APPS.PA_COMPETENCE_PVT dependencies on PA_HR_COMPETENCE_UTILS

Line 121: IF pa_hr_competence_utils.check_competence_exists

117:
118: END IF; /*Project ID NULL */
119: END IF;
120:
121: IF pa_hr_competence_utils.check_competence_exists
122: (p_object_name, l_first_assignment_id, p_competence_id) = 'Y' THEN
123: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR
124: ,p_error_message_code => 'PA_COMPETENCE_ELEMENT_EXISTS');
125: END IF;

Line 126: --dbms_output.put_line('after calling pa_hr_competence_utils.check_competence_exists');

122: (p_object_name, l_first_assignment_id, p_competence_id) = 'Y' THEN
123: Check_Error ( p_return_status => FND_API.G_RET_STS_ERROR
124: ,p_error_message_code => 'PA_COMPETENCE_ELEMENT_EXISTS');
125: END IF;
126: --dbms_output.put_line('after calling pa_hr_competence_utils.check_competence_exists');
127:
128: -- If there are errors, do not proceed to insert the data
129: IF g_noof_errors > 0 THEN
130: x_return_status := FND_API.G_RET_STS_ERROR;

Line 279: IF pa_hr_competence_utils.check_competence_exists

275: END IF;
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277: -- Check if the combination exists. If it does not, then
278: -- should not proceed with the update
279: IF pa_hr_competence_utils.check_competence_exists
280: (p_object_name,p_object_id,p_competence_id) = 'N' THEN
281: Check_Error (p_return_status => FND_API.G_RET_STS_ERROR
282: ,p_error_message_code =>'PA_COMPETENCE_ELE_NOT_EXISTS');
283: END IF;

Line 386: IF pa_hr_competence_utils.check_competence_exists

382: END IF;
383: x_return_status := FND_API.G_RET_STS_SUCCESS;
384: -- Check if the combination exists. If it does not, then
385: -- should not proceed with the delete
386: IF pa_hr_competence_utils.check_competence_exists
387: (p_object_name,p_object_id,p_competence_id) = 'N' THEN
388: Check_Error (p_return_status => FND_API.G_RET_STS_ERROR
389: ,p_error_message_code =>'PA_COMPETENCE_ELE_NOT_EXISTS');
390: END IF;