DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on INV_TRX_UTIL_PUB

Line 8727: inv_trx_util_pub.insert_line_trx

8723:
8724: IF l_lpn_context = 3 OR l_lpn_context = 2 THEN --added context =2 bug 4189437
8725:
8726: l_return :=
8727: inv_trx_util_pub.insert_line_trx
8728: (p_trx_hdr_id => l_txn_header_id,
8729: p_item_id => v_mo_line.inventory_item_id,
8730: p_revision => v_mo_line.revision,
8731: p_org_id => p_organization_id,

Line 8756: inv_trx_util_pub.insert_line_trx

8752: --BUG 3356366: Insert MMTT with txn_status 2 so that it won't
8753: --invoke the DB trigger that calls update_loc_suggested_capacity
8754: ELSE
8755: l_return :=
8756: inv_trx_util_pub.insert_line_trx
8757: (p_trx_hdr_id => l_txn_header_id,
8758: p_item_id => v_mo_line.inventory_item_id,
8759: p_revision => v_mo_line.revision,
8760: p_org_id => p_organization_id,

Line 8798: mydebug('Error occurred while calling inv_trx_util_pub.insert_line_trx');

8794: IF (l_return <> 0) THEN
8795: ROLLBACK TO create_suggestions_sp;
8796:
8797: IF (l_debug = 1) THEN
8798: mydebug('Error occurred while calling inv_trx_util_pub.insert_line_trx');
8799: END IF;
8800:
8801: RAISE fnd_api.g_exc_unexpected_error;
8802: END IF;

Line 8870: inv_trx_util_pub.insert_lot_trx

8866: mydebug('Insert a record into MTLT for lot: ' || v_mo_line.lot_number);
8867: END IF;
8868:
8869: l_return :=
8870: inv_trx_util_pub.insert_lot_trx
8871: (p_trx_tmp_id => l_txn_temp_id,
8872: p_user_id => p_user_id,
8873: p_lot_number => v_mo_line.lot_number,
8874: p_trx_qty => v_mo_line.quantity,

Line 8890: mydebug('Error occurred while calling inv_trx_util_pub.insert_lot_trx');

8886: l_progress := '100';
8887:
8888: IF (l_return <> 0) THEN
8889: IF (l_debug = 1) THEN
8890: mydebug('Error occurred while calling inv_trx_util_pub.insert_lot_trx');
8891: END IF;
8892:
8893: RAISE fnd_api.g_exc_unexpected_error;
8894: END IF;