25: errbuf := fnd_message.get;
26: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
27: End If;
28:
29: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
30: l_from_date := fnd_date.displayDT_to_date(p_from_date);
31: l_to_date := fnd_date.displayDT_to_date(p_to_date);
32:
33: l_push_date_range1 := nvl(l_from_date,
26: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
27: End If;
28:
29: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
30: l_from_date := fnd_date.displayDT_to_date(p_from_date);
31: l_to_date := fnd_date.displayDT_to_date(p_to_date);
32:
33: l_push_date_range1 := nvl(l_from_date,
34: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
27: End If;
28:
29: fnd_date.initialize('YYYY/MM/DD', 'YYYY/MM/DD HH24:MI:SS');
30: l_from_date := fnd_date.displayDT_to_date(p_from_date);
31: l_to_date := fnd_date.displayDT_to_date(p_to_date);
32:
33: l_push_date_range1 := nvl(l_from_date,
34: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
35: l_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);