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

Line 131: FND_MSG_PUB.Add;

127: THEN
128: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, organization_id missing ');
129: FND_MESSAGE.Set_Name('GMI','MISSING');
130: FND_MESSAGE.Set_Token('MISSING', 'Organization_id');
131: FND_MSG_PUB.Add;
132: raise FND_API.G_EXC_ERROR;
133: END IF;
134:
135: /* Begin - Bug 2418860 */

Line 144: FND_MSG_PUB.Add;

140: THEN
141: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, demand_source_header_id missing ');
142: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
143: FND_MESSAGE.Set_Token('MISSING', 'demand_source_header_id');
144: FND_MSG_PUB.Add;
145: raise FND_API.G_EXC_ERROR;
146: END IF;
147: */
148: /* End - Bug 2418860 */

Line 157: FND_MSG_PUB.Add;

153: THEN
154: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(q): Error, demand_source_line_id missing ');
155: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
156: FND_MESSAGE.Set_Token('MISSING', 'demand_source_line_id');
157: FND_MSG_PUB.Add;
158: raise FND_API.G_EXC_ERROR;
159: END IF;
160: ELSIF p_event = 'CREATE' THEN
161: /* =======================================================================

Line 181: FND_MSG_PUB.Add;

177: OR p_rec_to_check.organization_id = FND_API.G_MISS_NUM )
178: THEN
179: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
180: FND_MESSAGE.Set_Token('MISSING', 'Organization_id');
181: FND_MSG_PUB.Add;
182: raise FND_API.G_EXC_ERROR;
183: END IF;
184:
185: /* Begin - Bug 2418860 */

Line 194: FND_MSG_PUB.Add;

190: OR p_rec_to_check.demand_source_header_id = FND_API.G_MISS_NUM )
191: THEN
192: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
193: FND_MESSAGE.Set_Token('MISSING', 'demand_source_header_id');
194: FND_MSG_PUB.Add;
195: raise FND_API.G_EXC_ERROR;
196: END IF;
197: */
198: /* End - Bug 2418860 */

Line 207: FND_MSG_PUB.Add;

203: OR p_rec_to_check.demand_source_line_id = FND_API.G_MISS_NUM )
204: THEN
205: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
206: FND_MESSAGE.Set_Token('MISSING', 'demand_source_line_id');
207: FND_MSG_PUB.Add;
208: raise FND_API.G_EXC_ERROR;
209: END IF;
210:
211: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(c): Check demand_source_type_id ');

Line 218: FND_MSG_PUB.Add;

214: OR p_rec_to_check.demand_source_type_id = FND_API.G_MISS_NUM )
215: THEN
216: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
217: FND_MESSAGE.Set_Token('MISSING', 'demand_source_type_id');
218: FND_MSG_PUB.Add;
219: raise FND_API.G_EXC_ERROR;
220: END IF;
221:
222: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(c): Check inventory_item_id ');

Line 229: FND_MSG_PUB.Add;

225: OR p_rec_to_check.inventory_item_id = FND_API.G_MISS_NUM )
226: THEN
227: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
228: FND_MESSAGE.Set_Token('MISSING', 'inventory_item_id');
229: FND_MSG_PUB.Add;
230: raise FND_API.G_EXC_ERROR;
231: END IF;
232:
233: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(c): Check reservation_uom_code ');

Line 239: FND_MSG_PUB.Add;

235: OR p_rec_to_check.reservation_uom_code = FND_API.G_MISS_CHAR )
236: THEN
237: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
238: FND_MESSAGE.Set_Token('MISSING', 'reservation_uom_code');
239: FND_MSG_PUB.Add;
240: raise FND_API.G_EXC_ERROR;
241: END IF;
242:
243: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(c): Check reservation_quantity ');

Line 250: FND_MSG_PUB.Add;

246: OR p_rec_to_check.reservation_quantity = FND_API.G_MISS_NUM )
247: THEN
248: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
249: FND_MESSAGE.Set_Token('MISSING', 'reservation_quantity');
250: FND_MSG_PUB.Add;
251: raise FND_API.G_EXC_ERROR;
252: END IF;
253:
254: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Check_Mising(c): Check requirement_date ');

Line 260: FND_MSG_PUB.Add;

256: OR p_rec_to_check.requirement_date = FND_API.G_MISS_DATE )
257: THEN
258: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
259: FND_MESSAGE.Set_Token('MISSING', 'requirement_date');
260: FND_MSG_PUB.Add;
261: raise FND_API.G_EXC_ERROR;
262: END IF;
263: END IF;
264:

Line 271: FND_MSG_PUB.count_and_get

267: WHEN FND_API.G_EXC_ERROR THEN
268: x_return_status := FND_API.G_RET_STS_ERROR;
269:
270: /* Get message count and data */
271: FND_MSG_PUB.count_and_get
272: ( p_count => x_msg_count
273: , p_data => x_msg_data
274: );
275:

Line 281: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

277:
278: WHEN OTHERS THEN
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280:
281: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
282: , l_api_name
283: );
284:
285: /* Get message count and data */

Line 286: FND_MSG_Pub.Count_and_Get

282: , l_api_name
283: );
284:
285: /* Get message count and data */
286: FND_MSG_Pub.Count_and_Get
287: ( p_count => x_msg_count
288: , p_data => x_msg_data
289: );
290:

Line 346: /* FND_MSG_PUB.Add; */

342: ||p_query_input.demand_source_line_id||'.');
343: /* ================================================================*/
344: /* FND_MESSAGE.Set_Name('GMI','SO_Not_Found'); */
345: /* FND_MESSAGE.Set_Token('LINE_ID', p_query_input.demand_source_line_id); */
346: /* FND_MSG_PUB.Add; */
347: /* RAISE FND_API.G_EXC_ERROR; */
348: ELSE
349: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: inv_item_id='||l_inventory_item_id||'.');
350:

Line 368: FND_MSG_PUB.Add;

364: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
365: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
366: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_query_input.organization_id);
367: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
368: FND_MSG_PUB.Add;
369: CLOSE c_sales_order; -- Bug 3598280
370: raise FND_API.G_EXC_ERROR;
371: END IF;
372:

Line 392: FND_MSG_PUB.Add;

388: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
389: THEN
390: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
391: FND_MESSAGE.Set_Token('APPS_UOM_CODE', l_order_quantity_uom);
392: FND_MSG_PUB.Add;
393: CLOSE c_sales_order; -- Bug 3598280
394: RAISE FND_API.G_EXC_ERROR;
395: ELSE
396: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: uom1='||x_opm_um||'.');

Line 410: FND_MSG_Pub.count_and_get

406: x_error_code := SQLCODE;
407: /* End - Bug 2168710 */
408:
409: /* Get message count and data */
410: FND_MSG_Pub.count_and_get
411: ( p_count => x_msg_count
412: , p_data => x_msg_data
413: );
414:

Line 421: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

417: WHEN OTHERS THEN
418: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Error in Select='||SQLCODE||'.');
419: x_return_status := SQLCODE;
420:
421: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
422: , l_api_name
423: );
424:
425: /* Get message count and data */

Line 426: FND_MSG_Pub.count_and_get

422: , l_api_name
423: );
424:
425: /* Get message count and data */
426: FND_MSG_Pub.count_and_get
427: ( p_count => x_msg_count
428: , p_data => x_msg_data
429: );
430:

Line 490: FND_MSG_PUB.count_and_get

486: WHEN FND_API.G_EXC_ERROR THEN
487: x_return_status := FND_API.G_RET_STS_ERROR;
488:
489: /* Get message count and data */
490: FND_MSG_PUB.count_and_get
491: ( p_count => x_msg_count
492: , p_data => x_msg_data
493: );
494:

Line 498: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

494:
495: WHEN OTHERS THEN
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497:
498: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
499: , l_api_name
500: );
501:
502: /* Get message count and data */

Line 503: FND_MSG_PUB.count_and_get

499: , l_api_name
500: );
501:
502: /* Get message count and data */
503: FND_MSG_PUB.count_and_get
504: ( p_count => x_msg_count
505: , p_data => x_msg_data
506: );
507:

Line 669: FND_MSG_PUB.Add;

665: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
666: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
667: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
668: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
669: FND_MSG_PUB.Add;
670: raise FND_API.G_EXC_ERROR;
671: END IF;
672: ELSE
673: GMI_reservation_Util.PrintLn('(opm_dbg) Dont create the default lot again (Shouldnt be here) - 1 ! ');

Line 702: FND_MSG_PUB.Add;

698: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
699: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
700: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
701: FND_MESSAGE.Set_Token('WHERE', 'Create_Default_Lot');
702: FND_MSG_PUB.Add;
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705:
706: END IF;

Line 715: FND_MSG_PUB.count_and_get

711: WHEN FND_API.G_EXC_ERROR THEN
712: x_return_status := FND_API.G_RET_STS_ERROR;
713:
714: /* Get message count and data */
715: FND_MSG_PUB.count_and_get
716: ( p_count => x_msg_count
717: , p_data => x_msg_data
718: );
719:

Line 723: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

719:
720: WHEN OTHERS THEN
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
722:
723: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
724: , l_api_name
725: );
726:
727: /* Get message count and data */

Line 728: FND_MSG_PUB.count_and_get

724: , l_api_name
725: );
726:
727: /* Get message count and data */
728: FND_MSG_PUB.count_and_get
729: ( p_count => x_msg_count
730: , p_data => x_msg_data
731: );
732:

Line 824: FND_MSG_PUB.Add;

820: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Validation_Before_Allocate
821: ERROR:Returned by Get_Process_Org.');
822: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
823: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);
824: FND_MSG_PUB.Add;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828: x_allocation_rec.co_code := g_co_code;

Line 851: FND_MSG_PUB.Add;

847: ERROR:Returned by Get_OPM_item_from_Apps.');
848: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
849: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_mtl_rsv_rec.organization_id);
850: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_mtl_rsv_rec.inventory_item_id);
851: FND_MSG_PUB.Add;
852: RAISE FND_API.G_EXC_ERROR;
853: ELSE
854: x_allocation_rec.item_no := x_ic_item_mst_rec.item_no;
855: END IF;

Line 879: FND_MSG_PUB.Add;

875: CLOSE c_customer_and_so_info;
876: GMI_reservation_Util.PrintLn('(opm_dbg) in Util v: cust_no=NOTFOUND');
877: FND_MESSAGE.Set_Name('GMI','GMI_CUST_INFO');
878: FND_MESSAGE.Set_Token('SO_LINE_ID', x_allocation_rec.line_id);
879: FND_MSG_PUB.Add;
880: RAISE FND_API.G_EXC_ERROR;
881: ELSE
882: GMI_reservation_Util.PrintLn('(opm_dbg) in Util v: cust_no='||x_allocation_rec.cust_no||',
883: doc_line='||x_allocation_rec.doc_line);

Line 909: FND_MSG_PUB.Add;

905: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
906: THEN
907: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
908: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_mtl_rsv_rec.reservation_uom_code);
909: FND_MSG_PUB.Add;
910: RAISE FND_API.G_EXC_ERROR;
911: ELSE
912: GMI_reservation_Util.PrintLn('(opm_dbg) in Util v: uom1='||x_allocation_rec.order_um1||'.');
913: END IF;

Line 986: FND_MSG_PUB.count_and_get

982: GMI_Reservation_Util.PrintLn('Exiting Util validation_before_allocate: Error');
983: x_return_status := FND_API.G_RET_STS_ERROR;
984:
985: /* Get message count and data */
986: FND_MSG_PUB.count_and_get
987: ( p_count => x_msg_count
988: , p_data => x_msg_data
989: );
990:

Line 995: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

991: WHEN OTHERS THEN
992: GMI_Reservation_Util.PrintLn('Exiting Util validation_before_allocate: ErrorOther');
993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
994:
995: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
996: , l_api_name
997: );
998:
999: /* Get message count and data */

Line 1000: FND_MSG_PUB.count_and_get

996: , l_api_name
997: );
998:
999: /* Get message count and data */
1000: FND_MSG_PUB.count_and_get
1001: ( p_count => x_msg_count
1002: , p_data => x_msg_data
1003: );
1004:

Line 1060: FND_MSG_PUB.count_and_get

1056: WHEN FND_API.G_EXC_ERROR THEN
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058:
1059: /* Get message count and data */
1060: FND_MSG_PUB.count_and_get
1061: ( p_count => x_msg_count
1062: , p_data => x_msg_data
1063: );
1064:

Line 1068: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1064:
1065: WHEN OTHERS THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067:
1068: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1069: , l_api_name
1070: );
1071:
1072: /* Get message count and data */

Line 1073: FND_MSG_PUB.count_and_get

1069: , l_api_name
1070: );
1071:
1072: /* Get message count and data */
1073: FND_MSG_PUB.count_and_get
1074: ( p_count => x_msg_count
1075: , p_data => x_msg_data
1076: );
1077:

Line 1123: FND_MSG_PUB.Add;

1119:
1120: IF c_uom%NOTFOUND THEN
1121: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
1122: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_Apps_UOM);
1123: FND_MSG_PUB.Add;
1124: CLOSE c_uom; -- Bug 3598280
1125: RAISE FND_API.G_EXC_ERROR;
1126: END IF;
1127: CLOSE c_uom;

Line 1135: FND_MSG_PUB.count_and_get

1131: WHEN FND_API.G_EXC_ERROR THEN
1132: x_return_status := FND_API.G_RET_STS_ERROR;
1133:
1134: /* Get message count and data */
1135: FND_MSG_PUB.count_and_get
1136: ( p_count => x_msg_count
1137: , p_data => x_msg_data
1138: );
1139:

Line 1143: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1139:
1140: WHEN OTHERS THEN
1141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1142:
1143: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1144: , l_api_name
1145: );
1146:
1147: /* Get message count and data */

Line 1148: FND_MSG_PUB.count_and_get

1144: , l_api_name
1145: );
1146:
1147: /* Get message count and data */
1148: FND_MSG_PUB.count_and_get
1149: ( p_count => x_msg_count
1150: , p_data => x_msg_data
1151: );
1152:

Line 1200: FND_MSG_PUB.Add;

1196:
1197: IF c_uom%NOTFOUND THEN
1198: FND_MESSAGE.Set_Name('GMI','GMI_APPS_UOM_NOT_FOUND');
1199: FND_MESSAGE.Set_Token('OPM_UOM_CODE', p_OPM_UOM);
1200: FND_MSG_PUB.Add;
1201: CLOSE c_uom; -- Bug 3598280
1202: RAISE FND_API.G_EXC_ERROR;
1203: END IF;
1204: CLOSE c_uom;

Line 1212: FND_MSG_PUB.count_and_get

1208: WHEN FND_API.G_EXC_ERROR THEN
1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210:
1211: /* Get message count and data */
1212: FND_MSG_PUB.count_and_get
1213: ( p_count => x_msg_count
1214: , p_data => x_msg_data
1215: );
1216:

Line 1220: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1216:
1217: WHEN OTHERS THEN
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219:
1220: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1221: , l_api_name
1222: );
1223:
1224: /* Get message count and data */

Line 1225: FND_MSG_PUB.count_and_get

1221: , l_api_name
1222: );
1223:
1224: /* Get message count and data */
1225: FND_MSG_PUB.count_and_get
1226: ( p_count => x_msg_count
1227: , p_data => x_msg_data
1228: );
1229:

Line 1262: FND_MSG_PUB.Add;

1258:
1259: IF c_org%NOTFOUND THEN
1260: FND_MESSAGE.Set_Name('GMI','GMI_ORG_NOT_FOUND_IN_OE');
1261: FND_MESSAGE.Set_Token('SO_LINE_ID', p_oe_line_id);
1262: FND_MSG_PUB.Add;
1263: CLOSE c_org; -- Bug 3598280
1264: RAISE FND_API.G_EXC_ERROR;
1265: END IF;
1266: CLOSE c_org;

Line 1275: FND_MSG_PUB.count_and_get

1271: WHEN FND_API.G_EXC_ERROR THEN
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273:
1274: /* Get message count and data */
1275: FND_MSG_PUB.count_and_get
1276: ( p_count => x_msg_count
1277: , p_data => x_msg_data
1278: );
1279:

Line 1283: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1279:
1280: WHEN OTHERS THEN
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282:
1283: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1284: , l_api_name
1285: );
1286:
1287: /* Get message count and data */

Line 1288: FND_MSG_PUB.count_and_get

1284: , l_api_name
1285: );
1286:
1287: /* Get message count and data */
1288: FND_MSG_PUB.count_and_get
1289: ( p_count => x_msg_count
1290: , p_data => x_msg_data
1291: );
1292:

Line 1349: FND_MSG_PUB.Add;

1345: ||p_inventory_item_id||', org_id='||p_organization_id);
1346: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1347: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1348: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1349: FND_MSG_PUB.Add;
1350: CLOSE c_item; -- Bug 3598280
1351: RAISE FND_API.G_EXC_ERROR;
1352: ELSE
1353: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: item_no='||x_ic_item_mst_rec.item_no||'.');

Line 1363: FND_MSG_PUB.count_and_get

1359: WHEN FND_API.G_EXC_ERROR THEN
1360: x_return_status := FND_API.G_RET_STS_ERROR;
1361:
1362: /* Get message count and data */
1363: FND_MSG_PUB.count_and_get
1364: ( p_count => x_msg_count
1365: , p_data => x_msg_data
1366: );
1367:

Line 1371: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1367:
1368: WHEN OTHERS THEN
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1370:
1371: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1372: , l_api_name
1373: );
1374:
1375: /* Get message count and data */

Line 1376: FND_MSG_PUB.count_and_get

1372: , l_api_name
1373: );
1374:
1375: /* Get message count and data */
1376: FND_MSG_PUB.count_and_get
1377: ( p_count => x_msg_count
1378: , p_data => x_msg_data
1379: );
1380:

Line 1468: FND_MSG_PUB.Add;

1464:
1465: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
1466: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);
1467: FND_MESSAGE.Set_Token('WHERE', l_api_name);
1468: FND_MSG_PUB.Add;
1469: CLOSE c_sales_order_line; -- Bug 3598280
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: END IF;
1472: CLOSE c_sales_order_line;

Line 1579: FND_MSG_PUB.Add;

1575: GMI_Reservation_Util.printLn('return error from query reservation');
1576: FND_MESSAGE.Set_Name('GMI','GMI_QRY_RSV_FAILED');
1577: FND_MESSAGE.Set_Token('SO_LINE_ID', p_query_input.demand_source_line_id);
1578: FND_MESSAGE.Set_Token('WHERE', l_api_name);
1579: FND_MSG_PUB.Add;
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1581: END IF;
1582:
1583: GMI_Reservation_Util.printLn('After Query_Res, count='||l_reservation_count);

Line 1590: FND_MSG_PUB.Add;

1586: IF (l_reservation_count < 0)
1587: THEN
1588: GMI_Reservation_Util.printLn('Invalid value for reservation_count='||l_reservation_count);
1589: FND_MESSAGE.Set_Name('INV','INV_INVALID_COUNT');
1590: FND_MSG_PUB.Add;
1591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1592: END IF;
1593:
1594: GMI_Reservation_Util.printLn('As nothing reserved, need to build the default_lot rec_type,

Line 1628: FND_MSG_PUB.Add;

1624: GMI_reservation_Util.PrintLn('(opm_dbg) in Reallocate, ERROR:Returned by Get_Default_Lot.');
1625: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1626: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');
1627: FND_MESSAGE.Set_Token('WHERE','Reallocate');
1628: FND_MSG_PUB.Add;
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1631:
1632: GMI_reservation_Util.PrintLn('(opm_dbg) in Reallocate, qty='

Line 1697: FND_MSG_PUB.count_and_get

1693: GMI_Reservation_Util.printLn('End of GMI_Reservation.Reallocate. Error');
1694: x_return_status := FND_API.G_RET_STS_ERROR;
1695:
1696: /* Get message count and data */
1697: FND_MSG_PUB.count_and_get
1698: ( p_count => x_msg_count
1699: , p_data => x_msg_data
1700: );
1701:

Line 1707: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1703: ROLLBACK TO SAVEPOINT Reallocate_Transactions;
1704: GMI_Reservation_Util.printLn('End of GMI_Reservation.Reallocate. ErrorOthers');
1705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1706:
1707: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1708: , l_api_name
1709: );
1710:
1711: /* Get message count and data */

Line 1712: FND_MSG_PUB.count_and_get

1708: , l_api_name
1709: );
1710:
1711: /* Get message count and data */
1712: FND_MSG_PUB.count_and_get
1713: ( p_count => x_msg_count
1714: , p_data => x_msg_data
1715: );
1716:

Line 1769: FND_MSG_PUB.Add;

1765: GMI_reservation_Util.PrintLn('(opm_dbg) in Get_DefaultLot_from_ItemCtl, ERROR:Returned by Get_Default_Lot.');
1766: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1767: FND_MESSAGE.Set_Token('BY_PROC','GMI_Reservation_Util.Get_Default_Lot');
1768: FND_MESSAGE.Set_Token('WHERE','Get_DefaultLot_from_ItemCtl');
1769: FND_MSG_PUB.Add;
1770: RAISE FND_API.G_EXC_ERROR;
1771: END IF;
1772:
1773: /* ============================================================================================= */

Line 1793: FND_MSG_PUB.Add;

1789: GMI_Reservation_Util.printLn('(opm_dbg) in end of Get_DefaultLot_from_ItemCtl ERROR:Returned by Get_OPM_item_from_Apps.');
1790: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1791: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
1792: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
1793: FND_MSG_PUB.Add;
1794: RAISE FND_API.G_EXC_ERROR;
1795: END IF;
1796:
1797:

Line 1829: FND_MSG_PUB.count_and_get

1825: GMI_Reservation_Util.printLn('End of Get_DefaultLot_from_ItemCtl. Error');
1826: x_return_status := FND_API.G_RET_STS_ERROR;
1827:
1828: /* Get message count and data */
1829: FND_MSG_PUB.count_and_get
1830: ( p_count => x_msg_count
1831: , p_data => x_msg_data
1832: );
1833:

Line 1838: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1834: WHEN OTHERS THEN
1835: GMI_Reservation_Util.printLn('End of Get_DefaultLot_from_ItemCtl. ErrorOthers');
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837:
1838: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1839: , l_api_name
1840: );
1841:
1842: /* Get message count and data */

Line 1843: FND_MSG_PUB.count_and_get

1839: , l_api_name
1840: );
1841:
1842: /* Get message count and data */
1843: FND_MSG_PUB.count_and_get
1844: ( p_count => x_msg_count
1845: , p_data => x_msg_data
1846: );
1847:

Line 1992: FND_MSG_PUB.Add;

1988: x_ic_tran_rec.trans_id := 0;
1989: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Set trans_id=0 ', 'pick_lots.log');
1990: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
1991: FND_MESSAGE.Set_Token('MISSING', 'trans_id');
1992: FND_MSG_PUB.Add;
1993: /* raise FND_API.G_EXC_ERROR; */
1994: END IF;
1995:
1996: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check item_id ', 'pick_lots.log');

Line 2003: FND_MSG_PUB.Add;

1999: OR p_ic_tran_rec.item_id = FND_API.G_MISS_NUM)
2000: THEN
2001: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2002: FND_MESSAGE.Set_Token('MISSING', 'item_id');
2003: FND_MSG_PUB.Add;
2004: /* raise FND_API.G_EXC_ERROR; */
2005: END IF;
2006:
2007: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check line_id ', 'pick_lots.log');

Line 2014: FND_MSG_PUB.Add;

2010: OR p_ic_tran_rec.line_id = FND_API.G_MISS_NUM)
2011: THEN
2012: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2013: FND_MESSAGE.Set_Token('MISSING', 'line_id');
2014: FND_MSG_PUB.Add;
2015: /* raise FND_API.G_EXC_ERROR; */
2016: END IF;
2017:
2018: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check whse_code ', 'pick_lots.log');

Line 2025: FND_MSG_PUB.Add;

2021: OR p_ic_tran_rec.whse_code = FND_API.G_MISS_CHAR)
2022: THEN
2023: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2024: FND_MESSAGE.Set_Token('MISSING', 'whse_code');
2025: FND_MSG_PUB.Add;
2026: raise FND_API.G_EXC_ERROR;
2027: END IF;
2028:
2029: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check co_code/orgn_code ', 'pick_lots.log');

Line 2047: FND_MSG_PUB.Add;

2043: IF (Get_Orgn_Co_from_Whse%NOTFOUND)
2044: THEN
2045: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2046: FND_MESSAGE.Set_Token('MISSING', 'NOTFOUND co_code/orgn_code');
2047: FND_MSG_PUB.Add;
2048: CLOSE Get_Orgn_Co_from_Whse;
2049: raise FND_API.G_EXC_ERROR;
2050: END IF;
2051: CLOSE Get_Orgn_Co_from_Whse;

Line 2055: FND_MSG_PUB.Add;

2051: CLOSE Get_Orgn_Co_from_Whse;
2052:
2053: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2054: FND_MESSAGE.Set_Token('MISSING', 'co_code/orgn_code');
2055: FND_MSG_PUB.Add;
2056: /* raise FND_API.G_EXC_ERROR; */
2057: END IF;
2058:
2059:

Line 2067: FND_MSG_PUB.Add;

2063: OR p_ic_tran_rec.lot_id = FND_API.G_MISS_NUM)
2064: THEN
2065: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2066: FND_MESSAGE.Set_Token('MISSING', 'lot_id');
2067: FND_MSG_PUB.Add;
2068: /* raise FND_API.G_EXC_ERROR; */
2069: END IF;
2070:
2071: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check location ', 'pick_lots.log');

Line 2078: FND_MSG_PUB.Add;

2074: OR p_ic_tran_rec.location = FND_API.G_MISS_CHAR)
2075: THEN
2076: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2077: FND_MESSAGE.Set_Token('MISSING', 'location');
2078: FND_MSG_PUB.Add;
2079: /* raise FND_API.G_EXC_ERROR; */
2080: END IF;
2081:
2082: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check doc_id ', 'pick_lots.log');

Line 2089: FND_MSG_PUB.Add;

2085: OR p_ic_tran_rec.doc_id = FND_API.G_MISS_NUM)
2086: THEN
2087: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2088: FND_MESSAGE.Set_Token('MISSING', 'doc_id');
2089: FND_MSG_PUB.Add;
2090: /* raise FND_API.G_EXC_ERROR; */
2091: END IF;
2092:
2093: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check doc_type ', 'pick_lots.log');

Line 2100: FND_MSG_PUB.Add;

2096: OR p_ic_tran_rec.doc_type = FND_API.G_MISS_CHAR)
2097: THEN
2098: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2099: FND_MESSAGE.Set_Token('MISSING', 'doc_type');
2100: FND_MSG_PUB.Add;
2101: /* raise FND_API.G_EXC_ERROR; */
2102: END IF;
2103:
2104: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check doc_line ', 'pick_lots.log');

Line 2111: FND_MSG_PUB.Add;

2107: OR p_ic_tran_rec.doc_line = FND_API.G_MISS_NUM)
2108: THEN
2109: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2110: FND_MESSAGE.Set_Token('MISSING', 'doc_line');
2111: FND_MSG_PUB.Add;
2112: /* raise FND_API.G_EXC_ERROR; */
2113: END IF;
2114:
2115: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check line_type ', 'pick_lots.log');

Line 2122: FND_MSG_PUB.Add;

2118: OR p_ic_tran_rec.line_type = FND_API.G_MISS_NUM)
2119: THEN
2120: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2121: FND_MESSAGE.Set_Token('MISSING', 'line_type');
2122: FND_MSG_PUB.Add;
2123: /* raise FND_API.G_EXC_ERROR; */
2124: END IF;
2125:
2126: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check trans_qty ', 'pick_lots.log');

Line 2133: FND_MSG_PUB.Add;

2129: OR p_ic_tran_rec.trans_qty = FND_API.G_MISS_NUM)
2130: THEN
2131: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2132: FND_MESSAGE.Set_Token('MISSING', 'trans_qty');
2133: FND_MSG_PUB.Add;
2134: /* raise FND_API.G_EXC_ERROR; */
2135: END IF;
2136:
2137: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check trans_qty2 ', 'pick_lots.log');

Line 2144: FND_MSG_PUB.Add;

2140: OR p_ic_tran_rec.trans_qty2 = FND_API.G_MISS_NUM)
2141: THEN
2142: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2143: FND_MESSAGE.Set_Token('MISSING', 'trans_qty2');
2144: FND_MSG_PUB.Add;
2145: /* raise FND_API.G_EXC_ERROR; */
2146: END IF;
2147:
2148: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check trans_um ', 'pick_lots.log');

Line 2155: FND_MSG_PUB.Add;

2151: OR p_ic_tran_rec.trans_um = FND_API.G_MISS_CHAR)
2152: THEN
2153: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2154: FND_MESSAGE.Set_Token('MISSING', 'trans_um');
2155: FND_MSG_PUB.Add;
2156: /* raise FND_API.G_EXC_ERROR; */
2157: END IF;
2158:
2159: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check trans_um2 ', 'pick_lots.log');

Line 2166: FND_MSG_PUB.Add;

2162: OR p_ic_tran_rec.trans_um2 = FND_API.G_MISS_CHAR)
2163: THEN
2164: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2165: FND_MESSAGE.Set_Token('MISSING', 'trans_um2');
2166: FND_MSG_PUB.Add;
2167: /* raise FND_API.G_EXC_ERROR; */
2168: END IF;
2169:
2170: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check trans_date ', 'pick_lots.log');

Line 2177: FND_MSG_PUB.Add;

2173: THEN
2174: /* x_ic_tran_rec.trans_date := sysdate; */
2175: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2176: FND_MESSAGE.Set_Token('MISSING', 'trans_date');
2177: FND_MSG_PUB.Add;
2178: /* raise FND_API.G_EXC_ERROR; */
2179: END IF;
2180:
2181:

Line 2213: FND_MSG_PUB.count_and_get

2209: GMI_Reservation_Util.printLn('End of Validation_ic_tran_rec. Error', 'pick_lots.log');
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211:
2212: /* Get message count and data */
2213: FND_MSG_PUB.count_and_get
2214: ( p_count => x_msg_count
2215: , p_data => x_msg_data
2216: );
2217:

Line 2222: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

2218: WHEN OTHERS THEN
2219: GMI_Reservation_Util.printLn('End of Validation_ic_tran_rec. ErrorOthers', 'pick_lots.log');
2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2221:
2222: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2223: , l_api_name
2224: );
2225:
2226: /* Get message count and data */

Line 2227: FND_MSG_PUB.count_and_get

2223: , l_api_name
2224: );
2225:
2226: /* Get message count and data */
2227: FND_MSG_PUB.count_and_get
2228: ( p_count => x_msg_count
2229: , p_data => x_msg_data
2230: );
2231:

Line 2396: FND_MSG_PUB.ADD;

2392: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Because trans_line_id (='||ll_ic_tran_rec.line_id||') is not >0');
2393: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2394: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2395: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2396: FND_MSG_PUB.ADD;
2397: RAISE FND_API.G_EXC_ERROR;
2398: ELSE
2399: /* ================================================================ */
2400: /* Init variables before calling QueryReservation: */

Line 2420: FND_MSG_PUB.Add;

2416: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots : sales_order(line_id='||ll_ic_tran_rec.line_id||')=NOTFOUND', 'pick_lots.log');
2417: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
2418: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2419: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);
2420: FND_MSG_PUB.Add;
2421: RAISE FND_API.G_EXC_ERROR;
2422: ELSE
2423: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots FOUND: line_id='||ll_ic_tran_rec.line_id||'.', 'pick_lots.log');
2424: END IF;

Line 2453: FND_MSG_PUB.Add;

2449: THEN
2450: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Set_Pick_Lots ERROR:Returned by Get_Process_Org.');
2451: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
2452: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2453: FND_MSG_PUB.Add;
2454: RAISE FND_API.G_EXC_ERROR;
2455: END IF;
2456:
2457: l_co_code := ll_ic_tran_rec.co_code;

Line 2474: FND_MSG_PUB.Add;

2470: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2471: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
2472: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2473: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
2474: FND_MSG_PUB.Add;
2475: raise FND_API.G_EXC_ERROR;
2476: END IF;
2477:
2478: /* B1390816, odaboval 16-Nov-2000 : Added a check on the Horizon period. */

Line 2509: FND_MSG_PUB.Add;

2505: THEN
2506: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2507: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');
2508: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);
2509: FND_MSG_PUB.Add;
2510: RAISE FND_API.G_EXC_ERROR;
2511: END IF;
2512:
2513: /* It is not possible to allocate (create/update) if the period between */

Line 2523: FND_MSG_PUB.Add;

2519: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2520: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2521: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2522: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2523: FND_MSG_PUB.Add;
2524: RAISE FND_API.G_EXC_ERROR;
2525: END IF;
2526:
2527: /* ==================================================================== */

Line 2613: FND_MSG_PUB.ADD;

2609: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(1).', 'pick_lots.log');
2610: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2611: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2612: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2613: FND_MSG_PUB.ADD;
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2616: l_need_update_default_lot := FALSE;
2617:

Line 2632: FND_MSG_PUB.ADD;

2628: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Query_Reservation.', 'pick_lots.log');
2629: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
2630: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2631: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
2632: FND_MSG_PUB.ADD;
2633: RAISE FND_API.G_EXC_ERROR;
2634: END IF;
2635:
2636: /* At this point the table should have rows */

Line 2652: FND_MSG_PUB.ADD;

2648: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Default_Lot.', 'pick_lots.log');
2649: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2650: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
2651: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2652: FND_MSG_PUB.ADD;
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;
2655:
2656: /* ============================================================================================= */

Line 2672: FND_MSG_PUB.Add;

2668: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots ERROR:Returned by Lock_Inventory.');
2669: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2670: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
2671: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2672: FND_MSG_PUB.Add;
2673: RAISE FND_API.G_EXC_ERROR;
2674: END IF;
2675: */
2676: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: default_lot_index='||l_default_lot_index, 'pick_lots.log');

Line 2696: FND_MSG_PUB.ADD;

2692: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(2).', 'pick_lots.log');
2693: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2694: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2695: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2696: FND_MSG_PUB.ADD;
2697: RAISE FND_API.G_EXC_ERROR;
2698: END IF;
2699: l_need_update_default_lot := FALSE;
2700:

Line 2743: FND_MSG_PUB.ADD;

2739: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Allocation.', 'pick_lots.log');
2740: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2741: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
2742: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2743: FND_MSG_PUB.ADD;
2744: RAISE FND_API.G_EXC_ERROR;
2745: END IF;
2746:
2747: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Not updating the default, save orig trans to local rec.', 'pick_lots.log');

Line 2771: FND_MSG_PUB.ADD;

2767: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Validation_ictran_rec.', 'pick_lots.log');
2768: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2769: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2770: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2771: FND_MSG_PUB.ADD;
2772: RAISE FND_API.G_EXC_ERROR;
2773: END IF;
2774:
2775: l_ic_tran_rec.doc_id := l_demand_source_header_id;

Line 2841: FND_MSG_PUB.Add;

2837: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2838: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2839: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2840: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2841: FND_MSG_PUB.Add;
2842: RAISE FND_API.G_EXC_ERROR;
2843: END IF;
2844: ELSE
2845: /* Need to delete the Original transaction, and then create a new one. */

Line 2879: FND_MSG_PUB.Add;

2875: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, Error returned by Delete_Reservation, Error='||x_return_status, 'pick_lots.log');
2876: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2877: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');
2878: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2879: FND_MSG_PUB.Add;
2880: RAISE FND_API.G_EXC_ERROR;
2881: END IF;
2882:
2883: END IF;

Line 2939: FND_MSG_PUB.Add;

2935: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2936: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2937: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2938: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2939: FND_MSG_PUB.Add;
2940: RAISE FND_API.G_EXC_ERROR;
2941: END IF;
2942:
2943: /* Begin enhancement 1928979 - lakshmi swamy */

Line 2955: FND_MSG_PUB.Add;

2951: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2952: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2953: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2954: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2955: FND_MSG_PUB.Add;
2956: RAISE FND_API.G_EXC_ERROR;
2957: END IF;
2958:
2959: UPDATE ic_tran_pnd

Line 3083: FND_MSG_PUB.Add;

3079: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback)');
3080: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3081: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3082: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3083: FND_MSG_PUB.Add;
3084: x_return_status := FND_API.G_RET_STS_ERROR;
3085:
3086: /* Get message count and data */
3087: FND_MSG_PUB.count_and_get

Line 3087: FND_MSG_PUB.count_and_get

3083: FND_MSG_PUB.Add;
3084: x_return_status := FND_API.G_RET_STS_ERROR;
3085:
3086: /* Get message count and data */
3087: FND_MSG_PUB.count_and_get
3088: ( p_count => x_msg_count
3089: , p_data => x_msg_data
3090: );
3091:

Line 3099: FND_MSG_PUB.Add;

3095: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback) - lock error in Move Order Line', 'pick_lots.log');
3096: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3097: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3098: FND_MESSAGE.Set_Token('WHAT', 'LockError');
3099: FND_MSG_PUB.Add;
3100: x_return_status := FND_API.G_RET_STS_ERROR;
3101:
3102: WHEN OTHERS THEN
3103: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;

Line 3108: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

3104:
3105: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. ErrorOthers (Rollback)');
3106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3107:
3108: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
3109: , l_api_name
3110: );
3111:
3112: /* Get message count and data */

Line 3113: FND_MSG_PUB.count_and_get

3109: , l_api_name
3110: );
3111:
3112: /* Get message count and data */
3113: FND_MSG_PUB.count_and_get
3114: ( p_count => x_msg_count
3115: , p_data => x_msg_data
3116: );
3117:

Line 3331: FND_MSG_PUB.Add;

3327: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3328: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3329: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3330: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3331: FND_MSG_PUB.Add;
3332: RAISE FND_API.G_EXC_ERROR;
3333: END IF;
3334:
3335: l_ic_tran_rec.trans_id := null;

Line 3360: FND_MSG_PUB.Add;

3356: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3357: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3358: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3359: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3360: FND_MSG_PUB.Add;
3361: RAISE FND_API.G_EXC_ERROR;
3362: END IF;
3363: /* cancel all the reservations for GME */
3364: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot, cancel reservation for line_id '||l_ic_tran_rec.line_id);

Line 3393: FND_MSG_PUB.Add;

3389: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3390: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3391: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3392: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3393: FND_MSG_PUB.Add;
3394: RAISE FND_API.G_EXC_ERROR;
3395: END IF;
3396: END IF;
3397: /* if the trans_qty is 0, remove all the outstand GME reservations as well */

Line 3473: FND_MSG_PUB.Add;

3469: GMI_reservation_Util.PrintLn('(opm_dbg) in end of Create_Empty_Default_Lot c ERROR:Returned by Lock_Inventory.');
3470: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3471: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
3472: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3473: FND_MSG_PUB.Add;
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;
3476:
3477: /* ============================================================================================= */

Line 3550: FND_MSG_PUB.Add;

3546: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3547: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3548: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3549: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3550: FND_MSG_PUB.Add;
3551: RAISE FND_API.G_EXC_ERROR;
3552: END IF;
3553: ELSE
3554: GMI_reservation_Util.PrintLn('(opm_dbg) Dont create the default lot again (Shouldnt be here) - 2 ! ');

Line 3591: FND_MSG_PUB.ADD;

3587: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: No Error but No Rows Found in reservation (ERROR)', 'pick_lots.log');
3588: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3589: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3590: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3591: FND_MSG_PUB.ADD;
3592: RAISE FND_API.G_EXC_ERROR;
3593: END IF;
3594:
3595: /* There may have been a problem getting the rows */

Line 3602: FND_MSG_PUB.ADD;

3598: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Query_Reservation(2).', 'pick_lots.log');
3599: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3600: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3601: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3602: FND_MSG_PUB.ADD;
3603: RAISE FND_API.G_EXC_ERROR;
3604: END IF;
3605:
3606: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: we have rows now calling Get_Default_Lot.', 'pick_lots.log');

Line 3618: FND_MSG_PUB.ADD;

3614: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Get_Default_Lot.', 'pick_lots.log');
3615: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3616: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3617: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3618: FND_MSG_PUB.ADD;
3619: RAISE FND_API.G_EXC_ERROR;
3620: END IF;
3621:
3622: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: default_lot_index='||x_default_lot_index, 'pick_lots.log');

Line 3629: FND_MSG_PUB.ADD;

3625: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Still no default lot = ERROR.', 'pick_lots.log');
3626: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3627: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3628: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3629: FND_MSG_PUB.ADD;
3630: RAISE FND_API.G_EXC_ERROR;
3631: END IF;
3632:
3633: EXCEPTION

Line 3641: FND_MSG_PUB.Add;

3637: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. Error');
3638: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3639: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3640: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3641: FND_MSG_PUB.Add;
3642: x_return_status := FND_API.G_RET_STS_ERROR;
3643:
3644: /* Get message count and data */
3645: FND_MSG_PUB.count_and_get

Line 3645: FND_MSG_PUB.count_and_get

3641: FND_MSG_PUB.Add;
3642: x_return_status := FND_API.G_RET_STS_ERROR;
3643:
3644: /* Get message count and data */
3645: FND_MSG_PUB.count_and_get
3646: ( p_count => x_msg_count
3647: , p_data => x_msg_data
3648: );
3649:

Line 3656: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

3652:
3653: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. ErrorOthers');
3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3655:
3656: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
3657: , l_api_name
3658: );
3659:
3660: /* Get message count and data */

Line 3661: FND_MSG_PUB.count_and_get

3657: , l_api_name
3658: );
3659:
3660: /* Get message count and data */
3661: FND_MSG_PUB.count_and_get
3662: ( p_count => x_msg_count
3663: , p_data => x_msg_data
3664: );
3665:

Line 3717: FND_MSG_PUB.Add;

3713: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. Error');
3714: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3715: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');
3716: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3717: FND_MSG_PUB.Add;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719:
3720: /* Get message count and data */
3721: FND_MSG_PUB.count_and_get

Line 3721: FND_MSG_PUB.count_and_get

3717: FND_MSG_PUB.Add;
3718: x_return_status := FND_API.G_RET_STS_ERROR;
3719:
3720: /* Get message count and data */
3721: FND_MSG_PUB.count_and_get
3722: ( p_count => x_msg_count
3723: , p_data => x_msg_data
3724: );
3725:

Line 3730: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

3726: WHEN OTHERS THEN
3727: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. ErrorOthers');
3728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3729:
3730: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
3731: , l_api_name
3732: );
3733:
3734: /* Get message count and data */

Line 3735: FND_MSG_PUB.count_and_get

3731: , l_api_name
3732: );
3733:
3734: /* Get message count and data */
3735: FND_MSG_PUB.count_and_get
3736: ( p_count => x_msg_count
3737: , p_data => x_msg_data
3738: );
3739:

Line 3865: FND_MSG_PUB.Add;

3861: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3862: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3863: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3864: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3865: FND_MSG_PUB.Add;
3866: raise FND_API.G_EXC_ERROR;
3867: END IF;
3868: END create_dflt_lot_from_scratch;
3869:

Line 4152: FND_MSG_PUB.Add;

4148: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4149: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4150: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4151: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4152: FND_MSG_PUB.Add;
4153: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4154: END IF;
4155:
4156: l_ictran_rec.trans_id := l_tran_row.trans_id;

Line 4182: FND_MSG_PUB.Add;

4178: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4179: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4180: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4181: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4182: FND_MSG_PUB.Add;
4183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4184: END IF;
4185:
4186: EXCEPTION

Line 4191: FND_MSG_PUB.count_and_get

4187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4188: x_return_status := FND_API.G_RET_STS_ERROR;
4189:
4190: /* Get message count and data */
4191: FND_MSG_PUB.count_and_get
4192: ( p_encoded=> FND_API.G_FALSE
4193: , p_count => x_msg_count
4194: , p_data => x_msg_data
4195: );

Line 4197: l_msg_data := FND_MSG_PUB.GET(l_cnt,'F');

4193: , p_count => x_msg_count
4194: , p_data => x_msg_data
4195: );
4196: for l_cnt in 1..x_msg_count loop
4197: l_msg_data := FND_MSG_PUB.GET(l_cnt,'F');
4198: GMI_reservation_Util.PrintLn('for_rcv '||l_msg_data);
4199: end loop;
4200: GMI_reservation_Util.PrintLn('for rcv:EXP Error count='||x_msg_count);
4201:

Line 4205: FND_MSG_PUB.Add_Exc_Msg ( 'RESERVATION_UTIL'

4201:
4202: WHEN OTHERS THEN
4203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4204:
4205: FND_MSG_PUB.Add_Exc_Msg ( 'RESERVATION_UTIL'
4206: , 'create_trans_for_rcv'
4207: );
4208:
4209: /* Get message count and data */

Line 4210: FND_MSG_Pub.Count_and_Get

4206: , 'create_trans_for_rcv'
4207: );
4208:
4209: /* Get message count and data */
4210: FND_MSG_Pub.Count_and_Get
4211: ( p_count => x_msg_count
4212: , p_data => x_msg_data
4213: );
4214:

Line 4216: l_msg_data := FND_MSG_PUB.GET(l_cnt,'F');

4212: , p_data => x_msg_data
4213: );
4214:
4215: for l_cnt in 1..x_msg_count loop
4216: l_msg_data := FND_MSG_PUB.GET(l_cnt,'F');
4217: GMI_reservation_Util.PrintLn('for_rcv '||l_msg_data);
4218: end loop;
4219: GMI_reservation_Util.PrintLn('for rcv:EXP Error count='||x_msg_count);
4220:

Line 4432: FND_MSG_PUB.Add;

4428: x_msg_data =>l_msg_data);
4429: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4430: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4431: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_from_uom);
4432: FND_MSG_PUB.Add;
4433: RAISE FND_API.G_EXC_ERROR;
4434: END IF;
4435: GMI_reservation_Util.PrintLn('from uom (OPM) '||l_opm_from_uom);
4436: GMI_RESERVATION_UTIL.Get_OPMUOM_from_AppsUOM(

Line 4445: FND_MSG_PUB.Add;

4441: x_msg_data =>l_msg_data);
4442: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4443: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4444: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_to_uom);
4445: FND_MSG_PUB.Add;
4446: RAISE FND_API.G_EXC_ERROR;
4447: END IF;
4448: GMI_reservation_Util.PrintLn('to uom (OPM) '||l_opm_to_uom);
4449:

Line 4461: FND_MSG_PUB.Add;

4457: IF l_converted_qty < 0 THEN
4458: GMI_reservation_Util.PrintLn('conversion error code'|| l_converted_qty);
4459: FND_MESSAGE.Set_Name('GMI','GMICUOM.icuomcv');
4460: FND_MESSAGE.Set_Token('CONVERSION_ERROR', p_apps_to_uom);
4461: FND_MSG_PUB.Add;
4462: RAISE FND_API.G_EXC_ERROR;
4463: END IF;
4464:
4465: --

Line 4776: FND_MSG_PUB.Add;

4772: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4773: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4774: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4775: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4776: FND_MSG_PUB.Add;
4777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4778: END IF;
4779: END IF;
4780: END IF;

Line 4840: FND_MSG_PUB.Add;

4836: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4837: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4838: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4839: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4840: FND_MSG_PUB.Add;
4841:
4842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4843: END IF;
4844: /* no more fulfilment */

Line 5038: FND_MSG_PUB.Add;

5034: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5035: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5036: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5037: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5038: FND_MSG_PUB.Add;
5039: x_return_status := FND_API.G_RET_STS_ERROR;
5040: RETURN;
5041: END IF; -- of update
5042:

Line 5158: FND_MSG_Pub.count_and_get

5154: WHEN FND_API.G_EXC_ERROR THEN
5155:
5156: x_return_status := FND_API.G_RET_STS_ERROR;
5157:
5158: FND_MSG_Pub.count_and_get
5159: ( p_count => x_msg_count
5160: , p_data => x_msg_data
5161: );
5162:

Line 5167: FND_MSG_PUB.Count_And_Get

5163: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Exp_Error ');
5164:
5165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5167: FND_MSG_PUB.Count_And_Get
5168: (
5169: p_count => x_msg_count,
5170: p_data => x_msg_data,
5171: p_encoded => FND_API.G_FALSE

Line 5178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

5174: WHEN OTHERS THEN
5175: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Error in Select='||SQLCODE||'.');
5176: x_return_status := SQLCODE;
5177:
5178: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
5179: , l_api_name
5180: );
5181:
5182: /* Get message count and data */

Line 5183: FND_MSG_Pub.count_and_get

5179: , l_api_name
5180: );
5181:
5182: /* Get message count and data */
5183: FND_MSG_Pub.count_and_get
5184: ( p_count => x_msg_count
5185: , p_data => x_msg_data
5186: );
5187:

Line 5287: FND_MSG_Pub.count_and_get

5283: WHEN FND_API.G_EXC_ERROR THEN
5284:
5285: x_return_status := FND_API.G_RET_STS_ERROR;
5286:
5287: FND_MSG_Pub.count_and_get
5288: ( p_count => x_msg_count
5289: , p_data => x_msg_data
5290: );
5291:

Line 5296: FND_MSG_PUB.Count_And_Get

5292: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Exp_Error ');
5293:
5294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5296: FND_MSG_PUB.Count_And_Get
5297: (
5298: p_count => x_msg_count,
5299: p_data => x_msg_data,
5300: p_encoded => FND_API.G_FALSE

Line 5307: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

5303: WHEN OTHERS THEN
5304: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Error in Select='||SQLCODE||'.');
5305: x_return_status := SQLCODE;
5306:
5307: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
5308: , l_api_name
5309: );
5310:
5311: /* Get message count and data */

Line 5312: FND_MSG_Pub.count_and_get

5308: , l_api_name
5309: );
5310:
5311: /* Get message count and data */
5312: FND_MSG_Pub.count_and_get
5313: ( p_count => x_msg_count
5314: , p_data => x_msg_data
5315: );
5316:

Line 5392: FND_MSG_PUB.Add;

5388: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5389: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5390: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5391: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5392: FND_MSG_PUB.Add;
5393: raise FND_API.G_EXC_ERROR;
5394: END IF;
5395:
5396: IF ( l_ic_item_mst_rec.lot_indivisible = 1 ) THEN

Line 5442: FND_MSG_Pub.count_and_get

5438: WHEN FND_API.G_EXC_ERROR THEN
5439:
5440: x_return_status := FND_API.G_RET_STS_ERROR;
5441:
5442: FND_MSG_Pub.count_and_get
5443: ( p_count => x_msg_count
5444: , p_data => x_msg_data
5445: );
5446:

Line 5451: FND_MSG_PUB.Count_And_Get

5447: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Exp_Error ');
5448:
5449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5451: FND_MSG_PUB.Count_And_Get
5452: (
5453: p_count => x_msg_count,
5454: p_data => x_msg_data,
5455: p_encoded => FND_API.G_FALSE

Line 5462: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

5458: WHEN OTHERS THEN
5459: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Error in Select='||SQLCODE||'.');
5460: x_return_status := SQLCODE;
5461:
5462: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
5463: , l_api_name
5464: );
5465:
5466: /* Get message count and data */

Line 5467: FND_MSG_Pub.count_and_get

5463: , l_api_name
5464: );
5465:
5466: /* Get message count and data */
5467: FND_MSG_Pub.count_and_get
5468: ( p_count => x_msg_count
5469: , p_data => x_msg_data
5470: );
5471:

Line 5547: FND_MSG_PUB.Add;

5543: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5544: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5545: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5546: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5547: FND_MSG_PUB.Add;
5548: x_check_status := 0;
5549: raise FND_API.G_EXC_ERROR;
5550: END IF;
5551:

Line 5627: FND_MSG_Pub.count_and_get

5623: WHEN FND_API.G_EXC_ERROR THEN
5624:
5625: x_return_status := FND_API.G_RET_STS_ERROR;
5626:
5627: FND_MSG_Pub.count_and_get
5628: ( p_count => x_msg_count
5629: , p_data => x_msg_data
5630: );
5631:

Line 5638: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

5634: WHEN OTHERS THEN
5635: GMI_reservation_Util.PrintLn('(opm_dbg) in Util validate_opm_quantities: Error in Select='||SQLCODE||'.');
5636: x_return_status := SQLCODE;
5637:
5638: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
5639: , l_api_name
5640: );
5641:
5642: /* Get message count and data */

Line 5643: FND_MSG_Pub.count_and_get

5639: , l_api_name
5640: );
5641:
5642: /* Get message count and data */
5643: FND_MSG_Pub.count_and_get
5644: ( p_count => x_msg_count
5645: , p_data => x_msg_data
5646: );
5647: