DBA Data[Home] [Help]

APPS.PER_KAD_INS dependencies on HR_API

Line 168: When hr_api.check_integrity_violated Then

164: per_kad_shd.g_api_dml := false; -- Unset the api dml status
165: --
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: Exception
168: When hr_api.check_integrity_violated Then
169: -- A check constraint has been violated
170: per_kad_shd.g_api_dml := false; -- Unset the api dml status
171: per_kad_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

168: When hr_api.check_integrity_violated Then
169: -- A check constraint has been violated
170: per_kad_shd.g_api_dml := false; -- Unset the api dml status
171: per_kad_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: per_kad_shd.g_api_dml := false; -- Unset the api dml status
176: per_kad_shd.constraint_error

Line 173: When hr_api.parent_integrity_violated Then

169: -- A check constraint has been violated
170: per_kad_shd.g_api_dml := false; -- Unset the api dml status
171: per_kad_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: per_kad_shd.g_api_dml := false; -- Unset the api dml status
176: per_kad_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

173: When hr_api.parent_integrity_violated Then
174: -- Parent integrity has been violated
175: per_kad_shd.g_api_dml := false; -- Unset the api dml status
176: per_kad_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: per_kad_shd.g_api_dml := false; -- Unset the api dml status
181: per_kad_shd.constraint_error

Line 178: When hr_api.unique_integrity_violated Then

174: -- Parent integrity has been violated
175: per_kad_shd.g_api_dml := false; -- Unset the api dml status
176: per_kad_shd.constraint_error
177: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: per_kad_shd.g_api_dml := false; -- Unset the api dml status
181: per_kad_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

178: When hr_api.unique_integrity_violated Then
179: -- Unique integrity has been violated
180: per_kad_shd.g_api_dml := false; -- Unset the api dml status
181: per_kad_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When Others Then
184: per_kad_shd.g_api_dml := false; -- Unset the api dml status
185: Raise;
186: End insert_dml;

Line 356: Raise HR_Api.Validate_Enabled;

352: --
353: -- If we are validating then raise the Validate_Enabled exception
354: --
355: If p_validate then
356: Raise HR_Api.Validate_Enabled;
357: End If;
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: Exception

Line 361: When HR_Api.Validate_Enabled Then

357: End If;
358: --
359: hr_utility.set_location(' Leaving:'||l_proc, 10);
360: Exception
361: When HR_Api.Validate_Enabled Then
362: --
363: -- As the Validate_Enabled exception has been raised
364: -- we must rollback to the savepoint
365: --