APPS.OPI_EDW_OPM_JOB_DETAIL_F_C dependencies on EDW_COLLECTION_UTIL

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

441: Retcode:=0;
442: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
443: l_to_date :=to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS');
444:
445: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,l_staging_table,l_staging_table,l_exception_msg)) THEN
446: errbuf := fnd_message.get;
447: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
448: Return;
449: END IF;

Line 455: EDW_COLLECTION_UTIL.G_local_last_push_start_date -

451: -- Taking care of cases where the input from/to
452: -- date is NULL.
453: -- --------------------------------------------
454: g_push_from_date := nvl(l_from_date,
455: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
456: EDW_COLLECTION_UTIL.g_offset);
457: g_push_to_date := nvl(l_to_date,
458: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
459: edw_log.put_line( 'The collection range is from '||

Line 456: EDW_COLLECTION_UTIL.g_offset);

452: -- date is NULL.
453: -- --------------------------------------------
454: g_push_from_date := nvl(l_from_date,
455: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
456: EDW_COLLECTION_UTIL.g_offset);
457: g_push_to_date := nvl(l_to_date,
458: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
459: edw_log.put_line( 'The collection range is from '||
460: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 458: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

454: g_push_from_date := nvl(l_from_date,
455: EDW_COLLECTION_UTIL.G_local_last_push_start_date -
456: EDW_COLLECTION_UTIL.g_offset);
457: g_push_to_date := nvl(l_to_date,
458: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
459: edw_log.put_line( 'The collection range is from '||
460: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
461: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
462: edw_log.put_line(' ');

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

495: ' rows into the staging table');
496: edw_log.put_line(' ');
497: commit;
498:
499: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, l_exception_msg,
500: g_push_from_date, g_push_to_date);
501: -- ---------------------------------------------------------------------------
502: -- END OF Collection , Developer Customizable Section
503: -- ---------------------------------------------------------------------------

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

507: Retcode:=g_retcode;
508: l_exception_msg := Retcode || ':' || Errbuf;
509: rollback; -- Rollback insert into local staging
510: edw_log.put_line('Inserting into local staging have failed');
511: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
512: raise;
513: WHEN L_IDEN_CHANGE_FAILURE THEN
514: Errbuf:=g_errbuf;
515: Retcode:=g_retcode;

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

514: Errbuf:=g_errbuf;
515: Retcode:=g_retcode;
516: l_exception_msg := Retcode || ':' || Errbuf;
517: edw_log.put_line('Identifying changed records have Failed');
518: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
519: raise;
520: WHEN OTHERS THEN
521: Errbuf:=g_errbuf;
522: Retcode:=g_retcode;

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

522: Retcode:=g_retcode;
523: l_exception_msg := Retcode || ':' || Errbuf;
524: rollback;
525: edw_log.put_line('Other errors');
526: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
527: g_push_from_date, g_push_to_date);
528: raise;
529: END;
530: END OPI_EDW_OPM_JOB_DETAIL_F_C ;