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_QUANTITY_PVT dependencies on FND_MSG_PUB

Line 125: FND_MSG_PUB.Add;

121: IF l_user_id = 0
122: THEN
123: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_USER_NAME');
124: FND_MESSAGE.SET_TOKEN('USER_NAME',l_user_name);
125: FND_MSG_PUB.Add;
126: RAISE FND_API.G_EXC_ERROR;
127: END IF;
128:
129: -- Get required system constants

Line 137: FND_MSG_PUB.Add;

133: IF (IC$DEFAULT_LOT IS NULL)
134: THEN
135: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');
136: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$DEFAULT_LOT');
137: FND_MSG_PUB.Add;
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;
140: IC$DEFAULT_LOCT := FND_PROFILE.Value_Specific( name => 'IC$DEFAULT_LOCT'
141: , user_id => l_user_id

Line 147: FND_MSG_PUB.Add;

143: IF (IC$DEFAULT_LOCT IS NULL)
144: THEN
145: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');
146: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$DEFAULT_LOCT');
147: FND_MSG_PUB.Add;
148: RAISE FND_API.G_EXC_ERROR;
149: END IF;
150: IC$ALLOWNEGINV := FND_PROFILE.Value_Specific( name => 'IC$ALLOWNEGINV'
151: , user_id => l_user_id

Line 157: FND_MSG_PUB.Add;

153: IF (IC$ALLOWNEGINV IS NULL)
154: THEN
155: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');
156: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$ALLOWNEGINV');
157: FND_MSG_PUB.Add;
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160: IC$MOVEDIFFSTAT := FND_PROFILE.Value_Specific( name => 'IC$MOVEDIFFSTAT'
161: , user_id => l_user_id

Line 167: FND_MSG_PUB.Add;

163: IF (IC$MOVEDIFFSTAT IS NULL)
164: THEN
165: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_CONSTANT');
166: FND_MESSAGE.SET_TOKEN('CONSTANT_NAME','IC$MOVEDIFFSTAT');
167: FND_MSG_PUB.Add;
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171: -- Store transaction locally

Line 180: FND_MSG_PUB.Add;

176: IF NOT GMA_VALID_GRP.NumRangeCheck(1,5,l_trans_type)
177: THEN
178: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_TRANS_TYPE');
179: FND_MESSAGE.SET_TOKEN('TRANS_TYPE',l_trans_type);
180: FND_MSG_PUB.Add;
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;
183:
184: -- Check for inappropriate fields being passed for transaction type

Line 193: FND_MSG_PUB.Add;

189: THEN
190: FND_MESSAGE.SET_NAME('GMI','IC_API_FROM_WHSE_NOT_REQD');
191: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
192: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
193: FND_MSG_PUB.Add;
194: RAISE FND_API.G_EXC_ERROR;
195: END IF;
196: -- To Warehouse
197: IF (l_trans_rec.to_whse_code <> ' ' AND

Line 204: FND_MSG_PUB.Add;

200: THEN
201: FND_MESSAGE.SET_NAME('GMI','IC_API_TO_WHSE_NOT_REQD');
202: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
203: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
204: FND_MSG_PUB.Add;
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: -- From Location
208: IF (l_trans_rec.from_location <> ' ' AND

Line 215: FND_MSG_PUB.Add;

211: THEN
212: FND_MESSAGE.SET_NAME('GMI','IC_API_LOCATION_NOT_REQD');
213: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
214: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
215: FND_MSG_PUB.Add;
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218: -- To Location
219: IF (l_trans_rec.to_location <> ' ' AND

Line 226: FND_MSG_PUB.Add;

222: THEN
223: FND_MESSAGE.SET_NAME('GMI','IC_API_LOCATION_NOT_REQD');
224: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
225: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
226: FND_MSG_PUB.Add;
227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229: -- Primary UOM
230: IF (l_trans_rec.item_um <> ' ' AND

Line 238: FND_MSG_PUB.Add;

234: THEN
235: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_NOT_REQD');
236: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
237: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
238: FND_MSG_PUB.Add;
239: RAISE FND_API.G_EXC_ERROR;
240: END IF;
241: -- Secondary UOM
242: IF (l_trans_rec.item_um2 <> ' ' AND

Line 250: FND_MSG_PUB.Add;

246: THEN
247: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM2_NOT_REQD');
248: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
249: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
250: FND_MSG_PUB.Add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: -- Primary qty
254: IF (l_trans_rec.trans_qty <> 0 AND

Line 262: FND_MSG_PUB.Add;

258: THEN
259: FND_MESSAGE.SET_NAME('GMI','IC_API_QTY_NOT_REQD');
260: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
261: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
262: FND_MSG_PUB.Add;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: -- Secondary qty
266: IF (l_trans_rec.trans_qty2 <> 0 AND

Line 274: FND_MSG_PUB.Add;

270: THEN
271: FND_MESSAGE.SET_NAME('GMI','IC_API_QTY2_NOT_REQD');
272: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
273: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
274: FND_MSG_PUB.Add;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277: -- QC Grade
278: IF (l_trans_rec.qc_grade <> ' ' AND

Line 285: FND_MSG_PUB.Add;

281: THEN
282: FND_MESSAGE.SET_NAME('GMI','IC_API_QC_GRADE_NOT_REQD');
283: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
284: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
285: FND_MSG_PUB.Add;
286: RAISE FND_API.G_EXC_ERROR;
287: END IF;
288: -- Lot Status
289: IF (l_trans_rec.lot_status <> ' ' AND

Line 296: FND_MSG_PUB.Add;

292: THEN
293: FND_MESSAGE.SET_NAME('GMI','IC_API_LOT_STATUS_NOT_REQD');
294: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
295: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
296: FND_MSG_PUB.Add;
297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300: -- Validate Journal number

Line 308: FND_MSG_PUB.Add;

304: ,l_trans_rec.orgn_code)
305: THEN
306: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_JOURNAL_NO');
307: FND_MESSAGE.SET_TOKEN('JOURNAL_NO',l_trans_rec.journal_no);
308: FND_MSG_PUB.Add;
309: RAISE FND_API.G_EXC_ERROR;
310: ELSE
311: IF (l_trans_rec.journal_no = ' ' OR
312: l_trans_rec.journal_no IS NULL)

Line 323: FND_MSG_PUB.Add;

319: THEN
320: FND_MESSAGE.SET_NAME('GMI','IC_API_UNABLE_TO_GET_DOC_NO');
321: FND_MESSAGE.SET_TOKEN('DOC_TYPE','JRNL');
322: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_trans_rec.orgn_code);
323: FND_MSG_PUB.Add;
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326: END IF;
327: END IF;

Line 338: FND_MSG_PUB.Add;

334: IF (l_sy_reas_cds_rec.reason_code = ' ')
335: THEN
336: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_REASON_CODE');
337: FND_MESSAGE.SET_TOKEN('REASON_CODE',l_trans_rec.reason_code);
338: FND_MSG_PUB.Add;
339: RAISE FND_API.G_EXC_ERROR;
340: END IF;
341:
342: -- Get the item details

Line 356: FND_MSG_PUB.Add;

352: (l_ic_item_mst_rec.delete_mark = 1)
353: THEN
354: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');
355: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
356: FND_MSG_PUB.Add;
357: RAISE FND_API.G_EXC_ERROR;
358: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
359: THEN
360: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');

Line 362: FND_MSG_PUB.Add;

358: ELSIF (l_ic_item_mst_rec.noninv_ind = 1)
359: THEN
360: FND_MESSAGE.SET_NAME('GMI','IC_API_NONINV_ITEM_NO');
361: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
362: FND_MSG_PUB.Add;
363: RAISE FND_API.G_EXC_ERROR;
364: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
365: THEN
366: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');

Line 368: FND_MSG_PUB.Add;

364: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)
365: THEN
366: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_ITEM_NO');
367: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
368: FND_MSG_PUB.Add;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371:
372: -- Check that transaction type is applicable to item

Line 379: FND_MSG_PUB.Add;

375: THEN
376: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_TRANS_TYPE_FOR_ITEM');
377: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
378: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
379: FND_MSG_PUB.Add;
380: RAISE FND_API.G_EXC_ERROR;
381: END IF;
382:
383: -- Lot status change

Line 389: FND_MSG_PUB.Add;

385: THEN
386: FND_MESSAGE.SET_NAME('GMI','IC_API_INV_TRANS_TYPE_FOR_ITEM');
387: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
388: FND_MESSAGE.SET_TOKEN('TRANS_TYPE', l_trans_type);
389: FND_MSG_PUB.Add;
390: RAISE FND_API.G_EXC_ERROR;
391: END IF;
392:
393: -- Default unit of measure fields for status and QC grade change

Line 426: FND_MSG_PUB.Add;

422: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
423: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
424: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
425: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
426: FND_MSG_PUB.Add;
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429: ELSE
430: IF (l_trans_rec.lot_no = ' ' OR

Line 437: FND_MSG_PUB.Add;

433: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
434: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
435: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
436: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
437: FND_MSG_PUB.Add;
438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: END IF;
441:

Line 454: FND_MSG_PUB.Add;

450: IF (l_trans_rec.sublot_no <>' ')
451: THEN
452: FND_MESSAGE.SET_NAME('GMI','IC_API_SUBLOT_NOT_REQD');
453: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
454: FND_MSG_PUB.Add;
455: RAISE FND_API.G_EXC_ERROR;
456: END IF;
457: END IF;
458:

Line 477: FND_MSG_PUB.Add;

473: IF (l_ic_item_mst_rec.lot_ctl = 1 AND
474: l_trans_rec.lot_no='DEFAULTLOT')
475: THEN
476: FND_MESSAGE.SET_NAME('GMI','IC_DEFAULTLOTERR');
477: FND_MSG_PUB.Add;
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480: END IF;
481:

Line 497: FND_MSG_PUB.Add;

493: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
494: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
495: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
496: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
497: FND_MSG_PUB.Add;
498: RAISE FND_API.G_EXC_ERROR;
499: ELSIF (l_ic_lots_mst_rec.lot_id = -2)
500: THEN
501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 513: FND_MSG_PUB.Add;

509: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');
510: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
511: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
512: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
513: FND_MSG_PUB.Add;
514: RAISE FND_API.G_EXC_ERROR;
515: END IF;
516: ELSE
517: -- If the lot was not found when creating inventory then create it

Line 542: FND_MSG_PUB.Initialize;

538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539: END IF;
540:
541: -- Initialize message list to remove 'Lot created' message
542: FND_MSG_PUB.Initialize;
543:
544: -- Get lot details for lot created
545: GMI_GLOBAL_GRP.Get_Lot ( p_item_id => l_ic_item_mst_rec.item_id
546: , p_lot_no => l_trans_rec.lot_no

Line 569: FND_MSG_PUB.Add;

565: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_QC_GRADE');
566: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
567: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
568: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
569: FND_MSG_PUB.Add;
570: RAISE FND_API.G_EXC_ERROR;
571: END IF;
572: ELSE
573: l_trans_rec.qc_grade :=l_ic_lots_mst_rec.qc_grade;

Line 587: FND_MSG_PUB.Add;

583: (l_ic_whse_mst_rec.delete_mark = 1)
584: THEN
585: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
586: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_trans_rec.from_whse_code);
587: FND_MSG_PUB.Add;
588: RAISE FND_API.G_EXC_ERROR;
589: ELSE
590: -- Check location parameters
591: IF NOT GMI_VALID_GRP.Validate_Location

Line 602: FND_MSG_PUB.Add;

598: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');
599: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_trans_rec.item_no);
600: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_trans_rec.from_whse_code);
601: FND_MESSAGE.SET_TOKEN('LOCATION',l_trans_rec.from_location);
602: FND_MSG_PUB.Add;
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF (l_trans_rec.from_location = ' ' OR
605: l_trans_rec.from_location IS NULL)
606: THEN

Line 627: FND_MSG_PUB.Add;

623: (l_ic_whse_mst_rec.delete_mark = 1)
624: THEN
625: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
626: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_trans_rec.to_whse_code);
627: FND_MSG_PUB.Add;
628: RAISE FND_API.G_EXC_ERROR;
629: ELSE
630: -- Check location parameters
631: IF NOT GMI_VALID_GRP.Validate_Location

Line 642: FND_MSG_PUB.Add;

638: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOCATION');
639: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_trans_rec.item_no);
640: FND_MESSAGE.SET_TOKEN('WHSE_CODE', l_trans_rec.to_whse_code);
641: FND_MESSAGE.SET_TOKEN('LOCATION',l_trans_rec.to_location);
642: FND_MSG_PUB.Add;
643: RAISE FND_API.G_EXC_ERROR;
644: ELSE
645: IF (l_trans_rec.to_location = ' ' OR
646: l_trans_rec.to_location IS NULL)

Line 660: FND_MSG_PUB.Add;

656: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_SAME_WHSE_LOC');
657: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
658: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
659: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
660: FND_MSG_PUB.Add;
661: RAISE FND_API.G_EXC_ERROR;
662: END IF;
663: -- For Change lot status 'to' warehouse and location are the same as 'from'
664: ELSIF (l_trans_type = 4)

Line 704: FND_MSG_PUB.Add;

700: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
701: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
702: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_trans_rec.from_whse_code);
703: FND_MESSAGE.SET_TOKEN('LOCATION',l_trans_rec.from_location);
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: ELSIF (l_ic_loct_inv_rec_from.item_id = 0) OR
707: (l_ic_loct_inv_rec_from.loct_onhand = 0 AND l_trans_type =4)
708: THEN

Line 715: FND_MSG_PUB.Add;

711: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
712: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
713: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_trans_rec.from_whse_code);
714: FND_MESSAGE.SET_TOKEN('LOCATION',l_trans_rec.from_location);
715: FND_MSG_PUB.Add;
716: RAISE FND_API.G_EXC_ERROR;
717: ELSIF (l_trans_type = 2)
718: THEN
719: l_trans_rec.lot_status :=l_ic_loct_inv_rec_from.lot_status;

Line 728: FND_MSG_PUB.Add;

724: FND_MESSAGE.SET_NAME('GMI','IC_API_SAME_LOT_STATUS');
725: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
726: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
727: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
728: FND_MSG_PUB.Add;
729: RAISE FND_API.G_EXC_ERROR;
730: ELSE
731: -- Store original lot status
732: x_old_lot_status :=l_ic_loct_inv_rec_from.lot_status;

Line 748: FND_MSG_PUB.Add;

744: FND_MESSAGE.SET_NAME('GMI','IC_API_NO_LOT_ONHAND');
745: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
746: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
747: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
748: FND_MSG_PUB.Add;
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751: END IF;
752:

Line 762: FND_MSG_PUB.Add;

758: FND_MESSAGE.SET_NAME('GMI','IC_API_ZERO_QTY');
759: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
760: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
761: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
762: FND_MSG_PUB.Add;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765: IF (l_trans_rec.trans_qty2 <> 0 AND
766: l_trans_rec.trans_qty2 IS NOT NULL) AND

Line 774: FND_MSG_PUB.Add;

770: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QTY2');
771: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
772: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
773: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
774: FND_MSG_PUB.Add;
775: RAISE FND_API.G_EXC_ERROR;
776: END IF;
777: END IF;
778:

Line 785: FND_MSG_PUB.Add;

781: THEN
782: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_UOM');
783: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
784: FND_MESSAGE.SET_TOKEN('UOM',l_trans_rec.item_um);
785: FND_MSG_PUB.Add;
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788:
789: -- Handle Quantities

Line 816: FND_MSG_PUB.Add;

812: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
813: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
814: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_trans_rec.item_um);
815: FND_MESSAGE.SET_TOKEN('TO_UOM',l_ic_item_mst_rec.item_um);
816: FND_MSG_PUB.Add;
817: RAISE FND_API.G_EXC_ERROR;
818: ELSE
819: l_trans_rec.item_um :=l_ic_item_mst_rec.item_um;
820: -- Reverse quantity sign if reversed above

Line 853: FND_MSG_PUB.Add;

849: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
850: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
851: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_ic_item_mst_rec.item_um);
852: FND_MESSAGE.SET_TOKEN('TO_UOM',l_ic_item_mst_rec.item_um2);
853: FND_MSG_PUB.Add;
854: RAISE FND_API.G_EXC_ERROR;
855: END IF;
856: -- Reverse quantity sign if reversed above
857: IF l_neg_qty = 1

Line 895: FND_MSG_PUB.Add;

891: FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR');
892: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
893: FND_MESSAGE.SET_TOKEN('FROM_UOM',l_trans_rec.item_um2);
894: FND_MESSAGE.SET_TOKEN('TO_UOM',l_ic_item_mst_rec.item_um2);
895: FND_MSG_PUB.Add;
896: RAISE FND_API.G_EXC_ERROR;
897: ELSE
898: l_trans_rec.item_um2 :=l_ic_item_mst_rec.item_um2;
899: -- Reverse quantity sign if reversed above

Line 918: FND_MSG_PUB.Add;

914: FND_MESSAGE.SET_NAME('GMI','IC_API_QTY_TOLERANCE_ERROR');
915: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
916: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
917: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
918: FND_MSG_PUB.Add;
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921: END IF;
922: ELSE

Line 934: FND_MSG_PUB.Add;

930: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_QTY_NOT_NEG');
931: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
932: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
933: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
934: FND_MSG_PUB.Add;
935: RAISE FND_API.G_EXC_ERROR;
936: END IF;
937:
938: -- Check location inventory for becoming negative

Line 953: FND_MSG_PUB.Add;

949: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
950: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
951: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_trans_rec.from_whse_code);
952: FND_MESSAGE.SET_TOKEN('LOCATION',l_trans_rec.from_location);
953: FND_MSG_PUB.Add;
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956: END IF;
957:

Line 968: FND_MSG_PUB.Add;

964: FND_MESSAGE.SET_NAME('GMI','IC_API_DEC_NOT_ALLOWED');
965: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
966: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
967: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_ERROR;
970: ELSIF ((l_sy_reas_cds_rec.reason_type = 2) AND
971: (l_trans_rec.trans_qty > 0))
972: THEN

Line 977: FND_MSG_PUB.Add;

973: FND_MESSAGE.SET_NAME('GMI','IC_API_INC_NOT_ALLOWED');
974: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
975: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
976: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
977: FND_MSG_PUB.Add;
978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: END IF;
981:

Line 993: FND_MSG_PUB.Add;

989: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
990: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
991: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_trans_rec.from_whse_code);
992: FND_MESSAGE.SET_TOKEN('LOCATION',l_trans_rec.from_location);
993: FND_MSG_PUB.Add;
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996:
997: -- If moving inventory, check inventory at to warehouse /location

Line 1031: FND_MSG_PUB.Add;

1027: FND_MESSAGE.SET_NAME('GMI','IC_API_MOVE_STATUS_ERR');
1028: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
1029: FND_MESSAGE.SET_TOKEN('LOT_NO',l_trans_rec.lot_no);
1030: FND_MESSAGE.SET_TOKEN('SUBLOT_NO',l_trans_rec.sublot_no);
1031: FND_MSG_PUB.Add;
1032: RAISE FND_API.G_EXC_ERROR;
1033: END IF;
1034: ELSE
1035: l_trans_rec.lot_status := l_ic_loct_inv_rec_from.lot_status;

Line 1051: FND_MSG_PUB.Add;

1047: THEN
1048: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_STATUS');
1049: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_trans_rec.lot_status);
1050: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
1051: FND_MSG_PUB.Add;
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054: -- Check for unposted journals with different lot status
1055: IF Check_unposted_jnl_lot_status

Line 1066: FND_MSG_PUB.Add;

1062: THEN
1063: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_LOT_STATUS');
1064: FND_MESSAGE.SET_TOKEN('LOT_STATUS',l_trans_rec.lot_status);
1065: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
1066: FND_MSG_PUB.Add;
1067: RAISE FND_API.G_EXC_ERROR;
1068: END IF;
1069: END IF;
1070:

Line 1081: FND_MSG_PUB.Add;

1077: THEN
1078: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_QC_GRADE');
1079: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_trans_rec.qc_grade);
1080: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
1081: FND_MSG_PUB.Add;
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084: -- Check for unposted journals with different QC grade
1085: IF Check_unposted_jnl_qc_grade

Line 1094: FND_MSG_PUB.Add;

1090: THEN
1091: FND_MESSAGE.SET_NAME('GMI','IC_API_UNPOSTED_JNL_QC_GRADE');
1092: FND_MESSAGE.SET_TOKEN('QC_GRADE',l_trans_rec.qc_grade);
1093: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_trans_rec.item_no);
1094: FND_MSG_PUB.Add;
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097: END IF;
1098:

Line 1104: FND_MSG_PUB.Add;

1100: IF NOT GMA_VALID_GRP.Validate_co_code(l_trans_rec.co_code)
1101: THEN
1102: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_CO_CODE');
1103: FND_MESSAGE.SET_TOKEN('CO_CODE',l_trans_rec.co_code);
1104: FND_MSG_PUB.Add;
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107:
1108: -- Validate Organisation Code belongs to Company Code

Line 1115: FND_MSG_PUB.Add;

1111: )
1112: THEN
1113: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ORGN_CODE');
1114: FND_MESSAGE.SET_TOKEN('ORGN_CODE',l_trans_rec.orgn_code);
1115: FND_MSG_PUB.Add;
1116: RAISE FND_API.G_EXC_ERROR;
1117: END IF;
1118:
1119: -- Validate Transaction Date For Transactions

Line 1132: FND_MSG_PUB.Add;

1128: THEN
1129: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_CLOSED');
1130: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_trans_rec.item_no);
1131: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_trans_rec.trans_date);
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: ELSIF TRUNC(l_trans_rec.trans_date, 'DD') >
1135: TRUNC(SYSDATE, 'DD')
1136: THEN

Line 1140: FND_MSG_PUB.Add;

1136: THEN
1137: FND_MESSAGE.SET_NAME('GMI','IC_API_CANNOT_POST_FUTURE');
1138: FND_MESSAGE.SET_TOKEN('ITEM_NO' , l_trans_rec.item_no);
1139: FND_MESSAGE.SET_TOKEN('TRANS_DATE', l_trans_rec.trans_date);
1140: FND_MSG_PUB.Add;
1141: RAISE FND_API.G_EXC_ERROR;
1142: END IF;
1143:
1144: -- If no errors then move local trans_rec to output parameter

Line 1151: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1152: , p_data => x_msg_data
1153: );
1154:
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1157: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

1153: );
1154:
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1158: , p_data => x_msg_data
1159: );
1160: WHEN OTHERS THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1162: -- IF FND_MSG_PUB.check_msg_level

1158: , p_data => x_msg_data
1159: );
1160: WHEN OTHERS THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: -- IF FND_MSG_PUB.check_msg_level
1163: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1164: -- THEN
1165:
1166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 1163: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1159: );
1160: WHEN OTHERS THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: -- IF FND_MSG_PUB.check_msg_level
1163: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1164: -- THEN
1165:
1166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1167: , 'Validate_Inventory_posting'

Line 1166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1162: -- IF FND_MSG_PUB.check_msg_level
1163: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1164: -- THEN
1165:
1166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1167: , 'Validate_Inventory_posting'
1168: );
1169: -- END IF;
1170: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

Line 1170: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count

1166: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1167: , 'Validate_Inventory_posting'
1168: );
1169: -- END IF;
1170: FND_MSG_PUB.Count_AND_GET ( p_count => x_msg_count
1171: , p_data => x_msg_data
1172: );
1173:
1174: END Validate_Inventory_Posting;

Line 1241: -- IF FND_MSG_PUB.check_msg_level

1237: RETURN TRUE;
1238:
1239: EXCEPTION
1240: WHEN OTHERS THEN
1241: -- IF FND_MSG_PUB.check_msg_level
1242: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1243: -- THEN
1244:
1245: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 1242: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1238:
1239: EXCEPTION
1240: WHEN OTHERS THEN
1241: -- IF FND_MSG_PUB.check_msg_level
1242: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1243: -- THEN
1244:
1245: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1246: , 'Insert_IC_JRNL_MST'

Line 1245: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1241: -- IF FND_MSG_PUB.check_msg_level
1242: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1243: -- THEN
1244:
1245: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1246: , 'Insert_IC_JRNL_MST'
1247: );
1248: -- END IF;
1249: RETURN FALSE;

Line 1348: -- IF FND_MSG_PUB.check_msg_level

1344: RETURN TRUE;
1345:
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: -- IF FND_MSG_PUB.check_msg_level
1349: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1350: -- THEN
1351:
1352: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 1349: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1345:
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: -- IF FND_MSG_PUB.check_msg_level
1349: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1350: -- THEN
1351:
1352: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1353: , 'Insert_IC_ADJS_JNL'

Line 1352: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1348: -- IF FND_MSG_PUB.check_msg_level
1349: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1350: -- THEN
1351:
1352: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1353: , 'Insert_IC_ADJS_JNL'
1354: );
1355: -- END IF;
1356: RETURN FALSE;