eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_BILLING_BATCH_PUB dependencies on FND_MSG_PUB

Line 169: FND_MSG_PUB.Add;

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

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

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

Line 178: FND_MSG_PUB.Add;

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

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

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

Line 224: FND_MSG_PUB.Add;

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

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

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

Line 234: FND_MSG_PUB.Add;

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

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

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

Line 244: FND_MSG_PUB.Add;

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

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

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

Line 413: FND_MSG_PUB.Add;

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

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

410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
411: ELSE
412: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
413: FND_MSG_PUB.Add;
414: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417:
418: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 531: FND_MSG_PUB.initialize;

527: SAVEPOINT PROCESS_PAID_LOANS;
528:
529: -- Initialize message list IF p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean(p_init_msg_list) THEN
531: FND_MSG_PUB.initialize;
532: END IF;
533:
534: -- Initialize API return status to SUCCESS
535: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 618: FND_MSG_PUB.Add;

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

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

615: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
616: ELSE
617: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
618: FND_MSG_PUB.Add;
619: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
620: RAISE FND_API.G_EXC_ERROR;
621: END IF;
622:
623: if P_COMMIT = FND_API.G_TRUE then

Line 791: FND_MSG_PUB.Add;

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

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

788: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_HEADERS_ALL');
789: ELSE
790: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
791: FND_MSG_PUB.Add;
792: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
793: RAISE FND_API.G_EXC_ERROR;
794: END IF;
795:
796: if P_COMMIT = FND_API.G_TRUE then

Line 1438: FND_MSG_PUB.Add;

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

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

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

Line 1505: FND_MSG_PUB.Add;

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

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

1502:
1503: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Fee transaction type is not set.');
1504: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_FEE_TRX_TYPE_IN_SYS_OPT');
1505: FND_MSG_PUB.Add;
1506: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1507: RAISE FND_API.G_EXC_ERROR;
1508:
1509: end if;
1510:

Line 1897: FND_MSG_PUB.Add;

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

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

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

Line 2019: FND_MSG_PUB.Add;

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

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

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

Line 2028: FND_MSG_PUB.Add;

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

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

2025: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2026: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2027: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2028: FND_MSG_PUB.Add;
2029: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2030:
2031: END LOOP;
2032:
2033: close ar_invoice_err_cur;

Line 2057: FND_MSG_PUB.Add;

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

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

2054: l_ar_error_counter := 1;
2055: FND_MESSAGE.SET_NAME('LNS', 'LNS_CR_INV_FAIL');
2056: FND_MESSAGE.SET_TOKEN('MSG', l_msg_data);
2057: FND_MSG_PUB.Add;
2058: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2059:
2060: END IF;
2061:
2062: /* query AR errors */

Line 2080: FND_MSG_PUB.Add;

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

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

2077: FND_MESSAGE.SET_TOKEN('VALUE', l_invalid_value);
2078: FND_MESSAGE.SET_TOKEN('HEADER', l_trx_header_id);
2079: FND_MESSAGE.SET_TOKEN('LINE', l_trx_line_id);
2080: FND_MSG_PUB.Add;
2081: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
2082:
2083: END LOOP;
2084:
2085: close ar_invoice_err_cur;

Line 2184: FND_MSG_PUB.Add;

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

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

2181: if l_Count2 = 0 then
2182: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No AR invoices fetched');
2183: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_INV_FETCHED');
2184: FND_MSG_PUB.Add;
2185: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2186: RAISE FND_API.G_EXC_ERROR;
2187: end if;
2188:
2189: /* Update interest and fee trxs with principal_trx_id as RELATED_CUSTOMER_TRX_ID */

Line 2199: FND_MSG_PUB.Add;

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

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

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

Line 2213: FND_MSG_PUB.Add;

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

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

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

Line 2331: FND_MSG_PUB.Add;

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

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

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

Line 2367: FND_MSG_PUB.Add;

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

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

2364:
2365: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No AR transactions found to reverse.');
2366: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_REVERSE');
2367: FND_MSG_PUB.Add;
2368: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2369: RAISE FND_API.G_EXC_ERROR;
2370:
2371: end if;
2372:

Line 2382: FND_MSG_PUB.Add;

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

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

2379:
2380: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_CM_BATCH');
2381: FND_MESSAGE.SET_TOKEN('BATCH', l_batch_source_name);
2382: FND_MSG_PUB.Add;
2383: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2384: RAISE FND_API.G_EXC_ERROR;
2385:
2386: end if;
2387:

Line 2460: FND_MSG_PUB.Add;

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

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

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

Line 2555: FND_MSG_PUB.Add;

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

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

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

Line 2563: FND_MSG_PUB.Add;

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

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

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

Line 2571: FND_MSG_PUB.Add;

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

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

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

Line 2579: FND_MSG_PUB.Add;

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

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

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

Line 2592: FND_MSG_PUB.Add;

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

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

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

Line 2602: FND_MSG_PUB.Add;

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

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

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

Line 2628: FND_MSG_PUB.Add;

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

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

2625:
2626: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: AR_RECEIPT_API_PUB.APPLY raised error: ' || substr(l_msg_data,1,225));
2627: FND_MESSAGE.SET_NAME('LNS', 'LNS_APPL_CR_FAIL');
2628: FND_MSG_PUB.Add;
2629: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
2630: RAISE FND_API.G_EXC_ERROR;
2631:
2632: ELSE
2633: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully applied cash receipt to trx ' || P_TRX_ID || ' line ' || P_TRX_LINE_ID);

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

2779:
2780: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2781:
2782: while (l_indexNo <= l_msg_Count ) loop
2783: fnd_msg_pub.get(l_indexNo, 'F', l_msg, l_index);
2784: LogMessage(FND_LOG.LEVEL_ERROR, 'Error: ' || l_msg);
2785: l_indexNo := l_indexNo + 1;
2786: End Loop;
2787:

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

2908: l_statement := l_statement || l_new_line || '' || l_currency || '';
2909:
2910: l_statement := l_statement || l_new_line || '' || l_new_line;
2911: while (l_indexNo <= P_ERR_COUNT ) loop
2912: fnd_msg_pub.get(l_indexNo, 'F', l_error, l_index);
2913: l_error := REPLACE(l_error, '&', '');
2914: l_statement := l_statement || l_error;
2915: l_indexNo := l_indexNo + 1;
2916: End Loop;

Line 3466: FND_MSG_PUB.Add;

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

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

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

Line 3601: FND_MSG_PUB.initialize;

3597: END IF;
3598:
3599: -- Initialize message list if p_init_msg_list is set to TRUE
3600: IF FND_API.To_Boolean(p_init_msg_list) THEN
3601: FND_MSG_PUB.initialize;
3602: END IF;
3603:
3604: -- Initialize API return status to success
3605: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3642: FND_MSG_PUB.Add;

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

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

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

Line 3779: FND_MSG_PUB.Add;

3775: return;
3776:
3777: /*
3778: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_AMOUNT_INST');
3779: FND_MSG_PUB.Add;
3780: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3781: RAISE FND_API.G_EXC_ERROR;
3782: */
3783: end if;

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

3776:
3777: /*
3778: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_AMOUNT_INST');
3779: FND_MSG_PUB.Add;
3780: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
3781: RAISE FND_API.G_EXC_ERROR;
3782: */
3783: end if;
3784:

Line 3900: FND_MSG_PUB.Add;

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

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

3897: if l_amortization_rec.INSTALLMENT_NUMBER <> l_fee_tbl(l_Count).FEE_INSTALLMENT then
3898:
3899: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_INSTAL');
3900: FND_MSG_PUB.Add;
3901: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3902: RAISE FND_API.G_EXC_ERROR;
3903:
3904: end if;
3905:

Line 3994: FND_MSG_PUB.Add;

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

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

3991: ELSE
3992: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
3993: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3994: FND_MSG_PUB.Add;
3995: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
3996: RAISE FND_API.G_EXC_ERROR;
3997: END IF;
3998:
3999: STORE_LAST_PAYMENT_NUMBER(P_LOAN_REC.LOAN_ID);

Line 4040: FND_MSG_PUB.Count_And_Get(

4036: -- END OF BODY OF API
4037: x_return_status := FND_API.G_RET_STS_SUCCESS;
4038:
4039: -- Standard call to get message count and if count is 1, get message info
4040: FND_MSG_PUB.Count_And_Get(
4041: p_encoded => FND_API.G_FALSE,
4042: p_count => x_msg_count,
4043: p_data => x_msg_data);
4044:

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

4048: EXCEPTION
4049: WHEN FND_API.G_EXC_ERROR THEN
4050: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
4051: x_return_status := FND_API.G_RET_STS_ERROR;
4052: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4053: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);
4054: g_cr_return_status := 'WARNING';
4055:
4056: /* building error statement */

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

4065:
4066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4067: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
4068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4070: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);
4071: g_cr_return_status := 'WARNING';
4072:
4073: /* building error statement */

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

4082:
4083: WHEN OTHERS THEN
4084: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
4085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4087: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4088: END IF;
4089: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4090: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);

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

4083: WHEN OTHERS THEN
4084: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
4085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4087: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4088: END IF;
4089: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4090: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);
4091: g_cr_return_status := 'WARNING';

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

4085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4087: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4088: END IF;
4089: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4090: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_REC.LOAN_NUMBER);
4091: g_cr_return_status := 'WARNING';
4092:
4093: /* building error statement */

Line 4197: FND_MSG_PUB.initialize;

4193: END IF;
4194:
4195: -- Initialize message list if p_init_msg_list is set to TRUE
4196: IF FND_API.To_Boolean(p_init_msg_list) THEN
4197: FND_MSG_PUB.initialize;
4198: END IF;
4199:
4200: -- Initialize API return status to success
4201: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4256: FND_MSG_PUB.Add;

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

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

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

Line 4283: FND_MSG_PUB.Add;

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

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

4280: ELSE
4281: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4282: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4283: FND_MSG_PUB.Add;
4284: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4285: RAISE FND_API.G_EXC_ERROR;
4286: END IF;
4287:
4288: /* getting terms version for future update */

Line 4321: FND_MSG_PUB.Add;

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

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

4318: ELSE
4319: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
4320: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
4321: FND_MSG_PUB.Add;
4322: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4323: RAISE FND_API.G_EXC_ERROR;
4324: END IF;
4325:
4326: l_end := sysdate;

Line 4338: FND_MSG_PUB.Count_And_Get(

4334: -- END OF BODY OF API
4335: x_return_status := FND_API.G_RET_STS_SUCCESS;
4336:
4337: -- Standard call to get message count and if count is 1, get message info
4338: FND_MSG_PUB.Count_And_Get(
4339: p_encoded => FND_API.G_FALSE,
4340: p_count => x_msg_count,
4341: p_data => x_msg_data);
4342:

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

4346: EXCEPTION
4347: WHEN FND_API.G_EXC_ERROR THEN
4348: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4349: x_return_status := FND_API.G_RET_STS_ERROR;
4350: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4351: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4351: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4355: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4356: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4357: WHEN OTHERS THEN
4358: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4356: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4357: WHEN OTHERS THEN
4358: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4361: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4362: END IF;
4363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4364: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);

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

4357: WHEN OTHERS THEN
4358: ROLLBACK TO SINGLE_LOAN_NEXT_DD_PVT;
4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4361: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4362: END IF;
4363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4364: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4365: END;

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

4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
4361: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4362: END IF;
4363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
4364: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loan ' || P_LOAN_NEXT_DD_REC.LOAN_NUMBER);
4365: END;
4366:
4367:

Line 4783: FND_MSG_PUB.initialize;

4779: END IF;
4780:
4781: -- Initialize message list if p_init_msg_list is set to TRUE
4782: IF FND_API.To_Boolean(p_init_msg_list) THEN
4783: FND_MSG_PUB.initialize;
4784: END IF;
4785:
4786: -- Initialize API return status to success
4787: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4820: FND_MSG_PUB.Add;

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

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

4817: if g_days_to_bill_before_dd is null then
4818: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: At least one of the days must be set.');
4819: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_BILLING_INP_PAR');
4820: FND_MSG_PUB.Add;
4821: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4822: RAISE FND_API.G_EXC_ERROR;
4823: else
4824: l_to_date := g_days_to_bill_before_dd;
4825: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'To Days/Date: ' || l_to_date || GET_BILLING_DATE(l_to_date));

Line 5018: FND_MSG_PUB.Count_And_Get(

5014: -- END OF BODY OF API
5015: x_return_status := FND_API.G_RET_STS_SUCCESS;
5016:
5017: -- Standard call to get message count and if count is 1, get message info
5018: FND_MSG_PUB.Count_And_Get(
5019: p_encoded => FND_API.G_FALSE,
5020: p_count => x_msg_count,
5021: p_data => x_msg_data);
5022:

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

5025: EXCEPTION
5026: WHEN FND_API.G_EXC_ERROR THEN
5027: ROLLBACK TO BILL_LOANS_PVT;
5028: x_return_status := FND_API.G_RET_STS_ERROR;
5029: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5030: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5031: g_cr_return_status := 'ERROR';
5032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5033: ROLLBACK TO BILL_LOANS_PVT;

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

5031: g_cr_return_status := 'ERROR';
5032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5033: ROLLBACK TO BILL_LOANS_PVT;
5034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5035: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5036: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5037: g_cr_return_status := 'ERROR';
5038: WHEN OTHERS THEN
5039: ROLLBACK TO BILL_LOANS_PVT;

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

5037: g_cr_return_status := 'ERROR';
5038: WHEN OTHERS THEN
5039: ROLLBACK TO BILL_LOANS_PVT;
5040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5041: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5042: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5043: END IF;
5044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5045: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');

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

5038: WHEN OTHERS THEN
5039: ROLLBACK TO BILL_LOANS_PVT;
5040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5041: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5042: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5043: END IF;
5044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5045: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5046: g_cr_return_status := 'ERROR';

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

5040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5041: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5042: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5043: END IF;
5044: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5045: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5046: g_cr_return_status := 'ERROR';
5047: END;
5048:

Line 5148: FND_MSG_PUB.initialize;

5144: END IF;
5145:
5146: -- Initialize message list if p_init_msg_list is set to TRUE
5147: IF FND_API.To_Boolean(p_init_msg_list) THEN
5148: FND_MSG_PUB.initialize;
5149: END IF;
5150:
5151: -- Initialize API return status to success
5152: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5207: FND_MSG_PUB.Count_And_Get(

5203: -- END OF BODY OF API
5204: x_return_status := FND_API.G_RET_STS_SUCCESS;
5205:
5206: -- Standard call to get message count and if count is 1, get message info
5207: FND_MSG_PUB.Count_And_Get(
5208: p_encoded => FND_API.G_FALSE,
5209: p_count => x_msg_count,
5210: p_data => x_msg_data);
5211:

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

5214: EXCEPTION
5215: WHEN FND_API.G_EXC_ERROR THEN
5216: ROLLBACK TO LOANS_NEXT_DD_PVT;
5217: x_return_status := FND_API.G_RET_STS_ERROR;
5218: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5219: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5221: ROLLBACK TO LOANS_NEXT_DD_PVT;
5222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5219: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5221: ROLLBACK TO LOANS_NEXT_DD_PVT;
5222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5224: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5225: WHEN OTHERS THEN
5226: ROLLBACK TO LOANS_NEXT_DD_PVT;
5227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5224: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5225: WHEN OTHERS THEN
5226: ROLLBACK TO LOANS_NEXT_DD_PVT;
5227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5229: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5230: END IF;
5231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5232: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');

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

5225: WHEN OTHERS THEN
5226: ROLLBACK TO LOANS_NEXT_DD_PVT;
5227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5229: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5230: END IF;
5231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5232: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5233: END;

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

5227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5228: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5229: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5230: END IF;
5231: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5232: LogMessage(FND_LOG.LEVEL_ERROR, 'Rollbacked loans');
5233: END;
5234:
5235:

Line 5387: FND_MSG_PUB.initialize;

5383: END IF;
5384:
5385: -- Initialize message list if p_init_msg_list is set to TRUE
5386: IF FND_API.To_Boolean(p_init_msg_list) THEN
5387: FND_MSG_PUB.initialize;
5388: END IF;
5389:
5390: -- Initialize API return status to success
5391: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5416: FND_MSG_PUB.Add;

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

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

5413:
5414: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
5415: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
5416: FND_MSG_PUB.Add;
5417: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5418: RAISE FND_API.G_EXC_ERROR;
5419:
5420: end if;
5421:

Line 5497: FND_MSG_PUB.Add;

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

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

5494:
5495: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No trx lines found to reverse.');
5496: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');
5497: FND_MSG_PUB.Add;
5498: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5499: RAISE FND_API.G_EXC_ERROR;
5500:
5501: end if;
5502:

Line 5576: FND_MSG_PUB.Add;

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

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

5573: ELSE
5574: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Failed to calculate next payment due date.');
5575: FND_MESSAGE.SET_NAME('LNS', 'LNS_CALC_NEXT_DUE_FAIL');
5576: FND_MSG_PUB.Add;
5577: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5578: RAISE FND_API.G_EXC_ERROR;
5579: END IF;
5580:
5581: STORE_LAST_PAYMENT_NUMBER(P_LOAN_ID);

Line 5641: FND_MSG_PUB.Count_And_Get(

5637: -- END OF BODY OF API
5638: x_return_status := FND_API.G_RET_STS_SUCCESS;
5639:
5640: -- Standard call to get message count and if count is 1, get message info
5641: FND_MSG_PUB.Count_And_Get(
5642: p_encoded => FND_API.G_FALSE,
5643: p_count => x_msg_count,
5644: p_data => x_msg_data);
5645:

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

5648: EXCEPTION
5649: WHEN FND_API.G_EXC_ERROR THEN
5650: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
5651: x_return_status := FND_API.G_RET_STS_ERROR;
5652: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5653: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
5654: g_cr_return_status := 'ERROR';
5655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5656: ROLLBACK TO REVERSE_LAST_AMORTIZATION;

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

5654: g_cr_return_status := 'ERROR';
5655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5656: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
5657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5658: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5659: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
5660: g_cr_return_status := 'ERROR';
5661: WHEN OTHERS THEN
5662: ROLLBACK TO REVERSE_LAST_AMORTIZATION;

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

5660: g_cr_return_status := 'ERROR';
5661: WHEN OTHERS THEN
5662: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
5663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5664: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5665: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5666: END IF;
5667: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5668: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');

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

5661: WHEN OTHERS THEN
5662: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
5663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5664: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5665: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5666: END IF;
5667: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5668: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
5669: g_cr_return_status := 'ERROR';

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

5663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5664: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5665: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5666: END IF;
5667: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5668: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
5669: g_cr_return_status := 'ERROR';
5670: END;
5671:

Line 5803: FND_MSG_PUB.initialize;

5799: END IF;
5800:
5801: -- Initialize message list if p_init_msg_list is set to TRUE
5802: IF FND_API.To_Boolean(p_init_msg_list) THEN
5803: FND_MSG_PUB.initialize;
5804: END IF;
5805:
5806: -- Initialize API return status to success
5807: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5827: FND_MSG_PUB.Add;

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

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

5824:
5825: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
5826: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
5827: FND_MSG_PUB.Add;
5828: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5829: RAISE FND_API.G_EXC_ERROR;
5830:
5831: end if;
5832:

Line 5835: FND_MSG_PUB.Add;

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

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

5832:
5833: if P_LINE_TYPE is null then
5834: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LINE_TYPE');
5835: FND_MSG_PUB.Add;
5836: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
5837: RAISE FND_API.G_EXC_ERROR;
5838: end if;
5839:
5840: /* quering for last loan amortization record */

Line 5904: FND_MSG_PUB.Add;

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

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

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

Line 5924: FND_MSG_PUB.Count_And_Get(

5920: -- END OF BODY OF API
5921: x_return_status := FND_API.G_RET_STS_SUCCESS;
5922:
5923: -- Standard call to get message count and if count is 1, get message info
5924: FND_MSG_PUB.Count_And_Get(
5925: p_encoded => FND_API.G_FALSE,
5926: p_count => x_msg_count,
5927: p_data => x_msg_data);
5928:

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

5931: EXCEPTION
5932: WHEN FND_API.G_EXC_ERROR THEN
5933: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
5934: x_return_status := FND_API.G_RET_STS_ERROR;
5935: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5936: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
5937: g_cr_return_status := 'ERROR';
5938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5939: ROLLBACK TO REVERSE_LAST_AMORTIZATION;

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

5937: g_cr_return_status := 'ERROR';
5938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5939: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
5940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5941: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5942: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
5943: g_cr_return_status := 'ERROR';
5944: WHEN OTHERS THEN
5945: ROLLBACK TO REVERSE_LAST_AMORTIZATION;

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

5943: g_cr_return_status := 'ERROR';
5944: WHEN OTHERS THEN
5945: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
5946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5948: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5949: END IF;
5950: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5951: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');

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

5944: WHEN OTHERS THEN
5945: ROLLBACK TO REVERSE_LAST_AMORTIZATION;
5946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5948: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5949: END IF;
5950: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5951: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
5952: g_cr_return_status := 'ERROR';

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

5946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
5948: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5949: END IF;
5950: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5951: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
5952: g_cr_return_status := 'ERROR';
5953:
5954: END CREDIT_AMORTIZATION_PARTIAL;

Line 6072: FND_MSG_PUB.initialize;

6068: END IF;
6069:
6070: -- Initialize message list if p_init_msg_list is set to TRUE
6071: IF FND_API.To_Boolean(p_init_msg_list) THEN
6072: FND_MSG_PUB.initialize;
6073: END IF;
6074:
6075: -- Initialize API return status to success
6076: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6092: FND_MSG_PUB.Add;

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

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

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

Line 6100: FND_MSG_PUB.Add;

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

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

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

Line 6108: FND_MSG_PUB.Add;

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

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

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

Line 6117: FND_MSG_PUB.Add;

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

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

6114: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No lines found for header ' || P_BILL_HEADER_REC.HEADER_ID);
6115: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINES');
6116: FND_MESSAGE.SET_TOKEN('HEADER', P_BILL_HEADER_REC.HEADER_ID);
6117: FND_MSG_PUB.Add;
6118: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6119: RAISE FND_API.G_EXC_ERROR;
6120: end if;
6121:
6122: /* init amounts */

Line 6147: FND_MSG_PUB.Add;

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

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

6144: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Amount for line ' || l_lines_tbl(l_Count).LINE_ID || ' is not set.');
6145: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_AMOUNT');
6146: FND_MESSAGE.SET_TOKEN('LINE', l_lines_tbl(l_Count).LINE_ID);
6147: FND_MSG_PUB.Add;
6148: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6149: RAISE FND_API.G_EXC_ERROR;
6150: end if;
6151:
6152: if l_lines_tbl(l_Count).LINE_TYPE is null then

Line 6156: FND_MSG_PUB.Add;

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

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

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

Line 6211: FND_MSG_PUB.Add;

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

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

6208: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_INSTALLMENT');
6209: FND_MESSAGE.SET_TOKEN('LOAN',P_BILL_HEADER_REC.LOAN_ID);
6210: FND_MESSAGE.SET_TOKEN('INST', P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM);
6211: FND_MSG_PUB.Add;
6212: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6213: RAISE FND_API.G_EXC_ERROR;
6214: end if;
6215:
6216: close loan_cur;

Line 6339: FND_MSG_PUB.Count_And_Get(

6335: -- END OF BODY OF API
6336: x_return_status := FND_API.G_RET_STS_SUCCESS;
6337:
6338: -- Standard call to get message count and if count is 1, get message info
6339: FND_MSG_PUB.Count_And_Get(
6340: p_encoded => FND_API.G_FALSE,
6341: p_count => x_msg_count,
6342: p_data => x_msg_data);
6343:

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

6346: EXCEPTION
6347: WHEN FND_API.G_EXC_ERROR THEN
6348: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6349: x_return_status := FND_API.G_RET_STS_ERROR;
6350: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6351: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6353: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6351: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6353: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6355: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6356: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6357: WHEN OTHERS THEN
6358: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6356: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6357: WHEN OTHERS THEN
6358: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6361: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6362: END IF;
6363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6364: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

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

6357: WHEN OTHERS THEN
6358: ROLLBACK TO CREATE_SINGLE_OFFCYCLE_BILL;
6359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6361: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6362: END IF;
6363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6364: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6365: END;

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

6359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6360: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6361: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6362: END IF;
6363: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6364: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6365: END;
6366:
6367:

Line 6446: FND_MSG_PUB.initialize;

6442: END IF;
6443:
6444: -- Initialize message list if p_init_msg_list is set to TRUE
6445: IF FND_API.To_Boolean(p_init_msg_list) THEN
6446: FND_MSG_PUB.initialize;
6447: END IF;
6448:
6449: -- Initialize API return status to success
6450: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6461: FND_MSG_PUB.Add;

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

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

6458: if P_BILL_HEADERS_TBL(l_Count).HEADER_ID is null then
6459: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Header ID is not set.');
6460: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_HEADER');
6461: FND_MSG_PUB.Add;
6462: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6463: RAISE FND_API.G_EXC_ERROR;
6464: end if;
6465:
6466: /* Init lines table */

Line 6477: FND_MSG_PUB.Add;

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

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

6474: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: Header ID for line ' || P_BILL_LINES_TBL(l_Count1).LINE_ID || ' is not set.');
6475: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_BILL_NO_LINE_HEADER');
6476: FND_MESSAGE.SET_TOKEN('LINE', P_BILL_LINES_TBL(l_Count1).LINE_ID);
6477: FND_MSG_PUB.Add;
6478: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6479: RAISE FND_API.G_EXC_ERROR;
6480: end if;
6481:
6482: /* Adding current line record to lines table of current header */

Line 6520: FND_MSG_PUB.Count_And_Get(

6516: -- END OF BODY OF API
6517: x_return_status := FND_API.G_RET_STS_SUCCESS;
6518:
6519: -- Standard call to get message count and if count is 1, get message info
6520: FND_MSG_PUB.Count_And_Get(
6521: p_encoded => FND_API.G_FALSE,
6522: p_count => x_msg_count,
6523: p_data => x_msg_data);
6524:

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

6527: EXCEPTION
6528: WHEN FND_API.G_EXC_ERROR THEN
6529: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
6530: x_return_status := FND_API.G_RET_STS_ERROR;
6531: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6532: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6534: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
6535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6532: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6534: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
6535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6536: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6537: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6538: WHEN OTHERS THEN
6539: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
6540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6537: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6538: WHEN OTHERS THEN
6539: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
6540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6542: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6543: END IF;
6544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6545: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');

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

6538: WHEN OTHERS THEN
6539: ROLLBACK TO CREATE_OFFCYCLE_BILLS;
6540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6542: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6543: END IF;
6544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6545: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6546: END;

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

6540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6542: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6543: END IF;
6544: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6545: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loan');
6546: END;
6547:
6548:

Line 6673: FND_MSG_PUB.initialize;

6669: END IF;
6670:
6671: -- Initialize message list if p_init_msg_list is set to TRUE
6672: IF FND_API.To_Boolean(p_init_msg_list) THEN
6673: FND_MSG_PUB.initialize;
6674: END IF;
6675:
6676: -- Initialize API return status to success
6677: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6689: FND_MSG_PUB.Add;

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

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

6686: if P_AMORTIZATION_ID is null then
6687: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Amortization ID must be set.');
6688: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_AMORT');
6689: FND_MSG_PUB.Add;
6690: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
6691: RAISE FND_API.G_EXC_ERROR;
6692: end if;
6693:
6694: /* verify is it really offcycle bill, reversed etc. */

Line 6709: FND_MSG_PUB.Add;

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

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

6706:
6707: -- LogMessage(FND_LOG.LEVEL_ERROR, 'ERROR: No amortization record found.');
6708: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_NO_BILL_FOUND');
6709: FND_MSG_PUB.Add;
6710: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6711: RAISE FND_API.G_EXC_ERROR;
6712:
6713: else
6714:

Line 6725: FND_MSG_PUB.Add;

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

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

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

Line 6733: FND_MSG_PUB.Add;

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

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

6730:
6731: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: The amortization is already reversed.');
6732: FND_MESSAGE.SET_NAME('LNS', 'LNS_MAN_REV_ALREADY_REV');
6733: FND_MSG_PUB.Add;
6734: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6735: RAISE FND_API.G_EXC_ERROR;
6736:
6737: end if;
6738:

Line 6780: FND_MSG_PUB.Add;

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

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

6777:
6778: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: No trx lines found to reverse.');
6779: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_TRX_LINES_TO_REV');
6780: FND_MSG_PUB.Add;
6781: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
6782: RAISE FND_API.G_EXC_ERROR;
6783:
6784: end if;
6785:

Line 6812: FND_MSG_PUB.Count_And_Get(

6808: -- END OF BODY OF API
6809: x_return_status := FND_API.G_RET_STS_SUCCESS;
6810:
6811: -- Standard call to get message count and if count is 1, get message info
6812: FND_MSG_PUB.Count_And_Get(
6813: p_encoded => FND_API.G_FALSE,
6814: p_count => x_msg_count,
6815: p_data => x_msg_data);
6816:

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

6819: EXCEPTION
6820: WHEN FND_API.G_EXC_ERROR THEN
6821: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
6822: x_return_status := FND_API.G_RET_STS_ERROR;
6823: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6824: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6826: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
6827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6824: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6826: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
6827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6828: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6829: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6830: WHEN OTHERS THEN
6831: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
6832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

6829: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6830: WHEN OTHERS THEN
6831: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
6832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6834: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6835: END IF;
6836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6837: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

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

6830: WHEN OTHERS THEN
6831: ROLLBACK TO REVERSE_OFFCYCLE_BILL;
6832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6834: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6835: END IF;
6836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6837: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6838: END;

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

6832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
6834: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6835: END IF;
6836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
6837: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
6838: END;
6839:
6840:

Line 6983: FND_MSG_PUB.initialize;

6979: END IF;
6980:
6981: -- Initialize message list if p_init_msg_list is set to TRUE
6982: IF FND_API.To_Boolean(p_init_msg_list) THEN
6983: FND_MSG_PUB.initialize;
6984: END IF;
6985:
6986: -- Initialize API return status to success
6987: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7000: FND_MSG_PUB.Add;

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

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

6997:
6998: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
6999: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
7000: FND_MSG_PUB.Add;
7001: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7002: RAISE FND_API.G_EXC_ERROR;
7003:
7004: end if;
7005:

Line 7010: FND_MSG_PUB.Add;

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

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

7007: if g_receivables_trx_id is null then
7008: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Receivables activity name is not set in the system option.');
7009: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_TRX_IN_SYS_OPT');
7010: FND_MSG_PUB.Add;
7011: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7012: RAISE FND_API.G_EXC_ERROR;
7013:
7014: end if;
7015:

Line 7026: FND_MSG_PUB.Add;

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

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

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

Line 7072: FND_MSG_PUB.Add;

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

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

7069: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Adjustment amount: -' || l_requested_amount);
7070: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Receivable remaining amount: ' || l_amount_due_remaining);
7071: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ADJ_AMT');
7072: FND_MSG_PUB.Add;
7073: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7074: RAISE FND_API.G_EXC_ERROR;
7075: else
7076: l_type := 'LINE';
7077: end if;

Line 7087: FND_MSG_PUB.Add;

7083: if l_adj_number is not null or l_adj_id is not null then
7084: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Attempt to duplicate adjustment. Receivable has been already adjusted for this loan by adjustment xxx' );
7085: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');
7086: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);
7087: FND_MSG_PUB.Add;
7088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7089: RAISE FND_API.G_EXC_ERROR;
7090: end if;
7091:

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

7084: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Attempt to duplicate adjustment. Receivable has been already adjusted for this loan by adjustment xxx' );
7085: FND_MESSAGE.SET_NAME('LNS', 'LNS_DUPL_ADJ_ORIG_REC');
7086: FND_MESSAGE.SET_TOKEN('ADJ', l_adj_number);
7087: FND_MSG_PUB.Add;
7088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7089: RAISE FND_API.G_EXC_ERROR;
7090: end if;
7091:
7092: /* buld comments */

Line 7155: FND_MSG_PUB.Add;

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

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

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

Line 7171: FND_MSG_PUB.Count_And_Get(

7167: -- END OF BODY OF API
7168: x_return_status := FND_API.G_RET_STS_SUCCESS;
7169:
7170: -- Standard call to get message count and if count is 1, get message info
7171: FND_MSG_PUB.Count_And_Get(
7172: p_encoded => FND_API.G_FALSE,
7173: p_count => x_msg_count,
7174: p_data => x_msg_data);
7175:

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

7178: EXCEPTION
7179: WHEN FND_API.G_EXC_ERROR THEN
7180: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7181: x_return_status := FND_API.G_RET_STS_ERROR;
7182: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7185: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7183: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7185: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7187: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7189: WHEN OTHERS THEN
7190: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7188: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7189: WHEN OTHERS THEN
7190: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7193: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7194: END IF;
7195: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

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

7189: WHEN OTHERS THEN
7190: ROLLBACK TO ADJUST_ORIGINAL_RECEIVABLE;
7191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7193: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7194: END IF;
7195: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7197: END;

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

7191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7193: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7194: END IF;
7195: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7196: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7197: END;
7198:
7199:

Line 7298: FND_MSG_PUB.initialize;

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

Line 7312: FND_MSG_PUB.Add;

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

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

7309:
7310: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
7311: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
7312: FND_MSG_PUB.Add;
7313: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7314: RAISE FND_API.G_EXC_ERROR;
7315:
7316: end if;
7317:

Line 7433: FND_MSG_PUB.Add;

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

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

7430: if l_amortization_rec.INSTALLMENT_NUMBER <> l_fee_tbl(l_Count).FEE_INSTALLMENT then
7431:
7432: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_FEE_INSTAL');
7433: FND_MSG_PUB.Add;
7434: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7435: RAISE FND_API.G_EXC_ERROR;
7436:
7437: end if;
7438:

Line 7484: FND_MSG_PUB.Count_And_Get(

7480: x_return_status := FND_API.G_RET_STS_SUCCESS;
7481: X_BILLED_YN := 'Y';
7482:
7483: -- Standard call to get message count and if count is 1, get message info
7484: FND_MSG_PUB.Count_And_Get(
7485: p_encoded => FND_API.G_FALSE,
7486: p_count => x_msg_count,
7487: p_data => x_msg_data);
7488:

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

7491: EXCEPTION
7492: WHEN FND_API.G_EXC_ERROR THEN
7493: ROLLBACK TO PREBILL_SINGLE_LOAN;
7494: x_return_status := FND_API.G_RET_STS_ERROR;
7495: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7496: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7498: ROLLBACK TO PREBILL_SINGLE_LOAN;
7499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7496: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7498: ROLLBACK TO PREBILL_SINGLE_LOAN;
7499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7500: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7501: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7502: WHEN OTHERS THEN
7503: ROLLBACK TO PREBILL_SINGLE_LOAN;
7504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7501: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7502: WHEN OTHERS THEN
7503: ROLLBACK TO PREBILL_SINGLE_LOAN;
7504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7506: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7507: END IF;
7508: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7509: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

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

7502: WHEN OTHERS THEN
7503: ROLLBACK TO PREBILL_SINGLE_LOAN;
7504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7506: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7507: END IF;
7508: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7509: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7510: END;

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

7504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7505: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7506: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7507: END IF;
7508: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7509: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7510: END;
7511:
7512:

Line 7635: FND_MSG_PUB.initialize;

7631: END IF;
7632:
7633: -- Initialize message list if p_init_msg_list is set to TRUE
7634: IF FND_API.To_Boolean(p_init_msg_list) THEN
7635: FND_MSG_PUB.initialize;
7636: END IF;
7637:
7638: -- Initialize API return status to success
7639: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 7649: FND_MSG_PUB.Add;

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

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

7646:
7647: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: Loan must be set.');
7648: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
7649: FND_MSG_PUB.Add;
7650: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7651: RAISE FND_API.G_EXC_ERROR;
7652:
7653: end if;
7654:

Line 7764: FND_MSG_PUB.Count_And_Get(

7760: -- END OF BODY OF API
7761: x_return_status := FND_API.G_RET_STS_SUCCESS;
7762:
7763: -- Standard call to get message count and if count is 1, get message info
7764: FND_MSG_PUB.Count_And_Get(
7765: p_encoded => FND_API.G_FALSE,
7766: p_count => x_msg_count,
7767: p_data => x_msg_data);
7768:

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

7771: EXCEPTION
7772: WHEN FND_API.G_EXC_ERROR THEN
7773: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
7774: x_return_status := FND_API.G_RET_STS_ERROR;
7775: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7776: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7778: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
7779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7776: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7778: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
7779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7780: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7781: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7782: WHEN OTHERS THEN
7783: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
7784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

7781: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7782: WHEN OTHERS THEN
7783: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
7784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7786: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7787: END IF;
7788: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7789: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

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

7782: WHEN OTHERS THEN
7783: ROLLBACK TO FORGIVENESS_ADJUSTMENT;
7784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7786: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7787: END IF;
7788: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7789: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7790: END;

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

7784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
7786: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
7787: END IF;
7788: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7789: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
7790: END;
7791:
7792: