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_BILLING_BATCH_PUB dependencies on LNS_LOAN_HEADER_PUB

Line 325: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

321: l_old_last_payment_number number;
322: l_old_amortization_id number;
323: l_current_phase varchar2(30);
324:
325: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
326:
327: /*-----------------------------------------------------------------------+
328: | Cursor Declarations |
329: +-----------------------------------------------------------------------*/

Line 408: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

404: end if;
405:
406: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
407:
408: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
409: P_LOAN_HEADER_REC => l_loan_header_rec,
410: P_INIT_MSG_LIST => FND_API.G_FALSE,
411: X_RETURN_STATUS => l_return_status,
412: X_MSG_COUNT => l_msg_count,

Line 496: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

492: l_remaining_amount number;
493: l_end date;
494: l_start date;
495:
496: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
497:
498: /*-----------------------------------------------------------------------+
499: | Cursor Declarations |
500: +-----------------------------------------------------------------------*/

Line 612: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

608: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header info w following values:');
609: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);
610: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Secondary status: ' || l_loan_header_rec.SECONDARY_STATUS);
611:
612: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
613: P_LOAN_HEADER_REC => l_loan_header_rec,
614: P_INIT_MSG_LIST => FND_API.G_FALSE,
615: X_RETURN_STATUS => l_return_status,
616: X_MSG_COUNT => l_msg_count,

Line 734: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

730: l_loan_number varchar2(60);
731: l_end date;
732: l_start date;
733:
734: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
735:
736: /*-----------------------------------------------------------------------+
737: | Cursor Declarations |
738: +-----------------------------------------------------------------------*/

Line 785: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

781:
782: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header info w following values:');
783: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);
784:
785: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
786: P_LOAN_HEADER_REC => l_loan_header_rec,
787: P_INIT_MSG_LIST => FND_API.G_FALSE,
788: X_RETURN_STATUS => l_return_status,
789: X_MSG_COUNT => l_msg_count,

Line 3858: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

3854: -- l_floating_flag varchar2(1);
3855: l_create_zero_instal varchar2(1);
3856: l_profile_name VARCHAR2(240);
3857:
3858: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3859: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3860: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3861: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
3862: l_is_disable_bill varchar2(1);

Line 4297: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => P_LOAN_REC.OBJECT_VERSION_NUMBER,

4293: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header info w following values:');
4294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BILLED_FLAG: ' || l_loan_header_rec.BILLED_FLAG);
4295: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LAST_BILLED_DATE: ' || l_loan_header_rec.LAST_BILLED_DATE);
4296:
4297: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => P_LOAN_REC.OBJECT_VERSION_NUMBER,
4298: P_LOAN_HEADER_REC => l_loan_header_rec,
4299: P_INIT_MSG_LIST => FND_API.G_FALSE,
4300: X_RETURN_STATUS => l_return_status,
4301: X_MSG_COUNT => l_msg_count,

Line 4309: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));

4305:
4306: IF l_return_status = 'S' THEN
4307: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4308: ELSE
4309: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4310: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4311: FND_MSG_PUB.Add;
4312: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4313: RAISE FND_API.G_EXC_ERROR;

Line 4478: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

4474: l_cur_phase varchar2(30);
4475: l_end date;
4476: l_start date;
4477:
4478: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4479: l_amortization_rec lns_financials.AMORTIZATION_REC;
4480: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
4481:
4482: /*-----------------------------------------------------------------------+

Line 4586: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_object_version_number,

4582: l_loan_header_rec.loan_id := P_LOAN_NEXT_DD_REC.LOAN_ID;
4583: l_loan_header_rec.BILLED_FLAG := 'N';
4584: l_object_version_number := P_LOAN_NEXT_DD_REC.OBJECT_VERSION_NUMBER;
4585:
4586: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_object_version_number,
4587: P_LOAN_HEADER_REC => l_loan_header_rec,
4588: P_INIT_MSG_LIST => FND_API.G_FALSE,
4589: X_RETURN_STATUS => l_return_status,
4590: X_MSG_COUNT => l_msg_count,

Line 4598: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));

4594:
4595: IF l_return_status = 'S' THEN
4596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4597: ELSE
4598: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4599: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4600: FND_MSG_PUB.Add;
4601: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4602: RAISE FND_API.G_EXC_ERROR;

Line 6638: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

6634: l_Count NUMBER;
6635: l_prin_balance number;
6636: l_funded_amount number;
6637:
6638: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
6639: l_loan_rec LNS_BILLING_BATCH_PUB.LOAN_TO_BILL_REC;
6640: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
6641:
6642: /*-----------------------------------------------------------------------+