455: l_customized varchar2(1);
456: l_offset number(38);
457: l_statement_xml clob;
458: x_billed_yn varchar2(1);
459: l_fee_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
460: l_appr_dist_cnt NUMBER;
461: l_return_status VARCHAR2(1);
462: l_msg_count NUMBER;
463: l_msg_data VARCHAR2(32767);
860: /* Bug#9255294 - No need to call this now, as the below method inserts records of conversionFees into feeSchds table
861: However, now the conversionFees insert into feeScheds when this fee is assigned to the loan
862:
863: --Process Conversion Fees
864: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before calling lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
865: lns_fee_engine.processDisbursementFees(p_init_msg_list => FND_API.G_TRUE
866: ,p_commit => FND_API.G_FALSE
867: ,p_phase => 'TERM'
868: ,p_loan_id => l_loan_header_rec.loan_id
861: However, now the conversionFees insert into feeScheds when this fee is assigned to the loan
862:
863: --Process Conversion Fees
864: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before calling lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
865: lns_fee_engine.processDisbursementFees(p_init_msg_list => FND_API.G_TRUE
866: ,p_commit => FND_API.G_FALSE
867: ,p_phase => 'TERM'
868: ,p_loan_id => l_loan_header_rec.loan_id
869: ,p_disb_head_id => NULL
870: ,x_return_status => x_return_status
871: ,x_msg_count => x_msg_count
872: ,x_msg_data => x_msg_data);
873:
874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
875:
876: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for TERM phase failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
878: l_last_api_called := 'lns_fee_engine.processDisbursementFees';
873:
874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
875:
876: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for TERM phase failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
878: l_last_api_called := 'lns_fee_engine.processDisbursementFees';
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881: */
874: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for permanent conversion to TERM phase');
875:
876: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
877: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - lns_fee_engine.processDisbursementFees to process Conversion fees for TERM phase failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
878: l_last_api_called := 'lns_fee_engine.processDisbursementFees';
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881: */
882: /**********************End Permanent Conversion to Term Phase*************/
934:
935: /* Bug#8937530get Billed and Reversed 'Submit For Approval' Fees using getSubmitForApprFeeSchedule*/
936: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling Billed LNS_FEES_ENGINE.getSubmitForApprFeeSchedule...');
937:
938: LNS_FEE_ENGINE.getSubmitForApprFeeSchedule(p_init_msg_list => FND_API.G_TRUE,
939: p_loan_Id => l_approval_action_rec.loan_id,
940: p_billed_flag => 'Y',
941: x_fees_tbl => l_fee_tbl,
942: X_RETURN_STATUS => l_return_status,