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 225: dbms_lob.createtemporary(g_last_rc_appl_report, FALSE, DBMS_LOB.CALL);

221: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
222: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
223:
224: /* init report clob */
225: dbms_lob.createtemporary(g_last_rc_appl_report, FALSE, DBMS_LOB.CALL);
226: dbms_lob.open(g_last_rc_appl_report, dbms_lob.lob_readwrite);
227:
228: l_new_line := '
229: ';

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

222: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
223:
224: /* init report clob */
225: dbms_lob.createtemporary(g_last_rc_appl_report, FALSE, DBMS_LOB.CALL);
226: dbms_lob.open(g_last_rc_appl_report, dbms_lob.lob_readwrite);
227:
228: l_new_line := '
229: ';
230: l_header := '' || l_new_line || '';

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

317: l_parameters := l_parameters || l_new_line || '' || l_new_line || '' || l_new_line;
318: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_parameters: ' || l_parameters);
319:
320: /* add header to report */
321: DBMS_LOB.write(g_last_rc_appl_report, length(l_header), 1, l_header);
322: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to report');
323:
324: /* add parameters to report */
325: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_parameters), l_parameters);

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

321: DBMS_LOB.write(g_last_rc_appl_report, length(l_header), 1, l_header);
322: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to report');
323:
324: /* add parameters to report */
325: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_parameters), l_parameters);
326: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
327:
328: /* add all statements to report */
329: if dbms_lob.getlength(g_last_all_appl_stmt) > 0 then

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

325: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_parameters), l_parameters);
326: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
327:
328: /* add all statements to report */
329: if dbms_lob.getlength(g_last_all_appl_stmt) > 0 then
330: DBMS_LOB.Append(g_last_rc_appl_report, g_last_all_appl_stmt);
331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
332: end if;
333:

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

326: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
327:
328: /* add all statements to report */
329: if dbms_lob.getlength(g_last_all_appl_stmt) > 0 then
330: DBMS_LOB.Append(g_last_rc_appl_report, g_last_all_appl_stmt);
331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
332: end if;
333:
334: /* add footer to report */

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

331: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
332: end if;
333:
334: /* add footer to report */
335: dbms_lob.writeAppend(g_last_rc_appl_report, length(l_footer), l_footer);
336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to report');
337:
338: /* print report to output file */
339: LNS_REP_UTILS.PRINT_CLOB(g_last_rc_appl_report);

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

398: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
399: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
400:
401: /* init statement clob */
402: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
403: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
404:
405: l_new_line := '
406: ';

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

399: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
400:
401: /* init statement clob */
402: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
403: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
404:
405: l_new_line := '
406: ';
407: if P_OPEN_CLOSE_FLAG = 'OPEN' then

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

417: l_data := l_new_line || '';
418: end if;
419:
420: /* add header to stmt */
421: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);
422: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added loan to stmt');
423:
424: /* add statements to all statement */
425: if dbms_lob.getlength(l_statement_xml) > 0 then

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

421: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);
422: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added loan to stmt');
423:
424: /* add statements to all statement */
425: if dbms_lob.getlength(l_statement_xml) > 0 then
426: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
427: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt to all statement');
428: end if;
429:

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

422: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added loan to stmt');
423:
424: /* add statements to all statement */
425: if dbms_lob.getlength(l_statement_xml) > 0 then
426: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
427: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt to all statement');
428: end if;
429:
430: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

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

487: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
488: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
489:
490: /* init statement clob */
491: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
492: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
493:
494: l_new_line := '
495: ';

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

488: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
489:
490: /* init statement clob */
491: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
492: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
493:
494: l_new_line := '
495: ';
496: if P_ACTION_FLAG = 'APPLY' then

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

507: end if;
508: end if;
509:
510: /* add header to stmt */
511: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);
512: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt');
513:
514: /* add statements to all statement */
515: if dbms_lob.getlength(l_statement_xml) > 0 then

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

511: DBMS_LOB.write(l_statement_xml, length(l_data), 1, l_data);
512: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt');
513:
514: /* add statements to all statement */
515: if dbms_lob.getlength(l_statement_xml) > 0 then
516: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
517: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt to all statement');
518: end if;
519:

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

512: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt');
513:
514: /* add statements to all statement */
515: if dbms_lob.getlength(l_statement_xml) > 0 then
516: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
517: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added stmt to all statement');
518: end if;
519:
520: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

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

584: LogMessage(FND_LOG.LEVEL_STATEMENT, ' ');
585: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
586:
587: /* init statement clob */
588: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
589: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
590:
591: l_new_line := '
592: ';

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

585: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
586:
587: /* init statement clob */
588: dbms_lob.createtemporary(l_statement_xml, FALSE, DBMS_LOB.CALL);
589: dbms_lob.open(l_statement_xml, dbms_lob.lob_readwrite);
590:
591: l_new_line := '
592: ';
593: if P_ACTION = 'APPLY' then

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

676: l_application := l_application || l_new_line || '' || P_ERROR ||'';
677: -- LogMessage(FND_LOG.LEVEL_STATEMENT, 'Step4');
678:
679: /* add header to stmt */
680: DBMS_LOB.write(l_statement_xml, length(l_header), 1, l_header);
681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to stmt');
682:
683: /* add data to stmt */
684: dbms_lob.writeAppend(l_statement_xml, length(l_application), l_application);

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

680: DBMS_LOB.write(l_statement_xml, length(l_header), 1, l_header);
681: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to stmt');
682:
683: /* add data to stmt */
684: dbms_lob.writeAppend(l_statement_xml, length(l_application), l_application);
685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added data to stmt');
686:
687: /* add footer to stmt */
688: dbms_lob.writeAppend(l_statement_xml, length(l_footer), l_footer);

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

684: dbms_lob.writeAppend(l_statement_xml, length(l_application), l_application);
685: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added data to stmt');
686:
687: /* add footer to stmt */
688: dbms_lob.writeAppend(l_statement_xml, length(l_footer), l_footer);
689: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to stmt');
690:
691: /* add statements to all statement */
692: if dbms_lob.getlength(l_statement_xml) > 0 then

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

688: dbms_lob.writeAppend(l_statement_xml, length(l_footer), l_footer);
689: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to stmt');
690:
691: /* add statements to all statement */
692: if dbms_lob.getlength(l_statement_xml) > 0 then
693: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
694: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statement to all statement');
695: end if;
696:

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

689: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to stmt');
690:
691: /* add statements to all statement */
692: if dbms_lob.getlength(l_statement_xml) > 0 then
693: DBMS_LOB.Append(g_last_all_appl_stmt, l_statement_xml);
694: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statement to all statement');
695: end if;
696:
697: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

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

1921:
1922: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Searching for loan to pay...');
1923:
1924: /* init all statement clob */
1925: dbms_lob.createtemporary(g_last_all_appl_stmt, FALSE, DBMS_LOB.CALL);
1926: dbms_lob.open(g_last_all_appl_stmt, dbms_lob.lob_readwrite);
1927:
1928: l_Count := 0;
1929: 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 1926: dbms_lob.open(g_last_all_appl_stmt, dbms_lob.lob_readwrite);

1922: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Searching for loan to pay...');
1923:
1924: /* init all statement clob */
1925: dbms_lob.createtemporary(g_last_all_appl_stmt, FALSE, DBMS_LOB.CALL);
1926: dbms_lob.open(g_last_all_appl_stmt, dbms_lob.lob_readwrite);
1927:
1928: l_Count := 0;
1929: 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);
1930: LOOP