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 1306: wf_mail.test_flag := TRUE;

1302: from wf_notifications
1303: where notification_id = p_nid;
1304:
1305: if (l_mstatus not in ('MAIL')) then
1306: wf_mail.test_flag := TRUE;
1307: l_cells(1) := 'WH:Setting MAIL_STATUS to MAIL since the original status was ' || l_mstatus || '.';
1308: Get_Table(l_cells, 1, 'H', l_temp);
1309: l_cells.DELETE;
1310: l_result := l_result || l_temp;

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

1314: end if;
1315: end if;
1316:
1317: begin
1318: wf_mail.getTemplateName(l_nid, l_status, l_mstatus, l_ttype, l_tname);
1319: exception
1320: when others then
1321: l_ttype := null;
1322: l_tname := null;

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

1331: l_user_terr, l_osys, l_osysid, l_installed);
1332:
1333: l_ntf_lang := l_user_lang;
1334: l_ntf_terr := l_user_terr;
1335: Wf_Mail.Get_Ntf_Language(l_nid, l_ntf_lang, l_ntf_terr, l_ntf_codeset);
1336:
1337: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);
1338:
1339: -- Storing all the possible language/territory combinations for the given

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

1333: l_ntf_lang := l_user_lang;
1334: l_ntf_terr := l_user_terr;
1335: Wf_Mail.Get_Ntf_Language(l_nid, l_ntf_lang, l_ntf_terr, l_ntf_codeset);
1336:
1337: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);
1338:
1339: -- Storing all the possible language/territory combinations for the given
1340: -- notification id in a parameter list
1341: l_lang_list(1).language := l_user_lang;

Line 1541: WHERE component_type = 'WF_MAILER'

1537: --
1538: CURSOR c_get_components_id is
1539: SELECT component_id
1540: FROM FND_SVC_COMPONENTS
1541: WHERE component_type = 'WF_MAILER'
1542: order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;
1543:
1544: begin
1545:

Line 1547: wf_mail.Set_FYI_Flag(FALSE);

1543:
1544: begin
1545:
1546: l_ttype := 'WFMAIL'; -- Set the default type;
1547: wf_mail.Set_FYI_Flag(FALSE);
1548:
1549: -- GET tamplte name of a Mailer component
1550: for rec_component in c_get_components_id loop
1551:

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

1592: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,
1593: l_npref, l_user_lang, l_user_terr,
1594: l_osys, l_osysid, l_installed);
1595: -- get Session lang
1596: Wf_Mail.GetSessionLanguage(l_ses_lang, l_ses_terr, l_ses_codeset);
1597:
1598: -- l_user_lang should be valid within wf_langauges
1599: select installed_flag
1600: into l_installed

Line 1809: wf_mail.test_flag := TRUE;

1805: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1806:
1807: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1808:
1809: wf_mail.test_flag := TRUE;
1810: l_before := dbms_utility.get_time();
1811: begin
1812: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);
1813: exception

Line 1910: wf_mail.test_flag := TRUE;

1906:
1907: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);
1908: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1909:
1910: wf_mail.test_flag := TRUE;
1911:
1912: l_before := dbms_utility.get_time();
1913:
1914: begin

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

2193: select profile_option_name, profile_option_value
2194: from fnd_profile_options a, fnd_profile_option_values b
2195: where a.application_id = b.application_id and
2196: a.profile_option_id = b.profile_option_id and
2197: a.profile_option_name in ('APPS_FRAMEWORK_AGENT', 'WF_MAIL_WEB_AGENT',
2198: 'AMPOOL_ENABLED', 'ICX_LIMIT_TIME',
2199: 'ICX_LIMIT_CONNECT', 'ICX_SESSION_TIMEOUT',
2200: 'FRAMEWORK_URL_TIMEOUT')
2201: and b.level_value = 0;

Line 2252: from wf_mailer_tags

2248: tag_id,
2249: action,
2250: pattern,
2251: allow_reload
2252: from wf_mailer_tags
2253: order by name;
2254: begin
2255: l_cells(1) := 'WH:Workflow Notification Tags Value';
2256: Get_Table(l_cells, 1, 'H', l_result);

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

2789:
2790: -- GSC Mailer component parameters
2791: l_temp_result := '
'||wf_core.newline;
2792: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2793: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);
2794:
2795: -- GSC Mailer component scheduled events
2796: l_temp_result := '
'||wf_core.newline;
2797: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

2794:
2795: -- GSC Mailer component scheduled events
2796: l_temp_result := '
'||wf_core.newline;
2797: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2798: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
2799:
2800: -- Mailer Tags
2801: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;
2802: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

2956:
2957: -- GSC Mailer component parameters
2958: l_temp_result := '
'||wf_core.newline;
2959: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2960: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);
2961: l_temp_result := 'Go to top
'||wf_core.newline;
2963: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2964:

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

2964:
2965: -- GSC Mailer component scheduled events
2966: l_temp_result := '
'||wf_core.newline;
2967: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2968: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
2969: l_temp_result := 'Go to top
'||wf_core.newline;
2971: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2972:

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

4261:
4262: -- GSC Mailer component parameters
4263: l_temp_result := '
'||wf_core.newline;
4264: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4265: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);
4266:
4267: -- GSC Mailer component scheduled events
4268: l_temp_result := '
'||wf_core.newline;
4269: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

4266:
4267: -- GSC Mailer component scheduled events
4268: l_temp_result := '
'||wf_core.newline;
4269: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4270: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
4271:
4272: -- Mailer Tags
4273: l_temp_result := '
'||wf_core.newline;
4274: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

4372: l_temp_result := '
'||wf_core.newline;
4373: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4374:
4375: -- GSC Mailer component parameters
4376: Get_GSC_Comp_Parameters('WF_MAILER', null, l_value);
4377: l_temp_result := '
'||wf_core.newline;
4378: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4379:
4380: -- GSC Mailer component scheduled events

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

4377: l_temp_result := '
'||wf_core.newline;
4378: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4379:
4380: -- GSC Mailer component scheduled events
4381: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
4382: l_temp_result := '
'||wf_core.newline;
4383: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4384:
4385: -- Mailer Tags