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_ENGINE_PVT dependencies on INV_DETAIL_UTIL_PVT

Line 285: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

281: -- Purges all records from WMS_TRANSACTIONS_TEMP for the move
282: -- order line
283: PROCEDURE purge_detail_temp_records
284: ( x_return_status OUT NOCOPY VARCHAR2
285: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
286: ) IS
287: l_api_name CONSTANT VARCHAR2(30) := 'purge_detail_temp_records';
288: l_debug NUMBER;
289: BEGIN

Line 344: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

340: -- Resolves serial number ranges and insert records into the temporary table
341: -- for detailing
342: PROCEDURE resolve_serials(
343: x_return_status OUT NOCOPY VARCHAR2
344: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
345: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
346: ) IS
347: l_api_name CONSTANT VARCHAR2(30) := 'resolve_serials';
348: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 345: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type

341: -- for detailing
342: PROCEDURE resolve_serials(
343: x_return_status OUT NOCOPY VARCHAR2
344: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
345: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
346: ) IS
347: l_api_name CONSTANT VARCHAR2(30) := 'resolve_serials';
348: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
349: --

Line 375: inv_detail_util_pvt.split_prefix_num(p_request_line_rec.serial_number_start, l_prefix, l_fm_num);

371: --
372: -- get the actual serial number based on range
373: IF p_request_line_rec.serial_number_end IS NOT NULL
374: AND p_request_line_rec.serial_number_end <> p_request_line_rec.serial_number_start THEN
375: inv_detail_util_pvt.split_prefix_num(p_request_line_rec.serial_number_start, l_prefix, l_fm_num);
376: inv_detail_util_pvt.split_prefix_num(p_request_line_rec.serial_number_end, l_prefix, l_to_num);
377: l_length_num := LENGTH(l_fm_num);
378:
379: --

Line 376: inv_detail_util_pvt.split_prefix_num(p_request_line_rec.serial_number_end, l_prefix, l_to_num);

372: -- get the actual serial number based on range
373: IF p_request_line_rec.serial_number_end IS NOT NULL
374: AND p_request_line_rec.serial_number_end <> p_request_line_rec.serial_number_start THEN
375: inv_detail_util_pvt.split_prefix_num(p_request_line_rec.serial_number_start, l_prefix, l_fm_num);
376: inv_detail_util_pvt.split_prefix_num(p_request_line_rec.serial_number_end, l_prefix, l_to_num);
377: l_length_num := LENGTH(l_fm_num);
378:
379: --
380: FOR l_counter IN 1 .. l_to_num - l_fm_num + 1 LOOP

Line 457: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

453: -- transfer transactions into issue and receipt
454: -- transaction
455: PROCEDURE prepare(
456: x_return_status OUT NOCOPY VARCHAR2
457: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
458: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
459: , p_reservations IN inv_reservation_global.mtl_reservation_tbl_type
460: , x_allow_non_partial_rules OUT NOCOPY BOOLEAN
461: ) IS

Line 458: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type

454: -- transaction
455: PROCEDURE prepare(
456: x_return_status OUT NOCOPY VARCHAR2
457: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
458: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
459: , p_reservations IN inv_reservation_global.mtl_reservation_tbl_type
460: , x_allow_non_partial_rules OUT NOCOPY BOOLEAN
461: ) IS
462: l_api_name CONSTANT VARCHAR2(30) := 'Prepare';

Line 479: l_detail_level_tbl inv_detail_util_pvt.g_detail_level_tbl_type;

475: l_pp_temp_qty NUMBER;
476: l_reserved_qty NUMBER;
477: l_index NUMBER;
478: --
479: l_detail_level_tbl inv_detail_util_pvt.g_detail_level_tbl_type;
480: l_detail_level_tbl_size NUMBER;
481: --
482: l_wms_txn_temp_tbl g_wms_txn_temp_tbl_type;
483: l_remaining_quantity NUMBER;

Line 524: -- The fuctionality in inv_detail_util_pvt for detailing serial

520: -- requires both serial number support and detail based on
521: -- reservations. So you can not just change the value of
522: -- l_serial_support to Y and expect the code will work correctly!
523: --
524: -- The fuctionality in inv_detail_util_pvt for detailing serial
525: -- numbers is different from what I mean here. Over there
526: -- we do not use any pick and put away rules, just check
527: -- which serial number is free and take it. Here when we
528: -- say detailing serial numbers, we mean we will check the

Line 548: inv_detail_util_pvt.compute_pick_detail_level(

544: END IF;
545: ELSE
546: IF p_request_context.transfer_flag
547: OR p_request_context.type_code = 2 THEN -- pick only or transfer
548: inv_detail_util_pvt.compute_pick_detail_level(
549: l_return_status
550: , p_request_line_rec
551: , p_request_context
552: , p_reservations

Line 589: inv_detail_util_pvt.get_lot_expiration_date(

585: --log_event(l_api_name, 'prepare ', 'in prepare sec qty '||l_detail_level_tbl(l_index).secondary_quantity);
586:
587: IF l_wms_txn_temp_tbl(l_index).lot_number IS NOT NULL THEN
588: l_wms_txn_temp_tbl(l_index).lot_expiration_date :=
589: inv_detail_util_pvt.get_lot_expiration_date(
590: p_request_line_rec.organization_id
591: , p_request_line_rec.inventory_item_id
592: , l_wms_txn_temp_tbl(l_index).lot_number
593: );

Line 741: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

737: --
738: PROCEDURE prepare_transfer_receipt
739: (
740: x_return_status IN OUT NOCOPY VARCHAR2
741: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
742: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
743: ) IS
744: l_api_name CONSTANT VARCHAR2(30) := 'prepare_transfer_receipt';
745: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 742: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type

738: PROCEDURE prepare_transfer_receipt
739: (
740: x_return_status IN OUT NOCOPY VARCHAR2
741: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
742: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
743: ) IS
744: l_api_name CONSTANT VARCHAR2(30) := 'prepare_transfer_receipt';
745: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
746:

Line 1065: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

1061: -- read from the table wms_transactions_temp by the order of
1062: -- revision, from_sub, to_sub, from_loc, to_loc, lot_number, serial_number
1063: PROCEDURE output_issue_or_receipt(
1064: x_return_status OUT NOCOPY VARCHAR2
1065: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
1066: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
1067: , p_plan_tasks IN BOOLEAN ---DEFAULT FALSE
1068: ) IS
1069: l_transaction_temp_id NUMBER;

Line 1066: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type

1062: -- revision, from_sub, to_sub, from_loc, to_loc, lot_number, serial_number
1063: PROCEDURE output_issue_or_receipt(
1064: x_return_status OUT NOCOPY VARCHAR2
1065: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
1066: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
1067: , p_plan_tasks IN BOOLEAN ---DEFAULT FALSE
1068: ) IS
1069: l_transaction_temp_id NUMBER;
1070:

Line 1135: l_curr_rec inv_detail_util_pvt.g_output_process_rec_type;

1131:
1132: --
1133: l_api_name CONSTANT VARCHAR2(30) := 'output_issue_or_receipt';
1134: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1135: l_curr_rec inv_detail_util_pvt.g_output_process_rec_type;
1136: l_debug NUMBER;
1137: --
1138: BEGIN
1139: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN

Line 1163: inv_detail_util_pvt.add_output(l_curr_rec);

1159: END IF;
1160: If l_debug = 1 THEN
1161: log_event(l_api_name, 'add output', 'add output');
1162: END IF;
1163: inv_detail_util_pvt.add_output(l_curr_rec);
1164: END LOOP;
1165:
1166: CLOSE l_pp_temp_csr;
1167: IF l_debug = 1 THEN

Line 1170: inv_detail_util_pvt.process_output(l_return_status

1166: CLOSE l_pp_temp_csr;
1167: IF l_debug = 1 THEN
1168: log_event(l_api_name, 'process output', 'process output');
1169: END IF;
1170: inv_detail_util_pvt.process_output(l_return_status
1171: , p_request_line_rec
1172: , p_request_context
1173: , p_plan_tasks);
1174:

Line 1231: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

1227: --
1228: -- create output suggestion records for transfer
1229: PROCEDURE combine_transfer(
1230: x_return_status OUT NOCOPY VARCHAR2
1231: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
1232: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
1233: , p_plan_tasks IN BOOLEAN ----DEFAULT FALSE
1234: ) IS
1235: l_api_name VARCHAR2(30) := 'combine_transfer';

Line 1232: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type

1228: -- create output suggestion records for transfer
1229: PROCEDURE combine_transfer(
1230: x_return_status OUT NOCOPY VARCHAR2
1231: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type
1232: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type
1233: , p_plan_tasks IN BOOLEAN ----DEFAULT FALSE
1234: ) IS
1235: l_api_name VARCHAR2(30) := 'combine_transfer';
1236: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1343: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;

1339: l_issue_tbl_size INTEGER;
1340: l_receipt_tbl_size INTEGER;
1341: l_curr_issue_idx INTEGER;
1342: l_curr_receipt_idx INTEGER;
1343: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;
1344: l_xfer_qty NUMBER;
1345: l_txn_xfer_qty NUMBER;
1346: l_sec_xfer_qty NUMBER;
1347: l_grade_code VARCHAR2(150);

Line 1501: inv_detail_util_pvt.add_output(l_output_process_rec);

1497: l_output_process_rec.pick_rule_id := l_issue_tbl(l_curr_issue_idx).rule_id;
1498: l_output_process_rec.put_away_rule_id := l_receipt_tbl(l_curr_receipt_idx).rule_id;
1499: l_output_process_rec.reservation_id := l_issue_tbl(l_curr_issue_idx).reservation_id;
1500: l_output_process_rec.lpn_id := l_issue_tbl(l_curr_issue_idx).lpn_id;
1501: inv_detail_util_pvt.add_output(l_output_process_rec);
1502:
1503: --
1504: -- get next issue suggestion if suggested issue qty is used up
1505: IF l_issue_tbl(l_curr_issue_idx).primary_quantity = 0 THEN

Line 1518: inv_detail_util_pvt.process_output(l_return_status

1514: <>
1515: NULL;
1516: END LOOP;
1517:
1518: inv_detail_util_pvt.process_output(l_return_status
1519: , p_request_line_rec
1520: , p_request_context
1521: , p_plan_tasks);
1522:

Line 1668: l_request_context inv_detail_util_pvt.g_request_context_rec_type;

1664: l_msg_data VARCHAR2(2000);
1665: l_counter INTEGER;
1666: l_type_code NUMBER;
1667: l_number NUMBER;
1668: l_request_context inv_detail_util_pvt.g_request_context_rec_type;
1669: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;
1670: l_move_order_type NUMBER;
1671: l_loc_control_from NUMBER;
1672: l_loc_control_to NUMBER;

Line 1669: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;

1665: l_counter INTEGER;
1666: l_type_code NUMBER;
1667: l_number NUMBER;
1668: l_request_context inv_detail_util_pvt.g_request_context_rec_type;
1669: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;
1670: l_move_order_type NUMBER;
1671: l_loc_control_from NUMBER;
1672: l_loc_control_to NUMBER;
1673: l_item_control_from NUMBER;

Line 1946: inv_detail_util_pvt.validate_and_init(x_return_status

1942: -- validate input and initialize
1943: If l_debug = 1 THEN
1944: log_event(l_api_name, 'Create Suggestions', 'before init');
1945: END IF;
1946: inv_detail_util_pvt.validate_and_init(x_return_status
1947: , p_transaction_temp_id
1948: , p_suggest_serial
1949: , l_request_line_rec
1950: , l_request_context);

Line 2598: inv_detail_util_pvt.init_output_process_tbl;

2594: -- Skip this step when simulating rule or strategy; we want to
2595: -- keep records in WTT, and don't want to insert into MMTT.
2596: IF l_simulation_mode IN (g_full_simulation, g_no_simulation) THEN
2597: --added by jcearley on 11/22/99 - output table must be initialized
2598: inv_detail_util_pvt.init_output_process_tbl;
2599:
2600: IF l_request_context.transaction_action_id IN (2, 3, 28) THEN
2601: combine_transfer(l_return_status, l_request_line_rec, l_request_context, p_plan_tasks);
2602: ELSE

Line 2625: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id

2621: , p_validation_level => fnd_api.g_valid_level_full
2622: , x_return_status => l_return_status
2623: , x_msg_count => l_msg_count
2624: , x_msg_data => l_msg_data
2625: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id
2626: , p_insert_lot_flag => inv_detail_util_pvt.g_insert_lot_flag
2627: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag
2628: );
2629: END IF;

Line 2626: , p_insert_lot_flag => inv_detail_util_pvt.g_insert_lot_flag

2622: , x_return_status => l_return_status
2623: , x_msg_count => l_msg_count
2624: , x_msg_data => l_msg_data
2625: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id
2626: , p_insert_lot_flag => inv_detail_util_pvt.g_insert_lot_flag
2627: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag
2628: );
2629: END IF;
2630:

Line 2627: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag

2623: , x_msg_count => l_msg_count
2624: , x_msg_data => l_msg_data
2625: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id
2626: , p_insert_lot_flag => inv_detail_util_pvt.g_insert_lot_flag
2627: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag
2628: );
2629: END IF;
2630:
2631: -- Delete records from WMS_TRANSACTIONS_TEMP