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_FINANCIALS dependencies on LNS_FEE_ENGINE

Line 597: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

593: n number;
594: l_original_loan_amount number;
595: l_fund_sched_count number;
596:
597: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
598: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
599: l_custom_tbl LNS_CUSTOM_PUB.CUSTOM_TBL;
600: l_AMORT_METHOD varchar2(30);
601: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;

Line 598: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

594: l_original_loan_amount number;
595: l_fund_sched_count number;
596:
597: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
598: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
599: l_custom_tbl LNS_CUSTOM_PUB.CUSTOM_TBL;
600: l_AMORT_METHOD varchar2(30);
601: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
602: l_CUSTOM_SET_REC LNS_CUSTOM_PUB.custom_settings_type;

Line 741: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');

737: l_fee_basis_tbl(3).fee_basis_amount := l_original_loan_amount;
738: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
739: l_fee_basis_tbl(4).fee_basis_amount := l_loan_details.requested_amount + l_loan_details.ADD_REQUESTED_AMOUNT - l_original_loan_amount;
740:
741: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
742: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
743: ,p_loan_id => p_loan_id
744: ,p_installment => 0
745: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 742: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

738: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
739: l_fee_basis_tbl(4).fee_basis_amount := l_loan_details.requested_amount + l_loan_details.ADD_REQUESTED_AMOUNT - l_original_loan_amount;
740:
741: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
742: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
743: ,p_loan_id => p_loan_id
744: ,p_installment => 0
745: ,p_fee_basis_tbl => l_fee_basis_tbl
746: ,p_based_on_terms => p_based_on_terms

Line 1103: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for

1099: l_api_version_number number;
1100: l_return_status VARCHAR2(1);
1101: l_msg_count NUMBER;
1102: l_msg_data VARCHAR2(32767);
1103: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for
1104: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1105: l_overdue_amount number;
1106: i number;
1107: l_due_date date;

Line 1104: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

1100: l_return_status VARCHAR2(1);
1101: l_msg_count NUMBER;
1102: l_msg_data VARCHAR2(32767);
1103: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for
1104: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1105: l_overdue_amount number;
1106: i number;
1107: l_due_date date;
1108: l_installment number;

Line 1572: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

1568: l_return_status VARCHAR2(1);
1569: l_msg_count NUMBER;
1570: l_msg_data VARCHAR2(32767);
1571: l_api_name varchar2(25);
1572: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1573: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;
1574: l_fees_tbl_2 LNS_FINANCIALS.FEES_TBL;
1575: l_total_fees number;
1576: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

Line 1573: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;

1569: l_msg_count NUMBER;
1570: l_msg_data VARCHAR2(32767);
1571: l_api_name varchar2(25);
1572: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1573: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;
1574: l_fees_tbl_2 LNS_FINANCIALS.FEES_TBL;
1575: l_total_fees number;
1576: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1577: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for

Line 1576: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

1572: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1573: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;
1574: l_fees_tbl_2 LNS_FINANCIALS.FEES_TBL;
1575: l_total_fees number;
1576: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1577: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for
1578: i number;
1579: --l_begin_balance number; -- used for fees calculation
1580: l_customized varchar2(1);

Line 1577: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for

1573: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;
1574: l_fees_tbl_2 LNS_FINANCIALS.FEES_TBL;
1575: l_total_fees number;
1576: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1577: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for
1578: i number;
1579: --l_begin_balance number; -- used for fees calculation
1580: l_customized varchar2(1);
1581: l_loan_start_date date;

Line 1774: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_TRUE

1770: else
1771: l_fee_structures(1).FEE_BILLING_OPTION := 'BILL_WITH_INSTALLMENT';
1772: end if;
1773:
1774: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_TRUE
1775: ,p_commit => FND_API.G_FALSE
1776: ,p_loan_id => p_loan_id
1777: ,p_installment_number => p_installment_number
1778: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 1796: lns_fee_engine.processLateFees(p_loan_id => p_loan_id

1792:
1793: if p_installment_number > 0 then
1794:
1795: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - processing late fees');
1796: lns_fee_engine.processLateFees(p_loan_id => p_loan_id
1797: ,p_init_msg_list => p_init_msg_list
1798: ,p_commit => 'F'
1799: ,p_phase => l_loan_details.LOAN_PHASE
1800: ,x_return_status => l_return_status

Line 1818: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_TRUE

1814: -- add the recurring fees for the installment onto the fee schedule
1815: l_fee_structures(1).fee_category := 'RECUR';
1816: l_fee_structures(1).fee_type := null;
1817:
1818: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_TRUE
1819: ,p_commit => FND_API.G_FALSE
1820: ,p_loan_id => p_loan_id
1821: ,p_installment_number => p_installment_number
1822: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 1837: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling lns_fee_engine.getFeeSchedule...');

1833: RAISE FND_API.G_EXC_ERROR;
1834: end if;
1835: end if;
1836:
1837: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling lns_fee_engine.getFeeSchedule...');
1838: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE
1839: ,p_loan_id => p_loan_id
1840: ,p_installment_number => p_installment_number
1841: ,p_disb_header_id => null

Line 1838: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE

1834: end if;
1835: end if;
1836:
1837: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling lns_fee_engine.getFeeSchedule...');
1838: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE
1839: ,p_loan_id => p_loan_id
1840: ,p_installment_number => p_installment_number
1841: ,p_disb_header_id => null
1842: ,p_phase => 'TERM'

Line 2037: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

2033: l_msg_count NUMBER;
2034: l_msg_data VARCHAR2(32767);
2035: l_api_name varchar2(25);
2036:
2037: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2038: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;
2039: l_fees_tbl_2 LNS_FINANCIALS.FEES_TBL;
2040: l_total_fees number;
2041: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

Line 2038: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;

2034: l_msg_data VARCHAR2(32767);
2035: l_api_name varchar2(25);
2036:
2037: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2038: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;
2039: l_fees_tbl_2 LNS_FINANCIALS.FEES_TBL;
2040: l_total_fees number;
2041: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2042: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for

Line 2041: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

2037: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2038: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;
2039: l_fees_tbl_2 LNS_FINANCIALS.FEES_TBL;
2040: l_total_fees number;
2041: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2042: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for
2043: i number;
2044: m number;
2045: l_wtd_balance number;

Line 2042: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for

2038: l_fees_tbl_1 LNS_FEE_ENGINE.FEE_CALC_TBL;
2039: l_fees_tbl_2 LNS_FINANCIALS.FEES_TBL;
2040: l_total_fees number;
2041: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2042: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; -- define what event(s) we are processing fees for
2043: i number;
2044: m number;
2045: l_wtd_balance number;
2046: l_periodic_rate number;

Line 2123: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE

2119: exit;
2120: end if;
2121: end loop;
2122:
2123: lns_fee_engine.getFeeSchedule(p_init_msg_list => FND_API.G_FALSE
2124: ,p_loan_id => p_loan_id
2125: ,p_installment_number => p_installment_number
2126: ,p_disb_header_id => null
2127: ,p_phase => 'OPEN'

Line 2466: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

2462: l_hid_cumul_norm_int_dtl_str varchar2(2000);
2463: l_cap_int_detail_str varchar2(2000);
2464: l_early_pay_cr_detail_str varchar2(2000);
2465:
2466: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2467: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2468: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2469: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2470: l_PRIN_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;

Line 2467: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

2463: l_cap_int_detail_str varchar2(2000);
2464: l_early_pay_cr_detail_str varchar2(2000);
2465:
2466: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2467: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2468: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2469: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2470: l_PRIN_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2471: l_INT_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;

Line 2696: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');

2692: l_fee_basis_tbl(3).fee_basis_amount := l_original_loan_amount;
2693: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
2694: l_fee_basis_tbl(4).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT - l_original_loan_amount;
2695:
2696: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
2697: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
2698: ,p_loan_id => l_loan_id
2699: ,p_installment => 0
2700: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 2697: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

2693: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
2694: l_fee_basis_tbl(4).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT - l_original_loan_amount;
2695:
2696: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
2697: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
2698: ,p_loan_id => l_loan_id
2699: ,p_installment => 0
2700: ,p_fee_basis_tbl => l_fee_basis_tbl
2701: ,p_based_on_terms => p_based_on_terms

Line 3580: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');

3576: l_fee_basis_tbl(8).fee_basis_amount := l_amortization_rec.UNPAID_INT;
3577: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
3578: l_fee_basis_tbl(9).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT;
3579:
3580: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
3581: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
3582: ,p_loan_id => l_loan_id
3583: ,p_installment => l_installment_number
3584: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 3581: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

3577: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
3578: l_fee_basis_tbl(9).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT;
3579:
3580: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
3581: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
3582: ,p_loan_id => l_loan_id
3583: ,p_installment => l_installment_number
3584: ,p_fee_basis_tbl => l_fee_basis_tbl
3585: ,p_based_on_terms => p_based_on_terms

Line 3870: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

3866: l_penal_int_detail_str varchar2(2000);
3867: l_cap_int_detail_str varchar2(2000);
3868: l_early_pay_cr_detail_str varchar2(2000);
3869:
3870: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
3871: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
3872: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
3873: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
3874: l_prev_payment_frequency varchar2(30);

Line 3871: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

3867: l_cap_int_detail_str varchar2(2000);
3868: l_early_pay_cr_detail_str varchar2(2000);
3869:
3870: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
3871: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
3872: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
3873: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
3874: l_prev_payment_frequency varchar2(30);
3875:

Line 4060: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');

4056: l_fee_basis_tbl(3).fee_basis_amount := l_original_loan_amount;
4057: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
4058: l_fee_basis_tbl(4).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT - l_original_loan_amount;
4059:
4060: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
4061: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
4062: ,p_loan_id => l_loan_id
4063: ,p_installment => 0
4064: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 4061: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

4057: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
4058: l_fee_basis_tbl(4).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT - l_original_loan_amount;
4059:
4060: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
4061: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
4062: ,p_loan_id => l_loan_id
4063: ,p_installment => 0
4064: ,p_fee_basis_tbl => l_fee_basis_tbl
4065: ,p_based_on_terms => p_based_on_terms

Line 4793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');

4789: l_fee_basis_tbl(8).fee_basis_amount := l_amortization_rec.UNPAID_INT;
4790: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
4791: l_fee_basis_tbl(9).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT;
4792:
4793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
4794: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
4795: ,p_loan_id => l_loan_id
4796: ,p_installment => l_installment_number
4797: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 4794: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

4790: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
4791: l_fee_basis_tbl(9).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT;
4792:
4793: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
4794: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
4795: ,p_loan_id => l_loan_id
4796: ,p_installment => l_installment_number
4797: ,p_fee_basis_tbl => l_fee_basis_tbl
4798: ,p_based_on_terms => p_based_on_terms

Line 5093: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

5089: l_penal_int_detail_str varchar2(2000);
5090: l_cap_int_detail_str varchar2(2000);
5091: l_early_pay_cr_detail_str varchar2(2000);
5092:
5093: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
5094: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
5095: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
5096: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
5097: l_prev_payment_frequency varchar2(30);

Line 5094: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

5090: l_cap_int_detail_str varchar2(2000);
5091: l_early_pay_cr_detail_str varchar2(2000);
5092:
5093: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
5094: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
5095: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
5096: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
5097: l_prev_payment_frequency varchar2(30);
5098:

Line 5317: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');

5313: l_fee_basis_tbl(3).fee_basis_amount := l_original_loan_amount;
5314: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
5315: l_fee_basis_tbl(4).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT - l_original_loan_amount;
5316:
5317: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
5318: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
5319: ,p_loan_id => l_loan_id
5320: ,p_installment => 0
5321: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 5318: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

5314: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
5315: l_fee_basis_tbl(4).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT - l_original_loan_amount;
5316:
5317: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
5318: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
5319: ,p_loan_id => l_loan_id
5320: ,p_installment => 0
5321: ,p_fee_basis_tbl => l_fee_basis_tbl
5322: ,p_based_on_terms => p_based_on_terms

Line 6126: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');

6122: l_fee_basis_tbl(8).fee_basis_amount := l_amortization_rec.UNPAID_INT;
6123: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
6124: l_fee_basis_tbl(9).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT;
6125:
6126: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
6127: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
6128: ,p_loan_id => l_loan_id
6129: ,p_installment => l_installment_number
6130: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 6127: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

6123: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
6124: l_fee_basis_tbl(9).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT;
6125:
6126: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
6127: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
6128: ,p_loan_id => l_loan_id
6129: ,p_installment => l_installment_number
6130: ,p_fee_basis_tbl => l_fee_basis_tbl
6131: ,p_based_on_terms => p_based_on_terms

Line 6432: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

6428: n number;
6429: l_norm_int_detail_str varchar2(2000);
6430: l_prev_end_balance number;
6431:
6432: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
6433: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
6434: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
6435:
6436: cursor c_total_disbursed(p_loan_id number, p_from_date date, p_to_date date) is

Line 6433: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

6429: l_norm_int_detail_str varchar2(2000);
6430: l_prev_end_balance number;
6431:
6432: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
6433: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
6434: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
6435:
6436: cursor c_total_disbursed(p_loan_id number, p_from_date date, p_to_date date) is
6437: select nvl(sum(header_amount), 0)

Line 6565: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');

6561: l_fee_basis_tbl(3).fee_basis_amount := l_end_balance;
6562: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
6563: l_fee_basis_tbl(4).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT - l_end_balance;
6564:
6565: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
6566: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
6567: ,p_loan_id => l_loan_id
6568: ,p_installment => 0
6569: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 6566: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

6562: l_fee_basis_tbl(4).fee_basis_name := 'TOTAL_UNDISB_AMT';
6563: l_fee_basis_tbl(4).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT - l_end_balance;
6564:
6565: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for 0-th installment...');
6566: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
6567: ,p_loan_id => l_loan_id
6568: ,p_installment => 0
6569: ,p_fee_basis_tbl => l_fee_basis_tbl
6570: ,p_based_on_terms => p_based_on_terms

Line 6810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');

6806: l_fee_basis_tbl(8).fee_basis_amount := l_amortization_rec.UNPAID_INT;
6807: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
6808: l_fee_basis_tbl(9).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT;
6809:
6810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
6811: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
6812: ,p_loan_id => l_loan_id
6813: ,p_installment => l_installment_number
6814: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 6811: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

6807: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
6808: l_fee_basis_tbl(9).fee_basis_amount := p_loan_details.requested_amount + p_loan_details.ADD_REQUESTED_AMOUNT;
6809:
6810: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
6811: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
6812: ,p_loan_id => l_loan_id
6813: ,p_installment => l_installment_number
6814: ,p_fee_basis_tbl => l_fee_basis_tbl
6815: ,p_based_on_terms => p_based_on_terms

Line 9075: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

9071: l_penal_int_int_detail_str varchar2(2000);
9072: l_penal_int_detail_str varchar2(2000);
9073: l_early_pay_cr_detail_str varchar2(2000);
9074:
9075: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
9076: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
9077: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
9078: l_rate_details LNS_FINANCIALS.INTEREST_RATE_REC;
9079:

Line 9076: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;

9072: l_penal_int_detail_str varchar2(2000);
9073: l_early_pay_cr_detail_str varchar2(2000);
9074:
9075: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
9076: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
9077: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
9078: l_rate_details LNS_FINANCIALS.INTEREST_RATE_REC;
9079:
9080: cursor c_additional_fees(p_loan_id number, p_phase varchar2, p_installment number) is

Line 9077: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

9073: l_early_pay_cr_detail_str varchar2(2000);
9074:
9075: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
9076: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
9077: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
9078: l_rate_details LNS_FINANCIALS.INTEREST_RATE_REC;
9079:
9080: cursor c_additional_fees(p_loan_id number, p_phase varchar2, p_installment number) is
9081: select nvl(sum(sched.fee_amount), 0)

Line 9175: lns_fee_engine.processLateFees(p_loan_id => p_loan_id

9171: RAISE FND_API.G_EXC_ERROR;
9172: END IF;
9173:
9174: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - processing late fees');
9175: lns_fee_engine.processLateFees(p_loan_id => p_loan_id
9176: ,p_init_msg_list => p_init_msg_list
9177: ,p_commit => 'F'
9178: ,p_phase => l_loan_details.LOAN_PHASE
9179: ,x_return_status => l_return_status

Line 9207: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_FALSE

9203: l_fee_basis_tbl(7).fee_basis_amount := l_loan_details.requested_amount + l_loan_details.ADD_REQUESTED_AMOUNT - l_loan_details.funded_amount;
9204: l_fee_basis_tbl(8).fee_basis_name := 'OVERDUE_INT';
9205: l_fee_basis_tbl(8).fee_basis_amount := l_loan_details.UNPAID_INTEREST;
9206:
9207: lns_fee_engine.processFees(p_init_msg_list => FND_API.G_FALSE
9208: ,p_commit => FND_API.G_FALSE
9209: ,p_loan_id => p_loan_id
9210: ,p_installment_number => -1
9211: ,p_fee_basis_tbl => l_fee_basis_tbl