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 DBMS_LOB

Line 55: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );

51: +-----------------------------------------------------------------------*/
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;

Line 60: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );

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 );
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);

Line 259: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

255: l_xml_header_length := length(l_xml_header);
256: tempResult := l_xml_header;
257: writelog('Constructing the XML Header is success');
258:
259: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
260: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
261: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
262:
263: writelog('End gen_xml_header_data_strategy');

Line 260: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);

256: tempResult := l_xml_header;
257: writelog('Constructing the XML Header is success');
258:
259: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
260: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
261: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
262:
263: writelog('End gen_xml_header_data_strategy');
264:

Line 261: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);

257: writelog('Constructing the XML Header is success');
258:
259: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
260: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
261: dbms_lob.writeAppend(tempResult, length(l_xml_header), l_xml_header);
262:
263: writelog('End gen_xml_header_data_strategy');
264:
265: EXCEPTION

Line 501: dbms_lob.writeAppend(tempResult, length(l_xml_body), l_xml_body);

497: l_xml_body := l_xml_body ||l_new_line||'';
498:
499: writelog('gen_xml_body_strategy, end of constructing body text');
500:
501: dbms_lob.writeAppend(tempResult, length(l_xml_body), l_xml_body);
502: l_seq_no := l_seq_no + 1;
503:
504: /*if p_strategy_status = 'CLOSE' then
505: l_no_closed_rec := l_no_closed_rec + 1;

Line 539: dbms_lob.writeAppend(tempResult, length(l_close_tag), l_close_tag);

535: l_close_tag := l_close_tag ||l_new_line||'' || l_no_reassign_rec || '';
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');

Line 864: dbms_lob.writeAppend(tempResult, length(l_xml_body), l_xml_body);

860: l_xml_body := l_xml_body ||l_new_line||'';
861:
862: writelog('gen_xml_body_wi, end of constructing body text');
863:
864: dbms_lob.writeAppend(tempResult, length(l_xml_body), l_xml_body);
865: l_seq_no := l_seq_no + 1;
866: END gen_xml_body_wi;
867:
868:

Line 949: dbms_lob.writeAppend(tempResult, length(l_xml_body), l_xml_body);

945: l_xml_body := l_xml_body ||l_new_line||'';
946:
947: writelog('gen_xml_body_wi, end of constructing body text');
948:
949: dbms_lob.writeAppend(tempResult, length(l_xml_body), l_xml_body);
950: l_seq_no := l_seq_no + 1;
951: END gen_xml_body_auto_wi;
952:
953: PROCEDURE MAIN( ERRBUF OUT NOCOPY VARCHAR2,