DBA Data[Home] [Help]

APPS.PER_ADD_INS dependencies on HR_API

Line 213: When hr_api.check_integrity_violated Then

209: per_add_shd.g_api_dml := false; -- Unset the api dml status
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 10);
212: Exception
213: When hr_api.check_integrity_violated Then
214: -- A check constraint has been violated
215: per_add_shd.g_api_dml := false; -- Unset the api dml status
216: per_add_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.check_integrity_violated Then
214: -- A check constraint has been violated
215: per_add_shd.g_api_dml := false; -- Unset the api dml status
216: per_add_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.parent_integrity_violated Then
219: -- Parent integrity has been violated
220: per_add_shd.g_api_dml := false; -- Unset the api dml status
221: per_add_shd.constraint_error

Line 218: When hr_api.parent_integrity_violated Then

214: -- A check constraint has been violated
215: per_add_shd.g_api_dml := false; -- Unset the api dml status
216: per_add_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.parent_integrity_violated Then
219: -- Parent integrity has been violated
220: per_add_shd.g_api_dml := false; -- Unset the api dml status
221: per_add_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.parent_integrity_violated Then
219: -- Parent integrity has been violated
220: per_add_shd.g_api_dml := false; -- Unset the api dml status
221: per_add_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.unique_integrity_violated Then
224: -- Unique integrity has been violated
225: per_add_shd.g_api_dml := false; -- Unset the api dml status
226: per_add_shd.constraint_error

Line 223: When hr_api.unique_integrity_violated Then

219: -- Parent integrity has been violated
220: per_add_shd.g_api_dml := false; -- Unset the api dml status
221: per_add_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.unique_integrity_violated Then
224: -- Unique integrity has been violated
225: per_add_shd.g_api_dml := false; -- Unset the api dml status
226: per_add_shd.constraint_error
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

223: When hr_api.unique_integrity_violated Then
224: -- Unique integrity has been violated
225: per_add_shd.g_api_dml := false; -- Unset the api dml status
226: per_add_shd.constraint_error
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When Others Then
229: per_add_shd.g_api_dml := false; -- Unset the api dml status
230: Raise;
231: End insert_dml;

Line 543: when hr_api.cannot_find_prog_unit then

539: ,p_validate_county => p_validate_county
540: ,p_party_id => p_rec.party_id -- HR/TCA merge
541: );
542: exception
543: when hr_api.cannot_find_prog_unit then
544: hr_api.cannot_find_prog_unit_error
545: (p_module_name => 'PER_ADDRESSES'
546: ,p_hook_type => 'AI'
547: );

Line 544: hr_api.cannot_find_prog_unit_error

540: ,p_party_id => p_rec.party_id -- HR/TCA merge
541: );
542: exception
543: when hr_api.cannot_find_prog_unit then
544: hr_api.cannot_find_prog_unit_error
545: (p_module_name => 'PER_ADDRESSES'
546: ,p_hook_type => 'AI'
547: );
548: end;

Line 627: Raise HR_Api.Validate_Enabled;

623: --
624: -- If we are validating then raise the Validate_Enabled exception
625: --
626: If p_validate then
627: Raise HR_Api.Validate_Enabled;
628: End If;
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 10);
631: Exception

Line 632: When HR_Api.Validate_Enabled Then

628: End If;
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 10);
631: Exception
632: When HR_Api.Validate_Enabled Then
633: --
634: -- As the Validate_Enabled exception has been raised
635: -- we must rollback to the savepoint
636: --