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.GMIVILC dependencies on FND_API

Line 74: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL

70: +==========================================================================+
71: */
72: PROCEDURE Validate_Lot_Conversion
73: ( p_api_version IN NUMBER
74: , p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
75: , p_item_cnv_rec IN GMIGAPI.conv_rec_typ
76: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
77: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
78: , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE

Line 140: x_return_status :=FND_API.G_RET_STS_SUCCESS;

136:
137: BEGIN
138:
139: /* Initialize API return status to sucess */
140: x_return_status :=FND_API.G_RET_STS_SUCCESS;
141:
142: /* Ensure Upper-case columns are converted */
143:
144:

Line 155: RAISE FND_API.G_EXC_ERROR;

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
159: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

Line 162: x_return_status :=FND_API.G_RET_STS_ERROR;

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:
166: IF

Line 163: RAISE FND_API.G_EXC_ERROR;

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:
166: IF
167: p_ic_lots_mst_row.delete_mark = 1 OR

Line 175: RAISE FND_API.G_EXC_ERROR;

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
179: -- Validate Primary Unit of Measure

Line 187: RAISE FND_API.G_EXC_ERROR;

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
191: -- Validate Secondary Unit of Measure

Line 199: RAISE FND_API.G_EXC_ERROR;

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 */
203: -- Bug 2446245

Line 215: RAISE FND_API.G_EXC_ERROR;

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 */
219: /* we'll get an exception as there's no point in continuing. */

Line 256: RAISE FND_API.G_EXC_ERROR;

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 */
260: /* is the same as the unit of measure type of the item primary uom. */

Line 290: RAISE FND_API.G_EXC_ERROR;

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 */
294: /* factor from the standard unit of measure of the unit of measure */

Line 320: RAISE FND_API.G_EXC_ERROR;

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;
324:

Line 349: RAISE FND_API.G_EXC_ERROR;

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;
353:

Line 390: RAISE FND_API.G_EXC_ERROR;

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:
394:

Line 426: x_return_status := FND_API.G_RET_STS_ERROR;

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: );
430:

Line 431: WHEN FND_API.G_EXC_ERROR THEN

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
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: );

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

428: , p_data => x_msg_data
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:

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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: );

Line 438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

434: , p_data => x_msg_data
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

Line 443: 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;
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