228:
229:
230: EXCEPTION
231: When no_data_found Then
232: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
233: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
234: wf_core.token('ORA_ERROR',l_debug_msg);
235: wf_core.raise('WF_ORA');
236:
230: EXCEPTION
231: When no_data_found Then
232: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
233: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
234: wf_core.token('ORA_ERROR',l_debug_msg);
235: wf_core.raise('WF_ORA');
236:
237: When others Then
238: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
231: When no_data_found Then
232: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
233: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
234: wf_core.token('ORA_ERROR',l_debug_msg);
235: wf_core.raise('WF_ORA');
236:
237: When others Then
238: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
239: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
234: wf_core.token('ORA_ERROR',l_debug_msg);
235: wf_core.raise('WF_ORA');
236:
237: When others Then
238: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
239: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
240: wf_core.token('ORA_ERROR',l_debug_msg);
241: wf_core.raise('WF_ORA');
242:
236:
237: When others Then
238: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
239: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
240: wf_core.token('ORA_ERROR',l_debug_msg);
241: wf_core.raise('WF_ORA');
242:
243: END Evaluate_Alerts;
244:
237: When others Then
238: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
239: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
240: wf_core.token('ORA_ERROR',l_debug_msg);
241: wf_core.raise('WF_ORA');
242:
243: END Evaluate_Alerts;
244:
245: End ASP_SERVICE_ALERT_AGENT;