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

Line 43: oe_debug_pub.add('updating selling prices of already saved options', 1);

39: Change Record:
40: bug fix: if in an existing configuration. qty of options modified,
41: selling price will be affected (list price we always get per unit.)
42: do not update using old pricing data from oe_order_lines.
43: oe_debug_pub.add('updating selling prices of already saved options', 1);
44:
45: bug 2211600 : operationis set to CREATE on the line records.
46:
47: Recurring Charges: The call to OE_DEFAULT_LINE.Attributes for every child line

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

106: '-', -1) + 1 ))
107: AND organization_id = OE_Sys_Parameters.Value('MASTER_ORGANIZATION_ID');
108:
109: --
110: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
111: --
112: BEGIN
113:
114: l_pricing_callback_off := FND_PROFILE.VALUE('ONT_BYPASS_PRICING_CALLBACK');

Line 118: oe_debug_pub.add('CONFIGURATOR PRICING CALLBACK TURNED OFF', 1);

114: l_pricing_callback_off := FND_PROFILE.VALUE('ONT_BYPASS_PRICING_CALLBACK');
115:
116: IF nvl(upper(l_pricing_callback_off), 'N') = 'Y' THEN
117: IF l_debug_level > 0 THEN
118: oe_debug_pub.add('CONFIGURATOR PRICING CALLBACK TURNED OFF', 1);
119: END IF;
120: x_total_price := 0;
121: RETURN;
122: ELSE

Line 124: oe_debug_pub.add('CONFIGURATOR PRICING CALLBACK IS ON', 1);

120: x_total_price := 0;
121: RETURN;
122: ELSE
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add('CONFIGURATOR PRICING CALLBACK IS ON', 1);
125: END IF;
126: END IF;
127:
128: l_time_start := to_char (new_time (sysdate, 'PST', 'EST'),

Line 135: oe_debug_pub.add('ENTERING OE_CONFIG_PRICE_ITEMS', 1);

131:
132: ------------------- parse session_key ----------------------
133:
134: IF l_debug_level > 0 THEN
135: oe_debug_pub.add('ENTERING OE_CONFIG_PRICE_ITEMS', 1);
136: END IF;
137:
138: -- ex => '120000#10000', extract top_model_line_id from session_key
139:

Line 141: oe_debug_pub.add('CONFIG_SESSION_KEY: '|| P_CONFIG_SESSION_KEY , 1);

137:
138: -- ex => '120000#10000', extract top_model_line_id from session_key
139:
140: IF l_debug_level > 0 THEN
141: oe_debug_pub.add('CONFIG_SESSION_KEY: '|| P_CONFIG_SESSION_KEY , 1);
142: END IF;
143:
144: l_top_line_id_pos :=
145: INSTR(p_config_session_key, '#' );

Line 147: oe_debug_pub.add('MODEL END POS: '|| L_TOP_LINE_ID_POS , 1);

143:
144: l_top_line_id_pos :=
145: INSTR(p_config_session_key, '#' );
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add('MODEL END POS: '|| L_TOP_LINE_ID_POS , 1);
148: END IF;
149:
150:
151: l_top_model_line_id := TO_NUMBER(SUBSTR(p_config_session_key, 1,

Line 155: oe_debug_pub.add('L_TOP_MODEL_LINE_ID: ' || L_TOP_MODEL_LINE_ID , 1);

151: l_top_model_line_id := TO_NUMBER(SUBSTR(p_config_session_key, 1,
152: l_top_line_id_pos - 1 ));
153:
154: IF l_debug_level > 0 THEN
155: oe_debug_pub.add('L_TOP_MODEL_LINE_ID: ' || L_TOP_MODEL_LINE_ID , 1);
156: END IF;
157:
158:
159: --------------------- restored configuration ---------------

Line 162: oe_debug_pub.add('UPDATING LIST PRICES ALREADY SAVED OPTIONS', 1);

158:
159: --------------------- restored configuration ---------------
160:
161: IF l_debug_level > 0 THEN
162: oe_debug_pub.add('UPDATING LIST PRICES ALREADY SAVED OPTIONS', 1);
163: END IF;
164:
165: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508' THEN
166: IF l_debug_level > 0 THEN

Line 167: oe_debug_pub.add('PRICING CALLBACK: PACK H NEW LOGIC MI', 1);

163: END IF;
164:
165: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508' THEN
166: IF l_debug_level > 0 THEN
167: oe_debug_pub.add('PRICING CALLBACK: PACK H NEW LOGIC MI', 1);
168: END IF;
169:
170: UPDATE CZ_PRICING_STRUCTURES cz
171: SET cz.list_price =

Line 239: oe_debug_pub.add('THIS IS AN ATO MODEL', 1);

235:
236:
237: IF l_model_line_rec.ato_line_id = l_top_model_line_id THEN
238: IF l_debug_level > 0 THEN
239: oe_debug_pub.add('THIS IS AN ATO MODEL', 1);
240: END IF;
241: l_line_rec := l_model_line_rec;
242: l_defaulted_flag := 'Y';
243: ELSE

Line 245: oe_debug_pub.add('THIS IS A PTO MODEL', 1);

241: l_line_rec := l_model_line_rec;
242: l_defaulted_flag := 'Y';
243: ELSE
244: IF l_debug_level > 0 THEN
245: oe_debug_pub.add('THIS IS A PTO MODEL', 1);
246: END IF;
247: l_line_rec := OE_Order_Pub.G_Miss_Line_Rec;
248: l_defaulted_flag := 'N';
249: END IF;

Line 252: oe_debug_pub.add('DEFAULTED_FLAG: '|| L_DEFAULTED_FLAG , 1);

248: l_defaulted_flag := 'N';
249: END IF;
250:
251: IF l_debug_level > 0 THEN
252: oe_debug_pub.add('DEFAULTED_FLAG: '|| L_DEFAULTED_FLAG , 1);
253: END IF;
254:
255:
256: l_index := 0;

Line 264: OE_DEBUG_PUB.Add ('Recurring Charges System Param ENABLED',1);

260:
261: --recurring charges
262: IF OE_SYS_PARAMETERS.Value ('RECURRING_CHARGES') = 'Y' THEN
263: IF l_debug_level > 0 THEN
264: OE_DEBUG_PUB.Add ('Recurring Charges System Param ENABLED',1);
265: OE_DEBUG_PUB.Add('Top Model Line ID:'||l_top_model_line_id,3);
266: END IF;
267: OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model
268: ( p_top_model_line_id => l_top_model_line_id

Line 265: OE_DEBUG_PUB.Add('Top Model Line ID:'||l_top_model_line_id,3);

261: --recurring charges
262: IF OE_SYS_PARAMETERS.Value ('RECURRING_CHARGES') = 'Y' THEN
263: IF l_debug_level > 0 THEN
264: OE_DEBUG_PUB.Add ('Recurring Charges System Param ENABLED',1);
265: OE_DEBUG_PUB.Add('Top Model Line ID:'||l_top_model_line_id,3);
266: END IF;
267: OE_CONFIG_TSO_PVT.Is_Part_Of_Container_Model
268: ( p_top_model_line_id => l_top_model_line_id
269: ,x_top_container_model => l_top_container_model

Line 302: oe_debug_pub.add(L_SEQ_NBR||' HDR : '||L_LINE_REC.HEADER_ID,1);

298: ELSE
299: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_OPTION;
300: END IF;
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add(L_SEQ_NBR||' HDR : '||L_LINE_REC.HEADER_ID,1);
303: oe_debug_pub.add('QTY: ' || L_LINE_REC.ORDERED_QUANTITY,1);
304: oe_debug_pub.add('UCFPB,ITEM_TYPE: '||L_LINE_REC.ITEM_TYPE_CODE,1);
305: END IF;
306: ELSE -- not defaulted, pto model, default 1st option

Line 303: oe_debug_pub.add('QTY: ' || L_LINE_REC.ORDERED_QUANTITY,1);

299: l_line_rec.item_type_code := OE_GLOBALS.G_ITEM_OPTION;
300: END IF;
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add(L_SEQ_NBR||' HDR : '||L_LINE_REC.HEADER_ID,1);
303: oe_debug_pub.add('QTY: ' || L_LINE_REC.ORDERED_QUANTITY,1);
304: oe_debug_pub.add('UCFPB,ITEM_TYPE: '||L_LINE_REC.ITEM_TYPE_CODE,1);
305: END IF;
306: ELSE -- not defaulted, pto model, default 1st option
307: OE_Default_Line.Attributes

Line 304: oe_debug_pub.add('UCFPB,ITEM_TYPE: '||L_LINE_REC.ITEM_TYPE_CODE,1);

300: END IF;
301: IF l_debug_level > 0 THEN
302: oe_debug_pub.add(L_SEQ_NBR||' HDR : '||L_LINE_REC.HEADER_ID,1);
303: oe_debug_pub.add('QTY: ' || L_LINE_REC.ORDERED_QUANTITY,1);
304: oe_debug_pub.add('UCFPB,ITEM_TYPE: '||L_LINE_REC.ITEM_TYPE_CODE,1);
305: END IF;
306: ELSE -- not defaulted, pto model, default 1st option
307: OE_Default_Line.Attributes
308: ( p_x_line_rec => l_line_rec

Line 316: oe_debug_pub.add('LINE INDEX: '|| L_INDEX , 1);

312:
313: l_index := l_index + 1;
314: l_line_tbl(l_index) := l_line_rec;
315: IF l_debug_level > 0 THEN
316: oe_debug_pub.add('LINE INDEX: '|| L_INDEX , 1);
317: oe_debug_pub.add('COMP: '||L_LINE_TBL(L_INDEX).COMPONENT_CODE , 1);
318: oe_debug_pub.add('ITEM: '||L_LINE_TBL(L_INDEX).INVENTORY_ITEM_ID,1);
319: END IF;
320: ELSE

Line 317: oe_debug_pub.add('COMP: '||L_LINE_TBL(L_INDEX).COMPONENT_CODE , 1);

313: l_index := l_index + 1;
314: l_line_tbl(l_index) := l_line_rec;
315: IF l_debug_level > 0 THEN
316: oe_debug_pub.add('LINE INDEX: '|| L_INDEX , 1);
317: oe_debug_pub.add('COMP: '||L_LINE_TBL(L_INDEX).COMPONENT_CODE , 1);
318: oe_debug_pub.add('ITEM: '||L_LINE_TBL(L_INDEX).INVENTORY_ITEM_ID,1);
319: END IF;
320: ELSE
321: l_model_item_key := l_item_key;

Line 318: oe_debug_pub.add('ITEM: '||L_LINE_TBL(L_INDEX).INVENTORY_ITEM_ID,1);

314: l_line_tbl(l_index) := l_line_rec;
315: IF l_debug_level > 0 THEN
316: oe_debug_pub.add('LINE INDEX: '|| L_INDEX , 1);
317: oe_debug_pub.add('COMP: '||L_LINE_TBL(L_INDEX).COMPONENT_CODE , 1);
318: oe_debug_pub.add('ITEM: '||L_LINE_TBL(L_INDEX).INVENTORY_ITEM_ID,1);
319: END IF;
320: ELSE
321: l_model_item_key := l_item_key;
322: IF l_debug_level > 0 THEN

Line 323: oe_debug_pub.add('THIS IS A MODEL LINE', 1);

319: END IF;
320: ELSE
321: l_model_item_key := l_item_key;
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add('THIS IS A MODEL LINE', 1);
324: END IF;
325: l_index := l_index + 1;
326: l_line_tbl(l_index + 1) := l_model_line_rec;
327: END IF; -- inventory item id match

Line 344: oe_debug_pub.add('RESTORED CONFIG , UPDATE PRICING BUTTOM PRESSED', 1);

340: 'DD-MON-YY HH24:MI:SS');
341:
342: IF l_index = 0 THEN -- everything updated
343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add('RESTORED CONFIG , UPDATE PRICING BUTTOM PRESSED', 1);
345: END IF;
346: l_total_price := 0;
347: BEGIN
348: SELECT sum(selling_price * quantity)

Line 369: oe_debug_pub.add('DONE WITH PO CALL', 1);

365: (sysdate, 'PST', 'EST'),
366: 'DD-MON-YY HH24:MI:SS');
367:
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add('DONE WITH PO CALL', 1);
370: END IF;
371:
372: ---------------------------- price_line --------------------
373:

Line 387: oe_debug_pub.add('IN CONFIG_PRICE_ITEMS , BEFORE CALL TO PRICE LINE', 1);

383: l_price_control_rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
384: l_price_control_rec.simulation_flag := 'Y';
385:
386: IF l_debug_level > 0 THEN
387: oe_debug_pub.add('IN CONFIG_PRICE_ITEMS , BEFORE CALL TO PRICE LINE', 1);
388: END IF;
389:
390: l_time_bef_price := to_char
391: (new_time

Line 410: oe_debug_pub.add('AFTER CALL TO PRICE LINE: '|| L_RETURN_STATUS , 1);

406: (sysdate, 'PST', 'EST'),
407: 'DD-MON-YY HH24:MI:SS');
408:
409: IF l_debug_level > 0 THEN
410: oe_debug_pub.add('AFTER CALL TO PRICE LINE: '|| L_RETURN_STATUS , 1);
411: END IF;
412:
413: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 420: oe_debug_pub.add('AFTER PRICING , TABLE COUNT: '||L_LINE_TBL.COUNT, 1);

416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:
419: IF l_debug_level > 0 THEN
420: oe_debug_pub.add('AFTER PRICING , TABLE COUNT: '||L_LINE_TBL.COUNT, 1);
421: END IF;
422:
423:
424:

Line 436: oe_debug_pub.add('INDEX: '|| L_INDEX || ' '|| L_LINE_TBL ( L_INDEX ).INVENTORY_ITEM_ID );

432: While l_index is not null
433: LOOP
434:
435: IF l_debug_level > 0 THEN
436: oe_debug_pub.add('INDEX: '|| L_INDEX || ' '|| L_LINE_TBL ( L_INDEX ).INVENTORY_ITEM_ID );
437: END IF;
438:
439: -- avoid processing for free items
440: IF l_line_tbl(l_index).top_model_line_id = l_top_model_line_id

Line 443: oe_debug_pub.add('GG0', 1);

439: -- avoid processing for free items
440: IF l_line_tbl(l_index).top_model_line_id = l_top_model_line_id
441: THEN
442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add('GG0', 1);
444: END IF;
445: l_item_key := l_line_tbl(l_index).inventory_item_id;
446:
447: IF l_debug_level > 0 THEN

Line 448: oe_debug_pub.add('GG01', 1);

444: END IF;
445: l_item_key := l_line_tbl(l_index).inventory_item_id;
446:
447: IF l_debug_level > 0 THEN
448: oe_debug_pub.add('GG01', 1);
449: END IF;
450:
451: -- using msg_data field temporarily to save debug file name.
452:

Line 465: oe_debug_pub.add('ITEM: '||L_LINE_TBL ( L_INDEX ).COMPONENT_CODE , 1);

461: AND item_key_type = cz_prc_callback_util.g_item_key_bom_node;
462:
463:
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add('ITEM: '||L_LINE_TBL ( L_INDEX ).COMPONENT_CODE , 1);
466: oe_debug_pub.add
467: ('THE LIST PRICE IS '||L_LINE_TBL(L_INDEX ).UNIT_LIST_PRICE , 1);
468: oe_debug_pub.add
469: ('THE SELL PRICE IS '||L_LINE_TBL(L_INDEX ).UNIT_SELLING_PRICE , 1);

Line 466: oe_debug_pub.add

462:
463:
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add('ITEM: '||L_LINE_TBL ( L_INDEX ).COMPONENT_CODE , 1);
466: oe_debug_pub.add
467: ('THE LIST PRICE IS '||L_LINE_TBL(L_INDEX ).UNIT_LIST_PRICE , 1);
468: oe_debug_pub.add
469: ('THE SELL PRICE IS '||L_LINE_TBL(L_INDEX ).UNIT_SELLING_PRICE , 1);
470: END IF;

Line 468: oe_debug_pub.add

464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add('ITEM: '||L_LINE_TBL ( L_INDEX ).COMPONENT_CODE , 1);
466: oe_debug_pub.add
467: ('THE LIST PRICE IS '||L_LINE_TBL(L_INDEX ).UNIT_LIST_PRICE , 1);
468: oe_debug_pub.add
469: ('THE SELL PRICE IS '||L_LINE_TBL(L_INDEX ).UNIT_SELLING_PRICE , 1);
470: END IF;
471:
472: END IF;

Line 492: oe_debug_pub.add('TOTAL_PRICE: '|| L_TOTAL_PRICE , 1);

488:
489: x_total_price := l_total_price;
490:
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add('TOTAL_PRICE: '|| L_TOTAL_PRICE , 1);
493: END IF;
494:
495: l_time_end := to_char
496: (new_time

Line 501: oe_debug_pub.add(' ' );

497: (sysdate, 'PST', 'EST'),
498: 'DD-MON-YY HH24:MI:SS');
499:
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add(' ' );
502: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
503: oe_debug_pub.add('TIME AFTER UPDATE RESTORED : ' ||L_TIME_UPD , 1);
504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);
505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);

Line 502: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);

498: 'DD-MON-YY HH24:MI:SS');
499:
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add(' ' );
502: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
503: oe_debug_pub.add('TIME AFTER UPDATE RESTORED : ' ||L_TIME_UPD , 1);
504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);
505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );

Line 503: oe_debug_pub.add('TIME AFTER UPDATE RESTORED : ' ||L_TIME_UPD , 1);

499:
500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add(' ' );
502: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
503: oe_debug_pub.add('TIME AFTER UPDATE RESTORED : ' ||L_TIME_UPD , 1);
504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);
505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );
507: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );

Line 504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);

500: IF l_debug_level > 0 THEN
501: oe_debug_pub.add(' ' );
502: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
503: oe_debug_pub.add('TIME AFTER UPDATE RESTORED : ' ||L_TIME_UPD , 1);
504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);
505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );
507: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
508: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);

Line 505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);

501: oe_debug_pub.add(' ' );
502: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
503: oe_debug_pub.add('TIME AFTER UPDATE RESTORED : ' ||L_TIME_UPD , 1);
504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);
505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );
507: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
508: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
509: oe_debug_pub.add('LEAVING OE_CONFIG_PRICE_ITEMS', 1);

Line 506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );

502: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
503: oe_debug_pub.add('TIME AFTER UPDATE RESTORED : ' ||L_TIME_UPD , 1);
504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);
505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );
507: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
508: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
509: oe_debug_pub.add('LEAVING OE_CONFIG_PRICE_ITEMS', 1);
510: END IF;

Line 507: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );

503: oe_debug_pub.add('TIME AFTER UPDATE RESTORED : ' ||L_TIME_UPD , 1);
504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);
505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );
507: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
508: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
509: oe_debug_pub.add('LEAVING OE_CONFIG_PRICE_ITEMS', 1);
510: END IF;
511:

Line 508: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);

504: oe_debug_pub.add('TIME AFTER CZ READ : ' ||L_TIME_READ , 1);
505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );
507: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
508: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
509: oe_debug_pub.add('LEAVING OE_CONFIG_PRICE_ITEMS', 1);
510: END IF;
511:
512: EXCEPTION

Line 509: oe_debug_pub.add('LEAVING OE_CONFIG_PRICE_ITEMS', 1);

505: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
506: oe_debug_pub.add('TIME BEFORE PRICING API : ' ||L_TIME_BEF_PRICE );
507: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
508: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
509: oe_debug_pub.add('LEAVING OE_CONFIG_PRICE_ITEMS', 1);
510: END IF;
511:
512: EXCEPTION
513:

Line 527: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);

523: AND item_key = l_model_item_key;
524:
525:
526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
528: oe_debug_pub.add('TIME AFTER READ FROM CZ : ' ||L_TIME_READ , 1);
529: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
530: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
531: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);

Line 528: oe_debug_pub.add('TIME AFTER READ FROM CZ : ' ||L_TIME_READ , 1);

524:
525:
526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
528: oe_debug_pub.add('TIME AFTER READ FROM CZ : ' ||L_TIME_READ , 1);
529: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
530: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
531: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
532: oe_debug_pub.add('OE_CONFIG_PRICE_ITEMS: ' ||SUBSTR (SQLERRM ,1 ,100),1);

Line 529: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);

525:
526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
528: oe_debug_pub.add('TIME AFTER READ FROM CZ : ' ||L_TIME_READ , 1);
529: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
530: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
531: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
532: oe_debug_pub.add('OE_CONFIG_PRICE_ITEMS: ' ||SUBSTR (SQLERRM ,1 ,100),1);
533: oe_debug_pub.add('OTHERS EXCEPTION IN OE_CONFIG_PRICE_ITEMS', 1);

Line 530: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );

526: IF l_debug_level > 0 THEN
527: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
528: oe_debug_pub.add('TIME AFTER READ FROM CZ : ' ||L_TIME_READ , 1);
529: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
530: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
531: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
532: oe_debug_pub.add('OE_CONFIG_PRICE_ITEMS: ' ||SUBSTR (SQLERRM ,1 ,100),1);
533: oe_debug_pub.add('OTHERS EXCEPTION IN OE_CONFIG_PRICE_ITEMS', 1);
534: END IF;

Line 531: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);

527: oe_debug_pub.add('TIME AT START OF CALLBACK : ' ||L_TIME_START , 1);
528: oe_debug_pub.add('TIME AFTER READ FROM CZ : ' ||L_TIME_READ , 1);
529: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
530: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
531: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
532: oe_debug_pub.add('OE_CONFIG_PRICE_ITEMS: ' ||SUBSTR (SQLERRM ,1 ,100),1);
533: oe_debug_pub.add('OTHERS EXCEPTION IN OE_CONFIG_PRICE_ITEMS', 1);
534: END IF;
535:

Line 532: oe_debug_pub.add('OE_CONFIG_PRICE_ITEMS: ' ||SUBSTR (SQLERRM ,1 ,100),1);

528: oe_debug_pub.add('TIME AFTER READ FROM CZ : ' ||L_TIME_READ , 1);
529: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
530: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
531: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
532: oe_debug_pub.add('OE_CONFIG_PRICE_ITEMS: ' ||SUBSTR (SQLERRM ,1 ,100),1);
533: oe_debug_pub.add('OTHERS EXCEPTION IN OE_CONFIG_PRICE_ITEMS', 1);
534: END IF;
535:
536: END OE_Config_Price_Items;

Line 533: oe_debug_pub.add('OTHERS EXCEPTION IN OE_CONFIG_PRICE_ITEMS', 1);

529: oe_debug_pub.add('TIME AFTER PROCESS_ORDER : ' ||L_TIME_PO , 1);
530: oe_debug_pub.add('TIME AFTER PRICING API : ' ||L_TIME_PRICE );
531: oe_debug_pub.add('TIME AT END OF CALLBACK : ' ||L_TIME_END , 1);
532: oe_debug_pub.add('OE_CONFIG_PRICE_ITEMS: ' ||SUBSTR (SQLERRM ,1 ,100),1);
533: oe_debug_pub.add('OTHERS EXCEPTION IN OE_CONFIG_PRICE_ITEMS', 1);
534: END IF;
535:
536: END OE_Config_Price_Items;
537:

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

544: ) IS
545: l_currency_code VARCHAR2(15);
546: l_top_line_id_pos NUMBER;
547: l_top_model_line_id NUMBER;
548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
549: BEGIN
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add ('Entering OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - '
552: || p_config_session_key || ' ***** ' || p_price_type);

Line 551: oe_debug_pub.add ('Entering OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - '

547: l_top_model_line_id NUMBER;
548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
549: BEGIN
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add ('Entering OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - '
552: || p_config_session_key || ' ***** ' || p_price_type);
553: END IF;
554:
555: l_top_line_id_pos := INSTR(p_config_session_key, '#' );

Line 560: oe_debug_pub.add('top_model_line_id - ' || l_top_model_line_id);

556: l_top_model_line_id := TO_NUMBER(SUBSTR(p_config_session_key,
557: 1, l_top_line_id_pos - 1 ));
558:
559: IF l_debug_level > 0 THEN
560: oe_debug_pub.add('top_model_line_id - ' || l_top_model_line_id);
561: END IF;
562:
563: SELECT DISTINCT h.transactional_curr_code
564: INTO l_currency_code

Line 571: oe_debug_pub.add ('l_currency_code - ' || l_currency_code);

567: WHERE h.header_id = l.header_id
568: AND l.line_id = l_top_model_line_id;
569:
570: IF l_debug_level > 0 THEN
571: oe_debug_pub.add ('l_currency_code - ' || l_currency_code);
572: END IF;
573:
574: x_currency_code := l_currency_code;
575:

Line 581: oe_debug_pub.add ('Exiting OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls');

577: p_price_type => p_price_type,
578: x_total_price => x_total_price);
579:
580: IF l_debug_level > 0 THEN
581: oe_debug_pub.add ('Exiting OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls');
582: END IF;
583: EXCEPTION
584: WHEN TOO_MANY_ROWS THEN
585: IF l_debug_level > 0 THEN

Line 586: oe_debug_pub.add ('Exception OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - TOO_MANY_ROWS');

582: END IF;
583: EXCEPTION
584: WHEN TOO_MANY_ROWS THEN
585: IF l_debug_level > 0 THEN
586: oe_debug_pub.add ('Exception OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - TOO_MANY_ROWS');
587: END IF;
588: WHEN OTHERS THEN
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add ('Exception OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - OTHERS');

Line 590: oe_debug_pub.add ('Exception OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - OTHERS');

586: oe_debug_pub.add ('Exception OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - TOO_MANY_ROWS');
587: END IF;
588: WHEN OTHERS THEN
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add ('Exception OE_CONFIG_PRICE_UTIL.oe_config_price_items_mls - OTHERS');
591: END IF;
592: END OE_Config_Price_Items_MLS;
593: --End of Bug# 7695217
594: