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

229: I NUMBER := 1;
230: l_mrp_calc_sd VARCHAR2(240);--bug14222176
231:
232: --
233: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
234: --
235: BEGIN
236:
237: IF l_debug_level > 0 THEN

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

234: --
235: BEGIN
236:
237: IF l_debug_level > 0 THEN
238: oe_debug_pub.add( 'ENTERING CALL ATP' ) ;
239: END IF;
240:
241: Initialize_mrp_record
242: ( p_x_atp_rec => in_atp_rec

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

243: ,l_count =>1 );
244:
245:
246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add( 'INVENTORY_ITEM_ID='||g_panda_rec_table(1).P_INVENTORY_ITEM_ID
248: || ' SHIP_FORM_ORG_ID='||G_panda_rec_table(1).p_SHIP_FROM_ORG_ID
249: || ' IN_GLOBAL_ORGS='||IN_GLOBAL_ORGS);
250: oe_debug_pub.add(' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' SHIP_TO_ORG_ID='
251: ||G_panda_rec_table(1).p_SHIP_TO_ORG_ID||' QTY='||G_panda_rec_table(1).p_QTY

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

246: IF l_debug_level > 0 THEN
247: oe_debug_pub.add( 'INVENTORY_ITEM_ID='||g_panda_rec_table(1).P_INVENTORY_ITEM_ID
248: || ' SHIP_FORM_ORG_ID='||G_panda_rec_table(1).p_SHIP_FROM_ORG_ID
249: || ' IN_GLOBAL_ORGS='||IN_GLOBAL_ORGS);
250: oe_debug_pub.add(' CUST_ID='||G_panda_rec_table(1).p_CUSTOMER_ID|| ' SHIP_TO_ORG_ID='
251: ||G_panda_rec_table(1).p_SHIP_TO_ORG_ID||' QTY='||G_panda_rec_table(1).p_QTY
252: || ' UOM='||G_panda_rec_table(1).p_UOM||' REQ DATE='||
253: G_panda_rec_table(1).p_REQUEST_DATE ) ;
254: END IF;

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

267: INTO l_line_id
268: FROM DUAL;
269: */
270: IF l_debug_level > 0 THEN
271: oe_debug_pub.add( 'LINE_ID='||G_ATP_LINE_ID ) ;
272: END IF;
273:
274: in_atp_rec.Identifier(I) := g_atp_line_id;
275: in_atp_rec.Action(I) := 100;

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

304:
305: --bug14222176
306: l_mrp_calc_sd := fnd_profile.value('MRP_ATP_CALC_SD');
307: IF nvl(l_mrp_calc_sd,'N') = 'Y' THEN
308: oe_debug_pub.add('in OEXFAVAB, MRP_ATP_CALC_SD profile set to yes ' );
309: in_atp_rec.Insert_Flag(I) := 1;
310: ELSE
311: oe_debug_pub.add('in OEXFAVAB, MRP_ATP_CALC_SD profile set to No ' );
312: in_atp_rec.Insert_Flag(I) := 0;

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

307: IF nvl(l_mrp_calc_sd,'N') = 'Y' THEN
308: oe_debug_pub.add('in OEXFAVAB, MRP_ATP_CALC_SD profile set to yes ' );
309: in_atp_rec.Insert_Flag(I) := 1;
310: ELSE
311: oe_debug_pub.add('in OEXFAVAB, MRP_ATP_CALC_SD profile set to No ' );
312: in_atp_rec.Insert_Flag(I) := 0;
313: END IF;
314: --end bug14222176
315:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1162: l_lot_control_code NUMBER;
1163: l_org_id NUMBER;
1164:
1165: --
1166: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1167: --
1168: BEGIN
1169:
1170: IF l_debug_level > 0 THEN

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

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

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

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

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

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

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

1240:
1241: )IS
1242:
1243: --
1244: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1245: --
1246: BEGIN
1247: SELECT organization_code,
1248: name

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

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

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

1270:
1271: l_line_index pls_integer := 0;
1272:
1273: --
1274: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1275: --
1276: BEGIN
1277:
1278: IF l_debug_level > 0 THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1755: ,p_qualifier_contexts_tbl => p_qualifier_Contexts_Tbl
1756: );*/
1757:
1758: IF l_debug_level > 0 THEN
1759: oe_debug_pub.add( 'EXIT QP_ATTR_MAPPING_PUB.BUILD_CONTEXTS FOR HEADER' , 1 ) ;
1760: END IF;
1761:
1762: EXCEPTION
1763: when no_data_found then

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

1781:
1782: i pls_integer;
1783:
1784: --
1785: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1786:
1787: --
1788: BEGIN
1789:

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

1787: --
1788: BEGIN
1789:
1790: IF l_debug_level > 0 THEN
1791: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;
1792: END IF;
1793:
1794: IF g_panda_rec_table(p_g_line_index).p_pricing_attribute1 is not null then
1795: i := px_Req_line_attr_tbl.count+1;

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

2696: px_Req_line_attr_tbl(i).Pricing_Attr_Value_From:=g_panda_rec_table(p_g_line_index).p_pricing_attribute100;
2697: end if;
2698:
2699: IF l_debug_level > 0 THEN
2700: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.APPEND_ATTRIBUTES' , 1 ) ;
2701: END IF;
2702:
2703: END Append_attributes;
2704:

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

2706: )
2707: IS
2708: i number;
2709: k number;
2710: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2711: l_attribute_type VARCHAR2(30);
2712: BEGIN
2713: --Temp Tables
2714: k:=G_ATTR_PRICING_ATTRIBUTE_TBL.count;

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

2713: --Temp Tables
2714: k:=G_ATTR_PRICING_ATTRIBUTE_TBL.count;
2715: i := px_req_line_attr_tbl.first;
2716: if l_debug_level >0 then
2717: oe_debug_pub.add('****populating attributes in to temp table **********');
2718: end if;
2719:
2720: if l_debug_level > 0 then
2721:

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

2718: end if;
2719:
2720: if l_debug_level > 0 then
2721:
2722: oe_debug_pub.add('k='||k||'i='||i);
2723: end if;
2724:
2725: while i is not null loop
2726: k:=k+1;

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

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

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

2736: l_attribute_type := QP_PREQ_GRP.G_PRICING_TYPE;
2737: END IF;
2738: G_ATTR_LINE_INDEX_tbl(k) := px_req_line_attr_tbl(i).line_index;
2739: IF l_debug_level > 0 THEN
2740: oe_debug_pub.add( 'LINE_INDEX:'||G_ATTR_LINE_INDEX_TBL ( K ) ) ;
2741: END IF;
2742: G_ATTR_LINE_DETAIL_INDEX_tbl(k) := NULL;
2743: G_ATTR_ATTRIBUTE_LEVEL_tbl(k) := QP_PREQ_GRP.G_LINE_LEVEL;
2744: G_ATTR_VALIDATED_FLAG_tbl(k) := 'N';

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

2786:
2787:
2788: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
2789: --
2790: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2791: --
2792: BEGIN
2793: G_LINE_INDEX_tbl.delete;
2794: G_LINE_TYPE_CODE_TBL.delete ;

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

2850: G_ATTR_PRIMARY_UOM_FLAG_TBL.delete;
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: IF l_debug_level > 0 THEN
2854: oe_debug_pub.add( L_ROUTINE||': '||SQLERRM , 1 ) ;
2855: END IF;
2856: END reset_all_tbls;
2857:
2858:

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

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

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

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

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

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

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

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

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

2962: END IF;
2963:
2964: END IF;
2965: IF l_debug_level > 0 THEN
2966: oe_debug_pub.add( 'AFTER DIRECT INSERT INTO TEMP TABLE: BULK INSERT' , 1 ) ;
2967: END IF;
2968:
2969: EXCEPTION
2970: WHEN OTHERS THEN

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

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

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

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

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

3186:
3187:
3188: --Populate Line detail
3189:
3190: oe_debug_pub.add('----Line detail information return back to caller----');
3191:
3192: FOR l_dets IN l_ldets_cur LOOP
3193:
3194: oe_debug_pub.add('----populating line detail output------');

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

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

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

3255: x_line_detail_tbl(I).CHANGE_REASON_CODE := substr(l_dets.CHANGE_REASON_CODE,1,240);
3256:
3257: IF l_status_code = FND_API.G_RET_STS_ERROR THEN
3258: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3259: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3260: --END IF;
3261: END IF;
3262:
3263: x_line_detail_tbl(I).EXPIRATION_DATE :=l_expiration_period_end_date;

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

3265: I:=1;
3266:
3267: --Populate Qualifier detail
3268: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3269: oe_debug_pub.add('----Before populate x_qual_tbl-----');
3270: --END IF;
3271: FOR l_qual IN l_qual_cur(QP_PREQ_GRP.G_DETAIL_LEVEL) LOOP
3272: x_line_detail_qual_tbl(I).LINE_DETAIL_INDEX := l_qual.LINE_DETAIL_INDEX;
3273: x_line_detail_qual_tbl(I).QUALIFIER_CONTEXT := l_qual.CONTEXT;

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

3283: I:=1;
3284:
3285: --LINE ATTRIBUTE DETAIL NEEDED
3286: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3287: oe_debug_pub.add('----Before populate attr_tbl-----');
3288: --END IF;
3289: FOR l_prc IN l_pricing_attr_cur LOOP
3290: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3291: oe_debug_pub.add('--------populating x_line_detail_attr----------');

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

3287: oe_debug_pub.add('----Before populate attr_tbl-----');
3288: --END IF;
3289: FOR l_prc IN l_pricing_attr_cur LOOP
3290: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3291: oe_debug_pub.add('--------populating x_line_detail_attr----------');
3292: oe_debug_pub.add('Line Detail Index: '||l_prc.LINE_DETAIL_INDEX);
3293: --END IF;
3294: x_line_detail_attr_tbl(I).LINE_DETAIL_INDEX := l_prc.LINE_DETAIL_INDEX;
3295: x_line_detail_attr_tbl(I).PRICING_CONTEXT := l_prc.PRICING_CONTEXT;

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

