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

Line 198: /*Calling API INV_TRX_UTIL_PUB.copy_insert_line_trx to create the child MMTT. This is a new API

194: and ATF determination methods will stamp the transfer_subinventory and
195: transfer_to_location columns later.
196: */
197:
198: /*Calling API INV_TRX_UTIL_PUB.copy_insert_line_trx to create the child MMTT. This is a new API
199: in INVTRUS.pls,hence dependency with version 115. */
200:
201: IF (l_debug=1) THEN
202: print_debug('Calling INV_TRX_UTIL_PUB.copy_insert_line_trx to create child MMTT',l_module_name,9);

Line 202: print_debug('Calling INV_TRX_UTIL_PUB.copy_insert_line_trx to create child MMTT',l_module_name,9);

198: /*Calling API INV_TRX_UTIL_PUB.copy_insert_line_trx to create the child MMTT. This is a new API
199: in INVTRUS.pls,hence dependency with version 115. */
200:
201: IF (l_debug=1) THEN
202: print_debug('Calling INV_TRX_UTIL_PUB.copy_insert_line_trx to create child MMTT',l_module_name,9);
203: END IF;
204:
205: l_progress:=50;
206: /*IF p_operation_type_id='INSPECT' then

Line 238: INV_TRX_UTIL_PUB.copy_insert_line_trx

234: IF (l_debug=1) THEN
235: print_debug('Stamp subsequent OP plan ID '||p_subsequent_op_plan_id||' to child task. ',l_module_name,9);
236: END IF;
237:
238: INV_TRX_UTIL_PUB.copy_insert_line_trx
239: (
240: x_return_status => l_return_status
241: ,x_msg_data => l_msg_data
242: ,x_msg_count => l_msg_count

Line 255: INV_TRX_UTIL_PUB.copy_insert_line_trx

251: );
252:
253: ELSE
254:
255: INV_TRX_UTIL_PUB.copy_insert_line_trx
256: (
257: x_return_status => l_return_status
258: ,x_msg_data => l_msg_data
259: ,x_msg_count => l_msg_count

Line 327: /*and Call INV_TRX_UTIL_PUB.INSERT_LOT_TRX passing the appropriate parameters

323: END IF;
324:
325: l_progress:=90;
326:
327: /*and Call INV_TRX_UTIL_PUB.INSERT_LOT_TRX passing the appropriate parameters
328: from the record variable to insert MTLT record.*/
329:
330: IF (l_debug=1) THEN
331: print_debug('Calling Insert_lot_trx to insert child MTLT records',l_module_name,9);

Line 336: l_insert_lot:=INV_TRX_UTIL_PUB.INSERT_LOT_TRX

332: END IF;
333:
334: IF (l_item_details_rec.lot_control_code=2) THEN
335:
336: l_insert_lot:=INV_TRX_UTIL_PUB.INSERT_LOT_TRX
337: (p_trx_tmp_id => x_source_task_id,
338: p_user_id => FND_GLOBAL.USER_ID ,
339: p_lot_number => l_mtlt_rec.lot_number ,
340: p_trx_qty => l_mtlt_rec.transaction_quantity,

Line 1174: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);

1170:
1171: IF p_document_rec.parent_line_id IS NOT NULL THEN
1172: IF (l_debug=1) THEN
1173: print_debug('p_document_rec.parent_line_id is not null, therefore need to delete parent MMTT record',l_module_name,4);
1174: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);
1175:
1176: print_debug('p_transaction_temp_id => '||p_document_rec.parent_line_id,l_module_name,4);
1177: END IF;
1178:

Line 1181: inv_trx_util_pub.delete_transaction

1177: END IF;
1178:
1179: l_progress := 30;
1180:
1181: inv_trx_util_pub.delete_transaction
1182: (x_return_status => l_return_status
1183: , x_msg_data => l_msg_data
1184: , x_msg_count => l_msg_count
1185: , p_transaction_temp_id => p_document_rec.parent_line_id

Line 1192: print_debug('After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);

1188:
1189: l_progress := 40;
1190:
1191: IF (l_debug=1) THEN
1192: print_debug('After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);
1193:
1194: print_debug('l_return_status => '||l_return_status,l_module_name,4);
1195: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1196: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

Line 1201: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);

1197: END IF;
1198:
1199: IF l_return_status <>FND_API.g_ret_sts_success THEN
1200: IF (l_debug=1) THEN
1201: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1202: END IF;
1203:
1204: RAISE FND_API.G_EXC_ERROR;
1205: END IF;

Line 1502: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);

1498:
1499:
1500: IF (l_debug=1) THEN
1501:
1502: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);
1503:
1504: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1505: END IF;
1506:

Line 1507: inv_trx_util_pub.delete_transaction

1503:
1504: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1505: END IF;
1506:
1507: inv_trx_util_pub.delete_transaction
1508: (x_return_status => l_return_status
1509: , x_msg_data => l_msg_data
1510: , x_msg_count => l_msg_count
1511: , p_transaction_temp_id => p_source_task_id

Line 1516: print_debug('Drop - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);

1512: , p_update_parent => FALSE
1513: );
1514:
1515: IF (l_debug=1) THEN
1516: print_debug('Drop - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);
1517:
1518: print_debug('l_return_status => '||l_return_status,l_module_name,4);
1519: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1520: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

Line 1525: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);

1521: END IF;
1522:
1523: IF l_return_status <>FND_API.g_ret_sts_success THEN
1524: IF (l_debug=1) THEN
1525: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1526: END IF;
1527:
1528: RAISE FND_API.G_EXC_ERROR;
1529: END IF;

Line 1732: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);

1728:
1729:
1730: IF (l_debug=1) THEN
1731:
1732: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);
1733:
1734: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1735: END IF;
1736:

Line 1737: inv_trx_util_pub.delete_transaction

1733:
1734: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1735: END IF;
1736:
1737: inv_trx_util_pub.delete_transaction
1738: (x_return_status => l_return_status
1739: , x_msg_data => l_msg_data
1740: , x_msg_count => l_msg_count
1741: , p_transaction_temp_id => p_source_task_id

Line 1748: print_debug('Inspect - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);

1744:
1745: l_progress := 242;
1746:
1747: IF (l_debug=1) THEN
1748: print_debug('Inspect - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);
1749:
1750: print_debug('l_return_status => '||l_return_status,l_module_name,4);
1751: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1752: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

Line 1757: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);

1753: END IF;
1754:
1755: IF l_return_status <>FND_API.g_ret_sts_success THEN
1756: IF (l_debug=1) THEN
1757: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1758: END IF;
1759:
1760: RAISE FND_API.G_EXC_ERROR;
1761: END IF;

Line 1903: print_debug('Before calling inv_trx_util_pub.copy_insert_line_trx with following parameters: ',l_module_name,4);

1899: END IF; -- IF p_next_operation_type_id = g_op_type_inspect
1900:
1901: IF (l_debug=1) THEN
1902:
1903: print_debug('Before calling inv_trx_util_pub.copy_insert_line_trx with following parameters: ',l_module_name,4);
1904:
1905: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1906: print_debug('p_subinventory_code => '||l_new_subinventory_code,l_module_name,4);
1907: print_debug('p_locator_id => '||l_new_locator_id,l_module_name,4);

Line 1934: INV_TRX_UTIL_PUB.copy_insert_line_trx

1930: IF (p_next_operation_type_id = g_op_type_crossdock AND
1931: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10
1932: THEN
1933:
1934: INV_TRX_UTIL_PUB.copy_insert_line_trx
1935: (
1936: x_return_status => l_return_status
1937: ,x_msg_data => l_msg_data
1938: ,x_msg_count => l_msg_count

Line 1961: INV_TRX_UTIL_PUB.copy_insert_line_trx

1957: print_debug('Stamp subsequent OP plan ID '||p_subsequent_op_plan_id||' to child task. ',l_module_name,9);
1958: END IF;
1959:
1960: ELSE
1961: INV_TRX_UTIL_PUB.copy_insert_line_trx
1962: (
1963: x_return_status => l_return_status
1964: ,x_msg_data => l_msg_data
1965: ,x_msg_count => l_msg_count

Line 1986: print_debug('After calling inv_trx_util_pub.copy_insert_line_trx: ',l_module_name,4);

1982:
1983: l_progress := 270;
1984:
1985: IF (l_debug=1) THEN
1986: print_debug('After calling inv_trx_util_pub.copy_insert_line_trx: ',l_module_name,4);
1987:
1988: print_debug('l_return_status => '||l_return_status,l_module_name,4);
1989: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1990: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

Line 2003: print_debug('Error occured while calling inv_trx_util_pub.copy_insert_line_trx',l_module_name,4);

1999: END IF;
2000: /* End 12541422 */
2001: IF l_return_status <>fnd_api.g_ret_sts_success THEN
2002: IF (l_debug=1) THEN
2003: print_debug('Error occured while calling inv_trx_util_pub.copy_insert_line_trx',l_module_name,4);
2004: END IF;
2005: RAISE FND_API.G_EXC_ERROR;
2006: END IF;
2007:

Line 2088: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);

2084: END IF;
2085:
2086: IF (l_debug=1) THEN
2087:
2088: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);
2089:
2090: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
2091: END IF;
2092:

Line 2093: inv_trx_util_pub.delete_transaction

2089:
2090: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
2091: END IF;
2092:
2093: inv_trx_util_pub.delete_transaction
2094: (x_return_status => l_return_status
2095: , x_msg_data => l_msg_data
2096: , x_msg_count => l_msg_count
2097: , p_transaction_temp_id => p_source_task_id

Line 2102: print_debug('Not last operation - Drop - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);

2098: , p_update_parent => FALSE
2099: );
2100:
2101: IF (l_debug=1) THEN
2102: print_debug('Not last operation - Drop - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);
2103:
2104: print_debug('l_return_status => '||l_return_status,l_module_name,4);
2105: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
2106: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

Line 2111: print_debug('Not last operation - Drop - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);

2107: END IF;
2108:
2109: IF l_return_status <>FND_API.g_ret_sts_success THEN
2110: IF (l_debug=1) THEN
2111: print_debug('Not last operation - Drop - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2112: END IF;
2113:
2114: RAISE FND_API.G_EXC_ERROR;
2115: END IF;

Line 2685: print_debug('Delete parent - Before calling INV_TRX_UTIL_PUB.Delete_transaction with following parameters: ' ,l_module_name,4);

2681: print_debug('l_mmtt_data_rec.primary_quantity = '|| l_mmtt_data_rec.primary_quantity,l_module_name,4);
2682: print_debug('l_mmtt_data_rec.secondary_transaction_quantity = '|| l_mmtt_data_rec.secondary_transaction_quantity,l_module_name,4);
2683: print_debug('l_mmtt_data_rec.transaction_quantity = '|| l_mmtt_data_rec.transaction_quantity,l_module_name,4);
2684:
2685: print_debug('Delete parent - Before calling INV_TRX_UTIL_PUB.Delete_transaction with following parameters: ' ,l_module_name,4);
2686: print_debug('p_transaction_temp_id => '|| l_mmtt_data_rec.parent_line_id,l_module_name,4);
2687: print_debug('p_update_parent => '|| 'FALSE',l_module_name,4);
2688:
2689: END IF;

Line 2695: INV_TRX_UTIL_PUB.Delete_transaction

2691: l_progress := 40;
2692:
2693: -- delete parent mmtt record
2694:
2695: INV_TRX_UTIL_PUB.Delete_transaction
2696: (x_return_status => l_return_status,
2697: x_msg_data => l_msg_data,
2698: x_msg_count => l_msg_count,
2699: p_transaction_temp_id => l_mmtt_data_rec.parent_line_id,

Line 2705: print_debug('Delete parent - After calling INV_TRX_UTIL_PUB.Delete_transaction.' ,l_module_name,4);

2701:
2702: l_progress := 50;
2703:
2704: IF (l_debug=1) THEN
2705: print_debug('Delete parent - After calling INV_TRX_UTIL_PUB.Delete_transaction.' ,l_module_name,4);
2706: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
2707: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2708: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2709: END IF;

Line 2713: print_debug('Delete parent - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);

2709: END IF;
2710:
2711: IF l_return_status <>FND_API.g_ret_sts_success THEN
2712: IF (l_debug=1) THEN
2713: print_debug('Delete parent - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2714: END IF;
2715:
2716: RAISE FND_API.G_EXC_ERROR;
2717: END IF;

Line 2888: print_debug('Delete child - Before calling INV_TRX_UTIL_PUB.Delete_transaction with following parameters: ' ,l_module_name,4);

2884: RAISE fnd_api.g_exc_error;
2885: END IF;
2886: ELSE
2887: IF (l_debug=1) THEN
2888: print_debug('Delete child - Before calling INV_TRX_UTIL_PUB.Delete_transaction with following parameters: ' ,l_module_name,4);
2889: print_debug('p_transaction_temp_id => '|| p_source_task_id,l_module_name,4);
2890: print_debug('p_update_parent => '|| 'FALSE',l_module_name,4);
2891:
2892: END IF;

Line 2898: INV_TRX_UTIL_PUB.Delete_transaction

2894: l_progress := 120;
2895:
2896: -- delete current mmtt record
2897:
2898: INV_TRX_UTIL_PUB.Delete_transaction
2899: (x_return_status => l_return_status,
2900: x_msg_data => l_msg_data,
2901: x_msg_count => l_msg_count,
2902: p_transaction_temp_id => p_source_task_id,

Line 2908: print_debug('Delete child - After calling INV_TRX_UTIL_PUB.Delete_transaction.' ,l_module_name,4);

2904:
2905: l_progress := 130;
2906:
2907: IF (l_debug=1) THEN
2908: print_debug('Delete child - After calling INV_TRX_UTIL_PUB.Delete_transaction.' ,l_module_name,4);
2909: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
2910: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2911: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2912: END IF;

Line 2916: print_debug('Delete child - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);

2912: END IF;
2913:
2914: IF l_return_status <>FND_API.g_ret_sts_success THEN
2915: IF (l_debug=1) THEN
2916: print_debug('Delete child - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2917: END IF;
2918:
2919: RAISE FND_API.G_EXC_ERROR;
2920: END IF;

Line 3118: INV_TRX_UTIL_PUB.Delete_transaction

3114:
3115: l_progress:=20;
3116: /* null out the Operation Plan Id ,parent Line Id and delete the Parent transaction temp Id*/
3117: /*Call table hanlder to delete MMTT/MSNT/MTLT for the Parent MMTT*/
3118: INV_TRX_UTIL_PUB.Delete_transaction
3119: (x_return_status => x_return_status,
3120: x_msg_data => x_msg_data,
3121: x_msg_count => x_msg_count,
3122: p_transaction_temp_id => p_document_rec.parent_line_id,