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 167: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_SYSTEM_OPTIONS');

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

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

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

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

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

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

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

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

219:
220: if g_batch_source_id is null then
221:
222: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Batch Source is not set in the system option.');
223: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BATCH_IN_SYS_OPT');
224: FND_MSG_PUB.Add;
225: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
226: RAISE FND_API.G_EXC_ERROR;
227:

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

229:
230: if g_trx_type_id is null then
231:
232: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Default Transaction Type is not set in the system option.');
233: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_TYPE_IN_SYS_OPT');
234: FND_MSG_PUB.Add;
235: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
236: RAISE FND_API.G_EXC_ERROR;
237:

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

239:
240: if g_multiple_lines is null then
241:
242: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Combination Invoice is not set in the system option.');
243: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INV_COMB_IN_SYS_OPT');
244: FND_MSG_PUB.Add;
245: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
246: RAISE FND_API.G_EXC_ERROR;
247:

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

408:
409: IF l_return_status = 'S' THEN
410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
411: ELSE
412: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
413: FND_MSG_PUB.Add;
414: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;

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

613:
614: IF l_return_status = 'S' THEN
615: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
616: ELSE
617: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
618: FND_MSG_PUB.Add;
619: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;

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

786:
787: IF l_return_status = 'S' THEN
788: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_HEADERS_ALL');
789: ELSE
790: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
791: FND_MSG_PUB.Add;
792: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;

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

1433:
1434: if g_int_trx_type_id is null then
1435:
1436: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Interest transaction type is not set.');
1437: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INT_TRX_TYPE_IN_SYS_OPT');
1438: FND_MSG_PUB.Add;
1439: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1440: RAISE FND_API.G_EXC_ERROR;
1441:

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

1500: /* set trx_type_id */
1501: if g_fee_trx_type_id is null then
1502:
1503: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Fee transaction type is not set.');
1504: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_FEE_TRX_TYPE_IN_SYS_OPT');
1505: FND_MSG_PUB.Add;
1506: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1507: RAISE FND_API.G_EXC_ERROR;
1508:

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

1892: end loop;
1893:
1894: if l_trx_header_tbl.COUNT = 0 then
1895: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No data to create invoices.');
1896: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_DATA_CR_INV');
1897: FND_MSG_PUB.Add;
1898: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1899: RAISE FND_API.G_EXC_ERROR;
1900: end if;

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

2013:
2014: l_ar_error_counter := l_ar_error_counter + 1;
2015:
2016: if l_ar_error_counter = 1 then
2017: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2018: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2019: FND_MSG_PUB.Add;
2020: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2021: end if;

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

2014: l_ar_error_counter := l_ar_error_counter + 1;
2015:
2016: if l_ar_error_counter = 1 then
2017: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2018: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2019: FND_MSG_PUB.Add;
2020: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2021: end if;
2022:

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

2019: FND_MSG_PUB.Add;
2020: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2021: end if;
2022:
2023: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2024: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2025: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2026: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2027: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);

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

2020: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2021: end if;
2022:
2023: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2024: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2025: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2026: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2027: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2028: FND_MSG_PUB.Add;

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

2021: end if;
2022:
2023: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2024: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2025: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2026: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2027: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2028: FND_MSG_PUB.Add;
2029: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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

2022:
2023: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2024: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2025: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2026: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2027: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2028: FND_MSG_PUB.Add;
2029: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2030:

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

2023: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2024: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2025: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2026: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2027: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2028: FND_MSG_PUB.Add;
2029: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2030:
2031: END LOOP;

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

2051: l_ar_error_counter := 0;
2052: 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
2053:
2054: l_ar_error_counter := 1;
2055: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2056: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2057: FND_MSG_PUB.Add;
2058: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2059:

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

2052: 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
2053:
2054: l_ar_error_counter := 1;
2055: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2056: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2057: FND_MSG_PUB.Add;
2058: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2059:
2060: END IF;

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

2071: l_invalid_value;
2072: exit when ar_invoice_err_cur%NOTFOUND;
2073:
2074: l_ar_error_counter := l_ar_error_counter + 1;
2075: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2076: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2077: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2078: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2079: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);

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

2072: exit when ar_invoice_err_cur%NOTFOUND;
2073:
2074: l_ar_error_counter := l_ar_error_counter + 1;
2075: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2076: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2077: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2078: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2079: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2080: FND_MSG_PUB.Add;

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

2073:
2074: l_ar_error_counter := l_ar_error_counter + 1;
2075: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2076: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2077: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2078: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2079: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2080: FND_MSG_PUB.Add;
2081: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

2074: l_ar_error_counter := l_ar_error_counter + 1;
2075: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2076: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2077: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2078: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2079: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2080: FND_MSG_PUB.Add;
2081: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2082:

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

2075: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2076: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);
2077: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2078: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2079: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2080: FND_MSG_PUB.Add;
2081: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2082:
2083: END LOOP;

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

2179: close ar_invoices_cur;
2180:
2181: if l_Count2 = 0 then
2182: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No AR invoices fetched');
2183: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INV_FETCHED');
2184: FND_MSG_PUB.Add;
2185: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2186: RAISE FND_API.G_EXC_ERROR;
2187: end if;

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

2194: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_interest_trx_id;
2195:
2196: if (sql%notfound) then
2197: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2198: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');
2199: FND_MSG_PUB.Add;
2200: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2201: RAISE FND_API.G_EXC_ERROR;
2202: end if;

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

2208: update RA_CUSTOMER_TRX_ALL set RELATED_CUSTOMER_TRX_ID = l_principal_trx_id where CUSTOMER_TRX_ID = l_fee_trx_id;
2209:
2210: if (sql%notfound) then
2211: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Update RA_CUSTOMER_TRX_ALL with RELATED_CUSTOMER_TRX_ID failed');
2212: FND_MESSAGE.SET_NAME('LNS', 'LNS_RELATE_INV_FAIL');
2213: FND_MSG_PUB.Add;
2214: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2215: RAISE FND_API.G_EXC_ERROR;
2216: end if;

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

2326:
2327: if P_REVERSE_TBL(l_Count).APPLIED_AMOUNT <> 0 then
2328:
2329: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot reverse because there are some valid activities on trx.');
2330: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_REV_BILL');
2331: FND_MSG_PUB.Add;
2332: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2333: RAISE FND_API.G_EXC_ERROR;
2334:

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

2362:
2363: if P_REVERSE_TBL.count = 0 or l_trx_tbl.count = 0 then
2364:
2365: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No AR transactions found to reverse.');
2366: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_REVERSE');
2367: FND_MSG_PUB.Add;
2368: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2369: RAISE FND_API.G_EXC_ERROR;
2370:

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

2376: close batch_source_cur;
2377:
2378: if l_cm_batch_source_id is null then
2379:
2380: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CM_BATCH');
2381: FND_MESSAGE.SET_TOKEN('BATCH', l_batch_source_name);
2382: FND_MSG_PUB.Add;
2383: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2384: RAISE FND_API.G_EXC_ERROR;

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

2377:
2378: if l_cm_batch_source_id is null then
2379:
2380: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CM_BATCH');
2381: FND_MESSAGE.SET_TOKEN('BATCH', l_batch_source_name);
2382: FND_MSG_PUB.Add;
2383: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2384: RAISE FND_API.G_EXC_ERROR;
2385:

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

2454:
2455: THEN
2456:
2457: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST raised unexpected error: ' || substr(l_msg_data,1,225));
2458: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_CM_FAIL');
2459: FND_MESSAGE.SET_TOKEN('BATCH', l_cm_batch_source_name);
2460: FND_MSG_PUB.Add;
2461: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2462: RAISE FND_API.G_EXC_ERROR;

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

2455: THEN
2456:
2457: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: AR_CREDIT_MEMO_API_PUB.CREATE_REQUEST raised unexpected error: ' || substr(l_msg_data,1,225));
2458: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_CM_FAIL');
2459: FND_MESSAGE.SET_TOKEN('BATCH', l_cm_batch_source_name);
2460: FND_MSG_PUB.Add;
2461: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2462: RAISE FND_API.G_EXC_ERROR;
2463:

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

2550: /* verify input data */
2551:
2552: if P_CASH_RECEIPT_ID is null then
2553: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cash Receipt ID is not set.');
2554: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_NOT_SET');
2555: FND_MSG_PUB.Add;
2556: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2557: RAISE FND_API.G_EXC_ERROR;
2558: end if;

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

2558: end if;
2559:
2560: if P_TRX_ID is null then
2561: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Trx ID is not set.');
2562: FND_MESSAGE.SET_NAME('LNS', 'LNS_TRX_NOT_SET');
2563: FND_MSG_PUB.Add;
2564: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2565: RAISE FND_API.G_EXC_ERROR;
2566: end if;

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

