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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

373: l_mrp_calc_sd VARCHAR2(240);--bug14222176
374:
375:
376: --
377: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
378: --
379: BEGIN
380:
381: IF l_debug_level > 0 THEN

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

378: --
379: BEGIN
380:
381: IF l_debug_level > 0 THEN
382: oe_debug_pub.add( 'ENTERING CALL ATP' ) ;
383: END IF;
384:
385: Initialize_mrp_record
386: ( p_x_atp_rec => l_atp_rec

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

387: ,l_count =>1 );
388:
389:
390: IF l_debug_level > 0 THEN
391: oe_debug_pub.add( 'INVENTORY_ITEM_ID='||P_RELATED_ITEM_ID||
392: ' SHIP_FORM_ORG_ID='||P_SHIP_FROM_ORG_ID|| ' P_GLOBAL_ORGS='||
393: P_GLOBAL_ORGS|| ' CUST_ID='||P_CUST_ACCOUNT_ID|| ' SHIP_TO_ORG_ID='||
394: P_SHIP_TO_ORG_ID||' QTY='||P_ORDERED_QTY|| ' UOM='||P_RELATED_UOM||' REQ DATE='||P_REQUEST_DATE ) ;
395: END IF;

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

404: l_atp_rec.Source_Organization_Id(1) := g_ship_from_org_id;
405: END IF;
406: */
407: IF l_debug_level > 0 THEN
408: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;
409: END IF;
410:
411: l_atp_rec.Source_Organization_Id(1) := p_ship_from_org_id;
412: l_atp_rec.Identifier(I) := g_atp_line_id;

Line 426: oe_debug_pub.add('date type code is ship:'||p_date_type_code);

422: -- 13686470
423: if p_date_type_code is null or p_date_type_code = 'SHIP' then
424:
425: if l_debug_level > 0 then
426: oe_debug_pub.add('date type code is ship:'||p_date_type_code);
427: end if ;
428: l_atp_rec.Requested_Ship_Date(I) := p_request_date;
429: elsif p_date_type_code='ARRIVAL' then
430:

Line 432: oe_debug_pub.add('date type code is arrival:'||p_date_type_code);

428: l_atp_rec.Requested_Ship_Date(I) := p_request_date;
429: elsif p_date_type_code='ARRIVAL' then
430:
431: if l_debug_level > 0 then
432: oe_debug_pub.add('date type code is arrival:'||p_date_type_code);
433: end if ;
434:
435: l_atp_rec.Requested_arrival_Date(I) := p_request_date;
436: end if ;

Line 462: oe_debug_pub.add('in OEXFRELB, MRP_ATP_CALC_SD profile set to yes ' );

458:
459: --bug14222176
460: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');
461: IF nvl(l_mrp_calc_sd,'N') = 'Y' THEN
462: oe_debug_pub.add('in OEXFRELB, MRP_ATP_CALC_SD profile set to yes ' );
463: l_atp_rec.Insert_Flag(I):= 1;
464: ELSE
465: oe_debug_pub.add('in OEXFRELB, MRP_ATP_CALC_SD profile set to No ' );
466: l_atp_rec.Insert_Flag(I):= 0;

Line 465: oe_debug_pub.add('in OEXFRELB, MRP_ATP_CALC_SD profile set to No ' );

461: IF nvl(l_mrp_calc_sd,'N') = 'Y' THEN
462: oe_debug_pub.add('in OEXFRELB, MRP_ATP_CALC_SD profile set to yes ' );
463: l_atp_rec.Insert_Flag(I):= 1;
464: ELSE
465: oe_debug_pub.add('in OEXFRELB, MRP_ATP_CALC_SD profile set to No ' );
466: l_atp_rec.Insert_Flag(I):= 0;
467: END IF;
468: --end bug14222176
469:

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

473:
474: -- Call ATP
475:
476: IF l_debug_level > 0 THEN
477: oe_debug_pub.add( '1. CALLING MRP API WITH SESSION ID '||L_SESSION_ID , 1 ) ;
478: END IF;
479:
480: IF l_debug_level > 0 THEN
481: print_time('Calling MRP');

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

496: IF l_debug_level > 0 THEN
497: print_time('After Calling MRP');
498: END IF;
499: IF l_debug_level > 0 THEN
500: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||
501: X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT|| ' MSG DATA='||X_MSG_DATA||
502: 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) || 'SHIP_FROM_ORG_ID =' ||
503: X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
504: END IF;

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

504: END IF;
505:
506: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
509: END IF;
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:

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

520: ,x_error_message =>x_error_message
521: );
522:
523: IF l_debug_level > 0 THEN
524: oe_debug_pub.add( 'STATUS='||X_RETURN_STATUS|| ' X_ERROR_MESSAGE ='||X_ERROR_MESSAGE|| ' MSG DATA='||X_MSG_DATA ) ;
525: END IF;
526:
527: IF x_return_status <> 'P' then
528:

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

526:
527: IF x_return_status <> 'P' then
528:
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add( 'RETURN_STATUS<>P' ) ;
531: END IF;
532:
533: IF nvl(x_atp_rec.available_quantity(1),0) = 0 then
534:

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

532:
533: IF nvl(x_atp_rec.available_quantity(1),0) = 0 then
534:
535: IF l_debug_level > 0 THEN
536: oe_debug_pub.add( 'AVAILABLE QUANTITY IS 0' ) ;
537: END IF;
538: x_available_date := null;
539: x_available_qty := 0;
540:

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

548: END IF;
549:
550: ELSE
551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'RETURN_STATUS=P MESG='||X_ERROR_MESSAGE ) ;
553: END IF;
554: x_available_qty := x_error_message;
555: x_available_date := null;
556: x_error_message := null;

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

562: x_qty_uom := x_atp_rec.quantity_uom(1);
563:
564:
565: IF l_debug_level > 0 THEN
566: oe_debug_pub.add( 'OUT_AVAL_QTY='||X_AVAILABLE_QTY||
567: ' SHIP_FORM_ORG_ID='||X_SHIP_FROM_ORG_ID|| ' UOM='||X_QTY_UOM||
568: ' OUT SHIP DATE='||X_ATP_REC.SHIP_DATE ( 1 ) || ' OUT GRP SHIP DATE='||
569: X_ATP_REC.GROUP_SHIP_DATE ( 1 ) || ' OUT ARRIVAL DATE='||
570: X_ATP_REC.ARRIVAL_DATE ( 1 ) || ' OUT GRP ARRIVAL DATE='||

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

574: END IF;
575:
576:
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'EXITING CALL ATP' , 1 ) ;
579: END IF;
580:
581:
582: EXCEPTION

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

583:
584: WHEN OTHERS THEN
585:
586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
588: END IF;
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
591: END IF;

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

586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
588: END IF;
589: IF l_debug_level > 0 THEN
590: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
591: END IF;
592: x_return_status := 'E';
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: -- Get message count and data

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

614:
615: l_return_status varchar2(10);
616:
617: --
618: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
619: --
620: BEGIN
621:
622: IF l_debug_level > 0 THEN

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

619: --
620: BEGIN
621:
622: IF l_debug_level > 0 THEN
623: oe_debug_pub.add( 'EXTENDING THE TABLE BY ' || L_COUNT , 5 ) ;
624: END IF;
625:
626: MSC_SATP_FUNC.Extend_ATP
627: (p_atp_tab => p_x_atp_rec,

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

657: l_arrival_set_name VARCHAR2(30);
658: l_arrival_date DATE := NULL;
659: l_sch_action varchar2(100) := 'OESCH_ACT_ATP_CHECK';
660: --
661: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
662: --
663: BEGIN
664:
665: x_return_status := 'S';

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

663: BEGIN
664:
665: x_return_status := 'S';
666: IF l_debug_level > 0 THEN
667: oe_debug_pub.add( '2. ENTERING CHECK_RESULTS ERROR_CODE='|| P_ATP_REC.ERROR_CODE ( J ) || ' P_GLOBAL_ORGS='||P_GLOBAL_ORGS ) ;
668: END IF;
669:
670: IF p_atp_rec.error_code(J) <> 0 AND
671: p_atp_rec.error_code(J) <> -99 AND -- Multi org changes.

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

673:
674: THEN
675:
676: IF l_debug_level > 0 THEN
677: oe_debug_pub.add( 'ERROR FROM MRP: ' || P_ATP_REC.ERROR_CODE ( J ) , 1 ) ;
678: END IF;
679:
680: IF p_atp_rec.error_code(J) = 80 THEN
681:

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

687: where lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
688: and lookup_code = 80;
689:
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'SETTING THE MESSAGE FOR OE_SCH_NO_SOURCE' ) ;
692: END IF;
693: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
694: IF p_global_orgs = 'N' then
695:

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

701:
702: ELSE
703:
704: IF l_debug_level > 0 THEN
705: oe_debug_pub.add( 'SCH FAILED ERROR CODE='||P_ATP_REC.ERROR_CODE ( J ) ) ;
706: END IF;
707:
708: l_explanation := null;
709:

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

722: ELSIF p_atp_rec.error_code(J) = 61 THEN
723:
724: -- setting the status flag to partial for ATP not applicable
725: IF l_debug_level > 0 THEN
726: oe_debug_pub.add( 'ERROR CODE = 61' ) ;
727: END IF;
728:
729: x_return_status := 'P';
730: x_error_message := l_explanation;

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

737: null;
738:
739: ELSE
740: IF l_debug_level > 0 THEN
741: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
742: END IF;
743: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
744: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
745:

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

755:
756: END IF; -- 80
757:
758: IF l_debug_level > 0 THEN
759: oe_debug_pub.add( 'SETTING ERROR' , 1 ) ;
760: END IF;
761: IF x_return_status <> 'P' then
762: x_return_status := 'E';
763: END IF;

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

764:
765: ELSE
766:
767: IF l_debug_level > 0 THEN
768: oe_debug_pub.add( ' ELSE '||P_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) || ' ERROR CODE : ' || P_ATP_REC.ERROR_CODE ( J ) ) ;
769: END IF;
770:
771: -- Muti org changes.
772: IF (p_atp_rec.error_code(J) <> -99 ) THEN

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

771: -- Muti org changes.
772: IF (p_atp_rec.error_code(J) <> -99 ) THEN
773:
774: IF l_debug_level > 0 THEN
775: oe_debug_pub.add( 'ERROR CODE : ' ||
776: P_ATP_REC.ERROR_CODE ( J ) || 'IDENTIFIER : ' ||
777: P_ATP_REC.IDENTIFIER ( J ) || 'ITEM : ' ||
778: P_ATP_REC.INVENTORY_ITEM_ID ( J ) || 'REQUEST SHIP DATE :' ||
779: TO_CHAR ( P_ATP_REC.REQUESTED_SHIP_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' ) ||

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

799: and lookup_code = p_atp_rec.error_code(J) ;
800:
801: g_atp_tbl(atp_count).error_message := l_explanation;
802: IF l_debug_level > 0 THEN
803: oe_debug_pub.add( 'EXPLANATION IS : ' || L_EXPLANATION , 1 ) ;
804: END IF;
805: x_error_message := l_explanation;
806:
807: IF p_atp_rec.error_code(J) = 150 THEN

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

825: --OE_MSG_PUB.Add;
826:
827: IF x_return_status ='E' and p_global_orgs = 'N' then
828: IF l_debug_level > 0 THEN
829: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
830: END IF;
831: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
832: p_count => x_msg_count,
833: p_data=>x_msg_data

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

832: p_count => x_msg_count,
833: p_data=>x_msg_data
834: );
835: IF l_debug_level > 0 THEN
836: oe_debug_pub.add( 'COUNT = '||X_MSG_COUNT||' MSG='||X_MSG_DATA ) ;
837: END IF;
838: END IF;
839:
840: IF l_debug_level > 0 THEN

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

837: END IF;
838: END IF;
839:
840: IF l_debug_level > 0 THEN
841: oe_debug_pub.add( 'EXITING CHECK_RESULTS: ' || X_RETURN_STATUS , 1 ) ;
842: END IF;
843:
844: EXCEPTION
845: WHEN OTHERS THEN

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

850: , 'Check_Results'
851: );
852: END IF;
853: IF l_debug_level > 0 THEN
854: oe_debug_pub.add( 'UNEXPECTED ERROR IN CHECK_RESULTS' ) ;
855: END IF;
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857:
858: END Check_Results_from_rec;

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

862: out_name out NOCOPY /* file.sql.39 change */ varchar2
863: )IS
864:
865: --
866: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
867: --
868: BEGIN
869: SELECT organization_code,
870: name

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

876: EXCEPTION
877:
878: WHEN OTHERS THEN
879: IF l_debug_level > 0 THEN
880: oe_debug_pub.add( 'GET_SHIP_FROM_ORG WHEN OTHERS '|| SQLCODE||SQLERRM ) ;
881: END IF;
882:
883: END get_ship_From_org;
884:

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

890:
891: l_line_index pls_integer := 0;
892:
893: --
894: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
895: --
896: BEGIN
897:
898: IF l_debug_level > 0 THEN

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

895: --
896: BEGIN
897:
898: IF l_debug_level > 0 THEN
899: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;
900: oe_debug_pub.add( ' line index in copy header to request'||l_line_index);
901: END IF;
902:
903: l_line_index := l_line_index+1;

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

896: BEGIN
897:
898: IF l_debug_level > 0 THEN
899: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' , 1 ) ;
900: oe_debug_pub.add( ' line index in copy header to request'||l_line_index);
901: END IF;
902:
903: l_line_index := l_line_index+1;
904: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE :=p_Request_Type_Code;

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

925: px_req_line_tbl(l_line_index).Rounding_factor := Get_Rounding_factor(g_price_list_id);
926: END IF;
927: --End If;
928: IF l_debug_level > 0 THEN
929: oe_debug_pub.add( 'CURR='||G_CURRENCY||' REQ DATE='||G_REQUEST_DATE||' ROUNDING_FACTOR='||PX_REQ_LINE_TBL ( L_LINE_INDEX ) .ROUNDING_FACTOR ) ;
930: END IF;
931:
932: --px_req_line_tbl(l_line_index).price_request_code := p_header_rec.price_request_code; -- PROMOTIONS SEP/01
933:

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

931:
932: --px_req_line_tbl(l_line_index).price_request_code := p_header_rec.price_request_code; -- PROMOTIONS SEP/01
933:
934: IF l_debug_level > 0 THEN
935: oe_debug_pub.add( 'EXITING OE_OE_RELATED_ITEMS_PVT.COPY_HEADER_TO_REQUEST' ) ;
936: END IF;
937:
938: END copy_Header_to_request;
939:

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

948: v_discounting_privilege VARCHAR2(30);
949: l_item_type_code VARCHAR2(30);
950:
951: --
952: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
953: --
954: begin
955:
956: IF l_debug_level > 0 THEN

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

953: --
954: begin
955:
956: IF l_debug_level > 0 THEN
957: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
958: oe_debug_pub.add( 'line index in copy line to request'||l_line_index);
959: END IF;
960:
961: l_line_index := l_line_index+1;

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

954: begin
955:
956: IF l_debug_level > 0 THEN
957: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
958: oe_debug_pub.add( 'line index in copy line to request'||l_line_index);
959: END IF;
960:
961: l_line_index := l_line_index+1;
962: px_req_line_tbl(l_line_index).Line_id := g_line_id;

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

977: px_req_line_tbl(l_line_index).CURRENCY_CODE :=g_currency;
978: px_req_line_tbl(l_line_index).UNIT_PRICE := Null;
979: --px_req_line_tbl(l_line_index).PERCENT_PRICE := p_Line_rec.unit_list_percent;
980: IF l_debug_level > 0 THEN
981: oe_debug_pub.add( 'QTY='||G_QTY||' UOM ='||G_UOM||' CURR='||G_CURRENCY ) ;
982: END IF;
983:
984: /*If (p_Line_rec.service_period = p_Line_rec.Order_quantity_uom) Then
985: px_req_line_tbl(l_line_index).UOM_QUANTITY := p_Line_rec.service_duration;

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

1025: --px_req_line_tbl(l_line_index).price_request_code := p_line_rec.price_request_code; -- PROMOTIONS SEP/01
1026: --px_req_line_tbl(l_line_index).line_category :=p_line_rec.line_category_code;
1027:
1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
1030: END IF;
1031:
1032: END copy_Line_to_request;
1033:

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

1035: l_Control_Rec in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE
1036: ,in_pricing_event in varchar2)IS
1037:
1038: --
1039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1040: --
1041:
1042: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1043: BEGIN

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

1074: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1075: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1076:
1077: --
1078: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1079: --
1080: BEGIN
1081:
1082: IF l_debug_level > 0 THEN

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

1079: --
1080: BEGIN
1081:
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add( 'BEFORE OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1084: END IF;
1085:
1086: IF l_debug_level > 0 THEN
1087: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||

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

1083: oe_debug_pub.add( 'BEFORE OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1084: END IF;
1085:
1086: IF l_debug_level > 0 THEN
1087: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||
1088: G_PRICING_DATE|| ' INV ITEM_IE='||G_RELATED_ITEM_ID|| ' AGREEMENT_ID='||
1089: G_AGREEMENT_ID|| ' REQ DATE='||G_REQUEST_DATE|| ' SHIP_TO_ORG_ID='||
1090: G_SHIP_TO_ORG_ID|| ' INVOICE_TO_ORG_ID='||G_INVOICE_TO_ORG_ID ) ;
1091: END IF;

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

1090: G_SHIP_TO_ORG_ID|| ' INVOICE_TO_ORG_ID='||G_INVOICE_TO_ORG_ID ) ;
1091: END IF;
1092:
1093: IF l_debug_level > 0 THEN
1094: 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 ) ;
1095: END IF;
1096:
1097: --oe_order_pub.g_line.org_id := l_org_id; --commented for Bug#10353197
1098: oe_order_pub.g_line.org_id := g_org_id; --Bug#10353197

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

1137: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1138: );
1139:
1140: IF l_debug_level > 0 THEN
1141: oe_debug_pub.add( 'EXIT OE_RELATED_ITEMS_PVT.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1142: END IF;
1143:
1144: EXCEPTION
1145: when no_data_found then

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

1161: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);
1162: l_qual_index pls_integer := nvl(px_Req_qual_tbl.last,0);
1163:
1164: --
1165: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1166: --
1167: BEGIN
1168:
1169: IF l_debug_level > 0 THEN

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

1166: --
1167: BEGIN
1168:
1169: IF l_debug_level > 0 THEN
1170: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;
1171: END IF;
1172: i := p_pricing_contexts_Tbl.First;
1173: While i is not null loop
1174: l_attr_index := l_attr_index +1;

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

1217: i := p_qualifier_contexts_Tbl.Next(i);
1218: end loop;
1219:
1220: IF l_debug_level > 0 THEN
1221: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.COPY_ATTRIBS_TO_REQ' , 1 ) ;
1222: END IF;
1223:
1224: END copy_attribs_to_Req;
1225:

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

1236: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1237: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1238:
1239: --
1240: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1241: --
1242: /*4163551*/
1243: l_header_rec OE_ORDER_PUB.header_rec_type;
1244: /*4163551*/

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

1244: /*4163551*/
1245: BEGIN
1246:
1247: IF l_debug_level > 0 THEN
1248: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1249: END IF;
1250:
1251:
1252: IF l_debug_level > 0 THEN

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

1249: END IF;
1250:
1251:
1252: IF l_debug_level > 0 THEN
1253: 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 ) ;
1254: END IF;
1255:
1256: IF l_debug_level > 0 THEN
1257: 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 1257: 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 ) ;

1253: 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 ) ;
1254: END IF;
1255:
1256: IF l_debug_level > 0 THEN
1257: 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 ) ;
1258: END IF;
1259: /*4163551*/
1260: IF l_debug_level > 0 THEN
1261: oe_debug_pub.add( ' 1 Related Items-Header_ID='||g_header_id);

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

1257: 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 ) ;
1258: END IF;
1259: /*4163551*/
1260: IF l_debug_level > 0 THEN
1261: oe_debug_pub.add( ' 1 Related Items-Header_ID='||g_header_id);
1262: END IF;
1263: IF g_header_id is NOT NULL THEN
1264: OE_Header_Util.Query_Row
1265: ( p_header_id => g_header_id,

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

1265: ( p_header_id => g_header_id,
1266: x_header_rec =>l_header_rec
1267: );
1268: IF l_debug_level > 0 THEN
1269: oe_debug_pub.add( ' Queried -Related Items-Header_ID='||g_header_id);
1270: END IF;
1271: END IF;
1272:
1273: IF l_header_rec.header_id IS NOT NULL AND

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

1273: IF l_header_rec.header_id IS NOT NULL AND
1274: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1275: oe_order_pub.g_hdr:=l_header_rec;
1276: IF l_debug_level > 0 THEN
1277: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1278: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1279: END IF;
1280: /*4163551*/
1281: ELSE

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

1274: l_header_rec.header_id<>FND_API.G_MISS_NUM THEN
1275: oe_order_pub.g_hdr:=l_header_rec;
1276: IF l_debug_level > 0 THEN
1277: oe_debug_pub.add( 'Header_ID='||oe_order_pub.g_hdr.header_id);
1278: oe_debug_pub.add( 'sdatti Related Items-Price List='||oe_order_pub.g_hdr.price_list_id);
1279: END IF;
1280: /*4163551*/
1281: ELSE
1282: oe_order_pub.g_hdr.agreement_id := g_agreement_id;

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

1326: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1327: );
1328:
1329: IF l_debug_level > 0 THEN
1330: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1331: END IF;
1332:
1333: EXCEPTION
1334: when no_data_found then

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

1348:
1349: i pls_integer;
1350:
1351: --
1352: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1353: --
1354: BEGIN
1355:
1356: IF l_debug_level > 0 THEN

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

1353: --
1354: BEGIN
1355:
1356: IF l_debug_level > 0 THEN
1357: oe_debug_pub.add( 'ENTERING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;
1358: END IF;
1359:
1360: IF g_PRICING_ATTRIBUTE1 is not null then
1361: i := px_Req_line_attr_tbl.count+1;

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

2262: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From:=g_PRICING_ATTRIBUTE100;
2263: end if;
2264:
2265: IF l_debug_level > 0 THEN
2266: oe_debug_pub.add( 'EXITING OE_RELATED_ITEMS_PVT.APPEND_ATTRIBUTES' , 1 ) ;
2267: END IF;
2268:
2269: END Append_attributes;
2270:

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

2406: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2407: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2408:
2409: --
2410: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2411: --
2412: BEGIN
2413: /*4163551*/
2414: oe_order_pub.g_hdr:=null;

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

2616: IF l_debug_level > 0 THEN
2617: print_time('After Calling PE');
2618: END IF;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
2621: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
2622: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
2623: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
2624: END IF;

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

2617: print_time('After Calling PE');
2618: END IF;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
2621: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
2622: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
2623: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
2624: END IF;
2625: if out_req_line_tbl.count > 0 then

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

2618: END IF;
2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
2621: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
2622: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
2623: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
2624: END IF;
2625: if out_req_line_tbl.count > 0 then
2626: for i in out_req_line_tbl.first..out_req_line_tbl.last

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

2619: IF l_debug_level > 0 THEN
2620: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
2621: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
2622: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
2623: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
2624: END IF;
2625: if out_req_line_tbl.count > 0 then
2626: for i in out_req_line_tbl.first..out_req_line_tbl.last
2627: loop

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

2625: if out_req_line_tbl.count > 0 then
2626: for i in out_req_line_tbl.first..out_req_line_tbl.last
2627: loop
2628: IF l_debug_level > 0 THEN
2629: oe_debug_pub.add( '*******************************' ) ;
2630: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2631: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2632: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;

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

2626: for i in out_req_line_tbl.first..out_req_line_tbl.last
2627: loop
2628: IF l_debug_level > 0 THEN
2629: oe_debug_pub.add( '*******************************' ) ;
2630: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2631: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2632: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;

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

2627: loop
2628: IF l_debug_level > 0 THEN
2629: oe_debug_pub.add( '*******************************' ) ;
2630: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2631: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2632: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;

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

2628: IF l_debug_level > 0 THEN
2629: oe_debug_pub.add( '*******************************' ) ;
2630: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2631: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2632: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;

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

2629: oe_debug_pub.add( '*******************************' ) ;
2630: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2631: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2632: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;

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

2630: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
2631: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2632: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;

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

2631: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
2632: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;

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

2632: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;

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

2633: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;

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

2634: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;

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

2635: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;

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

2636: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;

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

2637: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;

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

2638: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;

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

2639: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;

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

2640: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;

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

2641: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;

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

2642: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;

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

2643: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;

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

2644: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;

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

2645: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;

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

2646: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2654: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;

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

2647: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2654: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2655: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;

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

2648: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2654: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2655: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2656: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;

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

2649: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2654: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2655: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2656: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2657: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;

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

2650: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2654: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2655: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2656: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2657: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
2658: END IF;

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

2651: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2654: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2655: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2656: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2657: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
2658: END IF;
2659: end loop;

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

2652: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2654: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2655: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2656: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2657: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
2658: END IF;
2659: end loop;
2660: end if;

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

2653: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
2654: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
2655: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
2656: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
2657: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
2658: END IF;
2659: end loop;
2660: end if;
2661:

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

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

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

2665: if out_req_line_detail_tbl.count > 0 then
2666: for i in out_req_line_detail_tbl.first..out_req_line_detail_tbl.last
2667: loop
2668: IF l_debug_level > 0 THEN
2669: oe_debug_pub.add( 'LINE DETAIL TABLE RECORD='||I ) ;
2670: END IF;
2671: if out_req_line_detail_tbl.exists(i) then
2672: IF l_debug_level > 0 THEN
2673: oe_debug_pub.add( '*******************************' ) ;

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

2669: oe_debug_pub.add( 'LINE DETAIL TABLE RECORD='||I ) ;
2670: END IF;
2671: if out_req_line_detail_tbl.exists(i) then
2672: IF l_debug_level > 0 THEN
2673: oe_debug_pub.add( '*******************************' ) ;
2674: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2675: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2676: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;

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

2670: END IF;
2671: if out_req_line_detail_tbl.exists(i) then
2672: IF l_debug_level > 0 THEN
2673: oe_debug_pub.add( '*******************************' ) ;
2674: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2675: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2676: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;

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

2671: if out_req_line_detail_tbl.exists(i) then
2672: IF l_debug_level > 0 THEN
2673: oe_debug_pub.add( '*******************************' ) ;
2674: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2675: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2676: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;

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

2672: IF l_debug_level > 0 THEN
2673: oe_debug_pub.add( '*******************************' ) ;
2674: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2675: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2676: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;

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

2673: oe_debug_pub.add( '*******************************' ) ;
2674: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2675: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2676: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;

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

2674: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
2675: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2676: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;

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

2675: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
2676: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;

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

2676: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;

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

2677: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;

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

2678: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2686: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;

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

2679: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2686: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2687: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;

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

2680: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2686: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2687: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2688: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;

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

2681: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2686: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2687: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2688: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2689: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;

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

2682: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2686: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2687: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2688: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2689: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
2690: END IF;

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

2683: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2686: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2687: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2688: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2689: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
2690: END IF;
2691: end if;

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

2684: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2686: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2687: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2688: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2689: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
2690: END IF;
2691: end if;
2692:

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

2685: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
2686: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
2687: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
2688: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
2689: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
2690: END IF;
2691: end if;
2692:
2693: end loop;

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

2694: end if;
2695:
2696:
2697: IF l_debug_level > 0 THEN
2698: oe_debug_pub.add( 'COUNT LINE DETAIL ATTR TBL='|| OUT_REQ_LINE_DETAIL_ATTR_TBL.COUNT ) ;
2699: END IF;
2700: if out_req_line_detail_attr_tbl.count > 0 then
2701: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
2702: loop

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

2700: if out_req_line_detail_attr_tbl.count > 0 then
2701: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
2702: loop
2703: IF l_debug_level > 0 THEN
2704: oe_debug_pub.add( '*******************************' ) ;
2705: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2706: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2707: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2708: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

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

2701: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
2702: loop
2703: IF l_debug_level > 0 THEN
2704: oe_debug_pub.add( '*******************************' ) ;
2705: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2706: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2707: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2708: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2709: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

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

2702: loop
2703: IF l_debug_level > 0 THEN
2704: oe_debug_pub.add( '*******************************' ) ;
2705: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2706: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2707: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2708: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2709: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2710: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

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

2703: IF l_debug_level > 0 THEN
2704: oe_debug_pub.add( '*******************************' ) ;
2705: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2706: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2707: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2708: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2709: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2710: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2711: END IF;

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

2704: oe_debug_pub.add( '*******************************' ) ;
2705: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2706: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2707: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2708: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2709: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2710: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2711: END IF;
2712:

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

2705: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
2706: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2707: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2708: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2709: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2710: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2711: END IF;
2712:
2713: end loop;

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

2706: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2707: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2708: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2709: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2710: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2711: END IF;
2712:
2713: end loop;
2714: end if;

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

2714: end if;
2715:
2716:
2717: IF l_debug_level > 0 THEN
2718: oe_debug_pub.add( 'COUNT LINE ATTR TBL='||OUT_REQ_LINE_ATTR_TBL.COUNT ) ;
2719: END IF;
2720: if out_req_line_attr_tbl.count > 0 then
2721: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
2722: loop

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

2720: if out_req_line_attr_tbl.count > 0 then
2721: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
2722: loop
2723: IF l_debug_level > 0 THEN
2724: oe_debug_pub.add( '*******************************' ) ;
2725: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2726: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2727: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2728: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

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

2721: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
2722: loop
2723: IF l_debug_level > 0 THEN
2724: oe_debug_pub.add( '*******************************' ) ;
2725: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2726: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2727: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2728: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2729: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

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

2722: loop
2723: IF l_debug_level > 0 THEN
2724: oe_debug_pub.add( '*******************************' ) ;
2725: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2726: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2727: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2728: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2729: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2730: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

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

2723: IF l_debug_level > 0 THEN
2724: oe_debug_pub.add( '*******************************' ) ;
2725: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2726: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2727: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2728: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2729: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2730: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2731: END IF;

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

2724: oe_debug_pub.add( '*******************************' ) ;
2725: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2726: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2727: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2728: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2729: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2730: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2731: END IF;
2732:

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

2725: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
2726: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2727: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2728: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2729: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2730: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2731: END IF;
2732:
2733: end loop;

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

2726: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
2727: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
2728: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
2729: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
2730: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
2731: END IF;
2732:
2733: end loop;
2734: end if;

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

2734: end if;
2735:
2736:
2737: IF l_debug_level > 0 THEN
2738: oe_debug_pub.add( 'COUNT RELATED LINES TBL='|| OUT_REQ_RELATED_LINES_TBL.COUNT ) ;
2739: END IF;
2740: if out_req_related_lines_tbl.count > 0 then
2741: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
2742: loop

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

2740: if out_req_related_lines_tbl.count > 0 then
2741: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
2742: loop
2743: IF l_debug_level > 0 THEN
2744: oe_debug_pub.add( '*******************************' ) ;
2745: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2746: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2747: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2748: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;

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

2741: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
2742: loop
2743: IF l_debug_level > 0 THEN
2744: oe_debug_pub.add( '*******************************' ) ;
2745: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2746: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2747: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2748: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2749: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;

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

2742: loop
2743: IF l_debug_level > 0 THEN
2744: oe_debug_pub.add( '*******************************' ) ;
2745: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2746: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2747: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2748: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2749: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2750: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;

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

2743: IF l_debug_level > 0 THEN
2744: oe_debug_pub.add( '*******************************' ) ;
2745: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2746: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2747: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2748: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2749: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2750: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
2751: END IF;

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

2744: oe_debug_pub.add( '*******************************' ) ;
2745: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2746: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2747: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2748: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2749: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2750: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
2751: END IF;
2752:

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

2745: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
2746: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2747: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2748: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2749: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2750: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
2751: END IF;
2752:
2753: end loop;

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

2746: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
2747: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2748: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
2749: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
2750: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
2751: END IF;
2752:
2753: end loop;
2754: end if;

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

2754: end if;
2755:
2756:
2757: IF l_debug_level > 0 THEN
2758: oe_debug_pub.add( 'COUNT LINE QUAL TBL='||OUT_REQ_QUAL_TBL.COUNT ) ;
2759: END IF;
2760: if out_req_qual_tbl.count > 0 then
2761: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
2762: loop

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

2760: if out_req_qual_tbl.count > 0 then
2761: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
2762: loop
2763: IF l_debug_level > 0 THEN
2764: oe_debug_pub.add( '*******************************' ) ;
2765: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2766: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2767: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

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

2761: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
2762: loop
2763: IF l_debug_level > 0 THEN
2764: oe_debug_pub.add( '*******************************' ) ;
2765: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2766: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2767: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2769: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

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

2762: loop
2763: IF l_debug_level > 0 THEN
2764: oe_debug_pub.add( '*******************************' ) ;
2765: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2766: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2767: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2769: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2770: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

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

2763: IF l_debug_level > 0 THEN
2764: oe_debug_pub.add( '*******************************' ) ;
2765: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2766: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2767: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2769: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2770: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2771: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

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

2764: oe_debug_pub.add( '*******************************' ) ;
2765: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2766: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2767: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2769: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2770: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2771: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2772: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

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

2765: oe_debug_pub.add( 'QUAL TABLE RECORD='||I ) ;
2766: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2767: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2769: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2770: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2771: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2772: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2773: END IF;

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

2766: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
2767: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2769: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2770: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2771: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2772: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2773: END IF;
2774:

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

2767: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2769: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2770: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2771: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2772: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2773: END IF;
2774:
2775: end loop;

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

2768: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2769: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2770: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2771: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2772: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2773: END IF;
2774:
2775: end loop;
2776: end if;

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

2776: end if;
2777:
2778:
2779: IF l_debug_level > 0 THEN
2780: oe_debug_pub.add( 'COUNT LINE DETAIL QUAL TBL='|| OUT_REQ_LINE_DETAIL_QUAL_TBL.COUNT ) ;
2781: END IF;
2782: if out_req_line_detail_qual_tbl.count > 0 then
2783: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
2784: loop

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

2782: if out_req_line_detail_qual_tbl.count > 0 then
2783: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
2784: loop
2785: IF l_debug_level > 0 THEN
2786: oe_debug_pub.add( '*******************************' ) ;
2787: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2788: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2789: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

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

2783: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
2784: loop
2785: IF l_debug_level > 0 THEN
2786: oe_debug_pub.add( '*******************************' ) ;
2787: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2788: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2789: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2791: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

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

2784: loop
2785: IF l_debug_level > 0 THEN
2786: oe_debug_pub.add( '*******************************' ) ;
2787: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2788: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2789: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2791: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2792: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

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

2785: IF l_debug_level > 0 THEN
2786: oe_debug_pub.add( '*******************************' ) ;
2787: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2788: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2789: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2791: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2792: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2793: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

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

2786: oe_debug_pub.add( '*******************************' ) ;
2787: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2788: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2789: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2791: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2792: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2793: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2794: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

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

2787: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
2788: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2789: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2791: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2792: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2793: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2794: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2795: END IF;

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

2788: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
2789: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2791: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2792: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2793: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2794: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2795: END IF;
2796:

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

2789: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2791: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2792: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2793: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2794: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2795: END IF;
2796:
2797: end loop;

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

2790: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
2791: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
2792: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
2793: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
2794: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
2795: END IF;
2796:
2797: end loop;
2798: end if;

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

2798: end if;
2799:
2800:
2801: IF l_debug_level > 0 THEN
2802: oe_debug_pub.add( ' EXITING PRICE_ITEM*******************************' ) ;
2803: END IF;
2804:
2805: EXCEPTION
2806: when others then

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

2805: EXCEPTION
2806: when others then
2807:
2808: IF l_debug_level > 0 THEN
2809: oe_debug_pub.add( 'PRICE ITEM EXCEPTION WHEN OTHERS CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
2810: END IF;
2811:
2812: END price_item;
2813:

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

2929: in_pricing_attribute100 in varchar2
2930: ) IS
2931:
2932: --
2933: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2934: --
2935: BEGIN
2936:
2937: g_related_item_id := in_related_item_id;

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

3102: l_operand number;
3103: l_msg_text Varchar2(2000);
3104:
3105: --
3106: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3107: --
3108: BEGIN
3109:
3110: IF l_debug_level > 0 THEN

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

3107: --
3108: BEGIN
3109:
3110: IF l_debug_level > 0 THEN
3111: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;
3112: END IF;
3113: IF l_debug_level > 0 THEN
3114: 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 ) ;
3115: END IF;

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

3110: IF l_debug_level > 0 THEN
3111: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;
3112: END IF;
3113: IF l_debug_level > 0 THEN
3114: 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 ) ;
3115: END IF;
3116:
3117:
3118: IF in_line_Type_code ='LINE' and

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

3145:
3146: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
3147:
3148: IF l_debug_level > 0 THEN
3149: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID ) ;
3150: END IF;
3151: IF g_price_list_id is null then
3152:
3153: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');

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

3152:
3153: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
3154: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3155: IF l_debug_level > 0 THEN
3156: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3157: END IF;
3158: OE_MSG_PUB.Add;
3159:
3160: ELSE

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

3158: OE_MSG_PUB.Add;
3159:
3160: ELSE
3161: IF l_debug_level > 0 THEN
3162: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3163: END IF;
3164: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3165: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3166: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);

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

3196: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3197: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3198:
3199: IF l_debug_level > 0 THEN
3200: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3201: END IF;
3202: Begin
3203: Select name into l_price_list
3204: from qp_list_headers_vl a,qp_list_lines b where

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

3213: instr(in_status_text,',')-1);
3214: End;
3215:
3216: IF l_debug_level > 0 THEN
3217: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
3218: END IF;
3219: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3220: Begin
3221: Select name into l_price_list

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

3230: l_price_list := substr(in_status_text,
3231: instr(in_status_text,',')+1);
3232: End;
3233: IF l_debug_level > 0 THEN
3234: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3235: END IF;
3236:
3237: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3238: OE_MSG_PUB.Add;

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

3259:
3260: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and
3261: l_allow_negative_price = 'N' then
3262:
3263: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
3264: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3265: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3266: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3267: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);

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

3275: ELSIF in_line_Type_code ='LINE' and
3276: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
3277:
3278: IF l_debug_level > 0 THEN
3279: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
3280: END IF;
3281: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
3282: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
3283: OE_MSG_PUB.Add;

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

3292: --engine doesn't look at the line and will not return adjustments. In this
3293: --case we DON't want to remove the adjustments that engine doesn't return.
3294: then
3295: IF l_debug_level > 0 THEN
3296: oe_debug_pub.add( 'OE_PRICING_ERROR 2' ) ;
3297: END IF;
3298:
3299: IF in_status_text is not null then
3300: l_return_status := 'E';

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

3310: /*OPEN get_gsa_list_lines;
3311: FETCH get_gsa_list_lines
3312: INTO l_operand;
3313: CLOSE get_gsa_list_lines;
3314: oe_debug_pub.add('After select OE_PRICING_ERROR 2');
3315: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
3316: ' Operand='||l_operand);
3317:
3318: IF in_adjusted_unit_price <= l_operand then

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

3311: FETCH get_gsa_list_lines
3312: INTO l_operand;
3313: CLOSE get_gsa_list_lines;
3314: oe_debug_pub.add('After select OE_PRICING_ERROR 2');
3315: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
3316: ' Operand='||l_operand);
3317:
3318: IF in_adjusted_unit_price <= l_operand then
3319: oe_debug_pub.add('If unit price less than operand violation='||

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

3315: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
3316: ' Operand='||l_operand);
3317:
3318: IF in_adjusted_unit_price <= l_operand then
3319: oe_debug_pub.add('If unit price less than operand violation='||
3320: l_gsa_violation_action);
3321: --Check if the GSA check needs to be done.
3322: If l_gsa_violation_action in ('WARNING','ERROR') then
3323:

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

3320: l_gsa_violation_action);
3321: --Check if the GSA check needs to be done.
3322: If l_gsa_violation_action in ('WARNING','ERROR') then
3323:
3324: oe_debug_pub.add('GSA warning or error');
3325: Begin
3326: SELECT concatenated_segments
3327: INTO l_msg_text
3328: FROM mtl_system_items_kfv

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

3333: Null;
3334: End;
3335:
3336: l_return_status := 'E';
3337: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
3338: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
3339: l_msg_text := l_operand||' ( '||l_msg_text||' )';
3340: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
3341: OE_MSG_PUB.Add;

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

3353: --need to be pulled out by append_adjustment_lines routine
3354: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
3355: Then
3356: IF l_debug_level > 0 THEN
3357: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
3358: END IF;
3359: null;
3360:
3361: ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then

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

3360:
3361: ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then
3362:
3363: IF l_debug_level > 0 THEN
3364: oe_debug_pub.add( 'STATUS = UPDATED' ) ;
3365: END IF;
3366:
3367: END IF;-- Status_Code
3368:

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

3367: END IF;-- Status_Code
3368:
3369:
3370: IF l_debug_level > 0 THEN
3371: oe_debug_pub.add( 'PROCESS PRICING ERROR AFTER ERR CHK ST='||L_RETURN_STATUS ) ;
3372: END IF;
3373:
3374: IF l_return_status ='E' then
3375: IF l_debug_level > 0 THEN

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

3372: END IF;
3373:
3374: IF l_return_status ='E' then
3375: IF l_debug_level > 0 THEN
3376: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
3377: END IF;
3378: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
3379: p_count => l_msg_count,
3380: p_data=>l_msg_data

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

3381: );
3382: END IF;
3383:
3384: IF l_debug_level > 0 THEN
3385: oe_debug_pub.add( 'EXITING PROCESS_PRICING_ERRORS' ) ;
3386: END IF;
3387:
3388: EXCEPTION
3389:

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

3388: EXCEPTION
3389:
3390: when others then
3391: IF l_debug_level > 0 THEN
3392: oe_debug_pub.add( 'PROCESS PRICING ERRORS WHEN OTHERS EXCEPTION CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
3393: END IF;
3394:
3395: END process_pricing_errors;
3396: FUNCTION Get_Rounding_factor(p_list_header_id number) return number is

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

3397:
3398: l_rounding_factor number;
3399:
3400: --
3401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3402: --
3403: BEGIN
3404:
3405: select rounding_factor

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

3433: out_freight_terms_code out NOCOPY /* file.sql.39 change */ varchar2
3434: ) IS
3435:
3436: --
3437: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3438: --
3439: BEGIN
3440:
3441: IF l_debug_level > 0 THEN

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

3438: --
3439: BEGIN
3440:
3441: IF l_debug_level > 0 THEN
3442: oe_debug_pub.add( 'GET PRICE_LIST ID='||P_PRICE_LIST_ID ) ;
3443: END IF;
3444:
3445: IF p_price_list_id IS NOT NULL THEN
3446:

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

3469:
3470: END IF;
3471:
3472: IF l_debug_level > 0 THEN
3473: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
3474: END IF;
3475:
3476: EXCEPTION
3477:

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

3476: EXCEPTION
3477:
3478: WHEN NO_DATA_FOUND THEN
3479: IF l_debug_level > 0 THEN
3480: oe_debug_pub.add( 'NO DATA FOUND GET PRICE LIST_INFO' ) ;
3481: END IF;
3482:
3483: WHEN OTHERS THEN
3484: IF l_debug_level > 0 THEN

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

3481: END IF;
3482:
3483: WHEN OTHERS THEN
3484: IF l_debug_level > 0 THEN
3485: oe_debug_pub.add( 'WHEN OTHERS GET PRICE LIST_INFO'|| SQLCODE||SQLERRM ) ;
3486: END IF;
3487:
3488: END get_Price_List_info;
3489:

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

3518: l_ordered_conversion number;
3519: l_pricing_conversion number;
3520:
3521: --
3522: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3523: --
3524: BEGIN
3525:
3526: IF l_debug_level > 0 THEN

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

3523: --
3524: BEGIN
3525:
3526: IF l_debug_level > 0 THEN
3527: 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 ) ;
3528: END IF;
3529:
3530: OPEN c_items;
3531: FETCH c_items

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

3549: IF in_ordered_uom <> l_base_uom AND
3550: in_pricing_uom <> l_base_uom THEN
3551:
3552: IF l_debug_level > 0 THEN
3553: oe_debug_pub.add( 'NEITHER THE ORDERED OR PRICING UOM IS BASE UOM' ) ;
3554: END IF;
3555:
3556: l_ordered_conversion := get_conversion_rate(
3557: in_uom_code => in_ordered_uom,

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

3557: in_uom_code => in_ordered_uom,
3558: in_base_uom => l_base_uom
3559: );
3560: IF l_debug_level > 0 THEN
3561: oe_debug_pub.add( 'THE ORD RATE ='||L_ORDERED_CONVERSION ) ;
3562: END IF;
3563: l_pricing_conversion := get_conversion_rate(
3564: in_uom_code => in_pricing_uom,
3565: in_base_uom => l_base_uom

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

3564: in_uom_code => in_pricing_uom,
3565: in_base_uom => l_base_uom
3566: );
3567: IF l_debug_level > 0 THEN
3568: oe_debug_pub.add( 'THE PRICING RATE ='||L_PRICING_CONVERSION ) ;
3569: END IF;
3570:
3571: out_conversion_rate := l_ordered_conversion/l_pricing_conversion;
3572: IF l_debug_level > 0 THEN

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

3569: END IF;
3570:
3571: out_conversion_rate := l_ordered_conversion/l_pricing_conversion;
3572: IF l_debug_level > 0 THEN
3573: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
3574: END IF;
3575:
3576: -- Ordered Uom is the Base Uom,sending the pricing uom for conversion
3577: ELSIF in_ordered_uom = l_base_uom then

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

3576: -- Ordered Uom is the Base Uom,sending the pricing uom for conversion
3577: ELSIF in_ordered_uom = l_base_uom then
3578:
3579: IF l_debug_level > 0 THEN
3580: oe_debug_pub.add( 'THE ORDERED UOM IS BASE UOM' ) ;
3581: END IF;
3582:
3583: l_ordered_conversion := get_conversion_rate(
3584: in_uom_code => in_pricing_uom,

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

3585: in_base_uom => l_base_uom
3586: );
3587: out_conversion_rate := l_ordered_conversion;
3588: IF l_debug_level > 0 THEN
3589: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
3590: END IF;
3591:
3592: -- Pricing Uom is the Base Uom
3593: ELSIF in_pricing_uom = l_base_uom then

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

3592: -- Pricing Uom is the Base Uom
3593: ELSIF in_pricing_uom = l_base_uom then
3594:
3595: IF l_debug_level > 0 THEN
3596: oe_debug_pub.add( 'THE PRICING UOM IS BASE UOM' ) ;
3597: END IF;
3598: l_pricing_conversion := get_conversion_rate(
3599: in_uom_code => in_ordered_uom,
3600: in_base_uom => l_base_uom

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

3600: in_base_uom => l_base_uom
3601: );
3602: out_conversion_rate := l_pricing_conversion;
3603: IF l_debug_level > 0 THEN
3604: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
3605: END IF;
3606:
3607: END IF;
3608:

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

3620: EXCEPTION
3621:
3622: WHEN NO_DATA_FOUND THEN
3623: IF l_debug_level > 0 THEN
3624: oe_debug_pub.add( 'NO DATA FONUNG DIFFERENT_UOM ' ) ;
3625: END IF;
3626:
3627: WHEN OTHERS THEN
3628: IF c_items%ISOPEN then

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

3634: IF c_base_uom%ISOPEN then
3635: CLOSE c_base_uom;
3636: END IF;
3637: IF l_debug_level > 0 THEN
3638: oe_debug_pub.add( 'ERROR IN DIFFERENT_UOM '|| SQLCODE||SQLERRM ) ;
3639: END IF;
3640:
3641: END different_uom;
3642:

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

3669: l_conversion_rate number;
3670: l_uom_code varchar2(50);
3671:
3672: --
3673: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3674: --
3675: BEGIN
3676:
3677: IF l_debug_level > 0 THEN

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

3674: --
3675: BEGIN
3676:
3677: IF l_debug_level > 0 THEN
3678: oe_debug_pub.add( 'INSIDE GET_CONVERSION_RATE '|| ' IN_UOM_CODE='||IN_UOM_CODE|| ' IN_BASE_UOM='||IN_BASE_UOM ) ;
3679: END IF;
3680:
3681: OPEN c_item_conversion;
3682: FETCH c_item_conversion

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

3684:
3685: IF c_item_conversion%NOTFOUND THEN
3686:
3687: IF l_debug_level > 0 THEN
3688: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE NOT FOUND' ) ;
3689: END IF;
3690:
3691: OPEN c_conversion;
3692: FETCH c_conversion

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

3694:
3695: IF c_conversion%NOTFOUND THEN
3696:
3697: IF l_debug_level > 0 THEN
3698: oe_debug_pub.add( 'GENERIC CONVERSION NOT FOUND' ) ;
3699: END IF;
3700: OPEN c_inter_class;
3701: FETCH c_inter_class
3702: INTO l_conversion_rate;

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

3702: INTO l_conversion_rate;
3703:
3704: IF c_inter_class%NOTFOUND THEN
3705: IF l_debug_level > 0 THEN
3706: oe_debug_pub.add( 'INTER CLASS RETURN RATE NOT FOUND= 1' ) ;
3707: END IF;
3708: l_conversion_rate := 1;
3709:
3710: ELSE

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

3708: l_conversion_rate := 1;
3709:
3710: ELSE
3711: IF l_debug_level > 0 THEN
3712: oe_debug_pub.add( 'INTER CLASS RETURN RATE = '||L_CONVERSION_RATE ) ;
3713: END IF;
3714:
3715: END IF;
3716: CLOSE c_inter_class;

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

3717:
3718: ELSIF c_conversion%FOUND then
3719:
3720: IF l_debug_level > 0 THEN
3721: oe_debug_pub.add( 'RETURN RATE GENERIC= '||L_CONVERSION_RATE ) ;
3722: END IF;
3723:
3724: END IF;
3725: CLOSE c_conversion;

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

3726:
3727: ELSIF c_item_conversion%FOUND THEN
3728:
3729: IF l_debug_level > 0 THEN
3730: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE='||L_CONVERSION_RATE ) ;
3731: END IF;
3732:
3733: END IF;
3734: CLOSE c_item_conversion;

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

3738: EXCEPTION
3739:
3740: WHEN ZERO_DIVIDE THEN
3741: IF l_debug_level > 0 THEN
3742: oe_debug_pub.add( 'DIVIDE BY ZERO ERROR IN_UOM_CODE='||IN_UOM_CODE|| ' BASE UOM='||IN_BASE_UOM ) ;
3743: END IF;
3744:
3745: IF c_item_conversion%ISOPEN then
3746: CLOSE c_item_conversion;

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

3763: IF c_inter_class%ISOPEN then
3764: CLOSE c_inter_class;
3765: END IF;
3766: IF l_debug_level > 0 THEN
3767: oe_debug_pub.add( 'ERROR IN GET_CONVERSION_RATE '|| SQLCODE||SQLERRM ) ;
3768: END IF;
3769: return 1;
3770: END get_conversion_rate;
3771: PROCEDURE print_time(in_place in varchar2) IS

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

3777: l_hsecs number;
3778: l_total number;
3779:
3780: --
3781: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3782: --
3783: BEGIN
3784:
3785: --print_time2;

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

3792:
3793: g_hsecs := l_hsecs;
3794: g_place := in_place;
3795: IF l_debug_level > 0 THEN
3796: oe_debug_pub.add( 'TIME STARTING AT PLACE '||G_PLACE||' TIME='||G_HSECS ) ;
3797: END IF;
3798:
3799: ELSE
3800: l_total := (l_hsecs - g_hsecs)/100;

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

3799: ELSE
3800: l_total := (l_hsecs - g_hsecs)/100;
3801: g_total := g_total + l_total;
3802: IF l_debug_level > 0 THEN
3803: oe_debug_pub.add( 'TIME FROM ' ||G_PLACE||' TO '||IN_PLACE||' TIME DIFF='|| L_TOTAL||' SECONDS'||' TOTAL SO FAR='||G_TOTAL ) ;
3804: END IF;
3805: g_hsecs := l_hsecs;
3806: g_place := in_place;
3807:

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

3820: l_hsecs number;
3821: l_total number;
3822:
3823: --
3824: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3825: --
3826: BEGIN
3827:
3828: OPEN c2_hsecs;

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

3831: CLOSE c2_hsecs;
3832:
3833: IF g_total2 is null then
3834: IF l_debug_level > 0 THEN
3835: oe_debug_pub.add( 'G_TOTAL2 IS NULL L_HSECS='||L_HSECS ) ;
3836: END IF;
3837: g_total2 := l_hsecs;
3838: ELSE
3839: IF l_debug_level > 0 THEN

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

3836: END IF;
3837: g_total2 := l_hsecs;
3838: ELSE
3839: IF l_debug_level > 0 THEN
3840: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;
3841: END IF;
3842: l_total := (l_hsecs - g_total2)/100;
3843: IF l_debug_level > 0 THEN
3844: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;

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

3840: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;
3841: END IF;
3842: l_total := (l_hsecs - g_total2)/100;
3843: IF l_debug_level > 0 THEN
3844: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;
3845: END IF;
3846: g_total2 := l_hsecs;
3847: END IF;
3848: