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_MSG_PUB

Line 225: FND_MSG_PUB.initialize;

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
229: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 279: FND_MSG_PUB.Add;

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;
282: END IF;
283:

Line 280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));

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;
282: END IF;
283:
284: --2. create payoff document(s) in receivables

Line 363: FND_MSG_PUB.Add;

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;
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:

Line 364: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
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:

Line 420: FND_MSG_PUB.Add;

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;
423: end if;
424:

Line 421: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
423: end if;
424:
425: -- 4. create new interest and principal document for difference

Line 487: FND_MSG_PUB.Add;

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;
490: END IF;
491:

Line 488: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
490: END IF;
491:
492: end if;

Line 508: FND_MSG_PUB.Add;

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;
511: END IF;
512:

Line 509: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
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);

Line 547: FND_MSG_PUB.Add;

543: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - total payoff amount: ' || l_total_payoff_amount);
544:
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:

Line 548: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

544:
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

Line 596: FND_MSG_PUB.Add;

592: if j = l_cash_receipt_ids.count then
593: -- we have gone thru all the cash receipts and there is not enough
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:

Line 597: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

593: -- we have gone thru all the cash receipts and there is not enough
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

Line 644: FND_MSG_PUB.Add;

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;
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:

Line 645: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
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;

Line 689: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

685: -- ---------------------------------------------------------------------
686: -- End of API body
687: --
688:
689: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
690:
691: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
692:
693: EXCEPTION

Line 699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
701:
702: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
703: ROLLBACK TO processPayoff;

Line 707: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
709:
710: WHEN OTHERS THEN
711: ROLLBACK TO processPayoff;

Line 715: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
717:
718: end processPayoff;
719:

Line 864: FND_MSG_PUB.initialize;

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
868: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 928: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
931:
932: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ' - payoff tbl count ' || l_payoff_tbl2.count);

Line 1051: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1047: -- --------------------------------------------------------------------
1048: -- End of API body
1049: --
1050:
1051: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1052:
1053: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1054:
1055: EXCEPTION

Line 1061: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK TO getLoanInvoices;

Line 1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
1071:
1072: WHEN OTHERS THEN
1073: ROLLBACK TO getLoanInvoices;

Line 1077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
1079:
1080: end getLoanInvoices;
1081:

Line 1178: FND_MSG_PUB.Add;

1174:
1175: /* verify input data */
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:

Line 1179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1175: /* verify input data */
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

Line 1185: FND_MSG_PUB.Add;

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');
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:

Line 1186: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1182:
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 */

Line 1196: FND_MSG_PUB.Add;

1192: fetch receipt_cur into l_receipt_rem_amount;
1193:
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:

Line 1197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1193:
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;

Line 1205: FND_MSG_PUB.Add;

1201: close receipt_cur;
1202: /*
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: */

Line 1206: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1202: /*
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

Line 1248: FND_MSG_PUB.Add;

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;
1251: ELSE
1252: null;

Line 1249: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
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);

Line 1265: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
1267:
1268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1269: ROLLBACK TO APPLY_RECEIPT;

Line 1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
1275:
1276: WHEN OTHERS THEN
1277: ROLLBACK TO APPLY_RECEIPT;

Line 1281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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);
1283: END;
1284:
1285: /*=========================================================================

Line 1545: FND_MSG_PUB.initialize;

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
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1564: FND_MSG_PUB.ADD;

1560: if P_LOAN_ID is null then
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');

Line 1571: FND_MSG_PUB.ADD;

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');
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);

Line 1600: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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);
1604:

Line 1786: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1782: -- --------------------------------------------------------------------
1783: -- End of API body
1784: --
1785:
1786: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1787:
1788: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1789:
1790: EXCEPTION

Line 1794: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
1798:

Line 1866: FND_MSG_PUB.ADD;

1862: if P_LOAN_ID is null then
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');

Line 1873: FND_MSG_PUB.ADD;

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');
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);

Line 1892: FND_MSG_PUB.Add;

1888: l_loan_status <> 'IN_FUNDING')
1889: then
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;

Line 1893: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1889: then
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:

Line 1905: FND_MSG_PUB.Add;

1901: close pending_count_cur;
1902:
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

Line 1906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1902:
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);

Line 1916: FND_MSG_PUB.Add;

1912: close cancel_request_cur;
1913:
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:

Line 1917: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

1913:
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

Line 1925: FND_MSG_PUB.ADD;

1921: if trunc(p_cancellation_date) <> trunc(l_CANCELLATION_DATE) then
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;

Line 1943: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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);
1947:

Line 1990: FND_MSG_PUB.ADD;

1986: if l_payoff_unbilled_prin <> l_unbilled_prin then
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);

Line 2000: FND_MSG_PUB.ADD;

1996: if l_payoff_billed_prin <> l_billed_prin then
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);

Line 2010: FND_MSG_PUB.ADD;

2006: if l_payoff_unbilled_int < l_unbilled_int then
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);

Line 2020: FND_MSG_PUB.ADD;

2016: if l_payoff_billed_int <> l_billed_int then
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);

Line 2030: FND_MSG_PUB.ADD;

2026: if l_payoff_unbilled_fee < l_unbilled_fee then
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);

Line 2040: FND_MSG_PUB.ADD;

2036: if l_payoff_billed_fee <> l_billed_fee then
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');

Line 2120: FND_MSG_PUB.ADD;

2116: if P_LOAN_CANCELLATION_ID is null then
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);

Line 2150: FND_MSG_PUB.Add;

2146: l_loan_status <> 'IN_FUNDING')
2147: then
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;

Line 2151: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2147: then
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:

Line 2159: FND_MSG_PUB.Add;

2155:
2156: if (l_STATUS <> 'PENDING') then
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;

Line 2160: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2156: if (l_STATUS <> 'PENDING') then
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:

Line 2179: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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);
2183:

Line 2235: FND_MSG_PUB.ADD;

2231: if l_payoff_unbilled_prin <> l_unbilled_prin then
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);

Line 2245: FND_MSG_PUB.ADD;

2241: if l_payoff_billed_prin <> l_billed_prin then
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);

Line 2255: FND_MSG_PUB.ADD;

2251: if l_payoff_unbilled_int < l_unbilled_int then
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);

Line 2265: FND_MSG_PUB.ADD;

2261: if l_payoff_billed_int <> l_billed_int then
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);

Line 2275: FND_MSG_PUB.ADD;

2271: if l_payoff_unbilled_fee < l_unbilled_fee then
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);

Line 2285: FND_MSG_PUB.ADD;

2281: if l_payoff_billed_fee <> l_billed_fee then
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;

Line 2355: FND_MSG_PUB.initialize;

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
2359: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2570: FND_MSG_PUB.Add;

2566: IF l_return_status = 'S' THEN
2567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
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;

Line 2571: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2567: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
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:

Line 2585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2581: COMMIT WORK;
2582: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
2583: end if;
2584:
2585: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2586:
2587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
2588:
2589: EXCEPTION

Line 2593: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
2597:

Line 2721: FND_MSG_PUB.initialize;

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
2725: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2757: FND_MSG_PUB.Add;

2753:
2754: if l_receivables_trx_id is null then
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:

Line 2758: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2754: if l_receivables_trx_id is null then
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

Line 2874: FND_MSG_PUB.Add;

2870: -- checking for system options values required for adjustment
2871: if l_receivables_trx_id is null then
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:

Line 2875: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2871: if l_receivables_trx_id is null then
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

Line 2948: FND_MSG_PUB.Add;

2944: IF l_return_status = 'S' THEN
2945: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Billing is enabled');
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;

Line 2949: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

2945: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Billing is enabled');
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:

Line 2968: FND_MSG_PUB.Add;

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;
2971: END IF;
2972:

Line 2969: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2971: END IF;
2972:
2973: -- getting ids for the last billed invoices

Line 3131: FND_MSG_PUB.Add;

3127: IF l_return_status = 'S' THEN
3128: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
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:

Line 3132: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

3128: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
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: -- --------------------------------------------------------------------

Line 3145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3141: COMMIT WORK;
3142: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3143: end if;
3144:
3145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3146:
3147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3148:
3149: EXCEPTION

Line 3156: FND_MSG_PUB.Add;

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;
3157: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3159: end;
3160:

Line 3157: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
3157: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3159: end;
3160:
3161:

Line 3158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3154: FND_MESSAGE.SET_TOKEN('APINAME', l_api_name);
3155: FND_MESSAGE.SET_TOKEN('ERRMSG', sqlerrm);
3156: FND_MSG_PUB.Add;
3157: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3158: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3159: end;
3160:
3161:
3162:

Line 3208: FND_MSG_PUB.initialize;

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
3212: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3258: FND_MSG_PUB.Add;

3254: IF l_return_status = 'S' THEN
3255: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
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:

Line 3259: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

3255: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully update LNS_LOAN_HEADERS_ALL');
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: -- --------------------------------------------------------------------

Line 3272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3268: COMMIT WORK;
3269: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3270: end if;
3271:
3272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3273:
3274: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3275:
3276: EXCEPTION

Line 3280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
3284:

Line 3458: FND_MSG_PUB.initialize;

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
3462: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3526: FND_MSG_PUB.ADD;

3522: if (l_STATUS <> 'PENDING') then
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);

Line 3561: FND_MSG_PUB.Add;

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;
3564: END IF;
3565:

Line 3562: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
3564: END IF;
3565:
3566: open get_psa_cur(l_loan_id);

Line 3709: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
3713: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created loan with id ' || l_new_loan_id);

Line 3736: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
3740: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_CUSTOM_PUB.saveCustomSchedule...');

Line 3757: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
3761: end if;

Line 3786: FND_MSG_PUB.Add;

3782: FND_MESSAGE.SET_TOKEN('LOAN', l_LOAN_NUMBER);
3783: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_REQUESTED_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_LOAN_CURRENCY,50)));
3784: FND_MESSAGE.SET_TOKEN('CURR', l_LOAN_CURRENCY);
3785: FND_MESSAGE.SET_TOKEN('BORROWER', l_borrower_name);
3786: FND_MSG_PUB.Add;
3787: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
3788: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
3789:
3790: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);

Line 3787: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');

3783: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_REQUESTED_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_LOAN_CURRENCY,50)));
3784: FND_MESSAGE.SET_TOKEN('CURR', l_LOAN_CURRENCY);
3785: FND_MESSAGE.SET_TOKEN('BORROWER', l_borrower_name);
3786: FND_MSG_PUB.Add;
3787: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
3788: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
3789:
3790: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);
3791:

Line 3788: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);

3784: FND_MESSAGE.SET_TOKEN('CURR', l_LOAN_CURRENCY);
3785: FND_MESSAGE.SET_TOKEN('BORROWER', l_borrower_name);
3786: FND_MSG_PUB.Add;
3787: l_agreement_reason := FND_MSG_PUB.Get(p_encoded => 'F');
3788: FND_MSG_PUB.DELETE_MSG(FND_MSG_PUB.COUNT_MSG);
3789:
3790: LNS_REP_UTILS.STORE_LOAN_AGREEMENT_CP(l_loan_id, l_agreement_reason);
3791:
3792: -- --------------------------------------------------------------------

Line 3801: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3797: COMMIT WORK;
3798: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3799: end if;
3800:
3801: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3802:
3803: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3804:
3805: EXCEPTION

Line 3812: FND_MSG_PUB.Add;

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;
3813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3815: end;
3816:

Line 3813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
3813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3815: end;
3816:
3817:

Line 3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3810: FND_MESSAGE.SET_TOKEN('APINAME', l_api_name);
3811: FND_MESSAGE.SET_TOKEN('ERRMSG', sqlerrm);
3812: FND_MSG_PUB.Add;
3813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3815: end;
3816:
3817:
3818:

Line 3850: FND_MSG_PUB.initialize;

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
3854: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3888: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

3884: COMMIT WORK;
3885: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Commited');
3886: end if;
3887:
3888: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3889:
3890: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
3891:
3892: EXCEPTION

Line 3896: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

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:
3900: