DBA Data[Home] [Help]

APPS.GHR_PAH_INS dependencies on HR_API

Line 496: When hr_api.check_integrity_violated Then

492: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 10);
495: Exception
496: When hr_api.check_integrity_violated Then
497: -- A check constraint has been violated
498: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
499: ghr_pah_shd.constraint_error
500: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

496: When hr_api.check_integrity_violated Then
497: -- A check constraint has been violated
498: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
499: ghr_pah_shd.constraint_error
500: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
501: When hr_api.parent_integrity_violated Then
502: -- Parent integrity has been violated
503: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
504: ghr_pah_shd.constraint_error

Line 501: When hr_api.parent_integrity_violated Then

497: -- A check constraint has been violated
498: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
499: ghr_pah_shd.constraint_error
500: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
501: When hr_api.parent_integrity_violated Then
502: -- Parent integrity has been violated
503: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
504: ghr_pah_shd.constraint_error
505: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

501: When hr_api.parent_integrity_violated Then
502: -- Parent integrity has been violated
503: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
504: ghr_pah_shd.constraint_error
505: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
506: When hr_api.unique_integrity_violated Then
507: -- Unique integrity has been violated
508: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
509: ghr_pah_shd.constraint_error

Line 506: When hr_api.unique_integrity_violated Then

502: -- Parent integrity has been violated
503: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
504: ghr_pah_shd.constraint_error
505: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
506: When hr_api.unique_integrity_violated Then
507: -- Unique integrity has been violated
508: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
509: ghr_pah_shd.constraint_error
510: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

506: When hr_api.unique_integrity_violated Then
507: -- Unique integrity has been violated
508: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
509: ghr_pah_shd.constraint_error
510: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
511: When Others Then
512: ghr_pah_shd.g_api_dml := false; -- Unset the api dml status
513: Raise;
514: End insert_dml;

Line 828: when hr_api.cannot_find_prog_unit then

824: p_INFORMATION199 => p_rec.INFORMATION199 ,
825: p_INFORMATION200 => p_rec.INFORMATION200
826: );
827: exception
828: when hr_api.cannot_find_prog_unit then
829: hr_api.cannot_find_prog_unit_error
830: ( p_module_name => 'GHR_PA_HISTORY'
831: ,p_hook_type => 'AI'
832: );

Line 829: hr_api.cannot_find_prog_unit_error

825: p_INFORMATION200 => p_rec.INFORMATION200
826: );
827: exception
828: when hr_api.cannot_find_prog_unit then
829: hr_api.cannot_find_prog_unit_error
830: ( p_module_name => 'GHR_PA_HISTORY'
831: ,p_hook_type => 'AI'
832: );
833: end;