eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TDB_INS dependencies on HR_API

Line 247: When hr_api.check_integrity_violated Then

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

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

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

Line 252: When hr_api.parent_integrity_violated Then

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

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

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

Line 257: When hr_api.unique_integrity_violated Then

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

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

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

Line 488: Raise HR_Api.Validate_Enabled;

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

Line 493: When HR_Api.Validate_Enabled Then

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