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 2216: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2256: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_price_per_pqty:=l_line_rec.unit_list_price_per_pqty;
2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2263: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2264: --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 2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;

2257: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity :=l_line_rec.pricing_quantity;
2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2263: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2264: --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
2265:

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

2258: OE_ORDER_UTIL.g_line_tbl(l_notify_index).pricing_quantity_uom :=l_line_rec.pricing_quantity_uom;
2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2263: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2264: --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
2265:
2266: 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 2263: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;

2259: OE_ORDER_UTIL.g_line_tbl(l_notify_index).price_list_id := l_line_rec.price_list_id;
2260: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_list_percent :=l_line_rec.unit_list_percent;
2261: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_percent_base_price :=l_line_rec.unit_percent_base_price;
2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2263: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2264: --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
2265:
2266: 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);
2267:

Line 2266: 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);

2262: OE_ORDER_UTIL.g_line_tbl(l_notify_index).unit_selling_percent :=l_line_rec.unit_selling_percent;
2263: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation :=l_line_rec.operation;
2264: --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
2265:
2266: 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);
2267:
2268:
2269:
2270: IF l_debug_level > 0 THEN

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

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

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

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

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

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

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

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

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

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

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

3565: oe_debug_pub.add('list_line_id:'||l_Line_Adj_rec.list_line_id||'list_header_id:'||l_Line_Adj_rec.list_header_id);
3566: oe_debug_pub.add('last_update_date:'||l_Line_Adj_rec.last_update_date);
3567: END IF;
3568: --bug 3882620
3569: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3570: p_line_adj_rec =>l_line_adj_rec,
3571: p_line_adj_id => l_line_adj_rec.price_adjustment_id,
3572: p_old_line_adj_rec =>l_line_adj_rec,
3573: x_index => l_index,

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

3605: l_Header_Adj_rec.adjusted_amount := p_adjusted_amount_tbl(i);
3606: l_Header_Adj_rec.last_update_date := sysdate;
3607:
3608:
3609: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3610: p_hdr_adj_rec =>l_header_adj_rec,
3611: p_hdr_adj_id => l_header_adj_rec.price_adjustment_id,
3612: p_old_hdr_adj_rec =>l_header_adj_rec,
3613: x_index => l_index,

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

7377: IF l_debug_level > 0 THEN
7378: oe_debug_pub.add( ' EXCEPTION: PRICE LIST MISSING FOR BOOKED ORDER' ) ;
7379: END IF;
7380: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7381: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.GET_ATTRIBUTE_NAME('UNIT_LIST_PRICE'));
7382: OE_MSG_PUB.ADD;
7383: -- Bug 8236945
7384: IF OE_GLOBALS.G_UI_FLAG THEN
7385: RAISE FND_API.G_EXC_ERROR;

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

7743:
7744: If book_line.adjusted_unit_price IS NULL Then
7745: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7746: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7747: OE_Order_UTIL.Get_Attribute_Name('UNIT_SELLING_PRICE'));
7748: OE_MSG_PUB.ADD;
7749: End If;
7750:
7751: If book_line.unit_price IS NULL

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

7751: If book_line.unit_price IS NULL
7752: Then
7753: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
7754: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7755: OE_Order_UTIL.Get_Attribute_Name('UNIT_LIST_PRICE'));
7756: IF l_debug_level > 0 THEN
7757: oe_debug_pub.add( ' ERROR: UNIT LIST PRICE CAN NOT BE NULL' ) ;
7758: END IF;
7759: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN

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

7779: End If;
7780:
7781: If book_line.price_list_header_id IS NULL Then
7782: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRUIBUTE');
7783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_ORDER_UTIL.Get_Attribute_Name('PRICE_LIST_ID'));
7784: OE_MSG_PUB.ADD;
7785: IF l_debug_level > 0 THEN
7786: oe_debug_pub.add( ' ERROR: PRICE LIST ID CAN NOT BE NULL' ) ;
7787: END IF;

Line 7994: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl

7990: , p_init_msg_list => FND_API.G_FALSE
7991: , x_return_status => l_return_status
7992: , x_msg_count => l_msg_count
7993: , x_msg_data => l_msg_data
7994: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
7995: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl);
7996:
7997: IF l_debug_level > 0 THEN
7998: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;

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

7991: , x_return_status => l_return_status
7992: , x_msg_count => l_msg_count
7993: , x_msg_data => l_msg_data
7994: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
7995: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl);
7996:
7997: IF l_debug_level > 0 THEN
7998: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;
7999: END IF;