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_APPROVAL_ACTION_PUB dependencies on LNS_TERMS

Line 440: l_term_rec lns_terms_pub.loan_term_rec_type;

436: l_multiple_funding_flag varchar2(1);
437: l_open_to_term_flag varchar2(1);
438: l_budget_req_approval varchar2(1);
439: l_loan_needs_approval varchar2(1);
440: l_term_rec lns_terms_pub.loan_term_rec_type;
441: l_loan_details lns_financials.loan_details_rec; --used for shiftloandates api
442: l_term_id number;
443: l_term_version_number number;
444: -- for xla accounting events

Line 515: from LNS_TERMS

511: /* query term version */
512: CURSOR term_version_cur(P_LOAN_ID number) IS
513: select TERM_ID
514: ,OBJECT_VERSION_NUMBER
515: from LNS_TERMS
516: where LOAN_ID = P_LOAN_ID;
517:
518: CURSOR loan_version_cur(P_LOAN_ID number) IS
519: select OBJECT_VERSION_NUMBER

Line 818: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');

814: l_term_rec.LOAN_ID := l_loan_header_rec.loan_id;
815: l_term_rec.FIRST_PAYMENT_DATE := l_loan_details.first_payment_Date;
816: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
817:
818: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');
819: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'TERM_ID: ' || l_term_rec.TERM_ID);
820: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
821: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
822: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);

Line 824: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER

820: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
821: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
822: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
823:
824: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER
825: ,p_init_msg_list => FND_API.G_FALSE
826: ,p_loan_term_rec => l_term_rec
827: ,X_RETURN_STATUS => x_return_status
828: ,X_MSG_COUNT => x_msg_count

Line 834: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');

830:
831: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'x_return_status: ' || x_return_status);
832:
833: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
834: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
835: ELSE
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
837: FND_MSG_PUB.Add;
838: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));

Line 838: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));

834: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
835: ELSE
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
837: FND_MSG_PUB.Add;
838: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
839: l_last_api_called := 'LNS_TERMS_PUB.update_term';
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842:

Line 839: l_last_api_called := 'LNS_TERMS_PUB.update_term';

835: ELSE
836: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
837: FND_MSG_PUB.Add;
838: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - LNS_TERMS_PUB.update_term failed with message: ' || FND_MSG_PUB.Get(p_encoded => 'F'));
839: l_last_api_called := 'LNS_TERMS_PUB.update_term';
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842:
843: /* setting data for future loan update */

Line 1125: from lns_terms

1121: if l_customized = 'Y' then
1122:
1123: -- getting terms version for future update
1124: select term_id, object_version_number into l_term_id, l_object_version_number
1125: from lns_terms
1126: where loan_id = l_loan_header_rec.loan_id;
1127:
1128: -- Updating terms
1129: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1130: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_terms...');

1126: where loan_id = l_loan_header_rec.loan_id;
1127:
1128: -- Updating terms
1129: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1130: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_terms...');
1131: END IF;
1132:
1133: l_term_rec.TERM_ID := l_term_id;
1134: l_term_rec.LOAN_ID := l_loan_header_rec.loan_id;

Line 1137: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_object_version_number,

1133: l_term_rec.TERM_ID := l_term_id;
1134: l_term_rec.LOAN_ID := l_loan_header_rec.loan_id;
1135: l_term_rec.ORIG_PAY_CALC_METHOD := FND_API.G_MISS_CHAR;
1136:
1137: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_object_version_number,
1138: p_init_msg_list => FND_API.G_FALSE,
1139: p_loan_term_rec => l_term_rec,
1140: X_RETURN_STATUS => x_return_status,
1141: X_MSG_COUNT => x_msg_count,

Line 1150: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');

1146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1148:
1149: ELSE
1150: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');
1151: END IF;
1152:
1153: end if;
1154: