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.21.12020000.2 2012/07/04 08:11:12 raminoch 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.21.12020000.2 2012/07/04 08:11:12 raminoch 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 2030: TRACE('Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

2026: BEGIN
2027: x_return_status := fnd_api.g_ret_sts_success;
2028:
2029: IF l_debug = 1 THEN
2030: TRACE('Cleaning up MMTT, MTLT and MSNT for Txn Temp ID = ' || p_transaction_temp_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2031: END IF;
2032:
2033: OPEN c_item_info;
2034: 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, l_organization_id;-- 14259665 Performance Issue

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

2034: 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, l_organization_id;-- 14259665 Performance Issue
2035: CLOSE c_item_info;
2036:
2037: IF l_debug = 1 THEN
2038: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2039: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2040: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2041: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2042: END IF;

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

2035: CLOSE c_item_info;
2036:
2037: IF l_debug = 1 THEN
2038: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2039: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2040: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2041: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2042: END IF;
2043:

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

2036:
2037: IF l_debug = 1 THEN
2038: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2039: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2040: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2041: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2042: END IF;
2043:
2044:

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

2037: IF l_debug = 1 THEN
2038: TRACE('Item ID = ' || l_inventory_item_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2039: TRACE('Lot Control = ' || l_lot_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2040: TRACE('Serial Control = ' || l_serial_control_code, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2041: TRACE('Parent Line ID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2042: END IF;
2043:
2044:
2045: IF l_parent_line_id IS NOT NULL AND p_update_parent THEN

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

2043:
2044:
2045: IF l_parent_line_id IS NOT NULL AND p_update_parent THEN
2046: IF l_debug = 1 THEN
2047: TRACE('Child Record... Updating the Parent: TxnTempID = ' || l_parent_line_id, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2048: END IF;
2049:
2050: update_parent_mmtt(
2051: x_return_status => x_return_status

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

2056: );
2057:
2058: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2059: IF l_debug = 1 THEN
2060: TRACE('Error occurred while updating the Parent Record', 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2061: END IF;
2062:
2063: RAISE fnd_api.g_exc_error;
2064: END IF;

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

2110:
2111: END IF;
2112:
2113: IF l_debug = 1 THEN
2114: TRACE('Serials unmarked in MSN = ' || l_unmarked_count, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2115: TRACE('Records deleted in MSNT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2116: END IF;
2117: END IF;
2118:

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

2111: END IF;
2112:
2113: IF l_debug = 1 THEN
2114: TRACE('Serials unmarked in MSN = ' || l_unmarked_count, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2115: TRACE('Records deleted in MSNT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2116: END IF;
2117: END IF;
2118:
2119: -- Deleting all the Lots associated with the Transaction

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

2121: DELETE mtl_transaction_lots_temp
2122: WHERE transaction_temp_id = p_transaction_temp_id;
2123:
2124: IF l_debug = 1 THEN
2125: TRACE('Records deleted in MTLT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2126: END IF;
2127: END IF;
2128:
2129: -- Deleting the Task

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

2130: DELETE wms_dispatched_tasks
2131: WHERE transaction_temp_id = p_transaction_temp_id;
2132:
2133: IF l_debug = 1 THEN
2134: TRACE('Records deleted in WDT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2135: END IF;
2136:
2137: -- Deleting the Transaction
2138: DELETE mtl_material_transactions_temp

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

2138: DELETE mtl_material_transactions_temp
2139: WHERE transaction_temp_id = p_transaction_temp_id;
2140:
2141: IF l_debug = 1 THEN
2142: TRACE('Records deleted in MMTT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2143: END IF;
2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: x_return_status := fnd_api.g_ret_sts_error;

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

2143: END IF;
2144: EXCEPTION
2145: WHEN OTHERS THEN
2146: x_return_status := fnd_api.g_ret_sts_error;
2147: TRACE('Exception Occurred = ' || SQLERRM, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2148: END delete_transaction;
2149:
2150: PROCEDURE delete_lot_ser_trx(
2151: p_trx_tmp_id IN NUMBER

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

2225: DELETE mtl_transaction_lots_temp
2226: WHERE transaction_temp_id = p_trx_tmp_id;
2227:
2228:
2229: TRACE('Records deleted in MTLT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.delete_lot_ser_trx');
2230:
2231: END IF;
2232:
2233:

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

2299:
2300: OPEN c_child_details;
2301: FETCH c_child_details INTO l_item_id, l_child_pri_qty, l_child_txn_qty, l_child_sec_txn_qty, l_child_uom, l_parent_uom; --BUG12753174
2302: IF c_child_details%NOTFOUND THEN
2303: TRACE('Either Parent TxnTempID or Child TxnTempID is invalid', 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2304: x_return_status := fnd_api.g_ret_sts_error;
2305: RETURN;
2306: END IF;
2307:

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

2389: AND primary_quantity <= 0;
2390: END IF;
2391:
2392: IF l_debug = 1 THEN
2393: TRACE('Updating the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2394: END IF;
2395:
2396: UPDATE mtl_material_transactions_temp
2397: 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 2409: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

2405: inv_release.get_j_release_level
2406: THEN
2407: IF l_debug = 1 THEN
2408: TRACE('Checking if parent should be archived: Txn Temp ID = ' || p_parent_line_id
2409: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2410: END IF;
2411:
2412: l_api_return_status := fnd_api.g_ret_sts_success;
2413: inv_parent_mmtt_pvt.process_parent

Line 2422: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');

2418: IF l_api_return_status <> fnd_api.g_ret_sts_success
2419: THEN
2420: IF l_debug = 1 THEN
2421: TRACE('Error from inv_parent_mmtt_pvt.process_parent'
2422: , 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2423: END IF;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: END IF;
2426: ELSE

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

2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2425: END IF;
2426: ELSE
2427: IF l_debug = 1 THEN
2428: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2429: END IF;
2430:
2431: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_parent_line_id;
2432: DELETE mtl_material_transactions_temp WHERE transaction_temp_id = p_parent_line_id;

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

2436: WHEN OTHERS THEN
2437: x_return_status := fnd_api.g_ret_sts_unexp_error;
2438:
2439: IF (l_debug = 1) THEN
2440: TRACE('Unexpected Error occurred - ' || SQLERRM, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2441: END IF;
2442: END update_parent_mmtt;
2443:
2444: /* Bug 13020024

Line 2477: TRACE('*** Entering inv_trx_util_pub.call_rcv_manager. TrxHeaderId='||p_trx_header_id, 'INV_TRX_UTIL_PUB.CALL_RCV_MANAGER');

2473: x_outcome:= 'SUCCESS';
2474: x_msg := NULL;
2475:
2476: IF (l_debug = 1) THEN
2477: TRACE('*** Entering inv_trx_util_pub.call_rcv_manager. TrxHeaderId='||p_trx_header_id, 'INV_TRX_UTIL_PUB.CALL_RCV_MANAGER');
2478: END IF;
2479:
2480: IF (p_trx_header_id IS NOT NULL) AND (p_trx_header_id <> -1 ) THEN
2481:

Line 2522: , 'INV_TRX_UTIL_PUB.CALL_RCV_MANAGER');

2518:
2519:
2520: IF l_debug = 1 THEN
2521: TRACE('After call rcv manager. GrpId=' || l_group_id ||',retval:'||x_return_value||',outcome:'||x_outcome||',message:'|| x_msg
2522: , 'INV_TRX_UTIL_PUB.CALL_RCV_MANAGER');
2523: END IF;
2524:
2525: END IF;
2526:

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

2531: x_return_value := -1;
2532: x_outcome := 'ERROR';
2533: x_msg := 'Failed to call Receiving Transaction Processor!';
2534: IF (l_debug = 1) THEN
2535: TRACE('Unexpected Error occurred - ' || SQLERRM, 'INV_TRX_UTIL_PUB.CALL_RCV_MANAGER');
2536: END IF;
2537: END call_rcv_manager;
2538:
2539: END inv_trx_util_pub;

Line 2539: END inv_trx_util_pub;

2535: TRACE('Unexpected Error occurred - ' || SQLERRM, 'INV_TRX_UTIL_PUB.CALL_RCV_MANAGER');
2536: END IF;
2537: END call_rcv_manager;
2538:
2539: END inv_trx_util_pub;