175: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When Others Then
195: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
196: Raise;
197: End insert_dml;
368: --
369: -- If we are validating then raise the Validate_Enabled exception
370: --
371: If p_validate then
372: Raise HR_Api.Validate_Enabled;
373: End If;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 10);
376: Exception
373: End If;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 10);
376: Exception
377: When HR_Api.Validate_Enabled Then
378: --
379: -- As the Validate_Enabled exception has been raised
380: -- we must rollback to the savepoint
381: --