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