DBA Data[Home] [Help]

APPS.BEN_PSL_INS dependencies on HR_API

Line 240: When hr_api.check_integrity_violated Then

236: ben_psl_shd.g_api_dml := false; -- Unset the api dml status
237: hr_utility.set_location(' Leaving:'||l_proc, 15);
238: --
239: Exception
240: When hr_api.check_integrity_violated Then
241: -- A check constraint has been violated
242: ben_psl_shd.g_api_dml := false; -- Unset the api dml status
243: ben_psl_shd.constraint_error
244: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

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

Line 245: When hr_api.unique_integrity_violated Then

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

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

245: When hr_api.unique_integrity_violated Then
246: -- Unique integrity has been violated
247: ben_psl_shd.g_api_dml := false; -- Unset the api dml status
248: ben_psl_shd.constraint_error
249: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
250: When Others Then
251: ben_psl_shd.g_api_dml := false; -- Unset the api dml status
252: Raise;
253: End dt_insert_dml;

Line 444: when hr_api.cannot_find_prog_unit then

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

Line 446: hr_api.cannot_find_prog_unit_error

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

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

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