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 937: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;

933: )
934: IS
935: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
936: l_dummy VARCHAR2(10);
937: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
938: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
939: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
940:
941: l_agreement_name varchar2(240);

Line 938: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;

934: IS
935: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
936: l_dummy VARCHAR2(10);
937: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
938: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
939: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
940:
941: l_agreement_name varchar2(240);
942: l_agreement_revision varchar2(50);

Line 939: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;

935: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
936: l_dummy VARCHAR2(10);
937: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
938: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
939: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
940:
941: l_agreement_name varchar2(240);
942: l_agreement_revision varchar2(50);
943: l_sold_to_org number;

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

1255: oe_debug_pub.add('old curr ' || p_old_header_rec.transactional_curr_code,2);
1256: oe_debug_pub.add('New curr ' || p_header_rec.transactional_curr_code,2);
1257: -- Validate currency
1258:
1259: l_price_list_rec :=OE_Order_Cache.Load_Price_List (p_header_rec.price_list_id );
1260:
1261: --Added OR condition for CREATE Operation for bug 5060064
1262:
1263: IF (p_header_rec.price_list_id <>

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

1459:
1460: IF p_header_rec.agreement_id IS NOT NULL THEN
1461: -- commented by Geresh
1462: -- l_agreement_rec :=
1463: -- OE_Order_Cache.Load_Agreement (p_header_rec.agreement_id);
1464:
1465: BEGIN
1466: BEGIN
1467: select list_type_code

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

1615: raise FND_API.G_EXC_ERROR;
1616: END;
1617:
1618: -- l_order_type_rec :=
1619: -- OE_Order_Cache.Load_Order_Type (p_header_rec.order_type_id);
1620:
1621: /***
1622: IF (l_agreement_rec.sold_to_org_id IS NOT NULL AND
1623: l_agreement_rec.sold_to_org_id <>

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

3866: starts defaulting the FF */
3867: /* Fixing 2611912 to skip the Flex field validation in case of
3868: orders coming from CRM. This condition can be removed once process Order
3869: starts defaulting the FF */
3870: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_ATTRIBUTES') = 'Y' THEN
3871: -- AND p_x_header_rec.order_source_id <> 10 AND -- added for 2611912
3872: -- (p_x_header_rec.source_document_type_id IS NULL OR
3873: -- p_x_header_rec.source_document_type_id = FND_API.G_MISS_NUM OR
3874: -- p_x_header_rec.source_document_type_id = 2) THEN

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

4159: OE_DEBUG_PUB.ADD('Before G_header_desc_flex',2);
4160: /* Fixing 2375476 to skip the Flex field validation in case of
4161: Internal Orders. This condition will be removed once process Order
4162: starts defaulting the FF */
4163: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_GLOBAL_ATTRIBUTE') = 'Y' THEN
4164: -- AND p_x_header_rec.order_source_id <> 10 THEN
4165: IF NOT OE_VALIDATE.G_Header_Desc_Flex
4166: (p_context => p_x_header_rec.global_attribute_category
4167: ,p_attribute1 => p_x_header_rec.global_attribute1

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

4419: p_old_header_rec.tp_attribute15 IS NULL )))
4420:
4421: THEN
4422:
4423: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_HEADER_TP_ATTRIBUTES') = 'Y' THEN
4424: IF NOT OE_VALIDATE.TP_Header_Desc_Flex
4425: (p_context => p_x_header_rec.tp_context
4426: ,p_attribute1 => p_x_header_rec.tp_attribute1
4427: ,p_attribute2 => p_x_header_rec.tp_attribute2