DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on FND_MESSAGE

Line 373: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');

369: IF (l_sec_quantity_cancel = -99999) THEN
370: IF (l_debug = 1) THEN
371: DEBUG('Cannot convert uom to secondary uom', 'UPDATE LOTS TEMP');
372: END IF;
373: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
374: fnd_message.set_token('VALUE1', l_secondary_uom_code);
375: fnd_message.set_token('VALUE2', p_trx_uom);
376: fnd_msg_pub.ADD;
377: RAISE fnd_api.g_exc_unexpected_error;

Line 374: fnd_message.set_token('VALUE1', l_secondary_uom_code);

370: IF (l_debug = 1) THEN
371: DEBUG('Cannot convert uom to secondary uom', 'UPDATE LOTS TEMP');
372: END IF;
373: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
374: fnd_message.set_token('VALUE1', l_secondary_uom_code);
375: fnd_message.set_token('VALUE2', p_trx_uom);
376: fnd_msg_pub.ADD;
377: RAISE fnd_api.g_exc_unexpected_error;
378: END IF;

Line 375: fnd_message.set_token('VALUE2', p_trx_uom);

371: DEBUG('Cannot convert uom to secondary uom', 'UPDATE LOTS TEMP');
372: END IF;
373: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
374: fnd_message.set_token('VALUE1', l_secondary_uom_code);
375: fnd_message.set_token('VALUE2', p_trx_uom);
376: fnd_msg_pub.ADD;
377: RAISE fnd_api.g_exc_unexpected_error;
378: END IF;
379:

Line 614: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');

610: IF (l_sec_quantity_cancel = -99999) THEN
611: IF (l_debug = 1) THEN
612: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
613: END IF;
614: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
615: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
616: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
617: fnd_msg_pub.ADD;
618: RAISE fnd_api.g_exc_unexpected_error;

Line 615: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);

611: IF (l_debug = 1) THEN
612: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
613: END IF;
614: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
615: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
616: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
617: fnd_msg_pub.ADD;
618: RAISE fnd_api.g_exc_unexpected_error;
619: END IF;

Line 616: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);

612: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
613: END IF;
614: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
615: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
616: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
617: fnd_msg_pub.ADD;
618: RAISE fnd_api.g_exc_unexpected_error;
619: END IF;
620: IF l_trolin_rec.secondary_quantity_detailed IS NOT NULL THEN

Line 815: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');

811: IF (l_secondary_uom_qty = -99999) THEN
812: IF (l_debug = 1) THEN
813: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
814: END IF;
815: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
816: fnd_message.set_token('VALUE1', l_troldt_tbl(l_counter).secondary_uom_code);
817: fnd_message.set_token('VALUE2', l_transaction_uom);
818: fnd_msg_pub.ADD;
819: RAISE fnd_api.g_exc_unexpected_error;

Line 816: fnd_message.set_token('VALUE1', l_troldt_tbl(l_counter).secondary_uom_code);

812: IF (l_debug = 1) THEN
813: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
814: END IF;
815: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
816: fnd_message.set_token('VALUE1', l_troldt_tbl(l_counter).secondary_uom_code);
817: fnd_message.set_token('VALUE2', l_transaction_uom);
818: fnd_msg_pub.ADD;
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;

Line 817: fnd_message.set_token('VALUE2', l_transaction_uom);

813: DEBUG('Cannot convert uom to secondary uom', 'UPDATE TROLNDT ');
814: END IF;
815: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
816: fnd_message.set_token('VALUE1', l_troldt_tbl(l_counter).secondary_uom_code);
817: fnd_message.set_token('VALUE2', l_transaction_uom);
818: fnd_msg_pub.ADD;
819: RAISE fnd_api.g_exc_unexpected_error;
820: END IF;
821: IF l_secondary_uom_qty < 0 THEN

Line 1377: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');

1373: IF (l_trolin_rec.secondary_quantity = -99999) THEN
1374: IF (l_debug = 1) THEN
1375: DEBUG('Cannot convert uom to secondary uom', 'Inv_Transfer_Order_PVT.Trolins');
1376: END IF;
1377: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1378: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
1379: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
1380: fnd_msg_pub.ADD;
1381: RAISE fnd_api.g_exc_unexpected_error;

Line 1378: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);

1374: IF (l_debug = 1) THEN
1375: DEBUG('Cannot convert uom to secondary uom', 'Inv_Transfer_Order_PVT.Trolins');
1376: END IF;
1377: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1378: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
1379: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
1380: fnd_msg_pub.ADD;
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;

Line 1379: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);

1375: DEBUG('Cannot convert uom to secondary uom', 'Inv_Transfer_Order_PVT.Trolins');
1376: END IF;
1377: fnd_message.set_name('INV', 'INV_INVALID_UOM_CONV');
1378: fnd_message.set_token('VALUE1', l_old_trolin_rec.secondary_uom);
1379: fnd_message.set_token('VALUE2', l_trolin_rec.uom_code);
1380: fnd_msg_pub.ADD;
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;
1383: END IF;

Line 2689: fnd_message.set_name('INV', 'INV_CANNOT_TRX_CLOSED_MO');

2685: END IF;
2686:
2687: -- Cannot transact a closed move order line
2688: IF l_trolin_rec.line_status = 5 THEN
2689: fnd_message.set_name('INV', 'INV_CANNOT_TRX_CLOSED_MO');
2690: x_return_status := fnd_api.g_ret_sts_error;
2691: RAISE fnd_api.g_exc_error;
2692: END IF;
2693:

Line 2760: fnd_message.set_name('INV', 'INV_CANNOT_OVERPICK_WMS_SO');

2756: DEBUG('Patchset Level I:Overpicking not allowed for WMS orgs', 'Finalize_Pick_Confirm');
2757: END IF;
2758: IF l_wms_org_flag AND l_move_order_type = 3
2759: AND l_trolin_rec.quantity_delivered > l_trolin_rec.quantity THEN
2760: fnd_message.set_name('INV', 'INV_CANNOT_OVERPICK_WMS_SO');
2761: x_return_status := fnd_api.g_ret_sts_error;
2762: RAISE fnd_api.g_exc_error;
2763: END IF;
2764:

Line 2806: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

2802: IF (l_primary_shipping_quantity = -99999) THEN
2803: IF (l_debug = 1) THEN
2804: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2805: END IF;
2806: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2807: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2808: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2809: fnd_msg_pub.ADD;
2810: RAISE fnd_api.g_exc_unexpected_error;

Line 2807: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);

2803: IF (l_debug = 1) THEN
2804: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2805: END IF;
2806: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2807: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2808: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2809: fnd_msg_pub.ADD;
2810: RAISE fnd_api.g_exc_unexpected_error;
2811: END IF;

Line 2808: fnd_message.set_token('ROUTINE', 'Pick Confirm process');

2804: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2805: END IF;
2806: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2807: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2808: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2809: fnd_msg_pub.ADD;
2810: RAISE fnd_api.g_exc_unexpected_error;
2811: END IF;
2812: ELSE

Line 2858: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');

2854: IF (l_curr_mmtt_txn_qty = -99999) THEN
2855: IF (l_debug = 1) THEN
2856: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
2857: END IF;
2858: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2859: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2860: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2861: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2862: fnd_msg_pub.ADD;

Line 2859: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);

2855: IF (l_debug = 1) THEN
2856: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
2857: END IF;
2858: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2859: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2860: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2861: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2862: fnd_msg_pub.ADD;
2863: RAISE fnd_api.g_exc_unexpected_error;

Line 2860: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);

2856: DEBUG('Cannot convert uom of other MMTTs to current transaction_uom uom', 'Finalize_Pick_Confirm');
2857: END IF;
2858: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2859: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2860: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2861: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2862: fnd_msg_pub.ADD;
2863: RAISE fnd_api.g_exc_unexpected_error;
2864: END IF;

Line 2861: fnd_message.set_token('ROUTINE', 'Pick Confirm process');

2857: END IF;
2858: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2859: fnd_message.set_token('UOM1', l_curr_mmtt_txn_uom);
2860: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2861: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2862: fnd_msg_pub.ADD;
2863: RAISE fnd_api.g_exc_unexpected_error;
2864: END IF;
2865: END IF;

Line 2916: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');

2912: IF (g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_quantity = -99999) THEN
2913: IF (l_debug = 1) THEN
2914: DEBUG('Cannot convert uom of cached qty to current transaction_uom ', 'Finalize_Pick_Confirm');
2915: END IF;
2916: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2917: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom );
2918: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2919: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2920: fnd_msg_pub.ADD;

Line 2917: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom );

2913: IF (l_debug = 1) THEN
2914: DEBUG('Cannot convert uom of cached qty to current transaction_uom ', 'Finalize_Pick_Confirm');
2915: END IF;
2916: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2917: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom );
2918: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2919: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2920: fnd_msg_pub.ADD;
2921: RAISE fnd_api.g_exc_unexpected_error;

Line 2918: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);

2914: DEBUG('Cannot convert uom of cached qty to current transaction_uom ', 'Finalize_Pick_Confirm');
2915: END IF;
2916: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2917: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom );
2918: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2919: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2920: fnd_msg_pub.ADD;
2921: RAISE fnd_api.g_exc_unexpected_error;
2922: END IF;

Line 2919: fnd_message.set_token('ROUTINE', 'Pick Confirm process');

2915: END IF;
2916: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2917: fnd_message.set_token('UOM1', g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom );
2918: fnd_message.set_token('UOM2', l_mmtt_rec.transaction_uom);
2919: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2920: fnd_msg_pub.ADD;
2921: RAISE fnd_api.g_exc_unexpected_error;
2922: END IF;
2923: g_mo_picked_quantity_tbl(l_trolin_rec.line_id).picked_uom := l_mmtt_rec.transaction_uom ;

Line 2978: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

2974: IF (l_primary_pending_quantity = -99999) THEN
2975: IF (l_debug = 1) THEN
2976: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2977: END IF;
2978: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2979: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2980: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2981: fnd_msg_pub.ADD;
2982: RAISE fnd_api.g_exc_unexpected_error;

Line 2979: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);

2975: IF (l_debug = 1) THEN
2976: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2977: END IF;
2978: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2979: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2980: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2981: fnd_msg_pub.ADD;
2982: RAISE fnd_api.g_exc_unexpected_error;
2983: END IF;

Line 2980: fnd_message.set_token('ROUTINE', 'Pick Confirm process');

2976: DEBUG('Cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
2977: END IF;
2978: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
2979: fnd_message.set_token('UOM', l_mtl_reservation_rec.primary_uom_code);
2980: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
2981: fnd_msg_pub.ADD;
2982: RAISE fnd_api.g_exc_unexpected_error;
2983: END IF;
2984: ELSE

Line 3071: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');

3067: IF (l_unalloc_quantity = -99999) THEN
3068: IF (l_debug = 1) THEN
3069: DEBUG('Calculating unalloc qty: cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3070: END IF;
3071: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3072: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);
3073: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3074: fnd_msg_pub.ADD;
3075: RAISE fnd_api.g_exc_unexpected_error;

Line 3072: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);

3068: IF (l_debug = 1) THEN
3069: DEBUG('Calculating unalloc qty: cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3070: END IF;
3071: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3072: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);
3073: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3074: fnd_msg_pub.ADD;
3075: RAISE fnd_api.g_exc_unexpected_error;
3076: END IF;

Line 3073: fnd_message.set_token('ROUTINE', 'Pick Confirm process');

3069: DEBUG('Calculating unalloc qty: cannot convert uom to primary uom', 'Finalize_Pick_Confirm');
3070: END IF;
3071: fnd_message.set_name('INV', 'INV-CANNOT CONVERT');
3072: fnd_message.set_token('UOM', l_mmtt_rec.item_primary_uom_code);
3073: fnd_message.set_token('ROUTINE', 'Pick Confirm process');
3074: fnd_msg_pub.ADD;
3075: RAISE fnd_api.g_exc_unexpected_error;
3076: END IF;
3077: END IF; -- if UOM code not primary UOM

Line 3110: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');

3106: IF (l_debug = 1) THEN
3107: DEBUG('Error from wip_picking_pub.unallocate_material', 'Finalize_Pick_Confirm');
3108: DEBUG('Unable to lock the work order line for update', 'Finalize_Pick_Confirm');
3109: END IF;
3110: fnd_message.set_name('INV', 'INV_WIP_WORK_ORDER_LOCKED');
3111: fnd_msg_pub.ADD;
3112: RAISE fnd_api.g_exc_error;
3113: ELSIF l_return_status <> fnd_api.g_ret_sts_success THEN
3114: IF (l_debug = 1) THEN

Line 4261: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');

4257: AND WDD.released_status = 'S'
4258: FOR UPDATE NOWAIT;
4259: EXCEPTION
4260: WHEN NO_DATA_FOUND THEN
4261: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');
4262: fnd_msg_pub.ADD;
4263: RAISE fnd_api.g_exc_error;
4264: WHEN OTHERS THEN
4265: --could not lock row

Line 4267: fnd_message.set_name('INV', 'INV_DELIV_INFO_LOCKED');

4263: RAISE fnd_api.g_exc_error;
4264: WHEN OTHERS THEN
4265: --could not lock row
4266: IF SQLCODE = -54 THEN
4267: fnd_message.set_name('INV', 'INV_DELIV_INFO_LOCKED');
4268: fnd_message.set_token('LINEID', l_trolin_rec.line_id);
4269: fnd_msg_pub.ADD;
4270: RAISE fnd_api.g_exc_error;
4271: ELSE

Line 4268: fnd_message.set_token('LINEID', l_trolin_rec.line_id);

4264: WHEN OTHERS THEN
4265: --could not lock row
4266: IF SQLCODE = -54 THEN
4267: fnd_message.set_name('INV', 'INV_DELIV_INFO_LOCKED');
4268: fnd_message.set_token('LINEID', l_trolin_rec.line_id);
4269: fnd_msg_pub.ADD;
4270: RAISE fnd_api.g_exc_error;
4271: ELSE
4272: RAISE fnd_api.g_exc_unexpected_error;

Line 4456: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');

4452: , x_msg_data => x_msg_data
4453: , p_organization_id => l_mmtt_rec.organization_id
4454: , p_inventory_item_id => l_mmtt_rec.inventory_item_id );
4455: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
4456: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
4457: fnd_msg_pub.ADD;
4458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4459: END IF;
4460:

Line 4462: fnd_message.set_name('INV', 'WMS_CATCH_WEIGHT_NO_LPN_ERR');

4458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4459: END IF;
4460:
4461: IF (l_catch_weight_enabled = WMS_CATCH_WEIGHT_PVT.G_PRICE_SECONDARY AND (NVL(l_lpn_id,-1)<=0)) THEN
4462: fnd_message.set_name('INV', 'WMS_CATCH_WEIGHT_NO_LPN_ERR');
4463: fnd_msg_pub.ADD;
4464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4465: END IF;
4466: