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

Line 28: pa_debug.debug(x_err_stage);

24: x_err_stage := 'Getting Dimensions Statuses';
25: x_old_err_stack := x_err_stack;
26: x_err_stack := x_err_stack || '-> get_dimension_status';
27:
28: pa_debug.debug(x_err_stage);
29:
30: -- First get the dimension statuses
31:
32: pa_adw_collect_dimensions.get_dim_status

Line 116: pa_debug.debug(x_err_stage);

112: x_err_stage := 'Generating Collection Views';
113: x_old_err_stack := x_err_stack;
114: x_err_stack := x_err_stack || '-> generate_collection_views';
115:
116: pa_debug.debug(x_err_stage);
117:
118: get_dimension_status (x_err_stage, x_err_stack, x_err_code);
119:
120: -- Build the view in a PL/SQL array

Line 944: pa_debug.debug(x_err_stage);

940: x_err_stage := 'Creating Collection Views Definition in the DB';
941: x_old_err_stack := x_err_stack;
942: x_err_stack := x_err_stack || '-> create_collection_views';
943:
944: pa_debug.debug(x_err_stage);
945:
946: source_cursor := dbms_sql.open_cursor;
947: dbms_sql.parse(source_cursor,view_act_cmt,1,view_idx_act_cmt,TRUE,dbms_sql.v7);
948: retcode := dbms_sql.execute(source_cursor);

Line 980: pa_debug.debug(x_err_stage);

976: x_err_stage := 'Creating Collection Views Definition';
977: x_old_err_stack := x_err_stack;
978: x_err_stack := x_err_stack || '-> output_collection_views';
979:
980: pa_debug.debug(x_err_stage);
981:
982: pa_debug.debug('********START OF VIEWS DEFINITION*******', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
983: FOR i IN 1..view_idx_act_cmt LOOP
984: pa_debug.debug(view_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 982: pa_debug.debug('**START OF VIEWS DEFINITION*', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

978: x_err_stack := x_err_stack || '-> output_collection_views';
979:
980: pa_debug.debug(x_err_stage);
981:
982: pa_debug.debug('********START OF VIEWS DEFINITION*******', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
983: FOR i IN 1..view_idx_act_cmt LOOP
984: pa_debug.debug(view_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
985: END LOOP;
986: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 984: pa_debug.debug(view_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

980: pa_debug.debug(x_err_stage);
981:
982: pa_debug.debug('********START OF VIEWS DEFINITION*******', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
983: FOR i IN 1..view_idx_act_cmt LOOP
984: pa_debug.debug(view_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
985: END LOOP;
986: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
987: FOR i IN 1..view_idx_ref_act_cmt LOOP
988: pa_debug.debug(view_ref_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 986: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

982: pa_debug.debug('********START OF VIEWS DEFINITION*******', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
983: FOR i IN 1..view_idx_act_cmt LOOP
984: pa_debug.debug(view_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
985: END LOOP;
986: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
987: FOR i IN 1..view_idx_ref_act_cmt LOOP
988: pa_debug.debug(view_ref_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
989: END LOOP;
990: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 988: pa_debug.debug(view_ref_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

984: pa_debug.debug(view_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
985: END LOOP;
986: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
987: FOR i IN 1..view_idx_ref_act_cmt LOOP
988: pa_debug.debug(view_ref_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
989: END LOOP;
990: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
991: FOR i IN 1..view_idx_ref_ser_type_act_cmt LOOP
992: pa_debug.debug(view_ref_ser_type_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 990: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

986: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
987: FOR i IN 1..view_idx_ref_act_cmt LOOP
988: pa_debug.debug(view_ref_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
989: END LOOP;
990: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
991: FOR i IN 1..view_idx_ref_ser_type_act_cmt LOOP
992: pa_debug.debug(view_ref_ser_type_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
993: END LOOP;
994: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 992: pa_debug.debug(view_ref_ser_type_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

988: pa_debug.debug(view_ref_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
989: END LOOP;
990: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
991: FOR i IN 1..view_idx_ref_ser_type_act_cmt LOOP
992: pa_debug.debug(view_ref_ser_type_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
993: END LOOP;
994: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
995: FOR i IN 1..view_idx_budget_lines LOOP
996: pa_debug.debug(view_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 994: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

990: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
991: FOR i IN 1..view_idx_ref_ser_type_act_cmt LOOP
992: pa_debug.debug(view_ref_ser_type_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
993: END LOOP;
994: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
995: FOR i IN 1..view_idx_budget_lines LOOP
996: pa_debug.debug(view_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
997: END LOOP;
998: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 996: pa_debug.debug(view_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

992: pa_debug.debug(view_ref_ser_type_act_cmt(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
993: END LOOP;
994: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
995: FOR i IN 1..view_idx_budget_lines LOOP
996: pa_debug.debug(view_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
997: END LOOP;
998: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
999: FOR i IN 1..view_idx_ref_budget_lines LOOP
1000: pa_debug.debug(view_ref_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 998: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

994: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
995: FOR i IN 1..view_idx_budget_lines LOOP
996: pa_debug.debug(view_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
997: END LOOP;
998: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
999: FOR i IN 1..view_idx_ref_budget_lines LOOP
1000: pa_debug.debug(view_ref_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1001: END LOOP;
1002: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

Line 1000: pa_debug.debug(view_ref_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

996: pa_debug.debug(view_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
997: END LOOP;
998: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
999: FOR i IN 1..view_idx_ref_budget_lines LOOP
1000: pa_debug.debug(view_ref_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1001: END LOOP;
1002: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1003: pa_debug.debug('********END OF VIEWS DEFINITION*******', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1004:

Line 1002: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

998: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
999: FOR i IN 1..view_idx_ref_budget_lines LOOP
1000: pa_debug.debug(view_ref_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1001: END LOOP;
1002: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1003: pa_debug.debug('********END OF VIEWS DEFINITION*******', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1004:
1005: x_err_stack := x_old_err_stack;
1006:

Line 1003: pa_debug.debug('**END OF VIEWS DEFINITION*', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

999: FOR i IN 1..view_idx_ref_budget_lines LOOP
1000: pa_debug.debug(view_ref_budget_lines(i), PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1001: END LOOP;
1002: pa_debug.debug('/', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1003: pa_debug.debug('********END OF VIEWS DEFINITION*******', PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1004:
1005: x_err_stack := x_old_err_stack;
1006:
1007: EXCEPTION