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_LOG_PKG

Line 364: l_logPROC := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;

360: l_api varchar2(250) := g_plsqlName ||'GetRoleInfo2';
361: l_logPROC boolean := false;
362:
363: begin
364: l_logPROC := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;
365: if( l_logPROC ) then
366: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
367: end if;
368:

Line 366: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');

362:
363: begin
364: l_logPROC := WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level;
365: if( l_logPROC ) then
366: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
367: end if;
368:
369: --Check for composite name.
370: l_isComposite := CompositeName(role, l_origSystem, l_origSystemID);

Line 406: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,

402: );
403:
404: if (role_info_tbl.COUNT = 0 or role_info_tbl(1).display_name is NULL) then
405: if( l_logPROC ) then
406: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,
407: 'no records found by wfa_sec.get_role_info3(), querying *active* roles in other partitions then.');
408: end if;
409:
410: if NOT (l_isComposite) then

Line 412: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'case of no composite name');

408: end if;
409:
410: if NOT (l_isComposite) then
411: if( l_logPROC ) then
412: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'case of no composite name');
413: end if;
414:
415: -- try to select from all the ORIG_SYSTEMs that have no colon.
416: -- we query FNDRESPXXX also since we cannot list all of them here.

Line 453: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'case of composite name, querying with orig_system');

449: and rownum = 1;
450:
451: else
452: if( l_logPROC ) then
453: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'case of composite name, querying with orig_system');
454: end if;
455:
456: select R.NAME,
457: substrb(R.DISPLAY_NAME,1,360),

Line 496: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');

492: role_info_tbl(1).name := role;
493: end if;
494:
495: if( l_logPROC ) then
496: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
497: end if;
498: exception
499: when no_data_found then
500: if( WF_LOG_PKG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 500: if( WF_LOG_PKG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

496: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
497: end if;
498: exception
499: when no_data_found then
500: if( WF_LOG_PKG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
501: wf_log_pkg.String(WF_LOG_PKG.LEVEL_EXCEPTION, l_api,'role not found, querying ALL roles');
502: end if;
503: --If the role is not found in the local tables, we will check the view to make
504: --sure we continue to support standalone which has not denormalized wfds.

Line 501: wf_log_pkg.String(WF_LOG_PKG.LEVEL_EXCEPTION, l_api,'role not found, querying ALL roles');

497: end if;
498: exception
499: when no_data_found then
500: if( WF_LOG_PKG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
501: wf_log_pkg.String(WF_LOG_PKG.LEVEL_EXCEPTION, l_api,'role not found, querying ALL roles');
502: end if;
503: --If the role is not found in the local tables, we will check the view to make
504: --sure we continue to support standalone which has not denormalized wfds.
505: begin

Line 508: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'case of not composite role name');

504: --sure we continue to support standalone which has not denormalized wfds.
505: begin
506: if NOT (l_isComposite) then
507: if( l_logPROC ) then
508: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'case of not composite role name');
509: end if;
510: select R.NAME,
511: substrb(R.DISPLAY_NAME,1,360),
512: substrb(R.DESCRIPTION,1,1000),

Line 543: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'case of composite role name');

539: and R.PARTITION_ID not in (9,8,7,6,4)
540: and rownum = 1;
541: else
542: if( l_logPROC ) then
543: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'case of composite role name');
544: end if;
545:
546: select R.NAME,
547: substrb(R.DISPLAY_NAME,1,360),

Line 581: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');

577: and rownum = 1;
578: end if;
579:
580: if( l_logPROC ) then
581: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
582: end if;
583: exception
584: when NO_DATA_FOUND then
585: if( WF_LOG_PKG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 585: if( WF_LOG_PKG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

581: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
582: end if;
583: exception
584: when NO_DATA_FOUND then
585: if( WF_LOG_PKG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
586: wf_log_pkg.String(WF_LOG_PKG.LEVEL_EXCEPTION, l_api,'role not found again, setting role_info_tbl fields to NULL');
587: end if;
588: role_info_tbl(1).name := '';
589: role_info_tbl(1).display_name := '';

Line 586: wf_log_pkg.String(WF_LOG_PKG.LEVEL_EXCEPTION, l_api,'role not found again, setting role_info_tbl fields to NULL');

582: end if;
583: exception
584: when NO_DATA_FOUND then
585: if( WF_LOG_PKG.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
586: wf_log_pkg.String(WF_LOG_PKG.LEVEL_EXCEPTION, l_api,'role not found again, setting role_info_tbl fields to NULL');
587: end if;
588: role_info_tbl(1).name := '';
589: role_info_tbl(1).display_name := '';
590: role_info_tbl(1).description := '';

Line 615: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');

611: role_info_tbl(1).NLS_SORT :='';
612: role_info_tbl(1).NLS_CURRENCY :='';
613:
614: if( l_logPROC ) then
615: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
616: end if;
617: end;
618:
619: when others then

Line 700: if( WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level ) then

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
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);

Line 701: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');

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

Line 731: if( WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level ) then

727: when NO_DATA_FOUND then
728: p_installed_flag := 'N';
729: end;
730:
731: if( WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level ) then
732: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
733: end if;
734: exception
735: when others then

Line 732: wf_log_pkg.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');

728: p_installed_flag := 'N';
729: end;
730:
731: if( WF_LOG_PKG.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level ) then
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);

Line 4353: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

4349: l_overWriteUserRoles varchar2(2) := 'N';
4350: l_api varchar2(250) := g_plsqlName ||'ReassignUserRoles';
4351:
4352: BEGIN
4353: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4354: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
4355: end if;
4356:
4357: -- <6817561>

Line 4354: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');

4350: l_api varchar2(250) := g_plsqlName ||'ReassignUserRoles';
4351:
4352: BEGIN
4353: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4354: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
4355: end if;
4356:
4357: -- <6817561>
4358: if (p_overWriteUserRoles) then

Line 4439: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

4435: Where USER_ORIG_SYSTEM = p_old_user_origSystem
4436: And USER_ORIG_SYSTEM_ID = p_old_user_origSystemID
4437: And USER_NAME = p_user_name;
4438:
4439: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4440: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
4441: end if;
4442: END ReassignUserRoles;
4443:

Line 4440: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');

4436: And USER_ORIG_SYSTEM_ID = p_old_user_origSystemID
4437: And USER_NAME = p_user_name;
4438:
4439: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4440: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
4441: end if;
4442: END ReassignUserRoles;
4443:
4444:

Line 4670: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

4666: l_origSystemID number;
4667: l_api varchar2(250) := g_plsqlName ||'GetInfoFromMail2';
4668:
4669: begin
4670: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4671: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
4672: end if;
4673:
4674: GetInfoFromMail(mailid => p_emailid,

Line 4671: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');

4667: l_api varchar2(250) := g_plsqlName ||'GetInfoFromMail2';
4668:
4669: begin
4670: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4671: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
4672: end if;
4673:
4674: GetInfoFromMail(mailid => p_emailid,
4675: role => l_name,

Line 4723: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

4719: p_nlsSort := '';
4720: p_nlsCurrency := '';
4721: end if;
4722:
4723: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4724: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
4725: end if;
4726: end GetInfoFromMail2;
4727:

Line 4724: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');

4720: p_nlsCurrency := '';
4721: end if;
4722:
4723: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4724: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
4725: end if;
4726: end GetInfoFromMail2;
4727:
4728: function IsMLSEnabled(p_orig_system in varchar2)

Line 4840: if(wf_log_pkg.level_exception >= fnd_log.g_current_runtime_level) then

4836: --if we have reached here, it implies that the user or role
4837: -- is not truly end dated.
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;

Line 4841: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,

4837: -- is not truly end dated.
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);

Line 4966: if(wf_log_pkg.level_exception >=

4962: --if we have reached here, it implies that the role
4963: -- is not truly end dated.
4964: -- raise error
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 ' ||

Line 4968: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,

4964: -- raise error
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;

Line 5009: if(wf_log_pkg.level_exception >=

5005: --if we have reached here, it implies that the user
5006: -- is not truly end dated.
5007: -- raise error
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 ' ||

Line 5011: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,

5007: -- raise error
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;

Line 5060: if(wf_log_pkg.level_exception >=

5056: --if we have reached here, it implies that the user/role
5057: -- is not truly end dated.
5058: -- raise error
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 ' ||

Line 5062: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_EXCEPTION,

5058: -- raise error
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;