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.

APPS.ALR_MLR_PACKAGE dependencies on WF_LOG_PKG

Line 185: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

181: found number;
182:
183: step varchar2(200);
184: begin
185: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
186: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
187: 'alr.plsql.ALR_MLR_PACKAGE.Response', 'BEGIN');
188: end if;
189: l_eventkey := p_event.GetEventKey();

Line 186: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

182:
183: step varchar2(200);
184: begin
185: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
186: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
187: 'alr.plsql.ALR_MLR_PACKAGE.Response', 'BEGIN');
188: end if;
189: l_eventkey := p_event.GetEventKey();
190: l_eventName := p_event.getEventName();

Line 195: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

191: l_paramList := p_event.getParameterList();
192: l_eventData := p_event.getEventData();
193:
194: -- parse the event key into the message handle
195: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
196: wf_log_pkg.string(WF_LOG_PKG.level_statement,
197: 'alr.plsql.ALR_MLR_PACKAGE.Response',
198: 'Parsing for the node and message handle');
199: end if;

Line 196: wf_log_pkg.string(WF_LOG_PKG.level_statement,

192: l_eventData := p_event.getEventData();
193:
194: -- parse the event key into the message handle
195: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
196: wf_log_pkg.string(WF_LOG_PKG.level_statement,
197: 'alr.plsql.ALR_MLR_PACKAGE.Response',
198: 'Parsing for the node and message handle');
199: end if;
200:

Line 214: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

210: msg_handle := TO_NUMBER(l_message_handle);
211: node_handle := TO_NUMBER(l_node_handle);
212: morcl_id := TO_NUMBER(l_morcl_id);
213:
214: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
215: wf_log_pkg.string(WF_LOG_PKG.level_statement,
216: 'alr.plsql.ALR_MLR_PACKAGE.Response',
217: 'Node ['||l_node_handle||'] Msg Handle ['||
218: l_message_handle||']');

Line 215: wf_log_pkg.string(WF_LOG_PKG.level_statement,

211: node_handle := TO_NUMBER(l_node_handle);
212: morcl_id := TO_NUMBER(l_morcl_id);
213:
214: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
215: wf_log_pkg.string(WF_LOG_PKG.level_statement,
216: 'alr.plsql.ALR_MLR_PACKAGE.Response',
217: 'Node ['||l_node_handle||'] Msg Handle ['||
218: l_message_handle||']');
219: end if;

Line 221: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

217: 'Node ['||l_node_handle||'] Msg Handle ['||
218: l_message_handle||']');
219: end if;
220: if l_eventName = 'oracle.apps.alr.response.receive' then
221: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
222: wf_log_pkg.string(WF_LOG_PKG.level_statement,
223: 'alr.plsql.ALR_MLR_PACKAGE.Response',
224: 'Getting response details');
225: end if;

Line 222: wf_log_pkg.string(WF_LOG_PKG.level_statement,

218: l_message_handle||']');
219: end if;
220: if l_eventName = 'oracle.apps.alr.response.receive' then
221: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
222: wf_log_pkg.string(WF_LOG_PKG.level_statement,
223: 'alr.plsql.ALR_MLR_PACKAGE.Response',
224: 'Getting response details');
225: end if;
226: WF_XML.getResponseDetails(message => l_eventData,

Line 231: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

227: node => l_node,
228: version => l_version,
229: fromRole => l_from,
230: responses => l_responses);
231: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
232: wf_log_pkg.string(WF_LOG_PKG.level_statement,
233: 'alr.plsql.ALR_MLR_PACKAGE.Response',
234: 'Got response details from ['||l_from||']');
235: end if;

Line 232: wf_log_pkg.string(WF_LOG_PKG.level_statement,

228: version => l_version,
229: fromRole => l_from,
230: responses => l_responses);
231: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
232: wf_log_pkg.string(WF_LOG_PKG.level_statement,
233: 'alr.plsql.ALR_MLR_PACKAGE.Response',
234: 'Got response details from ['||l_from||']');
235: end if;
236:

Line 240: if (wf_log_pkg.level_procedure >=

236:
237: step := 'Processing responses';
238: -- first check if invalid response
239: if (l_responses.COUNT = 0) then
240: if (wf_log_pkg.level_procedure >=
241: fnd_log.g_current_runtime_level) then
242: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
243: 'alr.plsql.ALR_MLR_PACKAGE.Response',
244: 'Invalid response (response count is zero).');

Line 242: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

238: -- first check if invalid response
239: if (l_responses.COUNT = 0) then
240: if (wf_log_pkg.level_procedure >=
241: fnd_log.g_current_runtime_level) then
242: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
243: 'alr.plsql.ALR_MLR_PACKAGE.Response',
244: 'Invalid response (response count is zero).');
245: end if;
246:

