136: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
143: ota_ple_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
143: ota_ple_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
148: ota_ple_shd.constraint_error
141: -- A check constraint has been violated
142: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
143: ota_ple_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
148: ota_ple_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.parent_integrity_violated Then
146: -- Parent integrity has been violated
147: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
148: ota_ple_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
153: ota_ple_shd.constraint_error
146: -- Parent integrity has been violated
147: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
148: ota_ple_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
153: ota_ple_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
153: ota_ple_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End insert_dml;
296: --
297: -- If we are validating then raise the Validate_Enabled exception
298: --
299: If p_validate then
300: Raise HR_Api.Validate_Enabled;
301: End If;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: Exception
301: End If;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: Exception
305: When HR_Api.Validate_Enabled Then
306: --
307: -- As the Validate_Enabled exception has been raised
308: -- we must rollback to the savepoint
309: --