DBA Data[Home] [Help]

APPS.PER_US_DEL_TAX_LEG_HOOK dependencies on HR_UTILITY

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 39: hr_utility.trace('Deleted the tax records of '||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:

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 51: hr_utility.oracle_error(sqlcode);

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;

Line 52: hr_utility.raise_error;

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: