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: IF val_changed(p_correspondence_language) THEN

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

53: CLOSE c_system_person_type;
54: --
55: IF l_system_person_type IN ('EMP', 'EMP_APL') THEN
56: IF p_correspondence_language IS NULL THEN
57: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');
58: hr_utility.raise_error;
59: ELSIf p_correspondence_language NOT IN ('NL','F','D') THEN
60: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');
61: hr_utility.raise_error;

Line 58: hr_utility.raise_error;

54: --
55: IF l_system_person_type IN ('EMP', 'EMP_APL') THEN
56: IF p_correspondence_language IS NULL THEN
57: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');
58: hr_utility.raise_error;
59: ELSIf p_correspondence_language NOT IN ('NL','F','D') THEN
60: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');
61: hr_utility.raise_error;
62: END IF;

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

56: IF p_correspondence_language IS NULL THEN
57: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');
58: hr_utility.raise_error;
59: ELSIf p_correspondence_language NOT IN ('NL','F','D') THEN
60: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');
61: hr_utility.raise_error;
62: END IF;
63: END IF;
64: END IF;

Line 61: hr_utility.raise_error;

57: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_NULL');
58: hr_utility.raise_error;
59: ELSIf p_correspondence_language NOT IN ('NL','F','D') THEN
60: hr_utility.set_message(800, 'HR_BE_LANGUAGE_CODE_WRONG');
61: hr_utility.raise_error;
62: END IF;
63: END IF;
64: END IF;
65: END extra_language_checks;

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

76: (p_region_of_birth IN VARCHAR2) IS
77: BEGIN
78: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
79: -- Only if it is installed,the validation is performed.
80: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
81: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
82: RETURN;
83: END IF;
84: If val_changed(p_region_of_birth) AND p_region_of_birth IS NOT NULL THEN

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

77: BEGIN
78: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
79: -- Only if it is installed,the validation is performed.
80: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
81: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
82: RETURN;
83: END IF;
84: If val_changed(p_region_of_birth) AND p_region_of_birth IS NOT NULL THEN
85: hr_utility.set_message(800, 'HR_BE_REGION_OF_BIRTH_NOT_NULL');

Line 85: hr_utility.set_message(800, 'HR_BE_REGION_OF_BIRTH_NOT_NULL');

81: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
82: RETURN;
83: END IF;
84: If val_changed(p_region_of_birth) AND p_region_of_birth IS NOT NULL THEN
85: hr_utility.set_message(800, 'HR_BE_REGION_OF_BIRTH_NOT_NULL');
86: hr_utility.raise_error;
87: END IF;
88: END extra_person_checks;
89:

Line 86: hr_utility.raise_error;

82: RETURN;
83: END IF;
84: If val_changed(p_region_of_birth) AND p_region_of_birth IS NOT NULL THEN
85: hr_utility.set_message(800, 'HR_BE_REGION_OF_BIRTH_NOT_NULL');
86: hr_utility.raise_error;
87: END IF;
88: END extra_person_checks;
89:
90: --

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

98: (p_employee_category IN VARCHAR2) IS
99: BEGIN
100: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
101: -- Only if it is installed,the validation is performed.
102: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
103: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
104: RETURN;
105: END IF;
106: If p_employee_category IS NULL THEN

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

99: BEGIN
100: -- Added the validation for the Bug No. 6469769 to check whether the Belgium Legislation is installed or not.
101: -- Only if it is installed,the validation is performed.
102: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'BE') THEN
103: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
104: RETURN;
105: END IF;
106: If p_employee_category IS NULL THEN
107: hr_utility.set_message(800, 'HR_BE_EMPLOYEE_CAT_NOT_NULL');

Line 107: hr_utility.set_message(800, 'HR_BE_EMPLOYEE_CAT_NOT_NULL');

103: hr_utility.trace ('BE Legislation not installed. Not performing the validations');
104: RETURN;
105: END IF;
106: If p_employee_category IS NULL THEN
107: hr_utility.set_message(800, 'HR_BE_EMPLOYEE_CAT_NOT_NULL');
108: hr_utility.raise_error;
109: END IF;
110: END extra_assignment_checks;
111:

Line 108: hr_utility.raise_error;

104: RETURN;
105: END IF;
106: If p_employee_category IS NULL THEN
107: hr_utility.set_message(800, 'HR_BE_EMPLOYEE_CAT_NOT_NULL');
108: hr_utility.raise_error;
109: END IF;
110: END extra_assignment_checks;
111:
112: