APPS.ISC_EDW_BOOK_SUM1_F_C dependencies on EDW_COLLECTION_UTIL

Line 507: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name))

503: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
504: l_from_booked_date := to_date(p_from_booked_date,'YYYY/MM/DD HH24:MI:SS');
505: l_to_booked_date := to_date(p_to_booked_date, 'YYYY/MM/DD HH24:MI:SS');
506:
507: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name))
508: THEN errbuf := fnd_message.get;
509: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
510: END IF;
511:

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

509: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
510: END IF;
511:
512: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date := nvl(l_from_date,
513: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
514:
515: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date := nvl(l_to_date,
516: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
517:

Line 516: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

512: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date := nvl(l_from_date,
513: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
514:
515: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date := nvl(l_to_date,
516: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
517:
518: ISC_EDW_BOOK_SUM1_F_C.g_push_from_booked_date := nvl(l_from_booked_date,
519: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
520:

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

515: ISC_EDW_BOOK_SUM1_F_C.g_push_to_date := nvl(l_to_date,
516: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
517:
518: ISC_EDW_BOOK_SUM1_F_C.g_push_from_booked_date := nvl(l_from_booked_date,
519: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
520:
521: ISC_EDW_BOOK_SUM1_F_C.g_push_to_booked_date := nvl(l_to_booked_date,
522: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
523:

Line 522: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

518: ISC_EDW_BOOK_SUM1_F_C.g_push_from_booked_date := nvl(l_from_booked_date,
519: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
520:
521: ISC_EDW_BOOK_SUM1_F_C.g_push_to_booked_date := nvl(l_to_booked_date,
522: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
523:
524: EDW_LOG.Put_Line( 'The collection range is from '||
525: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
526: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));

Line 650: EDW_COLLECTION_UTIL.Wrapup(

646: EDW_LOG.Put_Line(' ');
647: EDW_LOG.Put_Line('Inserted '||nvl(g_row_count,0)||' rows into the staging table');
648: EDW_LOG.Put_Line(' ');
649:
650: EDW_COLLECTION_UTIL.Wrapup(
651: TRUE,
652: g_row_count,
653: NULL,
654: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

Line 670: EDW_COLLECTION_UTIL.Wrapup(

666: retcode := g_retcode;
667: l_exception_msg := errbuf;
668: ROLLBACK; -- Rollback insert into local staging
669: EDW_LOG.Put_Line('Inserting into local staging has failed : '|| l_exception_msg);
670: EDW_COLLECTION_UTIL.Wrapup(
671: FALSE,
672: g_row_count,
673: NULL,
674: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

Line 685: EDW_COLLECTION_UTIL.Wrapup(

681: l_exception_msg := errbuf;
682: ROLLBACK; -- rollback any insert into remote site
683: TRUNCATE_STG; -- Cleanup local staging table
684: EDW_LOG.Put_Line('Data migration from local to remote staging has failed : '|| l_exception_msg);
685: EDW_COLLECTION_UTIL.Wrapup(
686: FALSE,
687: g_row_count,
688: NULL,
689: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

Line 701: EDW_COLLECTION_UTIL.Wrapup(

697: ROLLBACK; -- Rollback the status to 'LOCAL READY'
698: DELETE_STG; -- Delete records in staging with status 'LOCAL READY'
699: COMMIT;
700: EDW_LOG.Put_Line('Setting status to READY has failed : '|| l_exception_msg);
701: EDW_COLLECTION_UTIL.Wrapup(
702: FALSE,
703: g_row_count,
704: NULL,
705: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

Line 717: EDW_COLLECTION_UTIL.Wrapup(

713: DELETE isc_tmp_book_sum1
714: WHERE seq_id IN ( l_seq_id_line);
715: COMMIT;
716: EDW_LOG.Put_Line('Identifying changed records has Failed : '|| l_exception_msg);
717: EDW_COLLECTION_UTIL.Wrapup(
718: FALSE,
719: g_row_count,
720: NULL,
721: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,

Line 731: EDW_COLLECTION_UTIL.Wrapup(

727: retcode := g_retcode;
728: l_exception_msg := errbuf;
729: ROLLBACK;
730: EDW_LOG.Put_Line('Other errors : '|| l_exception_msg);
731: EDW_COLLECTION_UTIL.Wrapup(
732: FALSE,
733: g_row_count,
734: NULL,
735: ISC_EDW_BOOK_SUM1_F_C.g_push_from_date,