DBA Data[Home] [Help]

APPS.GHR_REI_INS dependencies on HR_API

Line 190: When hr_api.check_integrity_violated Then

186: );
187: --
188: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: ghr_rei_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.parent_integrity_violated Then

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

189: Exception
190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: ghr_rei_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.parent_integrity_violated Then
195: -- Parent integrity has been violated
196: ghr_rei_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 194: When hr_api.parent_integrity_violated Then

190: When hr_api.check_integrity_violated Then
191: -- A check constraint has been violated
192: ghr_rei_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.parent_integrity_violated Then
195: -- Parent integrity has been violated
196: ghr_rei_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then

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

193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.parent_integrity_violated Then
195: -- Parent integrity has been violated
196: ghr_rei_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: ghr_rei_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 198: When hr_api.unique_integrity_violated Then

194: When hr_api.parent_integrity_violated Then
195: -- Parent integrity has been violated
196: ghr_rei_shd.constraint_error
197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: ghr_rei_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When Others Then

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

197: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
198: When hr_api.unique_integrity_violated Then
199: -- Unique integrity has been violated
200: ghr_rei_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When Others Then
203: Raise;
204: End insert_dml;
205: --

Line 367: when hr_api.cannot_find_prog_unit then

363: p_program_id => p_rec.program_id ,
364: p_program_update_date => p_rec.program_update_date
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: ( p_module_name => 'GHR_PA_REQUEST_EXTRA_INFO'
370: ,p_hook_type => 'AI'
371: );

Line 368: hr_api.cannot_find_prog_unit_error

364: p_program_update_date => p_rec.program_update_date
365: );
366: exception
367: when hr_api.cannot_find_prog_unit then
368: hr_api.cannot_find_prog_unit_error
369: ( p_module_name => 'GHR_PA_REQUEST_EXTRA_INFO'
370: ,p_hook_type => 'AI'
371: );
372: end;

Line 419: Raise HR_Api.Validate_Enabled;

415: --
416: -- If we are validating then raise the Validate_Enabled exception
417: --
418: If p_validate then
419: Raise HR_Api.Validate_Enabled;
420: End If;
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 10);
423: Exception

Line 424: When HR_Api.Validate_Enabled Then

420: End If;
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 10);
423: Exception
424: When HR_Api.Validate_Enabled Then
425: --
426: -- As the Validate_Enabled exception has been raised
427: -- we must rollback to the savepoint
428: --