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_PAYMENT_CAMP_RPT_PKG dependencies on DBMS_LOB

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

43: +-----------------------------------------------------------------------*/
44: BEGIN
45: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
46: LOOP
47: l_end := DBMS_LOB.INSTR (lob_loc => lob_loc, pattern => c_endline, offset => l_start, nth => 1 );
48: FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
49: IF (NVL (l_end, 0) < 1) THEN
50: EXIT;
51: END IF;

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

48: FND_FILE.put_line( FND_FILE.LOG,'l_end-->'||l_end);
49: IF (NVL (l_end, 0) < 1) THEN
50: EXIT;
51: END IF;
52: l_one_line := DBMS_LOB.SUBSTR (lob_loc => lob_loc, amount => l_end - l_start, offset => l_start );
53: FND_FILE.put_line( FND_FILE.LOG,'l_one_line-->'||l_one_line);
54: FND_FILE.put_line( FND_FILE.LOG,'c_endline_len-->'||c_endline_len);
55: l_start := l_end + c_endline_len;
56: FND_FILE.put_line( FND_FILE.LOG,'l_start-->'||l_start);

Line 319: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));

315: BEGIN
316: l_result := DBMS_XMLQUERY.getXML(ctx);
317: DBMS_XMLQUERY.closeContext(ctx);
318: l_rows_processed := 1;
319: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
320: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
321: EXCEPTION
322: WHEN OTHERS THEN
323: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);

Line 334: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

330: IF l_rows_processed <> 0 THEN
331: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;
332:
333: --get the length of the rowset header
334: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
335: FND_FILE.put_line( FND_FILE.LOG,'l_res_off-->'||l_resultOffset) ;
336: ELSE
337: l_resultOffset := 0;
338: END IF;

Line 375: l_xml_header_length := dbms_lob.getlength(l_xml_header);

371: l_xml_header := l_xml_header ||l_new_line||' ' ||TO_CHAR(l_sysdate,'YYYY-MM-DD')||'';
372: l_xml_header := l_xml_header ||l_new_line||' ' ||l_rows_processed||'';
373: l_xml_header := l_xml_header ||l_new_line||' ';
374: l_close_tag := l_new_line||''||l_new_line;
375: l_xml_header_length := dbms_lob.getlength(l_xml_header);
376: tempResult :=l_xml_header;
377: FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);
378: IF l_rows_processed <> 0 THEN
379: --copy result set to tempResult

Line 380: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);

376: tempResult :=l_xml_header;
377: FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);
378: IF l_rows_processed <> 0 THEN
379: --copy result set to tempResult
380: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
381: -- FND_FILE.put_line( FND_FILE.LOG,'11') ;
382: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
383: ELSE
384: -- FND_FILE.put_line( FND_FILE.LOG,'12') ;

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

381: -- FND_FILE.put_line( FND_FILE.LOG,'11') ;
382: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
383: ELSE
384: -- FND_FILE.put_line( FND_FILE.LOG,'12') ;
385: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
386: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
387: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
388: END IF;
389:

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

382: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
383: ELSE
384: -- FND_FILE.put_line( FND_FILE.LOG,'12') ;
385: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
386: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
387: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
388: END IF;
389:
390: --append the close tag to tempResult

Line 387: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);

383: ELSE
384: -- FND_FILE.put_line( FND_FILE.LOG,'12') ;
385: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
386: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
387: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
388: END IF;
389:
390: --append the close tag to tempResult
391: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);

Line 391: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);

387: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
388: END IF;
389:
390: --append the close tag to tempResult
391: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
392: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes2-->'||tempResult);
393: --print to the o/p file
394: print_clob(lob_loc => tempResult);
395: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;