eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_USER_EXCEP_GEN dependencies on MSC_EXCEPTION_PREFERENCES

Line 190: from MSC_EXCEPTION_PREFERENCES ep,

186: --function returns 0 if a user has selected a exception for notifiaction else returns 1
187: function validate_block_notification(p_user_name in varchar2, p_exception_type in number) return number is
188: cursor check_user(p_user in varchar2, p_excep_type number) is
189: select 1
190: from MSC_EXCEPTION_PREFERENCES ep,
191: fnd_user u
192: where ep.user_id = u.user_id
193: and u.user_name = p_user
194: and exception_type_lookup_code = p_excep_type

Line 3998: /*delete from MSC_EXCEPTION_PREFERENCES

3994: delete from msc_x_exception_details
3995: where exception_type = exceptionId
3996: and exception_group = -99;
3997:
3998: /*delete from MSC_EXCEPTION_PREFERENCES
3999: where EXCEPTION_TYPE_LOOKUP_CODE = exceptionId; */
4000:
4001: delete from msc_item_exceptions
4002: where exception_type = exceptionId