APPS.PER_CTK_INS dependencies on HR_API

Line 208: When hr_api.check_integrity_violated Then

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));

Line 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

Line 213: When hr_api.parent_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
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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

Line 218: When hr_api.unique_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
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 350: --l_effective_end_date := hr_api.g_eot;

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

Line 351: --l_effective_date := hr_api.g_sys;

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: --

Line 365: if ( nvl(p_rec.eligibility_profile_id, hr_api.g_number) <> hr_api.g_number ) then

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;

Line 566: when hr_api.cannot_find_prog_unit then

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');

Line 568: hr_api.cannot_find_prog_unit_error

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;