68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: --
71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ghr_caa_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ghr_caa_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;
80: End delete_dml;
194: );
195: --
196: exception
197: --
198: when hr_api.cannot_find_prog_unit then
199: --
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'GHR_COMPL_AGENCY_APPEALS'
202: ,p_hook_type => 'AD');
196: exception
197: --
198: when hr_api.cannot_find_prog_unit then
199: --
200: hr_api.cannot_find_prog_unit_error
201: (p_module_name => 'GHR_COMPL_AGENCY_APPEALS'
202: ,p_hook_type => 'AD');
203: --
204: end;