APPS.CLN_SYNC_ITEM_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 1744: cln_debug_pub.Add('Obtaining the inventory item id from the mtl_system_items_b table', 1);

1740: cln_debug_pub.Add('Item Number '||l_item_number, 1);
1741: END IF;
1742:
1743: IF (l_Debug_Level <= 1) THEN
1744: cln_debug_pub.Add('Obtaining the inventory item id from the mtl_system_items_b table', 1);
1745: END IF;
1746:
1747: BEGIN
1748: SELECT inventory_item_id

Line 1750: FROM mtl_system_items_b

1746:
1747: BEGIN
1748: SELECT inventory_item_id
1749: INTO l_inventory_item_id
1750: FROM mtl_system_items_b
1751: WHERE SEGMENT1 = l_item_number AND organization_id = l_master_organization_id;
1752:
1753: IF (l_Debug_Level <= 1) THEN
1754: cln_debug_pub.Add('Inventory Item ID for the item number : '||l_item_number||' is = '||l_inventory_item_id, 1);

Line 1759: cln_debug_pub.Add('ERROR : Could not find the record in the mtl_system_items_b table for the item number -'||l_item_number, 1);

1755: END IF;
1756:
1757: EXCEPTION
1758: WHEN NO_DATA_FOUND THEN
1759: cln_debug_pub.Add('ERROR : Could not find the record in the mtl_system_items_b table for the item number -'||l_item_number, 1);
1760: RAISE FND_API.G_EXC_ERROR;
1761: END;
1762:
1763: UPDATE CLN_CST_DTLS_TEMP