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.EAM_MATERIAL_ALLOCATIONS_PVT 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 139: 'Calling inv_trx_util_pub.delete_transaction');

135: --Reduce the allocation quantities in Move order headers, lines and in WRO
136: reduce_move_order(l_move_order_line_id, l_primary_mmtt_qty, 'Y');
137: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
139: 'Calling inv_trx_util_pub.delete_transaction');
140: end if;
141: --Call the inventory delete API.
142: --This API is similar to the wrapper inv_mo_line_detail_util.delete_allocation
143: inv_trx_util_pub.delete_transaction(

Line 143: inv_trx_util_pub.delete_transaction(

139: 'Calling inv_trx_util_pub.delete_transaction');
140: end if;
141: --Call the inventory delete API.
142: --This API is similar to the wrapper inv_mo_line_detail_util.delete_allocation
143: inv_trx_util_pub.delete_transaction(
144: x_return_status => x_return_status
145: , x_msg_data => x_msg_data
146: , x_msg_count => x_msg_count
147: , p_transaction_temp_id => p_transaction_temp_id

Line 151: 'inv_trx_util_pub.delete_transaction',x_return_status,x_msg_count,x_msg_data);

147: , p_transaction_temp_id => p_transaction_temp_id
148: );
149: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
150: eam_common_utilities_pvt.log_api_return(l_module,
151: 'inv_trx_util_pub.delete_transaction',x_return_status,x_msg_count,x_msg_data);
152: end if;
153: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
154: raise fnd_api.g_exc_error;
155: end if;

Line 269: 'Calling inv_trx_util_pub.copy_insert_line_trx');

265: elsif (l_qty_to_reduce > 0) then
266: -- save the remainder allocation by splitting current allocation.
267: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
269: 'Calling inv_trx_util_pub.copy_insert_line_trx');
270: end if;
271: --call the split API passing in current transaction temp id, split qty
272: inv_trx_util_pub.copy_insert_line_trx(
273: x_return_status => x_return_status

Line 272: inv_trx_util_pub.copy_insert_line_trx(

268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
269: 'Calling inv_trx_util_pub.copy_insert_line_trx');
270: end if;
271: --call the split API passing in current transaction temp id, split qty
272: inv_trx_util_pub.copy_insert_line_trx(
273: x_return_status => x_return_status
274: , x_msg_data => x_msg_data
275: , x_msg_count => x_msg_count
276: , x_new_txn_temp_id => x_new_transaction_temp_id

Line 284: 'inv_trx_util_pub.copy_insert_line_trx',x_return_status,x_msg_count,x_msg_data);

280: , p_primary_qty => l_qty_to_reduce
281: );
282: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
283: eam_common_utilities_pvt.log_api_return(l_module,
284: 'inv_trx_util_pub.copy_insert_line_trx',x_return_status,x_msg_count,x_msg_data);
285: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
286: 'inv_trx_util_pub.copy_insert_line_trx returned '
287: || 'x_new_txn_temp_id='|| x_new_transaction_temp_id);
288: end if;

Line 286: 'inv_trx_util_pub.copy_insert_line_trx returned '

282: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
283: eam_common_utilities_pvt.log_api_return(l_module,
284: 'inv_trx_util_pub.copy_insert_line_trx',x_return_status,x_msg_count,x_msg_data);
285: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
286: 'inv_trx_util_pub.copy_insert_line_trx returned '
287: || 'x_new_txn_temp_id='|| x_new_transaction_temp_id);
288: end if;
289: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
290: raise fnd_api.g_exc_error;

Line 434: --Not using inv_trx_util_pub.insert_ser_trx and serial_check.inv_mark_serial

430: ',p_serial='|| p_serial ||')');
431: end if;
432:
433: --API start
434: --Not using inv_trx_util_pub.insert_ser_trx and serial_check.inv_mark_serial
435: --because of bug 2798128
436: INSERT INTO mtl_serial_numbers_temp(transaction_temp_id
437: , fm_serial_number, to_serial_number, serial_prefix
438: , last_update_date, last_updated_by, creation_date, created_by

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

548: if (p_new_transaction_temp_id is not null and (l_reduction_qty >0)) then
549: --split this mtlt row under a new MMTT row with remaining qty
550: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
552: 'Calling inv_trx_util_pub.insert_lot_trx('|| 'p_pri_qty=p_trx_qty='|| l_reduction_qty);
553: end if;
554: l_insert_ret_status := inv_trx_util_pub.insert_lot_trx(
555: p_trx_tmp_id => p_new_transaction_temp_id
556: , p_user_id => fnd_global.user_id

Line 554: l_insert_ret_status := inv_trx_util_pub.insert_lot_trx(

550: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
551: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
552: 'Calling inv_trx_util_pub.insert_lot_trx('|| 'p_pri_qty=p_trx_qty='|| l_reduction_qty);
553: end if;
554: l_insert_ret_status := inv_trx_util_pub.insert_lot_trx(
555: p_trx_tmp_id => p_new_transaction_temp_id
556: , p_user_id => fnd_global.user_id
557: , p_lot_number => p_lot
558: , p_trx_qty => l_reduction_qty

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

560: , x_proc_msg => x_msg_data
561: , x_ser_trx_id => x_ser_trx_id);
562: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then
563: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
564: 'inv_trx_util_pub.insert_lot_trx returned: Status='||
565: l_insert_ret_status|| ' (0 success, -1 failure)'||
566: ', Return Message='|| x_msg_data|| ', Serial Temp Id='||
567: x_ser_trx_id);
568: end if;