280: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: Exception
284: When hr_api.check_integrity_violated Then
285: -- A check constraint has been violated
286: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
287: ben_cpd_shd.constraint_error
288: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
284: When hr_api.check_integrity_violated Then
285: -- A check constraint has been violated
286: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
287: ben_cpd_shd.constraint_error
288: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
289: When hr_api.parent_integrity_violated Then
290: -- Parent integrity has been violated
291: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
292: ben_cpd_shd.constraint_error
285: -- A check constraint has been violated
286: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
287: ben_cpd_shd.constraint_error
288: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
289: When hr_api.parent_integrity_violated Then
290: -- Parent integrity has been violated
291: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
292: ben_cpd_shd.constraint_error
293: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
289: When hr_api.parent_integrity_violated Then
290: -- Parent integrity has been violated
291: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
292: ben_cpd_shd.constraint_error
293: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
294: When hr_api.unique_integrity_violated Then
295: -- Unique integrity has been violated
296: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
297: ben_cpd_shd.constraint_error
290: -- Parent integrity has been violated
291: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
292: ben_cpd_shd.constraint_error
293: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
294: When hr_api.unique_integrity_violated Then
295: -- Unique integrity has been violated
296: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
297: ben_cpd_shd.constraint_error
298: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
294: When hr_api.unique_integrity_violated Then
295: -- Unique integrity has been violated
296: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
297: ben_cpd_shd.constraint_error
298: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
299: When Others Then
300: ben_cpd_shd.g_api_dml := false; -- Unset the api dml status
301: Raise;
302: End insert_dml;
631: );
632: --
633: exception
634: --
635: when hr_api.cannot_find_prog_unit then
636: --
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'BEN_CWB_PL_DSGN'
639: ,p_hook_type => 'AI');
633: exception
634: --
635: when hr_api.cannot_find_prog_unit then
636: --
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'BEN_CWB_PL_DSGN'
639: ,p_hook_type => 'AI');
640: --
641: end;