96: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.set_deny_warn :',SQLERRM);
97: END IF;
98: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
99: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.set_deny_warn');
100: IGS_GE_MSG_STACK.ADD;
101: RAISE;
102: END set_deny_warn;
103:
104:
193: EXCEPTION
194: WHEN OTHERS THEN
195: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
196: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_exists');
197: IGS_GE_MSG_STACK.ADD;
198: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
199: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_exists :',SQLERRM);
200: END IF;
201: ROLLBACK;
336: EXCEPTION
337: WHEN OTHERS THEN
338: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
339: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.update_warnings_table');
340: IGS_GE_MSG_STACK.ADD;
341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.update_warnings_table :',SQLERRM);
343: END IF;
344: ROLLBACK;
381: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_unit_sec :',SQLERRM);
382: END IF;
383: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
384: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_unit_sec');
385: IGS_GE_MSG_STACK.ADD;
386: RAISE;
387: END get_unit_sec;
388:
389: FUNCTION get_person_type (
426: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_person_type :',SQLERRM);
427: END IF;
428: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
429: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_person_type');
430: IGS_GE_MSG_STACK.ADD;
431: RAISE;
432: END get_person_type;
433:
434:
541: END IF;
542: ROLLBACK;
543: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
544: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_ss_warnings');
545: IGS_GE_MSG_STACK.ADD;
546: RAISE;
547:
548: END delete_ss_warnings;
549:
699: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_creation_is_valid :',SQLERRM);
700: END IF;
701: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
702: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_creation_is_valid');
703: IGS_GE_MSG_STACK.ADD;
704: RAISE;
705: END chk_sua_creation_is_valid;
706:
707: PROCEDURE create_ps_record( p_person_id IN NUMBER,
785:
786:
787: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
788: -- get message from stack and insert into warn record.
789: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
790: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
791: ROLLBACK;
792:
793: IF l_message_name IS NOT NULL THEN
819: END IF;
820: ROLLBACK;
821: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
822: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_ps_record');
823: IGS_GE_MSG_STACK.ADD;
824: RAISE;
825:
826: END create_ps_record;
827:
889:
890:
891: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
892: -- get message from stack and insert into warn record.
893: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
894: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
895:
896: IF l_message_name IS NOT NULL THEN
897:
920: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_cart_error :',SQLERRM);
921: END IF;
922: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
923: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_cart_error');
924: IGS_GE_MSG_STACK.ADD;
925: RAISE;
926:
927: END create_cart_error;
928:
1032:
1033:
1034: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1035: -- get message from stack and insert into warn record.
1036: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
1037: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
1038: ROLLBACK;
1039: IF l_message_name IS NOT NULL THEN
1040:
1078: RETURN;
1079: ELSE
1080: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1081: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua');
1082: IGS_GE_MSG_STACK.ADD;
1083: RAISE;
1084: END IF;
1085:
1086:
1195:
1196:
1197: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1198: -- get message from stack and insert into warn record.
1199: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
1200: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
1201:
1202: IF l_message_name IS NOT NULL THEN
1203:
1233: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua_from_plan :',SQLERRM);
1234: END IF;
1235: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1236: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua_from_plan');
1237: IGS_GE_MSG_STACK.ADD;
1238: RAISE;
1239:
1240: END create_sua_from_plan;
1241:
1368: EXCEPTION
1369:
1370: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1371: -- get message from stack and insert into warn record.
1372: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
1373: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
1374:
1375: IF l_message_name IS NOT NULL THEN
1376:
1411: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_perm_wlst_setup :',SQLERRM);
1412: END IF;
1413: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1414: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_perm_wlst_setup');
1415: IGS_GE_MSG_STACK.ADD;
1416: RAISE;
1417: END get_perm_wlst_setup;
1418:
1419: FUNCTION permission_required(
1770: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.permission_required :',SQLERRM);
1771: END IF;
1772: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1773: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.permission_required');
1774: IGS_GE_MSG_STACK.ADD;
1775: RAISE;
1776: END permission_required;
1777:
1778:
2029: EXCEPTION
2030:
2031: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
2032: -- get message from stack and insert into warn record.
2033: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
2034: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
2035:
2036: IF l_message_name IS NOT NULL THEN
2037:
2067: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.waitlist_required :',SQLERRM);
2068: END IF;
2069: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2070: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.waitlist_required');
2071: IGS_GE_MSG_STACK.ADD;
2072: RAISE;
2073: END waitlist_required;
2074:
2075:
2195: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.validate_enr_encb :',SQLERRM);
2196: END IF;
2197: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2198: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.validate_enr_encb');
2199: IGS_GE_MSG_STACK.ADD;
2200: RAISE;
2201:
2202: END validate_enr_encmb;
2203:
2706: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.reorder_uoo_ids :',SQLERRM);
2707: END IF;
2708: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2709: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.reorder_uoo_ids');
2710: IGS_GE_MSG_STACK.ADD;
2711: RAISE;
2712:
2713: END reorder_uoo_ids;
2714:
3163: EXCEPTION
3164:
3165: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3166: -- get message from stack and insert into warn record.
3167: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
3168: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
3169:
3170: IF l_message_name IS NOT NULL THEN
3171:
3267: END IF;
3268: ROLLBACK;
3269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
3270: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.eval_cart_max');
3271: IGS_GE_MSG_STACK.ADD;
3272: RAISE;
3273: END eval_cart_max;
3274:
3275: PROCEDURE create_planned_sua( p_person_id IN NUMBER,
3623:
3624: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3625:
3626: -- get message from stack and insert into warn record.
3627: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
3628: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
3629:
3630: IF l_message_name IS NOT NULL THEN
3631:
3955:
3956: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
3957:
3958: -- get message from stack and insert into warn record.
3959: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
3960: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
3961:
3962: IF l_message_name IS NOT NULL THEN
3963:
4036:
4037: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
4038:
4039: -- get message from stack and insert into warn record.
4040: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
4041: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
4042:
4043: IF l_message_name IS NOT NULL THEN
4044:
4093: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_planned_sua :',SQLERRM);
4094: END IF;
4095: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4096: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_planned_sua');
4097: IGS_GE_MSG_STACK.ADD;
4098: RAISE;
4099:
4100: END create_planned_sua;
4101:
4303: EXCEPTION
4304:
4305: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
4306:
4307: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
4308: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
4309:
4310: IF l_message_name IS NOT NULL THEN
4311:
4342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_unconfirm_sua :',SQLERRM);
4343: END IF;
4344: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4345: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_unconfirm_sua');
4346: IGS_GE_MSG_STACK.ADD;
4347: RAISE;
4348:
4349: END create_unconfirm_sua;
4350:
4696: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
4697:
4698: l_message_name := NULL;
4699: l_token_set := NULL;
4700: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
4701: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
4702:
4703: -- Extract the token values if the retrieved msg is IGS_EN_INVALID_SUP_SUB
4704: IF l_message_name = 'IGS_EN_INVALID_SUP_SUB' THEN
4870: -- Catch any exceptions here. If unhandled exceptions occur then return otherwise log an error record and continue
4871: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
4872:
4873: l_message_name := NULL;
4874: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
4875: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);
4876:
4877: IF l_message_name IS NOT NULL THEN
4878:
5089: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_enroll_sua :',SQLERRM);
5090: END IF;
5091: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5092: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_enroll_sua');
5093: IGS_GE_MSG_STACK.ADD;
5094: RAISE;
5095: END create_enroll_sua;
5096:
5097:
5146: EXCEPTION
5147: WHEN OTHERS THEN
5148: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
5149: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_plan_error_records');
5150: IGS_GE_MSG_STACK.ADD;
5151: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5152: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_plan_error_records :',SQLERRM);
5153: END IF;
5154: ROLLBACK;
5615: ROLLBACK TO sp_add_units_api;
5616: p_deny_warn := 'D';
5617: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5618: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.add_selected_units');
5619: IGS_GE_MSG_STACK.ADD;
5620: RAISE;
5621: END add_selected_units;
5622:
5623: PROCEDURE delete_unrelated_warnings(p_person_id IN VARCHAR2,
5650: END IF;
5651: ROLLBACK;
5652: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
5653: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_ADD_UNITS_API.delete_unrelated_warnings');
5654: IGS_GE_MSG_STACK.ADD;
5655: RAISE;
5656: END delete_unrelated_warnings;
5657:
5658: END IGS_EN_ADD_UNITS_API;