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_FINANCIALS dependencies on FND_MESSAGE

Line 468: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_TERMS');

464:
465: Exception
466: When No_Data_Found then
467: CLOSE c_terms;
468: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_TERMS');
469: FND_MSG_PUB.Add;
470: RAISE FND_API.G_EXC_ERROR;
471: end;
472:

Line 477: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_RATE_SCHEDULE');

473: -- rate schedules should have one row
474: l_rate_tbl := lns_financials.getRateSchedule(p_loan_id, 'TERM');
475:
476: if l_rate_tbl.count = 0 then
477: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_RATE_SCHEDULE');
478: FND_MSG_PUB.Add;
479: RAISE FND_API.G_EXC_ERROR;
480: end if;
481:

Line 485: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_AMOUNT');

481:
482: Begin
483: l_amount := lns_financials.getRemainingBalance(p_loan_id);
484: if l_amount <= 0 then
485: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_AMOUNT');
486: FND_MSG_PUB.Add;
487: RAISE FND_API.G_EXC_ERROR;
488: end if;
489:

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

648: ,p_col_name => 'LOAN_ID'
649: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
650:
651: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
652: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
653: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
654: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
655: FND_MSG_PUB.ADD;
656: RAISE FND_API.G_EXC_ERROR;

Line 653: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

649: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
650:
651: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
652: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
653: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
654: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
655: FND_MSG_PUB.ADD;
656: RAISE FND_API.G_EXC_ERROR;
657: end if;

Line 654: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);

650:
651: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
652: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
653: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
654: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
655: FND_MSG_PUB.ADD;
656: RAISE FND_API.G_EXC_ERROR;
657: end if;
658:

Line 1004: FND_MESSAGE.Set_Name('LNS', 'LNS_NEVER_PAYOFF');

1000: if l_periodic_rate <> 0 then
1001: -- we cannot have LN < 0
1002: -- this will be a loan that will never be paid off
1003: if ( l_periodic_rate * p_loan_amount ) / (p_payments_per_year * p_termly_amount) >= 1 then
1004: FND_MESSAGE.Set_Name('LNS', 'LNS_NEVER_PAYOFF');
1005: FND_MSG_PUB.Add;
1006: RAISE FND_API.G_EXC_ERROR;
1007: end if;
1008:

Line 1473: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');

1469: ,x_msg_count => l_msg_count
1470: ,x_msg_data => l_msg_data);
1471:
1472: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1473: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1474: FND_MSG_PUB.ADD;
1475: RAISE FND_API.G_EXC_ERROR;
1476: end if;
1477:

Line 1787: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');

1783: ,x_msg_data => l_msg_data);
1784:
1785: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_return_status = ' || l_return_status);
1786: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1787: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1788: FND_MSG_PUB.ADD;
1789: RAISE FND_API.G_EXC_ERROR;
1790: end if;
1791: end if;

Line 1806: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');

1802: ,x_msg_data => l_msg_data);
1803:
1804: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_return_status = ' || l_return_status);
1805: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1806: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1807: FND_MSG_PUB.ADD;
1808: RAISE FND_API.G_EXC_ERROR;
1809: end if;
1810:

Line 1831: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');

1827: ,x_msg_data => l_msg_data);
1828:
1829: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_return_status = ' || l_return_status);
1830: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1831: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1832: FND_MSG_PUB.ADD;
1833: RAISE FND_API.G_EXC_ERROR;
1834: end if;
1835: end if;

Line 1849: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');

1845: ,x_msg_count => l_msg_count
1846: ,x_msg_data => l_msg_data);
1847:
1848: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1849: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
1850: FND_MSG_PUB.ADD;
1851: RAISE FND_API.G_EXC_ERROR;
1852: end if;
1853:

Line 2134: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');

2130: ,x_msg_count => l_msg_count
2131: ,x_msg_data => l_msg_data);
2132:
2133: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2134: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
2135: FND_MSG_PUB.ADD;
2136: RAISE FND_API.G_EXC_ERROR;
2137: end if;
2138:

Line 6546: FND_MESSAGE.SET_NAME('LNS', 'LNS_COMPUTE_BALANCE_ERROR');

6542:
6543: end if;
6544: exception
6545: when others then
6546: FND_MESSAGE.SET_NAME('LNS', 'LNS_COMPUTE_BALANCE_ERROR');
6547: FND_MSG_PUB.ADD;
6548: LogMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
6549: RAISE FND_API.G_EXC_ERROR;
6550: end;

Line 6683: FND_MESSAGE.SET_NAME('LNS', 'LNS_COMPUTE_BALANCE_ERROR');

6679:
6680: end if;
6681: exception
6682: when others then
6683: FND_MESSAGE.SET_NAME('LNS', 'LNS_COMPUTE_BALANCE_ERROR');
6684: FND_MSG_PUB.ADD;
6685: LogMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
6686: RAISE FND_API.G_EXC_ERROR;
6687: end;

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

6981: ,p_col_name => 'LOAN_ID'
6982: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
6983:
6984: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6985: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6986: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
6987: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
6988: FND_MSG_PUB.ADD;
6989: RAISE FND_API.G_EXC_ERROR;

Line 6986: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

6982: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
6983:
6984: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6985: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6986: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
6987: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
6988: FND_MSG_PUB.ADD;
6989: RAISE FND_API.G_EXC_ERROR;
6990: end if;

Line 6987: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);

6983:
6984: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6985: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6986: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
6987: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
6988: FND_MSG_PUB.ADD;
6989: RAISE FND_API.G_EXC_ERROR;
6990: end if;
6991:

Line 6998: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REQ_DATE_ERR');

6994: fetch c_disbursements into l_disb_amount;
6995: close c_disbursements;
6996:
6997: if l_invalid_disb > 0 then
6998: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REQ_DATE_ERR');
6999: FND_MSG_PUB.ADD;
7000: RAISE FND_API.G_EXC_ERROR;
7001: end if;
7002:

Line 7188: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_RATES');

7184: l_rate_tbl(i).FLOATING_FLAG := l_floating_flag;
7185: END LOOP;
7186: Exception
7187: When No_Data_Found then
7188: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_RATES');
7189: FND_MSG_PUB.Add;
7190: RAISE FND_API.G_EXC_ERROR;
7191: End;
7192:

Line 8079: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_LOAN_ID');

8075:
8076: Exception
8077: When No_Data_Found then
8078: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LOAN ID: ' || l_loan_id || ' not found');
8079: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_LOAN_ID');
8080: FND_MSG_PUB.Add;
8081: RAISE FND_API.G_EXC_ERROR;
8082:
8083: When Others then

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

8456: ,p_col_name => 'LOAN_ID'
8457: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
8458:
8459: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8460: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
8461: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
8462: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
8463: FND_MSG_PUB.ADD;
8464: RAISE FND_API.G_EXC_ERROR;

Line 8461: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

8457: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
8458:
8459: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8460: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
8461: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
8462: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
8463: FND_MSG_PUB.ADD;
8464: RAISE FND_API.G_EXC_ERROR;
8465: end if;

Line 8462: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);

8458:
8459: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8460: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
8461: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
8462: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
8463: FND_MSG_PUB.ADD;
8464: RAISE FND_API.G_EXC_ERROR;
8465: end if;
8466:

Line 8512: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

8508:
8509: EXCEPTION
8510: WHEN OTHERS THEN
8511: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);
8512: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
8513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
8514: FND_MSG_PUB.ADD;
8515: RAISE FND_API.G_EXC_ERROR;
8516: END;

Line 8513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

8509: EXCEPTION
8510: WHEN OTHERS THEN
8511: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'ERROR: ' || sqlerrm);
8512: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
8513: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
8514: FND_MSG_PUB.ADD;
8515: RAISE FND_API.G_EXC_ERROR;
8516: END;
8517:

Line 8523: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');

8519: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_new_prin_first_pay_date: ' || l_new_prin_first_pay_date);
8520: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_new_maturity_date: ' || l_new_maturity_date);
8521:
8522: if l_new_int_first_pay_date is null or l_new_int_first_pay_date < p_new_start_date then
8523: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');
8524: FND_MSG_PUB.ADD;
8525: RAISE FND_API.G_EXC_ERROR;
8526: end if;
8527:

Line 8529: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYMENT_START_DATE_ERROR1');

8525: RAISE FND_API.G_EXC_ERROR;
8526: end if;
8527:
8528: if l_new_int_first_pay_date > l_new_maturity_date then
8529: FND_MESSAGE.SET_NAME('LNS', 'LNS_PAYMENT_START_DATE_ERROR1');
8530: FND_MSG_PUB.ADD;
8531: RAISE FND_API.G_EXC_ERROR;
8532: end if;
8533:

Line 8536: FND_MESSAGE.SET_NAME('LNS', 'LNS_PRIN_PAY_START_DATE_ERROR2');

8532: end if;
8533:
8534: if l_loan_details.PRIN_FIRST_PAY_DATE is not null then
8535: if l_new_prin_first_pay_date is null or l_new_prin_first_pay_date < p_new_start_date then
8536: FND_MESSAGE.SET_NAME('LNS', 'LNS_PRIN_PAY_START_DATE_ERROR2');
8537: FND_MSG_PUB.ADD;
8538: RAISE FND_API.G_EXC_ERROR;
8539: end if;
8540:

Line 8542: FND_MESSAGE.SET_NAME('LNS', 'LNS_PRIN_PAY_START_DATE_ERROR1');

8538: RAISE FND_API.G_EXC_ERROR;
8539: end if;
8540:
8541: if l_new_prin_first_pay_date > l_new_maturity_date then
8542: FND_MESSAGE.SET_NAME('LNS', 'LNS_PRIN_PAY_START_DATE_ERROR1');
8543: FND_MSG_PUB.ADD;
8544: RAISE FND_API.G_EXC_ERROR;
8545: end if;
8546: end if;

Line 8890: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_ALREADY');

8886:
8887:
8888: -- these dates should be further restricted
8889: if p_loan_details.loan_status = 'PAIDOFF' then
8890: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_ALREADY');
8891: FND_MSG_PUB.Add;
8892: RAISE FND_API.G_EXC_ERROR;
8893:
8894: --karamach --Bug5295446 --Need to prevent payoff for loans in Approved status as well

Line 8898: FND_MESSAGE.Set_Name('LNS', 'LNS_INVOICE_SUMMARY_ERROR');

8894: --karamach --Bug5295446 --Need to prevent payoff for loans in Approved status as well
8895: --elsif p_loan_details.loan_status = 'INCOMPLETE' or p_loan_details.loan_status = 'DELETED' or
8896: -- p_loan_details.loan_status = 'REJECTED' or p_loan_details.loan_status = 'PENDING' then
8897: elsif p_loan_details.loan_status IN ('INCOMPLETE','DELETED','REJECTED','PENDING') then
8898: FND_MESSAGE.Set_Name('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
8899: FND_MSG_PUB.Add;
8900: RAISE FND_API.G_EXC_ERROR;
8901: end if;
8902:

Line 8905: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY');

8901: end if;
8902:
8903: if p_payoff_date < p_loan_details.last_interest_accrual then
8904: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8905: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY');
8906: FND_MESSAGE.SET_TOKEN('PAYOFF_DATE', fnd_date.date_to_displaydate(p_loan_details.last_interest_accrual));
8907: FND_MSG_PUB.Add;
8908: RAISE FND_API.G_EXC_ERROR;
8909: end if;

Line 8906: FND_MESSAGE.SET_TOKEN('PAYOFF_DATE', fnd_date.date_to_displaydate(p_loan_details.last_interest_accrual));

8902:
8903: if p_payoff_date < p_loan_details.last_interest_accrual then
8904: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8905: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY');
8906: FND_MESSAGE.SET_TOKEN('PAYOFF_DATE', fnd_date.date_to_displaydate(p_loan_details.last_interest_accrual));
8907: FND_MSG_PUB.Add;
8908: RAISE FND_API.G_EXC_ERROR;
8909: end if;
8910:

Line 8913: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');

8909: end if;
8910:
8911: if p_payoff_date < p_loan_details.last_activity_date then
8912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8913: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');
8914: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');
8915: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));
8916: FND_MSG_PUB.Add;
8917: RAISE FND_API.G_EXC_ERROR;

Line 8914: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');

8910:
8911: if p_payoff_date < p_loan_details.last_activity_date then
8912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8913: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');
8914: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');
8915: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));
8916: FND_MSG_PUB.Add;
8917: RAISE FND_API.G_EXC_ERROR;
8918: end if;

Line 8915: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));

8911: if p_payoff_date < p_loan_details.last_activity_date then
8912: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8913: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');
8914: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');
8915: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));
8916: FND_MSG_PUB.Add;
8917: RAISE FND_API.G_EXC_ERROR;
8918: end if;
8919:

Line 9219: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');

