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

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_DEBUG

Line 309: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

305: i number;
306:
307:
308: BEGIN
309: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
310:
311: IF (l_debug_mode = 'Y') THEN
312: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Entered...', 3);
313: END IF;

Line 312: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Entered...', 3);

308: BEGIN
309: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
310:
311: IF (l_debug_mode = 'Y') THEN
312: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Entered...', 3);
313: END IF;
314:
315: IF (p_commit = FND_API.G_TRUE) THEN
316: savepoint Rollup_From_Subproject_PVT;

Line 320: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Performing validations...', 3);

316: savepoint Rollup_From_Subproject_PVT;
317: END IF;
318:
319: IF (l_debug_mode = 'Y') THEN
320: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Performing validations...', 3);
321: END IF;
322:
323: IF (p_element_versions.count = 0) THEN
324: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 354: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Inside Loop p_element_versions(i)='||p_element_versions(i-1), 3);

350: i:=i+1;
351: END IF;
352:
353: IF (l_debug_mode = 'Y') THEN
354: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Inside Loop p_element_versions(i)='||p_element_versions(i-1), 3);
355: END IF;
356: LOOP -- bug 5638103 loop3
357:
358: FETCH get_lnk_task INTO get_lnk_task_rec;

Line 430: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Updating task ver:'||get_lnk_task_rec.lnk_task_ver_id, 3);

426: -- Fix for Bug # 4385027.
427:
428: --end bug 4238036
429: IF (l_debug_mode = 'Y') THEN
430: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Updating task ver:'||get_lnk_task_rec.lnk_task_ver_id, 3);
431: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch start date='||l_parent_start_date, 3);
432: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch finish date='||l_parent_finish_date, 3);
433: END IF;
434:

Line 431: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch start date='||l_parent_start_date, 3);

427:
428: --end bug 4238036
429: IF (l_debug_mode = 'Y') THEN
430: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Updating task ver:'||get_lnk_task_rec.lnk_task_ver_id, 3);
431: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch start date='||l_parent_start_date, 3);
432: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch finish date='||l_parent_finish_date, 3);
433: END IF;
434:
435: -- Bug 6719725

Line 432: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch finish date='||l_parent_finish_date, 3);

428: --end bug 4238036
429: IF (l_debug_mode = 'Y') THEN
430: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Updating task ver:'||get_lnk_task_rec.lnk_task_ver_id, 3);
431: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch start date='||l_parent_start_date, 3);
432: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Sch finish date='||l_parent_finish_date, 3);
433: END IF;
434:
435: -- Bug 6719725
436: OPEN c_wh_generic_lock_cur(

Line 487: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Predicate = '||l_predicate, 3);

483: -- we will have predicate with not more than 1000
484: --params
485: --
486: IF (l_debug_mode = 'Y') THEN
487: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Predicate = '||l_predicate, 3);
488: END IF;
489: --
490: -- 5660584, pqe base bug 5638103
491: /* bug 5638103

Line 720: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates', 3);

716: END IF;
717: --bug 4153366
718:
719: IF (l_debug_mode = 'Y') THEN
720: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates', 3);
721: END IF;
722:
723: PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates(
724: p_element_version_id => l_elem_ver_id_tbl(i),

Line 736: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates x_return_status='||x_return_status, 3);

732: x_planning_end_tbl => l_planning_end_tbl,
733: x_return_status => x_return_status);
734:
735: IF (l_debug_mode = 'Y') THEN
736: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates x_return_status='||x_return_status, 3);
737: END IF;
738:
739: IF x_return_status = FND_API.G_RET_STS_ERROR then
740: RAISE FND_API.G_EXC_ERROR;

Line 786: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES', 3);

782: FETCH get_scheduled_dates into l_get_sch_dates_cur;
783: CLOSE get_scheduled_dates;
784:
785: IF (l_debug_mode = 'Y') THEN
786: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES', 3);
787: END IF;
788:
789: PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES (
790: p_validate_only => FND_API.G_FALSE

Line 801: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES x_return_status='||x_return_status, 3);

797: ,x_msg_count => x_msg_count
798: ,x_msg_data => x_msg_data );
799:
800: IF (l_debug_mode = 'Y') THEN
801: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES x_return_status='||x_return_status, 3);
802: END IF;
803:
804: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
805: RAISE FND_API.G_EXC_ERROR;

Line 812: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION', 3);

808:
809: IF (l_versioning = 'N') THEN
810: --baseline
811: IF (l_debug_mode = 'Y') THEN
812: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION', 3);
813: END IF;
814:
815: PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION(
816: p_commit => FND_API.G_FALSE,

Line 823: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION x_return_status='||x_return_status, 3);

819: x_msg_count => x_msg_count,
820: x_msg_data => x_msg_data);
821:
822: IF (l_debug_mode = 'Y') THEN
823: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION x_return_status='||x_return_status, 3);
824: END IF;
825:
826:
827: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 848: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES', 3);

844: (PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(l_struc_project_id) = 'SHARE_FULL')) AND
845: (l_versioning = 'N') THEN
846: --copy to transaction dates
847: IF (l_debug_mode = 'Y') THEN
848: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'Before calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES', 3);
849: END IF;
850:
851: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
852: p_validate_only => FND_API.G_FALSE

Line 860: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATESx_return_status='||x_return_status, 3);

856: ,x_msg_data => x_msg_data
857: );
858:
859: IF (l_debug_mode = 'Y') THEN
860: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATESx_return_status='||x_return_status, 3);
861: END IF;
862:
863: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
864: x_msg_count := FND_MSG_PUB.count_msg;

Line 938: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

934: l_debug_mode VARCHAR2(1);
935:
936: BEGIN
937:
938: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
939:
940: IF (l_debug_mode = 'Y') THEN
941: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.ROLLUP_FROM_SUBPROJECT', 'BEGIN', 3);
942: END IF;

Line 941: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.ROLLUP_FROM_SUBPROJECT', 'BEGIN', 3);

937:
938: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
939:
940: IF (l_debug_mode = 'Y') THEN
941: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.ROLLUP_FROM_SUBPROJECT', 'BEGIN', 3);
942: END IF;
943:
944: IF (p_element_versions.count = 0) THEN
945: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 948: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.ROLLUP_FROM_SUBPROJECT', 'p_element_versions.COUNT is 0', 3);

944: IF (p_element_versions.count = 0) THEN
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: IF (l_debug_mode = 'Y') THEN
948: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.ROLLUP_FROM_SUBPROJECT', 'p_element_versions.COUNT is 0', 3);
949: END IF;
950:
951: return;
952: END IF;

Line 974: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.ROLLUP_FROM_SUBPROJECT', 'END', 3);

970: x_msg_count => x_msg_count,
971: x_msg_data => x_msg_data);
972:
973: IF (l_debug_mode = 'Y') THEN
974: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.ROLLUP_FROM_SUBPROJECT', 'END', 3);
975: END IF;
976:
977: END Rollup_From_Subproject;
978:

Line 1024: pa_debug.debug('PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited BEGIN');

1020: l_count number :=0;
1021: BEGIN
1022:
1023: IF (p_debug_mode = 'Y') THEN
1024: pa_debug.debug('PA_STRUCT_TASK_ROLLUP_PUB.Tasks_Rollup_Unlimited BEGIN');
1025: END IF;
1026:
1027: IF (p_commit = FND_API.G_TRUE) THEN
1028: savepoint TASKS_ROLLUP_UNLIMITED_PUB;

Line 1370: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');--added by rtarway, 4218977

1366: --end bug 4541039
1367:
1368: begin
1369:
1370: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');--added by rtarway, 4218977
1371:
1372: IF (l_debug_mode = 'Y') THEN
1373: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP', 'Entered...', 3);
1374: END IF;

Line 1373: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP', 'Entered...', 3);

1369:
1370: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');--added by rtarway, 4218977
1371:
1372: IF (l_debug_mode = 'Y') THEN
1373: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP', 'Entered...', 3);
1374: END IF;
1375:
1376: IF (p_commit = FND_API.G_TRUE) THEN
1377: savepoint TASKS_ROLLUP_PVT;

Line 1381: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP', 'Performing validations',3);

1377: savepoint TASKS_ROLLUP_PVT;
1378: END IF;
1379:
1380: IF (l_debug_mode = 'Y') THEN
1381: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP', 'Performing validations',3);
1382: END IF;
1383:
1384: If (p_element_versions.count = 0) THEN
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1405: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Predicate = '||l_predicate,3);

1401: --dbms_output.put_line('Predicate => '||l_predicate);
1402: --dbms_output.put_line('Predicate2 => '||l_predicate2);
1403:
1404: IF (l_debug_mode = 'Y') THEN
1405: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Predicate = '||l_predicate,3);
1406: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Predicate2 = '||l_predicate2,3);
1407: END IF;
1408:
1409: --first select stmt - get all parents along the branch of the element

Line 1406: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Predicate2 = '||l_predicate2,3);

1402: --dbms_output.put_line('Predicate2 => '||l_predicate2);
1403:
1404: IF (l_debug_mode = 'Y') THEN
1405: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Predicate = '||l_predicate,3);
1406: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Predicate2 = '||l_predicate2,3);
1407: END IF;
1408:
1409: --first select stmt - get all parents along the branch of the element
1410: --second select stmt - get direct child of all parents

Line 1583: pa_debug.g_err_stage := 'Value of G_OP_VALIDATE_flag'||PA_PROJECT_PUB.G_OP_VALIDATE_FLAG ;

1579:
1580: close l_cur;
1581: --Added by rtarway, 4218977
1582: IF l_debug_mode = 'Y' THEN
1583: pa_debug.g_err_stage := 'Value of G_OP_VALIDATE_flag'||PA_PROJECT_PUB.G_OP_VALIDATE_FLAG ;
1584: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1585: END IF;
1586: --If Added by rtarway, BUG 4218977
1587: --Added null condition, for BUG 4226832

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

1580: close l_cur;
1581: --Added by rtarway, 4218977
1582: IF l_debug_mode = 'Y' THEN
1583: pa_debug.g_err_stage := 'Value of G_OP_VALIDATE_flag'||PA_PROJECT_PUB.G_OP_VALIDATE_FLAG ;
1584: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1585: END IF;
1586: --If Added by rtarway, BUG 4218977
1587: --Added null condition, for BUG 4226832
1588: if (PA_PROJECT_PUB.G_OP_VALIDATE_FLAG is null OR PA_PROJECT_PUB.G_OP_VALIDATE_FLAG = 'Y' ) then

Line 1629: pa_debug.debug('Binding: '||l_index||', id = '||l_rollup_table(l_index).object_id);

1625:
1626: l_index := l_rollup_table.First;
1627: LOOP
1628: IF (p_debug_mode = 'Y') THEN
1629: pa_debug.debug('Binding: '||l_index||', id = '||l_rollup_table(l_index).object_id);
1630: END IF;
1631: --dbms_output.put_line('Binding: '||l_index||', id = '||l_rollup_table(l_index).object_id);
1632:
1633: -- hyau l_duration := trunc(l_rollup_table(l_index).finish_date1 - l_rollup_table(l_index).start_date1) + 1;

Line 1721: pa_debug.debug('Updating linking task '||c1_rec.element_version_id);

1717: DBMS_SQL.BIND_VARIABLE(l_CursorId, ':pid', c1_rec.project_id);
1718: DBMS_SQL.BIND_VARIABLE(l_CursorId, ':evid', c1_rec.element_version_id);
1719:
1720: IF (p_debug_mode = 'Y') THEN
1721: pa_debug.debug('Updating linking task '||c1_rec.element_version_id);
1722: END IF;
1723: --dbms_output.put_line('Updating linking task '||c1_rec.element_version_id);
1724: --Update rows
1725: l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorId);

Line 1854: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates l_assgn_context = '||l_assgn_context,3);

1850: END IF;
1851: --bug 4153366
1852:
1853: IF (l_debug_mode = 'Y') THEN
1854: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates l_assgn_context = '||l_assgn_context,3);
1855: END IF;
1856:
1857: PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates(
1858: p_element_version_id => l_elem_ver_id_tbl(i),

Line 1869: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates x_return_status = '||x_return_status,3);

1865: x_planning_start_tbl => l_planning_start_tbl,
1866: x_planning_end_tbl => l_planning_end_tbl,
1867: x_return_status => x_return_status);
1868: IF (l_debug_mode = 'Y') THEN
1869: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates x_return_status = '||x_return_status,3);
1870: END IF;
1871:
1872: EXCEPTION
1873: WHEN OTHERS THEN

Line 1898: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES',3);

1894: FETCH get_scheduled_dates into l_get_sch_dates_cur;
1895: CLOSE get_scheduled_dates;
1896:
1897: IF (l_debug_mode = 'Y') THEN
1898: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES',3);
1899: END IF;
1900:
1901:
1902: PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES (

Line 1914: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES x_return_status='||x_return_status,3);

1910: ,x_msg_count => x_msg_count
1911: ,x_msg_data => x_msg_data );
1912:
1913: IF (l_debug_mode = 'Y') THEN
1914: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling PA_PROJECT_DATES_PUB.UPDATE_PROJECT_DATES x_return_status='||x_return_status,3);
1915: END IF;
1916:
1917:
1918: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1927: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION l_structure_version_id='||l_structure_version_id,3);

1923:
1924: IF (l_template_flag = 'N' AND l_versioning = 'N') THEN
1925: --baseline
1926: IF (l_debug_mode = 'Y') THEN
1927: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION l_structure_version_id='||l_structure_version_id,3);
1928: END IF;
1929:
1930: PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION(
1931: p_commit => FND_API.G_FALSE,

Line 1938: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION x_return_status='||x_return_status,3);

1934: x_msg_count => x_msg_count,
1935: x_msg_data => x_msg_data);
1936:
1937: IF (l_debug_mode = 'Y') THEN
1938: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION x_return_status='||x_return_status,3);
1939: END IF;
1940:
1941:
1942: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 1970: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES',3);

1966: (PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(l_struc_project_id) = 'N') THEN
1967: --copy to transaction dates
1968:
1969: IF (l_debug_mode = 'Y') THEN
1970: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES',3);
1971: END IF;
1972:
1973: PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES(
1974: p_validate_only => FND_API.G_FALSE

Line 1982: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES x_return_status='||x_return_status,3);

1978: ,x_msg_data => x_msg_data
1979: );
1980:
1981: IF (l_debug_mode = 'Y') THEN
1982: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATES x_return_status='||x_return_status,3);
1983: END IF;
1984:
1985:
1986: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 2030: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling Rollup_From_Subproject to rollup from the current project''s sub-project',3);

2026: --Bug No.3450684
2027: --Start rolling up from subproject associations
2028:
2029: IF (l_debug_mode = 'Y') THEN
2030: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling Rollup_From_Subproject to rollup from the current project''s sub-project',3);
2031: END IF;
2032:
2033: Rollup_From_Subproject(
2034: p_api_version => p_api_version

Line 2048: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling Rollup_From_Subproject to rollup from the current project''s sub-project x_return_status='||x_return_status,3);

2044: ,x_msg_count => x_msg_count
2045: ,x_msg_data => x_msg_data);
2046:
2047: IF (l_debug_mode = 'Y') THEN
2048: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling Rollup_From_Subproject to rollup from the current project''s sub-project x_return_status='||x_return_status,3);
2049: END IF;
2050:
2051: --
2052: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 2083: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','l_struc_project_id='||l_struc_project_id,3);

2079:
2080: ----bug 4541039
2081:
2082: IF (l_debug_mode = 'Y') THEN
2083: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','l_struc_project_id='||l_struc_project_id,3);
2084: END IF;
2085:
2086: FOR cur_select_hier_rec in cur_select_hier( l_struc_project_id, l_structure_version_id ) LOOP ----bug 4541039
2087:

Line 2099: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','l_rollup_from_sub_project='||l_struc_project_id,3);

2095: END IF;
2096:
2097:
2098: IF (l_debug_mode = 'Y') THEN
2099: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','l_rollup_from_sub_project='||l_struc_project_id,3);
2100: END IF;
2101:
2102: IF l_rollup_from_sub_project = 'Y'
2103: THEN

Line 2146: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling Rollup_From_Subproject to rollup from the current project id='||

2142: l_index := 1;
2143: l_parent_task_ver_id_tbl.extend;
2144: l_parent_task_ver_id_tbl(l_index):=get_str_ver_ic_lnk_tasks_rec.parent_task_ver_id;
2145: IF (l_debug_mode = 'Y') THEN
2146: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling Rollup_From_Subproject to rollup from the current project id='||
2147: cur_select_hier_rec.object_id_to2||' to its parent project id='||get_str_ver_ic_lnk_tasks_rec.parent_proj_id,3);
2148: END IF;
2149:
2150: PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject(

Line 2165: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling Rollup_From_Subproject to rollup from the current project id='||

2161: ,x_msg_count => x_msg_count
2162: ,x_msg_data => x_msg_data);
2163:
2164: IF (l_debug_mode = 'Y') THEN
2165: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling Rollup_From_Subproject to rollup from the current project id='||
2166: cur_select_hier_rec.object_id_to2||' to its parent project id='||get_str_ver_ic_lnk_tasks_rec.parent_proj_id||' x_return_status='||x_return_status,3);
2167: END If;
2168: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2169: x_msg_count := FND_MSG_PUB.count_msg;

Line 2187: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling Rollup_From_Subproject to rollup from the current project id='||

2183: l_parent_task_ver_id_tbl.extend;
2184: l_parent_task_ver_id_tbl(l_index):=get_str_ver_ic_lnk_tasks_rec.parent_task_ver_id;
2185:
2186: IF (l_debug_mode = 'Y') THEN
2187: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','Before calling Rollup_From_Subproject to rollup from the current project id='||
2188: cur_select_hier_rec.object_id_to2||' to its parent project id='||get_str_ver_ic_lnk_tasks_rec.parent_proj_id,3);
2189: END IF;
2190:
2191: PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject(

Line 2205: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling Rollup_From_Subproject to rollup from the current project id='||

2201: ,x_return_status => x_return_status
2202: ,x_msg_count => x_msg_count
2203: ,x_msg_data => x_msg_data);
2204: IF (l_debug_mode = 'Y') THEN
2205: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling Rollup_From_Subproject to rollup from the current project id='||
2206: cur_select_hier_rec.object_id_to2||' to its parent project id='||get_str_ver_ic_lnk_tasks_rec.parent_proj_id||' x_return_status='||x_return_status,3);
2207: END IF;
2208:
2209: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 2392: pa_debug.debug('PVT.TASK_STATUS_ROLLUP BEGIN');

2388: --hsiu: bug 2800553: added for performance improvement
2389: l_partial_flag VARCHAR2(1);
2390: BEGIN
2391: IF (p_debug_mode = 'Y') THEN
2392: pa_debug.debug('PVT.TASK_STATUS_ROLLUP BEGIN');
2393: END IF;
2394:
2395: IF (p_commit = FND_API.G_TRUE) THEN
2396: savepoint TASK_STATUS_ROLLUP_PUB;

Line 2400: pa_debug.debug('Performing validations');

2396: savepoint TASK_STATUS_ROLLUP_PUB;
2397: END IF;
2398:
2399: IF (p_debug_mode = 'Y') THEN
2400: pa_debug.debug('Performing validations');
2401: END IF;
2402:
2403: --begin rollup
2404:

Line 2601: pa_debug.debug('PVT.TASK_STATUS_ROLLUP BEGIN');

2597: and c.status_type = 'TASK';
2598: l_zero_weight_rec get_zero_weight_status%ROWTYPE;
2599: BEGIN
2600: IF (p_debug_mode = 'Y') THEN
2601: pa_debug.debug('PVT.TASK_STATUS_ROLLUP BEGIN');
2602: END IF;
2603:
2604: IF (p_commit = FND_API.G_TRUE) THEN
2605: savepoint TASK_STAT_PUSHDOWN_ROLLUP;

Line 2609: pa_debug.debug('Performing validations');

2605: savepoint TASK_STAT_PUSHDOWN_ROLLUP;
2606: END IF;
2607:
2608: IF (p_debug_mode = 'Y') THEN
2609: pa_debug.debug('Performing validations');
2610: END IF;
2611:
2612: --push down all cancelled and on-hold statuses
2613: OPEN get_zero_weight_status;

Line 2802: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

2798: BEGIN
2799:
2800: x_msg_count := 0;
2801: x_return_status := FND_API.G_RET_STS_SUCCESS;
2802: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2803:
2804: IF (p_debug_mode = 'Y') THEN
2805: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDULE_DATES_ROLLUP','Entered in PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP p_structure_version_id='||p_structure_version_id, 3);
2806: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDULE_DATES_ROLLUP','Entered in PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP p_project_id='||p_project_id, 3);

Line 2805: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDULE_DATES_ROLLUP','Entered in PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP p_structure_version_id='||p_structure_version_id, 3);

2801: x_return_status := FND_API.G_RET_STS_SUCCESS;
2802: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2803:
2804: IF (p_debug_mode = 'Y') THEN
2805: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDULE_DATES_ROLLUP','Entered in PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP p_structure_version_id='||p_structure_version_id, 3);
2806: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDULE_DATES_ROLLUP','Entered in PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP p_project_id='||p_project_id, 3);
2807: END IF;
2808:
2809: IF (p_commit = FND_API.G_TRUE) THEN

Line 2806: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDULE_DATES_ROLLUP','Entered in PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP p_project_id='||p_project_id, 3);

2802: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
2803:
2804: IF (p_debug_mode = 'Y') THEN
2805: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDULE_DATES_ROLLUP','Entered in PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP p_structure_version_id='||p_structure_version_id, 3);
2806: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDULE_DATES_ROLLUP','Entered in PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP p_project_id='||p_project_id, 3);
2807: END IF;
2808:
2809: IF (p_commit = FND_API.G_TRUE) THEN
2810: savepoint Program_Schedule_dates_rollup;

Line 2817: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before Opening cursor cur_select_grid', 3);

2813: IF (p_structure_version_id IS NULL OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2814: AND (p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2815: THEN
2816: IF l_debug_mode = 'Y' THEN
2817: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before Opening cursor cur_select_grid', 3);
2818: END IF;
2819:
2820: FOR cur_select_grid_rec IN cur_select_grid LOOP
2821:

Line 2829: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published version of the project:'||cur_select_grid_rec.project_id, 3);

2825: AND p_project_id= cur_select_grid_rec.project_id
2826: THEN
2827:
2828: IF l_debug_mode = 'Y' THEN
2829: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published version of the project:'||cur_select_grid_rec.project_id, 3);
2830: END IF;
2831:
2832: PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup(
2833: p_project_id => p_project_id,

Line 2846: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published version of the project:'||

2842: END IF;
2843:
2844:
2845: IF l_debug_mode = 'Y' THEN
2846: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Program_Schedule_dates_rollup for published version of the project:'||
2847: cur_select_grid_rec.project_id||' x_return_status='||x_return_status, 3);
2848: END IF;
2849:
2850: END IF;

Line 2859: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd for project'||cur_select_grid_rec.project_id, 3);

2855:
2856: IF l_tasks_ver_ids.count > 0 THEN
2857:
2858: IF l_debug_mode = 'Y' THEN
2859: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd for project'||cur_select_grid_rec.project_id, 3);
2860: END IF;
2861:
2862: -- Bug 6854670: Changed call to Rollup_From_Subproject_Unltd
2863: PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd(

Line 2880: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd x_return_status='||x_return_status, 3);

2876: ,x_msg_data => x_msg_data);
2877:
2878:
2879: IF l_debug_mode = 'Y' THEN
2880: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd x_return_status='||x_return_status, 3);
2881: END IF;
2882:
2883: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2884: RAISE FND_API.G_EXC_ERROR;

Line 2898: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 3);

2894:
2895: IF l_tasks_ver_ids.count > 0 THEN
2896:
2897: IF l_debug_mode = 'Y' THEN
2898: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before calling PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 3);
2899: END IF;
2900:
2901: -- Bug 6854670: Changed call to Rollup_From_Subproject_Unltd
2902: PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd(

Line 2919: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd x_return_status='||x_return_status, 3);

2915: ,x_msg_data => x_msg_data);
2916:
2917:
2918: IF l_debug_mode = 'Y' THEN
2919: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'After calling PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd x_return_status='||x_return_status, 3);
2920: END IF;
2921:
2922: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2923: RAISE FND_API.G_EXC_ERROR;