DBA Data[Home] [Help]

APPS.WMS_OP_INBOUND_PVT dependencies on INV_TRX_UTIL_PUB

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

186: and ATF determination methods will stamp the transfer_subinventory and
187: transfer_to_location columns later.
188: */
189:
190: /*Calling API INV_TRX_UTIL_PUB.copy_insert_line_trx to create the child MMTT. This is a new API
191: in INVTRUS.pls,hence dependency with version 115. */
192:
193: IF (l_debug=1) THEN
194: print_debug('Calling INV_TRX_UTIL_PUB.copy_insert_line_trx to create child MMTT',l_module_name,9);

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

190: /*Calling API INV_TRX_UTIL_PUB.copy_insert_line_trx to create the child MMTT. This is a new API
191: in INVTRUS.pls,hence dependency with version 115. */
192:
193: IF (l_debug=1) THEN
194: print_debug('Calling INV_TRX_UTIL_PUB.copy_insert_line_trx to create child MMTT',l_module_name,9);
195: END IF;
196:
197: l_progress:=50;
198: /*IF p_operation_type_id='INSPECT' then

Line 230: INV_TRX_UTIL_PUB.copy_insert_line_trx

226: IF (l_debug=1) THEN
227: print_debug('Stamp subsequent OP plan ID '||p_subsequent_op_plan_id||' to child task. ',l_module_name,9);
228: END IF;
229:
230: INV_TRX_UTIL_PUB.copy_insert_line_trx
231: (
232: x_return_status => l_return_status
233: ,x_msg_data => l_msg_data
234: ,x_msg_count => l_msg_count

Line 247: INV_TRX_UTIL_PUB.copy_insert_line_trx

243: );
244:
245: ELSE
246:
247: INV_TRX_UTIL_PUB.copy_insert_line_trx
248: (
249: x_return_status => l_return_status
250: ,x_msg_data => l_msg_data
251: ,x_msg_count => l_msg_count

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

315: END IF;
316:
317: l_progress:=90;
318:
319: /*and Call INV_TRX_UTIL_PUB.INSERT_LOT_TRX passing the appropriate parameters
320: from the record variable to insert MTLT record.*/
321:
322: IF (l_debug=1) THEN
323: print_debug('Calling Insert_lot_trx to insert child MTLT records',l_module_name,9);

Line 328: l_insert_lot:=INV_TRX_UTIL_PUB.INSERT_LOT_TRX

324: END IF;
325:
326: IF (l_item_details_rec.lot_control_code=2) THEN
327:
328: l_insert_lot:=INV_TRX_UTIL_PUB.INSERT_LOT_TRX
329: (p_trx_tmp_id => x_source_task_id,
330: p_user_id => FND_GLOBAL.USER_ID ,
331: p_lot_number => l_mtlt_rec.lot_number ,
332: p_trx_qty => l_mtlt_rec.transaction_quantity,

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

1131:
1132: IF p_document_rec.parent_line_id IS NOT NULL THEN
1133: IF (l_debug=1) THEN
1134: print_debug('p_document_rec.parent_line_id is not null, therefore need to delete parent MMTT record',l_module_name,4);
1135: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);
1136:
1137: print_debug('p_transaction_temp_id => '||p_document_rec.parent_line_id,l_module_name,4);
1138: END IF;
1139:

Line 1142: inv_trx_util_pub.delete_transaction

1138: END IF;
1139:
1140: l_progress := 30;
1141:
1142: inv_trx_util_pub.delete_transaction
1143: (x_return_status => l_return_status
1144: , x_msg_data => l_msg_data
1145: , x_msg_count => l_msg_count
1146: , p_transaction_temp_id => p_document_rec.parent_line_id

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

1149:
1150: l_progress := 40;
1151:
1152: IF (l_debug=1) THEN
1153: print_debug('After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);
1154:
1155: print_debug('l_return_status => '||l_return_status,l_module_name,4);
1156: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1157: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

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

1158: END IF;
1159:
1160: IF l_return_status <>FND_API.g_ret_sts_success THEN
1161: IF (l_debug=1) THEN
1162: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1163: END IF;
1164:
1165: RAISE FND_API.G_EXC_ERROR;
1166: END IF;

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

1459:
1460:
1461: IF (l_debug=1) THEN
1462:
1463: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);
1464:
1465: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1466: END IF;
1467:

Line 1468: inv_trx_util_pub.delete_transaction

1464:
1465: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1466: END IF;
1467:
1468: inv_trx_util_pub.delete_transaction
1469: (x_return_status => l_return_status
1470: , x_msg_data => l_msg_data
1471: , x_msg_count => l_msg_count
1472: , p_transaction_temp_id => p_source_task_id

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

1473: , p_update_parent => FALSE
1474: );
1475:
1476: IF (l_debug=1) THEN
1477: print_debug('Drop - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);
1478:
1479: print_debug('l_return_status => '||l_return_status,l_module_name,4);
1480: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1481: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

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

1482: END IF;
1483:
1484: IF l_return_status <>FND_API.g_ret_sts_success THEN
1485: IF (l_debug=1) THEN
1486: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1487: END IF;
1488:
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;

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

1684:
1685:
1686: IF (l_debug=1) THEN
1687:
1688: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);
1689:
1690: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1691: END IF;
1692:

Line 1693: inv_trx_util_pub.delete_transaction

1689:
1690: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1691: END IF;
1692:
1693: inv_trx_util_pub.delete_transaction
1694: (x_return_status => l_return_status
1695: , x_msg_data => l_msg_data
1696: , x_msg_count => l_msg_count
1697: , p_transaction_temp_id => p_source_task_id

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

1700:
1701: l_progress := 242;
1702:
1703: IF (l_debug=1) THEN
1704: print_debug('Inspect - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);
1705:
1706: print_debug('l_return_status => '||l_return_status,l_module_name,4);
1707: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1708: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

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

1709: END IF;
1710:
1711: IF l_return_status <>FND_API.g_ret_sts_success THEN
1712: IF (l_debug=1) THEN
1713: print_debug('inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
1714: END IF;
1715:
1716: RAISE FND_API.G_EXC_ERROR;
1717: END IF;

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

1855: END IF; -- IF p_next_operation_type_id = g_op_type_inspect
1856:
1857: IF (l_debug=1) THEN
1858:
1859: print_debug('Before calling inv_trx_util_pub.copy_insert_line_trx with following parameters: ',l_module_name,4);
1860:
1861: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
1862: print_debug('p_subinventory_code => '||l_new_subinventory_code,l_module_name,4);
1863: print_debug('p_locator_id => '||l_new_locator_id,l_module_name,4);

Line 1890: INV_TRX_UTIL_PUB.copy_insert_line_trx

1886: IF (p_next_operation_type_id = g_op_type_crossdock AND
1887: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10
1888: THEN
1889:
1890: INV_TRX_UTIL_PUB.copy_insert_line_trx
1891: (
1892: x_return_status => l_return_status
1893: ,x_msg_data => l_msg_data
1894: ,x_msg_count => l_msg_count

Line 1917: INV_TRX_UTIL_PUB.copy_insert_line_trx

1913: print_debug('Stamp subsequent OP plan ID '||p_subsequent_op_plan_id||' to child task. ',l_module_name,9);
1914: END IF;
1915:
1916: ELSE
1917: INV_TRX_UTIL_PUB.copy_insert_line_trx
1918: (
1919: x_return_status => l_return_status
1920: ,x_msg_data => l_msg_data
1921: ,x_msg_count => l_msg_count

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

1938:
1939: l_progress := 270;
1940:
1941: IF (l_debug=1) THEN
1942: print_debug('After calling inv_trx_util_pub.copy_insert_line_trx: ',l_module_name,4);
1943:
1944: print_debug('l_return_status => '||l_return_status,l_module_name,4);
1945: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
1946: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

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

1949: END IF;
1950:
1951: IF l_return_status <>fnd_api.g_ret_sts_success THEN
1952: IF (l_debug=1) THEN
1953: print_debug('Error occured while calling inv_trx_util_pub.copy_insert_line_trx',l_module_name,4);
1954: END IF;
1955: RAISE FND_API.G_EXC_ERROR;
1956: END IF;
1957:

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

2034: END IF;
2035:
2036: IF (l_debug=1) THEN
2037:
2038: print_debug('Before calling inv_trx_util_pub.delete_transaction with following parameters: ',l_module_name,4);
2039:
2040: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
2041: END IF;
2042:

Line 2043: inv_trx_util_pub.delete_transaction

2039:
2040: print_debug('p_transaction_temp_id => '||p_source_task_id,l_module_name,4);
2041: END IF;
2042:
2043: inv_trx_util_pub.delete_transaction
2044: (x_return_status => l_return_status
2045: , x_msg_data => l_msg_data
2046: , x_msg_count => l_msg_count
2047: , p_transaction_temp_id => p_source_task_id

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

2048: , p_update_parent => FALSE
2049: );
2050:
2051: IF (l_debug=1) THEN
2052: print_debug('Not last operation - Drop - After calling inv_trx_util_pub.delete_transaction.',l_module_name,4);
2053:
2054: print_debug('l_return_status => '||l_return_status,l_module_name,4);
2055: print_debug('l_msg_data => '||l_msg_data,l_module_name,4);
2056: print_debug('l_msg_count => '||l_msg_count,l_module_name,4);

Line 2061: 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);

2057: END IF;
2058:
2059: IF l_return_status <>FND_API.g_ret_sts_success THEN
2060: IF (l_debug=1) THEN
2061: 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);
2062: END IF;
2063:
2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;

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

2608: print_debug('l_mmtt_data_rec.parent_line_id = '|| l_mmtt_data_rec.parent_line_id,l_module_name,4);
2609: print_debug('l_mmtt_data_rec.backorder_delivery_detail_id = '|| l_mmtt_data_rec.backorder_delivery_detail_id,l_module_name,4);
2610:
2611:
2612: print_debug('Delete parent - Before calling INV_TRX_UTIL_PUB.Delete_transaction with following parameters: ' ,l_module_name,4);
2613: print_debug('p_transaction_temp_id => '|| l_mmtt_data_rec.parent_line_id,l_module_name,4);
2614: print_debug('p_update_parent => '|| 'FALSE',l_module_name,4);
2615:
2616: END IF;

Line 2622: INV_TRX_UTIL_PUB.Delete_transaction

2618: l_progress := 40;
2619:
2620: -- delete parent mmtt record
2621:
2622: INV_TRX_UTIL_PUB.Delete_transaction
2623: (x_return_status => l_return_status,
2624: x_msg_data => l_msg_data,
2625: x_msg_count => l_msg_count,
2626: p_transaction_temp_id => l_mmtt_data_rec.parent_line_id,

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

2628:
2629: l_progress := 50;
2630:
2631: IF (l_debug=1) THEN
2632: print_debug('Delete parent - After calling INV_TRX_UTIL_PUB.Delete_transaction.' ,l_module_name,4);
2633: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
2634: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2635: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2636: END IF;

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

2636: END IF;
2637:
2638: IF l_return_status <>FND_API.g_ret_sts_success THEN
2639: IF (l_debug=1) THEN
2640: print_debug('Delete parent - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2641: END IF;
2642:
2643: RAISE FND_API.G_EXC_ERROR;
2644: END IF;

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

2808: RAISE fnd_api.g_exc_error;
2809: END IF;
2810: ELSE
2811: IF (l_debug=1) THEN
2812: print_debug('Delete child - Before calling INV_TRX_UTIL_PUB.Delete_transaction with following parameters: ' ,l_module_name,4);
2813: print_debug('p_transaction_temp_id => '|| p_source_task_id,l_module_name,4);
2814: print_debug('p_update_parent => '|| 'FALSE',l_module_name,4);
2815:
2816: END IF;

Line 2822: INV_TRX_UTIL_PUB.Delete_transaction

2818: l_progress := 120;
2819:
2820: -- delete current mmtt record
2821:
2822: INV_TRX_UTIL_PUB.Delete_transaction
2823: (x_return_status => l_return_status,
2824: x_msg_data => l_msg_data,
2825: x_msg_count => l_msg_count,
2826: p_transaction_temp_id => p_source_task_id,

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

2828:
2829: l_progress := 130;
2830:
2831: IF (l_debug=1) THEN
2832: print_debug('Delete child - After calling INV_TRX_UTIL_PUB.Delete_transaction.' ,l_module_name,4);
2833: print_debug('x_return_status => '|| l_return_status,l_module_name,4);
2834: print_debug('x_msg_data => '|| l_msg_data,l_module_name,4);
2835: print_debug('x_msg_count => '|| l_msg_count,l_module_name,4);
2836: END IF;

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

2836: END IF;
2837:
2838: IF l_return_status <>FND_API.g_ret_sts_success THEN
2839: IF (l_debug=1) THEN
2840: print_debug('Delete child - inv_trx_util_pub.delete_transaction finished with error. l_return_status = ' || l_return_status,l_module_name,4);
2841: END IF;
2842:
2843: RAISE FND_API.G_EXC_ERROR;
2844: END IF;

Line 3042: INV_TRX_UTIL_PUB.Delete_transaction

3038:
3039: l_progress:=20;
3040: /* null out the Operation Plan Id ,parent Line Id and delete the Parent transaction temp Id*/
3041: /*Call table hanlder to delete MMTT/MSNT/MTLT for the Parent MMTT*/
3042: INV_TRX_UTIL_PUB.Delete_transaction
3043: (x_return_status => x_return_status,
3044: x_msg_data => x_msg_data,
3045: x_msg_count => x_msg_count,
3046: p_transaction_temp_id => p_document_rec.parent_line_id,