DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on INV_TRX_UTIL_PUB

Line 8380: inv_trx_util_pub.insert_line_trx

8376:
8377: IF l_lpn_context = 3 OR l_lpn_context = 2 THEN --added context =2 bug 4189437
8378:
8379: l_return :=
8380: inv_trx_util_pub.insert_line_trx
8381: (p_trx_hdr_id => l_txn_header_id,
8382: p_item_id => v_mo_line.inventory_item_id,
8383: p_revision => v_mo_line.revision,
8384: p_org_id => p_organization_id,

Line 8406: inv_trx_util_pub.insert_line_trx

8402: --BUG 3356366: Insert MMTT with txn_status 2 so that it won't
8403: --invoke the DB trigger that calls update_loc_suggested_capacity
8404: ELSE
8405: l_return :=
8406: inv_trx_util_pub.insert_line_trx
8407: (p_trx_hdr_id => l_txn_header_id,
8408: p_item_id => v_mo_line.inventory_item_id,
8409: p_revision => v_mo_line.revision,
8410: p_org_id => p_organization_id,

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

8440: IF (l_return <> 0) THEN
8441: ROLLBACK TO create_suggestions_sp;
8442:
8443: IF (l_debug = 1) THEN
8444: mydebug('Error occurred while calling inv_trx_util_pub.insert_line_trx');
8445: END IF;
8446:
8447: RAISE fnd_api.g_exc_unexpected_error;
8448: END IF;

Line 8516: inv_trx_util_pub.insert_lot_trx

8512: mydebug('Insert a record into MTLT for lot: ' || v_mo_line.lot_number);
8513: END IF;
8514:
8515: l_return :=
8516: inv_trx_util_pub.insert_lot_trx
8517: (p_trx_tmp_id => l_txn_temp_id,
8518: p_user_id => p_user_id,
8519: p_lot_number => v_mo_line.lot_number,
8520: p_trx_qty => v_mo_line.quantity,

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

8529: l_progress := '100';
8530:
8531: IF (l_return <> 0) THEN
8532: IF (l_debug = 1) THEN
8533: mydebug('Error occurred while calling inv_trx_util_pub.insert_lot_trx');
8534: END IF;
8535:
8536: RAISE fnd_api.g_exc_unexpected_error;
8537: END IF;