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 507: from LNS_TERMS

503: /* query term version */
504: CURSOR term_version_cur(P_LOAN_ID number) IS
505: select TERM_ID
506: ,OBJECT_VERSION_NUMBER
507: from LNS_TERMS
508: where LOAN_ID = P_LOAN_ID;
509:
510: CURSOR loan_version_cur(P_LOAN_ID number) IS
511: select OBJECT_VERSION_NUMBER

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

726: l_term_rec.LOAN_ID := l_loan_header_rec.loan_id;
727: l_term_rec.FIRST_PAYMENT_DATE := l_loan_details.first_payment_Date;
728: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
729:
730: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updating lns_terms w following values:');
731: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'TERM_ID: ' || l_term_rec.TERM_ID);
732: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
733: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
734: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);

Line 736: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER

732: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
733: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
734: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
735:
736: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER
737: ,p_init_msg_list => FND_API.G_FALSE
738: ,p_loan_term_rec => l_term_rec
739: ,X_RETURN_STATUS => x_return_status
740: ,X_MSG_COUNT => x_msg_count

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

742:
743: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'x_return_status: ' || x_return_status);
744:
745: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
747: ELSE
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
749: FND_MSG_PUB.Add;
750: 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 750: 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'));

746: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Successfully update LNS_TERMS');
747: ELSE
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
749: FND_MSG_PUB.Add;
750: 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'));
751: l_last_api_called := 'LNS_TERMS_PUB.update_term';
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754:

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

747: ELSE
748: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
749: FND_MSG_PUB.Add;
750: 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'));
751: l_last_api_called := 'LNS_TERMS_PUB.update_term';
752: RAISE FND_API.G_EXC_ERROR;
753: END IF;
754:
755: /* setting data for future loan update */

Line 938: from lns_terms

934: if l_customized = 'Y' then
935:
936: -- getting terms version for future update
937: select term_id, object_version_number into l_term_id, l_object_version_number
938: from lns_terms
939: where loan_id = l_loan_header_rec.loan_id;
940:
941: -- Updating terms
942: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

939: where loan_id = l_loan_header_rec.loan_id;
940:
941: -- Updating terms
942: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_terms...');
944: END IF;
945:
946: l_term_rec.TERM_ID := l_term_id;
947: l_term_rec.LOAN_ID := l_loan_header_rec.loan_id;

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

946: l_term_rec.TERM_ID := l_term_id;
947: l_term_rec.LOAN_ID := l_loan_header_rec.loan_id;
948: l_term_rec.ORIG_PAY_CALC_METHOD := FND_API.G_MISS_CHAR;
949:
950: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_object_version_number,
951: p_init_msg_list => FND_API.G_FALSE,
952: p_loan_term_rec => l_term_rec,
953: X_RETURN_STATUS => x_return_status,
954: X_MSG_COUNT => x_msg_count,

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

958: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || x_return_status);
959: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961: ELSE
962: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_TERMS');
963: END IF;
964:
965: end if;
966: