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

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

143: out_inv_item_type out nocopy varchar2
144: )
145: IS
146: l_org_id number := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
147: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
148: BEGIN
149: SELECT concatenated_segments,description,item_type
150: INTO out_inv_item_name,out_inv_desc,out_inv_item_type
151: FROM mtl_system_items_kfv

Line 159: oe_debug_pub.add( 'OE_OE_RELATED_ITEMS.GET_item_upgrade_details NO DATA FOUND' ) ;

155:
156: EXCEPTION
157: when no_data_found then
158: IF l_debug_level > 0 THEN
159: oe_debug_pub.add( 'OE_OE_RELATED_ITEMS.GET_item_upgrade_details NO DATA FOUND' ) ;
160: END IF;
161: when others then
162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'OE_OE_RELATED_ITEMS.GET_item_NAME WHEN OTHERS '|| SQLERRM||SQLCODE ) ;

Line 163: oe_debug_pub.add( 'OE_OE_RELATED_ITEMS.GET_item_NAME WHEN OTHERS '|| SQLERRM||SQLCODE ) ;

159: oe_debug_pub.add( 'OE_OE_RELATED_ITEMS.GET_item_upgrade_details NO DATA FOUND' ) ;
160: END IF;
161: when others then
162: IF l_debug_level > 0 THEN
163: oe_debug_pub.add( 'OE_OE_RELATED_ITEMS.GET_item_NAME WHEN OTHERS '|| SQLERRM||SQLCODE ) ;
164: END IF;
165:
166: END get_upgrade_item_details;
167:

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

209: l_line_rec oe_ak_order_lines_v%ROWTYPE;
210: l_out_line_rec oe_ak_order_lines_v%ROWTYPE;
211:
212: --
213: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
214: --
215: BEGIN
216:
217: IF l_debug_level > 0 THEN

Line 218: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.DEFAULTING '||

214: --
215: BEGIN
216:
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.DEFAULTING '||
219: 'ITEM_ID='||P_RELATED_ITEM_ID||
220: 'ORG ID TYPE ='||P_ORG_ID||
221: 'CUSTOMER_ID ='||P_CUST_ACCOUNT_ID||
222: 'SHIP_TO_ORG_ID ='||P_SHIP_TO_ORG_ID||

Line 287: oe_debug_pub.add( 'WSH_ID='||X_WSH_ID|| ' X_UOM=' || X_UOM ) ;

283: x_wsh_id := l_out_line_rec.ship_from_org_id;
284: x_uom := l_out_line_rec.order_quantity_uom;
285:
286: IF l_debug_level > 0 THEN
287: oe_debug_pub.add( 'WSH_ID='||X_WSH_ID|| ' X_UOM=' || X_UOM ) ;
288: END IF;
289:
290:
291: IF l_debug_level > 0 THEN

Line 292: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.DEFAULTING' ) ;

288: END IF;
289:
290:
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.DEFAULTING' ) ;
293: END IF;
294:
295: EXCEPTION
296:

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

368: I NUMBER := 1;
369:
370:
371: --
372: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
373: --
374: BEGIN
375:
376: IF l_debug_level > 0 THEN

Line 377: oe_debug_pub.add( 'ENTERING CALL ATP' ) ;

373: --
374: BEGIN
375:
376: IF l_debug_level > 0 THEN
377: oe_debug_pub.add( 'ENTERING CALL ATP' ) ;
378: END IF;
379:
380: Initialize_mrp_record
381: ( p_x_atp_rec => l_atp_rec

Line 386: oe_debug_pub.add( 'INVENTORY_ITEM_ID='||P_RELATED_ITEM_ID||

382: ,l_count =>1 );
383:
384:
385: IF l_debug_level > 0 THEN
386: oe_debug_pub.add( 'INVENTORY_ITEM_ID='||P_RELATED_ITEM_ID||
387: ' SHIP_FORM_ORG_ID='||P_SHIP_FROM_ORG_ID|| ' P_GLOBAL_ORGS='||
388: P_GLOBAL_ORGS|| ' CUST_ID='||P_CUST_ACCOUNT_ID|| ' SHIP_TO_ORG_ID='||
389: P_SHIP_TO_ORG_ID||' QTY='||P_ORDERED_QTY|| ' UOM='||P_RELATED_UOM||' REQ DATE='||P_REQUEST_DATE ) ;
390: END IF;

Line 403: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;

399: l_atp_rec.Source_Organization_Id(1) := g_ship_from_org_id;
400: END IF;
401: */
402: IF l_debug_level > 0 THEN
403: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;
404: END IF;
405:
406: l_atp_rec.Source_Organization_Id(1) := p_ship_from_org_id;
407: l_atp_rec.Identifier(I) := g_atp_line_id;

Line 444: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;

440:
441: -- Call ATP
442:
443: IF l_debug_level > 0 THEN
444: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
445: END IF;
446:
447: IF l_debug_level > 0 THEN
448: print_time('Calling MRP');

Line 467: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||

463: IF l_debug_level > 0 THEN
464: print_time('After Calling MRP');
465: END IF;
466: IF l_debug_level > 0 THEN
467: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||
468: X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT|| ' MSG DATA='||X_MSG_DATA||
469: 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) || 'SHIP_FROM_ORG_ID =' ||
470: X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
471: END IF;

Line 475: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;

471: END IF;
472:
473: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
474: IF l_debug_level > 0 THEN
475: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
476: END IF;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:

Line 491: oe_debug_pub.add( 'STATUS='||X_RETURN_STATUS|| ' X_ERROR_MESSAGE ='||X_ERROR_MESSAGE|| ' MSG DATA='||X_MSG_DATA ) ;

487: ,x_error_message =>x_error_message
488: );
489:
490: IF l_debug_level > 0 THEN
491: oe_debug_pub.add( 'STATUS='||X_RETURN_STATUS|| ' X_ERROR_MESSAGE ='||X_ERROR_MESSAGE|| ' MSG DATA='||X_MSG_DATA ) ;
492: END IF;
493:
494: IF x_return_status <> 'P' then
495:

Line 497: oe_debug_pub.add( 'RETURN_STATUS<>P' ) ;

493:
494: IF x_return_status <> 'P' then
495:
496: IF l_debug_level > 0 THEN
497: oe_debug_pub.add( 'RETURN_STATUS<>P' ) ;
498: END IF;
499:
500: IF nvl(x_atp_rec.available_quantity(1),0) = 0 then
501:

Line 503: oe_debug_pub.add( 'AVAILABLE QUANTITY IS 0' ) ;

499:
500: IF nvl(x_atp_rec.available_quantity(1),0) = 0 then
501:
502: IF l_debug_level > 0 THEN
503: oe_debug_pub.add( 'AVAILABLE QUANTITY IS 0' ) ;
504: END IF;
505: x_available_date := null;
506: x_available_qty := 0;
507:

Line 519: oe_debug_pub.add( 'RETURN_STATUS=P MESG='||X_ERROR_MESSAGE ) ;

515: END IF;
516:
517: ELSE
518: IF l_debug_level > 0 THEN
519: oe_debug_pub.add( 'RETURN_STATUS=P MESG='||X_ERROR_MESSAGE ) ;
520: END IF;
521: x_available_qty := x_error_message;
522: x_available_date := null;
523: x_error_message := null;

Line 533: oe_debug_pub.add( 'OUT_AVAL_QTY='||X_AVAILABLE_QTY||

529: x_qty_uom := x_atp_rec.quantity_uom(1);
530:
531:
532: IF l_debug_level > 0 THEN
533: oe_debug_pub.add( 'OUT_AVAL_QTY='||X_AVAILABLE_QTY||
534: ' SHIP_FORM_ORG_ID='||X_SHIP_FROM_ORG_ID|| ' UOM='||X_QTY_UOM||
535: ' OUT SHIP DATE='||X_ATP_REC.SHIP_DATE ( 1 ) || ' OUT GRP SHIP DATE='||
536: X_ATP_REC.GROUP_SHIP_DATE ( 1 ) || ' OUT ARRIVAL DATE='||
537: X_ATP_REC.ARRIVAL_DATE ( 1 ) || ' OUT GRP ARRIVAL DATE='||

Line 545: oe_debug_pub.add( 'EXITING CALL ATP' , 1 ) ;

541: END IF;
542:
543:
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'EXITING CALL ATP' , 1 ) ;
546: END IF;
547:
548:
549: EXCEPTION

Line 554: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;

550:
551: WHEN OTHERS THEN
552:
553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
555: END IF;
556: IF l_debug_level > 0 THEN
557: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
558: END IF;

Line 557: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;

553: IF l_debug_level > 0 THEN
554: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
555: END IF;
556: IF l_debug_level > 0 THEN
557: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
558: END IF;
559: x_return_status := 'E';
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: -- Get message count and data

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

581:
582: l_return_status varchar2(10);
583:
584: --
585: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
586: --
587: BEGIN
588:
589: IF l_debug_level > 0 THEN

Line 590: oe_debug_pub.add( 'EXTENDING THE TABLE BY ' || L_COUNT , 5 ) ;

586: --
587: BEGIN
588:
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add( 'EXTENDING THE TABLE BY ' || L_COUNT , 5 ) ;
591: END IF;
592:
593: MSC_SATP_FUNC.Extend_ATP
594: (p_atp_tab => p_x_atp_rec,

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

624: l_arrival_set_name VARCHAR2(30);
625: l_arrival_date DATE := NULL;
626: l_sch_action varchar2(100) := 'OESCH_ACT_ATP_CHECK';
627: --
628: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
629: --
630: BEGIN
631:
632: x_return_status := 'S';

Line 634: oe_debug_pub.add( '2. ENTERING CHECK_RESULTS ERROR_CODE='|| P_ATP_REC.ERROR_CODE ( J ) || ' P_GLOBAL_ORGS='||P_GLOBAL_ORGS ) ;

630: BEGIN
631:
632: x_return_status := 'S';
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add( '2. ENTERING CHECK_RESULTS ERROR_CODE='|| P_ATP_REC.ERROR_CODE ( J ) || ' P_GLOBAL_ORGS='||P_GLOBAL_ORGS ) ;
635: END IF;
636:
637: IF p_atp_rec.error_code(J) <> 0 AND
638: p_atp_rec.error_code(J) <> -99 AND -- Multi org changes.

Line 644: oe_debug_pub.add( 'ERROR FROM MRP: ' || P_ATP_REC.ERROR_CODE ( J ) , 1 ) ;

640:
641: THEN
642:
643: IF l_debug_level > 0 THEN
644: oe_debug_pub.add( 'ERROR FROM MRP: ' || P_ATP_REC.ERROR_CODE ( J ) , 1 ) ;
645: END IF;
646:
647: IF p_atp_rec.error_code(J) = 80 THEN
648:

Line 658: oe_debug_pub.add( 'SETTING THE MESSAGE FOR OE_SCH_NO_SOURCE' ) ;

654: where lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
655: and lookup_code = 80;
656:
657: IF l_debug_level > 0 THEN
658: oe_debug_pub.add( 'SETTING THE MESSAGE FOR OE_SCH_NO_SOURCE' ) ;
659: END IF;
660: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
661: IF p_global_orgs = 'N' then
662:

Line 672: oe_debug_pub.add( 'SCH FAILED ERROR CODE='||P_ATP_REC.ERROR_CODE ( J ) ) ;

668:
669: ELSE
670:
671: IF l_debug_level > 0 THEN
672: oe_debug_pub.add( 'SCH FAILED ERROR CODE='||P_ATP_REC.ERROR_CODE ( J ) ) ;
673: END IF;
674:
675: l_explanation := null;
676:

Line 693: oe_debug_pub.add( 'ERROR CODE = 61' ) ;

689: ELSIF p_atp_rec.error_code(J) = 61 THEN
690:
691: -- setting the status flag to partial for ATP not applicable
692: IF l_debug_level > 0 THEN
693: oe_debug_pub.add( 'ERROR CODE = 61' ) ;
694: END IF;
695:
696: x_return_status := 'P';
697: x_error_message := l_explanation;

Line 708: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;

704: null;
705:
706: ELSE
707: IF l_debug_level > 0 THEN
708: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
709: END IF;
710: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
711: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
712:

Line 726: oe_debug_pub.add( 'SETTING ERROR' , 1 ) ;

722:
723: END IF; -- 80
724:
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'SETTING ERROR' , 1 ) ;
727: END IF;
728: IF x_return_status <> 'P' then
729: x_return_status := 'E';
730: END IF;

Line 735: oe_debug_pub.add( ' ELSE '||P_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) || ' ERROR CODE : ' || P_ATP_REC.ERROR_CODE ( J ) ) ;

731:
732: ELSE
733:
734: IF l_debug_level > 0 THEN
735: oe_debug_pub.add( ' ELSE '||P_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) || ' ERROR CODE : ' || P_ATP_REC.ERROR_CODE ( J ) ) ;
736: END IF;
737:
738: -- Muti org changes.
739: IF (p_atp_rec.error_code(J) <> -99 ) THEN

Line 742: oe_debug_pub.add( 'ERROR CODE : ' ||

738: -- Muti org changes.
739: IF (p_atp_rec.error_code(J) <> -99 ) THEN
740:
741: IF l_debug_level > 0 THEN
742: oe_debug_pub.add( 'ERROR CODE : ' ||
743: P_ATP_REC.ERROR_CODE ( J ) || 'IDENTIFIER : ' ||
744: P_ATP_REC.IDENTIFIER ( J ) || 'ITEM : ' ||
745: P_ATP_REC.INVENTORY_ITEM_ID ( J ) || 'REQUEST SHIP DATE :' ||
746: TO_CHAR ( P_ATP_REC.REQUESTED_SHIP_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' ) ||

Line 770: oe_debug_pub.add( 'EXPLANATION IS : ' || L_EXPLANATION , 1 ) ;

766: and lookup_code = p_atp_rec.error_code(J) ;
767:
768: g_atp_tbl(atp_count).error_message := l_explanation;
769: IF l_debug_level > 0 THEN
770: oe_debug_pub.add( 'EXPLANATION IS : ' || L_EXPLANATION , 1 ) ;
771: END IF;
772: x_error_message := l_explanation;
773:
774: IF p_atp_rec.error_code(J) = 150 THEN

Line 796: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;

792: --OE_MSG_PUB.Add;
793:
794: IF x_return_status ='E' and p_global_orgs = 'N' then
795: IF l_debug_level > 0 THEN
796: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
797: END IF;
798: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
799: p_count => x_msg_count,
800: p_data=>x_msg_data

Line 803: oe_debug_pub.add( 'COUNT = '||X_MSG_COUNT||' MSG='||X_MSG_DATA ) ;

799: p_count => x_msg_count,
800: p_data=>x_msg_data
801: );
802: IF l_debug_level > 0 THEN
803: oe_debug_pub.add( 'COUNT = '||X_MSG_COUNT||' MSG='||X_MSG_DATA ) ;
804: END IF;
805: END IF;
806:
807: IF l_debug_level > 0 THEN

Line 808: oe_debug_pub.add( 'EXITING CHECK_RESULTS: ' || X_RETURN_STATUS , 1 ) ;

804: END IF;
805: END IF;
806:
807: IF l_debug_level > 0 THEN
808: oe_debug_pub.add( 'EXITING CHECK_RESULTS: ' || X_RETURN_STATUS , 1 ) ;
809: END IF;
810:
811: EXCEPTION
812: WHEN OTHERS THEN

Line 821: oe_debug_pub.add( 'UNEXPECTED ERROR IN CHECK_RESULTS' ) ;

817: , 'Check_Results'
818: );
819: END IF;
820: IF l_debug_level > 0 THEN
821: oe_debug_pub.add( 'UNEXPECTED ERROR IN CHECK_RESULTS' ) ;
822: END IF;
823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
824:
825: END Check_Results_from_rec;

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

829: out_name out NOCOPY /* file.sql.39 change */ varchar2
830: )IS
831:
832: --
833: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
834: --
835: BEGIN
836: SELECT organization_code,
837: name

Line 847: oe_debug_pub.add( 'GET_SHIP_FROM_ORG WHEN OTHERS '|| SQLCODE||SQLERRM ) ;

843: EXCEPTION
844:
845: WHEN OTHERS THEN
846: IF l_debug_level > 0 THEN
847: oe_debug_pub.add( 'GET_SHIP_FROM_ORG WHEN OTHERS '|| SQLCODE||SQLERRM ) ;
848: END IF;
849:
850: END get_ship_From_org;
851:

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

857:
858: l_line_index pls_integer := 0;
859:
860: --
861: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
862: --
863: BEGIN
864:
865: IF l_debug_level > 0 THEN

Line 866: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;

862: --
863: BEGIN
864:
865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;
867: oe_debug_pub.add( ' line index in copy header to request'||l_line_index);
868: END IF;
869:
870: l_line_index := l_line_index+1;

Line 867: oe_debug_pub.add( ' line index in copy header to request'||l_line_index);

863: BEGIN
864:
865: IF l_debug_level > 0 THEN
866: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;
867: oe_debug_pub.add( ' line index in copy header to request'||l_line_index);
868: END IF;
869:
870: l_line_index := l_line_index+1;
871: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE :=p_Request_Type_Code;

Line 896: oe_debug_pub.add( 'CURR='||G_CURRENCY||' REQ DATE='||G_REQUEST_DATE||' ROUNDING_FACTOR='||PX_REQ_LINE_TBL ( L_LINE_INDEX ) .ROUNDING_FACTOR ) ;

892: px_req_line_tbl(l_line_index).Rounding_factor := Get_Rounding_factor(g_price_list_id);
893: END IF;
894: --End If;
895: IF l_debug_level > 0 THEN
896: oe_debug_pub.add( 'CURR='||G_CURRENCY||' REQ DATE='||G_REQUEST_DATE||' ROUNDING_FACTOR='||PX_REQ_LINE_TBL ( L_LINE_INDEX ) .ROUNDING_FACTOR ) ;
897: END IF;
898:
899: --px_req_line_tbl(l_line_index).price_request_code := p_header_rec.price_request_code; -- PROMOTIONS SEP/01
900:

Line 902: oe_debug_pub.add( 'EXITING OE_OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' ) ;

898:
899: --px_req_line_tbl(l_line_index).price_request_code := p_header_rec.price_request_code; -- PROMOTIONS SEP/01
900:
901: IF l_debug_level > 0 THEN
902: oe_debug_pub.add( 'EXITING OE_OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' ) ;
903: END IF;
904:
905: END copy_Header_to_request;
906:

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

915: v_discounting_privilege VARCHAR2(30);
916: l_item_type_code VARCHAR2(30);
917:
918: --
919: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
920: --
921: begin
922:
923: IF l_debug_level > 0 THEN

Line 924: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;

920: --
921: begin
922:
923: IF l_debug_level > 0 THEN
924: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
925: oe_debug_pub.add( 'line index in copy line to request'||l_line_index);
926: END IF;
927:
928: l_line_index := l_line_index+1;

Line 925: oe_debug_pub.add( 'line index in copy line to request'||l_line_index);

921: begin
922:
923: IF l_debug_level > 0 THEN
924: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
925: oe_debug_pub.add( 'line index in copy line to request'||l_line_index);
926: END IF;
927:
928: l_line_index := l_line_index+1;
929: px_req_line_tbl(l_line_index).Line_id := g_line_id;

Line 948: oe_debug_pub.add( 'QTY='||G_QTY||' UOM ='||G_UOM||' CURR='||G_CURRENCY ) ;

944: px_req_line_tbl(l_line_index).CURRENCY_CODE :=g_currency;
945: px_req_line_tbl(l_line_index).UNIT_PRICE := Null;
946: --px_req_line_tbl(l_line_index).PERCENT_PRICE := p_Line_rec.unit_list_percent;
947: IF l_debug_level > 0 THEN
948: oe_debug_pub.add( 'QTY='||G_QTY||' UOM ='||G_UOM||' CURR='||G_CURRENCY ) ;
949: END IF;
950:
951: /*If (p_Line_rec.service_period = p_Line_rec.Order_quantity_uom) Then
952: px_req_line_tbl(l_line_index).UOM_QUANTITY := p_Line_rec.service_duration;

Line 996: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;

992: --px_req_line_tbl(l_line_index).price_request_code := p_line_rec.price_request_code; -- PROMOTIONS SEP/01
993: --px_req_line_tbl(l_line_index).line_category :=p_line_rec.line_category_code;
994:
995: IF l_debug_level > 0 THEN
996: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
997: END IF;
998:
999: END copy_Line_to_request;
1000:

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

1002: l_Control_Rec in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE
1003: ,in_pricing_event in varchar2)IS
1004:
1005: --
1006: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1007: --
1008:
1009: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1010: BEGIN

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

1041: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1042: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1043:
1044: --
1045: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1046: --
1047: BEGIN
1048:
1049: IF l_debug_level > 0 THEN

Line 1050: oe_debug_pub.add( 'BEFORE OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;

1046: --
1047: BEGIN
1048:
1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'BEFORE OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1051: END IF;
1052:
1053: IF l_debug_level > 0 THEN
1054: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||

Line 1054: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||

1050: oe_debug_pub.add( 'BEFORE OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1051: END IF;
1052:
1053: IF l_debug_level > 0 THEN
1054: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||
1055: G_PRICING_DATE|| ' INV ITEM_IE='||G_RELATED_ITEM_ID|| ' AGREEMENT_ID='||
1056: G_AGREEMENT_ID|| ' REQ DATE='||G_REQUEST_DATE|| ' SHIP_TO_ORG_ID='||
1057: G_SHIP_TO_ORG_ID|| ' INVOICE_TO_ORG_ID='||G_INVOICE_TO_ORG_ID ) ;
1058: END IF;

Line 1061: oe_debug_pub.add( 'QTY='||G_QTY|| ' ITEM_TYPE_CODE='||P_ITEM_TYPE_CODE|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID|| ' CUST_ID='||G_CUSTOMER_ID|| ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE|| ' UOM='||G_UOM ) ;

1057: G_SHIP_TO_ORG_ID|| ' INVOICE_TO_ORG_ID='||G_INVOICE_TO_ORG_ID ) ;
1058: END IF;
1059:
1060: IF l_debug_level > 0 THEN
1061: oe_debug_pub.add( 'QTY='||G_QTY|| ' ITEM_TYPE_CODE='||P_ITEM_TYPE_CODE|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID|| ' CUST_ID='||G_CUSTOMER_ID|| ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE|| ' UOM='||G_UOM ) ;
1062: END IF;
1063:
1064: oe_order_pub.g_line.org_id := l_org_id;
1065: oe_order_pub.g_line.pricing_date := g_pricing_date;

Line 1107: oe_debug_pub.add( 'EXIT OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;

1103: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1104: );
1105:
1106: IF l_debug_level > 0 THEN
1107: oe_debug_pub.add( 'EXIT OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1108: END IF;
1109:
1110: EXCEPTION
1111: when no_data_found then

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

1127: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);
1128: l_qual_index pls_integer := nvl(px_Req_qual_tbl.last,0);
1129:
1130: --
1131: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1132: --
1133: BEGIN
1134:
1135: IF l_debug_level > 0 THEN

Line 1136: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;

1132: --
1133: BEGIN
1134:
1135: IF l_debug_level > 0 THEN
1136: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;
1137: END IF;
1138: i := p_pricing_contexts_Tbl.First;
1139: While i is not null loop
1140: l_attr_index := l_attr_index +1;

Line 1187: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;

1183: i := p_qualifier_contexts_Tbl.Next(i);
1184: end loop;
1185:
1186: IF l_debug_level > 0 THEN
1187: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;
1188: END IF;
1189:
1190: END copy_attribs_to_Req;
1191:

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

1202: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1203: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1204:
1205: --
1206: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1207: --
1208: /*4163551*/
1209: l_header_rec OE_ORDER_PUB.header_rec_type;
1210: /*4163551*/

Line 1214: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;

1210: /*4163551*/
1211: BEGIN
1212:
1213: IF l_debug_level > 0 THEN
1214: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1215: END IF;
1216:
1217:
1218: IF l_debug_level > 0 THEN

Line 1219: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||G_PRICING_DATE|| ' AGREEMENT_ID='||G_AGREEMENT_ID|| ' REQ DATE='||G_REQUEST_DATE|| ' SHIP_TO_ORG_ID='||G_SHIP_TO_ORG_ID|| ' INVOICE_TO_ORG_ID='||G_INVOICE_TO_ORG_ID ) ;

1215: END IF;
1216:
1217:
1218: IF l_debug_level > 0 THEN
1219: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||G_PRICING_DATE|| ' AGREEMENT_ID='||G_AGREEMENT_ID|| ' REQ DATE='||G_REQUEST_DATE|| ' SHIP_TO_ORG_ID='||G_SHIP_TO_ORG_ID|| ' INVOICE_TO_ORG_ID='||G_INVOICE_TO_ORG_ID ) ;
1220: END IF;
1221:
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'QTY='||G_QTY|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID|| ' CUST_ID='||G_CUSTOMER_ID|| ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE ) ;

Line 1223: oe_debug_pub.add( 'QTY='||G_QTY|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID|| ' CUST_ID='||G_CUSTOMER_ID|| ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE ) ;

1219: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||G_PRICING_DATE|| ' AGREEMENT_ID='||G_AGREEMENT_ID|| ' REQ DATE='||G_REQUEST_DATE|| ' SHIP_TO_ORG_ID='||G_SHIP_TO_ORG_ID|| ' INVOICE_TO_ORG_ID='||G_INVOICE_TO_ORG_ID ) ;
1220: END IF;
1221:
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'QTY='||G_QTY|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID|| ' CUST_ID='||G_CUSTOMER_ID|| ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE ) ;
1224: END IF;
1225: /*4163551*/
1226: IF l_debug_level > 0 THEN
1227: oe_debug_pub.add( ' 1 Related Items-Header_ID='||g_header_id);

Line 1227: oe_debug_pub.add( ' 1 Related Items-Header_ID='||g_header_id);

1223: oe_debug_pub.add( 'QTY='||G_QTY|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID|| ' CUST_ID='||G_CUSTOMER_ID|| ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE ) ;
1224: END IF;
1225: /*4163551*/
1226: IF l_debug_level > 0 THEN
1227: oe_debug_pub.add( ' 1 Related Items-Header_ID='||g_header_id);
1228: END IF;
1229: IF g_header_id is NOT NULL THEN
1230: OE_Header_Util.Query_Row
1231: ( p_header_id => g_header_id,

Line 1235: oe_debug_pub.add( ' Queried -Related Items-Header_ID='||g_header_id);

1231: ( p_header_id => g_header_id,
1232: x_header_rec =>l_header_rec
1233: );
1234: IF l_debug_level > 0 THEN
1235: oe_debug_pub.add( ' Queried -Related Items-Header_ID='||g_header_id);
1236: END IF;
1237: END IF;
1238:
1239: IF l_header_rec.header_id IS NOT NULL AND

Line 1243: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);

1239: IF l_header_rec.header_id IS NOT NULL AND
1240: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1241: oe_order_pub.g_hdr:=l_header_rec;
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1244: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1245: END IF;
1246: /*4163551*/
1247: ELSE

Line 1244: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);

1240: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1241: oe_order_pub.g_hdr:=l_header_rec;
1242: IF l_debug_level > 0 THEN
1243: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1244: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1245: END IF;
1246: /*4163551*/
1247: ELSE
1248: oe_order_pub.g_hdr.agreement_id := g_agreement_id;

Line 1296: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;

1292: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1293: );
1294:
1295: IF l_debug_level > 0 THEN
1296: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1297: END IF;
1298:
1299: EXCEPTION
1300: when no_data_found then

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

1314:
1315: i pls_integer;
1316:
1317: --
1318: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1319: --
1320: BEGIN
1321:
1322: IF l_debug_level > 0 THEN

Line 1323: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;

1319: --
1320: BEGIN
1321:
1322: IF l_debug_level > 0 THEN
1323: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;
1324: END IF;
1325:
1326: IF g_PRICING_ATTRIBUTE1 is not null then
1327: i := px_Req_line_attr_tbl.count+1;

Line 2232: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;

2228: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From:=g_PRICING_ATTRIBUTE100;
2229: end if;
2230:
2231: IF l_debug_level > 0 THEN
2232: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;
2233: END IF;
2234:
2235: END Append_attributes;
2236:

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

2372: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2373: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2374:
2375: --
2376: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2377: --
2378: BEGIN
2379: /*4163551*/
2380: oe_order_pub.g_hdr:=null;

Line 2586: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;

2582: IF l_debug_level > 0 THEN
2583: print_time('After Calling PE');
2584: END IF;
2585: IF l_debug_level > 0 THEN
2586: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
2587: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
2588: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
2589: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
2590: END IF;

Line 2587: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;

2583: print_time('After Calling PE');
2584: END IF;
2585: IF l_debug_level > 0 THEN
2586: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
2587: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
2588: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
2589: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
2590: END IF;
2591: if out_req_line_tbl.count > 0 then

Line 2588: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;

2584: END IF;
2585: IF l_debug_level > 0 THEN
2586: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
2587: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
2588: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
2589: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
2590: END IF;
2591: if out_req_line_tbl.count > 0 then
2592: for i in out_req_line_tbl.first..out_req_line_tbl.last

Line 2589: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;

2585: IF l_debug_level > 0 THEN
2586: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
2587: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
2588: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
2589: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
2590: END IF;
2591: if out_req_line_tbl.count > 0 then
2592: for i in out_req_line_tbl.first..out_req_line_tbl.last
2593: loop

Line 2595: oe_debug_pub.add( '*******************************' ) ;

2591: if out_req_line_tbl.count > 0 then
2592: for i in out_req_line_tbl.first..out_req_line_tbl.last
2593: loop
2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( '*******************************' ) ;
2596: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2597: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;

Line 2596: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;

2592: for i in out_req_line_tbl.first..out_req_line_tbl.last
2593: loop
2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( '*******************************' ) ;
2596: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2597: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;

Line 2597: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;

2593: loop
2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( '*******************************' ) ;
2596: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2597: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;

Line 2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;

2594: IF l_debug_level > 0 THEN
2595: oe_debug_pub.add( '*******************************' ) ;
2596: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2597: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;

Line 2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;

2595: oe_debug_pub.add( '*******************************' ) ;
2596: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2597: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;

Line 2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;

2596: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2597: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;

Line 2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;

2597: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;

Line 2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;

2598: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;

Line 2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;

2599: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;

Line 2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;

2600: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;

Line 2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;

2601: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;

Line 2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;

2602: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;

Line 2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;

2603: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;

Line 2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;

2604: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;

Line 2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;

2605: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;

Line 2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;

2606: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;

Line 2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;

2607: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;

Line 2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;

2608: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;

Line 2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;

2609: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;

Line 2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;

2610: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;

Line 2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;

2611: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;

Line 2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;

2612: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;

Line 2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;

2613: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2621: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;

Line 2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;

2614: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2621: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2622: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;

Line 2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;

2615: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2621: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2622: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2623: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;

Line 2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;

2616: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2621: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2622: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2623: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
2624: END IF;

Line 2621: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;

2617: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2621: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2622: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2623: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
2624: END IF;
2625: end loop;

Line 2622: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;

2618: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2621: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2622: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2623: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
2624: END IF;
2625: end loop;
2626: end if;

Line 2623: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;

2619: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2620: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2621: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2622: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2623: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
2624: END IF;
2625: end loop;
2626: end if;
2627:

Line 2629: oe_debug_pub.add( 'COUNT LINE DETAIL TABLE='||OUT_REQ_LINE_DETAIL_TBL.COUNT ) ;

2625: end loop;
2626: end if;
2627:
2628: IF l_debug_level > 0 THEN
2629: oe_debug_pub.add( 'COUNT LINE DETAIL TABLE='||OUT_REQ_LINE_DETAIL_TBL.COUNT ) ;
2630: END IF;
2631: if out_req_line_detail_tbl.count > 0 then
2632: for i in out_req_line_detail_tbl.first..out_req_line_detail_tbl.last
2633: loop

Line 2635: oe_debug_pub.add( 'LINE DETAIL TABLE RECORD='||I ) ;

2631: if out_req_line_detail_tbl.count > 0 then
2632: for i in out_req_line_detail_tbl.first..out_req_line_detail_tbl.last
2633: loop
2634: IF l_debug_level > 0 THEN
2635: oe_debug_pub.add( 'LINE DETAIL TABLE RECORD='||I ) ;
2636: END IF;
2637: if out_req_line_detail_tbl.exists(i) then
2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( '*******************************' ) ;

Line 2639: oe_debug_pub.add( '*******************************' ) ;

2635: oe_debug_pub.add( 'LINE DETAIL TABLE RECORD='||I ) ;
2636: END IF;
2637: if out_req_line_detail_tbl.exists(i) then
2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( '*******************************' ) ;
2640: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2641: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;

Line 2640: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;

2636: END IF;
2637: if out_req_line_detail_tbl.exists(i) then
2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( '*******************************' ) ;
2640: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2641: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;

Line 2641: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;

2637: if out_req_line_detail_tbl.exists(i) then
2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( '*******************************' ) ;
2640: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2641: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;

Line 2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;

2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( '*******************************' ) ;
2640: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2641: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;

Line 2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;

2639: oe_debug_pub.add( '*******************************' ) ;
2640: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2641: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;

Line 2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;

2640: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2641: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;

Line 2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;

2641: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;

Line 2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;

2642: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;

Line 2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;

2643: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;

Line 2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;

2644: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;

Line 2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;

2645: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2653: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;

Line 2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;

2646: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2653: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2654: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;

Line 2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;

2647: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2653: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2654: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2655: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;

Line 2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;

2648: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2653: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2654: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2655: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
2656: END IF;

Line 2653: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;

2649: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2653: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2654: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2655: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
2656: END IF;
2657: end if;

Line 2654: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;

2650: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2653: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2654: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2655: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
2656: END IF;
2657: end if;
2658:

Line 2655: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;

2651: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2652: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2653: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2654: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2655: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
2656: END IF;
2657: end if;
2658:
2659: end loop;

Line 2664: oe_debug_pub.add( 'COUNT LINE DETAIL ATTR TBL='|| OUT_REQ_LINE_DETAIL_ATTR_TBL.COUNT ) ;

2660: end if;
2661:
2662:
2663: IF l_debug_level > 0 THEN
2664: oe_debug_pub.add( 'COUNT LINE DETAIL ATTR TBL='|| OUT_REQ_LINE_DETAIL_ATTR_TBL.COUNT ) ;
2665: END IF;
2666: if out_req_line_detail_attr_tbl.count > 0 then
2667: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
2668: loop

Line 2670: oe_debug_pub.add( '*******************************' ) ;

2666: if out_req_line_detail_attr_tbl.count > 0 then
2667: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
2668: loop
2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( '*******************************' ) ;
2671: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2672: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2673: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2674: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

Line 2671: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;

2667: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
2668: loop
2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( '*******************************' ) ;
2671: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2672: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2673: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2674: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2675: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

Line 2672: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;

2668: loop
2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( '*******************************' ) ;
2671: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2672: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2673: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2674: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2675: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2676: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

Line 2673: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;

2669: IF l_debug_level > 0 THEN
2670: oe_debug_pub.add( '*******************************' ) ;
2671: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2672: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2673: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2674: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2675: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2676: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2677: END IF;

Line 2674: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

2670: oe_debug_pub.add( '*******************************' ) ;
2671: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2672: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2673: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2674: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2675: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2676: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2677: END IF;
2678:

Line 2675: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

2671: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2672: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2673: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2674: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2675: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2676: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2677: END IF;
2678:
2679: end loop;

Line 2676: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

2672: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2673: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2674: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2675: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2676: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2677: END IF;
2678:
2679: end loop;
2680: end if;

Line 2684: oe_debug_pub.add( 'COUNT LINE ATTR TBL='||OUT_REQ_LINE_ATTR_TBL.COUNT ) ;

2680: end if;
2681:
2682:
2683: IF l_debug_level > 0 THEN
2684: oe_debug_pub.add( 'COUNT LINE ATTR TBL='||OUT_REQ_LINE_ATTR_TBL.COUNT ) ;
2685: END IF;
2686: if out_req_line_attr_tbl.count > 0 then
2687: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
2688: loop

Line 2690: oe_debug_pub.add( '*******************************' ) ;

2686: if out_req_line_attr_tbl.count > 0 then
2687: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
2688: loop
2689: IF l_debug_level > 0 THEN
2690: oe_debug_pub.add( '*******************************' ) ;
2691: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2692: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2693: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2694: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

Line 2691: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;

2687: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
2688: loop
2689: IF l_debug_level > 0 THEN
2690: oe_debug_pub.add( '*******************************' ) ;
2691: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2692: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2693: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2694: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2695: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

Line 2692: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;

2688: loop
2689: IF l_debug_level > 0 THEN
2690: oe_debug_pub.add( '*******************************' ) ;
2691: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2692: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2693: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2694: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2695: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2696: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

Line 2693: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;

2689: IF l_debug_level > 0 THEN
2690: oe_debug_pub.add( '*******************************' ) ;
2691: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2692: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2693: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2694: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2695: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2696: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2697: END IF;

Line 2694: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

2690: oe_debug_pub.add( '*******************************' ) ;
2691: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2692: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2693: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2694: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2695: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2696: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2697: END IF;
2698:

Line 2695: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

2691: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2692: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2693: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2694: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2695: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2696: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2697: END IF;
2698:
2699: end loop;

Line 2696: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

2692: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2693: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2694: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2695: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2696: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2697: END IF;
2698:
2699: end loop;
2700: end if;

Line 2704: oe_debug_pub.add( 'COUNT RELATED LINES TBL='|| OUT_REQ_RELATED_LINES_TBL.COUNT ) ;

2700: end if;
2701:
2702:
2703: IF l_debug_level > 0 THEN
2704: oe_debug_pub.add( 'COUNT RELATED LINES TBL='|| OUT_REQ_RELATED_LINES_TBL.COUNT ) ;
2705: END IF;
2706: if out_req_related_lines_tbl.count > 0 then
2707: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
2708: loop

Line 2710: oe_debug_pub.add( '*******************************' ) ;

2706: if out_req_related_lines_tbl.count > 0 then
2707: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
2708: loop
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add( '*******************************' ) ;
2711: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2712: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2713: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2714: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;

Line 2711: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;

2707: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
2708: loop
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add( '*******************************' ) ;
2711: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2712: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2713: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2714: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2715: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;

Line 2712: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;

2708: loop
2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add( '*******************************' ) ;
2711: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2712: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2713: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2714: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2715: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2716: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;

Line 2713: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;

2709: IF l_debug_level > 0 THEN
2710: oe_debug_pub.add( '*******************************' ) ;
2711: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2712: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2713: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2714: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2715: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2716: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
2717: END IF;

Line 2714: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;

2710: oe_debug_pub.add( '*******************************' ) ;
2711: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2712: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2713: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2714: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2715: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2716: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
2717: END IF;
2718:

Line 2715: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;

2711: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2712: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2713: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2714: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2715: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2716: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
2717: END IF;
2718:
2719: end loop;

Line 2716: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;

2712: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2713: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2714: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2715: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2716: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
2717: END IF;
2718:
2719: end loop;
2720: end if;

Line 2724: oe_debug_pub.add( 'COUNT LINE QUAL TBL='||OUT_REQ_QUAL_TBL.COUNT ) ;

2720: end if;
2721:
2722:
2723: IF l_debug_level > 0 THEN
2724: oe_debug_pub.add( 'COUNT LINE QUAL TBL='||OUT_REQ_QUAL_TBL.COUNT ) ;
2725: END IF;
2726: if out_req_qual_tbl.count > 0 then
2727: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
2728: loop

Line 2730: oe_debug_pub.add( '*******************************' ) ;

2726: if out_req_qual_tbl.count > 0 then
2727: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
2728: loop
2729: IF l_debug_level > 0 THEN
2730: oe_debug_pub.add( '*******************************' ) ;
2731: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2732: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

Line 2731: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;

2727: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
2728: loop
2729: IF l_debug_level > 0 THEN
2730: oe_debug_pub.add( '*******************************' ) ;
2731: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2732: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

Line 2732: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;

2728: loop
2729: IF l_debug_level > 0 THEN
2730: oe_debug_pub.add( '*******************************' ) ;
2731: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2732: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2736: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

Line 2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;

2729: IF l_debug_level > 0 THEN
2730: oe_debug_pub.add( '*******************************' ) ;
2731: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2732: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2736: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2737: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

Line 2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

2730: oe_debug_pub.add( '*******************************' ) ;
2731: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2732: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2736: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2737: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2738: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

Line 2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

2731: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2732: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2736: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2737: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2738: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2739: END IF;

Line 2736: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

2732: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2736: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2737: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2738: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2739: END IF;
2740:

Line 2737: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

2733: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2736: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2737: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2738: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2739: END IF;
2740:
2741: end loop;

Line 2738: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

2734: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2735: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2736: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2737: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2738: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2739: END IF;
2740:
2741: end loop;
2742: end if;

Line 2746: oe_debug_pub.add( 'COUNT LINE DETAIL QUAL TBL='|| OUT_REQ_LINE_DETAIL_QUAL_TBL.COUNT ) ;

2742: end if;
2743:
2744:
2745: IF l_debug_level > 0 THEN
2746: oe_debug_pub.add( 'COUNT LINE DETAIL QUAL TBL='|| OUT_REQ_LINE_DETAIL_QUAL_TBL.COUNT ) ;
2747: END IF;
2748: if out_req_line_detail_qual_tbl.count > 0 then
2749: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
2750: loop

Line 2752: oe_debug_pub.add( '*******************************' ) ;

2748: if out_req_line_detail_qual_tbl.count > 0 then
2749: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
2750: loop
2751: IF l_debug_level > 0 THEN
2752: oe_debug_pub.add( '*******************************' ) ;
2753: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2754: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

Line 2753: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;

2749: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
2750: loop
2751: IF l_debug_level > 0 THEN
2752: oe_debug_pub.add( '*******************************' ) ;
2753: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2754: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

Line 2754: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;

2750: loop
2751: IF l_debug_level > 0 THEN
2752: oe_debug_pub.add( '*******************************' ) ;
2753: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2754: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2758: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

Line 2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;

2751: IF l_debug_level > 0 THEN
2752: oe_debug_pub.add( '*******************************' ) ;
2753: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2754: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2758: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2759: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

Line 2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

2752: oe_debug_pub.add( '*******************************' ) ;
2753: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2754: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2758: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2759: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2760: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

Line 2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

2753: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2754: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2758: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2759: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2760: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2761: END IF;

Line 2758: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

2754: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2758: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2759: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2760: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2761: END IF;
2762:

Line 2759: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

2755: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2758: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2759: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2760: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2761: END IF;
2762:
2763: end loop;

Line 2760: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

2756: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2757: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2758: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2759: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2760: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2761: END IF;
2762:
2763: end loop;
2764: end if;

Line 2768: oe_debug_pub.add( ' EXITING PRICE_ITEM*******************************' ) ;

2764: end if;
2765:
2766:
2767: IF l_debug_level > 0 THEN
2768: oe_debug_pub.add( ' EXITING PRICE_ITEM*******************************' ) ;
2769: END IF;
2770:
2771: EXCEPTION
2772: when others then

Line 2775: oe_debug_pub.add( 'PRICE ITEM EXCEPTION WHEN OTHERS CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;

2771: EXCEPTION
2772: when others then
2773:
2774: IF l_debug_level > 0 THEN
2775: oe_debug_pub.add( 'PRICE ITEM EXCEPTION WHEN OTHERS CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
2776: END IF;
2777:
2778: END price_item;
2779:

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

2895: in_pricing_attribute100 in varchar2
2896: ) IS
2897:
2898: --
2899: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2900: --
2901: BEGIN
2902:
2903: g_related_item_id := in_related_item_id;

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

3068: l_operand number;
3069: l_msg_text Varchar2(2000);
3070:
3071: --
3072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3073: --
3074: BEGIN
3075:
3076: IF l_debug_level > 0 THEN

Line 3077: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;

3073: --
3074: BEGIN
3075:
3076: IF l_debug_level > 0 THEN
3077: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;
3078: END IF;
3079: IF l_debug_level > 0 THEN
3080: oe_debug_pub.add( 'LINE_TYPE_CODE='||IN_LINE_TYPE_CODE|| ' STATUS CODE='||IN_STATUS_CODE|| ' NEGATIVE PRICE ='||L_ALLOW_NEGATIVE_PRICE|| ' IN_UNIT_PRICE ='||IN_UNIT_PRICE|| ' IN_ADJUSTED_UNIT_PRICE ='||IN_ADJUSTED_UNIT_PRICE ) ;
3081: END IF;

Line 3080: oe_debug_pub.add( 'LINE_TYPE_CODE='||IN_LINE_TYPE_CODE|| ' STATUS CODE='||IN_STATUS_CODE|| ' NEGATIVE PRICE ='||L_ALLOW_NEGATIVE_PRICE|| ' IN_UNIT_PRICE ='||IN_UNIT_PRICE|| ' IN_ADJUSTED_UNIT_PRICE ='||IN_ADJUSTED_UNIT_PRICE ) ;

3076: IF l_debug_level > 0 THEN
3077: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;
3078: END IF;
3079: IF l_debug_level > 0 THEN
3080: oe_debug_pub.add( 'LINE_TYPE_CODE='||IN_LINE_TYPE_CODE|| ' STATUS CODE='||IN_STATUS_CODE|| ' NEGATIVE PRICE ='||L_ALLOW_NEGATIVE_PRICE|| ' IN_UNIT_PRICE ='||IN_UNIT_PRICE|| ' IN_ADJUSTED_UNIT_PRICE ='||IN_ADJUSTED_UNIT_PRICE ) ;
3081: END IF;
3082:
3083:
3084: IF in_line_Type_code ='LINE' and

Line 3115: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID ) ;

3111:
3112: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
3113:
3114: IF l_debug_level > 0 THEN
3115: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID ) ;
3116: END IF;
3117: IF g_price_list_id is null then
3118:
3119: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');

Line 3122: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;

3118:
3119: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
3120: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3121: IF l_debug_level > 0 THEN
3122: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3123: END IF;
3124: OE_MSG_PUB.Add;
3125:
3126: ELSE

Line 3128: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;

3124: OE_MSG_PUB.Add;
3125:
3126: ELSE
3127: IF l_debug_level > 0 THEN
3128: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3129: END IF;
3130: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3131: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3132: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);

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

3162: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3163: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3164:
3165: IF l_debug_level > 0 THEN
3166: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3167: END IF;
3168: Begin
3169: Select name into l_price_list
3170: from qp_list_headers_vl a,qp_list_lines b where

Line 3183: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;

3179: instr(in_status_text,',')-1);
3180: End;
3181:
3182: IF l_debug_level > 0 THEN
3183: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
3184: END IF;
3185: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3186: Begin
3187: Select name into l_price_list

Line 3200: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;

3196: l_price_list := substr(in_status_text,
3197: instr(in_status_text,',')+1);
3198: End;
3199: IF l_debug_level > 0 THEN
3200: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3201: END IF;
3202:
3203: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3204: OE_MSG_PUB.Add;

Line 3229: oe_debug_pub.add('Error as Negative Pricing is not Allowed');

3225:
3226: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and
3227: l_allow_negative_price = 'N' then
3228:
3229: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
3230: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3231: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3232: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3233: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);

Line 3245: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;

3241: ELSIF in_line_Type_code ='LINE' and
3242: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
3243:
3244: IF l_debug_level > 0 THEN
3245: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
3246: END IF;
3247: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
3248: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
3249: OE_MSG_PUB.Add;

Line 3262: oe_debug_pub.add( 'OE_PRICING_ERROR 2' ) ;

3258: --engine doesn't look at the line and will not return adjustments. In this
3259: --case we DON't want to remove the adjustments that engine doesn't return.
3260: then
3261: IF l_debug_level > 0 THEN
3262: oe_debug_pub.add( 'OE_PRICING_ERROR 2' ) ;
3263: END IF;
3264:
3265: IF in_status_text is not null then
3266: l_return_status := 'E';

Line 3280: oe_debug_pub.add('After select OE_PRICING_ERROR 2');

3276: /*OPEN get_gsa_list_lines;
3277: FETCH get_gsa_list_lines
3278: INTO l_operand;
3279: CLOSE get_gsa_list_lines;
3280: oe_debug_pub.add('After select OE_PRICING_ERROR 2');
3281: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
3282: ' Operand='||l_operand);
3283:
3284: IF in_adjusted_unit_price <= l_operand then

Line 3281: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||

3277: FETCH get_gsa_list_lines
3278: INTO l_operand;
3279: CLOSE get_gsa_list_lines;
3280: oe_debug_pub.add('After select OE_PRICING_ERROR 2');
3281: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
3282: ' Operand='||l_operand);
3283:
3284: IF in_adjusted_unit_price <= l_operand then
3285: oe_debug_pub.add('If unit price less than operand violation='||

Line 3285: oe_debug_pub.add('If unit price less than operand violation='||

3281: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
3282: ' Operand='||l_operand);
3283:
3284: IF in_adjusted_unit_price <= l_operand then
3285: oe_debug_pub.add('If unit price less than operand violation='||
3286: l_gsa_violation_action);
3287: --Check if the GSA check needs to be done.
3288: If l_gsa_violation_action in ('WARNING','ERROR') then
3289:

Line 3290: oe_debug_pub.add('GSA warning or error');

3286: l_gsa_violation_action);
3287: --Check if the GSA check needs to be done.
3288: If l_gsa_violation_action in ('WARNING','ERROR') then
3289:
3290: oe_debug_pub.add('GSA warning or error');
3291: Begin
3292: SELECT concatenated_segments
3293: INTO l_msg_text
3294: FROM mtl_system_items_kfv

Line 3303: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);

3299: Null;
3300: End;
3301:
3302: l_return_status := 'E';
3303: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
3304: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
3305: l_msg_text := l_operand||' ( '||l_msg_text||' )';
3306: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
3307: OE_MSG_PUB.Add;

Line 3323: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;

3319: --need to be pulled out by append_adjustment_lines routine
3320: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
3321: Then
3322: IF l_debug_level > 0 THEN
3323: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
3324: END IF;
3325: null;
3326:
3327: ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then

Line 3330: oe_debug_pub.add( 'STATUS = UPDATED' ) ;

3326:
3327: ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then
3328:
3329: IF l_debug_level > 0 THEN
3330: oe_debug_pub.add( 'STATUS = UPDATED' ) ;
3331: END IF;
3332:
3333: END IF;-- Status_Code
3334:

Line 3337: oe_debug_pub.add( 'PROCESS PRICING ERROR AFTER ERR CHK ST='||L_RETURN_STATUS ) ;

3333: END IF;-- Status_Code
3334:
3335:
3336: IF l_debug_level > 0 THEN
3337: oe_debug_pub.add( 'PROCESS PRICING ERROR AFTER ERR CHK ST='||L_RETURN_STATUS ) ;
3338: END IF;
3339:
3340: IF l_return_status ='E' then
3341: IF l_debug_level > 0 THEN

Line 3342: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;

3338: END IF;
3339:
3340: IF l_return_status ='E' then
3341: IF l_debug_level > 0 THEN
3342: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
3343: END IF;
3344: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
3345: p_count => l_msg_count,
3346: p_data=>l_msg_data

Line 3351: oe_debug_pub.add( 'EXITING PROCESS_PRICING_ERRORS' ) ;

3347: );
3348: END IF;
3349:
3350: IF l_debug_level > 0 THEN
3351: oe_debug_pub.add( 'EXITING PROCESS_PRICING_ERRORS' ) ;
3352: END IF;
3353:
3354: EXCEPTION
3355:

Line 3358: oe_debug_pub.add( 'PROCESS PRICING ERRORS WHEN OTHERS EXCEPTION CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;

3354: EXCEPTION
3355:
3356: when others then
3357: IF l_debug_level > 0 THEN
3358: oe_debug_pub.add( 'PROCESS PRICING ERRORS WHEN OTHERS EXCEPTION CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
3359: END IF;
3360:
3361: END process_pricing_errors;
3362: FUNCTION Get_Rounding_factor(p_list_header_id number) return number is

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

3363:
3364: l_rounding_factor number;
3365:
3366: --
3367: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3368: --
3369: BEGIN
3370:
3371: select rounding_factor

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

3399: out_freight_terms_code out NOCOPY /* file.sql.39 change */ varchar2
3400: ) IS
3401:
3402: --
3403: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3404: --
3405: BEGIN
3406:
3407: IF l_debug_level > 0 THEN

Line 3408: oe_debug_pub.add( 'GET PRICE_LIST ID='||P_PRICE_LIST_ID ) ;

3404: --
3405: BEGIN
3406:
3407: IF l_debug_level > 0 THEN
3408: oe_debug_pub.add( 'GET PRICE_LIST ID='||P_PRICE_LIST_ID ) ;
3409: END IF;
3410:
3411: IF p_price_list_id IS NOT NULL THEN
3412:

Line 3439: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;

3435:
3436: END IF;
3437:
3438: IF l_debug_level > 0 THEN
3439: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
3440: END IF;
3441:
3442: EXCEPTION
3443:

Line 3446: oe_debug_pub.add( 'NO DATA FOUND GET PRICE LIST_INFO' ) ;

3442: EXCEPTION
3443:
3444: WHEN NO_DATA_FOUND THEN
3445: IF l_debug_level > 0 THEN
3446: oe_debug_pub.add( 'NO DATA FOUND GET PRICE LIST_INFO' ) ;
3447: END IF;
3448:
3449: WHEN OTHERS THEN
3450: IF l_debug_level > 0 THEN

Line 3451: oe_debug_pub.add( 'WHEN OTHERS GET PRICE LIST_INFO'|| SQLCODE||SQLERRM ) ;

3447: END IF;
3448:
3449: WHEN OTHERS THEN
3450: IF l_debug_level > 0 THEN
3451: oe_debug_pub.add( 'WHEN OTHERS GET PRICE LIST_INFO'|| SQLCODE||SQLERRM ) ;
3452: END IF;
3453:
3454: END get_Price_List_info;
3455:

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

3484: l_ordered_conversion number;
3485: l_pricing_conversion number;
3486:
3487: --
3488: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3489: --
3490: BEGIN
3491:
3492: IF l_debug_level > 0 THEN

Line 3493: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.DIFFERENT_UOM'|| ' ORDERED_UOM ='||IN_ORDERED_UOM|| ' PRICING_UOM='||IN_PRICING_UOM|| ' IN_INV_ITEM_ID='||G_INVENTORY_ITEM_ID|| ' IN_ORG_ID='||IN_ORG_ID ) ;

3489: --
3490: BEGIN
3491:
3492: IF l_debug_level > 0 THEN
3493: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.DIFFERENT_UOM'|| ' ORDERED_UOM ='||IN_ORDERED_UOM|| ' PRICING_UOM='||IN_PRICING_UOM|| ' IN_INV_ITEM_ID='||G_INVENTORY_ITEM_ID|| ' IN_ORG_ID='||IN_ORG_ID ) ;
3494: END IF;
3495:
3496: OPEN c_items;
3497: FETCH c_items

Line 3519: oe_debug_pub.add( 'NEITHER THE ORDERED OR PRICING UOM IS BASE UOM' ) ;

3515: IF in_ordered_uom <> l_base_uom AND
3516: in_pricing_uom <> l_base_uom THEN
3517:
3518: IF l_debug_level > 0 THEN
3519: oe_debug_pub.add( 'NEITHER THE ORDERED OR PRICING UOM IS BASE UOM' ) ;
3520: END IF;
3521:
3522: l_ordered_conversion := get_conversion_rate(
3523: in_uom_code => in_ordered_uom,

Line 3527: oe_debug_pub.add( 'THE ORD RATE ='||L_ORDERED_CONVERSION ) ;

3523: in_uom_code => in_ordered_uom,
3524: in_base_uom => l_base_uom
3525: );
3526: IF l_debug_level > 0 THEN
3527: oe_debug_pub.add( 'THE ORD RATE ='||L_ORDERED_CONVERSION ) ;
3528: END IF;
3529: l_pricing_conversion := get_conversion_rate(
3530: in_uom_code => in_pricing_uom,
3531: in_base_uom => l_base_uom

Line 3534: oe_debug_pub.add( 'THE PRICING RATE ='||L_PRICING_CONVERSION ) ;

3530: in_uom_code => in_pricing_uom,
3531: in_base_uom => l_base_uom
3532: );
3533: IF l_debug_level > 0 THEN
3534: oe_debug_pub.add( 'THE PRICING RATE ='||L_PRICING_CONVERSION ) ;
3535: END IF;
3536:
3537: out_conversion_rate := l_ordered_conversion/l_pricing_conversion;
3538: IF l_debug_level > 0 THEN

Line 3539: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;

3535: END IF;
3536:
3537: out_conversion_rate := l_ordered_conversion/l_pricing_conversion;
3538: IF l_debug_level > 0 THEN
3539: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
3540: END IF;
3541:
3542: -- Ordered Uom is the Base Uom,sending the pricing uom for conversion
3543: ELSIF in_ordered_uom = l_base_uom then

Line 3546: oe_debug_pub.add( 'THE ORDERED UOM IS BASE UOM' ) ;

3542: -- Ordered Uom is the Base Uom,sending the pricing uom for conversion
3543: ELSIF in_ordered_uom = l_base_uom then
3544:
3545: IF l_debug_level > 0 THEN
3546: oe_debug_pub.add( 'THE ORDERED UOM IS BASE UOM' ) ;
3547: END IF;
3548:
3549: l_ordered_conversion := get_conversion_rate(
3550: in_uom_code => in_pricing_uom,

Line 3555: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;

3551: in_base_uom => l_base_uom
3552: );
3553: out_conversion_rate := l_ordered_conversion;
3554: IF l_debug_level > 0 THEN
3555: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
3556: END IF;
3557:
3558: -- Pricing Uom is the Base Uom
3559: ELSIF in_pricing_uom = l_base_uom then

Line 3562: oe_debug_pub.add( 'THE PRICING UOM IS BASE UOM' ) ;

3558: -- Pricing Uom is the Base Uom
3559: ELSIF in_pricing_uom = l_base_uom then
3560:
3561: IF l_debug_level > 0 THEN
3562: oe_debug_pub.add( 'THE PRICING UOM IS BASE UOM' ) ;
3563: END IF;
3564: l_pricing_conversion := get_conversion_rate(
3565: in_uom_code => in_ordered_uom,
3566: in_base_uom => l_base_uom

Line 3570: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;

3566: in_base_uom => l_base_uom
3567: );
3568: out_conversion_rate := l_pricing_conversion;
3569: IF l_debug_level > 0 THEN
3570: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
3571: END IF;
3572:
3573: END IF;
3574:

Line 3590: oe_debug_pub.add( 'NO DATA FONUNG DIFFERENT_UOM ' ) ;

3586: EXCEPTION
3587:
3588: WHEN NO_DATA_FOUND THEN
3589: IF l_debug_level > 0 THEN
3590: oe_debug_pub.add( 'NO DATA FONUNG DIFFERENT_UOM ' ) ;
3591: END IF;
3592:
3593: WHEN OTHERS THEN
3594: IF c_items%ISOPEN then

Line 3604: oe_debug_pub.add( 'ERROR IN DIFFERENT_UOM '|| SQLCODE||SQLERRM ) ;

3600: IF c_base_uom%ISOPEN then
3601: CLOSE c_base_uom;
3602: END IF;
3603: IF l_debug_level > 0 THEN
3604: oe_debug_pub.add( 'ERROR IN DIFFERENT_UOM '|| SQLCODE||SQLERRM ) ;
3605: END IF;
3606:
3607: END different_uom;
3608:

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

3635: l_conversion_rate number;
3636: l_uom_code varchar2(50);
3637:
3638: --
3639: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3640: --
3641: BEGIN
3642:
3643: IF l_debug_level > 0 THEN

Line 3644: oe_debug_pub.add( 'INSIDE GET_CONVERSION_RATE '|| ' IN_UOM_CODE='||IN_UOM_CODE|| ' IN_BASE_UOM='||IN_BASE_UOM ) ;

3640: --
3641: BEGIN
3642:
3643: IF l_debug_level > 0 THEN
3644: oe_debug_pub.add( 'INSIDE GET_CONVERSION_RATE '|| ' IN_UOM_CODE='||IN_UOM_CODE|| ' IN_BASE_UOM='||IN_BASE_UOM ) ;
3645: END IF;
3646:
3647: OPEN c_item_conversion;
3648: FETCH c_item_conversion

Line 3654: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE NOT FOUND' ) ;

3650:
3651: IF c_item_conversion%NOTFOUND THEN
3652:
3653: IF l_debug_level > 0 THEN
3654: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE NOT FOUND' ) ;
3655: END IF;
3656:
3657: OPEN c_conversion;
3658: FETCH c_conversion

Line 3664: oe_debug_pub.add( 'GENERIC CONVERSION NOT FOUND' ) ;

3660:
3661: IF c_conversion%NOTFOUND THEN
3662:
3663: IF l_debug_level > 0 THEN
3664: oe_debug_pub.add( 'GENERIC CONVERSION NOT FOUND' ) ;
3665: END IF;
3666: OPEN c_inter_class;
3667: FETCH c_inter_class
3668: INTO l_conversion_rate;

Line 3672: oe_debug_pub.add( 'INTER CLASS RETURN RATE NOT FOUND= 1' ) ;

3668: INTO l_conversion_rate;
3669:
3670: IF c_inter_class%NOTFOUND THEN
3671: IF l_debug_level > 0 THEN
3672: oe_debug_pub.add( 'INTER CLASS RETURN RATE NOT FOUND= 1' ) ;
3673: END IF;
3674: l_conversion_rate := 1;
3675:
3676: ELSE

Line 3678: oe_debug_pub.add( 'INTER CLASS RETURN RATE = '||L_CONVERSION_RATE ) ;

3674: l_conversion_rate := 1;
3675:
3676: ELSE
3677: IF l_debug_level > 0 THEN
3678: oe_debug_pub.add( 'INTER CLASS RETURN RATE = '||L_CONVERSION_RATE ) ;
3679: END IF;
3680:
3681: END IF;
3682: CLOSE c_inter_class;

Line 3687: oe_debug_pub.add( 'RETURN RATE GENERIC= '||L_CONVERSION_RATE ) ;

3683:
3684: ELSIF c_conversion%FOUND then
3685:
3686: IF l_debug_level > 0 THEN
3687: oe_debug_pub.add( 'RETURN RATE GENERIC= '||L_CONVERSION_RATE ) ;
3688: END IF;
3689:
3690: END IF;
3691: CLOSE c_conversion;

Line 3696: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE='||L_CONVERSION_RATE ) ;

3692:
3693: ELSIF c_item_conversion%FOUND THEN
3694:
3695: IF l_debug_level > 0 THEN
3696: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE='||L_CONVERSION_RATE ) ;
3697: END IF;
3698:
3699: END IF;
3700: CLOSE c_item_conversion;

Line 3708: oe_debug_pub.add( 'DIVIDE BY ZERO ERROR IN_UOM_CODE='||IN_UOM_CODE|| ' BASE UOM='||IN_BASE_UOM ) ;

3704: EXCEPTION
3705:
3706: WHEN ZERO_DIVIDE THEN
3707: IF l_debug_level > 0 THEN
3708: oe_debug_pub.add( 'DIVIDE BY ZERO ERROR IN_UOM_CODE='||IN_UOM_CODE|| ' BASE UOM='||IN_BASE_UOM ) ;
3709: END IF;
3710:
3711: IF c_item_conversion%ISOPEN then
3712: CLOSE c_item_conversion;

Line 3733: oe_debug_pub.add( 'ERROR IN GET_CONVERSION_RATE '|| SQLCODE||SQLERRM ) ;

3729: IF c_inter_class%ISOPEN then
3730: CLOSE c_inter_class;
3731: END IF;
3732: IF l_debug_level > 0 THEN
3733: oe_debug_pub.add( 'ERROR IN GET_CONVERSION_RATE '|| SQLCODE||SQLERRM ) ;
3734: END IF;
3735: return 1;
3736: END get_conversion_rate;
3737: PROCEDURE print_time(in_place in varchar2) IS

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

3743: l_hsecs number;
3744: l_total number;
3745:
3746: --
3747: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3748: --
3749: BEGIN
3750:
3751: --print_time2;

Line 3762: oe_debug_pub.add( 'TIME STARTING AT PLACE '||G_PLACE||' TIME='||G_HSECS ) ;

3758:
3759: g_hsecs := l_hsecs;
3760: g_place := in_place;
3761: IF l_debug_level > 0 THEN
3762: oe_debug_pub.add( 'TIME STARTING AT PLACE '||G_PLACE||' TIME='||G_HSECS ) ;
3763: END IF;
3764:
3765: ELSE
3766: l_total := (l_hsecs - g_hsecs)/100;

Line 3769: oe_debug_pub.add( 'TIME FROM ' ||G_PLACE||' TO '||IN_PLACE||' TIME DIFF='|| L_TOTAL||' SECONDS'||' TOTAL SO FAR='||G_TOTAL ) ;

3765: ELSE
3766: l_total := (l_hsecs - g_hsecs)/100;
3767: g_total := g_total + l_total;
3768: IF l_debug_level > 0 THEN
3769: oe_debug_pub.add( 'TIME FROM ' ||G_PLACE||' TO '||IN_PLACE||' TIME DIFF='|| L_TOTAL||' SECONDS'||' TOTAL SO FAR='||G_TOTAL ) ;
3770: END IF;
3771: g_hsecs := l_hsecs;
3772: g_place := in_place;
3773:

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

3786: l_hsecs number;
3787: l_total number;
3788:
3789: --
3790: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3791: --
3792: BEGIN
3793:
3794: OPEN c2_hsecs;

Line 3801: oe_debug_pub.add( 'G_TOTAL2 IS NULL L_HSECS='||L_HSECS ) ;

3797: CLOSE c2_hsecs;
3798:
3799: IF g_total2 is null then
3800: IF l_debug_level > 0 THEN
3801: oe_debug_pub.add( 'G_TOTAL2 IS NULL L_HSECS='||L_HSECS ) ;
3802: END IF;
3803: g_total2 := l_hsecs;
3804: ELSE
3805: IF l_debug_level > 0 THEN

Line 3806: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;

3802: END IF;
3803: g_total2 := l_hsecs;
3804: ELSE
3805: IF l_debug_level > 0 THEN
3806: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;
3807: END IF;
3808: l_total := (l_hsecs - g_total2)/100;
3809: IF l_debug_level > 0 THEN
3810: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;

Line 3810: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;

3806: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;
3807: END IF;
3808: l_total := (l_hsecs - g_total2)/100;
3809: IF l_debug_level > 0 THEN
3810: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;
3811: END IF;
3812: g_total2 := l_hsecs;
3813: END IF;
3814: