7: error_name varchar2(30);
8: error_message varchar2(2000);
9: error_stack varchar2(32000);
10: begin
11: htp.htmlOpen;
12: htp.headOpen;
13: htp.title(wf_core.translate('ERROR'));
14: htp.headClose;
15:
8: error_message varchar2(2000);
9: error_stack varchar2(32000);
10: begin
11: htp.htmlOpen;
12: htp.headOpen;
13: htp.title(wf_core.translate('ERROR'));
14: htp.headClose;
15:
16: begin
9: error_stack varchar2(32000);
10: begin
11: htp.htmlOpen;
12: htp.headOpen;
13: htp.title(wf_core.translate('ERROR'));
14: htp.headClose;
15:
16: begin
17: wfa_sec.Header(background_only=>TRUE);
10: begin
11: htp.htmlOpen;
12: htp.headOpen;
13: htp.title(wf_core.translate('ERROR'));
14: htp.headClose;
15:
16: begin
17: wfa_sec.Header(background_only=>TRUE);
18: exception
16: begin
17: wfa_sec.Header(background_only=>TRUE);
18: exception
19: when others then
20: htp.bodyOpen;
21: end;
22:
23: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
24: wf_core.get_error(error_name, error_message, error_stack);
19: when others then
20: htp.bodyOpen;
21: end;
22:
23: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
24: wf_core.get_error(error_name, error_message, error_stack);
25:
26: if (error_name is not null) then
27: htp.p(error_message);
23: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
24: wf_core.get_error(error_name, error_message, error_stack);
25:
26: if (error_name is not null) then
27: htp.p(error_message);
28: else
29: htp.p(sqlerrm);
30: end if;
31:
25:
26: if (error_name is not null) then
27: htp.p(error_message);
28: else
29: htp.p(sqlerrm);
30: end if;
31:
32: htp.hr;
33: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
28: else
29: htp.p(sqlerrm);
30: end if;
31:
32: htp.hr;
33: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
34: htp.br;
35: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
36: replace(error_stack,wf_core.newline,'
'));
29: htp.p(sqlerrm);
30: end if;
31:
32: htp.hr;
33: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
34: htp.br;
35: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
36: replace(error_stack,wf_core.newline,'
'));
37:
30: end if;
31:
32: htp.hr;
33: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
34: htp.br;
35: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
36: replace(error_stack,wf_core.newline,'
'));
37:
38: wfa_sec.Footer;
31:
32: htp.hr;
33: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
34: htp.br;
35: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
36: replace(error_stack,wf_core.newline,'
'));
37:
38: wfa_sec.Footer;
39: htp.htmlClose;
35: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
36: replace(error_stack,wf_core.newline,'
'));
37:
38: wfa_sec.Footer;
39: htp.htmlClose;
40: end Error;
41:
42: -- ***********************************************
43: -- procedure DispPageDialog
111:
112: end if;
113:
114: -- HTML Open
115: htp.htmlOpen;
116:
117: -- HTML Header Open
118: htp.headOpen;
119:
114: -- HTML Open
115: htp.htmlOpen;
116:
117: -- HTML Header Open
118: htp.headOpen;
119:
120: htp.p('');
158:
159: -- HTML Head Close
160: htp.headClose;
153:
154: }');
155:
156: htp.p('//-->');
157: htp.p('');
158:
159: -- HTML Head Close
160: htp.headClose;
161:
156: htp.p('//-->');
157: htp.p('');
158:
159: -- HTML Head Close
160: htp.headClose;
161:
162: if (p_mode = 'CREATE') then
163:
164: l_function_syntax := 'javascript:applySubmit()';
209: p_subheader_text => ' ',
210: p_buttons => l_button_list);
211:
212: -- HTML Body Open
213: htp.p('');
214:
215: htp.centerOpen;
216:
217: -- Form Open
211:
212: -- HTML Body Open
213: htp.p('
214:
215: htp.centerOpen;
216:
217: -- Form Open
218: htp.formOpen(cattributes => 'NAME="new_pagename"',
219: curl => l_agent || 'icx_define_pages.savePage',
220: cmethod => 'POST',
221: cenctype => 'multipart/form-data'); --mputman reodered
222:
223: -- Draw the Dialog Title Bar
224: l_dialog.open_dialog;
225:
226: -- TABLE FOR THE FORM ELEMENTS
227: -- htp.tableRowOpen;
228: -- wwutl_htp.tableDataOpen;
229: htp.tableOpen(cattributes=>'cellspacing="0" cellpadding="0" border="0" width="80%"');
230:
231: if (p_mode = 'COPY') then
224: l_dialog.open_dialog;
225:
226: -- TABLE FOR THE FORM ELEMENTS
227: -- htp.tableRowOpen;
228: -- wwutl_htp.tableDataOpen;
229: htp.tableOpen(cattributes=>'cellspacing="0" cellpadding="0" border="0" width="80%"');
230:
231: if (p_mode = 'COPY') then
232:
225:
226: -- TABLE FOR THE FORM ELEMENTS
227: -- htp.tableRowOpen;
228: -- wwutl_htp.tableDataOpen;
229: htp.tableOpen(cattributes=>'cellspacing="0" cellpadding="0" border="0" width="80%"');
230:
231: if (p_mode = 'COPY') then
232:
233: htp.p('
229: htp.tableOpen(cattributes=>'cellspacing="0" cellpadding="0" border="0" width="80%"');
230:
231: if (p_mode = 'COPY') then
232:
233: htp.p(' ');'||wf_core.translate('COPY')||' ');
234:
235: htp.p('');
236:
237: htp.p('
259:
260: htp.p('
256: htp.formSelectClose;
257:
258: htp.p('
263:
264: -- Old Page Name
265: if (p_mode IN ('RENAME', 'DELETE')) then
266:
267: htp.tableRowOpen;
268: htp.tableData(cvalue=>wf_core.translate('PAGE_NAME'),
269: cattributes => 'VALIGN="MIDDLE"');
270:
271: htp.tableData(''||l_page_name||'', cattributes => 'VALIGN="MIDDLE"');
264: -- Old Page Name
265: if (p_mode IN ('RENAME', 'DELETE')) then
266:
267: htp.tableRowOpen;
268: htp.tableData(cvalue=>wf_core.translate('PAGE_NAME'),
269: cattributes => 'VALIGN="MIDDLE"');
270:
271: htp.tableData(''||l_page_name||'', cattributes => 'VALIGN="MIDDLE"');
272: htp.tableRowClose;
267: htp.tableRowOpen;
268: htp.tableData(cvalue=>wf_core.translate('PAGE_NAME'),
269: cattributes => 'VALIGN="MIDDLE"');
270:
271: htp.tableData(''||l_page_name||'', cattributes => 'VALIGN="MIDDLE"');
272: htp.tableRowClose;
273: htp.formHidden('p_page_id', p_page_id);
274:
275: end if;
268: htp.tableData(cvalue=>wf_core.translate('PAGE_NAME'),
269: cattributes => 'VALIGN="MIDDLE"');
270:
271: htp.tableData(''||l_page_name||'', cattributes => 'VALIGN="MIDDLE"');
272: htp.tableRowClose;
273: htp.formHidden('p_page_id', p_page_id);
274:
275: end if;
276:
269: cattributes => 'VALIGN="MIDDLE"');
270:
271: htp.tableData(''||l_page_name||'', cattributes => 'VALIGN="MIDDLE"');
272: htp.tableRowClose;
273: htp.formHidden('p_page_id', p_page_id);
274:
275: end if;
276:
277: if (p_mode IN ('COPY', 'CREATE', 'RENAME')) THEN
277: if (p_mode IN ('COPY', 'CREATE', 'RENAME')) THEN
278:
279:
280:
281: htp.tableRowOpen;
282: htp.tableData(wf_core.translate('NEW_PAGE_NAME'),
283: cattributes => 'VALIGN="MIDDLE"');
284:
285: htp.tableData(htf.fontOpen(cface => 'arial,helvetica')
278:
279:
280:
281: htp.tableRowOpen;
282: htp.tableData(wf_core.translate('NEW_PAGE_NAME'),
283: cattributes => 'VALIGN="MIDDLE"');
284:
285: htp.tableData(htf.fontOpen(cface => 'arial,helvetica')
286: || htf.formText(cname => 'p_page_name', csize => '20', cmaxlength => '30',
281: htp.tableRowOpen;
282: htp.tableData(wf_core.translate('NEW_PAGE_NAME'),
283: cattributes => 'VALIGN="MIDDLE"');
284:
285: htp.tableData(htf.fontOpen(cface => 'arial,helvetica')
286: || htf.formText(cname => 'p_page_name', csize => '20', cmaxlength => '30',
287: cattributes => 'VALUE="'||l_page_name||'"')|| --mputman removed onClick
288: htf.fontClose, cattributes => 'VALIGN="MIDDLE"');
289: htp.tableRowClose;
285: htp.tableData(htf.fontOpen(cface => 'arial,helvetica')
286: || htf.formText(cname => 'p_page_name', csize => '20', cmaxlength => '30',
287: cattributes => 'VALUE="'||l_page_name||'"')|| --mputman removed onClick
288: htf.fontClose, cattributes => 'VALIGN="MIDDLE"');
289: htp.tableRowClose;
290: htp.formHidden('p_mode',p_mode);
291:
292: end if;
293:
286: || htf.formText(cname => 'p_page_name', csize => '20', cmaxlength => '30',
287: cattributes => 'VALUE="'||l_page_name||'"')|| --mputman removed onClick
288: htf.fontClose, cattributes => 'VALIGN="MIDDLE"');
289: htp.tableRowClose;
290: htp.formHidden('p_mode',p_mode);
291:
292: end if;
293:
294:
292: end if;
293:
294:
295: -- CLOSE THE TABLE FOR THE FORM ELEMENTS
296: htp.tableClose;
297:
298: -- Draw the dialog footer
299: l_dialog.close_dialog;
300:
298: -- Draw the dialog footer
299: l_dialog.close_dialog;
300:
301: -- CLOSE FORM
302: htp.formClose;
303:
304: htp.centerClose;
305:
306: -- Close Body
300:
301: -- CLOSE FORM
302: htp.formClose;
303:
304: htp.centerClose;
305:
306: -- Close Body
307: htp.bodyClose;
308:
303:
304: htp.centerClose;
305:
306: -- Close Body
307: htp.bodyClose;
308:
309: -- Close HTML
310: htp.htmlClose;
311:
306: -- Close Body
307: htp.bodyClose;
308:
309: -- Close HTML
310: htp.htmlClose;
311:
312: exception
313: when others then
314: rollback;
448: if (p_mode in ('CREATE', 'COPY', 'RENAME') ) then
449: -- removed browser specific code and added parent reload and window close
450: -- mputman 1936581
451: htp.p('');
455:
456: end if;
449: -- removed browser specific code and added parent reload and window close
450: -- mputman 1936581
451: htp.p('');
455:
456: end if;
457: exception
450: -- mputman 1936581
451: htp.p('');
455:
456: end if;
457: exception
458: when others then
512: else
513: l_history := 'history.go(0);';
514: end if;
515:
516: htp.p('');
517: htp.p('
513: l_history := 'history.go(0);';
514: end if;
515:
516: htp.p('');
517: htp.p('');
518: htp.p('
514: end if;
515:
516: htp.p('');
517: htp.p('
515:
516: htp.p('');
517: htp.p('
682: top.location.href = "'||wfa_html.base_url ||'/oraclemypage.home";
683: }');
684:
685: htp.p('//-->');
686: htp.p('');
687:
688: htp.p('
684:
685: htp.p('//-->');
686: htp.p('');
687:
688: htp.p('');
689: htp.formOpen('javascript:saveOrder()','POST','','','NAME="PageList"');
690:
691: htp.p('
'); Line 691: htp.p('
750: htp.p(' 751: 752: htp.p(' '); | 753: 754: htp.p(' 755: 756: htp.formClose; 757: 758: -- add real form that does the posting Line 756: htp.formClose; | ||||||||||||||||||||||||||||||||||||||||||||||
'); 753: 754: htp.p(' |
755:
756: htp.formClose;
757:
758: -- add real form that does the posting
759: htp.formOpen('icx_define_pages.OrderPages','POST','','','NAME="updatePageList"');
760: htp.formHidden(cname=>'pages');
761: htp.formHidden(cname=>'oldpages',cvalue=>old_plist);
762: htp.formHidden(cname=>'calledfrom');
763: htp.formClose;
756: htp.formClose;
757:
758: -- add real form that does the posting
759: htp.formOpen('icx_define_pages.OrderPages','POST','','','NAME="updatePageList"');
760: htp.formHidden(cname=>'pages');
761: htp.formHidden(cname=>'oldpages',cvalue=>old_plist);
762: htp.formHidden(cname=>'calledfrom');
763: htp.formClose;
764:
757:
758: -- add real form that does the posting
759: htp.formOpen('icx_define_pages.OrderPages','POST','','','NAME="updatePageList"');
760: htp.formHidden(cname=>'pages');
761: htp.formHidden(cname=>'oldpages',cvalue=>old_plist);
762: htp.formHidden(cname=>'calledfrom');
763: htp.formClose;
764:
765: -- finally add buttons for cabo page.
758: -- add real form that does the posting
759: htp.formOpen('icx_define_pages.OrderPages','POST','','','NAME="updatePageList"');
760: htp.formHidden(cname=>'pages');
761: htp.formHidden(cname=>'oldpages',cvalue=>old_plist);
762: htp.formHidden(cname=>'calledfrom');
763: htp.formClose;
764:
765: -- finally add buttons for cabo page.
766: -- these cause javascript error if procedure not called from
759: htp.formOpen('icx_define_pages.OrderPages','POST','','','NAME="updatePageList"');
760: htp.formHidden(cname=>'pages');
761: htp.formHidden(cname=>'oldpages',cvalue=>old_plist);
762: htp.formHidden(cname=>'calledfrom');
763: htp.formClose;
764:
765: -- finally add buttons for cabo page.
766: -- these cause javascript error if procedure not called from
767: -- cabo frame.
823: l_actions(6).gap := 'b_narrow_gap';
824:
825: icx_cabo.buttons(l_actions);
826:
827: htp.bodyClose;
828: htp.htmlClose;
829:
830: exception
831: when others then
824:
825: icx_cabo.buttons(l_actions);
826:
827: htp.bodyClose;
828: htp.htmlClose;
829:
830: exception
831: when others then
832: htp.p(SQLERRM);
828: htp.htmlClose;
829:
830: exception
831: when others then
832: htp.p(SQLERRM);
833:
834: end PageList;
835:
836:
848: -- Check session and current user
849: wfa_sec.GetSession(username);
850: username := upper(username);
851:
852: htp.headopen;
853: htp.p('');
853: htp.p('');
858: htp.headclose;
859:
860: l_toolbar.title := wf_core.translate ('MAINTAIN_PAGES');
861: l_toolbar.help_url := 'javascript:top.help_window()';
854:
855: icx_admin_sig.help_win_script('PAGEADM', null, 'FND');
856:
857: htp.p('');
858: htp.headclose;
859:
860: l_toolbar.title := wf_core.translate ('MAINTAIN_PAGES');
861: l_toolbar.help_url := 'javascript:top.help_window()';
862: fnd_message.set_name('ICX','ICX_HELP');