1978:
1979: l_header_error := TRUE;
1980:
1981: -- Display the message
1982: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1983: Fnd_file.put(fnd_file.log,'Column name:');
1984: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1985: Fnd_file.put(fnd_file.log,'Error Message:');
1986: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1979: l_header_error := TRUE;
1980:
1981: -- Display the message
1982: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1983: Fnd_file.put(fnd_file.log,'Column name:');
1984: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1985: Fnd_file.put(fnd_file.log,'Error Message:');
1986: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1987:
1980:
1981: -- Display the message
1982: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1983: Fnd_file.put(fnd_file.log,'Column name:');
1984: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1985: Fnd_file.put(fnd_file.log,'Error Message:');
1986: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1987:
1988: End if;
1981: -- Display the message
1982: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1983: Fnd_file.put(fnd_file.log,'Column name:');
1984: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1985: Fnd_file.put(fnd_file.log,'Error Message:');
1986: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1987:
1988: End if;
1989: End Loop;
1982: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
1983: Fnd_file.put(fnd_file.log,'Column name:');
1984: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
1985: Fnd_file.put(fnd_file.log,'Error Message:');
1986: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
1987:
1988: End if;
1989: End Loop;
1990:
2040: l_unit_of_measure,l_inventory_item_id,l_order_header_id,
2041: l_order_line_id,l_order_number,l_serial_number,l_item_name,l_item_revision,l_lot_number;
2042: Close c_ro_prodtxn;
2043:
2044: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
2045: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
2046: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
2047: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
2048: Fnd_file.put(fnd_file.log,'Column name:');
2041: l_order_line_id,l_order_number,l_serial_number,l_item_name,l_item_revision,l_lot_number;
2042: Close c_ro_prodtxn;
2043:
2044: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
2045: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
2046: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
2047: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
2048: Fnd_file.put(fnd_file.log,'Column name:');
2049: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
2042: Close c_ro_prodtxn;
2043:
2044: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
2045: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
2046: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
2047: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
2048: Fnd_file.put(fnd_file.log,'Column name:');
2049: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
2050: Fnd_file.put(fnd_file.log,'Error Message:');
2043:
2044: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
2045: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
2046: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
2047: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
2048: Fnd_file.put(fnd_file.log,'Column name:');
2049: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
2050: Fnd_file.put(fnd_file.log,'Error Message:');
2051: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
2044: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
2045: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
2046: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
2047: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
2048: Fnd_file.put(fnd_file.log,'Column name:');
2049: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
2050: Fnd_file.put(fnd_file.log,'Error Message:');
2051: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
2052:
2045: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
2046: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
2047: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
2048: Fnd_file.put(fnd_file.log,'Column name:');
2049: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
2050: Fnd_file.put(fnd_file.log,'Error Message:');
2051: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
2052:
2053: End If;
2046: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
2047: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
2048: Fnd_file.put(fnd_file.log,'Column name:');
2049: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
2050: Fnd_file.put(fnd_file.log,'Error Message:');
2051: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
2052:
2053: End If;
2054:
2047: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
2048: Fnd_file.put(fnd_file.log,'Column name:');
2049: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
2050: Fnd_file.put(fnd_file.log,'Error Message:');
2051: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
2052:
2053: End If;
2054:
2055: End Loop;
2089:
2090: -- fix for bug 5227347
2091: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
2092:
2093: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
2094: csd_bulk_receive_util.write_to_conc_log
2095: ( p_msg_count => l_msg_count,
2096: p_msg_data => l_msg_data);
2097:
2166:
2167: -- fix for bug 5227347
2168: If NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) then
2169:
2170: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
2171: csd_bulk_receive_util.write_to_conc_log
2172: ( p_msg_count => l_msg_count,
2173: p_msg_data => l_msg_data);
2174:
2260: If p_msg_count = 1 then
2261:
2262: l_msg := fnd_msg_pub.get(p_msg_index => 1,
2263: p_encoded => 'F' );
2264: Fnd_file.put_line(fnd_file.log,l_msg);
2265:
2266: Elsif p_msg_count > 1 then
2267:
2268: For i in 1..p_msg_count
2269:
2270: Loop
2271: l_msg := fnd_msg_pub.get(p_msg_index => i,
2272: p_encoded => 'F' );
2273: Fnd_file.put_line(fnd_file.log,l_msg);
2274: End loop;
2275:
2276: End If;
2277:
2364:
2365: fnd_message.set_name('CSD','CSD_BULK_RCV_STATUS_CONC_LABEL');
2366: l_status_label := fnd_message.get;
2367:
2368: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
2369: Fnd_file.put_line(fnd_file.output,'');
2370: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
2371: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
2372: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
2365: fnd_message.set_name('CSD','CSD_BULK_RCV_STATUS_CONC_LABEL');
2366: l_status_label := fnd_message.get;
2367:
2368: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
2369: Fnd_file.put_line(fnd_file.output,'');
2370: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
2371: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
2372: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
2373: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
2366: l_status_label := fnd_message.get;
2367:
2368: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
2369: Fnd_file.put_line(fnd_file.output,'');
2370: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
2371: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
2372: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
2373: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
2374: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
2367:
2368: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
2369: Fnd_file.put_line(fnd_file.output,'');
2370: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
2371: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
2372: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
2373: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
2374: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
2375: -- 12.1.2 changes, subhat.
2368: Fnd_file.put_line(fnd_file.output,rtrim(l_txn_label)||' : '||p_transaction_number);
2369: Fnd_file.put_line(fnd_file.output,'');
2370: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
2371: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
2372: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
2373: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
2374: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
2375: -- 12.1.2 changes, subhat.
2376: fnd_file.put(fnd_file.output,rpad('Unplanned Receipt',22,' ') );
2369: Fnd_file.put_line(fnd_file.output,'');
2370: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
2371: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
2372: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
2373: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
2374: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
2375: -- 12.1.2 changes, subhat.
2376: fnd_file.put(fnd_file.output,rpad('Unplanned Receipt',22,' ') );
2377: fnd_file.put(fnd_file.output,rpad('Over Receipt', 15, ' '));
2370: Fnd_file.put(fnd_file.output,rpad(rtrim(l_serial_label),18,' '));
2371: Fnd_file.put(fnd_file.output,rpad(rtrim(l_item_label),14,' '));
2372: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
2373: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
2374: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
2375: -- 12.1.2 changes, subhat.
2376: fnd_file.put(fnd_file.output,rpad('Unplanned Receipt',22,' ') );
2377: fnd_file.put(fnd_file.output,rpad('Over Receipt', 15, ' '));
2378: fnd_file.put(fnd_file.output,rpad('Under Receipt', 15, ' '));
2372: Fnd_file.put(fnd_file.output,rpad(rtrim(l_qty_label),13,' '));
2373: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
2374: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
2375: -- 12.1.2 changes, subhat.
2376: fnd_file.put(fnd_file.output,rpad('Unplanned Receipt',22,' ') );
2377: fnd_file.put(fnd_file.output,rpad('Over Receipt', 15, ' '));
2378: fnd_file.put(fnd_file.output,rpad('Under Receipt', 15, ' '));
2379: -- end 12.1.2 changes subhat
2380: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
2373: Fnd_file.put(fnd_file.output,rpad(rtrim(l_sr_label),25,' '));
2374: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
2375: -- 12.1.2 changes, subhat.
2376: fnd_file.put(fnd_file.output,rpad('Unplanned Receipt',22,' ') );
2377: fnd_file.put(fnd_file.output,rpad('Over Receipt', 15, ' '));
2378: fnd_file.put(fnd_file.output,rpad('Under Receipt', 15, ' '));
2379: -- end 12.1.2 changes subhat
2380: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
2381: --Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
2374: Fnd_file.put(fnd_file.output,rpad(rtrim(l_ro_label),25,' '));
2375: -- 12.1.2 changes, subhat.
2376: fnd_file.put(fnd_file.output,rpad('Unplanned Receipt',22,' ') );
2377: fnd_file.put(fnd_file.output,rpad('Over Receipt', 15, ' '));
2378: fnd_file.put(fnd_file.output,rpad('Under Receipt', 15, ' '));
2379: -- end 12.1.2 changes subhat
2380: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
2381: --Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
2382: Fnd_file.put_line(fnd_file.output,rpad('-',170,'-'));
2376: fnd_file.put(fnd_file.output,rpad('Unplanned Receipt',22,' ') );
2377: fnd_file.put(fnd_file.output,rpad('Over Receipt', 15, ' '));
2378: fnd_file.put(fnd_file.output,rpad('Under Receipt', 15, ' '));
2379: -- end 12.1.2 changes subhat
2380: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
2381: --Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
2382: Fnd_file.put_line(fnd_file.output,rpad('-',170,'-'));
2383:
2384:
2377: fnd_file.put(fnd_file.output,rpad('Over Receipt', 15, ' '));
2378: fnd_file.put(fnd_file.output,rpad('Under Receipt', 15, ' '));
2379: -- end 12.1.2 changes subhat
2380: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
2381: --Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
2382: Fnd_file.put_line(fnd_file.output,rpad('-',170,'-'));
2383:
2384:
2385: For c_get_bulk_receive_rec in c_get_bulk_receive( p_transaction_number)
2378: fnd_file.put(fnd_file.output,rpad('Under Receipt', 15, ' '));
2379: -- end 12.1.2 changes subhat
2380: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status_label),28,' '));
2381: --Fnd_file.put_line(fnd_file.output,rpad('-',110,'-'));
2382: Fnd_file.put_line(fnd_file.output,rpad('-',170,'-'));
2383:
2384:
2385: For c_get_bulk_receive_rec in c_get_bulk_receive( p_transaction_number)
2386: Loop
2403: Fetch c_get_item_desc into l_item_desc;
2404: Close c_get_item_desc;
2405:
2406:
2407: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
2408: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
2409: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
2410: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
2411: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
2404: Close c_get_item_desc;
2405:
2406:
2407: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
2408: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
2409: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
2410: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
2411: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
2412:
2405:
2406:
2407: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
2408: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
2409: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
2410: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
2411: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
2412:
2413: --12.1.2 changes, subhat.
2406:
2407: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
2408: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
2409: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
2410: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
2411: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
2412:
2413: --12.1.2 changes, subhat.
2414: if nvl(c_get_bulk_receive_rec.unplanned_receipt_flag,'N') = 'Y' then
2407: Fnd_file.put(fnd_file.output,rpad(nvl(c_get_bulk_receive_rec.serial_number,' '),18));
2408: Fnd_file.put(fnd_file.output,rpad(nvl(l_item_desc,' '),14,' '));
2409: Fnd_file.put(fnd_file.output,rpad(nvl(to_char(c_get_bulk_receive_rec.quantity),' '),13,' '));
2410: Fnd_file.put(fnd_file.output,rpad(nvl(l_incident_number,' '),25,' '));
2411: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
2412:
2413: --12.1.2 changes, subhat.
2414: if nvl(c_get_bulk_receive_rec.unplanned_receipt_flag,'N') = 'Y' then
2415: Fnd_file.put(fnd_file.output,rpad('Yes',22,' '));
2411: Fnd_file.put(fnd_file.output,rpad(nvl(l_repair_number,' '),25,' '));
2412:
2413: --12.1.2 changes, subhat.
2414: if nvl(c_get_bulk_receive_rec.unplanned_receipt_flag,'N') = 'Y' then
2415: Fnd_file.put(fnd_file.output,rpad('Yes',22,' '));
2416: else
2417: Fnd_file.put(fnd_file.output,rpad('No',22,' '));
2418: end if;
2419:
2413: --12.1.2 changes, subhat.
2414: if nvl(c_get_bulk_receive_rec.unplanned_receipt_flag,'N') = 'Y' then
2415: Fnd_file.put(fnd_file.output,rpad('Yes',22,' '));
2416: else
2417: Fnd_file.put(fnd_file.output,rpad('No',22,' '));
2418: end if;
2419:
2420: if nvl(c_get_bulk_receive_rec.over_receipt_flag,'N') = 'Y' then
2421: Fnd_file.put(fnd_file.output,rpad('Yes',15,' '));
2417: Fnd_file.put(fnd_file.output,rpad('No',22,' '));
2418: end if;
2419:
2420: if nvl(c_get_bulk_receive_rec.over_receipt_flag,'N') = 'Y' then
2421: Fnd_file.put(fnd_file.output,rpad('Yes',15,' '));
2422: else
2423: Fnd_file.put(fnd_file.output,rpad('No',15,' '));
2424: end if;
2425:
2419:
2420: if nvl(c_get_bulk_receive_rec.over_receipt_flag,'N') = 'Y' then
2421: Fnd_file.put(fnd_file.output,rpad('Yes',15,' '));
2422: else
2423: Fnd_file.put(fnd_file.output,rpad('No',15,' '));
2424: end if;
2425:
2426: if nvl(c_get_bulk_receive_rec.under_receipt_flag,'N') = 'Y' then
2427: Fnd_file.put(fnd_file.output,rpad('Yes',15,' '));
2423: Fnd_file.put(fnd_file.output,rpad('No',15,' '));
2424: end if;
2425:
2426: if nvl(c_get_bulk_receive_rec.under_receipt_flag,'N') = 'Y' then
2427: Fnd_file.put(fnd_file.output,rpad('Yes',15,' '));
2428: else
2429: Fnd_file.put(fnd_file.output,rpad('No',15,' '));
2430: end if;
2431: If ( c_get_bulk_receive_rec.status = 'ERRORED' ) then
2425:
2426: if nvl(c_get_bulk_receive_rec.under_receipt_flag,'N') = 'Y' then
2427: Fnd_file.put(fnd_file.output,rpad('Yes',15,' '));
2428: else
2429: Fnd_file.put(fnd_file.output,rpad('No',15,' '));
2430: end if;
2431: If ( c_get_bulk_receive_rec.status = 'ERRORED' ) then
2432:
2433: fnd_message.set_name('CSD','CSD_BULK_RCV_ERROR_STATUS');
2452: l_status := fnd_message.get;
2453:
2454: End if;
2455:
2456: Fnd_file.put_line(fnd_file.output,rpad(rtrim(l_status),28,' '));
2457:
2458: End Loop;
2459:
2460: If (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) then
3628:
3629: l_header_error := TRUE;
3630:
3631: -- Display the message
3632: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
3633: Fnd_file.put(fnd_file.log,'Column name:');
3634: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3635: Fnd_file.put(fnd_file.log,'Error Message:');
3636: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
3629: l_header_error := TRUE;
3630:
3631: -- Display the message
3632: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
3633: Fnd_file.put(fnd_file.log,'Column name:');
3634: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3635: Fnd_file.put(fnd_file.log,'Error Message:');
3636: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
3637:
3630:
3631: -- Display the message
3632: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
3633: Fnd_file.put(fnd_file.log,'Column name:');
3634: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3635: Fnd_file.put(fnd_file.log,'Error Message:');
3636: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
3637:
3638: End if;
3631: -- Display the message
3632: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
3633: Fnd_file.put(fnd_file.log,'Column name:');
3634: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3635: Fnd_file.put(fnd_file.log,'Error Message:');
3636: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
3637:
3638: End if;
3639: End Loop;
3632: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Header');
3633: Fnd_file.put(fnd_file.log,'Column name:');
3634: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3635: Fnd_file.put(fnd_file.log,'Error Message:');
3636: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message);
3637:
3638: End if;
3639: End Loop;
3640:
3690: l_unit_of_measure,l_inventory_item_id,l_order_header_id,
3691: l_order_line_id,l_order_number,l_serial_number,l_item_name,l_item_revision,l_lot_number;
3692: Close c_ro_prodtxn;
3693:
3694: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
3695: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
3696: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
3697: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
3698: Fnd_file.put(fnd_file.log,'Column name:');
3691: l_order_line_id,l_order_number,l_serial_number,l_item_name,l_item_revision,l_lot_number;
3692: Close c_ro_prodtxn;
3693:
3694: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
3695: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
3696: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
3697: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
3698: Fnd_file.put(fnd_file.log,'Column name:');
3699: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3692: Close c_ro_prodtxn;
3693:
3694: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
3695: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
3696: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
3697: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
3698: Fnd_file.put(fnd_file.log,'Column name:');
3699: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3700: Fnd_file.put(fnd_file.log,'Error Message:');
3693:
3694: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
3695: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
3696: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
3697: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
3698: Fnd_file.put(fnd_file.log,'Column name:');
3699: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3700: Fnd_file.put(fnd_file.log,'Error Message:');
3701: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message); */
3694: Fnd_file.put_line(fnd_file.log,'Error:Auto Receive failed - Line');
3695: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
3696: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
3697: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
3698: Fnd_file.put(fnd_file.log,'Column name:');
3699: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3700: Fnd_file.put(fnd_file.log,'Error Message:');
3701: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message); */
3702:
3695: Fnd_file.put(fnd_file.log,'Serial Number :'||l_serial_number||',');
3696: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
3697: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
3698: Fnd_file.put(fnd_file.log,'Column name:');
3699: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3700: Fnd_file.put(fnd_file.log,'Error Message:');
3701: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message); */
3702:
3703: End If;
3696: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_name||',');
3697: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
3698: Fnd_file.put(fnd_file.log,'Column name:');
3699: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3700: Fnd_file.put(fnd_file.log,'Error Message:');
3701: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message); */
3702:
3703: End If;
3704:
3697: Fnd_file.put_line(fnd_file.log,'Qty :'||l_estimate_quantity);
3698: Fnd_file.put(fnd_file.log,'Column name:');
3699: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).column_name);
3700: Fnd_file.put(fnd_file.log,'Error Message:');
3701: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message); */
3702:
3703: End If;
3704:
3705: End Loop;
3755: lc_api_name,
3756: 'Error in CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE: Return status '||l_return_status);
3757: End if;
3758:
3759: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
3760: csd_bulk_receive_util.write_to_conc_log
3761: ( p_msg_count => l_msg_count,
3762: p_msg_data => l_msg_data);
3763:
3817: lc_api_name,
3818: 'Error in CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE: Return status '||l_return_status);
3819: End if;
3820:
3821: Fnd_file.put_line(fnd_file.log,'Error : CSD_UPDATE_PROGRAMS_PVT.RECEIPTS_UPDATE failed');
3822: csd_bulk_receive_util.write_to_conc_log
3823: ( p_msg_count => l_msg_count,
3824: p_msg_data => l_msg_data);
3825: