22: -- -------------------------------------------
23: Begin
24: Errbuf :=NULL;
25: Retcode:=0;
26: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
27: errbuf := fnd_message.get;
28: Return;
29: END IF;
30: /*
28: Return;
29: END IF;
30: /*
31: g_push_date_range1 := nvl(p_from_date,
32: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: g_push_date_range2 := nvl(p_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: */
35: IF (p_from_date IS NULL) THEN
36: OPI_EDW_UOM_CONV_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
29: END IF;
30: /*
31: g_push_date_range1 := nvl(p_from_date,
32: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: g_push_date_range2 := nvl(p_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: */
35: IF (p_from_date IS NULL) THEN
36: OPI_EDW_UOM_CONV_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
37: EDW_COLLECTION_UTIL.g_offset;
32: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: g_push_date_range2 := nvl(p_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: */
35: IF (p_from_date IS NULL) THEN
36: OPI_EDW_UOM_CONV_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
37: EDW_COLLECTION_UTIL.g_offset;
38: ELSE
39: OPI_EDW_UOM_CONV_F_C.g_push_date_range1 := to_date(p_from_date,
40: 'YYYY/MM/DD HH24:MI:SS');
33: g_push_date_range2 := nvl(p_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: */
35: IF (p_from_date IS NULL) THEN
36: OPI_EDW_UOM_CONV_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
37: EDW_COLLECTION_UTIL.g_offset;
38: ELSE
39: OPI_EDW_UOM_CONV_F_C.g_push_date_range1 := to_date(p_from_date,
40: 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
41: END IF;
42:
43: IF (p_to_date IS NULL) THEN
44: OPI_EDW_UOM_CONV_F_C.g_push_date_range2 :=
45: EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
46: ELSE
47: IF to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD') =
48: to_char(sysdate,'YYYY/MM/DD') THEN
49: OPI_EDW_UOM_CONV_F_C.g_push_date_range2 := to_date(to_char(sysdate,
161:
162: -- ---------------------------------------------------------------------------
163: -- END OF Collection , Developer Customizable Section
164: -- ---------------------------------------------------------------------------
165: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
166: OPI_EDW_UOM_CONV_F_C.g_push_date_range1,
167: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);
168:
169: Exception When others then
170: Errbuf:=sqlerrm;
171: Retcode:=sqlcode;
172: l_exception_msg := Retcode || ':' || Errbuf;
173: rollback;
174: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
175: OPI_EDW_UOM_CONV_F_C.g_push_date_range1,
176: OPI_EDW_UOM_CONV_F_C.g_push_date_range2);
177: raise;
178: