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

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

3143: l_statement := l_statement || l_new_line || '';
3144: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_statement: ' || l_statement);
3145:
3146: /* init statement xml */
3147: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
3148: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
3149:
3150: /* building clob */
3151: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);

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

3144: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_statement: ' || l_statement);
3145:
3146: /* init statement xml */
3147: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
3148: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
3149:
3150: /* building clob */
3151: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
3152:

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

3147: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
3148: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
3149:
3150: /* building clob */
3151: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
3152:
3153: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
3154:
3155: EXCEPTION

Line 3256: dbms_lob.createtemporary(g_last_billing_report, FALSE, DBMS_LOB.CALL);

3252: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
3253: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
3254:
3255: /* init report clob */
3256: dbms_lob.createtemporary(g_last_billing_report, FALSE, DBMS_LOB.CALL);
3257: dbms_lob.open(g_last_billing_report, dbms_lob.lob_readwrite);
3258:
3259: l_new_line := '
3260: ';

Line 3257: dbms_lob.open(g_last_billing_report, dbms_lob.lob_readwrite);

3253: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
3254:
3255: /* init report clob */
3256: dbms_lob.createtemporary(g_last_billing_report, FALSE, DBMS_LOB.CALL);
3257: dbms_lob.open(g_last_billing_report, dbms_lob.lob_readwrite);
3258:
3259: l_new_line := '
3260: ';
3261: l_header := '' || l_new_line || '';

Line 3331: DBMS_LOB.write(g_last_billing_report, length(l_header), 1, l_header);

3327: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_parameters: ' || l_parameters);
3328:
3329:
3330: /* add header to billing report */
3331: DBMS_LOB.write(g_last_billing_report, length(l_header), 1, l_header);
3332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to report');
3333:
3334: /* add parameters to billing report */
3335: dbms_lob.writeAppend(g_last_billing_report, length(l_parameters), l_parameters);

Line 3335: dbms_lob.writeAppend(g_last_billing_report, length(l_parameters), l_parameters);

3331: DBMS_LOB.write(g_last_billing_report, length(l_header), 1, l_header);
3332: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to report');
3333:
3334: /* add parameters to billing report */
3335: dbms_lob.writeAppend(g_last_billing_report, length(l_parameters), l_parameters);
3336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
3337:
3338: /* add all statements to billing report */
3339: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then

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

3335: dbms_lob.writeAppend(g_last_billing_report, length(l_parameters), l_parameters);
3336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
3337:
3338: /* add all statements to billing report */
3339: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then
3340: DBMS_LOB.Append(g_last_billing_report, P_STATEMENTS_XML);
3341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
3342: end if;
3343:

Line 3340: DBMS_LOB.Append(g_last_billing_report, P_STATEMENTS_XML);

3336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
3337:
3338: /* add all statements to billing report */
3339: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then
3340: DBMS_LOB.Append(g_last_billing_report, P_STATEMENTS_XML);
3341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
3342: end if;
3343:
3344: /* add footer to billing report */

Line 3345: dbms_lob.writeAppend(g_last_billing_report, length(l_footer), l_footer);

3341: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
3342: end if;
3343:
3344: /* add footer to billing report */
3345: dbms_lob.writeAppend(g_last_billing_report, length(l_footer), l_footer);
3346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to report');
3347:
3348: /* print report to output file */
3349: LNS_REP_UTILS.PRINT_CLOB(g_last_billing_report); -- fix for bug 6938098

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

3928:
3929: -- START OF BODY OF API
3930:
3931:
3932: dbms_lob.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
3933: dbms_lob.open(X_STATEMENT_XML, dbms_lob.lob_readwrite);
3934:
3935: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
3936: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID: ' || P_LOAN_REC.LOAN_ID);

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

3929: -- START OF BODY OF API
3930:
3931:
3932: dbms_lob.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
3933: dbms_lob.open(X_STATEMENT_XML, dbms_lob.lob_readwrite);
3934:
3935: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
3936: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID: ' || P_LOAN_REC.LOAN_ID);
3937: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN DESCRIPTION: ' || P_LOAN_REC.LOAN_DESCRIPTION);

Line 4008: l_offset := DBMS_LOB.INSTR(lob_loc => l_statement_xml,

4004: fetch get_statement_cur into l_statement_xml;
4005: close get_statement_cur;
4006:
4007: /* remove xml header */
4008: l_offset := DBMS_LOB.INSTR(lob_loc => l_statement_xml,
4009: pattern => '>',
4010: offset => 1,
4011: nth => 1);
4012: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have removed header from the statement');

Line 4015: dbms_lob.copy(dest_lob => X_STATEMENT_XML,

4011: nth => 1);
4012: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have removed header from the statement');
4013:
4014: /* copy generated statement to output */
4015: dbms_lob.copy(dest_lob => X_STATEMENT_XML,
4016: src_lob => l_statement_xml,
4017: amount => dbms_lob.getlength(l_statement_xml)-l_offset,
4018: src_offset => l_offset+1);
4019:

Line 4017: amount => dbms_lob.getlength(l_statement_xml)-l_offset,

4013:
4014: /* copy generated statement to output */
4015: dbms_lob.copy(dest_lob => X_STATEMENT_XML,
4016: src_lob => l_statement_xml,
4017: amount => dbms_lob.getlength(l_statement_xml)-l_offset,
4018: src_offset => l_offset+1);
4019:
4020: x_return_status := l_return_status; --fix for bug 8830573
4021: return;

Line 4334: l_offset := DBMS_LOB.INSTR(lob_loc => l_statement_xml,

4330: fetch get_statement_cur into l_statement_xml;
4331: close get_statement_cur;
4332:
4333: /* remove xml header */
4334: l_offset := DBMS_LOB.INSTR(lob_loc => l_statement_xml,
4335: pattern => '>',
4336: offset => 1,
4337: nth => 1);
4338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have removed header from the statement');

Line 4342: dbms_lob.copy(dest_lob => X_STATEMENT_XML,

4338: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have removed header from the statement');
4339: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_offset: ' || l_offset);
4340:
4341: /* copy generated statement to output */
4342: dbms_lob.copy(dest_lob => X_STATEMENT_XML,
4343: src_lob => l_statement_xml,
4344: amount => dbms_lob.getlength(l_statement_xml)-l_offset,
4345: src_offset => l_offset+1);
4346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have copied generated statement to output');

Line 4344: amount => dbms_lob.getlength(l_statement_xml)-l_offset,

4340:
4341: /* copy generated statement to output */
4342: dbms_lob.copy(dest_lob => X_STATEMENT_XML,
4343: src_lob => l_statement_xml,
4344: amount => dbms_lob.getlength(l_statement_xml)-l_offset,
4345: src_offset => l_offset+1);
4346: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have copied generated statement to output');
4347:
4348: if P_COMMIT = FND_API.G_TRUE then

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

5063: -- START OF BODY OF API
5064:
5065: l_loans_to_bill_tbl := P_LOANS_TO_BILL_TBL;
5066:
5067: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);
5068: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);
5069:
5070: /* bill all selected loans */
5071: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Billing loans...');

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

5064:
5065: l_loans_to_bill_tbl := P_LOANS_TO_BILL_TBL;
5066:
5067: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);
5068: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);
5069:
5070: /* bill all selected loans */
5071: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Billing loans...');
5072: FOR l_Count1 IN 1..l_loans_to_bill_tbl.COUNT LOOP

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

5129: else
5130: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Will not perform loan forgiveness adjustment for loan ' || l_loans_to_bill_tbl(l_Count1).LOAN_ID);
5131: end if;
5132:
5133: dbms_lob.Append(g_last_all_statements, l_single_statement_xml);
5134:
5135: if P_COMMIT = FND_API.G_TRUE then
5136: COMMIT WORK;
5137: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited loan ' || l_loans_to_bill_tbl(l_Count1).LOAN_NUMBER);

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

5138: end if;
5139:
5140: ELSE /* otherwise append to errors clob */
5141:
5142: dbms_lob.Append(l_error_statements_xml, l_single_statement_xml);
5143:
5144: END IF;
5145:
5146: EXCEPTION

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

5160: P_DUE_DATE => l_loans_to_bill_tbl(l_Count1).NEXT_PAYMENT_DUE_DATE,
5161: P_ERR_COUNT => x_msg_count,
5162: X_STATEMENT_XML => l_single_statement_xml);
5163:
5164: dbms_lob.Append(l_error_statements_xml, l_single_statement_xml);
5165: END;
5166:
5167: END LOOP;
5168:

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

5166:
5167: END LOOP;
5168:
5169: /* if there are errors, add errors section */
5170: if dbms_lob.getlength(l_error_statements_xml) > 0 then
5171:
5172: l_new_line := '
5173: ';
5174: l_error_header := l_new_line || '' || l_new_line;

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

5172: l_new_line := '
5173: ';
5174: l_error_header := l_new_line || '' || l_new_line;
5175: l_error_footer := l_new_line || '' || l_new_line;
5176: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
5177: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
5178: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5179:
5180: end if;

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

5173: ';
5174: l_error_header := l_new_line || '' || l_new_line;
5175: l_error_footer := l_new_line || '' || l_new_line;
5176: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
5177: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
5178: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5179:
5180: end if;
5181:

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

5174: l_error_header := l_new_line || '' || l_new_line;
5175: l_error_footer := l_new_line || '' || l_new_line;
5176: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
5177: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
5178: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5179:
5180: end if;
5181:
5182: IF l_return_status <> 'S' THEN

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

5386:
5387: -- START OF BODY OF API
5388:
5389: /* init all_statements clob */
5390: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
5391: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
5392:
5393: init;
5394:

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

5387: -- START OF BODY OF API
5388:
5389: /* init all_statements clob */
5390: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
5391: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
5392:
5393: init;
5394:
5395: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Passed input parameters:');

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

5533: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Total found ' || l_Count || ' loan(s) to process');
5534:
5535: if l_Count > 0 then
5536:
5537: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);
5538: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);
5539:
5540: /* bill all selected loans */
5541: FOR l_Count1 IN 1..l_loans_to_bill_tbl.COUNT LOOP

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

5534:
5535: if l_Count > 0 then
5536:
5537: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);
5538: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);
5539:
5540: /* bill all selected loans */
5541: FOR l_Count1 IN 1..l_loans_to_bill_tbl.COUNT LOOP
5542:

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

5559: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Total billing timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
5560:
5561: IF l_return_status = 'S' THEN /* append to all statements clob */
5562:
5563: dbms_lob.Append(g_last_all_statements, l_single_statement_xml);
5564:
5565: -- loan forgiveness adjustment: fix for bug 7387659
5566: if l_loans_to_bill_tbl(l_Count1).FORGIVENESS_FLAG = 'Y' and
5567: l_loans_to_bill_tbl(l_Count1).FORGIVENESS_PERCENT > 0 and

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

5594: end if;
5595:
5596: ELSE /* otherwise append to errors clob */
5597:
5598: dbms_lob.Append(l_error_statements_xml, l_single_statement_xml);
5599:
5600: END IF;
5601:
5602: END LOOP;

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

5601:
5602: END LOOP;
5603:
5604: /* if there are errors, add errors section */
5605: if dbms_lob.getlength(l_error_statements_xml) > 0 then
5606:
5607: l_new_line := '
5608: ';
5609: l_error_header := l_new_line || '' || l_new_line;

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

5607: l_new_line := '
5608: ';
5609: l_error_header := l_new_line || '' || l_new_line;
5610: l_error_footer := l_new_line || '' || l_new_line;
5611: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
5612: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
5613: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5614:
5615: end if;

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

5608: ';
5609: l_error_header := l_new_line || '' || l_new_line;
5610: l_error_footer := l_new_line || '' || l_new_line;
5611: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
5612: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
5613: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5614:
5615: end if;
5616:

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

5609: l_error_header := l_new_line || '' || l_new_line;
5610: l_error_footer := l_new_line || '' || l_new_line;
5611: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
5612: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
5613: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5614:
5615: end if;
5616:
5617:

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

9169: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FORGIVENESS_PERCENT: ' || l_loans_to_bill_tbl(l_Count1).FORGIVENESS_PERCENT);
9170: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENT_PHASE: ' || l_loans_to_bill_tbl(l_Count1).CURRENT_PHASE);
9171:
9172: /* do all needed inits */
9173: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
9174: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
9175:
9176: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Calling BILL_LOANS_EXT...');
9177: BILL_LOANS_EXT(

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

9170: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENT_PHASE: ' || l_loans_to_bill_tbl(l_Count1).CURRENT_PHASE);
9171:
9172: /* do all needed inits */
9173: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
9174: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
9175:
9176: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Calling BILL_LOANS_EXT...');
9177: BILL_LOANS_EXT(
9178: P_API_VERSION => 1.0,