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

Line 192: --- u_file_handle := utl_file.fopen(i_file_path,i_file_name,'w', 3000);

188: END LOOP;
189:
190: --- operation moved to inside the Select_From_Stage_Table
191: --- Open the Outbound Transaction File in the Write Mode
192: --- u_file_handle := utl_file.fopen(i_file_path,i_file_name,'w', 3000);
193:
194: vPath := i_file_path;
195: vFileName:= i_file_name;
196:

Line 211: if (utl_file.is_open(u_file_handle)) then

207: l_common_key
208: );
209:
210: -- Close the Outbound Transaction File
211: if (utl_file.is_open(u_file_handle)) then
212: utl_file.fclose(u_file_handle);
213: end if;
214:
215: /**

Line 212: utl_file.fclose(u_file_handle);

208: );
209:
210: -- Close the Outbound Transaction File
211: if (utl_file.is_open(u_file_handle)) then
212: utl_file.fclose(u_file_handle);
213: end if;
214:
215: /**
216: The Cursors for the Select From Stage table are not closed in the Select_From_Stage_table

Line 244: WHEN UTL_FILE.write_error THEN

240: if ec_debug.G_debug_level >= 2 then
241: ec_debug.pop('EC_OUTBOUND_STAGE.GET_DATA');
242: end if;
243: EXCEPTION
244: WHEN UTL_FILE.write_error THEN
245: ec_utils.i_ret_code :=2;
246: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',null);
247: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
248: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 249: utl_file.fclose(u_file_handle);

245: ec_utils.i_ret_code :=2;
246: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',null);
247: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
248: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
249: utl_file.fclose(u_file_handle);
250: raise EC_UTILS.PROGRAM_EXIT;
251: WHEN UTL_FILE.read_error THEN
252: ec_utils.i_ret_code :=2;
253: ec_debug.pl(0,'EC','ECE_UTL_READ_ERROR',null);

Line 251: WHEN UTL_FILE.read_error THEN

247: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
248: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
249: utl_file.fclose(u_file_handle);
250: raise EC_UTILS.PROGRAM_EXIT;
251: WHEN UTL_FILE.read_error THEN
252: ec_utils.i_ret_code :=2;
253: ec_debug.pl(0,'EC','ECE_UTL_READ_ERROR',null);
254: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
255: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 256: utl_file.fclose(u_file_handle);

252: ec_utils.i_ret_code :=2;
253: ec_debug.pl(0,'EC','ECE_UTL_READ_ERROR',null);
254: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
255: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
256: utl_file.fclose(u_file_handle);
257: raise EC_UTILS.PROGRAM_EXIT;
258: WHEN UTL_FILE.invalid_path THEN
259: ec_utils.i_ret_code :=2;
260: ec_debug.pl(0,'EC','ECE_UTL_INVALID_PATH',null);

Line 258: WHEN UTL_FILE.invalid_path THEN

254: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
255: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
256: utl_file.fclose(u_file_handle);
257: raise EC_UTILS.PROGRAM_EXIT;
258: WHEN UTL_FILE.invalid_path THEN
259: ec_utils.i_ret_code :=2;
260: ec_debug.pl(0,'EC','ECE_UTL_INVALID_PATH',null);
261: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
262: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 263: utl_file.fclose(u_file_handle);

259: ec_utils.i_ret_code :=2;
260: ec_debug.pl(0,'EC','ECE_UTL_INVALID_PATH',null);
261: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
262: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
263: utl_file.fclose(u_file_handle);
264: raise EC_UTILS.PROGRAM_EXIT;
265: WHEN UTL_FILE.invalid_mode THEN
266: ec_utils.i_ret_code :=2;
267: ec_debug.pl(0,'EC','ECE_UTL_INVALID_MODE',null);

Line 265: WHEN UTL_FILE.invalid_mode THEN

261: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
262: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
263: utl_file.fclose(u_file_handle);
264: raise EC_UTILS.PROGRAM_EXIT;
265: WHEN UTL_FILE.invalid_mode THEN
266: ec_utils.i_ret_code :=2;
267: ec_debug.pl(0,'EC','ECE_UTL_INVALID_MODE',null);
268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
269: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 270: utl_file.fclose(u_file_handle);

266: ec_utils.i_ret_code :=2;
267: ec_debug.pl(0,'EC','ECE_UTL_INVALID_MODE',null);
268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
269: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
270: utl_file.fclose(u_file_handle);
271: raise EC_UTILS.PROGRAM_EXIT;
272: WHEN UTL_FILE.invalid_operation THEN
273: ec_utils.i_ret_code :=2;
274: ec_debug.pl(0,'EC','ECE_UTL_INVALID_OPERATION',null);

Line 272: WHEN UTL_FILE.invalid_operation THEN

268: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
269: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
270: utl_file.fclose(u_file_handle);
271: raise EC_UTILS.PROGRAM_EXIT;
272: WHEN UTL_FILE.invalid_operation THEN
273: ec_utils.i_ret_code :=2;
274: ec_debug.pl(0,'EC','ECE_UTL_INVALID_OPERATION',null);
275: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
276: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 277: utl_file.fclose(u_file_handle);

273: ec_utils.i_ret_code :=2;
274: ec_debug.pl(0,'EC','ECE_UTL_INVALID_OPERATION',null);
275: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
276: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
277: utl_file.fclose(u_file_handle);
278: raise EC_UTILS.PROGRAM_EXIT;
279: WHEN UTL_FILE.invalid_filehandle THEN
280: ec_utils.i_ret_code :=2;
281: ec_debug.pl(0,'EC','ECE_UTL_INVALID_FILEHANDLE',null);

Line 279: WHEN UTL_FILE.invalid_filehandle THEN

275: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
276: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
277: utl_file.fclose(u_file_handle);
278: raise EC_UTILS.PROGRAM_EXIT;
279: WHEN UTL_FILE.invalid_filehandle THEN
280: ec_utils.i_ret_code :=2;
281: ec_debug.pl(0,'EC','ECE_UTL_INVALID_FILEHANDLE',null);
282: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
283: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 284: utl_file.fclose(u_file_handle);

280: ec_utils.i_ret_code :=2;
281: ec_debug.pl(0,'EC','ECE_UTL_INVALID_FILEHANDLE',null);
282: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
283: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
284: utl_file.fclose(u_file_handle);
285: raise EC_UTILS.PROGRAM_EXIT;
286: WHEN UTL_FILE.internal_error THEN
287: ec_utils.i_ret_code :=2;
288: ec_debug.pl(0,'EC','ECE_UTL_INTERNAL_ERROR',null);

Line 286: WHEN UTL_FILE.internal_error THEN

282: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
283: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
284: utl_file.fclose(u_file_handle);
285: raise EC_UTILS.PROGRAM_EXIT;
286: WHEN UTL_FILE.internal_error THEN
287: ec_utils.i_ret_code :=2;
288: ec_debug.pl(0,'EC','ECE_UTL_INTERNAL_ERROR',null);
289: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
290: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 291: utl_file.fclose(u_file_handle);

287: ec_utils.i_ret_code :=2;
288: ec_debug.pl(0,'EC','ECE_UTL_INTERNAL_ERROR',null);
289: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
290: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
291: utl_file.fclose(u_file_handle);
292: raise EC_UTILS.PROGRAM_EXIT;
293: WHEN EC_UTILS.PROGRAM_EXIT THEN
294: raise;
295: WHEN OTHERS THEN

Line 299: utl_file.fclose(u_file_handle);

295: WHEN OTHERS THEN
296: ec_utils.i_ret_code :=2;
297: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_OUTBOUND_STAGE.GET_DATA');
298: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
299: utl_file.fclose(u_file_handle);
300: raise EC_UTILS.PROGRAM_EXIT;
301: END Get_Data;
302:
303: /**

Line 876: if (NOT utl_file.is_open(u_file_handle)) then

872: v_dummy_tp_code,
873: v_dummy_key_staging,
874: i_common_key
875: );
876: if (NOT utl_file.is_open(u_file_handle)) then
877: u_file_handle := utl_file.fopen(vPath,vFileName,'w', 3000);
878: end if;
879:
880: FOR m IN 3..i_level_info(i_level).total_records + 2

Line 877: u_file_handle := utl_file.fopen(vPath,vFileName,'w', 3000);

873: v_dummy_key_staging,
874: i_common_key
875: );
876: if (NOT utl_file.is_open(u_file_handle)) then
877: u_file_handle := utl_file.fopen(vPath,vFileName,'w', 3000);
878: end if;
879:
880: FOR m IN 3..i_level_info(i_level).total_records + 2
881: LOOP

Line 883: UTL_FILE.PUT_LINE(u_file_handle,i_common_key||v_dummy(m));

879:
880: FOR m IN 3..i_level_info(i_level).total_records + 2
881: LOOP
882: dbms_sql.column_value(i_select_cursor,m,v_dummy(m));
883: UTL_FILE.PUT_LINE(u_file_handle,i_common_key||v_dummy(m));
884: END LOOP;
885: END LOOP;
886: EXCEPTION
887: WHEN OTHERS THEN