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.

[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on OE_DELAYED_REQUESTS_PVT

Line 87: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>

83:
84: --validate item uniqueness
85: -- This is called just to make sure that a delayed request is logged..else validate_entity was being called again
86: -- from process_object
87: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
88: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
89: p_Entity_Id => p_line_rec.line_id,
90: p_requesting_entity_code =>
91: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 393: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN

389:
390: if l_debug_level > 0 then
391: oe_debug_pub.add('Blanket In create price list');
392: end if;
393: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN
394: RETURN;
395: END IF;
396:
397: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;

Line 398: gpr_price_list_rec.name := oe_delayed_requests_pvt.g_delayed_requests(I).param1;

394: RETURN;
395: END IF;
396:
397: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;
398: gpr_price_list_rec.name := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
399: gpr_price_list_rec.list_type_code := 'PRL';
400: gpr_price_list_rec.list_source_code := 'BLKT';
401: -- gpr_price_list_rec.description := oe_delayed_requests_pvt.g_delayed_requests(I).paramtext1;
402: gpr_price_list_rec.currency_code := oe_delayed_requests_pvt.g_delayed_requests(I).param2;

Line 401: -- gpr_price_list_rec.description := oe_delayed_requests_pvt.g_delayed_requests(I).paramtext1;

397: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;
398: gpr_price_list_rec.name := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
399: gpr_price_list_rec.list_type_code := 'PRL';
400: gpr_price_list_rec.list_source_code := 'BLKT';
401: -- gpr_price_list_rec.description := oe_delayed_requests_pvt.g_delayed_requests(I).paramtext1;
402: gpr_price_list_rec.currency_code := oe_delayed_requests_pvt.g_delayed_requests(I).param2;
403: --11i10 Pricing Changes Start
404: if oe_code_control.get_code_release_level >= '110510' then
405: gpr_price_list_rec.list_source_code := 'BSO';

Line 402: gpr_price_list_rec.currency_code := oe_delayed_requests_pvt.g_delayed_requests(I).param2;

398: gpr_price_list_rec.name := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
399: gpr_price_list_rec.list_type_code := 'PRL';
400: gpr_price_list_rec.list_source_code := 'BLKT';
401: -- gpr_price_list_rec.description := oe_delayed_requests_pvt.g_delayed_requests(I).paramtext1;
402: gpr_price_list_rec.currency_code := oe_delayed_requests_pvt.g_delayed_requests(I).param2;
403: --11i10 Pricing Changes Start
404: if oe_code_control.get_code_release_level >= '110510' then
405: gpr_price_list_rec.list_source_code := 'BSO';
406: gpr_price_list_rec.orig_system_header_ref :=

Line 407: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

403: --11i10 Pricing Changes Start
404: if oe_code_control.get_code_release_level >= '110510' then
405: gpr_price_list_rec.list_source_code := 'BSO';
406: gpr_price_list_rec.orig_system_header_ref :=
407: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
408: gpr_price_list_rec.shareable_flag := 'N';
409: gpr_price_list_rec.sold_to_org_id :=
410: oe_delayed_requests_pvt.g_delayed_requests(I).param7;
411: -- Add blanket header qualifier

Line 410: oe_delayed_requests_pvt.g_delayed_requests(I).param7;

406: gpr_price_list_rec.orig_system_header_ref :=
407: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
408: gpr_price_list_rec.shareable_flag := 'N';
409: gpr_price_list_rec.sold_to_org_id :=
410: oe_delayed_requests_pvt.g_delayed_requests(I).param7;
411: -- Add blanket header qualifier
412: l_qualifiers_tbl(1).excluder_flag := 'N';
413: l_qualifiers_tbl(1).comparison_operator_code := '=';
414: l_qualifiers_tbl(1).qualifier_context := 'ORDER';

Line 437: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

433:
434: l_qualifiers_tbl(1).qualifier_attribute := 'QUALIFIER_ATTRIBUTE5';
435: -- Blanket Header ID is the qualifier attribute value
436: l_qualifiers_tbl(1).qualifier_attr_value :=
437: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
438: l_qualifiers_tbl(1).qualifier_grouping_no := 1;
439: l_qualifiers_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
440: end if;
441: --11i10 Pricing Changes End

Line 447: lheader_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

443: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
444: --MOAC changes to force the PL tobe created in a ORG
445: gpr_price_list_rec.org_id := mo_global.get_current_org_id;
446: gpr_price_list_rec.global_flag := 'N';
447: lheader_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
448:
449: I := oe_delayed_requests_pvt.g_delayed_requests.first;
450:
451: WHILE I IS NOT NULL

Line 449: I := oe_delayed_requests_pvt.g_delayed_requests.first;

445: gpr_price_list_rec.org_id := mo_global.get_current_org_id;
446: gpr_price_list_rec.global_flag := 'N';
447: lheader_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
448:
449: I := oe_delayed_requests_pvt.g_delayed_requests.first;
450:
451: WHILE I IS NOT NULL
452: LOOP
453: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'

Line 453: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'

449: I := oe_delayed_requests_pvt.g_delayed_requests.first;
450:
451: WHILE I IS NOT NULL
452: LOOP
453: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'
454: AND
455: oe_delayed_requests_pvt.g_delayed_requests(I).entity_code =
456: oe_blanket_pub.g_entity_blanket_LINE THEN
457: if l_debug_level > 0 then

Line 455: oe_delayed_requests_pvt.g_delayed_requests(I).entity_code =

451: WHILE I IS NOT NULL
452: LOOP
453: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'
454: AND
455: oe_delayed_requests_pvt.g_delayed_requests(I).entity_code =
456: oe_blanket_pub.g_entity_blanket_LINE THEN
457: if l_debug_level > 0 then
458: oe_debug_pub.add('Blanket In create price list - line');
459: end if;

Line 460: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN

456: oe_blanket_pub.g_entity_blanket_LINE THEN
457: if l_debug_level > 0 then
458: oe_debug_pub.add('Blanket In create price list - line');
459: end if;
460: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN
461: if l_debug_level > 0 then
462: oe_debug_pub.add('Blanket In Skip');
463: end if;
464: GOTO SKIP_LINE;

Line 466: g_line_id_tbl(ind).line_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

462: oe_debug_pub.add('Blanket In Skip');
463: end if;
464: GOTO SKIP_LINE;
465: END IF;
466: g_line_id_tbl(ind).line_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
467:
468: select QP_LIST_LINES_S.NEXTVAL into l_list_line_seq from dual; --bug8344368
469: gpr_price_list_line_tbl(ind).list_line_id := l_list_line_seq;
470: gpr_price_list_line_tbl(ind).list_line_type_code := 'PLL';

Line 472: gpr_price_list_line_tbl(ind).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;

468: select QP_LIST_LINES_S.NEXTVAL into l_list_line_seq from dual; --bug8344368
469: gpr_price_list_line_tbl(ind).list_line_id := l_list_line_seq;
470: gpr_price_list_line_tbl(ind).list_line_type_code := 'PLL';
471: gpr_price_list_line_tbl(ind).operation := QP_GLOBALS.G_OPR_CREATE;
472: gpr_price_list_line_tbl(ind).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
473: gpr_price_list_line_tbl(ind).arithmetic_operator := 'UNIT_PRICE';
474:
475: -- Bug 3209215, Issue 9.1
476: -- Pass precedence value on price list lines

Line 484: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN

480: gpr_pricing_attr_tbl(K).list_line_id := FND_API.G_MISS_NUM;
481: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
482:
483:
484: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
485:
486: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
487: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
488:

Line 487: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;

483:
484: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
485:
486: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
487: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
488:
489: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN
490:
491: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE3';

Line 489: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN

485:
486: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
487: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
488:
489: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN
490:
491: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE3';
492: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := 'ALL';
493:

Line 497: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;

493:
494: ELSE
495:
496: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE1';
497: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
498:
499: -- 11i10 Pricing Change
500: -- Send customer item on price list line record
501: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'

Line 501: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'

497: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
498:
499: -- 11i10 Pricing Change
500: -- Send customer item on price list line record
501: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'
502: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
503: THEN
504: gpr_price_list_line_tbl(ind).customer_item_id :=
505: oe_delayed_requests_pvt.g_delayed_requests(I).param8;

Line 505: oe_delayed_requests_pvt.g_delayed_requests(I).param8;

501: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'
502: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
503: THEN
504: gpr_price_list_line_tbl(ind).customer_item_id :=
505: oe_delayed_requests_pvt.g_delayed_requests(I).param8;
506: oe_debug_pub.add('sending cust item id :'||
507: gpr_price_list_line_tbl(ind).customer_item_id);
508: END IF;
509:

Line 514: gpr_pricing_attr_tbl(K).PRODUCT_UOM_CODE := oe_delayed_requests_pvt.g_delayed_requests(I).param2;

510: END IF;
511:
512:
513:
514: gpr_pricing_attr_tbl(K).PRODUCT_UOM_CODE := oe_delayed_requests_pvt.g_delayed_requests(I).param2;
515: gpr_pricing_attr_tbl(K).EXCLUDER_FLAG := 'N';
516: gpr_pricing_attr_tbl(K).ATTRIBUTE_GROUPING_NO := 1;
517: gpr_pricing_attr_tbl(K).list_line_id := l_list_line_seq;
518: gpr_pricing_attr_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;

Line 536: oe_delayed_requests_pvt.g_delayed_requests.delete(I);

532: k:= k+1;
533: ind := ind+1;
534:
535: << SKIP_LINE >>
536: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
537: END IF;
538: I := oe_delayed_requests_pvt.g_delayed_requests.next(I);
539:
540: END LOOP;

Line 538: I := oe_delayed_requests_pvt.g_delayed_requests.next(I);

534:
535: << SKIP_LINE >>
536: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
537: END IF;
538: I := oe_delayed_requests_pvt.g_delayed_requests.next(I);
539:
540: END LOOP;
541:
542: /*

Line 555: gpr_qualifiers_tbl(K).qualifier_attr_value := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

551: gpr_qualifiers_tbl(K).qualifier_context := 'ORDER';
552: gpr_qualifiers_tbl(K).qualifier_attribute := 'QUALIFIER_ATTRIBUTE6';
553: gpr_qualifiers_tbl(K).comparison_operator_code := '=';
554: -- Blanket Line ID is the qualifier attribute value
555: gpr_qualifiers_tbl(K).qualifier_attr_value := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
556: oe_debug_pub.add('entity id :'||oe_delayed_requests_pvt.g_delayed_requests(I).entity_id);
557: gpr_qualifiers_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
558: END IF;
559: */

Line 556: oe_debug_pub.add('entity id :'||oe_delayed_requests_pvt.g_delayed_requests(I).entity_id);

552: gpr_qualifiers_tbl(K).qualifier_attribute := 'QUALIFIER_ATTRIBUTE6';
553: gpr_qualifiers_tbl(K).comparison_operator_code := '=';
554: -- Blanket Line ID is the qualifier attribute value
555: gpr_qualifiers_tbl(K).qualifier_attr_value := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
556: oe_debug_pub.add('entity id :'||oe_delayed_requests_pvt.g_delayed_requests(I).entity_id);
557: gpr_qualifiers_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
558: END IF;
559: */
560:

Line 756: /*IF oe_delayed_requests_pvt.g_delayed_requests(I).param3 IS NULL THEN

752: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
753: --
754: BEGIN
755: --begin commented the below if statement for bug 4762658
756: /*IF oe_delayed_requests_pvt.g_delayed_requests(I).param3 IS NULL THEN
757: RETURN;
758: END IF;*/
759: --end for bug 4762658
760: --for bug 3229225

Line 761: IF (oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL OR oe_delayed_requests_pvt.g_delayed_requests(I).param1=FND_API.G_MISS_NUM)

757: RETURN;
758: END IF;*/
759: --end for bug 4762658
760: --for bug 3229225
761: IF (oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL OR oe_delayed_requests_pvt.g_delayed_requests(I).param1=FND_API.G_MISS_NUM)
762: THEN
763: IF l_debug_level > 0
764: THEN
765: oe_debug_pub.add('Skip for null values');

Line 767: oe_delayed_requests_pvt.g_delayed_requests.delete(I);

763: IF l_debug_level > 0
764: THEN
765: oe_debug_pub.add('Skip for null values');
766: END IF;
767: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
768: GOTO SKIP_LINE1;
769: END IF;
770:
771: select QP_LIST_LINES_S.NEXTVAL into l_list_line_seq from dual; --bug8344368

Line 775: gpr_price_list_line_tbl(k).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;

771: select QP_LIST_LINES_S.NEXTVAL into l_list_line_seq from dual; --bug8344368
772: gpr_price_list_line_tbl(k).list_line_id := l_list_line_seq;
773: gpr_price_list_line_tbl(k).list_line_type_code := 'PLL';
774: gpr_price_list_line_tbl(k).operation := QP_GLOBALS.G_OPR_CREATE;
775: gpr_price_list_line_tbl(k).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
776: gpr_price_list_line_tbl(k).arithmetic_operator := 'UNIT_PRICE';
777: gpr_price_list_line_tbl(k).list_header_id :=
778: oe_delayed_requests_pvt.g_delayed_requests(I).param5 ;
779: -- Bug 3209215, Issue 9.1

Line 778: oe_delayed_requests_pvt.g_delayed_requests(I).param5 ;

774: gpr_price_list_line_tbl(k).operation := QP_GLOBALS.G_OPR_CREATE;
775: gpr_price_list_line_tbl(k).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
776: gpr_price_list_line_tbl(k).arithmetic_operator := 'UNIT_PRICE';
777: gpr_price_list_line_tbl(k).list_header_id :=
778: oe_delayed_requests_pvt.g_delayed_requests(I).param5 ;
779: -- Bug 3209215, Issue 9.1
780: -- Pass precedence value on price list lines
781: gpr_price_list_line_tbl(k).product_precedence := 1;
782:

Line 786: oe_delayed_requests_pvt.g_delayed_requests(I).param5;

782:
783: gpr_pricing_attr_tbl(K).pricing_attribute_id := FND_API.G_MISS_NUM;
784: gpr_pricing_attr_tbl(K).list_line_id := FND_API.G_MISS_NUM;
785: gpr_pricing_attr_tbl(K).list_header_id :=
786: oe_delayed_requests_pvt.g_delayed_requests(I).param5;
787: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
788:
789: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
790:

Line 789: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN

785: gpr_pricing_attr_tbl(K).list_header_id :=
786: oe_delayed_requests_pvt.g_delayed_requests(I).param5;
787: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
788:
789: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
790:
791: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
792: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
793:

Line 792: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;

788:
789: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
790:
791: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
792: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
793:
794: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN
795:
796: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE3';

Line 794: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN

790:
791: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
792: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
793:
794: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN
795:
796: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE3';
797: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := 'ALL';
798:

Line 802: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;

798:
799: ELSE
800:
801: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE1';
802: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
803:
804: -- 11i10 Pricing Change
805: -- Send customer item on price list line record
806: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'

Line 806: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'

802: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
803:
804: -- 11i10 Pricing Change
805: -- Send customer item on price list line record
806: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'
807: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
808: THEN
809: gpr_price_list_line_tbl(k).customer_item_id :=
810: oe_delayed_requests_pvt.g_delayed_requests(I).param8;

Line 810: oe_delayed_requests_pvt.g_delayed_requests(I).param8;

806: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'
807: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
808: THEN
809: gpr_price_list_line_tbl(k).customer_item_id :=
810: oe_delayed_requests_pvt.g_delayed_requests(I).param8;
811: oe_debug_pub.add('sending cust item id :'||
812: gpr_price_list_line_tbl(k).customer_item_id);
813: END IF;
814:

Line 817: gpr_pricing_attr_tbl(K).PRODUCT_UOM_CODE := oe_delayed_requests_pvt.g_delayed_requests(I).param2;

813: END IF;
814:
815: END IF;
816:
817: gpr_pricing_attr_tbl(K).PRODUCT_UOM_CODE := oe_delayed_requests_pvt.g_delayed_requests(I).param2;
818: gpr_pricing_attr_tbl(K).EXCLUDER_FLAG := 'N';
819: gpr_pricing_attr_tbl(K).ATTRIBUTE_GROUPING_NO := 1;
820: gpr_pricing_attr_tbl(K).list_line_id := l_list_line_seq;
821: gpr_pricing_attr_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;

Line 835: --oe_delayed_requests_pvt.g_delayed_requests.delete(I);

831: gpr_pricing_attr_tbl(K).pricing_attr_value_from := l_list_line_seq;--bug8344368
832: gpr_pricing_attr_tbl(K).comparison_operator_code := '=';
833:
834:
835: --oe_delayed_requests_pvt.g_delayed_requests.delete(I);
836:
837: QP_PRICE_LIST_GRP.Process_Price_List
838: ( p_api_version_number => 1
839: , p_init_msg_list => FND_API.G_FALSE

Line 920: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;

916: price_list_id = ppr_price_list_line_tbl(1).list_header_id,
917: lock_control = lock_control + 1
918: WHERE
919: line_id =
920: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;
921:
922: Update oe_blanket_lines_ext
923: set qp_list_line_id = ppr_price_list_line_tbl(1).list_line_id
924: WHERE

Line 926: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;

922: Update oe_blanket_lines_ext
923: set qp_list_line_id = ppr_price_list_line_tbl(1).list_line_id
924: WHERE
925: line_id =
926: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;
927:
928: << SKIP_LINE1 >>
929: g_new_price_list := false;
930: EXCEPTION

Line 979: gpr_price_list_line_tbl(K).list_line_id := oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param1 ;

975: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
976: --
977: BEGIN
978: x_return_status:= FND_API.G_RET_STS_SUCCESS;
979: gpr_price_list_line_tbl(K).list_line_id := oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param1 ;
980: gpr_price_list_line_tbl(K).operation := QP_GLOBALS.G_OPR_UPDATE;
981: gpr_price_list_line_tbl(K).list_header_id :=
982: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
983: gpr_price_list_line_tbl(K).end_date_active :=sysdate;

Line 982: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;

978: x_return_status:= FND_API.G_RET_STS_SUCCESS;
979: gpr_price_list_line_tbl(K).list_line_id := oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param1 ;
980: gpr_price_list_line_tbl(K).operation := QP_GLOBALS.G_OPR_UPDATE;
981: gpr_price_list_line_tbl(K).list_header_id :=
982: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
983: gpr_price_list_line_tbl(K).end_date_active :=sysdate;
984:
985: IF((NOT IS_BLANKET_PRICE_LIST(p_price_list_id => oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param3
986: ,p_blanket_header_id =>oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param4 ))

Line 985: IF((NOT IS_BLANKET_PRICE_LIST(p_price_list_id => oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param3

981: gpr_price_list_line_tbl(K).list_header_id :=
982: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
983: gpr_price_list_line_tbl(K).end_date_active :=sysdate;
984:
985: IF((NOT IS_BLANKET_PRICE_LIST(p_price_list_id => oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param3
986: ,p_blanket_header_id =>oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param4 ))
987: AND (gpr_price_list_line_tbl(K).list_line_id is not null))
988: THEN
989: QP_PRICE_LIST_GRP.Process_Price_List

Line 986: ,p_blanket_header_id =>oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param4 ))

982: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
983: gpr_price_list_line_tbl(K).end_date_active :=sysdate;
984:
985: IF((NOT IS_BLANKET_PRICE_LIST(p_price_list_id => oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param3
986: ,p_blanket_header_id =>oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param4 ))
987: AND (gpr_price_list_line_tbl(K).list_line_id is not null))
988: THEN
989: QP_PRICE_LIST_GRP.Process_Price_List
990: ( p_api_version_number => 1

Line 1019: WHERE line_id = oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id ;

1015: END IF;
1016:
1017: Update oe_blanket_lines_ext
1018: set qp_list_line_id = Null
1019: WHERE line_id = oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id ;
1020: END IF;
1021:
1022:
1023: EXCEPTION

Line 2542: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

2538: fnd_message.set_token('ATTRIBUTE',
2539: OE_Order_UTIL.Get_Attribute_Name('LINE_NUMBER'));
2540: OE_MSG_PUB.Add;
2541: ELSE
2542: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2543: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2544: p_Entity_Id => p_line_rec.line_id,
2545: p_requesting_entity_code =>
2546: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 2623: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>

2619: oe_debug_pub.add('before logging request for item uniqueness');
2620: end if;
2621:
2622: --validate item uniqueness
2623: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2624: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2625: p_Entity_Id => p_line_rec.line_id,
2626: p_requesting_entity_code =>
2627: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 2916: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>

2912: END IF;
2913:
2914: /* IF NOT OE_GLOBALS.EQUAL (p_line_rec.end_date_active, l_old_line_rec.end_date_active) THEN
2915: --validate item uniqueness
2916: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2917: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2918: p_Entity_Id => p_line_rec.line_id,
2919: p_requesting_entity_code =>
2920: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 3108: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

3104: --for bug 3229225.Commented out NOCOPY /* file.sql.39 change */ the If condition and added modified condition
3105: -- IF p_line_rec.unit_list_price IS NOT NULL
3106: IF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price)
3107: THEN
3108: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3109: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3110: p_Entity_Id => p_line_rec.line_id,
3111: p_requesting_entity_code =>
3112: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 3186: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

3182: if l_debug_level > 0 then
3183: oe_debug_pub.add('log ADD_BLANKET_PRICE_LIST_LINE');
3184: end if;
3185:
3186: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3187: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3188: p_Entity_Id => p_line_rec.line_id,
3189: p_requesting_entity_code =>
3190: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 3235: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

3231: oe_debug_pub.add('qp list line id :'||p_line_rec.qp_list_line_id);
3232: oe_debug_pub.add('Log delayed request: CLEAR_BLANKET_PRICE_LIST_LINE');
3233: end if;
3234:
3235: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3236: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3237: p_Entity_Id => p_line_rec.line_id,
3238: p_requesting_entity_code =>
3239: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 3280: oe_delayed_requests_pvt.Log_request

3276: oe_msg_pub.add;
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: ELSE
3279: -- Log delayed request to create new modifier list line
3280: oe_delayed_requests_pvt.Log_request
3281: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3282: p_Entity_Id => p_line_rec.line_id,
3283: p_requesting_entity_code =>
3284: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 4107: OE_Delayed_Requests_PVT.Log_Request

4103: x_return_status := l_return_status;
4104: END IF;
4105:
4106: IF NOT OE_GLOBALS.Equal(x_return_status, FND_API.G_RET_STS_ERROR) THEN
4107: OE_Delayed_Requests_PVT.Log_Request
4108: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4109: ,p_Entity_Id => p_header_rec.header_id
4110: ,p_requesting_entity_code =>
4111: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

Line 4137: OE_Delayed_Requests_PVT.Log_Request

4133: THEN
4134: if (NOT OE_GLOBALS.Equal(p_header_rec.start_date_active,l_old_header_rec.start_date_active) OR
4135: NOT OE_GLOBALS.Equal(p_header_rec.end_date_active,l_old_header_rec.end_date_active))
4136: THEN
4137: OE_Delayed_Requests_PVT.Log_Request
4138: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4139: ,p_Entity_Id => p_header_rec.header_id
4140: ,p_requesting_entity_code =>
4141: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

Line 4159: OE_Delayed_Requests_PVT.Log_Request

4155: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
4156: THEN
4157: if (NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,l_old_header_rec.sold_to_org_id) and
4158: p_header_rec.operation = oe_globals.g_opr_update) THEN
4159: OE_Delayed_Requests_PVT.Log_Request
4160: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
4161: ,p_Entity_Id => p_header_rec.header_id
4162: ,p_param1 => p_header_rec.sold_to_org_id
4163: ,p_requesting_entity_code =>

Line 4183: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

4179: l_new_pl_name := p_header_rec.new_price_list_name;
4180: else
4181: l_new_pl_name := p_header_rec.price_list_name;
4182: end if;
4183: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
4184: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
4185: p_Entity_Id => p_header_rec.header_id,
4186: p_requesting_entity_code =>
4187: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,

Line 4209: oe_delayed_requests_pvt.Log_request

4205:
4206: -- 11i10 Pricing Changes
4207: -- Log request to create new modifier
4208: IF g_new_modifier_list THEN
4209: oe_delayed_requests_pvt.Log_request
4210: (p_entity_code => oe_blanket_pub.g_entity_blanket_header,
4211: p_Entity_Id => p_header_rec.header_id,
4212: p_requesting_entity_code =>
4213: oe_blanket_pub.g_entity_blanket_header,

Line 7326: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

7322: x_return_status := FND_API.G_RET_STS_SUCCESS;
7323:
7324: -- Process Header requests
7325:
7326: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
7327: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER
7328: ,p_delete => FND_API.G_TRUE
7329: ,x_return_status => l_return_status
7330: );

Line 7339: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

7335: END IF;
7336:
7337: -- Process Line Level Request
7338:
7339: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
7340: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE
7341: ,p_delete => FND_API.G_TRUE
7342: ,x_return_status => l_return_status
7343: );

Line 7464: --OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643

7460: EXCEPTION
7461:
7462: WHEN FND_API.G_EXC_ERROR THEN
7463: --Commented for Bug 15879874
7464: --OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643
7465: x_return_status := FND_API.G_RET_STS_ERROR;
7466:
7467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7468: --Commented for Bug 15879874

Line 7469: --OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643

7465: x_return_status := FND_API.G_RET_STS_ERROR;
7466:
7467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7468: --Commented for Bug 15879874
7469: --OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643
7470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7471:
7472: WHEN OTHERS THEN
7473: --Commented for Bug 15879874

Line 7474: --OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643

7470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7471:
7472: WHEN OTHERS THEN
7473: --Commented for Bug 15879874
7474: --OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643
7475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7476:
7477: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7478: THEN

Line 7499: IF oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2 < 1 THEN

7495: --
7496: BEGIN
7497: x_return_status := FND_API.G_RET_STS_SUCCESS;
7498:
7499: IF oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2 < 1 THEN
7500: l_valid := 'N';
7501: ELSE
7502: BEGIN
7503: SELECT 'N'

Line 7507: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2

7503: SELECT 'N'
7504: INTO l_valid
7505: FROM oe_blanket_lines L
7506: WHERE L.line_number =
7507: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2
7508: AND L.header_id =
7509: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1
7510: AND L.line_id <>
7511: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;

Line 7509: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1

7505: FROM oe_blanket_lines L
7506: WHERE L.line_number =
7507: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2
7508: AND L.header_id =
7509: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1
7510: AND L.line_id <>
7511: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7512:
7513: EXCEPTION

Line 7511: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;

7507: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2
7508: AND L.header_id =
7509: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1
7510: AND L.line_id <>
7511: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7512:
7513: EXCEPTION
7514: WHEN no_data_found THEN
7515: l_valid := 'Y';

Line 7581: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;

7577:
7578: x_return_status := FND_API.G_RET_STS_SUCCESS;
7579:
7580: l_line_id :=
7581: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7582: l_item_id :=
7583: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;
7584: l_header_id :=
7585: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;

Line 7583: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;

7579:
7580: l_line_id :=
7581: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7582: l_item_id :=
7583: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;
7584: l_header_id :=
7585: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
7586: l_item_identifier_type :=
7587: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;

Line 7585: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;

7581: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7582: l_item_id :=
7583: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;
7584: l_header_id :=
7585: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
7586: l_item_identifier_type :=
7587: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;
7588:
7589: l_ordered_item_id :=

Line 7587: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;

7583: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;
7584: l_header_id :=
7585: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
7586: l_item_identifier_type :=
7587: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;
7588:
7589: l_ordered_item_id :=
7590: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param4;
7591:

Line 7590: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param4;

7586: l_item_identifier_type :=
7587: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;
7588:
7589: l_ordered_item_id :=
7590: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param4;
7591:
7592: l_ordered_item :=
7593: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param5;
7594:

Line 7593: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param5;

7589: l_ordered_item_id :=
7590: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param4;
7591:
7592: l_ordered_item :=
7593: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param5;
7594:
7595:
7596:
7597: l_start_date_active :=

Line 7598: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param1;

7594:
7595:
7596:
7597: l_start_date_active :=
7598: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param1;
7599: l_end_date_active :=
7600: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param2;
7601:
7602: if l_debug_level > 0 then

Line 7600: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param2;

7596:
7597: l_start_date_active :=
7598: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param1;
7599: l_end_date_active :=
7600: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param2;
7601:
7602: if l_debug_level > 0 then
7603: oe_debug_pub.add('In validate Item Uniqueness');
7604: oe_debug_pub.add('item identifier type :'|| l_item_identifier_type);