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.ECE_POCO_TRANSACTION dependencies on UTL_FILE

Line 106: -- ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767); --Bug 2887790

102: -- ec_debug.pl(1,'Open Output file'); --Bug 2034376
103: end if;
104: i_path := cOutput_Path;
105: i_filename := cFilename;
106: -- ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767); --Bug 2887790
107:
108: xProgress := 'POCO-10-1020';
109: ec_debug.pl(1,'Call Populate Poco Trx procedure'); --Bug 2034376
110: ece_poco_transaction.populate_poco_trx(

Line 153: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then

149: cProject_Interface); */
150:
151: xProgress := 'POCO-10-1090';
152: ec_debug.pl(1,'Close Output file'); --Bug 2034376
153: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then
154: utl_file.fclose(ece_poo_transaction.uFile_type);
155: end if;
156:
157:

Line 154: utl_file.fclose(ece_poo_transaction.uFile_type);

150:
151: xProgress := 'POCO-10-1090';
152: ec_debug.pl(1,'Close Output file'); --Bug 2034376
153: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then
154: utl_file.fclose(ece_poo_transaction.uFile_type);
155: end if;
156:
157:
158:

Line 175: WHEN utl_file.write_error THEN

171: retcode := 1;
172: ec_debug.disable_debug;
173: ROLLBACK;
174:
175: WHEN utl_file.write_error THEN
176: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
177: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
178:
179: retcode := 2;

Line 181: if (utl_file.is_open(ece_poo_transaction.uFile_type))

177: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
178:
179: retcode := 2;
180: ec_debug.disable_debug;
181: if (utl_file.is_open(ece_poo_transaction.uFile_type))
182: then
183: utl_file.fclose(ece_poo_transaction.uFile_type);
184: end if;
185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

Line 183: utl_file.fclose(ece_poo_transaction.uFile_type);

179: retcode := 2;
180: ec_debug.disable_debug;
181: if (utl_file.is_open(ece_poo_transaction.uFile_type))
182: then
183: utl_file.fclose(ece_poo_transaction.uFile_type);
184: end if;
185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
186: utl_file.fclose(ece_poo_transaction.uFile_type);
187: ROLLBACK;

Line 185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

181: if (utl_file.is_open(ece_poo_transaction.uFile_type))
182: then
183: utl_file.fclose(ece_poo_transaction.uFile_type);
184: end if;
185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
186: utl_file.fclose(ece_poo_transaction.uFile_type);
187: ROLLBACK;
188:
189: WHEN utl_file.invalid_path THEN

Line 186: utl_file.fclose(ece_poo_transaction.uFile_type);

182: then
183: utl_file.fclose(ece_poo_transaction.uFile_type);
184: end if;
185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
186: utl_file.fclose(ece_poo_transaction.uFile_type);
187: ROLLBACK;
188:
189: WHEN utl_file.invalid_path THEN
190: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);

Line 189: WHEN utl_file.invalid_path THEN

185: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
186: utl_file.fclose(ece_poo_transaction.uFile_type);
187: ROLLBACK;
188:
189: WHEN utl_file.invalid_path THEN
190: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
191: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
192:
193: retcode := 2;

Line 197: WHEN utl_file.invalid_operation THEN

193: retcode := 2;
194: ec_debug.disable_debug;
195: ROLLBACK;
196:
197: WHEN utl_file.invalid_operation THEN
198: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
199: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
200:
201: retcode := 2;

Line 203: if (utl_file.is_open(ece_poo_transaction.uFile_type))

199: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
200:
201: retcode := 2;
202: ec_debug.disable_debug;
203: if (utl_file.is_open(ece_poo_transaction.uFile_type))
204: then
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: end if;
207: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

Line 205: utl_file.fclose(ece_poo_transaction.uFile_type);

201: retcode := 2;
202: ec_debug.disable_debug;
203: if (utl_file.is_open(ece_poo_transaction.uFile_type))
204: then
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: end if;
207: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
208: utl_file.fclose(ece_poo_transaction.uFile_type);
209: ROLLBACK;

Line 207: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

203: if (utl_file.is_open(ece_poo_transaction.uFile_type))
204: then
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: end if;
207: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
208: utl_file.fclose(ece_poo_transaction.uFile_type);
209: ROLLBACK;
210:
211: WHEN OTHERS THEN

Line 208: utl_file.fclose(ece_poo_transaction.uFile_type);

204: then
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: end if;
207: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
208: utl_file.fclose(ece_poo_transaction.uFile_type);
209: ROLLBACK;
210:
211: WHEN OTHERS THEN
212: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

Line 217: if (utl_file.is_open(ece_poo_transaction.uFile_type))

213: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
214:
215: retcode := 2;
216: ec_debug.disable_debug;
217: if (utl_file.is_open(ece_poo_transaction.uFile_type))
218: then
219: utl_file.fclose(ece_poo_transaction.uFile_type);
220: end if;
221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

Line 219: utl_file.fclose(ece_poo_transaction.uFile_type);

215: retcode := 2;
216: ec_debug.disable_debug;
217: if (utl_file.is_open(ece_poo_transaction.uFile_type))
218: then
219: utl_file.fclose(ece_poo_transaction.uFile_type);
220: end if;
221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
222: utl_file.fclose(ece_poo_transaction.uFile_type);
223: ROLLBACK;

Line 221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

217: if (utl_file.is_open(ece_poo_transaction.uFile_type))
218: then
219: utl_file.fclose(ece_poo_transaction.uFile_type);
220: end if;
221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
222: utl_file.fclose(ece_poo_transaction.uFile_type);
223: ROLLBACK;
224:
225: END extract_poco_outbound;

Line 222: utl_file.fclose(ece_poo_transaction.uFile_type);

218: then
219: utl_file.fclose(ece_poo_transaction.uFile_type);
220: end if;
221: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
222: utl_file.fclose(ece_poo_transaction.uFile_type);
223: ROLLBACK;
224:
225: END extract_poco_outbound;
226:

Line 1284: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then

1280: -- ***************************************************
1281: xProgress := 'POCOB-10-1410';
1282: WHILE dbms_sql.fetch_rows(header_sel_c) > 0 LOOP -- Header
1283:
1284: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1285: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1286: end if;
1287: counter := 0;
1288: -- **************************************

Line 1285: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);

1281: xProgress := 'POCOB-10-1410';
1282: WHILE dbms_sql.fetch_rows(header_sel_c) > 0 LOOP -- Header
1283:
1284: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1285: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1286: end if;
1287: counter := 0;
1288: -- **************************************
1289: -- store internal values in pl/sql table