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

Line 5505: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;

5501:
5502: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5503: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5504: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5505: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5506: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5507: l_event_table lns_distributions_pub.acc_event_tbl;
5508: l_funded_lines_count number;
5509: l_dates_shifted_flag varchar2(1) := 'N';

Line 5607: from LNS_TERMS

5603: -- query term version
5604: CURSOR term_version_cur(P_LOAN_ID number) IS
5605: select TERM_ID,
5606: OBJECT_VERSION_NUMBER
5607: from LNS_TERMS
5608: where LOAN_ID = P_LOAN_ID;
5609:
5610: -- check to start billing for 0-th installment
5611: CURSOR do_billing_cur(C_LOAN_ID number, C_PHASE varchar2) IS

Line 5952: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');

5948: end if;
5949:
5950: end if;
5951:
5952: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');
5953: LogMessage(FND_LOG.LEVEL_STATEMENT, 'TERM_ID: ' || l_term_rec.TERM_ID);
5954: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
5955: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OPEN_FIRST_PAYMENT_DATE: ' || l_term_rec.OPEN_FIRST_PAYMENT_DATE);
5956: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OPEN_NEXT_PAYMENT_DATE: ' || l_term_rec.OPEN_NEXT_PAYMENT_DATE);

Line 5961: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER,

5957: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
5958: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRIN_FIRST_PAY_DATE: ' || l_term_rec.PRIN_FIRST_PAY_DATE);
5959: LogMessage(FND_LOG.LEVEL_STATEMENT, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
5960:
5961: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER,
5962: p_init_msg_list => FND_API.G_FALSE,
5963: p_loan_term_rec => l_term_rec,
5964: X_RETURN_STATUS => l_return_status,
5965: X_MSG_COUNT => l_msg_count,

Line 5971: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');

5967:
5968: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5969:
5970: IF l_return_status = 'S' THEN
5971: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
5972: ELSE
5973: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
5974: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
5975: FND_MSG_PUB.Add;

Line 5973: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));

5969:
5970: IF l_return_status = 'S' THEN
5971: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
5972: ELSE
5973: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
5974: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
5975: FND_MSG_PUB.Add;
5976: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5977: RAISE FND_API.G_EXC_ERROR;

Line 6051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');

6047: l_term_rec.FIRST_PAYMENT_DATE := l_loan_details.first_payment_Date;
6048: l_term_rec.PRIN_FIRST_PAY_DATE := l_loan_details.PRIN_FIRST_PAY_DATE; -- fix for bug 6938095
6049: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
6050:
6051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');
6052: LogMessage(FND_LOG.LEVEL_STATEMENT, 'TERM_ID: ' || l_term_rec.TERM_ID);
6053: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
6054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
6055: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRIN_FIRST_PAY_DATE: ' || l_term_rec.PRIN_FIRST_PAY_DATE);

Line 6058: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER,

6054: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
6055: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRIN_FIRST_PAY_DATE: ' || l_term_rec.PRIN_FIRST_PAY_DATE);
6056: LogMessage(FND_LOG.LEVEL_STATEMENT, 'NEXT_PAYMENT_DUE_DATE: ' || l_term_rec.NEXT_PAYMENT_DUE_DATE);
6057:
6058: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER,
6059: p_init_msg_list => FND_API.G_FALSE,
6060: p_loan_term_rec => l_term_rec,
6061: X_RETURN_STATUS => l_return_status,
6062: X_MSG_COUNT => l_msg_count,

Line 6068: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');

6064:
6065: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
6066:
6067: IF l_return_status = 'S' THEN
6068: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
6069: ELSE
6070: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
6071: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
6072: FND_MSG_PUB.Add;

Line 6070: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));

6066:
6067: IF l_return_status = 'S' THEN
6068: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
6069: ELSE
6070: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
6071: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
6072: FND_MSG_PUB.Add;
6073: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6074: RAISE FND_API.G_EXC_ERROR;

Line 6201: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');

6197: l_term_rec.FIRST_PAYMENT_DATE := l_loan_details.first_payment_Date;
6198: l_term_rec.PRIN_FIRST_PAY_DATE := l_loan_details.PRIN_FIRST_PAY_DATE; -- fix for bug 6938095
6199: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
6200:
6201: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');
6202: LogMessage(FND_LOG.LEVEL_STATEMENT, 'TERM_ID: ' || l_term_rec.TERM_ID);
6203: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_term_rec.LOAN_ID);
6204: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FIRST_PAYMENT_DATE: ' || l_term_rec.FIRST_PAYMENT_DATE);
6205: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRIN_FIRST_PAY_DATE: ' || l_term_rec.PRIN_FIRST_PAY_DATE);

Line 6216: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER,

6212: l_agreement_reason := l_agreement_reason || FND_MSG_PUB.Get(p_encoded => 'F');
6213: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
6214: end if;
6215:
6216: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_TERM_VERSION_NUMBER,
6217: p_init_msg_list => FND_API.G_FALSE,
6218: p_loan_term_rec => l_term_rec,
6219: X_RETURN_STATUS => l_return_status,
6220: X_MSG_COUNT => l_msg_count,

Line 6226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');

6222:
6223: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
6224:
6225: IF l_return_status = 'S' THEN
6226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
6227: ELSE
6228: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
6229: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
6230: FND_MSG_PUB.Add;

Line 6228: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));

6224:
6225: IF l_return_status = 'S' THEN
6226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
6227: ELSE
6228: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
6229: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
6230: FND_MSG_PUB.Add;
6231: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6232: RAISE FND_API.G_EXC_ERROR;

Line 8938: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;

8934: l_request_msg varchar2(240);
8935: l_request_status boolean;
8936: l_do_billing number;
8937:
8938: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
8939: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8940: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
8941:
8942: /*-----------------------------------------------------------------------+