73: l_pwd := x_unencrypted_password;
74: pwdCaseOpt := null;
75: -- Bug 5162136 Note: Creating user so use SITE level profile value.
76: -- Bug 8664441 - pass in initial values for the security context to ensure the site value is used.
77: pwdCaseOpt := fnd_profile.value_specific(name =>'SIGNON_PASSWORD_CASE',
78: user_id => -1,
79: responsibility_id => -1,
80: application_id => -1,
81: org_id => -1,
2385: LOOP
2386: FETCH existing_users INTO old_desc, old_email, old_fax, my_user, my_user_id;
2387: EXIT WHEN existing_users%NOTFOUND;
2388:
2389: fnd_profile.get_specific(name_z => 'APPS_SSO_LDAP_SYNC',
2390: user_id_z => my_user_id,
2391: val_z => l_allow_sync,
2392: defined_z => l_profile_defined);
2393:
2390: user_id_z => my_user_id,
2391: val_z => l_allow_sync,
2392: defined_z => l_profile_defined);
2393:
2394: fnd_profile.get_specific(name_z => 'APPS_SSO_LOCAL_LOGIN',
2395: user_id_z => my_user_id,
2396: val_z => l_local_login,
2397: defined_z => l_profile_defined);
2398:
2812: -- end bug 2504562
2813:
2814: --
2815: -- Added calls for the lang/territory and notification preference.
2816: fnd_profile.get_specific(name_z=>'ICX_LANGUAGE', user_id_z=>my_userid,
2817: val_z=>myLang, defined_z=>l_defined_z);
2818: wf_event.AddParameterToList('PREFERREDLANGUAGE', myLang, myList);
2819:
2820: fnd_profile.get_specific(name_z=>'ICX_TERRITORY', user_id_z=>my_userid,
2816: fnd_profile.get_specific(name_z=>'ICX_LANGUAGE', user_id_z=>my_userid,
2817: val_z=>myLang, defined_z=>l_defined_z);
2818: wf_event.AddParameterToList('PREFERREDLANGUAGE', myLang, myList);
2819:
2820: fnd_profile.get_specific(name_z=>'ICX_TERRITORY', user_id_z=>my_userid,
2821: val_z=>myTerr, defined_z=>l_defined_z);
2822:
2823: wf_event.AddParameterToList('ORCLNLSTERRITORY', myTerr, myList);
2824:
4292: end;
4293:
4294: if (retval = 1) then
4295: -- The above check return that user exists in oid.
4296: fnd_profile.get('APPS_SSO_LINK_SAME_NAMES', pf);
4297:
4298: if(pf = 'Y') then
4299: fnd_message.set_name('FND', 'FND_USER_SYNCHED');
4300: fnd_message.set_token('USER_NAME', x_user_name);
4439: -- the site level profile value.
4440: /* Code change for bug 7043484 */
4441: isOverrideFuncAssigned := fnd_function.test('OVERRIDE_PASSWORD_POLICY_PERM','N');
4442: if(isOverrideFuncAssigned = true) then
4443: pwdCaseOpt := fnd_profile.value('SIGNON_PASSWORD_CASE');
4444: else
4445: pwdCaseOpt := fnd_profile.value_specific('SIGNON_PASSWORD_CASE', userid);
4446: end if;
4447: if (pwdCaseOpt is null) or (pwdCaseOpt = '1') then
4441: isOverrideFuncAssigned := fnd_function.test('OVERRIDE_PASSWORD_POLICY_PERM','N');
4442: if(isOverrideFuncAssigned = true) then
4443: pwdCaseOpt := fnd_profile.value('SIGNON_PASSWORD_CASE');
4444: else
4445: pwdCaseOpt := fnd_profile.value_specific('SIGNON_PASSWORD_CASE', userid);
4446: end if;
4447: if (pwdCaseOpt is null) or (pwdCaseOpt = '1') then
4448: l_pwd := lower(x_unencrypted_password);
4449: end if;