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 5040: pa_utils.add_message (p_app_short_name => 'PA',

5036: FETCH l_assignments_csr INTO l_assignments_rec;
5037:
5038: IF l_assignments_csr%NOTFOUND THEN
5039: x_return_status := FND_API.G_RET_STS_ERROR;
5040: pa_utils.add_message (p_app_short_name => 'PA',
5041: p_msg_name => 'PA_INVALID_ASMGT_ID');
5042: x_msg_count := x_msg_count + 1;
5043:
5044: END IF;

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

5073: FETCH l_resource_csr INTO l_resource_rec;
5074:
5075: IF l_resource_csr%NOTFOUND THEN
5076: x_return_status := FND_API.G_RET_STS_ERROR;
5077: pa_utils.add_message (p_app_short_name => 'PA',
5078: p_msg_name => 'PA_INVALID_PERSON_ID');
5079: x_msg_count := x_msg_count + 1;
5080: END IF;
5081: CLOSE l_resource_csr;

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

5554: FETCH l_assignments_csr INTO l_assignments_rec;
5555:
5556: IF l_assignments_csr%NOTFOUND THEN
5557: x_return_status := FND_API.G_RET_STS_ERROR;
5558: pa_utils.add_message (p_app_short_name => 'PA',
5559: p_msg_name => 'PA_INVALID_ASMGT_ID');
5560: l_msg_count := l_msg_count + 1;
5561:
5562: END IF;

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

6035: ,x_return_status => l_return_status
6036: ,x_error_message_code => l_error_message_code );
6037:
6038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6039: PA_UTILS.Add_Message( p_app_short_name => 'PA'
6040: ,p_msg_name => l_error_message_code);
6041: END IF;
6042:
6043: l_return_status := FND_API.G_MISS_CHAR;

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

6977: -------------------------------------------------------
6978: OPEN l_projects_csr( p_project_id);
6979: FETCH l_projects_csr INTO l_projects_rec;
6980: IF l_projects_csr%NOTFOUND THEN
6981: pa_utils.add_message (p_app_short_name => 'PA',
6982: p_msg_name => 'PA_INVALID_PROJECT_ID');
6983: END IF;
6984: CLOSE l_projects_csr;
6985:

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

7003: IF l_projects_rec.admin_flag = 'N' THEN
7004: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7005: x_return_status := l_return_status;
7006: x_error_message_code := l_error_message_code;
7007: pa_utils.add_message (p_app_short_name => 'PA',
7008: p_msg_name => l_error_message_code);
7009: END IF;
7010: END IF;
7011:

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

7462: FETCH l_assignments_csr INTO l_assignments_rec;
7463:
7464: IF l_assignments_csr%NOTFOUND THEN
7465: x_return_status := FND_API.G_RET_STS_ERROR;
7466: pa_utils.add_message (p_app_short_name => 'PA',
7467: p_msg_name => 'PA_INVALID_ASMGT_ID');
7468: END IF;
7469:
7470: CLOSE l_assignments_csr;

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

8107: FOR i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST LOOP
8108:
8109: FND_MSG_PUB.initialize;
8110:
8111: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8112: ,p_msg_name => 'PA_PROCESS_ABORTED_SYSADMIN');
8113:
8114: SELECT user_id
8115: INTO l_submitter_user_id