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 FND_LOG

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 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 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 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 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 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 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 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 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 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 4967: fnd_log.g_current_runtime_level) then

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 ' ||
4971: 'and removed from any hierarchies');

Line 5010: fnd_log.g_current_runtime_level) then

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 ' ||
5014: 'and removed from any hierarchies');

Line 5061: fnd_log.g_current_runtime_level) then

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 ' ||
5065: 'and removed from any hierarchies');