DBA Data[Home] [Help]

APPS.PAY_ROM_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 175: When hr_api.check_integrity_violated Then

171: --
172: hr_utility.set_location(' Leaving:'||l_proc, 15);
173: --
174: Exception
175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: --
178: pay_rom_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

175: When hr_api.check_integrity_violated Then
176: -- A check constraint has been violated
177: --
178: pay_rom_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --
183: pay_rom_shd.constraint_error

Line 180: When hr_api.unique_integrity_violated Then

176: -- A check constraint has been violated
177: --
178: pay_rom_shd.constraint_error
179: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --
183: pay_rom_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

180: When hr_api.unique_integrity_violated Then
181: -- Unique integrity has been violated
182: --
183: pay_rom_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When Others Then
186: --
187: Raise;
188: End dt_insert_dml;

Line 418: when hr_api.cannot_find_prog_unit then

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

Line 420: hr_api.cannot_find_prog_unit_error

416: exception
417: --
418: when hr_api.cannot_find_prog_unit then
419: --
420: hr_api.cannot_find_prog_unit_error
421: (p_module_name => 'PAY_RUN_TYPE_ORG_METHODS_F'
422: ,p_hook_type => 'AI');
423: --
424: end;

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

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

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

514: ,p_rec in out nocopy pay_rom_shd.g_rec_type
515: ) is
516: --
517: l_proc varchar2(72) := g_package||'ins';
518: l_datetrack_mode varchar2(30) := hr_api.g_insert;
519: l_validation_start_date date;
520: l_validation_end_date date;
521: --
522: Begin