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_TAV_INS dependencies on HR_API

Line 203: When hr_api.check_integrity_violated Then

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

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

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

Line 208: When hr_api.parent_integrity_violated Then

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

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

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

Line 213: When hr_api.unique_integrity_violated Then

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

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

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

Line 409: Raise HR_Api.Validate_Enabled;

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

Line 414: When HR_Api.Validate_Enabled Then

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