21: error_name varchar2(30);
22: error_message varchar2(2000);
23: error_stack varchar2(32000);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
22: error_message varchar2(2000);
23: error_stack varchar2(32000);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
30: begin
23: error_stack varchar2(32000);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
30: begin
31: wfa_sec.Header(background_only=>TRUE);
24: begin
25: htp.htmlOpen;
26: htp.headOpen;
27: htp.title(wf_core.translate('ERROR'));
28: htp.headClose;
29:
30: begin
31: wfa_sec.Header(background_only=>TRUE);
32: exception
30: begin
31: wfa_sec.Header(background_only=>TRUE);
32: exception
33: when others then
34: htp.bodyOpen;
35: end;
36:
37: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
38:
33: when others then
34: htp.bodyOpen;
35: end;
36:
37: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
38:
39: wf_core.get_error(error_name, error_message, error_stack);
40:
41: -- Bug5161758 - XSS
42: error_message := wf_core.substitutespecialchars(error_message);
43: error_stack := wf_core.substitutespecialchars(error_stack);
44:
45: if (error_name is not null) then
46: htp.p(error_message);
47: else
48: htp.p(sqlerrm);
49: end if;
50:
44:
45: if (error_name is not null) then
46: htp.p(error_message);
47: else
48: htp.p(sqlerrm);
49: end if;
50:
51: htp.hr;
52: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
47: else
48: htp.p(sqlerrm);
49: end if;
50:
51: htp.hr;
52: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
53: htp.br;
54: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
55: replace(error_stack,wf_core.newline,'
'));
48: htp.p(sqlerrm);
49: end if;
50:
51: htp.hr;
52: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
53: htp.br;
54: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
55: replace(error_stack,wf_core.newline,'
'));
56:
49: end if;
50:
51: htp.hr;
52: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
53: htp.br;
54: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
55: replace(error_stack,wf_core.newline,'
'));
56:
57: wfa_sec.Footer;
50:
51: htp.hr;
52: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
53: htp.br;
54: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
55: replace(error_stack,wf_core.newline,'
'));
56:
57: wfa_sec.Footer;
58: htp.htmlClose;
54: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
55: replace(error_stack,wf_core.newline,'
'));
56:
57: wfa_sec.Footer;
58: htp.htmlClose;
59: end Error;
60:
61: /*===========================================================================
62:
513:
514: /*
515: ** Close the summary/details frameset
516: */
517: htp.p ('');
518:
519: EXCEPTION
520: WHEN OTHERS THEN
521: Wf_Core.Context('fnd_document_management',
2277: }'
2278: );
2279:
2280:
2281: htp.p(' ');
2282: htp.p('');
2283:
2284: EXCEPTION
2285: WHEN OTHERS THEN
2278: );
2279:
2280:
2281: htp.p(' ');
2282: htp.p('');
2283:
2284: EXCEPTION
2285: WHEN OTHERS THEN
2286: Wf_Core.Context('fnd_document_management',
2331:
2332: }'
2333: );
2334:
2335: htp.p(' ');
2336: htp.p('');
2337:
2338: EXCEPTION
2339: WHEN OTHERS THEN
2332: }'
2333: );
2334:
2335: htp.p(' ');
2336: htp.p('');
2337:
2338: EXCEPTION
2339: WHEN OTHERS THEN
2340: Wf_Core.Context('fnd_document_management',
'); | '); | '); 2582: 2583: /* Line 2581: htp.p('
2577: ** Put some space on the side 2582: 2583: /* 2584: ** inner table to define toolbar 2585: */ Line 2586: htp.p('
2748: 2749: /* 2750: ** Close the toolbar table data Line 2747: htp.p('
2743: /* 2747: htp.p(' |
2748:
2749: /*
2750: ** Close the toolbar table data
2751: */
2752: htp.p('');
2753:
2754: /*
2755: ** Create the logo and close the toolbar and logo table
2756: */
2753:
2754: /*
2755: ** Create the logo and close the toolbar and logo table
2756: */
2757: htp.p('
3013:
3014: -- If no document nodes are available then show an error message
3015: IF (l_dm_node_id IS NULL) THEN
3016:
3017: htp.htmlOpen;
3018: htp.headOpen;
3019: htp.title(wf_core.translate('WF_WORKFLOW_TITLE'));
3020: htp.headClose;
3021:
3014: -- If no document nodes are available then show an error message
3015: IF (l_dm_node_id IS NULL) THEN
3016:
3017: htp.htmlOpen;
3018: htp.headOpen;
3019: htp.title(wf_core.translate('WF_WORKFLOW_TITLE'));
3020: htp.headClose;
3021:
3022: htp.p ('
3015: IF (l_dm_node_id IS NULL) THEN
3016:
3017: htp.htmlOpen;
3018: htp.headOpen;
3019: htp.title(wf_core.translate('WF_WORKFLOW_TITLE'));
3020: htp.headClose;
3021:
3022: htp.p ('
3016:
3017: htp.htmlOpen;
3018: htp.headOpen;
3019: htp.title(wf_core.translate('WF_WORKFLOW_TITLE'));
3020: htp.headClose;
3021:
3022: htp.p ('
3018: htp.headOpen;
3019: htp.title(wf_core.translate('WF_WORKFLOW_TITLE'));
3020: htp.headClose;
3021:
3022: htp.p ('');
3023: htp.tableOpen(cattributes=>'summary=""');
3024: htp.tableRowOpen;
3025:
3026: htp.tabledata('
3019: htp.title(wf_core.translate('WF_WORKFLOW_TITLE'));
3020: htp.headClose;
3021:
3022: htp.p ('
3020: htp.headClose;
3021:
3022: htp.p ('
3024: htp.tableRowOpen;
3025:
3026: htp.tabledata('');
3028: htp.tabledata(''||wf_core.translate('WFDM_NO_NODES')||'');
3029:
3030: htp.tableRowClose;
3031: htp.tableClose;
3032: htp.bodyClose;
3026: htp.tabledata('');
3028: htp.tabledata(''||wf_core.translate('WFDM_NO_NODES')||'');
3029:
3030: htp.tableRowClose;
3031: htp.tableClose;
3032: htp.bodyClose;
3033: htp.htmlclose;
3034: return;
3027: WF_CORE.Translate('WFDM_NO_NODES') || '">');
3028: htp.tabledata(''||wf_core.translate('WFDM_NO_NODES')||'');
3029:
3030: htp.tableRowClose;
3031: htp.tableClose;
3032: htp.bodyClose;
3033: htp.htmlclose;
3034: return;
3035:
3028: htp.tabledata(''||wf_core.translate('WFDM_NO_NODES')||'');
3029:
3030: htp.tableRowClose;
3031: htp.tableClose;
3032: htp.bodyClose;
3033: htp.htmlclose;
3034: return;
3035:
3036: END IF;
3029:
3030: htp.tableRowClose;
3031: htp.tableClose;
3032: htp.bodyClose;
3033: htp.htmlclose;
3034: return;
3035:
3036: END IF;
3037:
3041: -- for Apps we need to use encode_url instead
3042: l_callback_function := wfa_html.encode_url(callback_function);
3043: l_dm_node_name := SUBSTR (l_dm_node_name , 1, 30);
3044:
3045: htp.htmlOpen;
3046: htp.headOpen;
3047: htp.title(l_dm_node_name);
3048: htp.headClose;
3049:
3042: l_callback_function := wfa_html.encode_url(callback_function);
3043: l_dm_node_name := SUBSTR (l_dm_node_name , 1, 30);
3044:
3045: htp.htmlOpen;
3046: htp.headOpen;
3047: htp.title(l_dm_node_name);
3048: htp.headClose;
3049:
3050: /*
3043: l_dm_node_name := SUBSTR (l_dm_node_name , 1, 30);
3044:
3045: htp.htmlOpen;
3046: htp.headOpen;
3047: htp.title(l_dm_node_name);
3048: htp.headClose;
3049:
3050: /*
3051: ** Create the top header frameset and the bottom summary/detail frameset
3044:
3045: htp.htmlOpen;
3046: htp.headOpen;
3047: htp.title(l_dm_node_name);
3048: htp.headClose;
3049:
3050: /*
3051: ** Create the top header frameset and the bottom summary/detail frameset
3052: */
3101:
3102: /*
3103: ** Close the summary/details frameset
3104: */
3105: htp.p ('');
3106:
3107: EXCEPTION
3108: WHEN OTHERS THEN
3109: Wf_Core.Context('fnd_document_management',
'); | '); | '); 3169: 3170: /* Line 3168: htp.p('
3164: ** Put some space on the side 3169: 3170: /* 3171: ** inner table to define toolbar 3172: */ Line 3173: htp.p('
3300: 3301: /* 3302: ** Close the toolbar table data Line 3299: htp.p('
3295: /* 3299: htp.p(' |
3300:
3301: /*
3302: ** Close the toolbar table data
3303: */
3304: htp.p('');
3305:
3306: /*
3307: ** Create the logo and close the toolbar and logo table
3308: */
3305:
3306: /*
3307: ** Create the logo and close the toolbar and logo table
3308: */
3309: htp.p('
3604:
3605: end if;
3606:
3607: -- Set page title
3608: htp.htmlOpen;
3609: htp.headOpen;
3610: htp.p('
3611: htp.title(wf_core.translate('WFDM_NODES_TITLE'));
3612: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
3605: end if;
3606:
3607: -- Set page title
3608: htp.htmlOpen;
3609: htp.headOpen;
3610: htp.p('
3611: htp.title(wf_core.translate('WFDM_NODES_TITLE'));
3612: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
3613: htp.headClose;
3606:
3607: -- Set page title
3608: htp.htmlOpen;
3609: htp.headOpen;
3610: htp.p('
3611: htp.title(wf_core.translate('WFDM_NODES_TITLE'));
3612: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
3613: htp.headClose;
3614: wfa_sec.Header(FALSE, '',wf_core.translate('WFDM_NODES_TITLE'), FALSE);
3607: -- Set page title
3608: htp.htmlOpen;
3609: htp.headOpen;
3610: htp.p('
3611: htp.title(wf_core.translate('WFDM_NODES_TITLE'));
3612: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
3613: htp.headClose;
3614: wfa_sec.Header(FALSE, '',wf_core.translate('WFDM_NODES_TITLE'), FALSE);
3615: htp.br;
3609: htp.headOpen;
3610: htp.p('
3611: htp.title(wf_core.translate('WFDM_NODES_TITLE'));
3612: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
3613: htp.headClose;
3614: wfa_sec.Header(FALSE, '',wf_core.translate('WFDM_NODES_TITLE'), FALSE);
3615: htp.br;
3616:
3617: IF (admin_mode = 'N') THEN
3611: htp.title(wf_core.translate('WFDM_NODES_TITLE'));
3612: wfa_html.create_help_function('wf/links/dmr.htm?DMREP');
3613: htp.headClose;
3614: wfa_sec.Header(FALSE, '',wf_core.translate('WFDM_NODES_TITLE'), FALSE);
3615: htp.br;
3616:
3617: IF (admin_mode = 'N') THEN
3618:
3619: htp.center(htf.bold(l_error_msg));
3615: htp.br;
3616:
3617: IF (admin_mode = 'N') THEN
3618:
3619: htp.center(htf.bold(l_error_msg));
3620: return;
3621:
3622: END IF;
3623:
3621:
3622: END IF;
3623:
3624: -- Column headers
3625: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
3626: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
3627:
3628: htp.tableHeader(cvalue=>''||
3629: wf_core.translate('NAME')||'',
3622: END IF;
3623:
3624: -- Column headers
3625: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
3626: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
3627:
3628: htp.tableHeader(cvalue=>''||
3629: wf_core.translate('NAME')||'',
3630: calign=>'Center', cattributes=>'id="t_name"');
3624: -- Column headers
3625: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%" summary=""');
3626: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
3627:
3628: htp.tableHeader(cvalue=>''||
3629: wf_core.translate('NAME')||'',
3630: calign=>'Center', cattributes=>'id="t_name"');
3631: htp.tableHeader(cvalue=>''||
3632: wf_core.translate('DESCRIPTION')||'',
3627:
3628: htp.tableHeader(cvalue=>''||
3629: wf_core.translate('NAME')||'',
3630: calign=>'Center', cattributes=>'id="t_name"');
3631: htp.tableHeader(cvalue=>''||
3632: wf_core.translate('DESCRIPTION')||'',
3633: calign=>'Center', cattributes=>'id="t_node_description"');
3634: htp.tableHeader(cvalue=>''
3635: || wf_core.translate('WFDM_WEB_AGENT')||'',
3630: calign=>'Center', cattributes=>'id="t_name"');
3631: htp.tableHeader(cvalue=>''||
3632: wf_core.translate('DESCRIPTION')||'',
3633: calign=>'Center', cattributes=>'id="t_node_description"');
3634: htp.tableHeader(cvalue=>''
3635: || wf_core.translate('WFDM_WEB_AGENT')||'',
3636: calign=>'Center', cattributes=>'id="t_connect_syntax"');
3637: htp.tableHeader(cvalue=>''||
3638: wf_core.translate('PRODUCT')||'',
3633: calign=>'Center', cattributes=>'id="t_node_description"');
3634: htp.tableHeader(cvalue=>''
3635: || wf_core.translate('WFDM_WEB_AGENT')||'',
3636: calign=>'Center', cattributes=>'id="t_connect_syntax"');
3637: htp.tableHeader(cvalue=>''||
3638: wf_core.translate('PRODUCT')||'',
3639: calign=>'Center', cattributes=>'id="t_product_name"');
3640: htp.tableHeader(cvalue=>''||
3641: wf_core.translate('VENDOR')||'',
3636: calign=>'Center', cattributes=>'id="t_connect_syntax"');
3637: htp.tableHeader(cvalue=>''||
3638: wf_core.translate('PRODUCT')||'',
3639: calign=>'Center', cattributes=>'id="t_product_name"');
3640: htp.tableHeader(cvalue=>''||
3641: wf_core.translate('VENDOR')||'',
3642: calign=>'Center', cattributes=>'id="t_vendor_name"');
3643: htp.tableHeader(cvalue=>''||
3644: wf_core.translate('VERSION')||'',
3639: calign=>'Center', cattributes=>'id="t_product_name"');
3640: htp.tableHeader(cvalue=>''||
3641: wf_core.translate('VENDOR')||'',
3642: calign=>'Center', cattributes=>'id="t_vendor_name"');
3643: htp.tableHeader(cvalue=>''||
3644: wf_core.translate('VERSION')||'',
3645: calign=>'Center', cattributes=>'id="t_version"');
3646: htp.tableHeader(cvalue=>''||
3647: wf_core.translate('WFDM_NODE_ID')||'',
3642: calign=>'Center', cattributes=>'id="t_vendor_name"');
3643: htp.tableHeader(cvalue=>''||
3644: wf_core.translate('VERSION')||'',
3645: calign=>'Center', cattributes=>'id="t_version"');
3646: htp.tableHeader(cvalue=>''||
3647: wf_core.translate('WFDM_NODE_ID')||'',
3648: calign=>'Center', cattributes=>'id="t_node_id"');
3649: htp.tableHeader(cvalue=>''||
3650: wf_core.translate('DELETE')||'',
3645: calign=>'Center', cattributes=>'id="t_version"');
3646: htp.tableHeader(cvalue=>''||
3647: wf_core.translate('WFDM_NODE_ID')||'',
3648: calign=>'Center', cattributes=>'id="t_node_id"');
3649: htp.tableHeader(cvalue=>''||
3650: wf_core.translate('DELETE')||'',
3651: calign=>'Center', cattributes=>'id="t_delete"');
3652: htp.tableRowClose;
3653: htp.tableRowOpen;
3648: calign=>'Center', cattributes=>'id="t_node_id"');
3649: htp.tableHeader(cvalue=>''||
3650: wf_core.translate('DELETE')||'',
3651: calign=>'Center', cattributes=>'id="t_delete"');
3652: htp.tableRowClose;
3653: htp.tableRowOpen;
3654: htp.tableRowClose;
3655:
3656: -- Show all nodes
3649: htp.tableHeader(cvalue=>''||
3650: wf_core.translate('DELETE')||'',
3651: calign=>'Center', cattributes=>'id="t_delete"');
3652: htp.tableRowClose;
3653: htp.tableRowOpen;
3654: htp.tableRowClose;
3655:
3656: -- Show all nodes
3657: for nodes in nodes_cursor loop
3650: wf_core.translate('DELETE')||'',
3651: calign=>'Center', cattributes=>'id="t_delete"');
3652: htp.tableRowClose;
3653: htp.tableRowOpen;
3654: htp.tableRowClose;
3655:
3656: -- Show all nodes
3657: for nodes in nodes_cursor loop
3658:
3655:
3656: -- Show all nodes
3657: for nodes in nodes_cursor loop
3658:
3659: htp.tableRowOpen(null, 'TOP');
3660:
3661: -- Bug5161758 - XSS
3662: htp.tableData(htf.anchor2(
3663: curl=>wfa_html.base_url||
3658:
3659: htp.tableRowOpen(null, 'TOP');
3660:
3661: -- Bug5161758 - XSS
3662: htp.tableData(htf.anchor2(
3663: curl=>wfa_html.base_url||
3664: '/fnd_document_management.dm_nodes_edit?p_node_id='||
3665: to_char(nodes.node_id),
3666: ctext=>wf_core.substitutespecialchars(nodes.node_name),
3665: to_char(nodes.node_id),
3666: ctext=>wf_core.substitutespecialchars(nodes.node_name),
3667: ctarget=>'_top'),
3668: 'Left', cattributes=>'headers="t_name"');
3669: htp.tableData(wf_core.substitutespecialchars(nodes.node_description),
3670: 'left',
3671: cattributes=>'headers="t_node_description"');
3672: htp.tableData(wf_core.substitutespecialchars(nodes.connect_syntax),
3673: 'left',
3668: 'Left', cattributes=>'headers="t_name"');
3669: htp.tableData(wf_core.substitutespecialchars(nodes.node_description),
3670: 'left',
3671: cattributes=>'headers="t_node_description"');
3672: htp.tableData(wf_core.substitutespecialchars(nodes.connect_syntax),
3673: 'left',
3674: cattributes=>'headers="t_connect_syntax"');
3675: htp.tableData(wf_core.substitutespecialchars(nodes.product_name),
3676: 'left',
3671: cattributes=>'headers="t_node_description"');
3672: htp.tableData(wf_core.substitutespecialchars(nodes.connect_syntax),
3673: 'left',
3674: cattributes=>'headers="t_connect_syntax"');
3675: htp.tableData(wf_core.substitutespecialchars(nodes.product_name),
3676: 'left',
3677: cattributes=>'headers="t_product_name"');
3678: htp.tableData(wf_core.substitutespecialchars(nodes.vendor_name),
3679: 'left',
3674: cattributes=>'headers="t_connect_syntax"');
3675: htp.tableData(wf_core.substitutespecialchars(nodes.product_name),
3676: 'left',
3677: cattributes=>'headers="t_product_name"');
3678: htp.tableData(wf_core.substitutespecialchars(nodes.vendor_name),
3679: 'left',
3680: cattributes=>'headers="t_vendor_name"');
3681: htp.tableData(wf_core.substitutespecialchars(nodes.version),
3682: 'left',
3677: cattributes=>'headers="t_product_name"');
3678: htp.tableData(wf_core.substitutespecialchars(nodes.vendor_name),
3679: 'left',
3680: cattributes=>'headers="t_vendor_name"');
3681: htp.tableData(wf_core.substitutespecialchars(nodes.version),
3682: 'left',
3683: cattributes=>'headers="t_version"');
3684: htp.tableData(wf_core.substitutespecialchars(nodes.node_id), 'left',
3685: cattributes=>'headers="t_node_id"');
3680: cattributes=>'headers="t_vendor_name"');
3681: htp.tableData(wf_core.substitutespecialchars(nodes.version),
3682: 'left',
3683: cattributes=>'headers="t_version"');
3684: htp.tableData(wf_core.substitutespecialchars(nodes.node_id), 'left',
3685: cattributes=>'headers="t_node_id"');
3686:
3687: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
3688: '/fnd_document_management.dm_nodes_confirm_delete?p_node_id='||
3683: cattributes=>'headers="t_version"');
3684: htp.tableData(wf_core.substitutespecialchars(nodes.node_id), 'left',
3685: cattributes=>'headers="t_node_id"');
3686:
3687: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
3688: '/fnd_document_management.dm_nodes_confirm_delete?p_node_id='||
3689: wf_core.substitutespecialchars(nodes.node_id),
3690: ctext=>''),
3691: 'center', cattributes=>'valign="MIDDLE" headers="t_delete"');
3691: 'center', cattributes=>'valign="MIDDLE" headers="t_delete"');
3692:
3693: end loop;
3694:
3695: htp.tableclose;
3696:
3697: htp.br;
3698:
3699: htp.tableopen(calign=>'CENTER', cattributes=>'summary=""');
3693: end loop;
3694:
3695: htp.tableclose;
3696:
3697: htp.br;
3698:
3699: htp.tableopen(calign=>'CENTER', cattributes=>'summary=""');
3700:
3701: --Add new node Button
3695: htp.tableclose;
3696:
3697: htp.br;
3698:
3699: htp.tableopen(calign=>'CENTER', cattributes=>'summary=""');
3700:
3701: --Add new node Button
3702: htp.tableRowOpen;
3703:
3698:
3699: htp.tableopen(calign=>'CENTER', cattributes=>'summary=""');
3700:
3701: --Add new node Button
3702: htp.tableRowOpen;
3703:
3704: l_url := wfa_html.base_url||'/fnd_document_management.dm_nodes_edit';
3705: l_icon := 'FNDJLFOK.gif';
3706: l_text := wf_core.translate ('WFDM_CREATE');
3705: l_icon := 'FNDJLFOK.gif';
3706: l_text := wf_core.translate ('WFDM_CREATE');
3707: l_onmouseover := wf_core.translate ('WFDM_CREATE');
3708:
3709: htp.p('
3709: htp.p('
3711: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);
3712:
3713: htp.p('');
3714:
3715: htp.tableRowClose;
3716:
3717: htp.tableclose;
3718:
3719: wfa_sec.Footer;
3713: htp.p('');
3714:
3715: htp.tableRowClose;
3716:
3717: htp.tableclose;
3718:
3719: wfa_sec.Footer;
3720: htp.htmlClose;
3721:
3716:
3717: htp.tableclose;
3718:
3719: wfa_sec.Footer;
3720: htp.htmlClose;
3721:
3722: exception
3723: when others then
3724: wf_core.context('FND_DOCUMENT_MANAGEMENT', 'Dm_Nodes_Display');
3813: -- get the document management home node information
3814: fnd_document_management.get_dm_home (l_username, dm_node_id, dm_node_name);
3815:
3816: -- Set page title
3817: htp.htmlOpen;
3818: htp.headOpen;
3819: htp.title(wf_core.translate('WFDM_HOME'));
3820: htp.headClose;
3821:
3814: fnd_document_management.get_dm_home (l_username, dm_node_id, dm_node_name);
3815:
3816: -- Set page title
3817: htp.htmlOpen;
3818: htp.headOpen;
3819: htp.title(wf_core.translate('WFDM_HOME'));
3820: htp.headClose;
3821:
3822: -- Page header
3815:
3816: -- Set page title
3817: htp.htmlOpen;
3818: htp.headOpen;
3819: htp.title(wf_core.translate('WFDM_HOME'));
3820: htp.headClose;
3821:
3822: -- Page header
3823: htp.center(htf.bold(wf_core.translate('WFDM_HOME')));
3816: -- Set page title
3817: htp.htmlOpen;
3818: htp.headOpen;
3819: htp.title(wf_core.translate('WFDM_HOME'));
3820: htp.headClose;
3821:
3822: -- Page header
3823: htp.center(htf.bold(wf_core.translate('WFDM_HOME')));
3824: htp.p('
');
3819: htp.title(wf_core.translate('WFDM_HOME'));
3820: htp.headClose;
3821:
3822: -- Page header
3823: htp.center(htf.bold(wf_core.translate('WFDM_HOME')));
3824: htp.p('
');
3825:
3826: -- Column headers
3827: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
3820: htp.headClose;
3821:
3822: -- Page header
3823: htp.center(htf.bold(wf_core.translate('WFDM_HOME')));
3824: htp.p('
');
3825:
3826: -- Column headers
3827: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
3828: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
3823: htp.center(htf.bold(wf_core.translate('WFDM_HOME')));
3824: htp.p('
');
3825:
3826: -- Column headers
3827: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
3828: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
3829:
3830: htp.tableHeader(cvalue=>''||
3831: wf_core.translate('NAME')||'',
3824: htp.p('
');
3825:
3826: -- Column headers
3827: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
3828: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
3829:
3830: htp.tableHeader(cvalue=>''||
3831: wf_core.translate('NAME')||'',
3832: calign=>'Center',
3826: -- Column headers
3827: htp.tableOpen('border=1 cellpadding=3 bgcolor=white width="100%"');
3828: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
3829:
3830: htp.tableHeader(cvalue=>''||
3831: wf_core.translate('NAME')||'',
3832: calign=>'Center',
3833: cattributes=>'id="t_name"');
3834: htp.tableHeader(cvalue=>''||
3830: htp.tableHeader(cvalue=>''||
3831: wf_core.translate('NAME')||'',
3832: calign=>'Center',
3833: cattributes=>'id="t_name"');
3834: htp.tableHeader(cvalue=>''||
3835: wf_core.translate('DESCRIPTION')||'',
3836: calign=>'Center', cattributes=>'id="t_node_description"');
3837: htp.tableHeader(cvalue=>''||
3838: wf_core.translate('PRODUCT')||'',
3833: cattributes=>'id="t_name"');
3834: htp.tableHeader(cvalue=>''||
3835: wf_core.translate('DESCRIPTION')||'',
3836: calign=>'Center', cattributes=>'id="t_node_description"');
3837: htp.tableHeader(cvalue=>''||
3838: wf_core.translate('PRODUCT')||'',
3839: calign=>'Center', cattributes=>'id="t_product"');
3840:
3841: htp.tableRowClose;
3837: htp.tableHeader(cvalue=>''||
3838: wf_core.translate('PRODUCT')||'',
3839: calign=>'Center', cattributes=>'id="t_product"');
3840:
3841: htp.tableRowClose;
3842: htp.tableRowOpen;
3843: htp.tableRowClose;
3844:
3845: -- Show all nodes
3838: wf_core.translate('PRODUCT')||'',
3839: calign=>'Center', cattributes=>'id="t_product"');
3840:
3841: htp.tableRowClose;
3842: htp.tableRowOpen;
3843: htp.tableRowClose;
3844:
3845: -- Show all nodes
3846: for nodes in nodes_cursor loop
3839: calign=>'Center', cattributes=>'id="t_product"');
3840:
3841: htp.tableRowClose;
3842: htp.tableRowOpen;
3843: htp.tableRowClose;
3844:
3845: -- Show all nodes
3846: for nodes in nodes_cursor loop
3847:
3844:
3845: -- Show all nodes
3846: for nodes in nodes_cursor loop
3847:
3848: htp.tableRowOpen(null, 'TOP');
3849:
3850: /*
3851: ** Always show the currently selected node in bold
3852: */
3851: ** Always show the currently selected node in bold
3852: */
3853: IF (dm_node_id = nodes.node_id) THEN
3854: -- Bug5161758 - XSS
3855: htp.tableData(htf.anchor2(
3856: curl=>wfa_html.base_url||
3857: '/fnd_document_management.set_dm_home_html?'||
3858: 'dm_node_id='||to_char(nodes.node_id)||
3859: '&username='||l_username||
3864: 'Left', cattributes=>'headers="t_name"');
3865:
3866: ELSE
3867:
3868: htp.tableData(htf.anchor2(
3869: curl=>dm_base_url||
3870: '/fnd_document_management.set_dm_home_html?'||
3871: 'dm_node_id='||to_char(nodes.node_id)||
3872: '&username='||l_username||
3878: END IF;
3879:
3880: -- Bug5161758 - XSS
3881: IF (dm_node_id = nodes.node_id) THEN
3882: htp.tableData(htf.bold(wf_core.substitutespecialchars(nodes.node_description)), 'left',
3883: cattributes=>'headers="t_node_description"');
3884: htp.tableData(htf.bold(wf_core.substitutespecialchars(nodes.product_name)), 'left',
3885: cattributes=>'headers="t_product"');
3886: ELSE
3880: -- Bug5161758 - XSS
3881: IF (dm_node_id = nodes.node_id) THEN
3882: htp.tableData(htf.bold(wf_core.substitutespecialchars(nodes.node_description)), 'left',
3883: cattributes=>'headers="t_node_description"');
3884: htp.tableData(htf.bold(wf_core.substitutespecialchars(nodes.product_name)), 'left',
3885: cattributes=>'headers="t_product"');
3886: ELSE
3887: htp.tableData(wf_core.substitutespecialchars(nodes.node_description), 'left',
3888: cattributes=>'headers="t_node_description"');
3883: cattributes=>'headers="t_node_description"');
3884: htp.tableData(htf.bold(wf_core.substitutespecialchars(nodes.product_name)), 'left',
3885: cattributes=>'headers="t_product"');
3886: ELSE
3887: htp.tableData(wf_core.substitutespecialchars(nodes.node_description), 'left',
3888: cattributes=>'headers="t_node_description"');
3889: htp.tableData(wf_core.substitutespecialchars(nodes.product_name), 'left', 'left',
3890: cattributes=>'headers="t_product"');
3891: END IF;
3885: cattributes=>'headers="t_product"');
3886: ELSE
3887: htp.tableData(wf_core.substitutespecialchars(nodes.node_description), 'left',
3888: cattributes=>'headers="t_node_description"');
3889: htp.tableData(wf_core.substitutespecialchars(nodes.product_name), 'left', 'left',
3890: cattributes=>'headers="t_product"');
3891: END IF;
3892:
3893: end loop;
3891: END IF;
3892:
3893: end loop;
3894:
3895: htp.tableclose;
3896:
3897: htp.br;
3898:
3899: wfa_sec.Footer;
3893: end loop;
3894:
3895: htp.tableclose;
3896:
3897: htp.br;
3898:
3899: wfa_sec.Footer;
3900: htp.htmlClose;
3901:
3896:
3897: htp.br;
3898:
3899: wfa_sec.Footer;
3900: htp.htmlClose;
3901:
3902: exception
3903: when others then
3904: rollback;
3946: WHERE product_name like p_find_criteria||'%';
3947:
3948: END IF;
3949:
3950: htp.p(wf_core.translate('PRODUCT'));
3951: htp.p('4');
3952: htp.p(TO_CHAR(l_row_count));
3953: htp.p(wf_core.translate('PRODUCT'));
3954: htp.p('50');
3947:
3948: END IF;
3949:
3950: htp.p(wf_core.translate('PRODUCT'));
3951: htp.p('4');
3952: htp.p(TO_CHAR(l_row_count));
3953: htp.p(wf_core.translate('PRODUCT'));
3954: htp.p('50');
3955: htp.p(wf_core.translate('VENDOR'));
3948: END IF;
3949:
3950: htp.p(wf_core.translate('PRODUCT'));
3951: htp.p('4');
3952: htp.p(TO_CHAR(l_row_count));
3953: htp.p(wf_core.translate('PRODUCT'));
3954: htp.p('50');
3955: htp.p(wf_core.translate('VENDOR'));
3956: htp.p('35');
3949:
3950: htp.p(wf_core.translate('PRODUCT'));
3951: htp.p('4');
3952: htp.p(TO_CHAR(l_row_count));
3953: htp.p(wf_core.translate('PRODUCT'));
3954: htp.p('50');
3955: htp.p(wf_core.translate('VENDOR'));
3956: htp.p('35');
3957: htp.p(wf_core.translate('VERSION'));
3950: htp.p(wf_core.translate('PRODUCT'));
3951: htp.p('4');
3952: htp.p(TO_CHAR(l_row_count));
3953: htp.p(wf_core.translate('PRODUCT'));
3954: htp.p('50');
3955: htp.p(wf_core.translate('VENDOR'));
3956: htp.p('35');
3957: htp.p(wf_core.translate('VERSION'));
3958: htp.p('15');
3951: htp.p('4');
3952: htp.p(TO_CHAR(l_row_count));
3953: htp.p(wf_core.translate('PRODUCT'));
3954: htp.p('50');
3955: htp.p(wf_core.translate('VENDOR'));
3956: htp.p('35');
3957: htp.p(wf_core.translate('VERSION'));
3958: htp.p('15');
3959: htp.p('PRODUCT_ID');
3952: htp.p(TO_CHAR(l_row_count));
3953: htp.p(wf_core.translate('PRODUCT'));
3954: htp.p('50');
3955: htp.p(wf_core.translate('VENDOR'));
3956: htp.p('35');
3957: htp.p(wf_core.translate('VERSION'));
3958: htp.p('15');
3959: htp.p('PRODUCT_ID');
3960: htp.p('0');
3953: htp.p(wf_core.translate('PRODUCT'));
3954: htp.p('50');
3955: htp.p(wf_core.translate('VENDOR'));
3956: htp.p('35');
3957: htp.p(wf_core.translate('VERSION'));
3958: htp.p('15');
3959: htp.p('PRODUCT_ID');
3960: htp.p('0');
3961:
3954: htp.p('50');
3955: htp.p(wf_core.translate('VENDOR'));
3956: htp.p('35');
3957: htp.p(wf_core.translate('VERSION'));
3958: htp.p('15');
3959: htp.p('PRODUCT_ID');
3960: htp.p('0');
3961:
3962: IF (p_titles_only = 'N') THEN
3955: htp.p(wf_core.translate('VENDOR'));
3956: htp.p('35');
3957: htp.p(wf_core.translate('VERSION'));
3958: htp.p('15');
3959: htp.p('PRODUCT_ID');
3960: htp.p('0');
3961:
3962: IF (p_titles_only = 'N') THEN
3963:
3956: htp.p('35');
3957: htp.p(wf_core.translate('VERSION'));
3958: htp.p('15');
3959: htp.p('PRODUCT_ID');
3960: htp.p('0');
3961:
3962: IF (p_titles_only = 'N') THEN
3963:
3964: OPEN c_product_lov (p_find_criteria||'%');
3973: l_product_id, l_product, l_vendor, l_version;
3974:
3975: EXIT WHEN c_product_lov%NOTFOUND;
3976:
3977: htp.p (l_product);
3978: htp.p (l_vendor);
3979: htp.p (l_version);
3980: htp.p (TO_CHAR(l_product_id));
3981:
3974:
3975: EXIT WHEN c_product_lov%NOTFOUND;
3976:
3977: htp.p (l_product);
3978: htp.p (l_vendor);
3979: htp.p (l_version);
3980: htp.p (TO_CHAR(l_product_id));
3981:
3982: END LOOP;
3975: EXIT WHEN c_product_lov%NOTFOUND;
3976:
3977: htp.p (l_product);
3978: htp.p (l_vendor);
3979: htp.p (l_version);
3980: htp.p (TO_CHAR(l_product_id));
3981:
3982: END LOOP;
3983:
3976:
3977: htp.p (l_product);
3978: htp.p (l_vendor);
3979: htp.p (l_version);
3980: htp.p (TO_CHAR(l_product_id));
3981:
3982: END LOOP;
3983:
3984: END IF;
4138: l_document_text := REPLACE(l_document_text, '<', '<');
4139:
4140: l_document_text := REPLACE(l_document_text, '>', '>');
4141:
4142: --htp.p('l_document_text = '||l_document_text);
4143:
4144: END IF;
4145:
4146: document_attributes.document_identifier := document_identifier;
4226: */
4227: -- get_document_token_value(l_document_text, '
4228: -- document_attributes.latest_version := l_value;
4229: /*
4230: htp.p('document_identifier ='||document_attributes.document_identifier);
4231: htp.p('document_name ='||document_attributes.document_name );
4232: htp.p('document_type ='||document_attributes.document_type );
4233: htp.p('filename ='||document_attributes.filename );
4234: htp.p('created_by ='||document_attributes.created_by );
4227: -- get_document_token_value(l_document_text, '
4228: -- document_attributes.latest_version := l_value;
4229: /*
4230: htp.p('document_identifier ='||document_attributes.document_identifier);
4231: htp.p('document_name ='||document_attributes.document_name );
4232: htp.p('document_type ='||document_attributes.document_type );
4233: htp.p('filename ='||document_attributes.filename );
4234: htp.p('created_by ='||document_attributes.created_by );
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4228: -- document_attributes.latest_version := l_value;
4229: /*
4230: htp.p('document_identifier ='||document_attributes.document_identifier);
4231: htp.p('document_name ='||document_attributes.document_name );
4232: htp.p('document_type ='||document_attributes.document_type );
4233: htp.p('filename ='||document_attributes.filename );
4234: htp.p('created_by ='||document_attributes.created_by );
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4229: /*
4230: htp.p('document_identifier ='||document_attributes.document_identifier);
4231: htp.p('document_name ='||document_attributes.document_name );
4232: htp.p('document_type ='||document_attributes.document_type );
4233: htp.p('filename ='||document_attributes.filename );
4234: htp.p('created_by ='||document_attributes.created_by );
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4237: htp.p('locked_by ='||document_attributes.locked_by );
4230: htp.p('document_identifier ='||document_attributes.document_identifier);
4231: htp.p('document_name ='||document_attributes.document_name );
4232: htp.p('document_type ='||document_attributes.document_type );
4233: htp.p('filename ='||document_attributes.filename );
4234: htp.p('created_by ='||document_attributes.created_by );
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4237: htp.p('locked_by ='||document_attributes.locked_by );
4238: htp.p('document_size ='||document_attributes.document_size );
4231: htp.p('document_name ='||document_attributes.document_name );
4232: htp.p('document_type ='||document_attributes.document_type );
4233: htp.p('filename ='||document_attributes.filename );
4234: htp.p('created_by ='||document_attributes.created_by );
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4237: htp.p('locked_by ='||document_attributes.locked_by );
4238: htp.p('document_size ='||document_attributes.document_size );
4239: htp.p('document_status ='||document_attributes.document_status );
4232: htp.p('document_type ='||document_attributes.document_type );
4233: htp.p('filename ='||document_attributes.filename );
4234: htp.p('created_by ='||document_attributes.created_by );
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4237: htp.p('locked_by ='||document_attributes.locked_by );
4238: htp.p('document_size ='||document_attributes.document_size );
4239: htp.p('document_status ='||document_attributes.document_status );
4240: htp.p('current_version ='||document_attributes.current_version );
4233: htp.p('filename ='||document_attributes.filename );
4234: htp.p('created_by ='||document_attributes.created_by );
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4237: htp.p('locked_by ='||document_attributes.locked_by );
4238: htp.p('document_size ='||document_attributes.document_size );
4239: htp.p('document_status ='||document_attributes.document_status );
4240: htp.p('current_version ='||document_attributes.current_version );
4241: htp.p('latest_version ='||document_attributes.latest_version );
4234: htp.p('created_by ='||document_attributes.created_by );
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4237: htp.p('locked_by ='||document_attributes.locked_by );
4238: htp.p('document_size ='||document_attributes.document_size );
4239: htp.p('document_status ='||document_attributes.document_status );
4240: htp.p('current_version ='||document_attributes.current_version );
4241: htp.p('latest_version ='||document_attributes.latest_version );
4242: */
4235: htp.p('last_updated_by ='||document_attributes.last_updated_by );
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4237: htp.p('locked_by ='||document_attributes.locked_by );
4238: htp.p('document_size ='||document_attributes.document_size );
4239: htp.p('document_status ='||document_attributes.document_status );
4240: htp.p('current_version ='||document_attributes.current_version );
4241: htp.p('latest_version ='||document_attributes.latest_version );
4242: */
4243: exception
4236: htp.p('last_update_date ='||document_attributes.last_update_date );
4237: htp.p('locked_by ='||document_attributes.locked_by );
4238: htp.p('document_size ='||document_attributes.document_size );
4239: htp.p('document_status ='||document_attributes.document_status );
4240: htp.p('current_version ='||document_attributes.current_version );
4241: htp.p('latest_version ='||document_attributes.latest_version );
4242: */
4243: exception
4244: when others then
4237: htp.p('locked_by ='||document_attributes.locked_by );
4238: htp.p('document_size ='||document_attributes.document_size );
4239: htp.p('document_status ='||document_attributes.document_status );
4240: htp.p('current_version ='||document_attributes.current_version );
4241: htp.p('latest_version ='||document_attributes.latest_version );
4242: */
4243: exception
4244: when others then
4245: document_attributes.document_name := wf_core.translate('WFDM_NODE_DOWN');
4266: document_id_field VARCHAR2(1000);
4267: document_name_field VARCHAR2(1000);
4268:
4269: BEGIN
4270: htp.headOpen;
4271: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4272: htp.headClose;
4273:
4274: htp.htmlopen;
4267: document_name_field VARCHAR2(1000);
4268:
4269: BEGIN
4270: htp.headOpen;
4271: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4272: htp.headClose;
4273:
4274: htp.htmlopen;
4275:
4268:
4269: BEGIN
4270: htp.headOpen;
4271: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4272: htp.headClose;
4273:
4274: htp.htmlopen;
4275:
4276: /*
4270: htp.headOpen;
4271: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4272: htp.headClose;
4273:
4274: htp.htmlopen;
4275:
4276: /*
4277: ** Get the document id
4278: */
4336:
4337: return true;">');
4338:
4339: htp.p ('
document_identifier='||wf_core.substitutespecialchars(document_identifier));
4340: htp.p ('
document_id='||wf_core.substitutespecialchars(document_id));
4341: htp.p ('
document_name='||wf_core.substitutespecialchars(document_name));
4342: htp.p ('
document_id_field='||wf_core.substitutespecialchars(document_id_field));
4343: htp.p ('
document_name_field='||wf_core.substitutespecialchars(document_name_field));
4344:
4337: return true;">');
4338:
4339: htp.p ('
document_identifier='||wf_core.substitutespecialchars(document_identifier));
4340: htp.p ('
document_id='||wf_core.substitutespecialchars(document_id));
4341: htp.p ('
document_name='||wf_core.substitutespecialchars(document_name));
4342: htp.p ('
document_id_field='||wf_core.substitutespecialchars(document_id_field));
4343: htp.p ('
document_name_field='||wf_core.substitutespecialchars(document_name_field));
4344:
4345: htp.bold('
'||wf_core.translate('WFDM_TRANSPORT_COMPLETED'));
4338:
4339: htp.p ('
document_identifier='||wf_core.substitutespecialchars(document_identifier));
4340: htp.p ('
document_id='||wf_core.substitutespecialchars(document_id));
4341: htp.p ('
document_name='||wf_core.substitutespecialchars(document_name));
4342: htp.p ('
document_id_field='||wf_core.substitutespecialchars(document_id_field));
4343: htp.p ('
document_name_field='||wf_core.substitutespecialchars(document_name_field));
4344:
4345: htp.bold('
'||wf_core.translate('WFDM_TRANSPORT_COMPLETED'));
4346:
4339: htp.p ('
document_identifier='||wf_core.substitutespecialchars(document_identifier));
4340: htp.p ('
document_id='||wf_core.substitutespecialchars(document_id));
4341: htp.p ('
document_name='||wf_core.substitutespecialchars(document_name));
4342: htp.p ('
document_id_field='||wf_core.substitutespecialchars(document_id_field));
4343: htp.p ('
document_name_field='||wf_core.substitutespecialchars(document_name_field));
4344:
4345: htp.bold('
'||wf_core.translate('WFDM_TRANSPORT_COMPLETED'));
4346:
4347: htp.bodyClose;
4341: htp.p ('
document_name='||wf_core.substitutespecialchars(document_name));
4342: htp.p ('
document_id_field='||wf_core.substitutespecialchars(document_id_field));
4343: htp.p ('
document_name_field='||wf_core.substitutespecialchars(document_name_field));
4344:
4345: htp.bold('
'||wf_core.translate('WFDM_TRANSPORT_COMPLETED'));
4346:
4347: htp.bodyClose;
4348:
4349: htp.htmlClose;
4343: htp.p ('
document_name_field='||wf_core.substitutespecialchars(document_name_field));
4344:
4345: htp.bold('
'||wf_core.translate('WFDM_TRANSPORT_COMPLETED'));
4346:
4347: htp.bodyClose;
4348:
4349: htp.htmlClose;
4350:
4351: exception
4345: htp.bold('
'||wf_core.translate('WFDM_TRANSPORT_COMPLETED'));
4346:
4347: htp.bodyClose;
4348:
4349: htp.htmlClose;
4350:
4351: exception
4352: when others then
4353: rollback;
4366: ============================================================================*/
4367: PROCEDURE show_transport_message IS
4368: BEGIN
4369:
4370: htp.headOpen;
4371: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4372: htp.headClose;
4373: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
4374:
4367: PROCEDURE show_transport_message IS
4368: BEGIN
4369:
4370: htp.headOpen;
4371: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4372: htp.headClose;
4373: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
4374:
4375: htp.tableOpen(cattributes=>'summary=""');
4368: BEGIN
4369:
4370: htp.headOpen;
4371: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4372: htp.headClose;
4373: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
4374:
4375: htp.tableOpen(cattributes=>'summary=""');
4376: htp.tableRowOpen;
4369:
4370: htp.headOpen;
4371: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4372: htp.headClose;
4373: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
4374:
4375: htp.tableOpen(cattributes=>'summary=""');
4376: htp.tableRowOpen;
4377:
4371: htp.title(wf_core.translate('WFDM_TRANSPORT_WINDOW'));
4372: htp.headClose;
4373: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
4374:
4375: htp.tableOpen(cattributes=>'summary=""');
4376: htp.tableRowOpen;
4377:
4378: htp.tabledata('',
4372: htp.headClose;
4373: htp.bodyOpen(cattributes=>'bgcolor="#CCCCCC"');
4374:
4375: htp.tableOpen(cattributes=>'summary=""');
4376: htp.tableRowOpen;
4377:
4378: htp.tabledata('',
4380: cattributes=>'id=""');
4377:
4378: htp.tabledata('',
4380: cattributes=>'id=""');
4381: htp.tabledata(wf_core.translate('WFDM_TRANSPORT_MESSAGE'),
4382: cattributes=>'id=""');
4383:
4384: htp.tableRowClose;
4385: htp.tableClose;
4380: cattributes=>'id=""');
4381: htp.tabledata(wf_core.translate('WFDM_TRANSPORT_MESSAGE'),
4382: cattributes=>'id=""');
4383:
4384: htp.tableRowClose;
4385: htp.tableClose;
4386: htp.bodyClose;
4387:
4388: htp.htmlClose;
4381: htp.tabledata(wf_core.translate('WFDM_TRANSPORT_MESSAGE'),
4382: cattributes=>'id=""');
4383:
4384: htp.tableRowClose;
4385: htp.tableClose;
4386: htp.bodyClose;
4387:
4388: htp.htmlClose;
4389:
4382: cattributes=>'id=""');
4383:
4384: htp.tableRowClose;
4385: htp.tableClose;
4386: htp.bodyClose;
4387:
4388: htp.htmlClose;
4389:
4390: exception
4384: htp.tableRowClose;
4385: htp.tableClose;
4386: htp.bodyClose;
4387:
4388: htp.htmlClose;
4389:
4390: exception
4391: when others then
4392: rollback;
4567: l_ticket := fnd_preference.get (username, 'WF', 'TICKET');
4568:
4569: if (l_ticket = ticket) then
4570:
4571: htp.p('
4572:
4573: else
4574:
4575: htp.p('
4571: htp.p('
4572:
4573: else
4574:
4575: htp.p('
4576:
4577: end if;
4578:
4579: exception
4624:
4625: PROCEDURE test (stringy IN VARCHAR2) IS
4626: BEGIN
4627: -- Bug5161758 - XSS
4628: htp.p (wf_core.substitutespecialchars(stringy));
4629: end;
4630:
4631:
4632: PROCEDURE show_test_message (