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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 247: oe_debug_pub.add

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

Line 256: oe_debug_pub.add

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 585: oe_debug_pub.add

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 955: oe_debug_pub.add('calling Is_Cancel_OR_Delete '

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

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

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

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

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

Line 977: oe_debug_pub.add

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

Line 987: oe_debug_pub.add

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1230: oe_debug_pub.add

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1381: oe_debug_pub.add(L_INNER_INDEX

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1859: oe_debug_pub.add

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

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

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

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

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