APPS.WMS_CONTAINER_PVT dependencies on INV_TRX_UTIL_PUB

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

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

Line 6848: x_error_code := inv_trx_util_pub.insert_line_trx(

6844:
6845: IF (l_debug = 1) THEN
6846: mdebug('trx header id for cartonization created: '|| TO_CHAR(l_trx_header_id), G_INFO);
6847: END IF;
6848: x_error_code := inv_trx_util_pub.insert_line_trx(
6849: p_trx_hdr_id=> l_trx_header_id,
6850: p_item_id=> p_inventory_item_id,
6851: p_revision=> p_revision,
6852: p_org_id=> p_organization_id,

Line 6900: x_error_code := inv_trx_util_pub.insert_lot_trx(

6896: IF ( x_error_code = 0 AND l_lot_number IS NOT NULL ) THEN
6897: IF (l_debug = 1) THEN
6898: mdebug('Insert lot entry in MTL_LOT_NUMBER_TEMP lot='|| l_lot_number, G_INFO);
6899: END IF;
6900: x_error_code := inv_trx_util_pub.insert_lot_trx(
6901: p_trx_tmp_id=> l_trx_tmp_id,
6902: p_user_id=> fnd_global.user_id,
6903: p_lot_number=> l_lot_number,
6904: p_trx_qty=> p_quantity,

Line 6933: x_error_code := inv_trx_util_pub.insert_ser_trx(

6929: mdebug('inserting serials '|| l_serial_number_from || '-' || l_serial_number_to || ' into mmtt', G_INFO);
6930: mdebug('with l_trx_tmp_id='|| l_trx_tmp_id, G_INFO);
6931: END IF;
6932: --Insert serials into MTL_SERIAL_NUMBERS_TEMP
6933: x_error_code := inv_trx_util_pub.insert_ser_trx(
6934: p_trx_tmp_id=> l_trx_tmp_id,
6935: p_user_id=> fnd_global.user_id,
6936: p_fm_ser_num=> l_serial_number_from,
6937: p_to_ser_num=> l_serial_number_to,

Line 7128: x_error_code := inv_trx_util_pub.insert_line_trx(

7124:
7125: IF (l_debug = 1) THEN
7126: mdebug('packing lpn: '|| TO_CHAR(l_lpn_to_pack) || ' with qty ' || TO_CHAR(l_primary_quantity));
7127: END IF;
7128: x_error_code := inv_trx_util_pub.insert_line_trx(
7129: p_trx_hdr_id=> l_trx_header_id,
7130: p_item_id=> p_inventory_item_id,
7131: p_revision=> p_revision,
7132: p_org_id=> p_organization_id,

Line 7180: x_error_code := inv_trx_util_pub.insert_lot_trx(

7176: IF ( x_error_code = 0 AND l_lot_number IS NOT NULL ) THEN
7177: IF (l_debug = 1) THEN
7178: mdebug('Insert lot entry in MTL_LOT_NUMBER_TEMP lot='|| l_lot_number, G_INFO);
7179: END IF;
7180: x_error_code := inv_trx_util_pub.insert_lot_trx(
7181: p_trx_tmp_id=> l_trx_tmp_id,
7182: p_user_id=> fnd_global.user_id,
7183: p_lot_number=> l_lot_number,
7184: p_trx_qty=> l_primary_quantity,

Line 7211: x_error_code := inv_trx_util_pub.insert_ser_trx(

7207: IF (l_debug = 1) THEN
7208: mdebug('inserting serials '|| l_serial_number_from || '-' || l_serial_number_to || ' into mmtt', G_INFO);
7209: mdebug('with l_trx_tmp_id='|| l_trx_tmp_id, G_INFO);
7210: END IF;
7211: x_error_code := inv_trx_util_pub.insert_ser_trx(
7212: p_trx_tmp_id=> l_trx_tmp_id,
7213: p_user_id=> fnd_global.user_id,
7214: p_fm_ser_num=> l_serial_number_from,
7215: p_to_ser_num=> l_serial_number_to,

Line 8226: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (

8222:
8223: FOR Nested_LPN_rec IN Nested_LPN_cur LOOP
8224: -- Insert an 'UNPACK' transaction of child LPN from parent LPN into
8225: -- MTL_MATERIAL_TRANSACTIONS_TEMP using standard MMTT insert API
8226: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (
8227: p_trx_hdr_id => l_trx_hdr_id
8228: , p_item_id => -1
8229: , p_org_id => p_organization_id
8230: , p_subinv_code => Nested_LPN_rec.subinventory_code

Line 8322: l_return_status := INV_TRX_UTIL_PUB.Insert_Lot_Trx(

8318: ELSE
8319: l_converted_qty := l_crnt_item_rec.lot_quantity;
8320: END IF;
8321: -- Insert record into MTL_TRANSACTIONS_LOTS_TEMP
8322: l_return_status := INV_TRX_UTIL_PUB.Insert_Lot_Trx(
8323: p_trx_tmp_id => l_trx_tmp_id
8324: , p_user_id => fnd_global.user_id
8325: , p_lot_number => l_crnt_item_rec.lot_number
8326: , p_trx_qty => l_crnt_item_rec.lot_quantity

Line 8400: l_return_status := INV_TRX_UTIL_PUB.Insert_Ser_Trx (

8396: IF (l_debug = 1) THEN
8397: mdebug('Insert ser tempid='||l_ser_tmp_id||' fmsn='||l_fm_serial||' tosn='||l_to_serial, 4);
8398: END IF;
8399: -- Range finished or last serial processed, insert serial with API and reset from serial
8400: l_return_status := INV_TRX_UTIL_PUB.Insert_Ser_Trx (
8401: p_trx_tmp_id => l_ser_tmp_id
8402: , p_user_id => fnd_global.user_id
8403: , p_fm_ser_num => l_fm_serial
8404: , p_to_ser_num => l_to_serial

Line 8629: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (

8625: --Every nested lpn will need to be deconsolidated from the outermost lpn,
8626: FOR lpn_rec IN nested_lpn_cursor LOOP
8627: -- Insert an 'UNPACK' transaction of child LPN from parent LPN into
8628: -- MTL_MATERIAL_TRANSACTIONS_TEMP using standard MMTT insert API
8629: l_return_status := INV_TRX_UTIL_PUB.INSERT_LINE_TRX (
8630: p_trx_hdr_id => l_trx_hdr_id
8631: , p_item_id => -1
8632: , p_org_id => p_organization_id
8633: , p_subinv_code => lpn_rec.subinventory_code