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_SCH_PAYMTS_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:
34: END;

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:
34: END;
35:

Line 89: edw_log.put_line(' ');

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

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

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

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

87: --Generates "Warning" message in the Status column of Concurrent Manager "Requests" table
88:
89: edw_log.put_line(' ');
90: edw_log.put_line('INSERTING ' || to_char(sql%rowcount) || ' rows from staging table');
91: edw_log.put_line('g_retcode is '||g_retcode);
92: END;
93:
94:
95: --------------------------------------------------

Line 427: edw_log.put_line('g_row_count');

423: FROM_CURRENCY
424: from FII_AP_SCH_PAYMTS_FCV;
425:
426: fii_flex_mapping.free_mem_all;
427: edw_log.put_line('g_row_count');
428: edw_log.put_line(TO_CHAR(sql%rowcount));
429: RETURN(sql%rowcount);
430: EXCEPTION
431: WHEN OTHERS THEN

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

424: from FII_AP_SCH_PAYMTS_FCV;
425:
426: fii_flex_mapping.free_mem_all;
427: edw_log.put_line('g_row_count');
428: edw_log.put_line(TO_CHAR(sql%rowcount));
429: RETURN(sql%rowcount);
430: EXCEPTION
431: WHEN OTHERS THEN
432: g_errbuf:=sqlerrm;

Line 750: edw_log.debug_line('');

746: TABNAME => 'FII_TMP_PK') ;
747: END IF; */
748:
749: --** Added for iExpense Enhancement,12-DEC-02
750: edw_log.debug_line('');
751: edw_log.debug_line(l_stmt);
752: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
753: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
754: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;

Line 751: edw_log.debug_line(l_stmt);

747: END IF; */
748:
749: --** Added for iExpense Enhancement,12-DEC-02
750: edw_log.debug_line('');
751: edw_log.debug_line(l_stmt);
752: execute immediate l_stmt using g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
753: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2,
754: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;
755: --**

Line 758: edw_log.put_line( 'NO OF ROWS CHANGED '||

754: g_acct_or_inv_date,g_push_date_range1,g_push_date_range2;
755: --**
756:
757: p_count := sql%rowcount;
758: edw_log.put_line( 'NO OF ROWS CHANGED '||
759: to_char(p_count));
760:
761: EXCEPTION
762: WHEN OTHERS THEN

Line 763: edw_log.put_line(' ');

759: to_char(p_count));
760:
761: EXCEPTION
762: WHEN OTHERS THEN
763: edw_log.put_line(' ');
764: g_errbuf:=sqlerrm;
765: g_retcode:=sqlcode;
766: edw_log.put_line(g_errbuf);
767:

Line 766: edw_log.put_line(g_errbuf);

762: WHEN OTHERS THEN
763: edw_log.put_line(' ');
764: g_errbuf:=sqlerrm;
765: g_retcode:=sqlcode;
766: edw_log.put_line(g_errbuf);
767:
768: rollback;
769:
770: END;

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

852: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
853: FII_AP_SCH_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
854: l_date1 := g_push_date_range1;
855: l_date2 := g_push_date_range2;
856: edw_log.put_line( 'The collection range is from '||
857: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
858: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
859: edw_log.put_line(' ');
860:

Line 859: edw_log.put_line(' ');

855: l_date2 := g_push_date_range2;
856: edw_log.put_line( 'The collection range is from '||
857: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||
858: to_char(l_date2,'MM/DD/YYYY HH24:MI:SS'));
859: edw_log.put_line(' ');
860:
861: --bug#3947925
862: --Check whether missing rates table has data or not. If not then copy missing rates
863: --from temp table to the missing rates table. This is required to avoid full refresh

Line 910: edw_log.put_line(' ');

906: -- --------------------------------------------------------
907: -- 1. Clean up any records left from previous process in
908: -- the local staging table.
909: -- --------------------------------------------------------
910: edw_log.put_line(' ');
911: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
912: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
913: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');
914: ELSE

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

907: -- 1. Clean up any records left from previous process in
908: -- the local staging table.
909: -- --------------------------------------------------------
910: edw_log.put_line(' ');
911: edw_log.put_line('Cleaning up unprocessed records left in local staging table');
912: IF (NOT LOCAL_SAME_AS_REMOTE) THEN
913: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');
914: ELSE
915: DELETE_STG;

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

914: ELSE
915: DELETE_STG;
916: END IF;
917: select count(*) into rows1 from FII_AP_SCH_PAYMTS_FSTG;
918: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
919: -- --------------------------------------------------------
920: -- 2. Identify Changed AP Scheduled Payments record
921: -- --------------------------------------------------------
922: edw_log.put_line(' ');

Line 922: edw_log.put_line(' ');

918: edw_log.put_line('Number of rows in stg after truncating or deleting'||rows1 );
919: -- --------------------------------------------------------
920: -- 2. Identify Changed AP Scheduled Payments record
921: -- --------------------------------------------------------
922: edw_log.put_line(' ');
923: edw_log.put_line('Identifying changed AP Scheduled Payments record');
924: fii_util.start_timer;
925: IDENTIFY_CHANGE(l_row_count);
926: fii_util.stop_timer;

Line 923: edw_log.put_line('Identifying changed AP Scheduled Payments record');

919: -- --------------------------------------------------------
920: -- 2. Identify Changed AP Scheduled Payments record
921: -- --------------------------------------------------------
922: edw_log.put_line(' ');
923: edw_log.put_line('Identifying changed AP Scheduled Payments record');
924: fii_util.start_timer;
925: IDENTIFY_CHANGE(l_row_count);
926: fii_util.stop_timer;
927: fii_util.print_timer('Identified '||l_row_count||' changed records');

Line 933: edw_log.put_line(' ');

929: -- --------------------------------------------------------
930: -- 3. Pushing data to local staging table
931: -- --------------------------------------------------------
932:
933: edw_log.put_line(' ');
934: edw_log.put_line('Pushing data');
935: fii_util.start_timer;
936: g_row_count :=PUSH_TO_LOCAL;
937: fii_util.stop_timer;

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

930: -- 3. Pushing data to local staging table
931: -- --------------------------------------------------------
932:
933: edw_log.put_line(' ');
934: edw_log.put_line('Pushing data');
935: fii_util.start_timer;
936: g_row_count :=PUSH_TO_LOCAL;
937: fii_util.stop_timer;
938: fii_util.print_timer('Process Time');

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

940: IF (g_row_count = -1) THEN
941: RAISE L_push_local_failure;
942: END IF;
943:
944: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
945: ' rows into the local staging table');
946: edw_log.put_line(' ');
947:
948: -- --------------------------------------------------------------------

Line 946: edw_log.put_line(' ');

942: END IF;
943:
944: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
945: ' rows into the local staging table');
946: edw_log.put_line(' ');
947:
948: -- --------------------------------------------------------------------
949: -- 4. Delete records generated from previous session from tmp_pk table
950: -- --------------------------------------------------------------------

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

949: -- 4. Delete records generated from previous session from tmp_pk table
950: -- --------------------------------------------------------------------
951: TRUNCATE_TABLE('fii_ap_tmp_schp_pk');
952: select count(*) into rows from fii_ap_tmp_schp_pk ;
953: edw_log.put_line('Number of rows in tmp_pk after truncating or deleting '||rows );
954: -- ------------------------------------------------------------------------------------------------
955: -- 4A. Insert missing rates from local fstg into tmp_pk table printing data to file
956: -- ------------------------------------------------------------------------------------------------
957:

Line 1056: edw_log.put_line(' ');

1052: -- as the source OLTP, which is the typical case.
1053: -- We move data from local to remote staging table
1054: -- and clean up local staging
1055: -- -----------------------------------------------
1056: edw_log.put_line(' ');
1057: edw_log.put_line('Moving data from local staging table to remote staging table');
1058: fii_util.start_timer;
1059: g_row_count := PUSH_REMOTE;
1060: fii_util.stop_timer;

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

1053: -- We move data from local to remote staging table
1054: -- and clean up local staging
1055: -- -----------------------------------------------
1056: edw_log.put_line(' ');
1057: edw_log.put_line('Moving data from local staging table to remote staging table');
1058: fii_util.start_timer;
1059: g_row_count := PUSH_REMOTE;
1060: fii_util.stop_timer;
1061: fii_util.print_timer('Duration');

Line 1065: edw_log.put_line(' ');

1061: fii_util.print_timer('Duration');
1062:
1063: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1064:
1065: edw_log.put_line(' ');
1066: edw_log.put_line(to_char(g_row_count));
1067: edw_log.put_line('Cleaning local staging table');
1068:
1069: fii_util.start_timer;

Line 1066: edw_log.put_line(to_char(g_row_count));

1062:
1063: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1064:
1065: edw_log.put_line(' ');
1066: edw_log.put_line(to_char(g_row_count));
1067: edw_log.put_line('Cleaning local staging table');
1068:
1069: fii_util.start_timer;
1070: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');

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

1063: IF (g_row_count = -1) THEN RAISE l_push_remote_failure; END IF;
1064:
1065: edw_log.put_line(' ');
1066: edw_log.put_line(to_char(g_row_count));
1067: edw_log.put_line('Cleaning local staging table');
1068:
1069: fii_util.start_timer;
1070: TRUNCATE_TABLE('FII_AP_SCH_PAYMTS_FSTG');
1071: fii_util.stop_timer;

Line 1081: edw_log.put_line(' ');

1077: -- as the source OLTP. We set the status of all our
1078: -- records status 'LOCAL READY' to 'READY'
1079: -- -----------------------------------------------
1080:
1081: edw_log.put_line(' ');
1082: edw_log.put_line(to_char(g_row_count));
1083: edw_log.put_line('Marking records in staging table with READY status');
1084:
1085: fii_util.start_timer;

Line 1082: edw_log.put_line(to_char(g_row_count));

1078: -- records status 'LOCAL READY' to 'READY'
1079: -- -----------------------------------------------
1080:
1081: edw_log.put_line(' ');
1082: edw_log.put_line(to_char(g_row_count));
1083: edw_log.put_line('Marking records in staging table with READY status');
1084:
1085: fii_util.start_timer;
1086: g_row_count := SET_STATUS_READY;

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

1079: -- -----------------------------------------------
1080:
1081: edw_log.put_line(' ');
1082: edw_log.put_line(to_char(g_row_count));
1083: edw_log.put_line('Marking records in staging table with READY status');
1084:
1085: fii_util.start_timer;
1086: g_row_count := SET_STATUS_READY;
1087: fii_util.stop_timer;

Line 1113: edw_log.put_line(' ');

1109: -- Successful. Commit and call
1110: -- wrapup to commit and insert messages into logs
1111: -- -----------------------------------------------
1112: -- COMMIT;
1113: edw_log.put_line(' ');
1114: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1115: ' rows into the staging table');
1116: edw_log.put_line(' ');
1117: Retcode := g_retcode;

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

1110: -- wrapup to commit and insert messages into logs
1111: -- -----------------------------------------------
1112: -- COMMIT;
1113: edw_log.put_line(' ');
1114: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1115: ' rows into the staging table');
1116: edw_log.put_line(' ');
1117: Retcode := g_retcode;
1118: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);

Line 1116: edw_log.put_line(' ');

1112: -- COMMIT;
1113: edw_log.put_line(' ');
1114: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1115: ' rows into the staging table');
1116: edw_log.put_line(' ');
1117: Retcode := g_retcode;
1118: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
1119: if (g_missing_rates >0) then
1120: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');

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

1116: edw_log.put_line(' ');
1117: Retcode := g_retcode;
1118: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
1119: if (g_missing_rates >0) then
1120: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
1121: end if;
1122: commit;
1123: --bug#3947925
1124: --Program is on the verge of completing successfully,so clean up

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

1133: WHEN L_IDEN_CHANGE_FAILURE THEN
1134: Errbuf:=g_errbuf;
1135: Retcode:=g_retcode;
1136: l_exception_msg := Retcode || ':' || Errbuf;
1137: edw_log.put_line('Identifying changed records have Failed');
1138: rollback;
1139: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1140: /* Set the completion status to error. bug#3207823 */
1141: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

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

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

1153: WHEN L_PUSH_REMOTE_FAILURE THEN
1154: Errbuf:=g_errbuf;
1155: Retcode:=g_retcode;
1156: l_exception_msg := Retcode || ':' || Errbuf;
1157: edw_log.put_line('Data migration from local to remote staging have failed');
1158: rollback;
1159: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1160: /* Set the completion status to error. bug#3207823 */
1161: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);

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

1163: WHEN L_SET_STATUS_FAILURE THEN
1164: Errbuf:=g_errbuf;
1165: Retcode:=g_retcode;
1166: l_exception_msg := Retcode || ':' || Errbuf;
1167: edw_log.put_line('Setting status to READY have failed');
1168: rollback;
1169: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1170: /* Set the completion status to error. bug#3207823 */
1171: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);