[Home] [Help]
212:
213: -- end hyau Bug 2852753
214:
215: BEGIN
216: pa_debug.init_err_stack ('PA_TASK_PUB1.CREATE_TASK');
217:
218: IF (p_debug_mode = 'Y') THEN
219: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK begin');
220: END IF;
215: BEGIN
216: pa_debug.init_err_stack ('PA_TASK_PUB1.CREATE_TASK');
217:
218: IF (p_debug_mode = 'Y') THEN
219: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK begin');
220: END IF;
221:
222: IF (p_commit = FND_API.G_TRUE) THEN
223: savepoint create_Task;
602: COMMIT;
603: END IF;
604:
605: IF (p_debug_mode = 'Y') THEN
606: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK END');
607: END IF;
608: EXCEPTION
609: when FND_API.G_EXC_ERROR then
610: if p_commit = FND_API.G_TRUE then
886: BEGIN
887:
888: --dbms_output.put_line( 'Entered ' );
889:
890: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK');
891:
892: IF (p_debug_mode = 'Y') THEN
893: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK begin');
894: END IF;
889:
890: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK');
891:
892: IF (p_debug_mode = 'Y') THEN
893: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK begin');
894: END IF;
895:
896: IF (p_commit = FND_API.G_TRUE) THEN
897: savepoint update_Task;
1493: COMMIT;
1494: END IF;
1495:
1496: IF (p_debug_mode = 'Y') THEN
1497: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK END');
1498: END IF;
1499: EXCEPTION
1500: when FND_API.G_EXC_ERROR then
1501: if p_commit = FND_API.G_TRUE then
1617: l_carrying_out_org_id NUMBER;
1618: l_task_manager_id NUMBER;
1619: BEGIN
1620:
1621: pa_debug.init_err_stack ('PA_TASK_PUB1.CREATE_TASK_VERSION');
1622:
1623: IF (p_debug_mode = 'Y') THEN
1624: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION begin');
1625: END IF;
1620:
1621: pa_debug.init_err_stack ('PA_TASK_PUB1.CREATE_TASK_VERSION');
1622:
1623: IF (p_debug_mode = 'Y') THEN
1624: pa_debug.debug('PA_TASK_PUB1.CREATE_TASK_VERSION begin');
1625: END IF;
1626:
1627: IF (p_commit = FND_API.G_TRUE) THEN
1628: savepoint create_Task_version;
1705: COMMIT;
1706: END IF;
1707:
1708: IF (p_debug_mode = 'Y') THEN
1709: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_TASK_VERSION END');
1710: END IF;
1711: EXCEPTION
1712: when FND_API.G_EXC_ERROR then
1713: if p_commit = FND_API.G_TRUE then
1829: --l_carrying_out_org_id NUMBER;
1830: --l_task_manager_id NUMBER;
1831: BEGIN
1832:
1833: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK_VERSION');
1834:
1835: IF (p_debug_mode = 'Y') THEN
1836: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_VERSION begin');
1837: END IF;
1832:
1833: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK_VERSION');
1834:
1835: IF (p_debug_mode = 'Y') THEN
1836: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_VERSION begin');
1837: END IF;
1838:
1839: IF (p_commit = FND_API.G_TRUE) THEN
1840: savepoint update_Task_version;
1959: COMMIT;
1960: END IF;
1961:
1962: IF (p_debug_mode = 'Y') THEN
1963: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_VERSION END');
1964: END IF;
1965: EXCEPTION
1966: when FND_API.G_EXC_ERROR then
1967: if p_commit = FND_API.G_TRUE then
2135: l_linked_task VARCHAR2(1);
2136:
2137: BEGIN
2138:
2139: pa_debug.init_err_stack ('PA_TASK_PUB1.DELETE_TASK_VERSION');
2140:
2141: IF (p_debug_mode = 'Y') THEN
2142: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_VERSION begin');
2143: END IF;
2138:
2139: pa_debug.init_err_stack ('PA_TASK_PUB1.DELETE_TASK_VERSION');
2140:
2141: IF (p_debug_mode = 'Y') THEN
2142: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_VERSION begin');
2143: END IF;
2144:
2145: IF (p_commit = FND_API.G_TRUE) THEN
2146: savepoint delete_Task_version;
2486: COMMIT;
2487: END IF;
2488:
2489: IF (p_debug_mode = 'Y') THEN
2490: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_VERSION END');
2491: END IF;
2492: EXCEPTION
2493: when FND_API.G_EXC_ERROR then
2494: if p_commit = FND_API.G_TRUE then
2631: l_data VARCHAR2(250);
2632: l_msg_index_out NUMBER;
2633: l_error_msg_code VARCHAR2(250);
2634: BEGIN
2635: pa_debug.init_err_stack ('PA_TASK_PUB1.create_schedule_VERSION');
2636:
2637: IF (p_debug_mode = 'Y') THEN
2638: pa_debug.debug('PA_TASK_PUB1.CREATE_SCHEDULE_VERSION begin');
2639: END IF;
2634: BEGIN
2635: pa_debug.init_err_stack ('PA_TASK_PUB1.create_schedule_VERSION');
2636:
2637: IF (p_debug_mode = 'Y') THEN
2638: pa_debug.debug('PA_TASK_PUB1.CREATE_SCHEDULE_VERSION begin');
2639: END IF;
2640:
2641: IF (p_commit = FND_API.G_TRUE) THEN
2642: savepoint create_schedule_version;
2733: COMMIT;
2734: END IF;
2735:
2736: IF (p_debug_mode = 'Y') THEN
2737: pa_debug.debug('PA_TASK_PUB1.CREATE_SCHEDULE_VERSION END');
2738: END IF;
2739: EXCEPTION
2740: when FND_API.G_EXC_ERROR then
2741: if p_commit = FND_API.G_TRUE then
2934: -- end hyau Bug 2852753
2935:
2936: BEGIN
2937:
2938: pa_debug.init_err_stack ('PA_TASK_PUB1.update_schedule_VERSION');
2939:
2940: IF (p_debug_mode = 'Y') THEN
2941: pa_debug.debug('PA_TASK_PUB1.update_SCHEDULE_VERSION begin');
2942: END IF;
2937:
2938: pa_debug.init_err_stack ('PA_TASK_PUB1.update_schedule_VERSION');
2939:
2940: IF (p_debug_mode = 'Y') THEN
2941: pa_debug.debug('PA_TASK_PUB1.update_SCHEDULE_VERSION begin');
2942: END IF;
2943:
2944: IF (p_commit = FND_API.G_TRUE) THEN
2945: savepoint update_schedule_version;
3192: COMMIT;
3193: END IF;
3194:
3195: IF (p_debug_mode = 'Y') THEN
3196: pa_debug.debug('PA_TASK_PUB1.UPDATE_SCHEDULE_VERSION END');
3197: END IF;
3198: EXCEPTION
3199: when FND_API.G_EXC_ERROR then
3200: if p_commit = FND_API.G_TRUE then
3755:
3756: -- 3905123 end
3757:
3758: BEGIN
3759: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASK');
3760:
3761: IF (p_debug_mode = 'Y') THEN
3762: pa_debug.debug('PA_TASK_PUB1.COPY_TASK begin');
3763: END IF;
3758: BEGIN
3759: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASK');
3760:
3761: IF (p_debug_mode = 'Y') THEN
3762: pa_debug.debug('PA_TASK_PUB1.COPY_TASK begin');
3763: END IF;
3764:
3765: IF (p_commit = FND_API.G_TRUE) THEN
3766: savepoint copy_task;
5280: COMMIT;
5281: END IF;
5282:
5283: IF (p_debug_mode = 'Y') THEN
5284: pa_debug.debug('PA_TASK_PUB1.COPY_TASK END');
5285: END IF;
5286: EXCEPTION
5287: when FND_API.G_EXC_ERROR then
5288: if p_commit = FND_API.G_TRUE then
5591:
5592: BEGIN
5593:
5594:
5595: pa_debug.init_err_stack ('PA_TASK_PUB1.MOVE_TASK_VERSION');
5596:
5597: IF (p_debug_mode = 'Y') THEN
5598: pa_debug.debug('PA_TASK_PUB1.MOVE_TASK_VERSION begin');
5599: END IF;
5594:
5595: pa_debug.init_err_stack ('PA_TASK_PUB1.MOVE_TASK_VERSION');
5596:
5597: IF (p_debug_mode = 'Y') THEN
5598: pa_debug.debug('PA_TASK_PUB1.MOVE_TASK_VERSION begin');
5599: END IF;
5600:
5601: IF (p_commit = FND_API.G_TRUE) THEN
5602: savepoint move_task_version;
6488: COMMIT;
6489: END IF;
6490:
6491: IF (p_debug_mode = 'Y') THEN
6492: pa_debug.debug('PA_TASK_PUB1.MOVE_TASK_VERSION END');
6493: END IF;
6494: EXCEPTION
6495: when FND_API.G_EXC_ERROR then
6496: if p_commit = FND_API.G_TRUE then
6625: l_parent_ver_id NUMBER;
6626: l_error_msg_code VARCHAR2(30);
6627:
6628: BEGIN
6629: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_TASK_VERSION');
6630:
6631: IF (p_debug_mode = 'Y') THEN
6632: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION begin');
6633: END IF;
6628: BEGIN
6629: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_TASK_VERSION');
6630:
6631: IF (p_debug_mode = 'Y') THEN
6632: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION begin');
6633: END IF;
6634:
6635: IF (p_commit = FND_API.G_TRUE) THEN
6636: savepoint indent_task_version;
7040: COMMIT;
7041: END IF;
7042:
7043: IF (p_debug_mode = 'Y') THEN
7044: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION END');
7045: END IF;
7046:
7047: EXCEPTION
7048: when FND_API.G_EXC_ERROR then
7187: and relationship_type = 'S';
7188: l_parent_ver_id NUMBER;
7189: l_error_msg_code VARCHAR2(30);
7190: BEGIN
7191: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_TASK_VERSION');
7192:
7193: IF (p_debug_mode = 'Y') THEN
7194: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION begin');
7195: END IF;
7190: BEGIN
7191: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_TASK_VERSION');
7192:
7193: IF (p_debug_mode = 'Y') THEN
7194: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION begin');
7195: END IF;
7196:
7197: IF (p_commit = FND_API.G_TRUE) THEN
7198: savepoint outdent_task_version;
7524: COMMIT;
7525: END IF;
7526:
7527: IF (p_debug_mode = 'Y') THEN
7528: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION END');
7529: END IF;
7530:
7531: EXCEPTION
7532: when FND_API.G_EXC_ERROR then
8575: --End Changes for bug 3083950
8576:
8577: BEGIN
8578:
8579: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
8580:
8581: IF l_debug_mode = 'Y' THEN
8582: pa_debug.g_err_stage:= 'Entering CALC_TASK_WEIGHTS';
8583: pa_debug.write(l_module_name,pa_debug.g_err_stage,
8578:
8579: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
8580:
8581: IF l_debug_mode = 'Y' THEN
8582: pa_debug.g_err_stage:= 'Entering CALC_TASK_WEIGHTS';
8583: pa_debug.write(l_module_name,pa_debug.g_err_stage,
8584: l_debug_level2);
8585:
8586:
8579: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
8580:
8581: IF l_debug_mode = 'Y' THEN
8582: pa_debug.g_err_stage:= 'Entering CALC_TASK_WEIGHTS';
8583: pa_debug.write(l_module_name,pa_debug.g_err_stage,
8584: l_debug_level2);
8585:
8586:
8587: pa_debug.set_curr_function( p_function => 'PA_TASK_PUB1.CALC_TASK_WEIGHTS',
8583: pa_debug.write(l_module_name,pa_debug.g_err_stage,
8584: l_debug_level2);
8585:
8586:
8587: pa_debug.set_curr_function( p_function => 'PA_TASK_PUB1.CALC_TASK_WEIGHTS',
8588: p_debug_mode => l_debug_mode );
8589:
8590: END IF;
8591:
8713: -- against the parent task id in local table for all its child task and as the sum of difference goes above -0.01
8714: -- or below -0.01 just increase or decrease the task weightage of the child task being processed by 0.01
8715: -- 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
8716: IF l_debug_mode = 'Y' THEN
8717: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
8718: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8719: END IF;
8720:
8721: l_temp_number := l_task_weight;
8714: -- or below -0.01 just increase or decrease the task weightage of the child task being processed by 0.01
8715: -- 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
8716: IF l_debug_mode = 'Y' THEN
8717: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
8718: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8719: END IF;
8720:
8721: l_temp_number := l_task_weight;
8722:
8720:
8721: l_temp_number := l_task_weight;
8722:
8723: IF l_debug_mode = 'Y' THEN
8724: pa_debug.g_err_stage:= 'Value of l_temp_number' || l_temp_number;
8725: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8726: END IF;
8727:
8728: l_diff_number := l_task_weight - l_temp_number;
8721: l_temp_number := l_task_weight;
8722:
8723: IF l_debug_mode = 'Y' THEN
8724: pa_debug.g_err_stage:= 'Value of l_temp_number' || l_temp_number;
8725: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8726: END IF;
8727:
8728: l_diff_number := l_task_weight - l_temp_number;
8729:
8727:
8728: l_diff_number := l_task_weight - l_temp_number;
8729:
8730: IF l_debug_mode = 'Y' THEN
8731: pa_debug.g_err_stage:= 'Value of l_diff_number' || l_diff_number;
8732: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8733: END IF;
8734:
8735: IF(l_diff_number <> 0) THEN
8728: l_diff_number := l_task_weight - l_temp_number;
8729:
8730: IF l_debug_mode = 'Y' THEN
8731: pa_debug.g_err_stage:= 'Value of l_diff_number' || l_diff_number;
8732: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8733: END IF;
8734:
8735: IF(l_diff_number <> 0) THEN
8736:
8734:
8735: IF(l_diff_number <> 0) THEN
8736:
8737: IF l_debug_mode = 'Y' THEN
8738: pa_debug.g_err_stage:= 'Value of l_parent_element_version_id' || l_parent_element_version_id;
8739: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8740: END IF;
8741:
8742: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
8735: IF(l_diff_number <> 0) THEN
8736:
8737: IF l_debug_mode = 'Y' THEN
8738: pa_debug.g_err_stage:= 'Value of l_parent_element_version_id' || l_parent_element_version_id;
8739: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8740: END IF;
8741:
8742: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
8743: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8742: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
8743: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8744:
8745: IF l_debug_mode = 'Y' THEN
8746: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
8747: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8748:
8749: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
8750: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8743: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8744:
8745: IF l_debug_mode = 'Y' THEN
8746: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
8747: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8748:
8749: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
8750: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8751: END IF;
8745: IF l_debug_mode = 'Y' THEN
8746: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
8747: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8748:
8749: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
8750: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8751: END IF;
8752: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
8753: l_task_weight := l_task_weight + 0.01;
8746: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
8747: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8748:
8749: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
8750: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8751: END IF;
8752: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
8753: l_task_weight := l_task_weight + 0.01;
8754: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
8752: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
8753: l_task_weight := l_task_weight + 0.01;
8754: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
8755: IF l_debug_mode = 'Y' THEN
8756: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
8757: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8758: END IF;
8759: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
8760: l_task_weight := l_task_weight - 0.01;
8753: l_task_weight := l_task_weight + 0.01;
8754: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
8755: IF l_debug_mode = 'Y' THEN
8756: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
8757: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8758: END IF;
8759: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
8760: l_task_weight := l_task_weight - 0.01;
8761: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
8759: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
8760: l_task_weight := l_task_weight - 0.01;
8761: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
8762: IF l_debug_mode = 'Y' THEN
8763: pa_debug.g_err_stage:= 'In else IF Value of l_task_weight' || l_task_weight;
8764: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8765: END IF;
8766: ELSE
8767: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8760: l_task_weight := l_task_weight - 0.01;
8761: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
8762: IF l_debug_mode = 'Y' THEN
8763: pa_debug.g_err_stage:= 'In else IF Value of l_task_weight' || l_task_weight;
8764: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8765: END IF;
8766: ELSE
8767: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8768: IF l_debug_mode = 'Y' THEN
8765: END IF;
8766: ELSE
8767: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8768: IF l_debug_mode = 'Y' THEN
8769: pa_debug.g_err_stage:= 'in else Value of l_task_weight' || l_task_weight;
8770: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8771: END IF;
8772: END IF;
8773: ELSE
8766: ELSE
8767: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8768: IF l_debug_mode = 'Y' THEN
8769: pa_debug.g_err_stage:= 'in else Value of l_task_weight' || l_task_weight;
8770: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8771: END IF;
8772: END IF;
8773: ELSE
8774: l_task_weightage_tbl(l_parent_element_version_id) := l_diff_number;
8774: l_task_weightage_tbl(l_parent_element_version_id) := l_diff_number;
8775: END IF;
8776:
8777: IF l_debug_mode = 'Y' THEN
8778: pa_debug.g_err_stage:= 'Value of task_weightage_tbl' || l_task_weightage_tbl(l_parent_element_version_id);
8779: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8780: END IF;
8781:
8782: END IF;
8775: END IF;
8776:
8777: IF l_debug_mode = 'Y' THEN
8778: pa_debug.g_err_stage:= 'Value of task_weightage_tbl' || l_task_weightage_tbl(l_parent_element_version_id);
8779: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8780: END IF;
8781:
8782: END IF;
8783:
8872: -- or below -0.01 just increase or decrease the task weightage of the child task being processed by 0.01
8873: -- 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
8874:
8875: IF l_debug_mode = 'Y' THEN
8876: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
8877: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8878: END IF;
8879:
8880: l_temp_number := l_task_weight;
8873: -- 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
8874:
8875: IF l_debug_mode = 'Y' THEN
8876: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
8877: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8878: END IF;
8879:
8880: l_temp_number := l_task_weight;
8881:
8879:
8880: l_temp_number := l_task_weight;
8881:
8882: IF l_debug_mode = 'Y' THEN
8883: pa_debug.g_err_stage:= 'Value of l_temp_number' || l_temp_number;
8884: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8885: END IF;
8886:
8887: l_diff_number := l_task_weight - l_temp_number;
8880: l_temp_number := l_task_weight;
8881:
8882: IF l_debug_mode = 'Y' THEN
8883: pa_debug.g_err_stage:= 'Value of l_temp_number' || l_temp_number;
8884: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8885: END IF;
8886:
8887: l_diff_number := l_task_weight - l_temp_number;
8888:
8886:
8887: l_diff_number := l_task_weight - l_temp_number;
8888:
8889: IF l_debug_mode = 'Y' THEN
8890: pa_debug.g_err_stage:= 'Value of l_diff_number' || l_diff_number;
8891: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8892: END IF;
8893:
8894: IF(l_diff_number <> 0) THEN
8887: l_diff_number := l_task_weight - l_temp_number;
8888:
8889: IF l_debug_mode = 'Y' THEN
8890: pa_debug.g_err_stage:= 'Value of l_diff_number' || l_diff_number;
8891: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8892: END IF;
8893:
8894: IF(l_diff_number <> 0) THEN
8895:
8893:
8894: IF(l_diff_number <> 0) THEN
8895:
8896: IF l_debug_mode = 'Y' THEN
8897: pa_debug.g_err_stage:= 'Value of l_parent_element_version_id' || l_parent_element_version_id;
8898: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8899: END IF;
8900:
8901: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
8894: IF(l_diff_number <> 0) THEN
8895:
8896: IF l_debug_mode = 'Y' THEN
8897: pa_debug.g_err_stage:= 'Value of l_parent_element_version_id' || l_parent_element_version_id;
8898: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8899: END IF;
8900:
8901: IF l_task_weightage_tbl.exists(l_parent_element_version_id) THEN
8902:
8902:
8903: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8904:
8905: IF l_debug_mode = 'Y' THEN
8906: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
8907: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8908:
8909: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
8910: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8903: l_sum_temp_number := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8904:
8905: IF l_debug_mode = 'Y' THEN
8906: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
8907: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8908:
8909: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
8910: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8911: END IF;
8905: IF l_debug_mode = 'Y' THEN
8906: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
8907: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8908:
8909: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
8910: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8911: END IF;
8912:
8913: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
8906: pa_debug.g_err_stage:= 'Value of l_sum_temp_number' || l_sum_temp_number;
8907: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8908:
8909: pa_debug.g_err_stage:= 'Value of l_constant_temp_number' || l_constant_temp_number;
8910: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8911: END IF;
8912:
8913: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
8914: l_task_weight := l_task_weight + 0.01;
8913: IF( l_sum_temp_number >= l_constant_temp_number ) THEN
8914: l_task_weight := l_task_weight + 0.01;
8915: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
8916: IF l_debug_mode = 'Y' THEN
8917: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
8918: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8919: END IF;
8920: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
8921: l_task_weight := l_task_weight - 0.01;
8914: l_task_weight := l_task_weight + 0.01;
8915: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number - 0.01;
8916: IF l_debug_mode = 'Y' THEN
8917: pa_debug.g_err_stage:= 'Value of l_task_weight' || l_task_weight;
8918: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8919: END IF;
8920: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
8921: l_task_weight := l_task_weight - 0.01;
8922: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
8920: ELSIF ( l_sum_temp_number <= -l_constant_temp_number ) THEN
8921: l_task_weight := l_task_weight - 0.01;
8922: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
8923: IF l_debug_mode = 'Y' THEN
8924: pa_debug.g_err_stage:= 'In else IF Value of l_task_weight' || l_task_weight;
8925: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8926: END IF;
8927: ELSE
8928: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8921: l_task_weight := l_task_weight - 0.01;
8922: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number + 0.01;
8923: IF l_debug_mode = 'Y' THEN
8924: pa_debug.g_err_stage:= 'In else IF Value of l_task_weight' || l_task_weight;
8925: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8926: END IF;
8927: ELSE
8928: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8929: IF l_debug_mode = 'Y' THEN
8926: END IF;
8927: ELSE
8928: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8929: IF l_debug_mode = 'Y' THEN
8930: pa_debug.g_err_stage:= 'in else Value of l_task_weight' || l_task_weight;
8931: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8932: END IF;
8933: END IF;
8934: ELSE
8927: ELSE
8928: l_task_weightage_tbl(l_parent_element_version_id) := l_task_weightage_tbl(l_parent_element_version_id) + l_diff_number;
8929: IF l_debug_mode = 'Y' THEN
8930: pa_debug.g_err_stage:= 'in else Value of l_task_weight' || l_task_weight;
8931: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8932: END IF;
8933: END IF;
8934: ELSE
8935: l_task_weightage_tbl(l_parent_element_version_id) := l_diff_number;
8935: l_task_weightage_tbl(l_parent_element_version_id) := l_diff_number;
8936: END IF;
8937:
8938: IF l_debug_mode = 'Y' THEN
8939: pa_debug.g_err_stage:= 'Value of task_weightage_tbl' || l_task_weightage_tbl(l_parent_element_version_id);
8940: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8941: END IF;
8942:
8943: END IF;
8936: END IF;
8937:
8938: IF l_debug_mode = 'Y' THEN
8939: pa_debug.g_err_stage:= 'Value of task_weightage_tbl' || l_task_weightage_tbl(l_parent_element_version_id);
8940: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8941: END IF;
8942:
8943: END IF;
8944: --End Changes for bug 3083950
8959:
8960: end LOOP;
8961:
8962: IF l_debug_mode = 'Y' THEN
8963: pa_debug.reset_curr_function;
8964: END IF;
8965:
8966: x_return_status := FND_API.G_RET_STS_SUCCESS;
8967: EXCEPTION
8970: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PUB1',
8971: p_procedure_name => 'CALC_TASK_WEIGHTS',
8972: p_error_text => SUBSTRB(SQLERRM,1,240));
8973: IF l_debug_mode = 'Y' THEN
8974: pa_debug.reset_curr_function;
8975: END IF;
8976:
8977: raise;
8978: END CALC_TASK_WEIGHTS;
9022: IS
9023:
9024: BEGIN
9025:
9026: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK_WEIGHTING');
9027:
9028: IF (p_debug_mode = 'Y') THEN
9029: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_WEIGHTING begin');
9030: END IF;
9025:
9026: pa_debug.init_err_stack ('PA_TASK_PUB1.UPDATE_TASK_WEIGHTING');
9027:
9028: IF (p_debug_mode = 'Y') THEN
9029: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_WEIGHTING begin');
9030: END IF;
9031:
9032: IF (p_commit = FND_API.G_TRUE) THEN
9033: savepoint update_task_weighting;
9371: --bug 4214825, end
9372:
9373: BEGIN
9374:
9375: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK');
9376:
9377: IF (p_debug_mode = 'Y') THEN
9378: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK begin');
9379: END IF;
9374:
9375: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK');
9376:
9377: IF (p_debug_mode = 'Y') THEN
9378: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK begin');
9379: END IF;
9380:
9381: IF (p_commit = FND_API.G_TRUE) THEN
9382: savepoint indent_task_version_bulk;
10510: COMMIT;
10511: END IF;
10512:
10513: IF (p_debug_mode = 'Y') THEN
10514: pa_debug.debug('PA_TASK_PUB1.INDENT_TASK_VERSION_BULK END');
10515: END IF;
10516:
10517: EXCEPTION
10518: when FND_API.G_EXC_ERROR then
10877: l_fin_task_flag VARCHAR2(1);
10878:
10879: BEGIN
10880:
10881: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK');
10882:
10883: IF (p_debug_mode = 'Y') THEN
10884: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK begin');
10885: END IF;
10880:
10881: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK');
10882:
10883: IF (p_debug_mode = 'Y') THEN
10884: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK begin');
10885: END IF;
10886:
10887: IF (p_commit = FND_API.G_TRUE) THEN
10888: savepoint OUTDENT_task_version_bulk;
11053: , src_proj_element_id
11054: , p_task_version_id),'N') = 'Y') then
11055:
11056: IF (p_debug_mode = 'Y') THEN
11057: pa_debug.debug('ERROR !!! PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK ');
11058: END IF;
11059:
11060: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
11061: p_msg_name => 'PA_PS_TASK_HAS_SUB_PROJ');
12147: COMMIT;
12148: END IF;
12149:
12150: IF (p_debug_mode = 'Y') THEN
12151: pa_debug.debug('PA_TASK_PUB1.OUTDENT_TASK_VERSION_BULK END');
12152: END IF;
12153:
12154: EXCEPTION
12155: when FND_API.G_EXC_ERROR then
12247: x_return_status := FND_API.G_RET_STS_SUCCESS;
12248:
12249: l_msg_count := 0;
12250: l_return_status := FND_API.G_RET_STS_SUCCESS;
12251: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N') ; -- Bug # 4605505.
12252: j := 0 ;
12253:
12254: --hsiu: commenting out due to p1 issue.
12255: -- savepoint should be issued only when p_commit
12258:
12259: FOR i in reverse p_task_version_id_tbl.FIRST..p_task_version_id_tbl.LAST LOOP
12260:
12261: IF l_debug_mode = 'Y' THEN
12262: pa_debug.debug('task id is :'||p_task_version_id_tbl(i));
12263: pa_debug.debug('record version id is :'||p_record_version_number_tbl(i));
12264: END IF ;
12265:
12266: -- initialization is required for every loop
12259: FOR i in reverse p_task_version_id_tbl.FIRST..p_task_version_id_tbl.LAST LOOP
12260:
12261: IF l_debug_mode = 'Y' THEN
12262: pa_debug.debug('task id is :'||p_task_version_id_tbl(i));
12263: pa_debug.debug('record version id is :'||p_record_version_number_tbl(i));
12264: END IF ;
12265:
12266: -- initialization is required for every loop
12267: l_return_status := FND_API.G_RET_STS_SUCCESS ;
12347:
12348:
12349:
12350: IF l_debug_mode = 'Y' THEN
12351: pa_debug.reset_curr_function;
12352: END IF ;
12353:
12354: EXCEPTION
12355: WHEN NO_DATA_FOUND THEN
12372: FND_MSG_PUB.add_exc_msg
12373: ( p_pkg_name => 'PA_TASK_PUB1'
12374: ,p_procedure_name => 'DELETE_TASK_VERSION_IN_BULK' );
12375: IF l_debug_mode = 'Y' THEN
12376: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,SQLERRM,4);
12377: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,pa_debug.G_Err_Stack,4);
12378: pa_debug.reset_curr_function;
12379: END IF;
12380: RAISE ;
12373: ( p_pkg_name => 'PA_TASK_PUB1'
12374: ,p_procedure_name => 'DELETE_TASK_VERSION_IN_BULK' );
12375: IF l_debug_mode = 'Y' THEN
12376: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,SQLERRM,4);
12377: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,pa_debug.G_Err_Stack,4);
12378: pa_debug.reset_curr_function;
12379: END IF;
12380: RAISE ;
12381:
12374: ,p_procedure_name => 'DELETE_TASK_VERSION_IN_BULK' );
12375: IF l_debug_mode = 'Y' THEN
12376: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,SQLERRM,4);
12377: pa_debug.write('DELETE_TASK_VERSION_IN_BULK' || G_PKG_NAME,pa_debug.G_Err_Stack,4);
12378: pa_debug.reset_curr_function;
12379: END IF;
12380: RAISE ;
12381:
12382: END DELETE_TASK_VERSION_IN_BULK ;
12431:
12432: x_return_status := FND_API.G_RET_STS_SUCCESS;
12433:
12434: IF (p_debug_mode = 'Y') THEN
12435: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_ASSOCIATION START');
12436: END IF;
12437:
12438: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
12439: FND_MSG_PUB.initialize;
12541: END IF;
12542: END IF;
12543:
12544: IF (p_debug_mode = 'Y') THEN
12545: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_ASSOCIATION END');
12546: END IF;
12547:
12548:
12549: EXCEPTION
12604: BEGIN
12605: x_return_status := FND_API.G_RET_STS_SUCCESS;
12606:
12607: IF (p_debug_mode = 'Y') THEN
12608: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_ASSOCIATION START');
12609: END IF;
12610:
12611: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
12612: FND_MSG_PUB.initialize;
12650: END IF;
12651:
12652:
12653: IF (p_debug_mode = 'Y') THEN
12654: pa_debug.debug('PA_TASK_PUB1.DELETE_TASK_ASSOCIATIONS END');
12655: END IF;
12656:
12657:
12658: EXCEPTION
12858: BEGIN
12859: x_return_status := FND_API.G_RET_STS_SUCCESS;
12860:
12861: IF (p_debug_mode = 'Y') THEN
12862: pa_debug.debug('PA_TASK_PUB1.Delete_Proj_To_Task_Assoc START');
12863: END IF;
12864: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
12865: FND_MSG_PUB.initialize;
12866: END IF;
12902: END IF;
12903: END IF;
12904:
12905: IF (p_debug_mode = 'Y') THEN
12906: pa_debug.debug('PA_TASK_PUB1.Delete_Proj_To_Task_Assoc END');
12907: END IF;
12908:
12909: EXCEPTION
12910: WHEN FND_API.G_EXC_ERROR THEN
12975:
12976: BEGIN
12977:
12978: IF (p_debug_mode = 'Y') THEN
12979: pa_debug.debug('PA_TASK_PUB1.Copy_Task_Associations START');
12980: END IF;
12981:
12982: x_return_status := FND_API.G_RET_STS_SUCCESS;
12983:
13049: END IF;
13050: END IF;
13051:
13052: IF (p_debug_mode = 'Y') THEN
13053: pa_debug.debug('PA_TASK_PUB1.Copy_Task_Associations END');
13054: END IF;
13055:
13056: EXCEPTION
13057: WHEN FND_API.G_EXC_ERROR THEN
13461:
13462: BEGIN
13463:
13464: IF (p_debug_mode = 'Y') THEN
13465: pa_debug.debug('PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO begin');
13466: END IF;
13467:
13468: IF (p_commit = FND_API.G_TRUE) THEN
13469: savepoint UPDATE_task_det_sch;
13468: IF (p_commit = FND_API.G_TRUE) THEN
13469: savepoint UPDATE_task_det_sch;
13470: END IF;
13471:
13472: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
13473:
13474: IF l_debug_mode = 'Y' THEN
13475: 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);
13476: 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);
13471:
13472: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
13473:
13474: IF l_debug_mode = 'Y' THEN
13475: 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);
13476: 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);
13477: 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);
13478: 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);
13479: 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);
13472: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
13473:
13474: IF l_debug_mode = 'Y' THEN
13475: 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);
13476: 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);
13477: 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);
13478: 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);
13479: 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);
13480: 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);
13473:
13474: IF l_debug_mode = 'Y' THEN
13475: 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);
13476: 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);
13477: 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);
13478: 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);
13479: 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);
13480: 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);
13481: 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);
13474: IF l_debug_mode = 'Y' THEN
13475: 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);
13476: 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);
13477: 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);
13478: 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);
13479: 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);
13480: 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);
13481: 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);
13482: 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);
13475: 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);
13476: 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);
13477: 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);
13478: 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);
13479: 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);
13480: 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);
13481: 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);
13482: 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);
13483: 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);
13476: 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);
13477: 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);
13478: 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);
13479: 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);
13480: 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);
13481: 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);
13482: 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);
13483: 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);
13484: 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);
13477: 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);
13478: 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);
13479: 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);
13480: 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);
13481: 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);
13482: 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);
13483: 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);
13484: 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);
13485: 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);
13478: 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);
13479: 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);
13480: 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);
13481: 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);
13482: 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);
13483: 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);
13484: 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);
13485: 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);
13486: 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);
13479: 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);
13480: 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);
13481: 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);
13482: 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);
13483: 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);
13484: 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);
13485: 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);
13486: 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);
13487: END IF;
13480: 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);
13481: 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);
13482: 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);
13483: 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);
13484: 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);
13485: 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);
13486: 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);
13487: END IF;
13488:
13481: 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);
13482: 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);
13483: 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);
13484: 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);
13485: 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);
13486: 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);
13487: END IF;
13488:
13489: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id); --maansari5/9
13482: 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);
13483: 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);
13484: 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);
13485: 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);
13486: 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);
13487: END IF;
13488:
13489: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id); --maansari5/9
13490:
13523: -- End of Bug Fix 5726773
13524:
13525: -- END: Code to raise error if negative etc values or planned values are entered.
13526: IF l_debug_mode = 'Y' THEN
13527: 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);
13528: END IF;
13529:
13530: -- Get the task_id.
13531:
13535: where element_version_id = p_task_ver_id
13536: and parent_structure_version_id = p_structure_version_id;
13537:
13538: IF l_debug_mode = 'Y' THEN
13539: 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);
13540: END IF;
13541: --bug 3959087
13542: SELECT project_currency_code INTO l_prj_currency_code FROM pa_projects_all WHERE project_id = p_project_id;
13543:
13549: l_object_id := l_task_id;
13550: END IF;
13551:
13552: IF l_debug_mode = 'Y' THEN
13553: 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);
13554: END IF;
13555:
13556:
13557: -- Logic to make sure that planned value = etc value + actual value if etc is changed.
13575: close cur_prev_planned_task_effort;
13576: END IF;
13577:
13578: IF l_debug_mode = 'Y' THEN
13579: 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);
13580: END IF;
13581:
13582: -- Get previous etc value.
13583: --maansari5/9
13592: close cur_prev_etc_effort2;
13593: END IF;
13594:
13595: IF l_debug_mode = 'Y' THEN
13596: 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);
13597: END IF;
13598:
13599: --maansari5/9
13600:
13622: END IF;
13623: --bug 3959087, end
13624:
13625: IF l_debug_mode = 'Y' THEN
13626: 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);
13627: END IF;
13628:
13629: --maansari5/9
13630: IF (p_planned_effort <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
13683:
13684: --Bug#6144931 END
13685:
13686: IF l_debug_mode = 'Y' THEN
13687: 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);
13688: 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);
13689: END IF;
13690:
13691: --bug 3959087, start
13684: --Bug#6144931 END
13685:
13686: IF l_debug_mode = 'Y' THEN
13687: 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);
13688: 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);
13689: END IF;
13690:
13691: --bug 3959087, start
13692: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );
13692: l_lowest_level_task := PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_task_ver_id );
13693: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');
13694:
13695: IF l_debug_mode = 'Y' THEN
13696: 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);
13697: 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);
13698: END IF;
13699: --bug 3959087, end
13700:
13693: l_assignment_exists := PA_PROGRESS_UTILS.check_assignment_exists(p_project_id, p_task_ver_id, 'PA_TASKS');
13694:
13695: IF l_debug_mode = 'Y' THEN
13696: 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);
13697: 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);
13698: END IF;
13699: --bug 3959087, end
13700:
13701: -- Call: pa_fp_planning_transaction_pub.update_planning_transactions().
13713: OPEN cur_sch;
13714: FETCH cur_sch INTO l_SCHEDULED_START_DATE, l_SCHEDULED_END_DATE;
13715: CLOSE cur_sch;
13716: IF l_debug_mode = 'Y' THEN
13717: 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);
13718: 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);
13719: END IF;
13720:
13721: l_task_ver_ids2.extend(1);
13714: FETCH cur_sch INTO l_SCHEDULED_START_DATE, l_SCHEDULED_END_DATE;
13715: CLOSE cur_sch;
13716: IF l_debug_mode = 'Y' THEN
13717: 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);
13718: 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);
13719: END IF;
13720:
13721: l_task_ver_ids2.extend(1);
13722: l_planned_effort2.extend(1);
13743: BEGIN
13744: IF NVL(l_prev_planned_effort,0) <> NVL(l_planned_effort,0)
13745: THEN
13746: IF l_debug_mode = 'Y' THEN
13747: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
13748: 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);
13749: 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);
13750: 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);
13751: 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);
13744: IF NVL(l_prev_planned_effort,0) <> NVL(l_planned_effort,0)
13745: THEN
13746: IF l_debug_mode = 'Y' THEN
13747: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
13748: 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);
13749: 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);
13750: 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);
13751: 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);
13752: END IF;
13745: THEN
13746: IF l_debug_mode = 'Y' THEN
13747: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
13748: 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);
13749: 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);
13750: 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);
13751: 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);
13752: END IF;
13753:
13746: IF l_debug_mode = 'Y' THEN
13747: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
13748: 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);
13749: 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);
13750: 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);
13751: 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);
13752: END IF;
13753:
13754: pa_fp_planning_transaction_pub.update_planning_transactions
13747: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling update_planning_transactions', x_Log_Level=> 3);
13748: 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);
13749: 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);
13750: 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);
13751: 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);
13752: END IF;
13753:
13754: pa_fp_planning_transaction_pub.update_planning_transactions
13755: (
13785:
13786:
13787: l_next_prog_cycle_date := pa_progress_utils.get_next_progress_cycle(p_project_id => p_project_id , p_task_id => l_task_id);
13788: IF l_debug_mode = 'Y' THEN
13789: 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);
13790: END IF;
13791:
13792:
13793: IF (nvl(p_percent_complete,0) > 0 AND p_percent_complete <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM)
13846: OPEN cur_proj_elements(l_task_id);
13847: FETCH cur_proj_elements INTO l_BASE_PERCENT_COMP_DERIV_CODE;
13848: CLOSE cur_proj_elements;
13849: IF l_debug_mode = 'Y' THEN
13850: 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);
13851: END IF;
13852:
13853: IF l_BASE_PERCENT_COMP_DERIV_CODE = 'EFFORT'
13854: THEN
13867: FETCH cur_get_costs INTO l_planned_cost, l_ppl_act_cost;
13868: CLOSE cur_get_costs;
13869:
13870: IF l_debug_mode = 'Y' THEN
13871: 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);
13872: 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);
13873: END IF;
13874: IF (l_planned_cost <> 0)
13875: THEN
13868: CLOSE cur_get_costs;
13869:
13870: IF l_debug_mode = 'Y' THEN
13871: 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);
13872: 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);
13873: END IF;
13874: IF (l_planned_cost <> 0)
13875: THEN
13876: l_eff_rollup_pc := round((l_ppl_act_cost/l_planned_cost)*100, 2);
13895:
13896: --bug 3959087, calculate percent complete for lowest level tasks only, depending on derivation code, end
13897:
13898: IF l_debug_mode = 'Y' THEN
13899: 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);
13900: 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);
13901: 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);
13902: 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);
13903: END IF;
13896: --bug 3959087, calculate percent complete for lowest level tasks only, depending on derivation code, end
13897:
13898: IF l_debug_mode = 'Y' THEN
13899: 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);
13900: 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);
13901: 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);
13902: 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);
13903: END IF;
13904:
13897:
13898: IF l_debug_mode = 'Y' THEN
13899: 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);
13900: 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);
13901: 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);
13902: 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);
13903: END IF;
13904:
13905:
13898: IF l_debug_mode = 'Y' THEN
13899: 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);
13900: 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);
13901: 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);
13902: 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);
13903: END IF;
13904:
13905:
13906: OPEN c_get_task_weight_method;
13925: END IF;
13926: --bug 3959087, end
13927:
13928: IF l_debug_mode = 'Y' THEN
13929: 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);
13930: END IF;
13931:
13932: --END IF; Bug 3856161
13933:
13947: l_actual_finish_DATE := nvl(l_actual_finish_date,l_SCHEDULED_END_DATE);
13948: END IF;
13949:
13950: IF l_debug_mode = 'Y' THEN
13951: 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);
13952: 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);
13953: END IF;
13954:
13955: -- Progress Management Changes, Bug # 3420093.
13948: END IF;
13949:
13950: IF l_debug_mode = 'Y' THEN
13951: 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);
13952: 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);
13953: END IF;
13954:
13955: -- Progress Management Changes, Bug # 3420093.
13956: -- If workplan versioning is disabled for the project.
14393:
14394:
14395: -- Call rollup_progress_pvt api for this task.
14396: IF l_debug_mode = 'Y' THEN
14397: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14398: 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);
14399: 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);
14400: 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);
14401: 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);
14394:
14395: -- Call rollup_progress_pvt api for this task.
14396: IF l_debug_mode = 'Y' THEN
14397: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14398: 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);
14399: 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);
14400: 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);
14401: 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);
14402: 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);
14395: -- Call rollup_progress_pvt api for this task.
14396: IF l_debug_mode = 'Y' THEN
14397: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14398: 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);
14399: 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);
14400: 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);
14401: 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);
14402: 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);
14403: END IF;
14396: IF l_debug_mode = 'Y' THEN
14397: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14398: 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);
14399: 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);
14400: 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);
14401: 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);
14402: 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);
14403: END IF;
14404:
14397: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Tasks', x_Log_Level=> 3);
14398: 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);
14399: 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);
14400: 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);
14401: 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);
14402: 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);
14403: END IF;
14404:
14405: -- 4591321 : Always call populate_pji_tab_for_plan
14398: 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);
14399: 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);
14400: 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);
14401: 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);
14402: 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);
14403: END IF;
14404:
14405: -- 4591321 : Always call populate_pji_tab_for_plan
14406: pa_progress_pub.populate_pji_tab_for_plan(
14455:
14456: -- Call rollup API only is there is a working progress for the given task_version and
14457: -- structure_version. The as_of_date will then be the max(as_of_date() of the working progress.
14458: IF l_debug_mode = 'Y' THEN
14459: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Entered For Assignments', x_Log_Level=> 3);
14460: END IF;
14461:
14462: --bug 4105720, get the task id
14463: OPEN c_proj_element_id;
14469: FETCH cur_progress_exists INTO l_progress_exists;
14470: CLOSE cur_progress_exists;
14471:
14472: IF l_debug_mode = 'Y' THEN
14473: 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);
14474: 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);
14475: END IF;
14476:
14477: IF NVL(l_progress_exists, 'N') = 'Y' THEN -- Bug 3976633
14470: CLOSE cur_progress_exists;
14471:
14472: IF l_debug_mode = 'Y' THEN
14473: 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);
14474: 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);
14475: END IF;
14476:
14477: IF NVL(l_progress_exists, 'N') = 'Y' THEN -- Bug 3976633
14478:
14492: FETCH c_proj_element_id INTO l_task_id;
14493: CLOSE c_proj_element_id;*/
14494:
14495: IF l_debug_mode = 'Y' THEN
14496: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
14497: 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);
14498: 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);
14499: 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);
14500: 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);
14493: CLOSE c_proj_element_id;*/
14494:
14495: IF l_debug_mode = 'Y' THEN
14496: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
14497: 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);
14498: 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);
14499: 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);
14500: 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);
14501: 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);
14494:
14495: IF l_debug_mode = 'Y' THEN
14496: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
14497: 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);
14498: 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);
14499: 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);
14500: 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);
14501: 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);
14502: END IF;
14495: IF l_debug_mode = 'Y' THEN
14496: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
14497: 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);
14498: 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);
14499: 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);
14500: 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);
14501: 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);
14502: END IF;
14503: -- 4591321 : Always call populate_pji_tab_for_plan
14496: pa_debug.write(x_Module=>'PA_TASK_PUB1.UPDATE_TASK_DET_SCH_INFO', x_Msg => 'Calling Rollup For Assignments', x_Log_Level=> 3);
14497: 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);
14498: 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);
14499: 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);
14500: 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);
14501: 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);
14502: END IF;
14503: -- 4591321 : Always call populate_pji_tab_for_plan
14504:
14497: 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);
14498: 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);
14499: 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);
14500: 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);
14501: 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);
14502: END IF;
14503: -- 4591321 : Always call populate_pji_tab_for_plan
14504:
14505: pa_progress_pub.populate_pji_tab_for_plan(
14731: SELECT pm_product_code
14732: FROM PA_PROJECTS_ALL
14733: WHERE project_id = c_project_id;
14734: BEGIN
14735: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASKS_IN_BULK');
14736: x_return_status := FND_API.G_RET_STS_SUCCESS;
14737: IF (p_debug_mode = 'Y') THEN
14738: pa_debug.debug('PA_TASK_PUB1.COPY_TASKS_IN_BULK begin');
14739: END IF;
14734: BEGIN
14735: pa_debug.init_err_stack ('PA_TASK_PUB1.COPY_TASKS_IN_BULK');
14736: x_return_status := FND_API.G_RET_STS_SUCCESS;
14737: IF (p_debug_mode = 'Y') THEN
14738: pa_debug.debug('PA_TASK_PUB1.COPY_TASKS_IN_BULK begin');
14739: END IF;
14740:
14741: IF (p_commit = FND_API.G_TRUE) THEN
14742: savepoint copy_tasks_in_bulk;
15207:
15208: /*4269830 : Performance Enhancements : End*/
15209:
15210: BEGIN
15211: pa_debug.init_err_stack ('PA_TASK_PUB1.MOVE_TASK_VERSIONS_IN_BULK');
15212:
15213: x_return_status := FND_API.G_RET_STS_SUCCESS ;
15214:
15215: IF (p_debug_mode = 'Y') THEN
15212:
15213: x_return_status := FND_API.G_RET_STS_SUCCESS ;
15214:
15215: IF (p_debug_mode = 'Y') THEN
15216: pa_debug.debug('PA_TASK_PUB1.MOVE_TASK_VERSIONS_IN_BULK begin');
15217: END IF;
15218:
15219: IF (p_commit = FND_API.G_TRUE) THEN
15220: savepoint MOVE_TASK_VERSIONS_IN_BULK ;
15491: l_data VARCHAR2(250);
15492: l_msg_index_out NUMBER;
15493:
15494: BEGIN
15495: pa_debug.init_err_stack ('PA_TASK_PUB1.Update_Task_All_Info');
15496:
15497: IF (p_debug_mode = 'Y') THEN
15498: pa_debug.debug('PA_TASK_PUB1.Update_Task_All_Info begin');
15499: END IF;
15494: BEGIN
15495: pa_debug.init_err_stack ('PA_TASK_PUB1.Update_Task_All_Info');
15496:
15497: IF (p_debug_mode = 'Y') THEN
15498: pa_debug.debug('PA_TASK_PUB1.Update_Task_All_Info begin');
15499: END IF;
15500:
15501: IF (p_commit = FND_API.G_TRUE) THEN
15502: savepoint update_Task_all_info;
15665: COMMIT;
15666: END IF;
15667:
15668: IF (p_debug_mode = 'Y') THEN
15669: pa_debug.debug('PA_TASK_PUB1.Update_Task_All_Info END');
15670: END IF;
15671:
15672: EXCEPTION
15673: when FND_API.G_EXC_ERROR then
15794: l_version_enabled VARCHAR2(1);
15795:
15796: BEGIN
15797: x_return_status := FND_API.G_RET_STS_SUCCESS;
15798: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
15799: SAVEPOINT CANCEL_TASK_SP;
15800:
15801: IF l_debug_mode = 'Y' THEN
15802: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
15798: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
15799: SAVEPOINT CANCEL_TASK_SP;
15800:
15801: IF l_debug_mode = 'Y' THEN
15802: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
15803: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
15804: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
15805: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
15806: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
15799: SAVEPOINT CANCEL_TASK_SP;
15800:
15801: IF l_debug_mode = 'Y' THEN
15802: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
15803: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
15804: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
15805: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
15806: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
15807: END IF;
15800:
15801: IF l_debug_mode = 'Y' THEN
15802: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
15803: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
15804: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
15805: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
15806: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
15807: END IF;
15808:
15801: IF l_debug_mode = 'Y' THEN
15802: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
15803: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
15804: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
15805: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
15806: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
15807: END IF;
15808:
15809: IF p_init_msg_list = 'T' THEN
15802: pa_debug.write(l_module_name,'Cancel Task Passed Parameters', 3);
15803: pa_debug.write(l_module_name,'p_task_id='||p_task_id, 3);
15804: pa_debug.write(l_module_name,'p_task_version_id='||p_task_version_id, 3);
15805: pa_debug.write(l_module_name,'p_project_id='||p_project_id, 3);
15806: pa_debug.write(l_module_name,'p_cancel_status_code='||p_cancel_status_code, 3);
15807: END IF;
15808:
15809: IF p_init_msg_list = 'T' THEN
15810: FND_MSG_PUB.initialize;
15810: FND_MSG_PUB.initialize;
15811: END IF;
15812:
15813: IF l_debug_mode = 'Y' THEN
15814: pa_debug.write(l_module_name,'Calling Check_chg_stat_cancel_ok', 3);
15815: END IF;
15816:
15817: PA_PROJ_ELEMENTS_UTILS.Check_chg_stat_cancel_ok
15818: (
15823: ,x_error_message_code => l_error_message_code
15824: );
15825:
15826: IF l_debug_mode = 'Y' THEN
15827: pa_debug.write(l_module_name,'After Call Check_chg_stat_cancel_ok x_return_status='||x_return_status, 3);
15828: END IF;
15829:
15830: IF (x_return_status <> 'S') THEN
15831: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
15832: p_msg_name => l_error_message_code);
15833: raise FND_API.G_EXC_ERROR;
15834: END IF;
15835: IF l_debug_mode = 'Y' THEN
15836: pa_debug.write(l_module_name,'Calling set_new_tasks_to_TBD', 3);
15837: END IF;
15838:
15839: PA_TASK_PVT1.set_new_tasks_to_tbd(
15840: p_project_id => p_project_id
15844: ,x_msg_count => x_msg_count
15845: ,x_msg_data => x_msg_data);
15846:
15847: IF l_debug_mode = 'Y' THEN
15848: pa_debug.write(l_module_name,'After Call set_new_tasks_to_TBD x_return_status='||x_return_status, 3);
15849: END IF;
15850:
15851: IF (x_return_status <> 'S') THEN
15852: raise FND_API.G_EXC_ERROR;
15852: raise FND_API.G_EXC_ERROR;
15853: END IF;
15854:
15855: IF l_debug_mode = 'Y' THEN
15856: pa_debug.write(l_module_name,'Calling push_down_task_status', 3);
15857: END IF;
15858:
15859: PA_PROGRESS_PUB.push_down_task_status(
15860: p_calling_module => p_calling_module
15867: ,x_msg_count => x_msg_count
15868: ,x_msg_data => x_msg_data
15869: );
15870: IF l_debug_mode = 'Y' THEN
15871: pa_debug.write(l_module_name,'After Call push_down_task_status x_return_status='||x_return_status, 3);
15872: END IF;
15873:
15874: IF (x_return_status <> 'S') THEN
15875: raise FND_API.G_EXC_ERROR;
15877:
15878: l_version_enabled := PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id);
15879:
15880: IF l_debug_mode = 'Y' THEN
15881: pa_debug.write(l_module_name,'Call Delete_SubProject_Association l_version_enabled='||l_version_enabled, 3);
15882: END IF;
15883:
15884: FOR l_all_tasks IN c_get_all_task_versions(p_task_id, p_project_id) LOOP
15885: IF l_debug_mode = 'Y' THEN
15882: END IF;
15883:
15884: FOR l_all_tasks IN c_get_all_task_versions(p_task_id, p_project_id) LOOP
15885: IF l_debug_mode = 'Y' THEN
15886: pa_debug.write(l_module_name,'l_all_tasks.element_version_id='||l_all_tasks.element_version_id, 3);
15887: pa_debug.write(l_module_name,'l_all_tasks.status_code='||l_all_tasks.status_code, 3);
15888: END IF;
15889: --4533534
15890: IF ((l_version_enabled = 'N') OR (l_version_enabled = 'Y' AND l_all_tasks.status_code = 'STRUCTURE_WORKING'))
15883:
15884: FOR l_all_tasks IN c_get_all_task_versions(p_task_id, p_project_id) LOOP
15885: IF l_debug_mode = 'Y' THEN
15886: pa_debug.write(l_module_name,'l_all_tasks.element_version_id='||l_all_tasks.element_version_id, 3);
15887: pa_debug.write(l_module_name,'l_all_tasks.status_code='||l_all_tasks.status_code, 3);
15888: END IF;
15889: --4533534
15890: IF ((l_version_enabled = 'N') OR (l_version_enabled = 'Y' AND l_all_tasks.status_code = 'STRUCTURE_WORKING'))
15891: THEN
15892: --4533534
15893: --FOR l_all_links IN c_get_links(l_all_tasks.element_version_id, p_project_id) LOOP
15894: FOR l_all_links IN c_get_links(l_all_tasks.element_version_id) LOOP
15895: IF l_debug_mode = 'Y' THEN
15896: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
15897: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
15898: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
15899: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15893: --FOR l_all_links IN c_get_links(l_all_tasks.element_version_id, p_project_id) LOOP
15894: FOR l_all_links IN c_get_links(l_all_tasks.element_version_id) LOOP
15895: IF l_debug_mode = 'Y' THEN
15896: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
15897: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
15898: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
15899: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15894: FOR l_all_links IN c_get_links(l_all_tasks.element_version_id) LOOP
15895: IF l_debug_mode = 'Y' THEN
15896: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
15897: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
15898: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
15899: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15895: IF l_debug_mode = 'Y' THEN
15896: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
15897: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
15898: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
15899: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15903: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
15896: pa_debug.write(l_module_name,'l_all_links.sub_project_id='||l_all_links.sub_project_id, 3);
15897: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
15898: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
15899: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15903: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
15904: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
15897: pa_debug.write(l_module_name,'l_all_links.sub_structure_ver_id='||l_all_links.sub_structure_ver_id, 3);
15898: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
15899: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15903: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
15904: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
15905: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
15898: --pa_debug.write(l_module_name,'l_all_links.parent_project_id='||l_all_links.parent_project_id, 3);
15899: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15903: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
15904: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
15905: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
15906: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
15899: --pa_debug.write(l_module_name,'l_all_links.parent_structure_ver_id='||l_all_links.parent_structure_ver_id, 3);
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15903: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
15904: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
15905: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
15906: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
15907: END IF;
15900: --pa_debug.write(l_module_name,'l_all_links.parent_task_version_id='||l_all_links.parent_task_version_id, 3);
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15903: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
15904: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
15905: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
15906: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
15907: END IF;
15908: --4533534
15901: --pa_debug.write(l_module_name,'l_all_links.parent_wbs_number='||l_all_links.parent_wbs_number, 3);
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15903: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
15904: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
15905: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
15906: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
15907: END IF;
15908: --4533534
15909: --IF ((l_version_enabled = 'N') OR (l_version_enabled = 'Y' AND NVL(l_all_links.task_unpub_ver_status_code,'WORKING') <> 'PUBLISHED'))
15902: pa_debug.write(l_module_name,'l_all_links.link_task_ver_id='||l_all_links.link_task_ver_id, 3);
15903: pa_debug.write(l_module_name,'l_all_links.object_relationship_id='||l_all_links.object_relationship_id, 3);
15904: pa_debug.write(l_module_name,'l_all_links.record_version_number='||l_all_links.record_version_number, 3);
15905: --pa_debug.write(l_module_name,'l_all_links.task_unpub_ver_status_code='||l_all_links.task_unpub_ver_status_code, 3);
15906: pa_debug.write(l_module_name,'l_all_links.relationship_type='||l_all_links.relationship_type, 3);
15907: END IF;
15908: --4533534
15909: --IF ((l_version_enabled = 'N') OR (l_version_enabled = 'Y' AND NVL(l_all_links.task_unpub_ver_status_code,'WORKING') <> 'PUBLISHED'))
15910:
15917: x_msg_count => x_msg_count,
15918: x_msg_data => x_msg_data
15919: );
15920: IF l_debug_mode = 'Y' THEN
15921: pa_debug.write(l_module_name,'After Call Delete_SubProject_Association x_return_status='||x_return_status, 3);
15922: END IF;
15923:
15924: IF (x_return_status <> 'S') THEN
15925: raise FND_API.G_EXC_ERROR;
16020: l_rec_task_attr l_cur_task_attr%rowtype;
16021:
16022: BEGIN
16023:
16024: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION');
16025:
16026: IF (p_debug_mode = 'Y') THEN
16027: pa_debug.debug('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION BEGIN');
16028: END IF;
16023:
16024: pa_debug.init_err_stack ('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION');
16025:
16026: IF (p_debug_mode = 'Y') THEN
16027: pa_debug.debug('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION BEGIN');
16028: END IF;
16029:
16030: IF (p_commit = FND_API.G_TRUE) THEN
16031: savepoint indent_multi_task_version;
16150: COMMIT;
16151: END IF;
16152:
16153: IF (p_debug_mode = 'Y') THEN
16154: pa_debug.debug('PA_TASK_PUB1.INDENT_MULTI_TASK_VERSION END');
16155: END IF;
16156:
16157: EXCEPTION
16158:
16252: l_rec_task_attr l_cur_task_attr%rowtype;
16253:
16254: BEGIN
16255:
16256: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION');
16257:
16258: IF (p_debug_mode = 'Y') THEN
16259: pa_debug.debug('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION BEGIN');
16260: END IF;
16255:
16256: pa_debug.init_err_stack ('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION');
16257:
16258: IF (p_debug_mode = 'Y') THEN
16259: pa_debug.debug('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION BEGIN');
16260: END IF;
16261:
16262: IF (p_commit = FND_API.G_TRUE) THEN
16263: savepoint outdent_multi_task_version;
16376: COMMIT;
16377: END IF;
16378:
16379: IF (p_debug_mode = 'Y') THEN
16380: pa_debug.debug('PA_TASK_PUB1.OUTDENT_MULTI_TASK_VERSION END');
16381: END IF;
16382:
16383: EXCEPTION
16384: