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

167: FROM OE_ORDER_LINES
168: WHERE HEADER_ID = p_header_id;
169:
170: --
171: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
172: --
173: BEGIN
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

216: when no_data_found then
217: l_tax_calculation_event_code := NULL;
218: when others then
219: IF l_debug_level > 0 THEN
220: oe_debug_pub.add( 'REN: FAILED WHILE TRYING TO QUERY UP TAX_CALCUALTION_EVENT FOR ORDER_TYPE_ID IN UPDATE_BOOKED_FLAG' ) ;
221: END IF;
222: RAISE;
223: END;
224: -- renga: end of change for tax calculation event enhancement

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

522: -- made in the two update stmts to the headers and lines tables.
523: -- First make call for the header, then loop through all the lines
524:
525: -- bug 2821129
526: oe_debug_pub.add('in OEXUBOKB header will do query');
527: oe_debug_pub.add('p_header_id is '|| p_header_id);
528: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);
529: OE_HEADER_ADJ_UTIL.Query_Rows
530: (p_header_id => p_header_id

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

523: -- First make call for the header, then loop through all the lines
524:
525: -- bug 2821129
526: oe_debug_pub.add('in OEXUBOKB header will do query');
527: oe_debug_pub.add('p_header_id is '|| p_header_id);
528: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);
529: OE_HEADER_ADJ_UTIL.Query_Rows
530: (p_header_id => p_header_id
531: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);

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

524:
525: -- bug 2821129
526: oe_debug_pub.add('in OEXUBOKB header will do query');
527: oe_debug_pub.add('p_header_id is '|| p_header_id);
528: oe_debug_pub.add('l_header_rec.header_id is '|| l_header_rec.header_id);
529: OE_HEADER_ADJ_UTIL.Query_Rows
530: (p_header_id => p_header_id
531: ,x_Header_adj_Tbl => OE_ORDER_UTIL.g_header_adj_tbl);
532:

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

538: OE_ORDER_UTIL.g_header_adj_tbl(l_in_loop_index).operation := OE_GLOBALS.G_OPR_CREATE;
539: l_in_loop_index := OE_ORDER_UTIL.g_header_adj_tbl.NEXT(l_in_loop_index);
540: END LOOP;
541:
542: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);
543:
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
546: END IF;

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

541:
542: oe_debug_pub.add('in OEXUBOKB header adj tbl count is '|| OE_ORDER_UTIL.g_header_adj_tbl.count);
543:
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
546: END IF;
547: -- call notification framework to get header index position
548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;

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

545: oe_debug_pub.add( 'BEFORE ENTERING UPDATE_GLOBAL_PICTURE IN BOOKING' ) ;
546: END IF;
547: -- call notification framework to get header index position
548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;
550: END IF;
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
553: END IF;

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

548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add( 'BEFORE UPDATE , HEADER VALUE' || OE_ORDER_UTIL.G_HEADER_REC.HEADER_ID ) ;
550: END IF;
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'BEFORE UPDATE , OLD HEADER VALUE' || OE_ORDER_UTIL.G_OLD_HEADER_REC.HEADER_ID ) ;
553: END IF;
554: OE_ORDER_UTIL.Update_Global_Picture
555: (p_Upd_New_Rec_If_Exists =>FALSE
556: , p_header_rec => l_header_rec

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

559: , x_index => l_notify_index
560: , x_return_status => l_return_status);
561:
562: IF l_debug_level > 0 THEN
563: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FOR HDR IS: ' || L_RETURN_STATUS ) ;
564: END IF;
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
567: END IF;

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

562: IF l_debug_level > 0 THEN
563: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FOR HDR IS: ' || L_RETURN_STATUS ) ;
564: END IF;
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add( 'HDR INDEX IS: ' || L_NOTIFY_INDEX , 1 ) ;
567: END IF;
568:
569: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
570: RAISE FND_API.G_EXC_ERROR;

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

574:
575: IF l_notify_index is not null then
576: -- modify Global Picture
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'JPN: OLD GLOBAL HDR REC BOOKED_FLAG IS:' || OE_ORDER_UTIL.G_OLD_HEADER_REC.BOOKED_FLAG , 1 ) ;
579: END IF;
580: OE_ORDER_UTIL.g_old_header_rec := l_old_header_rec;
581: OE_ORDER_UTIL.g_header_rec := OE_ORDER_UTIL.g_old_header_rec;
582: OE_ORDER_UTIL.g_old_header_rec.booked_flag := 'N';

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

590: OE_ORDER_UTIL.g_header_rec.lock_control:= l_header_rec.lock_control;
591: OE_ORDER_UTIL.g_header_rec.operation:= l_header_rec.operation;
592:
593: IF l_debug_level > 0 THEN
594: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
595: END IF;
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
598: END IF;

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

593: IF l_debug_level > 0 THEN
594: oe_debug_pub.add( 'JYOTHI:GLOBAL HDR REC BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
595: END IF;
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
598: END IF;
599: IF l_debug_level > 0 THEN
600: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
601: END IF;

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

596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add( 'GLOBAL HDR BOOKED_DATE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_DATE , 1 ) ;
598: END IF;
599: IF l_debug_level > 0 THEN
600: oe_debug_pub.add( 'GLOBAL HDR FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_HEADER_REC.FLOW_STATUS_CODE , 1 ) ;
601: END IF;
602:
603: END IF ; /* global entity index null check */
604:

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

610: <>
611:
612: WHILE l_loop_index IS NOT NULL LOOP
613: IF l_debug_level > 0 THEN
614: oe_debug_pub.add( 'JFC: IN BOOKING LINES , L_LOOP_INDEX= '||L_LOOP_INDEX , 1 ) ;
615: END IF;
616: -- call notification framework to get this line's index position
617: OE_ORDER_UTIL.Update_Global_Picture
618: (p_Upd_New_Rec_If_Exists =>FALSE

Line 625: 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 ) ;

621: , x_index => l_notify_index
622: , x_return_status => l_return_status);
623:
624: IF l_debug_level > 0 THEN
625: 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 ) ;
626: END IF;
627: IF l_debug_level > 0 THEN
628: 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 ) ;
629: END IF;

Line 628: 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 ) ;

624: IF l_debug_level > 0 THEN
625: 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 ) ;
626: END IF;
627: IF l_debug_level > 0 THEN
628: 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 ) ;
629: END IF;
630:
631: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
632: RAISE FND_API.G_EXC_ERROR;

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

649: OE_ORDER_UTIL.g_line_tbl(l_notify_index).lock_control:= l_line_tbl(l_loop_index).lock_control;
650: OE_ORDER_UTIL.g_line_tbl(l_notify_index).operation:=l_line_tbl(l_loop_index).operation;
651:
652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;
654: END IF;
655: IF l_debug_level > 0 THEN
656: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
657: END IF;

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

652: IF l_debug_level > 0 THEN
653: oe_debug_pub.add( 'IN BOOKING , AFTER UPDATE LINE GLOBAL PICTURE' ) ;
654: END IF;
655: IF l_debug_level > 0 THEN
656: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
657: END IF;
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
660: END IF;

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

655: IF l_debug_level > 0 THEN
656: oe_debug_pub.add( 'GLOBAL LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
657: END IF;
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
660: END IF;
661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
663: END IF;

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

658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add( 'GLOBAL LINE FLOW_STATUS_CODE IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .FLOW_STATUS_CODE , 1 ) ;
660: END IF;
661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
663: END IF;
664: IF l_debug_level > 0 THEN
665: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;
666: END IF;

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

661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( 'GLOBAL OLD LINE BOOKED_FLAG IS: ' || OE_ORDER_UTIL.G_OLD_LINE_TBL ( L_NOTIFY_INDEX ) .BOOKED_FLAG , 1 ) ;
663: END IF;
664: IF l_debug_level > 0 THEN
665: oe_debug_pub.add( 'GLOBAL LINE OPERATION IS: ' || OE_ORDER_UTIL.G_LINE_TBL ( L_NOTIFY_INDEX ) .OPERATION , 1 ) ;
666: END IF;
667: END IF ; /* global entity index null check */
668:
669: -- bug 2821129

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

667: END IF ; /* global entity index null check */
668:
669: -- bug 2821129
670:
671: oe_debug_pub.add('p_header_id is '|| p_header_id);
672: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);
673:
674: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
675:

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

668:
669: -- bug 2821129
670:
671: oe_debug_pub.add('p_header_id is '|| p_header_id);
672: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);
673:
674: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
675:
676: OE_LINE_ADJ_UTIL.Query_Rows

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

670:
671: oe_debug_pub.add('p_header_id is '|| p_header_id);
672: oe_debug_pub.add('line_id is '|| l_line_tbl(l_loop_index).line_id);
673:
674: oe_debug_pub.add('in OEXUBOKB start g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
675:
676: OE_LINE_ADJ_UTIL.Query_Rows
677: (
678: p_line_id => l_line_tbl(l_loop_index).line_id

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

679: ,p_header_id => p_header_id
680: ,x_Line_Adj_Tbl => l_line_adj_tbl);
681:
682:
683: oe_debug_pub.add('in OEXUBOKB line adj tbl count from query row is '|| l_line_adj_tbl.count);
684:
685:
686: l_in_loop_index := l_line_adj_tbl.FIRST;
687:

Line 698: 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);

694: , x_return_status => l_return_status);
695:
696: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
698: 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);
699: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
700:
701: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
702:

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

695:
696: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index) := l_line_adj_tbl(l_in_loop_index);
697: OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation := OE_GLOBALS.G_OPR_CREATE;
698: 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);
699: oe_debug_pub.add('in OEXUBOKB after insert into global table, operation is ' || OE_ORDER_UTIL.g_line_adj_tbl(l_notify_index).operation);
700:
701: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
702:
703: END LOOP;

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

701: l_in_loop_index := l_line_adj_tbl.NEXT(l_in_loop_index);
702:
703: END LOOP;
704:
705: oe_debug_pub.add('in OEXUBOKB at end g line adj tbl count is '|| OE_ORDER_UTIL.g_line_adj_tbl.count);
706:
707: l_loop_index := l_line_tbl.NEXT(l_loop_index);
708:
709: END LOOP outer; -- over each line to update global picture

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

789: IS
790: l_msg_count NUMBER;
791: l_msg_data VARCHAR2(2000);
792: --
793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
794: --
795: BEGIN
796:
797: -- If Payment Verification Fails then the Order is

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

797: -- If Payment Verification Fails then the Order is
798: -- Automatically Put on a Credit Checking Hold or
799: -- a Credit Card Processing Hold.
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add( 'BEFORE CALLING VERIFY PAYMENT' ) ;
802: END IF;
803: --
804: OE_Verify_Payment_PUB.Verify_Payment
805: ( p_header_id => p_header_id

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

830: IS
831: l_return_status VARCHAR2(30);
832: h_return_status VARCHAR2(30);
833: --
834: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
835: --
836: --FP bug 3872166
837: CURSOR line_ids(p_header_id IN NUMBER) IS
838: SELECT line_id

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

839: FROM oe_order_lines_all
840: WHERE header_id = p_header_id;
841: BEGIN
842: IF l_debug_level > 0 THEN
843: oe_debug_pub.add('Entering Oe_Order_Book_Util.Validate_sales_Credits' ) ;
844: END IF;
845:
846: h_return_status := FND_API.G_RET_STS_SUCCESS;
847: -- Validate Header Sales Credits

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

849: ( p_header_id => p_header_id
850: , x_return_status => x_return_status );
851:
852: IF l_debug_level > 0 THEN
853: oe_debug_pub.add( 'RETURN STATUS AFTER HSC:'||X_RETURN_STATUS ) ;
854: END IF;
855:
856: -- FP bug 4697708
857: -- h_return_status := x_return_status;

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

883: ( x_return_status => x_return_status
884: ,p_line_id => l_line_id.line_id);
885:
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add( 'RETURN STATUS AFTER LSC FOR LINE '||l_line_id.line_id|| 'IS '||X_RETURN_STATUS ) ;
888: END IF;
889:
890: -- FP bug 4697708
891: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

896: END LOOP;
897: --FP bug 3872166 end
898:
899: IF l_debug_level > 0 THEN
900: oe_debug_pub.add( 'RETURN STATUS AFTER LSC:'||L_RETURN_STATUS ) ;
901: END IF;
902:
903: -- FP bug 4697708
904: /*

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

921: x_return_status := FND_API.G_RET_STS_SUCCESS;
922: END IF;
923:
924: IF l_debug_level > 0 THEN
925: oe_debug_pub.add('Exiting Oe_Order_Book_Util.Validate_sales_Credits: '||x_return_status ) ;
926: END IF;
927:
928: EXCEPTION
929: WHEN OTHERS THEN

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

954: l_dummy VARCHAR2(30);
955: p_hold_rec OE_HOLDS_PUB.any_line_hold_rec;
956:
957: --
958: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
959: --
960: BEGIN
961:
962: IF l_debug_level > 0 THEN

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

959: --
960: BEGIN
961:
962: IF l_debug_level > 0 THEN
963: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;
964: END IF;
965:
966: -- Check if there are any generic or Booking holds
967:

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

990: l_check_holds_result = FND_API.G_FALSE )
991: THEN
992: IF nvl(fnd_profile.value('ONT_PREVENT_BOOKING'),'N')='Y' THEN
993: IF l_debug_level > 0 THEN
994: oe_debug_pub.add( 'Profile ont_prevent_booking is set' , 1 ) ;
995: END IF;
996:
997: BEGIN
998: SELECT

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

1006: p_hold_rec.wf_item_type := 'OEOH';
1007: p_hold_rec.wf_activity_name := 'BOOK_ORDER';
1008:
1009: IF l_debug_level > 0 THEN
1010: oe_debug_pub.add( 'Before calling Check_Any_Line_Hold' , 1 ) ;
1011: END IF;
1012:
1013: OE_HOLDS_PUB.Check_Any_Line_Hold
1014: (x_hold_rec => p_hold_rec

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

1033: END IF;
1034: END IF;
1035: /* Changes for bug#2673236:End */
1036: IF l_debug_level > 0 THEN
1037: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK_UTIL.CHECK_BOOKING_HOLDS' , 1 ) ;
1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN OTHERS THEN

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

1068: l_return_status VARCHAR2(1);
1069: l_validate_cfg BOOLEAN;
1070: l_freeze_inc_items BOOLEAN;
1071: --
1072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1073: --
1074:
1075: l_msg_count NUMBER;
1076: l_msg_data VARCHAR2(2000);

Line 1084: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_ORDER' ) ;

1080:
1081:
1082: BEGIN
1083: IF l_debug_level > 0 THEN
1084: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_ORDER' ) ;
1085: END IF;
1086:
1087: SAVEPOINT BOOK_ORDER;
1088:

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

1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133:
1134: IF l_debug_level > 0 THEN
1135: oe_debug_pub.add( 'RETURN STATUS AFTER SALES CREDITS:'||L_RETURN_STATUS ) ;
1136: END IF;
1137:
1138: -- Call process order to update the booked_flag on header and
1139: -- on all the order lines. This will also check for all the fields

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

1145: , x_return_status => x_return_status
1146: );
1147:
1148: IF l_debug_level > 0 THEN
1149: oe_debug_pub.add( 'RETURN STATUS AFTER UPDATE BOOKED:'||X_RETURN_STATUS ) ;
1150: END IF;
1151:
1152: -- if failure during validate sales credits OR during order and
1153: -- line validation, raise error

Line 1168: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS ) ;

1164:
1165: l_return_status := OE_Config_Util.Validate_Cfgs_In_Order
1166: (p_header_id => p_header_id);
1167: IF l_debug_level > 0 THEN
1168: oe_debug_pub.add( 'RETURN STATUS AFTER VALIDATE CFGS:'||L_RETURN_STATUS ) ;
1169: END IF;
1170:
1171: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1172: RAISE FND_API.G_EXC_ERROR;

Line 1190: oe_debug_pub.add( 'RETURN STATUS AFTER FREEZE INC:'||L_RETURN_STATUS ) ;

1186: l_return_status := OE_Config_Util.Freeze_Inc_Items_For_Order
1187: (p_header_id => p_header_id);
1188:
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( 'RETURN STATUS AFTER FREEZE INC:'||L_RETURN_STATUS ) ;
1191: END IF;
1192:
1193: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;

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

1247:
1248: --Check for licensing
1249: IF OE_Contracts_util.check_license() <> 'Y' THEN
1250: IF l_debug_level > 0 THEN
1251: oe_debug_pub.add('Contractual option not licensed, hence not performing article QA ', 3);
1252: END IF;
1253: ELSE
1254:
1255:

Line 1319: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;

1315: , p_data => x_msg_data
1316: );
1317:
1318: IF l_debug_level > 0 THEN
1319: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1320: END IF;
1321:
1322: EXCEPTION
1323: -- Bug 2285308: Clear Delayed Requests when there is an error.

Line 1331: oe_debug_pub.add( 'EXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;

1327: -- requests were not cleared from the cache earlier resulting
1328: -- in bugs like 2285308.
1329: WHEN FND_API.G_EXC_ERROR THEN
1330: IF l_debug_level > 0 THEN
1331: oe_debug_pub.add( 'EXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1332: END IF;
1333: x_return_status := FND_API.G_RET_STS_ERROR;
1334: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1335: OE_MSG_PUB.Count_And_Get

Line 1342: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;

1338: );
1339: ROLLBACK TO BOOK_ORDER;
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: IF l_debug_level > 0 THEN
1342: oe_debug_pub.add( 'UNEXP. ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1343: END IF;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1345: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1346: OE_MSG_PUB.Count_And_Get

Line 1353: oe_debug_pub.add( 'OTHERS ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;

1349: );
1350: ROLLBACK TO BOOK_ORDER;
1351: WHEN OTHERS THEN
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'OTHERS ERROR IN OE_ORDER_BOOK.BOOK_ORDER' , 1 ) ;
1354: END IF;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: OE_Delayed_Requests_PVT.Clear_Request(l_return_status);
1357: IF FND_MSG_PUB.Check_Msg_Level

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

1420: AND WIAS.activity_status = 'ERROR'
1421: AND WPA.activity_name = 'BOOK_ORDER'
1422: AND WPA.instance_id = WIAS.process_activity;
1423: --
1424: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1425: --
1426: BEGIN
1427: IF l_debug_level > 0 THEN
1428: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;

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

1424: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1425: --
1426: BEGIN
1427: IF l_debug_level > 0 THEN
1428: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;
1429: END IF;
1430:
1431: -- Initialize API return status to success
1432: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1472: -- Check if for this header, the BOOK_ELIGIBLE activity is in a
1473: -- notified state
1474:
1475: IF l_debug_level > 0 THEN
1476: oe_debug_pub.add( 'OPEN BOOK_ELIGIBLE' ) ;
1477: END IF;
1478: OPEN book_eligible;
1479: FETCH book_eligible INTO l_book_eligible;
1480:

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

1479: FETCH book_eligible INTO l_book_eligible;
1480:
1481: IF (book_eligible%NOTFOUND) THEN
1482: IF l_debug_level > 0 THEN
1483: oe_debug_pub.add( 'BOOKING NOT ELIGIBLE' ) ;
1484: END IF;
1485:
1486: -- Booking could be a high cost activity and could have been deferred
1487: -- due to a prior request. If the activity is in a deferred status,

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

1516: END IF;
1517:
1518: CLOSE book_eligible;
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'CLOSE BOOK_ELIGIBLE' ) ;
1521: END IF;
1522:
1523:
1524: -- Lock the order: header, lines , sales credits and price adjustments

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

1547: );
1548:
1549:
1550: IF l_debug_level > 0 THEN
1551: oe_debug_pub.add( 'AFTER CALLING WF_ENGINE' ) ;
1552: END IF;
1553:
1554: -- if order was booked, the flag on the order header would have
1555: -- been updated.

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

1597: -- customization between book eligible and book order
1598: -- (e.g. WF approval notification) due to which order
1599: -- did not even reach book order activity.
1600: IF l_debug_level > 0 THEN
1601: oe_debug_pub.add( 'AGAIN OPEN BOOK_ELIGIBLE' ) ;
1602: END IF;
1603: OPEN book_eligible;
1604: FETCH book_eligible INTO l_book_eligible;
1605: IF (book_eligible%FOUND) THEN

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

1618:
1619: OE_MSG_PUB.Reset_Msg_Context(p_entity_code => 'HEADER');
1620:
1621: IF l_debug_level > 0 THEN
1622: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.COMPLETE_BOOK_ELIGIBLE' , 1 ) ;
1623: END IF;
1624:
1625: EXCEPTION
1626: WHEN FND_API.G_EXC_ERROR THEN

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

1704: nextpos NUMBER;
1705: l_return_status VARCHAR2(30);
1706: l_orgid number;
1707: --
1708: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1709: --
1710: BEGIN
1711: IF l_debug_level > 0 THEN
1712: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;

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

1708: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1709: --
1710: BEGIN
1711: IF l_debug_level > 0 THEN
1712: oe_debug_pub.add( 'ENTER OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;
1713: END IF;
1714:
1715: -- Initialize API return status to success
1716: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1736: initial := 1;
1737: FOR I IN 1..p_header_count LOOP
1738:
1739: IF l_debug_level > 0 THEN
1740: oe_debug_pub.add( 'Enter Loop headercount'|| p_header_count , 1 ) ;
1741: END IF;
1742: /* changes for MOAC, not required since the input is the table
1743: IF I = p_header_count THEN
1744: nextpos := length(p_header_id_list)+1.0;

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

1756:
1757: END IF;
1758:
1759: IF l_debug_level > 0 THEN
1760: oe_debug_pub.add( 'HEADER ID: '||L_HEADER_ID , 1 ) ;
1761: END IF;
1762: --For CC Project
1763: SELECT h.Transaction_Phase_Code
1764: INTO l_Transaction_Phase_Code

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

1793: initial := nextpos + 1.0;
1794: END LOOP;
1795:
1796: IF l_debug_level > 0 THEN
1797: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.BOOK_MULTIPLE_ORDERS' , 1 ) ;
1798: END IF;
1799:
1800: EXCEPTION
1801: WHEN FND_API.G_EXC_ERROR THEN

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

1861: initial NUMBER;
1862: nextpos NUMBER;
1863: l_return_status VARCHAR2(30);
1864:
1865: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1866:
1867: TYPE header_id_tbl_type IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;
1868: l_header_id_tbl header_id_tbl_type;
1869: TYPE delete_header_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

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

1873: l_record_ids VARCHAR2(32000);
1874:
1875: BEGIN
1876: IF l_debug_level > 0 THEN
1877: oe_debug_pub.add('ENTER OE_ORDER_BOOK.QA_ORDER' , 1 ) ;
1878: oe_debug_pub.add('p_header_count: ' || p_header_count, 1);
1879: END IF;
1880:
1881: -- Initialize API return status to success

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

1874:
1875: BEGIN
1876: IF l_debug_level > 0 THEN
1877: oe_debug_pub.add('ENTER OE_ORDER_BOOK.QA_ORDER' , 1 ) ;
1878: oe_debug_pub.add('p_header_count: ' || p_header_count, 1);
1879: END IF;
1880:
1881: -- Initialize API return status to success
1882: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1884:
1885: --Check for licensing
1886: IF OE_Contracts_util.check_license() <> 'Y' THEN
1887: IF l_debug_level > 0 THEN
1888: oe_debug_pub.add('Contractual option not licensed, hence not performing article QA ', 3);
1889: END IF;
1890: RETURN;
1891: END IF;
1892:

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

1927: END IF;
1928:
1929: l_header_id := to_number(substr(p_header_id_list,initial, nextpos-initial));
1930: IF l_debug_level > 0 THEN
1931: oe_debug_pub.add( 'adding to PL/SQL table HEADER ID: '||L_HEADER_ID , 1 ) ;
1932: END IF;
1933:
1934: --transfer into PL/SQL table
1935: l_header_id_tbl(I) := l_header_id;

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

1937: initial := nextpos + 1.0;
1938: END LOOP;
1939:
1940: IF l_debug_level > 0 THEN
1941: oe_debug_pub.add('l_header_id_tbl.COUNT: ' || l_header_id_tbl.COUNT);
1942: END IF;
1943:
1944:
1945: --now run QA on header id's contained in PL/SQL table l_header_id_tbl

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

1945: --now run QA on header id's contained in PL/SQL table l_header_id_tbl
1946: J := 1;
1947: FOR I IN 1..p_header_count LOOP
1948: IF l_debug_level > 0 THEN
1949: oe_debug_pub.add('Calling OE_CONTRACTS_UTIL.qa_articles for l_header_id_tbl('||I||'): '||l_header_id_tbl(I));
1950: END IF;
1951:
1952: OE_CONTRACTS_UTIL.qa_articles (
1953: p_api_version => 1.0,

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

1961:
1962:
1963:
1964: IF l_debug_level > 0 THEN
1965: oe_debug_pub.add('l_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_return_status);
1966: oe_debug_pub.add('l_qa_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_qa_return_status);
1967: END IF;
1968:
1969: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

1962:
1963:
1964: IF l_debug_level > 0 THEN
1965: oe_debug_pub.add('l_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_return_status);
1966: oe_debug_pub.add('l_qa_return_status for l_header_id_tbl('||I||'): '||l_header_id_tbl(I)||' is '|| l_qa_return_status);
1967: END IF;
1968:
1969: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1970: IF l_qa_return_status = FND_API.G_RET_STS_ERROR THEN

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

1991: END LOOP;
1992:
1993:
1994: IF l_debug_level > 0 THEN
1995: oe_debug_pub.add('l_delete_header_id_tbl.COUNT: ' || l_delete_header_id_tbl.COUNT);
1996: oe_debug_pub.add('l_header_id_tbl.COUNT before deleting: ' || l_header_id_tbl.COUNT);
1997: END IF;
1998:
1999: --delete the header id's that failed QA from the PL/SQL table l_header_id_tbl

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

1992:
1993:
1994: IF l_debug_level > 0 THEN
1995: oe_debug_pub.add('l_delete_header_id_tbl.COUNT: ' || l_delete_header_id_tbl.COUNT);
1996: oe_debug_pub.add('l_header_id_tbl.COUNT before deleting: ' || l_header_id_tbl.COUNT);
1997: END IF;
1998:
1999: --delete the header id's that failed QA from the PL/SQL table l_header_id_tbl
2000: FOR J IN 1..l_delete_header_id_tbl.COUNT LOOP

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

2000: FOR J IN 1..l_delete_header_id_tbl.COUNT LOOP
2001: l_header_id_tbl.DELETE(l_delete_header_id_tbl(J));
2002:
2003: IF l_debug_level > 0 THEN
2004: oe_debug_pub.add('Deleted element with index ' || J || ' from l_header_id_tbl');
2005: END IF;
2006: END LOOP;
2007:
2008: IF l_debug_level > 0 THEN

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

2005: END IF;
2006: END LOOP;
2007:
2008: IF l_debug_level > 0 THEN
2009: oe_debug_pub.add('l_header_id_tbl.COUNT after deleting: ' || l_header_id_tbl.COUNT);
2010: END IF;
2011:
2012:
2013:

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

2029:
2030: p_header_id_list := l_record_ids;
2031:
2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add('Length of string l_record_ids: ' || LENGTH(l_record_ids));
2034: oe_debug_pub.add('Length of string p_header_id_list: ' || LENGTH(p_header_id_list));
2035: END IF;
2036:
2037:

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

2030: p_header_id_list := l_record_ids;
2031:
2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add('Length of string l_record_ids: ' || LENGTH(l_record_ids));
2034: oe_debug_pub.add('Length of string p_header_id_list: ' || LENGTH(p_header_id_list));
2035: END IF;
2036:
2037:
2038:

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

2036:
2037:
2038:
2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'EXIT OE_ORDER_BOOK.QA_ORDER' , 1 ) ;
2041: END IF;
2042:
2043: EXCEPTION
2044: WHEN FND_API.G_EXC_ERROR THEN