[Home] [Help]
1: PACKAGE BODY INV_RCV_STD_TRANSFER_APIS AS
2: /* $Header: INVSTDTB.pls 120.11 2006/11/22 05:40:13 anviswan ship $ */
3:
4: --Transaction UOM Code in RTI. Need this because the rcv_transactions
5: --record type does not store the uom_code
4: --Transaction UOM Code in RTI. Need this because the rcv_transactions
5: --record type does not store the uom_code
6: g_transfer_uom_code MTL_ITEM_UOMS_VIEW.UOM_CODE%TYPE;
7:
8: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_RCV_STD_TRANSFER_APIS';
9:
10: /* Debugging utility*/
11: PROCEDURE print_debug (
12: p_err_msg VARCHAR2
399: EXCEPTION
400: WHEN OTHERS THEN
401: IF SQLCODE IS NOT NULL THEN
402: inv_mobile_helper_functions.sql_error (
403: 'INV_RCV_STD_TRANSFER_APIS.INSERT_INTERFACE_CODE', 10, SQLCODE);
404: END IF;
405: RETURN -9999;
406: END insert_interface_code;
407:
766: , p_count => x_msg_count
767: , p_data => x_msg_data );
768: IF SQLCODE IS NOT NULL THEN
769: inv_mobile_helper_functions.sql_error (
770: 'INV_RCV_STD_TRANSFER_APIS.POPULATE_TRANSFER_RTI_VALUES',
771: l_progress,
772: SQLCODE);
773: END IF;
774: END populate_transfer_rti_values;
1027: , p_count => x_msg_count
1028: , p_data => x_msg_data );
1029: IF SQLCODE IS NOT NULL THEN
1030: inv_mobile_helper_functions.sql_error (
1031: 'INV_RCV_STD_TRANSFER_APIS.GET_AVAIL_QTY_TO_TRANSFER',
1032: l_progress,
1033: SQLCODE);
1034: END IF;
1035: END get_avail_quantity_to_transfer;
1467: , p_count => x_msg_count
1468: , p_data => x_msg_data );
1469: IF SQLCODE IS NOT NULL THEN
1470: inv_mobile_helper_functions.sql_error (
1471: 'INV_RCV_STD_TRANSFER_APIS.CREATE_PO_TRANSFER_REC',
1472: l_progress,
1473: SQLCODE);
1474: END IF;
1475: END create_po_transfer_rec;
1883: , p_count => x_msg_count
1884: , p_data => x_msg_data );
1885: IF SQLCODE IS NOT NULL THEN
1886: inv_mobile_helper_functions.sql_error (
1887: 'INV_RCV_STD_TRANSFER_APIS.CREATE_INT_SHIP_TRANSFER_REC',
1888: l_progress,
1889: SQLCODE);
1890: END IF;
1891: END create_int_ship_transfer_rec;
2302: , p_count => x_msg_count
2303: , p_data => x_msg_data );
2304: IF SQLCODE IS NOT NULL THEN
2305: inv_mobile_helper_functions.sql_error (
2306: 'INV_RCV_STD_TRANSFER_APIS.CREATE_RMA_TRANSFER_REC',
2307: l_progress,
2308: SQLCODE);
2309: END IF;
2310: END create_rma_transfer_rec;
2749: , p_count => x_msg_count
2750: , p_data => x_msg_data );
2751: IF SQLCODE IS NOT NULL THEN
2752: inv_mobile_helper_functions.sql_error (
2753: 'INV_RCV_STD_TRANSFER_APIS.CREATE_TRANSFER_RCVTXN_REC',
2754: l_progress,
2755: SQLCODE);
2756: END IF;
2757: END create_transfer_rcvtxn_rec;
3478: print_debug('SECONDARY UOM CODE = '|| p_sec_transfer_uom_code , 1);
3479: print_debug('SECONDARY QTY = '|| l_secondary_quantity, 1);
3480: END IF;
3481:
3482: inv_rcv_std_transfer_apis.create_transfer_rcvtxn_rec(
3483: x_return_status => l_return_status
3484: , x_msg_count => l_msg_count
3485: , x_msg_data => l_msg_data
3486: , p_organization_id => p_organization_id
3845: IF (l_debug = 1) THEN
3846: print_debug('BEFORE CALLING THE TRANSFER API ', 1);
3847: END IF;
3848:
3849: inv_rcv_std_transfer_apis.create_transfer_rcvtxn_rec
3850: (x_return_status => l_return_status
3851: , x_msg_count => l_msg_count
3852: , x_msg_data => l_msg_data
3853: , p_organization_id => p_organization_id
3920: , p_count => x_msg_count
3921: , p_data => x_msg_data );
3922: IF SQLCODE IS NOT NULL THEN
3923: inv_mobile_helper_functions.sql_error (
3924: 'INV_RCV_STD_TRANSFER_APIS.MATCH_TRANSFER_RCVTXN_REC',
3925: l_progress,
3926: SQLCODE);
3927: END IF;
3928: END Match_transfer_rcvtxn_rec;
3926: SQLCODE);
3927: END IF;
3928: END Match_transfer_rcvtxn_rec;
3929:
3930: END INV_RCV_STD_TRANSFER_APIS;
3931: