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.FND_OAM_COLLECTION dependencies on FND_LOG

Line 1388: from fnd_login_resp_forms F,

1384: if (is_collection_enabled('ACTIVE_USERS')) then
1385: -- get the number of active users
1386: select count(distinct(F.login_id))
1387: into ct_active_users
1388: from fnd_login_resp_forms F,
1389: gv$session S
1390: where F.AUDSID = S.AUDSID;
1391:
1392: -- update the number of active forms users

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 1978: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then

1974: end if;
1975: end loop;
1976:
1977: if (length(v_metric_list) > 0) then
1978: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
1979: fnd_message.clear;
1980: fnd_message.set_name('FND','OAM_DASHBOARD_METRIC_ALERT');
1981: fnd_message.set_token_sql('METRICS_AND_VALUES',
1982: 'select fnd_oam_dashboard_util.get_trans_name_values(''MET'','''||v_metric_list||''') from dual');

Line 1984: fnd_log.message(log_level=>fnd_log.level_unexpected,

1980: fnd_message.set_name('FND','OAM_DASHBOARD_METRIC_ALERT');
1981: fnd_message.set_token_sql('METRICS_AND_VALUES',
1982: 'select fnd_oam_dashboard_util.get_trans_name_values(''MET'','''||v_metric_list||''') from dual');
1983: --dbms_output.put_line('MET ALERT: ' || fnd_message.get);
1984: fnd_log.message(log_level=>fnd_log.level_unexpected,
1985: module=>MODULE||'.raise_alert',
1986: pop_message=>true);
1987: end if;
1988: end if;

Line 1991: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then

1987: end if;
1988: end if;
1989:
1990: if (length(v_st_list) > 0) then
1991: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
1992: fnd_message.clear;
1993: fnd_message.set_name('FND','OAM_DASHBOARD_STATUS_ALERT');
1994: fnd_message.set_token_sql('COMPONENTS_AND_STATUS',
1995: 'select fnd_oam_dashboard_util.get_trans_name_values(''STATUS'','''||v_st_list||''') from dual');

Line 1997: fnd_log.message(log_level=>fnd_log.level_unexpected,

1993: fnd_message.set_name('FND','OAM_DASHBOARD_STATUS_ALERT');
1994: fnd_message.set_token_sql('COMPONENTS_AND_STATUS',
1995: 'select fnd_oam_dashboard_util.get_trans_name_values(''STATUS'','''||v_st_list||''') from dual');
1996: --dbms_output.put_line('STATUS ALERT: ' || fnd_message.get);
1997: fnd_log.message(log_level=>fnd_log.level_unexpected,
1998: module=>MODULE||'.raise_alert',
1999: pop_message=>true);
2000: end if;
2001: end if;

Line 2315: if (fnd_log.level_event >= fnd_log.g_current_runtime_level) then

2311: return;
2312: end if;
2313:
2314: -- log some debugging info
2315: if (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
2316: fnd_log.string(log_level=>fnd_log.level_event,
2317: module=>MODULE||'.resubmit',
2318: message=>'Cancelled Request ' || p_r.request_id);
2319: end if;

Line 2316: fnd_log.string(log_level=>fnd_log.level_event,

2312: end if;
2313:
2314: -- log some debugging info
2315: if (fnd_log.level_event >= fnd_log.g_current_runtime_level) then
2316: fnd_log.string(log_level=>fnd_log.level_event,
2317: module=>MODULE||'.resubmit',
2318: message=>'Cancelled Request ' || p_r.request_id);
2319: end if;
2320: end;

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

Line 2437: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then

2433: close req_id_list;
2434:
2435: if ((v_req_list_rec.request_id is not null) and (v_req_list_rec.request_id.count >= TO_NUMBER(v_lng_run_req_count))) then
2436: -- raise alert with attachment
2437: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
2438: fnd_message.clear;
2439: fnd_message.set_name('FND','OAM_SYSAL_LONG_RUNNING_REQ_GEN');
2440: fnd_message.set_token('COUNT',v_lng_run_req_count);
2441: fnd_message.set_token('TOLERANCE',v_lng_run_req_tolerance);

Line 2442: v_attch_id := fnd_log.message_with_attachment(

2438: fnd_message.clear;
2439: fnd_message.set_name('FND','OAM_SYSAL_LONG_RUNNING_REQ_GEN');
2440: fnd_message.set_token('COUNT',v_lng_run_req_count);
2441: fnd_message.set_token('TOLERANCE',v_lng_run_req_tolerance);
2442: v_attch_id := fnd_log.message_with_attachment(
2443: log_level=>fnd_log.level_unexpected,
2444: module=>MODULE||'.Alert_Long_Running_Requests',
2445: pop_message=>false);
2446: fnd_log_attachment.writeln(

Line 2443: log_level=>fnd_log.level_unexpected,

2439: fnd_message.set_name('FND','OAM_SYSAL_LONG_RUNNING_REQ_GEN');
2440: fnd_message.set_token('COUNT',v_lng_run_req_count);
2441: fnd_message.set_token('TOLERANCE',v_lng_run_req_tolerance);
2442: v_attch_id := fnd_log.message_with_attachment(
2443: log_level=>fnd_log.level_unexpected,
2444: module=>MODULE||'.Alert_Long_Running_Requests',
2445: pop_message=>false);
2446: fnd_log_attachment.writeln(
2447: pattachment_id => v_attch_id,

Line 2446: fnd_log_attachment.writeln(

2442: v_attch_id := fnd_log.message_with_attachment(
2443: log_level=>fnd_log.level_unexpected,
2444: module=>MODULE||'.Alert_Long_Running_Requests',
2445: pop_message=>false);
2446: fnd_log_attachment.writeln(
2447: pattachment_id => v_attch_id,
2448: pmessage => fnd_message.get);
2449: fnd_log_attachment.writeln(
2450: pattachment_id => v_attch_id,

Line 2449: fnd_log_attachment.writeln(

2445: pop_message=>false);
2446: fnd_log_attachment.writeln(
2447: pattachment_id => v_attch_id,
2448: pmessage => fnd_message.get);
2449: fnd_log_attachment.writeln(
2450: pattachment_id => v_attch_id,
2451: pmessage => ' ');
2452: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop
2453: -- write info to attachment about each request.

Line 2454: fnd_log_attachment.writeln(

2450: pattachment_id => v_attch_id,
2451: pmessage => ' ');
2452: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop
2453: -- write info to attachment about each request.
2454: fnd_log_attachment.writeln(
2455: pattachment_id => v_attch_id,
2456: pmessage => v_req_list_rec.request_id(i) || ' - ' ||
2457: v_req_list_rec.display_name(i));
2458: end loop;

Line 2459: fnd_log_attachment.close(

2455: pattachment_id => v_attch_id,
2456: pmessage => v_req_list_rec.request_id(i) || ' - ' ||
2457: v_req_list_rec.display_name(i));
2458: end loop;
2459: fnd_log_attachment.close(
2460: pattachment_id => v_attch_id);
2461: end if;
2462: end if;
2463: end if; -- if(v_lng_run_req_alert_enable ='Y') then

Line 2544: if ((fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)) then

2540:
2541: if (v_spec_req_list_rec.request_id is not null and v_spec_req_list_rec.request_id.count > 0) then
2542: for i in v_spec_req_list_rec.request_id.FIRST..v_spec_req_list_rec.request_id.LAST loop
2543: --debug('Looping in cursor spec_req_id_list');
2544: if ((fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)) then
2545: -- Compute tolerance for this program
2546: v_spec_tol := round(
2547: nvl(v_spec_req_list_rec.threshold(i),
2548: v_spec_req_list_rec.avg_run_time(i))*(

Line 2560: fnd_log.proxy_alert_for_conc_req(

2556: fnd_message.clear;
2557: fnd_message.set_name('FND','OAM_SYSAL_LONG_RUNNING_REQ_SPE');
2558: fnd_message.set_token('PROG', v_spec_req_list_rec.display_name(i));
2559: fnd_message.set_token('TOLERANCE', v_spec_tol);
2560: fnd_log.proxy_alert_for_conc_req(
2561: module => MODULE||'.Alert_Long_Running_Requests',
2562: pop_message => true,
2563: request_id => v_spec_req_list_rec.request_id(i));
2564: end if;

Line 2630: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then

2626: into v_req_list_rec.request_id, v_req_list_rec.display_name;
2627: close req_id_list;
2628:
2629: if (v_req_list_rec.request_id is not null and v_req_list_rec.request_id.count >= TO_NUMBER(v_lng_pend_req_count)) then
2630: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
2631: fnd_message.clear;
2632: fnd_message.set_name('FND','OAM_SYSAL_LONG_PENDING_REQ_GEN');
2633: fnd_message.set_token('COUNT',v_lng_pend_req_count);
2634: fnd_message.set_token('TOLERANCE',v_lng_pend_req_tolerance);

Line 2635: v_attch_id := fnd_log.message_with_attachment(

2631: fnd_message.clear;
2632: fnd_message.set_name('FND','OAM_SYSAL_LONG_PENDING_REQ_GEN');
2633: fnd_message.set_token('COUNT',v_lng_pend_req_count);
2634: fnd_message.set_token('TOLERANCE',v_lng_pend_req_tolerance);
2635: v_attch_id := fnd_log.message_with_attachment(
2636: log_level=>fnd_log.level_unexpected,
2637: module=>MODULE||'.Alert_Long_Pending_Requests',
2638: pop_message=>false);
2639: fnd_log_attachment.writeln(

Line 2636: log_level=>fnd_log.level_unexpected,

2632: fnd_message.set_name('FND','OAM_SYSAL_LONG_PENDING_REQ_GEN');
2633: fnd_message.set_token('COUNT',v_lng_pend_req_count);
2634: fnd_message.set_token('TOLERANCE',v_lng_pend_req_tolerance);
2635: v_attch_id := fnd_log.message_with_attachment(
2636: log_level=>fnd_log.level_unexpected,
2637: module=>MODULE||'.Alert_Long_Pending_Requests',
2638: pop_message=>false);
2639: fnd_log_attachment.writeln(
2640: pattachment_id => v_attch_id,

Line 2639: fnd_log_attachment.writeln(

2635: v_attch_id := fnd_log.message_with_attachment(
2636: log_level=>fnd_log.level_unexpected,
2637: module=>MODULE||'.Alert_Long_Pending_Requests',
2638: pop_message=>false);
2639: fnd_log_attachment.writeln(
2640: pattachment_id => v_attch_id,
2641: pmessage => fnd_message.get);
2642: fnd_log_attachment.writeln(
2643: pattachment_id => v_attch_id,

Line 2642: fnd_log_attachment.writeln(

2638: pop_message=>false);
2639: fnd_log_attachment.writeln(
2640: pattachment_id => v_attch_id,
2641: pmessage => fnd_message.get);
2642: fnd_log_attachment.writeln(
2643: pattachment_id => v_attch_id,
2644: pmessage => ' ');
2645: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop
2646: -- write info to attachment about each request.

Line 2647: fnd_log_attachment.writeln(

2643: pattachment_id => v_attch_id,
2644: pmessage => ' ');
2645: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop
2646: -- write info to attachment about each request.
2647: fnd_log_attachment.writeln(
2648: pattachment_id => v_attch_id,
2649: pmessage => v_req_list_rec.request_id(i) || ' - ' ||
2650: v_req_list_rec.display_name(i));
2651: end loop;

Line 2652: fnd_log_attachment.close(

2648: pattachment_id => v_attch_id,
2649: pmessage => v_req_list_rec.request_id(i) || ' - ' ||
2650: v_req_list_rec.display_name(i));
2651: end loop;
2652: fnd_log_attachment.close(
2653: pattachment_id => v_attch_id);
2654: end if;
2655: end if;
2656: end if; -- if(v_lng_pend_req_alert_enable ='Y') then

Line 2723: if ((fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)) then

2719: close spec_req_id_list;
2720:
2721: if (v_spec_req_list_rec.request_id is not null and v_spec_req_list_rec.request_id.count > 0) then
2722: for i in v_spec_req_list_rec.request_id.FIRST..v_spec_req_list_rec.request_id.LAST loop
2723: if ((fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)) then
2724: fnd_message.clear;
2725: fnd_message.set_name('FND','OAM_SYSAL_LONG_PENDING_REQ_SPE');
2726: fnd_message.set_token('PROG', v_spec_req_list_rec.display_name(i));
2727: fnd_message.set_token('TOLERANCE', v_spec_req_list_rec.tolerance(i));

Line 2728: fnd_log.proxy_alert_for_conc_req(

2724: fnd_message.clear;
2725: fnd_message.set_name('FND','OAM_SYSAL_LONG_PENDING_REQ_SPE');
2726: fnd_message.set_token('PROG', v_spec_req_list_rec.display_name(i));
2727: fnd_message.set_token('TOLERANCE', v_spec_req_list_rec.tolerance(i));
2728: fnd_log.proxy_alert_for_conc_req(
2729: module => MODULE||'.Alert_Long_Pending_Requests',
2730: pop_message => true,
2731: request_id => v_spec_req_list_rec.request_id(i));
2732: end if;

Line 2774: if (fnd_log.level_unexpected < fnd_log.g_current_runtime_level) then

2770: --
2771: -- Check logging enabled in the first place. There's nothing to do
2772: -- if not enabled.
2773: --
2774: if (fnd_log.level_unexpected < fnd_log.g_current_runtime_level) then
2775: fnd_file.put_line(fnd_file.log, 'Logging Not Enabled.');
2776: return;
2777: end if;
2778:

Line 2818: if (fnd_log.level_unexpected < fnd_log.g_current_runtime_level) then

2814: --
2815: -- Check logging enabled in the first place. There's nothing to do
2816: -- if not enabled.
2817: --
2818: if (fnd_log.level_unexpected < fnd_log.g_current_runtime_level) then
2819: fnd_file.put_line(fnd_file.log, 'Logging Not Enabled.');
2820: return;
2821: end if;
2822: