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

Line 50: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_bsc_schema:'||sqlerrm);

46: END IF;
47: g_bsc_schema := l_bsc_schema;
48: return l_bsc_schema;
49: EXCEPTION when others then
50: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_bsc_schema:'||sqlerrm);
51: raise;
52: end;
53:
54: /*---------------------------------------------------------------------

Line 71: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_apps_schema:'||sqlerrm);

67: FETCH cApps INTO l_schema;
68: CLOSE cApps;
69: return l_schema;
70: EXCEPTION when others then
71: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_apps_schema:'||sqlerrm);
72: raise;
73: END;
74:
75: PROCEDURE init IS

Line 85: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.init:'||sqlerrm);

81: g_bsc_schema := get_bsc_schema;
82: g_apps_schema := get_apps_schema;
83: g_initialized := true;
84: EXCEPTION when others then
85: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.init:'||sqlerrm);
86: raise;
87:
88: END;
89:

Line 112: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_datatype:'||sqlerrm);

108: l_type := l_type ||'('||l_length||')';
109: END IF;
110: return l_type;
111: EXCEPTION when others then
112: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_datatype:'||sqlerrm);
113: raise;
114:
115: END;
116:

Line 139: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number:'||sqlerrm);

135: ' SELECT VALUE_N FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV(''SESSIONID'')'||
136: ' AND VARIABLE_ID = ' || x_variable_id || ')';
137: return l_cond;
138: EXCEPTION when others then
139: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Number:'||sqlerrm);
140: raise;
141: End;
142:
143: --===========================================================================+

Line 157: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number:'||sqlerrm);

153: init;
154: END IF;
155: bsc_apps.Add_Value_Big_In_Cond(x_variable_id , x_value);
156: EXCEPTION when others then
157: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Number:'||sqlerrm);
158: raise;
159: End;
160:
161: --===========================================================================+

Line 180: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Varchar2:'||sqlerrm);

176: cond := 'UPPER('|| x_column_name || ') IN ('||
177: ' SELECT UPPER(VALUE_V) FROM BSC_TMP_BIG_IN_COND WHERE SESSION_ID = USERENV(''SESSIONID'') AND VARIABLE_ID = '||x_variable_id||')';
178: return cond;
179: EXCEPTION when others then
180: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Get_New_Big_In_Cond_Varchar2:'||sqlerrm);
181: raise;
182: End;
183: --===========================================================================+
184: -- Name: Add_Value_Big_In_Cond_Varchar2

Line 198: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Varchar2:'||sqlerrm);

194: END IF;
195: bsc_apps.Add_Value_Big_In_Cond(x_variable_id , x_value);
196:
197: EXCEPTION when others then
198: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.Add_Value_Big_In_Cond_Varchar2:'||sqlerrm);
199: raise;
200: End;
201:
202: FUNCTION get_dbgen_fact_id(p_fact_name IN VARCHAR2, p_application_short_name IN VARCHAR2) RETURN NUMBER IS

Line 216: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_dbgen_fact_id:'||sqlerrm);

212: CLOSE cFactID;
213: return l_fact_id;*/
214: return to_number(p_fact_name);
215: EXCEPTION when others then
216: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_dbgen_fact_id:'||sqlerrm);
217: raise;
218: END;
219:
220: --****************************************************************************

Line 274: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_measure_list:'||sqlerrm||', expression='||p_expression);

270: i := l_measure_list_tmp.next(i);
271: END LOOP;
272: return l_measure_list;
273: EXCEPTION when others then
274: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_measure_list:'||sqlerrm||', expression='||p_expression);
275: raise;
276: End;
277:
278: --***************************************************************************

Line 316: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_kpi_property_value:'||sqlerrm||', p_kpi='||p_kpi||', p_property='||p_property||', p_default='||p_default);

312: return l_value;
313: END IF;
314: return p_default;
315: EXCEPTION when others then
316: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_kpi_property_value:'||sqlerrm||', p_kpi='||p_kpi||', p_property='||p_property||', p_default='||p_default);
317: raise;
318: End;
319:
320: PROCEDURE add_property(

Line 355: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.add_property:'||sqlerrm||', p_name='||p_name||', p_Value='||p_value);

351: l_property.name := p_name;
352: l_property.value := p_value;
353: p_properties(p_properties.last+1) := l_property;
354: EXCEPTION when others then
355: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.add_property:'||sqlerrm||', p_name='||p_name||', p_Value='||p_value);
356: raise;
357: END;
358:
359: FUNCTION get_property_value(p_properties IN BSC_DBGEN_STD_METADATA.tab_ClsProperties, p_name in varchar2) return VARCHAR2

Line 376: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_property_value:'||sqlerrm||', p_name='||p_name);

372: END LOOP;
373: return BSC_DBGEN_STD_METADATA.BSC_PROPERTY_NOT_FOUND ;
374:
375: EXCEPTION when others then
376: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_property_value:'||sqlerrm||', p_name='||p_name);
377: raise;
378: END;
379:
380: FUNCTION get_source_table_names(p_table_name IN VARCHAR2) RETURN DBMS_SQL.VARCHAR2_TABLE IS

Line 395: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_source_table_names:'||sqlerrm||', p_table_name='||p_table_name);

391: l_list(l_list.count) := i.source_table_name;
392: END LOOP;
393: return l_list;
394: EXCEPTION when others then
395: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_source_table_names:'||sqlerrm||', p_table_name='||p_table_name);
396: raise;
397: END;
398:
399: FUNCTION get_table_type(p_table_name IN VARCHAR2) RETURN VARCHAR2

Line 448: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_table_type:'||sqlerrm||', p_table_name='||p_table_name);

444: return 'S';
445: END IF;
446: return null;
447: EXCEPTION when others then
448: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_table_type:'||sqlerrm||', p_table_name='||p_table_name);
449: raise;
450: END;
451:
452: FUNCTION get_mvlog_for_table(p_table_name IN VARCHAR2) RETURN VARCHAR2

Line 467: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_mvlog_for_table:'||sqlerrm||', p_table_name='||p_table_name);

463: FETCH cMVLog INTO l_mvlog_name;
464: CLOSE cMVLog;
465: RETURN l_mvlog_name;
466: EXCEPTION when others then
467: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_mvlog_for_table:'||sqlerrm||', p_table_name='||p_table_name);
468: raise;
469: END;
470:
471:

Line 523: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_char_chunks:'||sqlerrm||', p_msg='||p_msg||', p_chunk_size='||p_chunk_size);

519: l_msg := substr(l_msg, l_chunk_size+1, length(l_msg));
520: END LOOP;
521: return l_varchar2_table;
522: EXCEPTION when others then
523: fnd_file.put_line(FND_FILE.LOG, 'Exception in BSC_DBGEN_UTILS.get_char_chunks:'||sqlerrm||', p_msg='||p_msg||', p_chunk_size='||p_chunk_size);
524: raise;
525: END;
526:
527: /****************************************************************************

Line 729: fnd_file.put_line(FND_FILE.log, 'Error in add_string:string='||p_string||', error='||sqlerrm);

725: return;
726: end if;
727: p_varchar2_table(l_index) := p_varchar2_table(l_index)||p_string;
728: exception when others then
729: fnd_file.put_line(FND_FILE.log, 'Error in add_string:string='||p_string||', error='||sqlerrm);
730: raise;
731: END;
732:
733:

Line 756: fnd_file.put_line(FND_FILE.LOG, 'Chk 0, bind#='||p_num_bind_vars);

752:
753: l_cur number;
754: dummy NUMBER;
755: BEGIN
756: fnd_file.put_line(FND_FILE.LOG, 'Chk 0, bind#='||p_num_bind_vars);
757: for i in 1..p_varchar2_table.count loop
758: l_sql(i) := p_varchar2_table(i);
759: end loop;
760: fnd_file.put_line(FND_FILE.LOG, 'Chk 1');

Line 760: fnd_file.put_line(FND_FILE.LOG, 'Chk 1');

756: fnd_file.put_line(FND_FILE.LOG, 'Chk 0, bind#='||p_num_bind_vars);
757: for i in 1..p_varchar2_table.count loop
758: l_sql(i) := p_varchar2_table(i);
759: end loop;
760: fnd_file.put_line(FND_FILE.LOG, 'Chk 1');
761:
762: for i in p_varchar2_table.count+1..50 loop
763: l_sql(i) := null;
764: end loop;

Line 777: fnd_file.put_line(FND_FILE.LOG, 'Chk 4');

773: language_flag => dbms_sql.native );
774:
775: dummy := dbms_sql.execute(l_cur);
776: dbms_sql.close_cursor(l_cur);
777: fnd_file.put_line(FND_FILE.LOG, 'Chk 4');
778: elsif p_num_bind_vars = 1 then
779: execute immediate l_sql(1) ||l_sql(2) ||l_sql(3) ||l_sql(4) ||l_sql(5) ||l_sql(6) ||l_sql(7) ||l_sql(8) ||l_sql(9) ||l_sql(10)||
780: l_sql(11)||l_sql(12)||l_sql(13)||l_sql(14)||l_sql(15)||l_sql(16)||l_sql(17)||l_sql(18)||l_sql(19)||l_sql(20)||
781: l_sql(21)||l_sql(22)||l_sql(23)||l_sql(24)||l_sql(25)||l_sql(26)||l_sql(27)||l_sql(28)||l_sql(29)||l_sql(30)||

Line 953: fnd_file.put_line(FND_FILE.LOG,'Maximun bind variables supported by this api was exceeded');

949: raise e_max_bind_vars_exceeded;
950: end if;
951: exception
952: when e_max_bind_vars_exceeded then
953: fnd_file.put_line(FND_FILE.LOG,'Maximun bind variables supported by this api was exceeded');
954: raise;
955: when others then
956: fnd_file.put_line(FND_FILE.LOG,'Error in execute_immediate: error='||sqlerrm||', count = '||p_varchar2_table.count||', bind#='||p_num_bind_vars);
957: for i in 1..p_varchar2_table.count loop

Line 956: fnd_file.put_line(FND_FILE.LOG,'Error in execute_immediate: error='||sqlerrm||', count = '||p_varchar2_table.count||', bind#='||p_num_bind_vars);

952: when e_max_bind_vars_exceeded then
953: fnd_file.put_line(FND_FILE.LOG,'Maximun bind variables supported by this api was exceeded');
954: raise;
955: when others then
956: fnd_file.put_line(FND_FILE.LOG,'Error in execute_immediate: error='||sqlerrm||', count = '||p_varchar2_table.count||', bind#='||p_num_bind_vars);
957: for i in 1..p_varchar2_table.count loop
958: for j in 1..128 loop
959: fnd_file.put_line(FND_FILE.LOG, substr(p_varchar2_table(i), (j-1)*256+1, 256));
960: end loop;

Line 959: fnd_file.put_line(FND_FILE.LOG, substr(p_varchar2_table(i), (j-1)*256+1, 256));

955: when others then
956: fnd_file.put_line(FND_FILE.LOG,'Error in execute_immediate: error='||sqlerrm||', count = '||p_varchar2_table.count||', bind#='||p_num_bind_vars);
957: for i in 1..p_varchar2_table.count loop
958: for j in 1..128 loop
959: fnd_file.put_line(FND_FILE.LOG, substr(p_varchar2_table(i), (j-1)*256+1, 256));
960: end loop;
961: end loop;
962: raise;
963: END;