[Home] [Help]
1027: --
1028: --
1029: -- Get the business group id from profile
1030: --
1031: l_business_group_id := fnd_profile.value('IRC_REGISTRATION_BG_ID');
1032: --
1033: if l_business_group_id is null then
1034: fnd_message.set_name('PER','IRC_412155_REG_BG_NOT_SET');
1035: fnd_message.raise_error;
1513: -- Process Logic
1514: --
1515: --
1516: -- Set profile option
1517: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
1518: hr_utility.set_location(l_proc, 40);
1519: --
1520: -- Added for turn off key flex field validation
1521: --
1955: where paaf.vacancy_id = p_vacancy_id and paaf.assignment_type = 'A'
1956: and p_effective_date between PAAF.EFFECTIVE_START_DATE
1957: AND PAAF.EFFECTIVE_END_DATE
1958: and paaf.VACANCY_ID = AGV1.VACANCY_ID
1959: and AGV1.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME')
1960: and per1.person_id=paaf.person_id
1961: and p_effective_date between per1.effective_start_date and per1.effective_end_date
1962: and per1.party_id=prefs.party_id
1963: and prefs.agency_id=agv1.agency_id
1967: cursor csr_application_count_limit(p_vacancy_id number) is
1968: select AGV.MAX_ALLOWED_APPLICANTS
1969: from IRC_AGENCY_VACANCIES AGV
1970: where agv.vacancy_id = p_vacancy_id
1971: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');
1972: --
1973: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;
1974: l_application_count Number;
1975: l_agency_id IRC_AGENCY_VACANCIES.AGENCY_ID%TYPE;
1976: begin
1977: --
1978: -- only check if Agency profile is set
1979: --
1980: if ( FND_PROFILE.VALUE('IRC_AGENCY_NAME') is not null ) then
1981: --
1982: -- get the applicant count limit for the vacancy
1983: --
1984: open csr_application_count_limit(p_vacancy_id);
1985: fetch csr_application_count_limit into l_application_count_limit;
1986: --
1987: if ( csr_application_count_limit%found ) then
1988: if ( l_application_count_limit is null ) then
1989: l_application_count_limit := FND_PROFILE.VALUE('IRC_MAX_APPLICANTS_DFT');
1990: end if;
1991: end if;
1992: close csr_application_count_limit;
1993: --
2923: hr_utility.set_location(l_proc,30);
2924: --
2925: -- set the language profile option
2926: --
2927: l_profile_check := fnd_profile.save (
2928: x_name => 'ICX_LANGUAGE',
2929: x_value => p_language,
2930: x_level_name => 'USER',
2931: x_level_value => l_user_id );
2948: hr_utility.set_location(l_proc,50);
2949: --
2950: -- look to see if we are using multiple security groups
2951: --
2952: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
2953: hr_utility.set_location(l_proc,60);
2954: l_sec_profile_id:=fnd_profile.value_specific
2955: (name=>'PER_SECURITY_PROFILE_ID'
2956: ,user_id=>l_user_id
2950: -- look to see if we are using multiple security groups
2951: --
2952: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
2953: hr_utility.set_location(l_proc,60);
2954: l_sec_profile_id:=fnd_profile.value_specific
2955: (name=>'PER_SECURITY_PROFILE_ID'
2956: ,user_id=>l_user_id
2957: ,responsibility_id=>p_responsibility_id
2958: ,application_id=>p_resp_appl_id);
2955: (name=>'PER_SECURITY_PROFILE_ID'
2956: ,user_id=>l_user_id
2957: ,responsibility_id=>p_responsibility_id
2958: ,application_id=>p_resp_appl_id);
2959: l_business_group_id:=fnd_profile.value_specific
2960: (name=>'PER_BUSINESS_GROUP_ID'
2961: ,user_id=>l_user_id
2962: ,responsibility_id=>p_responsibility_id
2963: ,application_id=>p_resp_appl_id);
2978: hr_utility.set_location(l_proc,90);
2979: --
2980: -- Assign the grant to the User
2981: --
2982: l_menu_name:=fnd_profile.value_specific
2983: (name=>'IRC_CANDIDATE_PSET'
2984: ,user_id=>l_user_id
2985: ,responsibility_id=>p_responsibility_id
2986: ,application_id=>p_resp_appl_id);
3080: l_start_date := trunc(p_start_date);
3081: --
3082: -- default Allow Access if input value is NULL
3083: --
3084: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));
3085: --
3086: -- Call Before Process User Hook
3087: --
3088: begin
3377: open csr_get_email(p_user_name);
3378: fetch csr_get_email into l_current_email_address;
3379: close csr_get_email;
3380: --
3381: l_central_registration_url:=fnd_profile.value('APPS_CENTRAL_REGISTER_URL');
3382: --
3383: if l_central_registration_url is null then
3384: --
3385: fnd_user_pkg.UpdateUser (
3515: select per1.person_id
3516: from per_all_people_f per1
3517: where per1.party_id=p_party_id
3518: and trunc(sysdate) between per1.effective_start_date and per1.effective_end_date
3519: and per1.business_group_id = fnd_profile.value('IRC_REGISTRATION_BG_ID');
3520:
3521: l_person_id number;
3522:
3523: cursor has_notification_prefs(p_party_id number) is
3666: --
3667: -- default Allow Access if input value is NULL
3668: --
3669: if p_allow_access is NULL then
3670: l_allow_access := nvl(fnd_profile.value_specific
3671: (name=>'IRC_VISIBLE_PREF_DEFAULT'
3672: ,responsibility_id=>p_responsibility_id
3673: ,application_id=>p_resp_appl_id), 'N');
3674: else
3941: --
3942: -- Get the Password Length from the profile
3943: --
3944: begin
3945: if fnd_profile.value('SIGNON_PASSWORD_LENGTH') is not null then
3946: l_password_length := fnd_profile.value('SIGNON_PASSWORD_LENGTH');
3947: else
3948: l_password_length := l_min_password_length;
3949: end if;
3942: -- Get the Password Length from the profile
3943: --
3944: begin
3945: if fnd_profile.value('SIGNON_PASSWORD_LENGTH') is not null then
3946: l_password_length := fnd_profile.value('SIGNON_PASSWORD_LENGTH');
3947: else
3948: l_password_length := l_min_password_length;
3949: end if;
3950: exception
4043: end if;
4044:
4045: -- set the language prefs if required
4046: if (p_language is not null) then
4047: l_profile_check := fnd_profile.save (
4048: x_name => 'ICX_LANGUAGE',
4049: x_value => l_nls_language,
4050: x_level_name => 'USER',
4051: x_level_value => l_user_id );
4077: hr_utility.set_location(l_proc,180);
4078: --
4079: -- look to see if we are using multiple security groups
4080: --
4081: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4082: hr_utility.set_location(l_proc,190);
4083: l_sec_profile_id:=fnd_profile.value_specific
4084: (name=>'PER_SECURITY_PROFILE_ID'
4085: ,user_id=>l_user_id
4079: -- look to see if we are using multiple security groups
4080: --
4081: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4082: hr_utility.set_location(l_proc,190);
4083: l_sec_profile_id:=fnd_profile.value_specific
4084: (name=>'PER_SECURITY_PROFILE_ID'
4085: ,user_id=>l_user_id
4086: ,responsibility_id=>p_responsibility_id
4087: ,application_id=>p_resp_appl_id);
4084: (name=>'PER_SECURITY_PROFILE_ID'
4085: ,user_id=>l_user_id
4086: ,responsibility_id=>p_responsibility_id
4087: ,application_id=>p_resp_appl_id);
4088: l_business_group_id2:=fnd_profile.value_specific
4089: (name=>'PER_BUSINESS_GROUP_ID'
4090: ,user_id=>l_user_id
4091: ,responsibility_id=>p_responsibility_id
4092: ,application_id=>p_resp_appl_id);
4126: --
4127: -- now send an e-mail to the user confirming that this has been done
4128: --
4129: hr_utility.set_location(l_proc,220);
4130: l_sso_enabled:=fnd_profile.value('APPS_SSO');
4131:
4132: l_central_registration_url:=fnd_profile.value('APPS_CENTRAL_REGISTER_URL');
4133:
4134: l_nid:=wf_notification.send( upper(p_current_email_address)
4128: --
4129: hr_utility.set_location(l_proc,220);
4130: l_sso_enabled:=fnd_profile.value('APPS_SSO');
4131:
4132: l_central_registration_url:=fnd_profile.value('APPS_CENTRAL_REGISTER_URL');
4133:
4134: l_nid:=wf_notification.send( upper(p_current_email_address)
4135: , fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE')
4136: , 'IRC_TEXT_HTML_MSG'
4131:
4132: l_central_registration_url:=fnd_profile.value('APPS_CENTRAL_REGISTER_URL');
4133:
4134: l_nid:=wf_notification.send( upper(p_current_email_address)
4135: , fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE')
4136: , 'IRC_TEXT_HTML_MSG'
4137: );
4138: --
4139: fnd_message.set_name('PER','IRC_EXEMP_SUBJECT');
4412: hr_utility.set_location(l_proc, 20);
4413: --
4414: -- default Allow Access if input value is NULL
4415: --
4416: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));
4417: --
4418: open get_person_party_info;
4419: fetch get_person_party_info into l_user_id, l_person_id, l_person_party_id;
4420: close get_person_party_info;
4477: ,x_employee_id => l_person_id);
4478: --
4479: hr_utility.set_location(l_proc, 60);
4480: --
4481: l_profile_check := fnd_profile.save (
4482: x_name => 'ICX_LANGUAGE',
4483: x_value => l_nls_language,
4484: x_level_name => 'USER',
4485: x_level_value => l_user_id );
4582: hr_utility.set_location(l_proc, 100);
4583: --
4584: -- look to see if we are using multiple security groups
4585: --
4586: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4587: l_sec_profile_id:=fnd_profile.value_specific
4588: (name=>'PER_SECURITY_PROFILE_ID'
4589: ,user_id=>l_user_id
4590: ,responsibility_id=>p_responsibility_id
4583: --
4584: -- look to see if we are using multiple security groups
4585: --
4586: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4587: l_sec_profile_id:=fnd_profile.value_specific
4588: (name=>'PER_SECURITY_PROFILE_ID'
4589: ,user_id=>l_user_id
4590: ,responsibility_id=>p_responsibility_id
4591: ,application_id=>p_resp_appl_id);
4588: (name=>'PER_SECURITY_PROFILE_ID'
4589: ,user_id=>l_user_id
4590: ,responsibility_id=>p_responsibility_id
4591: ,application_id=>p_resp_appl_id);
4592: l_business_group_id:=fnd_profile.value_specific
4593: (name=>'PER_BUSINESS_GROUP_ID'
4594: ,user_id=>l_user_id
4595: ,responsibility_id=>p_responsibility_id
4596: ,application_id=>p_resp_appl_id);
4626: -- REVISIT, what about Security Profile Assignment
4627: end if;
4628: --
4629: -- check if User has access to Candidate Homepage function
4630: l_function_name:=fnd_profile.value_specific
4631: (name=>'IRC_HOME_PAGE_FUNCTION'
4632: ,user_id=>l_user_id
4633: ,responsibility_id=>p_responsibility_id
4634: ,application_id=>p_resp_appl_id);
4635: l_func_check := fnd_data_security.check_function(1.0,l_function_name,
4636: 'GLOBAL',null,null,null,null,null,upper(p_user_name));
4637: -- if user doesn't have the access, create the Grant
4638: if l_func_check <> 'T' then
4639: l_menu_name:=fnd_profile.value_specific
4640: (name=>'IRC_CANDIDATE_PSET'
4641: ,user_id=>l_user_id
4642: ,responsibility_id=>p_responsibility_id
4643: ,application_id=>p_resp_appl_id);
4778: return 'NO_PROFILE';
4779: end if;
4780: close get_user_responsibility;
4781: -- check if User has access to Candidate Homepage function
4782: l_function_name:=fnd_profile.value_specific
4783: (name=>'IRC_HOME_PAGE_FUNCTION'
4784: ,user_id=>l_user_id
4785: ,responsibility_id=>p_responsibility_id
4786: ,application_id=>p_resp_appl_id);
4879: );
4880: hr_utility.set_location(l_proc, 25);
4881: -- fix for bug 4765406
4882: -- set the profile to SSO
4883: l_found := fnd_profile.save(x_name => 'APPS_SSO_LOCAL_LOGIN'
4884: , x_value => 'SSO'
4885: , x_level_name => 'USER'
4886: , x_level_value => l_user_id);
4887:
4980: hr_utility.set_location(l_proc, 100);
4981: --
4982: -- look to see if we are using multiple security groups
4983: --
4984: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4985: l_sec_profile_id:=fnd_profile.value_specific
4986: (name=>'PER_SECURITY_PROFILE_ID'
4987: ,user_id=>p_user_id
4988: ,responsibility_id=>p_responsibility_id
4981: --
4982: -- look to see if we are using multiple security groups
4983: --
4984: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4985: l_sec_profile_id:=fnd_profile.value_specific
4986: (name=>'PER_SECURITY_PROFILE_ID'
4987: ,user_id=>p_user_id
4988: ,responsibility_id=>p_responsibility_id
4989: ,application_id=>p_resp_appl_id);
4986: (name=>'PER_SECURITY_PROFILE_ID'
4987: ,user_id=>p_user_id
4988: ,responsibility_id=>p_responsibility_id
4989: ,application_id=>p_resp_appl_id);
4990: l_business_group_id:=fnd_profile.value_specific
4991: (name=>'PER_BUSINESS_GROUP_ID'
4992: ,user_id=>p_user_id
4993: ,responsibility_id=>p_responsibility_id
4994: ,application_id=>p_resp_appl_id);
5096: hr_utility.set_location(l_proc, 100);
5097: --
5098: -- look to see if we are using multiple security groups
5099: --
5100: if(fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
5101: l_sec_profile_id:=fnd_profile.value_specific
5102: (name=>'PER_SECURITY_PROFILE_ID'
5103: ,user_id=>p_user_id
5104: ,responsibility_id=>p_resp_id
5097: --
5098: -- look to see if we are using multiple security groups
5099: --
5100: if(fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
5101: l_sec_profile_id:=fnd_profile.value_specific
5102: (name=>'PER_SECURITY_PROFILE_ID'
5103: ,user_id=>p_user_id
5104: ,responsibility_id=>p_resp_id
5105: ,application_id=>p_resp_appl_id);
5102: (name=>'PER_SECURITY_PROFILE_ID'
5103: ,user_id=>p_user_id
5104: ,responsibility_id=>p_resp_id
5105: ,application_id=>p_resp_appl_id);
5106: l_business_group_id:=fnd_profile.value_specific
5107: (name=>'PER_BUSINESS_GROUP_ID'
5108: ,user_id=>p_user_id
5109: ,responsibility_id=>p_resp_id
5110: ,application_id=>p_resp_appl_id);
5241: , new_key =>'LOADER' );
5242: --
5243: -- set the language profile option
5244: --
5245: l_profile_check := fnd_profile.save (
5246: x_name => 'ICX_LANGUAGE',
5247: x_value => p_language,
5248: x_level_name => 'USER',
5249: x_level_value => l_user_id );
5317: ) IS
5318: --
5319: l_password_check varchar2(1);
5320: l_password_change_check varchar2(1);
5321: l_customer_pwd_check fnd_profile_option_values.profile_option_value%type;
5322: l_allow_access irc_notification_preferences.allow_access%type;
5323: l_start_date date;
5324: cursor get_nls_language is
5325: select nls_language
5335: l_start_date := trunc(p_start_date);
5336: --
5337: -- default Allow Access if input value is NULL
5338: --
5339: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));
5340: --
5341: -- Call Before Process User Hook
5342: --
5343: begin
5401: else
5402: close get_nls_language;
5403: end if;
5404: --
5405: l_customer_pwd_check := nvl(fnd_profile.value('SIGNON_PASSWORD_CUSTOM'),'N');
5406: IF l_customer_pwd_check = 'N' THEN
5407: -- Validate the password
5408: --
5409: l_password_check := fnd_web_sec.validate_password(username => p_user_name