36: l_procedure VARCHAR2(100);
37:
38: BEGIN
39:
40: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
41: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
42: RETURN;
43: END IF;
44:
37:
38: BEGIN
39:
40: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
41: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
42: RETURN;
43: END IF;
44:
45: g_debug := hr_utility.debug_enabled;
41: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
42: RETURN;
43: END IF;
44:
45: g_debug := hr_utility.debug_enabled;
46: l_procedure := g_package ||'check_tds_fields';
47: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
48:
49: IF g_debug THEN
56:
57: IF p_eei_information_category = 'PAY_IN_BONUS_INFO_DFF' THEN
58:
59: IF p_eei_information1 <> 'P' AND p_eei_information2 IS NOT NULL THEN
60: hr_utility.set_message(800, 'PER_IN_CANT_ENTER_PERCENTAGE');
61: hr_utility.raise_error;
62: END IF;
63:
64: IF p_eei_information1 = 'P' AND p_eei_information2 IS NULL THEN
57: IF p_eei_information_category = 'PAY_IN_BONUS_INFO_DFF' THEN
58:
59: IF p_eei_information1 <> 'P' AND p_eei_information2 IS NOT NULL THEN
60: hr_utility.set_message(800, 'PER_IN_CANT_ENTER_PERCENTAGE');
61: hr_utility.raise_error;
62: END IF;
63:
64: IF p_eei_information1 = 'P' AND p_eei_information2 IS NULL THEN
65: hr_utility.set_message(800, 'PER_IN_ENTER_PERCENTAGE');
61: hr_utility.raise_error;
62: END IF;
63:
64: IF p_eei_information1 = 'P' AND p_eei_information2 IS NULL THEN
65: hr_utility.set_message(800, 'PER_IN_ENTER_PERCENTAGE');
66: hr_utility.raise_error;
67: END IF;
68: END IF;
69:
62: END IF;
63:
64: IF p_eei_information1 = 'P' AND p_eei_information2 IS NULL THEN
65: hr_utility.set_message(800, 'PER_IN_ENTER_PERCENTAGE');
66: hr_utility.raise_error;
67: END IF;
68: END IF;
69:
70: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
70: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
71:
72: EXCEPTION
73: WHEN OTHERS THEN
74: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');
75: hr_utility.set_message_token('FUNCTION',l_procedure);
76: hr_utility.set_message_token('SQLERRMC',SQLERRM);
77: hr_utility.raise_error;
78: END check_tds_fields ;
71:
72: EXCEPTION
73: WHEN OTHERS THEN
74: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');
75: hr_utility.set_message_token('FUNCTION',l_procedure);
76: hr_utility.set_message_token('SQLERRMC',SQLERRM);
77: hr_utility.raise_error;
78: END check_tds_fields ;
79:
72: EXCEPTION
73: WHEN OTHERS THEN
74: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');
75: hr_utility.set_message_token('FUNCTION',l_procedure);
76: hr_utility.set_message_token('SQLERRMC',SQLERRM);
77: hr_utility.raise_error;
78: END check_tds_fields ;
79:
80:
73: WHEN OTHERS THEN
74: hr_utility.set_message(800,'PER_IN_ORACLE_GENERIC_ERROR');
75: hr_utility.set_message_token('FUNCTION',l_procedure);
76: hr_utility.set_message_token('SQLERRMC',SQLERRM);
77: hr_utility.raise_error;
78: END check_tds_fields ;
79:
80:
81: END pay_in_ele_extra_info_leg_hook ;