APPS.WMS_CONTAINER_PVT dependencies on INV_TRX_UTIL_PUB

Line 33: INV_TRX_UTIL_PUB.TRACE(msg, g_pkg_name, LEVEL);

29:
30: PROCEDURE mdebug(msg IN VARCHAR2, LEVEL NUMBER := G_MESSAGE) IS
31: BEGIN
32: --DBMS_OUTPUT.put_line(msg);
33: INV_TRX_UTIL_PUB.TRACE(msg, g_pkg_name, LEVEL);
34: END;
35:
36: FUNCTION Convert_UOM (
37: p_inventory_item_id IN NUMBER

Line 7408: x_error_code := inv_trx_util_pub.insert_line_trx(

7404:
7405: IF (l_debug = 1) THEN
7406: mdebug('trx header id for cartonization created: '|| TO_CHAR(l_trx_header_id), G_INFO);
7407: END IF;
7408: x_error_code := inv_trx_util_pub.insert_line_trx(
7409: p_trx_hdr_id=> l_trx_header_id,
7410: p_item_id=> p_inventory_item_id,
7411: p_revision=> p_revision,
7412: p_org_id=> p_organization_id,

Line 7460: x_error_code := inv_trx_util_pub.insert_lot_trx(

7456: IF ( x_error_code = 0 AND l_lot_number IS NOT NULL ) THEN
7457: IF (l_debug = 1) THEN
7458: mdebug('Insert lot entry in MTL_LOT_NUMBER_TEMP lot='|| l_lot_number, G_INFO);
7459: END IF;
7460: x_error_code := inv_trx_util_pub.insert_lot_trx(
7461: p_trx_tmp_id=> l_trx_tmp_id,
7462: p_user_id=> fnd_global.user_id,
7463: p_lot_number=> l_lot_number,
7464: p_trx_qty=> p_quantity,

Line 7493: x_error_code := inv_trx_util_pub.insert_ser_trx(

7489: mdebug('inserting serials '|| l_serial_number_from || '-' || l_serial_number_to || ' into mmtt', G_INFO);
7490: mdebug('with l_trx_tmp_id='|| l_trx_tmp_id, G_INFO);
7491: END IF;
7492: --Insert serials into MTL_SERIAL_NUMBERS_TEMP
7493: x_error_code := inv_trx_util_pub.insert_ser_trx(
7494: p_trx_tmp_id=> l_trx_tmp_id,
7495: p_user_id=> fnd_global.user_id,
7496: p_fm_ser_num=> l_serial_number_from,
7497: p_to_ser_num=> l_serial_number_to,

Line 7688: x_error_code := inv_trx_util_pub.insert_line_trx(

7684:
7685: IF (l_debug = 1) THEN
7686: mdebug('packing lpn: '|| TO_CHAR(l_lpn_to_pack) || ' with qty ' || TO_CHAR(l_primary_quantity));
7687: END IF;
7688: x_error_code := inv_trx_util_pub.insert_line_trx(
7689: p_trx_hdr_id=> l_trx_header_id,
7690: p_item_id=> p_inventory_item_id,
7691: p_revision=> p_revision,
7692: p_org_id=> p_organization_id,

Line 7740: x_error_code := inv_trx_util_pub.insert_lot_trx(

7736: IF ( x_error_code = 0 AND l_lot_number IS NOT NULL ) THEN
7737: IF (l_debug = 1) THEN
7738: mdebug('Insert lot entry in MTL_LOT_NUMBER_TEMP lot='|| l_lot_number, G_INFO);
7739: END IF;
7740: x_error_code := inv_trx_util_pub.insert_lot_trx(
7741: p_trx_tmp_id=> l_trx_tmp_id,
7742: p_user_id=> fnd_global.user_id,
7743: p_lot_number=> l_lot_number,
7744: p_trx_qty=> l_primary_quantity,

Line 7771: x_error_code := inv_trx_util_pub.insert_ser_trx(

7767: IF (l_debug = 1) THEN
7768: mdebug('inserting serials '|| l_serial_number_from || '-' || l_serial_number_to || ' into mmtt', G_INFO);
7769: mdebug('with l_trx_tmp_id='|| l_trx_tmp_id, G_INFO);
7770: END IF;
7771: x_error_code := inv_trx_util_pub.insert_ser_trx(
7772: p_trx_tmp_id=> l_trx_tmp_id,
7773: p_user_id=> fnd_global.user_id,
7774: p_fm_ser_num=> l_serial_number_from,
7775: p_to_ser_num=> l_serial_number_to,

Line 8797: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (

8793:
8794: FOR Nested_LPN_rec IN Nested_LPN_cur LOOP
8795: -- Insert an 'UNPACK' transaction of child LPN from parent LPN into
8796: -- MTL_MATERIAL_TRANSACTIONS_TEMP using standard MMTT insert API
8797: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (
8798: p_trx_hdr_id => l_trx_hdr_id
8799: , p_item_id => -1
8800: , p_org_id => p_organization_id
8801: , p_subinv_code => Nested_LPN_rec.subinventory_code

Line 8893: l_return_status := INV_TRX_UTIL_PUB.Insert_Lot_Trx(

8889: ELSE
8890: l_converted_qty := l_crnt_item_rec.lot_quantity;
8891: END IF;
8892: -- Insert record into MTL_TRANSACTIONS_LOTS_TEMP
8893: l_return_status := INV_TRX_UTIL_PUB.Insert_Lot_Trx(
8894: p_trx_tmp_id => l_trx_tmp_id
8895: , p_user_id => fnd_global.user_id
8896: , p_lot_number => l_crnt_item_rec.lot_number
8897: , p_trx_qty => l_crnt_item_rec.lot_quantity

Line 8971: l_return_status := INV_TRX_UTIL_PUB.Insert_Ser_Trx (

8967: IF (l_debug = 1) THEN
8968: mdebug('Insert ser tempid='||l_ser_tmp_id||' fmsn='||l_fm_serial||' tosn='||l_to_serial, 4);
8969: END IF;
8970: -- Range finished or last serial processed, insert serial with API and reset from serial
8971: l_return_status := INV_TRX_UTIL_PUB.Insert_Ser_Trx (
8972: p_trx_tmp_id => l_ser_tmp_id
8973: , p_user_id => fnd_global.user_id
8974: , p_fm_ser_num => l_fm_serial
8975: , p_to_ser_num => l_to_serial

Line 9202: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (

9198: --Every nested lpn will need to be deconsolidated from the outermost lpn,
9199: FOR lpn_rec IN nested_lpn_cursor LOOP
9200: -- Insert an 'UNPACK' transaction of child LPN from parent LPN into
9201: -- MTL_MATERIAL_TRANSACTIONS_TEMP using standard MMTT insert API
9202: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (
9203: p_trx_hdr_id => l_trx_hdr_id
9204: , p_item_id => -1
9205: , p_org_id => p_organization_id
9206: , p_subinv_code => lpn_rec.subinventory_code