DBA Data[Home] [Help]

APPS.GMIVILC dependencies on FND_MESSAGE

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

148:
149: IF p_ic_item_mst_row.item_id = 0 OR
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

Line 153: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);

149: IF p_ic_item_mst_row.item_id = 0 OR
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

Line 159: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

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

Line 160: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);

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

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

166: IF
167: p_ic_lots_mst_row.delete_mark = 1 OR
168: p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
169: THEN
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;

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

167: p_ic_lots_mst_row.delete_mark = 1 OR
168: p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
169: THEN
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;

Line 172: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);

168: p_ic_lots_mst_row.inactive_ind = 1 AND GMIGUTL.IC$API_ALLOW_INACTIVE = 0
169: THEN
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;

Line 173: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);

169: THEN
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:

Line 183: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');

179: -- Validate Primary Unit of Measure
180:
181: IF NOT GMA_VALID_GRP.Validate_um(l_rec_from_um)
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;

Line 184: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);

180:
181: IF NOT GMA_VALID_GRP.Validate_um(l_rec_from_um)
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;

Line 185: FND_MESSAGE.SET_TOKEN('UOM',l_rec_from_um);

181: IF NOT GMA_VALID_GRP.Validate_um(l_rec_from_um)
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:

Line 195: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');

191: -- Validate Secondary Unit of Measure
192:
193: IF NOT GMA_VALID_GRP.Validate_um(l_rec_to_um)
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;

Line 196: FND_MESSAGE.SET_TOKEN('ITEM_NO',p_item_cnv_rec.item_no);

192:
193: IF NOT GMA_VALID_GRP.Validate_um(l_rec_to_um)
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;

Line 197: FND_MESSAGE.SET_TOKEN('UOM',l_rec_to_um);

193: IF NOT GMA_VALID_GRP.Validate_um(l_rec_to_um)
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:

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

206: l_type_factorrev := 1 / p_item_cnv_rec.type_factor;
207:
208: IF (l_factor <= 0)
209: THEN
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;

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

207:
208: IF (l_factor <= 0)
209: THEN
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;

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

208: IF (l_factor <= 0)
209: THEN
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;

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

209: THEN
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:

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

247: /* Check that the from UoM type differs from the to UoM type. If not then */
248: /* error and exit */
249: IF l_from_type = l_to_type
250: THEN
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;

Line 252: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);

248: /* error and exit */
249: IF l_from_type = l_to_type
250: THEN
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;

Line 253: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);

249: IF l_from_type = l_to_type
250: THEN
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;

Line 254: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);

250: THEN
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:

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

281: l_to_um := l_rec_from_um;
282: l_to_std_um := l_from_std;
283: l_from_std_um := l_to_std;
284: ELSE
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;

Line 286: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);

282: l_to_std_um := l_from_std;
283: l_from_std_um := l_to_std;
284: ELSE
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;

Line 287: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);

283: l_from_std_um := l_to_std;
284: ELSE
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;

Line 288: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);

284: ELSE
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:

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

309: ,patomic => 0
310: );
311: IF (l_factor < 0)
312: THEN
313: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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);

Line 314: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);

310: );
311: IF (l_factor < 0)
312: THEN
313: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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);

Line 315: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);

311: IF (l_factor < 0)
312: THEN
313: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

Line 316: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);

312: THEN
313: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

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

313: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
314: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

Line 318: FND_MESSAGE.SET_TOKEN('UM2', l_from_std_um);

314: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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:

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

338: ,patomic => 0
339: );
340: IF (l_factor < 0)
341: THEN
342: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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);

Line 343: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);

339: );
340: IF (l_factor < 0)
341: THEN
342: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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);

Line 344: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);

340: IF (l_factor < 0)
341: THEN
342: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

Line 345: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);

341: THEN
342: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

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

342: FND_MESSAGE.SET_NAME('GMI','IC_API_ITEM_LOT_UOM_FAILED');
343: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

Line 347: FND_MESSAGE.SET_TOKEN('UM2', l_to_std_um);

343: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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:

Line 383: FND_MESSAGE.SET_NAME('GMI','GMI_LOTCONV_TRANSACTIONS_EXIST');

379: CLOSE Cur_journal;
380: END IF;
381: END IF;
382: IF (X_count > 0) THEN
383: FND_MESSAGE.SET_NAME('GMI','GMI_LOTCONV_TRANSACTIONS_EXIST');
384: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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);

Line 384: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);

380: END IF;
381: END IF;
382: IF (X_count > 0) THEN
383: FND_MESSAGE.SET_NAME('GMI','GMI_LOTCONV_TRANSACTIONS_EXIST');
384: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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);

Line 385: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);

381: END IF;
382: IF (X_count > 0) THEN
383: FND_MESSAGE.SET_NAME('GMI','GMI_LOTCONV_TRANSACTIONS_EXIST');
384: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

Line 386: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);

382: IF (X_count > 0) THEN
383: FND_MESSAGE.SET_NAME('GMI','GMI_LOTCONV_TRANSACTIONS_EXIST');
384: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

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

383: FND_MESSAGE.SET_NAME('GMI','GMI_LOTCONV_TRANSACTIONS_EXIST');
384: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

Line 388: FND_MESSAGE.SET_TOKEN('UM2', l_to_std_um);

384: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);
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;

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

416: EXCEPTION
417:
418: WHEN NO_DATA_FOUND
419: THEN
420: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
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);

Line 421: FND_MESSAGE.SET_TOKEN('UOM', p_item_cnv_rec.from_uom);

417:
418: WHEN NO_DATA_FOUND
419: THEN
420: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
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;

Line 422: FND_MESSAGE.SET_TOKEN('ITEM_NO', p_item_cnv_rec.item_no);

418: WHEN NO_DATA_FOUND
419: THEN
420: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
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;

Line 423: FND_MESSAGE.SET_TOKEN('LOT_NO', p_item_cnv_rec.lot_no);

419: THEN
420: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_UOM');
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

Line 424: FND_MESSAGE.SET_TOKEN('SUBLOT_NO', p_item_cnv_rec.sublot_no);

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