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 525: -- The fuctionality in inv_detail_util_pvt for detailing serial

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

Line 549: inv_detail_util_pvt.compute_pick_detail_level(

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

Line 593: inv_detail_util_pvt.get_lot_expiration_date(

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

Line 745: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

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

Line 746: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type

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

Line 1069: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

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

Line 1070: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type

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

Line 1139: l_curr_rec inv_detail_util_pvt.g_output_process_rec_type;

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

Line 1167: inv_detail_util_pvt.add_output(l_curr_rec);

1163: END IF;
1164: If l_debug = 1 THEN
1165: log_event(l_api_name, 'add output', 'add output');
1166: END IF;
1167: inv_detail_util_pvt.add_output(l_curr_rec);
1168: END LOOP;
1169:
1170: CLOSE l_pp_temp_csr;
1171: IF l_debug = 1 THEN

Line 1174: inv_detail_util_pvt.process_output(l_return_status

1170: CLOSE l_pp_temp_csr;
1171: IF l_debug = 1 THEN
1172: log_event(l_api_name, 'process output', 'process output');
1173: END IF;
1174: inv_detail_util_pvt.process_output(l_return_status
1175: , p_request_line_rec
1176: , p_request_context
1177: , p_plan_tasks);
1178:

Line 1235: , p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type

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

Line 1236: , p_request_context IN inv_detail_util_pvt.g_request_context_rec_type

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

Line 1347: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;

1343: l_issue_tbl_size INTEGER;
1344: l_receipt_tbl_size INTEGER;
1345: l_curr_issue_idx INTEGER;
1346: l_curr_receipt_idx INTEGER;
1347: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;
1348: l_xfer_qty NUMBER;
1349: l_txn_xfer_qty NUMBER;
1350: l_sec_xfer_qty NUMBER;
1351: l_grade_code VARCHAR2(150);

Line 1505: inv_detail_util_pvt.add_output(l_output_process_rec);

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

Line 1522: inv_detail_util_pvt.process_output(l_return_status

1518: <>
1519: NULL;
1520: END LOOP;
1521:
1522: inv_detail_util_pvt.process_output(l_return_status
1523: , p_request_line_rec
1524: , p_request_context
1525: , p_plan_tasks);
1526:

Line 1673: l_request_context inv_detail_util_pvt.g_request_context_rec_type;

1669: l_msg_data VARCHAR2(2000);
1670: l_counter PLS_INTEGER; --8809951 changed to Pls_Integer
1671: l_type_code PLS_INTEGER; --8809951 changed to Pls_Integer
1672: l_number NUMBER;
1673: l_request_context inv_detail_util_pvt.g_request_context_rec_type;
1674: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;
1675: l_move_order_type PLS_INTEGER; --8809951 changed to Pls_Integer
1676: l_loc_control_from PLS_INTEGER; --8809951 changed to Pls_Integer
1677: l_loc_control_to PLS_INTEGER; --8809951 changed to Pls_Integer

Line 1674: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;

1670: l_counter PLS_INTEGER; --8809951 changed to Pls_Integer
1671: l_type_code PLS_INTEGER; --8809951 changed to Pls_Integer
1672: l_number NUMBER;
1673: l_request_context inv_detail_util_pvt.g_request_context_rec_type;
1674: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;
1675: l_move_order_type PLS_INTEGER; --8809951 changed to Pls_Integer
1676: l_loc_control_from PLS_INTEGER; --8809951 changed to Pls_Integer
1677: l_loc_control_to PLS_INTEGER; --8809951 changed to Pls_Integer
1678: l_item_control_from PLS_INTEGER; --8809951 changed to Pls_Integer

Line 2005: inv_detail_util_pvt.validate_and_init(x_return_status

2001: -- validate input and initialize
2002: If l_debug = 1 THEN
2003: log_event(l_api_name, 'Create Suggestions', 'before init');
2004: END IF;
2005: inv_detail_util_pvt.validate_and_init(x_return_status
2006: , p_transaction_temp_id
2007: , p_suggest_serial
2008: , l_request_line_rec
2009: , l_request_context

Line 2858: inv_detail_util_pvt.init_output_process_tbl;

2854: -- multiple times in a single session with same move_order_line_id
2855:
2856: IF l_simulation_mode IN (g_full_simulation, g_no_simulation, g_available_inventory ) THEN
2857: --added by jcearley on 11/22/99 - output table must be initialized
2858: inv_detail_util_pvt.init_output_process_tbl;
2859:
2860: IF l_request_context.transaction_action_id IN (2, 3, 28) THEN
2861: combine_transfer(l_return_status, l_request_line_rec, l_request_context, p_plan_tasks);
2862: ELSE

Line 2885: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id

2881: , p_validation_level => fnd_api.g_valid_level_full
2882: , x_return_status => l_return_status
2883: , x_msg_count => l_msg_count
2884: , x_msg_data => l_msg_data
2885: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id
2886: , p_insert_lot_flag => inv_detail_util_pvt.g_insert_lot_flag
2887: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag
2888: );
2889: END IF;

Line 2886: , p_insert_lot_flag => inv_detail_util_pvt.g_insert_lot_flag

2882: , x_return_status => l_return_status
2883: , x_msg_count => l_msg_count
2884: , x_msg_data => l_msg_data
2885: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id
2886: , p_insert_lot_flag => inv_detail_util_pvt.g_insert_lot_flag
2887: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag
2888: );
2889: END IF;
2890:

Line 2887: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag

2883: , x_msg_count => l_msg_count
2884: , x_msg_data => l_msg_data
2885: , p_txn_header_id => inv_detail_util_pvt.g_transaction_header_id
2886: , p_insert_lot_flag => inv_detail_util_pvt.g_insert_lot_flag
2887: , p_insert_serial_flag => inv_detail_util_pvt.g_insert_serial_flag
2888: );
2889: END IF;
2890:
2891: -- Delete records from WMS_TRANSACTIONS_TEMP

Line 2901: /* inv_detail_util_pvt.validate_and_init calls

2897: --
2898: END IF;
2899:
2900: -- 12942776
2901: /* inv_detail_util_pvt.validate_and_init calls
2902: inv_detail_util_pvt.get_request_context which has updated the primary_quantity
2903: based on the quantity, quantity detailed calculations which is not reverted back
2904: after creating suggestion. Reverting the primary quantity back to correct quantity
2905: for inbound mtrls.. */

Line 2902: inv_detail_util_pvt.get_request_context which has updated the primary_quantity

2898: END IF;
2899:
2900: -- 12942776
2901: /* inv_detail_util_pvt.validate_and_init calls
2902: inv_detail_util_pvt.get_request_context which has updated the primary_quantity
2903: based on the quantity, quantity detailed calculations which is not reverted back
2904: after creating suggestion. Reverting the primary quantity back to correct quantity
2905: for inbound mtrls.. */
2906: -- collecting values of current mtrl...