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_MESSAGE

Line 278: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALCULATE_PAYOFF_ERROR');

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

Line 360: FND_MESSAGE.SET_NAME('LNS', 'LNS_UNAPPLY_CASH_ERROR');

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;
364: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 361: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');

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;
364: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
365: RAISE FND_API.G_EXC_ERROR;

Line 362: FND_MESSAGE.SET_TOKEN('VALUE', l_receipt_number);

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

Line 419: FND_MESSAGE.SET_NAME('LNS', 'LNS_CREDIT_MEMO_ERROR');

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

Line 486: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');

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

Line 507: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_SUMMARY_ERROR');

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

Line 546: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYOFF_SHORT_CASH');

542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - total receipts: ' || l_total_receipts_amount);
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;

Line 595: FND_MESSAGE.SET_NAME('LNS', 'LNS_ALL_RECEIPTS_EXHAUSTED');

591: if l_found = 'X' then
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;

Line 641: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPLY_CASH_ERROR');

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;
645: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 642: FND_MESSAGE.SET_TOKEN('PARAMETER', 'RECEIPT_NUMBER');

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;
645: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
646: RAISE FND_API.G_EXC_ERROR;

Line 643: FND_MESSAGE.SET_TOKEN('VALUE', l_cash_receipt_ids(j).receipt_number);

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

Line 927: --FND_MESSAGE.SET_NAME('LNS', 'LNS_UPDATE_HEADER_ERROR');

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

Line 1177: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');

1173: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' p_trans_to_receipt_rate: ' || p_trans_to_receipt_rate);
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;

Line 1184: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');

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

Line 1195: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');

1191: open receipt_cur(P_CASH_RECEIPT_ID);
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;

Line 1204: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');

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

Line 1247: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');

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

Line 1561: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

1557: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_cancellation_date = ' || p_cancellation_date);
1558:
1559: /* verify input parameters */
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;

Line 1562: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_LOAN_ID');

1558:
1559: /* verify input parameters */
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;

Line 1563: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

1559: /* verify input parameters */
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

Line 1568: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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');
1570: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);
1571: FND_MSG_PUB.ADD;
1572: RAISE FND_API.G_EXC_ERROR;

Line 1569: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_cancellation_date');

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');
1570: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);
1571: FND_MSG_PUB.ADD;
1572: RAISE FND_API.G_EXC_ERROR;
1573: end if;

Line 1570: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);

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

Line 1863: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

1859: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_LOAN_CANCELLATION_ID = ' || p_LOAN_CANCELLATION_ID);
1860:
1861: -- verify input parameters
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;

Line 1864: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_LOAN_ID');

1860:
1861: -- verify input parameters
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;

Line 1865: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);

1861: -- verify input parameters
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

Line 1870: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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');
1872: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);
1873: FND_MSG_PUB.ADD;
1874: RAISE FND_API.G_EXC_ERROR;

Line 1871: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_cancellation_date');

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');
1872: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);
1873: FND_MSG_PUB.ADD;
1874: RAISE FND_API.G_EXC_ERROR;
1875: end if;

Line 1872: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);

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

Line 1891: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_LN_STATUS');

1887: l_loan_status <> 'FUNDING_ERROR' and
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:

Line 1904: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_ALREADY_EXIST');

1900: fetch pending_count_cur into l_count;
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;

Line 1915: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_STATUS');

1911: fetch cancel_request_cur into l_status, l_CANCELLATION_DATE;
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;

Line 1922: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 1923: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_cancellation_date');

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

Line 1924: FND_MESSAGE.SET_TOKEN('VALUE', p_cancellation_date);

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

Line 1987: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

1983:
1984: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);
1985: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
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;

Line 1988: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled principal amount');

1984: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);
1985: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
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;

Line 1989: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_prin);

1985: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
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:

Line 1997: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 1998: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid principal amount');

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

Line 1999: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_prin);

1995: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);
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:

Line 2007: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2008: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled interest amount');

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

Line 2009: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_int);

2005: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);
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:

Line 2017: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2018: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid interest amount');

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

Line 2019: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_int);

2015: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);
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:

Line 2027: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2028: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled fee amount');

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

Line 2029: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_fee);

2025: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);
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:

Line 2037: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2038: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid fee amount');

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

Line 2039: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_fee);

2035: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);
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:

Line 2117: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

2113: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'P_LOAN_CANCELLATION_ID = ' || P_LOAN_CANCELLATION_ID);
2114:
2115: -- verify input parameters
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;

Line 2118: FND_MESSAGE.SET_TOKEN('PARAMETER', 'P_LOAN_CANCELLATION_ID');

2114:
2115: -- verify input parameters
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;

Line 2119: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_CANCELLATION_ID);

2115: -- verify input parameters
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:

Line 2149: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_LN_STATUS');

2145: l_loan_status <> 'FUNDING_ERROR' and
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:

Line 2158: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANCEL_INVAL_STATUS');

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

Line 2232: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

2228:
2229: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);
2230: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
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;

Line 2233: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled principal amount');

2229: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_payoff_unbilled_prin = ' || l_payoff_unbilled_prin);
2230: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
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;

Line 2234: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_prin);

2230: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_prin = ' || l_unbilled_prin);
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:

Line 2242: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2243: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid principal amount');

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

Line 2244: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_prin);

2240: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_prin = ' || l_billed_prin);
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:

Line 2252: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2253: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled interest amount');

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

Line 2254: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_int);

2250: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_int = ' || l_unbilled_int);
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:

Line 2262: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2263: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid interest amount');

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

Line 2264: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_int);

2260: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_int = ' || l_billed_int);
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:

Line 2272: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2273: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total unbilled fee amount');

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

Line 2274: FND_MESSAGE.SET_TOKEN('VALUE', l_unbilled_fee);

2270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_unbilled_fee = ' || l_unbilled_fee);
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:

Line 2282: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

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

Line 2283: FND_MESSAGE.SET_TOKEN('PARAMETER', 'total billed unpaid fee amount');

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

Line 2284: FND_MESSAGE.SET_TOKEN('VALUE', l_billed_fee);

2280: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_billed_fee = ' || l_billed_fee);
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:

Line 2569: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

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

Line 2756: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');

2752: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_receivables_trx_id = ' || l_receivables_trx_id);
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;

Line 2873: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');

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

Line 2947: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

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

Line 2967: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');

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

Line 3130: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

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

Line 3153: FND_MESSAGE.SET_NAME('LNS', 'LNS_PLSQL_API_ERROR');

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;
3157: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3154: FND_MESSAGE.SET_TOKEN('APINAME', l_api_name);

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

Line 3155: FND_MESSAGE.SET_TOKEN('ERRMSG', sqlerrm);

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

Line 3257: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');

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

Line 3523: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

3519: ,l_borrower_name;
3520: close split_details_cur;
3521:
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;

Line 3524: FND_MESSAGE.SET_TOKEN('PARAMETER', 'status');

3520: close split_details_cur;
3521:
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;

Line 3525: FND_MESSAGE.SET_TOKEN('VALUE', l_STATUS);

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

Line 3560: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVOICE_CREATION_ERROR');

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

Line 3780: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_SPLIT_AGR_REASON');

3776: where LOAN_SPLIT_ID = p_LOAN_SPLIT_ID;
3777: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3778:
3779: -- fix for bug 14491711
3780: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_SPLIT_AGR_REASON');
3781: FND_MESSAGE.SET_TOKEN('SPLIT', l_split_request);
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);

Line 3781: FND_MESSAGE.SET_TOKEN('SPLIT', l_split_request);

3777: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
3778:
3779: -- fix for bug 14491711
3780: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_SPLIT_AGR_REASON');
3781: FND_MESSAGE.SET_TOKEN('SPLIT', l_split_request);
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);

Line 3782: FND_MESSAGE.SET_TOKEN('LOAN', l_LOAN_NUMBER);

3778:
3779: -- fix for bug 14491711
3780: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_SPLIT_AGR_REASON');
3781: FND_MESSAGE.SET_TOKEN('SPLIT', l_split_request);
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;

Line 3783: FND_MESSAGE.SET_TOKEN('AMOUNT', to_char(l_REQUESTED_AMOUNT, FND_CURRENCY.SAFE_GET_FORMAT_MASK(l_LOAN_CURRENCY,50)));

3779: -- fix for bug 14491711
3780: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_SPLIT_AGR_REASON');
3781: FND_MESSAGE.SET_TOKEN('SPLIT', l_split_request);
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');

Line 3784: FND_MESSAGE.SET_TOKEN('CURR', l_LOAN_CURRENCY);

3780: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_SPLIT_AGR_REASON');
3781: FND_MESSAGE.SET_TOKEN('SPLIT', l_split_request);
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);

Line 3785: FND_MESSAGE.SET_TOKEN('BORROWER', l_borrower_name);

3781: FND_MESSAGE.SET_TOKEN('SPLIT', l_split_request);
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:

Line 3809: FND_MESSAGE.SET_NAME('LNS', 'LNS_PLSQL_API_ERROR');

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;
3813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3810: FND_MESSAGE.SET_TOKEN('APINAME', l_api_name);

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

Line 3811: FND_MESSAGE.SET_TOKEN('ERRMSG', sqlerrm);

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