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_DISPATCH_GEN dependencies on INV_QUANTITY_TREE_PUB

Line 3078: inv_quantity_tree_pub.clear_quantity_cache;

3074: RAISE fnd_api.g_exc_error;
3075: END;
3076:
3077: -- clear quantity cache before we create qty tree.
3078: inv_quantity_tree_pub.clear_quantity_cache;
3079:
3080: -- Check if LPN has items other than the one requested
3081:
3082: IF (l_debug = 1) THEN

Line 3185: inv_quantity_tree_pub.update_quantities(

3181: END IF;*/
3182: IF NVL(l_allocated_lpn_id, 0) = p_lpn THEN
3183: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
3184: -- in order to get correct att.
3185: inv_quantity_tree_pub.update_quantities(
3186: p_api_version_number => 1.0
3187: , p_init_msg_lst => fnd_api.g_false
3188: , x_return_status => l_return_status
3189: , x_msg_count => l_msg_cnt

Line 3193: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3189: , x_msg_count => l_msg_cnt
3190: , x_msg_data => l_msg_data
3191: , p_organization_id => p_org_id
3192: , p_inventory_item_id => p_item_id
3193: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3194: , p_is_revision_control => b_is_revision_control
3195: , p_is_lot_control => TRUE
3196: , p_is_serial_control => b_is_serial_control
3197: , p_revision => NVL(p_rev, NULL)

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

3219: mydebug('lpn_match: calling update qty tree with lpn 1st time failed ');
3220: END IF;
3221:
3222: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3223: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3224: fnd_msg_pub.ADD;
3225: RAISE fnd_api.g_exc_error;
3226: END IF;
3227: ELSE

Line 3228: inv_quantity_tree_pub.update_quantities(

3224: fnd_msg_pub.ADD;
3225: RAISE fnd_api.g_exc_error;
3226: END IF;
3227: ELSE
3228: inv_quantity_tree_pub.update_quantities(
3229: p_api_version_number => 1.0
3230: , p_init_msg_lst => fnd_api.g_false
3231: , x_return_status => l_return_status
3232: , x_msg_count => l_msg_cnt

Line 3236: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3232: , x_msg_count => l_msg_cnt
3233: , x_msg_data => l_msg_data
3234: , p_organization_id => p_org_id
3235: , p_inventory_item_id => p_item_id
3236: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3237: , p_is_revision_control => b_is_revision_control
3238: , p_is_lot_control => TRUE
3239: , p_is_serial_control => b_is_serial_control
3240: , p_revision => NVL(p_rev, NULL)

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

3262: mydebug('lpn_match: calling update qty tree back without lpn 1st time failed ');
3263: END IF;
3264:
3265: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3266: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3267: fnd_msg_pub.ADD;
3268: RAISE fnd_api.g_exc_error;
3269: END IF;
3270: END IF;

Line 3272: inv_quantity_tree_pub.query_quantities(

3268: RAISE fnd_api.g_exc_error;
3269: END IF;
3270: END IF;
3271:
3272: inv_quantity_tree_pub.query_quantities(
3273: p_api_version_number => 1.0
3274: , p_init_msg_lst => fnd_api.g_false
3275: , x_return_status => l_return_status
3276: , x_msg_count => l_msg_cnt

Line 3280: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3276: , x_msg_count => l_msg_cnt
3277: , x_msg_data => l_msg_data
3278: , p_organization_id => p_org_id
3279: , p_inventory_item_id => p_item_id
3280: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3281: , p_is_revision_control => b_is_revision_control
3282: , p_is_lot_control => TRUE
3283: , p_is_serial_control => b_is_serial_control
3284: , p_demand_source_type_id => -9999

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

3334: mydebug('lpn_match: calling qty tree 1st time failed ');
3335: END IF;
3336:
3337: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3338: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3339: fnd_msg_pub.ADD;
3340: RAISE fnd_api.g_exc_error;
3341: END IF;
3342:

Line 3346: inv_quantity_tree_pub.update_quantities(

3342:
3343: IF NVL(l_allocated_lpn_id, 0) = p_lpn THEN
3344: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
3345: -- in order to get correct att.
3346: inv_quantity_tree_pub.update_quantities(
3347: p_api_version_number => 1.0
3348: , p_init_msg_lst => fnd_api.g_false
3349: , x_return_status => l_return_status
3350: , x_msg_count => l_msg_cnt

Line 3354: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3350: , x_msg_count => l_msg_cnt
3351: , x_msg_data => l_msg_data
3352: , p_organization_id => p_org_id
3353: , p_inventory_item_id => p_item_id
3354: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3355: , p_is_revision_control => b_is_revision_control
3356: , p_is_lot_control => TRUE
3357: , p_is_serial_control => b_is_serial_control
3358: , p_revision => NVL(p_rev, NULL)

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

3380: mydebug('lpn_match: calling update qty tree back with lpn 1st time failed ');
3381: END IF;
3382:
3383: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3384: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3385: fnd_msg_pub.ADD;
3386: RAISE fnd_api.g_exc_error;
3387: END IF;
3388: ELSE

Line 3389: inv_quantity_tree_pub.update_quantities(

3385: fnd_msg_pub.ADD;
3386: RAISE fnd_api.g_exc_error;
3387: END IF;
3388: ELSE
3389: inv_quantity_tree_pub.update_quantities(
3390: p_api_version_number => 1.0
3391: , p_init_msg_lst => fnd_api.g_false
3392: , x_return_status => l_return_status
3393: , x_msg_count => l_msg_cnt

Line 3397: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3393: , x_msg_count => l_msg_cnt
3394: , x_msg_data => l_msg_data
3395: , p_organization_id => p_org_id
3396: , p_inventory_item_id => p_item_id
3397: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3398: , p_is_revision_control => b_is_revision_control
3399: , p_is_lot_control => TRUE
3400: , p_is_serial_control => b_is_serial_control
3401: , p_revision => NVL(p_rev, NULL)

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

3423: mydebug('lpn_match: calling update qty tree back without lpn 1st time failed ');
3424: END IF;
3425:
3426: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3427: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3428: fnd_msg_pub.ADD;
3429: RAISE fnd_api.g_exc_error;
3430: END IF;
3431: END IF;

Line 3522: inv_quantity_tree_pub.update_quantities(

3518:
3519: IF NVL(l_allocated_lpn_id, 0) = p_lpn THEN
3520: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
3521: -- in order to get correct att.
3522: inv_quantity_tree_pub.update_quantities(
3523: p_api_version_number => 1.0
3524: , p_init_msg_lst => fnd_api.g_false
3525: , x_return_status => l_return_status
3526: , x_msg_count => l_msg_cnt

Line 3530: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3526: , x_msg_count => l_msg_cnt
3527: , x_msg_data => l_msg_data
3528: , p_organization_id => p_org_id
3529: , p_inventory_item_id => p_item_id
3530: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3531: , p_is_revision_control => b_is_revision_control
3532: , p_is_lot_control => FALSE
3533: , p_is_serial_control => b_is_serial_control
3534: , p_revision => NVL(p_rev, NULL)

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

3556: mydebug('lpn_match: calling update qty tree with lpn 2nd time failed ');
3557: END IF;
3558:
3559: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3560: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3561: fnd_msg_pub.ADD;
3562: RAISE fnd_api.g_exc_error;
3563: END IF;
3564: ELSE

Line 3565: inv_quantity_tree_pub.update_quantities(

3561: fnd_msg_pub.ADD;
3562: RAISE fnd_api.g_exc_error;
3563: END IF;
3564: ELSE
3565: inv_quantity_tree_pub.update_quantities(
3566: p_api_version_number => 1.0
3567: , p_init_msg_lst => fnd_api.g_false
3568: , x_return_status => l_return_status
3569: , x_msg_count => l_msg_cnt

Line 3573: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3569: , x_msg_count => l_msg_cnt
3570: , x_msg_data => l_msg_data
3571: , p_organization_id => p_org_id
3572: , p_inventory_item_id => p_item_id
3573: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3574: , p_is_revision_control => b_is_revision_control
3575: , p_is_lot_control => FALSE
3576: , p_is_serial_control => b_is_serial_control
3577: , p_revision => NVL(p_rev, NULL)

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

3599: mydebug('lpn_match: calling update qty tree back without lpn 2nd time failed ');
3600: END IF;
3601:
3602: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3603: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3604: fnd_msg_pub.ADD;
3605: RAISE fnd_api.g_exc_error;
3606: END IF;
3607: END IF;

Line 3609: inv_quantity_tree_pub.query_quantities(

3605: RAISE fnd_api.g_exc_error;
3606: END IF;
3607: END IF;
3608:
3609: inv_quantity_tree_pub.query_quantities(
3610: p_api_version_number => 1.0
3611: , p_init_msg_lst => fnd_api.g_false
3612: , x_return_status => l_return_status
3613: , x_msg_count => l_msg_cnt

Line 3617: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3613: , x_msg_count => l_msg_cnt
3614: , x_msg_data => l_msg_data
3615: , p_organization_id => p_org_id
3616: , p_inventory_item_id => p_item_id
3617: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3618: , p_is_revision_control => b_is_revision_control
3619: , p_is_lot_control => FALSE
3620: , p_is_serial_control => b_is_serial_control
3621: , p_demand_source_type_id => -9999

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

3640: mydebug('lpn_match: calling qty tree 2nd time failed ');
3641: END IF;
3642:
3643: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3644: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3645: fnd_msg_pub.ADD;
3646: RAISE fnd_api.g_exc_error;
3647: END IF;
3648:

Line 3652: inv_quantity_tree_pub.update_quantities(

3648:
3649: IF NVL(l_allocated_lpn_id, 0) = p_lpn THEN
3650: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
3651: -- in order to get correct att.
3652: inv_quantity_tree_pub.update_quantities(
3653: p_api_version_number => 1.0
3654: , p_init_msg_lst => fnd_api.g_false
3655: , x_return_status => l_return_status
3656: , x_msg_count => l_msg_cnt

Line 3660: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3656: , x_msg_count => l_msg_cnt
3657: , x_msg_data => l_msg_data
3658: , p_organization_id => p_org_id
3659: , p_inventory_item_id => p_item_id
3660: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3661: , p_is_revision_control => b_is_revision_control
3662: , p_is_lot_control => FALSE
3663: , p_is_serial_control => b_is_serial_control
3664: , p_revision => NVL(p_rev, NULL)

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

3686: mydebug('lpn_match: calling update qty tree with lpn 2nd time failed ');
3687: END IF;
3688:
3689: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3690: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3691: fnd_msg_pub.ADD;
3692: RAISE fnd_api.g_exc_error;
3693: END IF;
3694: ELSE

Line 3695: inv_quantity_tree_pub.update_quantities(

3691: fnd_msg_pub.ADD;
3692: RAISE fnd_api.g_exc_error;
3693: END IF;
3694: ELSE
3695: inv_quantity_tree_pub.update_quantities(
3696: p_api_version_number => 1.0
3697: , p_init_msg_lst => fnd_api.g_false
3698: , x_return_status => l_return_status
3699: , x_msg_count => l_msg_cnt

Line 3703: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3699: , x_msg_count => l_msg_cnt
3700: , x_msg_data => l_msg_data
3701: , p_organization_id => p_org_id
3702: , p_inventory_item_id => p_item_id
3703: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3704: , p_is_revision_control => b_is_revision_control
3705: , p_is_lot_control => FALSE
3706: , p_is_serial_control => b_is_serial_control
3707: , p_revision => NVL(p_rev, NULL)

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

3729: mydebug('lpn_match: calling update qty tree back without lpn 2nd time failed ');
3730: END IF;
3731:
3732: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3733: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3734: fnd_msg_pub.ADD;
3735: RAISE fnd_api.g_exc_error;
3736: END IF;
3737: END IF;

Line 3905: inv_quantity_tree_pub.update_quantities(

3901: END IF;*/
3902: IF NVL(l_allocated_lpn_id, 0) = p_lpn THEN
3903: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
3904: -- in order to get correct att.
3905: inv_quantity_tree_pub.update_quantities(
3906: p_api_version_number => 1.0
3907: , p_init_msg_lst => fnd_api.g_false
3908: , x_return_status => l_return_status
3909: , x_msg_count => l_msg_cnt

Line 3913: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3909: , x_msg_count => l_msg_cnt
3910: , x_msg_data => l_msg_data
3911: , p_organization_id => p_org_id
3912: , p_inventory_item_id => p_item_id
3913: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3914: , p_is_revision_control => b_is_revision_control
3915: , p_is_lot_control => TRUE
3916: , p_is_serial_control => b_is_serial_control
3917: , p_revision => NVL(p_rev, NULL)

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

3939: mydebug('lpn_match: calling update qty tree with lpn 3rd time failed ');
3940: END IF;
3941:
3942: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3943: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3944: fnd_msg_pub.ADD;
3945: RAISE fnd_api.g_exc_error;
3946: END IF;
3947: ELSE

Line 3948: inv_quantity_tree_pub.update_quantities(

3944: fnd_msg_pub.ADD;
3945: RAISE fnd_api.g_exc_error;
3946: END IF;
3947: ELSE
3948: inv_quantity_tree_pub.update_quantities(
3949: p_api_version_number => 1.0
3950: , p_init_msg_lst => fnd_api.g_false
3951: , x_return_status => l_return_status
3952: , x_msg_count => l_msg_cnt

Line 3956: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3952: , x_msg_count => l_msg_cnt
3953: , x_msg_data => l_msg_data
3954: , p_organization_id => p_org_id
3955: , p_inventory_item_id => p_item_id
3956: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
3957: , p_is_revision_control => b_is_revision_control
3958: , p_is_lot_control => TRUE
3959: , p_is_serial_control => b_is_serial_control
3960: , p_revision => NVL(p_rev, NULL)

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

3982: mydebug('lpn_match: calling update qty tree back 3rd time without lpn 3rd time failed ');
3983: END IF;
3984:
3985: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3986: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3987: fnd_msg_pub.ADD;
3988: RAISE fnd_api.g_exc_error;
3989: END IF;
3990: END IF;

Line 3992: inv_quantity_tree_pub.query_quantities(

3988: RAISE fnd_api.g_exc_error;
3989: END IF;
3990: END IF;
3991:
3992: inv_quantity_tree_pub.query_quantities(
3993: p_api_version_number => 1.0
3994: , p_init_msg_lst => fnd_api.g_false
3995: , x_return_status => l_return_status
3996: , x_msg_count => l_msg_cnt

Line 4000: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

3996: , x_msg_count => l_msg_cnt
3997: , x_msg_data => l_msg_data
3998: , p_organization_id => p_org_id
3999: , p_inventory_item_id => p_item_id
4000: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
4001: , p_is_revision_control => b_is_revision_control
4002: , p_is_lot_control => TRUE
4003: , p_is_serial_control => b_is_serial_control
4004: , p_demand_source_type_id => -9999

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

4065: mydebug('lpn_match: calling qty tree 3rd time failed ');
4066: END IF;
4067:
4068: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4069: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4070: fnd_msg_pub.ADD;
4071: RAISE fnd_api.g_exc_error;
4072: END IF;
4073:

Line 4126: inv_quantity_tree_pub.update_quantities(

4122:
4123: IF NVL(l_allocated_lpn_id, 0) = p_lpn THEN
4124: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
4125: -- in order to get correct att.
4126: inv_quantity_tree_pub.update_quantities(
4127: p_api_version_number => 1.0
4128: , p_init_msg_lst => fnd_api.g_false
4129: , x_return_status => l_return_status
4130: , x_msg_count => l_msg_cnt

Line 4134: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

4130: , x_msg_count => l_msg_cnt
4131: , x_msg_data => l_msg_data
4132: , p_organization_id => p_org_id
4133: , p_inventory_item_id => p_item_id
4134: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
4135: , p_is_revision_control => b_is_revision_control
4136: , p_is_lot_control => TRUE
4137: , p_is_serial_control => b_is_serial_control
4138: , p_revision => NVL(p_rev, NULL)

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

4160: mydebug('lpn_match: calling update qty tree with lpn 3rd time failed ');
4161: END IF;
4162:
4163: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4164: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4165: fnd_msg_pub.ADD;
4166: RAISE fnd_api.g_exc_error;
4167: END IF;
4168: ELSE

Line 4169: inv_quantity_tree_pub.update_quantities(

4165: fnd_msg_pub.ADD;
4166: RAISE fnd_api.g_exc_error;
4167: END IF;
4168: ELSE
4169: inv_quantity_tree_pub.update_quantities(
4170: p_api_version_number => 1.0
4171: , p_init_msg_lst => fnd_api.g_false
4172: , x_return_status => l_return_status
4173: , x_msg_count => l_msg_cnt

Line 4177: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

4173: , x_msg_count => l_msg_cnt
4174: , x_msg_data => l_msg_data
4175: , p_organization_id => p_org_id
4176: , p_inventory_item_id => p_item_id
4177: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
4178: , p_is_revision_control => b_is_revision_control
4179: , p_is_lot_control => TRUE
4180: , p_is_serial_control => b_is_serial_control
4181: , p_revision => NVL(p_rev, NULL)

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

4203: mydebug('lpn_match: calling update qty tree back without lpn 3rd time failed ');
4204: END IF;
4205:
4206: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4207: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4208: fnd_msg_pub.ADD;
4209: RAISE fnd_api.g_exc_error;
4210: END IF;
4211: END IF;

Line 4355: inv_quantity_tree_pub.update_quantities(

4351: END IF;*/
4352: IF NVL(l_allocated_lpn_id, 0) = p_lpn THEN
4353: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
4354: -- in order to get correct att.
4355: inv_quantity_tree_pub.update_quantities(
4356: p_api_version_number => 1.0
4357: , p_init_msg_lst => fnd_api.g_false
4358: , x_return_status => l_return_status
4359: , x_msg_count => l_msg_cnt

Line 4363: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

4359: , x_msg_count => l_msg_cnt
4360: , x_msg_data => l_msg_data
4361: , p_organization_id => p_org_id
4362: , p_inventory_item_id => p_item_id
4363: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
4364: , p_is_revision_control => b_is_revision_control
4365: , p_is_lot_control => FALSE
4366: , p_is_serial_control => b_is_serial_control
4367: , p_revision => NVL(p_rev, NULL)

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

4389: mydebug('lpn_match: calling update qty tree with lpn 4th time failed ');
4390: END IF;
4391:
4392: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4393: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4394: fnd_msg_pub.ADD;
4395: RAISE fnd_api.g_exc_error;
4396: END IF;
4397: ELSE

Line 4398: inv_quantity_tree_pub.update_quantities(

4394: fnd_msg_pub.ADD;
4395: RAISE fnd_api.g_exc_error;
4396: END IF;
4397: ELSE
4398: inv_quantity_tree_pub.update_quantities(
4399: p_api_version_number => 1.0
4400: , p_init_msg_lst => fnd_api.g_false
4401: , x_return_status => l_return_status
4402: , x_msg_count => l_msg_cnt

Line 4406: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

4402: , x_msg_count => l_msg_cnt
4403: , x_msg_data => l_msg_data
4404: , p_organization_id => p_org_id
4405: , p_inventory_item_id => p_item_id
4406: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
4407: , p_is_revision_control => b_is_revision_control
4408: , p_is_lot_control => FALSE
4409: , p_is_serial_control => b_is_serial_control
4410: , p_revision => NVL(p_rev, NULL)

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

4432: mydebug('lpn_match: calling update qty tree without lpn 4th time failed ');
4433: END IF;
4434:
4435: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4436: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4437: fnd_msg_pub.ADD;
4438: RAISE fnd_api.g_exc_error;
4439: END IF;
4440: END IF;

Line 4442: inv_quantity_tree_pub.query_quantities(

4438: RAISE fnd_api.g_exc_error;
4439: END IF;
4440: END IF;
4441:
4442: inv_quantity_tree_pub.query_quantities(
4443: p_api_version_number => 1.0
4444: , p_init_msg_lst => fnd_api.g_false
4445: , x_return_status => l_return_status
4446: , x_msg_count => l_msg_cnt

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

4446: , x_msg_count => l_msg_cnt
4447: , x_msg_data => l_msg_data
4448: , p_organization_id => p_org_id
4449: , p_inventory_item_id => p_item_id
4450: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode --??
4451: , p_is_revision_control => b_is_revision_control
4452: , p_is_lot_control => FALSE
4453: , p_is_serial_control => b_is_serial_control
4454: , p_demand_source_type_id => -9999

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

4513: mydebug('lpn_match: calling qty tree 4th time failed');
4514: END IF;
4515:
4516: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4517: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4518: fnd_msg_pub.ADD;
4519: RAISE fnd_api.g_exc_error;
4520: END IF;
4521:

Line 4525: inv_quantity_tree_pub.update_quantities(

4521:
4522: IF NVL(l_allocated_lpn_id, 0) = p_lpn THEN
4523: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
4524: -- in order to get correct att.
4525: inv_quantity_tree_pub.update_quantities(
4526: p_api_version_number => 1.0
4527: , p_init_msg_lst => fnd_api.g_false
4528: , x_return_status => l_return_status
4529: , x_msg_count => l_msg_cnt

Line 4533: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

4529: , x_msg_count => l_msg_cnt
4530: , x_msg_data => l_msg_data
4531: , p_organization_id => p_org_id
4532: , p_inventory_item_id => p_item_id
4533: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
4534: , p_is_revision_control => b_is_revision_control
4535: , p_is_lot_control => FALSE
4536: , p_is_serial_control => b_is_serial_control
4537: , p_revision => NVL(p_rev, NULL)

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

4559: mydebug('lpn_match: calling update qty tree back with lpn 4th time failed ');
4560: END IF;
4561:
4562: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4563: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4564: fnd_msg_pub.ADD;
4565: RAISE fnd_api.g_exc_error;
4566: END IF;
4567: ELSE

Line 4568: inv_quantity_tree_pub.update_quantities(

4564: fnd_msg_pub.ADD;
4565: RAISE fnd_api.g_exc_error;
4566: END IF;
4567: ELSE
4568: inv_quantity_tree_pub.update_quantities(
4569: p_api_version_number => 1.0
4570: , p_init_msg_lst => fnd_api.g_false
4571: , x_return_status => l_return_status
4572: , x_msg_count => l_msg_cnt

Line 4576: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

4572: , x_msg_count => l_msg_cnt
4573: , x_msg_data => l_msg_data
4574: , p_organization_id => p_org_id
4575: , p_inventory_item_id => p_item_id
4576: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
4577: , p_is_revision_control => b_is_revision_control
4578: , p_is_lot_control => FALSE
4579: , p_is_serial_control => b_is_serial_control
4580: , p_revision => NVL(p_rev, NULL)

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

4602: mydebug('lpn_match: calling update qty tree back without lpn 4th time failed ');
4603: END IF;
4604:
4605: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
4606: fnd_message.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4607: fnd_msg_pub.ADD;
4608: RAISE fnd_api.g_exc_error;
4609: END IF;
4610: END IF;

Line 4932: inv_quantity_tree_pub.update_quantities

4928:
4929: /*IF nvl(l_allocated_lpn_id, 0) = p_lpn THEN
4930: --from lpn is the same as allocated_lpn, we need to update qty tree as negative qty
4931: -- in order to get correct att.
4932: inv_quantity_tree_pub.update_quantities
4933: ( p_api_version_number => 1.0
4934: , p_init_msg_lst => fnd_api.g_false
4935: , x_return_status => l_return_status
4936: , x_msg_count => l_msg_cnt

Line 4940: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

4936: , x_msg_count => l_msg_cnt
4937: , x_msg_data => l_msg_data
4938: , p_organization_id => p_org_id
4939: , p_inventory_item_id => p_item_id
4940: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
4941: , p_is_revision_control => b_is_revision_control
4942: , p_is_lot_control => b_is_lot_control
4943: , p_is_serial_control => b_is_serial_control
4944: --, p_demand_source_type_id => NULL

Line 4961: inv_quantity_tree_pub.update_quantities

4957: , p_lpn_id => p_lpn
4958: , p_transfer_subinventory_code => l_xfr_sub_code
4959: );
4960: ELSE
4961: inv_quantity_tree_pub.update_quantities
4962: ( p_api_version_number => 1.0
4963: , p_init_msg_lst => fnd_api.g_false
4964: , x_return_status => l_return_status
4965: , x_msg_count => l_msg_cnt

Line 4969: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

4965: , x_msg_count => l_msg_cnt
4966: , x_msg_data => l_msg_data
4967: , p_organization_id => p_org_id
4968: , p_inventory_item_id => p_item_id
4969: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
4970: , p_is_revision_control => b_is_revision_control
4971: , p_is_lot_control => b_is_lot_control
4972: , p_is_serial_control => b_is_serial_control
4973: --, p_demand_source_type_id => NULL