[Home] [Help]
1861: -- for the system_person_type is stored in per_person_type_usages_f table.
1862: -- Since the current Personal Information Basic Details region and the
1863: -- New Hire page does not allow a user to choose any user flavor, so we'll
1864: -- zap the p_person_type_id to hr_api.g_number value when it is not an
1865: -- applicant when calling the hr_person_api.update_person. That way, the api
1866: -- will understand that the person_type is not changed and will not update
1867: -- the person_type_id in per_person_type_usages_f table as is. If we pass
1868: -- the per_all_people_f.person_type_id to the api, the person_type_id in
1869: -- per_person_type_usages_f table will be updated with that value which will
2050: nvl(l_current_employee_flag, 'N') <> 'Y' AND
2051: nvl(l_current_npw_flag, 'N') <> 'Y')
2052: then
2053: if(p_ni_duplicate_warn_or_err <> 'IGNORE') then
2054: hr_person_info_util_ss.check_ni_unique(
2055: p_national_identifier => p_national_identifier
2056: ,p_business_group_id => p_business_group_id
2057: ,p_person_id => p_person_id
2058: ,p_ni_duplicate_warn_or_err => p_ni_duplicate_warn_or_err);
2059: end if;
2060:
2061: if(p_validate_ni <> 'IGNORE') then
2062: hr_utility.set_location('p_validate_ni <> IGNORE:'||l_proc,70);
2063: hr_person_info_util_ss.validate_national_identifier(
2064: p_national_identifier => p_national_identifier
2065: ,p_birth_date => p_date_of_birth
2066: ,p_gender => p_sex
2067: ,p_person_id => p_person_id
3398:
3399:
3400: -- Fix 2091186
3401: /*
3402: hr_person_att.update_person gives error
3403: THE MANDATORY COLUMN ATTRIBUTE
3404: when a segment in descriptive flex field is made as required.
3405: The solution suggested is to add the descriptive flex is to
3406: ignore validation using hr_dflex_utility.create_ignore_df_validation
3406: ignore validation using hr_dflex_utility.create_ignore_df_validation
3407: please refer to bug for further details.
3408: */
3409:
3410: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
3411:
3412:
3413: hr_person_api.update_person (
3414: p_validate => false
3409:
3410: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
3411:
3412:
3413: hr_person_api.update_person (
3414: p_validate => false
3415: ,p_datetrack_update_mode => p_attribute_update_mode
3416: ,p_effective_date => p_effective_date
3417: ,p_person_id => p_person_id
3547: ,p_assign_payroll_warning => l_assign_payroll_warning
3548: ,p_orig_hire_warning => l_orig_hire_warning);
3549:
3550: --
3551: hr_person_info_util_ss.remove_ignore_df_validation;
3552: -- Fix 2091186 End.
3553:
3554:
3555: IF p_validate_mode
5419: end if;
5420:
5421: -- Fix bug :2091186
5422:
5423: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
5424:
5425: ---------------------------------------------------------------------------
5426: -- Bug 1937643 Fix Begins - 08/04/2002
5427: -- With the PTU model, the per_all_people_f.person_type_id stores only the
5429: -- for the system_person_type is stored in per_person_type_usages_f table.
5430: -- Since the current Personal Information Basic Details region and the
5431: -- New Hire page does not allow a user to choose any user flavor, so we'll
5432: -- zap the p_person_type_id to hr_api.g_number value when it is not an
5433: -- applicant when calling the hr_person_api.update_person. That way, the api
5434: -- will understand that the person_type is not changed and will not update
5435: -- the person_type_id in per_person_type_usages_f table as is. If we pass
5436: -- the per_all_people_f.person_type_id to the api, the person_type_id in
5437: -- per_person_type_usages_f table will be updated with that value which will
5453:
5454: -- Bug 1937643 Fix Ends - 08/04/2002
5455:
5456:
5457: hr_person_api.update_person(
5458: p_validate => p_validate
5459: ,p_effective_date => l_effective_date
5460: ,p_datetrack_update_mode => hr_transaction_api.get_varchar2_value
5461: (p_transaction_step_id => p_transaction_step_id
5834: ,p_name_combination_warning => l_name_combination_warning
5835: ,p_assign_payroll_warning => l_assign_payroll_warning
5836: ,p_orig_hire_warning => l_orig_hire_warning
5837: );
5838: hr_person_info_util_ss.remove_ignore_df_validation;
5839:
5840: -- Fix bug 2091186 ends.
5841: ELSE
5842: -- for future use, put in code for creating an employee
7347: IF p_flow_name = 'Insert' THEN
7348: -- end cobra codes
7349:
7350: if(p_ni_duplicate_warn_or_err <> 'IGNORE') then
7351: hr_person_info_util_ss.check_ni_unique(
7352: p_national_identifier => p_national_identifier
7353: ,p_business_group_id => p_business_group_id
7354: ,p_person_id => p_person_id
7355: ,p_ni_duplicate_warn_or_err => p_ni_duplicate_warn_or_err);
7356: hr_utility.set_location('p_ni_duplicate_warn_or_err!=IGNORE'||l_proc,65);
7357: end if;
7358:
7359: if(p_validate_ni <> 'IGNORE') then
7360: hr_person_info_util_ss.validate_national_identifier(
7361: p_national_identifier => p_national_identifier
7362: ,p_birth_date => p_date_of_birth
7363: ,p_gender => p_sex
7364: ,p_person_id => p_person_id
7803: -- to be used by the actions page.
7804: -- if l_full_name is null, derive it
7805: if (l_full_name is null) then
7806: hr_utility.set_location('l_full_name is null:'||l_proc,100);
7807: hr_person.derive_full_name(p_first_name,
7808: p_middle_names, p_last_name, p_known_as,
7809: p_title, p_date_of_birth,
7810: p_person_id, p_business_group_id
7811: ,l_full_name,l_dup_name,