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

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

25: l_list_line_type_code VARCHAR2(30);
26: l_list_line_type_code_rec List_Line_Type_Code_Rec_Type;
27:
28: --
29: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
30: --
31: BEGIN
32:
33: IF l_debug_level > 0 THEN

Line 34: oe_debug_pub.add( 'ENTERING OE_FREIGHT_RATING_PVT.GET_LIST_LINE_TYPE_CODE' , 1 ) ;

30: --
31: BEGIN
32:
33: IF l_debug_level > 0 THEN
34: oe_debug_pub.add( 'ENTERING OE_FREIGHT_RATING_PVT.GET_LIST_LINE_TYPE_CODE' , 1 ) ;
35: END IF;
36:
37: IF p_key IS NOT NULL THEN
38:

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

42: l_list_line_type_code
43: := g_list_line_type_code_tbl(p_key).list_line_type_code;
44:
45: IF l_debug_level > 0 THEN
46: oe_debug_pub.add( 'LIST LINE TYPE CODE FOR HEADER: ' || P_KEY ||' IS: ' || L_LIST_LINE_TYPE_CODE , 3 ) ;
47: END IF;
48:
49: ELSE
50:

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

65: g_list_line_type_code_tbl(p_key)
66: := l_list_line_type_code_rec;
67:
68: IF l_debug_level > 0 THEN
69: oe_debug_pub.add( 'LOADING LIST LINE TYPE CODE FOR HEADER: ' || P_KEY ||' IS: ' || L_LIST_LINE_TYPE_CODE , 3 ) ;
70: END IF;
71: END IF;
72:
73:

Line 80: oe_debug_pub.add( 'EXITING OE_FREIGHT_RATING_PVT.GET_LIST_LINE_TYPE_CODE' , 1 ) ;

76:
77: END IF;
78:
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add( 'EXITING OE_FREIGHT_RATING_PVT.GET_LIST_LINE_TYPE_CODE' , 1 ) ;
81: END IF;
82:
83: RETURN l_list_line_type_code;
84:

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

112: PROCEDURE Print_Time(p_msg IN VARCHAR2)
113: IS
114: l_time VARCHAR2(100);
115: --
116: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
117: --
118: BEGIN
119: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
120: 'DD-MON-YY HH24:MI:SS');

Line 122: oe_debug_pub.add( P_MSG || ': '|| L_TIME , 1 ) ;

118: BEGIN
119: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
120: 'DD-MON-YY HH24:MI:SS');
121: IF l_debug_level > 0 THEN
122: oe_debug_pub.add( P_MSG || ': '|| L_TIME , 1 ) ;
123: END IF;
124: END Print_Time;
125:
126: PROCEDURE Prepare_Adj_Detail

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

136:
137: l_price_adjustment_id number := 0;
138:
139: --
140: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
141: --
142: BEGIN
143:
144: IF l_debug_level > 0 THEN

