DBA Data[Home] [Help]

APPS.BEN_PGM_INS dependencies on HR_API

Line 374: When hr_api.check_integrity_violated Then

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));

Line 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

Line 379: When hr_api.unique_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
383: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

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

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: