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

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

28: AND WIAS.activity_status = 'DEFERRED'
29: AND WPA.activity_name = 'BOOK_DEFER'
30: AND WPA.instance_id = WIAS.process_activity;
31: --
32: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
33: --
34: BEGIN
35: IF l_debug_level > 0 THEN
36: oe_debug_pub.add( 'CHECK IF BOOKING IS DEFERRED' ) ;

Line 36: oe_debug_pub.add( 'CHECK IF BOOKING IS DEFERRED' ) ;

32: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
33: --
34: BEGIN
35: IF l_debug_level > 0 THEN
36: oe_debug_pub.add( 'CHECK IF BOOKING IS DEFERRED' ) ;
37: END IF;
38:
39: OPEN book_deferred;
40: FETCH book_deferred INTO l_book_deferred;

Line 44: oe_debug_pub.add( 'BOOKING IS DEFERRED' ) ;

40: FETCH book_deferred INTO l_book_deferred;
41:
42: IF (book_deferred%FOUND) THEN
43: IF l_debug_level > 0 THEN
44: oe_debug_pub.add( 'BOOKING IS DEFERRED' ) ;
45: END IF;
46: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOK_DEFERRED');
47: OE_MSG_PUB.ADD;
48: CLOSE book_deferred;

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

71: IS
72: l_price_control_rec QP_PREQ_GRP.control_record_type;
73: l_request_rec oe_order_pub.request_rec_type;
74: --
75: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
76: --
77: BEGIN
78: -- Oe_Debug_pub.Add('Before Book_Pricing_Event');
79: l_Price_Control_Rec.pricing_event := 'BOOK';

Line 78: -- Oe_Debug_pub.Add('Before Book_Pricing_Event');

74: --
75: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
76: --
77: BEGIN
78: -- Oe_Debug_pub.Add('Before Book_Pricing_Event');
79: l_Price_Control_Rec.pricing_event := 'BOOK';
80: l_Price_Control_Rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
81: l_Price_Control_Rec.Simulation_Flag := 'N';
82:

Line 92: -- Oe_Debug_pub.Add('After Book_Pricing_Event');

88: ,p_write_to_db => TRUE
89: ,p_request_rec => l_request_rec
90: ,x_line_Tbl => p_x_Line_Tbl
91: );
92: -- Oe_Debug_pub.Add('After Book_Pricing_Event');
93:
94: END Pricing_Book_Event;
95:
96:

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

170: FROM OE_ORDER_LINES
171: WHERE HEADER_ID = p_header_id;
172:
173: --
174: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
175: --
176: BEGIN
177: -- Added debug for bug 13435459
178: IF l_debug_level > 0 THEN

Line 179: oe_debug_pub.add( 'ENTERING UPDATE_BOOKED_FLAG', 0.5) ;

175: --
176: BEGIN
177: -- Added debug for bug 13435459
178: IF l_debug_level > 0 THEN
179: oe_debug_pub.add( 'ENTERING UPDATE_BOOKED_FLAG', 0.5) ;
180: END IF;
181:
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183: x_validate_cfg := FALSE;

Line 227: oe_debug_pub.add( 'REN: FAILED WHILE TRYING TO QUERY UP TAX_CALCUALTION_EVENT FOR ORDER_TYPE_ID IN UPDATE_BOOKED_FLAG' ) ;

223: when no_data_found then
224: l_tax_calculation_event_code := NULL;
225: when others then
226: IF l_debug_level > 0 THEN
227: oe_debug_pub.add( 'REN: FAILED WHILE TRYING TO QUERY UP TAX_CALCUALTION_EVENT FOR ORDER_TYPE_ID IN UPDATE_BOOKED_FLAG' ) ;
228: END IF;
229: RAISE;
230: END;
231: -- renga: end of change for tax calculation event enhancement

Line 580: oe_debug_pub.add('in OEXUBOKB header will do query');

576: -- made in the two update stmts to the headers and lines tables.
577: -- First make call for the header, then loop through all the lines
578:
579: -- bug 2821129
580: oe_debug_pub.add('in OEXUBOKB header will do query');
581: oe_debug_pub.add('p_header_id is '|| p_header_id);
582: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);
583: OE_HEADER_ADJ_UTIL.Query_Rows
584: (p_header_id => p_header_id

Line 581: oe_debug_pub.add('p_header_id is '|| p_header_id);

577: -- First make call for the header, then loop through all the lines
578:
579: -- bug 2821129
580: oe_debug_pub.add('in OEXUBOKB header will do query');
581: oe_debug_pub.add('p_header_id is '|| p_header_id);
582: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);
583: OE_HEADER_ADJ_UTIL.Query_Rows
584: (p_header_id => p_header_id
585: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);

Line 582: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);

578:
579: -- bug 2821129
580: oe_debug_pub.add('in OEXUBOKB header will do query');
581: oe_debug_pub.add('p_header_id is '|| p_header_id);
582: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);
583: OE_HEADER_ADJ_UTIL.Query_Rows
584: (p_header_id => p_header_id
585: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);
586:

Line 596: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);

592: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
593: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
594: END LOOP;
595:
596: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);
597:
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
600: END IF;

Line 599: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;

595:
596: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);
597:
598: IF l_debug_level > 0 THEN
599: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
600: END IF;
601: -- call notification framework to get header index position
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;

Line 603: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;

599: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
600: END IF;
601: -- call notification framework to get header index position
602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;
604: END IF;
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
607: END IF;

Line 606: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;

602: IF l_debug_level > 0 THEN
603: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;
604: END IF;
605: IF l_debug_level > 0 THEN
606: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
607: END IF;
608: OE_ORDER_UTIL.Update_Global_Picture
609: (p_Upd_New_Rec_If_Exists =>FALSE
610: , p_header_rec => l_header_rec

Line 617: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FOR HDR IS: ' || L_RETURN_STATUS ) ;

613: , x_index => l_notify_index
614: , x_return_status => l_return_status);
615:
616: IF l_debug_level > 0 THEN
617: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FOR HDR IS: ' || L_RETURN_STATUS ) ;
618: END IF;
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
621: END IF;

Line 620: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;

616: IF l_debug_level > 0 THEN
617: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FOR HDR IS: ' || L_RETURN_STATUS ) ;
618: END IF;
619: IF l_debug_level > 0 THEN
620: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
621: END IF;
622:
623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
624: RAISE FND_API.G_EXC_ERROR;

Line 632: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;

628:
629: IF l_notify_index is not null then
630: -- modify Global Picture
631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
633: END IF;
634: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
635: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
636: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';

Line 648: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;

644: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
645: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
646:
647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
649: END IF;
650: IF l_debug_level > 0 THEN
651: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
652: END IF;

Line 651: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;

647: IF l_debug_level > 0 THEN
648: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
649: END IF;
650: IF l_debug_level > 0 THEN
651: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
652: END IF;
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
655: END IF;

Line 654: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;

650: IF l_debug_level > 0 THEN
651: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
652: END IF;
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
655: END IF;
656:
657: END IF ; /* global entity index null check */
658:

Line 668: oe_debug_pub.add( 'JFC: IN BOOKING LINES , L_LOOP_INDEX= '||L_LOOP_INDEX , 1 ) ;

664: <>
665:
666: WHILE l_loop_index IS NOT NULL LOOP
667: IF l_debug_level > 0 THEN
668: oe_debug_pub.add( 'JFC: IN BOOKING LINES , L_LOOP_INDEX= '||L_LOOP_INDEX , 1 ) ;
669: END IF;
670: -- call notification framework to get this line's index position
671: OE_ORDER_UTIL.Update_Global_Picture
672: (p_Upd_New_Rec_If_Exists =>FALSE

Line 679: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;

675: , x_index => l_notify_index
676: , x_return_status => l_return_status);
677:
678: IF l_debug_level > 0 THEN
679: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
680: END IF;
681: IF l_debug_level > 0 THEN
682: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
683: END IF;

Line 682: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;

678: IF l_debug_level > 0 THEN
679: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
680: END IF;
681: IF l_debug_level > 0 THEN
682: oe_debug_pub.add( 'UPDATE_GLOBAL INDEX IN OE_ORDER_BOOK_UTIL FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
683: END IF;
684:
685: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
686: RAISE FND_API.G_EXC_ERROR;

Line 707: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;

703: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
704: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
705:
706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;
708: END IF;
709: IF l_debug_level > 0 THEN
710: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
711: END IF;

Line 710: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;

706: IF l_debug_level > 0 THEN
707: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;
708: END IF;
709: IF l_debug_level > 0 THEN
710: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
711: END IF;
712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
714: END IF;

Line 713: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;

709: IF l_debug_level > 0 THEN
710: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
711: END IF;
712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
714: END IF;
715: IF l_debug_level > 0 THEN
716: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
717: END IF;

Line 716: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;

712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
714: END IF;
715: IF l_debug_level > 0 THEN
716: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
717: END IF;
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;
720: END IF;

Line 719: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;

715: IF l_debug_level > 0 THEN
716: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
717: END IF;
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;
720: END IF;
721: END IF ; /* global entity index null check */
722:
723: -- bug 2821129

Line 725: oe_debug_pub.add('p_header_id is '|| p_header_id);

721: END IF ; /* global entity index null check */
722:
723: -- bug 2821129
724:
725: oe_debug_pub.add('p_header_id is '|| p_header_id);
726: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);
727:
728: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
729:

