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.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on FND_FILE

Line 206: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));

202: -- RMUNJULU 115.4 3061748
203: IF G_ERROR <> 'Y' THEN
204:
205: --log
206: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
207: FND_FILE.put_line(FND_FILE.log, l_type ||
208: RPAD(' ',40-LENGTH(l_type),' ') ||
209: l_processed);
210:

Line 207: FND_FILE.put_line(FND_FILE.log, l_type ||

203: IF G_ERROR <> 'Y' THEN
204:
205: --log
206: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
207: FND_FILE.put_line(FND_FILE.log, l_type ||
208: RPAD(' ',40-LENGTH(l_type),' ') ||
209: l_processed);
210:
211: FND_FILE.put_line(FND_FILE.log, RPAD('-',77 ,'-'));

Line 211: FND_FILE.put_line(FND_FILE.log, RPAD('-',77 ,'-'));

207: FND_FILE.put_line(FND_FILE.log, l_type ||
208: RPAD(' ',40-LENGTH(l_type),' ') ||
209: l_processed);
210:
211: FND_FILE.put_line(FND_FILE.log, RPAD('-',77 ,'-'));
212:
213: FND_FILE.put_line(FND_FILE.log, l_term_k ||
214: RPAD(' ',40-LENGTH(l_term_k),' ') ||
215: l_success);

Line 213: FND_FILE.put_line(FND_FILE.log, l_term_k ||

209: l_processed);
210:
211: FND_FILE.put_line(FND_FILE.log, RPAD('-',77 ,'-'));
212:
213: FND_FILE.put_line(FND_FILE.log, l_term_k ||
214: RPAD(' ',40-LENGTH(l_term_k),' ') ||
215: l_success);
216:
217: FND_FILE.put_line(FND_FILE.log, l_error_k ||

Line 217: FND_FILE.put_line(FND_FILE.log, l_error_k ||

213: FND_FILE.put_line(FND_FILE.log, l_term_k ||
214: RPAD(' ',40-LENGTH(l_term_k),' ') ||
215: l_success);
216:
217: FND_FILE.put_line(FND_FILE.log, l_error_k ||
218: RPAD(' ',40-LENGTH(l_error_k),' ') ||
219: l_error);
220: FND_FILE.put_line(FND_FILE.log,'');
221: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));

Line 220: FND_FILE.put_line(FND_FILE.log,'');

216:
217: FND_FILE.put_line(FND_FILE.log, l_error_k ||
218: RPAD(' ',40-LENGTH(l_error_k),' ') ||
219: l_error);
220: FND_FILE.put_line(FND_FILE.log,'');
221: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
222:
223: -- output
224: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||

Line 221: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));

217: FND_FILE.put_line(FND_FILE.log, l_error_k ||
218: RPAD(' ',40-LENGTH(l_error_k),' ') ||
219: l_error);
220: FND_FILE.put_line(FND_FILE.log,'');
221: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
222:
223: -- output
224: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||
225: l_orcl_logo);

Line 224: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||

220: FND_FILE.put_line(FND_FILE.log,'');
221: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
222:
223: -- output
224: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||
225: l_orcl_logo);
226:
227: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_term_heading)/2, ' ' ) ||
228: l_term_heading);

Line 227: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_term_heading)/2, ' ' ) ||

223: -- output
224: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||
225: l_orcl_logo);
226:
227: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_term_heading)/2, ' ' ) ||
228: l_term_heading);
229:
230: FND_FILE.put_line(FND_FILE.output, RPAD(' ',128/2-LENGTH(l_term_heading)/2 , ' ' ) ||
231: RPAD('-',LENGTH(l_term_heading),'-'));

Line 230: FND_FILE.put_line(FND_FILE.output, RPAD(' ',128/2-LENGTH(l_term_heading)/2 , ' ' ) ||

226:
227: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_term_heading)/2, ' ' ) ||
228: l_term_heading);
229:
230: FND_FILE.put_line(FND_FILE.output, RPAD(' ',128/2-LENGTH(l_term_heading)/2 , ' ' ) ||
231: RPAD('-',LENGTH(l_term_heading),'-'));
232:
233: FND_FILE.put_line(FND_FILE.output, '');
234:

Line 233: FND_FILE.put_line(FND_FILE.output, '');

229:
230: FND_FILE.put_line(FND_FILE.output, RPAD(' ',128/2-LENGTH(l_term_heading)/2 , ' ' ) ||
231: RPAD('-',LENGTH(l_term_heading),'-'));
232:
233: FND_FILE.put_line(FND_FILE.output, '');
234:
235: FND_FILE.put_line(FND_FILE.output, l_set_of_books ||' : '||
236: l_set_of_books_name ||
237: RPAD(' ', 128-LENGTH(l_set_of_books)-LENGTH(l_set_of_books_name)-LENGTH(l_run_date)-25, ' ' ) ||

Line 235: FND_FILE.put_line(FND_FILE.output, l_set_of_books ||' : '||

231: RPAD('-',LENGTH(l_term_heading),'-'));
232:
233: FND_FILE.put_line(FND_FILE.output, '');
234:
235: FND_FILE.put_line(FND_FILE.output, l_set_of_books ||' : '||
236: l_set_of_books_name ||
237: RPAD(' ', 128-LENGTH(l_set_of_books)-LENGTH(l_set_of_books_name)-LENGTH(l_run_date)-25, ' ' ) ||
238: l_run_date ||' : ' ||
239: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'));

Line 241: FND_FILE.put_line(FND_FILE.output, l_oper_unit || ' : ' ||

237: RPAD(' ', 128-LENGTH(l_set_of_books)-LENGTH(l_set_of_books_name)-LENGTH(l_run_date)-25, ' ' ) ||
238: l_run_date ||' : ' ||
239: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'));
240:
241: FND_FILE.put_line(FND_FILE.output, l_oper_unit || ' : ' ||
242: l_org_name ||
243: RPAD(' ', 128-LENGTH(l_oper_unit)-LENGTH(l_org_name)-LENGTH(l_inv_ended_by)-25, ' ' ) ||
244: l_inv_ended_by ||' : ' ||
245: TO_CHAR(G_INV_ENDED_BY_DATE, 'DD-MON-YYYY HH24:MI'));

Line 247: FND_FILE.put_line(FND_FILE.output,'');

243: RPAD(' ', 128-LENGTH(l_oper_unit)-LENGTH(l_org_name)-LENGTH(l_inv_ended_by)-25, ' ' ) ||
244: l_inv_ended_by ||' : ' ||
245: TO_CHAR(G_INV_ENDED_BY_DATE, 'DD-MON-YYYY HH24:MI'));
246:
247: FND_FILE.put_line(FND_FILE.output,'');
248: FND_FILE.put_line(FND_FILE.output,'');
249:
250: FND_FILE.put_line(FND_FILE.output, l_type ||
251: RPAD(' ',40-LENGTH(l_type),' ') ||

Line 248: FND_FILE.put_line(FND_FILE.output,'');

244: l_inv_ended_by ||' : ' ||
245: TO_CHAR(G_INV_ENDED_BY_DATE, 'DD-MON-YYYY HH24:MI'));
246:
247: FND_FILE.put_line(FND_FILE.output,'');
248: FND_FILE.put_line(FND_FILE.output,'');
249:
250: FND_FILE.put_line(FND_FILE.output, l_type ||
251: RPAD(' ',40-LENGTH(l_type),' ') ||
252: l_processed);

Line 250: FND_FILE.put_line(FND_FILE.output, l_type ||

246:
247: FND_FILE.put_line(FND_FILE.output,'');
248: FND_FILE.put_line(FND_FILE.output,'');
249:
250: FND_FILE.put_line(FND_FILE.output, l_type ||
251: RPAD(' ',40-LENGTH(l_type),' ') ||
252: l_processed);
253:
254: FND_FILE.put_line(FND_FILE.output, RPAD('-',128 ,'-'));

Line 254: FND_FILE.put_line(FND_FILE.output, RPAD('-',128 ,'-'));

250: FND_FILE.put_line(FND_FILE.output, l_type ||
251: RPAD(' ',40-LENGTH(l_type),' ') ||
252: l_processed);
253:
254: FND_FILE.put_line(FND_FILE.output, RPAD('-',128 ,'-'));
255:
256: FND_FILE.put_line(FND_FILE.output, l_term_k ||
257: RPAD(' ',40-LENGTH(l_term_k),' ') ||
258: l_success);

Line 256: FND_FILE.put_line(FND_FILE.output, l_term_k ||

252: l_processed);
253:
254: FND_FILE.put_line(FND_FILE.output, RPAD('-',128 ,'-'));
255:
256: FND_FILE.put_line(FND_FILE.output, l_term_k ||
257: RPAD(' ',40-LENGTH(l_term_k),' ') ||
258: l_success);
259:
260: FND_FILE.put_line(FND_FILE.output, l_error_k ||

Line 260: FND_FILE.put_line(FND_FILE.output, l_error_k ||

256: FND_FILE.put_line(FND_FILE.output, l_term_k ||
257: RPAD(' ',40-LENGTH(l_term_k),' ') ||
258: l_success);
259:
260: FND_FILE.put_line(FND_FILE.output, l_error_k ||
261: RPAD(' ',40-LENGTH(l_error_k),' ') ||
262: l_error);
263:
264: FND_FILE.put_line(FND_FILE.output,'');

Line 264: FND_FILE.put_line(FND_FILE.output,'');

260: FND_FILE.put_line(FND_FILE.output, l_error_k ||
261: RPAD(' ',40-LENGTH(l_error_k),' ') ||
262: l_error);
263:
264: FND_FILE.put_line(FND_FILE.output,'');
265: FND_FILE.put_line(FND_FILE.output, RPAD('=',128,'=' ));
266: FND_FILE.put_line(FND_FILE.output,'');
267:
268: -- Print Investor Agreements Terminated Successfully

Line 265: FND_FILE.put_line(FND_FILE.output, RPAD('=',128,'=' ));

261: RPAD(' ',40-LENGTH(l_error_k),' ') ||
262: l_error);
263:
264: FND_FILE.put_line(FND_FILE.output,'');
265: FND_FILE.put_line(FND_FILE.output, RPAD('=',128,'=' ));
266: FND_FILE.put_line(FND_FILE.output,'');
267:
268: -- Print Investor Agreements Terminated Successfully
269: IF l_success > 0 THEN

Line 266: FND_FILE.put_line(FND_FILE.output,'');

262: l_error);
263:
264: FND_FILE.put_line(FND_FILE.output,'');
265: FND_FILE.put_line(FND_FILE.output, RPAD('=',128,'=' ));
266: FND_FILE.put_line(FND_FILE.output,'');
267:
268: -- Print Investor Agreements Terminated Successfully
269: IF l_success > 0 THEN
270:

Line 271: FND_FILE.put_line(FND_FILE.output, l_term_k);

267:
268: -- Print Investor Agreements Terminated Successfully
269: IF l_success > 0 THEN
270:
271: FND_FILE.put_line(FND_FILE.output, l_term_k);
272: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_term_k), '-' ));
273: FND_FILE.put_line(FND_FILE.output,'');
274:
275: l_print := 'N';

Line 272: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_term_k), '-' ));

268: -- Print Investor Agreements Terminated Successfully
269: IF l_success > 0 THEN
270:
271: FND_FILE.put_line(FND_FILE.output, l_term_k);
272: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_term_k), '-' ));
273: FND_FILE.put_line(FND_FILE.output,'');
274:
275: l_print := 'N';
276:

Line 273: FND_FILE.put_line(FND_FILE.output,'');

269: IF l_success > 0 THEN
270:
271: FND_FILE.put_line(FND_FILE.output, l_term_k);
272: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_term_k), '-' ));
273: FND_FILE.put_line(FND_FILE.output,'');
274:
275: l_print := 'N';
276:
277: FOR i IN success_message_table.FIRST..success_message_table.LAST LOOP

Line 281: FND_FILE.put_line(FND_FILE.output, l_serial || RPAD(' ',15-LENGTH(l_serial),' ')||

277: FOR i IN success_message_table.FIRST..success_message_table.LAST LOOP
278:
279: IF l_print = 'N' THEN
280:
281: FND_FILE.put_line(FND_FILE.output, l_serial || RPAD(' ',15-LENGTH(l_serial),' ')||
282: l_k_num || RPAD(' ',35-LENGTH(l_k_num),' ')||
283: l_start_date||RPAD(' ',15-LENGTH(l_start_date),' ') ||
284: l_end_date||RPAD(' ',15-LENGTH(l_end_date),' ') ||
285: l_status||RPAD(' ',15-LENGTH(l_status),' '));

Line 287: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_serial),'-') || RPAD('-',15-LENGTH(l_serial),'-')||

283: l_start_date||RPAD(' ',15-LENGTH(l_start_date),' ') ||
284: l_end_date||RPAD(' ',15-LENGTH(l_end_date),' ') ||
285: l_status||RPAD(' ',15-LENGTH(l_status),' '));
286:
287: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_serial),'-') || RPAD('-',15-LENGTH(l_serial),'-')||
288: RPAD('-',LENGTH(l_k_num),'-') || RPAD('-',35-LENGTH(l_k_num),'-')||
289: RPAD('-',LENGTH(l_start_date),'-')||RPAD('-',15-LENGTH(l_start_date),'-') ||
290: RPAD('-',LENGTH(l_end_date),'-')||RPAD('-',15-LENGTH(l_end_date),'-') ||
291: RPAD('-',LENGTH(l_status),'-')||RPAD('-',15-LENGTH(l_status),'-'));

Line 296: FND_FILE.put_line(FND_FILE.output, i || RPAD(' ',15-LENGTH(i),' ')||

292:
293: l_print := 'Y';
294: END IF;
295:
296: FND_FILE.put_line(FND_FILE.output, i || RPAD(' ',15-LENGTH(i),' ')||
297: success_message_table(i).contract_number ||
298: RPAD(' ',35-LENGTH(success_message_table(i).contract_number),' ')||
299: success_message_table(i).start_date||
300: RPAD(' ',15-LENGTH(success_message_table(i).start_date),' ') ||

Line 306: --FND_FILE.put_line(FND_FILE.output,'');

302: RPAD(' ',15-LENGTH(success_message_table(i).end_date),' ') ||
303: success_message_table(i).status||
304: RPAD(' ',15-LENGTH(success_message_table(i).status),' '));
305:
306: --FND_FILE.put_line(FND_FILE.output,'');
307:
308: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
309:
310: --FOR j IN success_message_table(i).msg_tbl.FIRST..success_message_table(i).msg_tbl.LAST LOOP

Line 308: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');

304: RPAD(' ',15-LENGTH(success_message_table(i).status),' '));
305:
306: --FND_FILE.put_line(FND_FILE.output,'');
307:
308: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
309:
310: --FOR j IN success_message_table(i).msg_tbl.FIRST..success_message_table(i).msg_tbl.LAST LOOP
311: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);
312: --FND_FILE.put_line(FND_FILE.output,'');

Line 311: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);

307:
308: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
309:
310: --FOR j IN success_message_table(i).msg_tbl.FIRST..success_message_table(i).msg_tbl.LAST LOOP
311: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);
312: --FND_FILE.put_line(FND_FILE.output,'');
313: --END LOOP;
314:
315: --FND_FILE.put_line(FND_FILE.output,'');

Line 312: --FND_FILE.put_line(FND_FILE.output,'');

308: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
309:
310: --FOR j IN success_message_table(i).msg_tbl.FIRST..success_message_table(i).msg_tbl.LAST LOOP
311: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);
312: --FND_FILE.put_line(FND_FILE.output,'');
313: --END LOOP;
314:
315: --FND_FILE.put_line(FND_FILE.output,'');
316:

Line 315: --FND_FILE.put_line(FND_FILE.output,'');

311: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);
312: --FND_FILE.put_line(FND_FILE.output,'');
313: --END LOOP;
314:
315: --FND_FILE.put_line(FND_FILE.output,'');
316:
317: END LOOP;
318: END IF;
319:

Line 320: FND_FILE.put_line(FND_FILE.output,'');

316:
317: END LOOP;
318: END IF;
319:
320: FND_FILE.put_line(FND_FILE.output,'');
321:
322: -- Print Investor Agreements errored
323: IF l_error > 0 THEN
324:

Line 325: FND_FILE.put_line(FND_FILE.output, l_error_k);

321:
322: -- Print Investor Agreements errored
323: IF l_error > 0 THEN
324:
325: FND_FILE.put_line(FND_FILE.output, l_error_k);
326: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_error_k), '-' ));
327: FND_FILE.put_line(FND_FILE.output,'');
328:
329: -- SECHAWLA 26-JAN-04 3377730: Initialize the table index

Line 326: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_error_k), '-' ));

322: -- Print Investor Agreements errored
323: IF l_error > 0 THEN
324:
325: FND_FILE.put_line(FND_FILE.output, l_error_k);
326: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_error_k), '-' ));
327: FND_FILE.put_line(FND_FILE.output,'');
328:
329: -- SECHAWLA 26-JAN-04 3377730: Initialize the table index
330: msg_lines_table_index := 1;

Line 327: FND_FILE.put_line(FND_FILE.output,'');

323: IF l_error > 0 THEN
324:
325: FND_FILE.put_line(FND_FILE.output, l_error_k);
326: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_error_k), '-' ));
327: FND_FILE.put_line(FND_FILE.output,'');
328:
329: -- SECHAWLA 26-JAN-04 3377730: Initialize the table index
330: msg_lines_table_index := 1;
331:

Line 334: FND_FILE.put_line(FND_FILE.output, l_serial || RPAD(' ',15-LENGTH(l_serial),' ')||

330: msg_lines_table_index := 1;
331:
332: FOR i IN error_message_table.FIRST..error_message_table.LAST LOOP
333:
334: FND_FILE.put_line(FND_FILE.output, l_serial || RPAD(' ',15-LENGTH(l_serial),' ')||
335: l_k_num || RPAD(' ',35-LENGTH(l_k_num),' ')||
336: l_start_date||RPAD(' ',15-LENGTH(l_start_date),' ') ||
337: l_end_date||RPAD(' ',15-LENGTH(l_end_date),' ') ||
338: l_status||RPAD(' ',15-LENGTH(l_status),' '));

Line 340: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_serial),'-') || RPAD('-',15-LENGTH(l_serial),'-')||

336: l_start_date||RPAD(' ',15-LENGTH(l_start_date),' ') ||
337: l_end_date||RPAD(' ',15-LENGTH(l_end_date),' ') ||
338: l_status||RPAD(' ',15-LENGTH(l_status),' '));
339:
340: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_serial),'-') || RPAD('-',15-LENGTH(l_serial),'-')||
341: RPAD('-',LENGTH(l_k_num),'-') || RPAD('-',35-LENGTH(l_k_num),'-')||
342: RPAD('-',LENGTH(l_start_date),'-')||RPAD('-',15-LENGTH(l_start_date),'-') ||
343: RPAD('-',LENGTH(l_end_date),'-')||RPAD('-',15-LENGTH(l_end_date),'-') ||
344: RPAD('-',LENGTH(l_status),'-')||RPAD('-',15-LENGTH(l_status),'-'));

Line 346: FND_FILE.put_line(FND_FILE.output, i || RPAD(' ',15-LENGTH(i),' ')||

342: RPAD('-',LENGTH(l_start_date),'-')||RPAD('-',15-LENGTH(l_start_date),'-') ||
343: RPAD('-',LENGTH(l_end_date),'-')||RPAD('-',15-LENGTH(l_end_date),'-') ||
344: RPAD('-',LENGTH(l_status),'-')||RPAD('-',15-LENGTH(l_status),'-'));
345:
346: FND_FILE.put_line(FND_FILE.output, i || RPAD(' ',15-LENGTH(i),' ')||
347: error_message_table(i).contract_number ||
348: RPAD(' ',35-LENGTH(error_message_table(i).contract_number),' ')||
349: error_message_table(i).start_date||
350: RPAD(' ',15-LENGTH(error_message_table(i).start_date),' ') ||

Line 356: FND_FILE.put_line(FND_FILE.output,'');

352: RPAD(' ',15-LENGTH(error_message_table(i).end_date),' ') ||
353: error_message_table(i).status||
354: RPAD(' ',15-LENGTH(error_message_table(i).status),' '));
355:
356: FND_FILE.put_line(FND_FILE.output,'');
357:
358: FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
359:
360: -- SECHAWLA 26-JAN-04 3377730: A table can not have a table or record with composite fields on lower versions

Line 358: FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');

354: RPAD(' ',15-LENGTH(error_message_table(i).status),' '));
355:
356: FND_FILE.put_line(FND_FILE.output,'');
357:
358: FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
359:
360: -- SECHAWLA 26-JAN-04 3377730: A table can not have a table or record with composite fields on lower versions
361: -- of db/Pl Sql Removed the msg_tbl field from message_rec_type
362: /*

Line 364: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || error_message_table(i).msg_tbl(j).msg);

360: -- SECHAWLA 26-JAN-04 3377730: A table can not have a table or record with composite fields on lower versions
361: -- of db/Pl Sql Removed the msg_tbl field from message_rec_type
362: /*
363: FOR j IN error_message_table(i).msg_tbl.FIRST..error_message_table(i).msg_tbl.LAST LOOP
364: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || error_message_table(i).msg_tbl(j).msg);
365: FND_FILE.put_line(FND_FILE.output,'');
366: END LOOP;
367: */
368:

Line 365: FND_FILE.put_line(FND_FILE.output,'');

361: -- of db/Pl Sql Removed the msg_tbl field from message_rec_type
362: /*
363: FOR j IN error_message_table(i).msg_tbl.FIRST..error_message_table(i).msg_tbl.LAST LOOP
364: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || error_message_table(i).msg_tbl(j).msg);
365: FND_FILE.put_line(FND_FILE.output,'');
366: END LOOP;
367: */
368:
369: -- SECHAWLA 26-JAN-04 3377730: A table can not have a table or record with composite fields on lower versions

Line 374: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || msg_lines_table(j).msg);

370: -- of db/Pl Sql Removed the msg_tbl field from message_rec_type
371:
372: FOR j IN msg_lines_table_index .. msg_lines_table.LAST LOOP
373: IF msg_lines_table(j).id = error_message_table(i).id THEN
374: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || msg_lines_table(j).msg);
375: FND_FILE.put_line(FND_FILE.output,'');
376: ELSE
377: msg_lines_table_index := j ;
378: EXIT;

Line 375: FND_FILE.put_line(FND_FILE.output,'');

371:
372: FOR j IN msg_lines_table_index .. msg_lines_table.LAST LOOP
373: IF msg_lines_table(j).id = error_message_table(i).id THEN
374: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || msg_lines_table(j).msg);
375: FND_FILE.put_line(FND_FILE.output,'');
376: ELSE
377: msg_lines_table_index := j ;
378: EXIT;
379: END IF;

Line 383: FND_FILE.put_line(FND_FILE.output,'');

379: END IF;
380:
381: END LOOP;
382:
383: FND_FILE.put_line(FND_FILE.output,'');
384:
385: END LOOP;
386:
387: END IF;

Line 389: FND_FILE.put_line(FND_FILE.output,'');

385: END LOOP;
386:
387: END IF;
388:
389: FND_FILE.put_line(FND_FILE.output,'');
390: FND_FILE.put_line(FND_FILE.output,'');
391: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);
392:
393: ELSE -- RMUNJULU 115.4 3061748

Line 390: FND_FILE.put_line(FND_FILE.output,'');

386:
387: END IF;
388:
389: FND_FILE.put_line(FND_FILE.output,'');
390: FND_FILE.put_line(FND_FILE.output,'');
391: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);
392:
393: ELSE -- RMUNJULU 115.4 3061748
394:

Line 391: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);

387: END IF;
388:
389: FND_FILE.put_line(FND_FILE.output,'');
390: FND_FILE.put_line(FND_FILE.output,'');
391: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);
392:
393: ELSE -- RMUNJULU 115.4 3061748
394:
395: FND_FILE.put_line(FND_FILE.log,l_processed || ' = 0');

Line 395: FND_FILE.put_line(FND_FILE.log,l_processed || ' = 0');

391: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);
392:
393: ELSE -- RMUNJULU 115.4 3061748
394:
395: FND_FILE.put_line(FND_FILE.log,l_processed || ' = 0');
396: FND_FILE.put_line(FND_FILE.log,l_inv);
397:
398: END IF;
399: EXCEPTION

Line 396: FND_FILE.put_line(FND_FILE.log,l_inv);

392:
393: ELSE -- RMUNJULU 115.4 3061748
394:
395: FND_FILE.put_line(FND_FILE.log,l_processed || ' = 0');
396: FND_FILE.put_line(FND_FILE.log,l_inv);
397:
398: END IF;
399: EXCEPTION
400: