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 217: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

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

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 224: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 229: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

273: ,x_return_status => l_return_status
274: ,x_msg_count => l_msg_count
275: ,x_msg_data => l_msg_data);
276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
278: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');
279: FND_MSG_PUB.Add;
280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
281: RAISE FND_API.G_EXC_ERROR;

Line 281: RAISE FND_API.G_EXC_ERROR;

277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
278: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');
279: FND_MSG_PUB.Add;
280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283:
284: --2. create payoff document(s) in receivables
285: -- build the header for the loan document(s) to be created

Line 353: ,p_commit => FND_API.G_FALSE

349: -- 2. if so, unapply all cash_receipts from document
350: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplying cash from pay_sched_id: ' || l_rec_application_id);
351: ar_receipt_api_pub.unapply(p_api_version => 1.0
352: ,p_init_msg_list => p_init_msg_list
353: ,p_commit => FND_API.G_FALSE
354: ,p_receivable_application_id => l_rec_application_id
355: ,x_return_status => l_return_status
356: ,x_msg_count => l_msg_count
357: ,x_msg_data => l_msg_data);

Line 359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

355: ,x_return_status => l_return_status
356: ,x_msg_count => l_msg_count
357: ,x_msg_data => l_msg_data);
358:
359: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: FND_MESSAGE.SET_NAME('LNS', 'LNS_UNAPPLY_CASH_ERROR');
361: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
362: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);
363: FND_MSG_PUB.Add;

Line 365: RAISE FND_API.G_EXC_ERROR;

361: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
362: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);
363: FND_MSG_PUB.Add;
364: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
365: RAISE FND_API.G_EXC_ERROR;
366: end if;
367:
368:
369: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - unapplied cash successfully');

Line 410: ,P_COMMIT => FND_API.G_FALSE

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
413: ,P_LINE_TYPE => 'INT'
414: ,X_RETURN_STATUS => l_return_status

Line 411: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL

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
413: ,P_LINE_TYPE => 'INT'
414: ,X_RETURN_STATUS => l_return_status
415: ,X_MSG_COUNT => l_msg_count

Line 418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

414: ,X_RETURN_STATUS => l_return_status
415: ,X_MSG_COUNT => l_msg_count
416: ,X_MSG_DATA => l_msg_data);
417:
418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
419: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');
420: FND_MSG_PUB.Add;
421: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
422: RAISE FND_API.G_EXC_ERROR;

Line 422: RAISE FND_API.G_EXC_ERROR;

418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
419: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');
420: FND_MSG_PUB.Add;
421: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
422: RAISE FND_API.G_EXC_ERROR;
423: end if;
424:
425: -- 4. create new interest and principal document for difference
426: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - RECALCULATING INTEREST');

Line 476: ,p_init_msg_list => FND_API.G_TRUE

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
480: ,p_bill_lines_tbl => l_bill_lines_tbl

Line 477: ,p_commit => FND_API.G_FALSE

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
480: ,p_bill_lines_tbl => l_bill_lines_tbl
481: ,x_return_status => l_return_status

Line 485: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

481: ,x_return_status => l_return_status
482: ,x_msg_count => l_msg_count
483: ,x_msg_data => l_msg_data);
484:
485: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
486: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
487: FND_MSG_PUB.Add;
488: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
489: RAISE FND_API.G_EXC_ERROR;

Line 489: RAISE FND_API.G_EXC_ERROR;

485: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
486: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
487: FND_MSG_PUB.Add;
488: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:
492: end if;
493:

Line 506: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

502: ,x_return_status => l_return_status
503: ,x_msg_count => l_msg_count
504: ,x_msg_data => l_msg_data);
505:
506: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
507: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
508: FND_MSG_PUB.Add;
509: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
510: RAISE FND_API.G_EXC_ERROR;

Line 510: RAISE FND_API.G_EXC_ERROR;

506: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
507: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
508: FND_MSG_PUB.Add;
509: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512:
513: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - # of unpaid invoices to process = ' || l_invoices_tbl.count);
514:

Line 549: RAISE FND_API.G_EXC_ERROR;

545: if l_total_receipts_amount < l_total_payoff_amount then
546: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');
547: FND_MSG_PUB.Add;
548: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
549: RAISE FND_API.G_EXC_ERROR;
550: end if;
551:
552: --5. apply cash
553: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - applying receipts...');

Line 598: RAISE FND_API.G_EXC_ERROR;

594: -- open receipts in the list to cover this invoice
595: FND_MESSAGE.SET_NAME('LNS', 'LNS_ALL_RECEIPTS_EXHAUSTED');
596: FND_MSG_PUB.Add;
597: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
598: RAISE FND_API.G_EXC_ERROR;
599: end if;
600:
601: else
602: -- receipt has not been previously applied to invoice

Line 640: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

636: ,x_msg_count => l_msg_count
637: ,x_msg_data => l_msg_data);
638:
639: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - apply cash status: ' || l_return_status);
640: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
641: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');
642: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
643: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);
644: FND_MSG_PUB.Add;

Line 646: RAISE FND_API.G_EXC_ERROR;

642: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');
643: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);
644: FND_MSG_PUB.Add;
645: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
646: RAISE FND_API.G_EXC_ERROR;
647: END IF;
648:
649: l_invoice_amount_remaining := l_invoice_amount_remaining - l_amount_to_apply;
650: l_receipt_amount_remaining := l_receipt_amount_remaining - l_amount_to_apply;

Line 670: ,P_INIT_MSG_LIST => FND_API.G_FALSE

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
674: ,P_PAYOFF_DATE => p_payoff_date

Line 671: ,P_COMMIT => FND_API.G_FALSE

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
674: ,P_PAYOFF_DATE => p_payoff_date
675: ,x_return_status => l_return_status

Line 679: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

675: ,x_return_status => l_return_status
676: ,x_msg_count => l_msg_count
677: ,x_msg_data => l_msg_data);
678: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - return status: ' || l_return_status);
679: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
680: COMMIT WORK;
681: else
682: RAISE FND_API.G_EXC_ERROR;
683: END IF;

Line 682: RAISE FND_API.G_EXC_ERROR;

678: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - return status: ' || l_return_status);
679: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
680: COMMIT WORK;
681: else
682: RAISE FND_API.G_EXC_ERROR;
683: END IF;
684:
685: -- ---------------------------------------------------------------------
686: -- End of API body

Line 694: WHEN FND_API.G_EXC_ERROR THEN

690:
691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
692:
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO processPayoff;
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: x_msg_count := l_msg_count;
698: x_msg_data := l_msg_data;

Line 696: x_return_status := FND_API.G_RET_STS_ERROR;

692:
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO processPayoff;
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: x_msg_count := l_msg_count;
698: x_msg_data := l_msg_data;
699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
700: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

698: x_msg_data := l_msg_data;
699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
700: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: ROLLBACK TO processPayoff;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: x_msg_count := l_msg_count;
706: x_msg_data := l_msg_data;

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: ROLLBACK TO processPayoff;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: x_msg_count := l_msg_count;
706: x_msg_data := l_msg_data;
707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
708: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 712: x_return_status := FND_API.G_RET_STS_ERROR;

708: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
709:
710: WHEN OTHERS THEN
711: ROLLBACK TO processPayoff;
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: x_msg_count := l_msg_count;
714: x_msg_data := l_msg_data;
715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
716: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

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

852: -- Standard Start of API savepoint
853: SAVEPOINT getLoanInvoices;
854:
855: -- Standard call to check for call compatibility.
856: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
857: l_api_name, G_PKG_NAME)
858: THEN
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;

Line 859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

855: -- Standard call to check for call compatibility.
856: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
857: l_api_name, G_PKG_NAME)
858: THEN
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861:
862: -- Initialize message list IF p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 863: IF FND_API.to_Boolean(p_init_msg_list) THEN

859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861:
862: -- Initialize message list IF p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean(p_init_msg_list) THEN
864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: -- Initialize API return status to SUCCESS

Line 868: x_return_status := FND_API.G_RET_STS_SUCCESS;

864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: -- Initialize API return status to SUCCESS
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: --
871: -- Api body
872: -- --------------------------------------------------------------------

Line 926: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

922: ,x_payoff_tbl => l_payoff_tbl2
923: ,x_return_status => l_return_status
924: ,x_msg_count => l_msg_count
925: ,x_msg_data => l_msg_data);
926: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
927: --FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
928: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;

Line 929: RAISE FND_API.G_EXC_ERROR;

925: ,x_msg_data => l_msg_data);
926: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
927: --FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');
928: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
929: RAISE FND_API.G_EXC_ERROR;
930: END IF;
931:
932: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);
933:

Line 1056: WHEN FND_API.G_EXC_ERROR THEN

1052:
1053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1054:
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_ERROR THEN
1057: ROLLBACK TO getLoanInvoices;
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: x_msg_count := l_msg_count;
1060: x_msg_data := l_msg_data;

Line 1058: x_return_status := FND_API.G_RET_STS_ERROR;

1054:
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_ERROR THEN
1057: ROLLBACK TO getLoanInvoices;
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: x_msg_count := l_msg_count;
1060: x_msg_data := l_msg_data;
1061: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1062: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1060: x_msg_data := l_msg_data;
1061: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1062: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK TO getLoanInvoices;
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: x_msg_count := l_msg_count;
1068: x_msg_data := l_msg_data;

Line 1066: x_return_status := FND_API.G_RET_STS_ERROR;

1062: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK TO getLoanInvoices;
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: x_msg_count := l_msg_count;
1068: x_msg_data := l_msg_data;
1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR;

1070: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1071:
1072: WHEN OTHERS THEN
1073: ROLLBACK TO getLoanInvoices;
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: x_msg_count := l_msg_count;
1076: x_msg_data := l_msg_data;
1077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1078: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1163: x_return_status := FND_API.G_RET_STS_SUCCESS;

1159: -- Standard Start of API savepoint
1160: SAVEPOINT APPLY_RECEIPT;
1161:
1162: -- Initialize API return status to SUCCESS
1163: x_return_status := FND_API.G_RET_STS_SUCCESS;
1164:
1165: --
1166: -- Api body
1167: -- --------------------------------------------------------------------

Line 1180: RAISE FND_API.G_EXC_ERROR;

1176: if P_CASH_RECEIPT_ID is null then
1177: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');
1178: FND_MSG_PUB.Add;
1179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1180: RAISE FND_API.G_EXC_ERROR;
1181: end if;
1182:
1183: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT = 0 then
1184: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');

Line 1187: RAISE FND_API.G_EXC_ERROR;

1183: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT = 0 then
1184: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');
1185: FND_MSG_PUB.Add;
1186: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1187: RAISE FND_API.G_EXC_ERROR;
1188: end if;
1189:
1190: /* verifying requested qpply amount */
1191: open receipt_cur(P_CASH_RECEIPT_ID);

Line 1198: RAISE FND_API.G_EXC_ERROR;

1194: if receipt_cur%NOTFOUND then
1195: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');
1196: FND_MSG_PUB.Add;
1197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1198: RAISE FND_API.G_EXC_ERROR;
1199: end if;
1200:
1201: close receipt_cur;
1202: /*

Line 1207: RAISE FND_API.G_EXC_ERROR;

1203: if l_receipt_rem_amount < P_APPLY_AMOUNT then
1204: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');
1205: FND_MSG_PUB.Add;
1206: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1207: RAISE FND_API.G_EXC_ERROR;
1208: end if;
1209: */
1210: select
1211: DAYS_TOGL_AFTER_DUE_DATE

Line 1230: ,P_INIT_MSG_LIST => FND_API.G_TRUE

1226: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' apply_date: ' || l_apply_date);
1227:
1228: /* Applying cash receipt to invoice */
1229: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1230: ,P_INIT_MSG_LIST => FND_API.G_TRUE
1231: ,P_COMMIT => FND_API.G_FALSE
1232: ,X_RETURN_STATUS => L_RETURN_STATUS
1233: ,X_MSG_COUNT => L_MSG_COUNT
1234: ,X_MSG_DATA => L_MSG_DATA

Line 1231: ,P_COMMIT => FND_API.G_FALSE

1227:
1228: /* Applying cash receipt to invoice */
1229: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1230: ,P_INIT_MSG_LIST => FND_API.G_TRUE
1231: ,P_COMMIT => FND_API.G_FALSE
1232: ,X_RETURN_STATUS => L_RETURN_STATUS
1233: ,X_MSG_COUNT => L_MSG_COUNT
1234: ,X_MSG_DATA => L_MSG_DATA
1235: ,p_cash_receipt_id => P_CASH_RECEIPT_ID

Line 1246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1242:
1243: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' return_status: ' || l_return_status);
1244: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' msg_data: ' || substr(l_msg_data,1,225));
1245:
1246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1247: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1248: FND_MSG_PUB.Add;
1249: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1250: RAISE FND_API.G_EXC_ERROR;

Line 1250: RAISE FND_API.G_EXC_ERROR;

1246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1247: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
1248: FND_MSG_PUB.Add;
1249: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1250: RAISE FND_API.G_EXC_ERROR;
1251: ELSE
1252: null;
1253: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);
1254: END IF;

Line 1260: WHEN FND_API.G_EXC_ERROR THEN

1256:
1257: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1258:
1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: ROLLBACK TO APPLY_RECEIPT;
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: x_msg_count := l_msg_count;
1264: x_msg_data := l_msg_data;

Line 1262: x_return_status := FND_API.G_RET_STS_ERROR;

1258:
1259: EXCEPTION
1260: WHEN FND_API.G_EXC_ERROR THEN
1261: ROLLBACK TO APPLY_RECEIPT;
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: x_msg_count := l_msg_count;
1264: x_msg_data := l_msg_data;
1265: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1266: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1264: x_msg_data := l_msg_data;
1265: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1266: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1267:
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO APPLY_RECEIPT;
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: x_msg_count := l_msg_count;
1272: x_msg_data := l_msg_data;

Line 1270: x_return_status := FND_API.G_RET_STS_ERROR;

1266: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1267:
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO APPLY_RECEIPT;
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: x_msg_count := l_msg_count;
1272: x_msg_data := l_msg_data;
1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1274: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

Line 1278: x_return_status := FND_API.G_RET_STS_ERROR;

1274: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1275:
1276: WHEN OTHERS THEN
1277: ROLLBACK TO APPLY_RECEIPT;
1278: x_return_status := FND_API.G_RET_STS_ERROR;
1279: x_msg_count := l_msg_count;
1280: x_msg_data := l_msg_data;
1281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1282: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);

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

1533: -- Standard Start of API savepoint
1534: SAVEPOINT getInvoicesForLoanCancellation;
1535:
1536: -- Standard call to check for call compatibility.
1537: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
1538: l_api_name, G_PKG_NAME)
1539: THEN
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;

Line 1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1536: -- Standard call to check for call compatibility.
1537: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
1538: l_api_name, G_PKG_NAME)
1539: THEN
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542:
1543: -- Initialize message list IF p_init_msg_list is set to TRUE.
1544: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1544: IF FND_API.to_Boolean(p_init_msg_list) THEN

1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: END IF;
1542:
1543: -- Initialize message list IF p_init_msg_list is set to TRUE.
1544: IF FND_API.to_Boolean(p_init_msg_list) THEN
1545: FND_MSG_PUB.initialize;
1546: END IF;
1547:
1548: -- Initialize API return status to SUCCESS

Line 1549: x_return_status := FND_API.G_RET_STS_SUCCESS;

1545: FND_MSG_PUB.initialize;
1546: END IF;
1547:
1548: -- Initialize API return status to SUCCESS
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;
1550:
1551: --
1552: -- Api body
1553: -- --------------------------------------------------------------------

Line 1565: RAISE FND_API.G_EXC_ERROR;

1561: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1562: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_LOAN_ID');
1563: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
1564: FND_MSG_PUB.ADD;
1565: RAISE FND_API.G_EXC_ERROR;
1566: end if;
1567: if p_cancellation_date is null then
1568: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1569: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_cancellation_date');

Line 1572: RAISE FND_API.G_EXC_ERROR;

1568: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1569: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_cancellation_date');
1570: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);
1571: FND_MSG_PUB.ADD;
1572: RAISE FND_API.G_EXC_ERROR;
1573: end if;
1574:
1575: open c_loanInfo(p_loan_id);
1576: fetch c_loanInfo into l_invoice_number,

Line 1590: ,p_init_msg_list => FND_API.G_TRUE

1586: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funded_amount = ' || l_funded_amount);
1587:
1588: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1589: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1590: ,p_init_msg_list => FND_API.G_TRUE
1591: ,p_loan_id => p_loan_id
1592: ,p_date => p_cancellation_date
1593: ,p_reason => 'LOAN_CANCELLATION'
1594: ,x_payoff_tbl => l_payoff_tbl2

Line 1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1595: ,x_return_status => l_return_status
1596: ,x_msg_count => l_msg_count
1597: ,x_msg_data => l_msg_data);
1598: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1600: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);

Line 1601: RAISE FND_API.G_EXC_ERROR;

1597: ,x_msg_data => l_msg_data);
1598: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1599: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1600: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
1604:
1605: open precision_cur(P_LOAN_ID);

Line 1793: x_return_status := FND_API.G_RET_STS_ERROR;

1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: ROLLBACK TO getInvoicesForLoanCancellation;
1793: x_return_status := FND_API.G_RET_STS_ERROR;
1794: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1795: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
1796: end;
1797:

Line 1867: RAISE FND_API.G_EXC_ERROR;

1863: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1864: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_LOAN_ID');
1865: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
1866: FND_MSG_PUB.ADD;
1867: RAISE FND_API.G_EXC_ERROR;
1868: end if;
1869: if p_cancellation_date is null then
1870: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1871: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_cancellation_date');

Line 1874: RAISE FND_API.G_EXC_ERROR;

1870: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1871: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_cancellation_date');
1872: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);
1873: FND_MSG_PUB.ADD;
1874: RAISE FND_API.G_EXC_ERROR;
1875: end if;
1876:
1877: open loan_details_cur(P_LOAN_ID);
1878: fetch loan_details_cur into l_loan_status;

Line 1894: RAISE FND_API.G_EXC_ERROR;

1890:
1891: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_LN_STATUS');
1892: FND_MSG_PUB.Add;
1893: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1894: RAISE FND_API.G_EXC_ERROR;
1895:
1896: end if;
1897:
1898: if p_LOAN_CANCELLATION_ID is null then

Line 1907: RAISE FND_API.G_EXC_ERROR;

1903: if (l_count > 0) then
1904: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_ALREADY_EXIST');
1905: FND_MSG_PUB.Add;
1906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1907: RAISE FND_API.G_EXC_ERROR;
1908: end if;
1909: else
1910: open cancel_request_cur(p_LOAN_CANCELLATION_ID);
1911: fetch cancel_request_cur into l_status, l_CANCELLATION_DATE;

Line 1918: RAISE FND_API.G_EXC_ERROR;

1914: if (l_status <> 'PENDING') then
1915: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_STATUS');
1916: FND_MSG_PUB.Add;
1917: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1918: RAISE FND_API.G_EXC_ERROR;
1919: end if;
1920:
1921: if trunc(p_cancellation_date) <> trunc(l_CANCELLATION_DATE) then
1922: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

Line 1926: RAISE FND_API.G_EXC_ERROR;

1922: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1923: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_cancellation_date');
1924: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);
1925: FND_MSG_PUB.ADD;
1926: RAISE FND_API.G_EXC_ERROR;
1927: end if;
1928:
1929: end if;
1930:

Line 1933: ,p_init_msg_list => FND_API.G_TRUE

1929: end if;
1930:
1931: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
1932: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
1933: ,p_init_msg_list => FND_API.G_TRUE
1934: ,p_loan_id => p_loan_id
1935: ,p_date => p_cancellation_date
1936: ,p_reason => 'LOAN_CANCELLATION'
1937: ,x_payoff_tbl => l_payoff_tbl2

Line 1942: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1938: ,x_return_status => l_return_status
1939: ,x_msg_count => l_msg_count
1940: ,x_msg_data => l_msg_data);
1941: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1942: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1943: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);

Line 1944: RAISE FND_API.G_EXC_ERROR;

1940: ,x_msg_data => l_msg_data);
1941: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
1942: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1943: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
1944: RAISE FND_API.G_EXC_ERROR;
1945: END IF;
1946: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
1947:
1948: for k in 1..l_payoff_tbl2.count loop

Line 1991: RAISE FND_API.G_EXC_ERROR;

1987: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1988: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled principal amount');
1989: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_prin);
1990: FND_MSG_PUB.ADD;
1991: RAISE FND_API.G_EXC_ERROR;
1992: end if;
1993:
1994: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_prin = ' || l_payoff_billed_prin);
1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);

Line 2001: RAISE FND_API.G_EXC_ERROR;

1997: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
1998: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid principal amount');
1999: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_prin);
2000: FND_MSG_PUB.ADD;
2001: RAISE FND_API.G_EXC_ERROR;
2002: end if;
2003:
2004: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_int = ' || l_payoff_unbilled_int);
2005: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);

Line 2011: RAISE FND_API.G_EXC_ERROR;

2007: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2008: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled interest amount');
2009: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_int);
2010: FND_MSG_PUB.ADD;
2011: RAISE FND_API.G_EXC_ERROR;
2012: end if;
2013:
2014: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_int = ' || l_payoff_billed_int);
2015: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);

Line 2021: RAISE FND_API.G_EXC_ERROR;

2017: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2018: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid interest amount');
2019: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_int);
2020: FND_MSG_PUB.ADD;
2021: RAISE FND_API.G_EXC_ERROR;
2022: end if;
2023:
2024: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_fee = ' || l_payoff_unbilled_fee);
2025: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);

Line 2031: RAISE FND_API.G_EXC_ERROR;

2027: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2028: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled fee amount');
2029: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_fee);
2030: FND_MSG_PUB.ADD;
2031: RAISE FND_API.G_EXC_ERROR;
2032: end if;
2033:
2034: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_fee = ' || l_payoff_billed_fee);
2035: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);

Line 2041: RAISE FND_API.G_EXC_ERROR;

2037: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2038: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid fee amount');
2039: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_fee);
2040: FND_MSG_PUB.ADD;
2041: RAISE FND_API.G_EXC_ERROR;
2042: end if;
2043:
2044: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2045:

Line 2121: RAISE FND_API.G_EXC_ERROR;

2117: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2118: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_LOAN_CANCELLATION_ID');
2119: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_CANCELLATION_ID);
2120: FND_MSG_PUB.ADD;
2121: RAISE FND_API.G_EXC_ERROR;
2122: end if;
2123:
2124: open cancel_request_cur(P_LOAN_CANCELLATION_ID);
2125: fetch cancel_request_cur

Line 2152: RAISE FND_API.G_EXC_ERROR;

2148:
2149: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_LN_STATUS');
2150: FND_MSG_PUB.Add;
2151: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2152: RAISE FND_API.G_EXC_ERROR;
2153:
2154: end if;
2155:
2156: if (l_STATUS <> 'PENDING') then

Line 2161: RAISE FND_API.G_EXC_ERROR;

2157:
2158: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_STATUS');
2159: FND_MSG_PUB.Add;
2160: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2161: RAISE FND_API.G_EXC_ERROR;
2162:
2163: end if;
2164:
2165: if (P_ACTION = 'APPROVE') then

Line 2169: ,p_init_msg_list => FND_API.G_TRUE

2165: if (P_ACTION = 'APPROVE') then
2166:
2167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_financials.calcLoanRemainingAmounts...');
2168: lns_financials.calcLoanRemainingAmounts(p_api_version => 1.0
2169: ,p_init_msg_list => FND_API.G_TRUE
2170: ,p_loan_id => l_LOAN_ID
2171: ,p_date => l_cancellation_date
2172: ,p_reason => 'LOAN_CANCELLATION'
2173: ,x_payoff_tbl => l_payoff_tbl2

Line 2178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2174: ,x_return_status => l_return_status
2175: ,x_msg_count => l_msg_count
2176: ,x_msg_data => l_msg_data);
2177: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;
2182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);

Line 2180: RAISE FND_API.G_EXC_ERROR;

2176: ,x_msg_data => l_msg_data);
2177: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2178: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;
2182: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'payoff tbl count = ' || l_payoff_tbl2.count);
2183:
2184: for k in 1..l_payoff_tbl2.count loop

Line 2236: RAISE FND_API.G_EXC_ERROR;

2232: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2233: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled principal amount');
2234: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_prin);
2235: FND_MSG_PUB.ADD;
2236: RAISE FND_API.G_EXC_ERROR;
2237: end if;
2238:
2239: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_prin = ' || l_payoff_billed_prin);
2240: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);

Line 2246: RAISE FND_API.G_EXC_ERROR;

2242: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2243: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid principal amount');
2244: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_prin);
2245: FND_MSG_PUB.ADD;
2246: RAISE FND_API.G_EXC_ERROR;
2247: end if;
2248:
2249: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_int = ' || l_payoff_unbilled_int);
2250: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);

Line 2256: RAISE FND_API.G_EXC_ERROR;

2252: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2253: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled interest amount');
2254: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_int);
2255: FND_MSG_PUB.ADD;
2256: RAISE FND_API.G_EXC_ERROR;
2257: end if;
2258:
2259: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_int = ' || l_payoff_billed_int);
2260: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);

Line 2266: RAISE FND_API.G_EXC_ERROR;

2262: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2263: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid interest amount');
2264: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_int);
2265: FND_MSG_PUB.ADD;
2266: RAISE FND_API.G_EXC_ERROR;
2267: end if;
2268:
2269: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_fee = ' || l_payoff_unbilled_fee);
2270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);

Line 2276: RAISE FND_API.G_EXC_ERROR;

2272: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2273: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled fee amount');
2274: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_fee);
2275: FND_MSG_PUB.ADD;
2276: RAISE FND_API.G_EXC_ERROR;
2277: end if;
2278:
2279: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_billed_fee = ' || l_payoff_billed_fee);
2280: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);

Line 2286: RAISE FND_API.G_EXC_ERROR;

2282: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2283: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid fee amount');
2284: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_fee);
2285: FND_MSG_PUB.ADD;
2286: RAISE FND_API.G_EXC_ERROR;
2287: end if;
2288:
2289: end if;
2290: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

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

2343: -- Standard Start of API savepoint
2344: SAVEPOINT saveLoanCancelRequest;
2345:
2346: -- Standard call to check for call compatibility.
2347: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
2348: l_api_name, G_PKG_NAME)
2349: THEN
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;

Line 2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2346: -- Standard call to check for call compatibility.
2347: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
2348: l_api_name, G_PKG_NAME)
2349: THEN
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;
2352:
2353: -- Initialize message list IF p_init_msg_list is set to TRUE.
2354: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2354: IF FND_API.to_Boolean(p_init_msg_list) THEN

2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351: END IF;
2352:
2353: -- Initialize message list IF p_init_msg_list is set to TRUE.
2354: IF FND_API.to_Boolean(p_init_msg_list) THEN
2355: FND_MSG_PUB.initialize;
2356: END IF;
2357:
2358: -- Initialize API return status to SUCCESS

Line 2359: x_return_status := FND_API.G_RET_STS_SUCCESS;

2355: FND_MSG_PUB.initialize;
2356: END IF;
2357:
2358: -- Initialize API return status to SUCCESS
2359: x_return_status := FND_API.G_RET_STS_SUCCESS;
2360:
2361: --
2362: -- Api body
2363: -- --------------------------------------------------------------------

Line 2559: P_INIT_MSG_LIST => FND_API.G_FALSE,

2555:
2556: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
2557: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
2558: P_LOAN_HEADER_REC => l_loan_header_rec,
2559: P_INIT_MSG_LIST => FND_API.G_FALSE,
2560: X_RETURN_STATUS => l_return_status,
2561: X_MSG_COUNT => l_msg_count,
2562: X_MSG_DATA => l_msg_data);
2563:

Line 2572: RAISE FND_API.G_EXC_ERROR;

2568: ELSE
2569: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2570: FND_MSG_PUB.Add;
2571: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2572: RAISE FND_API.G_EXC_ERROR;
2573: END IF;
2574: end if;
2575:
2576: -- --------------------------------------------------------------------

Line 2580: if P_COMMIT = FND_API.G_TRUE then

2576: -- --------------------------------------------------------------------
2577: -- End of API body
2578: --
2579:
2580: if P_COMMIT = FND_API.G_TRUE then
2581: COMMIT WORK;
2582: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
2583: end if;
2584:

Line 2592: x_return_status := FND_API.G_RET_STS_ERROR;

2588:
2589: EXCEPTION
2590: WHEN OTHERS THEN
2591: ROLLBACK TO saveLoanCancelRequest;
2592: x_return_status := FND_API.G_RET_STS_ERROR;
2593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2594: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
2595: end;
2596:

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

2709: -- Standard Start of API savepoint
2710: SAVEPOINT approveLoanCancelRequest;
2711:
2712: -- Standard call to check for call compatibility.
2713: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
2714: l_api_name, G_PKG_NAME)
2715: THEN
2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2717: END IF;

Line 2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2712: -- Standard call to check for call compatibility.
2713: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
2714: l_api_name, G_PKG_NAME)
2715: THEN
2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2717: END IF;
2718:
2719: -- Initialize message list IF p_init_msg_list is set to TRUE.
2720: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 2720: IF FND_API.to_Boolean(p_init_msg_list) THEN

2716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2717: END IF;
2718:
2719: -- Initialize message list IF p_init_msg_list is set to TRUE.
2720: IF FND_API.to_Boolean(p_init_msg_list) THEN
2721: FND_MSG_PUB.initialize;
2722: END IF;
2723:
2724: -- Initialize API return status to SUCCESS

Line 2725: x_return_status := FND_API.G_RET_STS_SUCCESS;

2721: FND_MSG_PUB.initialize;
2722: END IF;
2723:
2724: -- Initialize API return status to SUCCESS
2725: x_return_status := FND_API.G_RET_STS_SUCCESS;
2726:
2727: --
2728: -- Api body
2729: -- --------------------------------------------------------------------

Line 2759: RAISE FND_API.G_EXC_ERROR;

2755: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
2756: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
2757: FND_MSG_PUB.Add;
2758: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2759: RAISE FND_API.G_EXC_ERROR;
2760: end if;
2761:
2762: if l_loan_class = 'DIRECT' then
2763: -- cancel all remaining active disbursements

Line 2767: P_INIT_MSG_LIST => FND_API.G_FALSE,

2763: -- cancel all remaining active disbursements
2764: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB...');
2765: LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB(
2766: P_API_VERSION => 1.0,
2767: P_INIT_MSG_LIST => FND_API.G_FALSE,
2768: P_COMMIT => FND_API.G_FALSE,
2769: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2770: P_LOAN_ID => l_loan_id,
2771: X_RETURN_STATUS => l_return_status,

Line 2768: P_COMMIT => FND_API.G_FALSE,

2764: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB...');
2765: LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB(
2766: P_API_VERSION => 1.0,
2767: P_INIT_MSG_LIST => FND_API.G_FALSE,
2768: P_COMMIT => FND_API.G_FALSE,
2769: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2770: P_LOAN_ID => l_loan_id,
2771: X_RETURN_STATUS => l_return_status,
2772: X_MSG_COUNT => l_msg_count,

Line 2769: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

2765: LNS_FUNDING_PUB.APPROVE_CANCEL_REM_DISB(
2766: P_API_VERSION => 1.0,
2767: P_INIT_MSG_LIST => FND_API.G_FALSE,
2768: P_COMMIT => FND_API.G_FALSE,
2769: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2770: P_LOAN_ID => l_loan_id,
2771: X_RETURN_STATUS => l_return_status,
2772: X_MSG_COUNT => l_msg_count,
2773: X_MSG_DATA => l_msg_data);

Line 2777: RAISE FND_API.G_EXC_ERROR;

2773: X_MSG_DATA => l_msg_data);
2774: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2775:
2776: IF l_return_status <> 'S' THEN
2777: RAISE FND_API.G_EXC_ERROR;
2778: END IF;
2779: else
2780: -- cancel all remaining pending orig receivables
2781: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Rejecting all remaining pending orig receivables...');

Line 2876: RAISE FND_API.G_EXC_ERROR;

2872: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
2873: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
2874: FND_MSG_PUB.Add;
2875: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
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...');

Line 2899: RAISE FND_API.G_EXC_ERROR;

2895:
2896: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'l_adj_number = ' || l_adj_number || ' (l_adj_id = ' || l_adj_id || ')');
2897:
2898: if l_adj_id is null and l_adj_number is null then
2899: RAISE FND_API.G_EXC_ERROR;
2900: end if;
2901:
2902: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating LNS_LOAN_CANCEL_DETAILS...');
2903: update LNS_LOAN_CANCEL_DETAILS set

Line 2937: P_INIT_MSG_LIST => FND_API.G_FALSE,

2933: l_loan_header_rec.DISABLE_BILLING_FLAG := 'N';
2934:
2935: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
2936: P_LOAN_HEADER_REC => l_loan_header_rec,
2937: P_INIT_MSG_LIST => FND_API.G_FALSE,
2938: X_RETURN_STATUS => l_return_status,
2939: X_MSG_COUNT => l_msg_count,
2940: X_MSG_DATA => l_msg_data);
2941:

Line 2950: RAISE FND_API.G_EXC_ERROR;

2946: ELSE
2947: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
2948: FND_MSG_PUB.Add;
2949: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
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...');

Line 2956: ,p_init_msg_list => FND_API.G_TRUE

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
2960: ,p_bill_lines_tbl => l_bill_lines_tbl

Line 2957: ,p_commit => FND_API.G_FALSE

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
2960: ,p_bill_lines_tbl => l_bill_lines_tbl
2961: ,x_return_status => l_return_status

Line 2966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2962: ,x_msg_count => l_msg_count
2963: ,x_msg_data => l_msg_data);
2964:
2965: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
2966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2967: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
2968: FND_MSG_PUB.Add;
2969: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2970: RAISE FND_API.G_EXC_ERROR;

Line 2970: RAISE FND_API.G_EXC_ERROR;

2966: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2967: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
2968: FND_MSG_PUB.Add;
2969: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
2970: RAISE FND_API.G_EXC_ERROR;
2971: END IF;
2972:
2973: -- getting ids for the last billed invoices
2974: open new_invoices_cur(l_loan_id);

Line 3051: RAISE FND_API.G_EXC_ERROR;

3047: P_ORG_ID => l_org_id);
3048: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'l_adj_number = ' || l_adj_number || ' (l_adj_id = ' || l_adj_id || ')');
3049:
3050: if l_adj_id is null and l_adj_number is null then
3051: RAISE FND_API.G_EXC_ERROR;
3052: end if;
3053:
3054: elsif l_invoices_tbl(i).LOAN_LINE_ID is null and
3055: l_invoices_tbl(i).ACTION is not null and

Line 3064: P_INIT_MSG_LIST => FND_API.G_TRUE,

3060: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_CUSTOMER_TRX_ID = ' || l_invoices_tbl(i).CUST_TRX_ID);
3061: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_line_amount = ' || -l_invoices_tbl(i).AMOUNT_TO_PROCESS);
3062: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST(
3063: P_API_VERSION => 1.0,
3064: P_INIT_MSG_LIST => FND_API.G_TRUE,
3065: P_COMMIT => FND_API.G_FALSE,
3066: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
3067: P_CUSTOMER_TRX_ID => l_invoices_tbl(i).CUST_TRX_ID,
3068: P_LINE_CREDIT_FLAG => 'N',

Line 3065: P_COMMIT => FND_API.G_FALSE,

3061: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_line_amount = ' || -l_invoices_tbl(i).AMOUNT_TO_PROCESS);
3062: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST(
3063: P_API_VERSION => 1.0,
3064: P_INIT_MSG_LIST => FND_API.G_TRUE,
3065: P_COMMIT => FND_API.G_FALSE,
3066: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
3067: P_CUSTOMER_TRX_ID => l_invoices_tbl(i).CUST_TRX_ID,
3068: P_LINE_CREDIT_FLAG => 'N',
3069: p_line_amount => -l_invoices_tbl(i).AMOUNT_TO_PROCESS,

Line 3066: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

3062: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST(
3063: P_API_VERSION => 1.0,
3064: P_INIT_MSG_LIST => FND_API.G_TRUE,
3065: P_COMMIT => FND_API.G_FALSE,
3066: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
3067: P_CUSTOMER_TRX_ID => l_invoices_tbl(i).CUST_TRX_ID,
3068: P_LINE_CREDIT_FLAG => 'N',
3069: p_line_amount => -l_invoices_tbl(i).AMOUNT_TO_PROCESS,
3070: P_CM_REASON_CODE => 'CANCELLATION',

Line 3086: IF l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error OR

3082: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3083: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_msg_data: ' || substr(l_msg_data,1,225));
3084: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_request_id: ' || l_request_id);
3085:
3086: IF l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error OR
3087: l_request_id is null OR l_request_id = -1
3088: THEN
3089: RAISE FND_API.G_EXC_ERROR;
3090: END IF;

Line 3089: RAISE FND_API.G_EXC_ERROR;

3085:
3086: IF l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error OR
3087: l_request_id is null OR l_request_id = -1
3088: THEN
3089: RAISE FND_API.G_EXC_ERROR;
3090: END IF;
3091: end if;
3092:
3093: end loop;

Line 3114: l_loan_header_rec.SECONDARY_STATUS := FND_API.G_MISS_CHAR;

3110: close loan_version_cur;
3111:
3112: l_loan_header_rec.loan_id := l_loan_id;
3113: l_loan_header_rec.LOAN_STATUS := 'CANCELLED';
3114: l_loan_header_rec.SECONDARY_STATUS := FND_API.G_MISS_CHAR;
3115: l_loan_header_rec.DISABLE_BILLING_FLAG := 'N';
3116:
3117: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
3118: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

Line 3120: P_INIT_MSG_LIST => FND_API.G_FALSE,

3116:
3117: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
3118: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
3119: P_LOAN_HEADER_REC => l_loan_header_rec,
3120: P_INIT_MSG_LIST => FND_API.G_FALSE,
3121: X_RETURN_STATUS => l_return_status,
3122: X_MSG_COUNT => l_msg_count,
3123: X_MSG_DATA => l_msg_data);
3124:

Line 3133: RAISE FND_API.G_EXC_ERROR;

3129: ELSE
3130: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3131: FND_MSG_PUB.Add;
3132: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3133: RAISE FND_API.G_EXC_ERROR;
3134: END IF;
3135:
3136: -- --------------------------------------------------------------------
3137: -- End of API body

Line 3140: if P_COMMIT = FND_API.G_TRUE then

3136: -- --------------------------------------------------------------------
3137: -- End of API body
3138: --
3139:
3140: if P_COMMIT = FND_API.G_TRUE then
3141: COMMIT WORK;
3142: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3143: end if;
3144:

Line 3152: x_return_status := FND_API.G_RET_STS_ERROR;

3148:
3149: EXCEPTION
3150: WHEN OTHERS THEN
3151: ROLLBACK TO approveLoanCancelRequest;
3152: x_return_status := FND_API.G_RET_STS_ERROR;
3153: FND_MESSAGE.SET_NAME('LNS', 'LNS_PLSQL_API_ERROR');
3154: FND_MESSAGE.SET_TOKEN('APINAME', l_api_name);
3155: FND_MESSAGE.SET_TOKEN('ERRMSG', sqlerrm);
3156: FND_MSG_PUB.Add;

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

3196: -- Standard Start of API savepoint
3197: SAVEPOINT rejectLoanCancelRequest;
3198:
3199: -- Standard call to check for call compatibility.
3200: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
3201: l_api_name, G_PKG_NAME)
3202: THEN
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: END IF;

Line 3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3199: -- Standard call to check for call compatibility.
3200: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
3201: l_api_name, G_PKG_NAME)
3202: THEN
3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: END IF;
3205:
3206: -- Initialize message list IF p_init_msg_list is set to TRUE.
3207: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3207: IF FND_API.to_Boolean(p_init_msg_list) THEN

3203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3204: END IF;
3205:
3206: -- Initialize message list IF p_init_msg_list is set to TRUE.
3207: IF FND_API.to_Boolean(p_init_msg_list) THEN
3208: FND_MSG_PUB.initialize;
3209: END IF;
3210:
3211: -- Initialize API return status to SUCCESS

Line 3212: x_return_status := FND_API.G_RET_STS_SUCCESS;

3208: FND_MSG_PUB.initialize;
3209: END IF;
3210:
3211: -- Initialize API return status to SUCCESS
3212: x_return_status := FND_API.G_RET_STS_SUCCESS;
3213:
3214: --
3215: -- Api body
3216: -- --------------------------------------------------------------------

Line 3247: P_INIT_MSG_LIST => FND_API.G_FALSE,

3243:
3244: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating loan header...');
3245: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
3246: P_LOAN_HEADER_REC => l_loan_header_rec,
3247: P_INIT_MSG_LIST => FND_API.G_FALSE,
3248: X_RETURN_STATUS => l_return_status,
3249: X_MSG_COUNT => l_msg_count,
3250: X_MSG_DATA => l_msg_data);
3251:

Line 3260: RAISE FND_API.G_EXC_ERROR;

3256: ELSE
3257: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3258: FND_MSG_PUB.Add;
3259: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3260: RAISE FND_API.G_EXC_ERROR;
3261: END IF;
3262:
3263: -- --------------------------------------------------------------------
3264: -- End of API body

Line 3267: if P_COMMIT = FND_API.G_TRUE then

3263: -- --------------------------------------------------------------------
3264: -- End of API body
3265: --
3266:
3267: if P_COMMIT = FND_API.G_TRUE then
3268: COMMIT WORK;
3269: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3270: end if;
3271:

Line 3279: x_return_status := FND_API.G_RET_STS_ERROR;

3275:
3276: EXCEPTION
3277: WHEN OTHERS THEN
3278: ROLLBACK TO rejectLoanCancelRequest;
3279: x_return_status := FND_API.G_RET_STS_ERROR;
3280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3281: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3282: end;
3283:

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

3446: -- Standard Start of API savepoint
3447: SAVEPOINT approveLoanSplitRequest;
3448:
3449: -- Standard call to check for call compatibility.
3450: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
3451: l_api_name, G_PKG_NAME)
3452: THEN
3453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3454: END IF;

Line 3453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3449: -- Standard call to check for call compatibility.
3450: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
3451: l_api_name, G_PKG_NAME)
3452: THEN
3453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3454: END IF;
3455:
3456: -- Initialize message list IF p_init_msg_list is set to TRUE.
3457: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3457: IF FND_API.to_Boolean(p_init_msg_list) THEN

3453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3454: END IF;
3455:
3456: -- Initialize message list IF p_init_msg_list is set to TRUE.
3457: IF FND_API.to_Boolean(p_init_msg_list) THEN
3458: FND_MSG_PUB.initialize;
3459: END IF;
3460:
3461: -- Initialize API return status to SUCCESS

Line 3462: x_return_status := FND_API.G_RET_STS_SUCCESS;

3458: FND_MSG_PUB.initialize;
3459: END IF;
3460:
3461: -- Initialize API return status to SUCCESS
3462: x_return_status := FND_API.G_RET_STS_SUCCESS;
3463:
3464: --
3465: -- Api body
3466: -- --------------------------------------------------------------------

Line 3527: RAISE FND_API.G_EXC_ERROR;

3523: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
3524: FND_MESSAGE.SET_TOKEN('PARAMETER', 'status');
3525: FND_MESSAGE.SET_TOKEN('VALUE', l_STATUS);
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:

Line 3549: ,p_init_msg_list => FND_API.G_TRUE

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
3553: ,p_bill_lines_tbl => l_BILL_LINES_TBL

Line 3550: ,p_commit => FND_API.G_FALSE

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
3553: ,p_bill_lines_tbl => l_BILL_LINES_TBL
3554: ,x_return_status => l_return_status

Line 3559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3555: ,x_msg_count => l_msg_count
3556: ,x_msg_data => l_msg_data);
3557:
3558: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3560: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
3561: FND_MSG_PUB.Add;
3562: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3563: RAISE FND_API.G_EXC_ERROR;

Line 3563: RAISE FND_API.G_EXC_ERROR;

3559: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3560: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');
3561: FND_MSG_PUB.Add;
3562: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3563: RAISE FND_API.G_EXC_ERROR;
3564: END IF;
3565:
3566: open get_psa_cur(l_loan_id);
3567: fetch get_psa_cur into l_payment_schedule_id, l_new_am_sched_id;

Line 3690: P_INIT_MSG_LIST => FND_API.G_TRUE,

3686:
3687: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_LOAN_PUB.CREATE_LOAN...');
3688: LNS_LOAN_PUB.CREATE_LOAN(
3689: P_API_VERSION => 1.0,
3690: P_INIT_MSG_LIST => FND_API.G_TRUE,
3691: P_COMMIT => FND_API.G_FALSE,
3692: P_VALIDATION_LEVEL => 100,
3693: P_Loan_Details_Rec => l_LOAN_DTL_REC,
3694: P_Loan_Lines_Tbl => l_LOAN_LINES_TBL,

Line 3691: P_COMMIT => FND_API.G_FALSE,

3687: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_LOAN_PUB.CREATE_LOAN...');
3688: LNS_LOAN_PUB.CREATE_LOAN(
3689: P_API_VERSION => 1.0,
3690: P_INIT_MSG_LIST => FND_API.G_TRUE,
3691: P_COMMIT => FND_API.G_FALSE,
3692: P_VALIDATION_LEVEL => 100,
3693: P_Loan_Details_Rec => l_LOAN_DTL_REC,
3694: P_Loan_Lines_Tbl => l_LOAN_LINES_TBL,
3695: P_DISB_TBL => l_DISB_TBL,

Line 3708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3704: X_MSG_COUNT => l_msg_count,
3705: X_MSG_DATA => l_msg_data);
3706:
3707: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3709: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3710: RAISE FND_API.G_EXC_ERROR;
3711: END IF;
3712:

Line 3710: RAISE FND_API.G_EXC_ERROR;

3706:
3707: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3709: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3710: RAISE FND_API.G_EXC_ERROR;
3711: END IF;
3712:
3713: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created loan with id ' || l_new_loan_id);
3714:

Line 3725: P_INIT_MSG_LIST => FND_API.G_TRUE,

3721: -- if this is custom schedule loan then parse it and save it
3722: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.parseClob...');
3723: LNS_CUSTOM_PUB.parseClob(
3724: P_API_VERSION => 1.0,
3725: P_INIT_MSG_LIST => FND_API.G_TRUE,
3726: P_COMMIT => FND_API.G_FALSE,
3727: P_VALIDATION_LEVEL => 100,
3728: P_CLOB => l_CUSTOM_SCHEDULE,
3729: P_RETAIN_DATA => 'Y',

Line 3726: P_COMMIT => FND_API.G_FALSE,

3722: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.parseClob...');
3723: LNS_CUSTOM_PUB.parseClob(
3724: P_API_VERSION => 1.0,
3725: P_INIT_MSG_LIST => FND_API.G_TRUE,
3726: P_COMMIT => FND_API.G_FALSE,
3727: P_VALIDATION_LEVEL => 100,
3728: P_CLOB => l_CUSTOM_SCHEDULE,
3729: P_RETAIN_DATA => 'Y',
3730: x_return_status => l_return_status,

Line 3735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3731: x_msg_count => l_msg_count,
3732: x_msg_data => l_msg_data);
3733:
3734: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3736: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3737: RAISE FND_API.G_EXC_ERROR;
3738: END IF;
3739:

Line 3737: RAISE FND_API.G_EXC_ERROR;

3733:
3734: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3735: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3736: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3737: RAISE FND_API.G_EXC_ERROR;
3738: END IF;
3739:
3740: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.saveCustomSchedule...');
3741: LNS_CUSTOM_PUB.saveCustomSchedule(

Line 3743: P_INIT_MSG_LIST => FND_API.G_TRUE,

3739:
3740: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.saveCustomSchedule...');
3741: LNS_CUSTOM_PUB.saveCustomSchedule(
3742: P_API_VERSION => 1.0,
3743: P_INIT_MSG_LIST => FND_API.G_TRUE,
3744: P_COMMIT => FND_API.G_FALSE,
3745: P_VALIDATION_LEVEL => 100,
3746: P_LOAN_ID => l_new_loan_id,
3747: P_BASED_ON_TERMS => 'ORIGINATION',

Line 3744: P_COMMIT => FND_API.G_FALSE,

3740: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.saveCustomSchedule...');
3741: LNS_CUSTOM_PUB.saveCustomSchedule(
3742: P_API_VERSION => 1.0,
3743: P_INIT_MSG_LIST => FND_API.G_TRUE,
3744: P_COMMIT => FND_API.G_FALSE,
3745: P_VALIDATION_LEVEL => 100,
3746: P_LOAN_ID => l_new_loan_id,
3747: P_BASED_ON_TERMS => 'ORIGINATION',
3748: P_USE_RETAINED_DATA => 'Y',

Line 3756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3752: x_msg_count => l_msg_count,
3753: x_msg_data => l_msg_data);
3754:
3755: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3757: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;
3760:

Line 3758: RAISE FND_API.G_EXC_ERROR;

3754:
3755: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_return_status ' || l_return_status);
3756: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3757: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3758: RAISE FND_API.G_EXC_ERROR;
3759: END IF;
3760:
3761: end if;
3762:

Line 3796: if P_COMMIT = FND_API.G_TRUE then

3792: -- --------------------------------------------------------------------
3793: -- End of API body
3794: --
3795:
3796: if P_COMMIT = FND_API.G_TRUE then
3797: COMMIT WORK;
3798: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3799: end if;
3800:

Line 3808: x_return_status := FND_API.G_RET_STS_ERROR;

3804:
3805: EXCEPTION
3806: WHEN OTHERS THEN
3807: ROLLBACK TO approveLoanSplitRequest;
3808: x_return_status := FND_API.G_RET_STS_ERROR;
3809: FND_MESSAGE.SET_NAME('LNS', 'LNS_PLSQL_API_ERROR');
3810: FND_MESSAGE.SET_TOKEN('APINAME', l_api_name);
3811: FND_MESSAGE.SET_TOKEN('ERRMSG', sqlerrm);
3812: FND_MSG_PUB.Add;

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

3838: -- Standard Start of API savepoint
3839: SAVEPOINT rejectLoanCancelRequest;
3840:
3841: -- Standard call to check for call compatibility.
3842: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
3843: l_api_name, G_PKG_NAME)
3844: THEN
3845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3846: END IF;

Line 3845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3841: -- Standard call to check for call compatibility.
3842: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
3843: l_api_name, G_PKG_NAME)
3844: THEN
3845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3846: END IF;
3847:
3848: -- Initialize message list IF p_init_msg_list is set to TRUE.
3849: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 3849: IF FND_API.to_Boolean(p_init_msg_list) THEN

3845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3846: END IF;
3847:
3848: -- Initialize message list IF p_init_msg_list is set to TRUE.
3849: IF FND_API.to_Boolean(p_init_msg_list) THEN
3850: FND_MSG_PUB.initialize;
3851: END IF;
3852:
3853: -- Initialize API return status to SUCCESS

Line 3854: x_return_status := FND_API.G_RET_STS_SUCCESS;

3850: FND_MSG_PUB.initialize;
3851: END IF;
3852:
3853: -- Initialize API return status to SUCCESS
3854: x_return_status := FND_API.G_RET_STS_SUCCESS;
3855:
3856: --
3857: -- Api body
3858: -- --------------------------------------------------------------------

Line 3883: if P_COMMIT = FND_API.G_TRUE then

3879: -- --------------------------------------------------------------------
3880: -- End of API body
3881: --
3882:
3883: if P_COMMIT = FND_API.G_TRUE then
3884: COMMIT WORK;
3885: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3886: end if;
3887:

Line 3895: x_return_status := FND_API.G_RET_STS_ERROR;

3891:
3892: EXCEPTION
3893: WHEN OTHERS THEN
3894: ROLLBACK TO rejectLoanSplitRequest;
3895: x_return_status := FND_API.G_RET_STS_ERROR;
3896: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3897: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
3898: end;
3899: