APPS.EDW_OPI_OPRN_M_C dependencies on EDW_COLLECTION_UTIL

Line 23: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN

19: -- -------------------------------------------
20: Begin
21: Errbuf :=NULL;
22: Retcode:=0;
23: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN
24: errbuf := fnd_message.get;
25: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
26: Return;
27: END IF;

Line 29: EDW_OPI_OPRN_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

25: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
26: Return;
27: END IF;
28: IF (p_from_date IS NULL) THEN
29: EDW_OPI_OPRN_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
30: EDW_COLLECTION_UTIL.g_offset;
31: ELSE
32: EDW_OPI_OPRN_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
33: END IF;

Line 30: EDW_COLLECTION_UTIL.g_offset;

26: Return;
27: END IF;
28: IF (p_from_date IS NULL) THEN
29: EDW_OPI_OPRN_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
30: EDW_COLLECTION_UTIL.g_offset;
31: ELSE
32: EDW_OPI_OPRN_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
33: END IF;
34: IF (p_to_date IS NULL) THEN

Line 35: EDW_OPI_OPRN_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

31: ELSE
32: EDW_OPI_OPRN_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
33: END IF;
34: IF (p_to_date IS NULL) THEN
35: EDW_OPI_OPRN_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
36: ELSE
37: EDW_OPI_OPRN_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
38: END IF;
39: edw_log.put_line( 'The collection range is from '||

Line 58: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_OPRN_M_C.g_exception_msg,

54: edw_log.put_line(' ');
55: -- ---------------------------------------------------------------------------
56: -- END OF Collection , Developer Customizable Section
57: -- ---------------------------------------------------------------------------
58: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_OPRN_M_C.g_exception_msg,
59: EDW_OPI_OPRN_M_C.g_push_date_range1,
60: EDW_OPI_OPRN_M_C.g_push_date_range2);
61: commit;
62: Exception When others then

Line 68: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_OPRN_M_C.g_exception_msg,

64: Retcode:=sqlcode;
65: l_exception_msg := Retcode || ':' || Errbuf;
66: EDW_OPI_OPRN_M_C.g_exception_msg := l_exception_msg;
67: rollback;
68: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_OPRN_M_C.g_exception_msg,
69: EDW_OPI_OPRN_M_C.g_push_date_range1,
70: EDW_OPI_OPRN_M_C.g_push_date_range2);
71: commit;
72: End;