DBA Data[Home] [Help]

APPS.BEN_SVA_INS dependencies on HR_API

Line 228: When hr_api.check_integrity_violated Then

224: ben_sva_shd.g_api_dml := false; -- Unset the api dml status
225: hr_utility.set_location(' Leaving:'||l_proc, 15);
226: --
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: ben_sva_shd.g_api_dml := false; -- Unset the api dml status
231: ben_sva_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: ben_sva_shd.g_api_dml := false; -- Unset the api dml status
231: ben_sva_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: ben_sva_shd.g_api_dml := false; -- Unset the api dml status
236: ben_sva_shd.constraint_error

Line 233: When hr_api.unique_integrity_violated Then

229: -- A check constraint has been violated
230: ben_sva_shd.g_api_dml := false; -- Unset the api dml status
231: ben_sva_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: ben_sva_shd.g_api_dml := false; -- Unset the api dml status
236: ben_sva_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.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: ben_sva_shd.g_api_dml := false; -- Unset the api dml status
236: ben_sva_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When Others Then
239: ben_sva_shd.g_api_dml := false; -- Unset the api dml status
240: Raise;
241: End dt_insert_dml;

Line 427: when hr_api.cannot_find_prog_unit then

423: );
424: --
425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'ben_svc_area_f'
431: ,p_hook_type => 'AI');

Line 429: hr_api.cannot_find_prog_unit_error

425: exception
426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'ben_svc_area_f'
431: ,p_hook_type => 'AI');
432: --
433: end;

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

462: --
463: -- Post Failure:
464: -- The Lck process can fail for:
465: -- 1) When attempting to lock the row the row could already be locked by
466: -- another user. This will raise the HR_Api.Object_Locked exception.
467: -- 2) When attempting to the lock the parent which doesn't exist.
468: -- For the entity to be locked the parent must exist!
469: --
470: -- Developer Implementation Notes: