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.WF_DIAGNOSTICS dependencies on WF_MAIL

Line 10: th_bgcolor varchar2(7) := wf_mail.g_th_bgcolor;

6: table_border varchar2(2) := '0';
7: table_bgcolor varchar2(7) := 'white';
8:
9: -- Header attributes
10: th_bgcolor varchar2(7) := wf_mail.g_th_bgcolor;
11: th_fontcolor varchar2(7) := wf_mail.g_th_fontcolor;
12: th_fontface varchar2(80) := wf_mail.g_th_fontface;
13: th_fontsize varchar2(2) := wf_mail.g_th_fontsize;
14:

Line 11: th_fontcolor varchar2(7) := wf_mail.g_th_fontcolor;

7: table_bgcolor varchar2(7) := 'white';
8:
9: -- Header attributes
10: th_bgcolor varchar2(7) := wf_mail.g_th_bgcolor;
11: th_fontcolor varchar2(7) := wf_mail.g_th_fontcolor;
12: th_fontface varchar2(80) := wf_mail.g_th_fontface;
13: th_fontsize varchar2(2) := wf_mail.g_th_fontsize;
14:
15: -- Cell attributes

Line 12: th_fontface varchar2(80) := wf_mail.g_th_fontface;

8:
9: -- Header attributes
10: th_bgcolor varchar2(7) := wf_mail.g_th_bgcolor;
11: th_fontcolor varchar2(7) := wf_mail.g_th_fontcolor;
12: th_fontface varchar2(80) := wf_mail.g_th_fontface;
13: th_fontsize varchar2(2) := wf_mail.g_th_fontsize;
14:
15: -- Cell attributes
16: td_bgcolor varchar2(7) := wf_mail.g_td_bgcolor;

Line 13: th_fontsize varchar2(2) := wf_mail.g_th_fontsize;

9: -- Header attributes
10: th_bgcolor varchar2(7) := wf_mail.g_th_bgcolor;
11: th_fontcolor varchar2(7) := wf_mail.g_th_fontcolor;
12: th_fontface varchar2(80) := wf_mail.g_th_fontface;
13: th_fontsize varchar2(2) := wf_mail.g_th_fontsize;
14:
15: -- Cell attributes
16: td_bgcolor varchar2(7) := wf_mail.g_td_bgcolor;
17: td_fontcolor varchar2(7) := wf_mail.g_td_fontcolor;

Line 16: td_bgcolor varchar2(7) := wf_mail.g_td_bgcolor;

12: th_fontface varchar2(80) := wf_mail.g_th_fontface;
13: th_fontsize varchar2(2) := wf_mail.g_th_fontsize;
14:
15: -- Cell attributes
16: td_bgcolor varchar2(7) := wf_mail.g_td_bgcolor;
17: td_fontcolor varchar2(7) := wf_mail.g_td_fontcolor;
18: td_fontface varchar2(80) := wf_mail.g_td_fontface;
19: td_fontsize varchar2(2) := wf_mail.g_td_fontsize;
20:

Line 17: td_fontcolor varchar2(7) := wf_mail.g_td_fontcolor;

13: th_fontsize varchar2(2) := wf_mail.g_th_fontsize;
14:
15: -- Cell attributes
16: td_bgcolor varchar2(7) := wf_mail.g_td_bgcolor;
17: td_fontcolor varchar2(7) := wf_mail.g_td_fontcolor;
18: td_fontface varchar2(80) := wf_mail.g_td_fontface;
19: td_fontsize varchar2(2) := wf_mail.g_td_fontsize;
20:
21: -- Header

Line 18: td_fontface varchar2(80) := wf_mail.g_td_fontface;

14:
15: -- Cell attributes
16: td_bgcolor varchar2(7) := wf_mail.g_td_bgcolor;
17: td_fontcolor varchar2(7) := wf_mail.g_td_fontcolor;
18: td_fontface varchar2(80) := wf_mail.g_td_fontface;
19: td_fontsize varchar2(2) := wf_mail.g_td_fontsize;
20:
21: -- Header
22: g_head varchar2(50) := '';

Line 19: td_fontsize varchar2(2) := wf_mail.g_td_fontsize;

15: -- Cell attributes
16: td_bgcolor varchar2(7) := wf_mail.g_td_bgcolor;
17: td_fontcolor varchar2(7) := wf_mail.g_td_fontcolor;
18: td_fontface varchar2(80) := wf_mail.g_td_fontface;
19: td_fontsize varchar2(2) := wf_mail.g_td_fontsize;
20:
21: -- Header
22: g_head varchar2(50) := '';
23: g_end varchar2(50) := '';

Line 1484: wf_mail.test_flag := TRUE;

1480: from wf_notifications
1481: where notification_id = p_nid;
1482:
1483: if (l_mstatus not in ('MAIL')) then
1484: wf_mail.test_flag := TRUE;
1485: l_cells(1) := 'WH:Setting MAIL_STATUS to MAIL since the original status was ' || l_mstatus || '.';
1486: Get_Table(l_cells, 1, 'H', l_temp);
1487: l_cells.DELETE;
1488: l_result := l_result || l_temp;

Line 1496: wf_mail.getTemplateName(l_nid, l_status, l_mstatus, l_ttype, l_tname);

1492: end if;
1493: end if;
1494:
1495: begin
1496: wf_mail.getTemplateName(l_nid, l_status, l_mstatus, l_ttype, l_tname);
1497: exception
1498: when others then
1499: l_ttype := null;
1500: l_tname := null;

Line 1513: Wf_Mail.Get_Ntf_Language(l_nid, l_ntf_lang, l_ntf_terr, l_ntf_codeset);

1509: l_user_terr, l_osys, l_osysid, l_installed);
1510:
1511: l_ntf_lang := l_user_lang;
1512: l_ntf_terr := l_user_terr;
1513: Wf_Mail.Get_Ntf_Language(l_nid, l_ntf_lang, l_ntf_terr, l_ntf_codeset);
1514:
1515: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);
1516:
1517: -- Storing all the possible language/territory combinations for the given

Line 1515: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);

1511: l_ntf_lang := l_user_lang;
1512: l_ntf_terr := l_user_terr;
1513: Wf_Mail.Get_Ntf_Language(l_nid, l_ntf_lang, l_ntf_terr, l_ntf_codeset);
1514:
1515: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);
1516:
1517: -- Storing all the possible language/territory combinations for the given
1518: -- notification id in a parameter list
1519: l_lang_list(1).language := l_user_lang;

Line 1728: WHERE component_type = 'WF_MAILER'

1724: --
1725: CURSOR c_get_components_id is
1726: SELECT component_id
1727: FROM FND_SVC_COMPONENTS
1728: WHERE component_type = 'WF_MAILER'
1729: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;
1730:
1731: begin
1732:

Line 1734: wf_mail.Set_FYI_Flag(FALSE);

1730:
1731: begin
1732:
1733: l_ttype := 'WFMAIL'; -- Set the default type;
1734: wf_mail.Set_FYI_Flag(FALSE);
1735:
1736: -- GET tamplte name of a Mailer component
1737: for rec_component in c_get_components_id loop
1738:

Line 1783: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);

1779: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,
1780: l_npref, l_user_lang, l_user_terr,
1781: l_osys, l_osysid, l_installed);
1782: -- get Session lang
1783: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);
1784:
1785: -- l_user_lang should be valid within wf_langauges
1786: select installed_flag
1787: into l_installed

Line 1996: wf_mail.test_flag := TRUE;

1992: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1993:
1994: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1995:
1996: wf_mail.test_flag := TRUE;
1997: l_before := dbms_utility.get_time();
1998: begin
1999: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);
2000: exception

Line 2097: wf_mail.test_flag := TRUE;

2093:
2094: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);
2095: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
2096:
2097: wf_mail.test_flag := TRUE;
2098:
2099: l_before := dbms_utility.get_time();
2100:
2101: begin

Line 2384: a.profile_option_name in ('APPS_FRAMEWORK_AGENT', 'WF_MAIL_WEB_AGENT',

2380: select profile_option_name, profile_option_value
2381: from fnd_profile_options a, fnd_profile_option_values b
2382: where a.application_id = b.application_id and
2383: a.profile_option_id = b.profile_option_id and
2384: a.profile_option_name in ('APPS_FRAMEWORK_AGENT', 'WF_MAIL_WEB_AGENT',
2385: 'AMPOOL_ENABLED', 'ICX_LIMIT_TIME',
2386: 'ICX_LIMIT_CONNECT', 'ICX_SESSION_TIMEOUT',
2387: 'FRAMEWORK_URL_TIMEOUT')
2388: and b.level_value = 0;

Line 2487: from wf_mailer_tags

2483: tag_id,
2484: action,
2485: pattern,
2486: allow_reload
2487: from wf_mailer_tags
2488: order by name;
2489: begin
2490: l_cells(1) := 'WH:Workflow Notification Tags Value';
2491: Get_Table(l_cells, 1, 'H', l_result);

Line 3110: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);

3106:
3107: -- GSC Mailer component parameters
3108: l_temp_result := '
'||wf_core.newline;
3109: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3110: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);
3111:
3112: -- GSC Mailer component scheduled events
3113: l_temp_result := '
'||wf_core.newline;
3114: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 3115: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);

3111:
3112: -- GSC Mailer component scheduled events
3113: l_temp_result := '
'||wf_core.newline;
3114: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3115: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
3116:
3117: -- Mailer Tags
3118: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;
3119: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 3311: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);

3307:
3308: -- GSC Mailer component parameters
3309: l_temp_result := '
'||wf_core.newline;
3310: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3311: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);
3312: l_temp_result := 'Go to top
'||wf_core.newline;
3314: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3315:

Line 3319: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);

3315:
3316: -- GSC Mailer component scheduled events
3317: l_temp_result := '
'||wf_core.newline;
3318: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3319: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
3320: l_temp_result := 'Go to top
'||wf_core.newline;
3322: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3323:

Line 4616: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);

4612:
4613: -- GSC Mailer component parameters
4614: l_temp_result := '
'||wf_core.newline;
4615: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4616: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);
4617:
4618: -- GSC Mailer component scheduled events
4619: l_temp_result := '
'||wf_core.newline;
4620: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 4621: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);

4617:
4618: -- GSC Mailer component scheduled events
4619: l_temp_result := '
'||wf_core.newline;
4620: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4621: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
4622:
4623: -- Mailer Tags
4624: l_temp_result := '
'||wf_core.newline;
4625: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 4727: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);

4723: l_temp_result := '
'||wf_core.newline;
4724: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4725:
4726: -- GSC Mailer component parameters
4727: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);
4728: l_temp_result := '
'||wf_core.newline;
4729: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4730:
4731: -- GSC Mailer component scheduled events

Line 4732: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);

4728: l_temp_result := '
'||wf_core.newline;
4729: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4730:
4731: -- GSC Mailer component scheduled events
4732: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
4733: l_temp_result := '
'||wf_core.newline;
4734: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4735:
4736: -- Mailer Tags