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 563: l_cust_trx_rec_type := OE_ORDER_CACHE.Load_Cust_Trx_Type(l_cust_Trx_type_id);

559: oe_debug_pub.add( 'value of customer trx type id '||l_cust_trx_type_id,1);
560: END IF;
561:
562: IF l_cust_trx_type_id IS NOT NULL AND l_cust_trx_type_id <> 0 THEN
563: l_cust_trx_rec_type := OE_ORDER_CACHE.Load_Cust_Trx_Type(l_cust_Trx_type_id);
564: l_calculate_tax_flag := l_cust_trx_rec_type.tax_calculation_flag;
565: END IF;
566:
567: IF l_debug_level > 0 THEN

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

569: END IF;
570:
571: -- end bug#5462464
572:
573: -- l_line_type_rec := OE_Order_Cache.Load_Line_Type(p_line_rec.line_type_id);
574:
575: -- fix for bug 1701388 - commented the following code
576: -- Fix bug#1098412: check for calculate tax flag ONLY if receivable
577: -- transaction type EXISTS on the line type

Line 597: = OE_Order_Cache.g_header_rec.order_type_id;

593: SELECT TAX_CALCULATION_EVENT_CODE
594: INTO l_tax_calculation_event_code
595: FROM oe_transaction_types_all
596: WHERE transaction_type_id
597: = OE_Order_Cache.g_header_rec.order_type_id;
598:
599: IF nvl(l_tax_calculation_event_code, 'ENTERING') IN ('ENTERING', 'BOOKING') THEN
600:
601: x_return_status := FND_API.G_RET_STS_ERROR;

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

687:
688: END IF;
689:
690: --key Transaction dates
691: l_hdr_booked_date := oe_order_cache.g_header_rec.booked_date ;
692: IF l_hdr_booked_date = FND_API.G_MISS_DATE or l_hdr_booked_date IS NULL THEN
693: l_hdr_booked_date := sysdate ;
694: END IF ;
695:

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

1754: -- Item is BUY item
1755: IF(NOT OE_GLOBALS.G_UI_FLAG) THEN
1756:
1757: --changes for bug 4171642
1758: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1759: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1760: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1761: THEN
1762: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then

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

1755: IF(NOT OE_GLOBALS.G_UI_FLAG) THEN
1756:
1757: --changes for bug 4171642
1758: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1759: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1760: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1761: THEN
1762: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1763: l_dummy := 'VALID';

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

1756:
1757: --changes for bug 4171642
1758: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1759: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1760: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1761: THEN
1762: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1763: l_dummy := 'VALID';
1764: else

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

1758: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1759: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1760: ( OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1761: THEN
1762: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1763: l_dummy := 'VALID';
1764: else
1765: RAISE NO_DATA_FOUND ;
1766: end if;

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

1764: else
1765: RAISE NO_DATA_FOUND ;
1766: end if;
1767: ELSE
1768: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;
1769: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then
1770: l_dummy := 'VALID';
1771: else
1772: Raise No_Data_Found ;

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

1765: RAISE NO_DATA_FOUND ;
1766: end if;
1767: ELSE
1768: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;
1769: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then
1770: l_dummy := 'VALID';
1771: else
1772: Raise No_Data_Found ;
1773: end if ;

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

1784: END IF;
1785: ELSE /* Item is get or free item */
1786:
1787: --changes for bug 3975762
1788: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1789: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1790: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1791: THEN
1792: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then

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

1785: ELSE /* Item is get or free item */
1786:
1787: --changes for bug 3975762
1788: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1789: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1790: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1791: THEN
1792: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1793: l_dummy := 'VALID';

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

1786:
1787: --changes for bug 3975762
1788: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1789: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1790: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1791: THEN
1792: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1793: l_dummy := 'VALID';
1794: else

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

1788: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
1789: ( OE_ORDER_CACHE.g_item_rec.master_org_id = g_master_org_id) AND
1790: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
1791: THEN
1792: if OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y' then
1793: l_dummy := 'VALID';
1794: else
1795: RAISE NO_DATA_FOUND ;
1796: end if ;

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

1794: else
1795: RAISE NO_DATA_FOUND ;
1796: end if ;
1797: ELSE
1798: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;
1799: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then
1800: l_dummy := 'VALID';
1801: else
1802: Raise No_Data_Found ;

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

1795: RAISE NO_DATA_FOUND ;
1796: end if ;
1797: ELSE
1798: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ) ;
1799: if (OE_ORDER_CACHE.g_item_rec.customer_order_enabled_flag = 'Y') then
1800: l_dummy := 'VALID';
1801: else
1802: Raise No_Data_Found ;
1803: end if ;

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

2067: oe_debug_pub.add('Entering Validate_Return_Item',1);
2068: END IF;
2069:
2070: -- bug 4171642
2071: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2072: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND
2073: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2074: THEN
2075: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');

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

2068: END IF;
2069:
2070: -- bug 4171642
2071: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2072: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND
2073: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2074: THEN
2075: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2076: ELSE

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

2069:
2070: -- bug 4171642
2071: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2072: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND
2073: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2074: THEN
2075: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2076: ELSE
2077: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,

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

2071: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2072: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.master_org_id) AND
2073: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2074: THEN
2075: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2076: ELSE
2077: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,
2078: p_key2 => p_ship_from_org_id );
2079: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');

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

2073: (OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_inventory_item_id)
2074: THEN
2075: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2076: ELSE
2077: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,
2078: p_key2 => p_ship_from_org_id );
2079: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2080: END IF ;
2081: /*

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

2075: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2076: ELSE
2077: OE_ORDER_CACHE.Load_Item( p_key1 => p_inventory_item_id ,
2078: p_key2 => p_ship_from_org_id );
2079: l_returnable_flag := nvl(OE_ORDER_CACHE.g_item_rec.returnable_flag , 'Y');
2080: END IF ;
2081: /*
2082: SELECT nvl(returnable_flag,'Y')
2083: INTO l_returnable_flag

Line 3810: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM

3806: l_validate_result VARCHAR2(1):='Y';
3807: --MC End
3808: /*OPM 02/JUN/00 BEGIN
3809: ====================*/
3810: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM
3811: --l_OPM_UOM VARCHAR2(4); --OPM 06/22 --INVCONV
3812: l_status VARCHAR2(1); --OPM 06/22
3813: l_msg_count NUMBER;
3814: l_msg_data VARCHAR2(2000);

Line 3935: l_price_list_rec OE_ORDER_CACHE.Price_List_Rec_Type ;

3931: and acct_site.cust_account_id = cust_acct.cust_account_id;
3932:
3933: -- end eBTax changes
3934: --added for bug 4200055
3935: l_price_list_rec OE_ORDER_CACHE.Price_List_Rec_Type ;
3936: --PP Revenue Recognition
3937: --bug 4893057
3938: l_rule_type VARCHAR2(10);
3939: l_line_type VARCHAR2(80);

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

3946: THEN
3947: IF l_debug_level > 0 then
3948: oe_debug_pub.add('Header has got created in the same call',1);
3949: END IF;
3950: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
3951: l_header_created := TRUE;
3952: END IF;
3953:
3954: -----------------------------------------------------------

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

4359: END IF;
4360: /* fix bug 2570174, check for restricted subinv */
4361: BEGIN
4362: -- bug 4171642
4363: if (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM
4364: AND
4365: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4366: AND
4367: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)

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

4361: BEGIN
4362: -- bug 4171642
4363: if (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM
4364: AND
4365: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4366: AND
4367: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)
4368: THEN
4369: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;

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

4363: if (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM
4364: AND
4365: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4366: AND
4367: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)
4368: THEN
4369: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4370: else
4371: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,

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

4365: OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4366: AND
4367: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)
4368: THEN
4369: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4370: else
4371: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4372: p_key2 => p_line_rec.ship_from_org_id );
4373: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id

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

4367: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id)
4368: THEN
4369: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4370: else
4371: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4372: p_key2 => p_line_rec.ship_from_org_id );
4373: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4374: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN
4375: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;

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

4369: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4370: else
4371: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4372: p_key2 => p_line_rec.ship_from_org_id );
4373: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4374: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN
4375: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4376: else
4377: l_restrict_subinv := 0;

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

4370: else
4371: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4372: p_key2 => p_line_rec.ship_from_org_id );
4373: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4374: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN
4375: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4376: else
4377: l_restrict_subinv := 0;
4378: end if ;

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

4371: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id ,
4372: p_key2 => p_line_rec.ship_from_org_id );
4373: if ( OE_ORDER_CACHE.g_item_rec.organization_id = p_line_rec.ship_from_org_id
4374: and OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id) THEN
4375: l_restrict_subinv := OE_ORDER_CACHE.g_item_rec.restrict_subinventories_code;
4376: else
4377: l_restrict_subinv := 0;
4378: end if ;
4379: end if ;

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

5626:
5627: -- Validation of Ship To Org Id.
5628: IF p_line_rec.ship_to_org_id IS NOT NULL
5629: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5630: (OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))
5631: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id
5632: ,p_old_line_rec.ship_to_org_id)
5633: OR NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id
5634: ,p_old_line_rec.sold_to_org_id))

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

5659:
5660: -- Ship to contact depends on Ship To Org
5661: IF p_line_rec.ship_to_contact_id IS NOT NULL
5662: AND NOT (l_header_created
5663: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_contact_id, p_line_rec.ship_to_contact_id)
5664: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))
5665: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id)
5666: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id))
5667: --Bug 5679739 AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id)

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

5660: -- Ship to contact depends on Ship To Org
5661: IF p_line_rec.ship_to_contact_id IS NOT NULL
5662: AND NOT (l_header_created
5663: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_contact_id, p_line_rec.ship_to_contact_id)
5664: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))
5665: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id)
5666: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id))
5667: --Bug 5679739 AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id)
5668: THEN

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

5663: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_contact_id, p_line_rec.ship_to_contact_id)
5664: AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id))
5665: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_contact_id,p_old_line_rec.ship_to_contact_id)
5666: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_to_org_id,p_old_line_rec.ship_to_org_id))
5667: --Bug 5679739 AND OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.ship_to_org_id,p_line_rec.ship_to_org_id)
5668: THEN
5669:
5670: BEGIN
5671: IF l_debug_level > 0 then

Line 5723: (OE_Order_Cache.g_header_rec.deliver_to_org_id,

5719:
5720: -- Validation of Deliver To Org Id.
5721: IF p_line_rec.deliver_to_org_id IS NOT NULL
5722: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5723: (OE_Order_Cache.g_header_rec.deliver_to_org_id,
5724: p_line_rec.deliver_to_org_id))
5725: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id
5726: ,p_old_line_rec.deliver_to_org_id)
5727: OR NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id

Line 5754: (OE_Order_Cache.g_header_rec.deliver_to_org_id,

5750:
5751: -- Deliver to contact depends on Deliver To Org
5752: IF p_line_rec.deliver_to_contact_id IS NOT NULL
5753: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5754: (OE_Order_Cache.g_header_rec.deliver_to_org_id,
5755: p_line_rec.deliver_to_org_id) AND OE_GLOBALS.EQUAL
5756: (OE_Order_Cache.g_header_rec.deliver_to_contact_id,
5757: p_line_rec.deliver_to_contact_id))
5758: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_contact_id

Line 5756: (OE_Order_Cache.g_header_rec.deliver_to_contact_id,

5752: IF p_line_rec.deliver_to_contact_id IS NOT NULL
5753: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5754: (OE_Order_Cache.g_header_rec.deliver_to_org_id,
5755: p_line_rec.deliver_to_org_id) AND OE_GLOBALS.EQUAL
5756: (OE_Order_Cache.g_header_rec.deliver_to_contact_id,
5757: p_line_rec.deliver_to_contact_id))
5758: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_contact_id
5759: ,p_old_line_rec.deliver_to_contact_id)
5760: OR NOT OE_GLOBALS.EQUAL(p_line_rec.deliver_to_org_id

Line 5816: (OE_Order_Cache.g_header_rec.invoice_to_org_id,

5812:
5813: -- Validation of Invoice To Org Id.
5814: IF p_line_rec.invoice_to_org_id IS NOT NULL
5815: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5816: (OE_Order_Cache.g_header_rec.invoice_to_org_id,
5817: p_line_rec.invoice_to_org_id))
5818: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id
5819: ,p_old_line_rec.invoice_to_org_id)
5820: OR NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id

Line 5909: (OE_Order_Cache.g_header_rec.invoice_to_contact_id,

5905: -- Validation of Invoice To Contact Id.
5906: IF p_line_rec.invoice_to_contact_id IS NOT NULL
5907: AND p_line_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM
5908: AND NOT (l_header_created AND OE_GLOBALS.EQUAL
5909: (OE_Order_Cache.g_header_rec.invoice_to_contact_id,
5910: p_line_rec.invoice_to_contact_id))
5911: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_contact_id
5912: ,p_old_line_rec.invoice_to_contact_id)
5913: OR NOT OE_GLOBALS.EQUAL(p_line_rec.invoice_to_org_id

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

6269: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG)
6270: THEN
6271: BEGIN
6272: /* -- bug 4171642 commented following for bug 8704697,8894555
6273: IF ((OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
6274: AND
6275: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)
6276: AND
6277: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN

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

6271: BEGIN
6272: /* -- bug 4171642 commented following for bug 8704697,8894555
6273: IF ((OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
6274: AND
6275: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)
6276: AND
6277: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
6278: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6279: ELSE

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

6273: IF ((OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
6274: AND
6275: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)
6276: AND
6277: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
6278: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6279: ELSE
6280: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );
6281: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;

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

6274: AND
6275: (nvl(p_line_rec.ship_from_org_id,g_master_org_id) = OE_ORDER_CACHE.g_item_rec.organization_id)
6276: AND
6277: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
6278: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6279: ELSE
6280: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );
6281: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6282: END IF ;

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

6276: AND
6277: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
6278: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6279: ELSE
6280: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );
6281: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6282: END IF ;
6283: end of bug 8894555,8704697 */
6284: /*SELECT primary_uom_code

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

6277: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
6278: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6279: ELSE
6280: OE_ORDER_CACHE.Load_Item( p_key1 => p_line_rec.inventory_item_id , p_key2 => p_line_rec.ship_from_org_id );
6281: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6282: END IF ;
6283: end of bug 8894555,8704697 */
6284: /*SELECT primary_uom_code
6285: INTO l_uom

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

6290: */
6291: -- end bug 4171642
6292: ---Start bug 8894555 Primary uom should be validated against the Master org for model items
6293: ---UOM will be picked from cache if ship_from and master org are same else get from DB
6294: IF ( (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
6295: AND
6296: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.organization_id)
6297: AND
6298: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN

Line 6296: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.organization_id)

6292: ---Start bug 8894555 Primary uom should be validated against the Master org for model items
6293: ---UOM will be picked from cache if ship_from and master org are same else get from DB
6294: IF ( (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
6295: AND
6296: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.organization_id)
6297: AND
6298: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
6299:
6300:

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

6294: IF ( (OE_ORDER_CACHE.g_item_rec.organization_id <> FND_API.G_MISS_NUM)
6295: AND
6296: (g_master_org_id = OE_ORDER_CACHE.g_item_rec.organization_id)
6297: AND
6298: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
6299:
6300:
6301: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6302: if l_debug_level > 0 then

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

6297: AND
6298: OE_ORDER_CACHE.g_item_rec.inventory_item_id = p_line_rec.inventory_item_id ) THEN
6299:
6300:
6301: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6302: if l_debug_level > 0 then
6303: oe_debug_pub.add('Primary uom from item cache : '||l_uom);
6304: end if;
6305:

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

6520: if p_line_rec.cancelled_flag <> 'Y' and
6521: p_line_rec.calculate_price_flag not in ('P','N') Then
6522: BEGIN
6523: --
6524: l_hdr_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
6525:
6526: --fix a problem in which for some rare cases in which cachce has a null of transactional_curr_code
6527: If nvl(l_hdr_currency_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR Then
6528: Select transactional_curr_code

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

6612: -- modified by lkxu: to select from qp_list_headers_vl instead
6613: -- of from qp_price_lists_v to select only PRL type list headers.
6614:
6615: --use cache instead of sql for bug 4200055
6616: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_line_rec.price_list_id) ;
6617: IF ( l_price_list_rec.price_list_id <> FND_API.G_MISS_NUM
6618: AND l_price_list_rec.price_list_id IS NOT NULL
6619: AND l_price_list_rec.price_list_id = p_line_rec.price_list_id ) THEN
6620: if (

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

6834: THEN
6835:
6836: -- Fixed bug 1949756: validate line level cust po number
6837: -- only if it is different from header cust po number
6838: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
6839: IF NOT OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.cust_po_number,
6840: p_line_rec.cust_po_number)
6841: AND OE_Validate_Header.Is_Duplicate_PO_Number
6842: (p_line_rec.cust_po_number

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

6835:
6836: -- Fixed bug 1949756: validate line level cust po number
6837: -- only if it is different from header cust po number
6838: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
6839: IF NOT OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.cust_po_number,
6840: p_line_rec.cust_po_number)
6841: AND OE_Validate_Header.Is_Duplicate_PO_Number
6842: (p_line_rec.cust_po_number
6843: ,p_line_rec.sold_to_org_id

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

6925:
6926: IF l_debug_level > 0 then
6927: OE_DEBUG_PUB.ADD('l_hdr_currency_code1:' || l_hdr_currency_code,2);
6928: END IF;
6929: l_hdr_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
6930: Validate_Commitment(
6931: p_line_rec => p_line_rec
6932: , p_hdr_currency_code => l_hdr_currency_code
6933: , p_ota_line => l_is_ota_line

Line 7582: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null

7578: -- no validation for SOLD_TO
7579: -- since no line level sold_to_site_use_id
7580: -- REMOVE after LOV is fixed
7581: ELSIF p_line_rec.ib_installed_at_location = 'SOLD_TO'
7582: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7583: THEN
7584: l_return_status := FND_API.G_RET_STS_ERROR;
7585: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7586: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));

Line 7645: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null

7641: -- no validation for SOLD_TO
7642: -- since no line level sold_to_site_use_id
7643: -- REMOVE after LOV is fixed
7644: ELSIF p_line_rec.ib_current_location = 'SOLD_TO'
7645: AND OE_Order_Cache.g_header_rec.sold_to_site_use_id is null
7646: THEN
7647: l_return_status := FND_API.G_RET_STS_ERROR;
7648: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));

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

8153: THEN
8154: IF l_debug_level > 0 then
8155: oe_debug_pub.add('Header has got created in the same call',1);
8156: END IF;
8157: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
8158: l_header_created := TRUE;
8159: END IF;
8160:
8161: -- Validate line attributes

Line 8171: OE_Order_Cache.g_header_rec.accounting_rule_id ))

8167: THEN
8168: IF NOT(l_header_created) OR
8169: (l_header_created AND
8170: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_id,
8171: OE_Order_Cache.g_header_rec.accounting_rule_id ))
8172: THEN
8173: IF l_debug_level > 0 then
8174: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
8175: END IF;

Line 8199: OE_Order_Cache.g_header_rec.accounting_rule_duration ))

8195: THEN
8196: IF NOT(l_header_created) OR
8197: (l_header_created AND
8198: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_duration,
8199: OE_Order_Cache.g_header_rec.accounting_rule_duration ))
8200: THEN
8201: IF l_debug_level > 0 then
8202: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule_duration',1);
8203: END IF;

Line 8227: OE_Order_Cache.g_header_rec.agreement_id ))

8223: THEN
8224: IF NOT(l_header_created) OR
8225: (l_header_created AND
8226: NOT OE_GLOBALS.EQUAL(p_x_line_rec.agreement_id,
8227: OE_Order_Cache.g_header_rec.agreement_id ))
8228: THEN
8229:
8230: IF NOT OE_Validate.Agreement(p_x_line_rec.agreement_id) THEN
8231: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8254: OE_Order_Cache.g_header_rec.deliver_to_contact_id ))

8250: THEN
8251: IF NOT(l_header_created) OR
8252: (l_header_created AND
8253: NOT OE_GLOBALS.EQUAL(p_x_line_rec.deliver_to_contact_id,
8254: OE_Order_Cache.g_header_rec.deliver_to_contact_id ))
8255: THEN
8256:
8257: IF NOT OE_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
8258: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8281: OE_Order_Cache.g_header_rec.deliver_to_org_id ))

8277: THEN
8278: IF NOT(l_header_created) OR
8279: (l_header_created AND
8280: NOT OE_GLOBALS.EQUAL(p_x_line_rec.deliver_to_org_id,
8281: OE_Order_Cache.g_header_rec.deliver_to_org_id ))
8282: THEN
8283:
8284: IF NOT OE_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
8285: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8308: OE_Order_Cache.g_header_rec.demand_class_code ))

8304: THEN
8305: IF NOT(l_header_created) OR
8306: (l_header_created AND
8307: NOT OE_GLOBALS.EQUAL(p_x_line_rec.demand_class_code,
8308: OE_Order_Cache.g_header_rec.demand_class_code ))
8309: THEN
8310:
8311: IF NOT OE_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
8312: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8370: OE_Order_Cache.g_header_rec.fob_point_code ))

8366: THEN
8367: IF NOT(l_header_created) OR
8368: (l_header_created AND
8369: NOT OE_GLOBALS.EQUAL(p_x_line_rec.fob_point_code,
8370: OE_Order_Cache.g_header_rec.fob_point_code ))
8371: THEN
8372:
8373: IF NOT OE_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
8374: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8396: OE_Order_Cache.g_header_rec.freight_terms_code ))

8392: THEN
8393: IF NOT(l_header_created) OR
8394: (l_header_created AND
8395: NOT OE_GLOBALS.EQUAL(p_x_line_rec.freight_terms_code,
8396: OE_Order_Cache.g_header_rec.freight_terms_code ))
8397: THEN
8398:
8399: IF NOT OE_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
8400: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8422: OE_Order_Cache.g_header_rec.invoice_to_contact_id ))

8418: THEN
8419: IF NOT(l_header_created) OR
8420: (l_header_created AND
8421: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoice_to_contact_id,
8422: OE_Order_Cache.g_header_rec.invoice_to_contact_id ))
8423: THEN
8424:
8425: IF NOT OE_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
8426: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8448: OE_Order_Cache.g_header_rec.invoice_to_org_id ))

8444: THEN
8445: IF NOT(l_header_created) OR
8446: (l_header_created AND
8447: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoice_to_org_id,
8448: OE_Order_Cache.g_header_rec.invoice_to_org_id ))
8449: THEN
8450:
8451: IF NOT OE_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
8452: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8474: OE_Order_Cache.g_header_rec.invoicing_rule_id ))

8470: THEN
8471: IF NOT(l_header_created) OR
8472: (l_header_created AND
8473: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoicing_rule_id,
8474: OE_Order_Cache.g_header_rec.invoicing_rule_id ))
8475: THEN
8476:
8477: IF NOT OE_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
8478: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8557: OE_Order_Cache.g_header_rec.payment_term_id ))

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

Line 8612: OE_Order_Cache.g_header_rec.price_list_id ))

8608: THEN
8609: IF NOT(l_header_created) OR
8610: (l_header_created AND
8611: NOT OE_GLOBALS.EQUAL(p_x_line_rec.price_list_id,
8612: OE_Order_Cache.g_header_rec.price_list_id ))
8613: THEN
8614:
8615: IF NOT OE_Validate.Price_List(p_x_line_rec.price_list_id) THEN
8616: --No partial level validation if this is a mandatory field.

Line 8708: OE_Order_Cache.g_header_rec.shipment_priority_code ))

8704: THEN
8705: IF NOT(l_header_created) OR
8706: (l_header_created AND
8707: NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipment_priority_code,
8708: OE_Order_Cache.g_header_rec.shipment_priority_code ))
8709: THEN
8710:
8711: IF NOT OE_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
8712: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8734: OE_Order_Cache.g_header_rec.shipping_method_code ))

8730: THEN
8731: IF NOT(l_header_created) OR
8732: (l_header_created AND
8733: NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipping_method_code,
8734: OE_Order_Cache.g_header_rec.shipping_method_code ))
8735: THEN
8736:
8737: IF NOT OE_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
8738: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8760: OE_Order_Cache.g_header_rec.ship_from_org_id ))

8756: THEN
8757: IF NOT(l_header_created) OR
8758: (l_header_created AND
8759: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_from_org_id,
8760: OE_Order_Cache.g_header_rec.ship_from_org_id ))
8761: THEN
8762:
8763: IF NOT OE_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
8764: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8822: OE_Order_Cache.g_header_rec.ship_to_contact_id ))

8818: THEN
8819: IF NOT(l_header_created) OR
8820: (l_header_created AND
8821: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_contact_id,
8822: OE_Order_Cache.g_header_rec.ship_to_contact_id ))
8823: THEN
8824:
8825: IF NOT OE_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
8826: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8848: OE_Order_Cache.g_header_rec.ship_to_org_id ))

8844: THEN
8845: IF NOT(l_header_created) OR
8846: (l_header_created AND
8847: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_org_id,
8848: OE_Order_Cache.g_header_rec.ship_to_org_id ))
8849: THEN
8850:
8851: IF NOT OE_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
8852: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8874: OE_Order_Cache.g_header_rec.sold_to_org_id ))

8870: THEN
8871: IF NOT(l_header_created) OR
8872: (l_header_created AND
8873: NOT OE_GLOBALS.EQUAL(p_x_line_rec.sold_to_org_id,
8874: OE_Order_Cache.g_header_rec.sold_to_org_id ))
8875: THEN
8876:
8877: IF NOT OE_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
8878: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8918: OE_Order_Cache.g_header_rec.tax_exempt_flag ))

8914: THEN
8915: IF NOT(l_header_created) OR
8916: (l_header_created AND
8917: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_exempt_flag,
8918: OE_Order_Cache.g_header_rec.tax_exempt_flag ))
8919: THEN
8920:
8921: IF NOT OE_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
8922: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8944: OE_Order_Cache.g_header_rec.tax_exempt_reason_code ))

8940: THEN
8941: IF NOT(l_header_created) OR
8942: (l_header_created AND
8943: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_exempt_reason_code,
8944: OE_Order_Cache.g_header_rec.tax_exempt_reason_code ))
8945: THEN
8946:
8947: IF NOT OE_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
8948: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 8970: OE_Order_Cache.g_header_rec.tax_point_code ))

8966: THEN
8967: IF NOT(l_header_created) OR
8968: (l_header_created AND
8969: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_point_code,
8970: OE_Order_Cache.g_header_rec.tax_point_code ))
8971: THEN
8972:
8973: IF NOT OE_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
8974: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 9048: OE_Order_Cache.g_header_rec.salesrep_id ))

9044: THEN
9045: IF NOT(l_header_created) OR
9046: (l_header_created AND
9047: NOT OE_GLOBALS.EQUAL(p_x_line_rec.salesrep_id,
9048: OE_Order_Cache.g_header_rec.salesrep_id ))
9049: THEN
9050:
9051: IF NOT OE_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
9052: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND

Line 9139: OE_Order_Cache.g_header_rec.minisite_id ))

9135: THEN
9136: IF NOT(l_header_created) OR
9137: (l_header_created AND
9138: NOT OE_GLOBALS.EQUAL(p_x_line_rec.minisite_id,
9139: OE_Order_Cache.g_header_rec.minisite_id ))
9140:
9141: THEN
9142:
9143: IF NOT OE_Validate.Minisite(p_x_line_rec.Minisite_id) THEN

Line 9169: OE_Order_Cache.g_header_rec.Ib_owner ))

9165: THEN
9166: IF NOT(l_header_created) OR
9167: (l_header_created AND
9168: NOT OE_GLOBALS.EQUAL(p_x_line_rec.Ib_owner,
9169: OE_Order_Cache.g_header_rec.Ib_owner ))
9170:
9171: THEN
9172:
9173: IF NOT OE_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN

Line 9197: OE_Order_Cache.g_header_rec.Ib_installed_at_location ))

9193: THEN
9194: IF NOT(l_header_created) OR
9195: (l_header_created AND
9196: NOT OE_GLOBALS.EQUAL(p_x_line_rec.Ib_installed_at_location,
9197: OE_Order_Cache.g_header_rec.Ib_installed_at_location ))
9198:
9199: THEN
9200:
9201: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN

Line 9225: OE_Order_Cache.g_header_rec.Ib_current_location ))

9221: THEN
9222: IF NOT(l_header_created) OR
9223: (l_header_created AND
9224: NOT OE_GLOBALS.EQUAL(p_x_line_rec.Ib_current_location,
9225: OE_Order_Cache.g_header_rec.Ib_current_location ))
9226:
9227: THEN
9228:
9229: IF NOT OE_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN

Line 9253: OE_Order_Cache.g_header_rec.End_customer_id ))

9249: THEN
9250: IF NOT(l_header_created) OR
9251: (l_header_created AND
9252: NOT OE_GLOBALS.EQUAL(p_x_line_rec.End_customer_id,
9253: OE_Order_Cache.g_header_rec.End_customer_id ))
9254:
9255: THEN
9256:
9257: IF NOT OE_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN

Line 9281: OE_Order_Cache.g_header_rec.End_customer_contact_id ))

9277: THEN
9278: IF NOT(l_header_created) OR
9279: (l_header_created AND
9280: NOT OE_GLOBALS.EQUAL(p_x_line_rec.End_customer_contact_id,
9281: OE_Order_Cache.g_header_rec.End_customer_contact_id ))
9282:
9283: THEN
9284:
9285: IF NOT OE_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN

Line 9309: OE_Order_Cache.g_header_rec.End_customer_site_use_id ))

9305: THEN
9306: IF NOT(l_header_created) OR
9307: (l_header_created AND
9308: NOT OE_GLOBALS.EQUAL(p_x_line_rec.End_customer_site_use_id,
9309: OE_Order_Cache.g_header_rec.End_customer_site_use_id ))
9310:
9311: THEN
9312:
9313: IF NOT OE_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN

Line 9487: OE_Order_Cache.g_header_rec.supplier_signature ))

9483: THEN
9484: IF NOT(l_header_created) OR
9485: (l_header_created AND
9486: NOT OE_GLOBALS.EQUAL(p_x_line_rec.supplier_signature,
9487: OE_Order_Cache.g_header_rec.supplier_signature ))
9488:
9489: THEN
9490:
9491: IF NOT OE_Validate.SUPPLIER_SIGNATURE(p_x_line_rec.supplier_signature) THEN

Line 9515: OE_Order_Cache.g_header_rec.supplier_signature_date ))

9511: THEN
9512: IF NOT(l_header_created) OR
9513: (l_header_created AND
9514: NOT OE_GLOBALS.EQUAL(p_x_line_rec.supplier_signature_date,
9515: OE_Order_Cache.g_header_rec.supplier_signature_date ))
9516:
9517: THEN
9518:
9519: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE(p_x_line_rec.supplier_signature_date) THEN

Line 9543: OE_Order_Cache.g_header_rec.customer_signature ))

9539: THEN
9540: IF NOT(l_header_created) OR
9541: (l_header_created AND
9542: NOT OE_GLOBALS.EQUAL(p_x_line_rec.customer_signature,
9543: OE_Order_Cache.g_header_rec.customer_signature ))
9544:
9545: THEN
9546:
9547: IF NOT OE_Validate.CUSTOMER_SIGNATURE(p_x_line_rec.customer_signature) THEN

Line 9571: OE_Order_Cache.g_header_rec.customer_signature_date ))

9567: THEN
9568: IF NOT(l_header_created) OR
9569: (l_header_created AND
9570: NOT OE_GLOBALS.EQUAL(p_x_line_rec.customer_signature_date,
9571: OE_Order_Cache.g_header_rec.customer_signature_date ))
9572:
9573: THEN
9574:
9575: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE(p_x_line_rec.customer_signature_date) THEN

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

9771: THEN
9772: IF l_debug_level > 0 then
9773: oe_debug_pub.add('Before calling line_desc_flex',2);
9774: END IF;
9775: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_ATTRIBUTES') = 'Y' THEN
9776:
9777: IF NOT OE_VALIDATE.Line_Desc_Flex
9778: (p_context => p_x_line_rec.context
9779: ,p_attribute1 => p_x_line_rec.attribute1

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

10087:
10088: IF l_debug_level > 0 then
10089: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
10090: END IF;
10091: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_GLOBAL_ATTRIBUTE') = 'Y' THEN
10092: IF NOT OE_VALIDATE.G_Line_Desc_Flex
10093: (p_context => p_x_line_rec.global_attribute_category
10094: ,p_attribute1 => p_x_line_rec.global_attribute1
10095: ,p_attribute2 => p_x_line_rec.global_attribute2

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

10408: ( p_x_line_rec.industry_context <>
10409: p_old_line_rec.industry_context OR
10410: p_old_line_rec.industry_context IS NULL )))
10411: THEN
10412: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_INDUSTRY_ATTRIBUTE') = 'Y' THEN
10413: IF NOT OE_VALIDATE.I_Line_Desc_Flex
10414: (p_context => p_x_line_rec.Industry_context
10415: ,p_attribute1 => p_x_line_rec.Industry_attribute1
10416: ,p_attribute2 => p_x_line_rec.Industry_attribute2

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

10751: p_old_line_rec.tp_attribute15 IS NULL )))
10752:
10753: THEN
10754:
10755: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_TP_ATTRIBUTES') = 'Y' THEN
10756: IF NOT OE_VALIDATE.TP_Line_Desc_Flex
10757: (p_context => p_x_line_rec.tp_context
10758: ,p_attribute1 => p_x_line_rec.tp_attribute1
10759: ,p_attribute2 => p_x_line_rec.tp_attribute2

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

10931:
10932: IF l_debug_level > 0 then
10933: oe_debug_pub.add('Before calling Return line_desc_flex',2);
10934: END IF;
10935: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_RETURN_ATTRIBUTE') = 'Y' THEN
10936: IF NOT OE_VALIDATE.R_Line_Desc_Flex
10937: (p_context => p_x_line_rec.Return_context
10938: ,p_attribute1 => p_x_line_rec.Return_attribute1
10939: ,p_attribute2 => p_x_line_rec.Return_attribute2