[Home] [Help]
1146: -- Bug5659809: update last_update_date and last_update_by as well
1147: UPDATE wms_license_plate_numbers
1148: SET lpn_context = 1
1149: --, last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
1150: --, last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
1151: WHERE lpn_id = l_lpn_id;
1152:
1153: -- Update remaining MMTT record
1154: UPDATE mtl_material_transactions_temp
1424: UPDATE wms_license_plate_numbers
1425: SET lpn_context = l_lpn_context_packing
1426: ,catch_weight_flag = NULL --16466288
1427: -- , last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
1428: -- , last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
1429: WHERE lpn_id = l_lpn_match_lpn_id
1430: AND lpn_context = l_lpn_context_inv --, l_transfer_lpn_id)
1431: AND organization_id = p_organization_id;
1432:
1484: UPDATE wms_license_plate_numbers
1485: SET lpn_context = l_lpn_context_packing
1486: ,catch_weight_flag = NULL --16466288
1487: --, last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
1488: --, last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
1489: WHERE lpn_id = l_transfer_lpn_id
1490: AND lpn_context in (l_lpn_context_packing , l_lpn_context_pregenerated)
1491: AND organization_id = p_organization_id;
1492:
6766: -- Bug5659809: update last_update_date and last_update_by as well
6767: UPDATE wms_license_plate_numbers
6768: SET lpn_context = l_lpn_context_PREGENERATED
6769: -- , last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
6770: -- , last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
6771: WHERE lpn_id = rec_transfer_lpns.transfer_lpn_id
6772: AND lpn_context <> l_lpn_context_picked;
6773:
6774: IF SQL%NOTFOUND THEN
6789: -- Bug5659809: update last_update_date and last_update_by as well
6790: UPDATE wms_license_plate_numbers
6791: SET lpn_context = l_lpn_context_INV
6792: --, last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
6793: --, last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
6794: WHERE lpn_id = rec_from_lpns.lpn_id
6795: AND lpn_context = l_lpn_context_packing;
6796:
6797: IF SQL%NOTFOUND THEN
6824: -- Bug5659809: update last_update_date and last_update_by as well
6825: UPDATE wms_license_plate_numbers
6826: SET lpn_context = l_lpn_context_inv
6827: --, last_update_date = SYSDATE /* Bug 9448490 Lot Substitution Project */
6828: --, last_updated_by = fnd_global.user_id /* Bug 9448490 Lot Substitution Project */
6829: WHERE lpn_id = rec_content_lpns.content_lpn_id
6830: AND lpn_context <> l_lpn_context_picked;
6831:
6832: IF SQL%NOTFOUND THEN
12795: END IF;
12796: ELSIF(l_msg_count = 1) THEN
12797: IF (l_debug = 1) THEN
12798: mydebug('check_pack_lpn: Not Successful');
12799: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
12800: END IF;
12801: ELSE
12802: IF (l_debug = 1) THEN
12803: mydebug('check_pack_lpn: Not Successful2');
12806: FOR i IN 1 .. l_msg_count LOOP
12807: x_msg_data := fnd_msg_pub.get(i, 'F');
12808:
12809: IF (l_debug = 1) THEN
12810: mydebug(REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
12811: END IF;
12812: END LOOP;
12813: END IF;
12814:
15538: p_item_id => p_item_id,
15539: p_revision => p_rev,
15540: p_lot => rec_lots_in_lpn.lot_number,
15541: p_transaction_temp_id => p_transaction_temp_id,
15542: p_created_by => fnd_global.user_id,
15543: p_from_serial => rec_serials_in_lpn.serial_number,
15544: p_to_serial => rec_serials_in_lpn.serial_number,
15545: p_status_id => NULL,
15546: x_return_status => l_ser_return_status,
15636: mydebug (p_api_name||' Item is Serial Controlled');
15637: -- Unmark the Serials
15638: UPDATE MTL_SERIAL_NUMBERS
15639: SET group_mark_id = NULL
15640: , last_updated_by = fnd_global.user_id
15641: , last_update_date = SYSDATE
15642: WHERE (current_organization_id
15643: ,inventory_item_id
15644: ,serial_number)