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_PAYOFF_PUB dependencies on LNS_BILLING_BATCH_PUB

Line 87: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation

83: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
84: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
85: l_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL;
86: l_add_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL; -- for unapplied crs on last interest document only
87: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
88: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
89: l_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;
90: l_total_payoff_amount number;
91: l_total_receipts_amount number;

Line 88: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation

84: l_invoices_tbl LNS_PAYOFF_PUB.INVOICE_DETAILS_TBL;
85: l_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL;
86: l_add_cash_receipt_ids LNS_PAYOFF_PUB.CASH_RECEIPT_TBL; -- for unapplied crs on last interest document only
87: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
88: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
89: l_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;
90: l_total_payoff_amount number;
91: l_total_receipts_amount number;
92: l_object_version number;

Line 408: LNS_BILLING_BATCH_PUB.CREDIT_AMORTIZATION_PARTIAL(P_API_VERSION => 1.0

404: end loop; --end unapplication loop
405:
406: -- 3. credit document
407: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - crediting final interest document');
408: LNS_BILLING_BATCH_PUB.CREDIT_AMORTIZATION_PARTIAL(P_API_VERSION => 1.0
409: ,P_INIT_MSG_LIST => p_init_msg_list
410: ,P_COMMIT => FND_API.G_FALSE
411: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
412: ,P_LOAN_ID => p_loan_id

Line 475: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0

471: if l_bill_lines_tbl.count >= 1 then
472:
473: -- we have at least 1 invoice to create with amount > 0
474: -- must pass false for commit here or else payoff documents will exist in receivables
475: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0
476: ,p_init_msg_list => FND_API.G_TRUE
477: ,p_commit => FND_API.G_FALSE
478: ,p_validation_level => 100
479: ,p_bill_headers_tbl => l_bill_headers_tbl

Line 668: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - calling LNS_BILLING_BATCH_PUB.processPaidLoans');

664:
665: end loop;
666: -- end of step 5
667:
668: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - calling LNS_BILLING_BATCH_PUB.processPaidLoans');
669: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(P_API_VERSION => 1.0
670: ,P_INIT_MSG_LIST => FND_API.G_FALSE
671: ,P_COMMIT => FND_API.G_FALSE
672: ,P_VALIDATION_LEVEL => 100

Line 669: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(P_API_VERSION => 1.0

665: end loop;
666: -- end of step 5
667:
668: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - calling LNS_BILLING_BATCH_PUB.processPaidLoans');
669: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(P_API_VERSION => 1.0
670: ,P_INIT_MSG_LIST => FND_API.G_FALSE
671: ,P_COMMIT => FND_API.G_FALSE
672: ,P_VALIDATION_LEVEL => 100
673: ,P_LOAN_ID => p_loan_id

Line 2645: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation

2641: l_request_id number;
2642: l_due_date1 date;
2643: l_TRX_DATE date;
2644:
2645: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
2646: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
2647: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
2648: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;
2649: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;

Line 2646: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation

2642: l_due_date1 date;
2643: l_TRX_DATE date;
2644:
2645: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
2646: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
2647: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
2648: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;
2649: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
2650: l_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;

Line 2649: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;

2645: l_bill_headers_tbl LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL; -- for invoice creation
2646: l_bill_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL; -- for invoice creation
2647: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type; -- to update the loan header
2648: l_invoices_tbl LNS_PAYOFF_PUB.LOAN_CANCEL_DETAILS_TBL;
2649: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
2650: l_cm_line_tbl AR_CREDIT_MEMO_API_PUB.Cm_Line_Tbl_Type_Cover%type;
2651:
2652: -- query loan info
2653: CURSOR loan_info_cur(P_LOAN_CANCELLATION_ID number) IS

Line 2880: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ...');

2876: RAISE FND_API.G_EXC_ERROR;
2877: end if;
2878:
2879: -- do adjustment
2880: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ...');
2881: LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ(P_TYPE => 'INVOICE',
2882: P_PAYMENT_SCHEDULE_ID => l_invoices_tbl(i).PAYMENT_SCHEDULE_ID,
2883: P_RECEIVABLES_TRX_ID => l_receivables_trx_id,
2884: P_AMOUNT => l_invoices_tbl(i).AMOUNT_TO_PROCESS,

Line 2881: LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ(P_TYPE => 'INVOICE',

2877: end if;
2878:
2879: -- do adjustment
2880: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ...');
2881: LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ(P_TYPE => 'INVOICE',
2882: P_PAYMENT_SCHEDULE_ID => l_invoices_tbl(i).PAYMENT_SCHEDULE_ID,
2883: P_RECEIVABLES_TRX_ID => l_receivables_trx_id,
2884: P_AMOUNT => l_invoices_tbl(i).AMOUNT_TO_PROCESS,
2885: P_APPLY_DATE => l_invoices_tbl(i).DUE_DATE,

Line 2954: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');

2950: RAISE FND_API.G_EXC_ERROR;
2951: END IF;
2952: end if;
2953:
2954: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');
2955: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0
2956: ,p_init_msg_list => FND_API.G_TRUE
2957: ,p_commit => FND_API.G_FALSE
2958: ,p_validation_level => 100

Line 2955: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0

2951: END IF;
2952: end if;
2953:
2954: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');
2955: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0
2956: ,p_init_msg_list => FND_API.G_TRUE
2957: ,p_commit => FND_API.G_FALSE
2958: ,p_validation_level => 100
2959: ,p_bill_headers_tbl => l_bill_headers_tbl

Line 3034: LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ(P_TYPE => 'INVOICE',

3030: l_adj_id := null;
3031: l_adj_number := null;
3032:
3033: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Adjusting down ' || l_invoices_tbl(i).CUST_TRX_ID || '...');
3034: LNS_BILLING_BATCH_PUB.CREATE_AR_ADJ(P_TYPE => 'INVOICE',
3035: P_PAYMENT_SCHEDULE_ID => l_invoices_tbl(i).PAYMENT_SCHEDULE_ID,
3036: P_RECEIVABLES_TRX_ID => l_receivables_trx_id,
3037: P_AMOUNT => -l_invoices_tbl(i).AMOUNT_TO_PROCESS,
3038: P_APPLY_DATE => l_invoices_tbl(i).DUE_DATE,

Line 3356: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;

3352: l_split_request varchar2(30);
3353: l_borrower_name VARCHAR2(360);
3354: l_agreement_reason varchar2(500);
3355:
3356: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
3357: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3358: l_LOAN_DTL_REC LNS_LOAN_PUB.Loan_Details_Rec_Type;
3359: l_LOAN_LINES_TBL LNS_LOAN_PUB.Loan_Lines_Tbl_Type;
3360: l_LOAN_PART_TBL LNS_LOAN_PUB.LOAN_PART_TBL_TYPE;

Line 3357: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;

3353: l_borrower_name VARCHAR2(360);
3354: l_agreement_reason varchar2(500);
3355:
3356: l_BILL_HEADERS_TBL LNS_BILLING_BATCH_PUB.BILL_HEADERS_TBL;
3357: l_BILL_LINES_TBL LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3358: l_LOAN_DTL_REC LNS_LOAN_PUB.Loan_Details_Rec_Type;
3359: l_LOAN_LINES_TBL LNS_LOAN_PUB.Loan_Lines_Tbl_Type;
3360: l_LOAN_PART_TBL LNS_LOAN_PUB.LOAN_PART_TBL_TYPE;
3361: l_OPEN_RATES_TBL LNS_LOAN_PUB.LOAN_RATES_TBL_TYPE;

Line 3530: LNS_BILLING_BATCH_PUB.VALIDATE_PRIN_AMOUNT(l_loan_id, l_REQUESTED_AMOUNT, l_LOAN_START_DATE);

3526: FND_MSG_PUB.ADD;
3527: RAISE FND_API.G_EXC_ERROR;
3528: end if;
3529:
3530: LNS_BILLING_BATCH_PUB.VALIDATE_PRIN_AMOUNT(l_loan_id, l_REQUESTED_AMOUNT, l_LOAN_START_DATE);
3531:
3532: l_header_counter := 1;
3533: l_BILL_HEADERS_TBL(l_header_counter).HEADER_ID := l_header_counter;
3534: l_BILL_HEADERS_TBL(l_header_counter).LOAN_ID := l_loan_id;

Line 3547: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');

3543: l_BILL_LINES_TBL(l_line_counter).LINE_AMOUNT := l_REQUESTED_AMOUNT;
3544: l_BILL_LINES_TBL(l_line_counter).LINE_TYPE := 'PRIN';
3545: l_BILL_LINES_TBL(l_line_counter).LINE_DESC := 'Loan split';
3546:
3547: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');
3548: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0
3549: ,p_init_msg_list => FND_API.G_TRUE
3550: ,p_commit => FND_API.G_FALSE
3551: ,p_validation_level => 100

Line 3548: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0

3544: l_BILL_LINES_TBL(l_line_counter).LINE_TYPE := 'PRIN';
3545: l_BILL_LINES_TBL(l_line_counter).LINE_DESC := 'Loan split';
3546:
3547: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_billing_batch_pub.create_offcycle_bills...');
3548: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0
3549: ,p_init_msg_list => FND_API.G_TRUE
3550: ,p_commit => FND_API.G_FALSE
3551: ,p_validation_level => 100
3552: ,p_bill_headers_tbl => l_BILL_HEADERS_TBL