eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_LOAD dependencies on INV_QUANTITY_TREE_PUB

Line 7469: inv_quantity_tree_pub.clear_quantity_cache;

7465: RAISE fnd_api.g_exc_error;
7466: END;
7467:
7468: -- clear quantity cache before we create qty tree.
7469: inv_quantity_tree_pub.clear_quantity_cache;
7470:
7471: -- Check if LPN has items other than the one requested
7472:
7473: IF (l_debug = 1) THEN

Line 7575: inv_quantity_tree_pub.update_quantities(

7571:
7572: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
7573: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
7574: -- in order to get correct att.
7575: inv_quantity_tree_pub.update_quantities(
7576: p_api_version_number => 1.0
7577: , p_init_msg_lst => fnd_api.g_false
7578: , x_return_status => l_return_status
7579: , x_msg_count => l_msg_cnt

Line 7583: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

7579: , x_msg_count => l_msg_cnt
7580: , x_msg_data => l_msg_data
7581: , p_organization_id => p_org_id
7582: , p_inventory_item_id => p_item_id
7583: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
7584: , p_is_revision_control => b_is_revision_control
7585: , p_is_lot_control => TRUE
7586: , p_is_serial_control => b_is_serial_control
7587: , p_revision => NVL(p_rev, NULL)

Line 7621: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

7617: mydebug('calling update qty tree with lpn 1st time failed ');
7618: END IF;
7619:
7620: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
7621: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
7622: fnd_msg_pub.ADD;
7623: RAISE fnd_api.g_exc_error;
7624: END IF;
7625: --Bug#5649056: only update if subinventory and locator match

Line 7627: inv_quantity_tree_pub.update_quantities(

7623: RAISE fnd_api.g_exc_error;
7624: END IF;
7625: --Bug#5649056: only update if subinventory and locator match
7626: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
7627: inv_quantity_tree_pub.update_quantities(
7628: p_api_version_number => 1.0
7629: , p_init_msg_lst => fnd_api.g_false
7630: , x_return_status => l_return_status
7631: , x_msg_count => l_msg_cnt

Line 7635: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

7631: , x_msg_count => l_msg_cnt
7632: , x_msg_data => l_msg_data
7633: , p_organization_id => p_org_id
7634: , p_inventory_item_id => p_item_id
7635: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
7636: , p_is_revision_control => b_is_revision_control
7637: , p_is_lot_control => TRUE
7638: , p_is_serial_control => b_is_serial_control
7639: , p_revision => NVL(p_rev, NULL)

Line 7673: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

7669: mydebug('calling update qty tree back without lpn 1st time failed ');
7670: END IF;
7671:
7672: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
7673: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
7674: fnd_msg_pub.ADD;
7675: RAISE fnd_api.g_exc_error;
7676: END IF;
7677: END IF;

Line 7679: inv_quantity_tree_pub.query_quantities(

7675: RAISE fnd_api.g_exc_error;
7676: END IF;
7677: END IF;
7678:
7679: inv_quantity_tree_pub.query_quantities(
7680: p_api_version_number => 1.0
7681: , p_init_msg_lst => fnd_api.g_false
7682: , x_return_status => l_return_status
7683: , x_msg_count => l_msg_cnt

Line 7687: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

7683: , x_msg_count => l_msg_cnt
7684: , x_msg_data => l_msg_data
7685: , p_organization_id => p_org_id
7686: , p_inventory_item_id => p_item_id
7687: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
7688: , p_is_revision_control => b_is_revision_control
7689: , p_is_lot_control => TRUE
7690: , p_is_serial_control => b_is_serial_control
7691: , p_demand_source_type_id => -9999

Line 7756: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

7752: mydebug('calling qty tree 1st time failed ');
7753: END IF;
7754:
7755: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
7756: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
7757: fnd_msg_pub.ADD;
7758: RAISE fnd_api.g_exc_error;
7759: END IF;
7760:

Line 7764: inv_quantity_tree_pub.update_quantities(

7760:
7761: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
7762: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
7763: -- in order to get correct att.
7764: inv_quantity_tree_pub.update_quantities(
7765: p_api_version_number => 1.0
7766: , p_init_msg_lst => fnd_api.g_false
7767: , x_return_status => l_return_status
7768: , x_msg_count => l_msg_cnt

Line 7772: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

7768: , x_msg_count => l_msg_cnt
7769: , x_msg_data => l_msg_data
7770: , p_organization_id => p_org_id
7771: , p_inventory_item_id => p_item_id
7772: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
7773: , p_is_revision_control => b_is_revision_control
7774: , p_is_lot_control => TRUE
7775: , p_is_serial_control => b_is_serial_control
7776: , p_revision => NVL(p_rev, NULL)

Line 7810: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

7806: mydebug('calling update qty tree back with lpn 1st time failed ');
7807: END IF;
7808:
7809: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
7810: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
7811: fnd_msg_pub.ADD;
7812: RAISE fnd_api.g_exc_error;
7813: END IF;
7814: --Bug#5649056: only update if subinventory and locator match

Line 7816: inv_quantity_tree_pub.update_quantities(

7812: RAISE fnd_api.g_exc_error;
7813: END IF;
7814: --Bug#5649056: only update if subinventory and locator match
7815: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
7816: inv_quantity_tree_pub.update_quantities(
7817: p_api_version_number => 1.0
7818: , p_init_msg_lst => fnd_api.g_false
7819: , x_return_status => l_return_status
7820: , x_msg_count => l_msg_cnt

Line 7824: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

7820: , x_msg_count => l_msg_cnt
7821: , x_msg_data => l_msg_data
7822: , p_organization_id => p_org_id
7823: , p_inventory_item_id => p_item_id
7824: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
7825: , p_is_revision_control => b_is_revision_control
7826: , p_is_lot_control => TRUE
7827: , p_is_serial_control => b_is_serial_control
7828: , p_revision => NVL(p_rev, NULL)

Line 7862: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

7858: mydebug('calling update qty tree back without lpn 1st time failed ');
7859: END IF;
7860:
7861: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
7862: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
7863: fnd_msg_pub.ADD;
7864: RAISE fnd_api.g_exc_error;
7865: END IF;
7866: END IF;

Line 7992: inv_quantity_tree_pub.update_quantities(

7988:
7989: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
7990: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
7991: -- in order to get correct att.
7992: inv_quantity_tree_pub.update_quantities(
7993: p_api_version_number => 1.0
7994: , p_init_msg_lst => fnd_api.g_false
7995: , x_return_status => l_return_status
7996: , x_msg_count => l_msg_cnt

Line 8000: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

7996: , x_msg_count => l_msg_cnt
7997: , x_msg_data => l_msg_data
7998: , p_organization_id => p_org_id
7999: , p_inventory_item_id => p_item_id
8000: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8001: , p_is_revision_control => b_is_revision_control
8002: , p_is_lot_control => FALSE
8003: , p_is_serial_control => b_is_serial_control
8004: , p_revision => NVL(p_rev, NULL)

Line 8038: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8034: mydebug('calling update qty tree with lpn 2nd time failed ');
8035: END IF;
8036:
8037: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8038: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8039: fnd_msg_pub.ADD;
8040: RAISE fnd_api.g_exc_error;
8041: END IF;
8042: --Bug#5649056: only update if subinventory and locator match

Line 8044: inv_quantity_tree_pub.update_quantities(

8040: RAISE fnd_api.g_exc_error;
8041: END IF;
8042: --Bug#5649056: only update if subinventory and locator match
8043: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
8044: inv_quantity_tree_pub.update_quantities(
8045: p_api_version_number => 1.0
8046: , p_init_msg_lst => fnd_api.g_false
8047: , x_return_status => l_return_status
8048: , x_msg_count => l_msg_cnt

Line 8052: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8048: , x_msg_count => l_msg_cnt
8049: , x_msg_data => l_msg_data
8050: , p_organization_id => p_org_id
8051: , p_inventory_item_id => p_item_id
8052: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8053: , p_is_revision_control => b_is_revision_control
8054: , p_is_lot_control => FALSE
8055: , p_is_serial_control => b_is_serial_control
8056: , p_revision => NVL(p_rev, NULL)

Line 8090: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8086: mydebug('calling update qty tree back without lpn 2nd time failed ');
8087: END IF;
8088:
8089: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8090: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8091: fnd_msg_pub.ADD;
8092: RAISE fnd_api.g_exc_error;
8093: END IF;
8094: END IF;

Line 8096: inv_quantity_tree_pub.query_quantities(

8092: RAISE fnd_api.g_exc_error;
8093: END IF;
8094: END IF;
8095:
8096: inv_quantity_tree_pub.query_quantities(
8097: p_api_version_number => 1.0
8098: , p_init_msg_lst => fnd_api.g_false
8099: , x_return_status => l_return_status
8100: , x_msg_count => l_msg_cnt

Line 8104: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8100: , x_msg_count => l_msg_cnt
8101: , x_msg_data => l_msg_data
8102: , p_organization_id => p_org_id
8103: , p_inventory_item_id => p_item_id
8104: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8105: , p_is_revision_control => b_is_revision_control
8106: , p_is_lot_control => FALSE
8107: , p_is_serial_control => b_is_serial_control
8108: , p_demand_source_type_id => -9999

Line 8151: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8147: mydebug('calling qty tree 2nd time failed ');
8148: END IF;
8149:
8150: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8151: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8152: fnd_msg_pub.ADD;
8153: RAISE fnd_api.g_exc_error;
8154: END IF;
8155:

Line 8159: inv_quantity_tree_pub.update_quantities(

8155:
8156: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
8157: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
8158: -- in order to get correct att.
8159: inv_quantity_tree_pub.update_quantities(
8160: p_api_version_number => 1.0
8161: , p_init_msg_lst => fnd_api.g_false
8162: , x_return_status => l_return_status
8163: , x_msg_count => l_msg_cnt

Line 8167: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8163: , x_msg_count => l_msg_cnt
8164: , x_msg_data => l_msg_data
8165: , p_organization_id => p_org_id
8166: , p_inventory_item_id => p_item_id
8167: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8168: , p_is_revision_control => b_is_revision_control
8169: , p_is_lot_control => FALSE
8170: , p_is_serial_control => b_is_serial_control
8171: , p_revision => NVL(p_rev, NULL)

Line 8205: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8201: mydebug('calling update qty tree with lpn 2nd time failed ');
8202: END IF;
8203:
8204: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8205: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8206: fnd_msg_pub.ADD;
8207: RAISE fnd_api.g_exc_error;
8208: END IF;
8209: --Bug#5649056: only update if subinventory and locator match

Line 8211: inv_quantity_tree_pub.update_quantities(

8207: RAISE fnd_api.g_exc_error;
8208: END IF;
8209: --Bug#5649056: only update if subinventory and locator match
8210: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
8211: inv_quantity_tree_pub.update_quantities(
8212: p_api_version_number => 1.0
8213: , p_init_msg_lst => fnd_api.g_false
8214: , x_return_status => l_return_status
8215: , x_msg_count => l_msg_cnt

Line 8219: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8215: , x_msg_count => l_msg_cnt
8216: , x_msg_data => l_msg_data
8217: , p_organization_id => p_org_id
8218: , p_inventory_item_id => p_item_id
8219: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8220: , p_is_revision_control => b_is_revision_control
8221: , p_is_lot_control => FALSE
8222: , p_is_serial_control => b_is_serial_control
8223: , p_revision => NVL(p_rev, NULL)

Line 8257: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8253: mydebug('calling update qty tree back without lpn 2nd time failed ');
8254: END IF;
8255:
8256: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8257: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8258: fnd_msg_pub.ADD;
8259: RAISE fnd_api.g_exc_error;
8260: END IF;
8261: END IF;

Line 8356: inv_quantity_tree_pub.update_quantities(

8352:
8353: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
8354: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
8355: -- in order to get correct att.
8356: inv_quantity_tree_pub.update_quantities(
8357: p_api_version_number => 1.0
8358: , p_init_msg_lst => fnd_api.g_false
8359: , x_return_status => l_return_status
8360: , x_msg_count => l_msg_cnt

Line 8364: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8360: , x_msg_count => l_msg_cnt
8361: , x_msg_data => l_msg_data
8362: , p_organization_id => p_org_id
8363: , p_inventory_item_id => p_item_id
8364: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8365: , p_is_revision_control => b_is_revision_control
8366: , p_is_lot_control => TRUE
8367: , p_is_serial_control => b_is_serial_control
8368: , p_revision => NVL(p_rev, NULL)

Line 8402: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8398: mydebug('calling update qty tree with lpn 3rd time failed ');
8399: END IF;
8400:
8401: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8402: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8403: fnd_msg_pub.ADD;
8404: RAISE fnd_api.g_exc_error;
8405: END IF;
8406: --Bug#5649056: only update if subinventory and locator match

Line 8408: inv_quantity_tree_pub.update_quantities(

8404: RAISE fnd_api.g_exc_error;
8405: END IF;
8406: --Bug#5649056: only update if subinventory and locator match
8407: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
8408: inv_quantity_tree_pub.update_quantities(
8409: p_api_version_number => 1.0
8410: , p_init_msg_lst => fnd_api.g_false
8411: , x_return_status => l_return_status
8412: , x_msg_count => l_msg_cnt

Line 8416: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8412: , x_msg_count => l_msg_cnt
8413: , x_msg_data => l_msg_data
8414: , p_organization_id => p_org_id
8415: , p_inventory_item_id => p_item_id
8416: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8417: , p_is_revision_control => b_is_revision_control
8418: , p_is_lot_control => TRUE
8419: , p_is_serial_control => b_is_serial_control
8420: , p_revision => NVL(p_rev, NULL)

Line 8454: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8450: mydebug('calling update qty tree back 3rd time without lpn 3rd time failed ');
8451: END IF;
8452:
8453: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8454: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8455: fnd_msg_pub.ADD;
8456: RAISE fnd_api.g_exc_error;
8457: END IF;
8458: END IF;

Line 8460: inv_quantity_tree_pub.query_quantities(

8456: RAISE fnd_api.g_exc_error;
8457: END IF;
8458: END IF;
8459:
8460: inv_quantity_tree_pub.query_quantities(
8461: p_api_version_number => 1.0
8462: , p_init_msg_lst => fnd_api.g_false
8463: , x_return_status => l_return_status
8464: , x_msg_count => l_msg_cnt

Line 8468: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8464: , x_msg_count => l_msg_cnt
8465: , x_msg_data => l_msg_data
8466: , p_organization_id => p_org_id
8467: , p_inventory_item_id => p_item_id
8468: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8469: , p_is_revision_control => b_is_revision_control
8470: , p_is_lot_control => TRUE
8471: , p_is_serial_control => b_is_serial_control
8472: , p_demand_source_type_id => -9999

Line 8554: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8550: mydebug('calling qty tree 3rd time failed ');
8551: END IF;
8552:
8553: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8554: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8555: fnd_msg_pub.ADD;
8556: RAISE fnd_api.g_exc_error;
8557: END IF;
8558:

Line 8680: inv_quantity_tree_pub.update_quantities(

8676:
8677: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
8678: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
8679: -- in order to get correct att.
8680: inv_quantity_tree_pub.update_quantities(
8681: p_api_version_number => 1.0
8682: , p_init_msg_lst => fnd_api.g_false
8683: , x_return_status => l_return_status
8684: , x_msg_count => l_msg_cnt

Line 8688: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8684: , x_msg_count => l_msg_cnt
8685: , x_msg_data => l_msg_data
8686: , p_organization_id => p_org_id
8687: , p_inventory_item_id => p_item_id
8688: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8689: , p_is_revision_control => b_is_revision_control
8690: , p_is_lot_control => TRUE
8691: , p_is_serial_control => b_is_serial_control
8692: , p_revision => NVL(p_rev, NULL)

Line 8726: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8722: mydebug('calling update qty tree with lpn 3rd time failed ');
8723: END IF;
8724:
8725: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8726: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8727: fnd_msg_pub.ADD;
8728: RAISE fnd_api.g_exc_error;
8729: END IF;
8730: --Bug#5649056: only update if subinventory and locator match

Line 8732: inv_quantity_tree_pub.update_quantities(

8728: RAISE fnd_api.g_exc_error;
8729: END IF;
8730: --Bug#5649056: only update if subinventory and locator match
8731: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
8732: inv_quantity_tree_pub.update_quantities(
8733: p_api_version_number => 1.0
8734: , p_init_msg_lst => fnd_api.g_false
8735: , x_return_status => l_return_status
8736: , x_msg_count => l_msg_cnt

Line 8740: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8736: , x_msg_count => l_msg_cnt
8737: , x_msg_data => l_msg_data
8738: , p_organization_id => p_org_id
8739: , p_inventory_item_id => p_item_id
8740: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8741: , p_is_revision_control => b_is_revision_control
8742: , p_is_lot_control => TRUE
8743: , p_is_serial_control => b_is_serial_control
8744: , p_revision => NVL(p_rev, NULL)

Line 8778: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8774: mydebug('calling update qty tree back without lpn 3rd time failed ');
8775: END IF;
8776:
8777: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8778: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8779: fnd_msg_pub.ADD;
8780: RAISE fnd_api.g_exc_error;
8781: END IF;
8782: END IF;

Line 8904: inv_quantity_tree_pub.update_quantities(

8900:
8901: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
8902: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
8903: -- in order to get correct att.
8904: inv_quantity_tree_pub.update_quantities(
8905: p_api_version_number => 1.0
8906: , p_init_msg_lst => fnd_api.g_false
8907: , x_return_status => l_return_status
8908: , x_msg_count => l_msg_cnt

Line 8912: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8908: , x_msg_count => l_msg_cnt
8909: , x_msg_data => l_msg_data
8910: , p_organization_id => p_org_id
8911: , p_inventory_item_id => p_item_id
8912: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8913: , p_is_revision_control => b_is_revision_control
8914: , p_is_lot_control => FALSE
8915: , p_is_serial_control => b_is_serial_control
8916: , p_revision => NVL(p_rev, NULL)

Line 8950: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8946: mydebug('calling update qty tree with lpn 4th time failed ');
8947: END IF;
8948:
8949: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
8950: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
8951: fnd_msg_pub.ADD;
8952: RAISE fnd_api.g_exc_error;
8953: END IF;
8954: --Bug#5649056: only update if subinventory and locator match

Line 8957: inv_quantity_tree_pub.update_quantities(

8953: END IF;
8954: --Bug#5649056: only update if subinventory and locator match
8955: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
8956:
8957: inv_quantity_tree_pub.update_quantities(
8958: p_api_version_number => 1.0
8959: , p_init_msg_lst => fnd_api.g_false
8960: , x_return_status => l_return_status
8961: , x_msg_count => l_msg_cnt

Line 8965: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

8961: , x_msg_count => l_msg_cnt
8962: , x_msg_data => l_msg_data
8963: , p_organization_id => p_org_id
8964: , p_inventory_item_id => p_item_id
8965: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
8966: , p_is_revision_control => b_is_revision_control
8967: , p_is_lot_control => FALSE
8968: , p_is_serial_control => b_is_serial_control
8969: , p_revision => NVL(p_rev, NULL)

Line 9003: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

8999: mydebug('calling update qty tree without lpn 4th time failed ');
9000: END IF;
9001:
9002: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9003: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9004: fnd_msg_pub.ADD;
9005: RAISE fnd_api.g_exc_error;
9006: END IF;
9007: END IF;

Line 9009: inv_quantity_tree_pub.query_quantities(

9005: RAISE fnd_api.g_exc_error;
9006: END IF;
9007: END IF;
9008:
9009: inv_quantity_tree_pub.query_quantities(
9010: p_api_version_number => 1.0
9011: , p_init_msg_lst => fnd_api.g_false
9012: , x_return_status => l_return_status
9013: , x_msg_count => l_msg_cnt

Line 9017: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode --??

9013: , x_msg_count => l_msg_cnt
9014: , x_msg_data => l_msg_data
9015: , p_organization_id => p_org_id
9016: , p_inventory_item_id => p_item_id
9017: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode --??
9018: , p_is_revision_control => b_is_revision_control
9019: , p_is_lot_control => FALSE
9020: , p_is_serial_control => b_is_serial_control
9021: , p_demand_source_type_id => -9999

Line 9110: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

9106: mydebug('calling qty tree 4th time failed');
9107: END IF;
9108:
9109: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9110: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9111: fnd_msg_pub.ADD;
9112: RAISE fnd_api.g_exc_error;
9113: END IF;
9114:

Line 9118: inv_quantity_tree_pub.update_quantities(

9114:
9115: IF NVL(l_allocated_lpn_id, 0) = p_fromlpn_id THEN
9116: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
9117: -- in order to get correct att.
9118: inv_quantity_tree_pub.update_quantities(
9119: p_api_version_number => 1.0
9120: , p_init_msg_lst => fnd_api.g_false
9121: , x_return_status => l_return_status
9122: , x_msg_count => l_msg_cnt

Line 9126: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

9122: , x_msg_count => l_msg_cnt
9123: , x_msg_data => l_msg_data
9124: , p_organization_id => p_org_id
9125: , p_inventory_item_id => p_item_id
9126: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9127: , p_is_revision_control => b_is_revision_control
9128: , p_is_lot_control => FALSE
9129: , p_is_serial_control => b_is_serial_control
9130: , p_revision => NVL(p_rev, NULL)

Line 9164: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

9160: mydebug('calling update qty tree back with lpn 4th time failed ');
9161: END IF;
9162:
9163: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9164: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9165: fnd_msg_pub.ADD;
9166: RAISE fnd_api.g_exc_error;
9167: END IF;
9168: --Bug#5649056: only update if subinventory and locator match

Line 9170: inv_quantity_tree_pub.update_quantities(

9166: RAISE fnd_api.g_exc_error;
9167: END IF;
9168: --Bug#5649056: only update if subinventory and locator match
9169: ELSIF ( l_lpn_sub = l_mmtt_sub AND l_lpn_loc = l_mmtt_loc ) THEN
9170: inv_quantity_tree_pub.update_quantities(
9171: p_api_version_number => 1.0
9172: , p_init_msg_lst => fnd_api.g_false
9173: , x_return_status => l_return_status
9174: , x_msg_count => l_msg_cnt

Line 9178: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

9174: , x_msg_count => l_msg_cnt
9175: , x_msg_data => l_msg_data
9176: , p_organization_id => p_org_id
9177: , p_inventory_item_id => p_item_id
9178: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
9179: , p_is_revision_control => b_is_revision_control
9180: , p_is_lot_control => FALSE
9181: , p_is_serial_control => b_is_serial_control
9182: , p_revision => NVL(p_rev, NULL)

Line 9216: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

9212: mydebug('calling update qty tree back without lpn 4th time failed ');
9213: END IF;
9214:
9215: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
9216: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
9217: fnd_msg_pub.ADD;
9218: RAISE fnd_api.g_exc_error;
9219: END IF;
9220: END IF;

Line 10053: p_tree_mode => inv_quantity_tree_pub.g_loose_only_mode,

10049: -- always do one query at least for non lot controlled items
10050:
10051: INV_TXN_VALIDATIONS.get_available_quantity
10052: (x_return_status => l_return_status,
10053: p_tree_mode => inv_quantity_tree_pub.g_loose_only_mode,
10054: p_organization_id =>p_org_id,
10055: p_inventory_item_id => p_item_id,
10056: p_is_revision_control =>p_is_revision_control,
10057: p_is_lot_control =>p_is_lot_control,

Line 10196: fnd_message.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

10192: IF (l_debug = 1) THEN
10193: mydebug('calling qty tree 1st time failed ');
10194: END IF;
10195: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
10196: fnd_message.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
10197: fnd_msg_pub.ADD;
10198: RAISE fnd_api.g_exc_error;
10199: END IF;
10200: