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.IEX_STRATEGY_DIAG_REPORT dependencies on FND_FILE

Line 56: --FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);

52: BEGIN
53: -- LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
54: LOOP
55: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );
56: --FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
57: IF (NVL (l_end, 0) < 1) THEN
58: EXIT;
59: END IF;
60: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );

Line 61: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);

57: IF (NVL (l_end, 0) < 1) THEN
58: EXIT;
59: END IF;
60: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
61: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
62: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
63: l_start := l_end + c_endline_len;
64: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
65: --FND_FILE.put_line( FND_FILE.LOG,'32');

Line 62: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);

58: EXIT;
59: END IF;
60: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
61: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
62: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
63: l_start := l_end + c_endline_len;
64: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
65: --FND_FILE.put_line( FND_FILE.LOG,'32');
66: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

Line 64: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);

60: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
61: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
62: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
63: l_start := l_end + c_endline_len;
64: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
65: --FND_FILE.put_line( FND_FILE.LOG,'32');
66: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
67: END LOOP;
68: END PRINT_CLOB;

Line 65: --FND_FILE.put_line( FND_FILE.LOG,'32');

61: --FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
62: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
63: l_start := l_end + c_endline_len;
64: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
65: --FND_FILE.put_line( FND_FILE.LOG,'32');
66: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
67: END LOOP;
68: END PRINT_CLOB;
69:

Line 66: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);

62: --FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
63: l_start := l_end + c_endline_len;
64: --FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);
65: --FND_FILE.put_line( FND_FILE.LOG,'32');
66: Fnd_File.PUT_line(Fnd_File.OUTPUT,l_one_line);
67: END LOOP;
68: END PRINT_CLOB;
69:
70:

Line 157: fnd_file.put_line(FND_FILE.LOG, 'In get_resource raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);

153: writelog('In get_resource raised Exception l_resource_name: ' || l_resource_name);
154: EXCEPTION
155: WHEN OTHERS THEN
156: writelog('In get_resource raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
157: fnd_file.put_line(FND_FILE.LOG, 'In get_resource raised Exception ' || ' sqlcode = ' || sqlcode || ' sqlerrm = ' || sqlerrm);
158: end get_resource;
159:
160: Procedure gen_xml_header_data_strategy
161: is

Line 192: FND_FILE.put_line( FND_FILE.LOG,'XML header data generation starts');

188: where resource_id = p_resource_id;
189:
190: begin
191: writelog('Begin gen_xml_header_data_strategy');
192: FND_FILE.put_line( FND_FILE.LOG,'XML header data generation starts');
193:
194: select to_char(sysdate, 'YYYY-MM-DD')
195: into l_report_date
196: from dual;

Line 267: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

263: writelog('End gen_xml_header_data_strategy');
264:
265: EXCEPTION
266: WHEN OTHERS THEN
267: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
268: RAISE;
269: END gen_xml_header_data_strategy;
270:
271:

Line 477: FND_FILE.put_line( FND_FILE.LOG,'creation_date'||l_creation_date);

473: l_strategy_name := format_string(l_strategy_name);
474: l_creation_date := format_string(TO_CHAR(p_strategy_rec.creation_date,'YYYY-MM-DD'));
475: l_new_strategy_name := format_string(l_new_strategy_name);
476: writelog('gen_xml_body_strategy, after format_string');
477: FND_FILE.put_line( FND_FILE.LOG,'creation_date'||l_creation_date);
478:
479: --l_xml_body := l_xml_body ||l_new_line||'';
480: l_xml_body := l_xml_body ||l_new_line||'<'|| p_strategy_status||' num="' || l_seq_no || '">';
481: l_xml_body := l_xml_body ||l_new_line||' ' || l_party_id || '';

Line 518: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

514: writelog('End gen_xml_body_strategy');
515:
516: EXCEPTION
517: WHEN OTHERS THEN
518: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
519: writelog('in gen_xml_body_strategy, err: '||sqlerrm);
520: RAISE;
521: END gen_xml_body_strategy;
522:

Line 530: FND_FILE.put_line( FND_FILE.LOG,'XML append close tag generation starts');

526: l_close_tag VARCHAR2(4000);
527:
528: begin
529: writelog('Begin gen_xml_append_closetag_sty');
530: FND_FILE.put_line( FND_FILE.LOG,'XML append close tag generation starts');
531:
532: l_close_tag := l_new_line||'';
533: /* l_close_tag := l_close_tag ||l_new_line||'' || l_no_closed_rec || '';
534: l_close_tag := l_close_tag ||l_new_line||'' || l_no_reopen_rec || '';

Line 540: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');

536: l_close_tag := l_close_tag ||l_new_line||'' || l_no_new_rec || ''; */
537: l_close_tag := l_close_tag ||l_new_line||''||l_new_line;
538:
539: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
540: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
541: --Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
542: print_clob(lob_loc => tempResult);
543: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
544: writelog('End gen_xml_append_closetag_sty');

Line 541: --Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);

537: l_close_tag := l_close_tag ||l_new_line||''||l_new_line;
538:
539: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
540: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
541: --Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
542: print_clob(lob_loc => tempResult);
543: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
544: writelog('End gen_xml_append_closetag_sty');
545:

Line 543: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');

539: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);
540: FND_FILE.put_line( FND_FILE.LOG,'Appended close tag to XML data');
541: --Fnd_File.PUT_line(Fnd_File.OUTPUT,tempResult);
542: print_clob(lob_loc => tempResult);
543: FND_FILE.put_line( FND_FILE.LOG,'XML generation is success');
544: writelog('End gen_xml_append_closetag_sty');
545:
546: EXCEPTION
547: WHEN OTHERS THEN

Line 548: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

544: writelog('End gen_xml_append_closetag_sty');
545:
546: EXCEPTION
547: WHEN OTHERS THEN
548: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
549: RAISE;
550: END gen_xml_append_closetag_sty;
551:
552: PROCEDURE gen_xml_corpt_str_list

Line 709: FND_FILE.put_line( FND_FILE.LOG,'XML append corrupted strategy list starts');

705: WHERE strategy_id = p_strategy_id;
706:
707: BEGIN
708: writelog('Begin gen_xml_corpt_str_list');
709: FND_FILE.put_line( FND_FILE.LOG,'XML append corrupted strategy list starts');
710:
711: FOR i in c_str_without_wf
712: LOOP
713:

Line 812: FND_FILE.put_line( FND_FILE.LOG,'XML append corrupted strategy list end');

808:
809:
810:
811: writelog('End gen_xml_corpt_str_list');
812: FND_FILE.put_line( FND_FILE.LOG,'XML append corrupted strategy list end');
813: EXCEPTION
814: WHEN OTHERS THEN
815: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
816: RAISE;

Line 815: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);

811: writelog('End gen_xml_corpt_str_list');
812: FND_FILE.put_line( FND_FILE.LOG,'XML append corrupted strategy list end');
813: EXCEPTION
814: WHEN OTHERS THEN
815: FND_FILE.put_line( FND_FILE.LOG,'err'||sqlerrm);
816: RAISE;
817: END gen_xml_corpt_str_list;
818:
819: PROCEDURE gen_xml_body_wi (p_work_item_temp_id NUMBER , p_wi_temp_status VARCHAR2)