APPS.WF_ROUTE dependencies on WF_CORE

Line 8: -- 1. wf_core errors

4: --
5: -- Error (PRIVATE)
6: -- Print a page with an error message.
7: -- Errors are retrieved from these sources in order:
8: -- 1. wf_core errors
9: -- 2. Oracle errors
10: -- 3. Unspecified INTERNAL error
11: --
12: procedure Error

Line 39: Wf_Core.Token('RULE', to_char(ruleid));

35: from WF_ROUTING_RULES WRR
36: where WRR.RULE_ID = RuleOwner.ruleid;
37: exception
38: when no_data_found then
39: Wf_Core.Token('RULE', to_char(ruleid));
40: Wf_Core.Raise('WFRTG_INVALID_RULE');
41: end;
42:
43: return owner;

Line 40: Wf_Core.Raise('WFRTG_INVALID_RULE');

36: where WRR.RULE_ID = RuleOwner.ruleid;
37: exception
38: when no_data_found then
39: Wf_Core.Token('RULE', to_char(ruleid));
40: Wf_Core.Raise('WFRTG_INVALID_RULE');
41: end;
42:
43: return owner;
44: exception

Line 46: wf_core.context('Wf_Route', 'RuleOwner', to_char(ruleid));

42:
43: return owner;
44: exception
45: when others then
46: wf_core.context('Wf_Route', 'RuleOwner', to_char(ruleid));
47: raise;
48: end RuleOwner;
49:
50: --

Line 77: admin_role := wf_core.translate('WF_ADMIN_ROLE');

73: end if;
74:
75: -- If admin granted to current user,
76: -- grant access and pretend to be
77: admin_role := wf_core.translate('WF_ADMIN_ROLE');
78: if (admin_role = '*' or
79: Wf_Directory.IsPerformer(curuser, admin_role)) then
80: return(user);
81: end if;

Line 85: Wf_Core.Token('CURUSER', curuser);

81: end if;
82:
83: -- Otherwise current user must match the user checking
84: if (curuser <> user) then
85: Wf_Core.Token('CURUSER', curuser);
86: Wf_Core.Token('USER', user);
87: Wf_Core.Raise('WFRTG_ACCESS_USER');
88: end if;
89:

Line 86: Wf_Core.Token('USER', user);

82:
83: -- Otherwise current user must match the user checking
84: if (curuser <> user) then
85: Wf_Core.Token('CURUSER', curuser);
86: Wf_Core.Token('USER', user);
87: Wf_Core.Raise('WFRTG_ACCESS_USER');
88: end if;
89:
90: return(user);

Line 87: Wf_Core.Raise('WFRTG_ACCESS_USER');

83: -- Otherwise current user must match the user checking
84: if (curuser <> user) then
85: Wf_Core.Token('CURUSER', curuser);
86: Wf_Core.Token('USER', user);
87: Wf_Core.Raise('WFRTG_ACCESS_USER');
88: end if;
89:
90: return(user);
91: exception

Line 93: wf_core.context('Wf_Route', 'Authenticate', user);

89:
90: return(user);
91: exception
92: when others then
93: wf_core.context('Wf_Route', 'Authenticate', user);
94: raise;
95: end Authenticate;
96:
97: --

Line 130: wf_core.context('Wf_Route', 'GetAttrValue', to_char(ruleid), attrname);

126: exception
127: when no_data_found then
128: return(FALSE);
129: when others then
130: wf_core.context('Wf_Route', 'GetAttrValue', to_char(ruleid), attrname);
131: raise;
132: end GetAttrValue;
133:
134: --

Line 161: wf_core.context('Wf_Route', 'GetLookupMeaning', ltype, lcode);

157: exception
158: when no_data_found then
159: return(lcode);
160: when others then
161: wf_core.context('Wf_Route', 'GetLookupMeaning', ltype, lcode);
162: raise;
163: end GetLookupMeaning;
164:
165: --

Line 245: wf_core.context('Wf_Route', 'GetDisplayWindow', type, format,

241: return(value);
242:
243: exception
244: when others then
245: wf_core.context('Wf_Route', 'GetDisplayWindow', type, format,
246: tvalue, to_char(nvalue), to_char(dvalue));
247: raise;
248: end GetDisplayValue;
249:

Line 260: l_message varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate ('WFPREF_LOV'));

256: dvalue in varchar2,
257: seq in varchar2 )
258: is
259: len pls_integer;
260: l_message varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate ('WFPREF_LOV'));
261:
262: -- variable for LOV
263: l_url varchar2(1000);
264: l_media varchar2(240) := wfa_html.image_loc;

Line 307: wf_core.context('Wf_route', 'GetRole', name, seq);

303: cattributes=>'id=""');
304:
305: exception
306: when others then
307: wf_core.context('Wf_route', 'GetRole', name, seq);
308: raise;
309: end GetRole;
310:
311:

Line 345: wf_core.newline||

341: htp.formHidden('h_fdocnames', '');
342:
343: -- Create hidden field and select list
344: template := htf.formHidden('h_fnames', name||'#LOOKUP#'||format)||
345: wf_core.newline||
346: htf.formSelectOpen('h_fvalues',
347: cattributes=>'id="i_attr'||seq||'"');
348:
349:

Line 353: template := template||wf_core.newline||

349:
350: -- Add all lookups to select list
351: for i in lookup_codes(format) loop
352: if (i.lookup_code = value) then
353: template := template||wf_core.newline||
354: htf.formSelectOption(i.meaning, 'SELECTED');
355: else
356: template := template||wf_core.newline||
357: htf.formSelectOption(i.meaning);

Line 356: template := template||wf_core.newline||

352: if (i.lookup_code = value) then
353: template := template||wf_core.newline||
354: htf.formSelectOption(i.meaning, 'SELECTED');
355: else
356: template := template||wf_core.newline||
357: htf.formSelectOption(i.meaning);
358: end if;
359: end loop;
360: template := template||wf_core.newline||htf.formSelectClose;

Line 360: template := template||wf_core.newline||htf.formSelectClose;

356: template := template||wf_core.newline||
357: htf.formSelectOption(i.meaning);
358: end if;
359: end loop;
360: template := template||wf_core.newline||htf.formSelectClose;
361:
362: if (not submit) then
363: -- Draw a normal field
364: htp.tableData(template, 'left',cattributes=>'id=""');

Line 369: ||wf_core.newline||template);

365: else
366: -- Draw a submit-style field for the result.
367: -- Leave TableData open so reassign button can be added to same cell.
368: htp.p(''
369: ||wf_core.newline||template);
370: htp.formSubmit('Submit', wf_core.translate('SUBMIT'), 'NOBORDER');
371: end if;
372:
373: exception

Line 370: htp.formSubmit('Submit', wf_core.translate('SUBMIT'), 'NOBORDER');

366: -- Draw a submit-style field for the result.
367: -- Leave TableData open so reassign button can be added to same cell.
368: htp.p(''
369: ||wf_core.newline||template);
370: htp.formSubmit('Submit', wf_core.translate('SUBMIT'), 'NOBORDER');
371: end if;
372:
373: exception
374: when others then

Line 375: wf_core.context('Wf_Route', 'GetLookup', name, value, format, seq);

371: end if;
372:
373: exception
374: when others then
375: wf_core.context('Wf_Route', 'GetLookup', name, value, format, seq);
376: raise;
377: end GetLookup;
378:
379: -- GetDocument (PRIVATE)

Line 423: wf_core.context('Wf_route', 'GetDocument', name, format, dvalue);

419: cattributes=>'id=""');
420:
421: exception
422: when others then
423: wf_core.context('Wf_route', 'GetDocument', name, format, dvalue);
424: raise;
425: end GetDocument;
426:
427: --

Line 484: wf_core.context('Wf_Route', 'GetField', name, type, format, dvalue,

480: cattributes=>'id=""');
481: end if;
482: exception
483: when others then
484: wf_core.context('Wf_Route', 'GetField', name, type, format, dvalue,
485: index_num);
486: raise;
487: end GetField;
488:

Line 525: wf_core.token('ROLE', role);

521: return(rname);
522: exception
523: when no_data_found then
524: -- Not displayed or internal role name, error
525: wf_core.token('ROLE', role);
526: wf_core.raise('WFNTF_ROLE');
527: end;
528:
529: exception

Line 526: wf_core.raise('WFNTF_ROLE');

522: exception
523: when no_data_found then
524: -- Not displayed or internal role name, error
525: wf_core.token('ROLE', role);
526: wf_core.raise('WFNTF_ROLE');
527: end;
528:
529: exception
530: when others then

Line 531: wf_core.context('Wf_Route', 'ValidateRole', role);

527: end;
528:
529: exception
530: when others then
531: wf_core.context('Wf_Route', 'ValidateRole', role);
532: raise;
533: end ValidateRole;
534:
535: --

Line 594: wf_core.context('Wf_Route', 'StringToDate', dstring);

590:
591: return(datebuf);
592: exception
593: when others then
594: wf_core.context('Wf_Route', 'StringToDate', dstring);
595: raise;
596: end StringToDate;
597:
598: --

Line 652: wf_core.token('TYPE', attr_fmt);

648: where Wl.LOOKUP_TYPE = SetAttribute.attr_fmt
649: and MEANING = SetAttribute.attr_value;
650: exception
651: when no_data_found then
652: wf_core.token('TYPE', attr_fmt);
653: wf_core.token('CODE', attr_value);
654: wf_core.raise('WFSQL_LOOKUP_CODE');
655: end;
656: elsif (attr_type = 'ROLE') then

Line 653: wf_core.token('CODE', attr_value);

649: and MEANING = SetAttribute.attr_value;
650: exception
651: when no_data_found then
652: wf_core.token('TYPE', attr_fmt);
653: wf_core.token('CODE', attr_value);
654: wf_core.raise('WFSQL_LOOKUP_CODE');
655: end;
656: elsif (attr_type = 'ROLE') then
657:

Line 654: wf_core.raise('WFSQL_LOOKUP_CODE');

650: exception
651: when no_data_found then
652: wf_core.token('TYPE', attr_fmt);
653: wf_core.token('CODE', attr_value);
654: wf_core.raise('WFSQL_LOOKUP_CODE');
655: end;
656: elsif (attr_type = 'ROLE') then
657:
658: -- Decode role to internal name

Line 695: wf_core.context('Wf_Route', 'SetAttribute',

691: );
692: end if;
693: exception
694: when others then
695: wf_core.context('Wf_Route', 'SetAttribute',
696: to_char(ruleid), attr_name_type, attr_value);
697: raise;
698: end SetAttribute;
699:

Line 728: wf_core.context('Wf_Route', 'DeleteRule', ruleid, user);

724: -- Return to opening page
725: Wf_Route.List(user, '--EDITSCREEN--');
726: exception
727: when others then
728: wf_core.context('Wf_Route', 'DeleteRule', ruleid, user);
729: wf_route.error;
730: end;
731:
732: --

Line 813: wf_core.raise('WFRTG_BAD_DATE_RANGE');

809: enddate := StringToDate(end_date);
810:
811: -- Validate date range
812: if (enddate <= begdate) then
813: wf_core.raise('WFRTG_BAD_DATE_RANGE');
814: end if;
815:
816: -- Update columns in main table
817: update WF_ROUTING_RULES WRR set

Line 857: wf_core.context('Wf_Route', 'SubmitUpdate', rule_id, action,

853: when CANCEL_RECORD then
854: Wf_Route.List(owner);
855:
856: when others then
857: wf_core.context('Wf_Route', 'SubmitUpdate', rule_id, action,
858: action_argument, begin_date, end_date);
859: wf_route.error;
860: end SubmitUpdate;
861:

Line 882: l_onmouseover varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate('WFA_FIND_USER'));

878: s0 varchar2(2000);
879: l_url varchar2(1000);
880: l_media varchar2(240) := wfa_html.image_loc;
881: l_icon varchar2(30) := 'FNDILOV.gif';
882: l_onmouseover varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate('WFA_FIND_USER'));
883:
884: -- Rule data
885: cursor rulecurs is
886: select WRR.MESSAGE_TYPE,

Line 952: l_message varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate ('WFPREF_LOV'));

948: msg_name varchar2(30);
949:
950: fchecked pls_integer := null;
951: tchecked pls_integer := null;
952: l_message varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate ('WFPREF_LOV'));
953:
954: begin
955: -- Find rule owner and validate access
956: nruleid := to_number(ruleid);

Line 965: Wf_Core.Token('RULE', to_char(nruleid));

961: -- Get rule data
962: open rulecurs;
963: fetch rulecurs into rulerec;
964: if (rulecurs%notfound) then
965: Wf_Core.Token('RULE', to_char(nruleid));
966: Wf_Core.Raise('WFRTG_INVALID_RULE');
967: end if;
968: close rulecurs;
969:

Line 966: Wf_Core.Raise('WFRTG_INVALID_RULE');

962: open rulecurs;
963: fetch rulecurs into rulerec;
964: if (rulecurs%notfound) then
965: Wf_Core.Token('RULE', to_char(nruleid));
966: Wf_Core.Raise('WFRTG_INVALID_RULE');
967: end if;
968: close rulecurs;
969:
970: -- Set page title

Line 973: htp.title(wf_core.translate('WFRTG_UPDATE_TITLE')||' '||realname);

969:
970: -- Set page title
971: htp.htmlOpen;
972: htp.headOpen;
973: htp.title(wf_core.translate('WFRTG_UPDATE_TITLE')||' '||realname);
974: wfa_html.create_help_function('wf/links/upr.htm?UPRULE');
975: fnd_document_management.get_open_dm_display_window;
976:
977: -- Add the java script to the header to open the dm window for

Line 982: wfa_sec.Header(FALSE,'',wf_core.translate('WFRTG_UPDATE_TITLE'), TRUE);

978: -- any DM function that and any standard LOV
979: fnd_document_management.get_open_dm_attach_window;
980:
981: htp.headClose;
982: wfa_sec.Header(FALSE,'',wf_core.translate('WFRTG_UPDATE_TITLE'), TRUE);
983:
984: -- Open form
985: -- Add dummy fields to start both array-type input fields.
986: -- These dummy values are needed so that the array parameters to

Line 1005: htp.tableData(cvalue=>wf_core.translate('MESSAGE_TYPE'),

1001: --
1002:
1003: -- Message Type/Name
1004: htp.tableRowOpen;
1005: htp.tableData(cvalue=>wf_core.translate('MESSAGE_TYPE'),
1006: calign=>'right',
1007: cattributes=>'id=""');
1008: htp.tableHeader(cvalue=>nvl(rulerec.type_display,
1009: htf.em(wf_core.translate(''))),

Line 1009: htf.em(wf_core.translate(''))),

1005: htp.tableData(cvalue=>wf_core.translate('MESSAGE_TYPE'),
1006: calign=>'right',
1007: cattributes=>'id=""');
1008: htp.tableHeader(cvalue=>nvl(rulerec.type_display,
1009: htf.em(wf_core.translate(''))),
1010: calign=>'left',
1011: cattributes=>'id=""');
1012: htp.tableRowClose;
1013: htp.tableRowOpen;

Line 1014: htp.tableData(cvalue=>wf_core.translate('NOTIFICATION'),

1010: calign=>'left',
1011: cattributes=>'id=""');
1012: htp.tableRowClose;
1013: htp.tableRowOpen;
1014: htp.tableData(cvalue=>wf_core.translate('NOTIFICATION'),
1015: calign=>'right',
1016: cattributes=>'id=""');
1017: IF (rulerec.subject IS NULL) THEN
1018:

Line 1019: htp.tableHeader(cvalue=>htf.em(wf_core.translate('')),

1015: calign=>'right',
1016: cattributes=>'id=""');
1017: IF (rulerec.subject IS NULL) THEN
1018:
1019: htp.tableHeader(cvalue=>htf.em(wf_core.translate('')),
1020: calign=>'left',
1021: cattributes=>'id=""');
1022: ELSE
1023:

Line 1035: wf_core.translate('WFRTG_BEGIN_DATE') || '',

1031:
1032: -- Active Dates
1033: htp.tableRowOpen;
1034: htp.tableData(cvalue=>'' ||
1035: wf_core.translate('WFRTG_BEGIN_DATE') || '',
1036: calign=>'right',
1037: cattributes=>'id=""');
1038: htp.tableData(cvalue=>htf.formText(cname=>'begin_date',
1039: csize=>30, cmaxlength=>64,

Line 1047: wf_core.translate('WFRTG_END_DATE') || '',

1043: cattributes=>'id=""');
1044: htp.tableRowClose;
1045: htp.tableRowOpen;
1046: htp.tableData(cvalue=>'' ||
1047: wf_core.translate('WFRTG_END_DATE') || '',
1048: calign=>'right',
1049: cattributes=>'id=""');
1050: htp.tableData(cvalue=>htf.formText(cname=>'end_date',
1051: csize=>30, cmaxlength=>64,

Line 1062: htp.tableHeader(wf_core.translate('WFRTG_AUTOMATICALLY'), 'left',

1058: htp.tableRowOpen;
1059: htp.tableData(htf.br,cattributes=>'id=""');
1060: htp.tableRowClose;
1061: htp.tableRowOpen;
1062: htp.tableHeader(wf_core.translate('WFRTG_AUTOMATICALLY'), 'left',
1063: ccolspan=>'2',cattributes=>'id=""');
1064: htp.tableRowClose;
1065:
1066:

Line 1071: wf_core.translate('WFRTG_COMMENTS_INCLUDE') || '',

1067: -- Comment
1068:
1069: htp.tableRowOpen;
1070: htp.tableData(cvalue=>'' ||
1071: wf_core.translate('WFRTG_COMMENTS_INCLUDE') || '',
1072: calign=>'right', cattributes=>'width="10%" id=""');
1073: htp.tableData(cvalue=>htf.formTextareaOpen2(
1074: cname=>'rule_comment',
1075: nrows=>3,

Line 1107: wf_core.translate('WFA_ASSIGNTO') || '');

1103:
1104: end if;
1105:
1106: htp.p('' ||
1107: wf_core.translate('WFA_ASSIGNTO') || '');
1108: htp.formHidden('action_argument', rulerec.action_argument);
1109:
1110: if (rulerec.action_argument IS NOT NULL) then
1111:

Line 1146: wf_core.translate('WFA_GROUP_REASSIGN_DELEGATE') || '');

1142: htp.p('&'||'nbsp;&'||'nbsp;&'||'nbsp;');
1143: htp.formRadio(cname=>'fmode', cvalue=>'FORWARD', cchecked=>fchecked,
1144: cattributes=>'id="i_group_reassign"');
1145: htp.p('' ||
1146: wf_core.translate('WFA_GROUP_REASSIGN_DELEGATE') || '');
1147: htp.br;
1148: htp.p('&'||'nbsp;&'||'nbsp;&'||'nbsp;');
1149: htp.formRadio(cname=>'fmode', cvalue=>'TRANSFER', cchecked=>tchecked,
1150: cattributes=>'id="i_transfer"');

Line 1152: wf_core.translate('WFA_GROUP_REASSIGN_TRANSFER') || '');

1148: htp.p('&'||'nbsp;&'||'nbsp;&'||'nbsp;');
1149: htp.formRadio(cname=>'fmode', cvalue=>'TRANSFER', cchecked=>tchecked,
1150: cattributes=>'id="i_transfer"');
1151: htp.p('' ||
1152: wf_core.translate('WFA_GROUP_REASSIGN_TRANSFER') || '');
1153: htp.br;
1154:
1155: -- ### Comment below out since we have Delegate and Transfer implemented
1156: -- Instead put a hidden field to make fmode forward

Line 1193: wf_core.translate('WFRTG_CLOSE') || '');

1189: -- a choice of 'close', otherwise 'respond'.
1190: --
1191: if (rowcount = 0) then
1192: htp.p('' ||
1193: wf_core.translate('WFRTG_CLOSE') || '');
1194: else
1195: htp.p('' ||
1196: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '');
1197: -- Draw attr fields

Line 1196: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '');

1192: htp.p('' ||
1193: wf_core.translate('WFRTG_CLOSE') || '');
1194: else
1195: htp.p('' ||
1196: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '');
1197: -- Draw attr fields
1198: htp.tableOpen(cattributes=>'summary=""');
1199: -- LOOP
1200: for attr in attrcurs loop

Line 1204: htp.p('

1200: for attr in attrcurs loop
1201: respcnt := respcnt + 1;
1202: htp.tableRowOpen;
1203: -- Indentation
1204: htp.p('
1205: '||'&'||'nbsp &'||'nbsp &'||'nbsp');
1206:
1207: -- Prompt
1208: htp.tableData(cvalue=>'' ||

Line 1256: wf_core.translate('WFRTG_DELIVER') ||

1252: htp.formRadio(cname=>'action', cvalue=>'NOOP',
1253: cattributes=>'id="i_deliver"');
1254: end if;
1255: htp.p('' ||
1256: wf_core.translate('WFRTG_DELIVER') ||
1257: '');
1258: htp.br;
1259: end if;
1260: -- NOTE: Do NOT create any more fields for h_names or h_values here. The

Line 1273: wf_core.translate ('WFMON_DONE'),

1269:
1270: htp.p('');
1271:
1272: wfa_html.create_reg_button ('javascript:document.CREATE_RULE.submit()',
1273: wf_core.translate ('WFMON_DONE'),
1274: wfa_html.image_loc,
1275: 'FNDJLFOK.gif',
1276: wf_core.translate ('WFMON_DONE'));
1277:

Line 1276: wf_core.translate ('WFMON_DONE'));

1272: wfa_html.create_reg_button ('javascript:document.CREATE_RULE.submit()',
1273: wf_core.translate ('WFMON_DONE'),
1274: wfa_html.image_loc,
1275: 'FNDJLFOK.gif',
1276: wf_core.translate ('WFMON_DONE'));
1277:
1278: htp.p('');
1279:
1280: htp.p('');

Line 1283: wf_core.translate ('CANCEL'),

1279:
1280: htp.p('');
1281:
1282: wfa_html.create_reg_button ('javascript:window.history.back()',
1283: wf_core.translate ('CANCEL'),
1284: wfa_html.image_loc,
1285: 'FNDJLFCN.gif',
1286: wf_core.translate ('CANCEL'));
1287:

Line 1286: wf_core.translate ('CANCEL'));

1282: wfa_html.create_reg_button ('javascript:window.history.back()',
1283: wf_core.translate ('CANCEL'),
1284: wfa_html.image_loc,
1285: 'FNDJLFCN.gif',
1286: wf_core.translate ('CANCEL'));
1287:
1288: htp.p('');
1289:
1290:

Line 1302: wf_core.context('Wf_Route', 'UpdateRule', ruleid);

1298: when others then
1299: if (rulecurs%isopen) then
1300: close rulecurs;
1301: end if;
1302: wf_core.context('Wf_Route', 'UpdateRule', ruleid);
1303: wf_route.error;
1304: end UpdateRule;
1305:
1306: --

Line 1398: wf_core.raise('WFRTG_BAD_DATE_RANGE');

1394: enddate := StringToDate(end_date);
1395:
1396: -- Validate date range
1397: if (enddate <= begdate) then
1398: wf_core.raise('WFRTG_BAD_DATE_RANGE');
1399: end if;
1400:
1401: -- Validate action
1402: -- Only rule is RESPOND must have both msg_type and msg_name specified

Line 1405: wf_core.raise('WFRTG_RESPOND_MESSAGE');

1401: -- Validate action
1402: -- Only rule is RESPOND must have both msg_type and msg_name specified
1403: if (action = 'RESPOND') then
1404: if ((typebuf is null) or (namebuf is null)) then
1405: wf_core.raise('WFRTG_RESPOND_MESSAGE');
1406: end if;
1407: end if;
1408:
1409: -- Validate action_argument

Line 1468: wf_core.context('Wf_Route', 'SubmitCreate', msg_type, msg_name,

1464:
1465: exception
1466: when others then
1467: rollback;
1468: wf_core.context('Wf_Route', 'SubmitCreate', msg_type, msg_name,
1469: begin_date, end_date, action);
1470: wf_route.error;
1471: end SubmitCreate;
1472:

Line 1572: l_onmouseover varchar2(240) := wf_core.translate ('WFPREF_LOV');

1568: isactive number; -- Active?
1569: l_media varchar2(240) := wfa_html.image_loc;
1570: l_icon varchar2(30) := 'FNDILOV.gif';
1571: l_text varchar2(30) := '';
1572: l_onmouseover varchar2(240) := wf_core.translate ('WFPREF_LOV');
1573: l_url varchar2(4000);
1574: today date; -- Today's date
1575: s0 varchar2(2000); -- Dummy
1576:

Line 1635: htp.center(htf.bold(wf_core.translate('WFPREF_INVALID_ROLE_NAME'))||':'||display_user);

1631:
1632: IF (realname IS NULL) THEN
1633:
1634: htp.p('');
1635: htp.center(htf.bold(wf_core.translate('WFPREF_INVALID_ROLE_NAME'))||':'||display_user);
1636: htp.br;
1637:
1638: htp.tableopen(calign=>'CENTER',cattributes=>'summary=""');
1639:

Line 1647: l_text := wf_core.translate ('WFMON_OK');

1643:
1644: l_url := wfa_html.base_url||
1645: '/wf_route.find';
1646: l_icon := 'FNDJLFOK.gif';
1647: l_text := wf_core.translate ('WFMON_OK');
1648: l_onmouseover := wf_core.translate ('WFMON_OK');
1649:
1650: htp.p('');
1651:

Line 1648: l_onmouseover := wf_core.translate ('WFMON_OK');

1644: l_url := wfa_html.base_url||
1645: '/wf_route.find';
1646: l_icon := 'FNDJLFOK.gif';
1647: l_text := wf_core.translate ('WFMON_OK');
1648: l_onmouseover := wf_core.translate ('WFMON_OK');
1649:
1650: htp.p('');
1651:
1652: wf_pref.create_reg_button (l_url, l_onmouseover, l_media, l_icon, l_text);

Line 1664: htp.title(wf_core.translate('WFRTG_LIST_TITLE')||' - '||realname);

1660: END IF;
1661:
1662: htp.headOpen;
1663: htp.p('');
1664: htp.title(wf_core.translate('WFRTG_LIST_TITLE')||' - '||realname);
1665: wfa_html.create_help_function('wf/links/nrr.htm?NRR');
1666: htp.headClose;
1667: wfa_sec.header(FALSE, 'wf_route.find', wf_core.translate('WFRTG_FIND_TITLE'), TRUE);
1668:

Line 1667: wfa_sec.header(FALSE, 'wf_route.find', wf_core.translate('WFRTG_FIND_TITLE'), TRUE);

1663: htp.p('');
1664: htp.title(wf_core.translate('WFRTG_LIST_TITLE')||' - '||realname);
1665: wfa_html.create_help_function('wf/links/nrr.htm?NRR');
1666: htp.headClose;
1667: wfa_sec.header(FALSE, 'wf_route.find', wf_core.translate('WFRTG_FIND_TITLE'), TRUE);
1668:
1669: -- Column headers
1670: htp.tableOpen(calign=>'CENTER', cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary="' || wf_core.translate('WFRTG_FIND_TITLE') || '"');
1671: -- htp.tableRowOpen(cattributes=>'bgcolor=#83c1c1');

Line 1670: htp.tableOpen(calign=>'CENTER', cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary="' || wf_core.translate('WFRTG_FIND_TITLE') || '"');

1666: htp.headClose;
1667: wfa_sec.header(FALSE, 'wf_route.find', wf_core.translate('WFRTG_FIND_TITLE'), TRUE);
1668:
1669: -- Column headers
1670: htp.tableOpen(calign=>'CENTER', cattributes=>'border=1 cellpadding=3 bgcolor=white width="100%" summary="' || wf_core.translate('WFRTG_FIND_TITLE') || '"');
1671: -- htp.tableRowOpen(cattributes=>'bgcolor=#83c1c1');
1672: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1673:
1674: -- htp.tableData(cvalue=>''||

Line 1676: wf_core.translate('MESSAGE_TYPE')||'',

1672: htp.tableRowOpen(cattributes=>'bgcolor=#006699');
1673:
1674: -- htp.tableData(cvalue=>''||
1675: htp.tableHeader(cvalue=>''||
1676: wf_core.translate('MESSAGE_TYPE')||'',
1677: calign=>'Center',
1678: cattributes=>'id="' || wf_core.translate('MESSAGE_TYPE') || '"');
1679: htp.tableHeader(cvalue=>''||
1680: wf_core.translate('NOTIFICATION')||'',

1676: wf_core.translate('MESSAGE_TYPE')||'',
1677: calign=>'Center',
1678: cattributes=>'id="' || wf_core.translate('MESSAGE_TYPE') || '"');
1679: htp.tableHeader(cvalue=>''||
1680: wf_core.translate('NOTIFICATION')||'',
1681: calign=>'Center',
1682: cattributes=>'id="' || wf_core.translate('NOTIFICATION') || '"');
1683: htp.tableHeader(cvalue=>''||
1684: wf_core.translate('RESULT_APPLY_RULE')||'',

Line 1682: cattributes=>'id="' || wf_core.translate('NOTIFICATION') || '"');

1678: cattributes=>'id="' || wf_core.translate('MESSAGE_TYPE') || '"');
1679: htp.tableHeader(cvalue=>''||
1680: wf_core.translate('NOTIFICATION')||'',
1681: calign=>'Center',
1682: cattributes=>'id="' || wf_core.translate('NOTIFICATION') || '"');
1683: htp.tableHeader(cvalue=>''||
1684: wf_core.translate('RESULT_APPLY_RULE')||'',
1685: calign=>'Center',
1686: cattributes=>'id="' || wf_core.translate('RESULT_APPLY_RULE') || '"');

Line 1684: wf_core.translate('RESULT_APPLY_RULE')||'',

1680: wf_core.translate('NOTIFICATION')||'',
1681: calign=>'Center',
1682: cattributes=>'id="' || wf_core.translate('NOTIFICATION') || '"');
1683: htp.tableHeader(cvalue=>''||
1684: wf_core.translate('RESULT_APPLY_RULE')||'',
1685: calign=>'Center',
1686: cattributes=>'id="' || wf_core.translate('RESULT_APPLY_RULE') || '"');
1687: htp.tableHeader(cvalue=>''||
1688: wf_core.translate('ACTIVE')||'',

Line 1686: cattributes=>'id="' || wf_core.translate('RESULT_APPLY_RULE') || '"');

1682: cattributes=>'id="' || wf_core.translate('NOTIFICATION') || '"');
1683: htp.tableHeader(cvalue=>''||
1684: wf_core.translate('RESULT_APPLY_RULE')||'',
1685: calign=>'Center',
1686: cattributes=>'id="' || wf_core.translate('RESULT_APPLY_RULE') || '"');
1687: htp.tableHeader(cvalue=>''||
1688: wf_core.translate('ACTIVE')||'',
1689: calign=>'Center',
1690: cattributes=>'id="' || wf_core.translate('ACTIVE') || '"');

Line 1688: wf_core.translate('ACTIVE')||'',

1684: wf_core.translate('RESULT_APPLY_RULE')||'',
1685: calign=>'Center',
1686: cattributes=>'id="' || wf_core.translate('RESULT_APPLY_RULE') || '"');
1687: htp.tableHeader(cvalue=>''||
1688: wf_core.translate('ACTIVE')||'',
1689: calign=>'Center',
1690: cattributes=>'id="' || wf_core.translate('ACTIVE') || '"');
1691: htp.tableHeader(cvalue=>''||
1692: wf_core.translate('WFRTG_DELETE')||'',

Line 1690: cattributes=>'id="' || wf_core.translate('ACTIVE') || '"');

1686: cattributes=>'id="' || wf_core.translate('RESULT_APPLY_RULE') || '"');
1687: htp.tableHeader(cvalue=>''||
1688: wf_core.translate('ACTIVE')||'',
1689: calign=>'Center',
1690: cattributes=>'id="' || wf_core.translate('ACTIVE') || '"');
1691: htp.tableHeader(cvalue=>''||
1692: wf_core.translate('WFRTG_DELETE')||'',
1693: calign=>'Center',
1694: cattributes=>'id="' || wf_core.translate('WFRTG_DELETE') || '"');

Line 1692: wf_core.translate('WFRTG_DELETE')||'',

1688: wf_core.translate('ACTIVE')||'',
1689: calign=>'Center',
1690: cattributes=>'id="' || wf_core.translate('ACTIVE') || '"');
1691: htp.tableHeader(cvalue=>''||
1692: wf_core.translate('WFRTG_DELETE')||'',
1693: calign=>'Center',
1694: cattributes=>'id="' || wf_core.translate('WFRTG_DELETE') || '"');
1695: htp.tableRowClose;
1696: htp.tableRowOpen;

Line 1694: cattributes=>'id="' || wf_core.translate('WFRTG_DELETE') || '"');

1690: cattributes=>'id="' || wf_core.translate('ACTIVE') || '"');
1691: htp.tableHeader(cvalue=>''||
1692: wf_core.translate('WFRTG_DELETE')||'',
1693: calign=>'Center',
1694: cattributes=>'id="' || wf_core.translate('WFRTG_DELETE') || '"');
1695: htp.tableRowClose;
1696: htp.tableRowOpen;
1697: htp.tableRowClose;
1698:

Line 1720: htf.em(wf_core.translate(''))),

1716: end if;
1717:
1718: htp.tableRowOpen(null, 'TOP');
1719: htp.tableData(nvl(rule.type_display,
1720: htf.em(wf_core.translate(''))),
1721: 'left',cattributes=>'id=""');
1722:
1723: IF (rule.subject IS NULL) THEN
1724:

Line 1725: htp.tableData(htf.em(wf_core.translate('')),

1721: 'left',cattributes=>'id=""');
1722:
1723: IF (rule.subject IS NULL) THEN
1724:
1725: htp.tableData(htf.em(wf_core.translate('')),
1726: 'left', cattributes=>'id=""');
1727:
1728: ELSE
1729:

Line 1744: wf_core.translate('DELEGATE')||':'||

1740: s0, s0, s0, s0);
1741: htp.tableData(htf.anchor(wfa_html.base_url||
1742: '/Wf_Route.UpdateRule?ruleid='||
1743: to_char(rule.rule_id),
1744: wf_core.translate('DELEGATE')||':'||
1745: forwardname),
1746: 'left',cattributes=>'id=""');
1747: elsif ( rule.action = 'TRANSFER' ) then
1748: -- get the display name of the forwardee in transfering

Line 1754: wf_core.translate('TRANSFER')||':'||

1750: s0, s0, s0, s0);
1751: htp.tableData(htf.anchor(wfa_html.base_url||
1752: '/Wf_Route.UpdateRule?ruleid='||
1753: to_char(rule.rule_id),
1754: wf_core.translate('TRANSFER')||':'||
1755: forwardname),
1756: 'left',cattributes=>'id=""');
1757: else
1758: if ( rule.action = 'NOOP' ) then

Line 1762: wf_core.translate('WFRTG_DELIVERTOME')),

1758: if ( rule.action = 'NOOP' ) then
1759: htp.tableData(htf.anchor(wfa_html.base_url||
1760: '/Wf_Route.UpdateRule?ruleid='||
1761: to_char(rule.rule_id),
1762: wf_core.translate('WFRTG_DELIVERTOME')),
1763: 'left',cattributes=>'id=""');
1764: else
1765:
1766: -- Check existing of response

Line 1818: wf_core.translate('WFRTG_CLOSE')),

1814: if (rowcount = 0) then
1815: htp.tableData(htf.anchor(wfa_html.base_url||
1816: '/Wf_Route.UpdateRule?ruleid='||
1817: to_char(rule.rule_id),
1818: wf_core.translate('WFRTG_CLOSE')),
1819: 'left',cattributes=>'id="' ||
1820: wf_core.translate('WFRTG_CLOSE') || '"');
1821: else
1822: if (att_tvalue is not null) then

Line 1820: wf_core.translate('WFRTG_CLOSE') || '"');

1816: '/Wf_Route.UpdateRule?ruleid='||
1817: to_char(rule.rule_id),
1818: wf_core.translate('WFRTG_CLOSE')),
1819: 'left',cattributes=>'id="' ||
1820: wf_core.translate('WFRTG_CLOSE') || '"');
1821: else
1822: if (att_tvalue is not null) then
1823: htp.tableData(htf.anchor(wfa_html.base_url||
1824: '/Wf_Route.UpdateRule?ruleid='||

Line 1826: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND')||':'

1822: if (att_tvalue is not null) then
1823: htp.tableData(htf.anchor(wfa_html.base_url||
1824: '/Wf_Route.UpdateRule?ruleid='||
1825: to_char(rule.rule_id),
1826: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND')||':'
1827: ||att_tvalue),
1828: 'left',cattributes=>'id="' || wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '"');
1829: else
1830: htp.tableData(htf.anchor(wfa_html.base_url||

Line 1828: 'left',cattributes=>'id="' || wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '"');

1824: '/Wf_Route.UpdateRule?ruleid='||
1825: to_char(rule.rule_id),
1826: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND')||':'
1827: ||att_tvalue),
1828: 'left',cattributes=>'id="' || wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '"');
1829: else
1830: htp.tableData(htf.anchor(wfa_html.base_url||
1831: '/Wf_Route.UpdateRule?ruleid='||
1832: to_char(rule.rule_id),

Line 1833: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND')),

1829: else
1830: htp.tableData(htf.anchor(wfa_html.base_url||
1831: '/Wf_Route.UpdateRule?ruleid='||
1832: to_char(rule.rule_id),
1833: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND')),
1834: 'left',cattributes=>'id="' || wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '"');
1835: end if;
1836: end if;
1837: end if;

Line 1834: 'left',cattributes=>'id="' || wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '"');

1830: htp.tableData(htf.anchor(wfa_html.base_url||
1831: '/Wf_Route.UpdateRule?ruleid='||
1832: to_char(rule.rule_id),
1833: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND')),
1834: 'left',cattributes=>'id="' || wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '"');
1835: end if;
1836: end if;
1837: end if;
1838: end if;

Line 1842: 'Center', wf_core.translate('ACTIVE')), 'center',

1838: end if;
1839:
1840: if isactive = 1 then
1841: htp.tableData(htf.img(wfa_html.image_loc||'FNDICHEK.gif',
1842: 'Center', wf_core.translate('ACTIVE')), 'center',
1843: cattributes=>'valign="MIDDLE" id=""');
1844: else
1845: htp.tableData(htf.br,cattributes=>'id=""');
1846: end if;

Line 1856: alt="' || wf_core.translate('WFRTG_DELETE') || '" BORDER=0>'),

1852: htp.tableData(htf.anchor2(curl=>wfa_html.base_url||
1853: '/Wf_Route.DeleteRule?user='||username||
1854: '&'||'ruleid='||to_char(rule.rule_id),
1855: ctext=>' 1856: alt="' || wf_core.translate('WFRTG_DELETE') || '" BORDER=0>'),
1857: 'center', cattributes=>'valign="MIDDLE" id=""');
1858: htp.tableRowClose;
1859: end loop;
1860:

Line 1879: wf_core.translate('WFRTG_INSERT'),

1875:
1876: htp.p('');
1877:
1878: wfa_html.create_reg_button ('javascript:document.WF_LIST.submit()',
1879: wf_core.translate('WFRTG_INSERT'),
1880: wfa_html.image_loc,
1881: 'FNDJLFOK.gif',
1882: wf_core.translate('WFRTG_INSERT'));
1883:

Line 1882: wf_core.translate('WFRTG_INSERT'));

1878: wfa_html.create_reg_button ('javascript:document.WF_LIST.submit()',
1879: wf_core.translate('WFRTG_INSERT'),
1880: wfa_html.image_loc,
1881: 'FNDJLFOK.gif',
1882: wf_core.translate('WFRTG_INSERT'));
1883:
1884: htp.p('');
1885:
1886: htp.tableRowClose;

Line 1895: wf_core.context('Wf_Route', 'List', user, display_user);

1891: -- wfa_sec.Footer;
1892: htp.htmlClose;
1893: exception
1894: when others then
1895: wf_core.context('Wf_Route', 'List', user, display_user);
1896: wf_route.error;
1897: end List;
1898:
1899:

Line 1917: l_onmouseover varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate('WFA_FIND_USER'));

1913: l_url varchar2(1000);
1914: l_media varchar2(240) := wfa_html.image_loc;
1915: l_icon varchar2(30) := 'FNDILOV.gif';
1916: s0 varchar2(2000);
1917: l_onmouseover varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate('WFA_FIND_USER'));
1918: l_message varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate ('WFPREF_LOV'));
1919:
1920: begin
1921: -- Check if current user has admin role

Line 1918: l_message varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate ('WFPREF_LOV'));

1914: l_media varchar2(240) := wfa_html.image_loc;
1915: l_icon varchar2(30) := 'FNDILOV.gif';
1916: s0 varchar2(2000);
1917: l_onmouseover varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate('WFA_FIND_USER'));
1918: l_message varchar2(240) := wfa_html.replace_onMouseOver_quotes(wf_core.translate ('WFPREF_LOV'));
1919:
1920: begin
1921: -- Check if current user has admin role
1922: Wfa_Sec.GetSession(curuser);

Line 1924: admin_role := wf_core.translate('WF_ADMIN_ROLE');

1920: begin
1921: -- Check if current user has admin role
1922: Wfa_Sec.GetSession(curuser);
1923: wf_directory.GetRoleInfo(curuser, realname, s0, s0, s0, s0);
1924: admin_role := wf_core.translate('WF_ADMIN_ROLE');
1925: if (admin_role <> '*' and
1926: not Wf_Directory.IsPerformer(curuser, admin_role)) then
1927: -- If current user does not have admin,
1928: -- go directly to rules list for current user.

Line 1937: htp.title(wf_core.translate('WFRTG_FIND_TITLE'));

1933:
1934: -- Admin approved, draw the form
1935: htp.htmlOpen;
1936: htp.headOpen;
1937: htp.title(wf_core.translate('WFRTG_FIND_TITLE'));
1938: wfa_html.create_help_function('wf/links/rul.htm?RULES');
1939: fnd_document_management.get_open_dm_display_window;
1940: htp.headClose;
1941: wfa_sec.header(FALSE, '', wf_core.translate('WFRTG_FIND_TITLE'), TRUE);

Line 1941: wfa_sec.header(FALSE, '', wf_core.translate('WFRTG_FIND_TITLE'), TRUE);

1937: htp.title(wf_core.translate('WFRTG_FIND_TITLE'));
1938: wfa_html.create_help_function('wf/links/rul.htm?RULES');
1939: fnd_document_management.get_open_dm_display_window;
1940: htp.headClose;
1941: wfa_sec.header(FALSE, '', wf_core.translate('WFRTG_FIND_TITLE'), TRUE);
1942:
1943: htp.formOpen(curl=>'wf_route.list',
1944: cmethod=>'POST', cattributes=>'NAME="WF_FIND"');
1945:

Line 1950: wf_core.translate('USER_ID') || '', calign=>'right',

1946: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 cellpadding=2 cellspacing=0 summary=""');
1947:
1948: htp.tableRowOpen;
1949: htp.tableData(cvalue=>'' ||
1950: wf_core.translate('USER_ID') || '', calign=>'right',
1951: cattributes=>'id=""');
1952: htp.formHidden('user', curuser);
1953:
1954: -- add LOV here: Note:bottom is name of frame.

Line 1989: wf_core.translate ('FIND'),

1985:
1986: htp.p('');
1987:
1988: wfa_html.create_reg_button ('javascript:document.WF_FIND.submit()',
1989: wf_core.translate ('FIND'),
1990: wfa_html.image_loc,
1991: 'fndfind.gif',
1992: wf_core.translate ('FIND'));
1993:

Line 1992: wf_core.translate ('FIND'));

1988: wfa_html.create_reg_button ('javascript:document.WF_FIND.submit()',
1989: wf_core.translate ('FIND'),
1990: wfa_html.image_loc,
1991: 'fndfind.gif',
1992: wf_core.translate ('FIND'));
1993:
1994: htp.p('');
1995:
1996: htp.tableRowClose;

Line 2003: wf_core.context('Wf_Route', 'Find', user);

1999: wfa_sec.Footer;
2000: htp.htmlClose;
2001: exception
2002: when others then
2003: wf_core.context('Wf_Route', 'Find', user);
2004: wf_route.error;
2005: end Find;
2006:
2007: --