DBA Data[Home] [Help]

APPS.HR_BE_EXTRA_PERSON_RULES dependencies on HR_UTILITY

Line 44: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN

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:

Line 45: hr_utility.trace ('BE Legislation not installed. Not performing the validations');

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:

Line 69: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');

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;

Line 70: 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;

Line 72: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');

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;

Line 73: hr_utility.raise_error;

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

Line 93: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN

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

Line 94: hr_utility.trace ('BE Legislation not installed. Not performing the validations');

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');

Line 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:

Line 99: hr_utility.raise_error;

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: --

Line 115: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN

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

Line 116: hr_utility.trace ('BE Legislation not installed. Not performing the validations');

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');

Line 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:

Line 121: hr_utility.raise_error;

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: