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_TRX_UTIL_PUB dependencies on INV_TRX_UTIL_PUB

Line 1: PACKAGE BODY inv_trx_util_pub AS

1: PACKAGE BODY inv_trx_util_pub AS
2: /* $Header: INVTRXUB.pls 120.8.12010000.3 2008/09/09 11:26:37 appldev ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_TRX_UTIL_PUB';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_TRX_UTIL_PUB';

1: PACKAGE BODY inv_trx_util_pub AS
2: /* $Header: INVTRXUB.pls 120.8.12010000.3 2008/09/09 11:26:37 appldev ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_TRX_UTIL_PUB';
5:
6: PROCEDURE TRACE(p_mesg VARCHAR2, p_mod VARCHAR2, p_level NUMBER := 9) IS
7: BEGIN
8: inv_log_util.TRACE(p_mesg, p_mod, p_level);

Line 1889: TRACE('Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1885: BEGIN
1886: x_return_status := fnd_api.g_ret_sts_success;
1887:
1888: IF l_debug = 1 THEN
1889: TRACE('Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1890: END IF;
1891:
1892: OPEN c_item_info;
1893: FETCH c_item_info INTO l_inventory_item_id, l_lot_control_code, l_serial_control_code, l_parent_line_id,l_txn_hdr_id;

Line 1897: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1893: FETCH c_item_info INTO l_inventory_item_id, l_lot_control_code, l_serial_control_code, l_parent_line_id,l_txn_hdr_id;
1894: CLOSE c_item_info;
1895:
1896: IF l_debug = 1 THEN
1897: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1898: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1899: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1900: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1901: END IF;

Line 1898: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1894: CLOSE c_item_info;
1895:
1896: IF l_debug = 1 THEN
1897: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1898: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1899: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1900: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1901: END IF;
1902:

Line 1899: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1895:
1896: IF l_debug = 1 THEN
1897: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1898: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1899: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1900: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1901: END IF;
1902:
1903:

Line 1900: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1896: IF l_debug = 1 THEN
1897: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1898: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1899: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1900: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1901: END IF;
1902:
1903:
1904: IF l_parent_line_id IS NOT NULL AND p_update_parent THEN

Line 1906: TRACE('Child Record... Updating the Parent: TxnTempID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1902:
1903:
1904: IF l_parent_line_id IS NOT NULL AND p_update_parent THEN
1905: IF l_debug = 1 THEN
1906: TRACE('Child Record... Updating the Parent: TxnTempID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1907: END IF;
1908:
1909: update_parent_mmtt(
1910: x_return_status => x_return_status

Line 1919: TRACE('Error occurred while updating the Parent Record', 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1915: );
1916:
1917: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1918: IF l_debug = 1 THEN
1919: TRACE('Error occurred while updating the Parent Record', 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1920: END IF;
1921:
1922: RAISE fnd_api.g_exc_error;
1923: END IF;

Line 1959: TRACE('Serials unmarked in MSN = ' || l_unmarked_count, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1955:
1956: END IF;
1957:
1958: IF l_debug = 1 THEN
1959: TRACE('Serials unmarked in MSN = ' || l_unmarked_count, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1960: TRACE('Records deleted in MSNT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1961: END IF;
1962: END IF;
1963:

Line 1960: TRACE('Records deleted in MSNT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1956: END IF;
1957:
1958: IF l_debug = 1 THEN
1959: TRACE('Serials unmarked in MSN = ' || l_unmarked_count, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1960: TRACE('Records deleted in MSNT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1961: END IF;
1962: END IF;
1963:
1964: -- Deleting all the Lots associated with the Transaction

Line 1970: TRACE('Records deleted in MTLT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1966: DELETE mtl_transaction_lots_temp
1967: WHERE transaction_temp_id = p_transaction_temp_id;
1968:
1969: IF l_debug = 1 THEN
1970: TRACE('Records deleted in MTLT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1971: END IF;
1972: END IF;
1973:
1974: -- Deleting the Task

Line 1979: TRACE('Records deleted in WDT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1975: DELETE wms_dispatched_tasks
1976: WHERE transaction_temp_id = p_transaction_temp_id;
1977:
1978: IF l_debug = 1 THEN
1979: TRACE('Records deleted in WDT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1980: END IF;
1981:
1982: -- Deleting the Transaction
1983: DELETE mtl_material_transactions_temp

Line 1987: TRACE('Records deleted in MMTT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1983: DELETE mtl_material_transactions_temp
1984: WHERE transaction_temp_id = p_transaction_temp_id;
1985:
1986: IF l_debug = 1 THEN
1987: TRACE('Records deleted in MMTT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1988: END IF;
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: x_return_status := fnd_api.g_ret_sts_error;

Line 1992: TRACE('Exception Occurred = ' || SQLERRM, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

1988: END IF;
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: x_return_status := fnd_api.g_ret_sts_error;
1992: TRACE('Exception Occurred = ' || SQLERRM, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1993: END delete_transaction;
1994:
1995: PROCEDURE delete_lot_ser_trx(
1996: p_trx_tmp_id IN NUMBER

Line 2074: TRACE('Records deleted in MTLT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.delete_lot_ser_trx');

2070: DELETE mtl_transaction_lots_temp
2071: WHERE transaction_temp_id = p_trx_tmp_id;
2072:
2073:
2074: TRACE('Records deleted in MTLT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.delete_lot_ser_trx');
2075:
2076: END IF;
2077:
2078:

Line 2132: TRACE('Either Parent TxnTempID or Child TxnTempID is invalid', 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

2128:
2129: OPEN c_child_details;
2130: FETCH c_child_details INTO l_item_id, l_child_pri_qty, l_child_txn_qty, l_child_uom, l_parent_uom;
2131: IF c_child_details%NOTFOUND THEN
2132: TRACE('Either Parent TxnTempID or Child TxnTempID is invalid', 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2133: x_return_status := fnd_api.g_ret_sts_error;
2134: RETURN;
2135: END IF;
2136:

Line 2198: TRACE('Updating the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

2194: AND primary_quantity <= 0;
2195: END IF;
2196:
2197: IF l_debug = 1 THEN
2198: TRACE('Updating the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2199: END IF;
2200:
2201: UPDATE mtl_material_transactions_temp
2202: SET transaction_quantity = transaction_quantity - inv_convert.inv_um_convert(inventory_item_id, NULL, l_child_txn_qty, l_child_uom, transaction_uom, NULL, NULL)

Line 2213: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

2209: inv_release.get_j_release_level
2210: THEN
2211: IF l_debug = 1 THEN
2212: TRACE('Checking if parent should be archived: Txn Temp ID = ' || p_parent_line_id
2213: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2214: END IF;
2215:
2216: l_api_return_status := fnd_api.g_ret_sts_success;
2217: inv_parent_mmtt_pvt.process_parent

Line 2226: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

2222: IF l_api_return_status <> fnd_api.g_ret_sts_success
2223: THEN
2224: IF l_debug = 1 THEN
2225: TRACE('Error from inv_parent_mmtt_pvt.process_parent'
2226: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2227: END IF;
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230: ELSE

Line 2232: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230: ELSE
2231: IF l_debug = 1 THEN
2232: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2233: END IF;
2234:
2235: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_parent_line_id;
2236: DELETE mtl_material_transactions_temp WHERE transaction_temp_id = p_parent_line_id;

Line 2244: TRACE('Unexpected Error occurred - ' || SQLERRM, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

2240: WHEN OTHERS THEN
2241: x_return_status := fnd_api.g_ret_sts_unexp_error;
2242:
2243: IF (l_debug = 1) THEN
2244: TRACE('Unexpected Error occurred - ' || SQLERRM, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2245: END IF;
2246: END update_parent_mmtt;
2247:
2248: END inv_trx_util_pub;

Line 2248: END inv_trx_util_pub;

2244: TRACE('Unexpected Error occurred - ' || SQLERRM, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2245: END IF;
2246: END update_parent_mmtt;
2247:
2248: END inv_trx_util_pub;