APPS.POA_EDW_CSTM_MSR_F_C dependencies on EDW_COLLECTION_UTIL

Line 257: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name, l_staging_table,

253:
254: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
255: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
256:
257: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name, l_staging_table,
258: l_staging_table, l_exception_msg)) THEN
259: errbuf := fnd_message.get;
260: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
261: END IF;

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

266: -- date is NULL.
267: -- --------------------------------------------
268:
269: g_push_date_range1 := nvl(l_from_date,
270: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
271: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
272:
273: edw_log.put_line( 'The collection range is from '||
274: to_char(g_push_date_range1, 'MM/DD/YYYY HH24:MI:SS')||' to '||

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

267: -- --------------------------------------------
268:
269: g_push_date_range1 := nvl(l_from_date,
270: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
271: g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
272:
273: edw_log.put_line( 'The collection range is from '||
274: to_char(g_push_date_range1, 'MM/DD/YYYY HH24:MI:SS')||' to '||
275: to_char(g_push_date_range2, 'MM/DD/YYYY HH24:MI:SS'));

Line 325: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,

321: edw_log.put_line(' ');
322: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));
323: edw_log.put_line(' ');
324:
325: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
326: P_PERIOD_START => g_push_date_range1,
327: P_PERIOD_END => g_push_date_range2);
328:
329: EXCEPTION

Line 337: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,

333: Retcode:=g_retcode;
334: l_exception_msg := Retcode || ':' || Errbuf;
335: rollback; -- Rollback insert into local staging
336: edw_log.put_line('Inserting into local staging have failed');
337: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
338: g_push_date_range1, g_push_date_range2);
339: raise;
340:
341: WHEN L_IDEN_CHANGE_FAILURE THEN

Line 347: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,

343: Retcode:=g_retcode;
344: l_exception_msg := Retcode || ':' || Errbuf;
345: TRUNCATE_INC;
346: edw_log.put_line('Identifying changed records have Failed');
347: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
348: g_push_date_range1, g_push_date_range2);
349: raise;
350:
351: WHEN OTHERS THEN

Line 357: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,

353: Retcode:=g_retcode;
354: l_exception_msg := Retcode || ':' || Errbuf;
355: rollback;
356: edw_log.put_line('Other errors');
357: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
358: g_push_date_range1, g_push_date_range2);
359: raise;
360:
361: End;