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_DEFAULT_LINE dependencies on OE_GLOBALS

Line 85: IF OE_GLOBALS.G_UI_FLAG then

81: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
82: --
83: BEGIN
84: --For Bug#7592137
85: IF OE_GLOBALS.G_UI_FLAG then
86: RETURN 0;
87: ELSE
88: OE_ORDER_CACHE.Load_Order_Header(g_line_rec.header_id);
89: IF l_debug_level > 0 THEN

Line 128: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code

124: (p_line_rec.ship_from_org_id IS NOT NULL AND
125: p_line_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN
126:
127: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null
128: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code
129: ,p_old_line_rec.shipping_method_code) OR
130: NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id
131: ,p_old_line_rec.ship_from_org_id) OR
132: NOT OE_GLOBALS.EQUAL(p_line_rec.freight_carrier_code

Line 130: NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id

126:
127: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null
128: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code
129: ,p_old_line_rec.shipping_method_code) OR
130: NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id
131: ,p_old_line_rec.ship_from_org_id) OR
132: NOT OE_GLOBALS.EQUAL(p_line_rec.freight_carrier_code
133: ,p_old_line_rec.freight_carrier_code)) THEN
134:

Line 132: NOT OE_GLOBALS.EQUAL(p_line_rec.freight_carrier_code

128: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code
129: ,p_old_line_rec.shipping_method_code) OR
130: NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id
131: ,p_old_line_rec.ship_from_org_id) OR
132: NOT OE_GLOBALS.EQUAL(p_line_rec.freight_carrier_code
133: ,p_old_line_rec.freight_carrier_code)) THEN
134:
135: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
136:

Line 215: IF NOT oe_globals.G_HTML_FLAG THEN

211: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
212: --
213: BEGIN
214:
215: IF NOT oe_globals.G_HTML_FLAG THEN
216:
217: -- use order_header cache instead of sql : bug 4200055
218: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
219: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL

Line 296: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL) OR

292:
293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( ' COMP_CODE , ITEM_TYPE_CODE ' || G_LINE_REC.ITEM_TYPE_CODE ) ;
295: END IF;
296: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL) OR
297: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
298: g_line_rec.line_id = g_line_rec.top_model_line_id)
299: THEN
300: g_line_rec.component_code := to_char(g_line_rec.inventory_item_id);

Line 297: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND

293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( ' COMP_CODE , ITEM_TYPE_CODE ' || G_LINE_REC.ITEM_TYPE_CODE ) ;
295: END IF;
296: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL) OR
297: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
298: g_line_rec.line_id = g_line_rec.top_model_line_id)
299: THEN
300: g_line_rec.component_code := to_char(g_line_rec.inventory_item_id);
301: RETURN g_line_rec.component_code;

Line 335: IF g_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

331: THEN
332: RETURN NULL;
333: END IF;
334:
335: IF g_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
336: RETURN NULL;
337: ELSE
338: -- class/option, avoid setting value to null by the last return.
339: IF g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN

Line 427: l_control_rec OE_GLOBALS.Control_Rec_Type;

423: l_x_line_Tbl OE_Order_PUB.Line_Tbl_Type;
424:
425: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
426: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
427: l_control_rec OE_GLOBALS.Control_Rec_Type;
428: l_agreement_name varchar2(240);
429: l_agreement_id number;
430:
431: --

Line 553: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.blanket_number

549: -- Copy source attribute values from IN parameters
550: -- to the new record
551: IF p_blanket_number IS NOT NULL
552: THEN
553: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.blanket_number
554: ,p_blanket_number)
555: THEN
556: p_x_line_rec.blanket_number := p_blanket_number;
557: l_line_rec := p_x_line_rec;

Line 570: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.blanket_line_number

566: END IF;
567:
568: IF p_blanket_line_number IS NOT NULL
569: THEN
570: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.blanket_line_number
571: ,p_blanket_line_number)
572: THEN
573: p_x_line_rec.blanket_line_number := p_blanket_line_number;
574: l_line_rec := p_x_line_rec;

Line 587: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.blanket_version_number

583: END IF;
584:
585: IF p_blanket_version_number IS NOT NULL
586: THEN
587: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.blanket_version_number
588: ,p_blanket_version_number)
589: THEN
590: p_x_line_rec.blanket_version_number := p_blanket_version_number;
591: -- No dependent attributes exist for blanket version number

Line 992: AND (NOT OE_GLOBALS.EQUAL(p_x_line_rec.cust_po_number

988: AND p_x_line_rec.cust_po_number <> FND_API.G_MISS_CHAR
989: -- Bug 2818494
990: -- Default blanket from customer PO only if either
991: -- customer PO or item is updated on order line.
992: AND (NOT OE_GLOBALS.EQUAL(p_x_line_rec.cust_po_number
993: ,p_old_line_rec.cust_po_number)
994: OR NOT OE_GLOBALS.EQUAL(p_x_line_rec.inventory_item_id
995: ,p_old_line_rec.inventory_item_id)
996: )

Line 994: OR NOT OE_GLOBALS.EQUAL(p_x_line_rec.inventory_item_id

990: -- Default blanket from customer PO only if either
991: -- customer PO or item is updated on order line.
992: AND (NOT OE_GLOBALS.EQUAL(p_x_line_rec.cust_po_number
993: ,p_old_line_rec.cust_po_number)
994: OR NOT OE_GLOBALS.EQUAL(p_x_line_rec.inventory_item_id
995: ,p_old_line_rec.inventory_item_id)
996: )
997: )
998: THEN

Line 1042: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD

1038: IF ( p_x_line_rec.sold_to_org_id IS NOT NULL
1039: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1040: AND p_x_line_rec.inventory_item_id IS NOT NULL
1041: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1042: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1043: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1044: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id))) THEN
1045:
1046: Default_Blanket_Values

Line 1043: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT

1039: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1040: AND p_x_line_rec.inventory_item_id IS NOT NULL
1041: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1042: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1043: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1044: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id))) THEN
1045:
1046: Default_Blanket_Values
1047: ( p_blanket_number => p_x_line_rec.blanket_number,

Line 1062: AND NOT OE_GLOBALS.EQUAL(l_blanket_number

1058: x_blanket_request_date => x_blanket_request_date
1059: );
1060:
1061: IF (l_blanket_number IS NOT NULL
1062: AND NOT OE_GLOBALS.EQUAL(l_blanket_number
1063: ,p_x_line_rec.blanket_number))
1064: OR (l_blanket_line_number IS NOT NULL
1065: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number
1066: ,p_x_line_rec.blanket_line_number))

Line 1065: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number

1061: IF (l_blanket_number IS NOT NULL
1062: AND NOT OE_GLOBALS.EQUAL(l_blanket_number
1063: ,p_x_line_rec.blanket_number))
1064: OR (l_blanket_line_number IS NOT NULL
1065: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number
1066: ,p_x_line_rec.blanket_line_number))
1067: THEN
1068: Clear_And_Re_Default
1069: (p_blanket_number => l_blanket_number

Line 1086: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE

1082:
1083: END IF;
1084:
1085:
1086: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
1087: OR p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM)
1088: THEN
1089:
1090: if l_debug_level > 0 then

Line 1128: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD

1124: ELSIF (p_x_line_rec.sold_to_org_id IS NOT NULL
1125: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1126: AND p_x_line_rec.inventory_item_id IS NOT NULL
1127: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1128: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1129: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1130: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id)
1131: )
1132: -- Bug 2769562 => If blanket line number is being cleared by user

Line 1129: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT

1125: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1126: AND p_x_line_rec.inventory_item_id IS NOT NULL
1127: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1128: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1129: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1130: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id)
1131: )
1132: -- Bug 2769562 => If blanket line number is being cleared by user
1133: -- (value for blanket line number existed in old rec), blanket

Line 1180: AND NOT OE_GLOBALS.EQUAL(l_blanket_number

1176: x_blanket_request_date => x_blanket_request_date
1177: );
1178:
1179: IF (l_blanket_number IS NOT NULL
1180: AND NOT OE_GLOBALS.EQUAL(l_blanket_number
1181: ,p_x_line_rec.blanket_number))
1182: OR (l_blanket_line_number IS NOT NULL
1183: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number
1184: ,p_x_line_rec.blanket_line_number))

Line 1183: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number

1179: IF (l_blanket_number IS NOT NULL
1180: AND NOT OE_GLOBALS.EQUAL(l_blanket_number
1181: ,p_x_line_rec.blanket_number))
1182: OR (l_blanket_line_number IS NOT NULL
1183: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number
1184: ,p_x_line_rec.blanket_line_number))
1185: THEN
1186: Clear_And_Re_Default
1187: (p_blanket_number => l_blanket_number

Line 1366: g_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE AND

1362: children into same fulfillment set. We exclude service item and the
1363: top model itself*/
1364: -- 4118431
1365: IF (g_line_rec.line_id <> g_line_rec.top_model_line_id AND
1366: g_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE AND
1367: g_line_rec.top_modeL_line_id IS NOT NULL AND
1368: g_line_rec.line_id > 0 ) THEN
1369:
1370: Insert_into_set

Line 1389: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR

1385: * since user dose not enter them.They are created in the
1386: * process_included_items procedure and all the fields to be populated
1387: * from the parent line, are populated there. */
1388:
1389: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1390: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1391: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1392: g_line_rec.line_id = g_line_rec.top_modeL_line_id)
1393: THEN

Line 1390: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR

1386: * process_included_items procedure and all the fields to be populated
1387: * from the parent line, are populated there. */
1388:
1389: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1390: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1391: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1392: g_line_rec.line_id = g_line_rec.top_modeL_line_id)
1393: THEN
1394: IF l_debug_level > 0 THEN

Line 1391: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND

1387: * from the parent line, are populated there. */
1388:
1389: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1390: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1391: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1392: g_line_rec.line_id = g_line_rec.top_modeL_line_id)
1393: THEN
1394: IF l_debug_level > 0 THEN
1395: oe_debug_pub.add( 'RETURNING FOR SERVICE , INCLUDED , TOP LEVEL KITS' , 1 ) ;

Line 1413: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

1409: /* After getting ato_line_id, for top level parents and ato items,
1410: * we don't default any other columns for lines with item_type MODEL
1411: * and STANDARD */
1412:
1413: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1414: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1415: THEN
1416: --{ bug3601544 starts
1417: IF l_debug_level > 0 THEN

Line 1414: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD

1410: * we don't default any other columns for lines with item_type MODEL
1411: * and STANDARD */
1412:
1413: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1414: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1415: THEN
1416: --{ bug3601544 starts
1417: IF l_debug_level > 0 THEN
1418: OE_DEBUG_PUB.Add('IB Owner: '||g_line_rec.ib_owner,3);

Line 1454: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

1450: /* If we are here, it means item_type_code is CLASS, OPTION, KIT under
1451: * a model,or CONFIG. Load top parent, so that we know if it is ato,
1452: * smc pto or nonsmc pto */
1453:
1454: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1455: l_parent_line_id := g_line_rec.ato_line_id;
1456: ELSE
1457: l_parent_line_id := g_line_rec.top_model_line_id;
1458: END IF;

Line 1537: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR

1533: END IF;
1534:
1535: /* These updates are valid only for Options/clasees/included items */
1536:
1537: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1538: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1539: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1540: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1541: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)

Line 1538: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

1534:
1535: /* These updates are valid only for Options/clasees/included items */
1536:
1537: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1538: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1539: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1540: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1541: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)
1542: THEN

Line 1539: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

1535: /* These updates are valid only for Options/clasees/included items */
1536:
1537: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1538: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1539: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1540: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1541: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)
1542: THEN
1543:

Line 1540: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND

1536:
1537: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1538: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1539: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1540: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1541: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)
1542: THEN
1543:
1544: IF l_debug_level > 0 THEN

Line 1551: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

1547:
1548: RETURN;
1549: END IF;
1550:
1551: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1552: l_parent_line_id := p_x_line_rec.ato_line_id;
1553: ELSE
1554: l_parent_line_id := p_x_line_rec.top_model_line_id;
1555: END IF;

Line 1645: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

1641: RETURN NULL;
1642: END IF;
1643:
1644: IF g_line_rec.line_category_code =
1645: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
1646: RETURN NULL;
1647: END IF;
1648:
1649: OE_ORDER_CACHE.Load_Item

Line 1665: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND

1661:
1662: -- top level ATO model and ato item.
1663: -- build in wip flag, see if req?
1664:
1665: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
1666: l_replenish_to_order_flag = 'Y') OR
1667: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
1668: l_replenish_to_order_flag = 'Y' AND
1669: l_build_in_wip_flag = 'Y')OR

Line 1667: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND

1663: -- build in wip flag, see if req?
1664:
1665: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
1666: l_replenish_to_order_flag = 'Y') OR
1667: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
1668: l_replenish_to_order_flag = 'Y' AND
1669: l_build_in_wip_flag = 'Y')OR
1670: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND
1671: l_replenish_to_order_flag = 'Y' AND --9775352

Line 1670: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND

1666: l_replenish_to_order_flag = 'Y') OR
1667: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
1668: l_replenish_to_order_flag = 'Y' AND
1669: l_build_in_wip_flag = 'Y')OR
1670: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND
1671: l_replenish_to_order_flag = 'Y' AND --9775352
1672: l_build_in_wip_flag = 'Y' AND
1673: Nvl(fnd_profile.Value('ONT_HON_ATO_FOR_INC'),'N')='Y')
1674: THEN

Line 1688: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

1684: * ato model (ont: item_type_code is CLASS, bom_item_type = 1)
1685: * under top ato model will have ato_line_id = line_id
1686: * of top ato parent. kit can not be under an ATO */
1687:
1688: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1689: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1690: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1691:
1692: OE_Order_Cache.Load_Top_Model_Line

Line 1689: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1685: * under top ato model will have ato_line_id = line_id
1686: * of top ato parent. kit can not be under an ATO */
1687:
1688: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1689: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1690: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1691:
1692: OE_Order_Cache.Load_Top_Model_Line
1693: (g_line_rec.top_model_line_id );

Line 1690: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

1686: * of top ato parent. kit can not be under an ATO */
1687:
1688: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1689: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1690: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1691:
1692: OE_Order_Cache.Load_Top_Model_Line
1693: (g_line_rec.top_model_line_id );
1694: l_ato_line_id := OE_Order_Cache.g_top_model_line_rec.ato_line_id;

Line 1702: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND

1698: IF l_debug_level > 0 THEN
1699: oe_debug_pub.add( 'TOP MODEL IS PTO' , 3 ) ;
1700: END IF;
1701:
1702: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
1703: l_replenish_to_order_flag = 'Y' AND
1704: l_bom_item_type = 1) THEN
1705:
1706: IF l_debug_level > 0 THEN

Line 1753: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION

1749: ELSE
1750: IF l_debug_level > 0 THEN
1751: oe_debug_pub.add('CONFIG_ITEM_ID NOT RETURNED FROM CZ');
1752: END IF;
1753: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION
1754: AND
1755: l_replenish_to_order_flag = 'Y' AND
1756: l_build_in_wip_flag = 'Y'
1757: THEN

Line 1817: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION

1813: -- should have line_id = ato_line_id, if ato_item is
1814: -- under a ato sub config, its ato_line_id = line_id
1815: -- of the ato sub config.
1816:
1817: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION
1818: AND
1819: l_replenish_to_order_flag = 'Y' AND
1820: l_build_in_wip_flag = 'Y'
1821: THEN

Line 1969: IF p_line_rec.operation = oe_globals.g_opr_update THEN

1965: IF l_debug_level > 0 THEN
1966: oe_debug_pub.add( 'ENTERING CHECK ITEM TYPE' ) ;
1967: oe_debug_pub.add( 'ITEM TYPE '|| P_ITEM_TYPE_CODE ) ;
1968: END IF;
1969: IF p_line_rec.operation = oe_globals.g_opr_update THEN
1970: IF (p_old_line_rec.item_type_code <> FND_API.G_MISS_CHAR AND
1971: p_old_line_rec.item_type_code IS NOT NULL) THEN
1972:
1973: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.item_type_code,

Line 1973: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.item_type_code,

1969: IF p_line_rec.operation = oe_globals.g_opr_update THEN
1970: IF (p_old_line_rec.item_type_code <> FND_API.G_MISS_CHAR AND
1971: p_old_line_rec.item_type_code IS NOT NULL) THEN
1972:
1973: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.item_type_code,
1974: p_item_type_code) THEN
1975:
1976: FND_MESSAGE.SET_NAME('ONT','OE_ITEM_TYPE_CONST');
1977: OE_MSG_PUB.ADD;

Line 2030: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

2026: RETURN NULL;
2027: END IF;
2028:
2029:
2030: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
2031: g_line_rec.subscription_enable_flag := 'N'; -- sol_ord_er #16014165
2032: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2033: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)
2034: ELSIF p_line_rec.line_category_code = 'ORDER'

Line 2032: RETURN OE_GLOBALS.G_ITEM_STANDARD;

2028:
2029:
2030: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
2031: g_line_rec.subscription_enable_flag := 'N'; -- sol_ord_er #16014165
2032: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2033: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)
2034: ELSIF p_line_rec.line_category_code = 'ORDER'
2035: and p_line_rec.retrobill_request_id is NOT NULL
2036: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN

Line 2038: RETURN OE_GLOBALS.G_ITEM_STANDARD;

2034: ELSIF p_line_rec.line_category_code = 'ORDER'
2035: and p_line_rec.retrobill_request_id is NOT NULL
2036: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN
2037:
2038: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2039: --- BUG#6933507
2040: /*ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
2041: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN*/
2042: -- sol_ord_er #16014165 commented above as Included Item can be Subscription Service */

Line 2040: /*ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

2036: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN
2037:
2038: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2039: --- BUG#6933507
2040: /*ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
2041: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN*/
2042: -- sol_ord_er #16014165 commented above as Included Item can be Subscription Service */
2043: -- LABEL: SOL_ORD 100
2044: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

Line 2041: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN*/

2037:
2038: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2039: --- BUG#6933507
2040: /*ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
2041: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN*/
2042: -- sol_ord_er #16014165 commented above as Included Item can be Subscription Service */
2043: -- LABEL: SOL_ORD 100
2044: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
2045: RETURN p_line_rec.item_type_code;

Line 2044: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

2040: /*ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
2041: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN*/
2042: -- sol_ord_er #16014165 commented above as Included Item can be Subscription Service */
2043: -- LABEL: SOL_ORD 100
2044: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
2045: RETURN p_line_rec.item_type_code;
2046: END IF;
2047:
2048:

Line 2059: If(OE_ORDER_CACHE.g_item_rec.contract_item_type_code = OE_GLOBALS.G_ITEM_SUBSCRIPTION)

2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'BOM ITEM TYPE IS ' || L_BOM_ITEM_TYPE ) ;
2057: END IF;
2058: -- sol_ord_er #16014165
2059: If(OE_ORDER_CACHE.g_item_rec.contract_item_type_code = OE_GLOBALS.G_ITEM_SUBSCRIPTION)
2060: THEN
2061: /* If System Parameter is set to default behaviour of subscription Item as Service */
2062: If( OE_Sys_Parameters.VALUE('OM_DEF_SUBSCRIPTION_BEHAVIOUR',p_line_rec.org_id) = 'SUB')
2063: AND p_line_rec.subscription_enable_flag <> 'N' THEN

Line 2090: If p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN

2086: oe_debug_pub.add('SK OEXDLINB.pls SUBSCRIPTION4 N');
2087: End If;
2088: End If;
2089: /* Logic commented at LABEL: SOL_ORD 100 is implemented here */
2090: If p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
2091: RETURN p_line_rec.item_type_code;
2092: End If;
2093: -- sol_ord_er #16014165 end
2094:

Line 2110: OE_GLOBALS.G_ITEM_CLASS);

2106: END IF;
2107: --Procedure to check change in item_type_code
2108: Check_Item_Type(p_line_rec,
2109: p_old_line_rec,
2110: OE_GLOBALS.G_ITEM_CLASS);
2111: RETURN OE_GLOBALS.G_ITEM_CLASS;
2112: END IF;
2113:
2114: IF l_debug_level > 0 THEN

Line 2111: RETURN OE_GLOBALS.G_ITEM_CLASS;

2107: --Procedure to check change in item_type_code
2108: Check_Item_Type(p_line_rec,
2109: p_old_line_rec,
2110: OE_GLOBALS.G_ITEM_CLASS);
2111: RETURN OE_GLOBALS.G_ITEM_CLASS;
2112: END IF;
2113:
2114: IF l_debug_level > 0 THEN
2115: oe_debug_pub.add( 'RETURNING MODEL AS THE ITEM TYPE' , 1 ) ;

Line 2120: OE_GLOBALS.G_ITEM_MODEL);

2116: END IF;
2117: --Procedure to check change in item_type_code
2118: Check_Item_Type(p_line_rec,
2119: p_old_line_rec,
2120: OE_GLOBALS.G_ITEM_MODEL);
2121: RETURN OE_GLOBALS.G_ITEM_MODEL;
2122:
2123: ELSIF l_bom_item_type = 2
2124: THEN

Line 2121: RETURN OE_GLOBALS.G_ITEM_MODEL;

2117: --Procedure to check change in item_type_code
2118: Check_Item_Type(p_line_rec,
2119: p_old_line_rec,
2120: OE_GLOBALS.G_ITEM_MODEL);
2121: RETURN OE_GLOBALS.G_ITEM_MODEL;
2122:
2123: ELSIF l_bom_item_type = 2
2124: THEN
2125: IF l_debug_level > 0 THEN

Line 2132: OE_GLOBALS.G_ITEM_CLASS);

2128: -- Only CLASS items have bom_item_type = 2
2129: --Procedure to check change in item_type_code
2130: Check_Item_Type(p_line_rec,
2131: p_old_line_rec,
2132: OE_GLOBALS.G_ITEM_CLASS);
2133: RETURN OE_GLOBALS.G_ITEM_CLASS;
2134:
2135: ELSIF l_bom_item_type = 4 and
2136: l_service_item_flag = 'N'

Line 2133: RETURN OE_GLOBALS.G_ITEM_CLASS;

2129: --Procedure to check change in item_type_code
2130: Check_Item_Type(p_line_rec,
2131: p_old_line_rec,
2132: OE_GLOBALS.G_ITEM_CLASS);
2133: RETURN OE_GLOBALS.G_ITEM_CLASS;
2134:
2135: ELSIF l_bom_item_type = 4 and
2136: l_service_item_flag = 'N'
2137: THEN

Line 2156: l_item_type_code := OE_GLOBALS.G_ITEM_KIT;

2152: --16559475 start commented below part of code from IF statement
2153: THEN
2154: --AND nvl(g_line_rec.top_model_line_id, 0) = nvl(g_line_rec.line_id, 0) THEN-- sol_ord_er #16014165
2155: --16559475 end
2156: l_item_type_code := OE_GLOBALS.G_ITEM_KIT;
2157: ELSIF (g_line_rec.top_model_line_id is not null AND
2158: g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM)
2159: THEN
2160: IF l_debug_level > 0 THEN

Line 2163: l_item_type_code := OE_GLOBALS.G_ITEM_OPTION;

2159: THEN
2160: IF l_debug_level > 0 THEN
2161: oe_debug_pub.add( 'GET_ITEM_TYPE NO DATA FOUND , BOM_ITEM_TYPE : 4' , 1 ) ;
2162: END IF;
2163: l_item_type_code := OE_GLOBALS.G_ITEM_OPTION;
2164: -- sol_ord_er #16014165
2165: ELSIF g_line_rec.subscription_enable_flag = 'Y' then
2166: IF l_debug_level > 0 THEN
2167: oe_debug_pub.add('SK OEXDLINB.pls 7.1 Returning Service');

Line 2169: l_item_type_code := OE_GLOBALS.G_ITEM_SERVICE;

2165: ELSIF g_line_rec.subscription_enable_flag = 'Y' then
2166: IF l_debug_level > 0 THEN
2167: oe_debug_pub.add('SK OEXDLINB.pls 7.1 Returning Service');
2168: End If;
2169: l_item_type_code := OE_GLOBALS.G_ITEM_SERVICE;
2170: -- sol_ord_er #16014165 end
2171: ELSE
2172: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
2173: END IF;

Line 2172: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

2168: End If;
2169: l_item_type_code := OE_GLOBALS.G_ITEM_SERVICE;
2170: -- sol_ord_er #16014165 end
2171: ELSE
2172: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
2173: END IF;
2174:
2175: IF l_debug_level > 0 THEN
2176: oe_debug_pub.add( ' BEFORE CALLING CHECK 1' ) ;

Line 2193: OE_GLOBALS.G_ITEM_SERVICE);

2189: END IF;
2190: --Procedure to check change in item_type_code
2191: Check_Item_Type(p_line_rec,
2192: p_old_line_rec,
2193: OE_GLOBALS.G_ITEM_SERVICE);
2194: RETURN OE_GLOBALS.G_ITEM_SERVICE;
2195:
2196: END IF;
2197:

Line 2194: RETURN OE_GLOBALS.G_ITEM_SERVICE;

2190: --Procedure to check change in item_type_code
2191: Check_Item_Type(p_line_rec,
2192: p_old_line_rec,
2193: OE_GLOBALS.G_ITEM_SERVICE);
2194: RETURN OE_GLOBALS.G_ITEM_SERVICE;
2195:
2196: END IF;
2197:
2198: RETURN null;

Line 2210: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

2206: WHEN NO_DATA_FOUND THEN
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add( ' BEFORE CALLING CHECK 4' ) ;
2209: END IF;
2210: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
2211: --Procedure to check change in item_type_code
2212: Check_Item_Type(p_line_rec,
2213: p_old_line_rec,
2214: l_item_type_code);

Line 2275: OE_GLOBALS.Set_Context;

2271: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2272: --
2273: BEGIN
2274:
2275: OE_GLOBALS.Set_Context;
2276: l_org_id := OE_GLOBALS.G_ORG_ID;
2277:
2278: RETURN l_Org_Id;
2279:

Line 2276: l_org_id := OE_GLOBALS.G_ORG_ID;

2272: --
2273: BEGIN
2274:
2275: OE_GLOBALS.Set_Context;
2276: l_org_id := OE_GLOBALS.G_ORG_ID;
2277:
2278: RETURN l_Org_Id;
2279:
2280: END Get_Org;

Line 2297: IF (p_line_rec.operation = oe_globals.g_opr_create) and

2293: oe_debug_pub.add( 'IN DEFAULTING: FUNCTION GET_LINE_CATEGORY' , 1 ) ;
2294: END IF;
2295:
2296: /* replaced with the following IF for 2421909
2297: IF (p_line_rec.operation = oe_globals.g_opr_create) and
2298: (p_line_rec.line_type_id IS NULL OR
2299: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2300: */
2301:

Line 2315: IF (p_line_rec.operation = oe_globals.g_opr_create)

2311: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2312: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2313: */
2314:
2315: IF (p_line_rec.operation = oe_globals.g_opr_create)
2316: THEN -- 2421909ND
2317:
2318: IF l_debug_level > 0 THEN
2319: oe_debug_pub.add( 'AK IN DEFAULTING: OPERATION IS CREATE' , 1 ) ;

Line 2345: IF (p_line_rec.operation = oe_globals.g_opr_update AND

2341: END IF;
2342: --retro{In the case of price increase for original line, the initial
2343: --retrobill line will be created with line_category return and has to be
2344: --updated to order
2345: IF (p_line_rec.operation = oe_globals.g_opr_update AND
2346: p_old_line_rec.line_category_code = 'RETURN' AND
2347: p_line_rec.line_category_code = 'ORDER' AND
2348: p_line_rec.order_source_id = 27 ) THEN
2349: l_category := 'ORDER';

Line 2359: IF p_line_rec.operation = oe_globals.g_opr_update THEN

2355: IF l_debug_level > 0 THEN
2356: oe_debug_pub.add( 'LINE CATEGORY: ' || L_CATEGORY ) ;
2357: END IF;
2358:
2359: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2360:
2361: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2362: p_old_line_rec.line_category_code IS NOT NULL) THEN
2363:

Line 2364: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,

2360:
2361: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2362: p_old_line_rec.line_category_code IS NOT NULL) THEN
2363:
2364: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,
2365: l_category) THEN
2366: --retro{In the case of price increase for original line, the initial
2367: --retrobill line will be created with line_category return and has to be
2368: --updated to order.The original flow doesn't allow and raises exception,To

Line 2370: IF (p_line_rec.operation = oe_globals.g_opr_update AND

2366: --retro{In the case of price increase for original line, the initial
2367: --retrobill line will be created with line_category return and has to be
2368: --updated to order.The original flow doesn't allow and raises exception,To
2369: --prevent the exception a if loop is added in the case of retrobilling
2370: IF (p_line_rec.operation = oe_globals.g_opr_update AND
2371: p_old_line_rec.line_category_code = 'RETURN' AND
2372: p_line_rec.line_category_code = 'ORDER' AND
2373: p_line_rec.order_source_id = 27 AND
2374: p_line_rec.retrobill_request_id is not null) THEN

Line 2403: IF p_line_rec.operation = oe_globals.g_opr_update THEN

2399: IF l_debug_level > 0 THEN
2400: oe_debug_pub.add( 'IN DEFAULTING: NO DATAFOUND' , 1 ) ;
2401: END IF;
2402: l_category := 'ORDER';
2403: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2404:
2405: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2406: p_old_line_rec.line_category_code IS NOT NULL) THEN
2407:

Line 2408: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,

2404:
2405: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2406: p_old_line_rec.line_category_code IS NOT NULL) THEN
2407:
2408: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,
2409: l_category) THEN
2410: FND_MESSAGE.SET_NAME('ONT', 'OE_LINE_CAT_CONST');
2411: OE_MSG_PUB.ADD;
2412: IF l_debug_level > 0 THEN

Line 2634: l_source_type VARCHAR2(30) := OE_GLOBALS.G_SOURCE_INTERNAL;

2630: FUNCTION Get_Source_Type(p_source_type IN VARCHAR2,
2631: p_line_type_id IN NUMBER)
2632: RETURN VARCHAR2
2633: IS
2634: l_source_type VARCHAR2(30) := OE_GLOBALS.G_SOURCE_INTERNAL;
2635: --
2636: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2637: --
2638: BEGIN

Line 2656: IF l_source_type <> OE_GLOBALS.G_SOURCE_EXTERNAL AND

2652: IF l_source_type is null THEN
2653: RETURN p_source_type;
2654: END IF;
2655:
2656: IF l_source_type <> OE_GLOBALS.G_SOURCE_EXTERNAL AND
2657: l_source_type <> OE_GLOBALS.G_SOURCE_INTERNAL THEN
2658: l_source_type := p_source_type;
2659: END IF;
2660:

Line 2657: l_source_type <> OE_GLOBALS.G_SOURCE_INTERNAL THEN

2653: RETURN p_source_type;
2654: END IF;
2655:
2656: IF l_source_type <> OE_GLOBALS.G_SOURCE_EXTERNAL AND
2657: l_source_type <> OE_GLOBALS.G_SOURCE_INTERNAL THEN
2658: l_source_type := p_source_type;
2659: END IF;
2660:
2661: EXCEPTION

Line 2700: IF (p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN

2696: THEN
2697: RETURN NULL;
2698: END IF;
2699:
2700: IF (p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN
2701: RETURN 'Y';
2702: END IF;
2703:
2704: IF l_debug_level > 0 THEN

Line 2714: IF NOT OE_GLOBALS.Equal(p_item_type_code,

2710: (p_ato_line_id <> FND_API.G_MISS_NUM)
2711: THEN
2712:
2713: -- ##1820608, ato_item can be under a pto model.
2714: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2715: OE_GLOBALS.G_ITEM_STANDARD) AND
2716: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2717: p_line_id = p_ato_line_id )AND
2718: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND -- 9775352

Line 2715: OE_GLOBALS.G_ITEM_STANDARD) AND

2711: THEN
2712:
2713: -- ##1820608, ato_item can be under a pto model.
2714: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2715: OE_GLOBALS.G_ITEM_STANDARD) AND
2716: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2717: p_line_id = p_ato_line_id )AND
2718: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND -- 9775352
2719: p_line_id = p_ato_line_id )

Line 2716: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

2712:
2713: -- ##1820608, ato_item can be under a pto model.
2714: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2715: OE_GLOBALS.G_ITEM_STANDARD) AND
2716: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2717: p_line_id = p_ato_line_id )AND
2718: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND -- 9775352
2719: p_line_id = p_ato_line_id )
2720: THEN

Line 2718: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND -- 9775352

2714: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2715: OE_GLOBALS.G_ITEM_STANDARD) AND
2716: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2717: p_line_id = p_ato_line_id )AND
2718: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED AND -- 9775352
2719: p_line_id = p_ato_line_id )
2720: THEN
2721:
2722: IF l_debug_level > 0 THEN

Line 3629: p_x_line_rec.item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

3625: p_x_line_rec.ordered_item := l_ref_line_rec.ordered_item ;
3626: p_x_line_rec.inventory_item_id := l_ref_line_rec.inventory_item_id;
3627: p_x_line_rec.item_identifier_type := l_ref_line_rec.item_identifier_type;
3628: p_x_line_rec.ordered_item_id := l_ref_line_rec.ordered_item_id;
3629: p_x_line_rec.item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
3630: ELSE
3631: NULL;
3632: END IF;
3633:

Line 3746: OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' THEN

3742:
3743: IF (p_x_line_rec.pricing_quantity IS NULL OR
3744: p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM) THEN
3745: IF p_x_line_rec.return_context = 'SERIAL' OR
3746: OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' THEN
3747: p_x_line_rec.pricing_quantity_uom :=
3748: l_ref_line_rec.pricing_quantity_uom;
3749: p_x_line_rec.pricing_quantity := OE_Order_Misc_Util.convert_uom(
3750: p_x_line_rec.inventory_item_id,

Line 4081: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2)

4077: oe_debug_pub.add( 'INSIDE DEFAULTING RMA' , 1 ) ;
4078: oe_debug_pub.add( 'RMA OPERATION IS'||P_X_LINE_REC.OPERATION , 1 ) ;
4079: END IF;
4080:
4081: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2)
4082: THEN
4083: IF l_debug_level > 0 THEN
4084: oe_debug_pub.add( 'CLEARING RMA_ATTRIBUTES' , 1 ) ;
4085: oe_debug_pub.add( ' OLD P_OLD_LINE_REC.RETURN_CONTEXT = '||P_OLD_LINE_REC.RETURN_CONTEXT , 1 ) ;

Line 4180: IF OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' OR NOT (OE_GLOBALS.G_UI_FLAG) THEN

4176: oe_debug_pub.add( ' p_x_line_rec.ordered_quantity = '|| p_x_line_rec.ordered_quantity,5 ) ;
4177: END IF;
4178:
4179:
4180: IF OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' OR NOT (OE_GLOBALS.G_UI_FLAG) THEN
4181: p_x_line_rec.ordered_quantity := l_line_rec.ordered_quantity; -- bug# 6617423 -----bug#9854947: Uncommenting the code
4182: ---bug#9854947 : commenting the following ER's code : this is unwanted
4183: /*
4184: -- bug# 6617423 : start

Line 4215: IF p_x_line_rec.source_document_type_id = 2 OR OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' THEN

4211: IF p_x_line_rec.source_document_type_id = 2 THEN
4212: p_x_line_rec.order_source_id := 2;
4213: END IF;
4214:
4215: IF p_x_line_rec.source_document_type_id = 2 OR OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' THEN
4216: p_x_line_rec.calculate_price_flag := l_line_rec.calculate_price_flag;
4217: p_x_line_rec.pricing_date := l_line_rec.pricing_date;
4218: IF l_debug_level > 0 THEN
4219: oe_debug_pub.add( 'CALCULATE PRICE FLAG : '||P_X_LINE_REC.CALCULATE_PRICE_FLAG ) ;

Line 4227: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN

4223:
4224: -- Fix for the issue 2347377. Retain the flex values if sent in
4225: -- by NON-UI call like (OrderImport) / COPY.
4226:
4227: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
4228: IF l_debug_level > 0 THEN
4229: oe_debug_pub.add('Context is' ||P_X_LINE_REC.context);
4230: oe_debug_pub.add('Attribute 1 is : '||P_X_LINE_REC.attribute1);
4231: END IF;

Line 4351: END IF; --IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2) THEN

4347: p_x_line_rec.tp_attribute15 := l_line_rec.tp_attribute15;
4348:
4349: END IF;
4350:
4351: END IF; --IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2) THEN
4352:
4353:
4354: IF p_x_line_rec.return_attribute2 is NOT NULL AND
4355: p_x_line_rec.return_attribute2 <> FND_API.G_MISS_CHAR

Line 4378: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2) THEN

4374: IF l_debug_level > 0 THEN
4375: oe_debug_pub.add( 'IN DEFAULT RETURN ATTRIBUTES -1' , 1 ) ;
4376: END IF;
4377:
4378: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2) THEN
4379:
4380: -- Get the values of l_currency_code and l_sold_to_org_id
4381: OE_ORDER_CACHE.Load_Order_Header(p_x_line_rec.header_id);
4382: l_sold_to_org_id := OE_ORDER_CACHE.g_header_rec.SOLD_TO_ORG_ID;

Line 4450: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;

4446: p_x_line_rec.actual_shipment_date := NULL;
4447: -- source type code for RMA lines will always be set to internal. If
4448: -- in future we plan to change the design then please comment out the
4449: -- following code.
4450: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
4451:
4452: p_x_line_rec.over_ship_reason_code := NULL;
4453: p_x_line_rec.over_ship_resolved_flag := NULL;
4454: p_x_line_rec.shipping_interfaced_flag := NULL;

Line 4466: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF); */ --bug 14698931

4462: -- CAll OE_Validate_Line.Attributes
4463: /* OE_Validate_Line.Attributes(
4464: x_return_status => l_return_status
4465: , p_x_line_rec => p_x_line_rec
4466: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF); */ --bug 14698931
4467: ---Start bug# 14698931
4468: if OE_GLOBALS.g_validate_desc_flex ='Y' then
4469: if l_debug_level>0 then
4470: oe_debug_pub.add(' do not validate DFF , setting OE_GLOBALS.G_validate_desc_flex ');

Line 4468: if OE_GLOBALS.g_validate_desc_flex ='Y' then

4464: x_return_status => l_return_status
4465: , p_x_line_rec => p_x_line_rec
4466: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF); */ --bug 14698931
4467: ---Start bug# 14698931
4468: if OE_GLOBALS.g_validate_desc_flex ='Y' then
4469: if l_debug_level>0 then
4470: oe_debug_pub.add(' do not validate DFF , setting OE_GLOBALS.G_validate_desc_flex ');
4471: end if;
4472:

Line 4470: oe_debug_pub.add(' do not validate DFF , setting OE_GLOBALS.G_validate_desc_flex ');

4466: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF); */ --bug 14698931
4467: ---Start bug# 14698931
4468: if OE_GLOBALS.g_validate_desc_flex ='Y' then
4469: if l_debug_level>0 then
4470: oe_debug_pub.add(' do not validate DFF , setting OE_GLOBALS.G_validate_desc_flex ');
4471: end if;
4472:
4473: OE_GLOBALS.g_validate_desc_flex := 'N' ;
4474: OE_Validate_Line.Attributes(

Line 4473: OE_GLOBALS.g_validate_desc_flex := 'N' ;

4469: if l_debug_level>0 then
4470: oe_debug_pub.add(' do not validate DFF , setting OE_GLOBALS.G_validate_desc_flex ');
4471: end if;
4472:
4473: OE_GLOBALS.g_validate_desc_flex := 'N' ;
4474: OE_Validate_Line.Attributes(
4475: x_return_status => l_return_status
4476: , p_x_line_rec => p_x_line_rec
4477: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF);

Line 4477: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF);

4473: OE_GLOBALS.g_validate_desc_flex := 'N' ;
4474: OE_Validate_Line.Attributes(
4475: x_return_status => l_return_status
4476: , p_x_line_rec => p_x_line_rec
4477: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF);
4478: OE_GLOBALS.g_validate_desc_flex := 'Y' ;
4479:
4480: else
4481: OE_Validate_Line.Attributes(

Line 4478: OE_GLOBALS.g_validate_desc_flex := 'Y' ;

4474: OE_Validate_Line.Attributes(
4475: x_return_status => l_return_status
4476: , p_x_line_rec => p_x_line_rec
4477: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF);
4478: OE_GLOBALS.g_validate_desc_flex := 'Y' ;
4479:
4480: else
4481: OE_Validate_Line.Attributes(
4482: x_return_status => l_return_status

Line 4484: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF);

4480: else
4481: OE_Validate_Line.Attributes(
4482: x_return_status => l_return_status
4483: , p_x_line_rec => p_x_line_rec
4484: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF);
4485:
4486: end if ;
4487: ---End bug# 14698931
4488:

Line 4493: END IF; --IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2,....

4489: IF l_debug_level > 0 THEN
4490: oe_debug_pub.add( 'THE ORDERED QTY IS '||P_X_LINE_REC.ORDERED_QUANTITY ) ;
4491: oe_debug_pub.add( 'THE PRICING QTY IS '||P_X_LINE_REC.PRICING_QUANTITY ) ;
4492: END IF;
4493: END IF; --IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2,....
4494:
4495: END IF; --- IF p_x_line_rec.return_attribute2 is NOT NULL
4496:
4497: END Return_Attributes;

Line 4533: /* IF (p_x_line_rec.operation = oe_globals.g_opr_create and */

4529: END IF;
4530: fnd_profile.get('ONT_IMP_MULTIPLE_SHIPMENTS', g_multiple_shipments);
4531: g_multiple_shipments := nvl(g_multiple_shipments, 'NO');
4532:
4533: /* IF (p_x_line_rec.operation = oe_globals.g_opr_create and */
4534: IF p_x_line_rec.return_context is NOT NULL AND
4535: p_x_line_rec.return_context <> FND_API.G_MISS_CHAR THEN
4536: Return_Attributes
4537: ( p_x_line_rec => p_x_line_rec

Line 4567: IF g_line_rec.operation = oe_globals.g_opr_create THEN

4563: -- get item_type is dependent on get_top_model
4564: -- get ato_line , get_shippbale etc are dependent on get_item_type
4565: -- please do not changes their sequence.
4566:
4567: IF g_line_rec.operation = oe_globals.g_opr_create THEN
4568: g_line_rec.org_id := Get_Org;
4569:
4570: -- QUOTING change
4571: -- Initialize flow status to DRAFT for lines in negotiation phase

Line 4620: ELSIF g_line_rec.operation = oe_globals.g_opr_update

4616:
4617: /* Added for the BUG #3257965.
4618: For update operation need to raise an error for line_category_code. */
4619:
4620: ELSIF g_line_rec.operation = oe_globals.g_opr_update
4621: AND NOT OE_GLOBALS.EQUAL(g_line_rec.line_category_code
4622: ,p_old_line_rec.line_category_code)
4623: THEN
4624: --3365705For retrobill we change the order type from return to order

Line 4621: AND NOT OE_GLOBALS.EQUAL(g_line_rec.line_category_code

4617: /* Added for the BUG #3257965.
4618: For update operation need to raise an error for line_category_code. */
4619:
4620: ELSIF g_line_rec.operation = oe_globals.g_opr_update
4621: AND NOT OE_GLOBALS.EQUAL(g_line_rec.line_category_code
4622: ,p_old_line_rec.line_category_code)
4623: THEN
4624: --3365705For retrobill we change the order type from return to order
4625: -- and the exception shouldn't be raised

Line 4644: IF g_line_rec.operation = oe_globals.g_opr_create AND

4640:
4641: -- BUG 3646340: Return_reason is a defaultable field and it needs to be
4642: -- defaulted if the line category changes to RETURN.
4643:
4644: IF g_line_rec.operation = oe_globals.g_opr_create AND
4645: g_line_rec.line_category_code = 'RETURN' AND
4646: g_line_rec.return_reason_code IS NULL AND
4647: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4648: p_old_line_rec.line_category_code)

Line 4647: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,

4643:
4644: IF g_line_rec.operation = oe_globals.g_opr_create AND
4645: g_line_rec.line_category_code = 'RETURN' AND
4646: g_line_rec.return_reason_code IS NULL AND
4647: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4648: p_old_line_rec.line_category_code)
4649: THEN
4650: IF l_debug_level > 0 THEN
4651: oe_debug_pub.add('LINE CATEGORY CHANGED - REASON set to miss') ;

Line 4657: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,

4653: g_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
4654: END IF;
4655:
4656: IF g_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
4657: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4658: p_old_line_rec.line_category_code)
4659: THEN
4660: g_line_rec.top_model_line_id := Get_Top_Model_Line;
4661: END IF;

Line 4671: or NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,

4667: IF l_debug_level > 0 THEN
4668: oe_debug_pub.add( 'BEFORE ITEM_TYPE' ) ;
4669: END IF;
4670: IF g_line_rec.item_type_code = FND_API.G_MISS_CHAR
4671: or NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4672: p_old_line_rec.line_category_code)
4673: THEN
4674: g_line_rec.item_type_code :=
4675: Get_Item_Type(g_line_rec, p_old_line_rec);

Line 4683: IF NOT OE_GLOBALS.Equal(p_old_line_rec.inventory_item_id,

4679: -- we are not checking for miss_char, because there is
4680: -- no clear_dep for smc_flag. and we don ot want to
4681: -- do that because of the way options defaulting work.
4682:
4683: IF NOT OE_GLOBALS.Equal(p_old_line_rec.inventory_item_id,
4684: g_line_rec.inventory_item_id) THEN
4685: IF l_debug_level > 0 THEN
4686: oe_debug_pub.add( 'CALLING GET_SMC' , 3 ) ;
4687: END IF;

Line 4704: g_line_rec.operation = OE_GLOBALS.G_OPR_CREATE

4700: -- get_item_type and get_smc_flag
4701:
4702: IF (g_line_rec.item_type_code <> FND_API.G_MISS_CHAR OR
4703: g_line_rec.item_type_code is not null) AND
4704: g_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
4705: THEN
4706: model_option_defaulting;
4707: END IF;
4708:

Line 4711: g_line_rec.org_id := OE_GLOBALS.G_ORG_ID;

4707: END IF;
4708:
4709: IF (g_line_rec.line_id = FND_API.G_MISS_NUM) OR
4710: (g_line_rec.line_id IS NULL) THEN
4711: g_line_rec.org_id := OE_GLOBALS.G_ORG_ID;
4712: END IF;
4713:
4714: IF g_line_rec.booked_flag = FND_API.G_MISS_CHAR THEN
4715: g_line_rec.booked_flag := Get_Booked;

Line 4797: IF NOT OE_GLOBALS.EQUAL( g_line_rec.sold_to_org_id

4793: -- Fixed bug 1206047: if user provides a value for the customer (sold_to)
4794: -- then override it with the value of sold_to from the header
4795: -- For the initial release, customer should be common on all lines of
4796: -- an order.
4797: IF NOT OE_GLOBALS.EQUAL( g_line_rec.sold_to_org_id
4798: ,p_old_line_rec.sold_to_org_id )
4799: THEN
4800: g_line_rec.sold_to_org_id := Get_Sold_To;
4801: END IF;

Line 4814: --p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

4810: IF nvl(g_line_rec.top_model_line_id,0) <> nvl(g_line_rec.ato_line_id,0) AND
4811: g_line_rec.top_model_line_id IS NOT NULL THEN
4812:
4813: /* Change for bug 2276993 */
4814: --p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4815:
4816: IF g_line_rec.ship_tolerance_below IS NULL OR
4817: g_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM OR
4818: g_line_rec.ship_tolerance_below = p_old_Line_rec.ship_tolerance_below THEN

Line 4869: IF ( l_in_rec.operation = OE_GLOBALS.G_OPR_CREATE -- 7152122

4865:
4866: --Perform blanket defaulting
4867: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4868:
4869: IF ( l_in_rec.operation = OE_GLOBALS.G_OPR_CREATE -- 7152122
4870: AND trunc( l_in_rec.request_date ) <> trunc(l_in_old_rec.request_date)
4871: AND l_in_rec.blanket_line_number IS NOT NULL )THEN
4872: l_in_rec.blanket_line_number := FND_API.G_MISS_NUM;
4873: END IF;

Line 4942: AND (NOT OE_GLOBALS.EQUAL(l_in_rec.blanket_number,l_rec.blanket_number)

4938: -- More blanket defaulting
4939: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4940:
4941: IF l_rec.blanket_number IS NOT NULL
4942: AND (NOT OE_GLOBALS.EQUAL(l_in_rec.blanket_number,l_rec.blanket_number)
4943: OR trunc(l_blanket_request_date) <> trunc(l_rec.request_date)
4944: )
4945: THEN
4946:

Line 4992: IF NOT oe_globals.equal(p_x_line_rec.pricing_date,

4988:
4989: IF p_x_line_rec.agreement_id IS NOT NULL AND
4990: p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN
4991:
4992: IF NOT oe_globals.equal(p_x_line_rec.pricing_date,
4993: p_old_line_rec.pricing_date)
4994: OR
4995: not oe_globals.equal(p_x_line_rec.agreement_id,
4996: p_old_line_rec.agreement_id) THEN

Line 4995: not oe_globals.equal(p_x_line_rec.agreement_id,

4991:
4992: IF NOT oe_globals.equal(p_x_line_rec.pricing_date,
4993: p_old_line_rec.pricing_date)
4994: OR
4995: not oe_globals.equal(p_x_line_rec.agreement_id,
4996: p_old_line_rec.agreement_id) THEN
4997:
4998: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4999: Default_Active_Agr_Revision

Line 4998: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

4994: OR
4995: not oe_globals.equal(p_x_line_rec.agreement_id,
4996: p_old_line_rec.agreement_id) THEN
4997:
4998: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4999: Default_Active_Agr_Revision
5000: ( p_x_line_rec => p_x_line_rec,
5001: p_old_line_rec => p_old_line_rec);
5002: END IF;

Line 5042: --IF NOT (oe_globals.g_ui_flag) THEN -- added for bug 7675652 --commented for bug 11778250

5038:
5039: -- The code below is not required when order created from UI, but is required for the orders created/update othe sources like Process Order
5040: -- and Order Import. The Pricing Quantity and UOM is anyways returned by Pricing Engine in case UI. Added condition accordingly for bug 7675652.
5041:
5042: --IF NOT (oe_globals.g_ui_flag) THEN -- added for bug 7675652 --commented for bug 11778250
5043: IF (p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM
5044: OR p_x_line_rec.pricing_quantity is NULL
5045: OR p_x_line_rec.pricing_quantity = -99999) THEN
5046: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR

Line 5084: /*IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

5080: oe_debug_pub.add(' Ordered UOM '|| p_x_line_rec.order_quantity_uom,1);
5081: oe_debug_pub.add( ' Pricing Qty is not equal to Ord Qty and P_UOM is not populated' , 1 ) ;
5082: END IF;
5083: --commented for bug 11778250
5084: /*IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
5085: --Added the message after review.
5086: FND_MESSAGE.SET_NAME('ONT', 'ONT_INVALID_ORD_QTY_PRC_QTY');
5087: OE_MSG_PUB.Add;
5088: RAISE FND_API.G_EXC_ERROR;

Line 5207: IF (p_x_line_rec.operation = Oe_Globals.G_Opr_Create) THEN

5203: END IF;
5204: */
5205: -- Bug 8626559: Start
5206: IF (p_x_line_rec.flow_status_code = Fnd_Api.G_Miss_Char) THEN
5207: IF (p_x_line_rec.operation = Oe_Globals.G_Opr_Create) THEN
5208: IF p_x_line_rec.transaction_phase_code = 'N' THEN
5209: p_x_line_rec.flow_status_code := 'DRAFT';
5210: ELSE
5211: p_x_line_rec.flow_status_code := 'ENTERED';

Line 5417: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;

5413: END IF;
5414:
5415: IF p_x_line_rec.source_type_code is null OR
5416: p_x_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN
5417: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5418: END IF;
5419:
5420: -- Bug 5708174
5421: IF p_x_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN

Line 5421: IF p_x_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN

5417: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5418: END IF;
5419:
5420: -- Bug 5708174
5421: IF p_x_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN
5422: p_x_line_rec.subinventory := NULL;
5423: END IF;
5424: -- Added to fix the issue in bug 2894486
5425: IF p_x_line_rec.line_category_code = 'RETURN' THEN

Line 5426: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;

5422: p_x_line_rec.subinventory := NULL;
5423: END IF;
5424: -- Added to fix the issue in bug 2894486
5425: IF p_x_line_rec.line_category_code = 'RETURN' THEN
5426: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5427: p_x_line_rec.ato_line_id := NULL;
5428: END IF;
5429:
5430: -- Bug 5331971, internal orders shall not be externally sourced

Line 5432: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;

5428: END IF;
5429:
5430: -- Bug 5331971, internal orders shall not be externally sourced
5431: IF p_x_line_rec.order_source_id = 10 THEN
5432: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5433: END IF;
5434: /* commented for bug 13088960
5435: -- This is the new condition aksingh changed on 04/22/01
5436: IF NOT OE_GLOBALS.Equal(p_x_line_rec.request_date,

Line 5436: IF NOT OE_GLOBALS.Equal(p_x_line_rec.request_date,

5432: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5433: END IF;
5434: /* commented for bug 13088960
5435: -- This is the new condition aksingh changed on 04/22/01
5436: IF NOT OE_GLOBALS.Equal(p_x_line_rec.request_date,
5437: p_old_line_rec.request_date)
5438: THEN
5439: IF l_debug_level > 0 THEN
5440: oe_debug_pub.add( 'OEXDLINB -1- CHECK FOR G_MISS_DATE FOR REQUEST ' ) ;

Line 5447: IF OE_GLOBALS.Equal(p_x_line_rec.latest_acceptable_date,

5443: -- aksingh added this if for the bug 1745501
5444: IF l_debug_level > 0 THEN
5445: oe_debug_pub.add( 'OEXDLINB -2- CHECK FOR G_MISS_DATE FOR LATEST ' ) ;
5446: END IF;
5447: IF OE_GLOBALS.Equal(p_x_line_rec.latest_acceptable_date,
5448: p_old_line_rec.latest_acceptable_date)
5449: OR p_x_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE
5450: THEN
5451: IF l_debug_level > 0 THEN

Line 5572: IF NOT OE_GLOBALS.Equal(p_x_line_rec.line_type_id,

5568: END IF;
5569:
5570: /* The following lines are commented to fix the bug 1409036 */
5571: /*
5572: IF NOT OE_GLOBALS.Equal(p_x_line_rec.line_type_id,
5573: p_old_line_rec.line_type_id)
5574: THEN
5575: p_x_line_rec.source_type_code :=
5576: Get_Source_Type(p_source_type => p_x_line_rec.source_type_code,

Line 5596: OR NOT OE_GLOBALS.Equal(p_x_Line_rec.subscription_enable_flag,

5592: End If;
5593: -- sol_ord_er #16014165 end
5594: IF (p_x_line_rec.shippable_flag is NULL OR
5595: p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR )
5596: OR NOT OE_GLOBALS.Equal(p_x_Line_rec.subscription_enable_flag,
5597: p_old_line_rec.subscription_enable_flag) THEN -- sol_ord_er #16014165
5598: IF l_debug_level > 0 THEN
5599: oe_debug_pub.add( 'CALLING GET SHIPPABLE_FLAG ' , 1 ) ;
5600: END IF;

Line 5632: AND NOT OE_GLOBALS.Equal(p_old_line_rec.ship_from_org_id,

5628: p_x_line_rec.service_duration := '';
5629: END IF;
5630:
5631: IF p_x_line_rec.schedule_status_code is null
5632: AND NOT OE_GLOBALS.Equal(p_old_line_rec.ship_from_org_id,
5633: p_x_line_rec.ship_from_org_id) THEN
5634: IF p_x_line_rec.ship_from_org_id is not null
5635: THEN
5636: IF l_debug_level > 0 THEN

Line 5673: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE

5669: END IF;
5670: END IF;
5671:
5672:
5673: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
5674: THEN
5675: model_option_update (p_x_line_rec => p_x_line_rec);
5676: END IF;
5677:

Line 5684: --p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

5680: IF nvl(p_x_line_rec.top_model_line_id,0) <> nvl(p_x_line_rec.ato_line_id,0) AND
5681: p_x_line_rec.top_model_line_id IS NOT NULL THEN
5682:
5683: /* Change for bug 2276993 */
5684: --p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
5685:
5686: /* Fix for bug 2420456 */
5687: IF l_set_tolerance_below = 'Y' THEN
5688:

Line 5725: IF NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,

5721: END IF;
5722:
5723: -- to clear out user_item_description if item changes
5724: -- and user_item_description is not changing.
5725: IF NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,
5726: p_old_line_rec.inventory_item_id)
5727: AND OE_GLOBALS.Equal(p_x_line_rec.user_item_description,
5728: p_old_line_rec.user_item_description)
5729: AND p_old_line_rec.user_item_description IS NOT NULL THEN

Line 5727: AND OE_GLOBALS.Equal(p_x_line_rec.user_item_description,

5723: -- to clear out user_item_description if item changes
5724: -- and user_item_description is not changing.
5725: IF NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,
5726: p_old_line_rec.inventory_item_id)
5727: AND OE_GLOBALS.Equal(p_x_line_rec.user_item_description,
5728: p_old_line_rec.user_item_description)
5729: AND p_old_line_rec.user_item_description IS NOT NULL THEN
5730:
5731: p_x_line_rec.user_item_description := NULL;