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.9 2010/05/02 21:57:49 nisinha 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 316: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.location'

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

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

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

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

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

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

447: );
448: /* End of code chnage for Bug 6631033 */
449:
450: IF P_DEBUG_MODE = 'Y' THEN
451: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
452: ,x_msg => 'create project party,status='||x_return_status
453: ,x_log_level => li_message_level);
454: END IF;
455:

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

481: ,p_start_date => l_assignment_rec.start_date
482: ,x_return_status => l_check_resource
483: );
484: IF P_DEBUG_MODE = 'Y' THEN
485: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
486: ,x_msg => 'validate person, status='||l_check_resource
487: ,x_log_level => li_message_level);
488: END IF;
489:

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

505:
506: --dbms_output.put_line('calling assignment default');
507: --Log Message
508: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
509: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENTS_PVT.Create_Assignment.utilization_defaults'
510: ,x_msg => 'Getting Utilization Defaults.'
511: ,x_log_level => 5);
512: END IF;
513:

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

553: l_assignment_rec.fcst_tp_amount_type := l_fcst_tp_amount_type_tmp;
554: -- Bug 5130421 : End
555:
556: IF P_DEBUG_MODE = 'Y' THEN
557: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
558: ,x_msg => 'work_type_id='||l_work_type_id||
559: ' tp_amount_type='||l_assignment_rec.fcst_tp_amount_type||
560: ' job_group_id='||l_assignment_rec.fcst_job_group_id
561: ,x_log_level => li_message_level);

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

559: ' tp_amount_type='||l_assignment_rec.fcst_tp_amount_type||
560: ' job_group_id='||l_assignment_rec.fcst_job_group_id
561: ,x_log_level => li_message_level);
562:
563: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
564: ,x_msg => 'job_id='||l_assignment_rec.fcst_job_id||
565: ' org_id='||l_assignment_rec.expenditure_org_id||
566: ' carry_out_org_id='||l_assignment_rec.expenditure_organization_id
567: ,x_log_level => li_message_level);

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

565: ' org_id='||l_assignment_rec.expenditure_org_id||
566: ' carry_out_org_id='||l_assignment_rec.expenditure_organization_id
567: ,x_log_level => li_message_level);
568:
569: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
570: ,x_msg => 'exp_type='||l_assignment_rec.expenditure_type||
571: ' exp_type_cls='||l_assignment_rec.expenditure_type_class||
572: ' return_status='||l_return_status
573: ,x_log_level => li_message_level);

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

588: l_resource_source_id IS NOT NULL THEN
589:
590: --Log Message
591: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
592: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_PVT.Create_Assignment.bill_rate'
593: ,x_msg => 'Getting Revenue Bill Rate'
594: ,x_log_level => 5);
595: END IF;
596: --dbms_output.put_line('before get rev amt');

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

615: --dbms_output.put_line('after get rev amt');
616:
617: END IF;
618: IF P_DEBUG_MODE = 'Y' THEN
619: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
620: ,x_msg => 'get_rev_amt done'
621: ,x_log_level => li_message_level);
622: END IF;
623:

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

633: FROM PA_PROJECTS_ALL
634: WHERE project_id = p_assignment_rec.project_id;
635:
636: IF P_DEBUG_MODE = 'Y' THEN
637: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
638: ,x_msg => 'resource_id='||l_assignment_rec.resource_id
639: ,x_log_level => li_message_level);
640: END IF;
641:

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

733: END IF ; --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
734: /* End of Changes for Bug 6056112 */
735:
736: IF P_DEBUG_MODE = 'Y' THEN
737: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
738: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
739: ' res_format='||l_proj_asgmt_res_format_id||
740: ' person_id='||l_person_id_tmp||
741: ' job_id='||l_fcst_job_id_tmp

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

739: ' res_format='||l_proj_asgmt_res_format_id||
740: ' person_id='||l_person_id_tmp||
741: ' job_id='||l_fcst_job_id_tmp
742: ,x_log_level => li_message_level);
743: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
744: ,x_msg => 'org_id='||l_resource_organization_id||
745: ' exp_type='||l_expenditure_type_tmp||
746: ' role_id='||l_project_role_id_tmp||
747: ' named_role='||l_assignment_name_tmp

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

753: OPEN check_future_dated_employee;
754: FETCH check_future_dated_employee INTO l_future_dated_emp;
755:
756: IF P_DEBUG_MODE = 'Y' THEN
757: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
758: ,x_msg => 'future_dated_employee ='||l_future_dated_emp
759: ,x_log_level => li_message_level);
760: END IF;
761:

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

776: END IF;
777: CLOSE check_future_dated_employee;
778:
779: IF P_DEBUG_MODE = 'Y' THEN
780: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
781: ,x_msg => 'resource_list_member_id='||l_assignment_rec.resource_list_member_id
782: ,x_log_level => li_message_level);
783: END IF;
784:

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

785: END IF;
786:
787: --Log Message
788: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
789: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.function_security'
790: ,x_msg => 'Check if user can confirm an assignment.'
791: ,x_log_level => 5);
792: END IF;
793: --function security call:

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

878: --dbms_output.put_line('cc end date: '||l_assignment_rec.end_date);
879:
880: --Log Message
881: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
882: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.cc_resource'
883: ,x_msg => 'Check if resource can be cross-charged.'
884: ,x_log_level => 5);
885: END IF;
886: PA_RESOURCE_UTILS.check_cc_for_resource(p_resource_id => l_assignment_rec.resource_id,

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

937:
938:
939: --Log Message
940: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
941: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment.insert_row'
942: ,x_msg => 'Insert new assignment into Table.'
943: ,x_log_level => 5);
944: END IF;
945:

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

1024: ,x_assignment_number => l_assignment_rec.assignment_number
1025: ,x_return_status => x_return_status
1026: );
1027: IF P_DEBUG_MODE = 'Y' THEN
1028: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1029: ,x_msg => 'after insert_row, status='||x_return_status
1030: ,x_log_level => li_message_level);
1031: END IF;
1032:

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

1083: --pa_schedule_utils.l_print_log := TRUE;
1084:
1085: --FP.M Development
1086: IF P_DEBUG_MODE = 'Y' THEN
1087: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1088: ,x_msg => 'FP.M Development'
1089: ,x_log_level => li_message_level);
1090:
1091: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

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

1087: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1088: ,x_msg => 'FP.M Development'
1089: ,x_log_level => li_message_level);
1090:
1091: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1092: ,x_msg => 'resource_list_member_id'||l_assignment_rec.resource_list_member_id
1093: ,x_log_level => li_message_level);
1094:
1095: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

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

1091: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1092: ,x_msg => 'resource_list_member_id'||l_assignment_rec.resource_list_member_id
1093: ,x_log_level => li_message_level);
1094:
1095: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1096: ,x_msg => 'budget_version_id'||p_budget_version_id
1097: ,x_log_level => li_message_level);
1098: END IF;
1099:

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

1145: ,p_project_role_id => p_assignment_rec.project_role_id
1146: ,x_return_status => l_return_status
1147: );
1148: IF P_DEBUG_MODE = 'Y' THEN
1149: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1150: ,x_msg => 'Update_Task_Assignments status '||l_return_status
1151: ,x_log_level => li_message_level);
1152:
1153: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

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

1149: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1150: ,x_msg => 'Update_Task_Assignments status '||l_return_status
1151: ,x_log_level => li_message_level);
1152:
1153: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1154: ,x_msg => 'project_id='||l_assignment_rec.project_id||
1155: ' sch_flag='||l_schedule_basis_flag||
1156: ' party_id='||l_assignment_rec.project_party_id
1157: ,x_log_level => li_message_level);

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

1155: ' sch_flag='||l_schedule_basis_flag||
1156: ' party_id='||l_assignment_rec.project_party_id
1157: ,x_log_level => li_message_level);
1158:
1159: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1160: ,x_msg => 'cal_id='||l_assignment_rec.calendar_id||
1161: ' asgmt_id='||l_assignment_rec.assignment_id||
1162: ' src_asgmt_id='||l_assignment_rec.source_assignment_id
1163: ,x_log_level => li_message_level);

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

1161: ' asgmt_id='||l_assignment_rec.assignment_id||
1162: ' src_asgmt_id='||l_assignment_rec.source_assignment_id
1163: ,x_log_level => li_message_level);
1164:
1165: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1166: ,x_msg => 's_date='||l_assignment_rec.start_date||
1167: ' cal_perct='||l_assignment_rec.resource_calendar_percent||
1168: ' e_date='||l_assignment_rec.end_date||
1169: ' status='||l_assignment_rec.status_code

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

1172:
1173: IF l_task_assignment_id_tbl.COUNT <> 0 THEN
1174: FOR j IN l_task_assignment_id_tbl.FIRST .. l_task_assignment_id_tbl.LAST LOOP
1175: IF P_DEBUG_MODE = 'Y' THEN
1176: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1177: ,x_msg => 'tait('||j||')='||l_task_assignment_id_tbl(j)
1178: ,x_log_level => li_message_level);
1179: END IF;
1180: END LOOP;

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

1180: END LOOP;
1181: END IF;
1182:
1183: IF P_DEBUG_MODE = 'Y' THEN
1184: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1185: ,x_msg => 'task_flag='||p_sum_tasks_flag||
1186: ' work_type='||l_assignment_rec.work_type_id
1187: ,x_log_level => li_message_level);
1188: END IF;

Line 1229: PA_DEBUG.Reset_err_stack;

1225:
1226: END IF; -- IF (p_validate_only <> FND_API.G_TRUE AND FND_MSG_PUB.Count_Msg = 0)
1227:
1228: -- Reset the error stack when returning to the calling program
1229: PA_DEBUG.Reset_err_stack;
1230:
1231:
1232: EXCEPTION
1233: WHEN OTHERS THEN

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

1240: -- 4537865 : End
1241:
1242: -- Set the excetption Message and the stack
1243: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'
1244: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1245: --
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1247: RAISE; -- This is optional depending on the needs
1248:

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

1457: -- 4537865 : Initialize the return_status
1458: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1459:
1460: -- Initialize the Error Stack
1461: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment');
1462:
1463: --Log Message
1464: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1465: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'

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

1461: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment');
1462:
1463: --Log Message
1464: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1465: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1466: ,x_msg => 'Beginning of Update_Staff_Assignment'
1467: ,x_log_level => 5);
1468: END IF;
1469: --

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

1488: l_assignment_rec.resource_id := l_cur_resource_id;
1489: END IF;
1490:
1491: IF P_DEBUG_MODE = 'Y' THEN
1492: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1493: ,x_msg => 'l_asgmt_rec.resource_id='||l_assignment_rec.resource_id
1494: ,x_log_level => li_message_level);
1495: END IF;
1496:

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

1499: END IF;
1500:
1501: --Log Message
1502: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1503: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1504: ,x_msg => 'Old resource list member id='||l_cur_resource_list_member_id
1505: ,x_log_level => 5);
1506: END IF;
1507:

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

1525: from pa_resource_txn_attributes
1526: WHERE resource_id = l_assignment_rec.resource_id;
1527: END IF;
1528: IF P_DEBUG_MODE = 'Y' THEN
1529: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1530: ,x_msg => 'l_person_id='||l_person_id
1531: ,x_log_level => li_message_level);
1532: END IF;
1533:

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

1550: p_assignment_rec.assignment_name <> FND_API.G_MISS_CHAR AND
1551: p_assignment_rec.assignment_name <> l_cur_assignment_name) THEN
1552: --Log Message
1553: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1554: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1555: ,x_msg => 'Mandatory attributes changed'
1556: ,x_log_level => 5);
1557: END IF;
1558: /*

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

1612: OPEN get_resource_organization;
1613: FETCH get_resource_organization INTO l_resource_organization_id;
1614: CLOSE get_resource_organization;
1615: IF P_DEBUG_MODE = 'Y' THEN
1616: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1617: ,x_msg => 'l_resource_organization_id='||l_resource_organization_id
1618: ,x_log_level => li_message_level);
1619: END IF;
1620:

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

1637: AND l_assignment_rec.start_date BETWEEN prd.resource_effective_start_date
1638: AND prd.resource_effective_end_date ;
1639:
1640: IF P_DEBUG_MODE = 'Y' THEN
1641: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1642: ,x_msg => 'l_fcst_job_id_tmp='||l_fcst_job_id_tmp
1643: ,x_log_level => li_message_level);
1644: END IF;
1645:

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

1662: AND assn.assignment_type in ('C','E')
1663: AND assn.primary_flag = 'Y'
1664: AND ROWNUM = 1;
1665: IF P_DEBUG_MODE = 'Y' THEN
1666: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1667: ,x_msg => 'l_fcst_job_id_tmp='||l_fcst_job_id_tmp
1668: ,x_log_level => li_message_level);
1669: END IF;
1670:

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

1680: END IF ; --IF (nvl(l_future_term_wf_flag,'N') = 'Y')
1681: /* End of Changes for Bug 6056112 */
1682:
1683: IF P_DEBUG_MODE = 'Y' THEN
1684: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1685: ,x_msg => 'l_person_type_code='||l_person_type_code
1686: ,x_log_level => li_message_level);
1687:
1688: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'

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

1684: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1685: ,x_msg => 'l_person_type_code='||l_person_type_code
1686: ,x_log_level => li_message_level);
1687:
1688: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1689: ,x_msg => 'proj_id='||p_assignment_rec.project_id||
1690: ' res_format='||l_cur_res_format_id||
1691: ' person_id='||l_person_id_tmp||
1692: ' job_id='||l_fcst_job_id_tmp

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

1690: ' res_format='||l_cur_res_format_id||
1691: ' person_id='||l_person_id_tmp||
1692: ' job_id='||l_fcst_job_id_tmp
1693: ,x_log_level => li_message_level);
1694: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1695: ,x_msg => 'org_id='||l_resource_organization_id||
1696: ' exp_type='||l_expenditure_type_tmp||
1697: ' role_id='||l_project_role_id_tmp||
1698: ' named_role='||l_assignment_name_tmp

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

1711: ,p_person_type_code => l_person_type_code
1712: ,p_named_role => l_assignment_name_tmp);
1713: --Log Message
1714: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1715: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1716: ,x_msg => 'new resource list member id='||l_assignment_rec.resource_list_member_id
1717: ,x_log_level => 5);
1718: END IF;
1719:

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

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

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

1815: ,x_return_status => l_return_status
1816: );
1817: --Log Message
1818: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1819: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
1820: ,x_msg => 'Update_task_assignments, status='||l_return_status
1821: ,x_log_level => 5);
1822: END IF;
1823:

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

1859:
1860:
1861: --Log Message
1862: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1863: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1864: ,x_msg => 'Update_task_assignments, status='||l_return_status
1865: ,x_log_level => 5);
1866: END IF;
1867:

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

1872: p_assignment_rec.assignment_name <> l_cur_assignment_name THEN
1873:
1874: --Log Message
1875: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1876: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1877: ,x_msg => 'Mandatory attributes not changed'
1878: ,x_log_level => 5);
1879: END IF;
1880:

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

1897: ,x_return_status => l_return_status
1898: );
1899: --Log Message
1900: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1901: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.begin'
1902: ,x_msg => 'Update_task_assignments, status='||l_return_status
1903: ,x_log_level => 5);
1904: END IF;
1905:

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

2008: IF l_assignment_rec.apprvl_status_code= PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
2009:
2010: --Log Message
2011: IF P_DEBUG_MODE = 'Y' THEN
2012: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.insert_history'
2013: ,x_msg => 'Inserting into Assignment History.'
2014: ,x_log_level => 5);
2015: END IF;
2016:

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

2025:
2026:
2027: --Log Message
2028: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2029: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.get_next_stus'
2030: ,x_msg => 'Getting next assignment approval status.'
2031: ,x_log_level => 5);
2032:
2033: END IF;

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

2060: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) THEN
2061:
2062: --Log Message
2063: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2064: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment.update_row'
2065: ,x_msg => 'Update Assignment Record.'
2066: ,x_log_level => 5);
2067: END IF;
2068:

Line 2142: PA_DEBUG.Reset_err_stack;

2138: END IF;
2139:
2140:
2141: -- Reset the error stack when returning to the calling program
2142: PA_DEBUG.Reset_err_stack;
2143:
2144:
2145: EXCEPTION
2146: WHEN OTHERS THEN

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

2146: WHEN OTHERS THEN
2147:
2148: -- Set the excetption Message and the stack
2149: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Update_Staffed_Assignment'
2150: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2151: --
2152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2153: RAISE; -- This is optional depending on the needs
2154:

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

2187:
2188: -- 4537865 : Initialize the return_status
2189: x_return_status := FND_API.G_RET_STS_SUCCESS;
2190: -- Initialize the Error Stack
2191: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment');
2192:
2193: --Log Message
2194: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2195: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.begin'

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

2191: PA_DEBUG.set_err_stack('PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment');
2192:
2193: --Log Message
2194: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2195: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.begin'
2196: ,x_msg => 'Beginning of Delete_Staff_Assignment'
2197: ,x_log_level => 5);
2198: END IF;
2199: -- Assignment cannot be deleted if project transactions are associated with it

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

2224: IF (p_validate_only = FND_API.G_FALSE AND PA_ASSIGNMENTS_PUB.g_error_exists <> FND_API.G_TRUE) 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.del_schedules'
2229: ,x_msg => 'Deleting Assignment Schedules'
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_asgmt'

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_asgmt'
2248: ,x_msg => 'Deleting Assignment record.'
2249: ,x_log_level => 5);
2250: END IF;
2251:

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

2261: IF x_return_status = 'S'AND p_project_party_id IS NOT NULL THEN
2262:
2263: --Log Message
2264: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2265: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.proj_party.'
2266: ,x_msg => 'Deleting Project Party'
2267: ,x_log_level => 5);
2268: END IF;
2269:

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

2280:
2281:
2282: --Log Message
2283: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2284: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment.del_history'
2285: ,x_msg => 'Deleting Assignment History.'
2286: ,x_log_level => 5);
2287: END IF;
2288:

Line 2302: PA_DEBUG.Reset_err_stack;

2298: END IF;
2299:
2300:
2301: -- Reset the error stack when returning to the calling program
2302: PA_DEBUG.Reset_err_stack;
2303:
2304: END IF;
2305:
2306: EXCEPTION

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

2307: WHEN OTHERS THEN
2308:
2309: -- Set the excetption Message and the stack
2310: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_STAFFED_ASSIGNMENT_PVT.Delete_Staffed_Assignment'
2311: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2312: --
2313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2314: RAISE; -- This is optional depending on the needs
2315: