[Home] [Help]
2118: -- for the system_person_type is stored in per_person_type_usages_f table.
2119: -- Since the current Personal Information Basic Details region and the
2120: -- New Hire page does not allow a user to choose any user flavor, so we'll
2121: -- zap the p_person_type_id to hr_api.g_number value when it is not an
2122: -- applicant when calling the hr_person_api.update_person. That way, the api
2123: -- will understand that the person_type is not changed and will not update
2124: -- the person_type_id in per_person_type_usages_f table as is. If we pass
2125: -- the per_all_people_f.person_type_id to the api, the person_type_id in
2126: -- per_person_type_usages_f table will be updated with that value which will
2344: nvl(l_current_employee_flag, 'N') <> 'Y' AND
2345: nvl(l_current_npw_flag, 'N') <> 'Y')
2346: then
2347: if(p_ni_duplicate_warn_or_err <> 'IGNORE') then
2348: hr_person_info_util_ss.check_ni_unique(
2349: p_national_identifier => p_national_identifier
2350: ,p_business_group_id => p_business_group_id
2351: ,p_person_id => p_person_id
2352: ,p_ni_duplicate_warn_or_err => p_ni_duplicate_warn_or_err);
2353: end if;
2354:
2355: if(p_validate_ni <> 'IGNORE') then
2356: hr_utility.set_location('p_validate_ni <> IGNORE:'||l_proc,70);
2357: hr_person_info_util_ss.validate_national_identifier(
2358: p_national_identifier => p_national_identifier
2359: ,p_birth_date => p_date_of_birth
2360: ,p_gender => p_sex
2361: ,p_person_id => p_person_id
3774:
3775:
3776: -- Fix 2091186
3777: /*
3778: hr_person_att.update_person gives error
3779: THE MANDATORY COLUMN ATTRIBUTE
3780: when a segment in descriptive flex field is made as required.
3781: The solution suggested is to add the descriptive flex is to
3782: ignore validation using hr_dflex_utility.create_ignore_df_validation
3782: ignore validation using hr_dflex_utility.create_ignore_df_validation
3783: please refer to bug for further details.
3784: */
3785:
3786: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
3787:
3788:
3789: hr_person_api.update_person (
3790: p_validate => false
3785:
3786: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
3787:
3788:
3789: hr_person_api.update_person (
3790: p_validate => false
3791: ,p_datetrack_update_mode => p_attribute_update_mode
3792: ,p_effective_date => p_effective_date
3793: ,p_person_id => p_person_id
3923: ,p_assign_payroll_warning => l_assign_payroll_warning
3924: ,p_orig_hire_warning => l_orig_hire_warning);
3925:
3926: --
3927: hr_person_info_util_ss.remove_ignore_df_validation;
3928: -- Fix 2091186 End.
3929:
3930:
3931: IF p_validate_mode
5976: end if;
5977: end if;
5978: -- Fix bug :2091186
5979:
5980: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
5981:
5982: ---------------------------------------------------------------------------
5983: -- Bug 1937643 Fix Begins - 08/04/2002
5984: -- With the PTU model, the per_all_people_f.person_type_id stores only the
5986: -- for the system_person_type is stored in per_person_type_usages_f table.
5987: -- Since the current Personal Information Basic Details region and the
5988: -- New Hire page does not allow a user to choose any user flavor, so we'll
5989: -- zap the p_person_type_id to hr_api.g_number value when it is not an
5990: -- applicant when calling the hr_person_api.update_person. That way, the api
5991: -- will understand that the person_type is not changed and will not update
5992: -- the person_type_id in per_person_type_usages_f table as is. If we pass
5993: -- the per_all_people_f.person_type_id to the api, the person_type_id in
5994: -- per_person_type_usages_f table will be updated with that value which will
6013:
6014: -- Bug 1937643 Fix Ends - 08/04/2002
6015:
6016:
6017: hr_person_api.update_person(
6018: p_validate => p_validate
6019: ,p_effective_date => l_effective_date
6020: ,p_datetrack_update_mode => hr_transaction_api.get_varchar2_value
6021: (p_transaction_step_id => p_transaction_step_id
6394: ,p_name_combination_warning => l_name_combination_warning
6395: ,p_assign_payroll_warning => l_assign_payroll_warning
6396: ,p_orig_hire_warning => l_orig_hire_warning
6397: );
6398: hr_person_info_util_ss.remove_ignore_df_validation;
6399:
6400: -- Fix bug 2091186 ends.
6401: ELSE
6402: -- for future use, put in code for creating an employee
7925: IF p_flow_name = 'Insert' THEN
7926: -- end cobra codes
7927:
7928: if(p_ni_duplicate_warn_or_err <> 'IGNORE') then
7929: hr_person_info_util_ss.check_ni_unique(
7930: p_national_identifier => p_national_identifier
7931: ,p_business_group_id => p_business_group_id
7932: ,p_person_id => p_person_id
7933: ,p_ni_duplicate_warn_or_err => p_ni_duplicate_warn_or_err);
7934: hr_utility.set_location('p_ni_duplicate_warn_or_err!=IGNORE'||l_proc,65);
7935: end if;
7936:
7937: if(p_validate_ni <> 'IGNORE') then
7938: hr_person_info_util_ss.validate_national_identifier(
7939: p_national_identifier => p_national_identifier
7940: ,p_birth_date => p_date_of_birth
7941: ,p_gender => p_sex
7942: ,p_person_id => p_person_id
8381: -- to be used by the actions page.
8382: -- if l_full_name is null, derive it
8383: if (l_full_name is null) then
8384: hr_utility.set_location('l_full_name is null:'||l_proc,100);
8385: hr_person.derive_full_name(p_first_name,
8386: p_middle_names, p_last_name, p_known_as,
8387: p_title, p_date_of_birth,
8388: p_person_id, p_business_group_id
8389: ,l_full_name,l_dup_name,