APPS.PQP_AAT_INS dependencies on HR_API

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

99: --
100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> hr_api.g_insert) then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --

Line 317: When hr_api.check_integrity_violated Then

313: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
314: hr_utility.set_location(' Leaving:'||l_proc, 15);
315: --
316: Exception
317: When hr_api.check_integrity_violated Then
318: -- A check constraint has been violated
319: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
320: pqp_aat_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

317: When hr_api.check_integrity_violated Then
318: -- A check constraint has been violated
319: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
320: pqp_aat_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
325: pqp_aat_shd.constraint_error

Line 322: When hr_api.unique_integrity_violated Then

318: -- A check constraint has been violated
319: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
320: pqp_aat_shd.constraint_error
321: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
325: pqp_aat_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

322: When hr_api.unique_integrity_violated Then
323: -- Unique integrity has been violated
324: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
325: pqp_aat_shd.constraint_error
326: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
327: When Others Then
328: pqp_aat_shd.g_api_dml := false; -- Unset the api dml status
329: Raise;
330: End dt_insert_dml;

Line 645: when hr_api.cannot_find_prog_unit then

641: );
642: --
643: exception
644: --
645: when hr_api.cannot_find_prog_unit then
646: --
647: hr_api.cannot_find_prog_unit_error
648: (p_module_name => 'PQP_ASSIGNMENT_ATTRIBUTES_F'
649: ,p_hook_type => 'AI');

Line 647: hr_api.cannot_find_prog_unit_error

643: exception
644: --
645: when hr_api.cannot_find_prog_unit then
646: --
647: hr_api.cannot_find_prog_unit_error
648: (p_module_name => 'PQP_ASSIGNMENT_ATTRIBUTES_F'
649: ,p_hook_type => 'AI');
650: --
651: end;

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

676: --
677: -- Post Failure:
678: -- The Lck process can fail for:
679: -- 1) When attempting to lock the row the row could already be locked by
680: -- another user. This will raise the HR_Api.Object_Locked exception.
681: -- 2) When attempting to the lock the parent which doesn't exist.
682: -- For the entity to be locked the parent must exist!
683: --
684: -- Developer Implementation Notes:

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

735: ,p_rec in out nocopy pqp_aat_shd.g_rec_type
736: ) is
737: --
738: l_proc varchar2(72) := g_package||'ins';
739: l_datetrack_mode varchar2(30) := hr_api.g_insert;
740: l_validation_start_date date;
741: l_validation_end_date date;
742: --
743: Begin