262: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
263: 'Validate Transaction Number');
264: End if;
265:
266: Fnd_file.put_line(fnd_file.log,'Error: Transaction Number is null');
267: retcode := c_error;
268:
269: End if;
270:
374:
375: Rollback to change_ib_owner;
376:
377: -- Write to conc log
378: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
379: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
380: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
381: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
382: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
375: Rollback to change_ib_owner;
376:
377: -- Write to conc log
378: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
379: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
380: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
381: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
382: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
383:
376:
377: -- Write to conc log
378: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
379: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
380: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
381: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
382: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
383:
384: csd_bulk_receive_util.write_to_conc_log
377: -- Write to conc log
378: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
379: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
380: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
381: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
382: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
383:
384: csd_bulk_receive_util.write_to_conc_log
385: ( p_msg_count => l_msg_count,
378: Fnd_file.put_line(fnd_file.log,'Error: IB Change Owner failed');
379: Fnd_file.put(fnd_file.log,'Serial Number :'||c_change_owner_rec.serial_number||',');
380: Fnd_file.put(fnd_file.log,'Inventory Item id :'||c_change_owner_rec.inventory_item_id||',');
381: Fnd_file.put(fnd_file.log,'Qty :'||c_change_owner_rec.quantity||',');
382: Fnd_file.put_line(fnd_file.log,'New Party Id :'||c_change_owner_rec.orig_party_id);
383:
384: csd_bulk_receive_util.write_to_conc_log
385: ( p_msg_count => l_msg_count,
386: p_msg_data => l_msg_data);
497: and incident_id is null
498: and internal_sr_flag = 'Y';
499:
500: -- Write to Conc Log
501: Fnd_file.put_line(fnd_file.log,'Error: Creation of Internal Service Request failed');
502: Fnd_file.put_line(fnd_file.log,'Internal party id :'||l_intr_party_id);
503:
504: csd_bulk_receive_util.write_to_conc_log
505: ( p_msg_count => l_msg_count,
498: and internal_sr_flag = 'Y';
499:
500: -- Write to Conc Log
501: Fnd_file.put_line(fnd_file.log,'Error: Creation of Internal Service Request failed');
502: Fnd_file.put_line(fnd_file.log,'Internal party id :'||l_intr_party_id);
503:
504: csd_bulk_receive_util.write_to_conc_log
505: ( p_msg_count => l_msg_count,
506: p_msg_data => l_msg_data);
594: set status = 'ERRORED'
595: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
596:
597: -- Write to conc log
598: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
599: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
600: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
601: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
602:
595: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
596:
597: -- Write to conc log
598: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
599: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
600: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
601: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
602:
603: csd_bulk_receive_util.write_to_conc_log
596:
597: -- Write to conc log
598: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
599: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
600: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
601: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
602:
603: csd_bulk_receive_util.write_to_conc_log
604: ( p_msg_count => l_msg_count,
597: -- Write to conc log
598: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
599: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
600: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
601: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
602:
603: csd_bulk_receive_util.write_to_conc_log
604: ( p_msg_count => l_msg_count,
605: p_msg_data => l_msg_data);
638: set status = 'ERRORED'
639: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
640:
641: -- Write to conc log
642: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
643: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
644: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
645: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
646:
639: where bulk_receive_id = c_reprocess_ro_rec.bulk_receive_id;
640:
641: -- Write to conc log
642: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
643: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
644: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
645: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
646:
647: csd_bulk_receive_util.write_to_conc_log
640:
641: -- Write to conc log
642: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
643: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
644: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
645: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
646:
647: csd_bulk_receive_util.write_to_conc_log
648: ( p_msg_count => l_msg_count,
641: -- Write to conc log
642: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
643: Fnd_file.put(fnd_file.log,'Serial Number :'||c_reprocess_ro_rec.serial_number||',');
644: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_reprocess_ro_rec.inventory_item_id||',');
645: Fnd_file.put_line(fnd_file.log,'Qty :'||c_reprocess_ro_rec.quantity);
646:
647: csd_bulk_receive_util.write_to_conc_log
648: ( p_msg_count => l_msg_count,
649: p_msg_data => l_msg_data);
1170: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1171: 'Error occured while creating RO '||l_msg_data);
1172: End if;
1173:
1174: fnd_file.put_line(fnd_file.log,'Error occured in repair order creation '||l_msg_data);
1175:
1176: update csd_bulk_receive_items_b
1177: set status = 'ERRORED'
1178: where bulk_receive_id = bk_rcv_rec.bulk_receive_id;
1217: fnd_log.STRING (fnd_log.level_procedure,
1218: 'CSD.PLSQL.CSD_BULK_RECEIVE_PVT.PROCESS_BULK_RECEIVE_ITEMS',
1219: 'Error occured while creating default product lines '||l_msg_data);
1220: End if;
1221: fnd_file.put_line(fnd_file.log,'Error occured during creation of default logistics lines '||l_msg_data);
1222: csd_bulk_receive_util.write_to_conc_log(l_msg_count,l_msg_data);
1223:
1224: update csd_bulk_receive_items_b
1225: set status = 'ERRORED'
1396: and incident_id is null
1397: and internal_sr_flag = 'N';
1398:
1399: -- Write to conc log
1400: Fnd_file.put_line(fnd_file.log,'Error: Service Request Creation failed');
1401: Fnd_file.put_line(fnd_file.log,'Party id :'||c_create_sr_rec.party_id);
1402:
1403: csd_bulk_receive_util.write_to_conc_log
1404: ( p_msg_count => l_msg_count,
1397: and internal_sr_flag = 'N';
1398:
1399: -- Write to conc log
1400: Fnd_file.put_line(fnd_file.log,'Error: Service Request Creation failed');
1401: Fnd_file.put_line(fnd_file.log,'Party id :'||c_create_sr_rec.party_id);
1402:
1403: csd_bulk_receive_util.write_to_conc_log
1404: ( p_msg_count => l_msg_count,
1405: p_msg_data => l_msg_data);
1491: set status = 'ERRORED'
1492: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1493:
1494: -- Write to conc log
1495: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
1496: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1497: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1498: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1499:
1492: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1493:
1494: -- Write to conc log
1495: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
1496: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1497: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1498: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1499:
1500: csd_bulk_receive_util.write_to_conc_log
1493:
1494: -- Write to conc log
1495: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
1496: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1497: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1498: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1499:
1500: csd_bulk_receive_util.write_to_conc_log
1501: ( p_msg_count => l_msg_count,
1494: -- Write to conc log
1495: Fnd_file.put_line(fnd_file.log,'Error : Creation of Default Logistic lines failed');
1496: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1497: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1498: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1499:
1500: csd_bulk_receive_util.write_to_conc_log
1501: ( p_msg_count => l_msg_count,
1502: p_msg_data => l_msg_data);
1537: set status = 'ERRORED'
1538: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1539:
1540: -- Write to conc log
1541: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
1542: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1543: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1544: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1545:
1538: where bulk_receive_id = c_create_ro_rec.bulk_receive_id;
1539:
1540: -- Write to conc log
1541: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
1542: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1543: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1544: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1545:
1546: csd_bulk_receive_util.write_to_conc_log
1539:
1540: -- Write to conc log
1541: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
1542: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1543: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1544: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1545:
1546: csd_bulk_receive_util.write_to_conc_log
1547: ( p_msg_count => l_msg_count,
1540: -- Write to conc log
1541: Fnd_file.put_line(fnd_file.log,'Error : Creation of Repair Order failed');
1542: Fnd_file.put(fnd_file.log,'Serial Number :'||c_create_ro_rec.serial_number||',');
1543: Fnd_file.put(fnd_file.log,'Inventory Item Id :'||c_create_ro_rec.inventory_item_id||',');
1544: Fnd_file.put_line(fnd_file.log,'Qty :'||c_create_ro_rec.quantity);
1545:
1546: csd_bulk_receive_util.write_to_conc_log
1547: ( p_msg_count => l_msg_count,
1548: p_msg_data => l_msg_data);
1587:
1588: -- Verify if the Sub Inv is set
1589: If ( fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV') is null) then
1590:
1591: Fnd_file.put_line(fnd_file.log,'Error : Bulk Receive Sub Inventory Profile is Null');
1592: Fnd_file.put_line(fnd_file.log,'Error : Unable to Auto Receive');
1593:
1594: -- Exit the loop
1595: exit;
1588: -- Verify if the Sub Inv is set
1589: If ( fnd_profile.value('CSD_BLK_RCV_DEFAULT_SUB_INV') is null) then
1590:
1591: Fnd_file.put_line(fnd_file.log,'Error : Bulk Receive Sub Inventory Profile is Null');
1592: Fnd_file.put_line(fnd_file.log,'Error : Unable to Auto Receive');
1593:
1594: -- Exit the loop
1595: exit;
1596:
1623: -- Draft RO is created for a Serialized Item with qty > 1
1624: If (l_source_serial_number is null and l_serial_number_control_code <> c_non_serialized ) then
1625:
1626: -- Display the log message;Verify if Serial number is entered
1627: Fnd_file.put_line(fnd_file.log,'Warning : Serial Number is not entered for a Serialized Item,unable to Auto receive');
1628: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
1629: Fnd_file.put_line(fnd_file.log,'Item :'||l_item_name);
1630:
1631: Else
1624: If (l_source_serial_number is null and l_serial_number_control_code <> c_non_serialized ) then
1625:
1626: -- Display the log message;Verify if Serial number is entered
1627: Fnd_file.put_line(fnd_file.log,'Warning : Serial Number is not entered for a Serialized Item,unable to Auto receive');
1628: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
1629: Fnd_file.put_line(fnd_file.log,'Item :'||l_item_name);
1630:
1631: Else
1632:
1625:
1626: -- Display the log message;Verify if Serial number is entered
1627: Fnd_file.put_line(fnd_file.log,'Warning : Serial Number is not entered for a Serialized Item,unable to Auto receive');
1628: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
1629: Fnd_file.put_line(fnd_file.log,'Item :'||l_item_name);
1630:
1631: Else
1632:
1633: -- Fix for bug#5415850
1663: End if;
1664:
1665: Else
1666: -- Display the log message RO RMA Order is not BOOKED
1667: Fnd_file.put_line(fnd_file.log,'Warning : Order is not Booked,unable to Auto receive');
1668: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
1669: Fnd_file.put_line(fnd_file.log,'Inventory Item :'||l_item_name);
1670: End if;
1671:
1664:
1665: Else
1666: -- Display the log message RO RMA Order is not BOOKED
1667: Fnd_file.put_line(fnd_file.log,'Warning : Order is not Booked,unable to Auto receive');
1668: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
1669: Fnd_file.put_line(fnd_file.log,'Inventory Item :'||l_item_name);
1670: End if;
1671:
1672: End Loop; -- End of c_auto_receive_rec Loop
1665: Else
1666: -- Display the log message RO RMA Order is not BOOKED
1667: Fnd_file.put_line(fnd_file.log,'Warning : Order is not Booked,unable to Auto receive');
1668: Fnd_file.put(fnd_file.log,'Serial Number :'||c_auto_receive_rec.serial_number);
1669: Fnd_file.put_line(fnd_file.log,'Inventory Item :'||l_item_name);
1670: End if;
1671:
1672: End Loop; -- End of c_auto_receive_rec Loop
1673:
1743: p_data => l_msg_data);
1744:
1745: IF l_msg_count = 1 THEN
1746:
1747: fnd_file.put_line( fnd_file.log, l_msg_data);
1748:
1749: ELSIF l_msg_count > 1 THEN
1750:
1751: -- If the message count is greater than 1, loop through the
1753:
1754: FOR l_msg_ctr IN 1..l_msg_count
1755: LOOP
1756: l_msg_data := fnd_msg_pub.get(l_msg_ctr, FND_API.G_FALSE );
1757: fnd_file.put_line( fnd_file.log, l_msg_data);
1758: END LOOP;
1759:
1760: END IF;
1761: