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 OE_ORDER_UTIL

Line 2215: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

2211: END IF;
2212:
2213: l_notify_index := NULL;
2214:
2215: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
2216: p_header_id=>l_line_rec.header_id,
2217: --p_old_line_rec=>p_old_line_rec,
2218: --p_line_rec =>p_line_rec,
2219: p_line_id => l_line_rec.line_id,

Line 2232: oe_debug_pub.add(' Global OLD_LINE USP BEFORE ASSIGNMENT:'||OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).unit_selling_price);

2228:
2229: IF l_notify_index IS NOT NULL THEN
2230: IF l_debug_level > 0 THEN
2231: oe_debug_pub.add(' Global index obtained is:'||l_notify_index);
2232: oe_debug_pub.add(' Global OLD_LINE USP BEFORE ASSIGNMENT:'||OE_ORDER_UTIL.g_old_line_tbl(l_notify_index).unit_selling_price);
2233: oe_debug_pub.add(' p_old_line_rec.usp:'||p_old_line_rec.unit_selling_price);
2234: oe_debug_pub.add(' new line rec.usp:'||l_line_rec.unit_selling_price);
2235: END IF;
2236: --update Global Picture directly

Line 2237: --OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= p_old_line_rec;

2233: oe_debug_pub.add(' p_old_line_rec.usp:'||p_old_line_rec.unit_selling_price);
2234: oe_debug_pub.add(' new line rec.usp:'||l_line_rec.unit_selling_price);
2235: END IF;
2236: --update Global Picture directly
2237: --OE_ORDER_UTIL.g_old_line_tbl(l_notify_index):= p_old_line_rec;
2238:
2239: --As per HASHRAF 12/01/03 05:58 pm in bug 2920261
2240: --it could potentially undo bug 2806544
2241:

Line 2242: IF OE_ORDER_UTIL.g_line_tbl.exists(l_notify_index) Then

2238:
2239: --As per HASHRAF 12/01/03 05:58 pm in bug 2920261
2240: --it could potentially undo bug 2806544
2241:
2242: IF OE_ORDER_UTIL.g_line_tbl.exists(l_notify_index) Then
2243: If OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code IS NULL then
2244: --for the create case
2245: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
2246: End If;

Line 2243: If OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code IS NULL then

2239: --As per HASHRAF 12/01/03 05:58 pm in bug 2920261
2240: --it could potentially undo bug 2806544
2241:
2242: IF OE_ORDER_UTIL.g_line_tbl.exists(l_notify_index) Then
2243: If OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code IS NULL then
2244: --for the create case
2245: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
2246: End If;
2247: Else

Line 2245: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

2241:
2242: IF OE_ORDER_UTIL.g_line_tbl.exists(l_notify_index) Then
2243: If OE_ORDER_UTIL.g_line_tbl(l_notify_index).flow_status_code IS NULL then
2244: --for the create case
2245: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
2246: End If;
2247: Else
2248: --The record does not exists at all in g_line_tbl, creating one
2249: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

Line 2249: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);

2245: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
2246: End If;
2247: Else
2248: --The record does not exists at all in g_line_tbl, creating one
2249: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
2250: End If;
2251:
2252: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price:=l_line_rec.unit_selling_price;
2253: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price :=l_line_rec.unit_list_price;

Line 2252: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price:=l_line_rec.unit_selling_price;

2248: --The record does not exists at all in g_line_tbl, creating one
2249: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
2250: End If;
2251:
2252: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price:=l_line_rec.unit_selling_price;
2253: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price :=l_line_rec.unit_list_price;
2254: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price_per_pqty:=l_line_rec.unit_selling_price_per_pqty;
2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;

Line 2253: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price :=l_line_rec.unit_list_price;

2249: OE_ORDER_UTIL.g_line_tbl(l_notify_index):= OE_ORDER_UTIL.g_old_line_tbl(l_notify_index);
2250: End If;
2251:
2252: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price:=l_line_rec.unit_selling_price;
2253: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price :=l_line_rec.unit_list_price;
2254: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price_per_pqty:=l_line_rec.unit_selling_price_per_pqty;
2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;

Line 2254: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price_per_pqty:=l_line_rec.unit_selling_price_per_pqty;

2250: End If;
2251:
2252: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price:=l_line_rec.unit_selling_price;
2253: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price :=l_line_rec.unit_list_price;
2254: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price_per_pqty:=l_line_rec.unit_selling_price_per_pqty;
2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;

Line 2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;

2251:
2252: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price:=l_line_rec.unit_selling_price;
2253: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price :=l_line_rec.unit_list_price;
2254: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price_per_pqty:=l_line_rec.unit_selling_price_per_pqty;
2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;

Line 2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;

2252: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price:=l_line_rec.unit_selling_price;
2253: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price :=l_line_rec.unit_list_price;
2254: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price_per_pqty:=l_line_rec.unit_selling_price_per_pqty;
2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;

Line 2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;

2253: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price :=l_line_rec.unit_list_price;
2254: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price_per_pqty:=l_line_rec.unit_selling_price_per_pqty;
2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;

Line 2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;

2254: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_price_per_pqty:=l_line_rec.unit_selling_price_per_pqty;
2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;

Line 2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;

2255: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2263: --AS per Jyothi Narayan April 23 11:40, we need to assign line_id as well when it is a direct call from booking api

Line 2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;

2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2263: --AS per Jyothi Narayan April 23 11:40, we need to assign line_id as well when it is a direct call from booking api
2264:

Line 2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;

2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2263: --AS per Jyothi Narayan April 23 11:40, we need to assign line_id as well when it is a direct call from booking api
2264:
2265: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id :=nvl(OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id,l_line_rec.line_id);

Line 2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;

2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2263: --AS per Jyothi Narayan April 23 11:40, we need to assign line_id as well when it is a direct call from booking api
2264:
2265: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id :=nvl(OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id,l_line_rec.line_id);
2266:

Line 2265: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id :=nvl(OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id,l_line_rec.line_id);

2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2263: --AS per Jyothi Narayan April 23 11:40, we need to assign line_id as well when it is a direct call from booking api
2264:
2265: OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id :=nvl(OE_ORDER_UTIL.g_line_tbl(l_notify_index).line_id,l_line_rec.line_id);
2266:
2267:
2268:
2269: IF l_debug_level > 0 THEN

Line 2270: oe_debug_pub.add('Global picture OLD USP is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE);

2266:
2267:
2268:
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add('Global picture OLD USP is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE);
2271: oe_debug_pub.add('Global picture NEW USP is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE) ;
2272: oe_debug_pub.add('Global picture NEW OPR is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).operation);
2273: oe_debug_pub.add('Global picture OLD QTY is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2274: oe_debug_pub.add('Global picture NEW QTY is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);

Line 2271: oe_debug_pub.add('Global picture NEW USP is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE) ;

2267:
2268:
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add('Global picture OLD USP is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE);
2271: oe_debug_pub.add('Global picture NEW USP is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE) ;
2272: oe_debug_pub.add('Global picture NEW OPR is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).operation);
2273: oe_debug_pub.add('Global picture OLD QTY is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2274: oe_debug_pub.add('Global picture NEW QTY is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2275: END IF;

Line 2272: oe_debug_pub.add('Global picture NEW OPR is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).operation);

2268:
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add('Global picture OLD USP is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE);
2271: oe_debug_pub.add('Global picture NEW USP is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE) ;
2272: oe_debug_pub.add('Global picture NEW OPR is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).operation);
2273: oe_debug_pub.add('Global picture OLD QTY is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2274: oe_debug_pub.add('Global picture NEW QTY is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2275: END IF;
2276: END IF;

Line 2273: oe_debug_pub.add('Global picture OLD QTY is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);

2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add('Global picture OLD USP is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE);
2271: oe_debug_pub.add('Global picture NEW USP is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE) ;
2272: oe_debug_pub.add('Global picture NEW OPR is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).operation);
2273: oe_debug_pub.add('Global picture OLD QTY is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2274: oe_debug_pub.add('Global picture NEW QTY is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2275: END IF;
2276: END IF;
2277:

Line 2274: oe_debug_pub.add('Global picture NEW QTY is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);

2270: oe_debug_pub.add('Global picture OLD USP is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE);
2271: oe_debug_pub.add('Global picture NEW USP is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).UNIT_SELLING_PRICE) ;
2272: oe_debug_pub.add('Global picture NEW OPR is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).operation);
2273: oe_debug_pub.add('Global picture OLD QTY is:'||OE_ORDER_UTIL.G_OLD_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2274: oe_debug_pub.add('Global picture NEW QTY is:'||OE_ORDER_UTIL.G_LINE_TBL(L_NOTIFY_INDEX).ordered_quantity);
2275: END IF;
2276: END IF;
2277:
2278: END;

Line 3494: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,

3490: oe_debug_pub.add('list_line_id:'||l_Line_Adj_rec.list_line_id||'list_header_id:'||l_Line_Adj_rec.list_header_id);
3491: oe_debug_pub.add('last_update_date:'||l_Line_Adj_rec.last_update_date);
3492: END IF;
3493: --bug 3882620
3494: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3495: p_line_adj_rec =>l_line_adj_rec,
3496: p_line_adj_id => l_line_adj_rec.price_adjustment_id,
3497: p_old_line_adj_rec =>l_line_adj_rec,
3498: x_index => l_index,

Line 7099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));

7095: IF l_debug_level > 0 THEN
7096: oe_debug_pub.add( ' EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER' ) ;
7097: END IF;
7098: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7099: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
7100: OE_MSG_PUB.ADD;
7101: RAISE FND_API.G_EXC_ERROR;
7102: End If;
7103: IF l_debug_level > 0 THEN

Line 7460: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));

7456:
7457: If book_line.adjusted_unit_price IS NULL Then
7458: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7459: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7460: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
7461: OE_MSG_PUB.ADD;
7462: End If;
7463:
7464: If book_line.unit_price IS NULL

Line 7468: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));

7464: If book_line.unit_price IS NULL
7465: Then
7466: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7468: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
7469: IF l_debug_level > 0 THEN
7470: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
7471: END IF;
7472: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

Line 7491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));

7487: End If;
7488:
7489: If book_line.price_list_header_id IS NULL Then
7490: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');
7491: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
7492: OE_MSG_PUB.ADD;
7493: IF l_debug_level > 0 THEN
7494: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;
7495: END IF;

Line 7691: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl

7687: , p_init_msg_list => FND_API.G_FALSE
7688: , x_return_status => l_return_status
7689: , x_msg_count => l_msg_count
7690: , x_msg_data => l_msg_data
7691: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
7692: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl);
7693:
7694: IF l_debug_level > 0 THEN
7695: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;

Line 7692: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl);

7688: , x_return_status => l_return_status
7689: , x_msg_count => l_msg_count
7690: , x_msg_data => l_msg_data
7691: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
7692: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl);
7693:
7694: IF l_debug_level > 0 THEN
7695: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;
7696: END IF;