222: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
229: ota_evt_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
229: ota_evt_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.parent_integrity_violated Then
232: -- Parent integrity has been violated
233: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
234: ota_evt_shd.constraint_error
227: -- A check constraint has been violated
228: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
229: ota_evt_shd.constraint_error
230: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.parent_integrity_violated Then
232: -- Parent integrity has been violated
233: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
234: ota_evt_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
231: When hr_api.parent_integrity_violated Then
232: -- Parent integrity has been violated
233: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
234: ota_evt_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
239: ota_evt_shd.constraint_error
232: -- Parent integrity has been violated
233: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
234: ota_evt_shd.constraint_error
235: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
239: ota_evt_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
236: When hr_api.unique_integrity_violated Then
237: -- Unique integrity has been violated
238: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
239: ota_evt_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
243: Raise;
244: End insert_dml;
437: -- added for eBS by asud
438: -- If we are validating then raise the Validate_Enabled exception
439: --
440: If p_validate then
441: Raise HR_Api.Validate_Enabled;
442: End If;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 10);
445: Exception
442: End If;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 10);
445: Exception
446: When HR_Api.Validate_Enabled Then
447: --
448: -- As the Validate_Enabled exception has been raised
449: -- we must rollback to the savepoint
450: --