9215: ,x_msg_count => l_msg_count
9216: ,x_msg_data => l_msg_data);
9217:
9218: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9219: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
9220: FND_MSG_PUB.ADD;
9221: RAISE FND_API.G_EXC_ERROR;
9222: end if;
9223: end if;

Line 9558: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INTERVAL');

9554: x_ppy := 2;
9555: elsif p_frequency = 'YEARLY' then
9556: x_ppy := 1;
9557: else
9558: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INTERVAL');
9559: FND_MESSAGE.SET_TOKEN('INTERVAL',p_frequency);
9560: FND_MSG_PUB.Add;
9561: RAISE FND_API.G_EXC_ERROR;
9562: end if;

Line 9559: FND_MESSAGE.SET_TOKEN('INTERVAL',p_frequency);

9555: elsif p_frequency = 'YEARLY' then
9556: x_ppy := 1;
9557: else
9558: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INTERVAL');
9559: FND_MESSAGE.SET_TOKEN('INTERVAL',p_frequency);
9560: FND_MSG_PUB.Add;
9561: RAISE FND_API.G_EXC_ERROR;
9562: end if;
9563:

Line 9980: -- FND_MESSAGE.Set_Name('LNS', 'LNS_UNABLE_TO_COMPUTE_BALANCE');

9976:
9977: When Others then
9978: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Error: ' || sqlerrm);
9979: --seed this message
9980: -- FND_MESSAGE.Set_Name('LNS', 'LNS_UNABLE_TO_COMPUTE_BALANCE');
9981: -- FND_MSG_PUB.Add;
9982: -- RAISE FND_API.G_EXC_ERROR;
9983:
9984: end getAnnualRate;

Line 10267: FND_MESSAGE.Set_Name('LNS', 'LNS_UNABLE_TO_COMPUTE_BALANCE');

10263: Exception
10264: When Others then
10265: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Error: ' || sqlerrm);
10266: --seed this message
10267: FND_MESSAGE.Set_Name('LNS', 'LNS_UNABLE_TO_COMPUTE_BALANCE');
10268: FND_MSG_PUB.Add;
10269: RAISE FND_API.G_EXC_ERROR;
10270: */
10271: end getRemainingBalance;

Line 10645: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_ACTIVE_DATE');

10641: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_phase: ' || p_phase);
10642:
10643: -- validate the from and to Dates
10644: if p_from_date > p_to_date then
10645: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_ACTIVE_DATE');
10646: FND_MSG_PUB.Add;
10647: RAISE FND_API.G_EXC_ERROR;
10648: end if;
10649:

Line 10851: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_ACTIVE_DATE');

10847: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_date: ' || p_to_date);
10848:
10849: -- validate the from and to Dates
10850: if p_from_date > p_to_date then
10851: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_ACTIVE_DATE');
10852: FND_MSG_PUB.Add;
10853: RAISE FND_API.G_EXC_ERROR;
10854: end if;
10855:

Line 10868: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR1');

10864: ,p_phase => l_loan_phase);
10865:
10866: -- validate if dates are within the boundaries of loan_start and maturity_dates
10867: if p_to_date > l_loan_details.maturity_date then
10868: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR1');
10869: FND_MSG_PUB.Add;
10870: RAISE FND_API.G_EXC_ERROR;
10871: end if;
10872:

Line 10874: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');

10870: RAISE FND_API.G_EXC_ERROR;
10871: end if;
10872:
10873: if p_from_date < l_loan_details.loan_start_date then
10874: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');
10875: FND_MSG_PUB.Add;
10876: RAISE FND_API.G_EXC_ERROR;
10877: end if;
10878:

Line 12164: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');

12160: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, ' - in exception. Error: ' || sqlerrm);
12161: --dbms_lob.freetemporary(l_clob);
12162: dbms_xmlparser.freeParser(l_parser);
12163: dbms_xmldom.freeDocument(l_doc);
12164: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
12165: FND_MESSAGE.SET_TOKEN('ERROR' ,sqlerrm);
12166: FND_MSG_PUB.Add;
12167: END;
12168:

Line 12165: FND_MESSAGE.SET_TOKEN('ERROR' ,sqlerrm);

12161: --dbms_lob.freetemporary(l_clob);
12162: dbms_xmlparser.freeParser(l_parser);
12163: dbms_xmldom.freeDocument(l_doc);
12164: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
12165: FND_MESSAGE.SET_TOKEN('ERROR' ,sqlerrm);
12166: FND_MSG_PUB.Add;
12167: END;
12168:
12169: