APPS.EDW_GEOGRAPHY_M_C dependencies on EDW_COLLECTION_UTIL

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

33:
34: Begin
35: Errbuf :=NULL;
36: Retcode:=0;
37: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN
38: errbuf := fnd_message.get;
39: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
40: END IF;
41:

Line 42: EDW_COLLECTION_UTIL.get_dblink_names(g_source_link, g_target_link);

38: errbuf := fnd_message.get;
39: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
40: END IF;
41:
42: EDW_COLLECTION_UTIL.get_dblink_names(g_source_link, g_target_link);
43:
44: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
45: l_from_date := fnd_date.displayDT_to_date(p_from_date);
46: l_to_date := fnd_date.displayDT_to_date(p_to_date);

Line 49: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

45: l_from_date := fnd_date.displayDT_to_date(p_from_date);
46: l_to_date := fnd_date.displayDT_to_date(p_to_date);
47:
48: g_push_date_range1 := nvl(l_from_date,
49: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
50: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
51:
52: l_date1 := g_push_date_range1;
53: l_date2 := g_push_date_range2;

Line 50: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

46: l_to_date := fnd_date.displayDT_to_date(p_to_date);
47:
48: g_push_date_range1 := nvl(l_from_date,
49: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
50: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
51:
52: l_date1 := g_push_date_range1;
53: l_date2 := g_push_date_range2;
54: edw_log.put_line( 'The collection range is from '||

Line 92: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count_m, P_PERIOD_START => l_date1,

88: -- ---------------------------------------------------------------------------
89: -- END OF Collection , Developer Customizable Section
90: -- ---------------------------------------------------------------------------
91:
92: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count_m, P_PERIOD_START => l_date1,
93: P_PERIOD_END => l_date2);
94: commit;
95:
96: Exception When others then

Line 102: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GEOGRAPHY_M_C.g_exception_msg,

98: Retcode:=sqlcode;
99: l_exception_msg := Retcode || ':' || Errbuf;
100: EDW_GEOGRAPHY_M_C.g_exception_msg := l_exception_msg;
101: rollback;
102: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_GEOGRAPHY_M_C.g_exception_msg,
103: g_push_date_range1, g_push_date_range2);
104: End;
105:
106:

Line 496: l_tmp_str := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',

492:
493: l_date1 := p_from_date;
494: l_date2 := p_to_date;
495:
496: l_tmp_str := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
497: 'EDW_GEOGRAPHY_M_SREG');
498: if(l_tmp_str is NULL) THEN
499: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing State_Region');
500: end if;

Line 687: l_tmp_str := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',

683:
684: l_date1 := p_from_date;
685: l_date2 := p_to_date;
686:
687: l_tmp_str := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
688: 'EDW_GEOGRAPHY_M_REGN');
689: if(l_tmp_str is NULL) THEN
690: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing REGION');
691: end if;

Line 878: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',

874:
875: l_date1 := p_from_date;
876: l_date2 := p_to_date;
877:
878: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
879: 'EDW_GEOGRAPHY_M_ARE2');
880: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN', 'EDW_ALL');
881: if(l_tmp_str1 is NULL or l_tmp_str2 is NULL) THEN
882: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA2');

Line 880: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN', 'EDW_ALL');

876: l_date2 := p_to_date;
877:
878: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
879: 'EDW_GEOGRAPHY_M_ARE2');
880: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN', 'EDW_ALL');
881: if(l_tmp_str1 is NULL or l_tmp_str2 is NULL) THEN
882: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA2');
883: end if;
884:

Line 961: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',

957:
958: l_date1 := p_from_date;
959: l_date2 := p_to_date;
960:
961: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
962: 'EDW_GEOGRAPHY_M_ARE1');
963: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN', 'EDW_ALL');
964: if(l_tmp_str1 is NULL or l_tmp_str2 is NULL) THEN
965: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA1');

Line 963: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN', 'EDW_ALL');

959: l_date2 := p_to_date;
960:
961: l_tmp_str1 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN',
962: 'EDW_GEOGRAPHY_M_ARE1');
963: l_tmp_str2 := EDW_COLLECTION_UTIL.get_lookup_value ('EDW_LEVEL_PUSH_DOWN', 'EDW_ALL');
964: if(l_tmp_str1 is NULL or l_tmp_str2 is NULL) THEN
965: edw_log.put_line('***Warning*** : No Look Code Found From GET_LOOKUP_VALUE in Pushing AREA1');
966: end if;
967: