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

Line 115: l_outfile_handle UTL_FILE.FILE_TYPE;

111: l_ic_item_mst_row ic_item_mst%ROWTYPE;
112: l_ic_item_cpg_row ic_item_cpg%ROWTYPE;
113: l_p_dir VARCHAR2(50);
114: l_output_file VARCHAR2(20);
115: l_outfile_handle UTL_FILE.FILE_TYPE;
116: l_input_file VARCHAR2(20);
117: l_infile_handle UTL_FILE.FILE_TYPE;
118: l_line VARCHAR2(800);
119: l_delimiter VARCHAR(1);

Line 117: l_infile_handle UTL_FILE.FILE_TYPE;

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

Line 122: l_log_handle UTL_FILE.FILE_TYPE;

118: l_line VARCHAR2(800);
119: l_delimiter VARCHAR(1);
120: l_log_dir VARCHAR2(50);
121: l_log_name VARCHAR2(20) :='wrapper';
122: l_log_handle UTL_FILE.FILE_TYPE;
123: l_global_file VARCHAR2(20);
124:
125: l_session_id VARCHAR2(10);
126:

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

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

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

148:
149: /* Open The Wrapper File For Output And The Input File for Input. */
150:
151: l_log_handle :=UTL_FILE.FOPEN(l_log_dir, l_log_name, 'w');
152: l_infile_handle :=UTL_FILE.FOPEN(l_p_dir, l_input_file, 'r');
153:
154: /* Loop thru flat file and call Inventory Quantities API */
155:
156: /* dbms_output.put_line('Start Processing'); */

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

153:
154: /* Loop thru flat file and call Inventory Quantities API */
155:
156: /* dbms_output.put_line('Start Processing'); */
157: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at '
158: || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
159:
160: UTL_FILE.NEW_LINE(l_log_handle);
161: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );

Line 160: UTL_FILE.NEW_LINE(l_log_handle);

156: /* dbms_output.put_line('Start Processing'); */
157: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at '
158: || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
159:
160: UTL_FILE.NEW_LINE(l_log_handle);
161: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
162: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
163: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
164: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );

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

157: UTL_FILE.PUT_LINE(l_log_handle, 'Process Started at '
158: || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
159:
160: UTL_FILE.NEW_LINE(l_log_handle);
161: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
162: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
163: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
164: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
165:

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

158: || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
159:
160: UTL_FILE.NEW_LINE(l_log_handle);
161: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
162: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
163: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
164: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
165:
166: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');

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

159:
160: UTL_FILE.NEW_LINE(l_log_handle);
161: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
162: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
163: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
164: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
165:
166: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');
167:

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

160: UTL_FILE.NEW_LINE(l_log_handle);
161: UTL_FILE.PUT_LINE(l_log_handle, 'Input Directory ' || l_p_dir );
162: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
163: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
164: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
165:
166: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');
167:
168:

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

162: UTL_FILE.PUT_LINE(l_log_handle, 'Input File ' || l_input_file );
163: UTL_FILE.PUT_LINE(l_log_handle, 'Record Type ' || l_delimiter );
164: UTL_FILE.PUT_LINE(l_log_handle, 'Output File ' || l_output_file );
165:
166: l_outfile_handle :=UTL_FILE.FOPEN(l_p_dir, l_output_file, 'w');
167:
168:
169: LOOP
170: l_record_count :=l_record_count+1;

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

169: LOOP
170: l_record_count :=l_record_count+1;
171:
172: BEGIN
173: UTL_FILE.GET_LINE(l_infile_handle, l_line);
174: EXCEPTION
175: WHEN NO_DATA_FOUND THEN
176: EXIT;
177: END;

Line 179: UTL_FILE.NEW_LINE(l_log_handle);

175: WHEN NO_DATA_FOUND THEN
176: EXIT;
177: END;
178:
179: UTL_FILE.NEW_LINE(l_log_handle);
180: UTL_FILE.PUT_LINE(l_log_handle, 'Reading Record ' || l_record_count );
181:
182: item_rec.item_no :=Get_Field(l_line,l_delimiter,1);
183: item_rec.item_desc1 :=Get_Field(l_line,l_delimiter,2);

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

176: EXIT;
177: END;
178:
179: UTL_FILE.NEW_LINE(l_log_handle);
180: UTL_FILE.PUT_LINE(l_log_handle, 'Reading Record ' || l_record_count );
181:
182: item_rec.item_no :=Get_Field(l_line,l_delimiter,1);
183: item_rec.item_desc1 :=Get_Field(l_line,l_delimiter,2);
184: item_rec.item_desc2 :=Get_Field(l_line,l_delimiter,3);

Line 324: UTL_FILE.PUT_LINE(l_log_handle,'item_no = '||item_rec.item_no);

320: item_rec.tech_class :=Get_Field(l_line,l_delimiter,94);
321:
322:
323:
324: UTL_FILE.PUT_LINE(l_log_handle,'item_no = '||item_rec.item_no);
325: UTL_FILE.PUT_LINE(l_log_handle,'item_desc1 = '||item_rec.item_desc1);
326: UTL_FILE.PUT_LINE(l_log_handle,'item_desc2 = '||item_rec.item_desc2);
327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);
328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);

Line 325: UTL_FILE.PUT_LINE(l_log_handle,'item_desc1 = '||item_rec.item_desc1);

321:
322:
323:
324: UTL_FILE.PUT_LINE(l_log_handle,'item_no = '||item_rec.item_no);
325: UTL_FILE.PUT_LINE(l_log_handle,'item_desc1 = '||item_rec.item_desc1);
326: UTL_FILE.PUT_LINE(l_log_handle,'item_desc2 = '||item_rec.item_desc2);
327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);
328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);
329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);

Line 326: UTL_FILE.PUT_LINE(l_log_handle,'item_desc2 = '||item_rec.item_desc2);

322:
323:
324: UTL_FILE.PUT_LINE(l_log_handle,'item_no = '||item_rec.item_no);
325: UTL_FILE.PUT_LINE(l_log_handle,'item_desc1 = '||item_rec.item_desc1);
326: UTL_FILE.PUT_LINE(l_log_handle,'item_desc2 = '||item_rec.item_desc2);
327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);
328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);
329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);
330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);

Line 327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);

323:
324: UTL_FILE.PUT_LINE(l_log_handle,'item_no = '||item_rec.item_no);
325: UTL_FILE.PUT_LINE(l_log_handle,'item_desc1 = '||item_rec.item_desc1);
326: UTL_FILE.PUT_LINE(l_log_handle,'item_desc2 = '||item_rec.item_desc2);
327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);
328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);
329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);
330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);
331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);

Line 328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);

324: UTL_FILE.PUT_LINE(l_log_handle,'item_no = '||item_rec.item_no);
325: UTL_FILE.PUT_LINE(l_log_handle,'item_desc1 = '||item_rec.item_desc1);
326: UTL_FILE.PUT_LINE(l_log_handle,'item_desc2 = '||item_rec.item_desc2);
327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);
328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);
329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);
330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);
331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);
332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);

Line 329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);

325: UTL_FILE.PUT_LINE(l_log_handle,'item_desc1 = '||item_rec.item_desc1);
326: UTL_FILE.PUT_LINE(l_log_handle,'item_desc2 = '||item_rec.item_desc2);
327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);
328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);
329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);
330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);
331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);
332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);
333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);

Line 330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);

326: UTL_FILE.PUT_LINE(l_log_handle,'item_desc2 = '||item_rec.item_desc2);
327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);
328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);
329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);
330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);
331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);
332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);
333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);
334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);

Line 331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);

327: UTL_FILE.PUT_LINE(l_log_handle,'alt_itema = '||item_rec.alt_itema);
328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);
329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);
330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);
331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);
332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);
333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);
334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);
335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);

Line 332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);

328: UTL_FILE.PUT_LINE(l_log_handle,'alt_itemb = '||item_rec.alt_itemb);
329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);
330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);
331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);
332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);
333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);
334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);
335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);
336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);

Line 333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);

329: UTL_FILE.PUT_LINE(l_log_handle,'item_um = '||item_rec.item_um);
330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);
331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);
332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);
333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);
334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);
335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);
336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);
337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);

Line 334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);

330: UTL_FILE.PUT_LINE(l_log_handle,'dualum_ind = '||item_rec.dualum_ind);
331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);
332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);
333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);
334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);
335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);
336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);
337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);
338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);

Line 335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);

331: UTL_FILE.PUT_LINE(l_log_handle,'item_um2 = '||item_rec.item_um2);
332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);
333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);
334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);
335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);
336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);
337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);
338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);
339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);

Line 336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);

332: UTL_FILE.PUT_LINE(l_log_handle,'deviation_lo = '||item_rec.deviation_lo);
333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);
334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);
335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);
336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);
337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);
338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);
339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);
340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);

Line 337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);

333: UTL_FILE.PUT_LINE(l_log_handle,'deviation_hi = '||item_rec.deviation_hi);
334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);
335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);
336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);
337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);
338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);
339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);
340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);
341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);

Line 338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);

334: UTL_FILE.PUT_LINE(l_log_handle,'level_code = '||item_rec.level_code);
335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);
336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);
337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);
338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);
339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);
340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);
341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);
342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);

Line 339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);

335: UTL_FILE.PUT_LINE(l_log_handle,'lot_ctl = '||item_rec.lot_ctl);
336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);
337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);
338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);
339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);
340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);
341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);
342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);
343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);

Line 340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);

336: UTL_FILE.PUT_LINE(l_log_handle,'lot_indivisible= '||item_rec.lot_indivisible);
337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);
338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);
339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);
340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);
341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);
342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);
343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);
344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);

Line 341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);

337: UTL_FILE.PUT_LINE(l_log_handle,'sublot_ctl = '||item_rec.sublot_ctl);
338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);
339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);
340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);
341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);
342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);
343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);
344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);
345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);

Line 342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);

338: UTL_FILE.PUT_LINE(l_log_handle,'loct_ctl = '||item_rec.loct_ctl);
339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);
340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);
341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);
342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);
343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);
344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);
345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);
346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);

Line 343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);

339: UTL_FILE.PUT_LINE(l_log_handle,'noninv_ind = '||item_rec.noninv_ind);
340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);
341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);
342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);
343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);
344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);
345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);
346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);
347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);

Line 344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);

340: UTL_FILE.PUT_LINE(l_log_handle,'match_type = '||item_rec.match_type);
341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);
342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);
343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);
344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);
345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);
346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);
347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);
348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);

Line 345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);

341: UTL_FILE.PUT_LINE(l_log_handle,'inactive_ind = '||item_rec.inactive_ind);
342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);
343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);
344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);
345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);
346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);
347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);
348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);
349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);

Line 346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);

342: UTL_FILE.PUT_LINE(l_log_handle,'inv_type = '||item_rec.inv_type);
343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);
344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);
345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);
346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);
347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);
348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);
349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);
350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);

Line 347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);

343: UTL_FILE.PUT_LINE(l_log_handle,'shelf_life = '||item_rec.shelf_life);
344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);
345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);
346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);
347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);
348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);
349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);
350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);
351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);

Line 348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);

344: UTL_FILE.PUT_LINE(l_log_handle,'retest_interval= '||item_rec.retest_interval);
345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);
346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);
347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);
348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);
349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);
350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);
351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);
352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);

Line 349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);

345: UTL_FILE.PUT_LINE(l_log_handle,'item_abccode = '||item_rec.item_abccode);
346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);
347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);
348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);
349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);
350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);
351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);
352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);
353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);

Line 350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);

346: UTL_FILE.PUT_LINE(l_log_handle,'gl_class = '||item_rec.gl_class);
347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);
348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);
349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);
350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);
351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);
352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);
353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);
354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);

Line 351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);

347: UTL_FILE.PUT_LINE(l_log_handle,'inv_class = '||item_rec.inv_class);
348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);
349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);
350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);
351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);
352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);
353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);
354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);
355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);

Line 352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);

348: UTL_FILE.PUT_LINE(l_log_handle,'sales_class = '||item_rec.sales_class);
349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);
350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);
351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);
352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);
353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);
354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);
355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);
356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);

Line 353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);

349: UTL_FILE.PUT_LINE(l_log_handle,'ship_class = '||item_rec.ship_class);
350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);
351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);
352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);
353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);
354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);
355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);
356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);
357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);

Line 354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);

350: UTL_FILE.PUT_LINE(l_log_handle,'frt_class = '||item_rec.frt_class);
351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);
352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);
353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);
354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);
355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);
356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);
357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);
358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);

Line 355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);

351: UTL_FILE.PUT_LINE(l_log_handle,'price_class = '||item_rec.price_class);
352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);
353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);
354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);
355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);
356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);
357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);
358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);
359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);

Line 356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);

352: UTL_FILE.PUT_LINE(l_log_handle,'storage_class = '||item_rec.storage_class);
353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);
354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);
355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);
356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);
357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);
358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);
359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);
360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);

Line 357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);

353: UTL_FILE.PUT_LINE(l_log_handle,'purch_class = '||item_rec.purch_class);
354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);
355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);
356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);
357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);
358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);
359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);
360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);
361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);

Line 358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);

354: UTL_FILE.PUT_LINE(l_log_handle,'tax_class = '||item_rec.tax_class);
355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);
356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);
357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);
358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);
359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);
360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);
361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);
362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);

Line 359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);

355: UTL_FILE.PUT_LINE(l_log_handle,'customs_class = '||item_rec.customs_class);
356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);
357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);
358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);
359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);
360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);
361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);
362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);
363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);

Line 360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);

356: UTL_FILE.PUT_LINE(l_log_handle,'alloc_class = '||item_rec.alloc_class);
357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);
358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);
359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);
360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);
361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);
362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);
363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);
364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);

Line 361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);

357: UTL_FILE.PUT_LINE(l_log_handle,'planning_class = '||item_rec.planning_class);
358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);
359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);
360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);
361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);
362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);
363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);
364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);
365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);

Line 362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);

358: UTL_FILE.PUT_LINE(l_log_handle,'itemcost_class = '||item_rec.itemcost_class);
359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);
360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);
361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);
362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);
363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);
364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);
365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);
366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);

Line 363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);

359: UTL_FILE.PUT_LINE(l_log_handle,'cost_mthd_code = '||item_rec.cost_mthd_code);
360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);
361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);
362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);
363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);
364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);
365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);
366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);
367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);

Line 364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);

360: UTL_FILE.PUT_LINE(l_log_handle,'upc_code = '||item_rec.upc_code);
361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);
362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);
363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);
364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);
365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);
366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);
367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);
368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);

Line 365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);

361: UTL_FILE.PUT_LINE(l_log_handle,'grade_ctl = '||item_rec.grade_ctl);
362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);
363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);
364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);
365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);
366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);
367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);
368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);
369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);

Line 366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);

362: UTL_FILE.PUT_LINE(l_log_handle,'status_ctl = '||item_rec.status_ctl);
363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);
364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);
365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);
366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);
367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);
368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);
369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);
370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);

Line 367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);

363: UTL_FILE.PUT_LINE(l_log_handle,'qc_grade = '||item_rec.qc_grade);
364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);
365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);
366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);
367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);
368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);
369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);
370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);
371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);

Line 368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);

364: UTL_FILE.PUT_LINE(l_log_handle,'lot_status = '||item_rec.lot_status);
365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);
366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);
367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);
368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);
369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);
370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);
371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);
372: UTL_FILE.PUT_LINE(

Line 369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);

365: UTL_FILE.PUT_LINE(l_log_handle,'bulk_id = '||item_rec.bulk_id);
366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);
367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);
368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);
369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);
370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);
371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);
372: UTL_FILE.PUT_LINE(
373: l_log_handle,'expaction_interval = '||item_rec.expaction_interval);

Line 370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);

366: UTL_FILE.PUT_LINE(l_log_handle,'pkg_id = '||item_rec.pkg_id);
367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);
368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);
369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);
370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);
371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);
372: UTL_FILE.PUT_LINE(
373: l_log_handle,'expaction_interval = '||item_rec.expaction_interval);
374: UTL_FILE.PUT_LINE(l_log_handle,'phantom_type = '||item_rec.phantom_type);

Line 371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);

367: UTL_FILE.PUT_LINE(l_log_handle,'qcitem_no = '||item_rec.qcitem_no);
368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);
369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);
370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);
371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);
372: UTL_FILE.PUT_LINE(
373: l_log_handle,'expaction_interval = '||item_rec.expaction_interval);
374: UTL_FILE.PUT_LINE(l_log_handle,'phantom_type = '||item_rec.phantom_type);
375: UTL_FILE.PUT_LINE(l_log_handle,'whse_item_no = '||item_rec.whse_item_no);

Line 372: UTL_FILE.PUT_LINE(

368: UTL_FILE.PUT_LINE(l_log_handle,'qchold_res_code= '||item_rec.qchold_res_code);
369: UTL_FILE.PUT_LINE(l_log_handle,'expaction_code = '||item_rec.expaction_code);
370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);
371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);
372: UTL_FILE.PUT_LINE(
373: l_log_handle,'expaction_interval = '||item_rec.expaction_interval);
374: UTL_FILE.PUT_LINE(l_log_handle,'phantom_type = '||item_rec.phantom_type);
375: UTL_FILE.PUT_LINE(l_log_handle,'whse_item_no = '||item_rec.whse_item_no);
376: UTL_FILE.PUT_LINE(

Line 374: UTL_FILE.PUT_LINE(l_log_handle,'phantom_type = '||item_rec.phantom_type);

370: UTL_FILE.PUT_LINE(l_log_handle,'fill_qty = '||item_rec.fill_qty);
371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);
372: UTL_FILE.PUT_LINE(
373: l_log_handle,'expaction_interval = '||item_rec.expaction_interval);
374: UTL_FILE.PUT_LINE(l_log_handle,'phantom_type = '||item_rec.phantom_type);
375: UTL_FILE.PUT_LINE(l_log_handle,'whse_item_no = '||item_rec.whse_item_no);
376: UTL_FILE.PUT_LINE(
377: l_log_handle,'experimental_ind = '||item_rec.experimental_ind);
378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);

Line 375: UTL_FILE.PUT_LINE(l_log_handle,'whse_item_no = '||item_rec.whse_item_no);

371: UTL_FILE.PUT_LINE(l_log_handle,'fill_um = '||item_rec.fill_um);
372: UTL_FILE.PUT_LINE(
373: l_log_handle,'expaction_interval = '||item_rec.expaction_interval);
374: UTL_FILE.PUT_LINE(l_log_handle,'phantom_type = '||item_rec.phantom_type);
375: UTL_FILE.PUT_LINE(l_log_handle,'whse_item_no = '||item_rec.whse_item_no);
376: UTL_FILE.PUT_LINE(
377: l_log_handle,'experimental_ind = '||item_rec.experimental_ind);
378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);
379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);

Line 376: UTL_FILE.PUT_LINE(

372: UTL_FILE.PUT_LINE(
373: l_log_handle,'expaction_interval = '||item_rec.expaction_interval);
374: UTL_FILE.PUT_LINE(l_log_handle,'phantom_type = '||item_rec.phantom_type);
375: UTL_FILE.PUT_LINE(l_log_handle,'whse_item_no = '||item_rec.whse_item_no);
376: UTL_FILE.PUT_LINE(
377: l_log_handle,'experimental_ind = '||item_rec.experimental_ind);
378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);
379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);
380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);

Line 378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);

374: UTL_FILE.PUT_LINE(l_log_handle,'phantom_type = '||item_rec.phantom_type);
375: UTL_FILE.PUT_LINE(l_log_handle,'whse_item_no = '||item_rec.whse_item_no);
376: UTL_FILE.PUT_LINE(
377: l_log_handle,'experimental_ind = '||item_rec.experimental_ind);
378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);
379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);
380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);
381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);
382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);

Line 379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);

375: UTL_FILE.PUT_LINE(l_log_handle,'whse_item_no = '||item_rec.whse_item_no);
376: UTL_FILE.PUT_LINE(
377: l_log_handle,'experimental_ind = '||item_rec.experimental_ind);
378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);
379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);
380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);
381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);
382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);
383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);

Line 380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);

376: UTL_FILE.PUT_LINE(
377: l_log_handle,'experimental_ind = '||item_rec.experimental_ind);
378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);
379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);
380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);
381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);
382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);
383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);
384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );

Line 381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);

377: l_log_handle,'experimental_ind = '||item_rec.experimental_ind);
378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);
379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);
380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);
381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);
382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);
383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);
384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );
385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );

Line 382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);

378: UTL_FILE.PUT_LINE(l_log_handle,'exported_date = '||item_rec.exported_date);
379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);
380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);
381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);
382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);
383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);
384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );
385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );
386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );

Line 383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);

379: UTL_FILE.PUT_LINE(l_log_handle,'seq_dpnd_class = '||item_rec.seq_dpnd_class);
380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);
381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);
382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);
383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);
384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );
385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );
386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );
387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );

Line 384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );

380: UTL_FILE.PUT_LINE(l_log_handle,'commodity_code = '||item_rec.commodity_code);
381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);
382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);
383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);
384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );
385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );
386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );
387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );
388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );

Line 385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );

381: UTL_FILE.PUT_LINE(l_log_handle,'ic_matr_days = '||item_rec.ic_matr_days);
382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);
383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);
384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );
385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );
386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );
387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );
388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );
389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );

Line 386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );

382: UTL_FILE.PUT_LINE(l_log_handle,'ic_hold_days = '||item_rec.ic_hold_days);
383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);
384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );
385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );
386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );
387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );
388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );
389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );
390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );

Line 387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );

383: UTL_FILE.PUT_LINE(l_log_handle,'user_name = '||item_rec.user_name);
384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );
385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );
386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );
387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );
388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );
389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );
390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );
391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );

Line 388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );

384: UTL_FILE.PUT_LINE(l_log_handle,'Attribute1 = '|| item_rec.attribute1 );
385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );
386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );
387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );
388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );
389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );
390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );
391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );
392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );

Line 389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );

385: UTL_FILE.PUT_LINE(l_log_handle,'Attribute2 = '|| item_rec.attribute2 );
386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );
387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );
388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );
389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );
390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );
391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );
392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );
393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );

Line 390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );

386: UTL_FILE.PUT_LINE(l_log_handle,'Attribute3 = '|| item_rec.attribute3 );
387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );
388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );
389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );
390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );
391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );
392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );
393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );
394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );

Line 391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );

387: UTL_FILE.PUT_LINE(l_log_handle,'Attribute4 = '|| item_rec.attribute4 );
388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );
389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );
390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );
391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );
392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );
393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );
394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );
395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );

Line 392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );

388: UTL_FILE.PUT_LINE(l_log_handle,'Attribute5 = '|| item_rec.attribute5 );
389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );
390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );
391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );
392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );
393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );
394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );
395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );
396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );

Line 393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );

389: UTL_FILE.PUT_LINE(l_log_handle,'Attribute6 = '|| item_rec.attribute6 );
390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );
391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );
392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );
393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );
394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );
395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );
396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );
397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );

Line 394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );

390: UTL_FILE.PUT_LINE(l_log_handle,'Attribute7 = '|| item_rec.attribute7 );
391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );
392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );
393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );
394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );
395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );
396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );
397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );
398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );

Line 395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );

391: UTL_FILE.PUT_LINE(l_log_handle,'Attribute8 = '|| item_rec.attribute8 );
392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );
393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );
394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );
395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );
396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );
397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );
398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );
399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );

Line 396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );

392: UTL_FILE.PUT_LINE(l_log_handle,'Attribute9 = '|| item_rec.attribute9 );
393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );
394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );
395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );
396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );
397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );
398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );
399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );
400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );

Line 397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );

393: UTL_FILE.PUT_LINE(l_log_handle,'Attribute10 = '|| item_rec.attribute10 );
394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );
395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );
396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );
397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );
398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );
399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );
400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );
401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );

Line 398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );

394: UTL_FILE.PUT_LINE(l_log_handle,'Attribute11 = '|| item_rec.attribute11 );
395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );
396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );
397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );
398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );
399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );
400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );
401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );
402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );

Line 399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );

395: UTL_FILE.PUT_LINE(l_log_handle,'Attribute12 = '|| item_rec.attribute12 );
396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );
397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );
398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );
399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );
400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );
401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );
402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );
403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );

Line 400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );

396: UTL_FILE.PUT_LINE(l_log_handle,'Attribute13 = '|| item_rec.attribute13 );
397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );
398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );
399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );
400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );
401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );
402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );
403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );
404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );

Line 401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );

397: UTL_FILE.PUT_LINE(l_log_handle,'Attribute14 = '|| item_rec.attribute14 );
398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );
399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );
400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );
401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );
402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );
403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );
404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );
405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );

Line 402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );

398: UTL_FILE.PUT_LINE(l_log_handle,'Attribute15 = '|| item_rec.attribute15 );
399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );
400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );
401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );
402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );
403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );
404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );
405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );
406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );

Line 403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );

399: UTL_FILE.PUT_LINE(l_log_handle,'Attribute16 = '|| item_rec.attribute16 );
400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );
401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );
402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );
403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );
404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );
405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );
406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );
407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );

Line 404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );

400: UTL_FILE.PUT_LINE(l_log_handle,'Attribute17 = '|| item_rec.attribute17 );
401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );
402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );
403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );
404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );
405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );
406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );
407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );
408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );

Line 405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );

401: UTL_FILE.PUT_LINE(l_log_handle,'Attribute18 = '|| item_rec.attribute18 );
402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );
403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );
404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );
405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );
406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );
407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );
408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );
409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );

Line 406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );

402: UTL_FILE.PUT_LINE(l_log_handle,'Attribute19 = '|| item_rec.attribute19 );
403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );
404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );
405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );
406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );
407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );
408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );
409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );
410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );

Line 407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );

403: UTL_FILE.PUT_LINE(l_log_handle,'Attribute20 = '|| item_rec.attribute20 );
404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );
405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );
406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );
407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );
408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );
409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );
410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );
411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );

Line 408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );

404: UTL_FILE.PUT_LINE(l_log_handle,'Attribute21 = '|| item_rec.attribute21 );
405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );
406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );
407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );
408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );
409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );
410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );
411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );
412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );

Line 409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );

405: UTL_FILE.PUT_LINE(l_log_handle,'Attribute22 = '|| item_rec.attribute22 );
406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );
407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );
408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );
409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );
410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );
411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );
412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );
413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );

Line 410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );

406: UTL_FILE.PUT_LINE(l_log_handle,'Attribute23 = '|| item_rec.attribute23 );
407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );
408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );
409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );
410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );
411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );
412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );
413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );
414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );

Line 411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );

407: UTL_FILE.PUT_LINE(l_log_handle,'Attribute24 = '|| item_rec.attribute24 );
408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );
409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );
410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );
411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );
412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );
413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );
414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );
415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );

Line 412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );

408: UTL_FILE.PUT_LINE(l_log_handle,'Attribute25 = '|| item_rec.attribute25 );
409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );
410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );
411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );
412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );
413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );
414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );
415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );
416: -- TKW 9/11/2003 B2378017

Line 413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );

409: UTL_FILE.PUT_LINE(l_log_handle,'Attribute26 = '|| item_rec.attribute26 );
410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );
411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );
412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );
413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );
414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );
415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );
416: -- TKW 9/11/2003 B2378017
417: UTL_FILE.PUT_LINE(l_log_handle,'GL Business Class = '|| item_rec.gl_business_class);

Line 414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );

410: UTL_FILE.PUT_LINE(l_log_handle,'Attribute27 = '|| item_rec.attribute27 );
411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );
412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );
413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );
414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );
415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );
416: -- TKW 9/11/2003 B2378017
417: UTL_FILE.PUT_LINE(l_log_handle,'GL Business Class = '|| item_rec.gl_business_class);
418: UTL_FILE.PUT_LINE(l_log_handle,'GL Product Line = '|| item_rec.gl_prod_line);

Line 415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );

411: UTL_FILE.PUT_LINE(l_log_handle,'Attribute28 = '|| item_rec.attribute28 );
412: UTL_FILE.PUT_LINE(l_log_handle,'Attribute29 = '|| item_rec.attribute29 );
413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );
414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );
415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );
416: -- TKW 9/11/2003 B2378017
417: UTL_FILE.PUT_LINE(l_log_handle,'GL Business Class = '|| item_rec.gl_business_class);
418: UTL_FILE.PUT_LINE(l_log_handle,'GL Product Line = '|| item_rec.gl_prod_line);
419: UTL_FILE.PUT_LINE(l_log_handle,'Substandard Item Class = '|| item_rec.sub_standard_class);

Line 417: UTL_FILE.PUT_LINE(l_log_handle,'GL Business Class = '|| item_rec.gl_business_class);

413: UTL_FILE.PUT_LINE(l_log_handle,'Attribute30 = '|| item_rec.attribute30 );
414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );
415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );
416: -- TKW 9/11/2003 B2378017
417: UTL_FILE.PUT_LINE(l_log_handle,'GL Business Class = '|| item_rec.gl_business_class);
418: UTL_FILE.PUT_LINE(l_log_handle,'GL Product Line = '|| item_rec.gl_prod_line);
419: UTL_FILE.PUT_LINE(l_log_handle,'Substandard Item Class = '|| item_rec.sub_standard_class);
420: UTL_FILE.PUT_LINE(l_log_handle,'Tech Class and Subclass = '|| item_rec.tech_class);
421:

Line 418: UTL_FILE.PUT_LINE(l_log_handle,'GL Product Line = '|| item_rec.gl_prod_line);

414: UTL_FILE.PUT_LINE(l_log_handle,'Attribute_Category = '|| item_rec.attribute_category );
415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );
416: -- TKW 9/11/2003 B2378017
417: UTL_FILE.PUT_LINE(l_log_handle,'GL Business Class = '|| item_rec.gl_business_class);
418: UTL_FILE.PUT_LINE(l_log_handle,'GL Product Line = '|| item_rec.gl_prod_line);
419: UTL_FILE.PUT_LINE(l_log_handle,'Substandard Item Class = '|| item_rec.sub_standard_class);
420: UTL_FILE.PUT_LINE(l_log_handle,'Tech Class and Subclass = '|| item_rec.tech_class);
421:
422: GMIPAPI.Create_Item

Line 419: UTL_FILE.PUT_LINE(l_log_handle,'Substandard Item Class = '|| item_rec.sub_standard_class);

415: UTL_FILE.PUT_LINE(l_log_handle,'ont_pricing_qty_source = '|| item_rec.ont_pricing_qty_source );
416: -- TKW 9/11/2003 B2378017
417: UTL_FILE.PUT_LINE(l_log_handle,'GL Business Class = '|| item_rec.gl_business_class);
418: UTL_FILE.PUT_LINE(l_log_handle,'GL Product Line = '|| item_rec.gl_prod_line);
419: UTL_FILE.PUT_LINE(l_log_handle,'Substandard Item Class = '|| item_rec.sub_standard_class);
420: UTL_FILE.PUT_LINE(l_log_handle,'Tech Class and Subclass = '|| item_rec.tech_class);
421:
422: GMIPAPI.Create_Item
423: ( p_api_version => 3.0

Line 420: UTL_FILE.PUT_LINE(l_log_handle,'Tech Class and Subclass = '|| item_rec.tech_class);

416: -- TKW 9/11/2003 B2378017
417: UTL_FILE.PUT_LINE(l_log_handle,'GL Business Class = '|| item_rec.gl_business_class);
418: UTL_FILE.PUT_LINE(l_log_handle,'GL Product Line = '|| item_rec.gl_prod_line);
419: UTL_FILE.PUT_LINE(l_log_handle,'Substandard Item Class = '|| item_rec.sub_standard_class);
420: UTL_FILE.PUT_LINE(l_log_handle,'Tech Class and Subclass = '|| item_rec.tech_class);
421:
422: GMIPAPI.Create_Item
423: ( p_api_version => 3.0
424: , p_init_msg_list => FND_API.G_TRUE

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

447: p_msg_index_out => l_dummy_cnt);
448:
449: /* dbms_output.put_line('Message ' || l_data ); */
450:
451: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
452: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
453: UTL_FILE.NEW_LINE(l_outfile_handle);
454:
455: IF l_status = 'E' OR

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

448:
449: /* dbms_output.put_line('Message ' || l_data ); */
450:
451: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
452: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
453: UTL_FILE.NEW_LINE(l_outfile_handle);
454:
455: IF l_status = 'E' OR
456: l_status = 'U'

Line 453: UTL_FILE.NEW_LINE(l_outfile_handle);

449: /* dbms_output.put_line('Message ' || l_data ); */
450:
451: UTL_FILE.PUT_LINE(l_outfile_handle, 'Record = ' ||l_record_count );
452: UTL_FILE.PUT_LINE(l_outfile_handle, l_data);
453: UTL_FILE.NEW_LINE(l_outfile_handle);
454:
455: IF l_status = 'E' OR
456: l_status = 'U'
457: THEN

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

457: THEN
458: l_data := CONCAT('ERROR ',l_data);
459: END IF;
460:
461: UTL_FILE.PUT_LINE(l_log_handle, l_data);
462:
463: /* Update error status */
464: IF (l_status = 'U')
465: THEN

Line 485: UTL_FILE.NEW_LINE(l_log_handle);

481:
482: END IF;
483:
484: END LOOP;
485: UTL_FILE.NEW_LINE(l_log_handle);
486: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at '
487: || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
488: /* Check if any messages generated. If so then decode and */
489: /* output to error message flat file */

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

482: END IF;
483:
484: END LOOP;
485: UTL_FILE.NEW_LINE(l_log_handle);
486: UTL_FILE.PUT_LINE(l_log_handle, 'Process Completed at '
487: || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
488: /* Check if any messages generated. If so then decode and */
489: /* output to error message flat file */
490:

Line 491: UTL_FILE.FCLOSE_ALL;

487: || to_char(SYSDATE,'DD-MON-YY HH24:MI:SS'));
488: /* Check if any messages generated. If so then decode and */
489: /* output to error message flat file */
490:
491: UTL_FILE.FCLOSE_ALL;
492:
493: RETURN l_return_status;
494:
495: EXCEPTION

Line 496: WHEN UTL_FILE.INVALID_OPERATION THEN

492:
493: RETURN l_return_status;
494:
495: EXCEPTION
496: WHEN UTL_FILE.INVALID_OPERATION THEN
497: /* dbms_output.put_line('Invalid Operation For '|| l_global_file); */
498: UTL_FILE.FCLOSE_ALL;
499: RETURN l_return_status;
500:

Line 498: UTL_FILE.FCLOSE_ALL;

494:
495: EXCEPTION
496: WHEN UTL_FILE.INVALID_OPERATION THEN
497: /* dbms_output.put_line('Invalid Operation For '|| l_global_file); */
498: UTL_FILE.FCLOSE_ALL;
499: RETURN l_return_status;
500:
501: WHEN UTL_FILE.INVALID_PATH THEN
502: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */

Line 501: WHEN UTL_FILE.INVALID_PATH THEN

497: /* dbms_output.put_line('Invalid Operation For '|| l_global_file); */
498: UTL_FILE.FCLOSE_ALL;
499: RETURN l_return_status;
500:
501: WHEN UTL_FILE.INVALID_PATH THEN
502: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
503: UTL_FILE.FCLOSE_ALL;
504: RETURN l_return_status;
505:

Line 503: UTL_FILE.FCLOSE_ALL;

499: RETURN l_return_status;
500:
501: WHEN UTL_FILE.INVALID_PATH THEN
502: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
503: UTL_FILE.FCLOSE_ALL;
504: RETURN l_return_status;
505:
506: WHEN UTL_FILE.INVALID_MODE THEN
507: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */

Line 506: WHEN UTL_FILE.INVALID_MODE THEN

502: /* dbms_output.put_line('Invalid Path For '|| l_global_file); */
503: UTL_FILE.FCLOSE_ALL;
504: RETURN l_return_status;
505:
506: WHEN UTL_FILE.INVALID_MODE THEN
507: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
508: UTL_FILE.FCLOSE_ALL;
509: RETURN l_return_status;
510:

Line 508: UTL_FILE.FCLOSE_ALL;

504: RETURN l_return_status;
505:
506: WHEN UTL_FILE.INVALID_MODE THEN
507: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
508: UTL_FILE.FCLOSE_ALL;
509: RETURN l_return_status;
510:
511: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
512: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */

Line 511: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

507: /* dbms_output.put_line('Invalid Mode For '|| l_global_file); */
508: UTL_FILE.FCLOSE_ALL;
509: RETURN l_return_status;
510:
511: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
512: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
513: UTL_FILE.FCLOSE_ALL;
514: RETURN l_return_status;
515:

Line 513: UTL_FILE.FCLOSE_ALL;

509: RETURN l_return_status;
510:
511: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
512: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
513: UTL_FILE.FCLOSE_ALL;
514: RETURN l_return_status;
515:
516: WHEN UTL_FILE.WRITE_ERROR THEN
517: /* dbms_output.put_line('Invalid Write Error '|| l_global_file); */

Line 516: WHEN UTL_FILE.WRITE_ERROR THEN

512: /* dbms_output.put_line('Invalid File Handle '|| l_global_file); */
513: UTL_FILE.FCLOSE_ALL;
514: RETURN l_return_status;
515:
516: WHEN UTL_FILE.WRITE_ERROR THEN
517: /* dbms_output.put_line('Invalid Write Error '|| l_global_file); */
518: UTL_FILE.FCLOSE_ALL;
519: RETURN l_return_status;
520:

Line 518: UTL_FILE.FCLOSE_ALL;

514: RETURN l_return_status;
515:
516: WHEN UTL_FILE.WRITE_ERROR THEN
517: /* dbms_output.put_line('Invalid Write Error '|| l_global_file); */
518: UTL_FILE.FCLOSE_ALL;
519: RETURN l_return_status;
520:
521: WHEN UTL_FILE.READ_ERROR THEN
522: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */

Line 521: WHEN UTL_FILE.READ_ERROR THEN

517: /* dbms_output.put_line('Invalid Write Error '|| l_global_file); */
518: UTL_FILE.FCLOSE_ALL;
519: RETURN l_return_status;
520:
521: WHEN UTL_FILE.READ_ERROR THEN
522: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
523: UTL_FILE.FCLOSE_ALL;
524: RETURN l_return_status;
525:

Line 523: UTL_FILE.FCLOSE_ALL;

519: RETURN l_return_status;
520:
521: WHEN UTL_FILE.READ_ERROR THEN
522: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
523: UTL_FILE.FCLOSE_ALL;
524: RETURN l_return_status;
525:
526: WHEN UTL_FILE.INTERNAL_ERROR THEN
527: /* dbms_output.put_line('Internal Error'); */

Line 526: WHEN UTL_FILE.INTERNAL_ERROR THEN

522: /* dbms_output.put_line('Invalid Read Error '|| l_global_file); */
523: UTL_FILE.FCLOSE_ALL;
524: RETURN l_return_status;
525:
526: WHEN UTL_FILE.INTERNAL_ERROR THEN
527: /* dbms_output.put_line('Internal Error'); */
528: UTL_FILE.FCLOSE_ALL;
529: RETURN l_return_status;
530:

Line 528: UTL_FILE.FCLOSE_ALL;

524: RETURN l_return_status;
525:
526: WHEN UTL_FILE.INTERNAL_ERROR THEN
527: /* dbms_output.put_line('Internal Error'); */
528: UTL_FILE.FCLOSE_ALL;
529: RETURN l_return_status;
530:
531: WHEN OTHERS THEN
532: /* dbms_output.put_line('Other Error'); */

Line 533: UTL_FILE.FCLOSE_ALL;

529: RETURN l_return_status;
530:
531: WHEN OTHERS THEN
532: /* dbms_output.put_line('Other Error'); */
533: UTL_FILE.FCLOSE_ALL;
534: RETURN l_return_status;
535:
536: END Create_Item;
537: