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

Line 26: uFile_type utl_file.file_type;

22: p_communication_method VARCHAR2(120) := 'EDI';
23: p_transaction_type VARCHAR2(120) := 'SPSO';
24: p_document_type VARCHAR2(120) := 'SPS';
25: l_line_text VARCHAR2(2000);
26: uFile_type utl_file.file_type;
27: p_output_width INTEGER := 4000;
28: p_run_id INTEGER;
29: p_header_interface VARCHAR2(120) := 'ECE_SPSO_HEADERS';
30: p_item_interface VARCHAR2(120) := 'ECE_SPSO_ITEMS';

Line 134: if (NOT utl_file.is_open(uFile_type)) then

130: FETCH c_output
131: INTO l_line_text;
132:
133: if (c_output%ROWCOUNT > 0) then
134: if (NOT utl_file.is_open(uFile_type)) then
135: uFile_type := utl_file.fopen ( cOutput_Path,
136: cOutput_Filename,
137: 'W' );
138: end if;

Line 135: uFile_type := utl_file.fopen ( cOutput_Path,

131: INTO l_line_text;
132:
133: if (c_output%ROWCOUNT > 0) then
134: if (NOT utl_file.is_open(uFile_type)) then
135: uFile_type := utl_file.fopen ( cOutput_Path,
136: cOutput_Filename,
137: 'W' );
138: end if;
139: end if;

Line 146: utl_file.put_line ( uFile_type,l_line_text );

142:
143: -- Write the data from ece_output to the output file.
144:
145: xProgress := 'SPSO-10-1090';
146: utl_file.put_line ( uFile_type,l_line_text );
147: ec_debug.pl ( 3, 'l_line_text: ',l_line_text );
148:
149: END LOOP;
150:

Line 156: if (utl_file.is_open( uFile_type)) then

152:
153: -- Close the output file.
154:
155: xProgress := 'SPSO-10-1100';
156: if (utl_file.is_open( uFile_type)) then
157: utl_file.fclose ( uFile_type );
158: end if;
159:
160: xProgress := 'SPSO-10-1110';

Line 157: utl_file.fclose ( uFile_type );

153: -- Close the output file.
154:
155: xProgress := 'SPSO-10-1100';
156: if (utl_file.is_open( uFile_type)) then
157: utl_file.fclose ( uFile_type );
158: end if;
159:
160: xProgress := 'SPSO-10-1110';
161: ec_debug.pl ( 0, 'EC', 'ECE_SPSO_COMPLETE ',NULL );

Line 197: WHEN utl_file.write_error THEN

193: retcode := 1;
194: ec_debug.disable_debug;
195: ROLLBACK;
196:
197: WHEN utl_file.write_error THEN
198:
199: ec_debug.pl ( 0,
200: 'EC',
201: 'ECE_UTL_WRITE_ERROR',

Line 215: WHEN utl_file.invalid_path THEN

211: ec_debug.disable_debug;
212: ROLLBACK;
213: RAISE;
214:
215: WHEN utl_file.invalid_path THEN
216:
217: ec_debug.pl ( 0,
218: 'EC',
219: 'ECE_UTIL_INVALID_PATH',

Line 233: WHEN utl_file.invalid_operation THEN

229: ec_debug.disable_debug;
230: ROLLBACK;
231: RAISE;
232:
233: WHEN utl_file.invalid_operation THEN
234:
235: ec_debug.pl ( 0,
236: 'EC',
237: 'ECE_UTIL_INVALID_OPERATION',

Line 297: uFile_type utl_file.file_type;

293: p_communication_method VARCHAR2(120) := 'EDI';
294: p_transaction_type VARCHAR2(120) := 'SSSO';
295: p_document_type VARCHAR2(120) := 'SSS';
296: l_line_text VARCHAR2(2000);
297: uFile_type utl_file.file_type;
298: p_output_width INTEGER := 4000;
299: p_run_id NUMBER ;
300: p_header_interface VARCHAR2(120) := 'ECE_SPSO_HEADERS';
301: p_item_interface VARCHAR2(120) := 'ECE_SPSO_ITEMS';

Line 404: if (NOT utl_file.is_open(uFile_type)) then

400: LOOP
401: FETCH c_output
402: INTO l_line_text;
403: if (c_output%ROWCOUNT > 0) then
404: if (NOT utl_file.is_open(uFile_type)) then
405: uFile_type := utl_file.fopen ( cOutput_Path,
406: cOutput_Filename,
407: 'W' );
408: end if;

Line 405: uFile_type := utl_file.fopen ( cOutput_Path,

401: FETCH c_output
402: INTO l_line_text;
403: if (c_output%ROWCOUNT > 0) then
404: if (NOT utl_file.is_open(uFile_type)) then
405: uFile_type := utl_file.fopen ( cOutput_Path,
406: cOutput_Filename,
407: 'W' );
408: end if;
409: end if;

Line 415: utl_file.put_line ( uFile_type,

411:
412: -- Write the data from ece_output to the output file.
413:
414: xProgress := 'SSSO-10-1090';
415: utl_file.put_line ( uFile_type,
416: l_line_text );
417: ec_debug.pl ( 3, 'l_line_text: ',l_line_text );
418:
419: END LOOP;

Line 426: if (utl_file.is_open( uFile_type)) then

422:
423: -- Close the output file.
424:
425: xProgress := 'SSSO-10-1100';
426: if (utl_file.is_open( uFile_type)) then
427: utl_file.fclose ( uFile_type );
428: end if;
429:
430: xProgress := 'SSSO-10-1110';

Line 427: utl_file.fclose ( uFile_type );

423: -- Close the output file.
424:
425: xProgress := 'SSSO-10-1100';
426: if (utl_file.is_open( uFile_type)) then
427: utl_file.fclose ( uFile_type );
428: end if;
429:
430: xProgress := 'SSSO-10-1110';
431: ec_debug.pl ( 0, 'EC', 'ECE_SSSO_COMPLETE', NULL );

Line 468: WHEN utl_file.write_error THEN

464: retcode := 1;
465: ec_debug.disable_debug;
466: ROLLBACK;
467:
468: WHEN utl_file.write_error THEN
469:
470: ec_debug.pl ( 0,
471: 'EC',
472: 'ECE_UTL_WRITE_ERROR',

Line 487: WHEN utl_file.invalid_path THEN

483: ec_debug.disable_debug;
484: ROLLBACK;
485: RAISE;
486:
487: WHEN utl_file.invalid_path THEN
488:
489: ec_debug.pl ( 0,
490: 'EC',
491: 'ECE_UTIL_INVALID_PATH',

Line 505: WHEN utl_file.invalid_operation THEN

501: ec_debug.disable_debug;
502: ROLLBACK;
503: RAISE;
504:
505: WHEN utl_file.invalid_operation THEN
506:
507: ec_debug.pl ( 0,
508: 'EC', '
509: ECE_UTIL_INVALID_OPERATION',

Line 743: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN

739: ec_debug.pl ( 3, 'cItem_D_Interface: ',cItem_D_Interface );
740:
741: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
742: -- be the directory where the output file will be written.
743: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN
744: -- THE INIT.ORA FILE. Refer to the Oracle7 documentation for more information
745: -- on the package UTL_FILE.
746:
747: xProgress := 'SPSOB-10-0100';

Line 745: -- on the package UTL_FILE.

741: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
742: -- be the directory where the output file will be written.
743: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN
744: -- THE INIT.ORA FILE. Refer to the Oracle7 documentation for more information
745: -- on the package UTL_FILE.
746:
747: xProgress := 'SPSOB-10-0100';
748: fnd_profile.get ( 'ECE_OUT_FILE_PATH',
749: cOutput_path );

Line 1828: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN

1824:
1825:
1826: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
1827: -- be the directory where the output file will be written.
1828: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN
1829: -- THE INIT.ORA FILE. Refer to the Oracle7 documentation for more information
1830: -- on the package UTL_FILE.
1831:
1832: xProgress := 'SPSOB-30-0100';

Line 1830: -- on the package UTL_FILE.

1826: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
1827: -- be the directory where the output file will be written.
1828: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN
1829: -- THE INIT.ORA FILE. Refer to the Oracle7 documentation for more information
1830: -- on the package UTL_FILE.
1831:
1832: xProgress := 'SPSOB-30-0100';
1833: fnd_profile.get('ECE_OUT_FILE_PATH',
1834: cOutput_path);

Line 2445: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN

2441: ec_debug.pl ( 3, 'p_edi_count: ',p_edi_count );
2442:
2443: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
2444: -- be the directory where the output file will be written.
2445: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN
2446: -- THE INIT.ORA FILE. Refer to the Oracle7 documentation for more information
2447: -- on the package UTL_FILE.
2448:
2449: xProgress := 'SPSOB-40-0100';

Line 2447: -- on the package UTL_FILE.

2443: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
2444: -- be the directory where the output file will be written.
2445: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN
2446: -- THE INIT.ORA FILE. Refer to the Oracle7 documentation for more information
2447: -- on the package UTL_FILE.
2448:
2449: xProgress := 'SPSOB-40-0100';
2450: fnd_profile.get ( 'ECE_OUT_FILE_PATH',
2451: cOutput_path );

Line 2632: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN

2628: ec_debug.pl ( 3, 'p_ship_d_interface: ',p_ship_d_interface );
2629:
2630: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
2631: -- be the directory where the output file will be written.
2632: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN
2633: -- THE INIT.ORA FILE. Refer to the Oracle7 documentation for more information
2634: -- on the package UTL_FILE.
2635:
2636: xProgress := 'SPSOB-50-0100';

Line 2634: -- on the package UTL_FILE.

2630: -- Retreive the system profile option ECE_OUT_FILE_PATH. This will
2631: -- be the directory where the output file will be written.
2632: -- NOTE: THIS DIRECTORY MUST BE SPECIFIED IN THE PARAMETER utl_file_dir IN
2633: -- THE INIT.ORA FILE. Refer to the Oracle7 documentation for more information
2634: -- on the package UTL_FILE.
2635:
2636: xProgress := 'SPSOB-50-0100';
2637: fnd_profile.get ( 'ECE_OUT_FILE_PATH',
2638: cOutput_path );