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 DBMS_LOB

Line 244: dbms_lob.WriteAppend(p_table, length(l_table), l_table);

240:
241: if (l_mod = 0) then
242: l_table := l_table||'';
243: end if;
244: dbms_lob.WriteAppend(p_table, length(l_table), l_table);
245: l_table := '';
246: end loop;
247: end if;
248: l_table := '';

Line 249: dbms_lob.WriteAppend(p_table, length(l_table), l_table);

245: l_table := '';
246: end loop;
247: end if;
248: l_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');

Line 899: dbms_lob.trim(l_temp, 0);

895: and wma.message_name = wn.message_name
896: and wn.notification_id = p_nid;
897:
898: begin
899: dbms_lob.trim(l_temp, 0);
900:
901: l_cells(1) := 'WH:Notification Message Attribute Values';
902: Get_Table(l_cells, 1, 'H', l_result);
903: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

Line 903: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

899: dbms_lob.trim(l_temp, 0);
900:
901: l_cells(1) := 'WH:Notification Message Attribute Values';
902: Get_Table(l_cells, 1, 'H', l_result);
903: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
904: l_cells.DELETE;
905:
906: l_cells(1) := '10%:Name';
907: l_cells(2) := '15%:Display Name';

Line 929: dbms_lob.Append(p_value, l_temp);

925: i := i+8;
926: end loop;
927:
928: Get_Table(l_cells, 8, 'H', l_temp);
929: dbms_lob.Append(p_value, l_temp);
930: exception
931: when others then
932: l_cells.DELETE;
933: l_cells(1) := '10%:Note';

Line 938: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

934: l_cells(2) := 'Error when generating Notification Message Attribute Values Information for nid '||p_nid;
935: l_cells(3) := '10%:Error';
936: l_cells(4) := sqlerrm;
937: Get_Table(l_cells, 2, 'V', l_result);
938: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
939: end Get_Ntf_Msg_Attrs;
940:
941: --
942: -- Get_Ntf_Attrs -

Line 960: dbms_lob.Trim(l_temp, 0);

956: from wf_notification_attributes
957: where notification_id = p_nid;
958:
959: begin
960: dbms_lob.Trim(l_temp, 0);
961:
962: l_cells(1) := 'WH:Notification Attribute Values';
963: Get_Table(l_cells, 1, 'H', l_result);
964: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

Line 964: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

960: dbms_lob.Trim(l_temp, 0);
961:
962: l_cells(1) := 'WH:Notification Attribute Values';
963: Get_Table(l_cells, 1, 'H', l_result);
964: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
965: l_cells.DELETE;
966:
967: l_cells(1) := '15%:Name';
968: l_cells(2) := '15%:Number Value';

Line 981: dbms_lob.Append(p_value, l_temp);

977: l_cells(i+4) := l_attr_rec.txt_val;
978: i := i+4;
979: end loop;
980: Get_Table(l_cells, 4, 'H', l_temp);
981: dbms_lob.Append(p_value, l_temp);
982: exception
983: when others then
984: l_cells.DELETE;
985: l_cells(1) := '10%:Note';

Line 990: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

986: l_cells(2) := 'Error when generating Notification Attributes Values Information for nid '||p_nid;
987: l_cells(3) := '10%:Error';
988: l_cells(4) := sqlerrm;
989: Get_Table(l_cells, 2, 'V', l_result);
990: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
991: end Get_Ntf_Attrs;
992:
993:
994: --

Line 1026: dbms_lob.Trim(l_temp, 0);

1022: AND lookup_type = type;
1023:
1024:
1025: begin
1026: dbms_lob.Trim(l_temp, 0);
1027:
1028: l_cells(1) := 'WH:Notification Message Result Attribute Values';
1029: Get_Table(l_cells, 1, 'H', l_result);
1030: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

Line 1030: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1026: dbms_lob.Trim(l_temp, 0);
1027:
1028: l_cells(1) := 'WH:Notification Message Result Attribute Values';
1029: Get_Table(l_cells, 1, 'H', l_result);
1030: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1031: l_cells.DELETE;
1032:
1033: l_cells(1) := '15%:Lookup Type';
1034: l_cells(2) := '15%:Lookup Code';

Line 1056: dbms_lob.Append(p_value, l_temp);

1052:
1053: exception
1054: when no_data_found then
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);

Line 1061: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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;
1064: end;
1065:

Line 1085: dbms_lob.Append(p_value, l_temp);

1081: end loop;
1082: end if;
1083:
1084: Get_Table(l_cells, 4, 'H', l_temp);
1085: dbms_lob.Append(p_value, l_temp);
1086: exception
1087: when others then
1088: l_cells.DELETE;
1089: l_cells(1) := '10%:Note';

Line 1094: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1090: l_cells(2) := 'Error when generating Notification Result Attributes Values Information for nid '||p_nid;
1091: l_cells(3) := '10%:Error';
1092: l_cells(4) := sqlerrm;
1093: Get_Table(l_cells, 2, 'V', l_result);
1094: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1095: end Get_Ntf_Msg_Result_Attrs;
1096:
1097: --
1098: -- Get_User_Comments -

Line 1118: dbms_lob.Trim(l_temp, 0);

1114: where wc.notification_id = p_nid
1115: order by comment_date;
1116:
1117: begin
1118: dbms_lob.Trim(l_temp, 0);
1119:
1120: l_cells(1) := 'WH:Notification User Comments';
1121: Get_Table(l_cells, 1, 'H', l_result);
1122: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

Line 1122: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1118: dbms_lob.Trim(l_temp, 0);
1119:
1120: l_cells(1) := 'WH:Notification User Comments';
1121: Get_Table(l_cells, 1, 'H', l_result);
1122: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1123: l_cells.DELETE;
1124:
1125: l_cells(1) := '10%:From Role';
1126: l_cells(2) := '10%:From User';

Line 1141: dbms_lob.Append(p_value, l_temp);

1137: l_cells(i+5) := l_comm_rec.user_comment;
1138: i := i+5;
1139: end loop;
1140: Get_Table(l_cells, 5, 'H', l_temp);
1141: dbms_lob.Append(p_value, l_temp);
1142: exception
1143: when others then
1144: l_cells.DELETE;
1145: l_cells(1) := '10%:Note';

Line 1150: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1146: l_cells(2) := 'Error when generating Notification User Comments Information for nid '||p_nid;
1147: l_cells(3) := '10%:Error';
1148: l_cells(4) := sqlerrm;
1149: Get_Table(l_cells, 2, 'V', l_result);
1150: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1151: end Get_User_Comments;
1152:
1153: --
1154: -- Get_Event_Queue_Status -

Line 1569: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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:
1572: l_result := '';
1573: l_result := l_result||'
1592: end if;
1593: l_result := l_result||'
';
1594: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1595: else
1596: l_result := NULL;
1597: l_cells(1) := 'Warning';
1598: -- Bug 14365670. Consider the case when this is the NID of a group of notifications

1592: end if; 1593: l_result := l_result\|\|'

Line 1607: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1603: l_cells(2) := 'E-mail full template information not generated since notification '||l_nid||' represents '||
1604: 'a notification group. View details of associated notifications by runnig wfmlrdbg.sql for them.';
1605: end if;
1606: Get_Table(l_cells, 2, 'V', l_result);
1607: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1608: end if;
1609:
1610: begin
1611: select subject, body, html_body

Line 1634: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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:
1637: l_result := '';
1638: l_result := l_result||'
1657: end if;
1658: l_result := l_result||'
';
1659: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1660: end if; -- installed flag check
1661: end loop;
1662: -- Reset to the base NLS settings
1663: SetNLS(l_ses_lang, l_ses_terr);

1657: end if; 1658: l_result := l_result\|\|'

Line 1672: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1668: l_cells(2) := 'Error when generating Notification Template Information for nid '||p_nid;
1669: l_cells(3) := '10%:Error';
1670: l_cells(4) := sqlerrm;
1671: Get_Table(l_cells, 2, 'V', l_result);
1672: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1673: end Get_Ntf_Templates;
1674:
1675:
1676:

Line 1812: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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:
1814: l_result := NULL;
1815:
1816: l_result := '';
Line 1847: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1843: end if;
1844:
1845: l_result := l_result||'

';
1846:
1847: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1848:
1849: end if;
1850:
1851: -- Generate template based on session lang

Line 1877: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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:
1879: l_result := NULL;
1880:
1881: l_result := '';
Line 1912: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1908: end if;
1909:
1910: l_result := l_result||'

';
1911:
1912: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1913:
1914: end if; -- If language installed
1915:
1916: -- Reset to the base NLS settings

Line 1932: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

1928: l_cells(2) := 'Error when generating Summary Notification Template for Role '||p_role;
1929: l_cells(3) := '10%:Error';
1930: l_cells(4) := sqlerrm;
1931: Get_Table(l_cells, 2, 'V', l_result);
1932: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
1933:
1934: end get_Summary_Templates;
1935:
1936:

Line 1994: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);

1990: wf_event.AddParameterToList('ROLE', l_role, l_parameters);
1991: wf_event.AddParameterToList('GROUP_ID', to_char(p_nid), l_parameters);
1992: wf_event.addParameterToList('Q_CORRELATION_ID', l_msg_type, l_parameters);
1993:
1994: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
1995:
1996: wf_mail.test_flag := TRUE;
1997: l_before := dbms_utility.get_time();
1998: begin

Line 2010: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2006:
2007: l_result := l_result||'Time Taken to complete Generate: '||l_time_taken||' Seconds';
2009: l_result := l_result||'
'; 2010: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2011: 2012: l_amount := dbms_lob.getlength(l_doc); 2013: l_chunksize := 10000; 2014: l_offset := 1; Line 2012: l_amount := dbms_lob.getlength(l_doc); 2008: ' color='||th_fontcolor||'>Time Taken to complete Generate: '||l_time_taken||' Seconds
';
2009: l_result := l_result||'
'; 2010: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2011: 2012: l_amount := dbms_lob.getlength(l_doc); 2013: l_chunksize := 10000; 2014: l_offset := 1; 2015: loop 2016: l_result := NULL; Line 2018: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2014: l_offset := 1; 2015: loop 2016: l_result := NULL; 2017: if (l_amount > l_chunksize) then 2018: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2019: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2020: l_amount := l_amount - l_chunksize; 2021: l_offset := l_offset + l_chunksize; 2022: l_buffer := NULL; Line 2023: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2019: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2020: l_amount := l_amount - l_chunksize; 2021: l_offset := l_offset + l_chunksize; 2022: l_buffer := NULL; 2023: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2024: else 2025: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2026: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2027: exit; Line 2025: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2021: l_offset := l_offset + l_chunksize; 2022: l_buffer := NULL; 2023: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2024: else 2025: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2026: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2027: exit; 2028: end if; 2029: end loop; Line 2032: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2028: end if; 2029: end loop; 2030: 2031: l_result := l_result||'
';
2032: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2033: exception
2034: when others then
2035: l_cells.DELETE;
2036: l_cells(1) := '10%:Note';

Line 2041: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2037: l_cells(2) := 'Error when generating Notification Message Information for nid '||p_nid;
2038: l_cells(3) := '10%:Error';
2039: l_cells(4) := sqlerrm;
2040: Get_Table(l_cells, 2, 'V', l_result);
2041: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2042: end Get_Ntf_Message;
2043:
2044:
2045: -- Get_Summary_Ntf_Message

Line 2095: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);

2091: -- Set AQs correlation id to item type i.e. 'WFMAIL'
2092: wf_event.addParameterToList('Q_CORRELATION_ID', 'WFMAIL', l_parameters);
2093:
2094: -- wf_event.AddParameterToList('GROUP_ID', to_char(0), l_parameters);
2095: dbms_lob.CreateTemporary(l_doc, false, dbms_lob.Call);
2096:
2097: wf_mail.test_flag := TRUE;
2098:
2099: l_before := dbms_utility.get_time();

Line 2114: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2110:
2111: l_result := l_result||'Time Taken to complete Generate: '||l_time_taken||' Seconds';
2113: l_result := l_result||'
'; 2114: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2115: 2116: l_amount := dbms_lob.getlength(l_doc); 2117: l_chunksize := 10000; 2118: l_offset := 1; Line 2116: l_amount := dbms_lob.getlength(l_doc); 2112: ' color='||th_fontcolor||'>Time Taken to complete Generate: '||l_time_taken||' Seconds
';
2113: l_result := l_result||'
'; 2114: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2115: 2116: l_amount := dbms_lob.getlength(l_doc); 2117: l_chunksize := 10000; 2118: l_offset := 1; 2119: loop 2120: l_result := NULL; Line 2122: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2118: l_offset := 1; 2119: loop 2120: l_result := NULL; 2121: if (l_amount > l_chunksize) then 2122: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2123: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2124: l_amount := l_amount - l_chunksize; 2125: l_offset := l_offset + l_chunksize; 2126: l_buffer := NULL; Line 2127: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2123: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2124: l_amount := l_amount - l_chunksize; 2125: l_offset := l_offset + l_chunksize; 2126: l_buffer := NULL; 2127: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2128: else 2129: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2130: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2131: exit; Line 2129: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2125: l_offset := l_offset + l_chunksize; 2126: l_buffer := NULL; 2127: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2128: else 2129: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2130: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2131: exit; 2132: end if; 2133: end loop; Line 2136: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2132: end if; 2133: end loop; 2134: 2135: l_result := l_result||'
';
2136: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2137: exception
2138: when others then
2139: l_cells.DELETE;
2140: l_cells(1) := '10%:Note';

Line 2145: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2141: l_cells(2) := 'Error when generating Summary Notification Message Information for Role '||p_role;
2142: l_cells(3) := '10%:Error';
2143: l_cells(4) := sqlerrm;
2144: Get_Table(l_cells, 2, 'V', l_result);
2145: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2146: end Get_Summary_Ntf_Message;
2147:
2148:
2149: --

Line 2190: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2186: begin
2187: l_cells(1) := 'WH:GSC '||p_comp_type||' Component Parameters';
2188: Get_Table(l_cells, 1, 'H', l_result);
2189: l_cells.DELETE;
2190: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2191:
2192: for l_crec in c_comps loop
2193: l_cells(1) := '20%:Component Id';
2194: l_cells(2) := l_crec.component_id;

Line 2211: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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:
2214: l_cells(1) := '25%:Parameter Name';
2215: l_cells(2) := '25%:Parameter Value';

Line 2228: dbms_lob.createTemporary(l_temp, TRUE, DBMS_LOB.CALL);

2224: l_cells(i+4) := l_prec.default_parameter_value;
2225: i := i+4;
2226: end loop;
2227:
2228: dbms_lob.createTemporary(l_temp, TRUE, DBMS_LOB.CALL);
2229: Get_Table(l_cells, 4, 'H', l_temp);
2230: l_cells.DELETE;
2231: dbms_lob.append(dest_lob => p_value, src_lob => l_temp);
2232: l_result := NULL;

Line 2231: dbms_lob.append(dest_lob => p_value, src_lob => l_temp);

2227:
2228: dbms_lob.createTemporary(l_temp, TRUE, DBMS_LOB.CALL);
2229: Get_Table(l_cells, 4, 'H', l_temp);
2230: l_cells.DELETE;
2231: dbms_lob.append(dest_lob => p_value, src_lob => l_temp);
2232: l_result := NULL;
2233: dbms_lob.freeTemporary(l_temp);
2234: end loop;
2235: exception

Line 2233: dbms_lob.freeTemporary(l_temp);

2229: Get_Table(l_cells, 4, 'H', l_temp);
2230: l_cells.DELETE;
2231: dbms_lob.append(dest_lob => p_value, src_lob => l_temp);
2232: l_result := NULL;
2233: dbms_lob.freeTemporary(l_temp);
2234: end loop;
2235: exception
2236: when others then
2237: l_cells.DELETE;

Line 2243: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2239: l_cells(2) := 'Error when generating Parameters Information for GSC Component Type '||p_comp_type;
2240: l_cells(3) := '10%:Error';
2241: l_cells(4) := sqlerrm;
2242: Get_Table(l_cells, 2, 'V', l_result);
2243: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2244: end Get_GSC_Comp_Parameters;
2245:
2246:
2247: --

Line 2298: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2294: begin
2295: l_cells(1) := 'WH:GSC '||p_comp_type||' Component Scheduled Events ';
2296: Get_Table(l_cells, 1, 'H', l_result);
2297: l_cells.DELETE;
2298: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2299:
2300: for l_crec in c_comps loop
2301: l_cells(1) := '20%:Component Id';
2302: l_cells(2) := l_crec.component_id;

Line 2312: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

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:
2315: l_cells(1) := '12%:Request Id';
2316: l_cells(2) := '12%:Job Id';

Line 2349: dbms_lob.createTemporary(l_temp, TRUE, DBMS_LOB.CALL);

2345: l_cells(i+6) := '';
2346: l_cells(i+7) := '';
2347: l_cells(i+8) := '';
2348:
2349: dbms_lob.createTemporary(l_temp, TRUE, DBMS_LOB.CALL);
2350: Get_Table(l_cells, 8, 'H', l_temp);
2351: l_cells.DELETE;
2352:
2353: dbms_lob.append(dest_lob => p_value, src_lob => l_temp);

Line 2353: dbms_lob.append(dest_lob => p_value, src_lob => l_temp);

2349: dbms_lob.createTemporary(l_temp, TRUE, DBMS_LOB.CALL);
2350: Get_Table(l_cells, 8, 'H', l_temp);
2351: l_cells.DELETE;
2352:
2353: dbms_lob.append(dest_lob => p_value, src_lob => l_temp);
2354: l_result := NULL;
2355: dbms_lob.freeTemporary(l_temp);
2356: end loop;
2357: exception

Line 2355: dbms_lob.freeTemporary(l_temp);

2351: l_cells.DELETE;
2352:
2353: dbms_lob.append(dest_lob => p_value, src_lob => l_temp);
2354: l_result := NULL;
2355: dbms_lob.freeTemporary(l_temp);
2356: end loop;
2357: exception
2358: when others then
2359: l_cells.DELETE;

Line 2365: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2361: l_cells(2) := 'Error when generating Scheduled Events Information for GSC Component Type '||p_comp_type;
2362: l_cells(3) := '10%:Error';
2363: l_cells(4) := sqlerrm;
2364: Get_Table(l_cells, 2, 'V', l_result);
2365: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2366: end Get_GSC_Comp_ScheduledEvents;
2367:
2368: --
2369: -- Get_Profile_Option_Values

Line 2394: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2390: begin
2391: l_cells(1) := 'WH:Profile Option Values';
2392: Get_Table(l_cells, 1, 'H', l_result);
2393: l_cells.DELETE;
2394: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2395:
2396: l_cells(1) := '25%:Parameter Name';
2397: l_cells(2) := '25%:Parameter Value';
2398:

Line 2408: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2404: end loop;
2405:
2406: Get_Table(l_cells, 2, 'H', l_result);
2407: l_cells.DELETE;
2408: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2409: exception
2410: when others then
2411: l_cells.DELETE;
2412: l_cells(1) := '10%:Note';

Line 2417: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2413: l_cells(2) := 'Error when fetching Profile Option Values';
2414: l_cells(3) := '10%:Error';
2415: l_cells(4) := sqlerrm;
2416: Get_Table(l_cells, 2, 'V', l_result);
2417: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2418: end Get_Profile_Option_Values;
2419:
2420:
2421: --

Line 2443: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2439: begin
2440: l_cells(1) := 'WH:Override Email Character Set Values';
2441: Get_Table(l_cells, 1, 'H', l_result);
2442: l_cells.DELETE;
2443: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2444:
2445: l_cells(1) := '25%:Language Code / DB Charset';
2446: l_cells(2) := '25%:Override IANA Charset';
2447:

Line 2457: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2453: end loop;
2454:
2455: Get_Table(l_cells, 2, 'H', l_result);
2456: l_cells.DELETE;
2457: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2458: exception
2459: when others then
2460: l_cells.DELETE;
2461: l_cells(1) := '10%:Note';

Line 2466: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2462: l_cells(2) := 'Error while fetching Override Email Charset Values';
2463: l_cells(3) := '10%:Error';
2464: l_cells(4) := sqlerrm;
2465: Get_Table(l_cells, 2, 'V', l_result);
2466: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2467:
2468: end Get_Override_Charset;
2469:
2470: --

Line 2647: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2643: l_result := l_result||' ';
2644: end if;
2645:
2646: l_result := l_result||'

'; 2647: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2648: l_amount := dbms_lob.getlength(l_doc); 2649: l_chunksize := 10000; 2650: l_offset := 1; 2651: Line 2648: l_amount := dbms_lob.getlength(l_doc); 2644: end if; 2645: 2646: l_result := l_result||' '; 2647: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2648: l_amount := dbms_lob.getlength(l_doc); 2649: l_chunksize := 10000; 2650: l_offset := 1; 2651: 2652: loop Line 2655: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2651: 2652: loop 2653: l_result := NULL; 2654: if (l_amount > l_chunksize) then 2655: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2656: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2657: l_amount := l_amount - l_chunksize; 2658: l_offset := l_offset + l_chunksize; 2659: l_buffer := NULL; Line 2660: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2656: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2657: l_amount := l_amount - l_chunksize; 2658: l_offset := l_offset + l_chunksize; 2659: l_buffer := NULL; 2660: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2661: else 2662: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2663: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2664: exit; Line 2662: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2658: l_offset := l_offset + l_chunksize; 2659: l_buffer := NULL; 2660: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2661: else 2662: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2663: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2664: exit; 2665: end if; 2666: end loop; Line 2669: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2665: end if; 2666: end loop; 2667: 2668: l_result := l_result||' '; 2669: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2670: l_result := NULL; 2671: i := i+1; 2672: end loop; 2673: Line 2676: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2672: end loop; 2673: 2674: if (i=1) then 2675: l_result := l_result||'
(not available)
';
2676: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2677: end if;
2678:
2679: exception
2680: when others then

Line 2687: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2683: 'from WF_NOTIFICATION_OUT for nid '||p_nid;
2684: l_cells(3) := '10%:Error';
2685: l_cells(4) := sqlerrm;
2686: Get_Table(l_cells, 2, 'V', l_result);
2687: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2688: end Get_Ntf_Msg_From_Out;
2689:
2690: --
2691: -- Get_Ntf_Msg_From_Out

Line 2758: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2754: exit when c_ntf_out%NOTFOUND;
2755:
2756: l_result := l_result||'
'; 2757: 2758: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2759: 2760: l_amount := dbms_lob.getlength(l_doc); 2761: 2762: l_chunksize := 10000; Line 2760: l_amount := dbms_lob.getlength(l_doc); 2756: l_result := l_result||''; 2757: 2758: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2759: 2760: l_amount := dbms_lob.getlength(l_doc); 2761: 2762: l_chunksize := 10000; 2763: l_offset := 1; 2764: Line 2769: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2765: loop 2766: l_result := NULL; 2767: 2768: if (l_amount > l_chunksize) then 2769: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2770: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2771: l_amount := l_amount - l_chunksize; 2772: l_offset := l_offset + l_chunksize; 2773: l_buffer := NULL; Line 2774: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2770: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2771: l_amount := l_amount - l_chunksize; 2772: l_offset := l_offset + l_chunksize; 2773: l_buffer := NULL; 2774: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2775: else 2776: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2777: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2778: exit; Line 2776: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2772: l_offset := l_offset + l_chunksize; 2773: l_buffer := NULL; 2774: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2775: else 2776: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2777: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2778: exit; 2779: end if; 2780: end loop; Line 2783: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2779: end if; 2780: end loop; 2781: 2782: l_result := l_result||' '; 2783: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2784: l_result := NULL; 2785: 2786: i := i+1; 2787: Line 2792: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2788: end loop; -- cursor loop 2789: 2790: if (i=1) then 2791: l_result := l_result||'
(not available)
';
2792: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2793: end if;
2794:
2795: exception
2796: when others then

Line 2803: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2799: ' WF_NOTIFICATION_OUT for role '||p_role;
2800: l_cells(3) := '10%:Error';
2801: l_cells(4) := sqlerrm;
2802: Get_Table(l_cells, 2, 'V', l_result);
2803: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2804: end Get_Summary_Msg_From_Out;
2805:
2806: --
2807: -- Get_Ntf_Msg_From_In

Line 2848: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2844: if (i=1) then
2845: l_result := l_result||'';
2846: end if;
2847: l_result := l_result||'
'; 2848: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2849: l_amount := dbms_lob.getlength(l_doc); 2850: l_chunksize := 10000; 2851: l_offset := 1; 2852: loop Line 2849: l_amount := dbms_lob.getlength(l_doc); 2845: l_result := l_result||'
';
2846: end if;
2847: l_result := l_result||'
'; 2848: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2849: l_amount := dbms_lob.getlength(l_doc); 2850: l_chunksize := 10000; 2851: l_offset := 1; 2852: loop 2853: l_result := NULL; Line 2855: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2851: l_offset := 1; 2852: loop 2853: l_result := NULL; 2854: if (l_amount > l_chunksize) then 2855: dbms_lob.read(l_doc, l_chunksize, l_offset, l_buffer); 2856: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2857: l_amount := l_amount - l_chunksize; 2858: l_offset := l_offset + l_chunksize; 2859: l_buffer := NULL; Line 2860: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2856: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2857: l_amount := l_amount - l_chunksize; 2858: l_offset := l_offset + l_chunksize; 2859: l_buffer := NULL; 2860: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2861: else 2862: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2863: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2864: exit; Line 2862: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2858: l_offset := l_offset + l_chunksize; 2859: l_buffer := NULL; 2860: dbms_lob.WriteAppend(p_value, length(l_result), l_result); 2861: else 2862: dbms_lob.read(l_doc, l_amount, l_offset, l_buffer); 2863: l_result := Wf_Notification.SubstituteSpecialChars(l_buffer); 2864: exit; 2865: end if; 2866: end loop; Line 2869: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2865: end if; 2866: end loop; 2867: 2868: l_result := l_result||'

';
2869: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2870: l_result := NULL;
2871: i := i+1;
2872: end loop;
2873:

Line 2876: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2872: end loop;
2873:
2874: if (i=1) then
2875: l_result := l_result||'(not available)';
2876: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2877: end if;
2878:
2879: exception
2880: when others then

Line 2886: dbms_lob.WriteAppend(p_value, length(l_result), l_result);

2882: l_cells(2) := 'Error when fetching Notification Message from WF_NOTIFICATION_IN for nid '||p_nid;
2883: l_cells(3) := '10%:Error';
2884: l_cells(4) := sqlerrm;
2885: Get_Table(l_cells, 2, 'V', l_result);
2886: dbms_lob.WriteAppend(p_value, length(l_result), l_result);
2887: end Get_Ntf_Msg_From_In;
2888:
2889: --
2890: -- Get_Ntf_Msg_From_In

Line 3080: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);

3076: l_head varchar2(100);
3077: l_group_cnt number;
3078:
3079: begin
3080: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
3081: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
3082: l_head := ''||to_char(p_nid)||' - wfmlrdbg output';
3083: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
3084:

Line 3081: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);

3077: l_group_cnt number;
3078:
3079: begin
3080: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
3081: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
3082: l_head := ''||to_char(p_nid)||' - wfmlrdbg output';
3083: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
3084:
3085: begin

Line 3083: dbms_lob.WriteAppend(l_value, length(l_head), l_head);

3079: begin
3080: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
3081: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
3082: l_head := ''||to_char(p_nid)||' - wfmlrdbg output';
3083: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
3084:
3085: begin
3086: select null
3087: into l_dummy

Line 3095: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3091: when NO_DATA_FOUND then
3092: l_cells(1) := 'WH:Notification Id '||p_nid||' has been purged and is not available in the Database.';
3093: Get_Table(l_cells, 1, 'H', l_temp_result);
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);

Line 3099: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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
3103: l_temp_result := '
'||wf_core.newline;

Line 3104: 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
3108: l_temp_result := '
'||wf_core.newline;

Line 3109: 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
3113: l_temp_result := '
'||wf_core.newline;

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

Line 3119: 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);
3123:

Line 3122: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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);
3123:
3124: p_value := l_value;
3125: return;
3126: end;

Line 3130: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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;
3134: l_temp_result := 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
3140: begin

Line 3154: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 3181: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3177: ' size='||td_fontsize||'>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);
3182: Get_Ntf_Msg_Attrs(p_nid, l_value);
3183: l_temp_result := 'Go to top
'||wf_core.newline;
3185: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 3185: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3181: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3182: Get_Ntf_Msg_Attrs(p_nid, l_value);
3183: l_temp_result := 'Go to top
'||wf_core.newline;
3185: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3186:
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);

Line 3188: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3192: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3196: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3200: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3204: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3208: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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
3212: l_temp_result := '
'

Line 3219: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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 := '
'
3223: ||Get_Event_Queue_Status(p_queue_name => WFD_ERROR,

Line 3229: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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 := '
'
3233: ||Get_Error_Ntf_Details(p_event_name => 'oracle.apps.wf.notification.%',

Line 3238: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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 := '
'
3242: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_OUT,

Line 3248: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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 := '
'
3252: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_IN,

Line 3258: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3262: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3266: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3270: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3274: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3278: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3282: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3286: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3290: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3294: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3298: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3302: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3306: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3310: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3314: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3318: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 3322: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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;
3326: l_temp_result := 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
3332: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 3332: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

3328: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3329:
3330:
3331: -- Send the final HTML Output to the caller
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;

Line 3339: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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;
3343:

Line 3340: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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;
3343:
3344: --

Line 3363: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);

3359:
3360: type t_controlq is ref cursor;
3361: l_unresponded_subs_c t_controlq;
3362: begin
3363: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);
3364: -- Set up Header
3365: l_temp_result := g_head ;
3366: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3367:

Line 3366: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3362: begin
3363: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);
3364: -- Set up Header
3365: l_temp_result := g_head ;
3366: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3367:
3368: l_temp_result := '';
3369:
3370: -- Removed check for concurrent request in order to make this work in Standalone too
Line 3383: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3379: l_temp_result := l_temp_result || '
';
3380: end if;
3381: l_temp_result := l_temp_result || '

DBMS JOB for Control Queue cleanup is not Running
';
3382:
3383: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3384:
3385: l_temp_result := '';
3386:
3387: execute immediate 'SELECT COUNT(1) FROM '||g_qowner||'.AQ$WF_CONTROL_S' INTO l_subscriber_number;
Line 3394: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3390: -- the message.
3391: IF (l_subscriber_number < 1024) THEN
3392: -- return message saying that the number of subscriber is OK.
3393: l_temp_result := l_temp_result || '

WF Control Queue has less than 1024 active subscribers.

';
3394: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3395: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
3396: p_value := l_value;
3397: return;
3398: END IF;

Line 3395: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

3391: IF (l_subscriber_number < 1024) THEN
3392: -- return message saying that the number of subscriber is OK.
3393: l_temp_result := l_temp_result || 'WF Control Queue has less than 1024 active subscribers. ';
3394: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3395: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
3396: p_value := l_value;
3397: return;
3398: END IF;
3399:

Line 3446: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3442: END;
3443: END IF;
3444:
3445: l_temp_result := l_temp_result || '';
3446: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3447:
3448: -- Send the final HTML Output to the caller
3449: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
3450:

Line 3449: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

3445: l_temp_result := l_temp_result || '';
3446: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3447:
3448: -- Send the final HTML Output to the caller
3449: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
3450:
3451: p_value := l_value;
3452: end Get_Control_Queue_Status;
3453:

Line 3492: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);

3488: AND oa.guid(+) = sub.out_agent_guid
3489: AND oa.system_guid = oas.guid(+)
3490: ORDER BY e.name;
3491: begin
3492: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);
3493: -- Set up Header
3494: l_temp_result := g_head ;
3495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3496:

Line 3495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3491: begin
3492: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.Session);
3493: -- Set up Header
3494: l_temp_result := g_head ;
3495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3496:
3497: l_temp_result := '';
3498:
3499: SELECT WF_EVENT.LOCAL_SYSTEM_NAME INTO l_sys_name FROM dual;
Line 3504: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3500:
3501: l_temp_result := l_temp_result || '
';
3502:
3503: l_temp_result := l_temp_result || '

The local System Name is ' || l_sys_name || '
';
3504: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3505:
3506: l_temp_result := '';
3507: l_temp_result := l_temp_result || '';
3508:
Line 3514: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3510: l_temp_result := l_temp_result || r_agent.agent_name || r_agent.sys_name || r_agent.status;
3511: end loop;
3512:
3513: l_temp_result := l_temp_result || '
Agent Name System Name Status

';
3514: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3515:
3516: l_temp_result := '';
3517: l_temp_result := l_temp_result || '';
3518:
Line 3527: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

3523: l_temp_result := l_temp_result || '
';
3524:
3525: end loop;
3526: l_temp_result := l_temp_result || '
Event Name Subscription Rule Function Subscription Out Agent Status

'|| r_sub.STATUS ||'
';
3527: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3528:
3529:
3530: -- Send the final HTML Output to the caller
3531: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

Line 3531: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

3527: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
3528:
3529:
3530: -- Send the final HTML Output to the caller
3531: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
3532:
3533: p_value := l_value;
3534: end Get_BES_Clone_Status;
3535:

Line 3601: l_amount := dbms_lob.GetLength(p_value);

3597: l_last_gt pls_integer;
3598: l_last_sc pls_integer;
3599: l_value varchar2(32000);
3600: begin
3601: l_amount := dbms_lob.GetLength(p_value);
3602: l_chunksize := 100;
3603: l_offset := 1;
3604: l_buffer_size := 0;
3605: if (l_amount > 0) then

Line 3609: dbms_lob.read(p_value, l_chunksize, l_offset, l_buffer);

3605: if (l_amount > 0) then
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

Line 3627: dbms_lob.read(p_value, l_amount, l_offset, l_buffer);

3623: l_amount := l_amount - l_buffer_size;
3624: l_offset := l_offset + l_buffer_size;
3625: l_buffer := '';
3626: else
3627: dbms_lob.read(p_value, l_amount, l_offset, l_buffer);
3628: dbms_output.put_line(l_buffer);
3629: exit;
3630: end if;
3631: end loop;

Line 3881: dbms_lob.CreateTemporary(l_message, TRUE, dbms_lob.Call);

3877: SELECT version
3878: INTO l_dbver
3879: FROM v$instance;
3880:
3881: dbms_lob.CreateTemporary(l_message, TRUE, dbms_lob.Call);
3882:
3883: l_cells(1) := 'WH:Workflow Agents/Queues Status report.';
3884: Get_table(l_cells, 1, 'H', l_temp);
3885: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);

Line 3885: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);

3881: dbms_lob.CreateTemporary(l_message, TRUE, dbms_lob.Call);
3882:
3883: l_cells(1) := 'WH:Workflow Agents/Queues Status report.';
3884: Get_table(l_cells, 1, 'H', l_temp);
3885: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);
3886: l_cells.DELETE;
3887:
3888: p_status := 'SUCCESS';
3889:

Line 3925: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);

3921: td_fontcolor := 'black';
3922:
3923: Get_table(l_cells, 7, 'H', l_temp);
3924: l_temp := '
'||l_temp;
3925: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);
3926: l_temp := '';
3927: l_cells.DELETE;
3928:
3929: if (agt_rec.name <> 'WF_CONTROL') then

Line 3964: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);

3960: Get_Table(l_cells, 1, 'H', l_temp);
3961: else
3962: Get_Table(l_cells, 4, 'H', l_temp);
3963: end if;
3964: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);
3965: l_cells.DELETE;
3966:
3967: -- Get Table header for writing Subscribers Rules
3968: l_cells(1) := '30%:Rule Name';

Line 4028: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);

4024: Get_Table(l_cells, 1, 'H', l_temp);
4025: else
4026: Get_Table(l_cells, 2, 'H', l_temp);
4027: end if;
4028: dbms_lob.WriteAppend(l_message, length(l_temp), l_temp);
4029: l_temp := '';
4030: l_cells.DELETE;
4031: end if;
4032: end if;

Line 4037: -- dbms_lob.Copy(p_report, l_message, dbms_lob.GetLength(l_message), 1, 1);

4033: close c_queue;
4034: end loop;
4035: close c_agents;
4036:
4037: -- dbms_lob.Copy(p_report, l_message, dbms_lob.GetLength(l_message), 1, 1);
4038: -- dbms_lob.FreeTemporary(l_message);
4039: p_report := l_message;
4040:
4041: end CheckAgentsAQStatus;

Line 4038: -- dbms_lob.FreeTemporary(l_message);

4034: end loop;
4035: close c_agents;
4036:
4037: -- dbms_lob.Copy(p_report, l_message, dbms_lob.GetLength(l_message), 1, 1);
4038: -- dbms_lob.FreeTemporary(l_message);
4039: p_report := l_message;
4040:
4041: end CheckAgentsAQStatus;
4042:

Line 4381: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);

4377: l_cells tdType;
4378: l_head varchar2(200);
4379: begin
4380:
4381: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4382: l_head := ''||'Event Info:'||p_event_name||' - wfbesdbg output';
4383: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
4384:
4385: begin

Line 4383: dbms_lob.WriteAppend(l_value, length(l_head), l_head);

4379: begin
4380:
4381: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4382: l_head := ''||'Event Info:'||p_event_name||' - wfbesdbg output';
4383: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
4384:
4385: begin
4386: select null
4387: into l_dummy

Line 4395: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

4391: when NO_DATA_FOUND then
4392: l_cells(1) := 'WH: Event '||p_event_name||' has been purged and is not available in the Database.';
4393: Get_Table(l_cells, 1, 'H', l_temp_result);
4394: l_cells.DELETE;
4395: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4396: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4397: p_value := l_value;
4398: return;
4399: end;

Line 4396: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

4392: l_cells(1) := 'WH: Event '||p_event_name||' has been purged and is not available in the Database.';
4393: Get_Table(l_cells, 1, 'H', l_temp_result);
4394: l_cells.DELETE;
4395: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4396: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4397: p_value := l_value;
4398: return;
4399: end;
4400:

Line 4402: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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 := '
'
4406: ||Get_Evt_Sys_Status(p_event_name => p_event_name,

Line 4411: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 4485: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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);
4489: p_value := l_value;

Line 4488: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

4484: ' size='||td_fontsize||'>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);
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;

Line 4495: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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;
4499:

Line 4496: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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;
4499:
4500:

Line 4527: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);

4523: l_install varchar2(1);
4524:
4525: begin
4526:
4527: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4528:
4529: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
4530:
4531: l_head := ''||'Role Info:'||p_role||' - wfsmrdbg output';

Line 4529: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);

4525: begin
4526:
4527: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4528:
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;

Line 4535: dbms_lob.WriteAppend(l_value, length(l_head), l_head);

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
4538: -- Get_Ntf_Role_Info / or some DIS Apis
4539: Wf_Directory.GetRoleInfoMail(p_role, l_dname, l_email,

Line 4556: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

4552: Get_Table(l_cells, 1, 'H', l_temp_result);
4553: l_cells.DELETE;
4554:
4555: -- Add to LOB
4556: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4557: --
4558: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4559:
4560: p_content := l_value;

Line 4558: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

4554:
4555: -- Add to LOB
4556: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4557: --
4558: dbms_lob.WriteAppend(l_value, length(g_end), g_end);
4559:
4560: p_content := l_value;
4561: return;
4562: end if;

Line 4567: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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
4571: l_temp_result := '
' ||Get_Summary_Ntf_Role_Info(p_role)||wf_core.newline;

Line 4573: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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 :
4577: -- Detail can be seen at WF_NOTIFICATION.getSummaryURL

Line 4588: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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
4591: l_temp_result := '
'||wf_core.newline;
4592: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 4592: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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:
4596: -- WF_XML.generate FOR an event with

Line 4600: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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
4604: l_temp_result := '
'||wf_core.newline;

Line 4605: 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
4609: l_temp_result := '
'||wf_core.newline;

Line 4610: 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
4614: l_temp_result := '
'||wf_core.newline;

Line 4615: 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
4619: l_temp_result := '
'||wf_core.newline;

Line 4620: 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
4624: l_temp_result := '
'||wf_core.newline;

Line 4625: 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;
4629: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 4629: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 4632: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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);
4633:
4634: p_content := l_value;
4635:
4636: exception

Line 4642: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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:
4646: end Get_Summary_Mailer_Debug; -- end of Summary Mailer dbg

Line 4643: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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:
4646: end Get_Summary_Mailer_Debug; -- end of Summary Mailer dbg
4647:

Line 4671: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);

4667:
4668: -- get session user
4669: select user into l_user from dual;
4670:
4671: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4672: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
4673:
4674: l_head := ''||'Alert Info:'||p_module||' - wfalrdbg output';
4675: dbms_lob.WriteAppend(l_value, length(l_head), l_head);

Line 4672: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);

4668: -- get session user
4669: select user into l_user from dual;
4670:
4671: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4672: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
4673:
4674: l_head := ''||'Alert Info:'||p_module||' - wfalrdbg output';
4675: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
4676:

Line 4675: dbms_lob.WriteAppend(l_value, length(l_head), l_head);

4671: dbms_lob.CreateTemporary(l_value, TRUE, dbms_lob.session);
4672: dbms_lob.CreateTemporary(l_temp, TRUE, dbms_lob.session);
4673:
4674: l_head := ''||'Alert Info:'||p_module||' - wfalrdbg output';
4675: dbms_lob.WriteAppend(l_value, length(l_head), l_head);
4676:
4677: -- Error Notification Details
4678: -- Check whether wf_error aq will have ALERT in case it failes or not.
4679: --

Line 4684: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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 := '
'
4688: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_OUT,

Line 4694: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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
4697: l_temp_result := '
'
4698: ||Get_JMS_Queue_Status(p_queue_name => WFD_NTF_IN,

Line 4704: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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;
4707: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);
4708:

Line 4707: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 4713: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 4719: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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);
4723: l_temp_result := '
'||wf_core.newline;

Line 4724: 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);
4728: l_temp_result := '
'||wf_core.newline;

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

Line 4734: 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;
4738: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

Line 4738: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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

Line 4741: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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);
4742:
4743: p_content := l_value;
4744:
4745: exception

Line 4752: dbms_lob.WriteAppend(l_value, length(l_temp_result), l_temp_result);

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:
4755: p_content := l_value;
4756:

Line 4753: dbms_lob.WriteAppend(l_value, length(g_end), g_end);

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:
4755: p_content := l_value;
4756:
4757: end Get_Mailer_Alert_Debug;

Event Name	Subscription Rule Function	Subscription Out Agent	Status
'\|\| r_sub.STATUS \|\|'