DBA Data[Home] [Help]

APPS.GMIVILC dependencies on FND_MSG_PUB

Line 154: FND_MSG_PUB.Add;

150: p_ic_item_mst_row.delete_mark = 1
151: THEN
152: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
153: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);
154: FND_MSG_PUB.Add;
155: RAISE FND_API.G_EXC_ERROR;
156: ELSIF p_ic_item_mst_row.inactive_ind = 1
157: AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
158: THEN

Line 161: FND_MSG_PUB.Add;

157: AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
158: THEN
159: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
160: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);
161: FND_MSG_PUB.Add;
162: x_return_status :=FND_API.G_RET_STS_ERROR;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:

Line 174: FND_MSG_PUB.Add;

170: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
171: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
172: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
173: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
174: FND_MSG_PUB.Add;
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:
178: -- Bug 1741321

Line 186: FND_MSG_PUB.Add;

182: THEN
183: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
184: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);
185: FND_MESSAGE.SET_TOKEN('UOM',l_rec_from_um);
186: FND_MSG_PUB.Add;
187: RAISE FND_API.G_EXC_ERROR;
188: END IF;
189:
190: -- Bug 1741321

Line 198: FND_MSG_PUB.Add;

194: THEN
195: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
196: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);
197: FND_MESSAGE.SET_TOKEN('UOM',l_rec_to_um);
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: /* Check that conversion factor is positive value */

Line 214: FND_MSG_PUB.Add;

210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_TYPE_FACTOR');
211: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
212: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
213: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
214: FND_MSG_PUB.Add;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: /* Get UOM details of the from Unit of Measure. If this retrieval fails */

Line 255: FND_MSG_PUB.Add;

251: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
252: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
253: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
254: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
255: FND_MSG_PUB.Add;
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258:
259: /* Check that the unit of measure type of the from_uom or the to_uom */

Line 289: FND_MSG_PUB.Add;

285: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
286: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
287: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
288: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
289: FND_MSG_PUB.Add;
290: RAISE FND_API.G_EXC_ERROR;
291: END IF;
292:
293: /* Now we have all the data required to calculate the conversion */

Line 319: FND_MSG_PUB.Add;

315: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
316: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
317: FND_MESSAGE.SET_TOKEN('UM1', l_from_um);
318: FND_MESSAGE.SET_TOKEN('UM2', l_from_std_um);
319: FND_MSG_PUB.Add;
320: RAISE FND_API.G_EXC_ERROR;
321: END IF;
322:
323: l_type_factorrev := 1 / l_factor;

Line 348: FND_MSG_PUB.Add;

344: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
345: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
346: FND_MESSAGE.SET_TOKEN('UM1', l_to_um);
347: FND_MESSAGE.SET_TOKEN('UM2', l_to_std_um);
348: FND_MSG_PUB.Add;
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:
352: l_type_factorrev := 1 / l_factor;

Line 389: FND_MSG_PUB.Add;

385: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
386: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
387: FND_MESSAGE.SET_TOKEN('UM1', l_to_um);
388: FND_MESSAGE.SET_TOKEN('UM2', l_to_std_um);
389: FND_MSG_PUB.Add;
390: RAISE FND_API.G_EXC_ERROR;
391: END IF;
392: END IF;
393:

Line 412: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

408: x_ic_item_cnv_row.type_factorrev := l_type_factorrev;
409: x_ic_item_cnv_row.last_update_login := GMIGUTL.DEFAULT_LOGIN;
410:
411:
412: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
413: , p_data => x_msg_data
414: );
415:
416: EXCEPTION

Line 425: FND_MSG_PUB.Add;

421: FND_MESSAGE.SET_TOKEN('UOM', p_item_cnv_rec.from_uom);
422: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
423: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
424: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
425: FND_MSG_PUB.Add;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
428: , p_data => x_msg_data
429: );

Line 427: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

423: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);
424: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);
425: FND_MSG_PUB.Add;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
428: , p_data => x_msg_data
429: );
430:
431: WHEN FND_API.G_EXC_ERROR THEN

Line 433: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

429: );
430:
431: WHEN FND_API.G_EXC_ERROR THEN
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
434: , p_data => x_msg_data
435: );
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 439: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

435: );
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
440: , p_data => x_msg_data
441: );
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 444: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

440: , p_data => x_msg_data
441: );
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
445: , l_api_name
446: );
447: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
448: , p_data => x_msg_data

Line 447: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
445: , l_api_name
446: );
447: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
448: , p_data => x_msg_data
449: );
450: END Validate_Lot_Conversion;
451: