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 466: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_TERMS');

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

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

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

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

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

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

683: ,p_col_name => 'LOAN_ID'
684: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
685:
686: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
687: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
688: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
689: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;

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

684: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
685:
686: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
687: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
688: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
689: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;
692: end if;

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

685:
686: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
687: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
688: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
689: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;
692: end if;
693: /*

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

1071: if l_periodic_rate <> 0 then
1072: -- we cannot have LN < 0
1073: -- this will be a loan that will never be paid off
1074: if ( l_periodic_rate * p_loan_amount ) / (p_payments_per_year * p_termly_amount) >= 1 then
1075: FND_MESSAGE.Set_Name('LNS', 'LNS_NEVER_PAYOFF');
1076: FND_MSG_PUB.Add;
1077: RAISE FND_API.G_EXC_ERROR;
1078: end if;
1079:

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

1541: ,x_msg_count => l_msg_count
1542: ,x_msg_data => l_msg_data);
1543:
1544: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1545: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
1546: FND_MSG_PUB.ADD;
1547: RAISE FND_API.G_EXC_ERROR;
1548: end if;
1549:

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

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

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

1866: ,x_msg_count => l_msg_count
1867: ,x_msg_data => l_msg_data);
1868:
1869: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1870: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
1871: FND_MSG_PUB.ADD;
1872: RAISE FND_API.G_EXC_ERROR;
1873: end if;
1874:

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

2146: ,p_phase => 'OPEN'
2147: ,p_day_count_method => l_loan_Details.day_count_method);
2148: exception
2149: when others then
2150: FND_MESSAGE.SET_NAME('LNS', 'LNS_COMPUTE_BALANCE_ERROR');
2151: FND_MSG_PUB.ADD;
2152: RAISE FND_API.G_EXC_ERROR;
2153:
2154: end;

Line 2196: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');

2192:
2193: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': FLOATING RECALCULATE');
2194: -- raise error as rates does not exist
2195: if l_rate_details.ANNUAL_RATE is null then
2196: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
2197: FND_MSG_PUB.ADD;
2198: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || l_loan_details.OPEN_INDEX_RATE_ID);
2199: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || l_loan_details.NEXT_RATE_CHANGE_DATE);
2200: RAISE FND_API.G_EXC_ERROR;

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

2259: ,x_msg_count => l_msg_count
2260: ,x_msg_data => l_msg_data);
2261:
2262: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2263: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
2264: FND_MSG_PUB.ADD;
2265: RAISE FND_API.G_EXC_ERROR;
2266: end if;
2267:

Line 2980: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');

2976: ,l_payment_tbl(l_installment_number).period_begin_date);
2977:
2978: -- raise error as rates does not exist
2979: if l_rate_details.ANNUAL_RATE is null then
2980: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
2981: FND_MSG_PUB.ADD;
2982: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || p_loan_details.TERM_INDEX_RATE_ID);
2983: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || p_loan_details.NEXT_RATE_CHANGE_DATE);
2984: RAISE FND_API.G_EXC_ERROR;

Line 4072: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');

4068: ,l_payment_tbl(l_installment_number).period_begin_date);
4069:
4070: -- raise error as rates does not exist
4071: if l_rate_details.ANNUAL_RATE is null then
4072: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
4073: FND_MSG_PUB.ADD;
4074: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || p_loan_details.TERM_INDEX_RATE_ID);
4075: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || p_loan_details.NEXT_RATE_CHANGE_DATE);
4076: RAISE FND_API.G_EXC_ERROR;

Line 5086: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');

5082: ,l_payment_tbl(l_installment_number).period_begin_date);
5083:
5084: -- raise error as rates does not exist
5085: if l_rate_details.ANNUAL_RATE is null then
5086: FND_MESSAGE.SET_NAME('LNS', 'LNS_RATES_ERROR');
5087: FND_MSG_PUB.ADD;
5088: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for INDEX_ID ' || p_loan_details.TERM_INDEX_RATE_ID);
5089: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': rates missing for DATE ' || p_loan_details.NEXT_RATE_CHANGE_DATE);
5090: RAISE FND_API.G_EXC_ERROR;

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

5835: ,p_phase => 'OPEN'
5836: ,p_day_count_method => l_day_count_method);
5837: exception
5838: when others then
5839: FND_MESSAGE.SET_NAME('LNS', 'LNS_COMPUTE_BALANCE_ERROR');
5840: FND_MSG_PUB.ADD;
5841: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - ERROR COMPUTING BALANCE');
5842: RAISE FND_API.G_EXC_ERROR;
5843: end;

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

6108: ,p_col_name => 'LOAN_ID'
6109: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
6110:
6111: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6112: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6113: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
6114: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
6115: FND_MSG_PUB.ADD;
6116: RAISE FND_API.G_EXC_ERROR;

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

6109: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
6110:
6111: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6112: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6113: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
6114: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
6115: FND_MSG_PUB.ADD;
6116: RAISE FND_API.G_EXC_ERROR;
6117: end if;

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

6110:
6111: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6112: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6113: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
6114: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
6115: FND_MSG_PUB.ADD;
6116: RAISE FND_API.G_EXC_ERROR;
6117: end if;
6118:

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

6126: fetch c_invalid_disb into l_invalid_disb;
6127: close c_invalid_disb;
6128:
6129: if l_invalid_disb > 0 then
6130: FND_MESSAGE.SET_NAME('LNS', 'LNS_DISB_REQ_DATE_ERR');
6131: FND_MSG_PUB.ADD;
6132: RAISE FND_API.G_EXC_ERROR;
6133: end if;
6134:

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

6335: l_rate_tbl(i).FLOATING_FLAG := l_floating_flag;
6336: END LOOP;
6337: Exception
6338: When No_Data_Found then
6339: FND_MESSAGE.Set_Name('LNS', 'LNS_NO_RATES');
6340: FND_MSG_PUB.Add;
6341: RAISE FND_API.G_EXC_ERROR;
6342: End;
6343:

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

7294:
7295: Exception
7296: When No_Data_Found then
7297: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LOAN ID: ' || l_loan_id || ' not found');
7298: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_LOAN_ID');
7299: FND_MSG_PUB.Add;
7300: RAISE FND_API.G_EXC_ERROR;
7301:
7302: When Others then

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

7669: ,p_col_name => 'LOAN_ID'
7670: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
7671:
7672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
7673: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
7674: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
7675: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
7676: FND_MSG_PUB.ADD;
7677: RAISE FND_API.G_EXC_ERROR;

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

7670: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
7671:
7672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
7673: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
7674: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
7675: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
7676: FND_MSG_PUB.ADD;
7677: RAISE FND_API.G_EXC_ERROR;
7678: end if;

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

7671:
7672: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
7673: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
7674: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
7675: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
7676: FND_MSG_PUB.ADD;
7677: RAISE FND_API.G_EXC_ERROR;
7678: end if;
7679:

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

8095:
8096:
8097: -- these dates should be further restricted
8098: if p_loan_details.loan_status = 'PAIDOFF' then
8099: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_ALREADY');
8100: FND_MSG_PUB.Add;
8101: RAISE FND_API.G_EXC_ERROR;
8102:
8103: --karamach --Bug5295446 --Need to prevent payoff for loans in Approved status as well

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

8103: --karamach --Bug5295446 --Need to prevent payoff for loans in Approved status as well
8104: --elsif p_loan_details.loan_status = 'INCOMPLETE' or p_loan_details.loan_status = 'DELETED' or
8105: -- p_loan_details.loan_status = 'REJECTED' or p_loan_details.loan_status = 'PENDING' then
8106: elsif p_loan_details.loan_status IN ('INCOMPLETE','DELETED','REJECTED','PENDING','APPROVED') then
8107: FND_MESSAGE.Set_Name('LNS', 'LNS_INVOICE_SUMMARY_ERROR');
8108: FND_MSG_PUB.Add;
8109: RAISE FND_API.G_EXC_ERROR;
8110: end if;
8111:

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

8110: end if;
8111:
8112: if p_payoff_date < p_loan_details.last_interest_accrual then
8113: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8114: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY');
8115: FND_MESSAGE.SET_TOKEN('PAYOFF_DATE', fnd_date.date_to_displaydate(p_loan_details.last_interest_accrual));
8116: FND_MSG_PUB.Add;
8117: RAISE FND_API.G_EXC_ERROR;
8118: end if;

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

8111:
8112: if p_payoff_date < p_loan_details.last_interest_accrual then
8113: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8114: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY');
8115: FND_MESSAGE.SET_TOKEN('PAYOFF_DATE', fnd_date.date_to_displaydate(p_loan_details.last_interest_accrual));
8116: FND_MSG_PUB.Add;
8117: RAISE FND_API.G_EXC_ERROR;
8118: end if;
8119:

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

8118: end if;
8119:
8120: if p_payoff_date < p_loan_details.last_activity_date then
8121: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8122: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');
8123: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');
8124: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));
8125: FND_MSG_PUB.Add;
8126: RAISE FND_API.G_EXC_ERROR;

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

8119:
8120: if p_payoff_date < p_loan_details.last_activity_date then
8121: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8122: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');
8123: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');
8124: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));
8125: FND_MSG_PUB.Add;
8126: RAISE FND_API.G_EXC_ERROR;
8127: end if;

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

8120: if p_payoff_date < p_loan_details.last_activity_date then
8121: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - payoff too early');
8122: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYOFF_TOO_EARLY2');
8123: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LAST_ACTIVITY_DATE');
8124: FND_MESSAGE.SET_TOKEN('VALUE', fnd_date.date_to_displaydate(p_loan_details.last_activity_date));
8125: FND_MSG_PUB.Add;
8126: RAISE FND_API.G_EXC_ERROR;
8127: end if;
8128:

Line 8331: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_PAYOFF_DATE');

8327: ,p_rate_date => p_payoff_date);
8328:
8329: if l_rate_for_date is null then
8330: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || FND_MSG_PUB.Get(p_encoded => 'F'));
8331: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_PAYOFF_DATE');
8332: FND_MSG_PUB.Add;
8333: RAISE FND_API.G_EXC_ERROR;
8334: end if;
8335:

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

8578: l_ppy := 2;
8579: elsif p_frequency = 'YEARLY' then
8580: l_ppy := 1;
8581: else
8582: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INTERVAL');
8583: FND_MESSAGE.SET_TOKEN('INTERVAL',p_frequency);
8584: FND_MSG_PUB.Add;
8585: RAISE FND_API.G_EXC_ERROR;
8586: end if;

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

8579: elsif p_frequency = 'YEARLY' then
8580: l_ppy := 1;
8581: else
8582: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_INTERVAL');
8583: FND_MESSAGE.SET_TOKEN('INTERVAL',p_frequency);
8584: FND_MSG_PUB.Add;
8585: RAISE FND_API.G_EXC_ERROR;
8586: end if;
8587:

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

8907:
8908: When Others then
8909: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Error: ' || sqlerrm);
8910: --seed this message
8911: -- FND_MESSAGE.Set_Name('LNS', 'LNS_UNABLE_TO_COMPUTE_BALANCE');
8912: -- FND_MSG_PUB.Add;
8913: -- RAISE FND_API.G_EXC_ERROR;
8914:
8915: end getAnnualRate;

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

9188: Exception
9189: When Others then
9190: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Error: ' || sqlerrm);
9191: --seed this message
9192: FND_MESSAGE.Set_Name('LNS', 'LNS_UNABLE_TO_COMPUTE_BALANCE');
9193: FND_MSG_PUB.Add;
9194: RAISE FND_API.G_EXC_ERROR;
9195: */
9196: end getRemainingBalance;

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

9441: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_calc_method: ' || p_calc_method);
9442:
9443: -- validate the from and to Dates
9444: if p_from_date > p_to_date then
9445: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_ACTIVE_DATE');
9446: FND_MSG_PUB.Add;
9447: RAISE FND_API.G_EXC_ERROR;
9448: end if;
9449: /*

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

9452: ,p_phase => 'OPEN');
9453:
9454: -- validate if dates are within the boundaries of loan_start and maturity_dates
9455: if p_to_date > l_loan_details.maturity_date then
9456: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR1');
9457: FND_MSG_PUB.Add;
9458: RAISE FND_API.G_EXC_ERROR;
9459: end if;
9460:

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

9458: RAISE FND_API.G_EXC_ERROR;
9459: end if;
9460:
9461: if p_from_date < l_loan_details.loan_start_date then
9462: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');
9463: FND_MSG_PUB.Add;
9464: RAISE FND_API.G_EXC_ERROR;
9465: end if;
9466: */

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

9647: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_date: ' || p_to_date);
9648:
9649: -- validate the from and to Dates
9650: if p_from_date > p_to_date then
9651: FND_MESSAGE.Set_Name('LNS', 'LNS_INVALID_ACTIVE_DATE');
9652: FND_MSG_PUB.Add;
9653: RAISE FND_API.G_EXC_ERROR;
9654: end if;
9655:

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

9664: ,p_phase => l_loan_phase);
9665:
9666: -- validate if dates are within the boundaries of loan_start and maturity_dates
9667: if p_to_date > l_loan_details.maturity_date then
9668: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR1');
9669: FND_MSG_PUB.Add;
9670: RAISE FND_API.G_EXC_ERROR;
9671: end if;
9672:

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

9670: RAISE FND_API.G_EXC_ERROR;
9671: end if;
9672:
9673: if p_from_date < l_loan_details.loan_start_date then
9674: FND_MESSAGE.Set_Name('LNS', 'LNS_PAYMENT_START_DATE_ERROR2');
9675: FND_MSG_PUB.Add;
9676: RAISE FND_API.G_EXC_ERROR;
9677: end if;
9678: