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

Line 192: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;

188: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
189: , x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
190: )
191: IS
192: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
193: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
194: BEGIN
195:
196: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);

Line 193: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

189: , x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
190: )
191: IS
192: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
193: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
194: BEGIN
195:
196: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
197:

Line 286: l_order_type_rec := OE_Order_Cache.Load_Order_Type

282:
283: -- Check for additional required fields based on flags set
284: -- at the order type: agreement, customer po number
285:
286: l_order_type_rec := OE_Order_Cache.Load_Order_Type
287: (p_header_rec.order_type_id);
288:
289: IF ( l_order_type_rec.agreement_required_flag = 'Y' AND
290: p_header_rec.agreement_id IS NULL)

Line 317: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

313: -- conversion type is required
314:
315: IF p_header_rec.conversion_type_code IS NULL
316: THEN
317: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
318:
319: IF ( l_set_of_books_rec.currency_code <>
320: p_header_rec.transactional_curr_code) THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;

Line 906: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;

902: )
903: IS
904: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
905: l_dummy VARCHAR2(10);
906: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
907: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
908: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
909:
910: l_agreement_name varchar2(240);

Line 907: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;

903: IS
904: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
905: l_dummy VARCHAR2(10);
906: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
907: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
908: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
909:
910: l_agreement_name varchar2(240);
911: l_agreement_revision varchar2(50);

Line 908: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;

904: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
905: l_dummy VARCHAR2(10);
906: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
907: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
908: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
909:
910: l_agreement_name varchar2(240);
911: l_agreement_revision varchar2(50);
912: l_sold_to_org number;

Line 1191: l_price_list_rec :=OE_Order_Cache.Load_Price_List (p_header_rec.price_list_id );

1187: oe_debug_pub.add('old curr ' || p_old_header_rec.transactional_curr_code,2);
1188: oe_debug_pub.add('New curr ' || p_header_rec.transactional_curr_code,2);
1189: -- Validate currency
1190:
1191: l_price_list_rec :=OE_Order_Cache.Load_Price_List (p_header_rec.price_list_id );
1192:
1193: --Added OR condition for CREATE Operation for bug 5060064
1194:
1195: IF (p_header_rec.price_list_id <>

Line 1395: -- OE_Order_Cache.Load_Agreement (p_header_rec.agreement_id);

1391:
1392: IF p_header_rec.agreement_id IS NOT NULL THEN
1393: -- commented by Geresh
1394: -- l_agreement_rec :=
1395: -- OE_Order_Cache.Load_Agreement (p_header_rec.agreement_id);
1396:
1397: BEGIN
1398: BEGIN
1399: select list_type_code

Line 1551: -- OE_Order_Cache.Load_Order_Type (p_header_rec.order_type_id);

1547: raise FND_API.G_EXC_ERROR;
1548: END;
1549:
1550: -- l_order_type_rec :=
1551: -- OE_Order_Cache.Load_Order_Type (p_header_rec.order_type_id);
1552:
1553: /***
1554: IF (l_agreement_rec.sold_to_org_id IS NOT NULL AND
1555: l_agreement_rec.sold_to_org_id <>

Line 3780: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_ATTRIBUTES') = 'Y' THEN

3776: starts defaulting the FF */
3777: /* Fixing 2611912 to skip the Flex field validation in case of
3778: orders coming from CRM. This condition can be removed once process Order
3779: starts defaulting the FF */
3780: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_ATTRIBUTES') = 'Y' THEN
3781: -- AND p_x_header_rec.order_source_id <> 10 AND -- added for 2611912
3782: -- (p_x_header_rec.source_document_type_id IS NULL OR
3783: -- p_x_header_rec.source_document_type_id = FND_API.G_MISS_NUM OR
3784: -- p_x_header_rec.source_document_type_id = 2) THEN

Line 4073: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_GLOBAL_ATTRIBUTE') = 'Y' THEN

4069: OE_DEBUG_PUB.ADD('Before G_header_desc_flex',2);
4070: /* Fixing 2375476 to skip the Flex field validation in case of
4071: Internal Orders. This condition will be removed once process Order
4072: starts defaulting the FF */
4073: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_GLOBAL_ATTRIBUTE') = 'Y' THEN
4074: -- AND p_x_header_rec.order_source_id <> 10 THEN
4075: IF NOT OE_VALIDATE.G_Header_Desc_Flex
4076: (p_context => p_x_header_rec.global_attribute_category
4077: ,p_attribute1 => p_x_header_rec.global_attribute1

Line 4333: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_HEADER_TP_ATTRIBUTES') = 'Y' THEN

4329: p_old_header_rec.tp_attribute15 IS NULL )))
4330:
4331: THEN
4332:
4333: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_HEADER_TP_ATTRIBUTES') = 'Y' THEN
4334: IF NOT OE_VALIDATE.TP_Header_Desc_Flex
4335: (p_context => p_x_header_rec.tp_context
4336: ,p_attribute1 => p_x_header_rec.tp_attribute1
4337: ,p_attribute2 => p_x_header_rec.tp_attribute2