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

Line 67: u_file_handle utl_file.file_type;

63: l_file_pos number :=0;
64: l_next_file_pos NUMBER :=0;
65: l_total_rec_unit number :=0;
66: l_rec_number NUMBER;
67: u_file_handle utl_file.file_type;
68: c_current_line varchar2(2000);
69: v_next_rec_number varchar2(22);
70: next_rec_number number :=0;
71: skip_record_flag BOOLEAN := FALSE;

Line 246: u_file_handle := utl_file.fopen(i_file_path,i_file_name,'r');

242: end if;
243:
244:
245: --- Open the Inbound Transaction File in the Read Mode
246: u_file_handle := utl_file.fopen(i_file_path,i_file_name,'r');
247:
248:
249: -- Find Positions for Translator Code and Location Code in the PL/SQL table.
250: find_pos

Line 273: utl_file.get_line(u_file_handle,c_current_line);

269: BEGIN
270: v_next_rec_number := NULL;
271: skip_record_flag := FALSE;
272:
273: utl_file.get_line(u_file_handle,c_current_line);
274:
275: v_next_rec_number := SUBSTRB(c_current_line,
276: g_record_num_start,
277: g_record_num_length

Line 592: utl_file.fclose(u_file_handle);

588:
589: end;
590:
591: -- Close the Inbound Transaction File
592: utl_file.fclose(u_file_handle);
593:
594: if EC_DEBUG.G_debug_level >= 1 then
595: ec_debug.pl(1,'EC','ECE_NO_LINES_READ','NO_OF_LINES',counter);
596: end if;

Line 603: WHEN UTL_FILE.write_error THEN

599: ec_debug.pl(1,'EC','ECE_DOCUMENTS_PROCESSED','NO_OF_DOCS',i_document_number);
600: ec_debug.pop('EC_INBOUND_STAGE.LOAD_DATA');
601: end if;
602: EXCEPTION
603: WHEN UTL_FILE.write_error THEN
604: EC_UTILS.i_ret_code :=2;
605: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',null);
606: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
607: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 608: utl_file.fclose(u_file_handle);

604: EC_UTILS.i_ret_code :=2;
605: ec_debug.pl(0,'EC','ECE_UTL_WRITE_ERROR',null);
606: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
607: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
608: utl_file.fclose(u_file_handle);
609: raise EC_UTILS.PROGRAM_EXIT;
610: WHEN UTL_FILE.read_error THEN
611: EC_UTILS.i_ret_code :=2;
612: ec_debug.pl(0,'EC','ECE_UTL_READ_ERROR',null);

Line 610: WHEN UTL_FILE.read_error THEN

606: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
607: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
608: utl_file.fclose(u_file_handle);
609: raise EC_UTILS.PROGRAM_EXIT;
610: WHEN UTL_FILE.read_error THEN
611: EC_UTILS.i_ret_code :=2;
612: ec_debug.pl(0,'EC','ECE_UTL_READ_ERROR',null);
613: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
614: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 615: utl_file.fclose(u_file_handle);

611: EC_UTILS.i_ret_code :=2;
612: ec_debug.pl(0,'EC','ECE_UTL_READ_ERROR',null);
613: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
614: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
615: utl_file.fclose(u_file_handle);
616: raise EC_UTILS.PROGRAM_EXIT;
617: WHEN UTL_FILE.invalid_path THEN
618: EC_UTILS.i_ret_code :=2;
619: ec_debug.pl(0,'EC','ECE_UTL_INVALID_PATH',null);

Line 617: WHEN UTL_FILE.invalid_path THEN

613: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
614: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
615: utl_file.fclose(u_file_handle);
616: raise EC_UTILS.PROGRAM_EXIT;
617: WHEN UTL_FILE.invalid_path THEN
618: EC_UTILS.i_ret_code :=2;
619: ec_debug.pl(0,'EC','ECE_UTL_INVALID_PATH',null);
620: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
621: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 622: utl_file.fclose(u_file_handle);

618: EC_UTILS.i_ret_code :=2;
619: ec_debug.pl(0,'EC','ECE_UTL_INVALID_PATH',null);
620: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
621: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
622: utl_file.fclose(u_file_handle);
623: raise EC_UTILS.PROGRAM_EXIT;
624: WHEN UTL_FILE.invalid_mode THEN
625: EC_UTILS.i_ret_code :=2;
626: ec_debug.pl(0,'EC','ECE_UTL_INVALID_MODE',null);

Line 624: WHEN UTL_FILE.invalid_mode THEN

620: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
621: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
622: utl_file.fclose(u_file_handle);
623: raise EC_UTILS.PROGRAM_EXIT;
624: WHEN UTL_FILE.invalid_mode THEN
625: EC_UTILS.i_ret_code :=2;
626: ec_debug.pl(0,'EC','ECE_UTL_INVALID_MODE',null);
627: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
628: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 629: utl_file.fclose(u_file_handle);

625: EC_UTILS.i_ret_code :=2;
626: ec_debug.pl(0,'EC','ECE_UTL_INVALID_MODE',null);
627: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
628: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
629: utl_file.fclose(u_file_handle);
630: raise EC_UTILS.PROGRAM_EXIT;
631: WHEN UTL_FILE.invalid_operation THEN
632: EC_UTILS.i_ret_code :=2;
633: ec_debug.pl(0,'EC','ECE_UTL_INVALID_OPERATION',null);

Line 631: WHEN UTL_FILE.invalid_operation THEN

627: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
628: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
629: utl_file.fclose(u_file_handle);
630: raise EC_UTILS.PROGRAM_EXIT;
631: WHEN UTL_FILE.invalid_operation THEN
632: EC_UTILS.i_ret_code :=2;
633: ec_debug.pl(0,'EC','ECE_UTL_INVALID_OPERATION',null);
634: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
635: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 636: utl_file.fclose(u_file_handle);

632: EC_UTILS.i_ret_code :=2;
633: ec_debug.pl(0,'EC','ECE_UTL_INVALID_OPERATION',null);
634: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
635: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
636: utl_file.fclose(u_file_handle);
637: raise EC_UTILS.PROGRAM_EXIT;
638: WHEN UTL_FILE.invalid_filehandle THEN
639: EC_UTILS.i_ret_code :=2;
640: ec_debug.pl(0,'EC','ECE_UTL_INVALID_FILEHANDLE',null);

Line 638: WHEN UTL_FILE.invalid_filehandle THEN

634: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
635: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
636: utl_file.fclose(u_file_handle);
637: raise EC_UTILS.PROGRAM_EXIT;
638: WHEN UTL_FILE.invalid_filehandle THEN
639: EC_UTILS.i_ret_code :=2;
640: ec_debug.pl(0,'EC','ECE_UTL_INVALID_FILEHANDLE',null);
641: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
642: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 643: utl_file.fclose(u_file_handle);

639: EC_UTILS.i_ret_code :=2;
640: ec_debug.pl(0,'EC','ECE_UTL_INVALID_FILEHANDLE',null);
641: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
642: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
643: utl_file.fclose(u_file_handle);
644: raise EC_UTILS.PROGRAM_EXIT;
645: WHEN UTL_FILE.internal_error THEN
646: EC_UTILS.i_ret_code :=2;
647: ec_debug.pl(0,'EC','ECE_UTL_INTERNAL_ERROR',null);

Line 645: WHEN UTL_FILE.internal_error THEN

641: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
642: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
643: utl_file.fclose(u_file_handle);
644: raise EC_UTILS.PROGRAM_EXIT;
645: WHEN UTL_FILE.internal_error THEN
646: EC_UTILS.i_ret_code :=2;
647: ec_debug.pl(0,'EC','ECE_UTL_INTERNAL_ERROR',null);
648: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
649: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

Line 650: utl_file.fclose(u_file_handle);

646: EC_UTILS.i_ret_code :=2;
647: ec_debug.pl(0,'EC','ECE_UTL_INTERNAL_ERROR',null);
648: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
649: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
650: utl_file.fclose(u_file_handle);
651: raise EC_UTILS.PROGRAM_EXIT;
652: WHEN EC_UTILS.PROGRAM_EXIT THEN
653: raise;
654: WHEN OTHERS THEN

Line 658: utl_file.fclose(u_file_handle);

654: WHEN OTHERS THEN
655: EC_UTILS.i_ret_code :=2;
656: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','EC_INBOUND_STAGE.LOAD_DATA');
657: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
658: utl_file.fclose(u_file_handle);
659: raise EC_UTILS.PROGRAM_EXIT;
660: END Load_Data;
661:
662: /**