eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_ROUTE dependencies on WF_ROUTE

Line 1: PACKAGE BODY WF_ROUTE AS

1: PACKAGE BODY WF_ROUTE AS
2: /* $Header: wfrtgb.pls 120.4 2006/04/06 09:31:41 rwunderl ship $ */
3:
4: --
5: -- Error (PRIVATE)

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 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 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 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 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 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 715: owner := Wf_Route.Authenticate(user);

711: is
712: owner varchar2(320);
713: begin
714: -- Validate access
715: owner := Wf_Route.Authenticate(user);
716:
717: -- Delete this rule along with any child attributes
718: delete from WF_ROUTING_RULE_ATTRIBUTES
719: where RULE_ID = ruleid;

Line 725: Wf_Route.List(user, '--EDITSCREEN--');

721: delete from WF_ROUTING_RULES
722: where RULE_ID = ruleid;
723:
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;

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 729: wf_route.error;

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: --
733: -- SubmitUpdate

Line 777: owner := Wf_Route.RuleOwner(nruleid);

773: CANCEL_RECORD exception;
774: begin
775: -- Find rule owner and validate access
776: nruleid := to_number(rule_id);
777: owner := Wf_Route.RuleOwner(nruleid);
778: owner := Wf_Route.Authenticate(owner);
779: wf_directory.GetRoleInfo(owner, realname, s0, s0, s0, s0);
780:
781: l_action := substrb(action, 1, 30);

Line 778: owner := Wf_Route.Authenticate(owner);

774: begin
775: -- Find rule owner and validate access
776: nruleid := to_number(rule_id);
777: owner := Wf_Route.RuleOwner(nruleid);
778: owner := Wf_Route.Authenticate(owner);
779: wf_directory.GetRoleInfo(owner, realname, s0, s0, s0, s0);
780:
781: l_action := substrb(action, 1, 30);
782:

Line 849: owa_util.redirect_url(curl=>wfa_html.base_url || '/wf_route.list?user='||owner||'&display_user=--EDITSCREEN--',

845: end if;
846: end if;
847:
848: -- Go back to the List page
849: owa_util.redirect_url(curl=>wfa_html.base_url || '/wf_route.list?user='||owner||'&display_user=--EDITSCREEN--',
850: bclose_header=>TRUE);
851:
852: exception
853: when CANCEL_RECORD then

Line 854: Wf_Route.List(owner);

850: bclose_header=>TRUE);
851:
852: exception
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);

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 859: wf_route.error;

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:
862: --
863: -- UpdateRule

Line 957: owner := Wf_Route.RuleOwner(nruleid);

953:
954: begin
955: -- Find rule owner and validate access
956: nruleid := to_number(ruleid);
957: owner := Wf_Route.RuleOwner(nruleid);
958: owner := Wf_Route.Authenticate(owner);
959: wf_directory.GetRoleInfo(owner, realname, s0, s0, s0, s0);
960:
961: -- Get rule data

Line 958: owner := Wf_Route.Authenticate(owner);

954: begin
955: -- Find rule owner and validate access
956: nruleid := to_number(ruleid);
957: owner := Wf_Route.RuleOwner(nruleid);
958: owner := Wf_Route.Authenticate(owner);
959: wf_directory.GetRoleInfo(owner, realname, s0, s0, s0, s0);
960:
961: -- Get rule data
962: open rulecurs;

Line 990: htp.p('
');

986: -- These dummy values are needed so that the array parameters to
987: -- the submit procedure will not be null even if there are no real
988: -- response fields. This would cause a pl/sql error, because array
989: -- parameters can't be defaulted.
990: htp.p('');
991: htp.formHidden('h_fnames', 'Dummy_Name');
992: htp.formHidden('h_fvalues', 'Dummy_Value');
993: htp.formHidden('h_fdocnames', 'Dummy_Document_Value');
994: htp.formHidden('rule_id', ruleid);

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 1303: wf_route.error;

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: --
1307: -- SubmitCreate

Line 1360: owner := Wf_Route.Authenticate(user);

1356: l_action varchar2(30) := action;
1357:
1358: begin
1359: -- Validate access
1360: owner := Wf_Route.Authenticate(user);
1361: wf_directory.GetRoleInfo(owner, realname, s0, s0, s0, s0);
1362:
1363: -- Check if delete
1364:

Line 1369: Wf_Route.List(user, '--EDITSCREEN--');

1365: if (delete_button is not null) then
1366: --
1367: -- Raise DELETE so that it won't create a record
1368: --
1369: Wf_Route.List(user, '--EDITSCREEN--');
1370: return;
1371: end if;
1372:
1373: if (done_button is not null) then

Line 1445: -- Wf_route.UpdateRule(to_char(ruleid));

1441: SubmitCreate.rule_comment
1442: );
1443:
1444: -- Go directly to update to finish entering data
1445: -- Wf_route.UpdateRule(to_char(ruleid));
1446: --
1447: -- Update routing attributes if RESPOND
1448: --
1449: if (SubmitCreate.action = 'RESPOND') then

Line 1460: owa_util.redirect_url(curl=>wfa_html.base_url || '/wf_route.list?user='||user||'&display_user=--EDITSCREEN--',

1456: end if;
1457: end if;
1458:
1459: -- Go back to the List page
1460: owa_util.redirect_url(curl=>wfa_html.base_url || '/wf_route.list?user='||user||'&display_user=--EDITSCREEN--',
1461: bclose_header=>TRUE);
1462:
1463:
1464:

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 1470: wf_route.error;

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:
1473:
1474: --

Line 1619: username := Wf_Route.Authenticate(upper(t_user));

1615:
1616: end if;
1617:
1618: -- Check current user has access to this user
1619: username := Wf_Route.Authenticate(upper(t_user));
1620: wf_directory.GetRoleInfo(username, realname, s0, s0, s0, s0);
1621:
1622:
1623: -- Set today's date

Line 1645: '/wf_route.find';

1641:
1642: htp.tableRowOpen;
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:

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 1742: '/Wf_Route.UpdateRule?ruleid='||

1738: -- get the display name of the forwardee in delegation
1739: wf_directory.GetRoleInfo(rule.action_argument, forwardname,
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=""');

Line 1752: '/Wf_Route.UpdateRule?ruleid='||

1748: -- get the display name of the forwardee in transfering
1749: wf_directory.GetRoleInfo(rule.action_argument, forwardname,
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=""');

Line 1760: '/Wf_Route.UpdateRule?ruleid='||

1756: 'left',cattributes=>'id=""');
1757: else
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

Line 1816: '/Wf_Route.UpdateRule?ruleid='||

1812: -- a choice of 'close', otherwise 'response'.
1813: --
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') || '"');

Line 1824: '/Wf_Route.UpdateRule?ruleid='||

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='||
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') || '"');

Line 1831: '/Wf_Route.UpdateRule?ruleid='||

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),
1833: wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND')),
1834: 'left',cattributes=>'id="' || wf_core.translate('WFITD_MSG_SOURCE_TYPE_RESPOND') || '"');
1835: end if;

Line 1853: '/Wf_Route.DeleteRule?user='||username||

1849: -- to_char(rule.begin_date, ' HH24:MI:SS'),
1850: -- htf.br), 'left',cattributes=>'id=""');
1851:
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=""');

Line 1865: htp.formOpen(curl=>'wf_route.CreateRule',

1861: htp.tableClose;
1862:
1863:
1864: -- Button to create new rule
1865: htp.formOpen(curl=>'wf_route.CreateRule',
1866: cmethod=>'POST', cattributes=>'NAME="WF_LIST"');
1867:
1868: htp.formHidden('user', username);
1869:

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 1896: wf_route.error;

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:
1900: --

Line 1929: Wf_Route.List(curuser, '--EDITSCREEN--');

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.
1929: Wf_Route.List(curuser, '--EDITSCREEN--');
1930: -- Wf_Route.ListFrame;
1931: return;
1932: end if;
1933:

Line 1930: -- Wf_Route.ListFrame;

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.
1929: Wf_Route.List(curuser, '--EDITSCREEN--');
1930: -- Wf_Route.ListFrame;
1931: return;
1932: end if;
1933:
1934: -- Admin approved, draw the form

Line 1943: htp.formOpen(curl=>'wf_route.list',

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:
1946: htp.tableOpen(calign=>'CENTER', cattributes=>'border=0 cellpadding=2 cellspacing=0 summary=""');
1947:

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: --

Line 2004: wf_route.error;

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: --
2008: -- ChangeMessageName

Line 2021: END WF_ROUTE;

2017: where MESSAGE_TYPE = p_itemType
2018: and MESSAGE_NAME = p_oldMessageName;
2019: end;
2020:
2021: END WF_ROUTE;