APPS.LNS_BILLING_BATCH_PUB dependencies on FND_MSG_PUB

Line 173: FND_MSG_PUB.Add;

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:
177: elsif g_sys_opt_num > 1 then

Line 174: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
177: elsif g_sys_opt_num > 1 then
178:

Line 182: FND_MSG_PUB.Add;

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:
186: end if;

Line 183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
186: end if;
187:

Line 231: FND_MSG_PUB.Add;

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:
235: end if;

Line 232: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
235: end if;
236:

Line 241: FND_MSG_PUB.Add;

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:
245: end if;

Line 242: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
245: end if;
246:

Line 251: FND_MSG_PUB.Add;

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:
255: end if;

Line 252: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
255: end if;
256:

Line 421: FND_MSG_PUB.Add;

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;
425:

Line 422: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
425:
426: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 538: FND_MSG_PUB.initialize;

534: SAVEPOINT PROCESS_PAID_LOANS;
535:
536: -- Initialize message list IF p_init_msg_list is set to TRUE.
537: IF FND_API.to_Boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: -- Initialize API return status to SUCCESS
542: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 625: FND_MSG_PUB.Add;

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;
629:

Line 626: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
629:
630: if P_COMMIT = FND_API.G_TRUE then

Line 798: FND_MSG_PUB.Add;

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;
802:

Line 799: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
802:
803: if P_COMMIT = FND_API.G_TRUE then

Line 1241: FND_MSG_PUB.Add;

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;
1245:

Line 1242: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
1245:
1246: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Preparing to call AR invoice api...');

Line 1520: FND_MSG_PUB.Add;

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:
1524: end if;

Line 1521: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
1524: end if;
1525:

Line 1589: FND_MSG_PUB.Add;

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:
1593: end if;

Line 1590: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
1593: end if;
1594:

Line 2008: FND_MSG_PUB.Add;

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: */
2012:

Line 2009: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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: */
2012:
2013: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Creating AR invoices with following values:');

Line 2139: FND_MSG_PUB.Add;

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

Line 2140: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
2143: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_ERROR');
2144: FND_MESSAGE.SET_TOKEN('ERR', l_error_message);

Line 2148: FND_MSG_PUB.Add;

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;
2152:

Line 2149: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2152:
2153: close ar_invoice_err_cur;

Line 2177: FND_MSG_PUB.Add;

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;
2181:

Line 2178: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2181:
2182: /* query AR errors */

Line 2200: FND_MSG_PUB.Add;

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;
2204:

Line 2201: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2204:
2205: close ar_invoice_err_cur;

Line 2351: FND_MSG_PUB.Add;

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;
2355:

Line 2352: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2355:
2356: /* Update interest and fee trxs with principal_trx_id as RELATED_CUSTOMER_TRX_ID */

Line 2366: FND_MSG_PUB.Add;

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;
2370:

Line 2367: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2370:
2371: end if;

Line 2380: FND_MSG_PUB.Add;

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;
2384:

Line 2381: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2384:
2385: end if;

Line 2505: FND_MSG_PUB.Add;

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:
2509: end if;

Line 2506: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
2509: end if;
2510:

Line 2541: FND_MSG_PUB.Add;

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:
2545: end if;

Line 2542: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
2545: end if;
2546:

Line 2556: FND_MSG_PUB.Add;

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:
2560: end if;

Line 2557: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
2560: end if;
2561:

Line 2653: FND_MSG_PUB.Add;

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:
2657: ELSE

Line 2654: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
2657: ELSE
2658:

Line 2748: FND_MSG_PUB.Add;

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;
2752:

Line 2749: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2752:
2753: if P_TRX_ID is null then

Line 2756: FND_MSG_PUB.Add;

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;
2760:

Line 2757: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2760:
2761: if P_TRX_LINE_ID is null then

Line 2764: FND_MSG_PUB.Add;

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;
2768:

Line 2765: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2768:
2769: if P_APPLY_AMOUNT is null or P_APPLY_AMOUNT <= 0 then

Line 2772: FND_MSG_PUB.Add;

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;
2776:

Line 2773: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2776:
2777: /* verifying requested qpply amount */

Line 2785: FND_MSG_PUB.Add;

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;
2789:

Line 2786: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2789:
2790: close receipt_cur;

Line 2795: FND_MSG_PUB.Add;

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;
2799:

Line 2796: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
2799:
2800: /* Applying cash receipt to invoice */

Line 2821: FND_MSG_PUB.Add;

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:
2825: ELSE

Line 2822: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
2825: ELSE
2826: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);

Line 2997: FND_MSG_PUB.Add;

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:
3000: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_count: ' || l_msg_count);
3001: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_data: ' || l_msg_data);

Line 2998: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
3000: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_count: ' || l_msg_count);
3001: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_data: ' || l_msg_data);
3002:

Line 3004: fnd_msg_pub.get(l_indexNo, 'F', l_msg, l_index);

3000: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_count: ' || l_msg_count);
3001: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_data: ' || l_msg_data);
3002:
3003: while (l_indexNo <= l_msg_Count ) loop
3004: fnd_msg_pub.get(l_indexNo, 'F', l_msg, l_index);
3005: LogMessage(FND_LOG.LEVEL_ERROR, 'Error: ' || l_msg);
3006: l_indexNo := l_indexNo + 1;
3007: End Loop;
3008:

Line 3136: fnd_msg_pub.get(l_indexNo, 'F', l_error, l_index);

3132: l_statement := l_statement || l_new_line || '' || l_currency || '';
3133:
3134: l_statement := l_statement || l_new_line || '' || l_new_line;
3135: while (l_indexNo <= P_ERR_COUNT ) loop
3136: fnd_msg_pub.get(l_indexNo, 'F', l_error, l_index);
3137: l_error := LNS_REP_UTILS.REPLACE_SPECIAL_CHARS(l_error);
3138: l_statement := l_statement || l_error;
3139: l_indexNo := l_indexNo + 1;
3140: End Loop;

Line 3708: FND_MSG_PUB.Add;

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);
3712: RAISE FND_API.G_EXC_ERROR;

Line 3709: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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);
3712: RAISE FND_API.G_EXC_ERROR;
3713:

Line 3784: FND_MSG_PUB.Add;

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;
3788:

Line 3785: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
3788:
3789: END;

Line 3923: FND_MSG_PUB.initialize;

3919: END IF;
3920:
3921: -- Initialize message list if p_init_msg_list is set to TRUE
3922: IF FND_API.To_Boolean(p_init_msg_list) THEN
3923: FND_MSG_PUB.initialize;
3924: END IF;
3925:
3926: -- Initialize API return status to success
3927: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3965: FND_MSG_PUB.Add;

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:
3969: end if;

Line 3966: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
3969: end if;
3970:

Line 4103: FND_MSG_PUB.Add;

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;
4107:

Line 4104: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4107:
4108:

Line 4138: FND_MSG_PUB.Add;

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;
4142: end if;

Line 4139: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4142: end if;
4143:

Line 4244: FND_MSG_PUB.Add;

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:
4248: end if;

Line 4245: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
4248: end if;
4249:

Line 4311: FND_MSG_PUB.Add;

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;
4315:

Line 4312: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4315:
4316: STORE_LAST_PAYMENT_NUMBER(P_LOAN_REC.LOAN_ID);

Line 4357: FND_MSG_PUB.Count_And_Get(

4353: -- END OF BODY OF API
4354: x_return_status := FND_API.G_RET_STS_SUCCESS;
4355:
4356: -- Standard call to get message count and if count is 1, get message info
4357: FND_MSG_PUB.Count_And_Get(
4358: p_encoded => FND_API.G_FALSE,
4359: p_count => x_msg_count,
4360: p_data => x_msg_data);
4361:

Line 4369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4365: EXCEPTION
4366: WHEN FND_API.G_EXC_ERROR THEN
4367: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
4368: x_return_status := FND_API.G_RET_STS_ERROR;
4369: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4370: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);
4371: g_cr_return_status := 'WARNING';
4372:
4373: /* building error statement */

Line 4386: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4382:
4383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4384: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
4385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4386: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4387: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);
4388: g_cr_return_status := 'WARNING';
4389:
4390: /* building error statement */

Line 4403: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

4399:
4400: WHEN OTHERS THEN
4401: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
4402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4403: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4404: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4405: END IF;
4406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4407: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);

Line 4404: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

4400: WHEN OTHERS THEN
4401: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
4402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4403: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4404: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4405: END IF;
4406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4407: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);
4408: g_cr_return_status := 'WARNING';

Line 4406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4403: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4404: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4405: END IF;
4406: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4407: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);
4408: g_cr_return_status := 'WARNING';
4409:
4410: /* building error statement */

Line 4514: FND_MSG_PUB.initialize;

4510: END IF;
4511:
4512: -- Initialize message list if p_init_msg_list is set to TRUE
4513: IF FND_API.To_Boolean(p_init_msg_list) THEN
4514: FND_MSG_PUB.initialize;
4515: END IF;
4516:
4517: -- Initialize API return status to success
4518: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4573: FND_MSG_PUB.Add;

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:
4577: end if;

Line 4574: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
4577: end if;
4578:

Line 4600: FND_MSG_PUB.Add;

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;
4604:

Line 4601: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4604:
4605: /* getting terms version for future update */

Line 4638: FND_MSG_PUB.Add;

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;
4642:

Line 4639: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
4642:
4643: l_end := sysdate;

Line 4655: FND_MSG_PUB.Count_And_Get(

4651: -- END OF BODY OF API
4652: x_return_status := FND_API.G_RET_STS_SUCCESS;
4653:
4654: -- Standard call to get message count and if count is 1, get message info
4655: FND_MSG_PUB.Count_And_Get(
4656: p_encoded => FND_API.G_FALSE,
4657: p_count => x_msg_count,
4658: p_data => x_msg_data);
4659:

Line 4667: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4663: EXCEPTION
4664: WHEN FND_API.G_EXC_ERROR THEN
4665: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4666: x_return_status := FND_API.G_RET_STS_ERROR;
4667: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4668: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4670: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4672: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4668: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4670: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4672: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4673: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4674: WHEN OTHERS THEN
4675: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

4673: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4674: WHEN OTHERS THEN
4675: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4679: END IF;
4680: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4681: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);

Line 4678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

4674: WHEN OTHERS THEN
4675: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4679: END IF;
4680: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4681: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4682: END;

Line 4680: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

4676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4677: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4678: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4679: END IF;
4680: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4681: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4682: END;
4683:
4684:

Line 5057: FND_MSG_PUB.initialize;

5053: END IF;
5054:
5055: -- Initialize message list if p_init_msg_list is set to TRUE
5056: IF FND_API.To_Boolean(p_init_msg_list) THEN
5057: FND_MSG_PUB.initialize;
5058: END IF;
5059:
5060: -- Initialize API return status to success
5061: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5124: FND_MSG_PUB.Add;

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;
5128:

Line 5125: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
5128:
5129: else

Line 5150: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5146: EXCEPTION
5147: WHEN OTHERS THEN
5148: ROLLBACK TO BILL_LOANS_EXT_PVT1;
5149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5150: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5151: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan ' || l_loans_to_bill_tbl(l_Count1).LOAN_NUMBER);
5152: g_cr_return_status := 'WARNING';
5153:
5154: /* building error statement */

Line 5199: FND_MSG_PUB.Count_And_Get(

5195: -- END OF BODY OF API
5196: x_return_status := FND_API.G_RET_STS_SUCCESS;
5197:
5198: -- Standard call to get message count and if count is 1, get message info
5199: FND_MSG_PUB.Count_And_Get(
5200: p_encoded => FND_API.G_FALSE,
5201: p_count => x_msg_count,
5202: p_data => x_msg_data);
5203:

Line 5210: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5206: EXCEPTION
5207: WHEN FND_API.G_EXC_ERROR THEN
5208: ROLLBACK TO BILL_LOANS_EXT_PVT;
5209: x_return_status := FND_API.G_RET_STS_ERROR;
5210: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5211: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
5212: g_cr_return_status := 'ERROR';
5213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5214: ROLLBACK TO BILL_LOANS_EXT_PVT;

Line 5216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5212: g_cr_return_status := 'ERROR';
5213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5214: ROLLBACK TO BILL_LOANS_EXT_PVT;
5215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5217: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
5218: g_cr_return_status := 'ERROR';
5219: WHEN OTHERS THEN
5220: ROLLBACK TO BILL_LOANS_EXT_PVT;

Line 5222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

5218: g_cr_return_status := 'ERROR';
5219: WHEN OTHERS THEN
5220: ROLLBACK TO BILL_LOANS_EXT_PVT;
5221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5224: END IF;
5225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');

Line 5223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

5219: WHEN OTHERS THEN
5220: ROLLBACK TO BILL_LOANS_EXT_PVT;
5221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5224: END IF;
5225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
5227: g_cr_return_status := 'ERROR';

Line 5225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5222: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5223: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5224: END IF;
5225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
5227: g_cr_return_status := 'ERROR';
5228: END;
5229:

Line 5381: FND_MSG_PUB.initialize;

5377: END IF;
5378:
5379: -- Initialize message list if p_init_msg_list is set to TRUE
5380: IF FND_API.To_Boolean(p_init_msg_list) THEN
5381: FND_MSG_PUB.initialize;
5382: END IF;
5383:
5384: -- Initialize API return status to success
5385: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5422: FND_MSG_PUB.Add;

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
5426: l_to_date := g_days_to_bill_before_dd;

Line 5423: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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
5426: l_to_date := g_days_to_bill_before_dd;
5427: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'To Days/Date: ' || l_to_date || GET_BILLING_DATE(l_to_date));

Line 5632: FND_MSG_PUB.Count_And_Get(

5628: -- END OF BODY OF API
5629: x_return_status := FND_API.G_RET_STS_SUCCESS;
5630:
5631: -- Standard call to get message count and if count is 1, get message info
5632: FND_MSG_PUB.Count_And_Get(
5633: p_encoded => FND_API.G_FALSE,
5634: p_count => x_msg_count,
5635: p_data => x_msg_data);
5636:

Line 5643: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5639: EXCEPTION
5640: WHEN FND_API.G_EXC_ERROR THEN
5641: ROLLBACK TO BILL_LOANS_PVT;
5642: x_return_status := FND_API.G_RET_STS_ERROR;
5643: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5644: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5645: g_cr_return_status := 'ERROR';
5646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5647: ROLLBACK TO BILL_LOANS_PVT;

Line 5649: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5645: g_cr_return_status := 'ERROR';
5646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5647: ROLLBACK TO BILL_LOANS_PVT;
5648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5649: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5650: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5651: g_cr_return_status := 'ERROR';
5652: WHEN OTHERS THEN
5653: ROLLBACK TO BILL_LOANS_PVT;

Line 5655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

5651: g_cr_return_status := 'ERROR';
5652: WHEN OTHERS THEN
5653: ROLLBACK TO BILL_LOANS_PVT;
5654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5656: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5657: END IF;
5658: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5659: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');

Line 5656: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

5652: WHEN OTHERS THEN
5653: ROLLBACK TO BILL_LOANS_PVT;
5654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5656: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5657: END IF;
5658: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5659: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5660: g_cr_return_status := 'ERROR';

Line 5658: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5656: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5657: END IF;
5658: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5659: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5660: g_cr_return_status := 'ERROR';
5661: END;
5662:

Line 5762: FND_MSG_PUB.initialize;

5758: END IF;
5759:
5760: -- Initialize message list if p_init_msg_list is set to TRUE
5761: IF FND_API.To_Boolean(p_init_msg_list) THEN
5762: FND_MSG_PUB.initialize;
5763: END IF;
5764:
5765: -- Initialize API return status to success
5766: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5821: FND_MSG_PUB.Count_And_Get(

5817: -- END OF BODY OF API
5818: x_return_status := FND_API.G_RET_STS_SUCCESS;
5819:
5820: -- Standard call to get message count and if count is 1, get message info
5821: FND_MSG_PUB.Count_And_Get(
5822: p_encoded => FND_API.G_FALSE,
5823: p_count => x_msg_count,
5824: p_data => x_msg_data);
5825:

Line 5832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5828: EXCEPTION
5829: WHEN FND_API.G_EXC_ERROR THEN
5830: ROLLBACK TO LOANS_NEXT_DD_PVT;
5831: x_return_status := FND_API.G_RET_STS_ERROR;
5832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5833: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5835: ROLLBACK TO LOANS_NEXT_DD_PVT;
5836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5833: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5835: ROLLBACK TO LOANS_NEXT_DD_PVT;
5836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5838: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5839: WHEN OTHERS THEN
5840: ROLLBACK TO LOANS_NEXT_DD_PVT;
5841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

5838: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5839: WHEN OTHERS THEN
5840: ROLLBACK TO LOANS_NEXT_DD_PVT;
5841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5843: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5844: END IF;
5845: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5846: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');

Line 5843: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

5839: WHEN OTHERS THEN
5840: ROLLBACK TO LOANS_NEXT_DD_PVT;
5841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5843: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5844: END IF;
5845: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5846: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5847: END;

Line 5845: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

5841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5842: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5843: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5844: END IF;
5845: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5846: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5847: END;
5848:
5849:

Line 6001: FND_MSG_PUB.initialize;

5997: END IF;
5998:
5999: -- Initialize message list if p_init_msg_list is set to TRUE
6000: IF FND_API.To_Boolean(p_init_msg_list) THEN
6001: FND_MSG_PUB.initialize;
6002: END IF;
6003:
6004: -- Initialize API return status to success
6005: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6030: FND_MSG_PUB.Add;

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:
6034: end if;

Line 6031: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
6034: end if;
6035:

Line 6112: FND_MSG_PUB.Add;

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: */
6116: else

Line 6113: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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: */
6116: else
6117:

Line 6194: FND_MSG_PUB.Add;

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;
6198:

Line 6195: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6198:
6199: STORE_LAST_PAYMENT_NUMBER(P_LOAN_ID);

Line 6262: FND_MSG_PUB.Count_And_Get(

6258: -- END OF BODY OF API
6259: x_return_status := FND_API.G_RET_STS_SUCCESS;
6260:
6261: -- Standard call to get message count and if count is 1, get message info
6262: FND_MSG_PUB.Count_And_Get(
6263: p_encoded => FND_API.G_FALSE,
6264: p_count => x_msg_count,
6265: p_data => x_msg_data);
6266:

Line 6273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6269: EXCEPTION
6270: WHEN FND_API.G_EXC_ERROR THEN
6271: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
6272: x_return_status := FND_API.G_RET_STS_ERROR;
6273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6274: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6275: g_cr_return_status := 'ERROR';
6276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6277: ROLLBACK TO REVERSE_LAST_AMORTIZATION;

Line 6279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6275: g_cr_return_status := 'ERROR';
6276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6277: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
6278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6280: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6281: g_cr_return_status := 'ERROR';
6282: WHEN OTHERS THEN
6283: ROLLBACK TO REVERSE_LAST_AMORTIZATION;

Line 6285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

6281: g_cr_return_status := 'ERROR';
6282: WHEN OTHERS THEN
6283: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
6284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6286: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6287: END IF;
6288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6289: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');

Line 6286: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

6282: WHEN OTHERS THEN
6283: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
6284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6286: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6287: END IF;
6288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6289: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6290: g_cr_return_status := 'ERROR';

Line 6288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6285: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6286: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6287: END IF;
6288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6289: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6290: g_cr_return_status := 'ERROR';
6291: END;
6292:

Line 6424: FND_MSG_PUB.initialize;

6420: END IF;
6421:
6422: -- Initialize message list if p_init_msg_list is set to TRUE
6423: IF FND_API.To_Boolean(p_init_msg_list) THEN
6424: FND_MSG_PUB.initialize;
6425: END IF;
6426:
6427: -- Initialize API return status to success
6428: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6448: FND_MSG_PUB.Add;

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:
6452: end if;

Line 6449: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
6452: end if;
6453:

Line 6456: FND_MSG_PUB.Add;

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;
6460:

Line 6457: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6460:
6461: /* quering for last loan amortization record */

Line 6525: FND_MSG_PUB.Add;

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:
6529: end if;

Line 6526: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
6529: end if;
6530:

Line 6545: FND_MSG_PUB.Count_And_Get(

6541: -- END OF BODY OF API
6542: x_return_status := FND_API.G_RET_STS_SUCCESS;
6543:
6544: -- Standard call to get message count and if count is 1, get message info
6545: FND_MSG_PUB.Count_And_Get(
6546: p_encoded => FND_API.G_FALSE,
6547: p_count => x_msg_count,
6548: p_data => x_msg_data);
6549:

Line 6556: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6552: EXCEPTION
6553: WHEN FND_API.G_EXC_ERROR THEN
6554: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
6555: x_return_status := FND_API.G_RET_STS_ERROR;
6556: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6557: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6558: g_cr_return_status := 'ERROR';
6559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6560: ROLLBACK TO REVERSE_LAST_AMORTIZATION;

Line 6562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6558: g_cr_return_status := 'ERROR';
6559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6560: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
6561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6563: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6564: g_cr_return_status := 'ERROR';
6565: WHEN OTHERS THEN
6566: ROLLBACK TO REVERSE_LAST_AMORTIZATION;

Line 6568: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

6564: g_cr_return_status := 'ERROR';
6565: WHEN OTHERS THEN
6566: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
6567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6568: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6569: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6570: END IF;
6571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6572: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');

Line 6569: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

6565: WHEN OTHERS THEN
6566: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
6567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6568: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6569: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6570: END IF;
6571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6572: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6573: g_cr_return_status := 'ERROR';

Line 6571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6568: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6569: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6570: END IF;
6571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6572: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6573: g_cr_return_status := 'ERROR';
6574:
6575: END CREDIT_AMORTIZATION_PARTIAL;

Line 6704: FND_MSG_PUB.initialize;

6700: END IF;
6701:
6702: -- Initialize message list if p_init_msg_list is set to TRUE
6703: IF FND_API.To_Boolean(p_init_msg_list) THEN
6704: FND_MSG_PUB.initialize;
6705: END IF;
6706:
6707: -- Initialize API return status to success
6708: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6724: FND_MSG_PUB.Add;

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;
6728:

Line 6725: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6728:
6729: if P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM is null then

Line 6732: FND_MSG_PUB.Add;

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;
6736:

Line 6733: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6736:
6737: if P_BILL_HEADER_REC.DUE_DATE is null then

Line 6740: FND_MSG_PUB.Add;

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;
6744:

Line 6741: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6744:
6745: if l_lines_tbl.count = 0 then

Line 6749: FND_MSG_PUB.Add;

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;
6753:

Line 6750: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6753:
6754: /* init amounts */

Line 6779: FND_MSG_PUB.Add;

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;
6783:

Line 6780: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6783:
6784: if l_lines_tbl(l_Count).LINE_TYPE is null then

Line 6788: FND_MSG_PUB.Add;

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;
6792: /*

Line 6789: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6792: /*
6793: if l_lines_tbl(l_Count).LINE_DESC is null then

Line 6843: FND_MSG_PUB.Add;

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;
6847:

Line 6844: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6847:
6848: close loan_cur;

Line 6929: FND_MSG_PUB.Add;

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;
6933:

Line 6930: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
6933:
6934: else

Line 6965: FND_MSG_PUB.Count_And_Get(

6961: -- END OF BODY OF API
6962: x_return_status := FND_API.G_RET_STS_SUCCESS;
6963:
6964: -- Standard call to get message count and if count is 1, get message info
6965: FND_MSG_PUB.Count_And_Get(
6966: p_encoded => FND_API.G_FALSE,
6967: p_count => x_msg_count,
6968: p_data => x_msg_data);
6969:

Line 6976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6972: EXCEPTION
6973: WHEN FND_API.G_EXC_ERROR THEN
6974: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6975: x_return_status := FND_API.G_RET_STS_ERROR;
6976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6977: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6979: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6981: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6977: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6979: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6981: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6982: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6983: WHEN OTHERS THEN
6984: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6986: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

6982: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6983: WHEN OTHERS THEN
6984: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6986: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6988: END IF;
6989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6990: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 6987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

6983: WHEN OTHERS THEN
6984: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6986: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6988: END IF;
6989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6990: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6991: END;

Line 6989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

6985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6986: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6987: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6988: END IF;
6989: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6990: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6991: END;
6992:
6993:

Line 7072: FND_MSG_PUB.initialize;

7068: END IF;
7069:
7070: -- Initialize message list if p_init_msg_list is set to TRUE
7071: IF FND_API.To_Boolean(p_init_msg_list) THEN
7072: FND_MSG_PUB.initialize;
7073: END IF;
7074:
7075: -- Initialize API return status to success
7076: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7087: FND_MSG_PUB.Add;

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;
7091:

Line 7088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
7091:
7092: /* Init lines table */

Line 7103: FND_MSG_PUB.Add;

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;
7107:

Line 7104: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
7107:
7108: /* Adding current line record to lines table of current header */

Line 7146: FND_MSG_PUB.Count_And_Get(

7142: -- END OF BODY OF API
7143: x_return_status := FND_API.G_RET_STS_SUCCESS;
7144:
7145: -- Standard call to get message count and if count is 1, get message info
7146: FND_MSG_PUB.Count_And_Get(
7147: p_encoded => FND_API.G_FALSE,
7148: p_count => x_msg_count,
7149: p_data => x_msg_data);
7150:

Line 7157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7153: EXCEPTION
7154: WHEN FND_API.G_EXC_ERROR THEN
7155: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
7156: x_return_status := FND_API.G_RET_STS_ERROR;
7157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7158: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
7159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7160: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
7161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7162: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7158: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
7159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7160: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
7161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7162: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
7164: WHEN OTHERS THEN
7165: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
7166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

7163: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
7164: WHEN OTHERS THEN
7165: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
7166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7168: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7169: END IF;
7170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7171: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');

Line 7168: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

7164: WHEN OTHERS THEN
7165: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
7166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7168: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7169: END IF;
7170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7171: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
7172: END;

Line 7170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7168: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7169: END IF;
7170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7171: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
7172: END;
7173:
7174:

Line 7300: FND_MSG_PUB.initialize;

7296: END IF;
7297:
7298: -- Initialize message list if p_init_msg_list is set to TRUE
7299: IF FND_API.To_Boolean(p_init_msg_list) THEN
7300: FND_MSG_PUB.initialize;
7301: END IF;
7302:
7303: -- Initialize API return status to success
7304: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7316: FND_MSG_PUB.Add;

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;
7320:

Line 7317: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
7320:
7321: /* verify is it really offcycle bill, reversed etc. */

Line 7336: FND_MSG_PUB.Add;

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:
7340: else

Line 7337: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
7340: else
7341:

Line 7352: FND_MSG_PUB.Add;

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:
7356: elsif l_REVERSED_FLAG = 'Y' then

Line 7353: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
7356: elsif l_REVERSED_FLAG = 'Y' then
7357:

Line 7360: FND_MSG_PUB.Add;

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:
7364: end if;

Line 7361: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
7364: end if;
7365:

Line 7407: FND_MSG_PUB.Add;

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:
7411: end if;

Line 7408: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
7411: end if;
7412:

Line 7448: FND_MSG_PUB.Count_And_Get(

7444: -- END OF BODY OF API
7445: x_return_status := FND_API.G_RET_STS_SUCCESS;
7446:
7447: -- Standard call to get message count and if count is 1, get message info
7448: FND_MSG_PUB.Count_And_Get(
7449: p_encoded => FND_API.G_FALSE,
7450: p_count => x_msg_count,
7451: p_data => x_msg_data);
7452:

Line 7459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7455: EXCEPTION
7456: WHEN FND_API.G_EXC_ERROR THEN
7457: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
7458: x_return_status := FND_API.G_RET_STS_ERROR;
7459: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7462: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
7463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7464: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7460: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7462: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
7463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7464: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7465: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7466: WHEN OTHERS THEN
7467: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
7468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

7465: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7466: WHEN OTHERS THEN
7467: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
7468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7470: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7471: END IF;
7472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 7470: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

7466: WHEN OTHERS THEN
7467: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
7468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7470: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7471: END IF;
7472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7474: END;

Line 7472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7469: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7470: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7471: END IF;
7472: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7473: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7474: END;
7475:
7476:

Line 7621: FND_MSG_PUB.initialize;

7617: END IF;
7618:
7619: -- Initialize message list if p_init_msg_list is set to TRUE
7620: IF FND_API.To_Boolean(p_init_msg_list) THEN
7621: FND_MSG_PUB.initialize;
7622: END IF;
7623:
7624: -- Initialize API return status to success
7625: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7638: FND_MSG_PUB.Add;

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:
7642: end if;

Line 7639: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
7642: end if;
7643:

Line 7648: FND_MSG_PUB.Add;

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:
7652: end if;

Line 7649: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
7652: end if;
7653:

Line 7664: FND_MSG_PUB.Add;

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:
7668: end if;

Line 7665: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
7668: end if;
7669:

Line 7711: FND_MSG_PUB.Add;

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
7715: l_type := 'LINE';

Line 7712: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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
7715: l_type := 'LINE';
7716: end if;

Line 7726: FND_MSG_PUB.Add;

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;
7730:

Line 7727: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
7730:
7731: /* buld comments */

Line 7801: FND_MSG_PUB.Add;

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;
7805:

Line 7802: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
7805:
7806: if P_COMMIT = FND_API.G_TRUE then

Line 7817: FND_MSG_PUB.Count_And_Get(

7813: -- END OF BODY OF API
7814: x_return_status := FND_API.G_RET_STS_SUCCESS;
7815:
7816: -- Standard call to get message count and if count is 1, get message info
7817: FND_MSG_PUB.Count_And_Get(
7818: p_encoded => FND_API.G_FALSE,
7819: p_count => x_msg_count,
7820: p_data => x_msg_data);
7821:

Line 7828: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7824: EXCEPTION
7825: WHEN FND_API.G_EXC_ERROR THEN
7826: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7827: x_return_status := FND_API.G_RET_STS_ERROR;
7828: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7829: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7831: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7833: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7829: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7831: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7833: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7834: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7835: WHEN OTHERS THEN
7836: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

7834: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7835: WHEN OTHERS THEN
7836: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7840: END IF;
7841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7842: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 7839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

7835: WHEN OTHERS THEN
7836: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7840: END IF;
7841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7842: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7843: END;

Line 7841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

7837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7838: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7840: END IF;
7841: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7842: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7843: END;
7844:
7845:

Line 7944: FND_MSG_PUB.initialize;

7940: END IF;
7941:
7942: -- Initialize message list if p_init_msg_list is set to TRUE
7943: IF FND_API.To_Boolean(p_init_msg_list) THEN
7944: FND_MSG_PUB.initialize;
7945: END IF;
7946:
7947: -- Initialize API return status to success
7948: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7958: FND_MSG_PUB.Add;

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:
7962: end if;

Line 7959: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
7962: end if;
7963:

Line 8090: FND_MSG_PUB.Add;

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:
8094: end if;

Line 8091: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
8094: end if;
8095:

Line 8141: FND_MSG_PUB.Count_And_Get(

8137: x_return_status := FND_API.G_RET_STS_SUCCESS;
8138: X_BILLED_YN := 'Y';
8139:
8140: -- Standard call to get message count and if count is 1, get message info
8141: FND_MSG_PUB.Count_And_Get(
8142: p_encoded => FND_API.G_FALSE,
8143: p_count => x_msg_count,
8144: p_data => x_msg_data);
8145:

Line 8152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8148: EXCEPTION
8149: WHEN FND_API.G_EXC_ERROR THEN
8150: ROLLBACK TO PREBILL_SINGLE_LOAN;
8151: x_return_status := FND_API.G_RET_STS_ERROR;
8152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8153: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8155: ROLLBACK TO PREBILL_SINGLE_LOAN;
8156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8153: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8155: ROLLBACK TO PREBILL_SINGLE_LOAN;
8156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8157: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8158: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8159: WHEN OTHERS THEN
8160: ROLLBACK TO PREBILL_SINGLE_LOAN;
8161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

8158: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8159: WHEN OTHERS THEN
8160: ROLLBACK TO PREBILL_SINGLE_LOAN;
8161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8163: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8164: END IF;
8165: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 8163: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

8159: WHEN OTHERS THEN
8160: ROLLBACK TO PREBILL_SINGLE_LOAN;
8161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8163: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8164: END IF;
8165: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8167: END;

Line 8165: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8163: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8164: END IF;
8165: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8166: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8167: END;
8168:
8169:

Line 8247: FND_MSG_PUB.Add;

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:
8251: end if;

Line 8248: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
8251: end if;
8252: if P_AMOUNT is null then

Line 8432: FND_MSG_PUB.initialize;

8428: END IF;
8429:
8430: -- Initialize message list if p_init_msg_list is set to TRUE
8431: IF FND_API.To_Boolean(p_init_msg_list) THEN
8432: FND_MSG_PUB.initialize;
8433: END IF;
8434:
8435: -- Initialize API return status to success
8436: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 8446: FND_MSG_PUB.Add;

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:
8450: end if;

Line 8447: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
8450: end if;
8451:

Line 8573: FND_MSG_PUB.Count_And_Get(

8569: -- END OF BODY OF API
8570: x_return_status := FND_API.G_RET_STS_SUCCESS;
8571:
8572: -- Standard call to get message count and if count is 1, get message info
8573: FND_MSG_PUB.Count_And_Get(
8574: p_encoded => FND_API.G_FALSE,
8575: p_count => x_msg_count,
8576: p_data => x_msg_data);
8577:

Line 8584: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8580: EXCEPTION
8581: WHEN FND_API.G_EXC_ERROR THEN
8582: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
8583: x_return_status := FND_API.G_RET_STS_ERROR;
8584: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8585: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8587: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
8588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8589: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8585: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8587: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
8588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8589: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8590: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8591: WHEN OTHERS THEN
8592: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
8593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8594: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

8590: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8591: WHEN OTHERS THEN
8592: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
8593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8594: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8595: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8596: END IF;
8597: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8598: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 8595: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

8591: WHEN OTHERS THEN
8592: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
8593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8594: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8595: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8596: END IF;
8597: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8598: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8599: END;

Line 8597: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8594: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8595: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8596: END IF;
8597: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8598: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8599: END;
8600:
8601:

Line 8713: FND_MSG_PUB.initialize;

8709: END IF;
8710:
8711: -- Initialize message list if p_init_msg_list is set to TRUE
8712: IF FND_API.To_Boolean(p_init_msg_list) THEN
8713: FND_MSG_PUB.initialize;
8714: END IF;
8715:
8716: -- Initialize API return status to success
8717: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 8729: FND_MSG_PUB.Add;

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:
8733: end if;

Line 8730: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
8733: end if;
8734:

Line 8738: FND_MSG_PUB.Add;

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;
8742:

Line 8739: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
8742:
8743: -- Bug#6830765 - Added new procedure ..EXT_1, which returns '0' if 0th installment is scheduled and it solves

Line 8789: FND_MSG_PUB.initialize;

8785: RAISE FND_API.G_EXC_ERROR;
8786: end if;
8787:
8788: -- remove any msg from the stack
8789: FND_MSG_PUB.initialize;
8790:
8791: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Data returned:');
8792: LogMessage(FND_LOG.LEVEL_STATEMENT, 'INSTALLMENT_NUMBER: ' || l_amortization_rec.INSTALLMENT_NUMBER);
8793: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || l_amortization_rec.due_date);

Line 8805: FND_MSG_PUB.Add;

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:
8809: end if;

Line 8806: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
8809: end if;
8810:

Line 8831: FND_MSG_PUB.Add;

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;
8835: end if;

Line 8832: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
8835: end if;
8836:

Line 8960: FND_MSG_PUB.Count_And_Get(

8956: -- END OF BODY OF API
8957: x_return_status := FND_API.G_RET_STS_SUCCESS;
8958:
8959: -- Standard call to get message count and if count is 1, get message info
8960: FND_MSG_PUB.Count_And_Get(
8961: p_encoded => FND_API.G_FALSE,
8962: p_count => x_msg_count,
8963: p_data => x_msg_data);
8964:

Line 8971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8967: EXCEPTION
8968: WHEN FND_API.G_EXC_ERROR THEN
8969: ROLLBACK TO GET_NEXT_INSTAL_TO_BILL;
8970: x_return_status := FND_API.G_RET_STS_ERROR;
8971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8972: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8974: ROLLBACK TO GET_NEXT_INSTAL_TO_BILL;
8975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8972: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8974: ROLLBACK TO GET_NEXT_INSTAL_TO_BILL;
8975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8976: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8977: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8978: WHEN OTHERS THEN
8979: ROLLBACK TO GET_NEXT_INSTAL_TO_BILL;
8980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8981: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

8977: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8978: WHEN OTHERS THEN
8979: ROLLBACK TO GET_NEXT_INSTAL_TO_BILL;
8980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8981: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8982: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8983: END IF;
8984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8985: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 8982: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

8978: WHEN OTHERS THEN
8979: ROLLBACK TO GET_NEXT_INSTAL_TO_BILL;
8980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8981: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8982: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8983: END IF;
8984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8985: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8986: END;

Line 8984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

8980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8981: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
8982: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
8983: END IF;
8984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
8985: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
8986: END;
8987:
8988:

Line 9105: FND_MSG_PUB.initialize;

9101: END IF;
9102:
9103: -- Initialize message list if p_init_msg_list is set to TRUE
9104: IF FND_API.To_Boolean(p_init_msg_list) THEN
9105: FND_MSG_PUB.initialize;
9106: END IF;
9107:
9108: -- Initialize API return status to success
9109: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 9119: FND_MSG_PUB.Add;

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;
9123:

Line 9120: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
9123:
9124: l_Count1 := 1;

Line 9229: FND_MSG_PUB.Count_And_Get(

9225: -- END OF BODY OF API
9226: x_return_status := FND_API.G_RET_STS_SUCCESS;
9227:
9228: -- Standard call to get message count and if count is 1, get message info
9229: FND_MSG_PUB.Count_And_Get(
9230: p_encoded => FND_API.G_FALSE,
9231: p_count => x_msg_count,
9232: p_data => x_msg_data);
9233:

Line 9240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

9236: EXCEPTION
9237: WHEN FND_API.G_EXC_ERROR THEN
9238: ROLLBACK TO BILL_AND_PAY_NEXT_INSTAL;
9239: x_return_status := FND_API.G_RET_STS_ERROR;
9240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9241: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9243: ROLLBACK TO BILL_AND_PAY_NEXT_INSTAL;
9244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9245: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

9241: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9243: ROLLBACK TO BILL_AND_PAY_NEXT_INSTAL;
9244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9245: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9246: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9247: WHEN OTHERS THEN
9248: ROLLBACK TO BILL_AND_PAY_NEXT_INSTAL;
9249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

9246: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9247: WHEN OTHERS THEN
9248: ROLLBACK TO BILL_AND_PAY_NEXT_INSTAL;
9249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
9251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9252: END IF;
9253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9254: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 9251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

9247: WHEN OTHERS THEN
9248: ROLLBACK TO BILL_AND_PAY_NEXT_INSTAL;
9249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
9251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9252: END IF;
9253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9254: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9255: END;

Line 9253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

9249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
9251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9252: END IF;
9253: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9254: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9255: END;
9256:
9257:

Line 9405: FND_MSG_PUB.initialize;

9401: END IF;
9402:
9403: -- Initialize message list if p_init_msg_list is set to TRUE
9404: IF FND_API.To_Boolean(p_init_msg_list) THEN
9405: FND_MSG_PUB.initialize;
9406: END IF;
9407:
9408: -- Initialize API return status to success
9409: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 9662: l_error := FND_MSG_PUB.Get(p_encoded => 'F');

9658: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
9659: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_data: ' || l_msg_data);
9660:
9661: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9662: l_error := FND_MSG_PUB.Get(p_encoded => 'F');
9663: END IF;
9664:
9665: EXCEPTION
9666: WHEN OTHERS THEN

Line 9679: FND_MSG_PUB.Add;

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;
9683: END IF;

Line 9680: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
9683: END IF;
9684:

Line 9734: FND_MSG_PUB.Count_And_Get(

9730: -- END OF BODY OF API
9731: x_return_status := FND_API.G_RET_STS_SUCCESS;
9732:
9733: -- Standard call to get message count and if count is 1, get message info
9734: FND_MSG_PUB.Count_And_Get(
9735: p_encoded => FND_API.G_FALSE,
9736: p_count => x_msg_count,
9737: p_data => x_msg_data);
9738:

Line 9745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

9741: EXCEPTION
9742: WHEN FND_API.G_EXC_ERROR THEN
9743: ROLLBACK TO PAY_INSTALLMENTS;
9744: x_return_status := FND_API.G_RET_STS_ERROR;
9745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9746: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9748: ROLLBACK TO PAY_INSTALLMENTS;
9749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

9746: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9748: ROLLBACK TO PAY_INSTALLMENTS;
9749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9750: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9751: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9752: WHEN OTHERS THEN
9753: ROLLBACK TO PAY_INSTALLMENTS;
9754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

9751: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9752: WHEN OTHERS THEN
9753: ROLLBACK TO PAY_INSTALLMENTS;
9754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
9756: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9757: END IF;
9758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9759: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 9756: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

9752: WHEN OTHERS THEN
9753: ROLLBACK TO PAY_INSTALLMENTS;
9754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
9756: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9757: END IF;
9758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9759: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9760: END;

Line 9758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

9754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9755: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
9756: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9757: END IF;
9758: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
9759: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
9760: END;
9761:
9762:

Line 9856: FND_MSG_PUB.Add;

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:
9860: end if;

Line 9857: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
9860: end if;
9861:

Line 9903: FND_MSG_PUB.Add;

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;
9907:

Line 9904: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
9907:
9908: end if;

Line 10042: FND_MSG_PUB.initialize;

10038: END IF;
10039:
10040: -- Initialize message list if p_init_msg_list is set to TRUE
10041: IF FND_API.To_Boolean(p_init_msg_list) THEN
10042: FND_MSG_PUB.initialize;
10043: END IF;
10044:
10045: -- Initialize API return status to success
10046: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 10060: FND_MSG_PUB.Add;

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:
10064: end if;

Line 10061: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
10064: end if;
10065:

Line 10106: FND_MSG_PUB.Count_And_Get(

10102: -- END OF BODY OF API
10103: x_return_status := FND_API.G_RET_STS_SUCCESS;
10104:
10105: -- Standard call to get message count and if count is 1, get message info
10106: FND_MSG_PUB.Count_And_Get(
10107: p_encoded => FND_API.G_FALSE,
10108: p_count => x_msg_count,
10109: p_data => x_msg_data);
10110:

Line 10117: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10113: EXCEPTION
10114: WHEN FND_API.G_EXC_ERROR THEN
10115: ROLLBACK TO GET_BILLED_INSTALLMENT;
10116: x_return_status := FND_API.G_RET_STS_ERROR;
10117: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10120: ROLLBACK TO GET_BILLED_INSTALLMENT;
10121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10122: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10120: ROLLBACK TO GET_BILLED_INSTALLMENT;
10121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10122: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10123: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10124: WHEN OTHERS THEN
10125: ROLLBACK TO GET_BILLED_INSTALLMENT;
10126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

10123: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10124: WHEN OTHERS THEN
10125: ROLLBACK TO GET_BILLED_INSTALLMENT;
10126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10128: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10129: END IF;
10130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10131: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 10128: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

10124: WHEN OTHERS THEN
10125: ROLLBACK TO GET_BILLED_INSTALLMENT;
10126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10128: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10129: END IF;
10130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10131: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10132: END;

Line 10130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10128: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10129: END IF;
10130: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10131: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10132: END;
10133:
10134:

Line 10231: FND_MSG_PUB.initialize;

10227: END IF;
10228:
10229: -- Initialize message list if p_init_msg_list is set to TRUE
10230: IF FND_API.To_Boolean(p_init_msg_list) THEN
10231: FND_MSG_PUB.initialize;
10232: END IF;
10233:
10234: -- Initialize API return status to success
10235: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 10248: FND_MSG_PUB.Add;

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:
10252: end if;

Line 10249: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
10252: end if;
10253:

Line 10327: FND_MSG_PUB.Count_And_Get(

10323: -- END OF BODY OF API
10324: x_return_status := FND_API.G_RET_STS_SUCCESS;
10325:
10326: -- Standard call to get message count and if count is 1, get message info
10327: FND_MSG_PUB.Count_And_Get(
10328: p_encoded => FND_API.G_FALSE,
10329: p_count => x_msg_count,
10330: p_data => x_msg_data);
10331:

Line 10338: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10334: EXCEPTION
10335: WHEN FND_API.G_EXC_ERROR THEN
10336: ROLLBACK TO BILL_AND_PAY_OFFCYCLE_BILLS;
10337: x_return_status := FND_API.G_RET_STS_ERROR;
10338: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10339: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10341: ROLLBACK TO BILL_AND_PAY_OFFCYCLE_BILLS;
10342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10343: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10339: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10341: ROLLBACK TO BILL_AND_PAY_OFFCYCLE_BILLS;
10342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10343: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10344: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10345: WHEN OTHERS THEN
10346: ROLLBACK TO BILL_AND_PAY_OFFCYCLE_BILLS;
10347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

10344: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10345: WHEN OTHERS THEN
10346: ROLLBACK TO BILL_AND_PAY_OFFCYCLE_BILLS;
10347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10350: END IF;
10351: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 10349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

10345: WHEN OTHERS THEN
10346: ROLLBACK TO BILL_AND_PAY_OFFCYCLE_BILLS;
10347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10350: END IF;
10351: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10353: END;

Line 10351: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10350: END IF;
10351: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10353: END;
10354:
10355:

Line 10461: FND_MSG_PUB.initialize;

10457: END IF;
10458:
10459: -- Initialize message list if p_init_msg_list is set to TRUE
10460: IF FND_API.To_Boolean(p_init_msg_list) THEN
10461: FND_MSG_PUB.initialize;
10462: END IF;
10463:
10464: -- Initialize API return status to success
10465: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10475: FND_MSG_PUB.Add;

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;
10479:

Line 10476: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
10479:
10480: /* getting loan_number */

Line 10553: FND_MSG_PUB.ADD;

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:
10557: logMessage(FND_LOG.LEVEL_PROCEDURE, 'Calling lns_fee_engine.getFeeSchedule...');

Line 10573: FND_MSG_PUB.ADD;

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:
10577: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Toal No. of UnBilled SubmitApproval Fees are: ' || l_fee_tbl.count);

Line 10660: FND_MSG_PUB.Count_And_Get(

10656: x_return_status := FND_API.G_RET_STS_SUCCESS;
10657: X_BILLED_YN := 'Y';
10658:
10659: -- Standard call to get message count and if count is 1, get message info
10660: FND_MSG_PUB.Count_And_Get(
10661: p_encoded => FND_API.G_FALSE,
10662: p_count => x_msg_count,
10663: p_data => x_msg_data);
10664:

Line 10671: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10667: EXCEPTION
10668: WHEN FND_API.G_EXC_ERROR THEN
10669: ROLLBACK TO BILL_SING_LOAN_SUBMIT_APPR_FEE;
10670: x_return_status := FND_API.G_RET_STS_ERROR;
10671: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10672: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10674: ROLLBACK TO BILL_SING_LOAN_SUBMIT_APPR_FEE;
10675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10676: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10672: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10674: ROLLBACK TO BILL_SING_LOAN_SUBMIT_APPR_FEE;
10675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10676: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10677: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10678: WHEN OTHERS THEN
10679: ROLLBACK TO BILL_SING_LOAN_SUBMIT_APPR_FEE;
10680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 10681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

10677: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10678: WHEN OTHERS THEN
10679: ROLLBACK TO BILL_SING_LOAN_SUBMIT_APPR_FEE;
10680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10682: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10683: END IF;
10684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10685: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 10682: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

10678: WHEN OTHERS THEN
10679: ROLLBACK TO BILL_SING_LOAN_SUBMIT_APPR_FEE;
10680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10682: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10683: END IF;
10684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10685: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10686: END;

Line 10684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

10680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10681: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
10682: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10683: END IF;
10684: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
10685: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
10686: END;
10687:
10688: PROCEDURE REVERSE_BILLED_FEES(p_amortization_id IN NUMBER)

Line 10714: FND_MSG_PUB.Add;

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;
10718:

Line 10715: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
10718:
10719:

Line 10814: FND_MSG_PUB.Add;

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:
10818: end if;

Line 10815: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
10818: end if;
10819:

Line 10967: FND_MSG_PUB.initialize;

10963: END IF;
10964:
10965: -- Initialize message list if p_init_msg_list is set to TRUE
10966: IF FND_API.To_Boolean(p_init_msg_list) THEN
10967: FND_MSG_PUB.initialize;
10968: END IF;
10969:
10970: -- Initialize API return status to success
10971: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10984: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
10988:

Line 10993: FND_MSG_PUB.Add;

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:
10997: end if;

Line 10994: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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:
10997: end if;
10998:

Line 11021: FND_MSG_PUB.Add;

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;
11025:

Line 11022: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
11025:
11026: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Adjusting additional receivable ' || l_trx_number || 'for loan ' || l_loan_number || '...');

Line 11034: FND_MSG_PUB.Add;

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
11038: l_type := 'LINE';

Line 11035: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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
11038: l_type := 'LINE';
11039: end if;

Line 11049: FND_MSG_PUB.Add;

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;
11053:

Line 11050: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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;
11053:
11054: /* buld comments */

Line 11105: FND_MSG_PUB.Count_And_Get(

11101: -- END OF BODY OF API
11102: x_return_status := FND_API.G_RET_STS_SUCCESS;
11103:
11104: -- Standard call to get message count and if count is 1, get message info
11105: FND_MSG_PUB.Count_And_Get(
11106: p_encoded => FND_API.G_FALSE,
11107: p_count => x_msg_count,
11108: p_data => x_msg_data);
11109:

Line 11116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

11112: EXCEPTION
11113: WHEN FND_API.G_EXC_ERROR THEN
11114: ROLLBACK TO ADJUST_ADD_RECEIVABLE;
11115: x_return_status := FND_API.G_RET_STS_ERROR;
11116: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
11117: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
11118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11119: ROLLBACK TO ADJUST_ADD_RECEIVABLE;
11120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

11117: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
11118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11119: ROLLBACK TO ADJUST_ADD_RECEIVABLE;
11120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11121: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
11122: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
11123: WHEN OTHERS THEN
11124: ROLLBACK TO ADJUST_ADD_RECEIVABLE;
11125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 11126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

11122: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
11123: WHEN OTHERS THEN
11124: ROLLBACK TO ADJUST_ADD_RECEIVABLE;
11125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
11127: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
11128: END IF;
11129: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
11130: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 11127: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

11123: WHEN OTHERS THEN
11124: ROLLBACK TO ADJUST_ADD_RECEIVABLE;
11125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
11127: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
11128: END IF;
11129: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
11130: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
11131: END;

Line 11129: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

11125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
11127: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
11128: END IF;
11129: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
11130: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
11131: END;
11132:
11133: