DBA Data[Home] [Help]

APPS.ASP_ORDER_ALERT_AGENT dependencies on WF_CORE

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

235:
236:
237: EXCEPTION
238: When no_data_found Then
239: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
240: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
241: wf_core.token('ORA_ERROR',l_debug_msg);
242: wf_core.raise('WF_ORA');
243:

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

237: EXCEPTION
238: When no_data_found Then
239: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
240: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
241: wf_core.token('ORA_ERROR',l_debug_msg);
242: wf_core.raise('WF_ORA');
243:
244: When others Then
245: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

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

238: When no_data_found Then
239: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
240: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
241: wf_core.token('ORA_ERROR',l_debug_msg);
242: wf_core.raise('WF_ORA');
243:
244: When others 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||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);

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

241: wf_core.token('ORA_ERROR',l_debug_msg);
242: wf_core.raise('WF_ORA');
243:
244: When others 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||':OTHERS:'||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:
244: When others 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||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
247: wf_core.token('ORA_ERROR',l_debug_msg);
248: wf_core.raise('WF_ORA');
249:
250: END Evaluate_Alerts;
251:

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

244: When others 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||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
247: wf_core.token('ORA_ERROR',l_debug_msg);
248: wf_core.raise('WF_ORA');
249:
250: END Evaluate_Alerts;
251:
252: End ASP_ORDER_ALERT_AGENT;