3288: --END IF;
3289: FOR l_prc IN l_pricing_attr_cur LOOP
3290: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3291: oe_debug_pub.add('--------populating x_line_detail_attr----------');
3292: oe_debug_pub.add('Line Detail Index: '||l_prc.LINE_DETAIL_INDEX);
3293: --END IF;
3294: x_line_detail_attr_tbl(I).LINE_DETAIL_INDEX := l_prc.LINE_DETAIL_INDEX;
3295: x_line_detail_attr_tbl(I).PRICING_CONTEXT := l_prc.PRICING_CONTEXT;
3296: x_line_detail_attr_tbl(I).PRICING_ATTRIBUTE := l_prc.PRICING_ATTRIBUTE;

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

3304:
3305: I:=1;
3306:
3307: --IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3308: oe_debug_pub.add('----Before populate l_rltd_lines_tbl-----');
3309: --END IF;
3310: FOR l_rltd IN l_rltd_lines_cur LOOP
3311: x_related_lines_tbl(I).LINE_INDEX := l_rltd.Line_index;
3312: x_related_lines_tbl(I).LINE_DETAIL_INDEX := l_rltd.LINE_DETAIL_INDEX;

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

3320:
3321: EXCEPTION
3322: WHEN E_ROUTINE_ERROR THEN
3323: -- IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
3324: oe_debug_pub.add(l_routine||':'||substr(l_status_text,1,240));
3325: -- END IF;
3326:
3327: END Populate_results;
3328:

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

3351: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
3352: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
3353: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type; --added for bug 12541442
3354: --
3355: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3356: --
3357: BEGIN
3358:
3359: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;

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

3359: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;
3360: reset_all_tbls;
3361:
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'SETTING REQUEST ID' , 1 ) ;
3364: END IF;
3365:
3366: qp_price_request_context.set_request_id;
3367:

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

3365:
3366: qp_price_request_context.set_request_id;
3367:
3368: IF l_debug_level > 0 THEN
3369: oe_debug_pub.add('REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
3370: END IF;
3371:
3372:
3373: OE_ORDER_PUB.G_HDR:=NULL;

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

3433: ,px_Req_qual_tbl => l_req_qual_tbl
3434: ,p_g_line_index =>1
3435: );
3436:
3437: oe_Debug_pub.add(' Populating the attr tables');
3438: append_attr_to_TTables(px_req_line_attr_tbl=>l_req_line_attr_tbl);
3439:
3440: out_req_line_tbl(1).status_Code := null;
3441: out_req_line_tbl(1).status_text := null;

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

3443: IF l_debug_level > 0 THEN
3444: print_time('Calling PE');
3445: END IF;
3446:
3447: oe_Debug_pub.add(' Populating the temp tables');
3448: populate_temp_table;
3449:
3450: --added for bug 12541442
3451: IF l_debug_level > 0 THEN

Line 3452: oe_Debug_pub.add('Value of OE_ORDER_PUB.G_HDR.CONVERSION_RATE is '||OE_ORDER_PUB.G_HDR.CONVERSION_RATE);

3448: populate_temp_table;
3449:
3450: --added for bug 12541442
3451: IF l_debug_level > 0 THEN
3452: oe_Debug_pub.add('Value of OE_ORDER_PUB.G_HDR.CONVERSION_RATE is '||OE_ORDER_PUB.G_HDR.CONVERSION_RATE);
3453: oe_Debug_pub.add('Value of OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE is '||OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE);
3454: END IF;
3455:
3456: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;

Line 3453: oe_Debug_pub.add('Value of OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE is '||OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE);

3449:
3450: --added for bug 12541442
3451: IF l_debug_level > 0 THEN
3452: oe_Debug_pub.add('Value of OE_ORDER_PUB.G_HDR.CONVERSION_RATE is '||OE_ORDER_PUB.G_HDR.CONVERSION_RATE);
3453: oe_Debug_pub.add('Value of OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE is '||OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE);
3454: END IF;
3455:
3456: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
3457: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;

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

3467:
3468: IF l_debug_level > 0 THEN
3469: print_time('After Calling PE');
3470: END IF;
3471: oe_debug_pub.add('After caling the pricing engine');
3472:
3473: populate_results(
3474: x_line_tbl =>out_req_line_tbl
3475: ,x_line_qual_tbl =>out_Req_qual_tbl

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

3483: print_time('After populating the pl/sql records');
3484: END IF;
3485:
3486: IF l_debug_level > 0 THEN
3487: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
3488: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
3489: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
3490: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
3491: END IF;

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

3484: END IF;
3485:
3486: IF l_debug_level > 0 THEN
3487: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
3488: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
3489: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
3490: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
3491: END IF;
3492:

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

3485:
3486: IF l_debug_level > 0 THEN
3487: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
3488: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
3489: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
3490: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
3491: END IF;
3492:
3493: if out_req_line_tbl.count > 0 then

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

3486: IF l_debug_level > 0 THEN
3487: oe_debug_pub.add( '******AFTER CALLING PRICING ENGINE' ) ;
3488: oe_debug_pub.add( 'MAIN STATUS ='||L_RETURN_STATUS ) ;
3489: oe_debug_pub.add( 'MAIN TEXT ='||L_RETURN_STATUS_TEXT ) ;
3490: oe_debug_pub.add( 'COUNT LINE TABLE='||OUT_REQ_LINE_TBL.COUNT ) ;
3491: END IF;
3492:
3493: if out_req_line_tbl.count > 0 then
3494: for i in out_req_line_tbl.first..out_req_line_tbl.last

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

3494: for i in out_req_line_tbl.first..out_req_line_tbl.last
3495: loop
3496:
3497: IF l_debug_level > 0 THEN
3498: oe_debug_pub.add( '*******************************' ) ;
3499: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3500: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3501: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;

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

3495: loop
3496:
3497: IF l_debug_level > 0 THEN
3498: oe_debug_pub.add( '*******************************' ) ;
3499: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3500: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3501: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;

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

3496:
3497: IF l_debug_level > 0 THEN
3498: oe_debug_pub.add( '*******************************' ) ;
3499: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3500: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3501: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;

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

3497: IF l_debug_level > 0 THEN
3498: oe_debug_pub.add( '*******************************' ) ;
3499: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3500: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3501: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;

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

3498: oe_debug_pub.add( '*******************************' ) ;
3499: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3500: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3501: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;

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

3499: oe_debug_pub.add( 'REQUEST_TYPE_CODE ='|| OUT_REQ_LINE_TBL ( I ) .REQUEST_TYPE_CODE ) ;
3500: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3501: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;

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

3500: oe_debug_pub.add( 'PRICING_EVENT ='||OUT_REQ_LINE_TBL ( I ) .PRICING_EVENT ) ;
3501: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;

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

3501: oe_debug_pub.add( 'HEADER_ID ='||OUT_REQ_LINE_TBL ( I ) .HEADER_ID ) ;
3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;

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

3502: oe_debug_pub.add( 'LINE_TYPE_CODE='||OUT_REQ_LINE_TBL ( I ) .LINE_TYPE_CODE ) ;
3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;

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

3503: oe_debug_pub.add( 'LINE_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .LINE_QUANTITY ) ;
3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;

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

3504: oe_debug_pub.add( 'LINE_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .LINE_UOM_CODE ) ;
3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;

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

3505: oe_debug_pub.add( 'UOM_QUANTITY ='||OUT_REQ_LINE_TBL ( I ) .UOM_QUANTITY ) ;
3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;

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

3506: oe_debug_pub.add( 'PRI_QUANTITY='||OUT_REQ_LINE_TBL ( I ) .PRICED_QUANTITY ) ;
3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;

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

3507: oe_debug_pub.add( 'PR_UOM_CODE ='||OUT_REQ_LINE_TBL ( I ) .PRICED_UOM_CODE ) ;
3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;

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

3508: oe_debug_pub.add( 'CURRENCY_CODE ='||OUT_REQ_LINE_TBL ( I ) .CURRENCY_CODE ) ;
3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;

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

3509: oe_debug_pub.add( 'UNIT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .UNIT_PRICE ) ;
3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;

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

3510: oe_debug_pub.add( 'PERCENT_PRICE ='||OUT_REQ_LINE_TBL ( I ) .PERCENT_PRICE ) ;
3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;

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

3511: oe_debug_pub.add( 'ADJ_UNIT_PRICE='|| OUT_REQ_LINE_TBL ( I ) .ADJUSTED_UNIT_PRICE ) ;
3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;

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

3512: oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;

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

3513: oe_debug_pub.add( 'ROUNDING_FAC='||OUT_REQ_LINE_TBL ( I ) .ROUNDING_FACTOR ) ;
3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;

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

3514: oe_debug_pub.add( 'PRICE_FLAG ='||OUT_REQ_LINE_TBL ( I ) .PRICE_FLAG ) ;
3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;

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

3515: oe_debug_pub.add( 'PRICE_REQUEST_CODE ='|| OUT_REQ_LINE_TBL ( I ) .PRICE_REQUEST_CODE ) ;
3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3523: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;

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

3516: oe_debug_pub.add( 'HOLD_CODE ='||OUT_REQ_LINE_TBL ( I ) .HOLD_CODE ) ;
3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3523: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3524: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;

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

3517: oe_debug_pub.add( 'HOLD_TEXT ='||OUT_REQ_LINE_TBL ( I ) .HOLD_TEXT ) ;
3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3523: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3524: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3525: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;

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

3518: oe_debug_pub.add( 'STATUS_CODE ='||OUT_REQ_LINE_TBL ( I ) .STATUS_CODE ) ;
3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3523: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3524: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3525: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3526: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;

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

3519: oe_debug_pub.add( 'STATUS_TEXT ='||OUT_REQ_LINE_TBL ( I ) .STATUS_TEXT ) ;
3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3523: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3524: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3525: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3526: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
3527: END IF;

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

3520: oe_debug_pub.add( 'USAGE_PRICING_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .USAGE_PRICING_TYPE ) ;
3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3523: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3524: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3525: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3526: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
3527: END IF;
3528: end loop;

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

3521: oe_debug_pub.add( 'LINE_CATEGORY ='||OUT_REQ_LINE_TBL ( I ) .LINE_CATEGORY ) ;
3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3523: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3524: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3525: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3526: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
3527: END IF;
3528: end loop;
3529: end if;

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

3522: oe_debug_pub.add( 'PRICING EFFECTIVE DATE='|| OUT_REQ_LINE_TBL ( I ) .PRICING_EFFECTIVE_DATE ) ;
3523: oe_debug_pub.add( 'ACTIVE_DATE_FIRST ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST ) ;
3524: oe_debug_pub.add( 'ACTIVE_DATE_FIRST_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_FIRST_TYPE ) ;
3525: oe_debug_pub.add( 'ACTIVE_DATE_SECOND ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND ) ;
3526: oe_debug_pub.add( 'ACTIVE_DATE_SECOND_TYPE ='|| OUT_REQ_LINE_TBL ( I ) .ACTIVE_DATE_SECOND_TYPE ) ;
3527: END IF;
3528: end loop;
3529: end if;
3530:

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

3528: end loop;
3529: end if;
3530:
3531: IF l_debug_level > 0 THEN
3532: oe_debug_pub.add( 'COUNT LINE DETAIL TABLE='||OUT_REQ_LINE_DETAIL_TBL.COUNT ) ;
3533: END IF;
3534:
3535: if out_req_line_detail_tbl.count > 0 then
3536:

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

3537: for i in out_req_line_detail_tbl.first..out_req_line_detail_tbl.last
3538: loop
3539:
3540: IF l_debug_level > 0 THEN
3541: oe_debug_pub.add( 'LINE DETAIL TABLE RECORD='||I ) ;
3542: END IF;
3543:
3544: IF out_req_line_detail_tbl.exists(i) then
3545:

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

3543:
3544: IF out_req_line_detail_tbl.exists(i) then
3545:
3546: IF l_debug_level > 0 THEN
3547: oe_debug_pub.add( '*******************************' ) ;
3548: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3549: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3550: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;

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

3544: IF out_req_line_detail_tbl.exists(i) then
3545:
3546: IF l_debug_level > 0 THEN
3547: oe_debug_pub.add( '*******************************' ) ;
3548: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3549: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3550: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;

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

3545:
3546: IF l_debug_level > 0 THEN
3547: oe_debug_pub.add( '*******************************' ) ;
3548: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3549: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3550: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;

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

3546: IF l_debug_level > 0 THEN
3547: oe_debug_pub.add( '*******************************' ) ;
3548: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3549: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3550: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;

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

3547: oe_debug_pub.add( '*******************************' ) ;
3548: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3549: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3550: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;

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

3548: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_INDEX ) ;
3549: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3550: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;

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

3549: oe_debug_pub.add( 'LIST_LINE_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_TYPE_CODE ) ;
3550: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;

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

3550: oe_debug_pub.add( 'LINE_DETAIL_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_DETAIL_TYPE_CODE ) ;
3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;

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

3551: oe_debug_pub.add( 'CREATED_FROM_LIST_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .CREATED_FROM_LIST_TYPE_CODE ) ;
3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);

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

3552: oe_debug_pub.add( 'AUTOMATIC_FLAG='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .AUTOMATIC_FLAG ) ;
3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;

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

3553: oe_debug_pub.add( 'ACCRUAL='||OUT_REQ_LINE_DETAIL_TBL ( I ) .ACCRUAL_FLAG ) ;
3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;

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

3554: oe_debug_pub.add( 'STATUS='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_CODE ) ;
3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;

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

3555: oe_debug_pub.add( 'STS_TEXT='||OUT_REQ_LINE_DETAIL_TBL ( I ) .STATUS_TEXT ) ;
3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3563: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;

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

3556: oe_debug_pub.add( 'LIST_HEADER_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_HEADER_ID ) ;
3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3563: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3564: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;

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

3557: oe_debug_pub.add( 'LIST_LINE_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_LINE_ID ) ;
3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3563: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3564: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3565: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );

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

3558: oe_debug_pub.add( 'PRICE_BREAK_TYPE_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .PRICE_BREAK_TYPE_CODE ) ;
3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3563: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3564: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3565: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3566: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);

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

3559: oe_debug_pub.add( 'OPERAND_CALCULATION_CODE='||OUT_REQ_LINE_DETAIL_TBL(I).OPERAND_CALCULATION_CODE);
3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3563: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3564: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3565: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3566: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);
3567: end if;

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

3560: oe_debug_pub.add( 'LST_PRICE='||OUT_REQ_LINE_DETAIL_TBL ( I ) .LIST_PRICE ) ;
3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3563: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3564: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3565: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3566: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);
3567: end if;
3568: end if;

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

3561: oe_debug_pub.add( 'ADJUSTMENT_AMOUNT='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .ADJUSTMENT_AMOUNT ) ;
3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3563: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3564: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3565: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3566: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);
3567: end if;
3568: end if;
3569: end loop;

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

3562: oe_debug_pub.add( 'LINE_QUANTITY='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .LINE_QUANTITY ) ;
3563: oe_debug_pub.add( 'MODIFIER_LEVEL_CODE='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .MODIFIER_LEVEL_CODE ) ;
3564: oe_debug_pub.add( 'INVENTORY_ITEM_ID='|| OUT_REQ_LINE_DETAIL_TBL ( I ) .INVENTORY_ITEM_ID ) ;
3565: oe_debug_pub.add( 'RECURRING_FLAG='||OUT_REQ_LINE_DETAIL_TBL (I).RECURRING_FLAG );
3566: oe_debug_pub.add( 'RECURRING_VALUE='||OUT_REQ_LINE_DETAIL_TBL(I).RECURRING_VALUE);
3567: end if;
3568: end if;
3569: end loop;
3570:

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

3571: end if;
3572:
3573:
3574: IF l_debug_level > 0 THEN
3575: oe_debug_pub.add( 'COUNT LINE DETAIL ATTR TBL='|| OUT_REQ_LINE_DETAIL_ATTR_TBL.COUNT ) ;
3576: END IF;
3577:
3578: if out_req_line_detail_attr_tbl.count > 0 then
3579: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last

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

3578: if out_req_line_detail_attr_tbl.count > 0 then
3579: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
3580: loop
3581: IF l_debug_level > 0 THEN
3582: oe_debug_pub.add( '*******************************' ) ;
3583: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3584: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3585: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3586: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

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

3579: for i in out_req_line_detail_attr_tbl.first..out_req_line_detail_attr_tbl.last
3580: loop
3581: IF l_debug_level > 0 THEN
3582: oe_debug_pub.add( '*******************************' ) ;
3583: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3584: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3585: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3586: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3587: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

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

3580: loop
3581: IF l_debug_level > 0 THEN
3582: oe_debug_pub.add( '*******************************' ) ;
3583: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3584: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3585: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3586: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3587: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3588: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

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

3581: IF l_debug_level > 0 THEN
3582: oe_debug_pub.add( '*******************************' ) ;
3583: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3584: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3585: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3586: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3587: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3588: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3589: END IF;

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

3582: oe_debug_pub.add( '*******************************' ) ;
3583: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3584: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3585: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3586: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3587: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3588: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3589: END IF;
3590:

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

3583: oe_debug_pub.add( 'LINE DETAIL ATTR_TABLE RECORD='||I ) ;
3584: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3585: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3586: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3587: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3588: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3589: END IF;
3590:
3591: end loop;

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

3584: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3585: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3586: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3587: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3588: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3589: END IF;
3590:
3591: end loop;
3592: end if;

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

3592: end if;
3593:
3594:
3595: IF l_debug_level > 0 THEN
3596: oe_debug_pub.add( 'COUNT LINE ATTR TBL='||OUT_REQ_LINE_ATTR_TBL.COUNT ) ;
3597: END IF;
3598:
3599: if out_req_line_attr_tbl.count > 0 then
3600: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last

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

3599: if out_req_line_attr_tbl.count > 0 then
3600: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
3601: loop
3602: IF l_debug_level > 0 THEN
3603: oe_debug_pub.add( '*******************************' ) ;
3604: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3605: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3606: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3607: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;

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

3600: for i in out_req_line_attr_tbl.first..out_req_line_attr_tbl.last
3601: loop
3602: IF l_debug_level > 0 THEN
3603: oe_debug_pub.add( '*******************************' ) ;
3604: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3605: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3606: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3607: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3608: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;

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

3601: loop
3602: IF l_debug_level > 0 THEN
3603: oe_debug_pub.add( '*******************************' ) ;
3604: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3605: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3606: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3607: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3608: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3609: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;

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

3602: IF l_debug_level > 0 THEN
3603: oe_debug_pub.add( '*******************************' ) ;
3604: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3605: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3606: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3607: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3608: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3609: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3610: END IF;

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

3603: oe_debug_pub.add( '*******************************' ) ;
3604: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3605: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3606: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3607: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3608: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3609: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3610: END IF;
3611:

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

3604: oe_debug_pub.add( 'LINE ATTR_TABLE RECORD='||I ) ;
3605: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3606: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3607: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3608: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3609: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3610: END IF;
3611:
3612: end loop;

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

3605: oe_debug_pub.add( 'LINE_INDEX='||OUT_REQ_LINE_ATTR_TBL ( I ) .LINE_INDEX ) ;
3606: oe_debug_pub.add( 'PRICING_CONTEXT='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_CONTEXT ) ;
3607: oe_debug_pub.add( 'PRICING_ATTRIBUTE='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTRIBUTE ) ;
3608: oe_debug_pub.add( 'PRICING_ATTR_VALUE_FROM='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_FROM ) ;
3609: oe_debug_pub.add( 'PRICING_ATTR_VALUE_TO='|| OUT_REQ_LINE_ATTR_TBL ( I ) .PRICING_ATTR_VALUE_TO ) ;
3610: END IF;
3611:
3612: end loop;
3613: end if;

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

3613: end if;
3614:
3615:
3616: IF l_debug_level > 0 THEN
3617: oe_debug_pub.add( 'COUNT RELATED LINES TBL='|| OUT_REQ_RELATED_LINES_TBL.COUNT ) ;
3618: END IF;
3619:
3620: if out_req_related_lines_tbl.count > 0 then
3621: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last

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

3620: if out_req_related_lines_tbl.count > 0 then
3621: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
3622: loop
3623: IF l_debug_level > 0 THEN
3624: oe_debug_pub.add( '*******************************' ) ;
3625: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3626: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3627: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3628: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;

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

3621: for i in out_req_related_lines_tbl.first..out_req_related_lines_tbl.last
3622: loop
3623: IF l_debug_level > 0 THEN
3624: oe_debug_pub.add( '*******************************' ) ;
3625: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3626: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3627: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3628: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3629: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;

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

3622: loop
3623: IF l_debug_level > 0 THEN
3624: oe_debug_pub.add( '*******************************' ) ;
3625: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3626: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3627: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3628: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3629: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3630: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;

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

3623: IF l_debug_level > 0 THEN
3624: oe_debug_pub.add( '*******************************' ) ;
3625: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3626: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3627: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3628: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3629: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3630: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
3631: END IF;

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

3624: oe_debug_pub.add( '*******************************' ) ;
3625: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3626: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3627: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3628: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3629: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3630: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
3631: END IF;
3632:

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

3625: oe_debug_pub.add( 'RELATD LINES RECORD='||I ) ;
3626: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3627: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3628: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3629: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3630: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
3631: END IF;
3632:
3633: end loop;

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

3626: oe_debug_pub.add( 'LIN_INDEX='||OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_INDEX ) ;
3627: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3628: oe_debug_pub.add( 'RELATIONSHIP_TYPE_CODE='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATIONSHIP_TYPE_CODE ) ;
3629: oe_debug_pub.add( 'RELATED_LINE_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_INDEX ) ;
3630: oe_debug_pub.add( 'RELATED_LINE_DETAIL_INDEX='|| OUT_REQ_RELATED_LINES_TBL ( I ) .RELATED_LINE_DETAIL_INDEX ) ;
3631: END IF;
3632:
3633: end loop;
3634: end if;

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

3634: end if;
3635:
3636:
3637: IF l_debug_level > 0 THEN
3638: oe_debug_pub.add( 'COUNT LINE QUAL TBL='||OUT_REQ_QUAL_TBL.COUNT ) ;
3639: END IF;
3640:
3641: if out_req_qual_tbl.count > 0 then
3642: for i in out_req_qual_tbl.first..out_req_qual_tbl.last

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

3641: if out_req_qual_tbl.count > 0 then
3642: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
3643: loop
3644: IF l_debug_level > 0 THEN
3645: oe_debug_pub.add('*******************************' ) ;
3646: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3647: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3648: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

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

3642: for i in out_req_qual_tbl.first..out_req_qual_tbl.last
3643: loop
3644: IF l_debug_level > 0 THEN
3645: oe_debug_pub.add('*******************************' ) ;
3646: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3647: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3648: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3650: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

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

3643: loop
3644: IF l_debug_level > 0 THEN
3645: oe_debug_pub.add('*******************************' ) ;
3646: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3647: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3648: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3650: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3651: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

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

3644: IF l_debug_level > 0 THEN
3645: oe_debug_pub.add('*******************************' ) ;
3646: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3647: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3648: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3650: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3651: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3652: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

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

3645: oe_debug_pub.add('*******************************' ) ;
3646: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3647: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3648: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3650: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3651: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3652: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3653: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

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

3646: oe_debug_pub.add('QUAL TABLE RECORD='||I ) ;
3647: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3648: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3650: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3651: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3652: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3653: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3654: END IF;

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

3647: oe_debug_pub.add('LINE_INDEX='||OUT_REQ_QUAL_TBL ( I ) .LINE_INDEX ) ;
3648: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3650: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3651: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3652: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3653: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3654: END IF;
3655:

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

3648: oe_debug_pub.add('QUALIFIER_CONTEXT='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3650: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3651: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3652: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3653: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3654: END IF;
3655:
3656: end loop;

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

3649: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3650: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3651: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3652: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3653: oe_debug_pub.add( 'VALIDATED_FLAG='||OUT_REQ_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3654: END IF;
3655:
3656: end loop;
3657: end if;

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

3657: end if;
3658:
3659:
3660: IF l_debug_level > 0 THEN
3661: oe_debug_pub.add( 'COUNT LINE DETAIL QUAL TBL='|| OUT_REQ_LINE_DETAIL_QUAL_TBL.COUNT ) ;
3662: END IF;
3663:
3664: if out_req_line_detail_qual_tbl.count > 0 then
3665: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last

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

3664: if out_req_line_detail_qual_tbl.count > 0 then
3665: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
3666: loop
3667: IF l_debug_level > 0 THEN
3668: oe_debug_pub.add( '*******************************' ) ;
3669: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3670: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3671: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;

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

3665: for i in out_req_line_detail_qual_tbl.first..out_req_line_detail_qual_tbl.last
3666: loop
3667: IF l_debug_level > 0 THEN
3668: oe_debug_pub.add( '*******************************' ) ;
3669: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3670: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3671: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3673: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;

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

3666: loop
3667: IF l_debug_level > 0 THEN
3668: oe_debug_pub.add( '*******************************' ) ;
3669: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3670: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3671: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3673: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3674: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;

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

3667: IF l_debug_level > 0 THEN
3668: oe_debug_pub.add( '*******************************' ) ;
3669: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3670: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3671: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3673: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3674: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3675: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;

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

3668: oe_debug_pub.add( '*******************************' ) ;
3669: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3670: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3671: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3673: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3674: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3675: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3676: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;

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

3669: oe_debug_pub.add( 'LINE DETAIL QUAL TABLE RECORD='||I ) ;
3670: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3671: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3673: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3674: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3675: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3676: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3677: END IF;

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

3670: oe_debug_pub.add( 'LINE_DETAIL_INDEX='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .LINE_DETAIL_INDEX ) ;
3671: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3673: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3674: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3675: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3676: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3677: END IF;
3678:

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

3671: oe_debug_pub.add( 'QUALIFIER_CONTEXT='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_CONTEXT ) ;
3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3673: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3674: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3675: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3676: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3677: END IF;
3678:
3679: end loop;

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

3672: oe_debug_pub.add( 'QUALIFIER_ATTRIBUTE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTRIBUTE ) ;
3673: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_FROM='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_FROM ) ;
3674: oe_debug_pub.add( 'QUALIFIER_ATTR_VALUE_TO='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .QUALIFIER_ATTR_VALUE_TO ) ;
3675: oe_debug_pub.add( 'COMPARISON_OPERATOR_CODE='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .COMPARISON_OPERATOR_CODE ) ;
3676: oe_debug_pub.add( 'VALIDATED_FLAG='|| OUT_REQ_LINE_DETAIL_QUAL_TBL ( I ) .VALIDATED_FLAG ) ;
3677: END IF;
3678:
3679: end loop;
3680: end if;

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

3680: end if;
3681:
3682:
3683: IF l_debug_level > 0 THEN
3684: oe_debug_pub.add( 'EXITING PRICE_ITEM*******************************' ) ;
3685: END IF;
3686:
3687: EXCEPTION
3688: when others then

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

3687: EXCEPTION
3688: when others then
3689:
3690: IF l_debug_level > 0 THEN
3691: oe_debug_pub.add( 'PRICE ITEM EXCEPTION WHEN OTHERS CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
3692: END IF;
3693:
3694: END price_item;
3695:

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

3701:
3702: g_panda_rec_table.delete;
3703: for i in in_panda_rec_table.first..in_panda_rec_table.last
3704: loop
3705: oe_debug_pub.add(' Line Record Nbr='||i);
3706:
3707: g_panda_rec_table(i):=in_panda_rec_table(i);
3708: oe_debug_pub.add('*******IT STARTS HERE*****');
3709: oe_debug_pub.add('index is'||i||' item is='||g_panda_rec_table(i).p_inventory_item_id);

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

3704: loop
3705: oe_debug_pub.add(' Line Record Nbr='||i);
3706:
3707: g_panda_rec_table(i):=in_panda_rec_table(i);
3708: oe_debug_pub.add('*******IT STARTS HERE*****');
3709: oe_debug_pub.add('index is'||i||' item is='||g_panda_rec_table(i).p_inventory_item_id);
3710:
3711: end loop;
3712:

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

3705: oe_debug_pub.add(' Line Record Nbr='||i);
3706:
3707: g_panda_rec_table(i):=in_panda_rec_table(i);
3708: oe_debug_pub.add('*******IT STARTS HERE*****');
3709: oe_debug_pub.add('index is'||i||' item is='||g_panda_rec_table(i).p_inventory_item_id);
3710:
3711: end loop;
3712:
3713: END pass_values_to_backend;

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

3726: l_attr_index pls_integer := nvl(px_Req_line_attr_tbl.last,0);
3727: l_qual_index pls_integer := nvl(px_Req_qual_tbl.last,0);
3728:
3729: --
3730: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3731: --
3732: BEGIN
3733:
3734: IF l_debug_level > 0 THEN

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

3731: --
3732: BEGIN
3733:
3734: IF l_debug_level > 0 THEN
3735: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;
3736: END IF;
3737: i := p_pricing_contexts_Tbl.First;
3738: While i is not null loop
3739: l_attr_index := l_attr_index +1;

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

3782: i := p_qualifier_contexts_Tbl.Next(i);
3783: end loop;
3784:
3785: IF l_debug_level > 0 THEN
3786: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.COPY_ATTRIBS_TO_REQ' , 1 ) ;
3787: END IF;
3788:
3789: END copy_attribs_to_Req;
3790:

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

3845: l_operand number;
3846: l_msg_text Varchar2(2000);
3847:
3848: --
3849: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3850: --
3851: BEGIN
3852:
3853: IF l_debug_level > 0 THEN

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

3850: --
3851: BEGIN
3852:
3853: IF l_debug_level > 0 THEN
3854: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;
3855: END IF;
3856: IF l_debug_level > 0 THEN
3857: 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 ) ;
3858: END IF;

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

3853: IF l_debug_level > 0 THEN
3854: oe_debug_pub.add( 'ENTERING PROCESS_PRICING_ERRORS' ) ;
3855: END IF;
3856: IF l_debug_level > 0 THEN
3857: 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 ) ;
3858: END IF;
3859:
3860:
3861: IF in_line_Type_code ='LINE' and

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

3888:
3889: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
3890:
3891: IF l_debug_level > 0 THEN
3892: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_panda_rec_table(1).p_PRICE_LIST_ID ) ;
3893: END IF;
3894: IF g_panda_rec_table(1).p_price_list_id is null then
3895:
3896: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');

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

3895:
3896: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
3897: FND_MESSAGE.SET_TOKEN('TEXT',in_status_text);
3898: IF l_debug_level > 0 THEN
3899: oe_debug_pub.add( 'INVALID PL ERR TXT='||IN_STATUS_TEXT ) ;
3900: END IF;
3901: OE_MSG_PUB.Add;
3902:
3903: ELSE

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

3901: OE_MSG_PUB.Add;
3902:
3903: ELSE
3904: IF l_debug_level > 0 THEN
3905: oe_debug_pub.add( 'INVALID PRICE LIST' ) ;
3906: END IF;
3907: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
3908: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3909: FND_MESSAGE.SET_TOKEN('UNIT',in_uom);

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

3939: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3940: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3941:
3942: IF l_debug_level > 0 THEN
3943: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3944: END IF;
3945: Begin
3946: Select name into l_price_list
3947: from qp_list_headers_vl a,qp_list_lines b where

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

3956: instr(in_status_text,',')-1);
3957: End;
3958:
3959: IF l_debug_level > 0 THEN
3960: oe_debug_pub.add( 'PRICE LIST 1='||L_PRICE_LIST ) ;
3961: END IF;
3962: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3963: Begin
3964: Select name into l_price_list

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

3973: l_price_list := substr(in_status_text,
3974: instr(in_status_text,',')+1);
3975: End;
3976: IF l_debug_level > 0 THEN
3977: oe_debug_pub.add( 'PRICE LIST 2='||L_PRICE_LIST ) ;
3978: END IF;
3979:
3980: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3981: OE_MSG_PUB.Add;

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

4002:
4003: /*elsif ( in_unit_price < 0 or in_Adjusted_unit_price < 0) and
4004: l_allow_negative_price = 'N' then
4005:
4006: oe_debug_pub.add('Error as Negative Pricing is not Allowed');
4007: FND_MESSAGE.SET_NAME('ONT','ONT_NEGATIVE_PRICE');
4008: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
4009: FND_MESSAGE.SET_TOKEN('LIST_PRICE',in_unit_price);
4010: FND_MESSAGE.SET_TOKEN('SELLING_PRICE',in_Adjusted_unit_price);

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

4018: ELSIF in_line_Type_code ='LINE' and
4019: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
4020:
4021: IF l_debug_level > 0 THEN
4022: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
4023: END IF;
4024: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
4025: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
4026: OE_MSG_PUB.Add;

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

4035: --engine doesn't look at the line and will not return adjustments. In this
4036: --case we DON't want to remove the adjustments that engine doesn't return.
4037: then
4038: IF l_debug_level > 0 THEN
4039: oe_debug_pub.add( 'OE_PRICING_ERROR 2' ) ;
4040: END IF;
4041:
4042: IF in_status_text is not null then
4043: l_return_status := 'E';

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

4051: /*OPEN get_gsa_list_lines;
4052: FETCH get_gsa_list_lines
4053: INTO l_operand;
4054: CLOSE get_gsa_list_lines;
4055: oe_debug_pub.add('After select OE_PRICING_ERROR 2');
4056: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
4057: ' Operand='||l_operand);
4058:
4059: IF in_adjusted_unit_price <= l_operand then

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

4052: FETCH get_gsa_list_lines
4053: INTO l_operand;
4054: CLOSE get_gsa_list_lines;
4055: oe_debug_pub.add('After select OE_PRICING_ERROR 2');
4056: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
4057: ' Operand='||l_operand);
4058:
4059: IF in_adjusted_unit_price <= l_operand then
4060: oe_debug_pub.add('If unit price less than operand violation='||

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

4056: oe_debug_pub.add('Adj price='||in_adjusted_unit_price||
4057: ' Operand='||l_operand);
4058:
4059: IF in_adjusted_unit_price <= l_operand then
4060: oe_debug_pub.add('If unit price less than operand violation='||
4061: l_gsa_violation_action);
4062: --Check if the GSA check needs to be done.
4063: If l_gsa_violation_action in ('WARNING','ERROR') then
4064:

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

4061: l_gsa_violation_action);
4062: --Check if the GSA check needs to be done.
4063: If l_gsa_violation_action in ('WARNING','ERROR') then
4064:
4065: oe_debug_pub.add('GSA warning or error');
4066: Begin
4067: SELECT concatenated_segments
4068: INTO l_msg_text
4069: FROM mtl_system_items_kfv

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

4074: Null;
4075: End;
4076:
4077: l_return_status := 'E';
4078: oe_debug_pub.add('GSA warning or error 2 msg_Text='||l_msg_text);
4079: FND_MESSAGE.SET_NAME('ONT','OE_GSA_VIOLATION');
4080: l_msg_text := l_operand||' ( '||l_msg_text||' )';
4081: FND_MESSAGE.SET_TOKEN('GSA_PRICE',l_msg_text);
4082: OE_MSG_PUB.Add;

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

4094: --need to be pulled out by append_adjustment_lines routine
4095: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
4096: Then
4097: IF l_debug_level > 0 THEN
4098: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
4099: END IF;
4100: null;
4101:
4102: ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then

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

4101:
4102: ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then
4103:
4104: IF l_debug_level > 0 THEN
4105: oe_debug_pub.add( 'STATUS = UPDATED' ) ;
4106: END IF;
4107:
4108: END IF;-- Status_Code
4109:

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

4108: END IF;-- Status_Code
4109:
4110:
4111: IF l_debug_level > 0 THEN
4112: oe_debug_pub.add( 'PROCESS PRICING ERROR AFTER ERR CHK ST='||L_RETURN_STATUS ) ;
4113: END IF;
4114:
4115: IF l_return_status ='E' then
4116: IF l_debug_level > 0 THEN

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

4113: END IF;
4114:
4115: IF l_return_status ='E' then
4116: IF l_debug_level > 0 THEN
4117: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
4118: END IF;
4119: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
4120: p_count => l_msg_count,
4121: p_data=>l_msg_data

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

4122: );
4123: END IF;
4124:
4125: IF l_debug_level > 0 THEN
4126: oe_debug_pub.add( 'EXITING PROCESS_PRICING_ERRORS' ) ;
4127: END IF;
4128:
4129: EXCEPTION
4130:

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

4129: EXCEPTION
4130:
4131: when others then
4132: IF l_debug_level > 0 THEN
4133: oe_debug_pub.add( 'PROCESS PRICING ERRORS WHEN OTHERS EXCEPTION CODE='|| SQLCODE||' MESSAGE='||SQLERRM ) ;
4134: END IF;
4135:
4136: END process_pricing_errors;
4137:

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

4141:
4142: l_rounding_factor number;
4143:
4144: --
4145: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4146: --
4147: BEGIN
4148:
4149: select rounding_factor

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

4183:
4184: l_list_type_code varchar2(300);
4185:
4186: --
4187: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4188: --
4189: BEGIN
4190:
4191: SELECT name,

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

4207: WHERE list_header_id = in_list_header_id;
4208:
4209:
4210: IF l_debug_level > 0 THEN
4211: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
4212: END IF;
4213: IF l_debug_level > 0 THEN
4214: oe_debug_pub.add( 'EXITING OE_AVA.GET_MODIFIER_NAME TYP='||L_LIST_TYPE_CODE ) ;
4215: END IF;

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

4210: IF l_debug_level > 0 THEN
4211: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
4212: END IF;
4213: IF l_debug_level > 0 THEN
4214: oe_debug_pub.add( 'EXITING OE_AVA.GET_MODIFIER_NAME TYP='||L_LIST_TYPE_CODE ) ;
4215: END IF;
4216:
4217: EXCEPTION
4218: when no_data_found then

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

4216:
4217: EXCEPTION
4218: when no_data_found then
4219: IF l_debug_level > 0 THEN
4220: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME NO DATA FOUND' ) ;
4221: END IF;
4222: when others then
4223: IF l_debug_level > 0 THEN
4224: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME WHEN OTHERS '|| SQLERRM||SQLCODE ) ;

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

4220: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME NO DATA FOUND' ) ;
4221: END IF;
4222: when others then
4223: IF l_debug_level > 0 THEN
4224: oe_debug_pub.add( 'OE_AVAILABILITY.GET_MODIFIER_NAME WHEN OTHERS '|| SQLERRM||SQLCODE ) ;
4225: END IF;
4226:
4227: END get_modifier_name;
4228:

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

4239:
4240: ) IS
4241:
4242: --
4243: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4244: --
4245: BEGIN
4246:
4247: SELECT

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

4259: WHERE list_line_id = in_list_line_id;
4260:
4261:
4262: IF l_debug_level > 0 THEN
4263: 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 ) ;
4264: END IF;
4265:
4266: EXCEPTION
4267: when no_data_found then

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

4265:
4266: EXCEPTION
4267: when no_data_found then
4268: IF l_debug_level > 0 THEN
4269: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS NO DATA FOUND' ) ;
4270: END IF;
4271: when others then
4272: IF l_debug_level > 0 THEN
4273: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS WHEN OTHERS '|| SQLERRM||SQLCODE ) ;

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

4269: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS NO DATA FOUND' ) ;
4270: END IF;
4271: when others then
4272: IF l_debug_level > 0 THEN
4273: oe_debug_pub.add( 'OE_AVAILABILITY.GET_LIST_LINE_DETAILS WHEN OTHERS '|| SQLERRM||SQLCODE ) ;
4274: END IF;
4275:
4276: END get_list_line_details;
4277:

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

4281:
4282: l_meaning varchar2(300);
4283:
4284: --
4285: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4286: --
4287: BEGIN
4288:
4289: IF l_debug_level > 0 THEN

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

4286: --
4287: BEGIN
4288:
4289: IF l_debug_level > 0 THEN
4290: oe_debug_pub.add( 'CODE='||IN_LOOKUP_CODE||' TYPE='||IN_LOOKUP_TYPE ) ;
4291: END IF;
4292:
4293: SELECT meaning
4294: INTO l_meaning

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

4304:
4305: EXCEPTION
4306: when no_data_found then
4307: IF l_debug_level > 0 THEN
4308: oe_debug_pub.add( 'OE_AVAILABILITY.GET_QP_LOOKUP_MEANING NO DATA FOUND' ) ;
4309: END IF;
4310: Return Null;
4311:
4312: END get_qp_lookup_meaning;

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

4318: ) return varchar2 IS
4319: l_pricing_attribute varchar2(300);
4320:
4321: --
4322: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4323: --
4324: BEGIN
4325:
4326: IF l_debug_level > 0 THEN

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

4323: --
4324: BEGIN
4325:
4326: IF l_debug_level > 0 THEN
4327: oe_debug_pub.add( 'GET_PRICING_ATTRIBUTE '|| 'IN_CONTEXT = '||IN_CONTEXT_NAME|| 'IN_ATTRIBUTE_NAME='||IN_ATTRIBUTE_NAME ) ;
4328: END IF;
4329: l_pricing_attribute := QP_UTIL.get_attribute_name(
4330: p_application_short_name=> 'QP',
4331: P_FLEXFIELD_NAME =>'QP_ATTR_DEFNS_PRICING',

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

4332: P_CONTEXT_NAME =>in_context_name,
4333: P_ATTRIBUTE_NAME =>in_attribute_name
4334: );
4335: IF l_debug_level > 0 THEN
4336: oe_debug_pub.add( 'EXITING GET_PRICING_ATTRIBUTE ='||L_PRICING_ATTRIBUTE ) ;
4337: END IF;
4338:
4339: return l_pricing_attribute;
4340:

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

4341: EXCEPTION
4342:
4343: WHEN others then
4344: IF l_debug_level > 0 THEN
4345: oe_debug_pub.add( 'WHEN OTHERS FOR GET_PRICING_ATTRIBUTE'|| SQLCODE||SQLERRM ) ;
4346: END IF;
4347: return null;
4348:
4349: END get_pricing_attribute;

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

4372:
4373: ) IS
4374:
4375: --
4376: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4377: --
4378: BEGIN
4379:
4380: IF l_debug_level > 0 THEN

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

4377: --
4378: BEGIN
4379:
4380: IF l_debug_level > 0 THEN
4381: oe_debug_pub.add( 'GET PRICE_LIST ID='||P_PRICE_LIST_ID ) ;
4382: END IF;
4383:
4384: IF p_price_list_id IS NOT NULL THEN
4385:

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

4408:
4409: END IF;
4410:
4411: IF l_debug_level > 0 THEN
4412: oe_debug_pub.add( 'END_DATE='||OUT_END_DATE|| ' START_DATE='||OUT_START_DATE ) ;
4413: END IF;
4414:
4415: EXCEPTION
4416:

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

4415: EXCEPTION
4416:
4417: WHEN NO_DATA_FOUND THEN
4418: IF l_debug_level > 0 THEN
4419: oe_debug_pub.add( 'NO DATA FOUND GET PRICE LIST_INFO' ) ;
4420: END IF;
4421:
4422: WHEN OTHERS THEN
4423: IF l_debug_level > 0 THEN

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

4420: END IF;
4421:
4422: WHEN OTHERS THEN
4423: IF l_debug_level > 0 THEN
4424: oe_debug_pub.add( 'WHEN OTHERS GET PRICE LIST_INFO'|| SQLCODE||SQLERRM ) ;
4425: END IF;
4426:
4427: END get_Price_List_info;
4428:

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

4533: l_ship_from_org_name varchar2(200);
4534: l_make_buy number;
4535:
4536: --
4537: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4538: --
4539: BEGIN
4540:
4541: IF l_debug_level > 0 THEN

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

4538: --
4539: BEGIN
4540:
4541: IF l_debug_level > 0 THEN
4542: oe_debug_pub.add( 'ENTERING OE_OE_AVAILABILITY.GET_ITEM_INFO'||
4543: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID ) ;
4544: END IF;
4545:
4546: OPEN c_item_info;

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

4590: , out_name =>out_wsh_name
4591: );
4592:
4593: IF l_debug_level > 0 THEN
4594: oe_debug_pub.add( 'USER_ITEM_TYPE='||L_USER_ITEM_TYPE ) ;
4595: END IF;
4596:
4597: out_lead_time := l_cummulative_total_lead_time;
4598: out_cost := l_order_cost;

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

4614: out_user_item_type := null;
4615:
4616: END IF;
4617: IF l_debug_level > 0 THEN
4618: oe_debug_pub.add( 'EXITING OE_OE_AVAILABILITY.GET_ITEM_INFO'||
4619: ' ITEM_STATUS ='||OUT_ITEM_STATUS ) ;
4620: END IF;
4621:
4622: EXCEPTION

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

4626: CLOSE c_item_info;
4627: END IF;
4628:
4629: IF l_debug_level > 0 THEN
4630: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.GET_ITEM_INFO '||
4631: 'INV_ITEM_ID='||IN_INVENTORY_ITEM_ID|| 'ORG_ID='||IN_ORG_ID||
4632: 'SQLCODE='||SQLCODE|| 'SQLERRM='||SQLERRM ) ;
4633: END IF;
4634:

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

4645: l_hsecs number;
4646: l_total number;
4647:
4648: --
4649: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4650: --
4651: BEGIN
4652:
4653: --print_time2;

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

4660:
4661: g_hsecs := l_hsecs;
4662: g_place := in_place;
4663: IF l_debug_level > 0 THEN
4664: oe_debug_pub.add( 'TIME STARTING AT PLACE '||G_PLACE||' TIME='||G_HSECS ) ;
4665: END IF;
4666:
4667: ELSE
4668: l_total := (l_hsecs - g_hsecs)/100;

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

4667: ELSE
4668: l_total := (l_hsecs - g_hsecs)/100;
4669: g_total := g_total + l_total;
4670: IF l_debug_level > 0 THEN
4671: oe_debug_pub.add( 'TIME FROM ' ||G_PLACE||' TO '||IN_PLACE||
4672: ' TIME DIFF='|| L_TOTAL||' SECONDS'||' TOTAL SO FAR='||G_TOTAL ) ;
4673: END IF;
4674: g_hsecs := l_hsecs;
4675: g_place := in_place;

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

4689: l_hsecs number;
4690: l_total number;
4691:
4692: --
4693: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4694: --
4695: BEGIN
4696:
4697: OPEN c2_hsecs;

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

4700: CLOSE c2_hsecs;
4701:
4702: IF g_total2 is null then
4703: IF l_debug_level > 0 THEN
4704: oe_debug_pub.add( 'G_TOTAL2 IS NULL L_HSECS='||L_HSECS ) ;
4705: END IF;
4706: g_total2 := l_hsecs;
4707: ELSE
4708: IF l_debug_level > 0 THEN

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

4705: END IF;
4706: g_total2 := l_hsecs;
4707: ELSE
4708: IF l_debug_level > 0 THEN
4709: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;
4710: END IF;
4711: l_total := (l_hsecs - g_total2)/100;
4712: IF l_debug_level > 0 THEN
4713: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;

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

4709: oe_debug_pub.add( 'L_HSECS='||L_HSECS||' TOTAL2='||G_TOTAL2 ) ;
4710: END IF;
4711: l_total := (l_hsecs - g_total2)/100;
4712: IF l_debug_level > 0 THEN
4713: oe_debug_pub.add( 'G_TOTAL2='||L_TOTAL ) ;
4714: END IF;
4715: g_total2 := l_hsecs;
4716: END IF;
4717:

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

4770: l_instance_code varchar2(100);
4771:
4772: l_inv_ctp number;
4773:
4774: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4775:
4776: CURSOR c_temp_table(in_session_id in number) IS
4777: SELECT source_organization_id,
4778: sr_instance_id,

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

4788:
4789: BEGIN
4790:
4791: IF l_debug_level > 0 THEN
4792: oe_debug_pub.add( 'ENTERING GA IN_ORG_ID='||IN_ORG_ID|| ' IN_CUSTOMER_ID='||IN_CUSTOMER_ID
4793: || ' IN_SITE_ID ='||IN_CUSTOMER_SITE_ID|| ' IN_ITEM_ID ='||IN_INVENTORY_ITEM_ID ) ;
4794: END IF;
4795:
4796: OPEN c_instance_id;

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

4803: x_return_status := 'S';
4804: l_mrp_atp_database_link := fnd_profile.value('MRP_ATP_DATABASE_LINK');
4805:
4806: IF l_debug_level > 0 THEN
4807: oe_debug_pub.add( 'L_INSTANCE_ID='||L_INSTANCE_ID|| ' DB LINK='
4808: ||L_MRP_ATP_DATABASE_LINK ||' Ins Code='||l_instance_code) ;
4809: END IF;
4810:
4811: msc_sch_wb.get_assignment_set(

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

4820: ,x_err_mesg =>x_err_mesg
4821: );
4822:
4823: IF l_debug_level > 0 THEN
4824: oe_debug_pub.add( 'ASSIGNMENT_SET_ID='||X_ASSIGNMENT_SET_ID|| ' SET NAME='||
4825: X_ASSIGNMENT_SET_NAME|| ' PLAN ID='||X_PLAN_ID|| ' PLAN NAME='
4826: ||X_PLAN_NAME|| ' RET CODE='||X_RETURN_STATUS|| ' ERR MESG='||X_ERR_MESG ) ;
4827: END IF;
4828:

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

4830: and x_assignment_set_id is null then
4831:
4832: x_msg_data := x_err_mesg;
4833: IF l_debug_level > 0 THEN
4834: oe_debug_pub.add( 'RETURNING IN GA 1' ) ;
4835: END IF;
4836:
4837: IF x_msg_data is not null then
4838:

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

4836:
4837: IF x_msg_data is not null then
4838:
4839: IF l_debug_level > 0 THEN
4840: oe_debug_pub.add( 'MSG DATA IS NOT NULL' ) ;
4841: END IF;
4842: x_return_status := 'E';
4843: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
4844: IF l_debug_level > 0 THEN

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

4841: END IF;
4842: x_return_status := 'E';
4843: FND_MESSAGE.SET_NAME('ONT','ONT_AVAIL_GENERIC');
4844: IF l_debug_level > 0 THEN
4845: oe_debug_pub.add( 'MSG DATA IS NOT NULL 2' ) ;
4846: END IF;
4847: FND_MESSAGE.SET_TOKEN('TEXT',x_msg_data);
4848: OE_MSG_PUB.Add;
4849:

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

4871:
4872:
4873: /*fnd_profile.get('INV_CTP',l_inv_ctp);
4874: IF l_debug_level > 0 THEN
4875: oe_debug_pub.add(' Inventory Capable to Promise='||l_inv_ctp);
4876: END IF;
4877:
4878: --Profile Inventory Capable to Prmise
4879: -- 4= PDS and we need to select a plan_id for org-org sourcing

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

4893: l_dynstring := '@'||l_mrp_atp_database_link;
4894: END IF;
4895:
4896: IF l_debug_level > 0 THEN
4897: oe_debug_pub.add('Getting Plan Id dynamic string='||l_dynstring);
4898: END IF;
4899:
4900: sql_stmt :=
4901: ' SELECT '||

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

4905: ' AND mast.sr_inventory_item_id = :in_inventory_item_id'||
4906: ' AND mast.organization_id = :in_org_id';
4907:
4908: IF l_debug_level > 0 THEN
4909: oe_debug_pub.add('Planning Sql='||sql_stmt);
4910: END IF;
4911:
4912:
4913: EXECUTE IMMEDIATE sql_stmt INTO x_plan_id

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

4917: IF x_plan_id is null then
4918: fnd_message.set_name('MSC', 'MSC_NO_PLANS_DEFINED');
4919: oe_msg_pub.add;
4920: x_return_status := 'E';
4921: oe_debug_pub.add('Plan Id NOT FOUND');
4922: END IF;
4923:
4924: END IF; -- if plan_id needs to be fetched */
4925:

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

4931: -- if the plan was fetched and found then continue
4932: IF nvl(x_return_status,'E') <> 'E' then
4933:
4934: IF l_debug_level > 0 THEN
4935: oe_debug_pub.add(' Before inserting into temp table '||
4936: ' instance_id='||l_instance_id||
4937: ' session_id='||l_session_id||
4938: ' inv_item_id='||in_inventory_item_id||
4939: ' customer_id='||l_customer_id||

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

4983:
4984: IF l_debug_level > 0 THEN
4985: print_time('After Calling Get Supply Sources');
4986:
4987: oe_debug_pub.add( ' After CALLing get_supply_sources_local '||
4988: ' status='||x_return_status||
4989: ' message='||x_err_mesg);
4990:
4991: END IF;

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

4991: END IF;
4992:
4993: IF nvl(x_return_status,'S') <> 'S' THEN
4994: IF l_debug_level > 0 THEN
4995: oe_debug_pub.add( ' ERROR IN CALL TO get_supply_sources_local');
4996: END IF;
4997: fnd_message.set_name('MSC', x_err_mesg);
4998: oe_msg_pub.add;
4999:

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

5003: x_return_status := 'S';
5004: END IF;
5005:
5006: IF l_debug_level > 0 THEN
5007: oe_debug_pub.add( ' SUCCESS IN CALL TO get_supply_sources_local');
5008: END IF;
5009:
5010: -- Read from mrp_atp_schedule_Temp
5011: -- Insert into l_sources_orgs_table org_id and instance_id

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

5013:
5014: FOR l_temp_rec in c_temp_table(l_session_id)
5015: LOOP
5016: IF l_debug_level > 0 THEN
5017: oe_debug_pub.add( ' Reading data from temp table');
5018: END IF;
5019: l_source_orgs_table(l_count).org_id:=l_temp_rec.source_organization_id;
5020: l_source_orgs_table(l_count).instance_id:=l_temp_rec.sr_instance_id;
5021: l_source_orgs_table(l_count).ship_method:=l_temp_rec.ship_method;

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

5026:
5027: END LOOP;
5028:
5029: IF l_debug_level > 0 THEN
5030: oe_debug_pub.add( ' After Reading data from temp table');
5031: END IF;
5032:
5033: IF l_source_orgs_table.COUNT > 0 then
5034: FOR i in l_source_orgs_table.FIRST..l_source_orgs_table.LAST

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

5033: IF l_source_orgs_table.COUNT > 0 then
5034: FOR i in l_source_orgs_table.FIRST..l_source_orgs_table.LAST
5035: LOOP
5036: IF l_debug_level > 0 THEN
5037: oe_debug_pub.add(' Record = '||i||
5038: ' org_id ='||l_source_orgs_table(i).org_id||
5039: ' instance_id ='||l_source_orgs_table(i).instance_id||
5040: ' ship_method ='||l_source_orgs_table(i).ship_method||
5041: ' del_lead_time ='||l_source_orgs_table(i).delivery_lead_time||

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

5047: END LOOP;
5048: ELSE
5049:
5050: IF l_debug_level > 0 THEN
5051: oe_debug_pub.add( ' THERE ARE NO SOURCES TO BE DISPLAYED ' ) ;
5052: END IF;
5053: x_return_status := 'E';
5054: x_error_mesg := 'MRP_ATP_NO_SOURCES';
5055: FND_MESSAGE.SET_NAME('MSC','MRP_ATP_NO_SOURCES');

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

5071:
5072: -- if it was a failure then we retrieve the message
5073: IF nvl(x_return_status,'E') <> 'S' then
5074: IF l_debug_level > 0 THEN
5075: oe_debug_pub.add( 'DOING COUNT_AND_GET' ) ;
5076: END IF;
5077: oe_msg_pub.count_and_get(p_encoded=>fnd_api.G_TRUE,
5078: p_count => x_msg_count,
5079: p_data=>x_msg_data

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

5078: p_count => x_msg_count,
5079: p_data=>x_msg_data
5080: );
5081: IF l_debug_level > 0 THEN
5082: oe_debug_pub.add( 'COUNT = '||X_MSG_COUNT||' MSG='||X_MSG_DATA ) ;
5083: END IF;
5084: END IF;
5085:
5086: IF l_debug_level > 0 THEN

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

5083: END IF;
5084: END IF;
5085:
5086: IF l_debug_level > 0 THEN
5087: oe_debug_pub.add( 'EXITING GA' ) ;
5088: END IF;
5089:
5090: EXCEPTION
5091: WHEN OTHERS THEN

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

5090: EXCEPTION
5091: WHEN OTHERS THEN
5092:
5093: IF l_debug_level > 0 THEN
5094: oe_debug_pub.add( 'WHEN OTHERS OF get_global_availability' ) ;
5095: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
5096: END IF;
5097:
5098: x_return_status := 'E';

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

5091: WHEN OTHERS THEN
5092:
5093: IF l_debug_level > 0 THEN
5094: oe_debug_pub.add( 'WHEN OTHERS OF get_global_availability' ) ;
5095: oe_debug_pub.add( 'CODE='||SQLCODE||' MSG='||SQLERRM ) ;
5096: END IF;
5097:
5098: x_return_status := 'E';
5099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

5148: l_ordered_conversion number;
5149: l_pricing_conversion number;
5150:
5151: --
5152: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5153: --
5154: BEGIN
5155:
5156: IF l_debug_level > 0 THEN

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

5153: --
5154: BEGIN
5155:
5156: IF l_debug_level > 0 THEN
5157: oe_debug_pub.add( 'ENTERING OE_AVAILABILITY.DIFFERENT_UOM'||
5158: ' ORDERED_UOM ='||IN_ORDERED_UOM|| ' PRICING_UOM='||
5159: IN_PRICING_UOM|| ' IN_INV_ITEM_ID='||
5160: G_panda_rec_table(1).p_INVENTORY_ITEM_ID|| ' IN_ORG_ID='||IN_ORG_ID ) ;
5161: END IF;

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

5182: IF in_ordered_uom <> l_base_uom AND
5183: in_pricing_uom <> l_base_uom THEN
5184:
5185: IF l_debug_level > 0 THEN
5186: oe_debug_pub.add( 'NEITHER THE ORDERED OR PRICING UOM IS BASE UOM' ) ;
5187: END IF;
5188:
5189: l_ordered_conversion := get_conversion_rate(
5190: in_uom_code => in_ordered_uom,

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

5190: in_uom_code => in_ordered_uom,
5191: in_base_uom => l_base_uom
5192: );
5193: IF l_debug_level > 0 THEN
5194: oe_debug_pub.add( 'THE ORD RATE ='||L_ORDERED_CONVERSION ) ;
5195: END IF;
5196: l_pricing_conversion := get_conversion_rate(
5197: in_uom_code => in_pricing_uom,
5198: in_base_uom => l_base_uom

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

5197: in_uom_code => in_pricing_uom,
5198: in_base_uom => l_base_uom
5199: );
5200: IF l_debug_level > 0 THEN
5201: oe_debug_pub.add( 'THE PRICING RATE ='||L_PRICING_CONVERSION ) ;
5202: END IF;
5203:
5204: out_conversion_rate := l_ordered_conversion/l_pricing_conversion;
5205: IF l_debug_level > 0 THEN

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

5202: END IF;
5203:
5204: out_conversion_rate := l_ordered_conversion/l_pricing_conversion;
5205: IF l_debug_level > 0 THEN
5206: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
5207: END IF;
5208:
5209: -- Ordered Uom is the Base Uom,sending the pricing uom for conversion
5210: ELSIF in_ordered_uom = l_base_uom then

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

5209: -- Ordered Uom is the Base Uom,sending the pricing uom for conversion
5210: ELSIF in_ordered_uom = l_base_uom then
5211:
5212: IF l_debug_level > 0 THEN
5213: oe_debug_pub.add( 'THE ORDERED UOM IS BASE UOM' ) ;
5214: END IF;
5215:
5216: l_ordered_conversion := get_conversion_rate(
5217: in_uom_code => in_pricing_uom,

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

5218: in_base_uom => l_base_uom
5219: );
5220: out_conversion_rate := l_ordered_conversion;
5221: IF l_debug_level > 0 THEN
5222: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
5223: END IF;
5224:
5225: -- Pricing Uom is the Base Uom
5226: ELSIF in_pricing_uom = l_base_uom then

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

5225: -- Pricing Uom is the Base Uom
5226: ELSIF in_pricing_uom = l_base_uom then
5227:
5228: IF l_debug_level > 0 THEN
5229: oe_debug_pub.add( 'THE PRICING UOM IS BASE UOM' ) ;
5230: END IF;
5231: l_pricing_conversion := get_conversion_rate(
5232: in_uom_code => in_ordered_uom,
5233: in_base_uom => l_base_uom

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

5233: in_base_uom => l_base_uom
5234: );
5235: out_conversion_rate := l_pricing_conversion;
5236: IF l_debug_level > 0 THEN
5237: oe_debug_pub.add( 'THE RATE ='||OUT_CONVERSION_RATE ) ;
5238: END IF;
5239:
5240: END IF;
5241:

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

5253: EXCEPTION
5254:
5255: WHEN NO_DATA_FOUND THEN
5256: IF l_debug_level > 0 THEN
5257: oe_debug_pub.add( 'NO DATA FONUNG DIFFERENT_UOM ' ) ;
5258: END IF;
5259:
5260: WHEN OTHERS THEN
5261: IF c_items%ISOPEN then

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

5267: IF c_base_uom%ISOPEN then
5268: CLOSE c_base_uom;
5269: END IF;
5270: IF l_debug_level > 0 THEN
5271: oe_debug_pub.add( 'ERROR IN DIFFERENT_UOM '|| SQLCODE||SQLERRM ) ;
5272: END IF;
5273:
5274: END different_uom;
5275:

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

5302: l_conversion_rate number;
5303: l_uom_code varchar2(50);
5304:
5305: --
5306: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5307: --
5308: BEGIN
5309:
5310: IF l_debug_level > 0 THEN

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

5307: --
5308: BEGIN
5309:
5310: IF l_debug_level > 0 THEN
5311: oe_debug_pub.add( 'INSIDE GET_CONVERSION_RATE '|| ' IN_UOM_CODE='||IN_UOM_CODE|| ' IN_BASE_UOM='||IN_BASE_UOM ) ;
5312: END IF;
5313:
5314: OPEN c_item_conversion;
5315: FETCH c_item_conversion

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

5317:
5318: IF c_item_conversion%NOTFOUND THEN
5319:
5320: IF l_debug_level > 0 THEN
5321: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE NOT FOUND' ) ;
5322: END IF;
5323:
5324: OPEN c_conversion;
5325: FETCH c_conversion

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

5327:
5328: IF c_conversion%NOTFOUND THEN
5329:
5330: IF l_debug_level > 0 THEN
5331: oe_debug_pub.add( 'GENERIC CONVERSION NOT FOUND' ) ;
5332: END IF;
5333: OPEN c_inter_class;
5334: FETCH c_inter_class
5335: INTO l_conversion_rate;

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

5335: INTO l_conversion_rate;
5336:
5337: IF c_inter_class%NOTFOUND THEN
5338: IF l_debug_level > 0 THEN
5339: oe_debug_pub.add( 'INTER CLASS RETURN RATE NOT FOUND= 1' ) ;
5340: END IF;
5341: l_conversion_rate := 1;
5342:
5343: ELSE

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

5341: l_conversion_rate := 1;
5342:
5343: ELSE
5344: IF l_debug_level > 0 THEN
5345: oe_debug_pub.add( 'INTER CLASS RETURN RATE = '||L_CONVERSION_RATE ) ;
5346: END IF;
5347:
5348: END IF;
5349: CLOSE c_inter_class;

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

5350:
5351: ELSIF c_conversion%FOUND then
5352:
5353: IF l_debug_level > 0 THEN
5354: oe_debug_pub.add( 'RETURN RATE GENERIC= '||L_CONVERSION_RATE ) ;
5355: END IF;
5356:
5357: END IF;
5358: CLOSE c_conversion;

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

5359:
5360: ELSIF c_item_conversion%FOUND THEN
5361:
5362: IF l_debug_level > 0 THEN
5363: oe_debug_pub.add( 'ITEM SPECIFIC CONVERSION RATE='||L_CONVERSION_RATE ) ;
5364: END IF;
5365:
5366: END IF;
5367: CLOSE c_item_conversion;

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

5371: EXCEPTION
5372:
5373: WHEN ZERO_DIVIDE THEN
5374: IF l_debug_level > 0 THEN
5375: oe_debug_pub.add( 'DIVIDE BY ZERO ERROR IN_UOM_CODE='||IN_UOM_CODE|| ' BASE UOM='||IN_BASE_UOM ) ;
5376: END IF;
5377:
5378: IF c_item_conversion%ISOPEN then
5379: CLOSE c_item_conversion;

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

5396: IF c_inter_class%ISOPEN then
5397: CLOSE c_inter_class;
5398: END IF;
5399: IF l_debug_level > 0 THEN
5400: oe_debug_pub.add( 'ERROR IN GET_CONVERSION_RATE '|| SQLCODE||SQLERRM ) ;
5401: END IF;
5402: return 1;
5403: END get_conversion_rate;
5404:

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

5425: l_msg_count number;
5426: l_msg_data varchar2(4000);
5427:
5428: --
5429: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5430: --
5431: BEGIN
5432:
5433:

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

5453: ,x_error_message =>out_error_message
5454: );
5455:
5456: IF l_debug_level > 0 THEN
5457: 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 ) ;
5458: END IF;
5459:
5460:
5461: IF l_debug_level > 0 THEN

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

5458: END IF;
5459:
5460:
5461: IF l_debug_level > 0 THEN
5462: oe_debug_pub.add( 'CALL_MRP_AND_INVENTORY'|| ' OUT_AVAILABLE_DATE ='||OUT_AVAILABLE_DATE|| ' OUT_AVAILABLE_QTY ='||OUT_AVAILABLE_QTY);
5463: oe_debug_pub.add( ' OUT_ON_HAND_QTY ='||OUT_ON_HAND_QTY|| ' OUT_RESERVABLE_QTY ='||OUT_RESERVABLE_QTY|| ' OUT_ERROR_MESSAGE ='||OUT_ERROR_MESSAGE ) ;
5464: END IF;
5465:
5466: EXCEPTION

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

5459:
5460:
5461: IF l_debug_level > 0 THEN
5462: oe_debug_pub.add( 'CALL_MRP_AND_INVENTORY'|| ' OUT_AVAILABLE_DATE ='||OUT_AVAILABLE_DATE|| ' OUT_AVAILABLE_QTY ='||OUT_AVAILABLE_QTY);
5463: oe_debug_pub.add( ' OUT_ON_HAND_QTY ='||OUT_ON_HAND_QTY|| ' OUT_RESERVABLE_QTY ='||OUT_RESERVABLE_QTY|| ' OUT_ERROR_MESSAGE ='||OUT_ERROR_MESSAGE ) ;
5464: END IF;
5465:
5466: EXCEPTION
5467: WHEN OTHERS THEN

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

5465:
5466: EXCEPTION
5467: WHEN OTHERS THEN
5468: IF l_debug_level > 0 THEN
5469: oe_debug_pub.add( 'INSIDE CALL_MRP_AND_INVENTORY '|| SQLERRM||SQLERRM ) ;
5470: END IF;
5471:
5472: END call_mrp_and_inventory;
5473:

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

5479: l_session_id number;
5480: l_mrp_dir varchar2(200);
5481:
5482: --
5483: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5484: --
5485: BEGIN
5486:
5487: SELECT mrp_atp_schedule_temp_s.nextval

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

5496: order_sch_wb.mr_debug := 'Y';
5497: order_sch_wb.debug_session_id := l_session_id;
5498:
5499: IF l_debug_level > 0 THEN
5500: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR='||L_MRP_DIR|| ' SESSION ID ='||L_SESSION_ID ) ;
5501: END IF;
5502: l_mrp_dir := substr(l_mrp_dir,1,18);
5503: IF l_debug_level > 0 THEN
5504: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR2='||L_MRP_DIR ) ;

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

5500: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR='||L_MRP_DIR|| ' SESSION ID ='||L_SESSION_ID ) ;
5501: END IF;
5502: l_mrp_dir := substr(l_mrp_dir,1,18);
5503: IF l_debug_level > 0 THEN
5504: oe_debug_pub.add( 'MSC_ATP_DEBUG DIR2='||L_MRP_DIR ) ;
5505: END IF;
5506: out_mrp_file := l_mrp_dir||'/session-'||l_session_id;
5507:
5508: EXCEPTION

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

5507:
5508: EXCEPTION
5509: WHEN NO_DATA_FOUND THEN
5510: IF l_debug_level > 0 THEN
5511: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
5512: END IF;
5513: WHEN OTHERS THEN
5514: IF l_debug_level > 0 THEN
5515: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;

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

5511: oe_debug_pub.add( 'OE_OE_AVAILABILITY.SET_MRP_DEBUG NO_DATA_FOUND' ) ;
5512: END IF;
5513: WHEN OTHERS THEN
5514: IF l_debug_level > 0 THEN
5515: oe_debug_pub.add( 'WHEN OTHERS OE_OE_AVAILABILITY.SET_MRP_DEBUG '|| SQLCODE||SQLERRM ) ;
5516: END IF;
5517:
5518: END set_mrp_debug;
5519:

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

5638: in_conversion_rate IN NUMBER DEFAULT NULL --added for bug 12541442
5639: ) IS
5640:
5641: --
5642: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5643: --
5644: l_index number :=1;
5645: BEGIN
5646: