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.BSC_MO_LOADER_CONFIG_PKG dependencies on FND_LOG

Line 67: bsc_mo_helper_pkg.writeTmp('Exception in isBasicTable:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

63: END IF;
64: return False;
65: End If;
66: EXCEPTION WHEN OTHERS THEN
67: bsc_mo_helper_pkg.writeTmp('Exception in isBasicTable:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
68: bsc_mo_helper_pkg.writeTmp('p_table_name = '||p_table_name||', l_temp = '||l_temp, FND_LOG.LEVEL_STATEMENT, true);
69: raise;
70: End ;
71:

Line 68: bsc_mo_helper_pkg.writeTmp('p_table_name = '||p_table_name||', l_temp = '||l_temp, FND_LOG.LEVEL_STATEMENT, true);

64: return False;
65: End If;
66: EXCEPTION WHEN OTHERS THEN
67: bsc_mo_helper_pkg.writeTmp('Exception in isBasicTable:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
68: bsc_mo_helper_pkg.writeTmp('p_table_name = '||p_table_name||', l_temp = '||l_temp, FND_LOG.LEVEL_STATEMENT, true);
69: raise;
70: End ;
71:
72: --****************************************************************************

Line 120: bsc_mo_helper_pkg.writeTmp('Exception in GetPhantomLevelPosition:'||sqlerrm, FND_LOG.LEVEL_STATEMENT, true);

116: END LOOP;
117: return posicion;
118:
119: EXCEPTION WHEN OTHERS THEN
120: bsc_mo_helper_pkg.writeTmp('Exception in GetPhantomLevelPosition:'||sqlerrm, FND_LOG.LEVEL_STATEMENT, true);
121: raise;
122: End ;
123:
124:

Line 161: bsc_mo_helper_pkg.writeTmp('Exception in GetPhantomLevels:'||sqlerrm, FND_LOG.LEVEL_STATEMENT, true);

157: Close c1;
158: Return numPhantomLevels;
159:
160: EXCEPTION WHEN OTHERS THEN
161: bsc_mo_helper_pkg.writeTmp('Exception in GetPhantomLevels:'||sqlerrm, FND_LOG.LEVEL_STATEMENT, true);
162: raise;
163: End;
164:
165: --****************************************************************************

Line 239: Configuracion||' AND PERIODICITY_ID = '|| l_periodicity_id||' AND LEVEL_COMB = '||strDrilesAnt, FND_LOG.LEVEL_STATEMENT);

235:
236: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
237: bsc_mo_helper_pkg.writeTmp('UPDATE BSC_KPI_DATA_TABLES SET LEVEL_COMB = '||
238: strDriles||' WHERE INDICATOR = '|| Indicator.Code||' AND DIM_SET_ID = '||
239: Configuracion||' AND PERIODICITY_ID = '|| l_periodicity_id||' AND LEVEL_COMB = '||strDrilesAnt, FND_LOG.LEVEL_STATEMENT);
240: END IF;
241:
242: UPDATE BSC_KPI_DATA_TABLES SET LEVEL_COMB = strDriles
243: WHERE INDICATOR = Indicator.Code AND DIM_SET_ID = Configuracion

Line 260: bsc_mo_helper_pkg.writeTmp('Exception in Corrections : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

256: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gIndicators.next(l_index1);
257: END LOOP;
258:
259: EXCEPTION WHEN OTHERS THEN
260: bsc_mo_helper_pkg.writeTmp('Exception in Corrections : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
261: bsc_mo_helper_pkg.terminateWithError('BSC_DIMCONFIG_FAILED', 'Corrections');
262: RAISE;
263:
264: End ;

Line 295: bsc_mo_helper_pkg.writeTmp('Inside ReCreateMaterializedViewsIndic', FND_LOG.LEVEL_PROCEDURE);

291: l_temp NUMBER;
292: BEGIN
293: --Populate mapping tables for the indicator before create materialized views
294: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
295: bsc_mo_helper_pkg.writeTmp('Inside ReCreateMaterializedViewsIndic', FND_LOG.LEVEL_PROCEDURE);
296: END IF;
297: --l_stmt := 'begin BSC_INTEGRATION_APIS.Populate_Mapping_Tables('|| Indic ||'); end;';
298: --EXECUTE IMMEDIATE l_stmt;
299: -- Obsoleted

Line 329: bsc_mo_helper_pkg.writeTmp('Completed ReCreateMaterializedViewsIndic', FND_LOG.LEVEL_PROCEDURE);

325:
326: END Loop;
327: CLOSE C1;
328: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
329: bsc_mo_helper_pkg.writeTmp('Completed ReCreateMaterializedViewsIndic', FND_LOG.LEVEL_PROCEDURE);
330: END IF;
331:
332: EXCEPTION WHEN OTHERS THEN
333: bsc_mo_helper_pkg.writeTmp('Exception in ReCreateMaterializedViewsIndic : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

Line 333: bsc_mo_helper_pkg.writeTmp('Exception in ReCreateMaterializedViewsIndic : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

329: bsc_mo_helper_pkg.writeTmp('Completed ReCreateMaterializedViewsIndic', FND_LOG.LEVEL_PROCEDURE);
330: END IF;
331:
332: EXCEPTION WHEN OTHERS THEN
333: bsc_mo_helper_pkg.writeTmp('Exception in ReCreateMaterializedViewsIndic : '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
334: bsc_mo_helper_pkg.terminateWithMsg('Exception in ReCreateMaterializedViewsIndic : '||sqlerrm);
335: raise;
336: End ;
337:

Line 371: bsc_mo_helper_pkg.writeTmp('Exception in CalcProjectionTable:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

367: close c1;
368: return l_ret;
369:
370: EXCEPTION WHEN OTHERS THEN
371: bsc_mo_helper_pkg.writeTmp('Exception in CalcProjectionTable:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
372: raise;
373: End;
374:
375:

Line 423: bsc_mo_helper_pkg.writeTmp('Exception in GetIndicTableType:'||sqlerrm, FND_LOG.LEVEL_EXCEPTION, true);

419: CLOSE C1;
420: return l_return;
421:
422: EXCEPTION WHEN OTHERS THEN
423: bsc_mo_helper_pkg.writeTmp('Exception in GetIndicTableType:'||sqlerrm, FND_LOG.LEVEL_EXCEPTION, true);
424: raise;
425: End ;
426:
427:

Line 492: bsc_mo_helper_pkg.writeTmp('Exception in InsertOriginTables:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

488: END IF;
489:
490:
491: EXCEPTION WHEN OTHERS THEN
492: bsc_mo_helper_pkg.writeTmp('Exception in InsertOriginTables:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
493: raise;
494: End;
495:
496:

Line 562: bsc_mo_helper_pkg.writeTmp('Exception in InitarrTablesIndic:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

558: bsc_mo_helper_pkg.writeTmp('Completed InitarrTablesIndic');
559: END IF;
560:
561: EXCEPTION WHEN OTHERS THEN
562: bsc_mo_helper_pkg.writeTmp('Exception in InitarrTablesIndic:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
563: raise;
564: End ;
565:
566:

Line 595: bsc_mo_helper_pkg.writeTmp('Exception in getLevelIndex:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

591: FETCH c1 INTO l_ret;
592: CLOSE c1;
593: return l_ret;
594: EXCEPTION WHEN OTHERS THEN
595: bsc_mo_helper_pkg.writeTmp('Exception in getLevelIndex:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
596: raise;
597: End;
598:
599:

Line 676: bsc_mo_helper_pkg.writeTmp('Exception in get_projection_and_gen_type:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

672: END IF;
673: End If;--If Tabla.IsTargetTable Then
674: End If;--Tabla.Type = 0 Then
675: EXCEPTION WHEN OTHERS THEN
676: bsc_mo_helper_pkg.writeTmp('Exception in get_projection_and_gen_type:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
677: raise;
678:
679: END;
680:

Line 863: bsc_mo_helper_pkg.writeTmp('Going to Delete Metadata tables for '||UPPER(Tabla.Name), FND_LOG.LEVEL_STATEMENT, false);

859: BSC_MO_HELPER_PKG.writeTmp(' ');
860: BSC_MO_HELPER_PKG.writeTmp('Processing gTables('||l_index1||') '||bsc_mo_helper_pkg.get_time);
861: BSC_MO_HELPER_PKG.write_this(Tabla);
862: END IF;
863: bsc_mo_helper_pkg.writeTmp('Going to Delete Metadata tables for '||UPPER(Tabla.Name), FND_LOG.LEVEL_STATEMENT, false);
864: --BSC_DB_TABLES_RELS
865: If Tabla.Type = 1 Then
866: -- Changed to bulk deletes/inserts for better performance - bug 4559323
867: PeriodicityOrigin := 0;

Line 1145: BSC_MO_HELPER_PKG.writeTmp('Production table altered', FND_LOG.LEVEL_STATEMENT, false);

1141: END IF;
1142: End If;
1143: <>
1144: IF ( Tabla.isProductionTable AND Tabla.isProductionTableAltered) THEN
1145: BSC_MO_HELPER_PKG.writeTmp('Production table altered', FND_LOG.LEVEL_STATEMENT, false);
1146: BSC_MO_HELPER_PKG.write_to_stack('Production table altered');
1147: -- table has been altered, so insert into bsc_db_tables_cols
1148: If Tabla.Type = 1 Then
1149: BSC_MO_HELPER_PKG.write_to_stack('Table Type=1');

Line 1174: BSC_MO_HELPER_PKG.writeTmp('Considering '||Tabla.data(i).fieldName, FND_LOG.LEVEL_STATEMENT, false);

1170: Tabla_originTable := BSC_DBGEN_UTILS.get_source_table_names(Tabla.name);
1171: Tabla_originTable(Tabla_originTable.count) := Tabla.Name;
1172: FOR i IN Tabla.data.first..Tabla.data.last LOOP
1173: l_measure := Tabla.data(i);
1174: BSC_MO_HELPER_PKG.writeTmp('Considering '||Tabla.data(i).fieldName, FND_LOG.LEVEL_STATEMENT, false);
1175: BSC_MO_HELPER_PKG.write_this(Tabla.data(i));
1176: IF Tabla.data(i).changeType='NEW' THEN -- new column, insert into db_tables_cols
1177: If projection = 1 Then
1178: l_temp := BSC_MO_HELPER_PKG.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, l_measure.fieldName, l_measure.source);

Line 1179: BSC_MO_HELPER_PKG.writeTmp('gLov, l_temp='||l_temp, FND_LOG.LEVEL_STATEMENT, false);

1175: BSC_MO_HELPER_PKG.write_this(Tabla.data(i));
1176: IF Tabla.data(i).changeType='NEW' THEN -- new column, insert into db_tables_cols
1177: If projection = 1 Then
1178: l_temp := BSC_MO_HELPER_PKG.findIndex(BSC_METADATA_OPTIMIZER_PKG.gLov, l_measure.fieldName, l_measure.source);
1179: BSC_MO_HELPER_PKG.writeTmp('gLov, l_temp='||l_temp, FND_LOG.LEVEL_STATEMENT, false);
1180: l_prj_method := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;
1181: Else
1182: l_prj_method := 0;
1183: End If;

Line 1184: BSC_MO_HELPER_PKG.writeTmp('l_prj_method='||l_prj_method, FND_LOG.LEVEL_STATEMENT, false);

1180: l_prj_method := BSC_METADATA_OPTIMIZER_PKG.gLov(l_temp).prjMethod;
1181: Else
1182: l_prj_method := 0;
1183: End If;
1184: BSC_MO_HELPER_PKG.writeTmp('l_prj_method='||l_prj_method, FND_LOG.LEVEL_STATEMENT, false);
1185: FOR j IN Tabla_originTable.first..Tabla_originTable.last LOOP
1186: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
1187: BSC_MO_HELPER_PKG.writeTmp('INSERT DB_TABLES_COLS5: Table_name = '||Tabla_originTable(j)||', column_type = A, Column Name= '||
1188: l_measure.fieldName||', source='||l_measure.source||', projection='||l_prj_method||', origin = '||l_measure.Origin );

Line 1208: BSC_MO_HELPER_PKG.writeTmp('Checkpoint 11 '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, false);

1204: END IF;
1205: EXIT WHEN l_index1 = BSC_METADATA_OPTIMIZER_PKG.gTables.last;
1206: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gTables.next(l_index1);
1207: END LOOP;
1208: BSC_MO_HELPER_PKG.writeTmp('Checkpoint 11 '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, false);
1209:
1210: --BULK DELETES
1211: FORALL i IN 1..l_db_calc_1_delete.count
1212: DELETE FROM BSC_DB_CALCULATIONS WHERE TABLE_NAME = l_db_calc_1_delete(i) AND CALCULATION_TYPE = 1;

Line 1226: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);

1222: EXCEPTION
1223: WHEN others THEN
1224: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1225: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1226: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1227: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1228: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1229: END LOOP;
1230: FOR i IN 1..l_tab_rels.count LOOP

Line 1228: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);

1224: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1225: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1226: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1227: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1228: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1229: END LOOP;
1230: FOR i IN 1..l_tab_rels.count LOOP
1231: bsc_mo_helper_pkg.writeTmp('Table='||l_tab_rels(i).table_name||', Source='||l_tab_rels(i).source_table_name||', Type='||l_tab_rels(i).relation_type,FND_LOG.LEVEL_EXCEPTION, true);
1232: END LOOP;

Line 1231: bsc_mo_helper_pkg.writeTmp('Table='||l_tab_rels(i).table_name||', Source='||l_tab_rels(i).source_table_name||', Type='||l_tab_rels(i).relation_type,FND_LOG.LEVEL_EXCEPTION, true);

1227: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1228: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1229: END LOOP;
1230: FOR i IN 1..l_tab_rels.count LOOP
1231: bsc_mo_helper_pkg.writeTmp('Table='||l_tab_rels(i).table_name||', Source='||l_tab_rels(i).source_table_name||', Type='||l_tab_rels(i).relation_type,FND_LOG.LEVEL_EXCEPTION, true);
1232: END LOOP;
1233: END;
1234:
1235: BEGIN

Line 1241: bsc_mo_helper_pkg.writeTmp('Insert calculations: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);

1237: INSERT INTO BSC_DB_CALCULATIONS VALUES l_tab_db_calculations(i);
1238: EXCEPTION
1239: WHEN others THEN
1240:
1241: bsc_mo_helper_pkg.writeTmp('Insert calculations: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);
1242: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1243: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1244: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1245: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||

Line 1244: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);

1240:
1241: bsc_mo_helper_pkg.writeTmp('Insert calculations: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);
1242: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1243: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1244: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1245: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1246: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1247: END LOOP;
1248: END;

Line 1246: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);

1242: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1243: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1244: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1245: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1246: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1247: END LOOP;
1248: END;
1249:
1250: BEGIN

Line 1256: bsc_mo_helper_pkg.writeTmp('Insert tables: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);

1252: INSERT INTO BSC_DB_TABLES VALUES l_tab_db_tables(i);
1253: EXCEPTION
1254: WHEN others THEN
1255:
1256: bsc_mo_helper_pkg.writeTmp('Insert tables: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);
1257: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1258: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1259: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1260: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||

Line 1259: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);

1255:
1256: bsc_mo_helper_pkg.writeTmp('Insert tables: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);
1257: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1258: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1259: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1260: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1261: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1262: END LOOP;
1263: END;

Line 1261: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);

1257: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1258: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1259: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1260: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1261: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1262: END LOOP;
1263: END;
1264:
1265: BEGIN

Line 1271: bsc_mo_helper_pkg.writeTmp('Insert Cols: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);

1267: INSERT INTO BSC_DB_TABLES_COLS VALUES l_tab_db_tables_cols(i);
1268: EXCEPTION
1269: WHEN others THEN
1270:
1271: bsc_mo_helper_pkg.writeTmp('Insert Cols: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);
1272: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1273: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1274: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1275: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||

Line 1274: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);

1270:
1271: bsc_mo_helper_pkg.writeTmp('Insert Cols: Number of errors is ' || SQL%BULK_EXCEPTIONS.COUNT, FND_LOG.LEVEL_EXCEPTION, true);
1272: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1273: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1274: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1275: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1276: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1277: END LOOP;
1278: END;

Line 1276: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);

1272: FOR i IN 1.. SQL%BULK_EXCEPTIONS.COUNT LOOP
1273: bsc_mo_helper_pkg.writeTmp('Error ' || i || ' occurred during '||
1274: 'iteration ' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX, FND_LOG.LEVEL_EXCEPTION, true);
1275: bsc_mo_helper_pkg.writeTmp('Oracle error is ' ||
1276: SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE),FND_LOG.LEVEL_EXCEPTION, true);
1277: END LOOP;
1278: END;
1279:
1280:

Line 1296: BSC_MO_HELPER_PKG.writeTmp('Going to configure Profit Calculations '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);

1292: End If;
1293: EXIT WHEN l_index1 = BSC_METADATA_OPTIMIZER_PKG.gTables.last;
1294: l_index1 := BSC_METADATA_OPTIMIZER_PKG.gTables.next(l_index1);
1295: END LOOP;
1296: BSC_MO_HELPER_PKG.writeTmp('Going to configure Profit Calculations '||bsc_mo_helper_pkg.get_time, FND_LOG.LEVEL_STATEMENT, true);
1297:
1298: --BSC-MV Note: Now that all the Loader metadata is configured, We need to configure
1299: --the Profit calculation in the base tables. It is going to call a Loader API
1300: --to do it. The same API is re-used in upgrade.

Line 1310: bsc_mo_helper_pkg.writeTmp( ' Exception in Loader Configuration:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

1306: BSC_MO_HELPER_PKG.writeTmp('Completed Loader Configuration '||bsc_mo_helper_pkg.get_time);
1307: END IF;
1308:
1309: EXCEPTION WHEN OTHERS THEN
1310: bsc_mo_helper_pkg.writeTmp( ' Exception in Loader Configuration:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1311: fnd_message.set_name('BSC', 'BSC_LOAD_CONFIGURATION_FAILED');
1312: app_exception.raise_exception;
1313: RAISE;
1314: End;

Line 1387: bsc_mo_helper_pkg.write_this(colDatos, FND_LOG.LEVEL_STATEMENT, false);

1383: --including the target tables created for the indicator
1384: InitarrTablesIndic( Indic, Configuracion, arrTables, numTables, arrIndicTables, numIndicTables);
1385: --Initialize the collection of data columns of the indicator
1386: colDatos := BSC_MO_INDICATOR_PKG.GetDataFields(Indic, Configuracion, True);
1387: bsc_mo_helper_pkg.write_this(colDatos, FND_LOG.LEVEL_STATEMENT, false);
1388: --Reconfigure
1389: --The only non-structural changes that could happen are:
1390: --Change in the rollup method
1391: --Change in the projection method

Line 1434: BSC_MO_HELPER_PKG.writeTmp('Error while executing : '||ddl_sql||', Error is '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

1430: begin
1431: BSC_MO_HELPER_PKG.Do_DDL( ddl_sql , ad_ddl.alter_table, l_table_name);
1432: newColumnFlag := True;
1433: exception when others then
1434: BSC_MO_HELPER_PKG.writeTmp('Error while executing : '||ddl_sql||', Error is '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1435: raise;
1436: end;
1437: End If;
1438: END IF;

Line 1620: bsc_mo_helper_pkg.writeTmp('Exception in ReConfigureUploadFieldsIndic:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);

1616: l_index1 := colConfiguraciones.next(l_index1);
1617: END LOOP;
1618: bsc_mo_helper_pkg.writeTmp('Completed ReConfigureUploadFieldsIndic');
1619: EXCEPTION WHEN OTHERS THEN
1620: bsc_mo_helper_pkg.writeTmp('Exception in ReConfigureUploadFieldsIndic:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1621: bsc_mo_helper_pkg.writeTmp('Stack is : '||l_stack, FND_LOG.LEVEL_UNEXPECTED, true);
1622: raise;
1623: End ;
1624:

Line 1621: bsc_mo_helper_pkg.writeTmp('Stack is : '||l_stack, FND_LOG.LEVEL_UNEXPECTED, true);

1617: END LOOP;
1618: bsc_mo_helper_pkg.writeTmp('Completed ReConfigureUploadFieldsIndic');
1619: EXCEPTION WHEN OTHERS THEN
1620: bsc_mo_helper_pkg.writeTmp('Exception in ReConfigureUploadFieldsIndic:'||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1621: bsc_mo_helper_pkg.writeTmp('Stack is : '||l_stack, FND_LOG.LEVEL_UNEXPECTED, true);
1622: raise;
1623: End ;
1624:
1625: END BSC_MO_LOADER_CONFIG_PKG;