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 8: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- 9187335

4: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_SCHEDULE_GRP';
5: G_SCH_TBL sch_tbl_type;
6: G_LINE_TBL OE_Order_PUB.Line_Tbl_Type;
7: G_OLD_LINE_TBL OE_Order_PUB.Line_Tbl_Type;
8: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- 9187335
9:
10: /** Fwd declaration ********/
11: PROCEDURE Process_order(x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2);
12: PROCEDURE Validate_sch_data(x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2);

Line 275: l_control_rec OE_GLOBALS.control_rec_type;

271: PROCEDURE Process_order(x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2)
272: IS
273: l_line_rec OE_Order_PUB.Line_Rec_type;
274: l_local_line_tbl OE_ORDER_PUB.line_tbl_type;
275: l_control_rec OE_GLOBALS.control_rec_type;
276: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
277: l_count Number;
278: l_ship_from_is_changed BOOLEAN := FALSE;
279: l_ship_method_is_changed BOOLEAN := FALSE;

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

441: END IF;
442:
443: IF l_line_rec.ato_line_id is not null
444: AND l_line_rec.ato_line_id <> l_line_rec.line_id
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');

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

501: oe_debug_pub.add(' OPM Enabled Org : No', 5);
502: END IF;
503: oe_debug_pub.add(' Reserved Qty : ' || nvl(l_line_rec.reserved_quantity, 0), 5);
504:
505: IF ( l_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD OR -- Not a Standard Item
506: l_line_rec.line_set_id IS NOT NULL OR -- Line is Split
507: l_line_rec.split_from_line_id IS NOT NULL OR -- Split Line
508: nvl(l_line_rec.source_document_type_id, -99) = 10 OR -- Internal Sales Order Line
509: l_line_rec.source_type_code = 'EXTERNAL' OR -- Externally Sourced Line

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

548: g_sch_tbl(I).x_override_atp_date_code := 'Y';
549: END IF;
550:
551: IF (l_line_rec.ato_line_id = l_line_rec.line_id
552: AND l_line_rec.item_type_code IN (OE_GLOBALS.G_ITEM_MODEL,
553: OE_GLOBALS.G_ITEM_CLASS))
554: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
555:
556: THEN

Line 553: OE_GLOBALS.G_ITEM_CLASS))

549: END IF;
550:
551: IF (l_line_rec.ato_line_id = l_line_rec.line_id
552: AND l_line_rec.item_type_code IN (OE_GLOBALS.G_ITEM_MODEL,
553: OE_GLOBALS.G_ITEM_CLASS))
554: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
555:
556: THEN
557: oe_debug_pub.add('ATO Model',2);

Line 554: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG

550:
551: IF (l_line_rec.ato_line_id = l_line_rec.line_id
552: AND l_line_rec.item_type_code IN (OE_GLOBALS.G_ITEM_MODEL,
553: OE_GLOBALS.G_ITEM_CLASS))
554: OR l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG
555:
556: THEN
557: oe_debug_pub.add('ATO Model',2);
558:

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

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

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

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

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

652: END IF;
653:
654: oe_debug_pub.add('Before assigning' || l_local_line_tbl(J).line_id,2);
655: g_line_tbl(l_count) := l_local_line_tbl(J);
656: g_line_tbl(l_count).operation := OE_GLOBALS.G_OPR_UPDATE;
657: g_line_tbl(l_count).return_status := Null;
658: l_count := l_count + 1;
659: <>
660: g_sch_tbl(I).x_line_number :=

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

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

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

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

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

767: l_ord_qty_is_changed := TRUE;
768: l_line_rec.Ordered_Quantity := g_sch_tbl(I).Ordered_Quantity;
769: END IF;
770:
771: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
772: g_line_tbl(l_count) := l_line_rec;
773: g_line_tbl(l_count).return_status := Null;
774: l_count := l_count + 1;
775: <>

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

794:
795: IF g_line_tbl(J).return_status <> FND_API.G_RET_STS_SUCCESS THEN
796:
797: oe_debug_pub.add('None ' || g_line_tbl(J).return_status,2);
798: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
799:
800: ELSE
801:
802:

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

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

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

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

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

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

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

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

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

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

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

1171: OE_MSG_PUB.ADD;
1172: x_return_status := FND_API.G_RET_STS_ERROR;
1173: END IF; */
1174:
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');

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

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

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

1182: END IF;
1183:
1184: IF g_line_tbl(I).ato_line_id IS NOT NULL THEN
1185: /* IF NOT (g_line_tbl(I).ato_line_id = g_line_tbl(I).line_id OR
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');

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

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

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

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

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

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

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

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

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

1219: OE_MSG_PUB.ADD;
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221: END IF;
1222:
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');

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

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

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

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

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

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

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

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

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

1413: FOR J IN 1..g_line_tbl.count LOOP
1414:
1415: IF g_line_tbl(J).ship_set_id = p_ship_set_id THEN
1416:
1417: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1418: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
1419:
1420: l_index := find_index(g_line_tbl(J).line_id);
1421: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;

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

1428: FOR J IN 1..g_line_tbl.count LOOP
1429:
1430: IF g_line_tbl(J).arrival_set_id = p_arrival_set_id THEN
1431:
1432: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1433: g_line_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
1434: l_index := find_index(g_line_tbl(J).line_id);
1435: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1436: END IF;

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

1442: FOR J IN 1..g_line_tbl.count LOOP
1443:
1444: IF g_line_tbl(J).top_model_line_id = p_top_model_line_id THEN
1445:
1446: g_line_tbl(J).operation := OE_GLOBALS.G_OPR_NONE;
1447: l_index := find_index(g_line_tbl(J).line_id);
1448: g_sch_tbl(l_index).x_return_status := FND_API.G_RET_STS_ERROR;
1449:
1450: END IF;

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

1565: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1566: IS
1567: BEGIN
1568:
1569: IF (NOT OE_GLOBALS.Equal(g_line_tbl(p_index).ship_from_org_id,
1570: g_old_line_tbl(p_index).ship_from_org_id))
1571: OR ( NOT OE_GLOBALS.Equal(g_line_tbl(p_index).inventory_item_id, g_old_line_tbl(p_index).inventory_item_id)
1572: AND nvl(g_line_tbl(p_index).booked_flag, 'N') = 'N'
1573: ) -- OR clause added for ER 6110708

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

1567: BEGIN
1568:
1569: IF (NOT OE_GLOBALS.Equal(g_line_tbl(p_index).ship_from_org_id,
1570: g_old_line_tbl(p_index).ship_from_org_id))
1571: OR ( NOT OE_GLOBALS.Equal(g_line_tbl(p_index).inventory_item_id, g_old_line_tbl(p_index).inventory_item_id)
1572: AND nvl(g_line_tbl(p_index).booked_flag, 'N') = 'N'
1573: ) -- OR clause added for ER 6110708
1574: THEN
1575:

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

1583: (p_line_rec => g_line_tbl(p_index)
1584: ,p_quantity_to_reserve => g_line_tbl(p_index).reserved_quantity
1585: ,x_return_Status => x_return_status);
1586:
1587: ELSIF NOT OE_GLOBALS.Equal(g_line_tbl(p_index).schedule_ship_date,
1588: g_old_line_tbl(p_index).schedule_ship_date)
1589: THEN
1590:
1591: OE_CONFIG_SCHEDULE_PVT.Update_Reservation