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_PROJECT_STRUCTURE_PVT1 dependencies on PA_DEBUG

Line 160: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE BEGIN');

156: l_deliverable_license VARCHAR2(1) := 'N';
157:
158: BEGIN
159: IF (p_debug_mode = 'Y') THEN
160: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE BEGIN');
161: END IF;
162:
163: IF (p_commit = FND_API.G_TRUE) THEN
164: savepoint CREATE_STRUC_PRIVATE;

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

164: savepoint CREATE_STRUC_PRIVATE;
165: END IF;
166:
167: IF (p_debug_mode = 'Y') THEN
168: pa_debug.debug('Performing validations');
169: END IF;
170:
171: --Check if the structure name is unique within the project
172: If (pa_project_structure_utils.check_structure_name_unique(p_structure_name,

Line 396: pa_debug.debug('workplan license = '||l_workplan_license);

392: --dbms_output.put_line('done inserting to pa_proj_element');
393:
394: Open get_licensed(l_workplan_license, l_financial_license, l_deliverable_license);
395: IF (p_debug_mode = 'Y') THEN
396: pa_debug.debug('workplan license = '||l_workplan_license);
397: pa_debug.debug('financial license = '||l_financial_license);
398: END IF;
399:
400: LOOP

Line 397: pa_debug.debug('financial license = '||l_financial_license);

393:
394: Open get_licensed(l_workplan_license, l_financial_license, l_deliverable_license);
395: IF (p_debug_mode = 'Y') THEN
396: pa_debug.debug('workplan license = '||l_workplan_license);
397: pa_debug.debug('financial license = '||l_financial_license);
398: END IF;
399:
400: LOOP
401: FETCH get_licensed into l_structure_type_id, l_structure_type;

Line 405: pa_debug.debug('structure_type = '||l_structure_type);

401: FETCH get_licensed into l_structure_type_id, l_structure_type;
402: EXIT WHEN get_licensed%NOTFOUND;
403: --dbms_output.put_line('begin inserting to struture type tbl');
404: IF (p_debug_mode = 'Y') THEN
405: pa_debug.debug('structure_type = '||l_structure_type);
406: END IF;
407: --check if structure type exists
408:
409: pa_project_structure_utils.Check_structure_Type_Exists(p_project_id,

Line 537: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE end');

533:
534: x_return_status := FND_API.G_RET_STS_SUCCESS;
535:
536: IF (p_debug_mode = 'Y') THEN
537: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE end');
538: END IF;
539:
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN

Line 673: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION begin');

669: FROM sys.dual;
670:
671: BEGIN
672: IF (p_debug_mode = 'Y') THEN
673: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION begin');
674: END IF;
675:
676: IF (p_commit = FND_API.G_TRUE) THEN
677: savepoint CREATE_STRUC_VER_PVT;

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

677: savepoint CREATE_STRUC_VER_PVT;
678: END IF;
679:
680: IF (p_debug_mode = 'Y') THEN
681: pa_debug.debug('Performing validations');
682: END IF;
683:
684: --Get project id
685: OPEN getid;

Line 840: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION end');

836:
837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838:
839: IF (p_debug_mode = 'Y') THEN
840: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION end');
841: END IF;
842:
843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN

Line 999: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION_ATTR begin');

995: l_current_working_ver_flag VARCHAR2(1); --FPM bug 3301192
996:
997: BEGIN
998: IF (p_debug_mode = 'Y') THEN
999: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION_ATTR begin');
1000: END IF;
1001:
1002: IF (p_commit = FND_API.G_TRUE) THEN
1003: savepoint CREATE_STRUC_VER_ATTR_PVT;

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

1003: savepoint CREATE_STRUC_VER_ATTR_PVT;
1004: END IF;
1005:
1006: IF (p_debug_mode = 'Y') THEN
1007: pa_debug.debug('Performing validations');
1008: END IF;
1009:
1010: OPEN getids;
1011: FETCH getids into l_project_id, l_proj_element_id;

Line 1315: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION_ATTR end');

1311:
1312: x_return_status := FND_API.G_RET_STS_SUCCESS;
1313:
1314: IF (p_debug_mode = 'Y') THEN
1315: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION_ATTR end');
1316: END IF;
1317:
1318: EXCEPTION
1319: WHEN FND_API.G_EXC_ERROR THEN

Line 1478: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_STRUCTURE begin');

1474: from pa_proj_elements
1475: where proj_element_id = p_structure_id;
1476: BEGIN
1477: IF (p_debug_mode = 'Y') THEN
1478: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_STRUCTURE begin');
1479: END IF;
1480:
1481: IF (p_commit = FND_API.G_TRUE) then
1482: savepoint update_structure_pvt;

Line 1527: pa_debug.debug('l_name = '||l_name);

1523: RAISE FND_API.G_EXC_ERROR;
1524: END IF;
1525:
1526: IF (p_debug_mode = 'Y') THEN
1527: pa_debug.debug('l_name = '||l_name);
1528: pa_debug.debug('p_structure_name = '||p_structure_name);
1529: END IF;
1530:
1531: --Check if structure name is unique, if changed.

Line 1528: pa_debug.debug('p_structure_name = '||p_structure_name);

1524: END IF;
1525:
1526: IF (p_debug_mode = 'Y') THEN
1527: pa_debug.debug('l_name = '||l_name);
1528: pa_debug.debug('p_structure_name = '||p_structure_name);
1529: END IF;
1530:
1531: --Check if structure name is unique, if changed.
1532: IF (l_name <> p_structure_name) then

Line 1534: pa_debug.debug('different!!');

1530:
1531: --Check if structure name is unique, if changed.
1532: IF (l_name <> p_structure_name) then
1533: IF (p_debug_mode = 'Y') THEN
1534: pa_debug.debug('different!!');
1535: END IF;
1536: IF ('Y' <> pa_project_structure_utils.Check_Structure_Name_Unique(p_structure_name,
1537: p_structure_id,
1538: l_project_id)) THEN

Line 1664: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_STRUCTURE end');

1660:
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: IF (p_debug_mode = 'Y') THEN
1664: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_STRUCTURE end');
1665: END IF;
1666:
1667: EXCEPTION
1668: when FND_API.G_EXC_ERROR then

Line 1852: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_STRUCTURE_VERSION_ATTR begin');

1848:
1849: BEGIN
1850: l_msg_count_int := FND_MSG_PUB.count_msg; /*Bug#6414944*/
1851: IF (p_debug_mode = 'Y') THEN
1852: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_STRUCTURE_VERSION_ATTR begin');
1853: END IF;
1854:
1855: IF (p_commit = FND_API.G_TRUE) THEN
1856: savepoint UPDATE_STRUC_VER_ATTR_PVT;

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

1856: savepoint UPDATE_STRUC_VER_ATTR_PVT;
1857: END IF;
1858:
1859: IF (p_debug_mode = 'Y') THEN
1860: pa_debug.debug('Performing validations');
1861: END IF;
1862:
1863: OPEN getids;
1864: FETCH getids into l_rowid,

Line 1952: pa_debug.debug('Published');

1948: IF ('N' = PA_PROJECT_STRUCTURE_UTILS.check_edit_wp_ok(l_project_id,
1949: l_structure_version_id)) THEN
1950: --If published
1951: IF (p_debug_mode = 'Y') THEN
1952: pa_debug.debug('Published');
1953: END IF;
1954:
1955: --if set current baseline flag
1956: IF (p_baseline_current_flag = 'Y') THEN

Line 2019: pa_debug.debug('Not Published');

2015: IF ('Y' = PA_PROJECT_STRUCTURE_UTILS.check_edit_wp_ok(l_project_id,
2016: l_structure_version_id)) THEN
2017: --If not published
2018: IF (p_debug_mode = 'Y') THEN
2019: pa_debug.debug('Not Published');
2020: END IF;
2021:
2022: --Check lock
2023: l_get_lock := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,

Line 2027: pa_debug.debug('l_get_lock value = '||l_get_lock);

2023: l_get_lock := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,
2024: l_structure_version_id);
2025:
2026: IF (p_debug_mode = 'Y') THEN
2027: pa_debug.debug('l_get_lock value = '||l_get_lock);
2028: END IF;
2029:
2030: --bug 3071008
2031: IF (l_get_lock <> 'Y') THEN

Line 2236: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_STRUCTURE_VERSION_ATTR end');

2232:
2233: x_return_status := FND_API.G_RET_STS_SUCCESS;
2234:
2235: IF (p_debug_mode = 'Y') THEN
2236: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_STRUCTURE_VERSION_ATTR end');
2237: END IF;
2238:
2239: EXCEPTION
2240: WHEN NO_DATA_FOUND THEN

Line 2336: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE begin');

2332: -- End fix for Bug # 4506308.
2333:
2334: BEGIN
2335: IF (p_debug_mode = 'Y') THEN
2336: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE begin');
2337: END IF;
2338:
2339: if p_commit = FND_API.G_TRUE then
2340: savepoint delete_structure_pvt;

Line 2441: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE end');

2437:
2438: x_return_status := FND_API.G_RET_STS_SUCCESS;
2439:
2440: IF (p_debug_mode = 'Y') THEN
2441: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE end');
2442: END IF;
2443:
2444: EXCEPTION
2445: when FND_API.G_EXC_ERROR then

Line 2527: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE_VERSION begin');

2523: -- End fix for Bug # 4483222.
2524:
2525: BEGIN
2526: IF (p_debug_mode = 'Y') THEN
2527: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE_VERSION begin');
2528: END IF;
2529:
2530: if p_commit = FND_API.G_TRUE then
2531: savepoint delete_structure_version_pvt;

Line 2536: pa_debug.debug('locking record '||p_structure_version_id||', '||p_record_Version_number);

2532: end if;
2533:
2534: --Lock record
2535: IF (p_debug_mode = 'Y') THEN
2536: pa_debug.debug('locking record '||p_structure_version_id||', '||p_record_Version_number);
2537: END IF;
2538: IF (p_validate_only <> FND_API.G_TRUE) THEN
2539: BEGIN
2540: --lock

Line 2591: pa_debug.debug('deleting structure versionn');

2587: raise FND_API.G_EXC_ERROR;
2588: end if;
2589:
2590: IF (p_debug_mode = 'Y') THEN
2591: pa_debug.debug('deleting structure versionn');
2592: END IF;
2593:
2594:
2595: -- Added by skannoji

Line 2704: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE_VERSION end');

2700:
2701: x_return_status := FND_API.G_RET_STS_SUCCESS;
2702:
2703: IF (p_debug_mode = 'Y') THEN
2704: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE_VERSION end');
2705: END IF;
2706:
2707: EXCEPTION
2708: when FND_API.G_EXC_ERROR then

Line 2803: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE_VERSION_ATTR begin');

2799: -- 3804437
2800:
2801: BEGIN
2802: IF (p_debug_mode = 'Y') THEN
2803: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE_VERSION_ATTR begin');
2804: END IF;
2805:
2806: if p_commit = FND_API.G_TRUE then
2807: savepoint delete_structure_ver_attr_pvt;

Line 2904: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE_VERSION_ATTR end');

2900: end if;
2901: /* Added for bug 8708651 */
2902:
2903: IF (p_debug_mode = 'Y') THEN
2904: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUCTURE_VERSION_ATTR end');
2905: END IF;
2906:
2907: x_return_status := FND_API.G_RET_STS_SUCCESS;
2908:

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

3297: WHERE element_version_id = c_structure_version_id;
3298:
3299: BEGIN
3300:
3301: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3302:
3303: IF (p_debug_mode = 'Y') THEN
3304: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE begin');
3305: END IF;

Line 3304: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE begin');

3300:
3301: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
3302:
3303: IF (p_debug_mode = 'Y') THEN
3304: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE begin');
3305: END IF;
3306:
3307: IF (p_commit = FND_API.G_TRUE) THEN
3308: savepoint publish_structure_pvt;

Line 3665: pa_debug.debug('create structure version =>'||l_new_struct_ver_id);

3661: --dbms_output.put_line('new struct version id = '||l_new_struct_ver_id);
3662: */
3663:
3664: IF (p_debug_mode = 'Y') THEN
3665: pa_debug.debug('create structure version =>'||l_new_struct_ver_id);
3666: END IF;
3667:
3668: l_msg_count := FND_MSG_PUB.count_msg;
3669: if l_msg_count > 0 then

Line 3711: -- pa_debug.debug('check incoming links for struct');

3707: --dbms_output.put_line('open p_structure_version_id');
3708: -- OPEN get_from_id(p_structure_version_id);
3709: -- LOOP
3710: -- IF (p_debug_mode = 'Y') THEN
3711: -- pa_debug.debug('check incoming links for struct');
3712: -- END IF;
3713: -- FETCH get_from_id INTO l_from_object_info;
3714: -- EXIT WHEN get_from_id%NOTFOUND;
3715: --

Line 3779: -- pa_debug.debug('update incoming links for struct =>'||l_return_status);

3775: -- --dbms_output.put_line('5b');
3776: --
3777: -- END IF;
3778: -- If (p_debug_mode = 'Y') THEN
3779: -- pa_debug.debug('update incoming links for struct =>'||l_return_status);
3780: -- END IF;
3781: --
3782: -- --Check error
3783: -- l_msg_count := FND_MSG_PUB.count_msg;

Line 3807: -- pa_debug.debug('check outgoing links for struct');

3803: --dbms_output.put_line('open get_to_id');
3804: -- OPEN get_to_id(p_structure_version_id);
3805: -- LOOP
3806: -- IF (p_debug_mode = 'Y') THEN
3807: -- pa_debug.debug('check outgoing links for struct');
3808: -- END IF;
3809: -- FETCH get_to_id INTO l_to_object_info;
3810: -- EXIT WHEN get_to_id%NOTFOUND;
3811: -- If (l_to_object_info.object_type_to = 'PA_STRUCTURES') THEN

Line 3884: -- pa_debug.debug('update outgoing links for struct =>'||l_return_status);

3880: -- CLOSE get_task_version_info;
3881: -- --dbms_output.put_line('8b');
3882: --
3883: -- If (p_debug_mode = 'Y') THEN
3884: -- pa_debug.debug('update outgoing links for struct =>'||l_return_status);
3885: -- END IF;
3886: -- END IF;
3887: -- --Check error
3888: -- l_msg_count := FND_MSG_PUB.count_msg;

Line 3918: pa_debug.debug('create task version for published structure');

3914: OPEN get_task_versions_csr(p_structure_version_id);
3915: l_last_wbs_level := NULL;
3916: LOOP
3917: IF (p_debug_mode = 'Y') THEN
3918: pa_debug.debug('create task version for published structure');
3919: END IF;
3920:
3921: FETCH get_task_versions_csr INTO l_task_versions_rec;
3922: EXIT WHEN get_task_versions_csr%NOTFOUND;

Line 4190: -- pa_debug.debug('updating links');

4186:
4187: -- error_msg('before update published links');
4188: --update links linking from working version to current published version
4189: -- IF (p_debug_mode = 'Y') THEN
4190: -- pa_debug.debug('updating links');
4191: -- END IF;
4192: -- PA_PROJECT_STRUCTURE_PVT1.UPDATE_LATEST_PUB_LINKS
4193: -- (
4194: -- p_init_msg_list => FND_API.G_FALSE

Line 4588: pa_debug.debug('create schedule version for struct');

4584: CLOSE get_ver_schedule_attr_csr;
4585: --dbms_output.put_line('10b');
4586:
4587: IF (p_debug_mode = 'Y') THEN
4588: pa_debug.debug('create schedule version for struct');
4589: END IF;
4590: --Call Create_Schedule_Version if workplan type
4591: /* hsiu: bug 2800553: commented for performance improvement
4592: PA_TASK_PUB1.CREATE_SCHEDULE_VERSION

Line 5354: pa_debug.debug('progress report api');

5350: );
5351: */
5352: /* removed
5353: IF (p_debug_mode = 'Y') THEN
5354: pa_debug.debug('progress report api');
5355: END IF;
5356:
5357:
5358: --Check if there is any error.

Line 5626: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'Before opening sel_other_structure_ver p_structure_version_id='||p_structure_version_id, 3);

5622:
5623: -- End
5624:
5625: IF l_debug_mode = 'Y' THEN
5626: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'Before opening sel_other_structure_ver p_structure_version_id='||p_structure_version_id, 3);
5627: END IF;
5628:
5629: --hsiu
5630: --changes for advanced structure

Line 5638: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'Before calling PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_wo_val', 3);

5634: FETCH sel_other_structure_ver into l_del_struc_ver_id, l_del_struc_ver_rvn;
5635: EXIT WHEN sel_other_structure_ver%NOTFOUND;
5636:
5637: IF l_debug_mode = 'Y' THEN
5638: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'Before calling PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_wo_val', 3);
5639: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'l_del_struc_ver_id='||l_del_struc_ver_id||' l_del_struc_ver_rvn='||l_del_struc_ver_rvn, 3);
5640: END IF;
5641:
5642: PA_PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_wo_val(

Line 5639: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'l_del_struc_ver_id='||l_del_struc_ver_id||' l_del_struc_ver_rvn='||l_del_struc_ver_rvn, 3);

5635: EXIT WHEN sel_other_structure_ver%NOTFOUND;
5636:
5637: IF l_debug_mode = 'Y' THEN
5638: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'Before calling PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_wo_val', 3);
5639: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'l_del_struc_ver_id='||l_del_struc_ver_id||' l_del_struc_ver_rvn='||l_del_struc_ver_rvn, 3);
5640: END IF;
5641:
5642: PA_PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_wo_val(
5643: p_structure_version_id => l_del_struc_ver_id

Line 5654: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'After calling PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_wo_val l_return_status='||l_return_status||' l_msg_count='||l_msg_count, 3);

5650: --Check if there is any error.
5651: l_msg_count := FND_MSG_PUB.count_msg;
5652:
5653: IF l_debug_mode = 'Y' THEN
5654: pa_debug.write('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE', 'After calling PROJECT_STRUCTURE_PVT1.Delete_Struc_Ver_wo_val l_return_status='||l_return_status||' l_msg_count='||l_msg_count, 3);
5655: END IF;
5656:
5657: IF l_msg_count > 0 OR l_return_status ='E' THEN
5658: x_msg_count := l_msg_count;

Line 5877: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE end');

5873: raise FND_API.G_EXC_ERROR;
5874: end if;
5875:
5876: IF (p_debug_mode = 'Y') THEN
5877: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.PUBLISH_STRUCTURE end');
5878: END IF;
5879:
5880: EXCEPTION
5881: when FND_API.G_EXC_ERROR then

Line 6057: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_LATEST_PUB_LINKS begin');

6053: l_latest_parent_struc_ver NUMBER;
6054:
6055: BEGIN
6056: IF (p_debug_mode = 'Y') THEN
6057: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_LATEST_PUB_LINKS begin');
6058: END IF;
6059:
6060: IF (p_commit = FND_API.G_TRUE) THEN
6061: savepoint update_latest_pub_links_pvt;

Line 6084: pa_debug.debug('No latest published version found');

6080: FETCH get_latest_struc_ver INTO l_latest_elem_ver;
6081: IF get_latest_struc_ver%NOTFOUND THEN
6082: --no publish version. exit;
6083: IF (p_debug_mode = 'Y') THEN
6084: pa_debug.debug('No latest published version found');
6085: END IF;
6086: --dbms_output.put_line('b, Close get_latest_struc_ver');
6087: CLOSE get_latest_struc_ver;
6088: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6102: pa_debug.debug('No latest published version found');

6098: l_latest_parent_struc_ver;
6099: IF get_latest_task_ver%NOTFOUND THEN
6100: --no publish version. exit;
6101: IF (p_debug_mode = 'Y') THEN
6102: pa_debug.debug('No latest published version found');
6103: END IF;
6104: --dbms_output.put_line('b, Close get_latest_task_ver');
6105: CLOSE get_latest_task_ver;
6106: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6121: pa_debug.debug('getting incoming links');

6117: --dbms_output.put_line('b, Open get_from_id');
6118: OPEN get_from_id(l_latest_elem_ver);
6119: LOOP
6120: IF (p_debug_mode = 'Y') THEN
6121: pa_debug.debug('getting incoming links');
6122: END IF;
6123: FETCH get_from_id INTO l_from_object_info;
6124: EXIT WHEN get_from_id%NOTFOUND;
6125:

Line 6390: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION');

6386:
6387: X_Row_id VARCHAR2(255);
6388: BEGIN
6389:
6390: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION');
6391:
6392: IF (p_debug_mode = 'Y') THEN
6393: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION begin');
6394: END IF;

Line 6393: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION begin');

6389:
6390: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION');
6391:
6392: IF (p_debug_mode = 'Y') THEN
6393: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION begin');
6394: END IF;
6395:
6396: IF (p_commit = FND_API.G_TRUE) THEN
6397: savepoint copy_structure_version_pvt;

Line 6430: pa_debug.debug('Create Structure Version return status: ' || l_return_status);

6426: ,x_msg_count => l_msg_count
6427: ,x_msg_data => l_msg_data );
6428:
6429: If (p_debug_mode = 'Y') THEN
6430: pa_debug.debug('Create Structure Version return status: ' || l_return_status);
6431: pa_debug.debug('l_new_struct_ver_id: ' || l_new_struct_ver_id);
6432: END IF;
6433:
6434:

Line 6431: pa_debug.debug('l_new_struct_ver_id: ' || l_new_struct_ver_id);

6427: ,x_msg_data => l_msg_data );
6428:
6429: If (p_debug_mode = 'Y') THEN
6430: pa_debug.debug('Create Structure Version return status: ' || l_return_status);
6431: pa_debug.debug('l_new_struct_ver_id: ' || l_new_struct_ver_id);
6432: END IF;
6433:
6434:
6435: --Check if there is any error.

Line 6472: pa_debug.debug('Create Structure Version Attr return status: ' || l_return_status);

6468: ,x_msg_count => l_msg_count
6469: ,x_msg_data => l_msg_data );
6470:
6471: IF (p_debug_mode = 'Y') THEN
6472: pa_debug.debug('Create Structure Version Attr return status: ' || l_return_status);
6473: pa_debug.debug('l_pev_structure_id: ' || l_pev_structure_id);
6474: END IF;
6475:
6476: --Check if there is any error.

Line 6473: pa_debug.debug('l_pev_structure_id: ' || l_pev_structure_id);

6469: ,x_msg_data => l_msg_data );
6470:
6471: IF (p_debug_mode = 'Y') THEN
6472: pa_debug.debug('Create Structure Version Attr return status: ' || l_return_status);
6473: pa_debug.debug('l_pev_structure_id: ' || l_pev_structure_id);
6474: END IF;
6475:
6476: --Check if there is any error.
6477: l_msg_count := FND_MSG_PUB.count_msg;

Line 6528: pa_debug.debug('Create Relationship return status: ' || l_return_status);

6524: );
6525: CLOSE l_get_structure_ver_csr;
6526:
6527: IF (p_debug_mode = 'Y') THEN
6528: pa_debug.debug('Create Relationship return status: ' || l_return_status);
6529: pa_debug.debug('l_new_obj_rel_id: ' || l_new_obj_rel_id);
6530: END IF;
6531: ELSIF(l_to_object_info.object_type_to = 'PA_TASKS') THEN
6532: OPEN get_task_version_info(l_to_object_info.object_id_to);

Line 6529: pa_debug.debug('l_new_obj_rel_id: ' || l_new_obj_rel_id);

6525: CLOSE l_get_structure_ver_csr;
6526:
6527: IF (p_debug_mode = 'Y') THEN
6528: pa_debug.debug('Create Relationship return status: ' || l_return_status);
6529: pa_debug.debug('l_new_obj_rel_id: ' || l_new_obj_rel_id);
6530: END IF;
6531: ELSIF(l_to_object_info.object_type_to = 'PA_TASKS') THEN
6532: OPEN get_task_version_info(l_to_object_info.object_id_to);
6533: FETCH get_task_version_info INTO l_info_task_ver_rec;

Line 6566: pa_debug.debug('Create Relationship return status: ' || l_return_status);

6562: ,x_msg_data => l_msg_data
6563: );
6564: CLOSE get_task_version_info;
6565: IF (p_debug_mode = 'Y') THEN
6566: pa_debug.debug('Create Relationship return status: ' || l_return_status);
6567: pa_debug.debug('l_new_obj_rel_id: ' || l_new_obj_rel_id);
6568: END IF;
6569: END IF;
6570: --Check error

Line 6567: pa_debug.debug('l_new_obj_rel_id: ' || l_new_obj_rel_id);

6563: );
6564: CLOSE get_task_version_info;
6565: IF (p_debug_mode = 'Y') THEN
6566: pa_debug.debug('Create Relationship return status: ' || l_return_status);
6567: pa_debug.debug('l_new_obj_rel_id: ' || l_new_obj_rel_id);
6568: END IF;
6569: END IF;
6570: --Check error
6571: l_msg_count := FND_MSG_PUB.count_msg;

Line 6673: pa_debug.debug('Create Schedule Version return status: ' || l_return_status);

6669: );
6670:
6671:
6672: IF (p_debug_mode = 'Y') THEN
6673: pa_debug.debug('Create Schedule Version return status: ' || l_return_status);
6674: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);
6675: END IF;
6676:
6677: --Check if there is any error.

Line 6674: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);

6670:
6671:
6672: IF (p_debug_mode = 'Y') THEN
6673: pa_debug.debug('Create Schedule Version return status: ' || l_return_status);
6674: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);
6675: END IF;
6676:
6677: --Check if there is any error.
6678: l_msg_count := FND_MSG_PUB.count_msg;

Line 6768: pa_debug.debug('Create Task Version return status: ' || l_return_status);

6764:
6765: t_equiv_elem_ver_id(l_task_versions_rec.element_version_id) := l_task_version_id;
6766:
6767: IF (p_debug_mode = 'Y') THEN
6768: pa_debug.debug('Create Task Version return status: ' || l_return_status);
6769: pa_debug.debug('l_task_version_id: ' || l_task_version_id);
6770: pa_debug.debug('l_msg_count: ' || l_msg_count);
6771: END IF;
6772:

Line 6769: pa_debug.debug('l_task_version_id: ' || l_task_version_id);

6765: t_equiv_elem_ver_id(l_task_versions_rec.element_version_id) := l_task_version_id;
6766:
6767: IF (p_debug_mode = 'Y') THEN
6768: pa_debug.debug('Create Task Version return status: ' || l_return_status);
6769: pa_debug.debug('l_task_version_id: ' || l_task_version_id);
6770: pa_debug.debug('l_msg_count: ' || l_msg_count);
6771: END IF;
6772:
6773: --Check if there is any error.

Line 6770: pa_debug.debug('l_msg_count: ' || l_msg_count);

6766:
6767: IF (p_debug_mode = 'Y') THEN
6768: pa_debug.debug('Create Task Version return status: ' || l_return_status);
6769: pa_debug.debug('l_task_version_id: ' || l_task_version_id);
6770: pa_debug.debug('l_msg_count: ' || l_msg_count);
6771: END IF;
6772:
6773: --Check if there is any error.
6774: l_msg_count := FND_MSG_PUB.count_msg;

Line 6790: pa_debug.debug('Before Create Schedule Version');

6786: FETCH l_get_ver_schedule_attr_csr INTO l_ver_schedule_attr_rec;
6787: CLOSE l_get_ver_schedule_attr_csr;
6788:
6789: IF (p_debug_mode = 'Y') THEN
6790: pa_debug.debug('Before Create Schedule Version');
6791: END IF;
6792: -- xxlu added DFF attributes
6793: /* PA_TASK_PUB1.CREATE_SCHEDULE_VERSION
6794: ( p_validate_only => FND_API.G_FALSE

Line 6884: pa_debug.debug('Create Schedule Version return status: ' || l_return_status);

6880: ,X_SOURCE_OBJECT_TYPE => 'PA_PROJECTS'
6881: );
6882:
6883: IF (p_debug_mode = 'Y') THEN
6884: pa_debug.debug('Create Schedule Version return status: ' || l_return_status);
6885: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);
6886: END IF;
6887:
6888: --Check if there is any error.

Line 6885: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);

6881: );
6882:
6883: IF (p_debug_mode = 'Y') THEN
6884: pa_debug.debug('Create Schedule Version return status: ' || l_return_status);
6885: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);
6886: END IF;
6887:
6888: --Check if there is any error.
6889: l_msg_count := FND_MSG_PUB.count_msg;

Line 7053: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION END');

7049: COMMIT;
7050: END IF;
7051:
7052: IF (p_debug_mode = 'Y') THEN
7053: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION END');
7054: END IF;
7055:
7056: EXCEPTION
7057: when FND_API.G_EXC_ERROR then

Line 7425: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE');

7421: where task_type_id = c_task_type_id;
7422: l_init_status_code PA_TASK_TYPES.INITIAL_STATUS_CODE%TYPE;
7423: --end bug 2667527
7424: BEGIN
7425: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE');
7426:
7427: IF (p_debug_mode = 'Y') THEN
7428: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE begin');
7429: END IF;

Line 7428: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE begin');

7424: BEGIN
7425: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE');
7426:
7427: IF (p_debug_mode = 'Y') THEN
7428: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE begin');
7429: END IF;
7430:
7431: IF (p_commit = FND_API.G_TRUE) THEN
7432: savepoint copy_structure_pvt;

Line 7659: pa_debug.debug('create structure');

7655: l_name := substr(l_project_name, 1, 240);
7656: END IF;
7657: */
7658: IF (p_debug_mode = 'Y') THEN
7659: pa_debug.debug('create structure');
7660: END IF;
7661:
7662: --Commented by hsiu
7663: -- IF (l_dest_template_flag = 'Y' AND l_structure_type = 'WORKPLAN') THEN

Line 7687: -- pa_debug.debug('create structure version');

7683: -- RAISE FND_API.G_EXC_ERROR;
7684: -- END IF;
7685:
7686: -- IF (p_debug_mode = 'Y') THEN
7687: -- pa_debug.debug('create structure version');
7688: -- END IF;
7689: -- PA_PROJECT_STRUCTURE_PVT1.Create_Structure_Version
7690: -- ( p_validate_only => FND_API.G_FALSE
7691: -- ,p_structure_id => l_structure_id

Line 7708: -- pa_debug.debug('create structure version attr');

7704: -- RAISE FND_API.G_EXC_ERROR;
7705: -- END IF;
7706:
7707: -- IF (p_debug_mode = 'Y') THEN
7708: -- pa_debug.debug('create structure version attr');
7709: -- END IF;
7710: -- PA_PROJECT_STRUCTURE_PVT1.Create_Structure_Version_Attr
7711: -- ( p_validate_only => FND_API.G_FALSE
7712: -- ,p_structure_version_id => l_new_structure_version_id

Line 7737: -- pa_debug.debug('create schedule version');

7733: -- RAISE FND_API.G_EXC_ERROR;
7734: -- END IF;
7735:
7736: -- IF (p_debug_mode = 'Y') THEN
7737: -- pa_debug.debug('create schedule version');
7738: -- END IF;
7739: -- PA_TASK_PUB1.CREATE_SCHEDULE_VERSION
7740: -- ( p_validate_only => FND_API.G_FALSE
7741: -- ,p_element_version_id => l_new_structure_version_id

Line 7810: pa_debug.debug('done: '||l_return_status);

7806: ,x_msg_count => l_msg_count
7807: ,x_msg_data => l_msg_data );
7808:
7809: IF (p_debug_mode = 'Y') THEN
7810: pa_debug.debug('done: '||l_return_status);
7811: END IF;
7812:
7813: --Check if there is any error.
7814: l_msg_count := FND_MSG_PUB.count_msg;

Line 7898: pa_debug.debug('create structure version');

7894: CLOSE l_get_structure_ver_csr;
7895:
7896:
7897: IF (p_debug_mode = 'Y') THEN
7898: pa_debug.debug('create structure version');
7899: END IF;
7900: PA_PROJECT_STRUCTURE_PVT1.Create_Structure_Version
7901: ( p_validate_only => p_validate_only
7902: ,p_structure_id => l_structure_id

Line 7967: pa_debug.debug('create schedule version for structure');

7963: -- end calculate scheduled start and finish dates
7964:
7965:
7966: IF (p_debug_mode = 'Y') THEN
7967: pa_debug.debug('create schedule version for structure');
7968: END IF;
7969:
7970: l_struc_scheduled_start_date := l_scheduled_start_date;
7971: l_struc_scheduled_finish_date := l_scheduled_finish_date;

Line 8040: pa_debug.debug('l_task_versions_rec.proj_elemnet_id = '||l_task_versions_rec.proj_element_id);

8036:
8037: --check if task already exist; if it does, then skip
8038: -- CREATE_TASK
8039: IF (p_debug_mode = 'Y') THEN
8040: pa_debug.debug('l_task_versions_rec.proj_elemnet_id = '||l_task_versions_rec.proj_element_id);
8041: END IF;
8042:
8043: If (NOT (l_task_match_tbl.exists(l_task_versions_rec.proj_element_id))) THEN
8044:

Line 8063: pa_debug.debug('inserting into task with id'||l_task_id);

8059: CLOSE l_get_pa_tasks_csr;
8060: END IF;
8061:
8062: IF (p_debug_mode = 'Y') THEN
8063: pa_debug.debug('inserting into task with id'||l_task_id);
8064: END IF;
8065:
8066: OPEN get_init_task_stat(l_tasks_rec.TYPE_ID);
8067: FETCH get_init_task_stat into l_init_status_code;

Line 8131: pa_debug.debug('l_task_id = '||l_task_id);

8127: l_task_id := l_task_match_tbl(l_task_versions_rec.proj_element_id);
8128: END IF;
8129:
8130: IF (p_debug_mode = 'Y') THEN
8131: pa_debug.debug('l_task_id = '||l_task_id);
8132: END IF;
8133:
8134:
8135: IF (p_debug_mode = 'Y') THEN

Line 8136: pa_debug.debug('before creating version:'||l_ref_task_ver_id||','||l_peer_or_sub);

8132: END IF;
8133:
8134:
8135: IF (p_debug_mode = 'Y') THEN
8136: pa_debug.debug('before creating version:'||l_ref_task_ver_id||','||l_peer_or_sub);
8137: END IF;
8138:
8139: OPEN get_task_ver_weighting(l_task_versions_rec.element_version_id);
8140: FETCH get_task_ver_weighting into l_weighting_percentage;

Line 8325: pa_debug.debug('create structure version attribute');

8321: FETCH l_get_structure_ver_attr_csr INTO l_structure_ver_attr_rec;
8322: CLOSE l_get_structure_ver_attr_csr;
8323:
8324: IF (p_debug_mode = 'Y') THEN
8325: pa_debug.debug('create structure version attribute');
8326: END IF;
8327:
8328: IF (l_copy = 1) THEN
8329: l_status_code := 'STRUCTURE_WORKING';

Line 8425: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE END');

8421: COMMIT;
8422: END IF;
8423:
8424: IF (p_debug_mode = 'Y') THEN
8425: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE END');
8426: END IF;
8427:
8428: EXCEPTION
8429: when FND_API.G_EXC_ERROR then

Line 8786: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION BEGIN');

8782: where a.project_id = b.project_id
8783: and b.element_version_id = p_structure_version_id;
8784: BEGIN
8785: IF (p_debug_mode = 'Y') THEN
8786: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION BEGIN');
8787: END IF;
8788:
8789: IF (p_commit = FND_API.G_TRUE) THEN
8790: savepoint baseline_structure_pvt;

Line 8905: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION end');

8901: END IF;
8902: -- End of changes
8903:
8904: IF (p_debug_mode = 'Y') THEN
8905: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.BASELINE_STRUCTURE_VERSION end');
8906: END IF;
8907:
8908: x_return_status := FND_API.G_RET_STS_SUCCESS;
8909:

Line 8987: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.SPLIT_WORKPLAN BEGIN');

8983: l_pev_schedule_id NUMBER;
8984:
8985: BEGIN
8986: IF (p_debug_mode = 'Y') THEN
8987: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.SPLIT_WORKPLAN BEGIN');
8988: END IF;
8989:
8990: IF (p_commit = FND_API.G_TRUE) THEN
8991: savepoint split_workplan;

Line 8995: pa_debug.debug('Find existing structure');

8991: savepoint split_workplan;
8992: END IF;
8993:
8994: IF (p_debug_mode = 'Y') THEN
8995: pa_debug.debug('Find existing structure');
8996: END IF;
8997:
8998: --get current costing/billing structure id
8999: OPEN c1;

Line 9016: pa_debug.debug('Deleting type structure type');

9012: OPEN sel_struct_type(l_structure_id);
9013: FETCH sel_struct_type INTO l_rowid;
9014: IF sel_struct_type%FOUND THEN
9015: IF (p_debug_mode = 'Y') THEN
9016: pa_debug.debug('Deleting type structure type');
9017: END IF;
9018: PA_PROJ_STRUCTURE_TYPES_PKG.delete_row(l_rowid);
9019: END IF;
9020: CLOSE sel_struct_type;

Line 9117: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.SPLIT_WORKPLAN end');

9113:
9114: x_return_status := FND_API.G_RET_STS_SUCCESS;
9115:
9116: IF (p_debug_mode = 'Y') THEN
9117: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.SPLIT_WORKPLAN end');
9118: END IF;
9119:
9120: EXCEPTION
9121: when FND_API.G_EXC_ERROR then

Line 9227: PA_DEBUG.INIT_ERR_STACK('PA_PROJECT_STRUCTURE_PVT1.SUBMIT_WORKPLAN');

9223: and b.object_type = 'PA_STRUCTURES';
9224: l_del_struc_ver_id NUMBER;
9225:
9226: BEGIN
9227: PA_DEBUG.INIT_ERR_STACK('PA_PROJECT_STRUCTURE_PVT1.SUBMIT_WORKPLAN');
9228:
9229: x_return_status := FND_API.G_RET_STS_SUCCESS;
9230:
9231: IF (p_commit = FND_API.G_TRUE) THEN

Line 9523: PA_DEBUG.init_err_stack('PA_PROJECT_STRUCTURE_PVT1.CHANGE_WORKPLAN_STATUS');

9519: where project_status_code = c_status_code
9520: and status_type = 'STRUCTURE';
9521:
9522: BEGIN
9523: PA_DEBUG.init_err_stack('PA_PROJECT_STRUCTURE_PVT1.CHANGE_WORKPLAN_STATUS');
9524:
9525: -- Initialize the return status to success
9526: x_return_status := FND_API.G_RET_STS_SUCCESS;
9527:

Line 9700: PA_DEBUG.init_err_stack('PA_PROJECT_STRUCTURE_PVT1.REWORK_WORKPLAN');

9696: and pps.status_type = 'STRUCTURE'
9697: and pps.project_status_code = 'STRUCTURE_SUBMITTED';
9698:
9699: BEGIN
9700: PA_DEBUG.init_err_stack('PA_PROJECT_STRUCTURE_PVT1.REWORK_WORKPLAN');
9701: x_return_status := FND_API.G_RET_STS_SUCCESS;
9702:
9703: IF (p_commit = FND_API.G_TRUE) THEN
9704: savepoint rework_workplan_pvt;

Line 10057: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_structures_setup_attr');

10053:
10054: l_wp_name VARCHAR2(240);
10055: BEGIN
10056: IF (p_debug_mode = 'Y') THEN
10057: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_structures_setup_attr');
10058: END IF;
10059:
10060: IF (p_commit = FND_API.G_TRUE) THEN
10061: savepoint update_struc_setup_attr_pvt;

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

10061: savepoint update_struc_setup_attr_pvt;
10062: END IF;
10063:
10064: IF (p_debug_mode = 'Y') THEN
10065: pa_debug.debug('Performing validations');
10066: END IF;
10067:
10068: /*
10069: --For enabling workplan

Line 11277: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_structures_setup_attr end');

11273:
11274: x_return_status := FND_API.G_RET_STS_SUCCESS;
11275:
11276: IF (p_debug_mode = 'Y') THEN
11277: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_structures_setup_attr end');
11278: END IF;
11279:
11280: EXCEPTION
11281: WHEN FND_API.G_EXC_ERROR THEN

Line 11412: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_workplan_versioning');

11408: --end bug 4546607
11409:
11410: BEGIN
11411: IF (p_debug_mode = 'Y') THEN
11412: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_workplan_versioning');
11413: END IF;
11414:
11415: IF (p_commit = FND_API.G_TRUE) THEN
11416: savepoint update_wp_versioning_pvt;

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

11416: savepoint update_wp_versioning_pvt;
11417: END IF;
11418:
11419: IF (p_debug_mode = 'Y') THEN
11420: pa_debug.debug('Performing validations');
11421: END IF;
11422:
11423: IF (p_enable_wp_version_flag = 'Y') THEN
11424: --enable versioning

Line 11622: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_workplan_versioning end');

11618:
11619: x_return_status := FND_API.G_RET_STS_SUCCESS;
11620:
11621: IF (p_debug_mode = 'Y') THEN
11622: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_workplan_versioning end');
11623: END IF;
11624:
11625: EXCEPTION
11626: WHEN FND_API.G_EXC_ERROR THEN

Line 11733: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_WP_CALENDAR BEGIN');

11729: l_bsl_dur NUMBER; -- Bug 3657808
11730: --
11731: BEGIN
11732: IF (p_debug_mode = 'Y') THEN
11733: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_WP_CALENDAR BEGIN');
11734: END IF;
11735:
11736: IF (p_commit = FND_API.G_TRUE) THEN
11737: savepoint update_wp_calendar;

Line 11960: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_WP_CALENDAR end');

11956:
11957: x_return_status := FND_API.G_RET_STS_SUCCESS;
11958:
11959: IF (p_debug_mode = 'Y') THEN
11960: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_WP_CALENDAR end');
11961: END IF;
11962:
11963: EXCEPTION
11964: WHEN FND_API.G_EXC_ERROR THEN

Line 12006: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_ALL_WP_CALENDAR BEGIN');

12002: from pa_projects_all
12003: where calendar_id = p_calendar_id;
12004: BEGIN
12005: IF (p_debug_mode = 'Y') THEN
12006: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_ALL_WP_CALENDAR BEGIN');
12007: END IF;
12008:
12009: IF (p_commit = FND_API.G_TRUE) THEN
12010: savepoint update_all_wp_calendar;

Line 12035: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_ALL_WP_CALENDAR END');

12031: END LOOP;
12032: x_return_status := FND_API.G_RET_STS_SUCCESS;
12033:
12034: IF (p_debug_mode = 'Y') THEN
12035: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.UPDATE_ALL_WP_CALENDAR END');
12036: END IF;
12037:
12038: EXCEPTION
12039: WHEN OTHERS THEN

Line 12100: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.RECALC_STRUC_VER_DURATION BEGIN');

12096: l_est_days NUMBER; -- Bug 3657808
12097: BEGIN
12098:
12099: IF (p_debug_mode = 'Y') THEN
12100: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.RECALC_STRUC_VER_DURATION BEGIN');
12101: END IF;
12102:
12103: IF (p_commit = FND_API.G_TRUE) THEN
12104: savepoint RECALC_STRUC_VER_DURATION;

Line 12221: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.RECALC_STRUC_VER_DURATION end');

12217: END LOOP;
12218: CLOSE get_dates;
12219:
12220: IF (p_debug_mode = 'Y') THEN
12221: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.RECALC_STRUC_VER_DURATION end');
12222: END IF;
12223:
12224: EXCEPTION
12225: WHEN FND_API.G_EXC_ERROR THEN

Line 12328: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL begin');

12324: l_parent_struc_ver_id PA_PROJ_ELEMENT_VERSIONS.PARENT_STRUCTURE_VERSION_ID%TYPE;
12325:
12326: BEGIN
12327: IF (p_debug_mode = 'Y') THEN
12328: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL begin');
12329: END IF;
12330:
12331: IF (p_commit = FND_API.G_TRUE) THEN
12332: savepoint delete_struc_ver_wo_val;

Line 12336: pa_debug.debug('get structure version_info');

12332: savepoint delete_struc_ver_wo_val;
12333: END IF;
12334:
12335: IF (p_debug_mode = 'Y') THEN
12336: pa_debug.debug('get structure version_info');
12337: END IF;
12338:
12339: --Delete logic
12340: --Get structure version information

Line 12365: pa_debug.debug('deleting task version '||to_char(l_task_version_id));

12361: LOOP
12362: FETCH get_top_tasks into l_task_version_id;
12363: EXIT WHEN get_top_tasks%NOTFOUND;
12364: IF (p_debug_mode = 'Y') THEN
12365: pa_debug.debug('deleting task version '||to_char(l_task_version_id));
12366: END IF;
12367:
12368: --Get record version number for task, as it will change everytime
12369: --a task is deleted.

Line 12404: pa_debug.debug('done deleting tasks');

12400: END LOOP;
12401: CLOSE get_top_tasks;
12402:
12403: IF (p_debug_mode = 'Y') THEN
12404: pa_debug.debug('done deleting tasks');
12405: END IF;
12406: --If all tasks are deleted, delete schedule if workplan
12407: --Check if this is workplan
12408: If ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN')) THEN

Line 12411: pa_debug.debug('WORKPLAN type');

12407: --Check if this is workplan
12408: If ('Y' = PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Version(p_structure_version_id, 'WORKPLAN')) THEN
12409: --Structure type exists. Delete from schedule table
12410: IF (p_debug_mode = 'Y') THEN
12411: pa_debug.debug('WORKPLAN type');
12412: END IF;
12413: PA_PROJ_ELEMENT_SCH_PKG.Delete_Row(l_pevsh_rowid);
12414:
12415: --bug 4172646

Line 12439: pa_debug.debug('del structure version attr');

12435: raise FND_API.G_EXC_ERROR;
12436: END IF;
12437:
12438: IF (p_debug_mode = 'Y') THEN
12439: pa_debug.debug('del structure version attr');
12440: END IF;
12441: --Delete structure version attribute
12442: PA_PROJECT_STRUCTURE_PVT1.Delete_Structure_Version_Attr(
12443: p_commit => p_commit,

Line 12467: pa_debug.debug('del structure version');

12463: END IF;
12464:
12465:
12466: IF (p_debug_mode = 'Y') THEN
12467: pa_debug.debug('del structure version');
12468: END IF;
12469:
12470: --Delete structure version
12471: PA_PROJECT_STRUCTURE_PVT1.Delete_Structure_Version(

Line 12502: pa_debug.debug('delete non-versioned structure');

12498: FETCH is_last_version into l_dummy;
12499: IF is_last_version%NOTFOUND THEN
12500: --We are deleting the last version. Delete structure
12501: IF (p_debug_mode = 'Y') THEN
12502: pa_debug.debug('delete non-versioned structure');
12503: END IF;
12504:
12505:
12506: IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_proj_element_id, 'WORKPLAN') = 'Y') THEN

Line 12594: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL end');

12590:
12591: x_return_status := FND_API.G_RET_STS_SUCCESS;
12592:
12593: IF (p_debug_mode = 'Y') THEN
12594: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.DELETE_STRUC_VER_WO_VAL end');
12595: END IF;
12596:
12597: EXCEPTION
12598: when FND_API.G_EXC_ERROR then

Line 13376: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION_BULK');

13372: l_fin_struc VARCHAR2(1);
13373:
13374: BEGIN
13375:
13376: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION_BULK');
13377:
13378: IF (p_debug_mode = 'Y') THEN
13379: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION_BULK begin');
13380: END IF;

Line 13379: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION_BULK begin');

13375:
13376: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION_BULK');
13377:
13378: IF (p_debug_mode = 'Y') THEN
13379: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION_BULK begin');
13380: END IF;
13381:
13382: IF (p_commit = FND_API.G_TRUE) THEN
13383: savepoint copy_structure_version_pvt_blk;

Line 13467: pa_debug.debug('Create Structure Version Bulk return status: ' || l_return_status);

13463: ,x_msg_data => l_msg_data );
13464: */
13465:
13466: If (p_debug_mode = 'Y') THEN
13467: pa_debug.debug('Create Structure Version Bulk return status: ' || l_return_status);
13468: pa_debug.debug('l_new_struct_ver_id: ' || l_new_struct_ver_id);
13469: END IF;
13470:
13471:

Line 13468: pa_debug.debug('l_new_struct_ver_id: ' || l_new_struct_ver_id);

13464: */
13465:
13466: If (p_debug_mode = 'Y') THEN
13467: pa_debug.debug('Create Structure Version Bulk return status: ' || l_return_status);
13468: pa_debug.debug('l_new_struct_ver_id: ' || l_new_struct_ver_id);
13469: END IF;
13470:
13471:
13472: --Check if there is any error.

Line 13509: pa_debug.debug('Create Structure Version Bulk Attr return status: ' || l_return_status);

13505: ,x_msg_count => l_msg_count
13506: ,x_msg_data => l_msg_data );
13507:
13508: IF (p_debug_mode = 'Y') THEN
13509: pa_debug.debug('Create Structure Version Bulk Attr return status: ' || l_return_status);
13510: pa_debug.debug('l_pev_structure_id: ' || l_pev_structure_id);
13511: END IF;
13512:
13513: --Check if there is any error.

Line 13510: pa_debug.debug('l_pev_structure_id: ' || l_pev_structure_id);

13506: ,x_msg_data => l_msg_data );
13507:
13508: IF (p_debug_mode = 'Y') THEN
13509: pa_debug.debug('Create Structure Version Bulk Attr return status: ' || l_return_status);
13510: pa_debug.debug('l_pev_structure_id: ' || l_pev_structure_id);
13511: END IF;
13512:
13513: --Check if there is any error.
13514: l_msg_count := FND_MSG_PUB.count_msg;

Line 13594: pa_debug.debug('Create Schedule Version Bulk return status: ' || l_return_status);

13590: );
13591:
13592:
13593: IF (p_debug_mode = 'Y') THEN
13594: pa_debug.debug('Create Schedule Version Bulk return status: ' || l_return_status);
13595: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);
13596: END IF;
13597:
13598: --Check if there is any error.

Line 13595: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);

13591:
13592:
13593: IF (p_debug_mode = 'Y') THEN
13594: pa_debug.debug('Create Schedule Version Bulk return status: ' || l_return_status);
13595: pa_debug.debug('l_pev_schedule_id: ' || l_pev_schedule_id);
13596: END IF;
13597:
13598: --Check if there is any error.
13599: l_msg_count := FND_MSG_PUB.count_msg;

Line 14067: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION_BULK END');

14063: COMMIT;
14064: END IF;
14065:
14066: IF (p_debug_mode = 'Y') THEN
14067: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.COPY_STRUCTURE_VERSION_BULK END');
14068: END IF;
14069:
14070: EXCEPTION
14071: when FND_API.G_EXC_ERROR then

Line 14521: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_structures_setup_attr');

14517: -- End fix for Bug # 4426392.
14518:
14519: BEGIN
14520: IF (p_debug_mode = 'Y') THEN
14521: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_structures_setup_attr');
14522: END IF;
14523:
14524: IF (p_commit = FND_API.G_TRUE) THEN
14525: savepoint update_struc_setup_attr_pvt;

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

14525: savepoint update_struc_setup_attr_pvt;
14526: END IF;
14527:
14528: IF (p_debug_mode = 'Y') THEN
14529: pa_debug.debug('Performing validations');
14530: END IF;
14531:
14532: l_wp_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_workplan_enabled(p_project_id);
14533: l_fin_enabled := PA_PROJECT_STRUCTURE_UTILS.Check_financial_enabled(p_project_id);

Line 18160: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_structures_setup_attr end');

18156:
18157: x_return_status := FND_API.G_RET_STS_SUCCESS;
18158:
18159: IF (p_debug_mode = 'Y') THEN
18160: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.update_structures_setup_attr end');
18161: END IF;
18162:
18163: EXCEPTION
18164: WHEN FND_API.G_EXC_ERROR THEN