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

Line 1043: EDW_LOG.Put_Line( 'The collection range is from '||

1039:
1040: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date := nvl(l_to_date,
1041: EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);
1042:
1043: EDW_LOG.Put_Line( 'The collection range is from '||
1044: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1045: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1046: EDW_LOG.Put_Line(' ');
1047:

Line 1046: EDW_LOG.Put_Line(' ');

1042:
1043: EDW_LOG.Put_Line( 'The collection range is from '||
1044: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1045: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1046: EDW_LOG.Put_Line(' ');
1047:
1048:
1049: -- ---------------------------------------
1050: -- Identify Change for Booked Orders Lines

Line 1053: EDW_LOG.Put_Line('Identifying changed Booked orders lines');

1049: -- ---------------------------------------
1050: -- Identify Change for Booked Orders Lines
1051: -- ---------------------------------------
1052:
1053: EDW_LOG.Put_Line('Identifying changed Booked orders lines');
1054:
1055: FII_UTIL.Start_Timer;
1056:
1057: g_seq_id_line_1 := Identify_Change(1,-1 , l_row_count);

Line 1071: EDW_LOG.Put_Line(' ');

1067: -- -----------------------------------
1068: -- Identify Change for Reserved Orders
1069: -- -----------------------------------
1070:
1071: EDW_LOG.Put_Line(' ');
1072: EDW_LOG.Put_Line('Identifying changed for reserved orders');
1073:
1074: FII_UTIL.Start_Timer;
1075:

Line 1072: EDW_LOG.Put_Line('Identifying changed for reserved orders');

1068: -- Identify Change for Reserved Orders
1069: -- -----------------------------------
1070:
1071: EDW_LOG.Put_Line(' ');
1072: EDW_LOG.Put_Line('Identifying changed for reserved orders');
1073:
1074: FII_UTIL.Start_Timer;
1075:
1076: g_seq_id_line_2 := Identify_Change(2, g_seq_id_line_1, l_row_count);

Line 1090: EDW_LOG.Put_Line(' ');

1086: -- -------------------------------------------------
1087: -- Identify Change for Multiple-Cancellations Orders
1088: -- -------------------------------------------------
1089:
1090: EDW_LOG.Put_Line(' ');
1091: EDW_LOG.Put_Line('Identifying changed for Multi-Cancellations orders');
1092:
1093: FII_UTIL.Start_Timer;
1094:

Line 1091: EDW_LOG.Put_Line('Identifying changed for Multi-Cancellations orders');

1087: -- Identify Change for Multiple-Cancellations Orders
1088: -- -------------------------------------------------
1089:
1090: EDW_LOG.Put_Line(' ');
1091: EDW_LOG.Put_Line('Identifying changed for Multi-Cancellations orders');
1092:
1093: FII_UTIL.Start_Timer;
1094:
1095: g_seq_id_line_3 := Identify_Change(3, g_seq_id_line_1, l_row_count);

Line 1109: EDW_LOG.Put_Line(' ');

1105: -- ----------------------------------------------------------
1106: -- Identify Missing Rate into ISC_EDW_BOOK_MISSING_RATE table
1107: -- ----------------------------------------------------------
1108:
1109: EDW_LOG.Put_Line(' ');
1110: EDW_LOG.Put_Line('Identifying the missing conversion rates (currency and UoM)');
1111:
1112: FII_UTIL.Start_Timer;
1113:

Line 1110: EDW_LOG.Put_Line('Identifying the missing conversion rates (currency and UoM)');

1106: -- Identify Missing Rate into ISC_EDW_BOOK_MISSING_RATE table
1107: -- ----------------------------------------------------------
1108:
1109: EDW_LOG.Put_Line(' ');
1110: EDW_LOG.Put_Line('Identifying the missing conversion rates (currency and UoM)');
1111:
1112: FII_UTIL.Start_Timer;
1113:
1114: g_miss_conv := Identify_Missing_Rate (l_row_count);

Line 1123: EDW_LOG.Put_Line(' ');

1119: THEN RAISE l_failure;
1120: END IF;
1121:
1122: FII_UTIL.Print_Timer('Inserted '||g_miss_conv||' rows into the ISC_EDW_BOOK_MISSING_RATE table in ');
1123: EDW_LOG.Put_Line(' ');
1124:
1125:
1126: -- --------------------------------------------------------------------
1127: -- Inserting into ISC_TMP_PK rows having missing rate (with seq_id < 0)

Line 1130: EDW_LOG.Put_Line(' ');

1126: -- --------------------------------------------------------------------
1127: -- Inserting into ISC_TMP_PK rows having missing rate (with seq_id < 0)
1128: -- --------------------------------------------------------------------
1129:
1130: EDW_LOG.Put_Line(' ');
1131: EDW_LOG.Put_Line('Inserting into ISC_TMP_PK with < 0 seq_id the rows having missing conversion rates (currency and UoM)');
1132:
1133: FII_UTIL.Start_Timer;
1134:

Line 1131: EDW_LOG.Put_Line('Inserting into ISC_TMP_PK with < 0 seq_id the rows having missing conversion rates (currency and UoM)');

1127: -- Inserting into ISC_TMP_PK rows having missing rate (with seq_id < 0)
1128: -- --------------------------------------------------------------------
1129:
1130: EDW_LOG.Put_Line(' ');
1131: EDW_LOG.Put_Line('Inserting into ISC_TMP_PK with < 0 seq_id the rows having missing conversion rates (currency and UoM)');
1132:
1133: FII_UTIL.Start_Timer;
1134:
1135: g_row_count := Insert_Isc_Tmp_Pk (l_row_count);

Line 1144: EDW_LOG.Put_Line(' ');

1140: THEN RAISE l_failure;
1141: END IF;
1142:
1143: FII_UTIL.Print_Timer('Inserted '||l_row_count||' rows into the ISC_TMP_PK table in ');
1144: EDW_LOG.Put_Line(' ');
1145:
1146:
1147: -- --------------------------------------------
1148: -- Deleting ISC_TMP_PK rows having missing rate

Line 1151: EDW_LOG.Put_Line(' ');

1147: -- --------------------------------------------
1148: -- Deleting ISC_TMP_PK rows having missing rate
1149: -- --------------------------------------------
1150:
1151: EDW_LOG.Put_Line(' ');
1152: EDW_LOG.Put_Line('Deleting the ISC_TMP_PK rows having a missing conversion rates before collecting (currency and UoM)');
1153:
1154: FII_UTIL.Start_Timer;
1155:

Line 1152: EDW_LOG.Put_Line('Deleting the ISC_TMP_PK rows having a missing conversion rates before collecting (currency and UoM)');

1148: -- Deleting ISC_TMP_PK rows having missing rate
1149: -- --------------------------------------------
1150:
1151: EDW_LOG.Put_Line(' ');
1152: EDW_LOG.Put_Line('Deleting the ISC_TMP_PK rows having a missing conversion rates before collecting (currency and UoM)');
1153:
1154: FII_UTIL.Start_Timer;
1155:
1156: g_row_count := Delete_Isc_Tmp_Pk ;

Line 1165: EDW_LOG.Put_Line(' ');

1161: THEN RAISE l_failure;
1162: END IF;
1163:
1164: FII_UTIL.Print_Timer('Deleted '||g_row_count||' rows from the ISC_TMP_PK table in ');
1165: EDW_LOG.Put_Line(' ');
1166:
1167:
1168: IF NOT ((g_all_or_nothing_flag = 'Y') and (g_miss_conv > 0)) -- collect except when this condition applies
1169: THEN

Line 1176: EDW_LOG.Put_Line(' ');

1172: -- -------------------------------------------
1173: -- Push to Local staging table for view type 1
1174: -- -------------------------------------------
1175:
1176: EDW_LOG.Put_Line(' ');
1177: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 1');
1178:
1179: EDW_LOG.Put_Line( 'The collection range is from '||
1180: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 1177: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 1');

1173: -- Push to Local staging table for view type 1
1174: -- -------------------------------------------
1175:
1176: EDW_LOG.Put_Line(' ');
1177: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 1');
1178:
1179: EDW_LOG.Put_Line( 'The collection range is from '||
1180: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1181: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));

Line 1179: EDW_LOG.Put_Line( 'The collection range is from '||

1175:
1176: EDW_LOG.Put_Line(' ');
1177: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 1');
1178:
1179: EDW_LOG.Put_Line( 'The collection range is from '||
1180: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1181: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1182:
1183: FII_UTIL.Start_Timer;

Line 1196: EDW_LOG.Put_Line(' ');

1192:
1193: g_rows_collected := g_row_count;
1194:
1195: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 1 into the local staging table in ');
1196: EDW_LOG.Put_Line(' ');
1197:
1198:
1199: -- -------------------------------------------
1200: -- Push to Local staging table for view type 2

Line 1203: EDW_LOG.Put_Line(' ');

1199: -- -------------------------------------------
1200: -- Push to Local staging table for view type 2
1201: -- -------------------------------------------
1202:
1203: EDW_LOG.Put_Line(' ');
1204: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 2');
1205:
1206: EDW_LOG.Put_Line(' ');
1207: EDW_LOG.Put_Line( 'The collection range is from '||

Line 1204: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 2');

1200: -- Push to Local staging table for view type 2
1201: -- -------------------------------------------
1202:
1203: EDW_LOG.Put_Line(' ');
1204: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 2');
1205:
1206: EDW_LOG.Put_Line(' ');
1207: EDW_LOG.Put_Line( 'The collection range is from '||
1208: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 1206: EDW_LOG.Put_Line(' ');

1202:
1203: EDW_LOG.Put_Line(' ');
1204: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 2');
1205:
1206: EDW_LOG.Put_Line(' ');
1207: EDW_LOG.Put_Line( 'The collection range is from '||
1208: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1209: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1210: EDW_LOG.Put_Line(' ');

Line 1207: EDW_LOG.Put_Line( 'The collection range is from '||

1203: EDW_LOG.Put_Line(' ');
1204: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 2');
1205:
1206: EDW_LOG.Put_Line(' ');
1207: EDW_LOG.Put_Line( 'The collection range is from '||
1208: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1209: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1210: EDW_LOG.Put_Line(' ');
1211:

Line 1210: EDW_LOG.Put_Line(' ');

1206: EDW_LOG.Put_Line(' ');
1207: EDW_LOG.Put_Line( 'The collection range is from '||
1208: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1209: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1210: EDW_LOG.Put_Line(' ');
1211:
1212: FII_UTIL.Start_Timer;
1213:
1214: g_row_count := Push_To_Local(2,g_seq_id_line_2);

Line 1225: EDW_LOG.Put_Line(' ');

1221:
1222: g_rows_collected := g_rows_collected + g_row_count;
1223:
1224: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 2 into the local staging table in ');
1225: EDW_LOG.Put_Line(' ');
1226:
1227:
1228: -- -------------------------------------------
1229: -- Push to Local staging table for view type 3

Line 1232: EDW_LOG.Put_Line(' ');

1228: -- -------------------------------------------
1229: -- Push to Local staging table for view type 3
1230: -- -------------------------------------------
1231:
1232: EDW_LOG.Put_Line(' ');
1233: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 3');
1234: EDW_LOG.Put_Line(' ');
1235:
1236: FII_UTIL.Start_Timer;

Line 1233: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 3');

1229: -- Push to Local staging table for view type 3
1230: -- -------------------------------------------
1231:
1232: EDW_LOG.Put_Line(' ');
1233: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 3');
1234: EDW_LOG.Put_Line(' ');
1235:
1236: FII_UTIL.Start_Timer;
1237:

Line 1234: EDW_LOG.Put_Line(' ');

1230: -- -------------------------------------------
1231:
1232: EDW_LOG.Put_Line(' ');
1233: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 3');
1234: EDW_LOG.Put_Line(' ');
1235:
1236: FII_UTIL.Start_Timer;
1237:
1238: g_row_count := Push_To_Local(3,g_seq_id_line_3);

Line 1249: EDW_LOG.Put_Line(' ');

1245:
1246: g_rows_collected := g_rows_collected + g_row_count;
1247:
1248: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 3 into the local staging table in ');
1249: EDW_LOG.Put_Line(' ');
1250:
1251: EDW_LOG.Put_Line(' ');
1252: EDW_LOG.Put_Line('Marking rows to be deleted from the Fact (rows having beeing deleted from the source instance table)');
1253: EDW_LOG.Put_Line(' ');

Line 1251: EDW_LOG.Put_Line(' ');

1247:
1248: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 3 into the local staging table in ');
1249: EDW_LOG.Put_Line(' ');
1250:
1251: EDW_LOG.Put_Line(' ');
1252: EDW_LOG.Put_Line('Marking rows to be deleted from the Fact (rows having beeing deleted from the source instance table)');
1253: EDW_LOG.Put_Line(' ');
1254:
1255: FII_UTIL.Start_Timer;

Line 1252: EDW_LOG.Put_Line('Marking rows to be deleted from the Fact (rows having beeing deleted from the source instance table)');

1248: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 3 into the local staging table in ');
1249: EDW_LOG.Put_Line(' ');
1250:
1251: EDW_LOG.Put_Line(' ');
1252: EDW_LOG.Put_Line('Marking rows to be deleted from the Fact (rows having beeing deleted from the source instance table)');
1253: EDW_LOG.Put_Line(' ');
1254:
1255: FII_UTIL.Start_Timer;
1256:

Line 1253: EDW_LOG.Put_Line(' ');

1249: EDW_LOG.Put_Line(' ');
1250:
1251: EDW_LOG.Put_Line(' ');
1252: EDW_LOG.Put_Line('Marking rows to be deleted from the Fact (rows having beeing deleted from the source instance table)');
1253: EDW_LOG.Put_Line(' ');
1254:
1255: FII_UTIL.Start_Timer;
1256:
1257: g_row_count := Deletion_Handling;

Line 1266: EDW_LOG.Put_Line(' ');

1262: THEN RAISE l_failure;
1263: END IF;
1264:
1265: FII_UTIL.Print_Timer('Marked '||g_row_count||' rows to be deleted from the Fact in ');
1266: EDW_LOG.Put_Line(' ');
1267:
1268: END;
1269: END IF; -- IF NOT ((g_all_or_nothing_flag = 'Y') and (g_miss_conv > 0))
1270:

Line 1291: EDW_LOG.Put_Line(' ');

1287:
1288: IF g_all_or_nothing_flag = 'N' -- We collected and report missing conversions
1289: THEN
1290: retcode := 1;
1291: EDW_LOG.Put_Line(' ');
1292: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE WARNING.');
1293: EDW_LOG.Put_Line(' ');
1294: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
1295: THEN

Line 1292: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE WARNING.');

1288: IF g_all_or_nothing_flag = 'N' -- We collected and report missing conversions
1289: THEN
1290: retcode := 1;
1291: EDW_LOG.Put_Line(' ');
1292: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE WARNING.');
1293: EDW_LOG.Put_Line(' ');
1294: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
1295: THEN
1296: retcode := -1;

Line 1293: EDW_LOG.Put_Line(' ');

1289: THEN
1290: retcode := 1;
1291: EDW_LOG.Put_Line(' ');
1292: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE WARNING.');
1293: EDW_LOG.Put_Line(' ');
1294: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
1295: THEN
1296: retcode := -1;
1297: EDW_LOG.Put_Line(' ');

Line 1297: EDW_LOG.Put_Line(' ');

1293: EDW_LOG.Put_Line(' ');
1294: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
1295: THEN
1296: retcode := -1;
1297: EDW_LOG.Put_Line(' ');
1298: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');
1299: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
1300: EDW_LOG.Put_Line(' ');
1301: END IF; --g_all_or_nothing_flag = 'N'

Line 1298: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');

1294: ELSIF g_all_or_nothing_flag = 'Y' -- We did not collect and report missing conversions
1295: THEN
1296: retcode := -1;
1297: EDW_LOG.Put_Line(' ');
1298: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');
1299: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
1300: EDW_LOG.Put_Line(' ');
1301: END IF; --g_all_or_nothing_flag = 'N'
1302:

Line 1299: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');

1295: THEN
1296: retcode := -1;
1297: EDW_LOG.Put_Line(' ');
1298: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');
1299: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
1300: EDW_LOG.Put_Line(' ');
1301: END IF; --g_all_or_nothing_flag = 'N'
1302:
1303: EDW_LOG.Put_Line('Below is the list of the missing conversions.');

Line 1300: EDW_LOG.Put_Line(' ');

1296: retcode := -1;
1297: EDW_LOG.Put_Line(' ');
1298: EDW_LOG.Put_Line('Collection finished with a CONVERSION RATE ERROR.');
1299: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
1300: EDW_LOG.Put_Line(' ');
1301: END IF; --g_all_or_nothing_flag = 'N'
1302:
1303: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
1304: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');

Line 1303: EDW_LOG.Put_Line('Below is the list of the missing conversions.');

1299: EDW_LOG.Put_Line('Collection aborted because there are missing conversion rates.');
1300: EDW_LOG.Put_Line(' ');
1301: END IF; --g_all_or_nothing_flag = 'N'
1302:
1303: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
1304: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
1305: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
1306: EDW_LOG.Put_Line(' ');
1307:

Line 1304: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');

1300: EDW_LOG.Put_Line(' ');
1301: END IF; --g_all_or_nothing_flag = 'N'
1302:
1303: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
1304: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
1305: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
1306: EDW_LOG.Put_Line(' ');
1307:
1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

Line 1305: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');

1301: END IF; --g_all_or_nothing_flag = 'N'
1302:
1303: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
1304: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
1305: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
1306: EDW_LOG.Put_Line(' ');
1307:
1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1309: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');

Line 1306: EDW_LOG.Put_Line(' ');

1302:
1303: EDW_LOG.Put_Line('Below is the list of the missing conversions.');
1304: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
1305: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
1306: EDW_LOG.Put_Line(' ');
1307:
1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1309: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
1310: EDW_LOG.Put_Line('');

Line 1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

1304: EDW_LOG.Put_Line('Enter the missing currency rates in Oracle General Ledger.');
1305: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
1306: EDW_LOG.Put_Line(' ');
1307:
1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1309: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
1310: EDW_LOG.Put_Line('');
1311: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
1312: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');

Line 1309: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');

1305: EDW_LOG.Put_Line('To fix the missing UOM please refer to the EDW implementation guide - UOM Setup');
1306: EDW_LOG.Put_Line(' ');
1307:
1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1309: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
1310: EDW_LOG.Put_Line('');
1311: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
1312: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');
1313:

Line 1310: EDW_LOG.Put_Line('');

1306: EDW_LOG.Put_Line(' ');
1307:
1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1309: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
1310: EDW_LOG.Put_Line('');
1311: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
1312: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');
1313:
1314: l_row_count := 0;

Line 1311: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');

1307:
1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1309: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
1310: EDW_LOG.Put_Line('');
1311: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
1312: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');
1313:
1314: l_row_count := 0;
1315:

Line 1312: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');

1308: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1309: EDW_LOG.Put_Line(' REPORT FOR THE MISSING CURRENCY CONVERSION RATES');
1310: EDW_LOG.Put_Line('');
1311: EDW_LOG.Put_Line('CONV. DATE - FROM CURR. - TO CURR. - CONV. TYPE CODE - STATUS');
1312: EDW_LOG.Put_Line('---------- - ---------- - -------- - --------------- - ----------------------');
1313:
1314: l_row_count := 0;
1315:
1316: FOR line IN Missing_Currency_Conversion

Line 1319: EDW_LOG.Put_Line( RPAD(line.curr_conv_date,10,' ')

1315:
1316: FOR line IN Missing_Currency_Conversion
1317: LOOP
1318: l_row_count := l_row_count + 1;
1319: EDW_LOG.Put_Line( RPAD(line.curr_conv_date,10,' ')
1320: ||' - '||RPAD(line.from_currency,10,' ')
1321: ||' - '||RPAD(line.to_currency,8,' ')
1322: ||' - '||RPAD(line.rate_type,15)
1323: ||' - '||RPAD(line.status,20));

Line 1328: EDW_LOG.Put_Line('');

1324: END LOOP;
1325:
1326: IF l_row_count = 0
1327: THEN
1328: EDW_LOG.Put_Line('');
1329: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
1330: EDW_LOG.Put_Line('');
1331: END IF;
1332:

Line 1329: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');

1325:
1326: IF l_row_count = 0
1327: THEN
1328: EDW_LOG.Put_Line('');
1329: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
1330: EDW_LOG.Put_Line('');
1331: END IF;
1332:
1333: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

Line 1330: EDW_LOG.Put_Line('');

1326: IF l_row_count = 0
1327: THEN
1328: EDW_LOG.Put_Line('');
1329: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
1330: EDW_LOG.Put_Line('');
1331: END IF;
1332:
1333: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1334: EDW_LOG.Put_Line('');

Line 1333: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

1329: EDW_LOG.Put_Line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
1330: EDW_LOG.Put_Line('');
1331: END IF;
1332:
1333: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1334: EDW_LOG.Put_Line('');
1335: EDW_LOG.Put_Line('');
1336: EDW_LOG.Put_Line('');
1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

Line 1334: EDW_LOG.Put_Line('');

1330: EDW_LOG.Put_Line('');
1331: END IF;
1332:
1333: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1334: EDW_LOG.Put_Line('');
1335: EDW_LOG.Put_Line('');
1336: EDW_LOG.Put_Line('');
1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');

Line 1335: EDW_LOG.Put_Line('');

1331: END IF;
1332:
1333: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1334: EDW_LOG.Put_Line('');
1335: EDW_LOG.Put_Line('');
1336: EDW_LOG.Put_Line('');
1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
1339: EDW_LOG.Put_Line('');

Line 1336: EDW_LOG.Put_Line('');

1332:
1333: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1334: EDW_LOG.Put_Line('');
1335: EDW_LOG.Put_Line('');
1336: EDW_LOG.Put_Line('');
1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
1339: EDW_LOG.Put_Line('');
1340: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');

Line 1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

1333: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1334: EDW_LOG.Put_Line('');
1335: EDW_LOG.Put_Line('');
1336: EDW_LOG.Put_Line('');
1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
1339: EDW_LOG.Put_Line('');
1340: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
1341: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');

Line 1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');

1334: EDW_LOG.Put_Line('');
1335: EDW_LOG.Put_Line('');
1336: EDW_LOG.Put_Line('');
1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
1339: EDW_LOG.Put_Line('');
1340: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
1341: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');
1342:

Line 1339: EDW_LOG.Put_Line('');

1335: EDW_LOG.Put_Line('');
1336: EDW_LOG.Put_Line('');
1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
1339: EDW_LOG.Put_Line('');
1340: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
1341: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');
1342:
1343: l_row_count := 0;

Line 1340: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');

1336: EDW_LOG.Put_Line('');
1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
1339: EDW_LOG.Put_Line('');
1340: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
1341: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');
1342:
1343: l_row_count := 0;
1344:

Line 1341: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');

1337: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1338: EDW_LOG.Put_Line(' REPORT FOR THE MISSING UNIT OF MEASURE CONVERSION RATES');
1339: EDW_LOG.Put_Line('');
1340: EDW_LOG.Put_Line('FROM UOM - TO UOM - ITEM_ID - ITEM NUMBER : ITEM DESCRIPTION');
1341: EDW_LOG.Put_Line('-------- - -------- - -------- - --------------------------------------------');
1342:
1343: l_row_count := 0;
1344:
1345: FOR line IN Missing_UOM_Conversion

Line 1348: EDW_LOG.Put_Line( RPAD(line.from_uom_code,8,' ')

1344:
1345: FOR line IN Missing_UOM_Conversion
1346: LOOP
1347: l_row_count := l_row_count + 1;
1348: EDW_LOG.Put_Line( RPAD(line.from_uom_code,8,' ')
1349: ||' - '||RPAD(line.to_uom_code,8,' ')
1350: ||' - '||RPAD(line.item_id,8,' ')
1351: ||' - '||RPAD(line.item_name,42));
1352: END LOOP;

Line 1356: EDW_LOG.Put_Line('');

1352: END LOOP;
1353:
1354: IF l_row_count = 0
1355: THEN
1356: EDW_LOG.Put_Line('');
1357: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');
1358: EDW_LOG.Put_Line('');
1359: END IF;
1360: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

Line 1357: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');

1353:
1354: IF l_row_count = 0
1355: THEN
1356: EDW_LOG.Put_Line('');
1357: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');
1358: EDW_LOG.Put_Line('');
1359: END IF;
1360: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1361: END; -- begin IF g_miss_conv > 0

Line 1358: EDW_LOG.Put_Line('');

1354: IF l_row_count = 0
1355: THEN
1356: EDW_LOG.Put_Line('');
1357: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');
1358: EDW_LOG.Put_Line('');
1359: END IF;
1360: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1361: END; -- begin IF g_miss_conv > 0
1362: END IF; -- IF g_miss_conv > 0

Line 1360: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

1356: EDW_LOG.Put_Line('');
1357: EDW_LOG.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');
1358: EDW_LOG.Put_Line('');
1359: END IF;
1360: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1361: END; -- begin IF g_miss_conv > 0
1362: END IF; -- IF g_miss_conv > 0
1363:
1364:

Line 1379: EDW_LOG.Put_Line(' ');

1375: -- No exception raised so far. Successful. Call
1376: -- Wrapup to commit and insert messages into logs
1377: -- ----------------------------------------------
1378:
1379: EDW_LOG.Put_Line(' ');
1380: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
1381: EDW_LOG.Put_Line(' ');
1382: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1383: EDW_LOG.Put_Line(' ');

Line 1380: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');

1376: -- Wrapup to commit and insert messages into logs
1377: -- ----------------------------------------------
1378:
1379: EDW_LOG.Put_Line(' ');
1380: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
1381: EDW_LOG.Put_Line(' ');
1382: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1383: EDW_LOG.Put_Line(' ');
1384: EDW_LOG.Put_Line('Start of the Wrapup section ');

Line 1381: EDW_LOG.Put_Line(' ');

1377: -- ----------------------------------------------
1378:
1379: EDW_LOG.Put_Line(' ');
1380: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
1381: EDW_LOG.Put_Line(' ');
1382: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1383: EDW_LOG.Put_Line(' ');
1384: EDW_LOG.Put_Line('Start of the Wrapup section ');
1385: EDW_LOG.Put_Line(' ');

Line 1382: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');

1378:
1379: EDW_LOG.Put_Line(' ');
1380: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
1381: EDW_LOG.Put_Line(' ');
1382: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1383: EDW_LOG.Put_Line(' ');
1384: EDW_LOG.Put_Line('Start of the Wrapup section ');
1385: EDW_LOG.Put_Line(' ');
1386:

Line 1383: EDW_LOG.Put_Line(' ');

1379: EDW_LOG.Put_Line(' ');
1380: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
1381: EDW_LOG.Put_Line(' ');
1382: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1383: EDW_LOG.Put_Line(' ');
1384: EDW_LOG.Put_Line('Start of the Wrapup section ');
1385: EDW_LOG.Put_Line(' ');
1386:
1387:

Line 1384: EDW_LOG.Put_Line('Start of the Wrapup section ');

1380: EDW_LOG.Put_Line('Inserted '||g_rows_collected||' rows into the local staging table');
1381: EDW_LOG.Put_Line(' ');
1382: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1383: EDW_LOG.Put_Line(' ');
1384: EDW_LOG.Put_Line('Start of the Wrapup section ');
1385: EDW_LOG.Put_Line(' ');
1386:
1387:
1388: IF retcode = -1

Line 1385: EDW_LOG.Put_Line(' ');

1381: EDW_LOG.Put_Line(' ');
1382: EDW_LOG.Put_Line('+---------------------------------------------------------------------------+');
1383: EDW_LOG.Put_Line(' ');
1384: EDW_LOG.Put_Line('Start of the Wrapup section ');
1385: EDW_LOG.Put_Line(' ');
1386:
1387:
1388: IF retcode = -1
1389: THEN

Line 1416: EDW_LOG.Put_Line(g_errbuf);

1412: EXCEPTION
1413:
1414: WHEN L_FAILURE THEN
1415: ROLLBACK;
1416: EDW_LOG.Put_Line(g_errbuf);
1417: retcode := -1;
1418: EDW_COLLECTION_UTIL.Wrapup(
1419: FALSE,
1420: g_rows_collected,

Line 1427: EDW_LOG.Put_Line('Other errors : '|| g_errbuf);

1423: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1424: WHEN OTHERS THEN
1425: ROLLBACK;
1426: g_errbuf := sqlerrm ||' - '|| sqlcode;
1427: EDW_LOG.Put_Line('Other errors : '|| g_errbuf);
1428: retcode := -1;
1429: EDW_COLLECTION_UTIL.Wrapup(
1430: FALSE,
1431: g_rows_collected,