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 135: FND_MSG_PUB.Add;

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

Line 148: FND_MSG_PUB.Add;

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

Line 161: FND_MSG_PUB.Add;

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

Line 185: FND_MSG_PUB.Add;

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

Line 198: FND_MSG_PUB.Add;

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

Line 211: FND_MSG_PUB.Add;

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

Line 222: FND_MSG_PUB.Add;

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

Line 233: FND_MSG_PUB.Add;

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

Line 243: FND_MSG_PUB.Add;

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

Line 254: FND_MSG_PUB.Add;

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

Line 264: FND_MSG_PUB.Add;

260: OR p_rec_to_check.requirement_date = FND_API.G_MISS_DATE )
261: THEN
262: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
263: FND_MESSAGE.Set_Token('MISSING', 'requirement_date');
264: FND_MSG_PUB.Add;
265: raise FND_API.G_EXC_ERROR;
266: END IF;
267: END IF;
268:

Line 275: FND_MSG_PUB.count_and_get

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

Line 285: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

281:
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284:
285: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
286: , l_api_name
287: );
288:
289: /* Get message count and data */

Line 290: FND_MSG_Pub.Count_and_Get

286: , l_api_name
287: );
288:
289: /* Get message count and data */
290: FND_MSG_Pub.Count_and_Get
291: ( p_count => x_msg_count
292: , p_data => x_msg_data
293: );
294:

Line 350: /* FND_MSG_PUB.Add; */

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

Line 372: FND_MSG_PUB.Add;

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

Line 396: FND_MSG_PUB.Add;

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

Line 414: FND_MSG_Pub.count_and_get

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

Line 425: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

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

Line 430: FND_MSG_Pub.count_and_get

426: , l_api_name
427: );
428:
429: /* Get message count and data */
430: FND_MSG_Pub.count_and_get
431: ( p_count => x_msg_count
432: , p_data => x_msg_data
433: );
434:

Line 494: FND_MSG_PUB.count_and_get

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

Line 502: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

498:
499: WHEN OTHERS THEN
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501:
502: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
503: , l_api_name
504: );
505:
506: /* Get message count and data */

Line 507: FND_MSG_PUB.count_and_get

503: , l_api_name
504: );
505:
506: /* Get message count and data */
507: FND_MSG_PUB.count_and_get
508: ( p_count => x_msg_count
509: , p_data => x_msg_data
510: );
511:

Line 673: FND_MSG_PUB.Add;

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

Line 706: FND_MSG_PUB.Add;

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

Line 719: FND_MSG_PUB.count_and_get

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

Line 727: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

723:
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726:
727: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
728: , l_api_name
729: );
730:
731: /* Get message count and data */

Line 732: FND_MSG_PUB.count_and_get

728: , l_api_name
729: );
730:
731: /* Get message count and data */
732: FND_MSG_PUB.count_and_get
733: ( p_count => x_msg_count
734: , p_data => x_msg_data
735: );
736:

Line 828: FND_MSG_PUB.Add;

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

Line 855: FND_MSG_PUB.Add;

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

Line 883: FND_MSG_PUB.Add;

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

Line 913: FND_MSG_PUB.Add;

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

Line 990: FND_MSG_PUB.count_and_get

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

Line 999: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

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

Line 1004: FND_MSG_PUB.count_and_get

1000: , l_api_name
1001: );
1002:
1003: /* Get message count and data */
1004: FND_MSG_PUB.count_and_get
1005: ( p_count => x_msg_count
1006: , p_data => x_msg_data
1007: );
1008:

Line 1064: FND_MSG_PUB.count_and_get

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

Line 1072: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1068:
1069: WHEN OTHERS THEN
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071:
1072: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1073: , l_api_name
1074: );
1075:
1076: /* Get message count and data */

Line 1077: FND_MSG_PUB.count_and_get

1073: , l_api_name
1074: );
1075:
1076: /* Get message count and data */
1077: FND_MSG_PUB.count_and_get
1078: ( p_count => x_msg_count
1079: , p_data => x_msg_data
1080: );
1081:

Line 1127: FND_MSG_PUB.Add;

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

Line 1139: FND_MSG_PUB.count_and_get

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

Line 1147: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1143:
1144: WHEN OTHERS THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146:
1147: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1148: , l_api_name
1149: );
1150:
1151: /* Get message count and data */

Line 1152: FND_MSG_PUB.count_and_get

1148: , l_api_name
1149: );
1150:
1151: /* Get message count and data */
1152: FND_MSG_PUB.count_and_get
1153: ( p_count => x_msg_count
1154: , p_data => x_msg_data
1155: );
1156:

Line 1204: FND_MSG_PUB.Add;

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

Line 1216: FND_MSG_PUB.count_and_get

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

Line 1224: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1220:
1221: WHEN OTHERS THEN
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1223:
1224: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1225: , l_api_name
1226: );
1227:
1228: /* Get message count and data */

Line 1229: FND_MSG_PUB.count_and_get

1225: , l_api_name
1226: );
1227:
1228: /* Get message count and data */
1229: FND_MSG_PUB.count_and_get
1230: ( p_count => x_msg_count
1231: , p_data => x_msg_data
1232: );
1233:

Line 1266: FND_MSG_PUB.Add;

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

Line 1279: FND_MSG_PUB.count_and_get

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

Line 1287: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1283:
1284: WHEN OTHERS THEN
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286:
1287: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1288: , l_api_name
1289: );
1290:
1291: /* Get message count and data */

Line 1292: FND_MSG_PUB.count_and_get

1288: , l_api_name
1289: );
1290:
1291: /* Get message count and data */
1292: FND_MSG_PUB.count_and_get
1293: ( p_count => x_msg_count
1294: , p_data => x_msg_data
1295: );
1296:

Line 1353: FND_MSG_PUB.Add;

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

Line 1367: FND_MSG_PUB.count_and_get

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

Line 1375: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1371:
1372: WHEN OTHERS THEN
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374:
1375: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1376: , l_api_name
1377: );
1378:
1379: /* Get message count and data */

Line 1380: FND_MSG_PUB.count_and_get

1376: , l_api_name
1377: );
1378:
1379: /* Get message count and data */
1380: FND_MSG_PUB.count_and_get
1381: ( p_count => x_msg_count
1382: , p_data => x_msg_data
1383: );
1384:

Line 1472: FND_MSG_PUB.Add;

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

Line 1583: FND_MSG_PUB.Add;

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

Line 1594: FND_MSG_PUB.Add;

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

Line 1632: FND_MSG_PUB.Add;

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

Line 1701: FND_MSG_PUB.count_and_get

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

Line 1711: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

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

Line 1716: FND_MSG_PUB.count_and_get

1712: , l_api_name
1713: );
1714:
1715: /* Get message count and data */
1716: FND_MSG_PUB.count_and_get
1717: ( p_count => x_msg_count
1718: , p_data => x_msg_data
1719: );
1720:

Line 1773: FND_MSG_PUB.Add;

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

Line 1797: FND_MSG_PUB.Add;

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

Line 1833: FND_MSG_PUB.count_and_get

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

Line 1842: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

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

Line 1847: FND_MSG_PUB.count_and_get

1843: , l_api_name
1844: );
1845:
1846: /* Get message count and data */
1847: FND_MSG_PUB.count_and_get
1848: ( p_count => x_msg_count
1849: , p_data => x_msg_data
1850: );
1851:

Line 2004: FND_MSG_PUB.Add;

2000: x_ic_tran_rec.trans_id := 0;
2001: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Set trans_id=0 ', 'pick_lots.log');
2002: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2003: FND_MESSAGE.Set_Token('MISSING', 'trans_id');
2004: FND_MSG_PUB.Add;
2005: /* raise FND_API.G_EXC_ERROR; */
2006: END IF;
2007:
2008: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check item_id ', 'pick_lots.log');

Line 2015: FND_MSG_PUB.Add;

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

Line 2026: FND_MSG_PUB.Add;

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

Line 2037: FND_MSG_PUB.Add;

2033: OR p_ic_tran_rec.whse_code = FND_API.G_MISS_CHAR)
2034: THEN
2035: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2036: FND_MESSAGE.Set_Token('MISSING', 'whse_code');
2037: FND_MSG_PUB.Add;
2038: raise FND_API.G_EXC_ERROR;
2039: END IF;
2040:
2041: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check co_code/orgn_code ', 'pick_lots.log');

Line 2059: FND_MSG_PUB.Add;

2055: IF (Get_Orgn_Co_from_Whse%NOTFOUND)
2056: THEN
2057: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2058: FND_MESSAGE.Set_Token('MISSING', 'NOTFOUND co_code/orgn_code');
2059: FND_MSG_PUB.Add;
2060: CLOSE Get_Orgn_Co_from_Whse;
2061: raise FND_API.G_EXC_ERROR;
2062: END IF;
2063: CLOSE Get_Orgn_Co_from_Whse;

Line 2067: FND_MSG_PUB.Add;

2063: CLOSE Get_Orgn_Co_from_Whse;
2064:
2065: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2066: FND_MESSAGE.Set_Token('MISSING', 'co_code/orgn_code');
2067: FND_MSG_PUB.Add;
2068: /* raise FND_API.G_EXC_ERROR; */
2069: END IF;
2070:
2071:

Line 2079: FND_MSG_PUB.Add;

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

Line 2090: FND_MSG_PUB.Add;

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

Line 2101: FND_MSG_PUB.Add;

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

Line 2112: FND_MSG_PUB.Add;

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

Line 2123: FND_MSG_PUB.Add;

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

Line 2134: FND_MSG_PUB.Add;

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

Line 2145: FND_MSG_PUB.Add;

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

Line 2156: FND_MSG_PUB.Add;

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

Line 2167: FND_MSG_PUB.Add;

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

Line 2178: FND_MSG_PUB.Add;

2174: OR p_ic_tran_rec.trans_um2 = FND_API.G_MISS_CHAR)
2175: THEN
2176: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2177: FND_MESSAGE.Set_Token('MISSING', 'trans_um2');
2178: FND_MSG_PUB.Add;
2179: /* raise FND_API.G_EXC_ERROR; */
2180: END IF;
2181:
2182: GMI_reservation_Util.PrintLn('(opm_dbg) in Util.Validation_ictran_rec: Check trans_date ', 'pick_lots.log');

Line 2189: FND_MSG_PUB.Add;

2185: THEN
2186: /* x_ic_tran_rec.trans_date := sysdate; */
2187: FND_MESSAGE.Set_Name('GMI','GMI_MISSING');
2188: FND_MESSAGE.Set_Token('MISSING', 'trans_date');
2189: FND_MSG_PUB.Add;
2190: /* raise FND_API.G_EXC_ERROR; */
2191: END IF;
2192:
2193:

Line 2225: FND_MSG_PUB.count_and_get

2221: GMI_Reservation_Util.printLn('End of Validation_ic_tran_rec. Error', 'pick_lots.log');
2222: x_return_status := FND_API.G_RET_STS_ERROR;
2223:
2224: /* Get message count and data */
2225: FND_MSG_PUB.count_and_get
2226: ( p_count => x_msg_count
2227: , p_data => x_msg_data
2228: );
2229:

Line 2234: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

2230: WHEN OTHERS THEN
2231: GMI_Reservation_Util.printLn('End of Validation_ic_tran_rec. ErrorOthers', 'pick_lots.log');
2232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2233:
2234: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2235: , l_api_name
2236: );
2237:
2238: /* Get message count and data */

Line 2239: FND_MSG_PUB.count_and_get

2235: , l_api_name
2236: );
2237:
2238: /* Get message count and data */
2239: FND_MSG_PUB.count_and_get
2240: ( p_count => x_msg_count
2241: , p_data => x_msg_data
2242: );
2243:

Line 2408: FND_MSG_PUB.ADD;

2404: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Because trans_line_id (='||ll_ic_tran_rec.line_id||') is not >0');
2405: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2406: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2407: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;
2410: ELSE
2411: /* ================================================================ */
2412: /* Init variables before calling QueryReservation: */

Line 2432: FND_MSG_PUB.Add;

2428: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots : sales_order(line_id='||ll_ic_tran_rec.line_id||')=NOTFOUND', 'pick_lots.log');
2429: FND_MESSAGE.Set_Name('GMI','GMI_QRY_SO_FAILED');
2430: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2431: FND_MESSAGE.Set_Token('SO_LINE_ID', ll_ic_tran_rec.line_id);
2432: FND_MSG_PUB.Add;
2433: RAISE FND_API.G_EXC_ERROR;
2434: ELSE
2435: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots FOUND: line_id='||ll_ic_tran_rec.line_id||'.', 'pick_lots.log');
2436: END IF;

Line 2465: FND_MSG_PUB.Add;

2461: THEN
2462: GMI_reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Util.Set_Pick_Lots ERROR:Returned by Get_Process_Org.');
2463: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
2464: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2465: FND_MSG_PUB.Add;
2466: RAISE FND_API.G_EXC_ERROR;
2467: END IF;
2468:
2469: l_co_code := ll_ic_tran_rec.co_code;

Line 2486: FND_MSG_PUB.Add;

2482: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2483: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
2484: FND_MESSAGE.Set_Token('ORGANIZATION_ID', l_organization_id);
2485: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', l_inventory_item_id);
2486: FND_MSG_PUB.Add;
2487: raise FND_API.G_EXC_ERROR;
2488: END IF;
2489:
2490: /* B1390816, odaboval 16-Nov-2000 : Added a check on the Horizon period. */

Line 2521: FND_MSG_PUB.Add;

2517: THEN
2518: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation - Error missing allocation parms',1);
2519: FND_MESSAGE.SET_NAME('GML','GML_NO_ALLOCATION_PARMS');
2520: FND_MESSAGE.SET_TOKEN('ALLOC_CLASS', l_ic_item_mst_rec.alloc_class);
2521: FND_MSG_PUB.Add;
2522: RAISE FND_API.G_EXC_ERROR;
2523: END IF;
2524:
2525: /* It is not possible to allocate (create/update) if the period between */

Line 2535: FND_MSG_PUB.Add;

2531: GMI_Reservation_Util.PrintLn('(opm_dbg) allocation horizon is out - using '|| l_op_alot_prm_rec.alloc_horizon||' days.');
2532: GMI_Reservation_Util.PrintLn('(opm_dbg) do allocate from sysdate > ' || (p_ic_tran_rec.trans_date + l_op_alot_prm_rec.alloc_horizon));
2533: GMI_Reservation_Util.PrintLn('(opm_dbg) or choose trans_date < '|| (SYSDATE + l_op_alot_prm_rec.alloc_horizon));
2534: FND_MESSAGE.SET_NAME('GML','SO_E_ALLOC_HORIZON_ERR');
2535: FND_MSG_PUB.Add;
2536: RAISE FND_API.G_EXC_ERROR;
2537: END IF;
2538:
2539: /* ==================================================================== */

Line 2625: FND_MSG_PUB.ADD;

2621: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(1).', 'pick_lots.log');
2622: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2623: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2624: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2625: FND_MSG_PUB.ADD;
2626: RAISE FND_API.G_EXC_ERROR;
2627: END IF;
2628: l_need_update_default_lot := FALSE;
2629:

Line 2644: FND_MSG_PUB.ADD;

2640: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Query_Reservation.', 'pick_lots.log');
2641: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
2642: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2643: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
2644: FND_MSG_PUB.ADD;
2645: RAISE FND_API.G_EXC_ERROR;
2646: END IF;
2647:
2648: /* At this point the table should have rows */

Line 2664: FND_MSG_PUB.ADD;

2660: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Default_Lot.', 'pick_lots.log');
2661: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2662: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
2663: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2664: FND_MSG_PUB.ADD;
2665: RAISE FND_API.G_EXC_ERROR;
2666: END IF;
2667:
2668: /* ============================================================================================= */

Line 2684: FND_MSG_PUB.Add;

2680: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots ERROR:Returned by Lock_Inventory.');
2681: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
2682: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
2683: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2684: FND_MSG_PUB.Add;
2685: RAISE FND_API.G_EXC_ERROR;
2686: END IF;
2687: */
2688: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: default_lot_index='||l_default_lot_index, 'pick_lots.log');

Line 2708: FND_MSG_PUB.ADD;

2704: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Create_Empty_Default_Lot(2).', 'pick_lots.log');
2705: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2706: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Empty_Default_Lot');
2707: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2708: FND_MSG_PUB.ADD;
2709: RAISE FND_API.G_EXC_ERROR;
2710: END IF;
2711: l_need_update_default_lot := FALSE;
2712:

Line 2755: FND_MSG_PUB.ADD;

2751: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Get_Allocation.', 'pick_lots.log');
2752: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2753: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
2754: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2755: FND_MSG_PUB.ADD;
2756: RAISE FND_API.G_EXC_ERROR;
2757: END IF;
2758:
2759: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Not updating the default, save orig trans to local rec.', 'pick_lots.log');

Line 2783: FND_MSG_PUB.ADD;

2779: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_Lots: Error Returned by Validation_ictran_rec.', 'pick_lots.log');
2780: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2781: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_ictran_rec');
2782: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2783: FND_MSG_PUB.ADD;
2784: RAISE FND_API.G_EXC_ERROR;
2785: END IF;
2786:
2787: l_ic_tran_rec.doc_id := l_demand_source_header_id;

Line 2853: FND_MSG_PUB.Add;

2849: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2850: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2851: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
2852: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2853: FND_MSG_PUB.Add;
2854: RAISE FND_API.G_EXC_ERROR;
2855: END IF;
2856: ELSE
2857: /* Need to delete the Original transaction, and then create a new one. */

Line 2891: FND_MSG_PUB.Add;

2887: GMI_Reservation_Util.PrintLn('(opm_dbg) In Set_Pick_Lots, Error returned by Delete_Reservation, Error='||x_return_status, 'pick_lots.log');
2888: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2889: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_PVT.Delete_Reservation');
2890: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2891: FND_MSG_PUB.Add;
2892: RAISE FND_API.G_EXC_ERROR;
2893: END IF;
2894:
2895: END IF;

Line 2951: FND_MSG_PUB.Add;

2947: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
2948: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2949: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
2950: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2951: FND_MSG_PUB.Add;
2952: RAISE FND_API.G_EXC_ERROR;
2953: END IF;
2954:
2955: /* Begin enhancement 1928979 - lakshmi swamy */

Line 2967: FND_MSG_PUB.Add;

2963: GMI_reservation_Util.PrintLn('(opm_dbg) in Set_Pick_lots: Error returned by GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip.', 'pick_lots.log');
2964: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
2965: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Manual_Alloc_Pickslip');
2966: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
2967: FND_MSG_PUB.Add;
2968: RAISE FND_API.G_EXC_ERROR;
2969: END IF;
2970:
2971: UPDATE ic_tran_pnd

Line 3095: FND_MSG_PUB.Add;

3091: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback)');
3092: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3093: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3094: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3095: FND_MSG_PUB.Add;
3096: x_return_status := FND_API.G_RET_STS_ERROR;
3097:
3098: /* Get message count and data */
3099: FND_MSG_PUB.count_and_get

Line 3099: FND_MSG_PUB.count_and_get

3095: FND_MSG_PUB.Add;
3096: x_return_status := FND_API.G_RET_STS_ERROR;
3097:
3098: /* Get message count and data */
3099: FND_MSG_PUB.count_and_get
3100: ( p_count => x_msg_count
3101: , p_data => x_msg_data
3102: );
3103:

Line 3111: FND_MSG_PUB.Add;

3107: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. Error (Rollback) - lock error in Move Order Line', 'pick_lots.log');
3108: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3109: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3110: FND_MESSAGE.Set_Token('WHAT', 'LockError');
3111: FND_MSG_PUB.Add;
3112: x_return_status := FND_API.G_RET_STS_ERROR;
3113:
3114: WHEN OTHERS THEN
3115: ROLLBACK TO SAVEPOINT Accept_Pick_Lots;

Line 3120: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

3116:
3117: GMI_Reservation_Util.printLn('End of Set_Pick_Lots. ErrorOthers (Rollback)');
3118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3119:
3120: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
3121: , l_api_name
3122: );
3123:
3124: /* Get message count and data */

Line 3125: FND_MSG_PUB.count_and_get

3121: , l_api_name
3122: );
3123:
3124: /* Get message count and data */
3125: FND_MSG_PUB.count_and_get
3126: ( p_count => x_msg_count
3127: , p_data => x_msg_data
3128: );
3129:

Line 3343: FND_MSG_PUB.Add;

3339: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3340: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3341: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
3342: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
3343: FND_MSG_PUB.Add;
3344: RAISE FND_API.G_EXC_ERROR;
3345: END IF;
3346:
3347: l_ic_tran_rec.trans_id := null;

Line 3372: FND_MSG_PUB.Add;

3368: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3369: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3370: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3371: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3372: FND_MSG_PUB.Add;
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;
3375: /* cancel all the reservations for GME */
3376: GMI_reservation_Util.PrintLn('(opm_dbg)in balancing the default lot, cancel reservation for line_id '||l_ic_tran_rec.line_id);

Line 3405: FND_MSG_PUB.Add;

3401: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3402: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3403: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
3404: FND_MESSAGE.Set_Token('WHERE', 'Set_Pick_Lots');
3405: FND_MSG_PUB.Add;
3406: RAISE FND_API.G_EXC_ERROR;
3407: END IF;
3408: END IF;
3409: /* if the trans_qty is 0, remove all the outstand GME reservations as well */

Line 3485: FND_MSG_PUB.Add;

3481: GMI_reservation_Util.PrintLn('(opm_dbg) in end of Create_Empty_Default_Lot c ERROR:Returned by Lock_Inventory.');
3482: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3483: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
3484: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3485: FND_MSG_PUB.Add;
3486: RAISE FND_API.G_EXC_ERROR;
3487: END IF;
3488:
3489: /* ============================================================================================= */

Line 3562: FND_MSG_PUB.Add;

3558: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3559: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3560: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3561: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3562: FND_MSG_PUB.Add;
3563: RAISE FND_API.G_EXC_ERROR;
3564: END IF;
3565: ELSE
3566: GMI_reservation_Util.PrintLn('(opm_dbg) Dont create the default lot again (Shouldnt be here) - 2 ! ');

Line 3603: FND_MSG_PUB.ADD;

3599: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: No Error but No Rows Found in reservation (ERROR)', 'pick_lots.log');
3600: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3601: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3602: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3603: FND_MSG_PUB.ADD;
3604: RAISE FND_API.G_EXC_ERROR;
3605: END IF;
3606:
3607: /* There may have been a problem getting the rows */

Line 3614: FND_MSG_PUB.ADD;

3610: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Query_Reservation(2).', 'pick_lots.log');
3611: FND_MESSAGE.SET_NAME('GMI','GMI_QRY_RSV_FAILED');
3612: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3613: FND_MESSAGE.Set_Token('SO_LINE_ID', l_rsv_rec.demand_source_line_id);
3614: FND_MSG_PUB.ADD;
3615: RAISE FND_API.G_EXC_ERROR;
3616: END IF;
3617:
3618: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: we have rows now calling Get_Default_Lot.', 'pick_lots.log');

Line 3630: FND_MSG_PUB.ADD;

3626: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Error Returned by Get_Default_Lot.', 'pick_lots.log');
3627: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3628: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3629: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3630: FND_MSG_PUB.ADD;
3631: RAISE FND_API.G_EXC_ERROR;
3632: END IF;
3633:
3634: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: default_lot_index='||x_default_lot_index, 'pick_lots.log');

Line 3641: FND_MSG_PUB.ADD;

3637: GMI_reservation_Util.PrintLn('(opm_dbg) in Create_Empty_Default_Lot: Still no default lot = ERROR.', 'pick_lots.log');
3638: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
3639: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
3640: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3641: FND_MSG_PUB.ADD;
3642: RAISE FND_API.G_EXC_ERROR;
3643: END IF;
3644:
3645: EXCEPTION

Line 3653: FND_MSG_PUB.Add;

3649: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. Error');
3650: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3651: FND_MESSAGE.Set_Token('WHERE', 'Create_Empty_Default_Lot');
3652: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3653: FND_MSG_PUB.Add;
3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655:
3656: /* Get message count and data */
3657: FND_MSG_PUB.count_and_get

Line 3657: FND_MSG_PUB.count_and_get

3653: FND_MSG_PUB.Add;
3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655:
3656: /* Get message count and data */
3657: FND_MSG_PUB.count_and_get
3658: ( p_count => x_msg_count
3659: , p_data => x_msg_data
3660: );
3661:

Line 3668: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

3664:
3665: GMI_Reservation_Util.printLn('End of Create_Empty_Default_Lot. ErrorOthers');
3666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3667:
3668: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
3669: , l_api_name
3670: );
3671:
3672: /* Get message count and data */

Line 3673: FND_MSG_PUB.count_and_get

3669: , l_api_name
3670: );
3671:
3672: /* Get message count and data */
3673: FND_MSG_PUB.count_and_get
3674: ( p_count => x_msg_count
3675: , p_data => x_msg_data
3676: );
3677:

Line 3729: FND_MSG_PUB.Add;

3725: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. Error');
3726: FND_MESSAGE.Set_Name('GMI','UNEXPECTED_ERROR');
3727: FND_MESSAGE.Set_Token('WHERE', 'Default_Lot_Exist');
3728: FND_MESSAGE.Set_Token('WHAT', 'ExpectedError');
3729: FND_MSG_PUB.Add;
3730: x_return_status := FND_API.G_RET_STS_ERROR;
3731:
3732: /* Get message count and data */
3733: FND_MSG_PUB.count_and_get

Line 3733: FND_MSG_PUB.count_and_get

3729: FND_MSG_PUB.Add;
3730: x_return_status := FND_API.G_RET_STS_ERROR;
3731:
3732: /* Get message count and data */
3733: FND_MSG_PUB.count_and_get
3734: ( p_count => x_msg_count
3735: , p_data => x_msg_data
3736: );
3737:

Line 3742: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

3738: WHEN OTHERS THEN
3739: GMI_Reservation_Util.printLn('End of Default_Lot_Exist. ErrorOthers');
3740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3741:
3742: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
3743: , l_api_name
3744: );
3745:
3746: /* Get message count and data */

Line 3747: FND_MSG_PUB.count_and_get

3743: , l_api_name
3744: );
3745:
3746: /* Get message count and data */
3747: FND_MSG_PUB.count_and_get
3748: ( p_count => x_msg_count
3749: , p_data => x_msg_data
3750: );
3751:

Line 3877: FND_MSG_PUB.Add;

3873: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
3874: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
3875: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
3876: FND_MESSAGE.Set_Token('WHERE','Create_Default_Lot');
3877: FND_MSG_PUB.Add;
3878: raise FND_API.G_EXC_ERROR;
3879: END IF;
3880: END create_dflt_lot_from_scratch;
3881:

Line 4164: FND_MSG_PUB.Add;

4160: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4161: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4162: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4163: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4164: FND_MSG_PUB.Add;
4165: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4166: END IF;
4167:
4168: l_ictran_rec.trans_id := l_tran_row.trans_id;

Line 4194: FND_MSG_PUB.Add;

4190: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4191: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4192: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
4193: FND_MESSAGE.Set_Token('WHERE','create_transaction_for_rcv');
4194: FND_MSG_PUB.Add;
4195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4196: END IF;
4197:
4198: EXCEPTION

Line 4203: FND_MSG_PUB.count_and_get

4199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4200: x_return_status := FND_API.G_RET_STS_ERROR;
4201:
4202: /* Get message count and data */
4203: FND_MSG_PUB.count_and_get
4204: ( p_encoded=> FND_API.G_FALSE
4205: , p_count => x_msg_count
4206: , p_data => x_msg_data
4207: );

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

4205: , p_count => x_msg_count
4206: , p_data => x_msg_data
4207: );
4208: for l_cnt in 1..x_msg_count loop
4209: l_msg_data := FND_MSG_PUB.GET(l_cnt,'F');
4210: GMI_reservation_Util.PrintLn('for_rcv '||l_msg_data);
4211: end loop;
4212: GMI_reservation_Util.PrintLn('for rcv:EXP Error count='||x_msg_count);
4213:

Line 4217: FND_MSG_PUB.Add_Exc_Msg ( 'RESERVATION_UTIL'

4213:
4214: WHEN OTHERS THEN
4215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4216:
4217: FND_MSG_PUB.Add_Exc_Msg ( 'RESERVATION_UTIL'
4218: , 'create_trans_for_rcv'
4219: );
4220:
4221: /* Get message count and data */

Line 4222: FND_MSG_Pub.Count_and_Get

4218: , 'create_trans_for_rcv'
4219: );
4220:
4221: /* Get message count and data */
4222: FND_MSG_Pub.Count_and_Get
4223: ( p_count => x_msg_count
4224: , p_data => x_msg_data
4225: );
4226:

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

4224: , p_data => x_msg_data
4225: );
4226:
4227: for l_cnt in 1..x_msg_count loop
4228: l_msg_data := FND_MSG_PUB.GET(l_cnt,'F');
4229: GMI_reservation_Util.PrintLn('for_rcv '||l_msg_data);
4230: end loop;
4231: GMI_reservation_Util.PrintLn('for rcv:EXP Error count='||x_msg_count);
4232:

Line 4444: FND_MSG_PUB.Add;

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

Line 4457: FND_MSG_PUB.Add;

4453: x_msg_data =>l_msg_data);
4454: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
4455: FND_MESSAGE.Set_Name('GMI','GMI_OPM_UOM_NOT_FOUND');
4456: FND_MESSAGE.Set_Token('APPS_UOM_CODE', p_apps_to_uom);
4457: FND_MSG_PUB.Add;
4458: RAISE FND_API.G_EXC_ERROR;
4459: END IF;
4460: GMI_reservation_Util.PrintLn('to uom (OPM) '||l_opm_to_uom);
4461:

Line 4473: FND_MSG_PUB.Add;

4469: IF l_converted_qty < 0 THEN
4470: GMI_reservation_Util.PrintLn('conversion error code'|| l_converted_qty);
4471: FND_MESSAGE.Set_Name('GMI','GMICUOM.icuomcv');
4472: FND_MESSAGE.Set_Token('CONVERSION_ERROR', p_apps_to_uom);
4473: FND_MSG_PUB.Add;
4474: RAISE FND_API.G_EXC_ERROR;
4475: END IF;
4476:
4477: --

Line 4788: FND_MSG_PUB.Add;

4784: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4785: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4786: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4787: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4788: FND_MSG_PUB.Add;
4789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4790: END IF;
4791: END IF;
4792: END IF;

Line 4852: FND_MSG_PUB.Add;

4848: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
4849: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
4850: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION');
4851: FND_MESSAGE.Set_Token('WHERE','split_trans_from_om');
4852: FND_MSG_PUB.Add;
4853:
4854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4855: END IF;
4856: /* no more fulfilment */

Line 5050: FND_MSG_PUB.Add;

5046: GMI_reservation_Util.PrintLn('Error Message '|| x_msg_data);
5047: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
5048: FND_MESSAGE.Set_Token('BY_PROC','GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TO_COMPLETED');
5049: FND_MESSAGE.Set_Token('WHERE','update_opm_trxns');
5050: FND_MSG_PUB.Add;
5051: x_return_status := FND_API.G_RET_STS_ERROR;
5052: RETURN;
5053: END IF; -- of update
5054:

Line 5170: FND_MSG_Pub.count_and_get

5166: WHEN FND_API.G_EXC_ERROR THEN
5167:
5168: x_return_status := FND_API.G_RET_STS_ERROR;
5169:
5170: FND_MSG_Pub.count_and_get
5171: ( p_count => x_msg_count
5172: , p_data => x_msg_data
5173: );
5174:

Line 5179: FND_MSG_PUB.Count_And_Get

5175: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Exp_Error ');
5176:
5177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5179: FND_MSG_PUB.Count_And_Get
5180: (
5181: p_count => x_msg_count,
5182: p_data => x_msg_data,
5183: p_encoded => FND_API.G_FALSE

Line 5190: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

5186: WHEN OTHERS THEN
5187: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Error in Select='||SQLCODE||'.');
5188: x_return_status := SQLCODE;
5189:
5190: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
5191: , l_api_name
5192: );
5193:
5194: /* Get message count and data */

Line 5195: FND_MSG_Pub.count_and_get

5191: , l_api_name
5192: );
5193:
5194: /* Get message count and data */
5195: FND_MSG_Pub.count_and_get
5196: ( p_count => x_msg_count
5197: , p_data => x_msg_data
5198: );
5199:

Line 5299: FND_MSG_Pub.count_and_get

5295: WHEN FND_API.G_EXC_ERROR THEN
5296:
5297: x_return_status := FND_API.G_RET_STS_ERROR;
5298:
5299: FND_MSG_Pub.count_and_get
5300: ( p_count => x_msg_count
5301: , p_data => x_msg_data
5302: );
5303:

Line 5308: FND_MSG_PUB.Count_And_Get

5304: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Exp_Error ');
5305:
5306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5308: FND_MSG_PUB.Count_And_Get
5309: (
5310: p_count => x_msg_count,
5311: p_data => x_msg_data,
5312: p_encoded => FND_API.G_FALSE

Line 5319: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

5315: WHEN OTHERS THEN
5316: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Error in Select='||SQLCODE||'.');
5317: x_return_status := SQLCODE;
5318:
5319: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
5320: , l_api_name
5321: );
5322:
5323: /* Get message count and data */

Line 5324: FND_MSG_Pub.count_and_get

5320: , l_api_name
5321: );
5322:
5323: /* Get message count and data */
5324: FND_MSG_Pub.count_and_get
5325: ( p_count => x_msg_count
5326: , p_data => x_msg_data
5327: );
5328:

Line 5404: FND_MSG_PUB.Add;

5400: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5401: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5402: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5403: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5404: FND_MSG_PUB.Add;
5405: raise FND_API.G_EXC_ERROR;
5406: END IF;
5407:
5408: IF ( l_ic_item_mst_rec.lot_indivisible = 1 ) THEN

Line 5454: FND_MSG_Pub.count_and_get

5450: WHEN FND_API.G_EXC_ERROR THEN
5451:
5452: x_return_status := FND_API.G_RET_STS_ERROR;
5453:
5454: FND_MSG_Pub.count_and_get
5455: ( p_count => x_msg_count
5456: , p_data => x_msg_data
5457: );
5458:

Line 5463: FND_MSG_PUB.Count_And_Get

5459: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Exp_Error ');
5460:
5461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5463: FND_MSG_PUB.Count_And_Get
5464: (
5465: p_count => x_msg_count,
5466: p_data => x_msg_data,
5467: p_encoded => FND_API.G_FALSE

Line 5474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

5470: WHEN OTHERS THEN
5471: GMI_reservation_Util.PrintLn('(opm_dbg) in Util q: Error in Select='||SQLCODE||'.');
5472: x_return_status := SQLCODE;
5473:
5474: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
5475: , l_api_name
5476: );
5477:
5478: /* Get message count and data */

Line 5479: FND_MSG_Pub.count_and_get

5475: , l_api_name
5476: );
5477:
5478: /* Get message count and data */
5479: FND_MSG_Pub.count_and_get
5480: ( p_count => x_msg_count
5481: , p_data => x_msg_data
5482: );
5483:

Line 5559: FND_MSG_PUB.Add;

5555: IF (return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5556: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
5557: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
5558: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
5559: FND_MSG_PUB.Add;
5560: x_check_status := 0;
5561: raise FND_API.G_EXC_ERROR;
5562: END IF;
5563:

Line 5639: FND_MSG_Pub.count_and_get

5635: WHEN FND_API.G_EXC_ERROR THEN
5636:
5637: x_return_status := FND_API.G_RET_STS_ERROR;
5638:
5639: FND_MSG_Pub.count_and_get
5640: ( p_count => x_msg_count
5641: , p_data => x_msg_data
5642: );
5643:

Line 5650: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

5646: WHEN OTHERS THEN
5647: GMI_reservation_Util.PrintLn('(opm_dbg) in Util validate_opm_quantities: Error in Select='||SQLCODE||'.');
5648: x_return_status := SQLCODE;
5649:
5650: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
5651: , l_api_name
5652: );
5653:
5654: /* Get message count and data */

Line 5655: FND_MSG_Pub.count_and_get

5651: , l_api_name
5652: );
5653:
5654: /* Get message count and data */
5655: FND_MSG_Pub.count_and_get
5656: ( p_count => x_msg_count
5657: , p_data => x_msg_data
5658: );
5659: