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

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

238: I NUMBER := 1;
239:
240:
241: --
242: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
243: --
244: BEGIN
245:
246: IF l_debug_level > 0 THEN

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

243: --
244: BEGIN
245:
246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add( 'ENTERING CALL ATP' ) ;
248: END IF;
249:
250: Initialize_mrp_record
251: ( p_x_atp_rec => in_atp_rec

Line 256: oe_debug_pub.add( 'INVENTORY_ITEM_ID='||g_panda_rec_table(1).P_INVENTORY_ITEM_ID

252: ,l_count =>1 );
253:
254:
255: IF l_debug_level > 0 THEN
256: oe_debug_pub.add( 'INVENTORY_ITEM_ID='||g_panda_rec_table(1).P_INVENTORY_ITEM_ID
257: || ' SHIP_FORM_ORG_ID='||G_panda_rec_table(1).p_SHIP_FROM_ORG_ID
258: || ' IN_GLOBAL_ORGS='||IN_GLOBAL_ORGS);
259: oe_debug_pub.add(' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' SHIP_TO_ORG_ID='
260: ||G_panda_rec_table(1).p_SHIP_TO_ORG_ID||' QTY='||G_panda_rec_table(1).p_QTY

Line 259: oe_debug_pub.add(' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' SHIP_TO_ORG_ID='

255: IF l_debug_level > 0 THEN
256: oe_debug_pub.add( 'INVENTORY_ITEM_ID='||g_panda_rec_table(1).P_INVENTORY_ITEM_ID
257: || ' SHIP_FORM_ORG_ID='||G_panda_rec_table(1).p_SHIP_FROM_ORG_ID
258: || ' IN_GLOBAL_ORGS='||IN_GLOBAL_ORGS);
259: oe_debug_pub.add(' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' SHIP_TO_ORG_ID='
260: ||G_panda_rec_table(1).p_SHIP_TO_ORG_ID||' QTY='||G_panda_rec_table(1).p_QTY
261: || ' UOM='||G_panda_rec_table(1).p_UOM||' REQ DATE='||
262: G_panda_rec_table(1).p_REQUEST_DATE ) ;
263: END IF;

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

276: INTO l_line_id
277: FROM DUAL;
278: */
279: IF l_debug_level > 0 THEN
280: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;
281: END IF;
282:
283: in_atp_rec.Identifier(I) := g_atp_line_id;
284: in_atp_rec.Action(I) := 100;

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

316:
317: -- Call ATP
318:
319: IF l_debug_level > 0 THEN
320: oe_debug_pub.add('1.CALLING MRP API WITH SESSION ID '||L_SESSION_ID);
321: END IF;
322:
323: IF l_debug_level > 0 THEN
324: print_time('Calling MRP');

Line 344: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT);

340: print_time('After Calling MRP');
341: END IF;
342:
343: IF l_debug_level > 0 THEN
344: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT);
345:
346: IF x_atp_rec.available_quantity.COUNT > 0 AND
347: x_atp_rec.source_organization_id.COUNT > 0 then
348: oe_debug_pub.add( ' MSG DATA='||X_MSG_DATA|| 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) ||

Line 348: oe_debug_pub.add( ' MSG DATA='||X_MSG_DATA|| 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) ||

344: oe_debug_pub.add( 'AFTER CALL MRP_ATP_PUB.CALL_ATP STS='||X_RETURN_STATUS|| ' MSG COUNT='||X_MSG_COUNT);
345:
346: IF x_atp_rec.available_quantity.COUNT > 0 AND
347: x_atp_rec.source_organization_id.COUNT > 0 then
348: oe_debug_pub.add( ' MSG DATA='||X_MSG_DATA|| 'AVL QTY='|| X_ATP_REC.AVAILABLE_QUANTITY ( 1 ) ||
349: 'SHIP_FROM_ORG_ID =' ||X_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ) ;
350: END IF;
351: END IF;
352:

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

351: END IF;
352:
353: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( 'ERROR IS' || X_MSG_DATA , 1 ) ;
356: END IF;
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
358: END IF;
359:

Line 371: oe_debug_pub.add( 'STATUS='||X_RETURN_STATUS|| ' X_ERROR_MESSAGE ='

367: ,x_error_message =>x_error_message
368: );
369:
370: IF l_debug_level > 0 THEN
371: oe_debug_pub.add( 'STATUS='||X_RETURN_STATUS|| ' X_ERROR_MESSAGE ='
372: ||X_ERROR_MESSAGE|| ' MSG DATA='||X_MSG_DATA ) ;
373: END IF;
374:
375: /* Commented the following code to fix fp bug 3498932 */

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

377:
378: IF nvl(x_return_status,'E') <> 'P' then
379:
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add( 'RETURN_STATUS<>P' ) ;
382: END IF;
383:
384: IF nvl(x_return_status,'E') <> 'E' THEN
385: IF nvl(x_atp_rec.available_quantity(1),0) = 0 then

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

384: IF nvl(x_return_status,'E') <> 'E' THEN
385: IF nvl(x_atp_rec.available_quantity(1),0) = 0 then
386:
387: IF l_debug_level > 0 THEN
388: oe_debug_pub.add( 'AVAILABLE QUANTITY IS 0' ) ;
389: END IF;
390: out_available_date := null;
391: out_available_qty := 0;
392:

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

412:
413: ELSE -- if status is P
414:
415: IF l_debug_level > 0 THEN
416: oe_debug_pub.add( 'RETURN_STATUS=P MESG='||X_ERROR_MESSAGE ) ;
417: END IF;
418: out_available_qty := x_error_message;
419: out_available_date := null;
420: x_error_message := null;

Line 453: oe_debug_pub.add( 'OUT_AVAL_QTY='||OUT_AVAILABLE_QTY|| ' SHIP_FORM_ORG_ID='||

449: END IF;
450:
451:
452: IF l_debug_level > 0 THEN
453: oe_debug_pub.add( 'OUT_AVAL_QTY='||OUT_AVAILABLE_QTY|| ' SHIP_FORM_ORG_ID='||
454: OUT_SHIP_FROM_ORG_ID|| ' UOM='||OUT_QTY_UOM);
455:
456:
457: IF x_atp_rec.ship_date.COUNT > 0 THEN

Line 458: oe_debug_pub.add(' OUT SHIP DATE='||X_ATP_REC.SHIP_DATE(1));

454: OUT_SHIP_FROM_ORG_ID|| ' UOM='||OUT_QTY_UOM);
455:
456:
457: IF x_atp_rec.ship_date.COUNT > 0 THEN
458: oe_debug_pub.add(' OUT SHIP DATE='||X_ATP_REC.SHIP_DATE(1));
459: END IF;
460:
461: IF x_atp_rec.group_ship_date.COUNT > 0 THEN
462: oe_debug_pub.add(' OUT GRP SHIP DATE='||X_ATP_REC.GROUP_SHIP_DATE(1));

Line 462: oe_debug_pub.add(' OUT GRP SHIP DATE='||X_ATP_REC.GROUP_SHIP_DATE(1));

458: oe_debug_pub.add(' OUT SHIP DATE='||X_ATP_REC.SHIP_DATE(1));
459: END IF;
460:
461: IF x_atp_rec.group_ship_date.COUNT > 0 THEN
462: oe_debug_pub.add(' OUT GRP SHIP DATE='||X_ATP_REC.GROUP_SHIP_DATE(1));
463: END IF;
464:
465: IF x_atp_rec.arrival_date.COUNT > 0 THEN
466: oe_debug_pub.add(' OUT ARRIVAL DATE='||X_ATP_REC.ARRIVAL_DATE(1));

Line 466: oe_debug_pub.add(' OUT ARRIVAL DATE='||X_ATP_REC.ARRIVAL_DATE(1));

462: oe_debug_pub.add(' OUT GRP SHIP DATE='||X_ATP_REC.GROUP_SHIP_DATE(1));
463: END IF;
464:
465: IF x_atp_rec.arrival_date.COUNT > 0 THEN
466: oe_debug_pub.add(' OUT ARRIVAL DATE='||X_ATP_REC.ARRIVAL_DATE(1));
467: END IF;
468:
469: IF x_atp_rec.requested_date_quantity.COUNT > 0 THEN
470: oe_debug_pub.add('REQ DATE QTY='||X_ATP_REC.REQUESTED_DATE_QUANTITY(1));

Line 470: oe_debug_pub.add('REQ DATE QTY='||X_ATP_REC.REQUESTED_DATE_QUANTITY(1));

466: oe_debug_pub.add(' OUT ARRIVAL DATE='||X_ATP_REC.ARRIVAL_DATE(1));
467: END IF;
468:
469: IF x_atp_rec.requested_date_quantity.COUNT > 0 THEN
470: oe_debug_pub.add('REQ DATE QTY='||X_ATP_REC.REQUESTED_DATE_QUANTITY(1));
471: END IF;
472: IF x_atp_rec.available_quantity.COUNT > 0 THEN
473: oe_debug_pub.add(' AVAILABLE QTY='||X_ATP_REC.AVAILABLE_QUANTITY(1));
474: END IF;

Line 473: oe_debug_pub.add(' AVAILABLE QTY='||X_ATP_REC.AVAILABLE_QUANTITY(1));

469: IF x_atp_rec.requested_date_quantity.COUNT > 0 THEN
470: oe_debug_pub.add('REQ DATE QTY='||X_ATP_REC.REQUESTED_DATE_QUANTITY(1));
471: END IF;
472: IF x_atp_rec.available_quantity.COUNT > 0 THEN
473: oe_debug_pub.add(' AVAILABLE QTY='||X_ATP_REC.AVAILABLE_QUANTITY(1));
474: END IF;
475:
476: END IF; -- if debug is on
477:

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

476: END IF; -- if debug is on
477:
478:
479: IF l_debug_level > 0 THEN
480: oe_debug_pub.add( 'EXITING CALL ATP' , 1 ) ;
481: END IF;
482:
483:
484: EXCEPTION

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

485:
486: WHEN OTHERS THEN
487:
488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
490: END IF;
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
493: END IF;

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

488: IF l_debug_level > 0 THEN
489: oe_debug_pub.add( 'WHEN OTHERS OF CALL_MRP_ATP' ) ;
490: END IF;
491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
493: END IF;
494: x_return_status := 'E';
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
496: -- Get message count and data

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

541: l_record OE_AK_ORDER_HEADERS_V%ROWTYPE;
542: l_out_record OE_AK_ORDER_HEADERS_V%ROWTYPE;
543:
544: --
545: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
546: --
547: l_bom_item_type Varchar2(1);
548: l_pick_components_flag Varchar2(1);
549: BEGIN

Line 553: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.DEFAULTING '|| ' ITEM_ID='||

549: BEGIN
550:
551:
552: IF l_debug_level > 0 THEN
553: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.DEFAULTING '|| ' ITEM_ID='||
554: IN_ITEM_ID|| ' SOURCE TYPE ='||IN_SOURCE|| ' ORG ID TYPE ='||IN_ORG_ID);
555: oe_debug_pub.add( ' CUSTOMER_ID ='||IN_CUSTOMER_ID|| ' SHIP_TO_ORG_ID ='||
556: IN_SHIP_TO_ORG_ID|| ' IN_BILL_TO_ORG_ID ='||IN_BILL_TO_ORG_ID
557: || ' IN_AGREEMENT_ID ='||IN_AGREEMENT_ID|| ' IN_ORDER_TYPE_ID ='

Line 555: oe_debug_pub.add( ' CUSTOMER_ID ='||IN_CUSTOMER_ID|| ' SHIP_TO_ORG_ID ='||

551:
552: IF l_debug_level > 0 THEN
553: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.DEFAULTING '|| ' ITEM_ID='||
554: IN_ITEM_ID|| ' SOURCE TYPE ='||IN_SOURCE|| ' ORG ID TYPE ='||IN_ORG_ID);
555: oe_debug_pub.add( ' CUSTOMER_ID ='||IN_CUSTOMER_ID|| ' SHIP_TO_ORG_ID ='||
556: IN_SHIP_TO_ORG_ID|| ' IN_BILL_TO_ORG_ID ='||IN_BILL_TO_ORG_ID
557: || ' IN_AGREEMENT_ID ='||IN_AGREEMENT_ID|| ' IN_ORDER_TYPE_ID ='
558: ||IN_ORDER_TYPE_ID ) ;
559: END IF;

Line 602: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM|| ' PRICE_LIST_ID='||

598: Null;
599: END;
600:
601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM|| ' PRICE_LIST_ID='||
603: OUT_PRICE_LIST_ID ) ;
604: END IF;
605:
606: ELSIF in_source = 'CUSTOMER' then

Line 609: oe_debug_pub.add( 'SOURCE = CUSTOMER' ) ;

605:
606: ELSIF in_source = 'CUSTOMER' then
607:
608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add( 'SOURCE = CUSTOMER' ) ;
610: END IF;
611: l_record.sold_to_org_id := in_customer_id;
612: l_record.org_id := in_org_id;
613: l_record.ship_to_org_id := in_ship_to_org_id;

Line 632: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM|| ' PRICE_LIST_ID='

628: out_wsh_id := l_out_record.ship_from_org_id;
629: out_price_list_id := l_out_record.price_list_id;
630:
631: IF l_debug_level > 0 THEN
632: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM|| ' PRICE_LIST_ID='
633: ||OUT_PRICE_LIST_ID ) ;
634: END IF;
635:
636: ELSIF in_source = 'SHIP_TO' then

Line 659: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM||

655: out_wsh_id := l_out_record.ship_from_org_id;
656: out_price_list_id := l_out_record.price_list_id;
657:
658: IF l_debug_level > 0 THEN
659: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM||
660: ' PRICE_LIST_ID='||OUT_PRICE_LIST_ID ) ;
661: END IF;
662:
663: ELSIF in_source = 'BILL_TO' then

Line 686: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM

682: out_uom := null;
683: out_price_list_id := l_out_record.price_list_id;
684:
685: IF l_debug_level > 0 THEN
686: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM
687: || ' PRICE_LIST_ID='||OUT_PRICE_LIST_ID ) ;
688: END IF;
689:
690: ELSIF in_source = 'AGREEMENT' then

Line 711: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||

707: out_uom := null;
708: out_price_list_id := l_out_rec.price_list_id;
709:
710: IF l_debug_level > 0 THEN
711: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||
712: OUT_UOM|| ' PRICE_LIST_ID='||OUT_PRICE_LIST_ID ) ;
713: END IF;
714:
715: ELSIF in_source = 'ORDER_TYPE' then

Line 737: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM

733: out_price_list_id := null;
734: out_wsh_id := null;
735:
736: IF l_debug_level > 0 THEN
737: oe_debug_pub.add( 'WSH_ID='||OUT_WSH_ID|| ' UOM='||OUT_UOM
738: || ' CONVERSION_TYPE_CODE='||OUT_CONVERSION_TYPE ) ;
739: END IF;
740:
741: ELSIF in_source = 'STARTUP' then

Line 766: oe_debug_pub.add( 'EXITING OE_AVAILABILITY.DEFAULTING' ) ;

762:
763: END IF; -- in source_type
764:
765: IF l_debug_level > 0 THEN
766: oe_debug_pub.add( 'EXITING OE_AVAILABILITY.DEFAULTING' ) ;
767: END IF;
768:
769: EXCEPTION
770:

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

833: l_arrival_set_name VARCHAR2(30);
834: l_arrival_date DATE := NULL;
835: l_sch_action varchar2(100) := 'OESCH_ACT_ATP_CHECK';
836: --
837: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
838: --
839: BEGIN
840:
841: x_return_status := 'S';

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

840:
841: x_return_status := 'S';
842: IF l_debug_level > 0 AND
843: p_atp_rec.error_code.COUNT > 0 THEN
844: oe_debug_pub.add( '2. ENTERING CHECK_RESULTS ERROR_CODE='|| P_ATP_REC.ERROR_CODE ( J ) ||
845: ' IN_GLOBAL_ORGS='||IN_GLOBAL_ORGS ) ;
846: END IF;
847:
848: IF p_atp_rec.error_code.COUNT > 0 AND

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

852:
853: THEN
854:
855: IF l_debug_level > 0 THEN
856: oe_debug_pub.add( 'ERROR FROM MRP: ' || P_ATP_REC.ERROR_CODE ( J ) , 1 ) ;
857: END IF;
858:
859: IF p_atp_rec.error_code(J) = 80 THEN
860:

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

866: where lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
867: and lookup_code = 80;
868:
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add( 'SETTING THE MESSAGE FOR OE_SCH_NO_SOURCE' ) ;
871: END IF;
872: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_SOURCE');
873: IF in_global_orgs = 'N' then
874:

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

880:
881: ELSE
882:
883: IF l_debug_level > 0 THEN
884: oe_debug_pub.add( 'SCH FAILED ERROR CODE='||P_ATP_REC.ERROR_CODE ( J ) ) ;
885: END IF;
886:
887: l_explanation := null;
888:

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

901: ELSIF p_atp_rec.error_code(J) = 61 THEN
902:
903: -- setting the status flag to partial for ATP not applicable
904: IF l_debug_level > 0 THEN
905: oe_debug_pub.add( 'ERROR CODE = 61' ) ;
906: END IF;
907:
908: x_return_status := 'P';
909: x_error_message := l_explanation;

Line 917: oe_debug_pub.add( 'ERROR CODE = 53' ) ;

913: ELSIF p_atp_rec.error_code(J) = 53 THEN
914:
915: x_return_status := 'E';
916: IF l_debug_level > 0 THEN
917: oe_debug_pub.add( 'ERROR CODE = 53' ) ;
918: END IF;
919:
920: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_AVA_NO_REQUESTED_QTY');
921: FND_MESSAGE.SET_TOKEN('PARTIAL_QUANTITY', p_atp_rec.requested_date_quantity(J));

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

939: null;
940:
941: ELSE
942: IF l_debug_level > 0 THEN
943: oe_debug_pub.add( 'ADDING MESSAGE TO THE STACK' , 1 ) ;
944: END IF;
945: --FND_MESSAGE.SET_NAME('ONT','OE_SCH_OE_ORDER_FAILED');
946: --FND_MESSAGE.SET_TOKEN('EXPLANATION',l_explanation);
947:

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

957:
958: END IF; -- 80
959:
960: IF l_debug_level > 0 THEN
961: oe_debug_pub.add( 'SETTING ERROR' , 1 ) ;
962: END IF;
963: IF x_return_status <> 'P' then
964: x_return_status := 'E';
965: END IF;

Line 970: oe_debug_pub.add( ' ELSE '||P_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ||

966:
967: ELSE
968:
969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add( ' ELSE '||P_ATP_REC.SOURCE_ORGANIZATION_ID ( 1 ) ||
971: ' ERROR CODE : ' || P_ATP_REC.ERROR_CODE ( J ) ) ;
972: END IF;
973:
974: -- Muti org changes.

Line 978: oe_debug_pub.add( 'ERROR CODE : ' || P_ATP_REC.ERROR_CODE ( J ) || 'IDENTIFIER : ' ||

974: -- Muti org changes.
975: IF (p_atp_rec.error_code(J) <> -99 ) THEN
976:
977: IF l_debug_level > 0 THEN
978: oe_debug_pub.add( 'ERROR CODE : ' || P_ATP_REC.ERROR_CODE ( J ) || 'IDENTIFIER : ' ||
979: P_ATP_REC.IDENTIFIER ( J ) || 'ITEM : ' ||
980: P_ATP_REC.INVENTORY_ITEM_ID ( J ));
981: oe_debug_pub.add( 'REQUEST SHIP DATE :' ||
982: TO_CHAR ( P_ATP_REC.REQUESTED_SHIP_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' )

Line 981: oe_debug_pub.add( 'REQUEST SHIP DATE :' ||

977: IF l_debug_level > 0 THEN
978: oe_debug_pub.add( 'ERROR CODE : ' || P_ATP_REC.ERROR_CODE ( J ) || 'IDENTIFIER : ' ||
979: P_ATP_REC.IDENTIFIER ( J ) || 'ITEM : ' ||
980: P_ATP_REC.INVENTORY_ITEM_ID ( J ));
981: oe_debug_pub.add( 'REQUEST SHIP DATE :' ||
982: TO_CHAR ( P_ATP_REC.REQUESTED_SHIP_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' )
983: || 'REQUEST ARRIVAL DATE :' || P_ATP_REC.REQUESTED_ARRIVAL_DATE ( J ));
984: oe_debug_pub.add( 'ARRIVAL DATE :' ||
985: TO_CHAR ( P_ATP_REC.ARRIVAL_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' ) ||

Line 984: oe_debug_pub.add( 'ARRIVAL DATE :' ||

980: P_ATP_REC.INVENTORY_ITEM_ID ( J ));
981: oe_debug_pub.add( 'REQUEST SHIP DATE :' ||
982: TO_CHAR ( P_ATP_REC.REQUESTED_SHIP_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' )
983: || 'REQUEST ARRIVAL DATE :' || P_ATP_REC.REQUESTED_ARRIVAL_DATE ( J ));
984: oe_debug_pub.add( 'ARRIVAL DATE :' ||
985: TO_CHAR ( P_ATP_REC.ARRIVAL_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' ) ||
986: 'SHIP DATE :' ||
987: TO_CHAR ( P_ATP_REC.SHIP_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' ));
988: oe_debug_pub.add( 'LEAD TIME :' ||P_ATP_REC.DELIVERY_LEAD_TIME ( J ) ||

Line 988: oe_debug_pub.add( 'LEAD TIME :' ||P_ATP_REC.DELIVERY_LEAD_TIME ( J ) ||

984: oe_debug_pub.add( 'ARRIVAL DATE :' ||
985: TO_CHAR ( P_ATP_REC.ARRIVAL_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' ) ||
986: 'SHIP DATE :' ||
987: TO_CHAR ( P_ATP_REC.SHIP_DATE ( J ) , 'DD-MON-RR:HH:MM:SS' ));
988: oe_debug_pub.add( 'LEAD TIME :' ||P_ATP_REC.DELIVERY_LEAD_TIME ( J ) ||
989: 'GROUP SHIP DATE :'||P_ATP_REC.GROUP_SHIP_DATE ( J ) ||
990: 'GROUP ARR DATE :'||P_ATP_REC.GROUP_ARRIVAL_DATE ( J ) ) ;
991: END IF;
992:

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

1002: and lookup_code = p_atp_rec.error_code(J) ;
1003:
1004: g_atp_tbl(atp_count).error_message := l_explanation;
1005: IF l_debug_level > 0 THEN
1006: oe_debug_pub.add( 'EXPLANATION IS : ' || L_EXPLANATION , 1 ) ;
1007: END IF;
1008: x_error_message := l_explanation;
1009:
1010: IF p_atp_rec.error_code(J) = 150 THEN

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

1028: --OE_MSG_PUB.Add;
1029:
1030: IF x_return_status ='E' and in_global_orgs = 'N' then
1031: IF l_debug_level > 0 THEN
1032: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
1033: END IF;
1034: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
1035: p_count => x_msg_count,
1036: p_data=>x_msg_data

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

1035: p_count => x_msg_count,
1036: p_data=>x_msg_data
1037: );
1038: IF l_debug_level > 0 THEN
1039: oe_debug_pub.add( 'COUNT = '||X_MSG_COUNT||' MSG='||X_MSG_DATA ) ;
1040: END IF;
1041: END IF;
1042:
1043: IF l_debug_level > 0 THEN

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

1040: END IF;
1041: END IF;
1042:
1043: IF l_debug_level > 0 THEN
1044: oe_debug_pub.add( 'EXITING CHECK_RESULTS: ' || X_RETURN_STATUS , 1 ) ;
1045: END IF;
1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN

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

1053: , 'Check_Results'
1054: );
1055: END IF;
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add( 'UNEXPECTED ERROR IN CHECK_RESULTS' ) ;
1058: END IF;
1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060:
1061: END Check_Results_from_rec;

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

1067:
1068: l_return_status varchar2(10);
1069:
1070: --
1071: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1072: --
1073: BEGIN
1074:
1075: IF l_debug_level > 0 THEN

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

1072: --
1073: BEGIN
1074:
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'EXTENDING THE TABLE BY ' || L_COUNT , 5 ) ;
1077: END IF;
1078:
1079: MSC_SATP_FUNC.Extend_ATP
1080: (p_atp_tab => p_x_atp_rec,

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

1159: l_lot_control_code NUMBER;
1160: l_org_id NUMBER;
1161:
1162: --
1163: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1164: --
1165: BEGIN
1166:
1167: IF l_debug_level > 0 THEN

Line 1168: oe_debug_pub.add( 'ENTERING QUERY_QTY_TREE'|| 'ORG IS : ' || P_ORG_ID

1164: --
1165: BEGIN
1166:
1167: IF l_debug_level > 0 THEN
1168: oe_debug_pub.add( 'ENTERING QUERY_QTY_TREE'|| 'ORG IS : ' || P_ORG_ID
1169: || 'ITEM IS : ' || P_ITEM_ID ) ;
1170: END IF;
1171:
1172: BEGIN

Line 1219: oe_debug_pub.add( 'RR: L_QOH ' || L_QOH|| 'RR: L_QOH ' || L_ATR ) ;

1215: , x_atr => l_atr
1216: );
1217:
1218: IF l_debug_level > 0 THEN
1219: oe_debug_pub.add( 'RR: L_QOH ' || L_QOH|| 'RR: L_QOH ' || L_ATR ) ;
1220: END IF;
1221:
1222: x_on_hand_qty := l_qoh;
1223: x_avail_to_reserve := l_atr;

Line 1226: oe_debug_pub.add( 'EXITING QUERY_QTY_TREE ' , 1 ) ;

1222: x_on_hand_qty := l_qoh;
1223: x_avail_to_reserve := l_atr;
1224:
1225: IF l_debug_level > 0 THEN
1226: oe_debug_pub.add( 'EXITING QUERY_QTY_TREE ' , 1 ) ;
1227: END IF;
1228:
1229: END Query_Qty_Tree;
1230:

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

1237:
1238: )IS
1239:
1240: --
1241: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1242: --
1243: BEGIN
1244: SELECT organization_code,
1245: name

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

1251: EXCEPTION
1252:
1253: WHEN OTHERS THEN
1254: IF l_debug_level > 0 THEN
1255: oe_debug_pub.add( 'GET_SHIP_FROM_ORG WHEN OTHERS '|| SQLCODE||SQLERRM ) ;
1256: END IF;
1257:
1258: END get_ship_From_org;
1259:

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

1267:
1268: l_line_index pls_integer := 0;
1269:
1270: --
1271: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1272: --
1273: BEGIN
1274:
1275: IF l_debug_level > 0 THEN

Line 1276: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.COPY_HEADER_TO_REQUEST' , 1 ) ;

1272: --
1273: BEGIN
1274:
1275: IF l_debug_level > 0 THEN
1276: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.COPY_HEADER_TO_REQUEST' , 1 ) ;
1277: END IF;
1278:
1279: l_line_index := l_line_index+1;
1280: px_req_line_tbl(l_line_index).REQUEST_TYPE_CODE :=p_Request_Type_Code;

Line 1305: oe_debug_pub.add( 'CURR='||G_panda_rec_table(1).p_CURRENCY||' REQ DATE='||

1301: px_req_line_tbl(l_line_index).Rounding_factor := Get_Rounding_factor(g_panda_rec_table(1).p_price_list_id);
1302: END IF;
1303: --End If;
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add( 'CURR='||G_panda_rec_table(1).p_CURRENCY||' REQ DATE='||
1306: G_panda_rec_table(1).p_REQUEST_DATE||' ROUNDING_FACTOR='||
1307: PX_REQ_LINE_TBL ( L_LINE_INDEX ) .ROUNDING_FACTOR ) ;
1308: END IF;
1309:

Line 1314: oe_debug_pub.add(' POPULATING HEADER RECORD INTO TEMP TABLE ***********');

1310: --px_req_line_tbl(l_line_index).price_request_code := p_header_rec.price_request_code; -- PROMOTIONS SEP/01
1311: --populating temp tables
1312: G_LINE_INDEX_TBL.delete;
1313: if l_debug_level > 0 then
1314: oe_debug_pub.add('********** POPULATING HEADER RECORD INTO TEMP TABLE *********************');
1315: --oe_debug_pub.add('line index is='||G_LINE_INDEX_TBL(l_line_index));
1316: end if;
1317: G_LINE_INDEX_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_INDEX;
1318: G_LINE_TYPE_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_TYPE_CODE;

Line 1315: --oe_debug_pub.add('line index is='||G_LINE_INDEX_TBL(l_line_index));

1311: --populating temp tables
1312: G_LINE_INDEX_TBL.delete;
1313: if l_debug_level > 0 then
1314: oe_debug_pub.add('********** POPULATING HEADER RECORD INTO TEMP TABLE *********************');
1315: --oe_debug_pub.add('line index is='||G_LINE_INDEX_TBL(l_line_index));
1316: end if;
1317: G_LINE_INDEX_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_INDEX;
1318: G_LINE_TYPE_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_TYPE_CODE;
1319: G_PRICING_EFFECTIVE_DATE_TBL(l_line_index) := TRUNC(px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE);

Line 1338: oe_debug_pub.add('the order line id'||G_LINE_ID_TBL(l_line_index));

1334: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1335: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
1336: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
1337: if l_debug_level >0 then
1338: oe_debug_pub.add('the order line id'||G_LINE_ID_TBL(l_line_index));
1339: end if;
1340: G_ROUNDING_FLAG_TBL(l_line_index) := NULL;
1341: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
1342: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;

Line 1360: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_HEADER_TO_REQUEST' ) ;

1356:
1357: --Temp Table population done
1358:
1359: IF l_debug_level > 0 THEN
1360: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_HEADER_TO_REQUEST' ) ;
1361: END IF;
1362:
1363: END copy_Header_to_request;
1364:

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

1376: v_discounting_privilege VARCHAR2(30);
1377: l_item_type_code VARCHAR2(30);
1378:
1379: --
1380: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1381: --
1382: begin
1383:
1384: IF l_debug_level > 0 THEN

Line 1385: oe_debug_pub.add( 'ENTERING OE_ORDER_ADJ_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;

1381: --
1382: begin
1383:
1384: IF l_debug_level > 0 THEN
1385: oe_debug_pub.add( 'ENTERING OE_ORDER_ADJ_PVT.COPY_LINE_TO_REQUEST' , 1 ) ;
1386: END IF;
1387:
1388: l_line_index := l_line_index+1;
1389: px_req_line_tbl(l_line_index).Line_id := g_line_id;

Line 1409: oe_debug_pub.add( 'QTY='||G_panda_rec_table(p_line_index).p_QTY||' UOM ='||

1405: px_req_line_tbl(l_line_index).CURRENCY_CODE :=g_panda_rec_table(p_line_index).p_currency;
1406: px_req_line_tbl(l_line_index).UNIT_PRICE := Null;
1407: --px_req_line_tbl(l_line_index).PERCENT_PRICE := p_Line_rec.unit_list_percent;
1408: IF l_debug_level > 0 THEN
1409: oe_debug_pub.add( 'QTY='||G_panda_rec_table(p_line_index).p_QTY||' UOM ='||
1410: G_panda_rec_table(p_line_index).p_UOM||' CURR='||G_panda_rec_table(p_line_index).p_CURRENCY ) ;
1411: END IF;
1412:
1413: /*If (p_Line_rec.service_period = p_Line_rec.Order_quantity_uom) Then

Line 1459: oe_debug_pub.add('Temp tables population for lines ******');

1455:
1456: --px_req_line_tbl(l_line_index).price_request_code := p_line_rec.price_request_code; -- PROMOTIONS SEP/01
1457: --px_req_line_tbl(l_line_index).line_category :=p_line_rec.line_category_code;
1458:
1459: oe_debug_pub.add('********Temp tables population for lines **************');
1460: oe_debug_pub.add('LINE INDEX'||l_line_index);
1461:
1462: G_LINE_INDEX_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_INDEX;
1463: G_LINE_TYPE_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_TYPE_CODE;

Line 1460: oe_debug_pub.add('LINE INDEX'||l_line_index);

1456: --px_req_line_tbl(l_line_index).price_request_code := p_line_rec.price_request_code; -- PROMOTIONS SEP/01
1457: --px_req_line_tbl(l_line_index).line_category :=p_line_rec.line_category_code;
1458:
1459: oe_debug_pub.add('********Temp tables population for lines **************');
1460: oe_debug_pub.add('LINE INDEX'||l_line_index);
1461:
1462: G_LINE_INDEX_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_INDEX;
1463: G_LINE_TYPE_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_TYPE_CODE;
1464: G_PRICING_EFFECTIVE_DATE_TBL(l_line_index):= TRUNC(px_req_line_tbl(l_line_index).PRICING_EFFECTIVE_DATE);

Line 1471: oe_debug_pub.add( 'QUANTITY'||PX_REQ_LINE_TBL(L_LINE_INDEX).LINE_QUANTITY||' '||

1467: G_ACTIVE_DATE_SECOND_TBL(l_line_index) := TRUNC(px_req_line_tbl(l_line_index).ACTIVE_DATE_SECOND);
1468: G_ACTIVE_DATE_SECOND_TYPE_TBL(l_line_index):= px_req_line_tbl(l_line_index).ACTIVE_DATE_SECOND_TYPE;
1469: --px_req_line_tbl(l_line_index).priced_quantity := NULL;
1470: IF l_debug_level > 0 THEN
1471: oe_debug_pub.add( 'QUANTITY'||PX_REQ_LINE_TBL(L_LINE_INDEX).LINE_QUANTITY||' '||
1472: PX_REQ_LINE_TBL(L_LINE_INDEX).PRICED_QUANTITY , 3 ) ;
1473: END IF;
1474: IF l_debug_level > 0 THEN
1475: oe_debug_pub.add( 'PRICE FLAG'||PX_REQ_LINE_TBL(L_LINE_INDEX).PRICE_FLAG ) ;

Line 1475: oe_debug_pub.add( 'PRICE FLAG'||PX_REQ_LINE_TBL(L_LINE_INDEX).PRICE_FLAG ) ;

1471: oe_debug_pub.add( 'QUANTITY'||PX_REQ_LINE_TBL(L_LINE_INDEX).LINE_QUANTITY||' '||
1472: PX_REQ_LINE_TBL(L_LINE_INDEX).PRICED_QUANTITY , 3 ) ;
1473: END IF;
1474: IF l_debug_level > 0 THEN
1475: oe_debug_pub.add( 'PRICE FLAG'||PX_REQ_LINE_TBL(L_LINE_INDEX).PRICE_FLAG ) ;
1476: END IF;
1477: G_LINE_QUANTITY_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_QUANTITY;
1478:
1479: G_LINE_UOM_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_UOM_CODE;

Line 1486: oe_debug_pub.add( 'UNIT PRICE'||PX_REQ_LINE_TBL(L_LINE_INDEX).UNIT_PRICE||' '||

1482: G_UOM_QUANTITY_TBL(l_line_index) := NULL;
1483: G_PRICED_UOM_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICED_UOM_CODE;
1484: G_CURRENCY_CODE_TBL(l_line_index) := px_req_line_tbl(l_line_index).CURRENCY_CODE;
1485: IF l_debug_level > 0 THEN
1486: oe_debug_pub.add( 'UNIT PRICE'||PX_REQ_LINE_TBL(L_LINE_INDEX).UNIT_PRICE||' '||
1487: PX_REQ_LINE_TBL(L_LINE_INDEX).ADJUSTED_UNIT_PRICE ) ;
1488: END IF;
1489: G_UNIT_PRICE_TBL(l_line_index) := px_req_line_tbl(l_line_index).unit_price; -- AG
1490: G_PERCENT_PRICE_TBL(l_line_index) := NULL;

Line 1496: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( L_LINE_INDEX ) ) ;

1492: G_PROCESSED_FLAG_TBL(l_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1493: G_PRICE_FLAG_TBL(l_line_index) := px_req_line_tbl(l_line_index).PRICE_FLAG;
1494: G_LINE_ID_TBL(l_line_index) := px_req_line_tbl(l_line_index).LINE_ID;
1495: IF l_debug_level > 0 THEN
1496: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( L_LINE_INDEX ) ) ;
1497: END IF;
1498: G_ROUNDING_FLAG_TBL(l_line_index) := NULL; -- AG
1499: G_ROUNDING_FACTOR_TBL(l_line_index) := px_req_line_tbl(l_line_index).ROUNDING_FACTOR;
1500: G_PROCESSING_ORDER_TBL(l_line_index) := NULL;

Line 1514: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_LINE_TO_REQUEST' , 1 ) ;

1510: G_LINE_CATEGORY_TBL(l_line_index) := NULL;
1511:
1512:
1513: IF l_debug_level > 0 THEN
1514: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_LINE_TO_REQUEST' , 1 ) ;
1515: END IF;
1516:
1517: END copy_Line_to_request;
1518:

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

1522: l_Control_Rec in out nocopy QP_PREQ_GRP.CONTROL_RECORD_TYPE
1523: ,in_pricing_event in varchar2)IS
1524:
1525: --
1526: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1527: --
1528: BEGIN
1529:
1530: l_control_rec.pricing_event := in_pricing_event;

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

1559: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1560: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1561:
1562: --
1563: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1564: l_pass_line VARCHAR2(1) :='N';
1565: --
1566: BEGIN
1567:

Line 1569: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;

1565: --
1566: BEGIN
1567:
1568: IF l_debug_level > 0 THEN
1569: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1570: END IF;
1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||

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

1569: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1570: END IF;
1571:
1572: IF l_debug_level > 0 THEN
1573: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||
1574: G_panda_rec_table(p_line_index).p_PRICING_DATE|| ' INV ITEM_IE='
1575: ||' master_org='||l_master_org_id
1576: ||G_panda_rec_table(p_line_index).p_INVENTORY_ITEM_ID);
1577: oe_debug_pub.add( ' AGREEMENT_ID='||G_panda_rec_table(p_line_index).p_AGREEMENT_ID||

Line 1577: oe_debug_pub.add( ' AGREEMENT_ID='||G_panda_rec_table(p_line_index).p_AGREEMENT_ID||

1573: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||
1574: G_panda_rec_table(p_line_index).p_PRICING_DATE|| ' INV ITEM_IE='
1575: ||' master_org='||l_master_org_id
1576: ||G_panda_rec_table(p_line_index).p_INVENTORY_ITEM_ID);
1577: oe_debug_pub.add( ' AGREEMENT_ID='||G_panda_rec_table(p_line_index).p_AGREEMENT_ID||
1578: ' REQ DATE='||G_panda_rec_table(p_line_index).p_REQUEST_DATE||
1579: ' SHIP_TO_ORG_ID='||G_panda_rec_table(p_line_index).p_SHIP_TO_ORG_ID||
1580: ' INVOICE_TO_ORG_ID='||G_panda_rec_table(p_line_index).p_INVOICE_TO_ORG_ID ) ;
1581: END IF;

Line 1584: oe_debug_pub.add( 'QTY='||G_panda_rec_table(p_line_index).p_QTY||

1580: ' INVOICE_TO_ORG_ID='||G_panda_rec_table(p_line_index).p_INVOICE_TO_ORG_ID ) ;
1581: END IF;
1582:
1583: IF l_debug_level > 0 THEN
1584: oe_debug_pub.add( 'QTY='||G_panda_rec_table(p_line_index).p_QTY||
1585: ' ITEM_TYPE_CODE='||P_ITEM_TYPE_CODE||
1586: ' PRICE_LIST_ID='||G_panda_rec_table(p_line_index).p_PRICE_LIST_ID||
1587: ' CUST_ID='||G_panda_rec_table(p_line_index).p_CUSTOMER_ID||
1588: ' PRICE REQ CODE='||P_PRICE_REQUEST_CODE||

Line 1643: oe_debug_pub.add('l_PASS_LINE'||l_pass_line);

1639: ,p_pricing_contexts_tbl => p_pricing_contexts_Tbl
1640: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1641: );*/
1642: IF l_debug_level > 0 THEN
1643: oe_debug_pub.add('l_PASS_LINE'||l_pass_line);
1644: END IF;
1645:
1646: IF l_debug_level > 0 THEN
1647: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;

Line 1647: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;

1643: oe_debug_pub.add('l_PASS_LINE'||l_pass_line);
1644: END IF;
1645:
1646: IF l_debug_level > 0 THEN
1647: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR LINE' , 1 ) ;
1648: END IF;
1649:
1650: EXCEPTION
1651: when no_data_found then

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

1671: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1672: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1673:
1674: --
1675: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1676: --
1677: BEGIN
1678:
1679: IF l_debug_level > 0 THEN

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

1676: --
1677: BEGIN
1678:
1679: IF l_debug_level > 0 THEN
1680: oe_debug_pub.add( 'BEFORE QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1681: END IF;
1682:
1683:
1684: IF l_debug_level > 0 THEN

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

1681: END IF;
1682:
1683:
1684: IF l_debug_level > 0 THEN
1685: oe_debug_pub.add( 'ORG_ID='||L_ORG_ID|| ' PRICING_DATE='||
1686: G_panda_rec_table(1).p_PRICING_DATE|| ' AGREEMENT_ID='||
1687: G_panda_rec_table(1).p_AGREEMENT_ID|| ' REQ DATE='||
1688: G_panda_rec_table(1).p_REQUEST_DATE|| ' SHIP_TO_ORG_ID='||
1689: G_panda_rec_table(1).p_SHIP_TO_ORG_ID|| ' INVOICE_TO_ORG_ID='||

Line 1694: oe_debug_pub.add( 'QTY='||G_panda_rec_table(1).p_QTY||

1690: G_panda_rec_table(1).p_INVOICE_TO_ORG_ID ) ;
1691: END IF;
1692:
1693: IF l_debug_level > 0 THEN
1694: oe_debug_pub.add( 'QTY='||G_panda_rec_table(1).p_QTY||
1695: ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID||
1696: ' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' PRICE REQ CODE='||
1697: P_PRICE_REQUEST_CODE ) ;
1698: END IF;

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

1750: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1751: );*/
1752:
1753: IF l_debug_level > 0 THEN
1754: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1755: END IF;
1756:
1757: EXCEPTION
1758: when no_data_found then

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

1776:
1777: i pls_integer;
1778:
1779: --
1780: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1781:
1782: --
1783: BEGIN
1784:

Line 1786: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;

1782: --
1783: BEGIN
1784:
1785: IF l_debug_level > 0 THEN
1786: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;
1787: END IF;
1788:
1789: IF g_panda_rec_table(p_g_line_index).p_pricing_attribute1 is not null then
1790: i := px_Req_line_attr_tbl.count+1;

Line 2695: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;

2691: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From:=g_panda_rec_table(p_g_line_index).p_pricing_attribute100;
2692: end if;
2693:
2694: IF l_debug_level > 0 THEN
2695: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;
2696: END IF;
2697:
2698: END Append_attributes;
2699:

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

2701: )
2702: IS
2703: i number;
2704: k number;
2705: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2706: l_attribute_type VARCHAR2(30);
2707: BEGIN
2708: --Temp Tables
2709: k:=G_ATTR_PRICING_ATTRIBUTE_TBL.count;

Line 2712: oe_debug_pub.add('populating attributes in to temp table ******');

2708: --Temp Tables
2709: k:=G_ATTR_PRICING_ATTRIBUTE_TBL.count;
2710: i := px_req_line_attr_tbl.first;
2711: if l_debug_level >0 then
2712: oe_debug_pub.add('****populating attributes in to temp table **********');
2713: end if;
2714:
2715: if l_debug_level > 0 then
2716:

Line 2717: oe_debug_pub.add('k='||k||'i='||i);

2713: end if;
2714:
2715: if l_debug_level > 0 then
2716:
2717: oe_debug_pub.add('k='||k||'i='||i);
2718: end if;
2719:
2720: while i is not null loop
2721: k:=k+1;

Line 2723: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;

2719:
2720: while i is not null loop
2721: k:=k+1;
2722: IF l_debug_level > 0 THEN
2723: oe_debug_pub.add( 'POPULATE LINE ATTRS'||K||' '||PX_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT , 3 ) ;
2724: END IF;
2725:
2726: IF (px_req_line_attr_tbl(I).PRICING_CONTEXT = QP_PREQ_GRP.G_ITEM_CONTEXT) THEN
2727: l_attribute_type := QP_PREQ_GRP.G_PRODUCT_TYPE;

Line 2735: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;

2731: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
2732: END IF;
2733: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
2734: IF l_debug_level > 0 THEN
2735: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
2736: END IF;
2737: G_ATTR_LINE_DETAIL_INDEX_tbl(k) := NULL;
2738: G_ATTR_ATTRIBUTE_LEVEL_tbl(k) := QP_PREQ_GRP.G_LINE_LEVEL;
2739: G_ATTR_VALIDATED_FLAG_tbl(k) := 'N';

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

2781:
2782:
2783: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
2784: --
2785: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2786: --
2787: BEGIN
2788: G_LINE_INDEX_tbl.delete;
2789: G_LINE_TYPE_CODE_TBL.delete ;

Line 2849: oe_debug_pub.add( L_ROUTINE||': '||SQLERRM , 1 ) ;

2845: G_ATTR_PRIMARY_UOM_FLAG_TBL.delete;
2846: EXCEPTION
2847: WHEN OTHERS THEN
2848: IF l_debug_level > 0 THEN
2849: oe_debug_pub.add( L_ROUTINE||': '||SQLERRM , 1 ) ;
2850: END IF;
2851: END reset_all_tbls;
2852:
2853:

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

2855: IS
2856: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2857: l_return_status_Text varchar2(240) ;
2858: --
2859: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2860: --
2861: BEGIN
2862: IF l_debug_level > 0 THEN
2863: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;

Line 2863: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;

2859: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2860: --
2861: BEGIN
2862: IF l_debug_level > 0 THEN
2863: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
2864: END IF;
2865: QP_PREQ_GRP.INSERT_LINES2
2866: (p_LINE_INDEX => G_LINE_INDEX_TBL,
2867: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,

Line 2906: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;

2902: x_status_text =>l_return_status_text);
2903:
2904: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2905: IF l_debug_level > 0 THEN
2906: oe_debug_pub.add( 'WRONG IN INSERT_LINES2'||L_RETURN_STATUS_TEXT , 1 ) ;
2907: END IF;
2908: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2909: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2910: OE_MSG_PUB.Add;

Line 2951: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;

2947: l_return_status_text );
2948:
2949: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2950: IF l_debug_level > 0 THEN
2951: oe_debug_pub.add( 'ERROR INSERTING INTO LINE ATTRS'||SQLERRM ) ;
2952: END IF;
2953: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS'); --bug#7149497
2954: FND_MESSAGE.SET_TOKEN('ERR_TEXT',l_return_status_text);
2955: OE_MSG_PUB.Add;

Line 2961: oe_debug_pub.add( 'AFTER DIRECT INSERT INTO TEMP TABLE: BULK INSERT' , 1 ) ;

2957: END IF;
2958:
2959: END IF;
2960: IF l_debug_level > 0 THEN
2961: oe_debug_pub.add( 'AFTER DIRECT INSERT INTO TEMP TABLE: BULK INSERT' , 1 ) ;
2962: END IF;
2963:
2964: EXCEPTION
2965: WHEN OTHERS THEN

Line 3142: oe_debug_pub.add('----Before populate l_line_tbl-----');

3138:
3139: BEGIN
3140:
3141:
3142: oe_debug_pub.add('----Before populate l_line_tbl-----');
3143: oe_debug_pub.add('----Line information return back to caller----');
3144:
3145: FOR l_line IN l_lines_cur LOOP
3146: --requirement from Jay, will cause holes in pl/sql table.

Line 3143: oe_debug_pub.add('----Line information return back to caller----');

3139: BEGIN
3140:
3141:
3142: oe_debug_pub.add('----Before populate l_line_tbl-----');
3143: oe_debug_pub.add('----Line information return back to caller----');
3144:
3145: FOR l_line IN l_lines_cur LOOP
3146: --requirement from Jay, will cause holes in pl/sql table.
3147: I := l_line.LINE_INDEX;

Line 3185: oe_debug_pub.add('----Line detail information return back to caller----');

3181:
3182:
3183: --Populate Line detail
3184:
3185: oe_debug_pub.add('----Line detail information return back to caller----');
3186:
3187: FOR l_dets IN l_ldets_cur LOOP
3188:
3189: oe_debug_pub.add('----populating line detail output------');

Line 3189: oe_debug_pub.add('----populating line detail output------');

3185: oe_debug_pub.add('----Line detail information return back to caller----');
3186:
3187: FOR l_dets IN l_ldets_cur LOOP
3188:
3189: oe_debug_pub.add('----populating line detail output------');
3190: --requirement by Jay, will cause holes in pl/sql tbl
3191: I := l_dets.line_detail_index;
3192: x_line_detail_tbl(I).LINE_DETAIL_INDEX := l_dets.LINE_DETAIL_INDEX;
3193: x_line_detail_tbl(I).LINE_DETAIL_TYPE_CODE:=l_dets.LINE_DETAIL_TYPE_CODE;

Line 3254: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));

3250: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
3251:
3252: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
3253: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3254: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3255: --END IF;
3256: END IF;
3257:
3258: x_line_detail_tbl(I).EXPIRATION_DATE :=l_expiration_period_end_date;

Line 3264: oe_debug_pub.add('----Before populate x_qual_tbl-----');

3260: I:=1;
3261:
3262: --Populate Qualifier detail
3263: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3264: oe_debug_pub.add('----Before populate x_qual_tbl-----');
3265: --END IF;
3266: FOR l_qual IN l_qual_cur(QP_PREQ_GRP.G_DETAIL_LEVEL) LOOP
3267: x_line_detail_qual_tbl(I).LINE_DETAIL_INDEX := l_qual.LINE_DETAIL_INDEX;
3268: x_line_detail_qual_tbl(I).QUALIFIER_CONTEXT := l_qual.CONTEXT;

Line 3282: oe_debug_pub.add('----Before populate attr_tbl-----');

3278: I:=1;
3279:
3280: --LINE ATTRIBUTE DETAIL NEEDED
3281: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3282: oe_debug_pub.add('----Before populate attr_tbl-----');
3283: --END IF;
3284: FOR l_prc IN l_pricing_attr_cur LOOP
3285: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3286: oe_debug_pub.add('--------populating x_line_detail_attr----------');

Line 3286: oe_debug_pub.add('--------populating x_line_detail_attr----------');

3282: oe_debug_pub.add('----Before populate attr_tbl-----');
3283: --END IF;
3284: FOR l_prc IN l_pricing_attr_cur LOOP
3285: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3286: oe_debug_pub.add('--------populating x_line_detail_attr----------');
3287: oe_debug_pub.add('Line Detail Index: '||l_prc.LINE_DETAIL_INDEX);
3288: --END IF;
3289: x_line_detail_attr_tbl(I).LINE_DETAIL_INDEX := l_prc.LINE_DETAIL_INDEX;
3290: x_line_detail_attr_tbl(I).PRICING_CONTEXT := l_prc.PRICING_CONTEXT;

Line 3287: oe_debug_pub.add('Line Detail Index: '||l_prc.LINE_DETAIL_INDEX);

3283: --END IF;
3284: FOR l_prc IN l_pricing_attr_cur LOOP
3285: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3286: oe_debug_pub.add('--------populating x_line_detail_attr----------');
3287: oe_debug_pub.add('Line Detail Index: '||l_prc.LINE_DETAIL_INDEX);
3288: --END IF;
3289: x_line_detail_attr_tbl(I).LINE_DETAIL_INDEX := l_prc.LINE_DETAIL_INDEX;
3290: x_line_detail_attr_tbl(I).PRICING_CONTEXT := l_prc.PRICING_CONTEXT;
3291: x_line_detail_attr_tbl(I).PRICING_ATTRIBUTE := l_prc.PRICING_ATTRIBUTE;

Line 3303: oe_debug_pub.add('----Before populate l_rltd_lines_tbl-----');

3299:
3300: I:=1;
3301:
3302: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3303: oe_debug_pub.add('----Before populate l_rltd_lines_tbl-----');
3304: --END IF;
3305: FOR l_rltd IN l_rltd_lines_cur LOOP
3306: x_related_lines_tbl(I).LINE_INDEX := l_rltd.Line_index;
3307: x_related_lines_tbl(I).LINE_DETAIL_INDEX := l_rltd.LINE_DETAIL_INDEX;

Line 3319: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));

3315:
3316: EXCEPTION
3317: WHEN E_ROUTINE_ERROR THEN
3318: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3319: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3320: -- END IF;
3321:
3322: END Populate_results;
3323:

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

3346: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3347: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3348:
3349: --
3350: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3351: --
3352: BEGIN
3353:
3354: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;

Line 3358: oe_debug_pub.add( 'SETTING REQUEST ID' , 1 ) ;

3354: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;
3355: reset_all_tbls;
3356:
3357: IF l_debug_level > 0 THEN
3358: oe_debug_pub.add( 'SETTING REQUEST ID' , 1 ) ;
3359: END IF;
3360:
3361: qp_price_request_context.set_request_id;
3362:

Line 3364: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;

3360:
3361: qp_price_request_context.set_request_id;
3362:
3363: IF l_debug_level > 0 THEN
3364: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
3365: END IF;
3366:
3367:
3368: OE_ORDER_PUB.G_HDR:=NULL;

Line 3432: oe_Debug_pub.add(' Populating the attr tables');

3428: ,px_Req_qual_tbl => l_req_qual_tbl
3429: ,p_g_line_index =>1
3430: );
3431:
3432: oe_Debug_pub.add(' Populating the attr tables');
3433: append_attr_to_TTables(px_req_line_attr_tbl=>l_req_line_attr_tbl);
3434:
3435: out_req_line_tbl(1).status_Code := null;
3436: out_req_line_tbl(1).status_text := null;

Line 3442: oe_Debug_pub.add(' Populating the temp tables');

3438: IF l_debug_level > 0 THEN
3439: print_time('Calling PE');
3440: END IF;
3441:
3442: oe_Debug_pub.add(' Populating the temp tables');
3443: populate_temp_table;
3444:
3445: QP_PREQ_PUB.PRICE_REQUEST
3446: (p_control_rec =>l_control_rec,

Line 3454: oe_debug_pub.add('After caling the pricing engine');

3450:
3451: IF l_debug_level > 0 THEN
3452: print_time('After Calling PE');
3453: END IF;
3454: oe_debug_pub.add('After caling the pricing engine');
3455:
3456: populate_results(
3457: x_line_tbl =>out_req_line_tbl
3458: ,x_line_qual_tbl =>out_Req_qual_tbl

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

3466: print_time('After populating the pl/sql records');
3467: END IF;
3468:
3469: IF l_debug_level > 0 THEN
3470: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
3471: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
3472: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
3473: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
3474: END IF;

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

3467: END IF;
3468:
3469: IF l_debug_level > 0 THEN
3470: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
3471: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
3472: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
3473: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
3474: END IF;
3475:

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

3468:
3469: IF l_debug_level > 0 THEN
3470: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
3471: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
3472: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
3473: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
3474: END IF;
3475:
3476: if out_req_line_tbl.count > 0 then

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

3469: IF l_debug_level > 0 THEN
3470: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
3471: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
3472: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
3473: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
3474: END IF;
3475:
3476: if out_req_line_tbl.count > 0 then
3477: for i in out_req_line_tbl.first..out_req_line_tbl.last

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

3477: for i in out_req_line_tbl.first..out_req_line_tbl.last
3478: loop
3479:
3480: IF l_debug_level > 0 THEN
3481: oe_debug_pub.add( '*******************************' ) ;
3482: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3483: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3484: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;

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

3478: loop
3479:
3480: IF l_debug_level > 0 THEN
3481: oe_debug_pub.add( '*******************************' ) ;
3482: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3483: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3484: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;

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

3479:
3480: IF l_debug_level > 0 THEN
3481: oe_debug_pub.add( '*******************************' ) ;
3482: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3483: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3484: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;

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

3480: IF l_debug_level > 0 THEN
3481: oe_debug_pub.add( '*******************************' ) ;
3482: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3483: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3484: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;

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

3481: oe_debug_pub.add( '*******************************' ) ;
3482: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3483: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3484: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;

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

3482: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3483: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3484: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;

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

3483: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3484: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;

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

3484: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;

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

3485: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;

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

3486: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;

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

3487: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;

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

3488: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;

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

3489: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;

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

3490: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;

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

3491: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;

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

3492: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;

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

3493: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;

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

3494: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;

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

3495: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;

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

3496: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;

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

3497: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;

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

3498: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3506: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;

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

3499: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3506: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3507: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;

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

3500: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3506: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3507: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3508: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;

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

3501: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3506: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3507: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3508: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3509: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;

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

3502: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3506: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3507: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3508: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3509: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
3510: END IF;

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

3503: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3506: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3507: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3508: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3509: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
3510: END IF;
3511: end loop;

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

3504: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3506: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3507: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3508: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3509: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
3510: END IF;
3511: end loop;
3512: end if;

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

3505: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3506: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3507: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3508: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3509: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
3510: END IF;
3511: end loop;
3512: end if;
3513:

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

3511: end loop;
3512: end if;
3513:
3514: IF l_debug_level > 0 THEN
3515: oe_debug_pub.add( 'COUNT LINE DETAIL TABLE='||OUT_REQ_LINE_DETAIL_TBL.COUNT ) ;
3516: END IF;
3517:
3518: if out_req_line_detail_tbl.count > 0 then
3519:

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

3520: for i in out_req_line_detail_tbl.first..out_req_line_detail_tbl.last
3521: loop
3522:
3523: IF l_debug_level > 0 THEN
3524: oe_debug_pub.add( 'LINE DETAIL TABLE RECORD='||I ) ;
3525: END IF;
3526:
3527: IF out_req_line_detail_tbl.exists(i) then
3528:

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

3526:
3527: IF out_req_line_detail_tbl.exists(i) then
3528:
3529: IF l_debug_level > 0 THEN
3530: oe_debug_pub.add( '*******************************' ) ;
3531: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3532: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3533: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;

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

3527: IF out_req_line_detail_tbl.exists(i) then
3528:
3529: IF l_debug_level > 0 THEN
3530: oe_debug_pub.add( '*******************************' ) ;
3531: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3532: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3533: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;

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

3528:
3529: IF l_debug_level > 0 THEN
3530: oe_debug_pub.add( '*******************************' ) ;
3531: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3532: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3533: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;

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

3529: IF l_debug_level > 0 THEN
3530: oe_debug_pub.add( '*******************************' ) ;
3531: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3532: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3533: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;

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

3530: oe_debug_pub.add( '*******************************' ) ;
3531: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3532: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3533: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;

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

3531: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3532: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3533: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;

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

3532: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3533: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;

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

3533: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;

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

3534: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);

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

3535: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;

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

3536: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;

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

3537: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;

Line 3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);

3538: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3546: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;

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

3539: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3546: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3547: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;

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

3540: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3546: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3547: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3548: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );

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

3541: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3546: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3547: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3548: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3549: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);

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

3542: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3546: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3547: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3548: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3549: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);
3550: end if;

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

3543: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3546: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3547: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3548: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3549: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);
3550: end if;
3551: end if;

Line 3548: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );

3544: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3546: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3547: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3548: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3549: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);
3550: end if;
3551: end if;
3552: end loop;

Line 3549: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);

3545: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3546: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3547: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3548: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3549: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);
3550: end if;
3551: end if;
3552: end loop;
3553:

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

3554: end if;
3555:
3556:
3557: IF l_debug_level > 0 THEN
3558: oe_debug_pub.add( 'COUNT LINE DETAIL ATTR TBL='|| OUT_REQ_LINE_DETAIL_ATTR_TBL.COUNT ) ;
3559: END IF;
3560:
3561: if out_req_line_detail_attr_tbl.count > 0 then
3562: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last

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

3561: if out_req_line_detail_attr_tbl.count > 0 then
3562: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
3563: loop
3564: IF l_debug_level > 0 THEN
3565: oe_debug_pub.add( '*******************************' ) ;
3566: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3567: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3568: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3569: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

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

3562: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
3563: loop
3564: IF l_debug_level > 0 THEN
3565: oe_debug_pub.add( '*******************************' ) ;
3566: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3567: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3568: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3569: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3570: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

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

3563: loop
3564: IF l_debug_level > 0 THEN
3565: oe_debug_pub.add( '*******************************' ) ;
3566: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3567: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3568: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3569: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3570: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3571: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

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

3564: IF l_debug_level > 0 THEN
3565: oe_debug_pub.add( '*******************************' ) ;
3566: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3567: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3568: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3569: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3570: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3571: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3572: END IF;

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

3565: oe_debug_pub.add( '*******************************' ) ;
3566: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3567: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3568: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3569: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3570: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3571: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3572: END IF;
3573:

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

3566: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3567: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3568: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3569: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3570: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3571: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3572: END IF;
3573:
3574: end loop;

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

3567: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3568: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3569: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3570: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3571: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3572: END IF;
3573:
3574: end loop;
3575: end if;

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

3575: end if;
3576:
3577:
3578: IF l_debug_level > 0 THEN
3579: oe_debug_pub.add( 'COUNT LINE ATTR TBL='||OUT_REQ_LINE_ATTR_TBL.COUNT ) ;
3580: END IF;
3581:
3582: if out_req_line_attr_tbl.count > 0 then
3583: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last

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

3582: if out_req_line_attr_tbl.count > 0 then
3583: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
3584: loop
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( '*******************************' ) ;
3587: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3588: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3589: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3590: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

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

3583: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
3584: loop
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( '*******************************' ) ;
3587: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3588: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3589: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3590: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3591: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

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

3584: loop
3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( '*******************************' ) ;
3587: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3588: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3589: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3590: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3591: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3592: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

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

3585: IF l_debug_level > 0 THEN
3586: oe_debug_pub.add( '*******************************' ) ;
3587: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3588: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3589: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3590: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3591: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3592: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3593: END IF;

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

3586: oe_debug_pub.add( '*******************************' ) ;
3587: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3588: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3589: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3590: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3591: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3592: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3593: END IF;
3594:

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

3587: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3588: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3589: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3590: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3591: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3592: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3593: END IF;
3594:
3595: end loop;

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

3588: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3589: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3590: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3591: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3592: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3593: END IF;
3594:
3595: end loop;
3596: end if;

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

3596: end if;
3597:
3598:
3599: IF l_debug_level > 0 THEN
3600: oe_debug_pub.add( 'COUNT RELATED LINES TBL='|| OUT_REQ_RELATED_LINES_TBL.COUNT ) ;
3601: END IF;
3602:
3603: if out_req_related_lines_tbl.count > 0 then
3604: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last

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

3603: if out_req_related_lines_tbl.count > 0 then
3604: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
3605: loop
3606: IF l_debug_level > 0 THEN
3607: oe_debug_pub.add( '*******************************' ) ;
3608: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3609: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3610: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3611: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;

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

3604: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
3605: loop
3606: IF l_debug_level > 0 THEN
3607: oe_debug_pub.add( '*******************************' ) ;
3608: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3609: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3610: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3611: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3612: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;

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

3605: loop
3606: IF l_debug_level > 0 THEN
3607: oe_debug_pub.add( '*******************************' ) ;
3608: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3609: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3610: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3611: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3612: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3613: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;

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

3606: IF l_debug_level > 0 THEN
3607: oe_debug_pub.add( '*******************************' ) ;
3608: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3609: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3610: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3611: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3612: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3613: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
3614: END IF;

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

3607: oe_debug_pub.add( '*******************************' ) ;
3608: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3609: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3610: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3611: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3612: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3613: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
3614: END IF;
3615:

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

3608: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3609: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3610: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3611: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3612: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3613: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
3614: END IF;
3615:
3616: end loop;

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

3609: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3610: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3611: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3612: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3613: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
3614: END IF;
3615:
3616: end loop;
3617: end if;

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

3617: end if;
3618:
3619:
3620: IF l_debug_level > 0 THEN
3621: oe_debug_pub.add( 'COUNT LINE QUAL TBL='||OUT_REQ_QUAL_TBL.COUNT ) ;
3622: END IF;
3623:
3624: if out_req_qual_tbl.count > 0 then
3625: for i in out_req_qual_tbl.first..out_req_qual_tbl.last

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

3624: if out_req_qual_tbl.count > 0 then
3625: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
3626: loop
3627: IF l_debug_level > 0 THEN
3628: oe_debug_pub.add('*******************************' ) ;
3629: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3630: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3631: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

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

3625: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
3626: loop
3627: IF l_debug_level > 0 THEN
3628: oe_debug_pub.add('*******************************' ) ;
3629: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3630: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3631: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3633: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

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

3626: loop
3627: IF l_debug_level > 0 THEN
3628: oe_debug_pub.add('*******************************' ) ;
3629: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3630: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3631: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3633: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3634: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

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

3627: IF l_debug_level > 0 THEN
3628: oe_debug_pub.add('*******************************' ) ;
3629: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3630: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3631: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3633: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3634: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3635: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

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

3628: oe_debug_pub.add('*******************************' ) ;
3629: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3630: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3631: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3633: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3634: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3635: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3636: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

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

3629: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3630: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3631: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3633: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3634: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3635: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3636: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3637: END IF;

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

3630: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3631: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3633: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3634: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3635: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3636: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3637: END IF;
3638:

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

3631: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3633: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3634: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3635: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3636: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3637: END IF;
3638:
3639: end loop;

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

3632: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3633: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3634: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3635: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3636: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3637: END IF;
3638:
3639: end loop;
3640: end if;

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

3640: end if;
3641:
3642:
3643: IF l_debug_level > 0 THEN
3644: oe_debug_pub.add( 'COUNT LINE DETAIL QUAL TBL='|| OUT_REQ_LINE_DETAIL_QUAL_TBL.COUNT ) ;
3645: END IF;
3646:
3647: if out_req_line_detail_qual_tbl.count > 0 then
3648: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last

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

3647: if out_req_line_detail_qual_tbl.count > 0 then
3648: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
3649: loop
3650: IF l_debug_level > 0 THEN
3651: oe_debug_pub.add( '*******************************' ) ;
3652: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3653: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3654: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

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

3648: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
3649: loop
3650: IF l_debug_level > 0 THEN
3651: oe_debug_pub.add( '*******************************' ) ;
3652: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3653: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3654: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3656: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

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

3649: loop
3650: IF l_debug_level > 0 THEN
3651: oe_debug_pub.add( '*******************************' ) ;
3652: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3653: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3654: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3656: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3657: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

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

3650: IF l_debug_level > 0 THEN
3651: oe_debug_pub.add( '*******************************' ) ;
3652: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3653: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3654: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3656: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3657: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3658: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

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

3651: oe_debug_pub.add( '*******************************' ) ;
3652: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3653: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3654: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3656: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3657: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3658: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3659: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

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

3652: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3653: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3654: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3656: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3657: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3658: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3659: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3660: END IF;

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

3653: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3654: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3656: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3657: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3658: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3659: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3660: END IF;
3661:

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

3654: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3656: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3657: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3658: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3659: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3660: END IF;
3661:
3662: end loop;

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

3655: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3656: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3657: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3658: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3659: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3660: END IF;
3661:
3662: end loop;
3663: end if;

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

3663: end if;
3664:
3665:
3666: IF l_debug_level > 0 THEN
3667: oe_debug_pub.add( 'EXITING PRICE_ITEM*******************************' ) ;
3668: END IF;
3669:
3670: EXCEPTION
3671: when others then

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

3670: EXCEPTION
3671: when others then
3672:
3673: IF l_debug_level > 0 THEN
3674: oe_debug_pub.add( 'PRICE ITEM EXCEPTION WHEN OTHERS CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
3675: END IF;
3676:
3677: END price_item;
3678:

Line 3688: oe_debug_pub.add(' Line Record Nbr='||i);

3684:
3685: g_panda_rec_table.delete;
3686: for i in in_panda_rec_table.first..in_panda_rec_table.last
3687: loop
3688: oe_debug_pub.add(' Line Record Nbr='||i);
3689:
3690: g_panda_rec_table(i):=in_panda_rec_table(i);
3691: oe_debug_pub.add('*******IT STARTS HERE*****');
3692: oe_debug_pub.add('index is'||i||' item is='||g_panda_rec_table(i).p_inventory_item_id);

Line 3691: oe_debug_pub.add('***IT STARTS HERE*');

3687: loop
3688: oe_debug_pub.add(' Line Record Nbr='||i);
3689:
3690: g_panda_rec_table(i):=in_panda_rec_table(i);
3691: oe_debug_pub.add('*******IT STARTS HERE*****');
3692: oe_debug_pub.add('index is'||i||' item is='||g_panda_rec_table(i).p_inventory_item_id);
3693:
3694: end loop;
3695:

Line 3692: oe_debug_pub.add('index is'||i||' item is='||g_panda_rec_table(i).p_inventory_item_id);

3688: oe_debug_pub.add(' Line Record Nbr='||i);
3689:
3690: g_panda_rec_table(i):=in_panda_rec_table(i);
3691: oe_debug_pub.add('*******IT STARTS HERE*****');
3692: oe_debug_pub.add('index is'||i||' item is='||g_panda_rec_table(i).p_inventory_item_id);
3693:
3694: end loop;
3695:
3696: END pass_values_to_backend;

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

3709: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);
3710: l_qual_index pls_integer := nvl(px_Req_qual_tbl.last,0);
3711:
3712: --
3713: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3714: --
3715: BEGIN
3716:
3717: IF l_debug_level > 0 THEN

Line 3718: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;

3714: --
3715: BEGIN
3716:
3717: IF l_debug_level > 0 THEN
3718: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;
3719: END IF;
3720: i := p_pricing_contexts_Tbl.First;
3721: While i is not null loop
3722: l_attr_index := l_attr_index +1;

Line 3769: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;

3765: i := p_qualifier_contexts_Tbl.Next(i);
3766: end loop;
3767:
3768: IF l_debug_level > 0 THEN
3769: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;
3770: END IF;
3771:
3772: END copy_attribs_to_Req;
3773:

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

3828: l_operand number;
3829: l_msg_text Varchar2(2000);
3830:
3831: --
3832: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3833: --
3834: BEGIN
3835:
3836: IF l_debug_level > 0 THEN

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

3833: --
3834: BEGIN
3835:
3836: IF l_debug_level > 0 THEN
3837: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;
3838: END IF;
3839: IF l_debug_level > 0 THEN
3840: 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 ) ;
3841: END IF;

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

3836: IF l_debug_level > 0 THEN
3837: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;
3838: END IF;
3839: IF l_debug_level > 0 THEN
3840: 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 ) ;
3841: END IF;
3842:
3843:
3844: IF in_line_Type_code ='LINE' and

Line 3875: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;

3871:
3872: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
3873:
3874: IF l_debug_level > 0 THEN
3875: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
3876: END IF;
3877: IF g_panda_rec_table(1).p_price_list_id is null then
3878:
3879: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');

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

3878:
3879: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
3880: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3881: IF l_debug_level > 0 THEN
3882: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3883: END IF;
3884: OE_MSG_PUB.Add;
3885:
3886: ELSE

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

3884: OE_MSG_PUB.Add;
3885:
3886: ELSE
3887: IF l_debug_level > 0 THEN
3888: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3889: END IF;
3890: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3891: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3892: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);

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

3922: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3924:
3925: IF l_debug_level > 0 THEN
3926: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3927: END IF;
3928: Begin
3929: Select name into l_price_list
3930: from qp_list_headers_vl a,qp_list_lines b where

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

3939: instr(in_status_text,',')-1);
3940: End;
3941:
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
3944: END IF;
3945: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3946: Begin
3947: Select name into l_price_list

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

3956: l_price_list := substr(in_status_text,
3957: instr(in_status_text,',')+1);
3958: End;
3959: IF l_debug_level > 0 THEN
3960: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3961: END IF;
3962:
3963: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3964: OE_MSG_PUB.Add;

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

3985:
3986: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and
3987: l_allow_negative_price = 'N' then
3988:
3989: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
3990: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
3991: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3992: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
3993: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);

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

4001: ELSIF in_line_Type_code ='LINE' and
4002: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
4003:
4004: IF l_debug_level > 0 THEN
4005: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4006: END IF;
4007: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
4008: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4009: OE_MSG_PUB.Add;

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

4018: --engine doesn't look at the line and will not return adjustments. In this
4019: --case we DON't want to remove the adjustments that engine doesn't return.
4020: then
4021: IF l_debug_level > 0 THEN
4022: oe_debug_pub.add( 'OE_PRICING_ERROR 2' ) ;
4023: END IF;
4024:
4025: IF in_status_text is not null then
4026: l_return_status := 'E';

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

4034: /*OPEN get_gsa_list_lines;
4035: FETCH get_gsa_list_lines
4036: INTO l_operand;
4037: CLOSE get_gsa_list_lines;
4038: oe_debug_pub.add('After select OE_PRICING_ERROR 2');
4039: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
4040: ' Operand='||l_operand);
4041:
4042: IF in_adjusted_unit_price <= l_operand then

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

4035: FETCH get_gsa_list_lines
4036: INTO l_operand;
4037: CLOSE get_gsa_list_lines;
4038: oe_debug_pub.add('After select OE_PRICING_ERROR 2');
4039: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
4040: ' Operand='||l_operand);
4041:
4042: IF in_adjusted_unit_price <= l_operand then
4043: oe_debug_pub.add('If unit price less than operand violation='||

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

4039: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
4040: ' Operand='||l_operand);
4041:
4042: IF in_adjusted_unit_price <= l_operand then
4043: oe_debug_pub.add('If unit price less than operand violation='||
4044: l_gsa_violation_action);
4045: --Check if the GSA check needs to be done.
4046: If l_gsa_violation_action in ('WARNING','ERROR') then
4047:

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

4044: l_gsa_violation_action);
4045: --Check if the GSA check needs to be done.
4046: If l_gsa_violation_action in ('WARNING','ERROR') then
4047:
4048: oe_debug_pub.add('GSA warning or error');
4049: Begin
4050: SELECT concatenated_segments
4051: INTO l_msg_text
4052: FROM mtl_system_items_kfv

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

4057: Null;
4058: End;
4059:
4060: l_return_status := 'E';
4061: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
4062: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
4063: l_msg_text := l_operand||' ( '||l_msg_text||' )';
4064: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
4065: OE_MSG_PUB.Add;

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

4077: --need to be pulled out by append_adjustment_lines routine
4078: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
4079: Then
4080: IF l_debug_level > 0 THEN
4081: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
4082: END IF;
4083: null;
4084:
4085: ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then

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

4084:
4085: ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then
4086:
4087: IF l_debug_level > 0 THEN
4088: oe_debug_pub.add( 'STATUS = UPDATED' ) ;
4089: END IF;
4090:
4091: END IF;-- Status_Code
4092:

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

4091: END IF;-- Status_Code
4092:
4093:
4094: IF l_debug_level > 0 THEN
4095: oe_debug_pub.add( 'PROCESS PRICING ERROR AFTER ERR CHK ST='||L_RETURN_STATUS ) ;
4096: END IF;
4097:
4098: IF l_return_status ='E' then
4099: IF l_debug_level > 0 THEN

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

4096: END IF;
4097:
4098: IF l_return_status ='E' then
4099: IF l_debug_level > 0 THEN
4100: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
4101: END IF;
4102: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
4103: p_count => l_msg_count,
4104: p_data=>l_msg_data

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

4105: );
4106: END IF;
4107:
4108: IF l_debug_level > 0 THEN
4109: oe_debug_pub.add( 'EXITING PROCESS_PRICING_ERRORS' ) ;
4110: END IF;
4111:
4112: EXCEPTION
4113:

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

4112: EXCEPTION
4113:
4114: when others then
4115: IF l_debug_level > 0 THEN
4116: oe_debug_pub.add( 'PROCESS PRICING ERRORS WHEN OTHERS EXCEPTION CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
4117: END IF;
4118:
4119: END process_pricing_errors;
4120:

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

4124:
4125: l_rounding_factor number;
4126:
4127: --
4128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4129: --
4130: BEGIN
4131:
4132: select rounding_factor

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

4166:
4167: l_list_type_code varchar2(300);
4168:
4169: --
4170: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4171: --
4172: BEGIN
4173:
4174: SELECT name,

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

4190: WHERE list_header_id = in_list_header_id;
4191:
4192:
4193: IF l_debug_level > 0 THEN
4194: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
4195: END IF;
4196: IF l_debug_level > 0 THEN
4197: oe_debug_pub.add( 'EXITING OE_AVA.GET_MODIFIER_NAME TYP='||L_LIST_TYPE_CODE ) ;
4198: END IF;

Line 4197: oe_debug_pub.add( 'EXITING OE_AVA.GET_MODIFIER_NAME TYP='||L_LIST_TYPE_CODE ) ;

4193: IF l_debug_level > 0 THEN
4194: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
4195: END IF;
4196: IF l_debug_level > 0 THEN
4197: oe_debug_pub.add( 'EXITING OE_AVA.GET_MODIFIER_NAME TYP='||L_LIST_TYPE_CODE ) ;
4198: END IF;
4199:
4200: EXCEPTION
4201: when no_data_found then

Line 4203: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME NO DATA FOUND' ) ;

4199:
4200: EXCEPTION
4201: when no_data_found then
4202: IF l_debug_level > 0 THEN
4203: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME NO DATA FOUND' ) ;
4204: END IF;
4205: when others then
4206: IF l_debug_level > 0 THEN
4207: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME WHEN OTHERS '|| SQLERRM||SQLCODE ) ;

Line 4207: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME WHEN OTHERS '|| SQLERRM||SQLCODE ) ;

4203: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME NO DATA FOUND' ) ;
4204: END IF;
4205: when others then
4206: IF l_debug_level > 0 THEN
4207: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME WHEN OTHERS '|| SQLERRM||SQLCODE ) ;
4208: END IF;
4209:
4210: END get_modifier_name;
4211:

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

4222:
4223: ) IS
4224:
4225: --
4226: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4227: --
4228: BEGIN
4229:
4230: SELECT

Line 4246: oe_debug_pub.add( 'EXITING OE_AVA.GET_LINE_DETAILS TYPE='|| 'LIST_LINE_TYPE_CODE='|| OUT_LIST_LINE_TYPE_CODE|| 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;

4242: WHERE list_line_id = in_list_line_id;
4243:
4244:
4245: IF l_debug_level > 0 THEN
4246: oe_debug_pub.add( 'EXITING OE_AVA.GET_LINE_DETAILS TYPE='|| 'LIST_LINE_TYPE_CODE='|| OUT_LIST_LINE_TYPE_CODE|| 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
4247: END IF;
4248:
4249: EXCEPTION
4250: when no_data_found then

Line 4252: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS NO DATA FOUND' ) ;

4248:
4249: EXCEPTION
4250: when no_data_found then
4251: IF l_debug_level > 0 THEN
4252: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS NO DATA FOUND' ) ;
4253: END IF;
4254: when others then
4255: IF l_debug_level > 0 THEN
4256: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS WHEN OTHERS '|| SQLERRM||SQLCODE ) ;

Line 4256: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS WHEN OTHERS '|| SQLERRM||SQLCODE ) ;

4252: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS NO DATA FOUND' ) ;
4253: END IF;
4254: when others then
4255: IF l_debug_level > 0 THEN
4256: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS WHEN OTHERS '|| SQLERRM||SQLCODE ) ;
4257: END IF;
4258:
4259: END get_list_line_details;
4260:

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

4264:
4265: l_meaning varchar2(300);
4266:
4267: --
4268: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4269: --
4270: BEGIN
4271:
4272: IF l_debug_level > 0 THEN

Line 4273: oe_debug_pub.add( 'CODE='||IN_LOOKUP_CODE||' TYPE='||IN_LOOKUP_TYPE ) ;

4269: --
4270: BEGIN
4271:
4272: IF l_debug_level > 0 THEN
4273: oe_debug_pub.add( 'CODE='||IN_LOOKUP_CODE||' TYPE='||IN_LOOKUP_TYPE ) ;
4274: END IF;
4275:
4276: SELECT meaning
4277: INTO l_meaning

Line 4291: oe_debug_pub.add( 'OE_AVAILABILITY.GET_QP_LOOKUP_MEANING NO DATA FOUND' ) ;

4287:
4288: EXCEPTION
4289: when no_data_found then
4290: IF l_debug_level > 0 THEN
4291: oe_debug_pub.add( 'OE_AVAILABILITY.GET_QP_LOOKUP_MEANING NO DATA FOUND' ) ;
4292: END IF;
4293: Return Null;
4294:
4295: END get_qp_lookup_meaning;

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

4301: ) return varchar2 IS
4302: l_pricing_attribute varchar2(300);
4303:
4304: --
4305: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4306: --
4307: BEGIN
4308:
4309: IF l_debug_level > 0 THEN

Line 4310: oe_debug_pub.add( 'GET_PRICING_ATTRIBUTE '|| 'IN_CONTEXT = '||IN_CONTEXT_NAME|| 'IN_ATTRIBUTE_NAME='||IN_ATTRIBUTE_NAME ) ;

4306: --
4307: BEGIN
4308:
4309: IF l_debug_level > 0 THEN
4310: oe_debug_pub.add( 'GET_PRICING_ATTRIBUTE '|| 'IN_CONTEXT = '||IN_CONTEXT_NAME|| 'IN_ATTRIBUTE_NAME='||IN_ATTRIBUTE_NAME ) ;
4311: END IF;
4312: l_pricing_attribute := QP_UTIL.get_attribute_name(
4313: p_application_short_name=> 'QP',
4314: P_FLEXFIELD_NAME =>'QP_ATTR_DEFNS_PRICING',

Line 4319: oe_debug_pub.add( 'EXITING GET_PRICING_ATTRIBUTE ='||L_PRICING_ATTRIBUTE ) ;

4315: P_CONTEXT_NAME =>in_context_name,
4316: P_ATTRIBUTE_NAME =>in_attribute_name
4317: );
4318: IF l_debug_level > 0 THEN
4319: oe_debug_pub.add( 'EXITING GET_PRICING_ATTRIBUTE ='||L_PRICING_ATTRIBUTE ) ;
4320: END IF;
4321:
4322: return l_pricing_attribute;
4323:

Line 4328: oe_debug_pub.add( 'WHEN OTHERS FOR GET_PRICING_ATTRIBUTE'|| SQLCODE||SQLERRM ) ;

4324: EXCEPTION
4325:
4326: WHEN others then
4327: IF l_debug_level > 0 THEN
4328: oe_debug_pub.add( 'WHEN OTHERS FOR GET_PRICING_ATTRIBUTE'|| SQLCODE||SQLERRM ) ;
4329: END IF;
4330: return null;
4331:
4332: END get_pricing_attribute;

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

4355:
4356: ) IS
4357:
4358: --
4359: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4360: --
4361: BEGIN
4362:
4363: IF l_debug_level > 0 THEN

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

4360: --
4361: BEGIN
4362:
4363: IF l_debug_level > 0 THEN
4364: oe_debug_pub.add( 'GET PRICE_LIST ID='||P_PRICE_LIST_ID ) ;
4365: END IF;
4366:
4367: IF p_price_list_id IS NOT NULL THEN
4368:

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

4391:
4392: END IF;
4393:
4394: IF l_debug_level > 0 THEN
4395: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
4396: END IF;
4397:
4398: EXCEPTION
4399:

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

4398: EXCEPTION
4399:
4400: WHEN NO_DATA_FOUND THEN
4401: IF l_debug_level > 0 THEN
4402: oe_debug_pub.add( 'NO DATA FOUND GET PRICE LIST_INFO' ) ;
4403: END IF;
4404:
4405: WHEN OTHERS THEN
4406: IF l_debug_level > 0 THEN

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

4403: END IF;
4404:
4405: WHEN OTHERS THEN
4406: IF l_debug_level > 0 THEN
4407: oe_debug_pub.add( 'WHEN OTHERS GET PRICE LIST_INFO'|| SQLCODE||SQLERRM ) ;
4408: END IF;
4409:
4410: END get_Price_List_info;
4411:

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

4516: l_ship_from_org_name varchar2(200);
4517: l_make_buy number;
4518:
4519: --
4520: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4521: --
4522: BEGIN
4523:
4524: IF l_debug_level > 0 THEN

Line 4525: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.GET_ITEM_INFO'||

4521: --
4522: BEGIN
4523:
4524: IF l_debug_level > 0 THEN
4525: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.GET_ITEM_INFO'||
4526: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID ) ;
4527: END IF;
4528:
4529: OPEN c_item_info;

Line 4577: oe_debug_pub.add( 'USER_ITEM_TYPE='||L_USER_ITEM_TYPE ) ;

4573: , out_name =>out_wsh_name
4574: );
4575:
4576: IF l_debug_level > 0 THEN
4577: oe_debug_pub.add( 'USER_ITEM_TYPE='||L_USER_ITEM_TYPE ) ;
4578: END IF;
4579:
4580: out_lead_time := l_cummulative_total_lead_time;
4581: out_cost := l_order_cost;

Line 4601: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.GET_ITEM_INFO'||

4597: out_user_item_type := null;
4598:
4599: END IF;
4600: IF l_debug_level > 0 THEN
4601: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.GET_ITEM_INFO'||
4602: ' ITEM_STATUS ='||OUT_ITEM_STATUS ) ;
4603: END IF;
4604:
4605: EXCEPTION

Line 4613: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.GET_ITEM_INFO '||

4609: CLOSE c_item_info;
4610: END IF;
4611:
4612: IF l_debug_level > 0 THEN
4613: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.GET_ITEM_INFO '||
4614: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID||
4615: 'SQLCODE='||SQLCODE|| 'SQLERRM='||SQLERRM ) ;
4616: END IF;
4617:

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

4628: l_hsecs number;
4629: l_total number;
4630:
4631: --
4632: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4633: --
4634: BEGIN
4635:
4636: --print_time2;

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

4643:
4644: g_hsecs := l_hsecs;
4645: g_place := in_place;
4646: IF l_debug_level > 0 THEN
4647: oe_debug_pub.add( 'TIME STARTING AT PLACE '||G_PLACE||' TIME='||G_HSECS ) ;
4648: END IF;
4649:
4650: ELSE
4651: l_total := (l_hsecs - g_hsecs)/100;

Line 4654: oe_debug_pub.add( 'TIME FROM ' ||G_PLACE||' TO '||IN_PLACE||

4650: ELSE
4651: l_total := (l_hsecs - g_hsecs)/100;
4652: g_total := g_total + l_total;
4653: IF l_debug_level > 0 THEN
4654: oe_debug_pub.add( 'TIME FROM ' ||G_PLACE||' TO '||IN_PLACE||
4655: ' TIME DIFF='|| L_TOTAL||' SECONDS'||' TOTAL SO FAR='||G_TOTAL ) ;
4656: END IF;
4657: g_hsecs := l_hsecs;
4658: g_place := in_place;

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

4672: l_hsecs number;
4673: l_total number;
4674:
4675: --
4676: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4677: --
4678: BEGIN
4679:
4680: OPEN c2_hsecs;

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

4683: CLOSE c2_hsecs;
4684:
4685: IF g_total2 is null then
4686: IF l_debug_level > 0 THEN
4687: oe_debug_pub.add( 'G_TOTAL2 IS NULL L_HSECS='||L_HSECS ) ;
4688: END IF;
4689: g_total2 := l_hsecs;
4690: ELSE
4691: IF l_debug_level > 0 THEN

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

4688: END IF;
4689: g_total2 := l_hsecs;
4690: ELSE
4691: IF l_debug_level > 0 THEN
4692: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;
4693: END IF;
4694: l_total := (l_hsecs - g_total2)/100;
4695: IF l_debug_level > 0 THEN
4696: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;

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

4692: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;
4693: END IF;
4694: l_total := (l_hsecs - g_total2)/100;
4695: IF l_debug_level > 0 THEN
4696: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;
4697: END IF;
4698: g_total2 := l_hsecs;
4699: END IF;
4700:

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

4753: l_instance_code varchar2(100);
4754:
4755: l_inv_ctp number;
4756:
4757: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4758:
4759: CURSOR c_temp_table(in_session_id in number) IS
4760: SELECT source_organization_id,
4761: sr_instance_id,

Line 4775: oe_debug_pub.add( 'ENTERING GA IN_ORG_ID='||IN_ORG_ID|| ' IN_CUSTOMER_ID='||IN_CUSTOMER_ID

4771:
4772: BEGIN
4773:
4774: IF l_debug_level > 0 THEN
4775: oe_debug_pub.add( 'ENTERING GA IN_ORG_ID='||IN_ORG_ID|| ' IN_CUSTOMER_ID='||IN_CUSTOMER_ID
4776: || ' IN_SITE_ID ='||IN_CUSTOMER_SITE_ID|| ' IN_ITEM_ID ='||IN_INVENTORY_ITEM_ID ) ;
4777: END IF;
4778:
4779: OPEN c_instance_id;

Line 4790: oe_debug_pub.add( 'L_INSTANCE_ID='||L_INSTANCE_ID|| ' DB LINK='

4786: x_return_status := 'S';
4787: l_mrp_atp_database_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
4788:
4789: IF l_debug_level > 0 THEN
4790: oe_debug_pub.add( 'L_INSTANCE_ID='||L_INSTANCE_ID|| ' DB LINK='
4791: ||L_MRP_ATP_DATABASE_LINK ||' Ins Code='||l_instance_code) ;
4792: END IF;
4793:
4794: msc_sch_wb.get_assignment_set(

Line 4807: oe_debug_pub.add( 'ASSIGNMENT_SET_ID='||X_ASSIGNMENT_SET_ID|| ' SET NAME='||

4803: ,x_err_mesg =>x_err_mesg
4804: );
4805:
4806: IF l_debug_level > 0 THEN
4807: oe_debug_pub.add( 'ASSIGNMENT_SET_ID='||X_ASSIGNMENT_SET_ID|| ' SET NAME='||
4808: X_ASSIGNMENT_SET_NAME|| ' PLAN ID='||X_PLAN_ID|| ' PLAN NAME='
4809: ||X_PLAN_NAME|| ' RET CODE='||X_RETURN_STATUS|| ' ERR MESG='||X_ERR_MESG ) ;
4810: END IF;
4811:

Line 4817: oe_debug_pub.add( 'RETURNING IN GA 1' ) ;

4813: and x_assignment_set_id is null then
4814:
4815: x_msg_data := x_err_mesg;
4816: IF l_debug_level > 0 THEN
4817: oe_debug_pub.add( 'RETURNING IN GA 1' ) ;
4818: END IF;
4819:
4820: IF x_msg_data is not null then
4821:

Line 4823: oe_debug_pub.add( 'MSG DATA IS NOT NULL' ) ;

4819:
4820: IF x_msg_data is not null then
4821:
4822: IF l_debug_level > 0 THEN
4823: oe_debug_pub.add( 'MSG DATA IS NOT NULL' ) ;
4824: END IF;
4825: x_return_status := 'E';
4826: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
4827: IF l_debug_level > 0 THEN

Line 4828: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;

4824: END IF;
4825: x_return_status := 'E';
4826: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
4827: IF l_debug_level > 0 THEN
4828: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
4829: END IF;
4830: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);
4831: OE_MSG_PUB.Add;
4832:

Line 4858: oe_debug_pub.add(' Inventory Capable to Promise='||l_inv_ctp);

4854:
4855:
4856: /*fnd_profile.get('INV_CTP',l_inv_ctp);
4857: IF l_debug_level > 0 THEN
4858: oe_debug_pub.add(' Inventory Capable to Promise='||l_inv_ctp);
4859: END IF;
4860:
4861: --Profile Inventory Capable to Prmise
4862: -- 4= PDS and we need to select a plan_id for org-org sourcing

Line 4880: oe_debug_pub.add('Getting Plan Id dynamic string='||l_dynstring);

4876: l_dynstring := '@'||l_mrp_atp_database_link;
4877: END IF;
4878:
4879: IF l_debug_level > 0 THEN
4880: oe_debug_pub.add('Getting Plan Id dynamic string='||l_dynstring);
4881: END IF;
4882:
4883: sql_stmt :=
4884: ' SELECT '||

Line 4892: oe_debug_pub.add('Planning Sql='||sql_stmt);

4888: ' AND mast.sr_inventory_item_id = :in_inventory_item_id'||
4889: ' AND mast.organization_id = :in_org_id';
4890:
4891: IF l_debug_level > 0 THEN
4892: oe_debug_pub.add('Planning Sql='||sql_stmt);
4893: END IF;
4894:
4895:
4896: EXECUTE IMMEDIATE sql_stmt INTO x_plan_id

Line 4904: oe_debug_pub.add('Plan Id NOT FOUND');

4900: IF x_plan_id is null then
4901: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');
4902: oe_msg_pub.add;
4903: x_return_status := 'E';
4904: oe_debug_pub.add('Plan Id NOT FOUND');
4905: END IF;
4906:
4907: END IF; -- if plan_id needs to be fetched */
4908:

Line 4918: oe_debug_pub.add(' Before inserting into temp table '||

4914: -- if the plan was fetched and found then continue
4915: IF nvl(x_return_status,'E') <> 'E' then
4916:
4917: IF l_debug_level > 0 THEN
4918: oe_debug_pub.add(' Before inserting into temp table '||
4919: ' instance_id='||l_instance_id||
4920: ' session_id='||l_session_id||
4921: ' inv_item_id='||in_inventory_item_id||
4922: ' customer_id='||l_customer_id||

Line 4970: oe_debug_pub.add( ' After CALLing get_supply_sources_local '||

4966:
4967: IF l_debug_level > 0 THEN
4968: print_time('After Calling Get Supply Sources');
4969:
4970: oe_debug_pub.add( ' After CALLing get_supply_sources_local '||
4971: ' status='||x_return_status||
4972: ' message='||x_err_mesg);
4973:
4974: END IF;

Line 4978: oe_debug_pub.add( ' ERROR IN CALL TO get_supply_sources_local');

4974: END IF;
4975:
4976: IF nvl(x_return_status,'S') <> 'S' THEN
4977: IF l_debug_level > 0 THEN
4978: oe_debug_pub.add( ' ERROR IN CALL TO get_supply_sources_local');
4979: END IF;
4980: fnd_message.set_name('MSC', x_err_mesg);
4981: oe_msg_pub.add;
4982:

Line 4990: oe_debug_pub.add( ' SUCCESS IN CALL TO get_supply_sources_local');

4986: x_return_status := 'S';
4987: END IF;
4988:
4989: IF l_debug_level > 0 THEN
4990: oe_debug_pub.add( ' SUCCESS IN CALL TO get_supply_sources_local');
4991: END IF;
4992:
4993: -- Read from mrp_atp_schedule_Temp
4994: -- Insert into l_sources_orgs_table org_id and instance_id

Line 5000: oe_debug_pub.add( ' Reading data from temp table');

4996:
4997: FOR l_temp_rec in c_temp_table(l_session_id)
4998: LOOP
4999: IF l_debug_level > 0 THEN
5000: oe_debug_pub.add( ' Reading data from temp table');
5001: END IF;
5002: l_source_orgs_table(l_count).org_id:=l_temp_rec.source_organization_id;
5003: l_source_orgs_table(l_count).instance_id:=l_temp_rec.sr_instance_id;
5004: l_source_orgs_table(l_count).ship_method:=l_temp_rec.ship_method;

Line 5013: oe_debug_pub.add( ' After Reading data from temp table');

5009:
5010: END LOOP;
5011:
5012: IF l_debug_level > 0 THEN
5013: oe_debug_pub.add( ' After Reading data from temp table');
5014: END IF;
5015:
5016: IF l_source_orgs_table.COUNT > 0 then
5017: FOR i in l_source_orgs_table.FIRST..l_source_orgs_table.LAST

Line 5020: oe_debug_pub.add(' Record = '||i||

5016: IF l_source_orgs_table.COUNT > 0 then
5017: FOR i in l_source_orgs_table.FIRST..l_source_orgs_table.LAST
5018: LOOP
5019: IF l_debug_level > 0 THEN
5020: oe_debug_pub.add(' Record = '||i||
5021: ' org_id ='||l_source_orgs_table(i).org_id||
5022: ' instance_id ='||l_source_orgs_table(i).instance_id||
5023: ' ship_method ='||l_source_orgs_table(i).ship_method||
5024: ' del_lead_time ='||l_source_orgs_table(i).delivery_lead_time||

Line 5034: oe_debug_pub.add( ' THERE ARE NO SOURCES TO BE DISPLAYED ' ) ;

5030: END LOOP;
5031: ELSE
5032:
5033: IF l_debug_level > 0 THEN
5034: oe_debug_pub.add( ' THERE ARE NO SOURCES TO BE DISPLAYED ' ) ;
5035: END IF;
5036: x_return_status := 'E';
5037: x_error_mesg := 'MRP_ATP_NO_SOURCES';
5038: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');

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

5054:
5055: -- if it was a failure then we retrieve the message
5056: IF nvl(x_return_status,'E') <> 'S' then
5057: IF l_debug_level > 0 THEN
5058: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
5059: END IF;
5060: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
5061: p_count => x_msg_count,
5062: p_data=>x_msg_data

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

5061: p_count => x_msg_count,
5062: p_data=>x_msg_data
5063: );
5064: IF l_debug_level > 0 THEN
5065: oe_debug_pub.add( 'COUNT = '||X_MSG_COUNT||' MSG='||X_MSG_DATA ) ;
5066: END IF;
5067: END IF;
5068:
5069: IF l_debug_level > 0 THEN

Line 5070: oe_debug_pub.add( 'EXITING GA' ) ;

5066: END IF;
5067: END IF;
5068:
5069: IF l_debug_level > 0 THEN
5070: oe_debug_pub.add( 'EXITING GA' ) ;
5071: END IF;
5072:
5073: EXCEPTION
5074: WHEN OTHERS THEN

Line 5077: oe_debug_pub.add( 'WHEN OTHERS OF get_global_availability' ) ;

5073: EXCEPTION
5074: WHEN OTHERS THEN
5075:
5076: IF l_debug_level > 0 THEN
5077: oe_debug_pub.add( 'WHEN OTHERS OF get_global_availability' ) ;
5078: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
5079: END IF;
5080:
5081: x_return_status := 'E';

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

5074: WHEN OTHERS THEN
5075:
5076: IF l_debug_level > 0 THEN
5077: oe_debug_pub.add( 'WHEN OTHERS OF get_global_availability' ) ;
5078: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
5079: END IF;
5080:
5081: x_return_status := 'E';
5082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

5131: l_ordered_conversion number;
5132: l_pricing_conversion number;
5133:
5134: --
5135: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5136: --
5137: BEGIN
5138:
5139: IF l_debug_level > 0 THEN

Line 5140: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.DIFFERENT_UOM'||

5136: --
5137: BEGIN
5138:
5139: IF l_debug_level > 0 THEN
5140: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.DIFFERENT_UOM'||
5141: ' ORDERED_UOM ='||IN_ORDERED_UOM|| ' PRICING_UOM='||
5142: IN_PRICING_UOM|| ' IN_INV_ITEM_ID='||
5143: G_panda_rec_table(1).p_INVENTORY_ITEM_ID|| ' IN_ORG_ID='||IN_ORG_ID ) ;
5144: END IF;

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

5165: IF in_ordered_uom <> l_base_uom AND
5166: in_pricing_uom <> l_base_uom THEN
5167:
5168: IF l_debug_level > 0 THEN
5169: oe_debug_pub.add( 'NEITHER THE ORDERED OR PRICING UOM IS BASE UOM' ) ;
5170: END IF;
5171:
5172: l_ordered_conversion := get_conversion_rate(
5173: in_uom_code => in_ordered_uom,

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

5173: in_uom_code => in_ordered_uom,
5174: in_base_uom => l_base_uom
5175: );
5176: IF l_debug_level > 0 THEN
5177: oe_debug_pub.add( 'THE ORD RATE ='||L_ORDERED_CONVERSION ) ;
5178: END IF;
5179: l_pricing_conversion := get_conversion_rate(
5180: in_uom_code => in_pricing_uom,
5181: in_base_uom => l_base_uom

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

5180: in_uom_code => in_pricing_uom,
5181: in_base_uom => l_base_uom
5182: );
5183: IF l_debug_level > 0 THEN
5184: oe_debug_pub.add( 'THE PRICING RATE ='||L_PRICING_CONVERSION ) ;
5185: END IF;
5186:
5187: out_conversion_rate := l_ordered_conversion/l_pricing_conversion;
5188: IF l_debug_level > 0 THEN

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

5185: END IF;
5186:
5187: out_conversion_rate := l_ordered_conversion/l_pricing_conversion;
5188: IF l_debug_level > 0 THEN
5189: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
5190: END IF;
5191:
5192: -- Ordered Uom is the Base Uom,sending the pricing uom for conversion
5193: ELSIF in_ordered_uom = l_base_uom then

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

5192: -- Ordered Uom is the Base Uom,sending the pricing uom for conversion
5193: ELSIF in_ordered_uom = l_base_uom then
5194:
5195: IF l_debug_level > 0 THEN
5196: oe_debug_pub.add( 'THE ORDERED UOM IS BASE UOM' ) ;
5197: END IF;
5198:
5199: l_ordered_conversion := get_conversion_rate(
5200: in_uom_code => in_pricing_uom,

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

5201: in_base_uom => l_base_uom
5202: );
5203: out_conversion_rate := l_ordered_conversion;
5204: IF l_debug_level > 0 THEN
5205: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
5206: END IF;
5207:
5208: -- Pricing Uom is the Base Uom
5209: ELSIF in_pricing_uom = l_base_uom then

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

5208: -- Pricing Uom is the Base Uom
5209: ELSIF in_pricing_uom = l_base_uom then
5210:
5211: IF l_debug_level > 0 THEN
5212: oe_debug_pub.add( 'THE PRICING UOM IS BASE UOM' ) ;
5213: END IF;
5214: l_pricing_conversion := get_conversion_rate(
5215: in_uom_code => in_ordered_uom,
5216: in_base_uom => l_base_uom

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

5216: in_base_uom => l_base_uom
5217: );
5218: out_conversion_rate := l_pricing_conversion;
5219: IF l_debug_level > 0 THEN
5220: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
5221: END IF;
5222:
5223: END IF;
5224:

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

5236: EXCEPTION
5237:
5238: WHEN NO_DATA_FOUND THEN
5239: IF l_debug_level > 0 THEN
5240: oe_debug_pub.add( 'NO DATA FONUNG DIFFERENT_UOM ' ) ;
5241: END IF;
5242:
5243: WHEN OTHERS THEN
5244: IF c_items%ISOPEN then

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

5250: IF c_base_uom%ISOPEN then
5251: CLOSE c_base_uom;
5252: END IF;
5253: IF l_debug_level > 0 THEN
5254: oe_debug_pub.add( 'ERROR IN DIFFERENT_UOM '|| SQLCODE||SQLERRM ) ;
5255: END IF;
5256:
5257: END different_uom;
5258:

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

5285: l_conversion_rate number;
5286: l_uom_code varchar2(50);
5287:
5288: --
5289: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5290: --
5291: BEGIN
5292:
5293: IF l_debug_level > 0 THEN

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

5290: --
5291: BEGIN
5292:
5293: IF l_debug_level > 0 THEN
5294: oe_debug_pub.add( 'INSIDE GET_CONVERSION_RATE '|| ' IN_UOM_CODE='||IN_UOM_CODE|| ' IN_BASE_UOM='||IN_BASE_UOM ) ;
5295: END IF;
5296:
5297: OPEN c_item_conversion;
5298: FETCH c_item_conversion

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

5300:
5301: IF c_item_conversion%NOTFOUND THEN
5302:
5303: IF l_debug_level > 0 THEN
5304: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE NOT FOUND' ) ;
5305: END IF;
5306:
5307: OPEN c_conversion;
5308: FETCH c_conversion

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

5310:
5311: IF c_conversion%NOTFOUND THEN
5312:
5313: IF l_debug_level > 0 THEN
5314: oe_debug_pub.add( 'GENERIC CONVERSION NOT FOUND' ) ;
5315: END IF;
5316: OPEN c_inter_class;
5317: FETCH c_inter_class
5318: INTO l_conversion_rate;

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

5318: INTO l_conversion_rate;
5319:
5320: IF c_inter_class%NOTFOUND THEN
5321: IF l_debug_level > 0 THEN
5322: oe_debug_pub.add( 'INTER CLASS RETURN RATE NOT FOUND= 1' ) ;
5323: END IF;
5324: l_conversion_rate := 1;
5325:
5326: ELSE

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

5324: l_conversion_rate := 1;
5325:
5326: ELSE
5327: IF l_debug_level > 0 THEN
5328: oe_debug_pub.add( 'INTER CLASS RETURN RATE = '||L_CONVERSION_RATE ) ;
5329: END IF;
5330:
5331: END IF;
5332: CLOSE c_inter_class;

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

5333:
5334: ELSIF c_conversion%FOUND then
5335:
5336: IF l_debug_level > 0 THEN
5337: oe_debug_pub.add( 'RETURN RATE GENERIC= '||L_CONVERSION_RATE ) ;
5338: END IF;
5339:
5340: END IF;
5341: CLOSE c_conversion;

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

5342:
5343: ELSIF c_item_conversion%FOUND THEN
5344:
5345: IF l_debug_level > 0 THEN
5346: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE='||L_CONVERSION_RATE ) ;
5347: END IF;
5348:
5349: END IF;
5350: CLOSE c_item_conversion;

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

5354: EXCEPTION
5355:
5356: WHEN ZERO_DIVIDE THEN
5357: IF l_debug_level > 0 THEN
5358: oe_debug_pub.add( 'DIVIDE BY ZERO ERROR IN_UOM_CODE='||IN_UOM_CODE|| ' BASE UOM='||IN_BASE_UOM ) ;
5359: END IF;
5360:
5361: IF c_item_conversion%ISOPEN then
5362: CLOSE c_item_conversion;

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

5379: IF c_inter_class%ISOPEN then
5380: CLOSE c_inter_class;
5381: END IF;
5382: IF l_debug_level > 0 THEN
5383: oe_debug_pub.add( 'ERROR IN GET_CONVERSION_RATE '|| SQLCODE||SQLERRM ) ;
5384: END IF;
5385: return 1;
5386: END get_conversion_rate;
5387:

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

5408: l_msg_count number;
5409: l_msg_data varchar2(4000);
5410:
5411: --
5412: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5413: --
5414: BEGIN
5415:
5416:

Line 5440: oe_debug_pub.add( 'L_RETURN_STATUS='||L_RETURN_STATUS|| ' OUT_AVAILABLE_QTY='||OUT_AVAILABLE_QTY|| ' L_OUT_MESSAGE='||L_OUT_MESSAGE|| ' OUT_ERROR_MESSAGE='||OUT_ERROR_MESSAGE ) ;

5436: ,x_error_message =>out_error_message
5437: );
5438:
5439: IF l_debug_level > 0 THEN
5440: oe_debug_pub.add( 'L_RETURN_STATUS='||L_RETURN_STATUS|| ' OUT_AVAILABLE_QTY='||OUT_AVAILABLE_QTY|| ' L_OUT_MESSAGE='||L_OUT_MESSAGE|| ' OUT_ERROR_MESSAGE='||OUT_ERROR_MESSAGE ) ;
5441: END IF;
5442:
5443:
5444: IF l_debug_level > 0 THEN

Line 5445: oe_debug_pub.add( 'CALL_MRP_AND_INVENTORY'|| ' OUT_AVAILABLE_DATE ='||OUT_AVAILABLE_DATE|| ' OUT_AVAILABLE_QTY ='||OUT_AVAILABLE_QTY);

5441: END IF;
5442:
5443:
5444: IF l_debug_level > 0 THEN
5445: oe_debug_pub.add( 'CALL_MRP_AND_INVENTORY'|| ' OUT_AVAILABLE_DATE ='||OUT_AVAILABLE_DATE|| ' OUT_AVAILABLE_QTY ='||OUT_AVAILABLE_QTY);
5446: oe_debug_pub.add( ' OUT_ON_HAND_QTY ='||OUT_ON_HAND_QTY|| ' OUT_RESERVABLE_QTY ='||OUT_RESERVABLE_QTY|| ' OUT_ERROR_MESSAGE ='||OUT_ERROR_MESSAGE ) ;
5447: END IF;
5448:
5449: EXCEPTION

Line 5446: oe_debug_pub.add( ' OUT_ON_HAND_QTY ='||OUT_ON_HAND_QTY|| ' OUT_RESERVABLE_QTY ='||OUT_RESERVABLE_QTY|| ' OUT_ERROR_MESSAGE ='||OUT_ERROR_MESSAGE ) ;

5442:
5443:
5444: IF l_debug_level > 0 THEN
5445: oe_debug_pub.add( 'CALL_MRP_AND_INVENTORY'|| ' OUT_AVAILABLE_DATE ='||OUT_AVAILABLE_DATE|| ' OUT_AVAILABLE_QTY ='||OUT_AVAILABLE_QTY);
5446: oe_debug_pub.add( ' OUT_ON_HAND_QTY ='||OUT_ON_HAND_QTY|| ' OUT_RESERVABLE_QTY ='||OUT_RESERVABLE_QTY|| ' OUT_ERROR_MESSAGE ='||OUT_ERROR_MESSAGE ) ;
5447: END IF;
5448:
5449: EXCEPTION
5450: WHEN OTHERS THEN

Line 5452: oe_debug_pub.add( 'INSIDE CALL_MRP_AND_INVENTORY '|| SQLERRM||SQLERRM ) ;

5448:
5449: EXCEPTION
5450: WHEN OTHERS THEN
5451: IF l_debug_level > 0 THEN
5452: oe_debug_pub.add( 'INSIDE CALL_MRP_AND_INVENTORY '|| SQLERRM||SQLERRM ) ;
5453: END IF;
5454:
5455: END call_mrp_and_inventory;
5456:

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

5462: l_session_id number;
5463: l_mrp_dir varchar2(200);
5464:
5465: --
5466: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5467: --
5468: BEGIN
5469:
5470: SELECT mrp_atp_schedule_temp_s.nextval

Line 5483: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR='||L_MRP_DIR|| ' SESSION ID ='||L_SESSION_ID ) ;

5479: order_sch_wb.mr_debug := 'Y';
5480: order_sch_wb.debug_session_id := l_session_id;
5481:
5482: IF l_debug_level > 0 THEN
5483: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR='||L_MRP_DIR|| ' SESSION ID ='||L_SESSION_ID ) ;
5484: END IF;
5485: l_mrp_dir := substr(l_mrp_dir,1,18);
5486: IF l_debug_level > 0 THEN
5487: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR2='||L_MRP_DIR ) ;

Line 5487: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR2='||L_MRP_DIR ) ;

5483: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR='||L_MRP_DIR|| ' SESSION ID ='||L_SESSION_ID ) ;
5484: END IF;
5485: l_mrp_dir := substr(l_mrp_dir,1,18);
5486: IF l_debug_level > 0 THEN
5487: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR2='||L_MRP_DIR ) ;
5488: END IF;
5489: out_mrp_file := l_mrp_dir||'/session-'||l_session_id;
5490:
5491: EXCEPTION

Line 5494: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;

5490:
5491: EXCEPTION
5492: WHEN NO_DATA_FOUND THEN
5493: IF l_debug_level > 0 THEN
5494: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
5495: END IF;
5496: WHEN OTHERS THEN
5497: IF l_debug_level > 0 THEN
5498: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

Line 5498: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

5494: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
5495: END IF;
5496: WHEN OTHERS THEN
5497: IF l_debug_level > 0 THEN
5498: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;
5499: END IF;
5500:
5501: END set_mrp_debug;
5502:

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

5619: in_pricing_attribute100 in varchar2
5620: ) IS
5621:
5622: --
5623: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5624: --
5625: l_index number :=1;
5626: BEGIN
5627: