16: Errbuf :=NULL;
17: Retcode:=0;
18:
19: edw_log.put_line(' ');
20: edw_log.put_line('call EDW_COLLECTION_UTIL ');
21: -- -------------------------------------------
22: -- call edw_collection_util.setup
23: -- -------------------------------------------
24: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
18:
19: edw_log.put_line(' ');
20: edw_log.put_line('call EDW_COLLECTION_UTIL ');
21: -- -------------------------------------------
22: -- call edw_collection_util.setup
23: -- -------------------------------------------
24: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
25: l_staging_table,
26: l_staging_table,
20: edw_log.put_line('call EDW_COLLECTION_UTIL ');
21: -- -------------------------------------------
22: -- call edw_collection_util.setup
23: -- -------------------------------------------
24: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
25: l_staging_table,
26: l_staging_table,
27: l_exception_msg)) THEN
28: errbuf := fnd_message.get;
42: -- date is NULL.
43: -- --------------------------------------------
44:
45: l_from_date := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
47: EDW_COLLECTION_UTIL.g_offset);
48: l_to_date := nvl(l_to_date,
49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
50: -- End of code change for bug fix 2140267.
43: -- --------------------------------------------
44:
45: l_from_date := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
47: EDW_COLLECTION_UTIL.g_offset);
48: l_to_date := nvl(l_to_date,
49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
50: -- End of code change for bug fix 2140267.
51: IF l_fact_name = 'OPI_EDW_INV_DAILY_STAT_F' THEN
45: l_from_date := nvl(l_from_date,
46: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
47: EDW_COLLECTION_UTIL.g_offset);
48: l_to_date := nvl(l_to_date,
49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
50: -- End of code change for bug fix 2140267.
51: IF l_fact_name = 'OPI_EDW_INV_DAILY_STAT_F' THEN
52: edw_log.put_line(' ');
53: -- edw_log.put_line(' Start of Collect Process Inventory Daily Status ');