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

Line 66: , p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE

62: --+==========================================================================+
63: -- Api end of comments
64: PROCEDURE Create_Item_Lot_Uom_Conv
65: ( p_api_version IN NUMBER
66: , p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE
67: , p_commit IN VARCHAR2 :=FND_API.G_FALSE
68: , p_validation_level IN VARCHAR2 :=FND_API.G_VALID_LEVEL_FULL
69: , p_item_cnv_rec IN item_cnv_rec_typ
70: , x_return_status OUT NOCOPY VARCHAR2

Line 67: , p_commit IN VARCHAR2 :=FND_API.G_FALSE

63: -- Api end of comments
64: PROCEDURE Create_Item_Lot_Uom_Conv
65: ( p_api_version IN NUMBER
66: , p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE
67: , p_commit IN VARCHAR2 :=FND_API.G_FALSE
68: , p_validation_level IN VARCHAR2 :=FND_API.G_VALID_LEVEL_FULL
69: , p_item_cnv_rec IN item_cnv_rec_typ
70: , x_return_status OUT NOCOPY VARCHAR2
71: , x_msg_count OUT NOCOPY NUMBER

Line 68: , p_validation_level IN VARCHAR2 :=FND_API.G_VALID_LEVEL_FULL

64: PROCEDURE Create_Item_Lot_Uom_Conv
65: ( p_api_version IN NUMBER
66: , p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE
67: , p_commit IN VARCHAR2 :=FND_API.G_FALSE
68: , p_validation_level IN VARCHAR2 :=FND_API.G_VALID_LEVEL_FULL
69: , p_item_cnv_rec IN item_cnv_rec_typ
70: , x_return_status OUT NOCOPY VARCHAR2
71: , x_msg_count OUT NOCOPY NUMBER
72: , x_msg_data OUT NOCOPY VARCHAR2

Line 108: IF NOT FND_API.Compatible_API_CALL ( l_api_version

104:
105: -- Standard Start OF API savepoint
106: SAVEPOINT Create_Item_Lot_Uom_Conv;
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_CALL ( l_api_version
109: , p_api_version
110: , l_api_name
111: , G_PKG_NAME
112: )

Line 114: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

110: , l_api_name
111: , G_PKG_NAME
112: )
113: THEN
114: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: -- Initialize message list if p_int_msg_list is set TRUE.
118: IF FND_API.to_boolean(p_init_msg_list)

Line 118: IF FND_API.to_boolean(p_init_msg_list)

114: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: -- Initialize message list if p_int_msg_list is set TRUE.
118: IF FND_API.to_boolean(p_init_msg_list)
119: THEN
120: FND_MSG_PUB.Initialize;
121: END IF;
122: -- Initialize API return status to sucess

Line 123: x_return_status :=FND_API.G_RET_STS_SUCCESS;

119: THEN
120: FND_MSG_PUB.Initialize;
121: END IF;
122: -- Initialize API return status to sucess
123: x_return_status :=FND_API.G_RET_STS_SUCCESS;
124:
125: -- Populate WHO columns
126: l_user_name :=p_item_cnv_rec.user_name;
127: GMA_GLOBAL_GRP.Get_who( p_user_name => l_user_name

Line 136: RAISE FND_API.G_EXC_ERROR;

132: THEN
133: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
134: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
135: FND_MSG_PUB.Add;
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: -- Ensure Upper-case columns are converted
140:

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: );
151:
152: IF (l_ic_item_mst_rec.item_id < 0)
153: THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSIF (l_ic_item_mst_rec.item_id = 0) OR
156: (l_ic_item_mst_rec.delete_mark = 1)
157: THEN
158: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');

Line 161: RAISE FND_API.G_EXC_ERROR;

157: THEN
158: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
159: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
160: FND_MSG_PUB.Add;
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
163: THEN
164: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
165: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);

Line 167: RAISE FND_API.G_EXC_ERROR;

163: THEN
164: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
165: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
169: THEN
170: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);

Line 173: -- x_return_status :=FND_API.G_RET_STS_ERROR;

169: THEN
170: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
172: FND_MSG_PUB.Add;
173: -- x_return_status :=FND_API.G_RET_STS_ERROR;
174: -- RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177: -- If blank or null lot_no then get default lot

Line 174: -- RAISE FND_API.G_EXC_ERROR;

170: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);
172: FND_MSG_PUB.Add;
173: -- x_return_status :=FND_API.G_RET_STS_ERROR;
174: -- RAISE FND_API.G_EXC_ERROR;
175: END IF;
176:
177: -- If blank or null lot_no then get default lot
178:

Line 190: RAISE FND_API.G_EXC_ERROR;

186: THEN
187: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');
188: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$DEFAULT_LOT');
189: FND_MSG_PUB.Add;
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192: END IF;
193:
194:

Line 215: RAISE FND_API.G_EXC_ERROR;

211: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
212: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
213: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_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
219:

Line 235: RAISE FND_API.G_EXC_ERROR;

231: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
232: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
233: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
234: FND_MSG_PUB.Add;
235: RAISE FND_API.G_EXC_ERROR;
236: ELSIF (l_error_code = -2)
237: THEN
238: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');
239: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);

Line 244: RAISE FND_API.G_EXC_ERROR;

240: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
241: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
242: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
243: FND_MSG_PUB.Add;
244: RAISE FND_API.G_EXC_ERROR;
245: END IF;
246:
247: -- Get UOM details of the to Unit of Measure
248:

Line 263: RAISE FND_API.G_EXC_ERROR;

259: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
260: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
261: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: ELSIF (l_error_code = -2)
265: THEN
266: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');
267: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

Line 272: RAISE FND_API.G_EXC_ERROR;

268: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
269: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
270: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);
271: FND_MSG_PUB.Add;
272: RAISE FND_API.G_EXC_ERROR;
273: END IF;
274:
275: -- Check that the from UoM type differs from the to UoM type. If not then
276: -- error and exit

Line 284: RAISE FND_API.G_EXC_ERROR;

280: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
281: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
282: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
283: FND_MSG_PUB.Add;
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;
286:
287: -- Get UOM details of the item primary Unit of Measure
288: -- This should not produce any errors but we'll check for them anyway.

Line 304: RAISE FND_API.G_EXC_ERROR;

300: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
301: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
302: FND_MESSAGE.SET_TOKEN('UOM', l_ic_item_mst_rec.item_um);
303: FND_MSG_PUB.Add;
304: RAISE FND_API.G_EXC_ERROR;
305: ELSIF (l_error_code = -2)
306: THEN
307: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');
308: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

Line 313: RAISE FND_API.G_EXC_ERROR;

309: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
310: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
311: FND_MESSAGE.SET_TOKEN('UOM', l_ic_item_mst_rec.item_um);
312: FND_MSG_PUB.Add;
313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315:
316: -- Check that the unit of measure type of the from_uom or the to_uom
317: -- is the same as the unit of measure type of the item primary uom.

Line 342: RAISE FND_API.G_EXC_ERROR;

338: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
339: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
340: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
341: FND_MSG_PUB.Add;
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: -- Check that item/lot conversion does not already exist
346:

Line 359: RAISE FND_API.G_EXC_ERROR;

355: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
356: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
357: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);
358: FND_MSG_PUB.Add;
359: RAISE FND_API.G_EXC_ERROR;
360: END IF;
361:
362: -- Check that conversion factor is positive value
363:

Line 371: RAISE FND_API.G_EXC_ERROR;

367: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
368: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
369: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
370: FND_MSG_PUB.Add;
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;
373:
374: -- Now we have all the data required to calculate the conversion
375: -- factor from the standard unit of measure of the unit of measure

Line 400: RAISE FND_API.G_EXC_ERROR;

396: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
397: FND_MESSAGE.SET_TOKEN('UM1', l_from_um);
398: FND_MESSAGE.SET_TOKEN('UM2', l_sy_uoms_typ_rec_from.std_um);
399: FND_MSG_PUB.Add;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: END IF;
403:
404: -- Next convert from to_uom to std_um for to_uom uom type

Line 425: RAISE FND_API.G_EXC_ERROR;

421: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
422: FND_MESSAGE.SET_TOKEN('UM1', l_to_um);
423: FND_MESSAGE.SET_TOKEN('UM2', l_sy_uoms_typ_rec_to.std_um);
424: FND_MSG_PUB.Add;
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: END IF;
428:
429: -- Now calculate the inverse value of the conversion factor

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449:
450:
451: IF NOT GMI_ITEM_LOT_CONV_PVT.insert_IC_ITEM_CNV(l_ic_item_cnv_rec)
452: THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: -- END of API Body
457:

Line 459: IF FND_API.to_boolean(p_commit)

455:
456: -- END of API Body
457:
458: -- Standard Check of p_commit.
459: IF FND_API.to_boolean(p_commit)
460: THEN
461: COMMIT WORK;
462: END IF;
463: -- Success message

Line 477: WHEN FND_API.G_EXC_ERROR THEN

473: , p_data => x_msg_data
474: );
475:
476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
478: ROLLBACK TO Create_Item_Lot_Uom_Conv;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
481: , p_data => x_msg_data

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

475:
476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
478: ROLLBACK TO Create_Item_Lot_Uom_Conv;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

479: x_return_status := FND_API.G_RET_STS_ERROR;
480: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Create_Item_Lot_Uom_Conv;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
487: , p_data => x_msg_data

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

481: , p_data => x_msg_data
482: );
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO Create_Item_Lot_Uom_Conv;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
487: , p_data => x_msg_data
488: );
489: WHEN OTHERS THEN

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

487: , p_data => x_msg_data
488: );
489: WHEN OTHERS THEN
490: ROLLBACK TO Create_Item_Lot_Uom_Conv;
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: -- IF FND_MSG_PUB.check_msg_level
493: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
494: -- THEN
495: