79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: end if;
81: --
82: Exception
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
86: hxc_hac_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.child_integrity_violated then
84: -- Child integrity has been violated
85: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
86: hxc_hac_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When Others Then
89: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
90: Raise;
91: End delete_dml;
212: );
213: --
214: exception
215: --
216: when hr_api.cannot_find_prog_unit then
217: --
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'HXC_APPROVAL_COMPS'
220: ,p_hook_type => 'AD');
214: exception
215: --
216: when hr_api.cannot_find_prog_unit then
217: --
218: hr_api.cannot_find_prog_unit_error
219: (p_module_name => 'HXC_APPROVAL_COMPS'
220: ,p_hook_type => 'AD');
221: --
222: end;