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_PRICE_PVT dependencies on DUAL

Line 5583: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics

5579: IF l_debug_level > 0 THEN
5580: oe_debug_pub.add('l_fulfilled_qty:'|| l_fulfilled_qty);
5581: END IF;
5582:
5583: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics
5584: (p_line_rec.inventory_item_id
5585: ,p_line_rec.ship_from_org_id
5586: ,l_item_rec) THEN
5587:

Line 5593: oe_debug_pub.add( 'DUAL - ONT_PRICING_QTY_SOURCE = S IN OEXVOPRB.PLS ' ) ;

5589: -- IF l_item_rec.ont_pricing_qty_source = 1 THEN -- INVCONV price by quantity 2
5590: IF p_line_rec.fulfillment_base IS NULL THEN --16206165 CW
5591: IF l_item_rec.ont_pricing_qty_source = 'S' THEN -- INVCONV
5592: IF l_debug_level > 0 THEN
5593: oe_debug_pub.add( 'DUAL - ONT_PRICING_QTY_SOURCE = S IN OEXVOPRB.PLS ' ) ;
5594: END IF;
5595: l_req_line_rec.LINE_QUANTITY := p_Line_rec.Ordered_quantity2 ;
5596: l_req_line_rec.LINE_UOM_CODE := p_Line_rec.Ordered_quantity_uom2 ;
5597: G_catchweight_qty_tbl(px_line_index) := p_line_rec.shipped_quantity2;

Line 5695: oe_debug_pub.add( 'DUAL - PRICING QUANTITY IS : ' ||L_REQ_LINE_REC.LINE_QUANTITY ) ;

5691:
5692: --16206165 CW end
5693:
5694: IF l_debug_level > 0 THEN
5695: oe_debug_pub.add( 'DUAL - PRICING QUANTITY IS : ' ||L_REQ_LINE_REC.LINE_QUANTITY ) ;
5696: END IF;
5697: IF l_debug_level > 0 THEN
5698: oe_debug_pub.add( 'DUAL - PRICING QUANTITY UOM IS : ' || L_REQ_LINE_REC.LINE_UOM_CODE )
5699: ;

Line 5698: oe_debug_pub.add( 'DUAL - PRICING QUANTITY UOM IS : ' || L_REQ_LINE_REC.LINE_UOM_CODE )

5694: IF l_debug_level > 0 THEN
5695: oe_debug_pub.add( 'DUAL - PRICING QUANTITY IS : ' ||L_REQ_LINE_REC.LINE_QUANTITY ) ;
5696: END IF;
5697: IF l_debug_level > 0 THEN
5698: oe_debug_pub.add( 'DUAL - PRICING QUANTITY UOM IS : ' || L_REQ_LINE_REC.LINE_UOM_CODE )
5699: ;
5700: END IF;
5701: -- Pack J catchweight
5702: ELSIF OE_CODE_CONTROL.Code_Release_level >= '110510' THEN

Line 6380: oe_debug_pub.add('Query individual line changed:'||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);

6376: ELSE
6377: -------------------------------------------------------------------
6378: --Pricing says passing only changed lines, use query_line
6379: --------------------------------------------------------------------
6380: oe_debug_pub.add('Query individual line changed:'||OE_Line_Adj_Util.G_CHANGED_LINE_TBL.count);
6381:
6382: --bug4529937 have put the code to query for changed lines in a procedure
6383: Query_Changed_Lines(p_header_id => p_header_id,
6384: x_line_tbl => l_line_tbl);

Line 6466: Select 'x' into l_dummy from dual

6462:
6463: -- Added to check if Agreement is Active for Bug#2740845
6464: If l_line_tbl(line_Tbl_Index).agreement_id is not null Then
6465: BEGIN
6466: Select 'x' into l_dummy from dual
6467: where exists (select 'x' from oe_agreements_vl where
6468: agreement_id = l_line_tbl(line_Tbl_Index).agreement_id and
6469: ( trunc(nvl(l_line_tbl(line_Tbl_Index).PRICING_DATE,sysdate))
6470: between

Line 6690: --If p_header_id is null means caller tries to price individual line

6686: --If we pass check_line_flag = 'N' to QP, this means a old behavior (pre I), or
6687: --we want to force sourcing and repricing of a line. This is usually the case
6688: --for action-->price_line call in UI.
6689:
6690: --If p_header_id is null means caller tries to price individual line
6691: --in this case, we should force a reprice of the line. No optimization
6692: --like to check the l_pass_line is needed #bug 289804100.
6693: --QP will need to unconditionally build sourcing.
6694: --BTEA

Line 6741: Select 'x' into l_dummy from dual

6737: ,p_honor_price_flag =>p_control_rec.p_honor_price_flag
6738: ,px_line_index => l_line_index );
6739: Begin
6740: l_header_id2:=nvl(p_header_id, l_line_tbl(line_tbl_index).header_id);
6741: Select 'x' into l_dummy from dual
6742: Where exists
6743: (select 'x' from oe_order_price_attribs oopa
6744: where nvl(oopa.line_id,l_Line_Tbl(line_Tbl_Index).line_id) = l_Line_Tbl(line_Tbl_Index).line_id
6745: and oopa.header_id = l_header_id2);

Line 6825: from dual where

6821: Begin
6822: BEGIN
6823:
6824: Select 'x' into l_dummy
6825: from dual where
6826: exists(select 'x' from oe_order_lines
6827: Where header_id = l_header_id
6828: and calculate_price_flag in ('Y','P')
6829: and item_type_code not in ('CONFIG', 'INCLUDED'));

Line 6841: from dual where

6837: END;
6838:
6839: IF l_completely_frozen = FALSE THEN
6840: Select 'p' into l_dummy
6841: from dual where
6842: exists (select 'x' from oe_order_lines
6843: where header_id = l_header_id
6844: and calculate_price_flag in ('N', 'P')
6845: and cancelled_flag = 'N'

Line 6894: Select 'x' into l_dummy from dual

6890: G_STMT_NO := 'calculate_adjustments#170';
6891:
6892: Begin
6893: l_header_id2:= nvl(p_header_id,l_line_tbl(l_line_tbl.first).header_id);
6894: Select 'x' into l_dummy from dual
6895: where exists(
6896: Select 'X' from oe_order_price_attribs oopa
6897: where oopa.header_id = l_header_id2 and oopa.line_id is null);
6898:

Line 7646: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

7642: IF l_line_rec.shipped_quantity is not null and l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
7643: vmsg := FND_MESSAGE.GET;
7644: oe_debug_pub.add('vmsg = '||vmsg,1);
7645: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7646: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7647: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7648: -- 4919922
7649: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7650: IF (G_REQUEST_ID IS NULL) THEN

Line 7651: select oe_msg_request_id_s.nextval into g_request_id from dual;

7647: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7648: -- 4919922
7649: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7650: IF (G_REQUEST_ID IS NULL) THEN
7651: select oe_msg_request_id_s.nextval into g_request_id from dual;
7652: END IF;
7653: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7654: END IF;
7655:

Line 7685: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

7681: IF l_debug_level > 0 THEN
7682: oe_debug_pub.add('vmsg = '||vmsg,1);
7683: END IF;
7684: pricing_errors_hold(l_line_rec.header_id,l_line_rec.line_id,vmsg);
7685: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7686:
7687: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7688: -- 4919922
7689: IF (OE_GLOBALS.G_UI_FLAG ) THEN

Line 7691: select oe_msg_request_id_s.nextval into g_request_id from dual;

7687: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7688: -- 4919922
7689: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7690: IF (G_REQUEST_ID IS NULL) THEN
7691: select oe_msg_request_id_s.nextval into g_request_id from dual;
7692: END IF;
7693: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7694: END IF;
7695:

Line 7704: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

7700: l_temp_line_rec.ordered_quantity := Wrong_line.line_quantity;
7701: oe_debug_pub.add('has invalid line3');
7702: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7703: oe_debug_pub.add('has invalid line4');
7704: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7705:
7706: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7707: -- 4919922
7708: IF (OE_GLOBALS.G_UI_FLAG ) THEN

Line 7710: select oe_msg_request_id_s.nextval into g_request_id from dual;

7706: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7707: -- 4919922
7708: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7709: IF (G_REQUEST_ID IS NULL) THEN
7710: select oe_msg_request_id_s.nextval into g_request_id from dual;
7711: END IF;
7712: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7713: END IF;
7714:

Line 7722: -- select oe_msg_request_id_s.nextval into l_request_id from dual;

7718: else
7719: l_temp_line_rec.line_id := Wrong_line.line_id;
7720: l_temp_line_rec.ordered_quantity := Wrong_line.line_quantity;
7721: l_temp_line_rec.pricing_quantity := Wrong_line.priced_quantity;
7722: -- select oe_msg_request_id_s.nextval into l_request_id from dual;
7723:
7724: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7725: -- 4919922
7726: IF (OE_GLOBALS.G_UI_FLAG ) THEN

Line 7728: select oe_msg_request_id_s.nextval into g_request_id from dual;

7724: -- OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, l_request_id,'U');
7725: -- 4919922
7726: IF (OE_GLOBALS.G_UI_FLAG ) THEN
7727: IF (G_REQUEST_ID IS NULL) THEN
7728: select oe_msg_request_id_s.nextval into g_request_id from dual;
7729: END IF;
7730: OE_MSG_PUB.INSERT_MESSAGE(OE_MSG_PUB.COUNT_MSG, G_REQUEST_ID,'U');
7731: END IF;
7732: