DBA Data[Home] [Help]

APPS.HR_DE_VALIDATE_PKG dependencies on HR_UTILITY

Line 28: IF hr_utility.chk_product_install('Oracle Human Resources', 'DE') THEN

24:
25: BEGIN
26:
27: /* Added for GSI Bug 5472781 */
28: IF hr_utility.chk_product_install('Oracle Human Resources', 'DE') THEN
29:
30: OPEN csr_get_table;
31: FETCH csr_get_table INTO l_table;
32: CLOSE csr_get_table;

Line 36: hr_utility.set_message(800, 'HR_78912_DE_NO_PENSION_CONT');

32: CLOSE csr_get_table;
33:
34: If P_ENTRY_INFORMATION_CATEGORY ='DE_SOCIAL INSURANCE' then
35: If P_ENTRY_INFORMATION1 = '0000' and l_table = 'DE_TAX_TABLE_A' then
36: hr_utility.set_message(800, 'HR_78912_DE_NO_PENSION_CONT');
37: hr_utility.raise_error;
38: End If;
39: End If;
40:

Line 37: hr_utility.raise_error;

33:
34: If P_ENTRY_INFORMATION_CATEGORY ='DE_SOCIAL INSURANCE' then
35: If P_ENTRY_INFORMATION1 = '0000' and l_table = 'DE_TAX_TABLE_A' then
36: hr_utility.set_message(800, 'HR_78912_DE_NO_PENSION_CONT');
37: hr_utility.raise_error;
38: End If;
39: End If;
40:
41: END IF;

Line 76: IF hr_utility.chk_product_install('Oracle Human Resources', 'DE') THEN

72:
73: BEGIN
74:
75: /* Added for GSI Bug 5472781 */
76: IF hr_utility.chk_product_install('Oracle Human Resources', 'DE') THEN
77:
78: OPEN csr_get_asg_id;
79: FETCH csr_get_asg_id INTO l_assignment_id;
80: CLOSE csr_get_asg_id;

Line 88: hr_utility.set_message(800, 'HR_78912_DE_NO_PENSION_CONT');

84: CLOSE csr_get_table;
85:
86: If P_ENTRY_INFORMATION_CATEGORY ='DE_SOCIAL INSURANCE' then
87: If P_ENTRY_INFORMATION1 = '0000' and l_table = 'DE_TAX_TABLE_A' then
88: hr_utility.set_message(800, 'HR_78912_DE_NO_PENSION_CONT');
89: hr_utility.raise_error;
90: End If;
91: End If;
92:

Line 89: hr_utility.raise_error;

85:
86: If P_ENTRY_INFORMATION_CATEGORY ='DE_SOCIAL INSURANCE' then
87: If P_ENTRY_INFORMATION1 = '0000' and l_table = 'DE_TAX_TABLE_A' then
88: hr_utility.set_message(800, 'HR_78912_DE_NO_PENSION_CONT');
89: hr_utility.raise_error;
90: End If;
91: End If;
92:
93: END IF;