77: --
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: --
80: Exception
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
84: per_za_ao_ass_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
81: When hr_api.check_integrity_violated Then
82: -- A check constraint has been violated
83: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
84: per_za_ao_ass_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
89: per_za_ao_ass_shd.constraint_error
82: -- A check constraint has been violated
83: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
84: per_za_ao_ass_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
89: per_za_ao_ass_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.parent_integrity_violated Then
87: -- Parent integrity has been violated
88: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
89: per_za_ao_ass_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
94: per_za_ao_ass_shd.constraint_error
87: -- Parent integrity has been violated
88: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
89: per_za_ao_ass_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
94: per_za_ao_ass_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.unique_integrity_violated Then
92: -- Unique integrity has been violated
93: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
94: per_za_ao_ass_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When Others Then
97: per_za_ao_ass_shd.g_api_dml := false; -- Unset the api dml status
98: Raise;
99: End update_dml;
235: --
236: -- If we are validating then raise the Validate_Enabled exception
237: --
238: If p_validate then
239: Raise HR_Api.Validate_Enabled;
240: End If;
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: Exception
240: End If;
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 10);
243: Exception
244: When HR_Api.Validate_Enabled Then
245: --
246: -- As the Validate_Enabled exception has been raised
247: -- we must rollback to the savepoint
248: --