204: --
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 10);
207: Exception
208: When hr_api.check_integrity_violated Then
209: -- A check constraint has been violated
210: --
211: per_ctk_shd.constraint_error
212: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When hr_api.check_integrity_violated Then
209: -- A check constraint has been violated
210: --
211: per_ctk_shd.constraint_error
212: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
213: When hr_api.parent_integrity_violated Then
214: -- Parent integrity has been violated
215: --
216: per_ctk_shd.constraint_error
209: -- A check constraint has been violated
210: --
211: per_ctk_shd.constraint_error
212: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
213: When hr_api.parent_integrity_violated Then
214: -- Parent integrity has been violated
215: --
216: per_ctk_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
213: When hr_api.parent_integrity_violated Then
214: -- Parent integrity has been violated
215: --
216: per_ctk_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: --
221: per_ctk_shd.constraint_error
214: -- Parent integrity has been violated
215: --
216: per_ctk_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: --
221: per_ctk_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: --
221: per_ctk_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When Others Then
224: --
225: Raise;
226: End insert_dml;
346: --
347: -- Add Create Eligibility Object logic
348: --
349:
350: --l_effective_end_date := hr_api.g_eot;
351: --l_effective_date := hr_api.g_sys;
352: --l_business_group_id :=
353: --
354: -- Get the business group_id
347: -- Add Create Eligibility Object logic
348: --
349:
350: --l_effective_end_date := hr_api.g_eot;
351: --l_effective_date := hr_api.g_sys;
352: --l_business_group_id :=
353: --
354: -- Get the business group_id
355: --
361: --
362: --
363: -- Add Create Eligibility Object logic
364: --
365: if ( nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number ) then
366: --
367: open c_elig_prfl_dates(p_rec.eligibility_profile_id);
368: fetch c_elig_prfl_dates into l_effective_date;
369: close c_elig_prfl_dates;
562: );
563: --
564: exception
565: --
566: when hr_api.cannot_find_prog_unit then
567: --
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'PER_TASKS_IN_CHECKLIST'
570: ,p_hook_type => 'AI');
564: exception
565: --
566: when hr_api.cannot_find_prog_unit then
567: --
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'PER_TASKS_IN_CHECKLIST'
570: ,p_hook_type => 'AI');
571: --
572: end;