302: p_error_text in varchar2)
303: is
304: l_error_text varchar2(32000);
305: begin
306: l_error_text := p_error_text || g_newline || dbms_utility.format_error_stack();
307:
308: raise_application_error(p_error_code, l_error_text);
309:
310: exception
314: -- user as the main cause of the exception. Rest of the exception is
315: -- basically the call stack trace.
316: --
317: if (g_exception_depth = 0) then
318: g_error_message := dbms_utility.format_error_stack();
319: end if;
320:
321: g_exception_depth := g_exception_depth + 1;
322:
1408: p_send_date => Sysdate);
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: l_bes_message := 'Workflow: Business Event System raised exception.' ||
1412: g_newline || dbms_utility.format_error_stack();
1413: END;
1414:
1415: /*
1416: Release the lock of this program instance.
1453: --
1454: -- Add the error message stack
1455: --
1456: l_message := l_message || '----- Error Message Stack -----' || g_newline;
1457: l_message := l_message || dbms_utility.format_error_stack();
1458:
1459: --
1460: -- Return FAILURE
1461: --