DBA Data[Home] [Help]

APPS.OTA_EVT_INS dependencies on HR_API

Line 228: When hr_api.check_integrity_violated Then

224: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
231: ota_evt_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
231: ota_evt_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
236: ota_evt_shd.constraint_error

Line 233: When hr_api.parent_integrity_violated Then

229: -- A check constraint has been violated
230: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
231: ota_evt_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
236: ota_evt_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
236: ota_evt_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
241: ota_evt_shd.constraint_error

Line 238: When hr_api.unique_integrity_violated Then

234: -- Parent integrity has been violated
235: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
236: ota_evt_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
241: ota_evt_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
241: ota_evt_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When Others Then
244: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
245: Raise;
246: End insert_dml;

Line 443: Raise HR_Api.Validate_Enabled;

439: -- added for eBS by asud
440: -- If we are validating then raise the Validate_Enabled exception
441: --
442: If p_validate then
443: Raise HR_Api.Validate_Enabled;
444: End If;
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: Exception

Line 448: When HR_Api.Validate_Enabled Then

444: End If;
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 10);
447: Exception
448: When HR_Api.Validate_Enabled Then
449: --
450: -- As the Validate_Enabled exception has been raised
451: -- we must rollback to the savepoint
452: --