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.ZPB_USER_UPDATE dependencies on FND_LOG

Line 211: b_writetolog := (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);

207: and c.responsibility_key = g.subject_name;
208:
209: begin
210: -- check logging requirement for this module
211: b_writetolog := (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
212: --FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME);
213:
214: -- loop for adding users to the Catalog from the fnd_user table
215: for each in usernames loop

Line 212: --FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME);

208:
209: begin
210: -- check logging requirement for this module
211: b_writetolog := (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
212: --FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME);
213:
214: -- loop for adding users to the Catalog from the fnd_user table
215: for each in usernames loop
216: if length(each.name) <= n_namelength then

Line 237: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

233: insert into bism_subjects (subject_id, subject_name, subject_type) values (t_newguid,each.name,'u');
234: insert into bism_groups (user_id, group_id) values(t_newguid,t_newguid);
235:
236: if (b_writetolog) then
237: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
238: 'User with name '|| each.name||' has been added successfully');
239: end if;
240: else
241: if t_subjecttype = 'g' then

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

239: end if;
240: else
241: if t_subjecttype = 'g' then
242: if (b_writetolog) then
243: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
244: 'A group already exists with name '|| each.name);
245: end if;
246: else
247: if (b_writetolog) then

Line 248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

244: 'A group already exists with name '|| each.name);
245: end if;
246: else
247: if (b_writetolog) then
248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
249: 'User '|| each.name ||' already exists');
250: end if;
251: end if;
252: end if;

Line 261: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

257:
258: for eachgroup in groups loop
259: if length(eachgroup.role)>n_namelength then
260: if (b_writetolog) then
261: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
262: eachgroup.role||' can not be added to the Catalog because it has more than n_namelength chars');
263: end if;
264: else
265: begin

Line 292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

288: -- give user some default privileges
289: insert into bism_permissions(subject_id, object_id, privilege) values(t_newguid, t_objectid, n_writepermission);
290:
291: if (b_writetolog) then
292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
293: 'Group with name '|| eachgroup.role||' has been added successfully');
294: end if;
295: else
296: if t_subjecttype = 'u' then

Line 298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

294: end if;
295: else
296: if t_subjecttype = 'u' then
297: if (b_writetolog) then
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
299: 'A user already exists with name '|| eachgroup.role);
300: end if;
301: else
302: if (b_writetolog) then

Line 303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

299: 'A user already exists with name '|| eachgroup.role);
300: end if;
301: else
302: if (b_writetolog) then
303: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
304: 'Group '|| eachgroup.role ||' already exists');
305: end if;
306: end if;
307: end if;

Line 404: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

400:
401: -- only users can belong to groups
402: if t_subjecttype1 <> 'u' then
403: if (b_writetolog) then
404: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
405: eachgrant.grantee||' is not a user. It can not be added to a group');
406: end if;
407: elsif t_subjecttype2 <> 'g' then
408: if (b_writetolog) then

Line 409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

405: eachgrant.grantee||' is not a user. It can not be added to a group');
406: end if;
407: elsif t_subjecttype2 <> 'g' then
408: if (b_writetolog) then
409: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
410: eachgrant.granted_role||' is not a group. Users can not be added to it');
411: end if;
412: else
413: if t_subid1 is not null and t_subid2 is not null then

Line 439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME, 'A new user ' ||eachgrant.grantee||

435: and resp_id = eachgrant.responsibility_id
436: and business_area_id = p_business_area_id;
437: if SQL%NOTFOUND then
438: if (b_writetolog) then
439: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME, 'A new user ' ||eachgrant.grantee||
440: ' will be added to the group '|| eachgrant.granted_role);
441: end if;
442: else
443: if (b_writetolog) then

Line 444: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME, 'The existing user-group entry '||

440: ' will be added to the group '|| eachgrant.granted_role);
441: end if;
442: else
443: if (b_writetolog) then
444: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME, 'The existing user-group entry '||
445: eachgrant.grantee||' - '|| eachgrant.granted_role || ' will be overwritten');
446: end if;
447: end if;
448:

Line 479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

475: SYSDATE);
476: end if;
477:
478: if (b_writetolog) then
479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
480: 'User '||eachgrant.grantee||' has been added to the group '|| eachgrant.granted_role);
481: end if;
482: else
483: if (b_writetolog) then

Line 484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

480: 'User '||eachgrant.grantee||' has been added to the group '|| eachgrant.granted_role);
481: end if;
482: else
483: if (b_writetolog) then
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
485: 'Subject ids are null for the relationship between '||eachgrant.grantee||
486: ' and '||eachgrant.granted_role);
487: end if;
488: end if;

Line 494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

490:
491: exception
492: when no_data_found then
493: if (b_writetolog) then
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
495: 'Either user '||eachgrant.grantee||' does not exist or group '||
496: eachgrant.granted_role||' does not exist');
497: end if;
498: end;

Line 539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

535: and account_status <> HIDE_ACCOUNT;
536: --end if;
537:
538: if (b_writetolog) then
539: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
540: 'Deleted '||eachdeleted.subject_name);
541: end if;
542:
543: end loop;

Line 564: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

560: and account_status <> CURRENT_USER
561: and business_area_id = p_business_area_id;
562:
563: if (b_writetolog) then
564: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
565: 'Reinstated '||eachreinstated.subject_name);
566: end if;
567: end loop;
568:

Line 597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

593: and business_area_id = p_business_area_id
594: and not(account_status = EXP_USER or account_status = HIDE_ACCOUNT);
595:
596: if (b_writetolog) then
597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
598: 'Deleted relationship between user '||eachrevoked.uname||' and group '||eachrevoked.gname);
599: end if;
600: end loop;
601:

Line 625: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,

621: and group_id = t_subid2
622: and business_area_id = p_business_area_id;
623:
624: if (b_writetolog) then
625: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, MODULE_NAME,
626: 'Reinstated '||eachreinstatedrole.uname||'-'||eachreinstatedrole.gname);
627: end if;
628: end loop;
629: