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 2923: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);

2919: l_statement := l_statement || l_new_line || '';
2920: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_statement: ' || l_statement);
2921:
2922: /* init statement xml */
2923: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
2924: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
2925:
2926: /* building clob */
2927: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);

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

2920: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_statement: ' || l_statement);
2921:
2922: /* init statement xml */
2923: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
2924: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
2925:
2926: /* building clob */
2927: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
2928:

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

2923: DBMS_LOB.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
2924: DBMS_LOB.open(X_STATEMENT_XML, DBMS_LOB.lob_readwrite);
2925:
2926: /* building clob */
2927: DBMS_LOB.write(X_STATEMENT_XML, length(l_statement), 1, l_statement);
2928:
2929: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2930:
2931: EXCEPTION

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

3012: LogMessage(FND_LOG.LEVEL_UNEXPECTED, ' ');
3013: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
3014:
3015: /* init report clob */
3016: dbms_lob.createtemporary(g_last_billing_report, FALSE, DBMS_LOB.CALL);
3017: dbms_lob.open(g_last_billing_report, dbms_lob.lob_readwrite);
3018:
3019: l_new_line := '
3020: ';

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

3013: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
3014:
3015: /* init report clob */
3016: dbms_lob.createtemporary(g_last_billing_report, FALSE, DBMS_LOB.CALL);
3017: dbms_lob.open(g_last_billing_report, dbms_lob.lob_readwrite);
3018:
3019: l_new_line := '
3020: ';
3021: l_header := '' || l_new_line || '';

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

3062: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_parameters: ' || l_parameters);
3063:
3064:
3065: /* add header to billing report */
3066: DBMS_LOB.write(g_last_billing_report, length(l_header), 1, l_header);
3067: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to report');
3068:
3069: /* add parameters to billing report */
3070: dbms_lob.writeAppend(g_last_billing_report, length(l_parameters), l_parameters);

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

3066: DBMS_LOB.write(g_last_billing_report, length(l_header), 1, l_header);
3067: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added header to report');
3068:
3069: /* add parameters to billing report */
3070: dbms_lob.writeAppend(g_last_billing_report, length(l_parameters), l_parameters);
3071: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
3072:
3073: /* add all statements to billing report */
3074: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then

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

3070: dbms_lob.writeAppend(g_last_billing_report, length(l_parameters), l_parameters);
3071: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
3072:
3073: /* add all statements to billing report */
3074: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then
3075: DBMS_LOB.Append(g_last_billing_report, P_STATEMENTS_XML);
3076: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
3077: end if;
3078:

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

3071: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added parameters to report');
3072:
3073: /* add all statements to billing report */
3074: if dbms_lob.getlength(P_STATEMENTS_XML) > 0 then
3075: DBMS_LOB.Append(g_last_billing_report, P_STATEMENTS_XML);
3076: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
3077: end if;
3078:
3079: /* add footer to billing report */

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

3076: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added statements to report');
3077: end if;
3078:
3079: /* add footer to billing report */
3080: dbms_lob.writeAppend(g_last_billing_report, length(l_footer), l_footer);
3081: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Added footer to report');
3082:
3083: /* print report to output file */
3084: LNS_REP_UTILS.PRINT_CLOB(g_last_billing_report); -- fix for bug 6938098

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

3605: l_return_status := FND_API.G_RET_STS_SUCCESS;
3606:
3607: -- START OF BODY OF API
3608:
3609: dbms_lob.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
3610: dbms_lob.open(X_STATEMENT_XML, dbms_lob.lob_readwrite);
3611:
3612: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
3613: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID: ' || P_LOAN_REC.LOAN_ID);

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

3606:
3607: -- START OF BODY OF API
3608:
3609: dbms_lob.createtemporary(X_STATEMENT_XML, FALSE, DBMS_LOB.CALL);
3610: dbms_lob.open(X_STATEMENT_XML, dbms_lob.lob_readwrite);
3611:
3612: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Processing loan ' || P_LOAN_REC.LOAN_NUMBER);
3613: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN ID: ' || P_LOAN_REC.LOAN_ID);
3614: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'LOAN DESCRIPTION: ' || P_LOAN_REC.LOAN_DESCRIPTION);

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

3681: fetch get_statement_cur into l_statement_xml;
3682: close get_statement_cur;
3683:
3684: /* remove xml header */
3685: l_offset := DBMS_LOB.INSTR(lob_loc => l_statement_xml,
3686: pattern => '>',
3687: offset => 1,
3688: nth => 1);
3689: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have removed header from the statement');

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

3688: nth => 1);
3689: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have removed header from the statement');
3690:
3691: /* copy generated statement to output */
3692: dbms_lob.copy(dest_lob => X_STATEMENT_XML,
3693: src_lob => l_statement_xml,
3694: amount => dbms_lob.getlength(l_statement_xml)-l_offset,
3695: src_offset => l_offset+1);
3696:

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

3690:
3691: /* copy generated statement to output */
3692: dbms_lob.copy(dest_lob => X_STATEMENT_XML,
3693: src_lob => l_statement_xml,
3694: amount => dbms_lob.getlength(l_statement_xml)-l_offset,
3695: src_offset => l_offset+1);
3696:
3697: return;
3698: end if;

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

4013: fetch get_statement_cur into l_statement_xml;
4014: close get_statement_cur;
4015:
4016: /* remove xml header */
4017: l_offset := DBMS_LOB.INSTR(lob_loc => l_statement_xml,
4018: pattern => '>',
4019: offset => 1,
4020: nth => 1);
4021: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have removed header from the statement');

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

4021: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have removed header from the statement');
4022: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_offset: ' || l_offset);
4023:
4024: /* copy generated statement to output */
4025: dbms_lob.copy(dest_lob => X_STATEMENT_XML,
4026: src_lob => l_statement_xml,
4027: amount => dbms_lob.getlength(l_statement_xml)-l_offset,
4028: src_offset => l_offset+1);
4029: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have copied generated statement to output');

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

4023:
4024: /* copy generated statement to output */
4025: dbms_lob.copy(dest_lob => X_STATEMENT_XML,
4026: src_lob => l_statement_xml,
4027: amount => dbms_lob.getlength(l_statement_xml)-l_offset,
4028: src_offset => l_offset+1);
4029: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Have copied generated statement to output');
4030:
4031: if P_COMMIT = FND_API.G_TRUE then

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

4788:
4789: -- START OF BODY OF API
4790:
4791: /* init all_statements clob */
4792: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
4793: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
4794:
4795: init;
4796:

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

4789: -- START OF BODY OF API
4790:
4791: /* init all_statements clob */
4792: dbms_lob.createtemporary(g_last_all_statements, FALSE, DBMS_LOB.CALL);
4793: dbms_lob.open(g_last_all_statements, dbms_lob.lob_readwrite);
4794:
4795: init;
4796:
4797: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Passed input parameters:');

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

4919: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Total found ' || l_Count || ' loan(s) to process');
4920:
4921: if l_Count > 0 then
4922:
4923: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);
4924: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);
4925:
4926: /* bill all selected loans */
4927: FOR l_Count1 IN 1..l_loans_to_bill_tbl.COUNT LOOP

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

4920:
4921: if l_Count > 0 then
4922:
4923: dbms_lob.createtemporary(l_error_statements_xml, FALSE, DBMS_LOB.CALL);
4924: dbms_lob.open(l_error_statements_xml, dbms_lob.lob_readwrite);
4925:
4926: /* bill all selected loans */
4927: FOR l_Count1 IN 1..l_loans_to_bill_tbl.COUNT LOOP
4928:

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

4945: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Total billing timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
4946:
4947: IF l_return_status = 'S' THEN /* append to all statements clob */
4948:
4949: dbms_lob.Append(g_last_all_statements, l_single_statement_xml);
4950:
4951: -- loan forgiveness adjustment: fix for bug 7387659
4952: if l_loans_to_bill_tbl(l_Count1).FORGIVENESS_FLAG = 'Y' and
4953: l_loans_to_bill_tbl(l_Count1).FORGIVENESS_PERCENT > 0 and

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

4980: end if;
4981:
4982: ELSE /* otherwise append to errors clob */
4983:
4984: dbms_lob.Append(l_error_statements_xml, l_single_statement_xml);
4985:
4986: END IF;
4987:
4988: END LOOP;

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

4987:
4988: END LOOP;
4989:
4990: /* if there are errors, add errors section */
4991: if dbms_lob.getlength(l_error_statements_xml) > 0 then
4992:
4993: l_new_line := '
4994: ';
4995: l_error_header := l_new_line || '' || l_new_line;

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

4993: l_new_line := '
4994: ';
4995: l_error_header := l_new_line || '' || l_new_line;
4996: l_error_footer := l_new_line || '' || l_new_line;
4997: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
4998: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
4999: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5000:
5001: end if;

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

4994: ';
4995: l_error_header := l_new_line || '' || l_new_line;
4996: l_error_footer := l_new_line || '' || l_new_line;
4997: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
4998: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
4999: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5000:
5001: end if;
5002:

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

4995: l_error_header := l_new_line || '' || l_new_line;
4996: l_error_footer := l_new_line || '' || l_new_line;
4997: dbms_lob.writeAppend(g_last_all_statements, length(l_error_header), l_error_header);
4998: dbms_lob.Append(g_last_all_statements, l_error_statements_xml);
4999: dbms_lob.writeAppend(g_last_all_statements, length(l_error_footer), l_error_footer);
5000:
5001: end if;
5002:
5003: