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.IGC_CC_REVALUE_PROCESS_PKG dependencies on FND_LOG

Line 57: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.validate_params.Msg1',

53: -- END IF;
54:
55: -- bug 3199488, start block
56: IF (l_state_level >= l_debug_level) THEN
57: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.validate_params.Msg1',
58: ' IGCCREPB -- Validate Params begins ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
59: END IF;
60: -- bug 3199488, end block
61:

Line 270: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.validate_params.Msg2',

266: -- END IF;
267:
268: -- bug 3199488, start block
269: IF (l_state_level >= l_debug_level) THEN
270: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.validate_params.Msg2',
271: ' IGCCREPB -- Validate Params ends ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
272: END IF;
273: -- bug 3199488, end block
274:

Line 302: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.lock_cc_po.Msg1',

298: -- END IF;
299:
300: -- bug 3199488, start block
301: IF (l_state_level >= l_debug_level) THEN
302: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.lock_cc_po.Msg1',
303: ' IGCCREPB -- Lock CC PO Begins ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
304: END IF;
305: -- bug 3199488, end block
306:

Line 395: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.lock_cc_po.Msg2',

391: -- END IF;
392:
393: -- bug 3199488, start block
394: IF (l_state_level >= l_debug_level) THEN
395: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.lock_cc_po.Msg2',
396: ' IGCCREPB -- Lock CC PO Ends ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
397: END IF;
398: -- bug 3199488, end block
399:

Line 637: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg1',

633: -- END IF;
634:
635: -- bug 3199488, start block
636: IF (l_state_level >= l_debug_level) THEN
637: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg1',
638: ' IGCCREPB -- Reval Update Begins ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
639: END IF;
640: -- bug 3199488, end block
641:

Line 744: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg2',

740: -- END IF;
741:
742: -- bug 3199488, start block
743: IF (l_state_level >= l_debug_level) THEN
744: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg2',
745: ' IGCCREPB -- Reval Update Ends 9 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
746: END IF;
747: -- bug 3199488, end block
748:

Line 838: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg3',

834: -- END IF;
835:
836: -- bug 3199488, start block
837: IF (l_state_level >= l_debug_level) THEN
838: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg3',
839: ' IGCCREPB -- Reval Update Ends 8 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
840: END IF;
841: -- bug 3199488, end block
842:

Line 958: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg4',

954: -- END IF;
955:
956: -- bug 3199488, start block
957: IF (l_state_level >= l_debug_level) THEN
958: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg4',
959: ' IGCCREPB -- Reval Update Ends 7 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
960: END IF;
961: -- bug 3199488, end block
962:

Line 1040: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg5',

1036: -- END IF;
1037:
1038: -- bug 3199488, start block
1039: IF (l_state_level >= l_debug_level) THEN
1040: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg5',
1041: ' IGCCREPB -- Reval Update Ends 6 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1042: END IF;
1043: -- bug 3199488, end block
1044:

Line 1158: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg6',

1154: -- END IF;
1155:
1156: -- bug 3199488, start block
1157: IF (l_state_level >= l_debug_level) THEN
1158: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg6',
1159: ' IGCCREPB -- Reval Update Ends 5 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1160: END IF;
1161: -- bug 3199488, end block
1162:

Line 1299: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg7',

1295: -- END IF;
1296:
1297: -- bug 3199488, start block
1298: IF (l_state_level >= l_debug_level) THEN
1299: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg7',
1300: ' IGCCREPB -- Reval Update Ends 4 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1301: END IF;
1302: -- bug 3199488, end block
1303:

Line 1344: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg8',

1340: -- END IF;
1341:
1342: -- bug 3199488, start block
1343: IF (l_state_level >= l_debug_level) THEN
1344: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg8',
1345: ' IGCCREPB -- Reval Update Ends 3 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1346: END IF;
1347: -- bug 3199488, end block
1348:

Line 1401: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg9',

1397: -- END IF;
1398:
1399: -- bug 3199488, start block
1400: IF (l_state_level >= l_debug_level) THEN
1401: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg9',
1402: ' IGCCREPB -- Reval Update Ends 1 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1403: END IF;
1404: -- bug 3199488, end block
1405:

Line 1423: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg10',

1419: -- END IF;
1420:
1421: -- bug 3199488, start block
1422: IF (l_state_level >= l_debug_level) THEN
1423: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg10',
1424: ' IGCCREPB -- Reval Update Ends 2 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1425: END IF;
1426: -- bug 3199488, end block
1427:

Line 1437: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg11',

1433: -- END IF;
1434:
1435: -- bug 3199488, start block
1436: IF (l_state_level >= l_debug_level) THEN
1437: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.reval_update.Msg11',
1438: ' IGCCREPB -- Reval Update Ends 10 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1439: END IF;
1440: -- bug 3199488, end block
1441:

Line 1523: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.populate_errors.Msg1',

1519: -- END IF;
1520:
1521: -- bug 3199488, start block
1522: IF (l_state_level >= l_debug_level) THEN
1523: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.populate_errors.Msg1',
1524: ' IGCCREPB -- Populate Error Begins ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1525: END IF;
1526: -- bug 3199488, end block
1527:

Line 1571: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.populate_errors.Msg2',

1567: -- END IF;
1568:
1569: -- bug 3199488, start block
1570: IF (l_state_level >= l_debug_level) THEN
1571: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.populate_errors.Msg2',
1572: ' IGCCREPB -- Populate Error Ends ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1573: END IF;
1574: -- bug 3199488, end block
1575:

Line 1974: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg1',

1970: -- END IF;
1971:
1972: -- bug 3199488, start block
1973: IF (l_state_level >= l_debug_level) THEN
1974: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg1',
1975: ' IGCCREPB -- Starting Revalue CC ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
1976: END IF;
1977: -- bug 3199488, end block
1978:

Line 2019: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg2',

2015: -- END IF;
2016:
2017: -- bug 3199488, start block
2018: IF (l_state_level >= l_debug_level) THEN
2019: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg2',
2020: ' IGCCREPB -- Calling get_budg_ctrl_params ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2021: END IF;
2022: -- bug 3199488, end block
2023:

Line 2085: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg3',

2081: --END IF;
2082:
2083: -- bug 3199488, start block
2084: IF (l_state_level >= l_debug_level) THEN
2085: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg3',
2086: ' IGCCREPB -- Submitting request ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2087: END IF;
2088: -- bug 3199488, end block
2089:

Line 2161: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp1',

2157: -- fnd_file.put_line (FND_FILE.LOG,
2158: -- l_error_text);
2159: -- bug 3199488 start block
2160: IF (l_state_level >= l_debug_level) THEN
2161: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp1',
2162: l_error_text);
2163: END IF;
2164: -- bug 3199488, end block
2165: END LOOP;

Line 2188: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg4',

2184: --END IF;
2185:
2186: -- bug 3199488, start block
2187: IF (l_state_level >= l_debug_level) THEN
2188: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg4',
2189: ' IGCCREPB -- Calling validate_params ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2190: END IF;
2191: -- bug 3199488, end block
2192:

Line 2211: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg5',

2207: --END IF;
2208:
2209: -- bug 3199488, start block
2210: IF (l_state_level >= l_debug_level) THEN
2211: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg5',
2212: ' IGCCREPB -- Submitting request ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2213: END IF;
2214: -- bug 3199488, end block
2215:

Line 2280: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp2',

2276: -- fnd_file.put_line (FND_FILE.LOG,
2277: -- l_error_text);
2278: -- bug 3199488 start block
2279: IF (l_state_level >= l_debug_level) THEN
2280: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp2',
2281: l_error_text);
2282: END IF;
2283: -- bug 3199488, end block
2284: END LOOP;

Line 2301: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg6',

2297: -- END IF;
2298:
2299: -- bug 3199488, start block
2300: IF (l_state_level >= l_debug_level) THEN
2301: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg6',
2302: ' IGCCREPB -- Opening revalue_process_cc_cursor ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2303: END IF;
2304: -- bug 3199488, end block
2305:

Line 2331: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg7',

2327: -- END IF;
2328:
2329: -- bug 3199488, start block
2330: IF (l_state_level >= l_debug_level) THEN
2331: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg7',
2332: ' IGCCREPB -- Inserting CC type S record into process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2333: END IF;
2334: -- bug 3199488, end block
2335:

Line 2377: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg8',

2373: -- END IF;
2374:
2375: -- bug 3199488, start block
2376: IF (l_state_level >= l_debug_level) THEN
2377: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg8',
2378: ' IGCCREPB -- Checking R CC Type record ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2379: END IF;
2380: -- bug 3199488, end block
2381:

Line 2400: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg9',

2396: -- END IF;
2397:
2398: -- bug 3199488, start block
2399: IF (l_state_level >= l_debug_level) THEN
2400: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg9',
2401: ' IGCCREPB -- Cover not found ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2402: END IF;
2403: -- bug 3199488, end block
2404:

Line 2416: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg10',

2412: -- END IF;
2413:
2414: -- bug 3199488, start block
2415: IF (l_state_level >= l_debug_level) THEN
2416: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg10',
2417: ' IGCCREPB -- Inserting cover into process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2418: END IF;
2419: -- bug 3199488, end block
2420:

Line 2457: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg11',

2453: -- END IF;
2454:
2455: -- bug 3199488, start block
2456: IF (l_state_level >= l_debug_level) THEN
2457: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg11',
2458: ' IGCCREPB -- Opening all releases Cursor ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2459: END IF;
2460: -- bug 3199488, end block
2461:

Line 2473: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg12',

2469: -- END IF;
2470:
2471: -- bug 3199488, start block
2472: IF (l_state_level >= l_debug_level) THEN
2473: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg12',
2474: ' IGCCREPB -- Inserting release into process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2475: END IF;
2476: -- bug 3199488, end block
2477:

Line 2550: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg13',

2546: -- END IF;
2547:
2548: -- bug 3199488, start block
2549: IF (l_state_level >= l_debug_level) THEN
2550: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg13',
2551: ' IGCCREPB -- Attempting lock CC PO ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2552: END IF;
2553: -- bug 3199488, end block
2554:

Line 2582: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg14',

2578: -- END IF;
2579:
2580: -- bug 3199488, start block
2581: IF (l_state_level >= l_debug_level) THEN
2582: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg14',
2583: ' IGCCREPB -- Begin Cover revaluation ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2584: END IF;
2585: -- bug 3199488, end block
2586:

Line 2605: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg15',

2601: -- END IF;
2602:
2603: -- bug 3199488, start block
2604: IF (l_state_level >= l_debug_level) THEN
2605: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg15',
2606: ' IGCCREPB -- Cover not found ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2607: END IF;
2608: -- bug 3199488, end block
2609:

Line 2621: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg16',

2617: -- END IF;
2618:
2619: -- bug 3199488, start block
2620: IF (l_state_level >= l_debug_level) THEN
2621: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg16',
2622: ' IGCCREPB -- Obtaining releases cursor ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2623: END IF;
2624: -- bug 3199488, end block
2625:

Line 2636: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg17',

2632: -- END IF;
2633:
2634: -- bug 3199488, start block
2635: IF (l_state_level >= l_debug_level) THEN
2636: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg17',
2637: ' IGCCREPB -- Inserting into process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2638: END IF;
2639: -- bug 3199488, end block
2640:

Line 2675: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg18',

2671: -- END IF;
2672:
2673: -- bug 3199488, start block
2674: IF (l_state_level >= l_debug_level) THEN
2675: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg18',
2676: ' IGCCREPB -- Done with releases ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2677: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg19',
2678: ' IGCCREPB -- Inserting cover into process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2679:

Line 2677: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg19',

2673: -- bug 3199488, start block
2674: IF (l_state_level >= l_debug_level) THEN
2675: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg18',
2676: ' IGCCREPB -- Done with releases ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2677: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg19',
2678: ' IGCCREPB -- Inserting cover into process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2679:
2680: END IF;
2681: -- bug 3199488, end block

Line 2724: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg20',

2720: -- END IF;
2721:
2722: -- bug 3199488, start block
2723: IF (l_state_level >= l_debug_level) THEN
2724: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg20',
2725: ' IGCCREPB -- Done with revalue process CC ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2726: END IF;
2727: -- bug 3199488, end block
2728:

Line 2739: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg21',

2735: -- END IF;
2736:
2737: -- bug 3199488, start block
2738: IF (l_state_level >= l_debug_level) THEN
2739: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg21',
2740: ' IGCCREPB -- Checking Final Phase ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2741: END IF;
2742: -- bug 3199488, end block
2743:

Line 2752: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg22',

2748: -- END IF;
2749:
2750: -- bug 3199488, start block
2751: IF (l_state_level >= l_debug_level) THEN
2752: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg22',
2753: ' IGCCREPB -- Final Phase Starts ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2754: END IF;
2755: -- bug 3199488, end block
2756:

Line 2779: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg23',

2775: -- END IF;
2776:
2777: -- bug 3199488, start block
2778: IF (l_state_level >= l_debug_level) THEN
2779: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg23',
2780: ' IGCCREPB -- Attempting lock cc po ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2781: END IF;
2782: -- bug 3199488, end block
2783:

Line 2796: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg24',

2792: -- END IF;
2793:
2794: -- bug 3199488, start block
2795: IF (l_state_level >= l_debug_level) THEN
2796: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg24',
2797: ' IGCCREPB -- Attempting lock cc po FALSE ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2798: END IF;
2799: -- bug 3199488, end block
2800:

Line 2818: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg25',

2814: -- END IF;
2815:
2816: -- bug 3199488, start block
2817: IF (l_state_level >= l_debug_level) THEN
2818: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg25',
2819: ' IGCCREPB -- Checking Cover Type ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2820: END IF;
2821: -- bug 3199488, end block
2822:

Line 2831: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg26',

2827: -- END IF;
2828:
2829: -- bug 3199488, start block
2830: IF (l_state_level >= l_debug_level) THEN
2831: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg26',
2832: ' IGCCREPB -- Getting Releases ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2833: END IF;
2834: -- bug 3199488, end block
2835:

Line 2851: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg27',' IGCCREPB -- locking cc po for release ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

2847: -- END IF;
2848:
2849: -- bug 3199488, start block
2850: IF (l_state_level >= l_debug_level) THEN
2851: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg27',' IGCCREPB -- locking cc po for release ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2852: END IF;
2853: -- bug 3199488, end block
2854:
2855: l_lock_cc_po := lock_cc_po(l_sob_id,l_org_id,l_rel_cc_header_id,l_request_id1);

Line 2866: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg28',

2862: -- END IF;
2863:
2864: -- bug 3199488, start block
2865: IF (l_state_level >= l_debug_level) THEN
2866: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg28',
2867: ' IGCCREPB -- locking cc po for release FALSE' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2868: END IF;
2869: -- bug 3199488, end block
2870:

Line 2899: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg29',

2895: -- END IF;
2896:
2897: -- bug 3199488, start block
2898: IF (l_state_level >= l_debug_level) THEN
2899: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg29',
2900: ' IGCCREPB -- Done with releases ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2901: END IF;
2902: -- bug 3199488, end block
2903:

Line 2914: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg30',

2910: -- END IF;
2911:
2912: -- bug 3199488, start block
2913: IF (l_state_level >= l_debug_level) THEN
2914: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg30',
2915: ' IGCCREPB -- lock cc po TRUE ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2916: END IF;
2917: -- bug 3199488, end block
2918:

Line 2930: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg31',

2926: -- END IF;
2927:
2928: -- bug 3199488, start block
2929: IF (l_state_level >= l_debug_level) THEN
2930: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg31',
2931: ' IGCCREPB -- lock cc po FALSE ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2932: END IF;
2933: -- bug 3199488, end block
2934:

Line 2967: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg32',

2963: -- END IF;
2964:
2965: -- bug 3199488, start block
2966: IF (l_state_level >= l_debug_level) THEN
2967: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg32',
2968: ' IGCCREPB -- Done with reval_data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2969: END IF;
2970: -- bug 3199488, end block
2971:

Line 2981: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg33',

2977: -- END IF;
2978:
2979: -- bug 3199488, start block
2980: IF (l_state_level >= l_debug_level) THEN
2981: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg33',
2982: ' IGCCREPB -- Done with lock CC and PO ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2983: END IF;
2984: -- bug 3199488, end block
2985:

Line 2994: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg34',

2990: -- END IF;
2991:
2992: -- bug 3199488, start block
2993: IF (l_state_level >= l_debug_level) THEN
2994: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg34',
2995: ' IGCCREPB -- Validate Cover for avail amount ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
2996: END IF;
2997: -- bug 3199488, end block
2998:

Line 3018: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg35',

3014: -- END IF;
3015:
3016: -- bug 3199488, start block
3017: IF (l_state_level >= l_debug_level) THEN
3018: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg35',
3019: ' IGCCREPB -- Getting account lines ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3020: END IF;
3021: -- bug 3199488, end block
3022:

Line 3041: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg36',

3037: -- END IF;
3038:
3039: -- bug 3199488, start block
3040: IF (l_state_level >= l_debug_level) THEN
3041: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg36',
3042: ' IGCCREPB -- Getting account lines ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3043: END IF;
3044: -- bug 3199488, end block
3045:

Line 3064: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg37',' IGCCREPB -- Amt total 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3060: -- END IF;
3061:
3062: -- bug 3199488, start block
3063: IF (l_state_level >= l_debug_level) THEN
3064: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg37',' IGCCREPB -- Amt total 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3065: END IF;
3066: -- bug 3199488, end block
3067:
3068: l_non_reval_acct_amt_total := 0;

Line 3097: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg38',

3093: -- Output_Debug (' IGCCREPB -- Amt total 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3094: -- END IF;
3095: -- bug 3199488, start block
3096: IF (l_state_level >= l_debug_level) THEN
3097: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg38',
3098: ' IGCCREPB -- Amt total 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3099: END IF;
3100: -- bug 3199488, end block
3101: l_reval_acct_amt_total := 0;

Line 3126: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg39',

3122: -- END IF;
3123:
3124: -- bug 3199488, start block
3125: IF (l_state_level >= l_debug_level) THEN
3126: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg39',
3127: ' IGCCREPB -- Revalue ONLY ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3128: END IF;
3129: -- bug 3199488, end block
3130:

Line 3150: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg40',

3146: -- END IF;
3147:
3148: -- bug 3199488, start block
3149: IF (l_state_level >= l_debug_level) THEN
3150: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg40',
3151: ' IGCCREPB -- NON Revalue amt total 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3152: END IF;
3153: -- bug 3199488, end block
3154:

Line 3186: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg41',

3182: -- END IF;
3183:
3184: -- bug 3199488, start block
3185: IF (l_state_level >= l_debug_level) THEN
3186: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg41',
3187: ' IGCCREPB -- Revalue amt total 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3188: END IF;
3189: -- bug 3199488, end block
3190:

Line 3207: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg42',

3203: -- END IF;
3204:
3205: -- bug 3199488, start block
3206: IF (l_state_level >= l_debug_level) THEN
3207: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg42',
3208: ' IGCCREPB -- Cover AND Release revaluation ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3209: END IF;
3210: -- bug 3199488, end block
3211:

Line 3231: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg43',

3227: -- END IF;
3228:
3229: -- bug 3199488, start block
3230: IF (l_state_level >= l_debug_level) THEN
3231: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg43',
3232: ' IGCCREPB -- NON reval acct amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3233: END IF;
3234: -- bug 3199488, end block
3235:

Line 3265: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg44',

3261: -- Output_Debug (' IGCCREPB -- reval acct amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3262: -- END IF;
3263: -- bug 3199488, start block
3264: IF (l_state_level >= l_debug_level) THEN
3265: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg44',
3266: ' IGCCREPB -- reval acct amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3267: END IF;
3268: -- bug 3199488, end block
3269: l_reval_acct_amt_total := 0;

Line 3290: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg45',

3286: -- Output_Debug (' IGCCREPB -- Populating error for amounts ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3287: -- END IF;
3288: -- bug 3199488, start block
3289: IF (l_state_level >= l_debug_level) THEN
3290: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg45',
3291: ' IGCCREPB -- Populating error for amounts ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3292: END IF;
3293: -- bug 3199488, end block
3294:

Line 3310: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg46',

3306: -- END IF;
3307:
3308: -- bug 3199488, start block
3309: IF (l_state_level >= l_debug_level) THEN
3310: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg46',
3311: ' IGCCREPB -- Getting PF Lines ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3312: END IF;
3313: -- bug 3199488, end block
3314:

Line 3334: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg47',

3330: -- END IF;
3331:
3332: -- bug 3199488, start block
3333: IF (l_state_level >= l_debug_level) THEN
3334: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg47',
3335: ' IGCCREPB -- Single Release revaluation ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3336: END IF;
3337: -- bug 3199488, end block
3338:

Line 3359: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg48',

3355: -- Output_Debug (' IGCCREPB -- Non reval PF amount 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3356: -- END IF;
3357: -- bug 3199488, start block
3358: IF (l_state_level >= l_debug_level) THEN
3359: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg48',
3360: ' IGCCREPB -- Non reval PF amount 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3361: END IF;
3362: -- bug 3199488, end block
3363: l_non_reval_pf_amt_total := 0;

Line 3400: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg49', ' IGCCREPB -- reval PF amount 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3396: -- Output_Debug (' IGCCREPB -- reval PF amount 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3397: -- END IF;
3398: -- bug 3199488, start block
3399: IF (l_state_level >= l_debug_level) THEN
3400: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg49', ' IGCCREPB -- reval PF amount 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3401: END IF;
3402: -- bug 3199488, end block
3403:
3404: l_reval_pf_amt_total := 0;

Line 3421: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg50',

3417: -- END IF;
3418:
3419: -- bug 3199488, start block
3420: IF (l_state_level >= l_debug_level) THEN
3421: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg50',
3422: ' IGCCREPB -- Cover AND release reval ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3423: END IF;
3424: -- bug 3199488, end block
3425:

Line 3448: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg51',' IGCCREPB -- NON reval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3444: -- END IF;
3445:
3446: -- bug 3199488, start block
3447: IF (l_state_level >= l_debug_level) THEN
3448: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg51',' IGCCREPB -- NON reval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3449: END IF;
3450: -- bug 3199488, end block
3451:
3452: l_non_reval_pf_amt_total := 0;

Line 3489: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg52',' IGCCREPB -- reval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3485: -- Output_Debug (' IGCCREPB -- reval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3486: -- END IF;
3487: -- bug 3199488, start block
3488: IF (l_state_level >= l_debug_level) THEN
3489: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg52',' IGCCREPB -- reval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3490: END IF;
3491: -- bug 3199488, end block
3492: l_reval_pf_amt_total := 0;
3493: END;

Line 3514: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg53',

3510: -- Output_Debug (' IGCCREPB -- Release REVAL Only ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3511: -- END IF;
3512: -- bug 3199488, start block
3513: IF (l_state_level >= l_debug_level) THEN
3514: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg53',
3515: ' IGCCREPB -- Release REVAL Only ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3516: END IF;
3517: -- bug 3199488, end block
3518:

Line 3540: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg54',

3536: -- Output_Debug (' IGCCREPB -- NON raval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3537: -- END IF;
3538: -- bug 3199488, start block
3539: IF (l_state_level >= l_debug_level) THEN
3540: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg54',
3541: ' IGCCREPB -- Non raval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3542: END IF;
3543: -- bug 3199488, end block
3544: l_non_reval_pf_amt_total := 0;

Line 3582: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg55',

3578: -- Output_Debug (' IGCCREPB -- raval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3579: -- END IF;
3580: -- bug 3199488, start block
3581: IF (l_state_level >= l_debug_level) THEN
3582: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg55',
3583: ' IGCCREPB -- Non raval PF amt 0 ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3584: END IF;
3585: -- bug 3199488, end block
3586: l_reval_pf_amt_total := 0;

Line 3603: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg56',

3599: -- END IF;
3600:
3601: -- bug 3199488, start block
3602: IF (l_state_level >= l_debug_level) THEN
3603: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg56',
3604: ' IGCCREPB -- Populate error PF amt ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3605: END IF;
3606: -- bug 3199488, end block
3607:

Line 3626: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg57',

3622: -- END IF;
3623:
3624: -- bug 3199488, start block
3625: IF (l_state_level >= l_debug_level) THEN
3626: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg57',
3627: ' IGCCREPB -- Done with PF line cursor ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3628: END IF;
3629: -- bug 3199488, end block
3630:

Line 3639: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg58',

3635: -- END IF;
3636:
3637: -- bug 3199488, start block
3638: IF (l_state_level >= l_debug_level) THEN
3639: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg58',
3640: ' IGCCREPB -- Done with ACCT line cursor ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3641: END IF;
3642: -- bug 3199488, end block
3643:

Line 3653: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg59',

3649: -- END IF;
3650:
3651: -- bug 3199488, start block
3652: IF (l_state_level >= l_debug_level) THEN
3653: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg59',
3654: ' IGCCREPB -- Done with cover reval cursor ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3655: END IF;
3656: -- bug 3199488, end block
3657:

Line 3667: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg60',

3663: -- END IF;
3664:
3665: -- bug 3199488, start block
3666: IF (l_state_level >= l_debug_level) THEN
3667: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg60',
3668: ' IGCCREPB -- Validate contract commitment cursor ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3669: END IF;
3670: -- bug 3199488, end block
3671:

Line 3704: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg61',

3700: -- END IF;
3701:
3702: -- bug 3199488, start block
3703: IF (l_state_level >= l_debug_level) THEN
3704: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg61',
3705: ' IGCCREPB -- calling Validate CC ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3706: END IF;
3707: -- bug 3199488, end block
3708:

Line 3724: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg62',

3720: -- END IF;
3721:
3722: -- bug 3199488, start block
3723: IF (l_state_level >= l_debug_level) THEN
3724: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg62',
3725: ' IGCCREPB -- Done calling Validate CC ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3726: END IF;
3727: -- bug 3199488, end block
3728:

Line 3744: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg63',

3740: -- END IF;
3741:
3742: -- bug 3199488, start block
3743: IF (l_state_level >= l_debug_level) THEN
3744: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg63',
3745: ' IGCCREPB -- Checking Preliminary Phase ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3746: END IF;
3747: -- bug 3199488, end block
3748:

Line 3759: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg64',

3755: -- END IF;
3756:
3757: -- bug 3199488, start block
3758: IF (l_state_level >= l_debug_level) THEN
3759: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg64',
3760: ' IGCCREPB -- Preliminary Phase ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3761: END IF;
3762: -- bug 3199488, end block
3763:

Line 3783: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg65',

3779: -- END IF;
3780:
3781: -- bug 3199488, start block
3782: IF (l_state_level >= l_debug_level) THEN
3783: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg65',
3784: ' IGCCREPB -- Checking Cover header type ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3785: END IF;
3786: -- bug 3199488, end block
3787:

Line 3809: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg66',

3805: -- END IF;
3806:
3807: -- bug 3199488, start block
3808: IF (l_state_level >= l_debug_level) THEN
3809: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg66',
3810: ' IGCCREPB -- Done prelim phase ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3811: END IF;
3812: -- bug 3199488, end block
3813:

Line 3823: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg67',

3819: -- END IF;
3820:
3821: -- bug 3199488, start block
3822: IF (l_state_level >= l_debug_level) THEN
3823: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg67',
3824: ' IGCCREPB -- Checking if Final Phase ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3825: END IF;
3826: -- bug 3199488, end block
3827:

Line 3837: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg68',

3833: -- END IF;
3834:
3835: -- bug 3199488, start block
3836: IF (l_state_level >= l_debug_level) THEN
3837: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg68',
3838: ' IGCCREPB -- Final Phase ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3839: END IF;
3840: -- bug 3199488, end block
3841:

Line 3851: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg69',

3847: -- END IF;
3848:
3849: -- bug 3199488, start block
3850: IF (l_state_level >= l_debug_level) THEN
3851: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg69',
3852: ' IGCCREPB -- Passed validation ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3853: END IF;
3854: -- bug 3199488, end block
3855:

Line 3864: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg70',

3860: -- END IF;
3861:
3862: -- bug 3199488, start block
3863: IF (l_state_level >= l_debug_level) THEN
3864: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg70',
3865: ' IGCCREPB -- Updating process data table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3866: END IF;
3867: -- bug 3199488, end block
3868:

Line 3892: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg71',

3888: -- Output_Debug (' IGCCREPB -- Updating Headers table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3889: -- END IF;
3890: -- bug 3199488, start block
3891: IF (l_state_level >= l_debug_level) THEN
3892: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg71',
3893: ' IGCCREPB -- Updating Headers table ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3894: END IF;
3895: -- bug 3199488, end block
3896: UPDATE igc_cc_headers

Line 3909: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg72',

3905: -- END IF;
3906:
3907: -- bug 3199488, start block
3908: IF (l_state_level >= l_debug_level) THEN
3909: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg72',
3910: ' IGCCREPB -- Checking CC type Standard ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3911: END IF;
3912: -- bug 3199488, end block
3913:

Line 3922: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg73',

3918: -- END IF;
3919:
3920: -- bug 3199488, start block
3921: IF (l_state_level >= l_debug_level) THEN
3922: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg73',
3923: ' IGCCREPB -- Standard CC getting PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3924: END IF;
3925: -- bug 3199488, end block
3926:

Line 3947: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg74',

3943: -- Output_Debug (' IGCCREPB -- Checking PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3944: -- END IF;
3945: -- bug 3199488, start block
3946: IF (l_state_level >= l_debug_level) THEN
3947: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg74',
3948: ' IGCCREPB -- Checking PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3949: END IF;
3950: -- bug 3199488, end block
3951: IF (l_po_count = 1)

Line 3960: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg75',' IGCCREPB -- Updating PO Headers ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

3956: -- Output_Debug (' IGCCREPB -- Updating PO Headers ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3957: -- END IF;
3958: -- bug 3199488, start block
3959: IF (l_state_level >= l_debug_level) THEN
3960: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg75',' IGCCREPB -- Updating PO Headers ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3961: END IF;
3962: -- bug 3199488, end block
3963: UPDATE po_headers_all
3964: SET approved_flag = 'N'

Line 3981: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg76',

3977: -- END IF;
3978:
3979: -- bug 3199488, start block
3980: IF (l_state_level >= l_debug_level) THEN
3981: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg76',
3982: ' IGCCREPB -- Checking if Cover Type ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3983: END IF;
3984: -- bug 3199488, end block
3985:

Line 3994: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg77',

3990: -- END IF;
3991:
3992: -- bug 3199488, start block
3993: IF (l_state_level >= l_debug_level) THEN
3994: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg77',
3995: ' IGCCREPB -- Obtain all releases ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
3996: END IF;
3997: -- bug 3199488, end block
3998:

Line 4010: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg78',' IGCCREPB -- Update process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4006: -- END IF;
4007:
4008: -- bug 3199488, start block
4009: IF (l_state_level >= l_debug_level) THEN
4010: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg78',' IGCCREPB -- Update process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4011: END IF;
4012: -- bug 3199488, end block
4013:
4014: UPDATE igc_cc_process_data

Line 4027: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg79',' IGCCREPB -- Update Header data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4023: -- END IF;
4024:
4025: -- bug 3199488, start block
4026: IF (l_state_level >= l_debug_level) THEN
4027: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg79',' IGCCREPB -- Update Header data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4028: END IF;
4029: -- bug 3199488, end block
4030:
4031: UPDATE igc_cc_headers

Line 4043: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg80',' IGCCREPB -- Getting PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4039: -- END IF;
4040:
4041: -- bug 3199488, start block
4042: IF (l_state_level >= l_debug_level) THEN
4043: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg80',' IGCCREPB -- Getting PO line count ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4044: END IF;
4045: -- bug 3199488, end block
4046:
4047: BEGIN

Line 4068: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg81',' IGCCREPB -- Update PO Header data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4064: -- END IF;
4065:
4066: -- bug 3199488, start block
4067: IF (l_state_level >= l_debug_level) THEN
4068: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg81',' IGCCREPB -- Update PO Header data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4069: END IF;
4070: -- bug 3199488, end block
4071:
4072: BEGIN

Line 4092: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg82',

4088: -- END IF;
4089:
4090: -- bug 3199488, start block
4091: IF (l_state_level >= l_debug_level) THEN
4092: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg82',
4093: ' IGCCREPB -- End Releases Loop ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4094: END IF;
4095: -- bug 3199488, end block
4096:

Line 4109: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg83',

4105: -- END IF;
4106:
4107: -- bug 3199488, start block
4108: IF (l_state_level >= l_debug_level) THEN
4109: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg83',
4110: ' IGCCREPB -- Failed validation ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4111: END IF;
4112: -- bug 3199488, end block
4113:

Line 4121: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg84',

4117: -- Output_Debug (' IGCCREPB -- Updating Cover or Standard in process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4118: -- END IF;
4119: -- bug 3199488, start block
4120: IF (l_state_level >= l_debug_level) THEN
4121: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg84',
4122: ' IGCCREPB -- Updating cover or Standard in process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4123: END IF;
4124: -- bug 3199488, end block
4125:

Line 4142: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg85',

4138: -- END IF;
4139:
4140: -- bug 3199488, start block
4141: IF (l_state_level >= l_debug_level) THEN
4142: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg85',
4143: ' IGCCREPB -- Updating Cover process data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4144: END IF;
4145: -- bug 3199488, end block
4146:

Line 4171: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg86',

4167: -- END IF;
4168:
4169: -- bug 3199488, start block
4170: IF (l_state_level >= l_debug_level) THEN
4171: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg86',
4172: ' IGCCREPB -- Done c_reval data ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4173: END IF;
4174: -- bug 3199488, end block
4175:

Line 4185: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg87',

4181: -- END IF;
4182:
4183: -- bug 3199488, start block
4184: IF (l_state_level >= l_debug_level) THEN
4185: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg87',
4186: ' IGCCREPB -- Check if reservation phase is to begin ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4187: END IF;
4188: -- bug 3199488, end block
4189:

Line 4200: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg88',

4196: -- END IF;
4197:
4198: -- bug 3199488, start block
4199: IF (l_state_level >= l_debug_level) THEN
4200: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg88',
4201: ' IGCCREPB -- reservation phase begins ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4202: END IF;
4203: -- bug 3199488, end block
4204:

Line 4230: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg89',

4226: -- END IF;
4227:
4228: -- bug 3199488, start block
4229: IF (l_state_level >= l_debug_level) THEN
4230: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg89',
4231: ' IGCCREPB -- Validation status P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4232: END IF;
4233: -- bug 3199488, end block
4234:

Line 4258: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg90',

4254: -- END IF;
4255:
4256: -- bug 3199488, start block
4257: IF (l_state_level >= l_debug_level) THEN
4258: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg90',
4259: ' IGCCREPB -- Reservation in Forced mode beginning ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4260: END IF;
4261: -- bug 3199488, end block
4262:

Line 4281: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg91', ' IGCCREPB -- Encumber CC call ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4277: -- END IF;
4278:
4279: -- bug 3199488, start block
4280: IF (l_state_level >= l_debug_level) THEN
4281: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg91', ' IGCCREPB -- Encumber CC call ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4282: END IF;
4283: -- bug 3199488, end block
4284:
4285: -- fix bug 2124590 start 1

Line 4357: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg92',

4353: -- END IF;
4354:
4355: -- bug 3199488, start block
4356: IF (l_state_level >= l_debug_level) THEN
4357: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg92',
4358: ' IGCCREPB -- Reval Cover Fail process exceptions ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4359: END IF;
4360: -- bug 3199488, end block
4361:

Line 4396: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg93',

4392: -- END IF;
4393:
4394: -- bug 3199488, start block
4395: IF (l_state_level >= l_debug_level) THEN
4396: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg93',
4397: ' IGCCREPB -- Updating process data after encumber CC ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4398: END IF;
4399: -- bug 3199488, end block
4400:

Line 4416: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg94',

4412: -- END IF;
4413:
4414: -- bug 3199488, start block
4415: IF (l_state_level >= l_debug_level) THEN
4416: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg94',
4417: ' IGCCREPB -- Updating process data after encumber CC for Cover ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4418: END IF;
4419: -- bug 3199488, end block
4420:

Line 4442: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg95',

4438: -- END IF;
4439:
4440: -- bug 3199488, start block
4441: IF (l_state_level >= l_debug_level) THEN
4442: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg95',
4443: ' IGCCREPB -- Getting all releases for Cover ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4444: END IF;
4445: -- bug 3199488, end block
4446:

Line 4476: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg96',' IGCCREPB -- Calling reval_update P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4472: -- Output_Debug (' IGCCREPB -- Calling reval_update P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4473: -- END IF;
4474: -- bug 3199488, start block
4475: IF (l_state_level >= l_debug_level) THEN
4476: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg96',' IGCCREPB -- Calling reval_update P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4477: END IF;
4478: -- bug 3199488, end block
4479: l_message := NULL;
4480: l_err_header_id := NULL;

Line 4508: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg97',' IGCCREPB -- Calling reval_update F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4504: -- END IF;
4505:
4506: -- bug 3199488, start block
4507: IF (l_state_level >= l_debug_level) THEN
4508: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg97',' IGCCREPB -- Calling reval_update F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4509: END IF;
4510: -- bug 3199488, end block
4511:
4512: l_message := NULL;

Line 4541: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg98',' IGCCREPB -- Rolling back Revalues ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4537: -- Output_Debug (' IGCCREPB -- Rolling back Revalues ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4538: -- END IF;
4539: -- bug 3199488, start block
4540: IF (l_state_level >= l_debug_level) THEN
4541: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg98',' IGCCREPB -- Rolling back Revalues ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4542: END IF;
4543: -- bug 3199488, end block
4544: EXIT;
4545: END IF;

Line 4556: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg99',' IGCCREPB -- Done with releases ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4552: -- END IF;
4553:
4554: -- bug 3199488, start block
4555: IF (l_state_level >= l_debug_level) THEN
4556: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg99',' IGCCREPB -- Done with releases ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4557: END IF;
4558: -- bug 3199488, end block
4559:
4560: /* Process the cover */

Line 4567: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg100',' IGCCREPB -- Checking to process Cover ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4563: -- END IF;
4564:
4565: -- bug 3199488, start block
4566: IF (l_state_level >= l_debug_level) THEN
4567: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg100',' IGCCREPB -- Checking to process Cover ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4568: END IF;
4569: -- bug 3199488, end block
4570:
4571: IF (l_process_flag = 'P')

Line 4581: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg101','IGCCREPB -- process Cover ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4577: -- END IF;
4578:
4579: -- bug 3199488, start block
4580: IF (l_state_level >= l_debug_level) THEN
4581: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg101','IGCCREPB -- process Cover ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4582: END IF;
4583: -- bug 3199488, end block
4584:
4585: SELECT validate_only

Line 4599: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg102','IGCCREPB -- Reval Cover Update P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4595: -- Output_Debug (' IGCCREPB -- Reval Cover Update P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4596: -- END IF;
4597: -- bug 3199488, start block
4598: IF (l_state_level >= l_debug_level) THEN
4599: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg102','IGCCREPB -- Reval Cover Update P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4600: END IF;
4601: -- bug 3199488, end block
4602:
4603: l_message := NULL;

Line 4630: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg103','IGCCREPB -- Reval Cover Update F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4626: -- Output_Debug (' IGCCREPB -- Reval Cover Update F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4627: -- END IF;
4628: -- bug 3199488, start block
4629: IF (l_state_level >= l_debug_level) THEN
4630: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg103','IGCCREPB -- Reval Cover Update F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4631: END IF;
4632: -- bug 3199488, end block
4633:
4634: l_message := NULL;

Line 4665: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg104','IGCCREPB -- Rollback Revalues ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4661: -- END IF;
4662:
4663: -- bug 3199488, start block
4664: IF (l_state_level >= l_debug_level) THEN
4665: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg104','IGCCREPB -- Rollback Revalues ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4666: END IF;
4667: -- bug 3199488, end block
4668:
4669: ROLLBACK TO REVALUE5;

Line 4700: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg105','IGCCREPB -- Commit Revalues ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4696: -- END IF;
4697:
4698: -- bug 3199488, start block
4699: IF (l_state_level >= l_debug_level) THEN
4700: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg105','IGCCREPB -- Commit Revalues ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4701: END IF;
4702: -- bug 3199488, end block
4703:
4704: COMMIT;

Line 4714: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg106','IGCCREPB -- Standard reval ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4710: -- END IF;
4711:
4712: -- bug 3199488, start block
4713: IF (l_state_level >= l_debug_level) THEN
4714: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg106','IGCCREPB -- Standard reval ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4715: END IF;
4716: -- bug 3199488, end block
4717:
4718: SAVEPOINT REVALUE6;

Line 4730: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg107','IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));

4726: -- Output_Debug (' IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4727: -- END IF;
4728: -- bug 3199488, start block
4729: IF (l_state_level >= l_debug_level) THEN
4730: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg107','IGCCREPB -- Standard reval P ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4731: END IF;
4732: -- bug 3199488, end block
4733: l_message := NULL;
4734: l_err_header_id := NULL;

Line 4760: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg108',

4756: -- Output_Debug (' IGCCREPB -- Standard reval F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4757: -- END IF;
4758: -- bug 3199488, start block
4759: IF (l_state_level >= l_debug_level) THEN
4760: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg108',
4761: 'IGCCREPB -- Standard reval F ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4762: END IF;
4763: -- bug 3199488, end block
4764:

Line 4794: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg109',

4790: -- Output_Debug (' IGCCREPB -- Standard Rollback revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4791: -- END IF;
4792: -- bug 3199488, start block
4793: IF (l_state_level >= l_debug_level) THEN
4794: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg109',
4795: 'IGCCREPB -- Standard Rollback revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4796: END IF;
4797: -- bug 3199488, end block
4798: ROLLBACK TO REVALUE6;

Line 4829: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg110',

4825: -- Output_Debug (' IGCCREPB -- Standard Commit revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4826: -- END IF;
4827: -- bug 3199488, start block
4828: IF (l_state_level >= l_debug_level) THEN
4829: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg110',
4830: 'IGCCREPB -- Standard Commit revalue ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4831: END IF;
4832: -- bug 3199488, end block
4833: COMMIT;

Line 4848: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg111',

4844: -- END IF;
4845:
4846: -- bug 3199488, start block
4847: IF (l_state_level >= l_debug_level) THEN
4848: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg111',
4849: 'IGCCREPB -- Close revalue Cursor ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4850: END IF;
4851: -- bug 3199488, end block
4852:

Line 4895: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg112',

4891: -- END IF;
4892:
4893: -- bug 3199488, start block
4894: IF (l_state_level >= l_debug_level) THEN
4895: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Msg112',
4896: 'IGCCREPB -- End Main submit request ' || to_char(sysdate,'DD-MON-YY:MI:SS'));
4897: END IF;
4898: -- bug 3199488, end block
4899:

Line 4966: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp3',

4962: -- fnd_file.put_line (FND_FILE.LOG,
4963: -- l_error_text);
4964: -- bug 3199488 start block
4965: IF (l_state_level >= l_debug_level) THEN
4966: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp3',
4967: l_error_text);
4968: END IF;
4969: -- bug 3199488, end block
4970: END LOOP;

Line 4982: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp1',TRUE);

4978: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_main');
4979: END IF;
4980: -- bug 3199488 start block
4981: IF (l_unexp_level >= l_debug_level) THEN
4982: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp1',TRUE);
4983: END IF;
4984: -- bug 3199488, end block
4985: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
4986: p_data => l_msg_data );

Line 4997: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp4',

4993: -- fnd_file.put_line (FND_FILE.LOG,
4994: -- l_error_text);
4995: -- bug 3199488 start block
4996: IF (l_state_level >= l_debug_level) THEN
4997: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp4',
4998: l_error_text);
4999: END IF;
5000: -- bug 3199488, end block
5001: END LOOP;

Line 5008: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp5',

5004: -- fnd_file.put_line (FND_FILE.LOG,
5005: -- l_error_text);
5006: -- bug 3199488 start block
5007: IF (l_state_level >= l_debug_level) THEN
5008: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp5',
5009: l_error_text);
5010: END IF;
5011: -- bug 3199488, end block
5012: END IF;

Line 5024: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp2',TRUE);

5020: IF (l_unexp_level >= l_debug_level) THEN
5021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');
5022: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
5023: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
5024: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp2',TRUE);
5025: END IF;
5026: -- bug 3199488, end block
5027: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
5028: p_data => l_msg_data );

Line 5039: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp6',

5035: -- fnd_file.put_line (FND_FILE.LOG,
5036: -- l_error_text);
5037: -- bug 3199488 start block
5038: IF (l_state_level >= l_debug_level) THEN
5039: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp6',
5040: l_error_text);
5041: END IF;
5042: -- bug 3199488, end block
5043: END LOOP;

Line 5050: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp7',

5046: -- fnd_file.put_line (FND_FILE.LOG,
5047: -- l_error_text);
5048: -- bug 3199488 start block
5049: IF (l_state_level >= l_debug_level) THEN
5050: FND_LOG.STRING(l_state_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Excp7',
5051: l_error_text);
5052: END IF;
5053: -- bug 3199488, end block
5054: END IF;

Line 5058: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5054: END IF;
5055:
5056: END revalue_main;
5057: BEGIN
5058: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5059: l_state_level := FND_LOG.LEVEL_STATEMENT;
5060: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
5061: l_event_level := FND_LOG.LEVEL_EVENT;
5062: l_excep_level := FND_LOG.LEVEL_EXCEPTION;

Line 5059: l_state_level := FND_LOG.LEVEL_STATEMENT;

5055:
5056: END revalue_main;
5057: BEGIN
5058: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5059: l_state_level := FND_LOG.LEVEL_STATEMENT;
5060: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
5061: l_event_level := FND_LOG.LEVEL_EVENT;
5062: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
5063: l_error_level := FND_LOG.LEVEL_ERROR;

Line 5060: l_proc_level := FND_LOG.LEVEL_PROCEDURE;

5056: END revalue_main;
5057: BEGIN
5058: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5059: l_state_level := FND_LOG.LEVEL_STATEMENT;
5060: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
5061: l_event_level := FND_LOG.LEVEL_EVENT;
5062: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
5063: l_error_level := FND_LOG.LEVEL_ERROR;
5064: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

Line 5061: l_event_level := FND_LOG.LEVEL_EVENT;

5057: BEGIN
5058: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5059: l_state_level := FND_LOG.LEVEL_STATEMENT;
5060: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
5061: l_event_level := FND_LOG.LEVEL_EVENT;
5062: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
5063: l_error_level := FND_LOG.LEVEL_ERROR;
5064: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
5065:

Line 5062: l_excep_level := FND_LOG.LEVEL_EXCEPTION;

5058: l_debug_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5059: l_state_level := FND_LOG.LEVEL_STATEMENT;
5060: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
5061: l_event_level := FND_LOG.LEVEL_EVENT;
5062: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
5063: l_error_level := FND_LOG.LEVEL_ERROR;
5064: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
5065:
5066: l_debug_mode := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');

Line 5063: l_error_level := FND_LOG.LEVEL_ERROR;

5059: l_state_level := FND_LOG.LEVEL_STATEMENT;
5060: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
5061: l_event_level := FND_LOG.LEVEL_EVENT;
5062: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
5063: l_error_level := FND_LOG.LEVEL_ERROR;
5064: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
5065:
5066: l_debug_mode := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
5067: g_debug_flag := 'N' ;

Line 5064: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;

5060: l_proc_level := FND_LOG.LEVEL_PROCEDURE;
5061: l_event_level := FND_LOG.LEVEL_EVENT;
5062: l_excep_level := FND_LOG.LEVEL_EXCEPTION;
5063: l_error_level := FND_LOG.LEVEL_ERROR;
5064: l_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
5065:
5066: l_debug_mode := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
5067: g_debug_flag := 'N' ;
5068: g_debug_msg := NULL;