DBA Data[Home] [Help]

APPS.IGS_EN_ADD_UNITS_API dependencies on FND_MESSAGE

Line 98: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
101: RAISE;
102: END set_deny_warn;

Line 99: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.set_deny_warn');

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;
101: RAISE;
102: END set_deny_warn;
103:

Line 195: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

191: END LOOP;
192:
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);

Line 196: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_exists');

192:
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;

Line 285: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ERROR_UNITS');

281: -- if it does not exists then update the warnings records of those uoo ids having 'D' as 'I'
282:
283: -- get the message text to be concatenated to the message text of a record in warnings table
284: -- which does not have a corresponding unit in the cart.
285: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ERROR_UNITS');
286: l_message1 := FND_MESSAGE.GET();
287:
288: FND_MESSAGE.SET_NAME('IGS','IGS_SS_EN_SEE_ADMIN');
289: l_message2 := FND_MESSAGE.GET();

Line 286: l_message1 := FND_MESSAGE.GET();

282:
283: -- get the message text to be concatenated to the message text of a record in warnings table
284: -- which does not have a corresponding unit in the cart.
285: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ERROR_UNITS');
286: l_message1 := FND_MESSAGE.GET();
287:
288: FND_MESSAGE.SET_NAME('IGS','IGS_SS_EN_SEE_ADMIN');
289: l_message2 := FND_MESSAGE.GET();
290:

Line 288: FND_MESSAGE.SET_NAME('IGS','IGS_SS_EN_SEE_ADMIN');

284: -- which does not have a corresponding unit in the cart.
285: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ERROR_UNITS');
286: l_message1 := FND_MESSAGE.GET();
287:
288: FND_MESSAGE.SET_NAME('IGS','IGS_SS_EN_SEE_ADMIN');
289: l_message2 := FND_MESSAGE.GET();
290:
291: FOR dist IN c_dist_uooids LOOP
292: l_sua_exists := NULL;

Line 289: l_message2 := FND_MESSAGE.GET();

285: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ERROR_UNITS');
286: l_message1 := FND_MESSAGE.GET();
287:
288: FND_MESSAGE.SET_NAME('IGS','IGS_SS_EN_SEE_ADMIN');
289: l_message2 := FND_MESSAGE.GET();
290:
291: FOR dist IN c_dist_uooids LOOP
292: l_sua_exists := NULL;
293: l_ps_rec_exists := NULL;

Line 338: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

334: COMMIT;
335:
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);

Line 339: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.update_warnings_table');

335:
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;

Line 383: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
386: RAISE;
387: END get_unit_sec;

Line 384: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_unit_sec');

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;
386: RAISE;
387: END get_unit_sec;
388:

Line 428: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
431: RAISE;
432: END get_person_type;

Line 429: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_person_type');

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;
431: RAISE;
432: END get_person_type;
433:

Line 543: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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');
545: IGS_GE_MSG_STACK.ADD;
546: RAISE;
547:

Line 544: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_ss_warnings');

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');
545: IGS_GE_MSG_STACK.ADD;
546: RAISE;
547:
548: END delete_ss_warnings;

Line 701: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
704: RAISE;
705: END chk_sua_creation_is_valid;

Line 702: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.chk_sua_creation_is_valid');

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;
704: RAISE;
705: END chk_sua_creation_is_valid;
706:

Line 790: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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
794:

Line 821: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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');
823: IGS_GE_MSG_STACK.ADD;
824: RAISE;
825:

Line 822: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_ps_record');

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');
823: IGS_GE_MSG_STACK.ADD;
824: RAISE;
825:
826: END create_ps_record;

Line 894: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
898: l_unit_sec := get_unit_sec(p_uoo_id);

Line 922: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
925: RAISE;
926:

Line 923: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_cart_error');

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;
925: RAISE;
926:
927: END create_cart_error;

Line 1037: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
1041: l_unit_sec := get_unit_sec(p_uoo_id);

Line 1080: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1076: p_return_status := 'FALSE';
1077: p_message := 'IGS_EN_SUA_EXISTS'||'*'||l_unit_sec;
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;

Line 1081: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua');

1077: p_message := 'IGS_EN_SUA_EXISTS'||'*'||l_unit_sec;
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:

Line 1200: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
1204: l_message_tokens := NULL;

Line 1235: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
1238: RAISE;
1239:

Line 1236: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_sua_from_plan');

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;
1238: RAISE;
1239:
1240: END create_sua_from_plan;

Line 1373: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
1377: l_unit_sec := get_unit_sec(p_unit_params(i).uoo_id);

Line 1413: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
1416: RAISE;
1417: END get_perm_wlst_setup;

Line 1414: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.get_perm_wlst_setup');

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;
1416: RAISE;
1417: END get_perm_wlst_setup;
1418:

Line 1772: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
1775: RAISE;
1776: END permission_required;

Line 1773: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.permission_required');

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;
1775: RAISE;
1776: END permission_required;
1777:

Line 2034: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
2038: l_unit_sec := get_unit_sec(p_uoo_id);

Line 2069: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
2072: RAISE;
2073: END waitlist_required;

Line 2070: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.waitlist_required');

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;
2072: RAISE;
2073: END waitlist_required;
2074:

Line 2197: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
2200: RAISE;
2201:

Line 2198: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.validate_enr_encb');

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;
2200: RAISE;
2201:
2202: END validate_enr_encmb;

Line 2708: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
2711: RAISE;
2712:

Line 2709: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.reorder_uoo_ids');

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;
2711: RAISE;
2712:
2713: END reorder_uoo_ids;

Line 3168: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
3172: igs_en_drop_units_api.create_ss_warning (

Line 3269: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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');
3271: IGS_GE_MSG_STACK.ADD;
3272: RAISE;
3273: END eval_cart_max;

Line 3270: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.eval_cart_max');

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');
3271: IGS_GE_MSG_STACK.ADD;
3272: RAISE;
3273: END eval_cart_max;
3274:

Line 3628: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
3632: -- add to warnings table as error i.e warn_icon is 'D'

Line 3960: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
3964: -- add to warnings table as error i.e warn_icon is 'D'

Line 4041: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
4045: -- add to warnings table as error i.e warn_icon is 'D'

Line 4095: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
4098: RAISE;
4099:

Line 4096: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_planned_sua');

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;
4098: RAISE;
4099:
4100: END create_planned_sua;

Line 4308: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
4312: l_unit_sec := get_unit_sec(p_unit_params(i).uoo_id);

Line 4344: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
4347: RAISE;
4348:

Line 4345: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_unconfirm_sua');

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;
4347: RAISE;
4348:
4349: END create_unconfirm_sua;

Line 4701: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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
4705: l_token1 := FND_MESSAGE.GET_TOKEN('CONSTAT',NULL);

Line 4705: l_token1 := FND_MESSAGE.GET_TOKEN('CONSTAT',NULL);

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
4705: l_token1 := FND_MESSAGE.GET_TOKEN('CONSTAT',NULL);
4706: l_token2 := FND_MESSAGE.GET_TOKEN('SSTAT',NULL);
4707: -- Then prepare the token along with their values in the fromat required
4708: -- token:token_value
4709: IF l_token1 IS NOT NULL AND l_token2 IS NOT NULL THEN

Line 4706: l_token2 := FND_MESSAGE.GET_TOKEN('SSTAT',NULL);

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
4705: l_token1 := FND_MESSAGE.GET_TOKEN('CONSTAT',NULL);
4706: l_token2 := FND_MESSAGE.GET_TOKEN('SSTAT',NULL);
4707: -- Then prepare the token along with their values in the fromat required
4708: -- token:token_value
4709: IF l_token1 IS NOT NULL AND l_token2 IS NOT NULL THEN
4710: l_token_set := 'CONSTAT' || ':' || l_token1 ||';'||'SSTAT'||':'||l_token2||';' ;

Line 4875: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

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:
4879: l_unit_sec := get_unit_sec(l_uoo_id);

Line 5091: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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;
5094: RAISE;
5095: END create_enroll_sua;

Line 5092: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.create_enroll_sua');

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;
5094: RAISE;
5095: END create_enroll_sua;
5096:

Line 5148: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

5144:
5145:
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);

Line 5149: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.delete_plan_error_records');

5145:
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;

Line 5617: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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');
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;

Line 5618: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_ADD_UNITS_API.add_selected_units');

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');
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:

Line 5652: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

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');
5654: IGS_GE_MSG_STACK.ADD;
5655: RAISE;
5656: END delete_unrelated_warnings;

Line 5653: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_ADD_UNITS_API.delete_unrelated_warnings');

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');
5654: IGS_GE_MSG_STACK.ADD;
5655: RAISE;
5656: END delete_unrelated_warnings;
5657: