DBA Data[Home] [Help]

APPS.PQH_GIN_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 197: When hr_api.check_integrity_violated Then

193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 15);
195: --
196: Exception
197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
199: --
200: pqh_gin_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
199: --
200: pqh_gin_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: --
205: pqh_gin_shd.constraint_error

Line 202: When hr_api.unique_integrity_violated Then

198: -- A check constraint has been violated
199: --
200: pqh_gin_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: --
205: pqh_gin_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: --
205: pqh_gin_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: --
209: Raise;
210: End dt_insert_dml;

Line 415: when hr_api.cannot_find_prog_unit then

411: );
412: --
413: exception
414: --
415: when hr_api.cannot_find_prog_unit then
416: --
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'PQH_FR_GLOBAL_INDICES_F'
419: ,p_hook_type => 'AI');

Line 417: hr_api.cannot_find_prog_unit_error

413: exception
414: --
415: when hr_api.cannot_find_prog_unit then
416: --
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'PQH_FR_GLOBAL_INDICES_F'
419: ,p_hook_type => 'AI');
420: --
421: end;

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

446: --
447: -- Post Failure:
448: -- The Lck process can fail for:
449: -- 1) When attempting to lock the row the row could already be locked by
450: -- another user. This will raise the HR_Api.Object_Locked exception.
451: -- 2) When attempting to the lock the parent which doesn't exist.
452: -- For the entity to be locked the parent must exist!
453: --
454: -- Developer Implementation Notes:

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

505: ,p_rec in out nocopy pqh_gin_shd.g_rec_type
506: ) is
507: --
508: l_proc varchar2(72) := g_package||'ins';
509: l_datetrack_mode varchar2(30) := hr_api.g_insert;
510: l_validation_start_date date;
511: l_validation_end_date date;
512: --
513: Begin