[Home] [Help]
2022: IF l_lot_number IS NOT NULL THEN --muom:sk
2023: IF l_fulfillment_base = 'S' THEN --{
2024:
2025: IF(p_lpn_match_lpn_id IS NOT NULL) THEN
2026: inv_quantity_tree_pub.query_quantities(
2027: p_api_version_number => 1.0
2028: , p_init_msg_lst => fnd_api.g_false
2029: , x_return_status => l_return_status
2030: , x_msg_count => l_msg_cnt
2030: , x_msg_count => l_msg_cnt
2031: , x_msg_data => l_msg_data
2032: , p_organization_id => p_organization_id
2033: , p_inventory_item_id => p_inventory_item_id
2034: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
2035: , p_is_revision_control => b_is_revision_control
2036: , p_is_lot_control => TRUE
2037: , p_is_serial_control => FALSE -- Dual UOM Items cannot be serial controlled and if fulfill base is 'S' item is dual UOM controlled always
2038: , p_demand_source_type_id => -9999
2055: , p_lpn_id => p_lpn_match_lpn_id
2056: , p_grade_code => NULL
2057: );
2058: ELSE
2059: inv_quantity_tree_pub.query_quantities(
2060: p_api_version_number => 1.0
2061: , p_init_msg_lst => fnd_api.g_false
2062: , x_return_status => l_return_status
2063: , x_msg_count => l_msg_cnt
2063: , x_msg_count => l_msg_cnt
2064: , x_msg_data => l_msg_data
2065: , p_organization_id => p_organization_id
2066: , p_inventory_item_id => p_inventory_item_id
2067: , p_tree_mode => inv_quantity_tree_pub.g_loose_only_mode
2068: , p_is_revision_control => b_is_revision_control
2069: , p_is_lot_control => TRUE
2070: , p_is_serial_control => FALSE -- Dual UOM Items cannot be serial controlled and if fulfill base is 'S' item is dual UOM controlled always
2071: , p_demand_source_type_id => -9999
2149: mydebug ('l_confirmed_prim_qty after adding qty for above lot is:' || l_confirmed_prim_qty);
2150:
2151: ELSE --Quantity tree errored out
2152: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2153: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2154: fnd_msg_pub.ADD;
2155: RAISE fnd_api.g_exc_error;
2156: END IF;--}
2157: ELSE --fulfillment base is 'P'
2233: ELSE --Non lot controlled item
2234: IF l_fulfillment_base = 'S' THEN --{
2235:
2236: IF(p_lpn_match_lpn_id IS NOT NULL) THEN
2237: inv_quantity_tree_pub.query_quantities(
2238: p_api_version_number => 1.0
2239: , p_init_msg_lst => fnd_api.g_false
2240: , x_return_status => l_return_status
2241: , x_msg_count => l_msg_cnt
2241: , x_msg_count => l_msg_cnt
2242: , x_msg_data => l_msg_data
2243: , p_organization_id => p_organization_id
2244: , p_inventory_item_id => p_inventory_item_id
2245: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
2246: , p_is_revision_control => b_is_revision_control
2247: , p_is_lot_control => FALSE
2248: , p_is_serial_control => FALSE -- Dual UOM Items cannot be serial controlled and if fulfill base is 'S' item is dual UOM controlled always
2249: , p_demand_source_type_id => -9999
2266: , p_lpn_id => p_lpn_match_lpn_id
2267: , p_grade_code => NULL
2268: );
2269: ELSE
2270: inv_quantity_tree_pub.query_quantities(
2271: p_api_version_number => 1.0
2272: , p_init_msg_lst => fnd_api.g_false
2273: , x_return_status => l_return_status
2274: , x_msg_count => l_msg_cnt
2274: , x_msg_count => l_msg_cnt
2275: , x_msg_data => l_msg_data
2276: , p_organization_id => p_organization_id
2277: , p_inventory_item_id => p_inventory_item_id
2278: , p_tree_mode => inv_quantity_tree_pub.g_loose_only_mode
2279: , p_is_revision_control => b_is_revision_control
2280: , p_is_lot_control => FALSE
2281: , p_is_serial_control => FALSE -- Dual UOM Items cannot be serial controlled and if fulfill base is 'S' item is dual UOM controlled always
2282: , p_demand_source_type_id => -9999
2334: x_satt := l_satt;
2335:
2336: ELSE --Quantity tree errored out
2337: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2338: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2339: fnd_msg_pub.ADD;
2340: RAISE fnd_api.g_exc_error;
2341: END IF;--}
2342: ELSE --fulfillment base is 'P'
8997: RAISE fnd_api.g_exc_error;
8998: END;
8999:
9000: -- clear quantity cache before we create qty tree.
9001: inv_quantity_tree_pub.clear_quantity_cache;
9002:
9003: -- Check if LPN has items other than the one requested
9004:
9005: IF (l_debug = 1) THEN
9102:
9103: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN --{
9104: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
9105: --in order to get correct att.
9106: inv_quantity_tree_pub.update_quantities(
9107: p_api_version_number => 1.0
9108: , p_init_msg_lst => fnd_api.g_false
9109: , x_return_status => l_return_status
9110: , x_msg_count => l_msg_cnt
9110: , x_msg_count => l_msg_cnt
9111: , x_msg_data => l_msg_data
9112: , p_organization_id => p_org_id
9113: , p_inventory_item_id => p_item_id
9114: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9115: , p_is_revision_control => b_is_revision_control
9116: , p_is_lot_control => TRUE
9117: , p_is_serial_control => b_is_serial_control
9118: , p_revision => NVL(p_rev, NULL)
9148: mydebug('calling update qty tree with lpn 1st time failed ');
9149: END IF;
9150:
9151: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9152: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9153: fnd_msg_pub.ADD;
9154: RAISE fnd_api.g_exc_error;
9155: END IF;
9156: --Bug#5649056: only update if subinventory and locator match
9154: RAISE fnd_api.g_exc_error;
9155: END IF;
9156: --Bug#5649056: only update if subinventory and locator match
9157: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
9158: inv_quantity_tree_pub.update_quantities(
9159: p_api_version_number => 1.0
9160: , p_init_msg_lst => fnd_api.g_false
9161: , x_return_status => l_return_status
9162: , x_msg_count => l_msg_cnt
9162: , x_msg_count => l_msg_cnt
9163: , x_msg_data => l_msg_data
9164: , p_organization_id => p_org_id
9165: , p_inventory_item_id => p_item_id
9166: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9167: , p_is_revision_control => b_is_revision_control
9168: , p_is_lot_control => TRUE
9169: , p_is_serial_control => b_is_serial_control
9170: , p_revision => NVL(p_rev, NULL)
9200: mydebug('calling update qty tree back without lpn 1st time failed ');
9201: END IF;
9202:
9203: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9204: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9205: fnd_msg_pub.ADD;
9206: RAISE fnd_api.g_exc_error;
9207: END IF;
9208: END IF; --}
9206: RAISE fnd_api.g_exc_error;
9207: END IF;
9208: END IF; --}
9209:
9210: inv_quantity_tree_pub.query_quantities(
9211: p_api_version_number => 1.0
9212: , p_init_msg_lst => fnd_api.g_false
9213: , x_return_status => l_return_status
9214: , x_msg_count => l_msg_cnt
9214: , x_msg_count => l_msg_cnt
9215: , x_msg_data => l_msg_data
9216: , p_organization_id => p_org_id
9217: , p_inventory_item_id => p_item_id
9218: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9219: , p_is_revision_control => b_is_revision_control
9220: , p_is_lot_control => TRUE
9221: , p_is_serial_control => b_is_serial_control
9222: , p_demand_source_type_id => -9999
9305: mydebug('calling qty tree 1st time failed ');
9306: END IF;
9307:
9308: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9309: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9310: fnd_msg_pub.ADD;
9311: RAISE fnd_api.g_exc_error;
9312: END IF; --}
9313:
9313:
9314: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN --{
9315: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
9316: -- in order to get correct att.
9317: inv_quantity_tree_pub.update_quantities(
9318: p_api_version_number => 1.0
9319: , p_init_msg_lst => fnd_api.g_false
9320: , x_return_status => l_return_status
9321: , x_msg_count => l_msg_cnt
9321: , x_msg_count => l_msg_cnt
9322: , x_msg_data => l_msg_data
9323: , p_organization_id => p_org_id
9324: , p_inventory_item_id => p_item_id
9325: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9326: , p_is_revision_control => b_is_revision_control
9327: , p_is_lot_control => TRUE
9328: , p_is_serial_control => b_is_serial_control
9329: , p_revision => NVL(p_rev, NULL)
9359: mydebug('calling update qty tree back with lpn 1st time failed ');
9360: END IF;
9361:
9362: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9363: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9364: fnd_msg_pub.ADD;
9365: RAISE fnd_api.g_exc_error;
9366: END IF;
9367: --Bug#5649056: only update if subinventory and locator match
9365: RAISE fnd_api.g_exc_error;
9366: END IF;
9367: --Bug#5649056: only update if subinventory and locator match
9368: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
9369: inv_quantity_tree_pub.update_quantities(
9370: p_api_version_number => 1.0
9371: , p_init_msg_lst => fnd_api.g_false
9372: , x_return_status => l_return_status
9373: , x_msg_count => l_msg_cnt
9373: , x_msg_count => l_msg_cnt
9374: , x_msg_data => l_msg_data
9375: , p_organization_id => p_org_id
9376: , p_inventory_item_id => p_item_id
9377: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9378: , p_is_revision_control => b_is_revision_control
9379: , p_is_lot_control => TRUE
9380: , p_is_serial_control => b_is_serial_control
9381: , p_revision => NVL(p_rev, NULL)
9411: mydebug('calling update qty tree back without lpn 1st time failed ');
9412: END IF;
9413:
9414: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9415: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9416: fnd_msg_pub.ADD;
9417: RAISE fnd_api.g_exc_error;
9418: END IF;
9419: END IF; --}
9482:
9483: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN --{
9484: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
9485: -- in order to get correct att.
9486: inv_quantity_tree_pub.update_quantities(
9487: p_api_version_number => 1.0
9488: , p_init_msg_lst => fnd_api.g_false
9489: , x_return_status => l_return_status
9490: , x_msg_count => l_msg_cnt
9490: , x_msg_count => l_msg_cnt
9491: , x_msg_data => l_msg_data
9492: , p_organization_id => p_org_id
9493: , p_inventory_item_id => p_item_id
9494: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9495: , p_is_revision_control => b_is_revision_control
9496: , p_is_lot_control => FALSE
9497: , p_is_serial_control => b_is_serial_control
9498: , p_revision => NVL(p_rev, NULL)
9528: mydebug('calling update qty tree with lpn 2nd time failed ');
9529: END IF;
9530:
9531: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9532: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9533: fnd_msg_pub.ADD;
9534: RAISE fnd_api.g_exc_error;
9535: END IF;
9536: --Bug#5649056: only update if subinventory and locator match
9534: RAISE fnd_api.g_exc_error;
9535: END IF;
9536: --Bug#5649056: only update if subinventory and locator match
9537: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
9538: inv_quantity_tree_pub.update_quantities(
9539: p_api_version_number => 1.0
9540: , p_init_msg_lst => fnd_api.g_false
9541: , x_return_status => l_return_status
9542: , x_msg_count => l_msg_cnt
9542: , x_msg_count => l_msg_cnt
9543: , x_msg_data => l_msg_data
9544: , p_organization_id => p_org_id
9545: , p_inventory_item_id => p_item_id
9546: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9547: , p_is_revision_control => b_is_revision_control
9548: , p_is_lot_control => FALSE
9549: , p_is_serial_control => b_is_serial_control
9550: , p_revision => NVL(p_rev, NULL)
9580: mydebug('calling update qty tree back without lpn 2nd time failed ');
9581: END IF;
9582:
9583: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9584: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9585: fnd_msg_pub.ADD;
9586: RAISE fnd_api.g_exc_error;
9587: END IF;
9588: END IF; --}
9586: RAISE fnd_api.g_exc_error;
9587: END IF;
9588: END IF; --}
9589:
9590: inv_quantity_tree_pub.query_quantities(
9591: p_api_version_number => 1.0
9592: , p_init_msg_lst => fnd_api.g_false
9593: , x_return_status => l_return_status
9594: , x_msg_count => l_msg_cnt
9594: , x_msg_count => l_msg_cnt
9595: , x_msg_data => l_msg_data
9596: , p_organization_id => p_org_id
9597: , p_inventory_item_id => p_item_id
9598: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9599: , p_is_revision_control => b_is_revision_control
9600: , p_is_lot_control => FALSE
9601: , p_is_serial_control => b_is_serial_control
9602: , p_demand_source_type_id => -9999
9653: mydebug('calling qty tree 2nd time failed ');
9654: END IF;
9655:
9656: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9657: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9658: fnd_msg_pub.ADD;
9659: RAISE fnd_api.g_exc_error;
9660: END IF;
9661:
9661:
9662: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN --{
9663: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
9664: -- in order to get correct att.
9665: inv_quantity_tree_pub.update_quantities(
9666: p_api_version_number => 1.0
9667: , p_init_msg_lst => fnd_api.g_false
9668: , x_return_status => l_return_status
9669: , x_msg_count => l_msg_cnt
9669: , x_msg_count => l_msg_cnt
9670: , x_msg_data => l_msg_data
9671: , p_organization_id => p_org_id
9672: , p_inventory_item_id => p_item_id
9673: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9674: , p_is_revision_control => b_is_revision_control
9675: , p_is_lot_control => FALSE
9676: , p_is_serial_control => b_is_serial_control
9677: , p_revision => NVL(p_rev, NULL)
9707: mydebug('calling update qty tree with lpn 2nd time failed ');
9708: END IF;
9709:
9710: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9711: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9712: fnd_msg_pub.ADD;
9713: RAISE fnd_api.g_exc_error;
9714: END IF;
9715: --Bug#5649056: only update if subinventory and locator match
9713: RAISE fnd_api.g_exc_error;
9714: END IF;
9715: --Bug#5649056: only update if subinventory and locator match
9716: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
9717: inv_quantity_tree_pub.update_quantities(
9718: p_api_version_number => 1.0
9719: , p_init_msg_lst => fnd_api.g_false
9720: , x_return_status => l_return_status
9721: , x_msg_count => l_msg_cnt
9721: , x_msg_count => l_msg_cnt
9722: , x_msg_data => l_msg_data
9723: , p_organization_id => p_org_id
9724: , p_inventory_item_id => p_item_id
9725: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9726: , p_is_revision_control => b_is_revision_control
9727: , p_is_lot_control => FALSE
9728: , p_is_serial_control => b_is_serial_control
9729: , p_revision => NVL(p_rev, NULL)
9759: mydebug('calling update qty tree back without lpn 2nd time failed ');
9760: END IF;
9761:
9762: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9763: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9764: fnd_msg_pub.ADD;
9765: RAISE fnd_api.g_exc_error;
9766: END IF;
9767: END IF; --}
9861:
9862: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN --{
9863: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
9864: -- in order to get correct att.
9865: inv_quantity_tree_pub.update_quantities(
9866: p_api_version_number => 1.0
9867: , p_init_msg_lst => fnd_api.g_false
9868: , x_return_status => l_return_status
9869: , x_msg_count => l_msg_cnt
9869: , x_msg_count => l_msg_cnt
9870: , x_msg_data => l_msg_data
9871: , p_organization_id => p_org_id
9872: , p_inventory_item_id => p_item_id
9873: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9874: , p_is_revision_control => b_is_revision_control
9875: , p_is_lot_control => TRUE
9876: , p_is_serial_control => b_is_serial_control
9877: , p_revision => NVL(p_rev, NULL)
9907: mydebug('calling update qty tree with lpn 3rd time failed ');
9908: END IF;
9909:
9910: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9911: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9912: fnd_msg_pub.ADD;
9913: RAISE fnd_api.g_exc_error;
9914: END IF;
9915: --Bug#5649056: only update if subinventory and locator match
9913: RAISE fnd_api.g_exc_error;
9914: END IF;
9915: --Bug#5649056: only update if subinventory and locator match
9916: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
9917: inv_quantity_tree_pub.update_quantities(
9918: p_api_version_number => 1.0
9919: , p_init_msg_lst => fnd_api.g_false
9920: , x_return_status => l_return_status
9921: , x_msg_count => l_msg_cnt
9921: , x_msg_count => l_msg_cnt
9922: , x_msg_data => l_msg_data
9923: , p_organization_id => p_org_id
9924: , p_inventory_item_id => p_item_id
9925: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9926: , p_is_revision_control => b_is_revision_control
9927: , p_is_lot_control => TRUE
9928: , p_is_serial_control => b_is_serial_control
9929: , p_revision => NVL(p_rev, NULL)
9959: mydebug('calling update qty tree back 3rd time without lpn 3rd time failed ');
9960: END IF;
9961:
9962: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9963: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9964: fnd_msg_pub.ADD;
9965: RAISE fnd_api.g_exc_error;
9966: END IF;
9967: END IF;--}
9965: RAISE fnd_api.g_exc_error;
9966: END IF;
9967: END IF;--}
9968:
9969: inv_quantity_tree_pub.query_quantities(
9970: p_api_version_number => 1.0
9971: , p_init_msg_lst => fnd_api.g_false
9972: , x_return_status => l_return_status
9973: , x_msg_count => l_msg_cnt
9973: , x_msg_count => l_msg_cnt
9974: , x_msg_data => l_msg_data
9975: , p_organization_id => p_org_id
9976: , p_inventory_item_id => p_item_id
9977: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9978: , p_is_revision_control => b_is_revision_control
9979: , p_is_lot_control => TRUE
9980: , p_is_serial_control => b_is_serial_control
9981: , p_demand_source_type_id => -9999
10082: mydebug('calling qty tree 3rd time failed ');
10083: END IF;
10084:
10085: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10086: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10087: fnd_msg_pub.ADD;
10088: RAISE fnd_api.g_exc_error;
10089: END IF; --}
10090:
10213:
10214: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN --{
10215: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
10216: --in order to get correct att.
10217: inv_quantity_tree_pub.update_quantities(
10218: p_api_version_number => 1.0
10219: , p_init_msg_lst => fnd_api.g_false
10220: , x_return_status => l_return_status
10221: , x_msg_count => l_msg_cnt
10221: , x_msg_count => l_msg_cnt
10222: , x_msg_data => l_msg_data
10223: , p_organization_id => p_org_id
10224: , p_inventory_item_id => p_item_id
10225: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10226: , p_is_revision_control => b_is_revision_control
10227: , p_is_lot_control => TRUE
10228: , p_is_serial_control => b_is_serial_control
10229: , p_revision => NVL(p_rev, NULL)
10259: mydebug('calling update qty tree with lpn 3rd time failed ');
10260: END IF;
10261:
10262: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10263: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10264: fnd_msg_pub.ADD;
10265: RAISE fnd_api.g_exc_error;
10266: END IF;
10267: --Bug#5649056: only update if subinventory and locator match
10265: RAISE fnd_api.g_exc_error;
10266: END IF;
10267: --Bug#5649056: only update if subinventory and locator match
10268: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
10269: inv_quantity_tree_pub.update_quantities(
10270: p_api_version_number => 1.0
10271: , p_init_msg_lst => fnd_api.g_false
10272: , x_return_status => l_return_status
10273: , x_msg_count => l_msg_cnt
10273: , x_msg_count => l_msg_cnt
10274: , x_msg_data => l_msg_data
10275: , p_organization_id => p_org_id
10276: , p_inventory_item_id => p_item_id
10277: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10278: , p_is_revision_control => b_is_revision_control
10279: , p_is_lot_control => TRUE
10280: , p_is_serial_control => b_is_serial_control
10281: , p_revision => NVL(p_rev, NULL)
10311: mydebug('calling update qty tree back without lpn 3rd time failed ');
10312: END IF;
10313:
10314: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10315: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10316: fnd_msg_pub.ADD;
10317: RAISE fnd_api.g_exc_error;
10318: END IF;
10319: END IF; --}
10441:
10442: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN --{
10443: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
10444: -- in order to get correct att.
10445: inv_quantity_tree_pub.update_quantities(
10446: p_api_version_number => 1.0
10447: , p_init_msg_lst => fnd_api.g_false
10448: , x_return_status => l_return_status
10449: , x_msg_count => l_msg_cnt
10449: , x_msg_count => l_msg_cnt
10450: , x_msg_data => l_msg_data
10451: , p_organization_id => p_org_id
10452: , p_inventory_item_id => p_item_id
10453: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10454: , p_is_revision_control => b_is_revision_control
10455: , p_is_lot_control => FALSE
10456: , p_is_serial_control => b_is_serial_control
10457: , p_revision => NVL(p_rev, NULL)
10487: mydebug('calling update qty tree with lpn 4th time failed ');
10488: END IF;
10489:
10490: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10491: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10492: fnd_msg_pub.ADD;
10493: RAISE fnd_api.g_exc_error;
10494: END IF;
10495: --Bug#5649056: only update if subinventory and locator match
10494: END IF;
10495: --Bug#5649056: only update if subinventory and locator match
10496: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
10497:
10498: inv_quantity_tree_pub.update_quantities(
10499: p_api_version_number => 1.0
10500: , p_init_msg_lst => fnd_api.g_false
10501: , x_return_status => l_return_status
10502: , x_msg_count => l_msg_cnt
10502: , x_msg_count => l_msg_cnt
10503: , x_msg_data => l_msg_data
10504: , p_organization_id => p_org_id
10505: , p_inventory_item_id => p_item_id
10506: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10507: , p_is_revision_control => b_is_revision_control
10508: , p_is_lot_control => FALSE
10509: , p_is_serial_control => b_is_serial_control
10510: , p_revision => NVL(p_rev, NULL)
10540: mydebug('calling update qty tree without lpn 4th time failed ');
10541: END IF;
10542:
10543: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10544: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10545: fnd_msg_pub.ADD;
10546: RAISE fnd_api.g_exc_error;
10547: END IF;
10548: END IF; --}
10546: RAISE fnd_api.g_exc_error;
10547: END IF;
10548: END IF; --}
10549:
10550: inv_quantity_tree_pub.query_quantities(
10551: p_api_version_number => 1.0
10552: , p_init_msg_lst => fnd_api.g_false
10553: , x_return_status => l_return_status
10554: , x_msg_count => l_msg_cnt
10554: , x_msg_count => l_msg_cnt
10555: , x_msg_data => l_msg_data
10556: , p_organization_id => p_org_id
10557: , p_inventory_item_id => p_item_id
10558: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode --??
10559: , p_is_revision_control => b_is_revision_control
10560: , p_is_lot_control => FALSE
10561: , p_is_serial_control => b_is_serial_control
10562: , p_demand_source_type_id => -9999
10647: mydebug('calling qty tree 4th time failed');
10648: END IF;
10649:
10650: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10651: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10652: fnd_msg_pub.ADD;
10653: RAISE fnd_api.g_exc_error;
10654: END IF; --}
10655:
10655:
10656: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN --{
10657: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
10658: -- in order to get correct att.
10659: inv_quantity_tree_pub.update_quantities(
10660: p_api_version_number => 1.0
10661: , p_init_msg_lst => fnd_api.g_false
10662: , x_return_status => l_return_status
10663: , x_msg_count => l_msg_cnt
10663: , x_msg_count => l_msg_cnt
10664: , x_msg_data => l_msg_data
10665: , p_organization_id => p_org_id
10666: , p_inventory_item_id => p_item_id
10667: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10668: , p_is_revision_control => b_is_revision_control
10669: , p_is_lot_control => FALSE
10670: , p_is_serial_control => b_is_serial_control
10671: , p_revision => NVL(p_rev, NULL)
10701: mydebug('calling update qty tree back with lpn 4th time failed ');
10702: END IF;
10703:
10704: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10705: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10706: fnd_msg_pub.ADD;
10707: RAISE fnd_api.g_exc_error;
10708: END IF;
10709: --Bug#5649056: only update if subinventory and locator match
10707: RAISE fnd_api.g_exc_error;
10708: END IF;
10709: --Bug#5649056: only update if subinventory and locator match
10710: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
10711: inv_quantity_tree_pub.update_quantities(
10712: p_api_version_number => 1.0
10713: , p_init_msg_lst => fnd_api.g_false
10714: , x_return_status => l_return_status
10715: , x_msg_count => l_msg_cnt
10715: , x_msg_count => l_msg_cnt
10716: , x_msg_data => l_msg_data
10717: , p_organization_id => p_org_id
10718: , p_inventory_item_id => p_item_id
10719: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10720: , p_is_revision_control => b_is_revision_control
10721: , p_is_lot_control => FALSE
10722: , p_is_serial_control => b_is_serial_control
10723: , p_revision => NVL(p_rev, NULL)
10753: mydebug('calling update qty tree back without lpn 4th time failed ');
10754: END IF;
10755:
10756: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10757: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10758: fnd_msg_pub.ADD;
10759: RAISE fnd_api.g_exc_error;
10760: END IF;
10761: END IF; --}
10846: IF (p_full_lot_allocation IN ('N', 'P')) THEN
10847: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
10848: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
10849: -- in order to get correct att.
10850: inv_quantity_tree_pub.update_quantities(
10851: p_api_version_number => 1.0
10852: , p_init_msg_lst => fnd_api.g_false
10853: , x_return_status => l_return_status
10854: , x_msg_count => l_msg_cnt
10854: , x_msg_count => l_msg_cnt
10855: , x_msg_data => l_msg_data
10856: , p_organization_id => p_org_id
10857: , p_inventory_item_id => p_item_id
10858: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10859: , p_is_revision_control => b_is_revision_control
10860: , p_is_lot_control => TRUE
10861: , p_is_serial_control => b_is_serial_control
10862: , p_revision => NVL(p_rev, NULL)
10891: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
10892: END IF;
10893:
10894: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10895: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10896: fnd_msg_pub.ADD;
10897: RAISE fnd_api.g_exc_error;
10898: END IF;
10899:
10897: RAISE fnd_api.g_exc_error;
10898: END IF;
10899:
10900: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
10901: inv_quantity_tree_pub.update_quantities(
10902: p_api_version_number => 1.0
10903: , p_init_msg_lst => fnd_api.g_false
10904: , x_return_status => l_return_status
10905: , x_msg_count => l_msg_cnt
10905: , x_msg_count => l_msg_cnt
10906: , x_msg_data => l_msg_data
10907: , p_organization_id => p_org_id
10908: , p_inventory_item_id => p_item_id
10909: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10910: , p_is_revision_control => b_is_revision_control
10911: , p_is_lot_control => TRUE
10912: , p_is_serial_control => b_is_serial_control
10913: , p_revision => NVL(p_rev, NULL)
10941: mydebug('calling update qty tree for FlexiLotAlloc without lpn failed ');
10942: END IF;
10943:
10944: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10945: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10946: fnd_msg_pub.ADD;
10947: RAISE fnd_api.g_exc_error;
10948: END IF;
10949: END IF;
10975: mydebug(' Unallocated l_mtlt_secondary_qty: ' || l_mtlt_secondary_qty);
10976: END IF;
10977:
10978:
10979: inv_quantity_tree_pub.query_quantities(
10980: p_api_version_number => 1.0
10981: , p_init_msg_lst => fnd_api.g_false
10982: , x_return_status => l_return_status
10983: , x_msg_count => l_msg_cnt
10983: , x_msg_count => l_msg_cnt
10984: , x_msg_data => l_msg_data
10985: , p_organization_id => p_org_id
10986: , p_inventory_item_id => p_item_id
10987: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
10988: , p_is_revision_control => b_is_revision_control
10989: , p_is_lot_control => TRUE
10990: , p_is_serial_control => b_is_serial_control
10991: , p_demand_source_type_id => -9999
11092: -- Start for 16267113 Flexible Lot Allocation
11093: IF (p_full_lot_allocation IN ('N', 'P')) THEN
11094: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
11095:
11096: inv_quantity_tree_pub.update_quantities(
11097: p_api_version_number => 1.0
11098: , p_init_msg_lst => fnd_api.g_false
11099: , x_return_status => l_return_status
11100: , x_msg_count => l_msg_cnt
11100: , x_msg_count => l_msg_cnt
11101: , x_msg_data => l_msg_data
11102: , p_organization_id => p_org_id
11103: , p_inventory_item_id => p_item_id
11104: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
11105: , p_is_revision_control => b_is_revision_control
11106: , p_is_lot_control => TRUE
11107: , p_is_serial_control => b_is_serial_control
11108: , p_revision => NVL(p_rev, NULL)
11137: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
11138: END IF;
11139:
11140: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
11141: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
11142: fnd_msg_pub.ADD;
11143: RAISE fnd_api.g_exc_error;
11144: END IF;
11145: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
11142: fnd_msg_pub.ADD;
11143: RAISE fnd_api.g_exc_error;
11144: END IF;
11145: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
11146: inv_quantity_tree_pub.update_quantities(
11147: p_api_version_number => 1.0
11148: , p_init_msg_lst => fnd_api.g_false
11149: , x_return_status => l_return_status
11150: , x_msg_count => l_msg_cnt
11150: , x_msg_count => l_msg_cnt
11151: , x_msg_data => l_msg_data
11152: , p_organization_id => p_org_id
11153: , p_inventory_item_id => p_item_id
11154: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
11155: , p_is_revision_control => b_is_revision_control
11156: , p_is_lot_control => TRUE
11157: , p_is_serial_control => b_is_serial_control
11158: , p_revision => NVL(p_rev, NULL)
11186: mydebug('calling update qty tree back for +ve qty without lpn for FlexiLotAlloc failed ');
11187: END IF;
11188:
11189: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
11190: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
11191: fnd_msg_pub.ADD;
11192: RAISE fnd_api.g_exc_error;
11193: END IF;
11194: END IF;
12268: -- always do one query at least for non lot controlled items
12269:
12270: INV_TXN_VALIDATIONS.get_available_quantity
12271: (x_return_status => l_return_status,
12272: p_tree_mode => inv_quantity_tree_pub.g_loose_only_mode,
12273: p_organization_id =>p_org_id,
12274: p_inventory_item_id => p_item_id,
12275: p_is_revision_control =>p_is_revision_control,
12276: p_is_lot_control =>p_is_lot_control,
12453: IF (l_debug = 1) THEN
12454: mydebug('calling qty tree 1st time failed ');
12455: END IF;
12456: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
12457: fnd_message.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
12458: fnd_msg_pub.ADD;
12459: RAISE fnd_api.g_exc_error;
12460: END IF; --}
12461:
14959: mydebug(' Unallocated p_fromlpn_id ' || p_fromlpn_id);
14960: mydebug(' Unallocated l_xfr_sub_code ' || l_xfr_sub_code);
14961: END IF;
14962:
14963: inv_quantity_tree_pub.query_quantities(
14964: p_api_version_number => 1.0
14965: , p_init_msg_lst => fnd_api.g_false
14966: , x_return_status => l_return_status
14967: , x_msg_count => l_msg_cnt
14967: , x_msg_count => l_msg_cnt
14968: , x_msg_data => l_msg_data
14969: , p_organization_id => p_org_id
14970: , p_inventory_item_id => p_item_id
14971: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
14972: , p_is_revision_control => b_is_revision_control
14973: , p_is_lot_control => TRUE
14974: , p_is_serial_control => b_is_serial_control
14975: , p_demand_source_type_id => -9999
15042: mydebug(' Unallocated l_mtlt_lot_number : ' || l_mtlt_lot_number);
15043: mydebug(' Unallocated l_mtlt_primary_qty: ' || l_mtlt_primary_qty);
15044: END IF;
15045:
15046: inv_quantity_tree_pub.query_quantities(
15047: p_api_version_number => 1.0
15048: , p_init_msg_lst => fnd_api.g_false
15049: , x_return_status => l_return_status
15050: , x_msg_count => l_msg_cnt
15050: , x_msg_count => l_msg_cnt
15051: , x_msg_data => l_msg_data
15052: , p_organization_id => p_org_id
15053: , p_inventory_item_id => p_item_id
15054: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
15055: , p_is_revision_control => b_is_revision_control
15056: , p_is_lot_control => TRUE
15057: , p_is_serial_control => b_is_serial_control
15058: , p_demand_source_type_id => -9999
15801: ELSE
15802: b_is_revision_control := TRUE;
15803: END IF;
15804:
15805: inv_quantity_tree_pub.clear_quantity_cache;
15806:
15807: SELECT primary_uom_code
15808: INTO l_primary_uom
15809: FROM mtl_system_items
15955: IF (p_full_lot_allocation IN ('N', 'P')) THEN
15956: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
15957: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
15958: -- in order to get correct att.
15959: inv_quantity_tree_pub.update_quantities(
15960: p_api_version_number => 1.0
15961: , p_init_msg_lst => fnd_api.g_false
15962: , x_return_status => l_return_status
15963: , x_msg_count => l_msg_cnt
15963: , x_msg_count => l_msg_cnt
15964: , x_msg_data => l_msg_data
15965: , p_organization_id => p_org_id
15966: , p_inventory_item_id => p_item_id
15967: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
15968: , p_is_revision_control => b_is_revision_control
15969: , p_is_lot_control => TRUE
15970: , p_is_serial_control => b_is_serial_control
15971: , p_revision => NVL(p_rev, NULL)
16000: mydebug('calling update qty tree with lpn for FlexiLotAlloc failed ');
16001: END IF;
16002:
16003: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
16004: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
16005: fnd_msg_pub.ADD;
16006: RAISE fnd_api.g_exc_error;
16007: END IF;
16008:
16006: RAISE fnd_api.g_exc_error;
16007: END IF;
16008:
16009: ELSIF ( Nvl(l_lpn_sub, p_confirmed_sub) = l_mmtt_sub AND Nvl(l_lpn_loc, p_confirmed_loc_id) = l_mmtt_loc ) THEN
16010: inv_quantity_tree_pub.update_quantities(
16011: p_api_version_number => 1.0
16012: , p_init_msg_lst => fnd_api.g_false
16013: , x_return_status => l_return_status
16014: , x_msg_count => l_msg_cnt
16014: , x_msg_count => l_msg_cnt
16015: , x_msg_data => l_msg_data
16016: , p_organization_id => p_org_id
16017: , p_inventory_item_id => p_item_id
16018: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
16019: , p_is_revision_control => b_is_revision_control
16020: , p_is_lot_control => TRUE
16021: , p_is_serial_control => b_is_serial_control
16022: , p_revision => NVL(p_rev, NULL)
16050: mydebug('calling update qty tree for FlexiLotAlloc without lpn failed ');
16051: END IF;
16052:
16053: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
16054: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
16055: fnd_msg_pub.ADD;
16056: RAISE fnd_api.g_exc_error;
16057: END IF;
16058: END IF;
16057: END IF;
16058: END IF;
16059: END IF;
16060:
16061: inv_quantity_tree_pub.query_quantities(
16062: p_api_version_number => 1.0
16063: , p_init_msg_lst => fnd_api.g_false
16064: , x_return_status => l_return_status
16065: , x_msg_count => l_msg_cnt
16065: , x_msg_count => l_msg_cnt
16066: , x_msg_data => l_msg_data
16067: , p_organization_id => p_org_id
16068: , p_inventory_item_id => p_item_id
16069: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
16070: , p_is_revision_control => b_is_revision_control
16071: , p_is_lot_control => TRUE
16072: , p_is_serial_control => b_is_serial_control
16073: , p_demand_source_type_id => -9999