APPS.INV_ITEM_GRP dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 747: /* Need to get Item ID from MTL_SYSTEM_ITEMS_INTERFACE since ITEM_NUMBER

743: l_IOI_run_mode := 1;
744: ELSIF ( p_transaction_type = 'UPDATE' ) then
745: l_IOI_run_mode := 2;
746:
747: /* Need to get Item ID from MTL_SYSTEM_ITEMS_INTERFACE since ITEM_NUMBER
748: could be passed with item record to Update_Item
749: --
750: -- Use passed record item id to retrieve updated item
751: --

Line 790: x_Error_tbl(1).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';

786:
787: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
788: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
789: x_Error_tbl(1).UNIQUE_ID := 1;
790: x_Error_tbl(1).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
791: x_Error_tbl(1).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);
792: RETURN;
793: END IF;
794:

Line 870: MTL_SYSTEM_ITEMS_INTERFACE

866: , l_transaction_id
867: , l_inventory_item_id
868: , l_organization_id
869: FROM
870: MTL_SYSTEM_ITEMS_INTERFACE
871: WHERE
872: set_process_id = l_set_process_id;
873:
874: IF l_inv_debug_level IN(101, 102) THEN

Line 910: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';

906: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
907: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
908: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
909: x_Error_tbl(l_idx).UNIQUE_ID := 999;
910: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
911: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);
912: END IF;
913:
914: -- Do not insert message, if IOI is success.

Line 919: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';

915: --
916: /*
917: l_idx := 1;
918: x_Error_tbl(l_idx).UNIQUE_ID := 0;
919: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
920: x_Error_tbl(l_idx).MESSAGE_TEXT :=
921: 'Create_Item success. IOI tnx_id=' || to_char(l_transaction_id) ||
922: ' inventory_item_id=' || to_char(l_inventory_item_id);
923: */

Line 965: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';

961: IF ( l_return_code <> 0
962: AND l_idx = NVL( x_Error_tbl.COUNT, 0) ) THEN
963: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
964: x_Error_tbl(l_idx).UNIQUE_ID := 1;
965: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
966: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('Error during IOI run.'
967: || ' Process_flag=' || to_char(l_process_flag)
968: || ' Return_code=' || to_char(l_return_code)
969: || ' Unexpexted error: ' || l_err_text,1,239);

Line 989: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';

985: IF ( l_return_code <> 0 ) THEN
986: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
987: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
988: x_Error_tbl(l_idx).UNIQUE_ID := 999;
989: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
990: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_err_text,1,239);
991: END IF;
992: ----------------------------------------------------------
993: -- Control the API commit through the IOI

Line 3426: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE(

3422: END IF;
3423:
3424: -- Insert item row into MSII for further processing by IOI.
3425:
3426: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE(
3427: process_flag
3428: ,set_process_id
3429: ,transaction_type
3430: ,ORGANIZATION_ID