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 115: l_table := l_table||wf_core.newline||'

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

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

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

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

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

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

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

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

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

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

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

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

419: l_cells.DELETE;
420: l_cells(1) := '10%:Note';
421: l_cells(2) := 'Error when generating Notification Recipient Role Members Information for nid '||p_nid;
422: l_cells(3) := '10%:Error';
423: if (wf_core.error_name is null) then
424: l_cells(4) := sqlerrm;
425: else
426: l_cells(4) := wf_core.error_name;
427: end if;

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

422: l_cells(3) := '10%:Error';
423: if (wf_core.error_name is null) then
424: l_cells(4) := sqlerrm;
425: else
426: l_cells(4) := wf_core.error_name;
427: end if;
428: Get_Table(l_cells, 2, 'V', l_result);
429: return l_result;
430: end Get_Ntf_Role_Users;

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

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

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

492: l_cells(3) := '10%:Error';
493: if (wf_core.error_name is null) then
494: l_cells(4) := sqlerrm;
495: else
496: l_cells(4) := wf_core.error_name;
497: end if;
498: Get_Table(l_cells, 2, 'V', l_result);
499: return l_result;
500: end Get_Ntf_Role_Info;

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

563: l_cells(1) := '10%:Note';
564: l_cells(2) := 'Error when generating Summary Notification Recipient ' ||
565: 'Role Members Info. for role '||p_role;
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_Summary_Ntf_Role_Users;

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

634: l_cells.DELETE;
635: l_cells(1) := '10%:Note';
636: l_cells(2) := 'Error when generating Notification Recipient Role Information for nid '||p_role;
637: l_cells(3) := '10%:Error';
638: if (wf_core.error_name is null) then
639: l_cells(4) := sqlerrm;
640: else
641: l_cells(4) := wf_core.error_name;
642: end if;

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

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

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

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

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

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

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

1374: where name = l_tname
1375: and type = l_ttype;
1376: exception
1377: when no_data_found then
1378: wf_core.token('NAME', l_tname);
1379: wf_core.token('TYPE', l_ttype);
1380: wf_core.raise('WFNTF_MESSAGE');
1381: end;
1382:

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

1375: and type = l_ttype;
1376: exception
1377: when no_data_found then
1378: wf_core.token('NAME', l_tname);
1379: wf_core.token('TYPE', l_ttype);
1380: wf_core.raise('WFNTF_MESSAGE');
1381: end;
1382:
1383: l_result := NULL;

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

1376: exception
1377: when no_data_found then
1378: wf_core.token('NAME', l_tname);
1379: wf_core.token('TYPE', l_ttype);
1380: wf_core.raise('WFNTF_MESSAGE');
1381: end;
1382:
1383: l_result := NULL;
1384: l_cells(1) := '25%:Message Type';

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

1385: l_cells(2) := l_ttype;
1386: l_cells(3) := '25%:Message Name';
1387: l_cells(4) := l_tname;
1388: Get_Table(l_cells, 2, 'V', l_temp);
1389: l_result := l_result||l_temp||wf_core.newline;
1390: l_cells.DELETE;
1391: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1392: l_result := NULL;
1393:

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

1400: l_result := l_result||Wf_Notification.SubstituteSpecialChars(l_txt_body);
1401: else
1402: l_result := '(not defined)';
1403: end if;
1404: l_result := l_result||''||wf_core.newline;
1405:
1406: l_result := l_result||'';
1408: l_result := l_result||'E-mail Message Template in HTML format. ('||l_nls_lang||'_'||l_nls_terr||')';

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

1430: where name = l_msg_name
1431: and type = l_msg_type;
1432: exception
1433: when no_data_found then
1434: wf_core.token('NAME', l_msg_name );
1435: wf_core.token('TYPE', l_msg_type);
1436: wf_core.raise('WFNTF_MESSAGE');
1437: end;
1438:

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

1431: and type = l_msg_type;
1432: exception
1433: when no_data_found then
1434: wf_core.token('NAME', l_msg_name );
1435: wf_core.token('TYPE', l_msg_type);
1436: wf_core.raise('WFNTF_MESSAGE');
1437: end;
1438:
1439: l_result := NULL;

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

1432: exception
1433: when no_data_found then
1434: wf_core.token('NAME', l_msg_name );
1435: wf_core.token('TYPE', l_msg_type);
1436: wf_core.raise('WFNTF_MESSAGE');
1437: end;
1438:
1439: l_result := NULL;
1440: l_cells(1) := '25%:Message Type';

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

1441: l_cells(2) := l_msg_type;
1442: l_cells(3) := '25%:Message Name';
1443: l_cells(4) := l_msg_name;
1444: Get_Table(l_cells, 2, 'V', l_temp);
1445: l_result := l_result||l_temp||wf_core.newline;
1446: l_cells.DELETE;
1447: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1448: l_result := NULL;
1449:

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

1456: l_result := l_result||Wf_Notification.SubstituteSpecialChars(l_txt_body);
1457: else
1458: l_result := '(not defined)';
1459: end if;
1460: l_result := l_result||''||wf_core.newline;
1461:
1462: l_result := l_result||'';
1464: l_result := l_result||'Notification Message Definition in HTML format. ('||l_nls_lang||'_'||l_nls_terr||')';

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

1618: l_cells(3) := '25%:Message Name';
1619: l_cells(4) := l_tname;
1620:
1621: Get_Table(l_cells, 2, 'V', l_temp);
1622: l_result := l_result||l_temp||wf_core.newline;
1623: l_cells.DELETE;
1624:
1625: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1626:

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

1631: || th_fontface|| ' size='||th_fontsize||' color='||th_fontcolor||'>';
1632:
1633: l_result := l_result||'Summary Message Template in TEXT format. ('||
1634: l_user_lang||'_'||l_user_terr||')';
1635: --l_result := l_result||wf_core.newline;
1636: l_result := l_result||'

';

1637: 

1638:         if (l_txt_body is not null) then

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


Line 1644: l_result := l_result||'

'||wf_core.newline;

1640: else
1641: l_result := '(not defined or user language ' || l_user_lang ||' is not installed )';
1642: end if;
1643:
1644: l_result := l_result||''||wf_core.newline;
1645:
1646: l_result := l_result||'';
1648: l_result := l_result||'Summary Message Template in HTML format. ('||

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

1683: l_cells(3) := '25%:Message Name';
1684: l_cells(4) := l_tname;
1685:
1686: Get_Table(l_cells, 2, 'V', l_temp);
1687: l_result := l_result||l_temp||wf_core.newline;
1688: l_cells.DELETE;
1689:
1690: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1691:

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

1696: || th_fontface|| ' size='||th_fontsize||' color='||th_fontcolor||'>';
1697:
1698: l_result := l_result||'Summary Message Template in TEXT format. ('||
1699: l_ses_lang||'_'||l_ses_terr||')';
1700: --l_result := l_result||wf_core.newline;
1701: l_result := l_result||'

';

1702: 

1703:         if (l_txt_body is not null) then

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


Line 1709: l_result := l_result||'

'||wf_core.newline;

1705: else
1706: l_result := '(not defined or user language ' || l_ses_lang ||' is not installed )';
1707: end if;
1708:
1709: l_result := l_result||''||wf_core.newline;
1710:
1711: l_result := l_result||'';
1713: l_result := l_result||'Summary Message Template in HTML format. ('||

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

1730: SetNLS(l_ses_lang, l_ses_terr);
1731:
1732: exception
1733: when no_data_found then
1734: wf_core.token('NAME', l_tname);
1735: wf_core.token('TYPE', l_ttype);
1736: wf_core.raise('WFNTF_MESSAGE');
1737:
1738: when others then

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

1731:
1732: exception
1733: when no_data_found then
1734: wf_core.token('NAME', l_tname);
1735: wf_core.token('TYPE', l_ttype);
1736: wf_core.raise('WFNTF_MESSAGE');
1737:
1738: when others then
1739: l_cells.DELETE;

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

1732: exception
1733: when no_data_found then
1734: wf_core.token('NAME', l_tname);
1735: wf_core.token('TYPE', l_ttype);
1736: wf_core.raise('WFNTF_MESSAGE');
1737:
1738: when others then
1739: l_cells.DELETE;
1740: l_cells(1) := '10%:Note';

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

1795: from wf_notifications
1796: where notification_id = p_nid;
1797: exception
1798: when others then
1799: wf_core.context('WF_DIAGNOSTICS', 'Fetch Role', to_char(p_nid));
1800: raise;
1801: end;
1802: wf_event.AddParameterToList('NOTIFICATION_ID', to_char(p_nid), l_parameters);
1803: wf_event.AddParameterToList('ROLE', l_role, l_parameters);

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

1811: begin
1812: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);
1813: exception
1814: when others then
1815: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);
1816: raise;
1817: end;
1818: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);
1819:

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

1914: begin
1915: l_doc := wf_xml.generate(p_event_name, p_event_key, l_parameters);
1916: exception
1917: when others then
1918: wf_core.context('WF_DIAGNOSTICS', 'Generate', p_event_name, p_event_key);
1919: raise;
1920: end;
1921:
1922: l_time_taken := to_char((dbms_utility.get_time()-l_before)/100);

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

2018: l_cells(13) := '20%:Correlation Id';
2019: l_cells(14) := l_crec.correlation_id;
2020:
2021: Get_Table(l_cells, 2, 'V', l_result);
2022: l_result := l_result||wf_core.newline;
2023: l_cells.DELETE;
2024: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2025: l_result := NULL;
2026:

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

2119: l_cells(6) := l_crec.component_status;
2120:
2121:
2122: Get_Table(l_cells, 2, 'V', l_result);
2123: l_result := l_result||wf_core.newline;
2124: l_cells.DELETE;
2125: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2126: l_result := NULL;
2127:

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

2296:
2297: begin
2298: l_cells(1) := 'WH:TABLE OF CONTENTS';
2299: Get_Table(l_cells, 1, 'H', l_result);
2300: l_result := l_result||wf_core.newline;
2301: l_cells.DELETE;
2302:
2303: l_cells(1) := '20%:Serial No.';
2304: l_cells(2) := '80%:Contents';

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

2782: l_cells.DELETE;
2783: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2784:
2785: -- Profile Option Values
2786: l_temp_result := '
'||wf_core.newline;
2787: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2788: Get_Profile_Option_Values(l_value);
2789:
2790: -- GSC Mailer component parameters

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

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

Line 2796: 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);
2798: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
2799:
2800: -- Mailer Tags

Line 2801: l_temp_result := '
'||Get_Mailer_Tags()||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);
2803:
2804: -- Send the final HTML Output to the caller
2805: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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

2808: return;
2809: end;
2810:
2811: -- Get Table of Contents
2812: l_temp_result := ''||Get_Mailer_TOC(p_nid)||wf_core.newline;
2813: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2814:
2815: -- Get Notfication Item Info
2816: l_temp_result := '
'||Get_Ntf_Item_Info(p_nid)||wf_core.newline;

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

2812: l_temp_result := ''||Get_Mailer_TOC(p_nid)||wf_core.newline;
2813: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2814:
2815: -- Get Notfication Item Info
2816: l_temp_result := '
'||Get_Ntf_Item_Info(p_nid)||wf_core.newline;
2817: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2819: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2820:

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

2814:
2815: -- Get Notfication Item Info
2816: l_temp_result := '
'||Get_Ntf_Item_Info(p_nid)||wf_core.newline;
2817: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2819: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2820:
2821: -- Get Users belonging to the recipient Role
2822: l_temp_result := '
'||Get_Ntf_Role_Users(p_nid)||wf_core.newline;

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

2818: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2819: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2820:
2821: -- Get Users belonging to the recipient Role
2822: l_temp_result := '
'||Get_Ntf_Role_Users(p_nid)||wf_core.newline;
2823: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2825: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2826:

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

2820:
2821: -- Get Users belonging to the recipient Role
2822: l_temp_result := '
'||Get_Ntf_Role_Users(p_nid)||wf_core.newline;
2823: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2825: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2826:
2827: -- Get the recipient Role Information
2828: l_temp_result := '
'||Get_Ntf_Role_Info(p_nid)||wf_core.newline;

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

2824: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2825: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2826:
2827: -- Get the recipient Role Information
2828: l_temp_result := '
'||Get_Ntf_Role_Info(p_nid)||wf_core.newline;
2829: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2831: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2832:

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

2826:
2827: -- Get the recipient Role Information
2828: l_temp_result := '
'||Get_Ntf_Role_Info(p_nid)||wf_core.newline;
2829: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2831: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2832:
2833: -- Get the Recipient Role routing rules information
2834: l_temp_result := '
'||Get_Routing_Rules(p_nid)||wf_core.newline;

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

2830: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2831: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2832:
2833: -- Get the Recipient Role routing rules information
2834: l_temp_result := '
'||Get_Routing_Rules(p_nid)||wf_core.newline;
2835: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2837: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2838:

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

2832:
2833: -- Get the Recipient Role routing rules information
2834: l_temp_result := '
'||Get_Routing_Rules(p_nid)||wf_core.newline;
2835: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2837: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2838:
2839: -- Get the Nore Info Role Information
2840: l_temp_result := '
'||Get_Ntf_More_Info(p_nid)||wf_core.newline;

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

2836: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2837: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2838:
2839: -- Get the Nore Info Role Information
2840: l_temp_result := '
'||Get_Ntf_More_Info(p_nid)||wf_core.newline;
2841: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2843: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2844:

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

2838:
2839: -- Get the Nore Info Role Information
2840: l_temp_result := '
'||Get_Ntf_More_Info(p_nid)||wf_core.newline;
2841: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2843: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2844:
2845: l_temp_result := '
'||wf_core.newline;
2846: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

2852: l_temp_result := '
'||wf_core.newline;
2853: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2854: Get_Ntf_Attrs(p_nid, l_value);
2855: l_temp_result := 'Go to top
'||wf_core.newline;
2857: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2858:
2859: -- Get the Notification User comments
2860: l_temp_result := '
'||wf_core.newline;

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

2856: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2857: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2858:
2859: -- Get the Notification User comments
2860: l_temp_result := '
'||wf_core.newline;
2861: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2862: Get_User_Comments(p_nid, l_value);
2863: l_temp_result := 'Go to top
'||wf_core.newline;

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

2860: l_temp_result := '
'||wf_core.newline;
2861: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2862: Get_User_Comments(p_nid, l_value);
2863: l_temp_result := 'Go to top
'||wf_core.newline;
2865: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2866:
2867: -- Queue Statuses
2868: -- Deferred queue status

Line 2873: ||wf_core.newline;

2869: l_temp_result := '
'
2870: ||Get_Event_Queue_Status(p_queue_name => WFD_DEFERRED,
2871: p_event_name => 'oracle.apps.wf.notification%',
2872: p_event_key => to_char(p_nid))
2873: ||wf_core.newline;
2874: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2876: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2877:

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

2871: p_event_name => 'oracle.apps.wf.notification%',
2872: p_event_key => to_char(p_nid))
2873: ||wf_core.newline;
2874: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2876: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2877:
2878: -- Error Queue Status
2879: l_temp_result := '
'

Line 2883: ||wf_core.newline;

2879: l_temp_result := '
'
2880: ||Get_Event_Queue_Status(p_queue_name => WFD_ERROR,
2881: p_event_name => 'oracle.apps.wf.notification%',
2882: p_event_key => to_char(p_nid))
2883: ||wf_core.newline;
2884: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2886: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2887:

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

2881: p_event_name => 'oracle.apps.wf.notification%',
2882: p_event_key => to_char(p_nid))
2883: ||wf_core.newline;
2884: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2886: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2887:
2888: -- Error Notification Details
2889: l_temp_result := '
'

Line 2892: ||wf_core.newline;

2888: -- Error Notification Details
2889: l_temp_result := '
'
2890: ||Get_Error_Ntf_Details(p_event_name => 'oracle.apps.wf.notification.%',
2891: p_event_key => p_nid)
2892: ||wf_core.newline;
2893: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2895: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2896:

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

2890: ||Get_Error_Ntf_Details(p_event_name => 'oracle.apps.wf.notification.%',
2891: p_event_key => p_nid)
2892: ||wf_core.newline;
2893: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2895: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2896:
2897: -- Notification OUT Queue Status
2898: l_temp_result := '
'

Line 2902: ||wf_core.newline;

2898: l_temp_result := '
'
2899: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_OUT,
2900: p_event_name => 'oracle.apps.wf.notification%',
2901: p_event_key => to_char(p_nid))
2902: ||wf_core.newline;
2903: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2905: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2906:

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

2900: p_event_name => 'oracle.apps.wf.notification%',
2901: p_event_key => to_char(p_nid))
2902: ||wf_core.newline;
2903: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2905: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2906:
2907: -- Notification IN Queue Status
2908: l_temp_result := '
'

Line 2912: ||wf_core.newline;

2908: l_temp_result := '
'
2909: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_IN,
2910: p_event_name => 'oracle.apps.wf.notification%',
2911: p_event_key => to_char(p_nid))
2912: ||wf_core.newline;
2913: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2915: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2916:

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

2910: p_event_name => 'oracle.apps.wf.notification%',
2911: p_event_key => to_char(p_nid))
2912: ||wf_core.newline;
2913: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2915: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2916:
2917: -- Email and Notification message definition
2918: l_temp_result := '
'||wf_core.newline;

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

2914: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2915: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2916:
2917: -- Email and Notification message definition
2918: l_temp_result := '
'||wf_core.newline;
2919: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2920: Get_Ntf_Templates(p_nid, l_value);
2921: l_temp_result := 'Go to top
'||wf_core.newline;

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

2918: l_temp_result := '
'||wf_core.newline;
2919: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2920: Get_Ntf_Templates(p_nid, l_value);
2921: l_temp_result := 'Go to top
'||wf_core.newline;
2923: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2924:
2925: -- XML Message for the notification
2926: l_temp_result := '
'||wf_core.newline;

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

2922: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2923: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2924:
2925: -- XML Message for the notification
2926: l_temp_result := '
'||wf_core.newline;
2927: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2928: Get_Ntf_Message(p_nid, l_value);
2929: l_temp_result := 'Go to top
'||wf_core.newline;

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

2926: l_temp_result := '
'||wf_core.newline;
2927: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2928: Get_Ntf_Message(p_nid, l_value);
2929: l_temp_result := 'Go to top
'||wf_core.newline;
2931: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2932:
2933: -- XML Message for the notification from WF_NOTIFICATION_OUT
2934: l_temp_result := '
'||wf_core.newline;

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

2930: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2931: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2932:
2933: -- XML Message for the notification from WF_NOTIFICATION_OUT
2934: l_temp_result := '
'||wf_core.newline;
2935: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2936: Get_Ntf_Msg_From_Out(p_nid, l_value);
2937: l_temp_result := 'Go to top
'||wf_core.newline;

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

2934: l_temp_result := '
'||wf_core.newline;
2935: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2936: Get_Ntf_Msg_From_Out(p_nid, l_value);
2937: l_temp_result := 'Go to top
'||wf_core.newline;
2939: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2940:
2941: -- XML Message for the notification from WF_NOTIFICATION_IN
2942: l_temp_result := '
'||wf_core.newline;

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

2938: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2939: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2940:
2941: -- XML Message for the notification from WF_NOTIFICATION_IN
2942: l_temp_result := '
'||wf_core.newline;
2943: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2944: Get_Ntf_Msg_From_In(p_nid, l_value);
2945: l_temp_result := 'Go to top
'||wf_core.newline;

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

2942: l_temp_result := '
'||wf_core.newline;
2943: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2944: Get_Ntf_Msg_From_In(p_nid, l_value);
2945: l_temp_result := 'Go to top
'||wf_core.newline;
2947: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2948:
2949: -- Profile Option Values
2950: l_temp_result := '
'||wf_core.newline;

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

2946: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2947: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2948:
2949: -- Profile Option Values
2950: l_temp_result := '
'||wf_core.newline;
2951: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2952: Get_Profile_Option_Values(l_value);
2953: l_temp_result := 'Go to top
'||wf_core.newline;

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

2950: l_temp_result := '
'||wf_core.newline;
2951: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2952: Get_Profile_Option_Values(l_value);
2953: l_temp_result := 'Go to top
'||wf_core.newline;
2955: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2956:
2957: -- GSC Mailer component parameters
2958: l_temp_result := '
'||wf_core.newline;

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

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

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

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

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

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

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

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

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

2970: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
2971: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2972:
2973: -- Mailer Tags
2974: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;
2975: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2977: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2978:

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

2972:
2973: -- Mailer Tags
2974: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;
2975: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
2977: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2978:
2979:
2980: -- Send the final HTML Output to the caller

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

2981: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
2982: p_value := l_value;
2983: exception
2984: when others then
2985: l_temp_result := 'Error encountered while Generating Mailer Debug Information for nid '||p_nid||wf_core.newline;
2986: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
2987: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
2988: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2989: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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

2982: p_value := l_value;
2983: exception
2984: when others then
2985: l_temp_result := 'Error encountered while Generating Mailer Debug Information for nid '||p_nid||wf_core.newline;
2986: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
2987: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
2988: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2989: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
2990: p_value := l_value;

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

2983: exception
2984: when others then
2985: l_temp_result := 'Error encountered while Generating Mailer Debug Information for nid '||p_nid||wf_core.newline;
2986: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
2987: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
2988: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
2989: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
2990: p_value := l_value;
2991: end Get_Mailer_Debug;

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

3205: loop
3206: l_last_cr := 0;
3207: if (l_amount > l_chunksize) then
3208: l_buffer := substr(p_value, l_offset, l_chunksize);
3209: l_last_cr := instr(l_buffer, wf_core.newline, -1);
3210: l_last_gt := instr(l_buffer, '>', -1);
3211: l_last_sc := instr(l_buffer, ';', -1);
3212: if (l_last_cr > 1) then
3213: l_buffer_size := l_last_cr;

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

3255: loop
3256: l_last_cr := 0;
3257: if (l_amount > l_chunksize) then
3258: dbms_lob.read(p_value, l_chunksize, l_offset, l_buffer);
3259: l_last_cr := instr(l_buffer, wf_core.newline, -1);
3260: l_last_gt := instr(l_buffer, '>', -1);
3261: l_last_sc := instr(l_buffer, ';', -1);
3262: if (l_last_cr > 1) then
3263: l_buffer_size := l_last_cr;

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

4046: p_value := l_value;
4047: return;
4048: end;
4049:
4050: l_temp_result := ''||wf_core.newline;
4051: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4052:
4053: -- Get WF_SYSTEM_STATUS
4054: l_temp_result := '
'

Line 4057: ||wf_core.newline;

4053: -- Get WF_SYSTEM_STATUS
4054: l_temp_result := '
'
4055: ||Get_Evt_Sys_Status(p_event_name => p_event_name,
4056: p_event_key => p_event_key)
4057: ||wf_core.newline;
4058: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4060: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4061:

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

4055: ||Get_Evt_Sys_Status(p_event_name => p_event_name,
4056: p_event_key => p_event_key)
4057: ||wf_core.newline;
4058: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4060: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4061:
4062: -- Get Business Event Item Info
4063: l_temp_result := '
'||Get_Bus_Evt_Info(p_event_name)||wf_core.newline;

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

4059: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
4060: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4061:
4062: -- Get Business Event Item Info
4063: l_temp_result := '
'||Get_Bus_Evt_Info(p_event_name)||wf_core.newline;
4064: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4066: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4067:

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

4061:
4062: -- Get Business Event Item Info
4063: l_temp_result := '
'||Get_Bus_Evt_Info(p_event_name)||wf_core.newline;
4064: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4066: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4067:
4068: -- Get Subscription Info using Cache API
4069: l_temp_result := '
'||Get_Evt_Subs_Cac_Info(p_event_name)||wf_core.newline;

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

4065: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
4066: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4067:
4068: -- Get Subscription Info using Cache API
4069: l_temp_result := '
'||Get_Evt_Subs_Cac_Info(p_event_name)||wf_core.newline;
4070: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4072: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4073:

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

4067:
4068: -- Get Subscription Info using Cache API
4069: l_temp_result := '
'||Get_Evt_Subs_Cac_Info(p_event_name)||wf_core.newline;
4070: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4072: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4073:
4074: -- Get Subscription Info from DB
4075: l_temp_result := '
'||Get_Evt_Subs_Info(p_event_name)||wf_core.newline;

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

4071: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
4072: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4073:
4074: -- Get Subscription Info from DB
4075: l_temp_result := '
'||Get_Evt_Subs_Info(p_event_name)||wf_core.newline;
4076: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4078: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4079:

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

4073:
4074: -- Get Subscription Info from DB
4075: l_temp_result := '
'||Get_Evt_Subs_Info(p_event_name)||wf_core.newline;
4076: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4078: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4079:
4080: -- Listener Statuses
4081: l_temp_result := '
'||Get_Agent_Lsnrs_Status||wf_core.newline;

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

4077: ' size='||td_fontsize||'>Go to top
'||wf_core.newline;
4078: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4079:
4080: -- Listener Statuses
4081: l_temp_result := '
'||Get_Agent_Lsnrs_Status||wf_core.newline;
4082: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4084: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4085:

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

4079:
4080: -- Listener Statuses
4081: l_temp_result := '
'||Get_Agent_Lsnrs_Status||wf_core.newline;
4082: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4084: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4085:
4086: -- Queue Statuses
4087: -- Deferred queue status

Line 4092: ||wf_core.newline;

4088: l_temp_result := '
'
4089: ||Get_Event_Queue_Status(p_queue_name => WFD_DEFERRED,
4090: p_event_name => p_event_name,
4091: p_event_key => p_event_key)
4092: ||wf_core.newline;
4093: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4095: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4096:

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

4090: p_event_name => p_event_name,
4091: p_event_key => p_event_key)
4092: ||wf_core.newline;
4093: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4095: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4096:
4097: -- Java Deferred Queue Status
4098: l_temp_result := '
'

Line 4102: ||wf_core.newline;

4098: l_temp_result := '
'
4099: ||Get_JMS_Queue_Status(p_queue_name => WFD_JAVA_DEFERRED,
4100: p_event_name => p_event_name,
4101: p_event_key => p_event_key)
4102: ||wf_core.newline;
4103: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4105: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4106:

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

4100: p_event_name => p_event_name,
4101: p_event_key => p_event_key)
4102: ||wf_core.newline;
4103: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4105: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4106:
4107: -- Error Queue Status
4108: l_temp_result := '
'

Line 4112: ||wf_core.newline;

4108: l_temp_result := '
'
4109: ||Get_Event_Queue_Status(p_queue_name => WFD_ERROR,
4110: p_event_name => p_event_name,
4111: p_event_key => p_event_key)
4112: ||wf_core.newline;
4113: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4115: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4116:

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

4110: p_event_name => p_event_name,
4111: p_event_key => p_event_key)
4112: ||wf_core.newline;
4113: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4115: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4116:
4117: -- Java Error Queue Status
4118: l_temp_result := '
'

Line 4122: ||wf_core.newline;

4118: l_temp_result := '
'
4119: ||Get_JMS_Queue_Status(p_queue_name => WFD_JAVA_ERROR,
4120: p_event_name => p_event_name,
4121: p_event_key => p_event_key)
4122: ||wf_core.newline;
4123: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4125: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4126:

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

4120: p_event_name => p_event_name,
4121: p_event_key => p_event_key)
4122: ||wf_core.newline;
4123: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4125: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4126:
4127: -- Error Notification Details
4128: l_temp_result := '
'

Line 4131: ||wf_core.newline;

4127: -- Error Notification Details
4128: l_temp_result := '
'
4129: ||Get_Error_Ntf_Details(p_event_name => p_event_name,
4130: p_event_key => p_event_key)
4131: ||wf_core.newline;
4132: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4134: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4135:

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

4129: ||Get_Error_Ntf_Details(p_event_name => p_event_name,
4130: p_event_key => p_event_key)
4131: ||wf_core.newline;
4132: l_temp_result := l_temp_result||'Go to top
'||wf_core.newline;
4134: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4135:
4136: -- Send the final HTML Output to the caller
4137: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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

4137: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4138: p_value := l_value;
4139: exception
4140: when others then
4141: l_temp_result := 'Error encountered while Generating BES Debug Information for event '||p_event_name||wf_core.newline;
4142: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4143: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4144: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4145: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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

4138: p_value := l_value;
4139: exception
4140: when others then
4141: l_temp_result := 'Error encountered while Generating BES Debug Information for event '||p_event_name||wf_core.newline;
4142: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4143: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4144: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4145: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4146: p_value := l_value;

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

4139: exception
4140: when others then
4141: l_temp_result := 'Error encountered while Generating BES Debug Information for event '||p_event_name||wf_core.newline;
4142: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4143: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4144: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4145: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4146: p_value := l_value;
4147: end Get_Bes_Debug;

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

4178: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
4179:
4180: l_head := ''||'Role Info:'||p_role||' - wfsmrdbg output';
4181:
4182: l_head := l_head||wf_core.newline;
4183:
4184: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
4185:
4186: -- check Role exist in row exist

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

4210: return;
4211: end if;
4212:
4213: -- Get Users belonging to the recipient Role
4214: l_temp_result := '
' ||Get_Summary_Ntf_Role_Users(p_role)||wf_core.newline;
4215: l_temp_result := l_temp_result || '
'||wf_core.newline;
4216: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4217:
4218:

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

4211: end if;
4212:
4213: -- Get Users belonging to the recipient Role
4214: l_temp_result := '
' ||Get_Summary_Ntf_Role_Users(p_role)||wf_core.newline;
4215: l_temp_result := l_temp_result || '
'||wf_core.newline;
4216: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4217:
4218:
4219: -- Get the recipient Role Information

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

4216: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4217:
4218:
4219: -- Get the recipient Role Information
4220: l_temp_result := '
' ||Get_Summary_Ntf_Role_Info(p_role)||wf_core.newline;
4221: l_temp_result := l_temp_result || '
'||wf_core.newline;
4222: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4223:
4224: -- Queue Statuses : Since summary ntf always enqued in wf_notification_out.

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

4217:
4218:
4219: -- Get the recipient Role Information
4220: l_temp_result := '
' ||Get_Summary_Ntf_Role_Info(p_role)||wf_core.newline;
4221: l_temp_result := l_temp_result || '
'||wf_core.newline;
4222: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4223:
4224: -- Queue Statuses : Since summary ntf always enqued in wf_notification_out.
4225: -- If SUMHTML or SUMMARY then contents are fetched from Fwk API :

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

4231:
4232: -- show number of rows in wf_notification_out AQ
4233: l_temp_result := '
' ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_OUT,
4234: p_event_name => 'oracle.apps.wf.notification%',
4235: p_event_key => p_role || '%')||wf_core.newline;
4236:
4237: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4238:
4239: -- Email and Notification message definition

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

4236:
4237: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4238:
4239: -- Email and Notification message definition
4240: l_temp_result := '
'||wf_core.newline;
4241: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4242: -- Summary template : WFMAIL
4243: Get_Summary_Templates(p_role, l_npref, l_value);
4244:

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

4244:
4245: -- WF_XML.generate FOR an event with
4246: -- event key for summary is generated as: role_name + sysdate
4247: --
4248: l_temp_result := '
'||wf_core.newline;
4249: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4250: Get_Summary_Ntf_Message(p_role, l_value );
4251:
4252: -- XML Message for a role from WF_NOTIFICATION_OUT

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

4249: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4250: Get_Summary_Ntf_Message(p_role, l_value );
4251:
4252: -- XML Message for a role from WF_NOTIFICATION_OUT
4253: l_temp_result := '
'||wf_core.newline;
4254: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4255: Get_Summary_Msg_From_Out(p_role, l_value);
4256:
4257: -- Profile Option Values

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

4254: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4255: Get_Summary_Msg_From_Out(p_role, l_value);
4256:
4257: -- Profile Option Values
4258: l_temp_result := '
'||wf_core.newline;
4259: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4260: Get_Profile_Option_Values(l_value);
4261:
4262: -- GSC Mailer component parameters

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

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

Line 4268: 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);
4270: Get_GSC_Comp_ScheduledEvents('WF_MAILER', null, l_value);
4271:
4272: -- Mailer Tags

Line 4273: 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);
4275:
4276: l_temp_result := Get_Mailer_Tags()||wf_core.newline;
4277: l_temp_result := l_temp_result || '
'||wf_core.newline;

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

4272: -- Mailer Tags
4273: l_temp_result := '
'||wf_core.newline;
4274: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4275:
4276: l_temp_result := Get_Mailer_Tags()||wf_core.newline;
4277: l_temp_result := l_temp_result || '
'||wf_core.newline;
4278: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4279:
4280: -- Send the final HTML Output to the caller

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

4273: l_temp_result := '
'||wf_core.newline;
4274: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4275:
4276: l_temp_result := Get_Mailer_Tags()||wf_core.newline;
4277: l_temp_result := l_temp_result || '
'||wf_core.newline;
4278: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4279:
4280: -- Send the final HTML Output to the caller
4281: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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

4284:
4285: exception
4286: when others then
4287: l_temp_result := 'Error encountered while Generating Summary Mailer Debug '||
4288: 'Information for role '||p_role||wf_core.newline;
4289: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4290: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4291: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4292: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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

4285: exception
4286: when others then
4287: l_temp_result := 'Error encountered while Generating Summary Mailer Debug '||
4288: 'Information for role '||p_role||wf_core.newline;
4289: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4290: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4291: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4292: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4293: p_content := l_value;

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

4286: when others then
4287: l_temp_result := 'Error encountered while Generating Summary Mailer Debug '||
4288: 'Information for role '||p_role||wf_core.newline;
4289: l_temp_result := l_temp_result||'Error Name : '||wf_core.newline||wf_core.error_name;
4290: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4291: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4292: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4293: p_content := l_value;
4294:

Line 4332: ||wf_core.newline;

4328: --
4329: l_temp_result := '
'
4330: ||Get_Error_Ntf_Details(p_event_name => 'oracle.apps.wf.notification.%',
4331: p_event_key => p_idstring)
4332: ||wf_core.newline;
4333: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4334:
4335: -- Notification OUT Queue Status
4336: l_temp_result := '
'

Line 4341: ||wf_core.newline;

4337: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_OUT,
4338: p_event_name => 'oracle.apps.wf.notification%',
4339: p_event_key => to_char(p_idstring) || '%',
4340: p_corr_id => l_user || ':' || p_module || '%')
4341: ||wf_core.newline;
4342:
4343: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4344:
4345: -- Notification IN Queue Status

Line 4351: ||wf_core.newline;

4347: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_IN,
4348: p_event_name => 'oracle.apps.alr.response.receive%',
4349: p_event_key => to_char(p_idstring) || '%',
4350: p_corr_id => l_user || ':' || p_module || '%')
4351: ||wf_core.newline;
4352:
4353: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4354:
4355: l_temp_result := '
'||wf_core.newline;

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

4351: ||wf_core.newline;
4352:
4353: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4354:
4355: l_temp_result := '
'||wf_core.newline;
4356: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4357:
4358: -- XML Message for the alert from WF_NOTIFICATION_OUT
4359: Get_Ntf_Msg_From_Out(p_idstring, l_user || ':' || p_module || '%', l_value);

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

4357:
4358: -- XML Message for the alert from WF_NOTIFICATION_OUT
4359: Get_Ntf_Msg_From_Out(p_idstring, l_user || ':' || p_module || '%', l_value);
4360:
4361: l_temp_result := '
'||wf_core.newline;
4362: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4363:
4364: -- XML Message for the notification from WF_NOTIFICATION_IN
4365: Get_Ntf_Msg_From_In(p_idstring, l_user || ':' || p_module || '%', l_value);

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

4363:
4364: -- XML Message for the notification from WF_NOTIFICATION_IN
4365: Get_Ntf_Msg_From_In(p_idstring, l_user || ':' || p_module || '%', l_value);
4366:
4367: l_temp_result := '
'||wf_core.newline;
4368: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4369:
4370: -- Profile Option Values
4371: Get_Profile_Option_Values(l_value);

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

4368: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4369:
4370: -- Profile Option Values
4371: Get_Profile_Option_Values(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);

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

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

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

4382: l_temp_result := '
'||wf_core.newline;
4383: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4384:
4385: -- Mailer Tags
4386: l_temp_result := '
'||Get_Mailer_Tags()||wf_core.newline;
4387: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4388:
4389: -- Send the final HTML Output to the caller
4390: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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

4393:
4394: exception
4395: when others then
4396: l_temp_result := 'Error encountered while Generating Mailer Alert Debug '||
4397: ' Information for module '||p_module|| '
'|| wf_core.newline;
4398: l_temp_result := l_temp_result||'Error Name : '||wf_core.error_name || '
' || wf_core.newline;
4399: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4400:
4401: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

4394: exception
4395: when others then
4396: l_temp_result := 'Error encountered while Generating Mailer Alert Debug '||
4397: ' Information for module '||p_module|| '
'|| wf_core.newline;
4398: l_temp_result := l_temp_result||'Error Name : '||wf_core.error_name || '
' || wf_core.newline;
4399: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4400:
4401: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4402: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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

4395: when others then
4396: l_temp_result := 'Error encountered while Generating Mailer Alert Debug '||
4397: ' Information for module '||p_module|| '
'|| wf_core.newline;
4398: l_temp_result := l_temp_result||'Error Name : '||wf_core.error_name || '
' || wf_core.newline;
4399: l_temp_result := l_temp_result||'Error Stack: '||wf_core.newline||wf_core.error_stack;
4400:
4401: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4402: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4403: