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_PA_COST_F_C dependencies on EDW_LOG

Line 110: edw_log.put_line('Number of rows in stg'||rows2 );

106: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
107: select count(*) into rows2 from FII_PA_COST_FSTG;
108:
109: if g_debug_flag = 'Y' then
110: edw_log.put_line('Number of rows in stg'||rows2 );
111: edw_log.put_line(' ');
112: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
113: edw_log.put_line('g_retcode is '||g_retcode);
114: edw_log.put_line('g_missing_rates is '||g_missing_rates);

Line 111: edw_log.put_line(' ');

107: select count(*) into rows2 from FII_PA_COST_FSTG;
108:
109: if g_debug_flag = 'Y' then
110: edw_log.put_line('Number of rows in stg'||rows2 );
111: edw_log.put_line(' ');
112: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
113: edw_log.put_line('g_retcode is '||g_retcode);
114: edw_log.put_line('g_missing_rates is '||g_missing_rates);
115: end if;

Line 112: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');

108:
109: if g_debug_flag = 'Y' then
110: edw_log.put_line('Number of rows in stg'||rows2 );
111: edw_log.put_line(' ');
112: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
113: edw_log.put_line('g_retcode is '||g_retcode);
114: edw_log.put_line('g_missing_rates is '||g_missing_rates);
115: end if;
116:

Line 113: edw_log.put_line('g_retcode is '||g_retcode);

109: if g_debug_flag = 'Y' then
110: edw_log.put_line('Number of rows in stg'||rows2 );
111: edw_log.put_line(' ');
112: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
113: edw_log.put_line('g_retcode is '||g_retcode);
114: edw_log.put_line('g_missing_rates is '||g_missing_rates);
115: end if;
116:
117: END;

Line 114: edw_log.put_line('g_missing_rates is '||g_missing_rates);

110: edw_log.put_line('Number of rows in stg'||rows2 );
111: edw_log.put_line(' ');
112: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
113: edw_log.put_line('g_retcode is '||g_retcode);
114: edw_log.put_line('g_missing_rates is '||g_missing_rates);
115: end if;
116:
117: END;
118:

Line 338: edw_log.put_line('g_row_count is');

334: fii_flex_mapping.free_mem_all;
335:
336: -- return
337: if g_debug_flag = 'Y' then
338: edw_log.put_line('g_row_count is');
339: edw_log.put_line(TO_CHAR(sql%rowcount));
340: end if;
341:
342: RETURN(sql%rowcount);

Line 339: edw_log.put_line(TO_CHAR(sql%rowcount));

335:
336: -- return
337: if g_debug_flag = 'Y' then
338: edw_log.put_line('g_row_count is');
339: edw_log.put_line(TO_CHAR(sql%rowcount));
340: end if;
341:
342: RETURN(sql%rowcount);
343:

Line 520: edw_log.put_line(' ');

516: line_type = 'R'
517: AND program_update_date BETWEEN g_push_date_range1 and g_push_date_range2;
518:
519: if g_debug_flag = 'Y' then
520: edw_log.put_line(' ');
521: edw_log.put_line('Inserted ' || nvl(SQL%ROWCOUNT,0) || ' records into primary key table' );
522: end if;
523:
524: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN

Line 521: edw_log.put_line('Inserted ' || nvl(SQL%ROWCOUNT,0) || ' records into primary key table' );

517: AND program_update_date BETWEEN g_push_date_range1 and g_push_date_range2;
518:
519: if g_debug_flag = 'Y' then
520: edw_log.put_line(' ');
521: edw_log.put_line('Inserted ' || nvl(SQL%ROWCOUNT,0) || ' records into primary key table' );
522: end if;
523:
524: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
525:

Line 530: edw_log.put_line('Analyzed primary key table' );

526: l_stmt := 'ANALYZE TABLE ' || l_fii_schema || '.FII_PA_COST_PK COMPUTE STATISTICS';
527: EXECUTE IMMEDIATE l_stmt;
528:
529: if g_debug_flag = 'Y' then
530: edw_log.put_line('Analyzed primary key table' );
531: end if;
532:
533: END IF;
534:

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

598: l_date1 := g_push_date_range1;
599: l_date2 := g_push_date_range2;
600:
601: if g_debug_flag = 'Y' then
602: edw_log.put_line( 'The collection range is from '||
603: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
604: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
605: edw_log.put_line(' ');
606: end if;

Line 605: edw_log.put_line(' ');

601: if g_debug_flag = 'Y' then
602: edw_log.put_line( 'The collection range is from '||
603: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
604: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
605: edw_log.put_line(' ');
606: end if;
607:
608: -- --------------------------------------------------------
609: -- 1. Clean up any records left from previous process in

Line 613: edw_log.put_line(' ');

609: -- 1. Clean up any records left from previous process in
610: -- the local staging table.
611: -- --------------------------------------------------------
612: if g_debug_flag = 'Y' then
613: edw_log.put_line(' ');
614: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
615: fii_util.start_timer;
616: end if;
617:

Line 614: edw_log.put_line('Cleaning up unprocessed records left in local staging table');

610: -- the local staging table.
611: -- --------------------------------------------------------
612: if g_debug_flag = 'Y' then
613: edw_log.put_line(' ');
614: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
615: fii_util.start_timer;
616: end if;
617:
618: -- note that TRUNCATE statement does implicit commit;

Line 628: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );

624: END IF;
625: select count(*) into rows1 from FII_PA_COST_FSTG;
626:
627: if g_debug_flag = 'Y' then
628: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
629: fii_util.stop_timer;
630: fii_util.print_timer('Process Time');
631: end if;
632:

Line 650: edw_log.put_line('Number of rows in pk after identify change'||rows1 );

646: end if;
647: select count(*) into rows1 from FII_PA_COST_pk;
648:
649: if g_debug_flag = 'Y' then
650: edw_log.put_line('Number of rows in pk after identify change'||rows1 );
651: fii_util.stop_timer;
652: fii_util.print_timer('Process Time');
653: end if;
654:

Line 660: edw_log.put_line(' ');

656: -- 3. Pushing data to local staging table
657: -- --------------------------------------------------------
658:
659: if g_debug_flag = 'Y' then
660: edw_log.put_line(' ');
661: edw_log.put_line('Pushing data to local staging table');
662: fii_util.start_timer;
663: end if;
664:

Line 661: edw_log.put_line('Pushing data to local staging table');

657: -- --------------------------------------------------------
658:
659: if g_debug_flag = 'Y' then
660: edw_log.put_line(' ');
661: edw_log.put_line('Pushing data to local staging table');
662: fii_util.start_timer;
663: end if;
664:
665: g_row_count := PUSH_TO_LOCAL;

Line 677: edw_log.put_line('Inserted '||nvl(g_row_count,0)|| ' rows into the local staging table');

673: RAISE L_push_local_failure;
674: END IF;
675:
676: if g_debug_flag = 'Y' then
677: edw_log.put_line('Inserted '||nvl(g_row_count,0)|| ' rows into the local staging table');
678: edw_log.put_line(' ');
679: end if;
680:
681: -- --------------------------------------------------------

Line 678: edw_log.put_line(' ');

674: END IF;
675:
676: if g_debug_flag = 'Y' then
677: edw_log.put_line('Inserted '||nvl(g_row_count,0)|| ' rows into the local staging table');
678: edw_log.put_line(' ');
679: end if;
680:
681: -- --------------------------------------------------------
682: -- 4. Clean up any records left from previous process in

Line 687: edw_log.put_line(' ');

683: -- the FII_PA_COST_PK table
684: -- --------------------------------------------------------
685:
686: if g_debug_flag = 'Y' then
687: edw_log.put_line(' ');
688: edw_log.put_line('Cleaning up unprocessed records left in primary key table');
689: end if;
690:
691: -- note that TRUNCATE statement does implicit commit;

Line 688: edw_log.put_line('Cleaning up unprocessed records left in primary key table');

684: -- --------------------------------------------------------
685:
686: if g_debug_flag = 'Y' then
687: edw_log.put_line(' ');
688: edw_log.put_line('Cleaning up unprocessed records left in primary key table');
689: end if;
690:
691: -- note that TRUNCATE statement does implicit commit;
692:

Line 697: -- edw_log.put_line('rows in tmp_pk after truncating'||to_char(rows1));

693: IF NOT TRUNCATE_PK THEN
694: RAISE l_truncate_tmp_pk_failure;
695: -- select count(*) into rows1 from FII_PA_COST_PK;
696: -- if g_debug_flag = 'Y' then
697: -- edw_log.put_line('rows in tmp_pk after truncating'||to_char(rows1));
698: -- end if;
699: END IF;
700: -- select count(*) into rows1 from FII_PA_COST_PK;
701: -- if g_debug_flag = 'Y' then

Line 702: -- edw_log.put_line('rows in tmp_pk after truncating'||to_char(rows1));

698: -- end if;
699: END IF;
700: -- select count(*) into rows1 from FII_PA_COST_PK;
701: -- if g_debug_flag = 'Y' then
702: -- edw_log.put_line('rows in tmp_pk after truncating'||to_char(rows1));
703: -- end if;
704:
705:
706: -- ------------------------------------------------------------------------------------------------

Line 743: edw_log.put_line(' ');

739: -- and clean up local staging
740: -- -----------------------------------------------
741:
742: if g_debug_flag = 'Y' then
743: edw_log.put_line(' ');
744: edw_log.put_line('g_row_count in LOCAL_SAME_AS_REMOTE'|| g_row_count);
745: edw_log.put_line('Moving data from local staging table to remote staging table');
746: fii_util.start_timer;
747: end if;

Line 744: edw_log.put_line('g_row_count in LOCAL_SAME_AS_REMOTE'|| g_row_count);

740: -- -----------------------------------------------
741:
742: if g_debug_flag = 'Y' then
743: edw_log.put_line(' ');
744: edw_log.put_line('g_row_count in LOCAL_SAME_AS_REMOTE'|| g_row_count);
745: edw_log.put_line('Moving data from local staging table to remote staging table');
746: fii_util.start_timer;
747: end if;
748:

Line 745: edw_log.put_line('Moving data from local staging table to remote staging table');

741:
742: if g_debug_flag = 'Y' then
743: edw_log.put_line(' ');
744: edw_log.put_line('g_row_count in LOCAL_SAME_AS_REMOTE'|| g_row_count);
745: edw_log.put_line('Moving data from local staging table to remote staging table');
746: fii_util.start_timer;
747: end if;
748:
749: g_row_count := PUSH_REMOTE;

Line 759: edw_log.put_line(' ');

755:
756: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
757:
758: if g_debug_flag = 'Y' then
759: edw_log.put_line(' ');
760: edw_log.put_line('Cleaning local staging table');
761: fii_util.start_timer;
762: end if;
763:

Line 760: edw_log.put_line('Cleaning local staging table');

756: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
757:
758: if g_debug_flag = 'Y' then
759: edw_log.put_line(' ');
760: edw_log.put_line('Cleaning local staging table');
761: fii_util.start_timer;
762: end if;
763:
764: TRUNCATE_STG;

Line 779: edw_log.put_line(' ');

775: -- records status 'LOCAL READY' to 'READY'
776: -- -----------------------------------------------
777:
778: if g_debug_flag = 'Y' then
779: edw_log.put_line(' ');
780: edw_log.put_line('Marking records in staging table with READY status');
781: fii_util.start_timer;
782: end if;
783:

Line 780: edw_log.put_line('Marking records in staging table with READY status');

776: -- -----------------------------------------------
777:
778: if g_debug_flag = 'Y' then
779: edw_log.put_line(' ');
780: edw_log.put_line('Marking records in staging table with READY status');
781: fii_util.start_timer;
782: end if;
783:
784: g_row_count := SET_STATUS_READY;

Line 789: edw_log.put_line('g_row_count from SET_STATUS_READY'|| g_row_count);

785:
786: if g_debug_flag = 'Y' then
787: fii_util.stop_timer;
788: fii_util.print_timer('Process time');
789: edw_log.put_line('g_row_count from SET_STATUS_READY'|| g_row_count);
790: end if;
791:
792: DELETE_STG;
793: IF (g_row_count = -1) THEN RAISE l_set_status_failure; END IF;

Line 808: edw_log.put_line(' ');

804: -- Clean up any records in the FII_PA_COST_PK table
805: -- --------------------------------------------------------
806:
807: if g_debug_flag = 'Y' then
808: edw_log.put_line(' ');
809: edw_log.put_line('Cleaning up primary key table');
810: end if;
811:
812: /* IF NOT TRUNCATE_PK THEN

Line 809: edw_log.put_line('Cleaning up primary key table');

805: -- --------------------------------------------------------
806:
807: if g_debug_flag = 'Y' then
808: edw_log.put_line(' ');
809: edw_log.put_line('Cleaning up primary key table');
810: end if;
811:
812: /* IF NOT TRUNCATE_PK THEN
813: -- Normally this error will not occur - Collection concurrent

Line 826: edw_log.put_line(' ');

822: END IF;
823: */
824:
825: if g_debug_flag = 'Y' then
826: edw_log.put_line(' ');
827: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
828: ' rows into the staging table');
829: edw_log.put_line(' ');
830: end if;

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

823: */
824:
825: if g_debug_flag = 'Y' then
826: edw_log.put_line(' ');
827: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
828: ' rows into the staging table');
829: edw_log.put_line(' ');
830: end if;
831:

Line 829: edw_log.put_line(' ');

825: if g_debug_flag = 'Y' then
826: edw_log.put_line(' ');
827: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
828: ' rows into the staging table');
829: edw_log.put_line(' ');
830: end if;
831:
832: Retcode := g_retcode;
833: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);

Line 837: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');

833: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2);
834: if (g_missing_rates >0) then
835:
836: if g_debug_flag = 'Y' then
837: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
838: end if;
839:
840: end if;
841:

Line 849: edw_log.put_line(' ');

845: Errbuf:=g_errbuf;
846: Retcode:=g_retcode;
847: l_exception_msg := Retcode || ':' || Errbuf;
848: if g_debug_flag = 'Y' then
849: edw_log.put_line(' ');
850: edw_log.put_line('ERROR: Identifying changed records have failed');
851: edw_log.put_line(' ');
852: end if;
853: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

Line 850: edw_log.put_line('ERROR: Identifying changed records have failed');

846: Retcode:=g_retcode;
847: l_exception_msg := Retcode || ':' || Errbuf;
848: if g_debug_flag = 'Y' then
849: edw_log.put_line(' ');
850: edw_log.put_line('ERROR: Identifying changed records have failed');
851: edw_log.put_line(' ');
852: end if;
853: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
854: WHEN L_PUSH_LOCAL_FAILURE THEN

Line 851: edw_log.put_line(' ');

847: l_exception_msg := Retcode || ':' || Errbuf;
848: if g_debug_flag = 'Y' then
849: edw_log.put_line(' ');
850: edw_log.put_line('ERROR: Identifying changed records have failed');
851: edw_log.put_line(' ');
852: end if;
853: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
854: WHEN L_PUSH_LOCAL_FAILURE THEN
855: rollback;

Line 860: edw_log.put_line(' ');

856: Errbuf:=g_errbuf;
857: Retcode:=g_retcode;
858: l_exception_msg := Retcode || ':' || Errbuf;
859: if g_debug_flag = 'Y' then
860: edw_log.put_line(' ');
861: edw_log.put_line('ERROR: Inserting into local staging have failed');
862: edw_log.put_line(' ');
863: end if;
864: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

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

857: Retcode:=g_retcode;
858: l_exception_msg := Retcode || ':' || Errbuf;
859: if g_debug_flag = 'Y' then
860: edw_log.put_line(' ');
861: edw_log.put_line('ERROR: Inserting into local staging have failed');
862: edw_log.put_line(' ');
863: end if;
864: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
865: WHEN L_PUSH_REMOTE_FAILURE THEN

Line 862: edw_log.put_line(' ');

858: l_exception_msg := Retcode || ':' || Errbuf;
859: if g_debug_flag = 'Y' then
860: edw_log.put_line(' ');
861: edw_log.put_line('ERROR: Inserting into local staging have failed');
862: edw_log.put_line(' ');
863: end if;
864: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
865: WHEN L_PUSH_REMOTE_FAILURE THEN
866: rollback;

