DBA Data[Home] [Help]

APPS.OTA_TAV_INS dependencies on HR_API

Line 205: When hr_api.check_integrity_violated Then

201: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 10);
204: Exception
205: When hr_api.check_integrity_violated Then
206: -- A check constraint has been violated
207: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
208: ota_tav_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

205: When hr_api.check_integrity_violated Then
206: -- A check constraint has been violated
207: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
208: ota_tav_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.parent_integrity_violated Then
211: -- Parent integrity has been violated
212: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
213: ota_tav_shd.constraint_error

Line 210: When hr_api.parent_integrity_violated Then

206: -- A check constraint has been violated
207: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
208: ota_tav_shd.constraint_error
209: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
210: When hr_api.parent_integrity_violated Then
211: -- Parent integrity has been violated
212: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
213: ota_tav_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

210: When hr_api.parent_integrity_violated Then
211: -- Parent integrity has been violated
212: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
213: ota_tav_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.unique_integrity_violated Then
216: -- Unique integrity has been violated
217: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
218: ota_tav_shd.constraint_error

Line 215: When hr_api.unique_integrity_violated Then

211: -- Parent integrity has been violated
212: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
213: ota_tav_shd.constraint_error
214: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
215: When hr_api.unique_integrity_violated Then
216: -- Unique integrity has been violated
217: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
218: ota_tav_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

215: When hr_api.unique_integrity_violated Then
216: -- Unique integrity has been violated
217: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
218: ota_tav_shd.constraint_error
219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When Others Then
221: ota_tav_shd.g_api_dml := false; -- Unset the api dml status
222: Raise;
223: End insert_dml;

Line 411: Raise HR_Api.Validate_Enabled;

407: --
408: -- If we are validating then raise the Validate_Enabled exception
409: --
410: If p_validate then
411: Raise HR_Api.Validate_Enabled;
412: End If;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: Exception

Line 416: When HR_Api.Validate_Enabled Then

412: End If;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: Exception
416: When HR_Api.Validate_Enabled Then
417: --
418: -- As the Validate_Enabled exception has been raised
419: -- we must rollback to the savepoint
420: --