DBA Data[Home] [Help]

APPS.PAY_RFI_INS dependencies on HR_API

Line 116: If (p_datetrack_mode <> hr_api.g_insert) then

112: --
113: -- If the datetrack_mode is not INSERT then we must populate the WHO
114: -- columns with the 'old' creation values and 'new' updated values.
115: --
116: If (p_datetrack_mode <> hr_api.g_insert) then
117: hr_utility.set_location(l_proc, 10);
118: --
119: -- Get the object version number for the insert
120: --

Line 199: When hr_api.check_integrity_violated Then

195: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
196: hr_utility.set_location(' Leaving:'||l_proc, 15);
197: --
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
202: pay_rfi_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
202: pay_rfi_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
207: pay_rfi_shd.constraint_error

Line 204: When hr_api.unique_integrity_violated Then

200: -- A check constraint has been violated
201: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
202: pay_rfi_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
207: pay_rfi_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

204: When hr_api.unique_integrity_violated Then
205: -- Unique integrity has been violated
206: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
207: pay_rfi_shd.constraint_error
208: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
209: When Others Then
210: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
211: Raise;
212: End dt_insert_dml;

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

410: --
411: -- Post Failure:
412: -- The Lck process can fail for:
413: -- 1) When attempting to lock the row the row could already be locked by
414: -- another user. This will raise the HR_Api.Object_Locked exception.
415: -- 2) When attempting to the lock the parent which doesn't exist.
416: -- For the entity to be locked the parent must exist!
417: --
418: -- Developer Implementation Notes:

Line 476: l_datetrack_mode varchar2(30) := hr_api.g_insert;

472: ,p_rec in out nocopy pay_rfi_shd.g_rec_type
473: ) is
474: --
475: l_proc varchar2(72) := g_package||'ins';
476: l_datetrack_mode varchar2(30) := hr_api.g_insert;
477: l_validation_start_date date;
478: l_validation_end_date date;
479: --
480: Begin