DBA Data[Home] [Help]

APPS.FND_SIGNON dependencies on FND_PROFILE

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

539: l_audit_level := 'D';
540: else
541: if (FND_GLOBAL.USER_ID = -1) or (FND_GLOBAL.USER_ID = 6) then
542: l_audit_level:=
543: fnd_profile.value_specific('SIGNONAUDIT:LEVEL', UID);
544: else
545: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
546: end if;
547: end if;

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

541: if (FND_GLOBAL.USER_ID = -1) or (FND_GLOBAL.USER_ID = 6) then
542: l_audit_level:=
543: fnd_profile.value_specific('SIGNONAUDIT:LEVEL', UID);
544: else
545: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
546: end if;
547: end if;
548:
549:

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

854:
855: if (l_proxy_user_id is not NULL) then
856: l_audit_level := 'D';
857: else
858: l_audit_level:=fnd_profile.value('SIGNONAUDIT:LEVEL');
859: end if;
860:
861: -- If resp/form level auditing insert record for new resp
862: if (l_audit_level in ('C', 'D')) then

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

920: --
921: -- Bug 3238722: The login_id generated by FND_LOGINS_S is not being recorded in
922: -- FND_LOGINS when a user-level value for the profile option 'Sign-On Audit:Level' is set
923: -- but a site-level value is not. This happens when the audit level value returned by
924: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
925: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
926: -- then the context is not set. If the context is not set, the code should call
927: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for
928: -- the audit level. Once an accurate value for the profile is returned, the login_id will

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

923: -- but a site-level value is not. This happens when the audit level value returned by
924: -- fnd_profile.value returns the site-level when the context is not set. The code needs to
925: -- check if the context is set by an FND_GLOBAL.USER_ID call. If the return value is -1,
926: -- then the context is not set. If the context is not set, the code should call
927: -- fnd_profile.value_specific and pass in the user_id to return an accurate value for
928: -- the audit level. Once an accurate value for the profile is returned, the login_id will
929: -- be properly recorded in FND_LOGINS.
930: --
931:

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

950: if (l_proxy_user_id is not NULL) then
951: l_audit_level := 'D';
952: else
953: if (FND_GLOBAL.USER_ID = -1) OR (FND_GLOBAL.USER_ID = 6) then
954: l_audit_level:= fnd_profile.value_specific('SIGNONAUDIT:LEVEL', user_id);
955: else
956: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
957: end if;
958: end if;

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

952: else
953: if (FND_GLOBAL.USER_ID = -1) OR (FND_GLOBAL.USER_ID = 6) then
954: l_audit_level:= fnd_profile.value_specific('SIGNONAUDIT:LEVEL', user_id);
955: else
956: l_audit_level:= fnd_profile.value('SIGNONAUDIT:LEVEL');
957: end if;
958: end if;
959:
960: