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 216: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));

212: -- RMUNJULU 115.4 3061748
213: IF G_ERROR <> 'Y' THEN
214:
215: --log
216: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
217: FND_FILE.put_line(FND_FILE.log, l_type ||
218: RPAD(' ',40-LENGTH(l_type),' ') ||
219: l_processed);
220:

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

213: IF G_ERROR <> 'Y' THEN
214:
215: --log
216: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
217: FND_FILE.put_line(FND_FILE.log, l_type ||
218: RPAD(' ',40-LENGTH(l_type),' ') ||
219: l_processed);
220:
221: FND_FILE.put_line(FND_FILE.log, RPAD('-',77 ,'-'));

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

217: FND_FILE.put_line(FND_FILE.log, l_type ||
218: RPAD(' ',40-LENGTH(l_type),' ') ||
219: l_processed);
220:
221: FND_FILE.put_line(FND_FILE.log, RPAD('-',77 ,'-'));
222:
223: FND_FILE.put_line(FND_FILE.log, l_term_k ||
224: RPAD(' ',40-LENGTH(l_term_k),' ') ||
225: l_success);

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

219: l_processed);
220:
221: FND_FILE.put_line(FND_FILE.log, RPAD('-',77 ,'-'));
222:
223: FND_FILE.put_line(FND_FILE.log, l_term_k ||
224: RPAD(' ',40-LENGTH(l_term_k),' ') ||
225: l_success);
226:
227: FND_FILE.put_line(FND_FILE.log, l_error_k ||

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

223: FND_FILE.put_line(FND_FILE.log, l_term_k ||
224: RPAD(' ',40-LENGTH(l_term_k),' ') ||
225: l_success);
226:
227: FND_FILE.put_line(FND_FILE.log, l_error_k ||
228: RPAD(' ',40-LENGTH(l_error_k),' ') ||
229: l_error);
230: FND_FILE.put_line(FND_FILE.log,'');
231: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));

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

226:
227: FND_FILE.put_line(FND_FILE.log, l_error_k ||
228: RPAD(' ',40-LENGTH(l_error_k),' ') ||
229: l_error);
230: FND_FILE.put_line(FND_FILE.log,'');
231: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
232:
233: -- output
234: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||

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

227: FND_FILE.put_line(FND_FILE.log, l_error_k ||
228: RPAD(' ',40-LENGTH(l_error_k),' ') ||
229: l_error);
230: FND_FILE.put_line(FND_FILE.log,'');
231: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
232:
233: -- output
234: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||
235: l_orcl_logo);

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

230: FND_FILE.put_line(FND_FILE.log,'');
231: FND_FILE.put_line(FND_FILE.log, RPAD('=',77,'=' ));
232:
233: -- output
234: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||
235: l_orcl_logo);
236:
237: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_term_heading)/2, ' ' ) ||
238: l_term_heading);

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

233: -- output
234: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_orcl_logo)/2, ' ' ) ||
235: l_orcl_logo);
236:
237: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_term_heading)/2, ' ' ) ||
238: l_term_heading);
239:
240: FND_FILE.put_line(FND_FILE.output, RPAD(' ',128/2-LENGTH(l_term_heading)/2 , ' ' ) ||
241: RPAD('-',LENGTH(l_term_heading),'-'));

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

236:
237: FND_FILE.PUT_LINE(FND_FILE.output, RPAD(' ', 128/2-LENGTH(l_term_heading)/2, ' ' ) ||
238: l_term_heading);
239:
240: FND_FILE.put_line(FND_FILE.output, RPAD(' ',128/2-LENGTH(l_term_heading)/2 , ' ' ) ||
241: RPAD('-',LENGTH(l_term_heading),'-'));
242:
243: FND_FILE.put_line(FND_FILE.output, '');
244:

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

239:
240: FND_FILE.put_line(FND_FILE.output, RPAD(' ',128/2-LENGTH(l_term_heading)/2 , ' ' ) ||
241: RPAD('-',LENGTH(l_term_heading),'-'));
242:
243: FND_FILE.put_line(FND_FILE.output, '');
244:
245: FND_FILE.put_line(FND_FILE.output, l_set_of_books ||' : '||
246: l_set_of_books_name ||
247: RPAD(' ', 128-LENGTH(l_set_of_books)-LENGTH(l_set_of_books_name)-LENGTH(l_run_date)-25, ' ' ) ||

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

241: RPAD('-',LENGTH(l_term_heading),'-'));
242:
243: FND_FILE.put_line(FND_FILE.output, '');
244:
245: FND_FILE.put_line(FND_FILE.output, l_set_of_books ||' : '||
246: l_set_of_books_name ||
247: RPAD(' ', 128-LENGTH(l_set_of_books)-LENGTH(l_set_of_books_name)-LENGTH(l_run_date)-25, ' ' ) ||
248: l_run_date ||' : ' ||
249: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'));

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

247: RPAD(' ', 128-LENGTH(l_set_of_books)-LENGTH(l_set_of_books_name)-LENGTH(l_run_date)-25, ' ' ) ||
248: l_run_date ||' : ' ||
249: TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI'));
250:
251: FND_FILE.put_line(FND_FILE.output, l_oper_unit || ' : ' ||
252: l_org_name ||
253: RPAD(' ', 128-LENGTH(l_oper_unit)-LENGTH(l_org_name)-LENGTH(l_inv_ended_by)-25, ' ' ) ||
254: l_inv_ended_by ||' : ' ||
255: TO_CHAR(G_INV_ENDED_BY_DATE, 'DD-MON-YYYY HH24:MI'));

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

253: RPAD(' ', 128-LENGTH(l_oper_unit)-LENGTH(l_org_name)-LENGTH(l_inv_ended_by)-25, ' ' ) ||
254: l_inv_ended_by ||' : ' ||
255: TO_CHAR(G_INV_ENDED_BY_DATE, 'DD-MON-YYYY HH24:MI'));
256:
257: FND_FILE.put_line(FND_FILE.output,'');
258: FND_FILE.put_line(FND_FILE.output,'');
259:
260: FND_FILE.put_line(FND_FILE.output, l_type ||
261: RPAD(' ',40-LENGTH(l_type),' ') ||

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

254: l_inv_ended_by ||' : ' ||
255: TO_CHAR(G_INV_ENDED_BY_DATE, 'DD-MON-YYYY HH24:MI'));
256:
257: FND_FILE.put_line(FND_FILE.output,'');
258: FND_FILE.put_line(FND_FILE.output,'');
259:
260: FND_FILE.put_line(FND_FILE.output, l_type ||
261: RPAD(' ',40-LENGTH(l_type),' ') ||
262: l_processed);

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

256:
257: FND_FILE.put_line(FND_FILE.output,'');
258: FND_FILE.put_line(FND_FILE.output,'');
259:
260: FND_FILE.put_line(FND_FILE.output, l_type ||
261: RPAD(' ',40-LENGTH(l_type),' ') ||
262: l_processed);
263:
264: FND_FILE.put_line(FND_FILE.output, RPAD('-',128 ,'-'));

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

260: FND_FILE.put_line(FND_FILE.output, l_type ||
261: RPAD(' ',40-LENGTH(l_type),' ') ||
262: l_processed);
263:
264: FND_FILE.put_line(FND_FILE.output, RPAD('-',128 ,'-'));
265:
266: FND_FILE.put_line(FND_FILE.output, l_term_k ||
267: RPAD(' ',40-LENGTH(l_term_k),' ') ||
268: l_success);

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

262: l_processed);
263:
264: FND_FILE.put_line(FND_FILE.output, RPAD('-',128 ,'-'));
265:
266: FND_FILE.put_line(FND_FILE.output, l_term_k ||
267: RPAD(' ',40-LENGTH(l_term_k),' ') ||
268: l_success);
269:
270: FND_FILE.put_line(FND_FILE.output, l_error_k ||

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

266: FND_FILE.put_line(FND_FILE.output, l_term_k ||
267: RPAD(' ',40-LENGTH(l_term_k),' ') ||
268: l_success);
269:
270: FND_FILE.put_line(FND_FILE.output, l_error_k ||
271: RPAD(' ',40-LENGTH(l_error_k),' ') ||
272: l_error);
273:
274: FND_FILE.put_line(FND_FILE.output,'');

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

270: FND_FILE.put_line(FND_FILE.output, l_error_k ||
271: RPAD(' ',40-LENGTH(l_error_k),' ') ||
272: l_error);
273:
274: FND_FILE.put_line(FND_FILE.output,'');
275: FND_FILE.put_line(FND_FILE.output, RPAD('=',128,'=' ));
276: FND_FILE.put_line(FND_FILE.output,'');
277:
278: -- Print Investor Agreements Terminated Successfully

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

271: RPAD(' ',40-LENGTH(l_error_k),' ') ||
272: l_error);
273:
274: FND_FILE.put_line(FND_FILE.output,'');
275: FND_FILE.put_line(FND_FILE.output, RPAD('=',128,'=' ));
276: FND_FILE.put_line(FND_FILE.output,'');
277:
278: -- Print Investor Agreements Terminated Successfully
279: IF l_success > 0 THEN

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

272: l_error);
273:
274: FND_FILE.put_line(FND_FILE.output,'');
275: FND_FILE.put_line(FND_FILE.output, RPAD('=',128,'=' ));
276: FND_FILE.put_line(FND_FILE.output,'');
277:
278: -- Print Investor Agreements Terminated Successfully
279: IF l_success > 0 THEN
280:

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

277:
278: -- Print Investor Agreements Terminated Successfully
279: IF l_success > 0 THEN
280:
281: FND_FILE.put_line(FND_FILE.output, l_term_k);
282: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_term_k), '-' ));
283: FND_FILE.put_line(FND_FILE.output,'');
284:
285: l_print := 'N';

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

278: -- Print Investor Agreements Terminated Successfully
279: IF l_success > 0 THEN
280:
281: FND_FILE.put_line(FND_FILE.output, l_term_k);
282: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_term_k), '-' ));
283: FND_FILE.put_line(FND_FILE.output,'');
284:
285: l_print := 'N';
286:

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

279: IF l_success > 0 THEN
280:
281: FND_FILE.put_line(FND_FILE.output, l_term_k);
282: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_term_k), '-' ));
283: FND_FILE.put_line(FND_FILE.output,'');
284:
285: l_print := 'N';
286:
287: FOR i IN success_message_table.FIRST..success_message_table.LAST LOOP

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

287: FOR i IN success_message_table.FIRST..success_message_table.LAST LOOP
288:
289: IF l_print = 'N' THEN
290:
291: FND_FILE.put_line(FND_FILE.output, l_serial || RPAD(' ',15-LENGTH(l_serial),' ')||
292: l_k_num || RPAD(' ',35-LENGTH(l_k_num),' ')||
293: l_start_date||RPAD(' ',15-LENGTH(l_start_date),' ') ||
294: l_end_date||RPAD(' ',15-LENGTH(l_end_date),' ') ||
295: l_status||RPAD(' ',15-LENGTH(l_status),' '));

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

293: l_start_date||RPAD(' ',15-LENGTH(l_start_date),' ') ||
294: l_end_date||RPAD(' ',15-LENGTH(l_end_date),' ') ||
295: l_status||RPAD(' ',15-LENGTH(l_status),' '));
296:
297: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_serial),'-') || RPAD('-',15-LENGTH(l_serial),'-')||
298: RPAD('-',LENGTH(l_k_num),'-') || RPAD('-',35-LENGTH(l_k_num),'-')||
299: RPAD('-',LENGTH(l_start_date),'-')||RPAD('-',15-LENGTH(l_start_date),'-') ||
300: RPAD('-',LENGTH(l_end_date),'-')||RPAD('-',15-LENGTH(l_end_date),'-') ||
301: RPAD('-',LENGTH(l_status),'-')||RPAD('-',15-LENGTH(l_status),'-'));

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

302:
303: l_print := 'Y';
304: END IF;
305:
306: FND_FILE.put_line(FND_FILE.output, i || RPAD(' ',15-LENGTH(i),' ')||
307: success_message_table(i).contract_number ||
308: RPAD(' ',35-LENGTH(success_message_table(i).contract_number),' ')||
309: success_message_table(i).start_date||
310: RPAD(' ',15-LENGTH(success_message_table(i).start_date),' ') ||

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

312: RPAD(' ',15-LENGTH(success_message_table(i).end_date),' ') ||
313: success_message_table(i).status||
314: RPAD(' ',15-LENGTH(success_message_table(i).status),' '));
315:
316: --FND_FILE.put_line(FND_FILE.output,'');
317:
318: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
319:
320: --FOR j IN success_message_table(i).msg_tbl.FIRST..success_message_table(i).msg_tbl.LAST LOOP

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

314: RPAD(' ',15-LENGTH(success_message_table(i).status),' '));
315:
316: --FND_FILE.put_line(FND_FILE.output,'');
317:
318: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
319:
320: --FOR j IN success_message_table(i).msg_tbl.FIRST..success_message_table(i).msg_tbl.LAST LOOP
321: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);
322: --FND_FILE.put_line(FND_FILE.output,'');

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

317:
318: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
319:
320: --FOR j IN success_message_table(i).msg_tbl.FIRST..success_message_table(i).msg_tbl.LAST LOOP
321: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);
322: --FND_FILE.put_line(FND_FILE.output,'');
323: --END LOOP;
324:
325: --FND_FILE.put_line(FND_FILE.output,'');

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

318: --FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
319:
320: --FOR j IN success_message_table(i).msg_tbl.FIRST..success_message_table(i).msg_tbl.LAST LOOP
321: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);
322: --FND_FILE.put_line(FND_FILE.output,'');
323: --END LOOP;
324:
325: --FND_FILE.put_line(FND_FILE.output,'');
326:

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

321: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || success_message_table(i).msg_tbl(j).msg);
322: --FND_FILE.put_line(FND_FILE.output,'');
323: --END LOOP;
324:
325: --FND_FILE.put_line(FND_FILE.output,'');
326:
327: END LOOP;
328: END IF;
329:

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

326:
327: END LOOP;
328: END IF;
329:
330: FND_FILE.put_line(FND_FILE.output,'');
331:
332: -- Print Investor Agreements errored
333: IF l_error > 0 THEN
334:

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

331:
332: -- Print Investor Agreements errored
333: IF l_error > 0 THEN
334:
335: FND_FILE.put_line(FND_FILE.output, l_error_k);
336: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_error_k), '-' ));
337: FND_FILE.put_line(FND_FILE.output,'');
338:
339: -- SECHAWLA 26-JAN-04 3377730: Initialize the table index

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

332: -- Print Investor Agreements errored
333: IF l_error > 0 THEN
334:
335: FND_FILE.put_line(FND_FILE.output, l_error_k);
336: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_error_k), '-' ));
337: FND_FILE.put_line(FND_FILE.output,'');
338:
339: -- SECHAWLA 26-JAN-04 3377730: Initialize the table index
340: msg_lines_table_index := 1;

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

333: IF l_error > 0 THEN
334:
335: FND_FILE.put_line(FND_FILE.output, l_error_k);
336: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_error_k), '-' ));
337: FND_FILE.put_line(FND_FILE.output,'');
338:
339: -- SECHAWLA 26-JAN-04 3377730: Initialize the table index
340: msg_lines_table_index := 1;
341:

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

340: msg_lines_table_index := 1;
341:
342: FOR i IN error_message_table.FIRST..error_message_table.LAST LOOP
343:
344: FND_FILE.put_line(FND_FILE.output, l_serial || RPAD(' ',15-LENGTH(l_serial),' ')||
345: l_k_num || RPAD(' ',35-LENGTH(l_k_num),' ')||
346: l_start_date||RPAD(' ',15-LENGTH(l_start_date),' ') ||
347: l_end_date||RPAD(' ',15-LENGTH(l_end_date),' ') ||
348: l_status||RPAD(' ',15-LENGTH(l_status),' '));

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

346: l_start_date||RPAD(' ',15-LENGTH(l_start_date),' ') ||
347: l_end_date||RPAD(' ',15-LENGTH(l_end_date),' ') ||
348: l_status||RPAD(' ',15-LENGTH(l_status),' '));
349:
350: FND_FILE.put_line(FND_FILE.output, RPAD('-',LENGTH(l_serial),'-') || RPAD('-',15-LENGTH(l_serial),'-')||
351: RPAD('-',LENGTH(l_k_num),'-') || RPAD('-',35-LENGTH(l_k_num),'-')||
352: RPAD('-',LENGTH(l_start_date),'-')||RPAD('-',15-LENGTH(l_start_date),'-') ||
353: RPAD('-',LENGTH(l_end_date),'-')||RPAD('-',15-LENGTH(l_end_date),'-') ||
354: RPAD('-',LENGTH(l_status),'-')||RPAD('-',15-LENGTH(l_status),'-'));

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

352: RPAD('-',LENGTH(l_start_date),'-')||RPAD('-',15-LENGTH(l_start_date),'-') ||
353: RPAD('-',LENGTH(l_end_date),'-')||RPAD('-',15-LENGTH(l_end_date),'-') ||
354: RPAD('-',LENGTH(l_status),'-')||RPAD('-',15-LENGTH(l_status),'-'));
355:
356: FND_FILE.put_line(FND_FILE.output, i || RPAD(' ',15-LENGTH(i),' ')||
357: error_message_table(i).contract_number ||
358: RPAD(' ',35-LENGTH(error_message_table(i).contract_number),' ')||
359: error_message_table(i).start_date||
360: RPAD(' ',15-LENGTH(error_message_table(i).start_date),' ') ||

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

362: RPAD(' ',15-LENGTH(error_message_table(i).end_date),' ') ||
363: error_message_table(i).status||
364: RPAD(' ',15-LENGTH(error_message_table(i).status),' '));
365:
366: FND_FILE.put_line(FND_FILE.output,'');
367:
368: FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
369:
370: -- SECHAWLA 26-JAN-04 3377730: A table can not have a table or record with composite fields on lower versions

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

364: RPAD(' ',15-LENGTH(error_message_table(i).status),' '));
365:
366: FND_FILE.put_line(FND_FILE.output,'');
367:
368: FND_FILE.put_line(FND_FILE.output, RPAD(' ',5,' ') || l_messages || ' :');
369:
370: -- SECHAWLA 26-JAN-04 3377730: A table can not have a table or record with composite fields on lower versions
371: -- of db/Pl Sql Removed the msg_tbl field from message_rec_type
372: /*

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

370: -- SECHAWLA 26-JAN-04 3377730: A table can not have a table or record with composite fields on lower versions
371: -- of db/Pl Sql Removed the msg_tbl field from message_rec_type
372: /*
373: FOR j IN error_message_table(i).msg_tbl.FIRST..error_message_table(i).msg_tbl.LAST LOOP
374: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || error_message_table(i).msg_tbl(j).msg);
375: FND_FILE.put_line(FND_FILE.output,'');
376: END LOOP;
377: */
378:

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

371: -- of db/Pl Sql Removed the msg_tbl field from message_rec_type
372: /*
373: FOR j IN error_message_table(i).msg_tbl.FIRST..error_message_table(i).msg_tbl.LAST LOOP
374: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || error_message_table(i).msg_tbl(j).msg);
375: FND_FILE.put_line(FND_FILE.output,'');
376: END LOOP;
377: */
378:
379: -- SECHAWLA 26-JAN-04 3377730: A table can not have a table or record with composite fields on lower versions

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

387: FOR j IN msg_lines_table.FIRST..msg_lines_table.LAST LOOP
388: IF msg_lines_table(j).id = error_message_table(i).id THEN
389: --Bug 7007686
390: l_msg_num:=l_msg_num+1;
391: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || msg_lines_table(j).msg);
392: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || l_msg_num || ': ' || msg_lines_table(j).msg);
393: --Bug 7007686 :End
394: FND_FILE.put_line(FND_FILE.output,'');
395:

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

388: IF msg_lines_table(j).id = error_message_table(i).id THEN
389: --Bug 7007686
390: l_msg_num:=l_msg_num+1;
391: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || msg_lines_table(j).msg);
392: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || l_msg_num || ': ' || msg_lines_table(j).msg);
393: --Bug 7007686 :End
394: FND_FILE.put_line(FND_FILE.output,'');
395:
396: /*Bug 7007686 :commented

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

390: l_msg_num:=l_msg_num+1;
391: --FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || j || ': ' || msg_lines_table(j).msg);
392: FND_FILE.put(FND_FILE.output, RPAD(' ',5,' ') || l_msg_num || ': ' || msg_lines_table(j).msg);
393: --Bug 7007686 :End
394: FND_FILE.put_line(FND_FILE.output,'');
395:
396: /*Bug 7007686 :commented
397: ELSE
398: msg_lines_table_index := j ;

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

401: END IF;
402:
403: END LOOP;
404:
405: FND_FILE.put_line(FND_FILE.output,'');
406:
407: END LOOP;
408:
409: END IF;

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

407: END LOOP;
408:
409: END IF;
410:
411: FND_FILE.put_line(FND_FILE.output,'');
412: FND_FILE.put_line(FND_FILE.output,'');
413: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);
414:
415: ELSE -- RMUNJULU 115.4 3061748

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

408:
409: END IF;
410:
411: FND_FILE.put_line(FND_FILE.output,'');
412: FND_FILE.put_line(FND_FILE.output,'');
413: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);
414:
415: ELSE -- RMUNJULU 115.4 3061748
416:

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

409: END IF;
410:
411: FND_FILE.put_line(FND_FILE.output,'');
412: FND_FILE.put_line(FND_FILE.output,'');
413: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);
414:
415: ELSE -- RMUNJULU 115.4 3061748
416:
417: FND_FILE.put_line(FND_FILE.log,l_processed || ' = 0');

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

413: FND_FILE.put_line(FND_FILE.output, RPAD(' ', 53 , ' ' ) || l_eop);
414:
415: ELSE -- RMUNJULU 115.4 3061748
416:
417: FND_FILE.put_line(FND_FILE.log,l_processed || ' = 0');
418: FND_FILE.put_line(FND_FILE.log,l_inv);
419:
420: END IF;
421: EXCEPTION

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

414:
415: ELSE -- RMUNJULU 115.4 3061748
416:
417: FND_FILE.put_line(FND_FILE.log,l_processed || ' = 0');
418: FND_FILE.put_line(FND_FILE.log,l_inv);
419:
420: END IF;
421: EXCEPTION
422: