APPS.PER_SPS_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 263: When hr_api.check_integrity_violated Then

259: per_sps_shd.g_api_dml := false; -- Unset the api dml status
260: hr_utility.set_location(' Leaving:'||l_proc, 15);
261: --
262: Exception
263: When hr_api.check_integrity_violated Then
264: -- A check constraint has been violated
265: per_sps_shd.g_api_dml := false; -- Unset the api dml status
266: per_sps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

263: When hr_api.check_integrity_violated Then
264: -- A check constraint has been violated
265: per_sps_shd.g_api_dml := false; -- Unset the api dml status
266: per_sps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When hr_api.unique_integrity_violated Then
269: -- Unique integrity has been violated
270: per_sps_shd.g_api_dml := false; -- Unset the api dml status
271: per_sps_shd.constraint_error

Line 268: When hr_api.unique_integrity_violated Then

264: -- A check constraint has been violated
265: per_sps_shd.g_api_dml := false; -- Unset the api dml status
266: per_sps_shd.constraint_error
267: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
268: When hr_api.unique_integrity_violated Then
269: -- Unique integrity has been violated
270: per_sps_shd.g_api_dml := false; -- Unset the api dml status
271: per_sps_shd.constraint_error
272: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

268: When hr_api.unique_integrity_violated Then
269: -- Unique integrity has been violated
270: per_sps_shd.g_api_dml := false; -- Unset the api dml status
271: per_sps_shd.constraint_error
272: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
273: When Others Then
274: per_sps_shd.g_api_dml := false; -- Unset the api dml status
275: Raise;
276: End dt_insert_dml;

Line 629: when hr_api.cannot_find_prog_unit then

625: );
626: --
627: exception
628: --
629: when hr_api.cannot_find_prog_unit then
630: --
631: hr_api.cannot_find_prog_unit_error
632: (p_module_name => 'PER_SPINAL_POINT_STEPS_F'
633: ,p_hook_type => 'AI');

Line 631: hr_api.cannot_find_prog_unit_error

627: exception
628: --
629: when hr_api.cannot_find_prog_unit then
630: --
631: hr_api.cannot_find_prog_unit_error
632: (p_module_name => 'PER_SPINAL_POINT_STEPS_F'
633: ,p_hook_type => 'AI');
634: --
635: end;

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

660: --
661: -- Post Failure:
662: -- The Lck process can fail for:
663: -- 1) When attempting to lock the row the row could already be locked by
664: -- another user. This will raise the HR_Api.Object_Locked exception.
665: -- 2) When attempting to the lock the parent which doesn't exist.
666: -- For the entity to be locked the parent must exist!
667: --
668: -- Developer Implementation Notes:

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

722: ,p_rec in out nocopy per_sps_shd.g_rec_type
723: ) is
724: --
725: l_proc varchar2(72) := g_package||'ins';
726: l_datetrack_mode varchar2(30) := hr_api.g_insert;
727: l_validation_start_date date;
728: l_validation_end_date date;
729: --
730: Begin