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

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

8: l_code_release varchar2(30) := NULL;
9: l_enable_freight_rating varchar2(1) := NULL;
10:
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13: --
14: BEGIN
15:
16: IF l_debug_level > 0 THEN

Line 17: oe_debug_pub.add( 'OEXUFRRB: IN IS_FREIGHT_RATING_AVAILABLE' ) ;

13: --
14: BEGIN
15:
16: IF l_debug_level > 0 THEN
17: oe_debug_pub.add( 'OEXUFRRB: IN IS_FREIGHT_RATING_AVAILABLE' ) ;
18: END IF;
19:
20: l_code_release := OE_CODE_CONTROL.Get_Code_Release_Level;
21:

Line 24: oe_debug_pub.add( 'LESS THAN PACK I' , 3 ) ;

20: l_code_release := OE_CODE_CONTROL.Get_Code_Release_Level;
21:
22: IF l_code_release < '110509' THEN
23: IF l_debug_level > 0 THEN
24: oe_debug_pub.add( 'LESS THAN PACK I' , 3 ) ;
25: END IF;
26: Return False;
27: END IF;
28:

Line 39: oe_debug_pub.add( 'FTE IS NOT INSTALLED!' , 3 ) ;

35: IF G_FTE_INSTALLED = 'N' THEN
36: --FND_MESSAGE.Set_Name('ONT','ONT_FTE_NOT_INSTALLED');
37: --OE_MSG_PUB.Add;
38: IF l_debug_level > 0 THEN
39: oe_debug_pub.add( 'FTE IS NOT INSTALLED!' , 3 ) ;
40: END IF;
41: RETURN False;
42: END IF;
43:

Line 48: oe_debug_pub.add( 'ENABLE_FREIGHT_RATING IS NO ' , 3 ) ;

44: l_enable_freight_rating := nvl(OE_Sys_Parameters.Value('FTE_INTEGRATION'), 'N');
45:
46: IF l_enable_freight_rating in ('N', 'S') THEN
47: IF l_debug_level > 0 THEN
48: oe_debug_pub.add( 'ENABLE_FREIGHT_RATING IS NO ' , 3 ) ;
49: END IF;
50: Return False;
51: END IF;
52:

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

68: l_api_name CONSTANT VARCHAR2(30):= 'Get_Cost_Amount';
69: l_line_rec OE_Order_PUB.Line_Rec_Type;
70: l_cost_amount NUMBER := 0.0;
71: --
72: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
73: --
74: BEGIN
75:
76: IF l_debug_level > 0 THEN

Line 77: oe_debug_pub.add( 'OEXUFRRB:INSIDE GET COST AMOUNT FOR' || P_COST_TYPE_CODE , 1 ) ;

73: --
74: BEGIN
75:
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'OEXUFRRB:INSIDE GET COST AMOUNT FOR' || P_COST_TYPE_CODE , 1 ) ;
78: END IF;
79:
80: -- Get the Line record from the Global Record
81: l_line_rec := OE_ORDER_PUB.G_LINE;

Line 88: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;

84:
85: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
86: THEN
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
89: oe_debug_pub.add( 'EXITING CHARGES' ) ;
90: END IF;
91: RETURN NULL;
92: END IF;

Line 89: oe_debug_pub.add( 'EXITING CHARGES' ) ;

85: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
86: THEN
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
89: oe_debug_pub.add( 'EXITING CHARGES' ) ;
90: END IF;
91: RETURN NULL;
92: END IF;
93:

Line 98: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;

94: -- Check for values of cost_type_code
95:
96: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
99: oe_debug_pub.add( 'EXITING CHARGES' ) ;
100: END IF;
101: RETURN NULL;
102: END IF;

Line 99: oe_debug_pub.add( 'EXITING CHARGES' ) ;

95:
96: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
99: oe_debug_pub.add( 'EXITING CHARGES' ) ;
100: END IF;
101: RETURN NULL;
102: END IF;
103:

Line 110: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');

106: /*
107: IF l_line_rec.pricing_quantity IS NULL OR
108: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
109: l_line_rec.pricing_quantity <= 0 THEN
110: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');
111: oe_debug_pub.add('exiting charges');
112: RETURN NULL;
113: END IF;
114: */

Line 111: oe_debug_pub.add('exiting charges');

107: IF l_line_rec.pricing_quantity IS NULL OR
108: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
109: l_line_rec.pricing_quantity <= 0 THEN
110: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');
111: oe_debug_pub.add('exiting charges');
112: RETURN NULL;
113: END IF;
114: */
115:

Line 124: oe_debug_pub.add( 'LINE IS SHIPPABLE AND IS SHIPPED' , 3 ) ;

120:
121: -- Cost records are stored in OE_PRICE_ADJUSTMENTS table with
122: -- list_line_type_code = 'COST'
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'LINE IS SHIPPABLE AND IS SHIPPED' , 3 ) ;
125: END IF;
126: SELECT NVL(SUM(ADJUSTED_AMOUNT),0)
127: INTO l_cost_amount
128: FROM OE_PRICE_ADJUSTMENTS

Line 135: oe_debug_pub.add( 'AFTER GETTING COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;

131: AND CHARGE_TYPE_CODE = p_cost_type_code
132: AND nvl(ESTIMATED_FLAG, 'N') <> 'Y';
133:
134: IF l_debug_level > 0 THEN
135: oe_debug_pub.add( 'AFTER GETTING COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
136: END IF;
137:
138: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
139: ELSE

Line 149: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;

145: AND CHARGE_TYPE_CODE = p_cost_type_code
146: AND ESTIMATED_FLAG = 'Y';
147:
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
150: END IF;
151:
152: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
153: END IF;

Line 156: oe_debug_pub.add( 'LINE NOT SHIPPABLE OR IS NOT SHIPPED' , 3 ) ;

152: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
153: END IF;
154: ELSE
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add( 'LINE NOT SHIPPABLE OR IS NOT SHIPPED' , 3 ) ;
157: END IF;
158: RETURN NULL;
159:
160: END IF;

Line 162: oe_debug_pub.add( 'LEAVING CHARGES' ) ;

158: RETURN NULL;
159:
160: END IF;
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add( 'LEAVING CHARGES' ) ;
163: END IF;
164: EXCEPTION
165:
166: WHEN NO_DATA_FOUND THEN

Line 168: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;

164: EXCEPTION
165:
166: WHEN NO_DATA_FOUND THEN
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
169: END IF;
170: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
171:
172: WHEN OTHERS THEN

Line 182: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;

178: , 'Get_Cost_Amount'
179: );
180: END IF;
181: IF l_debug_level > 0 THEN
182: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;
183: END IF;
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END Get_Cost_Amount;
186:

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

192: l_list_line_type_code VARCHAR2(30);
193: l_list_line_type_code_rec List_Line_Type_Code_Rec_Type;
194:
195: --
196: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
197: --
198: BEGIN
199:
200: IF l_debug_level > 0 THEN

Line 201: oe_debug_pub.add( 'ENTERING OE_FREIGHT_RATING_UTIL.GET_LIST_LINE_TYPE_CODE' , 1 ) ;

197: --
198: BEGIN
199:
200: IF l_debug_level > 0 THEN
201: oe_debug_pub.add( 'ENTERING OE_FREIGHT_RATING_UTIL.GET_LIST_LINE_TYPE_CODE' , 1 ) ;
202: END IF;
203:
204: IF p_key IS NOT NULL THEN
205:

Line 212: oe_debug_pub.add( 'LIST LINE TYPE CODE FOR HEADER: ' || P_KEY ||' IS: ' || L_LIST_LINE_TYPE_CODE , 3 ) ;

208: l_list_line_type_code
209: := g_list_line_type_code_tbl(MOD(p_key,G_BINARY_LIMIT)).list_line_type_code; -- Bug 8636027
210:
211: IF l_debug_level > 0 THEN
212: oe_debug_pub.add( 'LIST LINE TYPE CODE FOR HEADER: ' || P_KEY ||' IS: ' || L_LIST_LINE_TYPE_CODE , 3 ) ;
213: END IF;
214:
215: ELSE
216:

Line 237: oe_debug_pub.add( 'LOADING LIST LINE TYPE CODE FOR HEADER: ' || P_KEY ||' IS: ' || L_LIST_LINE_TYPE_CODE , 3 ) ;

233: g_list_line_type_code_tbl(MOD(p_key,G_BINARY_LIMIT)) -- Bug 8636027
234: := l_list_line_type_code_rec;
235:
236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add( 'LOADING LIST LINE TYPE CODE FOR HEADER: ' || P_KEY ||' IS: ' || L_LIST_LINE_TYPE_CODE , 3 ) ;
238: END IF;
239: END IF;
240:
241: END IF;

Line 246: oe_debug_pub.add( 'EXITING OE_FREIGHT_RATING_UTIL.GET_LIST_LINE_TYPE_CODE' , 1 ) ;

242:
243: END IF;
244:
245: IF l_debug_level > 0 THEN
246: oe_debug_pub.add( 'EXITING OE_FREIGHT_RATING_UTIL.GET_LIST_LINE_TYPE_CODE' , 1 ) ;
247: END IF;
248:
249: RETURN l_list_line_type_code;
250:

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

272: l_api_name CONSTANT VARCHAR2(30):= 'Get_Cost_Amount';
273: l_line_rec OE_Order_PUB.Line_Rec_Type;
274: l_cost_amount NUMBER := 0.0;
275: --
276: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
277: --
278: BEGIN
279:
280: IF l_debug_level > 0 THEN

Line 281: oe_debug_pub.add( 'OEXUFRRB:INSIDE get_estimated_cost_amount FOR' || P_COST_TYPE_CODE , 1 ) ;

277: --
278: BEGIN
279:
280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'OEXUFRRB:INSIDE get_estimated_cost_amount FOR' || P_COST_TYPE_CODE , 1 ) ;
282: END IF;
283:
284: -- Get the Line record from the Global Record
285: l_line_rec := OE_ORDER_PUB.G_LINE;

Line 292: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;

288:
289: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
290: THEN
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
293: oe_debug_pub.add( 'EXITING CHARGES' ) ;
294: END IF;
295: RETURN NULL;
296: END IF;

Line 293: oe_debug_pub.add( 'EXITING CHARGES' ) ;

289: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
290: THEN
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
293: oe_debug_pub.add( 'EXITING CHARGES' ) ;
294: END IF;
295: RETURN NULL;
296: END IF;
297:

Line 302: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;

298: -- Check for values of cost_type_code
299:
300: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
303: oe_debug_pub.add( 'EXITING CHARGES' ) ;
304: END IF;
305: RETURN NULL;
306: END IF;

Line 303: oe_debug_pub.add( 'EXITING CHARGES' ) ;

299:
300: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
303: oe_debug_pub.add( 'EXITING CHARGES' ) ;
304: END IF;
305: RETURN NULL;
306: END IF;
307:

Line 314: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');

310: /*
311: IF l_line_rec.pricing_quantity IS NULL OR
312: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
313: l_line_rec.pricing_quantity <= 0 THEN
314: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');
315: oe_debug_pub.add('exiting charges');
316: RETURN NULL;
317: END IF;
318: */

Line 315: oe_debug_pub.add('exiting charges');

311: IF l_line_rec.pricing_quantity IS NULL OR
312: l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR
313: l_line_rec.pricing_quantity <= 0 THEN
314: oe_debug_pub.add('l_line_rec.pricing_quantity = FND_API.G_MISS_NUM OR _line_rec.pricing_quantity <= 0');
315: oe_debug_pub.add('exiting charges');
316: RETURN NULL;
317: END IF;
318: */
319:

Line 332: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;

328: AND CHARGE_TYPE_CODE = p_cost_type_code
329: AND ESTIMATED_FLAG = 'Y';
330:
331: IF l_debug_level > 0 THEN
332: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
333: END IF;
334:
335: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
336: ELSE

Line 338: oe_debug_pub.add( 'LINE NOT SHIPPABLE ' , 3 ) ;

334:
335: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
336: ELSE
337: IF l_debug_level > 0 THEN
338: oe_debug_pub.add( 'LINE NOT SHIPPABLE ' , 3 ) ;
339: END IF;
340: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
341:
342: END IF;

Line 344: oe_debug_pub.add( 'LEAVING CHARGES' ) ;

340: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
341:
342: END IF;
343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'LEAVING CHARGES' ) ;
345: END IF;
346: EXCEPTION
347:
348: WHEN NO_DATA_FOUND THEN

Line 350: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;

346: EXCEPTION
347:
348: WHEN NO_DATA_FOUND THEN
349: IF l_debug_level > 0 THEN
350: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
351: END IF;
352: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
353:
354: WHEN OTHERS THEN

Line 364: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;

360: , 'Get_Cost_Amount'
361: );
362: END IF;
363: IF l_debug_level > 0 THEN
364: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;
365: END IF;
366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
367: END Get_Estimated_Cost_Amount;
368:

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

368:
369: PROCEDURE Create_Dummy_Adjustment(p_header_id in number) IS
370: l_price_adjustment_id number := -1;
371: --
372: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
373: --
374: BEGIN
375:
376: IF p_header_id is not null THEN

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

427: l_api_name CONSTANT VARCHAR2(30):= 'Get_Estimated_Cost_Amount_Ns';
428: l_line_rec OE_Order_PUB.Line_Rec_Type;
429: l_cost_amount NUMBER := 0.0;
430: --
431: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
432: --
433: BEGIN
434:
435: IF l_debug_level > 0 THEN

Line 436: oe_debug_pub.add('OEXUFRRB: Inside Procedure Get_Estimated_Cost_Amount_Ns');

432: --
433: BEGIN
434:
435: IF l_debug_level > 0 THEN
436: oe_debug_pub.add('OEXUFRRB: Inside Procedure Get_Estimated_Cost_Amount_Ns');
437: oe_debug_pub.add('p_cost_type_code : ' || P_COST_TYPE_CODE , 1 ) ;
438: END IF;
439: -- Get the Line record from the Global Record
440: l_line_rec := OE_ORDER_PUB.G_LINE;

Line 437: oe_debug_pub.add('p_cost_type_code : ' || P_COST_TYPE_CODE , 1 ) ;

433: BEGIN
434:
435: IF l_debug_level > 0 THEN
436: oe_debug_pub.add('OEXUFRRB: Inside Procedure Get_Estimated_Cost_Amount_Ns');
437: oe_debug_pub.add('p_cost_type_code : ' || P_COST_TYPE_CODE , 1 ) ;
438: END IF;
439: -- Get the Line record from the Global Record
440: l_line_rec := OE_ORDER_PUB.G_LINE;
441:

Line 447: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;

443:
444: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
445: THEN
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
448: oe_debug_pub.add( 'EXITING CHARGES' ) ;
449: END IF;
450: RETURN NULL;
451: END IF;

Line 448: oe_debug_pub.add( 'EXITING CHARGES' ) ;

444: IF l_line_rec.line_id is NULL OR l_line_rec.line_id = FND_API.G_MISS_NUM
445: THEN
446: IF l_debug_level > 0 THEN
447: oe_debug_pub.add( 'L_LINE_REC.LINE_ID IS NULL OR L_LINE_REC.LINE_ID IS FND_API.G_MISS_NUM' ) ;
448: oe_debug_pub.add( 'EXITING CHARGES' ) ;
449: END IF;
450: RETURN NULL;
451: END IF;
452:

Line 457: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;

453: -- Check for values of cost_type_code
454:
455: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
458: oe_debug_pub.add( 'EXITING CHARGES' ) ;
459: END IF;
460: RETURN NULL;
461: END IF;

Line 458: oe_debug_pub.add( 'EXITING CHARGES' ) ;

454:
455: IF p_cost_type_code is NULL OR p_cost_type_code = FND_API.G_MISS_CHAR THEN
456: IF l_debug_level > 0 THEN
457: oe_debug_pub.add( 'P_COST_TYPE_CODE IS NULL OR P_COST_TYPE_CODE IS FND_API.G_MISS_CHAR' ) ;
458: oe_debug_pub.add( 'EXITING CHARGES' ) ;
459: END IF;
460: RETURN NULL;
461: END IF;
462:

Line 472: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;

468: AND CHARGE_TYPE_CODE = p_cost_type_code
469: AND ESTIMATED_FLAG = 'Y';
470:
471: IF l_debug_level > 0 THEN
472: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
473: END IF;
474: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'LEAVING CHARGES' ) ;

Line 476: oe_debug_pub.add( 'LEAVING CHARGES' ) ;

472: oe_debug_pub.add( 'AFTER GETTING ESTIMATED COST AMOUNT ' || TO_CHAR ( L_COST_AMOUNT ) , 3 ) ;
473: END IF;
474: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(l_cost_amount);
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'LEAVING CHARGES' ) ;
477: END IF;
478: EXCEPTION
479: WHEN NO_DATA_FOUND THEN
480: IF l_debug_level > 0 THEN

Line 481: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;

477: END IF;
478: EXCEPTION
479: WHEN NO_DATA_FOUND THEN
480: IF l_debug_level > 0 THEN
481: oe_debug_pub.add( 'NO COST INFORMATION FOUND IN OE_PRICE_ADJUSTMENTS' ) ;
482: END IF;
483: RETURN FND_NUMBER.NUMBER_TO_CANONICAL(0);
484: WHEN OTHERS THEN
485: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 493: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;

489: , 'Get_Cost_Amount'
490: );
491: END IF;
492: IF l_debug_level > 0 THEN
493: oe_debug_pub.add( 'UNEXCPETED ERRORS:'||SQLERRM ) ;
494: END IF;
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END Get_Estimated_Cost_Amount_ns;
497: