DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_PUB dependencies on FND_MESSAGE

Line 122: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');

118: where organization_id = l_status_rec.organization_id
119: and secondary_inventory_name = l_status_rec.zone_code;
120:
121: ELSE
122: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
123: FND_MSG_PUB.ADD;
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:

Line 158: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');

154: , last_update_login = l_status_rec.last_update_login
155: where organization_id = l_status_rec.organization_id
156: and inventory_location_id = l_status_rec.locator_id;
157: ELSE
158: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
159: FND_MSG_PUB.ADD;
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:

Line 196: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');

192: where organization_id = l_status_rec.organization_id
193: and inventory_item_id = l_status_rec.inventory_item_id
194: and lot_number = l_status_rec.lot_number;
195: ELSE
196: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:

Line 244: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');

240: and serial_number > l_status_rec.serial_number and
241: serial_number <= l_status_rec.to_serial_number;
242: end if;
243: ELSE
244: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
245: FND_MSG_PUB.ADD;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:

Line 298: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');

294: and nvl(lot_number, '@@@@') = nvl(l_status_rec.lot_number, nvl(lot_number, '@@@@'))
295: and nvl(locator_id, -9999) = nvl(l_status_rec.locator_id, nvl(locator_id, -9999))
296: and nvl(lpn_id, -9999) = nvl(l_status_rec.lpn_id, -9999);
297: ELSE
298: FND_MESSAGE.SET_NAME('INV', 'INV_STATUS_UPD_RESV_FAIL');
299: FND_MSG_PUB.ADD;
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:

Line 321: FND_MESSAGE.SET_NAME('INV', 'INV_ZERO_ONHAND');

317: if ((sql%notfound) AND p_object_type <> 'Q') THEN
318: /*Bug#15939164 Added the below code to give a warning message when there exists no onhand to be updated*/
319: IF (p_object_type = 'H') THEN
320: --Dbms_Output.put_line ('before error');
321: FND_MESSAGE.SET_NAME('INV', 'INV_ZERO_ONHAND');
322: FND_MSG_PUB.ADD;
323: x_return_status := g_ret_sts_warning;
324: RETURN;
325: ELSE