1200: l_approval_action_rec.action_type = 'APPROVE' and
1201: (l_loan_header_rec.loan_status = 'ACTIVE' or l_loan_header_rec.loan_status = 'APPROVED')) then
1202:
1203: -- generate Loan Agreement Report
1204: l_last_api_called := 'LNS_REP_UTILS.STORE_LOAN_AGREEMENT';
1205: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1206: LNS_REP_UTILS.STORE_LOAN_AGREEMENT(l_loan_header_rec.loan_id);
1207: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1208: /*
1201: (l_loan_header_rec.loan_status = 'ACTIVE' or l_loan_header_rec.loan_status = 'APPROVED')) then
1202:
1203: -- generate Loan Agreement Report
1204: l_last_api_called := 'LNS_REP_UTILS.STORE_LOAN_AGREEMENT';
1205: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1206: LNS_REP_UTILS.STORE_LOAN_AGREEMENT(l_loan_header_rec.loan_id);
1207: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1208: /*
1209: -- begin submit request to generate Loan Agreement Report
1202:
1203: -- generate Loan Agreement Report
1204: l_last_api_called := 'LNS_REP_UTILS.STORE_LOAN_AGREEMENT';
1205: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1206: LNS_REP_UTILS.STORE_LOAN_AGREEMENT(l_loan_header_rec.loan_id);
1207: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1208: /*
1209: -- begin submit request to generate Loan Agreement Report
1210: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1203: -- generate Loan Agreement Report
1204: l_last_api_called := 'LNS_REP_UTILS.STORE_LOAN_AGREEMENT';
1205: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1206: LNS_REP_UTILS.STORE_LOAN_AGREEMENT(l_loan_header_rec.loan_id);
1207: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_REP_UTILS.STORE_LOAN_AGREEMENT');
1208: /*
1209: -- begin submit request to generate Loan Agreement Report
1210: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' Before calling FND_REQUEST.SUBMIT_REQUEST for LNS_AGREEMENT (Loan Agreement Report) for loan_id: ' || l_loan_header_rec.loan_id);
1211: l_notify := FND_REQUEST.ADD_NOTIFICATION(FND_GLOBAL.USER_NAME);
1794: FND_MSG_PUB.Add;
1795: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1796: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
1797:
1798: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);
1799:
1800: if P_COMMIT = FND_API.G_TRUE then
1801: COMMIT WORK;
1802: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
1997: FND_MSG_PUB.Add;
1998: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
1999: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
2000:
2001: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);
2002:
2003: if P_COMMIT = FND_API.G_TRUE then
2004: COMMIT WORK;
2005: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');