[Home] [Help]
256:
257: tab_index := ind;
258:
259: IF (l_debug = 1) THEN
260: INV_TRX_UTIL_PUB.trace('out :' || p_total_qty || ':' ,g_pkg_name,9);
261: INV_TRX_UTIL_PUB.trace('Ttype :' ||p_transaction_type_id || ':' ,g_pkg_name,9);
262: INV_TRX_UTIL_PUB.trace('Tlot :' ||p_transaction_lot || ':' ,g_pkg_name,9);
263: INV_TRX_UTIL_PUB.trace('Item :' ||p_inventory_item_id || ':' ,g_pkg_name,9);
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
257: tab_index := ind;
258:
259: IF (l_debug = 1) THEN
260: INV_TRX_UTIL_PUB.trace('out :' || p_total_qty || ':' ,g_pkg_name,9);
261: INV_TRX_UTIL_PUB.trace('Ttype :' ||p_transaction_type_id || ':' ,g_pkg_name,9);
262: INV_TRX_UTIL_PUB.trace('Tlot :' ||p_transaction_lot || ':' ,g_pkg_name,9);
263: INV_TRX_UTIL_PUB.trace('Item :' ||p_inventory_item_id || ':' ,g_pkg_name,9);
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
265: INV_TRX_UTIL_PUB.trace('Sub :' ||p_subinventory_code || ':' ,g_pkg_name,9);
258:
259: IF (l_debug = 1) THEN
260: INV_TRX_UTIL_PUB.trace('out :' || p_total_qty || ':' ,g_pkg_name,9);
261: INV_TRX_UTIL_PUB.trace('Ttype :' ||p_transaction_type_id || ':' ,g_pkg_name,9);
262: INV_TRX_UTIL_PUB.trace('Tlot :' ||p_transaction_lot || ':' ,g_pkg_name,9);
263: INV_TRX_UTIL_PUB.trace('Item :' ||p_inventory_item_id || ':' ,g_pkg_name,9);
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
265: INV_TRX_UTIL_PUB.trace('Sub :' ||p_subinventory_code || ':' ,g_pkg_name,9);
266: INV_TRX_UTIL_PUB.trace('Loc :' ||p_locator_id || ':' ,g_pkg_name,9);
259: IF (l_debug = 1) THEN
260: INV_TRX_UTIL_PUB.trace('out :' || p_total_qty || ':' ,g_pkg_name,9);
261: INV_TRX_UTIL_PUB.trace('Ttype :' ||p_transaction_type_id || ':' ,g_pkg_name,9);
262: INV_TRX_UTIL_PUB.trace('Tlot :' ||p_transaction_lot || ':' ,g_pkg_name,9);
263: INV_TRX_UTIL_PUB.trace('Item :' ||p_inventory_item_id || ':' ,g_pkg_name,9);
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
265: INV_TRX_UTIL_PUB.trace('Sub :' ||p_subinventory_code || ':' ,g_pkg_name,9);
266: INV_TRX_UTIL_PUB.trace('Loc :' ||p_locator_id || ':' ,g_pkg_name,9);
267: INV_TRX_UTIL_PUB.trace('TQty :' ||p_transaction_quantity || ':' ,g_pkg_name,9);
260: INV_TRX_UTIL_PUB.trace('out :' || p_total_qty || ':' ,g_pkg_name,9);
261: INV_TRX_UTIL_PUB.trace('Ttype :' ||p_transaction_type_id || ':' ,g_pkg_name,9);
262: INV_TRX_UTIL_PUB.trace('Tlot :' ||p_transaction_lot || ':' ,g_pkg_name,9);
263: INV_TRX_UTIL_PUB.trace('Item :' ||p_inventory_item_id || ':' ,g_pkg_name,9);
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
265: INV_TRX_UTIL_PUB.trace('Sub :' ||p_subinventory_code || ':' ,g_pkg_name,9);
266: INV_TRX_UTIL_PUB.trace('Loc :' ||p_locator_id || ':' ,g_pkg_name,9);
267: INV_TRX_UTIL_PUB.trace('TQty :' ||p_transaction_quantity || ':' ,g_pkg_name,9);
268: INV_TRX_UTIL_PUB.trace('PQty:' ||p_primary_quantity || ':' ,g_pkg_name,9);
261: INV_TRX_UTIL_PUB.trace('Ttype :' ||p_transaction_type_id || ':' ,g_pkg_name,9);
262: INV_TRX_UTIL_PUB.trace('Tlot :' ||p_transaction_lot || ':' ,g_pkg_name,9);
263: INV_TRX_UTIL_PUB.trace('Item :' ||p_inventory_item_id || ':' ,g_pkg_name,9);
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
265: INV_TRX_UTIL_PUB.trace('Sub :' ||p_subinventory_code || ':' ,g_pkg_name,9);
266: INV_TRX_UTIL_PUB.trace('Loc :' ||p_locator_id || ':' ,g_pkg_name,9);
267: INV_TRX_UTIL_PUB.trace('TQty :' ||p_transaction_quantity || ':' ,g_pkg_name,9);
268: INV_TRX_UTIL_PUB.trace('PQty:' ||p_primary_quantity || ':' ,g_pkg_name,9);
269: END IF;
262: INV_TRX_UTIL_PUB.trace('Tlot :' ||p_transaction_lot || ':' ,g_pkg_name,9);
263: INV_TRX_UTIL_PUB.trace('Item :' ||p_inventory_item_id || ':' ,g_pkg_name,9);
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
265: INV_TRX_UTIL_PUB.trace('Sub :' ||p_subinventory_code || ':' ,g_pkg_name,9);
266: INV_TRX_UTIL_PUB.trace('Loc :' ||p_locator_id || ':' ,g_pkg_name,9);
267: INV_TRX_UTIL_PUB.trace('TQty :' ||p_transaction_quantity || ':' ,g_pkg_name,9);
268: INV_TRX_UTIL_PUB.trace('PQty:' ||p_primary_quantity || ':' ,g_pkg_name,9);
269: END IF;
270:
263: INV_TRX_UTIL_PUB.trace('Item :' ||p_inventory_item_id || ':' ,g_pkg_name,9);
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
265: INV_TRX_UTIL_PUB.trace('Sub :' ||p_subinventory_code || ':' ,g_pkg_name,9);
266: INV_TRX_UTIL_PUB.trace('Loc :' ||p_locator_id || ':' ,g_pkg_name,9);
267: INV_TRX_UTIL_PUB.trace('TQty :' ||p_transaction_quantity || ':' ,g_pkg_name,9);
268: INV_TRX_UTIL_PUB.trace('PQty:' ||p_primary_quantity || ':' ,g_pkg_name,9);
269: END IF;
270:
271: IF (p_total_qty IS NOT NULL)
264: INV_TRX_UTIL_PUB.trace('Org :' ||p_organization_id || ':' ,g_pkg_name,9);
265: INV_TRX_UTIL_PUB.trace('Sub :' ||p_subinventory_code || ':' ,g_pkg_name,9);
266: INV_TRX_UTIL_PUB.trace('Loc :' ||p_locator_id || ':' ,g_pkg_name,9);
267: INV_TRX_UTIL_PUB.trace('TQty :' ||p_transaction_quantity || ':' ,g_pkg_name,9);
268: INV_TRX_UTIL_PUB.trace('PQty:' ||p_primary_quantity || ':' ,g_pkg_name,9);
269: END IF;
270:
271: IF (p_total_qty IS NOT NULL)
272: THEN
270:
271: IF (p_total_qty IS NOT NULL)
272: THEN
273: IF (l_debug = 1) THEN
274: INV_TRX_UTIL_PUB.trace('p_split is <> nul',g_pkg_name,9);
275: END IF;
276: lot_split_data_insert.insert_mmtt(p_total_qty,
277: p_transaction_type_id,
278: p_userid,
277: p_transaction_type_id,
278: p_userid,
279: x_return_status);
280: IF (l_debug = 1) THEN
281: INV_TRX_UTIL_PUB.trace('after returning from insert_mmtt:Stat:' || x_return_status || ':',g_pkg_name,9);
282: END IF;
283: IF (x_return_status = FND_API.G_RET_STS_ERROR)
284: THEN
285: IF (l_debug = 1) THEN
282: END IF;
283: IF (x_return_status = FND_API.G_RET_STS_ERROR)
284: THEN
285: IF (l_debug = 1) THEN
286: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_ERRO',g_pkg_name,9);
287: END IF;
288: RAISE FND_API.G_EXC_ERROR ;
289: END IF;
290: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
289: END IF;
290: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
291: THEN
292: IF (l_debug = 1) THEN
293: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_UNEXPERRO',g_pkg_name,9);
294: END IF;
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
296: END IF;
297: x_header_id := tab_input(1).transaction_header_id;
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
296: END IF;
297: x_header_id := tab_input(1).transaction_header_id;
298: IF (l_debug = 1) THEN
299: INV_TRX_UTIL_PUB.trace('Header: '|| x_header_id ,g_pkg_name,9);
300: END IF;
301: tab_index :=0;
302: tab_input.delete;
303: END IF;
301: tab_index :=0;
302: tab_input.delete;
303: END IF;
304: IF (l_debug = 1) THEN
305: INV_TRX_UTIL_PUB.trace('mmtt over ' ,g_pkg_name,9);
306: END IF;
307: FND_MSG_PUB.Count_And_Get
308: ( p_count => x_msg_count ,
309: p_data => x_msg_data
317: (p_encoded => FND_API.G_FALSE,
318: p_count => x_msg_count,
319: p_data => x_msg_data);
320: IF (l_debug = 1) THEN
321: INV_TRX_UTIL_PUB.trace(x_msg_data || 'Close',g_pkg_name,9);
322: END IF;
323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
324: ROLLBACK ;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: (p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: IF (l_debug = 1) THEN
331: INV_TRX_UTIL_PUB.trace(x_msg_data || 'Close',g_pkg_name,9);
332: END IF;
333: WHEN OTHERS
334: THEN
335: ROLLBACK ;
338: (p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => x_msg_data);
341: IF (l_debug = 1) THEN
342: INV_TRX_UTIL_PUB.trace(x_msg_data || 'Close',g_pkg_name,9);
343: END IF;
344: END set_table;
345: --
346: PROCEDURE insert_data(p_ind IN NUMBER,
460: ,tab_input(p_ind).transaction_batch_seq
461: ,tab_input(p_ind).secondary_transaction_quantity -- Bug #4093379 INVCONV
462: ,tab_input(p_ind).item_secondary_uom_code); -- Bug #4093379 INVCONV
463: IF (l_debug = 1) THEN
464: INV_TRX_UTIL_PUB.trace('inserted mmtt ..' || p_ind,g_pkg_name,9);
465: END IF;
466:
467: IF (l_debug = 1) THEN
468: INV_TRX_UTIL_PUB.trace('inserting mtlt ' || p_ind,g_pkg_name,9);
464: INV_TRX_UTIL_PUB.trace('inserted mmtt ..' || p_ind,g_pkg_name,9);
465: END IF;
466:
467: IF (l_debug = 1) THEN
468: INV_TRX_UTIL_PUB.trace('inserting mtlt ' || p_ind,g_pkg_name,9);
469: END IF;
470: l_msg_data := 'mtl_transaction_lots_temp ';
471:
472: INSERT INTO
651: ,tab_input(p_ind).hold_date -- Bug #4093379 INVCONV
652: ,tab_input(p_ind).reason_id -- Bug #4093379 INVCONV
653: );
654: IF (l_debug = 1) THEN
655: INV_TRX_UTIL_PUB.trace('inserted mtlt ' || p_ind,g_pkg_name,9);
656: END IF;
657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN
659: x_return_status := FND_API.G_RET_STS_ERROR ;
657: EXCEPTION
658: WHEN FND_API.G_EXC_ERROR THEN
659: x_return_status := FND_API.G_RET_STS_ERROR ;
660: IF (l_debug = 1) THEN
661: INV_TRX_UTIL_PUB.trace( 'G_EXC_ERROR:INV_LOT_COMMIT_FAILURE ' || l_msg_data || ':' || sqlerrm,g_pkg_name,9);
662: END IF;
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
665: IF (l_debug = 1) THEN
662: END IF;
663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
665: IF (l_debug = 1) THEN
666: INV_TRX_UTIL_PUB.trace( 'G_EXC_UNEXPECTED_ERROR:INV_LOT_COMMIT_FAILURE ' || l_msg_data || ':' || sqlerrm,g_pkg_name,9);
667: END IF;
668: WHEN OTHERS THEN
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_COMMIT_FAILURE');
670: FND_MESSAGE.SET_NAME('INV', 'INV_LOT_COMMIT_FAILURE');
671: -- INV_LOT_COMMIT_FAILURE: There has been a database insert error, please contact your dba or Oracle Support'
672: FND_MSG_PUB.ADD;
673: IF (l_debug = 1) THEN
674: INV_TRX_UTIL_PUB.trace( 'Other INV_LOT_COMMIT_FAILURE ' || l_msg_data || ':' || sqlerrm,g_pkg_name,9);
675: END IF;
676: END ;
677: END insert_data;
678:
699:
700: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
701: BEGIN
702: IF (l_debug = 1) THEN
703: INV_TRX_UTIL_PUB.trace('in insert_mmtt',g_pkg_name,9);
704: END IF;
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706:
707: l_msg_data := 'select header_id from dual';
718: l_msg_data := 'select acct_period_id from org_acct_periods';
719:
720: BEGIN
721: IF (l_debug = 1) THEN
722: INV_TRX_UTIL_PUB.trace('getting acct_period_id', g_pkg_name, 9);
723: END IF;
724: SELECT acct_period_id
725: INTO l_acct_period_id
726: FROM org_acct_periods
737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE1', SYSDATE);
738: FND_MSG_PUB.ADD;
739: x_return_status := FND_API.G_RET_STS_ERROR ;
740: IF (l_debug = 1) THEN
741: INV_TRX_UTIL_PUB.trace( 'INV_NOOPEN_PERIOD_FOR_DATE '
742: || ':' || sqlerrm,g_pkg_name,9);
743: END IF;
744: RAISE FND_API.G_EXC_ERROR ;
745: WHEN OTHERS THEN
745: WHEN OTHERS THEN
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
748: IF (l_debug = 1) THEN
749: INV_TRX_UTIL_PUB.trace( 'Others:INV_NOOPEN_PERIOD_FOR_DATE '
750: || ':' || sqlerrm,g_pkg_name,9);
751: END IF;
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
753: END;
755: /* For Lot Translate, need to get the distribution account id and populate
756: into mmtt */
757: IF (p_transaction_type_id = inv_globals.G_type_inv_lot_translate) THEN
758: IF (l_debug = 1) THEN
759: INV_TRX_UTIL_PUB.trace('lot translate before getting dist acct', g_pkg_name, 9);
760: END IF;
761: BEGIN
762: SELECT distribution_account_id,
763: wsm_enabled_flag
767: WHERE organization_id = tab_input(1).organization_id;
768:
769: IF (l_dist_account_id IS NULL AND l_wsm_enabled_flag = 'Y') THEN
770: IF (l_debug = 1) THEN
771: INV_TRX_UTIL_PUB.trace('dist acct is null and wsm enabled = Y', g_pkg_name, 9);
772: END IF;
773: SELECT transaction_account_id
774: INTO l_dist_account_id
775: FROM wsm_parameters
779: IF (l_dist_account_id IS NULL) THEN
780: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');
781: FND_MSG_PUB.ADD;
782: IF (l_debug = 1) THEN
783: INV_TRX_UTIL_PUB.trace('INV_NO_DIST_ACCOUNT_ID' || ':' || sqlerrm, g_pkg_name, 9);
784: END IF;
785: x_return_status := FND_API.G_RET_STS_ERROR;
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
790: WHEN NO_DATA_FOUND THEN
791: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');
792: FND_MSG_PUB.ADD;
793: IF (l_debug = 1) THEN
794: INV_TRX_UTIL_PUB.trace('INV_NO_DIST_ACCOUNT_ID' || ':' || sqlerrm, g_pkg_name, 9);
795: END IF;
796: x_return_status := FND_API.G_RET_STS_ERROR;
797: RAISE FND_API.G_EXC_ERROR;
798: WHEN OTHERS THEN
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: FND_MESSAGE.SET_NAME('INV', 'INV_NO_DIST_ACCOUNT_ID');
801: FND_MSG_PUB.ADD;
802: IF (l_debug = 1) THEN
803: INV_TRX_UTIL_PUB.trace('INV_NO_DIST_ACCOUNT_ID' || ':' || sqlerrm, g_pkg_name, 9);
804: END IF;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END;
807:
850: AND parent_lpn_id IS NULL
851: AND lpn_context IN (1,5); -- Bug No 3886482, Pick LPNS with status 'Defined But Not Used'
852:
853: IF (l_debug = 1) THEN
854: INV_TRX_UTIL_PUB.trace('Lpn Found for ' || tab_input(ind).lpn_number ||
855: ':Id: ' || l_xfr_lpn_id,g_pkg_name,9);
856: END IF;
857: EXCEPTION
858: WHEN NO_DATA_FOUND THEN
856: END IF;
857: EXCEPTION
858: WHEN NO_DATA_FOUND THEN
859: IF (l_debug = 1) THEN
860: INV_TRX_UTIL_PUB.trace('No Lpn Found for ' || tab_input(ind).lpn_number,g_pkg_name,9);
861: END IF;
862: l_msg_data := l_msg_data || 'NO_DATA_FOUND: ' || sqlerrm;
863: IF (l_debug = 1) THEN
864: INV_TRX_UTIL_PUB.trace('msg:' || l_msg_data,g_pkg_name,9);
860: INV_TRX_UTIL_PUB.trace('No Lpn Found for ' || tab_input(ind).lpn_number,g_pkg_name,9);
861: END IF;
862: l_msg_data := l_msg_data || 'NO_DATA_FOUND: ' || sqlerrm;
863: IF (l_debug = 1) THEN
864: INV_TRX_UTIL_PUB.trace('msg:' || l_msg_data,g_pkg_name,9);
865: END IF;
866: WMS_Container_PUB.Create_LPN
867: ( p_api_version => 1.0,
868: x_return_status => x_return_status ,
876: p_locator_id => tab_input(ind).locator_id ,
877: x_lpn_id => l_xfr_lpn_id);
878:
879: IF (l_debug = 1) THEN
880: INV_TRX_UTIL_PUB.trace('Generate_lpn for ' || tab_input(ind).lpn_number ||
881: ':Id: ' || l_xfr_lpn_id ||
882: 'stat ' || x_return_status ||
883: 'msgt ' || l_msg_count ||
884: 'data ' || l_msg_data,g_pkg_name,9);
886:
887: IF (x_return_status = FND_API.G_RET_STS_ERROR)
888: THEN
889: IF (l_debug = 1) THEN
890: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_ERROR',g_pkg_name,9);
891: END IF;
892: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
893: FND_MSG_PUB.ADD;
894: RAISE FND_API.G_EXC_ERROR ;
897: THEN
898: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
899: FND_MSG_PUB.ADD;
900: IF (l_debug = 1) THEN
901: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_UNEXPERROR',g_pkg_name,9);
902: END IF;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
904: END IF;
905:
904: END IF;
905:
906: WHEN OTHERS THEN
907: IF (l_debug = 1) THEN
908: INV_TRX_UTIL_PUB.trace('No Lpn Found for ' || tab_input(ind).lpn_number,g_pkg_name,9);
909: END IF;
910: l_msg_data := 'LPN not found: ' || sqlerrm;
911: IF (l_debug = 1) THEN
912: INV_TRX_UTIL_PUB.trace(l_msg_data,g_pkg_name,9);
908: INV_TRX_UTIL_PUB.trace('No Lpn Found for ' || tab_input(ind).lpn_number,g_pkg_name,9);
909: END IF;
910: l_msg_data := 'LPN not found: ' || sqlerrm;
911: IF (l_debug = 1) THEN
912: INV_TRX_UTIL_PUB.trace(l_msg_data,g_pkg_name,9);
913: END IF;
914: FND_MESSAGE.SET_NAME('INV', 'INV_FIELD_INVALID');
915: FND_MESSAGE.SET_TOKEN('ENTITY1', tab_input(ind).lpn_number);
916: FND_MSG_PUB.ADD;
975: THEN
976: FOR ind IN 1..tab_index
977: LOOP
978: IF (l_debug = 1) THEN
979: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
980: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
981: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
982: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
976: FOR ind IN 1..tab_index
977: LOOP
978: IF (l_debug = 1) THEN
979: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
980: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
981: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
982: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
977: LOOP
978: IF (l_debug = 1) THEN
979: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
980: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
981: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
982: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
978: IF (l_debug = 1) THEN
979: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
980: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
981: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
982: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
979: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
980: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
981: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
982: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
980: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
981: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
982: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
981: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
982: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
982: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
983: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
991: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
984: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
991: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
992: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
985: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
991: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
992: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
993: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
986: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
991: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
992: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
993: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
994: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
987: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
991: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
992: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
993: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
994: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
995: END IF;
988: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
991: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
992: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
993: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
994: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
995: END IF;
996:
989: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
991: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
992: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
993: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
994: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
995: END IF;
996:
997: IF (l_debug = 1) THEN
990: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
991: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
992: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
993: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
994: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
995: END IF;
996:
997: IF (l_debug = 1) THEN
998: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
994: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
995: END IF;
996:
997: IF (l_debug = 1) THEN
998: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
999: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1000: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1001: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
995: END IF;
996:
997: IF (l_debug = 1) THEN
998: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
999: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1000: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1001: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
996:
997: IF (l_debug = 1) THEN
998: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
999: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1000: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1001: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
997: IF (l_debug = 1) THEN
998: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
999: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1000: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1001: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
998: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
999: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1000: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1001: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
999: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1000: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1001: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1000: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1001: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1001: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1002: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1003: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1004: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1005: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1006: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1014: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1007: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1014: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1015: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1008: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1014: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1015: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1016: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1009: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1014: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1015: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1016: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1017: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1010: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id,g_pkg_name,9);
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1014: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1015: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1016: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1017: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1018: END IF;
1011: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1014: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1015: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1016: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1017: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1018: END IF;
1019:
1012: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1014: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1015: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1016: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1017: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1018: END IF;
1019:
1020: insert_data (p_ind => ind,
1013: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1014: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1015: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1016: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1017: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1018: END IF;
1019:
1020: insert_data (p_ind => ind,
1021: p_ind_1st => ind_1st ,
1029:
1030: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1031: THEN
1032: IF (l_debug = 1) THEN
1033: INV_TRX_UTIL_PUB.trace('Split..FND_API.G_RET_STS_ERROR',g_pkg_name,9);
1034: END IF;
1035: RAISE FND_API.G_EXC_ERROR ;
1036: END IF;
1037: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1036: END IF;
1037: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1038: THEN
1039: IF (l_debug = 1) THEN
1040: INV_TRX_UTIL_PUB.trace('Split..FND_API.G_RET_STS_UNEXPERROR',g_pkg_name,9);
1041: END IF;
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1043: END IF;
1044:
1048: IF ( p_transaction_type_id = inv_globals.G_type_inv_lot_merge) THEN
1049: FOR ind IN REVERSE 1..tab_index
1050: LOOP
1051: IF (l_debug = 1) THEN
1052: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
1053: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
1054: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
1055: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1049: FOR ind IN REVERSE 1..tab_index
1050: LOOP
1051: IF (l_debug = 1) THEN
1052: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
1053: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
1054: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
1055: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1050: LOOP
1051: IF (l_debug = 1) THEN
1052: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
1053: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
1054: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
1055: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1051: IF (l_debug = 1) THEN
1052: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
1053: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
1054: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
1055: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1052: INV_TRX_UTIL_PUB.trace(ind || ': Header_id ' || tab_input(ind).transaction_header_id,g_pkg_name,9);
1053: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
1054: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
1055: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1053: INV_TRX_UTIL_PUB.trace(ind || ': Parent_id ' || l_parent_id,g_pkg_name,9);
1054: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
1055: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1054: INV_TRX_UTIL_PUB.trace(ind || ': Temp_id ' || tab_input(ind).transaction_temp_id,g_pkg_name,9);
1055: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1055: INV_TRX_UTIL_PUB.trace(ind || ': Batch_id ' || tab_input(ind).transaction_batch_id,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1056: INV_TRX_UTIL_PUB.trace(ind || ': Batch_seq ' || tab_input(ind).transaction_batch_seq,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1064: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
1057: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).transaction_type_id,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1064: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
1065: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
1058: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind).transaction_lot ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1064: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
1065: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
1066: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
1059: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).inventory_item_id ,g_pkg_name,9);
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1064: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
1065: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
1066: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
1067: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
1060: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).revision ,g_pkg_name,9);
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1064: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
1065: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
1066: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
1067: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
1068: END IF;
1061: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).organization_id ,g_pkg_name,9);
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1064: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
1065: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
1066: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
1067: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
1068: END IF;
1069:
1062: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).subinventory_code ,g_pkg_name,9);
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1064: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
1065: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
1066: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
1067: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
1068: END IF;
1069:
1070: IF (l_debug = 1) THEN
1063: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).locator_id ,g_pkg_name,9);
1064: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).transaction_quantity,g_pkg_name,9);
1065: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).primary_quantity ,g_pkg_name,9);
1066: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).transaction_uom ,g_pkg_name,9);
1067: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
1068: END IF;
1069:
1070: IF (l_debug = 1) THEN
1071: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
1067: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).secondary_transaction_quantity ,g_pkg_name,9); -- Bug #4093379 INVCONV
1068: END IF;
1069:
1070: IF (l_debug = 1) THEN
1071: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
1072: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1073: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1074: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1068: END IF;
1069:
1070: IF (l_debug = 1) THEN
1071: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
1072: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1073: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1074: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1069:
1070: IF (l_debug = 1) THEN
1071: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
1072: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1073: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1074: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1070: IF (l_debug = 1) THEN
1071: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
1072: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1073: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1074: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1071: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind_1st).item_description ,g_pkg_name,9);
1072: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1073: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1074: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1072: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || tab_input(ind_1st).item_location_control_code,g_pkg_name,9);
1073: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1074: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1073: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind_1st).item_restrict_subinv_code ,g_pkg_name,9);
1074: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1074: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind_1st).item_restrict_locators_code,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1075: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind_1st).item_revision_qty_control_code,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1076: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind_1st).item_primary_uom_code ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1077: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind_1st).item_shelf_life_code ,g_pkg_name,9);
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1078: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind_1st).item_shelf_life_days ,g_pkg_name,9);
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1079: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind_1st).allowed_units_lookup_code ,g_pkg_name,9);
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1087: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1080: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).lot_number ,g_pkg_name,9);
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1087: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1088: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1081: INV_TRX_UTIL_PUB.trace(ind || ': 1 ' || tab_input(ind).lot_expiration_date ,g_pkg_name,9);
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1087: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1088: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1089: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1082: INV_TRX_UTIL_PUB.trace(ind || ': 2 ' || p_total_qty,g_pkg_name,9);
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1087: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1088: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1089: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1090: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1083: INV_TRX_UTIL_PUB.trace(ind || ': 3 ' || tab_input(ind).lpn_id ,g_pkg_name,9);
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1087: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1088: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1089: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1090: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1091: END IF;
1084: INV_TRX_UTIL_PUB.trace(ind || ': 4 ' || tab_input(ind).lpn_number ,g_pkg_name,9);
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1087: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1088: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1089: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1090: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1091: END IF;
1092:
1085: INV_TRX_UTIL_PUB.trace(ind || ': 5 ' || tab_input(ind).item_secondary_uom_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1087: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1088: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1089: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1090: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1091: END IF;
1092:
1093: insert_data (p_ind => ind,
1086: INV_TRX_UTIL_PUB.trace(ind || ': 6 ' || tab_input(ind).parent_lot_number ,g_pkg_name,9); -- Bug #4093379 INVCONV
1087: INV_TRX_UTIL_PUB.trace(ind || ': 7 ' || tab_input(ind).expiration_action_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1088: INV_TRX_UTIL_PUB.trace(ind || ': 8 ' || tab_input(ind).expiration_action_code ,g_pkg_name,9); -- Bug #4093379 INVCONV
1089: INV_TRX_UTIL_PUB.trace(ind || ': 9 ' || tab_input(ind).hold_date ,g_pkg_name,9); -- Bug #4093379 INVCONV
1090: INV_TRX_UTIL_PUB.trace(ind || ': 0 ' || tab_input(ind).reason_id ,g_pkg_name,9); -- Bug #4093379 INVCONV
1091: END IF;
1092:
1093: insert_data (p_ind => ind,
1094: p_ind_1st => ind_1st ,
1102:
1103: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1104: THEN
1105: IF (l_debug = 1) THEN
1106: INV_TRX_UTIL_PUB.trace('Merge..FND_API.G_RET_STS_ERROR',g_pkg_name,9);
1107: INV_TRX_UTIL_PUB.trace('x_msg_data:x_label_status:'|| l_msg_data || ':'
1108: || l_label_status || ':' ,g_pkg_name,9);
1109: END IF;
1110: RAISE FND_API.G_EXC_ERROR ;
1103: IF (x_return_status = FND_API.G_RET_STS_ERROR)
1104: THEN
1105: IF (l_debug = 1) THEN
1106: INV_TRX_UTIL_PUB.trace('Merge..FND_API.G_RET_STS_ERROR',g_pkg_name,9);
1107: INV_TRX_UTIL_PUB.trace('x_msg_data:x_label_status:'|| l_msg_data || ':'
1108: || l_label_status || ':' ,g_pkg_name,9);
1109: END IF;
1110: RAISE FND_API.G_EXC_ERROR ;
1111: END IF;
1111: END IF;
1112: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1113: THEN
1114: IF (l_debug = 1) THEN
1115: INV_TRX_UTIL_PUB.trace('Merge..FND_API.G_RET_STS_UNEXPERROR',g_pkg_name,9);
1116: INV_TRX_UTIL_PUB.trace('x_msg_data:x_label_status:'|| l_msg_data || ':'
1117: || l_label_status || ':' ,g_pkg_name,9);
1118: END IF;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1112: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR)
1113: THEN
1114: IF (l_debug = 1) THEN
1115: INV_TRX_UTIL_PUB.trace('Merge..FND_API.G_RET_STS_UNEXPERROR',g_pkg_name,9);
1116: INV_TRX_UTIL_PUB.trace('x_msg_data:x_label_status:'|| l_msg_data || ':'
1117: || l_label_status || ':' ,g_pkg_name,9);
1118: END IF;
1119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1120: END IF;
1124: EXCEPTION
1125: WHEN FND_API.G_EXC_ERROR THEN
1126: x_return_status := FND_API.G_RET_STS_ERROR ;
1127: IF (l_debug = 1) THEN
1128: INV_TRX_UTIL_PUB.trace('insert_mmtt:G_EXC_ERROR: ' || sqlerrm ,g_pkg_name,9);
1129: END IF;
1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132: IF (l_debug = 1) THEN
1129: END IF;
1130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132: IF (l_debug = 1) THEN
1133: INV_TRX_UTIL_PUB.trace('insert_mmtt:G_EXC_UNEXPECTED_ERROR: ' || sqlerrm ,g_pkg_name,9);
1134: END IF;
1135: WHEN OTHERS
1136: THEN
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: WHEN OTHERS
1136: THEN
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: IF (l_debug = 1) THEN
1139: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_UNEXP_ERROR; outer most others' || sqlerrm,g_pkg_name,9);
1140: INV_TRX_UTIL_PUB.trace('other outer most...file closed' ,g_pkg_name,9);
1141: INV_TRX_UTIL_PUB.trace(l_msg_data,g_pkg_name,9);
1142: END IF;
1143: END insert_mmtt;
1136: THEN
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: IF (l_debug = 1) THEN
1139: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_UNEXP_ERROR; outer most others' || sqlerrm,g_pkg_name,9);
1140: INV_TRX_UTIL_PUB.trace('other outer most...file closed' ,g_pkg_name,9);
1141: INV_TRX_UTIL_PUB.trace(l_msg_data,g_pkg_name,9);
1142: END IF;
1143: END insert_mmtt;
1144: --
1137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1138: IF (l_debug = 1) THEN
1139: INV_TRX_UTIL_PUB.trace('FND_API.G_RET_STS_UNEXP_ERROR; outer most others' || sqlerrm,g_pkg_name,9);
1140: INV_TRX_UTIL_PUB.trace('other outer most...file closed' ,g_pkg_name,9);
1141: INV_TRX_UTIL_PUB.trace(l_msg_data,g_pkg_name,9);
1142: END IF;
1143: END insert_mmtt;
1144: --
1145: PROCEDURE select_init_parameters(
1217: WHERE organization_id = p_organization_id;
1218:
1219: IF (x_dist_account_id IS NULL AND x_wsm_enabled_flag = 'Y') THEN
1220: IF (l_debug = 1) THEN
1221: INV_TRX_UTIL_PUB.trace('dist acct is null and wsm enabled = Y', g_pkg_name, 9);
1222: END IF;
1223: SELECT NVL(transaction_account_id, 0)
1224: INTO x_dist_account_id
1225: FROM wsm_parameters
1226: WHERE organization_id = p_organization_id;
1227: END IF;
1228:
1229: IF (l_debug = 1) THEN
1230: INV_TRX_UTIL_PUB.trace('dist acct = ' || x_dist_account_id, g_pkg_name, 9);
1231: END IF;
1232:
1233: EXCEPTION
1234: WHEN NO_DATA_FOUND THEN