DBA Data[Home] [Help]

APPS.BEN_PGM_INS dependencies on HR_API

Line 372: When hr_api.check_integrity_violated Then

368: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
369: hr_utility.set_location(' Leaving:'||l_proc, 15);
370: --
371: Exception
372: When hr_api.check_integrity_violated Then
373: -- A check constraint has been violated
374: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
375: ben_pgm_shd.constraint_error
376: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

372: When hr_api.check_integrity_violated Then
373: -- A check constraint has been violated
374: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
375: ben_pgm_shd.constraint_error
376: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
377: When hr_api.unique_integrity_violated Then
378: -- Unique integrity has been violated
379: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
380: ben_pgm_shd.constraint_error

Line 377: When hr_api.unique_integrity_violated Then

373: -- A check constraint has been violated
374: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
375: ben_pgm_shd.constraint_error
376: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
377: When hr_api.unique_integrity_violated Then
378: -- Unique integrity has been violated
379: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
380: ben_pgm_shd.constraint_error
381: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

377: When hr_api.unique_integrity_violated Then
378: -- Unique integrity has been violated
379: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
380: ben_pgm_shd.constraint_error
381: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
382: When Others Then
383: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status
384: Raise;
385: End dt_insert_dml;

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

561: --
562: -- Post Failure:
563: -- The Lck process can fail for:
564: -- 1) When attempting to lock the row the row could already be locked by
565: -- another user. This will raise the HR_Api.Object_Locked exception.
566: -- 2) When attempting to the lock the parent which doesn't exist.
567: -- For the entity to be locked the parent must exist!
568: --
569: -- Developer Implementation Notes: