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

Line 29: edw_log.put_line(' ');

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

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

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

Line 82: edw_log.put_line(' ');

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

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

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

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

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

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

400: round((CHECK_AMT_B*GLOBAL_CURRENCY_RATE)/l_mau)*l_mau CHECK_AMT_G,
401: CHECK_NUMBER
402: from FII_AP_INV_PAYMTS_FCV;
403: fii_flex_mapping.free_mem_all;
404: edw_log.put_line('g_row_count is');
405: edw_log.put_line(TO_CHAR(sql%rowcount));
406: RETURN(sql%rowcount);
407:
408: EXCEPTION

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

401: CHECK_NUMBER
402: from FII_AP_INV_PAYMTS_FCV;
403: fii_flex_mapping.free_mem_all;
404: edw_log.put_line('g_row_count is');
405: edw_log.put_line(TO_CHAR(sql%rowcount));
406: RETURN(sql%rowcount);
407:
408: EXCEPTION
409: WHEN OTHERS THEN

Line 724: edw_log.debug_line('');

720: TABNAME => 'FII_TMP_PK') ;
721: END IF; */
722:
723: --** Added for iExpense Enhancement,12-DEC-02
724: edw_log.debug_line('');
725: edw_log.debug_line(l_stmt);
726: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
727: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
728: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;

Line 725: edw_log.debug_line(l_stmt);

721: END IF; */
722:
723: --** Added for iExpense Enhancement,12-DEC-02
724: edw_log.debug_line('');
725: edw_log.debug_line(l_stmt);
726: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
727: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
728: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;
729: --**

Line 732: edw_log.put_line( 'NO OF ROWS CHANGED '||to_char(p_count));

728: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;
729: --**
730:
731: p_count := sql%rowcount;
732: edw_log.put_line( 'NO OF ROWS CHANGED '||to_char(p_count));
733:
734: EXCEPTION
735: WHEN OTHERS THEN
736: g_errbuf:=sqlerrm;

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

838: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
839: FII_AP_INV_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
840: l_date1 := g_push_date_range1;
841: l_date2 := g_push_date_range2;
842: edw_log.put_line( 'The collection range is from '||
843: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
844: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
845: edw_log.put_line(' ');
846:

Line 845: edw_log.put_line(' ');

841: l_date2 := g_push_date_range2;
842: edw_log.put_line( 'The collection range is from '||
843: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
844: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
845: edw_log.put_line(' ');
846:
847: --bug#3947925
848: --Check whether missing rates table has data or not. If not then copy missing rates
849: --from temp table to the missing rates table. This is required to avoid full refresh

Line 896: edw_log.put_line(' ');

892: -- --------------------------------------------------------
893: -- 1. Clean up any records left from previous process in
894: -- the local staging table.
895: -- --------------------------------------------------------
896: edw_log.put_line(' ');
897: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
898: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
899: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
900: ELSE

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

893: -- 1. Clean up any records left from previous process in
894: -- the local staging table.
895: -- --------------------------------------------------------
896: edw_log.put_line(' ');
897: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
898: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
899: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
900: ELSE
901: DELETE_STG;

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

900: ELSE
901: DELETE_STG;
902: END IF;
903: select count(*) into rows1 from FII_AP_INV_PAYMTS_FSTG;
904: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
905: -- --------------------------------------------------------
906: -- 2. Identify Changed AP Invoice Payments record
907: -- --------------------------------------------------------
908: edw_log.put_line(' ');

Line 908: edw_log.put_line(' ');

904: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
905: -- --------------------------------------------------------
906: -- 2. Identify Changed AP Invoice Payments record
907: -- --------------------------------------------------------
908: edw_log.put_line(' ');
909: edw_log.put_line('Identifying changed AP Invoice Payments record');
910: fii_util.start_timer;
911: IDENTIFY_CHANGE(l_row_count);
912: fii_util.stop_timer;

Line 909: edw_log.put_line('Identifying changed AP Invoice Payments record');

905: -- --------------------------------------------------------
906: -- 2. Identify Changed AP Invoice Payments record
907: -- --------------------------------------------------------
908: edw_log.put_line(' ');
909: edw_log.put_line('Identifying changed AP Invoice Payments record');
910: fii_util.start_timer;
911: IDENTIFY_CHANGE(l_row_count);
912: fii_util.stop_timer;
913: fii_util.print_timer('Identified '||l_row_count||' changed records');

Line 919: edw_log.put_line(' ');

915: -- --------------------------------------------------------
916: -- 3. Pushing data to local staging table
917: -- --------------------------------------------------------
918:
919: edw_log.put_line(' ');
920: edw_log.put_line('Pushing data');
921: fii_util.start_timer;
922: g_row_count := PUSH_TO_LOCAL;
923: fii_util.stop_timer;

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

916: -- 3. Pushing data to local staging table
917: -- --------------------------------------------------------
918:
919: edw_log.put_line(' ');
920: edw_log.put_line('Pushing data');
921: fii_util.start_timer;
922: g_row_count := PUSH_TO_LOCAL;
923: fii_util.stop_timer;
924: fii_util.print_timer('Process Time');

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

926: IF (g_row_count = -1) THEN
927: RAISE L_push_local_failure;
928: END IF;
929:
930: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
931: ' rows into the local staging table');
932: edw_log.put_line(' ');
933:
934: -- --------------------------------------------------------

Line 932: edw_log.put_line(' ');

928: END IF;
929:
930: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
931: ' rows into the local staging table');
932: edw_log.put_line(' ');
933:
934: -- --------------------------------------------------------
935: -- 4. Delete all temp table records
936: -- --------------------------------------------------------

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

935: -- 4. Delete all temp table records
936: -- --------------------------------------------------------
937: TRUNCATE_TABLE('fii_ap_tmp_ipay_pk');
938: select count(*) into rows from fii_ap_tmp_ipay_pk ;
939: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );
940:
941: -- ------------------------------------------------------------------------------------------------
942: -- 4A. Insert missing rates from local fstg into tmp_pk table printing data to file
943: -- ------------------------------------------------------------------------------------------------

Line 1046: edw_log.put_line(' ');

1042: -- as the source OLTP, which is the typical case.
1043: -- We move data from local to remote staging table
1044: -- and clean up local staging
1045: -- -----------------------------------------------
1046: edw_log.put_line(' ');
1047: edw_log.put_line('Moving data from local staging table to remote staging table');
1048: fii_util.start_timer;
1049: g_row_count := PUSH_REMOTE;
1050: fii_util.stop_timer;

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

1043: -- We move data from local to remote staging table
1044: -- and clean up local staging
1045: -- -----------------------------------------------
1046: edw_log.put_line(' ');
1047: edw_log.put_line('Moving data from local staging table to remote staging table');
1048: fii_util.start_timer;
1049: g_row_count := PUSH_REMOTE;
1050: fii_util.stop_timer;
1051: fii_util.print_timer('Duration');

Line 1055: edw_log.put_line(' ');

1051: fii_util.print_timer('Duration');
1052:
1053: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1054:
1055: edw_log.put_line(' ');
1056: edw_log.put_line('Cleaning local staging table');
1057:
1058: fii_util.start_timer;
1059: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');

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

1052:
1053: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1054:
1055: edw_log.put_line(' ');
1056: edw_log.put_line('Cleaning local staging table');
1057:
1058: fii_util.start_timer;
1059: TRUNCATE_TABLE('FII_AP_INV_PAYMTS_FSTG');
1060: fii_util.stop_timer;

Line 1070: edw_log.put_line(' ');

1066: -- as the source OLTP. We set the status of all our
1067: -- records status 'LOCAL READY' to 'READY'
1068: -- -----------------------------------------------
1069:
1070: edw_log.put_line(' ');
1071: edw_log.put_line('Marking records in staging table with READY status');
1072:
1073: fii_util.start_timer;
1074: g_row_count := SET_STATUS_READY;

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

1067: -- records status 'LOCAL READY' to 'READY'
1068: -- -----------------------------------------------
1069:
1070: edw_log.put_line(' ');
1071: edw_log.put_line('Marking records in staging table with READY status');
1072:
1073: fii_util.start_timer;
1074: g_row_count := SET_STATUS_READY;
1075: fii_util.stop_timer;

Line 1101: edw_log.put_line(' ');

1097: -- Successful. Commit and call
1098: -- wrapup to commit and insert messages into logs
1099: -- -----------------------------------------------
1100: -- COMMIT;
1101: edw_log.put_line(' ');
1102: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1103: ' rows into the staging table');
1104: edw_log.put_line(' ');
1105: Retcode := g_retcode;

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

1098: -- wrapup to commit and insert messages into logs
1099: -- -----------------------------------------------
1100: -- COMMIT;
1101: edw_log.put_line(' ');
1102: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1103: ' rows into the staging table');
1104: edw_log.put_line(' ');
1105: Retcode := g_retcode;
1106: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);

Line 1104: edw_log.put_line(' ');

1100: -- COMMIT;
1101: edw_log.put_line(' ');
1102: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1103: ' rows into the staging table');
1104: edw_log.put_line(' ');
1105: Retcode := g_retcode;
1106: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
1107: if (g_missing_rates >0) then
1108: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');

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

1104: edw_log.put_line(' ');
1105: Retcode := g_retcode;
1106: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
1107: if (g_missing_rates >0) then
1108: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
1109: end if;
1110: commit;
1111: --bug#3947925
1112: --Program is on the verge of completing successfully,so clean up

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

1121: WHEN L_IDEN_CHANGE_FAILURE THEN
1122: Errbuf:=g_errbuf;
1123: Retcode:=g_retcode;
1124: l_exception_msg := Retcode || ':' || Errbuf;
1125: edw_log.put_line('Identifying changed records have Failed');
1126: rollback;
1127: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1128: /* Set the completion status to error. bug#3207823 */
1129: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

1131: WHEN L_PUSH_LOCAL_FAILURE THEN
1132: Errbuf:=g_errbuf;
1133: Retcode:=g_retcode;
1134: l_exception_msg := Retcode || ':' || Errbuf;
1135: edw_log.put_line('Inserting into local staging have failed');
1136: rollback;
1137: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1138: /* Set the completion status to error. bug#3207823 */
1139: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

1141: WHEN L_PUSH_REMOTE_FAILURE THEN
1142: Errbuf:=g_errbuf;
1143: Retcode:=g_retcode;
1144: l_exception_msg := Retcode || ':' || Errbuf;
1145: edw_log.put_line('Data migration from local to remote staging have failed');
1146: rollback;
1147: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1148: /* Set the completion status to error. bug#3207823 */
1149: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

1151: WHEN L_SET_STATUS_FAILURE THEN
1152: Errbuf:=g_errbuf;
1153: Retcode:=g_retcode;
1154: l_exception_msg := Retcode || ':' || Errbuf;
1155: edw_log.put_line('Setting status to READY have failed');
1156: rollback;
1157: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1158: /* Set the completion status to error. bug#3207823 */
1159: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);