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.MST_AUDIT_REP_EXCP dependencies on MST_EXCEP_PREFERENCES

Line 28: --check if exception appears in mst_excep_preferences (it does not have a threshold but

24: DELETE FROM mst_exceptions
25: WHERE plan_id = plan_idIn
26: AND exception_type = 704;
27:
28: --check if exception appears in mst_excep_preferences (it does not have a threshold but
29: --if it is enabled there should be an entry in that table with a dummy value for threshold).
30: dummyThreshold := getExceptionThreshold(704,userIdIn);
31: --if no threshold found it means exception is disabled, so exit procedure
32: IF dummyThreshold = -999 THEN

Line 113: --check if exception appears in mst_excep_preferences (it does not have a threshold but

109: RETURN;
110: END IF;
111:
112:
113: --check if exception appears in mst_excep_preferences (it does not have a threshold but
114: --if it is enabled there should be an entry in that table with a dummy value for threshold).
115: dummyThreshold := getExceptionThreshold(900,userIdIn);
116: --if no threshold found it means exception is disabled, so exit procedure
117: IF dummyThreshold = -999 THEN

Line 194: --check if exception appears in mst_excep_preferences (it does not have a threshold but

190: DELETE FROM mst_exceptions
191: WHERE plan_id = plan_idIn
192: AND exception_type = 219;
193:
194: --check if exception appears in mst_excep_preferences (it does not have a threshold but
195: --if it is enabled there should be an entry in that table with a dummy value for threshold).
196: dummyThreshold := getExceptionThreshold(219,userIdIn);
197: --if no threshold found it means exception is disabled, so exit procedure
198: IF dummyThreshold = -999 THEN

Line 310: --get the threshold from mst_excep_preferences

306: DELETE FROM mst_exceptions
307: WHERE plan_id = plan_idIn
308: AND exception_type = 902;
309:
310: --get the threshold from mst_excep_preferences
311: thresholdPct := getExceptionThreshold(902,userIdIn);
312: debug_output('thresholdPct='||thresholdPct);
313: --if no threshold found it means exception is disabled, so exit procedure
314: IF thresholdPct = -999 THEN

Line 549: --get the threshold from mst_excep_preferences

545: DELETE FROM mst_exceptions
546: WHERE plan_id = plan_idIn
547: AND exception_type = 903;
548:
549: --get the threshold from mst_excep_preferences
550: thresholdPct := getExceptionThreshold(903,userIdIn);
551: debug_output('thresholdPct='||thresholdPct);
552: --if no threshold found it means exception is disabled, so exit procedure
553: IF thresholdPct = -999 THEN

Line 693: --get the threshold from mst_excep_preferences

689: DELETE FROM mst_exceptions
690: WHERE plan_id = plan_idIn
691: AND exception_type = 904;
692:
693: --get the threshold from mst_excep_preferences
694: thresholdPct := getExceptionThreshold(904,userIdIn);
695: debug_output('thresholdPct='||thresholdPct);
696: --if no threshold found it means exception is disabled, so exit procedure
697: IF thresholdPct = -999 THEN

Line 856: --get the threshold from mst_excep_preferences

852: DELETE FROM mst_exceptions
853: WHERE plan_id = plan_idIn
854: AND exception_type = 905;
855:
856: --get the threshold from mst_excep_preferences
857: thresholdPct := getExceptionThreshold(905,userIdIn);
858: debug_output('thresholdPct='||thresholdPct);
859: --if no threshold found it means exception is disabled, so exit procedure
860: IF thresholdPct = -999 THEN

Line 1016: --get the threshold from mst_excep_preferences

1012: DELETE FROM mst_exceptions
1013: WHERE plan_id = plan_idIn
1014: AND exception_type = 104;
1015:
1016: --get the threshold from mst_excep_preferences
1017: thresholdInHrs := getExceptionThreshold(104,userIdIn);
1018: debug_output('thresholdInHrs=' ||thresholdInHrs);
1019: --if no threshold found it means exception is disabled, so exit procedure
1020: IF thresholdInHrs = -999 THEN

Line 1160: --get the threshold from mst_excep_preferences

1156: DELETE FROM mst_exceptions
1157: WHERE plan_id = plan_idIn
1158: AND exception_type = 105;
1159:
1160: --get the threshold from mst_excep_preferences
1161: thresholdInHrs := getExceptionThreshold(105,userIdIn);
1162: debug_output('thresholdInHrs='||thresholdInHrs);
1163: --if no threshold found it means exception is disabled, so exit procedure
1164: IF thresholdInHrs = -999 THEN

Line 1386: --get the threshold from mst_excep_preferences

1382: DELETE FROM mst_exceptions
1383: WHERE plan_id = plan_idIn
1384: AND exception_type = 404;
1385:
1386: --get the threshold from mst_excep_preferences
1387: thresholdInHrs:= getExceptionThreshold(404,userIdIn);
1388: debug_output('thresholdInHrs='||thresholdInHrs || ', sysdate = ' || sysdate);
1389: --if no threshold found it means exception is disabled, so exit procedure
1390: IF thresholdInHrs = -999 THEN

Line 1586: --get the threshold from mst_excep_preferences

1582: WHERE plan_id = plan_idIn
1583: AND exception_type = 405;
1584:
1585:
1586: --get the threshold from mst_excep_preferences
1587: thresholdInHrs := getExceptionThreshold(405,userIdIn);
1588: debug_output('thresholdInHrs='||thresholdInHrs || ', sysdate = ' || sysdate);
1589: --if no threshold found it means exception is disabled, so exit procedure
1590: IF thresholdInHrs = -999 THEN

Line 1877: --if no entry appears in mst_excep_preferences returns -999 (this is equivalent to a disabled exception)

1873: END IF;
1874: END testConv;
1875:
1876: --returns thresold (first looks for user value, then for global value if no user value is defined)
1877: --if no entry appears in mst_excep_preferences returns -999 (this is equivalent to a disabled exception)
1878: FUNCTION getExceptionThreshold (exceptionType NUMBER, userIdIn NUMBER) RETURN NUMBER IS
1879: total NUMBER;
1880: threshold NUMBER;
1881: BEGIN

Line 1882: --get the threshold from mst_excep_preferences

1878: FUNCTION getExceptionThreshold (exceptionType NUMBER, userIdIn NUMBER) RETURN NUMBER IS
1879: total NUMBER;
1880: threshold NUMBER;
1881: BEGIN
1882: --get the threshold from mst_excep_preferences
1883: BEGIN
1884: SELECT nvl(threshold_value,0) INTO threshold
1885: FROM mst_excep_preferences
1886: WHERE exception_type = exceptionType

Line 1885: FROM mst_excep_preferences

1881: BEGIN
1882: --get the threshold from mst_excep_preferences
1883: BEGIN
1884: SELECT nvl(threshold_value,0) INTO threshold
1885: FROM mst_excep_preferences
1886: WHERE exception_type = exceptionType
1887: and user_id = -9999
1888: and ROWNUM = 1;
1889: EXCEPTION