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_SETUP dependencies on WFE_HTML_UTIL

Line 50: hTab wfe_html_util.headerTabType;

46: where NAME in ('aq_tm_processes', 'job_queue_processes',
47: 'job_queue_interval')
48: order by NAME;
49:
50: hTab wfe_html_util.headerTabType;
51: dTab wfe_html_util.dataTabType;
52: i pls_integer;
53: vTab wfe_html_util.tmpTabType;
54:

Line 51: dTab wfe_html_util.dataTabType;

47: 'job_queue_interval')
48: order by NAME;
49:
50: hTab wfe_html_util.headerTabType;
51: dTab wfe_html_util.dataTabType;
52: i pls_integer;
53: vTab wfe_html_util.tmpTabType;
54:
55: begin

Line 53: vTab wfe_html_util.tmpTabType;

49:
50: hTab wfe_html_util.headerTabType;
51: dTab wfe_html_util.dataTabType;
52: i pls_integer;
53: vTab wfe_html_util.tmpTabType;
54:
55: begin
56: -- set the recommended values
57: i := 1;

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

92: htp.p('

'||wf_core.translate('WFE_INITPARAMS')||'');
93: -- ### Database Init.ora Parameters
94:
95: -- render table
96: Wfe_Html_Util.Simple_Table(hTab, dTab);
97:
98: exception
99: when OTHERS then
100: wf_core.context('WF_SETUP', 'Check_InitParameters');

Line 101: wfe_html_util.Error;

97:
98: exception
99: when OTHERS then
100: wf_core.context('WF_SETUP', 'Check_InitParameters');
101: wfe_html_util.Error;
102: end Check_InitParameters;
103:
104: procedure Check_Dblinks(
105: localsguid raw

Line 116: hTab wfe_html_util.headerTabType;

112: where PROTOCOL = 'SQLNET'
113: and DIRECTION = 'IN'
114: and SYSTEM_GUID <> localsguid;
115:
116: hTab wfe_html_util.headerTabType;
117: dTab wfe_html_util.dataTabType;
118: i pls_integer;
119:
120: begin

Line 117: dTab wfe_html_util.dataTabType;

113: and DIRECTION = 'IN'
114: and SYSTEM_GUID <> localsguid;
115:
116: hTab wfe_html_util.headerTabType;
117: dTab wfe_html_util.dataTabType;
118: i pls_integer;
119:
120: begin
121: -- populate the data table

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

161: htp.p('

'||wf_core.translate('WFE_DBLINKS')||'');
162: -- ### Database Links
163:
164: -- render table
165: Wfe_Html_Util.Simple_Table(hTab, dTab);
166:
167: exception
168: when OTHERS then
169: rollback;

Line 171: wfe_html_util.Error;

167: exception
168: when OTHERS then
169: rollback;
170: wf_core.context('WF_SETUP', 'Check_Dblinks');
171: wfe_html_util.Error;
172: end Check_Dblinks;
173:
174:
175: procedure Check_Queues(

Line 185: hTab wfe_html_util.headerTabType;

181: from WF_AGENTS A
182: where A.SYSTEM_GUID = localsguid
183: and A.PROTOCOL = 'SQLNET';
184:
185: hTab wfe_html_util.headerTabType;
186: dTab wfe_html_util.dataTabType;
187: i pls_integer;
188:
189: include_create boolean := FALSE;

Line 186: dTab wfe_html_util.dataTabType;

182: where A.SYSTEM_GUID = localsguid
183: and A.PROTOCOL = 'SQLNET';
184:
185: hTab wfe_html_util.headerTabType;
186: dTab wfe_html_util.dataTabType;
187: i pls_integer;
188:
189: include_create boolean := FALSE;
190: creatable boolean;

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

279: htp.p('

'||wf_core.translate('WFE_LOCAL_QUEUES')||'');
280: -- ### Local Agents
281:
282: -- render table
283: Wfe_Html_Util.Simple_Table(hTab, dTab);
284:
285: exception
286: when OTHERS then
287: rollback;

Line 289: wfe_html_util.Error;

285: exception
286: when OTHERS then
287: rollback;
288: wf_core.context('WF_SETUP', 'Check_Queues');
289: wfe_html_util.Error;
290: end Check_Queues;
291:
292:
293: procedure Check_Listeners(

Line 305: hTab wfe_html_util.headerTabType;

301: and A.PROTOCOL = 'SQLNET'
302: and A.STATUS = 'ENABLED'
303: and (A.DIRECTION is null or A.DIRECTION in ('IN', 'ANY'));
304:
305: hTab wfe_html_util.headerTabType;
306: dTab wfe_html_util.dataTabType;
307: i pls_integer;
308:
309: creatable boolean;

Line 306: dTab wfe_html_util.dataTabType;

302: and A.STATUS = 'ENABLED'
303: and (A.DIRECTION is null or A.DIRECTION in ('IN', 'ANY'));
304:
305: hTab wfe_html_util.headerTabType;
306: dTab wfe_html_util.dataTabType;
307: i pls_integer;
308:
309: creatable boolean;
310: jobnum number;

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

376: htp.p('

'||wf_core.translate('WFE_LISTENERS')||'');
377: -- ### Listeners for local queues.
378:
379: -- render table
380: Wfe_Html_Util.Simple_Table(hTab, dTab);
381:
382: exception
383: when OTHERS then
384: rollback;

Line 386: wfe_html_util.Error;

382: exception
383: when OTHERS then
384: rollback;
385: wf_core.context('WF_SETUP', 'Check_Listeners');
386: wfe_html_util.Error;
387: end Check_Listeners;
388:
389:
390: procedure Check_Propagations(

Line 422: hTab wfe_html_util.headerTabType;

418: and A.PROTOCOL = 'SQLNET'
419: and A.DIRECTION = 'OUT'
420: order by TOSYSTEM;
421:
422: hTab wfe_html_util.headerTabType;
423: dTab wfe_html_util.dataTabType;
424: i pls_integer;
425:
426: creatable boolean;

Line 423: dTab wfe_html_util.dataTabType;

419: and A.DIRECTION = 'OUT'
420: order by TOSYSTEM;
421:
422: hTab wfe_html_util.headerTabType;
423: dTab wfe_html_util.dataTabType;
424: i pls_integer;
425:
426: creatable boolean;
427:

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

518: htp.p('

'||wf_core.translate('WFE_PROPAGATIONS')||'');
519: -- ### Propagations for local out agents.
520:
521: -- render table
522: Wfe_Html_Util.Simple_Table(hTab, dTab);
523:
524: exception
525: when OTHERS then
526: rollback;

Line 528: wfe_html_util.Error;

524: exception
525: when OTHERS then
526: rollback;
527: wf_core.context('WF_SETUP', 'Check_Propagations');
528: wfe_html_util.Error;
529: end Check_Propagations;
530:
531: procedure Check_All
532: is

Line 574: Wfe_Html_Util.generate_confirm;

570:
571: htp.title(wf_core.translate('WFE_CHECK_ALL_TITLE')||'('||lsys||')');
572: wfa_html.create_help_function('wf/links/evt.htm?'||'EVTSETUP');
573: fnd_document_management.get_open_dm_display_window;
574: Wfe_Html_Util.generate_confirm;
575:
576: htp.headClose;
577:
578: -- Page header

Line 608: wfe_html_util.Error;

604: exception
605: when OTHERS then
606: rollback;
607: wf_core.context('WF_SETUP', 'Check_All');
608: wfe_html_util.Error;
609: end Check_All;
610:
611: -- ###
612: -- Create_Queue is not used for now

Line 689: Wfe_Html_Util.gotoURL(p_url=>wfa_html.base_url||'/Wf_Setup.Check_All');

685:
686: commit;
687:
688: -- go back to check_all
689: Wfe_Html_Util.gotoURL(p_url=>wfa_html.base_url||'/Wf_Setup.Check_All');
690:
691: exception
692: when OTHERS then
693: rollback;

Line 696: wfe_html_util.Error;

692: when OTHERS then
693: rollback;
694: wf_core.context('WF_SETUP', 'Create_Queue', rawtohex(aguid),
695: qname, qtable);
696: wfe_html_util.Error;
697: end Create_Queue;
698:
699: --
700: -- List_Listener

Line 719: hTab wfe_html_util.headerTabType;

715:
716: aname varchar2(30);
717: lguid raw(16);
718:
719: hTab wfe_html_util.headerTabType;
720: dTab wfe_html_util.dataTabType;
721: i pls_integer;
722:
723: l_url varchar2(2000);

Line 720: dTab wfe_html_util.dataTabType;

716: aname varchar2(30);
717: lguid raw(16);
718:
719: hTab wfe_html_util.headerTabType;
720: dTab wfe_html_util.dataTabType;
721: i pls_integer;
722:
723: l_url varchar2(2000);
724:

Line 833: Wfe_Html_Util.generate_confirm;

829: htp.title(wf_core.translate('WFE_LIST_LISTENERS_TITLE'));
830: wfa_html.create_help_function('wf/links/def.htm?'||'DEFLSNR');
831: fnd_document_management.get_open_dm_display_window;
832:
833: Wfe_Html_Util.generate_confirm;
834:
835: htp.headClose;
836:
837: -- Page header

Line 845: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab);

841: TRUE);
842:
843: htp.br; -- add some space between header and table
844:
845: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab);
846:
847: htp.tableopen (calign=>'CENTER summary=""');
848: htp.tableRowOpen;
849: htp.p('');

Line 881: wfe_html_util.Error;

877:
878: exception
879: when OTHERS then
880: wf_core.context('WF_SETUP', 'List_Listener', rawtohex(l_aguid));
881: wfe_html_util.Error;
882: end List_Listener;
883:
884: --
885: -- Edit_Listener

Line 1101: wfe_html_util.Error;

1097: exception
1098: when OTHERS then
1099: rollback;
1100: wf_core.context('WF_SETUP', 'Edit_Listener', rawtohex(aguid));
1101: wfe_html_util.Error;
1102: end Edit_Listener;
1103:
1104: procedure Edit_Propagation(
1105: oqueue in varchar2,

Line 1346: wfe_html_util.Error;

1342: exception
1343: when OTHERS then
1344: rollback;
1345: wf_core.context('WF_SETUP', 'Edit_Propagation', oqueue, tosystem, url);
1346: wfe_html_util.Error;
1347: end Edit_Propagation;
1348:
1349:
1350: --

Line 1468: Wfe_Html_Util.gotoURL(h_url);

1464:
1465: commit;
1466:
1467: -- go back to the specified URL
1468: Wfe_Html_Util.gotoURL(h_url);
1469:
1470: exception
1471: when OTHERS then
1472: rollback;

Line 1475: wfe_html_util.Error;

1471: when OTHERS then
1472: rollback;
1473: wf_core.context('WF_SETUP', 'SubmitListener', h_name, h_rundate,
1474: '('||h_day||','||h_hour||','||h_minute||','||h_sec||')');
1475: wfe_html_util.Error;
1476: end SubmitListener;
1477:
1478:
1479: --

Line 1503: Wfe_Html_Util.gotoURL(h_url);

1499: if (h_action = 'DELETE') then
1500: Wf_Setup.DeletePropagation(h_qname, h_system);
1501:
1502: -- go back to the specified URL
1503: Wfe_Html_Util.gotoURL(h_url);
1504: return;
1505: end if;
1506:
1507: -- resolve duration

Line 1556: Wfe_Html_Util.gotoURL(h_url);

1552: latency=>l_latency
1553: );
1554:
1555: -- go back to the specified URL
1556: Wfe_Html_Util.gotoURL(h_url);
1557:
1558: exception
1559: when OTHERS then
1560: rollback;

Line 1563: wfe_html_util.Error;

1559: when OTHERS then
1560: rollback;
1561: wf_core.context('WF_SETUP', 'SubmitPropagation', h_qname, h_system,
1562: h_duration, h_interval, h_latency);
1563: wfe_html_util.Error;
1564: end SubmitPropagation;
1565:
1566:
1567: --

Line 1594: Wfe_Html_Util.gotoURL(h_url);

1590:
1591: DBMS_JOB.Remove(h_job);
1592:
1593: -- go back to the specified URL
1594: Wfe_Html_Util.gotoURL(h_url);
1595: exception
1596: when OTHERS then
1597: wf_core.context('WF_SETUP', 'DeleteJob', h_job, h_url);
1598: raise;