DBA Data[Home] [Help]

APPS.BEN_ESP_INS dependencies on HR_API

Line 236: When hr_api.check_integrity_violated Then

232: ben_esp_shd.g_api_dml := false; -- Unset the api dml status
233: hr_utility.set_location(' Leaving:'||l_proc, 15);
234: --
235: Exception
236: When hr_api.check_integrity_violated Then
237: -- A check constraint has been violated
238: ben_esp_shd.g_api_dml := false; -- Unset the api dml status
239: ben_esp_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.check_integrity_violated Then
237: -- A check constraint has been violated
238: ben_esp_shd.g_api_dml := false; -- Unset the api dml status
239: ben_esp_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.unique_integrity_violated Then
242: -- Unique integrity has been violated
243: ben_esp_shd.g_api_dml := false; -- Unset the api dml status
244: ben_esp_shd.constraint_error

Line 241: When hr_api.unique_integrity_violated Then

237: -- A check constraint has been violated
238: ben_esp_shd.g_api_dml := false; -- Unset the api dml status
239: ben_esp_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When hr_api.unique_integrity_violated Then
242: -- Unique integrity has been violated
243: ben_esp_shd.g_api_dml := false; -- Unset the api dml status
244: ben_esp_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

241: When hr_api.unique_integrity_violated Then
242: -- Unique integrity has been violated
243: ben_esp_shd.g_api_dml := false; -- Unset the api dml status
244: ben_esp_shd.constraint_error
245: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
246: When Others Then
247: ben_esp_shd.g_api_dml := false; -- Unset the api dml status
248: Raise;
249: End dt_insert_dml;

Line 442: when hr_api.cannot_find_prog_unit then

438: );
439: --
440: exception
441: --
442: when hr_api.cannot_find_prog_unit then
443: --
444: hr_api.cannot_find_prog_unit_error
445: (p_module_name => 'ben_elig_sp_clng_prg_prte_f'
446: ,p_hook_type => 'AI');

Line 444: hr_api.cannot_find_prog_unit_error

440: exception
441: --
442: when hr_api.cannot_find_prog_unit then
443: --
444: hr_api.cannot_find_prog_unit_error
445: (p_module_name => 'ben_elig_sp_clng_prg_prte_f'
446: ,p_hook_type => 'AI');
447: --
448: end;

Line 481: -- another user. This will raise the HR_Api.Object_Locked exception.

477: --
478: -- Post Failure:
479: -- The Lck process can fail for:
480: -- 1) When attempting to lock the row the row could already be locked by
481: -- another user. This will raise the HR_Api.Object_Locked exception.
482: -- 2) When attempting to the lock the parent which doesn't exist.
483: -- For the entity to be locked the parent must exist!
484: --
485: -- Developer Implementation Notes: