APPS.ECE_MVSTO_TRANSACTION dependencies on UTL_FILE

Line 31: uFile_type utl_file.file_type;

27: cHeader_Interface VARCHAR2(120) := 'ECE_MVSTO_HEADERS';
28: cLine_Interface VARCHAR2(120) := 'ECE_MVSTO_DETAILS';
29: cLocation_Interface VARCHAR2(120) := 'ECE_MVSTO_LOCATIONS';
30: l_line_text VARCHAR2(2000);
31: uFile_type utl_file.file_type;
32: cEnabled VARCHAR2(1) := 'Y';
33: ece_transaction_disabled EXCEPTION;
34: cFilename VARCHAR2(30) := NULL; --2430822
35:

Line 137: if (NOT utl_file.is_open(uFile_type)) then

133:
134: xProgress := 'MVSTO-10-1060';
135:
136: if (c_output%ROWCOUNT > 0) then
137: if (NOT utl_file.is_open(uFile_type)) then
138: uFile_type := UTL_FILE.fopen(cOutput_Path,
139: cFilename,
140: 'W');
141: end if;

Line 138: uFile_type := UTL_FILE.fopen(cOutput_Path,

134: xProgress := 'MVSTO-10-1060';
135:
136: if (c_output%ROWCOUNT > 0) then
137: if (NOT utl_file.is_open(uFile_type)) then
138: uFile_type := UTL_FILE.fopen(cOutput_Path,
139: cFilename,
140: 'W');
141: end if;
142: end if;

Line 149: utl_file.put_line(uFile_type,

145:
146: -- Write the data from ece_output to the output file.
147:
148: xProgress := 'MVSTO-10-1070';
149: utl_file.put_line(uFile_type,
150: l_line_text);
151:
152: END LOOP;
153:

Line 160: if (utl_file.is_open( uFile_type)) then

156:
157: -- Close the output file.
158:
159: xProgress := 'MVSTO-10-1090';
160: if (utl_file.is_open( uFile_type)) then
161: utl_file.fclose(uFile_type);
162: end if;
163:
164: -- Assume everything went ok so delete the records from ece_output.

Line 161: utl_file.fclose(uFile_type);

157: -- Close the output file.
158:
159: xProgress := 'MVSTO-10-1090';
160: if (utl_file.is_open( uFile_type)) then
161: utl_file.fclose(uFile_type);
162: end if;
163:
164: -- Assume everything went ok so delete the records from ece_output.
165:

Line 199: WHEN utl_file.write_error THEN

195: ec_debug.disable_debug;
196: ROLLBACK;
197: RAISE;
198:
199: WHEN utl_file.write_error THEN
200: ec_debug.pl(0,
201: 'EC',
202: 'ECE_UTL_WRITE_ERROR',
203: NULL);

Line 216: WHEN utl_file.invalid_path THEN

212: ec_debug.disable_debug;
213: ROLLBACK;
214: RAISE;
215:
216: WHEN utl_file.invalid_path THEN
217:
218: ec_debug.pl(0,
219: 'EC',
220: 'ECE_UTIL_INVALID_PATH',

Line 234: WHEN utl_file.invalid_operation THEN

230: ec_debug.disable_debug;
231: ROLLBACK;
232: RAISE;
233:
234: WHEN utl_file.invalid_operation THEN
235:
236: ec_debug.pl(0,
237: 'EC',
238: 'ECE_UTIL_INVALID_OPERATION',