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_DIRECTORY dependencies on WF_DIRECTORY

Line 1: package body Wf_Directory as

1: package body Wf_Directory as
2: /* $Header: wfdirb.pls 120.30.12010000.4 2008/12/04 00:27:57 alepe ship $ */
3:
4: --
5: -- Private variables and APIs

Line 16: g_plsqlName varchar2(30) := 'wf.plsql.WF_DIRECTORY.';

12: g_localPartitionName varchar2(30);
13: g_system_status varchar2(30);
14:
15: -- logging variable
16: g_plsqlName varchar2(30) := 'wf.plsql.WF_DIRECTORY.';
17:
18: -- System_Status (PRIVATE)
19: -- Returns the current System Status
20: function System_Status

Line 24: if wf_directory.g_system_status is null then

20: function System_Status
21: return varchar2
22: is
23: begin
24: if wf_directory.g_system_status is null then
25: wf_directory.g_system_status:= wf_core.translate('WF_SYSTEM_STATUS');
26: end if;
27: return wf_directory.g_system_status;
28: end;

Line 25: wf_directory.g_system_status:= wf_core.translate('WF_SYSTEM_STATUS');

21: return varchar2
22: is
23: begin
24: if wf_directory.g_system_status is null then
25: wf_directory.g_system_status:= wf_core.translate('WF_SYSTEM_STATUS');
26: end if;
27: return wf_directory.g_system_status;
28: end;
29: --

Line 27: return wf_directory.g_system_status;

23: begin
24: if wf_directory.g_system_status is null then
25: wf_directory.g_system_status:= wf_core.translate('WF_SYSTEM_STATUS');
26: end if;
27: return wf_directory.g_system_status;
28: end;
29: --
30: -- MinDate (PRIVATE)
31: -- Return the earliest of the two dates

Line 94: -- P_UserTable WF_DIRECTORY.UserTable

90: -- IN
91: -- P_UserList VARCHAR2
92: -- OUT
93: -- RETURN
94: -- P_UserTable WF_DIRECTORY.UserTable
95: --
96: procedure String_To_UserTable (p_UserList in VARCHAR2,
97: p_UserTable out NOCOPY WF_DIRECTORY.UserTable)
98: is

Line 97: p_UserTable out NOCOPY WF_DIRECTORY.UserTable)

93: -- RETURN
94: -- P_UserTable WF_DIRECTORY.UserTable
95: --
96: procedure String_To_UserTable (p_UserList in VARCHAR2,
97: p_UserTable out NOCOPY WF_DIRECTORY.UserTable)
98: is
99:
100: c1 pls_integer;
101: u1 pls_integer := 0;

Line 167: wf_core.context('Wf_Directory','CompositeName',p_CompositeName);

163: when invalidNumConv then
164: return FALSE;
165:
166: when others then
167: wf_core.context('Wf_Directory','CompositeName',p_CompositeName);
168: raise;
169: end;
170:
171: --

Line 185: users out NOCOPY Wf_Directory.UserTable)

181: -- table of users that perform the role
182: --
183: procedure GetRoleUsers(
184: role in varchar2,
185: users out NOCOPY Wf_Directory.UserTable)
186:
187: is
188: l_origSystem VARCHAR2(30);
189: l_origSystemID NUMBER;

Line 226: wf_core.context('Wf_Directory','GetRoleUsers',Role);

222: close c;
223: elsif corig%ISOPEN then
224: close corig;
225: end if;
226: wf_core.context('Wf_Directory','GetRoleUsers',Role);
227: raise;
228: end GetRoleUsers;
229:
230: --

Line 247: users out NOCOPY Wf_Directory.UserTable)

243: --
244: procedure GetUserRelation(
245: base_user in varchar2,
246: relation in varchar2,
247: users out NOCOPY Wf_Directory.UserTable)
248: is
249: begin
250: null;
251: exception

Line 253: wf_core.context('Wf_Directory','GetUserRelation',base_user,relation);

249: begin
250: null;
251: exception
252: when others then
253: wf_core.context('Wf_Directory','GetUserRelation',base_user,relation);
254: raise;
255: end GetUserRelation;
256:
257: --

Line 267: roles out NOCOPY Wf_Directory.RoleTable)

263: -- table of roles performed by the user
264: --
265: procedure GetUserRoles(
266: user in varchar2,
267: roles out NOCOPY Wf_Directory.RoleTable)
268: is
269: l_origSystem VARCHAR2(30);
270: l_origSystemID NUMBER;
271:

Line 305: wf_core.context('Wf_Directory','GetUserRoles',User);

301: elsif (corig%ISOPEN) then
302: close corig;
303: end if;
304:
305: wf_core.context('Wf_Directory','GetUserRoles',User);
306: raise;
307: end GetUserRoles;
308:
309: --

Line 329: role_info_tbl wf_directory.wf_local_roles_tbl_type;

325: notification_preference out NOCOPY varchar2,
326: language out NOCOPY varchar2,
327: territory out NOCOPY varchar2)
328: is
329: role_info_tbl wf_directory.wf_local_roles_tbl_type;
330: begin
331: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
332:
333: display_name := role_info_tbl(1).display_name;

Line 331: Wf_Directory.GetRoleInfo2(role, role_info_tbl);

327: territory out NOCOPY varchar2)
328: is
329: role_info_tbl wf_directory.wf_local_roles_tbl_type;
330: begin
331: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
332:
333: display_name := role_info_tbl(1).display_name;
334: email_address := role_info_tbl(1).email_address;
335: notification_preference := role_info_tbl(1).notification_preference;

Line 341: wf_core.context('Wf_Directory','GetRoleInfo',Role);

337: territory := role_info_tbl(1).territory;
338:
339: exception
340: when others then
341: wf_core.context('Wf_Directory','GetRoleInfo',Role);
342: raise;
343: end GetRoleInfo;
344:
345: --

Line 355: role_info_tbl out NOCOPY wf_directory.wf_local_roles_tbl_type)

351: -- role_info_tbl
352: --
353: procedure GetRoleInfo2(
354: role in varchar2,
355: role_info_tbl out NOCOPY wf_directory.wf_local_roles_tbl_type)
356: is
357: l_origSystem VARCHAR2(30);
358: l_origSystemID NUMBER;
359: l_isComposite BOOLEAN;

Line 620: wf_core.context('Wf_Directory','GetRoleInfo2',Role);

616: end if;
617: end;
618:
619: when others then
620: wf_core.context('Wf_Directory','GetRoleInfo2',Role);
621: raise;
622: end GetRoleInfo2;
623:
624: --

Line 651: role_info_tbl wf_directory.wf_local_roles_tbl_type;

647: orig_system out NOCOPY varchar2,
648: orig_system_id out NOCOPY number,
649: installed_flag out NOCOPY varchar2)
650: is
651: role_info_tbl wf_directory.wf_local_roles_tbl_type;
652: begin
653:
654: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
655:

Line 654: Wf_Directory.GetRoleInfo2(role, role_info_tbl);

650: is
651: role_info_tbl wf_directory.wf_local_roles_tbl_type;
652: begin
653:
654: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
655:
656: display_name := role_info_tbl(1).display_name;
657: email_address := role_info_tbl(1).email_address;
658: notification_preference := role_info_tbl(1).notification_preference;

Line 676: wf_core.context('Wf_Directory','GetRoleInfoMail',Role);

672: end;
673:
674: exception
675: when others then
676: wf_core.context('Wf_Directory','GetRoleInfoMail',Role);
677: raise;
678: end GetRoleInfoMail;
679:
680: procedure GetRoleInfoMail2( p_role in varchar2,

Line 696: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;

692: , p_nlsNumericCharacters out NOCOPY varchar2
693: , p_nlsSort out NOCOPY varchar2
694: , p_nlsCurrency out NOCOPY varchar2)
695: is
696: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
697: l_api varchar2(250) := g_plsqlName ||'GetRoleInfoMail2';
698:
699: begin
700: if( WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level ) then

Line 704: Wf_Directory.GetRoleInfo2(p_role, l_role_info_tbl);

700: if( WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level ) then
701: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
702: end if;
703:
704: Wf_Directory.GetRoleInfo2(p_role, l_role_info_tbl);
705:
706: p_display_name := l_role_info_tbl(1).display_name;
707: p_email_address := l_role_info_tbl(1).email_address;
708: p_notification_preference := l_role_info_tbl(1).notification_preference;

Line 736: wf_core.context('Wf_Directory','GetRoleInfoMail2', p_role);

732: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
733: end if;
734: exception
735: when others then
736: wf_core.context('Wf_Directory','GetRoleInfoMail2', p_role);
737: raise;
738: end GetRoleInfoMail2;
739:
740: --

Line 751: role_info_tbl wf_directory.wf_local_roles_tbl_type;

747: --
748: function GetRoleNtfPref(
749: role in varchar2) return varchar2
750: is
751: role_info_tbl wf_directory.wf_local_roles_tbl_type;
752: notification_preference varchar2(8);
753: begin
754:
755: Wf_Directory.GetRoleInfo2(role, role_info_tbl);

Line 755: Wf_Directory.GetRoleInfo2(role, role_info_tbl);

751: role_info_tbl wf_directory.wf_local_roles_tbl_type;
752: notification_preference varchar2(8);
753: begin
754:
755: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
756: notification_preference := role_info_tbl(1).notification_preference;
757:
758: return notification_preference;
759: exception

Line 761: wf_core.context('Wf_Directory','GetRoleNotePref',Role);

757:
758: return notification_preference;
759: exception
760: when others then
761: wf_core.context('Wf_Directory','GetRoleNotePref',Role);
762: raise;
763: end GetRoleNtfPref;
764:
765: --

Line 780: role_info_tbl wf_directory.wf_local_roles_tbl_type;

776: orig_system out NOCOPY varchar2,
777: orig_system_id out NOCOPY number
778: )
779: is
780: role_info_tbl wf_directory.wf_local_roles_tbl_type;
781: begin
782: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
783:
784: orig_system := role_info_tbl(1).orig_system;

Line 782: Wf_Directory.GetRoleInfo2(role, role_info_tbl);

778: )
779: is
780: role_info_tbl wf_directory.wf_local_roles_tbl_type;
781: begin
782: Wf_Directory.GetRoleInfo2(role, role_info_tbl);
783:
784: orig_system := role_info_tbl(1).orig_system;
785: orig_system_id := role_info_tbl(1).orig_system_id;
786:

Line 789: wf_core.context('Wf_Directory','GetRoleOrigSysInfo',Role);

785: orig_system_id := role_info_tbl(1).orig_system_id;
786:
787: exception
788: when others then
789: wf_core.context('Wf_Directory','GetRoleOrigSysInfo',Role);
790: raise;
791: end GetRoleOrigSysInfo;
792:
793: --

Line 878: wf_core.context('Wf_Directory','IsPerformer',User,Role);

874: exception
875: when no_data_found then
876: return FALSE;
877: when others then
878: wf_core.context('Wf_Directory','IsPerformer',User,Role);
879: raise;
880: end IsPerformer;
881:
882: --

Line 894: wf_core.context('Wf_Directory','CurrentUser');

890: begin
891: return NULL;
892: exception
893: when others then
894: wf_core.context('Wf_Directory','CurrentUser');
895: raise;
896: end CurrentUser;
897:
898: --

Line 943: wf_core.context('Wf_Directory','UserActive',Username);

939: exception
940: when no_data_found then
941: return FALSE;
942: when others then
943: wf_core.context('Wf_Directory','UserActive',Username);
944: raise;
945: end UserActive;
946:
947: --

Line 977: wf_core.context('Wf_Directory','GetUserName', p_orig_system,

973: fetch c_user into p_name, p_display_name;
974: close c_user;
975: exception
976: when others then
977: wf_core.context('Wf_Directory','GetUserName', p_orig_system,
978: p_orig_system_id);
979: raise;
980: end GetuserName;
981:

Line 1011: wf_core.context('Wf_Directory','GetRoleName',p_orig_system,p_orig_system);

1007: fetch c_role into p_name,p_display_name;
1008: close c_role;
1009: exception
1010: when others then
1011: wf_core.context('Wf_Directory','GetRoleName',p_orig_system,p_orig_system);
1012: raise;
1013: end GetRoleName;
1014:
1015: --

Line 1173: wf_core.context('Wf_Directory', 'SetAdHocUserStatus', user_name, status);

1169: status=>SetAdHocUserStatus.status);
1170:
1171: exception
1172: when others then
1173: wf_core.context('Wf_Directory', 'SetAdHocUserStatus', user_name, status);
1174: raise;
1175: end SetAdHocUserStatus;
1176:
1177: --

Line 1206: wf_core.context('Wf_Directory', 'SetAdHocRoleStatus', role_name, status);

1202: status=>SetAdHocRoleStatus.status);
1203:
1204: exception
1205: when others then
1206: wf_core.context('Wf_Directory', 'SetAdHocRoleStatus', role_name, status);
1207: raise;
1208: end SetAdHocRoleStatus;
1209:
1210:

Line 1445: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE) AND

1441: l_lastupdlog );
1442:
1443: --If MLS language support is enabled for this orig_system
1444: --then sync the data to _TL table aswell.
1445: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE) AND
1446: (userenv('LANG') <> 'US')) then
1447: insert into WF_LOCAL_ROLES_TL
1448: ( NAME,
1449: ORIG_SYSTEM,

Line 1537: wf_core.context('Wf_Directory', 'CreateUser', CreateUser.Name,

1533: CreateUser.orig_system_id));
1534: WF_CORE.Raise('WF_DUP_USER');
1535:
1536: when others then
1537: wf_core.context('Wf_Directory', 'CreateUser', CreateUser.Name,
1538: l_origSys, CreateUser.orig_system_id );
1539: raise;
1540: end CreateUser;
1541:

Line 1630: wf_core.context('Wf_Directory', 'CreateAdHocUser');

1626:
1627:
1628: exception
1629: when others then
1630: wf_core.context('Wf_Directory', 'CreateAdHocUser');
1631: raise;
1632: end CreateAdHocUser;
1633:
1634:

Line 1898: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE ) AND

1894: l_creatdt,
1895: l_creatby,
1896: l_lastupdlog );
1897:
1898: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE ) AND
1899: (userenv('LANG') <> 'US')) then
1900: --If the orig_system is MLS enabled then sync the dat into
1901: --the _TL table aswell.
1902: insert into WF_LOCAL_ROLES_TL

Line 1944: wf_core.context('Wf_Directory', 'CreateRole', CreateRole.role_Name,

1940: CreateRole.orig_system_id));
1941: WF_CORE.Raise('WF_DUP_ROLE');
1942:
1943: when others then
1944: wf_core.context('Wf_Directory', 'CreateRole', CreateRole.role_Name,
1945: l_origSys, CreateRole.orig_system_id);
1946: raise;
1947: end CreateRole;
1948:

Line 1982: l_users WF_DIRECTORY.UserTable;

1978: parent_orig_system in varchar2,
1979: parent_orig_system_id in number,
1980: owner_tag in varchar2)
1981: is
1982: l_users WF_DIRECTORY.UserTable;
1983:
1984: begin
1985: --Convert the string to a proper user table.
1986: if (role_users is NOT NULL) then

Line 1987: WF_DIRECTORY.string_to_userTable(role_users, l_users);

1983:
1984: begin
1985: --Convert the string to a proper user table.
1986: if (role_users is NOT NULL) then
1987: WF_DIRECTORY.string_to_userTable(role_users, l_users);
1988: end if;
1989:
1990: --Pass the call over to the superceding procedure CreateAdHocRole2
1991: WF_DIRECTORY.CreateAdHocRole2(role_name=>CreateAdhocRole.role_name,

Line 1991: WF_DIRECTORY.CreateAdHocRole2(role_name=>CreateAdhocRole.role_name,

1987: WF_DIRECTORY.string_to_userTable(role_users, l_users);
1988: end if;
1989:
1990: --Pass the call over to the superceding procedure CreateAdHocRole2
1991: WF_DIRECTORY.CreateAdHocRole2(role_name=>CreateAdhocRole.role_name,
1992: role_display_name=>CreateAdhocRole.role_display_name,
1993: language=>CreateAdhocRole.language,
1994: territory=>CreateAdhocRole.Territory,
1995: role_description=>CreateAdhocRole.role_description,

Line 2007: wf_core.context('Wf_Directory', 'CreateAdHocRole');

2003: parent_orig_system_id=>CreateAdhocRole.parent_orig_system_id,
2004: owner_tag=>CreateAdhocRole.owner_tag);
2005: exception
2006: when others then
2007: wf_core.context('Wf_Directory', 'CreateAdHocRole');
2008: raise;
2009: end CreateAdHocRole;
2010:
2011: --

Line 2019: -- role_users - WF_DIRECTORY.UserTable

2015: -- role_name -
2016: -- role_display_name -
2017: -- role_description -
2018: -- notification_preference -
2019: -- role_users - WF_DIRECTORY.UserTable
2020: -- language -
2021: -- territory -
2022: -- email_address -
2023: -- fax -

Line 2034: role_users in WF_DIRECTORY.UserTable,

2030: language in varchar2,
2031: territory in varchar2,
2032: role_description in varchar2,
2033: notification_preference in varchar2,
2034: role_users in WF_DIRECTORY.UserTable,
2035: email_address in varchar2,
2036: fax in varchar2,
2037: status in varchar2,
2038: expiration_date in date,

Line 2115: wf_core.context('Wf_Directory', 'CreateAdHocRole2');

2111:
2112:
2113: exception
2114: when others then
2115: wf_core.context('Wf_Directory', 'CreateAdHocRole2');
2116: raise;
2117: end CreateAdHocRole2;
2118:
2119: --

Line 2440: if (wf_directory.System_Status()='DISABLED') then

2436: eventParams(i).getValue(),l_params);
2437: end loop;
2438: end if;
2439: --determine if BES is enabled
2440: if (wf_directory.System_Status()='DISABLED') then
2441: --Create the event that is to be raised
2442:
2443: wf_event_t.initialize(event);
2444: event.Send_Date := sysdate;

Line 2482: wf_core.context('Wf_Directory', 'CreateUserRole',

2478:
2479:
2480: exception
2481: when others then
2482: wf_core.context('Wf_Directory', 'CreateUserRole',
2483: user_name, role_name, l_uorigSys,
2484: to_char(nvl(user_orig_system_id, l_uorigSysID)),
2485: l_rorigSys, to_char(nvl(role_orig_system_id, l_rorigSysID)));
2486:

Line 2829: if (wf_directory.System_Status()='DISABLED') then

2825: end loop;
2826: end if;
2827:
2828: --determine if BES is enabled
2829: if (wf_directory.System_Status()='DISABLED') then
2830: --Create the event that is to be raised
2831:
2832: wf_event_t.initialize(event);
2833: event.Send_Date := sysdate;

Line 2963: wf_core.context('Wf_Directory', 'RemoveUserRole',

2959: -- user.
2960:
2961: exception
2962: when others then
2963: wf_core.context('Wf_Directory', 'RemoveUserRole',
2964: user_name, role_name, user_orig_system, to_char(user_orig_system_id),
2965: role_orig_system, to_char(role_orig_system_id));
2966:
2967: raise;

Line 2982: l_users WF_DIRECTORY.UserTable;

2978: --
2979: procedure AddUsersToAdHocRole(role_name in varchar2,
2980: role_users in varchar2)
2981: is
2982: l_users WF_DIRECTORY.UserTable;
2983:
2984: begin
2985:
2986: if (role_users is NOT NULL) then

Line 2996: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole',

2992: end if;
2993:
2994: exception
2995: when others then
2996: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole',
2997: role_name, '"'||role_users||'"');
2998: raise;
2999: end AddUsersToAdHocRole;
3000:

Line 3011: role_users in WF_DIRECTORY.UserTable) is

3007: -- or adhoc users
3008: -- OUT
3009: --
3010: procedure AddUsersToAdHocRole2(role_name in varchar2,
3011: role_users in WF_DIRECTORY.UserTable) is
3012:
3013: d1 pls_integer;
3014: colon pls_integer;
3015: userIND number;

Line 3065: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2', role_name);

3061: wf_core.token('USERNAME', role_users(userIND));
3062: wf_core.raise('WF_INVALID_USER');
3063:
3064: when others then
3065: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2', role_name);
3066: raise;
3067: end;
3068:
3069: -- Check Duplicate

Line 3112: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2',

3108: end if;
3109:
3110: exception
3111: when others then
3112: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2',
3113: role_name);
3114: raise;
3115: end AddUsersToAdHocRole2;
3116:

Line 3544: wf_core.context('Wf_Directory', 'SetUserAttr', user_name, display_name);

3540: p_event_key=>user_name, p_parameters=>l_params);
3541:
3542: exception
3543: when others then
3544: wf_core.context('Wf_Directory', 'SetUserAttr', user_name, display_name);
3545: raise;
3546: end SetUserAttr;
3547:
3548: --

Line 3786: (wf_directory.isMLSEnabled(SetRoleAttr.orig_system) = FALSE)) then

3782:
3783: end if;
3784: else --(NOT overWrite)
3785: if ((userenv('LANG') = 'US') OR
3786: (wf_directory.isMLSEnabled(SetRoleAttr.orig_system) = FALSE)) then
3787: update WF_LOCAL_ROLES
3788: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3789: NOTIFICATION_PREFERENCE),
3790: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),

Line 4018: wf_core.context('Wf_Directory', 'SetRoleAttr', SetRoleAttr.role_name,

4014: p_event_key=>role_name, p_parameters=>l_params);
4015:
4016: exception
4017: when others then
4018: wf_core.context('Wf_Directory', 'SetRoleAttr', SetRoleAttr.role_name,
4019: SetRoleAttr.display_name);
4020: raise;
4021: end SetRoleAttr;
4022:

Line 4052: wf_core.context('Wf_Directory', 'SetAdHocUserExpiration', user_name, expiration_date);

4048: status=>NULL);
4049:
4050: exception
4051: when others then
4052: wf_core.context('Wf_Directory', 'SetAdHocUserExpiration', user_name, expiration_date);
4053: raise;
4054: end SetAdHocUserExpiration;
4055:
4056: --

Line 4085: wf_core.context('Wf_Directory', 'SetAdHocRoleExpiration', role_name,

4081: status=>NULL);
4082:
4083: exception
4084: when others then
4085: wf_core.context('Wf_Directory', 'SetAdHocRoleExpiration', role_name,
4086: expiration_date);
4087: raise;
4088: end SetAdHocRoleExpiration;
4089:

Line 4135: wf_core.context('Wf_Directory', 'SetAdHocUserAttr', user_name,

4131: owner_tag=>SetAdhocUserAttr.owner_tag);
4132:
4133: exception
4134: when others then
4135: wf_core.context('Wf_Directory', 'SetAdHocUserAttr', user_name,
4136: display_name);
4137: raise;
4138: end SetAdHocUserAttr;
4139:

Line 4185: wf_core.context('Wf_Directory', 'SetAdHocRoleAttr', role_name,

4181: owner_tag=>SetAdHocRoleAttr.owner_tag);
4182:
4183: exception
4184: when others then
4185: wf_core.context('Wf_Directory', 'SetAdHocRoleAttr', role_name,
4186: display_name);
4187: raise;
4188: end SetAdHocRoleAttr;
4189:

Line 4266: wf_core.context('Wf_Directory', 'RemoveUsersFromAdHocRole',

4262: end if;
4263:
4264: exception
4265: when others then
4266: wf_core.context('Wf_Directory', 'RemoveUsersFromAdHocRole',
4267: role_name, '"'||role_users||'"');
4268: raise;
4269: end RemoveUsersFromAdHocRole;
4270:

Line 4316: WF_CORE.Context('WF_DIRECTORY', 'ChangeLocalUserName', OldName, NewName);

4312: end if;
4313:
4314: exception
4315: when others then
4316: WF_CORE.Context('WF_DIRECTORY', 'ChangeLocalUserName', OldName, NewName);
4317: raise;
4318:
4319: end ChangeLocalUserName;
4320:

Line 4488: FROM WF_DIRECTORY_PARTITIONS

4484: /* We will place PER in FND_USR */
4485:
4486: SELECT Partition_ID, orig_system
4487: INTO g_partitionID, g_partitionName
4488: FROM WF_DIRECTORY_PARTITIONS
4489: WHERE ORIG_SYSTEM = DECODE(g_origSystem, 'PER', 'FND_USR',
4490: g_origSystem)
4491: AND PARTITION_ID IS NOT NULL;
4492:

Line 4503: FROM WF_DIRECTORY_PARTITIONS

4499: if (g_localPartitionID is NULL) then
4500: begin
4501: SELECT Partition_ID, orig_system
4502: INTO g_localPartitionID, g_localPartitionName
4503: FROM WF_DIRECTORY_PARTITIONS
4504: WHERE ORIG_SYSTEM = 'WF_LOCAL_ROLES';
4505:
4506: exception
4507: when NO_DATA_FOUND then

Line 4523: WF_CORE.Context('WF_DIRECTORY', 'AssignPartition', p_orig_system);

4519: p_partitionName := g_partitionName;
4520:
4521: exception
4522: when OTHERS then
4523: WF_CORE.Context('WF_DIRECTORY', 'AssignPartition', p_orig_system);
4524: raise;
4525: end;
4526:
4527: -- Bug 3090738

Line 4744: --package we query from wf_directory_partitions directly.

4740: end if;
4741:
4742: --We can use the global variable set in wf_local.syncroles
4743: --but for standalone so as not to introduce dependency on WF_LOCAL
4744: --package we query from wf_directory_partitions directly.
4745: select count(1)
4746: into mls_enabled
4747: from wf_directory_partitions
4748: where orig_system = l_origSys

Line 4747: from wf_directory_partitions

4743: --but for standalone so as not to introduce dependency on WF_LOCAL
4744: --package we query from wf_directory_partitions directly.
4745: select count(1)
4746: into mls_enabled
4747: from wf_directory_partitions
4748: where orig_system = l_origSys
4749: and ROLE_TL_VIEW is not NULL ;
4750: if (mls_enabled = 1) then
4751: return TRUE;

Line 4842: 'WF_DIRECTORY.deleteRole',

4838: -- raise error
4839:
4840: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
4841: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
4842: 'WF_DIRECTORY.deleteRole',
4843: 'Role is still active. Make sure it is end dated ');
4844: end if;
4845: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
4846: WF_CORE.Token('ROLE',p_name);

Line 4845: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);

4841: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
4842: 'WF_DIRECTORY.deleteRole',
4843: 'Role is still active. Make sure it is end dated ');
4844: end if;
4845: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
4846: WF_CORE.Token('ROLE',p_name);
4847: WF_CORE.Raise('WFDS_ROLE_ACTIVE');
4848: exception
4849: when no_data_found then

Line 4893: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);

4889:
4890:
4891: exception
4892: when others then
4893: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
4894: raise;
4895: end;
4896:
4897:

Line 4936: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);

4932: or(p_rolename is not null and (p_roleOrigSystem is null
4933: or p_roleOrigSystemID is null))) then
4934:
4935: --raise error
4936: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
4937: WF_CORE.Raise('WFSQL_ARGS');
4938:
4939: elsif p_username is null then -- role has been passed
4940: begin

Line 4969: 'WF_DIRECTORY.DeleteUserRole',

4965:
4966: if(wf_log_pkg.level_exception >=
4967: fnd_log.g_current_runtime_level) then
4968: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
4969: 'WF_DIRECTORY.DeleteUserRole',
4970: 'User/Role assignment is still active. Make sure it is end dated ' ||
4971: 'and removed from any hierarchies');
4972: end if;
4973: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);

Line 4973: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);

4969: 'WF_DIRECTORY.DeleteUserRole',
4970: 'User/Role assignment is still active. Make sure it is end dated ' ||
4971: 'and removed from any hierarchies');
4972: end if;
4973: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);
4974: WF_CORE.Token('ROLE',p_rolename);
4975: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
4976: exception
4977: when no_data_found then

Line 5012: 'WF_DIRECTORY.DeleteUserRole',

5008:
5009: if(wf_log_pkg.level_exception >=
5010: fnd_log.g_current_runtime_level) then
5011: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
5012: 'WF_DIRECTORY.DeleteUserRole',
5013: 'User/Role assignment is still active. Make sure it is end dated ' ||
5014: 'and removed from any hierarchies');
5015: end if;
5016: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);

Line 5016: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);

5012: 'WF_DIRECTORY.DeleteUserRole',
5013: 'User/Role assignment is still active. Make sure it is end dated ' ||
5014: 'and removed from any hierarchies');
5015: end if;
5016: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);
5017: WF_CORE.Token('ROLE',p_username);
5018: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5019: exception
5020: when no_data_found then

Line 5063: 'WF_DIRECTORY.DeleteUserRole',

5059:
5060: if(wf_log_pkg.level_exception >=
5061: fnd_log.g_current_runtime_level) then
5062: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
5063: 'WF_DIRECTORY.DeleteUserRole',
5064: 'User/Role assignment is still active. Make sure it is end dated ' ||
5065: 'and removed from any hierarchies');
5066: end if;
5067: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);

Line 5067: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);

5063: 'WF_DIRECTORY.DeleteUserRole',
5064: 'User/Role assignment is still active. Make sure it is end dated ' ||
5065: 'and removed from any hierarchies');
5066: end if;
5067: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5068: WF_CORE.Token('ROLE',p_rolename);
5069: WF_CORE.Token('USER',p_username);
5070: WF_CORE.Raise('WFDS_ASSIGNMENT_ACTIVE');
5071: exception

Line 5091: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);

5087: end;
5088: end if;
5089: exception
5090: when others then
5091: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5092: raise;
5093: end;
5094:
5095:

Line 5096: end Wf_Directory;

5092: raise;
5093: end;
5094:
5095:
5096: end Wf_Directory;