Line 871: edw_log.put_line(' ');

867: Errbuf:=g_errbuf;
868: Retcode:=g_retcode;
869: l_exception_msg := Retcode || ':' || Errbuf;
870: if g_debug_flag = 'Y' then
871: edw_log.put_line(' ');
872: edw_log.put_line('ERROR: Data migration from local to remote staging have failed');
873: edw_log.put_line(' ');
874: end if;
875: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

Line 872: edw_log.put_line('ERROR: Data migration from local to remote staging have failed');

868: Retcode:=g_retcode;
869: l_exception_msg := Retcode || ':' || Errbuf;
870: if g_debug_flag = 'Y' then
871: edw_log.put_line(' ');
872: edw_log.put_line('ERROR: Data migration from local to remote staging have failed');
873: edw_log.put_line(' ');
874: end if;
875: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
876: WHEN L_SET_STATUS_FAILURE THEN

Line 873: edw_log.put_line(' ');

869: l_exception_msg := Retcode || ':' || Errbuf;
870: if g_debug_flag = 'Y' then
871: edw_log.put_line(' ');
872: edw_log.put_line('ERROR: Data migration from local to remote staging have failed');
873: edw_log.put_line(' ');
874: end if;
875: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
876: WHEN L_SET_STATUS_FAILURE THEN
877: rollback;

Line 882: edw_log.put_line(' ');

878: Errbuf:=g_errbuf;
879: Retcode:=g_retcode;
880: l_exception_msg := Retcode || ':' || Errbuf;
881: if g_debug_flag = 'Y' then
882: edw_log.put_line(' ');
883: edw_log.put_line('ERROR: Setting status to READY have failed');
884: edw_log.put_line(' ');
885: end if;
886: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);

Line 883: edw_log.put_line('ERROR: Setting status to READY have failed');

879: Retcode:=g_retcode;
880: l_exception_msg := Retcode || ':' || Errbuf;
881: if g_debug_flag = 'Y' then
882: edw_log.put_line(' ');
883: edw_log.put_line('ERROR: Setting status to READY have failed');
884: edw_log.put_line(' ');
885: end if;
886: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
887: WHEN L_TRUNCATE_TMP_PK_FAILURE THEN

Line 884: edw_log.put_line(' ');

880: l_exception_msg := Retcode || ':' || Errbuf;
881: if g_debug_flag = 'Y' then
882: edw_log.put_line(' ');
883: edw_log.put_line('ERROR: Setting status to READY have failed');
884: edw_log.put_line(' ');
885: end if;
886: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
887: WHEN L_TRUNCATE_TMP_PK_FAILURE THEN
888: rollback;

Line 893: edw_log.put_line('ERROR: Clean-up of primary key table failed');

889: Errbuf:=g_errbuf;
890: Retcode:=g_retcode;
891: l_exception_msg := Retcode || ':' || Errbuf;
892: if g_debug_flag = 'Y' then
893: edw_log.put_line('ERROR: Clean-up of primary key table failed');
894: edw_log.put_line(' ');
895: end if;
896: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
897: WHEN OTHERS THEN

Line 894: edw_log.put_line(' ');

890: Retcode:=g_retcode;
891: l_exception_msg := Retcode || ':' || Errbuf;
892: if g_debug_flag = 'Y' then
893: edw_log.put_line('ERROR: Clean-up of primary key table failed');
894: edw_log.put_line(' ');
895: end if;
896: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, g_push_date_range1, g_push_date_range2);
897: WHEN OTHERS THEN
898: rollback;