APPS.BSC_MO_UI_PKG dependencies on FND_LOG

Line 112: bsc_mo_helper_pkg.writeTmp( 'Error in InsertRelatedTables :'||l_error, FND_LOG.LEVEL_UNEXPECTED);

108: END IF;
109:
110: EXCEPTION WHEN OTHERS THEN
111: l_error := sqlerrm;
112: bsc_mo_helper_pkg.writeTmp( 'Error in InsertRelatedTables :'||l_error, FND_LOG.LEVEL_UNEXPECTED);
113: RAISE;
114: End;
115:
116:

Line 310: bsc_mo_helper_pkg.writeTmp('Completed MarkIndicsForNonStrucChanges', FND_LOG.LEVEL_PROCEDURE);

306: l_stack := l_stack ||' Check 5 ';
307: END IF;
308:
309: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN
310: bsc_mo_helper_pkg.writeTmp('Completed MarkIndicsForNonStrucChanges', FND_LOG.LEVEL_PROCEDURE);
311: END IF;
312:
313: EXCEPTION WHEN OTHERS THEN
314: l_error := sqlerrm;

Line 378: bsc_mo_helper_pkg.writeTmp('Started CreateDBMeasureByKpiView', FND_LOG.LEVEL_PROCEDURE);

374:
375: PROCEDURE CreateDBMeasureByKpiView IS
376: l_stmt varchar2(1000);
377: BEGIN
378: bsc_mo_helper_pkg.writeTmp('Started CreateDBMeasureByKpiView', FND_LOG.LEVEL_PROCEDURE);
379: l_stmt := ' CREATE OR REPLACE VIEW BSC_DB_MEASURE_BY_KPI_V( INDICATOR, MEASURE_ID ) AS
380: SELECT DB.INDICATOR, DS.MEASURE_ID1 AS MEASURE_ID
381: FROM BSC_KPI_ANALYSIS_MEASURES_B DB, BSC_SYS_DATASETS_B DS
382: WHERE DB.DATASET_ID = DS.DATASET_ID

Line 388: bsc_mo_helper_pkg.writeTmp('Completed CreateDBMeasureByKpiView', FND_LOG.LEVEL_PROCEDURE);

384: SELECT DB.INDICATOR, DS.MEASURE_ID2 AS MEASURE_ID
385: FROM BSC_KPI_ANALYSIS_MEASURES_B DB, BSC_SYS_DATASETS_B DS
386: WHERE DB.DATASET_ID = DS.DATASET_ID AND DS.MEASURE_ID2 IS NOT NULL ';
387: execute immediate l_stmt;
388: bsc_mo_helper_pkg.writeTmp('Completed CreateDBMeasureByKpiView', FND_LOG.LEVEL_PROCEDURE);
389: exception when others then
390: bsc_mo_helper_pkg.writeTmp('Error in CreateDBMeasureByKpiView :'||sqlerrm, FND_LOG.LEVEL_EXCEPTION, true);
391: raise;
392: END;

Line 390: bsc_mo_helper_pkg.writeTmp('Error in CreateDBMeasureByKpiView :'||sqlerrm, FND_LOG.LEVEL_EXCEPTION, true);

386: WHERE DB.DATASET_ID = DS.DATASET_ID AND DS.MEASURE_ID2 IS NOT NULL ';
387: execute immediate l_stmt;
388: bsc_mo_helper_pkg.writeTmp('Completed CreateDBMeasureByKpiView', FND_LOG.LEVEL_PROCEDURE);
389: exception when others then
390: bsc_mo_helper_pkg.writeTmp('Error in CreateDBMeasureByKpiView :'||sqlerrm, FND_LOG.LEVEL_EXCEPTION, true);
391: raise;
392: END;
393:
394: -- pProcessId = -ICX_Session_Id (For cleanup)

Line 596: BSC_MO_HELPER_PKG.writeTmp('Exception in updateRelatedIndicators : '||l_error, FND_LOG.LEVEL_EXCEPTION);

592: END IF;
593:
594: EXCEPTION WHEN OTHERS THEN
595: l_error := sqlerrm;
596: BSC_MO_HELPER_PKG.writeTmp('Exception in updateRelatedIndicators : '||l_error, FND_LOG.LEVEL_EXCEPTION);
597: raise;
598: END;
599:
600: -- Incremental Run call from UI

Line 1289: BSC_MO_HELPER_PKG.writeTmp('Exception in getRelatedIndicators : '||l_error, FND_LOG.LEVEL_EXCEPTION);

1285:
1286: EXCEPTION WHEN OTHERS THEN
1287: ROLLBACK;
1288: l_error := sqlerrm;
1289: BSC_MO_HELPER_PKG.writeTmp('Exception in getRelatedIndicators : '||l_error, FND_LOG.LEVEL_EXCEPTION);
1290: raise;
1291: END;
1292:
1293: PROCEDURE deleteBSCSession(pSession IN NUMBER) IS

Line 1335: BSC_MO_HELPER_PKG.writeTmp('Exception in cleanUITempTable : '||sqlerrm, FND_LOG.LEVEL_EXCEPTION);

1331: BSC_MO_HELPER_PKG.writeTmp( 'Completed cleanUITempTable');
1332: END IF;
1333:
1334: EXCEPTION WHEN OTHERS THEN
1335: BSC_MO_HELPER_PKG.writeTmp('Exception in cleanUITempTable : '||sqlerrm, FND_LOG.LEVEL_EXCEPTION);
1336: raise;
1337: END;
1338:
1339: /*------------------------------------------------------------------------------------------