DBA Data[Home] [Help]

APPS.FII_PA_UOM_CONV_F_C dependencies on EDW_COLLECTION_UTIL

Line 38: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN

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

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

45: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
46: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
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:
51: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
52:
53: l_date1 := g_push_date_range1;

Line 51: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_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:
51: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
52:
53: l_date1 := g_push_date_range1;
54: l_date2 := g_push_date_range2;
55:

Line 154: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);

150: -- ---------------------------------------------------------------------------
151: -- END OF Collection , Developer Customizable Section
152: -- ---------------------------------------------------------------------------
153:
154: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
155:
156: Exception When others then
157:
158: Errbuf:=sqlerrm;

Line 162: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

158: Errbuf:=sqlerrm;
159: Retcode:=sqlcode;
160: l_exception_msg := Retcode || ':' || Errbuf;
161: rollback;
162: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
163: raise;
164: End;
165:
166: End FII_PA_UOM_CONV_F_C;