DBA Data[Home] [Help]

APPS.OE_SCHEDULE_GRP dependencies on FND_MESSAGE

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

330: ,p_entity_id => g_sch_tbl(I).line_id
331: ,p_header_id => g_sch_tbl(I).header_id
332: ,p_line_id => g_sch_tbl(I).line_id);
333:
334: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_LOOP_LINE');
335: FND_MESSAGE.SET_TOKEN('LINE_ID',g_sch_tbl(I).line_id);
336: OE_MSG_PUB.ADD;
337: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
338: goto end_main_loop;

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

331: ,p_header_id => g_sch_tbl(I).header_id
332: ,p_line_id => g_sch_tbl(I).line_id);
333:
334: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_LOOP_LINE');
335: FND_MESSAGE.SET_TOKEN('LINE_ID',g_sch_tbl(I).line_id);
336: OE_MSG_PUB.ADD;
337: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
338: goto end_main_loop;
339: END;

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

364: IF g_sch_tbl(I).Orig_Schedule_Ship_Date IS NOT NULL
365: AND trunc(l_line_rec.Schedule_Ship_Date) <>
366: trunc(g_sch_tbl(I).Orig_Schedule_Ship_Date) THEN
367:
368: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
369: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
370: OE_Order_Util.Get_Attribute_Name('Schedule_Ship_Date'));
371: OE_MSG_PUB.ADD;
372: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 369: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

365: AND trunc(l_line_rec.Schedule_Ship_Date) <>
366: trunc(g_sch_tbl(I).Orig_Schedule_Ship_Date) THEN
367:
368: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
369: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
370: OE_Order_Util.Get_Attribute_Name('Schedule_Ship_Date'));
371: OE_MSG_PUB.ADD;
372: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
373:

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

377: AND trunc(l_line_rec.Schedule_Arrival_date) <>
378: trunc(g_sch_tbl(I).Orig_Schedule_arrival_date)
379: THEN
380:
381: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
382: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
383: OE_Order_Util.Get_Attribute_Name('Schedule_Arrival_date'));
384: OE_MSG_PUB.ADD;
385: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 382: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

378: trunc(g_sch_tbl(I).Orig_Schedule_arrival_date)
379: THEN
380:
381: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
382: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
383: OE_Order_Util.Get_Attribute_Name('Schedule_Arrival_date'));
384: OE_MSG_PUB.ADD;
385: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
386:

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

390: AND l_line_rec.ship_from_org_id <>
391: g_sch_tbl(I).Orig_ship_from_org_id
392: THEN
393:
394: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
396: OE_Order_Util.Get_Attribute_Name('ship_from_org_id'));
397: OE_MSG_PUB.ADD;
398: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

391: g_sch_tbl(I).Orig_ship_from_org_id
392: THEN
393:
394: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
396: OE_Order_Util.Get_Attribute_Name('ship_from_org_id'));
397: OE_MSG_PUB.ADD;
398: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
399:

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

403: AND l_line_rec.Shipping_Method_Code <>
404: g_sch_tbl(I).Orig_Shipping_Method_Code
405: THEN
406:
407: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
409: OE_Order_Util.Get_Attribute_Name('Shipping_Method_Code'));
410: OE_MSG_PUB.ADD;
411: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

404: g_sch_tbl(I).Orig_Shipping_Method_Code
405: THEN
406:
407: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
408: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
409: OE_Order_Util.Get_Attribute_Name('Shipping_Method_Code'));
410: OE_MSG_PUB.ADD;
411: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
412:

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

416: AND l_line_rec.ordered_quantity <>
417: g_sch_tbl(I).Orig_ordered_quantity
418: THEN
419:
420: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
422: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
423: OE_MSG_PUB.ADD;
424: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

417: g_sch_tbl(I).Orig_ordered_quantity
418: THEN
419:
420: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
421: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
422: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
423: OE_MSG_PUB.ADD;
424: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
425:

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

431: trunc(g_sch_tbl(I).Orig_Earliest_Ship_date)
432:
433: THEN
434:
435: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
436: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
437: OE_Order_Util.Get_Attribute_Name('Earliest_Ship_date'));
438: OE_MSG_PUB.ADD;
439: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 436: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

432:
433: THEN
434:
435: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
436: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
437: OE_Order_Util.Get_Attribute_Name('Earliest_Ship_date'));
438: OE_MSG_PUB.ADD;
439: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
440:

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

445: AND NOT l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
446:
447: oe_debug_pub.add('E4',2);
448: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
450: OE_MSG_PUB.ADD;
451: END IF;
452:
453: /* Added for ER 6110708 to support Item Substitutions from Planning Loop Back */

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

462: -- If Item on the Sales Order Line has changed after running the plan and
463: -- before Planning releases the recommendations, then we should not accept the Item
464: -- Substitution. This means that planning has recommended item substitution based on old data.
465: IF l_line_rec.inventory_item_id <> g_sch_tbl(I).orig_inventory_item_id THEN
466: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
468: OE_Order_Util.Get_Attribute_Name('inventory_item_id'));
469: OE_MSG_PUB.ADD;
470: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;

Line 467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

463: -- before Planning releases the recommendations, then we should not accept the Item
464: -- Substitution. This means that planning has recommended item substitution based on old data.
465: IF l_line_rec.inventory_item_id <> g_sch_tbl(I).orig_inventory_item_id THEN
466: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
468: OE_Order_Util.Get_Attribute_Name('inventory_item_id'));
469: OE_MSG_PUB.ADD;
470: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
471: END IF;

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

512: ( nvl(l_line_rec.booked_flag, 'N') = 'Y' and nvl(l_line_rec.reserved_quantity, 0) <> 0 ) -- Booked Line with Reservations
513: )
514: THEN
515: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
517: OE_MSG_PUB.ADD;
518: END IF;
519:
520: -- Do not allow substitution of Shippable Item with non-Shippable and vise versa once the Line is Booked.

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

527: AND ORGANIZATION_ID = nvl(g_sch_tbl(I).ship_from_org_id, l_line_rec.ship_from_org_id);
528:
529: IF l_shippable_flag <> l_line_rec.shippable_flag THEN
530: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_SHP_NONSHP');
532: OE_MSG_PUB.ADD;
533: END IF;
534: END;
535: END IF;

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

591: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
592: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
593: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
594: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
595: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
596: OE_MSG_PUB.ADD;
597: goto end_loop;
598: END IF;
599: */

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

608: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
609: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
610: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
611: l_local_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
612: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
613: oe_msg_pub.add;
614: goto end_loop;
615: END IF;
616: */

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

713: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
714: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
715: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
716: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
717: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
718: OE_MSG_PUB.ADD;
719: goto end_loop1;
720: END IF;
721: */ l_line_rec.schedule_ship_date := g_sch_tbl(I).schedule_ship_date;

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

726: oe_debug_pub.add('Schedule Ship Date connot be less than request_date');
727: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
728: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;
729: l_line_rec.return_status := FND_API.G_RET_STS_ERROR;
730: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_INVALID_DATE');
731: oe_msg_pub.add;
732: goto end_loop1;
733: END IF;
734: */ l_line_rec.schedule_arrival_date := g_sch_tbl(I).schedule_arrival_date;

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

1064: ,p_line_id => g_sch_tbl(I).line_id);
1065:
1066: oe_debug_pub.add('ONT_SCH_LOOP_DATE_NULL',1);
1067: g_sch_tbl(I).x_return_status := FND_API.G_RET_STS_ERROR;
1068: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_DATE_NULL');
1069: OE_MSG_PUB.ADD;
1070:
1071: END IF;
1072:

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

1134: IF g_line_tbl(I).schedule_status_code is null THEN
1135:
1136: oe_debug_pub.add('E1',2);
1137: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1138: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_CANT_UPDATE');
1139: OE_MSG_PUB.ADD;
1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141: END IF;
1142: */

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

1143: IF g_line_tbl(I).cancelled_flag = 'Y' THEN
1144:
1145: oe_debug_pub.add('E1-1',2);
1146: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1147: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_FULLY_CANCELLED');
1148: OE_MSG_PUB.ADD;
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150: END IF;
1151:

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

1152: IF g_line_tbl(I).shipped_quantity is not null THEN
1153:
1154: oe_debug_pub.add('E1-2',2);
1155: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1156: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LINE_SHIPPED');
1157: OE_MSG_PUB.ADD;
1158: x_return_status := FND_API.G_RET_STS_ERROR;
1159: END IF;
1160:

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

1166: g_old_line_tbl(I).ship_from_org_id) THEN
1167:
1168: oe_debug_pub.add('E2',2);
1169: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1170: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_FRMD');
1171: OE_MSG_PUB.ADD;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: END IF; */
1174:

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

1175: IF g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
1176:
1177: oe_debug_pub.add('E3',2);
1178: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1179: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_SRV');
1180: OE_MSG_PUB.ADD;
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: END IF;
1183:

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

1186: g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN
1187:
1188: oe_debug_pub.add('E4',2);
1189: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1190: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1191: OE_MSG_PUB.ADD;
1192: x_return_status := FND_API.G_RET_STS_ERROR;
1193: END IF;
1194: */

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

1194: */
1195: IF nvl(g_line_tbl(I).model_remnant_flag,'N') = 'Y' THEN
1196: oe_debug_pub.add('E5',2);
1197: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1198: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1199: OE_MSG_PUB.ADD;
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201:
1202: END IF;

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

1205: IF g_line_tbl(I).line_category_code = 'RETURN' THEN
1206:
1207: oe_debug_pub.add('E6',2);
1208: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1209: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_RET');
1210: OE_MSG_PUB.ADD;
1211: x_return_status := FND_API.G_RET_STS_ERROR;
1212: END IF;
1213:

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

1214: IF OE_OTA_UTIL.Is_OTA_Line(g_line_tbl(I).order_quantity_uom) THEN
1215:
1216: oe_debug_pub.add('E7',2);
1217: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1218: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1219: OE_MSG_PUB.ADD;
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221: END IF;
1222:

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

1223: IF g_line_tbl(I).source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN
1224:
1225: oe_debug_pub.add('E8',2);
1226: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1227: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_EXT');
1228: OE_MSG_PUB.ADD;
1229: x_return_status := FND_API.G_RET_STS_ERROR;
1230: END IF;
1231:

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

1238: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_ONE THEN
1239:
1240: oe_debug_pub.add('E9',2);
1241: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1242: FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_LVL');
1243: OE_MSG_PUB.ADD;
1244: x_return_status := FND_API.G_RET_STS_ERROR;
1245:
1246:

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

1265: NVL(g_sch_tbl(I).ship_from_org_id,g_line_tbl(I).ship_from_org_id)
1266: THEN
1267: oe_debug_pub.add('E10',2);
1268: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1269: FND_MESSAGE.SET_NAMe('ONT', 'OE_SCH_LOOP_WSH_UPD');
1270: OE_MSG_PUB.ADD;
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272:
1273: END IF;

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

1299:
1300: IF (l_result = FND_API.G_TRUE) THEN
1301: oe_debug_pub.add('E11',2);
1302: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;
1303: FND_MESSAGE.SET_NAME('ONT','OE_SCH_LINE_ON_HOLD');
1304: OE_MSG_PUB.Add;
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: END IF;
1307:

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

1405:
1406: IF NOT l_result THEN
1407:
1408: oe_debug_pub.add('E10',2);
1409: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_LOOP_NOT_SUP');
1410: OE_MSG_PUB.ADD;
1411: IF p_ship_set_id IS NOT NULL THEN
1412:
1413: FOR J IN 1..g_line_tbl.count LOOP