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 4501: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then

4497: l_overWriteUserRoles varchar2(2) := 'N';
4498: l_api varchar2(250) := g_plsqlName ||'ReassignUserRoles';
4499:
4500: BEGIN
4501: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4502: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
4503: end if;
4504:
4505: -- <6817561>

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

4585: Where USER_ORIG_SYSTEM = p_old_user_origSystem
4586: And USER_ORIG_SYSTEM_ID = p_old_user_origSystemID
4587: And USER_NAME = p_user_name;
4588:
4589: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4590: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
4591: end if;
4592: END ReassignUserRoles;
4593:

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

4803: l_origSystemID number;
4804: l_api varchar2(250) := g_plsqlName ||'GetInfoFromMail2';
4805:
4806: begin
4807: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4808: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'BEGIN');
4809: end if;
4810:
4811: GetInfoFromMail(mailid => p_emailid,

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

4856: p_nlsSort := '';
4857: p_nlsCurrency := '';
4858: end if;
4859:
4860: if(wf_log_pkg.LEVEL_PROCEDURE >= fnd_log.g_current_runtime_level) then
4861: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE, l_api,'END');
4862: end if;
4863: end GetInfoFromMail2;
4864:

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

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

Line 5104: fnd_log.g_current_runtime_level) then

5100: -- is not truly end dated.
5101: -- raise error
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');

Line 5147: fnd_log.g_current_runtime_level) then

5143: -- is not truly end dated.
5144: -- raise error
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');

Line 5198: fnd_log.g_current_runtime_level) then

5194: -- is not truly end dated.
5195: -- raise error
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');