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.MTL_MMTT_T dependencies on INV_TRX_UTIL_PUB

Line 50: inv_trx_util_pub.TRACE('INSERTING', 'TRIGGER:', 9);

46: -- Bug# 1524413
47: -- if ((INSERTING) and (:new.posting_flag = 'Y') and
48: IF ((INSERTING) AND ((:NEW.transaction_status <> 2) OR (:NEW.transaction_status IS NULL))) THEN
49:
50: inv_trx_util_pub.TRACE('INSERTING', 'TRIGGER:', 9);
51: l_sql_stmt_num := 2;
52: l_organization_id := :NEW.organization_id;
53: l_inventory_item_id := :NEW.inventory_item_id;
54: l_locator_id := :NEW.locator_id;

Line 67: inv_trx_util_pub.TRACE(

63: l_lpn_id := :NEW.lpn_id;
64: l_sql_stmt_num := 3;
65:
66: IF (l_debug=1) THEN
67: inv_trx_util_pub.TRACE(
68: 'IN DB trigger- The values are l_transaction_action is '
69: || TO_CHAR(l_transaction_action_id)
70: || ' - '
71: || 'transfer organization_id '

Line 181: inv_trx_util_pub.TRACE('In DB trigger -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);

177: , p_transfer_location_id => l_transfer_to_location
178: , p_source => NULL
179: );
180: IF (l_debug =1) THEN
181: inv_trx_util_pub.TRACE('In DB trigger -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);
182: END IF;
183: ELSE
184: inv_loc_wms_utils.update_lpn_loc_curr_capacity(
185: x_return_status => l_return_status

Line 212: inv_trx_util_pub.TRACE('In DB trigger -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);

208: , p_transfer_location_id => l_transfer_to_location
209: , p_source => NULL
210: );
211: IF (l_debug =1) THEN
212: inv_trx_util_pub.TRACE('In DB trigger -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);
213: END IF;
214: END IF;
215: END IF;
216: ELSE

Line 218: inv_trx_util_pub.TRACE('IN DB trigger-for loose item', 'update_current_capacity', 4);

214: END IF;
215: END IF;
216: ELSE
217: IF (l_debug =1) THEN
218: inv_trx_util_pub.TRACE('IN DB trigger-for loose item', 'update_current_capacity', 4);
219: END IF;
220: /*
221: ** The following transaction actions need to be flagged as issues
222: ** Subinventory Xfers 2 inv_globals.G_Action_Subxfr

Line 346: inv_trx_util_pub.TRACE('UPDATING', 'TRIGGER:', 9);

342: -- Bug 4494281 the last AND condition above is required in order to avoid the updation of locator capacity matching the above condition, for staging trxfr
343: -- the or condition is necessary for bulk pack, where the mmtt record initially does
344: -- not have the transfer lpn stamped. but it is later update.
345: IF (l_debug=1) THEN
346: inv_trx_util_pub.TRACE('UPDATING', 'TRIGGER:', 9);
347: END IF;
348: l_sql_stmt_num := 11;
349: l_organization_id := :NEW.organization_id;
350: l_inventory_item_id := :NEW.inventory_item_id;

Line 367: inv_trx_util_pub.TRACE(

363: l_wms_task_type := :NEW.wms_task_type;
364: l_sql_stmt_num := 12;
365: l_transaction_source_type_id := :NEW.transaction_source_type_id; --Added for Bug# 4046825.
366: IF (l_debug=1) THEN
367: inv_trx_util_pub.TRACE(
368: 'IN DB trigger- The value of l_transaction_action is '
369: || TO_CHAR(l_transaction_action_id)
370: || ' - '
371: || 'transfer organization_id '

Line 422: inv_trx_util_pub.TRACE(

418: AND NOT ( l_content_lpn_id IS NOT NULL AND l_transaction_action_id = inv_globals.G_Action_Subxfr AND l_wms_task_type in (4,5)) --4655988
419: ) THEN
420:
421: IF (l_debug=1) THEN
422: inv_trx_util_pub.TRACE(
423: 'UPDATING '
424: || 'l_txn_action_id :' || l_transaction_action_id
425: || 'l_wms_task_type :' || l_wms_task_type );
426: END IF;

Line 451: inv_trx_util_pub.TRACE('IN DB TRIGGER -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);

447: , p_from_loc_id => l_locator_id
448: , p_from_org_id => l_organization_id
449: );
450: IF (l_debug=1) THEN
451: inv_trx_util_pub.TRACE('IN DB TRIGGER -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);
452: END IF;
453: END IF; /*End of fix for Bug#4046825.*/
454: --Revert Suggested Capacity.
455: inv_loc_wms_utils.revert_loc_suggested_capacity(

Line 506: inv_trx_util_pub.TRACE('In DB TRIGGER -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);

502: , p_quantity => l_primary_quantity
503: , p_container_item_id => l_container_item_id
504: , p_cartonization_id => l_cartonization_id
505: );
506: inv_trx_util_pub.TRACE('In DB TRIGGER -status is ' || l_return_status, 'UPDATE_LPN_LOC_CURR_CAPACITY', 4);
507: END IF; /*End of fix for Bug#4046825.*/
508: --Revert Suggested Capacity.
509: inv_loc_wms_utils.revert_loc_suggested_capacity(
510: x_return_status => l_return_status

Line 522: inv_trx_util_pub.TRACE('IN DB trigger-for loose item', 'update_current_capacity', 4);

518: , p_quantity => l_primary_quantity
519: );
520: END IF;
521: ELSE
522: inv_trx_util_pub.TRACE('IN DB trigger-for loose item', 'update_current_capacity', 4);
523: inv_trx_util_pub.TRACE('transaction action id is:' || l_transaction_action_id, 'TRIGGER:', 9);
524:
525: -- Picking Suggestion (Txn action 2,3,28)
526: IF (l_transaction_action_id IN(2,3,28)) THEN

Line 523: inv_trx_util_pub.TRACE('transaction action id is:' || l_transaction_action_id, 'TRIGGER:', 9);

519: );
520: END IF;
521: ELSE
522: inv_trx_util_pub.TRACE('IN DB trigger-for loose item', 'update_current_capacity', 4);
523: inv_trx_util_pub.TRACE('transaction action id is:' || l_transaction_action_id, 'TRIGGER:', 9);
524:
525: -- Picking Suggestion (Txn action 2,3,28)
526: IF (l_transaction_action_id IN(2,3,28)) THEN
527: l_primary_quantity := ABS(l_primary_quantity);