DBA Data[Home] [Help]

APPS.ARI_SELF_SERVICE_PKG dependencies on HR_UTILITY

Line 110: hr_utility.set_location('calling validate_login user_name='||p_user||' and pwd:'||p_pwd||' and disable='||p_disable,10);

106: l_loginID number;
107: l_expired varchar2(10);
108: --
109: BEGIN
110: hr_utility.set_location('calling validate_login user_name='||p_user||' and pwd:'||p_pwd||' and disable='||p_disable,10);
111: l_result := fnd_web_sec.validate_login(p_user => p_user,
112: p_pwd => p_pwd);
113: hr_utility.set_location('result='||l_result,20);
114:

Line 113: hr_utility.set_location('result='||l_result,20);

109: BEGIN
110: hr_utility.set_location('calling validate_login user_name='||p_user||' and pwd:'||p_pwd||' and disable='||p_disable,10);
111: l_result := fnd_web_sec.validate_login(p_user => p_user,
112: p_pwd => p_pwd);
113: hr_utility.set_location('result='||l_result,20);
114:
115: if l_result = 'N' and p_disable = 'Y' then
116: begin
117: hr_utility.set_location('calling disable user',30);

Line 117: hr_utility.set_location('calling disable user',30);

113: hr_utility.set_location('result='||l_result,20);
114:
115: if l_result = 'N' and p_disable = 'Y' then
116: begin
117: hr_utility.set_location('calling disable user',30);
118: select user_id into userID
119: from fnd_user
120: where user_name = user AND
121: user_id <> 6 and

Line 125: hr_utility.set_location('called disable user',40);

121: user_id <> 6 and
122: (start_date <= sysdate) AND
123: (end_date is null or end_date > sysdate);
124: fnd_web_sec.unsuccessful_login(userID);
125: hr_utility.set_location('called disable user',40);
126: exception
127: when no_data_found then
128: hr_utility.set_location('No data found',10);
129: return 'N';

Line 128: hr_utility.set_location('No data found',10);

124: fnd_web_sec.unsuccessful_login(userID);
125: hr_utility.set_location('called disable user',40);
126: exception
127: when no_data_found then
128: hr_utility.set_location('No data found',10);
129: return 'N';
130: end;
131: end if;
132: if l_result = 'Y' and p_disable = 'Y'then

Line 133: hr_utility.set_location('creating new session loginid='||l_loginID||' expired='||l_expired,10);

129: return 'N';
130: end;
131: end if;
132: if l_result = 'Y' and p_disable = 'Y'then
133: hr_utility.set_location('creating new session loginid='||l_loginID||' expired='||l_expired,10);
134: -- fnd_signon.new_icx_session(userID, l_loginID, l_expired);
135: end if;
136: hr_utility.set_location('final result:='||l_result,40);
137: --

Line 136: hr_utility.set_location('final result:='||l_result,40);

132: if l_result = 'Y' and p_disable = 'Y'then
133: hr_utility.set_location('creating new session loginid='||l_loginID||' expired='||l_expired,10);
134: -- fnd_signon.new_icx_session(userID, l_loginID, l_expired);
135: end if;
136: hr_utility.set_location('final result:='||l_result,40);
137: --
138: return l_result;
139: --
140: END ValidateLogin;