DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on FND_FILE

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

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);

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

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:

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

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;

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

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;

Line 1986: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_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;
1990:

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

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:');

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

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);

Line 2046: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_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:');

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

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);

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

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:

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

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;

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

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:

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

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;

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

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:

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

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:

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

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

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

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:

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

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,' '));

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

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,' '));

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

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,' '));

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

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.

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

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,' ') );

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

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, ' '));

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

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, ' '));

Line 2376: fnd_file.put(fnd_file.output,rpad('Unplanned Receipt',22,' ') );

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,' '));

Line 2377: fnd_file.put(fnd_file.output,rpad('Over Receipt', 15, ' '));

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,'-'));

Line 2378: fnd_file.put(fnd_file.output,rpad('Under Receipt', 15, ' '));

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,'-'));

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

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:

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

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)

Line 2382: Fnd_file.put_line(fnd_file.output,rpad('-',170,'-'));

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

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

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,' '));

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

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:

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

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.

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

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

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

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,' '));

Line 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:

Line 2417: Fnd_file.put(fnd_file.output,rpad('No',22,' '));

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,' '));

Line 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:

Line 2423: Fnd_file.put(fnd_file.output,rpad('No',15,' '));

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,' '));

Line 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

Line 2429: Fnd_file.put(fnd_file.output,rpad('No',15,' '));

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');

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

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

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

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);

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

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:

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

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;

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

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;

Line 3636: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_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;
3640:

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

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:');

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

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);

Line 3696: Fnd_file.put(fnd_file.log,'Inventory Item :'||l_item_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:');

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

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); */

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

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:

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

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;

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

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:

Line 3701: Fnd_file.put_line(fnd_file.log,l_rcv_error_msg_tbl(i).error_message); */

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;

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

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:

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

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: