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.FII_POPULATE_TIME dependencies on EDW_LOG

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

91:
92: begin
93: l_start_date_init := nvl(trunc(p_from_date,'mm'),trunc(sysdate-1900,'YYYY'));
94: l_end_date_init:= nvl(p_to_date,trunc(sysdate+2200,'YYYY'));
95: edw_log.put_line( 'The collection range is from '||
96: to_char(l_start_date_init,'dd-MON-yyyy')||' to '||
97: to_char(l_end_date_init,'dd-MON-yyyy'));
98: edw_log.put_line(' ');
99:

Line 98: edw_log.put_line(' ');

94: l_end_date_init:= nvl(p_to_date,trunc(sysdate+2200,'YYYY'));
95: edw_log.put_line( 'The collection range is from '||
96: to_char(l_start_date_init,'dd-MON-yyyy')||' to '||
97: to_char(l_end_date_init,'dd-MON-yyyy'));
98: edw_log.put_line(' ');
99:
100: Select substrb(edw_instance.get_code,1,40)
101: into l_instance
102: from dual;

Line 244: edw_log.put_line(' ');

240: -- Begin Pushing gregorian hierarchy
241: -- ---------------------------------------------------------
242: /* Pushing Day */
243: begin
244: edw_log.put_line(' ');
245: edw_log.put_line('Pushing Day and Calendar Day');
246: fii_util.start_timer;
247: loop
248: insert into edw_time_day_lstg

Line 245: edw_log.put_line('Pushing Day and Calendar Day');

241: -- ---------------------------------------------------------
242: /* Pushing Day */
243: begin
244: edw_log.put_line(' ');
245: edw_log.put_line('Pushing Day and Calendar Day');
246: fii_util.start_timer;
247: loop
248: insert into edw_time_day_lstg
249: (day_pk,

Line 358: edw_log.put_line(' ');

354: end loop;
355: commit;
356: fii_util.stop_timer;
357: fii_util.print_timer('Process Time');
358: edw_log.put_line(' ');
359: end;
360:
361: /* Pushing Month */
362: begin

Line 363: edw_log.put_line('Pushing Month and Month level push down');

359: end;
360:
361: /* Pushing Month */
362: begin
363: edw_log.put_line('Pushing Month and Month level push down');
364: fii_util.start_timer;
365: loop
366: l_mon_quarter_date:=trunc(l_mon_month_start_date,'Q');
367:

Line 507: edw_log.put_line(' ');

503: end loop;
504: commit;
505: fii_util.stop_timer;
506: fii_util.print_timer('Process Time');
507: edw_log.put_line(' ');
508: end;
509:
510: /* Pushing Quarter */
511: begin

Line 512: edw_log.put_line('Pushing Quarter');

508: end;
509:
510: /* Pushing Quarter */
511: begin
512: edw_log.put_line('Pushing Quarter');
513: fii_util.start_timer;
514: l_quarter:=fnd_message.get_string('FII', 'FII_AR_QUARTER');
515: loop
516: insert into edw_time_qtr_lstg

Line 554: edw_log.put_line(' ');

550: end loop;
551: commit;
552: fii_util.stop_timer;
553: fii_util.print_timer('Process Time');
554: edw_log.put_line(' ');
555: end;
556:
557: /* Pushing Half Year */
558: begin

Line 559: edw_log.put_line('Pushing Half Year');

555: end;
556:
557: /* Pushing Half Year */
558: begin
559: edw_log.put_line('Pushing Half Year');
560: fii_util.start_timer;
561: l_first_half:=fnd_message.get_string('FII', 'FII_AR_FIRST_HALF');
562: l_second_half:=fnd_message.get_string('FII', 'FII_AR_SECOND_HALF');
563: loop

Line 609: edw_log.put_line(' ');

605: end loop;
606: commit;
607: fii_util.stop_timer;
608: fii_util.print_timer('Process Time');
609: edw_log.put_line(' ');
610: end;
611:
612: /* Pushing Year */
613: begin

Line 614: edw_log.put_line('Pushing Year');

610: end;
611:
612: /* Pushing Year */
613: begin
614: edw_log.put_line('Pushing Year');
615: fii_util.start_timer;
616: loop
617: insert into edw_time_year_lstg
618: (year_pk,

Line 656: edw_log.put_line(' ');

652: end loop;
653: commit;
654: fii_util.stop_timer;
655: fii_util.print_timer('Process Time');
656: edw_log.put_line(' ');
657: end;
658:
659: /* Pushing Week */
660: begin

Line 661: edw_log.put_line('Pushing Week');

657: end;
658:
659: /* Pushing Week */
660: begin
661: edw_log.put_line('Pushing Week');
662: fii_util.start_timer;
663: l_week:=fnd_message.get_string('FII', 'FII_AR_WEEK');
664: loop
665: insert into edw_time_week_lstg

Line 712: edw_log.put_line(' ');

708: end loop;
709: commit;
710: fii_util.stop_timer;
711: fii_util.print_timer('Process Time');
712: edw_log.put_line(' ');
713: end;
714:
715: /* Pushing 445 Period */
716: begin

Line 717: edw_log.put_line('Pushing 445 Period');

713: end;
714:
715: /* Pushing 445 Period */
716: begin
717: edw_log.put_line('Pushing 445 Period');
718: fii_util.start_timer;
719: l_period:=fnd_message.get_string('FII', 'FII_AR_PERIOD');
720: loop
721: INSERT INTO edw_time_period_445_lstg

Line 770: edw_log.put_line(' ');

766: end loop;
767: commit;
768: fii_util.stop_timer;
769: fii_util.print_timer('Process Time');
770: edw_log.put_line(' ');
771: end;
772:
773: /* Pushing Half Month */
774: begin

Line 775: edw_log.put_line('Pushing Half Month');

771: end;
772:
773: /* Pushing Half Month */
774: begin
775: edw_log.put_line('Pushing Half Month');
776: fii_util.start_timer;
777: l_first_half:=fnd_message.get_string('FII', 'FII_AR_FIRST_HALF');
778: l_second_half:=fnd_message.get_string('FII', 'FII_AR_SECOND_HALF');
779: loop

Line 862: edw_log.put_line(' ');

858: end loop;
859: commit;
860: fii_util.stop_timer;
861: fii_util.print_timer('Process Time');
862: edw_log.put_line(' ');
863: end;
864:
865: /* for Status Viewer to verify the pushed record number */
866: rows_inserted:=l_row_cday;

Line 868: edw_log.put_line(' ');

864:
865: /* for Status Viewer to verify the pushed record number */
866: rows_inserted:=l_row_cday;
867:
868: edw_log.put_line(' ');
869: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
870: edw_log.put_line(to_char(l_row_day)||' records has been pushed to Day');
871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');
872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');

Line 869: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');

865: /* for Status Viewer to verify the pushed record number */
866: rows_inserted:=l_row_cday;
867:
868: edw_log.put_line(' ');
869: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
870: edw_log.put_line(to_char(l_row_day)||' records has been pushed to Day');
871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');
872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');
873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');

Line 870: edw_log.put_line(to_char(l_row_day)||' records has been pushed to Day');

866: rows_inserted:=l_row_cday;
867:
868: edw_log.put_line(' ');
869: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
870: edw_log.put_line(to_char(l_row_day)||' records has been pushed to Day');
871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');
872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');
873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');
874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');

Line 871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');

867:
868: edw_log.put_line(' ');
869: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
870: edw_log.put_line(to_char(l_row_day)||' records has been pushed to Day');
871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');
872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');
873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');
874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');
875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');

Line 872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');

868: edw_log.put_line(' ');
869: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
870: edw_log.put_line(to_char(l_row_day)||' records has been pushed to Day');
871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');
872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');
873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');
874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');
875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');
876: edw_log.put_line(to_char(l_row_week)||' records has been pushed to Week');

Line 873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');

869: edw_log.put_line(to_char(l_row_cday)||' records has been pushed to Calendar Day');
870: edw_log.put_line(to_char(l_row_day)||' records has been pushed to Day');
871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');
872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');
873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');
874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');
875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');
876: edw_log.put_line(to_char(l_row_week)||' records has been pushed to Week');
877: edw_log.put_line(to_char(l_row_445)||' records has been pushed to Period 445');

Line 874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');

870: edw_log.put_line(to_char(l_row_day)||' records has been pushed to Day');
871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');
872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');
873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');
874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');
875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');
876: edw_log.put_line(to_char(l_row_week)||' records has been pushed to Week');
877: edw_log.put_line(to_char(l_row_445)||' records has been pushed to Period 445');
878: edw_log.put_line(' ');

Line 875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');

871: edw_log.put_line(to_char(l_row_hmth)||' records has been pushed to Half Month');
872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');
873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');
874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');
875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');
876: edw_log.put_line(to_char(l_row_week)||' records has been pushed to Week');
877: edw_log.put_line(to_char(l_row_445)||' records has been pushed to Period 445');
878: edw_log.put_line(' ');
879: end;

Line 876: edw_log.put_line(to_char(l_row_week)||' records has been pushed to Week');

872: edw_log.put_line(to_char(l_row_mth)||' records has been pushed to Month');
873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');
874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');
875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');
876: edw_log.put_line(to_char(l_row_week)||' records has been pushed to Week');
877: edw_log.put_line(to_char(l_row_445)||' records has been pushed to Period 445');
878: edw_log.put_line(' ');
879: end;
880:

Line 877: edw_log.put_line(to_char(l_row_445)||' records has been pushed to Period 445');

873: edw_log.put_line(to_char(l_row_qtr)||' records has been pushed to Quarter');
874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');
875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');
876: edw_log.put_line(to_char(l_row_week)||' records has been pushed to Week');
877: edw_log.put_line(to_char(l_row_445)||' records has been pushed to Period 445');
878: edw_log.put_line(' ');
879: end;
880:
881: END FII_POPULATE_TIME;

Line 878: edw_log.put_line(' ');

874: edw_log.put_line(to_char(l_row_hyr)||' records has been pushed to Half Year');
875: edw_log.put_line(to_char(l_row_year)||' records has been pushed to Year');
876: edw_log.put_line(to_char(l_row_week)||' records has been pushed to Week');
877: edw_log.put_line(to_char(l_row_445)||' records has been pushed to Period 445');
878: edw_log.put_line(' ');
879: end;
880:
881: END FII_POPULATE_TIME;