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_CORE

Line 29: g_qowner varchar2(30) := Wf_Core.Translate('WF_SCHEMA');

25: -- Temp CLOB
26: l_temp CLOB;
27:
28: -- Queue owner
29: g_qowner varchar2(30) := Wf_Core.Translate('WF_SCHEMA');
30:
31: -- Queue name constants
32: WFD_NTF_OUT varchar2(30) := 'WF_NOTIFICATION_OUT';
33: WFD_NTF_IN varchar2(30) := 'WF_NOTIFICATION_IN';

Line 116: l_table := l_table||wf_core.newline||'

112: if ((p_dir = 'V' and l_mod = 1) or (p_dir = 'H' and i <= p_cols)) then
113: l_colon := instr(l_text,':');
114: l_width := substr(l_text, 1, l_colon-1);
115: l_text := substr(l_text, l_colon+1);
116: l_table := l_table||wf_core.newline||' 117:
118: if (l_width is not null) then
119: l_table := l_table||' width='||l_width;
120: end if;

Line 127: l_table := l_table||wf_core.newline||'

123: ||' size='||l_th_fontsize||'>';
124: l_table := l_table|| l_text||'';
125: l_table := l_table||'';
126: else
127: l_table := l_table||wf_core.newline||' 128: l_table := l_table||' bgcolor='||l_td_bgcolor||'>';
129: l_table := l_table||' 130: ||' size='||l_td_fontsize||'>';
131: l_table := l_table||l_text||'';

Line 144: wf_core.context('WF_DIAGNOSTICS', 'Get_Table', 'Varchar2 Table');

140: p_table := l_table;
141: return;
142: exception
143: when others then
144: wf_core.context('WF_DIAGNOSTICS', 'Get_Table', 'Varchar2 Table');
145: raise;
146: end Get_Table;
147:
148: --

Line 223: l_table := l_table||wf_core.newline||'

219: if ((p_dir = 'V' and l_mod = 1) or (p_dir = 'H' and i <= p_cols)) then
220: l_colon := instr(l_text,':');
221: l_width := substr(l_text, 1, l_colon-1);
222: l_text := substr(l_text, l_colon+1);
223: l_table := l_table||wf_core.newline||' 224:
225: if (l_width is not null) then
226: l_table := l_table||' width='||l_width;
227: end if;

Line 234: l_table := l_table||wf_core.newline||'

230: ||' size='||l_th_fontsize||'>';
231: l_table := l_table|| l_text||'';
232: l_table := l_table||'';
233: else
234: l_table := l_table||wf_core.newline||' 235: l_table := l_table||' bgcolor='||l_td_bgcolor||'>';
236: l_table := l_table||' 237: ||' size='||l_td_fontsize||'>';
238: l_table := l_table||l_text||'';

Line 253: wf_core.context('WF_DIAGNOSTICS', 'Get_Table', 'CLOB Table');

249: dbms_lob.WriteAppend(p_table, length(l_table), l_table);
250: return;
251: exception
252: when others then
253: wf_core.context('WF_DIAGNOSTICS', 'Get_Table', 'CLOB Table');
254: raise;
255: end Get_Table;
256:
257: --

Line 497: if (wf_core.error_name is null) then

493: l_cells.DELETE;
494: l_cells(1) := '10%:Note';
495: l_cells(2) := 'Error when generating Notification Recipient Role Members Information for nid '||p_nid;
496: l_cells(3) := '10%:Error';
497: if (wf_core.error_name is null) then
498: l_cells(4) := sqlerrm;
499: else
500: l_cells(4) := wf_core.error_name;
501: end if;

Line 500: l_cells(4) := wf_core.error_name;

496: l_cells(3) := '10%:Error';
497: if (wf_core.error_name is null) then
498: l_cells(4) := sqlerrm;
499: else
500: l_cells(4) := wf_core.error_name;
501: end if;
502: Get_Table(l_cells, 2, 'V', l_result);
503: return l_result;
504: end Get_Ntf_Role_Users;

Line 567: if (wf_core.error_name is null) then

563: l_cells.DELETE;
564: l_cells(1) := '10%:Note';
565: l_cells(2) := 'Error when generating Notification Recipient Role Information for nid '||p_nid;
566: l_cells(3) := '10%:Error';
567: if (wf_core.error_name is null) then
568: l_cells(4) := sqlerrm;
569: else
570: l_cells(4) := wf_core.error_name;
571: end if;

Line 570: l_cells(4) := wf_core.error_name;

566: l_cells(3) := '10%:Error';
567: if (wf_core.error_name is null) then
568: l_cells(4) := sqlerrm;
569: else
570: l_cells(4) := wf_core.error_name;
571: end if;
572: Get_Table(l_cells, 2, 'V', l_result);
573: return l_result;
574: end Get_Ntf_Role_Info;

Line 641: if (wf_core.error_name is null) then

637: l_cells(1) := '10%:Note';
638: l_cells(2) := 'Error when generating Summary Notification Recipient ' ||
639: 'Role Members Info. for role '||p_role;
640: l_cells(3) := '10%:Error';
641: if (wf_core.error_name is null) then
642: l_cells(4) := sqlerrm;
643: else
644: l_cells(4) := wf_core.error_name;
645: end if;

Line 644: l_cells(4) := wf_core.error_name;

640: l_cells(3) := '10%:Error';
641: if (wf_core.error_name is null) then
642: l_cells(4) := sqlerrm;
643: else
644: l_cells(4) := wf_core.error_name;
645: end if;
646: Get_Table(l_cells, 2, 'V', l_result);
647: return l_result;
648: end Get_Summary_Ntf_Role_Users;

Line 712: if (wf_core.error_name is null) then

708: l_cells.DELETE;
709: l_cells(1) := '10%:Note';
710: l_cells(2) := 'Error when generating Notification Recipient Role Information for nid '||p_role;
711: l_cells(3) := '10%:Error';
712: if (wf_core.error_name is null) then
713: l_cells(4) := sqlerrm;
714: else
715: l_cells(4) := wf_core.error_name;
716: end if;

Line 715: l_cells(4) := wf_core.error_name;

711: l_cells(3) := '10%:Error';
712: if (wf_core.error_name is null) then
713: l_cells(4) := sqlerrm;
714: else
715: l_cells(4) := wf_core.error_name;
716: end if;
717: Get_Table(l_cells, 2, 'V', l_result);
718:
719: return l_result;

Line 786: if (wf_core.error_message is null) then

782: l_cells.DELETE;
783: l_cells(1) := '10%:Note';
784: l_cells(2) := 'Error when generating Notification More Info Role Information for nid '||p_nid;
785: l_cells(3) := '10%:Error';
786: if (wf_core.error_message is null) then
787: l_cells(4) := sqlerrm;
788: else
789: l_cells(4) := wf_core.error_message;
790: end if;

Line 789: l_cells(4) := wf_core.error_message;

785: l_cells(3) := '10%:Error';
786: if (wf_core.error_message is null) then
787: l_cells(4) := sqlerrm;
788: else
789: l_cells(4) := wf_core.error_message;
790: end if;
791: Get_Table(l_cells, 2, 'V', l_result);
792: return l_result;
793: end Get_Ntf_More_Info;

Line 1059: l_cells(1) := '20%(not defined)'||wf_core.newline;

1055: Get_Table(l_cells, 4, 'H', l_temp);
1056: dbms_lob.Append(p_value, l_temp);
1057:
1058: l_cells.DELETE;
1059: l_cells(1) := '20%(not defined)'||wf_core.newline;
1060: Get_Table(l_cells, 1, 'V', l_result);
1061: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1062:
1063: return;

Line 1556: wf_core.token('NAME', l_tname);

1552: where name = l_tname
1553: and type = l_ttype;
1554: exception
1555: when no_data_found then
1556: wf_core.token('NAME', l_tname);
1557: wf_core.token('TYPE', l_ttype);
1558: wf_core.raise('WFNTF_MESSAGE');
1559: end;
1560:

Line 1557: wf_core.token('TYPE', l_ttype);

1553: and type = l_ttype;
1554: exception
1555: when no_data_found then
1556: wf_core.token('NAME', l_tname);
1557: wf_core.token('TYPE', l_ttype);
1558: wf_core.raise('WFNTF_MESSAGE');
1559: end;
1560:
1561: l_result := NULL;

Line 1558: wf_core.raise('WFNTF_MESSAGE');

1554: exception
1555: when no_data_found then
1556: wf_core.token('NAME', l_tname);
1557: wf_core.token('TYPE', l_ttype);
1558: wf_core.raise('WFNTF_MESSAGE');
1559: end;
1560:
1561: l_result := NULL;
1562: l_cells(1) := '25%:Message Type';

Line 1567: l_result := l_result||l_temp||wf_core.newline;

1563: l_cells(2) := l_ttype;
1564: l_cells(3) := '25%:Message Name';
1565: l_cells(4) := l_tname;
1566: Get_Table(l_cells, 2, 'V', l_temp);
1567: l_result := l_result||l_temp||wf_core.newline;
1568: l_cells.DELETE;
1569: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1570: l_result := NULL;
1571:

Line 1582: l_result := l_result||''||wf_core.newline;

1578: l_result := l_result||Wf_Notification.SubstituteSpecialChars(l_txt_body);
1579: else
1580: l_result := '(not defined)';
1581: end if;
1582: l_result := l_result||''||wf_core.newline;
1583:
1584: l_result := l_result||'';
1586: l_result := l_result||'E-mail Message Template in HTML format. ('||l_nls_lang||'_'||l_nls_terr||')';

Line 1618: wf_core.token('NAME', l_msg_name );

1614: where name = l_msg_name
1615: and type = l_msg_type;
1616: exception
1617: when no_data_found then
1618: wf_core.token('NAME', l_msg_name );
1619: wf_core.token('TYPE', l_msg_type);
1620: wf_core.raise('WFNTF_MESSAGE');
1621: end;
1622:

Line 1619: wf_core.token('TYPE', l_msg_type);

1615: and type = l_msg_type;
1616: exception
1617: when no_data_found then
1618: wf_core.token('NAME', l_msg_name );
1619: wf_core.token('TYPE', l_msg_type);
1620: wf_core.raise('WFNTF_MESSAGE');
1621: end;
1622:
1623: l_result := NULL;

Line 1620: wf_core.raise('WFNTF_MESSAGE');

1616: exception
1617: when no_data_found then
1618: wf_core.token('NAME', l_msg_name );
1619: wf_core.token('TYPE', l_msg_type);
1620: wf_core.raise('WFNTF_MESSAGE');
1621: end;
1622:
1623: l_result := NULL;
1624: l_cells(1) := '25%:Message Type';

Line 1632: l_result := l_result||l_temp||wf_core.newline;

1628: l_cells(5) := '25%:Subject';
1629: l_cells(6) := l_subj;
1630:
1631: Get_Table(l_cells, 2, 'V', l_temp);
1632: l_result := l_result||l_temp||wf_core.newline;
1633: l_cells.DELETE;
1634: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1635: l_result := NULL;
1636:

Line 1647: l_result := l_result||''||wf_core.newline;

1643: l_result := l_result||Wf_Notification.SubstituteSpecialChars(l_txt_body);
1644: else
1645: l_result := l_result||'(not defined)';
1646: end if;
1647: l_result := l_result||''||wf_core.newline;
1648:
1649: l_result := l_result||'';
1651: l_result := l_result||'Notification Message Definition in HTML format. ('||l_nls_lang||'_'||l_nls_terr||')';

Line 1809: l_result := l_result||l_temp||wf_core.newline;

1805: l_cells(3) := '25%:Message Name';
1806: l_cells(4) := l_tname;
1807:
1808: Get_Table(l_cells, 2, 'V', l_temp);
1809: l_result := l_result||l_temp||wf_core.newline;
1810: l_cells.DELETE;
1811:
1812: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1813:

Line 1822: --l_result := l_result||wf_core.newline;

1818: || th_fontface|| ' size='||th_fontsize||' color='||th_fontcolor||'>';
1819:
1820: l_result := l_result||'Summary Message Template in TEXT format. ('||
1821: l_user_lang||'_'||l_user_terr||')';
1822: --l_result := l_result||wf_core.newline;
1823: l_result := l_result||'

';

1824: 

1825:         if (l_txt_body is not null) then

1826:             l_result := l_result||Wf_Notification.SubstituteSpecialChars(l_txt_body);


Line 1831: l_result := l_result||'

'||wf_core.newline;

1827: else
1828: l_result := '(not defined or user language ' || l_user_lang ||' is not installed )';
1829: end if;
1830:
1831: l_result := l_result||''||wf_core.newline;
1832:
1833: l_result := l_result||'';
1835: l_result := l_result||'Summary Message Template in HTML format. ('||

Line 1874: l_result := l_result||l_temp||wf_core.newline;

1870: l_cells(3) := '25%:Message Name';
1871: l_cells(4) := l_tname;
1872:
1873: Get_Table(l_cells, 2, 'V', l_temp);
1874: l_result := l_result||l_temp||wf_core.newline;
1875: l_cells.DELETE;
1876:
1877: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1878:

Line 1887: --l_result := l_result||wf_core.newline;

1883: || th_fontface|| ' size='||th_fontsize||' color='||th_fontcolor||'>';
1884:
1885: l_result := l_result||'Summary Message Template in TEXT format. ('||
1886: l_ses_lang||'_'||l_ses_terr||')';
1887: --l_result := l_result||wf_core.newline;
1888: l_result := l_result||'

';

1889: 

1890:         if (l_txt_body is not null) then

1891:             l_result := l_result||Wf_Notification.SubstituteSpecialChars(l_txt_body);


Line 1896: l_result := l_result||'

'||wf_core.newline;

1892: else
1893: l_result := '(not defined or user language ' || l_ses_lang ||' is not installed )';
1894: end if;
1895:
1896: l_result := l_result||''||wf_core.newline;
1897:
1898: l_result := l_result||'';
1900: l_result := l_result||'Summary Message Template in HTML format. ('||

Line 1921: wf_core.token('NAME', l_tname);

1917: SetNLS(l_ses_lang, l_ses_terr);
1918:
1919: exception
1920: when no_data_found then
1921: wf_core.token('NAME', l_tname);
1922: wf_core.token('TYPE', l_ttype);
1923: wf_core.raise('WFNTF_MESSAGE');
1924:
1925: when others then

Line 1922: wf_core.token('TYPE', l_ttype);

1918:
1919: exception
1920: when no_data_found then
1921: wf_core.token('NAME', l_tname);
1922: wf_core.token('TYPE', l_ttype);
1923: wf_core.raise('WFNTF_MESSAGE');
1924:
1925: when others then
1926: l_cells.DELETE;

Line 1923: wf_core.raise('WFNTF_MESSAGE');

1919: exception
1920: when no_data_found then
1921: wf_core.token('NAME', l_tname);
1922: wf_core.token('TYPE', l_ttype);
1923: wf_core.raise('WFNTF_MESSAGE');
1924:
1925: when others then
1926: l_cells.DELETE;
1927: l_cells(1) := '10%:Note';

Line 1986: wf_core.context('WF_DIAGNOSTICS', 'Fetch Role', to_char(p_nid));

1982: from wf_notifications
1983: where notification_id = p_nid;
1984: exception
1985: when others then
1986: wf_core.context('WF_DIAGNOSTICS', 'Fetch Role', to_char(p_nid));
1987: raise;
1988: end;
1989: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1990: wf_event.AddParameterToList('ROLE', l_role, l_parameters);

Line 2002: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);

1998: begin
1999: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);
2000: exception
2001: when others then
2002: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);
2003: raise;
2004: end;
2005: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);
2006:

Line 2105: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);

2101: begin
2102: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);
2103: exception
2104: when others then
2105: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);
2106: raise;
2107: end;
2108:
2109: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);

Line 2209: l_result := l_result||wf_core.newline;

2205: l_cells(13) := '20%:Correlation Id';
2206: l_cells(14) := l_crec.correlation_id;
2207:
2208: Get_Table(l_cells, 2, 'V', l_result);
2209: l_result := l_result||wf_core.newline;
2210: l_cells.DELETE;
2211: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2212: l_result := NULL;
2213:

Line 2310: l_result := l_result||wf_core.newline;

2306: l_cells(6) := l_crec.component_status;
2307:
2308:
2309: Get_Table(l_cells, 2, 'V', l_result);
2310: l_result := l_result||wf_core.newline;
2311: l_cells.DELETE;
2312: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2313: l_result := NULL;
2314:

Line 2535: l_result := l_result||wf_core.newline;

2531:
2532: begin
2533: l_cells(1) := 'WH:TABLE OF CONTENTS';
2534: Get_Table(l_cells, 1, 'H', l_result);
2535: l_result := l_result||wf_core.newline;
2536: l_cells.DELETE;
2537:
2538: l_cells(1) := '20%:Serial No.';
2539: l_cells(2) := '80%:Contents';

Line 3098: l_temp_result := '
'||wf_core.newline;

3094: l_cells.DELETE;
3095: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3096:
3097: -- Profile Option Values
3098: l_temp_result := '
'||wf_core.newline;
3099: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3100: Get_Profile_Option_Values(l_value);
3101:
3102: -- Get IANA Override charset values

Line 3103: l_temp_result := '
'||wf_core.newline;

3099: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3100: Get_Profile_Option_Values(l_value);
3101:
3102: -- Get IANA Override charset values
3103: l_temp_result := '
'||wf_core.newline;
3104: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3105: Get_Override_Charset(l_value);
3106:
3107: -- GSC Mailer component parameters

Line 3108: l_temp_result := '
'||wf_core.newline;

3104: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3105: Get_Override_Charset(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

Line 3113: 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);
3115: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
3116:
3117: -- Mailer Tags

Line 3118: l_temp_result := '
'||Get_Mailer_Tags()||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);
3120:
3121: -- Send the final HTML Output to the caller
3122: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 3129: l_temp_result := ''||Get_Mailer_TOC(p_nid)||wf_core.newline;

3125: return;
3126: end;
3127:
3128: -- Get Table of Contents
3129: l_temp_result := ''||Get_Mailer_TOC(p_nid)||wf_core.newline;
3130: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3131:
3132: -- Get Notfication Item Info
3133: l_temp_result := '
'||Get_Ntf_Item_Info(p_nid)||wf_core.newline;

Line 3133: l_temp_result := '
'||Get_Ntf_Item_Info(p_nid)||wf_core.newline;

3129: l_temp_result := ''||Get_Mailer_TOC(p_nid)||wf_core.newline;
3130: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3131:
3132: -- Get Notfication Item Info
3133: l_temp_result := '
'||Get_Ntf_Item_Info(p_nid)||wf_core.newline;
3134: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3136: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3137:

Line 3135: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3131:
3132: -- Get Notfication Item Info
3133: l_temp_result := '
'||Get_Ntf_Item_Info(p_nid)||wf_core.newline;
3134: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3136: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3137:
3138: -- Bug 14365670. Consider the case when this is the NID of a group of notifications
3139: -- which mail status is null and no

Line 3151: l_temp_result := '
'||Get_Group_Ntfs(p_nid)||wf_core.newline;

3147: g_group_ntf := TRUE;
3148: end if;
3149:
3150: -- Get Group associated notifications
3151: l_temp_result := '
'||Get_Group_Ntfs(p_nid)||wf_core.newline;
3152: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3154: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3155:

Line 3153: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3149:
3150: -- Get Group associated notifications
3151: l_temp_result := '
'||Get_Group_Ntfs(p_nid)||wf_core.newline;
3152: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3154: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3155:
3156: -- Get Users belonging to the recipient Role
3157: l_temp_result := '
'||Get_Ntf_Role_Users(p_nid)||wf_core.newline;

Line 3157: l_temp_result := '
'||Get_Ntf_Role_Users(p_nid)||wf_core.newline;

3153: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3154: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3155:
3156: -- Get Users belonging to the recipient Role
3157: l_temp_result := '
'||Get_Ntf_Role_Users(p_nid)||wf_core.newline;
3158: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3160: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3161:

Line 3159: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3155:
3156: -- Get Users belonging to the recipient Role
3157: l_temp_result := '
'||Get_Ntf_Role_Users(p_nid)||wf_core.newline;
3158: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3160: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3161:
3162: -- Get the recipient Role Information
3163: l_temp_result := '
'||Get_Ntf_Role_Info(p_nid)||wf_core.newline;

Line 3163: l_temp_result := '
'||Get_Ntf_Role_Info(p_nid)||wf_core.newline;

3159: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3160: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3161:
3162: -- Get the recipient Role Information
3163: l_temp_result := '
'||Get_Ntf_Role_Info(p_nid)||wf_core.newline;
3164: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3166: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3167:

Line 3165: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3161:
3162: -- Get the recipient Role Information
3163: l_temp_result := '
'||Get_Ntf_Role_Info(p_nid)||wf_core.newline;
3164: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3166: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3167:
3168: -- Get the Recipient Role routing rules information
3169: l_temp_result := '
'||Get_Routing_Rules(p_nid)||wf_core.newline;

Line 3169: l_temp_result := '
'||Get_Routing_Rules(p_nid)||wf_core.newline;

3165: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3166: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3167:
3168: -- Get the Recipient Role routing rules information
3169: l_temp_result := '
'||Get_Routing_Rules(p_nid)||wf_core.newline;
3170: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3172: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3173:

Line 3171: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3167:
3168: -- Get the Recipient Role routing rules information
3169: l_temp_result := '
'||Get_Routing_Rules(p_nid)||wf_core.newline;
3170: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3172: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3173:
3174: -- Get the Nore Info Role Information
3175: l_temp_result := '
'||Get_Ntf_More_Info(p_nid)||wf_core.newline;

Line 3175: l_temp_result := '
'||Get_Ntf_More_Info(p_nid)||wf_core.newline;

3171: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3172: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3173:
3174: -- Get the Nore Info Role Information
3175: l_temp_result := '
'||Get_Ntf_More_Info(p_nid)||wf_core.newline;
3176: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3178: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3179:

Line 3177: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3173:
3174: -- Get the Nore Info Role Information
3175: l_temp_result := '
'||Get_Ntf_More_Info(p_nid)||wf_core.newline;
3176: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3178: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3179:
3180: l_temp_result := '
'||wf_core.newline;
3181: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 3191: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3187: l_temp_result := '
'||wf_core.newline;
3188: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3189: Get_Ntf_Attrs(p_nid, l_value);
3190: l_temp_result := 'Go to top
'||wf_core.newline;
3192: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3193:
3194: -- Get Notification result attribute values
3195: l_temp_result := '
'||wf_core.newline;

Line 3195: l_temp_result := '
'||wf_core.newline;

3191: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3192: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3193:
3194: -- Get Notification result attribute values
3195: l_temp_result := '
'||wf_core.newline;
3196: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3197: Get_Ntf_Msg_Result_Attrs(p_nid, l_value);
3198: l_temp_result := 'Go to top
'||wf_core.newline;

Line 3199: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3195: l_temp_result := '
'||wf_core.newline;
3196: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3197: Get_Ntf_Msg_Result_Attrs(p_nid, l_value);
3198: l_temp_result := 'Go to top
'||wf_core.newline;
3200: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3201:
3202: -- Get the Notification User comments
3203: l_temp_result := '
'||wf_core.newline;

Line 3203: l_temp_result := '
'||wf_core.newline;

3199: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3200: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3201:
3202: -- Get the Notification User comments
3203: l_temp_result := '
'||wf_core.newline;
3204: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3205: Get_User_Comments(p_nid, l_value);
3206: l_temp_result := 'Go to top
'||wf_core.newline;

Line 3207: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3203: l_temp_result := '
'||wf_core.newline;
3204: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3205: Get_User_Comments(p_nid, l_value);
3206: l_temp_result := 'Go to top
'||wf_core.newline;
3208: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3209:
3210: -- Queue Statuses
3211: -- Deferred queue status

Line 3216: ||wf_core.newline;

3212: l_temp_result := '
'
3213: ||Get_Event_Queue_Status(p_queue_name => WFD_DEFERRED,
3214: p_event_name => 'oracle.apps.wf.notification%',
3215: p_event_key => to_char(p_nid))
3216: ||wf_core.newline;
3217: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3219: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3220:

Line 3218: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3214: p_event_name => 'oracle.apps.wf.notification%',
3215: p_event_key => to_char(p_nid))
3216: ||wf_core.newline;
3217: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3219: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3220:
3221: -- Error Queue Status
3222: l_temp_result := '
'

Line 3226: ||wf_core.newline;

3222: l_temp_result := '
'
3223: ||Get_Event_Queue_Status(p_queue_name => WFD_ERROR,
3224: p_event_name => 'oracle.apps.wf.notification%',
3225: p_event_key => to_char(p_nid))
3226: ||wf_core.newline;
3227: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3229: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3230:

Line 3228: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3224: p_event_name => 'oracle.apps.wf.notification%',
3225: p_event_key => to_char(p_nid))
3226: ||wf_core.newline;
3227: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3229: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3230:
3231: -- Error Notification Details
3232: l_temp_result := '
'

Line 3235: ||wf_core.newline;

3231: -- Error Notification Details
3232: l_temp_result := '
'
3233: ||Get_Error_Ntf_Details(p_event_name => 'oracle.apps.wf.notification.%',
3234: p_event_key => p_nid)
3235: ||wf_core.newline;
3236: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3238: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3239:

Line 3237: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3233: ||Get_Error_Ntf_Details(p_event_name => 'oracle.apps.wf.notification.%',
3234: p_event_key => p_nid)
3235: ||wf_core.newline;
3236: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3238: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3239:
3240: -- Notification OUT Queue Status
3241: l_temp_result := '
'

Line 3245: ||wf_core.newline;

3241: l_temp_result := '
'
3242: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_OUT,
3243: p_event_name => 'oracle.apps.wf.notification%',
3244: p_event_key => to_char(p_nid))
3245: ||wf_core.newline;
3246: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3248: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3249:

Line 3247: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3243: p_event_name => 'oracle.apps.wf.notification%',
3244: p_event_key => to_char(p_nid))
3245: ||wf_core.newline;
3246: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3248: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3249:
3250: -- Notification IN Queue Status
3251: l_temp_result := '
'

Line 3255: ||wf_core.newline;

3251: l_temp_result := '
'
3252: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_IN,
3253: p_event_name => 'oracle.apps.wf.notification%',
3254: p_event_key => to_char(p_nid))
3255: ||wf_core.newline;
3256: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3258: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3259:

Line 3257: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3253: p_event_name => 'oracle.apps.wf.notification%',
3254: p_event_key => to_char(p_nid))
3255: ||wf_core.newline;
3256: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3258: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3259:
3260: -- Email and Notification message definition
3261: l_temp_result := '
'||wf_core.newline;

Line 3261: l_temp_result := '
'||wf_core.newline;

3257: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3258: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3259:
3260: -- Email and Notification message definition
3261: l_temp_result := '
'||wf_core.newline;
3262: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3263: Get_Ntf_Templates(p_nid, l_value);
3264: l_temp_result := 'Go to top
'||wf_core.newline;

Line 3265: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3261: l_temp_result := '
'||wf_core.newline;
3262: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3263: Get_Ntf_Templates(p_nid, l_value);
3264: l_temp_result := 'Go to top
'||wf_core.newline;
3266: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3267:
3268: -- XML Message for the notification
3269: l_temp_result := '
'||wf_core.newline;

Line 3269: l_temp_result := '
'||wf_core.newline;

3265: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3266: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3267:
3268: -- XML Message for the notification
3269: l_temp_result := '
'||wf_core.newline;
3270: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3271: Get_Ntf_Message(p_nid, l_value);
3272: l_temp_result := 'Go to top
'||wf_core.newline;

Line 3273: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3269: l_temp_result := '
'||wf_core.newline;
3270: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3271: Get_Ntf_Message(p_nid, l_value);
3272: l_temp_result := 'Go to top
'||wf_core.newline;
3274: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3275:
3276: -- XML Message for the notification from WF_NOTIFICATION_OUT
3277: l_temp_result := '
'||wf_core.newline;

Line 3277: l_temp_result := '
'||wf_core.newline;

3273: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3274: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3275:
3276: -- XML Message for the notification from WF_NOTIFICATION_OUT
3277: l_temp_result := '
'||wf_core.newline;
3278: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3279: Get_Ntf_Msg_From_Out(p_nid, l_value);
3280: l_temp_result := 'Go to top
'||wf_core.newline;

Line 3281: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3277: l_temp_result := '
'||wf_core.newline;
3278: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3279: Get_Ntf_Msg_From_Out(p_nid, l_value);
3280: l_temp_result := 'Go to top
'||wf_core.newline;
3282: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3283:
3284: -- XML Message for the notification from WF_NOTIFICATION_IN
3285: l_temp_result := '
'||wf_core.newline;

Line 3285: l_temp_result := '
'||wf_core.newline;

3281: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3282: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3283:
3284: -- XML Message for the notification from WF_NOTIFICATION_IN
3285: l_temp_result := '
'||wf_core.newline;
3286: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3287: Get_Ntf_Msg_From_In(p_nid, l_value);
3288: l_temp_result := 'Go to top
'||wf_core.newline;

Line 3289: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3285: l_temp_result := '
'||wf_core.newline;
3286: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3287: Get_Ntf_Msg_From_In(p_nid, l_value);
3288: l_temp_result := 'Go to top
'||wf_core.newline;
3290: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3291:
3292: -- Profile Option Values
3293: l_temp_result := '
'||wf_core.newline;

Line 3293: l_temp_result := '
'||wf_core.newline;

3289: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3290: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3291:
3292: -- Profile Option Values
3293: l_temp_result := '
'||wf_core.newline;
3294: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3295: Get_Profile_Option_Values(l_value);
3296: l_temp_result := 'Go to top
'||wf_core.newline;

Line 3297: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3293: l_temp_result := '
'||wf_core.newline;
3294: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3295: Get_Profile_Option_Values(l_value);
3296: l_temp_result := 'Go to top
'||wf_core.newline;
3298: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3299:
3300: -- IANA Override Character Set Values
3301: l_temp_result := '
'||wf_core.newline;

Line 3301: l_temp_result := '
'||wf_core.newline;

3297: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3298: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3299:
3300: -- IANA Override Character Set Values
3301: l_temp_result := '
'||wf_core.newline;
3302: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3303: Get_Override_Charset(l_value);
3304: l_temp_result := 'Go to top
'||wf_core.newline;

Line 3305: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3301: l_temp_result := '
'||wf_core.newline;
3302: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3303: Get_Override_Charset(l_value);
3304: l_temp_result := 'Go to top
'||wf_core.newline;
3306: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3307:
3308: -- GSC Mailer component parameters
3309: l_temp_result := '
'||wf_core.newline;

Line 3309: l_temp_result := '
'||wf_core.newline;

3305: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3306: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
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;

Line 3313: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

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:
3316: -- GSC Mailer component scheduled events
3317: l_temp_result := '
'||wf_core.newline;

Line 3317: l_temp_result := '
'||wf_core.newline;

3313: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3314: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
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;

Line 3321: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

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:
3324: -- Mailer Tags
3325: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;

Line 3325: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;

3321: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
3322: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3323:
3324: -- Mailer Tags
3325: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;
3326: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3328: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3329:

Line 3327: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

3323:
3324: -- Mailer Tags
3325: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;
3326: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
3328: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3329:
3330:
3331: -- Send the final HTML Output to the caller

Line 3336: l_temp_result := 'Error encountered while Generating Mailer Debug Information for nid '||p_nid||wf_core.newline;

3332: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
3333: p_value := l_value;
3334: exception
3335: when others then
3336: l_temp_result := 'Error encountered while Generating Mailer Debug Information for nid '||p_nid||wf_core.newline;
3337: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
3338: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
3339: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3340: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 3337: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;

3333: p_value := l_value;
3334: exception
3335: when others then
3336: l_temp_result := 'Error encountered while Generating Mailer Debug Information for nid '||p_nid||wf_core.newline;
3337: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
3338: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
3339: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3340: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
3341: p_value := l_value;

Line 3338: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;

3334: exception
3335: when others then
3336: l_temp_result := 'Error encountered while Generating Mailer Debug Information for nid '||p_nid||wf_core.newline;
3337: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
3338: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
3339: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3340: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
3341: p_value := l_value;
3342: end Get_Mailer_Debug;

Line 3560: l_last_cr := instr(l_buffer, wf_core.newline, -1);

3556: loop
3557: l_last_cr := 0;
3558: if (l_amount > l_chunksize) then
3559: l_buffer := substr(p_value, l_offset, l_chunksize);
3560: l_last_cr := instr(l_buffer, wf_core.newline, -1);
3561: l_last_gt := instr(l_buffer, '>', -1);
3562: l_last_sc := instr(l_buffer, ';', -1);
3563: if (l_last_cr > 1) then
3564: l_buffer_size := l_last_cr;

Line 3610: l_last_cr := instr(l_buffer, wf_core.newline, -1);

3606: loop
3607: l_last_cr := 0;
3608: if (l_amount > l_chunksize) then
3609: dbms_lob.read(p_value, l_chunksize, l_offset, l_buffer);
3610: l_last_cr := instr(l_buffer, wf_core.newline, -1);
3611: l_last_gt := instr(l_buffer, '>', -1);
3612: l_last_sc := instr(l_buffer, ';', -1);
3613: if (l_last_cr > 1) then
3614: l_buffer_size := l_last_cr;

Line 4401: l_temp_result := ''||wf_core.newline;

4397: p_value := l_value;
4398: return;
4399: end;
4400:
4401: l_temp_result := ''||wf_core.newline;
4402: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4403:
4404: -- Get WF_SYSTEM_STATUS
4405: l_temp_result := '
'

Line 4408: ||wf_core.newline;

4404: -- Get WF_SYSTEM_STATUS
4405: l_temp_result := '
'
4406: ||Get_Evt_Sys_Status(p_event_name => p_event_name,
4407: p_event_key => p_event_key)
4408: ||wf_core.newline;
4409: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4411: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4412:

Line 4410: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4406: ||Get_Evt_Sys_Status(p_event_name => p_event_name,
4407: p_event_key => p_event_key)
4408: ||wf_core.newline;
4409: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4411: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4412:
4413: -- Get Business Event Item Info
4414: l_temp_result := '
'||Get_Bus_Evt_Info(p_event_name)||wf_core.newline;

Line 4414: l_temp_result := '
'||Get_Bus_Evt_Info(p_event_name)||wf_core.newline;

4410: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
4411: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4412:
4413: -- Get Business Event Item Info
4414: l_temp_result := '
'||Get_Bus_Evt_Info(p_event_name)||wf_core.newline;
4415: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4417: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4418:

Line 4416: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4412:
4413: -- Get Business Event Item Info
4414: l_temp_result := '
'||Get_Bus_Evt_Info(p_event_name)||wf_core.newline;
4415: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4417: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4418:
4419: -- Get Subscription Info using Cache API
4420: l_temp_result := '
'||Get_Evt_Subs_Cac_Info(p_event_name)||wf_core.newline;

Line 4420: l_temp_result := '
'||Get_Evt_Subs_Cac_Info(p_event_name)||wf_core.newline;

4416: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
4417: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4418:
4419: -- Get Subscription Info using Cache API
4420: l_temp_result := '
'||Get_Evt_Subs_Cac_Info(p_event_name)||wf_core.newline;
4421: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4423: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4424:

Line 4422: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4418:
4419: -- Get Subscription Info using Cache API
4420: l_temp_result := '
'||Get_Evt_Subs_Cac_Info(p_event_name)||wf_core.newline;
4421: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4423: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4424:
4425: -- Get Subscription Info from DB
4426: l_temp_result := '
'||Get_Evt_Subs_Info(p_event_name)||wf_core.newline;

Line 4426: l_temp_result := '
'||Get_Evt_Subs_Info(p_event_name)||wf_core.newline;

4422: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
4423: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4424:
4425: -- Get Subscription Info from DB
4426: l_temp_result := '
'||Get_Evt_Subs_Info(p_event_name)||wf_core.newline;
4427: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4429: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4430:

Line 4428: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4424:
4425: -- Get Subscription Info from DB
4426: l_temp_result := '
'||Get_Evt_Subs_Info(p_event_name)||wf_core.newline;
4427: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4429: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4430:
4431: -- Listener Statuses
4432: l_temp_result := '
'||Get_Agent_Lsnrs_Status||wf_core.newline;

Line 4432: l_temp_result := '
'||Get_Agent_Lsnrs_Status||wf_core.newline;

4428: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
4429: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4430:
4431: -- Listener Statuses
4432: l_temp_result := '
'||Get_Agent_Lsnrs_Status||wf_core.newline;
4433: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4435: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4436:

Line 4434: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4430:
4431: -- Listener Statuses
4432: l_temp_result := '
'||Get_Agent_Lsnrs_Status||wf_core.newline;
4433: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4435: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4436:
4437: -- Queue Statuses
4438: -- Deferred queue status

Line 4443: ||wf_core.newline;

4439: l_temp_result := '
'
4440: ||Get_Event_Queue_Status(p_queue_name => WFD_DEFERRED,
4441: p_event_name => p_event_name,
4442: p_event_key => p_event_key)
4443: ||wf_core.newline;
4444: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4446: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4447:

Line 4445: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4441: p_event_name => p_event_name,
4442: p_event_key => p_event_key)
4443: ||wf_core.newline;
4444: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4446: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4447:
4448: -- Java Deferred Queue Status
4449: l_temp_result := '
'

Line 4453: ||wf_core.newline;

4449: l_temp_result := '
'
4450: ||Get_JMS_Queue_Status(p_queue_name => WFD_JAVA_DEFERRED,
4451: p_event_name => p_event_name,
4452: p_event_key => p_event_key)
4453: ||wf_core.newline;
4454: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4456: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4457:

Line 4455: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4451: p_event_name => p_event_name,
4452: p_event_key => p_event_key)
4453: ||wf_core.newline;
4454: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4456: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4457:
4458: -- Error Queue Status
4459: l_temp_result := '
'

Line 4463: ||wf_core.newline;

4459: l_temp_result := '
'
4460: ||Get_Event_Queue_Status(p_queue_name => WFD_ERROR,
4461: p_event_name => p_event_name,
4462: p_event_key => p_event_key)
4463: ||wf_core.newline;
4464: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4466: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4467:

Line 4465: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4461: p_event_name => p_event_name,
4462: p_event_key => p_event_key)
4463: ||wf_core.newline;
4464: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4466: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4467:
4468: -- Java Error Queue Status
4469: l_temp_result := '
'

Line 4473: ||wf_core.newline;

4469: l_temp_result := '
'
4470: ||Get_JMS_Queue_Status(p_queue_name => WFD_JAVA_ERROR,
4471: p_event_name => p_event_name,
4472: p_event_key => p_event_key)
4473: ||wf_core.newline;
4474: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4476: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4477:

Line 4475: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4471: p_event_name => p_event_name,
4472: p_event_key => p_event_key)
4473: ||wf_core.newline;
4474: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4476: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4477:
4478: -- Error Notification Details
4479: l_temp_result := '
'

Line 4482: ||wf_core.newline;

4478: -- Error Notification Details
4479: l_temp_result := '
'
4480: ||Get_Error_Ntf_Details(p_event_name => p_event_name,
4481: p_event_key => p_event_key)
4482: ||wf_core.newline;
4483: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4485: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4486:

Line 4484: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;

4480: ||Get_Error_Ntf_Details(p_event_name => p_event_name,
4481: p_event_key => p_event_key)
4482: ||wf_core.newline;
4483: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4485: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4486:
4487: -- Send the final HTML Output to the caller
4488: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 4492: l_temp_result := 'Error encountered while Generating BES Debug Information for event '||p_event_name||wf_core.newline;

4488: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4489: p_value := l_value;
4490: exception
4491: when others then
4492: l_temp_result := 'Error encountered while Generating BES Debug Information for event '||p_event_name||wf_core.newline;
4493: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4494: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4496: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 4493: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;

4489: p_value := l_value;
4490: exception
4491: when others then
4492: l_temp_result := 'Error encountered while Generating BES Debug Information for event '||p_event_name||wf_core.newline;
4493: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4494: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4496: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4497: p_value := l_value;

Line 4494: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;

4490: exception
4491: when others then
4492: l_temp_result := 'Error encountered while Generating BES Debug Information for event '||p_event_name||wf_core.newline;
4493: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4494: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4496: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4497: p_value := l_value;
4498: end Get_Bes_Debug;

Line 4533: l_head := l_head||wf_core.newline;

4529: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
4530:
4531: l_head := ''||'Role Info:'||p_role||' - wfsmrdbg output';
4532:
4533: l_head := l_head||wf_core.newline;
4534:
4535: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
4536:
4537: -- check Role exist in row exist

Line 4565: l_temp_result := '
' ||Get_Summary_Ntf_Role_Users(p_role)||wf_core.newline;

4561: return;
4562: end if;
4563:
4564: -- Get Users belonging to the recipient Role
4565: l_temp_result := '
' ||Get_Summary_Ntf_Role_Users(p_role)||wf_core.newline;
4566: l_temp_result := l_temp_result || '
'||wf_core.newline;
4567: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4568:
4569:

Line 4566: l_temp_result := l_temp_result || '
'||wf_core.newline;

4562: end if;
4563:
4564: -- Get Users belonging to the recipient Role
4565: l_temp_result := '
' ||Get_Summary_Ntf_Role_Users(p_role)||wf_core.newline;
4566: l_temp_result := l_temp_result || '
'||wf_core.newline;
4567: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4568:
4569:
4570: -- Get the recipient Role Information

Line 4571: l_temp_result := '
' ||Get_Summary_Ntf_Role_Info(p_role)||wf_core.newline;

4567: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4568:
4569:
4570: -- Get the recipient Role Information
4571: l_temp_result := '
' ||Get_Summary_Ntf_Role_Info(p_role)||wf_core.newline;
4572: l_temp_result := l_temp_result || '
'||wf_core.newline;
4573: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4574:
4575: -- Queue Statuses : Since summary ntf always enqued in wf_notification_out.

Line 4572: l_temp_result := l_temp_result || '
'||wf_core.newline;

4568:
4569:
4570: -- Get the recipient Role Information
4571: l_temp_result := '
' ||Get_Summary_Ntf_Role_Info(p_role)||wf_core.newline;
4572: l_temp_result := l_temp_result || '
'||wf_core.newline;
4573: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4574:
4575: -- Queue Statuses : Since summary ntf always enqued in wf_notification_out.
4576: -- If SUMHTML or SUMMARY then contents are fetched from Fwk API :

Line 4586: p_event_key => p_role || '%')||wf_core.newline;

4582:
4583: -- show number of rows in wf_notification_out AQ
4584: l_temp_result := '
' ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_OUT,
4585: p_event_name => 'oracle.apps.wf.notification%',
4586: p_event_key => p_role || '%')||wf_core.newline;
4587:
4588: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4589:
4590: -- Email and Notification message definition

Line 4591: l_temp_result := '
'||wf_core.newline;

4587:
4588: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4589:
4590: -- Email and Notification message definition
4591: l_temp_result := '
'||wf_core.newline;
4592: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4593: -- Summary template : WFMAIL
4594: Get_Summary_Templates(p_role, l_npref, l_value);
4595:

Line 4599: l_temp_result := '
'||wf_core.newline;

4595:
4596: -- WF_XML.generate FOR an event with
4597: -- event key for summary is generated as: role_name + sysdate
4598: --
4599: l_temp_result := '
'||wf_core.newline;
4600: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4601: Get_Summary_Ntf_Message(p_role, l_value );
4602:
4603: -- XML Message for a role from WF_NOTIFICATION_OUT

Line 4604: l_temp_result := '
'||wf_core.newline;

4600: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4601: Get_Summary_Ntf_Message(p_role, l_value );
4602:
4603: -- XML Message for a role from WF_NOTIFICATION_OUT
4604: l_temp_result := '
'||wf_core.newline;
4605: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4606: Get_Summary_Msg_From_Out(p_role, l_value);
4607:
4608: -- Profile Option Values

Line 4609: l_temp_result := '
'||wf_core.newline;

4605: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4606: Get_Summary_Msg_From_Out(p_role, l_value);
4607:
4608: -- Profile Option Values
4609: l_temp_result := '
'||wf_core.newline;
4610: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4611: Get_Profile_Option_Values(l_value);
4612:
4613: -- GSC Mailer component parameters

Line 4614: l_temp_result := '
'||wf_core.newline;

4610: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4611: Get_Profile_Option_Values(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

Line 4619: 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);
4621: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
4622:
4623: -- Mailer Tags

Line 4624: 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);
4626:
4627: l_temp_result := Get_Mailer_Tags()||wf_core.newline;
4628: l_temp_result := l_temp_result || '
'||wf_core.newline;

Line 4627: l_temp_result := Get_Mailer_Tags()||wf_core.newline;

4623: -- Mailer Tags
4624: l_temp_result := '
'||wf_core.newline;
4625: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4626:
4627: l_temp_result := Get_Mailer_Tags()||wf_core.newline;
4628: l_temp_result := l_temp_result || '
'||wf_core.newline;
4629: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4630:
4631: -- Send the final HTML Output to the caller

Line 4628: l_temp_result := l_temp_result || '
'||wf_core.newline;

4624: l_temp_result := '
'||wf_core.newline;
4625: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4626:
4627: l_temp_result := Get_Mailer_Tags()||wf_core.newline;
4628: l_temp_result := l_temp_result || '
'||wf_core.newline;
4629: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4630:
4631: -- Send the final HTML Output to the caller
4632: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 4639: 'Information for role '||p_role||wf_core.newline;

4635:
4636: exception
4637: when others then
4638: l_temp_result := 'Error encountered while Generating Summary Mailer Debug '||
4639: 'Information for role '||p_role||wf_core.newline;
4640: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4641: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4642: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4643: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 4640: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;

4636: exception
4637: when others then
4638: l_temp_result := 'Error encountered while Generating Summary Mailer Debug '||
4639: 'Information for role '||p_role||wf_core.newline;
4640: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4641: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4642: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4643: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4644: p_content := l_value;

Line 4641: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;

4637: when others then
4638: l_temp_result := 'Error encountered while Generating Summary Mailer Debug '||
4639: 'Information for role '||p_role||wf_core.newline;
4640: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4641: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4642: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4643: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4644: p_content := l_value;
4645:

Line 4683: ||wf_core.newline;

4679: --
4680: l_temp_result := '
'
4681: ||Get_Error_Ntf_Details(p_event_name => 'oracle.apps.wf.notification.%',
4682: p_event_key => p_idstring)
4683: ||wf_core.newline;
4684: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4685:
4686: -- Notification OUT Queue Status
4687: l_temp_result := '
'

Line 4692: ||wf_core.newline;

4688: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_OUT,
4689: p_event_name => 'oracle.apps.wf.notification%',
4690: p_event_key => to_char(p_idstring) || '%',
4691: p_corr_id => l_user || ':' || p_module || '%')
4692: ||wf_core.newline;
4693:
4694: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4695:
4696: -- Notification IN Queue Status

Line 4702: ||wf_core.newline;

4698: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_IN,
4699: p_event_name => 'oracle.apps.alr.response.receive%',
4700: p_event_key => to_char(p_idstring) || '%',
4701: p_corr_id => l_user || ':' || p_module || '%')
4702: ||wf_core.newline;
4703:
4704: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4705:
4706: l_temp_result := '
'||wf_core.newline;

Line 4706: l_temp_result := '
'||wf_core.newline;

4702: ||wf_core.newline;
4703:
4704: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4705:
4706: l_temp_result := '
'||wf_core.newline;
4707: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4708:
4709: -- XML Message for the alert from WF_NOTIFICATION_OUT
4710: Get_Ntf_Msg_From_Out(p_idstring, l_user || ':' || p_module || '%', l_value);

Line 4712: l_temp_result := '
'||wf_core.newline;

4708:
4709: -- XML Message for the alert from WF_NOTIFICATION_OUT
4710: Get_Ntf_Msg_From_Out(p_idstring, l_user || ':' || p_module || '%', l_value);
4711:
4712: l_temp_result := '
'||wf_core.newline;
4713: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4714:
4715: -- XML Message for the notification from WF_NOTIFICATION_IN
4716: Get_Ntf_Msg_From_In(p_idstring, l_user || ':' || p_module || '%', l_value);

Line 4718: l_temp_result := '
'||wf_core.newline;

4714:
4715: -- XML Message for the notification from WF_NOTIFICATION_IN
4716: Get_Ntf_Msg_From_In(p_idstring, l_user || ':' || p_module || '%', l_value);
4717:
4718: l_temp_result := '
'||wf_core.newline;
4719: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4720:
4721: -- Profile Option Values
4722: Get_Profile_Option_Values(l_value);

Line 4723: l_temp_result := '
'||wf_core.newline;

4719: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4720:
4721: -- Profile Option Values
4722: Get_Profile_Option_Values(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);

Line 4728: 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
4732: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);

Line 4733: 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
4737: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;

Line 4737: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;

4733: l_temp_result := '
'||wf_core.newline;
4734: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4735:
4736: -- Mailer Tags
4737: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;
4738: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4739:
4740: -- Send the final HTML Output to the caller
4741: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 4748: ' Information for module '||p_module|| '
'|| wf_core.newline;

4744:
4745: exception
4746: when others then
4747: l_temp_result := 'Error encountered while Generating Mailer Alert Debug '||
4748: ' Information for module '||p_module|| '
'|| wf_core.newline;
4749: l_temp_result := l_temp_result||'Error Name : '||wf_core.error_name || '
' || wf_core.newline;
4750: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4751:
4752: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 4749: l_temp_result := l_temp_result||'Error Name : '||wf_core.error_name || '
' || wf_core.newline;

4745: exception
4746: when others then
4747: l_temp_result := 'Error encountered while Generating Mailer Alert Debug '||
4748: ' Information for module '||p_module|| '
'|| wf_core.newline;
4749: l_temp_result := l_temp_result||'Error Name : '||wf_core.error_name || '
' || wf_core.newline;
4750: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4751:
4752: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4753: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 4750: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;

4746: when others then
4747: l_temp_result := 'Error encountered while Generating Mailer Alert Debug '||
4748: ' Information for module '||p_module|| '
'|| wf_core.newline;
4749: l_temp_result := l_temp_result||'Error Name : '||wf_core.error_name || '
' || wf_core.newline;
4750: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4751:
4752: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4753: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4754: