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_POO_TRANSACTION dependencies on UTL_FILE

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

107: ec_debug.pl(1,'Open Output file'); --Bug 2034376
108: end if;
109: i_path := cOutput_Path;
110: i_filename := cFilename;
111: -- ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767); --Bug 2887790
112:
113: xProgress := 'POO-10-1040';
114: if ec_debug.G_debug_level = 1 then
115: ec_debug.pl(1,'Call Populate Poo Trx procedure'); --Bug 2034376

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

165: cDistribution_Interface);
166: */
167:
168: xProgress := 'POO-10-1042';
169: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then
170: utl_file.fclose(ece_poo_transaction.uFile_type);
171: end if;
172:
173: IF ec_mapping_utils.ec_get_trans_upgrade_status(cTransaction_Type) = 'U' THEN

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

166: */
167:
168: xProgress := 'POO-10-1042';
169: if (utl_file.is_open(ece_poo_transaction.uFile_type)) then
170: utl_file.fclose(ece_poo_transaction.uFile_type);
171: end if;
172:
173: IF ec_mapping_utils.ec_get_trans_upgrade_status(cTransaction_Type) = 'U' THEN
174: ec_debug.pl(0,'EC','ECE_REC_TRANS_PENDING',NULL);

Line 194: WHEN utl_file.write_error THEN

190: retcode := 1;
191: ec_debug.disable_debug;
192: ROLLBACK;
193:
194: WHEN utl_file.write_error THEN
195: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
196: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
197:
198: retcode := 2;

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

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

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

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

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

200: if (utl_file.is_open(ece_poo_transaction.uFile_type))
201: then
202: utl_file.fclose(ece_poo_transaction.uFile_type);
203: end if;
204: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: ROLLBACK;
207:
208: WHEN utl_file.invalid_path THEN

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

201: then
202: utl_file.fclose(ece_poo_transaction.uFile_type);
203: end if;
204: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: ROLLBACK;
207:
208: WHEN utl_file.invalid_path THEN
209: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);

Line 208: WHEN utl_file.invalid_path THEN

204: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
205: utl_file.fclose(ece_poo_transaction.uFile_type);
206: ROLLBACK;
207:
208: WHEN utl_file.invalid_path THEN
209: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
210: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
211:
212: retcode := 2;

Line 216: WHEN utl_file.invalid_operation THEN

212: retcode := 2;
213: ec_debug.disable_debug;
214: ROLLBACK;
215:
216: WHEN utl_file.invalid_operation THEN
217: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
218: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
219:
220: retcode := 2;

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

218: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
219:
220: retcode := 2;
221: ec_debug.disable_debug;
222: if (utl_file.is_open(ece_poo_transaction.uFile_type))
223: then
224: utl_file.fclose(ece_poo_transaction.uFile_type);
225: end if;
226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

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

220: retcode := 2;
221: ec_debug.disable_debug;
222: if (utl_file.is_open(ece_poo_transaction.uFile_type))
223: then
224: utl_file.fclose(ece_poo_transaction.uFile_type);
225: end if;
226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
227: utl_file.fclose(ece_poo_transaction.uFile_type);
228: ROLLBACK;

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

222: if (utl_file.is_open(ece_poo_transaction.uFile_type))
223: then
224: utl_file.fclose(ece_poo_transaction.uFile_type);
225: end if;
226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
227: utl_file.fclose(ece_poo_transaction.uFile_type);
228: ROLLBACK;
229:
230: WHEN OTHERS THEN

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

223: then
224: utl_file.fclose(ece_poo_transaction.uFile_type);
225: end if;
226: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
227: utl_file.fclose(ece_poo_transaction.uFile_type);
228: ROLLBACK;
229:
230: WHEN OTHERS THEN
231: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);

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

232: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
233:
234: retcode := 2;
235: ec_debug.disable_debug;
236: if (utl_file.is_open(ece_poo_transaction.uFile_type))
237: then
238: utl_file.fclose(ece_poo_transaction.uFile_type);
239: end if;
240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);

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

234: retcode := 2;
235: ec_debug.disable_debug;
236: if (utl_file.is_open(ece_poo_transaction.uFile_type))
237: then
238: utl_file.fclose(ece_poo_transaction.uFile_type);
239: end if;
240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
241: utl_file.fclose(ece_poo_transaction.uFile_type);
242: ROLLBACK;

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

236: if (utl_file.is_open(ece_poo_transaction.uFile_type))
237: then
238: utl_file.fclose(ece_poo_transaction.uFile_type);
239: end if;
240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
241: utl_file.fclose(ece_poo_transaction.uFile_type);
242: ROLLBACK;
243:
244: END extract_poo_outbound;

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

237: then
238: utl_file.fclose(ece_poo_transaction.uFile_type);
239: end if;
240: ece_poo_transaction.uFile_type := utl_file.fopen(cOutput_Path,cFilename,'W',32767);
241: utl_file.fclose(ece_poo_transaction.uFile_type);
242: ROLLBACK;
243:
244: END extract_poo_outbound;
245:

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

1324:
1325: -- **************************************
1326: -- store internal values in pl/sql table
1327: -- **************************************
1328: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1329: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1330: end if;
1331: xProgress := 'POOB-10-1431';
1332: ece_flatfile_pvt.assign_column_value_to_tbl(Header_sel_c,0,l_header_tbl,l_key_tbl);

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

1325: -- **************************************
1326: -- store internal values in pl/sql table
1327: -- **************************************
1328: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then
1329: ece_poo_transaction.uFile_type := utl_file.fopen(i_path,i_filename,'W',32767);
1330: end if;
1331: xProgress := 'POOB-10-1431';
1332: ece_flatfile_pvt.assign_column_value_to_tbl(Header_sel_c,0,l_header_tbl,l_key_tbl);
1333:

Line 6103: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);

6099: RPAD(NVL(p_Interface_tbl(iRow_num).layout_code,' '),2) ||
6100: RPAD(NVL(p_Interface_tbl(iRow_num).record_qualifier,' '),3) || cInsert_stmt;
6101:
6102: xProgress := 'POOB-WR-1100';
6103: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);
6104: xProgress := 'POOB-WR-1110';
6105: cInsert_stmt := NULL;
6106: -- cInsert_stmt := '*' || TO_CHAR(p_Interface_tbl(i).Record_num);
6107: END IF;

Line 6119: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);

6115: RPAD(NVL(p_Interface_tbl(iRow_num).layout_code,' '),2) ||
6116: RPAD(NVL(p_Interface_tbl(iRow_num).record_qualifier,' '),3) || cInsert_stmt;
6117:
6118: xProgress := 'POOB-WR-1130';
6119: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);
6120: END IF;
6121: END IF;
6122: END LOOP;
6123:

Line 6129: WHEN utl_file.write_error THEN

6125: ec_debug.pop('ECE_POO_TRANSACTION.WRITE_TO_FILE');
6126: end if;
6127:
6128: EXCEPTION
6129: WHEN utl_file.write_error THEN
6130: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
6131: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6132: app_exception.raise_exception;
6133:

Line 6134: WHEN utl_file.invalid_path THEN

6130: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
6131: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6132: app_exception.raise_exception;
6133:
6134: WHEN utl_file.invalid_path THEN
6135: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
6136: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6137: app_exception.raise_exception;
6138:

Line 6139: WHEN utl_file.invalid_operation THEN

6135: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
6136: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6137: app_exception.raise_exception;
6138:
6139: WHEN utl_file.invalid_operation THEN
6140: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
6141: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6142: app_exception.raise_exception;
6143: