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

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

29: p_header_counter Number
30: ) IS
31: l_count number; -- bug 4558093
32: l_hdr_count number := OE_BULK_ORDER_PVT.G_HEADER_REC.HEADER_ID.count;
33: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
34:
35: Begin
36: --bug 4558093
37: IF l_hdr_count > G_PRICE_FLAG.ALL_LINES_Y.COUNT THEN

Line 44: oe_debug_pub.add('inside set_price_flag');

40: G_PRICE_FLAG.ALL_LINES_N.extend(l_hdr_count - l_count);
41: G_PRICE_FLAG.MIXED.extend(l_hdr_count - l_count);
42: END IF;
43: If l_debug_level > 0 Then
44: oe_debug_pub.add('inside set_price_flag');
45: oe_debug_pub.add('p_header_counter : '||p_header_counter||'hdr count : '||oe_bulk_order_pvt.g_header_rec.header_id.count);
46: oe_debug_pub.add('G_PRICE_FLAG count : '||G_PRICE_FLAG.ALL_LINES_Y.count);
47: end if;
48:

Line 45: oe_debug_pub.add('p_header_counter : '||p_header_counter||'hdr count : '||oe_bulk_order_pvt.g_header_rec.header_id.count);

41: G_PRICE_FLAG.MIXED.extend(l_hdr_count - l_count);
42: END IF;
43: If l_debug_level > 0 Then
44: oe_debug_pub.add('inside set_price_flag');
45: oe_debug_pub.add('p_header_counter : '||p_header_counter||'hdr count : '||oe_bulk_order_pvt.g_header_rec.header_id.count);
46: oe_debug_pub.add('G_PRICE_FLAG count : '||G_PRICE_FLAG.ALL_LINES_Y.count);
47: end if;
48:
49: If G_PRICE_FLAG.ALL_LINES_Y(p_header_counter) is null or G_PRICE_FLAG.ALL_LINES_N(p_header_counter) is null or G_PRICE_FLAG.MIXED(p_header_counter) is null Then

Line 46: oe_debug_pub.add('G_PRICE_FLAG count : '||G_PRICE_FLAG.ALL_LINES_Y.count);

42: END IF;
43: If l_debug_level > 0 Then
44: oe_debug_pub.add('inside set_price_flag');
45: oe_debug_pub.add('p_header_counter : '||p_header_counter||'hdr count : '||oe_bulk_order_pvt.g_header_rec.header_id.count);
46: oe_debug_pub.add('G_PRICE_FLAG count : '||G_PRICE_FLAG.ALL_LINES_Y.count);
47: end if;
48:
49: If G_PRICE_FLAG.ALL_LINES_Y(p_header_counter) is null or G_PRICE_FLAG.ALL_LINES_N(p_header_counter) is null or G_PRICE_FLAG.MIXED(p_header_counter) is null Then
50: If G_PRICE_FLAG.ALL_LINES_Y(p_header_counter) is null and G_PRICE_FLAG.ALL_LINES_N(p_header_counter) is null and G_PRICE_FLAG.MIXED(p_header_counter) is null then

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

75:
76: l_hdr_ctr Number := p_header_rec.header_id.count;
77: i Number;
78: l_count number;
79: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
80: Begin
81:
82: If l_debug_level > 0 Then
83: oe_debug_pub.add('inside set_hdr_price_flag');

Line 83: oe_debug_pub.add('inside set_hdr_price_flag');

79: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
80: Begin
81:
82: If l_debug_level > 0 Then
83: oe_debug_pub.add('inside set_hdr_price_flag');
84: oe_debug_pub.add('p_header_rec.header_id.count = '||l_hdr_ctr);
85: oe_debug_pub.add('g_price_flag count all_lines_y= '|| G_PRICE_FLAG.ALL_LINES_Y.count);
86: oe_debug_pub.add('g_price_flag count mixed= '|| G_PRICE_FLAG.MIXED.count);
87: end if;

Line 84: oe_debug_pub.add('p_header_rec.header_id.count = '||l_hdr_ctr);

80: Begin
81:
82: If l_debug_level > 0 Then
83: oe_debug_pub.add('inside set_hdr_price_flag');
84: oe_debug_pub.add('p_header_rec.header_id.count = '||l_hdr_ctr);
85: oe_debug_pub.add('g_price_flag count all_lines_y= '|| G_PRICE_FLAG.ALL_LINES_Y.count);
86: oe_debug_pub.add('g_price_flag count mixed= '|| G_PRICE_FLAG.MIXED.count);
87: end if;
88:

Line 85: oe_debug_pub.add('g_price_flag count all_lines_y= '|| G_PRICE_FLAG.ALL_LINES_Y.count);

81:
82: If l_debug_level > 0 Then
83: oe_debug_pub.add('inside set_hdr_price_flag');
84: oe_debug_pub.add('p_header_rec.header_id.count = '||l_hdr_ctr);
85: oe_debug_pub.add('g_price_flag count all_lines_y= '|| G_PRICE_FLAG.ALL_LINES_Y.count);
86: oe_debug_pub.add('g_price_flag count mixed= '|| G_PRICE_FLAG.MIXED.count);
87: end if;
88:
89: p_header_rec.calculate_price_flag.extend(l_hdr_ctr);

Line 86: oe_debug_pub.add('g_price_flag count mixed= '|| G_PRICE_FLAG.MIXED.count);

82: If l_debug_level > 0 Then
83: oe_debug_pub.add('inside set_hdr_price_flag');
84: oe_debug_pub.add('p_header_rec.header_id.count = '||l_hdr_ctr);
85: oe_debug_pub.add('g_price_flag count all_lines_y= '|| G_PRICE_FLAG.ALL_LINES_Y.count);
86: oe_debug_pub.add('g_price_flag count mixed= '|| G_PRICE_FLAG.MIXED.count);
87: end if;
88:
89: p_header_rec.calculate_price_flag.extend(l_hdr_ctr);
90:

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

118: Procedure Unbook_included_item
119:
120: *****************************************************************************************************/
121: Procedure Unbook_Included_Item(p_start_index In Number,p_count In Number) As
122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
123: Begin
124:
125: If l_debug_level > 0 Then
126: oe_debug_pub.add('Starting unbook included item lines');

Line 126: oe_debug_pub.add('Starting unbook included item lines');

122: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
123: Begin
124:
125: If l_debug_level > 0 Then
126: oe_debug_pub.add('Starting unbook included item lines');
127: oe_debug_pub.add('p_start_index:'||p_start_index);
128: oe_debug_pub.add('p_count:'||p_count);
129: End If;
130:

Line 127: oe_debug_pub.add('p_start_index:'||p_start_index);

123: Begin
124:
125: If l_debug_level > 0 Then
126: oe_debug_pub.add('Starting unbook included item lines');
127: oe_debug_pub.add('p_start_index:'||p_start_index);
128: oe_debug_pub.add('p_count:'||p_count);
129: End If;
130:
131: For i in p_start_index..p_start_index + p_count - 1 Loop

Line 128: oe_debug_pub.add('p_count:'||p_count);

124:
125: If l_debug_level > 0 Then
126: oe_debug_pub.add('Starting unbook included item lines');
127: oe_debug_pub.add('p_start_index:'||p_start_index);
128: oe_debug_pub.add('p_count:'||p_count);
129: End If;
130:
131: For i in p_start_index..p_start_index + p_count - 1 Loop
132: If OE_BULK_ORDER_PVT.G_Line_Rec.Booked_Flag.exists(i) Then

Line 136: oe_debug_pub.add('Record index:'||i||' does not exists');

132: If OE_BULK_ORDER_PVT.G_Line_Rec.Booked_Flag.exists(i) Then
133: OE_BULK_ORDER_PVT.G_Line_Rec.Booked_Flag(i):='N';
134: Else
135: If l_debug_level > 0 Then
136: oe_debug_pub.add('Record index:'||i||' does not exists');
137: End If;
138: End If;
139: End Loop;
140:

Line 142: oe_debug_pub.add('Leaving unbook included item lines');

138: End If;
139: End Loop;
140:
141: If l_debug_level > 0 Then
142: oe_debug_pub.add('Leaving unbook included item lines');
143: End If;
144: End;
145:
146: /*************************************************************************************************

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

160: IS
161: l_booked_flag varchar2(1) := oe_order_cache.g_header_rec.booked_flag;
162: i Number;
163: --
164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
165: --
166: cursor test is
167: select pricing_status_code,LINE_DETAIL_INDEX,LINE_INDEX from QP_PREQ_LINE_ATTRS_TMP;
168: BEGIN

Line 170: oe_debug_pub.add( 'INSIDE OE_BULK_PRICEORDER_PVT.INSERT_ADJ' ) ;

166: cursor test is
167: select pricing_status_code,LINE_DETAIL_INDEX,LINE_INDEX from QP_PREQ_LINE_ATTRS_TMP;
168: BEGIN
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'INSIDE OE_BULK_PRICEORDER_PVT.INSERT_ADJ' ) ;
171: END IF;
172: --bug 3544829
173: -- added the condition for manual adjustments in the where clause
174: INSERT INTO OE_PRICE_ADJUSTMENTS

Line 398: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;

394: AND ldets.list_line_type_code<>'IUE'
395: );
396:
397: IF l_debug_level > 0 THEN
398: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' ADJUSTMENTS' ) ;
399: END IF;
400:
401: --Insert associations
402:

Line 459: oe_debug_pub.add('after inserting assocs');

455: RLTD.PRICING_STATUS_CODE = 'N');
456:
457: --Insert pricing attributes
458: If l_debug_level > 0 Then
459: oe_debug_pub.add('after inserting assocs');
460: oe_debug_pub.add('INSERTED '||SQL%ROWCOUNT||' ASSOCIATIONS');
461: for i in test loop
462: oe_debug_pub.add('pricing_status_code = '||i.pricing_status_code);
463: oe_debug_pub.add('LINE_DETAIL_INDEX = '||i.LINE_DETAIL_INDEX);

Line 460: oe_debug_pub.add('INSERTED '||SQL%ROWCOUNT||' ASSOCIATIONS');

456:
457: --Insert pricing attributes
458: If l_debug_level > 0 Then
459: oe_debug_pub.add('after inserting assocs');
460: oe_debug_pub.add('INSERTED '||SQL%ROWCOUNT||' ASSOCIATIONS');
461: for i in test loop
462: oe_debug_pub.add('pricing_status_code = '||i.pricing_status_code);
463: oe_debug_pub.add('LINE_DETAIL_INDEX = '||i.LINE_DETAIL_INDEX);
464: oe_debug_pub.add('LINE_INDEX = '||i.LINE_INDEX);

Line 462: oe_debug_pub.add('pricing_status_code = '||i.pricing_status_code);

458: If l_debug_level > 0 Then
459: oe_debug_pub.add('after inserting assocs');
460: oe_debug_pub.add('INSERTED '||SQL%ROWCOUNT||' ASSOCIATIONS');
461: for i in test loop
462: oe_debug_pub.add('pricing_status_code = '||i.pricing_status_code);
463: oe_debug_pub.add('LINE_DETAIL_INDEX = '||i.LINE_DETAIL_INDEX);
464: oe_debug_pub.add('LINE_INDEX = '||i.LINE_INDEX);
465: end loop;
466: end if;

Line 463: oe_debug_pub.add('LINE_DETAIL_INDEX = '||i.LINE_DETAIL_INDEX);

459: oe_debug_pub.add('after inserting assocs');
460: oe_debug_pub.add('INSERTED '||SQL%ROWCOUNT||' ASSOCIATIONS');
461: for i in test loop
462: oe_debug_pub.add('pricing_status_code = '||i.pricing_status_code);
463: oe_debug_pub.add('LINE_DETAIL_INDEX = '||i.LINE_DETAIL_INDEX);
464: oe_debug_pub.add('LINE_INDEX = '||i.LINE_INDEX);
465: end loop;
466: end if;
467: INSERT INTO OE_PRICE_ADJ_ATTRIBS

Line 464: oe_debug_pub.add('LINE_INDEX = '||i.LINE_INDEX);

460: oe_debug_pub.add('INSERTED '||SQL%ROWCOUNT||' ASSOCIATIONS');
461: for i in test loop
462: oe_debug_pub.add('pricing_status_code = '||i.pricing_status_code);
463: oe_debug_pub.add('LINE_DETAIL_INDEX = '||i.LINE_DETAIL_INDEX);
464: oe_debug_pub.add('LINE_INDEX = '||i.LINE_INDEX);
465: end loop;
466: end if;
467: INSERT INTO OE_PRICE_ADJ_ATTRIBS
468: ( PRICE_ADJUSTMENT_ID

Line 519: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' PRICE ADJ ATTRIBS' , 3 ) ;

515: );
516:
517:
518: IF l_debug_level > 0 THEN
519: oe_debug_pub.add( 'INSERTED '||SQL%ROWCOUNT||' PRICE ADJ ATTRIBS' , 3 ) ;
520: END IF;
521:
522: Exception
523: WHEN OTHERS THEN

Line 525: oe_debug_pub.add('ERROR in inserting adjustments and associations'||sqlerrm);

521:
522: Exception
523: WHEN OTHERS THEN
524: IF l_debug_level > 0 THEN
525: oe_debug_pub.add('ERROR in inserting adjustments and associations'||sqlerrm);
526: END IF;
527: Raise FND_API.G_EXC_ERROR;
528: END Insert_Adj;
529:

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

558: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
559: and lines.process_status <> 'NOT_VALID';
560:
561: l_ordered_quantity Number;
562: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
563:
564: Begin
565: If l_debug_level > 0 Then
566: oe_debug_pub.add('inside update_global_line');

Line 566: oe_debug_pub.add('inside update_global_line');

562: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
563:
564: Begin
565: If l_debug_level > 0 Then
566: oe_debug_pub.add('inside update_global_line');
567: end if;
568: For valid in valid_lines Loop
569:
570: l_ordered_quantity:=OE_BULK_ORDER_PVT.G_Line_Rec.Ordered_Quantity(valid.line_index);

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

654: l_msg_count Number;
655: l_msg_data Varchar2(2000);
656: l_return_status Varchar2(30);
657: l_header_id number;
658: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
659:
660: Begin
661: l_return_status:= FND_API.G_RET_STS_SUCCESS;
662:

Line 664: oe_debug_pub.add('Entering OE_BULK_PRICEORDER_PVT.credit_check');

660: Begin
661: l_return_status:= FND_API.G_RET_STS_SUCCESS;
662:
663: If l_debug_level > 0 Then
664: oe_debug_pub.add('Entering OE_BULK_PRICEORDER_PVT.credit_check');
665: End If;
666:
667: For i IN 1..p_header_rec.header_id.count Loop
668:

Line 683: oe_debug_pub.add(' Calling OE_Verify_Payment_PUB.Verify_Payment');

679:
680: IF OE_BULK_CACHE.IS_CC_REQUIRED(p_header_rec.order_type_id(i))
681: THEN
682: If l_debug_level > 0 Then
683: oe_debug_pub.add(' Calling OE_Verify_Payment_PUB.Verify_Payment');
684: End If;
685:
686: OE_Verify_Payment_PUB.Verify_Payment
687: ( p_header_id => l_header_id

Line 695: oe_debug_pub.add('Verify payment returns status errors:'||l_msg_data);

691: , p_msg_data => l_msg_data
692: , p_return_status => l_return_status);
693:
694: If l_return_status <> FND_API.G_RET_STS_SUCCESS Then
695: oe_debug_pub.add('Verify payment returns status errors:'||l_msg_data);
696: l_return_status := FND_API.G_RET_STS_SUCCESS;
697: Booking_Failed(i,p_header_rec);
698: End If;
699: End IF;

Line 703: oe_debug_pub.add('Header Id:'|| p_header_rec.header_id(i) || 'not exists in DB');

699: End IF;
700:
701: Exception
702: When no_data_found Then
703: oe_debug_pub.add('Header Id:'|| p_header_rec.header_id(i) || 'not exists in DB');
704: When others Then
705: oe_debug_pub.add('Errors occured when restoring the book flag:'||SQLERRM);
706: End;
707:

Line 705: oe_debug_pub.add('Errors occured when restoring the book flag:'||SQLERRM);

701: Exception
702: When no_data_found Then
703: oe_debug_pub.add('Header Id:'|| p_header_rec.header_id(i) || 'not exists in DB');
704: When others Then
705: oe_debug_pub.add('Errors occured when restoring the book flag:'||SQLERRM);
706: End;
707:
708: End If;
709: End Loop;

Line 712: oe_debug_pub.add('Leaving OE_BULK_PRICEORDER_PVT.credit_checking');

708: End If;
709: End Loop;
710:
711: If l_debug_level > 0 Then
712: oe_debug_pub.add('Leaving OE_BULK_PRICEORDER_PVT.credit_checking');
713: End If;
714: End;
715:
716:

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

743: the header_index changes. While iterating, if it is a 'KIT' line then we will need to mark included item lines as unbook also. To do that, we should start from global_line_rec.ii_start_index and iterate until ii_start_index + ii_count - 1
744: ******************************************************************************************************/
745: Procedure Unbook_Order(p_header_index IN Number,
746: p_line_index IN Number) As
747: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
748: l_index number;
749: Begin
750: If l_debug_level > 0 Then
751: oe_debug_pub.add('inside Unbook_Order');

Line 751: oe_debug_pub.add('inside Unbook_Order');

747: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
748: l_index number;
749: Begin
750: If l_debug_level > 0 Then
751: oe_debug_pub.add('inside Unbook_Order');
752: oe_debug_pub.add('p_header_index = '||p_header_index);
753: oe_debug_pub.add('p_line_index = '||p_line_index);
754: End if;
755:

Line 752: oe_debug_pub.add('p_header_index = '||p_header_index);

748: l_index number;
749: Begin
750: If l_debug_level > 0 Then
751: oe_debug_pub.add('inside Unbook_Order');
752: oe_debug_pub.add('p_header_index = '||p_header_index);
753: oe_debug_pub.add('p_line_index = '||p_line_index);
754: End if;
755:
756: If p_header_index Is Null Then

Line 753: oe_debug_pub.add('p_line_index = '||p_line_index);

749: Begin
750: If l_debug_level > 0 Then
751: oe_debug_pub.add('inside Unbook_Order');
752: oe_debug_pub.add('p_header_index = '||p_header_index);
753: oe_debug_pub.add('p_line_index = '||p_line_index);
754: End if;
755:
756: If p_header_index Is Null Then
757: If l_debug_level > 0 Then

Line 758: oe_debug_pub.add('Header index is null, unable to proceed. Returning');

754: End if;
755:
756: If p_header_index Is Null Then
757: If l_debug_level > 0 Then
758: oe_debug_pub.add('Header index is null, unable to proceed. Returning');
759: end if;
760: Return;
761: End If;
762:

Line 764: oe_debug_pub.add('before checking Booked_Flag');

760: Return;
761: End If;
762:
763: If l_debug_level > 0 Then
764: oe_debug_pub.add('before checking Booked_Flag');
765: oe_debug_pub.add('Booked_Flag = '||OE_Bulk_Order_Pvt.G_Header_Rec.Booked_Flag(p_header_index));
766: oe_debug_pub.add('after printing Booked_Flag');
767: end if;
768: If OE_Bulk_Order_Pvt.G_Header_Rec.Booked_Flag(p_header_index) = 'N' Then

Line 765: oe_debug_pub.add('Booked_Flag = '||OE_Bulk_Order_Pvt.G_Header_Rec.Booked_Flag(p_header_index));

761: End If;
762:
763: If l_debug_level > 0 Then
764: oe_debug_pub.add('before checking Booked_Flag');
765: oe_debug_pub.add('Booked_Flag = '||OE_Bulk_Order_Pvt.G_Header_Rec.Booked_Flag(p_header_index));
766: oe_debug_pub.add('after printing Booked_Flag');
767: end if;
768: If OE_Bulk_Order_Pvt.G_Header_Rec.Booked_Flag(p_header_index) = 'N' Then
769: If l_debug_level > 0 Then

Line 766: oe_debug_pub.add('after printing Booked_Flag');

762:
763: If l_debug_level > 0 Then
764: oe_debug_pub.add('before checking Booked_Flag');
765: oe_debug_pub.add('Booked_Flag = '||OE_Bulk_Order_Pvt.G_Header_Rec.Booked_Flag(p_header_index));
766: oe_debug_pub.add('after printing Booked_Flag');
767: end if;
768: If OE_Bulk_Order_Pvt.G_Header_Rec.Booked_Flag(p_header_index) = 'N' Then
769: If l_debug_level > 0 Then
770: Oe_Debug_Pub.add('Order has been unbooked, no further unbook action is needed');

Line 770: Oe_Debug_Pub.add('Order has been unbooked, no further unbook action is needed');

766: oe_debug_pub.add('after printing Booked_Flag');
767: end if;
768: If OE_Bulk_Order_Pvt.G_Header_Rec.Booked_Flag(p_header_index) = 'N' Then
769: If l_debug_level > 0 Then
770: Oe_Debug_Pub.add('Order has been unbooked, no further unbook action is needed');
771: End If;
772: RETURN;
773: End If;
774:

Line 787: oe_debug_pub.add('in the while loop');

783:
784: While l_index > 0 Loop
785:
786: If l_debug_level > 0 Then
787: oe_debug_pub.add('in the while loop');
788: end if;
789: OE_BULK_ORDER_PVT.G_Line_Rec.Booked_Flag(l_index) := 'N';
790:
791: If OE_BULK_ORDER_PVT.G_Line_Rec.item_type_code(l_index) = 'KIT' Then

Line 796: oe_debug_pub.add('after checking item_type_code');

792: Unbook_Included_Item(p_start_index=> OE_BULK_ORDER_PVT.G_Line_Rec.ii_start_index(l_index),
793: p_count => OE_BULK_ORDER_PVT.G_Line_Rec.ii_count(l_index));
794: End If;
795: If l_debug_level > 0 Then
796: oe_debug_pub.add('after checking item_type_code');
797: end if;
798: If l_index <> 1 Then
799: If OE_BULK_ORDER_PVT.G_Line_Rec.Header_Index(l_index) <>
800: OE_BULK_ORDER_PVT.G_Line_Rec.Header_Index(l_index-1)

Line 832: oe_debug_pub.add('Line index is null, unable to unbook line');

828: l_index := l_index + 1;
829: End Loop;
830: Else
831: If l_debug_level > 0 Then
832: oe_debug_pub.add('Line index is null, unable to unbook line');
833: End If;
834: End If;
835:
836: End If;

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

866:
867: l_list_line_nos Varchar2(2000):=' ';
868: l_separator Varchar2(1):='';
869: --
870: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
871: --
872: Begin
873: For i in List_Lines_no Loop
874: l_list_line_nos := i.name||':'||i.list_line_no||l_separator||l_list_line_nos;

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

892: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
893: l_has_errors Boolean := False;
894: --l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
895: --l_gsa_violation_action Varchar2(30) := nvl(fnd_profile.value('ONT_GSA_VIOLATION_ACTION'), 'WARNING');
896: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
897: l_invalid_line varchar2(1);
898: l_request_id number;
899: l_price_list Varchar2(240);
900: l_msg_text Varchar2(200);

Line 947: oe_debug_pub.add('inside check_errors');

943:
944: Begin
945:
946: If l_debug_level > 0 Then
947: oe_debug_pub.add('inside check_errors');
948: end if;
949: OE_BULK_ORDER_PVT.G_Line_Rec.source_document_type_id.extend(l_line_count);
950: OE_BULK_ORDER_PVT.G_Line_Rec.source_document_line_id.extend(l_line_count);
951:

Line 954: oe_debug_pub.add('inside wrong_line loop');

950: OE_BULK_ORDER_PVT.G_Line_Rec.source_document_line_id.extend(l_line_count);
951:
952: For wrong_line in wrong_lines loop
953: if l_debug_level > 0 Then
954: oe_debug_pub.add('inside wrong_line loop');
955: oe_debug_pub.add('line_index = '||wrong_line.line_index);
956: end if;
957:
958: l_header_id := OE_BULK_ORDER_PVT.G_Line_Rec.header_id(wrong_line.line_index);

Line 955: oe_debug_pub.add('line_index = '||wrong_line.line_index);

951:
952: For wrong_line in wrong_lines loop
953: if l_debug_level > 0 Then
954: oe_debug_pub.add('inside wrong_line loop');
955: oe_debug_pub.add('line_index = '||wrong_line.line_index);
956: end if;
957:
958: l_header_id := OE_BULK_ORDER_PVT.G_Line_Rec.header_id(wrong_line.line_index);
959: l_order_source_id := OE_BULK_ORDER_PVT.G_Line_Rec.order_source_id(wrong_line.line_index);

Line 977: If l_debug_level > 0 Then oe_debug_pub.add('before set_msg_context'); end if;

973: l_price_list_id := OE_BULK_ORDER_PVT.G_Line_Rec.price_list_id(wrong_line.line_index);
974: l_inventory_item_id := OE_BULK_ORDER_PVT.G_Line_Rec.inventory_item_id(wrong_line.line_index);
975:
976:
977: If l_debug_level > 0 Then oe_debug_pub.add('before set_msg_context'); end if;
978:
979: OE_BULK_MSG_PUB.set_msg_context
980: ( p_entity_code => 'LINE'
981: ,p_entity_id => wrong_line.line_id

Line 995: oe_debug_pub.add( 'THE STATUS'||WRONG_LINE.PRICING_STATUS_CODE||':'||WRONG_LINE.PROCESSED_CODE||':'||WRONG_LINE.STATUS_TEXT ) ;

991: ,p_source_document_line_id => l_source_document_line_id
992: );
993:
994: IF l_debug_level > 0 THEN
995: oe_debug_pub.add( 'THE STATUS'||WRONG_LINE.PRICING_STATUS_CODE||':'||WRONG_LINE.PROCESSED_CODE||':'||WRONG_LINE.STATUS_TEXT ) ;
996: END IF;
997:
998: l_invalid_line := 'N';
999: -- add message when the price list is found to be inactive

Line 1004: IF l_debug_level > 0 THEN oe_debug_pub.add( 'PRICE LIST NOT FOUND1' ) ; END IF;

1000: IF wrong_line.line_Type_code ='LINE' and
1001: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND
1002: Then
1003:
1004: IF l_debug_level > 0 THEN oe_debug_pub.add( 'PRICE LIST NOT FOUND1' ) ; END IF;
1005:
1006: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1007: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1008: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);

Line 1041: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||l_ORDERED_ITEM||l_ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;

1037: End;
1038:
1039: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
1040: IF l_debug_level > 0 THEN
1041: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||l_ORDERED_ITEM||l_ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
1042: null;
1043: END IF;
1044:
1045: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');

Line 1055: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;

1051:
1052:
1053: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1056: END IF;
1057: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1058: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1059: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);

Line 1064: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;

1060: OE_BULK_MSG_PUB.Add;
1061:
1062: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
1063: IF l_debug_level > 0 THEN
1064: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
1065: END IF;
1066: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
1067: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1068: OE_BULK_MSG_PUB.Add;

Line 1075: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;

1071: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
1072: FND_API.G_RET_STS_ERROR)
1073: then
1074: IF l_debug_level > 0 THEN
1075: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
1076: END IF;
1077: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
1078: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);
1079: OE_BULK_MSG_PUB.Add;

Line 1083: oe_debug_pub.add( 'INVALID UOM' ) ;

1079: OE_BULK_MSG_PUB.Add;
1080:
1081: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add( 'INVALID UOM' ) ;
1084: END IF;
1085: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
1086: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1087: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);

Line 1091: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;

1087: FND_MESSAGE.SET_TOKEN('UOM',l_Order_Quantity_uom);
1088: OE_BULK_MSG_PUB.Add;
1089: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
1090: IF l_debug_level > 0 THEN
1091: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;
1092: END IF;
1093: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
1094:
1095: Begin

Line 1137: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;

1133: OE_BULK_MSG_PUB.Add;
1134:
1135: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
1136: IF l_debug_level > 0 THEN
1137: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
1138: END IF;
1139: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
1140: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||l_Ordered_Item||' ) '||
1141: wrong_line.status_text);

Line 1147: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;

1143:
1144:
1145: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
1146: IF l_debug_level > 0 THEN
1147: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
1148: END IF;
1149: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
1150: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||
1151: l_Ordered_Item||' ) '||wrong_line.status_text);

Line 1157: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;

1153: OE_BULK_MSG_PUB.Add;
1154:
1155: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
1156: IF l_debug_level > 0 THEN
1157: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1158: END IF;
1159: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1160: FND_MESSAGE.SET_TOKEN('ITEM',nvl(l_Ordered_Item,l_inventory_item_id));
1161: FND_MESSAGE.SET_TOKEN('ERR_TEXT',wrong_line.status_text);

Line 1174: oe_debug_pub.add(' GSA warning occured on line_id:'||wrong_line.line_id);

1170: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
1171: OE_BULK_MSG_PUB.Add;
1172:
1173: IF l_debug_level > 0 THEN
1174: oe_debug_pub.add(' GSA warning occured on line_id:'||wrong_line.line_id);
1175: END IF;
1176: ELSE --violation action is error
1177: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');
1178: OE_BULK_MSG_PUB.Add;

Line 1191: oe_debug_pub.add(' GSA Hold applied on line_id:'||wrong_line.line_id);

1187: p_activity_name => NULL,
1188: p_attribute => NULL,
1189: p_top_model_line_id => l_top_model_line_id );
1190: IF l_debug_level > 0 THEN
1191: oe_debug_pub.add(' GSA Hold applied on line_id:'||wrong_line.line_id);
1192: END IF;
1193: END IF;
1194: ELSE
1195: IF l_debug_level > 0 THEN oe_debug_pub.add(' GSA check is disabled'); END If;

Line 1195: IF l_debug_level > 0 THEN oe_debug_pub.add(' GSA check is disabled'); END If;

1191: oe_debug_pub.add(' GSA Hold applied on line_id:'||wrong_line.line_id);
1192: END IF;
1193: END IF;
1194: ELSE
1195: IF l_debug_level > 0 THEN oe_debug_pub.add(' GSA check is disabled'); END If;
1196: END IF;
1197: --bug 3716296 */
1198: END IF;
1199: End if;

Line 1219: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;

1215: FND_MESSAGE.SET_TOKEN('LIST_LINE_NO',get_list_lines(wrong_line.line_id));
1216: OE_BULK_MSG_PUB.Add;
1217:
1218: IF l_debug_level > 0 THEN
1219: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;
1220: oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;
1221: END IF;
1222:
1223: RAISE FND_API.G_EXC_ERROR;

Line 1220: oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;

1216: OE_BULK_MSG_PUB.Add;
1217:
1218: IF l_debug_level > 0 THEN
1219: oe_debug_pub.add( 'NEGATIVE LIST PRICE '||WRONG_LINE.UNIT_PRICE ||'OR SELLING PRICE '||WRONG_LINE.ADJUSTED_UNIT_PRICE ) ;
1220: oe_debug_pub.add( 'MODIFIERS:'||GET_LIST_LINES ( WRONG_LINE.LINE_ID ) ) ;
1221: END IF;
1222:
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;

Line 1227: IF l_debug_level > 0 THEN oe_debug_pub.add('before checking l_invalid_line'); END IF;

1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225:
1226:
1227: IF l_debug_level > 0 THEN oe_debug_pub.add('before checking l_invalid_line'); END IF;
1228:
1229: If l_invalid_line = 'Y' Then
1230: --we need to unbook the order and all the lines and included under this order
1231: --first check if the header is already has been unbooked, if yes, we would

Line 1237: If l_debug_level > 0 Then oe_debug_pub.add('after call to Unbook_Order'); END IF;

1233: --and all the lines including included under this order.
1234: --we can use header_index.
1235: Unbook_Order(OE_BULK_ORDER_PVT.G_Line_Rec.Header_Index(wrong_line.line_index),wrong_line.line_index);
1236:
1237: If l_debug_level > 0 Then oe_debug_pub.add('after call to Unbook_Order'); END IF;
1238: Else
1239: l_invalid_line:='N';
1240: End If;
1241:

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

1266: l_source_document_type_id Number;
1267: l_source_document_id Number;
1268: l_source_document_line_id Number;
1269: l_return_status Varchar2(1);
1270: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1271:
1272: CURSOR gsa_violators IS
1273: SELECT line_id, PRICING_STATUS_TEXT status_text, line_index
1274: FROM QP_PREQ_LINES_TMP

Line 1280: oe_debug_pub.add('inside check gsa');

1276: AND PROCESS_STATUS <> 'NOT_VALID'
1277: AND PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION;
1278: BEGIN
1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add('inside check gsa');
1281: END IF;
1282: for i in gsa_violators loop
1283: l_inventory_item_id := OE_BULK_ORDER_PVT.G_Line_Rec.inventory_item_id(i.line_index);
1284: l_header_id := OE_BULK_ORDER_PVT.G_Line_Rec.header_id(i.line_index);

Line 1287: oe_debug_pub.add('before set_msg_context');

1283: l_inventory_item_id := OE_BULK_ORDER_PVT.G_Line_Rec.inventory_item_id(i.line_index);
1284: l_header_id := OE_BULK_ORDER_PVT.G_Line_Rec.header_id(i.line_index);
1285: l_top_model_line_id := OE_BULK_ORDER_PVT.G_Line_Rec.top_model_line_id(i.line_index);
1286: If l_debug_level > 0 Then
1287: oe_debug_pub.add('before set_msg_context');
1288: end if;
1289:
1290: l_order_source_id := OE_BULK_ORDER_PVT.G_Line_Rec.order_source_id(i.line_index);
1291: l_orig_sys_document_ref := OE_BULK_ORDER_PVT.G_Line_Rec.orig_sys_document_ref(i.line_index);

Line 1321: oe_debug_pub.add(' GSA warning occured on line_id:'||i.line_id);

1317: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
1318: OE_BULK_MSG_PUB.Add;
1319:
1320: IF l_debug_level > 0 THEN
1321: oe_debug_pub.add(' GSA warning occured on line_id:'||i.line_id);
1322: END IF;
1323: ELSE --violation action is error
1324: /* bug 3735141
1325: FND_MESSAGE.SET_NAME('ONT','OE_GSA_HOLD_APPLIED');

Line 1343: oe_debug_pub.add(' GSA Hold applied on line_id:'||i.line_id);

1339: x_return_status => l_return_status);
1340: --bug 3735141
1341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1342: IF l_debug_level > 0 THEN
1343: oe_debug_pub.add(' GSA Hold applied on line_id:'||i.line_id);
1344: END IF;
1345: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1346: IF l_debug_level > 0 THEN
1347: oe_debug_pub.add('Unexpected error in applying GSA hold');

Line 1347: oe_debug_pub.add('Unexpected error in applying GSA hold');

1343: oe_debug_pub.add(' GSA Hold applied on line_id:'||i.line_id);
1344: END IF;
1345: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1346: IF l_debug_level > 0 THEN
1347: oe_debug_pub.add('Unexpected error in applying GSA hold');
1348: END IF;
1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1350: END IF;
1351: --bug 3735141

Line 1355: oe_debug_pub.add(' GSA check is disabled');

1351: --bug 3735141
1352: END IF;
1353: ELSE
1354: IF l_debug_level > 0 THEN
1355: oe_debug_pub.add(' GSA check is disabled');
1356: END If;
1357: END IF;
1358: END LOOP;
1359: END;

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

1399: cursor test is
1400: select CURRENCY_CODE,LINE_INDEX,LINE_ID,LINE_TYPE_CODE from qp_preq_lines_tmp;
1401:
1402: --
1403: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1404: --
1405: BEGIN
1406:
1407: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1413: oe_debug_pub.add('Version:'||get_version);

1409:
1410: qp_price_request_context.set_request_id;
1411:
1412: IF l_debug_level > 0 Then
1413: oe_debug_pub.add('Version:'||get_version);
1414: for l_index in 1..l_header_count loop
1415: oe_debug_pub.add('l_index : '||l_index||' header currency code : '||p_header_rec.transactional_curr_code(l_index));
1416: oe_debug_pub.add('price list id : '||p_header_rec.PRICE_LIST_ID(l_index)||' HEADER_ID : '||p_header_rec.HEADER_ID(l_index));
1417: oe_debug_pub.add('ordered date : '||p_header_rec.ORDERED_DATE(l_index)||' PRICING_DATE : '||p_header_rec.PRICING_DATE(l_index)||' header_index : '||p_header_rec.header_index(l_index));

Line 1415: oe_debug_pub.add('l_index : '||l_index||' header currency code : '||p_header_rec.transactional_curr_code(l_index));

1411:
1412: IF l_debug_level > 0 Then
1413: oe_debug_pub.add('Version:'||get_version);
1414: for l_index in 1..l_header_count loop
1415: oe_debug_pub.add('l_index : '||l_index||' header currency code : '||p_header_rec.transactional_curr_code(l_index));
1416: oe_debug_pub.add('price list id : '||p_header_rec.PRICE_LIST_ID(l_index)||' HEADER_ID : '||p_header_rec.HEADER_ID(l_index));
1417: oe_debug_pub.add('ordered date : '||p_header_rec.ORDERED_DATE(l_index)||' PRICING_DATE : '||p_header_rec.PRICING_DATE(l_index)||' header_index : '||p_header_rec.header_index(l_index));
1418: oe_debug_pub.add('orig_sys_document_ref : '||p_header_rec.orig_sys_document_ref(l_index));
1419: end loop;

Line 1416: oe_debug_pub.add('price list id : '||p_header_rec.PRICE_LIST_ID(l_index)||' HEADER_ID : '||p_header_rec.HEADER_ID(l_index));

1412: IF l_debug_level > 0 Then
1413: oe_debug_pub.add('Version:'||get_version);
1414: for l_index in 1..l_header_count loop
1415: oe_debug_pub.add('l_index : '||l_index||' header currency code : '||p_header_rec.transactional_curr_code(l_index));
1416: oe_debug_pub.add('price list id : '||p_header_rec.PRICE_LIST_ID(l_index)||' HEADER_ID : '||p_header_rec.HEADER_ID(l_index));
1417: oe_debug_pub.add('ordered date : '||p_header_rec.ORDERED_DATE(l_index)||' PRICING_DATE : '||p_header_rec.PRICING_DATE(l_index)||' header_index : '||p_header_rec.header_index(l_index));
1418: oe_debug_pub.add('orig_sys_document_ref : '||p_header_rec.orig_sys_document_ref(l_index));
1419: end loop;
1420: /*

Line 1417: oe_debug_pub.add('ordered date : '||p_header_rec.ORDERED_DATE(l_index)||' PRICING_DATE : '||p_header_rec.PRICING_DATE(l_index)||' header_index : '||p_header_rec.header_index(l_index));

1413: oe_debug_pub.add('Version:'||get_version);
1414: for l_index in 1..l_header_count loop
1415: oe_debug_pub.add('l_index : '||l_index||' header currency code : '||p_header_rec.transactional_curr_code(l_index));
1416: oe_debug_pub.add('price list id : '||p_header_rec.PRICE_LIST_ID(l_index)||' HEADER_ID : '||p_header_rec.HEADER_ID(l_index));
1417: oe_debug_pub.add('ordered date : '||p_header_rec.ORDERED_DATE(l_index)||' PRICING_DATE : '||p_header_rec.PRICING_DATE(l_index)||' header_index : '||p_header_rec.header_index(l_index));
1418: oe_debug_pub.add('orig_sys_document_ref : '||p_header_rec.orig_sys_document_ref(l_index));
1419: end loop;
1420: /*
1421: for l_index in 1..l_line_count loop

Line 1418: oe_debug_pub.add('orig_sys_document_ref : '||p_header_rec.orig_sys_document_ref(l_index));

1414: for l_index in 1..l_header_count loop
1415: oe_debug_pub.add('l_index : '||l_index||' header currency code : '||p_header_rec.transactional_curr_code(l_index));
1416: oe_debug_pub.add('price list id : '||p_header_rec.PRICE_LIST_ID(l_index)||' HEADER_ID : '||p_header_rec.HEADER_ID(l_index));
1417: oe_debug_pub.add('ordered date : '||p_header_rec.ORDERED_DATE(l_index)||' PRICING_DATE : '||p_header_rec.PRICING_DATE(l_index)||' header_index : '||p_header_rec.header_index(l_index));
1418: oe_debug_pub.add('orig_sys_document_ref : '||p_header_rec.orig_sys_document_ref(l_index));
1419: end loop;
1420: /*
1421: for l_index in 1..l_line_count loop
1422: oe_debug_pub.add('l_index : '||l_index||' line currency code : '||p_line_rec.currency_code(l_index));

Line 1422: oe_debug_pub.add('l_index : '||l_index||' line currency code : '||p_line_rec.currency_code(l_index));

1418: oe_debug_pub.add('orig_sys_document_ref : '||p_header_rec.orig_sys_document_ref(l_index));
1419: end loop;
1420: /*
1421: for l_index in 1..l_line_count loop
1422: oe_debug_pub.add('l_index : '||l_index||' line currency code : '||p_line_rec.currency_code(l_index));
1423: end loop;
1424: */
1425: end if;
1426:

Line 1432: oe_debug_pub.add('before QP_BULK_PREQ_GRP.Bulk_insert_lines');

1428: -- Bug 5640601 =>
1429: -- Selecting hsecs from v$times is changed to execute only when debug
1430: -- is enabled, as hsec is used for logging only when debug is enabled.
1431: SELECT hsecs INTO l_start_time from v$timer;
1432: oe_debug_pub.add('before QP_BULK_PREQ_GRP.Bulk_insert_lines');
1433: end if;
1434: QP_BULK_PREQ_GRP.Bulk_insert_lines(p_header_rec => p_header_rec
1435: , p_line_rec => p_line_rec
1436: , x_return_status => x_return_status

Line 1439: oe_debug_pub.add('return status after Bulk_insert_lines : '||x_return_status||' status text : '||x_return_status_text);

1435: , p_line_rec => p_line_rec
1436: , x_return_status => x_return_status
1437: , x_return_status_text => x_return_status_text);
1438: If l_debug_level > 0 Then
1439: oe_debug_pub.add('return status after Bulk_insert_lines : '||x_return_status||' status text : '||x_return_status_text);
1440: End IF;
1441: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1442: OR x_return_status = FND_API.G_RET_STS_ERROR )
1443: THEN

Line 1449: oe_debug_pub.add('l_count : '||l_count);

1445: END IF;
1446:
1447: If l_debug_level > 0 Then
1448: select count(*) into l_count from qp_preq_lines_tmp;
1449: oe_debug_pub.add('l_count : '||l_count);
1450: for i in test loop
1451: oe_debug_pub.add('curr code : '||i.CURRENCY_CODE||' LINE_INDEX : '||i.LINE_INDEX||' LINE_ID : '||i.LINE_ID||' LINE_TYPE_CODE : '||i.LINE_TYPE_CODE);
1452: end loop;
1453:

Line 1451: oe_debug_pub.add('curr code : '||i.CURRENCY_CODE||' LINE_INDEX : '||i.LINE_INDEX||' LINE_ID : '||i.LINE_ID||' LINE_TYPE_CODE : '||i.LINE_TYPE_CODE);

1447: If l_debug_level > 0 Then
1448: select count(*) into l_count from qp_preq_lines_tmp;
1449: oe_debug_pub.add('l_count : '||l_count);
1450: for i in test loop
1451: oe_debug_pub.add('curr code : '||i.CURRENCY_CODE||' LINE_INDEX : '||i.LINE_INDEX||' LINE_ID : '||i.LINE_ID||' LINE_TYPE_CODE : '||i.LINE_TYPE_CODE);
1452: end loop;
1453:
1454: -- Bug 5640601 =>
1455: -- Selecting hsecs from v$times is changed to execute only when debug

Line 1463: oe_debug_pub.add('before QP_BULK_PREQ_GRP.Bulk_insert_adj');

1459:
1460: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Bulk_insert_lines is (sec) '||((l_end_time-l_start_time)/100));
1461:
1462: If l_debug_level > 0 Then
1463: oe_debug_pub.add('before QP_BULK_PREQ_GRP.Bulk_insert_adj');
1464: end if;
1465: IF p_adjustments_exist = 'Y' THEN --pibadj
1466: QP_BULK_PREQ_GRP.Bulk_insert_adj(x_return_status,
1467: x_return_status_text);

Line 1469: oe_debug_pub.add('after Bulk_insert_adj return status : '||x_return_status||' status text : '||x_return_status_text);

1465: IF p_adjustments_exist = 'Y' THEN --pibadj
1466: QP_BULK_PREQ_GRP.Bulk_insert_adj(x_return_status,
1467: x_return_status_text);
1468: If l_debug_level > 0 Then
1469: oe_debug_pub.add('after Bulk_insert_adj return status : '||x_return_status||' status text : '||x_return_status_text);
1470: end if;
1471: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1472: OR x_return_status = FND_API.G_RET_STS_ERROR )
1473: THEN

Line 1510: oe_debug_pub.add('before QP_PREQ_PUB.PRICE_REQUEST');

1506: -- Selecting hsecs from v$times is changed to execute only when debug
1507: -- is enabled, as hsec is used for logging only when debug is enabled.
1508: SELECT hsecs INTO l_start_time from v$timer;
1509:
1510: oe_debug_pub.add('before QP_PREQ_PUB.PRICE_REQUEST');
1511: end if;
1512: QP_PREQ_PUB.PRICE_REQUEST
1513: (p_control_rec => l_Price_Control_rec
1514: ,x_return_status =>x_return_status

Line 1518: oe_debug_pub.add('after PRICE_REQUEST return status : '||x_return_status||' status text : '||x_return_status_Text);

1514: ,x_return_status =>x_return_status
1515: ,x_return_status_Text =>x_return_status_Text
1516: );
1517: If l_debug_level > 0 Then
1518: oe_debug_pub.add('after PRICE_REQUEST return status : '||x_return_status||' status text : '||x_return_status_Text);
1519:
1520: -- Bug 5640601 =>
1521: -- Selecting hsecs from v$times is changed to execute only when debug
1522: -- is enabled, as hsec is used for logging only when debug is enabled.

Line 1537: oe_debug_pub.add('before check_errors');

1533: -- error handling,if an error happens, the whole order in memory should be marked as unbooked
1534: -- check_errors will also post error message in message processing table.
1535: -- check_errors will also handle gsa violation.
1536: IF l_debug_level > 0 Then
1537: oe_debug_pub.add('before check_errors');
1538:
1539: -- Bug 5640601 =>
1540: -- Selecting hsecs from v$times is changed to execute only when debug
1541: -- is enabled, as hsec is used for logging only when debug is enabled.