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_UTILITY_PUB

Line 4255: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

4251: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_FEE_SCHEDULES with billed_flag = Y ...');
4252: UPDATE LNS_FEE_SCHEDULES
4253: SET
4254: BILLED_FLAG = 'Y',
4255: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
4256: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
4257: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
4258: WHERE
4259: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;

Line 4256: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,

4252: UPDATE LNS_FEE_SCHEDULES
4253: SET
4254: BILLED_FLAG = 'Y',
4255: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
4256: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
4257: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
4258: WHERE
4259: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
4260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');

Line 4257: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

4253: SET
4254: BILLED_FLAG = 'Y',
4255: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
4256: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
4257: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
4258: WHERE
4259: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
4260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');
4261:

Line 6252: UPDATE LNS_FEE_SCHEDULES SET ACTIVE_FLAG = 'N', LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = lns_utility_pub.last_updated_by, LAST_UPDATE_LOGIN = lns_utility_pub.last_update_login, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

6248: else
6249: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Before inactivating unbilled manual fees for this installment: ' || l_LAST_PAYMENT_NUMBER);
6250: --Bug5397345
6251: --Make sure unbilled manual fees for this reversed installment are inactivated
6252: UPDATE LNS_FEE_SCHEDULES SET ACTIVE_FLAG = 'N', LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = lns_utility_pub.last_updated_by, LAST_UPDATE_LOGIN = lns_utility_pub.last_update_login, OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
6253: WHERE LOAN_ID = P_LOAN_ID AND BILLED_FLAG = 'N' AND FEE_INSTALLMENT = l_LAST_PAYMENT_NUMBER;
6254: LogMessage(FND_LOG.LEVEL_STATEMENT, 'After inactivating unbilled manual fees by updating the active_flag in lns_fee_schedules for this loan and installment');
6255:
6256: end if;

Line 8101: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

8097: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_FEE_SCHEDULES with billed_flag = Y ...');
8098: UPDATE LNS_FEE_SCHEDULES
8099: SET
8100: BILLED_FLAG = 'Y',
8101: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
8102: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
8103: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
8104: WHERE
8105: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;

Line 8102: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,

8098: UPDATE LNS_FEE_SCHEDULES
8099: SET
8100: BILLED_FLAG = 'Y',
8101: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
8102: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
8103: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
8104: WHERE
8105: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
8106: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');

Line 8103: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

8099: SET
8100: BILLED_FLAG = 'Y',
8101: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
8102: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
8103: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
8104: WHERE
8105: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
8106: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');
8107:

Line 8858: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'PRIN');

8854: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
8855: l_invoices_tbl(i).ORIGINAL_AMOUNT := l_amortization_rec.PRINCIPAL_AMOUNT;
8856: l_invoices_tbl(i).TRX_DATE := l_trx_date;
8857: l_invoices_tbl(i).DUE_DATE := l_amortization_rec.due_date;
8858: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'PRIN');
8859: l_invoices_tbl(i).BILLED_FLAG := 'N';
8860: l_invoices_tbl(i).INVOICE_CURRENCY := l_currency;
8861: l_invoices_tbl(i).EXCHANGE_RATE := l_exchange_rate;
8862:

Line 8899: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('INT');

8895: l_invoices_tbl(i).CUST_TRX_ID := null;
8896: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID := null;
8897: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_amortization_rec.INSTALLMENT_NUMBER;
8898: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
8899: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('INT');
8900: l_invoices_tbl(i).ORIGINAL_AMOUNT := l_amortization_rec.INTEREST_AMOUNT;
8901: l_invoices_tbl(i).REMAINING_AMOUNT := l_amortization_rec.INTEREST_AMOUNT;
8902: l_invoices_tbl(i).FORGIVENESS_AMOUNT := 0;
8903: l_invoices_tbl(i).TRX_DATE := l_trx_date;

Line 8905: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'INT');

8901: l_invoices_tbl(i).REMAINING_AMOUNT := l_amortization_rec.INTEREST_AMOUNT;
8902: l_invoices_tbl(i).FORGIVENESS_AMOUNT := 0;
8903: l_invoices_tbl(i).TRX_DATE := l_trx_date;
8904: l_invoices_tbl(i).DUE_DATE := l_amortization_rec.due_date;
8905: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'INT');
8906: l_invoices_tbl(i).BILLED_FLAG := 'N';
8907: l_invoices_tbl(i).INVOICE_CURRENCY := l_currency;
8908: l_invoices_tbl(i).EXCHANGE_RATE := l_exchange_rate;
8909: --l_invoices_tbl(i).GL_DATE := l_invoices_tbl(i).DUE_DATE + nvl(g_day_togl_after_dd, 0);

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

8923: l_invoices_tbl(i).CUST_TRX_ID := null;
8924: l_invoices_tbl(i).PAYMENT_SCHEDULE_ID := null;
8925: l_invoices_tbl(i).INSTALLMENT_NUMBER := l_amortization_rec.INSTALLMENT_NUMBER;
8926: l_invoices_tbl(i).INVOICE_NUMBER := l_invoice_number;
8927: l_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName('FEE');
8928: l_invoices_tbl(i).ORIGINAL_AMOUNT := l_amortization_rec.FEE_AMOUNT;
8929: l_invoices_tbl(i).REMAINING_AMOUNT := l_amortization_rec.FEE_AMOUNT;
8930: l_invoices_tbl(i).FORGIVENESS_AMOUNT := 0;
8931: l_invoices_tbl(i).TRX_DATE := l_trx_date;

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

8929: l_invoices_tbl(i).REMAINING_AMOUNT := l_amortization_rec.FEE_AMOUNT;
8930: l_invoices_tbl(i).FORGIVENESS_AMOUNT := 0;
8931: l_invoices_tbl(i).TRX_DATE := l_trx_date;
8932: l_invoices_tbl(i).DUE_DATE := l_amortization_rec.due_date;
8933: l_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', 'FEE');
8934: l_invoices_tbl(i).BILLED_FLAG := 'N';
8935: l_invoices_tbl(i).INVOICE_CURRENCY := l_currency;
8936: l_invoices_tbl(i).EXCHANGE_RATE := l_exchange_rate;
8937: --l_invoices_tbl(i).GL_DATE := l_invoices_tbl(i).DUE_DATE + nvl(g_day_togl_after_dd, 0);

Line 10089: --x_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(x_invoices_tbl(i).PURPOSE);

10085:
10086: i := i + 1;
10087: x_invoices_tbl(i) := l_invoice_rec;
10088:
10089: --x_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(x_invoices_tbl(i).PURPOSE);
10090: x_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', x_invoices_tbl(i).PURPOSE);
10091: x_invoices_tbl(i).FORGIVENESS_AMOUNT := 0;
10092: x_invoices_tbl(i).BILLED_FLAG := 'Y';
10093:

Line 10090: x_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', x_invoices_tbl(i).PURPOSE);

10086: i := i + 1;
10087: x_invoices_tbl(i) := l_invoice_rec;
10088:
10089: --x_invoices_tbl(i).TRANSACTION_TYPE := lns_utility_pub.getDocumentName(x_invoices_tbl(i).PURPOSE);
10090: x_invoices_tbl(i).PURPOSE := lns_utility_pub.get_lookup_meaning('PAYMENT_APPLICATION_TYPE', x_invoices_tbl(i).PURPOSE);
10091: x_invoices_tbl(i).FORGIVENESS_AMOUNT := 0;
10092: x_invoices_tbl(i).BILLED_FLAG := 'Y';
10093:
10094: END LOOP;

Line 10615: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,

10611: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_FEE_SCHEDULES with billed_flag = Y ...');
10612: UPDATE LNS_FEE_SCHEDULES
10613: SET
10614: BILLED_FLAG = 'Y',
10615: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
10616: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
10617: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
10618: WHERE
10619: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;

Line 10616: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,

10612: UPDATE LNS_FEE_SCHEDULES
10613: SET
10614: BILLED_FLAG = 'Y',
10615: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
10616: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
10617: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
10618: WHERE
10619: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
10620: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');

Line 10617: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

10613: SET
10614: BILLED_FLAG = 'Y',
10615: last_update_date = LNS_UTILITY_PUB.LAST_UPDATE_DATE,
10616: last_updated_by = LNS_UTILITY_PUB.LAST_UPDATED_BY,
10617: last_update_login = LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
10618: WHERE
10619: FEE_SCHEDULE_ID = l_fee_tbl(l_Count).fee_schedule_id;
10620: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');
10621:

Line 10737: ,P_LAST_UPDATED_BY => LNS_UTILITY_PUB.LAST_UPDATED_BY

10733: ,P_ACTIVE_FLAG => null
10734: ,P_BILLED_FLAG => 'N' -- Make BilledFlag to 'N'
10735: ,P_FEE_WAIVABLE_FLAG => null
10736: ,P_WAIVED_AMOUNT => null
10737: ,P_LAST_UPDATED_BY => LNS_UTILITY_PUB.LAST_UPDATED_BY
10738: ,P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.LAST_UPDATE_DATE
10739: ,P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
10740: ,P_PROGRAM_ID => null
10741: ,P_REQUEST_ID => null

Line 10738: ,P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.LAST_UPDATE_DATE

10734: ,P_BILLED_FLAG => 'N' -- Make BilledFlag to 'N'
10735: ,P_FEE_WAIVABLE_FLAG => null
10736: ,P_WAIVED_AMOUNT => null
10737: ,P_LAST_UPDATED_BY => LNS_UTILITY_PUB.LAST_UPDATED_BY
10738: ,P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.LAST_UPDATE_DATE
10739: ,P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
10740: ,P_PROGRAM_ID => null
10741: ,P_REQUEST_ID => null
10742: ,P_OBJECT_VERSION_NUMBER => l_obj_ver_num + 1);

Line 10739: ,P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.LAST_UPDATE_LOGIN

10735: ,P_FEE_WAIVABLE_FLAG => null
10736: ,P_WAIVED_AMOUNT => null
10737: ,P_LAST_UPDATED_BY => LNS_UTILITY_PUB.LAST_UPDATED_BY
10738: ,P_LAST_UPDATE_DATE => LNS_UTILITY_PUB.LAST_UPDATE_DATE
10739: ,P_LAST_UPDATE_LOGIN => LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
10740: ,P_PROGRAM_ID => null
10741: ,P_REQUEST_ID => null
10742: ,P_OBJECT_VERSION_NUMBER => l_obj_ver_num + 1);
10743: l_count := l_count + 1;