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

Line 289: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_SCHEDULE_READ_ERROR');

285: ,x_return_status => l_return_status
286: ,x_msg_count => l_msg_count
287: ,x_msg_data => l_msg_data);
288: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
289: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_SCHEDULE_READ_ERROR');
290: FND_MSG_PUB.ADD;
291: RAISE FND_API.G_EXC_ERROR;
292: end if;
293: end if;

Line 1303: --FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CALC_ERROR');

1299:
1300: exception
1301: when no_data_found then
1302: l_fee := -1;
1303: --FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CALC_ERROR');
1304: --FND_MSG_PUB.ADD;
1305: --RAISE FND_API.G_EXC_ERROR;
1306: end;
1307: end if;

Line 1742: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_SCHEDULE_READ_ERROR');

1738: ,x_msg_count => l_msg_count
1739: ,x_msg_data => l_msg_data);
1740:
1741: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1742: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_SCHEDULE_READ_ERROR');
1743: FND_MSG_PUB.ADD;
1744: RAISE FND_API.G_EXC_ERROR;
1745: end if;
1746:

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

2000: ,p_col_name => 'LOAN_ID'
2001: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2002:
2003: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2004: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2005: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2006: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2007: FND_MSG_PUB.ADD;
2008: RAISE FND_API.G_EXC_ERROR;

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

2001: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2002:
2003: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2004: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2005: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2006: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2007: FND_MSG_PUB.ADD;
2008: RAISE FND_API.G_EXC_ERROR;
2009: end if;

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

2002:
2003: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2004: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2005: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2006: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2007: FND_MSG_PUB.ADD;
2008: RAISE FND_API.G_EXC_ERROR;
2009: end if;
2010:

Line 2024: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR3');

2020: for k in 1..i loop
2021:
2022: -- first validation as per june : do not add fees far into the future
2023: if p_fees_tbl(k).fee_installment > l_loan_details.LAST_INSTALLMENT_BILLED + 1 then
2024: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR3');
2025: FND_MSG_PUB.ADD;
2026: RAISE FND_API.G_EXC_ERROR;
2027: end if;
2028:

Line 2031: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR1');

2027: end if;
2028:
2029:
2030: if p_fees_tbl(k).fee_installment < l_loan_details.LAST_INSTALLMENT_BILLED then
2031: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR1');
2032: FND_MSG_PUB.ADD;
2033: RAISE FND_API.G_EXC_ERROR;
2034: end if;
2035:

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

2033: RAISE FND_API.G_EXC_ERROR;
2034: end if;
2035:
2036: if p_fees_tbl(k).fee_installment > l_loan_details.NUMBER_INSTALLMENTS then
2037: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR2');
2038: FND_MSG_PUB.ADD;
2039: RAISE FND_API.G_EXC_ERROR;
2040: end if;
2041:

Line 2043: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_AMOUNT');

2039: RAISE FND_API.G_EXC_ERROR;
2040: end if;
2041:
2042: if p_fees_tbl(k).FEE_AMOUNT is null or p_fees_tbl(k).FEE_AMOUNT < 0 then
2043: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_AMOUNT');
2044: FND_MSG_PUB.ADD;
2045: RAISE FND_API.G_EXC_ERROR;
2046: end if;
2047:

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

2055: ,p_col_name => 'FEE_ID'
2056: ,p_table_name => 'LNS_FEES');
2057:
2058: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2059: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2060: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');
2061: FND_MESSAGE.SET_TOKEN('VALUE', p_fees_tbl(k).FEE_ID);
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;

Line 2060: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');

2056: ,p_table_name => 'LNS_FEES');
2057:
2058: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2059: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2060: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');
2061: FND_MESSAGE.SET_TOKEN('VALUE', p_fees_tbl(k).FEE_ID);
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;
2064: end if;

Line 2061: FND_MESSAGE.SET_TOKEN('VALUE', p_fees_tbl(k).FEE_ID);

2057:
2058: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2059: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2060: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');
2061: FND_MESSAGE.SET_TOKEN('VALUE', p_fees_tbl(k).FEE_ID);
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;
2064: end if;
2065:

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

2210: ,p_col_name => 'LOAN_ID'
2211: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2212:
2213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2216: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2217: FND_MSG_PUB.ADD;
2218: RAISE FND_API.G_EXC_ERROR;

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

2211: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2212:
2213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2216: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2217: FND_MSG_PUB.ADD;
2218: RAISE FND_API.G_EXC_ERROR;
2219: end if;

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

2212:
2213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2216: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2217: FND_MSG_PUB.ADD;
2218: RAISE FND_API.G_EXC_ERROR;
2219: end if;
2220:

Line 2236: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR3');

2232: -- bypass this validation temporarily until more time for disbursement fees
2233: if p_fees_tbl(k).disb_header_id is null then
2234: -- first validation as per june : do not add fees far into the future
2235: if p_fees_tbl(k).fee_installment > l_loan_details.LAST_INSTALLMENT_BILLED + 1 then
2236: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR3');
2237: FND_MSG_PUB.ADD;
2238: RAISE FND_API.G_EXC_ERROR;
2239: end if;
2240:

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

2238: RAISE FND_API.G_EXC_ERROR;
2239: end if;
2240:
2241: if p_fees_tbl(k).fee_installment < l_loan_details.LAST_INSTALLMENT_BILLED then
2242: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR1');
2243: FND_MSG_PUB.ADD;
2244: RAISE FND_API.G_EXC_ERROR;
2245: end if;
2246:

Line 2248: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR2');

2244: RAISE FND_API.G_EXC_ERROR;
2245: end if;
2246:
2247: if p_fees_tbl(k).fee_installment > l_loan_details.NUMBER_INSTALLMENTS then
2248: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_INSTALLMENT_ERROR2');
2249: FND_MSG_PUB.ADD;
2250: RAISE FND_API.G_EXC_ERROR;
2251: end if;
2252:

Line 2254: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_AMOUNT');

2250: RAISE FND_API.G_EXC_ERROR;
2251: end if;
2252:
2253: if p_fees_tbl(k).FEE_AMOUNT is null or p_fees_tbl(k).FEE_AMOUNT <= 0 then
2254: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_AMOUNT');
2255: FND_MSG_PUB.ADD;
2256: RAISE FND_API.G_EXC_ERROR;
2257: end if;
2258:

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

2266: ,p_col_name => 'FEE_ID'
2267: ,p_table_name => 'LNS_FEES');
2268:
2269: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2270: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2271: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');
2272: FND_MESSAGE.SET_TOKEN('VALUE', p_fees_tbl(k).FEE_ID);
2273: FND_MSG_PUB.ADD;
2274: RAISE FND_API.G_EXC_ERROR;

Line 2271: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');

2267: ,p_table_name => 'LNS_FEES');
2268:
2269: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2270: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2271: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');
2272: FND_MESSAGE.SET_TOKEN('VALUE', p_fees_tbl(k).FEE_ID);
2273: FND_MSG_PUB.ADD;
2274: RAISE FND_API.G_EXC_ERROR;
2275: end if;

Line 2272: FND_MESSAGE.SET_TOKEN('VALUE', p_fees_tbl(k).FEE_ID);

2268:
2269: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2270: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2271: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_ID');
2272: FND_MESSAGE.SET_TOKEN('VALUE', p_fees_tbl(k).FEE_ID);
2273: FND_MSG_PUB.ADD;
2274: RAISE FND_API.G_EXC_ERROR;
2275: end if;
2276:

Line 2465: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CAT_TYPE_MISSING');

2461: l_fee_category := p_fee_structures(i).fee_category;
2462: l_fee_type := p_fee_structures(i).fee_type;
2463:
2464: if p_fee_structures(i).fee_category is null AND p_fee_structures(i).fee_type is null then
2465: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CAT_TYPE_MISSING');
2466: FND_MSG_PUB.ADD;
2467: RAISE FND_API.G_EXC_ERROR;
2468: end if;
2469:

Line 2488: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CALCULATION_FAILURE');

2484: ,x_return_status => l_return_status
2485: ,x_msg_count => l_msg_count
2486: ,x_msg_data => l_msg_data);
2487: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2488: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CALCULATION_FAILURE');
2489: FND_MSG_PUB.ADD;
2490: RAISE FND_API.G_EXC_ERROR;
2491: end if;
2492:

Line 2502: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_WRITE_FAILURE');

2498: ,x_return_status => l_return_status
2499: ,x_msg_count => l_msg_count
2500: ,x_msg_data => l_msg_data);
2501: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2502: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_WRITE_FAILURE');
2503: FND_MSG_PUB.ADD;
2504: RAISE FND_API.G_EXC_ERROR;
2505: end if;
2506: end loop;

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

2629: ,p_col_name => 'LOAN_ID'
2630: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2631:
2632: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2633: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2634: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2635: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2636: FND_MSG_PUB.ADD;
2637: RAISE FND_API.G_EXC_ERROR;

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

2630: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
2631:
2632: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2633: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2634: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2635: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2636: FND_MSG_PUB.ADD;
2637: RAISE FND_API.G_EXC_ERROR;
2638: end if;

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

2631:
2632: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2633: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2634: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
2635: FND_MESSAGE.SET_TOKEN('VALUE', p_loan_ID);
2636: FND_MSG_PUB.ADD;
2637: RAISE FND_API.G_EXC_ERROR;
2638: end if;
2639:

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

2646: ,p_col_name => 'FEE_SCHEDULE_ID'
2647: ,p_table_name => 'LNS_FEE_SCHEDULES');
2648:
2649: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2650: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2651: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_SCHEDULE_ID');
2652: FND_MESSAGE.SET_TOKEN('VALUE', p_fee_schedule_ID);
2653: FND_MSG_PUB.ADD;
2654: RAISE FND_API.G_EXC_ERROR;

Line 2651: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_SCHEDULE_ID');

2647: ,p_table_name => 'LNS_FEE_SCHEDULES');
2648:
2649: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2650: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2651: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_SCHEDULE_ID');
2652: FND_MESSAGE.SET_TOKEN('VALUE', p_fee_schedule_ID);
2653: FND_MSG_PUB.ADD;
2654: RAISE FND_API.G_EXC_ERROR;
2655: end if;

Line 2652: FND_MESSAGE.SET_TOKEN('VALUE', p_fee_schedule_ID);

2648:
2649: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2650: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
2651: FND_MESSAGE.SET_TOKEN('PARAMETER', 'FEE_SCHEDULE_ID');
2652: FND_MESSAGE.SET_TOKEN('VALUE', p_fee_schedule_ID);
2653: FND_MSG_PUB.ADD;
2654: RAISE FND_API.G_EXC_ERROR;
2655: end if;
2656:

Line 2660: FND_MESSAGE.SET_NAME('LNS', 'LNS_WAIVE_AMOUNT_INVALID');

2656:
2657: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount to waive ' || p_waive_amount);
2658:
2659: if p_waive_amount is null then
2660: FND_MESSAGE.SET_NAME('LNS', 'LNS_WAIVE_AMOUNT_INVALID');
2661: FND_MSG_PUB.ADD;
2662: RAISE FND_API.G_EXC_ERROR;
2663: else
2664: open c_fee_waive_amount(p_fee_schedule_id);

Line 2670: FND_MESSAGE.SET_NAME('LNS', 'LNS_WAIVE_AMOUNT_INVALID');

2666: close c_fee_waive_amount;
2667:
2668: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - amount remain ' || l_fee_amount_remaining);
2669: if p_waive_amount > l_fee_amount_remaining or p_waive_amount < 0 then
2670: FND_MESSAGE.SET_NAME('LNS', 'LNS_WAIVE_AMOUNT_INVALID');
2671: FND_MSG_PUB.ADD;
2672: RAISE FND_API.G_EXC_ERROR;
2673: end if;
2674:

Line 2973: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CALCULATION_FAILURE');

2969: ,x_return_status => l_return_status
2970: ,x_msg_count => l_msg_count
2971: ,x_msg_data => l_msg_data);
2972: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2973: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_CALCULATION_FAILURE');
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: end if;
2977:

Line 2995: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_WRITE_FAILURE');

2991: ,x_return_status => l_return_status
2992: ,x_msg_count => l_msg_count
2993: ,x_msg_data => l_msg_data);
2994: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
2995: FND_MESSAGE.SET_NAME('LNS', 'LNS_FEE_WRITE_FAILURE');
2996: FND_MSG_PUB.ADD;
2997: RAISE FND_API.G_EXC_ERROR;
2998: end if;
2999: