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_FEE_SCHEDULES

Line 594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_schedules...');

590: where loan_id = l_loan_id
591: and (end_date_active is null OR end_date_active > P_PAYOFF_DATE);
592: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_assignments is updated');
593:
594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_schedules...');
595: update lns_fee_schedules
596: set billed_flag = 'Y'
597: where loan_id = l_loan_id
598: and active_flag = 'Y'

Line 595: update lns_fee_schedules

591: and (end_date_active is null OR end_date_active > P_PAYOFF_DATE);
592: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_assignments is updated');
593:
594: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_fee_schedules...');
595: update lns_fee_schedules
596: set billed_flag = 'Y'
597: where loan_id = l_loan_id
598: and active_flag = 'Y'
599: and billed_flag = 'N'

Line 601: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_schedules is updated');

597: where loan_id = l_loan_id
598: and active_flag = 'Y'
599: and billed_flag = 'N'
600: and object_version_number = object_version_number + 1;
601: LogMessage(FND_LOG.LEVEL_STATEMENT, 'lns_fee_schedules is updated');
602:
603: /* updating loan header table */
604: l_loan_header_rec.loan_id := l_loan_id;
605: l_loan_header_rec.LOAN_STATUS := 'PAIDOFF';

Line 1228: from lns_fee_schedules

1224: and status = 'A';
1225:
1226: CURSOR cur_get_disbHdr_id(c_fee_schd_id number) IS
1227: SELECT disb_header_id
1228: from lns_fee_schedules
1229: where fee_schedule_id =c_fee_schd_id;
1230:
1231: BEGIN
1232: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');

Line 4250: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */

4246: RAISE FND_API.G_EXC_ERROR;
4247:
4248: end if;
4249:
4250: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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',

Line 4251: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_FEE_SCHEDULES with billed_flag = Y ...');

4247:
4248: end if;
4249:
4250: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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,

Line 4252: UPDATE LNS_FEE_SCHEDULES

4248: end if;
4249:
4250: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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,

Line 4260: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');

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:
4262: END LOOP;
4263:
4264: /* validate principal amount */

Line 5889: | 07-31-2006 karamach Added code to update active_flag to N in lns_fee_schedules for unbilled manual fees to fix bug5397345

5885: | 01-01-2004 scherkas Created
5886: | 01-20-2006 raverma delete row from rate_scheds for variable rate loan
5887: | 06-16-2006 karamach Removed code that deleted the rate sch row from lns_rate_schedules
5888: | and added fix in LNS_FINANCIAL_B.pls floatingRatePostProcessing procedure to update existing row to fix bug5331888
5889: | 07-31-2006 karamach Added code to update active_flag to N in lns_fee_schedules for unbilled manual fees to fix bug5397345
5890: *=======================================================================*/
5891: PROCEDURE REVERSE_LAST_AMORTIZATION(
5892: P_API_VERSION IN NUMBER,
5893: P_INIT_MSG_LIST IN VARCHAR2,

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 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');

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;
6257:
6258: -- END OF BODY OF API

Line 7430: -- If the loanStatus is INCOMPLETE, then only update the lns_fee_schedules.billed_flag = 'N' for the submitForApproval fees

7426: SELECT lhdr.loan_status INTO l_lns_status FROM lns_loan_headers lhdr WHERE lhdr.loan_id = l_LOAN_ID;
7427:
7428: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The LoanStatus of loanid '||l_LOAN_ID||' is '||l_lns_status) ;
7429:
7430: -- If the loanStatus is INCOMPLETE, then only update the lns_fee_schedules.billed_flag = 'N' for the submitForApproval fees
7431: IF l_lns_status = 'INCOMPLETE' THEN
7432: REVERSE_BILLED_FEES(p_amortization_id);
7433: END IF;
7434:

Line 8096: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */

8092: RAISE FND_API.G_EXC_ERROR;
8093:
8094: end if;
8095:
8096: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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',

Line 8097: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_FEE_SCHEDULES with billed_flag = Y ...');

8093:
8094: end if;
8095:
8096: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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,

Line 8098: UPDATE LNS_FEE_SCHEDULES

8094: end if;
8095:
8096: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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,

Line 8106: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');

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:
8108: END LOOP;
8109:
8110: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_BATCH_PUB.CREATE_OFFCYCLE_BILLS...');

Line 10610: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */

10606: l_BILL_LINES_TBL(l_Count1).LINE_DESC := l_fee_tbl(l_Count).FEE_NAME;
10607: l_BILL_LINES_TBL(l_Count1).FEE_SCHEDULE_ID := l_fee_tbl(l_Count).FEE_SCHEDULE_ID;
10608: l_tot_fee_amt := l_tot_fee_amt + l_fee_tbl(l_Count).FEE_AMOUNT;
10609:
10610: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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',

Line 10611: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_FEE_SCHEDULES with billed_flag = Y ...');

10607: l_BILL_LINES_TBL(l_Count1).FEE_SCHEDULE_ID := l_fee_tbl(l_Count).FEE_SCHEDULE_ID;
10608: l_tot_fee_amt := l_tot_fee_amt + l_fee_tbl(l_Count).FEE_AMOUNT;
10609:
10610: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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,

Line 10612: UPDATE LNS_FEE_SCHEDULES

10608: l_tot_fee_amt := l_tot_fee_amt + l_fee_tbl(l_Count).FEE_AMOUNT;
10609:
10610: /* updating LNS_FEE_SCHEDULES with billed_flag = Y */
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,

Line 10620: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_FEE_SCHEDULES');

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:
10622: END LOOP;
10623:
10624: IF (l_tot_fee_amt = 0) THEN

Line 10691: l_fee_schedule_id LNS_FEE_SCHEDULES.fee_schedule_id%TYPE;

10687:
10688: PROCEDURE REVERSE_BILLED_FEES(p_amortization_id IN NUMBER)
10689: IS
10690: l_api_name CONSTANT VARCHAR2(30) := 'REVERSE_BILLED_FEES';
10691: l_fee_schedule_id LNS_FEE_SCHEDULES.fee_schedule_id%TYPE;
10692: l_obj_ver_num NUMBER;
10693: l_count NUMBER;
10694:
10695: -- At present Reversing only SubmitForApproval Fees

Line 10698: FROM LNS_AMORTIZATION_SCHEDS scheds,lns_amortization_lines lines, lns_fees_all fee, lns_fee_schedules feeSchd

10694:
10695: -- At present Reversing only SubmitForApproval Fees
10696: CURSOR c_billed_submitAppFee(c_amortization_id NUMBER) IS
10697: SELECT lines.fee_schedule_id, feeSchd.object_version_number
10698: FROM LNS_AMORTIZATION_SCHEDS scheds,lns_amortization_lines lines, lns_fees_all fee, lns_fee_schedules feeSchd
10699: WHERE scheds.amortization_schedule_id = lines.amortization_schedule_id
10700: AND scheds.amortization_schedule_id = C_AMORTIZATION_ID
10701: AND lines.line_type = 'FEE'
10702: AND fee.fee_id = lines.fee_id

Line 10727: LNS_FEE_SCHEDULES_PKG.UPDATE_ROW(P_FEE_SCHEDULE_ID => l_fee_schedule_id

10723: FETCH c_billed_submitAppFee into l_fee_schedule_id, l_obj_ver_num;
10724: EXIT WHEN c_billed_submitAppFee%NOTFOUND;
10725: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'The fee_schedule_id is '||l_fee_schedule_id);
10726:
10727: LNS_FEE_SCHEDULES_PKG.UPDATE_ROW(P_FEE_SCHEDULE_ID => l_fee_schedule_id
10728: ,P_FEE_ID => null
10729: ,P_LOAN_ID => null
10730: ,P_FEE_AMOUNT => null
10731: ,P_FEE_INSTALLMENT => null