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 2265: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2261: ,x_error_message_code => l_error_message_code
2262: ,x_return_status => l_return_status);
2263:
2264: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2265: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2266: ,p_msg_name => l_error_message_code);
2267: END IF;
2268: l_return_status := NULL;
2269: END IF;

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

2290: ,x_msg_count => x_msg_count
2291: ,x_msg_data => x_msg_data );
2292:
2293: ELSE
2294: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2295: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
2296:
2297: END IF;
2298:

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

2580: ,x_return_status => l_return_status
2581: ,x_error_message_code => l_error_message_code );
2582:
2583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2584: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2585: ,p_msg_name => l_error_message_code);
2586: END IF;
2587:
2588: l_error_message_code := FND_API.G_MISS_CHAR;

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

2966: OPEN l_projects_csr( p_project_id);
2967: FETCH l_projects_csr INTO l_projects_rec;
2968: IF l_projects_csr%NOTFOUND THEN
2969:
2970: pa_utils.add_message (p_app_short_name => 'PA',
2971: p_msg_name => 'PA_INVALID_PROJECT_ID');
2972:
2973: END IF;
2974: CLOSE l_projects_csr;

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

2991:
2992: -- Only non-admin projects require a manager
2993: IF l_projects_rec.admin_flag = 'N' THEN
2994: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2995: pa_utils.add_message (p_app_short_name => 'PA',
2996: p_msg_name => l_error_message_code);
2997: END IF;
2998: END IF;
2999:

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

3006: FETCH l_stus_csr INTO l_stus_rec;
3007: IF l_stus_csr%NOTFOUND THEN
3008: l_return_status := FND_API.G_RET_STS_ERROR;
3009: l_error_message_code := 'PA_INVALID_STATUS_CODE';
3010: pa_utils.add_message (p_app_short_name => 'PA'
3011: ,p_msg_name => 'PA_INVALID_STATUS_CODE');
3012: RAISE INVALID_STATUS;
3013: log_message('Error in Workflow enabled check');
3014: END IF;

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

3014: END IF;
3015: CLOSE l_stus_csr;
3016:
3017: IF NVL(l_stus_rec.enable_wf_flag,'N') = 'N' THEN
3018: pa_utils.add_message (p_app_short_name => 'PA'
3019: ,p_msg_name => 'PA_INVALID_STATUS_CODE');
3020: RAISE NO_WORKFLOW_EXCEPTION;
3021: END IF;
3022:

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

3091: IF l_approver1_id_tbl(i) is null AND l_approver2_id_tbl(i) is null THEN
3092:
3093: --Add error message to error stack
3094: l_error_message_code := 'PA_RESOURCE_NO_AUTH';
3095: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3096: ,p_msg_name => l_error_message_code);
3097:
3098: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3099: ELSE

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

3118: ELSIF l_approver1_id_tbl(i) is null AND l_approver2_id_tbl(i) is null THEN
3119:
3120: --Add error message to error stack
3121: l_error_message_code := 'PA_RESOURCE_NO_AUTH';
3122: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3123: ,p_msg_name => l_error_message_code);
3124: log_message('No approver');
3125: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3126:

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

3161: END IF;
3162:
3163: IF l_apr1_res_auth = 'N' OR l_apr2_res_auth = 'N' THEN
3164:
3165: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3166: ,p_msg_name => 'PA_RESOURCE_NO_AUTH');
3167: log_message('No resource authority 1');
3168: RAISE PROCESS_ASSIGNMENT_EXCEPTION;
3169:

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

4169: THEN
4170: log_message('No Approvers for Loop:' || i);
4171:
4172: l_error_message_code := 'PA_RESOURCE_NO_APPROVAL';
4173: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4174: ,p_msg_name => l_error_message_code);
4175:
4176: END IF;
4177: END IF;

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

4194: ,x_return_status => l_return_status
4195: ,x_error_message_code => l_error_message_code );
4196:
4197: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4198: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4199: ,p_msg_name => l_error_message_code);
4200: END IF;
4201:
4202: log_message('After calling check_resourcename_or_id for Approver1 Loop:' || i);

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

4225: ,x_return_status => l_return_status
4226: ,x_error_message_code => l_error_message_code);
4227:
4228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4229: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4230: ,p_msg_name => l_error_message_code);
4231: END IF;
4232:
4233: log_message('After calling check_resourcename_or_id for Approver2 Loop:' || i);