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.WMS_TASK_DISPATCH_PUT_AWAY dependencies on WMS_EXCEPTIONS

Line 5127: -- Have to update WMS_Exceptions so that any exceptions already

5123: mydebug('complete_putaway: after updating mmtt with content lpn');
5124: END IF;
5125: END IF;--END IF (p_entire_lpn = 'N') THEN
5126:
5127: -- Have to update WMS_Exceptions so that any exceptions already
5128: -- recorded for this MMTT line will now be updated with the new txn
5129: -- header_id
5130: -- Bug# 3434940 - Performance Fixes
5131: -- Go against the org and item which are input params for

Line 5133: -- WMS_EXCEPTIONS

5129: -- header_id
5130: -- Bug# 3434940 - Performance Fixes
5131: -- Go against the org and item which are input params for
5132: -- complete_putaway since this will make use of the index in
5133: -- WMS_EXCEPTIONS
5134: UPDATE wms_exceptions
5135: SET transaction_header_id = l_txn_header_id
5136: WHERE transaction_header_id = l_orig_txn_header_id
5137: AND organization_id = p_org_id

Line 5134: UPDATE wms_exceptions

5130: -- Bug# 3434940 - Performance Fixes
5131: -- Go against the org and item which are input params for
5132: -- complete_putaway since this will make use of the index in
5133: -- WMS_EXCEPTIONS
5134: UPDATE wms_exceptions
5135: SET transaction_header_id = l_txn_header_id
5136: WHERE transaction_header_id = l_orig_txn_header_id
5137: AND organization_id = p_org_id
5138: AND inventory_item_id = p_item_id;

Line 5601: -- Have to update WMS_Exceptions so that any excpetions already

5597:
5598: END IF; --END IF (p_lpn_id = l_to_lpn_id) THEN
5599:
5600:
5601: -- Have to update WMS_Exceptions so that any excpetions already
5602: -- recorded for this MMTT line will now be updated with the new txn
5603: -- header_id
5604: -- Bug# 3434940 - Performance Fixes
5605: -- Go against the org and item which are input params for

Line 5607: -- WMS_EXCEPTIONS

5603: -- header_id
5604: -- Bug# 3434940 - Performance Fixes
5605: -- Go against the org and item which are input params for
5606: -- complete_putaway since this will make use of the index in
5607: -- WMS_EXCEPTIONS
5608: UPDATE wms_exceptions
5609: SET transaction_header_id = l_txn_header_id
5610: WHERE transaction_header_id = l_orig_txn_header_id
5611: AND organization_id = p_org_id

Line 5608: UPDATE wms_exceptions

5604: -- Bug# 3434940 - Performance Fixes
5605: -- Go against the org and item which are input params for
5606: -- complete_putaway since this will make use of the index in
5607: -- WMS_EXCEPTIONS
5608: UPDATE wms_exceptions
5609: SET transaction_header_id = l_txn_header_id
5610: WHERE transaction_header_id = l_orig_txn_header_id
5611: AND organization_id = p_org_id
5612: AND inventory_item_id = p_item_id;

Line 6911: SELECT wms_exceptions_s.NEXTVAL

6907:
6908: -- Log exception
6909:
6910: --Calculate Sequence Number
6911: SELECT wms_exceptions_s.NEXTVAL
6912: INTO l_sequence
6913: FROM DUAL;
6914:
6915: IF (l_debug = 1) THEN

Line 6920: INSERT INTO wms_exceptions

6916: mydebug('Inserting into exceptions');
6917: mydebug(l_sequence);
6918: END IF;
6919:
6920: INSERT INTO wms_exceptions
6921: (
6922: task_id
6923: , sequence_number
6924: , organization_id