DBA Data[Home] [Help]

APPS.OE_SCHEDULE_GRP dependencies on FND_MESSAGE

Line 203: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_LOOP_LINE');

199: ,p_entity_id => g_sch_tbl(I).line_id
200: ,p_header_id => g_sch_tbl(I).header_id
201: ,p_line_id => g_sch_tbl(I).line_id);
202:
203: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_LOOP_LINE');
204: FND_MESSAGE.SET_TOKEN('LINE_ID',g_sch_tbl(I).line_id);
205: OE_MSG_PUB.ADD;
206: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
207: goto end_main_loop;

Line 204: FND_MESSAGE.SET_TOKEN('LINE_ID',g_sch_tbl(I).line_id);

200: ,p_header_id => g_sch_tbl(I).header_id
201: ,p_line_id => g_sch_tbl(I).line_id);
202:
203: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_LOOP_LINE');
204: FND_MESSAGE.SET_TOKEN('LINE_ID',g_sch_tbl(I).line_id);
205: OE_MSG_PUB.ADD;
206: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
207: goto end_main_loop;
208: END;

Line 237: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');

233: IF g_sch_tbl(I).Orig_Schedule_Ship_Date IS NOT NULL
234: AND trunc(l_line_rec.Schedule_Ship_Date) <>
235: trunc(g_sch_tbl(I).Orig_Schedule_Ship_Date) THEN
236:
237: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
239: OE_Order_Util.Get_Attribute_Name('Schedule_Ship_Date'));
240: OE_MSG_PUB.ADD;
241: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

234: AND trunc(l_line_rec.Schedule_Ship_Date) <>
235: trunc(g_sch_tbl(I).Orig_Schedule_Ship_Date) THEN
236:
237: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
238: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
239: OE_Order_Util.Get_Attribute_Name('Schedule_Ship_Date'));
240: OE_MSG_PUB.ADD;
241: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
242:

Line 250: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');

246: AND trunc(l_line_rec.Schedule_Arrival_date) <>
247: trunc(g_sch_tbl(I).Orig_Schedule_arrival_date)
248: THEN
249:
250: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
252: OE_Order_Util.Get_Attribute_Name('Schedule_Arrival_date'));
253: OE_MSG_PUB.ADD;
254: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

247: trunc(g_sch_tbl(I).Orig_Schedule_arrival_date)
248: THEN
249:
250: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
252: OE_Order_Util.Get_Attribute_Name('Schedule_Arrival_date'));
253: OE_MSG_PUB.ADD;
254: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
255:

Line 263: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');

259: AND l_line_rec.ship_from_org_id <>
260: g_sch_tbl(I).Orig_ship_from_org_id
261: THEN
262:
263: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
265: OE_Order_Util.Get_Attribute_Name('ship_from_org_id'));
266: OE_MSG_PUB.ADD;
267: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

260: g_sch_tbl(I).Orig_ship_from_org_id
261: THEN
262:
263: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
264: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
265: OE_Order_Util.Get_Attribute_Name('ship_from_org_id'));
266: OE_MSG_PUB.ADD;
267: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
268:

Line 276: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');

272: AND l_line_rec.Shipping_Method_Code <>
273: g_sch_tbl(I).Orig_Shipping_Method_Code
274: THEN
275:
276: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
278: OE_Order_Util.Get_Attribute_Name('Shipping_Method_Code'));
279: OE_MSG_PUB.ADD;
280: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

273: g_sch_tbl(I).Orig_Shipping_Method_Code
274: THEN
275:
276: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
278: OE_Order_Util.Get_Attribute_Name('Shipping_Method_Code'));
279: OE_MSG_PUB.ADD;
280: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
281:

Line 289: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');

285: AND l_line_rec.ordered_quantity <>
286: g_sch_tbl(I).Orig_ordered_quantity
287: THEN
288:
289: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
291: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
292: OE_MSG_PUB.ADD;
293: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

286: g_sch_tbl(I).Orig_ordered_quantity
287: THEN
288:
289: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
290: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
291: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
292: OE_MSG_PUB.ADD;
293: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
294:

Line 304: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');

300: trunc(g_sch_tbl(I).Orig_Earliest_Ship_date)
301:
302: THEN
303:
304: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
306: OE_Order_Util.Get_Attribute_Name('Earliest_Ship_date'));
307: OE_MSG_PUB.ADD;
308: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

301:
302: THEN
303:
304: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
306: OE_Order_Util.Get_Attribute_Name('Earliest_Ship_date'));
307: OE_MSG_PUB.ADD;
308: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
309:

Line 318: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');

314: AND NOT l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
315:
316: oe_debug_pub.add('E4',2);
317: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
318: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
319: OE_MSG_PUB.ADD;
320: END IF;
321:
322: /* Added for ER 6110708 to support Item Substitutions from Planning Loop Back */

Line 335: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');

331: -- If Item on the Sales Order Line has changed after running the plan and
332: -- before Planning releases the recommendations, then we should not accept the Item
333: -- Substitution. This means that planning has recommended item substitution based on old data.
334: IF l_line_rec.inventory_item_id <> g_sch_tbl(I).orig_inventory_item_id THEN
335: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
337: OE_Order_Util.Get_Attribute_Name('inventory_item_id'));
338: OE_MSG_PUB.ADD;
339: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

332: -- before Planning releases the recommendations, then we should not accept the Item
333: -- Substitution. This means that planning has recommended item substitution based on old data.
334: IF l_line_rec.inventory_item_id <> g_sch_tbl(I).orig_inventory_item_id THEN
335: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
337: OE_Order_Util.Get_Attribute_Name('inventory_item_id'));
338: OE_MSG_PUB.ADD;
339: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
340: END IF;

Line 377: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');

373: ( nvl(l_line_rec.booked_flag, 'N') = 'Y' and nvl(l_line_rec.reserved_quantity, 0) <> 0 ) -- Booked Line with Reservations
374: )
375: THEN
376: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
377: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
378: OE_MSG_PUB.ADD;
379: END IF;
380:
381: -- Do not allow substitution of Shippable Item with non-Shippable and vise versa once the Line is Booked.

Line 392: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_SHP_NONSHP');

388: AND ORGANIZATION_ID = nvl(g_sch_tbl(I).ship_from_org_id, l_line_rec.ship_from_org_id);
389:
390: IF l_shippable_flag <> l_line_rec.shippable_flag THEN
391: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
392: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_SHP_NONSHP');
393: OE_MSG_PUB.ADD;
394: END IF;
395: END;
396: END IF;

Line 448: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');

444: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
445: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
446: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
447: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
448: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
449: OE_MSG_PUB.ADD;
450: goto end_loop;
451: END IF;
452: */

Line 465: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');

461: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
462: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
463: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
464: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
465: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
466: oe_msg_pub.add;
467: goto end_loop;
468: END IF;
469: */

Line 562: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');

558: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
559: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
560: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
561: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
562: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
563: OE_MSG_PUB.ADD;
564: goto end_loop1;
565: END IF;
566: */ l_line_rec.schedule_ship_date := g_sch_tbl(I).schedule_ship_date;

Line 575: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');

571: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
572: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
573: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
574: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
575: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
576: oe_msg_pub.add;
577: goto end_loop1;
578: END IF;
579: */ l_line_rec.schedule_arrival_date := g_sch_tbl(I).schedule_arrival_date;

Line 903: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_DATE_NULL');

899: ,p_line_id => g_sch_tbl(I).line_id);
900:
901: oe_debug_pub.add('ONT_SCH_LOOP_DATE_NULL',1);
902: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
903: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_DATE_NULL');
904: OE_MSG_PUB.ADD;
905:
906: END IF;
907:

Line 973: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_CANT_UPDATE');

969: IF g_line_tbl(I).schedule_status_code is null THEN
970:
971: oe_debug_pub.add('E1',2);
972: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
973: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_CANT_UPDATE');
974: OE_MSG_PUB.ADD;
975: x_return_status := FND_API.G_RET_STS_ERROR;
976: END IF;
977: */

Line 982: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_FULLY_CANCELLED');

978: IF g_line_tbl(I).cancelled_flag = 'Y' THEN
979:
980: oe_debug_pub.add('E1-1',2);
981: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
982: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_FULLY_CANCELLED');
983: OE_MSG_PUB.ADD;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: END IF;
986:

Line 991: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_SHIPPED');

987: IF g_line_tbl(I).shipped_quantity is not null THEN
988:
989: oe_debug_pub.add('E1-2',2);
990: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
991: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_SHIPPED');
992: OE_MSG_PUB.ADD;
993: x_return_status := FND_API.G_RET_STS_ERROR;
994: END IF;
995:

Line 1005: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_FRMD');

1001: g_old_line_tbl(I).ship_from_org_id) THEN
1002:
1003: oe_debug_pub.add('E2',2);
1004: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1005: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_FRMD');
1006: OE_MSG_PUB.ADD;
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: END IF; */
1009:

Line 1014: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_SRV');

1010: IF g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
1011:
1012: oe_debug_pub.add('E3',2);
1013: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1014: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_SRV');
1015: OE_MSG_PUB.ADD;
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: END IF;
1018:

Line 1025: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');

1021: g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN
1022:
1023: oe_debug_pub.add('E4',2);
1024: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1025: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1026: OE_MSG_PUB.ADD;
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;
1029: */

Line 1033: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');

1029: */
1030: IF nvl(g_line_tbl(I).model_remnant_flag,'N') = 'Y' THEN
1031: oe_debug_pub.add('E5',2);
1032: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1033: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1034: OE_MSG_PUB.ADD;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036:
1037: END IF;

Line 1044: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_RET');

1040: IF g_line_tbl(I).line_category_code = 'RETURN' THEN
1041:
1042: oe_debug_pub.add('E6',2);
1043: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1044: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_RET');
1045: OE_MSG_PUB.ADD;
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047: END IF;
1048:

Line 1053: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');

1049: IF OE_OTA_UTIL.Is_OTA_Line(g_line_tbl(I).order_quantity_uom) THEN
1050:
1051: oe_debug_pub.add('E7',2);
1052: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1053: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1054: OE_MSG_PUB.ADD;
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: END IF;
1057:

Line 1062: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_EXT');

1058: IF g_line_tbl(I).source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN
1059:
1060: oe_debug_pub.add('E8',2);
1061: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1062: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_EXT');
1063: OE_MSG_PUB.ADD;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: END IF;
1066:

Line 1077: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_LVL');

1073: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN
1074:
1075: oe_debug_pub.add('E9',2);
1076: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1077: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_LVL');
1078: OE_MSG_PUB.ADD;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080:
1081:

Line 1104: FND_MESSAGE.SET_NAMe('ONT', 'OE_SCH_LOOP_WSH_UPD');

1100: NVL(g_sch_tbl(I).ship_from_org_id,g_line_tbl(I).ship_from_org_id)
1101: THEN
1102: oe_debug_pub.add('E10',2);
1103: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1104: FND_MESSAGE.SET_NAMe('ONT', 'OE_SCH_LOOP_WSH_UPD');
1105: OE_MSG_PUB.ADD;
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107:
1108: END IF;

Line 1138: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');

1134:
1135: IF (l_result = FND_API.G_TRUE) THEN
1136: oe_debug_pub.add('E11',2);
1137: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1138: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
1139: OE_MSG_PUB.Add;
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141: END IF;
1142:

Line 1244: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');

1240:
1241: IF NOT l_result THEN
1242:
1243: oe_debug_pub.add('E10',2);
1244: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1245: OE_MSG_PUB.ADD;
1246: IF p_ship_set_id IS NOT NULL THEN
1247:
1248: FOR J IN 1..g_line_tbl.count LOOP