DBA Data[Home] [Help]

APPS.ASP_INVOICE_ALERT_AGENT dependencies on WF_CORE

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

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:

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

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

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

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

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

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:

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

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:

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

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;