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 FND_API

Line 214: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

210: -- Standard Start of API savepoint
211: SAVEPOINT processPayoff;
212:
213: -- Standard call to check for call compatibility.
214: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
215: l_api_name, G_PKG_NAME)
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;

Line 217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

213: -- Standard call to check for call compatibility.
214: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
215: l_api_name, G_PKG_NAME)
216: THEN
217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- Initialize message list IF p_init_msg_list is set to TRUE.
221: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 221: IF FND_API.to_Boolean(p_init_msg_list) THEN

217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
218: END IF;
219:
220: -- Initialize message list IF p_init_msg_list is set to TRUE.
221: IF FND_API.to_Boolean(p_init_msg_list) THEN
222: FND_MSG_PUB.initialize;
223: END IF;
224:
225: -- Initialize API return status to SUCCESS

Line 226: x_return_status := FND_API.G_RET_STS_SUCCESS;

222: FND_MSG_PUB.initialize;
223: END IF;
224:
225: -- Initialize API return status to SUCCESS
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: --
229: -- Api body
230: -- --------------------------------------------------------------------

Line 275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

271: ,p_payoff_date => p_payoff_date
272: ,x_return_status => l_return_status
273: ,x_msg_count => l_msg_count
274: ,x_msg_data => l_msg_data);
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: */

Line 277: RAISE FND_API.G_EXC_ERROR;

273: ,x_msg_count => l_msg_count
274: ,x_msg_data => l_msg_data);
275: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
276: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: */
280: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculating Payoff ');
281: lns_financials.calculatePayoff(p_api_version => 1.0

Line 290: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

286: ,x_return_status => l_return_status
287: ,x_msg_count => l_msg_count
288: ,x_msg_data => l_msg_data);
289:
290: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');
292: FND_MSG_PUB.Add;
293: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
294: RAISE FND_API.G_EXC_ERROR;

Line 294: RAISE FND_API.G_EXC_ERROR;

290: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
291: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');
292: FND_MSG_PUB.Add;
293: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296:
297: --2. create payoff document(s) in receivables
298: -- build the header for the loan document(s) to be created

Line 366: ,p_commit => FND_API.G_FALSE

362: -- 2. if so, unapply all cash_receipts from document
363: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplying cash from pay_sched_id: ' || l_rec_application_id);
364: ar_receipt_api_pub.unapply(p_api_version => 1.0
365: ,p_init_msg_list => p_init_msg_list
366: ,p_commit => FND_API.G_FALSE
367: ,p_receivable_application_id => l_rec_application_id
368: ,x_return_status => l_return_status
369: ,x_msg_count => l_msg_count
370: ,x_msg_data => l_msg_data);

Line 372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

368: ,x_return_status => l_return_status
369: ,x_msg_count => l_msg_count
370: ,x_msg_data => l_msg_data);
371:
372: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
373: FND_MESSAGE.SET_NAME('LNS', 'LNS_UNAPPLY_CASH_ERROR');
374: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
375: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);
376: FND_MSG_PUB.Add;

Line 378: RAISE FND_API.G_EXC_ERROR;

374: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
375: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);
376: FND_MSG_PUB.Add;
377: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
378: RAISE FND_API.G_EXC_ERROR;
379: end if;
380:
381:
382: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplied cash successfully');

Line 424: ,P_COMMIT => FND_API.G_FALSE

420: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - crediting final interest document');
421: /*=======================================================================*/
422: LNS_BILLING_BATCH_PUB.CREDIT_AMORTIZATION_PARTIAL(P_API_VERSION => 1.0
423: ,P_INIT_MSG_LIST => p_init_msg_list
424: ,P_COMMIT => FND_API.G_FALSE
425: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
426: ,P_LOAN_ID => p_loan_id
427: ,P_LINE_TYPE => 'INT'
428: ,X_RETURN_STATUS => l_return_status

Line 425: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL

421: /*=======================================================================*/
422: LNS_BILLING_BATCH_PUB.CREDIT_AMORTIZATION_PARTIAL(P_API_VERSION => 1.0
423: ,P_INIT_MSG_LIST => p_init_msg_list
424: ,P_COMMIT => FND_API.G_FALSE
425: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
426: ,P_LOAN_ID => p_loan_id
427: ,P_LINE_TYPE => 'INT'
428: ,X_RETURN_STATUS => l_return_status
429: ,X_MSG_COUNT => l_msg_count

Line 432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

428: ,X_RETURN_STATUS => l_return_status
429: ,X_MSG_COUNT => l_msg_count
430: ,X_MSG_DATA => l_msg_data);
431:
432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');
434: FND_MSG_PUB.Add;
435: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
436: RAISE FND_API.G_EXC_ERROR;

Line 436: RAISE FND_API.G_EXC_ERROR;

432: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
433: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');
434: FND_MSG_PUB.Add;
435: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
436: RAISE FND_API.G_EXC_ERROR;
437: end if;
438:
439: -- 4. create new interest and principal document for difference
440: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');

Line 491: ,p_commit => FND_API.G_FALSE

487: -- we have at least 1 invoice to create with amount > 0
488: -- must pass false for commit here or else payoff documents will exist in receivables
489: lns_billing_batch_pub.create_offcycle_bills(p_api_version => 1.0
490: ,p_init_msg_list => p_init_msg_list
491: ,p_commit => FND_API.G_FALSE
492: ,p_validation_level => 100
493: ,p_bill_headers_tbl => l_bill_headers_tbl
494: ,p_bill_lines_tbl => l_bill_lines_tbl
495: ,x_return_status => l_return_status

Line 499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

495: ,x_return_status => l_return_status
496: ,x_msg_count => l_msg_count
497: ,x_msg_data => l_msg_data);
498:
499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
501: FND_MSG_PUB.Add;
502: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
503: RAISE FND_API.G_EXC_ERROR;

Line 503: RAISE FND_API.G_EXC_ERROR;

499: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
500: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
501: FND_MSG_PUB.Add;
502: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:
506: end if;
507:

Line 520: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

516: ,x_return_status => l_return_status
517: ,x_msg_count => l_msg_count
518: ,x_msg_data => l_msg_data);
519:
520: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
521: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
522: FND_MSG_PUB.Add;
523: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
524: RAISE FND_API.G_EXC_ERROR;

Line 524: RAISE FND_API.G_EXC_ERROR;

520: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
521: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
522: FND_MSG_PUB.Add;
523: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
524: RAISE FND_API.G_EXC_ERROR;
525: END IF;
526:
527: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - # of unpaid invoices to process = ' || l_invoices_tbl.count);
528:

Line 563: RAISE FND_API.G_EXC_ERROR;

559: if l_total_receipts_amount < l_total_payoff_amount then
560: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');
561: FND_MSG_PUB.Add;
562: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
563: RAISE FND_API.G_EXC_ERROR;
564: end if;
565:
566: --5. apply cash
567: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - step 5');

Line 615: RAISE FND_API.G_EXC_ERROR;

611: -- open receipts in the list to cover this invoice
612: FND_MESSAGE.SET_NAME('LNS', 'LNS_ALL_RECEIPTS_EXHAUSTED');
613: FND_MSG_PUB.Add;
614: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
615: RAISE FND_API.G_EXC_ERROR;
616: end if;
617:
618: else
619: -- receipt has not been previously applied to invoice

Line 657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

653: ,x_msg_count => l_msg_count
654: ,x_msg_data => l_msg_data);
655:
656: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - apply cash status: ' || l_return_status);
657: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
658: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');
659: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
660: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);
661: FND_MSG_PUB.Add;

Line 663: RAISE FND_API.G_EXC_ERROR;

659: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
660: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);
661: FND_MSG_PUB.Add;
662: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;
665:
666: l_invoice_amount_remaining := l_invoice_amount_remaining - l_amount_to_apply;
667: l_receipt_amount_remaining := l_receipt_amount_remaining - l_amount_to_apply;

Line 687: ,P_INIT_MSG_LIST => FND_API.G_FALSE

683: -- end of step 5
684:
685: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_BILLING_BATCH_PUB.processPaidLoans');
686: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(P_API_VERSION => 1.0
687: ,P_INIT_MSG_LIST => FND_API.G_FALSE
688: ,P_COMMIT => FND_API.G_FALSE
689: ,P_VALIDATION_LEVEL => 100
690: ,P_LOAN_ID => p_loan_id
691: ,P_PAYOFF_DATE => p_payoff_date

Line 688: ,P_COMMIT => FND_API.G_FALSE

684:
685: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling LNS_BILLING_BATCH_PUB.processPaidLoans');
686: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(P_API_VERSION => 1.0
687: ,P_INIT_MSG_LIST => FND_API.G_FALSE
688: ,P_COMMIT => FND_API.G_FALSE
689: ,P_VALIDATION_LEVEL => 100
690: ,P_LOAN_ID => p_loan_id
691: ,P_PAYOFF_DATE => p_payoff_date
692: ,x_return_status => l_return_status

Line 696: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

692: ,x_return_status => l_return_status
693: ,x_msg_count => l_msg_count
694: ,x_msg_data => l_msg_data);
695: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LNS_BILLING_BATCH_PUB.processPaidLoans return status: ' || l_return_status);
696: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: COMMIT WORK;
698: else
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;

Line 699: RAISE FND_API.G_EXC_ERROR;

695: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - LNS_BILLING_BATCH_PUB.processPaidLoans return status: ' || l_return_status);
696: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
697: COMMIT WORK;
698: else
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701:
702:
703: -- one last check on the final balance before we mark the loan as

Line 737: P_INIT_MSG_LIST => FND_API.G_FALSE,

733: --l_loan_header_rec.object_version := l_object_version;
734:
735: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_object_version,
736: P_LOAN_HEADER_REC => l_loan_header_rec,
737: P_INIT_MSG_LIST => FND_API.G_FALSE,
738: X_RETURN_STATUS => l_return_status,
739: X_MSG_COUNT => l_msg_count,
740: X_MSG_DATA => l_msg_data);
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

737: P_INIT_MSG_LIST => FND_API.G_FALSE,
738: X_RETURN_STATUS => l_return_status,
739: X_MSG_COUNT => l_msg_count,
740: X_MSG_DATA => l_msg_data);
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
744: RAISE FND_API.G_EXC_ERROR;
745:

Line 744: RAISE FND_API.G_EXC_ERROR;

740: X_MSG_DATA => l_msg_data);
741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
742: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
743: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
744: RAISE FND_API.G_EXC_ERROR;
745:
746: update lns_fee_schedules
747: set billed_flag = 'Y'
748: where loan_id = p_loan_id

Line 772: RAISE FND_API.G_EXC_ERROR;

768: else
769: FND_MESSAGE.SET_NAME('LNS', 'LNS_FINAL_BALANCE_ERROR');
770: FND_MSG_PUB.Add;
771: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
772: RAISE FND_API.G_EXC_ERROR;
773: end if;
774: */
775: -- ---------------------------------------------------------------------
776: -- End of API body

Line 784: WHEN FND_API.G_EXC_ERROR THEN

780:
781: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
782:
783: EXCEPTION
784: WHEN FND_API.G_EXC_ERROR THEN
785: ROLLBACK TO processPayoff;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: x_msg_count := l_msg_count;
788: x_msg_data := l_msg_data;

Line 786: x_return_status := FND_API.G_RET_STS_ERROR;

782:
783: EXCEPTION
784: WHEN FND_API.G_EXC_ERROR THEN
785: ROLLBACK TO processPayoff;
786: x_return_status := FND_API.G_RET_STS_ERROR;
787: x_msg_count := l_msg_count;
788: x_msg_data := l_msg_data;
789: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
790: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

788: x_msg_data := l_msg_data;
789: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
790: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK TO processPayoff;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: x_msg_count := l_msg_count;
796: x_msg_data := l_msg_data;

Line 794: x_return_status := FND_API.G_RET_STS_ERROR;

790: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
791:
792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
793: ROLLBACK TO processPayoff;
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: x_msg_count := l_msg_count;
796: x_msg_data := l_msg_data;
797: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
798: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 802: x_return_status := FND_API.G_RET_STS_ERROR;

798: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
799:
800: WHEN OTHERS THEN
801: ROLLBACK TO processPayoff;
802: x_return_status := FND_API.G_RET_STS_ERROR;
803: x_msg_count := l_msg_count;
804: x_msg_data := l_msg_data;
805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
806: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 934: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

930: -- Standard Start of API savepoint
931: SAVEPOINT getLoanInvoices;
932:
933: -- Standard call to check for call compatibility.
934: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
935: l_api_name, G_PKG_NAME)
936: THEN
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: END IF;

Line 937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

933: -- Standard call to check for call compatibility.
934: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
935: l_api_name, G_PKG_NAME)
936: THEN
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: END IF;
939:
940: -- Initialize message list IF p_init_msg_list is set to TRUE.
941: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 941: IF FND_API.to_Boolean(p_init_msg_list) THEN

937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
938: END IF;
939:
940: -- Initialize message list IF p_init_msg_list is set to TRUE.
941: IF FND_API.to_Boolean(p_init_msg_list) THEN
942: FND_MSG_PUB.initialize;
943: END IF;
944:
945: -- Initialize API return status to SUCCESS

Line 946: x_return_status := FND_API.G_RET_STS_SUCCESS;

942: FND_MSG_PUB.initialize;
943: END IF;
944:
945: -- Initialize API return status to SUCCESS
946: x_return_status := FND_API.G_RET_STS_SUCCESS;
947:
948: --
949: -- Api body
950: -- --------------------------------------------------------------------

Line 996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

992: ,x_payoff_tbl => l_payoff_tbl2
993: ,x_return_status => l_return_status
994: ,x_msg_count => l_msg_count
995: ,x_msg_data => l_msg_data);
996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: --FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
998: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;

Line 999: RAISE FND_API.G_EXC_ERROR;

995: ,x_msg_data => l_msg_data);
996: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: --FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
998: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);
1003:

Line 1103: WHEN FND_API.G_EXC_ERROR THEN

1099:
1100: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1101:
1102: EXCEPTION
1103: WHEN FND_API.G_EXC_ERROR THEN
1104: ROLLBACK TO getLoanInvoices;
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: x_msg_count := l_msg_count;
1107: x_msg_data := l_msg_data;

Line 1105: x_return_status := FND_API.G_RET_STS_ERROR;

1101:
1102: EXCEPTION
1103: WHEN FND_API.G_EXC_ERROR THEN
1104: ROLLBACK TO getLoanInvoices;
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: x_msg_count := l_msg_count;
1107: x_msg_data := l_msg_data;
1108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1109: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1107: x_msg_data := l_msg_data;
1108: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1109: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1110:
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: ROLLBACK TO getLoanInvoices;
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: x_msg_count := l_msg_count;
1115: x_msg_data := l_msg_data;

Line 1113: x_return_status := FND_API.G_RET_STS_ERROR;

1109: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1110:
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: ROLLBACK TO getLoanInvoices;
1113: x_return_status := FND_API.G_RET_STS_ERROR;
1114: x_msg_count := l_msg_count;
1115: x_msg_data := l_msg_data;
1116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1117: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1121: x_return_status := FND_API.G_RET_STS_ERROR;

1117: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1118:
1119: WHEN OTHERS THEN
1120: ROLLBACK TO getLoanInvoices;
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: x_msg_count := l_msg_count;
1123: x_msg_data := l_msg_data;
1124: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1125: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1210: x_return_status := FND_API.G_RET_STS_SUCCESS;

1206: -- Standard Start of API savepoint
1207: SAVEPOINT APPLY_RECEIPT;
1208:
1209: -- Initialize API return status to SUCCESS
1210: x_return_status := FND_API.G_RET_STS_SUCCESS;
1211:
1212: --
1213: -- Api body
1214: -- --------------------------------------------------------------------

Line 1227: RAISE FND_API.G_EXC_ERROR;

1223: if P_CASH_RECEIPT_ID is null then
1224: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');
1225: FND_MSG_PUB.Add;
1226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1227: RAISE FND_API.G_EXC_ERROR;
1228: end if;
1229:
1230: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then
1231: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');

Line 1234: RAISE FND_API.G_EXC_ERROR;

1230: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then
1231: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');
1232: FND_MSG_PUB.Add;
1233: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1234: RAISE FND_API.G_EXC_ERROR;
1235: end if;
1236:
1237: /* verifying requested qpply amount */
1238: open receipt_cur(P_CASH_RECEIPT_ID);

Line 1245: RAISE FND_API.G_EXC_ERROR;

1241: if receipt_cur%NOTFOUND then
1242: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');
1243: FND_MSG_PUB.Add;
1244: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1245: RAISE FND_API.G_EXC_ERROR;
1246: end if;
1247:
1248: close receipt_cur;
1249: /*

Line 1254: RAISE FND_API.G_EXC_ERROR;

1250: if l_receipt_rem_amount < P_APPLY_AMOUNT then
1251: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');
1252: FND_MSG_PUB.Add;
1253: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1254: RAISE FND_API.G_EXC_ERROR;
1255: end if;
1256: */
1257: select
1258: DAYS_TOGL_AFTER_DUE_DATE

Line 1277: ,P_INIT_MSG_LIST => FND_API.G_FALSE

1273: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' apply_date: ' || l_apply_date);
1274:
1275: /* Applying cash receipt to invoice */
1276: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1277: ,P_INIT_MSG_LIST => FND_API.G_FALSE
1278: ,P_COMMIT => FND_API.G_FALSE
1279: ,X_RETURN_STATUS => L_RETURN_STATUS
1280: ,X_MSG_COUNT => L_MSG_COUNT
1281: ,X_MSG_DATA => L_MSG_DATA

Line 1278: ,P_COMMIT => FND_API.G_FALSE

1274:
1275: /* Applying cash receipt to invoice */
1276: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1277: ,P_INIT_MSG_LIST => FND_API.G_FALSE
1278: ,P_COMMIT => FND_API.G_FALSE
1279: ,X_RETURN_STATUS => L_RETURN_STATUS
1280: ,X_MSG_COUNT => L_MSG_COUNT
1281: ,X_MSG_DATA => L_MSG_DATA
1282: ,p_cash_receipt_id => P_CASH_RECEIPT_ID

Line 1293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1289:
1290: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' return_status: ' || l_return_status);
1291: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' msg_data: ' || substr(l_msg_data,1,225));
1292:
1293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1295: FND_MSG_PUB.Add;
1296: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1297: RAISE FND_API.G_EXC_ERROR;

Line 1297: RAISE FND_API.G_EXC_ERROR;

1293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1294: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1295: FND_MSG_PUB.Add;
1296: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1297: RAISE FND_API.G_EXC_ERROR;
1298: ELSE
1299: null;
1300: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);
1301: END IF;

Line 1307: WHEN FND_API.G_EXC_ERROR THEN

1303:
1304: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1305:
1306: EXCEPTION
1307: WHEN FND_API.G_EXC_ERROR THEN
1308: ROLLBACK TO APPLY_RECEIPT;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: x_msg_count := l_msg_count;
1311: x_msg_data := l_msg_data;

Line 1309: x_return_status := FND_API.G_RET_STS_ERROR;

1305:
1306: EXCEPTION
1307: WHEN FND_API.G_EXC_ERROR THEN
1308: ROLLBACK TO APPLY_RECEIPT;
1309: x_return_status := FND_API.G_RET_STS_ERROR;
1310: x_msg_count := l_msg_count;
1311: x_msg_data := l_msg_data;
1312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1313: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1311: x_msg_data := l_msg_data;
1312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1313: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1314:
1315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1316: ROLLBACK TO APPLY_RECEIPT;
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: x_msg_count := l_msg_count;
1319: x_msg_data := l_msg_data;

Line 1317: x_return_status := FND_API.G_RET_STS_ERROR;

1313: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1314:
1315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1316: ROLLBACK TO APPLY_RECEIPT;
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: x_msg_count := l_msg_count;
1319: x_msg_data := l_msg_data;
1320: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1321: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1325: x_return_status := FND_API.G_RET_STS_ERROR;

1321: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1322:
1323: WHEN OTHERS THEN
1324: ROLLBACK TO APPLY_RECEIPT;
1325: x_return_status := FND_API.G_RET_STS_ERROR;
1326: x_msg_count := l_msg_count;
1327: x_msg_data := l_msg_data;
1328: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1329: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);