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 30: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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