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

Line 114: l_outfile_handle UTL_FILE.FILE_TYPE;

110: l_data VARCHAR2(2000);
111: lot_rec GMIGAPI.lot_rec_typ;
112: l_p_dir VARCHAR2(50);
113: l_output_file VARCHAR2(20);
114: l_outfile_handle UTL_FILE.FILE_TYPE;
115: l_input_file VARCHAR2(20);
116: l_infile_handle UTL_FILE.FILE_TYPE;
117: l_line VARCHAR2(200);
118: l_delimiter VARCHAR(1);

Line 116: l_infile_handle UTL_FILE.FILE_TYPE;

112: l_p_dir VARCHAR2(50);
113: l_output_file VARCHAR2(20);
114: l_outfile_handle UTL_FILE.FILE_TYPE;
115: l_input_file VARCHAR2(20);
116: l_infile_handle UTL_FILE.FILE_TYPE;
117: l_line VARCHAR2(200);
118: l_delimiter VARCHAR(1);
119: l_log_dir VARCHAR2(50);
120: l_log_name VARCHAR2(20) :='wrapper';

Line 121: l_log_handle UTL_FILE.FILE_TYPE;

117: l_line VARCHAR2(200);
118: l_delimiter VARCHAR(1);
119: l_log_dir VARCHAR2(50);
120: l_log_name VARCHAR2(20) :='wrapper';
121: l_log_handle UTL_FILE.FILE_TYPE;
122: l_global_file VARCHAR2(20);
123:
124: l_session_id VARCHAR2(10);
125: l_ic_lots_mst_row ic_lots_mst%ROWTYPE;

Line 156: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');

152: /*
153: Open The Wrapper File For Output And The Input File for Input.
154: */
155:
156: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
157: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
158:
159: /*
160: Loop thru flat file and call Inventory Quantities API

Line 157: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');

153: Open The Wrapper File For Output And The Input File for Input.
154: */
155:
156: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
157: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
158:
159: /*
160: Loop thru flat file and call Inventory Quantities API
161: */

Line 164: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at '

160: Loop thru flat file and call Inventory Quantities API
161: */
162:
163: /* dbms_output.put_line('Start Processing'); */
164: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at '
165: || to_char(SYSDATE,'DD-MON-YY HH:MI:SS'));
166:
167: UTL_FILE.NEW_LINE(l_log_handle);
168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );

Line 167: UTL_FILE.NEW_LINE(l_log_handle);

163: /* dbms_output.put_line('Start Processing'); */
164: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at '
165: || to_char(SYSDATE,'DD-MON-YY HH:MI:SS'));
166:
167: UTL_FILE.NEW_LINE(l_log_handle);
168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
169: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
170: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
171: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );

Line 168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );

164: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at '
165: || to_char(SYSDATE,'DD-MON-YY HH:MI:SS'));
166:
167: UTL_FILE.NEW_LINE(l_log_handle);
168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
169: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
170: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
171: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
172:

Line 169: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );

165: || to_char(SYSDATE,'DD-MON-YY HH:MI:SS'));
166:
167: UTL_FILE.NEW_LINE(l_log_handle);
168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
169: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
170: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
171: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
172:
173: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');

Line 170: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );

166:
167: UTL_FILE.NEW_LINE(l_log_handle);
168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
169: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
170: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
171: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
172:
173: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');
174:

Line 171: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );

167: UTL_FILE.NEW_LINE(l_log_handle);
168: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
169: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
170: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
171: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
172:
173: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');
174:
175: LOOP

Line 173: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');

169: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
170: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
171: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
172:
173: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');
174:
175: LOOP
176: l_record_count :=l_record_count+1;
177:

Line 179: UTL_FILE.GET_LINE(l_infile_handle, l_line);

175: LOOP
176: l_record_count :=l_record_count+1;
177:
178: BEGIN
179: UTL_FILE.GET_LINE(l_infile_handle, l_line);
180: EXCEPTION
181: WHEN NO_DATA_FOUND THEN
182: EXIT;
183: END;

Line 185: UTL_FILE.NEW_LINE(l_log_handle);

181: WHEN NO_DATA_FOUND THEN
182: EXIT;
183: END;
184:
185: UTL_FILE.NEW_LINE(l_log_handle);
186: UTL_FILE.PUT_LINE(l_log_handle, 'Reading Record ' || l_record_count );
187:
188: lot_rec.item_no :=Get_Field(l_line,l_delimiter,1);
189: lot_rec.lot_no :=Get_Field(l_line,l_delimiter,2);

Line 186: UTL_FILE.PUT_LINE(l_log_handle, 'Reading Record ' || l_record_count );

182: EXIT;
183: END;
184:
185: UTL_FILE.NEW_LINE(l_log_handle);
186: UTL_FILE.PUT_LINE(l_log_handle, 'Reading Record ' || l_record_count );
187:
188: lot_rec.item_no :=Get_Field(l_line,l_delimiter,1);
189: lot_rec.lot_no :=Get_Field(l_line,l_delimiter,2);
190: lot_rec.sublot_no :=Get_Field(l_line,l_delimiter,3);

Line 302: UTL_FILE.PUT_LINE(l_log_handle,'item no = '||lot_rec.item_no);

298: lot_rec.attribute29 :=Get_Field(l_line,l_delimiter,47);
299: lot_rec.attribute30 :=Get_Field(l_line,l_delimiter,48);
300: lot_rec.attribute_category :=Get_Field(l_line,l_delimiter,49);
301:
302: UTL_FILE.PUT_LINE(l_log_handle,'item no = '||lot_rec.item_no);
303: UTL_FILE.PUT_LINE(l_log_handle,'lot_no = '||lot_rec.lot_no);
304: UTL_FILE.PUT_LINE(l_log_handle,'sublot_no = '||lot_rec.sublot_no);
305: UTL_FILE.PUT_LINE(l_log_handle,'lot_desc = '||lot_rec.lot_desc);
306: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||lot_rec.qc_grade);

Line 303: UTL_FILE.PUT_LINE(l_log_handle,'lot_no = '||lot_rec.lot_no);

299: lot_rec.attribute30 :=Get_Field(l_line,l_delimiter,48);
300: lot_rec.attribute_category :=Get_Field(l_line,l_delimiter,49);
301:
302: UTL_FILE.PUT_LINE(l_log_handle,'item no = '||lot_rec.item_no);
303: UTL_FILE.PUT_LINE(l_log_handle,'lot_no = '||lot_rec.lot_no);
304: UTL_FILE.PUT_LINE(l_log_handle,'sublot_no = '||lot_rec.sublot_no);
305: UTL_FILE.PUT_LINE(l_log_handle,'lot_desc = '||lot_rec.lot_desc);
306: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||lot_rec.qc_grade);
307: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||

Line 304: UTL_FILE.PUT_LINE(l_log_handle,'sublot_no = '||lot_rec.sublot_no);

300: lot_rec.attribute_category :=Get_Field(l_line,l_delimiter,49);
301:
302: UTL_FILE.PUT_LINE(l_log_handle,'item no = '||lot_rec.item_no);
303: UTL_FILE.PUT_LINE(l_log_handle,'lot_no = '||lot_rec.lot_no);
304: UTL_FILE.PUT_LINE(l_log_handle,'sublot_no = '||lot_rec.sublot_no);
305: UTL_FILE.PUT_LINE(l_log_handle,'lot_desc = '||lot_rec.lot_desc);
306: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||lot_rec.qc_grade);
307: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||
308: lot_rec.expaction_code);

Line 305: UTL_FILE.PUT_LINE(l_log_handle,'lot_desc = '||lot_rec.lot_desc);

301:
302: UTL_FILE.PUT_LINE(l_log_handle,'item no = '||lot_rec.item_no);
303: UTL_FILE.PUT_LINE(l_log_handle,'lot_no = '||lot_rec.lot_no);
304: UTL_FILE.PUT_LINE(l_log_handle,'sublot_no = '||lot_rec.sublot_no);
305: UTL_FILE.PUT_LINE(l_log_handle,'lot_desc = '||lot_rec.lot_desc);
306: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||lot_rec.qc_grade);
307: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||
308: lot_rec.expaction_code);
309: UTL_FILE.PUT_LINE(l_log_handle,'expaction_date = '||

Line 306: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||lot_rec.qc_grade);

302: UTL_FILE.PUT_LINE(l_log_handle,'item no = '||lot_rec.item_no);
303: UTL_FILE.PUT_LINE(l_log_handle,'lot_no = '||lot_rec.lot_no);
304: UTL_FILE.PUT_LINE(l_log_handle,'sublot_no = '||lot_rec.sublot_no);
305: UTL_FILE.PUT_LINE(l_log_handle,'lot_desc = '||lot_rec.lot_desc);
306: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||lot_rec.qc_grade);
307: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||
308: lot_rec.expaction_code);
309: UTL_FILE.PUT_LINE(l_log_handle,'expaction_date = '||
310: lot_rec.expaction_date);

Line 307: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||

303: UTL_FILE.PUT_LINE(l_log_handle,'lot_no = '||lot_rec.lot_no);
304: UTL_FILE.PUT_LINE(l_log_handle,'sublot_no = '||lot_rec.sublot_no);
305: UTL_FILE.PUT_LINE(l_log_handle,'lot_desc = '||lot_rec.lot_desc);
306: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||lot_rec.qc_grade);
307: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||
308: lot_rec.expaction_code);
309: UTL_FILE.PUT_LINE(l_log_handle,'expaction_date = '||
310: lot_rec.expaction_date);
311: UTL_FILE.PUT_LINE(l_log_handle,'lot_created = '||

Line 309: UTL_FILE.PUT_LINE(l_log_handle,'expaction_date = '||

305: UTL_FILE.PUT_LINE(l_log_handle,'lot_desc = '||lot_rec.lot_desc);
306: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||lot_rec.qc_grade);
307: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||
308: lot_rec.expaction_code);
309: UTL_FILE.PUT_LINE(l_log_handle,'expaction_date = '||
310: lot_rec.expaction_date);
311: UTL_FILE.PUT_LINE(l_log_handle,'lot_created = '||
312: lot_rec.lot_created);
313: UTL_FILE.PUT_LINE(l_log_handle,'expire_date = '||

Line 311: UTL_FILE.PUT_LINE(l_log_handle,'lot_created = '||

307: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||
308: lot_rec.expaction_code);
309: UTL_FILE.PUT_LINE(l_log_handle,'expaction_date = '||
310: lot_rec.expaction_date);
311: UTL_FILE.PUT_LINE(l_log_handle,'lot_created = '||
312: lot_rec.lot_created);
313: UTL_FILE.PUT_LINE(l_log_handle,'expire_date = '||
314: lot_rec.expire_date);
315: UTL_FILE.PUT_LINE(l_log_handle,'retest_date = '||

Line 313: UTL_FILE.PUT_LINE(l_log_handle,'expire_date = '||

309: UTL_FILE.PUT_LINE(l_log_handle,'expaction_date = '||
310: lot_rec.expaction_date);
311: UTL_FILE.PUT_LINE(l_log_handle,'lot_created = '||
312: lot_rec.lot_created);
313: UTL_FILE.PUT_LINE(l_log_handle,'expire_date = '||
314: lot_rec.expire_date);
315: UTL_FILE.PUT_LINE(l_log_handle,'retest_date = '||
316: lot_rec.retest_date);
317: UTL_FILE.PUT_LINE(l_log_handle,'strength = '||lot_rec.strength);

Line 315: UTL_FILE.PUT_LINE(l_log_handle,'retest_date = '||

311: UTL_FILE.PUT_LINE(l_log_handle,'lot_created = '||
312: lot_rec.lot_created);
313: UTL_FILE.PUT_LINE(l_log_handle,'expire_date = '||
314: lot_rec.expire_date);
315: UTL_FILE.PUT_LINE(l_log_handle,'retest_date = '||
316: lot_rec.retest_date);
317: UTL_FILE.PUT_LINE(l_log_handle,'strength = '||lot_rec.strength);
318: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||lot_rec.inactive_ind);
319: UTL_FILE.PUT_LINE(l_log_handle,'origination_type = '||

Line 317: UTL_FILE.PUT_LINE(l_log_handle,'strength = '||lot_rec.strength);

313: UTL_FILE.PUT_LINE(l_log_handle,'expire_date = '||
314: lot_rec.expire_date);
315: UTL_FILE.PUT_LINE(l_log_handle,'retest_date = '||
316: lot_rec.retest_date);
317: UTL_FILE.PUT_LINE(l_log_handle,'strength = '||lot_rec.strength);
318: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||lot_rec.inactive_ind);
319: UTL_FILE.PUT_LINE(l_log_handle,'origination_type = '||
320: lot_rec.origination_type);
321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);

Line 318: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||lot_rec.inactive_ind);

314: lot_rec.expire_date);
315: UTL_FILE.PUT_LINE(l_log_handle,'retest_date = '||
316: lot_rec.retest_date);
317: UTL_FILE.PUT_LINE(l_log_handle,'strength = '||lot_rec.strength);
318: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||lot_rec.inactive_ind);
319: UTL_FILE.PUT_LINE(l_log_handle,'origination_type = '||
320: lot_rec.origination_type);
321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);
322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);

Line 319: UTL_FILE.PUT_LINE(l_log_handle,'origination_type = '||

315: UTL_FILE.PUT_LINE(l_log_handle,'retest_date = '||
316: lot_rec.retest_date);
317: UTL_FILE.PUT_LINE(l_log_handle,'strength = '||lot_rec.strength);
318: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||lot_rec.inactive_ind);
319: UTL_FILE.PUT_LINE(l_log_handle,'origination_type = '||
320: lot_rec.origination_type);
321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);
322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);
323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);

Line 321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);

317: UTL_FILE.PUT_LINE(l_log_handle,'strength = '||lot_rec.strength);
318: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||lot_rec.inactive_ind);
319: UTL_FILE.PUT_LINE(l_log_handle,'origination_type = '||
320: lot_rec.origination_type);
321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);
322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);
323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);
324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);
325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );

Line 322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);

318: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||lot_rec.inactive_ind);
319: UTL_FILE.PUT_LINE(l_log_handle,'origination_type = '||
320: lot_rec.origination_type);
321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);
322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);
323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);
324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);
325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );
326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );

Line 323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);

319: UTL_FILE.PUT_LINE(l_log_handle,'origination_type = '||
320: lot_rec.origination_type);
321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);
322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);
323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);
324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);
325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );
326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );
327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );

Line 324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);

320: lot_rec.origination_type);
321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);
322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);
323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);
324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);
325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );
326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );
327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );
328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );

Line 325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );

321: UTL_FILE.PUT_LINE(l_log_handle,'shipvendor_no = '||lot_rec.shipvendor_no);
322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);
323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);
324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);
325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );
326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );
327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );
328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );
329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );

Line 326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );

322: UTL_FILE.PUT_LINE(l_log_handle,'vendor_lot_no = '||lot_rec.vendor_lot_no);
323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);
324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);
325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );
326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );
327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );
328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );
329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );
330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );

Line 327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );

323: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_date = '||lot_rec.ic_matr_date);
324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);
325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );
326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );
327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );
328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );
329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );
330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );
331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );

Line 328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );

324: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_date = '||lot_rec.ic_hold_date);
325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );
326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );
327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );
328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );
329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );
330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );
331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );
332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );

Line 329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );

325: UTL_FILE.PUT_LINE(l_log_handle,'user name = '||lot_rec.user_name );
326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );
327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );
328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );
329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );
330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );
331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );
332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );
333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );

Line 330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );

326: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| lot_rec.attribute1 );
327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );
328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );
329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );
330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );
331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );
332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );
333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );
334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );

Line 331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );

327: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| lot_rec.attribute2 );
328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );
329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );
330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );
331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );
332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );
333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );
334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );
335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );

Line 332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );

328: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| lot_rec.attribute3 );
329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );
330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );
331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );
332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );
333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );
334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );
335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );
336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );

Line 333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );

329: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| lot_rec.attribute4 );
330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );
331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );
332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );
333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );
334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );
335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );
336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );
337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );

Line 334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );

330: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| lot_rec.attribute5 );
331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );
332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );
333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );
334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );
335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );
336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );
337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );
338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );

Line 335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );

331: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| lot_rec.attribute6 );
332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );
333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );
334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );
335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );
336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );
337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );
338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );
339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );

Line 336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );

332: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| lot_rec.attribute7 );
333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );
334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );
335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );
336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );
337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );
338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );
339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );
340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );

Line 337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );

333: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| lot_rec.attribute8 );
334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );
335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );
336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );
337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );
338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );
339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );
340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );
341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );

Line 338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );

334: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| lot_rec.attribute9 );
335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );
336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );
337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );
338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );
339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );
340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );
341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );
342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );

Line 339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );

335: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| lot_rec.attribute10 );
336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );
337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );
338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );
339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );
340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );
341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );
342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );
343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );

Line 340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );

336: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| lot_rec.attribute11 );
337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );
338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );
339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );
340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );
341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );
342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );
343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );
344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );

Line 341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );

337: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| lot_rec.attribute12 );
338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );
339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );
340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );
341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );
342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );
343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );
344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );
345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );

Line 342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );

338: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| lot_rec.attribute13 );
339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );
340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );
341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );
342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );
343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );
344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );
345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );
346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );

Line 343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );

339: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| lot_rec.attribute14 );
340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );
341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );
342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );
343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );
344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );
345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );
346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );
347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );

Line 344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );

340: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| lot_rec.attribute15 );
341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );
342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );
343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );
344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );
345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );
346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );
347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );
348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );

Line 345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );

341: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| lot_rec.attribute16 );
342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );
343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );
344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );
345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );
346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );
347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );
348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );
349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );

Line 346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );

342: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| lot_rec.attribute17 );
343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );
344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );
345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );
346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );
347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );
348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );
349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );
350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );

Line 347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );

343: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| lot_rec.attribute18 );
344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );
345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );
346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );
347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );
348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );
349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );
350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );
351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );

Line 348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );

344: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| lot_rec.attribute19 );
345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );
346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );
347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );
348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );
349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );
350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );
351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );
352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );

Line 349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );

345: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| lot_rec.attribute20 );
346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );
347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );
348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );
349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );
350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );
351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );
352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );
353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );

Line 350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );

346: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| lot_rec.attribute21 );
347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );
348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );
349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );
350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );
351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );
352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );
353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );
354: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| lot_rec.attribute29 );

Line 351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );

347: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| lot_rec.attribute22 );
348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );
349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );
350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );
351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );
352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );
353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );
354: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| lot_rec.attribute29 );
355: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| lot_rec.attribute30 );

Line 352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );

348: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| lot_rec.attribute23 );
349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );
350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );
351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );
352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );
353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );
354: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| lot_rec.attribute29 );
355: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| lot_rec.attribute30 );
356: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| lot_rec.attribute_category );

Line 353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );

349: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| lot_rec.attribute24 );
350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );
351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );
352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );
353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );
354: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| lot_rec.attribute29 );
355: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| lot_rec.attribute30 );
356: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| lot_rec.attribute_category );
357:

Line 354: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| lot_rec.attribute29 );

350: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| lot_rec.attribute25 );
351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );
352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );
353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );
354: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| lot_rec.attribute29 );
355: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| lot_rec.attribute30 );
356: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| lot_rec.attribute_category );
357:
358: GMIPAPI.Create_Lot

Line 355: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| lot_rec.attribute30 );

351: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| lot_rec.attribute26 );
352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );
353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );
354: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| lot_rec.attribute29 );
355: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| lot_rec.attribute30 );
356: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| lot_rec.attribute_category );
357:
358: GMIPAPI.Create_Lot
359: ( p_api_version => 3.0

Line 356: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| lot_rec.attribute_category );

352: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| lot_rec.attribute27 );
353: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| lot_rec.attribute28 );
354: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| lot_rec.attribute29 );
355: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| lot_rec.attribute30 );
356: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| lot_rec.attribute_category );
357:
358: GMIPAPI.Create_Lot
359: ( p_api_version => 3.0
360: , p_init_msg_list => FND_API.G_TRUE

Line 384: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );

380: p_msg_index_out => l_dummy_cnt);
381:
382: /* dbms_output.put_line('Message ' || l_data ); */
383:
384: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
385: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
386: UTL_FILE.NEW_LINE(l_outfile_handle);
387:
388: IF l_status = 'E' OR

Line 385: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);

381:
382: /* dbms_output.put_line('Message ' || l_data ); */
383:
384: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
385: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
386: UTL_FILE.NEW_LINE(l_outfile_handle);
387:
388: IF l_status = 'E' OR
389: l_status = 'U'

Line 386: UTL_FILE.NEW_LINE(l_outfile_handle);

382: /* dbms_output.put_line('Message ' || l_data ); */
383:
384: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
385: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
386: UTL_FILE.NEW_LINE(l_outfile_handle);
387:
388: IF l_status = 'E' OR
389: l_status = 'U'
390: THEN

Line 394: UTL_FILE.PUT_LINE(l_log_handle, l_data);

390: THEN
391: l_data := CONCAT('ERROR ',l_data);
392: END IF;
393:
394: UTL_FILE.PUT_LINE(l_log_handle, l_data);
395:
396: /* Update error status */
397: IF (l_status = 'U')
398: THEN

Line 418: UTL_FILE.NEW_LINE(l_log_handle);

414:
415: END IF;
416:
417: END LOOP;
418: UTL_FILE.NEW_LINE(l_log_handle);
419: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at '
420: || to_char(SYSDATE,'DD-MON-YY HH:MI:SS'));
421: /*
422: Check if any messages generated. If so then decode and

Line 419: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at '

415: END IF;
416:
417: END LOOP;
418: UTL_FILE.NEW_LINE(l_log_handle);
419: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at '
420: || to_char(SYSDATE,'DD-MON-YY HH:MI:SS'));
421: /*
422: Check if any messages generated. If so then decode and
423: output to error message flat file

Line 426: UTL_FILE.FCLOSE_ALL;

422: Check if any messages generated. If so then decode and
423: output to error message flat file
424: */
425:
426: UTL_FILE.FCLOSE_ALL;
427:
428: RETURN l_return_status;
429:
430: EXCEPTION

Line 431: WHEN UTL_FILE.INVALID_OPERATION THEN

427:
428: RETURN l_return_status;
429:
430: EXCEPTION
431: WHEN UTL_FILE.INVALID_OPERATION THEN
432: /* dbms_output.put_line('Invalid Operation For '|| l_global_file); */
433: UTL_FILE.FCLOSE_ALL;
434:
435: WHEN UTL_FILE.INVALID_PATH THEN

Line 433: UTL_FILE.FCLOSE_ALL;

429:
430: EXCEPTION
431: WHEN UTL_FILE.INVALID_OPERATION THEN
432: /* dbms_output.put_line('Invalid Operation For '|| l_global_file); */
433: UTL_FILE.FCLOSE_ALL;
434:
435: WHEN UTL_FILE.INVALID_PATH THEN
436: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
437: UTL_FILE.FCLOSE_ALL;

Line 435: WHEN UTL_FILE.INVALID_PATH THEN

431: WHEN UTL_FILE.INVALID_OPERATION THEN
432: /* dbms_output.put_line('Invalid Operation For '|| l_global_file); */
433: UTL_FILE.FCLOSE_ALL;
434:
435: WHEN UTL_FILE.INVALID_PATH THEN
436: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
437: UTL_FILE.FCLOSE_ALL;
438:
439: WHEN UTL_FILE.INVALID_MODE THEN

Line 437: UTL_FILE.FCLOSE_ALL;

433: UTL_FILE.FCLOSE_ALL;
434:
435: WHEN UTL_FILE.INVALID_PATH THEN
436: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
437: UTL_FILE.FCLOSE_ALL;
438:
439: WHEN UTL_FILE.INVALID_MODE THEN
440: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
441: UTL_FILE.FCLOSE_ALL;

Line 439: WHEN UTL_FILE.INVALID_MODE THEN

435: WHEN UTL_FILE.INVALID_PATH THEN
436: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
437: UTL_FILE.FCLOSE_ALL;
438:
439: WHEN UTL_FILE.INVALID_MODE THEN
440: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
441: UTL_FILE.FCLOSE_ALL;
442:
443: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 441: UTL_FILE.FCLOSE_ALL;

437: UTL_FILE.FCLOSE_ALL;
438:
439: WHEN UTL_FILE.INVALID_MODE THEN
440: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
441: UTL_FILE.FCLOSE_ALL;
442:
443: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
444: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
445: UTL_FILE.FCLOSE_ALL;

Line 443: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

439: WHEN UTL_FILE.INVALID_MODE THEN
440: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
441: UTL_FILE.FCLOSE_ALL;
442:
443: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
444: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
445: UTL_FILE.FCLOSE_ALL;
446:
447: WHEN UTL_FILE.WRITE_ERROR THEN

Line 445: UTL_FILE.FCLOSE_ALL;

441: UTL_FILE.FCLOSE_ALL;
442:
443: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
444: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
445: UTL_FILE.FCLOSE_ALL;
446:
447: WHEN UTL_FILE.WRITE_ERROR THEN
448: /* dbms_output.put_line('Invalid Write Error '|| l_global_file); */
449: UTL_FILE.FCLOSE_ALL;

Line 447: WHEN UTL_FILE.WRITE_ERROR THEN

443: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
444: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
445: UTL_FILE.FCLOSE_ALL;
446:
447: WHEN UTL_FILE.WRITE_ERROR THEN
448: /* dbms_output.put_line('Invalid Write Error '|| l_global_file); */
449: UTL_FILE.FCLOSE_ALL;
450:
451: WHEN UTL_FILE.READ_ERROR THEN

Line 449: UTL_FILE.FCLOSE_ALL;

445: UTL_FILE.FCLOSE_ALL;
446:
447: WHEN UTL_FILE.WRITE_ERROR THEN
448: /* dbms_output.put_line('Invalid Write Error '|| l_global_file); */
449: UTL_FILE.FCLOSE_ALL;
450:
451: WHEN UTL_FILE.READ_ERROR THEN
452: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
453: UTL_FILE.FCLOSE_ALL;

Line 451: WHEN UTL_FILE.READ_ERROR THEN

447: WHEN UTL_FILE.WRITE_ERROR THEN
448: /* dbms_output.put_line('Invalid Write Error '|| l_global_file); */
449: UTL_FILE.FCLOSE_ALL;
450:
451: WHEN UTL_FILE.READ_ERROR THEN
452: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
453: UTL_FILE.FCLOSE_ALL;
454:
455: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 453: UTL_FILE.FCLOSE_ALL;

449: UTL_FILE.FCLOSE_ALL;
450:
451: WHEN UTL_FILE.READ_ERROR THEN
452: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
453: UTL_FILE.FCLOSE_ALL;
454:
455: WHEN UTL_FILE.INTERNAL_ERROR THEN
456: /* dbms_output.put_line('Internal Error'); */
457: UTL_FILE.FCLOSE_ALL;

Line 455: WHEN UTL_FILE.INTERNAL_ERROR THEN

451: WHEN UTL_FILE.READ_ERROR THEN
452: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
453: UTL_FILE.FCLOSE_ALL;
454:
455: WHEN UTL_FILE.INTERNAL_ERROR THEN
456: /* dbms_output.put_line('Internal Error'); */
457: UTL_FILE.FCLOSE_ALL;
458:
459: WHEN OTHERS THEN

Line 457: UTL_FILE.FCLOSE_ALL;

453: UTL_FILE.FCLOSE_ALL;
454:
455: WHEN UTL_FILE.INTERNAL_ERROR THEN
456: /* dbms_output.put_line('Internal Error'); */
457: UTL_FILE.FCLOSE_ALL;
458:
459: WHEN OTHERS THEN
460: /* dbms_output.put_line('Other Error'); */
461: UTL_FILE.FCLOSE_ALL;

Line 461: UTL_FILE.FCLOSE_ALL;

457: UTL_FILE.FCLOSE_ALL;
458:
459: WHEN OTHERS THEN
460: /* dbms_output.put_line('Other Error'); */
461: UTL_FILE.FCLOSE_ALL;
462:
463: END Create_Lot;
464:
465: /* +==========================================================================+