336: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
337: hr_utility.set_location(' Leaving:'||l_proc, 15);
338: --
339: Exception
340: When hr_api.check_integrity_violated Then
341: -- A check constraint has been violated
342: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
343: ben_cpp_shd.constraint_error
344: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
340: When hr_api.check_integrity_violated Then
341: -- A check constraint has been violated
342: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
343: ben_cpp_shd.constraint_error
344: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
345: When hr_api.unique_integrity_violated Then
346: -- Unique integrity has been violated
347: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
348: ben_cpp_shd.constraint_error
341: -- A check constraint has been violated
342: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
343: ben_cpp_shd.constraint_error
344: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
345: When hr_api.unique_integrity_violated Then
346: -- Unique integrity has been violated
347: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
348: ben_cpp_shd.constraint_error
349: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
345: When hr_api.unique_integrity_violated Then
346: -- Unique integrity has been violated
347: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
348: ben_cpp_shd.constraint_error
349: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
350: When Others Then
351: ben_cpp_shd.g_api_dml := false; -- Unset the api dml status
352: Raise;
353: End dt_insert_dml;
603: );
604: --
605: exception
606: --
607: when hr_api.cannot_find_prog_unit then
608: --
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'ben_plip_f'
611: ,p_hook_type => 'AI');
605: exception
606: --
607: when hr_api.cannot_find_prog_unit then
608: --
609: hr_api.cannot_find_prog_unit_error
610: (p_module_name => 'ben_plip_f'
611: ,p_hook_type => 'AI');
612: --
613: end;
642: --
643: -- Post Failure:
644: -- The Lck process can fail for:
645: -- 1) When attempting to lock the row the row could already be locked by
646: -- another user. This will raise the HR_Api.Object_Locked exception.
647: -- 2) When attempting to the lock the parent which doesn't exist.
648: -- For the entity to be locked the parent must exist!
649: --
650: -- Developer Implementation Notes: