39: BEGIN
40:
41: l_procedure := g_package||'validate_issue_expiry_date';
42: g_debug := hr_utility.debug_enabled;
43: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
44:
45: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
46: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
47: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
43: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
44:
45: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
46: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
47: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
48: RETURN;
49: END IF;
50:
51: IF g_debug THEN
48: RETURN;
49: END IF;
50:
51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_pei_information_category',p_pei_information_category);
54: pay_in_utils.trace('p_pei_information4 ',p_pei_information4 );
55: pay_in_utils.trace('p_pei_information5 ',p_pei_information5 );
56: pay_in_utils.trace('**************************************************','********************');
49: END IF;
50:
51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_pei_information_category',p_pei_information_category);
54: pay_in_utils.trace('p_pei_information4 ',p_pei_information4 );
55: pay_in_utils.trace('p_pei_information5 ',p_pei_information5 );
56: pay_in_utils.trace('**************************************************','********************');
57: END IF;
50:
51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_pei_information_category',p_pei_information_category);
54: pay_in_utils.trace('p_pei_information4 ',p_pei_information4 );
55: pay_in_utils.trace('p_pei_information5 ',p_pei_information5 );
56: pay_in_utils.trace('**************************************************','********************');
57: END IF;
58:
51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_pei_information_category',p_pei_information_category);
54: pay_in_utils.trace('p_pei_information4 ',p_pei_information4 );
55: pay_in_utils.trace('p_pei_information5 ',p_pei_information5 );
56: pay_in_utils.trace('**************************************************','********************');
57: END IF;
58:
59: IF p_pei_information_category = 'IN_PASSPORT_DETAILS' THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_pei_information_category',p_pei_information_category);
54: pay_in_utils.trace('p_pei_information4 ',p_pei_information4 );
55: pay_in_utils.trace('p_pei_information5 ',p_pei_information5 );
56: pay_in_utils.trace('**************************************************','********************');
57: END IF;
58:
59: IF p_pei_information_category = 'IN_PASSPORT_DETAILS' THEN
60: l_procedure :='PER_IN_EXTRA_PER_INFO_LEG_HOOK.VALIDATE_ISSUE_EXPIRY_DATE';
57: END IF;
58:
59: IF p_pei_information_category = 'IN_PASSPORT_DETAILS' THEN
60: l_procedure :='PER_IN_EXTRA_PER_INFO_LEG_HOOK.VALIDATE_ISSUE_EXPIRY_DATE';
61: pay_in_utils.set_location(g_debug,l_procedure,10);
62: IF p_pei_information4 IS NOT NULL AND p_pei_information5 IS NOT NULL THEN
63: IF fnd_date.canonical_to_date(p_pei_information4) > fnd_date.canonical_to_date(p_pei_information5) THEN
64: RAISE E_INVALID_DATES_ERR;
65: END IF;
63: IF fnd_date.canonical_to_date(p_pei_information4) > fnd_date.canonical_to_date(p_pei_information5) THEN
64: RAISE E_INVALID_DATES_ERR;
65: END IF;
66: END IF;
67: pay_in_utils.set_location(g_debug,l_procedure,20);
68: END IF;
69:
70: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
71:
66: END IF;
67: pay_in_utils.set_location(g_debug,l_procedure,20);
68: END IF;
69:
70: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
71:
72: EXCEPTION
73: WHEN E_INVALID_DATES_ERR THEN
74: hr_utility.set_message(800,'PER_IN_INCORRECT_PASSPORT_DATE');
71:
72: EXCEPTION
73: WHEN E_INVALID_DATES_ERR THEN
74: hr_utility.set_message(800,'PER_IN_INCORRECT_PASSPORT_DATE');
75: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
76: hr_utility.raise_error;
77:
78: END validate_issue_expiry_date;
79: