APPS.IGS_EN_DROP_UNITS_API dependencies on APP_EXCEPTION

Line 643: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

639: -- To handle user defined exception raised when adminstrative unit status cannot be detremined
640: WHEN NO_AUSL_RECORD_FOUND THEN
641: RAISE NO_AUSL_RECORD_FOUND;
642:
643: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
644: RAISE;
645:
646: WHEN OTHERS THEN
647:

Line 907: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

903: -- To handle user defined exception raised when adminstrative unit status cannot be detremined
904: WHEN NO_AUSL_RECORD_FOUND THEN
905: RAISE NO_AUSL_RECORD_FOUND;
906:
907: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
908: RAISE;
909:
910: WHEN OTHERS THEN
911: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 1056: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1052:
1053: RETURN;
1054:
1055: EXCEPTION
1056: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1057: RAISE;
1058:
1059: WHEN OTHERS THEN
1060: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 1205: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1201: COMMIT;
1202:
1203: EXCEPTION
1204:
1205: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1206: RAISE;
1207:
1208: WHEN OTHERS THEN
1209:

Line 1673: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1669: p_message := 'IGS_GE_RECORD_LOCKED';
1670: p_return_status := 'E';
1671: RETURN;
1672:
1673: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1674: igs_en_su_attempt_pkg.pkg_source_of_drop := NULL;
1675: igs_en_add_units_api.g_ss_session_id := NULL;
1676: IGS_GE_MSG_STACK.GET(-1, 'T', l_enc_message_name, l_msg_index);
1677: FND_MESSAGE.PARSE_ENCODED(l_enc_message_name,l_app_short_name,l_message_name);

Line 1734: APP_EXCEPTION.RAISE_EXCEPTION;

1730:
1731: IF p_uoo_ids IS NULL THEN
1732: FND_MESSAGE.set_name('IGS', 'IGS_GE_RECORD_CHANGED');
1733: IGS_GE_MSG_STACK.ADD;
1734: APP_EXCEPTION.RAISE_EXCEPTION;
1735: END IF;
1736:
1737: --modified sqlquery for bug 5037726,sql id : 14792801
1738: OPEN c_upd_units FOR

Line 1831: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN

1827: END LOOP;
1828: RETURN 'TRUE' ;
1829:
1830: EXCEPTION
1831: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1832: ROLLBACK;
1833: RAISE;
1834: WHEN OTHERS THEN
1835: