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

Line 30: edw_log.put_line(' ');

26: IF (FND_INSTALLATION.GET_APP_INFO('FII', l_status, l_industry, l_fii_schema)) THEN
27: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.'||table_name;
28: EXECUTE IMMEDIATE l_stmt;
29: END IF;
30: edw_log.put_line(' ');
31: edw_log.put_line('Truncating '|| table_name||' table');
32:
33: END;
34:

Line 31: edw_log.put_line('Truncating '|| table_name||' table');

27: l_stmt := 'TRUNCATE TABLE ' || l_fii_schema ||'.'||table_name;
28: EXECUTE IMMEDIATE l_stmt;
29: END IF;
30: edw_log.put_line(' ');
31: edw_log.put_line('Truncating '|| table_name||' table');
32:
33: END;
34:
35: -----------------------------------------------------------

Line 85: edw_log.put_line(' ');

81: g_missing_rates := 1;
82: END IF;
83: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
84:
85: edw_log.put_line(' ');
86: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
87: edw_log.put_line('g_retcode is '||g_retcode);
88: END;
89:

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

82: END IF;
83: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
84:
85: edw_log.put_line(' ');
86: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
87: edw_log.put_line('g_retcode is '||g_retcode);
88: END;
89:
90: --------------------------------------------------

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

83: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
84:
85: edw_log.put_line(' ');
86: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
87: edw_log.put_line('g_retcode is '||g_retcode);
88: END;
89:
90: --------------------------------------------------
91: --FUNCTION LOCAL_SAME_AS_REMOTE

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

310: 'LOCAL READY'),
311: FROM_CURRENCY
312: from FII_AP_INV_ON_HOLD_FCV;
313: fii_flex_mapping.free_mem_all;
314: edw_log.put_line('g_row_count is');
315: edw_log.put_line(TO_CHAR(sql%rowcount));
316: RETURN(sql%rowcount);
317:
318: EXCEPTION

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

311: FROM_CURRENCY
312: from FII_AP_INV_ON_HOLD_FCV;
313: fii_flex_mapping.free_mem_all;
314: edw_log.put_line('g_row_count is');
315: edw_log.put_line(TO_CHAR(sql%rowcount));
316: RETURN(sql%rowcount);
317:
318: EXCEPTION
319: WHEN OTHERS THEN

Line 554: edw_log.debug_line('');

550:
551: p_count := sql%rowcount;
552:
553: --** Added for iExpense Enhancement,12-DEC-02
554: edw_log.debug_line('');
555: edw_log.debug_line(l_stmt);
556: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
557: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
558: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,

Line 555: edw_log.debug_line(l_stmt);

551: p_count := sql%rowcount;
552:
553: --** Added for iExpense Enhancement,12-DEC-02
554: edw_log.debug_line('');
555: edw_log.debug_line(l_stmt);
556: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
557: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
558: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
559: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;

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

650: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
651: FII_AP_INV_ON_HOLD_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
652: l_date1 := g_push_date_range1;
653: l_date2 := g_push_date_range2;
654: edw_log.put_line( 'The collection range is from '||
655: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
656: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
657: edw_log.put_line(' ');
658:

Line 657: edw_log.put_line(' ');

653: l_date2 := g_push_date_range2;
654: edw_log.put_line( 'The collection range is from '||
655: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
656: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
657: edw_log.put_line(' ');
658:
659: --bug#3947925
660: --Check whether missing rates table has data or not. If not then copy missing rates
661: --from temp table to the missing rates table. This is required to avoid full refresh

Line 709: edw_log.put_line(' ');

705: -- --------------------------------------------------------
706: -- 1. Clean up any records left from previous process in
707: -- the local staging table.
708: -- --------------------------------------------------------
709: edw_log.put_line(' ');
710: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
711: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
712: TRUNCATE_TABLE('FII_AP_INV_ON_HOLD_FSTG');
713: ELSE

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

706: -- 1. Clean up any records left from previous process in
707: -- the local staging table.
708: -- --------------------------------------------------------
709: edw_log.put_line(' ');
710: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
711: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
712: TRUNCATE_TABLE('FII_AP_INV_ON_HOLD_FSTG');
713: ELSE
714: DELETE_STG;

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

713: ELSE
714: DELETE_STG;
715: END IF;
716: select count(*) into rows1 from FII_AP_INV_ON_HOLD_FSTG;
717: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
718: -- --------------------------------------------------------
719: -- 2. Identify Changed AP Invoice Holds record
720: -- --------------------------------------------------------
721: edw_log.put_line(' ');

Line 721: edw_log.put_line(' ');

717: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
718: -- --------------------------------------------------------
719: -- 2. Identify Changed AP Invoice Holds record
720: -- --------------------------------------------------------
721: edw_log.put_line(' ');
722: edw_log.put_line('Identifying changed AP Invoice Holds record');
723: fii_util.start_timer;
724: IDENTIFY_CHANGE(l_row_count);
725: fii_util.stop_timer;

Line 722: edw_log.put_line('Identifying changed AP Invoice Holds record');

718: -- --------------------------------------------------------
719: -- 2. Identify Changed AP Invoice Holds record
720: -- --------------------------------------------------------
721: edw_log.put_line(' ');
722: edw_log.put_line('Identifying changed AP Invoice Holds record');
723: fii_util.start_timer;
724: IDENTIFY_CHANGE(l_row_count);
725: fii_util.stop_timer;
726: fii_util.print_timer('Identified '||l_row_count||' changed records');

Line 733: edw_log.put_line(' ');

729: -- --------------------------------------------------------
730: -- 3. Pushing data to local staging table
731: -- --------------------------------------------------------
732:
733: edw_log.put_line(' ');
734: edw_log.put_line('Pushing data');
735: fii_util.start_timer;
736: g_row_count := PUSH_TO_LOCAL;
737: fii_util.stop_timer;

Line 734: edw_log.put_line('Pushing data');

730: -- 3. Pushing data to local staging table
731: -- --------------------------------------------------------
732:
733: edw_log.put_line(' ');
734: edw_log.put_line('Pushing data');
735: fii_util.start_timer;
736: g_row_count := PUSH_TO_LOCAL;
737: fii_util.stop_timer;
738: fii_util.print_timer('Process Time');

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

740: IF (g_row_count = -1) THEN
741: RAISE L_push_local_failure;
742: END IF;
743:
744: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
745: ' rows into the local staging table');
746: edw_log.put_line(' ');
747:
748: -- --------------------------------------------------------------------

Line 746: edw_log.put_line(' ');

742: END IF;
743:
744: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
745: ' rows into the local staging table');
746: edw_log.put_line(' ');
747:
748: -- --------------------------------------------------------------------
749: -- 4. Delete records generated from previous session from tmp_pk table
750: -- --------------------------------------------------------------------

Line 753: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );

749: -- 4. Delete records generated from previous session from tmp_pk table
750: -- --------------------------------------------------------------------
751: TRUNCATE_TABLE('fii_ap_tmp_invh_pk');
752: select count(*) into rows from fii_ap_tmp_invh_pk ;
753: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );
754: -- ------------------------------------------------------------------------------------------------
755: -- 4A. Insert missing rates from local fstg into tmp_pk table printing data to file
756: -- ------------------------------------------------------------------------------------------------
757:

Line 863: edw_log.put_line(' ');

859: -- We move data from local to remote staging table
860: -- and clean up local staging
861: -- -----------------------------------------------
862:
863: edw_log.put_line(' ');
864: edw_log.put_line('Moving data from local staging table to remote staging table');
865: fii_util.start_timer;
866: g_row_count := PUSH_REMOTE;
867: fii_util.stop_timer;

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

860: -- and clean up local staging
861: -- -----------------------------------------------
862:
863: edw_log.put_line(' ');
864: edw_log.put_line('Moving data from local staging table to remote staging table');
865: fii_util.start_timer;
866: g_row_count := PUSH_REMOTE;
867: fii_util.stop_timer;
868: fii_util.print_timer('Duration');

Line 872: edw_log.put_line(' ');

868: fii_util.print_timer('Duration');
869:
870: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
871:
872: edw_log.put_line(' ');
873: edw_log.put_line('Cleaning local staging table');
874:
875: fii_util.start_timer;
876: TRUNCATE_TABLE('FII_AP_INV_ON_HOLD_FSTG');

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

869:
870: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
871:
872: edw_log.put_line(' ');
873: edw_log.put_line('Cleaning local staging table');
874:
875: fii_util.start_timer;
876: TRUNCATE_TABLE('FII_AP_INV_ON_HOLD_FSTG');
877: fii_util.stop_timer;

Line 887: edw_log.put_line(' ');

883: -- as the source OLTP. We set the status of all our
884: -- records status 'LOCAL READY' to 'READY'
885: -- -----------------------------------------------
886:
887: edw_log.put_line(' ');
888: edw_log.put_line('Marking records in staging table with READY status');
889:
890: fii_util.start_timer;
891: g_row_count := SET_STATUS_READY;

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

884: -- records status 'LOCAL READY' to 'READY'
885: -- -----------------------------------------------
886:
887: edw_log.put_line(' ');
888: edw_log.put_line('Marking records in staging table with READY status');
889:
890: fii_util.start_timer;
891: g_row_count := SET_STATUS_READY;
892: fii_util.stop_timer;

Line 918: edw_log.put_line(' ');

914: -- Successful. Commit and call
915: -- wrapup to commit and insert messages into logs
916: -- -----------------------------------------------
917: -- COMMIT;
918: edw_log.put_line(' ');
919: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
920: ' rows into the staging table');
921: edw_log.put_line(' ');
922: Retcode := g_retcode;

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

915: -- wrapup to commit and insert messages into logs
916: -- -----------------------------------------------
917: -- COMMIT;
918: edw_log.put_line(' ');
919: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
920: ' rows into the staging table');
921: edw_log.put_line(' ');
922: Retcode := g_retcode;
923: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);

Line 921: edw_log.put_line(' ');

917: -- COMMIT;
918: edw_log.put_line(' ');
919: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
920: ' rows into the staging table');
921: edw_log.put_line(' ');
922: Retcode := g_retcode;
923: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
924: if (g_missing_rates >0) then
925: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');

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

921: edw_log.put_line(' ');
922: Retcode := g_retcode;
923: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
924: if (g_missing_rates >0) then
925: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
926: end if;
927: commit;
928: --bug#3947925
929: --Program is on the verge of completing successfully,so clean up

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

938: WHEN L_IDEN_CHANGE_FAILURE THEN
939: Errbuf:=g_errbuf;
940: Retcode:=g_retcode;
941: l_exception_msg := Retcode || ':' || Errbuf;
942: edw_log.put_line('Identifying changed records have Failed');
943: rollback;
944: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
945: /* Set the completion status to error. bug#3207823 */
946: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

948: WHEN L_PUSH_LOCAL_FAILURE THEN
949: Errbuf:=g_errbuf;
950: Retcode:=g_retcode;
951: l_exception_msg := Retcode || ':' || Errbuf;
952: edw_log.put_line('Inserting into local staging have failed');
953: rollback;
954: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
955: /* Set the completion status to error. bug#3207823 */
956: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

958: WHEN L_PUSH_REMOTE_FAILURE THEN
959: Errbuf:=g_errbuf;
960: Retcode:=g_retcode;
961: l_exception_msg := Retcode || ':' || Errbuf;
962: edw_log.put_line('Data migration from local to remote staging have failed');
963: rollback;
964: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
965: /* Set the completion status to error. bug#3207823 */
966: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

968: WHEN L_SET_STATUS_FAILURE THEN
969: Errbuf:=g_errbuf;
970: Retcode:=g_retcode;
971: l_exception_msg := Retcode || ':' || Errbuf;
972: edw_log.put_line('Setting status to READY have failed');
973: rollback;
974: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
975: /* Set the completion status to error. bug#3207823 */
976: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);