DBA Data[Home] [Help]

APPS.ASP_ALERT_ENGINE dependencies on WF_CORE

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

127: return;
128:
129: EXCEPTION
130: When no_data_found Then
131: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
132: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
133: wf_core.token('ORA_ERROR',l_debug_msg);
134: wf_core.raise('WF_ORA');
135:

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

129: EXCEPTION
130: When no_data_found Then
131: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
132: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
133: wf_core.token('ORA_ERROR',l_debug_msg);
134: wf_core.raise('WF_ORA');
135:
136: When others Then
137: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

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

130: When no_data_found Then
131: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
132: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
133: wf_core.token('ORA_ERROR',l_debug_msg);
134: wf_core.raise('WF_ORA');
135:
136: When others Then
137: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
138: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);

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

133: wf_core.token('ORA_ERROR',l_debug_msg);
134: wf_core.raise('WF_ORA');
135:
136: When others Then
137: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
138: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
139: wf_core.token('ORA_ERROR',l_debug_msg);
140: wf_core.raise('WF_ORA');
141:

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

135:
136: When others Then
137: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
138: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
139: wf_core.token('ORA_ERROR',l_debug_msg);
140: wf_core.raise('WF_ORA');
141:
142: END Get_Alert_Agent;
143:

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

136: When others Then
137: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
138: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
139: wf_core.token('ORA_ERROR',l_debug_msg);
140: wf_core.raise('WF_ORA');
141:
142: END Get_Alert_Agent;
143:
144:

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

201: return;
202:
203: EXCEPTION
204: When no_data_found Then
205: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
206: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
207: wf_core.token('ORA_ERROR',l_debug_msg);
208: wf_core.raise('WF_ORA');
209:

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

203: EXCEPTION
204: When no_data_found Then
205: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
206: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
207: wf_core.token('ORA_ERROR',l_debug_msg);
208: wf_core.raise('WF_ORA');
209:
210: When others Then
211: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

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

204: When no_data_found Then
205: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
206: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
207: wf_core.token('ORA_ERROR',l_debug_msg);
208: wf_core.raise('WF_ORA');
209:
210: When others 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||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);

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

207: wf_core.token('ORA_ERROR',l_debug_msg);
208: wf_core.raise('WF_ORA');
209:
210: When others 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||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
213: wf_core.token('ORA_ERROR',l_debug_msg);
214: wf_core.raise('WF_ORA');
215:

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

209:
210: When others 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||':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: END Get_Content_Provider;
217:

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

210: When others 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||':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: END Get_Content_Provider;
217:
218:

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

292: return;
293:
294: EXCEPTION
295: When no_data_found Then
296: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
297: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
298: wf_core.token('ORA_ERROR',l_debug_msg);
299: wf_core.raise('WF_ORA');
300:

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

294: EXCEPTION
295: When no_data_found Then
296: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
297: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
298: wf_core.token('ORA_ERROR',l_debug_msg);
299: wf_core.raise('WF_ORA');
300:
301: When others Then
302: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);

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

295: When no_data_found Then
296: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
297: l_debug_msg := l_qualified_api_name||':NO_DATA_FOUND:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
298: wf_core.token('ORA_ERROR',l_debug_msg);
299: wf_core.raise('WF_ORA');
300:
301: When others Then
302: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
303: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);

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

298: wf_core.token('ORA_ERROR',l_debug_msg);
299: wf_core.raise('WF_ORA');
300:
301: When others Then
302: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
303: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
304: wf_core.token('ORA_ERROR',l_debug_msg);
305: wf_core.raise('WF_ORA');
306:

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

300:
301: When others Then
302: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
303: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
304: wf_core.token('ORA_ERROR',l_debug_msg);
305: wf_core.raise('WF_ORA');
306:
307: END Get_Delivery_Agent;
308:

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

301: When others Then
302: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, to_char(actid), funcmode);
303: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
304: wf_core.token('ORA_ERROR',l_debug_msg);
305: wf_core.raise('WF_ORA');
306:
307: END Get_Delivery_Agent;
308:
309:

Line 339: Wf_Core.Context(G_PKG_NAME, 'Noop', l_api_name, itemkey, to_char(actid), funcmode);

335:
336: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
337: EXCEPTION
338: When others Then
339: Wf_Core.Context(G_PKG_NAME, 'Noop', l_api_name, itemkey, to_char(actid), funcmode);
340: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
341: wf_core.token('ORA_ERROR',l_debug_msg);
342: wf_core.raise('WF_ORA');
343: END NOOP;

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

337: EXCEPTION
338: When others Then
339: Wf_Core.Context(G_PKG_NAME, 'Noop', l_api_name, itemkey, to_char(actid), funcmode);
340: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
341: wf_core.token('ORA_ERROR',l_debug_msg);
342: wf_core.raise('WF_ORA');
343: END NOOP;
344:
345: ------------------------------------------------------------------------------

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

338: When others Then
339: Wf_Core.Context(G_PKG_NAME, 'Noop', l_api_name, itemkey, to_char(actid), funcmode);
340: l_debug_msg := l_qualified_api_name||':OTHERS:'||to_char(SQLCODE)||':'||substr(SQLERRM,1,500);
341: wf_core.token('ORA_ERROR',l_debug_msg);
342: wf_core.raise('WF_ORA');
343: END NOOP;
344:
345: ------------------------------------------------------------------------------
346: -- Alerts_Selector

Line 440: WF_CORE.Context('ASP_ALERT_ENGINE', 'Alerts_Selector',

436: END IF;
437:
438: EXCEPTION
439: WHEN OTHERS THEN
440: WF_CORE.Context('ASP_ALERT_ENGINE', 'Alerts_Selector',
441: itemtype, itemkey, actid, funcmode);
442: RAISE;
443: END Alerts_Selector;
444: