APPS.IGS_EN_ADD_UNITS_API dependencies on FND_LOG

Line 5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY igs_en_add_units_api AS
2: /* $Header: IGSEN93B.pls 120.39 2006/08/25 13:55:14 bdeviset noship $ */
3:
4: --package variables
5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: g_person_type igs_pe_typ_instances.person_type_code%TYPE;
7:
8: TYPE l_units_rec IS RECORD (
9: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

Line 95: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

91:
92: EXCEPTION
93: WHEN OTHERS THEN
94:
95: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 96: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.set_deny_warn :',SQLERRM);

92: EXCEPTION
93: WHEN OTHERS THEN
94:
95: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 198: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

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;
202: RAISE;

Line 199: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_exists :',SQLERRM);

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;
202: RAISE;
203:

Line 341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

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;
345: RAISE;

Line 342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.update_warnings_table :',SQLERRM);

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;
345: RAISE;
346:

Line 380: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

376:
377: EXCEPTION
378: WHEN OTHERS THEN
379:
380: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 381: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_unit_sec :',SQLERRM);

377: EXCEPTION
378: WHEN OTHERS THEN
379:
380: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 425: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

421:
422: EXCEPTION
423: WHEN OTHERS THEN
424:
425: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 426: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_person_type :',SQLERRM);

422: EXCEPTION
423: WHEN OTHERS THEN
424:
425: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 539: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

535:
536: EXCEPTION
537: WHEN OTHERS THEN
538:
539: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
540: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_ss_warnings :',SQLERRM);
541: END IF;
542: ROLLBACK;
543: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 540: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_ss_warnings :',SQLERRM);

536: EXCEPTION
537: WHEN OTHERS THEN
538:
539: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
540: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_ss_warnings :',SQLERRM);
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');

Line 698: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

694:
695: EXCEPTION
696:
697: WHEN OTHERS THEN
698: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 699: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.chk_sua_creation_is_valid :',SQLERRM);

695: EXCEPTION
696:
697: WHEN OTHERS THEN
698: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 817: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

813: END IF;
814:
815: WHEN OTHERS THEN
816:
817: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
818: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_ps_record :',SQLERRM);
819: END IF;
820: ROLLBACK;
821: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 818: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_ps_record :',SQLERRM);

814:
815: WHEN OTHERS THEN
816:
817: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
818: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_ps_record :',SQLERRM);
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');

Line 919: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

915: END IF;
916:
917: WHEN OTHERS THEN
918:
919: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 920: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_cart_error :',SQLERRM);

916:
917: WHEN OTHERS THEN
918:
919: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 1070: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

1066: END IF;
1067:
1068: WHEN OTHERS THEN
1069:
1070: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1071: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua :',SQLERRM);
1072: END IF;
1073: ROLLBACK;
1074: IF SQLCODE = -1 THEN

Line 1071: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua :',SQLERRM);

1067:
1068: WHEN OTHERS THEN
1069:
1070: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
1071: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua :',SQLERRM);
1072: END IF;
1073: ROLLBACK;
1074: IF SQLCODE = -1 THEN
1075: l_unit_sec := get_unit_sec(p_uoo_id);

Line 1232: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

1228: END IF;
1229:
1230: WHEN OTHERS THEN
1231:
1232: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 1233: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_sua_from_plan :',SQLERRM);

1229:
1230: WHEN OTHERS THEN
1231:
1232: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 1410: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

1406: EXCEPTION
1407:
1408: WHEN OTHERS THEN
1409:
1410: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 1411: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.get_perm_wlst_setup :',SQLERRM);

1407:
1408: WHEN OTHERS THEN
1409:
1410: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 1769: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

1765:
1766: EXCEPTION
1767: WHEN OTHERS THEN
1768:
1769: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 1770: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.permission_required :',SQLERRM);

1766: EXCEPTION
1767: WHEN OTHERS THEN
1768:
1769: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 2066: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

2062: RETURN TRUE;
2063: END IF;
2064:
2065: WHEN OTHERS THEN
2066: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 2067: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.waitlist_required :',SQLERRM);

2063: END IF;
2064:
2065: WHEN OTHERS THEN
2066: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 2194: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

2190:
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 2195: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.validate_enr_encb :',SQLERRM);

2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 2705: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

2701: END LOOP;
2702: END IF;
2703: EXCEPTION
2704: WHEN OTHERS THEN
2705: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 2706: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.reorder_uoo_ids :',SQLERRM);

2702: END IF;
2703: EXCEPTION
2704: WHEN OTHERS THEN
2705: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 3265: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

3261: RETURN TRUE;
3262: EXCEPTION
3263: -- In case of exception rollback and return false.
3264: WHEN OTHERS THEN
3265: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
3266: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.eval_cart_max :',SQLERRM);
3267: END IF;
3268: ROLLBACK;
3269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 3266: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.eval_cart_max :',SQLERRM);

3262: EXCEPTION
3263: -- In case of exception rollback and return false.
3264: WHEN OTHERS THEN
3265: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
3266: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.eval_cart_max :',SQLERRM);
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');

Line 4092: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

4088:
4089: EXCEPTION
4090: WHEN OTHERS THEN
4091: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
4092: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 4093: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_planned_sua :',SQLERRM);

4089: EXCEPTION
4090: WHEN OTHERS THEN
4091: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
4092: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 4341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

4337:
4338: EXCEPTION
4339: WHEN OTHERS THEN
4340:
4341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 4342: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_unconfirm_sua :',SQLERRM);

4338: EXCEPTION
4339: WHEN OTHERS THEN
4340:
4341: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 5088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

5084: p_return_status := 'FALSE';
5085: RETURN;
5086:
5087: WHEN OTHERS THEN
5088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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');

Line 5089: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.create_enroll_sua :',SQLERRM);

5085: RETURN;
5086:
5087: WHEN OTHERS THEN
5088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
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;

Line 5151: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

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;
5155: RAISE;

Line 5152: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_plan_error_records :',SQLERRM);

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;
5155: RAISE;
5156:

Line 5612: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

5608:
5609: WHEN OTHERS THEN
5610: igs_en_add_units_api.g_ss_session_id := NULL;
5611: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
5612: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5613: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.add_selected_units :',SQLERRM);
5614: END IF;
5615: ROLLBACK TO sp_add_units_api;
5616: p_deny_warn := 'D';

Line 5613: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.add_selected_units :',SQLERRM);

5609: WHEN OTHERS THEN
5610: igs_en_add_units_api.g_ss_session_id := NULL;
5611: IGS_EN_SU_ATTEMPT_PKG.pkg_source_of_drop := NULL;
5612: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5613: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.add_selected_units :',SQLERRM);
5614: END IF;
5615: ROLLBACK TO sp_add_units_api;
5616: p_deny_warn := 'D';
5617: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 5648: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN

5644:
5645: COMMIT;
5646: EXCEPTION
5647: WHEN OTHERS THEN
5648: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5649: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_unrelated_warnings :',SQLERRM);
5650: END IF;
5651: ROLLBACK;
5652: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

Line 5649: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_unrelated_warnings :',SQLERRM);

5645: COMMIT;
5646: EXCEPTION
5647: WHEN OTHERS THEN
5648: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
5649: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_en_add_units_api.delete_unrelated_warnings :',SQLERRM);
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');