Line 252: if (wf_log_pkg.level_procedure >=

248: step := 'Getting messge details';
249: GetMessageDetails(msg_handle, node_handle,
250: alr_msg_dtls_tbl);
251:
252: if (wf_log_pkg.level_procedure >=
253: fnd_log.g_current_runtime_level) then
254: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
255: 'alr.plsql.ALR_MLR_PACKAGE.Response',
256: 'After get mesage details.');

Line 254: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

250: alr_msg_dtls_tbl);
251:
252: if (wf_log_pkg.level_procedure >=
253: fnd_log.g_current_runtime_level) then
254: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
255: 'alr.plsql.ALR_MLR_PACKAGE.Response',
256: 'After get mesage details.');
257: end if;
258:

Line 266: if (wf_log_pkg.level_procedure >=

262: l_from,
263: 'INVALID RESPONSE',
264: 0);
265:
266: if (wf_log_pkg.level_procedure >=
267: fnd_log.g_current_runtime_level) then
268: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
269: 'alr.plsql.ALR_MLR_PACKAGE.Response',
270: 'After saveresphist');

Line 268: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

264: 0);
265:
266: if (wf_log_pkg.level_procedure >=
267: fnd_log.g_current_runtime_level) then
268: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
269: 'alr.plsql.ALR_MLR_PACKAGE.Response',
270: 'After saveresphist');
271: end if;
272:

Line 280: if (wf_log_pkg.level_statement >=

276: argument2 => l_message_handle,
277: argument3 => l_morcl_id,
278: argument4 => 'I');
279: if (reqid = 0) then
280: if (wf_log_pkg.level_statement >=
281: fnd_log.g_current_runtime_level) then
282: wf_log_pkg.string(WF_LOG_PKG.level_statement,
283: 'alr.plsql.ALR_MLR_PACKAGE.Response',
284: 'The request ID retued 0. Raising -20160 app error');

Line 282: wf_log_pkg.string(WF_LOG_PKG.level_statement,

278: argument4 => 'I');
279: if (reqid = 0) then
280: if (wf_log_pkg.level_statement >=
281: fnd_log.g_current_runtime_level) then
282: wf_log_pkg.string(WF_LOG_PKG.level_statement,
283: 'alr.plsql.ALR_MLR_PACKAGE.Response',
284: 'The request ID retued 0. Raising -20160 app error');
285: end if;
286: raise_application_error(-20160, FND_MESSAGE.GET);

Line 289: if (wf_log_pkg.level_statement >=

285: end if;
286: raise_application_error(-20160, FND_MESSAGE.GET);
287: end if;
288:
289: if (wf_log_pkg.level_statement >=
290: fnd_log.g_current_runtime_level) then
291: wf_log_pkg.string(WF_LOG_PKG.level_statement,
292: 'alr.plsql.ALR_MLR_PACKAGE.Response',
293: 'Concurrent request ['||to_char(reqid)||'] submitted');

Line 291: wf_log_pkg.string(WF_LOG_PKG.level_statement,

287: end if;
288:
289: if (wf_log_pkg.level_statement >=
290: fnd_log.g_current_runtime_level) then
291: wf_log_pkg.string(WF_LOG_PKG.level_statement,
292: 'alr.plsql.ALR_MLR_PACKAGE.Response',
293: 'Concurrent request ['||to_char(reqid)||'] submitted');
294: end if;
295: else

Line 298: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

294: end if;
295: else
296: -- process valid responses
297: for tk in 1..l_responses.COUNT loop
298: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
299: wf_log_pkg.string(WF_LOG_PKG.level_statement,
300: 'alr.plsql.ALR_MLR_PACKAGE.Response',
301: 'Processing ['||l_responses(tk).name||
302: '] ['||l_responses(tk).value||']');

Line 299: wf_log_pkg.string(WF_LOG_PKG.level_statement,

295: else
296: -- process valid responses
297: for tk in 1..l_responses.COUNT loop
298: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
299: wf_log_pkg.string(WF_LOG_PKG.level_statement,
300: 'alr.plsql.ALR_MLR_PACKAGE.Response',
301: 'Processing ['||l_responses(tk).name||
302: '] ['||l_responses(tk).value||']');
303: end if;

Line 308: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

304:
305: -- Alert specific processing here
306: -- Check for open responses
307: count_var := OpenResponses;
308: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
309: wf_log_pkg.string(WF_LOG_PKG.level_statement,
310: 'alr.plsql.ALR_MLR_PACKAGE.Response',
311: 'Open responses ['||to_char(count_var)||']');
312: end if;

Line 309: wf_log_pkg.string(WF_LOG_PKG.level_statement,

305: -- Alert specific processing here
306: -- Check for open responses
307: count_var := OpenResponses;
308: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
309: wf_log_pkg.string(WF_LOG_PKG.level_statement,
310: 'alr.plsql.ALR_MLR_PACKAGE.Response',
311: 'Open responses ['||to_char(count_var)||']');
312: end if;
313:

Line 365: if (wf_log_pkg.level_procedure >=

361: msg_handle, node_handle,
362: alr_init_resp_tbl);
363:
364: -- CALL CONCURRENT PROGRAM TO PERFORM ACTIONS
365: if (wf_log_pkg.level_procedure >=
366: fnd_log.g_current_runtime_level) then
367: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
368: 'alr.plsql.ALR_MLR_PACKAGE.Response',
369: 'Submitting Action Processor');

Line 367: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

363:
364: -- CALL CONCURRENT PROGRAM TO PERFORM ACTIONS
365: if (wf_log_pkg.level_procedure >=
366: fnd_log.g_current_runtime_level) then
367: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
368: 'alr.plsql.ALR_MLR_PACKAGE.Response',
369: 'Submitting Action Processor');
370: end if;
371: reqid := fnd_request.submit_request(application => 'ALR',

Line 381: if (wf_log_pkg.level_statement >=

377: argument5 => l_responses(tk).name,
378: argument6 => l_responses(tk).value,
379: argument7 => l_responses(tk).format);
380: if reqid = 0 then
381: if (wf_log_pkg.level_statement >=
382: fnd_log.g_current_runtime_level) then
383: wf_log_pkg.string(WF_LOG_PKG.level_statement,
384: 'alr.plsql.ALR_MLR_PACKAGE.Response',
385: 'The request ID retued 0. Raising -20160 app error');

Line 383: wf_log_pkg.string(WF_LOG_PKG.level_statement,

379: argument7 => l_responses(tk).format);
380: if reqid = 0 then
381: if (wf_log_pkg.level_statement >=
382: fnd_log.g_current_runtime_level) then
383: wf_log_pkg.string(WF_LOG_PKG.level_statement,
384: 'alr.plsql.ALR_MLR_PACKAGE.Response',
385: 'The request ID retued 0. Raising -20160 app error');
386: end if;
387: raise_application_error(-20160, FND_MESSAGE.GET);

Line 418: if (wf_log_pkg.level_procedure >=

414: msg_handle, node_handle,
415: alr_init_resp_tbl);
416:
417: -- CALL CONCURRENT PROGRAM TO PERFORM ACTIONS
418: if (wf_log_pkg.level_procedure >=
419: fnd_log.g_current_runtime_level) then
420: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
421: 'alr.plsql.ALR_MLR_PACKAGE.Response',
422: 'Submitting Action Processor');

Line 420: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

416:
417: -- CALL CONCURRENT PROGRAM TO PERFORM ACTIONS
418: if (wf_log_pkg.level_procedure >=
419: fnd_log.g_current_runtime_level) then
420: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
421: 'alr.plsql.ALR_MLR_PACKAGE.Response',
422: 'Submitting Action Processor');
423: end if;
424: reqid := fnd_request.submit_request(application => 'ALR',

Line 434: if (wf_log_pkg.level_statement >=

430: argument5 => l_responses(tk).name,
431: argument6 => l_responses(tk).value,
432: argument7 => l_responses(tk).format);
433: if (reqid = 0) then
434: if (wf_log_pkg.level_statement >=
435: fnd_log.g_current_runtime_level) then
436: wf_log_pkg.string(WF_LOG_PKG.level_statement,
437: 'alr.plsql.ALR_MLR_PACKAGE.Response',
438: 'The request ID retued 0. Raising -20160 app error');

Line 436: wf_log_pkg.string(WF_LOG_PKG.level_statement,

432: argument7 => l_responses(tk).format);
433: if (reqid = 0) then
434: if (wf_log_pkg.level_statement >=
435: fnd_log.g_current_runtime_level) then
436: wf_log_pkg.string(WF_LOG_PKG.level_statement,
437: 'alr.plsql.ALR_MLR_PACKAGE.Response',
438: 'The request ID retued 0. Raising -20160 app error');
439: end if;
440: raise_application_error(-20160, FND_MESSAGE.GET);

Line 468: if (wf_log_pkg.level_procedure >=

464: l_responses(tk).value,
465: alr_init_resp_tbl);
466:
467: -- CALL CONCURRENT PROGRAM TO PERFORM ACTIONS
468: if (wf_log_pkg.level_procedure >=
469: fnd_log.g_current_runtime_level) then
470: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
471: 'alr.plsql.ALR_MLR_PACKAGE.Response',
472: 'Submitting Action Processor');

Line 470: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

466:
467: -- CALL CONCURRENT PROGRAM TO PERFORM ACTIONS
468: if (wf_log_pkg.level_procedure >=
469: fnd_log.g_current_runtime_level) then
470: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
471: 'alr.plsql.ALR_MLR_PACKAGE.Response',
472: 'Submitting Action Processor');
473: end if;
474: reqid := fnd_request.submit_request(application => 'ALR',

Line 484: if (wf_log_pkg.level_statement >=

480: argument5 => l_responses(tk).name,
481: argument6 => l_responses(tk).value,
482: argument7 => l_responses(tk).format);
483: if (reqid = 0) then
484: if (wf_log_pkg.level_statement >=
485: fnd_log.g_current_runtime_level) then
486: wf_log_pkg.string(WF_LOG_PKG.level_statement,
487: 'alr.plsql.ALR_MLR_PACKAGE.Response',
488: 'The request ID retued 0. Raising -20160 app error');

Line 486: wf_log_pkg.string(WF_LOG_PKG.level_statement,

482: argument7 => l_responses(tk).format);
483: if (reqid = 0) then
484: if (wf_log_pkg.level_statement >=
485: fnd_log.g_current_runtime_level) then
486: wf_log_pkg.string(WF_LOG_PKG.level_statement,
487: 'alr.plsql.ALR_MLR_PACKAGE.Response',
488: 'The request ID retued 0. Raising -20160 app error');
489: end if;
490: raise_application_error(-20160, FND_MESSAGE.GET);

Line 498: if (wf_log_pkg.level_procedure >=

494: end if;
495:
496: -- last case is invalid response
497: if (found=0) then
498: if (wf_log_pkg.level_procedure >=
499: fnd_log.g_current_runtime_level) then
500: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
501: 'alr.plsql.ALR_MLR_PACKAGE.Response',
502: 'Submitting Action Processor');

Line 500: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

496: -- last case is invalid response
497: if (found=0) then
498: if (wf_log_pkg.level_procedure >=
499: fnd_log.g_current_runtime_level) then
500: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
501: 'alr.plsql.ALR_MLR_PACKAGE.Response',
502: 'Submitting Action Processor');
503: end if;
504: reqid := fnd_request.submit_request(application => 'ALR',

Line 514: if (wf_log_pkg.level_statement >=

510: argument5 => l_responses(tk).name,
511: argument6 => l_responses(tk).value,
512: argument7 => l_responses(tk).format);
513: if (reqid = 0) then
514: if (wf_log_pkg.level_statement >=
515: fnd_log.g_current_runtime_level) then
516: wf_log_pkg.string(WF_LOG_PKG.level_statement,
517: 'alr.plsql.ALR_MLR_PACKAGE.Response',
518: 'The request ID retued 0. Raising -20160 app error');

Line 516: wf_log_pkg.string(WF_LOG_PKG.level_statement,

512: argument7 => l_responses(tk).format);
513: if (reqid = 0) then
514: if (wf_log_pkg.level_statement >=
515: fnd_log.g_current_runtime_level) then
516: wf_log_pkg.string(WF_LOG_PKG.level_statement,
517: 'alr.plsql.ALR_MLR_PACKAGE.Response',
518: 'The request ID retued 0. Raising -20160 app error');
519: end if;
520: raise_application_error(-20160, FND_MESSAGE.GET);

Line 532: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then

528: end loop;
529: end if;
530: end if;
531:
532: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
533: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
534: 'alr.plsql.ALR_MLR_PACKAGE.Response', 'END');
535: end if;
536:

Line 533: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

529: end if;
530: end if;
531:
532: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
533: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
534: 'alr.plsql.ALR_MLR_PACKAGE.Response', 'END');
535: end if;
536:
537: return 'SUCCESS';

Line 581: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then

577: node_handle= node_handle;
578:
579: exception
580: when no_data_found then
581: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
582: wf_log_pkg.string(WF_LOG_PKG.level_statement,
583: 'alr.plsql.ALR_MLR_PACKAGE.GetMessageDetails',
584: 'Error, message handle does not exist in db.');
585: end if;

Line 582: wf_log_pkg.string(WF_LOG_PKG.level_statement,

578:
579: exception
580: when no_data_found then
581: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
582: wf_log_pkg.string(WF_LOG_PKG.level_statement,
583: 'alr.plsql.ALR_MLR_PACKAGE.GetMessageDetails',
584: 'Error, message handle does not exist in db.');
585: end if;
586: wf_core.context('ALR_MLR_PKG', 'RESPONSE',

Line 866: if (wf_log_pkg.level_procedure >=

862: exception
863: when others then
864: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
865: 'Exception during SaveRespHistory');
866: if (wf_log_pkg.level_procedure >=
867: fnd_log.g_current_runtime_level) then
868: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
869: 'alr.plsql.ALR_MLR_PACKAGE.Response',
870: 'Exception in SaveRespHistory');

Line 868: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

864: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
865: 'Exception during SaveRespHistory');
866: if (wf_log_pkg.level_procedure >=
867: fnd_log.g_current_runtime_level) then
868: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
869: 'alr.plsql.ALR_MLR_PACKAGE.Response',
870: 'Exception in SaveRespHistory');
871: end if;
872: raise;

Line 1126: if (wf_log_pkg.level_statement >=

1122: argument5 => l_name,
1123: argument6 => input,
1124: argument7 => l_format);
1125: if reqid = 0 then
1126: if (wf_log_pkg.level_statement >=
1127: fnd_log.g_current_runtime_level) then
1128: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1129: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1130: 'The request ID retued 0. Raising -20160 app error');

Line 1128: wf_log_pkg.string(WF_LOG_PKG.level_statement,

1124: argument7 => l_format);
1125: if reqid = 0 then
1126: if (wf_log_pkg.level_statement >=
1127: fnd_log.g_current_runtime_level) then
1128: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1129: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1130: 'The request ID retued 0. Raising -20160 app error');
1131: end if;
1132: raise_application_error(-20160, FND_MESSAGE.GET);

Line 1170: if (wf_log_pkg.level_statement >=

1166: argument5 => l_name,
1167: argument6 => input,
1168: argument7 => l_format);
1169: if (reqid = 0) then
1170: if (wf_log_pkg.level_statement >=
1171: fnd_log.g_current_runtime_level) then
1172: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1173: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1174: 'The request ID retued 0. Raising -20160 app error');

Line 1172: wf_log_pkg.string(WF_LOG_PKG.level_statement,

1168: argument7 => l_format);
1169: if (reqid = 0) then
1170: if (wf_log_pkg.level_statement >=
1171: fnd_log.g_current_runtime_level) then
1172: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1173: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1174: 'The request ID retued 0. Raising -20160 app error');
1175: end if;
1176: raise_application_error(-20160, FND_MESSAGE.GET);

Line 1203: if (wf_log_pkg.level_procedure >=

1199: input,
1200: alr_init_resp_tbl);
1201:
1202: -- CALL CONCURRENT PROGRAM TO PERFORM ACTIONS
1203: if (wf_log_pkg.level_procedure >=
1204: fnd_log.g_current_runtime_level) then
1205: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
1206: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1207: 'Submitting Action Processor');

Line 1205: wf_log_pkg.string(WF_LOG_PKG.level_procedure,

1201:
1202: -- CALL CONCURRENT PROGRAM TO PERFORM ACTIONS
1203: if (wf_log_pkg.level_procedure >=
1204: fnd_log.g_current_runtime_level) then
1205: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
1206: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1207: 'Submitting Action Processor');
1208: end if;
1209: reqid := fnd_request.submit_request(application => 'ALR',

Line 1219: if (wf_log_pkg.level_statement >=

1215: argument5 => l_name,
1216: argument6 => input,
1217: argument7 => l_format);
1218: if (reqid = 0) then
1219: if (wf_log_pkg.level_statement >=
1220: fnd_log.g_current_runtime_level) then
1221: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1222: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1223: 'The request ID retued 0. Raising -20160 app error');

Line 1221: wf_log_pkg.string(WF_LOG_PKG.level_statement,

1217: argument7 => l_format);
1218: if (reqid = 0) then
1219: if (wf_log_pkg.level_statement >=
1220: fnd_log.g_current_runtime_level) then
1221: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1222: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1223: 'The request ID retued 0. Raising -20160 app error');
1224: end if;
1225: raise_application_error(-20160, FND_MESSAGE.GET);

Line 1243: if (wf_log_pkg.level_statement >=

1239: argument5 => l_name,
1240: argument6 => input,
1241: argument7 => l_format);
1242: if (reqid = 0) then
1243: if (wf_log_pkg.level_statement >=
1244: fnd_log.g_current_runtime_level) then
1245: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1246: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1247: 'The request ID retued 0. Raising -20160 app error');

Line 1245: wf_log_pkg.string(WF_LOG_PKG.level_statement,

1241: argument7 => l_format);
1242: if (reqid = 0) then
1243: if (wf_log_pkg.level_statement >=
1244: fnd_log.g_current_runtime_level) then
1245: wf_log_pkg.string(WF_LOG_PKG.level_statement,
1246: 'alr.plsql.ALR_MLR_PACKAGE.Response',
1247: 'The request ID retued 0. Raising -20160 app error');
1248: end if;
1249: raise_application_error(-20160, FND_MESSAGE.GET);