372: IF (l_sec_quantity_cancel = -99999) THEN
373: IF (l_debug = 1) THEN
374: DEBUG('Cannot convert uom to secondary uom', 'UPDATE LOTS TEMP');
375: END IF;
376: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
377: fnd_message.set_token('VALUE1', l_secondary_uom_code);
378: fnd_message.set_token('VALUE2', p_trx_uom);
379: fnd_msg_pub.ADD;
380: RAISE fnd_api.g_exc_unexpected_error;
373: IF (l_debug = 1) THEN
374: DEBUG('Cannot convert uom to secondary uom', 'UPDATE LOTS TEMP');
375: END IF;
376: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
377: fnd_message.set_token('VALUE1', l_secondary_uom_code);
378: fnd_message.set_token('VALUE2', p_trx_uom);
379: fnd_msg_pub.ADD;
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;
374: DEBUG('Cannot convert uom to secondary uom', 'UPDATE LOTS TEMP');
375: END IF;
376: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
377: fnd_message.set_token('VALUE1', l_secondary_uom_code);
378: fnd_message.set_token('VALUE2', p_trx_uom);
379: fnd_msg_pub.ADD;
380: RAISE fnd_api.g_exc_unexpected_error;
381: END IF;
382:
613: IF (l_sec_quantity_cancel = -99999) THEN
614: IF (l_debug = 1) THEN
615: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
616: END IF;
617: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
618: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
619: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
620: fnd_msg_pub.ADD;
621: RAISE fnd_api.g_exc_unexpected_error;
614: IF (l_debug = 1) THEN
615: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
616: END IF;
617: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
618: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
619: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
620: fnd_msg_pub.ADD;
621: RAISE fnd_api.g_exc_unexpected_error;
622: END IF;
615: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
616: END IF;
617: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
618: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
619: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
620: fnd_msg_pub.ADD;
621: RAISE fnd_api.g_exc_unexpected_error;
622: END IF;
623: IF l_trolin_rec.secondary_quantity_detailed IS NOT NULL THEN
814: IF (l_secondary_uom_qty = -99999) THEN
815: IF (l_debug = 1) THEN
816: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
817: END IF;
818: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
819: fnd_message.set_token('VALUE1', l_troldt_tbl(l_counter).secondary_uom_code);
820: fnd_message.set_token('VALUE2', l_transaction_uom);
821: fnd_msg_pub.ADD;
822: RAISE fnd_api.g_exc_unexpected_error;
815: IF (l_debug = 1) THEN
816: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
817: END IF;
818: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
819: fnd_message.set_token('VALUE1', l_troldt_tbl(l_counter).secondary_uom_code);
820: fnd_message.set_token('VALUE2', l_transaction_uom);
821: fnd_msg_pub.ADD;
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;
816: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
817: END IF;
818: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
819: fnd_message.set_token('VALUE1', l_troldt_tbl(l_counter).secondary_uom_code);
820: fnd_message.set_token('VALUE2', l_transaction_uom);
821: fnd_msg_pub.ADD;
822: RAISE fnd_api.g_exc_unexpected_error;
823: END IF;
824: IF l_secondary_uom_qty < 0 THEN
1386: IF (l_trolin_rec.secondary_quantity = -99999) THEN
1387: IF (l_debug = 1) THEN
1388: DEBUG('Cannot convert uom to secondary uom', 'Inv_Transfer_Order_PVT.Trolins');
1389: END IF;
1390: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1391: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
1392: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
1393: fnd_msg_pub.ADD;
1394: RAISE fnd_api.g_exc_unexpected_error;
1387: IF (l_debug = 1) THEN
1388: DEBUG('Cannot convert uom to secondary uom', 'Inv_Transfer_Order_PVT.Trolins');
1389: END IF;
1390: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1391: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
1392: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
1393: fnd_msg_pub.ADD;
1394: RAISE fnd_api.g_exc_unexpected_error;
1395: END IF;
1388: DEBUG('Cannot convert uom to secondary uom', 'Inv_Transfer_Order_PVT.Trolins');
1389: END IF;
1390: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1391: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
1392: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
1393: fnd_msg_pub.ADD;
1394: RAISE fnd_api.g_exc_unexpected_error;
1395: END IF;
1396: END IF;
2716: END IF;
2717:
2718: -- Cannot transact a closed move order line
2719: IF l_trolin_rec.line_status = 5 THEN
2720: fnd_message.set_name('INV', 'INV_CANNOT_TRX_CLOSED_MO');
2721: x_return_status := fnd_api.g_ret_sts_error;
2722: RAISE fnd_api.g_exc_error;
2723: END IF;
2724:
2854: DEBUG('Patchset Level I:Overpicking not allowed for WMS orgs', 'Finalize_Pick_Confirm');
2855: END IF;
2856: IF l_wms_org_flag AND l_move_order_type = 3
2857: AND l_trolin_rec.quantity_delivered > l_trolin_rec.quantity THEN
2858: fnd_message.set_name('INV', 'INV_CANNOT_OVERPICK_WMS_SO');
2859: x_return_status := fnd_api.g_ret_sts_error;
2860: RAISE fnd_api.g_exc_error;
2861: END IF;
2862:
2921: IF (l_primary_shipping_quantity = -99999) THEN
2922: IF (l_debug = 1) THEN
2923: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2924: END IF;
2925: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2926: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2927: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2928: fnd_msg_pub.ADD;
2929: RAISE fnd_api.g_exc_unexpected_error;
2922: IF (l_debug = 1) THEN
2923: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2924: END IF;
2925: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2926: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2927: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2928: fnd_msg_pub.ADD;
2929: RAISE fnd_api.g_exc_unexpected_error;
2930: END IF;
2923: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2924: END IF;
2925: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2926: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2927: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2928: fnd_msg_pub.ADD;
2929: RAISE fnd_api.g_exc_unexpected_error;
2930: END IF;
2931: END IF;
2978: IF (l_curr_mmtt_txn_qty = -99999) THEN
2979: IF (l_debug = 1) THEN
2980: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
2981: END IF;
2982: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2983: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2984: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2985: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2986: fnd_msg_pub.ADD;
2979: IF (l_debug = 1) THEN
2980: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
2981: END IF;
2982: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2983: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2984: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2985: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2986: fnd_msg_pub.ADD;
2987: RAISE fnd_api.g_exc_unexpected_error;
2980: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
2981: END IF;
2982: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2983: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2984: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2985: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2986: fnd_msg_pub.ADD;
2987: RAISE fnd_api.g_exc_unexpected_error;
2988: END IF;
2981: END IF;
2982: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2983: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2984: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2985: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2986: fnd_msg_pub.ADD;
2987: RAISE fnd_api.g_exc_unexpected_error;
2988: END IF;
2989: ELSIF(l_fulfillment_base = 'S' ) THEN
3004: IF (l_curr_mmtt_txn_qty = -99999) THEN
3005: IF (l_debug = 1) THEN
3006: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
3007: END IF;
3008: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3009: fnd_message.set_token('UOM1', l_curr_mmtt_sec_uom);
3010: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3011: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3012: fnd_msg_pub.ADD;
3005: IF (l_debug = 1) THEN
3006: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
3007: END IF;
3008: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3009: fnd_message.set_token('UOM1', l_curr_mmtt_sec_uom);
3010: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3011: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3012: fnd_msg_pub.ADD;
3013: RAISE fnd_api.g_exc_unexpected_error;
3006: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
3007: END IF;
3008: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3009: fnd_message.set_token('UOM1', l_curr_mmtt_sec_uom);
3010: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3011: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3012: fnd_msg_pub.ADD;
3013: RAISE fnd_api.g_exc_unexpected_error;
3014: END IF;
3007: END IF;
3008: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3009: fnd_message.set_token('UOM1', l_curr_mmtt_sec_uom);
3010: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3011: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3012: fnd_msg_pub.ADD;
3013: RAISE fnd_api.g_exc_unexpected_error;
3014: END IF;
3015: END IF;
3073: IF (g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_quantity = -99999) THEN
3074: IF (l_debug = 1) THEN
3075: DEBUG('Cannot convert uom of cached qty to current transaction_uom ', 'Finalize_Pick_Confirm');
3076: END IF;
3077: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3078: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom );
3079: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3080: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3081: fnd_msg_pub.ADD;
3074: IF (l_debug = 1) THEN
3075: DEBUG('Cannot convert uom of cached qty to current transaction_uom ', 'Finalize_Pick_Confirm');
3076: END IF;
3077: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3078: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom );
3079: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3080: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3081: fnd_msg_pub.ADD;
3082: RAISE fnd_api.g_exc_unexpected_error;
3075: DEBUG('Cannot convert uom of cached qty to current transaction_uom ', 'Finalize_Pick_Confirm');
3076: END IF;
3077: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3078: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom );
3079: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3080: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3081: fnd_msg_pub.ADD;
3082: RAISE fnd_api.g_exc_unexpected_error;
3083: END IF;
3076: END IF;
3077: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
3078: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom );
3079: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
3080: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3081: fnd_msg_pub.ADD;
3082: RAISE fnd_api.g_exc_unexpected_error;
3083: END IF;
3084: g_mo_picked_quantity_tbl(MOD(l_trolin_rec.line_id,2147483648)).picked_uom := l_mmtt_rec.transaction_uom ;
3171: IF (l_primary_pending_quantity = -99999) THEN
3172: IF (l_debug = 1) THEN
3173: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3174: END IF;
3175: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3176: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
3177: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3178: fnd_msg_pub.ADD;
3179: RAISE fnd_api.g_exc_unexpected_error;
3172: IF (l_debug = 1) THEN
3173: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3174: END IF;
3175: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3176: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
3177: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3178: fnd_msg_pub.ADD;
3179: RAISE fnd_api.g_exc_unexpected_error;
3180: END IF;
3173: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3174: END IF;
3175: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3176: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
3177: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3178: fnd_msg_pub.ADD;
3179: RAISE fnd_api.g_exc_unexpected_error;
3180: END IF;
3181: ELSE
3278: IF (l_unalloc_quantity = -99999) THEN
3279: IF (l_debug = 1) THEN
3280: DEBUG('Calculating unalloc qty: cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3281: END IF;
3282: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3283: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);
3284: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3285: fnd_msg_pub.ADD;
3286: RAISE fnd_api.g_exc_unexpected_error;
3279: IF (l_debug = 1) THEN
3280: DEBUG('Calculating unalloc qty: cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3281: END IF;
3282: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3283: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);
3284: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3285: fnd_msg_pub.ADD;
3286: RAISE fnd_api.g_exc_unexpected_error;
3287: END IF;
3280: DEBUG('Calculating unalloc qty: cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3281: END IF;
3282: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3283: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);
3284: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3285: fnd_msg_pub.ADD;
3286: RAISE fnd_api.g_exc_unexpected_error;
3287: END IF;
3288: END IF; -- if UOM code not primary UOM
3317: IF (l_debug = 1) THEN
3318: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');
3319: DEBUG('Unable to lock the work order line for update', 'Finalize_Pick_Confirm');
3320: END IF;
3321: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
3322: fnd_msg_pub.ADD;
3323: RAISE fnd_api.g_exc_error;
3324: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
3325: IF (l_debug = 1) THEN
4593: AND WDD.released_status = 'S'
4594: FOR UPDATE NOWAIT;
4595: EXCEPTION
4596: WHEN NO_DATA_FOUND THEN
4597: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');
4598: fnd_msg_pub.ADD;
4599: RAISE fnd_api.g_exc_error;
4600: WHEN OTHERS THEN
4601: --could not lock row
4599: RAISE fnd_api.g_exc_error;
4600: WHEN OTHERS THEN
4601: --could not lock row
4602: IF SQLCODE = -54 THEN
4603: fnd_message.set_name('INV', 'INV_DELIV_INFO_LOCKED');
4604: fnd_message.set_token('LINEID', l_trolin_rec.line_id);
4605: fnd_msg_pub.ADD;
4606: RAISE fnd_api.g_exc_error;
4607: ELSE
4600: WHEN OTHERS THEN
4601: --could not lock row
4602: IF SQLCODE = -54 THEN
4603: fnd_message.set_name('INV', 'INV_DELIV_INFO_LOCKED');
4604: fnd_message.set_token('LINEID', l_trolin_rec.line_id);
4605: fnd_msg_pub.ADD;
4606: RAISE fnd_api.g_exc_error;
4607: ELSE
4608: RAISE fnd_api.g_exc_unexpected_error;
4788: , x_msg_data => x_msg_data
4789: , p_organization_id => l_mmtt_rec.organization_id
4790: , p_inventory_item_id => l_mmtt_rec.inventory_item_id );
4791: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
4792: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
4793: fnd_msg_pub.ADD;
4794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4795: END IF;
4796:
4795: END IF;
4796:
4797: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)
4798: AND nvl(l_mmtt_rec.secondary_transaction_quantity,0) = 0) THEN -- added secondary_transaction_quantity for bug 12616674
4799: fnd_message.set_name('INV', 'WMS_CATCH_WEIGHT_NO_LPN_ERR');
4800: fnd_msg_pub.ADD;
4801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4802: END IF;
4803: