[Home] [Help]
217:
218: -- end hyau Bug 2852753
219:
220: BEGIN
221: pa_debug.init_err_stack ('PA_TASK_PUB1.CREATE_TASK');
222:
223: IF (p_debug_mode = 'Y') THEN
224: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK begin');
225: END IF;
220: BEGIN
221: pa_debug.init_err_stack ('PA_TASK_PUB1.CREATE_TASK');
222:
223: IF (p_debug_mode = 'Y') THEN
224: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK begin');
225: END IF;
226:
227: IF (p_commit = FND_API.G_TRUE) THEN
228: savepoint create_Task;
610: COMMIT;
611: END IF;
612:
613: IF (p_debug_mode = 'Y') THEN
614: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK END');
615: END IF;
616: EXCEPTION
617: when FND_API.G_EXC_ERROR then
618: if p_commit = FND_API.G_TRUE then
897: BEGIN
898:
899: --dbms_output.put_line( 'Entered ' );
900:
901: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK');
902:
903: IF (p_debug_mode = 'Y') THEN
904: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK begin');
905: END IF;
900:
901: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK');
902:
903: IF (p_debug_mode = 'Y') THEN
904: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK begin');
905: END IF;
906:
907: IF (p_commit = FND_API.G_TRUE) THEN
908: savepoint update_Task;
1506: COMMIT;
1507: END IF;
1508:
1509: IF (p_debug_mode = 'Y') THEN
1510: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK END');
1511: END IF;
1512: EXCEPTION
1513: when FND_API.G_EXC_ERROR then
1514: if p_commit = FND_API.G_TRUE then
1630: l_carrying_out_org_id NUMBER;
1631: l_task_manager_id NUMBER;
1632: BEGIN
1633:
1634: pa_debug.init_err_stack ('PA_TASK_PUB1.CREATE_TASK_VERSION');
1635:
1636: IF (p_debug_mode = 'Y') THEN
1637: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION begin');
1638: END IF;
1633:
1634: pa_debug.init_err_stack ('PA_TASK_PUB1.CREATE_TASK_VERSION');
1635:
1636: IF (p_debug_mode = 'Y') THEN
1637: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION begin');
1638: END IF;
1639:
1640: IF (p_commit = FND_API.G_TRUE) THEN
1641: savepoint create_Task_version;
1718: COMMIT;
1719: END IF;
1720:
1721: IF (p_debug_mode = 'Y') THEN
1722: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_TASK_VERSION END');
1723: END IF;
1724: EXCEPTION
1725: when FND_API.G_EXC_ERROR then
1726: if p_commit = FND_API.G_TRUE then
1842: --l_carrying_out_org_id NUMBER;
1843: --l_task_manager_id NUMBER;
1844: BEGIN
1845:
1846: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK_VERSION');
1847:
1848: IF (p_debug_mode = 'Y') THEN
1849: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_VERSION begin');
1850: END IF;
1845:
1846: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK_VERSION');
1847:
1848: IF (p_debug_mode = 'Y') THEN
1849: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_VERSION begin');
1850: END IF;
1851:
1852: IF (p_commit = FND_API.G_TRUE) THEN
1853: savepoint update_Task_version;
1972: COMMIT;
1973: END IF;
1974:
1975: IF (p_debug_mode = 'Y') THEN
1976: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_VERSION END');
1977: END IF;
1978: EXCEPTION
1979: when FND_API.G_EXC_ERROR then
1980: if p_commit = FND_API.G_TRUE then
2175:
2176:
2177: BEGIN
2178:
2179: pa_debug.init_err_stack ('PA_TASK_PUB1.DELETE_TASK_VERSION');
2180:
2181: IF (p_debug_mode = 'Y') THEN
2182: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_VERSION begin');
2183: END IF;
2178:
2179: pa_debug.init_err_stack ('PA_TASK_PUB1.DELETE_TASK_VERSION');
2180:
2181: IF (p_debug_mode = 'Y') THEN
2182: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_VERSION begin');
2183: END IF;
2184:
2185: IF (p_commit = FND_API.G_TRUE) THEN
2186: savepoint delete_Task_version;
2536: COMMIT;
2537: END IF;
2538:
2539: IF (p_debug_mode = 'Y') THEN
2540: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_VERSION END');
2541: END IF;
2542: EXCEPTION
2543: when FND_API.G_EXC_ERROR then
2544: if p_commit = FND_API.G_TRUE then
2681: l_data VARCHAR2(250);
2682: l_msg_index_out NUMBER;
2683: l_error_msg_code VARCHAR2(250);
2684: BEGIN
2685: pa_debug.init_err_stack ('PA_TASK_PUB1.create_schedule_VERSION');
2686:
2687: IF (p_debug_mode = 'Y') THEN
2688: pa_debug.debug('PA_TASK_PUB1.CREATE_SCHEDULE_VERSION begin');
2689: END IF;
2684: BEGIN
2685: pa_debug.init_err_stack ('PA_TASK_PUB1.create_schedule_VERSION');
2686:
2687: IF (p_debug_mode = 'Y') THEN
2688: pa_debug.debug('PA_TASK_PUB1.CREATE_SCHEDULE_VERSION begin');
2689: END IF;
2690:
2691: IF (p_commit = FND_API.G_TRUE) THEN
2692: savepoint create_schedule_version;
2783: COMMIT;
2784: END IF;
2785:
2786: IF (p_debug_mode = 'Y') THEN
2787: pa_debug.debug('PA_TASK_PUB1.CREATE_SCHEDULE_VERSION END');
2788: END IF;
2789: EXCEPTION
2790: when FND_API.G_EXC_ERROR then
2791: if p_commit = FND_API.G_TRUE then
2984: -- end hyau Bug 2852753
2985:
2986: BEGIN
2987:
2988: pa_debug.init_err_stack ('PA_TASK_PUB1.update_schedule_VERSION');
2989:
2990: IF (p_debug_mode = 'Y') THEN
2991: pa_debug.debug('PA_TASK_PUB1.update_SCHEDULE_VERSION begin');
2992: END IF;
2987:
2988: pa_debug.init_err_stack ('PA_TASK_PUB1.update_schedule_VERSION');
2989:
2990: IF (p_debug_mode = 'Y') THEN
2991: pa_debug.debug('PA_TASK_PUB1.update_SCHEDULE_VERSION begin');
2992: END IF;
2993:
2994: IF (p_commit = FND_API.G_TRUE) THEN
2995: savepoint update_schedule_version;
3242: COMMIT;
3243: END IF;
3244:
3245: IF (p_debug_mode = 'Y') THEN
3246: pa_debug.debug('PA_TASK_PUB1.UPDATE_SCHEDULE_VERSION END');
3247: END IF;
3248: EXCEPTION
3249: when FND_API.G_EXC_ERROR then
3250: if p_commit = FND_API.G_TRUE then
3862: is_diff_calculated boolean := false;
3863: -- 12931302 end
3864:
3865: BEGIN
3866: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASK');
3867:
3868: IF (p_debug_mode = 'Y') THEN
3869: pa_debug.debug('PA_TASK_PUB1.COPY_TASK begin');
3870: END IF;
3865: BEGIN
3866: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASK');
3867:
3868: IF (p_debug_mode = 'Y') THEN
3869: pa_debug.debug('PA_TASK_PUB1.COPY_TASK begin');
3870: END IF;
3871:
3872: IF (p_commit = FND_API.G_TRUE) THEN
3873: savepoint copy_task;
5555: COMMIT;
5556: END IF;
5557:
5558: IF (p_debug_mode = 'Y') THEN
5559: pa_debug.debug('PA_TASK_PUB1.COPY_TASK END');
5560: END IF;
5561: EXCEPTION
5562: when FND_API.G_EXC_ERROR then
5563: if p_commit = FND_API.G_TRUE then
5866:
5867: BEGIN
5868:
5869:
5870: pa_debug.init_err_stack ('PA_TASK_PUB1.MOVE_TASK_VERSION');
5871:
5872: IF (p_debug_mode = 'Y') THEN
5873: pa_debug.debug('PA_TASK_PUB1.MOVE_TASK_VERSION begin');
5874: END IF;
5869:
5870: pa_debug.init_err_stack ('PA_TASK_PUB1.MOVE_TASK_VERSION');
5871:
5872: IF (p_debug_mode = 'Y') THEN
5873: pa_debug.debug('PA_TASK_PUB1.MOVE_TASK_VERSION begin');
5874: END IF;
5875:
5876: IF (p_commit = FND_API.G_TRUE) THEN
5877: savepoint move_task_version;
6770: COMMIT;
6771: END IF;
6772:
6773: IF (p_debug_mode = 'Y') THEN
6774: pa_debug.debug('PA_TASK_PUB1.MOVE_TASK_VERSION END');
6775: END IF;
6776: EXCEPTION
6777: when FND_API.G_EXC_ERROR then
6778: if p_commit = FND_API.G_TRUE then
6908: l_parent_ver_id NUMBER;
6909: l_error_msg_code VARCHAR2(30);
6910:
6911: BEGIN
6912: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_TASK_VERSION');
6913:
6914: IF (p_debug_mode = 'Y') THEN
6915: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION begin');
6916: END IF;
6911: BEGIN
6912: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_TASK_VERSION');
6913:
6914: IF (p_debug_mode = 'Y') THEN
6915: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION begin');
6916: END IF;
6917:
6918: IF (p_commit = FND_API.G_TRUE) THEN
6919: savepoint indent_task_version;
7337: COMMIT;
7338: END IF;
7339:
7340: IF (p_debug_mode = 'Y') THEN
7341: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION END');
7342: END IF;
7343:
7344: EXCEPTION
7345: when FND_API.G_EXC_ERROR then
7484: and relationship_type = 'S';
7485: l_parent_ver_id NUMBER;
7486: l_error_msg_code VARCHAR2(30);
7487: BEGIN
7488: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_TASK_VERSION');
7489:
7490: IF (p_debug_mode = 'Y') THEN
7491: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION begin');
7492: END IF;
7487: BEGIN
7488: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_TASK_VERSION');
7489:
7490: IF (p_debug_mode = 'Y') THEN
7491: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION begin');
7492: END IF;
7493:
7494: IF (p_commit = FND_API.G_TRUE) THEN
7495: savepoint outdent_task_version;
7821: COMMIT;
7822: END IF;
7823:
7824: IF (p_debug_mode = 'Y') THEN
7825: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION END');
7826: END IF;
7827:
7828: EXCEPTION
7829: when FND_API.G_EXC_ERROR then
8938: --End Changes for bug 3083950
8939:
8940: BEGIN
8941:
8942: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
8943:
8944: IF l_debug_mode = 'Y' THEN
8945: pa_debug.g_err_stage:= 'Entering CALC_TASK_WEIGHTS';
8946: pa_debug.write(l_module_name,pa_debug.g_err_stage,
8941:
8942: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
8943:
8944: IF l_debug_mode = 'Y' THEN
8945: pa_debug.g_err_stage:= 'Entering CALC_TASK_WEIGHTS';
8946: pa_debug.write(l_module_name,pa_debug.g_err_stage,
8947: l_debug_level2);
8948:
8949:
8942: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
8943:
8944: IF l_debug_mode = 'Y' THEN
8945: pa_debug.g_err_stage:= 'Entering CALC_TASK_WEIGHTS';
8946: pa_debug.write(l_module_name,pa_debug.g_err_stage,
8947: l_debug_level2);
8948:
8949:
8950: pa_debug.set_curr_function( p_function => 'PA_TASK_PUB1.CALC_TASK_WEIGHTS',
8946: pa_debug.write(l_module_name,pa_debug.g_err_stage,
8947: l_debug_level2);
8948:
8949:
8950: pa_debug.set_curr_function( p_function => 'PA_TASK_PUB1.CALC_TASK_WEIGHTS',
8951: p_debug_mode => l_debug_mode );
8952:
8953: END IF;
8954:
9076: -- against the parent task id in local table for all its child task and as the sum of difference goes above -0.01
9077: -- or below -0.01 just increase or decrease the task weightage of the child task being processed by 0.01
9078: -- SO in this way we will cover the weighting % which we have lost by rounding to 2nd decimal as the loss or gain reaches 0.1
9079: IF l_debug_mode = 'Y' THEN
9080: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
9081: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9082: END IF;
9083:
9084: l_temp_number := l_task_weight;
9077: -- or below -0.01 just increase or decrease the task weightage of the child task being processed by 0.01
9078: -- SO in this way we will cover the weighting % which we have lost by rounding to 2nd decimal as the loss or gain reaches 0.1
9079: IF l_debug_mode = 'Y' THEN
9080: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
9081: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9082: END IF;
9083:
9084: l_temp_number := l_task_weight;
9085:
9083:
9084: l_temp_number := l_task_weight;
9085:
9086: IF l_debug_mode = 'Y' THEN
9087: pa_debug.g_err_stage:= 'Value of l_temp_number' || l_temp_number;
9088: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9089: END IF;
9090:
9091: l_diff_number := l_task_weight - l_temp_number;
9084: l_temp_number := l_task_weight;
9085:
9086: IF l_debug_mode = 'Y' THEN
9087: pa_debug.g_err_stage:= 'Value of l_temp_number' || l_temp_number;
9088: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9089: END IF;
9090:
9091: l_diff_number := l_task_weight - l_temp_number;
9092:
9090:
9091: l_diff_number := l_task_weight - l_temp_number;
9092:
9093: IF l_debug_mode = 'Y' THEN
9094: pa_debug.g_err_stage:= 'Value of l_diff_number' || l_diff_number;
9095: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9096: END IF;
9097:
9098: IF(l_diff_number <> 0) THEN
9091: l_diff_number := l_task_weight - l_temp_number;
9092:
9093: IF l_debug_mode = 'Y' THEN
9094: pa_debug.g_err_stage:= 'Value of l_diff_number' || l_diff_number;
9095: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9096: END IF;
9097:
9098: IF(l_diff_number <> 0) THEN
9099:
9097:
9098: IF(l_diff_number <> 0) THEN
9099:
9100: IF l_debug_mode = 'Y' THEN
9101: pa_debug.g_err_stage:= 'Value of l_parent_element_version_id' || l_parent_element_version_id;
9102: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9103: END IF;
9104:
9105: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
9098: IF(l_diff_number <> 0) THEN
9099:
9100: IF l_debug_mode = 'Y' THEN
9101: pa_debug.g_err_stage:= 'Value of l_parent_element_version_id' || l_parent_element_version_id;
9102: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9103: END IF;
9104:
9105: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
9106: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9105: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
9106: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9107:
9108: IF l_debug_mode = 'Y' THEN
9109: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
9110: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9111:
9112: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
9113: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9106: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9107:
9108: IF l_debug_mode = 'Y' THEN
9109: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
9110: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9111:
9112: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
9113: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9114: END IF;
9108: IF l_debug_mode = 'Y' THEN
9109: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
9110: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9111:
9112: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
9113: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9114: END IF;
9115: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
9116: l_task_weight := l_task_weight + 0.01;
9109: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
9110: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9111:
9112: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
9113: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9114: END IF;
9115: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
9116: l_task_weight := l_task_weight + 0.01;
9117: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
9115: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
9116: l_task_weight := l_task_weight + 0.01;
9117: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
9118: IF l_debug_mode = 'Y' THEN
9119: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
9120: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9121: END IF;
9122: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
9123: l_task_weight := l_task_weight - 0.01;
9116: l_task_weight := l_task_weight + 0.01;
9117: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
9118: IF l_debug_mode = 'Y' THEN
9119: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
9120: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9121: END IF;
9122: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
9123: l_task_weight := l_task_weight - 0.01;
9124: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
9122: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
9123: l_task_weight := l_task_weight - 0.01;
9124: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
9125: IF l_debug_mode = 'Y' THEN
9126: pa_debug.g_err_stage:= 'In else IF Value of l_task_weight' || l_task_weight;
9127: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9128: END IF;
9129: ELSE
9130: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9123: l_task_weight := l_task_weight - 0.01;
9124: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
9125: IF l_debug_mode = 'Y' THEN
9126: pa_debug.g_err_stage:= 'In else IF Value of l_task_weight' || l_task_weight;
9127: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9128: END IF;
9129: ELSE
9130: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9131: IF l_debug_mode = 'Y' THEN
9128: END IF;
9129: ELSE
9130: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9131: IF l_debug_mode = 'Y' THEN
9132: pa_debug.g_err_stage:= 'in else Value of l_task_weight' || l_task_weight;
9133: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9134: END IF;
9135: END IF;
9136: ELSE
9129: ELSE
9130: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9131: IF l_debug_mode = 'Y' THEN
9132: pa_debug.g_err_stage:= 'in else Value of l_task_weight' || l_task_weight;
9133: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9134: END IF;
9135: END IF;
9136: ELSE
9137: l_task_weightage_tbl(l_parent_element_version_id) := l_diff_number;
9137: l_task_weightage_tbl(l_parent_element_version_id) := l_diff_number;
9138: END IF;
9139:
9140: IF l_debug_mode = 'Y' THEN
9141: pa_debug.g_err_stage:= 'Value of task_weightage_tbl' || l_task_weightage_tbl(l_parent_element_version_id);
9142: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9143: END IF;
9144:
9145: END IF;
9138: END IF;
9139:
9140: IF l_debug_mode = 'Y' THEN
9141: pa_debug.g_err_stage:= 'Value of task_weightage_tbl' || l_task_weightage_tbl(l_parent_element_version_id);
9142: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9143: END IF;
9144:
9145: END IF;
9146:
9235: -- or below -0.01 just increase or decrease the task weightage of the child task being processed by 0.01
9236: -- SO in this way we will cover the weighting % which we have lost by rounding to 2nd decimal as the loss or gain reaches 0.1
9237:
9238: IF l_debug_mode = 'Y' THEN
9239: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
9240: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9241: END IF;
9242:
9243: l_temp_number := l_task_weight;
9236: -- SO in this way we will cover the weighting % which we have lost by rounding to 2nd decimal as the loss or gain reaches 0.1
9237:
9238: IF l_debug_mode = 'Y' THEN
9239: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
9240: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9241: END IF;
9242:
9243: l_temp_number := l_task_weight;
9244:
9242:
9243: l_temp_number := l_task_weight;
9244:
9245: IF l_debug_mode = 'Y' THEN
9246: pa_debug.g_err_stage:= 'Value of l_temp_number' || l_temp_number;
9247: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9248: END IF;
9249:
9250: l_diff_number := l_task_weight - l_temp_number;
9243: l_temp_number := l_task_weight;
9244:
9245: IF l_debug_mode = 'Y' THEN
9246: pa_debug.g_err_stage:= 'Value of l_temp_number' || l_temp_number;
9247: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9248: END IF;
9249:
9250: l_diff_number := l_task_weight - l_temp_number;
9251:
9249:
9250: l_diff_number := l_task_weight - l_temp_number;
9251:
9252: IF l_debug_mode = 'Y' THEN
9253: pa_debug.g_err_stage:= 'Value of l_diff_number' || l_diff_number;
9254: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9255: END IF;
9256:
9257: IF(l_diff_number <> 0) THEN
9250: l_diff_number := l_task_weight - l_temp_number;
9251:
9252: IF l_debug_mode = 'Y' THEN
9253: pa_debug.g_err_stage:= 'Value of l_diff_number' || l_diff_number;
9254: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9255: END IF;
9256:
9257: IF(l_diff_number <> 0) THEN
9258:
9256:
9257: IF(l_diff_number <> 0) THEN
9258:
9259: IF l_debug_mode = 'Y' THEN
9260: pa_debug.g_err_stage:= 'Value of l_parent_element_version_id' || l_parent_element_version_id;
9261: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9262: END IF;
9263:
9264: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
9257: IF(l_diff_number <> 0) THEN
9258:
9259: IF l_debug_mode = 'Y' THEN
9260: pa_debug.g_err_stage:= 'Value of l_parent_element_version_id' || l_parent_element_version_id;
9261: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9262: END IF;
9263:
9264: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
9265:
9265:
9266: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9267:
9268: IF l_debug_mode = 'Y' THEN
9269: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
9270: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9271:
9272: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
9273: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9266: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9267:
9268: IF l_debug_mode = 'Y' THEN
9269: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
9270: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9271:
9272: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
9273: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9274: END IF;
9268: IF l_debug_mode = 'Y' THEN
9269: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
9270: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9271:
9272: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
9273: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9274: END IF;
9275:
9276: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
9269: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
9270: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9271:
9272: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
9273: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9274: END IF;
9275:
9276: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
9277: l_task_weight := l_task_weight + 0.01;
9276: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
9277: l_task_weight := l_task_weight + 0.01;
9278: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
9279: IF l_debug_mode = 'Y' THEN
9280: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
9281: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9282: END IF;
9283: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
9284: l_task_weight := l_task_weight - 0.01;
9277: l_task_weight := l_task_weight + 0.01;
9278: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
9279: IF l_debug_mode = 'Y' THEN
9280: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
9281: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9282: END IF;
9283: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
9284: l_task_weight := l_task_weight - 0.01;
9285: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
9283: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
9284: l_task_weight := l_task_weight - 0.01;
9285: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
9286: IF l_debug_mode = 'Y' THEN
9287: pa_debug.g_err_stage:= 'In else IF Value of l_task_weight' || l_task_weight;
9288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9289: END IF;
9290: ELSE
9291: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9284: l_task_weight := l_task_weight - 0.01;
9285: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
9286: IF l_debug_mode = 'Y' THEN
9287: pa_debug.g_err_stage:= 'In else IF Value of l_task_weight' || l_task_weight;
9288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9289: END IF;
9290: ELSE
9291: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9292: IF l_debug_mode = 'Y' THEN
9289: END IF;
9290: ELSE
9291: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9292: IF l_debug_mode = 'Y' THEN
9293: pa_debug.g_err_stage:= 'in else Value of l_task_weight' || l_task_weight;
9294: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9295: END IF;
9296: END IF;
9297: ELSE
9290: ELSE
9291: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
9292: IF l_debug_mode = 'Y' THEN
9293: pa_debug.g_err_stage:= 'in else Value of l_task_weight' || l_task_weight;
9294: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9295: END IF;
9296: END IF;
9297: ELSE
9298: l_task_weightage_tbl(l_parent_element_version_id) := l_diff_number;
9298: l_task_weightage_tbl(l_parent_element_version_id) := l_diff_number;
9299: END IF;
9300:
9301: IF l_debug_mode = 'Y' THEN
9302: pa_debug.g_err_stage:= 'Value of task_weightage_tbl' || l_task_weightage_tbl(l_parent_element_version_id);
9303: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9304: END IF;
9305:
9306: END IF;
9299: END IF;
9300:
9301: IF l_debug_mode = 'Y' THEN
9302: pa_debug.g_err_stage:= 'Value of task_weightage_tbl' || l_task_weightage_tbl(l_parent_element_version_id);
9303: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
9304: END IF;
9305:
9306: END IF;
9307: --End Changes for bug 3083950
9322:
9323: end LOOP;
9324:
9325: IF l_debug_mode = 'Y' THEN
9326: pa_debug.reset_curr_function;
9327: END IF;
9328:
9329: x_return_status := FND_API.G_RET_STS_SUCCESS;
9330: EXCEPTION
9333: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
9334: p_procedure_name => 'CALC_TASK_WEIGHTS',
9335: p_error_text => SUBSTRB(SQLERRM,1,240));
9336: IF l_debug_mode = 'Y' THEN
9337: pa_debug.reset_curr_function;
9338: END IF;
9339:
9340: raise;
9341: END CALC_TASK_WEIGHTS;
9385: IS
9386:
9387: BEGIN
9388:
9389: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK_WEIGHTING');
9390:
9391: IF (p_debug_mode = 'Y') THEN
9392: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_WEIGHTING begin');
9393: END IF;
9388:
9389: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK_WEIGHTING');
9390:
9391: IF (p_debug_mode = 'Y') THEN
9392: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_WEIGHTING begin');
9393: END IF;
9394:
9395: IF (p_commit = FND_API.G_TRUE) THEN
9396: savepoint update_task_weighting;
9734: --bug 4214825, end
9735:
9736: BEGIN
9737:
9738: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK');
9739:
9740: IF (p_debug_mode = 'Y') THEN
9741: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK begin');
9742: END IF;
9737:
9738: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK');
9739:
9740: IF (p_debug_mode = 'Y') THEN
9741: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK begin');
9742: END IF;
9743:
9744: IF (p_commit = FND_API.G_TRUE) THEN
9745: savepoint indent_task_version_bulk;
10890: COMMIT;
10891: END IF;
10892:
10893: IF (p_debug_mode = 'Y') THEN
10894: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK END');
10895: END IF;
10896:
10897: EXCEPTION
10898: when FND_API.G_EXC_ERROR then
11271: l_child_task_exists VARCHAR2(1) ;
11272: --Bug 16013002
11273: BEGIN
11274:
11275: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK');
11276:
11277: IF (p_debug_mode = 'Y') THEN
11278: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK begin');
11279: END IF;
11274:
11275: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK');
11276:
11277: IF (p_debug_mode = 'Y') THEN
11278: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK begin');
11279: END IF;
11280:
11281: IF (p_commit = FND_API.G_TRUE) THEN
11282: savepoint OUTDENT_task_version_bulk;
11447: , src_proj_element_id
11448: , p_task_version_id),'N') = 'Y') then
11449:
11450: IF (p_debug_mode = 'Y') THEN
11451: pa_debug.debug('ERROR !!! PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK ');
11452: END IF;
11453:
11454: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
11455: p_msg_name => 'PA_PS_TASK_HAS_SUB_PROJ');
12563: COMMIT;
12564: END IF;
12565:
12566: IF (p_debug_mode = 'Y') THEN
12567: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK END');
12568: END IF;
12569:
12570: EXCEPTION
12571: when FND_API.G_EXC_ERROR then
12694: x_return_status := FND_API.G_RET_STS_SUCCESS;
12695:
12696: l_msg_count := 0;
12697: l_return_status := FND_API.G_RET_STS_SUCCESS;
12698: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N') ; -- Bug # 4605505.
12699: j := 0 ;
12700:
12701: --hsiu: commenting out due to p1 issue.
12702: -- savepoint should be issued only when p_commit
12705:
12706: FOR i in reverse p_task_version_id_tbl.FIRST..p_task_version_id_tbl.LAST LOOP
12707:
12708: IF l_debug_mode = 'Y' THEN
12709: pa_debug.debug('task id is :'||p_task_version_id_tbl(i));
12710: pa_debug.debug('record version id is :'||p_record_version_number_tbl(i));
12711: END IF ;
12712:
12713: -- initialization is required for every loop
12706: FOR i in reverse p_task_version_id_tbl.FIRST..p_task_version_id_tbl.LAST LOOP
12707:
12708: IF l_debug_mode = 'Y' THEN
12709: pa_debug.debug('task id is :'||p_task_version_id_tbl(i));
12710: pa_debug.debug('record version id is :'||p_record_version_number_tbl(i));
12711: END IF ;
12712:
12713: -- initialization is required for every loop
12714: l_return_status := FND_API.G_RET_STS_SUCCESS ;
12818: FETCH get_project_id INTO l_project_id;
12819: CLOSE get_project_id;
12820:
12821: IF (l_debug_mode = 'Y') THEN
12822: pa_debug.debug('DELETE_TASK_VERSION_IN_BULK: l_planned_effort_exists - ' || l_planned_effort_exists);
12823: END IF ;
12824:
12825: IF ((PA_TASK_ASSIGNMENT_UTILS.IS_PROGRESS_ROLLUP_REQUIRED(l_project_id) = 'Y')
12826: AND
12830: (l_planned_effort_exists = 'Y')
12831: ) THEN
12832:
12833: IF (l_debug_mode = 'Y') THEN
12834: pa_debug.debug('DELETE_TASK_VERSION_IN_BULK: Calling PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP');
12835: END IF;
12836:
12837: PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP
12838: (
12848: pa_task_assignment_utils.g_require_progress_rollup := 'N';
12849:
12850: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12851: IF l_debug_mode = 'Y' THEN
12852: pa_debug.debug('Error after PA_PROJ_TASK_STRUC_PUB.PROCESS_WBS_UPDATES_WRP');
12853: END IF;
12854: RAISE FND_API.G_EXC_ERROR;
12855: END IF;
12856:
12857: END IF;
12858: END IF ; -- end of additions for bug 9535723
12859:
12860: IF l_debug_mode = 'Y' THEN
12861: pa_debug.reset_curr_function;
12862: END IF ;
12863:
12864: EXCEPTION
12865: WHEN NO_DATA_FOUND THEN
12896: FND_MSG_PUB.add_exc_msg
12897: ( p_pkg_name => 'PA_TASK_PUB1'
12898: ,p_procedure_name => 'DELETE_TASK_VERSION_IN_BULK' );
12899: IF l_debug_mode = 'Y' THEN
12900: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,SQLERRM,4);
12901: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,pa_debug.G_Err_Stack,4);
12902: pa_debug.reset_curr_function;
12903: END IF;
12904: RAISE ;
12897: ( p_pkg_name => 'PA_TASK_PUB1'
12898: ,p_procedure_name => 'DELETE_TASK_VERSION_IN_BULK' );
12899: IF l_debug_mode = 'Y' THEN
12900: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,SQLERRM,4);
12901: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,pa_debug.G_Err_Stack,4);
12902: pa_debug.reset_curr_function;
12903: END IF;
12904: RAISE ;
12905:
12898: ,p_procedure_name => 'DELETE_TASK_VERSION_IN_BULK' );
12899: IF l_debug_mode = 'Y' THEN
12900: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,SQLERRM,4);
12901: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,pa_debug.G_Err_Stack,4);
12902: pa_debug.reset_curr_function;
12903: END IF;
12904: RAISE ;
12905:
12906: END DELETE_TASK_VERSION_IN_BULK ;
12955:
12956: x_return_status := FND_API.G_RET_STS_SUCCESS;
12957:
12958: IF (p_debug_mode = 'Y') THEN
12959: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_ASSOCIATION START');
12960: END IF;
12961:
12962: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
12963: FND_MSG_PUB.initialize;
13065: END IF;
13066: END IF;
13067:
13068: IF (p_debug_mode = 'Y') THEN
13069: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_ASSOCIATION END');
13070: END IF;
13071:
13072:
13073: EXCEPTION
13128: BEGIN
13129: x_return_status := FND_API.G_RET_STS_SUCCESS;
13130:
13131: IF (p_debug_mode = 'Y') THEN
13132: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_ASSOCIATION START');
13133: END IF;
13134:
13135: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
13136: FND_MSG_PUB.initialize;
13174: END IF;
13175:
13176:
13177: IF (p_debug_mode = 'Y') THEN
13178: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_ASSOCIATIONS END');
13179: END IF;
13180:
13181:
13182: EXCEPTION
13382: BEGIN
13383: x_return_status := FND_API.G_RET_STS_SUCCESS;
13384:
13385: IF (p_debug_mode = 'Y') THEN
13386: pa_debug.debug('PA_TASK_PUB1.Delete_Proj_To_Task_Assoc START');
13387: END IF;
13388: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
13389: FND_MSG_PUB.initialize;
13390: END IF;
13426: END IF;
13427: END IF;
13428:
13429: IF (p_debug_mode = 'Y') THEN
13430: pa_debug.debug('PA_TASK_PUB1.Delete_Proj_To_Task_Assoc END');
13431: END IF;
13432:
13433: EXCEPTION
13434: WHEN FND_API.G_EXC_ERROR THEN
13499:
13500: BEGIN
13501:
13502: IF (p_debug_mode = 'Y') THEN
13503: pa_debug.debug('PA_TASK_PUB1.Copy_Task_Associations START');
13504: END IF;
13505:
13506: x_return_status := FND_API.G_RET_STS_SUCCESS;
13507:
13573: END IF;
13574: END IF;
13575:
13576: IF (p_debug_mode = 'Y') THEN
13577: pa_debug.debug('PA_TASK_PUB1.Copy_Task_Associations END');
13578: END IF;
13579:
13580: EXCEPTION
13581: WHEN FND_API.G_EXC_ERROR THEN
13985:
13986: BEGIN
13987:
13988: IF (p_debug_mode = 'Y') THEN
13989: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO begin');
13990: END IF;
13991:
13992: IF (p_commit = FND_API.G_TRUE) THEN
13993: savepoint UPDATE_task_det_sch;
13992: IF (p_commit = FND_API.G_TRUE) THEN
13993: savepoint UPDATE_task_det_sch;
13994: END IF;
13995:
13996: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
13997:
13998: IF l_debug_mode = 'Y' THEN
13999: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO Start : Passed Parameters :', x_Log_Level=> 3);
14000: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_calling_module='||p_calling_module, x_Log_Level=> 3);
13995:
13996: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
13997:
13998: IF l_debug_mode = 'Y' THEN
13999: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO Start : Passed Parameters :', x_Log_Level=> 3);
14000: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_calling_module='||p_calling_module, x_Log_Level=> 3);
14001: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14002: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
13996: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
13997:
13998: IF l_debug_mode = 'Y' THEN
13999: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO Start : Passed Parameters :', x_Log_Level=> 3);
14000: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_calling_module='||p_calling_module, x_Log_Level=> 3);
14001: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14002: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
13997:
13998: IF l_debug_mode = 'Y' THEN
13999: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO Start : Passed Parameters :', x_Log_Level=> 3);
14000: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_calling_module='||p_calling_module, x_Log_Level=> 3);
14001: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14002: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
13998: IF l_debug_mode = 'Y' THEN
13999: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO Start : Passed Parameters :', x_Log_Level=> 3);
14000: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_calling_module='||p_calling_module, x_Log_Level=> 3);
14001: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14002: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
13999: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO Start : Passed Parameters :', x_Log_Level=> 3);
14000: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_calling_module='||p_calling_module, x_Log_Level=> 3);
14001: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14002: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
14007: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_etc_cost='||p_etc_cost, x_Log_Level=> 3);
14000: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_calling_module='||p_calling_module, x_Log_Level=> 3);
14001: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14002: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
14007: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_etc_cost='||p_etc_cost, x_Log_Level=> 3);
14008: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_actual_effort='||p_actual_effort, x_Log_Level=> 3);
14001: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14002: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
14007: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_etc_cost='||p_etc_cost, x_Log_Level=> 3);
14008: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_actual_effort='||p_actual_effort, x_Log_Level=> 3);
14009: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_percent_complete='||p_percent_complete, x_Log_Level=> 3);
14002: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
14007: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_etc_cost='||p_etc_cost, x_Log_Level=> 3);
14008: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_actual_effort='||p_actual_effort, x_Log_Level=> 3);
14009: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_percent_complete='||p_percent_complete, x_Log_Level=> 3);
14010: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_res_assign_id='||p_res_assign_id, x_Log_Level=> 3);
14003: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_planned_effort='||p_planned_effort, x_Log_Level=> 3);
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
14007: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_etc_cost='||p_etc_cost, x_Log_Level=> 3);
14008: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_actual_effort='||p_actual_effort, x_Log_Level=> 3);
14009: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_percent_complete='||p_percent_complete, x_Log_Level=> 3);
14010: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_res_assign_id='||p_res_assign_id, x_Log_Level=> 3);
14011: END IF;
14004: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_ETC_effort='||p_ETC_effort, x_Log_Level=> 3);
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
14007: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_etc_cost='||p_etc_cost, x_Log_Level=> 3);
14008: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_actual_effort='||p_actual_effort, x_Log_Level=> 3);
14009: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_percent_complete='||p_percent_complete, x_Log_Level=> 3);
14010: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_res_assign_id='||p_res_assign_id, x_Log_Level=> 3);
14011: END IF;
14012:
14005: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
14007: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_etc_cost='||p_etc_cost, x_Log_Level=> 3);
14008: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_actual_effort='||p_actual_effort, x_Log_Level=> 3);
14009: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_percent_complete='||p_percent_complete, x_Log_Level=> 3);
14010: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_res_assign_id='||p_res_assign_id, x_Log_Level=> 3);
14011: END IF;
14012:
14013: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id); --maansari5/9
14006: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_object_type='||p_object_type, x_Log_Level=> 3);
14007: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_etc_cost='||p_etc_cost, x_Log_Level=> 3);
14008: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_actual_effort='||p_actual_effort, x_Log_Level=> 3);
14009: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_percent_complete='||p_percent_complete, x_Log_Level=> 3);
14010: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_res_assign_id='||p_res_assign_id, x_Log_Level=> 3);
14011: END IF;
14012:
14013: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id); --maansari5/9
14014:
14047: -- End of Bug Fix 5726773
14048:
14049: -- END: Code to raise error if negative etc values or planned values are entered.
14050: IF l_debug_mode = 'Y' THEN
14051: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_version_enabled='||l_version_enabled, x_Log_Level=> 3);
14052: END IF;
14053:
14054: -- Get the task_id.
14055:
14059: where element_version_id = p_task_ver_id
14060: and parent_structure_version_id = p_structure_version_id;
14061:
14062: IF l_debug_mode = 'Y' THEN
14063: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
14064: END IF;
14065: --bug 3959087
14066: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;
14067:
14073: l_object_id := l_task_id;
14074: END IF;
14075:
14076: IF l_debug_mode = 'Y' THEN
14077: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_object_id='||l_object_id, x_Log_Level=> 3);
14078: END IF;
14079:
14080:
14081: -- Logic to make sure that planned value = etc value + actual value if etc is changed.
14099: close cur_prev_planned_task_effort;
14100: END IF;
14101:
14102: IF l_debug_mode = 'Y' THEN
14103: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_prev_planned_effort='||l_prev_planned_effort, x_Log_Level=> 3);
14104: END IF;
14105:
14106: -- Get previous etc value.
14107: --maansari5/9
14116: close cur_prev_etc_effort2;
14117: END IF;
14118:
14119: IF l_debug_mode = 'Y' THEN
14120: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_prev_etc_effort='||l_prev_etc_effort, x_Log_Level=> 3);
14121: END IF;
14122:
14123: --maansari5/9
14124:
14146: END IF;
14147: --bug 3959087, end
14148:
14149: IF l_debug_mode = 'Y' THEN
14150: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_actual_effort='||l_actual_effort, x_Log_Level=> 3);
14151: END IF;
14152:
14153: --maansari5/9
14154: IF (p_planned_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14207:
14208: --Bug#6144931 END
14209:
14210: IF l_debug_mode = 'Y' THEN
14211: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_effort='||l_planned_effort, x_Log_Level=> 3);
14212: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_etc_effort='||l_etc_effort, x_Log_Level=> 3);
14213: END IF;
14214:
14215: --bug 3959087, start
14208: --Bug#6144931 END
14209:
14210: IF l_debug_mode = 'Y' THEN
14211: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_effort='||l_planned_effort, x_Log_Level=> 3);
14212: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_etc_effort='||l_etc_effort, x_Log_Level=> 3);
14213: END IF;
14214:
14215: --bug 3959087, start
14216: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );
14216: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );
14217: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');
14218:
14219: IF l_debug_mode = 'Y' THEN
14220: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_lowest_level_task='||l_lowest_level_task, x_Log_Level=> 3);
14221: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_assignment_exists='||l_assignment_exists, x_Log_Level=> 3);
14222: END IF;
14223: --bug 3959087, end
14224:
14217: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');
14218:
14219: IF l_debug_mode = 'Y' THEN
14220: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_lowest_level_task='||l_lowest_level_task, x_Log_Level=> 3);
14221: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_assignment_exists='||l_assignment_exists, x_Log_Level=> 3);
14222: END IF;
14223: --bug 3959087, end
14224:
14225: -- Call: pa_fp_planning_transaction_pub.update_planning_transactions().
14237: OPEN cur_sch;
14238: FETCH cur_sch INTO l_SCHEDULED_START_DATE, l_SCHEDULED_END_DATE;
14239: CLOSE cur_sch;
14240: IF l_debug_mode = 'Y' THEN
14241: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_SCHEDULED_START_DATE='||l_SCHEDULED_START_DATE, x_Log_Level=> 3);
14242: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_SCHEDULED_END_DATE='||l_SCHEDULED_END_DATE, x_Log_Level=> 3);
14243: END IF;
14244:
14245: l_task_ver_ids2.extend(1);
14238: FETCH cur_sch INTO l_SCHEDULED_START_DATE, l_SCHEDULED_END_DATE;
14239: CLOSE cur_sch;
14240: IF l_debug_mode = 'Y' THEN
14241: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_SCHEDULED_START_DATE='||l_SCHEDULED_START_DATE, x_Log_Level=> 3);
14242: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_SCHEDULED_END_DATE='||l_SCHEDULED_END_DATE, x_Log_Level=> 3);
14243: END IF;
14244:
14245: l_task_ver_ids2.extend(1);
14246: l_planned_effort2.extend(1);
14267: BEGIN
14268: IF NVL(l_prev_planned_effort,0) <> NVL(l_planned_effort,0)
14269: THEN
14270: IF l_debug_mode = 'Y' THEN
14271: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
14272: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_ver_ids2='||p_task_ver_id, x_Log_Level=> 3);
14273: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_effort2='||l_planned_effort, x_Log_Level=> 3);
14274: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_start_dates='||l_SCHEDULED_START_DATE, x_Log_Level=> 3);
14275: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_end_dates='||l_SCHEDULED_END_DATE, x_Log_Level=> 3);
14268: IF NVL(l_prev_planned_effort,0) <> NVL(l_planned_effort,0)
14269: THEN
14270: IF l_debug_mode = 'Y' THEN
14271: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
14272: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_ver_ids2='||p_task_ver_id, x_Log_Level=> 3);
14273: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_effort2='||l_planned_effort, x_Log_Level=> 3);
14274: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_start_dates='||l_SCHEDULED_START_DATE, x_Log_Level=> 3);
14275: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_end_dates='||l_SCHEDULED_END_DATE, x_Log_Level=> 3);
14276: END IF;
14269: THEN
14270: IF l_debug_mode = 'Y' THEN
14271: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
14272: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_ver_ids2='||p_task_ver_id, x_Log_Level=> 3);
14273: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_effort2='||l_planned_effort, x_Log_Level=> 3);
14274: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_start_dates='||l_SCHEDULED_START_DATE, x_Log_Level=> 3);
14275: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_end_dates='||l_SCHEDULED_END_DATE, x_Log_Level=> 3);
14276: END IF;
14277:
14270: IF l_debug_mode = 'Y' THEN
14271: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
14272: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_ver_ids2='||p_task_ver_id, x_Log_Level=> 3);
14273: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_effort2='||l_planned_effort, x_Log_Level=> 3);
14274: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_start_dates='||l_SCHEDULED_START_DATE, x_Log_Level=> 3);
14275: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_end_dates='||l_SCHEDULED_END_DATE, x_Log_Level=> 3);
14276: END IF;
14277:
14278: pa_fp_planning_transaction_pub.update_planning_transactions
14271: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
14272: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_ver_ids2='||p_task_ver_id, x_Log_Level=> 3);
14273: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_effort2='||l_planned_effort, x_Log_Level=> 3);
14274: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_start_dates='||l_SCHEDULED_START_DATE, x_Log_Level=> 3);
14275: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_end_dates='||l_SCHEDULED_END_DATE, x_Log_Level=> 3);
14276: END IF;
14277:
14278: pa_fp_planning_transaction_pub.update_planning_transactions
14279: (
14309:
14310:
14311: l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id , p_task_id => l_task_id);
14312: IF l_debug_mode = 'Y' THEN
14313: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_next_prog_cycle_date='||l_next_prog_cycle_date, x_Log_Level=> 3);
14314: END IF;
14315:
14316:
14317: IF (nvl(p_percent_complete,0) > 0 AND p_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
14370: OPEN cur_proj_elements(l_task_id);
14371: FETCH cur_proj_elements INTO l_BASE_PERCENT_COMP_DERIV_CODE;
14372: CLOSE cur_proj_elements;
14373: IF l_debug_mode = 'Y' THEN
14374: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_BASE_PERCENT_COMP_DERIV_CODE='||l_BASE_PERCENT_COMP_DERIV_CODE, x_Log_Level=> 3);
14375: END IF;
14376:
14377: IF l_BASE_PERCENT_COMP_DERIV_CODE = 'EFFORT'
14378: THEN
14391: FETCH cur_get_costs INTO l_planned_cost, l_ppl_act_cost;
14392: CLOSE cur_get_costs;
14393:
14394: IF l_debug_mode = 'Y' THEN
14395: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_ppl_act_cost='||l_ppl_act_cost, x_Log_Level=> 3);
14396: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_cost='||l_planned_cost, x_Log_Level=> 3);
14397: END IF;
14398: IF (l_planned_cost <> 0)
14399: THEN
14392: CLOSE cur_get_costs;
14393:
14394: IF l_debug_mode = 'Y' THEN
14395: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_ppl_act_cost='||l_ppl_act_cost, x_Log_Level=> 3);
14396: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_planned_cost='||l_planned_cost, x_Log_Level=> 3);
14397: END IF;
14398: IF (l_planned_cost <> 0)
14399: THEN
14400: l_eff_rollup_pc := round((l_ppl_act_cost/l_planned_cost)*100, 2);
14419:
14420: --bug 3959087, calculate percent complete for lowest level tasks only, depending on derivation code, end
14421:
14422: IF l_debug_mode = 'Y' THEN
14423: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_percent_complete='||l_percent_complete, x_Log_Level=> 3);
14424: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_override_pc='||l_override_pc, x_Log_Level=> 3);
14425: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_eff_rollup_pc='||l_eff_rollup_pc, x_Log_Level=> 3);
14426: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_curr_override_pc='||l_curr_override_pc, x_Log_Level=> 3);
14427: END IF;
14420: --bug 3959087, calculate percent complete for lowest level tasks only, depending on derivation code, end
14421:
14422: IF l_debug_mode = 'Y' THEN
14423: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_percent_complete='||l_percent_complete, x_Log_Level=> 3);
14424: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_override_pc='||l_override_pc, x_Log_Level=> 3);
14425: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_eff_rollup_pc='||l_eff_rollup_pc, x_Log_Level=> 3);
14426: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_curr_override_pc='||l_curr_override_pc, x_Log_Level=> 3);
14427: END IF;
14428:
14421:
14422: IF l_debug_mode = 'Y' THEN
14423: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_percent_complete='||l_percent_complete, x_Log_Level=> 3);
14424: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_override_pc='||l_override_pc, x_Log_Level=> 3);
14425: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_eff_rollup_pc='||l_eff_rollup_pc, x_Log_Level=> 3);
14426: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_curr_override_pc='||l_curr_override_pc, x_Log_Level=> 3);
14427: END IF;
14428:
14429:
14422: IF l_debug_mode = 'Y' THEN
14423: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_percent_complete='||l_percent_complete, x_Log_Level=> 3);
14424: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_override_pc='||l_override_pc, x_Log_Level=> 3);
14425: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_eff_rollup_pc='||l_eff_rollup_pc, x_Log_Level=> 3);
14426: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_curr_override_pc='||l_curr_override_pc, x_Log_Level=> 3);
14427: END IF;
14428:
14429:
14430: OPEN c_get_task_weight_method;
14449: END IF;
14450: --bug 3959087, end
14451:
14452: IF l_debug_mode = 'Y' THEN
14453: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_earned_value='||l_earned_value, x_Log_Level=> 3);
14454: END IF;
14455:
14456: --END IF; Bug 3856161
14457:
14471: l_actual_finish_DATE := nvl(l_actual_finish_date,l_SCHEDULED_END_DATE);
14472: END IF;
14473:
14474: IF l_debug_mode = 'Y' THEN
14475: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_actual_START_DATE='||l_actual_START_DATE, x_Log_Level=> 3);
14476: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_actual_finish_DATE='||l_actual_finish_DATE, x_Log_Level=> 3);
14477: END IF;
14478:
14479: -- Progress Management Changes, Bug # 3420093.
14472: END IF;
14473:
14474: IF l_debug_mode = 'Y' THEN
14475: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_actual_START_DATE='||l_actual_START_DATE, x_Log_Level=> 3);
14476: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_actual_finish_DATE='||l_actual_finish_DATE, x_Log_Level=> 3);
14477: END IF;
14478:
14479: -- Progress Management Changes, Bug # 3420093.
14480: -- If workplan versioning is disabled for the project.
14917:
14918:
14919: -- Call rollup_progress_pvt api for this task.
14920: IF l_debug_mode = 'Y' THEN
14921: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14922: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
14923: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14924: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
14925: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14918:
14919: -- Call rollup_progress_pvt api for this task.
14920: IF l_debug_mode = 'Y' THEN
14921: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14922: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
14923: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14924: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
14925: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14926: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14919: -- Call rollup_progress_pvt api for this task.
14920: IF l_debug_mode = 'Y' THEN
14921: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14922: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
14923: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14924: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
14925: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14926: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14927: END IF;
14920: IF l_debug_mode = 'Y' THEN
14921: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14922: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
14923: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14924: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
14925: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14926: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14927: END IF;
14928: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
14921: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14922: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
14923: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14924: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
14925: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14926: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14927: END IF;
14928: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
14929: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N'
14922: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
14923: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
14924: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
14925: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14926: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
14927: END IF;
14928: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
14929: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N'
14930: then
14982:
14983: -- Call rollup API only is there is a working progress for the given task_version and
14984: -- structure_version. The as_of_date will then be the max(as_of_date() of the working progress.
14985: IF l_debug_mode = 'Y' THEN
14986: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Entered For Assignments', x_Log_Level=> 3);
14987: END IF;
14988:
14989: --bug 4105720, get the task id
14990: OPEN c_proj_element_id;
14996: FETCH cur_progress_exists INTO l_progress_exists;
14997: CLOSE cur_progress_exists;
14998:
14999: IF l_debug_mode = 'Y' THEN
15000: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id '||l_task_id, x_Log_Level=> 3);
15001: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_progress_exists '||l_progress_exists, x_Log_Level=> 3);
15002: END IF;
15003:
15004: IF NVL(l_progress_exists, 'N') = 'Y' THEN -- Bug 3976633
14997: CLOSE cur_progress_exists;
14998:
14999: IF l_debug_mode = 'Y' THEN
15000: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id '||l_task_id, x_Log_Level=> 3);
15001: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_progress_exists '||l_progress_exists, x_Log_Level=> 3);
15002: END IF;
15003:
15004: IF NVL(l_progress_exists, 'N') = 'Y' THEN -- Bug 3976633
15005:
15019: FETCH c_proj_element_id INTO l_task_id;
15020: CLOSE c_proj_element_id;*/
15021:
15022: IF l_debug_mode = 'Y' THEN
15023: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
15024: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
15025: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
15026: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
15027: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15020: CLOSE c_proj_element_id;*/
15021:
15022: IF l_debug_mode = 'Y' THEN
15023: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
15024: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
15025: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
15026: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
15027: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15028: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15021:
15022: IF l_debug_mode = 'Y' THEN
15023: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
15024: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
15025: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
15026: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
15027: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15028: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15029: END IF;
15022: IF l_debug_mode = 'Y' THEN
15023: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
15024: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
15025: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
15026: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
15027: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15028: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15029: END IF;
15030: -- 4591321 : Always call populate_pji_tab_for_plan
15023: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
15024: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
15025: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
15026: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
15027: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15028: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15029: END IF;
15030: -- 4591321 : Always call populate_pji_tab_for_plan
15031: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
15024: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_task_id='||l_task_id, x_Log_Level=> 3);
15025: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'p_task_ver_id='||p_task_ver_id, x_Log_Level=> 3);
15026: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_method='||l_rollup_method, x_Log_Level=> 3);
15027: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15028: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'l_rollup_as_of_date='||l_rollup_as_of_date, x_Log_Level=> 3);
15029: END IF;
15030: -- 4591321 : Always call populate_pji_tab_for_plan
15031: -- 14556729:Huawei Code change to defer the roll up API when G_ROLLUP_DEFER is set to Y , so that all the roll up is processed once at the end .
15032: IF NVL(PA_PROJECT_PUB.G_ROLLUP_DEFER, 'N') = 'N'
15262: SELECT pm_product_code
15263: FROM PA_PROJECTS_ALL
15264: WHERE project_id = c_project_id;
15265: BEGIN
15266: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASKS_IN_BULK');
15267: x_return_status := FND_API.G_RET_STS_SUCCESS;
15268: IF (p_debug_mode = 'Y') THEN
15269: pa_debug.debug('PA_TASK_PUB1.COPY_TASKS_IN_BULK begin');
15270: END IF;
15265: BEGIN
15266: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASKS_IN_BULK');
15267: x_return_status := FND_API.G_RET_STS_SUCCESS;
15268: IF (p_debug_mode = 'Y') THEN
15269: pa_debug.debug('PA_TASK_PUB1.COPY_TASKS_IN_BULK begin');
15270: END IF;
15271:
15272: IF (p_commit = FND_API.G_TRUE) THEN
15273: savepoint copy_tasks_in_bulk;
15740:
15741: /*4269830 : Performance Enhancements : End*/
15742:
15743: BEGIN
15744: pa_debug.init_err_stack ('PA_TASK_PUB1.MOVE_TASK_VERSIONS_IN_BULK');
15745:
15746: x_return_status := FND_API.G_RET_STS_SUCCESS ;
15747:
15748: IF (p_debug_mode = 'Y') THEN
15745:
15746: x_return_status := FND_API.G_RET_STS_SUCCESS ;
15747:
15748: IF (p_debug_mode = 'Y') THEN
15749: pa_debug.debug('PA_TASK_PUB1.MOVE_TASK_VERSIONS_IN_BULK begin');
15750: END IF;
15751:
15752: IF (p_commit = FND_API.G_TRUE) THEN
15753: savepoint MOVE_TASK_VERSIONS_IN_BULK ;
16047: l_task_dates TASK_DATES_TBL_TYPE;
16048: -- End of addition for --bug 8301015
16049:
16050: BEGIN
16051: pa_debug.init_err_stack ('PA_TASK_PUB1.Update_Task_All_Info');
16052:
16053: IF (p_debug_mode = 'Y') THEN
16054: pa_debug.debug('PA_TASK_PUB1.Update_Task_All_Info begin');
16055: END IF;
16050: BEGIN
16051: pa_debug.init_err_stack ('PA_TASK_PUB1.Update_Task_All_Info');
16052:
16053: IF (p_debug_mode = 'Y') THEN
16054: pa_debug.debug('PA_TASK_PUB1.Update_Task_All_Info begin');
16055: END IF;
16056:
16057: IF (p_commit = FND_API.G_TRUE) THEN
16058: savepoint update_Task_all_info;
16322: COMMIT;
16323: END IF;
16324:
16325: IF (p_debug_mode = 'Y') THEN
16326: pa_debug.debug('PA_TASK_PUB1.Update_Task_All_Info END');
16327: END IF;
16328:
16329: EXCEPTION
16330: when FND_API.G_EXC_ERROR then
16451: l_version_enabled VARCHAR2(1);
16452:
16453: BEGIN
16454: x_return_status := FND_API.G_RET_STS_SUCCESS;
16455: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
16456: SAVEPOINT CANCEL_TASK_SP;
16457:
16458: IF l_debug_mode = 'Y' THEN
16459: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
16455: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
16456: SAVEPOINT CANCEL_TASK_SP;
16457:
16458: IF l_debug_mode = 'Y' THEN
16459: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
16460: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
16461: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
16462: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
16463: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
16456: SAVEPOINT CANCEL_TASK_SP;
16457:
16458: IF l_debug_mode = 'Y' THEN
16459: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
16460: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
16461: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
16462: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
16463: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
16464: END IF;
16457:
16458: IF l_debug_mode = 'Y' THEN
16459: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
16460: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
16461: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
16462: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
16463: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
16464: END IF;
16465:
16458: IF l_debug_mode = 'Y' THEN
16459: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
16460: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
16461: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
16462: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
16463: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
16464: END IF;
16465:
16466: IF p_init_msg_list = 'T' THEN
16459: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
16460: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
16461: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
16462: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
16463: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
16464: END IF;
16465:
16466: IF p_init_msg_list = 'T' THEN
16467: FND_MSG_PUB.initialize;
16467: FND_MSG_PUB.initialize;
16468: END IF;
16469:
16470: IF l_debug_mode = 'Y' THEN
16471: pa_debug.write(l_module_name,'Calling Check_chg_stat_cancel_ok', 3);
16472: END IF;
16473:
16474: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok
16475: (
16480: ,x_error_message_code => l_error_message_code
16481: );
16482:
16483: IF l_debug_mode = 'Y' THEN
16484: pa_debug.write(l_module_name,'After Call Check_chg_stat_cancel_ok x_return_status='||x_return_status, 3);
16485: END IF;
16486:
16487: IF (x_return_status <> 'S') THEN
16488: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16489: p_msg_name => l_error_message_code);
16490: raise FND_API.G_EXC_ERROR;
16491: END IF;
16492: IF l_debug_mode = 'Y' THEN
16493: pa_debug.write(l_module_name,'Calling set_new_tasks_to_TBD', 3);
16494: END IF;
16495:
16496: PA_TASK_PVT1.set_new_tasks_to_tbd(
16497: p_project_id => p_project_id
16501: ,x_msg_count => x_msg_count
16502: ,x_msg_data => x_msg_data);
16503:
16504: IF l_debug_mode = 'Y' THEN
16505: pa_debug.write(l_module_name,'After Call set_new_tasks_to_TBD x_return_status='||x_return_status, 3);
16506: END IF;
16507:
16508: IF (x_return_status <> 'S') THEN
16509: raise FND_API.G_EXC_ERROR;
16509: raise FND_API.G_EXC_ERROR;
16510: END IF;
16511:
16512: IF l_debug_mode = 'Y' THEN
16513: pa_debug.write(l_module_name,'Calling push_down_task_status', 3);
16514: END IF;
16515:
16516: PA_PROGRESS_PUB.push_down_task_status(
16517: p_calling_module => p_calling_module
16524: ,x_msg_count => x_msg_count
16525: ,x_msg_data => x_msg_data
16526: );
16527: IF l_debug_mode = 'Y' THEN
16528: pa_debug.write(l_module_name,'After Call push_down_task_status x_return_status='||x_return_status, 3);
16529: END IF;
16530:
16531: IF (x_return_status <> 'S') THEN
16532: raise FND_API.G_EXC_ERROR;
16534:
16535: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id);
16536:
16537: IF l_debug_mode = 'Y' THEN
16538: pa_debug.write(l_module_name,'Call Delete_SubProject_Association l_version_enabled='||l_version_enabled, 3);
16539: END IF;
16540:
16541: FOR l_all_tasks IN c_get_all_task_versions(p_task_id, p_project_id) LOOP
16542: IF l_debug_mode = 'Y' THEN
16539: END IF;
16540:
16541: FOR l_all_tasks IN c_get_all_task_versions(p_task_id, p_project_id) LOOP
16542: IF l_debug_mode = 'Y' THEN
16543: pa_debug.write(l_module_name,'l_all_tasks.element_version_id='||l_all_tasks.element_version_id, 3);
16544: pa_debug.write(l_module_name,'l_all_tasks.status_code='||l_all_tasks.status_code, 3);
16545: END IF;
16546: --4533534
16547: IF ((l_version_enabled = 'N') OR (l_version_enabled = 'Y' AND l_all_tasks.status_code = 'STRUCTURE_WORKING'))
16540:
16541: FOR l_all_tasks IN c_get_all_task_versions(p_task_id, p_project_id) LOOP
16542: IF l_debug_mode = 'Y' THEN
16543: pa_debug.write(l_module_name,'l_all_tasks.element_version_id='||l_all_tasks.element_version_id, 3);
16544: pa_debug.write(l_module_name,'l_all_tasks.status_code='||l_all_tasks.status_code, 3);
16545: END IF;
16546: --4533534
16547: IF ((l_version_enabled = 'N') OR (l_version_enabled = 'Y' AND l_all_tasks.status_code = 'STRUCTURE_WORKING'))
16548: THEN
16549: --4533534
16550: --FOR l_all_links IN c_get_links(l_all_tasks.element_version_id, p_project_id) LOOP
16551: FOR l_all_links IN c_get_links(l_all_tasks.element_version_id) LOOP
16552: IF l_debug_mode = 'Y' THEN
16553: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
16554: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
16555: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
16556: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16550: --FOR l_all_links IN c_get_links(l_all_tasks.element_version_id, p_project_id) LOOP
16551: FOR l_all_links IN c_get_links(l_all_tasks.element_version_id) LOOP
16552: IF l_debug_mode = 'Y' THEN
16553: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
16554: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
16555: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
16556: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16551: FOR l_all_links IN c_get_links(l_all_tasks.element_version_id) LOOP
16552: IF l_debug_mode = 'Y' THEN
16553: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
16554: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
16555: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
16556: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16552: IF l_debug_mode = 'Y' THEN
16553: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
16554: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
16555: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
16556: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16560: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
16553: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
16554: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
16555: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
16556: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16560: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
16561: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
16554: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
16555: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
16556: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16560: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
16561: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
16562: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
16555: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
16556: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16560: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
16561: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
16562: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
16563: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
16556: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16560: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
16561: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
16562: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
16563: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
16564: END IF;
16557: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16560: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
16561: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
16562: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
16563: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
16564: END IF;
16565: --4533534
16558: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16560: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
16561: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
16562: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
16563: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
16564: END IF;
16565: --4533534
16566: --IF ((l_version_enabled = 'N') OR (l_version_enabled = 'Y' AND NVL(l_all_links.task_unpub_ver_status_code,'WORKING') <> 'PUBLISHED'))
16559: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
16560: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
16561: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
16562: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
16563: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
16564: END IF;
16565: --4533534
16566: --IF ((l_version_enabled = 'N') OR (l_version_enabled = 'Y' AND NVL(l_all_links.task_unpub_ver_status_code,'WORKING') <> 'PUBLISHED'))
16567:
16574: x_msg_count => x_msg_count,
16575: x_msg_data => x_msg_data
16576: );
16577: IF l_debug_mode = 'Y' THEN
16578: pa_debug.write(l_module_name,'After Call Delete_SubProject_Association x_return_status='||x_return_status, 3);
16579: END IF;
16580:
16581: IF (x_return_status <> 'S') THEN
16582: raise FND_API.G_EXC_ERROR;
16677: l_rec_task_attr l_cur_task_attr%rowtype;
16678:
16679: BEGIN
16680:
16681: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION');
16682:
16683: IF (p_debug_mode = 'Y') THEN
16684: pa_debug.debug('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION BEGIN');
16685: END IF;
16680:
16681: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION');
16682:
16683: IF (p_debug_mode = 'Y') THEN
16684: pa_debug.debug('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION BEGIN');
16685: END IF;
16686:
16687: IF (p_commit = FND_API.G_TRUE) THEN
16688: savepoint indent_multi_task_version;
16807: COMMIT;
16808: END IF;
16809:
16810: IF (p_debug_mode = 'Y') THEN
16811: pa_debug.debug('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION END');
16812: END IF;
16813:
16814: EXCEPTION
16815:
16909: l_rec_task_attr l_cur_task_attr%rowtype;
16910:
16911: BEGIN
16912:
16913: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION');
16914:
16915: IF (p_debug_mode = 'Y') THEN
16916: pa_debug.debug('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION BEGIN');
16917: END IF;
16912:
16913: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION');
16914:
16915: IF (p_debug_mode = 'Y') THEN
16916: pa_debug.debug('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION BEGIN');
16917: END IF;
16918:
16919: IF (p_commit = FND_API.G_TRUE) THEN
16920: savepoint outdent_multi_task_version;
17033: COMMIT;
17034: END IF;
17035:
17036: IF (p_debug_mode = 'Y') THEN
17037: pa_debug.debug('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION END');
17038: END IF;
17039:
17040: EXCEPTION
17041: