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

Line 7970: dbms_lob.createtemporary(g_last_accrual_report, FALSE, DBMS_LOB.CALL);

7966: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, ' ');
7967: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
7968:
7969: /* init report clob */
7970: dbms_lob.createtemporary(g_last_accrual_report, FALSE, DBMS_LOB.CALL);
7971: dbms_lob.open(g_last_accrual_report, dbms_lob.lob_readwrite);
7972:
7973: l_new_line := '
7974: ';

Line 7971: dbms_lob.open(g_last_accrual_report, dbms_lob.lob_readwrite);

7967: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' +');
7968:
7969: /* init report clob */
7970: dbms_lob.createtemporary(g_last_accrual_report, FALSE, DBMS_LOB.CALL);
7971: dbms_lob.open(g_last_accrual_report, dbms_lob.lob_readwrite);
7972:
7973: l_new_line := '
7974: ';
7975: l_header := '' || l_new_line || '';

Line 8037: DBMS_LOB.write(g_last_accrual_report, length(l_header), 1, l_header);

8033: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_parameters: ' || l_parameters);
8034:
8035:
8036: /* add header to accrual report */
8037: DBMS_LOB.write(g_last_accrual_report, length(l_header), 1, l_header);
8038: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added header to report');
8039:
8040: /* add parameters to accrual report */
8041: dbms_lob.writeAppend(g_last_accrual_report, length(l_parameters), l_parameters);

Line 8041: dbms_lob.writeAppend(g_last_accrual_report, length(l_parameters), l_parameters);

8037: DBMS_LOB.write(g_last_accrual_report, length(l_header), 1, l_header);
8038: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added header to report');
8039:
8040: /* add parameters to accrual report */
8041: dbms_lob.writeAppend(g_last_accrual_report, length(l_parameters), l_parameters);
8042: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added parameters to report');
8043:
8044: /* add P_CP_STATEMENTS to accrual report */
8045: l_append := l_new_line || P_CP_STATEMENTS || l_new_line;

Line 8046: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);

8042: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added parameters to report');
8043:
8044: /* add P_CP_STATEMENTS to accrual report */
8045: l_append := l_new_line || P_CP_STATEMENTS || l_new_line;
8046: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8047: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added P_CP_STATEMENTS to report');
8048:
8049:
8050: l_append := l_new_line || ''|| g_passed_loan_cnt ||'';

Line 8051: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);

8047: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added P_CP_STATEMENTS to report');
8048:
8049:
8050: l_append := l_new_line || ''|| g_passed_loan_cnt ||'';
8051: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8052:
8053: l_append := l_new_line || ''|| g_failed_loan_cnt ||'';
8054: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8055:

Line 8054: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);

8050: l_append := l_new_line || ''|| g_passed_loan_cnt ||'';
8051: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8052:
8053: l_append := l_new_line || ''|| g_failed_loan_cnt ||'';
8054: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8055:
8056: l_append := l_new_line || ''|| l_new_line;
8057: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8058:

Line 8057: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);

8053: l_append := l_new_line || ''|| g_failed_loan_cnt ||'';
8054: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8055:
8056: l_append := l_new_line || ''|| l_new_line;
8057: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8058:
8059:
8060: /* add all statements to billing report */
8061: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then

Line 8061: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then

8057: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8058:
8059:
8060: /* add all statements to billing report */
8061: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then
8062: DBMS_LOB.Append(g_last_accrual_report, P_STATEMENTS_XML);
8063: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added statements to report');
8064: end if;
8065:

Line 8062: DBMS_LOB.Append(g_last_accrual_report, P_STATEMENTS_XML);

8058:
8059:
8060: /* add all statements to billing report */
8061: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then
8062: DBMS_LOB.Append(g_last_accrual_report, P_STATEMENTS_XML);
8063: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added statements to report');
8064: end if;
8065:
8066: l_append := l_new_line || '';

Line 8067: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);

8063: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added statements to report');
8064: end if;
8065:
8066: l_append := l_new_line || '';
8067: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8068:
8069: /* add footer to billing report */
8070: dbms_lob.writeAppend(g_last_accrual_report, length(l_footer), l_footer);
8071: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added footer to report');

Line 8070: dbms_lob.writeAppend(g_last_accrual_report, length(l_footer), l_footer);

8066: l_append := l_new_line || '';
8067: dbms_lob.writeAppend(g_last_accrual_report, length(l_append), l_append);
8068:
8069: /* add footer to billing report */
8070: dbms_lob.writeAppend(g_last_accrual_report, length(l_footer), l_footer);
8071: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Added footer to report');
8072:
8073: /* print report to output file */
8074: LNS_REP_UTILS.PRINT_CLOB(g_last_accrual_report); -- fix for bug 6938098

Line 8212: dbms_lob.createtemporary(l_in_statement, FALSE, DBMS_LOB.CALL);

8208: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_ERR_COUNT: ' || P_ERR_COUNT);
8209:
8210:
8211: /* init l_in_statement clob */
8212: dbms_lob.createtemporary(l_in_statement, FALSE, DBMS_LOB.CALL);
8213: dbms_lob.open(l_in_statement, dbms_lob.lob_readwrite);
8214:
8215: DBMS_LOB.write(l_in_statement, length(X_STATEMENT_XML), 1, X_STATEMENT_XML);
8216:

Line 8213: dbms_lob.open(l_in_statement, dbms_lob.lob_readwrite);

8209:
8210:
8211: /* init l_in_statement clob */
8212: dbms_lob.createtemporary(l_in_statement, FALSE, DBMS_LOB.CALL);
8213: dbms_lob.open(l_in_statement, dbms_lob.lob_readwrite);
8214:
8215: DBMS_LOB.write(l_in_statement, length(X_STATEMENT_XML), 1, X_STATEMENT_XML);
8216:
8217:

Line 8215: DBMS_LOB.write(l_in_statement, length(X_STATEMENT_XML), 1, X_STATEMENT_XML);

8211: /* init l_in_statement clob */
8212: dbms_lob.createtemporary(l_in_statement, FALSE, DBMS_LOB.CALL);
8213: dbms_lob.open(l_in_statement, dbms_lob.lob_readwrite);
8214:
8215: DBMS_LOB.write(l_in_statement, length(X_STATEMENT_XML), 1, X_STATEMENT_XML);
8216:
8217:
8218: /* init statement xml */
8219: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);

Line 8219: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);

8215: DBMS_LOB.write(l_in_statement, length(X_STATEMENT_XML), 1, X_STATEMENT_XML);
8216:
8217:
8218: /* init statement xml */
8219: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
8220: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
8221:
8222:
8223: /* query for loan number */

Line 8220: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);

8216:
8217:
8218: /* init statement xml */
8219: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
8220: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
8221:
8222:
8223: /* query for loan number */
8224: open loan_cur(P_LOAN_ID, P_INT_ACCRUED);

Line 8258: dbms_lob.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);

8254: l_statement := l_statement || l_new_line || ''||P_RESULT||'';
8255: l_statement := l_statement || l_new_line || '' || l_accr_int_amount || '';
8256: --l_statement := l_statement || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_INT_ACCRUED_DETAILS) || '';
8257: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_statement: ' || l_statement);
8258: dbms_lob.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
8259: dbms_lob.append(X_STATEMENT_XML, l_in_statement);
8260:
8261: l_statement2 := '';
8262:

Line 8259: dbms_lob.append(X_STATEMENT_XML, l_in_statement);

8255: l_statement := l_statement || l_new_line || '' || l_accr_int_amount || '';
8256: --l_statement := l_statement || l_new_line || '' || LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(P_INT_ACCRUED_DETAILS) || '';
8257: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_statement: ' || l_statement);
8258: dbms_lob.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
8259: dbms_lob.append(X_STATEMENT_XML, l_in_statement);
8260:
8261: l_statement2 := '';
8262:
8263:

Line 8293: DBMS_LOB.writeAppend(X_STATEMENT_XML, length(l_statement2), l_statement2);

8289:
8290:
8291:
8292: /* updating clob */
8293: DBMS_LOB.writeAppend(X_STATEMENT_XML, length(l_statement2), l_statement2);
8294:
8295: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
8296:
8297: EXCEPTION

Line 8391: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);

8387:
8388: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_statement: ' || l_statement);
8389:
8390: /* init statement xml */
8391: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
8392: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
8393:
8394: /* building clob */
8395: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);

Line 8392: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);

8388: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_statement: ' || l_statement);
8389:
8390: /* init statement xml */
8391: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
8392: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
8393:
8394: /* building clob */
8395: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
8396:

Line 8395: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);

8391: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
8392: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
8393:
8394: /* building clob */
8395: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
8396:
8397: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' -');
8398:
8399: EXCEPTION

Line 9161: dbms_lob.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);

9157:
9158: -- START OF BODY OF API
9159:
9160:
9161: dbms_lob.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
9162: dbms_lob.open(X_STATEMENT_XML, dbms_lob.lob_readwrite);
9163:
9164: x_statement_xml := x_statement_xml || l_new_line;
9165:

Line 9162: dbms_lob.open(X_STATEMENT_XML, dbms_lob.lob_readwrite);

9158: -- START OF BODY OF API
9159:
9160:
9161: dbms_lob.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
9162: dbms_lob.open(X_STATEMENT_XML, dbms_lob.lob_readwrite);
9163:
9164: x_statement_xml := x_statement_xml || l_new_line;
9165:
9166: OPEN loan_cur(p_loan_id);

Line 9436: --DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);

9432: ,X_STATEMENT_XML => x_statement_xml);
9433:
9434:
9435: /* Building clob */
9436: --DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
9437:
9438:
9439: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'p_commit is '||p_commit);
9440: IF FND_API.to_Boolean(p_commit)

Line 9679: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);

9675:
9676: -- START OF BODY OF API
9677:
9678: /* init all statements clob */
9679: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
9680: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
9681:
9682: dbms_lob.createtemporary(g_cp_statements, FALSE, DBMS_LOB.CALL);
9683: dbms_lob.open(g_cp_statements, dbms_lob.lob_readwrite);

Line 9680: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);

9676: -- START OF BODY OF API
9677:
9678: /* init all statements clob */
9679: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
9680: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
9681:
9682: dbms_lob.createtemporary(g_cp_statements, FALSE, DBMS_LOB.CALL);
9683: dbms_lob.open(g_cp_statements, dbms_lob.lob_readwrite);
9684:

Line 9682: dbms_lob.createtemporary(g_cp_statements, FALSE, DBMS_LOB.CALL);

9678: /* init all statements clob */
9679: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
9680: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
9681:
9682: dbms_lob.createtemporary(g_cp_statements, FALSE, DBMS_LOB.CALL);
9683: dbms_lob.open(g_cp_statements, dbms_lob.lob_readwrite);
9684:
9685: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Passed input parameters:');
9686: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BORROWER_ID: ' || P_BORROWER_ID);

Line 9683: dbms_lob.open(g_cp_statements, dbms_lob.lob_readwrite);

9679: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
9680: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
9681:
9682: dbms_lob.createtemporary(g_cp_statements, FALSE, DBMS_LOB.CALL);
9683: dbms_lob.open(g_cp_statements, dbms_lob.lob_readwrite);
9684:
9685: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Passed input parameters:');
9686: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_BORROWER_ID: ' || P_BORROWER_ID);
9687: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LEDGER_ID: ' || P_LEDGER_ID);

Line 9776: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);

9772: END IF;
9773:
9774: END IF;
9775:
9776: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);
9777: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);
9778:
9779: -- 1. The accrual Period/Date should be in Open GL Period
9780:

Line 9777: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);

9773:
9774: END IF;
9775:
9776: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);
9777: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);
9778:
9779: -- 1. The accrual Period/Date should be in Open GL Period
9780:
9781: IF l_ledger_id IS NOT NULL THEN

Line 9800: dbms_lob.Append(g_cp_statements, l_error_statements_xml);

9796: ,P_RESULT => 'E'
9797: ,P_ERR_COUNT => x_msg_count
9798: ,X_STATEMENT_XML => l_error_statements_xml);
9799:
9800: dbms_lob.Append(g_cp_statements, l_error_statements_xml);
9801: RAISE FND_API.G_EXC_ERROR;
9802: END IF;
9803: END IF;
9804:

Line 9844: dbms_lob.writeAppend(g_last_all_statements, length(l_success_header), l_success_header);

9840:
9841: l_success_header := l_new_line || '' || l_new_line;
9842: l_success_footer := l_new_line || '' || l_new_line;
9843:
9844: dbms_lob.writeAppend(g_last_all_statements, length(l_success_header), l_success_header);
9845:
9846: /* Accrue all the selected loans */
9847: FOR l_Count1 IN 1..l_loans_to_accrue_tbl.COUNT LOOP
9848:

Line 9871: dbms_lob.Append(g_last_all_statements, l_single_statement_xml);

9867: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Total Accrual timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
9868:
9869: IF l_return_status = 'S' THEN /* append to all statements clob */
9870:
9871: dbms_lob.Append(g_last_all_statements, l_single_statement_xml);
9872: g_passed_loan_cnt := g_passed_loan_cnt +1;
9873:
9874: ELSE /* otherwise append to errors clob */
9875:

Line 9876: dbms_lob.Append(l_error_statements_xml, l_single_statement_xml);

9872: g_passed_loan_cnt := g_passed_loan_cnt +1;
9873:
9874: ELSE /* otherwise append to errors clob */
9875:
9876: dbms_lob.Append(l_error_statements_xml, l_single_statement_xml);
9877: g_failed_loan_cnt := g_failed_loan_cnt +1;
9878:
9879: END IF;
9880:

Line 9882: dbms_lob.writeAppend(g_last_all_statements, length(l_success_footer), l_success_footer);

9878:
9879: END IF;
9880:
9881: END LOOP;
9882: dbms_lob.writeAppend(g_last_all_statements, length(l_success_footer), l_success_footer);
9883:
9884: /* if there are errors, add errors section */
9885: if dbms_lob.getlength(l_error_statements_xml) > 0 then
9886:

Line 9885: if dbms_lob.getlength(l_error_statements_xml) > 0 then

9881: END LOOP;
9882: dbms_lob.writeAppend(g_last_all_statements, length(l_success_footer), l_success_footer);
9883:
9884: /* if there are errors, add errors section */
9885: if dbms_lob.getlength(l_error_statements_xml) > 0 then
9886:
9887: l_error_header := l_new_line || '' || l_new_line;
9888: l_error_footer := l_new_line || '' || l_new_line;
9889: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);

Line 9889: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);

9885: if dbms_lob.getlength(l_error_statements_xml) > 0 then
9886:
9887: l_error_header := l_new_line || '' || l_new_line;
9888: l_error_footer := l_new_line || '' || l_new_line;
9889: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
9890: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
9891: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
9892:
9893: end if;

Line 9890: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);

9886:
9887: l_error_header := l_new_line || '' || l_new_line;
9888: l_error_footer := l_new_line || '' || l_new_line;
9889: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
9890: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
9891: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
9892:
9893: end if;
9894:

Line 9891: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);

9887: l_error_header := l_new_line || '' || l_new_line;
9888: l_error_footer := l_new_line || '' || l_new_line;
9889: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
9890: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
9891: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
9892:
9893: end if;
9894:
9895: END IF;