APPS.ONT_ITM_PKG dependencies on WSH_ITM_ITEMS

Line 1047: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;

1043: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1047: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1049: END IF;
1050:
1051: -- BUG 5408161

Line 1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;

1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1047: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1049: END IF;
1050:
1051: -- BUG 5408161
1052: -- Retrieve concatenated_segments ('ProductCode' in WSH_ITM_ITEMS table)

Line 1052: -- Retrieve concatenated_segments ('ProductCode' in WSH_ITM_ITEMS table)

1048: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1049: END IF;
1050:
1051: -- BUG 5408161
1052: -- Retrieve concatenated_segments ('ProductCode' in WSH_ITM_ITEMS table)
1053: SELECT concatenated_segments into l_product_code
1054: FROM mtl_system_items_vl
1055: WHERE inventory_item_id = p_line_rec.inventory_item_id
1056: AND organization_id = p_line_rec.ship_from_org_id; --l_organization_code ;

Line 1076: INSERT INTO WSH_ITM_ITEMS (

1072: WHEN OTHERS THEN
1073: l_Item_type := null;
1074: END;
1075:
1076: INSERT INTO WSH_ITM_ITEMS (
1077: ITEM_ID,
1078: REQUEST_CONTROL_ID,
1079: INVENTORY_ITEM_ID,
1080: ORGANIZATION_CODE,

Line 1091: wsh_itm_items_s.NEXTVAL,

1087: LAST_UPDATE_DATE,
1088: LAST_UPDATE_LOGIN
1089: )
1090: VALUES (
1091: wsh_itm_items_s.NEXTVAL,
1092: l_request_control_id,
1093: p_line_rec.inventory_item_id,
1094: l_organization_code,
1095: p_line_rec.org_id,

Line 1106: oe_debug_pub.add('Inserted record in to wsh_itm_items...' , 1 ) ;

1102: FND_GLOBAL.USER_ID
1103: );
1104:
1105: IF l_debug_level > 0 THEN
1106: oe_debug_pub.add('Inserted record in to wsh_itm_items...' , 1 ) ;
1107: END IF;
1108:
1109: END IF;
1110: