APPS.OPI_EDW_OPM_JOB_RSRC_F_C dependencies on EDW_COLLECTION_UTIL

Line 386: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,l_staging_table,l_staging_table,l_exception_msg)) THEN

382: Errbuf :=NULL;
383: Retcode:=0;
384: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
385: l_to_date :=to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS');
386: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,l_staging_table,l_staging_table,l_exception_msg)) THEN
387: errbuf := fnd_message.get;
388: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
389: Return;
390: END IF;

Line 396: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

392: -- Taking care of cases where the input from/to
393: -- date is NULL.
394: -- --------------------------------------------
395: g_push_from_date := nvl(l_from_date,
396: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
397: EDW_COLLECTION_UTIL.g_offset);
398: g_push_to_date := nvl(l_to_date,
399: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
400: edw_log.put_line( 'The collection range is from '||

Line 397: EDW_COLLECTION_UTIL.g_offset);

393: -- date is NULL.
394: -- --------------------------------------------
395: g_push_from_date := nvl(l_from_date,
396: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
397: EDW_COLLECTION_UTIL.g_offset);
398: g_push_to_date := nvl(l_to_date,
399: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
400: edw_log.put_line( 'The collection range is from '||
401: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 399: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

395: g_push_from_date := nvl(l_from_date,
396: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
397: EDW_COLLECTION_UTIL.g_offset);
398: g_push_to_date := nvl(l_to_date,
399: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
400: edw_log.put_line( 'The collection range is from '||
401: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
402: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
403: edw_log.put_line(' ');

Line 431: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,

427: edw_log.put_line(' ');
428: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
429: ' rows into the staging table');
430: edw_log.put_line(' ');
431: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
432: g_push_from_date, g_push_to_date);
433: -- ---------------------------------------------------------------------------
434: -- END OF Collection , Developer Customizable Section
435: -- ---------------------------------------------------------------------------

Line 443: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);

439: Retcode:=g_retcode;
440: l_exception_msg := Retcode || ':' || Errbuf;
441: rollback; -- Rollback insert into local staging
442: edw_log.put_line('Inserting into local staging have failed');
443: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
444: raise;
445: WHEN L_IDEN_CHANGE_FAILURE THEN
446: Errbuf:=g_errbuf;
447: Retcode:=g_retcode;

Line 450: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);

446: Errbuf:=g_errbuf;
447: Retcode:=g_retcode;
448: l_exception_msg := Retcode || ':' || Errbuf;
449: edw_log.put_line('Identifying changed records have Failed');
450: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
451: raise;
452: WHEN OTHERS THEN
453: Errbuf:=g_errbuf;
454: Retcode:=g_retcode;

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

454: Retcode:=g_retcode;
455: l_exception_msg := Retcode || ':' || Errbuf;
456: rollback;
457: edw_log.put_line('Other errors');
458: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
459: g_push_from_date, g_push_to_date);
460: raise;
461: END;
462: END OPI_EDW_OPM_JOB_RSRC_F_C ;