APPS.FND_OAM_COLLECTION dependencies on FND_LOG_UNIQUE_EXCEPTIONS

Line 1708: select count(*) into ct_new_al from fnd_log_unique_exceptions where

1704: ct_open_occ number;
1705: BEGIN
1706: if (is_collection_enabled('USER_ALERT_NEW')) then
1707: -- get the number of new alerts
1708: select count(*) into ct_new_al from fnd_log_unique_exceptions where
1709: status='N' and category='USER';
1710:
1711: -- update new alerts
1712: update_metric_internal('USER_ALERT_NEW', to_char(ct_new_al), -1);

Line 1718: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue

1714:
1715: if (is_collection_enabled('USER_ALERT_NEW_OCC')) then
1716: -- get the number of new occurrences
1717: select count(*) into ct_new_occ
1718: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue
1719: where fle.unique_exception_id = flue.unique_exception_id
1720: and flue.status='N'
1721: and flue.category='USER';
1722:

Line 1730: select count(*) into ct_open_al from fnd_log_unique_exceptions where

1726:
1727:
1728: if (is_collection_enabled('USER_ALERT_OPEN')) then
1729: -- get number of open alerts
1730: select count(*) into ct_open_al from fnd_log_unique_exceptions where
1731: status='O' and category='USER';
1732:
1733: -- update open alerts
1734: update_metric_internal('USER_ALERT_OPEN', to_char(ct_open_al), -1);

Line 1740: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue

1736:
1737: if (is_collection_enabled('USER_ALERT_OPEN_OCC')) then
1738: -- get the number of open occurrences
1739: select count(*) into ct_open_occ
1740: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue
1741: where fle.unique_exception_id = flue.unique_exception_id
1742: and flue.status='O'
1743: and flue.category='USER';
1744:

Line 1792: select count(*) into ct_new_al from fnd_log_unique_exceptions where

1788: ct_open_occ number;
1789: BEGIN
1790: if (is_collection_enabled('CRIT_UNPR_EXCEP')) then
1791: -- get the number of new alerts
1792: select count(*) into ct_new_al from fnd_log_unique_exceptions where
1793: status='N';
1794:
1795: -- update new alerts
1796: update_metric_internal('CRIT_UNPR_EXCEP', to_char(ct_new_al), -1);

Line 1802: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue

1798:
1799: if (is_collection_enabled('CRIT_PR_EXCEP')) then
1800: -- get the number of new occurrences
1801: select count(*) into ct_new_occ
1802: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue
1803: where fle.unique_exception_id = flue.unique_exception_id
1804: and flue.status='N';
1805:
1806: -- update new occurrances

Line 1813: select count(*) into ct_open_al from fnd_log_unique_exceptions where

1809:
1810:
1811: if (is_collection_enabled('CRIT_TOTAL_UNPR_EXCEP')) then
1812: -- get number of open alerts
1813: select count(*) into ct_open_al from fnd_log_unique_exceptions where
1814: status='O';
1815:
1816: -- update open alerts
1817: update_metric_internal('CRIT_TOTAL_UNPR_EXCEP', to_char(ct_open_al), -1);

Line 1823: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue

1819:
1820: if (is_collection_enabled('OPEN_OCC')) then
1821: -- get the number of open occurrences
1822: select count(*) into ct_open_occ
1823: from fnd_log_exceptions fle, fnd_log_unique_exceptions flue
1824: where fle.unique_exception_id = flue.unique_exception_id
1825: and flue.status='O';
1826:
1827: -- update open occurrances

Line 2351: FUNCTION is_alert_open ( p_enc_msg fnd_log_unique_exceptions.encoded_message%TYPE) RETURN boolean

2347: -- API to check if an already new or open alert exists for the given
2348: -- encoded messge
2349: --
2350: /*
2351: FUNCTION is_alert_open ( p_enc_msg fnd_log_unique_exceptions.encoded_message%TYPE) RETURN boolean
2352: IS
2353: v_exists boolean := FALSE;
2354: v_temp number := 0;
2355: BEGIN

Line 2359: from fnd_log_unique_exceptions

2355: BEGIN
2356: debug('p_enc_msg: ' || p_enc_msg);
2357: begin
2358: select 1 into v_temp
2359: from fnd_log_unique_exceptions
2360: where encoded_message = p_enc_msg
2361: and status in ('N','O');
2362: v_exists := TRUE;
2363: exception