APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 273: | This procedure stores last payment number and last amortization id in lns_loan_headers_all

269: /*========================================================================
270: | PRIVATE PROCEDURE STORE_LAST_PAYMENT_NUMBER
271: |
272: | DESCRIPTION
273: | This procedure stores last payment number and last amortization id in lns_loan_headers_all
274: |
275: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
276: |
277: | CALLS PROCEDURES/FUNCTIONS (local to this package body)

Line 410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

406:
407: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
408:
409: IF l_return_status = 'S' THEN
410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
411: ELSE
412: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
413: FND_MSG_PUB.Add;
414: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 615: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

611:
612: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
613:
614: IF l_return_status = 'S' THEN
615: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
616: ELSE
617: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
618: FND_MSG_PUB.Add;
619: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 788: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_HEADERS_ALL');

784:
785: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
786:
787: IF l_return_status = 'S' THEN
788: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_HEADERS_ALL');
789: ELSE
790: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
791: FND_MSG_PUB.Add;
792: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3149: from lns_loan_headers_all loan

3145: +-----------------------------------------------------------------------*/
3146:
3147: CURSOR c_get_currency_format_mask(pLoanId Number) is
3148: select FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50) mask
3149: from lns_loan_headers_all loan
3150: where loan.loan_id = pLoanId;
3151:
3152: BEGIN
3153:

Line 3288: 'FROM lns_loan_headers_all loan, ' ||

3284: 'payment_history.AMORTIZATION_SCHEDULE_ID < payment_summary.next_payment_amortization_id ' ||
3285: 'order by payment_history.AMORTIZATION_SCHEDULE_ID) ' ||
3286: 'AS Recent_Payment_History ' ||
3287:
3288: 'FROM lns_loan_headers_all loan, ' ||
3289: 'hz_parties party, ' ||
3290: 'fnd_territories_tl terr, ' ||
3291: 'hr_all_organization_units_tl org, ' ||
3292: 'LNS_PAYMENTS_SUMMARY_V payment_summary, ' ||

Line 3990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

3986:
3987: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
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;

Line 4279: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

4275:
4276: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
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;