2566: end if;
2567:
2568: if P_TRX_LINE_ID is null then
2569: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Trx Line ID is not set.');
2570: FND_MESSAGE.SET_NAME('LNS', 'LNS_TRX_LINE_NOT_SET');
2571: FND_MSG_PUB.Add;
2572: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2573: RAISE FND_API.G_EXC_ERROR;
2574: end if;

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

2574: end if;
2575:
2576: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then
2577: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Apply Amount is not set.');
2578: FND_MESSAGE.SET_NAME('LNS', 'LNS_AMOUNT_NOT_SET');
2579: FND_MSG_PUB.Add;
2580: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2581: RAISE FND_API.G_EXC_ERROR;
2582: end if;

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

2587: fetch receipt_cur into l_receipt_rem_amount;
2588:
2589: if receipt_cur%NOTFOUND then
2590: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No receipt found to apply.');
2591: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FOUND');
2592: FND_MSG_PUB.Add;
2593: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2594: RAISE FND_API.G_EXC_ERROR;
2595: end if;

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

2597: close receipt_cur;
2598:
2599: if l_receipt_rem_amount < P_APPLY_AMOUNT then
2600: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: The receipt does not have enough funds to apply requested amount.');
2601: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CR_FUNDS');
2602: FND_MSG_PUB.Add;
2603: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2604: RAISE FND_API.G_EXC_ERROR;
2605: end if;

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

2623:
2624: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2625:
2626: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: AR_RECEIPT_API_PUB.APPLY raised error: ' || substr(l_msg_data,1,225));
2627: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
2628: FND_MSG_PUB.Add;
2629: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2630: RAISE FND_API.G_EXC_ERROR;
2631:

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

3460: fetch verify_amount_cur into l_valid_amount;
3461: close verify_amount_cur;
3462:
3463: if P_PRIN_AMOUNT > l_valid_amount then
3464: -- FND_MESSAGE.SET_ENCODED('Principal bill amount cannot be greater than ' || l_valid_amount);
3465: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PRIN_BILL_AMOUNT');
3466: FND_MSG_PUB.Add;
3467: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3468: RAISE FND_API.G_EXC_ERROR;

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

3461: close verify_amount_cur;
3462:
3463: if P_PRIN_AMOUNT > l_valid_amount then
3464: -- FND_MESSAGE.SET_ENCODED('Principal bill amount cannot be greater than ' || l_valid_amount);
3465: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PRIN_BILL_AMOUNT');
3466: FND_MSG_PUB.Add;
3467: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3468: RAISE FND_API.G_EXC_ERROR;
3469: end if;

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

3636: P_LOAN_REC.NEXT_PAYMENT_DUE_DATE is null or
3637: P_LOAN_REC.LOAN_PAYMENT_FREQUENCY is null then
3638:
3639: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan misses some important data. Cannot proceed with billing of this loan.');
3640: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_MISS_DATA');
3641: FND_MESSAGE.SET_TOKEN('LOAN', P_LOAN_REC.LOAN_NUMBER);
3642: FND_MSG_PUB.Add;
3643: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3644: RAISE FND_API.G_EXC_ERROR;

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

3637: P_LOAN_REC.LOAN_PAYMENT_FREQUENCY is null then
3638:
3639: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan misses some important data. Cannot proceed with billing of this loan.');
3640: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_MISS_DATA');
3641: FND_MESSAGE.SET_TOKEN('LOAN', P_LOAN_REC.LOAN_NUMBER);
3642: FND_MSG_PUB.Add;
3643: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3644: RAISE FND_API.G_EXC_ERROR;
3645:

Line 3778: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_AMOUNT_INST');

3774: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0. Nothing to bill.');
3775: return;
3776:
3777: /*
3778: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_AMOUNT_INST');
3779: FND_MSG_PUB.Add;
3780: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3781: RAISE FND_API.G_EXC_ERROR;
3782: */

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

3895:
3896: /* added fee installment validation by raverma request */
3897: if l_amortization_rec.INSTALLMENT_NUMBER <> l_fee_tbl(l_Count).FEE_INSTALLMENT then
3898:
3899: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_INSTAL');
3900: FND_MSG_PUB.Add;
3901: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3902: RAISE FND_API.G_EXC_ERROR;
3903:

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

3989: IF l_return_status = 'S' THEN
3990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
3991: ELSE
3992: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
3993: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3994: FND_MSG_PUB.Add;
3995: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3996: RAISE FND_API.G_EXC_ERROR;
3997: END IF;

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

4251:
4252: if l_next_payment_due_date is null then
4253:
4254: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Next installment date is unknown.');
4255: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INST_DUE_DATE');
4256: FND_MSG_PUB.Add;
4257: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4258: RAISE FND_API.G_EXC_ERROR;
4259:

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

4278: IF l_return_status = 'S' THEN
4279: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4280: ELSE
4281: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4282: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4283: FND_MSG_PUB.Add;
4284: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4285: RAISE FND_API.G_EXC_ERROR;
4286: END IF;

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

4316: IF l_return_status = 'S' THEN
4317: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
4318: ELSE
4319: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
4320: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
4321: FND_MSG_PUB.Add;
4322: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4323: RAISE FND_API.G_EXC_ERROR;
4324: END IF;

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

4815: elsif P_BORROWER_ID is null and P_FROM_DAYS_TO_DD is null and P_TO_DAYS_TO_DD is null then
4816:
4817: if g_days_to_bill_before_dd is null then
4818: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: At least one of the days must be set.');
4819: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BILLING_INP_PAR');
4820: FND_MSG_PUB.Add;
4821: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4822: RAISE FND_API.G_EXC_ERROR;
4823: else

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

5411: /* verify input parameters */
5412: if P_LOAN_ID is null then
5413:
5414: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
5415: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
5416: FND_MSG_PUB.Add;
5417: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5418: RAISE FND_API.G_EXC_ERROR;
5419:

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

5492: /* Verify count */
5493: if l_reverse_tbl.count = 0 then
5494:
5495: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No trx lines found to reverse.');
5496: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');
5497: FND_MSG_PUB.Add;
5498: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5499: RAISE FND_API.G_EXC_ERROR;
5500:

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

5571: IF l_return_status = 'S' THEN
5572: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully calculated next payment due date.');
5573: ELSE
5574: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to calculate next payment due date.');
5575: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALC_NEXT_DUE_FAIL');
5576: FND_MSG_PUB.Add;
5577: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5578: RAISE FND_API.G_EXC_ERROR;
5579: END IF;

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

5822: /* verify input parameters */
5823: if P_LOAN_ID is null then
5824:
5825: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
5826: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
5827: FND_MSG_PUB.Add;
5828: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5829: RAISE FND_API.G_EXC_ERROR;
5830:

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

5830:
5831: end if;
5832:
5833: if P_LINE_TYPE is null then
5834: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LINE_TYPE');
5835: FND_MSG_PUB.Add;
5836: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5837: RAISE FND_API.G_EXC_ERROR;
5838: end if;

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

5899:
5900: /* Verify count */
5901: if l_reverse_tbl.count = 0 then
5902:
5903: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');
5904: FND_MSG_PUB.Add;
5905: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5906: RAISE FND_API.G_EXC_ERROR;
5907:

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

6087: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || P_BILL_HEADER_REC.DUE_DATE);
6088:
6089: if P_BILL_HEADER_REC.LOAN_ID is null then
6090: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan ID is not set.');
6091: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LOAN');
6092: FND_MSG_PUB.Add;
6093: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6094: RAISE FND_API.G_EXC_ERROR;
6095: end if;

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

6095: end if;
6096:
6097: if P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM is null then
6098: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Associated Payment Number is not set.');
6099: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_NUM');
6100: FND_MSG_PUB.Add;
6101: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6102: RAISE FND_API.G_EXC_ERROR;
6103: end if;

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

6103: end if;
6104:
6105: if P_BILL_HEADER_REC.DUE_DATE is null then
6106: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Bill Due Date is not set.');
6107: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_DUE');
6108: FND_MSG_PUB.Add;
6109: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6110: RAISE FND_API.G_EXC_ERROR;
6111: end if;

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

6111: end if;
6112:
6113: if l_lines_tbl.count = 0 then
6114: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No lines found for header ' || P_BILL_HEADER_REC.HEADER_ID);
6115: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINES');
6116: FND_MESSAGE.SET_TOKEN('HEADER', P_BILL_HEADER_REC.HEADER_ID);
6117: FND_MSG_PUB.Add;
6118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6119: RAISE FND_API.G_EXC_ERROR;

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

6112:
6113: if l_lines_tbl.count = 0 then
6114: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No lines found for header ' || P_BILL_HEADER_REC.HEADER_ID);
6115: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINES');
6116: FND_MESSAGE.SET_TOKEN('HEADER', P_BILL_HEADER_REC.HEADER_ID);
6117: FND_MSG_PUB.Add;
6118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6119: RAISE FND_API.G_EXC_ERROR;
6120: end if;

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

6141:
6142: /* Verifying lines data */
6143: if l_lines_tbl(l_Count).LINE_AMOUNT is null or l_lines_tbl(l_Count).LINE_AMOUNT <= 0 then
6144: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Amount for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6145: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_AMOUNT');
6146: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6147: FND_MSG_PUB.Add;
6148: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6149: RAISE FND_API.G_EXC_ERROR;

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

6142: /* Verifying lines data */
6143: if l_lines_tbl(l_Count).LINE_AMOUNT is null or l_lines_tbl(l_Count).LINE_AMOUNT <= 0 then
6144: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Amount for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6145: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_AMOUNT');
6146: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6147: FND_MSG_PUB.Add;
6148: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6149: RAISE FND_API.G_EXC_ERROR;
6150: end if;

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

6150: end if;
6151:
6152: if l_lines_tbl(l_Count).LINE_TYPE is null then
6153: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Line type for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6154: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_TYPE');
6155: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6156: FND_MSG_PUB.Add;
6157: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6158: RAISE FND_API.G_EXC_ERROR;

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

6151:
6152: if l_lines_tbl(l_Count).LINE_TYPE is null then
6153: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Line type for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6154: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_TYPE');
6155: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6156: FND_MSG_PUB.Add;
6157: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6158: RAISE FND_API.G_EXC_ERROR;
6159: end if;

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

6204:
6205:
6206: if loan_cur%NOTFOUND then
6207: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No amortization record found.');
6208: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_INSTALLMENT');
6209: FND_MESSAGE.SET_TOKEN('LOAN',P_BILL_HEADER_REC.LOAN_ID);
6210: FND_MESSAGE.SET_TOKEN('INST', P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM);
6211: FND_MSG_PUB.Add;
6212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

6205:
6206: if loan_cur%NOTFOUND then
6207: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No amortization record found.');
6208: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_INSTALLMENT');
6209: FND_MESSAGE.SET_TOKEN('LOAN',P_BILL_HEADER_REC.LOAN_ID);
6210: FND_MESSAGE.SET_TOKEN('INST', P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM);
6211: FND_MSG_PUB.Add;
6212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6213: RAISE FND_API.G_EXC_ERROR;

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

6206: if loan_cur%NOTFOUND then
6207: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No amortization record found.');
6208: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_INSTALLMENT');
6209: FND_MESSAGE.SET_TOKEN('LOAN',P_BILL_HEADER_REC.LOAN_ID);
6210: FND_MESSAGE.SET_TOKEN('INST', P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM);
6211: FND_MSG_PUB.Add;
6212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6213: RAISE FND_API.G_EXC_ERROR;
6214: end if;

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

6456: FOR l_Count IN 1..P_BILL_HEADERS_TBL.count LOOP
6457:
6458: if P_BILL_HEADERS_TBL(l_Count).HEADER_ID is null then
6459: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Header ID is not set.');
6460: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_HEADER');
6461: FND_MSG_PUB.Add;
6462: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6463: RAISE FND_API.G_EXC_ERROR;
6464: end if;

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

6471: FOR l_Count1 IN 1..P_BILL_LINES_TBL.count LOOP
6472:
6473: if P_BILL_LINES_TBL(l_Count1).HEADER_ID is null then
6474: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Header ID for line ' || P_BILL_LINES_TBL(l_Count1).LINE_ID || ' is not set.');
6475: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_HEADER');
6476: FND_MESSAGE.SET_TOKEN('LINE', P_BILL_LINES_TBL(l_Count1).LINE_ID);
6477: FND_MSG_PUB.Add;
6478: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6479: RAISE FND_API.G_EXC_ERROR;

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

6472:
6473: if P_BILL_LINES_TBL(l_Count1).HEADER_ID is null then
6474: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Header ID for line ' || P_BILL_LINES_TBL(l_Count1).LINE_ID || ' is not set.');
6475: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_HEADER');
6476: FND_MESSAGE.SET_TOKEN('LINE', P_BILL_LINES_TBL(l_Count1).LINE_ID);
6477: FND_MSG_PUB.Add;
6478: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6479: RAISE FND_API.G_EXC_ERROR;
6480: end if;

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

6684:
6685: /* verify input parameters */
6686: if P_AMORTIZATION_ID is null then
6687: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Amortization ID must be set.');
6688: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_AMORT');
6689: FND_MSG_PUB.Add;
6690: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6691: RAISE FND_API.G_EXC_ERROR;
6692: end if;

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

6704:
6705: if amort_cur%NOTFOUND then
6706:
6707: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: No amortization record found.');
6708: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_BILL_FOUND');
6709: FND_MSG_PUB.Add;
6710: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6711: RAISE FND_API.G_EXC_ERROR;
6712:

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

6720:
6721: if l_PARENT_AMORTIZATION_ID is null then
6722:
6723: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: The amortization is not offcycle bill.');
6724: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NOT_MAN_BILL');
6725: FND_MSG_PUB.Add;
6726: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6727: RAISE FND_API.G_EXC_ERROR;
6728:

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

6728:
6729: elsif l_REVERSED_FLAG = 'Y' then
6730:
6731: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: The amortization is already reversed.');
6732: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_ALREADY_REV');
6733: FND_MSG_PUB.Add;
6734: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6735: RAISE FND_API.G_EXC_ERROR;
6736:

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

6775: /* Check for table count */
6776: if l_reverse_tbl.count = 0 then
6777:
6778: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No trx lines found to reverse.');
6779: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');
6780: FND_MSG_PUB.Add;
6781: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6782: RAISE FND_API.G_EXC_ERROR;
6783:

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

6995: /* verify input parameters */
6996: if P_LOAN_ID is null then
6997:
6998: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
6999: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
7000: FND_MSG_PUB.Add;
7001: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7002: RAISE FND_API.G_EXC_ERROR;
7003:

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

7005:
7006: /* checking for system options values required for adjustment */
7007: if g_receivables_trx_id is null then
7008: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
7009: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
7010: FND_MSG_PUB.Add;
7011: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7012: RAISE FND_API.G_EXC_ERROR;
7013:

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

7021: if l_ussgl_flag = 'Y' then
7022:
7023: if g_USSGL_TRANSACTION_CODE is null then
7024: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: USSGL Transaction Code is not set in the system option.');
7025: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_CODE_IN_SYS_OPT');
7026: FND_MSG_PUB.Add;
7027: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7028: RAISE FND_API.G_EXC_ERROR;
7029:

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

7067: if l_requested_amount > l_amount_due_remaining then
7068: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Adjust amount cannot be greater than receivable remaining amount.');
7069: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Adjustment amount: -' || l_requested_amount);
7070: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Receivable remaining amount: ' || l_amount_due_remaining);
7071: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ADJ_AMT');
7072: FND_MSG_PUB.Add;
7073: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7074: RAISE FND_API.G_EXC_ERROR;
7075: else

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

7081:
7082: /* checking if adjustment for this loan already was made */
7083: if l_adj_number is not null or l_adj_id is not null then
7084: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Attempt to duplicate adjustment. Receivable has been already adjusted for this loan by adjustment xxx' );
7085: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');
7086: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);
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;

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

7082: /* checking if adjustment for this loan already was made */
7083: if l_adj_number is not null or l_adj_id is not null then
7084: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Attempt to duplicate adjustment. Receivable has been already adjusted for this loan by adjustment xxx' );
7085: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');
7086: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);
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 7154: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_FIND_ORIG_REC');

7150: close orig_rec_cur;
7151:
7152: if l_Count = 0 then
7153: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Cannot find receivable to adjust.');
7154: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_FIND_ORIG_REC');
7155: FND_MSG_PUB.Add;
7156: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7157: RAISE FND_API.G_EXC_ERROR;
7158: end if;

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

7307: /* verify input parameters */
7308: if P_LOAN_ID is null then
7309:
7310: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
7311: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
7312: FND_MSG_PUB.Add;
7313: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7314: RAISE FND_API.G_EXC_ERROR;
7315:

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

7428:
7429: /* added fee installment validation by raverma request */
7430: if l_amortization_rec.INSTALLMENT_NUMBER <> l_fee_tbl(l_Count).FEE_INSTALLMENT then
7431:
7432: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_INSTAL');
7433: FND_MSG_PUB.Add;
7434: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7435: RAISE FND_API.G_EXC_ERROR;
7436:

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

7644: /* verify input parameters */
7645: if P_LOAN_ID is null then
7646:
7647: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
7648: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
7649: FND_MSG_PUB.Add;
7650: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7651: RAISE FND_API.G_EXC_ERROR;
7652: