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

Line 355: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE');

351: l_msg_index_out NUMBER;
352:
353:
354: BEGIN
355: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE');
356:
357: IF (p_debug_mode = 'Y') THEN
358: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE begin');
359: END IF;

Line 358: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE begin');

354: BEGIN
355: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE');
356:
357: IF (p_debug_mode = 'Y') THEN
358: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE begin');
359: END IF;
360:
361: IF (p_commit = FND_API.G_TRUE) THEN
362: savepoint create_structure;

Line 453: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE END');

449: COMMIT;
450: END IF;
451:
452: IF (p_debug_mode = 'Y') THEN
453: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE END');
454: END IF;
455:
456: EXCEPTION
457: when FND_API.G_EXC_ERROR then

Line 568: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION');

564: l_data VARCHAR2(250);
565: l_msg_index_out NUMBER;
566:
567: BEGIN
568: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION');
569:
570: IF (p_debug_mode = 'Y') THEN
571: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION begin');
572: END IF;

Line 571: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION begin');

567: BEGIN
568: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION');
569:
570: IF (p_debug_mode = 'Y') THEN
571: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION begin');
572: END IF;
573:
574: IF (p_commit = FND_API.G_TRUE) THEN
575: savepoint create_structure_version;

Line 641: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION END');

637: COMMIT;
638: END IF;
639:
640: IF (p_debug_mode = 'Y') THEN
641: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION END');
642: END IF;
643:
644: EXCEPTION
645: when FND_API.G_EXC_ERROR then

Line 743: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION_ATTR');

739: l_data VARCHAR2(250);
740: l_msg_index_out NUMBER;
741:
742: BEGIN
743: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION_ATTR');
744:
745: IF (p_debug_mode = 'Y') THEN
746: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION_ATTR begin');
747: END IF;

Line 746: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION_ATTR begin');

742: BEGIN
743: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION_ATTR');
744:
745: IF (p_debug_mode = 'Y') THEN
746: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION_ATTR begin');
747: END IF;
748:
749: IF (p_commit = FND_API.G_TRUE) THEN
750: savepoint create_structure_version_attr;

Line 810: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION_ATTR END');

806: COMMIT;
807: END IF;
808:
809: IF (p_debug_mode = 'Y') THEN
810: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CREATE_STRUCTURE_VERSION_ATTR END');
811: END IF;
812:
813: EXCEPTION
814: when FND_API.G_EXC_ERROR then

Line 945: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE');

941: l_dummy VARCHAR2(1);
942:
943:
944: BEGIN
945: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE');
946:
947: IF (p_debug_mode = 'Y') THEN
948: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE begin');
949: END IF;

Line 948: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE begin');

944: BEGIN
945: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE');
946:
947: IF (p_debug_mode = 'Y') THEN
948: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE begin');
949: END IF;
950:
951: IF (p_commit = FND_API.G_TRUE) THEN
952: savepoint update_structure;

Line 1079: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE end');

1075: COMMIT;
1076: END IF;
1077:
1078: IF (p_debug_mode = 'Y') THEN
1079: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE end');
1080: END IF;
1081:
1082: EXCEPTION
1083: when FND_API.G_EXC_ERROR then

Line 1194: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.Update_Structure_Version_Attr');

1190: l_data VARCHAR2(250);
1191: l_msg_index_out NUMBER;
1192:
1193: BEGIN
1194: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.Update_Structure_Version_Attr');
1195:
1196: IF (p_debug_mode = 'Y') THEN
1197: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE_VERSION_ATTR begin');
1198: END IF;

Line 1197: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE_VERSION_ATTR begin');

1193: BEGIN
1194: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.Update_Structure_Version_Attr');
1195:
1196: IF (p_debug_mode = 'Y') THEN
1197: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE_VERSION_ATTR begin');
1198: END IF;
1199:
1200: IF (p_commit = FND_API.G_TRUE) THEN
1201: savepoint update_structure_version_attr;

Line 1278: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE_VERSION_ATTR END');

1274: COMMIT;
1275: END IF;
1276:
1277: IF (p_debug_mode = 'Y') THEN
1278: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURE_VERSION_ATTR END');
1279: END IF;
1280:
1281: EXCEPTION
1282: when FND_API.G_EXC_ERROR then

Line 1438: pa_debug.init_err_stack('PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version');

1434: i BINARY_INTEGER := 0;
1435:
1436:
1437: BEGIN
1438: pa_debug.init_err_stack('PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version');
1439:
1440: IF (p_debug_mode = 'Y') THEN
1441: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_STRUCTURE_VERSION begin');
1442: END IF;

Line 1441: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_STRUCTURE_VERSION begin');

1437: BEGIN
1438: pa_debug.init_err_stack('PA_PROJECT_STRUCTURE_PUB1.Delete_Structure_Version');
1439:
1440: IF (p_debug_mode = 'Y') THEN
1441: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_STRUCTURE_VERSION begin');
1442: END IF;
1443:
1444: IF (p_commit = FND_API.G_TRUE) THEN
1445: savepoint delete_structure_version;

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

1453: FND_MSG_PUB.initialize;
1454: END IF;
1455:
1456: IF (p_debug_mode = 'Y') THEN
1457: pa_debug.debug('get structure version_info');
1458: END IF;
1459:
1460: --Delete logic
1461: --Get structure version information

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

1556: LOOP
1557: FETCH get_top_tasks into l_task_version_id;
1558: EXIT WHEN get_top_tasks%NOTFOUND;
1559: IF (p_debug_mode = 'Y') THEN
1560: pa_debug.debug('deleting task version '||to_char(l_task_version_id));
1561: END IF;
1562:
1563: --Get record version number for task, as it will change everytime
1564: --a task is deleted.

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

1594: END LOOP;
1595: CLOSE get_top_tasks;
1596:
1597: IF (p_debug_mode = 'Y') THEN
1598: pa_debug.debug('done deleting tasks');
1599: END IF;
1600: --If all tasks are deleted, delete schedule if workplan
1601: --Check if this is workplan
1602:

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

1609:
1610: If (l_structure_type = 'WORKPLAN') THEN
1611: --Structure type exists. Delete from schedule table
1612: IF (p_debug_mode = 'Y') THEN
1613: pa_debug.debug('WORKPLAN type');
1614: END IF;
1615: PA_PROJ_ELEMENT_SCH_PKG.Delete_Row(l_pevsh_rowid);
1616:
1617: END IF;

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

1632: raise FND_API.G_EXC_ERROR;
1633: END IF;
1634:
1635: IF (p_debug_mode = 'Y') THEN
1636: pa_debug.debug('del structure version attr');
1637: END IF;
1638: --Delete structure version attribute
1639: PA_PROJECT_STRUCTURE_PVT1.Delete_Structure_Version_Attr(
1640: p_commit => p_commit,

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

1660: END IF;
1661:
1662:
1663: IF (p_debug_mode = 'Y') THEN
1664: pa_debug.debug('del structure version');
1665: END IF;
1666:
1667: --Delete structure version
1668: PA_PROJECT_STRUCTURE_PVT1.Delete_Structure_Version(

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

1695: FETCH is_last_version into l_dummy;
1696: IF is_last_version%NOTFOUND THEN
1697: --We are deleting the last version. Delete structure
1698: IF (p_debug_mode = 'Y') THEN
1699: pa_debug.debug('delete non-versioned structure');
1700: END IF;
1701:
1702: IF (PA_PROJECT_STRUCTURE_UTILS.Get_Struc_Type_For_Structure(l_proj_element_id, 'WORKPLAN') = 'Y') THEN
1703: --delete workplan attribute

Line 1793: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_STRUCTURE_VERSION end');

1789:
1790: x_return_status := FND_API.G_RET_STS_SUCCESS;
1791:
1792: IF (p_debug_mode = 'Y') THEN
1793: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_STRUCTURE_VERSION end');
1794: END IF;
1795:
1796: END IF; -- End of IF l_strucutre_status = 'STRUCTURE_PUBLISHED' THEN
1797:

Line 1915: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE');

1911: from pa_proj_element_versions
1912: where element_version_id = p_structure_version_id;
1913:
1914: BEGIN
1915: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE');
1916:
1917: IF (p_debug_mode = 'Y') THEN
1918: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE begin');
1919: END IF;

Line 1918: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE begin');

1914: BEGIN
1915: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE');
1916:
1917: IF (p_debug_mode = 'Y') THEN
1918: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE begin');
1919: END IF;
1920:
1921: IF (p_commit = FND_API.G_TRUE) THEN
1922: savepoint publish_structure;

Line 2051: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE end');

2047: COMMIT;
2048: END IF;
2049:
2050: IF (p_debug_mode = 'Y') THEN
2051: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE end');
2052: END IF;
2053:
2054: EXCEPTION
2055: when FND_API.G_EXC_ERROR then

Line 2153: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE');

2149: l_data VARCHAR2(250);
2150: l_msg_index_out NUMBER;
2151: BEGIN
2152:
2153: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE');
2154:
2155: IF (p_debug_mode = 'Y') THEN
2156: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE begin');
2157: END IF;

Line 2156: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE begin');

2152:
2153: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE');
2154:
2155: IF (p_debug_mode = 'Y') THEN
2156: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE begin');
2157: END IF;
2158:
2159: IF (p_commit = FND_API.G_TRUE) THEN
2160: savepoint copy_structure;

Line 2211: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE END');

2207: COMMIT;
2208: END IF;
2209:
2210: IF (p_debug_mode = 'Y') THEN
2211: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE END');
2212: END IF;
2213:
2214: EXCEPTION
2215: when FND_API.G_EXC_ERROR then

Line 2307: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION');

2303: l_data VARCHAR2(250);
2304: l_msg_index_out NUMBER;
2305: BEGIN
2306:
2307: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION');
2308:
2309: IF (p_debug_mode = 'Y') THEN
2310: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION begin');
2311: END IF;

Line 2310: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION begin');

2306:
2307: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION');
2308:
2309: IF (p_debug_mode = 'Y') THEN
2310: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION begin');
2311: END IF;
2312:
2313: IF (p_commit = FND_API.G_TRUE) THEN
2314: savepoint copy_structure_version;

Line 2364: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION END');

2360: COMMIT;
2361: END IF;
2362:
2363: IF (p_debug_mode = 'Y') THEN
2364: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION END');
2365: END IF;
2366:
2367: EXCEPTION
2368: when FND_API.G_EXC_ERROR then

Line 2433: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN');

2429: l_data VARCHAR2(250);
2430: l_msg_index_out NUMBER;
2431: l_project_id NUMBER;
2432: BEGIN
2433: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN');
2434:
2435: IF (p_debug_mode = 'Y') THEN
2436: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN begin');
2437: END IF;

Line 2436: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN begin');

2432: BEGIN
2433: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN');
2434:
2435: IF (p_debug_mode = 'Y') THEN
2436: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN begin');
2437: END IF;
2438:
2439: IF (p_commit = FND_API.G_TRUE) THEN
2440: savepoint submit_workplan;

Line 2496: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN end');

2492: COMMIT;
2493: END IF;
2494:
2495: IF (p_debug_mode = 'Y') THEN
2496: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN end');
2497: END IF;
2498:
2499: EXCEPTION
2500: when FND_API.G_EXC_ERROR then

Line 2561: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN');

2557: l_data VARCHAR2(250);
2558: l_msg_index_out NUMBER;
2559: l_project_id NUMBER;
2560: BEGIN
2561: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN');
2562:
2563: IF (p_debug_mode = 'Y') THEN
2564: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN begin');
2565: END IF;

Line 2564: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN begin');

2560: BEGIN
2561: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN');
2562:
2563: IF (p_debug_mode = 'Y') THEN
2564: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN begin');
2565: END IF;
2566:
2567: IF (p_commit = FND_API.G_TRUE) THEN
2568: savepoint rework_workplan;

Line 2615: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN end');

2611: COMMIT;
2612: END IF;
2613:
2614: IF (p_debug_mode = 'Y') THEN
2615: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN end');
2616: END IF;
2617:
2618: EXCEPTION
2619: when FND_API.G_EXC_ERROR then

Line 2707: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');

2703: l_data VARCHAR2(250);
2704: l_msg_index_out NUMBER;
2705:
2706: BEGIN
2707: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');
2708:
2709: IF (p_debug_mode = 'Y') THEN
2710: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');
2711: END IF;

Line 2710: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');

2706: BEGIN
2707: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');
2708:
2709: IF (p_debug_mode = 'Y') THEN
2710: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');
2711: END IF;
2712:
2713: IF (p_commit = FND_API.G_TRUE) THEN
2714: savepoint update_struc_setup_attr_pub;

Line 2767: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR end');

2763: COMMIT;
2764: END IF;
2765:
2766: IF (p_debug_mode = 'Y') THEN
2767: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR end');
2768: END IF;
2769:
2770: EXCEPTION
2771: when FND_API.G_EXC_ERROR then

Line 2826: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');

2822: l_data VARCHAR2(250);
2823: l_msg_index_out NUMBER;
2824:
2825: BEGIN
2826: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');
2827:
2828: IF (p_debug_mode = 'Y') THEN
2829: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');
2830: END IF;

Line 2829: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');

2825: BEGIN
2826: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');
2827:
2828: IF (p_debug_mode = 'Y') THEN
2829: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');
2830: END IF;
2831:
2832: IF (p_commit = FND_API.G_TRUE) THEN
2833: savepoint update_wp_versioning_pub;

Line 2880: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_WORKPLAN_VERSIONING end');

2876: COMMIT;
2877: END IF;
2878:
2879: IF (p_debug_mode = 'Y') THEN
2880: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_WORKPLAN_VERSIONING end');
2881: END IF;
2882:
2883: EXCEPTION
2884: when FND_API.G_EXC_ERROR then

Line 2976: pa_debug.init_err_stack('PA_PROJECT_STRUCTURE_PUB1.Delete_Working_Struc_Ver');

2972: where element_version_id = p_structure_version_id;
2973: l_project_id NUMBER;
2974:
2975: BEGIN
2976: pa_debug.init_err_stack('PA_PROJECT_STRUCTURE_PUB1.Delete_Working_Struc_Ver');
2977:
2978: IF (p_debug_mode = 'Y') THEN
2979: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_WORKINGSTRUC_VER begin');
2980: END IF;

Line 2979: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_WORKINGSTRUC_VER begin');

2975: BEGIN
2976: pa_debug.init_err_stack('PA_PROJECT_STRUCTURE_PUB1.Delete_Working_Struc_Ver');
2977:
2978: IF (p_debug_mode = 'Y') THEN
2979: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_WORKINGSTRUC_VER begin');
2980: END IF;
2981:
2982: IF (p_commit = FND_API.G_TRUE) THEN
2983: savepoint delete_working_struc_ver;

Line 3042: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_STRUCTURE_VERSION end');

3038:
3039: x_return_status := FND_API.G_RET_STS_SUCCESS;
3040:
3041: IF (p_debug_mode = 'Y') THEN
3042: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_STRUCTURE_VERSION end');
3043: END IF;
3044:
3045: EXCEPTION
3046: when FND_API.G_EXC_ERROR then

Line 3121: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE');

3117: l_proj_progress_attr_id NUMBER;
3118:
3119: BEGIN
3120:
3121: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE');
3122:
3123: IF (p_debug_mode = 'Y') THEN
3124: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE begin');
3125: END IF;

Line 3124: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE begin');

3120:
3121: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE');
3122:
3123: IF (p_debug_mode = 'Y') THEN
3124: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE begin');
3125: END IF;
3126:
3127: IF (p_commit = FND_API.G_TRUE) THEN
3128: savepoint ENABLE_FINANCIAL_STRUCTURE;

Line 3227: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE END');

3223: COMMIT;
3224: END IF;
3225:
3226: IF (p_debug_mode = 'Y') THEN
3227: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE END');
3228: END IF;
3229:
3230: EXCEPTION
3231: when FND_API.G_EXC_ERROR then

Line 3317: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE');

3313: where proj_element_id = c_structure_id
3314: and project_id = p_project_id;
3315:
3316: BEGIN
3317: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE');
3318:
3319: IF (p_debug_mode = 'Y') THEN
3320: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE begin');
3321: END IF;

Line 3320: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE begin');

3316: BEGIN
3317: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE');
3318:
3319: IF (p_debug_mode = 'Y') THEN
3320: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE begin');
3321: END IF;
3322:
3323: IF (p_commit = FND_API.G_TRUE) THEN
3324: savepoint DISABLE_FINANCIAL_STRUCTURE;

Line 3525: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE END');

3521: COMMIT;
3522: END IF;
3523:
3524: IF (p_debug_mode = 'Y') THEN
3525: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE END');
3526: END IF;
3527:
3528: EXCEPTION
3529: when FND_API.G_EXC_ERROR then

Line 3614: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG');

3610: l_data VARCHAR2(250);
3611: l_msg_index_out NUMBER;
3612: BEGIN
3613:
3614: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG');
3615:
3616: IF (p_debug_mode = 'Y') THEN
3617: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG begin');
3618: END IF;

Line 3617: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG begin');

3613:
3614: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG');
3615:
3616: IF (p_debug_mode = 'Y') THEN
3617: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG begin');
3618: END IF;
3619:
3620: IF (p_commit = FND_API.G_TRUE) THEN
3621: savepoint CLEAR_FINANCIAL_FLAG;

Line 3668: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG END');

3664: COMMIT;
3665: END IF;
3666:
3667: IF (p_debug_mode = 'Y') THEN
3668: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG END');
3669: END IF;
3670:
3671: EXCEPTION
3672: when FND_API.G_EXC_ERROR then

Line 3753: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag');

3749: l_data VARCHAR2(250);
3750: l_msg_index_out NUMBER;
3751: --
3752: BEGIN
3753: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag');
3754: --
3755: IF (p_debug_mode = 'Y') THEN
3756: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag begin');
3757: END IF;

Line 3756: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag begin');

3752: BEGIN
3753: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag');
3754: --
3755: IF (p_debug_mode = 'Y') THEN
3756: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag begin');
3757: END IF;
3758: --
3759: IF (p_commit = FND_API.G_TRUE) THEN
3760: savepoint update_sch_dirty_flag_pub;

Line 3800: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_SCH_DIRTY_FLAG end');

3796: COMMIT;
3797: END IF;
3798: --
3799: IF (p_debug_mode = 'Y') THEN
3800: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_SCH_DIRTY_FLAG end');
3801: END IF;
3802: --
3803: EXCEPTION
3804: WHEN FND_API.G_EXC_ERROR THEN

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

4004: BEGIN
4005:
4006: -- SAVEPOINT DELETE_PUBLISHED_STRUCTURE_VER;
4007:
4008: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4009:
4010: -- Standard call to check for call compatibility.
4011:
4012: IF NOT FND_API.Compatible_API_Call ( 1.0 ,