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 FND_LOG

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 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 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 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 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 241: fnd_log.g_current_runtime_level) then

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).');
245: end if;

Line 253: fnd_log.g_current_runtime_level) then

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.');
257: end if;

Line 267: fnd_log.g_current_runtime_level) then

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');
271: end if;

Line 281: fnd_log.g_current_runtime_level) then

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');
285: end if;

Line 290: fnd_log.g_current_runtime_level) then

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');
294: end if;

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 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 366: fnd_log.g_current_runtime_level) then

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');
370: end if;

Line 382: fnd_log.g_current_runtime_level) then

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');
386: end if;

Line 419: fnd_log.g_current_runtime_level) then

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');
423: end if;

Line 435: fnd_log.g_current_runtime_level) then

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');
439: end if;

Line 469: fnd_log.g_current_runtime_level) then

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');
473: end if;

Line 485: fnd_log.g_current_runtime_level) then

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');
489: end if;

Line 499: fnd_log.g_current_runtime_level) then

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');
503: end if;

Line 515: fnd_log.g_current_runtime_level) then

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');
519: end if;

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 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 867: fnd_log.g_current_runtime_level) then

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');
871: end if;

Line 1127: fnd_log.g_current_runtime_level) then

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');
1131: end if;

Line 1171: fnd_log.g_current_runtime_level) then

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');
1175: end if;

Line 1204: fnd_log.g_current_runtime_level) then

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');
1208: end if;

Line 1220: fnd_log.g_current_runtime_level) then

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');
1224: end if;

Line 1244: fnd_log.g_current_runtime_level) then

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');
1248: end if;