DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on WSH_INTERFACE

Line 2487: l_shipping_attr wsh_interface.changedattributetabtype;

2483: l_mmtt_count NUMBER;
2484: l_reservation_id NUMBER;
2485: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
2486: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
2487: l_shipping_attr wsh_interface.changedattributetabtype;
2488: l_source_header_id NUMBER;
2489: l_source_line_id NUMBER;
2490: l_delivery_detail_id NUMBER;
2491: l_move_order_type NUMBER;

Line 4959: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);

4955: --Bug #3306493
4956: --Adjust_serial_numbers_in_MSNT(l_serial_transaction_temp_id,l_lot_primary_quantity);
4957: Adjust_serial_numbers_in_MSNT(l_serial_trx_temp_id,l_lot_primary_quantity);
4958: END IF;
4959: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);
4960: IF (l_debug = 1) THEN
4961: DEBUG('after update shipping attributes', 'Finalize_Pick_Confirm');
4962: END IF;
4963:

Line 5055: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);

5051: DEBUG('Picked qty2 : '|| l_shipping_attr(1).picked_quantity2, l_api_name);
5052: DEBUG('Ordered uom2: '|| l_shipping_attr(1).ordered_quantity_uom2, l_api_name);
5053: DEBUG('Pending qty : '|| l_shipping_attr(1).pending_quantity, 'Finalize_Pick_Confirm');
5054: END IF;
5055: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);
5056: IF (l_debug = 1) THEN
5057: DEBUG('after update shipping attributes', 'Finalize_Pick_Confirm');
5058: END IF;
5059:

Line 5193: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);

5189: DEBUG('For fulfillment base S since sec pending is 0 setting the l_shipping_attr(1).pending_quantity to '|| l_shipping_attr(1).pending_quantity, 'Finalize_Pick_Confirm');
5190: END IF;
5191: END IF;
5192:
5193: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);
5194: IF (l_debug = 1) THEN
5195: DEBUG('after update shipping attributes', 'Finalize_Pick_Confirm');
5196: END IF;
5197:

Line 5284: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);

5280: DEBUG('Picked qty2 : '|| l_shipping_attr(1).picked_quantity2, l_api_name);
5281: DEBUG('Ordered uom2: '|| l_shipping_attr(1).ordered_quantity_uom2, l_api_name);
5282: DEBUG('Pending qty : '|| l_shipping_attr(1).pending_quantity, 'Finalize_Pick_Confirm');
5283: END IF;
5284: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);
5285: IF (l_debug = 1) THEN
5286: DEBUG('after update shipping attributes', 'Finalize_Pick_Confirm');
5287: END IF;
5288:

Line 5438: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);

5434: DEBUG('Pending S qty : '|| l_shipping_attr(1).pending_quantity2, 'Finalize_Pick_Confirm');
5435: DEBUG('l_primary_pending_quantity :'|| l_primary_pending_quantity, 'Finalize_Pick_Confirm');
5436: DEBUG('l_sec_pending_quantity :'|| l_sec_pending_quantity, 'Finalize_Pick_Confirm');
5437: END IF;
5438: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);
5439: IF (l_debug = 1) THEN
5440: DEBUG('after update shipping attributes', 'Finalize_Pick_Confirm');
5441: END IF;
5442:

Line 5540: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);

5536: DEBUG('Pending S qty : '|| l_shipping_attr(1).pending_quantity2, 'Finalize_Pick_Confirm');
5537: DEBUG('l_primary_pending_quantity :'|| l_primary_pending_quantity, 'Finalize_Pick_Confirm');
5538: DEBUG('l_sec_pending_quantity :'|| l_sec_pending_quantity, 'Finalize_Pick_Confirm');
5539: END IF;
5540: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr, x_return_status => l_return_status);
5541: IF (l_debug = 1) THEN
5542: DEBUG('after update shipping attributes', 'Finalize_Pick_Confirm');
5543: END IF;
5544:

Line 6593: DEBUG('wsh_interface.update_shipping_attributes Raised an exception ', 'Finalize_Pick_Confirm');

6589: EXCEPTION
6590: --code added for bug#8530301
6591: WHEN exec_wsh_int_upd_SA THEN
6592: IF (l_debug = 1) THEN
6593: DEBUG('wsh_interface.update_shipping_attributes Raised an exception ', 'Finalize_Pick_Confirm');
6594: END IF;
6595: x_return_status := fnd_api.g_ret_sts_error;
6596: -- end of code added for bug#8530301
6597: WHEN fnd_api.g_exc_error THEN