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 3539: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;

3535: l_end date;
3536: l_floating_flag varchar2(1);
3537:
3538: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3539: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3540: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3541: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
3542:
3543: /*-----------------------------------------------------------------------+

Line 3541: l_fee_tbl LNS_FINANCIALS.FEES_TBL;

3537:
3538: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3539: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3540: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3541: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
3542:
3543: /*-----------------------------------------------------------------------+
3544: | Cursor Declarations |
3545: +-----------------------------------------------------------------------*/

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

3708: /* new principal and interest amounts from getInstallment api */
3709:
3710: if P_LOAN_REC.CURRENT_PHASE = 'TERM' then
3711:
3712: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
3713: l_start := sysdate;
3714: lns_financials.getInstallment(
3715: p_api_version => 1.0,
3716: p_init_msg_list => FND_API.G_TRUE,

Line 3714: lns_financials.getInstallment(

3710: if P_LOAN_REC.CURRENT_PHASE = 'TERM' then
3711:
3712: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
3713: l_start := sysdate;
3714: lns_financials.getInstallment(
3715: p_api_version => 1.0,
3716: p_init_msg_list => FND_API.G_TRUE,
3717: p_commit => FND_API.G_FALSE,
3718: p_loan_Id => P_LOAN_REC.LOAN_ID,

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

3727: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'getInstallment Timing: ' || round((l_end - l_start)*86400, 2) || ' sec');
3728:
3729: else
3730:
3731: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
3732: l_start := sysdate;
3733: lns_financials.getOpenInstallment(
3734: p_init_msg_list => FND_API.G_TRUE,
3735: p_loan_Id => P_LOAN_REC.LOAN_ID,

Line 3733: lns_financials.getOpenInstallment(

3729: else
3730:
3731: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
3732: l_start := sysdate;
3733: lns_financials.getOpenInstallment(
3734: p_init_msg_list => FND_API.G_TRUE,
3735: p_loan_Id => P_LOAN_REC.LOAN_ID,
3736: p_installment_number => P_LOAN_REC.NEXT_PAYMENT_NUMBER,
3737: x_amortization_rec => l_amortization_rec,

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

3751: if l_return_status <> 'S' then
3752: RAISE FND_API.G_EXC_ERROR;
3753: end if;
3754:
3755: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Data returned from lns_financials.getInstallment:');
3756: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INSTALLMENT_NUMBER: ' || l_amortization_rec.INSTALLMENT_NUMBER);
3757: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || l_amortization_rec.due_date);
3758: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRINCIPAL_AMOUNT: ' || l_amortization_rec.PRINCIPAL_AMOUNT);
3759: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INTEREST_AMOUNT: ' || l_amortization_rec.INTEREST_AMOUNT);

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

3770: (P_LOAN_REC.NEXT_INTEREST_AMOUNT is null or P_LOAN_REC.NEXT_INTEREST_AMOUNT = 0) and
3771: (P_LOAN_REC.NEXT_FEE_AMOUNT is null or P_LOAN_REC.NEXT_FEE_AMOUNT = 0)
3772: then
3773:
3774: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0. Nothing to bill.');
3775: return;
3776:
3777: /*
3778: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_AMOUNT_INST');

Line 3805: lns_financials.floatingRatePostProcessing(p_loan_id => P_LOAN_REC.LOAN_ID

3801:
3802: if P_LOAN_REC.NEXT_INTEREST_AMOUNT > 0 and l_floating_flag = 'Y' then
3803:
3804: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BEFORE floating postProcessing');
3805: lns_financials.floatingRatePostProcessing(p_loan_id => P_LOAN_REC.LOAN_ID
3806: ,p_init_msg_list => FND_API.G_FALSE
3807: ,p_commit => FND_API.G_FALSE
3808: ,p_installment_number => P_LOAN_REC.NEXT_PAYMENT_NUMBER
3809: ,p_period_begin_date => P_LOAN_REC.NEXT_PAYMENT_DUE_DATE

Line 4162: l_amortization_rec lns_financials.AMORTIZATION_REC;

4158: l_end date;
4159: l_start date;
4160:
4161: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4162: l_amortization_rec lns_financials.AMORTIZATION_REC;
4163: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
4164:
4165: /*-----------------------------------------------------------------------+
4166: | Cursor Declarations |

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

4214: fetch loan_cur_phase_cur into l_cur_phase;
4215: close loan_cur_phase_cur;
4216:
4217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENT_PHASE: ' || l_cur_phase);
4218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting next payment due date from lns_financials.preProcessInstallment...');
4219:
4220: if l_cur_phase = 'TERM' then
4221: lns_financials.preProcessInstallment(
4222: P_API_VERSION => 1.0,

Line 4221: lns_financials.preProcessInstallment(

4217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURRENT_PHASE: ' || l_cur_phase);
4218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting next payment due date from lns_financials.preProcessInstallment...');
4219:
4220: if l_cur_phase = 'TERM' then
4221: lns_financials.preProcessInstallment(
4222: P_API_VERSION => 1.0,
4223: P_INIT_MSG_LIST => FND_API.G_FALSE,
4224: P_COMMIT => FND_API.G_FALSE,
4225: p_loan_Id => P_LOAN_NEXT_DD_REC.LOAN_ID,

Line 4232: lns_financials.preProcessOpenInstallment(

4228: X_RETURN_STATUS => l_return_status,
4229: X_MSG_COUNT => l_msg_count,
4230: X_MSG_DATA => l_msg_data);
4231: else
4232: lns_financials.preProcessOpenInstallment(
4233: -- P_API_VERSION => 1.0,
4234: P_INIT_MSG_LIST => FND_API.G_FALSE,
4235: P_COMMIT => FND_API.G_FALSE,
4236: p_loan_Id => P_LOAN_NEXT_DD_REC.LOAN_ID,

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

4240: X_MSG_COUNT => l_msg_count,
4241: X_MSG_DATA => l_msg_data);
4242: end if;
4243:
4244: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Returns from lns_financials.preProcessInstallment:');
4245: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INSTALLMENT_NUMBER: ' || l_amortization_rec.INSTALLMENT_NUMBER);
4246: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || l_amortization_rec.due_date);
4247:
4248: l_next_payment_due_date := l_amortization_rec.due_date;

Line 7265: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;

7261: l_loan_number varchar2(60);
7262: l_cur_phase VARCHAR2(30);
7263:
7264:
7265: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
7266: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
7267: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
7268: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7269:

Line 7266: l_fee_tbl LNS_FINANCIALS.FEES_TBL;

7262: l_cur_phase VARCHAR2(30);
7263:
7264:
7265: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
7266: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
7267: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
7268: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
7269:
7270: /*-----------------------------------------------------------------------+

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

7322:
7323: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Billing 0-th installment for loan ' || l_loan_number || '...');
7324:
7325: /* new principal and interest amounts from getInstallment api */
7326: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
7327:
7328: if l_cur_phase = 'TERM' then
7329:
7330: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');

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

7326: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
7327:
7328: if l_cur_phase = 'TERM' then
7329:
7330: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
7331: lns_financials.getInstallment(
7332: p_api_version => 1.0,
7333: p_init_msg_list => FND_API.G_TRUE,
7334: p_commit => FND_API.G_FALSE,

Line 7331: lns_financials.getInstallment(

7327:
7328: if l_cur_phase = 'TERM' then
7329:
7330: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getInstallment...');
7331: lns_financials.getInstallment(
7332: p_api_version => 1.0,
7333: p_init_msg_list => FND_API.G_TRUE,
7334: p_commit => FND_API.G_FALSE,
7335: p_loan_Id => P_LOAN_ID,

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

7341: X_MSG_DATA => l_msg_data);
7342:
7343: else
7344:
7345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
7346: lns_financials.getOpenInstallment(
7347: -- p_api_version => 1.0,
7348: p_init_msg_list => FND_API.G_TRUE,
7349: -- p_commit => FND_API.G_FALSE,

Line 7346: lns_financials.getOpenInstallment(

7342:
7343: else
7344:
7345: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling lns_financials.getOpenInstallment...');
7346: lns_financials.getOpenInstallment(
7347: -- p_api_version => 1.0,
7348: p_init_msg_list => FND_API.G_TRUE,
7349: -- p_commit => FND_API.G_FALSE,
7350: p_loan_Id => P_LOAN_ID,

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

7363: if l_return_status <> 'S' then
7364: RAISE FND_API.G_EXC_ERROR;
7365: end if;
7366:
7367: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Data returned from lns_financials.getInstallment:');
7368: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INSTALLMENT_NUMBER: ' || l_amortization_rec.INSTALLMENT_NUMBER);
7369: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || l_amortization_rec.due_date);
7370: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRINCIPAL_AMOUNT: ' || l_amortization_rec.PRINCIPAL_AMOUNT);
7371: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INTEREST_AMOUNT: ' || l_amortization_rec.INTEREST_AMOUNT);

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

7382: (l_amortization_rec.INTEREST_AMOUNT is null or l_amortization_rec.INTEREST_AMOUNT = 0) and
7383: (l_amortization_rec.FEE_AMOUNT is null or l_amortization_rec.FEE_AMOUNT = 0)
7384: then
7385:
7386: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0. Nothing to bill.');
7387: return;
7388:
7389: end if;
7390: