DBA Data[Home] [Help]

APPS.OE_GROUP_SCH_UTIL dependencies on STANDARD

Line 911: OE_GLOBALS.G_ITEM_STANDARD))

907: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
908: IF l_line_rec.ato_line_id IS NOT NULL AND
909: NOT ( l_line_rec.ato_line_id = l_line_rec.line_id AND
910: l_line_rec.item_type_code IN ( OE_GLOBALS.G_ITEM_OPTION,
911: OE_GLOBALS.G_ITEM_STANDARD))
912: THEN
913: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
914: ELSE
915: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_NOT_RESERVABLE');

Line 1618: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,

1614: END IF;
1615:
1616: ELSIF (l_ato_line_id is not null AND
1617: NOT (l_line_id = l_ato_line_id AND
1618: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,
1619: OE_GLOBALS.G_ITEM_OPTION)))
1620: THEN
1621:
1622:

Line 1898: l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD))

1894: (l_smc_flag = 'Y' OR
1895: l_ato_line_id is not null OR
1896: l_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1897: l_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1898: l_item_type_code = OE_GLOBALS.G_ITEM_STANDARD))
1899: OR l_line_category_code = 'RETURN'
1900: OR l_item_type_code = OE_GLOBALS.G_ITEM_SERVICE
1901: OR nvl(l_open_flag,'Y') = 'N'
1902: THEN

Line 1956: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,

1952: -- Decided to query the line. See what to pass to query sets.
1953: IF l_smc_flag = 'Y'
1954: OR (l_ato_line_id is not null AND
1955: NOT (l_line_id = l_ato_line_id AND
1956: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,
1957: OE_GLOBALS.G_ITEM_OPTION)))
1958: THEN
1959:
1960: -- query using top_model_line_id / ato line id

Line 2712: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,

2708:
2709:
2710: ELSIF (l_ato_line_id is not null AND
2711: NOT (l_line_id = l_ato_line_id AND
2712: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,
2713: OE_GLOBALS.G_ITEM_OPTION)))
2714: AND l_schedule_status_code is null
2715: THEN
2716:

Line 3029: OE_GLOBALS.G_ITEM_STANDARD))

3025: THEN
3026: IF l_line_tbl(I).ato_line_id IS NOT NULL AND
3027: NOT ( l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id AND
3028: l_line_tbl(I).item_type_code IN ( OE_GLOBALS.G_ITEM_OPTION,
3029: OE_GLOBALS.G_ITEM_STANDARD))
3030: THEN -- check for ato
3031: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
3032: IF l_debug_level > 0 THEN
3033: oe_debug_pub.add( 'NON SHIPPABLE ATO LINE' , 2 ) ;

Line 3255: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,

3251: OR l_ship_set_id is not null
3252: OR l_smc_flag = 'Y'
3253: OR (l_ato_line_id is not null AND
3254: NOT (l_line_id = l_ato_line_id AND
3255: l_item_type_code IN(OE_GLOBALS.G_ITEM_STANDARD,
3256: OE_GLOBALS.G_ITEM_OPTION)))
3257: THEN
3258:
3259: IF l_arrival_set_id is not null

Line 4325: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,

4321: x_return_status => x_return_status);
4322:
4323: ELSIF (l_ato_line_id is not null AND
4324: NOT (l_ato_line_id = p_sch_set_tbl(I).entity_id AND
4325: l_item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
4326: OE_GLOBALS.G_ITEM_OPTION)))
4327: THEN
4328:
4329: OE_Config_Util.Query_ATO_Options

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

4702: OE_MSG_PUB.Add;
4703: RAISE FND_API.G_EXC_ERROR;
4704:
4705: ELSE
4706: -- If the line is being added to set is a standard line
4707: -- save the line without scheduling attributes.
4708: IF l_debug_level > 0 THEN
4709: oe_debug_pub.add('Standard line is failed');
4710: END IF;

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

4705: ELSE
4706: -- If the line is being added to set is a standard line
4707: -- save the line without scheduling attributes.
4708: IF l_debug_level > 0 THEN
4709: oe_debug_pub.add('Standard line is failed');
4710: END IF;
4711: fnd_message.set_name('ONT','OE_SCH_SET_INS_FAILED');
4712: OE_MSG_PUB.Add;
4713:

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

5090:
5091: FOR I IN 1..l_line_tbl.count LOOP
5092:
5093: IF l_line_tbl(I).schedule_status_code IS NULL OR
5094: (l_line_tbl(I).item_type_code <> OE_GLOBALS.G_ITEM_STANDARD AND
5095: nvl(l_line_tbl(I).model_remnant_flag,'N') = 'N') THEN
5096:
5097: IF l_debug_level > 0 THEN
5098: oe_debug_pub.add( 'UNABLE TO BYPASS' , 2 ) ;

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

5234: AND nvl(l_line_tbl(I).override_atp_date_code,'N') = 'N' THEN
5235:
5236: IF (l_line_tbl(I).ato_line_id is not null AND
5237: NOT (l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id AND
5238: l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5239: OE_GLOBALS.G_ITEM_OPTION)))
5240: THEN
5241:
5242: BEGIN

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

5349: oe_schedule_util.OE_sch_Attrb_Tbl
5350: (l_line_tbl(I).top_model_line_id).date_attribute1;
5351: ELSIF l_line_tbl(I).ato_line_id is not null
5352: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5353: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5354: OE_GLOBALS.G_ITEM_OPTION))
5355: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5356: (l_line_tbl(I).ato_line_id )
5357: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)

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

5486: oe_schedule_util.OE_sch_Attrb_Tbl
5487: (l_line_tbl(I).top_model_line_id).date_attribute1;
5488: ELSIF l_line_tbl(I).ato_line_id is not null
5489: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5490: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5491: OE_GLOBALS.G_ITEM_OPTION))
5492: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5493: (l_line_tbl(I).ato_line_id )
5494: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)

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

5521: oe_schedule_util.OE_sch_Attrb_Tbl
5522: (l_line_tbl(I).top_model_line_id).attribute1;
5523: ELSIF l_line_tbl(I).ato_line_id is not null
5524: AND NOT(l_line_tbl(I).ato_line_id = l_line_tbl(I).line_id
5525: AND l_line_tbl(I).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
5526: OE_GLOBALS.G_ITEM_OPTION))
5527: AND oe_schedule_util.OE_sch_Attrb_Tbl.EXISTS
5528: (l_line_tbl(I).ato_line_id )
5529: AND oe_schedule_util.OE_sch_Attrb_Tbl (l_line_tbl(I).ato_line_id)

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

6088:
6089: IF nvl(l_line_tbl(J).override_atp_date_code,'N') = 'N'
6090: AND (l_line_tbl(J).ato_line_id is not null AND
6091: NOT (l_line_tbl(J).ato_line_id = l_line_tbl(J).line_id AND
6092: l_line_tbl(J).item_type_code IN (OE_GLOBALS.G_ITEM_STANDARD,
6093: OE_GLOBALS.G_ITEM_OPTION)))
6094: THEN
6095:
6096: BEGIN