Line 726: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);

722:
723: -- bug 2821129
724:
725: oe_debug_pub.add('p_header_id is '|| p_header_id);
726: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);
727:
728: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
729:
730: OE_LINE_ADJ_UTIL.Query_Rows

Line 728: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);

724:
725: oe_debug_pub.add('p_header_id is '|| p_header_id);
726: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);
727:
728: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
729:
730: OE_LINE_ADJ_UTIL.Query_Rows
731: (
732: p_line_id => l_line_tbl(l_loop_index).line_id

Line 737: oe_debug_pub.add('in OEXUBOKB line adj tbl count from query row is '|| l_line_adj_tbl.count);

733: ,p_header_id => p_header_id
734: ,x_Line_Adj_Tbl => l_line_adj_tbl);
735:
736:
737: oe_debug_pub.add('in OEXUBOKB line adj tbl count from query row is '|| l_line_adj_tbl.count);
738:
739:
740: l_in_loop_index := l_line_adj_tbl.FIRST;
741:

Line 752: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);

748: , x_return_status => l_return_status);
749:
750: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
751: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
752: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);
753: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
754:
755: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
756:

Line 753: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);

749:
750: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
751: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
752: oe_debug_pub.add('in OEXUBOKB after insert into global table, line_id is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).line_id);
753: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
754:
755: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
756:
757: END LOOP;

Line 759: oe_debug_pub.add('in OEXUBOKB at end g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);

755: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
756:
757: END LOOP;
758:
759: oe_debug_pub.add('in OEXUBOKB at end g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
760:
761: l_loop_index := l_line_tbl.NEXT(l_loop_index);
762:
763: END LOOP outer; -- over each line to update global picture

Line 806: oe_debug_pub.add( 'AFTER PRICING BOOK EVENT', 0.5) ;

802:
803: IF l_active_phase_count > 0 THEN
804: -- Added debug for bug 13435459
805: IF l_debug_level > 0 THEN
806: oe_debug_pub.add( 'AFTER PRICING BOOK EVENT', 0.5) ;
807: END IF;
808:
809: Pricing_Book_Event(p_x_line_tbl => l_line_tbl
810: , p_header_id => p_header_id

Line 815: oe_debug_pub.add( 'AFTER PRICING BOOK EVENT', 0.5) ;

811: , x_return_status => l_return_status
812: );
813: -- Added debug for bug 13435459
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add( 'AFTER PRICING BOOK EVENT', 0.5) ;
816: END IF;
817: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
818: RAISE FND_API.G_EXC_ERROR;
819: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 830: oe_debug_pub.add( 'EXITING UPDATE_BOOKED_FLAG', 0.5) ;

826: Oe_Margin_Pvt.Margin_Hold(p_header_id);
827: END IF;
828: -- Added debug for bug 13435459
829: IF l_debug_level > 0 THEN
830: oe_debug_pub.add( 'EXITING UPDATE_BOOKED_FLAG', 0.5) ;
831: END IF;
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: x_return_status := FND_API.G_RET_STS_ERROR;

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

855: IS
856: l_msg_count NUMBER;
857: l_msg_data VARCHAR2(2000);
858: --
859: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
860: --
861: BEGIN
862:
863: -- If Payment Verification Fails then the Order is

Line 867: oe_debug_pub.add( 'BEFORE CALLING VERIFY PAYMENT' ) ;

863: -- If Payment Verification Fails then the Order is
864: -- Automatically Put on a Credit Checking Hold or
865: -- a Credit Card Processing Hold.
866: IF l_debug_level > 0 THEN
867: oe_debug_pub.add( 'BEFORE CALLING VERIFY PAYMENT' ) ;
868: END IF;
869: --
870: OE_Verify_Payment_PUB.Verify_Payment
871: ( p_header_id => p_header_id

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

896: IS
897: l_return_status VARCHAR2(30);
898: h_return_status VARCHAR2(30);
899: --
900: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
901: --
902: --FP bug 3872166
903: CURSOR line_ids(p_header_id IN NUMBER) IS
904: SELECT line_id

Line 909: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;

905: FROM oe_order_lines_all
906: WHERE header_id = p_header_id;
907: BEGIN
908: IF l_debug_level > 0 THEN
909: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;
910: END IF;
911:
912: h_return_status := FND_API.G_RET_STS_SUCCESS;
913: -- Validate Header Sales Credits

Line 919: oe_debug_pub.add( 'RETURN STATUS AFTER HSC:'||X_RETURN_STATUS ) ;

915: ( p_header_id => p_header_id
916: , x_return_status => x_return_status );
917:
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add( 'RETURN STATUS AFTER HSC:'||X_RETURN_STATUS ) ;
920: END IF;
921:
922: -- FP bug 4697708
923: -- h_return_status := x_return_status;

Line 953: oe_debug_pub.add( 'RETURN STATUS AFTER LSC FOR LINE '||l_line_id.line_id|| 'IS '||X_RETURN_STATUS ) ;

949: ( x_return_status => x_return_status
950: ,p_line_id => l_line_id.line_id);
951:
952: IF l_debug_level > 0 THEN
953: oe_debug_pub.add( 'RETURN STATUS AFTER LSC FOR LINE '||l_line_id.line_id|| 'IS '||X_RETURN_STATUS ) ;
954: END IF;
955:
956: -- FP bug 4697708
957: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 966: oe_debug_pub.add( 'RETURN STATUS AFTER LSC:'||L_RETURN_STATUS ) ;

962: END LOOP;
963: --FP bug 3872166 end
964:
965: IF l_debug_level > 0 THEN
966: oe_debug_pub.add( 'RETURN STATUS AFTER LSC:'||L_RETURN_STATUS ) ;
967: END IF;
968:
969: -- FP bug 4697708
970: /*

Line 991: oe_debug_pub.add('Exiting Oe_Order_Book_Util.Validate_sales_Credits: '||x_return_status ) ;

987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988: END IF;
989:
990: IF l_debug_level > 0 THEN
991: oe_debug_pub.add('Exiting Oe_Order_Book_Util.Validate_sales_Credits: '||x_return_status ) ;
992: END IF;
993:
994: EXCEPTION
995: WHEN OTHERS THEN

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

1020: l_dummy VARCHAR2(30);
1021: p_hold_rec OE_HOLDS_PUB.any_line_hold_rec;
1022:
1023: --
1024: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1025: --
1026: BEGIN
1027:
1028: IF l_debug_level > 0 THEN

Line 1029: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;

1025: --
1026: BEGIN
1027:
1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;
1030: END IF;
1031:
1032: -- Check if there are any generic or Booking holds
1033:

Line 1060: oe_debug_pub.add( 'Profile ont_prevent_booking is set' , 1 ) ;

1056: l_check_holds_result = FND_API.G_FALSE )
1057: THEN
1058: IF nvl(fnd_profile.value('ONT_PREVENT_BOOKING'),'N')='Y' THEN
1059: IF l_debug_level > 0 THEN
1060: oe_debug_pub.add( 'Profile ont_prevent_booking is set' , 1 ) ;
1061: END IF;
1062:
1063: BEGIN
1064: SELECT

Line 1076: oe_debug_pub.add( 'Before calling Check_Any_Line_Hold' , 1 ) ;

1072: p_hold_rec.wf_item_type := 'OEOH';
1073: p_hold_rec.wf_activity_name := 'BOOK_ORDER';
1074:
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'Before calling Check_Any_Line_Hold' , 1 ) ;
1077: END IF;
1078:
1079: OE_HOLDS_PUB.Check_Any_Line_Hold
1080: (x_hold_rec => p_hold_rec

Line 1103: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;

1099: END IF;
1100: END IF;
1101: /* Changes for bug#2673236:End */
1102: IF l_debug_level > 0 THEN
1103: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;
1104: END IF;
1105:
1106: EXCEPTION
1107: WHEN OTHERS THEN

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

1134: l_return_status VARCHAR2(1);
1135: l_validate_cfg BOOLEAN;
1136: l_freeze_inc_items BOOLEAN;
1137: --
1138: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1139: --
1140:
1141: l_msg_count NUMBER;
1142: l_msg_data VARCHAR2(2000);

Line 1150: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_ORDER',0.5 ) ; -- debug level 0.5 added for bug 13435459

1146:
1147:
1148: BEGIN
1149: IF l_debug_level > 0 THEN
1150: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_ORDER',0.5 ) ; -- debug level 0.5 added for bug 13435459
1151: END IF;
1152:
1153: SAVEPOINT BOOK_ORDER;
1154:

Line 1201: oe_debug_pub.add( 'RETURN STATUS AFTER SALES CREDITS:'||L_RETURN_STATUS ) ;

1197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1198: END IF;
1199:
1200: IF l_debug_level > 0 THEN
1201: oe_debug_pub.add( 'RETURN STATUS AFTER SALES CREDITS:'||L_RETURN_STATUS ) ;
1202: END IF;
1203:
1204: -- Call process order to update the booked_flag on header and
1205: -- on all the order lines. This will also check for all the fields

Line 1215: oe_debug_pub.add( 'RETURN STATUS AFTER UPDATE BOOKED:'||X_RETURN_STATUS ) ;

1211: , x_return_status => x_return_status
1212: );
1213:
1214: IF l_debug_level > 0 THEN
1215: oe_debug_pub.add( 'RETURN STATUS AFTER UPDATE BOOKED:'||X_RETURN_STATUS ) ;
1216: END IF;
1217:
1218: -- if failure during validate sales credits OR during order and
1219: -- line validation, raise error

Line 1232: oe_debug_pub.add( 'BEFORE VALIDATE CFGS', 0.5) ;

1228: -- Validate configurations, if any, in this order
1229: IF (l_validate_cfg) THEN
1230: -- Added debug for bug 13435459
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'BEFORE VALIDATE CFGS', 0.5) ;
1233: END IF;
1234:
1235: l_return_status := OE_Config_Util.Validate_Cfgs_In_Order
1236: (p_header_id => p_header_id);

Line 1238: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS,0.5 ) ; -- debug level 0.5 added for bug 13435459

1234:
1235: l_return_status := OE_Config_Util.Validate_Cfgs_In_Order
1236: (p_header_id => p_header_id);
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS,0.5 ) ; -- debug level 0.5 added for bug 13435459
1239: END IF;
1240:
1241: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1242: RAISE FND_API.G_EXC_ERROR;

Line 1257: oe_debug_pub.add( 'BEFORE FREEZE INC', 0.5) ;

1253: OE_GLOBALS.G_IIFM_BOOKING )
1254: THEN
1255: -- Added debug for bug 13435459
1256: IF l_debug_level > 0 THEN
1257: oe_debug_pub.add( 'BEFORE FREEZE INC', 0.5) ;
1258: END IF;
1259:
1260: l_return_status := OE_Config_Util.Freeze_Inc_Items_For_Order
1261: (p_header_id => p_header_id);

Line 1264: oe_debug_pub.add( 'RETURN STATUS AFTER FREEZE INC:'||L_RETURN_STATUS,0.5 ) ; -- debug level 0.5 added for bug 13435459

1260: l_return_status := OE_Config_Util.Freeze_Inc_Items_For_Order
1261: (p_header_id => p_header_id);
1262:
1263: IF l_debug_level > 0 THEN
1264: oe_debug_pub.add( 'RETURN STATUS AFTER FREEZE INC:'||L_RETURN_STATUS,0.5 ) ; -- debug level 0.5 added for bug 13435459
1265: END IF;
1266:
1267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1268: RAISE FND_API.G_EXC_ERROR;

Line 1325: oe_debug_pub.add('Contractual option not licensed, hence not performing article QA ', 3);

1321:
1322: --Check for licensing
1323: IF OE_Contracts_util.check_license() <> 'Y' THEN
1324: IF l_debug_level > 0 THEN
1325: oe_debug_pub.add('Contractual option not licensed, hence not performing article QA ', 3);
1326: END IF;
1327: ELSE
1328:
1329:

Line 1373: oe_debug_pub.add( 'BEFORE VERIFY PAYMENT', 0.5) ;

1369: --R12 CVV2
1370: IF nvl(OE_GLOBALS.G_PAYMENT_PROCESSED, 'N') <> 'Y' THEN
1371: -- Added debug for bug 13435459
1372: IF l_debug_level > 0 THEN
1373: oe_debug_pub.add( 'BEFORE VERIFY PAYMENT', 0.5) ;
1374: END IF;
1375: Verify_Payment_AT_Booking
1376: (p_header_id => p_header_id
1377: , x_return_status => l_return_status

Line 1381: oe_debug_pub.add( 'AFTER VERIFY PAYMENT', 0.5) ;

1377: , x_return_status => l_return_status
1378: );
1379: -- Added debug for bug 13435459
1380: IF l_debug_level > 0 THEN
1381: oe_debug_pub.add( 'AFTER VERIFY PAYMENT', 0.5) ;
1382: END IF;
1383: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1401: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.BOOK_ORDER' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

1397: , p_data => x_msg_data
1398: );
1399:
1400: IF l_debug_level > 0 THEN
1401: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.BOOK_ORDER' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1402: END IF;
1403:
1404: EXCEPTION
1405: -- Bug 2285308: Clear Delayed Requests when there is an error.

Line 1413: oe_debug_pub.add( 'EXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

1409: -- requests were not cleared from the cache earlier resulting
1410: -- in bugs like 2285308.
1411: WHEN FND_API.G_EXC_ERROR THEN
1412: IF l_debug_level > 0 THEN
1413: oe_debug_pub.add( 'EXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1414: END IF;
1415: x_return_status := FND_API.G_RET_STS_ERROR;
1416: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1417: OE_MSG_PUB.Count_And_Get

Line 1424: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' ,0.5 ) ; -- debug level changed to 0.5 for bug 13435459

1420: );
1421: ROLLBACK TO BOOK_ORDER;
1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: IF l_debug_level > 0 THEN
1424: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' ,0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1425: END IF;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1428: OE_MSG_PUB.Count_And_Get

Line 1435: oe_debug_pub.add( 'OTHERS ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

1431: );
1432: ROLLBACK TO BOOK_ORDER;
1433: WHEN OTHERS THEN
1434: IF l_debug_level > 0 THEN
1435: oe_debug_pub.add( 'OTHERS ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
1436: END IF;
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1439: IF FND_MSG_PUB.Check_Msg_Level

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

1506: AND WIAS.activity_status = 'ERROR'
1507: AND WPA.activity_name = 'BOOK_ORDER'
1508: AND WPA.instance_id = WIAS.process_activity;
1509: --
1510: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1511: --
1512: BEGIN
1513: IF l_debug_level > 0 THEN
1514: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;

Line 1514: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;

1510: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1511: --
1512: BEGIN
1513: IF l_debug_level > 0 THEN
1514: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;
1515: END IF;
1516:
1517: -- Initialize API return status to success
1518: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1562: oe_debug_pub.add( 'OPEN BOOK_ELIGIBLE' ) ;

1558: -- Check if for this header, the BOOK_ELIGIBLE activity is in a
1559: -- notified state
1560:
1561: IF l_debug_level > 0 THEN
1562: oe_debug_pub.add( 'OPEN BOOK_ELIGIBLE' ) ;
1563: END IF;
1564: OPEN book_eligible;
1565: FETCH book_eligible INTO l_book_eligible;
1566:

Line 1569: oe_debug_pub.add( 'BOOKING NOT ELIGIBLE' ) ;

1565: FETCH book_eligible INTO l_book_eligible;
1566:
1567: IF (book_eligible%NOTFOUND) THEN
1568: IF l_debug_level > 0 THEN
1569: oe_debug_pub.add( 'BOOKING NOT ELIGIBLE' ) ;
1570: END IF;
1571:
1572: -- Booking could be a high cost activity and could have been deferred
1573: -- due to a prior request. If the activity is in a deferred status,

Line 1606: oe_debug_pub.add( 'CLOSE BOOK_ELIGIBLE' ) ;

1602: END IF;
1603:
1604: CLOSE book_eligible;
1605: IF l_debug_level > 0 THEN
1606: oe_debug_pub.add( 'CLOSE BOOK_ELIGIBLE' ) ;
1607: END IF;
1608:
1609:
1610: -- Lock the order: header, lines , sales credits and price adjustments

Line 1639: oe_debug_pub.add('Workflow complete activity failed. Raising');

1635: );
1636:
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: oe_debug_pub.add('Workflow complete activity failed. Raising');
1640: RAISE ;
1641: END ;
1642:
1643: IF l_debug_level > 0 THEN

Line 1644: oe_debug_pub.add( 'AFTER CALLING WF_ENGINE' ) ;

1640: RAISE ;
1641: END ;
1642:
1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( 'AFTER CALLING WF_ENGINE' ) ;
1645: END IF;
1646:
1647: -- if order was booked, the flag on the order header would have
1648: -- been updated.

Line 1694: oe_debug_pub.add( 'AGAIN OPEN BOOK_ELIGIBLE' ) ;

1690: -- customization between book eligible and book order
1691: -- (e.g. WF approval notification) due to which order
1692: -- did not even reach book order activity.
1693: IF l_debug_level > 0 THEN
1694: oe_debug_pub.add( 'AGAIN OPEN BOOK_ELIGIBLE' ) ;
1695: END IF;
1696: OPEN book_eligible;
1697: FETCH book_eligible INTO l_book_eligible;
1698: /* FOLLOWING CALL TO RAISE_BUSINESS_EVENT IS ADDED TO RAISE BUSINESS EVENT DURING ORDER BOOKING FAILURE.

Line 1704: oe_debug_pub.add('Calling Process Failure Event for Booking process for header_id '||p_header_id);

1700: */
1701: IF (book_eligible%FOUND) THEN
1702: -- START OF FIX 13536089
1703: If (l_debug_level > 0) THEN
1704: oe_debug_pub.add('Calling Process Failure Event for Booking process for header_id '||p_header_id);
1705: END IF;
1706:
1707: l_count := 1;
1708:

Line 1733: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;

1729:
1730: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1731:
1732: IF l_debug_level > 0 THEN
1733: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;
1734: END IF;
1735:
1736: EXCEPTION
1737: WHEN FND_API.G_EXC_ERROR THEN

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

1815: nextpos NUMBER;
1816: l_return_status VARCHAR2(30);
1817: l_orgid number;
1818: --
1819: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1820: --
1821: BEGIN
1822: IF l_debug_level > 0 THEN
1823: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;

Line 1823: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;

1819: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1820: --
1821: BEGIN
1822: IF l_debug_level > 0 THEN
1823: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;
1824: END IF;
1825:
1826: -- Initialize API return status to success
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1851: oe_debug_pub.add( 'Enter Loop headercount'|| p_header_count , 1 ) ;

1847: initial := 1;
1848: FOR I IN 1..p_header_count LOOP
1849:
1850: IF l_debug_level > 0 THEN
1851: oe_debug_pub.add( 'Enter Loop headercount'|| p_header_count , 1 ) ;
1852: END IF;
1853: /* changes for MOAC, not required since the input is the table
1854: IF I = p_header_count THEN
1855: nextpos := length(p_header_id_list)+1.0;

Line 1871: oe_debug_pub.add( 'HEADER ID: '||L_HEADER_ID , 1 ) ;

1867:
1868: END IF;
1869:
1870: IF l_debug_level > 0 THEN
1871: oe_debug_pub.add( 'HEADER ID: '||L_HEADER_ID , 1 ) ;
1872: END IF;
1873: --For CC Project
1874: SELECT h.Transaction_Phase_Code
1875: INTO l_Transaction_Phase_Code

Line 1908: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;

1904: initial := nextpos + 1.0;
1905: END LOOP;
1906:
1907: IF l_debug_level > 0 THEN
1908: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;
1909: END IF;
1910:
1911: EXCEPTION
1912: WHEN FND_API.G_EXC_ERROR THEN

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

1972: initial NUMBER;
1973: nextpos NUMBER;
1974: l_return_status VARCHAR2(30);
1975:
1976: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1977:
1978: TYPE header_id_tbl_type IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
1979: l_header_id_tbl header_id_tbl_type;
1980: TYPE delete_header_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1988: oe_debug_pub.add('ENTER OE_ORDER_BOOK.QA_ORDER' , 1 ) ;

1984: l_record_ids VARCHAR2(32000);
1985:
1986: BEGIN
1987: IF l_debug_level > 0 THEN
1988: oe_debug_pub.add('ENTER OE_ORDER_BOOK.QA_ORDER' , 1 ) ;
1989: oe_debug_pub.add('p_header_count: ' || p_header_count, 1);
1990: END IF;
1991:
1992: -- Initialize API return status to success

Line 1989: oe_debug_pub.add('p_header_count: ' || p_header_count, 1);

1985:
1986: BEGIN
1987: IF l_debug_level > 0 THEN
1988: oe_debug_pub.add('ENTER OE_ORDER_BOOK.QA_ORDER' , 1 ) ;
1989: oe_debug_pub.add('p_header_count: ' || p_header_count, 1);
1990: END IF;
1991:
1992: -- Initialize API return status to success
1993: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1999: oe_debug_pub.add('Contractual option not licensed, hence not performing article QA ', 3);

1995:
1996: --Check for licensing
1997: IF OE_Contracts_util.check_license() <> 'Y' THEN
1998: IF l_debug_level > 0 THEN
1999: oe_debug_pub.add('Contractual option not licensed, hence not performing article QA ', 3);
2000: END IF;
2001: RETURN;
2002: END IF;
2003:

Line 2042: oe_debug_pub.add( 'adding to PL/SQL table HEADER ID: '||L_HEADER_ID , 1 ) ;

2038: END IF;
2039:
2040: l_header_id := to_number(substr(p_header_id_list,initial, nextpos-initial));
2041: IF l_debug_level > 0 THEN
2042: oe_debug_pub.add( 'adding to PL/SQL table HEADER ID: '||L_HEADER_ID , 1 ) ;
2043: END IF;
2044:
2045: --transfer into PL/SQL table
2046: l_header_id_tbl(I) := l_header_id;

Line 2052: oe_debug_pub.add('l_header_id_tbl.COUNT: ' || l_header_id_tbl.COUNT);

2048: initial := nextpos + 1.0;
2049: END LOOP;
2050:
2051: IF l_debug_level > 0 THEN
2052: oe_debug_pub.add('l_header_id_tbl.COUNT: ' || l_header_id_tbl.COUNT);
2053: END IF;
2054:
2055:
2056: --now run QA on header id's contained in PL/SQL table l_header_id_tbl

Line 2060: oe_debug_pub.add('Calling OE_CONTRACTS_UTIL.qa_articles for l_header_id_tbl('||I||'): '||l_header_id_tbl(I));

2056: --now run QA on header id's contained in PL/SQL table l_header_id_tbl
2057: J := 1;
2058: FOR I IN 1..p_header_count LOOP
2059: IF l_debug_level > 0 THEN
2060: oe_debug_pub.add('Calling OE_CONTRACTS_UTIL.qa_articles for l_header_id_tbl('||I||'): '||l_header_id_tbl(I));
2061: END IF;
2062:
2063: OE_CONTRACTS_UTIL.qa_articles (
2064: p_api_version => 1.0,

Line 2076: oe_debug_pub.add('l_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_return_status);

2072:
2073:
2074:
2075: IF l_debug_level > 0 THEN
2076: oe_debug_pub.add('l_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_return_status);
2077: oe_debug_pub.add('l_qa_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_qa_return_status);
2078: END IF;
2079:
2080: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2077: oe_debug_pub.add('l_qa_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_qa_return_status);

2073:
2074:
2075: IF l_debug_level > 0 THEN
2076: oe_debug_pub.add('l_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_return_status);
2077: oe_debug_pub.add('l_qa_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_qa_return_status);
2078: END IF;
2079:
2080: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2081: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2106: oe_debug_pub.add('l_delete_header_id_tbl.COUNT: ' || l_delete_header_id_tbl.COUNT);

2102: END LOOP;
2103:
2104:
2105: IF l_debug_level > 0 THEN
2106: oe_debug_pub.add('l_delete_header_id_tbl.COUNT: ' || l_delete_header_id_tbl.COUNT);
2107: oe_debug_pub.add('l_header_id_tbl.COUNT before deleting: ' || l_header_id_tbl.COUNT);
2108: END IF;
2109:
2110: --delete the header id's that failed QA from the PL/SQL table l_header_id_tbl

Line 2107: oe_debug_pub.add('l_header_id_tbl.COUNT before deleting: ' || l_header_id_tbl.COUNT);

2103:
2104:
2105: IF l_debug_level > 0 THEN
2106: oe_debug_pub.add('l_delete_header_id_tbl.COUNT: ' || l_delete_header_id_tbl.COUNT);
2107: oe_debug_pub.add('l_header_id_tbl.COUNT before deleting: ' || l_header_id_tbl.COUNT);
2108: END IF;
2109:
2110: --delete the header id's that failed QA from the PL/SQL table l_header_id_tbl
2111: FOR J IN 1..l_delete_header_id_tbl.COUNT LOOP

Line 2115: oe_debug_pub.add('Deleted element with index ' || J || ' from l_header_id_tbl');

2111: FOR J IN 1..l_delete_header_id_tbl.COUNT LOOP
2112: l_header_id_tbl.DELETE(l_delete_header_id_tbl(J));
2113:
2114: IF l_debug_level > 0 THEN
2115: oe_debug_pub.add('Deleted element with index ' || J || ' from l_header_id_tbl');
2116: END IF;
2117: END LOOP;
2118:
2119: IF l_debug_level > 0 THEN

Line 2120: oe_debug_pub.add('l_header_id_tbl.COUNT after deleting: ' || l_header_id_tbl.COUNT);

2116: END IF;
2117: END LOOP;
2118:
2119: IF l_debug_level > 0 THEN
2120: oe_debug_pub.add('l_header_id_tbl.COUNT after deleting: ' || l_header_id_tbl.COUNT);
2121: END IF;
2122:
2123:
2124:

Line 2144: oe_debug_pub.add('Length of string l_record_ids: ' || LENGTH(l_record_ids));

2140:
2141: p_header_id_list := l_record_ids;
2142:
2143: IF l_debug_level > 0 THEN
2144: oe_debug_pub.add('Length of string l_record_ids: ' || LENGTH(l_record_ids));
2145: oe_debug_pub.add('Length of string p_header_id_list: ' || LENGTH(p_header_id_list));
2146: END IF;
2147:
2148:

Line 2145: oe_debug_pub.add('Length of string p_header_id_list: ' || LENGTH(p_header_id_list));

2141: p_header_id_list := l_record_ids;
2142:
2143: IF l_debug_level > 0 THEN
2144: oe_debug_pub.add('Length of string l_record_ids: ' || LENGTH(l_record_ids));
2145: oe_debug_pub.add('Length of string p_header_id_list: ' || LENGTH(p_header_id_list));
2146: END IF;
2147:
2148:
2149:

Line 2151: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.QA_ORDER' , 1 ) ;

2147:
2148:
2149:
2150: IF l_debug_level > 0 THEN
2151: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.QA_ORDER' , 1 ) ;
2152: END IF;
2153:
2154: EXCEPTION
2155: WHEN FND_API.G_EXC_ERROR THEN