Based on the business process if there is any undefined exeception occured while running concurrent program, we can end the concurrent program with Error/Warning.
Define ERRBUFF as the first parameter and Retcode as the second one. Mention the OUT variable type.
CREATE PROCEDURE PROCEDURE_NAME (errbuf OUT VARCHAR2,
retcode OUT VARCHAR2)
The retcode has three values returned by the concurrent manager
1–Success & warning
we can set the concurrent program to any of the three status by using these values in the retcode parameter
WHEN OTHERS THEN
FND_FILE.PUT_LINE(FND_FILE.LOG,’Unhandled exception occurred in package. ErrMsg: ‘||SQLERRM);
Even you can use fnd_concurrent.set_completion_Status to send the concurrent program to more status than success,error and warning.