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

Line 279: inv_quantity_tree_pub.clear_quantity_cache;

275: l_satr NUMBER;
276: l_demand_source_header_id NUMBER ;
277: l_demand_source_line_id NUMBER ;
278: BEGIN
279: inv_quantity_tree_pub.clear_quantity_cache;
280: IF p_is_revision_control = 'true' THEN
281: l_is_revision_control := TRUE;
282: END IF;
283:

Line 305: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

301: l_demand_source_line_id := p_demand_source_line_id ;
302: END IF ;
303:
304: IF p_tree_mode IS NULL THEN
305: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
306: ELSE l_tree_mode := p_tree_mode;
307: END IF ;
308:
309: inv_quantity_tree_pub.query_quantities

Line 309: inv_quantity_tree_pub.query_quantities

305: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
306: ELSE l_tree_mode := p_tree_mode;
307: END IF ;
308:
309: inv_quantity_tree_pub.query_quantities
310: ( p_api_version_number => 1.0
311: , p_init_msg_lst => fnd_api.g_false
312: , x_return_status => x_return_status
313: , x_msg_count => l_msg_count

Line 447: inv_quantity_tree_pub.clear_quantity_cache;

443: l_sqs NUMBER;
444: l_satr NUMBER;
445: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
446: BEGIN
447: inv_quantity_tree_pub.clear_quantity_cache;
448: IF p_is_revision_control = 'true' THEN
449: l_is_revision_control := TRUE;
450: END IF;
451:

Line 460: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

456: IF p_is_serial_control = 'true' THEN
457: l_is_serial_control := TRUE;
458: END IF;
459: IF p_tree_mode IS NULL THEN
460: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
461: ELSE l_tree_mode := p_tree_mode;
462: END IF ;
463: inv_quantity_tree_pub.query_quantities(
464: p_api_version_number => 1.0

Line 463: inv_quantity_tree_pub.query_quantities(

459: IF p_tree_mode IS NULL THEN
460: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
461: ELSE l_tree_mode := p_tree_mode;
462: END IF ;
463: inv_quantity_tree_pub.query_quantities(
464: p_api_version_number => 1.0
465: , p_init_msg_lst => fnd_api.g_false
466: , x_return_status => x_return_status
467: , x_msg_count => l_msg_count

Line 660: inv_quantity_tree_pub.clear_quantity_cache;

656: l_sqs NUMBER;
657: l_satr NUMBER;
658: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
659: BEGIN
660: inv_quantity_tree_pub.clear_quantity_cache;
661: IF p_is_revision_control = 'true' THEN
662: l_is_revision_control := TRUE;
663: END IF;
664:

Line 674: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

670: l_is_serial_control := TRUE;
671: END IF;
672:
673: IF p_tree_mode IS NULL THEN
674: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
675: ELSE l_tree_mode := p_tree_mode;
676: END IF ;
677:
678: inv_quantity_tree_pub.query_quantities(

Line 678: inv_quantity_tree_pub.query_quantities(

674: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
675: ELSE l_tree_mode := p_tree_mode;
676: END IF ;
677:
678: inv_quantity_tree_pub.query_quantities(
679: p_api_version_number => 1.0 ,
680: p_init_msg_lst => fnd_api.g_false ,
681: x_return_status => x_return_status ,
682: x_msg_count => l_msg_count ,

Line 866: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

862: IF p_is_serial_control = 'true' THEN
863: l_is_serial_control := TRUE;
864: END IF;
865: IF p_tree_mode IS NULL THEN
866: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
867: ELSE l_tree_mode := p_tree_mode;
868: END IF ;
869:
870:

Line 1209: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

1205: IF p_is_serial_control = 'true' THEN
1206: l_is_serial_control := TRUE;
1207: END IF;
1208: IF p_tree_mode IS NULL THEN
1209: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
1210: ELSE l_tree_mode := p_tree_mode;
1211: END IF ;
1212:
1213:

Line 1442: inv_quantity_tree_pub.clear_quantity_cache;

1438: l_sqs NUMBER;
1439: l_satr NUMBER;
1440: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1441: BEGIN
1442: inv_quantity_tree_pub.clear_quantity_cache;
1443: IF p_is_revision_control = 'true' THEN
1444: l_is_revision_control := TRUE;
1445: END IF;
1446:

Line 1456: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

1452: l_is_serial_control := TRUE;
1453: END IF;
1454:
1455: IF p_tree_mode IS NULL THEN
1456: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
1457: ELSE l_tree_mode := p_tree_mode;
1458: END IF ;
1459:
1460: inv_quantity_tree_pub.query_quantities(

Line 1460: inv_quantity_tree_pub.query_quantities(

1456: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
1457: ELSE l_tree_mode := p_tree_mode;
1458: END IF ;
1459:
1460: inv_quantity_tree_pub.query_quantities(
1461: p_api_version_number => 1.0 ,
1462: p_init_msg_lst => fnd_api.g_false ,
1463: x_return_status => x_return_status ,
1464: x_msg_count => l_msg_count ,

Line 1608: inv_quantity_tree_pub.clear_quantity_cache;

1604: IF (l_debug = 1) THEN
1605: mdebug ('Start check_loose_quantity.');
1606: END IF;
1607:
1608: inv_quantity_tree_pub.clear_quantity_cache;
1609:
1610: -- Standard call to check for call compatibility
1611: IF NOT fnd_api.compatible_api_call(l_api_version_number
1612: , p_api_version_number

Line 1712: p_tree_mode => INV_Quantity_Tree_PUB.g_loose_only_mode,

1708:
1709:
1710: inv_txn_validations.get_available_quantity
1711: (x_return_status => l_return_status,
1712: p_tree_mode => INV_Quantity_Tree_PUB.g_loose_only_mode,
1713: p_organization_id => p_organization_id,
1714: p_inventory_item_id => p_inventory_item_id,
1715: p_is_revision_control => p_is_revision_control,
1716: p_is_lot_control => p_is_lot_control,

Line 2593: l_tree_mode INTEGER := INV_Quantity_Tree_PUB.g_transaction_mode;

2589: --l_sum NUMBER;
2590: l_parent_lpn_id NUMBER;
2591: l_lpn_context NUMBER ;
2592: l_updt_qoh NUMBER;
2593: l_tree_mode INTEGER := INV_Quantity_Tree_PUB.g_transaction_mode;
2594:
2595: TYPE l_rec IS RECORD (
2596: inventory_item_id NUMBER,
2597: parent_lpn_id NUMBER,

Line 2627: l_tree_mode := INV_Quantity_Tree_PUB.g_no_lpn_rsvs_mode;

2623: x_return_msg :='';
2624:
2625: /* if transaction is subxfe ormo subxfer we should conside reserved qty. since reserved qty can be subxfered*/
2626: if p_transaction_type_id in (2,64) then
2627: l_tree_mode := INV_Quantity_Tree_PUB.g_no_lpn_rsvs_mode;
2628: end if;
2629:
2630: -- Clearing the quantity cache
2631: inv_quantity_tree_pub.clear_quantity_cache;

Line 2631: inv_quantity_tree_pub.clear_quantity_cache;

2627: l_tree_mode := INV_Quantity_Tree_PUB.g_no_lpn_rsvs_mode;
2628: end if;
2629:
2630: -- Clearing the quantity cache
2631: inv_quantity_tree_pub.clear_quantity_cache;
2632:
2633: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2634: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2635: -- INTO l_subinventory_code, l_locator_id

Line 2693: inv_quantity_tree_pub.query_quantities

2689: IF l_serial_number_control_code IN (2,5,6) THEN
2690: l_is_serial_control := TRUE;
2691: END IF;
2692:
2693: inv_quantity_tree_pub.query_quantities
2694: ( p_api_version_number => 1.0
2695: , p_init_msg_lst => fnd_api.g_false
2696: , x_return_status => l_return_status
2697: , x_msg_count => l_msg_count

Line 2733: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2729: END IF ;
2730: ELSE
2731: x_return :='F';
2732: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
2733: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
2734: x_return_msg := fnd_message.get;
2735: RETURN x_return;
2736: END IF ;
2737: l_updt_qoh := - l_qoh;

Line 2739: inv_quantity_tree_pub.update_quantities

2735: RETURN x_return;
2736: END IF ;
2737: l_updt_qoh := - l_qoh;
2738: /*need to update qty tree */
2739: inv_quantity_tree_pub.update_quantities
2740: ( p_api_version_number => 1.0
2741: , p_init_msg_lst => fnd_api.g_false
2742: , x_return_status => l_return_status
2743: , x_msg_count => l_msg_count

Line 2747: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

2743: , x_msg_count => l_msg_count
2744: , x_msg_data => l_msg_data
2745: , p_organization_id => p_organization_id
2746: , p_inventory_item_id => l_item_id
2747: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
2748: , p_is_revision_control => l_is_revision_control
2749: , p_is_lot_control => l_is_lot_control
2750: , p_is_serial_control => l_is_serial_control
2751: , p_demand_source_type_id => p_source_type_id

Line 2782: -- call to inv_quantity_tree_pub.query_quantities passes

2778: -- Bug# 2358224
2779: -- Overloaded version of the previous function passing in
2780: -- the to/transfer subinventory. This is the same as the
2781: -- previous call with the only difference being that the
2782: -- call to inv_quantity_tree_pub.query_quantities passes
2783: -- the p_transfer_subinventory_code input parameter
2784:
2785:
2786: -- Bug # 2433095 -- Changes to LPN reservations ported to the ovreloaded

Line 2825: l_tree_mode INTEGER := INV_Quantity_Tree_PUB.g_transaction_mode;

2821: -- l_sum NUMBER;
2822: l_parent_lpn_id NUMBER;
2823: l_lpn_context NUMBER ;
2824: l_updt_qoh NUMBER;
2825: l_tree_mode INTEGER := INV_Quantity_Tree_PUB.g_transaction_mode;
2826: l_inv_rcpt_code MTL_PARAMETERS.NEGATIVE_INV_RECEIPT_CODE%TYPE; -- Bug 13878269
2827:
2828: TYPE l_rec IS RECORD (
2829: inventory_item_id NUMBER,

Line 2864: l_tree_mode := INV_Quantity_Tree_PUB.g_no_lpn_rsvs_mode;

2860: END IF;
2861:
2862: /* if transaction is subxfe ormo subxfer we should conside reserved qty. since reserved qty can be subxfered*/
2863: if p_transaction_type_id in (2,64) then
2864: l_tree_mode := INV_Quantity_Tree_PUB.g_no_lpn_rsvs_mode;
2865: end if;
2866:
2867: -- Clearing the quantity cache
2868: inv_quantity_tree_pub.clear_quantity_cache;

Line 2868: inv_quantity_tree_pub.clear_quantity_cache;

2864: l_tree_mode := INV_Quantity_Tree_PUB.g_no_lpn_rsvs_mode;
2865: end if;
2866:
2867: -- Clearing the quantity cache
2868: inv_quantity_tree_pub.clear_quantity_cache;
2869:
2870: -- OPTIMIZED BELOW FOR PERFORMANCE MXGUPTA JUNE 4 2001
2871: -- SELECT DISTINCT wlpn.subinventory_code, wlpn.locator_id
2872: -- INTO l_subinventory_code, l_locator_id

Line 2938: inv_quantity_tree_pub.query_quantities

2934: IF l_serial_number_control_code IN (2,5,6) THEN
2935: l_is_serial_control := TRUE;
2936: END IF;
2937:
2938: inv_quantity_tree_pub.query_quantities
2939: ( p_api_version_number => 1.0
2940: , p_init_msg_lst => fnd_api.g_false
2941: , x_return_status => l_return_status
2942: , x_msg_count => l_msg_count

Line 3000: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

2996:
2997: ELSE
2998: x_return :='F';
2999: FND_MESSAGE.set_name('INV', 'INV-INVALID_QUANTITY_TYPE');
3000: FND_MESSAGE.set_token('ROUTINE', 'INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3001: x_return_msg := fnd_message.get;
3002: RETURN x_return;
3003: END IF ;
3004:

Line 3011: inv_quantity_tree_pub.update_quantities

3007:
3008: --mdebug (' l_updt_qoh ' || l_updt_qoh|| ' l qoh ' || l_qoh);
3009:
3010: /*need to update qty tree */
3011: inv_quantity_tree_pub.update_quantities
3012: ( p_api_version_number => 1.0
3013: , p_init_msg_lst => fnd_api.g_false
3014: , x_return_status => l_return_status
3015: , x_msg_count => l_msg_count

Line 3019: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode

3015: , x_msg_count => l_msg_count
3016: , x_msg_data => l_msg_data
3017: , p_organization_id => p_organization_id
3018: , p_inventory_item_id => l_item_id
3019: , p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode
3020: , p_is_revision_control => l_is_revision_control
3021: , p_is_lot_control => l_is_lot_control
3022: , p_is_serial_control => l_is_serial_control
3023: , p_demand_source_type_id => p_source_type_id

Line 3088: l_tree_mode NUMBER := INV_Quantity_Tree_PUB.g_transaction_mode;

3084: l_is_serial_control BOOLEAN := FALSE;
3085: l_is_lot_control BOOLEAN := FALSE ;
3086: l_lpn_context NUMBER;
3087: l_mod varchar2(20) := 'get_lpn_available';
3088: l_tree_mode NUMBER := INV_Quantity_Tree_PUB.g_transaction_mode;
3089:
3090: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3091: BEGIN
3092:

Line 3097: inv_quantity_tree_pub.clear_quantity_cache;

3093: x_return := 'Y';
3094: x_return_msg :='';
3095:
3096: -- Clearing the quantity cache
3097: inv_quantity_tree_pub.clear_quantity_cache;
3098:
3099: IF Upper(p_is_revision_control) = 'TRUE' THEN
3100: l_is_revision_control := TRUE;
3101: ELSE

Line 3126: l_tree_mode := INV_Quantity_Tree_PUB.g_transaction_mode; --lpn reservation

3122: END IF ;
3123:
3124: IF (p_lpn_id is NOT NULL AND p_lpn_id <> 0)
3125: THEN
3126: l_tree_mode := INV_Quantity_Tree_PUB.g_transaction_mode; --lpn reservation
3127: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
3128: quantity tree API using new tree mode ?????
3129: SELECT SUM(quantity)
3130: INTO x_lpn_onhand

Line 3146: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

3142: x_return_msg := fnd_message.get;
3143: RETURN x_return;
3144: END IF;*/
3145: ELSE
3146: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
3147: END IF;
3148:
3149: /* Bug 4108760, Commenting the changes done for bug 3246658.
3150: * Issue in bug 3246658 is solved by bug 3295705.

Line 3158: inv_quantity_tree_pub.query_quantities

3154: */
3155: /*Bug# 3246658: pass p_lot_expiration_date as sysdate so that for lot controlled items
3156: *with user defined shelf life the build_query does not return FALSE
3157: */
3158: inv_quantity_tree_pub.query_quantities
3159: (p_api_version_number => 1.0
3160: , p_init_msg_lst => fnd_api.g_false
3161: , x_return_status => l_return_status
3162: , x_msg_count => l_msg_count

Line 3209: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

3205: END IF ;
3206: ELSE
3207: x_return :='F';
3208: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3209: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3210: x_return_msg := fnd_message.get;
3211: RETURN x_return;
3212: END IF ;
3213:

Line 3268: l_tree_mode NUMBER := INV_Quantity_Tree_PUB.g_transaction_mode;

3264: l_is_serial_control BOOLEAN := FALSE;
3265: l_is_lot_control BOOLEAN := FALSE ;
3266: l_lpn_context NUMBER;
3267: l_mod varchar2(20) := 'get_lpn_available';
3268: l_tree_mode NUMBER := INV_Quantity_Tree_PUB.g_transaction_mode;
3269:
3270: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3271: BEGIN
3272:

Line 3277: inv_quantity_tree_pub.clear_quantity_cache;

3273: x_return := 'Y';
3274: x_return_msg :='';
3275:
3276: -- Clearing the quantity cache
3277: inv_quantity_tree_pub.clear_quantity_cache;
3278:
3279: IF Upper(p_is_revision_control) = 'TRUE' THEN
3280: l_is_revision_control := TRUE;
3281: ELSE

Line 3306: l_tree_mode := INV_Quantity_Tree_PUB.g_transaction_mode; --lpn reservation

3302: END IF ;
3303:
3304: IF (p_lpn_id is NOT NULL AND p_lpn_id <> 0)
3305: THEN
3306: l_tree_mode := INV_Quantity_Tree_PUB.g_transaction_mode; --lpn reservation
3307: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
3308: quantity tree API using new tree mode ?????
3309: SELECT SUM(quantity)
3310: INTO x_lpn_onhand

Line 3326: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

3322: x_return_msg := fnd_message.get;
3323: RETURN x_return;
3324: END IF;*/
3325: ELSE
3326: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
3327: END IF;
3328:
3329: /* Bug 4108760, Commenting the changes done for bug 3246658.
3330: * Issue in bug 3246658 is solved by bug 3295705.

Line 3338: inv_quantity_tree_pub.query_quantities

3334: */
3335: /*Bug# 3246658: pass p_lot_expiration_date as sysdate so that for lot controlled items
3336: *with user defined shelf life the build_query does not return FALSE
3337: */
3338: inv_quantity_tree_pub.query_quantities
3339: (p_api_version_number => 1.0
3340: , p_init_msg_lst => fnd_api.g_false
3341: , x_return_status => l_return_status
3342: , x_msg_count => l_msg_count

Line 3399: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

3395: END IF ;
3396: ELSE
3397: x_return :='F';
3398: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3399: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3400: x_return_msg := fnd_message.get;
3401: RETURN x_return;
3402: END IF ;
3403:

Line 3442: l_tree_mode NUMBER := INV_Quantity_Tree_PUB.g_transaction_mode;

3438: l_is_serial_control BOOLEAN := FALSE;
3439: l_is_lot_control BOOLEAN := FALSE ;
3440: l_lpn_context NUMBER;
3441: l_mod varchar2(20) := 'get_lpn_available';
3442: l_tree_mode NUMBER := INV_Quantity_Tree_PUB.g_transaction_mode;
3443:
3444: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3445: BEGIN
3446:

Line 3451: inv_quantity_tree_pub.clear_quantity_cache;

3447: x_return := 'Y';
3448: x_return_msg :='';
3449:
3450: -- Clearing the quantity cache
3451: inv_quantity_tree_pub.clear_quantity_cache;
3452:
3453: IF Upper(p_is_revision_control) = 'TRUE' THEN
3454: l_is_revision_control := TRUE;
3455: ELSE

Line 3480: l_tree_mode := INV_Quantity_Tree_PUB.g_transaction_mode; --lpn reservation

3476: END IF ;
3477:
3478: IF (p_lpn_id is NOT NULL AND p_lpn_id <> 0)
3479: THEN
3480: l_tree_mode := INV_Quantity_Tree_PUB.g_transaction_mode; --lpn reservation
3481: /* comment out for lpn reservation ??? how can we get immediate lpn item quantity by calling
3482: quantity tree API using new tree mode ?????
3483: SELECT SUM(quantity)
3484: INTO x_lpn_onhand

Line 3500: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

3496: x_return_msg := fnd_message.get;
3497: RETURN x_return;
3498: END IF;*/
3499: ELSE
3500: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
3501: END IF;
3502:
3503: inv_quantity_tree_pub.query_quantities
3504: (p_api_version_number => 1.0

Line 3503: inv_quantity_tree_pub.query_quantities

3499: ELSE
3500: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
3501: END IF;
3502:
3503: inv_quantity_tree_pub.query_quantities
3504: (p_api_version_number => 1.0
3505: , p_init_msg_lst => fnd_api.g_false
3506: , x_return_status => l_return_status
3507: , x_msg_count => l_msg_count

Line 3555: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

3551: END IF ;
3552: ELSE
3553: x_return :='F';
3554: FND_MESSAGE.set_name('INV', 'INV_INVALID_QUANTITY_TYPE');
3555: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
3556: x_return_msg := fnd_message.get;
3557: RETURN x_return;
3558: END IF ;
3559:

Line 3871: l_tree_mode NUMBER := inv_quantity_tree_pub.g_transaction_mode;

3867: IS
3868: l_is_revision_control BOOLEAN;
3869: l_is_lot_control BOOLEAN;
3870:
3871: l_tree_mode NUMBER := inv_quantity_tree_pub.g_transaction_mode;
3872: l_quantity_type NUMBER := inv_quantity_tree_pvt.g_qoh;
3873: l_onhand_source NUMBER := inv_quantity_tree_pvt.g_all_subs;
3874: l_qoh NUMBER;
3875: l_rqoh NUMBER;

Line 4062: inv_quantity_tree_pub.query_quantities

4058: l_is_revision_control := FALSE;
4059: END IF;
4060:
4061: -- Query the quantity tree for available to transact quantity
4062: inv_quantity_tree_pub.query_quantities
4063: (p_api_version_number => 1.0,
4064: p_init_msg_lst => fnd_api.g_false,
4065: x_return_status => x_return_status,
4066: x_msg_count => l_msg_count,

Line 4089: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');

4085: x_atr => l_atr);
4086:
4087: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4088: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4089: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
4090: x_return_msg := fnd_message.get;
4091: RETURN;
4092: END IF;
4093: IF (l_debug = 1) THEN

Line 4117: inv_quantity_tree_pub.update_quantities

4113:
4114: IF l_att > 0 THEN
4115: -- Update the quantity tree so that the serial transaction is
4116: -- reflected in the available quantity
4117: inv_quantity_tree_pub.update_quantities
4118: (p_api_version_number => 1.0,
4119: p_init_msg_lst => fnd_api.g_false,
4120: x_return_status => x_return_status,
4121: x_msg_count => l_msg_count,

Line 4146: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');

4142: x_atr => l_atr);
4143:
4144: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4145: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4146: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4147: x_return_msg := fnd_message.get;
4148: RETURN;
4149: END IF;
4150: IF (l_debug = 1) THEN

Line 4154: inv_quantity_tree_pub.update_quantities

4150: IF (l_debug = 1) THEN
4151: inv_log_util.trace('ATT in source: ' || l_att, 'process_serial_subxfr');
4152: END IF;
4153:
4154: inv_quantity_tree_pub.update_quantities
4155: (p_api_version_number => 1.0,
4156: p_init_msg_lst => fnd_api.g_false,
4157: x_return_status => x_return_status,
4158: x_msg_count => l_msg_count,

Line 4183: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');

4179: x_atr => l_atr);
4180:
4181: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4182: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
4183: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
4184: x_return_msg := fnd_message.get;
4185: RETURN;
4186: END IF;
4187:

Line 4426: inv_quantity_tree_pub.clear_quantity_cache;

4422: IF (l_debug = 1) THEN
4423: mdebug ('Start check_loose_and_packed_qty.');
4424: END IF;
4425:
4426: inv_quantity_tree_pub.clear_quantity_cache;
4427:
4428: -- Standard call to check for call compatibility
4429: IF NOT fnd_api.compatible_api_call(l_api_version_number
4430: , p_api_version_number

Line 4513: p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode,

4509: END IF;
4510:
4511: inv_txn_validations.get_available_quantity
4512: (x_return_status => l_return_status,
4513: p_tree_mode => INV_Quantity_Tree_PUB.g_transaction_mode,
4514: p_organization_id => p_organization_id,
4515: p_inventory_item_id => p_inventory_item_id,
4516: p_is_revision_control => p_is_revision_control,
4517: p_is_lot_control => p_is_lot_control,

Line 4726: inv_quantity_tree_pub.query_quantities

4722: -- Clearing any cache if existent
4723: inv_quantity_tree_grp.clear_quantity_cache ;
4724:
4725: -- this call will provide reserved quantity for all but the demand source specified
4726: inv_quantity_tree_pub.query_quantities
4727: ( p_api_version_number => 1.0
4728: , p_init_msg_lst => fnd_api.g_false
4729: , x_return_status => l_return_status
4730: , x_msg_count => l_msg_count

Line 4734: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode

4730: , x_msg_count => l_msg_count
4731: , x_msg_data => l_msg_data
4732: , p_organization_id => p_organization_id
4733: , p_inventory_item_id => p_inventory_item_id
4734: , p_tree_mode => inv_quantity_tree_pub.g_transaction_mode
4735: , p_is_revision_control => l_is_revision_control
4736: , p_is_lot_control => l_is_lot_control
4737: , p_is_serial_control => l_is_serial_control
4738: , p_demand_source_type_id => p_demand_source_type_id