74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: end if;
76: --
77: Exception
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
81: pqh_cpd_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.child_integrity_violated then
79: -- Child integrity has been violated
80: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
81: pqh_cpd_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When Others Then
84: pqh_cpd_shd.g_api_dml := false; -- Unset the api dml status
85: Raise;
86: End delete_dml;
289: );
290: --
291: exception
292: --
293: when hr_api.cannot_find_prog_unit then
294: --
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'PQH_CORPS_DEFINITIONS'
297: ,p_hook_type => 'AD');
291: exception
292: --
293: when hr_api.cannot_find_prog_unit then
294: --
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'PQH_CORPS_DEFINITIONS'
297: ,p_hook_type => 'AD');
298: --
299: end;