DBA Data[Home] [Help]

APPS.OE_GROUP_SCH_UTIL dependencies on STANDARD

Line 918: OE_GLOBALS.G_ITEM_STANDARD,OE_GLOBALS.G_ITEM_INCLUDED)) --9775352

914: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
915: IF l_line_rec.ato_line_id IS NOT NULL AND
916: NOT ( l_line_rec.ato_line_id = l_line_rec.line_id AND
917: l_line_rec.item_type_code IN ( OE_GLOBALS.G_ITEM_OPTION,
918: OE_GLOBALS.G_ITEM_STANDARD,OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
919: THEN
920: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
921: ELSE
922: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');

Line 1658: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,

1654: END IF;
1655:
1656: ELSIF (l_ato_line_id is not null AND
1657: NOT (l_line_id = l_ato_line_id AND
1658: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,
1659: OE_GLOBALS.G_ITEM_OPTION,
1660: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
1661: THEN
1662:

Line 1944: l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD))

1940: (l_smc_flag = 'Y' OR
1941: l_ato_line_id is not null OR
1942: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1943: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1944: l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD))
1945: OR l_line_category_code = 'RETURN'
1946: OR l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE
1947: OR nvl(l_open_flag,'Y') = 'N'
1948: OR NVL(l_subscription_enable_flag,'N') = 'Y' --sol_ord_er #16014165

Line 2003: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,

1999: -- Decided to query the line. See what to pass to query sets.
2000: IF l_smc_flag = 'Y'
2001: OR (l_ato_line_id is not null AND
2002: NOT (l_line_id = l_ato_line_id AND
2003: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,
2004: OE_GLOBALS.G_ITEM_OPTION,
2005: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
2006: THEN
2007:

Line 2790: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,

2786:
2787:
2788: ELSIF (l_ato_line_id is not null AND
2789: NOT (l_line_id = l_ato_line_id AND
2790: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,
2791: OE_GLOBALS.G_ITEM_OPTION,
2792: OE_GLOBALS.G_ITEM_INCLUDED))) -- 9775352
2793: AND l_schedule_status_code is null
2794: THEN

Line 3108: OE_GLOBALS.G_ITEM_STANDARD,OE_GLOBALS.G_ITEM_INCLUDED)) -- 9775352

3104: THEN
3105: IF l_line_tbl(I).ato_line_id IS NOT NULL AND
3106: NOT ( l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id AND
3107: l_line_tbl(I).item_type_code IN ( OE_GLOBALS.G_ITEM_OPTION,
3108: OE_GLOBALS.G_ITEM_STANDARD,OE_GLOBALS.G_ITEM_INCLUDED)) -- 9775352
3109: THEN -- check for ato
3110: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
3111: IF l_debug_level > 0 THEN
3112: oe_debug_pub.add( 'NON SHIPPABLE ATO LINE' , 2 ) ;

Line 3338: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,

3334: OR l_ship_set_id is not null
3335: OR l_smc_flag = 'Y'
3336: OR (l_ato_line_id is not null AND
3337: NOT (l_line_id = l_ato_line_id AND
3338: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,
3339: OE_GLOBALS.G_ITEM_OPTION,
3340: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
3341: THEN
3342:

Line 4409: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

4405: x_return_status => x_return_status);
4406:
4407: ELSIF (l_ato_line_id is not null AND
4408: NOT (l_ato_line_id = p_sch_set_tbl(I).entity_id AND
4409: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
4410: OE_GLOBALS.G_ITEM_OPTION,
4411: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
4412: THEN
4413:

Line 4791: -- If the line is being added to set is a standard line

4787: OE_MSG_PUB.Add;
4788: RAISE FND_API.G_EXC_ERROR;
4789:
4790: ELSE
4791: -- If the line is being added to set is a standard line
4792: -- save the line without scheduling attributes.
4793: IF l_debug_level > 0 THEN
4794: oe_debug_pub.add('Standard line is failed');
4795: END IF;

Line 4794: oe_debug_pub.add('Standard line is failed');

4790: ELSE
4791: -- If the line is being added to set is a standard line
4792: -- save the line without scheduling attributes.
4793: IF l_debug_level > 0 THEN
4794: oe_debug_pub.add('Standard line is failed');
4795: END IF;
4796: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4797: OE_MSG_PUB.Add;
4798:

Line 5182: (l_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_STANDARD AND

5178:
5179: FOR I IN 1..l_line_tbl.count LOOP
5180:
5181: IF l_line_tbl(I).schedule_status_code IS NULL OR
5182: (l_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_STANDARD AND
5183: nvl(l_line_tbl(I).model_remnant_flag,'N') = 'N') THEN
5184:
5185: IF l_debug_level > 0 THEN
5186: oe_debug_pub.add( 'UNABLE TO BYPASS' , 2 ) ;

Line 5326: l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

5322: AND nvl(l_line_tbl(I).override_atp_date_code,'N') = 'N' THEN
5323:
5324: IF (l_line_tbl(I).ato_line_id is not null AND
5325: NOT (l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id AND
5326: l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5327: OE_GLOBALS.G_ITEM_OPTION,
5328: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
5329: THEN
5330:

Line 5441: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION,OE_GLOBALS.G_ITEM_INCLUDED)) --9775352

5437: THEN
5438: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5439: ELSIF l_line_tbl(I).ato_line_id is not null
5440: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5441: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION,OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5442: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5443: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5444: THEN
5445: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;

Line 5566: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION, OE_GLOBALS.G_ITEM_INCLUDED)) --9775352

5562: THEN
5563: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).date_attribute1;
5564: ELSIF l_line_tbl(I).ato_line_id is not null
5565: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5566: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD, OE_GLOBALS.G_ITEM_OPTION, OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5567: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5568: AND oe_schedule_util.OE_sch_Attrb_Tbl (mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1 is not null
5569: THEN
5570: l_line_tbl(I).request_date := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).date_attribute1;

Line 5588: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

5584: THEN
5585: l_line_tbl(I).Ship_from_org_id := oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).top_model_line_id, G_BINARY_LIMIT)).attribute1;
5586: ELSIF l_line_tbl(I).ato_line_id is not null
5587: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5588: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5589: OE_GLOBALS.G_ITEM_OPTION,
5590: OE_GLOBALS.G_ITEM_INCLUDED)) --9775352
5591: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT) )
5592: AND oe_schedule_util.OE_sch_Attrb_Tbl(mod(l_line_tbl(I).ato_line_id, G_BINARY_LIMIT)).attribute1 is not null

Line 6158: l_line_tbl(J).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

6154:
6155: IF nvl(l_line_tbl(J).override_atp_date_code,'N') = 'N'
6156: AND (l_line_tbl(J).ato_line_id is not null AND
6157: NOT (l_line_tbl(J).ato_line_id = l_line_tbl(J).line_id AND
6158: l_line_tbl(J).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
6159: OE_GLOBALS.G_ITEM_OPTION,
6160: OE_GLOBALS.G_ITEM_INCLUDED))) --9775352
6161: THEN
6162: