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_MESSAGE

Line 133: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');

129: );
130:
131: IF l_user_id = 0
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;

Line 134: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);

130:
131: IF l_user_id = 0
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:

Line 158: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');

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

Line 159: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);

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

Line 164: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_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);
166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)

Line 165: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);

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);
166: FND_MSG_PUB.Add;
167: RAISE FND_API.G_EXC_ERROR;
168: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
169: THEN

Line 170: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_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);
172: FND_MSG_PUB.Add;
173: -- x_return_status :=FND_API.G_RET_STS_ERROR;
174: -- RAISE FND_API.G_EXC_ERROR;

Line 171: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_item_cnv_rec.item_no);

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

Line 187: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');

183: , user_id => l_user_id
184: );
185: IF (l_item_cnv_rec.lot_no IS NULL)
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;

Line 188: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$DEFAULT_LOT');

184: );
185: IF (l_item_cnv_rec.lot_no IS NULL)
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;

Line 210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');

206: IF (l_ic_lots_mst_rec.lot_id = -1) OR
207: (l_ic_lots_mst_rec.delete_mark = 1) OR
208: (l_ic_lots_mst_rec.inactive_ind = 1)
209: THEN
210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
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;

Line 211: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

207: (l_ic_lots_mst_rec.delete_mark = 1) OR
208: (l_ic_lots_mst_rec.inactive_ind = 1)
209: THEN
210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
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;

Line 212: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

208: (l_ic_lots_mst_rec.inactive_ind = 1)
209: THEN
210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
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;

Line 213: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

209: THEN
210: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
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:

Line 229: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');

225: );
226:
227: IF (l_error_code = -1)
228: THEN
229: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
230: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);
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);

Line 230: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);

226:
227: IF (l_error_code = -1)
228: THEN
229: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
230: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);
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;

Line 231: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

227: IF (l_error_code = -1)
228: THEN
229: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
230: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);
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;

Line 232: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

228: THEN
229: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
230: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);
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)

Line 233: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

229: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
230: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);
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

Line 238: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');

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

Line 239: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);

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

Line 240: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

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

Line 241: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

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

Line 242: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

238: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');
239: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.from_uom);
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:

Line 257: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');

253: );
254:
255: IF (l_error_code = -1)
256: THEN
257: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
258: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);
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);

Line 258: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);

254:
255: IF (l_error_code = -1)
256: THEN
257: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
258: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);
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;

Line 259: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

255: IF (l_error_code = -1)
256: THEN
257: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
258: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);
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;

Line 260: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

256: THEN
257: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
258: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);
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)

Line 261: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

257: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
258: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);
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

Line 266: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');

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

Line 267: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

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

Line 268: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

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

Line 269: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

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

Line 270: FND_MESSAGE.SET_TOKEN('UOM', l_item_cnv_rec.to_uom);

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

Line 279: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');

275: -- Check that the from UoM type differs from the to UoM type. If not then
276: -- error and exit
277: IF l_sy_uoms_typ_rec_from.um_type = l_sy_uoms_typ_rec_to.um_type
278: THEN
279: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
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;

Line 280: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

276: -- error and exit
277: IF l_sy_uoms_typ_rec_from.um_type = l_sy_uoms_typ_rec_to.um_type
278: THEN
279: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
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;

Line 281: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

277: IF l_sy_uoms_typ_rec_from.um_type = l_sy_uoms_typ_rec_to.um_type
278: THEN
279: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
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;

Line 282: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

278: THEN
279: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
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:

Line 298: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');

294: );
295:
296: IF (l_error_code = -1)
297: THEN
298: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
299: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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);

Line 299: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

295:
296: IF (l_error_code = -1)
297: THEN
298: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
299: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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;

Line 300: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

296: IF (l_error_code = -1)
297: THEN
298: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
299: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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;

Line 301: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

297: THEN
298: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
299: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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)

Line 302: FND_MESSAGE.SET_TOKEN('UOM', l_ic_item_mst_rec.item_um);

298: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
299: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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

Line 307: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM_TYPE');

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

Line 308: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

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

Line 309: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

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

Line 310: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

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

Line 311: FND_MESSAGE.SET_TOKEN('UOM', l_ic_item_mst_rec.item_um);

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

Line 337: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');

333: l_from_std_um := l_sy_uoms_typ_rec_to.std_um;
334: l_to_um := l_item_cnv_rec.from_uom;
335: l_to_std_um := l_sy_uoms_typ_rec_from.std_um;
336: ELSE
337: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
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;

Line 338: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

334: l_to_um := l_item_cnv_rec.from_uom;
335: l_to_std_um := l_sy_uoms_typ_rec_from.std_um;
336: ELSE
337: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
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;

Line 339: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

335: l_to_std_um := l_sy_uoms_typ_rec_from.std_um;
336: ELSE
337: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
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;

Line 340: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

336: ELSE
337: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_ITEM_UOM_MISMATCH');
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:

Line 353: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');

349: , l_item_cnv_rec.sublot_no
350: , l_um_type
351: )
352: THEN
353: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
354: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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);

Line 354: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

350: , l_um_type
351: )
352: THEN
353: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
354: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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;

Line 355: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

351: )
352: THEN
353: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
354: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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;

Line 356: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

352: THEN
353: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
354: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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;

Line 357: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);

353: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_CNV_ALREADY_EXISTS');
354: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
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:

Line 366: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_TYPE_FACTOR');

362: -- Check that conversion factor is positive value
363:
364: IF (l_factor <= 0)
365: THEN
366: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_TYPE_FACTOR');
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;

Line 367: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

363:
364: IF (l_factor <= 0)
365: THEN
366: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_TYPE_FACTOR');
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;

Line 368: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

364: IF (l_factor <= 0)
365: THEN
366: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_TYPE_FACTOR');
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;

Line 369: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

365: THEN
366: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_TYPE_FACTOR');
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:

Line 393: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');

389: ,patomic => 0
390: );
391: IF (l_factor < 0)
392: THEN
393: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
394: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
395: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
396: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
397: FND_MESSAGE.SET_TOKEN('UM1', l_from_um);

Line 394: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

390: );
391: IF (l_factor < 0)
392: THEN
393: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
394: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
395: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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);

Line 395: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

391: IF (l_factor < 0)
392: THEN
393: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
394: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
395: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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;

Line 396: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

392: THEN
393: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
394: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
395: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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;

Line 397: FND_MESSAGE.SET_TOKEN('UM1', l_from_um);

393: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
394: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
395: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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;

Line 398: FND_MESSAGE.SET_TOKEN('UM2', l_sy_uoms_typ_rec_from.std_um);

394: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
395: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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;

Line 418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');

414: ,patomic => 0
415: );
416: IF (l_factor < 0)
417: THEN
418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
419: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
421: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
422: FND_MESSAGE.SET_TOKEN('UM1', l_to_um);

Line 419: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

415: );
416: IF (l_factor < 0)
417: THEN
418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
419: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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);

Line 420: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

416: IF (l_factor < 0)
417: THEN
418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
419: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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;

Line 421: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

417: THEN
418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
419: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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;

Line 422: FND_MESSAGE.SET_TOKEN('UM1', l_to_um);

418: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
419: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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;

Line 423: FND_MESSAGE.SET_TOKEN('UM2', l_sy_uoms_typ_rec_to.std_um);

419: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
420: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
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;

Line 464: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');

460: THEN
461: COMMIT WORK;
462: END IF;
463: -- Success message
464: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
465: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
466: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
467: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
468: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);

Line 465: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);

461: COMMIT WORK;
462: END IF;
463: -- Success message
464: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
465: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
466: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
467: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
468: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);
469: FND_MSG_PUB.Add;

Line 466: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);

462: END IF;
463: -- Success message
464: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
465: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
466: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
467: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
468: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);
469: FND_MSG_PUB.Add;
470: -- Standard Call to get message count and if count is 1,

Line 467: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);

463: -- Success message
464: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
465: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
466: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
467: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
468: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);
469: FND_MSG_PUB.Add;
470: -- Standard Call to get message count and if count is 1,
471: -- get message info.

Line 468: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);

464: FND_MESSAGE.SET_NAME('GMI','IC_API_ILC_CREATED');
465: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_item_cnv_rec.item_no);
466: FND_MESSAGE.SET_TOKEN('LOT_NO', l_item_cnv_rec.lot_no);
467: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', l_item_cnv_rec.sublot_no);
468: FND_MESSAGE.SET_TOKEN('UM_TYPE', l_um_type);
469: FND_MSG_PUB.Add;
470: -- Standard Call to get message count and if count is 1,
471: -- get message info.
472: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count