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_MATERIAL_ALLOCATIONS_GRP dependencies on INV_TRX_UTIL_PUB

Line 9: remove_serial, update_lot, inv_trx_util_pub.insert_lot_trx. If proper care is

5: This package manages material allocations in MMTT, MTLT, MSNT along with related
6: interactions with move orders and WIP material requirements. Some of the APIS here
7: are not meant to be called in isolation. For example, reduce_allocation_header
8: is called in conjunction with subsequent calls to APIs as add_serial,
9: remove_serial, update_lot, inv_trx_util_pub.insert_lot_trx. If proper care is
10: not exercised in calling them in conjunction, the state of allocations
11: can become invalid.
12: */
13:

Line 162: 'Calling inv_trx_util_pub.delete_transaction');

158: --Reduce the allocation quantities in Move order headers, lines and in WRO
159: reduce_move_order(l_move_order_line_id, l_primary_mmtt_qty, 'Y');
160: if (l_slog) then
161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
162: 'Calling inv_trx_util_pub.delete_transaction');
163: end if;
164: --Call the inventory delete API.
165: --This API is similar to the wrapper inv_mo_line_detail_util.delete_allocation
166: inv_trx_util_pub.delete_transaction(

Line 166: inv_trx_util_pub.delete_transaction(

162: 'Calling inv_trx_util_pub.delete_transaction');
163: end if;
164: --Call the inventory delete API.
165: --This API is similar to the wrapper inv_mo_line_detail_util.delete_allocation
166: inv_trx_util_pub.delete_transaction(
167: x_return_status => x_return_status
168: , x_msg_data => x_msg_data
169: , x_msg_count => x_msg_count
170: , p_transaction_temp_id => p_transaction_temp_id

Line 174: 'inv_trx_util_pub.delete_transaction returns. Return status='

170: , p_transaction_temp_id => p_transaction_temp_id
171: );
172: if (l_slog) then
173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
174: 'inv_trx_util_pub.delete_transaction returns. Return status='
175: || x_return_status|| ', Message Count = '|| x_msg_count
176: || ', Message data=' || REPLACE(x_msg_data, CHR(0), ' '));
177: end if;
178: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 311: 'Calling inv_trx_util_pub.copy_insert_line_trx');

307: elsif (l_qty_to_reduce > 0) then
308: -- save the remainder allocation by splitting current allocation.
309: if (l_slog) then
310: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
311: 'Calling inv_trx_util_pub.copy_insert_line_trx');
312: end if;
313: --call the split API passing in current transaction temp id, split qty
314: inv_trx_util_pub.copy_insert_line_trx(
315: x_return_status => x_return_status

Line 314: inv_trx_util_pub.copy_insert_line_trx(

310: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
311: 'Calling inv_trx_util_pub.copy_insert_line_trx');
312: end if;
313: --call the split API passing in current transaction temp id, split qty
314: inv_trx_util_pub.copy_insert_line_trx(
315: x_return_status => x_return_status
316: , x_msg_data => x_msg_data
317: , x_msg_count => x_msg_count
318: , x_new_txn_temp_id => x_new_transaction_temp_id

Line 326: 'inv_trx_util_pub.copy_insert_line_trx returns. Return status='

322: , p_primary_qty => l_qty_to_reduce
323: );
324: if (l_slog) then
325: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
326: 'inv_trx_util_pub.copy_insert_line_trx returns. Return status='
327: || x_return_status|| ', Message Count = '|| x_msg_count
328: || 'x_new_txn_temp_id='|| x_new_transaction_temp_id
329: || ', Message data=' || REPLACE(x_msg_data, CHR(0), ' '));
330: end if;

Line 481: l_insert_err_code := inv_trx_util_pub.insert_ser_trx(

477: ',p_serial='|| p_serial ||')');
478: end if;
479:
480: --API start
481: l_insert_err_code := inv_trx_util_pub.insert_ser_trx(
482: p_trx_tmp_id => p_transaction_temp_id,
483: p_user_id => FND_GLOBAL.USER_ID,
484: p_fm_ser_num => p_serial,
485: p_to_ser_num => p_serial,

Line 605: 'Calling inv_trx_util_pub.insert_lot_trx('|| 'p_pri_qty=p_trx_qty='|| l_reduction_qty);

601: if (p_new_transaction_temp_id is not null and (l_reduction_qty >0)) then
602: --split this mtlt row under a new MMTT row with remaining qty
603: if (l_slog) then
604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
605: 'Calling inv_trx_util_pub.insert_lot_trx('|| 'p_pri_qty=p_trx_qty='|| l_reduction_qty);
606: end if;
607: l_insert_ret_status := inv_trx_util_pub.insert_lot_trx(
608: p_trx_tmp_id => p_new_transaction_temp_id
609: , p_user_id => fnd_global.user_id

Line 607: l_insert_ret_status := inv_trx_util_pub.insert_lot_trx(

603: if (l_slog) then
604: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
605: 'Calling inv_trx_util_pub.insert_lot_trx('|| 'p_pri_qty=p_trx_qty='|| l_reduction_qty);
606: end if;
607: l_insert_ret_status := inv_trx_util_pub.insert_lot_trx(
608: p_trx_tmp_id => p_new_transaction_temp_id
609: , p_user_id => fnd_global.user_id
610: , p_lot_number => p_lot
611: , p_trx_qty => l_reduction_qty

Line 617: 'inv_trx_util_pub.insert_lot_trx returned: Status='||

613: , x_proc_msg => x_msg_data
614: , x_ser_trx_id => x_ser_trx_id);
615: if (l_slog) then
616: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
617: 'inv_trx_util_pub.insert_lot_trx returned: Status='||
618: l_insert_ret_status|| ' (0 success, -1 failure)'||
619: ', Return Message='|| x_msg_data|| ', Serial Temp Id='||
620: x_ser_trx_id);
621: end if;