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.OE_SCHEDULE_GRP dependencies on OE_GLOBALS

Line 146: l_control_rec OE_GLOBALS.control_rec_type;

142: PROCEDURE Process_order(x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2)
143: IS
144: l_line_rec OE_Order_PUB.Line_Rec_type;
145: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
146: l_control_rec OE_GLOBALS.control_rec_type;
147: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
148: l_count Number;
149: l_ship_from_is_changed BOOLEAN := FALSE;
150: l_ship_method_is_changed BOOLEAN := FALSE;

Line 314: AND NOT l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

310: END IF;
311:
312: IF l_line_rec.ato_line_id is not null
313: AND l_line_rec.ato_line_id <> l_line_rec.line_id
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');

Line 366: IF ( l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD OR -- Not a Standard Item

362: oe_debug_pub.add(' OPM Enabled Org : No', 5);
363: END IF;
364: oe_debug_pub.add(' Reserved Qty : ' || nvl(l_line_rec.reserved_quantity, 0), 5);
365:
366: IF ( l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD OR -- Not a Standard Item
367: l_line_rec.line_set_id IS NOT NULL OR -- Line is Split
368: l_line_rec.split_from_line_id IS NOT NULL OR -- Split Line
369: nvl(l_line_rec.source_document_type_id, -99) = 10 OR -- Internal Sales Order Line
370: l_line_rec.source_type_code = 'EXTERNAL' OR -- Externally Sourced Line

Line 413: AND l_line_rec.item_type_code IN (OE_GLOBALS.G_ITEM_MODEL,

409: g_sch_tbl(I).x_override_atp_date_code := 'Y';
410: END IF;
411:
412: IF (l_line_rec.ato_line_id = l_line_rec.line_id
413: AND l_line_rec.item_type_code IN (OE_GLOBALS.G_ITEM_MODEL,
414: OE_GLOBALS.G_ITEM_CLASS))
415: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
416:
417: THEN

Line 414: OE_GLOBALS.G_ITEM_CLASS))

410: END IF;
411:
412: IF (l_line_rec.ato_line_id = l_line_rec.line_id
413: AND l_line_rec.item_type_code IN (OE_GLOBALS.G_ITEM_MODEL,
414: OE_GLOBALS.G_ITEM_CLASS))
415: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
416:
417: THEN
418: oe_debug_pub.add('ATO Model',2);

Line 415: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG

411:
412: IF (l_line_rec.ato_line_id = l_line_rec.line_id
413: AND l_line_rec.item_type_code IN (OE_GLOBALS.G_ITEM_MODEL,
414: OE_GLOBALS.G_ITEM_CLASS))
415: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
416:
417: THEN
418: oe_debug_pub.add('ATO Model',2);
419:

Line 446: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;

442: IF trunc(g_sch_tbl(I).schedule_ship_date) < trunc(l_local_line_tbl(J).request_date) THEN
443:
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;

Line 463: l_local_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;

459: /* IF trunc(g_sch_tbl(I).schedule_arrival_date) < trunc(l_local_line_tbl(J).request_date) THEN
460:
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;

Line 509: g_line_tbl(l_count).operation := OE_GLOBALS.G_OPR_UPDATE;

505: END IF;
506:
507: oe_debug_pub.add('Before assigning' || l_local_line_tbl(J).line_id,2);
508: g_line_tbl(l_count) := l_local_line_tbl(J);
509: g_line_tbl(l_count).operation := OE_GLOBALS.G_OPR_UPDATE;
510: g_line_tbl(l_count).return_status := Null;
511: l_count := l_count + 1;
512: <>
513: g_sch_tbl(I).x_line_number :=

Line 560: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;

556: /* IF trunc(g_sch_tbl(I).schedule_ship_date) < trunc(l_line_rec.request_date) THEN
557:
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;

Line 573: l_line_rec.operation := OE_GLOBALS.G_OPR_NONE;

569: /* IF trunc(g_sch_tbl(I).schedule_arrival_date) < trunc(l_line_rec.request_date) THEN
570:
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;

Line 616: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

612: l_ord_qty_is_changed := TRUE;
613: l_line_rec.Ordered_Quantity := g_sch_tbl(I).Ordered_Quantity;
614: END IF;
615:
616: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
617: g_line_tbl(l_count) := l_line_rec;
618: g_line_tbl(l_count).return_status := Null;
619: l_count := l_count + 1;
620: <>

Line 643: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;

639:
640: IF g_line_tbl(J).return_status <> FND_API.G_RET_STS_SUCCESS THEN
641:
642: oe_debug_pub.add('None ' || g_line_tbl(J).return_status,2);
643: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
644:
645: ELSE
646:
647:

Line 972: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

968: /*
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;

Line 981: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

977: */
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;

Line 990: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

986:
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;

Line 1000: AND not oe_globals.equal(g_line_tbl(I).ship_from_org_id,

996: oe_debug_pub.add('Firm_demand_flag :' || g_line_tbl(I).firm_demand_flag,1);
997:
998: -- Commenting this code as ASCP is doing this already.
999: /* IF NVL(g_old_line_tbl(I).firm_demand_flag,'N') = 'Y'
1000: AND not oe_globals.equal(g_line_tbl(I).ship_from_org_id,
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;

Line 1004: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1000: AND not oe_globals.equal(g_line_tbl(I).ship_from_org_id,
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; */

Line 1010: IF g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN

1006: OE_MSG_PUB.ADD;
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: END IF; */
1009:
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');

Line 1013: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1009:
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;

Line 1021: g_line_tbl(I).item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN

1017: END IF;
1018:
1019: IF g_line_tbl(I).ato_line_id IS NOT NULL THEN
1020: /* IF NOT (g_line_tbl(I).ato_line_id = g_line_tbl(I).line_id OR
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');

Line 1024: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1020: /* IF NOT (g_line_tbl(I).ato_line_id = g_line_tbl(I).line_id OR
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;

Line 1032: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1028: END IF;
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:

Line 1043: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1039:
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;

Line 1052: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1048:
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;

Line 1058: IF g_line_tbl(I).source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN

1054: OE_MSG_PUB.ADD;
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: END IF;
1057:
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');

Line 1061: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1057:
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;

Line 1076: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1072: l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE OR
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:

Line 1103: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1099: g_line_tbl(I).ship_from_org_id <>
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:

Line 1137: g_line_tbl(I).operation := OE_GLOBALS.G_OPR_NONE;

1133: END IF;
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;

Line 1252: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;

1248: FOR J IN 1..g_line_tbl.count LOOP
1249:
1250: IF g_line_tbl(J).ship_set_id = p_ship_set_id THEN
1251:
1252: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1253: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
1254:
1255: l_index := find_index(g_line_tbl(J).line_id);
1256: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;

Line 1267: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;

1263: FOR J IN 1..g_line_tbl.count LOOP
1264:
1265: IF g_line_tbl(J).arrival_set_id = p_arrival_set_id THEN
1266:
1267: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1268: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
1269: l_index := find_index(g_line_tbl(J).line_id);
1270: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1271: END IF;

Line 1281: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;

1277: FOR J IN 1..g_line_tbl.count LOOP
1278:
1279: IF g_line_tbl(J).top_model_line_id = p_top_model_line_id THEN
1280:
1281: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1282: l_index := find_index(g_line_tbl(J).line_id);
1283: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1284:
1285: END IF;

Line 1404: IF (NOT OE_GLOBALS.Equal(g_line_tbl(p_index).ship_from_org_id,

1400: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1401: IS
1402: BEGIN
1403:
1404: IF (NOT OE_GLOBALS.Equal(g_line_tbl(p_index).ship_from_org_id,
1405: g_old_line_tbl(p_index).ship_from_org_id))
1406: OR ( NOT OE_GLOBALS.Equal(g_line_tbl(p_index).inventory_item_id, g_old_line_tbl(p_index).inventory_item_id)
1407: AND nvl(g_line_tbl(p_index).booked_flag, 'N') = 'N'
1408: ) -- OR clause added for ER 6110708

Line 1406: OR ( NOT OE_GLOBALS.Equal(g_line_tbl(p_index).inventory_item_id, g_old_line_tbl(p_index).inventory_item_id)

1402: BEGIN
1403:
1404: IF (NOT OE_GLOBALS.Equal(g_line_tbl(p_index).ship_from_org_id,
1405: g_old_line_tbl(p_index).ship_from_org_id))
1406: OR ( NOT OE_GLOBALS.Equal(g_line_tbl(p_index).inventory_item_id, g_old_line_tbl(p_index).inventory_item_id)
1407: AND nvl(g_line_tbl(p_index).booked_flag, 'N') = 'N'
1408: ) -- OR clause added for ER 6110708
1409: THEN
1410:

Line 1421: ELSIF NOT OE_GLOBALS.Equal(g_line_tbl(p_index).schedule_ship_date,

1417: (p_line_rec => g_line_tbl(p_index)
1418: ,p_quantity_to_reserve => g_line_tbl(p_index).reserved_quantity
1419: ,x_return_Status => x_return_status);
1420:
1421: ELSIF NOT OE_GLOBALS.Equal(g_line_tbl(p_index).schedule_ship_date,
1422: g_old_line_tbl(p_index).schedule_ship_date)
1423: THEN
1424:
1425: OE_CONFIG_SCHEDULE_PVT.Update_Reservation