APPS.PA_CANDIDATE_PUB dependencies on PA_UTILS

Line 253: pa_utils.add_message

249: FROM pa_project_assignments
250: WHERE assignment_id=p_assignment_id;
251: EXCEPTION
252: WHEN NO_DATA_FOUND THEN
253: pa_utils.add_message
254: (p_app_short_name => 'PA',
255: p_msg_name => 'PA_XC_RECORD_CHANGED');
256: RAISE FND_API.G_EXC_ERROR;
257: WHEN OTHERS THEN

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

284:
285: PA_STARTUP.G_Check_ID_Flag := l_check_id_flag;
286:
287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
288: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
289: ,p_msg_name => l_msg_data );
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292:

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

337: x_msg_count => x_msg_count,
338: x_msg_data => x_msg_data);
339:
340: IF l_ret_code = FND_API.G_FALSE THEN
341: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
342: ,p_msg_name => 'PA_NO_RESOURCE_AUTHORITY' );
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: END IF;

Line 378: pa_utils.add_message

374: RETURN;
375: END IF;
376:
377: IF l_status_code is null THEN
378: pa_utils.add_message
379: (p_app_short_name => 'PA',
380: p_msg_name => 'PA_CAND_STATUS_REQD');
381: RAISE FND_API.G_EXC_ERROR;
382: ELSE

Line 672: pa_utils.add_message

668: EXCEPTION
669: WHEN NO_DATA_FOUND THEN
670: -- Message to indicate that only status with Declined sytem status
671: -- is acceptable
672: pa_utils.add_message
673: (p_app_short_name => 'PA',
674: p_msg_name => 'PA_STS_NOT_VALID');
675:
676: RAISE FND_API.G_EXC_ERROR;

Line 727: pa_utils.add_message

723:
724: EXCEPTION
725: -- if there is no project_status_code for ASSIGN
726: WHEN NO_DATA_FOUND THEN
727: pa_utils.add_message
728: (p_app_short_name => 'PA',
729: p_msg_name => 'PA_NO_ASSIGN_STATUS');
730:
731: RAISE FND_API.G_EXC_ERROR;

Line 946: pa_utils.add_message

942: FROM pa_candidates
943: WHERE candidate_id = p_candidate_id;
944:
945: IF l_old_record_version_number <> p_cand_record_version_number THEN
946: pa_utils.add_message
947: (p_app_short_name => 'PA',
948: p_msg_name => 'PA_XC_RECORD_CHANGED');
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;

Line 979: pa_utils.add_message

975: -- The user should not update Change Reason if status is not
976: -- updated.
977:
978: IF p_change_reason_code is not null THEN
979: pa_utils.add_message
980: (p_app_short_name => 'PA',
981: p_msg_name => 'PA_CAND_NO_STATUS_CHANGE');
982:
983: RAISE FND_API.G_EXC_ERROR;

Line 1021: pa_utils.add_message

1017: (o_status_code => l_old_status_code,
1018: n_status_code => l_status_code) = 'N'
1019: THEN
1020: -- Status Change is not allowed.
1021: pa_utils.add_message
1022: (p_app_short_name => 'PA',
1023: p_msg_name => 'PA_STATUS_CANT_CHANGE');
1024:
1025: RAISE FND_API.G_EXC_ERROR;

Line 1032: pa_utils.add_message

1028: -- Check if the change of status requires change reason
1029: -- to be specified.
1030: IF (pa_project_utils.Check_prj_stus_action_allowed(l_status_code, 'CANDIDATE_CHANGE_REASON') = 'Y')
1031: AND p_change_reason_code is null THEN
1032: pa_utils.add_message
1033: (p_app_short_name => 'PA',
1034: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;

Line 1281: pa_utils.add_message

1277: WHERE candidate_id = p_candidate_id;
1278:
1279: EXCEPTION
1280: WHEN NO_DATA_FOUND THEN
1281: pa_utils.add_message
1282: (p_app_short_name => 'PA',
1283: p_msg_name => 'PA_CAND_NOT_FOUND');
1284: RAISE FND_API.G_EXC_ERROR;
1285: WHEN OTHERS THEN

Line 1290: pa_utils.add_message

1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END;
1288:
1289: IF l_old_record_version_number <> p_record_version_number THEN
1290: pa_utils.add_message
1291: (p_app_short_name => 'PA',
1292: p_msg_name => 'PA_XC_RECORD_CHANGED');
1293: RAISE FND_API.G_EXC_ERROR;
1294: END IF;

Line 1318: pa_utils.add_message

1314: END IF;
1315:
1316: IF l_system_status_code = 'CANDIDATE_SYSTEM_NOMINATED'
1317: AND l_old_system_status_code <> 'CANDIDATE_SYSTEM_NOMINATED' THEN
1318: pa_utils.add_message
1319: (p_app_short_name => 'PA',
1320: p_msg_name => 'PA_CAND_STATUS_NOT_ALLOWED');
1321: RAISE FND_API.G_EXC_ERROR;
1322: END IF;

Line 1331: pa_utils.add_message

1327: -- updated.
1328: IF nvl(l_old_status_code,'-1') = nvl(l_status_code,'-1') THEN
1329:
1330: IF p_change_reason_code is not null THEN
1331: pa_utils.add_message
1332: (p_app_short_name => 'PA',
1333: p_msg_name => 'PA_CAND_NO_STATUS_CHANGE');
1334: RAISE FND_API.G_EXC_ERROR;
1335:

Line 1349: pa_utils.add_message

1345: -- if Status Change is not allowed.
1346: IF Pa_Project_Stus_Utils.Allow_Status_Change
1347: (o_status_code => l_old_status_code,
1348: n_status_code => l_status_code) = 'N' THEN
1349: pa_utils.add_message
1350: (p_app_short_name => 'PA',
1351: p_msg_name => 'PA_STATUS_CANT_CHANGE');
1352:
1353: RAISE FND_API.G_EXC_ERROR;

Line 1360: pa_utils.add_message

1356: -- Check if reason is required for the status change
1357: IF (pa_project_utils.Check_prj_stus_action_allowed
1358: (l_status_code, 'CANDIDATE_CHANGE_REASON') = 'Y') AND
1359: p_change_reason_code is null THEN
1360: pa_utils.add_message
1361: (p_app_short_name => 'PA',
1362: p_msg_name => 'PA_CAND_CHG_REASON_REQD');
1363:
1364: RAISE FND_API.G_EXC_ERROR;

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

1884: OPEN l_assignments_csr;
1885: FETCH l_assignments_csr INTO l_assignments_rec;
1886: IF l_assignments_csr%NOTFOUND THEN
1887: x_return_status := FND_API.G_RET_STS_ERROR;
1888: pa_utils.add_message (p_app_short_name => 'PA',
1889: p_msg_name => 'PA_INVALID_ASMGT_ID');
1890: CLOSE l_assignments_csr;
1891: ELSE
1892: CLOSE l_assignments_csr;

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

1895: OPEN l_projects_csr(l_assignments_rec.project_id);
1896: FETCH l_projects_csr INTO l_projects_rec;
1897: IF l_projects_csr%NOTFOUND THEN
1898: x_return_status := FND_API.G_RET_STS_ERROR;
1899: pa_utils.add_message (p_app_short_name => 'PA',
1900: p_msg_name => 'PA_INVALID_PROJECT_ID');
1901: CLOSE l_projects_csr;
1902: ELSE
1903: CLOSE l_projects_csr;