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 LNS_FINANCIALS

Line 3752: l_funded_amount := LNS_FINANCIALS.getFundedAmount(P_LOAN_ID, P_DATE, 'CURRENT');

3748: fetch verify_amount_cur into l_billed_amount;
3749: close verify_amount_cur;
3750: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_billed_amount = ' || l_billed_amount) ;
3751:
3752: l_funded_amount := LNS_FINANCIALS.getFundedAmount(P_LOAN_ID, P_DATE, 'CURRENT');
3753: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_funded_amount = ' || l_funded_amount) ;
3754:
3755: l_available_amount := l_funded_amount - l_billed_amount;
3756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_available_amount = ' || l_available_amount) ;

Line 3859: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;

3855: l_create_zero_instal varchar2(1);
3856: l_profile_name VARCHAR2(240);
3857:
3858: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3859: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3860: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3861: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
3862: l_is_disable_bill varchar2(1);
3863:

Line 3861: l_fee_tbl LNS_FINANCIALS.FEES_TBL;

3857:
3858: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3859: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3860: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3861: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
3862: l_is_disable_bill varchar2(1);
3863:
3864: /*-----------------------------------------------------------------------+
3865: | Cursor Declarations |

Line 4036: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');

4032: /* new principal and interest amounts from getInstallment api */
4033:
4034: if P_LOAN_REC.CURRENT_PHASE = 'TERM' then
4035:
4036: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
4037: l_start := sysdate;
4038: lns_financials.getInstallment(
4039: p_api_version => 1.0,
4040: p_init_msg_list => FND_API.G_TRUE,

Line 4038: lns_financials.getInstallment(

4034: if P_LOAN_REC.CURRENT_PHASE = 'TERM' then
4035:
4036: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
4037: l_start := sysdate;
4038: lns_financials.getInstallment(
4039: p_api_version => 1.0,
4040: p_init_msg_list => FND_API.G_TRUE,
4041: p_commit => FND_API.G_FALSE,
4042: p_loan_Id => P_LOAN_REC.LOAN_ID,

Line 4055: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');

4051: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'getInstallment Timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
4052:
4053: else
4054:
4055: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
4056: l_start := sysdate;
4057: lns_financials.getOpenInstallment(
4058: p_init_msg_list => FND_API.G_TRUE,
4059: p_loan_Id => P_LOAN_REC.LOAN_ID,

Line 4057: lns_financials.getOpenInstallment(

4053: else
4054:
4055: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
4056: l_start := sysdate;
4057: lns_financials.getOpenInstallment(
4058: p_init_msg_list => FND_API.G_TRUE,
4059: p_loan_Id => P_LOAN_REC.LOAN_ID,
4060: p_installment_number => P_LOAN_REC.NEXT_PAYMENT_NUMBER,
4061: x_amortization_rec => l_amortization_rec,

Line 4079: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Data returned from lns_financials.getInstallment:');

4075: if l_return_status <> 'S' then
4076: RAISE FND_API.G_EXC_ERROR;
4077: end if;
4078:
4079: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Data returned from lns_financials.getInstallment:');
4080: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INSTALLMENT_NUMBER: ' || l_amortization_rec.INSTALLMENT_NUMBER);
4081: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || l_amortization_rec.due_date);
4082: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRINCIPAL_AMOUNT: ' || l_amortization_rec.PRINCIPAL_AMOUNT);
4083: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INTEREST_AMOUNT: ' || l_amortization_rec.INTEREST_AMOUNT);

Line 4114: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_financials.getInstallment returns no data. Nothing to bill. Returning.');

4110: if l_amortization_rec.INSTALLMENT_NUMBER is null and
4111: l_amortization_rec.due_date is null
4112: then
4113:
4114: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_financials.getInstallment returns no data. Nothing to bill. Returning.');
4115: return;
4116:
4117: end if;
4118:

Line 4124: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0. ');

4120: (P_LOAN_REC.NEXT_INTEREST_AMOUNT is null or P_LOAN_REC.NEXT_INTEREST_AMOUNT = 0) and
4121: (P_LOAN_REC.NEXT_FEE_AMOUNT is null or P_LOAN_REC.NEXT_FEE_AMOUNT = 0)
4122: then
4123:
4124: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0. ');
4125:
4126: -- fix for bug 7000066: get LNS_CREATE_ZERO_INSTAL profile value to see if we need to create 0 amount installment
4127: l_create_zero_instal := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_INSTAL'), 'N');
4128: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CREATE_ZERO_INSTAL profile: ' || l_create_zero_instal);

Line 4479: l_amortization_rec lns_financials.AMORTIZATION_REC;

4475: l_end date;
4476: l_start date;
4477:
4478: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4479: l_amortization_rec lns_financials.AMORTIZATION_REC;
4480: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
4481:
4482: /*-----------------------------------------------------------------------+
4483: | Cursor Declarations |

Line 4535: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting next payment due date from lns_financials.preProcessInstallment...');

4531: fetch loan_cur_phase_cur into l_cur_phase;
4532: close loan_cur_phase_cur;
4533:
4534: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENT_PHASE: ' || l_cur_phase);
4535: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting next payment due date from lns_financials.preProcessInstallment...');
4536:
4537: if l_cur_phase = 'TERM' then
4538: lns_financials.preProcessInstallment(
4539: P_API_VERSION => 1.0,

Line 4538: lns_financials.preProcessInstallment(

4534: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENT_PHASE: ' || l_cur_phase);
4535: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting next payment due date from lns_financials.preProcessInstallment...');
4536:
4537: if l_cur_phase = 'TERM' then
4538: lns_financials.preProcessInstallment(
4539: P_API_VERSION => 1.0,
4540: P_INIT_MSG_LIST => FND_API.G_FALSE,
4541: P_COMMIT => FND_API.G_FALSE,
4542: p_loan_Id => P_LOAN_NEXT_DD_REC.LOAN_ID,

Line 4549: lns_financials.preProcessOpenInstallment(

4545: X_RETURN_STATUS => l_return_status,
4546: X_MSG_COUNT => l_msg_count,
4547: X_MSG_DATA => l_msg_data);
4548: else
4549: lns_financials.preProcessOpenInstallment(
4550: -- P_API_VERSION => 1.0,
4551: P_INIT_MSG_LIST => FND_API.G_FALSE,
4552: P_COMMIT => FND_API.G_FALSE,
4553: p_loan_Id => P_LOAN_NEXT_DD_REC.LOAN_ID,

Line 4561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Returns from lns_financials.preProcessInstallment:');

4557: X_MSG_COUNT => l_msg_count,
4558: X_MSG_DATA => l_msg_data);
4559: end if;
4560:
4561: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Returns from lns_financials.preProcessInstallment:');
4562: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INSTALLMENT_NUMBER: ' || l_amortization_rec.INSTALLMENT_NUMBER);
4563: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || l_amortization_rec.due_date);
4564:
4565: l_next_payment_due_date := l_amortization_rec.due_date;

Line 7911: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;

7907: l_loan_number varchar2(60);
7908: l_cur_phase VARCHAR2(30);
7909:
7910:
7911: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
7912: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
7913: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
7914: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7915:

Line 7912: l_fee_tbl LNS_FINANCIALS.FEES_TBL;

7908: l_cur_phase VARCHAR2(30);
7909:
7910:
7911: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
7912: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
7913: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
7914: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7915:
7916: /*-----------------------------------------------------------------------+

Line 7972: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');

7968:
7969: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Billing 0-th installment for loan ' || l_loan_number || '...');
7970:
7971: /* new principal and interest amounts from getInstallment api */
7972: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
7973:
7974: if l_cur_phase = 'TERM' then
7975:
7976: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');

Line 7976: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');

7972: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
7973:
7974: if l_cur_phase = 'TERM' then
7975:
7976: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
7977: lns_financials.getInstallment(
7978: p_api_version => 1.0,
7979: p_init_msg_list => FND_API.G_TRUE,
7980: p_commit => FND_API.G_FALSE,

Line 7977: lns_financials.getInstallment(

7973:
7974: if l_cur_phase = 'TERM' then
7975:
7976: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
7977: lns_financials.getInstallment(
7978: p_api_version => 1.0,
7979: p_init_msg_list => FND_API.G_TRUE,
7980: p_commit => FND_API.G_FALSE,
7981: p_loan_Id => P_LOAN_ID,

Line 7991: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');

7987: X_MSG_DATA => l_msg_data);
7988:
7989: else
7990:
7991: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
7992: lns_financials.getOpenInstallment(
7993: -- p_api_version => 1.0,
7994: p_init_msg_list => FND_API.G_TRUE,
7995: -- p_commit => FND_API.G_FALSE,

Line 7992: lns_financials.getOpenInstallment(

7988:
7989: else
7990:
7991: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
7992: lns_financials.getOpenInstallment(
7993: -- p_api_version => 1.0,
7994: p_init_msg_list => FND_API.G_TRUE,
7995: -- p_commit => FND_API.G_FALSE,
7996: p_loan_Id => P_LOAN_ID,

Line 8013: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Data returned from lns_financials.getInstallment:');

8009: if l_return_status <> 'S' then
8010: RAISE FND_API.G_EXC_ERROR;
8011: end if;
8012:
8013: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Data returned from lns_financials.getInstallment:');
8014: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INSTALLMENT_NUMBER: ' || l_amortization_rec.INSTALLMENT_NUMBER);
8015: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || l_amortization_rec.due_date);
8016: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRINCIPAL_AMOUNT: ' || l_amortization_rec.PRINCIPAL_AMOUNT);
8017: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INTEREST_AMOUNT: ' || l_amortization_rec.INTEREST_AMOUNT);

Line 8033: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_financials.getInstallment returns no data. Nothing to bill. Returning.');

8029: if l_amortization_rec.INSTALLMENT_NUMBER is null and
8030: l_amortization_rec.due_date is null
8031: then
8032:
8033: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_financials.getInstallment returns no data. Nothing to bill. Returning.');
8034: return;
8035:
8036: end if;
8037:

Line 8043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0. Nothing to bill.');

8039: (l_amortization_rec.INTEREST_AMOUNT is null or l_amortization_rec.INTEREST_AMOUNT = 0) and
8040: (l_amortization_rec.FEE_AMOUNT is null or l_amortization_rec.FEE_AMOUNT = 0)
8041: then
8042:
8043: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0. Nothing to bill.');
8044: return;
8045:
8046: end if;
8047:

Line 8673: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;

8669: l_current_phase varchar2(30);
8670: l_trx_date date;
8671: l_term_id number;
8672:
8673: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
8674: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
8675: l_invoices_tbl LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL;
8676:
8677: /*-----------------------------------------------------------------------+

Line 8674: l_fee_tbl LNS_FINANCIALS.FEES_TBL;

8670: l_trx_date date;
8671: l_term_id number;
8672:
8673: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
8674: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
8675: l_invoices_tbl LNS_BILLING_BATCH_PUB.INVOICE_DETAILS_TBL;
8676:
8677: /*-----------------------------------------------------------------------+
8678: | Cursor Declarations |

Line 8753: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');

8749: close c_loanInfo;
8750:
8751: if l_current_phase = 'TERM' then
8752:
8753: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
8754: lns_financials.getInstallment(
8755: p_api_version => 1.0,
8756: p_init_msg_list => FND_API.G_TRUE,
8757: p_commit => FND_API.G_FALSE,

Line 8754: lns_financials.getInstallment(

8750:
8751: if l_current_phase = 'TERM' then
8752:
8753: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
8754: lns_financials.getInstallment(
8755: p_api_version => 1.0,
8756: p_init_msg_list => FND_API.G_TRUE,
8757: p_commit => FND_API.G_FALSE,
8758: p_loan_Id => P_LOAN_ID,

Line 8768: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');

8764: X_MSG_DATA => l_msg_data);
8765:
8766: else
8767:
8768: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
8769: lns_financials.getOpenInstallment(
8770: p_init_msg_list => FND_API.G_TRUE,
8771: p_loan_Id => P_LOAN_ID,
8772: p_installment_number => l_NEXT_PAYMENT_NUMBER,

Line 8769: lns_financials.getOpenInstallment(

8765:
8766: else
8767:
8768: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
8769: lns_financials.getOpenInstallment(
8770: p_init_msg_list => FND_API.G_TRUE,
8771: p_loan_Id => P_LOAN_ID,
8772: p_installment_number => l_NEXT_PAYMENT_NUMBER,
8773: x_amortization_rec => l_amortization_rec,

Line 8803: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_financials.getInstallment returns no data. Nothing to bill. Returning.');

8799: if l_amortization_rec.INSTALLMENT_NUMBER is null and
8800: l_amortization_rec.due_date is null
8801: then
8802:
8803: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_financials.getInstallment returns no data. Nothing to bill. Returning.');
8804: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BILLING_DATA');
8805: FND_MSG_PUB.Add;
8806: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8807: RAISE FND_API.G_EXC_ERROR;

Line 8816: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0.');

8812: l_amortization_rec.INTEREST_AMOUNT = 0 and
8813: l_amortization_rec.FEE_AMOUNT = 0
8814: then
8815:
8816: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0.');
8817:
8818: -- fix for bug 7000066: get LNS_CREATE_ZERO_INSTAL profile value to see if we need to create 0 amount installment
8819: l_create_zero_instal := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_INSTAL'), 'N');
8820: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CREATE_ZERO_INSTAL profile: ' || l_create_zero_instal);

Line 10429: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

10425: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
10426: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
10427: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
10428: l_fee_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
10429: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
10430:
10431:
10432: /*-----------------------------------------------------------------------+
10433: | Cursor Declarations |

Line 10510: l_loan_details := lns_financials.getLoanDetails(p_loan_id => P_LOAN_ID

10506: */
10507:
10508: logMessage(FND_LOG.LEVEL_PROCEDURE, 'Processing origination submit for approval fees...');
10509:
10510: l_loan_details := lns_financials.getLoanDetails(p_loan_id => P_LOAN_ID
10511: ,p_based_on_terms => 'ORIGINAL'
10512: ,p_phase => l_current_phase);
10513:
10514: l_fee_structures(1).fee_category := 'EVENT';