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 1916: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE');

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

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

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

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

2063: COMMIT;
2064: END IF;
2065:
2066: IF (p_debug_mode = 'Y') THEN
2067: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.PUBLISH_STRUCTURE end');
2068: END IF;
2069:
2070: EXCEPTION
2071: when FND_API.G_EXC_ERROR then

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

2165: l_data VARCHAR2(250);
2166: l_msg_index_out NUMBER;
2167: BEGIN
2168:
2169: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE');
2170:
2171: IF (p_debug_mode = 'Y') THEN
2172: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE begin');
2173: END IF;

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

2168:
2169: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE');
2170:
2171: IF (p_debug_mode = 'Y') THEN
2172: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE begin');
2173: END IF;
2174:
2175: IF (p_commit = FND_API.G_TRUE) THEN
2176: savepoint copy_structure;

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

2223: COMMIT;
2224: END IF;
2225:
2226: IF (p_debug_mode = 'Y') THEN
2227: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE END');
2228: END IF;
2229:
2230: EXCEPTION
2231: when FND_API.G_EXC_ERROR then

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

2319: l_data VARCHAR2(250);
2320: l_msg_index_out NUMBER;
2321: BEGIN
2322:
2323: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION');
2324:
2325: IF (p_debug_mode = 'Y') THEN
2326: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION begin');
2327: END IF;

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

2322:
2323: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION');
2324:
2325: IF (p_debug_mode = 'Y') THEN
2326: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION begin');
2327: END IF;
2328:
2329: IF (p_commit = FND_API.G_TRUE) THEN
2330: savepoint copy_structure_version;

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

2376: COMMIT;
2377: END IF;
2378:
2379: IF (p_debug_mode = 'Y') THEN
2380: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.COPY_STRUCTURE_VERSION END');
2381: END IF;
2382:
2383: EXCEPTION
2384: when FND_API.G_EXC_ERROR then

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

2445: l_data VARCHAR2(250);
2446: l_msg_index_out NUMBER;
2447: l_project_id NUMBER;
2448: BEGIN
2449: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN');
2450:
2451: IF (p_debug_mode = 'Y') THEN
2452: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN begin');
2453: END IF;

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

2448: BEGIN
2449: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN');
2450:
2451: IF (p_debug_mode = 'Y') THEN
2452: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN begin');
2453: END IF;
2454:
2455: IF (p_commit = FND_API.G_TRUE) THEN
2456: savepoint submit_workplan;

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

2508: COMMIT;
2509: END IF;
2510:
2511: IF (p_debug_mode = 'Y') THEN
2512: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.SUBMIT_WORKPLAN end');
2513: END IF;
2514:
2515: EXCEPTION
2516: when FND_API.G_EXC_ERROR then

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

2573: l_data VARCHAR2(250);
2574: l_msg_index_out NUMBER;
2575: l_project_id NUMBER;
2576: BEGIN
2577: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN');
2578:
2579: IF (p_debug_mode = 'Y') THEN
2580: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN begin');
2581: END IF;

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

2576: BEGIN
2577: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN');
2578:
2579: IF (p_debug_mode = 'Y') THEN
2580: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN begin');
2581: END IF;
2582:
2583: IF (p_commit = FND_API.G_TRUE) THEN
2584: savepoint rework_workplan;

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

2627: COMMIT;
2628: END IF;
2629:
2630: IF (p_debug_mode = 'Y') THEN
2631: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.REWORK_WORKPLAN end');
2632: END IF;
2633:
2634: EXCEPTION
2635: when FND_API.G_EXC_ERROR then

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

2721: l_data VARCHAR2(250);
2722: l_msg_index_out NUMBER;
2723:
2724: BEGIN
2725: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');
2726:
2727: IF (p_debug_mode = 'Y') THEN
2728: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');
2729: END IF;

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

2724: BEGIN
2725: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');
2726:
2727: IF (p_debug_mode = 'Y') THEN
2728: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');
2729: END IF;
2730:
2731: IF (p_commit = FND_API.G_TRUE) THEN
2732: savepoint update_struc_setup_attr_pub;

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

2783: COMMIT;
2784: END IF;
2785:
2786: IF (p_debug_mode = 'Y') THEN
2787: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_STRUCTURES_SETUP_ATTR end');
2788: END IF;
2789:
2790: EXCEPTION
2791: when FND_API.G_EXC_ERROR then

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

2842: l_data VARCHAR2(250);
2843: l_msg_index_out NUMBER;
2844:
2845: BEGIN
2846: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');
2847:
2848: IF (p_debug_mode = 'Y') THEN
2849: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');
2850: END IF;

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

2845: BEGIN
2846: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr');
2847:
2848: IF (p_debug_mode = 'Y') THEN
2849: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_structures_setup_attr begin');
2850: END IF;
2851:
2852: IF (p_commit = FND_API.G_TRUE) THEN
2853: savepoint update_wp_versioning_pub;

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

2896: COMMIT;
2897: END IF;
2898:
2899: IF (p_debug_mode = 'Y') THEN
2900: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_WORKPLAN_VERSIONING end');
2901: END IF;
2902:
2903: EXCEPTION
2904: when FND_API.G_EXC_ERROR then

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

2992: where element_version_id = p_structure_version_id;
2993: l_project_id NUMBER;
2994:
2995: BEGIN
2996: pa_debug.init_err_stack('PA_PROJECT_STRUCTURE_PUB1.Delete_Working_Struc_Ver');
2997:
2998: IF (p_debug_mode = 'Y') THEN
2999: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_WORKINGSTRUC_VER begin');
3000: END IF;

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

2995: BEGIN
2996: pa_debug.init_err_stack('PA_PROJECT_STRUCTURE_PUB1.Delete_Working_Struc_Ver');
2997:
2998: IF (p_debug_mode = 'Y') THEN
2999: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_WORKINGSTRUC_VER begin');
3000: END IF;
3001:
3002: IF (p_commit = FND_API.G_TRUE) THEN
3003: savepoint delete_working_struc_ver;

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

3058:
3059: x_return_status := FND_API.G_RET_STS_SUCCESS;
3060:
3061: IF (p_debug_mode = 'Y') THEN
3062: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DELETE_STRUCTURE_VERSION end');
3063: END IF;
3064:
3065: EXCEPTION
3066: when FND_API.G_EXC_ERROR then

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

3137: l_proj_progress_attr_id NUMBER;
3138:
3139: BEGIN
3140:
3141: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE');
3142:
3143: IF (p_debug_mode = 'Y') THEN
3144: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE begin');
3145: END IF;

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

3140:
3141: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE');
3142:
3143: IF (p_debug_mode = 'Y') THEN
3144: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE begin');
3145: END IF;
3146:
3147: IF (p_commit = FND_API.G_TRUE) THEN
3148: savepoint ENABLE_FINANCIAL_STRUCTURE;

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

3243: COMMIT;
3244: END IF;
3245:
3246: IF (p_debug_mode = 'Y') THEN
3247: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.ENABLE_FINANCIAL_STRUCTURE END');
3248: END IF;
3249:
3250: EXCEPTION
3251: when FND_API.G_EXC_ERROR then

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

3333: where proj_element_id = c_structure_id
3334: and project_id = p_project_id;
3335:
3336: BEGIN
3337: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE');
3338:
3339: IF (p_debug_mode = 'Y') THEN
3340: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE begin');
3341: END IF;

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

3336: BEGIN
3337: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE');
3338:
3339: IF (p_debug_mode = 'Y') THEN
3340: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE begin');
3341: END IF;
3342:
3343: IF (p_commit = FND_API.G_TRUE) THEN
3344: savepoint DISABLE_FINANCIAL_STRUCTURE;

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

3541: COMMIT;
3542: END IF;
3543:
3544: IF (p_debug_mode = 'Y') THEN
3545: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.DISABLE_FINANCIAL_STRUCTURE END');
3546: END IF;
3547:
3548: EXCEPTION
3549: when FND_API.G_EXC_ERROR then

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

3630: l_data VARCHAR2(250);
3631: l_msg_index_out NUMBER;
3632: BEGIN
3633:
3634: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG');
3635:
3636: IF (p_debug_mode = 'Y') THEN
3637: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG begin');
3638: END IF;

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

3633:
3634: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG');
3635:
3636: IF (p_debug_mode = 'Y') THEN
3637: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG begin');
3638: END IF;
3639:
3640: IF (p_commit = FND_API.G_TRUE) THEN
3641: savepoint CLEAR_FINANCIAL_FLAG;

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

3684: COMMIT;
3685: END IF;
3686:
3687: IF (p_debug_mode = 'Y') THEN
3688: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.CLEAR_FINANCIAL_FLAG END');
3689: END IF;
3690:
3691: EXCEPTION
3692: when FND_API.G_EXC_ERROR then

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

3769: l_data VARCHAR2(250);
3770: l_msg_index_out NUMBER;
3771: --
3772: BEGIN
3773: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag');
3774: --
3775: IF (p_debug_mode = 'Y') THEN
3776: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag begin');
3777: END IF;

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

3772: BEGIN
3773: pa_debug.init_err_stack ('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag');
3774: --
3775: IF (p_debug_mode = 'Y') THEN
3776: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.update_sch_dirty_flag begin');
3777: END IF;
3778: --
3779: IF (p_commit = FND_API.G_TRUE) THEN
3780: savepoint update_sch_dirty_flag_pub;

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

3816: COMMIT;
3817: END IF;
3818: --
3819: IF (p_debug_mode = 'Y') THEN
3820: pa_debug.debug('PA_PROJECT_STRUCTURE_PUB1.UPDATE_SCH_DIRTY_FLAG end');
3821: END IF;
3822: --
3823: EXCEPTION
3824: WHEN FND_API.G_EXC_ERROR THEN

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

4024: BEGIN
4025:
4026: -- SAVEPOINT DELETE_PUBLISHED_STRUCTURE_VER;
4027:
4028: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4029:
4030: -- Standard call to check for call compatibility.
4031:
4032: IF NOT FND_API.Compatible_API_Call ( 1.0 ,

Line 4358: pa_debug.write('Inside Procedure VALIDATE_CBS',3);

4354:
4355: BEGIN
4356:
4357: x_valid_flag :='N'; -- Initially make the flag as N (invalid) , once all validations are passed then set it to Y(valid)
4358: pa_debug.write('Inside Procedure VALIDATE_CBS',3);
4359:
4360: If p_cbs_flag = 'Y' THEN
4361: err_msg_post :='_E';
4362: else

Line 4370: pa_debug.write('Check if there exists baseline funding with out budget:'||p_project_id,3);

4366: --------------------------------------------------------------------------------------------------------------------------
4367: /* baseline funding with out budget option should not be enabled for checking if the
4368: project is CBS enabled bug#16772073*/
4369: IF p_cbs_flag = 'Y' THEN
4370: pa_debug.write('Check if there exists baseline funding with out budget:'||p_project_id,3);
4371: OPEN C_BL_FUND_BUD_EXISTS;
4372: FETCH C_BL_FUND_BUD_EXISTS into L_DUMMY;
4373: CLOSE C_BL_FUND_BUD_EXISTS;
4374: IF L_DUMMY = 1 THEN

Line 4385: pa_debug.write('Check if there exists Resource Assignments for project:'||p_project_id,3);

4381:
4382: --------------------------------------------------------------------------------------------------------------------------
4383: /* Project should not have any resource assignments to enable for CBS ,
4384: since Cost Code is mandatory for resource assignments for CBS */
4385: pa_debug.write('Check if there exists Resource Assignments for project:'||p_project_id,3);
4386: OPEN C_RES_ASSIGNMENT_EXISTS;
4387: FETCH C_RES_ASSIGNMENT_EXISTS into L_DUMMY;
4388: CLOSE C_RES_ASSIGNMENT_EXISTS;
4389: IF L_DUMMY = 1 THEN

Line 4448: pa_debug.write('Check if there exists any actuals for the project',3);

4444: End If;
4445:
4446: -----------------------------------------------------------------------------------------------------------------------------
4447:
4448: pa_debug.write('Check if there exists any actuals for the project',3);
4449: OPEN C_CHECK_EXPENDITURE_ITEM;
4450: FETCH C_CHECK_EXPENDITURE_ITEM into L_DUMMY;
4451: CLOSE C_CHECK_EXPENDITURE_ITEM;
4452:

Line 4460: pa_debug.write('Check if there exists any purchase order distribution',3);

4456: END IF;
4457:
4458:
4459: -----------------------------------------------------------------------------------------------------------------------------
4460: pa_debug.write('Check if there exists any purchase order distribution',3);
4461: OPEN C_CHECK_PO_DIST_EXISTS;
4462: FETCH C_CHECK_PO_DIST_EXISTS into L_DUMMY;
4463: CLOSE C_CHECK_PO_DIST_EXISTS;
4464:

Line 4470: pa_debug.write('Check if there exists any purchase order requisitions',3);

4466: x_error_msg_code :='PA_CBS_PO_DIST_E';
4467: return;
4468: END IF;
4469: -----------------------------------------------------------------------------------------------------------------------------
4470: pa_debug.write('Check if there exists any purchase order requisitions',3);
4471: OPEN C_CHECK_PO_REQ_EXISTS;
4472: FETCH C_CHECK_PO_REQ_EXISTS into L_DUMMY;
4473: CLOSE C_CHECK_PO_REQ_EXISTS;
4474:

Line 4480: pa_debug.write('Check if there exists any supplier invoices',3);

4476: x_error_msg_code :='PA_CBS_PO_REQ_E';
4477: return;
4478: END IF;
4479: -----------------------------------------------------------------------------------------------------------------------------
4480: pa_debug.write('Check if there exists any supplier invoices',3);
4481: OPEN C_CHECK_AP_INVOICE_EXISTS;
4482: FETCH C_CHECK_AP_INVOICE_EXISTS into L_DUMMY;
4483: CLOSE C_CHECK_AP_INVOICE_EXISTS;
4484:

Line 4491: pa_debug.write('Check if there exists supplier invoices distribution',3);

4487: return;
4488: END IF;
4489:
4490: -----------------------------------------------------------------------------------------------------------------------------
4491: pa_debug.write('Check if there exists supplier invoices distribution',3);
4492: OPEN C_CHECK_AP_INVOICE_DIST_EXISTS;
4493: FETCH C_CHECK_AP_INVOICE_DIST_EXISTS into L_DUMMY;
4494: CLOSE C_CHECK_AP_INVOICE_DIST_EXISTS;
4495:

Line 4502: pa_debug.write('Check if there exists commitment transaction',3);

4498: return;
4499: END IF;
4500:
4501: -----------------------------------------------------------------------------------------------------------------------------
4502: pa_debug.write('Check if there exists commitment transaction',3);
4503: OPEN C_CHECK_COMMIT_TXN_EXISTS;
4504: FETCH C_CHECK_COMMIT_TXN_EXISTS into L_DUMMY;
4505: CLOSE C_CHECK_COMMIT_TXN_EXISTS;
4506:

Line 4512: pa_debug.write('Check if there exists iExpense records',3);

4508: x_error_msg_code :='PA_CBS_COMMT_TXN_E';
4509: return;
4510: END IF;
4511: -----------------------------------------------------------------------------------------------------------------------------
4512: pa_debug.write('Check if there exists iExpense records',3);
4513: OPEN C_CHECK_iExpense_Rec_EXISTS;
4514: FETCH C_CHECK_iExpense_Rec_EXISTS into L_DUMMY;
4515: CLOSE C_CHECK_iExpense_Rec_EXISTS;
4516:

Line 4523: pa_debug.write('Check if there exists Inventory Transaction records',3);

4519: return;
4520: END IF;
4521:
4522: -----------------------------------------------------------------------------------------------------------------------------
4523: pa_debug.write('Check if there exists Inventory Transaction records',3);
4524: OPEN C_CHECK_INV_TXN_EXISTS;
4525: FETCH C_CHECK_INV_TXN_EXISTS into L_DUMMY;
4526: CLOSE C_CHECK_INV_TXN_EXISTS;
4527:

Line 4533: pa_debug.write('Check if there exists Intercompany Tax Receiving Task ',3);

4529: x_error_msg_code :='PA_CBS_INV_REC_E';
4530: return;
4531: END IF;
4532: -----------------------------------------------------------------------------------------------------------------------------
4533: pa_debug.write('Check if there exists Intercompany Tax Receiving Task ',3);
4534: OPEN C_CHECK_TAX_TASK_ID_EXISTS;
4535: FETCH C_CHECK_TAX_TASK_ID_EXISTS into L_DUMMY;
4536: CLOSE C_CHECK_TAX_TASK_ID_EXISTS;
4537:

Line 4614: pa_debug.write('All validations are done',3);

4610: return;
4611: END IF;
4612:
4613:
4614: pa_debug.write('All validations are done',3);
4615: x_valid_flag :='Y';
4616:
4617: END VALIDATE_PROJECT_FOR_CBS;
4618: --