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_PAYOFF_PUB dependencies on LNS_FINANCIALS

Line 82: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;

78: l_api_version_number number;
79: l_return_status VARCHAR2(1);
80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(32767);
82: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
83: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
84: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
85: l_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL;
86: l_add_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL; -- for unapplied crs on last interest document only

Line 83: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

79: l_return_status VARCHAR2(1);
80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(32767);
82: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
83: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
84: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
85: l_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL;
86: l_add_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL; -- for unapplied crs on last interest document only
87: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation

Line 268: lns_financials.calculatePayoff(p_api_version => 1.0

264: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LOAN CURRENCY ' || l_loan_currency);
265: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - loan_exchange_rate ' || l_loan_exchange_rate);
266:
267: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - calculating Payoff ');
268: lns_financials.calculatePayoff(p_api_version => 1.0
269: ,p_init_msg_list => p_init_msg_list
270: ,p_loan_id => p_loan_id
271: ,p_payoff_date => p_payoff_date
272: ,x_payoff_tbl => l_payoff_tbl2

Line 822: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;

818: l_msg_count NUMBER;
819: l_msg_data VARCHAR2(32767);
820:
821: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
822: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
823: i number;
824: l_cust_trx_id number;
825: l_payment_schedule_id number;
826: l_invoice_number varchar2(60);

Line 918: lns_financials.calculatePayoff(p_api_version => 1.0

914: -- get the additional records "to be created"
915: if p_payoff_date is not null then
916: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - getting addition TO BE CREATED documents');
917: --dbms_output.put_line('calculating payoof amounts');
918: lns_financials.calculatePayoff(p_api_version => 1.0
919: ,p_init_msg_list => p_init_msg_list
920: ,p_loan_id => p_loan_id
921: ,p_payoff_date => p_payoff_date
922: ,x_payoff_tbl => l_payoff_tbl2

Line 1420: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;

1416: l_msg_count NUMBER;
1417: l_msg_data VARCHAR2(32767);
1418:
1419: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;
1420: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
1421: i number;
1422: l_cust_trx_id number;
1423: l_payment_schedule_id number;
1424: l_invoice_number varchar2(60);

Line 1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');

1584: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_phase = ' || l_phase);
1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);
1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);
1587:
1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1589: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1590: ,p_init_msg_list => FND_API.G_TRUE
1591: ,p_loan_id => p_loan_id
1592: ,p_date => p_cancellation_date

Line 1589: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0

1585: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_class = ' || l_class);
1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);
1587:
1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1589: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1590: ,p_init_msg_list => FND_API.G_TRUE
1591: ,p_loan_id => p_loan_id
1592: ,p_date => p_cancellation_date
1593: ,p_reason => 'LOAN_CANCELLATION'

Line 1833: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;

1829: l_payoff_billed_int number;
1830: l_payoff_unbilled_fee number;
1831: l_payoff_billed_fee number;
1832:
1833: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
1834:
1835: CURSOR pending_count_cur(P_LOAN_ID number) IS
1836: select count(1)
1837: from LNS_LOAN_CANCELLATIONS

Line 1931: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');

1927: end if;
1928:
1929: end if;
1930:
1931: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1932: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1933: ,p_init_msg_list => FND_API.G_TRUE
1934: ,p_loan_id => p_loan_id
1935: ,p_date => p_cancellation_date

Line 1932: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0

1928:
1929: end if;
1930:
1931: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1932: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1933: ,p_init_msg_list => FND_API.G_TRUE
1934: ,p_loan_id => p_loan_id
1935: ,p_date => p_cancellation_date
1936: ,p_reason => 'LOAN_CANCELLATION'

Line 2086: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;

2082: l_payoff_billed_int number;
2083: l_payoff_unbilled_fee number;
2084: l_payoff_billed_fee number;
2085:
2086: l_payoff_tbl2 LNS_FINANCIALS.PAYOFF_TBL2;
2087:
2088: CURSOR loan_details_cur(P_LOAN_ID number) IS
2089: select LOAN_STATUS
2090: from lns_loan_headers_all

Line 2167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');

2163: end if;
2164:
2165: if (P_ACTION = 'APPROVE') then
2166:
2167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
2168: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
2169: ,p_init_msg_list => FND_API.G_TRUE
2170: ,p_loan_id => l_LOAN_ID
2171: ,p_date => l_cancellation_date

Line 2168: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0

2164:
2165: if (P_ACTION = 'APPROVE') then
2166:
2167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
2168: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
2169: ,p_init_msg_list => FND_API.G_TRUE
2170: ,p_loan_id => l_LOAN_ID
2171: ,p_date => l_cancellation_date
2172: ,p_reason => 'LOAN_CANCELLATION'