213: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: Exception
217: When hr_api.check_integrity_violated Then
218: -- A check constraint has been violated
219: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
220: ben_xrc_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.check_integrity_violated Then
218: -- A check constraint has been violated
219: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
220: ben_xrc_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.parent_integrity_violated Then
223: -- Parent integrity has been violated
224: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
225: ben_xrc_shd.constraint_error
218: -- A check constraint has been violated
219: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
220: ben_xrc_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.parent_integrity_violated Then
223: -- Parent integrity has been violated
224: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
225: ben_xrc_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.parent_integrity_violated Then
223: -- Parent integrity has been violated
224: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
225: ben_xrc_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: -- Unique integrity has been violated
229: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
230: ben_xrc_shd.constraint_error
223: -- Parent integrity has been violated
224: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
225: ben_xrc_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: -- Unique integrity has been violated
229: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
230: ben_xrc_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: -- Unique integrity has been violated
229: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
230: ben_xrc_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When Others Then
233: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
234: Raise;
235: End insert_dml;
385: );
386: --
387: exception
388: --
389: when hr_api.cannot_find_prog_unit then
390: --
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'ben_ext_rcd'
393: ,p_hook_type => 'AI');
387: exception
388: --
389: when hr_api.cannot_find_prog_unit then
390: --
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'ben_ext_rcd'
393: ,p_hook_type => 'AI');
394: --
395: end;