[Home] [Help]
3156: close move_maturity_date_cur;
3157:
3158: if l_move_maturity_date = -1 then
3159:
3160: lns_financials.shiftLoan(
3161: p_loan_id => P_LOAN_ID
3162: ,p_init_msg_list => FND_API.G_TRUE
3163: ,p_commit => FND_API.G_FALSE
3164: ,x_return_status => l_return_status
3165: ,x_msg_count => l_msg_count
3166: ,x_msg_data => l_msg_data);
3167:
3168: IF l_return_status <> 'S' THEN
3169: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to lns_financials.shiftLoan failed');
3170: RAISE FND_API.G_EXC_ERROR;
3171: END IF;
3172:
3173: end if;
4862: l_submit_disb varchar2(1);
4863: l_status_code varchar2(10);
4864: l_funds_reserved_flag varchar2(1);
4865: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4866: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
4867:
4868: /*-----------------------------------------------------------------------+
4869: | Cursor Declarations |
4870: +-----------------------------------------------------------------------*/
5219: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5220: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5221: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5222: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5223: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5224: l_event_table lns_distributions_pub.acc_event_tbl;
5225: l_funded_lines_count number;
5226: l_dates_shifted_flag varchar2(1) := 'N';
5227:
5531: l_loan_header_rec.secondary_status <> 'REMAINING_DISB_CANCELLED')) then
5532:
5533: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting new loan dates...');
5534:
5535: LNS_FINANCIALS.shiftLoanDates(p_loan_id => l_loan_header_rec.loan_id
5536: ,p_new_start_date=> l_DISB_LINE_REC.DISBURSEMENT_DATE
5537: ,p_phase => 'TERM'
5538: ,x_loan_details => l_loan_details
5539: ,x_dates_shifted_flag => l_dates_shifted_flag
5541: ,x_msg_count => l_msg_count
5542: ,x_msg_data => l_msg_data);
5543:
5544: IF l_return_status <> 'S' THEN
5545: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to LNS_FINANCIALS.shiftLoanDates failed');
5546: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5547: RAISE FND_API.G_EXC_ERROR;
5548: END IF;
5549:
5759:
5760: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Its first payment for the loan - getting new open loan dates...');
5761: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting new open loan dates...');
5762:
5763: LNS_FINANCIALS.shiftLoanDates(p_loan_id => l_loan_header_rec.loan_id
5764: ,p_new_start_date => l_DISB_LINE_REC.DISBURSEMENT_DATE
5765: ,p_phase => 'OPEN'
5766: ,x_loan_details => l_loan_details
5767: ,x_dates_shifted_flag => l_dates_shifted_flag
5798: -- Bug#6313658 Shifting LoanDates for Term also
5799: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Its first payment for the loan - getting new term loan dates...');
5800: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting new term loan dates...');
5801:
5802: LNS_FINANCIALS.shiftLoanDates(p_loan_id => l_loan_header_rec.loan_id
5803: ,p_new_start_date => l_loan_header_rec.OPEN_MATURITY_DATE
5804: ,p_phase => 'TERM'
5805: ,x_loan_details => l_loan_details
5806: ,x_dates_shifted_flag => l_dates_shifted_flag
5857:
5858: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Its first payment for the loan - getting new loan dates...');
5859: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Getting new loan dates...');
5860:
5861: LNS_FINANCIALS.shiftLoanDates(p_loan_id => l_loan_header_rec.loan_id
5862: ,p_new_start_date => l_DISB_LINE_REC.DISBURSEMENT_DATE
5863: ,p_phase => 'TERM'
5864: ,x_loan_details => l_loan_details
5865: ,x_dates_shifted_flag => l_dates_shifted_flag
8434: l_do_billing number;
8435:
8436: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
8437: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8438: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
8439:
8440: /*-----------------------------------------------------------------------+
8441: | Cursor Declarations |
8442: +-----------------------------------------------------------------------*/