APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOAN_HEADER_PUB

Line 317: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

313: l_old_last_payment_number number;
314: l_old_amortization_id number;
315: l_current_phase varchar2(30);
316:
317: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
318:
319: /*-----------------------------------------------------------------------+
320: | Cursor Declarations |
321: +-----------------------------------------------------------------------*/

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

396: end if;
397:
398: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
399:
400: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
401: P_LOAN_HEADER_REC => l_loan_header_rec,
402: P_INIT_MSG_LIST => FND_API.G_FALSE,
403: X_RETURN_STATUS => l_return_status,
404: X_MSG_COUNT => l_msg_count,

Line 488: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

484: l_remaining_amount number;
485: l_end date;
486: l_start date;
487:
488: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
489:
490: /*-----------------------------------------------------------------------+
491: | Cursor Declarations |
492: +-----------------------------------------------------------------------*/

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

601: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header info w following values:');
602: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);
603: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Secondary status: ' || l_loan_header_rec.SECONDARY_STATUS);
604:
605: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
606: P_LOAN_HEADER_REC => l_loan_header_rec,
607: P_INIT_MSG_LIST => FND_API.G_FALSE,
608: X_RETURN_STATUS => l_return_status,
609: X_MSG_COUNT => l_msg_count,

Line 727: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

723: l_loan_number varchar2(60);
724: l_end date;
725: l_start date;
726:
727: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
728:
729: /*-----------------------------------------------------------------------+
730: | Cursor Declarations |
731: +-----------------------------------------------------------------------*/

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

774:
775: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header info w following values:');
776: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);
777:
778: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
779: P_LOAN_HEADER_REC => l_loan_header_rec,
780: P_INIT_MSG_LIST => FND_API.G_FALSE,
781: X_RETURN_STATUS => l_return_status,
782: X_MSG_COUNT => l_msg_count,

Line 3538: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

3534: l_start date;
3535: l_end date;
3536: l_floating_flag varchar2(1);
3537:
3538: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3539: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3540: l_lines_tbl LNS_BILLING_BATCH_PUB.BILL_LINES_TBL;
3541: l_fee_tbl LNS_FINANCIALS.FEES_TBL;
3542:

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

3976: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header info w following values:');
3977: LogMessage(FND_LOG.LEVEL_STATEMENT, 'BILLED_FLAG: ' || l_loan_header_rec.BILLED_FLAG);
3978: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LAST_BILLED_DATE: ' || l_loan_header_rec.LAST_BILLED_DATE);
3979:
3980: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => P_LOAN_REC.OBJECT_VERSION_NUMBER,
3981: P_LOAN_HEADER_REC => l_loan_header_rec,
3982: P_INIT_MSG_LIST => FND_API.G_FALSE,
3983: X_RETURN_STATUS => l_return_status,
3984: X_MSG_COUNT => l_msg_count,

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

3988:
3989: IF l_return_status = 'S' THEN
3990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
3991: ELSE
3992: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
3993: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3994: FND_MSG_PUB.Add;
3995: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3996: RAISE FND_API.G_EXC_ERROR;

Line 4161: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

4157: l_cur_phase varchar2(30);
4158: l_end date;
4159: l_start date;
4160:
4161: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4162: l_amortization_rec lns_financials.AMORTIZATION_REC;
4163: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
4164:
4165: /*-----------------------------------------------------------------------+

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

4265: l_loan_header_rec.loan_id := P_LOAN_NEXT_DD_REC.LOAN_ID;
4266: l_loan_header_rec.BILLED_FLAG := 'N';
4267: l_object_version_number := P_LOAN_NEXT_DD_REC.OBJECT_VERSION_NUMBER;
4268:
4269: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_object_version_number,
4270: P_LOAN_HEADER_REC => l_loan_header_rec,
4271: P_INIT_MSG_LIST => FND_API.G_FALSE,
4272: X_RETURN_STATUS => l_return_status,
4273: X_MSG_COUNT => l_msg_count,

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

4277:
4278: IF l_return_status = 'S' THEN
4279: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4280: ELSE
4281: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4282: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4283: FND_MSG_PUB.Add;
4284: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4285: RAISE FND_API.G_EXC_ERROR;