DBA Data[Home] [Help]

APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOAN_LINES

Line 6957: lns_loan_lines lines

6953: nvl(lines.installment_number, 1)
6954: from LNS_LOAN_HEADERS loan,
6955: RA_CUSTOMER_TRX trx,
6956: ar_payment_schedules psa,
6957: lns_loan_lines lines
6958: where loan.loan_id = P_LOAN_ID and
6959: loan.loan_id = lines.loan_id and
6960: lines.reference_type = 'RECEIVABLE' and
6961: lines.REFERENCE_ID = trx.CUSTOMER_TRX_ID and

Line 7127: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_LINES...');

7123: X_ADJ_ID => l_adj_id,
7124: X_ADJ_NUMBER => l_adj_number,
7125: P_ORG_ID => l_org_id);
7126:
7127: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_LINES...');
7128: LNS_LOAN_LINE_PUB.UPDATE_LINE_ADJUSTMENT_NUMBER(
7129: p_init_msg_list => FND_API.G_FALSE
7130: ,p_loan_id => P_LOAN_ID
7131: ,p_loan_line_id => l_line_id

Line 7142: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_LINES');

7138: ,x_msg_data => l_msg_data);
7139:
7140: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7141: IF l_return_status = 'S' THEN
7142: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_LINES');
7143: ELSE
7144: RAISE FND_API.G_EXC_ERROR;
7145: END IF;
7146: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully created adjustment ' || l_adj_number || ' for original receivable ' || l_trx_number);