WHEN OTHERS THEN
RAISE_APPLICATION_ERROR (-20006, SQLERRM);
But I am not able to figure out what is causing this error. What does this "line 5328 ORA-06512: at line 5" in the error message indicate?. My package body has only 600 lines. And why is the error message not displaying the procedure name? though I have defined the procedure name in the exception.
What is the best way to get the procedure name in the error message? So that it becomes easier for identifying which procedure is causing the erro?
Typically an exception from within WF_NOTIFICATION package is caused when you have defined a PLSQL or PLSQLCLOB document type message attribute to generate the notification message body. Any uncaught exceptions from within your PLSQL Document API is raised to the notification details page.
Please use only RAISE; within "WHEN OTHERS THEN" after setting the context. Also, please check if your PLSQL Document API is right?