60: --
61: hr_utility.set_location(' Leaving:'||l_proc, 10);
62: --
63: Exception
64: When hr_api.child_integrity_violated then
65: -- Child integrity has been violated
66: ghr_nre_shd.constraint_error
67: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
68: When Others Then
63: Exception
64: When hr_api.child_integrity_violated then
65: -- Child integrity has been violated
66: ghr_nre_shd.constraint_error
67: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
68: When Others Then
69: Raise;
70: End delete_dml;
71: --
172: );
173: --
174: exception
175: --
176: when hr_api.cannot_find_prog_unit then
177: --
178: hr_api.cannot_find_prog_unit_error
179: (p_module_name => 'ghr_noac_remarks'
180: ,p_hook_type => 'AD');
174: exception
175: --
176: when hr_api.cannot_find_prog_unit then
177: --
178: hr_api.cannot_find_prog_unit_error
179: (p_module_name => 'ghr_noac_remarks'
180: ,p_hook_type => 'AD');
181: --
182: end;