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

Line 171: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_SYSTEM_OPTIONS');

167:
168: if g_sys_opt_num = 0 then
169:
170: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No system options found for the org ' || g_org_id);
171: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_SYSTEM_OPTIONS');
172: FND_MESSAGE.SET_TOKEN('ORG', g_org_id);
173: FND_MSG_PUB.Add;
174: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
175: RAISE FND_API.G_EXC_ERROR;

Line 172: FND_MESSAGE.SET_TOKEN('ORG', g_org_id);

168: if g_sys_opt_num = 0 then
169:
170: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No system options found for the org ' || g_org_id);
171: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_SYSTEM_OPTIONS');
172: FND_MESSAGE.SET_TOKEN('ORG', g_org_id);
173: FND_MSG_PUB.Add;
174: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
175: RAISE FND_API.G_EXC_ERROR;
176:

Line 180: FND_MESSAGE.SET_NAME('LNS', 'LNS_MANY_SYSTEM_OPTIONS');

176:
177: elsif g_sys_opt_num > 1 then
178:
179: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Found more then 1 system options records for the org ' || g_org_id);
180: FND_MESSAGE.SET_NAME('LNS', 'LNS_MANY_SYSTEM_OPTIONS');
181: FND_MESSAGE.SET_TOKEN('ORG', g_org_id);
182: FND_MSG_PUB.Add;
183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
184: RAISE FND_API.G_EXC_ERROR;

Line 181: FND_MESSAGE.SET_TOKEN('ORG', g_org_id);

177: elsif g_sys_opt_num > 1 then
178:
179: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Found more then 1 system options records for the org ' || g_org_id);
180: FND_MESSAGE.SET_NAME('LNS', 'LNS_MANY_SYSTEM_OPTIONS');
181: FND_MESSAGE.SET_TOKEN('ORG', g_org_id);
182: FND_MSG_PUB.Add;
183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
184: RAISE FND_API.G_EXC_ERROR;
185:

Line 230: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BATCH_IN_SYS_OPT');

226:
227: if g_batch_source_id is null then
228:
229: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Batch Source is not set in the system option.');
230: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BATCH_IN_SYS_OPT');
231: FND_MSG_PUB.Add;
232: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
233: RAISE FND_API.G_EXC_ERROR;
234:

Line 240: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_TYPE_IN_SYS_OPT');

236:
237: if g_trx_type_id is null then
238:
239: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Default Transaction Type is not set in the system option.');
240: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_TYPE_IN_SYS_OPT');
241: FND_MSG_PUB.Add;
242: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
243: RAISE FND_API.G_EXC_ERROR;
244:

Line 250: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INV_COMB_IN_SYS_OPT');

246:
247: if g_multiple_lines is null then
248:
249: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Combination Invoice is not set in the system option.');
250: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INV_COMB_IN_SYS_OPT');
251: FND_MSG_PUB.Add;
252: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
253: RAISE FND_API.G_EXC_ERROR;
254:

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

416:
417: IF l_return_status = 'S' THEN
418: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
419: ELSE
420: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
421: FND_MSG_PUB.Add;
422: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;

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

620:
621: IF l_return_status = 'S' THEN
622: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
623: ELSE
624: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
625: FND_MSG_PUB.Add;
626: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
627: RAISE FND_API.G_EXC_ERROR;
628: END IF;

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

793:
794: IF l_return_status = 'S' THEN
795: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_HEADERS_ALL');
796: ELSE
797: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
798: FND_MSG_PUB.Add;
799: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;

Line 1239: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_DISABLED');

1235: l_is_disable_bill := IS_BILLING_DISABLED(P_LOAN_REC.LOAN_ID);
1236: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_is_disable_bill is '||l_is_disable_bill);
1237: IF l_is_disable_bill = 'Y' THEN
1238: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: BILLING is Disabled for the loan '||p_loan_rec.loan_number);
1239: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_DISABLED');
1240: FND_MESSAGE.SET_TOKEN('LOAN_NUMBER', p_loan_rec.loan_number);
1241: FND_MSG_PUB.Add;
1242: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1243: RAISE FND_API.G_EXC_ERROR;

Line 1240: FND_MESSAGE.SET_TOKEN('LOAN_NUMBER', p_loan_rec.loan_number);

1236: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_is_disable_bill is '||l_is_disable_bill);
1237: IF l_is_disable_bill = 'Y' THEN
1238: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: BILLING is Disabled for the loan '||p_loan_rec.loan_number);
1239: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_DISABLED');
1240: FND_MESSAGE.SET_TOKEN('LOAN_NUMBER', p_loan_rec.loan_number);
1241: FND_MSG_PUB.Add;
1242: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;

Line 1519: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INT_TRX_TYPE_IN_SYS_OPT');

1515:
1516: if g_int_trx_type_id is null then
1517:
1518: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Interest transaction type is not set.');
1519: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INT_TRX_TYPE_IN_SYS_OPT');
1520: FND_MSG_PUB.Add;
1521: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1522: RAISE FND_API.G_EXC_ERROR;
1523:

Line 1588: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_FEE_TRX_TYPE_IN_SYS_OPT');

1584: /* set trx_type_id */
1585: if g_fee_trx_type_id is null then
1586:
1587: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Fee transaction type is not set.');
1588: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_FEE_TRX_TYPE_IN_SYS_OPT');
1589: FND_MSG_PUB.Add;
1590: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1591: RAISE FND_API.G_EXC_ERROR;
1592:

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

2003: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'WARNING: No data available to create invoices. Returning.');
2004: --return;
2005: /*
2006: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No data to create invoices.');
2007: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_DATA_CR_INV');
2008: FND_MSG_PUB.Add;
2009: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2010: RAISE FND_API.G_EXC_ERROR;
2011: */

Line 2137: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');

2133:
2134: l_ar_error_counter := l_ar_error_counter + 1;
2135:
2136: if l_ar_error_counter = 1 then
2137: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2138: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2139: FND_MSG_PUB.Add;
2140: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2141: end if;

Line 2138: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);

2134: l_ar_error_counter := l_ar_error_counter + 1;
2135:
2136: if l_ar_error_counter = 1 then
2137: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2138: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2139: FND_MSG_PUB.Add;
2140: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2141: end if;
2142:

Line 2143: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');

2139: FND_MSG_PUB.Add;
2140: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2141: end if;
2142:
2143: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2144: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2145: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2146: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2147: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);

Line 2144: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);

2140: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2141: end if;
2142:
2143: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2144: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2145: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2146: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2147: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2148: FND_MSG_PUB.Add;

Line 2145: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);

2141: end if;
2142:
2143: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2144: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2145: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2146: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2147: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2148: FND_MSG_PUB.Add;
2149: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 2146: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);

2142:
2143: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2144: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2145: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2146: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2147: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2148: FND_MSG_PUB.Add;
2149: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2150:

Line 2147: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);

2143: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2144: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2145: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2146: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2147: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2148: FND_MSG_PUB.Add;
2149: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2150:
2151: END LOOP;

Line 2175: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');

2171: l_ar_error_counter := 0;
2172: IF l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error OR l_batch_id is null THEN
2173:
2174: l_ar_error_counter := 1;
2175: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2176: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2177: FND_MSG_PUB.Add;
2178: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2179:

Line 2176: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);

2172: IF l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error OR l_batch_id is null THEN
2173:
2174: l_ar_error_counter := 1;
2175: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2176: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2177: FND_MSG_PUB.Add;
2178: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2179:
2180: END IF;

Line 2195: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');

2191: l_invalid_value;
2192: exit when ar_invoice_err_cur%NOTFOUND;
2193:
2194: l_ar_error_counter := l_ar_error_counter + 1;
2195: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2196: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2197: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2198: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2199: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);

Line 2196: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);

2192: exit when ar_invoice_err_cur%NOTFOUND;
2193:
2194: l_ar_error_counter := l_ar_error_counter + 1;
2195: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2196: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2197: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2198: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2199: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2200: FND_MSG_PUB.Add;

Line 2197: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);

2193:
2194: l_ar_error_counter := l_ar_error_counter + 1;
2195: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2196: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2197: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2198: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2199: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2200: FND_MSG_PUB.Add;
2201: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 2198: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);

2194: l_ar_error_counter := l_ar_error_counter + 1;
2195: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2196: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2197: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2198: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2199: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2200: FND_MSG_PUB.Add;
2201: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2202:

Line 2199: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);

2195: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2196: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2197: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2198: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2199: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2200: FND_MSG_PUB.Add;
2201: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2202:
2203: END LOOP;

Line 2350: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INV_FETCHED');

2346: close ar_invoices_cur;
2347:
2348: if l_Count2 = 0 then
2349: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No AR invoices fetched');
2350: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INV_FETCHED');
2351: FND_MSG_PUB.Add;
2352: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2353: RAISE FND_API.G_EXC_ERROR;
2354: end if;

Line 2365: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');

2361: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_interest_trx_id;
2362:
2363: if (sql%notfound) then
2364: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2365: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');
2366: FND_MSG_PUB.Add;
2367: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2368: RAISE FND_API.G_EXC_ERROR;
2369: end if;

Line 2379: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');

2375: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_fee_trx_id;
2376:
2377: if (sql%notfound) then
2378: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2379: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');
2380: FND_MSG_PUB.Add;
2381: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2382: RAISE FND_API.G_EXC_ERROR;
2383: end if;

Line 2504: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_REV_BILL');

2500:
2501: if P_REVERSE_TBL(l_Count).APPLIED_AMOUNT <> 0 then
2502:
2503: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot reverse because there are some valid activities on trx.');
2504: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_REV_BILL');
2505: FND_MSG_PUB.Add;
2506: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2507: RAISE FND_API.G_EXC_ERROR;
2508:

Line 2540: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_REVERSE');

2536:
2537: if P_REVERSE_TBL.count = 0 or l_trx_tbl.count = 0 then
2538:
2539: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No AR transactions found to reverse.');
2540: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_REVERSE');
2541: FND_MSG_PUB.Add;
2542: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2543: RAISE FND_API.G_EXC_ERROR;
2544:

Line 2554: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CM_BATCH');

2550: close batch_source_cur;
2551:
2552: if l_cm_batch_source_id is null then
2553:
2554: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CM_BATCH');
2555: FND_MESSAGE.SET_TOKEN('BATCH', l_batch_source_name);
2556: FND_MSG_PUB.Add;
2557: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2558: RAISE FND_API.G_EXC_ERROR;

Line 2555: FND_MESSAGE.SET_TOKEN('BATCH', l_batch_source_name);

2551:
2552: if l_cm_batch_source_id is null then
2553:
2554: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CM_BATCH');
2555: FND_MESSAGE.SET_TOKEN('BATCH', l_batch_source_name);
2556: FND_MSG_PUB.Add;
2557: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2558: RAISE FND_API.G_EXC_ERROR;
2559:

Line 2651: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_CM_FAIL');

2647:
2648: THEN
2649:
2650: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST raised unexpected error: ' || substr(l_msg_data,1,225));
2651: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_CM_FAIL');
2652: FND_MESSAGE.SET_TOKEN('BATCH', l_cm_batch_source_name);
2653: FND_MSG_PUB.Add;
2654: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2655: RAISE FND_API.G_EXC_ERROR;

Line 2652: FND_MESSAGE.SET_TOKEN('BATCH', l_cm_batch_source_name);

2648: THEN
2649:
2650: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST raised unexpected error: ' || substr(l_msg_data,1,225));
2651: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_CM_FAIL');
2652: FND_MESSAGE.SET_TOKEN('BATCH', l_cm_batch_source_name);
2653: FND_MSG_PUB.Add;
2654: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2655: RAISE FND_API.G_EXC_ERROR;
2656:

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

2743: /* verify input data */
2744:
2745: if P_CASH_RECEIPT_ID is null then
2746: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cash Receipt ID is not set.');
2747: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');
2748: FND_MSG_PUB.Add;
2749: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2750: RAISE FND_API.G_EXC_ERROR;
2751: end if;

Line 2755: FND_MESSAGE.SET_NAME('LNS', 'LNS_TRX_NOT_SET');

2751: end if;
2752:
2753: if P_TRX_ID is null then
2754: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Trx ID is not set.');
2755: FND_MESSAGE.SET_NAME('LNS', 'LNS_TRX_NOT_SET');
2756: FND_MSG_PUB.Add;
2757: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2758: RAISE FND_API.G_EXC_ERROR;
2759: end if;

Line 2763: FND_MESSAGE.SET_NAME('LNS', 'LNS_TRX_LINE_NOT_SET');

2759: end if;
2760:
2761: if P_TRX_LINE_ID is null then
2762: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Trx Line ID is not set.');
2763: FND_MESSAGE.SET_NAME('LNS', 'LNS_TRX_LINE_NOT_SET');
2764: FND_MSG_PUB.Add;
2765: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2766: RAISE FND_API.G_EXC_ERROR;
2767: end if;

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

2767: end if;
2768:
2769: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then
2770: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Apply Amount is not set.');
2771: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');
2772: FND_MSG_PUB.Add;
2773: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2774: RAISE FND_API.G_EXC_ERROR;
2775: end if;

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

2780: fetch receipt_cur into l_receipt_rem_amount;
2781:
2782: if receipt_cur%NOTFOUND then
2783: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No receipt found to apply.');
2784: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');
2785: FND_MSG_PUB.Add;
2786: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2787: RAISE FND_API.G_EXC_ERROR;
2788: end if;

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

2790: close receipt_cur;
2791:
2792: if l_receipt_rem_amount < P_APPLY_AMOUNT then
2793: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: The receipt does not have enough funds to apply requested amount.');
2794: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');
2795: FND_MSG_PUB.Add;
2796: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2797: RAISE FND_API.G_EXC_ERROR;
2798: end if;

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

2816:
2817: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2818:
2819: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: AR_RECEIPT_API_PUB.APPLY raised error: ' || substr(l_msg_data,1,225));
2820: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
2821: FND_MSG_PUB.Add;
2822: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2823: RAISE FND_API.G_EXC_ERROR;
2824:

Line 2989: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_ADJ_FAIL');

2985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS or
2986: l_adj_id is null or
2987: l_adj_num is null
2988: THEN
2989: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_ADJ_FAIL');
2990: if l_return_status = FND_API.G_RET_STS_SUCCESS and l_adj_id is null then
2991: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_id is null');
2992: elsif l_return_status = FND_API.G_RET_STS_SUCCESS and l_adj_num is null then
2993: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_number is null');

Line 2991: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_id is null');

2987: l_adj_num is null
2988: THEN
2989: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_ADJ_FAIL');
2990: if l_return_status = FND_API.G_RET_STS_SUCCESS and l_adj_id is null then
2991: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_id is null');
2992: elsif l_return_status = FND_API.G_RET_STS_SUCCESS and l_adj_num is null then
2993: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_number is null');
2994: else
2995: FND_MESSAGE.SET_TOKEN('REASON', 'unknown');

Line 2993: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_number is null');

2989: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_ADJ_FAIL');
2990: if l_return_status = FND_API.G_RET_STS_SUCCESS and l_adj_id is null then
2991: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_id is null');
2992: elsif l_return_status = FND_API.G_RET_STS_SUCCESS and l_adj_num is null then
2993: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_number is null');
2994: else
2995: FND_MESSAGE.SET_TOKEN('REASON', 'unknown');
2996: end if;
2997: FND_MSG_PUB.Add;

Line 2995: FND_MESSAGE.SET_TOKEN('REASON', 'unknown');

2991: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_id is null');
2992: elsif l_return_status = FND_API.G_RET_STS_SUCCESS and l_adj_num is null then
2993: FND_MESSAGE.SET_TOKEN('REASON', 'new_adjust_number is null');
2994: else
2995: FND_MESSAGE.SET_TOKEN('REASON', 'unknown');
2996: end if;
2997: FND_MSG_PUB.Add;
2998: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2999:

Line 3707: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILL_STMT_GEN_FAIL');

3703:
3704: EXCEPTION
3705: WHEN OTHERS THEN
3706: -- Bug#8848035 - Thow the user defined exception if it fails
3707: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILL_STMT_GEN_FAIL');
3708: FND_MSG_PUB.Add;
3709: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3710: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to generate billing statement');
3711: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: ' || sqlerrm);

Line 3782: -- FND_MESSAGE.SET_ENCODED('Principal bill amount cannot be greater than ' || l_valid_amount);

3778:
3779: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_PRIN_AMOUNT = ' || P_PRIN_AMOUNT) ;
3780:
3781: if P_PRIN_AMOUNT > l_available_amount then
3782: -- FND_MESSAGE.SET_ENCODED('Principal bill amount cannot be greater than ' || l_valid_amount);
3783: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PRIN_BILL_AMOUNT');
3784: FND_MSG_PUB.Add;
3785: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3786: RAISE FND_API.G_EXC_ERROR;

Line 3783: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PRIN_BILL_AMOUNT');

3779: LogMessage(FND_LOG.LEVEL_STATEMENT, 'P_PRIN_AMOUNT = ' || P_PRIN_AMOUNT) ;
3780:
3781: if P_PRIN_AMOUNT > l_available_amount then
3782: -- FND_MESSAGE.SET_ENCODED('Principal bill amount cannot be greater than ' || l_valid_amount);
3783: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PRIN_BILL_AMOUNT');
3784: FND_MSG_PUB.Add;
3785: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3786: RAISE FND_API.G_EXC_ERROR;
3787: end if;

Line 3963: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_MISS_DATA');

3959: P_LOAN_REC.NEXT_PAYMENT_DUE_DATE is null or
3960: P_LOAN_REC.LOAN_PAYMENT_FREQUENCY is null then
3961:
3962: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan misses some important data. Cannot proceed with billing of this loan.');
3963: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_MISS_DATA');
3964: FND_MESSAGE.SET_TOKEN('LOAN', P_LOAN_REC.LOAN_NUMBER);
3965: FND_MSG_PUB.Add;
3966: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3967: RAISE FND_API.G_EXC_ERROR;

Line 3964: FND_MESSAGE.SET_TOKEN('LOAN', P_LOAN_REC.LOAN_NUMBER);

3960: P_LOAN_REC.LOAN_PAYMENT_FREQUENCY is null then
3961:
3962: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan misses some important data. Cannot proceed with billing of this loan.');
3963: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_MISS_DATA');
3964: FND_MESSAGE.SET_TOKEN('LOAN', P_LOAN_REC.LOAN_NUMBER);
3965: FND_MSG_PUB.Add;
3966: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3967: RAISE FND_API.G_EXC_ERROR;
3968:

Line 4101: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_DISABLED');

4097: l_is_disable_bill := IS_BILLING_DISABLED(P_LOAN_REC.LOAN_ID);
4098: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_is_disable_bill is '||l_is_disable_bill);
4099: IF l_is_disable_bill = 'Y' THEN
4100: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: BILLING is Disabled for the loan '||p_loan_rec.loan_number);
4101: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_DISABLED');
4102: FND_MESSAGE.SET_TOKEN('LOAN_NUMBER', p_loan_rec.loan_number);
4103: FND_MSG_PUB.Add;
4104: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
4105: RAISE FND_API.G_EXC_ERROR;

Line 4102: FND_MESSAGE.SET_TOKEN('LOAN_NUMBER', p_loan_rec.loan_number);

4098: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_is_disable_bill is '||l_is_disable_bill);
4099: IF l_is_disable_bill = 'Y' THEN
4100: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: BILLING is Disabled for the loan '||p_loan_rec.loan_number);
4101: FND_MESSAGE.SET_NAME('LNS', 'LNS_BILLING_DISABLED');
4102: FND_MESSAGE.SET_TOKEN('LOAN_NUMBER', p_loan_rec.loan_number);
4103: FND_MSG_PUB.Add;
4104: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
4105: RAISE FND_API.G_EXC_ERROR;
4106: END IF;

Line 4136: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_BILL_ZERO_AMOUNT');

4132: select USER_PROFILE_OPTION_NAME into l_profile_name
4133: from FND_PROFILE_OPTIONS_VL
4134: where PROFILE_OPTION_NAME = 'LNS_CREATE_ZERO_INSTAL';
4135:
4136: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_BILL_ZERO_AMOUNT');
4137: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
4138: FND_MSG_PUB.Add;
4139: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
4140: RAISE FND_API.G_EXC_ERROR;

Line 4137: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);

4133: from FND_PROFILE_OPTIONS_VL
4134: where PROFILE_OPTION_NAME = 'LNS_CREATE_ZERO_INSTAL';
4135:
4136: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_BILL_ZERO_AMOUNT');
4137: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
4138: FND_MSG_PUB.Add;
4139: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
4140: RAISE FND_API.G_EXC_ERROR;
4141: -- return;

Line 4243: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_INSTAL');

4239:
4240: /* added fee installment validation by raverma request */
4241: if l_amortization_rec.INSTALLMENT_NUMBER <> l_fee_tbl(l_Count).FEE_INSTALLMENT then
4242:
4243: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_INSTAL');
4244: FND_MSG_PUB.Add;
4245: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4246: RAISE FND_API.G_EXC_ERROR;
4247:

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

4306: IF l_return_status = 'S' THEN
4307: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4308: ELSE
4309: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4310: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4311: FND_MSG_PUB.Add;
4312: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4313: RAISE FND_API.G_EXC_ERROR;
4314: END IF;

Line 4572: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INST_DUE_DATE');

4568:
4569: if l_next_payment_due_date is null then
4570:
4571: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Next installment date is unknown.');
4572: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INST_DUE_DATE');
4573: FND_MSG_PUB.Add;
4574: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4575: -- RAISE FND_API.G_EXC_ERROR;
4576:

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

4595: IF l_return_status = 'S' THEN
4596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4597: ELSE
4598: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4599: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4600: FND_MSG_PUB.Add;
4601: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4602: RAISE FND_API.G_EXC_ERROR;
4603: END IF;

Line 4637: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');

4633: IF l_return_status = 'S' THEN
4634: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
4635: ELSE
4636: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
4637: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
4638: FND_MSG_PUB.Add;
4639: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4640: RAISE FND_API.G_EXC_ERROR;
4641: END IF;

Line 5123: FND_MESSAGE.SET_NAME('LNS', 'LNS_FORGIVENESS_FAIL');

5119: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully performed forgiveness adjustment.');
5120: ELSE
5121: -- g_cr_return_status := 'WARNING';
5122: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to perform forgiveness adjustment for loan ' || l_loans_to_bill_tbl(l_Count1).LOAN_NUMBER);
5123: FND_MESSAGE.SET_NAME('LNS', 'LNS_FORGIVENESS_FAIL');
5124: FND_MSG_PUB.Add;
5125: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5126: RAISE FND_API.G_EXC_ERROR;
5127: END IF;

Line 5421: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BILLING_INP_PAR');

5417: elsif P_TYPE_ID is null and P_PRODUCT_ID is null and P_BORROWER_ID is null and P_FROM_DAYS_TO_DD is null and P_TO_DAYS_TO_DD is null then
5418:
5419: if g_days_to_bill_before_dd is null then
5420: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: At least one of the days must be set.');
5421: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BILLING_INP_PAR');
5422: FND_MSG_PUB.Add;
5423: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5424: RAISE FND_API.G_EXC_ERROR;
5425: else

Line 6029: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

6025: /* verify input parameters */
6026: if P_LOAN_ID is null then
6027:
6028: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
6029: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
6030: FND_MSG_PUB.Add;
6031: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6032: RAISE FND_API.G_EXC_ERROR;
6033:

Line 6111: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');

6107: if l_reverse_tbl.count = 0 then
6108:
6109: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No trx lines found to reverse - will not create AR CM.');
6110: /*
6111: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');
6112: FND_MSG_PUB.Add;
6113: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6114: RAISE FND_API.G_EXC_ERROR;
6115: */

Line 6193: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALC_NEXT_DUE_FAIL');

6189: IF l_return_status = 'S' THEN
6190: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully calculated next payment due date.');
6191: ELSE
6192: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to calculate next payment due date.');
6193: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALC_NEXT_DUE_FAIL');
6194: FND_MSG_PUB.Add;
6195: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6196: RAISE FND_API.G_EXC_ERROR;
6197: END IF;

Line 6447: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

6443: /* verify input parameters */
6444: if P_LOAN_ID is null then
6445:
6446: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
6447: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
6448: FND_MSG_PUB.Add;
6449: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6450: RAISE FND_API.G_EXC_ERROR;
6451:

Line 6455: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LINE_TYPE');

6451:
6452: end if;
6453:
6454: if P_LINE_TYPE is null then
6455: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LINE_TYPE');
6456: FND_MSG_PUB.Add;
6457: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6458: RAISE FND_API.G_EXC_ERROR;
6459: end if;

Line 6524: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');

6520:
6521: /* Verify count */
6522: if l_reverse_tbl.count = 0 then
6523:
6524: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');
6525: FND_MSG_PUB.Add;
6526: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6527: RAISE FND_API.G_EXC_ERROR;
6528:

Line 6723: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LOAN');

6719: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || P_BILL_HEADER_REC.DUE_DATE);
6720:
6721: if P_BILL_HEADER_REC.LOAN_ID is null then
6722: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan ID is not set.');
6723: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LOAN');
6724: FND_MSG_PUB.Add;
6725: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6726: RAISE FND_API.G_EXC_ERROR;
6727: end if;

Line 6731: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_NUM');

6727: end if;
6728:
6729: if P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM is null then
6730: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Associated Payment Number is not set.');
6731: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_NUM');
6732: FND_MSG_PUB.Add;
6733: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6734: RAISE FND_API.G_EXC_ERROR;
6735: end if;

Line 6739: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_DUE');

6735: end if;
6736:
6737: if P_BILL_HEADER_REC.DUE_DATE is null then
6738: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Bill Due Date is not set.');
6739: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_DUE');
6740: FND_MSG_PUB.Add;
6741: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6742: RAISE FND_API.G_EXC_ERROR;
6743: end if;

Line 6747: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINES');

6743: end if;
6744:
6745: if l_lines_tbl.count = 0 then
6746: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No lines found for header ' || P_BILL_HEADER_REC.HEADER_ID);
6747: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINES');
6748: FND_MESSAGE.SET_TOKEN('HEADER', P_BILL_HEADER_REC.HEADER_ID);
6749: FND_MSG_PUB.Add;
6750: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6751: RAISE FND_API.G_EXC_ERROR;

Line 6748: FND_MESSAGE.SET_TOKEN('HEADER', P_BILL_HEADER_REC.HEADER_ID);

6744:
6745: if l_lines_tbl.count = 0 then
6746: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No lines found for header ' || P_BILL_HEADER_REC.HEADER_ID);
6747: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINES');
6748: FND_MESSAGE.SET_TOKEN('HEADER', P_BILL_HEADER_REC.HEADER_ID);
6749: FND_MSG_PUB.Add;
6750: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6751: RAISE FND_API.G_EXC_ERROR;
6752: end if;

Line 6777: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_AMOUNT');

6773:
6774: /* Verifying lines data */
6775: if l_lines_tbl(l_Count).LINE_AMOUNT is null or l_lines_tbl(l_Count).LINE_AMOUNT = 0 then
6776: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Amount for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6777: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_AMOUNT');
6778: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6779: FND_MSG_PUB.Add;
6780: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6781: RAISE FND_API.G_EXC_ERROR;

Line 6778: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);

6774: /* Verifying lines data */
6775: if l_lines_tbl(l_Count).LINE_AMOUNT is null or l_lines_tbl(l_Count).LINE_AMOUNT = 0 then
6776: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Amount for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6777: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_AMOUNT');
6778: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6779: FND_MSG_PUB.Add;
6780: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6781: RAISE FND_API.G_EXC_ERROR;
6782: end if;

Line 6786: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_TYPE');

6782: end if;
6783:
6784: if l_lines_tbl(l_Count).LINE_TYPE is null then
6785: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Line type for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6786: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_TYPE');
6787: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6788: FND_MSG_PUB.Add;
6789: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6790: RAISE FND_API.G_EXC_ERROR;

Line 6787: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);

6783:
6784: if l_lines_tbl(l_Count).LINE_TYPE is null then
6785: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Line type for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6786: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_TYPE');
6787: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6788: FND_MSG_PUB.Add;
6789: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6790: RAISE FND_API.G_EXC_ERROR;
6791: end if;

Line 6840: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_INSTALLMENT');

6836: l_funded_amount;
6837:
6838: if loan_cur%NOTFOUND then
6839: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No amortization record found.');
6840: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_INSTALLMENT');
6841: FND_MESSAGE.SET_TOKEN('LOAN',P_BILL_HEADER_REC.LOAN_ID);
6842: FND_MESSAGE.SET_TOKEN('INST', P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM);
6843: FND_MSG_PUB.Add;
6844: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 6841: FND_MESSAGE.SET_TOKEN('LOAN',P_BILL_HEADER_REC.LOAN_ID);

6837:
6838: if loan_cur%NOTFOUND then
6839: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No amortization record found.');
6840: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_INSTALLMENT');
6841: FND_MESSAGE.SET_TOKEN('LOAN',P_BILL_HEADER_REC.LOAN_ID);
6842: FND_MESSAGE.SET_TOKEN('INST', P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM);
6843: FND_MSG_PUB.Add;
6844: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6845: RAISE FND_API.G_EXC_ERROR;

Line 6842: FND_MESSAGE.SET_TOKEN('INST', P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM);

6838: if loan_cur%NOTFOUND then
6839: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No amortization record found.');
6840: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_INSTALLMENT');
6841: FND_MESSAGE.SET_TOKEN('LOAN',P_BILL_HEADER_REC.LOAN_ID);
6842: FND_MESSAGE.SET_TOKEN('INST', P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM);
6843: FND_MSG_PUB.Add;
6844: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6845: RAISE FND_API.G_EXC_ERROR;
6846: end if;

Line 6928: FND_MESSAGE.SET_NAME('LNS', 'LNS_FORGIVENESS_FAIL');

6924: IF l_return_status = 'S' THEN
6925: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully performed forgiveness adjustment.');
6926: ELSE
6927: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to perform forgiveness adjustment');
6928: FND_MESSAGE.SET_NAME('LNS', 'LNS_FORGIVENESS_FAIL');
6929: FND_MSG_PUB.Add;
6930: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6931: RAISE FND_API.G_EXC_ERROR;
6932: END IF;

Line 7086: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_HEADER');

7082: FOR l_Count IN 1..P_BILL_HEADERS_TBL.count LOOP
7083:
7084: if P_BILL_HEADERS_TBL(l_Count).HEADER_ID is null then
7085: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Header ID is not set.');
7086: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_HEADER');
7087: FND_MSG_PUB.Add;
7088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7089: RAISE FND_API.G_EXC_ERROR;
7090: end if;

Line 7101: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_HEADER');

7097: FOR l_Count1 IN 1..P_BILL_LINES_TBL.count LOOP
7098:
7099: if P_BILL_LINES_TBL(l_Count1).HEADER_ID is null then
7100: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Header ID for line ' || P_BILL_LINES_TBL(l_Count1).LINE_ID || ' is not set.');
7101: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_HEADER');
7102: FND_MESSAGE.SET_TOKEN('LINE', P_BILL_LINES_TBL(l_Count1).LINE_ID);
7103: FND_MSG_PUB.Add;
7104: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
7105: RAISE FND_API.G_EXC_ERROR;

Line 7102: FND_MESSAGE.SET_TOKEN('LINE', P_BILL_LINES_TBL(l_Count1).LINE_ID);

7098:
7099: if P_BILL_LINES_TBL(l_Count1).HEADER_ID is null then
7100: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Header ID for line ' || P_BILL_LINES_TBL(l_Count1).LINE_ID || ' is not set.');
7101: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_HEADER');
7102: FND_MESSAGE.SET_TOKEN('LINE', P_BILL_LINES_TBL(l_Count1).LINE_ID);
7103: FND_MSG_PUB.Add;
7104: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
7105: RAISE FND_API.G_EXC_ERROR;
7106: end if;

Line 7315: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_AMORT');

7311:
7312: /* verify input parameters */
7313: if P_AMORTIZATION_ID is null then
7314: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Amortization ID must be set.');
7315: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_AMORT');
7316: FND_MSG_PUB.Add;
7317: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7318: RAISE FND_API.G_EXC_ERROR;
7319: end if;

Line 7335: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_BILL_FOUND');

7331:
7332: if amort_cur%NOTFOUND then
7333:
7334: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: No amortization record found.');
7335: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_BILL_FOUND');
7336: FND_MSG_PUB.Add;
7337: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
7338: RAISE FND_API.G_EXC_ERROR;
7339:

Line 7351: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NOT_MAN_BILL');

7347:
7348: if l_PARENT_AMORTIZATION_ID is null then
7349:
7350: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: The amortization is not offcycle bill.');
7351: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NOT_MAN_BILL');
7352: FND_MSG_PUB.Add;
7353: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
7354: RAISE FND_API.G_EXC_ERROR;
7355:

Line 7359: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_ALREADY_REV');

7355:
7356: elsif l_REVERSED_FLAG = 'Y' then
7357:
7358: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: The amortization is already reversed.');
7359: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_ALREADY_REV');
7360: FND_MSG_PUB.Add;
7361: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
7362: RAISE FND_API.G_EXC_ERROR;
7363:

Line 7406: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');

7402: /* Check for table count */
7403: if l_reverse_tbl.count = 0 then
7404:
7405: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No trx lines found to reverse.');
7406: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');
7407: FND_MSG_PUB.Add;
7408: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
7409: RAISE FND_API.G_EXC_ERROR;
7410:

Line 7637: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

7633: /* verify input parameters */
7634: if P_LOAN_ID is null then
7635:
7636: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
7637: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
7638: FND_MSG_PUB.Add;
7639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7640: RAISE FND_API.G_EXC_ERROR;
7641:

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

7643:
7644: /* checking for system options values required for adjustment */
7645: if g_receivables_trx_id is null then
7646: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
7647: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
7648: FND_MSG_PUB.Add;
7649: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7650: RAISE FND_API.G_EXC_ERROR;
7651:

Line 7663: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_CODE_IN_SYS_OPT');

7659: if l_ussgl_flag = 'Y' then
7660:
7661: if g_USSGL_TRANSACTION_CODE is null then
7662: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: USSGL Transaction Code is not set in the system option.');
7663: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_CODE_IN_SYS_OPT');
7664: FND_MSG_PUB.Add;
7665: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7666: RAISE FND_API.G_EXC_ERROR;
7667:

Line 7710: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ADJ_AMT');

7706: if l_requested_amount > l_amount_due_remaining then
7707: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Adjust amount cannot be greater than receivable remaining amount.');
7708: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Adjustment amount: -' || l_requested_amount);
7709: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Receivable remaining amount: ' || l_amount_due_remaining);
7710: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ADJ_AMT');
7711: FND_MSG_PUB.Add;
7712: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7713: RAISE FND_API.G_EXC_ERROR;
7714: else

Line 7724: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');

7720:
7721: /* checking if adjustment for this loan already was made */
7722: if l_adj_number is not null or l_adj_id is not null then
7723: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Attempt to duplicate adjustment. Receivable has been already adjusted for this loan by adjustment xxx' );
7724: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');
7725: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);
7726: FND_MSG_PUB.Add;
7727: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7728: RAISE FND_API.G_EXC_ERROR;

Line 7725: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);

7721: /* checking if adjustment for this loan already was made */
7722: if l_adj_number is not null or l_adj_id is not null then
7723: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Attempt to duplicate adjustment. Receivable has been already adjusted for this loan by adjustment xxx' );
7724: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');
7725: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);
7726: FND_MSG_PUB.Add;
7727: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7728: RAISE FND_API.G_EXC_ERROR;
7729: end if;

Line 7800: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_FIND_ORIG_REC');

7796: close orig_rec_cur;
7797:
7798: if l_Count = 0 then
7799: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot find receivable to adjust.');
7800: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_FIND_ORIG_REC');
7801: FND_MSG_PUB.Add;
7802: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7803: RAISE FND_API.G_EXC_ERROR;
7804: end if;

Line 7957: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

7953: /* verify input parameters */
7954: if P_LOAN_ID is null then
7955:
7956: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
7957: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
7958: FND_MSG_PUB.Add;
7959: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7960: RAISE FND_API.G_EXC_ERROR;
7961:

Line 8089: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_INSTAL');

8085:
8086: /* added fee installment validation by raverma request */
8087: if l_amortization_rec.INSTALLMENT_NUMBER <> l_fee_tbl(l_Count).FEE_INSTALLMENT then
8088:
8089: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_INSTAL');
8090: FND_MSG_PUB.Add;
8091: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8092: RAISE FND_API.G_EXC_ERROR;
8093:

Line 8246: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

8242: /* verify input parameters */
8243: if P_LOAN_ID is null then
8244:
8245: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
8246: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
8247: FND_MSG_PUB.Add;
8248: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8249: RAISE FND_API.G_EXC_ERROR;
8250:

Line 8445: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

8441: /* verify input parameters */
8442: if P_LOAN_ID is null then
8443:
8444: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
8445: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
8446: FND_MSG_PUB.Add;
8447: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8448: RAISE FND_API.G_EXC_ERROR;
8449:

Line 8728: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

8724: /* verify input parameters */
8725: if P_LOAN_ID is null then
8726:
8727: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
8728: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
8729: FND_MSG_PUB.Add;
8730: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8731: RAISE FND_API.G_EXC_ERROR;
8732:

Line 8737: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_READY_BILL_NEXT_INSTAL');

8733: end if;
8734:
8735: if CAN_BILL_NEXT_INSTAL(P_LOAN_ID) = false then
8736: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan is not ready to bill next installment. Returning.');
8737: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_READY_BILL_NEXT_INSTAL');
8738: FND_MSG_PUB.Add;
8739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8740: RAISE FND_API.G_EXC_ERROR;
8741: end if;

Line 8804: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BILLING_DATA');

8800: l_amortization_rec.due_date is null
8801: then
8802:
8803: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_financials.getInstallment returns no data. Nothing to bill. Returning.');
8804: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BILLING_DATA');
8805: FND_MSG_PUB.Add;
8806: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8807: RAISE FND_API.G_EXC_ERROR;
8808:

Line 8829: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_BILL_ZERO_AMOUNT');

8825: from FND_PROFILE_OPTIONS_VL
8826: where PROFILE_OPTION_NAME = 'LNS_CREATE_ZERO_INSTAL';
8827:
8828: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Billing of zero amount installments is disallowed by profile LNS: Create Zero Amount Installments.');
8829: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_BILL_ZERO_AMOUNT');
8830: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
8831: FND_MSG_PUB.Add;
8832: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8833: RAISE FND_API.G_EXC_ERROR;

Line 8830: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);

8826: where PROFILE_OPTION_NAME = 'LNS_CREATE_ZERO_INSTAL';
8827:
8828: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Billing of zero amount installments is disallowed by profile LNS: Create Zero Amount Installments.');
8829: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_BILL_ZERO_AMOUNT');
8830: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);
8831: FND_MSG_PUB.Add;
8832: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
8833: RAISE FND_API.G_EXC_ERROR;
8834: -- return;

Line 9118: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_READY_BILL_NEXT_INSTAL');

9114: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input loan_id = ' || P_LOAN_ID);
9115:
9116: if CAN_BILL_NEXT_INSTAL(P_LOAN_ID) = false then
9117: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Loan is not ready to bill next installment. Returning.');
9118: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_READY_BILL_NEXT_INSTAL');
9119: FND_MSG_PUB.Add;
9120: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
9121: RAISE FND_API.G_EXC_ERROR;
9122: end if;

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

9674:
9675: l_application := l_application + 1;
9676:
9677: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9678: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
9679: FND_MSG_PUB.Add;
9680: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
9681: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Reported error: ' || l_error);
9682: RAISE FND_API.G_EXC_ERROR;

Line 9855: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

9851: /* verify input parameters */
9852: if P_LOAN_ID is null then
9853:
9854: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
9855: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
9856: FND_MSG_PUB.Add;
9857: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
9858: RAISE FND_API.G_EXC_ERROR;
9859:

Line 9902: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALC_NEXT_DUE_FAIL');

9898: IF l_return_status = 'S' THEN
9899: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully calculated next payment due date.');
9900: ELSE
9901: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to calculate next payment due date.');
9902: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALC_NEXT_DUE_FAIL');
9903: FND_MSG_PUB.Add;
9904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
9905: RAISE FND_API.G_EXC_ERROR;
9906: END IF;

Line 10059: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

10055: /* verify input parameters */
10056: if P_LOAN_ID is null or P_AM_SCHED_ID is null then
10057:
10058: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
10059: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
10060: FND_MSG_PUB.Add;
10061: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
10062: RAISE FND_API.G_EXC_ERROR;
10063:

Line 10247: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

10243: /* verify input parameters */
10244: if P_LOAN_ID is null or P_BILL_HEADERS_TBL.count = 0 then
10245:
10246: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
10247: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
10248: FND_MSG_PUB.Add;
10249: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
10250: RAISE FND_API.G_EXC_ERROR;
10251:

Line 10474: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

10470: X_BILLED_YN := 'N';
10471:
10472: /* verify input parameters */
10473: if P_LOAN_ID is null then
10474: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
10475: FND_MSG_PUB.Add;
10476: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
10477: RAISE FND_API.G_EXC_ERROR;
10478: end if;

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

10548:
10549: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
10550: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_data: ' || substr(l_msg_data,1,225));
10551: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
10552: FND_MESSAGE.SET_NAME('LNS', 'LNS_PROCESS_FEE_ERROR');
10553: FND_MSG_PUB.ADD;
10554: RAISE FND_API.G_EXC_ERROR;
10555: end if;
10556:

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

10568:
10569: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
10570: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_data: ' || substr(l_msg_data,1,225));
10571: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
10572: FND_MESSAGE.SET_NAME('LNS', 'LNS_READ_FEE_ERROR');
10573: FND_MSG_PUB.ADD;
10574: RAISE FND_API.G_EXC_ERROR;
10575: end if;
10576:

Line 10713: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_AMORT');

10709: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
10710:
10711: /* verify input parameters */
10712: if P_AMORTIZATION_ID is null then
10713: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_AMORT');
10714: FND_MSG_PUB.Add;
10715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
10716: RAISE FND_API.G_EXC_ERROR;
10717: end if;

Line 10813: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');

10809:
10810: /* verify input parameters */
10811: if P_LOAN_ID is null then
10812:
10813: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
10814: FND_MSG_PUB.Add;
10815: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
10816: RAISE FND_API.G_EXC_ERROR;
10817:

Line 10982: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );

10978:
10979: /* verify input parameters */
10980: if P_LOAN_LINE_ID is null then
10981:
10982: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
10983: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_LINE_ID' );
10984: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
10985: RAISE FND_API.G_EXC_ERROR;
10986:

Line 10983: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_LINE_ID' );

10979: /* verify input parameters */
10980: if P_LOAN_LINE_ID is null then
10981:
10982: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
10983: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_LINE_ID' );
10984: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
10985: RAISE FND_API.G_EXC_ERROR;
10986:
10987: end if;

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

10988:
10989: /* checking for system options values required for adjustment */
10990: if g_receivables_trx_id is null then
10991: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
10992: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
10993: FND_MSG_PUB.Add;
10994: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
10995: RAISE FND_API.G_EXC_ERROR;
10996:

Line 11020: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_FIND_ORIG_REC');

11016: l_installment_number;
11017: close add_rec_cur;
11018:
11019: if l_payment_schedule_id is null then
11020: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_FIND_ORIG_REC');
11021: FND_MSG_PUB.Add;
11022: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
11023: RAISE FND_API.G_EXC_ERROR;
11024: end if;

Line 11033: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ADJ_AMT');

11029: if l_requested_amount > l_amount_due_remaining then
11030: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Adjust amount cannot be greater than receivable remaining amount.');
11031: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Adjustment amount: -' || l_requested_amount);
11032: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Receivable remaining amount: ' || l_amount_due_remaining);
11033: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ADJ_AMT');
11034: FND_MSG_PUB.Add;
11035: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
11036: RAISE FND_API.G_EXC_ERROR;
11037: else

Line 11047: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');

11043:
11044: /* checking if adjustment for this loan already was made */
11045: if l_adj_number is not null or l_adj_id is not null then
11046: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Attempt to duplicate adjustment. Receivable has been already adjusted for this loan by adjustment xxx' );
11047: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');
11048: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);
11049: FND_MSG_PUB.Add;
11050: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
11051: RAISE FND_API.G_EXC_ERROR;

Line 11048: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);

11044: /* checking if adjustment for this loan already was made */
11045: if l_adj_number is not null or l_adj_id is not null then
11046: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Attempt to duplicate adjustment. Receivable has been already adjusted for this loan by adjustment xxx' );
11047: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');
11048: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);
11049: FND_MSG_PUB.Add;
11050: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
11051: RAISE FND_API.G_EXC_ERROR;
11052: end if;