142: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
143: IF (l_debug=1) THEN
144: print_debug('Unexpected Error,Insertion failed'||SQLERRM,l_module_name,3);
145: END IF;
146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
147: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
148: END IF;
149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
150:
143: IF (l_debug=1) THEN
144: print_debug('Unexpected Error,Insertion failed'||SQLERRM,l_module_name,3);
145: END IF;
146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
147: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
148: END IF;
149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
150:
151: END;
145: END IF;
146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
147: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
148: END IF;
149: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
150:
151: END;
152:
153:
247: IF (l_debug=1) THEN
248: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
249: END IF;
250:
251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
253: END IF;
254:
255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
248: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
249: END IF;
250:
251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
253: END IF;
254:
255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
256:
251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
253: END IF;
254:
255: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
256:
257: END;
258:
259: /**
316: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
317: IF (l_debug=1) THEN
318: print_debug('Unexpected Error While Deleting'||SQLERRM,'Delete_Plan_Instance',1);
319: END IF;
320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
321: fnd_msg_pub.add_exc_msg(g_pkg_name, 'DELETE_PLAN_INSTANCE');
322: END IF;
323: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
324: END;
317: IF (l_debug=1) THEN
318: print_debug('Unexpected Error While Deleting'||SQLERRM,'Delete_Plan_Instance',1);
319: END IF;
320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
321: fnd_msg_pub.add_exc_msg(g_pkg_name, 'DELETE_PLAN_INSTANCE');
322: END IF;
323: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
324: END;
325:
319: END IF;
320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
321: fnd_msg_pub.add_exc_msg(g_pkg_name, 'DELETE_PLAN_INSTANCE');
322: END IF;
323: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
324: END;
325:
326: /**
327: *
Procedure:Insert_operation_instance
445: IF (l_debug=1) THEN
446: print_debug('Unexptec Error while inserting'||SQLERRM,l_module_name,1);
447: END IF;
448:
449: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
450: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
451: END IF;
452:
453: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
446: print_debug('Unexptec Error while inserting'||SQLERRM,l_module_name,1);
447: END IF;
448:
449: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
450: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
451: END IF;
452:
453: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
454:
449: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
450: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
451: END IF;
452:
453: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
454:
455: END;
456:
457:
518: IF (l_debug=1) THEN
519: print_debug('Unexpected Error'||SQLERRM,l_module_name,1);
520: END IF;
521:
522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
523: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
524: END IF;
525:
526: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
519: print_debug('Unexpected Error'||SQLERRM,l_module_name,1);
520: END IF;
521:
522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
523: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
524: END IF;
525:
526: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
527: END;
522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
523: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
524: END IF;
525:
526: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
527: END;
528:
529:
530: /**
633: IF (l_debug=1) THEN
634: print_debug('Unexpected Error Obtained While Updating Operation instance'||SQLERRM,l_module_name,1);
635: END IF;
636:
637: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
638: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
639: END IF;
640:
641: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
634: print_debug('Unexpected Error Obtained While Updating Operation instance'||SQLERRM,l_module_name,1);
635: END IF;
636:
637: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
638: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
639: END IF;
640:
641: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
642: END;
637: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
638: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
639: END IF;
640:
641: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
642: END;
643:
644: /**
645: *
Procedure:Archive_Plan_instance
891: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
892: IF (l_debug=1) THEN
893: print_debug('Unexpected Error:'||SQLERRM||l_progress,l_module_name,1);
894: END IF;
895: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
896: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
897: END IF;
898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
899: END;
892: IF (l_debug=1) THEN
893: print_debug('Unexpected Error:'||SQLERRM||l_progress,l_module_name,1);
894: END IF;
895: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
896: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
897: END IF;
898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
899: END;
900:
894: END IF;
895: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
896: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
897: END IF;
898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
899: END;
900:
901:
902: /**
992: IF (l_debug=1) THEN
993: print_debug('Unexpected error '||SQLERRM||' at '||l_progress,l_module_name,1);
994: END IF;
995:
996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
997: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
998: END IF;
999: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1000:
993: print_debug('Unexpected error '||SQLERRM||' at '||l_progress,l_module_name,1);
994: END IF;
995:
996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
997: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
998: END IF;
999: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1000:
1001: END;
995:
996: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
997: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
998: END IF;
999: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1000:
1001: END;
1002:
1003:
1141: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1142: IF (l_debug=1) THEN
1143: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1144: END IF;
1145: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1146: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1147: END IF;
1148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1149:
1142: IF (l_debug=1) THEN
1143: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1144: END IF;
1145: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1146: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1147: END IF;
1148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1149:
1150: END;
1144: END IF;
1145: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1146: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1147: END IF;
1148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1149:
1150: END;
1151:
1152: -- non autonomous transaction -- Added for bug # 14284768
1281: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1282: IF (l_debug=1) THEN
1283: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1284: END IF;
1285: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1286: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1287: END IF;
1288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1289:
1282: IF (l_debug=1) THEN
1283: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1284: END IF;
1285: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1286: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1287: END IF;
1288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1289:
1290: END;
1284: END IF;
1285: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1286: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1287: END IF;
1288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1289:
1290: END;
1291:
1292: /**
1438: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1439: IF (l_debug=1) THEN
1440: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1441: END IF;
1442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1444: END IF;
1445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1446: END;
1439: IF (l_debug=1) THEN
1440: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1441: END IF;
1442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1444: END IF;
1445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1446: END;
1447:
1441: END IF;
1442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1444: END IF;
1445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1446: END;
1447:
1448:
1449:
1866: IF (l_debug=1) THEN
1867: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1868: END IF;
1869:
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1872: END IF;
1873:
1874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1867: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1868: END IF;
1869:
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1872: END IF;
1873:
1874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1875: END;
1870: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_module_name);
1872: END IF;
1873:
1874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1875: END;
1876:
1877:
1878: