[Home] [Help]
165:
166: -- insted of modifying cursor, querying the line,
167: -- so that code remains clean.
168:
169: OE_Line_Util.Lock_Row( p_line_id => p_parent_line_id
170: ,p_x_line_rec => l_parent_line_rec
171: ,x_return_status => l_return_status);
172:
173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657:
658: -- insted of modifying cursor, querying the line,
659: -- so that code remains clean.
660:
661: OE_LINE_UTIL.Lock_Row(p_line_id => p_request_rec.param1,
662: p_x_line_rec => l_changed_line_rec,
663: x_return_status => l_return_status);
664:
665: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: --
842: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
843: --
844: BEGIN
845: OE_LINE_UTIL.Lock_Row(p_line_id => p_line_id
846: ,p_x_line_rec => l_line_rec
847: ,x_return_status => l_return_status);
848:
849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3287: IF l_debug_level > 0 THEN
3288: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.CREATE_HDR_XML' , 1);
3289: END IF;
3290:
3291: OE_LINE_UTIL.Query_Row(p_line_id => p_model_line_id
3292: ,x_line_rec => l_model_line_rec);
3293:
3294: -- now set the values from model_rec and org_id
3295: l_context_org_id :=
3809:
3810: -- Loop over fetched records
3811: FOR op in C1 LOOP
3812:
3813: OE_Line_Util.Query_Row( p_line_id => op.line_id
3814: ,x_line_rec => l_line_rec );
3815:
3816: IF (l_line_rec.open_flag = 'Y' OR
3817: p_send_cancel_lines = 'Y') AND
3880:
3881: -- Loop over fetched records
3882: FOR ato_option in C1 LOOP
3883:
3884: OE_Line_Util.Query_Row( p_line_id => ato_option.line_id
3885: ,x_line_rec => l_line_rec );
3886:
3887: IF (l_line_rec.open_flag = 'Y' OR
3888: p_send_cancel_lines = 'Y') AND
4074:
4075: -- Loop over fetched records
4076: FOR inc_item in C1 LOOP
4077:
4078: OE_Line_Util.Query_Row( p_line_id => inc_item.line_id
4079: ,x_line_rec => l_line_rec );
4080:
4081: IF (l_line_rec.open_flag = 'Y' OR
4082: p_send_cancel_lines = 'Y') AND
4113: Procedure Name : Process_Included_Items
4114: Description :
4115: This procedure is used to explode the included items for a
4116: PTO model/class or a kit. This procedure is called from
4117: oe_line_util if,
4118: the included items freeze method profile options is ENTRY or NULL.
4119: a new line is created in a booked order.
4120: a line with included items is schduled.
4121:
4294: oe_debug_pub.add('DO NOT LOCK' , 3 );
4295: END IF;
4296: ELSE
4297: IF p_line_id = FND_API.G_MISS_NUM THEN
4298: OE_LINE_UTIL.Lock_Row
4299: (p_line_id => p_line_rec.line_id
4300: ,p_x_line_rec => l_parent_line_rec
4301: ,x_return_status => l_return_status);
4302: -- Parent Line has been passed
4310: IF l_debug_level > 0 THEN
4311: oe_debug_pub.add('PARENT LINE_ID: '|| P_LINE_ID , 2 );
4312: END IF;
4313:
4314: OE_LINE_UTIL.Lock_Row
4315: (p_line_id => p_line_id
4316: ,p_x_line_rec => l_parent_line_rec
4317: ,x_return_status => l_return_status);
4318: END IF;
4913: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4914:
4915: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4916: IF p_line_id <> FND_API.G_MISS_NUM THEN
4917: OE_Line_Util.Query_Row(p_line_id => p_line_id
4918: ,x_line_rec => l_line_rec);
4919: ELSE
4920: RAISE FND_API.G_EXC_ERROR;
4921: END IF;
4979: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4980:
4981: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4982: IF p_line_id <> FND_API.G_MISS_NUM THEN
4983: OE_Line_Util.Query_Row(p_line_id => p_line_id
4984: ,x_line_rec => l_line_rec);
4985: ELSE
4986: RAISE FND_API.G_EXC_ERROR;
4987: END IF;
5044: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5045:
5046: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5047: IF p_line_id <> FND_API.G_MISS_NUM THEN
5048: OE_Line_Util.Query_Row(p_line_id => p_line_id
5049: ,x_line_rec => l_line_rec);
5050: ELSE
5051: RAISE FND_API.G_EXC_ERROR;
5052: END IF;
5107: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5108:
5109: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5110: IF p_line_id <> FND_API.G_MISS_NUM THEN
5111: OE_Line_Util.Query_Row(p_line_id => p_line_id
5112: ,x_line_rec => l_line_rec);
5113: ELSE
5114: RAISE FND_API.G_EXC_ERROR;
5115: END IF;
5170: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5171:
5172: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5173: IF p_line_id <> FND_API.G_MISS_NUM THEN
5174: OE_Line_Util.Query_Row(p_line_id => p_line_id
5175: ,x_line_rec => l_line_rec);
5176: ELSE
5177: RAISE FND_API.G_EXC_ERROR;
5178: END IF;
5237: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5238:
5239: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5240: IF p_line_id <> FND_API.G_MISS_NUM THEN
5241: OE_Line_Util.Query_Row(p_line_id => p_line_id
5242: ,x_line_rec => l_line_rec);
5243: ELSE
5244: RAISE FND_API.G_EXC_ERROR;
5245: END IF;
5300: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5301:
5302: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5303: IF p_line_id <> FND_API.G_MISS_NUM THEN
5304: OE_Line_Util.Query_Row(p_line_id => p_line_id
5305: ,x_line_rec => l_line_rec);
5306: ELSE
5307: RAISE FND_API.G_EXC_ERROR;
5308: END IF;
5366: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5367:
5368: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5369: IF p_line_id <> FND_API.G_MISS_NUM THEN
5370: OE_Line_Util.Query_Row(p_line_id => p_line_id
5371: ,x_line_rec => l_line_rec);
5372: ELSE
5373: RAISE FND_API.G_EXC_ERROR;
5374: END IF;
5430: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5431:
5432: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5433: IF p_line_id <> FND_API.G_MISS_NUM THEN
5434: OE_Line_Util.Query_Row(p_line_id => p_line_id
5435: ,x_line_rec => l_line_rec);
5436: ELSE
5437: RAISE FND_API.G_EXC_ERROR;
5438: END IF;
5496: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5497:
5498: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5499: IF p_line_id <> FND_API.G_MISS_NUM THEN
5500: OE_Line_Util.Query_Row(p_line_id => p_line_id
5501: ,x_line_rec => l_line_rec);
5502: ELSE
5503: RAISE FND_API.G_EXC_ERROR;
5504: END IF;
5558: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5559:
5560: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5561: IF p_line_id <> FND_API.G_MISS_NUM THEN
5562: OE_Line_Util.Query_Row(p_line_id => p_line_id
5563: ,x_line_rec => l_line_rec);
5564: ELSE
5565: RAISE FND_API.G_EXC_ERROR;
5566: END IF;
5678: LOOP
5679: FETCH l_line_csr into l_line_id;
5680: EXIT WHEN l_line_csr%NOTFOUND;
5681:
5682: OE_Line_Util.Query_Row( p_line_id => l_line_id
5683: ,x_line_rec => l_line_rec );
5684:
5685: x_line_tbl(x_line_tbl.COUNT + 1) := l_line_rec;
5686:
7873: for included items. To improce performance of
7874: saving included items, we will set the
7875: control_rec.change_attributes parameter to FALSE.
7876: Hence all the delayed requests logged in
7877: oe_line_util.apply_attribute_changes procedure for
7878: included_items will be logged here.
7879: --------------------------------------------------------*/
7880: PROCEDURE Log_Included_Item_Requests
7881: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type