APPS.PER_US_DEL_TAX_LEG_HOOK dependencies on PER_US_DEL_TAX_LEG_HOOK

Line 1: PACKAGE BODY PER_US_DEL_TAX_LEG_HOOK AS

1: PACKAGE BODY PER_US_DEL_TAX_LEG_HOOK AS
2: /* $Header: pyusdel.pkb 120.1 2010/05/21 13:55:52 pmatamsr noship $ */
3:
4: PROCEDURE DELETE_US_TAX_INFO
5: (P_PERSON_ID in NUMBER

Line 25: hr_utility.set_location('Entering: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 10);

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;

Line 44: hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 20);

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

Line 49: hr_utility.trace('Exception raised in PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO');

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:

Line 50: hr_utility.set_location('Leaving: PER_US_DEL_TAX_LEG_HOOK.DELETE_US_TAX_INFO', 30);

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

Line 57: END PER_US_DEL_TAX_LEG_HOOK;

53:
54: --
55: END DELETE_US_TAX_INFO;
56:
57: END PER_US_DEL_TAX_LEG_HOOK;
58: