DBA Data[Home] [Help]

APPS.WF_EVENT_HTML dependencies on WFE_HTML_UTIL

Line 199: hTab wfe_html_util.headerTabType;

195: and (xn is null or lower(NAME) like '%'||lower(xn)||'%')
196: and (xs = '*' or STATUS = xs)
197: order by NAME;
198:
199: hTab wfe_html_util.headerTabType;
200: dTab wfe_html_util.dataTabType;
201: i pls_integer;
202:
203: username varchar2(320); -- Username to query

Line 200: dTab wfe_html_util.dataTabType;

196: and (xs = '*' or STATUS = xs)
197: order by NAME;
198:
199: hTab wfe_html_util.headerTabType;
200: dTab wfe_html_util.dataTabType;
201: i pls_integer;
202:
203: username varchar2(320); -- Username to query
204: admin_role varchar2(320); -- Role for admin mode

Line 320: Wfe_Html_Util.generate_confirm;

316: htp.title(wf_core.translate('WFE_LIST_EVENTS_TITLE'));
317: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVT');
318: fnd_document_management.get_open_dm_display_window;
319:
320: Wfe_Html_Util.generate_confirm;
321:
322: htp.headClose;
323:
324: -- Page header

Line 368: Wfe_Html_Util.Simple_Table(hTab, dTab);

364: hTab(i).value := wf_core.translate('STATUS');
365: hTab(i).attr := 'id="'||wf_core.translate('STATUS')||'"';
366:
367: -- render table
368: Wfe_Html_Util.Simple_Table(hTab, dTab);
369:
370: htp.tableopen (calign=>'CENTER ', cattributes=>'summary""');
371: htp.tableRowOpen;
372: htp.p('');

Line 397: wfe_html_util.Error;

393: exception
394: when OTHERS then
395: rollback;
396: wf_core.context('WF_EVENT_HTML', 'ListEvents');
397: wfe_html_util.Error;
398: end ListEvents;
399:
400: --
401: -- ListSystems

Line 421: hTab wfe_html_util.headerTabType;

417: and (xn is null or lower(NAME) like '%'||lower(xn)||'%')
418: and (mguid is null or MASTER_GUID = mguid)
419: order by NAME;
420:
421: hTab wfe_html_util.headerTabType;
422: dTab wfe_html_util.dataTabType;
423: i pls_integer;
424:
425: username varchar2(320); -- Username to query

Line 422: dTab wfe_html_util.dataTabType;

418: and (mguid is null or MASTER_GUID = mguid)
419: order by NAME;
420:
421: hTab wfe_html_util.headerTabType;
422: dTab wfe_html_util.dataTabType;
423: i pls_integer;
424:
425: username varchar2(320); -- Username to query
426: admin_role varchar2(320); -- Role for admin mode

Line 586: Wfe_Html_Util.generate_confirm;

582: htp.title(wf_core.translate('WFE_LIST_SYSTEMS_TITLE'));
583: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVSYS');
584: fnd_document_management.get_open_dm_display_window;
585:
586: Wfe_Html_Util.generate_confirm;
587:
588: htp.headClose;
589:
590: -- Page header

Line 630: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,

626: hTab(i).attr := 'id="'||wf_core.translate('MASTER')||'"';
627:
628: -- render table
629:
630: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,
631: tabattr=>'border=1 cellpadding=3 bgcolor=white width=100% summary="' ||
632: wf_core.translate('WFE_LIST_SYSTEMS_TITLE') || '"');
633:
634: -- message to indicate local system

Line 663: wfe_html_util.Error;

659: exception
660: when OTHERS then
661: rollback;
662: wf_core.context('WF_EVENT_HTML', 'ListSystems');
663: wfe_html_util.Error;
664: end ListSystems;
665:
666: --
667: -- ListAgents

Line 698: hTab wfe_html_util.headerTabType;

694: and (xd = '*' or A.DIRECTION = xd)
695: and (xs = '*' or A.STATUS = xs)
696: order by SYSTEM_NAME, A.NAME, A.ADDRESS, A.PROTOCOL;
697:
698: hTab wfe_html_util.headerTabType;
699: dTab wfe_html_util.dataTabType;
700: i pls_integer;
701:
702: username varchar2(320); -- Username to query

Line 699: dTab wfe_html_util.dataTabType;

695: and (xs = '*' or A.STATUS = xs)
696: order by SYSTEM_NAME, A.NAME, A.ADDRESS, A.PROTOCOL;
697:
698: hTab wfe_html_util.headerTabType;
699: dTab wfe_html_util.dataTabType;
700: i pls_integer;
701:
702: username varchar2(320); -- Username to query
703: admin_role varchar2(320); -- Role for admin mode

Line 884: Wfe_Html_Util.generate_confirm;

880: htp.title(wf_core.translate('WFE_LIST_AGENTS_TITLE'));
881: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVAGT');
882: fnd_document_management.get_open_dm_display_window;
883:
884: Wfe_Html_Util.generate_confirm;
885:
886: htp.headClose;
887:
888: -- Page header

Line 950: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,

946:
947: -- render table
948: -- for an empty table, show only the level 0 title
949: if (dTab.COUNT = 0) then
950: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,
951: tabattr=>'border=0 cellpadding=3 cellspacing=2 bgcolor=#CCCCCC
952: width=100%
953: summary="' || wf_core.translate('WFE_LIST_AGENTS_TITLE') || '"',
954: show_1st_title=>TRUE, show_level=>0);

Line 958: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,

954: show_1st_title=>TRUE, show_level=>0);
955:
956: -- show the full table
957: else
958: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,
959: tabattr=>'border=0 cellpadding=3 cellspacing=2 bgcolor=#CCCCCC
960: width=100%
961: summary="' || wf_core.translate('WFE_LIST_AGENTS_TITLE') || '"',
962: show_1st_title=>FALSE);

Line 984: wfe_html_util.Error;

980: exception
981: when OTHERS then
982: rollback;
983: wf_core.context('WF_EVENT_HTML', 'ListAgents');
984: wfe_html_util.Error;
985: end ListAgents;
986:
987: --
988: -- ListSubscriptions

Line 1019: hTab wfe_html_util.headerTabType;

1015: and E.GUID (+)= ES.EVENT_FILTER_GUID
1016: and SY.GUID (+)= ES.SYSTEM_GUID
1017: order by SYSTEM_NAME, EVENT_NAME, ES.PHASE;
1018:
1019: hTab wfe_html_util.headerTabType;
1020: dTab wfe_html_util.dataTabType;
1021: cTab wfe_html_util.tmpTabType; -- temporary column table
1022:
1023: i pls_integer;

Line 1020: dTab wfe_html_util.dataTabType;

1016: and SY.GUID (+)= ES.SYSTEM_GUID
1017: order by SYSTEM_NAME, EVENT_NAME, ES.PHASE;
1018:
1019: hTab wfe_html_util.headerTabType;
1020: dTab wfe_html_util.dataTabType;
1021: cTab wfe_html_util.tmpTabType; -- temporary column table
1022:
1023: i pls_integer;
1024: j pls_integer;

Line 1021: cTab wfe_html_util.tmpTabType; -- temporary column table

1017: order by SYSTEM_NAME, EVENT_NAME, ES.PHASE;
1018:
1019: hTab wfe_html_util.headerTabType;
1020: dTab wfe_html_util.dataTabType;
1021: cTab wfe_html_util.tmpTabType; -- temporary column table
1022:
1023: i pls_integer;
1024: j pls_integer;
1025:

Line 1374: Wfe_Html_Util.generate_confirm;

1370: htp.title(wf_core.translate('WFE_LIST_SUBSC_TITLE'));
1371: wfa_html.create_help_function('wf/links/def.htm?'||'DEFEVSUB');
1372: fnd_document_management.get_open_dm_display_window;
1373:
1374: Wfe_Html_Util.generate_confirm;
1375:
1376: htp.headClose;
1377:
1378: -- Page header

Line 1467: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,

1463: hTab(i).attr := 'id="'||wf_core.translate('STATUS')||'"';
1464:
1465: -- render table
1466: if (dTab.COUNT = 0) then
1467: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,
1468: tabattr=>'border=0 cellpadding=3 cellspacing=2 bgcolor=#CCCCCC
1469: width=100% summary="' ||
1470: wf_core.translate('WFE_LIST_SUBSC_TITLE') || '"',
1471: show_1st_title=>TRUE, show_level=>0);

Line 1475: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,

1471: show_1st_title=>TRUE, show_level=>0);
1472:
1473: -- show the full table
1474: else
1475: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab,
1476: tabattr=>'border=0 cellpadding=3 cellspacing=2 bgcolor=#CCCCCC
1477: width=100% summary="' ||
1478: wf_core.translate('WFE_LIST_SUBSC_TITLE') || '"',
1479: show_1st_title=>FALSE);

Line 1513: wfe_html_util.Error;

1509: exception
1510: when OTHERS then
1511: rollback;
1512: wf_core.context('WF_EVENT_HTML', 'ListSubscriptions');
1513: wfe_html_util.Error;
1514: end ListSubscriptions;
1515:
1516: --
1517: -- EditEvent

Line 1563: hTab wfe_html_util.headerTabType;

1559: where EG.GROUP_GUID = h_guid
1560: and E.GUID = EG.MEMBER_GUID;
1561:
1562:
1563: hTab wfe_html_util.headerTabType;
1564: dTab wfe_html_util.dataTabType;
1565: i pls_integer;
1566:
1567: aligntext varchar2(240);

Line 1564: dTab wfe_html_util.dataTabType;

1560: and E.GUID = EG.MEMBER_GUID;
1561:
1562:
1563: hTab wfe_html_util.headerTabType;
1564: dTab wfe_html_util.dataTabType;
1565: i pls_integer;
1566:
1567: aligntext varchar2(240);
1568:

Line 1679: Wfe_Html_Util.generate_check_all;

1675: end if;
1676:
1677: fnd_document_management.get_open_dm_display_window;
1678:
1679: Wfe_Html_Util.generate_check_all;
1680:
1681: htp.headClose;
1682:
1683: -- Page header

Line 1926: Wfe_Html_Util.Simple_Table(hTab, dTab);

1922: hTab(i).value := wf_core.translate('STATUS');
1923: hTab(i).attr := 'id="'||wf_core.translate('STATUS')||'"';
1924:
1925: -- render table
1926: Wfe_Html_Util.Simple_Table(hTab, dTab);
1927:
1928: htp.formClose;
1929:
1930: htp.tableOpen(cattributes=>'WIDTH=100%

Line 2049: wfe_html_util.Error;

2045: exception
2046: when others then
2047: rollback;
2048: wf_core.context('WF_EVENT_HTML', 'EditEvent', h_guid);
2049: wfe_html_util.Error;
2050: end EditEvent;
2051:
2052: --
2053: -- EditGroup

Line 2091: hTab wfe_html_util.headerTabType;

2087: where EG.GROUP_GUID = h_guid
2088: and E.GUID = EG.MEMBER_GUID;
2089:
2090:
2091: hTab wfe_html_util.headerTabType;
2092: dTab wfe_html_util.dataTabType;
2093: i pls_integer;
2094:
2095: username varchar2(320); -- Username to query

Line 2092: dTab wfe_html_util.dataTabType;

2088: and E.GUID = EG.MEMBER_GUID;
2089:
2090:
2091: hTab wfe_html_util.headerTabType;
2092: dTab wfe_html_util.dataTabType;
2093: i pls_integer;
2094:
2095: username varchar2(320); -- Username to query
2096: admin_role varchar2(320); -- Role for admin mode

Line 2135: Wfe_Html_Util.generate_check_all;

2131: htp.title(wf_core.translate('WFE_EDIT_GROUP_TITLE'));
2132: wfa_html.create_help_function('wf/links/t_d.htm?T_DEFEVGPM');
2133: fnd_document_management.get_open_dm_display_window;
2134:
2135: Wfe_Html_Util.generate_check_all;
2136:
2137: htp.headClose;
2138:
2139: -- Page header

Line 2235: Wfe_Html_Util.Simple_Table(hTab, dTab);

2231: hTab(i).value := wf_core.translate('STATUS');
2232: hTab(i).attr := 'id="'||wf_core.translate('STATUS')||'"';
2233:
2234: -- render table
2235: Wfe_Html_Util.Simple_Table(hTab, dTab);
2236:
2237: htp.formClose;
2238:
2239: -- If we generate simple table, we create this check/uncheck all.

Line 2309: wfe_html_util.Error;

2305: exception
2306: when others then
2307: rollback;
2308: wf_core.context('WF_EVENT_HTML', 'EditGroup', rawtohex(h_guid));
2309: wfe_html_util.Error;
2310: end EditGroup;
2311:
2312: --
2313: -- EditSystem

Line 2538: wfe_html_util.Error;

2534: exception
2535: when others then
2536: rollback;
2537: wf_core.context('WF_EVENT_HTML', 'EditSystem', h_guid);
2538: wfe_html_util.Error;
2539: end EditSystem;
2540:
2541: --
2542: -- EditAgent

Line 2905: wfe_html_util.Error;

2901: exception
2902: when others then
2903: rollback;
2904: wf_core.context('WF_EVENT_HTML', 'EditAgent', h_guid);
2905: wfe_html_util.Error;
2906: end EditAgent;
2907:
2908: --
2909: -- EditSubscription

Line 3814: wfe_html_util.Error;

3810: exception
3811: when OTHERS then
3812: rollback;
3813: wf_core.context('WF_EVENT_HTML', 'EditSubscription');
3814: wfe_html_util.Error;
3815: end EditSubscription;
3816:
3817: --
3818: -- SubmitEvent

Line 3913: Wfe_Html_Util.gotoURL(url);

3909: Wf_Event_Html.EditEvent(l_guid);
3910:
3911: -- Go to a specific url
3912: else
3913: Wfe_Html_Util.gotoURL(url);
3914: end if;
3915:
3916: exception
3917: when OTHERS then

Line 3920: wfe_html_util.Error;

3916: exception
3917: when OTHERS then
3918: rollback;
3919: wf_core.context('WF_EVENT_HTML', 'SubmitEvent', rawtohex(l_guid));
3920: wfe_html_util.Error;
3921: end SubmitEvent;
3922:
3923: --
3924: -- SubmitSelectedGEvents

Line 3955: Wfe_Html_Util.gotoURL(url);

3951: elsif (action = 'ADD') then
3952: Wf_Event_Html.AddSelectedGEvents(h_gguid, h_guids);
3953: end if;
3954:
3955: Wfe_Html_Util.gotoURL(url);
3956:
3957: exception
3958: when OTHERS then
3959: rollback;

Line 3962: wfe_html_util.Error;

3958: when OTHERS then
3959: rollback;
3960: wf_core.context('WF_EVENT_HTML', 'SubmitSelectedGEvents',
3961: rawtohex(h_gguid), url);
3962: wfe_html_util.Error;
3963: end SubmitSelectedGEvents;
3964:
3965: --
3966: -- SubmitSystem

Line 4043: wfe_html_util.Error;

4039: exception
4040: when OTHERS then
4041: rollback;
4042: wf_core.context('WF_EVENT_HTML', 'SubmitSystem', rawtohex(l_guid));
4043: wfe_html_util.Error;
4044: end SubmitSystem;
4045:
4046: --
4047: -- SubmitAgent

Line 4146: wfe_html_util.Error;

4142: exception
4143: when OTHERS then
4144: rollback;
4145: wf_core.context('WF_EVENT_HTML', 'SubmitAgent', rawtohex(l_guid));
4146: wfe_html_util.Error;
4147: end SubmitAgent;
4148:
4149: --
4150: -- SubmitSubscription

Line 4302: wfe_html_util.Error;

4298: exception
4299: when OTHERS then
4300: rollback;
4301: wf_core.context('WF_EVENT_HTML', 'SubmitSubscription', rawtohex(l_guid));
4302: wfe_html_util.Error;
4303: end SubmitSubscription;
4304:
4305: --
4306: -- FindEvent

Line 4336: hTab wfe_html_util.headerTabType;

4332: and (h_name is null or lower(NAME) like '%'||lower(h_name)||'%')
4333: and (h_status = '*' or STATUS = h_status)
4334: order by NAME;
4335:
4336: hTab wfe_html_util.headerTabType;
4337: dTab wfe_html_util.dataTabType;
4338: i pls_integer;
4339: title varchar2(2000);
4340: helptext varchar2(2000);

Line 4337: dTab wfe_html_util.dataTabType;

4333: and (h_status = '*' or STATUS = h_status)
4334: order by NAME;
4335:
4336: hTab wfe_html_util.headerTabType;
4337: dTab wfe_html_util.dataTabType;
4338: i pls_integer;
4339: title varchar2(2000);
4340: helptext varchar2(2000);
4341: selected boolean := FALSE;

Line 4404: Wfe_Html_Util.generate_check_all;

4400: htp.title(title);
4401: wfa_html.create_help_function(helptext);
4402: fnd_document_management.get_open_dm_display_window;
4403:
4404: Wfe_Html_Util.generate_check_all;
4405:
4406: htp.headClose;
4407:
4408: -- Page header

Line 4591: Wfe_Html_Util.Simple_Table(hTab, dTab);

4587: hTab(i).value := wf_core.translate('STATUS');
4588: hTab(i).attr := 'id="'||wf_core.translate('STATUS')||'"';
4589:
4590: -- render table
4591: Wfe_Html_Util.Simple_Table(hTab, dTab);
4592:
4593: htp.formClose;
4594:
4595: -- Buttons Area

Line 4645: wfe_html_util.Error;

4641: exception
4642: when others then
4643: rollback;
4644: wf_core.context('WF_EVENT_HTML', 'FindEvent', rawtohex(x_gguid));
4645: wfe_html_util.Error;
4646: end FindEvent;
4647:
4648: --
4649: -- FindSystem

Line 4718: Wfe_Html_Util.gotoURL(wfa_html.base_url||'/Wf_Event_Html.ListEvents');

4714: Wf_Events_Pkg.Delete_Row(h_guid);
4715: end if;
4716:
4717: -- go back to ListEvents
4718: Wfe_Html_Util.gotoURL(wfa_html.base_url||'/Wf_Event_Html.ListEvents');
4719:
4720: exception
4721: when others then
4722: rollback;

Line 4724: wfe_html_util.Error;

4720: exception
4721: when others then
4722: rollback;
4723: wf_core.context('WF_EVENT_HTML', 'DeleteEvent', rawtohex(h_guid));
4724: wfe_html_util.Error;
4725: end DeleteEvent;
4726:
4727: --
4728: -- DeleteSystem

Line 4752: wfe_html_util.Error;

4748: exception
4749: when others then
4750: rollback;
4751: wf_core.context('WF_EVENT_HTML', 'DeleteSystem', rawtohex(h_guid));
4752: wfe_html_util.Error;
4753: end DeleteSystem;
4754:
4755: --
4756: -- DeleteAgent

Line 4780: wfe_html_util.Error;

4776: exception
4777: when others then
4778: rollback;
4779: wf_core.context('WF_EVENT_HTML', 'DeleteAgent', rawtohex(h_guid));
4780: wfe_html_util.Error;
4781: end DeleteAgent;
4782:
4783: -- DeleteSubscription
4784: -- Delete a subscription

Line 4807: wfe_html_util.Error;

4803: exception
4804: when others then
4805: rollback;
4806: wf_core.context('WF_EVENT_HTML', 'DeleteSubscription', rawtohex(h_guid));
4807: wfe_html_util.Error;
4808: end DeleteSubscription;
4809:
4810: --
4811: -- wf_event_val

Line 5962: wfe_html_util.Error;

5958: exception
5959: when OTHERS then
5960: rollback;
5961: wf_core.context('WF_EVENT_HTML', 'RaiseEvent', p_event_name, p_event_key);
5962: wfe_html_util.Error;
5963: --raise;
5964: end RaiseEvent;
5965: -- RaiseEventConfirm
5966: -- Screen which confirms to user that event was raised.

Line 6034: wfe_html_util.Error;

6030: exception
6031: when OTHERS then
6032: rollback;
6033: wf_core.context('WF_EVENT_HTML', 'RaiseEventConfirm');
6034: wfe_html_util.Error;
6035: --raise;
6036: end RaiseEventConfirm;
6037: -- GetSystemIdentifier
6038: -- Returns xml document which contains Local System and In Agent details

Line 6110: wfe_html_util.Error;

6106: exception
6107: when OTHERS then
6108: rollback;
6109: wf_core.context('WF_EVENT_HTML', 'GetSystemIdentifier');
6110: wfe_html_util.Error;
6111: --raise;
6112: end GetSystemIdentifier;
6113:
6114: -- Event Queue Display

Line 6359: wfe_html_util.Error;

6355: exception
6356: when others then
6357: rollback;
6358: wf_core.context('WF_EVENT_HTML', 'EventQueueDisplay');
6359: wfe_html_util.Error;
6360: --raise;
6361: end EventQueueDisplay;
6362: -- FindQueueMessage
6363: -- Filter Screen over Queue Messages

Line 6527: wfe_html_util.Error;

6523: exception
6524: when others then
6525: rollback;
6526: wf_core.context('WF_EVENT_HTML', 'FindQueueMessage');
6527: wfe_html_util.Error;
6528: end;
6529: -- FindECXMSGQueueMessage
6530: -- Filter Screen over Queue Messages
6531: -- IN

Line 6696: wfe_html_util.Error;

6692: exception
6693: when others then
6694: rollback;
6695: wf_core.context('WF_EVENT_HTML', 'FindECXMSGQueueMessage');
6696: wfe_html_util.Error;
6697: end;
6698: -- FindECXMSGQueueMessage
6699: -- Filter Screen over Queue Messages
6700: -- IN

Line 6843: wfe_html_util.Error;

6839: exception
6840: when others then
6841: rollback;
6842: wf_core.context('WF_EVENT_HTML', 'FindECX_INENGOBJQueueMessage');
6843: wfe_html_util.Error;
6844: end;
6845:
6846:
6847:

Line 7228: wfe_html_util.Error;

7224: when others then
7225: rollback;
7226: Wf_Core.Context('WF_EVENT_HTML', 'ListQueueMessages',
7227: p_queue_name);
7228: wfe_html_util.Error;
7229: --raise;
7230: end ListQueueMessages;
7231: -- EventDataContents
7232: -- Shows clob contents in XML format

Line 7425: wfe_html_util.Error;

7421: when others then
7422: rollback;
7423: Wf_Core.Context('WF_EVENT_HTML', 'EventDataContents',
7424: p_queue_table,p_message_id);
7425: wfe_html_util.Error;
7426: --raise;
7427: end EventDataContents;
7428: procedure EventDataContents (
7429: P_EVENTATTRIBUTE in varchar2,

Line 7538: wfe_html_util.Error;

7534: WHEN OTHERS THEN
7535: rollback;
7536: WF_CORE.Context('WF_STANDARD', 'EventDataContents',
7537: P_EventAttribute, P_ItemType, P_ItemKey);
7538: wfe_html_util.Error;
7539: --RAISE;
7540: end EventDataContents;
7541:
7542: