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.INV_RESERVATION_PVT dependencies on INV_QUANTITY_TREE_PVT

Line 3033: inv_quantity_tree_pvt.query_tree(

3029: l_dual_control := TRUE;
3030: END IF;
3031:
3032: -- INVCONV Include secondary parameters below
3033: inv_quantity_tree_pvt.query_tree(
3034: p_api_version_number => 1.0
3035: , p_init_msg_lst => fnd_api.g_true
3036: , x_return_status => l_return_status
3037: , x_msg_count => l_msg_count

Line 3191: l_quantity_type := inv_quantity_tree_pvt.g_qr_same_demand;

3187: END IF;
3188: END IF;
3189: END IF;
3190:
3191: l_quantity_type := inv_quantity_tree_pvt.g_qr_same_demand;
3192: --
3193: inv_quantity_tree_pvt.update_quantities(
3194: p_api_version_number => 1.0
3195: , p_init_msg_lst => fnd_api.g_true

Line 3193: inv_quantity_tree_pvt.update_quantities(

3189: END IF;
3190:
3191: l_quantity_type := inv_quantity_tree_pvt.g_qr_same_demand;
3192: --
3193: inv_quantity_tree_pvt.update_quantities(
3194: p_api_version_number => 1.0
3195: , p_init_msg_lst => fnd_api.g_true
3196: , x_return_status => l_return_status
3197: , x_msg_count => l_msg_count

Line 3358: inv_quantity_tree_pvt.update_quantities(

3354: END IF; -- INVCONV
3355: --
3356: IF p_from_supply_source_type_id = inv_reservation_global.g_source_type_inv THEN
3357: -- INVCONV - Incorporate secondaries
3358: inv_quantity_tree_pvt.update_quantities(
3359: p_api_version_number => 1.0
3360: , p_init_msg_lst => fnd_api.g_true
3361: , x_return_status => l_return_status
3362: , x_msg_count => l_msg_count

Line 3371: , p_quantity_type => inv_quantity_tree_pvt.g_qr_other_demand

3367: , p_subinventory_code => p_from_subinventory_code
3368: , p_locator_id => p_from_locator_id
3369: , p_primary_quantity => l_net_qty1
3370: , p_secondary_quantity => l_secondary_net_qty1
3371: , p_quantity_type => inv_quantity_tree_pvt.g_qr_other_demand
3372: , x_qoh => l_qoh
3373: , x_rqoh => l_rqoh
3374: , x_qr => l_qr
3375: , x_qs => l_qs

Line 3430: inv_quantity_tree_pvt.update_quantities(

3426: END IF;
3427:
3428: --
3429: -- INVCONV - Incorporate secondaries into call
3430: inv_quantity_tree_pvt.update_quantities(
3431: p_api_version_number => 1.0
3432: , p_init_msg_lst => fnd_api.g_true
3433: , x_return_status => l_return_status
3434: , x_msg_count => l_msg_count

Line 3443: , p_quantity_type => inv_quantity_tree_pvt.g_qr_other_demand

3439: , p_subinventory_code => p_from_subinventory_code
3440: , p_locator_id => p_from_locator_id
3441: , p_primary_quantity => l_net_qty1
3442: , p_secondary_quantity => l_secondary_net_qty1
3443: , p_quantity_type => inv_quantity_tree_pvt.g_qr_other_demand
3444: , x_qoh => l_qoh
3445: , x_rqoh => l_rqoh
3446: , x_qr => l_qr
3447: , x_qs => l_qs

Line 3464: inv_quantity_tree_pvt.update_quantities(

3460: IF l_return_status = fnd_api.g_ret_sts_error THEN
3461: -- fail to modify in tree2
3462: -- undo the modification in tree1
3463: -- INVCONV - Incorporate secondaries into call
3464: inv_quantity_tree_pvt.update_quantities(
3465: p_api_version_number => 1.0
3466: , p_init_msg_lst => fnd_api.g_true
3467: , x_return_status => l_return_status
3468: , x_msg_count => l_msg_count

Line 3477: , p_quantity_type => inv_quantity_tree_pvt.g_qr_same_demand

3473: , p_subinventory_code => p_from_subinventory_code
3474: , p_locator_id => p_from_locator_id
3475: , p_primary_quantity => -l_net_qty1
3476: , p_secondary_quantity => -l_secondary_net_qty1
3477: , p_quantity_type => inv_quantity_tree_pvt.g_qr_same_demand
3478: , x_qoh => l_qoh
3479: , x_rqoh => l_rqoh
3480: , x_qr => l_qr
3481: , x_qs => l_qs

Line 3524: inv_quantity_tree_pvt.query_tree(

3520: debug_print('Validate Qty :Action Update');
3521: END IF;
3522:
3523: -- INVCONV - Incorporate secondaries into call
3524: inv_quantity_tree_pvt.query_tree(
3525: p_api_version_number => 1.0
3526: , p_init_msg_lst => fnd_api.g_true
3527: , x_return_status => l_return_status
3528: , x_msg_count => l_msg_count

Line 3597: inv_quantity_tree_pvt.update_quantities(

3593: AND p_check_availability = fnd_api.g_true )THEN
3594: --rollback quantity tree changes .
3595: IF l_modify_tree1 THEN
3596: -- INVCONV Incorporate secondaries
3597: inv_quantity_tree_pvt.update_quantities(
3598: p_api_version_number => 1.0
3599: , p_init_msg_lst => fnd_api.g_true
3600: , x_return_status => l_return_status
3601: , x_msg_count => l_msg_count

Line 3610: , p_quantity_type => inv_quantity_tree_pvt.g_qr_same_demand

3606: , p_subinventory_code => p_from_subinventory_code
3607: , p_locator_id => p_from_locator_id
3608: , p_primary_quantity => -l_net_qty1
3609: , p_secondary_quantity => -l_secondary_net_qty1
3610: , p_quantity_type => inv_quantity_tree_pvt.g_qr_same_demand
3611: , x_qoh => l_qoh
3612: , x_rqoh => l_rqoh
3613: , x_qr => l_qr
3614: , x_qs => l_qs

Line 3654: inv_quantity_tree_pvt.update_quantities(

3650: -- The from tree must also be updated with the quantity, since the
3651: -- from tree and the to tree are for the same organization and item
3652:
3653: -- INVCONV Incorporate Secondaries in call
3654: inv_quantity_tree_pvt.update_quantities(
3655: p_api_version_number => 1.0
3656: , p_init_msg_lst => fnd_api.g_true
3657: , x_return_status => l_return_status
3658: , x_msg_count => l_msg_count

Line 3667: , p_quantity_type => inv_quantity_tree_pvt.g_qr_other_demand

3663: , p_subinventory_code => p_from_subinventory_code
3664: , p_locator_id => p_from_locator_id
3665: , p_primary_quantity => l_net_qty2
3666: , p_secondary_quantity => l_secondary_net_qty2
3667: , p_quantity_type => inv_quantity_tree_pvt.g_qr_other_demand
3668: , x_qoh => l_qoh
3669: , x_rqoh => l_rqoh
3670: , x_qr => l_qr
3671: , x_qs => l_qs

Line 3687: inv_quantity_tree_pvt.update_quantities(

3683: IF l_return_status = fnd_api.g_ret_sts_success
3684: AND l_modify_tree2 THEN
3685:
3686: -- INVCONV Incorporate Secondaries in call
3687: inv_quantity_tree_pvt.update_quantities(
3688: p_api_version_number => 1.0
3689: , p_init_msg_lst => fnd_api.g_true
3690: , x_return_status => l_return_status
3691: , x_msg_count => l_msg_count

Line 3700: , p_quantity_type => inv_quantity_tree_pvt.g_qr_same_demand

3696: , p_subinventory_code => p_to_subinventory_code
3697: , p_locator_id => p_to_locator_id
3698: , p_primary_quantity => l_net_qty2
3699: , p_secondary_quantity => l_secondary_net_qty2
3700: , p_quantity_type => inv_quantity_tree_pvt.g_qr_same_demand
3701: , x_qoh => l_qoh
3702: , x_rqoh => l_rqoh
3703: , x_qr => l_qr
3704: , x_qs => l_qs

Line 3722: inv_quantity_tree_pvt.update_quantities(

3718: -- fail to modify in tree2
3719: -- undo the modification in tree1 if l_modify_tree1 is true
3720: IF l_modify_tree1 THEN
3721: -- INVCONV - Incorporate secondaries
3722: inv_quantity_tree_pvt.update_quantities(
3723: p_api_version_number => 1.0
3724: , p_init_msg_lst => fnd_api.g_true
3725: , x_return_status => l_return_status
3726: , x_msg_count => l_msg_count

Line 3735: , p_quantity_type => inv_quantity_tree_pvt.g_qr_same_demand

3731: , p_subinventory_code => p_from_subinventory_code
3732: , p_locator_id => p_from_locator_id
3733: , p_primary_quantity => -l_net_qty1
3734: , p_secondary_quantity => -l_secondary_net_qty1
3735: , p_quantity_type => inv_quantity_tree_pvt.g_qr_same_demand
3736: , x_qoh => l_qoh
3737: , x_rqoh => l_rqoh
3738: , x_qr => l_qr
3739: , x_qs => l_qs

Line 3765: inv_quantity_tree_pvt.update_quantities(

3761:
3762: --
3763: IF l_modify_tree2 THEN
3764: -- INVCONV - Incorporate secondaries
3765: inv_quantity_tree_pvt.update_quantities(
3766: p_api_version_number => 1.0
3767: , p_init_msg_lst => fnd_api.g_true
3768: , x_return_status => l_return_status
3769: , x_msg_count => l_msg_count

Line 3778: , p_quantity_type => inv_quantity_tree_pvt.g_qr_other_demand

3774: , p_subinventory_code => p_from_subinventory_code
3775: , p_locator_id => p_from_locator_id
3776: , p_primary_quantity => -l_net_qty1
3777: , p_secondary_quantity => -l_secondary_net_qty1
3778: , p_quantity_type => inv_quantity_tree_pvt.g_qr_other_demand
3779: , x_qoh => l_qoh
3780: , x_rqoh => l_rqoh
3781: , x_qr => l_qr
3782: , x_qs => l_qs

Line 8896: inv_quantity_tree_pvt.create_tree

8892: -- Bug 2354735: Proceed with Trees only if p_validation_flag = 'T'
8893: IF p_force_reservation_flag <> fnd_api.g_true
8894: AND p_validation_flag = fnd_api.g_true
8895: AND l_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv THEN
8896: inv_quantity_tree_pvt.create_tree
8897: (
8898: p_api_version_number => 1.0
8899: , p_init_msg_lst => fnd_api.g_true
8900: , x_return_status => l_return_status

Line 8905: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode

8901: , x_msg_count => x_msg_count
8902: , x_msg_data => x_msg_data
8903: , p_organization_id => l_rsv_rec.organization_id
8904: , p_inventory_item_id => l_rsv_rec.inventory_item_id
8905: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode
8906: , p_is_revision_control => is_revision_control(l_orig_item_cache_index)
8907: , p_is_lot_control => is_lot_control(l_orig_item_cache_index)
8908: , p_is_serial_control => is_serial_control(l_orig_item_cache_index)
8909: , p_asset_sub_only => FALSE

Line 10669: inv_quantity_tree_pvt.create_tree

10665: debug_print('After adding item to the cache l_orig_item_cache_index: '||l_orig_item_cache_index);
10666: END IF;
10667: -- changes for bug 9874238 end
10668:
10669: inv_quantity_tree_pvt.create_tree
10670: (
10671: p_api_version_number => 1.0
10672: , p_init_msg_lst => fnd_api.g_true
10673: , x_return_status => l_return_status

Line 10678: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode

10674: , x_msg_count => x_msg_count
10675: , x_msg_data => x_msg_data
10676: , p_organization_id => l_orig_rsv_tbl(1).organization_id
10677: , p_inventory_item_id => l_orig_rsv_tbl(1).inventory_item_id
10678: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode
10679: , p_is_revision_control => is_revision_control(l_orig_item_cache_index)
10680: , p_is_lot_control => is_lot_control(l_orig_item_cache_index)
10681: , p_is_serial_control => is_serial_control(l_orig_item_cache_index)
10682: , p_asset_sub_only => FALSE

Line 10717: *inv_quantity_tree_pvt.create_tree

10713: * above and this tree would actually be the same tree, but would
10714: * would have different tree_ids. We don't need to update the same
10715: * tree twice, so we don't need to create the same tree twice.
10716: * Instead, pass NULL to the modify_tree procedure.
10717: *inv_quantity_tree_pvt.create_tree
10718: * (
10719: * p_api_version_number => 1.0
10720: * , p_init_msg_lst => fnd_api.g_true
10721: * , x_return_status => l_return_status

Line 10726: * , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode

10722: * , x_msg_count => x_msg_count
10723: * , x_msg_data => x_msg_data
10724: * , p_organization_id => l_to_rsv_rec.organization_id
10725: * , p_inventory_item_id => l_to_rsv_rec.inventory_item_id
10726: * , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode
10727: * , p_is_revision_control => is_revision_control(l_to_item_cache_index)
10728: * , p_is_lot_control => is_lot_control(l_to_item_cache_index)
10729: * , p_is_serial_control => is_serial_control(l_to_item_cache_index)
10730: * , p_asset_sub_only => FALSE

Line 12084: debug_print('calling inv_quantity_tree_pvt.create_tree');

12080: -- call quantity processor to
12081: -- modify the tree so that the quantity tree
12082: -- reflect the deletion
12083: IF (l_debug = 1) THEN
12084: debug_print('calling inv_quantity_tree_pvt.create_tree');
12085: END IF;
12086: inv_quantity_tree_pvt.create_tree(
12087: p_api_version_number => 1.0
12088: , p_init_msg_lst => fnd_api.g_true

Line 12086: inv_quantity_tree_pvt.create_tree(

12082: -- reflect the deletion
12083: IF (l_debug = 1) THEN
12084: debug_print('calling inv_quantity_tree_pvt.create_tree');
12085: END IF;
12086: inv_quantity_tree_pvt.create_tree(
12087: p_api_version_number => 1.0
12088: , p_init_msg_lst => fnd_api.g_true
12089: , x_return_status => l_return_status
12090: , x_msg_count => x_msg_count

Line 12094: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode

12090: , x_msg_count => x_msg_count
12091: , x_msg_data => x_msg_data
12092: , p_organization_id => l_tmp_rsv_tbl(1).organization_id
12093: , p_inventory_item_id => l_tmp_rsv_tbl(1).inventory_item_id
12094: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode
12095: , p_is_revision_control => is_revision_control(l_orig_item_cache_index)
12096: , p_is_lot_control => is_lot_control(l_orig_item_cache_index)
12097: , p_is_serial_control => is_serial_control(l_orig_item_cache_index)
12098: , p_asset_sub_only => FALSE

Line 12111: debug_print('error calling inv_quantity_tree_pvt.create_tree');

12107: );
12108:
12109: IF l_return_status = fnd_api.g_ret_sts_error THEN
12110: IF (l_debug = 1) THEN
12111: debug_print('error calling inv_quantity_tree_pvt.create_tree');
12112: END IF;
12113: RAISE fnd_api.g_exc_error;
12114: END IF;
12115:

Line 12119: debug_print('unexpected error calling inv_quantity_tree_pvt.create_tree');

12115:
12116: --
12117: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
12118: IF (l_debug = 1) THEN
12119: debug_print('unexpected error calling inv_quantity_tree_pvt.create_tree');
12120: END IF;
12121: RAISE fnd_api.g_exc_unexpected_error;
12122: END IF;
12123:

Line 12767: inv_quantity_tree_pvt.create_tree(

12763: AND p_validation_flag = fnd_api.g_true THEN
12764: -- call quantity processor to
12765: -- modify the tree so that the quantity tree
12766: -- reflect the deletion
12767: inv_quantity_tree_pvt.create_tree(
12768: p_api_version_number => 1.0
12769: , p_init_msg_lst => fnd_api.g_true
12770: , x_return_status => l_return_status
12771: , x_msg_count => x_msg_count

Line 12775: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode

12771: , x_msg_count => x_msg_count
12772: , x_msg_data => x_msg_data
12773: , p_organization_id => l_tmp_rsv_tbl(1).organization_id
12774: , p_inventory_item_id => l_tmp_rsv_tbl(1).inventory_item_id
12775: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode
12776: , p_is_revision_control => is_revision_control(l_orig_item_cache_index)
12777: , p_is_lot_control => is_lot_control(l_orig_item_cache_index)
12778: , p_is_serial_control => is_serial_control(l_orig_item_cache_index)
12779: , p_asset_sub_only => FALSE

Line 13801: inv_quantity_tree_pvt.create_tree

13797: END IF;
13798: END IF;
13799: -- INVCONV END
13800:
13801: inv_quantity_tree_pvt.create_tree
13802: (
13803: p_api_version_number => 1.0
13804: , p_init_msg_lst => fnd_api.g_true
13805: , x_return_status => l_return_status

Line 13810: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode

13806: , x_msg_count => x_msg_count
13807: , x_msg_data => x_msg_data
13808: , p_organization_id => l_orig_rsv_tbl(1).organization_id
13809: , p_inventory_item_id => l_orig_rsv_tbl(1).inventory_item_id
13810: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode
13811: , p_is_revision_control => is_revision_control(l_orig_item_cache_index)
13812: , p_is_lot_control => is_lot_control(l_orig_item_cache_index)
13813: , p_is_serial_control => is_serial_control(l_orig_item_cache_index)
13814: , p_asset_sub_only => FALSE

Line 13836: inv_quantity_tree_pvt.create_tree

13832: RAISE fnd_api.g_exc_unexpected_error;
13833: END IF;
13834:
13835: --
13836: inv_quantity_tree_pvt.create_tree
13837: (
13838: p_api_version_number => 1.0
13839: , p_init_msg_lst => fnd_api.g_true
13840: , x_return_status => l_return_status

Line 13845: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode

13841: , x_msg_count => x_msg_count
13842: , x_msg_data => x_msg_data
13843: , p_organization_id => l_to_rsv_rec.organization_id
13844: , p_inventory_item_id => l_to_rsv_rec.inventory_item_id
13845: , p_tree_mode => inv_quantity_tree_pvt.g_reservation_mode
13846: , p_is_revision_control => is_revision_control(l_to_item_cache_index)
13847: , p_is_lot_control => is_lot_control(l_to_item_cache_index)
13848: , p_is_serial_control => is_serial_control(l_to_item_cache_index)
13849: , p_asset_sub_only => FALSE

Line 13875: inv_quantity_tree_pvt.query_tree(

13871: IF l_orig_rsv_tbl(1).supply_source_type_id = inv_reservation_global.g_source_type_po
13872: AND l_to_rsv_rec.supply_source_type_id = inv_reservation_global.g_source_type_inv
13873: AND l_fulfill_base = 'S' AND l_transfer_all THEN
13874:
13875: inv_quantity_tree_pvt.query_tree(
13876: p_api_version_number => 1.0
13877: , p_init_msg_lst => fnd_api.g_true
13878: , x_return_status => l_return_status
13879: , x_msg_count => x_msg_count

Line 18244: inv_quantity_tree_pvt.do_check(p_api_version_number, p_init_msg_lst, l_return_status, x_msg_count, x_msg_data, tree_rec.p_tree_id, l_no_violation);

18240: IF (l_debug = 1) THEN
18241: debug_print('Calling do_check for tree_id = '||tree_rec.p_tree_id);
18242: END IF;
18243:
18244: inv_quantity_tree_pvt.do_check(p_api_version_number, p_init_msg_lst, l_return_status, x_msg_count, x_msg_data, tree_rec.p_tree_id, l_no_violation);
18245:
18246: IF l_return_status = fnd_api.g_ret_sts_error THEN
18247: RAISE fnd_api.g_exc_error;
18248: END IF;