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

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

111: l_updated_options_tbl OE_Order_PUB.request_tbl_type;
112: l_rev_date DATE;
113: l_frozen_model_bill VARCHAR2(1);
114: --
115: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
116: --
117:
118: BEGIN
119: IF l_debug_level > 0 THEN

Line 120: oe_debug_pub.add( 'ENTERING PROCESS_CONFIG_OPTIONS' , 5 ) ;

116: --
117:
118: BEGIN
119: IF l_debug_level > 0 THEN
120: oe_debug_pub.add( 'ENTERING PROCESS_CONFIG_OPTIONS' , 5 ) ;
121: END IF;
122:
123: Print_Time('Process_Config_Options start time');
124:

Line 150: oe_debug_pub.add('fulfilled_flag'|| l_model_line_rec.fulfilled_flag , 1 ) ;

146: Handle_Ret_Status(p_return_status => l_return_status);
147:
148: IF p_ui_flag = 'Y' Then
149:
150: oe_debug_pub.add('fulfilled_flag'|| l_model_line_rec.fulfilled_flag , 1 ) ;
151: oe_debug_pub.add('open_flag'|| l_model_line_rec.open_flag , 1 ) ;
152:
153: IF nvl(l_model_line_rec.open_flag, 'Y') = 'N' THEN
154: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');

Line 151: oe_debug_pub.add('open_flag'|| l_model_line_rec.open_flag , 1 ) ;

147:
148: IF p_ui_flag = 'Y' Then
149:
150: oe_debug_pub.add('fulfilled_flag'|| l_model_line_rec.fulfilled_flag , 1 ) ;
151: oe_debug_pub.add('open_flag'|| l_model_line_rec.open_flag , 1 ) ;
152:
153: IF nvl(l_model_line_rec.open_flag, 'Y') = 'N' THEN
154: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
155: FND_MESSAGE.Set_Token('MODEL', l_model_line_rec.ordered_item);

Line 159: oe_debug_pub.add('model line is closed', 1);

155: FND_MESSAGE.Set_Token('MODEL', l_model_line_rec.ordered_item);
156: OE_MSG_PUB.Add;
157:
158: IF l_debug_level > 0 then
159: oe_debug_pub.add('model line is closed', 1);
160: END IF;
161: RAISE FND_API.G_EXC_ERROR;
162: END IF;
163:

Line 169: oe_debug_pub.add('model line is fulfilled', 1);

165: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
166: FND_MESSAGE.Set_Token('MODEL', l_model_line_rec.ordered_item);
167: OE_MSG_PUB.Add;
168: IF l_debug_level > 0 then
169: oe_debug_pub.add('model line is fulfilled', 1);
170: END IF;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:

Line 179: oe_debug_pub.add('remnant model', 1);

175: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_REMNANT_NO_CHANGES');
176: FND_MESSAGE.Set_Token('MODEL', l_model_line_rec.ordered_item);
177: OE_MSG_PUB.Add;
178: IF l_debug_level > 0 then
179: oe_debug_pub.add('remnant model', 1);
180: END IF;
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;
183: END IF;

Line 201: oe_debug_pub.add( 'CALLING EXPLODE_BILL' , 1 ) ;

197: ,p_source_document_line_id => l_model_line_rec.source_document_line_id
198: ,p_source_document_type_id => l_model_line_rec.source_document_type_id);
199:
200: IF l_debug_level > 0 THEN
201: oe_debug_pub.add( 'CALLING EXPLODE_BILL' , 1 ) ;
202: END IF;
203:
204: oe_config_pvt.Explode_Bill
205: ( p_model_line_rec => l_model_line_rec

Line 226: oe_debug_pub.add( 'GETTING PREVIOUSLY SAVED OPTIONS FROM DB' , 2 ) ;

222: -- this is for perf reasons.
223:
224: IF p_ui_flag = 'Y' THEN
225: IF l_debug_level > 0 THEN
226: oe_debug_pub.add( 'GETTING PREVIOUSLY SAVED OPTIONS FROM DB' , 2 ) ;
227: END IF;
228:
229: Get_Options_From_DB( p_top_model_line_id => p_top_model_line_id
230: ,p_get_model_line => TRUE

Line 248: oe_debug_pub.add

244: ( p_options_tbl => l_options_tbl --=> sent in by caller.
245: ,p_comp_code => l_db_options_tbl(I).component_code);
246:
247: IF l_debug_level > 0 THEN
248: oe_debug_pub.add
249: ('CONTINUE: '|| L_OPTIONS_TBL ( L_INDEX ) .COMPONENT_CODE , 2 ) ;
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN

Line 257: oe_debug_pub.add

253: l_count := l_count + 1;
254: l_options_tbl(l_count) := l_db_options_tbl(I);
255:
256: IF l_debug_level > 0 THEN
257: oe_debug_pub.add
258: (I ||' ADD DB COMP: '|| L_DB_OPTIONS_TBL ( I ).COMPONENT_CODE , 1);
259: END IF;
260:
261: END;

Line 268: oe_debug_pub.add( 'CALLING CHECK_DUPLICATE_COMPONENTS' , 1 ) ;

264: END LOOP;
265: END IF;
266:
267: IF l_debug_level > 0 THEN
268: oe_debug_pub.add( 'CALLING CHECK_DUPLICATE_COMPONENTS' , 1 ) ;
269: END IF;
270:
271: Check_Duplicate_Components
272: ( p_options_tbl => l_options_tbl

Line 291: oe_debug_pub.add( 'CALLING CASCADE_UPDATES_DELETES' , 1 ) ;

287: IF l_updated_options_tbl.COUNT > 0 OR
288: l_deleted_options_tbl.COUNT > 0 THEN
289:
290: IF l_debug_level > 0 THEN
291: oe_debug_pub.add( 'CALLING CASCADE_UPDATES_DELETES' , 1 ) ;
292: END IF;
293:
294: OE_Config_Util.Cascade_Updates_Deletes
295: ( p_model_line_id => p_top_model_line_id

Line 308: oe_debug_pub.add( 'CALLING FILL_IN_CLASSES' , 1 ) ;

304: END IF; -- if ui flag is Y
305:
306:
307: IF l_debug_level > 0 THEN
308: oe_debug_pub.add( 'CALLING FILL_IN_CLASSES' , 1 ) ;
309: END IF;
310:
311:
312: Fill_In_Classes

Line 331: oe_debug_pub.add( 'CALLING BOM_BASED_VALIDATION' , 1 ) ;

327: ,x_bom_validation_tbl => l_bom_validation_tbl);
328:
329:
330: IF l_debug_level > 0 THEN
331: oe_debug_pub.add( 'CALLING BOM_BASED_VALIDATION' , 1 ) ;
332: END IF;
333:
334: IF l_bom_validation_tbl.COUNT > 0 THEN
335:

Line 347: oe_debug_pub.add( 'VALIDATION STATUS '|| L_VALIDATION_STATUS , 1 ) ;

343: x_valid_config := l_valid_config;
344: x_complete_config := l_complete_config;
345:
346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'VALIDATION STATUS '|| L_VALIDATION_STATUS , 1 ) ;
348: END IF;
349:
350: IF l_validation_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 364: oe_debug_pub.add('CALLER IS BOOKING AND ERRORED OUT' , 2 );

360: IF p_caller = 'BOOKING' AND
361: (l_valid_config = 'FALSE' OR l_complete_config = 'FALSE') THEN
362:
363: IF l_debug_level > 0 THEN
364: oe_debug_pub.add('CALLER IS BOOKING AND ERRORED OUT' , 2 );
365: END IF;
366:
367: x_return_status := l_validation_status;
368: RETURN;

Line 373: oe_debug_pub.add( 'ORDER IS BOOKED' , 1 ) ;

369: END IF; -- bug 4636208 ends
370:
371: IF nvl(l_model_line_rec.booked_flag, 'N' ) = 'Y' THEN
372: IF l_debug_level > 0 THEN
373: oe_debug_pub.add( 'ORDER IS BOOKED' , 1 ) ;
374: END IF;
375:
376: OE_Config_Pvt.put_hold_and_release_hold
377: (p_header_id => p_header_id,

Line 390: oe_debug_pub.add( 'NO OPTIONS TO VALIDATE' , 1 ) ;

386: END IF;
387:
388: ELSE
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add( 'NO OPTIONS TO VALIDATE' , 1 ) ;
391: END IF;
392: END IF;
393:
394:

Line 396: oe_debug_pub.add( 'CALLING HANDLE_DML' , 1 ) ;

392: END IF;
393:
394:
395: IF l_debug_level > 0 THEN
396: oe_debug_pub.add( 'CALLING HANDLE_DML' , 1 ) ;
397: END IF;
398:
399: Handle_DML
400: ( p_options_tbl => l_options_tbl

Line 412: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;

408: ( p_count => x_msg_count
409: , p_data => x_msg_data );
410:
411: IF l_debug_level > 0 THEN
412: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
413: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
414: END IF;
415:
416: Print_Time('Process_Config_Options end time');

Line 413: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;

409: , p_data => x_msg_data );
410:
411: IF l_debug_level > 0 THEN
412: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
413: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
414: END IF;
415:
416: Print_Time('Process_Config_Options end time');
417:

Line 432: oe_debug_pub.add('LEAVING PROCESS_CONFIG_OPTIONS'||X_RETURN_STATUS,5);

428: x_return_status := l_return_status;
429: END IF;
430:
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add('LEAVING PROCESS_CONFIG_OPTIONS'||X_RETURN_STATUS,5);
433: END IF;
434:
435: EXCEPTION
436:

Line 441: oe_debug_pub.add( 'EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);

437: -- IMP please read procedure description.
438:
439: WHEN FND_API.G_EXC_ERROR THEN
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);
442: END IF;
443:
444: IF p_ui_flag = 'Y' THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 455: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;

451: ( p_count => x_msg_count
452: , p_data => x_msg_data);
453:
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
456: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
457: END IF;
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 456: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;

452: , p_data => x_msg_data);
453:
454: IF l_debug_level > 0 THEN
455: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
456: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
457: END IF;
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: IF l_debug_level > 0 THEN

Line 461: oe_debug_pub.add('EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);

457: END IF;
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: IF l_debug_level > 0 THEN
461: oe_debug_pub.add('EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);
462: END IF;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464:
465: oe_msg_pub.count_and_get

Line 470: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;

466: ( p_count => x_msg_count
467: , p_data => x_msg_data);
468:
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
471: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
472: END IF;
473:
474: WHEN OTHERS THEN

Line 471: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;

467: , p_data => x_msg_data);
468:
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
471: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
472: END IF;
473:
474: WHEN OTHERS THEN
475: IF l_debug_level > 0 THEN

Line 476: oe_debug_pub.add( 'EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);

472: END IF;
473:
474: WHEN OTHERS THEN
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);
477: oe_debug_pub.add( 'ERROR: ' || SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
478: END IF;
479:
480: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

Line 477: oe_debug_pub.add( 'ERROR: ' || SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;

473:
474: WHEN OTHERS THEN
475: IF l_debug_level > 0 THEN
476: oe_debug_pub.add( 'EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);
477: oe_debug_pub.add( 'ERROR: ' || SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
478: END IF;
479:
480: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
481: THEN

Line 492: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;

488: ( p_count => x_msg_count
489: , p_data => x_msg_data );
490:
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
493: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
494: END IF;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496:

Line 493: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;

489: , p_data => x_msg_data );
490:
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
493: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
494: END IF;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496:
497: END Process_Config_Options;

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

515: I NUMBER;
516: l_index NUMBER;
517: l_req_rec OE_Order_Pub.Request_Rec_Type;
518: --
519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
520: --
521: BEGIN
522:
523: IF l_debug_level > 0 THEN

Line 524: oe_debug_pub.add('entering Prepare_Cascade_Tables', 3 );

520: --
521: BEGIN
522:
523: IF l_debug_level > 0 THEN
524: oe_debug_pub.add('entering Prepare_Cascade_Tables', 3 );
525: END IF;
526:
527: l_count := p_x_updated_options_tbl.COUNT;
528: l_index := p_x_deleted_options_tbl.COUNT;

Line 537: oe_debug_pub.add('disabled: '||p_options_tbl(I).component_code,1);

533:
534: IF p_options_tbl(I).disabled_flag = 'Y' THEN
535:
536: IF l_debug_level > 0 THEN
537: oe_debug_pub.add('disabled: '||p_options_tbl(I).component_code,1);
538: END IF;
539:
540: Handle_Disabled_Options
541: ( p_x_option_rec => p_options_tbl(I)

Line 549: oe_debug_pub.add('GET OLD QTY FOR '|| p_OPTIONS_TBL(I).LINE_ID,1);

545: IF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_UPDATE
546: THEN
547:
548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add('GET OLD QTY FOR '|| p_OPTIONS_TBL(I).LINE_ID,1);
550: END IF;
551:
552: SELECT ordered_quantity
553: INTO p_options_tbl(I).old_ordered_quantity

Line 575: oe_debug_pub.add('disabled hence setting param8', 4);

571: END IF;
572:
573: IF p_options_tbl(I).disabled_flag = 'Y' THEN
574: IF l_debug_level > 0 THEN
575: oe_debug_pub.add('disabled hence setting param8', 4);
576: END IF;
577: l_req_rec.param8 := 'Y';
578: ELSE
579: -- setting cancellation flag to No for now, since user can not

Line 586: oe_debug_pub.add

582: l_req_rec.param8 := 'N';
583: END IF;
584:
585: IF l_debug_level > 0 THEN
586: oe_debug_pub.add
587: ('UPDATE: '||L_REQ_REC.PARAM2||' '
588: ||L_REQ_REC.PARAM3||L_REQ_REC.PARAM5,1);
589: END IF;
590: -- 3563690

Line 612: oe_debug_pub.add( 'DELETE: '|| L_REQ_REC.PARAM2 || ' '

608: -- 3563690
609: l_req_rec.param10 := p_options_tbl(I).ordered_item ;
610:
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add( 'DELETE: '|| L_REQ_REC.PARAM2 || ' '
613: || L_REQ_REC.PARAM3 , 1 ) ;
614: END IF;
615: p_x_deleted_options_tbl(l_index) := l_req_rec;
616:

Line 623: oe_debug_pub.add('leaving Prepare_Cascade_Tables', 3 ) ;

619: I := p_options_tbl.NEXT(I);
620: END LOOP;
621:
622: IF l_debug_level > 0 THEN
623: oe_debug_pub.add('leaving Prepare_Cascade_Tables', 3 ) ;
624: END IF;
625:
626: EXCEPTION
627: WHEN OTHERS THEN

Line 629: oe_debug_pub.add('EXCEPTION IN Prepare_Cascade_Tables '|| SQLERRM ,1);

625:
626: EXCEPTION
627: WHEN OTHERS THEN
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add('EXCEPTION IN Prepare_Cascade_Tables '|| SQLERRM ,1);
630: END IF;
631: RAISE;
632: END Prepare_Cascade_Tables;
633:

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

642: RETURN NUMBER
643: IS
644: I NUMBER;
645: --
646: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
647: --
648: BEGIN
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add( 'ENTERING IND_MATCHING_COMP_INDEX'|| P_COMP_CODE , 1 ) ;

Line 650: oe_debug_pub.add( 'ENTERING IND_MATCHING_COMP_INDEX'|| P_COMP_CODE , 1 ) ;

646: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
647: --
648: BEGIN
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add( 'ENTERING IND_MATCHING_COMP_INDEX'|| P_COMP_CODE , 1 ) ;
651: END IF;
652:
653: I := p_options_tbl.FIRST;
654: WHILE I is not NULL

Line 658: oe_debug_pub.add( P_OPTIONS_TBL ( I ) .COMPONENT_CODE

654: WHILE I is not NULL
655: LOOP
656:
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( P_OPTIONS_TBL ( I ) .COMPONENT_CODE
659: || P_OPTIONS_TBL ( I ) .OPERATION , 1 ) ;
660: END IF;
661:
662: IF p_options_tbl(I).component_code = p_comp_code AND

Line 676: oe_debug_pub.add('EXCEPTION IN FIND_MATCHING_COMP_INDEX'|| SQLERRM ,1);

672: RAISE FND_API.G_EXC_ERROR;
673: EXCEPTION
674: WHEN OTHERS THEN
675: IF l_debug_level > 0 THEN
676: oe_debug_pub.add('EXCEPTION IN FIND_MATCHING_COMP_INDEX'|| SQLERRM ,1);
677: END IF;
678: RAISE;
679: END Find_Matching_Comp_Index;
680:

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

734: upper(FND_PROFILE.VALUE('ONT_CONFIG_QUICK_SAVE'));
735: l_cancellation BOOLEAN;
736:
737: --
738: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
739: --
740: BEGIN
741:
742: Print_Time('Entering Handle_DML');

Line 747: oe_debug_pub.add( 'DIRECT SAVE ON' , 1 ) ;

743:
744: IF p_model_line_rec.booked_flag = 'N' and l_profile_value = 'Y' AND
745: p_ui_flag = 'Y' THEN
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add( 'DIRECT SAVE ON' , 1 ) ;
748: END IF;
749: l_direct_save := TRUE;
750: ELSE
751: IF l_debug_level > 0 THEN

Line 752: oe_debug_pub.add( 'DIRECT SAVE OFF' || L_PROFILE_VALUE , 1 ) ;

748: END IF;
749: l_direct_save := TRUE;
750: ELSE
751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'DIRECT SAVE OFF' || L_PROFILE_VALUE , 1 ) ;
753: END IF;
754: l_direct_save := FALSE;
755: END IF;
756:

Line 763: oe_debug_pub.add( 'DIRECT SAVE IS ON' , 3 ) ;

759:
760: IF l_direct_save THEN
761:
762: IF l_debug_level > 0 THEN
763: oe_debug_pub.add( 'DIRECT SAVE IS ON' , 3 ) ;
764: END IF;
765:
766: OE_Config_Util.Default_Child_Line
767: ( p_parent_line_rec => p_model_line_rec

Line 800: oe_debug_pub.add(I|| ' OPEARION: '||P_OPTIONS_TBL(I).OPERATION ,1);

796: -- note that the operation should be INSERT and not create. CREATE is
797: -- used while calling SPC batch validation, not for process_order call.
798:
799: IF l_debug_level > 0 THEN
800: oe_debug_pub.add(I|| ' OPEARION: '||P_OPTIONS_TBL(I).OPERATION ,1);
801: END IF;
802:
803: IF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_INSERT
804: THEN

Line 807: oe_debug_pub.add('INSERT: '|| P_OPTIONS_TBL(I).COMPONENT_CODE ,1);

803: IF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_INSERT
804: THEN
805:
806: IF l_debug_level > 0 THEN
807: oe_debug_pub.add('INSERT: '|| P_OPTIONS_TBL(I).COMPONENT_CODE ,1);
808: END IF;
809:
810: IF l_direct_save AND p_options_tbl(I).bom_item_type = 2
811: THEN

Line 943: oe_debug_pub.add('UPDATE LINE_ID: '|| P_OPTIONS_TBL(I).LINE_ID ,1);

939: l_line_count := l_line_count + 1;
940: l_line_tbl(l_line_count) := l_line_upd_rec;
941:
942: IF l_debug_level > 0 THEN
943: oe_debug_pub.add('UPDATE LINE_ID: '|| P_OPTIONS_TBL(I).LINE_ID ,1);
944: END IF;
945:
946: ELSIF p_options_tbl(I).operation = OE_GLOBALS.G_OPR_DELETE THEN
947:

Line 956: oe_debug_pub.add('calling Is_Cancel_OR_Delete '

952: IF p_ui_flag = 'Y' AND
953: nvl(p_options_tbl(I).disabled_flag,'N') = 'N' THEN ---added nvl bug# 12416933
954:
955: IF l_debug_level > 0 THEN
956: oe_debug_pub.add('calling Is_Cancel_OR_Delete '
957: || l_line_del_rec.line_id, 3);
958: END IF;
959:
960: OE_Config_Pvt.Is_Cancel_OR_Delete

Line 967: oe_debug_pub.add('operation '|| l_line_del_rec.operation, 1);

963: ,p_change_comments => 'Changes in Options Window'
964: ,x_cancellation => l_cancellation
965: ,x_line_rec => l_line_del_rec);
966:
967: oe_debug_pub.add('operation '|| l_line_del_rec.operation, 1);
968: END IF;
969:
970: l_line_tbl(l_line_count) := l_line_del_rec;
971:

Line 973: oe_debug_pub.add('DELETE LINE_ID: '|| P_OPTIONS_TBL(I).LINE_ID , 1);

969:
970: l_line_tbl(l_line_count) := l_line_del_rec;
971:
972: IF l_debug_level > 0 THEN
973: oe_debug_pub.add('DELETE LINE_ID: '|| P_OPTIONS_TBL(I).LINE_ID , 1);
974: END IF;
975:
976: ELSE
977: IF l_debug_level > 0 THEN

Line 978: oe_debug_pub.add

974: END IF;
975:
976: ELSE
977: IF l_debug_level > 0 THEN
978: oe_debug_pub.add
979: ('NO ACTION OPERATION '|| p_options_tbl(I).disabled_flag, 1 ) ;
980: END IF;
981:
982: END IF; -- operation = create

Line 988: oe_debug_pub.add

984: I := p_options_tbl.NEXT(I);
985: END LOOP;
986:
987: IF l_debug_level > 0 THEN
988: oe_debug_pub.add
989: ( 'OUT OF LOOP '|| L_LINE_COUNT || ' ' || L_CLASS_LINE_COUNT , 1 ) ;
990: END IF;
991:
992:

Line 1017: oe_debug_pub.add( 'EXCEPTION IN HANDLE_DML: '|| SQLERRM , 1 ) ;

1013:
1014: EXCEPTION
1015: WHEN OTHERS THEN
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'EXCEPTION IN HANDLE_DML: '|| SQLERRM , 1 ) ;
1018: END IF;
1019: RAISE;
1020: END Handle_DML;
1021:

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

1039: l_line_count NUMBER;
1040: l_dummy VARCHAR2(30);
1041: l_cancellation BOOLEAN;
1042: --
1043: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1044: --
1045: BEGIN
1046:
1047: FND_MESSAGE.Set_Name('ONT', 'ONT_CONFIG_DISABLED_OPTION');

Line 1077: oe_debug_pub.add('do cancellation hence update with 0', 3 );

1073: ,x_line_rec => l_line_rec);
1074:
1075: IF l_cancellation THEN
1076: IF l_debug_level > 0 THEN
1077: oe_debug_pub.add('do cancellation hence update with 0', 3 );
1078: END IF;
1079:
1080: p_x_option_rec.ordered_quantity := 0;
1081: p_x_option_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line 1090: oe_debug_pub.add('no cancellation, delete ok ', 3 ) ;

1086: ELSE
1087: p_x_option_rec.operation := OE_GLOBALS.G_OPR_DELETE;
1088:
1089: IF l_debug_level > 0 THEN
1090: oe_debug_pub.add('no cancellation, delete ok ', 3 ) ;
1091: END IF;
1092: END IF;
1093:
1094: IF l_debug_level > 0 THEN

Line 1095: oe_debug_pub.add('option operation '|| p_x_option_rec.operation, 3);

1091: END IF;
1092: END IF;
1093:
1094: IF l_debug_level > 0 THEN
1095: oe_debug_pub.add('option operation '|| p_x_option_rec.operation, 3);
1096: END IF;
1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN

Line 1101: oe_debug_pub.add('EXCEPTION Handle_Disabled_Options: '||SQLERRM,1);

1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: IF l_debug_level > 0 THEN
1101: oe_debug_pub.add('EXCEPTION Handle_Disabled_Options: '||SQLERRM,1);
1102: END IF;
1103: RAISE;
1104: END Handle_Disabled_Options;
1105:

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

1136: l_result BOOLEAN;
1137: l_validation_org NUMBER;
1138: l_last NUMBER;
1139: --
1140: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1141: --
1142: BEGIN
1143:
1144: Print_Time('Entering Fill_In_Classes start time');

Line 1157: oe_debug_pub.add( 'I: '|| I , 1 ) ;

1153:
1154: I := p_x_options_tbl.FIRST;
1155:
1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add( 'I: '|| I , 1 ) ;
1158: END IF;
1159:
1160: WHILE I is not null
1161: LOOP

Line 1174: oe_debug_pub.add( I || 'HERE COMPONENT: '|| L_COMPONENT , 1 ) ;

1170: SUBSTR(l_orig_component, 1, (INSTR(l_orig_component, '-', 1, J) -1));
1171:
1172:
1173: IF l_debug_level > 0 THEN
1174: oe_debug_pub.add( I || 'HERE COMPONENT: '|| L_COMPONENT , 1 ) ;
1175: END IF;
1176:
1177: WHILE l_component is NOT NULL
1178: LOOP

Line 1181: oe_debug_pub.add( 'INNER LOOP COMPONENT: '|| L_COMPONENT , 1 ) ;

1177: WHILE l_component is NOT NULL
1178: LOOP
1179:
1180: IF l_debug_level > 0 THEN
1181: oe_debug_pub.add( 'INNER LOOP COMPONENT: '|| L_COMPONENT , 1 ) ;
1182: END IF;
1183: component_exists
1184: ( p_component => l_component
1185: ,p_options_tbl => p_x_options_tbl

Line 1190: oe_debug_pub.add( 'COMOPNENT NOT THERE , SO ADD '||L_COMPONENT,1);

1186: ,x_result => l_result);
1187:
1188: IF NOT (l_result) THEN
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( 'COMOPNENT NOT THERE , SO ADD '||L_COMPONENT,1);
1191: END IF;
1192: l_count := l_count + 1;
1193: l_options_tbl_index := l_options_tbl_index + 1;
1194: p_x_options_tbl(l_options_tbl_index).component_code := l_component;

Line 1198: oe_debug_pub.add( 'COMPONENT ALREADY PRESENT' , 1 ) ;

1194: p_x_options_tbl(l_options_tbl_index).component_code := l_component;
1195: p_x_options_tbl(l_options_tbl_index).operation := OE_GLOBALS.G_OPR_INSERT;
1196: ELSE
1197: IF l_debug_level > 0 THEN
1198: oe_debug_pub.add( 'COMPONENT ALREADY PRESENT' , 1 ) ;
1199: END IF;
1200: END IF;
1201:
1202: J := J + 1;

Line 1211: oe_debug_pub.add('COUNT IN OPTIONS TABLE: '|| P_X_OPTIONS_TBL.COUNT,1);

1207: I := p_x_options_tbl.NEXT(I);
1208: END LOOP;
1209:
1210: IF l_debug_level > 0 THEN
1211: oe_debug_pub.add('COUNT IN OPTIONS TABLE: '|| P_X_OPTIONS_TBL.COUNT,1);
1212: oe_debug_pub.add( 'COUNT SENT IN: '|| L_IN_COUNT , 1 ) ;
1213: END IF;
1214:
1215: IF p_x_options_tbl.count = l_in_count THEN

Line 1212: oe_debug_pub.add( 'COUNT SENT IN: '|| L_IN_COUNT , 1 ) ;

1208: END LOOP;
1209:
1210: IF l_debug_level > 0 THEN
1211: oe_debug_pub.add('COUNT IN OPTIONS TABLE: '|| P_X_OPTIONS_TBL.COUNT,1);
1212: oe_debug_pub.add( 'COUNT SENT IN: '|| L_IN_COUNT , 1 ) ;
1213: END IF;
1214:
1215: IF p_x_options_tbl.count = l_in_count THEN
1216: IF l_debug_level > 0 THEN

Line 1217: oe_debug_pub.add( 'NOTHING TO FILL' , 1 ) ;

1213: END IF;
1214:
1215: IF p_x_options_tbl.count = l_in_count THEN
1216: IF l_debug_level > 0 THEN
1217: oe_debug_pub.add( 'NOTHING TO FILL' , 1 ) ;
1218: END IF;
1219: RETURN;
1220: END IF;
1221:

Line 1231: oe_debug_pub.add

1227:
1228: l_component := p_x_options_tbl(I).component_code;
1229:
1230: IF l_debug_level > 0 THEN
1231: oe_debug_pub.add
1232: ( 'COMP COMPLETING: '|| L_COMPONENT ||' ' || L_VALIDATION_ORG , 1 ) ;
1233: END IF;
1234:
1235: SELECT component_sequence_id, component_item_id, sort_order,

Line 1272: oe_debug_pub.add( 'EXCEPTION IN FILL_IN_CLASSES' || SQLERRM , 1 ) ;

1268:
1269: EXCEPTION
1270: WHEN OTHERS THEN
1271: IF l_debug_level > 0 THEN
1272: oe_debug_pub.add( 'EXCEPTION IN FILL_IN_CLASSES' || SQLERRM , 1 ) ;
1273: END IF;
1274: RAISE;
1275: END Fill_In_Classes;
1276:

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

1289: ,x_result OUT NOCOPY /* file.sql.39 change */ BOOLEAN)
1290: IS
1291: I NUMBER;
1292: --
1293: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1294: --
1295: BEGIN
1296:
1297: I := p_options_tbl.FIRST;

Line 1302: oe_debug_pub.add(I || ' COMPARING TO COMPONENT: '

1298:
1299: WHILE I is not null
1300: LOOP
1301: IF l_debug_level > 0 THEN
1302: oe_debug_pub.add(I || ' COMPARING TO COMPONENT: '
1303: || P_OPTIONS_TBL ( I ) .COMPONENT_CODE , 1 ) ;
1304: END IF;
1305:
1306: IF p_options_tbl(I).component_code = p_component AND

Line 1310: oe_debug_pub.add( 'COMPONENT FOUND' , 1 ) ;

1306: IF p_options_tbl(I).component_code = p_component AND
1307: nvl(p_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE) <>
1308: OE_GLOBALS.G_OPR_DELETE THEN
1309: IF l_debug_level > 0 THEN
1310: oe_debug_pub.add( 'COMPONENT FOUND' , 1 ) ;
1311: END IF;
1312: x_result := true;
1313: RETURN;
1314: END IF;

Line 1322: oe_debug_pub.add( 'LEAVING COMPONENT_NOT_EXIST' , 1 ) ;

1318:
1319: x_result := false;
1320:
1321: IF l_debug_level > 0 THEN
1322: oe_debug_pub.add( 'LEAVING COMPONENT_NOT_EXIST' , 1 ) ;
1323: END IF;
1324: EXCEPTION
1325: WHEN OTHERS THEN
1326: IF l_debug_level > 0 THEN

Line 1327: oe_debug_pub.add( 'EXCEPTION IN COMPONENT_NOT_EXIST' || SQLERRM , 1 ) ;

1323: END IF;
1324: EXCEPTION
1325: WHEN OTHERS THEN
1326: IF l_debug_level > 0 THEN
1327: oe_debug_pub.add( 'EXCEPTION IN COMPONENT_NOT_EXIST' || SQLERRM , 1 ) ;
1328: END IF;
1329: RAISE;
1330: END component_exists;
1331:

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

1343: l_outer_index NUMBER;
1344: l_inner_index NUMBER;
1345: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1346: --
1347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1348: --
1349: BEGIN
1350: IF l_debug_level > 0 THEN
1351: oe_debug_pub.add( 'ENTERING CHECK_DUPLICATE_COMPONENTS' , 1 ) ;

Line 1351: oe_debug_pub.add( 'ENTERING CHECK_DUPLICATE_COMPONENTS' , 1 ) ;

1347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1348: --
1349: BEGIN
1350: IF l_debug_level > 0 THEN
1351: oe_debug_pub.add( 'ENTERING CHECK_DUPLICATE_COMPONENTS' , 1 ) ;
1352: oe_debug_pub.add( 'COUNT: '|| P_OPTIONS_TBL.COUNT , 1 ) ;
1353: END IF;
1354:
1355: l_outer_index := p_options_tbl.FIRST;

Line 1352: oe_debug_pub.add( 'COUNT: '|| P_OPTIONS_TBL.COUNT , 1 ) ;

1348: --
1349: BEGIN
1350: IF l_debug_level > 0 THEN
1351: oe_debug_pub.add( 'ENTERING CHECK_DUPLICATE_COMPONENTS' , 1 ) ;
1352: oe_debug_pub.add( 'COUNT: '|| P_OPTIONS_TBL.COUNT , 1 ) ;
1353: END IF;
1354:
1355: l_outer_index := p_options_tbl.FIRST;
1356: WHILE l_outer_index is not NULL

Line 1360: oe_debug_pub.add(p_OPTIONS_TBL(l_outer_index).operation

1356: WHILE l_outer_index is not NULL
1357: LOOP
1358:
1359: IF l_debug_level > 0 THEN
1360: oe_debug_pub.add(p_OPTIONS_TBL(l_outer_index).operation
1361: || p_OPTIONS_TBL(l_outer_index).component_code,3);
1362: END IF;
1363:
1364: IF p_options_tbl(l_outer_index).operation =

Line 1370: oe_debug_pub.add( L_OUTER_INDEX || ' CHECK DUPL: '

1366: p_options_tbl(l_outer_index).operation =
1367: OE_GLOBALS.G_OPR_INSERT
1368: THEN
1369: IF l_debug_level > 0 THEN
1370: oe_debug_pub.add( L_OUTER_INDEX || ' CHECK DUPL: '
1371: ||P_OPTIONS_TBL ( L_OUTER_INDEX ) .COMPONENT_CODE , 1 ) ;
1372: oe_debug_pub.add( 'SORT ORDER: '
1373: || P_OPTIONS_TBL ( L_OUTER_INDEX ) .SORT_ORDER , 1 ) ;
1374: END IF;

Line 1372: oe_debug_pub.add( 'SORT ORDER: '

1368: THEN
1369: IF l_debug_level > 0 THEN
1370: oe_debug_pub.add( L_OUTER_INDEX || ' CHECK DUPL: '
1371: ||P_OPTIONS_TBL ( L_OUTER_INDEX ) .COMPONENT_CODE , 1 ) ;
1372: oe_debug_pub.add( 'SORT ORDER: '
1373: || P_OPTIONS_TBL ( L_OUTER_INDEX ) .SORT_ORDER , 1 ) ;
1374: END IF;
1375:
1376: l_inner_index := p_options_tbl.FIRST;

Line 1382: oe_debug_pub.add(L_INNER_INDEX

1378: WHILE l_inner_index is not NULL
1379: LOOP
1380:
1381: IF l_debug_level > 0 THEN
1382: oe_debug_pub.add(L_INNER_INDEX
1383: || P_OPTIONS_TBL ( L_INNER_INDEX ) .COMPONENT_CODE , 1 ) ;
1384: END IF;
1385:
1386: IF l_inner_index <> l_outer_index THEN

Line 1392: oe_debug_pub.add( 'DUPLICATE EXIST' , 1 ) ;

1388: p_options_tbl(l_outer_index).component_code
1389: THEN
1390:
1391: IF l_debug_level > 0 THEN
1392: oe_debug_pub.add( 'DUPLICATE EXIST' , 1 ) ;
1393: END IF;
1394:
1395: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396:

Line 1411: oe_debug_pub.add( 'LEAVING CHECK_DUPLICATE_COMPONENTS' , 1 ) ;

1407: END LOOP;
1408:
1409: x_return_status := l_return_status;
1410: IF l_debug_level > 0 THEN
1411: oe_debug_pub.add( 'LEAVING CHECK_DUPLICATE_COMPONENTS' , 1 ) ;
1412: END IF;
1413:
1414: EXCEPTION
1415: WHEN OTHERS THEN

Line 1417: oe_debug_pub.add('EXCEPTION IN CHECK_DUPLICATE_OPTIONS'|| SQLERRM,1);

1413:
1414: EXCEPTION
1415: WHEN OTHERS THEN
1416: IF l_debug_level > 0 THEN
1417: oe_debug_pub.add('EXCEPTION IN CHECK_DUPLICATE_OPTIONS'|| SQLERRM,1);
1418: END IF;
1419: RAISE;
1420: END Check_Duplicate_Components;
1421:

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

1456: l_configurator_product_id NUMBER := 708;
1457: l_profile_value VARCHAR2(240);
1458:
1459: --
1460: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1461: --
1462: BEGIN
1463: IF l_debug_level > 0 THEN
1464: oe_debug_pub.add( 'ENTERING USE_CONFIGURATOR' , 1 ) ;

Line 1464: oe_debug_pub.add( 'ENTERING USE_CONFIGURATOR' , 1 ) ;

1460: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1461: --
1462: BEGIN
1463: IF l_debug_level > 0 THEN
1464: oe_debug_pub.add( 'ENTERING USE_CONFIGURATOR' , 1 ) ;
1465: END IF;
1466:
1467: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED IS NULL THEN
1468: OE_GLOBALS.G_CONFIGURATOR_INSTALLED

Line 1477: oe_debug_pub.add('CONFIGURATOR IS INSTALLED PROFILE SET TO YES',1);

1473:
1474: IF nvl(l_profile_value, 'Y') = 'Y' THEN
1475: IF OE_GLOBALS.G_CONFIGURATOR_INSTALLED = 'Y' THEN
1476: IF l_debug_level > 0 THEN
1477: oe_debug_pub.add('CONFIGURATOR IS INSTALLED PROFILE SET TO YES',1);
1478: END IF;
1479: RETURN true;
1480: ELSE
1481: l_profile_value := FND_PROFILE.VALUE('CZ_UIMGR_URL');

Line 1486: oe_debug_pub.add( 'URL VALUE IS NULL , USE OPTIONS WINDOW' , 1 ) ;

1482:
1483: IF l_profile_value is NULL THEN
1484:
1485: IF l_debug_level > 0 THEN
1486: oe_debug_pub.add( 'URL VALUE IS NULL , USE OPTIONS WINDOW' , 1 ) ;
1487: END IF;
1488:
1489: RETURN false;
1490: ELSE

Line 1493: oe_debug_pub.add( 'URL PROFILE VALUE '|| L_PROFILE_VALUE , 1 ) ;

1489: RETURN false;
1490: ELSE
1491:
1492: IF l_debug_level > 0 THEN
1493: oe_debug_pub.add( 'URL PROFILE VALUE '|| L_PROFILE_VALUE , 1 ) ;
1494: END IF;
1495:
1496: RETURN true;
1497: END IF;

Line 1501: oe_debug_pub.add( 'USE OPTIONS WINDOW' , 1 ) ;

1497: END IF;
1498: END IF;
1499: ELSE -- use_configurator profile is set to 'N'
1500: IF l_debug_level > 0 THEN
1501: oe_debug_pub.add( 'USE OPTIONS WINDOW' , 1 ) ;
1502: END IF;
1503: RETURN false;
1504: END IF;
1505:

Line 1507: oe_debug_pub.add( 'LEAVING USE_CONFIGURATOR' , 1 ) ;

1503: RETURN false;
1504: END IF;
1505:
1506: IF l_debug_level > 0 THEN
1507: oe_debug_pub.add( 'LEAVING USE_CONFIGURATOR' , 1 ) ;
1508: END IF;
1509:
1510: EXCEPTION
1511: WHEN OTHERS THEN

Line 1513: oe_debug_pub.add( 'USE_CONFIGURATOR EXCEPTION'|| SQLERRM , 1 ) ;

1509:
1510: EXCEPTION
1511: WHEN OTHERS THEN
1512: IF l_debug_level > 0 THEN
1513: oe_debug_pub.add( 'USE_CONFIGURATOR EXCEPTION'|| SQLERRM , 1 ) ;
1514: END IF;
1515: RETURN false;
1516: END Use_Configurator;
1517:

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

1580: l_msg_data VARCHAR2(2000);
1581: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1582:
1583: --
1584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1585: --
1586: BEGIN
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add(p_query_criteria || '-ENTERING GET_OPTIONS_FROM_DB'

Line 1588: oe_debug_pub.add(p_query_criteria || '-ENTERING GET_OPTIONS_FROM_DB'

1584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1585: --
1586: BEGIN
1587: IF l_debug_level > 0 THEN
1588: oe_debug_pub.add(p_query_criteria || '-ENTERING GET_OPTIONS_FROM_DB'
1589: || P_TOP_MODEL_LINE_ID,1);
1590: END IF;
1591:
1592: x_disabled_options := 'N';

Line 1626: oe_debug_pub.add('nothing can be disabled ', 1);

1622: ELSE
1623: IF p_query_criteria = 3 THEN
1624:
1625: IF l_debug_level > 0 THEN
1626: oe_debug_pub.add('nothing can be disabled ', 1);
1627: END IF;
1628: RETURN;
1629: END IF;
1630: END IF;

Line 1656: oe_debug_pub.add('do not enter loop', 1);

1652: IF p_query_criteria in (1,2,4) THEN
1653: l_disable_code := 1; -- error code of 1 means not disabled
1654: ELSE
1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add('do not enter loop', 1);
1657: END IF;
1658: l_disable_code := 0; -- error code of 0, do not enter loop
1659: END IF;
1660:

Line 1664: oe_debug_pub.add('no data, must be disabled', 1);

1660:
1661: EXCEPTION
1662: WHEN NO_DATA_FOUND THEN
1663: IF l_debug_level > 0 THEN
1664: oe_debug_pub.add('no data, must be disabled', 1);
1665: END IF;
1666:
1667: IF p_query_criteria in (1,3,4) THEN
1668: l_disable_code := 2; -- error code of 2 means disabled

Line 1675: oe_debug_pub.add('too many rows', 1);

1671: END IF;
1672:
1673: WHEN TOO_MANY_ROWS THEN
1674: IF l_debug_level > 0 THEN
1675: oe_debug_pub.add('too many rows', 1);
1676: END IF;
1677: RAISE;
1678:
1679: WHEN OTHERS THEN

Line 1681: oe_debug_pub.add('bom item select error '|| sqlerrm, 1);

1677: RAISE;
1678:
1679: WHEN OTHERS THEN
1680: IF l_debug_level > 0 THEN
1681: oe_debug_pub.add('bom item select error '|| sqlerrm, 1);
1682: END IF;
1683: RAISE;
1684: END;
1685: END IF; -- frozen or not

Line 1688: oe_debug_pub.add('disable_code '|| l_disable_code, 3);

1684: END;
1685: END IF; -- frozen or not
1686:
1687: IF l_debug_level > 0 THEN
1688: oe_debug_pub.add('disable_code '|| l_disable_code, 3);
1689: END IF;
1690:
1691: IF ((opt_rec.bom_item_type = 1 AND p_get_model_line) OR
1692: opt_rec.bom_item_type <> 1 ) AND

Line 1697: oe_debug_pub.add('SAVED OPTION FROM DB '||OPT_REC.COMPONENT_CODE,3);

1693: l_disable_code > 0 THEN
1694:
1695:
1696: IF l_debug_level > 0 THEN
1697: oe_debug_pub.add('SAVED OPTION FROM DB '||OPT_REC.COMPONENT_CODE,3);
1698: END IF;
1699:
1700: IF p_caller = 'OPTIONS WINDOW UI' THEN
1701: I := Mod(opt_rec.line_id,G_BINARY_LIMIT); -- Bug 8656395

Line 1722: oe_debug_pub.add('disabled ****', 1);

1718: x_options_tbl(I).disabled_flag := 'Y';
1719: x_disabled_options := 'Y';
1720:
1721: IF l_debug_level > 0 THEN
1722: oe_debug_pub.add('disabled ****', 1);
1723: END IF;
1724: ELSE
1725: x_options_tbl(I).disabled_flag := 'N';
1726: END IF;

Line 1760: oe_debug_pub.add('QTY FROM DB '|| OPT_REC.ORDERED_QUANTITY , 3 );

1756:
1757: x_options_tbl(I).line_id := opt_rec.line_id;
1758:
1759: IF l_debug_level > 0 THEN
1760: oe_debug_pub.add('QTY FROM DB '|| OPT_REC.ORDERED_QUANTITY , 3 );
1761: oe_debug_pub.add('ATTRIBUTE1 FROM DB '|| OPT_REC.ATTRIBUTE1 , 3 );
1762: END IF;
1763: ELSE
1764: IF l_debug_level > 0 THEN

Line 1761: oe_debug_pub.add('ATTRIBUTE1 FROM DB '|| OPT_REC.ATTRIBUTE1 , 3 );

1757: x_options_tbl(I).line_id := opt_rec.line_id;
1758:
1759: IF l_debug_level > 0 THEN
1760: oe_debug_pub.add('QTY FROM DB '|| OPT_REC.ORDERED_QUANTITY , 3 );
1761: oe_debug_pub.add('ATTRIBUTE1 FROM DB '|| OPT_REC.ATTRIBUTE1 , 3 );
1762: END IF;
1763: ELSE
1764: IF l_debug_level > 0 THEN
1765: oe_debug_pub.add('----- not assigned '||OPT_REC.COMPONENT_CODE,3);

Line 1765: oe_debug_pub.add('----- not assigned '||OPT_REC.COMPONENT_CODE,3);

1761: oe_debug_pub.add('ATTRIBUTE1 FROM DB '|| OPT_REC.ATTRIBUTE1 , 3 );
1762: END IF;
1763: ELSE
1764: IF l_debug_level > 0 THEN
1765: oe_debug_pub.add('----- not assigned '||OPT_REC.COMPONENT_CODE,3);
1766: END IF;
1767: END IF; -- if not bom_item = 1
1768:
1769: END LOOP;

Line 1772: oe_debug_pub.add( 'LEAVING GET_OPTIONS_FROM_DB' , 1 ) ;

1768:
1769: END LOOP;
1770:
1771: IF l_debug_level > 0 THEN
1772: oe_debug_pub.add( 'LEAVING GET_OPTIONS_FROM_DB' , 1 ) ;
1773: END IF;
1774:
1775: EXCEPTION
1776: WHEN OTHERS THEN

Line 1778: oe_debug_pub.add( 'GET_OPTIONS_FROM_DB EXCEPTION'|| SQLERRM , 1 ) ;

1774:
1775: EXCEPTION
1776: WHEN OTHERS THEN
1777: IF l_debug_level > 0 THEN
1778: oe_debug_pub.add( 'GET_OPTIONS_FROM_DB EXCEPTION'|| SQLERRM , 1 ) ;
1779: END IF;
1780: RAISE;
1781: END Get_Options_From_DB;
1782:

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

1788: PROCEDURE Print_Time(p_msg IN VARCHAR2)
1789: IS
1790: l_time VARCHAR2(100);
1791: --
1792: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1793: --
1794: BEGIN
1795: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
1796: 'DD-MON-YY HH24:MI:SS');

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

1794: BEGIN
1795: l_time := to_char (new_time (sysdate, 'PST', 'EST'),
1796: 'DD-MON-YY HH24:MI:SS');
1797: IF l_debug_level > 0 THEN
1798: oe_debug_pub.add( P_MSG || ': '|| L_TIME , 1 ) ;
1799: END IF;
1800: END Print_Time;
1801:
1802:

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

1807:
1808: PROCEDURE Handle_Ret_Status(p_return_Status VARCHAR2)
1809: IS
1810: --
1811: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1812: --
1813: BEGIN
1814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1829: IS
1830: I NUMBER;
1831: l_count NUMBER;
1832: --
1833: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1834: --
1835: BEGIN
1836: IF l_debug_level > 0 THEN
1837: oe_debug_pub.add( 'ENTERING LOAD_BOM_TABLE' , 1 ) ;

Line 1837: oe_debug_pub.add( 'ENTERING LOAD_BOM_TABLE' , 1 ) ;

1833: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1834: --
1835: BEGIN
1836: IF l_debug_level > 0 THEN
1837: oe_debug_pub.add( 'ENTERING LOAD_BOM_TABLE' , 1 ) ;
1838: END IF;
1839:
1840: l_count := 0;
1841: I := p_options_tbl.FIRST;

Line 1844: oe_debug_pub.add('NUMBER OF OPTION SENT IN ' || P_OPTIONS_TBL.COUNT,1);

1840: l_count := 0;
1841: I := p_options_tbl.FIRST;
1842:
1843: IF l_debug_level > 0 THEN
1844: oe_debug_pub.add('NUMBER OF OPTION SENT IN ' || P_OPTIONS_TBL.COUNT,1);
1845: END IF;
1846:
1847: WHILE I is not null
1848: LOOP

Line 1851: oe_debug_pub.add(P_OPTIONS_TBL(I).disabled_flag || ' child '

1847: WHILE I is not null
1848: LOOP
1849:
1850: IF l_debug_level > 0 THEN
1851: oe_debug_pub.add(P_OPTIONS_TBL(I).disabled_flag || ' child '
1852: || P_OPTIONS_TBL(I).line_id,1);
1853: END IF;
1854:
1855: IF nvl(p_options_tbl(I).operation, OE_GLOBALS.G_OPR_NONE)

Line 1860: oe_debug_pub.add

1856: <> OE_GLOBALS.G_OPR_DELETE AND
1857: nvl(p_options_tbl(I).disabled_flag, 'N') = 'N' THEN
1858:
1859: IF l_debug_level > 0 THEN
1860: oe_debug_pub.add
1861: ( 'COMPONENT: '|| P_OPTIONS_TBL ( I ) .COMPONENT_CODE , 2 ) ;
1862: END IF;
1863:
1864: l_count := l_count + 1;

Line 1880: oe_debug_pub.add( 'LEAVING LOAD_BOM_TABLE' , 1 ) ;

1876: I := p_options_tbl.NEXT(I);
1877: END LOOP;
1878:
1879: IF l_debug_level > 0 THEN
1880: oe_debug_pub.add( 'LEAVING LOAD_BOM_TABLE' , 1 ) ;
1881: END IF;
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: IF l_debug_level > 0 THEN

Line 1885: oe_debug_pub.add( 'LOAD_BOM_TABLE EXCEPTION'|| SQLERRM , 1 ) ;

1881: END IF;
1882: EXCEPTION
1883: WHEN OTHERS THEN
1884: IF l_debug_level > 0 THEN
1885: oe_debug_pub.add( 'LOAD_BOM_TABLE EXCEPTION'|| SQLERRM , 1 ) ;
1886: END IF;
1887: RAISE;
1888: END;
1889: