APPS.PER_HU_ASSIGN_EXTRA_INFO dependencies on HR_UTILITY

Line 10: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG_DATE');

6: ) IS
7: BEGIN
8: IF p_aei_information2 IS NOT NULL AND p_aei_information3 IS NOT NULL THEN
9: IF fnd_date.canonical_to_date(p_aei_information2)> fnd_date.canonical_to_date(p_aei_information3) THEN
10: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG_DATE');
11: hr_utility.raise_error;
12: END IF;
13: END IF;
14: END chk_date;

Line 11: hr_utility.raise_error;

7: BEGIN
8: IF p_aei_information2 IS NOT NULL AND p_aei_information3 IS NOT NULL THEN
9: IF fnd_date.canonical_to_date(p_aei_information2)> fnd_date.canonical_to_date(p_aei_information3) THEN
10: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG_DATE');
11: hr_utility.raise_error;
12: END IF;
13: END IF;
14: END chk_date;
15:

Line 37: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN

33: BEGIN
34: --
35: -- Added for GSI Bug 5472781
36: --
37: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
38: --
39: IF p_information_type='HU_ASG_CATEGORY' THEN
40: OPEN get_assignment_type;
41: FETCH get_assignment_type INTO l_assignment_type;

Line 43: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG');

39: IF p_information_type='HU_ASG_CATEGORY' THEN
40: OPEN get_assignment_type;
41: FETCH get_assignment_type INTO l_assignment_type;
42: IF l_assignment_type ='C' THEN
43: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG');
44: hr_utility.raise_error;
45: END IF;
46: CLOSE get_assignment_type;
47:

Line 44: hr_utility.raise_error;

40: OPEN get_assignment_type;
41: FETCH get_assignment_type INTO l_assignment_type;
42: IF l_assignment_type ='C' THEN
43: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG');
44: hr_utility.raise_error;
45: END IF;
46: CLOSE get_assignment_type;
47:
48: per_hu_assign_extra_info.chk_date(p_aei_information2 => p_aei_information2

Line 77: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN

73: BEGIN
74: --
75: -- Added for GSI Bug 5472781
76: --
77: IF hr_utility.chk_product_install('Oracle Human Resources', 'HU') THEN
78: --
79: IF p_aei_information_category = 'HU_ASG_CATEGORY' THEN
80:
81: OPEN get_assignment_type;

Line 84: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG');

80:
81: OPEN get_assignment_type;
82: FETCH get_assignment_type INTO l_assignment_type;
83: IF l_assignment_type ='C' THEN
84: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG');
85: hr_utility.raise_error;
86: END IF;
87: CLOSE get_assignment_type;
88:

Line 85: hr_utility.raise_error;

81: OPEN get_assignment_type;
82: FETCH get_assignment_type INTO l_assignment_type;
83: IF l_assignment_type ='C' THEN
84: hr_utility.set_message(800,'HR_HU_INVALID_ASG_CATG');
85: hr_utility.raise_error;
86: END IF;
87: CLOSE get_assignment_type;
88:
89: per_hu_assign_extra_info.chk_date(p_aei_information2 => p_aei_information2