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_ADV_PRICE_PVT dependencies on OE_DEBUG_PUB

Line 12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

8: G_REQUEST_ID NUMBER:=NULL;
9:
10: procedure Adj_Debug (p_text IN VARCHAR2, p_level IN NUMBER:=5) As
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13: --
14: Begin
15: If G_DEBUG Then
16: IF l_debug_level > 0 THEN

Line 17: oe_debug_pub.add( P_TEXT , P_LEVEL ) ;

13: --
14: Begin
15: If G_DEBUG Then
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add( P_TEXT , P_LEVEL ) ;
18: END IF;
19: End If;
20: End Adj_Debug;
21:

Line 28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

24: px_price_line_id_tbl IN OUT NOCOPY Oe_Order_Adj_Pvt.Index_Tbl_Type)
25: IS
26: l_line_index Number;
27: --
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: --
30: Begin
31:
32: l_line_index := px_line_tbl.First;

Line 61: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

57: l_index NUMBER:=1;
58: l_new_line_tbl OE_Order_Pub.Line_Tbl_Type;
59: l_old_line_tbl OE_Order_Pub.Line_Tbl_Type;
60: --
61: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
62: --
63: BEGIN
64: IF l_debug_level > 0 THEN
65: oe_debug_pub.add( 'INSIDE CALL PROCESS ORDER' , 1 ) ;

Line 65: oe_debug_pub.add( 'INSIDE CALL PROCESS ORDER' , 1 ) ;

61: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
62: --
63: BEGIN
64: IF l_debug_level > 0 THEN
65: oe_debug_pub.add( 'INSIDE CALL PROCESS ORDER' , 1 ) ;
66: END IF;
67: IF px_line_tbl.COUNT > 0 THEN
68: l_line_index := px_line_tbl.first;
69: while l_line_index is not null loop

Line 72: oe_debug_pub.add('Operation none or null:'||px_line_tbl(l_line_index).line_id||' from px_line_tbl' , 1 ) ;

68: l_line_index := px_line_tbl.first;
69: while l_line_index is not null loop
70: IF nvl(px_line_tbl(l_line_index).operation,OE_GLOBALS.G_OPR_NONE) = OE_GLOBALS.G_OPR_NONE THEN
71: IF l_debug_level > 0 THEN
72: oe_debug_pub.add('Operation none or null:'||px_line_tbl(l_line_index).line_id||' from px_line_tbl' , 1 ) ;
73: END IF;
74: --Do nothing on this line. None operation
75: NULL;
76: ELSE

Line 78: oe_debug_pub.add('Deleting line id:'||px_line_tbl(l_line_index).line_id||' from px_line_tbl' , 1 ) ;

74: --Do nothing on this line. None operation
75: NULL;
76: ELSE
77: IF l_debug_level > 0 THEN
78: oe_debug_pub.add('Deleting line id:'||px_line_tbl(l_line_index).line_id||' from px_line_tbl' , 1 ) ;
79: END IF;
80: l_new_line_tbl(l_index):=px_line_tbl(l_line_index);
81: oe_debug_pub.add(' l_index:'||l_index);
82: oe_debug_pub.add(' l_line_index:'||l_line_index);

Line 81: oe_debug_pub.add(' l_index:'||l_index);

77: IF l_debug_level > 0 THEN
78: oe_debug_pub.add('Deleting line id:'||px_line_tbl(l_line_index).line_id||' from px_line_tbl' , 1 ) ;
79: END IF;
80: l_new_line_tbl(l_index):=px_line_tbl(l_line_index);
81: oe_debug_pub.add(' l_index:'||l_index);
82: oe_debug_pub.add(' l_line_index:'||l_line_index);
83: oe_debug_pub.add(' new_line_tbl.count:'||px_line_tbl.count);
84: oe_debug_pub.add(' old_line_tbl.count:'||px_old_line_tbl.count);
85:

Line 82: oe_debug_pub.add(' l_line_index:'||l_line_index);

78: oe_debug_pub.add('Deleting line id:'||px_line_tbl(l_line_index).line_id||' from px_line_tbl' , 1 ) ;
79: END IF;
80: l_new_line_tbl(l_index):=px_line_tbl(l_line_index);
81: oe_debug_pub.add(' l_index:'||l_index);
82: oe_debug_pub.add(' l_line_index:'||l_line_index);
83: oe_debug_pub.add(' new_line_tbl.count:'||px_line_tbl.count);
84: oe_debug_pub.add(' old_line_tbl.count:'||px_old_line_tbl.count);
85:
86: IF px_old_line_tbl.exists(l_line_index) THEN

Line 83: oe_debug_pub.add(' new_line_tbl.count:'||px_line_tbl.count);

79: END IF;
80: l_new_line_tbl(l_index):=px_line_tbl(l_line_index);
81: oe_debug_pub.add(' l_index:'||l_index);
82: oe_debug_pub.add(' l_line_index:'||l_line_index);
83: oe_debug_pub.add(' new_line_tbl.count:'||px_line_tbl.count);
84: oe_debug_pub.add(' old_line_tbl.count:'||px_old_line_tbl.count);
85:
86: IF px_old_line_tbl.exists(l_line_index) THEN
87: l_old_line_tbl(l_index):=px_old_line_tbl(l_line_index);

Line 84: oe_debug_pub.add(' old_line_tbl.count:'||px_old_line_tbl.count);

80: l_new_line_tbl(l_index):=px_line_tbl(l_line_index);
81: oe_debug_pub.add(' l_index:'||l_index);
82: oe_debug_pub.add(' l_line_index:'||l_line_index);
83: oe_debug_pub.add(' new_line_tbl.count:'||px_line_tbl.count);
84: oe_debug_pub.add(' old_line_tbl.count:'||px_old_line_tbl.count);
85:
86: IF px_old_line_tbl.exists(l_line_index) THEN
87: l_old_line_tbl(l_index):=px_old_line_tbl(l_line_index);
88: END IF;

Line 109: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_PVT.HEADER' , 1 ) ;

105:
106: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
107:
108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_PVT.HEADER' , 1 ) ;
110: oe_debug_pub.add( 'LX_OLD_HEADER_REC.HEADER_ID='||LX_OLD_HEADER_REC.HEADER_ID , 1 ) ;
111: oe_debug_pub.add( 'LX_OLD_HEADER_REC.PAYMENT_TERM_ID='||LX_OLD_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
112: oe_debug_pub.add( 'LX_OLD_HEADER_REC.OPERATION='||LX_OLD_HEADER_REC.OPERATION , 1 ) ;
113: oe_debug_pub.add( 'PX_HEADER_REC.HEADER_ID='||PX_HEADER_REC.HEADER_ID , 1 ) ;

Line 110: oe_debug_pub.add( 'LX_OLD_HEADER_REC.HEADER_ID='||LX_OLD_HEADER_REC.HEADER_ID , 1 ) ;

106: OE_GLOBALS.G_PRICING_RECURSION := 'Y';
107:
108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_PVT.HEADER' , 1 ) ;
110: oe_debug_pub.add( 'LX_OLD_HEADER_REC.HEADER_ID='||LX_OLD_HEADER_REC.HEADER_ID , 1 ) ;
111: oe_debug_pub.add( 'LX_OLD_HEADER_REC.PAYMENT_TERM_ID='||LX_OLD_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
112: oe_debug_pub.add( 'LX_OLD_HEADER_REC.OPERATION='||LX_OLD_HEADER_REC.OPERATION , 1 ) ;
113: oe_debug_pub.add( 'PX_HEADER_REC.HEADER_ID='||PX_HEADER_REC.HEADER_ID , 1 ) ;
114: oe_debug_pub.add( 'PX_HEADER_REC.PAYMENT_TERM_ID='||PX_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;

Line 111: oe_debug_pub.add( 'LX_OLD_HEADER_REC.PAYMENT_TERM_ID='||LX_OLD_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;

107:
108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_PVT.HEADER' , 1 ) ;
110: oe_debug_pub.add( 'LX_OLD_HEADER_REC.HEADER_ID='||LX_OLD_HEADER_REC.HEADER_ID , 1 ) ;
111: oe_debug_pub.add( 'LX_OLD_HEADER_REC.PAYMENT_TERM_ID='||LX_OLD_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
112: oe_debug_pub.add( 'LX_OLD_HEADER_REC.OPERATION='||LX_OLD_HEADER_REC.OPERATION , 1 ) ;
113: oe_debug_pub.add( 'PX_HEADER_REC.HEADER_ID='||PX_HEADER_REC.HEADER_ID , 1 ) ;
114: oe_debug_pub.add( 'PX_HEADER_REC.PAYMENT_TERM_ID='||PX_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
115: oe_debug_pub.add( 'PX_HEADER_REC.OPERATION='||PX_HEADER_REC.OPERATION , 1 ) ;

Line 112: oe_debug_pub.add( 'LX_OLD_HEADER_REC.OPERATION='||LX_OLD_HEADER_REC.OPERATION , 1 ) ;

108: IF l_debug_level > 0 THEN
109: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_PVT.HEADER' , 1 ) ;
110: oe_debug_pub.add( 'LX_OLD_HEADER_REC.HEADER_ID='||LX_OLD_HEADER_REC.HEADER_ID , 1 ) ;
111: oe_debug_pub.add( 'LX_OLD_HEADER_REC.PAYMENT_TERM_ID='||LX_OLD_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
112: oe_debug_pub.add( 'LX_OLD_HEADER_REC.OPERATION='||LX_OLD_HEADER_REC.OPERATION , 1 ) ;
113: oe_debug_pub.add( 'PX_HEADER_REC.HEADER_ID='||PX_HEADER_REC.HEADER_ID , 1 ) ;
114: oe_debug_pub.add( 'PX_HEADER_REC.PAYMENT_TERM_ID='||PX_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
115: oe_debug_pub.add( 'PX_HEADER_REC.OPERATION='||PX_HEADER_REC.OPERATION , 1 ) ;
116: END IF;

Line 113: oe_debug_pub.add( 'PX_HEADER_REC.HEADER_ID='||PX_HEADER_REC.HEADER_ID , 1 ) ;

109: oe_debug_pub.add( 'BEFORE CALLING OE_ORDER_PVT.HEADER' , 1 ) ;
110: oe_debug_pub.add( 'LX_OLD_HEADER_REC.HEADER_ID='||LX_OLD_HEADER_REC.HEADER_ID , 1 ) ;
111: oe_debug_pub.add( 'LX_OLD_HEADER_REC.PAYMENT_TERM_ID='||LX_OLD_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
112: oe_debug_pub.add( 'LX_OLD_HEADER_REC.OPERATION='||LX_OLD_HEADER_REC.OPERATION , 1 ) ;
113: oe_debug_pub.add( 'PX_HEADER_REC.HEADER_ID='||PX_HEADER_REC.HEADER_ID , 1 ) ;
114: oe_debug_pub.add( 'PX_HEADER_REC.PAYMENT_TERM_ID='||PX_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
115: oe_debug_pub.add( 'PX_HEADER_REC.OPERATION='||PX_HEADER_REC.OPERATION , 1 ) ;
116: END IF;
117:

Line 114: oe_debug_pub.add( 'PX_HEADER_REC.PAYMENT_TERM_ID='||PX_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;

110: oe_debug_pub.add( 'LX_OLD_HEADER_REC.HEADER_ID='||LX_OLD_HEADER_REC.HEADER_ID , 1 ) ;
111: oe_debug_pub.add( 'LX_OLD_HEADER_REC.PAYMENT_TERM_ID='||LX_OLD_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
112: oe_debug_pub.add( 'LX_OLD_HEADER_REC.OPERATION='||LX_OLD_HEADER_REC.OPERATION , 1 ) ;
113: oe_debug_pub.add( 'PX_HEADER_REC.HEADER_ID='||PX_HEADER_REC.HEADER_ID , 1 ) ;
114: oe_debug_pub.add( 'PX_HEADER_REC.PAYMENT_TERM_ID='||PX_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
115: oe_debug_pub.add( 'PX_HEADER_REC.OPERATION='||PX_HEADER_REC.OPERATION , 1 ) ;
116: END IF;
117:
118: IF (px_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) Then

Line 115: oe_debug_pub.add( 'PX_HEADER_REC.OPERATION='||PX_HEADER_REC.OPERATION , 1 ) ;

111: oe_debug_pub.add( 'LX_OLD_HEADER_REC.PAYMENT_TERM_ID='||LX_OLD_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
112: oe_debug_pub.add( 'LX_OLD_HEADER_REC.OPERATION='||LX_OLD_HEADER_REC.OPERATION , 1 ) ;
113: oe_debug_pub.add( 'PX_HEADER_REC.HEADER_ID='||PX_HEADER_REC.HEADER_ID , 1 ) ;
114: oe_debug_pub.add( 'PX_HEADER_REC.PAYMENT_TERM_ID='||PX_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
115: oe_debug_pub.add( 'PX_HEADER_REC.OPERATION='||PX_HEADER_REC.OPERATION , 1 ) ;
116: END IF;
117:
118: IF (px_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) Then
119: OE_Order_Pvt.Header

Line 162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

158: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
159: l_ordered_item varchar2(300);
160:
161: --
162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
163: --
164: begin
165:
166: IF l_debug_level > 0 THEN

Line 167: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.SET_ITEM_FOR_IUE' ) ;

163: --
164: begin
165:
166: IF l_debug_level > 0 THEN
167: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.SET_ITEM_FOR_IUE' ) ;
168:
169: /*sdatti*/
170: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.INVENTORY_ITEM_ID,1);
171: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.original_INVENTORY_ITEM_ID,1);

Line 170: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.INVENTORY_ITEM_ID,1);

166: IF l_debug_level > 0 THEN
167: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.SET_ITEM_FOR_IUE' ) ;
168:
169: /*sdatti*/
170: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.INVENTORY_ITEM_ID,1);
171: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.original_INVENTORY_ITEM_ID,1);
172: oe_debug_pub.ADD('px_line_rec.original_ordered_item_id:'||px_line_rec.ordered_item_id,1);
173: oe_debug_pub.ADD('px_line_rec.original_item_identifier_type:'||px_line_rec.item_identifier_type,1);
174: oe_debug_pub.ADD('px_line_rec.original_ordered_item:'||px_line_rec.ordered_item,1);

Line 171: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.original_INVENTORY_ITEM_ID,1);

167: oe_debug_pub.add( 'ENTERING OE_ORDER_PRICE_PVT.SET_ITEM_FOR_IUE' ) ;
168:
169: /*sdatti*/
170: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.INVENTORY_ITEM_ID,1);
171: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.original_INVENTORY_ITEM_ID,1);
172: oe_debug_pub.ADD('px_line_rec.original_ordered_item_id:'||px_line_rec.ordered_item_id,1);
173: oe_debug_pub.ADD('px_line_rec.original_item_identifier_type:'||px_line_rec.item_identifier_type,1);
174: oe_debug_pub.ADD('px_line_rec.original_ordered_item:'||px_line_rec.ordered_item,1);
175:

Line 172: oe_debug_pub.ADD('px_line_rec.original_ordered_item_id:'||px_line_rec.ordered_item_id,1);

168:
169: /*sdatti*/
170: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.INVENTORY_ITEM_ID,1);
171: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.original_INVENTORY_ITEM_ID,1);
172: oe_debug_pub.ADD('px_line_rec.original_ordered_item_id:'||px_line_rec.ordered_item_id,1);
173: oe_debug_pub.ADD('px_line_rec.original_item_identifier_type:'||px_line_rec.item_identifier_type,1);
174: oe_debug_pub.ADD('px_line_rec.original_ordered_item:'||px_line_rec.ordered_item,1);
175:
176:

Line 173: oe_debug_pub.ADD('px_line_rec.original_item_identifier_type:'||px_line_rec.item_identifier_type,1);

169: /*sdatti*/
170: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.INVENTORY_ITEM_ID,1);
171: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.original_INVENTORY_ITEM_ID,1);
172: oe_debug_pub.ADD('px_line_rec.original_ordered_item_id:'||px_line_rec.ordered_item_id,1);
173: oe_debug_pub.ADD('px_line_rec.original_item_identifier_type:'||px_line_rec.item_identifier_type,1);
174: oe_debug_pub.ADD('px_line_rec.original_ordered_item:'||px_line_rec.ordered_item,1);
175:
176:
177: END IF;

Line 174: oe_debug_pub.ADD('px_line_rec.original_ordered_item:'||px_line_rec.ordered_item,1);

170: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.INVENTORY_ITEM_ID,1);
171: oe_debug_pub.ADD('px_line_rec.original_inventory_item_id:'||px_line_rec.original_INVENTORY_ITEM_ID,1);
172: oe_debug_pub.ADD('px_line_rec.original_ordered_item_id:'||px_line_rec.ordered_item_id,1);
173: oe_debug_pub.ADD('px_line_rec.original_item_identifier_type:'||px_line_rec.item_identifier_type,1);
174: oe_debug_pub.ADD('px_line_rec.original_ordered_item:'||px_line_rec.ordered_item,1);
175:
176:
177: END IF;
178:

Line 192: oe_debug_pub.add( 'PX_LINE_REC.INVENTORY_ITEM_ID ='||PX_LINE_REC.INVENTORY_ITEM_ID ) ;

188:
189: -- There is an item upgrade for this line
190: px_line_rec.inventory_item_id := p_related_item_id;
191: IF l_debug_level > 0 THEN
192: oe_debug_pub.add( 'PX_LINE_REC.INVENTORY_ITEM_ID ='||PX_LINE_REC.INVENTORY_ITEM_ID ) ;
193: END IF;
194: px_line_rec.item_identifier_type := 'INT'; --bug 2281351
195: If px_line_rec.item_identifier_type ='INT' then
196: px_line_rec.ordered_item_id := p_related_item_id;

Line 208: oe_debug_pub.add( 'EXITING OE_ORDER_ADJ_PVT.SET_ITEM_FOR_IUE' ) ;

204: Null;
205: End;
206: End If;
207: IF l_debug_level > 0 THEN
208: oe_debug_pub.add( 'EXITING OE_ORDER_ADJ_PVT.SET_ITEM_FOR_IUE' ) ;
209: END IF;
210: end set_item_for_iue;
211:
212:

Line 218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

214: is
215: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
216: l_return_status VARCHAR2(30);
217: l_index NUMBER;
218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
219:
220: begin
221: l_Line_Adj_rec.operation := OE_GLOBALS.G_OPR_DELETE;
222: l_Line_Adj_rec.price_adjustment_id := p_price_adjustment_id;

Line 231: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE IS: ' || L_RETURN_STATUS ) ;

227: x_index => l_index,
228: x_return_status => l_return_status);
229:
230: IF l_debug_level > 0 THEN
231: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE IS: ' || L_RETURN_STATUS ) ;
232: END IF;
233:
234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235:

Line 237: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

233:
234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235:
236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
238: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' , 1 ) ;
239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 238: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' , 1 ) ;

234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
235:
236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
238: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' , 1 ) ;
239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: IF l_debug_level > 0 THEN

Line 243: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' ) ;

239: END IF;
240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' ) ;
244: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' , 1 ) ;
245: END IF;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;

Line 244: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' , 1 ) ;

240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.DELETE_ATTRIBS_FOR_IUE' ) ;
244: oe_debug_pub.add( 'EXITING OE_ORDER_PRICE_PVT.DELETE_DEPENDENTS' , 1 ) ;
245: END IF;
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:

Line 300: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

296: i number;
297: l_header_id number := oe_order_cache.g_header_rec.header_id;
298:
299: --
300: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
301: --
302: BEGIN
303:
304:

Line 312: oe_debug_pub.add( 'REVERT BACK ITEM'||I.LINE_ID ) ;

308:
309: -- AmyIUE: let's revert back the following way
310: FOR i in revert_back_items LOOP
311: IF l_debug_level > 0 THEN
312: oe_debug_pub.add( 'REVERT BACK ITEM'||I.LINE_ID ) ;
313: END IF;
314: --bug 2858712
315: IF (px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).line_set_id IS NULL OR
316: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).line_set_id = FND_API.G_MISS_NUM) THEN

Line 559: oe_debug_pub.add( 'in upgraded items cursor');

555: );
556:
557: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'in upgraded items cursor');
560: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
561: END IF;
562: END IF;
563: END IF;

Line 560: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;

556:
557: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'in upgraded items cursor');
560: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
561: END IF;
562: END IF;
563: END IF;
564: END LOOP;

Line 623: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

619: l_count NUMBER;
620: --bug 4190357
621: l_old_shipping_method_code Varchar2(30); --bug 4190357
622: --
623: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
624: --
625: BEGIN
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'IN TERMS SUBSTITUTION' , 1 ) ;

Line 627: oe_debug_pub.add( 'IN TERMS SUBSTITUTION' , 1 ) ;

623: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
624: --
625: BEGIN
626: IF l_debug_level > 0 THEN
627: oe_debug_pub.add( 'IN TERMS SUBSTITUTION' , 1 ) ;
628: END IF;
629:
630: If G_DEBUG Then
631: for l in ldets_cur loop

Line 632: oe_debug_pub.add( 'LINE_INDEX='||L.LINE_INDEX , 1 ) ;

628: END IF;
629:
630: If G_DEBUG Then
631: for l in ldets_cur loop
632: oe_debug_pub.add( 'LINE_INDEX='||L.LINE_INDEX , 1 ) ;
633: oe_debug_pub.add( 'LINE_DETAIL_INDEX='||L.LINE_DETAIL_INDEX , 1 ) ;
634: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='||L.LINE_DETAIL_TYPE_CODE , 1 ) ;
635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;
636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;

Line 633: oe_debug_pub.add( 'LINE_DETAIL_INDEX='||L.LINE_DETAIL_INDEX , 1 ) ;

629:
630: If G_DEBUG Then
631: for l in ldets_cur loop
632: oe_debug_pub.add( 'LINE_INDEX='||L.LINE_INDEX , 1 ) ;
633: oe_debug_pub.add( 'LINE_DETAIL_INDEX='||L.LINE_DETAIL_INDEX , 1 ) ;
634: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='||L.LINE_DETAIL_TYPE_CODE , 1 ) ;
635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;
636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;
637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;

Line 634: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='||L.LINE_DETAIL_TYPE_CODE , 1 ) ;

630: If G_DEBUG Then
631: for l in ldets_cur loop
632: oe_debug_pub.add( 'LINE_INDEX='||L.LINE_INDEX , 1 ) ;
633: oe_debug_pub.add( 'LINE_DETAIL_INDEX='||L.LINE_DETAIL_INDEX , 1 ) ;
634: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='||L.LINE_DETAIL_TYPE_CODE , 1 ) ;
635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;
636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;
637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;
638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;

Line 635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;

631: for l in ldets_cur loop
632: oe_debug_pub.add( 'LINE_INDEX='||L.LINE_INDEX , 1 ) ;
633: oe_debug_pub.add( 'LINE_DETAIL_INDEX='||L.LINE_DETAIL_INDEX , 1 ) ;
634: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='||L.LINE_DETAIL_TYPE_CODE , 1 ) ;
635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;
636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;
637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;
638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;
639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;

Line 636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;

632: oe_debug_pub.add( 'LINE_INDEX='||L.LINE_INDEX , 1 ) ;
633: oe_debug_pub.add( 'LINE_DETAIL_INDEX='||L.LINE_DETAIL_INDEX , 1 ) ;
634: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='||L.LINE_DETAIL_TYPE_CODE , 1 ) ;
635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;
636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;
637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;
638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;
639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;
640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;

Line 637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;

633: oe_debug_pub.add( 'LINE_DETAIL_INDEX='||L.LINE_DETAIL_INDEX , 1 ) ;
634: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='||L.LINE_DETAIL_TYPE_CODE , 1 ) ;
635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;
636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;
637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;
638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;
639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;
640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;
641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;

Line 638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;

634: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='||L.LINE_DETAIL_TYPE_CODE , 1 ) ;
635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;
636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;
637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;
638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;
639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;
640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;
641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;
642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;

Line 639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;

635: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_ID='||L.CREATED_FROM_LIST_LINE_ID , 1 ) ;
636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;
637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;
638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;
639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;
640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;
641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;
642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;
643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;

Line 640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;

636: oe_debug_pub.add( 'CREATED_FROM_LIST_LINE_TYPE='||L.CREATED_FROM_LIST_LINE_TYPE , 1 ) ;
637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;
638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;
639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;
640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;
641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;
642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;
643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;
644: oe_debug_pub.add( 'APPLIED_FLAG='||L.APPLIED_FLAG , 1 ) ;

Line 641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;

637: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='||L.CREATED_FROM_LIST_TYPE_CODE , 1 ) ;
638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;
639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;
640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;
641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;
642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;
643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;
644: oe_debug_pub.add( 'APPLIED_FLAG='||L.APPLIED_FLAG , 1 ) ;
645: oe_debug_pub.add( 'PROCESS_CODE='||L.PROCESS_CODE , 1 ) ;

Line 642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;

638: oe_debug_pub.add( 'SUBSTITUTION_TYPE_CODE='||L.SUBSTITUTION_TYPE_CODE , 1 ) ;
639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;
640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;
641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;
642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;
643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;
644: oe_debug_pub.add( 'APPLIED_FLAG='||L.APPLIED_FLAG , 1 ) ;
645: oe_debug_pub.add( 'PROCESS_CODE='||L.PROCESS_CODE , 1 ) ;
646: oe_debug_pub.add( 'UPDATED_FLAG='||L.UPDATED_FLAG , 1 ) ;

Line 643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;

639: oe_debug_pub.add( 'SUBSTITUTION_VALUE_FROM='||L.SUBSTITUTION_VALUE_FROM , 1 ) ;
640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;
641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;
642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;
643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;
644: oe_debug_pub.add( 'APPLIED_FLAG='||L.APPLIED_FLAG , 1 ) ;
645: oe_debug_pub.add( 'PROCESS_CODE='||L.PROCESS_CODE , 1 ) ;
646: oe_debug_pub.add( 'UPDATED_FLAG='||L.UPDATED_FLAG , 1 ) ;
647:

Line 644: oe_debug_pub.add( 'APPLIED_FLAG='||L.APPLIED_FLAG , 1 ) ;

640: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO='||L.SUBSTITUTION_VALUE_TO , 1 ) ;
641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;
642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;
643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;
644: oe_debug_pub.add( 'APPLIED_FLAG='||L.APPLIED_FLAG , 1 ) ;
645: oe_debug_pub.add( 'PROCESS_CODE='||L.PROCESS_CODE , 1 ) ;
646: oe_debug_pub.add( 'UPDATED_FLAG='||L.UPDATED_FLAG , 1 ) ;
647:
648: end loop;

Line 645: oe_debug_pub.add( 'PROCESS_CODE='||L.PROCESS_CODE , 1 ) ;

641: oe_debug_pub.add( 'PROCESSED_FLAG='||L.PROCESSED_FLAG , 1 ) ;
642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;
643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;
644: oe_debug_pub.add( 'APPLIED_FLAG='||L.APPLIED_FLAG , 1 ) ;
645: oe_debug_pub.add( 'PROCESS_CODE='||L.PROCESS_CODE , 1 ) ;
646: oe_debug_pub.add( 'UPDATED_FLAG='||L.UPDATED_FLAG , 1 ) ;
647:
648: end loop;
649:

Line 646: oe_debug_pub.add( 'UPDATED_FLAG='||L.UPDATED_FLAG , 1 ) ;

642: oe_debug_pub.add( 'PRICING_STATUS_CODE='||L.PRICING_STATUS_CODE , 1 ) ;
643: oe_debug_pub.add( 'PRICING_PHASE_ID='||L.PRICING_PHASE_ID , 1 ) ;
644: oe_debug_pub.add( 'APPLIED_FLAG='||L.APPLIED_FLAG , 1 ) ;
645: oe_debug_pub.add( 'PROCESS_CODE='||L.PROCESS_CODE , 1 ) ;
646: oe_debug_pub.add( 'UPDATED_FLAG='||L.UPDATED_FLAG , 1 ) ;
647:
648: end loop;
649:
650: for k in test loop

Line 651: oe_debug_pub.add( 'LINE_INDEX = '||K.LINE_INDEX , 1 ) ;

647:
648: end loop;
649:
650: for k in test loop
651: oe_debug_pub.add( 'LINE_INDEX = '||K.LINE_INDEX , 1 ) ;
652: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||K.SUBSTITUTION_ATTRIBUTE , 1 ) ;
653: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||K.SUBSTITUTION_VALUE_TO , 1 ) ;
654: oe_debug_pub.add( 'PROCESS_CODE = '||K.PROCESS_CODE , 1 ) ;
655: end loop;

Line 652: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||K.SUBSTITUTION_ATTRIBUTE , 1 ) ;

648: end loop;
649:
650: for k in test loop
651: oe_debug_pub.add( 'LINE_INDEX = '||K.LINE_INDEX , 1 ) ;
652: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||K.SUBSTITUTION_ATTRIBUTE , 1 ) ;
653: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||K.SUBSTITUTION_VALUE_TO , 1 ) ;
654: oe_debug_pub.add( 'PROCESS_CODE = '||K.PROCESS_CODE , 1 ) ;
655: end loop;
656: End If; --end if for g_debug

Line 653: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||K.SUBSTITUTION_VALUE_TO , 1 ) ;

649:
650: for k in test loop
651: oe_debug_pub.add( 'LINE_INDEX = '||K.LINE_INDEX , 1 ) ;
652: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||K.SUBSTITUTION_ATTRIBUTE , 1 ) ;
653: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||K.SUBSTITUTION_VALUE_TO , 1 ) ;
654: oe_debug_pub.add( 'PROCESS_CODE = '||K.PROCESS_CODE , 1 ) ;
655: end loop;
656: End If; --end if for g_debug
657:

Line 654: oe_debug_pub.add( 'PROCESS_CODE = '||K.PROCESS_CODE , 1 ) ;

650: for k in test loop
651: oe_debug_pub.add( 'LINE_INDEX = '||K.LINE_INDEX , 1 ) ;
652: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||K.SUBSTITUTION_ATTRIBUTE , 1 ) ;
653: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||K.SUBSTITUTION_VALUE_TO , 1 ) ;
654: oe_debug_pub.add( 'PROCESS_CODE = '||K.PROCESS_CODE , 1 ) ;
655: end loop;
656: End If; --end if for g_debug
657:
658: FOR i in new_terms LOOP

Line 660: oe_debug_pub.add( 'L_HEADER_ID = '||L_HEADER_ID , 1 ) ;

656: End If; --end if for g_debug
657:
658: FOR i in new_terms LOOP
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add( 'L_HEADER_ID = '||L_HEADER_ID , 1 ) ;
661: oe_debug_pub.add( 'LINE INDEX = '||I.LINE_INDEX , 1 ) ;
662: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||I.SUBSTITUTION_ATTRIBUTE , 1 ) ;
663: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||I.SUBSTITUTION_VALUE_TO , 1 ) ;
664: oe_debug_pub.add('change rason code = '||I.CHANGE_REASON_CODE);

Line 661: oe_debug_pub.add( 'LINE INDEX = '||I.LINE_INDEX , 1 ) ;

657:
658: FOR i in new_terms LOOP
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add( 'L_HEADER_ID = '||L_HEADER_ID , 1 ) ;
661: oe_debug_pub.add( 'LINE INDEX = '||I.LINE_INDEX , 1 ) ;
662: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||I.SUBSTITUTION_ATTRIBUTE , 1 ) ;
663: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||I.SUBSTITUTION_VALUE_TO , 1 ) ;
664: oe_debug_pub.add('change rason code = '||I.CHANGE_REASON_CODE);
665: oe_debug_pub.add('change reason text = '||I.CHANGE_REASON_TEXT);

Line 662: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||I.SUBSTITUTION_ATTRIBUTE , 1 ) ;

658: FOR i in new_terms LOOP
659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add( 'L_HEADER_ID = '||L_HEADER_ID , 1 ) ;
661: oe_debug_pub.add( 'LINE INDEX = '||I.LINE_INDEX , 1 ) ;
662: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||I.SUBSTITUTION_ATTRIBUTE , 1 ) ;
663: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||I.SUBSTITUTION_VALUE_TO , 1 ) ;
664: oe_debug_pub.add('change rason code = '||I.CHANGE_REASON_CODE);
665: oe_debug_pub.add('change reason text = '||I.CHANGE_REASON_TEXT);
666: END IF;

Line 663: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||I.SUBSTITUTION_VALUE_TO , 1 ) ;

659: IF l_debug_level > 0 THEN
660: oe_debug_pub.add( 'L_HEADER_ID = '||L_HEADER_ID , 1 ) ;
661: oe_debug_pub.add( 'LINE INDEX = '||I.LINE_INDEX , 1 ) ;
662: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||I.SUBSTITUTION_ATTRIBUTE , 1 ) ;
663: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||I.SUBSTITUTION_VALUE_TO , 1 ) ;
664: oe_debug_pub.add('change rason code = '||I.CHANGE_REASON_CODE);
665: oe_debug_pub.add('change reason text = '||I.CHANGE_REASON_TEXT);
666: END IF;
667:

Line 664: oe_debug_pub.add('change rason code = '||I.CHANGE_REASON_CODE);

660: oe_debug_pub.add( 'L_HEADER_ID = '||L_HEADER_ID , 1 ) ;
661: oe_debug_pub.add( 'LINE INDEX = '||I.LINE_INDEX , 1 ) ;
662: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||I.SUBSTITUTION_ATTRIBUTE , 1 ) ;
663: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||I.SUBSTITUTION_VALUE_TO , 1 ) ;
664: oe_debug_pub.add('change rason code = '||I.CHANGE_REASON_CODE);
665: oe_debug_pub.add('change reason text = '||I.CHANGE_REASON_TEXT);
666: END IF;
667:
668: -- for header level term substitution, needs to update all lines

Line 665: oe_debug_pub.add('change reason text = '||I.CHANGE_REASON_TEXT);

661: oe_debug_pub.add( 'LINE INDEX = '||I.LINE_INDEX , 1 ) ;
662: oe_debug_pub.add( 'SUBSTITUTION_ATTRIBUTE = '||I.SUBSTITUTION_ATTRIBUTE , 1 ) ;
663: oe_debug_pub.add( 'SUBSTITUTION_VALUE_TO = '||I.SUBSTITUTION_VALUE_TO , 1 ) ;
664: oe_debug_pub.add('change rason code = '||I.CHANGE_REASON_CODE);
665: oe_debug_pub.add('change reason text = '||I.CHANGE_REASON_TEXT);
666: END IF;
667:
668: -- for header level term substitution, needs to update all lines
669: IF (i.line_id = l_header_id and i.line_type_code = 'ORDER') THEN

Line 696: oe_debug_pub.add( 'J = '||J , 1 ) ;

692: -- LOOP through all lines, update terms on the line
693: j := px_line_tbl.FIRST;
694: WHILE j Is Not Null loop
695: IF l_debug_level > 0 THEN
696: oe_debug_pub.add( 'J = '||J , 1 ) ;
697: oe_debug_pub.add( 'LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID , 1 ) ;
698: oe_debug_pub.add( 'INDEX IN SORTED TABLE = '||G_PRICE_LINE_ID_TBL ( PX_LINE_TBL ( J ) .LINE_ID ) , 1 ) ;
699: END IF;
700:

Line 697: oe_debug_pub.add( 'LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID , 1 ) ;

693: j := px_line_tbl.FIRST;
694: WHILE j Is Not Null loop
695: IF l_debug_level > 0 THEN
696: oe_debug_pub.add( 'J = '||J , 1 ) ;
697: oe_debug_pub.add( 'LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID , 1 ) ;
698: oe_debug_pub.add( 'INDEX IN SORTED TABLE = '||G_PRICE_LINE_ID_TBL ( PX_LINE_TBL ( J ) .LINE_ID ) , 1 ) ;
699: END IF;
700:
701: If G_DEBUG Then

Line 698: oe_debug_pub.add( 'INDEX IN SORTED TABLE = '||G_PRICE_LINE_ID_TBL ( PX_LINE_TBL ( J ) .LINE_ID ) , 1 ) ;

694: WHILE j Is Not Null loop
695: IF l_debug_level > 0 THEN
696: oe_debug_pub.add( 'J = '||J , 1 ) ;
697: oe_debug_pub.add( 'LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID , 1 ) ;
698: oe_debug_pub.add( 'INDEX IN SORTED TABLE = '||G_PRICE_LINE_ID_TBL ( PX_LINE_TBL ( J ) .LINE_ID ) , 1 ) ;
699: END IF;
700:
701: If G_DEBUG Then
702: for m in oe_price_adj_cur(px_line_tbl(j).line_id) loop

Line 703: oe_debug_pub.add( 'PRICE_ADJUSTMENT_ID='||M.PRICE_ADJUSTMENT_ID , 1 ) ;

699: END IF;
700:
701: If G_DEBUG Then
702: for m in oe_price_adj_cur(px_line_tbl(j).line_id) loop
703: oe_debug_pub.add( 'PRICE_ADJUSTMENT_ID='||M.PRICE_ADJUSTMENT_ID , 1 ) ;
704: oe_debug_pub.add( 'LIST_LINE_ID='||M.LIST_LINE_ID , 1 ) ;
705: oe_debug_pub.add( 'PRICING_PHASE_ID='||M.PRICING_PHASE_ID , 1 ) ;
706: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='||M.MODIFIER_LEVEL_CODE , 1 ) ;
707: end loop;

Line 704: oe_debug_pub.add( 'LIST_LINE_ID='||M.LIST_LINE_ID , 1 ) ;

700:
701: If G_DEBUG Then
702: for m in oe_price_adj_cur(px_line_tbl(j).line_id) loop
703: oe_debug_pub.add( 'PRICE_ADJUSTMENT_ID='||M.PRICE_ADJUSTMENT_ID , 1 ) ;
704: oe_debug_pub.add( 'LIST_LINE_ID='||M.LIST_LINE_ID , 1 ) ;
705: oe_debug_pub.add( 'PRICING_PHASE_ID='||M.PRICING_PHASE_ID , 1 ) ;
706: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='||M.MODIFIER_LEVEL_CODE , 1 ) ;
707: end loop;
708: End If;

Line 705: oe_debug_pub.add( 'PRICING_PHASE_ID='||M.PRICING_PHASE_ID , 1 ) ;

701: If G_DEBUG Then
702: for m in oe_price_adj_cur(px_line_tbl(j).line_id) loop
703: oe_debug_pub.add( 'PRICE_ADJUSTMENT_ID='||M.PRICE_ADJUSTMENT_ID , 1 ) ;
704: oe_debug_pub.add( 'LIST_LINE_ID='||M.LIST_LINE_ID , 1 ) ;
705: oe_debug_pub.add( 'PRICING_PHASE_ID='||M.PRICING_PHASE_ID , 1 ) ;
706: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='||M.MODIFIER_LEVEL_CODE , 1 ) ;
707: end loop;
708: End If;
709:

Line 706: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='||M.MODIFIER_LEVEL_CODE , 1 ) ;

702: for m in oe_price_adj_cur(px_line_tbl(j).line_id) loop
703: oe_debug_pub.add( 'PRICE_ADJUSTMENT_ID='||M.PRICE_ADJUSTMENT_ID , 1 ) ;
704: oe_debug_pub.add( 'LIST_LINE_ID='||M.LIST_LINE_ID , 1 ) ;
705: oe_debug_pub.add( 'PRICING_PHASE_ID='||M.PRICING_PHASE_ID , 1 ) ;
706: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='||M.MODIFIER_LEVEL_CODE , 1 ) ;
707: end loop;
708: End If;
709:
710: --bug 4271297 update line only if open and not cancelled

Line 713: oe_debug_pub.add( 'Lalit As the line in not closed/cancelled updating LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID , 1 ) ;

709:
710: --bug 4271297 update line only if open and not cancelled
711: if( nvl(px_line_tbl(j).cancelled_flag,'N') <> 'Y' and nvl(px_line_tbl(j).open_flag,'Y') <> 'N' ) THEN
712: if (l_debug_level > 0) then
713: oe_debug_pub.add( 'Lalit As the line in not closed/cancelled updating LINE ID = '||PX_LINE_TBL ( J ) .LINE_ID , 1 ) ;
714: end if;
715: select count(*) into vcount from oe_price_adjustments where
716: line_id = px_line_tbl(j).line_id and
717: LIST_LINE_TYPE_CODE = 'TSN' and MODIFIER_LEVEL_CODE = 'LINE';

Line 741: oe_debug_pub.add( 'J = END OF LOOP '||J , 1 ) ;

737: end if;
738: j := px_line_tbl.Next(j);
739:
740: IF l_debug_level > 0 THEN
741: oe_debug_pub.add( 'J = END OF LOOP '||J , 1 ) ;
742: END IF;
743:
744: END LOOP;
745:

Line 975: oe_debug_pub.add( 'in new_terms cursor');

971: and ldets.list_header_id=qh.list_header_id
972: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
973: );
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add( 'in new_terms cursor');
976: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
977: END IF;
978: --bug 4190357
979: End Loop;

Line 976: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;

972: AND ldets.process_code=QP_PREQ_GRP.G_STATUS_NEW
973: );
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add( 'in new_terms cursor');
976: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
977: END IF;
978: --bug 4190357
979: End Loop;
980: END Term_Substitution;

Line 1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1003: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1004: l_pricing_event varchar2(30);
1005: l_return_status varchar2(1);
1006: --
1007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1008: --
1009: l_org ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
1010: l_modifier QP_LIST_HEADERS_TL.NAME%TYPE;
1011: l_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;

Line 1014: oe_debug_pub.add( 'SET PRG'||L_LINE_REC.OPERATION||' qty'||p_line_quantity ) ;

1010: l_modifier QP_LIST_HEADERS_TL.NAME%TYPE;
1011: l_list_line_no QP_LIST_LINES.LIST_LINE_NO%TYPE;
1012: Begin
1013: IF l_debug_level > 0 THEN
1014: oe_debug_pub.add( 'SET PRG'||L_LINE_REC.OPERATION||' qty'||p_line_quantity ) ;
1015: END IF;
1016: if p_line_quantity < 0
1017: and
1018: ( p_line_category is null or

Line 1094: oe_debug_pub.add( 'RLANKA: SETTING ORDERED QUANTITY UOM' ) ;

1090: --Why hardcode to INT ?
1091: l_line_rec.item_identifier_type := 'INT';
1092:
1093: IF l_debug_level > 0 THEN
1094: oe_debug_pub.add( 'RLANKA: SETTING ORDERED QUANTITY UOM' ) ;
1095: END IF;
1096: IF l_debug_level > 0 THEN
1097: oe_debug_pub.add( 'UOM = ' || P_LINE_UOM_CODE ) ;
1098: END IF;

Line 1097: oe_debug_pub.add( 'UOM = ' || P_LINE_UOM_CODE ) ;

1093: IF l_debug_level > 0 THEN
1094: oe_debug_pub.add( 'RLANKA: SETTING ORDERED QUANTITY UOM' ) ;
1095: END IF;
1096: IF l_debug_level > 0 THEN
1097: oe_debug_pub.add( 'UOM = ' || P_LINE_UOM_CODE ) ;
1098: END IF;
1099: l_line_rec.order_quantity_uom := p_line_uom_code;
1100:
1101: --end Bug 1805134

Line 1105: oe_debug_pub.add( 'PRG_LINES'||L_LINE_REC.OPERATION ) ;

1101: --end Bug 1805134
1102:
1103: l_line_rec.price_list_id := p_price_list_header_id;
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( 'PRG_LINES'||L_LINE_REC.OPERATION ) ;
1106: END IF;
1107:
1108: G_STMT_NO := 'Process_Other_Item_Line#140';
1109: Begin

Line 1187: oe_debug_pub.add( 'unexp error logging batch event for updated free goods line', 3) ;

1183: p_request_type => OE_GLOBALS.G_PRICE_LINE,
1184: x_return_status => l_return_status);
1185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'unexp error logging batch event for updated free goods line', 3) ;
1188: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg', 3);
1189: END IF;
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1188: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg', 3);

1184: x_return_status => l_return_status);
1185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'unexp error logging batch event for updated free goods line', 3) ;
1188: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg', 3);
1189: END IF;
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: IF l_debug_level > 0 THEN

Line 1193: oe_debug_pub.add( 'error logging batch event for update free goods line',3);

1189: END IF;
1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'error logging batch event for update free goods line',3);
1194: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg' , 1 ) ;
1195: END IF;
1196: RAISE FND_API.G_EXC_ERROR;
1197: END IF;

Line 1194: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg' , 1 ) ;

1190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1192: IF l_debug_level > 0 THEN
1193: oe_debug_pub.add( 'error logging batch event for update free goods line',3);
1194: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.set_prg' , 1 ) ;
1195: END IF;
1196: RAISE FND_API.G_EXC_ERROR;
1197: END IF;
1198: END IF;

Line 1203: oe_debug_pub.add( 'ERROR IN SET_PRG'||SQLERRM ) ;

1199:
1200: px_line_rec := l_line_rec;
1201: exception when others then
1202: IF l_debug_level > 0 THEN
1203: oe_debug_pub.add( 'ERROR IN SET_PRG'||SQLERRM ) ;
1204: END IF;
1205: raise fnd_api.g_exc_error;
1206: end Set_Prg;
1207:

Line 1216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1212: l_line_rec OE_Order_Pub.line_rec_type := px_line_rec;
1213: l_pricing_event varchar2(30);
1214: l_return_status varchar2(1);
1215: --
1216: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1217: --
1218: Begin
1219: IF (nvl(l_line_rec.booked_flag, 'N') = 'N') Then
1220: IF l_debug_level > 0 THEN

Line 1221: oe_debug_pub.add( 'DELETE UNBOOKED ORDER' ) ;

1217: --
1218: Begin
1219: IF (nvl(l_line_rec.booked_flag, 'N') = 'N') Then
1220: IF l_debug_level > 0 THEN
1221: oe_debug_pub.add( 'DELETE UNBOOKED ORDER' ) ;
1222: END IF;
1223: l_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1224: ELSE
1225: l_line_rec.change_reason := 'SYSTEM';

Line 1229: oe_debug_pub.add( 'CANCEL BOOKED ORDER , LINE NOT SHIPPED' ) ;

1225: l_line_rec.change_reason := 'SYSTEM';
1226: l_line_rec.change_comments := 'REPRICING';
1227: IF (l_line_rec.shipped_quantity IS NULL) THEN
1228: IF l_debug_level > 0 THEN
1229: oe_debug_pub.add( 'CANCEL BOOKED ORDER , LINE NOT SHIPPED' ) ;
1230: END IF;
1231: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1232: BEGIN
1233: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110510' THEN

Line 1249: oe_debug_pub.add( 'REPRICE BOOKED ORDER , SHIPPED LINE' ) ;

1245: l_line_rec.ordered_quantity := 0;
1246: l_line_rec.pricing_quantity := 0;
1247: ELSE
1248: IF l_debug_level > 0 THEN
1249: oe_debug_pub.add( 'REPRICE BOOKED ORDER , SHIPPED LINE' ) ;
1250: END IF;
1251: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1252: l_line_rec.calculate_price_flag := 'Y';
1253: IF l_debug_level > 0 THEN

Line 1254: oe_debug_pub.add( 'LOGGING DELAYED REQUEST TO PRICE LINE' ) ;

1250: END IF;
1251: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1252: l_line_rec.calculate_price_flag := 'Y';
1253: IF l_debug_level > 0 THEN
1254: oe_debug_pub.add( 'LOGGING DELAYED REQUEST TO PRICE LINE' ) ;
1255: END IF;
1256:
1257: l_pricing_event := 'BATCH,BOOK';
1258: OE_delayed_requests_Pvt.log_request(

Line 1313: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1309: l_parent_line_id pls_integer;
1310: l_return_status varchar2(1);
1311: E_CLOSED_LINE Exception;
1312: --
1313: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1314: --
1315: l_tot_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE ;
1316: l_tot_price_qty OE_ORDER_LINES_ALL.pricing_quantity%TYPE ;
1317: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

Line 1321: oe_debug_pub.add( 'ENTERING PRG_LINES' ) ;

1317: l_ordered_quantity OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
1318: l_pricing_quantity OE_ORDER_LINES_ALL.pricing_quantity%TYPE;
1319: Begin
1320: IF l_debug_level > 0 THEN
1321: oe_debug_pub.add( 'ENTERING PRG_LINES' ) ;
1322: END IF;
1323:
1324: For i in prg_lines Loop
1325: IF l_debug_level > 0 THEN

Line 1326: oe_debug_pub.add( 'PRG LINE:'||I.LINE_ID||' PROCESS STATUS: '||I.PROCESS_STATUS ) ;

1322: END IF;
1323:
1324: For i in prg_lines Loop
1325: IF l_debug_level > 0 THEN
1326: oe_debug_pub.add( 'PRG LINE:'||I.LINE_ID||' PROCESS STATUS: '||I.PROCESS_STATUS ) ;
1327: END IF;
1328:
1329: If (i.Process_status = QP_PREQ_PUB.G_STATUS_DELETED) THEN
1330: l_line_rec := px_line_tbl(px_price_line_id_tbl(i.line_id));

Line 1362: oe_debug_pub.add('priced quantity:'||l_pricing_quantity);

1358: i.line_quantity - nvl(l_tot_qty,0);
1359:
1360:
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add('priced quantity:'||l_pricing_quantity);
1363: oe_debug_pub.add( 'ordered_quantity:Cancelled_quantity'||l_ordered_quantity||':'||l_line_rec.cancelled_quantity ) ;
1364: END IF;
1365: if (l_ordered_quantity <= nvl(l_line_rec.cancelled_quantity, 0)) Then
1366: oe_line_util.update_adjustment_flags(l_line_rec, l_line_rec);

Line 1363: oe_debug_pub.add( 'ordered_quantity:Cancelled_quantity'||l_ordered_quantity||':'||l_line_rec.cancelled_quantity ) ;

1359:
1360:
1361: IF l_debug_level > 0 THEN
1362: oe_debug_pub.add('priced quantity:'||l_pricing_quantity);
1363: oe_debug_pub.add( 'ordered_quantity:Cancelled_quantity'||l_ordered_quantity||':'||l_line_rec.cancelled_quantity ) ;
1364: END IF;
1365: if (l_ordered_quantity <= nvl(l_line_rec.cancelled_quantity, 0)) Then
1366: oe_line_util.update_adjustment_flags(l_line_rec, l_line_rec);
1367: Delete_Prg(l_line_rec);

Line 1419: oe_debug_pub.add( 'NEW LINE ID'||L_LINE_REC.LINE_ID ) ;

1415: --for Bug 3350425. To Prevent Blanket feilds being defaulting from Header.
1416: l_line_rec.blanket_number:=NULL;
1417: l_line_rec.blanket_line_number:=NULL;
1418: IF l_debug_level > 0 THEN
1419: oe_debug_pub.add( 'NEW LINE ID'||L_LINE_REC.LINE_ID ) ;
1420: END IF;
1421: --bug 4234500
1422: l_line_rec.change_reason := 'SYSTEM';
1423: l_line_rec.change_comments := 'REPRICING';

Line 1456: oe_debug_pub.add( 'PUTTING TO SHIP SET'||L_BUY_LINE_REC.SHIP_SET_ID ) ;

1452: End If;
1453:
1454: -- put into the same ship set
1455: IF l_debug_level > 0 THEN
1456: oe_debug_pub.add( 'PUTTING TO SHIP SET'||L_BUY_LINE_REC.SHIP_SET_ID ) ;
1457: END IF;
1458: l_line_rec.ship_set_id := l_buy_line_rec.ship_set_id;
1459: --bug 7000338/7002146
1460: IF (l_buy_line_rec.ship_set_id is NOT NULL AND l_buy_line_rec.ship_set_id <> FND_API.G_MISS_NUM) THEN

Line 1462: oe_debug_pub.add( 'PUTTING TO SHIP SET name'||L_LINE_REC.SHIP_SET ) ;

1458: l_line_rec.ship_set_id := l_buy_line_rec.ship_set_id;
1459: --bug 7000338/7002146
1460: IF (l_buy_line_rec.ship_set_id is NOT NULL AND l_buy_line_rec.ship_set_id <> FND_API.G_MISS_NUM) THEN
1461: select set_name INTO l_line_rec.ship_set from oe_sets where set_id= l_buy_line_rec.ship_set_id ;
1462: oe_debug_pub.add( 'PUTTING TO SHIP SET name'||L_LINE_REC.SHIP_SET ) ;
1463: END IF;
1464:
1465: EXCEPTION WHEN NO_DATA_FOUND THEN
1466: NULL;

Line 1509: oe_debug_pub.add( 'ERROR IN PROCESS_PRG'||SQLERRM ) ;

1505: WHEN E_CLOSED_LINE THEN
1506: NULL;
1507: WHEN OTHERS THEN
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( 'ERROR IN PROCESS_PRG'||SQLERRM ) ;
1510: END IF;
1511: RAISE FND_API.G_EXC_ERROR;
1512: End Process_PRG;
1513:

Line 1530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1526: l_list_name varchar2(240);
1527: l_operand number;
1528: l_msg_text Varchar2(200);
1529:
1530: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1531:
1532: Begin
1533:
1534: IF l_debug_level > 0 THEN

Line 1535: oe_debug_pub.add('PROMOTIONS - start of procedure Promotion_Put_Hold ');

1531:
1532: Begin
1533:
1534: IF l_debug_level > 0 THEN
1535: oe_debug_pub.add('PROMOTIONS - start of procedure Promotion_Put_Hold ');
1536: END IF;
1537:
1538: -- use the seeded hold_id
1539: IF (p_line_id IS NULL) THEN

Line 1541: oe_debug_pub.add('putting header '||p_header_id||' on hold',3);

1537:
1538: -- use the seeded hold_id
1539: IF (p_line_id IS NULL) THEN
1540: IF l_debug_level > 0 THEN
1541: oe_debug_pub.add('putting header '||p_header_id||' on hold',3);
1542: END IF;
1543:
1544: l_hold_source_rec.hold_id := G_SEEDED_PROM_ORDER_HOLD_ID;
1545: ELSE

Line 1547: oe_debug_pub.add('putting line '||p_line_id||' on hold',3);

1543:
1544: l_hold_source_rec.hold_id := G_SEEDED_PROM_ORDER_HOLD_ID;
1545: ELSE
1546: IF l_debug_level > 0 THEN
1547: oe_debug_pub.add('putting line '||p_line_id||' on hold',3);
1548: END IF;
1549: l_hold_source_rec.hold_id := G_SEEDED_PROM_LINE_HOLD_ID;
1550: END IF;
1551:

Line 1553: --oe_debug_pub.add('PAL PROMOTIONS - after select in procedure Promotion_Put_Hold ');

1549: l_hold_source_rec.hold_id := G_SEEDED_PROM_LINE_HOLD_ID;
1550: END IF;
1551:
1552: IF l_debug_level > 0 THEN
1553: --oe_debug_pub.add('PAL PROMOTIONS - after select in procedure Promotion_Put_Hold ');
1554: --oe_debug_pub.add('PAL PROMOTIONS - hold id is '|| l_hold_source_rec.hold_id,2);
1555: --oe_debug_pub.add(' PROMOTIONS - header_id is '|| p_header_id,2);
1556: --oe_debug_pub.add('PAL PROMOTIONS - line_id is '|| p_line_id,2);
1557: null;

Line 1554: --oe_debug_pub.add('PAL PROMOTIONS - hold id is '|| l_hold_source_rec.hold_id,2);

1550: END IF;
1551:
1552: IF l_debug_level > 0 THEN
1553: --oe_debug_pub.add('PAL PROMOTIONS - after select in procedure Promotion_Put_Hold ');
1554: --oe_debug_pub.add('PAL PROMOTIONS - hold id is '|| l_hold_source_rec.hold_id,2);
1555: --oe_debug_pub.add(' PROMOTIONS - header_id is '|| p_header_id,2);
1556: --oe_debug_pub.add('PAL PROMOTIONS - line_id is '|| p_line_id,2);
1557: null;
1558: END IF;

Line 1555: --oe_debug_pub.add(' PROMOTIONS - header_id is '|| p_header_id,2);

1551:
1552: IF l_debug_level > 0 THEN
1553: --oe_debug_pub.add('PAL PROMOTIONS - after select in procedure Promotion_Put_Hold ');
1554: --oe_debug_pub.add('PAL PROMOTIONS - hold id is '|| l_hold_source_rec.hold_id,2);
1555: --oe_debug_pub.add(' PROMOTIONS - header_id is '|| p_header_id,2);
1556: --oe_debug_pub.add('PAL PROMOTIONS - line_id is '|| p_line_id,2);
1557: null;
1558: END IF;
1559:

Line 1556: --oe_debug_pub.add('PAL PROMOTIONS - line_id is '|| p_line_id,2);

1552: IF l_debug_level > 0 THEN
1553: --oe_debug_pub.add('PAL PROMOTIONS - after select in procedure Promotion_Put_Hold ');
1554: --oe_debug_pub.add('PAL PROMOTIONS - hold id is '|| l_hold_source_rec.hold_id,2);
1555: --oe_debug_pub.add(' PROMOTIONS - header_id is '|| p_header_id,2);
1556: --oe_debug_pub.add('PAL PROMOTIONS - line_id is '|| p_line_id,2);
1557: null;
1558: END IF;
1559:
1560: l_hold_source_rec.hold_entity_id := p_header_id;

Line 1580: --oe_debug_pub.add('PAL PROMOTIONS - hold_entity_code is '|| l_hold_source_rec.Hold_Entity_code||l_x_result_out,2);

1576: ,x_result_out => l_x_result_out
1577: );
1578:
1579: IF l_debug_level > 0 THEN
1580: --oe_debug_pub.add('PAL PROMOTIONS - hold_entity_code is '|| l_hold_source_rec.Hold_Entity_code||l_x_result_out,2);
1581: null;
1582: end if;
1583:
1584: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

Line 1589: oe_debug_pub.add('PAL PROMOTIONS - apply holds in procedure Promotion_Put_Hold ');

1585: RAISE FND_API.G_EXC_ERROR;
1586: END IF;
1587: If l_x_result_out = FND_API.G_FALSE then
1588: IF l_debug_level > 0 THEN
1589: oe_debug_pub.add('PAL PROMOTIONS - apply holds in procedure Promotion_Put_Hold ');
1590: oe_debug_pub.add('hold line with header_id:'||p_header_id||' line_id: '||p_line_id,1);
1591: END IF;
1592: OE_HOLDS_PUB.Apply_Holds(
1593: p_api_version => 1.0

Line 1590: oe_debug_pub.add('hold line with header_id:'||p_header_id||' line_id: '||p_line_id,1);

1586: END IF;
1587: If l_x_result_out = FND_API.G_FALSE then
1588: IF l_debug_level > 0 THEN
1589: oe_debug_pub.add('PAL PROMOTIONS - apply holds in procedure Promotion_Put_Hold ');
1590: oe_debug_pub.add('hold line with header_id:'||p_header_id||' line_id: '||p_line_id,1);
1591: END IF;
1592: OE_HOLDS_PUB.Apply_Holds(
1593: p_api_version => 1.0
1594: ,p_hold_source_rec => l_hold_source_rec

Line 1610: oe_debug_pub.add('error applying hold',3);

1606: END IF;
1607: OE_MSG_PUB.Add;
1608: Else
1609: IF l_debug_level > 0 THEN
1610: oe_debug_pub.add('error applying hold',3);
1611: END IF;
1612: RAISE FND_API.G_EXC_ERROR;
1613: End If;
1614: End If; /* check hold */

Line 1617: -- oe_debug_pub.add('PAL PROMOTIONS - end of procedure Promotion_Put_Hold ');

1613: End If;
1614: End If; /* check hold */
1615:
1616: IF l_debug_level > 0 THEN
1617: -- oe_debug_pub.add('PAL PROMOTIONS - end of procedure Promotion_Put_Hold ');
1618: null;
1619: END IF;
1620: end Promotion_Put_Hold;
1621:

Line 1640: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1636: l_Header_id number := oe_order_cache.g_header_rec.Header_id;
1637:
1638: l_TRANSACTION_PHASE_CODE varchar2(30) := oe_order_cache.g_header_rec.TRANSACTION_PHASE_CODE;
1639:
1640: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1641:
1642: l_order_source_id NUMBER;
1643: l_orig_sys_document_ref VARCHAR2(50);
1644: l_orig_sys_line_ref VARCHAR2(50);

Line 1653: oe_debug_pub.add('inside procedure process_limits',1);

1649: l_source_document_line_id NUMBER;
1650: l_line_id NUMBER;
1651: BEGIN
1652: IF l_debug_level > 0 THEN
1653: oe_debug_pub.add('inside procedure process_limits',1);
1654: END IF;
1655: -- First, hold order or line
1656: For I in hold_lines LOOP
1657: IF l_debug_level > 0 THEN

Line 1658: oe_debug_pub.add('line_index = '||I.line_index,1);

1654: END IF;
1655: -- First, hold order or line
1656: For I in hold_lines LOOP
1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('line_index = '||I.line_index,1);
1659: oe_debug_pub.add('line_id = '||I.line_id,1);
1660:
1661: oe_debug_pub.add('line_Type_code = '||I.line_Type_code,1);
1662: oe_debug_pub.add('line_Type_code = '||I.hold_code,1);

Line 1659: oe_debug_pub.add('line_id = '||I.line_id,1);

1655: -- First, hold order or line
1656: For I in hold_lines LOOP
1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('line_index = '||I.line_index,1);
1659: oe_debug_pub.add('line_id = '||I.line_id,1);
1660:
1661: oe_debug_pub.add('line_Type_code = '||I.line_Type_code,1);
1662: oe_debug_pub.add('line_Type_code = '||I.hold_code,1);
1663: oe_debug_pub.add('TRANSACTION_PHASE_CODE = '||l_TRANSACTION_PHASE_CODE);

Line 1661: oe_debug_pub.add('line_Type_code = '||I.line_Type_code,1);

1657: IF l_debug_level > 0 THEN
1658: oe_debug_pub.add('line_index = '||I.line_index,1);
1659: oe_debug_pub.add('line_id = '||I.line_id,1);
1660:
1661: oe_debug_pub.add('line_Type_code = '||I.line_Type_code,1);
1662: oe_debug_pub.add('line_Type_code = '||I.hold_code,1);
1663: oe_debug_pub.add('TRANSACTION_PHASE_CODE = '||l_TRANSACTION_PHASE_CODE);
1664:
1665: END IF;

Line 1662: oe_debug_pub.add('line_Type_code = '||I.hold_code,1);

1658: oe_debug_pub.add('line_index = '||I.line_index,1);
1659: oe_debug_pub.add('line_id = '||I.line_id,1);
1660:
1661: oe_debug_pub.add('line_Type_code = '||I.line_Type_code,1);
1662: oe_debug_pub.add('line_Type_code = '||I.hold_code,1);
1663: oe_debug_pub.add('TRANSACTION_PHASE_CODE = '||l_TRANSACTION_PHASE_CODE);
1664:
1665: END IF;
1666:

Line 1663: oe_debug_pub.add('TRANSACTION_PHASE_CODE = '||l_TRANSACTION_PHASE_CODE);

1659: oe_debug_pub.add('line_id = '||I.line_id,1);
1660:
1661: oe_debug_pub.add('line_Type_code = '||I.line_Type_code,1);
1662: oe_debug_pub.add('line_Type_code = '||I.hold_code,1);
1663: oe_debug_pub.add('TRANSACTION_PHASE_CODE = '||l_TRANSACTION_PHASE_CODE);
1664:
1665: END IF;
1666:
1667: IF (l_limit_hold_action = 'NO_HOLD' or

Line 1698: oe_debug_pub.add('line_index = '||I.line_index,1);

1694: END LOOP;
1695: -- Second, put message about adjustments who violated limits
1696: For I in limit_violated_details LOOP
1697: IF l_debug_level > 0 THEN
1698: oe_debug_pub.add('line_index = '||I.line_index,1);
1699: oe_debug_pub.add('limit_text = '||I.limit_text,1);
1700: END IF;
1701: IF (i.line_id = l_header_id) THEN
1702: OE_MSG_PUB.set_msg_context

Line 1699: oe_debug_pub.add('limit_text = '||I.limit_text,1);

1695: -- Second, put message about adjustments who violated limits
1696: For I in limit_violated_details LOOP
1697: IF l_debug_level > 0 THEN
1698: oe_debug_pub.add('line_index = '||I.line_index,1);
1699: oe_debug_pub.add('limit_text = '||I.limit_text,1);
1700: END IF;
1701: IF (i.line_id = l_header_id) THEN
1702: OE_MSG_PUB.set_msg_context
1703: ( p_entity_code => 'HEADER'

Line 1720: oe_debug_pub.add('Getting reference data ');

1716: IF l_line_id IS NOT NULL AND l_line_id <> 0 AND
1717: l_line_id <> FND_API.G_MISS_NUM THEN
1718: BEGIN
1719: IF l_debug_level > 0 THEN
1720: oe_debug_pub.add('Getting reference data ');
1721: END IF;
1722:
1723: select order_source_id, orig_sys_document_ref,
1724: orig_sys_line_ref, orig_sys_shipment_ref,

Line 1736: oe_debug_pub.add('no data found while getting reference data ');

1732: where line_id = l_line_id;
1733: EXCEPTION
1734: WHEN NO_DATA_FOUND THEN
1735: IF l_debug_level > 0 THEN
1736: oe_debug_pub.add('no data found while getting reference data ');
1737: END IF;
1738: l_order_source_id := NULL;
1739: l_orig_sys_document_ref := NULL;
1740: l_orig_sys_line_ref := NULL;

Line 1791: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1787: is
1788: l_source_document_type_id number := oe_order_cache.g_header_rec.source_document_type_id;
1789: l_header_id number := oe_order_cache.g_header_rec.header_id;
1790: l_source_system_code number := 0;
1791: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1792: begin
1793:
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add(' In OE_ADV_PRICE_PVT.CHECK_NOTIFY');

Line 1795: oe_debug_pub.add(' In OE_ADV_PRICE_PVT.CHECK_NOTIFY');

1791: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1792: begin
1793:
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add(' In OE_ADV_PRICE_PVT.CHECK_NOTIFY');
1796: END IF;
1797: begin
1798: select 1 into l_source_system_code from
1799: oe_order_headers_all oh,

Line 1816: oe_debug_pub.add('l_source_document_type_id = '||l_source_document_type_id);

1812: null;
1813: end;
1814:
1815: IF l_debug_level > 0 THEN
1816: oe_debug_pub.add('l_source_document_type_id = '||l_source_document_type_id);
1817: oe_debug_pub.add('l_source_system_code = '||l_source_system_code);
1818: END IF;
1819:
1820:

Line 1817: oe_debug_pub.add('l_source_system_code = '||l_source_system_code);

1813: end;
1814:
1815: IF l_debug_level > 0 THEN
1816: oe_debug_pub.add('l_source_document_type_id = '||l_source_document_type_id);
1817: oe_debug_pub.add('l_source_system_code = '||l_source_system_code);
1818: END IF;
1819:
1820:
1821: IF nvl(l_source_document_type_id,0) IN (1, 3, 4, 7, 8, 11, 12, 13, 14,15, 16, 17, 18 , 19) OR l_source_system_code = 1

Line 1869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1865: AND (l_booked_flag = 'N' or ldets.list_line_type_code<>'IUE');
1866:
1867: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1868: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1869: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1870: l_index NUMBER;
1871: l_return_status VARCHAR2(1);
1872:
1873: begin

Line 1875: oe_debug_pub.add('in new_and_updated_notify',1);

1871: l_return_status VARCHAR2(1);
1872:
1873: begin
1874: IF l_debug_level > 0 THEN
1875: oe_debug_pub.add('in new_and_updated_notify',1);
1876: END IF;
1877: FOR l_insert IN insert_adj_cur LOOP
1878: IF l_insert.modifier_level_code <> 'ORDER' THEN
1879: l_Line_Adj_rec.line_id := l_insert.line_id;

Line 2052: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY IS: ' || L_RETURN_STATUS ) ;

2048: x_index => l_index,
2049: x_return_status => l_return_status);*/
2050:
2051: IF l_debug_level > 0 THEN
2052: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY IS: ' || L_RETURN_STATUS ) ;
2053: END IF;
2054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

Line 2056: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;

2052: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY IS: ' || L_RETURN_STATUS ) ;
2053: END IF;
2054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2057: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY');
2058: END IF;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2057: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY');

2053: END IF;
2054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2055: IF l_debug_level > 0 THEN
2056: oe_debug_pub.add( 'EVENT NOTIFY - UNEXPECTED ERROR' ) ;
2057: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY');
2058: END IF;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2061: IF l_debug_level > 0 THEN

Line 2062: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' ) ;

2058: END IF;
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2061: IF l_debug_level > 0 THEN
2062: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' ) ;
2063: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' , 1 ) ;
2064: END IF;
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;

Line 2063: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' , 1 ) ;

2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2061: IF l_debug_level > 0 THEN
2062: oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' ) ;
2063: oe_debug_pub.add( 'EXITING OE_ADV_PRICE_PVT.NEW_AND_UPDATE_NOTIFY' , 1 ) ;
2064: END IF;
2065: RAISE FND_API.G_EXC_ERROR;
2066: END IF;
2067:

Line 2080: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2076: px_line_Tbl IN OUT NOCOPY oe_Order_Pub.Line_Tbl_Type
2077: )
2078: IS
2079:
2080: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2081:
2082: Cursor updated_lines_prl IS
2083: SELECT l.LINE_ID,
2084: lines.PRICE_LIST_HEADER_ID,

Line 2101: oe_debug_pub.add('In Register_price_list');

2097:
2098: BEGIN
2099:
2100: IF l_debug_level > 0 THEN
2101: oe_debug_pub.add('In Register_price_list');
2102: END IF;
2103: for i in updated_lines_prl loop
2104: IF l_debug_level > 0 THEN
2105: oe_debug_pub.add('Old Price List id : '||i.price_list_id);

Line 2105: oe_debug_pub.add('Old Price List id : '||i.price_list_id);

2101: oe_debug_pub.add('In Register_price_list');
2102: END IF;
2103: for i in updated_lines_prl loop
2104: IF l_debug_level > 0 THEN
2105: oe_debug_pub.add('Old Price List id : '||i.price_list_id);
2106: oe_debug_pub.add('New Price List id : '||i.price_list_header_id);
2107: END IF;
2108: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).price_list_id := i.price_list_header_id;
2109: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).operation := OE_GLOBALS.G_OPR_UPDATE;

Line 2106: oe_debug_pub.add('New Price List id : '||i.price_list_header_id);

2102: END IF;
2103: for i in updated_lines_prl loop
2104: IF l_debug_level > 0 THEN
2105: oe_debug_pub.add('Old Price List id : '||i.price_list_id);
2106: oe_debug_pub.add('New Price List id : '||i.price_list_header_id);
2107: END IF;
2108: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).price_list_id := i.price_list_header_id;
2109: px_line_tbl(G_PRICE_LINE_ID_TBL(i.line_id)).operation := OE_GLOBALS.G_OPR_UPDATE;
2110: end loop;

Line 2135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2131: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2132:
2133:
2134: --
2135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2136: --
2137: BEGIN
2138: NULL;
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2140: If OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE Then

2136: --
2137: BEGIN
2138: NULL;
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140: If OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE Then
2141: G_DEBUG := TRUE;
2142: IF l_debug_level > 0 THEN
2143: oe_debug_pub.add( 'BCT G_DEBUG IS:'||OE_DEBUG_PUB.G_DEBUG ) ;
2144: END IF;

Line 2143: oe_debug_pub.add( 'BCT G_DEBUG IS:'||OE_DEBUG_PUB.G_DEBUG ) ;

2139: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140: If OE_DEBUG_PUB.G_DEBUG = FND_API.G_TRUE Then
2141: G_DEBUG := TRUE;
2142: IF l_debug_level > 0 THEN
2143: oe_debug_pub.add( 'BCT G_DEBUG IS:'||OE_DEBUG_PUB.G_DEBUG ) ;
2144: END IF;
2145: Else
2146: G_DEBUG := FALSE;
2147: End If;

Line 2154: oe_debug_pub.add( 'INSIDE OE_ORDER_ADV_PVT.PROCESS_ADV_MODIFIERS' , 1 ) ;

2150: IF p_control_rec.p_calculate_flag <> QP_PREQ_GRP.G_CALCULATE_ONLY
2151: THEN
2152:
2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( 'INSIDE OE_ORDER_ADV_PVT.PROCESS_ADV_MODIFIERS' , 1 ) ;
2155: END IF;
2156:
2157: Sort_Line_Table(px_line_Tbl,G_PRICE_LINE_ID_TBL);
2158: Item_Upgrade(px_old_line_tbl,px_line_Tbl,p_pricing_events);

Line 2162: oe_debug_pub.add( 'P_PRICING_EVENTS = '||P_PRICING_EVENTS , 1 ) ;

2158: Item_Upgrade(px_old_line_tbl,px_line_Tbl,p_pricing_events);
2159: Term_Substitution(p_header_rec,lx_new_header_rec,px_old_line_tbl,px_line_Tbl);
2160:
2161: IF l_debug_level > 0 THEN
2162: oe_debug_pub.add( 'P_PRICING_EVENTS = '||P_PRICING_EVENTS , 1 ) ;
2163: oe_debug_pub.add( 'BEFORE CALL TO CALL PROCESS ORDER' , 1 ) ;
2164: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID='||P_HEADER_REC.HEADER_ID , 1 ) ;
2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;

Line 2163: oe_debug_pub.add( 'BEFORE CALL TO CALL PROCESS ORDER' , 1 ) ;

2159: Term_Substitution(p_header_rec,lx_new_header_rec,px_old_line_tbl,px_line_Tbl);
2160:
2161: IF l_debug_level > 0 THEN
2162: oe_debug_pub.add( 'P_PRICING_EVENTS = '||P_PRICING_EVENTS , 1 ) ;
2163: oe_debug_pub.add( 'BEFORE CALL TO CALL PROCESS ORDER' , 1 ) ;
2164: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID='||P_HEADER_REC.HEADER_ID , 1 ) ;
2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;
2167: oe_debug_pub.add( 'LX_NEW_HEADER_REC.HEADER_ID='||LX_NEW_HEADER_REC.HEADER_ID , 1 ) ;

Line 2164: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID='||P_HEADER_REC.HEADER_ID , 1 ) ;

2160:
2161: IF l_debug_level > 0 THEN
2162: oe_debug_pub.add( 'P_PRICING_EVENTS = '||P_PRICING_EVENTS , 1 ) ;
2163: oe_debug_pub.add( 'BEFORE CALL TO CALL PROCESS ORDER' , 1 ) ;
2164: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID='||P_HEADER_REC.HEADER_ID , 1 ) ;
2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;
2167: oe_debug_pub.add( 'LX_NEW_HEADER_REC.HEADER_ID='||LX_NEW_HEADER_REC.HEADER_ID , 1 ) ;
2168: oe_debug_pub.add( 'LX_NEW_HEADER_REC.PAYMENT_TERM_ID='||LX_NEW_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;

Line 2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;

2161: IF l_debug_level > 0 THEN
2162: oe_debug_pub.add( 'P_PRICING_EVENTS = '||P_PRICING_EVENTS , 1 ) ;
2163: oe_debug_pub.add( 'BEFORE CALL TO CALL PROCESS ORDER' , 1 ) ;
2164: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID='||P_HEADER_REC.HEADER_ID , 1 ) ;
2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;
2167: oe_debug_pub.add( 'LX_NEW_HEADER_REC.HEADER_ID='||LX_NEW_HEADER_REC.HEADER_ID , 1 ) ;
2168: oe_debug_pub.add( 'LX_NEW_HEADER_REC.PAYMENT_TERM_ID='||LX_NEW_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2169: oe_debug_pub.add( 'LX_NEW_HEADER_REC.OPERATION='||LX_NEW_HEADER_REC.OPERATION , 1 ) ;

Line 2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;

2162: oe_debug_pub.add( 'P_PRICING_EVENTS = '||P_PRICING_EVENTS , 1 ) ;
2163: oe_debug_pub.add( 'BEFORE CALL TO CALL PROCESS ORDER' , 1 ) ;
2164: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID='||P_HEADER_REC.HEADER_ID , 1 ) ;
2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;
2167: oe_debug_pub.add( 'LX_NEW_HEADER_REC.HEADER_ID='||LX_NEW_HEADER_REC.HEADER_ID , 1 ) ;
2168: oe_debug_pub.add( 'LX_NEW_HEADER_REC.PAYMENT_TERM_ID='||LX_NEW_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2169: oe_debug_pub.add( 'LX_NEW_HEADER_REC.OPERATION='||LX_NEW_HEADER_REC.OPERATION , 1 ) ;
2170: END IF;

Line 2167: oe_debug_pub.add( 'LX_NEW_HEADER_REC.HEADER_ID='||LX_NEW_HEADER_REC.HEADER_ID , 1 ) ;

2163: oe_debug_pub.add( 'BEFORE CALL TO CALL PROCESS ORDER' , 1 ) ;
2164: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID='||P_HEADER_REC.HEADER_ID , 1 ) ;
2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;
2167: oe_debug_pub.add( 'LX_NEW_HEADER_REC.HEADER_ID='||LX_NEW_HEADER_REC.HEADER_ID , 1 ) ;
2168: oe_debug_pub.add( 'LX_NEW_HEADER_REC.PAYMENT_TERM_ID='||LX_NEW_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2169: oe_debug_pub.add( 'LX_NEW_HEADER_REC.OPERATION='||LX_NEW_HEADER_REC.OPERATION , 1 ) ;
2170: END IF;
2171:

Line 2168: oe_debug_pub.add( 'LX_NEW_HEADER_REC.PAYMENT_TERM_ID='||LX_NEW_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;

2164: oe_debug_pub.add( 'P_HEADER_REC.HEADER_ID='||P_HEADER_REC.HEADER_ID , 1 ) ;
2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;
2167: oe_debug_pub.add( 'LX_NEW_HEADER_REC.HEADER_ID='||LX_NEW_HEADER_REC.HEADER_ID , 1 ) ;
2168: oe_debug_pub.add( 'LX_NEW_HEADER_REC.PAYMENT_TERM_ID='||LX_NEW_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2169: oe_debug_pub.add( 'LX_NEW_HEADER_REC.OPERATION='||LX_NEW_HEADER_REC.OPERATION , 1 ) ;
2170: END IF;
2171:
2172: Process_Prg(px_line_Tbl

Line 2169: oe_debug_pub.add( 'LX_NEW_HEADER_REC.OPERATION='||LX_NEW_HEADER_REC.OPERATION , 1 ) ;

2165: oe_debug_pub.add( 'P_HEADER_REC.PAYMENT_TERM_ID='||P_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2166: oe_debug_pub.add( 'P_HEADER_REC.OPERATION='||P_HEADER_REC.OPERATION , 1 ) ;
2167: oe_debug_pub.add( 'LX_NEW_HEADER_REC.HEADER_ID='||LX_NEW_HEADER_REC.HEADER_ID , 1 ) ;
2168: oe_debug_pub.add( 'LX_NEW_HEADER_REC.PAYMENT_TERM_ID='||LX_NEW_HEADER_REC.PAYMENT_TERM_ID , 1 ) ;
2169: oe_debug_pub.add( 'LX_NEW_HEADER_REC.OPERATION='||LX_NEW_HEADER_REC.OPERATION , 1 ) ;
2170: END IF;
2171:
2172: Process_Prg(px_line_Tbl
2173: , px_old_line_tbl

Line 2190: oe_debug_pub.add('l_booked_flag = '||l_booked_flag);

2186: l_control_rec,
2187: x_return_status);
2188:
2189: IF l_debug_level > 0 THEN
2190: oe_debug_pub.add('l_booked_flag = '||l_booked_flag);
2191: oe_debug_pub.add('oe_order_cache.g_header_rec.booked_flag = '||oe_order_cache.g_header_rec.booked_flag);
2192: END IF;
2193:
2194: END IF; -- <> Calculate_Only

Line 2191: oe_debug_pub.add('oe_order_cache.g_header_rec.booked_flag = '||oe_order_cache.g_header_rec.booked_flag);

2187: x_return_status);
2188:
2189: IF l_debug_level > 0 THEN
2190: oe_debug_pub.add('l_booked_flag = '||l_booked_flag);
2191: oe_debug_pub.add('oe_order_cache.g_header_rec.booked_flag = '||oe_order_cache.g_header_rec.booked_flag);
2192: END IF;
2193:
2194: END IF; -- <> Calculate_Only
2195:

Line 2204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

2200: Procedure Insert_Adj(p_header_id in Number default null)
2201: IS
2202: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
2203: --
2204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2205: --
2206: BEGIN
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add( 'INSIDE OE_ADV_PRICE_PVT.INSERT_ADJ' ) ;

Line 2208: oe_debug_pub.add( 'INSIDE OE_ADV_PRICE_PVT.INSERT_ADJ' ) ;

2204: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2205: --
2206: BEGIN
2207: IF l_debug_level > 0 THEN
2208: oe_debug_pub.add( 'INSIDE OE_ADV_PRICE_PVT.INSERT_ADJ' ) ;
2209: END IF;
2210: INSERT INTO OE_PRICE_ADJUSTMENTS
2211: ( PRICE_ADJUSTMENT_ID
2212: , CREATION_DATE

Line 2440: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;

2436: -- AND (l_booked_flag = 'N' or ldets.list_line_type_code<>'IUE')
2437: );
2438:
2439: IF l_debug_level > 0 THEN
2440: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
2441: END IF;
2442:
2443:
2444: INSERT INTO OE_PRICE_ADJ_ASSOCS

Line 2504: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' PRICE ADJ ASSOCS' , 3 ) ;

2500:
2501:
2502:
2503: IF l_debug_level > 0 THEN
2504: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' PRICE ADJ ASSOCS' , 3 ) ;
2505: END IF;
2506: Exception
2507: WHEN OTHERS THEN
2508: IF l_debug_level > 0 THEN

Line 2509: oe_debug_pub.add('ERROR in inserting adjustments and associations'||sqlerrm);

2505: END IF;
2506: Exception
2507: WHEN OTHERS THEN
2508: IF l_debug_level > 0 THEN
2509: oe_debug_pub.add('ERROR in inserting adjustments and associations'||sqlerrm);
2510: END IF;
2511: Raise FND_API.G_EXC_ERROR;
2512: END Insert_Adj;
2513: