DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on PA_UTILS

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

335: OPEN l_assignments_csr;
336: FETCH l_assignments_csr INTO l_assignments_rec;
337: IF l_assignments_csr%NOTFOUND THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: pa_utils.add_message (p_app_short_name => 'PA',
340: p_msg_name => 'PA_INVALID_ASMGT_ID');
341: x_error_message_code := 'PA_INVALID_ASMGT_ID'; -- msg already avail
342: CLOSE l_assignments_csr;
343: x_msg_count := x_msg_count + 1;

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

348: /*
349: -- Do not launch a workflow if an approval is already pending
350: IF NVL(l_assignments_rec.pending_approval_flag, 'N') = 'Y' THEN
351: x_return_status := FND_API.G_RET_STS_ERROR;
352: pa_utils.add_message (p_app_short_name => 'PA',
353: p_msg_name =>
354: 'PA_ASG_APPROVAL_PENDING' );
355: x_error_message_code := 'PA_ASG_APPROVAL_PENDING';
356: x_msg_count := x_msg_count + 1;

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

362: l_wf_failure_status_code,
363: l_project_status_name ;
364: IF l_stus_csr%NOTFOUND THEN
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: pa_utils.add_message (p_app_short_name => 'PA',
367: p_msg_name => 'PA_INVALID_STATUS_CODE');
368: x_error_message_code := 'PA_INVALID_STATUS_CODE';-- msg already avail
369: CLOSE l_stus_csr;
370: x_msg_count := x_msg_count + 1;

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

376: FETCH l_projects_csr INTO l_projects_rec;
377: IF l_projects_csr%NOTFOUND THEN
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: x_error_message_code := 'PA_INVALID_PROJECT_ID'; -- msg already avail
380: pa_utils.add_message (p_app_short_name => 'PA',
381: p_msg_name => 'PA_INVALID_PROJECT_ID');
382: CLOSE l_projects_csr;
383: x_msg_count := x_msg_count + 1;
384: ELSE

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

415:
416: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
417: x_return_status := l_return_status;
418: x_error_message_code := l_error_message_code ;
419: pa_utils.add_message (p_app_short_name => 'PA',
420: p_msg_name => l_error_message_code);
421: END IF;
422: END IF;
423:

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

436: FETCH l_resource_csr INTO l_resource_rec;
437: IF l_resource_csr%NOTFOUND THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: x_error_message_code := 'PA_INVALID_PERSON_ID'; --msg already avail
440: pa_utils.add_message (p_app_short_name => 'PA',
441: p_msg_name => 'PA_INVALID_PERSON_ID');
442: CLOSE l_resource_csr;
443: x_msg_count := x_msg_count + 1;
444: ELSE

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

461: IF l_projects_rec.admin_flag = 'N' THEN
462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
463: x_return_status := l_return_status;
464: x_error_message_code := l_error_message_code;
465: pa_utils.add_message (p_app_short_name => 'PA',
466: p_msg_name => l_error_message_code);
467: END IF;
468: END IF;
469: -- If there are any busines rules violations , then do

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

1504: FETCH l_stus_csr INTO l_stus_rec;
1505: IF l_stus_csr%NOTFOUND THEN
1506: x_return_status := FND_API.G_RET_STS_ERROR;
1507: x_error_message_code := 'PA_INVALID_STATUS_CODE';-- msg already avail
1508: pa_utils.add_message (p_app_short_name => 'PA',
1509: p_msg_name => 'PA_INVALID_STATUS_CODE');
1510: l_msg_count := l_msg_count + 1;
1511: CLOSE l_stus_csr;
1512: -- RETURN;

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

5052: FETCH l_assignments_csr INTO l_assignments_rec;
5053:
5054: IF l_assignments_csr%NOTFOUND THEN
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056: pa_utils.add_message (p_app_short_name => 'PA',
5057: p_msg_name => 'PA_INVALID_ASMGT_ID');
5058: x_msg_count := x_msg_count + 1;
5059:
5060: END IF;

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

5089: FETCH l_resource_csr INTO l_resource_rec;
5090:
5091: IF l_resource_csr%NOTFOUND THEN
5092: x_return_status := FND_API.G_RET_STS_ERROR;
5093: pa_utils.add_message (p_app_short_name => 'PA',
5094: p_msg_name => 'PA_INVALID_PERSON_ID');
5095: x_msg_count := x_msg_count + 1;
5096: END IF;
5097: CLOSE l_resource_csr;

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

5570: FETCH l_assignments_csr INTO l_assignments_rec;
5571:
5572: IF l_assignments_csr%NOTFOUND THEN
5573: x_return_status := FND_API.G_RET_STS_ERROR;
5574: pa_utils.add_message (p_app_short_name => 'PA',
5575: p_msg_name => 'PA_INVALID_ASMGT_ID');
5576: l_msg_count := l_msg_count + 1;
5577:
5578: END IF;

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

6051: ,x_return_status => l_return_status
6052: ,x_error_message_code => l_error_message_code );
6053:
6054: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6055: PA_UTILS.Add_Message( p_app_short_name => 'PA'
6056: ,p_msg_name => l_error_message_code);
6057: END IF;
6058:
6059: l_return_status := FND_API.G_MISS_CHAR;

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

6993: -------------------------------------------------------
6994: OPEN l_projects_csr( p_project_id);
6995: FETCH l_projects_csr INTO l_projects_rec;
6996: IF l_projects_csr%NOTFOUND THEN
6997: pa_utils.add_message (p_app_short_name => 'PA',
6998: p_msg_name => 'PA_INVALID_PROJECT_ID');
6999: END IF;
7000: CLOSE l_projects_csr;
7001:

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

7019: IF l_projects_rec.admin_flag = 'N' THEN
7020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7021: x_return_status := l_return_status;
7022: x_error_message_code := l_error_message_code;
7023: pa_utils.add_message (p_app_short_name => 'PA',
7024: p_msg_name => l_error_message_code);
7025: END IF;
7026: END IF;
7027:

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

7478: FETCH l_assignments_csr INTO l_assignments_rec;
7479:
7480: IF l_assignments_csr%NOTFOUND THEN
7481: x_return_status := FND_API.G_RET_STS_ERROR;
7482: pa_utils.add_message (p_app_short_name => 'PA',
7483: p_msg_name => 'PA_INVALID_ASMGT_ID');
7484: END IF;
7485:
7486: CLOSE l_assignments_csr;

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

8123: FOR i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST LOOP
8124:
8125: FND_MSG_PUB.initialize;
8126:
8127: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8128: ,p_msg_name => 'PA_PROCESS_ABORTED_SYSADMIN');
8129:
8130: SELECT user_id
8131: INTO l_submitter_user_id