DBA Data[Home] [Help]

APPS.GHR_PRH_INS dependencies on HR_API

Line 121: When hr_api.check_integrity_violated Then

117:
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: p_rec := l_rec;
124: ghr_prh_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: p_rec := l_rec;
124: ghr_prh_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: p_rec := l_rec;
129: ghr_prh_shd.constraint_error

Line 126: When hr_api.parent_integrity_violated Then

122: -- A check constraint has been violated
123: p_rec := l_rec;
124: ghr_prh_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: p_rec := l_rec;
129: ghr_prh_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: p_rec := l_rec;
129: ghr_prh_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: p_rec := l_rec;
134: ghr_prh_shd.constraint_error

Line 131: When hr_api.unique_integrity_violated Then

127: -- Parent integrity has been violated
128: p_rec := l_rec;
129: ghr_prh_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: p_rec := l_rec;
134: ghr_prh_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: p_rec := l_rec;
134: ghr_prh_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: p_rec := l_rec;
138: Raise;
139: End insert_dml;

Line 280: when hr_api.cannot_find_prog_unit then

276: p_object_version_number => p_rec.object_version_number
277: );
278:
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: ( p_module_name => 'GHR_PA_ROUTING_HISTORY'
283: ,p_hook_type => 'AI'
284: );

Line 281: hr_api.cannot_find_prog_unit_error

277: );
278:
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: ( p_module_name => 'GHR_PA_ROUTING_HISTORY'
283: ,p_hook_type => 'AI'
284: );
285: end;

Line 337: Raise HR_Api.Validate_Enabled;

333: --
334: -- If we are validating then raise the Validate_Enabled exception
335: --
336: If p_validate then
337: Raise HR_Api.Validate_Enabled;
338: End If;
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 10);
341: Exception

Line 342: When HR_Api.Validate_Enabled Then

338: End If;
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 10);
341: Exception
342: When HR_Api.Validate_Enabled Then
343: --
344: -- As the Validate_Enabled exception has been raised
345: -- we must rollback to the savepoint
346: --