74: END IF;
75:
76: -- Initialize message list if p_init_msg_list is set to TRUE
77: IF FND_API.to_boolean(p_init_msg_list) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API rturn status to success
82: x_return_status := FND_API.g_ret_sts_success;
220: ROLLBACK TO save_one_physicalmap_grp;
221: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
222: x_return_status := FND_API.g_ret_sts_error;
223: END IF;
224: IF FND_MSG_PUB.check_msg_level(
225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
227:
228: IF l_default_msite = g_yes THEN
221: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
222: x_return_status := FND_API.g_ret_sts_error;
223: END IF;
224: IF FND_MSG_PUB.check_msg_level(
225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
227:
228: IF l_default_msite = g_yes THEN
229: FND_MESSAGE.set_name(
222: x_return_status := FND_API.g_ret_sts_error;
223: END IF;
224: IF FND_MSG_PUB.check_msg_level(
225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
227:
228: IF l_default_msite = g_yes THEN
229: FND_MESSAGE.set_name(
230: 'JTF',
245: END IF;
246: FND_MESSAGE.set_token(
247: 'ID',
248: TO_CHAR(l_deliverable_id));
249: FND_MSG_PUB.add;
250: END IF;
251:
252: WHEN OTHERS THEN
253: ROLLBACK TO save_one_physicalmap_grp;
252: WHEN OTHERS THEN
253: ROLLBACK TO save_one_physicalmap_grp;
254: x_return_status := FND_API.g_ret_sts_unexp_error ;
255:
256: IF FND_MSG_PUB.check_msg_level(
257: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
253: ROLLBACK TO save_one_physicalmap_grp;
254: x_return_status := FND_API.g_ret_sts_unexp_error ;
255:
256: IF FND_MSG_PUB.check_msg_level(
257: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
261: END;
254: x_return_status := FND_API.g_ret_sts_unexp_error ;
255:
256: IF FND_MSG_PUB.check_msg_level(
257: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
259: END IF;
260:
261: END;
262: END LOOP;
270: COMMIT;
271: END IF;
272:
273: -- Standard call to get message count and if count is 1, get message info
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.g_false,
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
282:
283: WHEN FND_API.g_exc_error THEN
284: ROLLBACK TO save_physicalmap_grp;
285: x_return_status := FND_API.g_ret_sts_error;
286: FND_MSG_PUB.count_and_get(
287: p_encoded => FND_API.g_false,
288: p_count => x_msg_count,
289: p_data => x_msg_data
290: );
291:
292: WHEN FND_API.g_exc_unexpected_error THEN
293: ROLLBACK TO save_physicalmap_grp;
294: x_return_status := FND_API.g_ret_sts_unexp_error;
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );
300:
301: WHEN dup_val_on_index THEN
302: ROLLBACK TO save_physicalmap_grp;
303: x_return_status := FND_API.g_ret_sts_error;
304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
305: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
306:
307: IF l_default_msite = g_no THEN
308: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_ALL_ALL_EXISTS');
301: WHEN dup_val_on_index THEN
302: ROLLBACK TO save_physicalmap_grp;
303: x_return_status := FND_API.g_ret_sts_error;
304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
305: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
306:
307: IF l_default_msite = g_no THEN
308: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_ALL_ALL_EXISTS');
309: ELSE
310: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_STE_ALL_EXISTS');
311: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
312: END IF;
313: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
314: FND_MSG_PUB.add;
315: END IF;
316:
317: FND_MSG_PUB.count_and_get(
318: p_encoded => FND_API.g_false,
313: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
314: FND_MSG_PUB.add;
315: END IF;
316:
317: FND_MSG_PUB.count_and_get(
318: p_encoded => FND_API.g_false,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );
323: WHEN OTHERS THEN
324: ROLLBACK TO save_physicalmap_grp;
325: x_return_status := FND_API.g_ret_sts_unexp_error ;
326:
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;
330:
331: FND_MSG_PUB.count_and_get(
324: ROLLBACK TO save_physicalmap_grp;
325: x_return_status := FND_API.g_ret_sts_unexp_error ;
326:
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;
330:
331: FND_MSG_PUB.count_and_get(
332: p_encoded => FND_API.g_false,
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;
330:
331: FND_MSG_PUB.count_and_get(
332: p_encoded => FND_API.g_false,
333: p_count => x_msg_count,
334: p_data => x_msg_data
335: );
408: END IF;
409:
410: -- Initialize message list if p_init_msg_list is set to TRUE
411: IF FND_API.to_boolean(p_init_msg_list) THEN
412: FND_MSG_PUB.initialize;
413: END IF;
414:
415: -- Initialize API rturn status to success
416: x_return_status := FND_API.g_ret_sts_success;
524: COMMIT;
525: END IF;
526:
527: -- Standard call to get message count and if count is 1, get message info
528: FND_MSG_PUB.count_and_get(
529: p_encoded => FND_API.g_false,
530: p_count => x_msg_count,
531: p_data => x_msg_data
532: );
535:
536: WHEN FND_API.g_exc_error THEN
537: ROLLBACK TO save_physicalmap_grp;
538: x_return_status := FND_API.g_ret_sts_error;
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false,
541: p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:
545: WHEN FND_API.g_exc_unexpected_error THEN
546: ROLLBACK TO save_physicalmap_grp;
547: x_return_status := FND_API.g_ret_sts_unexp_error;
548: FND_MSG_PUB.count_and_get(
549: p_encoded => FND_API.g_false,
550: p_count => x_msg_count,
551: p_data => x_msg_data
552: );
554: WHEN OTHERS THEN
555: ROLLBACK TO save_physicalmap_grp;
556: x_return_status := FND_API.g_ret_sts_unexp_error ;
557:
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
559: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
560: END IF;
561:
562: FND_MSG_PUB.count_and_get(
555: ROLLBACK TO save_physicalmap_grp;
556: x_return_status := FND_API.g_ret_sts_unexp_error ;
557:
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
559: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
560: END IF;
561:
562: FND_MSG_PUB.count_and_get(
563: p_encoded => FND_API.g_false,
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
559: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
560: END IF;
561:
562: FND_MSG_PUB.count_and_get(
563: p_encoded => FND_API.g_false,
564: p_count => x_msg_count,
565: p_data => x_msg_data
566: );
615: END IF;
616:
617: -- Initialize message list if p_init_msg_list is set to TRUE
618: IF FND_API.to_boolean(p_init_msg_list) THEN
619: FND_MSG_PUB.initialize;
620: END IF;
621:
622: -- Initialize API rturn status to success
623: x_return_status := FND_API.g_ret_sts_success;
637: DELETE FROM JTF_DSP_LGL_PHYS_MAP
638: WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);
639: IF SQL%NOTFOUND THEN
640: -- RAISE JTF_DSPMGRVALIDATION_GRP.physmap_not_exists_exception;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
642: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
643: FND_MESSAGE.set_token(
644: 'ID',
645: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
642: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
643: FND_MESSAGE.set_token(
644: 'ID',
645: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
646: FND_MSG_PUB.add;
647: END IF;
648: RAISE FND_API.g_exc_error;
649: END IF;
650:
661:
662: /*
663: WHEN JTF_DSPMGRVALIDATION_GRP.physmap_not_exists_exception THEN
664: -- only warning; no error
665: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
666: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
667: FND_MESSAGE.set_token(
668: 'ID',
669: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
666: FND_MESSAGE.set_name('JTF', 'JTF_DSP_PHYSMAP_NOT_EXISTS');
667: FND_MESSAGE.set_token(
668: 'ID',
669: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
670: FND_MSG_PUB.add;
671: END IF;
672: */
673:
674: WHEN OTHERS THEN
672: */
673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.g_ret_sts_unexp_error ;
676: IF FND_MSG_PUB.check_msg_level(
677: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
678: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
679: END IF;
680:
673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.g_ret_sts_unexp_error ;
676: IF FND_MSG_PUB.check_msg_level(
677: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
678: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
679: END IF;
680:
681: END;
674: WHEN OTHERS THEN
675: x_return_status := FND_API.g_ret_sts_unexp_error ;
676: IF FND_MSG_PUB.check_msg_level(
677: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
678: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
679: END IF;
680:
681: END;
682: END LOOP;
688: COMMIT;
689: END IF;
690:
691: -- Standard call to get message count and if count is 1, get message info
692: FND_MSG_PUB.count_and_get(
693: p_encoded => FND_API.g_false,
694: p_count => x_msg_count,
695: p_data => x_msg_data
696: );
699:
700: WHEN FND_API.g_exc_error THEN
701: ROLLBACK TO delete_physicalmap_grp;
702: x_return_status := FND_API.g_ret_sts_error;
703: FND_MSG_PUB.count_and_get(
704: p_encoded => FND_API.g_false,
705: p_count => x_msg_count,
706: p_data => x_msg_data
707: );
708:
709: WHEN FND_API.g_exc_unexpected_error THEN
710: ROLLBACK TO delete_physicalmap_grp;
711: x_return_status := FND_API.g_ret_sts_unexp_error ;
712: FND_MSG_PUB.count_and_get(
713: p_encoded => FND_API.g_false,
714: p_count => x_msg_count,
715: p_data => x_msg_data
716: );
718: WHEN OTHERS THEN
719: ROLLBACK TO delete_physicalmap_grp;
720: x_return_status := FND_API.g_ret_sts_unexp_error ;
721:
722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
723: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;
725:
726: FND_MSG_PUB.count_and_get(
719: ROLLBACK TO delete_physicalmap_grp;
720: x_return_status := FND_API.g_ret_sts_unexp_error ;
721:
722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
723: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;
725:
726: FND_MSG_PUB.count_and_get(
727: p_encoded => FND_API.g_false,
722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
723: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;
725:
726: FND_MSG_PUB.count_and_get(
727: p_encoded => FND_API.g_false,
728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );
765:
766: WHEN OTHERS THEN
767: ROLLBACK TO delete_attachment_grp;
768:
769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
770: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
771: END IF;
772:
773: END delete_attachment;
766: WHEN OTHERS THEN
767: ROLLBACK TO delete_attachment_grp;
768:
769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
770: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
771: END IF;
772:
773: END delete_attachment;
774:
806:
807: WHEN OTHERS THEN
808: ROLLBACK TO delete_deliverable_grp;
809:
810: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
811: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
812: END IF;
813:
814: END delete_deliverable;
807: WHEN OTHERS THEN
808: ROLLBACK TO delete_deliverable_grp;
809:
810: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
811: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
812: END IF;
813:
814: END delete_deliverable;
815:
847:
848: WHEN OTHERS THEN
849: ROLLBACK TO delete_msite_grp;
850:
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854:
855: END delete_msite;
848: WHEN OTHERS THEN
849: ROLLBACK TO delete_msite_grp;
850:
851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
852: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
853: END IF;
854:
855: END delete_msite;
856:
894:
895: WHEN OTHERS THEN
896: ROLLBACK TO delete_msite_language_grp;
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
899: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
900: END IF;
901:
902: END delete_msite_language;
895: WHEN OTHERS THEN
896: ROLLBACK TO delete_msite_language_grp;
897:
898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
899: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
900: END IF;
901:
902: END delete_msite_language;
903:
945: END IF;
946:
947: -- Initialize message list if p_init_msg_list is set to TRUE
948: IF FND_API.to_boolean(p_init_msg_list) THEN
949: FND_MSG_PUB.initialize;
950: END IF;
951:
952: -- Initialize API rturn status to success
953: x_return_status := FND_API.g_ret_sts_success;
976:
977: WHEN OTHERS THEN
978: ROLLBACK TO delete_one_ath_msite_grp;
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(
981: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:
977: WHEN OTHERS THEN
978: ROLLBACK TO delete_one_ath_msite_grp;
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(
981: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:
985: END;
978: ROLLBACK TO delete_one_ath_msite_grp;
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(
981: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;
984:
985: END;
986: END LOOP;
992: COMMIT;
993: END IF;
994:
995: -- Standard call to get message count and if count is 1, get message info
996: FND_MSG_PUB.count_and_get(
997: p_encoded => FND_API.g_false,
998: p_count => x_msg_count,
999: p_data => x_msg_data
1000: );
1003:
1004: WHEN FND_API.g_exc_error THEN
1005: ROLLBACK TO delete_attachment_msite_grp;
1006: x_return_status := FND_API.g_ret_sts_error;
1007: FND_MSG_PUB.count_and_get(
1008: p_encoded => FND_API.g_false,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012:
1013: WHEN FND_API.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_attachment_msite_grp;
1015: x_return_status := FND_API.g_ret_sts_unexp_error ;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );
1022: WHEN OTHERS THEN
1023: ROLLBACK TO delete_attachment_msite_grp;
1024: x_return_status := FND_API.g_ret_sts_unexp_error ;
1025:
1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1027: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029:
1030: FND_MSG_PUB.count_and_get(
1023: ROLLBACK TO delete_attachment_msite_grp;
1024: x_return_status := FND_API.g_ret_sts_unexp_error ;
1025:
1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1027: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029:
1030: FND_MSG_PUB.count_and_get(
1031: p_encoded => FND_API.g_false,
1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1027: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029:
1030: FND_MSG_PUB.count_and_get(
1031: p_encoded => FND_API.g_false,
1032: p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );
1071:
1072: WHEN OTHERS THEN
1073: ROLLBACK TO delete_dlv_all_all_grp;
1074:
1075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1076: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1077: END IF;
1078:
1079: END delete_dlv_all_all;
1072: WHEN OTHERS THEN
1073: ROLLBACK TO delete_dlv_all_all_grp;
1074:
1075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1076: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1077: END IF;
1078:
1079: END delete_dlv_all_all;
1080: