40: l_system_person_type per_person_types.system_person_type%TYPE;
41: BEGIN
42: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
43: -- Only if it is installed,the validation is performed.
44: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
45: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
46: RETURN;
47: END IF;
48:
41: BEGIN
42: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
43: -- Only if it is installed,the validation is performed.
44: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
45: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
46: RETURN;
47: END IF;
48:
49:
65: CLOSE c_system_person_type;
66: --
67: IF l_system_person_type IN ('EMP', 'EMP_APL') THEN
68: IF p_correspondence_language IS NULL THEN
69: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');
70: hr_utility.raise_error;
71: ELSIf p_correspondence_language NOT IN ('NL','F','D') THEN
72: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');
73: hr_utility.raise_error;
66: --
67: IF l_system_person_type IN ('EMP', 'EMP_APL') THEN
68: IF p_correspondence_language IS NULL THEN
69: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');
70: hr_utility.raise_error;
71: ELSIf p_correspondence_language NOT IN ('NL','F','D') THEN
72: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');
73: hr_utility.raise_error;
74: END IF;
68: IF p_correspondence_language IS NULL THEN
69: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');
70: hr_utility.raise_error;
71: ELSIf p_correspondence_language NOT IN ('NL','F','D') THEN
72: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');
73: hr_utility.raise_error;
74: END IF;
75: END IF;
76: END IF;
69: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');
70: hr_utility.raise_error;
71: ELSIf p_correspondence_language NOT IN ('NL','F','D') THEN
72: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');
73: hr_utility.raise_error;
74: END IF;
75: END IF;
76: END IF;
77: END IF; -- Bug#14250197
89: (p_region_of_birth IN VARCHAR2) IS
90: BEGIN
91: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
92: -- Only if it is installed,the validation is performed.
93: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
94: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
95: RETURN;
96: END IF;
97: If val_changed(p_region_of_birth) AND p_region_of_birth IS NOT NULL THEN
90: BEGIN
91: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
92: -- Only if it is installed,the validation is performed.
93: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
94: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
95: RETURN;
96: END IF;
97: If val_changed(p_region_of_birth) AND p_region_of_birth IS NOT NULL THEN
98: hr_utility.set_message(800, 'HR_BE_REGION_OF_BIRTH_NOT_NULL');
94: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
95: RETURN;
96: END IF;
97: If val_changed(p_region_of_birth) AND p_region_of_birth IS NOT NULL THEN
98: hr_utility.set_message(800, 'HR_BE_REGION_OF_BIRTH_NOT_NULL');
99: hr_utility.raise_error;
100: END IF;
101: END extra_person_checks;
102:
95: RETURN;
96: END IF;
97: If val_changed(p_region_of_birth) AND p_region_of_birth IS NOT NULL THEN
98: hr_utility.set_message(800, 'HR_BE_REGION_OF_BIRTH_NOT_NULL');
99: hr_utility.raise_error;
100: END IF;
101: END extra_person_checks;
102:
103: --
111: (p_employee_category IN VARCHAR2) IS
112: BEGIN
113: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
114: -- Only if it is installed,the validation is performed.
115: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
116: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
117: RETURN;
118: END IF;
119: If p_employee_category IS NULL THEN
112: BEGIN
113: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
114: -- Only if it is installed,the validation is performed.
115: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
116: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
117: RETURN;
118: END IF;
119: If p_employee_category IS NULL THEN
120: hr_utility.set_message(800, 'HR_BE_EMPLOYEE_CAT_NOT_NULL');
116: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
117: RETURN;
118: END IF;
119: If p_employee_category IS NULL THEN
120: hr_utility.set_message(800, 'HR_BE_EMPLOYEE_CAT_NOT_NULL');
121: hr_utility.raise_error;
122: END IF;
123: END extra_assignment_checks;
124:
117: RETURN;
118: END IF;
119: If p_employee_category IS NULL THEN
120: hr_utility.set_message(800, 'HR_BE_EMPLOYEE_CAT_NOT_NULL');
121: hr_utility.raise_error;
122: END IF;
123: END extra_assignment_checks;
124:
125: