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.IEB_SERVICEPLAN_PVT dependencies on FND_API

Line 40: x_return_status := fnd_api.g_ret_sts_success;

36: BEGIN
37:
38:
39: fnd_msg_pub.delete_msg();
40: x_return_status := fnd_api.g_ret_sts_success;
41: FND_MSG_PUB.initialize;
42: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
43: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
44: x_msg_data := '';

Line 135: WHEN fnd_api.g_exc_error THEN

131: p_plan_id := l_svc_plan_id;
132: COMMIT;
133:
134: EXCEPTION
135: WHEN fnd_api.g_exc_error THEN
136: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
137: ROLLBACK;
138: x_return_status := fnd_api.g_ret_sts_error;
139:

Line 138: x_return_status := fnd_api.g_ret_sts_error;

134: EXCEPTION
135: WHEN fnd_api.g_exc_error THEN
136: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
137: ROLLBACK;
138: x_return_status := fnd_api.g_ret_sts_error;
139:
140: WHEN fnd_api.g_exc_unexpected_error THEN
141: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
142: ROLLBACK;

Line 140: WHEN fnd_api.g_exc_unexpected_error THEN

136: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
137: ROLLBACK;
138: x_return_status := fnd_api.g_ret_sts_error;
139:
140: WHEN fnd_api.g_exc_unexpected_error THEN
141: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
142: ROLLBACK;
143: x_return_status := fnd_api.g_ret_sts_unexp_error;
144:

Line 143: x_return_status := fnd_api.g_ret_sts_unexp_error;

139:
140: WHEN fnd_api.g_exc_unexpected_error THEN
141: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
142: ROLLBACK;
143: x_return_status := fnd_api.g_ret_sts_unexp_error;
144:
145: WHEN OTHERS THEN
146: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
147:

Line 149: x_return_status := fnd_api.g_ret_sts_unexp_error;

145: WHEN OTHERS THEN
146: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
147:
148: ROLLBACK;
149: x_return_status := fnd_api.g_ret_sts_unexp_error;
150:
151: END Create_ServicePlan;
152: --===================================================================
153: -- NAME

Line 215: x_return_status := fnd_api.g_ret_sts_success;

211: BEGIN
212:
213:
214: fnd_msg_pub.delete_msg();
215: x_return_status := fnd_api.g_ret_sts_success;
216: FND_MSG_PUB.initialize;
217: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
218: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
219: x_msg_data := '';

Line 404: WHEN fnd_api.g_exc_error THEN

400:
401: COMMIT;
402:
403: EXCEPTION
404: WHEN fnd_api.g_exc_error THEN
405: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
406: ROLLBACK;
407: x_return_status := fnd_api.g_ret_sts_error;
408:

Line 407: x_return_status := fnd_api.g_ret_sts_error;

403: EXCEPTION
404: WHEN fnd_api.g_exc_error THEN
405: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
406: ROLLBACK;
407: x_return_status := fnd_api.g_ret_sts_error;
408:
409: WHEN fnd_api.g_exc_unexpected_error THEN
410: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
411: ROLLBACK;

Line 409: WHEN fnd_api.g_exc_unexpected_error THEN

405: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
406: ROLLBACK;
407: x_return_status := fnd_api.g_ret_sts_error;
408:
409: WHEN fnd_api.g_exc_unexpected_error THEN
410: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
411: ROLLBACK;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413:

Line 412: x_return_status := fnd_api.g_ret_sts_unexp_error;

408:
409: WHEN fnd_api.g_exc_unexpected_error THEN
410: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
411: ROLLBACK;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413:
414: WHEN OTHERS THEN
415: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
416:

Line 418: x_return_status := fnd_api.g_ret_sts_unexp_error;

414: WHEN OTHERS THEN
415: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
416:
417: ROLLBACK;
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419:
420: END Create_IOCoverages;
421: --===================================================================
422: -- NAME

Line 484: x_return_status := fnd_api.g_ret_sts_success;

480: BEGIN
481:
482:
483: fnd_msg_pub.delete_msg();
484: x_return_status := fnd_api.g_ret_sts_success;
485: FND_MSG_PUB.initialize;
486: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
487: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
488: x_msg_data := '';

Line 595: WHEN fnd_api.g_exc_error THEN

591:
592: COMMIT;
593:
594: EXCEPTION
595: WHEN fnd_api.g_exc_error THEN
596: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
597: ROLLBACK;
598: x_return_status := fnd_api.g_ret_sts_error;
599:

Line 598: x_return_status := fnd_api.g_ret_sts_error;

594: EXCEPTION
595: WHEN fnd_api.g_exc_error THEN
596: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
597: ROLLBACK;
598: x_return_status := fnd_api.g_ret_sts_error;
599:
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
602: ROLLBACK;

Line 600: WHEN fnd_api.g_exc_unexpected_error THEN

596: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
597: ROLLBACK;
598: x_return_status := fnd_api.g_ret_sts_error;
599:
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
602: ROLLBACK;
603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604:

Line 603: x_return_status := fnd_api.g_ret_sts_unexp_error;

599:
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
602: ROLLBACK;
603: x_return_status := fnd_api.g_ret_sts_unexp_error;
604:
605: WHEN OTHERS THEN
606: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
607:

Line 609: x_return_status := fnd_api.g_ret_sts_unexp_error;

605: WHEN OTHERS THEN
606: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
607:
608: ROLLBACK;
609: x_return_status := fnd_api.g_ret_sts_unexp_error;
610:
611: END Update_IOCoverages;
612: --===================================================================
613: -- NAME

Line 650: x_return_status := fnd_api.g_ret_sts_success;

646: BEGIN
647:
648:
649: fnd_msg_pub.delete_msg();
650: x_return_status := fnd_api.g_ret_sts_success;
651: FND_MSG_PUB.initialize;
652: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
653: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
654: x_msg_data := '';

Line 705: WHEN fnd_api.g_exc_error THEN

701:
702: COMMIT;
703:
704: EXCEPTION
705: WHEN fnd_api.g_exc_error THEN
706: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
707: ROLLBACK;
708: x_return_status := fnd_api.g_ret_sts_error;
709:

Line 708: x_return_status := fnd_api.g_ret_sts_error;

704: EXCEPTION
705: WHEN fnd_api.g_exc_error THEN
706: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
707: ROLLBACK;
708: x_return_status := fnd_api.g_ret_sts_error;
709:
710: WHEN fnd_api.g_exc_unexpected_error THEN
711: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
712: ROLLBACK;

Line 710: WHEN fnd_api.g_exc_unexpected_error THEN

706: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
707: ROLLBACK;
708: x_return_status := fnd_api.g_ret_sts_error;
709:
710: WHEN fnd_api.g_exc_unexpected_error THEN
711: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
712: ROLLBACK;
713: x_return_status := fnd_api.g_ret_sts_unexp_error;
714:

Line 713: x_return_status := fnd_api.g_ret_sts_unexp_error;

709:
710: WHEN fnd_api.g_exc_unexpected_error THEN
711: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
712: ROLLBACK;
713: x_return_status := fnd_api.g_ret_sts_unexp_error;
714:
715: WHEN OTHERS THEN
716: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
717:

Line 719: x_return_status := fnd_api.g_ret_sts_unexp_error;

715: WHEN OTHERS THEN
716: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
717:
718: ROLLBACK;
719: x_return_status := fnd_api.g_ret_sts_unexp_error;
720:
721:
722: END Create_Classification;
723:

Line 775: x_return_status := fnd_api.g_ret_sts_success;

771: BEGIN
772:
773:
774: fnd_msg_pub.delete_msg();
775: x_return_status := fnd_api.g_ret_sts_success;
776: FND_MSG_PUB.initialize;
777: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
778: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
779: x_msg_data := '';

Line 865: WHEN fnd_api.g_exc_error THEN

861:
862: COMMIT;
863:
864: EXCEPTION
865: WHEN fnd_api.g_exc_error THEN
866: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
867: ROLLBACK;
868: x_return_status := fnd_api.g_ret_sts_error;
869:

Line 868: x_return_status := fnd_api.g_ret_sts_error;

864: EXCEPTION
865: WHEN fnd_api.g_exc_error THEN
866: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
867: ROLLBACK;
868: x_return_status := fnd_api.g_ret_sts_error;
869:
870: WHEN fnd_api.g_exc_unexpected_error THEN
871: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
872: ROLLBACK;

Line 870: WHEN fnd_api.g_exc_unexpected_error THEN

866: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
867: ROLLBACK;
868: x_return_status := fnd_api.g_ret_sts_error;
869:
870: WHEN fnd_api.g_exc_unexpected_error THEN
871: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
872: ROLLBACK;
873: x_return_status := fnd_api.g_ret_sts_unexp_error;
874:

Line 873: x_return_status := fnd_api.g_ret_sts_unexp_error;

869:
870: WHEN fnd_api.g_exc_unexpected_error THEN
871: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
872: ROLLBACK;
873: x_return_status := fnd_api.g_ret_sts_unexp_error;
874:
875: WHEN OTHERS THEN
876: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
877:

Line 879: x_return_status := fnd_api.g_ret_sts_unexp_error;

875: WHEN OTHERS THEN
876: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
877:
878: ROLLBACK;
879: x_return_status := fnd_api.g_ret_sts_unexp_error;
880:
881:
882: END Create_CampCategory;
883:

Line 933: x_return_status := fnd_api.g_ret_sts_success;

929: BEGIN
930:
931:
932: fnd_msg_pub.delete_msg();
933: x_return_status := fnd_api.g_ret_sts_success;
934: FND_MSG_PUB.initialize;
935: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
936: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
937: x_msg_data := '';

Line 1018: WHEN fnd_api.g_exc_error THEN

1014:
1015: COMMIT;
1016:
1017: EXCEPTION
1018: WHEN fnd_api.g_exc_error THEN
1019: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1020: ROLLBACK;
1021: x_return_status := fnd_api.g_ret_sts_error;
1022:

Line 1021: x_return_status := fnd_api.g_ret_sts_error;

1017: EXCEPTION
1018: WHEN fnd_api.g_exc_error THEN
1019: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1020: ROLLBACK;
1021: x_return_status := fnd_api.g_ret_sts_error;
1022:
1023: WHEN fnd_api.g_exc_unexpected_error THEN
1024: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1025: ROLLBACK;

Line 1023: WHEN fnd_api.g_exc_unexpected_error THEN

1019: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1020: ROLLBACK;
1021: x_return_status := fnd_api.g_ret_sts_error;
1022:
1023: WHEN fnd_api.g_exc_unexpected_error THEN
1024: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1025: ROLLBACK;
1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027:

Line 1026: x_return_status := fnd_api.g_ret_sts_unexp_error;

1022:
1023: WHEN fnd_api.g_exc_unexpected_error THEN
1024: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1025: ROLLBACK;
1026: x_return_status := fnd_api.g_ret_sts_unexp_error;
1027:
1028: WHEN OTHERS THEN
1029: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1030:

Line 1032: x_return_status := fnd_api.g_ret_sts_unexp_error;

1028: WHEN OTHERS THEN
1029: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1030:
1031: ROLLBACK;
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033:
1034: END Create_ClassfnCategory;
1035:
1036: --===================================================================

Line 1078: x_return_status := fnd_api.g_ret_sts_success;

1074: BEGIN
1075:
1076:
1077: fnd_msg_pub.delete_msg();
1078: x_return_status := fnd_api.g_ret_sts_success;
1079: FND_MSG_PUB.initialize;
1080: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1081: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1082: x_msg_data := '';

Line 1132: WHEN fnd_api.g_exc_error THEN

1128:
1129: COMMIT;
1130:
1131: EXCEPTION
1132: WHEN fnd_api.g_exc_error THEN
1133: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1134: ROLLBACK;
1135: x_return_status := fnd_api.g_ret_sts_error;
1136:

Line 1135: x_return_status := fnd_api.g_ret_sts_error;

1131: EXCEPTION
1132: WHEN fnd_api.g_exc_error THEN
1133: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1134: ROLLBACK;
1135: x_return_status := fnd_api.g_ret_sts_error;
1136:
1137: WHEN fnd_api.g_exc_unexpected_error THEN
1138: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1139: ROLLBACK;

Line 1137: WHEN fnd_api.g_exc_unexpected_error THEN

1133: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1134: ROLLBACK;
1135: x_return_status := fnd_api.g_ret_sts_error;
1136:
1137: WHEN fnd_api.g_exc_unexpected_error THEN
1138: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1139: ROLLBACK;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141:

Line 1140: x_return_status := fnd_api.g_ret_sts_unexp_error;

1136:
1137: WHEN fnd_api.g_exc_unexpected_error THEN
1138: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1139: ROLLBACK;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141:
1142: WHEN OTHERS THEN
1143: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1144:

Line 1146: x_return_status := fnd_api.g_ret_sts_unexp_error;

1142: WHEN OTHERS THEN
1143: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1144:
1145: ROLLBACK;
1146: x_return_status := fnd_api.g_ret_sts_unexp_error;
1147:
1148:
1149: END Create_RegionalPlan;
1150:

Line 1190: x_return_status := fnd_api.g_ret_sts_success;

1186: BEGIN
1187:
1188:
1189: fnd_msg_pub.delete_msg();
1190: x_return_status := fnd_api.g_ret_sts_success;
1191: FND_MSG_PUB.initialize;
1192: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1193: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1194: x_msg_data := '';

Line 1239: WHEN fnd_api.g_exc_error THEN

1235:
1236: COMMIT;
1237:
1238: EXCEPTION
1239: WHEN fnd_api.g_exc_error THEN
1240: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1241: ROLLBACK;
1242: x_return_status := fnd_api.g_ret_sts_error;
1243:

Line 1242: x_return_status := fnd_api.g_ret_sts_error;

1238: EXCEPTION
1239: WHEN fnd_api.g_exc_error THEN
1240: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1241: ROLLBACK;
1242: x_return_status := fnd_api.g_ret_sts_error;
1243:
1244: WHEN fnd_api.g_exc_unexpected_error THEN
1245: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1246: ROLLBACK;

Line 1244: WHEN fnd_api.g_exc_unexpected_error THEN

1240: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1241: ROLLBACK;
1242: x_return_status := fnd_api.g_ret_sts_error;
1243:
1244: WHEN fnd_api.g_exc_unexpected_error THEN
1245: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1246: ROLLBACK;
1247: x_return_status := fnd_api.g_ret_sts_unexp_error;
1248:

Line 1247: x_return_status := fnd_api.g_ret_sts_unexp_error;

1243:
1244: WHEN fnd_api.g_exc_unexpected_error THEN
1245: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1246: ROLLBACK;
1247: x_return_status := fnd_api.g_ret_sts_unexp_error;
1248:
1249: WHEN OTHERS THEN
1250: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1251:

Line 1253: x_return_status := fnd_api.g_ret_sts_unexp_error;

1249: WHEN OTHERS THEN
1250: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1251:
1252: ROLLBACK;
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254:
1255: END Create_GroupPlanMap;
1256:
1257: --===================================================================

Line 1295: x_return_status := fnd_api.g_ret_sts_success;

1291: BEGIN
1292:
1293:
1294: fnd_msg_pub.delete_msg();
1295: x_return_status := fnd_api.g_ret_sts_success;
1296: FND_MSG_PUB.initialize;
1297: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1298: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1299: x_msg_data := '';

Line 1314: WHEN fnd_api.g_exc_error THEN

1310:
1311: COMMIT;
1312:
1313: EXCEPTION
1314: WHEN fnd_api.g_exc_error THEN
1315: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1316: ROLLBACK;
1317: x_return_status := fnd_api.g_ret_sts_error;
1318:

Line 1317: x_return_status := fnd_api.g_ret_sts_error;

1313: EXCEPTION
1314: WHEN fnd_api.g_exc_error THEN
1315: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1316: ROLLBACK;
1317: x_return_status := fnd_api.g_ret_sts_error;
1318:
1319: WHEN fnd_api.g_exc_unexpected_error THEN
1320: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1321: ROLLBACK;

Line 1319: WHEN fnd_api.g_exc_unexpected_error THEN

1315: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1316: ROLLBACK;
1317: x_return_status := fnd_api.g_ret_sts_error;
1318:
1319: WHEN fnd_api.g_exc_unexpected_error THEN
1320: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1321: ROLLBACK;
1322: x_return_status := fnd_api.g_ret_sts_unexp_error;
1323:

Line 1322: x_return_status := fnd_api.g_ret_sts_unexp_error;

1318:
1319: WHEN fnd_api.g_exc_unexpected_error THEN
1320: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1321: ROLLBACK;
1322: x_return_status := fnd_api.g_ret_sts_unexp_error;
1323:
1324: WHEN OTHERS THEN
1325: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1326:

Line 1328: x_return_status := fnd_api.g_ret_sts_unexp_error;

1324: WHEN OTHERS THEN
1325: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1326:
1327: ROLLBACK;
1328: x_return_status := fnd_api.g_ret_sts_unexp_error;
1329:
1330: END Update_Category;
1331:
1332:

Line 1369: x_return_status := fnd_api.g_ret_sts_success;

1365: BEGIN
1366:
1367:
1368: fnd_msg_pub.delete_msg();
1369: x_return_status := fnd_api.g_ret_sts_success;
1370: FND_MSG_PUB.initialize;
1371: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1372: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1373: x_msg_data := '';

Line 1477: WHEN fnd_api.g_exc_error THEN

1473:
1474: COMMIT;
1475:
1476: EXCEPTION
1477: WHEN fnd_api.g_exc_error THEN
1478: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1479: ROLLBACK;
1480: x_return_status := fnd_api.g_ret_sts_error;
1481:

Line 1480: x_return_status := fnd_api.g_ret_sts_error;

1476: EXCEPTION
1477: WHEN fnd_api.g_exc_error THEN
1478: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1479: ROLLBACK;
1480: x_return_status := fnd_api.g_ret_sts_error;
1481:
1482: WHEN fnd_api.g_exc_unexpected_error THEN
1483: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1484: ROLLBACK;

Line 1482: WHEN fnd_api.g_exc_unexpected_error THEN

1478: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1479: ROLLBACK;
1480: x_return_status := fnd_api.g_ret_sts_error;
1481:
1482: WHEN fnd_api.g_exc_unexpected_error THEN
1483: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1484: ROLLBACK;
1485: x_return_status := fnd_api.g_ret_sts_unexp_error;
1486:

Line 1485: x_return_status := fnd_api.g_ret_sts_unexp_error;

1481:
1482: WHEN fnd_api.g_exc_unexpected_error THEN
1483: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1484: ROLLBACK;
1485: x_return_status := fnd_api.g_ret_sts_unexp_error;
1486:
1487: WHEN OTHERS THEN
1488: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1489:

Line 1491: x_return_status := fnd_api.g_ret_sts_unexp_error;

1487: WHEN OTHERS THEN
1488: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1489:
1490: ROLLBACK;
1491: x_return_status := fnd_api.g_ret_sts_unexp_error;
1492:
1493: END Create_ServiceLevel;
1494:
1495:

Line 1532: x_return_status := fnd_api.g_ret_sts_success;

1528: BEGIN
1529:
1530:
1531: fnd_msg_pub.delete_msg();
1532: x_return_status := fnd_api.g_ret_sts_success;
1533: FND_MSG_PUB.initialize;
1534: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1535: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1536: x_msg_data := '';

Line 1569: WHEN fnd_api.g_exc_error THEN

1565:
1566: COMMIT;
1567:
1568: EXCEPTION
1569: WHEN fnd_api.g_exc_error THEN
1570: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1571: ROLLBACK;
1572: x_return_status := fnd_api.g_ret_sts_error;
1573:

Line 1572: x_return_status := fnd_api.g_ret_sts_error;

1568: EXCEPTION
1569: WHEN fnd_api.g_exc_error THEN
1570: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1571: ROLLBACK;
1572: x_return_status := fnd_api.g_ret_sts_error;
1573:
1574: WHEN fnd_api.g_exc_unexpected_error THEN
1575: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1576: ROLLBACK;

Line 1574: WHEN fnd_api.g_exc_unexpected_error THEN

1570: -- DBMS_OUTPUT.PUT_LINE('Error : '||sqlerrm);
1571: ROLLBACK;
1572: x_return_status := fnd_api.g_ret_sts_error;
1573:
1574: WHEN fnd_api.g_exc_unexpected_error THEN
1575: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1576: ROLLBACK;
1577: x_return_status := fnd_api.g_ret_sts_unexp_error;
1578:

Line 1577: x_return_status := fnd_api.g_ret_sts_unexp_error;

1573:
1574: WHEN fnd_api.g_exc_unexpected_error THEN
1575: -- DBMS_OUTPUT.PUT_LINE('unexpected Error : '||sqlerrm);
1576: ROLLBACK;
1577: x_return_status := fnd_api.g_ret_sts_unexp_error;
1578:
1579: WHEN OTHERS THEN
1580: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1581:

Line 1583: x_return_status := fnd_api.g_ret_sts_unexp_error;

1579: WHEN OTHERS THEN
1580: -- DBMS_OUTPUT.PUT_LINE('other Error : '||sqlerrm);
1581:
1582: ROLLBACK;
1583: x_return_status := fnd_api.g_ret_sts_unexp_error;
1584:
1585: END Update_ServiceLevel;
1586:
1587:

Line 1620: x_return_status := fnd_api.g_ret_sts_success;

1616:
1617: BEGIN
1618:
1619: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1620: x_return_status := fnd_api.g_ret_sts_success;
1621: x_msg_count := 0;
1622: x_msg_data := '';
1623:
1624:

Line 1648: x_return_status := fnd_api.g_ret_sts_unexp_error;

1644: EXCEPTION
1645: WHEN others THEN
1646: -- dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1647: ROLLBACK;
1648: x_return_status := fnd_api.g_ret_sts_unexp_error;
1649:
1650:
1651:
1652:

Line 1688: x_return_status := fnd_api.g_ret_sts_success;

1684:
1685: BEGIN
1686:
1687: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1688: x_return_status := fnd_api.g_ret_sts_success;
1689: x_msg_count := 0;
1690: x_msg_data := '';
1691:
1692: EXECUTE immediate

Line 1749: x_return_status := fnd_api.g_ret_sts_unexp_error;

1745: EXCEPTION
1746: WHEN others THEN
1747: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1748: ROLLBACK;
1749: x_return_status := fnd_api.g_ret_sts_unexp_error;
1750:
1751:
1752: END Delete_Service_Plan;
1753:

Line 1787: x_return_status := fnd_api.g_ret_sts_success;

1783:
1784: BEGIN
1785:
1786: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1787: x_return_status := fnd_api.g_ret_sts_success;
1788: x_msg_count := 0;
1789: x_msg_data := '';
1790:
1791: EXECUTE immediate

Line 1823: x_return_status := fnd_api.g_ret_sts_unexp_error;

1819: EXCEPTION
1820: WHEN others THEN
1821: --dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1822: ROLLBACK;
1823: x_return_status := fnd_api.g_ret_sts_unexp_error;
1824:
1825:
1826: END Delete_Classification;
1827:

Line 1860: x_return_status := fnd_api.g_ret_sts_success;

1856:
1857: BEGIN
1858:
1859: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1860: x_return_status := fnd_api.g_ret_sts_success;
1861: x_msg_count := 0;
1862: x_msg_data := '';
1863:
1864: EXECUTE immediate

Line 1883: x_return_status := fnd_api.g_ret_sts_unexp_error;

1879: EXCEPTION
1880: WHEN others THEN
1881: -- dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1882: ROLLBACK;
1883: x_return_status := fnd_api.g_ret_sts_unexp_error;
1884:
1885:
1886: END Delete_Category;
1887: --===================================================================

Line 1919: x_return_status := fnd_api.g_ret_sts_success;

1915:
1916: BEGIN
1917:
1918: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1919: x_return_status := fnd_api.g_ret_sts_success;
1920: x_msg_count := 0;
1921: x_msg_data := '';
1922:
1923: if( p_direction = 'I') then

Line 1948: x_return_status := fnd_api.g_ret_sts_unexp_error;

1944: EXCEPTION
1945: WHEN others THEN
1946: -- dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
1947: ROLLBACK;
1948: x_return_status := fnd_api.g_ret_sts_unexp_error;
1949:
1950:
1951: END Delete_IOCoverages;
1952:

Line 1972: x_return_status := fnd_api.g_ret_sts_success;

1968:
1969: BEGIN
1970:
1971: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1972: x_return_status := fnd_api.g_ret_sts_success;
1973: x_msg_count := 0;
1974: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1975: x_msg_data := '';
1976:

Line 2042: x_return_status := fnd_api.g_ret_sts_unexp_error;

2038: EXCEPTION
2039: WHEN others THEN
2040: -- dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
2041: ROLLBACK;
2042: x_return_status := fnd_api.g_ret_sts_unexp_error;
2043:
2044:
2045: END Delete_Regional_Plan;
2046:

Line 2063: x_return_status := fnd_api.g_ret_sts_success;

2059:
2060: BEGIN
2061:
2062: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2063: x_return_status := fnd_api.g_ret_sts_success;
2064: x_msg_count := 0;
2065: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2066: x_msg_data := '';
2067:

Line 2093: x_return_status := fnd_api.g_ret_sts_unexp_error;

2089: EXCEPTION
2090: WHEN others THEN
2091: -- dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
2092: ROLLBACK;
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2094:
2095:
2096: END Delete_Regional_PlanMaps;
2097:

Line 2119: x_return_status := fnd_api.g_ret_sts_success;

2115:
2116: BEGIN
2117:
2118: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
2119: x_return_status := fnd_api.g_ret_sts_success;
2120: x_msg_count := 0;
2121: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
2122: x_msg_data := '';
2123:

Line 2152: x_return_status := fnd_api.g_ret_sts_unexp_error;

2148: EXCEPTION
2149: WHEN others THEN
2150: -- dbms_outPUT.PUT_LINE('Error : '||sqlerrm);
2151: ROLLBACK;
2152: x_return_status := fnd_api.g_ret_sts_unexp_error;
2153:
2154:
2155:
2156: END Delete_SpecDateCoverages;