eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_VALIDATE_TROLIN dependencies on FND_MESSAGE

Line 20: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

16: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
17: BEGIN
18: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN
19: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
20: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
21: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_ID'),FALSE); -- ND
22: FND_MSG_PUB.Add;
23: END IF;
24: RETURN F;

Line 21: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_ID'),FALSE); -- ND

17: BEGIN
18: IF p_line_id IS NULL OR p_line_id = FND_API.G_MISS_NUM THEN
19: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
20: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
21: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_ID'),FALSE); -- ND
22: FND_MSG_PUB.Add;
23: END IF;
24: RETURN F;
25: END IF;

Line 41: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

37: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
38: BEGIN
39: IF p_line_number IS NULL OR p_line_number = FND_API.G_MISS_NUM THEN
40: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
41: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
42: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_NUMBER'),FALSE); -- ND
43: FND_MSG_PUB.Add;
44: END IF;
45: RETURN F;

Line 42: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_NUMBER'),FALSE); -- ND

38: BEGIN
39: IF p_line_number IS NULL OR p_line_number = FND_API.G_MISS_NUM THEN
40: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
41: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
42: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_NUMBER'),FALSE); -- ND
43: FND_MSG_PUB.Add;
44: END IF;
45: RETURN F;
46: END IF;

Line 56: FND_MESSAGE.SET_NAME('INV','INV_ALREADY_EXISTS');

52: RETURN T;
53: ELSE
54: --Bug #4347016
55: --If the line number is not unique display an error message
56: FND_MESSAGE.SET_NAME('INV','INV_ALREADY_EXISTS');
57: FND_MESSAGE.SET_TOKEN('ENTITY',FND_MESSAGE.GET_STRING('INV','INV_LINE_NUMBER'),FALSE);
58: FND_MSG_PUB.Add;
59: RETURN F;
60: END IF;

Line 57: FND_MESSAGE.SET_TOKEN('ENTITY',FND_MESSAGE.GET_STRING('INV','INV_LINE_NUMBER'),FALSE);

53: ELSE
54: --Bug #4347016
55: --If the line number is not unique display an error message
56: FND_MESSAGE.SET_NAME('INV','INV_ALREADY_EXISTS');
57: FND_MESSAGE.SET_TOKEN('ENTITY',FND_MESSAGE.GET_STRING('INV','INV_LINE_NUMBER'),FALSE);
58: FND_MSG_PUB.Add;
59: RETURN F;
60: END IF;
61:

Line 66: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');

62: EXCEPTION
63: WHEN NO_DATA_FOUND THEN
64: --inv_debug.message('in when no_data_found');
65: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
66: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
67: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','LINE_NUMBER'),FALSE);
68: FND_MSG_PUB.Add;
69: END IF;
70: RETURN F;

Line 67: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','LINE_NUMBER'),FALSE);

63: WHEN NO_DATA_FOUND THEN
64: --inv_debug.message('in when no_data_found');
65: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
66: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
67: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','LINE_NUMBER'),FALSE);
68: FND_MSG_PUB.Add;
69: END IF;
70: RETURN F;
71: WHEN OTHERS THEN

Line 91: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

87: BEGIN
88:
89: IF p_line_status IS NULL OR p_line_status = FND_API.G_MISS_NUM THEN
90: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
92: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_STATUS'),FALSE); -- ND
93: FND_MSG_PUB.Add;
94: END IF;
95: RETURN F;

Line 92: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_STATUS'),FALSE); -- ND

88:
89: IF p_line_status IS NULL OR p_line_status = FND_API.G_MISS_NUM THEN
90: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
91: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
92: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_STATUS'),FALSE); -- ND
93: FND_MSG_PUB.Add;
94: END IF;
95: RETURN F;
96: END IF;

Line 111: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');

107: EXCEPTION
108:
109: WHEN NO_DATA_FOUND THEN
110: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
111: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_STATUS'),FALSE);
113: FND_MSG_PUB.Add;
114: END IF;
115: RETURN F;

Line 112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_STATUS'),FALSE);

108:
109: WHEN NO_DATA_FOUND THEN
110: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
111: FND_MESSAGE.SET_NAME('INV','INV_INVALID_ATTRIBUTE');
112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_LINE_STATUS'),FALSE);
113: FND_MSG_PUB.Add;
114: END IF;
115: RETURN F;
116:

Line 222: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

218: -- Check required attributes.
219: IF p_trolin_rec.line_id IS NULL THEN
220: l_return_status := FND_API.G_RET_STS_ERROR;
221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
222: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id');
224: FND_MSG_PUB.Add;
225: END IF;
226: END IF;

Line 223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id');

219: IF p_trolin_rec.line_id IS NULL THEN
220: l_return_status := FND_API.G_RET_STS_ERROR;
221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
222: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_id');
224: FND_MSG_PUB.Add;
225: END IF;
226: END IF;
227:

Line 231: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

227:
228: IF p_trolin_rec.header_id IS NULL THEN
229: l_return_status := FND_API.G_RET_STS_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header_Id');
233: FND_MSG_PUB.Add;
234: END IF;
235: END IF;

Line 232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header_Id');

228: IF p_trolin_rec.header_id IS NULL THEN
229: l_return_status := FND_API.G_RET_STS_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
231: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Header_Id');
233: FND_MSG_PUB.Add;
234: END IF;
235: END IF;
236: --

Line 245: FND_MESSAGE.SET_NAME('INV','INV_ENTER_ITEM');

241: if( p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then
242: l_return_status := FND_API.G_RET_STS_ERROR;
243:
244: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
245: FND_MESSAGE.SET_NAME('INV','INV_ENTER_ITEM');
246: FND_MSG_PUB.Add;
247: END IF;
248: elsif( p_move_order_type = INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY AND p_trolin_rec.lpn_id is NULL) then
249: l_return_status := FND_API.G_RET_STS_ERROR;

Line 251: FND_MESSAGE.SET_NAME('INV', 'INV_ENTER_ITEM_LPN');

247: END IF;
248: elsif( p_move_order_type = INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY AND p_trolin_rec.lpn_id is NULL) then
249: l_return_status := FND_API.G_RET_STS_ERROR;
250: if( FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) then
251: FND_MESSAGE.SET_NAME('INV', 'INV_ENTER_ITEM_LPN');
252: FND_MSG_PUB.Add;
253: end if;
254: end if;
255: END IF;

Line 261: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

257: IF p_trolin_rec.date_required IS NULL THEN
258: l_return_status := FND_API.G_RET_STS_ERROR;
259:
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
261: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_DATE_REQUIRED'),FALSE);
263: FND_MSG_PUB.Add;
264: END IF;
265: END IF;

Line 262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_DATE_REQUIRED'),FALSE);

258: l_return_status := FND_API.G_RET_STS_ERROR;
259:
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
261: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','INV_DATE_REQUIRED'),FALSE);
263: FND_MSG_PUB.Add;
264: END IF;
265: END IF;
266:

Line 272: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');

268: if( p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then
269: l_return_status := FND_API.G_RET_STS_ERROR;
270:
271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
272: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');
273: FND_MSG_PUB.Add;
274: END IF;
275: end if;
276: END IF;

Line 282: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

278: IF p_trolin_rec.uom_code IS NULL THEN
279: if( p_trolin_rec.inventory_item_id is not null and p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then
280: l_return_status := FND_API.G_RET_STS_ERROR;
281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
282: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','UOM'),FALSE);
284: FND_MSG_PUB.Add;
285: END IF;
286: end if;

Line 283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','UOM'),FALSE);

279: if( p_trolin_rec.inventory_item_id is not null and p_move_order_type <> INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY ) then
280: l_return_status := FND_API.G_RET_STS_ERROR;
281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
282: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
283: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('INV','UOM'),FALSE);
284: FND_MSG_PUB.Add;
285: END IF;
286: end if;
287: END IF;

Line 292: FND_MESSAGE.SET_NAME('INV', 'INV_ENTER_ITEM_LPN');

288:
289: IF p_trolin_rec.lpn_id IS NULL THEN
290: if p_move_order_type = INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY and p_trolin_rec.inventory_item_id is null then
291: if( fnd_msg_pub.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)) then
292: FND_MESSAGE.SET_NAME('INV', 'INV_ENTER_ITEM_LPN');
293: FND_MSG_PUB.Add;
294: end if;
295: end if;
296: END IF;

Line 306: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

302: -- Added the last condition for bug 2519579
303: l_return_status := FND_API.G_RET_STS_ERROR;
304:
305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Account');
308: FND_MSG_PUB.Add;
309: END IF;
310: END IF;

Line 307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Account');

303: l_return_status := FND_API.G_RET_STS_ERROR;
304:
305: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
306: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Account');
308: FND_MSG_PUB.Add;
309: END IF;
310: END IF;
311:

Line 332: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

328: (INV_GLOBALS.G_MOVE_ORDER_PUT_AWAY, INV_GLOBALS.G_MOVE_ORDER_SYSTEM)) THEN
329: l_return_status := FND_API.G_RET_STS_ERROR;
330:
331: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
332: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','To Subinventory');
334: FND_MSG_PUB.Add;
335: END IF; --END IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
336: END IF; --END IF MO type not in Putaway, System)

Line 333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','To Subinventory');

329: l_return_status := FND_API.G_RET_STS_ERROR;
330:
331: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
332: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');
333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','To Subinventory');
334: FND_MSG_PUB.Add;
335: END IF; --END IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
336: END IF; --END IF MO type not in Putaway, System)
337: END IF; --END IF sub code is NULL

Line 359: FND_MESSAGE.SET_NAME('INV','INV_SUB_RESTRICT');

355: if (l_org_loc_control = 1) then
356: l_return_status := FND_API.G_RET_STS_ERROR;
357:
358: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
359: FND_MESSAGE.SET_NAME('INV','INV_SUB_RESTRICT');
360: FND_MSG_PUB.Add;
361: END IF;
362: else
363: if (l_org_loc_control = 4) then

Line 375: FND_MESSAGE.SET_NAME('INV','INV_SUB_RESTRICT');

371:
372: l_return_status := FND_API.G_RET_STS_ERROR;
373:
374: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
375: FND_MESSAGE.SET_NAME('INV','INV_SUB_RESTRICT');
376: FND_MSG_PUB.Add;
377: END IF;
378: elsif (l_sub_loc_control = 5) THEN
379: select nvl(location_control_code,1)

Line 389: FND_MESSAGE.SET_NAME('INV','INV_SUB_RESTRICT');

385: if (l_item_loc_control = 1) THEN
386: l_return_status := FND_API.G_RET_STS_ERROR;
387:
388: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
389: FND_MESSAGE.SET_NAME('INV','INV_SUB_RESTRICT');
390: FND_MSG_PUB.Add;
391: END IF;
392: end if;
393: end if;

Line 427: fnd_message.set_name('INV', 'INV_SUB_RESERVABLE');

423: , p_trolin_rec.organization_id);
424: FETCH c_get_item_num INTO l_item_number;
425: CLOSE c_get_item_num;
426:
427: fnd_message.set_name('INV', 'INV_SUB_RESERVABLE');
428: fnd_message.set_token('JOB', l_wip_entity_name);
429: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);
430: fnd_message.set_token('ITEM', l_item_number);
431: fnd_msg_pub.ADD;

Line 428: fnd_message.set_token('JOB', l_wip_entity_name);

424: FETCH c_get_item_num INTO l_item_number;
425: CLOSE c_get_item_num;
426:
427: fnd_message.set_name('INV', 'INV_SUB_RESERVABLE');
428: fnd_message.set_token('JOB', l_wip_entity_name);
429: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);
430: fnd_message.set_token('ITEM', l_item_number);
431: fnd_msg_pub.ADD;
432: l_return_status := FND_API.G_RET_STS_ERROR;

Line 429: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);

425: CLOSE c_get_item_num;
426:
427: fnd_message.set_name('INV', 'INV_SUB_RESERVABLE');
428: fnd_message.set_token('JOB', l_wip_entity_name);
429: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);
430: fnd_message.set_token('ITEM', l_item_number);
431: fnd_msg_pub.ADD;
432: l_return_status := FND_API.G_RET_STS_ERROR;
433: END IF;

Line 430: fnd_message.set_token('ITEM', l_item_number);

426:
427: fnd_message.set_name('INV', 'INV_SUB_RESERVABLE');
428: fnd_message.set_token('JOB', l_wip_entity_name);
429: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);
430: fnd_message.set_token('ITEM', l_item_number);
431: fnd_msg_pub.ADD;
432: l_return_status := FND_API.G_RET_STS_ERROR;
433: END IF;
434:

Line 450: fnd_message.set_name('WMS', 'WMS_SUB_LPN_CONTROLLED');

446: , p_trolin_rec.organization_id);
447: FETCH c_get_item_num INTO l_item_number;
448: CLOSE c_get_item_num;
449:
450: fnd_message.set_name('WMS', 'WMS_SUB_LPN_CONTROLLED');
451: fnd_message.set_token('JOB', l_wip_entity_name);
452: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);
453: fnd_message.set_token('ITEM', l_item_number);
454:

Line 451: fnd_message.set_token('JOB', l_wip_entity_name);

447: FETCH c_get_item_num INTO l_item_number;
448: CLOSE c_get_item_num;
449:
450: fnd_message.set_name('WMS', 'WMS_SUB_LPN_CONTROLLED');
451: fnd_message.set_token('JOB', l_wip_entity_name);
452: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);
453: fnd_message.set_token('ITEM', l_item_number);
454:
455: fnd_msg_pub.ADD;

Line 452: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);

448: CLOSE c_get_item_num;
449:
450: fnd_message.set_name('WMS', 'WMS_SUB_LPN_CONTROLLED');
451: fnd_message.set_token('JOB', l_wip_entity_name);
452: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);
453: fnd_message.set_token('ITEM', l_item_number);
454:
455: fnd_msg_pub.ADD;
456: l_return_status := FND_API.G_RET_STS_ERROR;

Line 453: fnd_message.set_token('ITEM', l_item_number);

449:
450: fnd_message.set_name('WMS', 'WMS_SUB_LPN_CONTROLLED');
451: fnd_message.set_token('JOB', l_wip_entity_name);
452: fnd_message.set_token('SUB', p_trolin_rec.to_subinventory_code);
453: fnd_message.set_token('ITEM', l_item_number);
454:
455: fnd_msg_pub.ADD;
456: l_return_status := FND_API.G_RET_STS_ERROR;
457: END IF;

Line 484: FND_MESSAGE.SET_NAME('INV', 'INV_INT_UNITNUMBER');

480: from pjm_unit_numbers_lov_v
481: where unit_number = p_trolin_rec.unit_number;
482: exception
483: when no_data_found then
484: FND_MESSAGE.SET_NAME('INV', 'INV_INT_UNITNUMBER');
485: FND_MSG_PUB.ADD;
486: raise FND_API.G_EXC_ERROR;
487: end;
488: end if;

Line 698: fnd_message.set_name('INV','INVALID_SUB');

694: --
695: EXCEPTION
696: WHEN NO_DATA_FOUND THEN
697: --inv_debug.message('ssia', 'invalid from sub');
698: fnd_message.set_name('INV','INVALID_SUB');
699: fnd_msg_pub.add;
700: RAISE fnd_api.g_exc_error;
701: END ;
702: ELSIF g_item.restrict_subinventories_code = 2 THEN

Line 714: fnd_message.SET_NAME('INV','INVALID_SUB');

710: --
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN
713: --inv_debug.message('ssia', 'invalid from sub');
714: fnd_message.SET_NAME('INV','INVALID_SUB');
715: fnd_msg_pub.add;
716: RAISE fnd_api.g_exc_error;
717: END ;
718: END IF;

Line 1279: fnd_message.set_name('INV','INVALID_SUB');

1275: --
1276: EXCEPTION
1277: WHEN NO_DATA_FOUND THEN
1278: --inv_debug.message('ssia', 'invalid to sub');
1279: fnd_message.set_name('INV','INVALID_SUB');
1280: fnd_msg_pub.add;
1281: RAISE fnd_api.g_exc_error;
1282: END ;
1283: ELSIF g_item.restrict_subinventories_code = 2 THEN

Line 1296: fnd_message.SET_NAME('INV','INVALID_SUB');

1292: --
1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN
1295: --inv_debug.message('ssia', 'invalid to sub');
1296: fnd_message.SET_NAME('INV','INVALID_SUB');
1297: fnd_msg_pub.add;
1298: RAISE fnd_api.g_exc_error;
1299: END ;
1300: END IF;