DBA Data[Home] [Help]

APPS.BSC_DBGEN_BSC_READER dependencies on FND_LOG

Line 179: bsc_mo_helper_pkg.writeTmp('Exception in load_system_measures: '||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);

175: g_sys_measures_loaded := true;
176: return;
177: exception when others then
178: l_stmt := sqlerrm;
179: bsc_mo_helper_pkg.writeTmp('Exception in load_system_measures: '||l_stmt, FND_LOG.LEVEL_UNEXPECTED, true);
180: bsc_mo_helper_pkg.TerminateWithError('BSC_VAR_LIST_INIT_FAILED', 'load_system_measures');
181: raise;
182: End;
183:

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

1058: CLOSE cv;
1059: END IF;
1060: return Get_Fact_Info(null, null, l_fact_ids);
1061: EXCEPTION WHEN OTHERS THEN
1062: bsc_mo_helper_pkg.writeTmp('Exception in Get_Facts_To_Recalculate : '||sqlerrm, FND_LOG.LEVEL_EXCEPTION, true);
1063: raise;
1064: END;
1065:
1066: FUNCTION Fact_ID_Exists(p_facts IN BSC_DBGEN_STD_METADATA.tab_clsFact, p_fact_id IN NUMBER) RETURN BOOLEAN IS

Line 1193: bsc_mo_helper_pkg.writeTmp( 'Inside GetMeasuresForFact, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

1189: TYPE CurTyp IS REF CURSOR;
1190: cv CurTyp;
1191: l_measure_source varchar2(30);
1192: BEGIN
1193: bsc_mo_helper_pkg.writeTmp( 'Inside GetMeasuresForFact, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
1194: OPEN cv for l_stmt2 USING BSC_METADATA_OPTIMIZER_PKG.C_PFORMULASOURCE,
1195: BSC_METADATA_OPTIMIZER_PKG.C_PAVGL,
1196: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLTOTAL,
1197: BSC_METADATA_OPTIMIZER_PKG.C_PAVGLCOUNTER, p_dim_set, to_number(p_fact);

Line 1357: bsc_mo_helper_pkg.writeTmp( 'Compl. GetMeasuresForFact, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);

1353: END IF;
1354: END Loop;
1355: close cv;
1356:
1357: bsc_mo_helper_pkg.writeTmp( 'Compl. GetMeasuresForFact, System time is '||bsc_mo_helper_pkg.get_time, fnd_log.level_statement, true);
1358: return colMeasures;
1359: EXCEPTION WHEN OTHERS THEN
1360: g_error := sqlerrm;
1361: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.get_measures_for_fact, p_fact='||p_fact||', dimset='||p_dim_set||g_error);