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

Line 6: pa_debug.debug('Getting the License Status');

2: /* $Header: PAADWCMB.pls 115.5 99/07/16 13:22:01 porting ship $ */
3:
4: FUNCTION Initialize RETURN NUMBER IS
5: BEGIN
6: pa_debug.debug('Getting the License Status');
7:
8: -- By Default the Oracle Project Collection Pack is not Licensed
9:
10: license_status := NVL(fnd_profile.value('PA_ADW_LICENSED'),'N');

Line 12: pa_debug.debug('Getting the Install Status');

8: -- By Default the Oracle Project Collection Pack is not Licensed
9:
10: license_status := NVL(fnd_profile.value('PA_ADW_LICENSED'),'N');
11:
12: pa_debug.debug('Getting the Install Status');
13:
14: -- By Default the Oracle Project Collection Pack is not Installed
15:
16: install_status := NVL(fnd_profile.value('PA_ADW_INSTALLED'),'N');

Line 18: pa_debug.debug('Getting the Tasks Profile Option Values');

14: -- By Default the Oracle Project Collection Pack is not Installed
15:
16: install_status := NVL(fnd_profile.value('PA_ADW_INSTALLED'),'N');
17:
18: pa_debug.debug('Getting the Tasks Profile Option Values');
19:
20: -- By Default we will not collect lowest/top level tasks
21: -- If we are collecting lowest tasks, we will always collect top tasks
22:

Line 23: pa_debug.debug('Getting the Lowest Task Profile Option Values');

19:
20: -- By Default we will not collect lowest/top level tasks
21: -- If we are collecting lowest tasks, we will always collect top tasks
22:
23: pa_debug.debug('Getting the Lowest Task Profile Option Values');
24:
25: collect_lowest_tasks_flag := NVL(fnd_profile.value('PA_ADW_COLLECT_LOWEST_TASKS'),'N');
26:
27: IF (collect_lowest_tasks_flag = 'Y') THEN

Line 31: pa_debug.debug('Getting the Top Task Profile Option Values');

27: IF (collect_lowest_tasks_flag = 'Y') THEN
28: -- Always collect top tasks
29: collect_top_tasks_flag := 'Y';
30: ELSE
31: pa_debug.debug('Getting the Top Task Profile Option Values');
32: collect_top_tasks_flag := NVL(fnd_profile.value('PA_ADW_COLLECT_TOP_TASKS'),'N');
33: END IF;
34:
35: RETURN (0);

Line 55: pa_debug.debug(x_err_stage);

51: x_err_stage := 'Getting Dimension Status';
52: x_old_err_stack := x_err_stack;
53: x_err_stack := x_err_stack || '-> get_dimension_status';
54:
55: pa_debug.debug(x_err_stage);
56:
57: -- Call the initialize procedure
58:
59: x_err_code := pa_adw_collect_main.initialize;

Line 149: pa_debug.debug(x_err_stage);

145: x_err_stage := 'Preparing Source Table for Collection';
146: x_old_err_stack := x_err_stack;
147: x_err_stack := x_err_stack || '-> prepare_src_table_for_refresh';
148:
149: pa_debug.debug(x_err_stage);
150:
151: UPDATE PA_TASKS SET ADW_NOTIFY_FLAG='Y'
152: WHERE ADW_NOTIFY_FLAG = 'N';
153:

Line 213: pa_debug.debug(x_err_stage);

209: x_err_stage := 'Clearing Interface Tables';
210: x_old_err_stack := x_err_stack;
211: x_err_stack := x_err_stack || '-> clear_interface_tables';
212:
213: pa_debug.debug(x_err_stage);
214:
215: DELETE FROM PA_TOP_TASKS_IT;
216: DELETE FROM PA_PROJECTS_IT;
217: DELETE FROM PA_PRJ_TYPES_IT;

Line 272: pa_debug.debug('Purging Interface Tables For OADW ' || x_table_name);

268: source_cursor integer;
269: rows_deleted integer;
270: BEGIN
271:
272: pa_debug.debug('Purging Interface Tables For OADW ' || x_table_name);
273:
274: -- prepare a cursor to delete from the source table
275: source_cursor := dbms_sql.open_cursor;
276: sql_command :=

Line 282: pa_debug.debug('Rows deleted:= ' || to_char(rows_deleted));

278: || ' WHERE WH_UPDATE_DATE <= :x_wh_update_date';
279: dbms_sql.parse(source_cursor,sql_command,dbms_sql.native);
280: dbms_sql.bind_variable(source_cursor, 'x_wh_update_date', x_wh_update_date);
281: rows_deleted := dbms_sql.execute(source_cursor);
282: pa_debug.debug('Rows deleted:= ' || to_char(rows_deleted));
283: dbms_sql.close_cursor(source_cursor);
284: EXCEPTION
285: WHEN OTHERS THEN
286: IF dbms_sql.is_open(source_cursor) THEN

Line 314: pa_debug.debug(x_err_stage);

310: x_old_err_stack := x_err_stack;
311: x_err_stack := x_err_stack || '-> purge_interface_tables_OADW';
312: earliest_collect_time := NULL;
313:
314: pa_debug.debug(x_err_stage);
315:
316: IF (install_status = 'Y') THEN
317:
318: /* Get the Warehouse Update DATE */

Line 423: pa_debug.debug(x_err_stage);

419: x_err_stage := 'Purging Interface Tables';
420: x_old_err_stack := x_err_stack;
421: x_err_stack := x_err_stack || '-> purge_interface_tables';
422:
423: pa_debug.debug(x_err_stage);
424:
425: DELETE FROM PA_TOP_TASKS_IT
426: WHERE STATUS_CODE = 'T';
427:

Line 554: pa_debug.debug(x_err_stage);

550: x_err_stage := 'Collecting Dimensions and Fact Tables';
551: x_old_err_stack := x_err_stack;
552: x_err_stack := x_err_stack || '-> get_dim_and_fact_main';
553:
554: pa_debug.debug(x_err_stage);
555:
556: -- Call the initialize procedure
557:
558: x_err_code := pa_adw_collect_main.initialize;

Line 563: pa_debug.debug('Oracle Project Analysis Collection Pack Not Licensed',

559:
560: -- Check the license status
561:
562: IF ( license_status <> 'Y' ) THEN
563: pa_debug.debug('Oracle Project Analysis Collection Pack Not Licensed',
564: pa_debug.DEBUG_LEVEL_EXCEPTION);
565: x_err_stage := 'Oracle Project Analysis Collection Pack Not Licensed';
566: x_err_code := 2;
567: ROLLBACK WORK;

Line 564: pa_debug.DEBUG_LEVEL_EXCEPTION);

560: -- Check the license status
561:
562: IF ( license_status <> 'Y' ) THEN
563: pa_debug.debug('Oracle Project Analysis Collection Pack Not Licensed',
564: pa_debug.DEBUG_LEVEL_EXCEPTION);
565: x_err_stage := 'Oracle Project Analysis Collection Pack Not Licensed';
566: x_err_code := 2;
567: ROLLBACK WORK;
568: return;

Line 776: pa_debug.debug('Exception Generated By Oracle Error: ' || SQLERRM(SQLCODE),

772:
773: EXCEPTION
774: WHEN OTHERS THEN
775: x_err_code := SQLCODE;
776: pa_debug.debug('Exception Generated By Oracle Error: ' || SQLERRM(SQLCODE),
777: pa_debug.DEBUG_LEVEL_EXCEPTION);
778: ROLLBACK WORK;
779: return;
780: END get_dim_and_fact_main;

Line 777: pa_debug.DEBUG_LEVEL_EXCEPTION);

773: EXCEPTION
774: WHEN OTHERS THEN
775: x_err_code := SQLCODE;
776: pa_debug.debug('Exception Generated By Oracle Error: ' || SQLERRM(SQLCODE),
777: pa_debug.DEBUG_LEVEL_EXCEPTION);
778: ROLLBACK WORK;
779: return;
780: END get_dim_and_fact_main;
781:

Line 800: pa_debug.debug(x_err_stage);

796: x_err_stage := 'Refreshing Dimensions and Fact Tables';
797: x_old_err_stack := x_err_stack;
798: x_err_stack := x_err_stack || '-> ref_dim_and_fact_main';
799:
800: pa_debug.debug(x_err_stage);
801:
802: -- Call the initialize procedure
803:
804: x_err_code := pa_adw_collect_main.initialize;

Line 809: pa_debug.debug('Oracle Project Analysis Collection Pack Not Licensed',

805:
806: -- Check the license status
807:
808: IF ( license_status <> 'Y' ) THEN
809: pa_debug.debug('Oracle Project Analysis Collection Pack Not Licensed',
810: pa_debug.DEBUG_LEVEL_EXCEPTION);
811: x_err_stage := 'Oracle Project Analysis Collection Pack Not Licensed';
812: x_err_code := 2;
813: ROLLBACK WORK;

Line 810: pa_debug.DEBUG_LEVEL_EXCEPTION);

806: -- Check the license status
807:
808: IF ( license_status <> 'Y' ) THEN
809: pa_debug.debug('Oracle Project Analysis Collection Pack Not Licensed',
810: pa_debug.DEBUG_LEVEL_EXCEPTION);
811: x_err_stage := 'Oracle Project Analysis Collection Pack Not Licensed';
812: x_err_code := 2;
813: ROLLBACK WORK;
814: return;

Line 949: pa_debug.debug('Exception Generated By Oracle Error: ' || SQLERRM(SQLCODE),

945:
946: EXCEPTION
947: WHEN OTHERS THEN
948: x_err_code := SQLCODE;
949: pa_debug.debug('Exception Generated By Oracle Error: ' || SQLERRM(SQLCODE),
950: pa_debug.DEBUG_LEVEL_EXCEPTION);
951: ROLLBACK WORK;
952: return;
953: END ref_dim_and_fact_main;

Line 950: pa_debug.DEBUG_LEVEL_EXCEPTION);

946: EXCEPTION
947: WHEN OTHERS THEN
948: x_err_code := SQLCODE;
949: pa_debug.debug('Exception Generated By Oracle Error: ' || SQLERRM(SQLCODE),
950: pa_debug.DEBUG_LEVEL_EXCEPTION);
951: ROLLBACK WORK;
952: return;
953: END ref_dim_and_fact_main;
954: