370: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
371: hr_utility.set_location(' Leaving:'||l_proc, 15);
372: --
373: Exception
374: When hr_api.check_integrity_violated Then
375: -- A check constraint has been violated
376: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
377: ben_pgm_shd.constraint_error
378: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
374: When hr_api.check_integrity_violated Then
375: -- A check constraint has been violated
376: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
377: ben_pgm_shd.constraint_error
378: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
379: When hr_api.unique_integrity_violated Then
380: -- Unique integrity has been violated
381: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
382: ben_pgm_shd.constraint_error
375: -- A check constraint has been violated
376: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
377: ben_pgm_shd.constraint_error
378: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
379: When hr_api.unique_integrity_violated Then
380: -- Unique integrity has been violated
381: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
382: ben_pgm_shd.constraint_error
383: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
379: When hr_api.unique_integrity_violated Then
380: -- Unique integrity has been violated
381: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
382: ben_pgm_shd.constraint_error
383: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
384: When Others Then
385: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
386: Raise;
387: End dt_insert_dml;
563: --
564: -- Post Failure:
565: -- The Lck process can fail for:
566: -- 1) When attempting to lock the row the row could already be locked by
567: -- another user. This will raise the HR_Api.Object_Locked exception.
568: -- 2) When attempting to the lock the parent which doesn't exist.
569: -- For the entity to be locked the parent must exist!
570: --
571: -- Developer Implementation Notes: