DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_PVT dependencies on FND_FILE

Line 231: Fnd_file.put_line(fnd_file.log,'Error: Transaction Number is null');

227: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
228: 'Validate Transaction Number');
229: End if;
230:
231: Fnd_file.put_line(fnd_file.log,'Error: Transaction Number is null');
232: retcode := c_error;
233:
234: End if;
235:

Line 343: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');

339:
340: Rollback to change_ib_owner;
341:
342: -- Write to conc log
343: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
344: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
345: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
346: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
347: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);

Line 344: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');

340: Rollback to change_ib_owner;
341:
342: -- Write to conc log
343: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
344: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
345: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
346: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
347: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
348:

Line 345: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');

341:
342: -- Write to conc log
343: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
344: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
345: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
346: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
347: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
348:
349: csd_bulk_receive_util.write_to_conc_log

Line 346: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');

342: -- Write to conc log
343: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
344: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
345: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
346: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
347: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
348:
349: csd_bulk_receive_util.write_to_conc_log
350: ( p_msg_count => l_msg_count,

Line 347: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);

343: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
344: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
345: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
346: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
347: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
348:
349: csd_bulk_receive_util.write_to_conc_log
350: ( p_msg_count => l_msg_count,
351: p_msg_data => l_msg_data);

Line 466: Fnd_file.put_line(fnd_file.log,'Error: Creation of Internal Service Request failed');

462: and incident_id is null
463: and internal_sr_flag = 'Y';
464:
465: -- Write to Conc Log
466: Fnd_file.put_line(fnd_file.log,'Error: Creation of Internal Service Request failed');
467: Fnd_file.put_line(fnd_file.log,'Internal party id :'||l_intr_party_id);
468:
469: csd_bulk_receive_util.write_to_conc_log
470: ( p_msg_count => l_msg_count,

Line 467: Fnd_file.put_line(fnd_file.log,'Internal party id :'||l_intr_party_id);

463: and internal_sr_flag = 'Y';
464:
465: -- Write to Conc Log
466: Fnd_file.put_line(fnd_file.log,'Error: Creation of Internal Service Request failed');
467: Fnd_file.put_line(fnd_file.log,'Internal party id :'||l_intr_party_id);
468:
469: csd_bulk_receive_util.write_to_conc_log
470: ( p_msg_count => l_msg_count,
471: p_msg_data => l_msg_data);

Line 563: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');

559: set status = 'ERRORED'
560: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
561:
562: -- Write to conc log
563: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
564: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
565: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
566: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
567:

Line 564: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');

560: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
561:
562: -- Write to conc log
563: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
564: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
565: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
566: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
567:
568: csd_bulk_receive_util.write_to_conc_log

Line 565: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');

561:
562: -- Write to conc log
563: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
564: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
565: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
566: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
567:
568: csd_bulk_receive_util.write_to_conc_log
569: ( p_msg_count => l_msg_count,

Line 566: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);

562: -- Write to conc log
563: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
564: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
565: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
566: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
567:
568: csd_bulk_receive_util.write_to_conc_log
569: ( p_msg_count => l_msg_count,
570: p_msg_data => l_msg_data);

Line 607: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');

603: set status = 'ERRORED'
604: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
605:
606: -- Write to conc log
607: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
608: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
609: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
610: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
611:

Line 608: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');

604: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
605:
606: -- Write to conc log
607: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
608: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
609: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
610: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
611:
612: csd_bulk_receive_util.write_to_conc_log

Line 609: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');

605:
606: -- Write to conc log
607: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
608: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
609: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
610: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
611:
612: csd_bulk_receive_util.write_to_conc_log
613: ( p_msg_count => l_msg_count,

Line 610: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);

606: -- Write to conc log
607: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
608: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
609: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
610: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
611:
612: csd_bulk_receive_util.write_to_conc_log
613: ( p_msg_count => l_msg_count,
614: p_msg_data => l_msg_data);

Line 688: Fnd_file.put_line(fnd_file.log,'Error: Service Request Creation failed');

684: and incident_id is null
685: and internal_sr_flag = 'N';
686:
687: -- Write to conc log
688: Fnd_file.put_line(fnd_file.log,'Error: Service Request Creation failed');
689: Fnd_file.put_line(fnd_file.log,'Party id :'||c_create_sr_rec.party_id);
690:
691: csd_bulk_receive_util.write_to_conc_log
692: ( p_msg_count => l_msg_count,

Line 689: Fnd_file.put_line(fnd_file.log,'Party id :'||c_create_sr_rec.party_id);

685: and internal_sr_flag = 'N';
686:
687: -- Write to conc log
688: Fnd_file.put_line(fnd_file.log,'Error: Service Request Creation failed');
689: Fnd_file.put_line(fnd_file.log,'Party id :'||c_create_sr_rec.party_id);
690:
691: csd_bulk_receive_util.write_to_conc_log
692: ( p_msg_count => l_msg_count,
693: p_msg_data => l_msg_data);

Line 783: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');

779: set status = 'ERRORED'
780: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
781:
782: -- Write to conc log
783: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
784: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
785: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
786: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
787:

Line 784: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');

780: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
781:
782: -- Write to conc log
783: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
784: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
785: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
786: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
787:
788: csd_bulk_receive_util.write_to_conc_log

Line 785: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');

781:
782: -- Write to conc log
783: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
784: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
785: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
786: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
787:
788: csd_bulk_receive_util.write_to_conc_log
789: ( p_msg_count => l_msg_count,

Line 786: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);

782: -- Write to conc log
783: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
784: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
785: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
786: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
787:
788: csd_bulk_receive_util.write_to_conc_log
789: ( p_msg_count => l_msg_count,
790: p_msg_data => l_msg_data);

Line 829: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');

825: set status = 'ERRORED'
826: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
827:
828: -- Write to conc log
829: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
830: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
831: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
832: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
833:

Line 830: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');

826: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
827:
828: -- Write to conc log
829: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
830: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
831: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
832: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
833:
834: csd_bulk_receive_util.write_to_conc_log

Line 831: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');

827:
828: -- Write to conc log
829: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
830: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
831: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
832: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
833:
834: csd_bulk_receive_util.write_to_conc_log
835: ( p_msg_count => l_msg_count,

Line 832: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);

828: -- Write to conc log
829: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
830: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
831: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
832: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
833:
834: csd_bulk_receive_util.write_to_conc_log
835: ( p_msg_count => l_msg_count,
836: p_msg_data => l_msg_data);

Line 872: Fnd_file.put_line(fnd_file.log,'Error : Bulk Receive Sub Inventory Profile is Null');

868:
869: -- Verify if the Sub Inv is set
870: If ( fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV') is null) then
871:
872: Fnd_file.put_line(fnd_file.log,'Error : Bulk Receive Sub Inventory Profile is Null');
873: Fnd_file.put_line(fnd_file.log,'Error : Unable to Auto Receive');
874:
875: -- Exit the loop
876: exit;

Line 873: Fnd_file.put_line(fnd_file.log,'Error : Unable to Auto Receive');

869: -- Verify if the Sub Inv is set
870: If ( fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV') is null) then
871:
872: Fnd_file.put_line(fnd_file.log,'Error : Bulk Receive Sub Inventory Profile is Null');
873: Fnd_file.put_line(fnd_file.log,'Error : Unable to Auto Receive');
874:
875: -- Exit the loop
876: exit;
877:

Line 908: Fnd_file.put_line(fnd_file.log,'Warning : Serial Number is not entered for a Serialized Item,unable to Auto receive');

904: -- Draft RO is created for a Serialized Item with qty > 1
905: If (l_source_serial_number is null and l_serial_number_control_code <> c_non_serialized ) then
906:
907: -- Display the log message;Verify if Serial number is entered
908: Fnd_file.put_line(fnd_file.log,'Warning : Serial Number is not entered for a Serialized Item,unable to Auto receive');
909: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
910: Fnd_file.put_line(fnd_file.log,'Item :'||l_item_name);
911:
912: Else

Line 909: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);

905: If (l_source_serial_number is null and l_serial_number_control_code <> c_non_serialized ) then
906:
907: -- Display the log message;Verify if Serial number is entered
908: Fnd_file.put_line(fnd_file.log,'Warning : Serial Number is not entered for a Serialized Item,unable to Auto receive');
909: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
910: Fnd_file.put_line(fnd_file.log,'Item :'||l_item_name);
911:
912: Else
913:

Line 910: Fnd_file.put_line(fnd_file.log,'Item :'||l_item_name);

906:
907: -- Display the log message;Verify if Serial number is entered
908: Fnd_file.put_line(fnd_file.log,'Warning : Serial Number is not entered for a Serialized Item,unable to Auto receive');
909: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
910: Fnd_file.put_line(fnd_file.log,'Item :'||l_item_name);
911:
912: Else
913:
914: -- Fix for bug#5415850

Line 926: Fnd_file.put_line(fnd_file.log,'Warning : Order is not Booked,unable to Auto receive');

922: End if;
923:
924: Else
925: -- Display the log message RO RMA Order is not BOOKED
926: Fnd_file.put_line(fnd_file.log,'Warning : Order is not Booked,unable to Auto receive');
927: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
928: Fnd_file.put_line(fnd_file.log,'Inventory Item :'||l_item_name);
929: End if;
930:

Line 927: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);

923:
924: Else
925: -- Display the log message RO RMA Order is not BOOKED
926: Fnd_file.put_line(fnd_file.log,'Warning : Order is not Booked,unable to Auto receive');
927: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
928: Fnd_file.put_line(fnd_file.log,'Inventory Item :'||l_item_name);
929: End if;
930:
931: End Loop; -- End of c_auto_receive_rec Loop

Line 928: Fnd_file.put_line(fnd_file.log,'Inventory Item :'||l_item_name);

924: Else
925: -- Display the log message RO RMA Order is not BOOKED
926: Fnd_file.put_line(fnd_file.log,'Warning : Order is not Booked,unable to Auto receive');
927: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
928: Fnd_file.put_line(fnd_file.log,'Inventory Item :'||l_item_name);
929: End if;
930:
931: End Loop; -- End of c_auto_receive_rec Loop
932:

Line 1000: fnd_file.put_line( fnd_file.log, l_msg_data);

996: p_data => l_msg_data);
997:
998: IF l_msg_count = 1 THEN
999:
1000: fnd_file.put_line( fnd_file.log, l_msg_data);
1001:
1002: ELSIF l_msg_count > 1 THEN
1003:
1004: -- If the message count is greater than 1, loop through the

Line 1010: fnd_file.put_line( fnd_file.log, l_msg_data);

1006:
1007: FOR l_msg_ctr IN 1..l_msg_count
1008: LOOP
1009: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1010: fnd_file.put_line( fnd_file.log, l_msg_data);
1011: END LOOP;
1012:
1013: END IF;
1014: