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

Line 25: pa_debug.debug(x_err_stage);

21: x_err_stage := 'Collecting Dimension Status for Dimension Code ' || x_dimension_code;
22: x_old_err_stack := x_err_stack;
23: x_err_stack := x_err_stack || '-> get_dim_status';
24:
25: pa_debug.debug(x_err_stage);
26:
27: SELECT
28: status_code
29: INTO

Line 37: pa_debug.debug('Completed ' || x_err_stage);

33: WHERE
34: dimension_code = x_dimension_code;
35:
36: x_err_stack := x_old_err_stack;
37: pa_debug.debug('Completed ' || x_err_stage);
38:
39: EXCEPTION
40: WHEN OTHERS THEN
41: x_err_code := SQLCODE;

Line 122: pa_debug.debug(x_err_stage);

118: x_err_stage := 'Collecting Lowest Level Task Dimension Table';
119: x_old_err_stack := x_err_stack;
120: x_err_stack := x_err_stack || '-> get_dim_tasks';
121:
122: pa_debug.debug(x_err_stage);
123:
124: -- Check the profile option value for collecting lowest tasks
125: IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y') THEN
126:

Line 248: pa_debug.debug(x_err_stage);

244: END IF; -- IF ( pa_adw_collect_main.collect_lowest_tasks_flag = 'Y')
245:
246: x_err_stage := 'Collecting Top Level Task Dimension Table';
247:
248: pa_debug.debug(x_err_stage);
249:
250: -- Check the profile option value for collecting top tasks
251: IF ( pa_adw_collect_main.collect_top_tasks_flag = 'Y') THEN
252:

Line 382: pa_debug.debug('Completed ' || x_err_stage);

378: ADW_NOTIFY_FLAG = 'S';
379:
380: x_err_stack := x_old_err_stack;
381:
382: pa_debug.debug('Completed ' || x_err_stage);
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: x_err_code := SQLCODE;

Line 436: pa_debug.debug(x_err_stage);

432: x_err_stage := 'Collecting Projects Dimension Table';
433: x_old_err_stack := x_err_stack;
434: x_err_stack := x_err_stack || '-> get_dim_projects';
435:
436: pa_debug.debug(x_err_stage);
437:
438: -- Process all projects
439:
440: FOR projects_r IN sel_projects LOOP

Line 553: pa_debug.debug('Completed ' || x_err_stage);

549: END LOOP; -- FOR projects_r IN sel_projects
550:
551: x_err_stack := x_old_err_stack;
552:
553: pa_debug.debug('Completed ' || x_err_stage);
554:
555: EXCEPTION
556: WHEN OTHERS THEN
557: x_err_code := SQLCODE;

Line 605: pa_debug.debug(x_err_stage);

601: x_err_stage := 'Collecting Project Types Dimension Table';
602: x_old_err_stack := x_err_stack;
603: x_err_stack := x_err_stack || '-> get_dim_project_types';
604:
605: pa_debug.debug(x_err_stage);
606:
607: -- Process all project types
608:
609: FOR project_types_r IN sel_project_types LOOP

Line 749: pa_debug.debug('Completed ' || x_err_stage);

745: END IF;
746:
747: x_err_stack := x_old_err_stack;
748:
749: pa_debug.debug('Completed ' || x_err_stage);
750:
751: EXCEPTION
752: WHEN OTHERS THEN
753: x_err_code := SQLCODE;

Line 804: pa_debug.debug(x_err_stage);

800: x_err_stage := 'Collecting Expenditure Types Dimension Table';
801: x_old_err_stack := x_err_stack;
802: x_err_stack := x_err_stack || '-> get_dim_expenditure_types';
803:
804: pa_debug.debug(x_err_stage);
805:
806: -- Process all expenditure types
807:
808: FOR expenditure_types_r IN sel_expenditure_types LOOP

Line 956: pa_debug.debug('Completed ' || x_err_stage);

952: END IF;
953:
954: x_err_stack := x_old_err_stack;
955:
956: pa_debug.debug('Completed ' || x_err_stage);
957:
958: EXCEPTION
959: WHEN OTHERS THEN
960: x_err_code := SQLCODE;

Line 1007: pa_debug.debug(x_err_stage);

1003: x_err_stage := 'Collecting Projects Classes Dimension Table';
1004: x_old_err_stack := x_err_stack;
1005: x_err_stack := x_err_stack || '-> get_dim_project_classes';
1006:
1007: pa_debug.debug(x_err_stage);
1008:
1009: -- Process all project classes
1010:
1011: FOR project_classes_r IN sel_project_classes LOOP

Line 1117: pa_debug.debug('Completed ' || x_err_stage);

1113: END LOOP; -- FOR project_classes_r IN sel_project_classes
1114:
1115: x_err_stack := x_old_err_stack;
1116:
1117: pa_debug.debug('Completed ' || x_err_stage);
1118:
1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: x_err_code := SQLCODE;

Line 1167: pa_debug.debug(x_err_stage);

1163: x_err_stage := 'Collecting Class Categories Dimension Table';
1164: x_old_err_stack := x_err_stack;
1165: x_err_stack := x_err_stack || '-> get_dim_class_categories';
1166:
1167: pa_debug.debug(x_err_stage);
1168:
1169: -- Process all class categories
1170:
1171: FOR class_categories_r IN sel_class_categories LOOP

Line 1272: pa_debug.debug('Completed ' || x_err_stage);

1268: END LOOP; -- FOR class_categories_r IN sel_class_categories
1269:
1270: x_err_stack := x_old_err_stack;
1271:
1272: pa_debug.debug('Completed ' || x_err_stage);
1273:
1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: x_err_code := SQLCODE;

Line 1323: pa_debug.debug(x_err_stage);

1319: x_err_stage := 'Collecting Class Codes Dimension Table';
1320: x_old_err_stack := x_err_stack;
1321: x_err_stack := x_err_stack || '-> get_dim_class_codes';
1322:
1323: pa_debug.debug(x_err_stage);
1324:
1325: -- Process all classes codes
1326:
1327: FOR class_codes_r IN sel_class_codes LOOP

Line 1432: pa_debug.debug('Completed ' || x_err_stage);

1428: END LOOP; -- FOR class_codes_r IN sel_class_codes
1429:
1430: x_err_stack := x_old_err_stack;
1431:
1432: pa_debug.debug('Completed ' || x_err_stage);
1433:
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: x_err_code := SQLCODE;

Line 1511: pa_debug.debug(x_err_stage);

1507: x_err_stage := 'Collecting Lowest Level Resource Dimension Table';
1508: x_old_err_stack := x_err_stack;
1509: x_err_stack := x_err_stack || '-> get_dim_resources';
1510:
1511: pa_debug.debug(x_err_stage);
1512:
1513: -- Process all lowest level resource first
1514:
1515: FOR lowest_res_members_r IN sel_lowest_res_members LOOP

Line 1747: pa_debug.debug('Completed ' || x_err_stage);

1743: ADW_NOTIFY_FLAG = 'S';
1744:
1745: x_err_stack := x_old_err_stack;
1746:
1747: pa_debug.debug('Completed ' || x_err_stage);
1748:
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: x_err_code := SQLCODE;

Line 1798: pa_debug.debug(x_err_stage);

1794: x_err_stage := 'Collecting Resource List Dimension Table';
1795: x_old_err_stack := x_err_stack;
1796: x_err_stack := x_err_stack || '-> get_dim_resource_lists';
1797:
1798: pa_debug.debug(x_err_stage);
1799:
1800: -- Process all resource lists
1801:
1802: FOR resource_lists_r IN sel_resource_lists LOOP

Line 1908: pa_debug.debug('Completed ' || x_err_stage);

1904: END LOOP; -- FOR resource_lists_r IN sel_resource_lists
1905:
1906: x_err_stack := x_old_err_stack;
1907:
1908: pa_debug.debug('Completed ' || x_err_stage);
1909:
1910: EXCEPTION
1911: WHEN OTHERS THEN
1912: x_err_code := SQLCODE;

Line 1958: pa_debug.debug(x_err_stage);

1954: x_err_stage := 'Collecting Budget Types Dimension Table';
1955: x_old_err_stack := x_err_stack;
1956: x_err_stack := x_err_stack || '-> get_dim_budget_types';
1957:
1958: pa_debug.debug(x_err_stage);
1959:
1960: -- Process all budget types
1961:
1962: FOR budget_types_r IN sel_budget_types LOOP

Line 2063: pa_debug.debug('Completed ' || x_err_stage);

2059: END LOOP; -- FOR budget_types_r IN sel_budget_types
2060:
2061: x_err_stack := x_old_err_stack;
2062:
2063: pa_debug.debug('Completed ' || x_err_stage);
2064:
2065: EXCEPTION
2066: WHEN OTHERS THEN
2067: x_err_code := SQLCODE;

Line 2154: pa_debug.debug(x_err_stage);

2150: x_err_stage := 'Collecting PA period Dimension Table';
2151: x_old_err_stack := x_err_stack;
2152: x_err_stack := x_err_stack || '-> get_dim_periods';
2153:
2154: pa_debug.debug(x_err_stage);
2155:
2156: -- Process all PA periods
2157:
2158: FOR periods_r IN sel_periods LOOP

Line 2524: pa_debug.debug('Completed ' || x_err_stage);

2520: END IF;
2521:
2522: x_err_stack := x_old_err_stack;
2523:
2524: pa_debug.debug('Completed ' || x_err_stage);
2525:
2526: EXCEPTION
2527: WHEN OTHERS THEN
2528: x_err_code := SQLCODE;

Line 2575: pa_debug.debug(x_err_stage);

2571: x_err_stage := 'Collecting Service Types Dimension Table';
2572: x_old_err_stack := x_err_stack;
2573: x_err_stack := x_err_stack || '-> get_dim_service_types';
2574:
2575: pa_debug.debug(x_err_stage);
2576:
2577: -- Process all service types
2578:
2579: FOR service_types_r IN sel_service_types LOOP

Line 2709: pa_debug.debug('Completed ' || x_err_stage);

2705: END IF;
2706:
2707: x_err_stack := x_old_err_stack;
2708:
2709: pa_debug.debug('Completed ' || x_err_stage);
2710:
2711: EXCEPTION
2712: WHEN OTHERS THEN
2713: x_err_code := SQLCODE;

Line 2846: pa_debug.debug(x_err_stage);

2842: x_err_stage := 'Collecting Organization/Operating Units Dimension Table';
2843: x_old_err_stack := x_err_stack;
2844: x_err_stack := x_err_stack || '-> get_dim_organizations';
2845:
2846: pa_debug.debug(x_err_stage);
2847:
2848: FOR project_org_r IN project_org LOOP
2849:
2850: -- First Try to Update the Row in the Interface Table

Line 3446: pa_debug.debug('Completed ' || x_err_stage);

3442: END LOOP;
3443:
3444: x_err_stack := x_old_err_stack;
3445:
3446: pa_debug.debug('Completed ' || x_err_stage);
3447:
3448: EXCEPTION
3449: WHEN OTHERS THEN
3450: x_err_code := SQLCODE;