DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_UTILS

Line 202: PA_UTILS.Add_Message('PA', l_error_message_code);

198: l_approver_person_id := l_new_approver_person_id;
199: END IF;
200: -- bug 4537865
201: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
202: PA_UTILS.Add_Message('PA', l_error_message_code);
203:
204: ELSE
205: -- Get submitter_person_id : added for bug#2247058
206: OPEN l_submitter_person_id_csr(FND_GLOBAL.USER_ID);

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

205: -- Get submitter_person_id : added for bug#2247058
206: OPEN l_submitter_person_id_csr(FND_GLOBAL.USER_ID);
207: FETCH l_submitter_person_id_csr INTO l_submitter_person_id;
208: IF l_submitter_person_id_csr%NOTFOUND THEN
209: pa_utils.add_message (p_app_short_name => 'PA',
210: p_msg_name => 'PA_NO_EMP_ID_USER');
211: END IF;
212: CLOSE l_submitter_person_id_csr;
213:

Line 277: PA_UTILS.Add_Message('PA', 'PA_UNEXP_APPRVL_ACTION');

273: --------------------------------------------------------------------------------------------------------
274: l_action_code := p_action_code;
275: IF l_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,
276: PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action, PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action) THEN
277: PA_UTILS.Add_Message('PA', 'PA_UNEXP_APPRVL_ACTION');
278: END IF;
279:
280:
281: --IF submitting for approval, then check is approval is required.

Line 325: PA_UTILS.Add_Message('PA',l_error_message_code);

321: x_return_status => l_return_status,
322: x_error_message_code => l_error_message_code);
323:
324: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
325: PA_UTILS.Add_Message('PA',l_error_message_code);
326: END IF;
327: /* commented out for bug #2247058
328: --------------------------------------------------------------------------------------------------------
329: -- If Workflow is Enabled

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

378: p_asgmt_status_code => l_success_status_code
379: ,p_project_id => l_project_id
380: ,p_add_message => 'N') = 'N' ) THEN
381:
382: PA_UTILS.Add_Message( p_app_short_name => 'PA'
383: ,p_msg_name => 'PA_APPRVL_PROJ_STUS_NOT_ALLOW'
384: ,p_token1 => 'PROJ_STATUS'
385: ,p_value1 => l_project_status_name);
386: EXIT;

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

392: p_asgmt_status_code => l_failure_status_code
393: ,p_project_id => l_project_id
394: ,p_add_message => 'N') = 'N' ) THEN
395:
396: PA_UTILS.Add_Message( p_app_short_name => 'PA'
397: ,p_msg_name => 'PA_APPRVL_PROJ_STUS_NOT_ALLOW'
398: ,p_token1 => 'PROJ_STATUS'
399: ,p_value1 => l_project_status_name);
400: EXIT;

Line 478: PA_UTILS.Add_Message('PA', l_error_message_code);

474: x_error_message_code => l_error_message_code);
475: --dbms_output.put_line('inside wf type'||l_wf_type);
476:
477: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
478: PA_UTILS.Add_Message('PA', l_error_message_code);
479: END IF;
480:
481: END IF; -- (l_wf_item_type IS NULL AND l..
482:

Line 538: PA_UTILS.Add_Message('PA', l_error_message_code);

534: ,x_return_status => l_return_status
535: ,x_error_message_code => l_error_message_code );
536:
537: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
538: PA_UTILS.Add_Message('PA', l_error_message_code);
539: END IF;
540:
541: l_return_status := FND_API.G_MISS_CHAR;
542: l_error_message_code := FND_API.G_MISS_CHAR;

Line 549: PA_UTILS.Add_Message('PA', 'PA_ASG_APPROVAL_PENDING');

545: ----------------------------------------------------------
546: -- check Pending Approval
547: ----------------------------------------------------------
548: IF NVL(l_pending_approval_flag, 'N') = 'Y' THEN
549: PA_UTILS.Add_Message('PA', 'PA_ASG_APPROVAL_PENDING');
550: ELSE
551: -- set approval pending flag if this assignment has been submitted
552: IF l_action_code = g_submit_action THEN
553: PA_ASGMT_WFSTD.Maintain_wf_pending_flag

Line 587: PA_UTILS.Add_Message('PA', l_error_message_code);

583: , x_error_message_code => l_error_message_code);
584: --dbms_output.put_line('start_workflow return status:'||l_return_status );
585:
586: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
587: PA_UTILS.Add_Message('PA', l_error_message_code);
588: END IF;
589: END IF; -- FND_MSG_PUB.Count_Msg < 1
590:
591: END IF; -- IF (l_wf_type <> 'NOT_ENABLED') AND...

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

709: END IF;
710:
711: IF PA_ASGMT_WFSTD.is_approval_pending(p_assignment_id => p_assignment_id) = 'Y' THEN
712:
713: PA_UTILS.Add_Message( p_app_short_name => 'PA'
714: ,p_msg_name => 'PA_WF_APPROVAL_PENDING');
715: ELSIF PA_ASSIGNMENT_APPROVAL_PVT.is_new_assignment(p_assignment_id => p_assignment_id) = 'Y' THEN
716: PA_UTILS.Add_Message( p_app_short_name => 'PA'
717: ,p_msg_name => 'PA_NO_APPRV_ASGMT_TO_REVERT');

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

712:
713: PA_UTILS.Add_Message( p_app_short_name => 'PA'
714: ,p_msg_name => 'PA_WF_APPROVAL_PENDING');
715: ELSIF PA_ASSIGNMENT_APPROVAL_PVT.is_new_assignment(p_assignment_id => p_assignment_id) = 'Y' THEN
716: PA_UTILS.Add_Message( p_app_short_name => 'PA'
717: ,p_msg_name => 'PA_NO_APPRV_ASGMT_TO_REVERT');
718: ELSE
719: --
720: --Get last approved record from assignments history

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

1741: l_project_party_id, l_resource_id;
1742:
1743: IF check_record_version%NOTFOUND THEN
1744:
1745: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1746: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
1747: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1748:
1749: ELSE

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

1918: --dbms_output.put_line('after PA_CANDIDATE_UTILS.Reverse_Candidate_Status ');
1919:
1920:
1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1922: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1923: ,p_msg_name => l_error_message_code);
1924: END IF;
1925:
1926: --

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

1968: ,x_msg_count => x_msg_count
1969: ,x_msg_data => x_msg_data);
1970:
1971: ELSE
1972: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1973: ,p_msg_name => 'PA_FAILED_TO_CREATE_OPEN_ASGN');
1974: END IF;
1975:
1976: --dbms_output.put_line('new requirement'||x_return_status);

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

2317: ,x_error_message_code => l_error_message_code
2318: ,x_return_status => l_return_status);
2319:
2320: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2321: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2322: ,p_msg_name => l_error_message_code);
2323: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE; --bug#8240018
2324: END IF;
2325: l_return_status := NULL;

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

2351: ,x_msg_count => x_msg_count
2352: ,x_msg_data => x_msg_data );
2353:
2354: ELSE
2355: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2356: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
2357:
2358: END IF;
2359:

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

2641: ,x_return_status => l_return_status
2642: ,x_error_message_code => l_error_message_code );
2643:
2644: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2645: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2646: ,p_msg_name => l_error_message_code);
2647: END IF;
2648:
2649: l_error_message_code := FND_API.G_MISS_CHAR;

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

3027: OPEN l_projects_csr( p_project_id);
3028: FETCH l_projects_csr INTO l_projects_rec;
3029: IF l_projects_csr%NOTFOUND THEN
3030:
3031: pa_utils.add_message (p_app_short_name => 'PA',
3032: p_msg_name => 'PA_INVALID_PROJECT_ID');
3033:
3034: END IF;
3035: CLOSE l_projects_csr;

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

3052:
3053: -- Only non-admin projects require a manager
3054: IF l_projects_rec.admin_flag = 'N' THEN
3055: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3056: pa_utils.add_message (p_app_short_name => 'PA',
3057: p_msg_name => l_error_message_code);
3058: END IF;
3059: END IF;
3060:

Line 3071: pa_utils.add_message (p_app_short_name => 'PA'

3067: FETCH l_stus_csr INTO l_stus_rec;
3068: IF l_stus_csr%NOTFOUND THEN
3069: l_return_status := FND_API.G_RET_STS_ERROR;
3070: l_error_message_code := 'PA_INVALID_STATUS_CODE';
3071: pa_utils.add_message (p_app_short_name => 'PA'
3072: ,p_msg_name => 'PA_INVALID_STATUS_CODE');
3073: RAISE INVALID_STATUS;
3074: log_message('Error in Workflow enabled check');
3075: END IF;

Line 3079: pa_utils.add_message (p_app_short_name => 'PA'

3075: END IF;
3076: CLOSE l_stus_csr;
3077:
3078: IF NVL(l_stus_rec.enable_wf_flag,'N') = 'N' THEN
3079: pa_utils.add_message (p_app_short_name => 'PA'
3080: ,p_msg_name => 'PA_INVALID_STATUS_CODE');
3081: RAISE NO_WORKFLOW_EXCEPTION;
3082: END IF;
3083:

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

3152: IF l_approver1_id_tbl(i) is null AND l_approver2_id_tbl(i) is null THEN
3153:
3154: --Add error message to error stack
3155: l_error_message_code := 'PA_RESOURCE_NO_AUTH';
3156: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3157: ,p_msg_name => l_error_message_code);
3158:
3159: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3160: ELSE

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

3179: ELSIF l_approver1_id_tbl(i) is null AND l_approver2_id_tbl(i) is null THEN
3180:
3181: --Add error message to error stack
3182: l_error_message_code := 'PA_RESOURCE_NO_AUTH';
3183: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3184: ,p_msg_name => l_error_message_code);
3185: log_message('No approver');
3186: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3187:

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

3222: END IF;
3223:
3224: IF l_apr1_res_auth = 'N' OR l_apr2_res_auth = 'N' THEN
3225:
3226: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3227: ,p_msg_name => 'PA_RESOURCE_NO_AUTH');
3228: log_message('No resource authority 1');
3229: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3230:

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

4234: THEN
4235: log_message('No Approvers for Loop:' || i);
4236:
4237: l_error_message_code := 'PA_RESOURCE_NO_APPROVAL';
4238: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4239: ,p_msg_name => l_error_message_code);
4240:
4241: END IF;
4242: END IF;

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

4259: ,x_return_status => l_return_status
4260: ,x_error_message_code => l_error_message_code );
4261:
4262: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4263: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4264: ,p_msg_name => l_error_message_code);
4265: END IF;
4266:
4267: log_message('After calling check_resourcename_or_id for Approver1 Loop:' || i);

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

4290: ,x_return_status => l_return_status
4291: ,x_error_message_code => l_error_message_code);
4292:
4293: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4294: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4295: ,p_msg_name => l_error_message_code);
4296: END IF;
4297:
4298: log_message('After calling check_resourcename_or_id for Approver2 Loop:' || i);