DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on FND_MESSAGE

Line 122: fnd_message.set_name('INV', 'INV_ERES_ENABLED');

118: IF (l_debug = 1) THEN
119: inv_log_util.TRACE('** Function TRANS_ERES_ENABLED - raised when Others', 'INV_LPN_TRX_PUB', 9);
120: END IF;
121:
122: fnd_message.set_name('INV', 'INV_ERES_ENABLED');
123: fnd_msg_pub.ADD;
124: RAISE fnd_api.g_exc_error;
125: RETURN FALSE;
126: END trans_eres_enabled;

Line 161: fnd_message.set_name('BOM', 'CST_SNAPSHOT_FAILED');

157: err_num => l_errNum,
158: err_code => l_errCode,
159: err_msg => l_errMsg);
160: IF(l_cst_ret <> 1) THEN
161: fnd_message.set_name('BOM', 'CST_SNAPSHOT_FAILED');
162: fnd_msg_pub.ADD;
163: IF (l_debug = 1) THEN
164: inv_log_util.TRACE('INVTRXWB: Error from CSTACOSN.op_snapshot ','INVTRXWB',1);
165: END IF;

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

224: inv_convert.inv_um_convert(v_mmtt_rec.inventory_item_id, 6, abs(v_mmtt_rec.transaction_quantity), v_mmtt_rec.transaction_uom
225: , l_temp_uom_code, NULL, NULL);
226:
227: IF (v_mmtt_rec.primary_quantity = -99999) THEN --Changed from '<=' bug 3984746
228: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
229: fnd_message.set_token('uom1', v_mmtt_rec.transaction_uom);
230: fnd_message.set_token('uom2', l_temp_uom_code);
231: fnd_message.set_token('module', 'INSERT_LINE_TRX');
232: fnd_msg_pub.ADD;

Line 229: fnd_message.set_token('uom1', v_mmtt_rec.transaction_uom);

225: , l_temp_uom_code, NULL, NULL);
226:
227: IF (v_mmtt_rec.primary_quantity = -99999) THEN --Changed from '<=' bug 3984746
228: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
229: fnd_message.set_token('uom1', v_mmtt_rec.transaction_uom);
230: fnd_message.set_token('uom2', l_temp_uom_code);
231: fnd_message.set_token('module', 'INSERT_LINE_TRX');
232: fnd_msg_pub.ADD;
233: RAISE fnd_api.g_exc_error;

Line 230: fnd_message.set_token('uom2', l_temp_uom_code);

226:
227: IF (v_mmtt_rec.primary_quantity = -99999) THEN --Changed from '<=' bug 3984746
228: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
229: fnd_message.set_token('uom1', v_mmtt_rec.transaction_uom);
230: fnd_message.set_token('uom2', l_temp_uom_code);
231: fnd_message.set_token('module', 'INSERT_LINE_TRX');
232: fnd_msg_pub.ADD;
233: RAISE fnd_api.g_exc_error;
234: END IF;

Line 231: fnd_message.set_token('module', 'INSERT_LINE_TRX');

227: IF (v_mmtt_rec.primary_quantity = -99999) THEN --Changed from '<=' bug 3984746
228: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
229: fnd_message.set_token('uom1', v_mmtt_rec.transaction_uom);
230: fnd_message.set_token('uom2', l_temp_uom_code);
231: fnd_message.set_token('module', 'INSERT_LINE_TRX');
232: fnd_msg_pub.ADD;
233: RAISE fnd_api.g_exc_error;
234: END IF;
235:

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

486:
487: l_primary_qty := inv_convert.inv_um_convert(curlpnrec.content_item_id, 6, curlpnrec.quantity, curlpnrec.uom, l_primary_uom, NULL, NULL);
488:
489: IF (l_primary_qty <= -99999) THEN
490: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
491: fnd_message.set_token('uom1', curlpnrec.uom);
492: fnd_message.set_token('uom2', l_primary_uom);
493: fnd_message.set_token('module', 'INSERT_LOT_TRX');
494: fnd_msg_pub.ADD;

Line 491: fnd_message.set_token('uom1', curlpnrec.uom);

487: l_primary_qty := inv_convert.inv_um_convert(curlpnrec.content_item_id, 6, curlpnrec.quantity, curlpnrec.uom, l_primary_uom, NULL, NULL);
488:
489: IF (l_primary_qty <= -99999) THEN
490: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
491: fnd_message.set_token('uom1', curlpnrec.uom);
492: fnd_message.set_token('uom2', l_primary_uom);
493: fnd_message.set_token('module', 'INSERT_LOT_TRX');
494: fnd_msg_pub.ADD;
495: RAISE fnd_api.g_exc_error;

Line 492: fnd_message.set_token('uom2', l_primary_uom);

488:
489: IF (l_primary_qty <= -99999) THEN
490: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
491: fnd_message.set_token('uom1', curlpnrec.uom);
492: fnd_message.set_token('uom2', l_primary_uom);
493: fnd_message.set_token('module', 'INSERT_LOT_TRX');
494: fnd_msg_pub.ADD;
495: RAISE fnd_api.g_exc_error;
496: END IF;

Line 493: fnd_message.set_token('module', 'INSERT_LOT_TRX');

489: IF (l_primary_qty <= -99999) THEN
490: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
491: fnd_message.set_token('uom1', curlpnrec.uom);
492: fnd_message.set_token('uom2', l_primary_uom);
493: fnd_message.set_token('module', 'INSERT_LOT_TRX');
494: fnd_msg_pub.ADD;
495: RAISE fnd_api.g_exc_error;
496: END IF;
497:

Line 517: fnd_message.set_name('INV', 'INV_FAILED');

513: IF (l_debug = 1) THEN
514: inv_log_util.TRACE('**Error from insertLot :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
515: END IF;
516:
517: fnd_message.set_name('INV', 'INV_FAILED');
518: fnd_msg_pub.ADD;
519: RAISE fnd_api.g_exc_error;
520: END IF;
521:

Line 546: fnd_message.set_name('INV', 'INV_FAILED');

542: IF (l_debug = 1) THEN
543: inv_log_util.TRACE('**Error from insertSerial :' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
544: END IF;
545:
546: fnd_message.set_name('INV', 'INV_FAILED');
547: fnd_msg_pub.ADD;
548: RAISE fnd_api.g_exc_error;
549: END IF;
550:

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

567: , p_uom2
568: , NULL
569: , NULL);
570: IF ( l_converted_qty = -99999 ) THEN
571: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
572: fnd_message.set_token('uom1', p_uom1);
573: fnd_message.set_token('uom2', p_uom2);
574: fnd_message.set_token('module', 'GET_CONVERTED_QTY');
575: fnd_msg_pub.ADD;

Line 572: fnd_message.set_token('uom1', p_uom1);

568: , NULL
569: , NULL);
570: IF ( l_converted_qty = -99999 ) THEN
571: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
572: fnd_message.set_token('uom1', p_uom1);
573: fnd_message.set_token('uom2', p_uom2);
574: fnd_message.set_token('module', 'GET_CONVERTED_QTY');
575: fnd_msg_pub.ADD;
576: RAISE fnd_api.g_exc_error;

Line 573: fnd_message.set_token('uom2', p_uom2);

569: , NULL);
570: IF ( l_converted_qty = -99999 ) THEN
571: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
572: fnd_message.set_token('uom1', p_uom1);
573: fnd_message.set_token('uom2', p_uom2);
574: fnd_message.set_token('module', 'GET_CONVERTED_QTY');
575: fnd_msg_pub.ADD;
576: RAISE fnd_api.g_exc_error;
577: END IF;

Line 574: fnd_message.set_token('module', 'GET_CONVERTED_QTY');

570: IF ( l_converted_qty = -99999 ) THEN
571: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
572: fnd_message.set_token('uom1', p_uom1);
573: fnd_message.set_token('uom2', p_uom2);
574: fnd_message.set_token('module', 'GET_CONVERTED_QTY');
575: fnd_msg_pub.ADD;
576: RAISE fnd_api.g_exc_error;
577: END IF;
578:

Line 702: fnd_message.set_name('INV', 'INV_NO_RECORDS');

698: inv_log_util.TRACE('From MTI, try update MTI batch and seq rowcount='||sql%rowcount, 'INV_LPN_TRX_PUB', 9);
699: END IF;
700:
701: IF ( sql%rowcount = 0 ) THEN
702: fnd_message.set_name('INV', 'INV_NO_RECORDS');
703: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');
704: fnd_msg_pub.ADD;
705: RAISE fnd_api.g_exc_error;
706: END IF;

Line 703: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');

699: END IF;
700:
701: IF ( sql%rowcount = 0 ) THEN
702: fnd_message.set_name('INV', 'INV_NO_RECORDS');
703: fnd_message.set_token('ENTITY', 'MTL_TRANSACTIONS_INTERFACE');
704: fnd_msg_pub.ADD;
705: RAISE fnd_api.g_exc_error;
706: END IF;
707: END IF;

Line 731: fnd_message.set_name('INV', 'INV_INT_XSUBCODE');

727: IF (l_debug = 1) THEN
728: inv_log_util.TRACE('No sub found when checking lpn_controlled_flag', 'INV_LPN_TRX_PUB', 5);
729: END IF;
730:
731: fnd_message.set_name('INV', 'INV_INT_XSUBCODE');
732: fnd_msg_pub.ADD;
733: RAISE fnd_api.g_exc_error;
734: END IF;
735:

Line 924: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');

920: INTO l_cst_grp
921: FROM cst_cost_groups
922: WHERE cost_group_id = NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id);
923:
924: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
925: fnd_message.set_token('CG', l_cst_grp);
926: fnd_msg_pub.ADD;
927: RAISE fnd_api.g_exc_error;
928: END IF;

Line 925: fnd_message.set_token('CG', l_cst_grp);

921: FROM cst_cost_groups
922: WHERE cost_group_id = NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id);
923:
924: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
925: fnd_message.set_token('CG', l_cst_grp);
926: fnd_msg_pub.ADD;
927: RAISE fnd_api.g_exc_error;
928: END IF;
929: END IF;

Line 1039: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');

1035: INTO l_cst_grp
1036: FROM cst_cost_groups
1037: WHERE cost_group_id = NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id);
1038:
1039: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
1040: fnd_message.set_token('CG', l_cst_grp);
1041: fnd_msg_pub.ADD;
1042: RAISE fnd_api.g_exc_error;
1043: END IF;

Line 1040: fnd_message.set_token('CG', l_cst_grp);

1036: FROM cst_cost_groups
1037: WHERE cost_group_id = NVL(curlpnrec.cost_group_id, p_mmtt.cost_group_id);
1038:
1039: fnd_message.set_name('INV', 'INV_COMINGLE_FAIL');
1040: fnd_message.set_token('CG', l_cst_grp);
1041: fnd_msg_pub.ADD;
1042: RAISE fnd_api.g_exc_error;
1043: END IF;
1044: END IF;

Line 1117: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');

1113: IF (l_debug = 1) THEN
1114: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1115: END IF;
1116:
1117: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
1118: fnd_msg_pub.ADD;
1119: RAISE fnd_api.g_exc_error;
1120: END IF;
1121: -- If this is for an OrgXfr transaction, update the cost_group_id

Line 1283: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');

1279: IF (l_debug = 1) THEN
1280: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
1281: END IF;
1282:
1283: fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
1284: fnd_msg_pub.ADD;
1285: RAISE fnd_api.g_exc_error;
1286: END IF;
1287: -- If this is for an OrgXfr transaction, update the cost_group_id

Line 1346: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');

1342: IF (l_debug = 1) THEN
1343: inv_log_util.TRACE('no data found INV_FOB_NOT_DEFINED', 'INV_LPN_TRX_PUB', 1);
1344: END IF;
1345:
1346: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1347: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1348: fnd_msg_pub.ADD;
1349: RAISE fnd_api.g_exc_error;
1350: END;

Line 1347: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);

1343: inv_log_util.TRACE('no data found INV_FOB_NOT_DEFINED', 'INV_LPN_TRX_PUB', 1);
1344: END IF;
1345:
1346: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1347: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1348: fnd_msg_pub.ADD;
1349: RAISE fnd_api.g_exc_error;
1350: END;
1351:

Line 1403: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');

1399: WHEN NO_DATA_FOUND THEN
1400: IF (l_debug = 1) THEN
1401: inv_log_util.TRACE('no data found INV_FOB_NOT_DEFINED', 'INV_LPN_TRX_PUB', 1);
1402: END IF;
1403: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1404: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1405: fnd_msg_pub.ADD;
1406: RAISE fnd_api.g_exc_error;
1407: END;

Line 1404: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);

1400: IF (l_debug = 1) THEN
1401: inv_log_util.TRACE('no data found INV_FOB_NOT_DEFINED', 'INV_LPN_TRX_PUB', 1);
1402: END IF;
1403: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
1404: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
1405: fnd_msg_pub.ADD;
1406: RAISE fnd_api.g_exc_error;
1407: END;
1408: else

Line 1575: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');

1571: , 1
1572: );
1573: END IF;
1574:
1575: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1576: fnd_msg_pub.ADD;
1577: RAISE fnd_api.g_exc_error;
1578: END IF;
1579: ELSE

Line 1706: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');

1702: , 1
1703: );
1704: END IF;
1705:
1706: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1707: fnd_msg_pub.ADD;
1708: RAISE fnd_api.g_exc_error;
1709: END IF;
1710: END LOOP;

Line 1772: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');

1768: , 1
1769: );
1770: END IF;
1771:
1772: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1773: fnd_msg_pub.ADD;
1774: RAISE fnd_api.g_exc_error;
1775: END IF;
1776: END IF;

Line 1885: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');

1881: , 9
1882: );
1883: END IF;
1884:
1885: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1886: fnd_msg_pub.ADD;
1887: RAISE fnd_api.g_exc_error;
1888: END IF;
1889: END LOOP;

Line 1951: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');

1947: , 1
1948: );
1949: END IF;
1950:
1951: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
1952: fnd_msg_pub.ADD;
1953: RAISE fnd_api.g_exc_error;
1954: END IF;
1955: END IF;

Line 1994: fnd_message.set_name('INV', 'INV_LPN_UPDATE_FAILURE');

1990: inv_log_util.TRACE('Error from modify_lpn :' || ret_status, 'INV_LPN_TRX_PUB', 1);
1991: inv_log_util.TRACE('Error msg :' || ret_msgdata || 'msgcnt=' || ret_msgcnt, 'INV_LPN_TRX_PUB', 1);
1992: END IF;
1993:
1994: fnd_message.set_name('INV', 'INV_LPN_UPDATE_FAILURE');
1995: fnd_msg_pub.ADD;
1996: RAISE fnd_api.g_exc_error;
1997: END IF;
1998: END;

Line 2467: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');

2463: IF (l_debug = 1) THEN
2464: inv_log_util.TRACE('Failed MTL_SERIAL_CHECK.Inv_Serial_Info', l_api_name, 1);
2465: END IF;
2466:
2467: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
2468: fnd_msg_pub.ADD;
2469: RAISE fnd_api.g_exc_error;
2470: END IF;
2471:

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

2586: inv_convert.inv_um_convert(p_item_rec.inventory_item_id, 6, l_split_quantity, p_uom_code, dd_rec.requested_quantity_uom, NULL
2587: , NULL);
2588:
2589: IF (l_remaining_quantity < 0) THEN
2590: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2591: fnd_message.set_token('uom1', p_uom_code);
2592: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2593: fnd_message.set_token('module', l_api_name);
2594: fnd_msg_pub.ADD;

Line 2591: fnd_message.set_token('uom1', p_uom_code);

2587: , NULL);
2588:
2589: IF (l_remaining_quantity < 0) THEN
2590: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2591: fnd_message.set_token('uom1', p_uom_code);
2592: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2593: fnd_message.set_token('module', l_api_name);
2594: fnd_msg_pub.ADD;
2595: RAISE fnd_api.g_exc_error;

Line 2592: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);

2588:
2589: IF (l_remaining_quantity < 0) THEN
2590: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2591: fnd_message.set_token('uom1', p_uom_code);
2592: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2593: fnd_message.set_token('module', l_api_name);
2594: fnd_msg_pub.ADD;
2595: RAISE fnd_api.g_exc_error;
2596: END IF;

Line 2593: fnd_message.set_token('module', l_api_name);

2589: IF (l_remaining_quantity < 0) THEN
2590: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2591: fnd_message.set_token('uom1', p_uom_code);
2592: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2593: fnd_message.set_token('module', l_api_name);
2594: fnd_msg_pub.ADD;
2595: RAISE fnd_api.g_exc_error;
2596: END IF;
2597: END IF;

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

2606: inv_convert.inv_um_convert(p_item_rec.inventory_item_id, 6, l_remaining_quantity, l_remaining_qty_uom
2607: , dd_rec.requested_quantity_uom, NULL, NULL);
2608:
2609: IF (l_remaining_quantity < 0) THEN
2610: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2611: fnd_message.set_token('uom1', l_remaining_qty_uom);
2612: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2613: fnd_message.set_token('module', l_api_name);
2614: fnd_msg_pub.ADD;

Line 2611: fnd_message.set_token('uom1', l_remaining_qty_uom);

2607: , dd_rec.requested_quantity_uom, NULL, NULL);
2608:
2609: IF (l_remaining_quantity < 0) THEN
2610: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2611: fnd_message.set_token('uom1', l_remaining_qty_uom);
2612: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2613: fnd_message.set_token('module', l_api_name);
2614: fnd_msg_pub.ADD;
2615: RAISE fnd_api.g_exc_error;

Line 2612: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);

2608:
2609: IF (l_remaining_quantity < 0) THEN
2610: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2611: fnd_message.set_token('uom1', l_remaining_qty_uom);
2612: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2613: fnd_message.set_token('module', l_api_name);
2614: fnd_msg_pub.ADD;
2615: RAISE fnd_api.g_exc_error;
2616: END IF;

Line 2613: fnd_message.set_token('module', l_api_name);

2609: IF (l_remaining_quantity < 0) THEN
2610: fnd_message.set_name('INV', 'INV_UOM_CONVERSION_ERROR');
2611: fnd_message.set_token('uom1', l_remaining_qty_uom);
2612: fnd_message.set_token('uom2', dd_rec.requested_quantity_uom);
2613: fnd_message.set_token('module', l_api_name);
2614: fnd_msg_pub.ADD;
2615: RAISE fnd_api.g_exc_error;
2616: END IF;
2617:

Line 2634: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');

2630: -- secondary quantity and uom for all WDD records for this lpn
2631: l_remaining_quantity2 := 0;
2632: ELSIF(dd_rec.requested_quantity_uom2 <> p_secondary_uom_code) THEN
2633: -- Sanity check to make sure that we are transacting in the same UOM
2634: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2635: fnd_message.set_token('UOM1', p_secondary_uom_code);
2636: fnd_message.set_token('UOM2', dd_rec.requested_quantity_uom2);
2637: fnd_msg_pub.ADD;
2638: RAISE fnd_api.g_exc_unexpected_error;

Line 2635: fnd_message.set_token('UOM1', p_secondary_uom_code);

2631: l_remaining_quantity2 := 0;
2632: ELSIF(dd_rec.requested_quantity_uom2 <> p_secondary_uom_code) THEN
2633: -- Sanity check to make sure that we are transacting in the same UOM
2634: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2635: fnd_message.set_token('UOM1', p_secondary_uom_code);
2636: fnd_message.set_token('UOM2', dd_rec.requested_quantity_uom2);
2637: fnd_msg_pub.ADD;
2638: RAISE fnd_api.g_exc_unexpected_error;
2639: ELSE

Line 2636: fnd_message.set_token('UOM2', dd_rec.requested_quantity_uom2);

2632: ELSIF(dd_rec.requested_quantity_uom2 <> p_secondary_uom_code) THEN
2633: -- Sanity check to make sure that we are transacting in the same UOM
2634: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2635: fnd_message.set_token('UOM1', p_secondary_uom_code);
2636: fnd_message.set_token('UOM2', dd_rec.requested_quantity_uom2);
2637: fnd_msg_pub.ADD;
2638: RAISE fnd_api.g_exc_unexpected_error;
2639: ELSE
2640: -- Everything checks out determine the amount of qty2 to split

Line 2697: fnd_message.set_name('INV', 'INV_SPLIT_LINE_FAILURE');

2693: IF (l_debug = 1) THEN
2694: inv_log_util.TRACE('**Error Delivery_Detail_Action: ' || ret_msgdata, l_api_name, 1);
2695: END IF;
2696:
2697: fnd_message.set_name('INV', 'INV_SPLIT_LINE_FAILURE');
2698: fnd_msg_pub.ADD;
2699: RAISE fnd_api.g_exc_error;
2700: END IF;
2701:

Line 2742: fnd_message.set_name('INV', 'INV_UNASSIGN_DEL_FAILURE');

2738: IF (l_debug = 1) THEN
2739: inv_log_util.TRACE('Error WSH_WMS_LPN_GRP.Delivery_Detail_Action' || ret_status, l_api_name, 1);
2740: END IF;
2741:
2742: fnd_message.set_name('INV', 'INV_UNASSIGN_DEL_FAILURE');
2743: fnd_msg_pub.ADD;
2744: RAISE fnd_api.g_exc_error;
2745: ELSIF (l_debug = 1) THEN
2746: inv_log_util.TRACE('Done with call to WSH Create_Update_Containers', l_api_name, 4);

Line 2778: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');

2774: IF (l_debug = 1) THEN
2775: inv_log_util.TRACE('***Error in update shipping attribures for split trx', l_api_name, 9);
2776: END IF;
2777:
2778: fnd_message.set_name('WMS', 'WMS_TD_UPD_SHP_ERROR');
2779: fnd_msg_pub.ADD;
2780: RAISE fnd_api.g_exc_error;
2781: END IF;
2782:

Line 2814: fnd_message.set_name('WMS', 'UPD_RESERVATION_PUP_FAIL');

2810: IF ( ret_status <> fnd_api.g_ret_sts_success ) THEN
2811: IF (l_debug = 1) THEN
2812: inv_log_util.TRACE('upd_reservation_pup failed '||ret_msgdata, l_api_name, 1);
2813: END IF;
2814: fnd_message.set_name('WMS', 'UPD_RESERVATION_PUP_FAIL');
2815: fnd_msg_pub.ADD;
2816: RAISE fnd_api.g_exc_error;
2817: END IF;
2818: l_progress := 'Done with call to Upd_Reservation_PUP_New';

Line 2837: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');

2833: END LOOP;
2834:
2835: IF (l_remaining_quantity > 0) THEN
2836: inv_log_util.TRACE('***Error while splittng delivery not enough quantity found in wdd', l_api_name, 1);
2837: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');
2838: fnd_msg_pub.ADD;
2839: RAISE fnd_api.g_exc_error;
2840: END IF;
2841:

Line 2893: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');

2889: END IF;
2890:
2891: IF (l_dd_rec.requested_quantity_uom2 <> p_secondary_uom_code) THEN
2892: -- Sanity check to make sure that we are transacting in the same UOM
2893: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2894: fnd_message.set_token('UOM1', p_secondary_uom_code);
2895: fnd_message.set_token('UOM2', l_dd_rec.requested_quantity_uom2);
2896: fnd_msg_pub.ADD;
2897: RAISE fnd_api.g_exc_unexpected_error;

Line 2894: fnd_message.set_token('UOM1', p_secondary_uom_code);

2890:
2891: IF (l_dd_rec.requested_quantity_uom2 <> p_secondary_uom_code) THEN
2892: -- Sanity check to make sure that we are transacting in the same UOM
2893: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2894: fnd_message.set_token('UOM1', p_secondary_uom_code);
2895: fnd_message.set_token('UOM2', l_dd_rec.requested_quantity_uom2);
2896: fnd_msg_pub.ADD;
2897: RAISE fnd_api.g_exc_unexpected_error;
2898: ELSIF(l_dd_rec.picked_quantity2 > qty2_remainder) THEN

Line 2895: fnd_message.set_token('UOM2', l_dd_rec.requested_quantity_uom2);

2891: IF (l_dd_rec.requested_quantity_uom2 <> p_secondary_uom_code) THEN
2892: -- Sanity check to make sure that we are transacting in the same UOM
2893: fnd_message.set_name('WMS', 'WMS_SEC_UOM_MISMATCH_ERROR');
2894: fnd_message.set_token('UOM1', p_secondary_uom_code);
2895: fnd_message.set_token('UOM2', l_dd_rec.requested_quantity_uom2);
2896: fnd_msg_pub.ADD;
2897: RAISE fnd_api.g_exc_unexpected_error;
2898: ELSIF(l_dd_rec.picked_quantity2 > qty2_remainder) THEN
2899: -- This WDD record can consume the entire remaining qty. subtract that

Line 2926: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');

2922: END LOOP;
2923:
2924: IF (qty2_remainder <> 0) THEN
2925: inv_log_util.TRACE('***Error while splittng delivery not enough quantity2 found in wdd', l_api_name, 9);
2926: fnd_message.set_name('WMS', 'INV_INSUFFICIENT_WDD_QTY');
2927: fnd_msg_pub.ADD;
2928: RAISE fnd_api.g_exc_error;
2929: END IF;
2930: ELSIF(l_debug = 1) THEN

Line 2971: fnd_message.set_name('WMS', 'WMS_UPD_DELIVERY_ERROR');

2967: IF (l_debug = 1) THEN
2968: inv_log_util.TRACE('Error calling Create_Update_Delivery_Detail: ' || ret_msgdata, l_api_name, 1);
2969: END IF;
2970:
2971: fnd_message.set_name('WMS', 'WMS_UPD_DELIVERY_ERROR');
2972: fnd_message.set_token('MSG1', ret_msgdata);
2973: fnd_msg_pub.ADD;
2974: RAISE fnd_api.g_exc_unexpected_error;
2975: END IF;

Line 2972: fnd_message.set_token('MSG1', ret_msgdata);

2968: inv_log_util.TRACE('Error calling Create_Update_Delivery_Detail: ' || ret_msgdata, l_api_name, 1);
2969: END IF;
2970:
2971: fnd_message.set_name('WMS', 'WMS_UPD_DELIVERY_ERROR');
2972: fnd_message.set_token('MSG1', ret_msgdata);
2973: fnd_msg_pub.ADD;
2974: RAISE fnd_api.g_exc_unexpected_error;
2975: END IF;
2976: END IF;

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

3026: , p_inventory_item_id => p_item_rec.inventory_item_id
3027: );
3028:
3029: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3030: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3031: fnd_msg_pub.ADD;
3032: RAISE fnd_api.g_exc_unexpected_error;
3033: END IF;
3034:

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

3052: , x_show_ct_wt => l_valid_sec_qty_split
3053: );
3054:
3055: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3056: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3057: fnd_msg_pub.ADD;
3058: RAISE fnd_api.g_exc_unexpected_error;
3059: END IF;
3060:

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

3167: , x_show_ct_wt => l_valid_sec_qty_split
3168: );
3169:
3170: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3171: fnd_message.set_name('INV', 'WMS_GET_CATCH_WEIGHT_ATT_FAIL');
3172: fnd_msg_pub.ADD;
3173: RAISE fnd_api.g_exc_unexpected_error;
3174: END IF;
3175:

Line 3831: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');

3827: v_mmtt.transaction_source_type_id = inv_globals.g_sourcetype_salesorder
3828: AND v_mmtt.transaction_action_id = inv_globals.g_action_logicalissue
3829: )
3830: ) THEN
3831: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
3832: fnd_msg_pub.ADD;
3833: RAISE fnd_api.g_exc_error;
3834: END IF;
3835:

Line 3964: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');

3960: IF (l_debug = 1) THEN
3961: inv_log_util.TRACE(' Error from update_fob_point:' || l_fob_ret_msg, 'INV_LPN_TRX_PUB', 1);
3962: END IF;
3963:
3964: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
3965: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
3966: fnd_msg_pub.ADD;
3967: RAISE fnd_api.g_exc_error;
3968: END IF;

Line 3965: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);

3961: inv_log_util.TRACE(' Error from update_fob_point:' || l_fob_ret_msg, 'INV_LPN_TRX_PUB', 1);
3962: END IF;
3963:
3964: fnd_message.set_name('INV', 'INV_FOB_NOT_DEFINED');
3965: fnd_message.set_token('ENTITY1', v_mmtt.organization_id);
3966: fnd_msg_pub.ADD;
3967: RAISE fnd_api.g_exc_error;
3968: END IF;
3969: END IF;

Line 4025: --fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');

4021: inv_log_util.TRACE(' Error from CostGrpAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4022: END IF;
4023: --Bug 3804314: The message from the cost group API is
4024: --overwritten by INV_COST_GROUP_FAILURE. Commenting the message.
4025: --fnd_message.set_name('INV', 'INV_COST_GROUP_FAILURE');
4026: --fnd_msg_pub.ADD;
4027: RAISE fnd_api.g_exc_error;
4028: END IF;
4029: END IF;

Line 4043: fnd_message.set_name(application => 'INV', NAME => 'INV_SUBMIT_FAIL');

4039: COMMIT; -- Need to commit for the request to be submitted
4040:
4041: IF (l_req_id = 0) THEN
4042: -- display error message
4043: fnd_message.set_name(application => 'INV', NAME => 'INV_SUBMIT_FAIL');
4044: fnd_message.set_token(token => 'TOKEN', VALUE => TO_CHAR(p_trx_hdr_id), TRANSLATE => FALSE);
4045: fnd_msg_pub.ADD;
4046: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4047: RETURN -1;

Line 4044: fnd_message.set_token(token => 'TOKEN', VALUE => TO_CHAR(p_trx_hdr_id), TRANSLATE => FALSE);

4040:
4041: IF (l_req_id = 0) THEN
4042: -- display error message
4043: fnd_message.set_name(application => 'INV', NAME => 'INV_SUBMIT_FAIL');
4044: fnd_message.set_token(token => 'TOKEN', VALUE => TO_CHAR(p_trx_hdr_id), TRANSLATE => FALSE);
4045: fnd_msg_pub.ADD;
4046: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4047: RETURN -1;
4048: ELSE

Line 4050: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');

4046: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4047: RETURN -1;
4048: ELSE
4049: -- display request ID
4050: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');
4051: fnd_message.set_token(token => 'REQUEST_ID', VALUE => TO_CHAR(l_req_id), TRANSLATE => FALSE);
4052: fnd_msg_pub.ADD;
4053: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4054:

Line 4051: fnd_message.set_token(token => 'REQUEST_ID', VALUE => TO_CHAR(l_req_id), TRANSLATE => FALSE);

4047: RETURN -1;
4048: ELSE
4049: -- display request ID
4050: fnd_message.set_name(application => 'INV', NAME => 'INV_CONC_TRANSACT');
4051: fnd_message.set_token(token => 'REQUEST_ID', VALUE => TO_CHAR(l_req_id), TRANSLATE => FALSE);
4052: fnd_msg_pub.ADD;
4053: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4054:
4055: IF (l_debug = 1) THEN

Line 4072: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');

4068: UPDATE mtl_material_transactions_temp
4069: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd
4070: WHERE transaction_header_id = p_trx_hdr_id;
4071:
4072: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');
4073: fnd_msg_pub.ADD;
4074: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4075:
4076: IF fnd_api.to_boolean(p_commit) THEN

Line 4165: fnd_message.set_name('INV', 'INV_FAILED');

4161: IF (l_debug = 1) THEN
4162: inv_log_util.TRACE(' Failed in EXPLODE_AND_INSERT!!', 'INV_LPN_TRX_PUB', 1);
4163: END IF;
4164:
4165: fnd_message.set_name('INV', 'INV_FAILED');
4166: fnd_msg_pub.ADD;
4167: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4168: RETURN -1;
4169: END IF;

Line 4558: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');

4554: IF (l_debug = 1) THEN
4555: inv_log_util.TRACE(' ERROR generated from getErecordIdAPI:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4556: END IF;
4557:
4558: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');
4559: fnd_msg_pub.ADD;
4560: RAISE fnd_api.g_exc_error;
4561: END IF;
4562:

Line 4586: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');

4582: IF (l_debug = 1) THEN
4583: inv_log_util.TRACE(' Error from Send ERES ACKNOWLEDGE API:' || ret_msgdata, 'INV_LPN_TRX_PUB', 1);
4584: END IF;
4585:
4586: fnd_message.set_name('INV', 'INV_ERECORD_INVALID');
4587: fnd_msg_pub.ADD;
4588: RAISE fnd_api.g_exc_error;
4589: END IF;
4590: END IF; /* IF ERECORD ID not NULL */

Line 4619: fnd_message.set_name('WMS', 'WMS_TXN_SUCCESS');

4615: --
4616: -- HVERDDIN END OF ERES CHANGES
4617: --
4618:
4619: fnd_message.set_name('WMS', 'WMS_TXN_SUCCESS');
4620: fnd_msg_pub.ADD;
4621: x_proc_msg := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4622: RETURN 0;
4623: EXCEPTION

Line 4655: fnd_message.set_name('INV', 'INV_INT_PROCCODE');

4651: END LOOP;
4652:
4653: x_proc_msg := SUBSTR(l_err_msg, 1, 170);
4654: -- Update MMTT with error_code
4655: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
4656: fnd_msg_pub.ADD;
4657: l_error_code := fnd_msg_pub.get(fnd_msg_pub.g_last, 'F');
4658:
4659: BEGIN

Line 5219: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');

5215: IF (l_debug = 1) THEN
5216: inv_log_util.TRACE('**Error Full unpack for wip issue:' || ret_status, 'INV_LPN_TRX_PUB', 1);
5217: END IF;
5218:
5219: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
5220: fnd_msg_pub.ADD;
5221: RAISE fnd_api.g_exc_error;
5222: END IF;
5223: ELSE

Line 5813: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');

5809: IF (l_debug = 1) THEN
5810: inv_log_util.TRACE('**Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
5811: END IF;
5812:
5813: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
5814: fnd_msg_pub.ADD;
5815: RAISE fnd_api.g_exc_error;
5816: END IF;
5817: END IF;

Line 5842: fnd_message.set_name('INV', 'BAD_INPUT_ARGUMENTS');

5838: inv_log_util.TRACE('Error. Cost Groups not specified. CG=' || p_cost_group_id || ',XfrCG=' || p_transfer_cost_group_id
5839: , 'INV_LPN_TRX_PUB', 1);
5840: END IF;
5841:
5842: fnd_message.set_name('INV', 'BAD_INPUT_ARGUMENTS');
5843: fnd_msg_pub.ADD;
5844: RAISE fnd_api.g_exc_error;
5845: END IF;
5846: END IF;

Line 5906: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');

5902: IF (l_debug = 1) THEN
5903: inv_log_util.TRACE('Error. Invalid LPN context for Transfer Trx:' || v_lpn_ctx, 'INV_LPN_TRX_PUB', 1);
5904: END IF;
5905:
5906: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
5907: fnd_msg_pub.ADD;
5908: RAISE fnd_api.g_exc_error;
5909: END IF;
5910:

Line 6136: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');

6132: IF (l_debug = 1) THEN
6133: inv_log_util.TRACE('**Error Full unpack :' || ret_status, 'INV_LPN_TRX_PUB', 1);
6134: END IF;
6135:
6136: fnd_message.set_name('INV', 'INV_PACKUNPACK_FAILURE');
6137: fnd_msg_pub.ADD;
6138: RAISE fnd_api.g_exc_error;
6139: END IF;
6140: ELSE

Line 6242: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');

6238: IF (l_debug = 1) THEN
6239: inv_log_util.TRACE('Error. Invalid LPN context for XFR_LPN :' || v_xfrlpn_ctx, 'INV_LPN_TRX_PUB', 1);
6240: END IF;
6241:
6242: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
6243: fnd_msg_pub.ADD;
6244: RAISE fnd_api.g_exc_error;
6245: END IF;
6246:

Line 6372: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');

6368: IF (l_debug = 1) THEN
6369: inv_log_util.TRACE('Error. Invalid LPN context for XFR_LPN :' || v_xfrlpn_ctx, 'INV_LPN_TRX_PUB', 1);
6370: END IF;
6371:
6372: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
6373: fnd_msg_pub.ADD;
6374: RAISE fnd_api.g_exc_error;
6375: END IF;
6376: END IF;

Line 6426: fnd_message.set_name('INV', 'INV_XFR_RSV_FAILURE');

6422: IF (l_debug = 1) THEN
6423: inv_log_util.TRACE('**Error from transfer_lpn_trx_reservation :' || ret_status, 'INV_LPN_TRX_PUB', 1);
6424: END IF;
6425:
6426: fnd_message.set_name('INV', 'INV_XFR_RSV_FAILURE');
6427: fnd_msg_pub.ADD;
6428: RAISE fnd_api.g_exc_error;
6429: END IF;
6430: END IF;