eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_EDW_COGS_F_C dependencies on EDW_LOG

Line 551: edw_log.put_line( 'The collection range is from '||

547:
548:
549:
550:
551: edw_log.put_line( 'The collection range is from '||
552: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
553: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
554: edw_log.put_line(' ');
555:

Line 554: edw_log.put_line(' ');

550:
551: edw_log.put_line( 'The collection range is from '||
552: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
553: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
554: edw_log.put_line(' ');
555:
556: -- --------------------------------------------------------
557: -- Identify Change for View Type 1
558: -- --------------------------------------------------------

Line 559: edw_log.put_line(' ');

555:
556: -- --------------------------------------------------------
557: -- Identify Change for View Type 1
558: -- --------------------------------------------------------
559: edw_log.put_line(' ');
560: edw_log.put_line('Identifying change in view type 1');
561:
562: l_row_count := 0;
563: l_seq_id_view1 := identify_change( p_view_id => 1,

Line 560: edw_log.put_line('Identifying change in view type 1');

556: -- --------------------------------------------------------
557: -- Identify Change for View Type 1
558: -- --------------------------------------------------------
559: edw_log.put_line(' ');
560: edw_log.put_line('Identifying change in view type 1');
561:
562: l_row_count := 0;
563: l_seq_id_view1 := identify_change( p_view_id => 1,
564: p_count => l_row_count );

Line 569: edw_log.put_line('Identified '|| l_row_count

565: IF (l_seq_id_view1 = -1 ) THEN
566: RAISE l_iden_change_failure;
567: END IF;
568:
569: edw_log.put_line('Identified '|| l_row_count
570: || ' changed records in view type 1. ');
571: -- --------------------------------------------------------
572: -- Identify Change for View Type 2
573: -- --------------------------------------------------------

Line 574: edw_log.put_line(' ');

570: || ' changed records in view type 1. ');
571: -- --------------------------------------------------------
572: -- Identify Change for View Type 2
573: -- --------------------------------------------------------
574: edw_log.put_line(' ');
575: edw_log.put_line('Identifying change in view type 2');
576: l_row_count := 0;
577: l_seq_id_view2 := identify_change( p_view_id => 2,
578: p_count => l_row_count );

Line 575: edw_log.put_line('Identifying change in view type 2');

571: -- --------------------------------------------------------
572: -- Identify Change for View Type 2
573: -- --------------------------------------------------------
574: edw_log.put_line(' ');
575: edw_log.put_line('Identifying change in view type 2');
576: l_row_count := 0;
577: l_seq_id_view2 := identify_change( p_view_id => 2,
578: p_count => l_row_count );
579: IF (l_seq_id_view2 = -1 ) THEN

Line 583: edw_log.put_line('Identified '|| l_row_count

579: IF (l_seq_id_view2 = -1 ) THEN
580: RAISE l_iden_change_failure;
581: END IF;
582:
583: edw_log.put_line('Identified '|| l_row_count
584: || ' changed records in view type 2. ');
585:
586: -- --------------------------------------------------------
587: -- Identify Change for View Type 3

Line 589: edw_log.put_line(' ');

585:
586: -- --------------------------------------------------------
587: -- Identify Change for View Type 3
588: -- --------------------------------------------------------
589: edw_log.put_line(' ');
590: edw_log.put_line('Identifying change in view type 3');
591: l_row_count := 0;
592: l_seq_id_view3 := identify_change( p_view_id => 3,
593: p_count => l_row_count );

Line 590: edw_log.put_line('Identifying change in view type 3');

586: -- --------------------------------------------------------
587: -- Identify Change for View Type 3
588: -- --------------------------------------------------------
589: edw_log.put_line(' ');
590: edw_log.put_line('Identifying change in view type 3');
591: l_row_count := 0;
592: l_seq_id_view3 := identify_change( p_view_id => 3,
593: p_count => l_row_count );
594: IF (l_seq_id_view3 = -1 ) THEN

Line 598: edw_log.put_line('Identified '|| l_row_count

594: IF (l_seq_id_view3 = -1 ) THEN
595: RAISE l_iden_change_failure;
596: END IF;
597:
598: edw_log.put_line('Identified '|| l_row_count
599: || ' changed records in view type 3. ');
600:
601: --RAISE l_iden_change_failure;
602: -- --------------------------------------------------------

Line 614: edw_log.put_line(' ');

610:
611: -- --------------------------------------------------------
612: -- . Pushing data to local staging table
613: -- --------------------------------------------------------
614: edw_log.put_line(' ');
615: edw_log.put_line('Inserting into local staging table for view type 1');
616:
617: l_row_count_view1 := push_to_local( p_view_id => 1,
618: p_seq_id => l_seq_id_view1 );

Line 615: edw_log.put_line('Inserting into local staging table for view type 1');

611: -- --------------------------------------------------------
612: -- . Pushing data to local staging table
613: -- --------------------------------------------------------
614: edw_log.put_line(' ');
615: edw_log.put_line('Inserting into local staging table for view type 1');
616:
617: l_row_count_view1 := push_to_local( p_view_id => 1,
618: p_seq_id => l_seq_id_view1 );
619: IF l_row_count_view1 = -1 THEN

Line 623: edw_log.put_line('Inserted ' || Nvl(l_row_count_view1,0) ||

619: IF l_row_count_view1 = -1 THEN
620: RAISE l_push_local_failure;
621: END IF;
622:
623: edw_log.put_line('Inserted ' || Nvl(l_row_count_view1,0) ||
624: ' rows into local staging table for view type 1');
625: edw_log.put_line(' ');
626:
627: --

Line 625: edw_log.put_line(' ');

621: END IF;
622:
623: edw_log.put_line('Inserted ' || Nvl(l_row_count_view1,0) ||
624: ' rows into local staging table for view type 1');
625: edw_log.put_line(' ');
626:
627: --
628: edw_log.put_line(' ');
629: edw_log.put_line('Inserting into local staging table for view type 2');

Line 628: edw_log.put_line(' ');

624: ' rows into local staging table for view type 1');
625: edw_log.put_line(' ');
626:
627: --
628: edw_log.put_line(' ');
629: edw_log.put_line('Inserting into local staging table for view type 2');
630:
631: l_row_count_view2 := push_to_local( p_view_id => 2,
632: p_seq_id => l_seq_id_view2 );

Line 629: edw_log.put_line('Inserting into local staging table for view type 2');

625: edw_log.put_line(' ');
626:
627: --
628: edw_log.put_line(' ');
629: edw_log.put_line('Inserting into local staging table for view type 2');
630:
631: l_row_count_view2 := push_to_local( p_view_id => 2,
632: p_seq_id => l_seq_id_view2 );
633: IF l_row_count_view2 = -1 THEN

Line 636: edw_log.put_line('Inserted ' || Nvl(l_row_count_view2,0) ||

632: p_seq_id => l_seq_id_view2 );
633: IF l_row_count_view2 = -1 THEN
634: RAISE l_push_local_failure;
635: END IF;
636: edw_log.put_line('Inserted ' || Nvl(l_row_count_view2,0) ||
637: ' rows into local staging table for view type 2');
638: edw_log.put_line(' ');
639:
640:

Line 638: edw_log.put_line(' ');

634: RAISE l_push_local_failure;
635: END IF;
636: edw_log.put_line('Inserted ' || Nvl(l_row_count_view2,0) ||
637: ' rows into local staging table for view type 2');
638: edw_log.put_line(' ');
639:
640:
641: --
642: edw_log.put_line(' ');

Line 642: edw_log.put_line(' ');

638: edw_log.put_line(' ');
639:
640:
641: --
642: edw_log.put_line(' ');
643: edw_log.put_line('Inserting into local staging table for view type 3');
644:
645: l_row_count_view3 := push_to_local( p_view_id => 3,
646: p_seq_id => l_seq_id_view3 );

Line 643: edw_log.put_line('Inserting into local staging table for view type 3');

639:
640:
641: --
642: edw_log.put_line(' ');
643: edw_log.put_line('Inserting into local staging table for view type 3');
644:
645: l_row_count_view3 := push_to_local( p_view_id => 3,
646: p_seq_id => l_seq_id_view3 );
647: IF l_row_count_view3 = -1 THEN

Line 650: edw_log.put_line('Inserted ' || Nvl(l_row_count_view3,0) ||

646: p_seq_id => l_seq_id_view3 );
647: IF l_row_count_view3 = -1 THEN
648: RAISE l_push_local_failure;
649: END IF;
650: edw_log.put_line('Inserted ' || Nvl(l_row_count_view3,0) ||
651: ' rows into local staging table for view type 3');
652: edw_log.put_line(' ');
653:
654: --

Line 652: edw_log.put_line(' ');

648: RAISE l_push_local_failure;
649: END IF;
650: edw_log.put_line('Inserted ' || Nvl(l_row_count_view3,0) ||
651: ' rows into local staging table for view type 3');
652: edw_log.put_line(' ');
653:
654: --
655: g_row_count := l_row_count_view1 + l_row_count_view2 + l_row_count_view3;
656:

Line 657: edw_log.put_line('For all view types, inserted ' || Nvl(g_row_count,0)

653:
654: --
655: g_row_count := l_row_count_view1 + l_row_count_view2 + l_row_count_view3;
656:
657: edw_log.put_line('For all view types, inserted ' || Nvl(g_row_count,0)
658: || ' rows into local staging table.');
659: edw_log.put_line(' ');
660:
661:

Line 659: edw_log.put_line(' ');

655: g_row_count := l_row_count_view1 + l_row_count_view2 + l_row_count_view3;
656:
657: edw_log.put_line('For all view types, inserted ' || Nvl(g_row_count,0)
658: || ' rows into local staging table.');
659: edw_log.put_line(' ');
660:
661:
662:
663: -- --------------------------------------------------------

Line 719: edw_log.put_line(' ');

715: -- --------------------------------------------
716: -- No exception raised so far. Call wrapup to transport
717: -- data to target database, and insert messages into logs
718: -- -----------------------------------------------
719: edw_log.put_line(' ');
720: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
721: ' rows into the staging table');
722: edw_log.put_line(' ');
723:

Line 720: edw_log.put_line('Inserted '||nvl(g_row_count,0)||

716: -- No exception raised so far. Call wrapup to transport
717: -- data to target database, and insert messages into logs
718: -- -----------------------------------------------
719: edw_log.put_line(' ');
720: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
721: ' rows into the staging table');
722: edw_log.put_line(' ');
723:
724: EDW_COLLECTION_UTIL.wrapup(TRUE,

Line 722: edw_log.put_line(' ');

718: -- -----------------------------------------------
719: edw_log.put_line(' ');
720: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
721: ' rows into the staging table');
722: edw_log.put_line(' ');
723:
724: EDW_COLLECTION_UTIL.wrapup(TRUE,
725: g_row_count,
726: l_exception_msg,

Line 748: edw_log.put_line( l_exception_msg);

744:
745: Retcode:= 1; -- completed with warning
746: l_exception_msg := Retcode || ':' || Errbuf;
747: rollback;
748: edw_log.put_line( l_exception_msg);
749: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
750: g_push_from_date, g_push_to_date);
751:
752: WHEN L_PUSH_LOCAL_FAILURE THEN

Line 757: edw_log.put_line('Inserting into local staging have failed');

753: Errbuf:=g_errbuf;
754: Retcode:=g_retcode;
755: l_exception_msg := Retcode || ':' || Errbuf;
756: rollback; -- Rollback insert into local staging
757: edw_log.put_line('Inserting into local staging have failed');
758: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
759: g_push_from_date, g_push_to_date);
760: raise;
761:

Line 772: edw_log.put_line('Identifying changed records have Failed');

768: l_industry, l_opi_schema) THEN
769: execute immediate 'truncate table ' || l_opi_schema
770: || '.opi_edw_cogs_inc ';
771: END IF;
772: edw_log.put_line('Identifying changed records have Failed');
773: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
774: g_push_from_date, g_push_to_date);
775: raise;
776:

Line 782: edw_log.put_line('Other errors');

778: Errbuf:= Sqlerrm;
779: Retcode:=sqlcode;
780: l_exception_msg := Retcode || ':' || Errbuf;
781: rollback;
782: edw_log.put_line('Other errors');
783: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,
784: g_push_from_date, g_push_to_date);
785: raise;
786: