APPS.FII_PA_REVENUE_F_C dependencies on FII_UTIL

Line 632: fii_util.start_timer;

628: -- --------------------------------------------------------
629:
630: if g_debug_flag = 'Y' then
631: edw_log.put_line(' ');
632: fii_util.start_timer;
633: end if;
634:
635: if NOT IDENTIFY_CHANGE THEN
636: RAISE l_iden_change_failure;

Line 640: fii_util.stop_timer;

636: RAISE l_iden_change_failure;
637: end if;
638:
639: if g_debug_flag = 'Y' then
640: fii_util.stop_timer;
641: fii_util.print_timer('Process Time');
642: end if;
643:
644: -- --------------------------------------------------------

Line 641: fii_util.print_timer('Process Time');

637: end if;
638:
639: if g_debug_flag = 'Y' then
640: fii_util.stop_timer;
641: fii_util.print_timer('Process Time');
642: end if;
643:
644: -- --------------------------------------------------------
645: -- 3. Pushing data to local staging table

Line 651: fii_util.start_timer;

647:
648: if g_debug_flag = 'Y' then
649: edw_log.put_line(' ');
650: edw_log.put_line('Pushing data');
651: fii_util.start_timer;
652: end if;
653:
654: g_row_count := PUSH_TO_LOCAL;
655:

Line 657: fii_util.stop_timer;

653:
654: g_row_count := PUSH_TO_LOCAL;
655:
656: if g_debug_flag = 'Y' then
657: fii_util.stop_timer;
658: fii_util.print_timer('Process Time');
659: end if;
660:
661: IF (g_row_count = -1) THEN

Line 658: fii_util.print_timer('Process Time');

654: g_row_count := PUSH_TO_LOCAL;
655:
656: if g_debug_flag = 'Y' then
657: fii_util.stop_timer;
658: fii_util.print_timer('Process Time');
659: end if;
660:
661: IF (g_row_count = -1) THEN
662: RAISE L_push_local_failure;

Line 729: fii_util.start_timer;

725:
726: if g_debug_flag = 'Y' then
727: edw_log.put_line(' ');
728: edw_log.put_line('Moving data from local staging table to remote staging table');
729: fii_util.start_timer;
730: end if;
731:
732: g_row_count := PUSH_REMOTE;
733:

Line 735: fii_util.stop_timer;

731:
732: g_row_count := PUSH_REMOTE;
733:
734: if g_debug_flag = 'Y' then
735: fii_util.stop_timer;
736: fii_util.print_timer('Process time');
737: end if;
738:
739: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;

Line 736: fii_util.print_timer('Process time');

732: g_row_count := PUSH_REMOTE;
733:
734: if g_debug_flag = 'Y' then
735: fii_util.stop_timer;
736: fii_util.print_timer('Process time');
737: end if;
738:
739: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
740:

Line 744: fii_util.start_timer;

740:
741: if g_debug_flag = 'Y' then
742: edw_log.put_line(' ');
743: edw_log.put_line('Cleaning local staging table');
744: fii_util.start_timer;
745: end if;
746:
747: TRUNCATE_STG;
748:

Line 750: fii_util.stop_timer;

746:
747: TRUNCATE_STG;
748:
749: if g_debug_flag = 'Y' then
750: fii_util.stop_timer;
751: fii_util.print_timer('Process time');
752: end if;
753:
754: ELSE

Line 751: fii_util.print_timer('Process time');

747: TRUNCATE_STG;
748:
749: if g_debug_flag = 'Y' then
750: fii_util.stop_timer;
751: fii_util.print_timer('Process time');
752: end if;
753:
754: ELSE
755: -- -----------------------------------------------

Line 764: fii_util.start_timer;

760:
761: if g_debug_flag = 'Y' then
762: edw_log.put_line(' ');
763: edw_log.put_line('Marking records in staging table with READY status');
764: fii_util.start_timer;
765: end if;
766:
767: g_row_count := SET_STATUS_READY;
768:

Line 770: fii_util.stop_timer;

766:
767: g_row_count := SET_STATUS_READY;
768:
769: if g_debug_flag = 'Y' then
770: fii_util.stop_timer;
771: fii_util.print_timer('Process time');
772: end if;
773:
774: DELETE_STG;

Line 771: fii_util.print_timer('Process time');

767: g_row_count := SET_STATUS_READY;
768:
769: if g_debug_flag = 'Y' then
770: fii_util.stop_timer;
771: fii_util.print_timer('Process time');
772: end if;
773:
774: DELETE_STG;
775: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;