DBA Data[Home] [Help]

APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_GE_MSG_STACK

Line 100: IGS_GE_MSG_STACK.ADD;

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:

Line 197: IGS_GE_MSG_STACK.ADD;

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;

Line 340: IGS_GE_MSG_STACK.ADD;

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;

Line 385: IGS_GE_MSG_STACK.ADD;

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 (

Line 430: IGS_GE_MSG_STACK.ADD;

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:

Line 545: IGS_GE_MSG_STACK.ADD;

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:

Line 703: IGS_GE_MSG_STACK.ADD;

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,

Line 789: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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

Line 823: IGS_GE_MSG_STACK.ADD;

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:

Line 893: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 924: IGS_GE_MSG_STACK.ADD;

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:

Line 1036: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 1082: IGS_GE_MSG_STACK.ADD;

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:

Line 1199: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 1237: IGS_GE_MSG_STACK.ADD;

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:

Line 1372: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 1415: IGS_GE_MSG_STACK.ADD;

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(

Line 1774: IGS_GE_MSG_STACK.ADD;

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:

Line 2033: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 2071: IGS_GE_MSG_STACK.ADD;

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:

Line 2199: IGS_GE_MSG_STACK.ADD;

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:

Line 2710: IGS_GE_MSG_STACK.ADD;

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:

Line 3167: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 3271: IGS_GE_MSG_STACK.ADD;

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,

Line 3627: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 3959: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 4040: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 4097: IGS_GE_MSG_STACK.ADD;

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:

Line 4307: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 4346: IGS_GE_MSG_STACK.ADD;

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:

Line 4700: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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

Line 4874: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);

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:

Line 5093: IGS_GE_MSG_STACK.ADD;

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:

Line 5150: IGS_GE_MSG_STACK.ADD;

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;

Line 5619: IGS_GE_MSG_STACK.ADD;

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,

Line 5654: IGS_GE_MSG_STACK.ADD;

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;