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 1332: if (NOT utl_file.is_open(ece_poo_transaction.uFile_type)) then

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

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

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

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

6132: RPAD(NVL(p_Interface_tbl(iRow_num).layout_code,' '),2) ||
6133: RPAD(NVL(p_Interface_tbl(iRow_num).record_qualifier,' '),3) || cInsert_stmt;
6134:
6135: xProgress := 'POOB-WR-1100';
6136: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);
6137: xProgress := 'POOB-WR-1110';
6138: cInsert_stmt := NULL;
6139: -- cInsert_stmt := '*' || TO_CHAR(p_Interface_tbl(i).Record_num);
6140: END IF;

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

6148: RPAD(NVL(p_Interface_tbl(iRow_num).layout_code,' '),2) ||
6149: RPAD(NVL(p_Interface_tbl(iRow_num).record_qualifier,' '),3) || cInsert_stmt;
6150:
6151: xProgress := 'POOB-WR-1130';
6152: utl_file.put_line(ece_poo_transaction.uFile_type,cInsert_stmt);
6153: END IF;
6154: END IF;
6155: END LOOP;
6156:

Line 6162: WHEN utl_file.write_error THEN

6158: ec_debug.pop('ECE_POO_TRANSACTION.WRITE_TO_FILE');
6159: end if;
6160:
6161: EXCEPTION
6162: WHEN utl_file.write_error THEN
6163: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
6164: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6165: app_exception.raise_exception;
6166:

Line 6167: WHEN utl_file.invalid_path THEN

6163: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',NULL);
6164: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6165: app_exception.raise_exception;
6166:
6167: WHEN utl_file.invalid_path THEN
6168: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
6169: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6170: app_exception.raise_exception;
6171:

Line 6172: WHEN utl_file.invalid_operation THEN

6168: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_PATH',NULL);
6169: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6170: app_exception.raise_exception;
6171:
6172: WHEN utl_file.invalid_operation THEN
6173: ec_debug.pl(0,'EC','ECE_UTIL_INVALID_OPERATION',NULL);
6174: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
6175: app_exception.raise_exception;
6176: