207:
208:
209: EXCEPTION
210: When no_data_found Then
211: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
212: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
213: wf_core.token('ORA_ERROR',l_debug_msg);
214: wf_core.raise('WF_ORA');
215:
209: EXCEPTION
210: When no_data_found Then
211: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
212: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
213: wf_core.token('ORA_ERROR',l_debug_msg);
214: wf_core.raise('WF_ORA');
215:
216: When others Then
217: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
210: When no_data_found Then
211: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
212: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
213: wf_core.token('ORA_ERROR',l_debug_msg);
214: wf_core.raise('WF_ORA');
215:
216: When others Then
217: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
218: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
213: wf_core.token('ORA_ERROR',l_debug_msg);
214: wf_core.raise('WF_ORA');
215:
216: When others Then
217: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
218: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
219: wf_core.token('ORA_ERROR',l_debug_msg);
220: wf_core.raise('WF_ORA');
221:
215:
216: When others Then
217: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
218: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
219: wf_core.token('ORA_ERROR',l_debug_msg);
220: wf_core.raise('WF_ORA');
221:
222: END Create_Content;
223:
216: When others Then
217: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
218: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
219: wf_core.token('ORA_ERROR',l_debug_msg);
220: wf_core.raise('WF_ORA');
221:
222: END Create_Content;
223:
224: End ASP_ORDER_CONTENT_PROVIDER;