DBA Data[Home] [Help]

APPS.ASP_SERVICE_ALERT_AGENT dependencies on WF_CORE

Line 232: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

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:

Line 234: wf_core.token('ORA_ERROR',l_debug_msg);

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);

Line 235: wf_core.raise('WF_ORA');

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);

Line 238: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

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:

Line 240: wf_core.token('ORA_ERROR',l_debug_msg);

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:

Line 241: wf_core.raise('WF_ORA');

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;