35: BEGIN
36:
37: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
38:
39: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
40: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
41:
42: ELSIF p_rowid IS NOT NULL THEN
43:
36:
37: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
38:
39: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
40: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
41:
42: ELSIF p_rowid IS NOT NULL THEN
43:
44: UPDATE MTH_ASSET_ERR SET
155: BEGIN
156:
157: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
158:
159: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
160: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
161:
162: ELSIF p_rowid IS NOT NULL THEN
163:
156:
157: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
158:
159: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
160: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
161:
162: ELSIF p_rowid IS NOT NULL THEN
163:
164: UPDATE MTH_DAY_ERR SET
199: BEGIN
200:
201: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
202:
203: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
204: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
205:
206: ELSIF p_rowid IS NOT NULL THEN
207:
200:
201: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
202:
203: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
204: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
205:
206: ELSIF p_rowid IS NOT NULL THEN
207:
208: UPDATE MTH_DIM_HIERARCHY_ERR SET
252: BEGIN
253:
254: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
255:
256: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
257: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
258:
259: ELSIF p_rowid IS NOT NULL THEN
260:
253:
254: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
255:
256: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
257: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
258:
259: ELSIF p_rowid IS NOT NULL THEN
260:
261: UPDATE MTH_DIM_LEVEL_LOOKUP_ERR SET
302: BEGIN
303:
304: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
305:
306: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
307: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
308:
309: ELSIF p_rowid IS NOT NULL THEN
310:
303:
304: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
305:
306: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
307: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
308:
309: ELSIF p_rowid IS NOT NULL THEN
310:
311: UPDATE MTH_ENTITY_PLANNED_USAGE_ERR SET
379: BEGIN
380:
381: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
382:
383: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
384: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
385:
386: ELSIF p_rowid IS NOT NULL THEN
387:
380:
381: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
382:
383: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
384: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
385:
386: ELSIF p_rowid IS NOT NULL THEN
387:
388: UPDATE MTH_EQUIPMENTS_ERR SET
509: BEGIN
510:
511: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
512:
513: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
514: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
515:
516: ELSIF p_rowid IS NOT NULL THEN
517:
510:
511: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
512:
513: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
514: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
515:
516: ELSIF p_rowid IS NOT NULL THEN
517:
518: UPDATE MTH_EQUIPMENT_REASON_SETUP_ERR SET
559: BEGIN
560:
561: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
562:
563: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
564: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
565:
566: ELSIF p_rowid IS NOT NULL THEN
567:
560:
561: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
562:
563: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
564: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
565:
566: ELSIF p_rowid IS NOT NULL THEN
567:
568: UPDATE MTH_EQUIPMENT_SHIFTS_ERR SET
635: BEGIN
636:
637: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
638:
639: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
640: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
641:
642: ELSIF p_rowid IS NOT NULL THEN
643:
636:
637: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
638:
639: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
640: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
641:
642: ELSIF p_rowid IS NOT NULL THEN
643:
644: UPDATE MTH_EQUIP_ENTITIES_ERR SET
737: BEGIN
738:
739: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
740:
741: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
742: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
743:
744: ELSIF p_rowid IS NOT NULL THEN
745:
738:
739: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
740:
741: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
742: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
743:
744: ELSIF p_rowid IS NOT NULL THEN
745:
746: UPDATE MTH_EQUIP_HIERARCHY_ERR SET
817: BEGIN
818:
819: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
820:
821: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
822: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
823:
824: ELSIF p_rowid IS NOT NULL THEN
825:
818:
819: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
820:
821: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
822: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
823:
824: ELSIF p_rowid IS NOT NULL THEN
825:
826: UPDATE MTH_EQUIP_OUTPUT_ERR SET
971: BEGIN
972:
973: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
974:
975: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
976: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
977:
978: ELSIF p_rowid IS NOT NULL THEN
979:
972:
973: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
974:
975: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
976: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
977:
978: ELSIF p_rowid IS NOT NULL THEN
979:
980: UPDATE MTH_EQUIP_PROD_SCHEDULE_ERR SET
1110: BEGIN
1111:
1112: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1113:
1114: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1115: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1116:
1117: ELSIF p_rowid IS NOT NULL THEN
1118:
1111:
1112: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1113:
1114: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1115: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1116:
1117: ELSIF p_rowid IS NOT NULL THEN
1118:
1119: UPDATE MTH_EQUIP_STANDARD_RATES_ERR SET
1237: BEGIN
1238:
1239: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1240:
1241: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1242: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1243:
1244: ELSIF p_rowid IS NOT NULL THEN
1245:
1238:
1239: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1240:
1241: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1242: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1243:
1244: ELSIF p_rowid IS NOT NULL THEN
1245:
1246: UPDATE MTH_EQUIP_STATUSES_ERR SET
1342: BEGIN
1343:
1344: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1345:
1346: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1347: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1348:
1349: ELSIF p_rowid IS NOT NULL THEN
1350:
1343:
1344: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1345:
1346: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1347: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1348:
1349: ELSIF p_rowid IS NOT NULL THEN
1350:
1351: UPDATE MTH_EVENT_ACTION_SETUP_ERR SET
1448: BEGIN
1449:
1450: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1451:
1452: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1453: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1454:
1455: ELSIF p_rowid IS NOT NULL THEN
1456:
1449:
1450: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1451:
1452: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1453: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1454:
1455: ELSIF p_rowid IS NOT NULL THEN
1456:
1457: UPDATE MTH_ITEMS_ERR SET
1660: BEGIN
1661:
1662: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1663:
1664: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1665: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1666:
1667: ELSIF p_rowid IS NOT NULL THEN
1668:
1661:
1662: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1663:
1664: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1665: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1666:
1667: ELSIF p_rowid IS NOT NULL THEN
1668:
1669: UPDATE MTH_ITEM_CATEGORIES_ERR SET
1806: BEGIN
1807:
1808: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1809:
1810: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1811: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1812:
1813: ELSIF p_rowid IS NOT NULL THEN
1814:
1807:
1808: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1809:
1810: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1811: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1812:
1813: ELSIF p_rowid IS NOT NULL THEN
1814:
1815: UPDATE MTH_ITEM_COST_ERR SET
1874: BEGIN
1875:
1876: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1877:
1878: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1879: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1880:
1881: ELSIF p_rowid IS NOT NULL THEN
1882:
1875:
1876: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1877:
1878: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1879: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1880:
1881: ELSIF p_rowid IS NOT NULL THEN
1882:
1883: UPDATE MTH_ITEM_HIERARCHY_ERR SET
1928: BEGIN
1929:
1930: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1931:
1932: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1933: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1934:
1935: ELSIF p_rowid IS NOT NULL THEN
1936:
1929:
1930: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
1931:
1932: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
1933: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
1934:
1935: ELSIF p_rowid IS NOT NULL THEN
1936:
1937: UPDATE MTH_METER_READINGS_ERR SET
2015: BEGIN
2016:
2017: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2018:
2019: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2020: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2021:
2022: ELSIF p_rowid IS NOT NULL THEN
2023:
2016:
2017: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2018:
2019: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2020: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2021:
2022: ELSIF p_rowid IS NOT NULL THEN
2023:
2024: UPDATE MTH_MTL_CONSUMED_TXN_LOT_ERR SET
2162: BEGIN
2163:
2164: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2165:
2166: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2167: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2168:
2169: ELSIF p_rowid IS NOT NULL THEN
2170:
2163:
2164: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2165:
2166: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2167: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2168:
2169: ELSIF p_rowid IS NOT NULL THEN
2170:
2171: UPDATE MTH_MTL_PRODUCED_TXN_LOT_ERR SET
2288: BEGIN
2289:
2290: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
2291:
2292: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2293: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2294:
2295: ELSIF p_rowid IS NOT NULL THEN
2296:
2289:
2290: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
2291:
2292: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2293: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2294:
2295: ELSIF p_rowid IS NOT NULL THEN
2296:
2297: UPDATE MTH_PERIOD_ERR SET
2358: BEGIN
2359:
2360: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2361:
2362: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2363: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2364:
2365: ELSIF p_rowid IS NOT NULL THEN
2366:
2359:
2360: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2361:
2362: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2363: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2364:
2365: ELSIF p_rowid IS NOT NULL THEN
2366:
2367: UPDATE MTH_PERSONNEL_ERR SET
2546: BEGIN
2547:
2548: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2549:
2550: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2551: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2552:
2553: ELSIF p_rowid IS NOT NULL THEN
2554:
2547:
2548: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2549:
2550: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2551: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2552:
2553: ELSIF p_rowid IS NOT NULL THEN
2554:
2555: UPDATE MTH_PRODUCTION_SCHEDULES_ERR SET
2826: BEGIN
2827:
2828: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2829:
2830: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2831: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2832:
2833: ELSIF p_rowid IS NOT NULL THEN
2834:
2827:
2828: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
2829:
2830: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
2831: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
2832:
2833: ELSIF p_rowid IS NOT NULL THEN
2834:
2835: UPDATE MTH_PRODUCTION_SEGMENTS_ERR SET
3000: BEGIN
3001:
3002: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3003:
3004: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3005: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3006:
3007: ELSIF p_rowid IS NOT NULL THEN
3008:
3001:
3002: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3003:
3004: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3005: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3006:
3007: ELSIF p_rowid IS NOT NULL THEN
3008:
3009: UPDATE MTH_PROD_MTL_CONSUMED_ERR SET
3158: BEGIN
3159:
3160: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3161:
3162: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3163: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3164:
3165: ELSIF p_rowid IS NOT NULL THEN
3166:
3159:
3160: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3161:
3162: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3163: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3164:
3165: ELSIF p_rowid IS NOT NULL THEN
3166:
3167: UPDATE MTH_PROD_MTL_CONSUMED_TXN_ERR SET
3310: BEGIN
3311:
3312: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3313:
3314: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3315: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3316:
3317: ELSIF p_rowid IS NOT NULL THEN
3318:
3311:
3312: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3313:
3314: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3315: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3316:
3317: ELSIF p_rowid IS NOT NULL THEN
3318:
3319: UPDATE MTH_PROD_MTL_PRODUCED_ERR SET
3474: BEGIN
3475:
3476: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3477:
3478: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3479: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3480:
3481: ELSIF p_rowid IS NOT NULL THEN
3482:
3475:
3476: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3477:
3478: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3479: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3480:
3481: ELSIF p_rowid IS NOT NULL THEN
3482:
3483: UPDATE MTH_PROD_MTL_PRODUCED_TXN_ERR SET
3621: BEGIN
3622:
3623: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3624:
3625: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3626: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3627:
3628: ELSIF p_rowid IS NOT NULL THEN
3629:
3622:
3623: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3624:
3625: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3626: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3627:
3628: ELSIF p_rowid IS NOT NULL THEN
3629:
3630: UPDATE MTH_PROD_SEGMENTS_TXN_ERR SET
3759: BEGIN
3760:
3761: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3762:
3763: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3764: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3765:
3766: ELSIF p_rowid IS NOT NULL THEN
3767:
3760:
3761: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3762:
3763: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3764: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3765:
3766: ELSIF p_rowid IS NOT NULL THEN
3767:
3768: UPDATE MTH_PROD_SUB_SEGMENTS_ERR SET
3858: BEGIN
3859:
3860: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
3861:
3862: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3863: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3864:
3865: ELSIF p_rowid IS NOT NULL THEN
3866:
3859:
3860: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
3861:
3862: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3863: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3864:
3865: ELSIF p_rowid IS NOT NULL THEN
3866:
3867: UPDATE MTH_QUARTER_ERR SET
3942: BEGIN
3943:
3944: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3945:
3946: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3947: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3948:
3949: ELSIF p_rowid IS NOT NULL THEN
3950:
3943:
3944: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
3945:
3946: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
3947: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
3948:
3949: ELSIF p_rowid IS NOT NULL THEN
3950:
3951: UPDATE MTH_RESOURCES_ERR SET
4112: BEGIN
4113:
4114: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4115:
4116: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4117: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4118:
4119: ELSIF p_rowid IS NOT NULL THEN
4120:
4113:
4114: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4115:
4116: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4117: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4118:
4119: ELSIF p_rowid IS NOT NULL THEN
4120:
4121: UPDATE MTH_RESOURCE_COST_ERR SET
4200: BEGIN
4201:
4202: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4203:
4204: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4205: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4206:
4207: ELSIF p_rowid IS NOT NULL THEN
4208:
4201:
4202: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4203:
4204: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4205: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4206:
4207: ELSIF p_rowid IS NOT NULL THEN
4208:
4209: UPDATE MTH_RESOURCE_REQUIREMENTS_ERR SET
4330: BEGIN
4331:
4332: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4333:
4334: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4335: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4336:
4337: ELSIF p_rowid IS NOT NULL THEN
4338:
4331:
4332: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4333:
4334: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4335: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4336:
4337: ELSIF p_rowid IS NOT NULL THEN
4338:
4339: UPDATE MTH_RESOURCE_TXN_ERR SET
4458: BEGIN
4459:
4460: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4461:
4462: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4463: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4464:
4465: ELSIF p_rowid IS NOT NULL THEN
4466:
4459:
4460: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4461:
4462: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4463: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4464:
4465: ELSIF p_rowid IS NOT NULL THEN
4466:
4467: UPDATE MTH_TAG_MASTER_ERR SET
4562: BEGIN
4563:
4564: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
4565:
4566: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4567: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4568:
4569: ELSIF p_rowid IS NOT NULL THEN
4570:
4563:
4564: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
4565:
4566: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4567: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4568:
4569: ELSIF p_rowid IS NOT NULL THEN
4570:
4571: UPDATE MTH_TIME_HIERARCHY_ERR SET
4608: BEGIN
4609:
4610: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4611:
4612: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4613: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4614:
4615: ELSIF p_rowid IS NOT NULL THEN
4616:
4609:
4610: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4611:
4612: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4613: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4614:
4615: ELSIF p_rowid IS NOT NULL THEN
4616:
4617: UPDATE MTH_USER_DIM_ENTITIES_ERR SET
4689: BEGIN
4690:
4691: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4692:
4693: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4694: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4695:
4696: ELSIF p_rowid IS NOT NULL THEN
4697:
4690:
4691: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4692:
4693: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4694: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4695:
4696: ELSIF p_rowid IS NOT NULL THEN
4697:
4698: UPDATE MTH_USER_DIM_HIERARCHY_ERR SET
4752: BEGIN
4753:
4754: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
4755:
4756: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4757: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4758:
4759: ELSIF p_rowid IS NOT NULL THEN
4760:
4753:
4754: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
4755:
4756: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4757: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4758:
4759: ELSIF p_rowid IS NOT NULL THEN
4760:
4761: UPDATE MTH_WEEK_ERR SET
4813: BEGIN
4814:
4815: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4816:
4817: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4818: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4819:
4820: ELSIF p_rowid IS NOT NULL THEN
4821:
4814:
4815: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4816:
4817: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4818: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4819:
4820: ELSIF p_rowid IS NOT NULL THEN
4821:
4822: UPDATE MTH_WORKDAY_SHIFTS_ERR SET
4930: BEGIN
4931:
4932: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4933:
4934: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4935: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4936:
4937: ELSIF p_rowid IS NOT NULL THEN
4938:
4931:
4932: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('Y','N','D') THEN
4933:
4934: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
4935: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
4936:
4937: ELSIF p_rowid IS NOT NULL THEN
4938:
4939: UPDATE MTH_WO_SALES_ORDERS_ERR SET
5056: BEGIN
5057:
5058: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
5059:
5060: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
5061: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
5062:
5063: ELSIF p_rowid IS NOT NULL THEN
5064:
5057:
5058: IF NVL(p_reprocess_ready_yn,'X') NOT IN ('D') THEN
5059:
5060: FND_MESSAGE.SET_NAME('MTH','MTH_INVALID_REPROCESS_READY_YN');
5061: RAISE_APPLICATION_ERROR(-20002, FND_MESSAGE.GET);
5062:
5063: ELSIF p_rowid IS NOT NULL THEN
5064:
5065: UPDATE MTH_YEAR_ERR SET