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.41 2010/07/16 04:18:47 dafang 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 837: from wf_directory_partitions_vl

833:
834: select orig_system, display_name
835: into GetRolePartitionInfo.orig_system,
836: GetRolePartitionInfo.display_name
837: from wf_directory_partitions_vl
838: where GetRolePartitionInfo.partition_id <> 1
839: and partition_id = GetRolePartitionInfo.partition_id
840: or GetRolePartitionInfo.partition_id = 1
841: and orig_system = GetRolePartitionInfo.orig_system;

Line 865: from wf_directory_partitions_vl

861:
862: select orig_system, display_name
863: into GetRolePartitionInfo.orig_system,
864: GetRolePartitionInfo.display_name
865: from wf_directory_partitions_vl
866: where GetRolePartitionInfo.partition_id <> 1
867: and partition_id = GetRolePartitionInfo.partition_id
868: or GetRolePartitionInfo.partition_id = 1
869: and orig_system = GetRolePartitionInfo.orig_system;

Line 877: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);

873: partition_id := -1;
874: orig_system := null;
875: display_name := null;
876: when others then
877: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);
878: raise;
879: end;
880: when others then
881: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);

Line 881: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);

877: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);
878: raise;
879: end;
880: when others then
881: wf_core.context('Wf_Directory','GetRolePartitionInfo',role);
882: raise;
883: end GetRolePartitionInfo;
884:
885: --

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

966: exception
967: when no_data_found then
968: return FALSE;
969: when others then
970: wf_core.context('Wf_Directory','IsPerformer',User,Role);
971: raise;
972: end IsPerformer;
973:
974: --

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

982: begin
983: return NULL;
984: exception
985: when others then
986: wf_core.context('Wf_Directory','CurrentUser');
987: raise;
988: end CurrentUser;
989:
990: --

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

1031: exception
1032: when no_data_found then
1033: return FALSE;
1034: when others then
1035: wf_core.context('Wf_Directory','UserActive',Username);
1036: raise;
1037: end UserActive;
1038:
1039: --

Line 1055: if WF_DIRECTORY.UserActive(p_rolename) then

1051: is
1052: colon pls_integer;
1053: dummy pls_integer;
1054: begin
1055: if WF_DIRECTORY.UserActive(p_rolename) then
1056: return TRUE;
1057: end if;
1058: colon := instr(p_rolename, ':');
1059: if (colon = 0) then

Line 1085: wf_core.context('Wf_Directory','RoleActive',p_rolename);

1081: exception
1082: when no_data_found then
1083: return FALSE;
1084: when others then
1085: wf_core.context('Wf_Directory','RoleActive',p_rolename);
1086: raise;
1087: end RoleActive;
1088:
1089: --

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

1115: fetch c_user into p_name, p_display_name;
1116: close c_user;
1117: exception
1118: when others then
1119: wf_core.context('Wf_Directory','GetUserName', p_orig_system,
1120: p_orig_system_id);
1121: raise;
1122: end GetuserName;
1123:

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

1149: fetch c_role into p_name,p_display_name;
1150: close c_role;
1151: exception
1152: when others then
1153: wf_core.context('Wf_Directory','GetRoleName',p_orig_system,p_orig_system);
1154: raise;
1155: end GetRoleName;
1156:
1157: --

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

1311: status=>SetAdHocUserStatus.status);
1312:
1313: exception
1314: when others then
1315: wf_core.context('Wf_Directory', 'SetAdHocUserStatus', user_name, status);
1316: raise;
1317: end SetAdHocUserStatus;
1318:
1319: --

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

1344: status=>SetAdHocRoleStatus.status);
1345:
1346: exception
1347: when others then
1348: wf_core.context('Wf_Directory', 'SetAdHocRoleStatus', role_name, status);
1349: raise;
1350: end SetAdHocRoleStatus;
1351:
1352:

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

1583: l_lastupdlog );
1584:
1585: --If MLS language support is enabled for this orig_system
1586: --then sync the data to _TL table aswell.
1587: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE) AND
1588: (userenv('LANG') <> 'US')) then
1589: insert into WF_LOCAL_ROLES_TL
1590: ( NAME,
1591: ORIG_SYSTEM,

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

1675: CreateUser.orig_system_id));
1676: WF_CORE.Raise('WF_DUP_USER');
1677:
1678: when others then
1679: wf_core.context('Wf_Directory', 'CreateUser', CreateUser.Name,
1680: l_origSys, CreateUser.orig_system_id );
1681: raise;
1682: end CreateUser;
1683:

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

1768:
1769:
1770: exception
1771: when others then
1772: wf_core.context('Wf_Directory', 'CreateAdHocUser');
1773: raise;
1774: end CreateAdHocUser;
1775:
1776:

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

2036: l_creatdt,
2037: l_creatby,
2038: l_lastupdlog );
2039:
2040: if ((WF_DIRECTORY.IsMLSEnabled(l_origSys) = TRUE ) AND
2041: (userenv('LANG') <> 'US')) then
2042: --If the orig_system is MLS enabled then sync the dat into
2043: --the _TL table aswell.
2044: insert into WF_LOCAL_ROLES_TL

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

2082: CreateRole.orig_system_id));
2083: WF_CORE.Raise('WF_DUP_ROLE');
2084:
2085: when others then
2086: wf_core.context('Wf_Directory', 'CreateRole', CreateRole.role_Name,
2087: l_origSys, CreateRole.orig_system_id);
2088: raise;
2089: end CreateRole;
2090:

Line 2124: l_users WF_DIRECTORY.UserTable;

2120: parent_orig_system in varchar2,
2121: parent_orig_system_id in number,
2122: owner_tag in varchar2)
2123: is
2124: l_users WF_DIRECTORY.UserTable;
2125:
2126: begin
2127: --Convert the string to a proper user table.
2128: if (role_users is NOT NULL) then

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

2125:
2126: begin
2127: --Convert the string to a proper user table.
2128: if (role_users is NOT NULL) then
2129: WF_DIRECTORY.string_to_userTable(role_users, l_users);
2130: end if;
2131:
2132: --Pass the call over to the superceding procedure CreateAdHocRole2
2133: WF_DIRECTORY.CreateAdHocRole2(role_name=>CreateAdhocRole.role_name,

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

2129: WF_DIRECTORY.string_to_userTable(role_users, l_users);
2130: end if;
2131:
2132: --Pass the call over to the superceding procedure CreateAdHocRole2
2133: WF_DIRECTORY.CreateAdHocRole2(role_name=>CreateAdhocRole.role_name,
2134: role_display_name=>CreateAdhocRole.role_display_name,
2135: language=>CreateAdhocRole.language,
2136: territory=>CreateAdhocRole.Territory,
2137: role_description=>CreateAdhocRole.role_description,

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

2145: parent_orig_system_id=>CreateAdhocRole.parent_orig_system_id,
2146: owner_tag=>CreateAdhocRole.owner_tag);
2147: exception
2148: when others then
2149: wf_core.context('Wf_Directory', 'CreateAdHocRole');
2150: raise;
2151: end CreateAdHocRole;
2152:
2153: --

Line 2161: -- role_users - WF_DIRECTORY.UserTable

2157: -- role_name -
2158: -- role_display_name -
2159: -- role_description -
2160: -- notification_preference -
2161: -- role_users - WF_DIRECTORY.UserTable
2162: -- language -
2163: -- territory -
2164: -- email_address -
2165: -- fax -

Line 2176: role_users in WF_DIRECTORY.UserTable,

2172: language in varchar2,
2173: territory in varchar2,
2174: role_description in varchar2,
2175: notification_preference in varchar2,
2176: role_users in WF_DIRECTORY.UserTable,
2177: email_address in varchar2,
2178: fax in varchar2,
2179: status in varchar2,
2180: expiration_date in date,

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

2253:
2254:
2255: exception
2256: when others then
2257: wf_core.context('Wf_Directory', 'CreateAdHocRole2');
2258: raise;
2259: end CreateAdHocRole2;
2260:
2261: --

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

2578: eventParams(i).getValue(),l_params);
2579: end loop;
2580: end if;
2581: --determine if BES is enabled
2582: if (wf_directory.System_Status()='DISABLED') then
2583: --Create the event that is to be raised
2584:
2585: wf_event_t.initialize(event);
2586: event.Send_Date := sysdate;

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

2620:
2621:
2622: exception
2623: when others then
2624: wf_core.context('Wf_Directory', 'CreateUserRole',
2625: user_name, role_name, l_uorigSys,
2626: to_char(nvl(user_orig_system_id, l_uorigSysID)),
2627: l_rorigSys, to_char(nvl(role_orig_system_id, l_rorigSysID)));
2628:

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

2973: end loop;
2974: end if;
2975:
2976: --determine if BES is enabled
2977: if (wf_directory.System_Status()='DISABLED') then
2978: --Create the event that is to be raised
2979:
2980: wf_event_t.initialize(event);
2981: event.Send_Date := sysdate;

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

3107: -- user.
3108:
3109: exception
3110: when others then
3111: wf_core.context('Wf_Directory', 'RemoveUserRole',
3112: user_name, role_name, user_orig_system, to_char(user_orig_system_id),
3113: role_orig_system, to_char(role_orig_system_id));
3114:
3115: raise;

Line 3130: l_users WF_DIRECTORY.UserTable;

3126: --
3127: procedure AddUsersToAdHocRole(role_name in varchar2,
3128: role_users in varchar2)
3129: is
3130: l_users WF_DIRECTORY.UserTable;
3131:
3132: begin
3133:
3134: if (role_users is NOT NULL) then

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

3140: end if;
3141:
3142: exception
3143: when others then
3144: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole',
3145: role_name, '"'||role_users||'"');
3146: raise;
3147: end AddUsersToAdHocRole;
3148:

Line 3159: role_users in WF_DIRECTORY.UserTable) is

3155: -- or adhoc users
3156: -- OUT
3157: --
3158: procedure AddUsersToAdHocRole2(role_name in varchar2,
3159: role_users in WF_DIRECTORY.UserTable) is
3160:
3161: d1 pls_integer;
3162: colon pls_integer;
3163: userIND number;

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

3209: wf_core.token('USERNAME', role_users(userIND));
3210: wf_core.raise('WF_INVALID_USER');
3211:
3212: when others then
3213: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2', role_name);
3214: raise;
3215: end;
3216:
3217: -- Check Duplicate

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

3256: end if;
3257:
3258: exception
3259: when others then
3260: wf_core.context('Wf_Directory', 'AddUsersToAdHocRole2',
3261: role_name);
3262: raise;
3263: end AddUsersToAdHocRole2;
3264:

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

3688: p_event_key=>user_name, p_parameters=>l_params);
3689:
3690: exception
3691: when others then
3692: wf_core.context('Wf_Directory', 'SetUserAttr', user_name, display_name);
3693: raise;
3694: end SetUserAttr;
3695:
3696: --

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

3930:
3931: end if;
3932: else --(NOT overWrite)
3933: if ((userenv('LANG') = 'US') OR
3934: (wf_directory.isMLSEnabled(SetRoleAttr.orig_system) = FALSE)) then
3935: update WF_LOCAL_ROLES
3936: set NOTIFICATION_PREFERENCE = nvl(SetRoleAttr.notification_preference,
3937: NOTIFICATION_PREFERENCE),
3938: LANGUAGE = nvl(SetRoleAttr.language, LANGUAGE),

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

4162: p_event_key=>role_name, p_parameters=>l_params);
4163:
4164: exception
4165: when others then
4166: wf_core.context('Wf_Directory', 'SetRoleAttr', SetRoleAttr.role_name,
4167: SetRoleAttr.display_name);
4168: raise;
4169: end SetRoleAttr;
4170:

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

4196: status=>NULL);
4197:
4198: exception
4199: when others then
4200: wf_core.context('Wf_Directory', 'SetAdHocUserExpiration', user_name, expiration_date);
4201: raise;
4202: end SetAdHocUserExpiration;
4203:
4204: --

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

4229: status=>NULL);
4230:
4231: exception
4232: when others then
4233: wf_core.context('Wf_Directory', 'SetAdHocRoleExpiration', role_name,
4234: expiration_date);
4235: raise;
4236: end SetAdHocRoleExpiration;
4237:

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

4279: owner_tag=>SetAdhocUserAttr.owner_tag);
4280:
4281: exception
4282: when others then
4283: wf_core.context('Wf_Directory', 'SetAdHocUserAttr', user_name,
4284: display_name);
4285: raise;
4286: end SetAdHocUserAttr;
4287:

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

4329: owner_tag=>SetAdHocRoleAttr.owner_tag);
4330:
4331: exception
4332: when others then
4333: wf_core.context('Wf_Directory', 'SetAdHocRoleAttr', role_name,
4334: display_name);
4335: raise;
4336: end SetAdHocRoleAttr;
4337:

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

4410: end if;
4411:
4412: exception
4413: when others then
4414: wf_core.context('Wf_Directory', 'RemoveUsersFromAdHocRole',
4415: role_name, '"'||role_users||'"');
4416: raise;
4417: end RemoveUsersFromAdHocRole;
4418:

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

4460: end if;
4461:
4462: exception
4463: when others then
4464: WF_CORE.Context('WF_DIRECTORY', 'ChangeLocalUserName', OldName, NewName);
4465: raise;
4466:
4467: end ChangeLocalUserName;
4468:

Line 4638: FROM WF_DIRECTORY_PARTITIONS

4634: /* We will place PER in FND_USR */
4635:
4636: SELECT Partition_ID, orig_system
4637: INTO g_partitionID, g_partitionName
4638: FROM WF_DIRECTORY_PARTITIONS
4639: WHERE ORIG_SYSTEM = DECODE(g_origSystem, 'PER', 'FND_USR',
4640: g_origSystem)
4641: AND PARTITION_ID IS NOT NULL;
4642:

Line 4653: FROM WF_DIRECTORY_PARTITIONS

4649: if (g_localPartitionID is NULL) then
4650: begin
4651: SELECT Partition_ID, orig_system
4652: INTO g_localPartitionID, g_localPartitionName
4653: FROM WF_DIRECTORY_PARTITIONS
4654: WHERE ORIG_SYSTEM = 'WF_LOCAL_ROLES';
4655:
4656: exception
4657: when NO_DATA_FOUND then

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

4669: p_partitionName := g_partitionName;
4670:
4671: exception
4672: when OTHERS then
4673: WF_CORE.Context('WF_DIRECTORY', 'AssignPartition', p_orig_system);
4674: raise;
4675: end;
4676:
4677: -- Bug 3090738

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

4877: end if;
4878:
4879: --We can use the global variable set in wf_local.syncroles
4880: --but for standalone so as not to introduce dependency on WF_LOCAL
4881: --package we query from wf_directory_partitions directly.
4882: select count(1)
4883: into mls_enabled
4884: from wf_directory_partitions
4885: where orig_system = l_origSys

Line 4884: from wf_directory_partitions

4880: --but for standalone so as not to introduce dependency on WF_LOCAL
4881: --package we query from wf_directory_partitions directly.
4882: select count(1)
4883: into mls_enabled
4884: from wf_directory_partitions
4885: where orig_system = l_origSys
4886: and ROLE_TL_VIEW is not NULL ;
4887: if (mls_enabled = 1) then
4888: return TRUE;

Line 4979: 'WF_DIRECTORY.deleteRole',

4975: -- raise error
4976:
4977: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then
4978: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
4979: 'WF_DIRECTORY.deleteRole',
4980: 'Role is still active. Make sure it is end dated ');
4981: end if;
4982: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
4983: WF_CORE.Token('ROLE',p_name);

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

4978: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
4979: 'WF_DIRECTORY.deleteRole',
4980: 'Role is still active. Make sure it is end dated ');
4981: end if;
4982: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
4983: WF_CORE.Token('ROLE',p_name);
4984: WF_CORE.Raise('WFDS_ROLE_ACTIVE');
4985: exception
4986: when no_data_found then

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

5026:
5027:
5028: exception
5029: when others then
5030: WF_CORE.Context('WF_DIRECTORY', 'deleteRole', p_name);
5031: raise;
5032: end;
5033:
5034:

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

5069: or(p_rolename is not null and (p_roleOrigSystem is null
5070: or p_roleOrigSystemID is null))) then
5071:
5072: --raise error
5073: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5074: WF_CORE.Raise('WFSQL_ARGS');
5075:
5076: elsif p_username is null then -- role has been passed
5077: begin

Line 5106: 'WF_DIRECTORY.DeleteUserRole',

5102:
5103: if(wf_log_pkg.level_exception >=
5104: fnd_log.g_current_runtime_level) then
5105: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
5106: 'WF_DIRECTORY.DeleteUserRole',
5107: 'User/Role assignment is still active. Make sure it is end dated ' ||
5108: 'and removed from any hierarchies');
5109: end if;
5110: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);

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

5106: 'WF_DIRECTORY.DeleteUserRole',
5107: 'User/Role assignment is still active. Make sure it is end dated ' ||
5108: 'and removed from any hierarchies');
5109: end if;
5110: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_rolename);
5111: WF_CORE.Token('ROLE',p_rolename);
5112: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5113: exception
5114: when no_data_found then

Line 5149: 'WF_DIRECTORY.DeleteUserRole',

5145:
5146: if(wf_log_pkg.level_exception >=
5147: fnd_log.g_current_runtime_level) then
5148: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
5149: 'WF_DIRECTORY.DeleteUserRole',
5150: 'User/Role assignment is still active. Make sure it is end dated ' ||
5151: 'and removed from any hierarchies');
5152: end if;
5153: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);

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

5149: 'WF_DIRECTORY.DeleteUserRole',
5150: 'User/Role assignment is still active. Make sure it is end dated ' ||
5151: 'and removed from any hierarchies');
5152: end if;
5153: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username);
5154: WF_CORE.Token('ROLE',p_username);
5155: WF_CORE.Raise('WFDS_USER_ROLE_ACTIVE');
5156: exception
5157: when no_data_found then

Line 5200: 'WF_DIRECTORY.DeleteUserRole',

5196:
5197: if(wf_log_pkg.level_exception >=
5198: fnd_log.g_current_runtime_level) then
5199: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,
5200: 'WF_DIRECTORY.DeleteUserRole',
5201: 'User/Role assignment is still active. Make sure it is end dated ' ||
5202: 'and removed from any hierarchies');
5203: end if;
5204: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);

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

5200: 'WF_DIRECTORY.DeleteUserRole',
5201: 'User/Role assignment is still active. Make sure it is end dated ' ||
5202: 'and removed from any hierarchies');
5203: end if;
5204: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5205: WF_CORE.Token('ROLE',p_rolename);
5206: WF_CORE.Token('USER',p_username);
5207: WF_CORE.Raise('WFDS_ASSIGNMENT_ACTIVE');
5208: exception

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

5224: end;
5225: end if;
5226: exception
5227: when others then
5228: WF_CORE.Context('WF_DIRECTORY', 'DeleteUserRole', p_username,p_rolename);
5229: raise;
5230: end;
5231:
5232:

Line 5233: end Wf_Directory;

5229: raise;
5230: end;
5231:
5232:
5233: end Wf_Directory;