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_DBGEN_BSC_READER dependencies on FND_FILE

Line 38: fnd_file.put_line(fnd_file.log, 'Exception in IsIndicatorPnL for '||Ind||' : '||sqlerrm);

34: Else
35: return false;
36: END IF;
37: EXCEPTION WHEN OTHERS THEN
38: fnd_file.put_line(fnd_file.log, 'Exception in IsIndicatorPnL for '||Ind||' : '||sqlerrm);
39: RAISE;
40: End;
41:
42: --****************************************************************************

Line 69: fnd_file.put_line(fnd_file.log, 'Exception in IsIndicatorBalance for '||ind||' : '||sqlerrm);

65: Else
66: return false;
67: END IF;
68: EXCEPTION WHEN OTHERS THEN
69: fnd_file.put_line(fnd_file.log, 'Exception in IsIndicatorBalance for '||ind||' : '||sqlerrm);
70: RAISE;
71: End;
72:
73: --****************************************************************************

Line 99: fnd_file.put_line(fnd_file.log, 'Exception in IsIndicatorBalanceOrPnL for '||ind||' : '||sqlerrm);

95: Else
96: return false;
97: END IF;
98: EXCEPTION WHEN OTHERS THEN
99: fnd_file.put_line(fnd_file.log, 'Exception in IsIndicatorBalanceOrPnL for '||ind||' : '||sqlerrm);
100: RAISE;
101: End;
102:
103: --***************************************************************************

Line 217: fnd_file.put_line(fnd_file.log, 'Exception in sys_measure_exists for field '||p_measure_name||' : '||sqlerrm);

213: i := g_sys_measures.next(i);
214: END LOOP;
215: return false;
216: EXCEPTION WHEN OTHERS THEN
217: fnd_file.put_line(fnd_file.log, 'Exception in sys_measure_exists for field '||p_measure_name||' : '||sqlerrm);
218: raise;
219: End ;
220:
221: --****************************************************************************

Line 255: Fnd_File.Put_Line(Fnd_File.Log, 'Exception dataFieldExists, '||sqlerrm);

251: END LOOP;
252: return false;
253:
254: EXCEPTION WHEN OTHERS THEN
255: Fnd_File.Put_Line(Fnd_File.Log, 'Exception dataFieldExists, '||sqlerrm);
256: raise;
257: End;
258:
259:

Line 304: Fnd_File.Put_Line(Fnd_File.Log, 'Exception in InsertInDBMeasureCols '||g_error);

300:
301:
302: EXCEPTION WHEN OTHERS THEN
303: g_error := sqlerrm;
304: Fnd_File.Put_Line(Fnd_File.Log, 'Exception in InsertInDBMeasureCols '||g_error);
305: RAISE;
306:
307: End;
308:

Line 432: Fnd_File.Put_Line(Fnd_File.Log, 'Exception in AddInternalColumnInDB : '||g_error);

428:
429:
430: EXCEPTION WHEN OTHERS THEN
431: g_error := sqlerrm;
432: Fnd_File.Put_Line(Fnd_File.Log, 'Exception in AddInternalColumnInDB : '||g_error);
433: raise;
434: End;
435: */
436:

Line 461: Fnd_File.Put_Line(Fnd_File.Log, 'Exception in SetMeasurePropertyDB : '||g_error);

457: AND TYPE = 0 AND NVL(SOURCE, 'BSC') = 'BSC';
458:
459: EXCEPTION WHEN OTHERS THEN
460: g_error := sqlerrm;
461: Fnd_File.Put_Line(Fnd_File.Log, 'Exception in SetMeasurePropertyDB : '||g_error);
462: raise;
463: End;
464:
465: --***************************************************************************

Line 515: Fnd_File.Put_Line(Fnd_File.Log, 'Exception in GetAggregateFunction '||g_error);

511: END IF;
512: close c1;
513: EXCEPTION WHEN OTHERS THEN
514: g_error := sqlerrm;
515: Fnd_File.Put_Line(Fnd_File.Log, 'Exception in GetAggregateFunction '||g_error);
516: RAISE;
517:
518: End;
519:

Line 734: fnd_file.put_line(fnd_file.log, 'Exception in is_parent_MN : '||g_error||', p_child_level='||p_child_level||', p_parent_level='||p_parent_level);

730: return false;
731: END IF;
732: EXCEPTION WHEN OTHERS THEN
733: g_error := sqlerrm;
734: fnd_file.put_line(fnd_file.log, 'Exception in is_parent_MN : '||g_error||', p_child_level='||p_child_level||', p_parent_level='||p_parent_level);
735: raise;
736: End;
737:
738:

Line 796: fnd_file.put_line(fnd_file.log, 'Exception in getDimensionIndex '||g_error);

792: END IF;
793: return -1;
794: EXCEPTION WHEN OTHERS THEN
795: g_error := sqlerrm;
796: fnd_file.put_line(fnd_file.log, 'Exception in getDimensionIndex '||g_error);
797: RAISE;
798: End ;
799:
800:

Line 823: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.insert_parents '||g_error);

819: end loop;
820: END IF;
821: EXCEPTION WHEN OTHERS THEN
822: g_error := sqlerrm;
823: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.insert_parents '||g_error);
824: RAISE;
825: END;
826:
827: FUNCTION configure_parent_periods(p_periodicity_list IN OUT nocopy BSC_DBGEN_STD_METADATA.tab_clsPeriodicity)

Line 875: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.configure_parent_periods '||g_error);

871: commit;
872: return p_periodicity_list;
873: EXCEPTION WHEN OTHERS THEN
874: g_error := sqlerrm;
875: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.configure_parent_periods '||g_error);
876: RAISE;
877: END;
878:
879:

Line 942: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.get_fact_info '||g_error);

938: END Loop;
939: CLOSE cv;
940: EXCEPTION WHEN OTHERS THEN
941: g_error := sqlerrm;
942: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.get_fact_info '||g_error);
943: RAISE;
944:
945: END;
946: FUNCTION Get_Fact_Info(p_process_id IN NUMBER, p_prototype_flag IN NUMBER) return BSC_DBGEN_STD_METADATA.tab_clsFact IS

Line 1107: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.get_highest_s_table '||g_error);

1103: CLOSE cSTable;
1104: return l_s_tablename;
1105: EXCEPTION WHEN OTHERS THEN
1106: g_error := sqlerrm;
1107: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.get_highest_s_table '||g_error);
1108: RAISE;
1109: END;
1110:
1111: FUNCTION get_lowest_s_table(p_fact IN VARCHAR2, p_dim_set IN NUMBER) return VARCHAR2 IS

Line 1148: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.get_lowest_s_table'||g_error);

1144: END IF;
1145: return l_fact_list;
1146: EXCEPTION WHEN OTHERS THEN
1147: g_error := sqlerrm;
1148: fnd_file.put_line(fnd_file.log, 'Exception in bsc_dbgen_bsc_reader.get_lowest_s_table'||g_error);
1149: RAISE;
1150: END;
1151:
1152:

Line 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);

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);
1362: RAISE;
1363: END;
1364:
1365: FUNCTION Get_Measures_For_Fact(p_fact IN VARCHAR2, p_dim_set IN NUMBER, p_include_derived_columns IN BOOLEAN default false) return BSC_DBGEN_STD_METADATA.tab_clsMeasure IS

Line 1424: fnd_file.put_line(FND_FILE.LOG, 'Error in Get_Measures_For_Fact:fact='||p_fact||', error='||sqlerrm);

1420: END LOOP;
1421: return colMeasures;
1422:
1423: EXCEPTION WHEN OTHERS THEN
1424: fnd_file.put_line(FND_FILE.LOG, 'Error in Get_Measures_For_Fact:fact='||p_fact||', error='||sqlerrm);
1425: raise;
1426: END;
1427:
1428: --****************************************************************************

Line 1464: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Periodicities_For_Fact:fact='||p_fact||',error='||sqlerrm);

1460: colPeriodicities := configure_parent_periods(colPeriodicities);
1461: return colPeriodicities;
1462: EXCEPTION WHEN OTHERS THEN
1463:
1464: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Periodicities_For_Fact:fact='||p_fact||',error='||sqlerrm);
1465: raise;
1466: End;
1467:
1468:

Line 1616: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Dimensions_For_Fact:fact='||p_fact||', dimset='||p_dim_set||', missing levels='||bsc_mo_helper_pkg.boolean_decode(p_include_missing_levels)||', error='||sqlerrm);

1612: close cv;
1613:
1614: return l_dimensions;
1615: EXCEPTION WHEN OTHERS THEN
1616: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Dimensions_For_Fact:fact='||p_fact||', dimset='||p_dim_set||', missing levels='||bsc_mo_helper_pkg.boolean_decode(p_include_missing_levels)||', error='||sqlerrm);
1617: raise;
1618: END;
1619:
1620:

Line 1658: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Parents_For_Level:p_level='||p_level_name||', p_num_levels='||p_num_levels||', error='||sqlerrm);

1654: l_count := l_count + 1;
1655: END LOOP;
1656: return l_tab_rels;
1657: EXCEPTION WHEN OTHERS THEN
1658: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Parents_For_Level:p_level='||p_level_name||', p_num_levels='||p_num_levels||', error='||sqlerrm);
1659: raise;
1660: END;
1661:
1662: function get_children_for_level(

Line 1695: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.get_children_for_level:p_level='||p_level_name||', p_num_levels='||p_num_levels||', error='||sqlerrm);

1691: l_tab_rels(l_tab_rels.count + 1) := l_lvl_rel;
1692: END LOOP;
1693: return l_tab_rels;
1694: EXCEPTION WHEN OTHERS THEN
1695: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.get_children_for_level:p_level='||p_level_name||', p_num_levels='||p_num_levels||', error='||sqlerrm);
1696: raise;
1697: END;
1698:
1699: function get_level_info(

Line 1717: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Level_Info:level='||p_level||', error='||sqlerrm);

1713: l_level.Level_PK_Datatype := BSC_DBGEN_UTILS.get_datatype(p_level, l_level.Level_PK);
1714: l_level.level_type := 0; -- normal
1715: return l_level;
1716: Exception when others then
1717: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Level_Info:level='||p_level||', error='||sqlerrm);
1718: raise;
1719: End;
1720:
1721: function get_facts_for_levels(p_levels dbms_sql.varchar2_table) return BSC_DBGEN_STD_METADATA.tab_clsFact is

Line 1759: fnd_file.put_line(FND_FILE.LOG, 'Exception in get_facts_for_levels :'||sqlerrm);

1755: END LOOP;
1756: CLOSE cv;
1757: return l_facts;
1758: Exception when others then
1759: fnd_file.put_line(FND_FILE.LOG, 'Exception in get_facts_for_levels :'||sqlerrm);
1760: for i in p_levels.first..p_levels.last loop
1761: fnd_file.put_line(FND_FILE.LOG, 'Level '||i||':'||p_levels(i));
1762: end loop;
1763: raise;

Line 1761: fnd_file.put_line(FND_FILE.LOG, 'Level '||i||':'||p_levels(i));

1757: return l_facts;
1758: Exception when others then
1759: fnd_file.put_line(FND_FILE.LOG, 'Exception in get_facts_for_levels :'||sqlerrm);
1760: for i in p_levels.first..p_levels.last loop
1761: fnd_file.put_line(FND_FILE.LOG, 'Level '||i||':'||p_levels(i));
1762: end loop;
1763: raise;
1764: End;
1765:

Line 1788: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_dim_sets_for_fact:'||p_fact||':'||sqlerrm);

1784: END LOOP;
1785: CLOSE cDimSets;
1786: return l_dim_sets;
1787: Exception when others then
1788: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_dim_sets_for_fact:'||p_fact||':'||sqlerrm);
1789: raise;
1790: End;
1791:
1792:

Line 1809: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_s_views:'||p_fact||','||p_dim_set||':'||sqlerrm);

1805: l_mv_list(l_mv_list.count+1) := i.mv_name;
1806: END LOOP;
1807: return l_mv_list;
1808: Exception when others then
1809: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_s_views:'||p_fact||','||p_dim_set||':'||sqlerrm);
1810: raise;
1811: End;
1812:
1813:

Line 1848: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_levels_for_Table:'||p_table_name||','||p_table_type||':'||sqlerrm);

1844: l_level_list(l_level_list.count+1) := l_level;
1845: END LOOP;
1846: return l_level_list;
1847: Exception when others then
1848: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_levels_for_Table:'||p_table_name||','||p_table_type||':'||sqlerrm);
1849: raise;
1850: End;
1851:
1852:

Line 2009: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_b_table_measures_for_fact:'||p_fact||','||p_dim_set||','||p_base_table||','||bsc_mo_helper_pkg.boolean_decode(p_include_derived_columns)||':'||sqlerrm);

2005: END IF;
2006: return l_measure_list;
2007:
2008: Exception when others then
2009: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_b_table_measures_for_fact:'||p_fact||','||p_dim_set||','||p_base_table||','||bsc_mo_helper_pkg.boolean_decode(p_include_derived_columns)||':'||sqlerrm);
2010: raise;
2011: End;
2012:
2013: function get_periodicity_for_table(

Line 2025: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_periodicity_for_table:'||p_table||':'||sqlerrm);

2021: CLOSE cTablePer;
2022: return l_per;
2023:
2024: Exception when others then
2025: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_periodicity_for_table:'||p_table||':'||sqlerrm);
2026: raise;
2027: End;
2028:
2029: function get_db_calendar_column(

Line 2042: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_db_calendar_column: calendar='||p_calendar_id||',per id='||p_periodicity_id||':'||sqlerrm);

2038: FETCH cDBColumn INTO l_db_column;
2039: CLOSE cDBColumn;
2040: return l_db_column;
2041: Exception when others then
2042: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_db_calendar_column: calendar='||p_calendar_id||',per id='||p_periodicity_id||':'||sqlerrm);
2043: raise;
2044: End;
2045:
2046:

Line 2107: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_zero_code_levels:'||p_fact||','||p_dim_set||':'||sqlerrm);

2103: l_level_list(l_level_list.count+1) := l_level;
2104: END LOOP;
2105: return l_level_list;
2106: Exception when others then
2107: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_zero_code_levels:'||p_fact||','||p_dim_set||':'||sqlerrm);
2108: raise;
2109: End;
2110:
2111: function get_base_tables_for_dim_set(

Line 2144: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_base_tables_for_dim_set:'||p_fact||','||p_dim_set||','||bsc_mo_helper_pkg.boolean_decode(p_targets)||':'||sqlerrm);

2140: l_table_list(l_table_list.count+1) := i.table_name;
2141: END LOOP;
2142: return l_table_list;
2143: Exception when others then
2144: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_base_tables_for_dim_set:'||p_fact||','||p_dim_set||','||bsc_mo_helper_pkg.boolean_decode(p_targets)||':'||sqlerrm);
2145: raise;
2146: END;
2147:
2148:

Line 2204: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Filter_for_dim_level:'||p_fact||','||p_level||':'||sqlerrm);

2200: CLOSE cFilter;
2201: return null;
2202: END IF;
2203: Exception when others then
2204: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_Filter_for_dim_level:'||p_fact||','||p_level||':'||sqlerrm);
2205: raise;
2206: End;
2207:
2208: function get_year_periodicity_for_fact(p_fact varchar2) return number is

Line 2252: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.get_current_year_for_fact:'||p_fact||':'||sqlerrm);

2248: CLOSE cCurrentYearFromCal;
2249: return l_current_year;
2250:
2251: Exception when others then
2252: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.get_current_year_for_fact:'||p_fact||':'||sqlerrm);
2253: raise;
2254: End;
2255:
2256: --added Jan 12, 2006

Line 2372: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_current_period_for_fact:'||p_fact||','||p_periodicity||':'||sqlerrm);

2368: CLOSE cv;
2369: return l_current_period;
2370:
2371: Exception when others then
2372: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_current_period_for_fact:'||p_fact||','||p_periodicity||':'||sqlerrm);
2373: raise;
2374:
2375: End;
2376:

Line 2403: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.is_projection_enabled_for_kpi:'||p_kpi||':'||sqlerrm);

2399: END LOOP;
2400: END IF;
2401: RETURN 'N';
2402: Exception when others then
2403: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.is_projection_enabled_for_kpi:'||p_kpi||':'||sqlerrm);
2404: raise;
2405:
2406: End;
2407:

Line 2424: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_all_facts_in_aw:'||sqlerrm);

2420: l_facts(l_facts.count+1) := i.indicator;
2421: END LOOP;
2422: return l_facts;
2423: Exception when others then
2424: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_all_facts_in_aw:'||sqlerrm);
2425: raise;
2426:
2427: End;
2428:

Line 2447: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.get_z_s_views:'||p_fact||','||p_dim_set||':'||sqlerrm);

2443: l_mv_list(l_mv_list.count+1) := i.mv_name;
2444: END LOOP;
2445: return l_mv_list;
2446: Exception when others then
2447: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.get_z_s_views:'||p_fact||','||p_dim_set||':'||sqlerrm);
2448: raise;
2449:
2450: End;
2451:

Line 2477: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_all_levels_for_fact:'||p_fact||':'||sqlerrm);

2473: END LOOP;
2474: CLOSE cv;
2475: return l_return;
2476: Exception when others then
2477: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_all_levels_for_fact:'||p_fact||':'||sqlerrm);
2478: raise;
2479: END;
2480:
2481: function get_dimension_level_short_name(p_dim_level_table_name IN VARCHAR2) return VARCHAR2

Line 2529: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_measures_for_short_names:'||sqlerrm);

2525: END IF;
2526: END LOOP;
2527: return l_measure_cols;
2528: Exception when others then
2529: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_measures_for_short_names:'||sqlerrm);
2530: raise;
2531: end;
2532:
2533:

Line 2568: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_dim_levels_for_short_names:'||':'||sqlerrm);

2564: END IF;
2565: END LOOP;
2566: return l_dim_levels;
2567: Exception when others then
2568: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_dim_levels_for_short_names:'||':'||sqlerrm);
2569: raise;
2570: end;
2571:
2572: function get_fact_implementation_type(p_fact in varchar2) return varchar2 is

Line 2598: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_fact_implementation_type:'||p_fact||':'||sqlerrm);

2594: end if;
2595: end if;
2596: return l_impl_type;
2597: Exception when others then
2598: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_fact_implementation_type:'||p_fact||':'||sqlerrm);
2599: raise;
2600: end;
2601:
2602: function is_level_used_by_prod_aw_fact(p_level_name in varchar2) return boolean is

Line 2621: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.is_level_used_by_prod_aw_fact:'||p_level_name||':'||sqlerrm);

2617: return true;
2618: end if;
2619: return false;
2620: Exception when others then
2621: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.is_level_used_by_prod_aw_fact:'||p_level_name||':'||sqlerrm);
2622: raise;
2623: end;
2624:
2625: function is_level_used_by_aw_fact(p_level_name in varchar2) return boolean is

Line 2665: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.is_level_used_by_aw_fact:'||p_level_name||':'||sqlerrm);

2661: end if;
2662: --dbms_output.put_line('returning false in is_level_used_by_aw_fact');
2663: return false;
2664: Exception when others then
2665: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.is_level_used_by_aw_fact:'||p_level_name||':'||sqlerrm);
2666: raise;
2667: end;
2668:
2669: function get_parents_for_level_aw(

Line 2715: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_parent_levels_for_aw:'||p_level_name||',levels='||p_num_levels||', error:'||sqlerrm);

2711: end if;
2712: END LOOP;
2713: return l_tab_rels;
2714: Exception when others then
2715: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_parent_levels_for_aw:'||p_level_name||',levels='||p_num_levels||', error:'||sqlerrm);
2716: raise;
2717: END;
2718:
2719: function get_children_for_level_aw(

Line 2756: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_children_for_level_aw:'||p_level_name||':'||sqlerrm);

2752: end if;
2753: END LOOP;
2754: return l_tab_rels;
2755: Exception when others then
2756: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_children_for_level_aw:'||p_level_name||':'||sqlerrm);
2757: raise;
2758: END;
2759:
2760:

Line 2787: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.get_target_per_for_b_table:'||p_fact||','||p_dim_set||','||p_b_table||':'||sqlerrm);

2783: l_periodicities(l_periodicities.count+1):=i.periodicity_id;
2784: END LOOP;
2785: return l_periodicities;
2786: Exception when others then
2787: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.get_target_per_for_b_table:'||p_fact||','||p_dim_set||','||p_b_table||':'||sqlerrm);
2788: raise;
2789: END;
2790:
2791:

Line 2941: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_fact_cols_from_b_table:'||p_fact||','||p_dim_set||','||p_b_table_name||','||p_col_type||':'||sqlerrm);

2937: commit;
2938: return l_col_maps;
2939: Exception when others then
2940: commit;
2941: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.Get_fact_cols_from_b_table:'||p_fact||','||p_dim_set||','||p_b_table_name||','||p_col_type||':'||sqlerrm);
2942: raise;
2943:
2944: End;
2945:

Line 2997: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.set_table_property:table='||p_table_name||', property='||p_property_name||', value='||p_property_value||':'||sqlerrm);

2993: set properties = l_final_value
2994: where table_name = p_table_name;
2995: return;
2996: Exception when others then
2997: fnd_file.put_line(FND_FILE.LOG, 'Error in BSC_DBGEN_BSC_READER.set_table_property:table='||p_table_name||', property='||p_property_name||', value='||p_property_value||':'||sqlerrm);
2998: raise;
2999: end;
3000:
3001: END BSC_DBGEN_BSC_READER ;