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 83: IF OE_GLOBALS.G_UI_FLAG then

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

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

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

Line 128: NOT OE_GLOBALS.EQUAL(p_line_rec.ship_from_org_id

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

Line 130: NOT OE_GLOBALS.EQUAL(p_line_rec.freight_carrier_code

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

Line 213: IF NOT oe_globals.G_HTML_FLAG THEN

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

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

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

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

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

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

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

Line 425: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

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

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

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

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

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

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

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

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

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

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

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

1021: IF p_x_line_rec.blanket_line_number IS NOT NULL
1022: AND p_x_line_rec.blanket_line_number <> FND_API.G_MISS_NUM
1023: THEN
1024:
1025: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
1026: OR p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM)
1027: THEN
1028:
1029: if l_debug_level > 0 then

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

1063: ELSIF (p_x_line_rec.sold_to_org_id IS NOT NULL
1064: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1065: AND p_x_line_rec.inventory_item_id IS NOT NULL
1066: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1067: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1068: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1069: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id)
1070: )
1071: -- Bug 2769562 => If blanket line number is being cleared by user

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

1064: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1065: AND p_x_line_rec.inventory_item_id IS NOT NULL
1066: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1067: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1068: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1069: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id)
1070: )
1071: -- Bug 2769562 => If blanket line number is being cleared by user
1072: -- (value for blanket line number existed in old rec), blanket

Line 1118: AND NOT OE_GLOBALS.EQUAL(l_blanket_number

1114: x_blanket_request_date => x_blanket_request_date
1115: );
1116:
1117: IF (l_blanket_number IS NOT NULL
1118: AND NOT OE_GLOBALS.EQUAL(l_blanket_number
1119: ,p_x_line_rec.blanket_number))
1120: OR (l_blanket_line_number IS NOT NULL
1121: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number
1122: ,p_x_line_rec.blanket_line_number))

Line 1121: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number

1117: IF (l_blanket_number IS NOT NULL
1118: AND NOT OE_GLOBALS.EQUAL(l_blanket_number
1119: ,p_x_line_rec.blanket_number))
1120: OR (l_blanket_line_number IS NOT NULL
1121: AND NOT OE_GLOBALS.EQUAL(l_blanket_line_number
1122: ,p_x_line_rec.blanket_line_number))
1123: THEN
1124: Clear_And_Re_Default
1125: (p_blanket_number => l_blanket_number

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

1300: children into same fulfillment set. We exclude service item and the
1301: top model itself*/
1302: -- 4118431
1303: IF (g_line_rec.line_id <> g_line_rec.top_model_line_id AND
1304: g_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE AND
1305: g_line_rec.top_modeL_line_id IS NOT NULL AND
1306: g_line_rec.line_id > 0 ) THEN
1307:
1308: Insert_into_set

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

1323: * since user dose not enter them.They are created in the
1324: * process_included_items procedure and all the fields to be populated
1325: * from the parent line, are populated there. */
1326:
1327: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1328: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1329: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1330: g_line_rec.line_id = g_line_rec.top_modeL_line_id)
1331: THEN

Line 1328: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR

1324: * process_included_items procedure and all the fields to be populated
1325: * from the parent line, are populated there. */
1326:
1327: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1328: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1329: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1330: g_line_rec.line_id = g_line_rec.top_modeL_line_id)
1331: THEN
1332: IF l_debug_level > 0 THEN

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

1325: * from the parent line, are populated there. */
1326:
1327: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1328: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
1329: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1330: g_line_rec.line_id = g_line_rec.top_modeL_line_id)
1331: THEN
1332: IF l_debug_level > 0 THEN
1333: oe_debug_pub.add( 'RETURNING FOR SERVICE , INCLUDED , TOP LEVEL KITS' , 1 ) ;

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

1347: /* After getting ato_line_id, for top level parents and ato items,
1348: * we don't default any other columns for lines with item_type MODEL
1349: * and STANDARD */
1350:
1351: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1352: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1353: THEN
1354: --{ bug3601544 starts
1355: IF l_debug_level > 0 THEN

Line 1352: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD

1348: * we don't default any other columns for lines with item_type MODEL
1349: * and STANDARD */
1350:
1351: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1352: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1353: THEN
1354: --{ bug3601544 starts
1355: IF l_debug_level > 0 THEN
1356: OE_DEBUG_PUB.Add('IB Owner: '||g_line_rec.ib_owner,3);

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

1388: /* If we are here, it means item_type_code is CLASS, OPTION, KIT under
1389: * a model,or CONFIG. Load top parent, so that we know if it is ato,
1390: * smc pto or nonsmc pto */
1391:
1392: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1393: l_parent_line_id := g_line_rec.ato_line_id;
1394: ELSE
1395: l_parent_line_id := g_line_rec.top_model_line_id;
1396: END IF;

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

1471: END IF;
1472:
1473: /* These updates are valid only for Options/clasees/included items */
1474:
1475: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1476: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1477: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1478: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1479: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)

Line 1476: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

1472:
1473: /* These updates are valid only for Options/clasees/included items */
1474:
1475: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1476: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1477: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1478: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1479: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)
1480: THEN

Line 1477: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR

1473: /* These updates are valid only for Options/clasees/included items */
1474:
1475: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1476: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1477: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1478: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1479: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)
1480: THEN
1481:

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

1474:
1475: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1476: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1477: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
1478: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT AND
1479: p_x_line_rec.line_id = p_x_line_rec.top_modeL_line_id)
1480: THEN
1481:
1482: IF l_debug_level > 0 THEN

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

1485:
1486: RETURN;
1487: END IF;
1488:
1489: IF p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1490: l_parent_line_id := p_x_line_rec.ato_line_id;
1491: ELSE
1492: l_parent_line_id := p_x_line_rec.top_model_line_id;
1493: END IF;

Line 1583: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

1579: RETURN NULL;
1580: END IF;
1581:
1582: IF g_line_rec.line_category_code =
1583: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
1584: RETURN NULL;
1585: END IF;
1586:
1587: OE_ORDER_CACHE.Load_Item

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

1599:
1600: -- top level ATO model and ato item.
1601: -- build in wip flag, see if req?
1602:
1603: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
1604: l_replenish_to_order_flag = 'Y') OR
1605: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
1606: l_replenish_to_order_flag = 'Y' AND
1607: l_build_in_wip_flag = 'Y')

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

1601: -- build in wip flag, see if req?
1602:
1603: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL AND
1604: l_replenish_to_order_flag = 'Y') OR
1605: (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD AND
1606: l_replenish_to_order_flag = 'Y' AND
1607: l_build_in_wip_flag = 'Y')
1608: THEN
1609: IF l_debug_level > 0 THEN

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

1618: * ato model (ont: item_type_code is CLASS, bom_item_type = 1)
1619: * under top ato model will have ato_line_id = line_id
1620: * of top ato parent. kit can not be under an ATO */
1621:
1622: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1623: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1624: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1625:
1626: OE_Order_Cache.Load_Top_Model_Line

Line 1623: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1619: * under top ato model will have ato_line_id = line_id
1620: * of top ato parent. kit can not be under an ATO */
1621:
1622: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1623: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1624: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1625:
1626: OE_Order_Cache.Load_Top_Model_Line
1627: (g_line_rec.top_model_line_id );

Line 1624: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

1620: * of top ato parent. kit can not be under an ATO */
1621:
1622: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1623: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1624: g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
1625:
1626: OE_Order_Cache.Load_Top_Model_Line
1627: (g_line_rec.top_model_line_id );
1628: l_ato_line_id := OE_Order_Cache.g_top_model_line_rec.ato_line_id;

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

1632: IF l_debug_level > 0 THEN
1633: oe_debug_pub.add( 'TOP MODEL IS PTO' , 3 ) ;
1634: END IF;
1635:
1636: IF (g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS AND
1637: l_replenish_to_order_flag = 'Y' AND
1638: l_bom_item_type = 1) THEN
1639:
1640: IF l_debug_level > 0 THEN

Line 1687: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION

1683: ELSE
1684: IF l_debug_level > 0 THEN
1685: oe_debug_pub.add('CONFIG_ITEM_ID NOT RETURNED FROM CZ');
1686: END IF;
1687: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION
1688: AND
1689: l_replenish_to_order_flag = 'Y' AND
1690: l_build_in_wip_flag = 'Y'
1691: THEN

Line 1751: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION

1747: -- should have line_id = ato_line_id, if ato_item is
1748: -- under a ato sub config, its ato_line_id = line_id
1749: -- of the ato sub config.
1750:
1751: IF g_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION
1752: AND
1753: l_replenish_to_order_flag = 'Y' AND
1754: l_build_in_wip_flag = 'Y'
1755: THEN

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

1899: IF l_debug_level > 0 THEN
1900: oe_debug_pub.add( 'ENTERING CHECK ITEM TYPE' ) ;
1901: oe_debug_pub.add( 'ITEM TYPE '|| P_ITEM_TYPE_CODE ) ;
1902: END IF;
1903: IF p_line_rec.operation = oe_globals.g_opr_update THEN
1904: IF (p_old_line_rec.item_type_code <> FND_API.G_MISS_CHAR AND
1905: p_old_line_rec.item_type_code IS NOT NULL) THEN
1906:
1907: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.item_type_code,

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

1903: IF p_line_rec.operation = oe_globals.g_opr_update THEN
1904: IF (p_old_line_rec.item_type_code <> FND_API.G_MISS_CHAR AND
1905: p_old_line_rec.item_type_code IS NOT NULL) THEN
1906:
1907: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.item_type_code,
1908: p_item_type_code) THEN
1909:
1910: FND_MESSAGE.SET_NAME('ONT','OE_ITEM_TYPE_CONST');
1911: OE_MSG_PUB.ADD;

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

1960: RETURN NULL;
1961: END IF;
1962:
1963:
1964: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
1965: RETURN OE_GLOBALS.G_ITEM_STANDARD;
1966: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)
1967: ELSIF p_line_rec.line_category_code = 'ORDER'
1968: and p_line_rec.retrobill_request_id is NOT NULL

Line 1965: RETURN OE_GLOBALS.G_ITEM_STANDARD;

1961: END IF;
1962:
1963:
1964: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
1965: RETURN OE_GLOBALS.G_ITEM_STANDARD;
1966: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)
1967: ELSIF p_line_rec.line_category_code = 'ORDER'
1968: and p_line_rec.retrobill_request_id is NOT NULL
1969: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN

Line 1971: RETURN OE_GLOBALS.G_ITEM_STANDARD;

1967: ELSIF p_line_rec.line_category_code = 'ORDER'
1968: and p_line_rec.retrobill_request_id is NOT NULL
1969: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN
1970:
1971: RETURN OE_GLOBALS.G_ITEM_STANDARD;
1972: --- BUG#6933507
1973: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1974: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
1975: RETURN p_line_rec.item_type_code;

Line 1973: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

1969: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN
1970:
1971: RETURN OE_GLOBALS.G_ITEM_STANDARD;
1972: --- BUG#6933507
1973: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1974: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
1975: RETURN p_line_rec.item_type_code;
1976: END IF;
1977:

Line 1974: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN

1970:
1971: RETURN OE_GLOBALS.G_ITEM_STANDARD;
1972: --- BUG#6933507
1973: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
1974: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
1975: RETURN p_line_rec.item_type_code;
1976: END IF;
1977:
1978:

Line 2004: OE_GLOBALS.G_ITEM_CLASS);

2000: END IF;
2001: --Procedure to check change in item_type_code
2002: Check_Item_Type(p_line_rec,
2003: p_old_line_rec,
2004: OE_GLOBALS.G_ITEM_CLASS);
2005: RETURN OE_GLOBALS.G_ITEM_CLASS;
2006: END IF;
2007:
2008: IF l_debug_level > 0 THEN

Line 2005: RETURN OE_GLOBALS.G_ITEM_CLASS;

2001: --Procedure to check change in item_type_code
2002: Check_Item_Type(p_line_rec,
2003: p_old_line_rec,
2004: OE_GLOBALS.G_ITEM_CLASS);
2005: RETURN OE_GLOBALS.G_ITEM_CLASS;
2006: END IF;
2007:
2008: IF l_debug_level > 0 THEN
2009: oe_debug_pub.add( 'RETURNING MODEL AS THE ITEM TYPE' , 1 ) ;

Line 2014: OE_GLOBALS.G_ITEM_MODEL);

2010: END IF;
2011: --Procedure to check change in item_type_code
2012: Check_Item_Type(p_line_rec,
2013: p_old_line_rec,
2014: OE_GLOBALS.G_ITEM_MODEL);
2015: RETURN OE_GLOBALS.G_ITEM_MODEL;
2016:
2017: ELSIF l_bom_item_type = 2
2018: THEN

Line 2015: RETURN OE_GLOBALS.G_ITEM_MODEL;

2011: --Procedure to check change in item_type_code
2012: Check_Item_Type(p_line_rec,
2013: p_old_line_rec,
2014: OE_GLOBALS.G_ITEM_MODEL);
2015: RETURN OE_GLOBALS.G_ITEM_MODEL;
2016:
2017: ELSIF l_bom_item_type = 2
2018: THEN
2019: IF l_debug_level > 0 THEN

Line 2026: OE_GLOBALS.G_ITEM_CLASS);

2022: -- Only CLASS items have bom_item_type = 2
2023: --Procedure to check change in item_type_code
2024: Check_Item_Type(p_line_rec,
2025: p_old_line_rec,
2026: OE_GLOBALS.G_ITEM_CLASS);
2027: RETURN OE_GLOBALS.G_ITEM_CLASS;
2028:
2029: ELSIF l_bom_item_type = 4 and
2030: l_service_item_flag = 'N'

Line 2027: RETURN OE_GLOBALS.G_ITEM_CLASS;

2023: --Procedure to check change in item_type_code
2024: Check_Item_Type(p_line_rec,
2025: p_old_line_rec,
2026: OE_GLOBALS.G_ITEM_CLASS);
2027: RETURN OE_GLOBALS.G_ITEM_CLASS;
2028:
2029: ELSIF l_bom_item_type = 4 and
2030: l_service_item_flag = 'N'
2031: THEN

Line 2046: l_item_type_code := OE_GLOBALS.G_ITEM_KIT;

2042: -- between a standard and an option item.
2043: -- ato_item's item_type_code will be standard
2044:
2045: IF l_pick_components_flag = 'Y' THEN
2046: l_item_type_code := OE_GLOBALS.G_ITEM_KIT;
2047: ELSIF (g_line_rec.top_model_line_id is not null AND
2048: g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM)
2049: THEN
2050: IF l_debug_level > 0 THEN

Line 2053: l_item_type_code := OE_GLOBALS.G_ITEM_OPTION;

2049: THEN
2050: IF l_debug_level > 0 THEN
2051: oe_debug_pub.add( 'GET_ITEM_TYPE NO DATA FOUND , BOM_ITEM_TYPE : 4' , 1 ) ;
2052: END IF;
2053: l_item_type_code := OE_GLOBALS.G_ITEM_OPTION;
2054: ELSE
2055: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
2056: END IF;
2057:

Line 2055: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

2051: oe_debug_pub.add( 'GET_ITEM_TYPE NO DATA FOUND , BOM_ITEM_TYPE : 4' , 1 ) ;
2052: END IF;
2053: l_item_type_code := OE_GLOBALS.G_ITEM_OPTION;
2054: ELSE
2055: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
2056: END IF;
2057:
2058: IF l_debug_level > 0 THEN
2059: oe_debug_pub.add( ' BEFORE CALLING CHECK 1' ) ;

Line 2076: OE_GLOBALS.G_ITEM_SERVICE);

2072: END IF;
2073: --Procedure to check change in item_type_code
2074: Check_Item_Type(p_line_rec,
2075: p_old_line_rec,
2076: OE_GLOBALS.G_ITEM_SERVICE);
2077: RETURN OE_GLOBALS.G_ITEM_SERVICE;
2078:
2079: END IF;
2080:

Line 2077: RETURN OE_GLOBALS.G_ITEM_SERVICE;

2073: --Procedure to check change in item_type_code
2074: Check_Item_Type(p_line_rec,
2075: p_old_line_rec,
2076: OE_GLOBALS.G_ITEM_SERVICE);
2077: RETURN OE_GLOBALS.G_ITEM_SERVICE;
2078:
2079: END IF;
2080:
2081: RETURN null;

Line 2093: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

2089: WHEN NO_DATA_FOUND THEN
2090: IF l_debug_level > 0 THEN
2091: oe_debug_pub.add( ' BEFORE CALLING CHECK 4' ) ;
2092: END IF;
2093: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
2094: --Procedure to check change in item_type_code
2095: Check_Item_Type(p_line_rec,
2096: p_old_line_rec,
2097: l_item_type_code);

Line 2158: OE_GLOBALS.Set_Context;

2154: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2155: --
2156: BEGIN
2157:
2158: OE_GLOBALS.Set_Context;
2159: l_org_id := OE_GLOBALS.G_ORG_ID;
2160:
2161: RETURN l_Org_Id;
2162:

Line 2159: l_org_id := OE_GLOBALS.G_ORG_ID;

2155: --
2156: BEGIN
2157:
2158: OE_GLOBALS.Set_Context;
2159: l_org_id := OE_GLOBALS.G_ORG_ID;
2160:
2161: RETURN l_Org_Id;
2162:
2163: END Get_Org;

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

2176: oe_debug_pub.add( 'IN DEFAULTING: FUNCTION GET_LINE_CATEGORY' , 1 ) ;
2177: END IF;
2178:
2179: /* replaced with the following IF for 2421909
2180: IF (p_line_rec.operation = oe_globals.g_opr_create) and
2181: (p_line_rec.line_type_id IS NULL OR
2182: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2183: */
2184:

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

2194: OE_ORDER_CACHE.Load_Order_Header(p_line_rec.header_id);
2195: l_order_category := OE_ORDER_CACHE.g_header_rec.ORDER_CATEGORY_CODE;
2196: */
2197:
2198: IF (p_line_rec.operation = oe_globals.g_opr_create)
2199: THEN -- 2421909ND
2200:
2201: IF l_debug_level > 0 THEN
2202: oe_debug_pub.add( 'AK IN DEFAULTING: OPERATION IS CREATE' , 1 ) ;

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

2224: END IF;
2225: --retro{In the case of price increase for original line, the initial
2226: --retrobill line will be created with line_category return and has to be
2227: --updated to order
2228: IF (p_line_rec.operation = oe_globals.g_opr_update AND
2229: p_old_line_rec.line_category_code = 'RETURN' AND
2230: p_line_rec.line_category_code = 'ORDER' AND
2231: p_line_rec.order_source_id = 27 ) THEN
2232: l_category := 'ORDER';

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

2238: IF l_debug_level > 0 THEN
2239: oe_debug_pub.add( 'LINE CATEGORY: ' || L_CATEGORY ) ;
2240: END IF;
2241:
2242: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2243:
2244: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2245: p_old_line_rec.line_category_code IS NOT NULL) THEN
2246:

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

2243:
2244: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2245: p_old_line_rec.line_category_code IS NOT NULL) THEN
2246:
2247: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,
2248: l_category) THEN
2249: --retro{In the case of price increase for original line, the initial
2250: --retrobill line will be created with line_category return and has to be
2251: --updated to order.The original flow doesn't allow and raises exception,To

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

2249: --retro{In the case of price increase for original line, the initial
2250: --retrobill line will be created with line_category return and has to be
2251: --updated to order.The original flow doesn't allow and raises exception,To
2252: --prevent the exception a if loop is added in the case of retrobilling
2253: IF (p_line_rec.operation = oe_globals.g_opr_update AND
2254: p_old_line_rec.line_category_code = 'RETURN' AND
2255: p_line_rec.line_category_code = 'ORDER' AND
2256: p_line_rec.order_source_id = 27 AND
2257: p_line_rec.retrobill_request_id is not null) THEN

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

2282: IF l_debug_level > 0 THEN
2283: oe_debug_pub.add( 'IN DEFAULTING: NO DATAFOUND' , 1 ) ;
2284: END IF;
2285: l_category := 'ORDER';
2286: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2287:
2288: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2289: p_old_line_rec.line_category_code IS NOT NULL) THEN
2290:

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

2287:
2288: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2289: p_old_line_rec.line_category_code IS NOT NULL) THEN
2290:
2291: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,
2292: l_category) THEN
2293: FND_MESSAGE.SET_NAME('ONT', 'OE_LINE_CAT_CONST');
2294: OE_MSG_PUB.ADD;
2295: IF l_debug_level > 0 THEN

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

2513: FUNCTION Get_Source_Type(p_source_type IN VARCHAR2,
2514: p_line_type_id IN NUMBER)
2515: RETURN VARCHAR2
2516: IS
2517: l_source_type VARCHAR2(30) := OE_GLOBALS.G_SOURCE_INTERNAL;
2518: --
2519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2520: --
2521: BEGIN

Line 2539: IF l_source_type <> OE_GLOBALS.G_SOURCE_EXTERNAL AND

2535: IF l_source_type is null THEN
2536: RETURN p_source_type;
2537: END IF;
2538:
2539: IF l_source_type <> OE_GLOBALS.G_SOURCE_EXTERNAL AND
2540: l_source_type <> OE_GLOBALS.G_SOURCE_INTERNAL THEN
2541: l_source_type := p_source_type;
2542: END IF;
2543:

Line 2540: l_source_type <> OE_GLOBALS.G_SOURCE_INTERNAL THEN

2536: RETURN p_source_type;
2537: END IF;
2538:
2539: IF l_source_type <> OE_GLOBALS.G_SOURCE_EXTERNAL AND
2540: l_source_type <> OE_GLOBALS.G_SOURCE_INTERNAL THEN
2541: l_source_type := p_source_type;
2542: END IF;
2543:
2544: EXCEPTION

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

2579: THEN
2580: RETURN NULL;
2581: END IF;
2582:
2583: IF (p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG) THEN
2584: RETURN 'Y';
2585: END IF;
2586:
2587: IF l_debug_level > 0 THEN

Line 2597: IF NOT OE_GLOBALS.Equal(p_item_type_code,

2593: (p_ato_line_id <> FND_API.G_MISS_NUM)
2594: THEN
2595:
2596: -- ##1820608, ato_item can be under a pto model.
2597: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2598: OE_GLOBALS.G_ITEM_STANDARD) AND
2599: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2600: p_line_id = p_ato_line_id )
2601: THEN

Line 2598: OE_GLOBALS.G_ITEM_STANDARD) AND

2594: THEN
2595:
2596: -- ##1820608, ato_item can be under a pto model.
2597: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2598: OE_GLOBALS.G_ITEM_STANDARD) AND
2599: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2600: p_line_id = p_ato_line_id )
2601: THEN
2602:

Line 2599: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND

2595:
2596: -- ##1820608, ato_item can be under a pto model.
2597: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2598: OE_GLOBALS.G_ITEM_STANDARD) AND
2599: NOT (p_item_type_code = OE_GLOBALS.G_ITEM_OPTION AND
2600: p_line_id = p_ato_line_id )
2601: THEN
2602:
2603: IF l_debug_level > 0 THEN

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

3506: p_x_line_rec.ordered_item := l_ref_line_rec.ordered_item ;
3507: p_x_line_rec.inventory_item_id := l_ref_line_rec.inventory_item_id;
3508: p_x_line_rec.item_identifier_type := l_ref_line_rec.item_identifier_type;
3509: p_x_line_rec.ordered_item_id := l_ref_line_rec.ordered_item_id;
3510: p_x_line_rec.item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
3511: ELSE
3512: NULL;
3513: END IF;
3514:

Line 3619: OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' THEN

3615:
3616: IF (p_x_line_rec.pricing_quantity IS NULL OR
3617: p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM) THEN
3618: IF p_x_line_rec.return_context = 'SERIAL' OR
3619: OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' THEN
3620: p_x_line_rec.pricing_quantity_uom :=
3621: l_ref_line_rec.pricing_quantity_uom;
3622: p_x_line_rec.pricing_quantity := OE_Order_Misc_Util.convert_uom(
3623: p_x_line_rec.inventory_item_id,

Line 3953: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2,

3949: IF l_debug_level > 0 THEN
3950: oe_debug_pub.add( 'INSIDE DEFAULTING RMA' , 1 ) ;
3951: oe_debug_pub.add( 'RMA OPERATION IS'||P_X_LINE_REC.OPERATION , 1 ) ;
3952: END IF;
3953: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2,
3954: p_old_line_rec.return_attribute2)
3955: THEN
3956: IF l_debug_level > 0 THEN
3957: oe_debug_pub.add( 'CLEARING RMA_ATTRIBUTES' , 1 ) ;

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

4045: oe_debug_pub.add( ' p_x_line_rec.ordered_quantity = '|| p_x_line_rec.ordered_quantity,5 ) ;
4046: END IF;
4047:
4048:
4049: IF OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' OR NOT (OE_GLOBALS.G_UI_FLAG) THEN
4050: --p_x_line_rec.ordered_quantity := l_line_rec.ordered_quantity; -- bug# 6617423
4051:
4052: -- bug# 6617423 : start
4053: oe_debug_pub.add( ' p_x_line_rec.org_id = '|| p_x_line_rec.org_id , 5 ) ;

Line 4083: OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y'

4079: p_x_line_rec.order_source_id := 2;
4080: END IF;
4081:
4082: IF p_x_line_rec.source_document_type_id = 2 OR
4083: OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y'
4084: THEN
4085: p_x_line_rec.calculate_price_flag := l_line_rec.calculate_price_flag;
4086: p_x_line_rec.pricing_date := l_line_rec.pricing_date;
4087: IF l_debug_level > 0 THEN

Line 4097: IF NOT (OE_GLOBALS.G_UI_FLAG)

4093:
4094: -- Fix for the issue 2347377. Retain the flex values if sent in
4095: -- by NON-UI call like (OrderImport) / COPY.
4096:
4097: IF NOT (OE_GLOBALS.G_UI_FLAG)
4098: THEN
4099: IF l_debug_level > 0 THEN
4100: oe_debug_pub.add('Context is' ||P_X_LINE_REC.context);
4101: oe_debug_pub.add('Attribute 1 is : '||P_X_LINE_REC.attribute1);

Line 4247: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2,

4243:
4244: IF l_debug_level > 0 THEN
4245: oe_debug_pub.add( 'IN DEFAULT RETURN ATTRIBUTES -1' , 1 ) ;
4246: END IF;
4247: IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2,
4248: p_old_line_rec.return_attribute2)
4249: THEN
4250:
4251: -- Get the values of l_currency_code and l_sold_to_org_id

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

4317: p_x_line_rec.actual_shipment_date := NULL;
4318: -- source type code for RMA lines will always be set to internal. If
4319: -- in future we plan to change the design then please comment out the
4320: -- following code.
4321: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
4322:
4323: p_x_line_rec.over_ship_reason_code := NULL;
4324: p_x_line_rec.over_ship_resolved_flag := NULL;
4325: p_x_line_rec.shipping_interfaced_flag := NULL;

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

4333: -- CAll OE_Validate_Line.Attributes
4334: OE_Validate_Line.Attributes(
4335: x_return_status => l_return_status
4336: , p_x_line_rec => p_x_line_rec
4337: , p_validation_level => OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF);
4338:
4339: IF l_debug_level > 0 THEN
4340: oe_debug_pub.add( 'THE ORDERED QTY IS '||P_X_LINE_REC.ORDERED_QUANTITY ) ;
4341: oe_debug_pub.add( 'THE PRICING QTY IS '||P_X_LINE_REC.PRICING_QUANTITY ) ;

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

4379: END IF;
4380: fnd_profile.get('ONT_IMP_MULTIPLE_SHIPMENTS', g_multiple_shipments);
4381: g_multiple_shipments := nvl(g_multiple_shipments, 'NO');
4382:
4383: /* IF (p_x_line_rec.operation = oe_globals.g_opr_create and */
4384: IF p_x_line_rec.return_context is NOT NULL AND
4385: p_x_line_rec.return_context <> FND_API.G_MISS_CHAR THEN
4386: Return_Attributes
4387: ( p_x_line_rec => p_x_line_rec

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

4413: -- get item_type is dependent on get_top_model
4414: -- get ato_line , get_shippbale etc are dependent on get_item_type
4415: -- please do not changes their sequence.
4416:
4417: IF g_line_rec.operation = oe_globals.g_opr_create THEN
4418: g_line_rec.org_id := Get_Org;
4419:
4420: -- QUOTING change
4421: -- Initialize flow status to DRAFT for lines in negotiation phase

Line 4470: ELSIF g_line_rec.operation = oe_globals.g_opr_update

4466:
4467: /* Added for the BUG #3257965.
4468: For update operation need to raise an error for line_category_code. */
4469:
4470: ELSIF g_line_rec.operation = oe_globals.g_opr_update
4471: AND NOT OE_GLOBALS.EQUAL(g_line_rec.line_category_code
4472: ,p_old_line_rec.line_category_code)
4473: THEN
4474: --3365705For retrobill we change the order type from return to order

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

4467: /* Added for the BUG #3257965.
4468: For update operation need to raise an error for line_category_code. */
4469:
4470: ELSIF g_line_rec.operation = oe_globals.g_opr_update
4471: AND NOT OE_GLOBALS.EQUAL(g_line_rec.line_category_code
4472: ,p_old_line_rec.line_category_code)
4473: THEN
4474: --3365705For retrobill we change the order type from return to order
4475: -- and the exception shouldn't be raised

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

4490:
4491: -- BUG 3646340: Return_reason is a defaultable field and it needs to be
4492: -- defaulted if the line category changes to RETURN.
4493:
4494: IF g_line_rec.operation = oe_globals.g_opr_create AND
4495: g_line_rec.line_category_code = 'RETURN' AND
4496: g_line_rec.return_reason_code IS NULL AND
4497: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4498: p_old_line_rec.line_category_code)

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

4493:
4494: IF g_line_rec.operation = oe_globals.g_opr_create AND
4495: g_line_rec.line_category_code = 'RETURN' AND
4496: g_line_rec.return_reason_code IS NULL AND
4497: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4498: p_old_line_rec.line_category_code)
4499: THEN
4500: IF l_debug_level > 0 THEN
4501: oe_debug_pub.add('LINE CATEGORY CHANGED - REASON set to miss') ;

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

4503: g_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
4504: END IF;
4505:
4506: IF g_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
4507: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4508: p_old_line_rec.line_category_code)
4509: THEN
4510: g_line_rec.top_model_line_id := Get_Top_Model_Line;
4511: END IF;

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

4517: IF l_debug_level > 0 THEN
4518: oe_debug_pub.add( 'BEFORE ITEM_TYPE' ) ;
4519: END IF;
4520: IF g_line_rec.item_type_code = FND_API.G_MISS_CHAR
4521: or NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4522: p_old_line_rec.line_category_code)
4523: THEN
4524: g_line_rec.item_type_code :=
4525: Get_Item_Type(g_line_rec, p_old_line_rec);

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

4529: -- we are not checking for miss_char, because there is
4530: -- no clear_dep for smc_flag. and we don ot want to
4531: -- do that because of the way options defaulting work.
4532:
4533: IF NOT OE_GLOBALS.Equal(p_old_line_rec.inventory_item_id,
4534: g_line_rec.inventory_item_id) THEN
4535: IF l_debug_level > 0 THEN
4536: oe_debug_pub.add( 'CALLING GET_SMC' , 3 ) ;
4537: END IF;

Line 4554: g_line_rec.operation = OE_GLOBALS.G_OPR_CREATE

4550: -- get_item_type and get_smc_flag
4551:
4552: IF (g_line_rec.item_type_code <> FND_API.G_MISS_CHAR OR
4553: g_line_rec.item_type_code is not null) AND
4554: g_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
4555: THEN
4556: model_option_defaulting;
4557: END IF;
4558:

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

4557: END IF;
4558:
4559: IF (g_line_rec.line_id = FND_API.G_MISS_NUM) OR
4560: (g_line_rec.line_id IS NULL) THEN
4561: g_line_rec.org_id := OE_GLOBALS.G_ORG_ID;
4562: END IF;
4563:
4564: IF g_line_rec.booked_flag = FND_API.G_MISS_CHAR THEN
4565: g_line_rec.booked_flag := Get_Booked;

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

4643: -- Fixed bug 1206047: if user provides a value for the customer (sold_to)
4644: -- then override it with the value of sold_to from the header
4645: -- For the initial release, customer should be common on all lines of
4646: -- an order.
4647: IF NOT OE_GLOBALS.EQUAL( g_line_rec.sold_to_org_id
4648: ,p_old_line_rec.sold_to_org_id )
4649: THEN
4650: g_line_rec.sold_to_org_id := Get_Sold_To;
4651: END IF;

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

4660: IF nvl(g_line_rec.top_model_line_id,0) <> nvl(g_line_rec.ato_line_id,0) AND
4661: g_line_rec.top_model_line_id IS NOT NULL THEN
4662:
4663: /* Change for bug 2276993 */
4664: --p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4665:
4666: IF g_line_rec.ship_tolerance_below IS NULL OR
4667: g_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM OR
4668: g_line_rec.ship_tolerance_below = p_old_Line_rec.ship_tolerance_below THEN

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

4715:
4716: --Perform blanket defaulting
4717: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4718:
4719: IF ( l_in_rec.operation = OE_GLOBALS.G_OPR_CREATE -- 7152122
4720: AND trunc( l_in_rec.request_date ) <> trunc(l_in_old_rec.request_date)
4721: AND l_in_rec.blanket_line_number IS NOT NULL )THEN
4722: l_in_rec.blanket_line_number := FND_API.G_MISS_NUM;
4723: END IF;

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

4788: -- More blanket defaulting
4789: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4790:
4791: IF l_rec.blanket_number IS NOT NULL
4792: AND (NOT OE_GLOBALS.EQUAL(l_in_rec.blanket_number,l_rec.blanket_number)
4793: OR trunc(l_blanket_request_date) <> trunc(l_rec.request_date)
4794: )
4795: THEN
4796:

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

4829:
4830: IF p_x_line_rec.agreement_id IS NOT NULL AND
4831: p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN
4832:
4833: IF NOT oe_globals.equal(p_x_line_rec.pricing_date,
4834: p_old_line_rec.pricing_date)
4835: OR
4836: not oe_globals.equal(p_x_line_rec.agreement_id,
4837: p_old_line_rec.agreement_id) THEN

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

4832:
4833: IF NOT oe_globals.equal(p_x_line_rec.pricing_date,
4834: p_old_line_rec.pricing_date)
4835: OR
4836: not oe_globals.equal(p_x_line_rec.agreement_id,
4837: p_old_line_rec.agreement_id) THEN
4838:
4839: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4840: Default_Active_Agr_Revision

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

4835: OR
4836: not oe_globals.equal(p_x_line_rec.agreement_id,
4837: p_old_line_rec.agreement_id) THEN
4838:
4839: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4840: Default_Active_Agr_Revision
4841: ( p_x_line_rec => p_x_line_rec,
4842: p_old_line_rec => p_old_line_rec);
4843: END IF;

Line 4921: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

4917: oe_debug_pub.add(' Ordered UOM '|| p_x_line_rec.order_quantity_uom,1);
4918: oe_debug_pub.add( ' Pricing Qty is not equal to Ord Qty and P_UOM is not populated' , 1 ) ;
4919: END IF;
4920:
4921: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4922: --Added the message after review.
4923: FND_MESSAGE.SET_NAME('ONT', 'ONT_INVALID_ORD_QTY_PRC_QTY');
4924: OE_MSG_PUB.Add;
4925: RAISE FND_API.G_EXC_ERROR;

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

5217: END IF;
5218:
5219: IF p_x_line_rec.source_type_code is null OR
5220: p_x_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN
5221: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5222: END IF;
5223:
5224: -- Bug 5708174
5225: IF p_x_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN

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

5221: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5222: END IF;
5223:
5224: -- Bug 5708174
5225: IF p_x_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL THEN
5226: p_x_line_rec.subinventory := NULL;
5227: END IF;
5228: -- Added to fix the issue in bug 2894486
5229: IF p_x_line_rec.line_category_code = 'RETURN' THEN

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

5226: p_x_line_rec.subinventory := NULL;
5227: END IF;
5228: -- Added to fix the issue in bug 2894486
5229: IF p_x_line_rec.line_category_code = 'RETURN' THEN
5230: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5231: p_x_line_rec.ato_line_id := NULL;
5232: END IF;
5233:
5234: -- Bug 5331971, internal orders shall not be externally sourced

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

5232: END IF;
5233:
5234: -- Bug 5331971, internal orders shall not be externally sourced
5235: IF p_x_line_rec.order_source_id = 10 THEN
5236: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5237: END IF;
5238:
5239: -- This is the new condition aksingh changed on 04/22/01
5240: IF NOT OE_GLOBALS.Equal(p_x_line_rec.request_date,

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

5236: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5237: END IF;
5238:
5239: -- This is the new condition aksingh changed on 04/22/01
5240: IF NOT OE_GLOBALS.Equal(p_x_line_rec.request_date,
5241: p_old_line_rec.request_date)
5242: THEN
5243: IF l_debug_level > 0 THEN
5244: oe_debug_pub.add( 'OEXDLINB -1- CHECK FOR G_MISS_DATE FOR REQUEST ' ) ;

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

5247: -- aksingh added this if for the bug 1745501
5248: IF l_debug_level > 0 THEN
5249: oe_debug_pub.add( 'OEXDLINB -2- CHECK FOR G_MISS_DATE FOR LATEST ' ) ;
5250: END IF;
5251: IF OE_GLOBALS.Equal(p_x_line_rec.latest_acceptable_date,
5252: p_old_line_rec.latest_acceptable_date)
5253: OR p_x_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE
5254: THEN
5255: IF l_debug_level > 0 THEN

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

5341: END IF;
5342:
5343: /* The following lines are commented to fix the bug 1409036 */
5344: /*
5345: IF NOT OE_GLOBALS.Equal(p_x_line_rec.line_type_id,
5346: p_old_line_rec.line_type_id)
5347: THEN
5348: p_x_line_rec.source_type_code :=
5349: Get_Source_Type(p_source_type => p_x_line_rec.source_type_code,

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

5368: ,p_item_type_code => p_x_line_rec.item_type_code );
5369: END IF;
5370:
5371: IF p_x_line_rec.schedule_status_code is null
5372: AND NOT OE_GLOBALS.Equal(p_old_line_rec.ship_from_org_id,
5373: p_x_line_rec.ship_from_org_id) THEN
5374: IF p_x_line_rec.ship_from_org_id is not null
5375: THEN
5376: IF l_debug_level > 0 THEN

Line 5413: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE

5409: END IF;
5410: END IF;
5411:
5412:
5413: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
5414: THEN
5415: model_option_update (p_x_line_rec => p_x_line_rec);
5416: END IF;
5417:

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

5420: IF nvl(p_x_line_rec.top_model_line_id,0) <> nvl(p_x_line_rec.ato_line_id,0) AND
5421: p_x_line_rec.top_model_line_id IS NOT NULL THEN
5422:
5423: /* Change for bug 2276993 */
5424: --p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
5425:
5426: /* Fix for bug 2420456 */
5427: IF l_set_tolerance_below = 'Y' THEN
5428:

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

5457: END IF;
5458:
5459: -- to clear out user_item_description if item changes
5460: -- and user_item_description is not changing.
5461: IF NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,
5462: p_old_line_rec.inventory_item_id)
5463: AND OE_GLOBALS.Equal(p_x_line_rec.user_item_description,
5464: p_old_line_rec.user_item_description)
5465: AND p_old_line_rec.user_item_description IS NOT NULL THEN

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

5459: -- to clear out user_item_description if item changes
5460: -- and user_item_description is not changing.
5461: IF NOT OE_GLOBALS.Equal(p_x_line_rec.inventory_item_id,
5462: p_old_line_rec.inventory_item_id)
5463: AND OE_GLOBALS.Equal(p_x_line_rec.user_item_description,
5464: p_old_line_rec.user_item_description)
5465: AND p_old_line_rec.user_item_description IS NOT NULL THEN
5466:
5467: p_x_line_rec.user_item_description := NULL;