APPS.OPI_EDW_OPI_JOB_RSRC_F_C dependencies on EDW_COLLECTION_UTIL

Line 435: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,

431: Retcode:=0;
432:
433:
434:
435: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,
436: l_staging_table,
437: l_staging_table,
438: l_exception_msg)) THEN
439: errbuf := fnd_message.get;

Line 449: EDW_COLLECTION_UTIL.G_local_last_push_start_date

445:
446:
447: g_push_from_date
448: := nvl(l_from_date,
449: EDW_COLLECTION_UTIL.G_local_last_push_start_date
450: - EDW_COLLECTION_UTIL.g_offset);
451:
452: g_push_to_date:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
453:

Line 450: - EDW_COLLECTION_UTIL.g_offset);

446:
447: g_push_from_date
448: := nvl(l_from_date,
449: EDW_COLLECTION_UTIL.G_local_last_push_start_date
450: - EDW_COLLECTION_UTIL.g_offset);
451:
452: g_push_to_date:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
453:
454: --l_date1 := g_push_date_range1;

Line 452: g_push_to_date:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

448: := nvl(l_from_date,
449: EDW_COLLECTION_UTIL.G_local_last_push_start_date
450: - EDW_COLLECTION_UTIL.g_offset);
451:
452: g_push_to_date:= nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
453:
454: --l_date1 := g_push_date_range1;
455: --l_date2 := g_push_date_range2;
456:

Line 602: EDW_COLLECTION_UTIL.wrapup(TRUE,

598: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
599: ' rows into the staging table');
600: edw_log.put_line(' ');
601:
602: EDW_COLLECTION_UTIL.wrapup(TRUE,
603: g_row_count,
604: l_exception_msg,
605: g_push_from_date,
606: g_push_to_date);

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

626: Retcode:=g_retcode;
627: l_exception_msg := Retcode || ':' || Errbuf;
628: rollback; -- Rollback insert into local staging
629: edw_log.put_line('Inserting into local staging have failed');
630: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
631: raise;
632:
633: WHEN L_IDEN_CHANGE_FAILURE THEN
634: Errbuf:=g_errbuf;

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

640: execute immediate 'truncate table ' || l_opi_schema
641: || '.opi_edw_opi_job_rsrc_inc ';
642: END IF;
643: edw_log.put_line('Identifying changed records have Failed');
644: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_from_date,g_push_to_date);
645: raise;
646:
647: WHEN OTHERS THEN
648: Errbuf:= Sqlerrm;

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

649: Retcode:=sqlcode;
650: l_exception_msg := Retcode || ':' || Errbuf;
651: rollback;
652: edw_log.put_line('Other errors');
653: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
654: g_push_from_date, g_push_to_date);
655: raise;
656:
657: END push;