DBA Data[Home] [Help]

APPS.OTA_TDB_INS dependencies on HR_API

Line 249: When hr_api.check_integrity_violated Then

245: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: Exception
249: When hr_api.check_integrity_violated Then
250: -- A check constraint has been violated
251: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
252: ota_tdb_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

249: When hr_api.check_integrity_violated Then
250: -- A check constraint has been violated
251: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
252: ota_tdb_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When hr_api.parent_integrity_violated Then
255: -- Parent integrity has been violated
256: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
257: ota_tdb_shd.constraint_error

Line 254: When hr_api.parent_integrity_violated Then

250: -- A check constraint has been violated
251: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
252: ota_tdb_shd.constraint_error
253: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
254: When hr_api.parent_integrity_violated Then
255: -- Parent integrity has been violated
256: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
257: ota_tdb_shd.constraint_error
258: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

254: When hr_api.parent_integrity_violated Then
255: -- Parent integrity has been violated
256: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
257: ota_tdb_shd.constraint_error
258: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
259: When hr_api.unique_integrity_violated Then
260: -- Unique integrity has been violated
261: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
262: ota_tdb_shd.constraint_error

Line 259: When hr_api.unique_integrity_violated Then

255: -- Parent integrity has been violated
256: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
257: ota_tdb_shd.constraint_error
258: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
259: When hr_api.unique_integrity_violated Then
260: -- Unique integrity has been violated
261: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
262: ota_tdb_shd.constraint_error
263: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

259: When hr_api.unique_integrity_violated Then
260: -- Unique integrity has been violated
261: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
262: ota_tdb_shd.constraint_error
263: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
264: When Others Then
265: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
266: Raise;
267: End insert_dml;

Line 490: Raise HR_Api.Validate_Enabled;

486: --
487: -- If we are validating then raise the Validate_Enabled exception
488: --
489: If p_validate then
490: Raise HR_Api.Validate_Enabled;
491: End If;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: Exception

Line 495: When HR_Api.Validate_Enabled Then

491: End If;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: Exception
495: When HR_Api.Validate_Enabled Then
496: --
497: -- As the Validate_Enabled exception has been raised
498: -- we must rollback to the savepoint
499: --