eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_DEBUG

Line 4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

1: PACKAGE BODY pa_staffed_assignment_pvt AS
2: /*$Header: PARDPVTB.pls 120.8.12010000.3 2008/11/28 06:18:30 kjai ship $*/
3: --
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
5: li_message_level NUMBER := 1;
6:
7: PROCEDURE Create_Staffed_Assignment
8: ( p_assignment_rec IN PA_ASSIGNMENTS_PUB.Assignment_Rec_Type

Line 179: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment');

175: -- 4537865 : Initialize the return_status
176: x_return_status := FND_API.G_RET_STS_SUCCESS ;
177:
178: -- Initialize the Error Stack
179: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment');
180: --dbms_output.put_line('create staffed assignment');
181:
182: --Log Message
183: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 184: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.begin'

180: --dbms_output.put_line('create staffed assignment');
181:
182: --Log Message
183: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
184: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.begin'
185: ,x_msg => 'Beginning of Create_Staff_Assignment'
186: ,x_log_level => 5);
187: END IF;
188: --

Line 315: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.location'

311: WHERE project_id = l_assignment_rec.project_id;
312: */
313: --Log Message
314: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
315: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.location'
316: ,x_msg => 'No need to get location from project'
317: ,x_log_level => 5);
318: END IF;
319:

Line 370: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.res_source_id'

366: (l_resource_source_id IS NULL OR l_resource_source_id =FND_API.G_MISS_NUM) THEN
367:
368: --Log Message
369: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
370: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.res_source_id'
371: ,x_msg => 'Getting Resource Source Id'
372: ,x_log_level => 5);
373: END IF;
374: OPEN get_resource_source_id;

Line 390: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.project_party'

386: --dbms_output.put_line('*****resource_id:'||l_assignment_rec.resource_id);
387:
388: --Log Message
389: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
390: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.project_party'
391: ,x_msg => 'Creating Project Party'
392: ,x_log_level => 5);
393: END IF;
394:

Line 420: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

416: ,x_msg_count => l_msg_count
417: ,x_msg_data => l_msg_data
418: );
419: IF P_DEBUG_MODE = 'Y' THEN
420: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
421: ,x_msg => 'create project party,status='||x_return_status
422: ,x_log_level => li_message_level);
423: END IF;
424:

Line 454: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

450: ,p_start_date => l_assignment_rec.start_date
451: ,x_return_status => l_check_resource
452: );
453: IF P_DEBUG_MODE = 'Y' THEN
454: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
455: ,x_msg => 'validate person, status='||l_check_resource
456: ,x_log_level => li_message_level);
457: END IF;
458:

Line 478: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENTS_PVT.Create_Assignment.utilization_defaults'

474:
475: --dbms_output.put_line('calling assignment default');
476: --Log Message
477: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
478: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENTS_PVT.Create_Assignment.utilization_defaults'
479: ,x_msg => 'Getting Utilization Defaults.'
480: ,x_log_level => 5);
481: END IF;
482:

Line 526: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

522: l_assignment_rec.fcst_tp_amount_type := l_fcst_tp_amount_type_tmp;
523: -- Bug 5130421 : End
524:
525: IF P_DEBUG_MODE = 'Y' THEN
526: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
527: ,x_msg => 'work_type_id='||l_work_type_id||
528: ' tp_amount_type='||l_assignment_rec.fcst_tp_amount_type||
529: ' job_group_id='||l_assignment_rec.fcst_job_group_id
530: ,x_log_level => li_message_level);

Line 532: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

528: ' tp_amount_type='||l_assignment_rec.fcst_tp_amount_type||
529: ' job_group_id='||l_assignment_rec.fcst_job_group_id
530: ,x_log_level => li_message_level);
531:
532: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
533: ,x_msg => 'job_id='||l_assignment_rec.fcst_job_id||
534: ' org_id='||l_assignment_rec.expenditure_org_id||
535: ' carry_out_org_id='||l_assignment_rec.expenditure_organization_id
536: ,x_log_level => li_message_level);

Line 538: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

534: ' org_id='||l_assignment_rec.expenditure_org_id||
535: ' carry_out_org_id='||l_assignment_rec.expenditure_organization_id
536: ,x_log_level => li_message_level);
537:
538: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
539: ,x_msg => 'exp_type='||l_assignment_rec.expenditure_type||
540: ' exp_type_cls='||l_assignment_rec.expenditure_type_class||
541: ' return_status='||l_return_status
542: ,x_log_level => li_message_level);

Line 561: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_PVT.Create_Assignment.bill_rate'

557: l_resource_source_id IS NOT NULL THEN
558:
559: --Log Message
560: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
561: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_PVT.Create_Assignment.bill_rate'
562: ,x_msg => 'Getting Revenue Bill Rate'
563: ,x_log_level => 5);
564: END IF;
565: --dbms_output.put_line('before get rev amt');

Line 588: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

584: --dbms_output.put_line('after get rev amt');
585:
586: END IF;
587: IF P_DEBUG_MODE = 'Y' THEN
588: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
589: ,x_msg => 'get_rev_amt done'
590: ,x_log_level => li_message_level);
591: END IF;
592:

Line 606: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

602: FROM PA_PROJECTS_ALL
603: WHERE project_id = p_assignment_rec.project_id;
604:
605: IF P_DEBUG_MODE = 'Y' THEN
606: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
607: ,x_msg => 'resource_id='||l_assignment_rec.resource_id
608: ,x_log_level => li_message_level);
609: END IF;
610:

Line 706: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

702: END IF ; --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
703: /* End of Changes for Bug 6056112 */
704:
705: IF P_DEBUG_MODE = 'Y' THEN
706: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
707: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
708: ' res_format='||l_proj_asgmt_res_format_id||
709: ' person_id='||l_person_id_tmp||
710: ' job_id='||l_fcst_job_id_tmp

Line 712: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

708: ' res_format='||l_proj_asgmt_res_format_id||
709: ' person_id='||l_person_id_tmp||
710: ' job_id='||l_fcst_job_id_tmp
711: ,x_log_level => li_message_level);
712: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
713: ,x_msg => 'org_id='||l_resource_organization_id||
714: ' exp_type='||l_expenditure_type_tmp||
715: ' role_id='||l_project_role_id_tmp||
716: ' named_role='||l_assignment_name_tmp

Line 726: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

722: OPEN check_future_dated_employee;
723: FETCH check_future_dated_employee INTO l_future_dated_emp;
724:
725: IF P_DEBUG_MODE = 'Y' THEN
726: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
727: ,x_msg => 'future_dated_employee ='||l_future_dated_emp
728: ,x_log_level => li_message_level);
729: END IF;
730:

Line 749: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

745: END IF;
746: CLOSE check_future_dated_employee;
747:
748: IF P_DEBUG_MODE = 'Y' THEN
749: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
750: ,x_msg => 'resource_list_member_id='||l_assignment_rec.resource_list_member_id
751: ,x_log_level => li_message_level);
752: END IF;
753:

Line 758: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.function_security'

754: END IF;
755:
756: --Log Message
757: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
758: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.function_security'
759: ,x_msg => 'Check if user can confirm an assignment.'
760: ,x_log_level => 5);
761: END IF;
762: --function security call:

Line 851: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.cc_resource'

847: --dbms_output.put_line('cc end date: '||l_assignment_rec.end_date);
848:
849: --Log Message
850: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
851: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.cc_resource'
852: ,x_msg => 'Check if resource can be cross-charged.'
853: ,x_log_level => 5);
854: END IF;
855: PA_RESOURCE_UTILS.check_cc_for_resource(p_resource_id => l_assignment_rec.resource_id,

Line 910: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.insert_row'

906:
907:
908: --Log Message
909: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
910: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.insert_row'
911: ,x_msg => 'Insert new assignment into Table.'
912: ,x_log_level => 5);
913: END IF;
914:

Line 997: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

993: ,x_assignment_number => l_assignment_rec.assignment_number
994: ,x_return_status => x_return_status
995: );
996: IF P_DEBUG_MODE = 'Y' THEN
997: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
998: ,x_msg => 'after insert_row, status='||x_return_status
999: ,x_log_level => li_message_level);
1000: END IF;
1001:

Line 1056: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1052: --pa_schedule_utils.l_print_log := TRUE;
1053:
1054: --FP.M Development
1055: IF P_DEBUG_MODE = 'Y' THEN
1056: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1057: ,x_msg => 'FP.M Development'
1058: ,x_log_level => li_message_level);
1059:
1060: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

Line 1060: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1056: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1057: ,x_msg => 'FP.M Development'
1058: ,x_log_level => li_message_level);
1059:
1060: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1061: ,x_msg => 'resource_list_member_id'||l_assignment_rec.resource_list_member_id
1062: ,x_log_level => li_message_level);
1063:
1064: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

Line 1064: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1060: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1061: ,x_msg => 'resource_list_member_id'||l_assignment_rec.resource_list_member_id
1062: ,x_log_level => li_message_level);
1063:
1064: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1065: ,x_msg => 'budget_version_id'||p_budget_version_id
1066: ,x_log_level => li_message_level);
1067: END IF;
1068:

Line 1118: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1114: ,p_project_role_id => p_assignment_rec.project_role_id
1115: ,x_return_status => l_return_status
1116: );
1117: IF P_DEBUG_MODE = 'Y' THEN
1118: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1119: ,x_msg => 'Update_Task_Assignments status '||l_return_status
1120: ,x_log_level => li_message_level);
1121:
1122: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

Line 1122: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1118: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1119: ,x_msg => 'Update_Task_Assignments status '||l_return_status
1120: ,x_log_level => li_message_level);
1121:
1122: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1123: ,x_msg => 'project_id='||l_assignment_rec.project_id||
1124: ' sch_flag='||l_schedule_basis_flag||
1125: ' party_id='||l_assignment_rec.project_party_id
1126: ,x_log_level => li_message_level);

Line 1128: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1124: ' sch_flag='||l_schedule_basis_flag||
1125: ' party_id='||l_assignment_rec.project_party_id
1126: ,x_log_level => li_message_level);
1127:
1128: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1129: ,x_msg => 'cal_id='||l_assignment_rec.calendar_id||
1130: ' asgmt_id='||l_assignment_rec.assignment_id||
1131: ' src_asgmt_id='||l_assignment_rec.source_assignment_id
1132: ,x_log_level => li_message_level);

Line 1134: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1130: ' asgmt_id='||l_assignment_rec.assignment_id||
1131: ' src_asgmt_id='||l_assignment_rec.source_assignment_id
1132: ,x_log_level => li_message_level);
1133:
1134: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1135: ,x_msg => 's_date='||l_assignment_rec.start_date||
1136: ' cal_perct='||l_assignment_rec.resource_calendar_percent||
1137: ' e_date='||l_assignment_rec.end_date||
1138: ' status='||l_assignment_rec.status_code

Line 1145: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1141:
1142: IF l_task_assignment_id_tbl.COUNT <> 0 THEN
1143: FOR j IN l_task_assignment_id_tbl.FIRST .. l_task_assignment_id_tbl.LAST LOOP
1144: IF P_DEBUG_MODE = 'Y' THEN
1145: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1146: ,x_msg => 'tait('||j||')='||l_task_assignment_id_tbl(j)
1147: ,x_log_level => li_message_level);
1148: END IF;
1149: END LOOP;

Line 1153: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

1149: END LOOP;
1150: END IF;
1151:
1152: IF P_DEBUG_MODE = 'Y' THEN
1153: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1154: ,x_msg => 'task_flag='||p_sum_tasks_flag||
1155: ' work_type='||l_assignment_rec.work_type_id
1156: ,x_log_level => li_message_level);
1157: END IF;

Line 1198: PA_DEBUG.Reset_err_stack;

1194:
1195: END IF; -- IF (p_validate_only <> FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg = 0)
1196:
1197: -- Reset the error stack when returning to the calling program
1198: PA_DEBUG.Reset_err_stack;
1199:
1200:
1201: EXCEPTION
1202: WHEN OTHERS THEN

Line 1213: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

1209: -- 4537865 : End
1210:
1211: -- Set the excetption Message and the stack
1212: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1213: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1214: --
1215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1216: RAISE; -- This is optional depending on the needs
1217:

Line 1430: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment');

1426: -- 4537865 : Initialize the return_status
1427: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1428:
1429: -- Initialize the Error Stack
1430: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment');
1431:
1432: --Log Message
1433: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1434: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

Line 1434: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

1430: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment');
1431:
1432: --Log Message
1433: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1434: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1435: ,x_msg => 'Beginning of Update_Staff_Assignment'
1436: ,x_log_level => 5);
1437: END IF;
1438: --

Line 1461: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1457: l_assignment_rec.resource_id := l_cur_resource_id;
1458: END IF;
1459:
1460: IF P_DEBUG_MODE = 'Y' THEN
1461: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1462: ,x_msg => 'l_asgmt_rec.resource_id='||l_assignment_rec.resource_id
1463: ,x_log_level => li_message_level);
1464: END IF;
1465:

Line 1472: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

1468: END IF;
1469:
1470: --Log Message
1471: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1472: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1473: ,x_msg => 'Old resource list member id='||l_cur_resource_list_member_id
1474: ,x_log_level => 5);
1475: END IF;
1476:

Line 1498: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1494: from pa_resource_txn_attributes
1495: WHERE resource_id = l_assignment_rec.resource_id;
1496: END IF;
1497: IF P_DEBUG_MODE = 'Y' THEN
1498: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1499: ,x_msg => 'l_person_id='||l_person_id
1500: ,x_log_level => li_message_level);
1501: END IF;
1502:

Line 1523: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

1519: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1520: p_assignment_rec.assignment_name <> l_cur_assignment_name) THEN
1521: --Log Message
1522: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1523: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1524: ,x_msg => 'Mandatory attributes changed'
1525: ,x_log_level => 5);
1526: END IF;
1527: /*

Line 1585: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1581: OPEN get_resource_organization;
1582: FETCH get_resource_organization INTO l_resource_organization_id;
1583: CLOSE get_resource_organization;
1584: IF P_DEBUG_MODE = 'Y' THEN
1585: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1586: ,x_msg => 'l_resource_organization_id='||l_resource_organization_id
1587: ,x_log_level => li_message_level);
1588: END IF;
1589:

Line 1610: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1606: AND l_assignment_rec.start_date BETWEEN prd.resource_effective_start_date
1607: AND prd.resource_effective_end_date ;
1608:
1609: IF P_DEBUG_MODE = 'Y' THEN
1610: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1611: ,x_msg => 'l_fcst_job_id_tmp='||l_fcst_job_id_tmp
1612: ,x_log_level => li_message_level);
1613: END IF;
1614:

Line 1635: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1631: AND assn.assignment_type in ('C','E')
1632: AND assn.primary_flag = 'Y'
1633: AND ROWNUM = 1;
1634: IF P_DEBUG_MODE = 'Y' THEN
1635: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1636: ,x_msg => 'l_fcst_job_id_tmp='||l_fcst_job_id_tmp
1637: ,x_log_level => li_message_level);
1638: END IF;
1639:

Line 1653: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1649: END IF ; --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
1650: /* End of Changes for Bug 6056112 */
1651:
1652: IF P_DEBUG_MODE = 'Y' THEN
1653: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1654: ,x_msg => 'l_person_type_code='||l_person_type_code
1655: ,x_log_level => li_message_level);
1656:
1657: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

Line 1657: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1653: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1654: ,x_msg => 'l_person_type_code='||l_person_type_code
1655: ,x_log_level => li_message_level);
1656:
1657: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1658: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
1659: ' res_format='||l_cur_res_format_id||
1660: ' person_id='||l_person_id_tmp||
1661: ' job_id='||l_fcst_job_id_tmp

Line 1663: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1659: ' res_format='||l_cur_res_format_id||
1660: ' person_id='||l_person_id_tmp||
1661: ' job_id='||l_fcst_job_id_tmp
1662: ,x_log_level => li_message_level);
1663: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1664: ,x_msg => 'org_id='||l_resource_organization_id||
1665: ' exp_type='||l_expenditure_type_tmp||
1666: ' role_id='||l_project_role_id_tmp||
1667: ' named_role='||l_assignment_name_tmp

Line 1684: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

1680: ,p_person_type_code => l_person_type_code
1681: ,p_named_role => l_assignment_name_tmp);
1682: --Log Message
1683: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1684: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1685: ,x_msg => 'new resource list member id='||l_assignment_rec.resource_list_member_id
1686: ,x_log_level => 5);
1687: END IF;
1688:

Line 1753: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1749: ,x_return_status => l_return_status
1750: );
1751: --Log Message
1752: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1753: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1754: ,x_msg => 'Update_task_assignments, status='||l_return_status
1755: ,x_log_level => 5);
1756: END IF;
1757:

Line 1788: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

1784: ,x_return_status => l_return_status
1785: );
1786: --Log Message
1787: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1788: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1789: ,x_msg => 'Update_task_assignments, status='||l_return_status
1790: ,x_log_level => 5);
1791: END IF;
1792:

Line 1832: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

1828:
1829:
1830: --Log Message
1831: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1832: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1833: ,x_msg => 'Update_task_assignments, status='||l_return_status
1834: ,x_log_level => 5);
1835: END IF;
1836:

Line 1845: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

1841: p_assignment_rec.assignment_name <> l_cur_assignment_name THEN
1842:
1843: --Log Message
1844: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1845: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1846: ,x_msg => 'Mandatory attributes not changed'
1847: ,x_log_level => 5);
1848: END IF;
1849:

Line 1870: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

1866: ,x_return_status => l_return_status
1867: );
1868: --Log Message
1869: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1870: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1871: ,x_msg => 'Update_task_assignments, status='||l_return_status
1872: ,x_log_level => 5);
1873: END IF;
1874:

Line 1981: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.insert_history'

1977: IF l_assignment_rec.apprvl_status_code= PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
1978:
1979: --Log Message
1980: IF P_DEBUG_MODE = 'Y' THEN
1981: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.insert_history'
1982: ,x_msg => 'Inserting into Assignment History.'
1983: ,x_log_level => 5);
1984: END IF;
1985:

Line 1998: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.get_next_stus'

1994:
1995:
1996: --Log Message
1997: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1998: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.get_next_stus'
1999: ,x_msg => 'Getting next assignment approval status.'
2000: ,x_log_level => 5);
2001:
2002: END IF;

Line 2027: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.update_row'

2023: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN
2024:
2025: --Log Message
2026: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2027: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.update_row'
2028: ,x_msg => 'Update Assignment Record.'
2029: ,x_log_level => 5);
2030: END IF;
2031:

Line 2105: PA_DEBUG.Reset_err_stack;

2101: END IF;
2102:
2103:
2104: -- Reset the error stack when returning to the calling program
2105: PA_DEBUG.Reset_err_stack;
2106:
2107:
2108: EXCEPTION
2109: WHEN OTHERS THEN

Line 2113: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

2109: WHEN OTHERS THEN
2110:
2111: -- Set the excetption Message and the stack
2112: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
2113: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2114: --
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2116: RAISE; -- This is optional depending on the needs
2117:

Line 2154: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment');

2150:
2151: -- 4537865 : Initialize the return_status
2152: x_return_status := FND_API.G_RET_STS_SUCCESS;
2153: -- Initialize the Error Stack
2154: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment');
2155:
2156: --Log Message
2157: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2158: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.begin'

Line 2158: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.begin'

2154: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment');
2155:
2156: --Log Message
2157: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2158: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.begin'
2159: ,x_msg => 'Beginning of Delete_Staff_Assignment'
2160: ,x_log_level => 5);
2161: END IF;
2162: -- Assignment cannot be deleted if project transactions are associated with it

Line 2191: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.del_schedules'

2187: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN
2188:
2189: --Log Message
2190: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2191: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.del_schedules'
2192: ,x_msg => 'Deleting Assignment Schedules'
2193: ,x_log_level => 5);
2194: END IF;
2195:

Line 2210: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.del_asgmt'

2206: );
2207:
2208: --Log Message
2209: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2210: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.del_asgmt'
2211: ,x_msg => 'Deleting Assignment record.'
2212: ,x_log_level => 5);
2213: END IF;
2214:

Line 2228: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.proj_party.'

2224: IF x_return_status = 'S'AND p_project_party_id IS NOT NULL THEN
2225:
2226: --Log Message
2227: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2228: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.proj_party.'
2229: ,x_msg => 'Deleting Project Party'
2230: ,x_log_level => 5);
2231: END IF;
2232:

Line 2247: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.del_history'

2243:
2244:
2245: --Log Message
2246: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2247: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.del_history'
2248: ,x_msg => 'Deleting Assignment History.'
2249: ,x_log_level => 5);
2250: END IF;
2251:

Line 2265: PA_DEBUG.Reset_err_stack;

2261: END IF;
2262:
2263:
2264: -- Reset the error stack when returning to the calling program
2265: PA_DEBUG.Reset_err_stack;
2266:
2267: END IF;
2268:
2269: EXCEPTION

Line 2274: ,p_procedure_name => PA_DEBUG.G_Err_Stack );

2270: WHEN OTHERS THEN
2271:
2272: -- Set the excetption Message and the stack
2273: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment'
2274: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2275: --
2276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2277: RAISE; -- This is optional depending on the needs
2278: