91: --
92: -- If the datetrack_mode is not INSERT then we must populate the WHO
93: -- columns with the 'old' creation values and 'new' updated values.
94: --
95: If (p_datetrack_mode <> hr_api.g_insert) then
96: hr_utility.set_location(l_proc, 10);
97: --
98: -- Select the 'old' created values
99: --
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 15);
185: --
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: --
190: per_abv_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: --
190: per_abv_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: per_abv_shd.constraint_error
188: -- A check constraint has been violated
189: --
190: per_abv_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: per_abv_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: --
195: per_abv_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: --
199: Raise;
200: End dt_insert_dml;
371: );
372: --
373: exception
374: --
375: when hr_api.cannot_find_prog_unit then
376: --
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'PER_ASSIGNMENT_BUDGET_VALUES_F'
379: ,p_hook_type => 'AI');
373: exception
374: --
375: when hr_api.cannot_find_prog_unit then
376: --
377: hr_api.cannot_find_prog_unit_error
378: (p_module_name => 'PER_ASSIGNMENT_BUDGET_VALUES_F'
379: ,p_hook_type => 'AI');
380: --
381: end;
406: --
407: -- Post Failure:
408: -- The Lck process can fail for:
409: -- 1) When attempting to lock the row the row could already be locked by
410: -- another user. This will raise the HR_Api.Object_Locked exception.
411: -- 2) When attempting to the lock the parent which doesn't exist.
412: -- For the entity to be locked the parent must exist!
413: --
414: -- Developer Implementation Notes:
468: ,p_rec in out nocopy per_abv_shd.g_rec_type
469: ) is
470: --
471: l_proc varchar2(72) := g_package||'ins';
472: l_datetrack_mode varchar2(30) := hr_api.g_insert;
473: l_validation_start_date date;
474: l_validation_end_date date;
475: --
476: Begin