[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.17.12010000.4 $)'
118: l_transfer_cost_group_id NUMBER := l_rcv_transaction_rec.transfer_cost_group_id;
119: l_project_id NUMBER := NULL;
120: l_task_id NUMBER := NULL;
121:
122: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
123: l_validation_flag VARCHAR2(1);
124: l_lpn_group_id NUMBER;
125:
126: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
527: , p_lot_control_code IN NUMBER
528: , p_serial_control_code IN NUMBER
529: , p_interface_transaction_id IN NUMBER
530: ) IS
531: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
532: BEGIN
533: IF (l_debug = 1) THEN
534: print_debug('entering insert_lot_serial 10: ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
535: END IF;
770: l_po_operation_seq_num NUMBER;
771: l_po_resource_seq_num NUMBER;
772: l_content_lpn_id NUMBER;
773: l_lpn_controlled_flag NUMBER;
774: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
775: l_subinventory_type NUMBER;
776: l_tmp_destination_code VARCHAR2(80);
777: l_asn_line_flag VARCHAR2(3);
778: l_is_expense VARCHAR2(1);
1634: AND msi.organization_id = rsup.to_organization_id
1635: AND msi.inventory_item_id = rsup.item_id
1636: ORDER BY rt.transaction_date DESC;
1637:
1638: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1639: BEGIN
1640: x_status := fnd_api.g_ret_sts_success;
1641:
1642: IF (l_debug = 1) THEN
2123: --END BUG 4500676
2124:
2125:
2126:
2127: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2128: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2129: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2130: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2131: l_prim_uom_code VARCHAR2(3);
2796: AND msi.organization_id = rsup.to_organization_id
2797: AND msi.inventory_item_id = rsup.item_id
2798: ORDER BY rt.transaction_date DESC;
2799:
2800: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2801: --table to store all RTId, quantity and original_rti_id for lot/serial splits
2802: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
2803: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
2804: l_msni_count NUMBER := 0;
3465: AND msi.organization_id = rsup.to_organization_id
3466: AND msi.inventory_item_id = rsup.item_id
3467: ORDER BY rt.transaction_date DESC;
3468:
3469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3470: --table to store all RTId, quantity and original_rti_id for lot/serial splits
3471: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
3472: l_split_lot_serial_ok BOOLEAN; --Return status of lot_serial_split API
3473: l_prim_uom_code VARCHAR2(3);
3914: AND rsh.shipment_header_id = rsup.shipment_header_id
3915: AND rsup.to_organization_id = p_organization_id
3916: AND rsup.item_id = p_item_id;
3917:
3918: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
3919: BEGIN
3920: x_status := fnd_api.g_ret_sts_success;
3921: l_progress := '10';
3922:
4154: FROM rcv_transactions_interface rti
4155: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4156: GROUP BY rti.lpn_id;
4157:
4158: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4159: BEGIN
4160: x_status := fnd_api.g_ret_sts_success;
4161: l_progress := '10';
4162:
4349: FROM rcv_transactions_interface rti
4350: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
4351: GROUP BY rti.lpn_id;
4352:
4353: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4354: BEGIN
4355: x_status := fnd_api.g_ret_sts_success;
4356: l_progress := '10';
4357:
4729: SELECT DISTINCT rti.interface_transaction_id
4730: FROM rcv_transactions_interface rti
4731: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
4732:
4733: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4734: BEGIN
4735: x_return_status := fnd_api.g_ret_sts_success;
4736: l_progress := '10';
4737:
5082: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
5083: END create_putaway_rcvtxn_intf_rec;
5084:
5085: PROCEDURE rcvtxn_clear_global IS
5086: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5087: BEGIN
5088: g_rcvtxn_detail_index := 1;
5089: inv_rcv_common_apis.g_po_startup_value := NULL;
5090: inv_rcv_common_apis.g_rcv_global_var := NULL;
5098: , p_shipment_line_id IN NUMBER
5099: ) IS
5100: l_progress VARCHAR2(10);
5101: l_serial_number VARCHAR2(30);
5102: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5103: BEGIN
5104: x_return_status := fnd_api.g_ret_sts_success;
5105:
5106: IF (l_debug = 1) THEN
5179: l_prod_code VARCHAR2(5) := inv_rcv_integration_apis.G_PROD_CODE;
5180: l_return_status VARCHAR2(1);
5181: l_msg_count NUMBER;
5182: l_msg_data VARCHAR2(10000);
5183: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5184: BEGIN
5185: --Get the required columns from MLN first
5186: SELECT expiration_date
5187: , status_id
5264: l_false VARCHAR2(1) := inv_rcv_integration_apis.G_FALSE;
5265: l_return_status VARCHAR2(1);
5266: l_msg_count NUMBER;
5267: l_msg_data VARCHAR2(10000);
5268: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5269: BEGIN
5270:
5271: --Get the serial status
5272: SELECT status_id
5437: --Bug 5331779-End change
5438: ORDER BY ORDERING1, ORDERING2
5439: ;
5440:
5441: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
5442: l_remaining_qty NUMBER;
5443: l_new_rti_info inv_rcv_integration_apis.child_rec_tb_tp;
5444: l_from_sub VARCHAR2(30);
5445: l_from_locator_id NUMBER;