APPS.PQH_DOA_INS dependencies on HR_API

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

121: --
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --

Line 189: When hr_api.check_integrity_violated Then

185: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
186: hr_utility.set_location(' Leaving:'||l_proc, 15);
187: --
188: Exception
189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
191: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
192: pqh_doa_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
191: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
192: pqh_doa_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.unique_integrity_violated Then
195: -- Unique integrity has been violated
196: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
197: pqh_doa_shd.constraint_error

Line 194: When hr_api.unique_integrity_violated Then

190: -- A check constraint has been violated
191: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
192: pqh_doa_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.unique_integrity_violated Then
195: -- Unique integrity has been violated
196: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
197: pqh_doa_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

194: When hr_api.unique_integrity_violated Then
195: -- Unique integrity has been violated
196: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
197: pqh_doa_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When Others Then
200: pqh_doa_shd.g_api_dml := false; -- Unset the api dml status
201: Raise;
202: End dt_insert_dml;

Line 401: when hr_api.cannot_find_prog_unit then

397: );
398: --
399: exception
400: --
401: when hr_api.cannot_find_prog_unit then
402: --
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'PQH_DOCUMENT_ATTRIBUTES_F'
405: ,p_hook_type => 'AI');

Line 403: hr_api.cannot_find_prog_unit_error

399: exception
400: --
401: when hr_api.cannot_find_prog_unit then
402: --
403: hr_api.cannot_find_prog_unit_error
404: (p_module_name => 'PQH_DOCUMENT_ATTRIBUTES_F'
405: ,p_hook_type => 'AI');
406: --
407: end;

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

432: --
433: -- Post Failure:
434: -- The Lck process can fail for:
435: -- 1) When attempting to lock the row the row could already be locked by
436: -- another user. This will raise the HR_Api.Object_Locked exception.
437: -- 2) When attempting to the lock the parent which doesn't exist.
438: -- For the entity to be locked the parent must exist!
439: --
440: -- Developer Implementation Notes:

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

491: ,p_rec in out NOCOPY pqh_doa_shd.g_rec_type
492: ) is
493: --
494: l_proc varchar2(72) := g_package||'ins';
495: l_datetrack_mode varchar2(30) := hr_api.g_insert;
496: l_validation_start_date date;
497: l_validation_end_date date;
498: --
499: Begin