[Home] [Help]
6:
7: g_pkg_name VARCHAR2(30) := 'INV_RCV_STD_DELIVER_APIS';
8:
9: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
10: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
11: BEGIN
12: IF (l_debug = 1) THEN
13: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg
14: , p_module => g_pkg_name||'($Revision: 120.29.12020000.3 $)'
120: l_transfer_cost_group_id NUMBER := l_rcv_transaction_rec.transfer_cost_group_id;
121: l_project_id NUMBER := NULL;
122: l_task_id NUMBER := NULL;
123:
124: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
125: l_validation_flag VARCHAR2(1);
126: l_lpn_group_id NUMBER;
127:
128: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
551: , p_lot_control_code IN NUMBER
552: , p_serial_control_code IN NUMBER
553: , p_interface_transaction_id IN NUMBER
554: ) IS
555: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
556: BEGIN
557: IF (l_debug = 1) THEN
558: print_debug('entering insert_lot_serial 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
559: END IF;
794: l_po_operation_seq_num NUMBER;
795: l_po_resource_seq_num NUMBER;
796: l_content_lpn_id NUMBER;
797: l_lpn_controlled_flag NUMBER;
798: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
799: l_subinventory_type NUMBER;
800: l_tmp_destination_code VARCHAR2(80);
801: l_asn_line_flag VARCHAR2(3);
802: l_is_expense VARCHAR2(1);
1668: AND msi.organization_id = rsup.to_organization_id
1669: AND msi.inventory_item_id = rsup.item_id
1670: ORDER BY rt.transaction_date DESC;
1671:
1672: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1673: BEGIN
1674: x_status := fnd_api.g_ret_sts_success;
1675:
1676: IF (l_debug = 1) THEN
2157: --END BUG 4500676
2158:
2159:
2160:
2161: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2162: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2163: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2164: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2165: l_prim_uom_code VARCHAR2(3);
2830: AND msi.organization_id = rsup.to_organization_id
2831: AND msi.inventory_item_id = rsup.item_id
2832: ORDER BY rt.transaction_date DESC;
2833:
2834: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2835: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2836: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2837: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2838: l_msni_count NUMBER := 0;
3561: AND msi.organization_id = rsup.to_organization_id
3562: AND msi.inventory_item_id = rsup.item_id
3563: ORDER BY rt.transaction_date DESC;
3564:
3565: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3566: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3567: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3568: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3569: l_prim_uom_code VARCHAR2(3);
4030: AND rsup.item_id = p_item_id
4031: AND Nvl(rsup.ITEM_REVISION, '@@##') = Nvl(p_revision, '@@##'); /* Bug 13598673 to pick right po_header_id*/
4032:
4033:
4034: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4035: BEGIN
4036: x_status := fnd_api.g_ret_sts_success;
4037: l_progress := '10';
4038:
4270: FROM rcv_transactions_interface rti
4271: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4272: GROUP BY rti.lpn_id;
4273:
4274: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4275: BEGIN
4276: x_status := fnd_api.g_ret_sts_success;
4277: l_progress := '10';
4278:
4465: FROM rcv_transactions_interface rti
4466: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4467: GROUP BY rti.lpn_id;
4468:
4469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4470: BEGIN
4471: x_status := fnd_api.g_ret_sts_success;
4472: l_progress := '10';
4473:
4847: SELECT DISTINCT rti.interface_transaction_id
4848: FROM rcv_transactions_interface rti
4849: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4850:
4851: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4852: BEGIN
4853: x_return_status := fnd_api.g_ret_sts_success;
4854: l_progress := '10';
4855:
5204: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5205: END create_putaway_rcvtxn_intf_rec;
5206:
5207: PROCEDURE rcvtxn_clear_global IS
5208: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5209: BEGIN
5210: g_rcvtxn_detail_index := 1;
5211: inv_rcv_common_apis.g_po_startup_value := NULL;
5212: inv_rcv_common_apis.g_rcv_global_var := NULL;
5220: , p_shipment_line_id IN NUMBER
5221: ) IS
5222: l_progress VARCHAR2(10);
5223: l_serial_number VARCHAR2(30);
5224: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5225: BEGIN
5226: x_return_status := fnd_api.g_ret_sts_success;
5227:
5228: IF (l_debug = 1) THEN
5301: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5302: l_return_status VARCHAR2(1);
5303: l_msg_count NUMBER;
5304: l_msg_data VARCHAR2(10000);
5305: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5306: BEGIN
5307: --Get the required columns from MLN first
5308: SELECT expiration_date
5309: , status_id
5386: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5387: l_return_status VARCHAR2(1);
5388: l_msg_count NUMBER;
5389: l_msg_data VARCHAR2(10000);
5390: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5391: BEGIN
5392:
5393: --Get the serial status
5394: SELECT status_id
5568: --Bug 5331779-End change
5569: ORDER BY ORDERING1, ORDERING2
5570: ;
5571:
5572: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5573: l_remaining_qty NUMBER;
5574: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
5575: l_from_sub VARCHAR2(30);
5576: l_from_locator_id NUMBER;