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_TASK_ASSIGNMENT_UTILS dependencies on PA_TASK_ASSIGNMENT_UTILS

Line 1: PACKAGE BODY PA_TASK_ASSIGNMENT_UTILS as

1: PACKAGE BODY PA_TASK_ASSIGNMENT_UTILS as
2: --/* $Header: PATAUTLB.pls 120.21.12020000.3 2013/05/23 15:58:39 djambhek ship $ */
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: L_MODULE varchar2(100) := 'PA_TASK_ASSIGNMENT_UTILS';

Line 5: L_MODULE varchar2(100) := 'PA_TASK_ASSIGNMENT_UTILS';

1: PACKAGE BODY PA_TASK_ASSIGNMENT_UTILS as
2: --/* $Header: PATAUTLB.pls 120.21.12020000.3 2013/05/23 15:58:39 djambhek ship $ */
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: L_MODULE varchar2(100) := 'PA_TASK_ASSIGNMENT_UTILS';
6: li_message_level NUMBER := 1;
7: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8:
9:

Line 120: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS',

116: PA_DEBUG.write_log (x_module => L_Module,
117: x_msg => 'Unexp. Error:' || L_FuncProc || SQLERRM,
118: x_log_level => 6);
119: END IF;
120: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS',
121: p_procedure_name => 'Get_Task_Resources');
122: RAISE;
123:
124: END Get_Task_Resources;

Line 186: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS',

182: PA_DEBUG.write_log (x_module => L_Module,
183: x_msg => 'Unexp. Error:' || L_FuncProc || SQLERRM,
184: x_log_level => 6);
185: END IF;
186: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS',
187: p_procedure_name => 'Get_Task_Resources');
188: RAISE;
189:
190: END Get_Task_Resources;

Line 258: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS',

254: PA_DEBUG.write_log (x_module => L_Module,
255: x_msg => 'Unexp. Error:' || L_FuncProc || SQLERRM,
256: x_log_level => 6);
257: END IF;
258: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS',
259: p_procedure_name => 'Check_Asgmt_Exists_In_Task');
260: RAISE;
261:
262: END Check_Asgmt_Exists_In_Task;

Line 515: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

511: x_return_status := l_x_return_status ;
512:
513: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
514: pa_debug.g_err_stage:='Beginning of TA: Adjust_Asgmt_Dates: ';
515: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
516: pa_debug.g_err_stage:= 'p_context: ' || p_context;
517: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
518: pa_debug.g_err_stage:= 'p_element_version_id :' || p_element_version_id ;
519: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 517: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

513: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
514: pa_debug.g_err_stage:='Beginning of TA: Adjust_Asgmt_Dates: ';
515: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
516: pa_debug.g_err_stage:= 'p_context: ' || p_context;
517: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
518: pa_debug.g_err_stage:= 'p_element_version_id :' || p_element_version_id ;
519: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
520: pa_debug.g_err_stage:='p_old_task_sch_start: ' || p_old_task_sch_start;
521: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 519: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

515: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
516: pa_debug.g_err_stage:= 'p_context: ' || p_context;
517: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
518: pa_debug.g_err_stage:= 'p_element_version_id :' || p_element_version_id ;
519: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
520: pa_debug.g_err_stage:='p_old_task_sch_start: ' || p_old_task_sch_start;
521: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
522: pa_debug.g_err_stage:= 'p_new_task_sch_start: ' || p_new_task_sch_start;
523: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 521: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

517: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
518: pa_debug.g_err_stage:= 'p_element_version_id :' || p_element_version_id ;
519: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
520: pa_debug.g_err_stage:='p_old_task_sch_start: ' || p_old_task_sch_start;
521: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
522: pa_debug.g_err_stage:= 'p_new_task_sch_start: ' || p_new_task_sch_start;
523: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
524: pa_debug.g_err_stage:= 'p_new_task_sch_finish: ' || p_new_task_sch_finish ;
525: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 523: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

519: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
520: pa_debug.g_err_stage:='p_old_task_sch_start: ' || p_old_task_sch_start;
521: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
522: pa_debug.g_err_stage:= 'p_new_task_sch_start: ' || p_new_task_sch_start;
523: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
524: pa_debug.g_err_stage:= 'p_new_task_sch_finish: ' || p_new_task_sch_finish ;
525: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
526: END IF;
527:

Line 525: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

521: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
522: pa_debug.g_err_stage:= 'p_new_task_sch_start: ' || p_new_task_sch_start;
523: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
524: pa_debug.g_err_stage:= 'p_new_task_sch_finish: ' || p_new_task_sch_finish ;
525: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
526: END IF;
527:
528: IF p_old_task_sch_start <> p_new_task_sch_start OR
529: p_old_task_sch_finish <> p_new_task_sch_finish OR

Line 537: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

533: -- just insert the IN parameters into temp table.
534:
535: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
536: pa_debug.g_err_stage:= 'insert into temp table:';
537: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
538: END IF;
539:
540: /*Bug 4377886 : Included explicitly the column names in the INSERT statement
541: to remove the GSCC Warning File.Sql.33 */

Line 580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

576: CLOSE get_bvid;
577:
578: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
579: pa_debug.g_err_stage:= 'l_budget_ver_id: ' || l_budget_ver_id;
580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
581: pa_debug.g_err_stage:= 'l_struct_ver_id: ' || l_struct_ver_id ;
582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
583: END IF;
584:

Line 582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

578: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
579: pa_debug.g_err_stage:= 'l_budget_ver_id: ' || l_budget_ver_id;
580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
581: pa_debug.g_err_stage:= 'l_struct_ver_id: ' || l_struct_ver_id ;
582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
583: END IF;
584:
585: -- Bug 4153366: Manually seed the statistics for the temporary table.
586: SELECT to_number(value)

Line 612: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

608: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;
609:
610: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
611: pa_debug.g_err_stage:= 'Use task sch case found' ;
612: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
613: END IF;
614:
615: -- Get all task assignments without the above flag checked and with start or
616: -- end date outside the new task dates range:

Line 643: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

639: AND ra.wbs_element_version_id = tasks.src_elem_ver_id;
640:
641: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
642: pa_debug.g_err_stage:= 'Use Adj. sch case found' ;
643: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
644: pa_debug.g_err_stage:= 'B4 check for dates NULL or not';
645: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
646: END IF;
647:

Line 645: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

641: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
642: pa_debug.g_err_stage:= 'Use Adj. sch case found' ;
643: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
644: pa_debug.g_err_stage:= 'B4 check for dates NULL or not';
645: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
646: END IF;
647:
648: IF (l_use_task_sch_asgmt_tbl is not null OR l_adj_dates_asgmt_tbl is not NULL)
649: AND ( l_use_task_sch_asgmt_tbl.COUNT + l_adj_dates_asgmt_tbl.COUNT > 0) THEN

Line 653: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

649: AND ( l_use_task_sch_asgmt_tbl.COUNT + l_adj_dates_asgmt_tbl.COUNT > 0) THEN
650:
651: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
652: pa_debug.g_err_stage:= 'A4 check for dates NULL or not';
653: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
654: END IF;
655:
656: l_resource_assignment_id_tbl.extend(l_use_task_sch_asgmt_tbl.COUNT+l_adj_dates_asgmt_tbl.COUNT);
657: l_schedule_start_date_tbl.extend(l_use_task_sch_asgmt_tbl.COUNT+l_adj_dates_asgmt_tbl.COUNT);

Line 672: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

668: l_task_elem_version_id_tbl(i) := l_use_task_task_ver_tbl(i); --Bug 4153366
669:
670: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
671: pa_debug.g_err_stage:=' l_task_elem_version_id_tbl(i): ' || l_task_elem_version_id_tbl(i);
672: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
673: pa_debug.g_err_stage:='l_resource_assignment_id_tbl(' || i || ') : ' || l_resource_assignment_id_tbl(i);
674: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
675: pa_debug.g_err_stage:='l_schedule_start_date_tbl(' || i || ') : ' || l_schedule_start_date_tbl(i);
676: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 674: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

670: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
671: pa_debug.g_err_stage:=' l_task_elem_version_id_tbl(i): ' || l_task_elem_version_id_tbl(i);
672: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
673: pa_debug.g_err_stage:='l_resource_assignment_id_tbl(' || i || ') : ' || l_resource_assignment_id_tbl(i);
674: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
675: pa_debug.g_err_stage:='l_schedule_start_date_tbl(' || i || ') : ' || l_schedule_start_date_tbl(i);
676: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
677: pa_debug.g_err_stage:='l_schedule_end_date_tbl(' || i || ') : ' || l_schedule_end_date_tbl(i);
678: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 676: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

672: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
673: pa_debug.g_err_stage:='l_resource_assignment_id_tbl(' || i || ') : ' || l_resource_assignment_id_tbl(i);
674: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
675: pa_debug.g_err_stage:='l_schedule_start_date_tbl(' || i || ') : ' || l_schedule_start_date_tbl(i);
676: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
677: pa_debug.g_err_stage:='l_schedule_end_date_tbl(' || i || ') : ' || l_schedule_end_date_tbl(i);
678: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
679: END IF;
680:

Line 678: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

674: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
675: pa_debug.g_err_stage:='l_schedule_start_date_tbl(' || i || ') : ' || l_schedule_start_date_tbl(i);
676: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
677: pa_debug.g_err_stage:='l_schedule_end_date_tbl(' || i || ') : ' || l_schedule_end_date_tbl(i);
678: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
679: END IF;
680:
681: END LOOP;
682:

Line 715: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

711: END IF;
712:
713: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
714: pa_debug.g_err_stage:='l_resource_assignment_id_tbl(' || i || ') : ' || l_resource_assignment_id_tbl(i);
715: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
716: pa_debug.g_err_stage:='l_schedule_start_date_tbl(' || i || ') : ' || l_schedule_start_date_tbl(i);
717: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
718: pa_debug.g_err_stage:='l_schedule_end_date_tbl(' || i || ') : ' || l_schedule_end_date_tbl(i);
719: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 717: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

713: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
714: pa_debug.g_err_stage:='l_resource_assignment_id_tbl(' || i || ') : ' || l_resource_assignment_id_tbl(i);
715: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
716: pa_debug.g_err_stage:='l_schedule_start_date_tbl(' || i || ') : ' || l_schedule_start_date_tbl(i);
717: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
718: pa_debug.g_err_stage:='l_schedule_end_date_tbl(' || i || ') : ' || l_schedule_end_date_tbl(i);
719: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
720: END IF;
721:

Line 719: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

715: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
716: pa_debug.g_err_stage:='l_schedule_start_date_tbl(' || i || ') : ' || l_schedule_start_date_tbl(i);
717: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
718: pa_debug.g_err_stage:='l_schedule_end_date_tbl(' || i || ') : ' || l_schedule_end_date_tbl(i);
719: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
720: END IF;
721:
722: k := k + 1;
723:

Line 730: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

726: IF p_context = 'UPDATE' THEN
727:
728: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
729: pa_debug.g_err_stage:= ' B4 update planning transaction call update in adjust dates: ' || x_return_status;
730: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
731: END IF;
732:
733: pa_fp_planning_transaction_pub.update_planning_transactions
734: (

Line 749: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

745: );
746:
747: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
748: pa_debug.g_err_stage:= 'x_return_status after update in adjust dates ' || x_return_status;
749: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
750: END IF;
751:
752: -- Bug 4153366 - clear the temp table
753: DELETE pa_copy_asgmts_temp;

Line 916: pa_debug.g_err_stage:='Beginning of PA_TASK_ASSIGNMENT_UTILS.Validate_Create_Assignment';

912:
913: --Loop through each task record in p_task_rec_tbl
914: --Get default Planning Dates:
915: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
916: pa_debug.g_err_stage:='Beginning of PA_TASK_ASSIGNMENT_UTILS.Validate_Create_Assignment';
917: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
918: END IF;
919:
920: x_del_task_level_rec_code_tbl := system.pa_varchar2_30_tbl_type();

Line 917: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

913: --Loop through each task record in p_task_rec_tbl
914: --Get default Planning Dates:
915: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
916: pa_debug.g_err_stage:='Beginning of PA_TASK_ASSIGNMENT_UTILS.Validate_Create_Assignment';
917: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
918: END IF;
919:
920: x_del_task_level_rec_code_tbl := system.pa_varchar2_30_tbl_type();
921: x_del_task_level_rec_code_tbl.extend(p_task_rec_tbl.COUNT);

Line 1003: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

999: End If;
1000:
1001: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1002: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).procure_resource_flag'||p_task_assignment_tbl(i).procure_resource_flag;
1003: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1004: END IF;
1005:
1006: --2. SCHEDULE INFORMATION VALIDATION
1007: -- Bug 3793623

Line 1108: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1104: --p_task_assignment_tbl(i).use_task_schedule_flag := 'N';
1105:
1106: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1107: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).planning_start_date'||p_task_assignment_tbl(i).planning_start_date;
1108: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1109: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).planning_end_date'||p_task_assignment_tbl(i).planning_end_date;
1110: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1111: pa_debug.g_err_stage:='TA: l_task_people_effort'||l_task_people_effort;
1112: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1110: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1106: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1107: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).planning_start_date'||p_task_assignment_tbl(i).planning_start_date;
1108: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1109: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).planning_end_date'||p_task_assignment_tbl(i).planning_end_date;
1110: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1111: pa_debug.g_err_stage:='TA: l_task_people_effort'||l_task_people_effort;
1112: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1113: pa_debug.g_err_stage:='TA: l_task_equip_effort'||l_task_equip_effort;
1114: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1112: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1108: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1109: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).planning_end_date'||p_task_assignment_tbl(i).planning_end_date;
1110: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1111: pa_debug.g_err_stage:='TA: l_task_people_effort'||l_task_people_effort;
1112: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1113: pa_debug.g_err_stage:='TA: l_task_equip_effort'||l_task_equip_effort;
1114: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1115: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).total_quantity'||p_task_assignment_tbl(i).total_quantity;
1116: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1114: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1110: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1111: pa_debug.g_err_stage:='TA: l_task_people_effort'||l_task_people_effort;
1112: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1113: pa_debug.g_err_stage:='TA: l_task_equip_effort'||l_task_equip_effort;
1114: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1115: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).total_quantity'||p_task_assignment_tbl(i).total_quantity;
1116: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1117: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).use_task_schedule_flag'||p_task_assignment_tbl(i).use_task_schedule_flag;
1118: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1116: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1112: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1113: pa_debug.g_err_stage:='TA: l_task_equip_effort'||l_task_equip_effort;
1114: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1115: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).total_quantity'||p_task_assignment_tbl(i).total_quantity;
1116: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1117: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).use_task_schedule_flag'||p_task_assignment_tbl(i).use_task_schedule_flag;
1118: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1119: END IF;
1120:

Line 1118: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1114: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1115: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).total_quantity'||p_task_assignment_tbl(i).total_quantity;
1116: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1117: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(i).use_task_schedule_flag'||p_task_assignment_tbl(i).use_task_schedule_flag;
1118: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1119: END IF;
1120:
1121: END LOOP;
1122:

Line 1133: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1129: End If;
1130:
1131: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1132: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).procure_resource_flag'||p_task_assignment_tbl(k).procure_resource_flag;
1133: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1134: END IF;
1135:
1136: --2. SCHEDULE INFORMATION VALIDATION
1137: -- Bug 3793623

Line 1232: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1228: END IF;
1229:
1230: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1231: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).planning_start_date'||p_task_assignment_tbl(k).planning_start_date;
1232: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1233: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).planning_end_date'||p_task_assignment_tbl(k).planning_end_date;
1234: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1235: pa_debug.g_err_stage:='TA: l_task_people_effort'||l_task_people_effort;
1236: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1234: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1230: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1231: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).planning_start_date'||p_task_assignment_tbl(k).planning_start_date;
1232: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1233: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).planning_end_date'||p_task_assignment_tbl(k).planning_end_date;
1234: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1235: pa_debug.g_err_stage:='TA: l_task_people_effort'||l_task_people_effort;
1236: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1237: pa_debug.g_err_stage:='TA: l_task_equip_effort'||l_task_equip_effort;
1238: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1236: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1232: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1233: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).planning_end_date'||p_task_assignment_tbl(k).planning_end_date;
1234: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1235: pa_debug.g_err_stage:='TA: l_task_people_effort'||l_task_people_effort;
1236: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1237: pa_debug.g_err_stage:='TA: l_task_equip_effort'||l_task_equip_effort;
1238: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1239: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).total_quantity'||p_task_assignment_tbl(k).total_quantity;
1240: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1238: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1234: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1235: pa_debug.g_err_stage:='TA: l_task_people_effort'||l_task_people_effort;
1236: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1237: pa_debug.g_err_stage:='TA: l_task_equip_effort'||l_task_equip_effort;
1238: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1239: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).total_quantity'||p_task_assignment_tbl(k).total_quantity;
1240: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1241: END IF;
1242:

Line 1240: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1236: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1237: pa_debug.g_err_stage:='TA: l_task_equip_effort'||l_task_equip_effort;
1238: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1239: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).total_quantity'||p_task_assignment_tbl(k).total_quantity;
1240: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1241: END IF;
1242:
1243:
1244: --Get default 'Assignment same as Task Duration' flag:

Line 1251: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1247:
1248:
1249: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1250: pa_debug.g_err_stage:='TA: p_task_assignment_tbl(k).use_task_schedule_flag'||p_task_assignment_tbl(k).use_task_schedule_flag;
1251: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1252: END IF;
1253:
1254: END IF; -- p_one_to_one_mapping_flag = 'N'
1255:

Line 1287: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1283: -- PA_TASKS to PA_ASSIGNMENT.
1284:
1285: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1286: pa_debug.g_err_stage:='Validate_Create_Assignment - Updating ta_display_flag to Y';
1287: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1288: END IF;
1289:
1290: -- 10/19/04: Discussed with Sakthi, Koushik and Ansari. We should not
1291: -- convert ta_display_flag from 'N' to 'Y' on published version

Line 1348: pa_debug.g_err_stage:='End of PA_TASK_ASSIGNMENT_UTILS.Validate_Create_Assignment';

1344:
1345: END IF; -- IF p_task_rec_tbl.count > 0
1346:
1347: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1348: pa_debug.g_err_stage:='End of PA_TASK_ASSIGNMENT_UTILS.Validate_Create_Assignment';
1349: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1350: END IF;
1351:
1352: EXCEPTION

Line 1349: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1345: END IF; -- IF p_task_rec_tbl.count > 0
1346:
1347: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1348: pa_debug.g_err_stage:='End of PA_TASK_ASSIGNMENT_UTILS.Validate_Create_Assignment';
1349: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1350: END IF;
1351:
1352: EXCEPTION
1353:

Line 1555: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1551: g_require_progress_rollup := 'N'; -- End of Bug 4492493
1552:
1553: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1554: pa_debug.g_err_stage:='Beginning of TA:Validate_Update_Assignment';
1555: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1556: END IF;
1557:
1558: l_msg_added_flag := 'N'; -- Fix for Bug # 4319137.
1559:

Line 1576: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1572: l_viol_indicator := null;
1573:
1574: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1575: pa_debug.g_err_stage:='P_resource_assignment_id:' || i || ' : ' || p_task_assignment_tbl(i).resource_assignment_id;
1576: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1577: pa_debug.g_err_stage:='P_Planning_Resource_Alias:' || i || p_task_assignment_tbl(i).planning_resource_alias;
1578: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1579: pa_debug.g_err_stage:='P_resource_list_member_id:' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id;
1580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1578: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1574: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1575: pa_debug.g_err_stage:='P_resource_assignment_id:' || i || ' : ' || p_task_assignment_tbl(i).resource_assignment_id;
1576: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1577: pa_debug.g_err_stage:='P_Planning_Resource_Alias:' || i || p_task_assignment_tbl(i).planning_resource_alias;
1578: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1579: pa_debug.g_err_stage:='P_resource_list_member_id:' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id;
1580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1581: pa_debug.g_err_stage:='P_resource_class_code:' || i || ' : ' || p_task_assignment_tbl(i).resource_class_code;
1582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1576: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1577: pa_debug.g_err_stage:='P_Planning_Resource_Alias:' || i || p_task_assignment_tbl(i).planning_resource_alias;
1578: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1579: pa_debug.g_err_stage:='P_resource_list_member_id:' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id;
1580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1581: pa_debug.g_err_stage:='P_resource_class_code:' || i || ' : ' || p_task_assignment_tbl(i).resource_class_code;
1582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1583: pa_debug.g_err_stage:='P_res_type_code:' || i || ' : ' || p_task_assignment_tbl(i).res_type_code;
1584: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1578: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1579: pa_debug.g_err_stage:='P_resource_list_member_id:' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id;
1580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1581: pa_debug.g_err_stage:='P_resource_class_code:' || i || ' : ' || p_task_assignment_tbl(i).resource_class_code;
1582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1583: pa_debug.g_err_stage:='P_res_type_code:' || i || ' : ' || p_task_assignment_tbl(i).res_type_code;
1584: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1585: pa_debug.g_err_stage:='P_resource_code:' || i || ' : ' || p_task_assignment_tbl(i).resource_code;
1586: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1584: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1580: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1581: pa_debug.g_err_stage:='P_resource_class_code:' || i || ' : ' || p_task_assignment_tbl(i).resource_class_code;
1582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1583: pa_debug.g_err_stage:='P_res_type_code:' || i || ' : ' || p_task_assignment_tbl(i).res_type_code;
1584: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1585: pa_debug.g_err_stage:='P_resource_code:' || i || ' : ' || p_task_assignment_tbl(i).resource_code;
1586: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1587: pa_debug.g_err_stage:='P_resource_name:' || i || ' : ' || p_task_assignment_tbl(i).resource_name;
1588: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1586: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1582: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1583: pa_debug.g_err_stage:='P_res_type_code:' || i || ' : ' || p_task_assignment_tbl(i).res_type_code;
1584: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1585: pa_debug.g_err_stage:='P_resource_code:' || i || ' : ' || p_task_assignment_tbl(i).resource_code;
1586: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1587: pa_debug.g_err_stage:='P_resource_name:' || i || ' : ' || p_task_assignment_tbl(i).resource_name;
1588: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1589: pa_debug.g_err_stage:='P_project_role_id:' || i || ' : ' || p_task_assignment_tbl(i).project_role_id;
1590: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1588: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1584: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1585: pa_debug.g_err_stage:='P_resource_code:' || i || ' : ' || p_task_assignment_tbl(i).resource_code;
1586: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1587: pa_debug.g_err_stage:='P_resource_name:' || i || ' : ' || p_task_assignment_tbl(i).resource_name;
1588: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1589: pa_debug.g_err_stage:='P_project_role_id:' || i || ' : ' || p_task_assignment_tbl(i).project_role_id;
1590: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1591: pa_debug.g_err_stage:='P_project_role_name:' || i || ' : ' || p_task_assignment_tbl(i).project_role_name;
1592: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1590: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1586: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1587: pa_debug.g_err_stage:='P_resource_name:' || i || ' : ' || p_task_assignment_tbl(i).resource_name;
1588: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1589: pa_debug.g_err_stage:='P_project_role_id:' || i || ' : ' || p_task_assignment_tbl(i).project_role_id;
1590: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1591: pa_debug.g_err_stage:='P_project_role_name:' || i || ' : ' || p_task_assignment_tbl(i).project_role_name;
1592: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1593: pa_debug.g_err_stage:='P_organization_id:' || i || ' : ' || p_task_assignment_tbl(i).organization_id;
1594: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1592: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1588: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1589: pa_debug.g_err_stage:='P_project_role_id:' || i || ' : ' || p_task_assignment_tbl(i).project_role_id;
1590: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1591: pa_debug.g_err_stage:='P_project_role_name:' || i || ' : ' || p_task_assignment_tbl(i).project_role_name;
1592: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1593: pa_debug.g_err_stage:='P_organization_id:' || i || ' : ' || p_task_assignment_tbl(i).organization_id;
1594: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1595: pa_debug.g_err_stage:='P_organization_name:' || i || ' : ' || p_task_assignment_tbl(i).organization_name;
1596: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1594: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1590: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1591: pa_debug.g_err_stage:='P_project_role_name:' || i || ' : ' || p_task_assignment_tbl(i).project_role_name;
1592: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1593: pa_debug.g_err_stage:='P_organization_id:' || i || ' : ' || p_task_assignment_tbl(i).organization_id;
1594: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1595: pa_debug.g_err_stage:='P_organization_name:' || i || ' : ' || p_task_assignment_tbl(i).organization_name;
1596: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1597: pa_debug.g_err_stage:='P_FC_Res_Type_Code:' || i || ' : ' || p_task_assignment_tbl(i).fc_res_type_code;
1598: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1596: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1592: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1593: pa_debug.g_err_stage:='P_organization_id:' || i || ' : ' || p_task_assignment_tbl(i).organization_id;
1594: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1595: pa_debug.g_err_stage:='P_organization_name:' || i || ' : ' || p_task_assignment_tbl(i).organization_name;
1596: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1597: pa_debug.g_err_stage:='P_FC_Res_Type_Code:' || i || ' : ' || p_task_assignment_tbl(i).fc_res_type_code;
1598: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1599: pa_debug.g_err_stage:='P_Fin_Category_Name:' || i || ' : ' || p_task_assignment_tbl(i).financial_category_name;
1600: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1598: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1594: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1595: pa_debug.g_err_stage:='P_organization_name:' || i || ' : ' || p_task_assignment_tbl(i).organization_name;
1596: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1597: pa_debug.g_err_stage:='P_FC_Res_Type_Code:' || i || ' : ' || p_task_assignment_tbl(i).fc_res_type_code;
1598: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1599: pa_debug.g_err_stage:='P_Fin_Category_Name:' || i || ' : ' || p_task_assignment_tbl(i).financial_category_name;
1600: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1601: pa_debug.g_err_stage:='P_Supplier_id:' || i || ' : ' || p_task_assignment_tbl(i).supplier_id;
1602: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1600: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1596: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1597: pa_debug.g_err_stage:='P_FC_Res_Type_Code:' || i || ' : ' || p_task_assignment_tbl(i).fc_res_type_code;
1598: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1599: pa_debug.g_err_stage:='P_Fin_Category_Name:' || i || ' : ' || p_task_assignment_tbl(i).financial_category_name;
1600: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1601: pa_debug.g_err_stage:='P_Supplier_id:' || i || ' : ' || p_task_assignment_tbl(i).supplier_id;
1602: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1603: pa_debug.g_err_stage:='P_Supplier_name:' || i || ' : ' || p_task_assignment_tbl(i).supplier_name;
1604: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1602: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1598: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1599: pa_debug.g_err_stage:='P_Fin_Category_Name:' || i || ' : ' || p_task_assignment_tbl(i).financial_category_name;
1600: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1601: pa_debug.g_err_stage:='P_Supplier_id:' || i || ' : ' || p_task_assignment_tbl(i).supplier_id;
1602: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1603: pa_debug.g_err_stage:='P_Supplier_name:' || i || ' : ' || p_task_assignment_tbl(i).supplier_name;
1604: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1605: pa_debug.g_err_stage:='P_INcur_By_Resource_Code:' || i || ' : ' || p_task_assignment_tbl(i).incur_by_resource_code;
1606: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1604: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1600: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1601: pa_debug.g_err_stage:='P_Supplier_id:' || i || ' : ' || p_task_assignment_tbl(i).supplier_id;
1602: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1603: pa_debug.g_err_stage:='P_Supplier_name:' || i || ' : ' || p_task_assignment_tbl(i).supplier_name;
1604: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1605: pa_debug.g_err_stage:='P_INcur_By_Resource_Code:' || i || ' : ' || p_task_assignment_tbl(i).incur_by_resource_code;
1606: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1607: pa_debug.g_err_stage:='P_planning_start_date:' || i || ' : ' || p_task_assignment_tbl(i).planning_start_date;
1608: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1606: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1602: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1603: pa_debug.g_err_stage:='P_Supplier_name:' || i || ' : ' || p_task_assignment_tbl(i).supplier_name;
1604: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1605: pa_debug.g_err_stage:='P_INcur_By_Resource_Code:' || i || ' : ' || p_task_assignment_tbl(i).incur_by_resource_code;
1606: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1607: pa_debug.g_err_stage:='P_planning_start_date:' || i || ' : ' || p_task_assignment_tbl(i).planning_start_date;
1608: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1609: pa_debug.g_err_stage:='P_planning_end_date : ' || i || ' : ' || p_task_assignment_tbl(i).planning_end_date;
1610: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1608: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1604: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1605: pa_debug.g_err_stage:='P_INcur_By_Resource_Code:' || i || ' : ' || p_task_assignment_tbl(i).incur_by_resource_code;
1606: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1607: pa_debug.g_err_stage:='P_planning_start_date:' || i || ' : ' || p_task_assignment_tbl(i).planning_start_date;
1608: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1609: pa_debug.g_err_stage:='P_planning_end_date : ' || i || ' : ' || p_task_assignment_tbl(i).planning_end_date;
1610: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1611: pa_debug.g_err_stage:='P_schedule_start_date:' || i || ' : ' || p_task_assignment_tbl(i).schedule_start_date;
1612: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1610: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1606: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1607: pa_debug.g_err_stage:='P_planning_start_date:' || i || ' : ' || p_task_assignment_tbl(i).planning_start_date;
1608: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1609: pa_debug.g_err_stage:='P_planning_end_date : ' || i || ' : ' || p_task_assignment_tbl(i).planning_end_date;
1610: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1611: pa_debug.g_err_stage:='P_schedule_start_date:' || i || ' : ' || p_task_assignment_tbl(i).schedule_start_date;
1612: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1613: pa_debug.g_err_stage:='P_schedule_end_date : ' || i || ' : ' || p_task_assignment_tbl(i).schedule_end_date;
1614: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1612: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1608: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1609: pa_debug.g_err_stage:='P_planning_end_date : ' || i || ' : ' || p_task_assignment_tbl(i).planning_end_date;
1610: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1611: pa_debug.g_err_stage:='P_schedule_start_date:' || i || ' : ' || p_task_assignment_tbl(i).schedule_start_date;
1612: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1613: pa_debug.g_err_stage:='P_schedule_end_date : ' || i || ' : ' || p_task_assignment_tbl(i).schedule_end_date;
1614: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1615: END IF;
1616:

Line 1614: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1610: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1611: pa_debug.g_err_stage:='P_schedule_start_date:' || i || ' : ' || p_task_assignment_tbl(i).schedule_start_date;
1612: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1613: pa_debug.g_err_stage:='P_schedule_end_date : ' || i || ' : ' || p_task_assignment_tbl(i).schedule_end_date;
1614: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1615: END IF;
1616:
1617: -- get old assignment data
1618: OPEN C_Res_Assignment_Info(p_task_assignment_tbl(i).resource_assignment_id);

Line 1697: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1693: CLOSE C1_Task_Dates;
1694:
1695: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1696: pa_debug.g_err_stage:='TA: alias:'||p_task_assignment_tbl(i).planning_resource_alias;
1697: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1698: pa_debug.g_err_stage:='TA: resource_list_member_id:'||p_task_assignment_tbl(i).resource_list_member_id;
1699: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1700: END IF;
1701:

Line 1699: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1695: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1696: pa_debug.g_err_stage:='TA: alias:'||p_task_assignment_tbl(i).planning_resource_alias;
1697: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1698: pa_debug.g_err_stage:='TA: resource_list_member_id:'||p_task_assignment_tbl(i).resource_list_member_id;
1699: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1700: END IF;
1701:
1702: L_Incur_By_Resource_Type := NULL;
1703: --reinitialize..

Line 1758: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1754: Lr_eligible_rlm_id_tbl(1) := p_task_assignment_tbl(i).resource_list_member_id;
1755:
1756: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1757: pa_debug.g_err_stage:='About to call PA_PLANNING_RESOURCE_UTILS.get_resource_defaults w/ret.status='||x_return_status;
1758: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1759: END IF;
1760:
1761: PA_PLANNING_RESOURCE_UTILS.get_resource_defaults(
1762: p_resource_list_members => Lr_eligible_rlm_id_tbl,

Line 1802: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1798: x_return_status => x_return_status);
1799:
1800: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1801: pa_debug.g_err_stage:='After PA_PLANNING_RESOURCE_UTILS.get_resource_defaults='||x_return_status;
1802: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1803: pa_debug.g_err_stage:='X_Resource_List_Member_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id ;
1804: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1805: pa_debug.g_err_stage:='x_resource_class_flag_tbl => ' || lr_resource_class_flag_tbl(1) ;
1806: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1804: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1800: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1801: pa_debug.g_err_stage:='After PA_PLANNING_RESOURCE_UTILS.get_resource_defaults='||x_return_status;
1802: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1803: pa_debug.g_err_stage:='X_Resource_List_Member_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id ;
1804: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1805: pa_debug.g_err_stage:='x_resource_class_flag_tbl => ' || lr_resource_class_flag_tbl(1) ;
1806: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1807: pa_debug.g_err_stage:='x_resource_class_code_tbl => ' || lr_resource_class_code_tbl(1) ;
1808: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1806: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1802: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1803: pa_debug.g_err_stage:='X_Resource_List_Member_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id ;
1804: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1805: pa_debug.g_err_stage:='x_resource_class_flag_tbl => ' || lr_resource_class_flag_tbl(1) ;
1806: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1807: pa_debug.g_err_stage:='x_resource_class_code_tbl => ' || lr_resource_class_code_tbl(1) ;
1808: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1809: pa_debug.g_err_stage:='x_resource_class_id_tbl => ' || lr_resource_class_id_tbl(1) ;
1810: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1808: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1804: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1805: pa_debug.g_err_stage:='x_resource_class_flag_tbl => ' || lr_resource_class_flag_tbl(1) ;
1806: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1807: pa_debug.g_err_stage:='x_resource_class_code_tbl => ' || lr_resource_class_code_tbl(1) ;
1808: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1809: pa_debug.g_err_stage:='x_resource_class_id_tbl => ' || lr_resource_class_id_tbl(1) ;
1810: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1811: pa_debug.g_err_stage:='x_res_type_code_tbl => ' || lr_res_type_code_tbl(1) ;
1812: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1810: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1806: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1807: pa_debug.g_err_stage:='x_resource_class_code_tbl => ' || lr_resource_class_code_tbl(1) ;
1808: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1809: pa_debug.g_err_stage:='x_resource_class_id_tbl => ' || lr_resource_class_id_tbl(1) ;
1810: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1811: pa_debug.g_err_stage:='x_res_type_code_tbl => ' || lr_res_type_code_tbl(1) ;
1812: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1813: pa_debug.g_err_stage:='x_incur_by_res_type_tbl => ' || lr_incur_by_res_type_tbl(1) ;
1814: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1812: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1808: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1809: pa_debug.g_err_stage:='x_resource_class_id_tbl => ' || lr_resource_class_id_tbl(1) ;
1810: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1811: pa_debug.g_err_stage:='x_res_type_code_tbl => ' || lr_res_type_code_tbl(1) ;
1812: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1813: pa_debug.g_err_stage:='x_incur_by_res_type_tbl => ' || lr_incur_by_res_type_tbl(1) ;
1814: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1815: pa_debug.g_err_stage:='x_person_id_tbl => ' || lr_person_id_tbl(1) ;
1816: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1814: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1810: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1811: pa_debug.g_err_stage:='x_res_type_code_tbl => ' || lr_res_type_code_tbl(1) ;
1812: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1813: pa_debug.g_err_stage:='x_incur_by_res_type_tbl => ' || lr_incur_by_res_type_tbl(1) ;
1814: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1815: pa_debug.g_err_stage:='x_person_id_tbl => ' || lr_person_id_tbl(1) ;
1816: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1817: pa_debug.g_err_stage:='x_person_type_code_tbl => ' || lr_person_type_code_tbl(1) ;
1818: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1816: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1812: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1813: pa_debug.g_err_stage:='x_incur_by_res_type_tbl => ' || lr_incur_by_res_type_tbl(1) ;
1814: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1815: pa_debug.g_err_stage:='x_person_id_tbl => ' || lr_person_id_tbl(1) ;
1816: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1817: pa_debug.g_err_stage:='x_person_type_code_tbl => ' || lr_person_type_code_tbl(1) ;
1818: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1819: pa_debug.g_err_stage:='x_named_role_tbl => ' || lr_named_role_tbl(1) ;
1820: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1818: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1814: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1815: pa_debug.g_err_stage:='x_person_id_tbl => ' || lr_person_id_tbl(1) ;
1816: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1817: pa_debug.g_err_stage:='x_person_type_code_tbl => ' || lr_person_type_code_tbl(1) ;
1818: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1819: pa_debug.g_err_stage:='x_named_role_tbl => ' || lr_named_role_tbl(1) ;
1820: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1821: pa_debug.g_err_stage:='x_bom_resource_id_tbl => ' || lr_bom_resource_id_tbl(1) ;
1822: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1820: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1816: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1817: pa_debug.g_err_stage:='x_person_type_code_tbl => ' || lr_person_type_code_tbl(1) ;
1818: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1819: pa_debug.g_err_stage:='x_named_role_tbl => ' || lr_named_role_tbl(1) ;
1820: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1821: pa_debug.g_err_stage:='x_bom_resource_id_tbl => ' || lr_bom_resource_id_tbl(1) ;
1822: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1823: pa_debug.g_err_stage:='x_non_labor_resource_tbl => ' || lr_non_labor_resource_tbl(1) ;
1824: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1822: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1818: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1819: pa_debug.g_err_stage:='x_named_role_tbl => ' || lr_named_role_tbl(1) ;
1820: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1821: pa_debug.g_err_stage:='x_bom_resource_id_tbl => ' || lr_bom_resource_id_tbl(1) ;
1822: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1823: pa_debug.g_err_stage:='x_non_labor_resource_tbl => ' || lr_non_labor_resource_tbl(1) ;
1824: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1825: pa_debug.g_err_stage:='x_inventory_item_id_tbl => ' || lr_inventory_item_id_tbl(1) ;
1826: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1824: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1820: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1821: pa_debug.g_err_stage:='x_bom_resource_id_tbl => ' || lr_bom_resource_id_tbl(1) ;
1822: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1823: pa_debug.g_err_stage:='x_non_labor_resource_tbl => ' || lr_non_labor_resource_tbl(1) ;
1824: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1825: pa_debug.g_err_stage:='x_inventory_item_id_tbl => ' || lr_inventory_item_id_tbl(1) ;
1826: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1827: pa_debug.g_err_stage:='x_item_category_id_tbl => ' || lr_item_category_id_tbl(1) ;
1828: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1826: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1822: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1823: pa_debug.g_err_stage:='x_non_labor_resource_tbl => ' || lr_non_labor_resource_tbl(1) ;
1824: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1825: pa_debug.g_err_stage:='x_inventory_item_id_tbl => ' || lr_inventory_item_id_tbl(1) ;
1826: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1827: pa_debug.g_err_stage:='x_item_category_id_tbl => ' || lr_item_category_id_tbl(1) ;
1828: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1829: pa_debug.g_err_stage:='x_project_role_id_tbl => ' || lr_project_role_id_tbl(1) ;
1830: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1828: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1824: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1825: pa_debug.g_err_stage:='x_inventory_item_id_tbl => ' || lr_inventory_item_id_tbl(1) ;
1826: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1827: pa_debug.g_err_stage:='x_item_category_id_tbl => ' || lr_item_category_id_tbl(1) ;
1828: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1829: pa_debug.g_err_stage:='x_project_role_id_tbl => ' || lr_project_role_id_tbl(1) ;
1830: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1831: pa_debug.g_err_stage:='x_organization_id_tbl => ' || lr_organization_id_tbl(1) ;
1832: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1830: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1826: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1827: pa_debug.g_err_stage:='x_item_category_id_tbl => ' || lr_item_category_id_tbl(1) ;
1828: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1829: pa_debug.g_err_stage:='x_project_role_id_tbl => ' || lr_project_role_id_tbl(1) ;
1830: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1831: pa_debug.g_err_stage:='x_organization_id_tbl => ' || lr_organization_id_tbl(1) ;
1832: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1833: pa_debug.g_err_stage:='x_fc_res_type_code_tbl => ' || lr_fc_res_type_code_tbl(1) ;
1834: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1832: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1828: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1829: pa_debug.g_err_stage:='x_project_role_id_tbl => ' || lr_project_role_id_tbl(1) ;
1830: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1831: pa_debug.g_err_stage:='x_organization_id_tbl => ' || lr_organization_id_tbl(1) ;
1832: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1833: pa_debug.g_err_stage:='x_fc_res_type_code_tbl => ' || lr_fc_res_type_code_tbl(1) ;
1834: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1835: pa_debug.g_err_stage:='x_expenditure_type_tbl => ' || lr_expenditure_type_tbl(1) ;
1836: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1834: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1830: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1831: pa_debug.g_err_stage:='x_organization_id_tbl => ' || lr_organization_id_tbl(1) ;
1832: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1833: pa_debug.g_err_stage:='x_fc_res_type_code_tbl => ' || lr_fc_res_type_code_tbl(1) ;
1834: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1835: pa_debug.g_err_stage:='x_expenditure_type_tbl => ' || lr_expenditure_type_tbl(1) ;
1836: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1837: pa_debug.g_err_stage:='x_event_type_tbl => ' || lr_event_type_tbl(1) ;
1838: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1836: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1832: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1833: pa_debug.g_err_stage:='x_fc_res_type_code_tbl => ' || lr_fc_res_type_code_tbl(1) ;
1834: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1835: pa_debug.g_err_stage:='x_expenditure_type_tbl => ' || lr_expenditure_type_tbl(1) ;
1836: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1837: pa_debug.g_err_stage:='x_event_type_tbl => ' || lr_event_type_tbl(1) ;
1838: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1839: pa_debug.g_err_stage:='x_revenue_category_code_tbl => ' || lr_revenue_category_code_tbl(1) ;
1840: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1838: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1834: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1835: pa_debug.g_err_stage:='x_expenditure_type_tbl => ' || lr_expenditure_type_tbl(1) ;
1836: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1837: pa_debug.g_err_stage:='x_event_type_tbl => ' || lr_event_type_tbl(1) ;
1838: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1839: pa_debug.g_err_stage:='x_revenue_category_code_tbl => ' || lr_revenue_category_code_tbl(1) ;
1840: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1841: pa_debug.g_err_stage:='x_supplier_id =>' || lr_supplier_id_tbl(1);
1842: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1840: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1836: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1837: pa_debug.g_err_stage:='x_event_type_tbl => ' || lr_event_type_tbl(1) ;
1838: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1839: pa_debug.g_err_stage:='x_revenue_category_code_tbl => ' || lr_revenue_category_code_tbl(1) ;
1840: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1841: pa_debug.g_err_stage:='x_supplier_id =>' || lr_supplier_id_tbl(1);
1842: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1843: pa_debug.g_err_stage:='x_unit_of_measure =>' || lr_unit_of_measure_tbl(1);
1844: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1842: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1838: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1839: pa_debug.g_err_stage:='x_revenue_category_code_tbl => ' || lr_revenue_category_code_tbl(1) ;
1840: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1841: pa_debug.g_err_stage:='x_supplier_id =>' || lr_supplier_id_tbl(1);
1842: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1843: pa_debug.g_err_stage:='x_unit_of_measure =>' || lr_unit_of_measure_tbl(1);
1844: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1845: pa_debug.g_err_stage:='x_spread_curve_id =>' || lr_spread_curve_id_tbl(1);
1846: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1844: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1840: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1841: pa_debug.g_err_stage:='x_supplier_id =>' || lr_supplier_id_tbl(1);
1842: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1843: pa_debug.g_err_stage:='x_unit_of_measure =>' || lr_unit_of_measure_tbl(1);
1844: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1845: pa_debug.g_err_stage:='x_spread_curve_id =>' || lr_spread_curve_id_tbl(1);
1846: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1847: pa_debug.g_err_stage:='x_etc_method_code =>' || lr_etc_method_code_tbl(1);
1848: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1846: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1842: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1843: pa_debug.g_err_stage:='x_unit_of_measure =>' || lr_unit_of_measure_tbl(1);
1844: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1845: pa_debug.g_err_stage:='x_spread_curve_id =>' || lr_spread_curve_id_tbl(1);
1846: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1847: pa_debug.g_err_stage:='x_etc_method_code =>' || lr_etc_method_code_tbl(1);
1848: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1849: pa_debug.g_err_stage:='x_mfc_cost_type_id =>' || lr_mfc_cost_type_id_tbl(1);
1850: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1848: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1844: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1845: pa_debug.g_err_stage:='x_spread_curve_id =>' || lr_spread_curve_id_tbl(1);
1846: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1847: pa_debug.g_err_stage:='x_etc_method_code =>' || lr_etc_method_code_tbl(1);
1848: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1849: pa_debug.g_err_stage:='x_mfc_cost_type_id =>' || lr_mfc_cost_type_id_tbl(1);
1850: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1851: pa_debug.g_err_stage:='x_incurred_by_res_flag =>' || lr_incurred_by_res_flag_tbl(1);
1852: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1850: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1846: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1847: pa_debug.g_err_stage:='x_etc_method_code =>' || lr_etc_method_code_tbl(1);
1848: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1849: pa_debug.g_err_stage:='x_mfc_cost_type_id =>' || lr_mfc_cost_type_id_tbl(1);
1850: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1851: pa_debug.g_err_stage:='x_incurred_by_res_flag =>' || lr_incurred_by_res_flag_tbl(1);
1852: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1853: pa_debug.g_err_stage:='x_incur_by_res_class_code=>' || lr_incur_by_res_class_code_tbl(1);
1854: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1852: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1848: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1849: pa_debug.g_err_stage:='x_mfc_cost_type_id =>' || lr_mfc_cost_type_id_tbl(1);
1850: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1851: pa_debug.g_err_stage:='x_incurred_by_res_flag =>' || lr_incurred_by_res_flag_tbl(1);
1852: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1853: pa_debug.g_err_stage:='x_incur_by_res_class_code=>' || lr_incur_by_res_class_code_tbl(1);
1854: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1855: pa_debug.g_err_stage:='x_Incur_by_role_id =>' || lr_Incur_by_role_id_tbl(1);
1856: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1854: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1850: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1851: pa_debug.g_err_stage:='x_incurred_by_res_flag =>' || lr_incurred_by_res_flag_tbl(1);
1852: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1853: pa_debug.g_err_stage:='x_incur_by_res_class_code=>' || lr_incur_by_res_class_code_tbl(1);
1854: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1855: pa_debug.g_err_stage:='x_Incur_by_role_id =>' || lr_Incur_by_role_id_tbl(1);
1856: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1857: pa_debug.g_err_stage:='x_org_id =>' || lr_org_id_tbl(1);
1858: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1856: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1852: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1853: pa_debug.g_err_stage:='x_incur_by_res_class_code=>' || lr_incur_by_res_class_code_tbl(1);
1854: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1855: pa_debug.g_err_stage:='x_Incur_by_role_id =>' || lr_Incur_by_role_id_tbl(1);
1856: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1857: pa_debug.g_err_stage:='x_org_id =>' || lr_org_id_tbl(1);
1858: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1859: pa_debug.g_err_stage:='x_rate_based_flag =>' || lr_rate_based_flag_tbl(1);
1860: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1858: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1854: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1855: pa_debug.g_err_stage:='x_Incur_by_role_id =>' || lr_Incur_by_role_id_tbl(1);
1856: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1857: pa_debug.g_err_stage:='x_org_id =>' || lr_org_id_tbl(1);
1858: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1859: pa_debug.g_err_stage:='x_rate_based_flag =>' || lr_rate_based_flag_tbl(1);
1860: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1861: pa_debug.g_err_stage:='x_rate_expenditure_type =>' || lr_rate_expenditure_type_tbl(1);
1862: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1860: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1856: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1857: pa_debug.g_err_stage:='x_org_id =>' || lr_org_id_tbl(1);
1858: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1859: pa_debug.g_err_stage:='x_rate_based_flag =>' || lr_rate_based_flag_tbl(1);
1860: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1861: pa_debug.g_err_stage:='x_rate_expenditure_type =>' || lr_rate_expenditure_type_tbl(1);
1862: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1863: pa_debug.g_err_stage:='x_rate_func_curr_code =>' || lr_rate_func_curr_code_tbl(1);
1864: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 1862: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1858: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1859: pa_debug.g_err_stage:='x_rate_based_flag =>' || lr_rate_based_flag_tbl(1);
1860: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1861: pa_debug.g_err_stage:='x_rate_expenditure_type =>' || lr_rate_expenditure_type_tbl(1);
1862: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1863: pa_debug.g_err_stage:='x_rate_func_curr_code =>' || lr_rate_func_curr_code_tbl(1);
1864: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1865: END IF;
1866:

Line 1864: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1860: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1861: pa_debug.g_err_stage:='x_rate_expenditure_type =>' || lr_rate_expenditure_type_tbl(1);
1862: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1863: pa_debug.g_err_stage:='x_rate_func_curr_code =>' || lr_rate_func_curr_code_tbl(1);
1864: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1865: END IF;
1866:
1867: -- DHI Fix: override currency
1868: R_Res_Assignment_Rec.rate_based_flag := lr_rate_based_flag_tbl(1);

Line 1930: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1926: l_P_named_role := gchar(p_task_assignment_tbl(i).named_role);
1927:
1928: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1929: pa_debug.g_err_stage:='Before validate_planning_resource call in task assignment utils, return status='||x_return_status;
1930: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1931: END IF;
1932:
1933: PA_PLANNING_RESOURCE_UTILS.Validate_Planning_Resource(
1934: P_Task_Name => l_task_name,

Line 1981: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

1977: X_Msg_Count => x_msg_count);
1978:
1979: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
1980: pa_debug.g_err_stage:='After validate_planning_resource, return status='||x_return_status;
1981: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
1982: END IF;
1983:
1984: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1985: RAISE FND_API.G_EXC_ERROR;

Line 2021: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2017: P_task_assignment_tbl(i).resource_class_flag := NULL; --gchar(P_task_assignment_tbl(i).resource_class_flag, 'B');
2018:
2019: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2020: pa_debug.g_err_stage:='X_Resource_List_Member_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id ;
2021: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2022: pa_debug.g_err_stage:='X_Person_Id => ' || i || ' : ' || p_task_assignment_tbl(i).person_id;
2023: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2024: pa_debug.g_err_stage:='X_Bom_Resource_Id => ' || i || ' : ' || p_task_assignment_tbl(i).bom_resource_id;
2025: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2023: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2019: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2020: pa_debug.g_err_stage:='X_Resource_List_Member_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_list_member_id ;
2021: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2022: pa_debug.g_err_stage:='X_Person_Id => ' || i || ' : ' || p_task_assignment_tbl(i).person_id;
2023: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2024: pa_debug.g_err_stage:='X_Bom_Resource_Id => ' || i || ' : ' || p_task_assignment_tbl(i).bom_resource_id;
2025: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2026: pa_debug.g_err_stage:='X_Job_Id => ' || i || ' : ' || p_task_assignment_tbl(i).job_id;
2027: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2025: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2021: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2022: pa_debug.g_err_stage:='X_Person_Id => ' || i || ' : ' || p_task_assignment_tbl(i).person_id;
2023: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2024: pa_debug.g_err_stage:='X_Bom_Resource_Id => ' || i || ' : ' || p_task_assignment_tbl(i).bom_resource_id;
2025: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2026: pa_debug.g_err_stage:='X_Job_Id => ' || i || ' : ' || p_task_assignment_tbl(i).job_id;
2027: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2028: pa_debug.g_err_stage:='X_Person_Type_Code => ' || i || ' : ' || p_task_assignment_tbl(i).person_type_code;
2029: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2027: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2023: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2024: pa_debug.g_err_stage:='X_Bom_Resource_Id => ' || i || ' : ' || p_task_assignment_tbl(i).bom_resource_id;
2025: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2026: pa_debug.g_err_stage:='X_Job_Id => ' || i || ' : ' || p_task_assignment_tbl(i).job_id;
2027: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2028: pa_debug.g_err_stage:='X_Person_Type_Code => ' || i || ' : ' || p_task_assignment_tbl(i).person_type_code;
2029: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2030: pa_debug.g_err_stage:='X_Non_Labor_Resource => ' || i || ' : ' || p_task_assignment_tbl(i).non_labor_resource;
2031: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2029: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2025: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2026: pa_debug.g_err_stage:='X_Job_Id => ' || i || ' : ' || p_task_assignment_tbl(i).job_id;
2027: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2028: pa_debug.g_err_stage:='X_Person_Type_Code => ' || i || ' : ' || p_task_assignment_tbl(i).person_type_code;
2029: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2030: pa_debug.g_err_stage:='X_Non_Labor_Resource => ' || i || ' : ' || p_task_assignment_tbl(i).non_labor_resource;
2031: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2032: pa_debug.g_err_stage:='X_Inventory_Item_Id => ' || i || ' : ' || p_task_assignment_tbl(i).inventory_item_id;
2033: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2031: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2027: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2028: pa_debug.g_err_stage:='X_Person_Type_Code => ' || i || ' : ' || p_task_assignment_tbl(i).person_type_code;
2029: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2030: pa_debug.g_err_stage:='X_Non_Labor_Resource => ' || i || ' : ' || p_task_assignment_tbl(i).non_labor_resource;
2031: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2032: pa_debug.g_err_stage:='X_Inventory_Item_Id => ' || i || ' : ' || p_task_assignment_tbl(i).inventory_item_id;
2033: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2034: pa_debug.g_err_stage:='X_Item_Category_Id => ' || i || ' : ' || p_task_assignment_tbl(i).item_category_id;
2035: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2033: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2029: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2030: pa_debug.g_err_stage:='X_Non_Labor_Resource => ' || i || ' : ' || p_task_assignment_tbl(i).non_labor_resource;
2031: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2032: pa_debug.g_err_stage:='X_Inventory_Item_Id => ' || i || ' : ' || p_task_assignment_tbl(i).inventory_item_id;
2033: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2034: pa_debug.g_err_stage:='X_Item_Category_Id => ' || i || ' : ' || p_task_assignment_tbl(i).item_category_id;
2035: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2036: pa_debug.g_err_stage:='X_Project_Role_Id => ' || i || ' : ' || p_task_assignment_tbl(i).project_role_id;
2037: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2035: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2031: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2032: pa_debug.g_err_stage:='X_Inventory_Item_Id => ' || i || ' : ' || p_task_assignment_tbl(i).inventory_item_id;
2033: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2034: pa_debug.g_err_stage:='X_Item_Category_Id => ' || i || ' : ' || p_task_assignment_tbl(i).item_category_id;
2035: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2036: pa_debug.g_err_stage:='X_Project_Role_Id => ' || i || ' : ' || p_task_assignment_tbl(i).project_role_id;
2037: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2038: pa_debug.g_err_stage:='X_Organization_Id => ' || i || ' : ' || p_task_assignment_tbl(i).organization_id;
2039: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2037: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2033: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2034: pa_debug.g_err_stage:='X_Item_Category_Id => ' || i || ' : ' || p_task_assignment_tbl(i).item_category_id;
2035: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2036: pa_debug.g_err_stage:='X_Project_Role_Id => ' || i || ' : ' || p_task_assignment_tbl(i).project_role_id;
2037: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2038: pa_debug.g_err_stage:='X_Organization_Id => ' || i || ' : ' || p_task_assignment_tbl(i).organization_id;
2039: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2040: pa_debug.g_err_stage:='X_Expenditure_Type => ' || i || ' : ' || p_task_assignment_tbl(i).expenditure_type;
2041: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2039: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2035: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2036: pa_debug.g_err_stage:='X_Project_Role_Id => ' || i || ' : ' || p_task_assignment_tbl(i).project_role_id;
2037: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2038: pa_debug.g_err_stage:='X_Organization_Id => ' || i || ' : ' || p_task_assignment_tbl(i).organization_id;
2039: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2040: pa_debug.g_err_stage:='X_Expenditure_Type => ' || i || ' : ' || p_task_assignment_tbl(i).expenditure_type;
2041: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2042: pa_debug.g_err_stage:='X_Expenditure_Category => ' || i || ' : ' || p_task_assignment_tbl(i).expenditure_category;
2043: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2041: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2037: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2038: pa_debug.g_err_stage:='X_Organization_Id => ' || i || ' : ' || p_task_assignment_tbl(i).organization_id;
2039: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2040: pa_debug.g_err_stage:='X_Expenditure_Type => ' || i || ' : ' || p_task_assignment_tbl(i).expenditure_type;
2041: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2042: pa_debug.g_err_stage:='X_Expenditure_Category => ' || i || ' : ' || p_task_assignment_tbl(i).expenditure_category;
2043: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2044: pa_debug.g_err_stage:='X_Event_Type => ' || i || ' : ' || p_task_assignment_tbl(i).event_type;
2045: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2043: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2039: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2040: pa_debug.g_err_stage:='X_Expenditure_Type => ' || i || ' : ' || p_task_assignment_tbl(i).expenditure_type;
2041: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2042: pa_debug.g_err_stage:='X_Expenditure_Category => ' || i || ' : ' || p_task_assignment_tbl(i).expenditure_category;
2043: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2044: pa_debug.g_err_stage:='X_Event_Type => ' || i || ' : ' || p_task_assignment_tbl(i).event_type;
2045: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2046: pa_debug.g_err_stage:='X_Revenue_Category_Code => ' || i || ' : ' || p_task_assignment_tbl(i).revenue_category_code;
2047: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2045: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2041: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2042: pa_debug.g_err_stage:='X_Expenditure_Category => ' || i || ' : ' || p_task_assignment_tbl(i).expenditure_category;
2043: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2044: pa_debug.g_err_stage:='X_Event_Type => ' || i || ' : ' || p_task_assignment_tbl(i).event_type;
2045: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2046: pa_debug.g_err_stage:='X_Revenue_Category_Code => ' || i || ' : ' || p_task_assignment_tbl(i).revenue_category_code;
2047: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2048: pa_debug.g_err_stage:='X_Supplier_Id => ' || i || ' : ' || p_task_assignment_tbl(i).supplier_id;
2049: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2047: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2043: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2044: pa_debug.g_err_stage:='X_Event_Type => ' || i || ' : ' || p_task_assignment_tbl(i).event_type;
2045: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2046: pa_debug.g_err_stage:='X_Revenue_Category_Code => ' || i || ' : ' || p_task_assignment_tbl(i).revenue_category_code;
2047: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2048: pa_debug.g_err_stage:='X_Supplier_Id => ' || i || ' : ' || p_task_assignment_tbl(i).supplier_id;
2049: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2050: pa_debug.g_err_stage:='X_Resource_Class_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_class_id;
2051: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2049: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2045: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2046: pa_debug.g_err_stage:='X_Revenue_Category_Code => ' || i || ' : ' || p_task_assignment_tbl(i).revenue_category_code;
2047: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2048: pa_debug.g_err_stage:='X_Supplier_Id => ' || i || ' : ' || p_task_assignment_tbl(i).supplier_id;
2049: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2050: pa_debug.g_err_stage:='X_Resource_Class_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_class_id;
2051: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2052: pa_debug.g_err_stage:='X_Incur_By_Role_Id => ' || i || ' : ' || p_task_assignment_tbl(i).incur_by_role_id;
2053: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2051: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2047: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2048: pa_debug.g_err_stage:='X_Supplier_Id => ' || i || ' : ' || p_task_assignment_tbl(i).supplier_id;
2049: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2050: pa_debug.g_err_stage:='X_Resource_Class_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_class_id;
2051: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2052: pa_debug.g_err_stage:='X_Incur_By_Role_Id => ' || i || ' : ' || p_task_assignment_tbl(i).incur_by_role_id;
2053: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2054: pa_debug.g_err_stage:='X_Incur_By_Res_Class_Code => ' || i || ' : ' || p_task_assignment_tbl(i).incur_by_res_class_code;
2055: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2053: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2049: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2050: pa_debug.g_err_stage:='X_Resource_Class_Id => ' || i || ' : ' || p_task_assignment_tbl(i).resource_class_id;
2051: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2052: pa_debug.g_err_stage:='X_Incur_By_Role_Id => ' || i || ' : ' || p_task_assignment_tbl(i).incur_by_role_id;
2053: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2054: pa_debug.g_err_stage:='X_Incur_By_Res_Class_Code => ' || i || ' : ' || p_task_assignment_tbl(i).incur_by_res_class_code;
2055: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2056: pa_debug.g_err_stage:='X_Incur_By_Res_Flag => ' || i || ' : ' || p_task_assignment_tbl(i).incurred_by_res_flag;
2057: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2055: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2051: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2052: pa_debug.g_err_stage:='X_Incur_By_Role_Id => ' || i || ' : ' || p_task_assignment_tbl(i).incur_by_role_id;
2053: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2054: pa_debug.g_err_stage:='X_Incur_By_Res_Class_Code => ' || i || ' : ' || p_task_assignment_tbl(i).incur_by_res_class_code;
2055: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2056: pa_debug.g_err_stage:='X_Incur_By_Res_Flag => ' || i || ' : ' || p_task_assignment_tbl(i).incurred_by_res_flag;
2057: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2058: pa_debug.g_err_stage:='X_Resource_Class_Flag => ' || i || ' : ' || p_task_assignment_tbl(i).resource_class_flag;
2059: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2057: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2053: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2054: pa_debug.g_err_stage:='X_Incur_By_Res_Class_Code => ' || i || ' : ' || p_task_assignment_tbl(i).incur_by_res_class_code;
2055: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2056: pa_debug.g_err_stage:='X_Incur_By_Res_Flag => ' || i || ' : ' || p_task_assignment_tbl(i).incurred_by_res_flag;
2057: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2058: pa_debug.g_err_stage:='X_Resource_Class_Flag => ' || i || ' : ' || p_task_assignment_tbl(i).resource_class_flag;
2059: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2060: pa_debug.g_err_stage:='X_Return_Status => ' || i || ' : ' || x_return_status;
2061: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2059: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2055: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2056: pa_debug.g_err_stage:='X_Incur_By_Res_Flag => ' || i || ' : ' || p_task_assignment_tbl(i).incurred_by_res_flag;
2057: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2058: pa_debug.g_err_stage:='X_Resource_Class_Flag => ' || i || ' : ' || p_task_assignment_tbl(i).resource_class_flag;
2059: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2060: pa_debug.g_err_stage:='X_Return_Status => ' || i || ' : ' || x_return_status;
2061: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2062: END IF;
2063:

Line 2061: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2057: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2058: pa_debug.g_err_stage:='X_Resource_Class_Flag => ' || i || ' : ' || p_task_assignment_tbl(i).resource_class_flag;
2059: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2060: pa_debug.g_err_stage:='X_Return_Status => ' || i || ' : ' || x_return_status;
2061: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2062: END IF;
2063:
2064: END IF;
2065:

Line 2068: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2064: END IF;
2065:
2066: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2067: pa_debug.g_err_stage:='B4 Validate Fin Cat for WP: ' || L_FuncProc || ':return_status:' || x_return_status;
2068: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2069: END IF;
2070:
2071: IF Validate_Fin_Cat_For_WP(p_task_assignment_tbl(i).fc_res_type_code ) <> 'Y' THEN
2072: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2077: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2073: END IF;
2074:
2075: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2076: pa_debug.g_err_stage:='B4 Validate Pl_Res_For_WP: ' || L_FuncProc || ':return_status:' || x_return_status;
2077: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2078: END IF;
2079:
2080: IF Validate_Pl_Res_For_WP(p_task_assignment_tbl(i).resource_list_member_id) <> 'Y' THEN
2081: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2086: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2082: END IF;
2083:
2084: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2085: pa_debug.g_err_stage:='After Validate Pl_Res_For_WP: ' || L_FuncProc || ':return_status:' || x_return_status;
2086: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2087: END IF;
2088:
2089: --2. Schedule Information
2090: --Validate the assignment Scheduled Dates:

Line 2193: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2189: END IF;
2190:
2191: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2192: pa_debug.g_err_stage:='l_actual_start_date => ' || l_actual_start_date;
2193: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2194: pa_debug.g_err_stage:='l_actual_end_date => ' || l_actual_end_date;
2195: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2196: pa_debug.g_err_stage:='schedule_start_date => ' || p_task_assignment_tbl(i).schedule_start_date;
2197: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2195: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2191: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2192: pa_debug.g_err_stage:='l_actual_start_date => ' || l_actual_start_date;
2193: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2194: pa_debug.g_err_stage:='l_actual_end_date => ' || l_actual_end_date;
2195: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2196: pa_debug.g_err_stage:='schedule_start_date => ' || p_task_assignment_tbl(i).schedule_start_date;
2197: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2198: pa_debug.g_err_stage:='schedule_end_date => ' || p_task_assignment_tbl(i).schedule_end_date;
2199: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

Line 2197: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2193: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2194: pa_debug.g_err_stage:='l_actual_end_date => ' || l_actual_end_date;
2195: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2196: pa_debug.g_err_stage:='schedule_start_date => ' || p_task_assignment_tbl(i).schedule_start_date;
2197: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2198: pa_debug.g_err_stage:='schedule_end_date => ' || p_task_assignment_tbl(i).schedule_end_date;
2199: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2200: END IF;
2201:

Line 2199: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2195: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2196: pa_debug.g_err_stage:='schedule_start_date => ' || p_task_assignment_tbl(i).schedule_start_date;
2197: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2198: pa_debug.g_err_stage:='schedule_end_date => ' || p_task_assignment_tbl(i).schedule_end_date;
2199: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2200: END IF;
2201:
2202: IF (l_actual_start_date IS NULL) OR (p_task_assignment_tbl(i).schedule_start_date <= l_actual_start_date) THEN
2203: p_task_assignment_tbl(i).planning_start_date := p_task_assignment_tbl(i).schedule_start_date;

Line 2263: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2259: END IF;
2260:
2261: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2262: pa_debug.g_err_stage:='After Progress violation checks: l_viol_indicator' || l_viol_indicator;
2263: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2264: END IF;
2265:
2266: IF l_viol_indicator is not null THEN
2267: -- override currency must goes with override raw cost rate for rate-based asgmts

Line 2323: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2319: END IF;
2320:
2321: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2322: pa_debug.g_err_stage:='End of TA:Validate_Update_Assignment';
2323: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2324: END IF;
2325:
2326: EXCEPTION
2327:

Line 2489: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2485: L_FuncProc := 'Validate_Delete_Assignment';
2486:
2487: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2488: pa_debug.g_err_stage:='Beginning of TA:Validate_Delete_Assignment';
2489: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2490: END IF;
2491:
2492: x_delete_task_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
2493: x_delete_asgmt_flag_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();

Line 2758: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

2754: END IF;
2755:
2756: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
2757: pa_debug.g_err_stage:='End of TA:Validate_Delete_Assignment';
2758: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
2759: END IF;
2760:
2761: EXCEPTION
2762:

Line 3473: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

3469: PA_DEBUG.write(x_module => L_Module, x_msg => 'l_target_budget_version_id: ' || l_target_budget_version_id, x_log_level => 3);
3470: PA_DEBUG.write(x_module => L_Module, x_msg => 'l_target_track_workplan_costs_flag: ' || l_target_workplan_costs_flag, x_log_level => 3);
3471:
3472: pa_debug.g_err_stage:='Beginning of TA: ' || L_FuncProc;
3473: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
3474: END IF;
3475:
3476:
3477:

Line 3517: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

3513: END IF;
3514:
3515: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
3516: pa_debug.g_err_stage:= 'TA: ' || L_FuncProc || ' class1: ' || l_res_class1 || ' 2:' || l_res_class2 || ' 3: ' || l_res_class3 || ' 4: ' || l_res_class4;
3517: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
3518: END IF;
3519:
3520: IF p_src_elem_ver_id_tbl IS NOT NULL THEN
3521:

Line 3596: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

3592: IF l_ta_resource_assgt_tbl.COUNT > 0 THEN
3593:
3594: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
3595: pa_debug.g_err_stage:='TA: ' || L_FuncProc || ' Res assgt. count ' || l_ta_resource_assgt_tbl.COUNT;
3596: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
3597: END IF;
3598:
3599: l_index := 0;
3600: l_previous_elem_version_id := l_ta_wbs_elem_ver_tbl(1);

Line 4171: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4167: l_c_res_mem_id_tbl := system.pa_num_tbl_type();
4168:
4169: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4170: pa_debug.g_err_stage:='TA: ' || L_FuncProc || ' b4 copy planning resources.';
4171: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4172: END IF;
4173:
4174: -- CASE 1: Copy External
4175: -- call Copy_Planning_Resource

Line 4237: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4233:
4234: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4235:
4236: pa_debug.g_err_stage:='TA: ' || L_FuncProc || ' a4 calling copy planning resources.';
4237: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4238:
4239: FOR temp_i IN 1..l_c_res_mem_id_tbl.COUNT LOOP
4240: PA_DEBUG.write(x_module => L_Module,
4241: x_msg => 'l_c_res_mem_id_tbl(' || temp_i || '): ' || l_c_res_mem_id_tbl(temp_i),

Line 4272: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4268: -- Bug 3745338, disallow copy of TR if the resource list member has changed.
4269: -- Bug 4097749 - Do not copy project_assignment_id if copying to another project,
4270: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4271: pa_debug.g_err_stage:='TA: ' || L_FuncProc || 'l_ta_tr_res_list_member_id_tbl(i): ' || l_ta_tr_res_list_member_id_tbl(i);
4272: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4273: pa_debug.g_err_stage:='TA: ' || L_FuncProc || 'l_c_res_mem_id_tbl(1): ' || l_c_res_mem_id_tbl(1);
4274: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4275: END IF;
4276:

Line 4274: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4270: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4271: pa_debug.g_err_stage:='TA: ' || L_FuncProc || 'l_ta_tr_res_list_member_id_tbl(i): ' || l_ta_tr_res_list_member_id_tbl(i);
4272: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4273: pa_debug.g_err_stage:='TA: ' || L_FuncProc || 'l_c_res_mem_id_tbl(1): ' || l_c_res_mem_id_tbl(1);
4274: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4275: END IF;
4276:
4277: IF l_ta_tr_res_list_member_id_tbl(i) <> l_c_res_mem_id_tbl(1) OR
4278: p_src_project_id <> p_target_project_id THEN

Line 4319: IF nvl(PA_TASK_ASSIGNMENT_UTILS.g_process_flow,'XYZ') <> 'PUBLISH' THEN

4315:
4316: -- Bug 4646016 : In Copy Assignments flow from one version to other
4317: -- we should make plan as 0 if it is -ve
4318: -- Begin
4319: IF nvl(PA_TASK_ASSIGNMENT_UTILS.g_process_flow,'XYZ') <> 'PUBLISH' THEN
4320: IF l_ta_rate_based_flag_tbl(i) = 'N' THEN
4321: IF x_resource_rec_tbl(l_index).total_quantity < 0 THEN
4322: x_resource_rec_tbl(l_index).total_quantity := 0;
4323: x_resource_rec_tbl(l_index).total_raw_cost := 0;

Line 4358: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4354: IF p_src_project_id <> p_target_project_id THEN
4355:
4356: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4357: pa_debug.g_err_stage:='TA: ' || L_FuncProc || ' Src project N.E. to target ' ;
4358: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4359: END IF;
4360:
4361:
4362: --Get the task scheduled dates of all tasks in p_src_version_id_tbl

Line 4423: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4419:
4420:
4421: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4422: pa_debug.g_err_stage:='TA: ' || L_FuncProc || ' adjusting dates here ' ;
4423: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4424: END IF;
4425:
4426: x_calculate_flag := 'Y';
4427:

Line 4452: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4448: END IF;
4449:
4450: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4451: pa_debug.g_err_stage:= 'TA: ' || L_FuncProc || ' Returned count on adjust: ' || l_c_resource_assgt_tbl.COUNT ;
4452: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4453: END IF;
4454:
4455: FOR i in 1..x_resource_rec_tbl.COUNT LOOP
4456:

Line 4615: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4611: END IF;
4612:
4613: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4614: pa_debug.g_err_stage:='TA: ' || L_FuncProc || 'Add_Planning_Transactions return status: ' || x_return_status;
4615: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4616: END IF;
4617: END IF; -- IF l_add_res_list_member_id_tbl.COUNT > 0 THEN
4618: -- End of Bug 4200146
4619:

Line 4706: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4702: END LOOP; -- FOR temp_i IN 1..x_resource_rec_tbl.COUNT LOOP
4703:
4704:
4705: pa_debug.g_err_stage:='End of TA: ' || L_FuncProc;
4706: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4707:
4708: END IF;
4709:
4710: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN

Line 4712: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4708: END IF;
4709:
4710: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4711: pa_debug.g_err_stage:= 'x_calculate_flag :=' || x_calculate_flag;
4712: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4713: END IF;
4714:
4715: -- should clear this temporary table after being used since the table will be
4716: -- reused in adjust_asgmt_date right away in the same session in publishing flow.

Line 4790: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4786:
4787:
4788: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4789: pa_debug.g_err_stage:='Entering: ' || L_FuncProc;
4790: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4791: END IF;
4792:
4793:
4794: IF p_resource_list_member_id is NOT NULL AND

Line 4800: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4796:
4797:
4798: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4799: pa_debug.g_err_stage:='B4 query : ' || L_FuncProc;
4800: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4801: END IF;
4802:
4803:
4804: OPEN C_Pl_Check(p_resource_list_member_id);

Line 4812: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4808:
4809:
4810: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4811: pa_debug.g_err_stage:='A4 Query: ' || L_FuncProc;
4812: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4813: END IF;
4814:
4815:
4816: IF R_Pl_Check.res_type in ('REVENUE_CATEGORY', 'EVENT_TYPE') THEN

Line 4838: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4834: );
4835:
4836: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4837: pa_debug.g_err_stage:='Wrong Res type: ' || L_FuncProc;
4838: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4839: END IF;
4840:
4841: RETURN 'N';
4842:

Line 4855: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4851: RETURN 'Y';
4852:
4853: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4854: pa_debug.g_err_stage:='End of TA: ' || L_FuncProc;
4855: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4856: END IF;
4857:
4858: EXCEPTION
4859:

Line 4930: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4926:
4927:
4928: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4929: pa_debug.g_err_stage:='Entering: ' || L_FuncProc;
4930: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4931: END IF;
4932:
4933:
4934: IF p_fc_res_type_code is NOT NULL AND

Line 4978: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

4974: RETURN 'Y';
4975:
4976: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
4977: pa_debug.g_err_stage:='End of TA: ' || L_FuncProc;
4978: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
4979: END IF;
4980:
4981: EXCEPTION
4982:

Line 5121: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

5117: L_FuncProc := 'Check_Edit_Task_Ok';
5118:
5119: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5120: pa_debug.g_err_stage:='Entering: ' || L_FuncProc;
5121: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
5122: END IF;
5123:
5124: IF P_structure_version_id is null or
5125: P_Project_Id is null THEN

Line 5156: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

5152: ) ;
5153:
5154: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5155: pa_debug.g_err_stage:='g_apply_progress_flag='||g_apply_progress_flag;
5156: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
5157: END IF;
5158:
5159: IF L_Status = 'N' then
5160:

Line 5174: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

5170: ELSE
5171:
5172: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5173: pa_debug.g_err_stage:='check process update';
5174: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
5175: END IF;
5176:
5177: M_Status := PA_PROJECT_STRUCTURE_UTILS.GET_UPDATE_WBS_FLAG(
5178: P_PROJECT_ID => l_project_id,

Line 5244: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);

5240: END IF;
5241:
5242: IF P_DEBUG_MODE = 'Y' AND (li_curr_level <= 3) THEN
5243: pa_debug.g_err_stage:='End of TA: ' || L_FuncProc;
5244: pa_debug.write('PA_TASK_ASSIGNMENT_UTILS',pa_debug.g_err_stage,3);
5245: END IF;
5246:
5247: EXCEPTION
5248:

Line 5486: return pa_task_assignment_utils.p_assignment_effort;

5482:
5483: FUNCTION Get_Assignment_Effort
5484: RETURN NUMBER IS
5485: begin
5486: return pa_task_assignment_utils.p_assignment_effort;
5487: exception when others then
5488: return pa_task_assignment_utils.p_assignment_effort;
5489: end;
5490:

Line 5488: return pa_task_assignment_utils.p_assignment_effort;

5484: RETURN NUMBER IS
5485: begin
5486: return pa_task_assignment_utils.p_assignment_effort;
5487: exception when others then
5488: return pa_task_assignment_utils.p_assignment_effort;
5489: end;
5490:
5491: FUNCTION Get_Team_Role(p_resource_list_member_id IN NUMBER default NULL, p_project_id IN NUMBER default NULL)
5492:

Line 5525: PA_TASK_ASSIGNMENT_UTILS.p_multi_asgmt_req_flag := 'N';

5521:
5522:
5523: BEGIN
5524:
5525: PA_TASK_ASSIGNMENT_UTILS.p_multi_asgmt_req_flag := 'N';
5526: pa_task_assignment_utils.p_assignment_effort := to_number(NULL);
5527:
5528:
5529: IF p_resource_list_member_id IS NOT NULL THEN

Line 5526: pa_task_assignment_utils.p_assignment_effort := to_number(NULL);

5522:
5523: BEGIN
5524:
5525: PA_TASK_ASSIGNMENT_UTILS.p_multi_asgmt_req_flag := 'N';
5526: pa_task_assignment_utils.p_assignment_effort := to_number(NULL);
5527:
5528:
5529: IF p_resource_list_member_id IS NOT NULL THEN
5530:

Line 5538: pa_task_assignment_utils.p_assignment_effort := C_Team_Role_rec.assignment_effort;

5534:
5535:
5536:
5537: L_Team_Role := C_Team_Role_rec.team_role;
5538: pa_task_assignment_utils.p_assignment_effort := C_Team_Role_rec.assignment_effort;
5539:
5540:
5541: WHILE C_Team_Role%FOUND
5542:

Line 5554: PA_TASK_ASSIGNMENT_UTILS.p_multi_asgmt_req_flag := 'Y'; /* Added for bug ???? */

5550:
5551: IF C_Team_Role%FOUND THEN
5552:
5553: L_Team_Role := L_Team_Role || ',' || C_Team_Role_rec.team_role;
5554: PA_TASK_ASSIGNMENT_UTILS.p_multi_asgmt_req_flag := 'Y'; /* Added for bug ???? */
5555: pa_task_assignment_utils.p_assignment_effort := pa_task_assignment_utils.p_assignment_effort + C_Team_Role_rec.assignment_effort;
5556:
5557:
5558: END IF;

Line 5555: pa_task_assignment_utils.p_assignment_effort := pa_task_assignment_utils.p_assignment_effort + C_Team_Role_rec.assignment_effort;

5551: IF C_Team_Role%FOUND THEN
5552:
5553: L_Team_Role := L_Team_Role || ',' || C_Team_Role_rec.team_role;
5554: PA_TASK_ASSIGNMENT_UTILS.p_multi_asgmt_req_flag := 'Y'; /* Added for bug ???? */
5555: pa_task_assignment_utils.p_assignment_effort := pa_task_assignment_utils.p_assignment_effort + C_Team_Role_rec.assignment_effort;
5556:
5557:
5558: END IF;
5559:

Line 6428: g_module_name VARCHAR2(30) := 'PA_TASK_ASSIGNMENT_UTILS';

6424: l_debug_level3 CONSTANT NUMBER := 3;
6425: l_debug_level4 CONSTANT NUMBER := 4;
6426: l_debug_level5 CONSTANT NUMBER := 5;
6427:
6428: g_module_name VARCHAR2(30) := 'PA_TASK_ASSIGNMENT_UTILS';
6429:
6430: l_module_name VARCHAR2(80) := 'PA_PM_UPDATE_TASK_ASSIGNMENT';
6431:
6432: l_struct_elem_version_id NUMBER;

Line 6490: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Printing Input parameters';

6486: END IF;
6487:
6488: --Print All Input Params
6489: IF l_debug_mode = 'Y' THEN
6490: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Printing Input parameters';
6491: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
6492: l_debug_level3);
6493:
6494: Pa_Debug.WRITE(g_module_name,'p_project_id'||':'||p_project_id,

Line 6506: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: UPDATE_TASK_ASSIGNMENT';

6502: -- As part of enforcing project security, which would determine
6503: -- whether the user has the necessary privileges to update the project
6504: -- need to call the pa_security package
6505: IF l_debug_mode = 'Y' THEN
6506: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: UPDATE_TASK_ASSIGNMENT';
6507: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6508: END IF;
6509: pa_security.initialize (X_user_id => l_user_id,
6510: X_calling_module => l_module_name);

Line 6554: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: UPDATE_TASK_ASSIGNMENT: Suceess';

6550: x_return_status := FND_API.G_RET_STS_ERROR;
6551: RAISE FND_API.G_EXC_ERROR;
6552: END IF;
6553: IF l_debug_mode = 'Y' THEN
6554: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: UPDATE_TASK_ASSIGNMENT: Suceess';
6555: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6556: END IF;
6557: -- Now verify whether project security allows the user to update
6558: -- the project

Line 6564: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Update/Query Project';

6560: -- Hence, cannot update the project.Raise error
6561: -- If the user has query privileges, then check whether
6562: -- update privileges are also available
6563: IF l_debug_mode = 'Y' THEN
6564: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Update/Query Project';
6565: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6566: END IF;
6567:
6568: IF pa_security.allow_query(x_project_id => p_project_id ) = 'N'

Line 6587: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Update/Query Project: Success';

6583: x_return_status := FND_API.G_RET_STS_ERROR;
6584: RAISE FND_API.G_EXC_ERROR;
6585: END IF;
6586: IF l_debug_mode = 'Y' THEN
6587: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Update/Query Project: Success';
6588: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6589:
6590: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Validating Str Version';
6591: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);

Line 6590: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Validating Str Version';

6586: IF l_debug_mode = 'Y' THEN
6587: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Update/Query Project: Success';
6588: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6589:
6590: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Validating Str Version';
6591: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6592: END IF;
6593: IF NVL(PA_PROJ_TASK_STRUC_PUB.WP_STR_EXISTS( p_project_id ), 'N') = 'N' THEN
6594: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 6644: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Validating Str/budget Version: Success';

6640: CLOSE C_Get_Budget_Version_Id;
6641: END IF;
6642:
6643: IF l_debug_mode = 'Y' THEN
6644: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Validating Str/budget Version: Success';
6645: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6646: END IF;
6647: --Get Current Working Version Id
6648: l_curr_working_version := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(

Line 6651: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Calling Check_edit_ok';

6647: --Get Current Working Version Id
6648: l_curr_working_version := PA_PROJECT_STRUCTURE_UTILS.get_current_working_ver_id(
6649: p_project_id => p_project_id);
6650: IF l_debug_mode = 'Y' THEN
6651: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Calling Check_edit_ok';
6652: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6653: END IF;
6654: IF 'N' = pa_task_assignment_utils.check_edit_task_ok
6655: ( P_PROJECT_ID => p_project_id,

Line 6654: IF 'N' = pa_task_assignment_utils.check_edit_task_ok

6650: IF l_debug_mode = 'Y' THEN
6651: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Checking Security: Calling Check_edit_ok';
6652: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6653: END IF;
6654: IF 'N' = pa_task_assignment_utils.check_edit_task_ok
6655: ( P_PROJECT_ID => p_project_id,
6656: P_STRUCTURE_VERSION_ID => l_struct_elem_version_id,
6657: P_CURR_STRUCT_VERSION_ID => l_curr_working_version) THEN
6658: -- Bug 4533152

Line 6667: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Calling Check_edit_ok: Success';

6663: x_return_status := FND_API.G_RET_STS_ERROR;
6664: RAISE FND_API.G_EXC_ERROR;
6665: END IF;
6666: IF l_debug_mode = 'Y' THEN
6667: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Calling Check_edit_ok: Success';
6668: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6669: END IF;
6670:
6671: IF ( l_budget_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM OR

Line 6687: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Check_edit_ok: Budget Version Id'||l_budget_version_id;

6683: ELSE
6684: px_budget_version_id := l_budget_version_id;
6685: END IF;
6686: IF l_debug_mode = 'Y' THEN
6687: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Check_edit_ok: Budget Version Id'||l_budget_version_id;
6688: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6689:
6690: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Check_edit_ok: End';
6691: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);

Line 6690: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Check_edit_ok: End';

6686: IF l_debug_mode = 'Y' THEN
6687: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Check_edit_ok: Budget Version Id'||l_budget_version_id;
6688: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6689:
6690: Pa_Debug.g_err_stage:= 'PA_TASK_ASSIGNMENT_UTILS :CHECK_EDIT_OK: Check_edit_ok: End';
6691: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,l_debug_level3);
6692: END IF;
6693:
6694: EXCEPTION

Line 6755: ( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS'

6751: CLOSE C_validate_Budget_Version_Id;
6752: END IF;
6753:
6754: Fnd_Msg_Pub.add_exc_msg
6755: ( p_pkg_name => 'PA_TASK_ASSIGNMENT_UTILS'
6756: , p_procedure_name => 'CHECK_EDIT_OK'
6757: , p_error_text => x_msg_data);
6758:
6759: IF l_debug_mode = 'Y' THEN

Line 6838: l_resource_list_id := pa_task_assignment_utils.get_wp_resource_list_id(p_project_id);

6834: BEGIN
6835: l_resource_list_id := p_resource_list_id;
6836:
6837: IF l_resource_list_id IS NULL THEN
6838: l_resource_list_id := pa_task_assignment_utils.get_wp_resource_list_id(p_project_id);
6839: END IF;
6840:
6841: OPEN get_uncat_flag(l_resource_list_id);
6842: FETCH get_uncat_flag INTO l_uncat_flag;

Line 6850: END PA_TASK_ASSIGNMENT_UTILS;

6846:
6847: END is_uncategorized_res_list;
6848: /* End for bug 6023345*/
6849:
6850: END PA_TASK_ASSIGNMENT_UTILS;
6851: