DBA Data[Home] [Help]

APPS.GHR_DUT_INS dependencies on HR_API

Line 179: When hr_api.check_integrity_violated Then

175: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
176: hr_utility.set_location(' Leaving:'||l_proc, 15);
177: --
178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
182: ghr_dut_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
182: ghr_dut_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated
186: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
187: ghr_dut_shd.constraint_error

Line 184: When hr_api.unique_integrity_violated Then

180: -- A check constraint has been violated
181: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
182: ghr_dut_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated
186: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
187: ghr_dut_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

184: When hr_api.unique_integrity_violated Then
185: -- Unique integrity has been violated
186: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
187: ghr_dut_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When Others Then
190: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
191: Raise;
192: End dt_insert_dml;

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

365: --
366: -- Post Failure:
367: -- The Lck process can fail for:
368: -- 1) When attempting to lock the row the row could already be locked by
369: -- another user. This will raise the HR_Api.Object_Locked exception.
370: -- 2) When attempting to the lock the parent which doesn't exist.
371: -- For the entity to be locked the parent must exist!
372: --
373: -- Developer Implementation Notes: