DBA Data[Home] [Help]

APPS.CSD_RECALLS_PVT dependencies on FND_FILE

Line 417: fnd_file.put_line(fnd_file.output,l_recall||' : '||l_recall_number);

413: WHERE crl.processing_group_id = p_group_id
414: AND crl.recall_id = crh.recall_id
415: AND rownum < 2;
416:
417: fnd_file.put_line(fnd_file.output,l_recall||' : '||l_recall_number);
418: fnd_file.put_line(fnd_file.output,' ');
419:
420: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');
421: l_serial_label := fnd_message.get;

Line 418: fnd_file.put_line(fnd_file.output,' ');

414: AND crl.recall_id = crh.recall_id
415: AND rownum < 2;
416:
417: fnd_file.put_line(fnd_file.output,l_recall||' : '||l_recall_number);
418: fnd_file.put_line(fnd_file.output,' ');
419:
420: fnd_message.set_name('CSD','CSD_BULK_RCV_SERIAL_CONC_LABEL');
421: l_serial_label := fnd_message.get;
422: fnd_message.set_name('CSD','CSD_BULK_RCV_ITEM_CONC_LABEL');

Line 434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));

430: fnd_message.set_name('GMO', 'GMO_INSTANCE_NUMBER_FIELD_NAME');
431: l_instance_label := fnd_message.get;
432:
433: -- put the output header.
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));

Line 435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));

431: l_instance_label := fnd_message.get;
432:
433: -- put the output header.
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));

Line 436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));

432:
433: -- put the output header.
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));

Line 437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));

433: -- put the output header.
434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
441:

Line 438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));

434: Fnd_file.put(fnd_file.output,rpad(l_instance_label,18,' '));
435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
441:
442: -- write the data.

Line 439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));

435: fnd_file.put(fnd_file.output,rpad(l_serial_label,18,' '));
436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
441:
442: -- write the data.
443: FOR i IN recall_details

Line 440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));

436: fnd_file.put(fnd_file.output,rpad(l_item_label,20,' '));
437: fnd_file.put(fnd_file.output,rpad(l_sr_label,25,' '));
438: fnd_file.put(fnd_file.output,rpad(l_ro_label,20,' '));
439: fnd_file.put_line(fnd_file.output,rpad(l_qty_label,10,' '));
440: fnd_file.put_line(fnd_file.output,rpad('-',114,'-'));
441:
442: -- write the data.
443: FOR i IN recall_details
444: LOOP

Line 445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));

441:
442: -- write the data.
443: FOR i IN recall_details
444: LOOP
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));

Line 446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));

442: -- write the data.
443: FOR i IN recall_details
444: LOOP
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));

Line 447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));

443: FOR i IN recall_details
444: LOOP
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
451: END LOOP;

Line 448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));

444: LOOP
445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
451: END LOOP;
452:

Line 449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));

445: fnd_file.put(fnd_file.output,rpad(nvl(i.instance_number,' '),18,' '));
446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
451: END LOOP;
452:
453: END write_to_conc_out;

Line 450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));

446: fnd_file.put(fnd_file.output,rpad(nvl(i.serial_number,' '),18,' '));
447: fnd_file.put(fnd_file.output,rpad(nvl(i.concatenated_segments,' '),20,' '));
448: fnd_file.put(fnd_file.output,rpad(nvl(i.incident_number,' '),25,' '));
449: fnd_file.put(fnd_file.output,rpad(nvl(i.repair_number,' '),20,' '));
450: fnd_file.put_line(fnd_file.output,rpad(nvl(to_char(i.quantity),' '),10,' '));
451: END LOOP;
452:
453: END write_to_conc_out;
454: