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_UTILITY_PUB

Line 858: ,lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')) line_type

854: ,trx_number
855: ,tty.name
856: ,amount_due_remaining
857: ,am.due_date
858: ,lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', decode(ps.customer_trx_id, principal_trx_Id, 'PRIN', interest_trx_id, 'INT', fee_trx_id, 'FEE')) line_type
859: from lns_amortization_scheds am
860: ,ar_payment_schedules ps
861: ,ra_cust_trx_types tty
862: where (am.principal_trx_id = ps.customer_trx_id OR

Line 1020: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);

1016: i := i + 1;
1017: l_invoices_tbl(i).CUST_TRX_ID := null;
1018: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;
1019: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1020: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);
1021: l_invoices_tbl(i).REMAINING_AMOUNT := l_payoff_tbl2(k).unbilled_amount;
1022: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1023: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1024: l_invoices_tbl(i).BILLED_FLAG := 'N';

Line 1023: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);

1019: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1020: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);
1021: l_invoices_tbl(i).REMAINING_AMOUNT := l_payoff_tbl2(k).unbilled_amount;
1022: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1023: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1024: l_invoices_tbl(i).BILLED_FLAG := 'N';
1025:
1026:
1027: elsif l_payoff_tbl2(k).unbilled_amount < 0 and l_payoff_tbl2(k).PAYOFF_PURPOSE = 'INT' then

Line 1050: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);

1046: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1047: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1048: l_invoices_tbl(i).TRANSACTION_TYPE := l_credit_name;
1049: l_invoices_tbl(i).REMAINING_AMOUNT := - l_last_interest;
1050: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1051: l_invoices_tbl(i).BILLED_FLAG := 'N';
1052:
1053: if l_last_interest + l_payoff_tbl2(k).unbilled_amount > 0 then
1054: -- new interest document

Line 1060: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);

1056: l_invoices_tbl(i).CUST_TRX_ID := null;
1057: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_installment;
1058: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1059: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1060: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);
1061: l_invoices_tbl(i).REMAINING_AMOUNT := l_last_interest + l_payoff_tbl2(k).unbilled_amount;
1062: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1063: l_invoices_tbl(i).BILLED_FLAG := 'N';
1064: end if;

Line 1062: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);

1058: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1059: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1060: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(l_payoff_tbl2(k).PAYOFF_PURPOSE);
1061: l_invoices_tbl(i).REMAINING_AMOUNT := l_last_interest + l_payoff_tbl2(k).unbilled_amount;
1062: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', l_payoff_tbl2(k).PAYOFF_PURPOSE);
1063: l_invoices_tbl(i).BILLED_FLAG := 'N';
1064: end if;
1065:
1066: end if;

Line 1083: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');

1079: l_invoices_tbl(i).CUST_TRX_ID := null;
1080: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_fee_installment;
1081: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1082: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1083: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
1084: l_invoices_tbl(i).REMAINING_AMOUNT := l_fee_amount;
1085: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE');
1086: l_invoices_tbl(i).BILLED_FLAG := 'N';
1087: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');

Line 1085: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE');

1081: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
1082: l_invoices_tbl(i).DUE_DATE := p_payoff_date;
1083: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
1084: l_invoices_tbl(i).REMAINING_AMOUNT := l_fee_amount;
1085: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE');
1086: l_invoices_tbl(i).BILLED_FLAG := 'N';
1087: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - fee found');
1088: end loop;
1089: close c_fees;