[Home] [Help]
1522:
1523: BEGIN
1524: SELECT GRADE_CONTROL_FLAG
1525: INTO l_grade_controlled_flag
1526: FROM mtl_system_items_b
1527: WHERE INVENTORY_ITEM_ID = p_item_id
1528: AND ORGANIZATION_ID = p_to_organization_id;
1529:
1530: IF g_debug = 1 THEN
1941: FROM MTL_UNITS_OF_MEASURE
1942: WHERE unit_of_measure = p_secondary_unit_of_measure;
1943:
1944: /*Check whether the unit of measure conversion is not fixed in the destination org.
1945: Fetch the SECONDARY_DEFAULT_IND from mtl_system_items_b. */
1946:
1947: SELECT secondary_default_ind
1948: INTO l_secondary_default_ind
1949: FROM mtl_system_items_b
1945: Fetch the SECONDARY_DEFAULT_IND from mtl_system_items_b. */
1946:
1947: SELECT secondary_default_ind
1948: INTO l_secondary_default_ind
1949: FROM mtl_system_items_b
1950: WHERE inventory_item_id =p_item_id
1951: AND organization_id =p_to_organization_id;
1952:
1953: /* The values are D => default
1957: l_progress :='033';
1958:
1959: IF g_debug = 1 THEN
1960: print_debug('uom classes for primary and secondary unit_of_measures
1961: and SECONDARY_DEFAULT_IND from mtl_system_items_b are:'|| l_primary_uom_class ||':'||l_secondary_uom_class ||':'||l_secondary_default_ind ||':'||l_progress, 1);
1962: END IF;
1963:
1964: /* Check whether UOM class are different and the dual uom is not of fixed type. */
1965: IF (l_primary_uom_class <> l_secondary_uom_class) AND (l_secondary_default_ind <>'F') THEN
2847: print_debug('previously received quantity for the Lot is :' || l_lot_recv_qty||':'||l_progress, 1);
2848: END IF;
2849:
2850: --If lot was previously received then take that quantity also into account.
2851: -- fetch Primary unit_of_measure of previously received lot from item master (mtl_system_items_b.)
2852: l_progress := '068';
2853:
2854: BEGIN
2855: SELECT PRIMARY_UNIT_OF_MEASURE
2853:
2854: BEGIN
2855: SELECT PRIMARY_UNIT_OF_MEASURE
2856: INTO l_lot_recv_unit_of_measure
2857: FROM mtl_system_items_b
2858: WHERE INVENTORY_ITEM_ID = p_item_id
2859: AND organization_id = p_to_organization_id;
2860:
2861: EXCEPTION
3166: /* Cursor definition to check whether item is a valid and it's lot, child lot controlled */
3167: CURSOR c_chk_msi_attr IS
3168: SELECT lot_control_code,
3169: child_lot_flag
3170: FROM mtl_system_items
3171: WHERE inventory_item_id = p_inventory_item_id
3172: AND organization_id = p_organization_id;
3173:
3174: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;
3178: x_return_status := fnd_api.g_ret_sts_success;
3179:
3180: /******************* START Item validation ********************/
3181:
3182: /* Check item attributes in Mtl_system_items Table */
3183:
3184: OPEN c_chk_msi_attr ;
3185: FETCH c_chk_msi_attr INTO l_chk_msi_attr_rec;
3186: