APPS.WF_MONITOR dependencies on WF_MONITOR

Line 1: package body WF_MONITOR as

1: package body WF_MONITOR as
2: /* $Header: wfmonb.pls 120.14 2006/09/19 11:34:35 santosin ship $: */
3:
4: type NameArrayTyp is table of varchar2(240) index by binary_integer;
5:

Line 117: Wf_Core.Context('wf_monitor',

113: x_status_icons_table(G_SUSPEND).icon_file_name := 'FNDIYLWL.gif';
114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: Wf_Core.Context('wf_monitor',
118: 'create_status_icons_table');
119: Error;
120:
121: END create_status_icons_table;

Line 204: l_code varchar2(80) := 'oracle.apps.fnd.wf.Monitor';

200: item_type_tl varchar2(80);
201: l_ie_plugin_ver varchar2(80); -- IE version is delimited by ','
202: l_archive varchar2(2000); -- first look for java classes at this archive
203: l_java_loc VARCHAR2(80) := '/OA_JAVA/';
204: l_code varchar2(80) := 'oracle.apps.fnd.wf.Monitor';
205: l_wf_plugin_download varchar2(80);
206: l_wf_plugin_version varchar2(80);
207: l_wf_classid varchar2(80);
208: l_admin varchar(4) := 'no';

Line 279: wf_core.Context('Wf_Monitor', 'HTML', x_item_type, x_item_key);

275: and item_key = x_item_key;
276:
277: exception
278: when NO_DATA_FOUND then
279: wf_core.Context('Wf_Monitor', 'HTML', x_item_type, x_item_key);
280: wf_core.Token('TYPE', x_item_type);
281: wf_core.Token('KEY', x_item_key);
282: wf_core.Raise('WFENG_ITEM');
283: when OTHERS then

Line 317: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top',

313: wfa_html.create_help_function('wf/links/wfm.htm?WFMON');
314: htp.p('

Line 368: htp.p('

364: ' installType="' || l_installType || '">'||
365: '</COMMENT>');
366: else
367: -- Client is not Windows, so we don't want to call Jinitiator.
368: htp.p(' 369:
370: l_archive := '/OA_JAVA/oracle/apps/fnd/jar/wfmon.jar, ' ||
371: '/OA_JAVA/oracle/apps/fnd/jar/fndewt.jar, ' ||
372: '/OA_JAVA/oracle/apps/fnd/jar/fndswing.jar, ' ||

Line 391: htp.p('

387: end if;
388:
389: else
390:
391: htp.p(' 392:
393: -- ### We should have this be under fnd/jar after 2.6
394: -- htp.p(' archive="/OA_JAVA/oracle/apps/fnd/wf/jar/wfmon.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndewt.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndswing.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndbalishare.jar"');
395:

Line 1424: return(x_agent||'/wf_monitor.html'||

1420: into xnls_lang
1421: from wf_languages
1422: where code=userenv('LANG');
1423:
1424: return(x_agent||'/wf_monitor.html'||
1425: '?'||'x_item_type=' ||wfa_html.conv_special_url_chars(x_item_type)||
1426: '&'||'x_item_key=' ||wfa_html.conv_special_url_chars(x_item_key)||
1427: '&'||'x_admin_mode='||x_admin_mode||
1428: '&'||'x_access_key='||access_key||

Line 1569: host:port/pls//wf_monitor.buildMonitorUrl?

1565: end getFunctionForRegion;
1566:
1567:
1568: /**Gets old Status monitor URL's of the form
1569: host:port/pls//wf_monitor.buildMonitorUrl?
1570: and converts it to a URL of the form RF.jsp so that the corresponding
1571: Status monitor function(digram, activities etc) gets directly accessed
1572: without the using PL/SQL catridge.Returns following error code
1573: 0 - Success

Line 1674: return(x_agent||'/wf_monitor.envelope'||

1670:
1671: --
1672: if x_options is not null then
1673:
1674: return(x_agent||'/wf_monitor.envelope'||
1675: '?'||'x_item_type=' ||wfa_html.conv_special_url_chars(x_item_type)||
1676: '&'||'x_item_key=' ||wfa_html.conv_special_url_chars(x_item_key)||
1677: '&'||'x_admin_mode='||x_admin_mode||
1678: '&'||'x_access_key='||access_key||

Line 1690: return(x_agent||'/wf_monitor.envelope'||

1686: '&'||'x_nls_lang='||xnls_lang);
1687:
1688: else
1689:
1690: return(x_agent||'/wf_monitor.envelope'||
1691: '?'||'x_item_type=' ||wfa_html.conv_special_url_chars(x_item_type)||
1692: '&'||'x_item_key=' ||wfa_html.conv_special_url_chars(x_item_key)||
1693: '&'||'x_admin_mode='||x_admin_mode||
1694: '&'||'x_access_key='||access_key||

Line 1758: return(x_agent||'/wf_monitor.envelope'||

1754: into xnls_lang
1755: from wf_languages
1756: where code=userenv('LANG');
1757:
1758: return(x_agent||'/wf_monitor.envelope'||
1759: '?'||'x_item_type=' ||wfa_html.conv_special_url_chars(x_item_type)||
1760: '&'||'x_item_key=' ||wfa_html.conv_special_url_chars(x_item_key)||
1761: '&'||'x_admin_mode='||x_admin_mode||
1762: '&'||'x_access_key='||access_key||

Line 1848: wf_monitor.Find_Instance();

1844: admin_mode VARCHAR2,
1845: access_key VARCHAR2) is
1846: begin
1847: if (item_type is null and item_key is null) then
1848: wf_monitor.Find_Instance();
1849: else
1850: wf_monitor.Envelope(item_type, item_key, admin_mode, access_key);
1851: end if;
1852: end ;

Line 1850: wf_monitor.Envelope(item_type, item_key, admin_mode, access_key);

1846: begin
1847: if (item_type is null and item_key is null) then
1848: wf_monitor.Find_Instance();
1849: else
1850: wf_monitor.Envelope(item_type, item_key, admin_mode, access_key);
1851: end if;
1852: end ;
1853:
1854:

Line 1989: 'Wf_Monitor',

1985:
1986: exception
1987: when others then
1988: Wf_Core.Context(
1989: 'Wf_Monitor',
1990: 'createenvsortlink',
1991: x_cur_sort_column ,
1992: x_cur_sort_order ,
1993: x_sort_column );

Line 2034: 'wf_monitor.envelope'||

2030: ** routine that gets passed anywhere you create an
2031: ** envelope url
2032: */
2033: x_standard_url := owa_util.get_owa_service_path||
2034: 'wf_monitor.envelope'||
2035: '?x_item_type='||wfa_html.conv_special_url_chars(x_item_type)||
2036: '&x_item_key='||wfa_html.conv_special_url_chars(x_item_key)||
2037: '&x_admin_mode='||x_admin_mode||
2038: '&x_access_key='||x_access_key||

Line 2165: Wf_Core.Context('Wf_Monitor', 'ShowColumnHeaders');

2161: htp.tableRowClose;
2162:
2163: exception
2164: when others then
2165: Wf_Core.Context('Wf_Monitor', 'ShowColumnHeaders');
2166: raise;
2167: end showColumnHeaders;
2168:
2169: --

Line 2252: Wf_Core.Context('Wf_Monitor', 'TableRow', itemtype, itemkey, process,

2248: htp.tableRowClose;
2249:
2250: exception
2251: when others then
2252: Wf_Core.Context('Wf_Monitor', 'TableRow', itemtype, itemkey, process,
2253: url, startdate);
2254: raise;
2255: end TableRow;
2256:

Line 2377: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top',

2373: wfa_html.create_help_function('wf/links/pro.htm?PROLIST');
2374: htp.headClose;
2375:
2376: -- Open body and draw standard header
2377: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top',
2378: wf_core.translate('WFMON_LISTTITLE'), TRUE);
2379:
2380: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=WHITE
2381: width=100% summary=""');

Line 2406: envurl :=wf_monitor.GetEnvelopeURL(wfa_html.base_url,

2402: fetch status_info into suspend_count;
2403: close status_info;
2404:
2405: begin
2406: envurl :=wf_monitor.GetEnvelopeURL(wfa_html.base_url,
2407: proc.item_type,
2408: proc.item_key,
2409: x_admin_privilege);
2410: exception

Line 2437: Wf_Core.Context('Wf_Monitor', 'Instance_List', x_active, x_itemtype,

2433: wfa_sec.footer;
2434: htp.htmlClose;
2435: exception
2436: when others then
2437: Wf_Core.Context('Wf_Monitor', 'Instance_List', x_active, x_itemtype,
2438: x_ident, x_process, x_status);
2439: Error;
2440: end Instance_List;
2441:

Line 2476: htp.p('

');

2472: l_status_icons_table wf_status_icons_table;
2473:
2474: BEGIN
2475:
2476: htp.p('');
2477:
2478: /*
2479: ** Skip a line
2480: */

Line 2677: Wf_Core.Context('wf_monitor',

2673: htp.formClose;
2674:
2675: EXCEPTION
2676: WHEN OTHERS THEN
2677: Wf_Core.Context('wf_monitor',
2678: 'draw_advanced_controls',
2679: x_advanced);
2680:
2681: error;

Line 2753: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top', wf_core.translate('WFMON_ENVELOPE_LIST'), TRUE, pseudo_login);

2749:
2750: -- Open body and draw standard header
2751: IF (x_advanced = 'FALSE') THEN
2752:
2753: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top', wf_core.translate('WFMON_ENVELOPE_LIST'), TRUE, pseudo_login);
2754:
2755: else
2756:
2757: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top', wf_core.translate('WFMON_ACTIVITIES_LIST'), TRUE, pseudo_login);

Line 2757: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top', wf_core.translate('WFMON_ACTIVITIES_LIST'), TRUE, pseudo_login);

2753: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top', wf_core.translate('WFMON_ENVELOPE_LIST'), TRUE, pseudo_login);
2754:
2755: else
2756:
2757: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top', wf_core.translate('WFMON_ACTIVITIES_LIST'), TRUE, pseudo_login);
2758:
2759: end if;
2760:
2761: exception

Line 2763: Wf_Core.Context('wf_monitor',

2759: end if;
2760:
2761: exception
2762: when others then
2763: Wf_Core.Context('wf_monitor',
2764: 'draw_header',
2765: x_item_type,
2766: x_item_key,
2767: x_admin_mode,

Line 2796: l_child_item_list wf_monitor.wf_items_tbl_type;

2792: x_nls_lang VARCHAR2
2793: ) is
2794:
2795: username varchar2(320);
2796: l_child_item_list wf_monitor.wf_items_tbl_type;
2797: l_number_of_children NUMBER :=0;
2798: begin
2799:
2800: /*

Line 2856: 'wf_monitor.draw_header'||

2852:
2853: htp.p(' 2854: 'scrolling=no frameborder=no framespacing=noresize '||
2855: 'src="'||owa_util.get_owa_service_path||
2856: 'wf_monitor.draw_header'||
2857: '?x_item_type='||wfa_html.conv_special_url_chars(x_item_type)||
2858: '&x_item_key='||wfa_html.conv_special_url_chars(x_item_key)||
2859: '&x_admin_mode='||x_admin_mode||
2860: '&x_access_key='||x_access_key||

Line 2878: wf_monitor.get_process_children(X_item_type,

2874:
2875: /*
2876: ** Get the process children for this row
2877: */
2878: wf_monitor.get_process_children(X_item_type,
2879: X_item_key,
2880: l_child_item_list,
2881: l_number_of_children);
2882:

Line 2892: 'wf_monitor.process_children'||

2888: 'wfa_html.LongDesc?p_token=WFMON_ENVELOPE_LIST">');
2889:
2890: htp.p(' 2891: 'src="'||owa_util.get_owa_service_path||
2892: 'wf_monitor.process_children'||
2893: '?x_item_type='||wfa_html.conv_special_url_chars(x_item_type)||
2894: '&x_item_key='||wfa_html.conv_special_url_chars(x_item_key)||
2895: '&x_admin_mode='||x_admin_mode||
2896: '&x_nls_lang='||x_nls_lang||'" WRAP=OFF "' ||

Line 2904: 'wf_monitor.envelope_frame'||

2900: 'wfa_html.LongDesc?p_token=WFMON_ENVELOPE_LIST">');
2901:
2902: htp.p(' 2903: 'src="'||owa_util.get_owa_service_path||
2904: 'wf_monitor.envelope_frame'||
2905: '?x_item_type='||wfa_html.conv_special_url_chars(x_item_type)||
2906: '&x_item_key='||wfa_html.conv_special_url_chars(x_item_key)||
2907: '&x_admin_mode='||wfa_html.conv_special_url_chars(x_admin_mode)||
2908: '&x_access_key='||wfa_html.conv_special_url_chars(x_access_key)||

Line 2936: 'wf_monitor.envelope_frame'||

2932: 'wfa_html.LongDesc?p_token=WFMON_ENVELOPE_LIST">');
2933:
2934: htp.p(' 2935: 'src="'||owa_util.get_owa_service_path||
2936: 'wf_monitor.envelope_frame'||
2937: '?x_item_type='||wfa_html.conv_special_url_chars(x_item_type)||
2938: '&x_item_key='||wfa_html.conv_special_url_chars(x_item_key)||
2939: '&x_admin_mode='||x_admin_mode||
2940: '&x_access_key='||x_access_key||

Line 2969: Wf_Core.Context('Wf_Monitor', 'Envelope', x_item_type, x_item_key);

2965: htp.htmlClose;
2966:
2967: exception
2968: when others then
2969: Wf_Core.Context('Wf_Monitor', 'Envelope', x_item_type, x_item_key);
2970: Error;
2971: end envelope;
2972:
2973: --

Line 3037: x_activity_cursor wf_monitor.wf_activity_cursor;

3033: l_valid_date BOOLEAN;
3034: l_expected_format VARCHAR2(80);
3035: u_key VARCHAR2(240);
3036: l_status_icons_table wf_status_icons_table;
3037: x_activity_cursor wf_monitor.wf_activity_cursor;
3038: x_activity_record wf_monitor.wf_activity_record;
3039: pseudo_login BOOLEAN := FALSE;
3040:
3041: cursor attrs(mnid in number) is

Line 3038: x_activity_record wf_monitor.wf_activity_record;

3034: l_expected_format VARCHAR2(80);
3035: u_key VARCHAR2(240);
3036: l_status_icons_table wf_status_icons_table;
3037: x_activity_cursor wf_monitor.wf_activity_cursor;
3038: x_activity_record wf_monitor.wf_activity_record;
3039: pseudo_login BOOLEAN := FALSE;
3040:
3041: cursor attrs(mnid in number) is
3042: select MA.NAME

Line 3126: 'open('||''''||'wf_monitor.draw_header'||

3122: htp.htmlOpen;
3123:
3124: -- use onload to redraw the header with new title when moving to detail screen
3125: htp.p('');

3221: ** Create the envelope form. The envelope form is under the advanced_controls
3222: ** form and is implemented as a separate form so that you can have the
3223: ** diffent submit controls for View Monitor vs. Show Activities.
3224: */
3225: htp.p('');
3226:
3227: /*
3228: ** Open the main table for the list of activities
3229: */

Line 3898: 'wf_monitor.draw_activity_error?x_item_type='||

3894: IF NOT (pseudo_login) then
3895: htp.tableData(
3896: cvalue=>'');

3972: ** options parameter so you want to show the advanced options button.
3973: */
3974: IF (x_advanced = 'FALSE') THEN
3975:
3976: htp.p('');
3977:
3978: htp.p(htf.formHidden('x_advanced', 'FIRST'));
3979: htp.p(htf.formHidden('x_item_type', x_item_type));
3980: htp.p(htf.formHidden('x_item_key', x_item_key));

Line 4021: Wf_Core.Context('Wf_Monitor', 'Envelope_Frame', x_item_type, x_item_key);

4017: htp.htmlClose;
4018:
4019: exception
4020: when others then
4021: Wf_Core.Context('Wf_Monitor', 'Envelope_Frame', x_item_type, x_item_key);
4022: Error;
4023: end envelope_frame;
4024:
4025: -- MODIFICATION LOG:

Line 4131: Wf_Core.Context('Wf_Monitor', 'Draw_Activity_Error', x_item_type, x_item_key);

4127: END LOOP;
4128:
4129: exception
4130: when others then
4131: Wf_Core.Context('Wf_Monitor', 'Draw_Activity_Error', x_item_type, x_item_key);
4132: Error;
4133:
4134: END draw_activity_error;
4135:

Line 4140: p_child_item_list OUT NOCOPY wf_monitor.wf_items_tbl_type,

4136:
4137: procedure get_process_children (
4138: p_parent_item_type IN VARCHAR2,
4139: p_parent_item_key IN VARCHAR2,
4140: p_child_item_list OUT NOCOPY wf_monitor.wf_items_tbl_type,
4141: p_number_of_children OUT NOCOPY NUMBER) IS
4142:
4143: cursor c_get_process_children IS
4144: SELECT item_type,

Line 4187: Wf_Core.Context('Wf_Monitor', 'get_process_children',

4183: CLOSE c_get_process_children;
4184: p_number_of_children := 0;
4185: return;
4186: when others then
4187: Wf_Core.Context('Wf_Monitor', 'get_process_children',
4188: p_parent_item_type, p_parent_item_key);
4189: Error;
4190:
4191: END get_process_children;

Line 4202: l_child_item_list wf_monitor.wf_items_tbl_type;

4198: p_nls_lang IN VARCHAR2) IS
4199:
4200: username VARCHAR2(320);
4201: access_key VARCHAR2(240);
4202: l_child_item_list wf_monitor.wf_items_tbl_type;
4203: l_number_of_children NUMBER :=0;
4204: l_record_num NUMBER := 0;
4205: ii NUMBER := 0;
4206: l_indent_str VARCHAR2(240) := NULL;

Line 4250: '/wf_monitor.envelope_frame'||

4246: htp.p ('');
4247:
4248: htp.p(l_indent_str||' 4310:
4311: wf_monitor.draw_process_children (x_item_type,
4312: x_item_key,
4313: x_admin_mode,
4314: 0,x_nls_lang);
4315:

Line 4323: Wf_Core.Context('Wf_Monitor', 'process_children',

4319: wfa_sec.footer;
4320:
4321: exception
4322: when others then
4323: Wf_Core.Context('Wf_Monitor', 'process_children',
4324: x_item_type, x_item_key);
4325: Error;
4326:
4327: END process_children;

Line 4350: p_function_name =>'WF_MONITOR_DIAGRAM_DATA',

4346: '&'||'adminMode='||p_admin_mode||
4347: '&'||'accessKey='||p_access_key||'&retainAM=Y';
4348:
4349: l_func := fnd_run_function.get_run_function_url(
4350: p_function_name =>'WF_MONITOR_DIAGRAM_DATA',
4351: p_resp_appl => null,
4352: p_resp_key => null,
4353: p_security_group_key => null,
4354: p_parameters => l_params,

Line 4366: p_function_name =>'WF_MONITOR_RES',

4362: is
4363: l_func varchar2(4000);
4364: begin
4365: l_func := fnd_run_function.get_run_function_url(
4366: p_function_name =>'WF_MONITOR_RES',
4367: p_resp_appl => null,
4368: p_resp_key => null,
4369: p_security_group_key => null,
4370: p_parameters => 'retainAM=Y',

Line 4388: p_function_name =>'WF_MONITOR_CRES_DATA',

4384: l_params := 'resType='||p_resType||
4385: '&'||'resPattern='||p_resPattern||'&retainAM=Y';
4386:
4387: l_func := fnd_run_function.get_run_function_url(
4388: p_function_name =>'WF_MONITOR_CRES_DATA',
4389: p_resp_appl => null,
4390: p_resp_key => null,
4391: p_security_group_key => null,
4392: p_parameters => l_params,

Line 4414: l_code varchar2(80) := 'oracle.apps.fnd.wf.Monitor';

4410: x_nls_lang in varchar2,
4411: x_browser in varchar2) return varchar2 is
4412:
4413: lang_codeset varchar2(50);
4414: l_code varchar2(80) := 'oracle.apps.fnd.wf.Monitor';
4415: l_archive varchar2(2000); -- first look for java classes at this archive
4416: l_wf_plugin_download varchar2(80);
4417: l_wf_plugin_version varchar2(80);
4418: l_wf_classid varchar2(80);

Line 4521: '

4517: else
4518:
4519: -- Client is not Windows, so we don't want to call Jinitiator.
4520: l_return_buffer := l_return_buffer ||
4521: ' 4522:
4523: l_archive := '/OA_JAVA/oracle/apps/fnd/jar/wfmon.jar, ' ||
4524: '/OA_JAVA/oracle/apps/fnd/jar/fndewt.jar, ' ||
4525: '/OA_JAVA/oracle/apps/fnd/jar/fndswing.jar, ' ||

Line 4552: end WF_MONITOR;

4548: return l_return_buffer;
4549:
4550: end createapplettags;
4551:
4552: end WF_MONITOR;