238:
239:
240: EXCEPTION
241: When no_data_found Then
242: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
243: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
244: wf_core.token('ORA_ERROR',l_debug_msg);
245: wf_core.raise('WF_ORA');
246:
240: EXCEPTION
241: When no_data_found Then
242: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
243: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
244: wf_core.token('ORA_ERROR',l_debug_msg);
245: wf_core.raise('WF_ORA');
246:
247: When others Then
248: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
241: When no_data_found Then
242: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
243: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
244: wf_core.token('ORA_ERROR',l_debug_msg);
245: wf_core.raise('WF_ORA');
246:
247: When others Then
248: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
249: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
244: wf_core.token('ORA_ERROR',l_debug_msg);
245: wf_core.raise('WF_ORA');
246:
247: When others Then
248: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
249: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
250: wf_core.token('ORA_ERROR',l_debug_msg);
251: wf_core.raise('WF_ORA');
252:
246:
247: When others Then
248: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
249: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
250: wf_core.token('ORA_ERROR',l_debug_msg);
251: wf_core.raise('WF_ORA');
252:
253: END Evaluate_Alerts;
254:
247: When others Then
248: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
249: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
250: wf_core.token('ORA_ERROR',l_debug_msg);
251: wf_core.raise('WF_ORA');
252:
253: END Evaluate_Alerts;
254:
255: End ASP_INVOICE_ALERT_AGENT;