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_COLL_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 313: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));

309: BEGIN
310: l_result := DBMS_XMLQUERY.getXML(ctx);
311: DBMS_XMLQUERY.closeContext(ctx);
312: l_rows_processed := 1;
313: FND_FILE.put_line( FND_FILE.LOG,'l_res_len-->'||dbms_lob.getlength(l_result));
314: --FND_FILE.put_line( FND_FILE.LOG,'l_res-->'||l_result);
315: EXCEPTION
316: WHEN OTHERS THEN
317: DBMS_XMLQUERY.getExceptionContent(ctx,l_errNo,l_errMsg);

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

324: IF l_rows_processed <> 0 THEN
325: -- FND_FILE.put_line( FND_FILE.LOG,'8') ;
326:
327: --get the length of the rowset header
328: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
329: FND_FILE.put_line( FND_FILE.LOG,'l_res_off-->'||l_resultOffset) ;
330: ELSE
331: l_resultOffset := 0;
332: END IF;

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

365: l_xml_header := l_xml_header ||l_new_line||' ' ||TO_CHAR(l_sysdate,'YYYY-MM-DD')||'';
366: l_xml_header := l_xml_header ||l_new_line||' ' ||l_rows_processed||'';
367: l_xml_header := l_xml_header ||l_new_line||' ';
368: l_close_tag := l_new_line||''||l_new_line;
369: l_xml_header_length := dbms_lob.getlength(l_xml_header);
370: tempResult :=l_xml_header;
371: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);
372: IF l_rows_processed <> 0 THEN
373: --copy result set to tempResult

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

370: tempResult :=l_xml_header;
371: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes0-->'||tempResult);
372: IF l_rows_processed <> 0 THEN
373: --copy result set to tempResult
374: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
375: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
376: ELSE
377:
378: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);

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

374: dbms_lob.copy(tempResult,l_result,dbms_lob.getlength(l_result)-l_resultOffset, l_xml_header_length,l_resultOffset);
375: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
376: ELSE
377:
378: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
379: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
380: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
381: END IF;
382: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);

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

375: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes1-->'||tempResult);
376: ELSE
377:
378: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
379: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
380: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
381: END IF;
382: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);
383: --append the close tag to tempResult

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

376: ELSE
377:
378: dbms_lob.createtemporary(tempResult,FALSE,DBMS_LOB.CALL);
379: dbms_lob.open(tempResult,dbms_lob.lob_readwrite);
380: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
381: END IF;
382: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);
383: --append the close tag to tempResult
384: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);

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

380: dbms_lob.writeAppend(tempResult, LENGTH(l_xml_header), l_xml_header);
381: END IF;
382: FND_FILE.put_line( FND_FILE.LOG,'5.base_curr'||g_base_curr);
383: --append the close tag to tempResult
384: dbms_lob.writeAppend(tempResult, LENGTH(l_close_tag), l_close_tag);
385: -- FND_FILE.put_line( FND_FILE.LOG,'tempRes2-->'||tempResult);
386: --print to the o/p file
387: print_clob(lob_loc => tempResult);
388: FND_FILE.put_line( FND_FILE.LOG,'15--end') ;