DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on FND_FILE

Line 1349: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');

1345:
1346: l_header_error := TRUE;
1347:
1348: -- Display the message
1349: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1350: Fnd_file.put(fnd_file.log,'Column name:');
1351: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1352: Fnd_file.put(fnd_file.log,'Error Message:');
1353: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);

Line 1350: Fnd_file.put(fnd_file.log,'Column name:');

1346: l_header_error := TRUE;
1347:
1348: -- Display the message
1349: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1350: Fnd_file.put(fnd_file.log,'Column name:');
1351: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1352: Fnd_file.put(fnd_file.log,'Error Message:');
1353: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1354:

Line 1351: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);

1347:
1348: -- Display the message
1349: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1350: Fnd_file.put(fnd_file.log,'Column name:');
1351: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1352: Fnd_file.put(fnd_file.log,'Error Message:');
1353: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1354:
1355: End if;

Line 1352: Fnd_file.put(fnd_file.log,'Error Message:');

1348: -- Display the message
1349: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1350: Fnd_file.put(fnd_file.log,'Column name:');
1351: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1352: Fnd_file.put(fnd_file.log,'Error Message:');
1353: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1354:
1355: End if;
1356: End Loop;

Line 1353: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);

1349: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1350: Fnd_file.put(fnd_file.log,'Column name:');
1351: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1352: Fnd_file.put(fnd_file.log,'Error Message:');
1353: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1354:
1355: End if;
1356: End Loop;
1357:

Line 1410: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');

1406: l_unit_of_measure,l_inventory_item_id,l_order_header_id,
1407: l_order_line_id,l_order_number,l_serial_number,l_item_name;
1408: Close c_ro_prodtxn;
1409:
1410: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
1411: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
1412: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
1414: Fnd_file.put(fnd_file.log,'Column name:');

Line 1411: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');

1407: l_order_line_id,l_order_number,l_serial_number,l_item_name;
1408: Close c_ro_prodtxn;
1409:
1410: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
1411: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
1412: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
1414: Fnd_file.put(fnd_file.log,'Column name:');
1415: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);

Line 1412: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');

1408: Close c_ro_prodtxn;
1409:
1410: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
1411: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
1412: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
1414: Fnd_file.put(fnd_file.log,'Column name:');
1415: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1416: Fnd_file.put(fnd_file.log,'Error Message:');

Line 1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);

1409:
1410: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
1411: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
1412: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
1414: Fnd_file.put(fnd_file.log,'Column name:');
1415: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1416: Fnd_file.put(fnd_file.log,'Error Message:');
1417: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);

Line 1414: Fnd_file.put(fnd_file.log,'Column name:');

1410: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
1411: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
1412: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
1414: Fnd_file.put(fnd_file.log,'Column name:');
1415: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1416: Fnd_file.put(fnd_file.log,'Error Message:');
1417: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1418:

Line 1415: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);

1411: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
1412: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
1414: Fnd_file.put(fnd_file.log,'Column name:');
1415: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1416: Fnd_file.put(fnd_file.log,'Error Message:');
1417: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1418:
1419: End If;

Line 1416: Fnd_file.put(fnd_file.log,'Error Message:');

1412: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
1414: Fnd_file.put(fnd_file.log,'Column name:');
1415: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1416: Fnd_file.put(fnd_file.log,'Error Message:');
1417: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1418:
1419: End If;
1420:

Line 1417: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);

1413: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
1414: Fnd_file.put(fnd_file.log,'Column name:');
1415: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1416: Fnd_file.put(fnd_file.log,'Error Message:');
1417: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1418:
1419: End If;
1420:
1421: End Loop;

Line 1452: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');

1448:
1449: -- fix for bug 5227347
1450: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1451:
1452: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
1453: csd_bulk_receive_util.write_to_conc_log
1454: ( p_msg_count => l_msg_count,
1455: p_msg_data => l_msg_data);
1456:

Line 1520: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');

1516:
1517: -- fix for bug 5227347
1518: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1519:
1520: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
1521: csd_bulk_receive_util.write_to_conc_log
1522: ( p_msg_count => l_msg_count,
1523: p_msg_data => l_msg_data);
1524:

Line 1614: Fnd_file.put_line(fnd_file.log,l_msg);

1610: If p_msg_count = 1 then
1611:
1612: l_msg := fnd_msg_pub.get(p_msg_index => 1,
1613: p_encoded => 'F' );
1614: Fnd_file.put_line(fnd_file.log,l_msg);
1615:
1616: Elsif p_msg_count > 1 then
1617:
1618: For i in 1..p_msg_count

Line 1623: Fnd_file.put_line(fnd_file.log,l_msg);

1619:
1620: Loop
1621: l_msg := fnd_msg_pub.get(p_msg_index => i,
1622: p_encoded => 'F' );
1623: Fnd_file.put_line(fnd_file.log,l_msg);
1624: End loop;
1625:
1626: End If;
1627:

Line 1718: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);

1714:
1715: fnd_message.set_name('CSD','CSD_BULK_RCV_STATUS_CONC_LABEL');
1716: l_status_label := fnd_message.get;
1717:
1718: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
1719: Fnd_file.put_line(fnd_file.output,'');
1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));

Line 1719: Fnd_file.put_line(fnd_file.output,'');

1715: fnd_message.set_name('CSD','CSD_BULK_RCV_STATUS_CONC_LABEL');
1716: l_status_label := fnd_message.get;
1717:
1718: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
1719: Fnd_file.put_line(fnd_file.output,'');
1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));

Line 1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));

1716: l_status_label := fnd_message.get;
1717:
1718: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
1719: Fnd_file.put_line(fnd_file.output,'');
1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
1724: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));

Line 1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));

1717:
1718: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
1719: Fnd_file.put_line(fnd_file.output,'');
1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
1724: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
1725: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));

Line 1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));

1718: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
1719: Fnd_file.put_line(fnd_file.output,'');
1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
1724: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
1725: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
1726: Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));

Line 1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));

1719: Fnd_file.put_line(fnd_file.output,'');
1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
1724: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
1725: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
1726: Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
1727:

Line 1724: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));

1720: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
1724: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
1725: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
1726: Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
1727:
1728:

Line 1725: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));

1721: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
1724: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
1725: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
1726: Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
1727:
1728:
1729: For c_get_bulk_receive_rec in c_get_bulk_receive( p_transaction_number)

Line 1726: Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));

1722: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
1723: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
1724: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
1725: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
1726: Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
1727:
1728:
1729: For c_get_bulk_receive_rec in c_get_bulk_receive( p_transaction_number)
1730: Loop

Line 1751: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));

1747: Fetch c_get_item_desc into l_item_desc;
1748: Close c_get_item_desc;
1749:
1750:
1751: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
1752: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
1753: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
1754: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
1755: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));

Line 1752: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));

1748: Close c_get_item_desc;
1749:
1750:
1751: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
1752: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
1753: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
1754: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
1755: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
1756:

Line 1753: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));

1749:
1750:
1751: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
1752: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
1753: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
1754: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
1755: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
1756:
1757:

Line 1754: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));

1750:
1751: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
1752: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
1753: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
1754: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
1755: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
1756:
1757:
1758: If ( c_get_bulk_receive_rec.status = 'ERRORED' ) then

Line 1755: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));

1751: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
1752: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
1753: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
1754: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
1755: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
1756:
1757:
1758: If ( c_get_bulk_receive_rec.status = 'ERRORED' ) then
1759:

Line 1783: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status),28,' '));

1779: l_status := fnd_message.get;
1780:
1781: End if;
1782:
1783: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status),28,' '));
1784:
1785: End Loop;
1786:
1787: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then