DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_PROFILE

Line 519: fnd_profile.value_specific('SIGNONAUDIT:LEVEL', UID);

515: l_audit_level := 'D';
516: else
517: if (FND_GLOBAL.USER_ID = -1) or (FND_GLOBAL.USER_ID = 6) then
518: l_audit_level:=
519: fnd_profile.value_specific('SIGNONAUDIT:LEVEL', UID);
520: else
521: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
522: end if;
523: end if;

Line 521: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');

517: if (FND_GLOBAL.USER_ID = -1) or (FND_GLOBAL.USER_ID = 6) then
518: l_audit_level:=
519: fnd_profile.value_specific('SIGNONAUDIT:LEVEL', UID);
520: else
521: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
522: end if;
523: end if;
524:
525:

Line 834: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');

830:
831: if (l_proxy_user_id is not NULL) then
832: l_audit_level := 'D';
833: else
834: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
835: end if;
836:
837: -- If resp/form level auditing insert record for new resp
838: if (l_audit_level in ('C', 'D')) then

Line 900: -- fnd_profile.value returns the site-level when the context is not set. The code needs to

896: --
897: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in
898: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set
899: -- but a site-level value is not. This happens when the audit level value returned by
900: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
901: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
902: -- then the context is not set. If the context is not set, the code should call
903: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for
904: -- the audit level. Once an accurate value for the profile is returned, the login_id will

Line 903: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for

899: -- but a site-level value is not. This happens when the audit level value returned by
900: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
901: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
902: -- then the context is not set. If the context is not set, the code should call
903: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for
904: -- the audit level. Once an accurate value for the profile is returned, the login_id will
905: -- be properly recorded in FND_LOGINS.
906: --
907:

Line 930: l_audit_level:= fnd_profile.value_specific('SIGNONAUDIT:LEVEL', user_id);

926: if (l_proxy_user_id is not NULL) then
927: l_audit_level := 'D';
928: else
929: if (FND_GLOBAL.USER_ID = -1) OR (FND_GLOBAL.USER_ID = 6) then
930: l_audit_level:= fnd_profile.value_specific('SIGNONAUDIT:LEVEL', user_id);
931: else
932: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
933: end if;
934: end if;

Line 932: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');

928: else
929: if (FND_GLOBAL.USER_ID = -1) OR (FND_GLOBAL.USER_ID = 6) then
930: l_audit_level:= fnd_profile.value_specific('SIGNONAUDIT:LEVEL', user_id);
931: else
932: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
933: end if;
934: end if;
935:
936: