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_ORDER_ADJ_PVT dependencies on OE_LINE_UTIL

Line 4147: -- IF oe_line_util.Process_Characteristics -- INVCONV

4143: px_req_line_tbl(l_line_index).LINE_UOM_CODE := p_Line_rec.Order_quantity_uom;
4144: px_req_line_tbl(l_line_index).PRICED_QUANTITY := p_Line_rec.pricing_quantity; -- OPM 2547940 moved this up to here from below next block
4145:
4146: -- start OPM 2046190
4147: -- IF oe_line_util.Process_Characteristics -- INVCONV
4148: IF oe_line_util.dual_uom_control -- INVCONV
4149: (p_line_rec.inventory_item_id
4150: ,p_line_rec.ship_from_org_id
4151: ,l_item_rec) THEN

Line 4148: IF oe_line_util.dual_uom_control -- INVCONV

4144: px_req_line_tbl(l_line_index).PRICED_QUANTITY := p_Line_rec.pricing_quantity; -- OPM 2547940 moved this up to here from below next block
4145:
4146: -- start OPM 2046190
4147: -- IF oe_line_util.Process_Characteristics -- INVCONV
4148: IF oe_line_util.dual_uom_control -- INVCONV
4149: (p_line_rec.inventory_item_id
4150: ,p_line_rec.ship_from_org_id
4151: ,l_item_rec) THEN
4152:

Line 4285: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(p_Line_rec);

4281: p_pricing_event ='SHIP' Then
4282: px_req_line_tbl(l_line_index).PRICE_FLAG := 'N';
4283: End If;
4284:
4285: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(p_Line_rec);
4286:
4287: -- Do not fetch the price for Configuration items and Included Items
4288: If l_item_type_code in( 'CONFIG','INCLUDED')
4289: Then

Line 5410: oe_line_util.query_row(p_Reference_line_Id,L_Line_Rec );

5406: -- Parent Line is not found in px_line_tbl
5407: Begin
5408: line_Tbl_index := px_line_tbl.count+1;
5409:
5410: oe_line_util.query_row(p_Reference_line_Id,L_Line_Rec );
5411: px_Line_Tbl(line_Tbl_index) := L_Line_Rec;
5412: -- Parent Line is only for info purpose, don't calculate price
5413: -- px_Line_Tbl(line_Tbl_index).calculate_price_flag := 'N';
5414: -- modified by lkxu, to be used in repricing

Line 5676: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);

5672: ----------------------------------------------------------------
5673: --Pricing says pass all lines, use query_lines is more efficient
5674: ----------------------------------------------------------------
5675: adj_debug('Query all_lines');
5676: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);
5677: g_pass_all_lines:='Y';
5678: Elsif l_order_status_rec.CHANGED_LINES_FLAG = 'Y' OR nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'N' Then
5679: -------------------------------------------------------------------
5680: --Pricing says pass only changed lines, use query_line

Line 5691: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

5687: --bug 3020702
5688: oe_debug_pub.add(' header_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).header_id);
5689: if oe_line_adj_util.G_CHANGED_LINE_TBL(i).header_id = p_header_id then
5690: oe_debug_pub.add(' trying to query line_id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5691: l_line_tbl(j):=oe_line_util.query_row(p_line_id =>Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);
5692: j:=j+1;
5693: end if;
5694: Exception when no_data_found then
5695: oe_debug_pub.add('Not found line id:'||Oe_Line_Adj_Util.G_CHANGED_LINE_TBL(i).line_id);

Line 5726: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);

5722: -- only to pass all lines when the returned all_lines_flag is Y.
5723: IF G_PASS_ALL_LINES = 'Y' THEN
5724: Begin
5725: adj_debug('querying up all lines in header: '||p_Header_id,3);
5726: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);
5727: --1472635
5728: l_all_lines_from_db := True;
5729: Exception when no_data_found then
5730: -- No need to process this order

Line 5742: oe_line_util.query_rows(p_line_id =>p_line_id, x_line_tbl=>l_Line_Tbl );

5738: G_STMT_NO := 'calculate_adjustments#50';
5739: If x_line_Tbl.count = 0 Then
5740: Begin
5741:
5742: oe_line_util.query_rows(p_line_id =>p_line_id, x_line_tbl=>l_Line_Tbl );
5743:
5744:
5745: Exception when no_data_found then
5746: -- No need to process this line

Line 5818: --If oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl(line_Tbl_Index)) <> 'CONFIG' Then

5814: End If;
5815: --End 2124989
5816:
5817: -- Do not price the config items
5818: --If oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl(line_Tbl_Index)) <> 'CONFIG' Then
5819:
5820:
5821: -- Populate that Global Structure
5822: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);

Line 6053: /*oe_line_util.query_rows(p_header_id =>l_header_id, x_line_tbl=>l_temp_Line_Tbl );

6049: l_header_id := p_header_id;
6050: End If;
6051: --adj_debug('BCT order header id '||l_header_id);
6052:
6053: /*oe_line_util.query_rows(p_header_id =>l_header_id, x_line_tbl=>l_temp_Line_Tbl );
6054: i2 := l_temp_line_tbl.first;
6055: While i2 is not Null Loop
6056: If l_temp_line_tbl(i2).calculate_price_flag In ('N','P') Then
6057: --adj_debug('BCT2000 any frozen line found');

Line 7406: OE_Line_Util.Query_Row

7402: -- End 2270949
7403:
7404: G_STMT_NO := 'Process_Other_Item_Line#20';
7405:
7406: OE_Line_Util.Query_Row
7407: ( p_Line_id => l_line_Adj_Rec.Line_Id
7408: , x_line_rec => l_line_rec);
7409:
7410: if l_line_rec.operation = FND_API.G_MISS_CHAR then

Line 8212: l_process := -- INVCONV oe_line_util.Process_Characteristics -- OPM 2547940

8208: G_STMT_NO := 'Calculate_Price#10';
8209: i:= p_Line_Tbl.First;
8210: adj_debug('Honor Price flag :'||p_honor_price_flag,2);
8211: While i is not null Loop
8212: l_process := -- INVCONV oe_line_util.Process_Characteristics -- OPM 2547940
8213: oe_line_util.dual_uom_control -- INVCONV
8214: (p_line_tbl(i).inventory_item_id
8215: ,p_line_tbl(i).ship_from_org_id
8216: ,l_item_rec);

Line 8213: oe_line_util.dual_uom_control -- INVCONV

8209: i:= p_Line_Tbl.First;
8210: adj_debug('Honor Price flag :'||p_honor_price_flag,2);
8211: While i is not null Loop
8212: l_process := -- INVCONV oe_line_util.Process_Characteristics -- OPM 2547940
8213: oe_line_util.dual_uom_control -- INVCONV
8214: (p_line_tbl(i).inventory_item_id
8215: ,p_line_tbl(i).ship_from_org_id
8216: ,l_item_rec);
8217:

Line 8638: IF oe_line_util.dual_uom_control -- INVCONV

8634: END IF;
8635:
8636: -- OPM 2547940 start - if pricing by quantity2 then if line is shipped and has shipped qty2 != ordered qty2
8637: -- need to adjust the operand so that invoicing will show correct amount (ordered qty * USP (adjusted) )
8638: IF oe_line_util.dual_uom_control -- INVCONV
8639: -- Process_Characteristics invconv
8640: (p_line_tbl(i).inventory_item_id
8641: ,p_line_tbl(i).ship_from_org_id
8642: ,l_item_rec) THEN

Line 8655: END IF; --oe_line_util.dual_uom_control -- INVCONV

8651: * (p_line_tbl(i).shipped_quantity2/p_line_tbl(i).ordered_quantity);
8652: oe_debug_pub.ADD('OPM NEW operand : '|| to_char(p_Line_Adj_Tbl(j).operand),5);
8653: END IF;
8654: END IF;
8655: END IF; --oe_line_util.dual_uom_control -- INVCONV
8656: -- OPM 2547940 end
8657:
8658:
8659: Else

Line 8680: IF oe_line_util.dual_uom_control -- INVCONV PROCESS_CHAR

8676:
8677: -- OPM 2547940 start - if pricing by quantity2 then if line is shipped and has shipped qty2 != ordered qty2
8678: -- need to adjust the adjusted_amount so that invoicing will show correct amount (ordered qty * USP (adjusted) )
8679:
8680: IF oe_line_util.dual_uom_control -- INVCONV PROCESS_CHAR
8681:
8682: (p_line_tbl(i).inventory_item_id
8683: ,p_line_tbl(i).ship_from_org_id
8684: ,l_item_rec) THEN

Line 8695: END IF; --oe_line_util.dual_uom_control -- INVCONV

8691: p_Line_Adj_Tbl(j).adjusted_amount := (p_Line_Adj_tbl(j).adjusted_amount_per_pqty* p_line_tbl(i).pricing_quantity )/p_line_tbl(i).ordered_quantity2
8692: * (p_line_tbl(i).shipped_quantity2/p_line_tbl(i).ordered_quantity);
8693: END IF;
8694: END IF;
8695: END IF; --oe_line_util.dual_uom_control -- INVCONV
8696: -- OPM 2547940 end
8697:
8698:
8699: If G_DEBUG Then

Line 8908: OE_Line_Util.Query_Row(p_Line_id => l_prg_line_id,

8904: END IF;
8905:
8906: IF NOT l_found_prg_line then
8907: adj_debug('PRG not in p_line_tbl, so query for line '||l_prg_line_id);
8908: OE_Line_Util.Query_Row(p_Line_id => l_prg_line_id,
8909: x_line_rec => l_line_rec);
8910: END IF;
8911:
8912: if (l_line_rec.booked_flag <> 'Y' OR

Line 9109: OE_Line_Util.Query_Row

9105:
9106: If x_Line_Tbl.count = 0 Then
9107: Begin
9108:
9109: OE_Line_Util.Query_Row
9110: ( p_Line_id => p_req_line_tbl(i).line_id
9111: , x_line_rec => l_line_rec);
9112: Exception when no_data_found then
9113: null;

Line 9114: adj_debug('process_adjustments OE_Line_Util.Query_Row , no data found');

9110: ( p_Line_id => p_req_line_tbl(i).line_id
9111: , x_line_rec => l_line_rec);
9112: Exception when no_data_found then
9113: null;
9114: adj_debug('process_adjustments OE_Line_Util.Query_Row , no data found');
9115: End;
9116: Else
9117: J:= x_Line_Tbl.First;
9118: While J is not null loop

Line 9360: ( ( oe_line_util.dual_uom_control -- INVCONV

9356:
9357: or -- OPM 2547940 start
9358: -- pricing by quantity2 - this is for case when order line is split from shipping and new line gets generated
9359: -- and this line has to be re-priced for catchweight pricing for OPM if pricing in secondary quantity
9360: ( ( oe_line_util.dual_uom_control -- INVCONV
9361: (l_line_rec.inventory_item_id
9362: ,l_line_rec.ship_from_org_id
9363: ,l_item_rec) )
9364: and p_req_line_tbl(i).line_Type_code ='LINE'

Line 9587: oe_line_util.Get_Return_Item_Type_Code

9583: and (
9584: ((
9585: ( l_line_tbl.exists( p_req_line_detail_Tbl(j).line_index)
9586: and
9587: oe_line_util.Get_Return_Item_Type_Code
9588: (l_line_tbl( p_req_line_detail_Tbl(j).line_index))<> 'INCLUDED'
9589: )
9590: Or not l_line_tbl.exists (p_req_line_detail_Tbl(j).line_index )
9591:

Line 10143: If oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG') then

10139: adj_debug('Payment_term , before process order '||l_line_tbl(i).payment_term_id,2);
10140: End If;
10141:
10142: -- uom begin
10143: If oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG') then
10144: l_line_tbl(i).unit_list_price_per_pqty := 0;
10145: end if;
10146:
10147: If l_line_tbl(i).unit_Selling_price_per_pqty is null or

Line 10148: oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG')

10144: l_line_tbl(i).unit_list_price_per_pqty := 0;
10145: end if;
10146:
10147: If l_line_tbl(i).unit_Selling_price_per_pqty is null or
10148: oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG')
10149: then
10150: l_line_tbl(i).unit_Selling_price_per_pqty := l_line_tbl(i).unit_list_price_per_pqty;
10151: end if;
10152:

Line 10163: IF oe_line_util.dual_uom_control -- INVCONV

10159:
10160: -- OPM 2547940 start - if pricing by quantity2 then if line is shipped and has shipped qty2 != ordered qty2
10161: -- need to adjust the unit selling price so that invoicing will show correct amount (ordered qty * USP (adjusted) )
10162:
10163: IF oe_line_util.dual_uom_control -- INVCONV
10164: (l_line_tbl(i).inventory_item_id
10165: ,l_line_tbl(i).ship_from_org_id
10166: ,l_item_rec) THEN
10167: IF l_item_rec.ont_pricing_qty_source = 'S' THEN -- price by quantity 2 -- INVCONV

Line 10178: END IF; --oe_line_util.dual_uom_control -- INVCONV

10174: * (l_line_tbl(i).shipped_quantity2/l_line_tbl(i).ordered_quantity);
10175: oe_debug_pub.ADD('OPM NEW USP : '|| to_char(l_line_tbl(i).unit_selling_price),5);
10176: END IF;
10177: END IF;
10178: END IF; --oe_line_util.dual_uom_control -- INVCONV
10179: -- OPM 2547940 end
10180:
10181:
10182: -- uom end

Line 10281: OE_LINE_UTIL.Lock_Row(x_return_status => x_return_status,

10277: Else
10278: l_line_tbl_final(l).operation := OE_GLOBALS.G_OPR_UPDATE;
10279: l_num_changed_lines := l_num_changed_lines + 1;
10280: adj_debug('lock row '||i||' '||l_old_line_tbl(l).line_id,1);
10281: OE_LINE_UTIL.Lock_Row(x_return_status => x_return_status,
10282: p_x_line_rec => l_old_line_tbl(l)
10283: );
10284:
10285: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 10411: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl_Final(j));

10407: IF l_Line_Tbl_Final(j).unit_selling_price IS NULL
10408: OR l_line_tbl_final(j).unit_list_price IS NULL
10409: OR l_line_tbl_final(j).price_list_id IS NULL THEN
10410: --
10411: l_item_type_code := oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl_Final(j));
10412: --
10413: IF (l_item_type_code <> 'CONFIG'
10414: AND l_item_type_code <> 'INCLUDED') THEN
10415: --

Line 10867: OE_Line_Util.Query_Rows(p_line_id => p_line_id

10863: OE_MSG_PUB.Add;
10864: END IF;
10865: RAISE FND_API.G_EXC_ERROR;
10866: elsif (px_line_Tbl.count = 0) Then
10867: OE_Line_Util.Query_Rows(p_line_id => p_line_id
10868: , x_line_tbl => px_line_tbl);
10869: end if;
10870: adj_debug('lines count'||px_line_tbl.count);
10871: l_source_document_type_id := px_line_Tbl(1).source_document_type_id;

Line 11209: oe_line_util.query_rows(

11205: l_Req_Control_Rec.Simulation_Flag := 'N';
11206:
11207: If p_header_id is null then
11208:
11209: oe_line_util.query_rows(
11210: p_line_id => p_line_id
11211: , x_line_tbl => l_line_tbl1
11212: );
11213:

Line 11225: oe_line_util.query_rows(

11221: p_header_id => p_header_id
11222: , x_header_rec => l_header_rec
11223: );
11224:
11225: oe_line_util.query_rows(
11226: p_header_id => p_header_id
11227: , x_line_tbl => l_Line_Tbl1
11228: );
11229: end if;

Line 11351: If oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG') then

11347: l_line_tbl(i).change_comments := 'PRICING';
11348: adj_debug('Audit Reason passed as '||l_line_tbl(i).change_reason,1);
11349:
11350: -- uom begin
11351: If oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG') then
11352: l_line_tbl(i).unit_list_price_per_pqty := 0;
11353: l_line_tbl(i).pricing_quantity := l_line_tbl(i).ordered_quantity;
11354: l_line_tbl(i).pricing_quantity_uom := l_line_tbl(i).order_quantity_uom;
11355: end if;

Line 11358: oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG')

11354: l_line_tbl(i).pricing_quantity_uom := l_line_tbl(i).order_quantity_uom;
11355: end if;
11356:
11357: If l_line_tbl(i).unit_Selling_price_per_pqty is null or
11358: oe_line_util.Get_Return_Item_Type_Code(l_line_tbl(i)) in ('INCLUDED', 'CONFIG')
11359: then
11360: l_line_tbl(i).unit_Selling_price_per_pqty := l_line_tbl(i).unit_list_price_per_pqty;
11361:
11362: End If;

Line 11374: IF oe_line_util.dual_uom_control -- invconv

11370:
11371: -- OPM 2547940 start - if pricing by quantity2 then if line is shipped and has shipped qty2 != ordered qty2
11372: -- need to adjust the adjusted_amount so that invoicing will show correct amount (ordered qty * USP (adjusted) )
11373:
11374: IF oe_line_util.dual_uom_control -- invconv
11375: (l_line_tbl(i).inventory_item_id
11376: ,l_line_tbl(i).ship_from_org_id
11377: ,l_item_rec) THEN
11378: IF l_item_rec.ont_pricing_qty_source = 'S' THEN -- price by quantity 2 -- INVCONV

Line 11391: END IF; --oe_line_util.dual_uom_control -- INVCONV

11387: * (l_line_tbl(i).shipped_quantity2/l_line_tbl(i).ordered_quantity);
11388:
11389: END IF;
11390: END IF;
11391: END IF; --oe_line_util.dual_uom_control -- INVCONV
11392: -- OPM 2547940 end
11393:
11394: oe_debug_pub.add('unit price'||l_line_tbl(i).unit_list_price||'+'||l_line_tbl(i).unit_selling_price,1);
11395: oe_debug_pub.add('unit price per pqty'||l_line_tbl(i).unit_list_price_per_pqty||'+'||l_line_tbl(i).unit_selling_price_per_pqty,1);

Line 11590: oe_Line_util.query_row(

11586: ELSE
11587: adj_debug('Old price_action way, order has no prg');
11588: Begin
11589: l_x_line_tbl(i).Line_id := l_Line_id;
11590: oe_Line_util.query_row(
11591: p_Line_id => l_Line_id
11592: , x_line_rec => l_x_Line_Tbl(i)
11593: );
11594: Exception when no_data_found then

Line 11656: oe_Line_util.query_row(

11652: IF (l_new_header or last_record_line_id = l_line_id) and l_x_line_tbl.count > 0 THEN
11653: IF last_record_line_id = l_line_id and l_prev_line_hdr_id = l_header_id THEN
11654: Begin
11655: l_x_line_tbl(j).Line_id := l_Line_id;
11656: oe_Line_util.query_row(
11657: p_Line_id => l_Line_id
11658: , x_line_rec => l_x_Line_Tbl(j)
11659: );
11660: Exception when no_data_found then

Line 11685: oe_Line_util.query_row(

11681:
11682: adj_debug('Old price_action way, order has no prg');
11683: Begin
11684: l_x_line_tbl(j).Line_id := l_Line_id;
11685: oe_Line_util.query_row(
11686: p_Line_id => l_Line_id
11687: , x_line_rec => l_x_Line_Tbl(j)
11688: );
11689: j := j + 1;

Line 11963: oe_Line_util.query_row(

11959: adj_debug('Old price_action way, order has no prg');
11960: Begin
11961:
11962: l_x_line_tbl(i).Line_id := l_Line_id;
11963: oe_Line_util.query_row(
11964: p_Line_id => l_Line_id
11965: , x_line_rec => l_x_Line_Tbl(i)
11966: );
11967: Exception when no_data_found then

Line 12635: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);

12631: if not (p_level = 'ORDER' and p_freight_flag) then --- bug 7655559
12632: --passing all lines under this header
12633: oe_debug_pub.add(' Query Rows under same header');
12634:
12635: oe_Line_util.query_rows(p_header_id => p_Header_id, x_line_tbl => l_Line_Tbl);
12636: oe_debug_pub.add('#of rows returned='|| to_char(l_line_tbl.count));
12637: oe_debug_pub.add('no.rows in l_line_tbl = '|| to_char(l_line_tbl.count));
12638:
12639: -- Bug 1713035

Line 12671: --oe_line_util.query_row(p_line_id =>p_line_id,x_line_rec=>l_line_rec);

12667:
12668: Elsif p_line_id is not null Then
12669: --just pass one line
12670: oe_debug_pub.add(' Query Rows under for line line id:'||p_line_id);
12671: --oe_line_util.query_row(p_line_id =>p_line_id,x_line_rec=>l_line_rec);
12672:
12673: -- Bug 1713035
12674: -- Use oe_oe_form_line.get_line instead of query_rows
12675: oe_debug_pub.add('calling get_line in oe_oe_form_line');