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_TRANSFER_ORDER_PVT dependencies on INV_RESERVATION_PUB

Line 177: inv_reservation_pub.query_reservation(

173: FOR l_counter IN 1 .. l_troldt_tbl.COUNT LOOP
174: -- if this is a pick wave move order, update the reservation first
175: IF (p_move_order_type = 3) THEN
176: l_rsv_temp_rec.reservation_id := l_troldt_tbl(l_counter).reservation_id;
177: inv_reservation_pub.query_reservation(
178: p_api_version_number => 1.0
179: , p_init_msg_lst => fnd_api.g_true
180: , x_return_status => l_return_status
181: , x_msg_count => l_msg_count

Line 206: inv_reservation_pub.update_reservation(

202: l_to_rsv_rec.secondary_reservation_quantity := NULL;
203: l_to_rsv_rec.secondary_detailed_quantity := NULL;
204: END IF;
205:
206: inv_reservation_pub.update_reservation(
207: p_api_version_number => 1.0
208: , p_init_msg_lst => fnd_api.g_true
209: , x_return_status => l_return_status
210: , x_msg_count => l_msg_count

Line 658: inv_reservation_pub.query_reservation(

654: END IF;
655:
656: IF (p_move_order_type = 3) THEN
657: l_rsv_temp_rec.reservation_id := l_troldt_tbl(l_counter).reservation_id;
658: inv_reservation_pub.query_reservation(
659: p_api_version_number => 1.0
660: , x_return_status => l_return_status
661: , x_msg_count => l_msg_count
662: , x_msg_data => l_msg_data

Line 848: inv_reservation_pub.update_reservation(

844: IF ( l_to_rsv_rec.secondary_uom_code IS NULL ) THEN
845: l_to_rsv_rec.secondary_reservation_quantity := NULL;
846: l_to_rsv_rec.secondary_detailed_quantity := NULL;
847: END IF;
848: inv_reservation_pub.update_reservation(
849: p_api_version_number => 1.0
850: , x_return_status => l_return_status
851: , x_msg_count => l_msg_count
852: , x_msg_data => l_msg_data

Line 888: inv_reservation_pub.update_reservation(

884: IF ( l_to_rsv_rec.secondary_uom_code IS NULL ) THEN
885: l_to_rsv_rec.secondary_reservation_quantity := NULL;
886: l_to_rsv_rec.secondary_detailed_quantity := NULL;
887: END IF;
888: inv_reservation_pub.update_reservation(
889: p_api_version_number => 1.0
890: , x_return_status => l_return_status
891: , x_msg_count => x_msg_count
892: , x_msg_data => x_msg_data

Line 1606: INV_RESERVATION_PUB.Query_Reservation

1602: l_rsv_temp_rec.demand_source_delivery := p_source_delivery_id;
1603: l_rsv_temp_rec.inventory_item_id := p_inventory_item_id;
1604: l_rsv_temp_rec.organization_id := p_organization_id;
1605:
1606: INV_RESERVATION_PUB.Query_Reservation
1607: (
1608: p_api_version_number => 1.0,
1609: x_return_status => l_return_status,
1610: x_msg_count => x_msg_count,

Line 2165: debug('About to call inv_reservation_pub.query_reservations', 'update_txn_source_line');

2161: IF (rec_mmtt.reservation_id IS NOT NULL) THEN
2162: l_original_reservation_rec.reservation_id := rec_mmtt.reservation_id;
2163:
2164: IF (l_debug = 1) THEN
2165: debug('About to call inv_reservation_pub.query_reservations', 'update_txn_source_line');
2166: END IF;
2167:
2168: -- Query the reservation record corresponding to the allocation line
2169: inv_reservation_pub.query_reservation

Line 2169: inv_reservation_pub.query_reservation

2165: debug('About to call inv_reservation_pub.query_reservations', 'update_txn_source_line');
2166: END IF;
2167:
2168: -- Query the reservation record corresponding to the allocation line
2169: inv_reservation_pub.query_reservation
2170: (p_api_version_number => 1.0,
2171: x_return_status => l_return_status,
2172: x_msg_count => l_msg_count,
2173: x_msg_data => l_msg_data,

Line 2209: inv_reservation_pub.transfer_reservation

2205: rec_mmtt.transaction_quantity);
2206: l_new_reservation_rec.detailed_quantity := Least(l_mtl_reservation_tbl(1).reservation_quantity,
2207: rec_mmtt.transaction_quantity);
2208:
2209: inv_reservation_pub.transfer_reservation
2210: (p_api_version_number => 1.0,
2211: p_init_msg_lst => fnd_api.g_false,
2212: x_return_status => l_return_status,
2213: x_msg_count => l_msg_count,

Line 2402: inv_reservation_pub.delete_reservation(

2398: -- Create a crossdock peg for a partial qty of sales order line
2399: -- and pick release the rest from inventory. Before receipt
2400: -- of crossdock material, stage the move order line from Inventory.
2401: -- Ensure that the crossdock peg is not deleted }}
2402: inv_reservation_pub.delete_reservation(
2403: p_api_version_number => 1.0
2404: , p_init_msg_lst => fnd_api.g_true
2405: , x_return_status => l_return_status
2406: , x_msg_count => l_msg_count

Line 3403: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');

3399:
3400: IF (l_mmtt_rec.reservation_id IS NOT NULL) THEN
3401: l_query_reservation_rec.reservation_id := l_mmtt_rec.reservation_id;
3402: IF (l_debug = 1) THEN
3403: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');
3404: END IF;
3405: inv_reservation_pub.query_reservation(
3406: p_api_version_number => 1.0
3407: , x_return_status => l_return_status

Line 3405: inv_reservation_pub.query_reservation(

3401: l_query_reservation_rec.reservation_id := l_mmtt_rec.reservation_id;
3402: IF (l_debug = 1) THEN
3403: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');
3404: END IF;
3405: inv_reservation_pub.query_reservation(
3406: p_api_version_number => 1.0
3407: , x_return_status => l_return_status
3408: , x_msg_count => l_msg_count
3409: , x_msg_data => l_msg_data

Line 3478: inv_reservation_pub.update_reservation(

3474: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
3475: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
3476: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
3477: END IF;
3478: inv_reservation_pub.update_reservation(
3479: p_api_version_number => 1.0
3480: , p_init_msg_lst => fnd_api.g_false
3481: , x_return_status => l_return_status
3482: , x_msg_count => x_msg_count

Line 3502: inv_reservation_pub.query_reservation(

3498: RAISE fnd_api.g_exc_unexpected_error;
3499: END IF;
3500:
3501: --requery reservation to reflect updated data
3502: inv_reservation_pub.query_reservation(
3503: p_api_version_number => 1.0
3504: , x_return_status => l_return_status
3505: , x_msg_count => l_msg_count
3506: , x_msg_data => l_msg_data

Line 3683: inv_reservation_pub.update_reservation(

3679: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
3680: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
3681: END IF;
3682:
3683: inv_reservation_pub.update_reservation(
3684: p_api_version_number => 1.0
3685: , p_init_msg_lst => fnd_api.g_false
3686: , x_return_status => l_return_status
3687: , x_msg_count => x_msg_count

Line 3776: inv_reservation_pub.transfer_reservation(

3772: IF l_mtl_reservation_tbl(1).lpn_id IS NOT NULL THEN
3773: l_mtl_reservation_rec.lpn_id := l_lpn_id;
3774: END IF;
3775:
3776: inv_reservation_pub.transfer_reservation(
3777: p_api_version_number => 1.0
3778: , p_init_msg_lst => fnd_api.g_false
3779: , x_return_status => l_return_status
3780: , x_msg_count => x_msg_count

Line 3865: inv_reservation_pub.transfer_reservation(

3861: IF (l_debug = 1) THEN
3862: DEBUG('l_primary_shipping_quantity: '|| l_primary_shipping_quantity, 'Finalize_Pick_Confirm');
3863: END IF;
3864:
3865: inv_reservation_pub.transfer_reservation(
3866: p_api_version_number => 1.0
3867: , p_init_msg_lst => fnd_api.g_false
3868: , x_return_status => l_return_status
3869: , x_msg_count => x_msg_count

Line 4005: inv_reservation_pub.query_reservation(

4001: l_mtl_reservation_rec.lot_number := l_lot_number;
4002: -- query to see whether a record with the key
4003: -- attributes already exists
4004: -- if there is, use update instead of create
4005: inv_reservation_pub.query_reservation(
4006: p_api_version_number => 1.0
4007: , p_init_msg_lst => fnd_api.g_false
4008: , x_return_status => l_return_status
4009: , x_msg_count => x_msg_count

Line 4038: inv_reservation_pub.update_reservation(

4034: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
4035: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
4036: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
4037: END IF;
4038: inv_reservation_pub.update_reservation(
4039: p_api_version_number => 1.0
4040: , p_init_msg_lst => fnd_api.g_false
4041: , x_return_status => l_return_status
4042: , x_msg_count => x_msg_count

Line 4065: inv_reservation_pub.create_reservation(

4061: l_mtl_reservation_rec.primary_reservation_quantity := ABS(l_lot_primary_quantity);
4062: l_mtl_reservation_rec.reservation_quantity := ABS(l_lot_transaction_quantity);
4063: l_mtl_reservation_rec.secondary_reservation_quantity := ABS(l_lot_secondary_quantity);
4064: l_mtl_reservation_rec.requirement_date := SYSDATE;
4065: inv_reservation_pub.create_reservation(
4066: p_api_version_number => 1.0
4067: , p_init_msg_lst => fnd_api.g_false
4068: , x_return_status => l_return_status
4069: , x_msg_count => x_msg_count

Line 4125: inv_reservation_pub.query_reservation(

4121: l_mtl_reservation_rec.lot_number := NULL;
4122: -- query to see whether a record with the key
4123: -- attributes already exists
4124: -- if there is, use update instead of create
4125: inv_reservation_pub.query_reservation(
4126: p_api_version_number => 1.0
4127: , p_init_msg_lst => fnd_api.g_false
4128: , x_return_status => l_return_status
4129: , x_msg_count => x_msg_count

Line 4158: inv_reservation_pub.update_reservation(

4154: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
4155: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
4156: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
4157: END IF;
4158: inv_reservation_pub.update_reservation(
4159: p_api_version_number => 1.0
4160: , p_init_msg_lst => fnd_api.g_false
4161: , x_return_status => l_return_status
4162: , x_msg_count => x_msg_count

Line 4185: inv_reservation_pub.create_reservation(

4181: l_mtl_reservation_rec.primary_reservation_quantity := l_primary_shipping_quantity;
4182: l_mtl_reservation_rec.reservation_quantity := l_shipping_quantity;
4183: l_mtl_reservation_rec.secondary_reservation_quantity := l_sec_shipping_quantity;
4184: l_mtl_reservation_rec.requirement_date := SYSDATE;
4185: inv_reservation_pub.create_reservation(
4186: p_api_version_number => 1.0
4187: , p_init_msg_lst => fnd_api.g_false
4188: , x_return_status => l_return_status
4189: , x_msg_count => x_msg_count

Line 5261: inv_reservation_pub.update_reservation(

5257: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
5258: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
5259: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
5260: END IF;
5261: inv_reservation_pub.update_reservation(
5262: p_api_version_number => 1.0
5263: , p_init_msg_lst => fnd_api.g_false
5264: , x_return_status => l_return_status
5265: , x_msg_count => x_msg_count

Line 5340: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');

5336: IF (l_mmtt_rec.reservation_id IS NOT NULL) THEN
5337: l_query_reservation_rec.reservation_id := l_mmtt_rec.reservation_id;
5338: IF (l_debug = 1) THEN
5339: DEBUG('reservation_id is = '|| l_mmtt_rec.reservation_id, 'Finalize_Pick_confirm');
5340: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');
5341: END IF;
5342: inv_reservation_pub.query_reservation(
5343: p_api_version_number => 1.0
5344: , x_return_status => l_return_status

Line 5342: inv_reservation_pub.query_reservation(

5338: IF (l_debug = 1) THEN
5339: DEBUG('reservation_id is = '|| l_mmtt_rec.reservation_id, 'Finalize_Pick_confirm');
5340: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');
5341: END IF;
5342: inv_reservation_pub.query_reservation(
5343: p_api_version_number => 1.0
5344: , x_return_status => l_return_status
5345: , x_msg_count => l_msg_count
5346: , x_msg_data => l_msg_data

Line 5401: inv_reservation_pub.update_reservation(

5397: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
5398: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
5399: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
5400: END IF;
5401: inv_reservation_pub.update_reservation(
5402: p_api_version_number => 1.0
5403: , p_init_msg_lst => fnd_api.g_false
5404: , x_return_status => l_return_status
5405: , x_msg_count => x_msg_count

Line 5425: inv_reservation_pub.query_reservation(

5421: RAISE fnd_api.g_exc_unexpected_error;
5422: END IF;
5423:
5424: --requery reservation to reflect updated data
5425: inv_reservation_pub.query_reservation(
5426: p_api_version_number => 1.0
5427: , x_return_status => l_return_status
5428: , x_msg_count => l_msg_count
5429: , x_msg_data => l_msg_data

Line 5507: inv_reservation_pub.update_reservation(

5503: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
5504: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
5505: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
5506: END IF;
5507: inv_reservation_pub.update_reservation(
5508: p_api_version_number => 1.0
5509: , p_init_msg_lst => fnd_api.g_false
5510: , x_return_status => l_return_status
5511: , x_msg_count => x_msg_count

Line 5597: inv_reservation_pub.transfer_reservation(

5593:
5594: IF (l_debug = 1) THEN
5595: DEBUG('Transfering reservations', 'Finalize_Pick_Confirm');
5596: end if;
5597: inv_reservation_pub.transfer_reservation(
5598: p_api_version_number => 1.0
5599: , p_init_msg_lst => fnd_api.g_false
5600: , x_return_status => l_return_status
5601: , x_msg_count => x_msg_count

Line 5677: inv_reservation_pub.transfer_reservation(

5673: IF (l_debug = 1) THEN
5674: DEBUG('Transfering reservation ', 'Finalize_Pick_Confirm');
5675: DEBUG('l_primary_shipping_quantity: '|| l_primary_shipping_quantity, 'Finalize_Pick_Confirm');
5676: END IF;
5677: inv_reservation_pub.transfer_reservation(
5678: p_api_version_number => 1.0
5679: , p_init_msg_lst => fnd_api.g_false
5680: , x_return_status => l_return_status
5681: , x_msg_count => x_msg_count

Line 5806: inv_reservation_pub.query_reservation(

5802: l_mtl_reservation_rec.lot_number := l_lot_number;
5803: -- query to see whether a record with the key
5804: -- attributes already exists
5805: -- if there is, use update instead of create
5806: inv_reservation_pub.query_reservation(
5807: p_api_version_number => 1.0
5808: , p_init_msg_lst => fnd_api.g_false
5809: , x_return_status => l_return_status
5810: , x_msg_count => x_msg_count

Line 5843: inv_reservation_pub.update_reservation(

5839: END IF;
5840: IF (l_debug = 1) THEN
5841: DEBUG('Update reservation id '|| l_mtl_reservation_rec.reservation_id, 'Finalize_Pick_Confirm');
5842: END IF;
5843: inv_reservation_pub.update_reservation(
5844: p_api_version_number => 1.0
5845: , p_init_msg_lst => fnd_api.g_false
5846: , x_return_status => l_return_status
5847: , x_msg_count => x_msg_count

Line 5871: inv_reservation_pub.create_reservation(

5867: l_mtl_reservation_rec.primary_reservation_quantity := ABS(l_lot_primary_quantity);
5868: l_mtl_reservation_rec.reservation_quantity := ABS(l_lot_transaction_quantity);
5869: l_mtl_reservation_rec.secondary_reservation_quantity := ABS(l_lot_secondary_quantity);
5870: l_mtl_reservation_rec.requirement_date := SYSDATE;
5871: inv_reservation_pub.create_reservation(
5872: p_api_version_number => 1.0
5873: , p_init_msg_lst => fnd_api.g_false
5874: , x_return_status => l_return_status
5875: , x_msg_count => x_msg_count

Line 5935: inv_reservation_pub.query_reservation(

5931: l_mtl_reservation_rec.lot_number := NULL;
5932: -- query to see whether a record with the key
5933: -- attributes already exists
5934: -- if there is, use update instead of create
5935: inv_reservation_pub.query_reservation(
5936: p_api_version_number => 1.0
5937: , p_init_msg_lst => fnd_api.g_false
5938: , x_return_status => l_return_status
5939: , x_msg_count => x_msg_count

Line 5966: inv_reservation_pub.update_reservation(

5962: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
5963: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
5964: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
5965: END IF;
5966: inv_reservation_pub.update_reservation(
5967: p_api_version_number => 1.0
5968: , p_init_msg_lst => fnd_api.g_false
5969: , x_return_status => l_return_status
5970: , x_msg_count => x_msg_count

Line 5996: inv_reservation_pub.create_reservation(

5992: l_mtl_reservation_rec.requirement_date := SYSDATE;
5993: IF (l_debug = 1) THEN
5994: DEBUG('create reservation demand source'|| l_mtl_reservation_rec.demand_source_type_id, 'Finalize_Pick_Confirm');
5995: END IF;
5996: inv_reservation_pub.create_reservation(
5997: p_api_version_number => 1.0
5998: , p_init_msg_lst => fnd_api.g_false
5999: , x_return_status => l_return_status
6000: , x_msg_count => x_msg_count

Line 6129: inv_reservation_pub.update_reservation(

6125: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
6126: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
6127: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
6128: END IF;
6129: inv_reservation_pub.update_reservation(
6130: p_api_version_number => 1.0
6131: , p_init_msg_lst => fnd_api.g_false
6132: , x_return_status => l_return_status
6133: , x_msg_count => x_msg_count