APPS.PA_CANDIDATE_PUB dependencies on PA_UTILS

Line 274: pa_utils.add_message

270: FROM pa_project_assignments
271: WHERE assignment_id=p_assignment_id;
272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: pa_utils.add_message
275: (p_app_short_name => 'PA',
276: p_msg_name => 'PA_XC_RECORD_CHANGED');
277: RAISE FND_API.G_EXC_ERROR;
278: WHEN OTHERS THEN

Line 309: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

305:
306: PA_STARTUP.G_Check_ID_Flag := l_check_id_flag;
307:
308: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
309: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
310: ,p_msg_name => l_msg_data );
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313:

Line 362: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

358: x_msg_count => x_msg_count,
359: x_msg_data => x_msg_data);
360:
361: IF l_ret_code = FND_API.G_FALSE THEN
362: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
363: ,p_msg_name => 'PA_NO_RESOURCE_AUTHORITY' );
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366: END IF;

Line 399: pa_utils.add_message

395: RETURN;
396: END IF;
397:
398: IF l_status_code is null THEN
399: pa_utils.add_message
400: (p_app_short_name => 'PA',
401: p_msg_name => 'PA_CAND_STATUS_REQD');
402: RAISE FND_API.G_EXC_ERROR;
403: ELSE

Line 746: pa_utils.add_message

742: EXCEPTION
743: WHEN NO_DATA_FOUND THEN
744: -- Message to indicate that only status with Declined sytem status
745: -- is acceptable
746: pa_utils.add_message
747: (p_app_short_name => 'PA',
748: p_msg_name => 'PA_STS_NOT_VALID');
749:
750: RAISE FND_API.G_EXC_ERROR;

Line 818: pa_utils.add_message

814:
815: EXCEPTION
816: -- if there is no project_status_code for ASSIGN
817: WHEN NO_DATA_FOUND THEN
818: pa_utils.add_message
819: (p_app_short_name => 'PA',
820: p_msg_name => 'PA_NO_ASSIGN_STATUS');
821:
822: RAISE FND_API.G_EXC_ERROR;

Line 1073: pa_utils.add_message

1069: FROM pa_candidates
1070: WHERE candidate_id = p_candidate_id;
1071:
1072: IF l_old_record_version_number <> p_cand_record_version_number THEN
1073: pa_utils.add_message
1074: (p_app_short_name => 'PA',
1075: p_msg_name => 'PA_XC_RECORD_CHANGED');
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;

Line 1106: pa_utils.add_message

1102: -- The user should not update Change Reason if status is not
1103: -- updated.
1104:
1105: IF p_change_reason_code is not null THEN
1106: pa_utils.add_message
1107: (p_app_short_name => 'PA',
1108: p_msg_name => 'PA_CAND_NO_STATUS_CHANGE');
1109:
1110: RAISE FND_API.G_EXC_ERROR;

Line 1148: pa_utils.add_message

1144: (o_status_code => l_old_status_code,
1145: n_status_code => l_status_code) = 'N'
1146: THEN
1147: -- Status Change is not allowed.
1148: pa_utils.add_message
1149: (p_app_short_name => 'PA',
1150: p_msg_name => 'PA_STATUS_CANT_CHANGE');
1151:
1152: RAISE FND_API.G_EXC_ERROR;

Line 1159: pa_utils.add_message

1155: -- Check if the change of status requires change reason
1156: -- to be specified.
1157: IF (pa_project_utils.Check_prj_stus_action_allowed(l_status_code, 'CANDIDATE_CHANGE_REASON') = 'Y')
1158: AND p_change_reason_code is null THEN
1159: pa_utils.add_message
1160: (p_app_short_name => 'PA',
1161: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;

Line 1482: pa_utils.add_message

1478: WHERE candidate_id = p_candidate_id;
1479:
1480: EXCEPTION
1481: WHEN NO_DATA_FOUND THEN
1482: pa_utils.add_message
1483: (p_app_short_name => 'PA',
1484: p_msg_name => 'PA_CAND_NOT_FOUND');
1485: RAISE FND_API.G_EXC_ERROR;
1486: WHEN OTHERS THEN

Line 1491: pa_utils.add_message

1487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1488: END;
1489:
1490: IF l_old_record_version_number <> p_record_version_number THEN
1491: pa_utils.add_message
1492: (p_app_short_name => 'PA',
1493: p_msg_name => 'PA_XC_RECORD_CHANGED');
1494: RAISE FND_API.G_EXC_ERROR;
1495: END IF;

Line 1519: pa_utils.add_message

1515: END IF;
1516:
1517: IF l_system_status_code = 'CANDIDATE_SYSTEM_NOMINATED'
1518: AND l_old_system_status_code <> 'CANDIDATE_SYSTEM_NOMINATED' THEN
1519: pa_utils.add_message
1520: (p_app_short_name => 'PA',
1521: p_msg_name => 'PA_CAND_STATUS_NOT_ALLOWED');
1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;

Line 1532: pa_utils.add_message

1528: -- updated.
1529: IF nvl(l_old_status_code,'-1') = nvl(l_status_code,'-1') THEN
1530:
1531: IF p_change_reason_code is not null THEN
1532: pa_utils.add_message
1533: (p_app_short_name => 'PA',
1534: p_msg_name => 'PA_CAND_NO_STATUS_CHANGE');
1535: RAISE FND_API.G_EXC_ERROR;
1536:

Line 1550: pa_utils.add_message

1546: -- if Status Change is not allowed.
1547: IF Pa_Project_Stus_Utils.Allow_Status_Change
1548: (o_status_code => l_old_status_code,
1549: n_status_code => l_status_code) = 'N' THEN
1550: pa_utils.add_message
1551: (p_app_short_name => 'PA',
1552: p_msg_name => 'PA_STATUS_CANT_CHANGE');
1553:
1554: RAISE FND_API.G_EXC_ERROR;

Line 1561: pa_utils.add_message

1557: -- Check if reason is required for the status change
1558: IF (pa_project_utils.Check_prj_stus_action_allowed
1559: (l_status_code, 'CANDIDATE_CHANGE_REASON') = 'Y') AND
1560: p_change_reason_code is null THEN
1561: pa_utils.add_message
1562: (p_app_short_name => 'PA',
1563: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1564:
1565: RAISE FND_API.G_EXC_ERROR;

Line 2142: pa_utils.add_message (p_app_short_name => 'PA',

2138: OPEN l_assignments_csr;
2139: FETCH l_assignments_csr INTO l_assignments_rec;
2140: IF l_assignments_csr%NOTFOUND THEN
2141: x_return_status := FND_API.G_RET_STS_ERROR;
2142: pa_utils.add_message (p_app_short_name => 'PA',
2143: p_msg_name => 'PA_INVALID_ASMGT_ID');
2144: CLOSE l_assignments_csr;
2145: ELSE
2146: CLOSE l_assignments_csr;

Line 2153: pa_utils.add_message (p_app_short_name => 'PA',

2149: OPEN l_projects_csr(l_assignments_rec.project_id);
2150: FETCH l_projects_csr INTO l_projects_rec;
2151: IF l_projects_csr%NOTFOUND THEN
2152: x_return_status := FND_API.G_RET_STS_ERROR;
2153: pa_utils.add_message (p_app_short_name => 'PA',
2154: p_msg_name => 'PA_INVALID_PROJECT_ID');
2155: CLOSE l_projects_csr;
2156: ELSE
2157: CLOSE l_projects_csr;