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_VALIDATE_LINE dependencies on OE_ORDER_CACHE

Line 258: --l_line_type_rec OE_Order_Cache.Line_Type_Rec_Type;

254: IS
255: l_proj_ref_enabled NUMBER;
256: l_proj_control_level NUMBER;
257: l_calculate_tax_flag VARCHAR2(1) := 'N';
258: --l_line_type_rec OE_Order_Cache.Line_Type_Rec_Type;
259: l_item_type_code VARCHAR2(30);
260: l_revision_controlled VARCHAR2(1);
261: l_rule_type VARCHAR2(10);
262: l_tax_calculation_event_code VARCHAR2(30);

Line 266: l_cust_trx_rec_type OE_ORDER_CACHE.cust_trx_rec_type;

262: l_tax_calculation_event_code VARCHAR2(30);
263: --key Transaction Dates
264: l_hdr_booked_date DATE ;
265: l_cust_trx_type_id NUMBER := 0;
266: l_cust_trx_rec_type OE_ORDER_CACHE.cust_trx_rec_type;
267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269:
270: IF l_debug_level > 0 then

Line 556: l_cust_trx_rec_type := OE_ORDER_CACHE.Load_Cust_Trx_Type(l_cust_Trx_type_id);

552: oe_debug_pub.add( 'value of customer trx type id '||l_cust_trx_type_id,1);
553: END IF;
554:
555: IF l_cust_trx_type_id IS NOT NULL AND l_cust_trx_type_id <> 0 THEN
556: l_cust_trx_rec_type := OE_ORDER_CACHE.Load_Cust_Trx_Type(l_cust_Trx_type_id);
557: l_calculate_tax_flag := l_cust_trx_rec_type.tax_calculation_flag;
558: END IF;
559:
560: IF l_debug_level > 0 THEN

Line 566: -- l_line_type_rec := OE_Order_Cache.Load_Line_Type(p_line_rec.line_type_id);

562: END IF;
563:
564: -- end bug#5462464
565:
566: -- l_line_type_rec := OE_Order_Cache.Load_Line_Type(p_line_rec.line_type_id);
567:
568: -- fix for bug 1701388 - commented the following code
569: -- Fix bug#1098412: check for calculate tax flag ONLY if receivable
570: -- transaction type EXISTS on the line type

Line 590: = OE_Order_Cache.g_header_rec.order_type_id;

586: SELECT TAX_CALCULATION_EVENT_CODE
587: INTO l_tax_calculation_event_code
588: FROM oe_transaction_types_all
589: WHERE transaction_type_id
590: = OE_Order_Cache.g_header_rec.order_type_id;
591:
592: IF nvl(l_tax_calculation_event_code, 'ENTERING') IN ('ENTERING', 'BOOKING') THEN
593:
594: x_return_status := FND_API.G_RET_STS_ERROR;

Line 667: l_hdr_booked_date := oe_order_cache.g_header_rec.booked_date ;

663:
664: END IF;
665:
666: --key Transaction dates
667: l_hdr_booked_date := oe_order_cache.g_header_rec.booked_date ;
668: IF l_hdr_booked_date = FND_API.G_MISS_DATE or l_hdr_booked_date IS NULL THEN
669: l_hdr_booked_date := sysdate ;
670: END IF ;
671:

Line 1734: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND

1730: -- Item is BUY item
1731: IF(NOT OE_GLOBALS.G_UI_FLAG) THEN
1732:
1733: --changes for bug 4171642
1734: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1735: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1736: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1737: THEN
1738: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then

Line 1735: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND

1731: IF(NOT OE_GLOBALS.G_UI_FLAG) THEN
1732:
1733: --changes for bug 4171642
1734: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1735: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1736: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1737: THEN
1738: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1739: l_dummy := 'VALID';

Line 1736: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)

1732:
1733: --changes for bug 4171642
1734: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1735: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1736: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1737: THEN
1738: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1739: l_dummy := 'VALID';
1740: else

Line 1738: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then

1734: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1735: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1736: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1737: THEN
1738: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1739: l_dummy := 'VALID';
1740: else
1741: RAISE NO_DATA_FOUND ;
1742: end if;

Line 1744: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;

1740: else
1741: RAISE NO_DATA_FOUND ;
1742: end if;
1743: ELSE
1744: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;
1745: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then
1746: l_dummy := 'VALID';
1747: else
1748: Raise No_Data_Found ;

Line 1745: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then

1741: RAISE NO_DATA_FOUND ;
1742: end if;
1743: ELSE
1744: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;
1745: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then
1746: l_dummy := 'VALID';
1747: else
1748: Raise No_Data_Found ;
1749: end if ;

Line 1764: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND

1760: END IF;
1761: ELSE /* Item is get or free item */
1762:
1763: --changes for bug 3975762
1764: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1765: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1766: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1767: THEN
1768: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then

Line 1765: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND

1761: ELSE /* Item is get or free item */
1762:
1763: --changes for bug 3975762
1764: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1765: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1766: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1767: THEN
1768: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1769: l_dummy := 'VALID';

Line 1766: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)

1762:
1763: --changes for bug 3975762
1764: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1765: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1766: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1767: THEN
1768: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1769: l_dummy := 'VALID';
1770: else

Line 1768: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then

1764: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1765: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1766: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1767: THEN
1768: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1769: l_dummy := 'VALID';
1770: else
1771: RAISE NO_DATA_FOUND ;
1772: end if ;

Line 1774: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;

1770: else
1771: RAISE NO_DATA_FOUND ;
1772: end if ;
1773: ELSE
1774: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;
1775: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then
1776: l_dummy := 'VALID';
1777: else
1778: Raise No_Data_Found ;

Line 1775: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then

1771: RAISE NO_DATA_FOUND ;
1772: end if ;
1773: ELSE
1774: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;
1775: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then
1776: l_dummy := 'VALID';
1777: else
1778: Raise No_Data_Found ;
1779: end if ;

Line 2046: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND

2042: IF l_debug_level > 0 then
2043: oe_debug_pub.add('Entering Validate_Return_Item',1);
2044: END IF;
2045: -- bug 4171642
2046: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2047: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND
2048: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2049: THEN
2050: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');

Line 2047: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND

2043: oe_debug_pub.add('Entering Validate_Return_Item',1);
2044: END IF;
2045: -- bug 4171642
2046: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2047: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND
2048: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2049: THEN
2050: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2051: ELSE

Line 2048: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)

2044: END IF;
2045: -- bug 4171642
2046: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2047: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND
2048: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2049: THEN
2050: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2051: ELSE
2052: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,

Line 2050: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');

2046: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2047: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND
2048: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2049: THEN
2050: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2051: ELSE
2052: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,
2053: p_key2 => p_ship_from_org_id );
2054: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');

Line 2052: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,

2048: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2049: THEN
2050: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2051: ELSE
2052: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,
2053: p_key2 => p_ship_from_org_id );
2054: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2055: END IF ;
2056: /*

Line 2054: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');

2050: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2051: ELSE
2052: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,
2053: p_key2 => p_ship_from_org_id );
2054: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2055: END IF ;
2056: /*
2057: SELECT nvl(returnable_flag,'Y')
2058: INTO l_returnable_flag

Line 3684: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM

3680: l_validate_result VARCHAR2(1):='Y';
3681: --MC End
3682: /*OPM 02/JUN/00 BEGIN
3683: ====================*/
3684: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM
3685: --l_OPM_UOM VARCHAR2(4); --OPM 06/22 --INVCONV
3686: l_status VARCHAR2(1); --OPM 06/22
3687: l_msg_count NUMBER;
3688: l_msg_data VARCHAR2(2000);

Line 3803: l_price_list_rec OE_ORDER_CACHE.Price_List_Rec_Type ;

3799: and acct_site.cust_account_id = cust_acct.cust_account_id;
3800:
3801: -- end eBTax changes
3802: --added for bug 4200055
3803: l_price_list_rec OE_ORDER_CACHE.Price_List_Rec_Type ;
3804: --PP Revenue Recognition
3805: --bug 4893057
3806: l_rule_type VARCHAR2(10);
3807:

Line 3818: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);

3814: THEN
3815: IF l_debug_level > 0 then
3816: oe_debug_pub.add('Header has got created in the same call',1);
3817: END IF;
3818: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
3819: l_header_created := TRUE;
3820: END IF;
3821:
3822: -----------------------------------------------------------

Line 4063: if (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM

4059: END IF;
4060: /* fix bug 2570174, check for restricted subinv */
4061: BEGIN
4062: -- bug 4171642
4063: if (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM
4064: AND
4065: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4066: AND
4067: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)

Line 4065: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id

4061: BEGIN
4062: -- bug 4171642
4063: if (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM
4064: AND
4065: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4066: AND
4067: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)
4068: THEN
4069: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;

Line 4067: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)

4063: if (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM
4064: AND
4065: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4066: AND
4067: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)
4068: THEN
4069: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4070: else
4071: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,

Line 4069: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;

4065: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4066: AND
4067: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)
4068: THEN
4069: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4070: else
4071: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4072: p_key2 => p_line_rec.ship_from_org_id );
4073: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id

Line 4071: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,

4067: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)
4068: THEN
4069: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4070: else
4071: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4072: p_key2 => p_line_rec.ship_from_org_id );
4073: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4074: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN
4075: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;

Line 4073: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id

4069: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4070: else
4071: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4072: p_key2 => p_line_rec.ship_from_org_id );
4073: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4074: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN
4075: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4076: else
4077: l_restrict_subinv := 0;

Line 4074: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN

4070: else
4071: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4072: p_key2 => p_line_rec.ship_from_org_id );
4073: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4074: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN
4075: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4076: else
4077: l_restrict_subinv := 0;
4078: end if ;

Line 4075: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;

4071: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4072: p_key2 => p_line_rec.ship_from_org_id );
4073: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4074: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN
4075: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4076: else
4077: l_restrict_subinv := 0;
4078: end if ;
4079: end if ;

Line 5289: (OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))

5285:
5286: -- Validation of Ship To Org Id.
5287: IF p_line_rec.ship_to_org_id IS NOT NULL
5288: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5289: (OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))
5290: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id
5291: ,p_old_line_rec.ship_to_org_id)
5292: OR NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id
5293: ,p_old_line_rec.sold_to_org_id))

Line 5322: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_contact_id, p_line_rec.ship_to_contact_id)

5318:
5319: -- Ship to contact depends on Ship To Org
5320: IF p_line_rec.ship_to_contact_id IS NOT NULL
5321: AND NOT (l_header_created
5322: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_contact_id, p_line_rec.ship_to_contact_id)
5323: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))
5324: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id)
5325: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id))
5326: --Bug 5679739 AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id)

Line 5323: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))

5319: -- Ship to contact depends on Ship To Org
5320: IF p_line_rec.ship_to_contact_id IS NOT NULL
5321: AND NOT (l_header_created
5322: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_contact_id, p_line_rec.ship_to_contact_id)
5323: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))
5324: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id)
5325: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id))
5326: --Bug 5679739 AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id)
5327: THEN

Line 5326: --Bug 5679739 AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id)

5322: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_contact_id, p_line_rec.ship_to_contact_id)
5323: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))
5324: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id)
5325: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id))
5326: --Bug 5679739 AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id)
5327: THEN
5328:
5329: BEGIN
5330: IF l_debug_level > 0 then

Line 5382: (OE_Order_Cache.g_header_rec.deliver_to_org_id,

5378:
5379: -- Validation of Deliver To Org Id.
5380: IF p_line_rec.deliver_to_org_id IS NOT NULL
5381: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5382: (OE_Order_Cache.g_header_rec.deliver_to_org_id,
5383: p_line_rec.deliver_to_org_id))
5384: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id
5385: ,p_old_line_rec.deliver_to_org_id)
5386: OR NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id

Line 5413: (OE_Order_Cache.g_header_rec.deliver_to_org_id,

5409:
5410: -- Deliver to contact depends on Deliver To Org
5411: IF p_line_rec.deliver_to_contact_id IS NOT NULL
5412: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5413: (OE_Order_Cache.g_header_rec.deliver_to_org_id,
5414: p_line_rec.deliver_to_org_id) AND OE_GLOBALS.EQUAL
5415: (OE_Order_Cache.g_header_rec.deliver_to_contact_id,
5416: p_line_rec.deliver_to_contact_id))
5417: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_contact_id

Line 5415: (OE_Order_Cache.g_header_rec.deliver_to_contact_id,

5411: IF p_line_rec.deliver_to_contact_id IS NOT NULL
5412: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5413: (OE_Order_Cache.g_header_rec.deliver_to_org_id,
5414: p_line_rec.deliver_to_org_id) AND OE_GLOBALS.EQUAL
5415: (OE_Order_Cache.g_header_rec.deliver_to_contact_id,
5416: p_line_rec.deliver_to_contact_id))
5417: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_contact_id
5418: ,p_old_line_rec.deliver_to_contact_id)
5419: OR NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id

Line 5475: (OE_Order_Cache.g_header_rec.invoice_to_org_id,

5471:
5472: -- Validation of Invoice To Org Id.
5473: IF p_line_rec.invoice_to_org_id IS NOT NULL
5474: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5475: (OE_Order_Cache.g_header_rec.invoice_to_org_id,
5476: p_line_rec.invoice_to_org_id))
5477: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id
5478: ,p_old_line_rec.invoice_to_org_id)
5479: OR NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id

Line 5568: (OE_Order_Cache.g_header_rec.invoice_to_contact_id,

5564: -- Validation of Invoice To Contact Id.
5565: IF p_line_rec.invoice_to_contact_id IS NOT NULL
5566: AND p_line_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM
5567: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5568: (OE_Order_Cache.g_header_rec.invoice_to_contact_id,
5569: p_line_rec.invoice_to_contact_id))
5570: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id
5571: ,p_old_line_rec.invoice_to_contact_id)
5572: OR NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id

Line 5932: IF ((OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)

5928: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG)
5929: THEN
5930: BEGIN
5931: -- bug 4171642
5932: IF ((OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
5933: AND
5934: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)
5935: AND
5936: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN

Line 5934: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)

5930: BEGIN
5931: -- bug 4171642
5932: IF ((OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
5933: AND
5934: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)
5935: AND
5936: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
5937: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5938: ELSE

Line 5936: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN

5932: IF ((OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
5933: AND
5934: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)
5935: AND
5936: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
5937: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5938: ELSE
5939: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );
5940: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;

Line 5937: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;

5933: AND
5934: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)
5935: AND
5936: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
5937: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5938: ELSE
5939: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );
5940: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5941: END IF ;

Line 5939: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );

5935: AND
5936: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
5937: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5938: ELSE
5939: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );
5940: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5941: END IF ;
5942: /*SELECT primary_uom_code
5943: INTO l_uom

Line 5940: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;

5936: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
5937: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5938: ELSE
5939: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );
5940: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
5941: END IF ;
5942: /*SELECT primary_uom_code
5943: INTO l_uom
5944: FROM mtl_system_items_b

Line 6152: l_hdr_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;

6148: if p_line_rec.cancelled_flag <> 'Y' and
6149: p_line_rec.calculate_price_flag not in ('P','N') Then
6150: BEGIN
6151: --
6152: l_hdr_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
6153:
6154: --fix a problem in which for some rare cases in which cachce has a null of transactional_curr_code
6155: If nvl(l_hdr_currency_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR Then
6156: Select transactional_curr_code

Line 6244: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_line_rec.price_list_id) ;

6240: -- modified by lkxu: to select from qp_list_headers_vl instead
6241: -- of from qp_price_lists_v to select only PRL type list headers.
6242:
6243: --use cache instead of sql for bug 4200055
6244: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_line_rec.price_list_id) ;
6245: IF ( l_price_list_rec.price_list_id <> FND_API.G_MISS_NUM
6246: AND l_price_list_rec.price_list_id IS NOT NULL
6247: AND l_price_list_rec.price_list_id = p_line_rec.price_list_id ) THEN
6248: if (

Line 6466: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);

6462: THEN
6463:
6464: -- Fixed bug 1949756: validate line level cust po number
6465: -- only if it is different from header cust po number
6466: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
6467: IF NOT OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.cust_po_number,
6468: p_line_rec.cust_po_number)
6469: AND OE_Validate_Header.Is_Duplicate_PO_Number
6470: (p_line_rec.cust_po_number

Line 6467: IF NOT OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.cust_po_number,

6463:
6464: -- Fixed bug 1949756: validate line level cust po number
6465: -- only if it is different from header cust po number
6466: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
6467: IF NOT OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.cust_po_number,
6468: p_line_rec.cust_po_number)
6469: AND OE_Validate_Header.Is_Duplicate_PO_Number
6470: (p_line_rec.cust_po_number
6471: ,p_line_rec.sold_to_org_id

Line 6557: l_hdr_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;

6553:
6554: IF l_debug_level > 0 then
6555: OE_DEBUG_PUB.ADD('l_hdr_currency_code1:' || l_hdr_currency_code,2);
6556: END IF;
6557: l_hdr_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
6558: Validate_Commitment(
6559: p_line_rec => p_line_rec
6560: , p_hdr_currency_code => l_hdr_currency_code
6561: , p_ota_line => l_is_ota_line

Line 7184: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null

7180: -- no validation for SOLD_TO
7181: -- since no line level sold_to_site_use_id
7182: -- REMOVE after LOV is fixed
7183: ELSIF p_line_rec.ib_installed_at_location = 'SOLD_TO'
7184: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7185: THEN
7186: l_return_status := FND_API.G_RET_STS_ERROR;
7187: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

Line 7247: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null

7243: -- no validation for SOLD_TO
7244: -- since no line level sold_to_site_use_id
7245: -- REMOVE after LOV is fixed
7246: ELSIF p_line_rec.ib_current_location = 'SOLD_TO'
7247: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7248: THEN
7249: l_return_status := FND_API.G_RET_STS_ERROR;
7250: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

Line 7745: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);

7741: THEN
7742: IF l_debug_level > 0 then
7743: oe_debug_pub.add('Header has got created in the same call',1);
7744: END IF;
7745: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
7746: l_header_created := TRUE;
7747: END IF;
7748:
7749: -- Validate line attributes

Line 7759: OE_Order_Cache.g_header_rec.accounting_rule_id ))

7755: THEN
7756: IF NOT(l_header_created) OR
7757: (l_header_created AND
7758: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_id,
7759: OE_Order_Cache.g_header_rec.accounting_rule_id ))
7760: THEN
7761: IF l_debug_level > 0 then
7762: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
7763: END IF;

Line 7787: OE_Order_Cache.g_header_rec.accounting_rule_duration ))

7783: THEN
7784: IF NOT(l_header_created) OR
7785: (l_header_created AND
7786: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_duration,
7787: OE_Order_Cache.g_header_rec.accounting_rule_duration ))
7788: THEN
7789: IF l_debug_level > 0 then
7790: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule_duration',1);
7791: END IF;

Line 7815: OE_Order_Cache.g_header_rec.agreement_id ))

7811: THEN
7812: IF NOT(l_header_created) OR
7813: (l_header_created AND
7814: NOT OE_GLOBALS.EQUAL(p_x_line_rec.agreement_id,
7815: OE_Order_Cache.g_header_rec.agreement_id ))
7816: THEN
7817:
7818: IF NOT OE_Validate.Agreement(p_x_line_rec.agreement_id) THEN
7819: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 7842: OE_Order_Cache.g_header_rec.deliver_to_contact_id ))

7838: THEN
7839: IF NOT(l_header_created) OR
7840: (l_header_created AND
7841: NOT OE_GLOBALS.EQUAL(p_x_line_rec.deliver_to_contact_id,
7842: OE_Order_Cache.g_header_rec.deliver_to_contact_id ))
7843: THEN
7844:
7845: IF NOT OE_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
7846: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 7869: OE_Order_Cache.g_header_rec.deliver_to_org_id ))

7865: THEN
7866: IF NOT(l_header_created) OR
7867: (l_header_created AND
7868: NOT OE_GLOBALS.EQUAL(p_x_line_rec.deliver_to_org_id,
7869: OE_Order_Cache.g_header_rec.deliver_to_org_id ))
7870: THEN
7871:
7872: IF NOT OE_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
7873: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 7896: OE_Order_Cache.g_header_rec.demand_class_code ))

7892: THEN
7893: IF NOT(l_header_created) OR
7894: (l_header_created AND
7895: NOT OE_GLOBALS.EQUAL(p_x_line_rec.demand_class_code,
7896: OE_Order_Cache.g_header_rec.demand_class_code ))
7897: THEN
7898:
7899: IF NOT OE_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
7900: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 7958: OE_Order_Cache.g_header_rec.fob_point_code ))

7954: THEN
7955: IF NOT(l_header_created) OR
7956: (l_header_created AND
7957: NOT OE_GLOBALS.EQUAL(p_x_line_rec.fob_point_code,
7958: OE_Order_Cache.g_header_rec.fob_point_code ))
7959: THEN
7960:
7961: IF NOT OE_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
7962: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 7984: OE_Order_Cache.g_header_rec.freight_terms_code ))

7980: THEN
7981: IF NOT(l_header_created) OR
7982: (l_header_created AND
7983: NOT OE_GLOBALS.EQUAL(p_x_line_rec.freight_terms_code,
7984: OE_Order_Cache.g_header_rec.freight_terms_code ))
7985: THEN
7986:
7987: IF NOT OE_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
7988: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8010: OE_Order_Cache.g_header_rec.invoice_to_contact_id ))

8006: THEN
8007: IF NOT(l_header_created) OR
8008: (l_header_created AND
8009: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoice_to_contact_id,
8010: OE_Order_Cache.g_header_rec.invoice_to_contact_id ))
8011: THEN
8012:
8013: IF NOT OE_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
8014: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8036: OE_Order_Cache.g_header_rec.invoice_to_org_id ))

8032: THEN
8033: IF NOT(l_header_created) OR
8034: (l_header_created AND
8035: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoice_to_org_id,
8036: OE_Order_Cache.g_header_rec.invoice_to_org_id ))
8037: THEN
8038:
8039: IF NOT OE_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
8040: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8062: OE_Order_Cache.g_header_rec.invoicing_rule_id ))

8058: THEN
8059: IF NOT(l_header_created) OR
8060: (l_header_created AND
8061: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoicing_rule_id,
8062: OE_Order_Cache.g_header_rec.invoicing_rule_id ))
8063: THEN
8064:
8065: IF NOT OE_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
8066: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8145: OE_Order_Cache.g_header_rec.payment_term_id ))

8141: THEN
8142: IF NOT(l_header_created) OR
8143: (l_header_created AND
8144: NOT OE_GLOBALS.EQUAL(p_x_line_rec.payment_term_id,
8145: OE_Order_Cache.g_header_rec.payment_term_id ))
8146: THEN
8147:
8148: IF NOT OE_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
8149: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8200: OE_Order_Cache.g_header_rec.price_list_id ))

8196: THEN
8197: IF NOT(l_header_created) OR
8198: (l_header_created AND
8199: NOT OE_GLOBALS.EQUAL(p_x_line_rec.price_list_id,
8200: OE_Order_Cache.g_header_rec.price_list_id ))
8201: THEN
8202:
8203: IF NOT OE_Validate.Price_List(p_x_line_rec.price_list_id) THEN
8204: --No partial level validation if this is a mandatory field.

Line 8296: OE_Order_Cache.g_header_rec.shipment_priority_code ))

8292: THEN
8293: IF NOT(l_header_created) OR
8294: (l_header_created AND
8295: NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipment_priority_code,
8296: OE_Order_Cache.g_header_rec.shipment_priority_code ))
8297: THEN
8298:
8299: IF NOT OE_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
8300: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8322: OE_Order_Cache.g_header_rec.shipping_method_code ))

8318: THEN
8319: IF NOT(l_header_created) OR
8320: (l_header_created AND
8321: NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipping_method_code,
8322: OE_Order_Cache.g_header_rec.shipping_method_code ))
8323: THEN
8324:
8325: IF NOT OE_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
8326: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8348: OE_Order_Cache.g_header_rec.ship_from_org_id ))

8344: THEN
8345: IF NOT(l_header_created) OR
8346: (l_header_created AND
8347: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_from_org_id,
8348: OE_Order_Cache.g_header_rec.ship_from_org_id ))
8349: THEN
8350:
8351: IF NOT OE_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
8352: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8410: OE_Order_Cache.g_header_rec.ship_to_contact_id ))

8406: THEN
8407: IF NOT(l_header_created) OR
8408: (l_header_created AND
8409: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_contact_id,
8410: OE_Order_Cache.g_header_rec.ship_to_contact_id ))
8411: THEN
8412:
8413: IF NOT OE_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
8414: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8436: OE_Order_Cache.g_header_rec.ship_to_org_id ))

8432: THEN
8433: IF NOT(l_header_created) OR
8434: (l_header_created AND
8435: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_org_id,
8436: OE_Order_Cache.g_header_rec.ship_to_org_id ))
8437: THEN
8438:
8439: IF NOT OE_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
8440: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8462: OE_Order_Cache.g_header_rec.sold_to_org_id ))

8458: THEN
8459: IF NOT(l_header_created) OR
8460: (l_header_created AND
8461: NOT OE_GLOBALS.EQUAL(p_x_line_rec.sold_to_org_id,
8462: OE_Order_Cache.g_header_rec.sold_to_org_id ))
8463: THEN
8464:
8465: IF NOT OE_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
8466: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8506: OE_Order_Cache.g_header_rec.tax_exempt_flag ))

8502: THEN
8503: IF NOT(l_header_created) OR
8504: (l_header_created AND
8505: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_exempt_flag,
8506: OE_Order_Cache.g_header_rec.tax_exempt_flag ))
8507: THEN
8508:
8509: IF NOT OE_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
8510: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8532: OE_Order_Cache.g_header_rec.tax_exempt_reason_code ))

8528: THEN
8529: IF NOT(l_header_created) OR
8530: (l_header_created AND
8531: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_exempt_reason_code,
8532: OE_Order_Cache.g_header_rec.tax_exempt_reason_code ))
8533: THEN
8534:
8535: IF NOT OE_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
8536: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8558: OE_Order_Cache.g_header_rec.tax_point_code ))

8554: THEN
8555: IF NOT(l_header_created) OR
8556: (l_header_created AND
8557: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_point_code,
8558: OE_Order_Cache.g_header_rec.tax_point_code ))
8559: THEN
8560:
8561: IF NOT OE_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
8562: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8630: OE_Order_Cache.g_header_rec.salesrep_id ))

8626: THEN
8627: IF NOT(l_header_created) OR
8628: (l_header_created AND
8629: NOT OE_GLOBALS.EQUAL(p_x_line_rec.salesrep_id,
8630: OE_Order_Cache.g_header_rec.salesrep_id ))
8631: THEN
8632:
8633: IF NOT OE_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
8634: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8721: OE_Order_Cache.g_header_rec.minisite_id ))

8717: THEN
8718: IF NOT(l_header_created) OR
8719: (l_header_created AND
8720: NOT OE_GLOBALS.EQUAL(p_x_line_rec.minisite_id,
8721: OE_Order_Cache.g_header_rec.minisite_id ))
8722:
8723: THEN
8724:
8725: IF NOT OE_Validate.Minisite(p_x_line_rec.Minisite_id) THEN

Line 8751: OE_Order_Cache.g_header_rec.Ib_owner ))

8747: THEN
8748: IF NOT(l_header_created) OR
8749: (l_header_created AND
8750: NOT OE_GLOBALS.EQUAL(p_x_line_rec.Ib_owner,
8751: OE_Order_Cache.g_header_rec.Ib_owner ))
8752:
8753: THEN
8754:
8755: IF NOT OE_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN

Line 8779: OE_Order_Cache.g_header_rec.Ib_installed_at_location ))

8775: THEN
8776: IF NOT(l_header_created) OR
8777: (l_header_created AND
8778: NOT OE_GLOBALS.EQUAL(p_x_line_rec.Ib_installed_at_location,
8779: OE_Order_Cache.g_header_rec.Ib_installed_at_location ))
8780:
8781: THEN
8782:
8783: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN

Line 8807: OE_Order_Cache.g_header_rec.Ib_current_location ))

8803: THEN
8804: IF NOT(l_header_created) OR
8805: (l_header_created AND
8806: NOT OE_GLOBALS.EQUAL(p_x_line_rec.Ib_current_location,
8807: OE_Order_Cache.g_header_rec.Ib_current_location ))
8808:
8809: THEN
8810:
8811: IF NOT OE_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN

Line 8835: OE_Order_Cache.g_header_rec.End_customer_id ))

8831: THEN
8832: IF NOT(l_header_created) OR
8833: (l_header_created AND
8834: NOT OE_GLOBALS.EQUAL(p_x_line_rec.End_customer_id,
8835: OE_Order_Cache.g_header_rec.End_customer_id ))
8836:
8837: THEN
8838:
8839: IF NOT OE_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN

Line 8863: OE_Order_Cache.g_header_rec.End_customer_contact_id ))

8859: THEN
8860: IF NOT(l_header_created) OR
8861: (l_header_created AND
8862: NOT OE_GLOBALS.EQUAL(p_x_line_rec.End_customer_contact_id,
8863: OE_Order_Cache.g_header_rec.End_customer_contact_id ))
8864:
8865: THEN
8866:
8867: IF NOT OE_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN

Line 8891: OE_Order_Cache.g_header_rec.End_customer_site_use_id ))

8887: THEN
8888: IF NOT(l_header_created) OR
8889: (l_header_created AND
8890: NOT OE_GLOBALS.EQUAL(p_x_line_rec.End_customer_site_use_id,
8891: OE_Order_Cache.g_header_rec.End_customer_site_use_id ))
8892:
8893: THEN
8894:
8895: IF NOT OE_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN

Line 8999: OE_Order_Cache.g_header_rec.supplier_signature ))

8995: THEN
8996: IF NOT(l_header_created) OR
8997: (l_header_created AND
8998: NOT OE_GLOBALS.EQUAL(p_x_line_rec.supplier_signature,
8999: OE_Order_Cache.g_header_rec.supplier_signature ))
9000:
9001: THEN
9002:
9003: IF NOT OE_Validate.SUPPLIER_SIGNATURE(p_x_line_rec.supplier_signature) THEN

Line 9027: OE_Order_Cache.g_header_rec.supplier_signature_date ))

9023: THEN
9024: IF NOT(l_header_created) OR
9025: (l_header_created AND
9026: NOT OE_GLOBALS.EQUAL(p_x_line_rec.supplier_signature_date,
9027: OE_Order_Cache.g_header_rec.supplier_signature_date ))
9028:
9029: THEN
9030:
9031: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE(p_x_line_rec.supplier_signature_date) THEN

Line 9055: OE_Order_Cache.g_header_rec.customer_signature ))

9051: THEN
9052: IF NOT(l_header_created) OR
9053: (l_header_created AND
9054: NOT OE_GLOBALS.EQUAL(p_x_line_rec.customer_signature,
9055: OE_Order_Cache.g_header_rec.customer_signature ))
9056:
9057: THEN
9058:
9059: IF NOT OE_Validate.CUSTOMER_SIGNATURE(p_x_line_rec.customer_signature) THEN

Line 9083: OE_Order_Cache.g_header_rec.customer_signature_date ))

9079: THEN
9080: IF NOT(l_header_created) OR
9081: (l_header_created AND
9082: NOT OE_GLOBALS.EQUAL(p_x_line_rec.customer_signature_date,
9083: OE_Order_Cache.g_header_rec.customer_signature_date ))
9084:
9085: THEN
9086:
9087: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE(p_x_line_rec.customer_signature_date) THEN

Line 9278: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_ATTRIBUTES') = 'Y' THEN

9274: THEN
9275: IF l_debug_level > 0 then
9276: oe_debug_pub.add('Before calling line_desc_flex',2);
9277: END IF;
9278: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_ATTRIBUTES') = 'Y' THEN
9279:
9280: IF NOT OE_VALIDATE.Line_Desc_Flex
9281: (p_context => p_x_line_rec.context
9282: ,p_attribute1 => p_x_line_rec.attribute1

Line 9594: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_GLOBAL_ATTRIBUTE') = 'Y' THEN

9590:
9591: IF l_debug_level > 0 then
9592: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
9593: END IF;
9594: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_GLOBAL_ATTRIBUTE') = 'Y' THEN
9595: IF NOT OE_VALIDATE.G_Line_Desc_Flex
9596: (p_context => p_x_line_rec.global_attribute_category
9597: ,p_attribute1 => p_x_line_rec.global_attribute1
9598: ,p_attribute2 => p_x_line_rec.global_attribute2

Line 9915: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_INDUSTRY_ATTRIBUTE') = 'Y' THEN

9911: ( p_x_line_rec.industry_context <>
9912: p_old_line_rec.industry_context OR
9913: p_old_line_rec.industry_context IS NULL )))
9914: THEN
9915: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_INDUSTRY_ATTRIBUTE') = 'Y' THEN
9916: IF NOT OE_VALIDATE.I_Line_Desc_Flex
9917: (p_context => p_x_line_rec.Industry_context
9918: ,p_attribute1 => p_x_line_rec.Industry_attribute1
9919: ,p_attribute2 => p_x_line_rec.Industry_attribute2

Line 10258: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_TP_ATTRIBUTES') = 'Y' THEN

10254: p_old_line_rec.tp_attribute15 IS NULL )))
10255:
10256: THEN
10257:
10258: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_TP_ATTRIBUTES') = 'Y' THEN
10259: IF NOT OE_VALIDATE.TP_Line_Desc_Flex
10260: (p_context => p_x_line_rec.tp_context
10261: ,p_attribute1 => p_x_line_rec.tp_attribute1
10262: ,p_attribute2 => p_x_line_rec.tp_attribute2

Line 10438: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_RETURN_ATTRIBUTE') = 'Y' THEN

10434:
10435: IF l_debug_level > 0 then
10436: oe_debug_pub.add('Before calling Return line_desc_flex',2);
10437: END IF;
10438: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_RETURN_ATTRIBUTE') = 'Y' THEN
10439: IF NOT OE_VALIDATE.R_Line_Desc_Flex
10440: (p_context => p_x_line_rec.Return_context
10441: ,p_attribute1 => p_x_line_rec.Return_attribute1
10442: ,p_attribute2 => p_x_line_rec.Return_attribute2