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