21: --
22:
23: BEGIN
24:
25: hr_utility.set_location('Entering: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 10);
26:
27: open csr_assignment_id(p_person_id,p_effective_date);
28: Loop
29: fetch csr_assignment_id into l_assignment_id;
35: ,p_delete_routine => 'ASSIGNMENT' );
36:
37: exit when csr_assignment_id%NOTFOUND;
38:
39: hr_utility.trace('Deleted the tax records of '||l_assignment_id);
40:
41: END Loop ;
42: close csr_assignment_id;
43:
40:
41: END Loop ;
42: close csr_assignment_id;
43:
44: hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 20);
45:
46: EXCEPTION
47:
48: WHEN OTHERS THEN
45:
46: EXCEPTION
47:
48: WHEN OTHERS THEN
49: hr_utility.trace('Exception raised in PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO');
50: hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 30);
51: hr_utility.oracle_error(sqlcode);
52: hr_utility.raise_error;
53:
46: EXCEPTION
47:
48: WHEN OTHERS THEN
49: hr_utility.trace('Exception raised in PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO');
50: hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 30);
51: hr_utility.oracle_error(sqlcode);
52: hr_utility.raise_error;
53:
54: --
47:
48: WHEN OTHERS THEN
49: hr_utility.trace('Exception raised in PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO');
50: hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 30);
51: hr_utility.oracle_error(sqlcode);
52: hr_utility.raise_error;
53:
54: --
55: END DELETE_US_TAX_INFO;
48: WHEN OTHERS THEN
49: hr_utility.trace('Exception raised in PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO');
50: hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 30);
51: hr_utility.oracle_error(sqlcode);
52: hr_utility.raise_error;
53:
54: --
55: END DELETE_US_TAX_INFO;
56: