'||wf_core.translate('WFE_INITPARAMS')||'');
88: hTab(i).def_type := 'TITLE';
89: hTab(i).value := wf_core.translate('VALUE_RECOMMENDED');
90: hTab(i).attr := 'ALIGN=RIGHT id="t_value_rec"';
91:
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);
'||wf_core.translate('WFE_DBLINKS')||'');
157: hTab(i).def_type := 'TITLE';
158: hTab(i).value := wf_core.translate('STATUS');
159: hTab(i).attr := 'id="t_status"';
160:
161: htp.p('
'||wf_core.translate('WFE_DBLINKS')||'');
162: -- ### Database Links
163:
164: -- render table
165: Wfe_Html_Util.Simple_Table(hTab, dTab);
'||wf_core.translate('WFE_LOCAL_QUEUES')||'');
275: hTab(i).def_type := 'TITLE';
276: hTab(i).value := wf_core.translate('MESSAGE_WAIT');
277: hTab(i).attr := 'ALIGN=RIGHT id="t_message_wait"';
278:
279: htp.p('
'||wf_core.translate('WFE_LOCAL_QUEUES')||'');
280: -- ### Local Agents
281:
282: -- render table
283: Wfe_Html_Util.Simple_Table(hTab, dTab);
'||wf_core.translate('WFE_LISTENERS')||'');
372: hTab(i).def_type := 'TITLE';
373: hTab(i).value := wf_core.translate('ACTION');
374: hTab(i).attr := 'id="t_action"';
375:
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);
'||wf_core.translate('WFE_PROPAGATIONS')||'');
514: hTab(i).def_type := 'TITLE';
515: hTab(i).value := wf_core.translate('SCHEDULE');
516: hTab(i).attr := 'id="t_schedule"';
517:
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);
558: lguid := Wf_Setup.GetLocalSystemGUID;
559: lsys := Wf_Setup.GetLocalSystem;
560:
561: -- Render page
562: htp.htmlOpen;
563:
564: -- Set page title
565: htp.headOpen;
566:
561: -- Render page
562: htp.htmlOpen;
563:
564: -- Set page title
565: htp.headOpen;
566:
567: -- list does not get updated after edit, so we add the
568: -- following tag to force the reload of page.
569: htp.p('');
565: htp.headOpen;
566:
567: -- list does not get updated after edit, so we add the
568: -- following tag to force the reload of page.
569: htp.p('');
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;
567: -- list does not get updated after edit, so we add the
568: -- following tag to force the reload of page.
569: htp.p('');
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:
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
579: wfa_sec.Header(FALSE,
580: NULL,
580: NULL,
581: wf_core.translate('WFE_CHECK_ALL_TITLE')||'('||lsys||')',
582: TRUE);
583:
584: htp.br; -- add some space between header and table
585:
586: Wf_Setup.Check_InitParameters;
587: htp.br;
588:
583:
584: htp.br; -- add some space between header and table
585:
586: Wf_Setup.Check_InitParameters;
587: htp.br;
588:
589: Wf_Setup.Check_Dblinks(lguid);
590: htp.br;
591:
586: Wf_Setup.Check_InitParameters;
587: htp.br;
588:
589: Wf_Setup.Check_Dblinks(lguid);
590: htp.br;
591:
592: Wf_Setup.Check_Queues(lguid);
593: htp.br;
594:
589: Wf_Setup.Check_Dblinks(lguid);
590: htp.br;
591:
592: Wf_Setup.Check_Queues(lguid);
593: htp.br;
594:
595: Wf_Setup.Check_Listeners(lguid);
596: htp.br;
597:
592: Wf_Setup.Check_Queues(lguid);
593: htp.br;
594:
595: Wf_Setup.Check_Listeners(lguid);
596: htp.br;
597:
598: Wf_Setup.Check_Propagations(lguid);
599: htp.br;
600:
595: Wf_Setup.Check_Listeners(lguid);
596: htp.br;
597:
598: Wf_Setup.Check_Propagations(lguid);
599: htp.br;
600:
601: wfa_sec.Footer;
602: htp.htmlClose;
603:
598: Wf_Setup.Check_Propagations(lguid);
599: htp.br;
600:
601: wfa_sec.Footer;
602: htp.htmlClose;
603:
604: exception
605: when OTHERS then
606: rollback;
812: hTab(i).value := wf_core.translate('INTERVAL');
813: hTab(i).attr := 'id="t_interval"';
814:
815: -- Render page
816: htp.htmlOpen;
817:
818: -- Set page title
819: htp.headOpen;
820:
815: -- Render page
816: htp.htmlOpen;
817:
818: -- Set page title
819: htp.headOpen;
820:
821: -- List does not get updated after edit, so we add the
822: -- following tag to force the reload of page.
823: -- Note that we do not expire the first page where the cookie is set.
822: -- following tag to force the reload of page.
823: -- Note that we do not expire the first page where the cookie is set.
824: -- Setting cookie will refresh the page upon next visit.
825: if (aguid is null) then
826: htp.p('');
827: end if;
828:
829: htp.title(wf_core.translate('WFE_LIST_LISTENERS_TITLE'));
830: wfa_html.create_help_function('wf/links/def.htm?'||'DEFLSNR');
825: if (aguid is null) then
826: htp.p('');
827: end if;
828:
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;
831: fnd_document_management.get_open_dm_display_window;
832:
833: Wfe_Html_Util.generate_confirm;
834:
835: htp.headClose;
836:
837: -- Page header
838: wfa_sec.Header(FALSE,
839: NULL,
839: NULL,
840: wf_core.translate('WFE_LIST_LISTENERS_TITLE'),
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=""');
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('
844:
845: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab);
846:
847: htp.tableopen (calign=>'CENTER summary=""');
848: htp.tableRowOpen;
849: htp.p('
845: Wfe_Html_Util.Simple_Table(headerTab=>hTab, dataTab=>dTab);
846:
847: htp.tableopen (calign=>'CENTER summary=""');
848: htp.tableRowOpen;
849: htp.p('
857: wf_core.translate('ADD'),
858: wfa_html.image_loc,
859: null,
860: wf_core.translate('ADD'));
861: htp.p('
860: wf_core.translate('ADD'));
861: htp.p('
866: wf_core.translate('CANCEL'),
867: wfa_html.image_loc,
868: 'FNDJLFCN.gif',
869: wf_core.translate('CANCEL'));
870: htp.p('
868: 'FNDJLFCN.gif',
869: wf_core.translate('CANCEL'));
870: htp.p('');
871:
872: htp.tableRowClose;
873: htp.tableClose;
874:
875: wfa_sec.Footer;
876: htp.htmlClose;
869: wf_core.translate('CANCEL'));
870: htp.p('');
871:
872: htp.tableRowClose;
873: htp.tableClose;
874:
875: wfa_sec.Footer;
876: htp.htmlClose;
877:
872: htp.tableRowClose;
873: htp.tableClose;
874:
875: wfa_sec.Footer;
876: htp.htmlClose;
877:
878: exception
879: when OTHERS then
880: wf_core.context('WF_SETUP', 'List_Listener', rawtohex(l_aguid));
939: wf_core.raise('WFE_AGENT_NOTEXIST');
940: end;
941:
942: -- Render page
943: htp.htmlOpen;
944:
945: -- Set page title
946: htp.headOpen;
947:
942: -- Render page
943: htp.htmlOpen;
944:
945: -- Set page title
946: htp.headOpen;
947:
948: htp.title(wf_core.translate('WFE_EDIT_LISTENER_TITLE'));
949: wfa_html.create_help_function('wf/links/t_d.htm?'||'T_DEFLSNR');
950:
944:
945: -- Set page title
946: htp.headOpen;
947:
948: htp.title(wf_core.translate('WFE_EDIT_LISTENER_TITLE'));
949: wfa_html.create_help_function('wf/links/t_d.htm?'||'T_DEFLSNR');
950:
951: fnd_document_management.get_open_dm_display_window;
952:
949: wfa_html.create_help_function('wf/links/t_d.htm?'||'T_DEFLSNR');
950:
951: fnd_document_management.get_open_dm_display_window;
952:
953: htp.headClose;
954:
955: -- Page header
956: wfa_sec.Header(FALSE, null, wf_core.translate('WFE_EDIT_LISTENER_TITLE'),
957: TRUE);
957: TRUE);
958:
959: -- Form
960: l_url := 'Wf_Setup.SubmitListener';
961: htp.formOpen(curl=>owa_util.get_owa_service_path||l_url,
962: cmethod=>'Post',
963: cattributes=>'TARGET="_top" NAME="WF_LSNR_EDIT"');
964:
965: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary="' ||
961: htp.formOpen(curl=>owa_util.get_owa_service_path||l_url,
962: cmethod=>'Post',
963: cattributes=>'TARGET="_top" NAME="WF_LSNR_EDIT"');
964:
965: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary="' ||
966: WF_CORE.Translate('WFE_EDIT_LISTENER_TITLE') || '"');
967:
968: -- Agent Name (non-editable)
969: htp.tableRowOpen;
965: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 summary="' ||
966: WF_CORE.Translate('WFE_EDIT_LISTENER_TITLE') || '"');
967:
968: -- Agent Name (non-editable)
969: htp.tableRowOpen;
970: htp.tableData(cvalue=>wf_core.translate('AGENT'),
971: calign=>'right', cattributes=>'id=""');
972: htp.tableData(cvalue=>''||aname||'', calign=>'left',
973: cattributes=>'id=""');
966: WF_CORE.Translate('WFE_EDIT_LISTENER_TITLE') || '"');
967:
968: -- Agent Name (non-editable)
969: htp.tableRowOpen;
970: htp.tableData(cvalue=>wf_core.translate('AGENT'),
971: calign=>'right', cattributes=>'id=""');
972: htp.tableData(cvalue=>''||aname||'', calign=>'left',
973: cattributes=>'id=""');
974: if (jobnum < 0) then
968: -- Agent Name (non-editable)
969: htp.tableRowOpen;
970: htp.tableData(cvalue=>wf_core.translate('AGENT'),
971: calign=>'right', cattributes=>'id=""');
972: htp.tableData(cvalue=>''||aname||'', calign=>'left',
973: cattributes=>'id=""');
974: if (jobnum < 0) then
975: htp.formHidden('h_job', null);
976: else
971: calign=>'right', cattributes=>'id=""');
972: htp.tableData(cvalue=>''||aname||'', calign=>'left',
973: cattributes=>'id=""');
974: if (jobnum < 0) then
975: htp.formHidden('h_job', null);
976: else
977: htp.formHidden('h_job', to_char(jobnum));
978: end if;
979: htp.formHidden('h_name', aname);
973: cattributes=>'id=""');
974: if (jobnum < 0) then
975: htp.formHidden('h_job', null);
976: else
977: htp.formHidden('h_job', to_char(jobnum));
978: end if;
979: htp.formHidden('h_name', aname);
980: htp.tableRowClose;
981:
975: htp.formHidden('h_job', null);
976: else
977: htp.formHidden('h_job', to_char(jobnum));
978: end if;
979: htp.formHidden('h_name', aname);
980: htp.tableRowClose;
981:
982: -- Run Date (default sysdate when left blank)
983: htp.tableRowOpen;
976: else
977: htp.formHidden('h_job', to_char(jobnum));
978: end if;
979: htp.formHidden('h_name', aname);
980: htp.tableRowClose;
981:
982: -- Run Date (default sysdate when left blank)
983: htp.tableRowOpen;
984: htp.tableData(cvalue=>'
979: htp.formHidden('h_name', aname);
980: htp.tableRowClose;
981:
982: -- Run Date (default sysdate when left blank)
983: htp.tableRowOpen;
984: htp.tableData(cvalue=>'', calign=>'right', cattributes=>'id=""');
987:
980: htp.tableRowClose;
981:
982: -- Run Date (default sysdate when left blank)
983: htp.tableRowOpen;
984: htp.tableData(cvalue=>'985: wf_core.translate('RUN_DATE') ||
986: '', calign=>'right', cattributes=>'id=""');
987:
988: htp.tableData(cvalue=>htf.formText('h_rundate',19,
984: htp.tableData(cvalue=>'', calign=>'right', cattributes=>'id=""');
987:
988: htp.tableData(cvalue=>htf.formText('h_rundate',19,
989: cattributes=>'id="i_rundate"')||' ('||
990: wf_engine.date_format||')', calign=>'left',
991: cattributes=>'id=""');
992: htp.tableRowClose;
988: htp.tableData(cvalue=>htf.formText('h_rundate',19,
989: cattributes=>'id="i_rundate"')||' ('||
990: wf_engine.date_format||')', calign=>'left',
991: cattributes=>'id=""');
992: htp.tableRowClose;
993:
994: -- Interval (default 0 day 0 hour 15 min 0 sec)
995: htp.tableRowOpen;
996: htp.tableData(cvalue=>wf_core.translate('RUN_EVERY'),
991: cattributes=>'id=""');
992: htp.tableRowClose;
993:
994: -- Interval (default 0 day 0 hour 15 min 0 sec)
995: htp.tableRowOpen;
996: htp.tableData(cvalue=>wf_core.translate('RUN_EVERY'),
997: calign=>'right', cattributes=>'id=""');
998: htp.tableData(cvalue=>''
992: htp.tableRowClose;
993:
994: -- Interval (default 0 day 0 hour 15 min 0 sec)
995: htp.tableRowOpen;
996: htp.tableData(cvalue=>wf_core.translate('RUN_EVERY'),
997: calign=>'right', cattributes=>'id=""');
998: htp.tableData(cvalue=>''
1000: , calign=>'left', cattributes=>'id=""');
994: -- Interval (default 0 day 0 hour 15 min 0 sec)
995: htp.tableRowOpen;
996: htp.tableData(cvalue=>wf_core.translate('RUN_EVERY'),
997: calign=>'right', cattributes=>'id=""');
998: htp.tableData(cvalue=>'999: ||' '||wf_core.translate('DAYS') || ''
1000: , calign=>'left', cattributes=>'id=""');
1001: htp.tableRowClose;
1002: htp.tableRowOpen;
997: calign=>'right', cattributes=>'id=""');
998: htp.tableData(cvalue=>''
1000: , calign=>'left', cattributes=>'id=""');
1001: htp.tableRowClose;
1002: htp.tableRowOpen;
1003: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1004: htp.tableData(cvalue=>''
998: htp.tableData(cvalue=>''
1000: , calign=>'left', cattributes=>'id=""');
1001: htp.tableRowClose;
1002: htp.tableRowOpen;
1003: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1004: htp.tableData(cvalue=>''
1006: , calign=>'left', cattributes=>'id=""');
999: ||' '||wf_core.translate('DAYS') || ''
1000: , calign=>'left', cattributes=>'id=""');
1001: htp.tableRowClose;
1002: htp.tableRowOpen;
1003: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1004: htp.tableData(cvalue=>''
1006: , calign=>'left', cattributes=>'id=""');
1007: htp.tableRowClose;
1000: , calign=>'left', cattributes=>'id=""');
1001: htp.tableRowClose;
1002: htp.tableRowOpen;
1003: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1004: htp.tableData(cvalue=>'1005: ||' '||wf_core.translate('HOURS') || ''
1006: , calign=>'left', cattributes=>'id=""');
1007: htp.tableRowClose;
1008: htp.tableRowOpen;
1003: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1004: htp.tableData(cvalue=>''
1006: , calign=>'left', cattributes=>'id=""');
1007: htp.tableRowClose;
1008: htp.tableRowOpen;
1009: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1010: htp.tableData(cvalue=>''
1004: htp.tableData(cvalue=>''
1006: , calign=>'left', cattributes=>'id=""');
1007: htp.tableRowClose;
1008: htp.tableRowOpen;
1009: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1010: htp.tableData(cvalue=>''
1012: , calign=>'left', cattributes=>'id=""');
1005: ||' '||wf_core.translate('HOURS') || ''
1006: , calign=>'left', cattributes=>'id=""');
1007: htp.tableRowClose;
1008: htp.tableRowOpen;
1009: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1010: htp.tableData(cvalue=>''
1012: , calign=>'left', cattributes=>'id=""');
1013: htp.tableRowClose;
1006: , calign=>'left', cattributes=>'id=""');
1007: htp.tableRowClose;
1008: htp.tableRowOpen;
1009: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1010: htp.tableData(cvalue=>'1011: ||' '||wf_core.translate('MINUTES') || ''
1012: , calign=>'left', cattributes=>'id=""');
1013: htp.tableRowClose;
1014: htp.tableRowOpen;
1009: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1010: htp.tableData(cvalue=>''
1012: , calign=>'left', cattributes=>'id=""');
1013: htp.tableRowClose;
1014: htp.tableRowOpen;
1015: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1016: htp.tableData(cvalue=>''
1010: htp.tableData(cvalue=>''
1012: , calign=>'left', cattributes=>'id=""');
1013: htp.tableRowClose;
1014: htp.tableRowOpen;
1015: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1016: htp.tableData(cvalue=>''
1018: , calign=>'left', cattributes=>'id=""');
1011: ||' '||wf_core.translate('MINUTES') || ''
1012: , calign=>'left', cattributes=>'id=""');
1013: htp.tableRowClose;
1014: htp.tableRowOpen;
1015: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1016: htp.tableData(cvalue=>''
1018: , calign=>'left', cattributes=>'id=""');
1019: htp.tableRowClose;
1012: , calign=>'left', cattributes=>'id=""');
1013: htp.tableRowClose;
1014: htp.tableRowOpen;
1015: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1016: htp.tableData(cvalue=>'1017: ||' '||wf_core.translate('SECONDS') || ''
1018: , calign=>'left', cattributes=>'id=""');
1019: htp.tableRowClose;
1020:
1015: htp.tableData(cvalue=>' ', calign=>'right', cattributes=>'id=""');
1016: htp.tableData(cvalue=>''
1018: , calign=>'left', cattributes=>'id=""');
1019: htp.tableRowClose;
1020:
1021: htp.tableClose;
1022:
1023: -- go back to the specified URL
1017: ||' '||wf_core.translate('SECONDS') || ''
1018: , calign=>'left', cattributes=>'id=""');
1019: htp.tableRowClose;
1020:
1021: htp.tableClose;
1022:
1023: -- go back to the specified URL
1024: -- if url is null, go back to check_all
1025: if (url is null) then
1022:
1023: -- go back to the specified URL
1024: -- if url is null, go back to check_all
1025: if (url is null) then
1026: htp.formHidden('h_url',wfa_html.base_url||'/Wf_Setup.Check_All');
1027: else
1028: htp.formHidden('h_url',url);
1029: end if;
1030:
1024: -- if url is null, go back to check_all
1025: if (url is null) then
1026: htp.formHidden('h_url',wfa_html.base_url||'/Wf_Setup.Check_All');
1027: else
1028: htp.formHidden('h_url',url);
1029: end if;
1030:
1031: htp.formClose;
1032:
1027: else
1028: htp.formHidden('h_url',url);
1029: end if;
1030:
1031: htp.formClose;
1032:
1033: -- figure out the interval if we are editing
1034: htp.p('');
1061: htp.p(' document.WF_LSNR_EDIT.h_sec.value="'||
1062: substr(l_interval,l_curpos)||'"');
1063: end if;
1064:
1065: htp.p('');
1066:
1067: htp.p('');
1068:
1069: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
1063: end if;
1064:
1065: htp.p('');
1066:
1067: htp.p('');
1068:
1069: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
1070: htp.tableRowOpen;
1071:
1065: htp.p('');
1066:
1067: htp.p('');
1068:
1069: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
1070: htp.tableRowOpen;
1071:
1072: -- Submit button
1073: htp.p('
1066:
1067: htp.p('');
1068:
1069: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
1070: htp.tableRowOpen;
1071:
1072: -- Submit button
1073: htp.p('
1069: htp.tableopen (calign=>'CENTER', cattributes=>'summary=""');
1070: htp.tableRowOpen;
1071:
1072: -- Submit button
1073: htp.p('
1075: wf_core.translate ('SUBMIT'),
1076: wfa_html.image_loc,
1077: null,
1078: wf_core.translate ('SUBMIT'));
1079: htp.p('
1078: wf_core.translate ('SUBMIT'));
1079: htp.p('
1084: wf_core.translate('CANCEL'),
1085: wfa_html.image_loc,
1086: 'FNDJLFCN.gif',
1087: wf_core.translate('CANCEL'));
1088: htp.p('
1086: 'FNDJLFCN.gif',
1087: wf_core.translate('CANCEL'));
1088: htp.p('');
1089:
1090: htp.tableRowClose;
1091: htp.tableClose;
1092:
1093: wfa_sec.Footer;
1094: htp.htmlClose;
1087: wf_core.translate('CANCEL'));
1088: htp.p('');
1089:
1090: htp.tableRowClose;
1091: htp.tableClose;
1092:
1093: wfa_sec.Footer;
1094: htp.htmlClose;
1095:
1090: htp.tableRowClose;
1091: htp.tableClose;
1092:
1093: wfa_sec.Footer;
1094: htp.htmlClose;
1095:
1096: commit;
1097: exception
1098: when OTHERS then
1138: wf_core.raise('WF_NOTADMIN');
1139: end if;
1140:
1141: -- Render page
1142: htp.htmlOpen;
1143:
1144: -- Set page title
1145: htp.headOpen;
1146:
1141: -- Render page
1142: htp.htmlOpen;
1143:
1144: -- Set page title
1145: htp.headOpen;
1146:
1147: htp.title(wf_core.translate('WFE_EDIT_PROPAGATION_TITLE'));
1148: wfa_html.create_help_function('wf/links/t_e.htm?'||'T_EPPGN');
1149:
1143:
1144: -- Set page title
1145: htp.headOpen;
1146:
1147: htp.title(wf_core.translate('WFE_EDIT_PROPAGATION_TITLE'));
1148: wfa_html.create_help_function('wf/links/t_e.htm?'||'T_EPPGN');
1149:
1150: fnd_document_management.get_open_dm_display_window;
1151:
1165: window.alert(msg);
1166: }
1167: }');
1168: htp.p('');
1169: htp.p('');
1170:
1171: htp.p('');
1172:
1173:
1167: }');
1168: htp.p('');
1169: htp.p('');
1170:
1171: htp.p('');
1172:
1173:
1174: htp.headClose;
1175:
1170:
1171: htp.p('');
1172:
1173:
1174: htp.headClose;
1175:
1176: -- Page header
1177: wfa_sec.Header(FALSE, null, wf_core.translate('WFE_EDIT_PROPAGATION_TITLE'),
1178: TRUE);
1178: TRUE);
1179:
1180: -- Form
1181: l_url := 'Wf_Setup.SubmitPropagation';
1182: htp.formOpen(curl=>owa_util.get_owa_service_path||l_url,
1183: cmethod=>'Post',
1184: cattributes=>'TARGET="_top" NAME="WF_PPGN_EDIT"');
1185:
1186: htp.tableOpen(calign=>'CENTER',
1182: htp.formOpen(curl=>owa_util.get_owa_service_path||l_url,
1183: cmethod=>'Post',
1184: cattributes=>'TARGET="_top" NAME="WF_PPGN_EDIT"');
1185:
1186: htp.tableOpen(calign=>'CENTER',
1187: cattributes=>'border=0 summary="' ||
1188: WF_CORE.Translate('WFE_EDIT_PROPAGATION_TITLE') ||
1189: '"');
1190:
1188: WF_CORE.Translate('WFE_EDIT_PROPAGATION_TITLE') ||
1189: '"');
1190:
1191: -- Queue Name (non-editable)
1192: htp.tableRowOpen;
1193: htp.tableData(cvalue=>wf_core.translate('QUEUE'), calign=>'right',
1194: cattributes=>'id=""');
1195: htp.tableData(cvalue=>''||oqueue||'', calign=>'left',
1196: cattributes=>'id=""');
1189: '"');
1190:
1191: -- Queue Name (non-editable)
1192: htp.tableRowOpen;
1193: htp.tableData(cvalue=>wf_core.translate('QUEUE'), calign=>'right',
1194: cattributes=>'id=""');
1195: htp.tableData(cvalue=>''||oqueue||'', calign=>'left',
1196: cattributes=>'id=""');
1197: htp.formHidden('h_qname', oqueue);
1191: -- Queue Name (non-editable)
1192: htp.tableRowOpen;
1193: htp.tableData(cvalue=>wf_core.translate('QUEUE'), calign=>'right',
1194: cattributes=>'id=""');
1195: htp.tableData(cvalue=>''||oqueue||'', calign=>'left',
1196: cattributes=>'id=""');
1197: htp.formHidden('h_qname', oqueue);
1198: htp.tableRowClose;
1199:
1193: htp.tableData(cvalue=>wf_core.translate('QUEUE'), calign=>'right',
1194: cattributes=>'id=""');
1195: htp.tableData(cvalue=>''||oqueue||'', calign=>'left',
1196: cattributes=>'id=""');
1197: htp.formHidden('h_qname', oqueue);
1198: htp.tableRowClose;
1199:
1200: -- To Database Link Name (non-editable)
1201: htp.tableRowOpen;
1194: cattributes=>'id=""');
1195: htp.tableData(cvalue=>''||oqueue||'', calign=>'left',
1196: cattributes=>'id=""');
1197: htp.formHidden('h_qname', oqueue);
1198: htp.tableRowClose;
1199:
1200: -- To Database Link Name (non-editable)
1201: htp.tableRowOpen;
1202: htp.tableData(cvalue=>wf_core.translate('WFE_DBLINK'), calign=>'right',
1197: htp.formHidden('h_qname', oqueue);
1198: htp.tableRowClose;
1199:
1200: -- To Database Link Name (non-editable)
1201: htp.tableRowOpen;
1202: htp.tableData(cvalue=>wf_core.translate('WFE_DBLINK'), calign=>'right',
1203: cattributes=>'id=""');
1204: htp.tableData(cvalue=>''||nvl(tosystem,wf_core.translate('LOCAL_SYSTEM'))
1205: ||'', calign=>'left', cattributes=>'id=""');
1198: htp.tableRowClose;
1199:
1200: -- To Database Link Name (non-editable)
1201: htp.tableRowOpen;
1202: htp.tableData(cvalue=>wf_core.translate('WFE_DBLINK'), calign=>'right',
1203: cattributes=>'id=""');
1204: htp.tableData(cvalue=>''||nvl(tosystem,wf_core.translate('LOCAL_SYSTEM'))
1205: ||'', calign=>'left', cattributes=>'id=""');
1206: htp.formHidden('h_system', tosystem);
1200: -- To Database Link Name (non-editable)
1201: htp.tableRowOpen;
1202: htp.tableData(cvalue=>wf_core.translate('WFE_DBLINK'), calign=>'right',
1203: cattributes=>'id=""');
1204: htp.tableData(cvalue=>''||nvl(tosystem,wf_core.translate('LOCAL_SYSTEM'))
1205: ||'', calign=>'left', cattributes=>'id=""');
1206: htp.formHidden('h_system', tosystem);
1207: htp.tableRowClose;
1208:
1202: htp.tableData(cvalue=>wf_core.translate('WFE_DBLINK'), calign=>'right',
1203: cattributes=>'id=""');
1204: htp.tableData(cvalue=>''||nvl(tosystem,wf_core.translate('LOCAL_SYSTEM'))
1205: ||'', calign=>'left', cattributes=>'id=""');
1206: htp.formHidden('h_system', tosystem);
1207: htp.tableRowClose;
1208:
1209: -- Duration (default null)
1210: htp.tableRowOpen;
1203: cattributes=>'id=""');
1204: htp.tableData(cvalue=>''||nvl(tosystem,wf_core.translate('LOCAL_SYSTEM'))
1205: ||'', calign=>'left', cattributes=>'id=""');
1206: htp.formHidden('h_system', tosystem);
1207: htp.tableRowClose;
1208:
1209: -- Duration (default null)
1210: htp.tableRowOpen;
1211: htp.tableData(cvalue=>wf_core.translate('DURATION'), calign=>'right', cattributes=>'id=""');
1206: htp.formHidden('h_system', tosystem);
1207: htp.tableRowClose;
1208:
1209: -- Duration (default null)
1210: htp.tableRowOpen;
1211: htp.tableData(cvalue=>wf_core.translate('DURATION'), calign=>'right', cattributes=>'id=""');
1212: htp.tableData(cvalue=>'',
1214: calign=>'left');
1207: htp.tableRowClose;
1208:
1209: -- Duration (default null)
1210: htp.tableRowOpen;
1211: htp.tableData(cvalue=>wf_core.translate('DURATION'), calign=>'right', cattributes=>'id=""');
1212: htp.tableData(cvalue=>'',
1214: calign=>'left');
1215: htp.tableRowClose;
1208:
1209: -- Duration (default null)
1210: htp.tableRowOpen;
1211: htp.tableData(cvalue=>wf_core.translate('DURATION'), calign=>'right', cattributes=>'id=""');
1212: htp.tableData(cvalue=>'1213: ||wf_core.translate('SECONDS') || '',
1214: calign=>'left');
1215: htp.tableRowClose;
1216:
1211: htp.tableData(cvalue=>wf_core.translate('DURATION'), calign=>'right', cattributes=>'id=""');
1212: htp.tableData(cvalue=>'',
1214: calign=>'left');
1215: htp.tableRowClose;
1216:
1217: -- Interval (default null)
1218: htp.tableRowOpen;
1219: htp.tableData(cvalue=>wf_core.translate('RUN_EVERY'), calign=>'right',
1214: calign=>'left');
1215: htp.tableRowClose;
1216:
1217: -- Interval (default null)
1218: htp.tableRowOpen;
1219: htp.tableData(cvalue=>wf_core.translate('RUN_EVERY'), calign=>'right',
1220: cattributes=>'id=""');
1221: htp.tableData(cvalue=>'',
1215: htp.tableRowClose;
1216:
1217: -- Interval (default null)
1218: htp.tableRowOpen;
1219: htp.tableData(cvalue=>wf_core.translate('RUN_EVERY'), calign=>'right',
1220: cattributes=>'id=""');
1221: htp.tableData(cvalue=>'',
1223: calign=>'left', cattributes=>'id=""');
1217: -- Interval (default null)
1218: htp.tableRowOpen;
1219: htp.tableData(cvalue=>wf_core.translate('RUN_EVERY'), calign=>'right',
1220: cattributes=>'id=""');
1221: htp.tableData(cvalue=>'1222: ||wf_core.translate('SECONDS') || '',
1223: calign=>'left', cattributes=>'id=""');
1224: htp.tableRowClose;
1225:
1220: cattributes=>'id=""');
1221: htp.tableData(cvalue=>'',
1223: calign=>'left', cattributes=>'id=""');
1224: htp.tableRowClose;
1225:
1226: -- Latency (default 60sec)
1227: htp.tableRowOpen;
1228: htp.tableData(cvalue=>wf_core.translate('LATENCY'), calign=>'right',
1223: calign=>'left', cattributes=>'id=""');
1224: htp.tableRowClose;
1225:
1226: -- Latency (default 60sec)
1227: htp.tableRowOpen;
1228: htp.tableData(cvalue=>wf_core.translate('LATENCY'), calign=>'right',
1229: cattributes=>'id=""');
1230: htp.tableData(cvalue=>'',
1224: htp.tableRowClose;
1225:
1226: -- Latency (default 60sec)
1227: htp.tableRowOpen;
1228: htp.tableData(cvalue=>wf_core.translate('LATENCY'), calign=>'right',
1229: cattributes=>'id=""');
1230: htp.tableData(cvalue=>'',
1232: calign=>'left');
1226: -- Latency (default 60sec)
1227: htp.tableRowOpen;
1228: htp.tableData(cvalue=>wf_core.translate('LATENCY'), calign=>'right',
1229: cattributes=>'id=""');
1230: htp.tableData(cvalue=>'1231: ||wf_core.translate('SECONDS') || '',
1232: calign=>'left');
1233: htp.tableRowClose;
1234:
1229: cattributes=>'id=""');
1230: htp.tableData(cvalue=>'',
1232: calign=>'left');
1233: htp.tableRowClose;
1234:
1235: htp.tableClose;
1236:
1237: htp.formHidden('h_edit',edit);
1231: ||wf_core.translate('SECONDS') || '',
1232: calign=>'left');
1233: htp.tableRowClose;
1234:
1235: htp.tableClose;
1236:
1237: htp.formHidden('h_edit',edit);
1238:
1239: -- go back to the specified URL
1233: htp.tableRowClose;
1234:
1235: htp.tableClose;
1236:
1237: htp.formHidden('h_edit',edit);
1238:
1239: -- go back to the specified URL
1240: -- if url is null, go back to check_all
1241: if (url is null) then
1238:
1239: -- go back to the specified URL
1240: -- if url is null, go back to check_all
1241: if (url is null) then
1242: htp.formHidden('h_url',wfa_html.base_url||'/Wf_Setup.Check_All');
1243: else
1244: htp.formHidden('h_url',url);
1245: end if;
1246:
1240: -- if url is null, go back to check_all
1241: if (url is null) then
1242: htp.formHidden('h_url',wfa_html.base_url||'/Wf_Setup.Check_All');
1243: else
1244: htp.formHidden('h_url',url);
1245: end if;
1246:
1247: -- action: DELETE/NULL
1248: htp.formHidden('h_action');
1244: htp.formHidden('h_url',url);
1245: end if;
1246:
1247: -- action: DELETE/NULL
1248: htp.formHidden('h_action');
1249:
1250: htp.formClose;
1251:
1252: -- figure out the interval if we are editing
1246:
1247: -- action: DELETE/NULL
1248: htp.formHidden('h_action');
1249:
1250: htp.formClose;
1251:
1252: -- figure out the interval if we are editing
1253: if (edit = 'Y') then
1254: htp.p('');
1275: htp.p(' document.WF_PPGN_EDIT.h_latency.value="'
1276: ||to_char(ppgnr.latency)||'"');
1277: end loop;
1278:
1279: htp.p('');
1280: htp.p('');
1281:
1282: end if;
1283:
1276: ||to_char(ppgnr.latency)||'"');
1277: end loop;
1278:
1279: htp.p('');
1280: htp.p('');
1281:
1282: end if;
1283:
1284: htp.tableopen (calign=>'CENTER', cattributes=>'WIDTH=100% summary=""');
1280: htp.p('');
1281:
1282: end if;
1283:
1284: htp.tableopen (calign=>'CENTER', cattributes=>'WIDTH=100% summary=""');
1285: htp.tableRowOpen;
1286:
1287: -- Delete button
1288: htp.p('
1281:
1282: end if;
1283:
1284: htp.tableopen (calign=>'CENTER', cattributes=>'WIDTH=100% summary=""');
1285: htp.tableRowOpen;
1286:
1287: -- Delete button
1288: htp.p('
1284: htp.tableopen (calign=>'CENTER', cattributes=>'WIDTH=100% summary=""');
1285: htp.tableRowOpen;
1286:
1287: -- Delete button
1288: htp.p('
1286:
1287: -- Delete button
1288: htp.p('
1287: -- Delete button
1288: htp.p('
1288: htp.p('
1296: wf_core.translate ('DELETE'),
1297: wfa_html.image_loc,
1298: null,
1299: wf_core.translate ('DELETE'));
1300: htp.p('
1297: wfa_html.image_loc,
1298: null,
1299: wf_core.translate ('DELETE'));
1300: htp.p('
1298: null,
1299: wf_core.translate ('DELETE'));
1300: htp.p('');
1301: htp.tableRowClose;
1302: htp.tableClose;
1303: else
1304: htp.p(' ');
1305: end if;
1306: htp.p('');
1300: htp.p('');
1301: htp.tableRowClose;
1302: htp.tableClose;
1303: else
1304: htp.p(' ');
1305: end if;
1306: htp.p('');
1307:
1308: -- Submit button
1302: htp.tableClose;
1303: else
1304: htp.p(' ');
1305: end if;
1306: htp.p('');
1307:
1308: -- Submit button
1309: htp.p('
1305: end if;
1306: htp.p('
1307:
1308: -- Submit button
1309: htp.p('
1308: -- Submit button
1309: htp.p('
1309: htp.p('
1317: wf_core.translate ('SUBMIT'),
1318: wfa_html.image_loc,
1319: null,
1320: wf_core.translate ('SUBMIT'));
1321: htp.p('
1318: wfa_html.image_loc,
1319: null,
1320: wf_core.translate ('SUBMIT'));
1321: htp.p('
1325: wf_core.translate('CANCEL'),
1326: wfa_html.image_loc,
1327: 'FNDJLFCN.gif',
1328: wf_core.translate('CANCEL'));
1329: htp.p('
1326: wfa_html.image_loc,
1327: 'FNDJLFCN.gif',
1328: wf_core.translate('CANCEL'));
1329: htp.p('');
1330: htp.tableRowClose;
1331: htp.tableClose;
1332: htp.p('');
1333:
1334: htp.tableRowClose;
1327: 'FNDJLFCN.gif',
1328: wf_core.translate('CANCEL'));
1329: htp.p('');
1330: htp.tableRowClose;
1331: htp.tableClose;
1332: htp.p('');
1333:
1334: htp.tableRowClose;
1335: htp.tableClose;
1328: wf_core.translate('CANCEL'));
1329: htp.p('');
1330: htp.tableRowClose;
1331: htp.tableClose;
1332: htp.p('');
1333:
1334: htp.tableRowClose;
1335: htp.tableClose;
1336:
1330: htp.tableRowClose;
1331: htp.tableClose;
1332: htp.p('');
1333:
1334: htp.tableRowClose;
1335: htp.tableClose;
1336:
1337: wfa_sec.Footer;
1338: htp.htmlClose;
1331: htp.tableClose;
1332: htp.p('');
1333:
1334: htp.tableRowClose;
1335: htp.tableClose;
1336:
1337: wfa_sec.Footer;
1338: htp.htmlClose;
1339:
1334: htp.tableRowClose;
1335: htp.tableClose;
1336:
1337: wfa_sec.Footer;
1338: htp.htmlClose;
1339:
1340: commit;
1341:
1342: exception