DBA Data[Home] [Help]

APPS.OTA_EVT_INS dependencies on HR_API

Line 226: When hr_api.check_integrity_violated Then

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

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

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

Line 231: When hr_api.parent_integrity_violated Then

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

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

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

Line 236: When hr_api.unique_integrity_violated Then

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

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

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

Line 441: Raise HR_Api.Validate_Enabled;

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

Line 446: When HR_Api.Validate_Enabled Then

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