Line 145: oe_debug_pub.add( 'ENTERING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;

141: --
142: BEGIN
143:
144: IF l_debug_level > 0 THEN
145: oe_debug_pub.add( 'ENTERING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;
146: END IF;
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: select oe_price_adjustments_s.nextval into l_price_adjustment_id

Line 153: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;

149: select oe_price_adjustments_s.nextval into l_price_adjustment_id
150: from dual;
151:
152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;
154: END IF;
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add( 'LINE_ID IN PREPARE_ADJ_DETAIL IS: ' ||P_LINE_ID , 1 ) ;
157: END IF;

Line 156: oe_debug_pub.add( 'LINE_ID IN PREPARE_ADJ_DETAIL IS: ' ||P_LINE_ID , 1 ) ;

152: IF l_debug_level > 0 THEN
153: oe_debug_pub.add( 'PRICE ADJUSTMENT ID IN PREPARE_ADJ_DETAIL IS: ' ||L_PRICE_ADJUSTMENT_ID , 1 ) ;
154: END IF;
155: IF l_debug_level > 0 THEN
156: oe_debug_pub.add( 'LINE_ID IN PREPARE_ADJ_DETAIL IS: ' ||P_LINE_ID , 1 ) ;
157: END IF;
158:
159: x_line_adj_rec.header_id := p_header_id;
160: x_line_adj_rec.line_id := p_line_id;

Line 176: oe_debug_pub.add( 'EXITING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;

172: x_line_adj_rec.estimated_flag := 'Y';
173: x_line_adj_rec.source_system_code := 'FTE';
174:
175: IF l_debug_level > 0 THEN
176: oe_debug_pub.add( 'EXITING PROCEDURE PREPARE_ADJ_DETAIL.' , 3 ) ;
177: END IF;
178:
179: EXCEPTION
180: WHEN OTHERS THEN

Line 183: oe_debug_pub.add( 'ERROR IN PROCEDURE PREPARE_ADJ_DETAIL: '||SUBSTR ( SQLERRM , 1 , 240 ) , 3 ) ;

179: EXCEPTION
180: WHEN OTHERS THEN
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'ERROR IN PROCEDURE PREPARE_ADJ_DETAIL: '||SUBSTR ( SQLERRM , 1 , 240 ) , 3 ) ;
184: END IF;
185: IF l_debug_level > 0 THEN
186: oe_debug_pub.add( 'UNEXPECTED ERROR IN PREPRARE_ADJ_DETAIL :'||SQLERRM , 3 ) ;
187: END IF;

Line 186: oe_debug_pub.add( 'UNEXPECTED ERROR IN PREPRARE_ADJ_DETAIL :'||SQLERRM , 3 ) ;

182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'ERROR IN PROCEDURE PREPARE_ADJ_DETAIL: '||SUBSTR ( SQLERRM , 1 , 240 ) , 3 ) ;
184: END IF;
185: IF l_debug_level > 0 THEN
186: oe_debug_pub.add( 'UNEXPECTED ERROR IN PREPRARE_ADJ_DETAIL :'||SQLERRM , 3 ) ;
187: END IF;
188: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
189: THEN
190: OE_MSG_PUB.Add_Exc_Msg

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

238: AND ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
239: AND ool.ato_line_id = p_ato_line_id;
240:
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245:
246: Print_Time('Entering OE_Freight_Rating_PVT.Process_FTE_Output..');

Line 270: oe_debug_pub.add( 'TOTAL NUMBER OF CONFIG LINES:'||P_CONFIG_COUNT , 3 ) ;

266: k := l_line_id_tbl.NEXT(k);
267: END LOOP;
268:
269: IF l_debug_level > 0 THEN
270: oe_debug_pub.add( 'TOTAL NUMBER OF CONFIG LINES:'||P_CONFIG_COUNT , 3 ) ;
271: END IF;
272:
273: -- initialize these values for FTE rates.
274: l_index := 1;

Line 280: oe_debug_pub.add( '============ FTE RESULTS ============' , 3 ) ;

276: -- insert the FTE output to database table.
277: I := p_fte_rates_tab.FIRST;
278: WHILE I IS NOT NULL LOOP
279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add( '============ FTE RESULTS ============' , 3 ) ;
281: END IF;
282:
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'SOURCE LINE :'|| P_FTE_RATES_TAB ( I ) .SOURCE_LINE_ID , 3 ) ;

Line 284: oe_debug_pub.add( 'SOURCE LINE :'|| P_FTE_RATES_TAB ( I ) .SOURCE_LINE_ID , 3 ) ;

280: oe_debug_pub.add( '============ FTE RESULTS ============' , 3 ) ;
281: END IF;
282:
283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'SOURCE LINE :'|| P_FTE_RATES_TAB ( I ) .SOURCE_LINE_ID , 3 ) ;
285: END IF;
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add( 'COST TYPE :'|| P_FTE_RATES_TAB ( I ) .COST_TYPE , 3 ) ;
288: END IF;

Line 287: oe_debug_pub.add( 'COST TYPE :'|| P_FTE_RATES_TAB ( I ) .COST_TYPE , 3 ) ;

283: IF l_debug_level > 0 THEN
284: oe_debug_pub.add( 'SOURCE LINE :'|| P_FTE_RATES_TAB ( I ) .SOURCE_LINE_ID , 3 ) ;
285: END IF;
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add( 'COST TYPE :'|| P_FTE_RATES_TAB ( I ) .COST_TYPE , 3 ) ;
288: END IF;
289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add( 'COST SUB TYPE :'|| P_FTE_RATES_TAB ( I ) .COST_SUB_TYPE , 3 ) ;
291: END IF;

Line 290: oe_debug_pub.add( 'COST SUB TYPE :'|| P_FTE_RATES_TAB ( I ) .COST_SUB_TYPE , 3 ) ;

286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add( 'COST TYPE :'|| P_FTE_RATES_TAB ( I ) .COST_TYPE , 3 ) ;
288: END IF;
289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add( 'COST SUB TYPE :'|| P_FTE_RATES_TAB ( I ) .COST_SUB_TYPE , 3 ) ;
291: END IF;
292: IF l_debug_level > 0 THEN
293: oe_debug_pub.add( 'PRICED QUANTITY :'|| P_FTE_RATES_TAB ( I ) .PRICED_QUANTITY , 3 ) ;
294: END IF;

Line 293: oe_debug_pub.add( 'PRICED QUANTITY :'|| P_FTE_RATES_TAB ( I ) .PRICED_QUANTITY , 3 ) ;

289: IF l_debug_level > 0 THEN
290: oe_debug_pub.add( 'COST SUB TYPE :'|| P_FTE_RATES_TAB ( I ) .COST_SUB_TYPE , 3 ) ;
291: END IF;
292: IF l_debug_level > 0 THEN
293: oe_debug_pub.add( 'PRICED QUANTITY :'|| P_FTE_RATES_TAB ( I ) .PRICED_QUANTITY , 3 ) ;
294: END IF;
295: IF l_debug_level > 0 THEN
296: oe_debug_pub.add( 'PRICED UOM :'|| P_FTE_RATES_TAB ( I ) .PRICED_UOM , 3 ) ;
297: END IF;

Line 296: oe_debug_pub.add( 'PRICED UOM :'|| P_FTE_RATES_TAB ( I ) .PRICED_UOM , 3 ) ;

292: IF l_debug_level > 0 THEN
293: oe_debug_pub.add( 'PRICED QUANTITY :'|| P_FTE_RATES_TAB ( I ) .PRICED_QUANTITY , 3 ) ;
294: END IF;
295: IF l_debug_level > 0 THEN
296: oe_debug_pub.add( 'PRICED UOM :'|| P_FTE_RATES_TAB ( I ) .PRICED_UOM , 3 ) ;
297: END IF;
298: IF l_debug_level > 0 THEN
299: oe_debug_pub.add( 'UNIT PRICE :'|| P_FTE_RATES_TAB ( I ) .UNIT_PRICE , 3 ) ;
300: END IF;

Line 299: oe_debug_pub.add( 'UNIT PRICE :'|| P_FTE_RATES_TAB ( I ) .UNIT_PRICE , 3 ) ;

295: IF l_debug_level > 0 THEN
296: oe_debug_pub.add( 'PRICED UOM :'|| P_FTE_RATES_TAB ( I ) .PRICED_UOM , 3 ) ;
297: END IF;
298: IF l_debug_level > 0 THEN
299: oe_debug_pub.add( 'UNIT PRICE :'|| P_FTE_RATES_TAB ( I ) .UNIT_PRICE , 3 ) ;
300: END IF;
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'BASE PRICE :'|| P_FTE_RATES_TAB ( I ) .BASE_PRICE , 3 ) ;
303: END IF;

Line 302: oe_debug_pub.add( 'BASE PRICE :'|| P_FTE_RATES_TAB ( I ) .BASE_PRICE , 3 ) ;

298: IF l_debug_level > 0 THEN
299: oe_debug_pub.add( 'UNIT PRICE :'|| P_FTE_RATES_TAB ( I ) .UNIT_PRICE , 3 ) ;
300: END IF;
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'BASE PRICE :'|| P_FTE_RATES_TAB ( I ) .BASE_PRICE , 3 ) ;
303: END IF;
304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add( 'ADJUSTED UNIT PRICE :'|| P_FTE_RATES_TAB ( I ) .ADJUSTED_UNIT_PRICE , 3 ) ;
306: END IF;

Line 305: oe_debug_pub.add( 'ADJUSTED UNIT PRICE :'|| P_FTE_RATES_TAB ( I ) .ADJUSTED_UNIT_PRICE , 3 ) ;

301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add( 'BASE PRICE :'|| P_FTE_RATES_TAB ( I ) .BASE_PRICE , 3 ) ;
303: END IF;
304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add( 'ADJUSTED UNIT PRICE :'|| P_FTE_RATES_TAB ( I ) .ADJUSTED_UNIT_PRICE , 3 ) ;
306: END IF;
307: IF l_debug_level > 0 THEN
308: oe_debug_pub.add( 'ADJUSTED PRICE :'|| P_FTE_RATES_TAB ( I ) .ADJUSTED_PRICE , 3 ) ;
309: END IF;

Line 308: oe_debug_pub.add( 'ADJUSTED PRICE :'|| P_FTE_RATES_TAB ( I ) .ADJUSTED_PRICE , 3 ) ;

304: IF l_debug_level > 0 THEN
305: oe_debug_pub.add( 'ADJUSTED UNIT PRICE :'|| P_FTE_RATES_TAB ( I ) .ADJUSTED_UNIT_PRICE , 3 ) ;
306: END IF;
307: IF l_debug_level > 0 THEN
308: oe_debug_pub.add( 'ADJUSTED PRICE :'|| P_FTE_RATES_TAB ( I ) .ADJUSTED_PRICE , 3 ) ;
309: END IF;
310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add( 'CURRENCY :'|| P_FTE_RATES_TAB ( I ) .CURRENCY , 3 ) ;
312: END IF;

Line 311: oe_debug_pub.add( 'CURRENCY :'|| P_FTE_RATES_TAB ( I ) .CURRENCY , 3 ) ;

307: IF l_debug_level > 0 THEN
308: oe_debug_pub.add( 'ADJUSTED PRICE :'|| P_FTE_RATES_TAB ( I ) .ADJUSTED_PRICE , 3 ) ;
309: END IF;
310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add( 'CURRENCY :'|| P_FTE_RATES_TAB ( I ) .CURRENCY , 3 ) ;
312: END IF;
313:
314: Prepare_Adj_Detail
315: (p_header_id => p_header_id

Line 330: oe_debug_pub.add('Register changed line: '||p_fte_rates_tab(I).source_line_id,1);

326: OE_LINE_ADJ_UTIL.INSERT_ROW(l_line_adj_rec);
327:
328: -- to register changed line so that repricing for this line
329: -- would happen.
330: oe_debug_pub.add('Register changed line: '||p_fte_rates_tab(I).source_line_id,1);
331: OE_LINE_ADJ_UTIL.Register_Changed_Lines
332: (p_line_id => p_fte_rates_tab(I).source_line_id,
333: p_header_id => p_header_id,
334: p_operation => OE_GLOBALS.G_OPR_UPDATE);

Line 348: oe_debug_pub.add( 'CASCADING ADJUSTMENT LINES TO CONFIG LINES. ' , 3 ) ;

344: WHILE l_index <= p_config_count LOOP
345:
346: l_line_id := p_x_line_tbl(l_index).line_id;
347: IF l_debug_level > 0 THEN
348: oe_debug_pub.add( 'CASCADING ADJUSTMENT LINES TO CONFIG LINES. ' , 3 ) ;
349: END IF;
350:
351: OPEN C_CONFIG_ITEM_PARENTS(p_x_line_tbl(l_index).ato_line_id);
352: FETCH C_CONFIG_ITEM_PARENTS BULK COLLECT INTO

Line 421: oe_debug_pub.add( 'CALLING PRICING ENGINE FOR FREIGHT FOR: '||P_HEADER_ID , 1 ) ;

417: -- Calling Pricing Engine to calculate freight charges
418: -- if being called from Action button.
419: IF NVL(p_ui_flag, 'N') = 'Y' THEN
420: IF l_debug_level > 0 THEN
421: oe_debug_pub.add( 'CALLING PRICING ENGINE FOR FREIGHT FOR: '||P_HEADER_ID , 1 ) ;
422: END IF;
423:
424: l_price_control_rec.p_request_type_code:='ONT';
425: l_Price_control_rec.p_write_to_db:=TRUE;

Line 497: oe_debug_pub.add( 'EXPECTED ERROR IN PROCESS FTE OUTPUT' , 1 ) ;

493:
494: WHEN FND_API.G_EXC_ERROR THEN
495:
496: IF l_debug_level > 0 THEN
497: oe_debug_pub.add( 'EXPECTED ERROR IN PROCESS FTE OUTPUT' , 1 ) ;
498: END IF;
499:
500: x_return_status := FND_API.G_RET_STS_ERROR;
501:

Line 505: oe_debug_pub.add( 'UNEXPECTED ERROR IN PROCESS FTE OUTPUT'|| SQLERRM , 2 ) ;

501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: IF l_debug_level > 0 THEN
505: oe_debug_pub.add( 'UNEXPECTED ERROR IN PROCESS FTE OUTPUT'|| SQLERRM , 2 ) ;
506: END IF;
507:
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: