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.LNS_APPL_ENGINE_PUB dependencies on DBMS_LOB

Line 213: dbms_lob.createtemporary(g_last_rc_appl_report, FALSE, DBMS_LOB.CALL);

209: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
210: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
211:
212: /* init report clob */
213: dbms_lob.createtemporary(g_last_rc_appl_report, FALSE, DBMS_LOB.CALL);
214: dbms_lob.open(g_last_rc_appl_report, dbms_lob.lob_readwrite);
215:
216: l_new_line := '
217: ';

Line 214: dbms_lob.open(g_last_rc_appl_report, dbms_lob.lob_readwrite);

210: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
211:
212: /* init report clob */
213: dbms_lob.createtemporary(g_last_rc_appl_report, FALSE, DBMS_LOB.CALL);
214: dbms_lob.open(g_last_rc_appl_report, dbms_lob.lob_readwrite);
215:
216: l_new_line := '
217: ';
218: l_header := '' || l_new_line || '';

Line 284: DBMS_LOB.write(g_last_rc_appl_report, length(l_header), 1, l_header);

280: l_parameters := l_parameters || l_new_line || '' || l_new_line || '' || l_new_line;
281: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_parameters: ' || l_parameters);
282:
283: /* add header to report */
284: DBMS_LOB.write(g_last_rc_appl_report, length(l_header), 1, l_header);
285: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to report');
286:
287: /* add parameters to report */
288: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_parameters), l_parameters);

Line 288: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_parameters), l_parameters);

284: DBMS_LOB.write(g_last_rc_appl_report, length(l_header), 1, l_header);
285: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to report');
286:
287: /* add parameters to report */
288: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_parameters), l_parameters);
289: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
290:
291: /* add all statements to report */
292: if dbms_lob.getlength(g_last_all_appl_stmt) > 0 then

Line 292: if dbms_lob.getlength(g_last_all_appl_stmt) > 0 then

288: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_parameters), l_parameters);
289: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
290:
291: /* add all statements to report */
292: if dbms_lob.getlength(g_last_all_appl_stmt) > 0 then
293: DBMS_LOB.Append(g_last_rc_appl_report, g_last_all_appl_stmt);
294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
295: end if;
296:

Line 293: DBMS_LOB.Append(g_last_rc_appl_report, g_last_all_appl_stmt);

289: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
290:
291: /* add all statements to report */
292: if dbms_lob.getlength(g_last_all_appl_stmt) > 0 then
293: DBMS_LOB.Append(g_last_rc_appl_report, g_last_all_appl_stmt);
294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
295: end if;
296:
297: /* add footer to report */

Line 298: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_footer), l_footer);

294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
295: end if;
296:
297: /* add footer to report */
298: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_footer), l_footer);
299: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to report');
300:
301: /* print report to output file */
302: LNS_REP_UTILS.PRINT_CLOB(g_last_rc_appl_report);

Line 365: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);

361: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
362: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
363:
364: /* init statement clob */
365: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
366: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
367:
368: l_new_line := '
369: ';

Line 366: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);

362: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
363:
364: /* init statement clob */
365: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
366: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
367:
368: l_new_line := '
369: ';
370: if P_OPEN_CLOSE_FLAG = 'OPEN' then

Line 384: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);

380: l_data := l_new_line || '';
381: end if;
382:
383: /* add header to stmt */
384: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);
385: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added loan to stmt');
386:
387: /* add statements to all statement */
388: if dbms_lob.getlength(l_statement_xml) > 0 then

Line 388: if dbms_lob.getlength(l_statement_xml) > 0 then

384: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);
385: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added loan to stmt');
386:
387: /* add statements to all statement */
388: if dbms_lob.getlength(l_statement_xml) > 0 then
389: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
390: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt to all statement');
391: end if;
392:

Line 389: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);

385: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added loan to stmt');
386:
387: /* add statements to all statement */
388: if dbms_lob.getlength(l_statement_xml) > 0 then
389: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
390: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt to all statement');
391: end if;
392:
393: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 454: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);

450: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
451: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
452:
453: /* init statement clob */
454: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
455: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
456:
457: l_new_line := '
458: ';

Line 455: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);

451: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
452:
453: /* init statement clob */
454: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
455: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
456:
457: l_new_line := '
458: ';
459: if P_ACTION_FLAG = 'APPLY' then

Line 474: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);

470: end if;
471: end if;
472:
473: /* add header to stmt */
474: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);
475: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt');
476:
477: /* add statements to all statement */
478: if dbms_lob.getlength(l_statement_xml) > 0 then

Line 478: if dbms_lob.getlength(l_statement_xml) > 0 then

474: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);
475: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt');
476:
477: /* add statements to all statement */
478: if dbms_lob.getlength(l_statement_xml) > 0 then
479: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
480: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt to all statement');
481: end if;
482:

Line 479: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);

475: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt');
476:
477: /* add statements to all statement */
478: if dbms_lob.getlength(l_statement_xml) > 0 then
479: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
480: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt to all statement');
481: end if;
482:
483: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 551: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);

547: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
548: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
549:
550: /* init statement clob */
551: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
552: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
553:
554: l_new_line := '
555: ';

Line 552: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);

548: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
549:
550: /* init statement clob */
551: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
552: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
553:
554: l_new_line := '
555: ';
556: if P_ACTION = 'APPLY' then

Line 643: DBMS_LOB.write(l_statement_xml, length(l_header), 1, l_header);

639: l_application := l_application || l_new_line || '' || P_ERROR ||'';
640: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'Step4');
641:
642: /* add header to stmt */
643: DBMS_LOB.write(l_statement_xml, length(l_header), 1, l_header);
644: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to stmt');
645:
646: /* add data to stmt */
647: dbms_lob.writeAppend(l_statement_xml, length(l_application), l_application);

Line 647: dbms_lob.writeAppend(l_statement_xml, length(l_application), l_application);

643: DBMS_LOB.write(l_statement_xml, length(l_header), 1, l_header);
644: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to stmt');
645:
646: /* add data to stmt */
647: dbms_lob.writeAppend(l_statement_xml, length(l_application), l_application);
648: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added data to stmt');
649:
650: /* add footer to stmt */
651: dbms_lob.writeAppend(l_statement_xml, length(l_footer), l_footer);

Line 651: dbms_lob.writeAppend(l_statement_xml, length(l_footer), l_footer);

647: dbms_lob.writeAppend(l_statement_xml, length(l_application), l_application);
648: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added data to stmt');
649:
650: /* add footer to stmt */
651: dbms_lob.writeAppend(l_statement_xml, length(l_footer), l_footer);
652: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to stmt');
653:
654: /* add statements to all statement */
655: if dbms_lob.getlength(l_statement_xml) > 0 then

Line 655: if dbms_lob.getlength(l_statement_xml) > 0 then

651: dbms_lob.writeAppend(l_statement_xml, length(l_footer), l_footer);
652: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to stmt');
653:
654: /* add statements to all statement */
655: if dbms_lob.getlength(l_statement_xml) > 0 then
656: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
657: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statement to all statement');
658: end if;
659:

Line 656: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);

652: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to stmt');
653:
654: /* add statements to all statement */
655: if dbms_lob.getlength(l_statement_xml) > 0 then
656: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
657: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statement to all statement');
658: end if;
659:
660: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 1849: dbms_lob.createtemporary(g_last_all_appl_stmt, FALSE, DBMS_LOB.CALL);

1845:
1846: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Searching for loan to pay...');
1847:
1848: /* init all statement clob */
1849: dbms_lob.createtemporary(g_last_all_appl_stmt, FALSE, DBMS_LOB.CALL);
1850: dbms_lob.open(g_last_all_appl_stmt, dbms_lob.lob_readwrite);
1851:
1852: l_Count := 0;
1853: open loans_cur(P_SEARCH_REC.LOAN_BORROWER_ID, P_SEARCH_REC.LOAN_PRODUCT_ID, P_SEARCH_REC.LOAN_ID, P_SEARCH_REC.UNAPPLY_FLAG);

Line 1850: dbms_lob.open(g_last_all_appl_stmt, dbms_lob.lob_readwrite);

1846: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Searching for loan to pay...');
1847:
1848: /* init all statement clob */
1849: dbms_lob.createtemporary(g_last_all_appl_stmt, FALSE, DBMS_LOB.CALL);
1850: dbms_lob.open(g_last_all_appl_stmt, dbms_lob.lob_readwrite);
1851:
1852: l_Count := 0;
1853: open loans_cur(P_SEARCH_REC.LOAN_BORROWER_ID, P_SEARCH_REC.LOAN_PRODUCT_ID, P_SEARCH_REC.LOAN_ID, P_SEARCH_REC.UNAPPLY_FLAG);
1854: LOOP