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 181: inv_reservation_pub.query_reservation(

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

Line 210: inv_reservation_pub.update_reservation(

206: l_to_rsv_rec.secondary_reservation_quantity := NULL;
207: l_to_rsv_rec.secondary_detailed_quantity := NULL;
208: END IF;
209:
210: inv_reservation_pub.update_reservation(
211: p_api_version_number => 1.0
212: , p_init_msg_lst => fnd_api.g_true
213: , x_return_status => l_return_status
214: , x_msg_count => l_msg_count

Line 661: inv_reservation_pub.query_reservation(

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

Line 851: inv_reservation_pub.update_reservation(

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

Line 891: inv_reservation_pub.update_reservation(

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

Line 1619: INV_RESERVATION_PUB.Query_Reservation

1615: l_rsv_temp_rec.demand_source_delivery := p_source_delivery_id;
1616: l_rsv_temp_rec.inventory_item_id := p_inventory_item_id;
1617: l_rsv_temp_rec.organization_id := p_organization_id;
1618:
1619: INV_RESERVATION_PUB.Query_Reservation
1620: (
1621: p_api_version_number => 1.0,
1622: x_return_status => l_return_status,
1623: x_msg_count => x_msg_count,

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

2174: IF (rec_mmtt.reservation_id IS NOT NULL) THEN
2175: l_original_reservation_rec.reservation_id := rec_mmtt.reservation_id;
2176:
2177: IF (l_debug = 1) THEN
2178: debug('About to call inv_reservation_pub.query_reservations', 'update_txn_source_line');
2179: END IF;
2180:
2181: -- Query the reservation record corresponding to the allocation line
2182: inv_reservation_pub.query_reservation

Line 2182: inv_reservation_pub.query_reservation

2178: debug('About to call inv_reservation_pub.query_reservations', 'update_txn_source_line');
2179: END IF;
2180:
2181: -- Query the reservation record corresponding to the allocation line
2182: inv_reservation_pub.query_reservation
2183: (p_api_version_number => 1.0,
2184: x_return_status => l_return_status,
2185: x_msg_count => l_msg_count,
2186: x_msg_data => l_msg_data,

Line 2222: inv_reservation_pub.transfer_reservation

2218: rec_mmtt.transaction_quantity);
2219: l_new_reservation_rec.detailed_quantity := Least(l_mtl_reservation_tbl(1).reservation_quantity,
2220: rec_mmtt.transaction_quantity);
2221:
2222: inv_reservation_pub.transfer_reservation
2223: (p_api_version_number => 1.0,
2224: p_init_msg_lst => fnd_api.g_false,
2225: x_return_status => l_return_status,
2226: x_msg_count => l_msg_count,

Line 2415: inv_reservation_pub.delete_reservation(

2411: -- Create a crossdock peg for a partial qty of sales order line
2412: -- and pick release the rest from inventory. Before receipt
2413: -- of crossdock material, stage the move order line from Inventory.
2414: -- Ensure that the crossdock peg is not deleted }}
2415: inv_reservation_pub.delete_reservation(
2416: p_api_version_number => 1.0
2417: , p_init_msg_lst => fnd_api.g_true
2418: , x_return_status => l_return_status
2419: , x_msg_count => l_msg_count

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

3630:
3631: IF (l_mmtt_rec.reservation_id IS NOT NULL) THEN
3632: l_query_reservation_rec.reservation_id := l_mmtt_rec.reservation_id;
3633: IF (l_debug = 1) THEN
3634: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');
3635: END IF;
3636: inv_reservation_pub.query_reservation(
3637: p_api_version_number => 1.0
3638: , x_return_status => l_return_status

Line 3636: inv_reservation_pub.query_reservation(

3632: l_query_reservation_rec.reservation_id := l_mmtt_rec.reservation_id;
3633: IF (l_debug = 1) THEN
3634: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');
3635: END IF;
3636: inv_reservation_pub.query_reservation(
3637: p_api_version_number => 1.0
3638: , x_return_status => l_return_status
3639: , x_msg_count => l_msg_count
3640: , x_msg_data => l_msg_data

Line 3722: inv_reservation_pub.update_reservation(

3718: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
3719: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
3720: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
3721: END IF;
3722: inv_reservation_pub.update_reservation(
3723: p_api_version_number => 1.0
3724: , p_init_msg_lst => fnd_api.g_false
3725: , x_return_status => l_return_status
3726: , x_msg_count => x_msg_count

Line 3746: inv_reservation_pub.query_reservation(

3742: RAISE fnd_api.g_exc_unexpected_error;
3743: END IF;
3744:
3745: --requery reservation to reflect updated data
3746: inv_reservation_pub.query_reservation(
3747: p_api_version_number => 1.0
3748: , x_return_status => l_return_status
3749: , x_msg_count => l_msg_count
3750: , x_msg_data => l_msg_data

Line 3942: inv_reservation_pub.update_reservation(

3938: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
3939: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
3940: END IF;
3941:
3942: inv_reservation_pub.update_reservation(
3943: p_api_version_number => 1.0
3944: , p_init_msg_lst => fnd_api.g_false
3945: , x_return_status => l_return_status
3946: , x_msg_count => x_msg_count

Line 4037: inv_reservation_pub.transfer_reservation(

4033: IF l_mtl_reservation_tbl(1).lpn_id IS NOT NULL THEN
4034: l_mtl_reservation_rec.lpn_id := l_lpn_id;
4035: END IF;
4036:
4037: inv_reservation_pub.transfer_reservation(
4038: p_api_version_number => 1.0
4039: , p_init_msg_lst => fnd_api.g_false
4040: , x_return_status => l_return_status
4041: , x_msg_count => x_msg_count

Line 4126: inv_reservation_pub.transfer_reservation(

4122: IF (l_debug = 1) THEN
4123: DEBUG('l_primary_shipping_quantity: '|| l_primary_shipping_quantity, 'Finalize_Pick_Confirm');
4124: END IF;
4125:
4126: inv_reservation_pub.transfer_reservation(
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 => x_msg_count

Line 4275: inv_reservation_pub.query_reservation(

4271: END IF;
4272: -- query to see whether a record with the key
4273: -- attributes already exists
4274: -- if there is, use update instead of create
4275: inv_reservation_pub.query_reservation(
4276: p_api_version_number => 1.0
4277: , p_init_msg_lst => fnd_api.g_false
4278: , x_return_status => l_return_status
4279: , x_msg_count => x_msg_count

Line 4308: inv_reservation_pub.update_reservation(

4304: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
4305: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
4306: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
4307: END IF;
4308: inv_reservation_pub.update_reservation(
4309: p_api_version_number => 1.0
4310: , p_init_msg_lst => fnd_api.g_false
4311: , x_return_status => l_return_status
4312: , x_msg_count => x_msg_count

Line 4384: inv_reservation_pub.create_reservation(

4380: DEBUG('update POSTING_FLAG to N for indivisible item ','Finalize_Pick_Confirm');
4381: END IF;
4382: --Bug 13961830 end
4383:
4384: inv_reservation_pub.create_reservation(
4385: p_api_version_number => 1.0
4386: , p_init_msg_lst => fnd_api.g_false
4387: , x_return_status => l_return_status
4388: , x_msg_count => x_msg_count

Line 4461: inv_reservation_pub.query_reservation(

4457: l_mtl_reservation_rec.lot_number := NULL;
4458: -- query to see whether a record with the key
4459: -- attributes already exists
4460: -- if there is, use update instead of create
4461: inv_reservation_pub.query_reservation(
4462: p_api_version_number => 1.0
4463: , p_init_msg_lst => fnd_api.g_false
4464: , x_return_status => l_return_status
4465: , x_msg_count => x_msg_count

Line 4494: inv_reservation_pub.update_reservation(

4490: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
4491: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
4492: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
4493: END IF;
4494: inv_reservation_pub.update_reservation(
4495: p_api_version_number => 1.0
4496: , p_init_msg_lst => fnd_api.g_false
4497: , x_return_status => l_return_status
4498: , x_msg_count => x_msg_count

Line 4521: inv_reservation_pub.create_reservation(

4517: l_mtl_reservation_rec.primary_reservation_quantity := l_primary_shipping_quantity;
4518: l_mtl_reservation_rec.reservation_quantity := l_shipping_quantity;
4519: l_mtl_reservation_rec.secondary_reservation_quantity := l_sec_shipping_quantity;
4520: l_mtl_reservation_rec.requirement_date := SYSDATE;
4521: inv_reservation_pub.create_reservation(
4522: p_api_version_number => 1.0
4523: , p_init_msg_lst => fnd_api.g_false
4524: , x_return_status => l_return_status
4525: , x_msg_count => x_msg_count

Line 5642: inv_reservation_pub.update_reservation(

5638: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
5639: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
5640: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
5641: END IF;
5642: inv_reservation_pub.update_reservation(
5643: p_api_version_number => 1.0
5644: , p_init_msg_lst => fnd_api.g_false
5645: , x_return_status => l_return_status
5646: , x_msg_count => x_msg_count

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

5717: IF (l_mmtt_rec.reservation_id IS NOT NULL) THEN
5718: l_query_reservation_rec.reservation_id := l_mmtt_rec.reservation_id;
5719: IF (l_debug = 1) THEN
5720: DEBUG('reservation_id is = '|| l_mmtt_rec.reservation_id, 'Finalize_Pick_confirm');
5721: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');
5722: END IF;
5723: inv_reservation_pub.query_reservation(
5724: p_api_version_number => 1.0
5725: , x_return_status => l_return_status

Line 5723: inv_reservation_pub.query_reservation(

5719: IF (l_debug = 1) THEN
5720: DEBUG('reservation_id is = '|| l_mmtt_rec.reservation_id, 'Finalize_Pick_confirm');
5721: DEBUG('about to call inv_reservation_pub.query_reservations ', 'Finalize_Pick_confirm');
5722: END IF;
5723: inv_reservation_pub.query_reservation(
5724: p_api_version_number => 1.0
5725: , x_return_status => l_return_status
5726: , x_msg_count => l_msg_count
5727: , x_msg_data => l_msg_data

Line 5805: inv_reservation_pub.update_reservation(

5801: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
5802: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
5803: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
5804: END IF;
5805: inv_reservation_pub.update_reservation(
5806: p_api_version_number => 1.0
5807: , p_init_msg_lst => fnd_api.g_false
5808: , x_return_status => l_return_status
5809: , x_msg_count => x_msg_count

Line 5829: inv_reservation_pub.query_reservation(

5825: RAISE fnd_api.g_exc_unexpected_error;
5826: END IF;
5827:
5828: --requery reservation to reflect updated data
5829: inv_reservation_pub.query_reservation(
5830: p_api_version_number => 1.0
5831: , x_return_status => l_return_status
5832: , x_msg_count => l_msg_count
5833: , x_msg_data => l_msg_data

Line 5911: inv_reservation_pub.update_reservation(

5907: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
5908: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
5909: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
5910: END IF;
5911: inv_reservation_pub.update_reservation(
5912: p_api_version_number => 1.0
5913: , p_init_msg_lst => fnd_api.g_false
5914: , x_return_status => l_return_status
5915: , x_msg_count => x_msg_count

Line 6000: inv_reservation_pub.transfer_reservation(

5996:
5997: IF (l_debug = 1) THEN
5998: DEBUG('Transfering reservations', 'Finalize_Pick_Confirm');
5999: end if;
6000: inv_reservation_pub.transfer_reservation(
6001: p_api_version_number => 1.0
6002: , p_init_msg_lst => fnd_api.g_false
6003: , x_return_status => l_return_status
6004: , x_msg_count => x_msg_count

Line 6079: inv_reservation_pub.transfer_reservation(

6075: IF (l_debug = 1) THEN
6076: DEBUG('Transfering reservation ', 'Finalize_Pick_Confirm');
6077: DEBUG('l_primary_shipping_quantity: '|| l_primary_shipping_quantity, 'Finalize_Pick_Confirm');
6078: END IF;
6079: inv_reservation_pub.transfer_reservation(
6080: p_api_version_number => 1.0
6081: , p_init_msg_lst => fnd_api.g_false
6082: , x_return_status => l_return_status
6083: , x_msg_count => x_msg_count

Line 6208: inv_reservation_pub.query_reservation(

6204: l_mtl_reservation_rec.lot_number := l_lot_number;
6205: -- query to see whether a record with the key
6206: -- attributes already exists
6207: -- if there is, use update instead of create
6208: inv_reservation_pub.query_reservation(
6209: p_api_version_number => 1.0
6210: , p_init_msg_lst => fnd_api.g_false
6211: , x_return_status => l_return_status
6212: , x_msg_count => x_msg_count

Line 6245: inv_reservation_pub.update_reservation(

6241: END IF;
6242: IF (l_debug = 1) THEN
6243: DEBUG('Update reservation id '|| l_mtl_reservation_rec.reservation_id, 'Finalize_Pick_Confirm');
6244: END IF;
6245: inv_reservation_pub.update_reservation(
6246: p_api_version_number => 1.0
6247: , p_init_msg_lst => fnd_api.g_false
6248: , x_return_status => l_return_status
6249: , x_msg_count => x_msg_count

Line 6294: inv_reservation_pub.create_reservation(

6290: l_mtl_reservation_rec.primary_reservation_quantity := ABS(l_lot_primary_quantity);
6291: l_mtl_reservation_rec.reservation_quantity := ABS(l_lot_transaction_quantity);
6292: l_mtl_reservation_rec.secondary_reservation_quantity := ABS(l_lot_secondary_quantity);
6293: l_mtl_reservation_rec.requirement_date := SYSDATE;
6294: inv_reservation_pub.create_reservation(
6295: p_api_version_number => 1.0
6296: , p_init_msg_lst => fnd_api.g_false
6297: , x_return_status => l_return_status
6298: , x_msg_count => x_msg_count

Line 6359: inv_reservation_pub.query_reservation(

6355: l_mtl_reservation_rec.lot_number := NULL;
6356: -- query to see whether a record with the key
6357: -- attributes already exists
6358: -- if there is, use update instead of create
6359: inv_reservation_pub.query_reservation(
6360: p_api_version_number => 1.0
6361: , p_init_msg_lst => fnd_api.g_false
6362: , x_return_status => l_return_status
6363: , x_msg_count => x_msg_count

Line 6390: inv_reservation_pub.update_reservation(

6386: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
6387: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
6388: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
6389: END IF;
6390: inv_reservation_pub.update_reservation(
6391: p_api_version_number => 1.0
6392: , p_init_msg_lst => fnd_api.g_false
6393: , x_return_status => l_return_status
6394: , x_msg_count => x_msg_count

Line 6420: inv_reservation_pub.create_reservation(

6416: l_mtl_reservation_rec.requirement_date := SYSDATE;
6417: IF (l_debug = 1) THEN
6418: DEBUG('create reservation demand source'|| l_mtl_reservation_rec.demand_source_type_id, 'Finalize_Pick_Confirm');
6419: END IF;
6420: inv_reservation_pub.create_reservation(
6421: p_api_version_number => 1.0
6422: , p_init_msg_lst => fnd_api.g_false
6423: , x_return_status => l_return_status
6424: , x_msg_count => x_msg_count

Line 6555: inv_reservation_pub.update_reservation(

6551: IF ( l_mtl_reservation_rec.secondary_uom_code IS NULL ) THEN
6552: l_mtl_reservation_rec.secondary_reservation_quantity := NULL;
6553: l_mtl_reservation_rec.secondary_detailed_quantity := NULL;
6554: END IF;
6555: inv_reservation_pub.update_reservation(
6556: p_api_version_number => 1.0
6557: , p_init_msg_lst => fnd_api.g_false
6558: , x_return_status => l_return_status
6559: , x_msg_count => x_msg_count