DBA Data[Home] [Help]

APPS.PER_ASG_INS dependencies on HR_API

Line 396: When hr_api.check_integrity_violated Then

392: per_asg_shd.g_api_dml := false; -- Unset the api dml status
393: hr_utility.set_location(' Leaving:'||l_proc, 15);
394: --
395: Exception
396: When hr_api.check_integrity_violated Then
397: -- A check constraint has been violated
398: per_asg_shd.g_api_dml := false; -- Unset the api dml status
399: per_asg_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

396: When hr_api.check_integrity_violated Then
397: -- A check constraint has been violated
398: per_asg_shd.g_api_dml := false; -- Unset the api dml status
399: per_asg_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When hr_api.unique_integrity_violated Then
402: -- Unique integrity has been violated
403: per_asg_shd.g_api_dml := false; -- Unset the api dml status
404: per_asg_shd.constraint_error

Line 401: When hr_api.unique_integrity_violated Then

397: -- A check constraint has been violated
398: per_asg_shd.g_api_dml := false; -- Unset the api dml status
399: per_asg_shd.constraint_error
400: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401: When hr_api.unique_integrity_violated Then
402: -- Unique integrity has been violated
403: per_asg_shd.g_api_dml := false; -- Unset the api dml status
404: per_asg_shd.constraint_error
405: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

401: When hr_api.unique_integrity_violated Then
402: -- Unique integrity has been violated
403: per_asg_shd.g_api_dml := false; -- Unset the api dml status
404: per_asg_shd.constraint_error
405: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
406: When Others Then
407: per_asg_shd.g_api_dml := false; -- Unset the api dml status
408: Raise;
409: End dt_insert_dml;

Line 800: when hr_api.cannot_find_prog_unit then

796: ,p_po_header_id => p_rec.po_header_id
797: ,p_po_line_id => p_rec.po_line_id
798: ,p_projected_assignment_end => p_rec.projected_assignment_end);
799: exception
800: when hr_api.cannot_find_prog_unit then
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
803: ,p_hook_type => 'AI'
804: );

Line 801: hr_api.cannot_find_prog_unit_error

797: ,p_po_line_id => p_rec.po_line_id
798: ,p_projected_assignment_end => p_rec.projected_assignment_end);
799: exception
800: when hr_api.cannot_find_prog_unit then
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'PER_ALL_ASSIGNMENTS_F'
803: ,p_hook_type => 'AI'
804: );
805: end;

Line 976: -- another user. This will raise the HR_Api.Object_Locked exception.

972: --
973: -- Post Failure:
974: -- The Lck process can fail for:
975: -- 1) When attempting to lock the row the row could already be locked by
976: -- another user. This will raise the HR_Api.Object_Locked exception.
977: -- 2) When attempting to the lock the parent which doesn't exist.
978: -- For the entity to be locked the parent must exist!
979: --
980: -- Developer Implementation Notes:

Line 1141: Raise HR_Api.Validate_Enabled;

1137: --
1138: -- If we are validating then raise the Validate_Enabled exception
1139: --
1140: If p_validate then
1141: Raise HR_Api.Validate_Enabled;
1142: End If;
1143: --
1144: hr_utility.set_location(' Leaving:'||l_proc, 10);
1145: Exception

Line 1146: When HR_Api.Validate_Enabled Then

1142: End If;
1143: --
1144: hr_utility.set_location(' Leaving:'||l_proc, 10);
1145: Exception
1146: When HR_Api.Validate_Enabled Then
1147: --
1148: -- As the Validate_Enabled exception has been raised
1149: -- we must rollback to the savepoint
1150: --