APPS.FND_SYSTEM_ALERT_INTG_UTIL dependencies on UTL_FILE

Line 98: config_file UTL_FILE.FILE_TYPE;

94: l_msg := 'm';
95: END fdebug;
96:
97: procedure printClobOut(result IN OUT NOCOPY CLOB) is
98: config_file UTL_FILE.FILE_TYPE;
99: xmlstr varchar2(32767);
100: line varchar2(2000);
101: begin
102: config_file := UTL_FILE.FOPEN ('/slot03/oracle/oam12devdb/9.2.0/appsutil/outbound/oam12dev', 'sqlQ.txt', 'W');

Line 102: config_file := UTL_FILE.FOPEN ('/slot03/oracle/oam12devdb/9.2.0/appsutil/outbound/oam12dev', 'sqlQ.txt', 'W');

98: config_file UTL_FILE.FILE_TYPE;
99: xmlstr varchar2(32767);
100: line varchar2(2000);
101: begin
102: config_file := UTL_FILE.FOPEN ('/slot03/oracle/oam12devdb/9.2.0/appsutil/outbound/oam12dev', 'sqlQ.txt', 'W');
103: xmlstr := dbms_lob.SUBSTR(result,32767);
104: loop
105: exit when xmlstr is null;
106: --line := substr(xmlstr,1,instr(xmlstr,chr(10))-1);

Line 108: UTL_FILE.PUT_LINE(config_file, line);

104: loop
105: exit when xmlstr is null;
106: --line := substr(xmlstr,1,instr(xmlstr,chr(10))-1);
107: --dbms_output.put_line('| '||line);
108: UTL_FILE.PUT_LINE(config_file, line);
109: --xmlstr := substr(xmlstr,instr(xmlstr,chr(10))+1);
110: end loop;
111: UTL_FILE.fclose(config_file);
112: end;

Line 111: UTL_FILE.fclose(config_file);

107: --dbms_output.put_line('| '||line);
108: UTL_FILE.PUT_LINE(config_file, line);
109: --xmlstr := substr(xmlstr,instr(xmlstr,chr(10))+1);
110: end loop;
111: UTL_FILE.fclose(config_file);
112: end;
113:
114: procedure writeString(msg in varchar2) is
115: config_file UTL_FILE.FILE_TYPE;

Line 115: config_file UTL_FILE.FILE_TYPE;

111: UTL_FILE.fclose(config_file);
112: end;
113:
114: procedure writeString(msg in varchar2) is
115: config_file UTL_FILE.FILE_TYPE;
116: startIndex number;
117: lineLength number;
118: line varchar2(255);
119: begin

Line 120: config_file := UTL_FILE.FOPEN ('/slot03/oracle/oam12devdb/9.2.0/appsutil/outbound/oam12dev', 'sqlQ.txt', 'W');

116: startIndex number;
117: lineLength number;
118: line varchar2(255);
119: begin
120: config_file := UTL_FILE.FOPEN ('/slot03/oracle/oam12devdb/9.2.0/appsutil/outbound/oam12dev', 'sqlQ.txt', 'W');
121: startIndex :=1;
122: lineLength := 255;
123: line := substr(msg, startIndex, lineLength);
124:

Line 128: UTL_FILE.PUT_LINE(config_file, line);

124:
125: loop
126: exit when line is null;
127: ---dbms_output.put_line(line);
128: UTL_FILE.PUT_LINE(config_file, line);
129: startIndex := startIndex + lineLength;
130: line := substr(msg, startIndex, lineLength);
131: end loop;
132:

Line 133: UTL_FILE.fclose(config_file);

129: startIndex := startIndex + lineLength;
130: line := substr(msg, startIndex, lineLength);
131: end loop;
132:
133: UTL_FILE.fclose(config_file);
134: end;
135:
136:
137: /**