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: wfa_sec.header(background_only=>TRUE);
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: wfa_sec.header(background_only=>TRUE);
16:
9: error_stack varchar2(32000);
10: begin
11: htp.htmlOpen;
12: htp.headOpen;
13: htp.title(wf_core.translate('ERROR'));
14: htp.headClose;
15: wfa_sec.header(background_only=>TRUE);
16:
17: htp.header(1, wf_core.translate('ERROR'));
10: begin
11: htp.htmlOpen;
12: htp.headOpen;
13: htp.title(wf_core.translate('ERROR'));
14: htp.headClose;
15: wfa_sec.header(background_only=>TRUE);
16:
17: htp.header(1, wf_core.translate('ERROR'));
18: htp.br;
13: htp.title(wf_core.translate('ERROR'));
14: htp.headClose;
15: wfa_sec.header(background_only=>TRUE);
16:
17: htp.header(1, wf_core.translate('ERROR'));
18: htp.br;
19: --
20: wf_core.get_error(error_name, error_message, error_stack);
21: if (error_name is not null) then
14: htp.headClose;
15: wfa_sec.header(background_only=>TRUE);
16:
17: htp.header(1, wf_core.translate('ERROR'));
18: htp.br;
19: --
20: wf_core.get_error(error_name, error_message, error_stack);
21: if (error_name is not null) then
22: htp.p(error_message);
18: htp.br;
19: --
20: wf_core.get_error(error_name, error_message, error_stack);
21: if (error_name is not null) then
22: htp.p(error_message);
23: elsif (sqlcode <> 0) then
24: htp.p(sqlerrm);
25: end if;
26:
20: wf_core.get_error(error_name, error_message, error_stack);
21: if (error_name is not null) then
22: htp.p(error_message);
23: elsif (sqlcode <> 0) then
24: htp.p(sqlerrm);
25: end if;
26:
27: htp.br;
28: if (error_stack is not null) then
23: elsif (sqlcode <> 0) then
24: htp.p(sqlerrm);
25: end if;
26:
27: htp.br;
28: if (error_stack is not null) then
29: htp.p(wf_core.translate('WFMON_ERROR_STACK'));
30: htp.p(replace(error_stack,wf_core.newline,'
') || '
');
31: end if;
25: end if;
26:
27: htp.br;
28: if (error_stack is not null) then
29: htp.p(wf_core.translate('WFMON_ERROR_STACK'));
30: htp.p(replace(error_stack,wf_core.newline,'
') || '
');
31: end if;
32: --
33: htp.bodyClose;
26:
27: htp.br;
28: if (error_stack is not null) then
29: htp.p(wf_core.translate('WFMON_ERROR_STACK'));
30: htp.p(replace(error_stack,wf_core.newline,'
') || '
');
31: end if;
32: --
33: htp.bodyClose;
34: htp.htmlClose;
29: htp.p(wf_core.translate('WFMON_ERROR_STACK'));
30: htp.p(replace(error_stack,wf_core.newline,'
') || '
');
31: end if;
32: --
33: htp.bodyClose;
34: htp.htmlClose;
35: --
36: end Print_Error;
37:
30: htp.p(replace(error_stack,wf_core.newline,'
') || '
');
31: end if;
32: --
33: htp.bodyClose;
34: htp.htmlClose;
35: --
36: end Print_Error;
37:
38: --
58: template varchar2(4000);
59:
60: begin
61: -- always print the display field as null
62: htp.formHidden('h_fdocnames', '');
63:
64: -- Create hidden field and select list
65: template := htf.formHidden('h_fnames', name||'#LOOKUP#'||format)||
66: wf_core.newline||
80: cattributes=>'value='||i.lookup_code);
81: end if;
82: end loop;
83: template := template||wf_core.newline||htf.formSelectClose;
84: htp.tableData(template, 'left',cattributes=>'id=""');
85: exception
86: when others then
87: wf_core.context('Wf_initiate', 'GetLookup', name, value, format);
88: raise;
99: l_callback_URL varchar2(4000);
100: l_attach_URL varchar2(4000);
101: begin
102:
103: htp.formHidden('h_fnames', name||'#DOCUMENT#'||format);
104: htp.formHidden('h_fvalues', null);
105:
106: -- Set the destination field name for the document id
107: fnd_document_management.set_document_id_html (
100: l_attach_URL varchar2(4000);
101: begin
102:
103: htp.formHidden('h_fnames', name||'#DOCUMENT#'||format);
104: htp.formHidden('h_fvalues', null);
105:
106: -- Set the destination field name for the document id
107: fnd_document_management.set_document_id_html (
108: null,
121: TRUE,
122: l_attach_url);
123:
124: -- document field
125: htp.tableData(cvalue=>htf.formText(cname=>'h_fdocnames', csize=>32,
126: cmaxlength=>60,
127: cvalue=>dvalue,
128: cattributes=>'id="i_attr'||index_num||'"')
129: ||'   '||l_attach_URL,
157: len := 40;
158: end if;
159:
160: -- Draw field
161: htp.formHidden('h_fnames', name||'#'||type||'#'||format);
162: -- always print the display field as null
163: htp.formHidden('h_fdocnames', '');
164: --
165: -- commented out multi-line field for text
159:
160: -- Draw field
161: htp.formHidden('h_fnames', name||'#'||type||'#'||format);
162: -- always print the display field as null
163: htp.formHidden('h_fdocnames', '');
164: --
165: -- commented out multi-line field for text
166: --
167: -- if (len <= 80) then
165: -- commented out multi-line field for text
166: --
167: -- if (len <= 80) then
168: -- single line field
169: htp.tableData(
170: cvalue=>htf.formText(cname=>'h_fvalues', csize=>40,
171: cmaxlength=>len,
172: cvalue=>replace(dvalue,'&','&'),
173: cattributes=>'id="i_attr'||index_num||'"'),
174: calign=>'Left',
175: cattributes=>'id=""');
176: -- else
177: -- multi line field
178: -- htp.tableData(
179: -- cvalue=>htf.formTextareaOpen2(
180: -- cname=>'h_fvalues',
181: -- nrows=>2,
182: -- ncolumns=>40,
213:
214: --
215: begin
216: -- Draw field
217: htp.formHidden('h_fnames', name||'#ROLE#');
218: -- always print the display field as null
219: htp.formHidden('h_fvalues', null);
220:
221: -- add LOV here: Note:bottom is name of frame.
215: begin
216: -- Draw field
217: htp.formHidden('h_fnames', name||'#ROLE#');
218: -- always print the display field as null
219: htp.formHidden('h_fvalues', null);
220:
221: -- add LOV here: Note:bottom is name of frame.
222: -- Note: The REPLACE function replaces all the space characters with
223: -- the proper escape sequence.
233:
234: l_message := wf_core.translate ('WFPREF_LOV');
235:
236: -- print everything together so ther is no gap.
237: htp.tabledata(htf.formText(cname=>'h_fdocnames',
238: csize=>30,
239: cmaxlength=>240,
240: cvalue=>dvalue,
241: cattributes=>'id="i_attr'||seq||'"')||
378: end if;
379: --
380: -- Header and Page Title
381: --
382: htp.htmlOpen;
383: htp.headOpen;
384: htp.title(wf_core.translate('WFINIT_ITEM_TYPE_TITLE'));
385: wfa_html.create_help_function('wf/links/tes.htm?TESTING');
386: htp.headClose;
379: --
380: -- Header and Page Title
381: --
382: htp.htmlOpen;
383: htp.headOpen;
384: htp.title(wf_core.translate('WFINIT_ITEM_TYPE_TITLE'));
385: wfa_html.create_help_function('wf/links/tes.htm?TESTING');
386: htp.headClose;
387: wfa_sec.header(page_title=>wf_core.translate('WFINIT_ITEM_TYPE_TITLE'));
380: -- Header and Page Title
381: --
382: htp.htmlOpen;
383: htp.headOpen;
384: htp.title(wf_core.translate('WFINIT_ITEM_TYPE_TITLE'));
385: wfa_html.create_help_function('wf/links/tes.htm?TESTING');
386: htp.headClose;
387: wfa_sec.header(page_title=>wf_core.translate('WFINIT_ITEM_TYPE_TITLE'));
388: --
382: htp.htmlOpen;
383: htp.headOpen;
384: htp.title(wf_core.translate('WFINIT_ITEM_TYPE_TITLE'));
385: wfa_html.create_help_function('wf/links/tes.htm?TESTING');
386: htp.headClose;
387: wfa_sec.header(page_title=>wf_core.translate('WFINIT_ITEM_TYPE_TITLE'));
388: --
389: if (l_error_msg IS NOT NULL) THEN
390: htp.center(htf.bold(l_error_msg));
386: htp.headClose;
387: wfa_sec.header(page_title=>wf_core.translate('WFINIT_ITEM_TYPE_TITLE'));
388: --
389: if (l_error_msg IS NOT NULL) THEN
390: htp.center(htf.bold(l_error_msg));
391: return;
392: end if;
393: --
394: htp.tableOpen(cattributes=>'border=1 cellpadding=1 cellspacing=3 bgcolor=white align=center summary= "' || wf_core.translate('WFINIT_ITEM_TYPE_TITLE') || '"');
390: htp.center(htf.bold(l_error_msg));
391: return;
392: end if;
393: --
394: htp.tableOpen(cattributes=>'border=1 cellpadding=1 cellspacing=3 bgcolor=white align=center summary= "' || wf_core.translate('WFINIT_ITEM_TYPE_TITLE') || '"');
395: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
396: htp.tableHeader(cvalue=>''||
397: wf_core.translate('ITEMTYPE')||'',
398: calign=>'center',
391: return;
392: end if;
393: --
394: htp.tableOpen(cattributes=>'border=1 cellpadding=1 cellspacing=3 bgcolor=white align=center summary= "' || wf_core.translate('WFINIT_ITEM_TYPE_TITLE') || '"');
395: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
396: htp.tableHeader(cvalue=>''||
397: wf_core.translate('ITEMTYPE')||'',
398: calign=>'center',
399: cattributes=>'id="' || wf_core.translate('ITEMTYPE') || '"');
392: end if;
393: --
394: htp.tableOpen(cattributes=>'border=1 cellpadding=1 cellspacing=3 bgcolor=white align=center summary= "' || wf_core.translate('WFINIT_ITEM_TYPE_TITLE') || '"');
395: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
396: htp.tableHeader(cvalue=>''||
397: wf_core.translate('ITEMTYPE')||'',
398: calign=>'center',
399: cattributes=>'id="' || wf_core.translate('ITEMTYPE') || '"');
400: htp.tableHeader(cvalue=>''||
396: htp.tableHeader(cvalue=>''||
397: wf_core.translate('ITEMTYPE')||'',
398: calign=>'center',
399: cattributes=>'id="' || wf_core.translate('ITEMTYPE') || '"');
400: htp.tableHeader(cvalue=>''||
401: wf_core.translate('WFITD_INTERNAL_NAME')||'',
402: calign=>'center',
403: cattributes=>'id="' || wf_core.translate('WFITD_INTERNAL_NAME') || '"');
404: htp.tableHeader(cvalue=>''||
400: htp.tableHeader(cvalue=>''||
401: wf_core.translate('WFITD_INTERNAL_NAME')||'',
402: calign=>'center',
403: cattributes=>'id="' || wf_core.translate('WFITD_INTERNAL_NAME') || '"');
404: htp.tableHeader(cvalue=>''||
405: wf_core.translate('DESCRIPTION')||'',
406: calign=>'center',
407: cattributes=>'id="' || wf_core.translate('DESCRIPTION') || '"');
408: htp.tableRowClose;
404: htp.tableHeader(cvalue=>''||
405: wf_core.translate('DESCRIPTION')||'',
406: calign=>'center',
407: cattributes=>'id="' || wf_core.translate('DESCRIPTION') || '"');
408: htp.tableRowClose;
409: --
410: --
411:
412: for typerec in itemtypes loop
409: --
410: --
411:
412: for typerec in itemtypes loop
413: htp.tableRowOpen('bgcolor=#ffffcc');
414:
415: htp.tableData(cvalue=>htf.anchor(wfa_html.base_url
416: ||'/wf_initiate.Process?ItemType='||wfa_html.conv_special_url_chars(typerec.name),
417: ctext=>typerec.display_name),
411:
412: for typerec in itemtypes loop
413: htp.tableRowOpen('bgcolor=#ffffcc');
414:
415: htp.tableData(cvalue=>htf.anchor(wfa_html.base_url
416: ||'/wf_initiate.Process?ItemType='||wfa_html.conv_special_url_chars(typerec.name),
417: ctext=>typerec.display_name),
418: cattributes=>'headers="' || wf_core.translate('ITEMTYPE') || '"');
419:
416: ||'/wf_initiate.Process?ItemType='||wfa_html.conv_special_url_chars(typerec.name),
417: ctext=>typerec.display_name),
418: cattributes=>'headers="' || wf_core.translate('ITEMTYPE') || '"');
419:
420: htp.tableData(cvalue=>typerec.name, calign=>'left',
421: cattributes=>'headers="' || wf_core.translate('WFITD_INTERNAL_NAME') || '"');
422: htp.tableData(cvalue=>typerec.description, calign=>'left',
423: cattributes=>'headers="' || wf_core.translate('DESCRIPTION') || '"');
424: htp.tableRowClose;
418: cattributes=>'headers="' || wf_core.translate('ITEMTYPE') || '"');
419:
420: htp.tableData(cvalue=>typerec.name, calign=>'left',
421: cattributes=>'headers="' || wf_core.translate('WFITD_INTERNAL_NAME') || '"');
422: htp.tableData(cvalue=>typerec.description, calign=>'left',
423: cattributes=>'headers="' || wf_core.translate('DESCRIPTION') || '"');
424: htp.tableRowClose;
425: end loop;
426: --
420: htp.tableData(cvalue=>typerec.name, calign=>'left',
421: cattributes=>'headers="' || wf_core.translate('WFITD_INTERNAL_NAME') || '"');
422: htp.tableData(cvalue=>typerec.description, calign=>'left',
423: cattributes=>'headers="' || wf_core.translate('DESCRIPTION') || '"');
424: htp.tableRowClose;
425: end loop;
426: --
427: --
428: htp.tableClose;
424: htp.tableRowClose;
425: end loop;
426: --
427: --
428: htp.tableClose;
429: wfa_sec.Footer;
430: htp.htmlClose;
431: exception
432: when others then
426: --
427: --
428: htp.tableClose;
429: wfa_sec.Footer;
430: htp.htmlClose;
431: exception
432: when others then
433: if (ItemTypes%isopen) then
434: close ItemTypes; -- Close cursor just in case
502: end if;
503: --
504: -- Header and Page Title
505: --
506: htp.htmlOpen;
507: htp.headOpen;
508: htp.title(wf_core.translate('WFINIT_PROCESS_TITLE'));
509: wfa_html.create_help_function('wf/links/ini.htm?INIT_WF');
510:
503: --
504: -- Header and Page Title
505: --
506: htp.htmlOpen;
507: htp.headOpen;
508: htp.title(wf_core.translate('WFINIT_PROCESS_TITLE'));
509: wfa_html.create_help_function('wf/links/ini.htm?INIT_WF');
510:
511: -- Add the java script to the header to open the dm window for
504: -- Header and Page Title
505: --
506: htp.htmlOpen;
507: htp.headOpen;
508: htp.title(wf_core.translate('WFINIT_PROCESS_TITLE'));
509: wfa_html.create_help_function('wf/links/ini.htm?INIT_WF');
510:
511: -- Add the java script to the header to open the dm window for
512: -- any DM function that and any standard LOV
512: -- any DM function that and any standard LOV
513: fnd_document_management.get_open_dm_attach_window;
514: fnd_document_management.get_open_dm_display_window;
515:
516: htp.headClose;
517:
518: wfa_sec.Header(FALSE, '', wf_core.translate('WFINIT_PROCESS_TITLE')||' - '||Process.ItemType);
519: htp.br;
520:
515:
516: htp.headClose;
517:
518: wfa_sec.Header(FALSE, '', wf_core.translate('WFINIT_PROCESS_TITLE')||' - '||Process.ItemType);
519: htp.br;
520:
521: --
522: if (l_error_msg IS NOT NULL) THEN
523: htp.center(htf.bold(l_error_msg));
519: htp.br;
520:
521: --
522: if (l_error_msg IS NOT NULL) THEN
523: htp.center(htf.bold(l_error_msg));
524: return;
525: end if;
526: --
527: --
536:
537: --
538: -- wf_initiate.SubmitWorkflow is the url(procedure) to which the contents
539: -- of this form is sent
540: htp.formOpen(curl=>wfa_html.base_url||'/Wf_Initiate.SubmitWorkflow',
541: cmethod=>'Post', cattributes=>'NAME="WF_INITIATE"');
542:
543: --
544: -- Add dummy fields to start both array-type input fields.
546: -- the submit procedure will not be null even if there are no real
547: -- response fields. This would cause a pl/sql error, because array
548: -- parameters can't be defaulted.
549: --
550: htp.formHidden('h_fnames', 'Dummy_Name');
551: htp.formHidden('h_fvalues', 'Dummy_Value');
552: htp.formHidden('h_fdocnames', 'Dummy_Display_Name');
553: --
554: htp.formHidden('itemtype',Process.ItemType);
547: -- response fields. This would cause a pl/sql error, because array
548: -- parameters can't be defaulted.
549: --
550: htp.formHidden('h_fnames', 'Dummy_Name');
551: htp.formHidden('h_fvalues', 'Dummy_Value');
552: htp.formHidden('h_fdocnames', 'Dummy_Display_Name');
553: --
554: htp.formHidden('itemtype',Process.ItemType);
555: --
548: -- parameters can't be defaulted.
549: --
550: htp.formHidden('h_fnames', 'Dummy_Name');
551: htp.formHidden('h_fvalues', 'Dummy_Value');
552: htp.formHidden('h_fdocnames', 'Dummy_Display_Name');
553: --
554: htp.formHidden('itemtype',Process.ItemType);
555: --
556: --
550: htp.formHidden('h_fnames', 'Dummy_Name');
551: htp.formHidden('h_fvalues', 'Dummy_Value');
552: htp.formHidden('h_fdocnames', 'Dummy_Display_Name');
553: --
554: htp.formHidden('itemtype',Process.ItemType);
555: --
556: --
557: -- Item Key
558: --
555: --
556: --
557: -- Item Key
558: --
559: htp.tableOpen(cattributes=>'border=0 cellpadding=2 cellspacing=0 ALIGN=CENTER summary="' || wf_core.translate('WFINIT_PROCESS_TITLE') || '"');
560: htp.tableRowOpen;
561: htp.tableData(cvalue=>'', calign=>'right',
563: cattributes=>'id=""');
556: --
557: -- Item Key
558: --
559: htp.tableOpen(cattributes=>'border=0 cellpadding=2 cellspacing=0 ALIGN=CENTER summary="' || wf_core.translate('WFINIT_PROCESS_TITLE') || '"');
560: htp.tableRowOpen;
561: htp.tableData(cvalue=>'', calign=>'right',
563: cattributes=>'id=""');
564: htp.tableData(cvalue=>htf.formText(cname=>'itemkey',csize=>40,
557: -- Item Key
558: --
559: htp.tableOpen(cattributes=>'border=0 cellpadding=2 cellspacing=0 ALIGN=CENTER summary="' || wf_core.translate('WFINIT_PROCESS_TITLE') || '"');
560: htp.tableRowOpen;
561: htp.tableData(cvalue=>'562: wf_core.translate('ITEMKEY') || '', calign=>'right',
563: cattributes=>'id=""');
564: htp.tableData(cvalue=>htf.formText(cname=>'itemkey',csize=>40,
565: cmaxlength=>240,
560: htp.tableRowOpen;
561: htp.tableData(cvalue=>'', calign=>'right',
563: cattributes=>'id=""');
564: htp.tableData(cvalue=>htf.formText(cname=>'itemkey',csize=>40,
565: cmaxlength=>240,
566: cattributes=>'id="i_itemkey"'),
567: calign=>'Left',
568: cattributes=>'id=""');
565: cmaxlength=>240,
566: cattributes=>'id="i_itemkey"'),
567: calign=>'Left',
568: cattributes=>'id=""');
569: htp.tableRowClose;
570: --
571: -- User Key
572: --
573: htp.tableRowOpen;
569: htp.tableRowClose;
570: --
571: -- User Key
572: --
573: htp.tableRowOpen;
574: htp.tableData(cvalue=>'',
576: calign=>'right',
577: cattributes=>'id=""');
570: --
571: -- User Key
572: --
573: htp.tableRowOpen;
574: htp.tableData(cvalue=>'575: wf_core.translate('USER_ITEMKEY') || '',
576: calign=>'right',
577: cattributes=>'id=""');
578: htp.tableData(cvalue=>htf.formText(cname=>'userkey', csize=>40,
574: htp.tableData(cvalue=>'',
576: calign=>'right',
577: cattributes=>'id=""');
578: htp.tableData(cvalue=>htf.formText(cname=>'userkey', csize=>40,
579: cmaxlength=>240,
580: cattributes=>'id="i_user_itemkey"'),
581: calign=>'Left',
582: cattributes=>'id=""');
579: cmaxlength=>240,
580: cattributes=>'id="i_user_itemkey"'),
581: calign=>'Left',
582: cattributes=>'id=""');
583: htp.tableRowClose;
584: --
585: -- Process name
586: --
587: htp.tableRowOpen('bgcolor=#ffffcc');
583: htp.tableRowClose;
584: --
585: -- Process name
586: --
587: htp.tableRowOpen('bgcolor=#ffffcc');
588: htp.tableData(cvalue=>'', calign=>'right',
590: cattributes=>'id=""');
591: htp.p('
584: --
585: -- Process name
586: --
587: htp.tableRowOpen('bgcolor=#ffffcc');
588: htp.tableData(cvalue=>'589: wf_core.translate('PROCESS_NAME') || '', calign=>'right',
590: cattributes=>'id=""');
591: htp.p('
587: htp.tableRowOpen('bgcolor=#ffffcc');
588: htp.tableData(cvalue=>'', calign=>'right',
590: cattributes=>'id=""');
591: htp.p('
588: htp.tableData(cvalue=>'', calign=>'right',
590: cattributes=>'id=""');
591: htp.p('
591: htp.p('
594: -- add a null process which will invoke the selector function
595: htp.formSelectOption(cvalue=>wf_core.translate('WFA_NULL_PROCESS')
596: ,cattributes=>'value='||'""');
597: for wfp in RunnableProcesses loop
598: htp.formSelectOption(cvalue=>wfp.display_name
599: ,cattributes=>'value='||'"'||wfp.process_name||'"');
600: end loop;
601:
602: htp.formSelectClose;
598: htp.formSelectOption(cvalue=>wfp.display_name
599: ,cattributes=>'value='||'"'||wfp.process_name||'"');
600: end loop;
601:
602: htp.formSelectClose;
603: htp.p('
599: ,cattributes=>'value='||'"'||wfp.process_name||'"');
600: end loop;
601:
602: htp.formSelectClose;
603: htp.p('');
604: htp.tableRowClose;
605: htp.formHidden('owner', null);
606:
607: --
600: end loop;
601:
602: htp.formSelectClose;
603: htp.p('');
604: htp.tableRowClose;
605: htp.formHidden('owner', null);
606:
607: --
608: -- Process Owner
601:
602: htp.formSelectClose;
603: htp.p('');
604: htp.tableRowClose;
605: htp.formHidden('owner', null);
606:
607: --
608: -- Process Owner
609: --
619: '&p_display_key='||'Y'||
620: '&p_dest_display_field=top.opener.parent.document.WF_INITIATE.display_owner.value',
621: ' ', '%20')||''''||',500,500)';
622:
623: htp.tableRowOpen;
624: htp.tableData(cvalue=>'', calign=>'right',
627: cattributes=>'id=""');
620: '&p_dest_display_field=top.opener.parent.document.WF_INITIATE.display_owner.value',
621: ' ', '%20')||''''||',500,500)';
622:
623: htp.tableRowOpen;
624: htp.tableData(cvalue=>'625: wf_core.translate('PROCESS_OWNER') ||
626: '', calign=>'right',
627: cattributes=>'id=""');
628:
626: '', calign=>'right',
627: cattributes=>'id=""');
628:
629: -- print everything together so ther is no gap.
630: htp.tabledata(htf.formText(cname=>'display_owner', csize=>30,
631: cmaxlength=>240,
632: cvalue=>username,
633: cattributes=>'id="i_process_owner"')||
634: ''||
636: l_message||'" onmouseover="window.status='||''''||
637: l_message||''''||';return true">',
638: cattributes=>'id=""');
639:
640: htp.tableRowClose;
641:
642: for rec in itemattrs loop
643: respcnt := respcnt + 1;
644: htp.tableRowOpen('bgcolor=#ffffcc');
640: htp.tableRowClose;
641:
642: for rec in itemattrs loop
643: respcnt := respcnt + 1;
644: htp.tableRowOpen('bgcolor=#ffffcc');
645: htp.tableData(cvalue=>'',
647: calign=>'right',
648: cattributes=>'id=""');
641:
642: for rec in itemattrs loop
643: respcnt := respcnt + 1;
644: htp.tableRowOpen('bgcolor=#ffffcc');
645: htp.tableData(cvalue=>'646: rec.display_name || '',
647: calign=>'right',
648: cattributes=>'id=""');
649:
659: GetDocument(rec.name, rec.format, dvalue, to_char(respcnt) );
660: else
661: GetField(rec.name, rec.type, rec.format, dvalue, to_char(respcnt) );
662: end if;
663: htp.tableRowClose;
664: end loop;
665:
666: htp.tableClose;
667:
662: end if;
663: htp.tableRowClose;
664: end loop;
665:
666: htp.tableClose;
667:
668: htp.formHidden('h_counter', to_char(respcnt+1));
669:
670: htp.br;
664: end loop;
665:
666: htp.tableClose;
667:
668: htp.formHidden('h_counter', to_char(respcnt+1));
669:
670: htp.br;
671:
672:
666: htp.tableClose;
667:
668: htp.formHidden('h_counter', to_char(respcnt+1));
669:
670: htp.br;
671:
672:
673: --Submit Button
674:
671:
672:
673: --Submit Button
674:
675: htp.tableopen(calign=>'CENTER', cattributes=>'summary=""');
676: htp.tableRowOpen;
677:
678: l_url := 'javascript:document.WF_INITIATE.submit()';
679: l_icon := 'FNDJLFOK.gif';
672:
673: --Submit Button
674:
675: htp.tableopen(calign=>'CENTER', cattributes=>'summary=""');
676: htp.tableRowOpen;
677:
678: l_url := 'javascript:document.WF_INITIATE.submit()';
679: l_icon := 'FNDJLFOK.gif';
680: l_text := wf_core.translate ('WFMON_OK');
679: l_icon := 'FNDJLFOK.gif';
680: l_text := wf_core.translate ('WFMON_OK');
681: l_onmouseover := wf_core.translate ('WFMON_OK');
682:
683: htp.p('
683: htp.p('
690: l_icon := 'FNDJLFCN.gif';
691: l_text := wf_core.translate ('CANCEL');
692: l_onmouseover := wf_core.translate ('CANCEL');
693:
694: htp.p('
694: htp.p('
696: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
697:
698: htp.p('');
699:
700: htp.tableRowClose;
701:
702: htp.tableclose;
703:
704:
698: htp.p('');
699:
700: htp.tableRowClose;
701:
702: htp.tableclose;
703:
704:
705: htp.formClose;
706: --
701:
702: htp.tableclose;
703:
704:
705: htp.formClose;
706: --
707: -- NOTE: Do NOT create any more fields for h_names or h_values here. The
708: -- submit buttons created above must be the last values for these fields
709: -- to work around an MSIE bug that always sends the submit button last.
709: -- to work around an MSIE bug that always sends the submit button last.
710: -- Page footer
711: --
712: Wfa_Sec.Footer;
713: htp.htmlClose;
714: exception
715: when others then
716: if (itemattrs%isopen) then
717: close itemattrs; -- Close cursor just in case
883: wfa_html.validate_display_name (display_owner, t_owner);
884:
885: --
886: if (l_error_msg IS NOT NULL) THEN
887: htp.center(htf.bold(l_error_msg));
888: return;
889: end if;
890:
891: wf_engine.createprocess(itemtype => SubmitWorkflow.itemtype,