eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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: