DBA Data[Home] [Help]

APPS.IRC_LOGIN dependencies on HR_UTILITY

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

126: l_loginID number;
127: l_expired varchar2(10);
128: --
129: begin
130: hr_utility.set_location('calling validate_login user_name='||p_user||' and pwd:'||p_pwd||' and disable='||p_disable,10);
131: l_result := fnd_web_sec.validate_login(p_user => p_user,
132: p_pwd => p_pwd);
133: hr_utility.set_location('result='||l_result,20);
134:

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

129: begin
130: hr_utility.set_location('calling validate_login user_name='||p_user||' and pwd:'||p_pwd||' and disable='||p_disable,10);
131: l_result := fnd_web_sec.validate_login(p_user => p_user,
132: p_pwd => p_pwd);
133: hr_utility.set_location('result='||l_result,20);
134:
135: if l_result = 'N' and p_disable = 'Y' then
136: begin
137: hr_utility.set_location('calling disable user',30);

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

133: hr_utility.set_location('result='||l_result,20);
134:
135: if l_result = 'N' and p_disable = 'Y' then
136: begin
137: hr_utility.set_location('calling disable user',30);
138: select user_id into userID
139: from fnd_user
140: where user_name = user AND
141: user_id <> 6 and

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

141: user_id <> 6 and
142: (start_date <= sysdate) AND
143: (end_date is null or end_date > sysdate);
144: fnd_web_sec.unsuccessful_login(userID);
145: hr_utility.set_location('called disable user',40);
146: exception
147: when no_data_found then
148: hr_utility.set_location('No data found',10);
149: return 'N';

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

144: fnd_web_sec.unsuccessful_login(userID);
145: hr_utility.set_location('called disable user',40);
146: exception
147: when no_data_found then
148: hr_utility.set_location('No data found',10);
149: return 'N';
150: end;
151: end if;
152: if l_result = 'Y' and p_disable = 'Y'then

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

149: return 'N';
150: end;
151: end if;
152: if l_result = 'Y' and p_disable = 'Y'then
153: hr_utility.set_location('creating new session loginid='||l_loginID||' expired='||l_expired,10);
154: -- fnd_signon.new_icx_session(userID, l_loginID, l_expired);
155: end if;
156: hr_utility.set_location('final result:='||l_result,40);
157: --

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

152: if l_result = 'Y' and p_disable = 'Y'then
153: hr_utility.set_location('creating new session loginid='||l_loginID||' expired='||l_expired,10);
154: -- fnd_signon.new_icx_session(userID, l_loginID, l_expired);
155: end if;
156: hr_utility.set_location('final result:='||l_result,40);
157: --
158: return l_result;
159: --
160: end validate_login;

Line 166: hr_utility.set_location('calling for user_name'||p_username,10);

162: procedure convertSession(p_token in VARCHAR2,
163: p_username IN VARCHAR2,
164: p_password IN VARCHAR2) is
165: begin
166: hr_utility.set_location('calling for user_name'||p_username,10);
167: OracleApps.convertSession(
168: c_token => p_token
169: ,i_1 => p_username
170: ,i_2 => p_password);

Line 171: hr_utility.set_location('done calling convertsession'||p_username,20);

167: OracleApps.convertSession(
168: c_token => p_token
169: ,i_1 => p_username
170: ,i_2 => p_password);
171: hr_utility.set_location('done calling convertsession'||p_username,20);
172: FND_USER_PKG.UpdateUser (
173: x_user_name => p_username
174: ,x_owner => null
175: ,x_last_logon_date => sysdate

Line 177: hr_utility.set_location('update usre:'||p_username||

173: x_user_name => p_username
174: ,x_owner => null
175: ,x_last_logon_date => sysdate
176: );
177: hr_utility.set_location('update usre:'||p_username||
178: ' with date'||to_char(sysdate,'DD-MON-YYYY hh:mm:ss'),30);
179: end convertSession;
180: --
181: end irc_login;