APPS.EDW_UPDATE_ATTRIBUTES dependencies on UTL_FILE

Line 27: ---| Changed API update_stg to use profile option UTL_FILE_LOG |

23: ---| directive. Removed restriction to 11i version to allow |
24: ---| back-porting. |
25: ---| |
26: ---| smulye 04-Sep-03 |
27: ---| Changed API update_stg to use profile option UTL_FILE_LOG |
28: ---| Bug 2903252 |
29: ---| smulye 17-Nov-03 |
30: ---| changed API update_stg to use AD APIs to get temporary tablespace name|
31: ---| Bug 2759144 |

Line 69: utl_file.put_line(g_file, substr(p_msg,l_count * 255+1, 255 ));

65:
66: l_count := 0;
67: l_length := length(p_msg);
68: loop
69: utl_file.put_line(g_file, substr(p_msg,l_count * 255+1, 255 ));
70: l_count := l_count +1 ;
71: exit when ((l_count*255) > l_length) OR l_count > 4;
72: end loop;
73: utl_file.fflush(g_file);

Line 73: utl_file.fflush(g_file);

69: utl_file.put_line(g_file, substr(p_msg,l_count * 255+1, 255 ));
70: l_count := l_count +1 ;
71: exit when ((l_count*255) > l_length) OR l_count > 4;
72: end loop;
73: utl_file.fflush(g_file);
74:
75: end;
76:
77: Procedure drop_temp_tables(l_table_list in dbms_sql.varchar2_table) IS

Line 218: l_file utl_file.file_type;

214: l_count number:=0;
215:
216: l_attach varchar2(1000) := null;
217:
218: l_file utl_file.file_type;
219:
220: l_tables varchar2(1000);
221:
222:

Line 763: g_file := utl_file.fopen(p_logfile_dir, 'EDW_'||p_object_name||'.log' ,'w');

759:
760: IF (p_start_mode <> 'LOAD') then
761: g_separate_logging := true;
762: IF (p_logfile_dir IS NOT NULL ) THEN
763: g_file := utl_file.fopen(p_logfile_dir, 'EDW_'||p_object_name||'.log' ,'w');
764: ELSE
765: /*l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
766: IF (l_dir is null) then
767: l_dir := edw_gen_view.getUtlfiledir;

Line 770: l_dir := fnd_profile.value('UTL_FILE_LOG');

766: IF (l_dir is null) then
767: l_dir := edw_gen_view.getUtlfiledir;
768: END IF;*/
769:
770: l_dir := fnd_profile.value('UTL_FILE_LOG');
771: if l_dir is null then
772: l_dir := fnd_profile.value('EDW_LOGFILE_DIR');
773: if l_dir is null then
774: l_dir:= edw_gen_view.getUtlfiledir;

Line 777: g_file := utl_file.fopen(l_dir, 'EDW_'||p_object_name||'.log' ,'w');

773: if l_dir is null then
774: l_dir:= edw_gen_view.getUtlfiledir;
775: end if;
776: end if;
777: g_file := utl_file.fopen(l_dir, 'EDW_'||p_object_name||'.log' ,'w');
778: END IF;
779: END IF;
780:
781: writelog('Start Time is :'||to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss'));

Line 1205: utl_file.fclose(g_file);

1201: return true;
1202:
1203: Exception when others then
1204: writelog('Inside Exception ');
1205: utl_file.fclose(g_file);
1206: raise;
1207: return false;
1208:
1209: