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_MESSAGE

Line 469: fnd_file.put_line(fnd_file.log, fnd_message.get);

465: valid_agent := false;
466: end if;
467:
468: if (v_url is null) and valid_agent then
469: fnd_file.put_line(fnd_file.log, fnd_message.get);
470: end if;
471: return v_url;
472: END construct_url;
473:

Line 1979: fnd_message.clear;

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');
1983: --dbms_output.put_line('MET ALERT: ' || fnd_message.get);

Line 1980: fnd_message.set_name('FND','OAM_DASHBOARD_METRIC_ALERT');

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');
1983: --dbms_output.put_line('MET ALERT: ' || fnd_message.get);
1984: fnd_log.message(log_level=>fnd_log.level_unexpected,

Line 1981: fnd_message.set_token_sql('METRICS_AND_VALUES',

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');
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',

Line 1983: --dbms_output.put_line('MET ALERT: ' || fnd_message.get);

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');
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;

Line 1992: fnd_message.clear;

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');
1996: --dbms_output.put_line('STATUS ALERT: ' || fnd_message.get);

Line 1993: fnd_message.set_name('FND','OAM_DASHBOARD_STATUS_ALERT');

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');
1996: --dbms_output.put_line('STATUS ALERT: ' || fnd_message.get);
1997: fnd_log.message(log_level=>fnd_log.level_unexpected,

Line 1994: fnd_message.set_token_sql('COMPONENTS_AND_STATUS',

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');
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',

Line 1996: --dbms_output.put_line('STATUS ALERT: ' || fnd_message.get);

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');
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;

Line 2334: p_ret_msg := fnd_message.get;

2330: p_ret_msg := ret_msg;
2331:
2332: -- check for any errors in the request submission
2333: if (p_ret_code = 0) then
2334: p_ret_msg := fnd_message.get;
2335: end if;
2336: exception
2337: -- some error occurred
2338: when others then

Line 2438: fnd_message.clear;

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);
2442: v_attch_id := fnd_log.message_with_attachment(

Line 2439: fnd_message.set_name('FND','OAM_SYSAL_LONG_RUNNING_REQ_GEN');

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);
2442: v_attch_id := fnd_log.message_with_attachment(
2443: log_level=>fnd_log.level_unexpected,

Line 2440: fnd_message.set_token('COUNT',v_lng_run_req_count);

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);
2442: v_attch_id := fnd_log.message_with_attachment(
2443: log_level=>fnd_log.level_unexpected,
2444: module=>MODULE||'.Alert_Long_Running_Requests',

Line 2441: fnd_message.set_token('TOLERANCE',v_lng_run_req_tolerance);

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);
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);

Line 2448: pmessage => fnd_message.get);

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,
2451: pmessage => ' ');
2452: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop

Line 2556: fnd_message.clear;

2552: -- Note: In the future if we provide users with more options, we
2553: -- may need to choose different messages based on those options
2554:
2555: -- raise proxy alert for each request
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(

Line 2557: fnd_message.set_name('FND','OAM_SYSAL_LONG_RUNNING_REQ_SPE');

2553: -- may need to choose different messages based on those options
2554:
2555: -- raise proxy alert for each request
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',

Line 2558: fnd_message.set_token('PROG', v_spec_req_list_rec.display_name(i));

2554:
2555: -- raise proxy alert for each request
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,

Line 2559: fnd_message.set_token('TOLERANCE', v_spec_tol);

2555: -- raise proxy alert for each request
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));

Line 2631: fnd_message.clear;

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);
2635: v_attch_id := fnd_log.message_with_attachment(

Line 2632: fnd_message.set_name('FND','OAM_SYSAL_LONG_PENDING_REQ_GEN');

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);
2635: v_attch_id := fnd_log.message_with_attachment(
2636: log_level=>fnd_log.level_unexpected,

Line 2633: fnd_message.set_token('COUNT',v_lng_pend_req_count);

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);
2635: v_attch_id := fnd_log.message_with_attachment(
2636: log_level=>fnd_log.level_unexpected,
2637: module=>MODULE||'.Alert_Long_Pending_Requests',

Line 2634: fnd_message.set_token('TOLERANCE',v_lng_pend_req_tolerance);

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);
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);

Line 2641: pmessage => fnd_message.get);

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,
2644: pmessage => ' ');
2645: for i in v_req_list_rec.request_id.FIRST..v_req_list_rec.request_id.LAST loop

Line 2724: fnd_message.clear;

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));
2728: fnd_log.proxy_alert_for_conc_req(

Line 2725: fnd_message.set_name('FND','OAM_SYSAL_LONG_PENDING_REQ_SPE');

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));
2728: fnd_log.proxy_alert_for_conc_req(
2729: module => MODULE||'.Alert_Long_Pending_Requests',

Line 2726: fnd_message.set_token('PROG', v_spec_req_list_rec.display_name(i));

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));
2728: fnd_log.proxy_alert_for_conc_req(
2729: module => MODULE||'.Alert_Long_Pending_Requests',
2730: pop_message => true,

Line 2727: fnd_message.set_token('TOLERANCE', v_spec_req_list_rec.tolerance(i));

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));
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));