[Home] [Help]
3031: end if;
3032: --
3033: -- Validate the password
3034: --
3035: l_password_check := fnd_web_sec.validate_password(username => p_user_name
3036: ,password => p_password);
3037:
3038: if (l_password_check = 'N') then
3039: fnd_message.raise_error;
3180: guestEncFndPwd fnd_user.encrypted_foundation_password%type;
3181: --
3182: begin
3183: --
3184: guestUserPwd := upper(FND_WEB_SEC.GET_GUEST_USERNAME_PWD());
3185: --
3186: delim := instr(guestUserPwd,'/');
3187: --
3188: if(delim = 0) then
3191: guestUserName := upper(substr(guestUserPwd,1,delim-1));
3192: guestUserPwdOnly := upper(substr(guestUserPwd,delim+1));
3193: end if;
3194: --
3195: if(fnd_web_sec.validate_login(guestUserName,guestUserPwdOnly) = 'N') then
3196: raise bad_guest_user;
3197: end if;
3198: --
3199: open get_pwd(guestUserName);
4635: hr_utility.set_location(l_proc, 50);
4636: --
4637: -- this case happens when user is present in SSO and applied for a job through
4638: -- HA and for this we have to create a local user who points to SSO user
4639: -- note that we are passing in FND_WEB_SEC.EXTERNAL_PWD which is checked by
4640: -- ATG routine and treats this as an SSO user
4641: elsif l_num = 3 then
4642: hr_utility.set_location(l_proc, 15);
4643: l_user_id := fnd_user_pkg.CreateUserId(
4642: hr_utility.set_location(l_proc, 15);
4643: l_user_id := fnd_user_pkg.CreateUserId(
4644: x_user_name => p_user_name
4645: ,x_owner => 'CUST'
4646: ,x_unencrypted_password => FND_WEB_SEC.EXTERNAL_PWD
4647: ,x_email_address => p_email
4648: ,x_user_guid => p_user_guid
4649: );
4650: hr_utility.set_location(l_proc, 25);
5169: end if;
5170: --
5171: -- Validate the password
5172: --
5173: l_password_check := fnd_web_sec.validate_password(username => p_user_name
5174: ,password => p_password);
5175:
5176: if (l_password_check = 'N') then
5177: fnd_message.raise_error;