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.EDW_ALL_COLLECT dependencies on EDW_SUMMARY_COLLECT

Line 515: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Going to call EDW_SUMMARY_COLLECT.collect_dimension',FND_LOG.LEVEL_PROCEDURE);

511: insert_into_load_progress_nd(g_load_pk,null,null,null,null,sysdate,null,null,'PD10','U');
512:
513: if g_dimension_collect then
514: if g_debug then
515: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Going to call EDW_SUMMARY_COLLECT.collect_dimension',FND_LOG.LEVEL_PROCEDURE);
516: end if;
517: insert_into_load_progress_nd(g_load_pk,g_object_name,g_object_id,'Dimension Collection',sysdate,null,'DIMENSION',
518: 'DIMENSION','DC10','I');
519: EDW_SUMMARY_COLLECT.collect_dimension_main(

Line 519: EDW_SUMMARY_COLLECT.collect_dimension_main(

515: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Going to call EDW_SUMMARY_COLLECT.collect_dimension',FND_LOG.LEVEL_PROCEDURE);
516: end if;
517: insert_into_load_progress_nd(g_load_pk,g_object_name,g_object_id,'Dimension Collection',sysdate,null,'DIMENSION',
518: 'DIMENSION','DC10','I');
519: EDW_SUMMARY_COLLECT.collect_dimension_main(
520: g_conc_program_id,
521: g_conc_program_name,
522: p_dim_name,
523: l_levels,

Line 565: if EDW_SUMMARY_COLLECT.check_error=false then

561: g_parallel_drill_down,
562: g_dd_status_table
563: );
564: insert_into_load_progress_nd(g_load_pk,null,null,null,null,sysdate,null,null,'DC10','U');
565: if EDW_SUMMARY_COLLECT.check_error=false then
566: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_SUMMARY_COLLECT.Collect_Dimension, '||
567: EDW_SUMMARY_COLLECT.get_status_message||' Time '||get_time,FND_LOG.LEVEL_ERROR);
568: g_status_message:=EDW_SUMMARY_COLLECT.get_status_message;
569: errbuf:=g_status_message;

Line 566: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_SUMMARY_COLLECT.Collect_Dimension, '||

562: g_dd_status_table
563: );
564: insert_into_load_progress_nd(g_load_pk,null,null,null,null,sysdate,null,null,'DC10','U');
565: if EDW_SUMMARY_COLLECT.check_error=false then
566: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_SUMMARY_COLLECT.Collect_Dimension, '||
567: EDW_SUMMARY_COLLECT.get_status_message||' Time '||get_time,FND_LOG.LEVEL_ERROR);
568: g_status_message:=EDW_SUMMARY_COLLECT.get_status_message;
569: errbuf:=g_status_message;
570: retcode:='2';

Line 567: EDW_SUMMARY_COLLECT.get_status_message||' Time '||get_time,FND_LOG.LEVEL_ERROR);

563: );
564: insert_into_load_progress_nd(g_load_pk,null,null,null,null,sysdate,null,null,'DC10','U');
565: if EDW_SUMMARY_COLLECT.check_error=false then
566: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_SUMMARY_COLLECT.Collect_Dimension, '||
567: EDW_SUMMARY_COLLECT.get_status_message||' Time '||get_time,FND_LOG.LEVEL_ERROR);
568: g_status_message:=EDW_SUMMARY_COLLECT.get_status_message;
569: errbuf:=g_status_message;
570: retcode:='2';
571: return_with_error(g_load_pk,'LOG');

Line 568: g_status_message:=EDW_SUMMARY_COLLECT.get_status_message;

564: insert_into_load_progress_nd(g_load_pk,null,null,null,null,sysdate,null,null,'DC10','U');
565: if EDW_SUMMARY_COLLECT.check_error=false then
566: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('ERROR:EDW_SUMMARY_COLLECT.Collect_Dimension, '||
567: EDW_SUMMARY_COLLECT.get_status_message||' Time '||get_time,FND_LOG.LEVEL_ERROR);
568: g_status_message:=EDW_SUMMARY_COLLECT.get_status_message;
569: errbuf:=g_status_message;
570: retcode:='2';
571: return_with_error(g_load_pk,'LOG');
572: return;

Line 574: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Finished EDW_SUMMARY_COLLECT.Collect_Dimension,Time '||get_time,

570: retcode:='2';
571: return_with_error(g_load_pk,'LOG');
572: return;
573: else
574: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('Finished EDW_SUMMARY_COLLECT.Collect_Dimension,Time '||get_time,
575: FND_LOG.LEVEL_PROCEDURE);
576: /*
577: get the record of the lowest level collection from the table edw_temp_collection_log
578: */

Line 1710: g_dim_rows_processed:=EDW_SUMMARY_COLLECT.get_number_rows_processed;

1706: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('In get_rows_processed'||get_time,FND_LOG.LEVEL_STATEMENT);
1707: end if;
1708: /*
1709: if g_collect_dim then
1710: g_dim_rows_processed:=EDW_SUMMARY_COLLECT.get_number_rows_processed;
1711: for i in 1..g_number_ins_req_coll loop
1712: g_ins_rows_collected(i):=g_dim_rows_processed;
1713: end loop;
1714: end if;*/

Line 2150: g_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_dim_derv_map_id;

2146: --get an idea about which all maps to refresh. find out NOCOPY what cols belong to what maps.
2147: if g_debug then
2148: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('In refresh_dim_derv_facts '||get_time,FND_LOG.LEVEL_STATEMENT);
2149: end if;
2150: g_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_dim_derv_map_id;
2151: g_derv_fact_id:=EDW_SUMMARY_COLLECT.g_derv_fact_id;
2152: g_dim_derv_map_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_refresh;
2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;
2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;

Line 2151: g_derv_fact_id:=EDW_SUMMARY_COLLECT.g_derv_fact_id;

2147: if g_debug then
2148: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('In refresh_dim_derv_facts '||get_time,FND_LOG.LEVEL_STATEMENT);
2149: end if;
2150: g_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_dim_derv_map_id;
2151: g_derv_fact_id:=EDW_SUMMARY_COLLECT.g_derv_fact_id;
2152: g_dim_derv_map_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_refresh;
2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;
2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;
2155: g_before_update_table:=EDW_SUMMARY_COLLECT.g_before_update_table;--pl/sql table

Line 2152: g_dim_derv_map_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_refresh;

2148: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('In refresh_dim_derv_facts '||get_time,FND_LOG.LEVEL_STATEMENT);
2149: end if;
2150: g_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_dim_derv_map_id;
2151: g_derv_fact_id:=EDW_SUMMARY_COLLECT.g_derv_fact_id;
2152: g_dim_derv_map_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_refresh;
2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;
2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;
2155: g_before_update_table:=EDW_SUMMARY_COLLECT.g_before_update_table;--pl/sql table
2156: g_number_before_update_table:=EDW_SUMMARY_COLLECT.g_number_before_update_table;

Line 2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;

2149: end if;
2150: g_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_dim_derv_map_id;
2151: g_derv_fact_id:=EDW_SUMMARY_COLLECT.g_derv_fact_id;
2152: g_dim_derv_map_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_refresh;
2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;
2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;
2155: g_before_update_table:=EDW_SUMMARY_COLLECT.g_before_update_table;--pl/sql table
2156: g_number_before_update_table:=EDW_SUMMARY_COLLECT.g_number_before_update_table;
2157: l_dim_id:=EDW_SUMMARY_COLLECT.g_dim_id;

Line 2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;

2150: g_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_dim_derv_map_id;
2151: g_derv_fact_id:=EDW_SUMMARY_COLLECT.g_derv_fact_id;
2152: g_dim_derv_map_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_refresh;
2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;
2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;
2155: g_before_update_table:=EDW_SUMMARY_COLLECT.g_before_update_table;--pl/sql table
2156: g_number_before_update_table:=EDW_SUMMARY_COLLECT.g_number_before_update_table;
2157: l_dim_id:=EDW_SUMMARY_COLLECT.g_dim_id;
2158: if g_before_update_table.count=0 then

Line 2155: g_before_update_table:=EDW_SUMMARY_COLLECT.g_before_update_table;--pl/sql table

2151: g_derv_fact_id:=EDW_SUMMARY_COLLECT.g_derv_fact_id;
2152: g_dim_derv_map_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_refresh;
2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;
2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;
2155: g_before_update_table:=EDW_SUMMARY_COLLECT.g_before_update_table;--pl/sql table
2156: g_number_before_update_table:=EDW_SUMMARY_COLLECT.g_number_before_update_table;
2157: l_dim_id:=EDW_SUMMARY_COLLECT.g_dim_id;
2158: if g_before_update_table.count=0 then
2159: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('There are no update tables created to refresh the derived facts',

Line 2156: g_number_before_update_table:=EDW_SUMMARY_COLLECT.g_number_before_update_table;

2152: g_dim_derv_map_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_refresh;
2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;
2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;
2155: g_before_update_table:=EDW_SUMMARY_COLLECT.g_before_update_table;--pl/sql table
2156: g_number_before_update_table:=EDW_SUMMARY_COLLECT.g_number_before_update_table;
2157: l_dim_id:=EDW_SUMMARY_COLLECT.g_dim_id;
2158: if g_before_update_table.count=0 then
2159: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('There are no update tables created to refresh the derived facts',
2160: FND_LOG.LEVEL_STATEMENT);

Line 2157: l_dim_id:=EDW_SUMMARY_COLLECT.g_dim_id;

2153: g_dim_derv_map_full_refresh:=EDW_SUMMARY_COLLECT.g_dim_derv_map_full_refresh;
2154: g_number_dim_derv_map_id:=EDW_SUMMARY_COLLECT.g_number_dim_derv_map_id;
2155: g_before_update_table:=EDW_SUMMARY_COLLECT.g_before_update_table;--pl/sql table
2156: g_number_before_update_table:=EDW_SUMMARY_COLLECT.g_number_before_update_table;
2157: l_dim_id:=EDW_SUMMARY_COLLECT.g_dim_id;
2158: if g_before_update_table.count=0 then
2159: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('There are no update tables created to refresh the derived facts',
2160: FND_LOG.LEVEL_STATEMENT);
2161: return true;

Line 2163: if EDW_SUMMARY_COLLECT.g_dim_empty_flag then

2159: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('There are no update tables created to refresh the derived facts',
2160: FND_LOG.LEVEL_STATEMENT);
2161: return true;
2162: end if;
2163: if EDW_SUMMARY_COLLECT.g_dim_empty_flag then
2164: if g_debug then
2165: EDW_OWB_COLLECTION_UTIL.write_to_log_file_n('This dimension was fully refreshed. So no need to inc refresh derv/summ facts'
2166: ,FND_LOG.LEVEL_STATEMENT);
2167: return true;