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

Line 307: FND_MSG_PUB.initialize;

303: /* Check p_init_msg_list
304: =========================================*/
305: IF FND_API.to_boolean(p_init_msg_list)
306: THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309:
310:
311: /*Move allocation record to local variable

Line 360: FND_MSG_PUB.Add;

356: PrintMsg('ERROR - Validation failed on action_code Only ');
357: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_ACTION_CODE');
358: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
359: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
360: FND_MSG_PUB.Add;
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: /*====================================

Line 380: FND_MSG_PUB.Add;

376: l_error_flag := FND_API.G_TRUE;
377: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_ID_REQUIRED');
378: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
379: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
380: FND_MSG_PUB.Add;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;
383: ELSIF( NVL(l_tran_rec.trans_id,0) <> 0)
384: THEN

Line 390: FND_MSG_PUB.Add;

386: l_error_flag := FND_API.G_TRUE;
387: FND_MESSAGE.SET_NAME('GMI','GMI_API_TRANS_ID_NOT_REQUIRED');
388: FND_MESSAGE.SET_TOKEN('ACTION_CODE ',l_tran_rec.action_code );
389: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
390: FND_MSG_PUB.Add;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: IF( UPPER(NVL(l_tran_rec.action_code,'N')) IN ('DELETE','UPDATE') AND

Line 409: FND_MSG_PUB.Add;

405: l_error_flag := FND_API.G_TRUE;
406: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_TRANS_ID');
407: FND_MESSAGE.SET_TOKEN('TRANS_ID',l_tran_rec.trans_id );
408: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.LINE_ID );
409: FND_MSG_PUB.Add;
410: RAISE FND_API.G_EXC_ERROR;
411: ELSIF (l_delete_mark = 1)
412: THEN
413: CLOSE validate_trans_id_cur;

Line 419: FND_MSG_PUB.Add;

415: l_error_flag := FND_API.G_TRUE;
416: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_DELETED');
417: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
418: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
419: FND_MSG_PUB.Add;
420: RAISE FND_API.G_EXC_ERROR;
421: ELSIF (l_completed_ind = 1)
422: THEN
423: CLOSE validate_trans_id_cur;

Line 429: FND_MSG_PUB.Add;

425: l_error_flag := FND_API.G_TRUE;
426: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_COMPLETED');
427: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
428: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_ERROR;
431: ELSIF (l_staged_ind = 1)
432: THEN
433: CLOSE validate_trans_id_cur;

Line 439: FND_MSG_PUB.Add;

435: l_error_flag := FND_API.G_TRUE;
436: FND_MESSAGE.SET_NAME('GML','GMI_API_TRANS_STAGED');
437: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id );
438: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id );
439: FND_MSG_PUB.Add;
440: RAISE FND_API.G_EXC_ERROR;
441: END IF;
442:
443:

Line 458: FND_MSG_PUB.Add;

454: PrintMsg('ERROR - validation failed on line id');
455: l_error_flag := FND_API.G_TRUE;
456: FND_MESSAGE.SET_NAME('GMI','MISSING');
457: FND_MESSAGE.SET_TOKEN('MISSING','line_id');
458: FND_MSG_PUB.Add;
459: RAISE FND_API.G_EXC_ERROR;
460: ELSE
461:
462: OPEN oe_order_lines_cur(l_tran_rec.line_id);

Line 474: FND_MSG_PUB.Add;

470: l_error_flag := FND_API.G_TRUE;
471: CLOSE oe_order_lines_cur;
472: FND_MESSAGE.SET_NAME('GML','GMI_API_INVALID_LINE_ID');
473: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
474: FND_MSG_PUB.Add;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:
478: PrintMsg('Quantity1 on the Sales Order Line is : '|| l_ordered_quantity);

Line 500: FND_MSG_PUB.Add;

496: l_error_flag := FND_API.G_TRUE;
497: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_STATUS');
498: FND_MESSAGE.SET_TOKEN('LINE_STATUS ',l_line_status);
499: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
500: FND_MSG_PUB.Add;
501: RAISE FND_API.G_EXC_ERROR;
502:
503: END IF;
504:

Line 543: FND_MSG_PUB.Add; / Define this message /

539: l_error_flag := FND_API.G_TRUE;
540: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LINE_DETAIL_ID');
541: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
542: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
543: FND_MSG_PUB.Add; /**** Define this message ****/
544: RAISE FND_API.G_EXC_ERROR;
545: END IF;
546:
547: l_pick_lots_rec.line_detail_id := l_tran_rec.line_detail_id;

Line 583: FND_MSG_PUB.Add;

579: l_tran_rec.line_id || 'Please specify one');
580: l_error_flag := FND_API.G_TRUE;
581: FND_MESSAGE.SET_NAME('GMI','MISSING');
582: FND_MESSAGE.SET_TOKEN('MISSING','Line_detail_id');
583: FND_MSG_PUB.Add;
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF (l_count = 1)
586: THEN
587: OPEN line_detail_id_cur(l_tran_rec.line_id);

Line 598: FND_MSG_PUB.Add;

594: l_error_flag := FND_API.G_TRUE;
595: CLOSE line_detail_id_cur;
596: FND_MESSAGE.SET_NAME('GMI','MISSING');
597: FND_MESSAGE.SET_TOKEN('MISSING','Line_detail_id');
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_ERROR;
600:
601: END IF;
602:

Line 638: FND_MSG_PUB.Add;

634: FND_MESSAGE.SET_TOKEN('REASON_CODE ',l_tran_rec.reason_code);
635: FND_MESSAGE.SET_TOKEN('LINE_ID ',l_tran_rec.line_id);
636: FND_MESSAGE.SET_TOKEN('TRANS_ID ',l_tran_rec.trans_id);
637: FND_MESSAGE.SET_TOKEN('LINE_DETAIL_ID ',l_tran_rec.line_detail_id);
638: FND_MSG_PUB.Add;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641:
642: IF(reas_code_cur%ISOPEN)

Line 668: FND_MSG_PUB.Add;

664: l_error_flag := FND_API.G_TRUE;
665: FND_MESSAGE.SET_NAME('GMI','GMI_API_WHSE_NOT_FOUND');
666: FND_MESSAGE.SET_TOKEN('ORG', l_ship_from_org_id);
667: FND_MESSAGE.SET_TOKEN('LINE_ID', l_tran_rec.line_id);
668: FND_MSG_PUB.Add;
669: RAISE FND_API.G_EXC_ERROR;
670: ELSE
671: CLOSE ic_whse_mst_cur;
672: END IF;

Line 701: FND_MSG_PUB.Add;

697: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
698: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
699: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
700: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
701: FND_MSG_PUB.Add;
702: RAISE FND_API.G_EXC_ERROR;
703: END IF;
704:
705: PrintMsg('l_ic_item_mst_rec.dualum_ind : '|| l_ic_item_mst_rec.dualum_ind);

Line 720: FND_MSG_PUB.Add;

716: l_error_flag := FND_API.G_TRUE;
717: FND_MESSAGE.SET_NAME('GMI','GMI_API_NONINV_ITEM');
718: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
719: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
720: FND_MSG_PUB.Add;
721: RAISE FND_API.G_EXC_ERROR;
722:
723: /* Must be active */
724: ELSIF (l_ic_item_mst_rec.inactive_ind = 1)

Line 731: FND_MSG_PUB.Add;

727: l_error_flag := FND_API.G_TRUE;
728: FND_MESSAGE.SET_NAME('GMI','GMI_API_INACTIVE_ITEM');
729: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
730: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
731: FND_MSG_PUB.Add;
732: RAISE FND_API.G_EXC_ERROR;
733:
734: /* Item should not be a no control item */
735: ELSIF (l_ic_item_mst_rec.lot_ctl = 0 AND (l_ic_item_mst_rec.loct_ctl = 0) )

Line 742: FND_MSG_PUB.Add;

738: l_error_flag := FND_API.G_TRUE;
739: FND_MESSAGE.SET_NAME('GMI','GMI_API_NO_CONTROL_ITEM');
740: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
741: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
742: FND_MSG_PUB.Add;
743: RAISE FND_API.G_EXC_ERROR;
744:
745: END IF;
746:

Line 771: FND_MSG_PUB.Add;

767: l_error_flag := FND_API.G_TRUE;
768: FND_MESSAGE.SET_NAME('GMI','GMI_API_NOT_LOT_CONTROL_ITEM');
769: FND_MESSAGE.SET_TOKEN('ITEM_NO_',l_ic_item_mst_rec.item_no);
770: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
771: FND_MSG_PUB.Add;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775: IF( NVL(p_tran_rec.sublot_no,' ') <> ' ' AND

Line 784: FND_MSG_PUB.Add;

780: l_error_flag := FND_API.G_TRUE;
781: FND_MESSAGE.SET_NAME('GMI','GMI_API_SUBLOT_NOT_REQUIRED');
782: FND_MESSAGE.SET_TOKEN('ITEM_NO', l_ic_item_mst_rec.item_no);
783: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
784: FND_MSG_PUB.Add;
785: RAISE FND_API.G_EXC_ERROR;
786: END IF;
787:
788: l_pick_lots_rec.item_id := l_ic_item_mst_rec.item_id;

Line 809: FND_MSG_PUB.Add;

805: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
806: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
807: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
808: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:
813:

Line 825: FND_MSG_PUB.Add;

821: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCATION_REQUIRED');
822: FND_MESSAGE.SET_TOKEN('ITEM_NO',l_ic_item_mst_rec.item_no);
823: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
824: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
825: FND_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829:

Line 843: FND_MSG_PUB.Add;

839: l_error_flag := FND_API.G_TRUE;
840: FND_MESSAGE.SET_NAME('GMI','GMI_API_LOCT_INVALID_LENGTH');
841: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
842: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
843: FND_MSG_PUB.Add;
844: RAISE FND_API.G_EXC_ERROR;
845: END IF;
846:
847: /* This is not a non validated location */

Line 865: FND_MSG_PUB.Add;

861: l_error_flag := FND_API.G_TRUE;
862: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVALID_LOCATION');
863: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
864: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
865: FND_MSG_PUB.Add;
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868:
869: IF (l_loc_inactive = 1)

Line 876: FND_MSG_PUB.Add;

872: l_error_flag := FND_API.G_TRUE;
873: FND_MESSAGE.SET_NAME('GMI','IC_API_INACTIVE_LOCATION');
874: FND_MESSAGE.SET_TOKEN('LOCATION',l_tran_rec.location);
875: FND_MESSAGE.SET_TOKEN('LINE_ID',l_tran_rec.line_id);
876: FND_MSG_PUB.Add;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879:
880: END IF; /* non validated location */

Line 915: FND_MSG_PUB.Add;

911: FND_MESSAGE.Set_Token('SUBLOT_NO', l_tran_rec.sublot_no);
912: FND_MESSAGE.Set_Token('LOT_ID', l_tran_rec.lot_id);
913: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
914: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
915: FND_MSG_PUB.Add;
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918:
919: l_tran_rec.lot_no := l_ic_lots_mst_rec.lot_no;

Line 931: FND_MSG_PUB.Add;

927: FND_MESSAGE.Set_Name('GMI','GMI_API_INACTIVE_LOT');
928: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
929: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
930: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
931: FND_MSG_PUB.Add;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:
935: /* Is it expired? */

Line 945: FND_MSG_PUB.Add;

941: FND_MESSAGE.Set_Name('GMI','GMI_API_EXPIRED_LOT');
942: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
943: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
944: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
945: FND_MSG_PUB.Add;
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948:
949: /* Is it Deleted? */

Line 959: FND_MSG_PUB.Add;

955: FND_MESSAGE.Set_Name('GMI','GMI_API_DELETED_LOT');
956: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
957: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
958: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
959: FND_MSG_PUB.Add;
960: RAISE FND_API.G_EXC_ERROR;
961: END IF;
962:
963: -- BEGIN BUG 2966077

Line 973: FND_MSG_PUB.Add;

969: FND_MESSAGE.Set_Name('GMI','IC_INVALID_QC_GRADE');
970: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
971: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
972: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
973: FND_MSG_PUB.Add;
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: --END BUG 2966077
977:

Line 1022: --FND_MSG_PUB.Add;

1018: --l_error_flag := FND_API.G_TRUE;
1019: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1020: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1021: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);
1022: --FND_MSG_PUB.Add;
1023: --RAISE FND_API.G_EXC_ERROR;
1024: ELSE
1025: CLOSE get_loct_inv_dtls_cur2;
1026: END IF;

Line 1036: --FND_MSG_PUB.Add;

1032: --l_error_flag := FND_API.G_TRUE;
1033: --FND_MESSAGE.Set_Name('GMI','GMI_API_NO_INVENTORY');
1034: --FND_MESSAGE.Set_Token('item_no', l_ic_item_mst_rec.item_no);
1035: --FND_MESSAGE.Set_Token('lot_no', l_tran_rec.lot_no);
1036: --FND_MSG_PUB.Add;
1037: --RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039:
1040: ELSE

Line 1066: FND_MSG_PUB.Add;

1062: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_STATUS_NOT_FOUND');
1063: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1064: FND_MESSAGE.Set_Token('LOT_STATUS', l_loct_inv_rec.lot_status);
1065: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1066: FND_MSG_PUB.Add;
1067: RAISE FND_API.G_EXC_ERROR;
1068:
1069: ELSE
1070: CLOSE lot_status_cur;

Line 1080: FND_MSG_PUB.Add;

1076: l_error_flag := FND_API.G_TRUE;
1077: FND_MESSAGE.SET_NAME('GMI','GMI_API_REJECTED_LOT');
1078: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1079: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1080: FND_MSG_PUB.Add;
1081: RAISE FND_API.G_EXC_ERROR;
1082:
1083: END IF;
1084:

Line 1092: FND_MSG_PUB.Add;

1088: l_error_flag := FND_API.G_TRUE;
1089: FND_MESSAGE.SET_NAME('GMI', 'GMI_API_LOT_NOT_ORDERABLE');
1090: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1091: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1092: FND_MSG_PUB.Add;
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;
1095:
1096: IF(l_lot_status_rec.nettable_ind <> 1)

Line 1103: FND_MSG_PUB.Add;

1099: l_error_flag := FND_API.G_TRUE;
1100: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_NETTABLE');
1101: FND_MESSAGE.Set_Token('LOT_NO', l_tran_rec.lot_no);
1102: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1103: FND_MSG_PUB.Add;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106:
1107: END IF; /* Status_ctl >0 */

Line 1135: FND_MSG_PUB.Add;

1131: l_error_flag := FND_API.G_TRUE;
1132: FND_MESSAGE.Set_Name('GMI','GMI_API_UOM_REQUIRED');
1133: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1134: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1135: FND_MSG_PUB.Add;
1136: RAISE FND_API.G_EXC_ERROR;
1137:
1138: ELSE /* l_tran_rec.trans_um is NOT NULL */
1139:

Line 1154: FND_MSG_PUB.Add;

1150: l_error_flag := FND_API.G_TRUE;
1151: FND_MESSAGE.Set_Name('GMI','GMI_API_APPS_UOM_NOT_FOUND');
1152: FND_MESSAGE.Set_Token('OPM_UOM',l_ic_item_mst_rec.item_um);
1153: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1154: FND_MSG_PUB.Add;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;
1157:
1158:

Line 1175: FND_MSG_PUB.Add;

1171: l_error_flag := FND_API.G_TRUE;
1172: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');
1173: FND_MESSAGE.Set_Token('APPS_UOM', l_tran_rec.trans_um);
1174: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1175: FND_MSG_PUB.Add;
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178: PrintMsg('to uom (OPM) '||l_opm_um);
1179:

Line 1206: FND_MSG_PUB.Add;

1202: FND_MESSAGE.Set_Token('FROM_UOM', l_opm_um);
1203: FND_MESSAGE.Set_Token('TO_UOM', l_ic_item_mst_rec.item_um);
1204: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1205: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1206: FND_MSG_PUB.Add;
1207: RAISE FND_API.G_EXC_ERROR;
1208:
1209: ELSE
1210: l_pick_lots_rec.trans_qty := l_tmp_qty;

Line 1267: FND_MSG_PUB.Add;

1263: l_error_flag := FND_API.G_TRUE;
1264: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY2_REQUIRED_DUAL3');
1265: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1266: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1267: FND_MSG_PUB.Add;
1268: RAISE FND_API.G_EXC_ERROR;
1269: END IF;
1270:
1271: ELSE /* trans_qty2 is not 0,in this case check deviation */

Line 1282: FND_MSG_PUB.Add;

1278: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1279: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1280: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1281: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1282: FND_MSG_PUB.Add;
1283: RAISE FND_API.G_EXC_ERROR;
1284:
1285: ELSIF (nvl(l_ic_item_mst_rec.deviation_lo,0)<>0 AND
1286: l_tran_rec.trans_qty2 < l_tmp_qty2 * (1-l_ic_item_mst_rec.deviation_lo)) THEN

Line 1294: FND_MSG_PUB.Add;

1290: FND_MESSAGE.Set_Token('QTY', l_pick_lots_rec.trans_qty);
1291: FND_MESSAGE.Set_Token('QTY2', l_tran_rec.trans_qty2);
1292: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1293: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1294: FND_MSG_PUB.Add;
1295: RAISE FND_API.G_EXC_ERROR;
1296:
1297: END IF;
1298:

Line 1321: FND_MSG_PUB.Add;

1317: l_error_flag := FND_API.G_TRUE;
1318: FND_MESSAGE.Set_Name('GMI','GMI_API_QTY_REQ_FOR_ACT_CODE');
1319: FND_MESSAGE.Set_Token('ACTION_CODE', l_tran_rec.action_code);
1320: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1321: FND_MSG_PUB.Add;
1322: RAISE FND_API.G_EXC_ERROR;
1323: END IF;
1324:
1325: OPEN get_commited_qty_cur;

Line 1363: FND_MSG_PUB.Add;

1359: PrintMsg('ERROR - -ve inventory is not allowed. This allocation would drive the inventory -ve. ');
1360: l_error_flag := FND_API.G_TRUE;
1361: FND_MESSAGE.SET_NAME('GMI','GMI_API_INVQTYNEG');
1362: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1363: FND_MSG_PUB.Add;
1364: RAISE FND_API.G_EXC_ERROR;
1365:
1366: ELSIF(l_allow_negative_inv = 2) THEN
1367: PrintMsg('Warning - This allocation would drive the inventory -ve. ');

Line 1370: FND_MSG_PUB.Add;

1366: ELSIF(l_allow_negative_inv = 2) THEN
1367: PrintMsg('Warning - This allocation would drive the inventory -ve. ');
1368: FND_MESSAGE.SET_NAME('GMI','GMI_API_WARNINVQTYNEG');
1369: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1370: FND_MSG_PUB.Add;
1371: END IF;
1372: END IF;
1373: END IF; /* Check -ve inventory */
1374:

Line 1458: FND_MSG_PUB.Add;

1454: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_INDIV_NO_OVEPIC');
1455: FND_MESSAGE.Set_Token('LOT_NO', l_ic_lots_mst_rec.lot_no);
1456: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1457: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1458: FND_MSG_PUB.Add;
1459: RAISE FND_API.G_EXC_ERROR;
1460:
1461: END IF;
1462: ELSIF ( (l_pick_lots_rec.trans_qty > l_available_qty) OR

Line 1534: FND_MSG_PUB.Add;

1530: l_error_flag := FND_API.G_TRUE;
1531: FND_MESSAGE.Set_Name('GMI','GMI_API_OPM_UOM_NOT_FOUND');
1532: FND_MESSAGE.Set_Token('APPS_UOM', l_ordered_quantity_uom);
1533: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1534: FND_MSG_PUB.Add;
1535: RAISE FND_API.G_EXC_ERROR;
1536: END IF;
1537:
1538: GMICUOM.icuomcv(

Line 1593: FND_MSG_PUB.Add;

1589: l_error_flag := FND_API.G_TRUE;
1590: FND_MESSAGE.Set_Name('GMI','GMI_API_OVERPICK_NOT_ALLOWED');
1591: FND_MESSAGE.Set_Token('ITEM_NO', l_ic_item_mst_rec.item_no);
1592: FND_MESSAGE.Set_Token('LINE_ID', l_tran_rec.line_id);
1593: FND_MSG_PUB.Add;
1594: RAISE FND_API.G_EXC_ERROR;
1595: END IF;
1596:
1597: END IF; /* Over pick not enabled */

Line 1632: FND_MSG_PUB.Add;

1628: IF l_return_val <> 0 THEN
1629:
1630: IF l_return_val = GMICCAL.INVCAL_FISCALYR_ERR THEN
1631: FND_MESSAGE.SET_NAME('GMI','IC_CAL_FISCALYR_ERR');
1632: FND_MSG_PUB.Add;
1633: ELSIF l_return_val = GMICCAL.INVCAL_PERIOD_ERR THEN
1634: FND_MESSAGE.SET_NAME('GMI','IC_CAL_CLOSED_IND_ERR');
1635: FND_MSG_PUB.Add;
1636: ELSIF l_return_val = GMICCAL.INVCAL_ORGN_PARM_ERR THEN

Line 1635: FND_MSG_PUB.Add;

1631: FND_MESSAGE.SET_NAME('GMI','IC_CAL_FISCALYR_ERR');
1632: FND_MSG_PUB.Add;
1633: ELSIF l_return_val = GMICCAL.INVCAL_PERIOD_ERR THEN
1634: FND_MESSAGE.SET_NAME('GMI','IC_CAL_CLOSED_IND_ERR');
1635: FND_MSG_PUB.Add;
1636: ELSIF l_return_val = GMICCAL.INVCAL_ORGN_PARM_ERR THEN
1637: FND_MESSAGE.SET_NAME('GMI','IC_INVALID_ORGN_ERR');
1638: FND_MSG_PUB.Add;
1639: ELSIF l_return_val = GMICCAL.INVCAL_CO_ERR THEN

Line 1638: FND_MSG_PUB.Add;

1634: FND_MESSAGE.SET_NAME('GMI','IC_CAL_CLOSED_IND_ERR');
1635: FND_MSG_PUB.Add;
1636: ELSIF l_return_val = GMICCAL.INVCAL_ORGN_PARM_ERR THEN
1637: FND_MESSAGE.SET_NAME('GMI','IC_INVALID_ORGN_ERR');
1638: FND_MSG_PUB.Add;
1639: ELSIF l_return_val = GMICCAL.INVCAL_CO_ERR THEN
1640: FND_MESSAGE.SET_NAME('GMI','IC_COCODEERR');
1641: FND_MSG_PUB.Add;
1642: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_PARM_ERR THEN

Line 1641: FND_MSG_PUB.Add;

1637: FND_MESSAGE.SET_NAME('GMI','IC_INVALID_ORGN_ERR');
1638: FND_MSG_PUB.Add;
1639: ELSIF l_return_val = GMICCAL.INVCAL_CO_ERR THEN
1640: FND_MESSAGE.SET_NAME('GMI','IC_COCODEERR');
1641: FND_MSG_PUB.Add;
1642: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_PARM_ERR THEN
1643: FND_MESSAGE.SET_NAME('GMI','IC_BLANKWHSE');
1644: FND_MSG_PUB.Add;
1645: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_ERR THEN

Line 1644: FND_MSG_PUB.Add;

1640: FND_MESSAGE.SET_NAME('GMI','IC_COCODEERR');
1641: FND_MSG_PUB.Add;
1642: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_PARM_ERR THEN
1643: FND_MESSAGE.SET_NAME('GMI','IC_BLANKWHSE');
1644: FND_MSG_PUB.Add;
1645: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_ERR THEN
1646: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
1647: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
1648: FND_MSG_PUB.Add;

Line 1648: FND_MSG_PUB.Add;

1644: FND_MSG_PUB.Add;
1645: ELSIF l_return_val = GMICCAL.INVCAL_WHSE_ERR THEN
1646: FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_CODE');
1647: FND_MESSAGE.SET_TOKEN('WHSE_CODE',l_ic_whse_mst_rec.whse_code);
1648: FND_MSG_PUB.Add;
1649: ELSIF l_return_val IN (GMICCAL.INVCAL_PERIOD_CLOSED,
1650: GMICCAL.INVCAL_WHSE_CLOSED) THEN
1651:
1652: FND_MESSAGE.SET_NAME('GMI','IC_API_TXN_POST_CLOSED');

Line 1655: FND_MSG_PUB.Add;

1651:
1652: FND_MESSAGE.SET_NAME('GMI','IC_API_TXN_POST_CLOSED');
1653: FND_MESSAGE.SET_TOKEN('DATE',l_tran_rec.trans_date);
1654: FND_MESSAGE.SET_TOKEN('WAREH',l_ic_whse_mst_rec.whse_code);
1655: FND_MSG_PUB.Add;
1656: ELSE
1657: FND_MESSAGE.SET_NAME('GMI','ICCAL_GENL_ERR');
1658: FND_MSG_PUB.Add;
1659: END IF;

Line 1658: FND_MSG_PUB.Add;

1654: FND_MESSAGE.SET_TOKEN('WAREH',l_ic_whse_mst_rec.whse_code);
1655: FND_MSG_PUB.Add;
1656: ELSE
1657: FND_MESSAGE.SET_NAME('GMI','ICCAL_GENL_ERR');
1658: FND_MSG_PUB.Add;
1659: END IF;
1660: l_error_flag := FND_API.G_TRUE;
1661: RAISE FND_API.G_EXC_ERROR;
1662: END IF;

Line 1692: FND_MSG_PUB.Add;

1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: FND_MESSAGE.Set_Name('GMI','GMI_SET_PIC_LOTS_ERROR');
1690: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_ship_from_org_id);
1691: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
1692: FND_MSG_PUB.Add;
1693: RAISE FND_API.G_EXC_ERROR;
1694: RETURN;
1695: ELSE
1696: PrintMsg('Successfully returning from Allocate_OPM_Orders');

Line 1709: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1705:
1706:
1707: x_return_status := FND_API.G_RET_STS_ERROR;
1708:
1709: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1710: , l_api_name
1711: );
1712: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1713: , p_count => x_msg_count

Line 1712: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

1708:
1709: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1710: , l_api_name
1711: );
1712: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1713: , p_count => x_msg_count
1714: , p_data => x_msg_data
1715: );
1716:

Line 1721: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1718: ROLLBACK TO SAVEPOINT Allocate_Opm_Orders_SP;
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720:
1721: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1722: , l_api_name
1723: );
1724: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1725: , p_count => x_msg_count

Line 1724: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1720:
1721: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1722: , l_api_name
1723: );
1724: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1725: , p_count => x_msg_count
1726: , p_data => x_msg_data
1727: );
1728: WHEN OTHERS THEN

Line 1730: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1726: , p_data => x_msg_data
1727: );
1728: WHEN OTHERS THEN
1729: ROLLBACK TO SAVEPOINT Allocate_Opm_Orders_SP;
1730: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1731: , l_api_name
1732: );
1733:
1734: /* Get message count and data */

Line 1735: FND_MSG_PUB.count_and_get

1731: , l_api_name
1732: );
1733:
1734: /* Get message count and data */
1735: FND_MSG_PUB.count_and_get
1736: ( p_count => x_msg_count
1737: , p_data => x_msg_data
1738: );
1739:

Line 1815: FND_MSG_PUB.Add;

1811: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1812: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1813: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1814: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1815: FND_MSG_PUB.Add;
1816:
1817: RAISE FND_API.G_EXC_ERROR;
1818:
1819: END IF;

Line 1839: FND_MSG_PUB.Add;

1835: FND_MESSAGE.Set_Name('GMI','GMI_API_LOT_NOT_FOUND');
1836: FND_MESSAGE.Set_Token('LOT_NO', p_lot_no);
1837: FND_MESSAGE.Set_Token('SUBLOT_NO', p_sublot_no);
1838: FND_MESSAGE.Set_Token('LOT_ID', p_lot_id);
1839: FND_MSG_PUB.Add;
1840:
1841: RAISE FND_API.G_EXC_ERROR;
1842:
1843: END IF;

Line 1855: FND_MSG_PUB.count_and_get

1851: EXCEPTION
1852: WHEN FND_API.G_EXC_ERROR THEN
1853: x_return_status := FND_API.G_RET_STS_ERROR;
1854: /* Get message count and data */
1855: FND_MSG_PUB.count_and_get
1856: ( p_count => x_msg_count
1857: , p_data => x_msg_data
1858: );
1859:

Line 1863: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1859:
1860: WHEN OTHERS THEN
1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1862:
1863: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1864: , l_api_name
1865: );
1866:
1867: /* Get message count and data */

Line 1868: FND_MSG_PUB.count_and_get

1864: , l_api_name
1865: );
1866:
1867: /* Get message count and data */
1868: FND_MSG_PUB.count_and_get
1869: ( p_count => x_msg_count
1870: , p_data => x_msg_data
1871: );
1872:

Line 1935: FND_MSG_PUB.Add;

1931: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
1932: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1933: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1934:
1935: FND_MSG_PUB.Add;
1936: RAISE FND_API.G_EXC_ERROR;
1937: ELSE
1938: CLOSE ic_item_mst_cur;
1939: PrintMsg(' Item_no = '|| x_ic_item_mst_rec.item_no);

Line 1946: FND_MSG_PUB.count_and_get

1942: EXCEPTION
1943: WHEN FND_API.G_EXC_ERROR THEN
1944: x_return_status := FND_API.G_RET_STS_ERROR;
1945: /* Get message count and data */
1946: FND_MSG_PUB.count_and_get
1947: ( p_count => x_msg_count
1948: , p_data => x_msg_data
1949: );
1950:

Line 1953: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1949: );
1950:
1951: WHEN OTHERS THEN
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1954: , l_api_name
1955: );
1956:
1957: /* Get message count and data */

Line 1958: FND_MSG_PUB.count_and_get

1954: , l_api_name
1955: );
1956:
1957: /* Get message count and data */
1958: FND_MSG_PUB.count_and_get
1959: ( p_count => x_msg_count
1960: , p_data => x_msg_data
1961: );
1962: