APPS.EDW_MTL_INVENTORY_LOC_M_C dependencies on EDW_COLLECTION_UTIL

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

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

Line 30: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

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

Line 31: EDW_COLLECTION_UTIL.g_offset;

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

Line 36: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

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

Line 63: EDW_COLLECTION_UTIL.wrapup(TRUE, g_lowest_level_count,

59: edw_log.put_line(' ');
60: -- ---------------------------------------------------------------------------
61: -- END OF Collection , Developer Customizable Section
62: -- ---------------------------------------------------------------------------
63: EDW_COLLECTION_UTIL.wrapup(TRUE, g_lowest_level_count,
64: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
65: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
66: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
67: commit;

Line 74: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,

70: Retcode:=sqlcode;
71: l_exception_msg := Retcode || ':' || Errbuf;
72: EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg := l_exception_msg;
73: rollback;
74: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_MTL_INVENTORY_LOC_M_C.g_exception_msg,
75: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range1,
76: EDW_MTL_INVENTORY_LOC_M_C.g_push_date_range2);
77: commit;
78: End;