DBA Data[Home] [Help]

APPS.ASP_SVCCONTRACT_ALERT_AGENT dependencies on WF_CORE

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

241: return;
242:
243: EXCEPTION
244: When no_data_found Then
245: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
246: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
247: wf_core.token('ORA_ERROR',l_debug_msg);
248: wf_core.raise('WF_ORA');
249:

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

243: EXCEPTION
244: When no_data_found Then
245: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
246: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
247: wf_core.token('ORA_ERROR',l_debug_msg);
248: wf_core.raise('WF_ORA');
249:
250: When others Then
251: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

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

244: When no_data_found Then
245: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
246: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
247: wf_core.token('ORA_ERROR',l_debug_msg);
248: wf_core.raise('WF_ORA');
249:
250: When others Then
251: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
252: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);

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

247: wf_core.token('ORA_ERROR',l_debug_msg);
248: wf_core.raise('WF_ORA');
249:
250: When others Then
251: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
252: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
253: wf_core.token('ORA_ERROR',l_debug_msg);
254: wf_core.raise('WF_ORA');
255:

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

249:
250: When others Then
251: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
252: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
253: wf_core.token('ORA_ERROR',l_debug_msg);
254: wf_core.raise('WF_ORA');
255:
256: END Evaluate_Alerts;
257:

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

250: When others Then
251: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
252: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
253: wf_core.token('ORA_ERROR',l_debug_msg);
254: wf_core.raise('WF_ORA');
255:
256: END Evaluate_Alerts;
257:
258: End ASP_SVCCONTRACT_ALERT_AGENT;