57: x_return_status := fnd_api.g_ret_sts_success;
58:
59: -- Initialize message list and count if needed
60: IF p_init_msg_list = fnd_api.g_true THEN
61: fnd_msg_pub.initialize;
62: gme_common_pvt.g_error_count := 0;
63: END IF;
64:
65: gme_common_pvt.set_timestamp;
180: END IF;
181:
182: -- Initialize message list and count if needed
183: IF p_init_msg_list = fnd_api.g_true THEN
184: fnd_msg_pub.initialize;
185: gme_common_pvt.g_error_count := 0;
186: END IF;
187:
188: /* Set the return status to success initially */
228: END IF;
229:
230: ROLLBACK TO SAVEPOINT create_phantom;
231: x_material_detail_rec := NULL;
232: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
233: gme_common_pvt.count_and_get (x_count => x_message_count
234: ,p_encoded => fnd_api.g_false
235: ,x_data => x_message_list);
236: x_return_status := fnd_api.g_ret_sts_unexp_error;
283:
284:
285: /* Initialize message list and count if needed */
286: IF p_init_msg_list = fnd_api.g_true THEN
287: fnd_msg_pub.initialize;
288: gme_common_pvt.g_error_count := 0;
289: END IF;
290:
291: x_batch_header_rec := p_batch_header_rec;
336: ,x_data => x_message_list);
337: WHEN OTHERS THEN
338: ROLLBACK TO SAVEPOINT scale_batch;
339: x_batch_header_rec := NULL;
340: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
341: gme_common_pvt.count_and_get (x_count => x_message_count
342: ,p_encoded => fnd_api.g_false
343: ,x_data => x_message_list);
344: x_return_status := fnd_api.g_ret_sts_unexp_error;
384: END IF;
385:
386: /* Initialize message list and count if needed */
387: IF p_init_msg_list = fnd_api.g_true THEN
388: fnd_msg_pub.initialize;
389: gme_common_pvt.g_error_count := 0;
390: END IF;
391:
392: gme_common_pvt.set_timestamp;
422: ,p_encoded => fnd_api.g_false
423: ,x_data => x_message_list);
424: WHEN OTHERS THEN
425: ROLLBACK TO SAVEPOINT theoretical_yield_batch;
426: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
427: gme_common_pvt.count_and_get (x_count => x_message_count
428: ,p_encoded => fnd_api.g_false
429: ,x_data => x_message_list);
430: x_return_status := fnd_api.g_ret_sts_unexp_error;
482: END IF;
483:
484: -- Initialize message list and count if needed
485: IF p_init_msg_list = fnd_api.g_true THEN
486: fnd_msg_pub.initialize;
487: gme_common_pvt.g_error_count := 0;
488: END IF;
489:
490: gme_common_pvt.set_timestamp;
641: END IF;
642:
643: -- Initialize message list and count if needed
644: IF p_init_msg_list = fnd_api.g_true THEN
645: fnd_msg_pub.initialize;
646: gme_common_pvt.g_error_count := 0;
647: END IF;
648:
649: gme_common_pvt.set_timestamp;
764: END IF;
765:
766: -- Initialize message list and count if needed
767: IF p_init_msg_list = fnd_api.g_true THEN
768: fnd_msg_pub.initialize;
769: gme_common_pvt.g_error_count := 0;
770: END IF;
771:
772: gme_common_pvt.set_timestamp;
919: x_return_status := fnd_api.g_ret_sts_success;
920:
921: -- Initialize message list and count if needed
922: IF p_init_msg_list = fnd_api.g_true THEN
923: fnd_msg_pub.initialize;
924: gme_common_pvt.g_error_count := 0;
925: END IF;
926:
927: gme_common_pvt.set_timestamp;
1044: END IF;
1045:
1046: -- Initialize message list and count if needed
1047: IF p_init_msg_list = fnd_api.g_true THEN
1048: fnd_msg_pub.initialize;
1049: gme_common_pvt.g_error_count := 0;
1050: END IF;
1051:
1052: gme_common_pvt.set_timestamp;
1200: END IF;
1201:
1202: -- Initialize message list and count if needed
1203: IF p_init_msg_list = fnd_api.g_true THEN
1204: fnd_msg_pub.initialize;
1205: gme_common_pvt.g_error_count := 0;
1206: END IF;
1207:
1208: gme_common_pvt.set_timestamp;
1305: END IF;
1306:
1307: /* Initialize message list and count if needed */
1308: IF p_init_msg_list = fnd_api.g_true THEN
1309: fnd_msg_pub.initialize;
1310: gme_common_pvt.g_error_count := 0;
1311: END IF;
1312:
1313: gme_common_pvt.set_timestamp;
1366: ,x_data => x_message_list);
1367: WHEN OTHERS THEN
1368: ROLLBACK TO SAVEPOINT reschedule_batch;
1369: x_batch_header_rec := NULL;
1370: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1371: gme_common_pvt.count_and_get (x_count => x_message_count
1372: ,p_encoded => fnd_api.g_false
1373: ,x_data => x_message_list);
1374: x_return_status := fnd_api.g_ret_sts_unexp_error;
1422: END IF;
1423:
1424: /* Initialize message list and count if needed */
1425: IF p_init_msg_list = fnd_api.g_true THEN
1426: fnd_msg_pub.initialize;
1427: gme_common_pvt.g_error_count := 0;
1428: END IF;
1429:
1430: gme_common_pvt.set_timestamp;
1491: x_return_status := fnd_api.g_ret_sts_error;
1492: WHEN OTHERS THEN
1493: ROLLBACK TO SAVEPOINT reschedule_batch_step;
1494: x_batch_step_rec := NULL;
1495: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1496: gme_common_pvt.count_and_get (x_count => x_message_count
1497: ,p_encoded => fnd_api.g_false
1498: ,x_data => x_message_list);
1499: x_return_status := fnd_api.g_ret_sts_unexp_error;
1536: x_return_status := fnd_api.g_ret_sts_success;
1537:
1538: -- Initialize message list and count if needed
1539: IF p_init_msg_list = fnd_api.g_true THEN
1540: fnd_msg_pub.initialize;
1541: gme_common_pvt.g_error_count := 0;
1542: END IF;
1543:
1544: gme_common_pvt.set_timestamp;
1634: x_return_status := fnd_api.g_ret_sts_success;
1635:
1636: -- Initialize message list and count if needed
1637: IF p_init_msg_list = fnd_api.g_true THEN
1638: fnd_msg_pub.initialize;
1639: gme_common_pvt.g_error_count := 0;
1640: END IF;
1641:
1642: gme_common_pvt.set_timestamp;
1773: x_return_status := fnd_api.g_ret_sts_success;
1774:
1775: -- Initialize message list and count if needed
1776: IF p_init_msg_list = fnd_api.g_true THEN
1777: fnd_msg_pub.initialize;
1778: gme_common_pvt.g_error_count := 0;
1779: END IF;
1780:
1781: gme_common_pvt.set_timestamp;
1889: x_return_status := fnd_api.g_ret_sts_success;
1890:
1891: -- Initialize message list and count if needed
1892: IF p_init_msg_list = fnd_api.g_true THEN
1893: fnd_msg_pub.initialize;
1894: gme_common_pvt.g_error_count := 0;
1895: END IF;
1896:
1897: gme_common_pvt.set_timestamp;
2004: x_return_status := fnd_api.g_ret_sts_success;
2005:
2006: -- Initialize message list and count if needed
2007: IF p_init_msg_list = fnd_api.g_true THEN
2008: fnd_msg_pub.initialize;
2009: gme_common_pvt.g_error_count := 0;
2010: END IF;
2011:
2012: gme_common_pvt.set_timestamp;
2118: x_return_status := fnd_api.g_ret_sts_success;
2119:
2120: -- Initialize message list and count if needed
2121: IF p_init_msg_list = fnd_api.g_true THEN
2122: fnd_msg_pub.initialize;
2123: gme_common_pvt.g_error_count := 0;
2124: END IF;
2125:
2126: gme_common_pvt.set_timestamp;
2232: END IF;
2233: END IF;
2234: /* Initialize message list and count if needed */
2235: IF p_init_msg_list = fnd_api.g_true THEN
2236: fnd_msg_pub.initialize;
2237: gme_common_pvt.g_error_count := 0;
2238: END IF;
2239:
2240: /* Punit Kumar */
2293: ,p_encoded => fnd_api.g_false
2294: ,x_data => x_message_list);
2295: WHEN OTHERS THEN
2296: ROLLBACK TO SAVEPOINT delete_step;
2297: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2298: gme_common_pvt.count_and_get (x_count => x_message_count
2299: ,p_encoded => fnd_api.g_false
2300: ,x_data => x_message_list);
2301: x_return_status := fnd_api.g_ret_sts_unexp_error;
2355: RAISE setup_failure;
2356: END IF;
2357: END IF;
2358: IF p_init_msg_list = fnd_api.g_true THEN
2359: fnd_msg_pub.initialize;
2360: gme_common_pvt.g_error_count := 0;
2361: END IF;
2362:
2363: /* Punit Kumar */
2430: ,x_data => x_message_list);
2431: WHEN OTHERS THEN
2432: ROLLBACK TO SAVEPOINT insert_step;
2433: x_batch_step := NULL;
2434: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2435: gme_common_pvt.count_and_get (x_count => x_message_count
2436: ,p_encoded => fnd_api.g_false
2437: ,x_data => x_message_list);
2438: x_return_status := fnd_api.g_ret_sts_unexp_error;
2480: END IF;
2481:
2482: -- Initialize message list and count if needed
2483: IF p_init_msg_list = fnd_api.g_true THEN
2484: fnd_msg_pub.initialize;
2485: gme_common_pvt.g_error_count := 0;
2486: END IF;
2487:
2488: gme_common_pvt.set_timestamp;
2611: END IF;
2612:
2613: -- Initialize message list and count if needed
2614: IF p_init_msg_list = fnd_api.g_true THEN
2615: fnd_msg_pub.initialize;
2616: gme_common_pvt.g_error_count := 0;
2617: END IF;
2618:
2619: gme_common_pvt.set_timestamp;
2736: END IF;
2737:
2738: /* Initialize message list and count if needed */
2739: IF p_init_msg_list = fnd_api.g_true THEN
2740: fnd_msg_pub.initialize;
2741: gme_common_pvt.g_error_count := 0;
2742: END IF;
2743:
2744: gme_common_pvt.set_timestamp;
2795: ,x_data => x_message_list);
2796: WHEN OTHERS THEN
2797: ROLLBACK TO SAVEPOINT close_batch;
2798: x_batch_header_rec := NULL;
2799: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2800: gme_common_pvt.count_and_get (x_count => x_message_count
2801: ,p_encoded => fnd_api.g_false
2802: ,x_data => x_message_list);
2803: x_return_status := fnd_api.g_ret_sts_unexp_error;
2848: END IF;
2849: END IF;
2850: /* Initialize message list and count if needed */
2851: IF p_init_msg_list = fnd_api.g_true THEN
2852: fnd_msg_pub.initialize;
2853: gme_common_pvt.g_error_count := 0;
2854: END IF;
2855:
2856: gme_common_pvt.set_timestamp;
2890: ,x_data => x_message_list);
2891: WHEN OTHERS THEN
2892: ROLLBACK TO SAVEPOINT close_batch_step;
2893: x_batch_step_rec := NULL;
2894: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2895: /*N Punit Kumar */
2896: gme_common_pvt.count_and_get (x_count => x_message_count
2897: ,p_encoded => fnd_api.g_false
2898: ,x_data => x_message_list);
2930: END IF;
2931:
2932: /* Initialize message list and count if needed*/
2933: IF p_init_msg_list = fnd_api.g_true THEN
2934: fnd_msg_pub.initialize;
2935: gme_common_pvt.g_error_count := 0;
2936: END IF;
2937:
2938: /* Set the success staus to success inititally*/
3028: ||'reopen_batch error : OTHERS.' || SQLCODE
3029: );
3030: END IF;
3031:
3032: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3033:
3034: gme_common_pvt.count_and_get (x_count => x_message_count
3035: ,p_encoded => fnd_api.g_false
3036: ,x_data => x_message_list);
3060: SAVEPOINT reopen_batch_step;
3061:
3062: /* Initialize message list and count if needed*/
3063: IF p_init_msg_list = fnd_api.g_true THEN
3064: fnd_msg_pub.initialize;
3065: gme_common_pvt.g_error_count := 0; /* Punit Kumar */
3066: END IF;
3067:
3068: IF (g_debug IS NOT NULL) THEN
3168: ||'reopen_step error : OTHERS.' || SQLCODE
3169: );
3170: END IF;
3171:
3172: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3173: /* Punit Kumar */
3174: gme_common_pvt.count_and_get (x_count => x_message_count
3175: ,p_encoded => fnd_api.g_false
3176: ,x_data => x_message_list);
3245: END IF;
3246:
3247: /* Initialize message list and count if needed */
3248: IF p_init_msg_list = fnd_api.g_true THEN
3249: fnd_msg_pub.initialize;
3250: gme_common_pvt.g_error_count := 0;
3251: END IF;
3252:
3253: gme_common_pvt.set_timestamp;
3318: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' in exception block; x_return_status= '||x_return_status);
3319: END IF;
3320: WHEN OTHERS THEN
3321: ROLLBACK TO SAVEPOINT incremental_backflush;
3322: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3323: gme_common_pvt.count_and_get (x_count => x_message_count
3324: ,p_encoded => fnd_api.g_false
3325: ,x_data => x_message_list);
3326: x_return_status := fnd_api.g_ret_sts_unexp_error;
3375: || 'Entering');
3376: END IF;
3377:
3378: IF (fnd_api.to_boolean (p_init_msg_list) ) THEN
3379: fnd_msg_pub.initialize;
3380: gme_common_pvt.g_error_count := 0;
3381: END IF;
3382:
3383: /* Set the return status to success initially */
3469: ,p_encoded => fnd_api.g_false
3470: ,x_data => x_message_list);
3471: WHEN OTHERS THEN
3472: ROLLBACK TO SAVEPOINT reroute_batch_main;
3473: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3474: x_batch_header_rec := NULL;
3475: x_return_status := fnd_api.g_ret_sts_unexp_error;
3476:
3477: IF (NVL (g_debug, 0) > 0) THEN
3544: END IF;
3545:
3546: -- Initialize message list and count if needed
3547: IF p_init_msg_list = fnd_api.g_true THEN
3548: fnd_msg_pub.initialize;
3549: gme_common_pvt.g_error_count := 0;
3550: END IF;
3551:
3552: gme_common_pvt.set_timestamp;
3695: END IF;
3696:
3697: -- Initialize message list and count if needed
3698: IF p_init_msg_list = fnd_api.g_true THEN
3699: fnd_msg_pub.initialize;
3700: gme_common_pvt.g_error_count := 0;
3701: END IF;
3702:
3703: gme_common_pvt.set_timestamp;
3795: || ' Error is '
3796: || SQLERRM);
3797: END IF;
3798:
3799: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3800: gme_common_pvt.count_and_get (x_count => x_message_count
3801: ,p_encoded => fnd_api.g_false
3802: ,x_data => x_message_list);
3803: x_return_status := fnd_api.g_ret_sts_unexp_error;
3844: x_return_status := fnd_api.g_ret_sts_success;
3845:
3846: -- Initialize message list and count if needed
3847: IF p_init_msg_list = fnd_api.g_true THEN
3848: fnd_msg_pub.initialize;
3849: gme_common_pvt.g_error_count := 0;
3850: END IF;
3851:
3852: gme_common_pvt.set_timestamp;
3951: x_return_status := fnd_api.g_ret_sts_success;
3952:
3953: -- Initialize message list and count if needed
3954: IF p_init_msg_list = fnd_api.g_true THEN
3955: fnd_msg_pub.initialize;
3956: gme_common_pvt.g_error_count := 0;
3957: END IF;
3958:
3959: gme_common_pvt.set_timestamp;
4054: END IF;
4055:
4056: -- Initialize message list and count if needed
4057: IF p_init_msg_list = fnd_api.g_true THEN
4058: fnd_msg_pub.initialize;
4059: gme_common_pvt.g_error_count := 0;
4060: END IF;
4061:
4062: /* Set the return status to success initially */
4095: || SQLERRM);
4096: END IF;
4097:
4098: ROLLBACK TO SAVEPOINT auto_detail_line;
4099: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4100: gme_common_pvt.count_and_get (x_count => x_message_count
4101: ,p_encoded => fnd_api.g_false
4102: ,x_data => x_message_list);
4103: x_return_status := fnd_api.g_ret_sts_unexp_error;
4138: END IF;
4139:
4140: -- Initialize message list and count if needed
4141: IF p_init_msg_list = fnd_api.g_true THEN
4142: fnd_msg_pub.initialize;
4143: gme_common_pvt.g_error_count := 0;
4144: END IF;
4145:
4146: /* Set the return status to success initially */
4178: || SQLERRM);
4179: END IF;
4180:
4181: ROLLBACK TO SAVEPOINT auto_detail_batch;
4182: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4183: gme_common_pvt.count_and_get (x_count => x_message_count,
4184: p_encoded => fnd_api.g_false,
4185: x_data => x_message_list);
4186: x_return_status := fnd_api.g_ret_sts_unexp_error;
4227: x_return_status := fnd_api.g_ret_sts_success;
4228:
4229: -- Initialize message list and count if needed
4230: IF p_init_msg_list = fnd_api.g_true THEN
4231: fnd_msg_pub.initialize;
4232: gme_common_pvt.g_error_count := 0;
4233: END IF;
4234:
4235: gme_common_pvt.set_timestamp;
4331: x_return_status := fnd_api.g_ret_sts_success;
4332:
4333: -- Initialize message list and count if needed
4334: IF p_init_msg_list = fnd_api.g_true THEN
4335: fnd_msg_pub.initialize;
4336: gme_common_pvt.g_error_count := 0;
4337: END IF;
4338:
4339: gme_common_pvt.set_timestamp;
4435: x_return_status := fnd_api.g_ret_sts_success;
4436:
4437: -- Initialize message list and count if needed
4438: IF p_init_msg_list = fnd_api.g_true THEN
4439: fnd_msg_pub.initialize;
4440: gme_common_pvt.g_error_count := 0;
4441: END IF;
4442:
4443: gme_common_pvt.set_timestamp;