29: --
30: BEGIN
31: --
32: /* Added for GSI Bug 5472781 */
33: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
34: hr_utility.set_location('Leaving : '|| l_proc , 5);
35: return;
36: END IF;
37: --
30: BEGIN
31: --
32: /* Added for GSI Bug 5472781 */
33: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
34: hr_utility.set_location('Leaving : '|| l_proc , 5);
35: return;
36: END IF;
37: --
38: hr_utility.set_location('Entering: '||l_proc,5);
34: hr_utility.set_location('Leaving : '|| l_proc , 5);
35: return;
36: END IF;
37: --
38: hr_utility.set_location('Entering: '||l_proc,5);
39: if p_org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO' then
40: hr_utility.set_location(l_proc,10);
41: if hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1')
36: END IF;
37: --
38: hr_utility.set_location('Entering: '||l_proc,5);
39: if p_org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO' then
40: hr_utility.set_location(l_proc,10);
41: if hr_multi_message.no_exclusive_error
42: (p_check_column1 => 'HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1')
43: then
44: -- No error for ORG_INFORMATION1 already exists so,
75: close csr_chk_generic_opm;
76: end if;
77: end if; -- check existing errors
78: end if; -- org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'
79: hr_utility.set_location(' Leaving: '||l_proc,99);
80: end validate_fr_opm_mapping;
81:
82: PROCEDURE validate_fr_contrib_codes
83: (p_org_information_id IN NUMBER
95: where ip.organization_id = p_org_information3;
96: BEGIN
97: --
98: /* Added for GSI Bug 5472781 */
99: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
100: hr_utility.set_location('Leaving : '|| l_proc , 01);
101: return;
102: END IF;
103: --
96: BEGIN
97: --
98: /* Added for GSI Bug 5472781 */
99: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'FR') THEN
100: hr_utility.set_location('Leaving : '|| l_proc , 01);
101: return;
102: END IF;
103: --
104: hr_utility.set_location(' Entering '||l_proc,01);
100: hr_utility.set_location('Leaving : '|| l_proc , 01);
101: return;
102: END IF;
103: --
104: hr_utility.set_location(' Entering '||l_proc,01);
105: if p_org_information_context = 'FR_COMP_CADRE_LIFE_INSURE' then
106: hr_utility.set_location(' Validating contrib_codes '||p_org_information5,01);
107: open c_ins_prov_type;
108: fetch c_ins_prov_type into l_type;
102: END IF;
103: --
104: hr_utility.set_location(' Entering '||l_proc,01);
105: if p_org_information_context = 'FR_COMP_CADRE_LIFE_INSURE' then
106: hr_utility.set_location(' Validating contrib_codes '||p_org_information5,01);
107: open c_ins_prov_type;
108: fetch c_ins_prov_type into l_type;
109: close c_ins_prov_type;
110: