APPS.QP_PRICE_BOOK_UTIL dependencies on FND_MESSAGE

Line 515: FND_MESSAGE.SET_NAME('FND', 'MO_ORG_REQUIRED');

511: IF nvl(p_pb_input_header_rec.publish_existing_pb_flag, 'N') <> 'Y' THEN
512: --Check if org_id is not null and valid. Else return, do not proceed.
513: IF p_pb_input_header_rec.org_id IS NULL THEN
514: x_return_status := 'E';
515: FND_MESSAGE.SET_NAME('FND', 'MO_ORG_REQUIRED');
516: l_message_text := FND_MESSAGE.GET;
517: l_price_book_messages_tbl(i).message_code := 'MO_ORG_REQUIRED';
518: l_price_book_messages_tbl(i).message_text := l_message_text;
519: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 516: l_message_text := FND_MESSAGE.GET;

512: --Check if org_id is not null and valid. Else return, do not proceed.
513: IF p_pb_input_header_rec.org_id IS NULL THEN
514: x_return_status := 'E';
515: FND_MESSAGE.SET_NAME('FND', 'MO_ORG_REQUIRED');
516: l_message_text := FND_MESSAGE.GET;
517: l_price_book_messages_tbl(i).message_code := 'MO_ORG_REQUIRED';
518: l_price_book_messages_tbl(i).message_text := l_message_text;
519: l_price_book_messages_tbl(i).pb_input_header_id :=
520: p_pb_input_header_rec.pb_input_header_id;

Line 529: FND_MESSAGE.SET_NAME('FND', 'MO_ORG_INVALID');

525: RETURN;
526: ELSE
527: IF MO_GLOBAL.check_access(p_pb_input_header_rec.org_id) <> 'Y' THEN
528: x_return_status := 'E';
529: FND_MESSAGE.SET_NAME('FND', 'MO_ORG_INVALID');
530: l_message_text := FND_MESSAGE.GET;
531: l_price_book_messages_tbl(i).message_code := 'MO_ORG_INVALID';
532: l_price_book_messages_tbl(i).message_text := l_message_text;
533: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 530: l_message_text := FND_MESSAGE.GET;

526: ELSE
527: IF MO_GLOBAL.check_access(p_pb_input_header_rec.org_id) <> 'Y' THEN
528: x_return_status := 'E';
529: FND_MESSAGE.SET_NAME('FND', 'MO_ORG_INVALID');
530: l_message_text := FND_MESSAGE.GET;
531: l_price_book_messages_tbl(i).message_code := 'MO_ORG_INVALID';
532: l_price_book_messages_tbl(i).message_text := l_message_text;
533: l_price_book_messages_tbl(i).pb_input_header_id :=
534: p_pb_input_header_rec.pb_input_header_id;

Line 547: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

543:
544:
545: IF p_pb_input_header_rec.pricing_perspective_code IS NULL THEN
546: x_return_status := 'E';
547: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICING_PERSPECTIVE_CODE');
549: l_message_text := FND_MESSAGE.GET;
550: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
551: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICING_PERSPECTIVE_CODE');

544:
545: IF p_pb_input_header_rec.pricing_perspective_code IS NULL THEN
546: x_return_status := 'E';
547: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICING_PERSPECTIVE_CODE');
549: l_message_text := FND_MESSAGE.GET;
550: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
551: l_price_book_messages_tbl(i).message_text := l_message_text;
552: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 549: l_message_text := FND_MESSAGE.GET;

545: IF p_pb_input_header_rec.pricing_perspective_code IS NULL THEN
546: x_return_status := 'E';
547: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
548: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICING_PERSPECTIVE_CODE');
549: l_message_text := FND_MESSAGE.GET;
550: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
551: l_price_book_messages_tbl(i).message_text := l_message_text;
552: l_price_book_messages_tbl(i).pb_input_header_id :=
553: p_pb_input_header_rec.pb_input_header_id;

Line 570: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICING_PERSPECTIVE');

566: p_pb_input_header_rec.pricing_perspective_code;
567: EXCEPTION
568: WHEN OTHERS THEN
569: x_return_status := 'E';
570: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICING_PERSPECTIVE');
571: FND_MESSAGE.SET_TOKEN('CODE',
572: p_pb_input_header_rec.pricing_perspective_code);
573: l_message_text := FND_MESSAGE.GET;
574: l_price_book_messages_tbl(i).message_code

Line 571: FND_MESSAGE.SET_TOKEN('CODE',

567: EXCEPTION
568: WHEN OTHERS THEN
569: x_return_status := 'E';
570: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICING_PERSPECTIVE');
571: FND_MESSAGE.SET_TOKEN('CODE',
572: p_pb_input_header_rec.pricing_perspective_code);
573: l_message_text := FND_MESSAGE.GET;
574: l_price_book_messages_tbl(i).message_code
575: := 'QP_INVALID_PRICING_PERSPECTIVE';

Line 573: l_message_text := FND_MESSAGE.GET;

569: x_return_status := 'E';
570: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICING_PERSPECTIVE');
571: FND_MESSAGE.SET_TOKEN('CODE',
572: p_pb_input_header_rec.pricing_perspective_code);
573: l_message_text := FND_MESSAGE.GET;
574: l_price_book_messages_tbl(i).message_code
575: := 'QP_INVALID_PRICING_PERSPECTIVE';
576: l_price_book_messages_tbl(i).message_text := l_message_text;
577: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 589: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICING_PERSPECTIVE');

585: END;
586:
587: IF p_pb_input_header_rec.pricing_perspective_code = 'QP' THEN
588: x_return_status := 'E';
589: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICING_PERSPECTIVE');
590: FND_MESSAGE.SET_TOKEN('CODE',
591: p_pb_input_header_rec.pricing_perspective_code);
592: l_message_text := FND_MESSAGE.GET;
593: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_PRICING_PERSPECTIVE';

Line 590: FND_MESSAGE.SET_TOKEN('CODE',

586:
587: IF p_pb_input_header_rec.pricing_perspective_code = 'QP' THEN
588: x_return_status := 'E';
589: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICING_PERSPECTIVE');
590: FND_MESSAGE.SET_TOKEN('CODE',
591: p_pb_input_header_rec.pricing_perspective_code);
592: l_message_text := FND_MESSAGE.GET;
593: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_PRICING_PERSPECTIVE';
594: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 592: l_message_text := FND_MESSAGE.GET;

588: x_return_status := 'E';
589: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICING_PERSPECTIVE');
590: FND_MESSAGE.SET_TOKEN('CODE',
591: p_pb_input_header_rec.pricing_perspective_code);
592: l_message_text := FND_MESSAGE.GET;
593: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_PRICING_PERSPECTIVE';
594: l_price_book_messages_tbl(i).message_text := l_message_text;
595: l_price_book_messages_tbl(i).pb_input_header_id :=
596: p_pb_input_header_rec.pb_input_header_id;

Line 616: FND_MESSAGE.SET_NAME('QP', 'QP_REQUEST_TYPE_NOT_FOUND');

612: fnd_profile.value('QP_PRICING_PERSPECTIVE_REQUEST_TYPE');
613:
614: IF l_request_type_code IS NULL THEN
615: x_return_status := 'E';
616: FND_MESSAGE.SET_NAME('QP', 'QP_REQUEST_TYPE_NOT_FOUND');
617: FND_MESSAGE.SET_TOKEN('APPLICATION',
618: p_pb_input_header_rec.pricing_perspective_code);
619: l_message_text := FND_MESSAGE.GET;
620: l_price_book_messages_tbl(i).message_code := 'QP_REQUEST_TYPE_NOT_FOUND';

Line 617: FND_MESSAGE.SET_TOKEN('APPLICATION',

613:
614: IF l_request_type_code IS NULL THEN
615: x_return_status := 'E';
616: FND_MESSAGE.SET_NAME('QP', 'QP_REQUEST_TYPE_NOT_FOUND');
617: FND_MESSAGE.SET_TOKEN('APPLICATION',
618: p_pb_input_header_rec.pricing_perspective_code);
619: l_message_text := FND_MESSAGE.GET;
620: l_price_book_messages_tbl(i).message_code := 'QP_REQUEST_TYPE_NOT_FOUND';
621: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 619: l_message_text := FND_MESSAGE.GET;

615: x_return_status := 'E';
616: FND_MESSAGE.SET_NAME('QP', 'QP_REQUEST_TYPE_NOT_FOUND');
617: FND_MESSAGE.SET_TOKEN('APPLICATION',
618: p_pb_input_header_rec.pricing_perspective_code);
619: l_message_text := FND_MESSAGE.GET;
620: l_price_book_messages_tbl(i).message_code := 'QP_REQUEST_TYPE_NOT_FOUND';
621: l_price_book_messages_tbl(i).message_text := l_message_text;
622: l_price_book_messages_tbl(i).pb_input_header_id :=
623: p_pb_input_header_rec.pb_input_header_id;

Line 651: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

647:
648: --Check if Customer Context is valid
649: IF p_pb_input_header_rec.customer_context IS NULL THEN
650: x_return_status := 'E';
651: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_CONTEXT');
653: l_message_text := FND_MESSAGE.GET;
654: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
655: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_CONTEXT');

648: --Check if Customer Context is valid
649: IF p_pb_input_header_rec.customer_context IS NULL THEN
650: x_return_status := 'E';
651: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_CONTEXT');
653: l_message_text := FND_MESSAGE.GET;
654: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
655: l_price_book_messages_tbl(i).message_text := l_message_text;
656: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 653: l_message_text := FND_MESSAGE.GET;

649: IF p_pb_input_header_rec.customer_context IS NULL THEN
650: x_return_status := 'E';
651: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_CONTEXT');
653: l_message_text := FND_MESSAGE.GET;
654: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
655: l_price_book_messages_tbl(i).message_text := l_message_text;
656: l_price_book_messages_tbl(i).pb_input_header_id :=
657: p_pb_input_header_rec.pb_input_header_id;

Line 662: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER_CONTEXT');

658: i := i + 1;
659: x_return_text := x_return_text || substr(l_message_text, 1, 240);
660: ELSIF p_pb_input_header_rec.customer_context <> 'CUSTOMER' THEN
661: x_return_status := 'E';
662: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER_CONTEXT');
663: l_message_text := FND_MESSAGE.GET;
664: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_CUSTOMER_CONTEXT';
665: l_price_book_messages_tbl(i).message_text := l_message_text;
666: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 663: l_message_text := FND_MESSAGE.GET;

659: x_return_text := x_return_text || substr(l_message_text, 1, 240);
660: ELSIF p_pb_input_header_rec.customer_context <> 'CUSTOMER' THEN
661: x_return_status := 'E';
662: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER_CONTEXT');
663: l_message_text := FND_MESSAGE.GET;
664: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_CUSTOMER_CONTEXT';
665: l_price_book_messages_tbl(i).message_text := l_message_text;
666: l_price_book_messages_tbl(i).pb_input_header_id :=
667: p_pb_input_header_rec.pb_input_header_id;

Line 676: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

672:
673: --Check if Customer Attribute is valid
674: IF p_pb_input_header_rec.customer_attribute IS NULL THEN
675: x_return_status := 'E';
676: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTRIBUTE');
678: l_message_text := FND_MESSAGE.GET;
679: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
680: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTRIBUTE');

673: --Check if Customer Attribute is valid
674: IF p_pb_input_header_rec.customer_attribute IS NULL THEN
675: x_return_status := 'E';
676: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTRIBUTE');
678: l_message_text := FND_MESSAGE.GET;
679: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
680: l_price_book_messages_tbl(i).message_text := l_message_text;
681: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 678: l_message_text := FND_MESSAGE.GET;

674: IF p_pb_input_header_rec.customer_attribute IS NULL THEN
675: x_return_status := 'E';
676: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTRIBUTE');
678: l_message_text := FND_MESSAGE.GET;
679: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
680: l_price_book_messages_tbl(i).message_text := l_message_text;
681: l_price_book_messages_tbl(i).pb_input_header_id :=
682: p_pb_input_header_rec.pb_input_header_id;

Line 689: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER_ATTRIBUTE');

685: ELSIF p_pb_input_header_rec.customer_attribute <> 'QUALIFIER_ATTRIBUTE2'
686: THEN
687: x_return_status := 'E';
688: --Must be only Customer Name
689: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER_ATTRIBUTE');
690: l_message_text := FND_MESSAGE.GET;
691: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_CUSTOMER_ATTRIBUTE';
692: l_price_book_messages_tbl(i).message_text := l_message_text;
693: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 690: l_message_text := FND_MESSAGE.GET;

686: THEN
687: x_return_status := 'E';
688: --Must be only Customer Name
689: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER_ATTRIBUTE');
690: l_message_text := FND_MESSAGE.GET;
691: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_CUSTOMER_ATTRIBUTE';
692: l_price_book_messages_tbl(i).message_text := l_message_text;
693: l_price_book_messages_tbl(i).pb_input_header_id :=
694: p_pb_input_header_rec.pb_input_header_id;

Line 752: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

748:
749: --Input customer must match the customer associated with the user
750: IF p_pb_input_header_rec.customer_attr_value IS NULL THEN
751: x_return_status := 'E';
752: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTR_VALUE');
754: l_message_text := FND_MESSAGE.GET;
755: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
756: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTR_VALUE');

749: --Input customer must match the customer associated with the user
750: IF p_pb_input_header_rec.customer_attr_value IS NULL THEN
751: x_return_status := 'E';
752: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTR_VALUE');
754: l_message_text := FND_MESSAGE.GET;
755: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
756: l_price_book_messages_tbl(i).message_text := l_message_text;
757: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 754: l_message_text := FND_MESSAGE.GET;

750: IF p_pb_input_header_rec.customer_attr_value IS NULL THEN
751: x_return_status := 'E';
752: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
753: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTR_VALUE');
754: l_message_text := FND_MESSAGE.GET;
755: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
756: l_price_book_messages_tbl(i).message_text := l_message_text;
757: l_price_book_messages_tbl(i).pb_input_header_id :=
758: p_pb_input_header_rec.pb_input_header_id;

Line 769: FND_MESSAGE.SET_NAME('QP', 'QP_CUSTOMER_NOT_MATCHING');

765: ELSIF (p_pb_input_header_rec.customer_attr_value <> l_customer_id AND
766: l_party_id_match <> 'Y')
767: THEN
768: x_return_status := 'E';
769: FND_MESSAGE.SET_NAME('QP', 'QP_CUSTOMER_NOT_MATCHING');
770: l_message_text := FND_MESSAGE.GET;
771: l_price_book_messages_tbl(i).message_code := 'QP_CUSTOMER_NOT_MATCHING';
772: l_price_book_messages_tbl(i).message_text := l_message_text;
773: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 770: l_message_text := FND_MESSAGE.GET;

766: l_party_id_match <> 'Y')
767: THEN
768: x_return_status := 'E';
769: FND_MESSAGE.SET_NAME('QP', 'QP_CUSTOMER_NOT_MATCHING');
770: l_message_text := FND_MESSAGE.GET;
771: l_price_book_messages_tbl(i).message_code := 'QP_CUSTOMER_NOT_MATCHING';
772: l_price_book_messages_tbl(i).message_text := l_message_text;
773: l_price_book_messages_tbl(i).pb_input_header_id :=
774: p_pb_input_header_rec.pb_input_header_id;

Line 781: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

777: END IF;
778:
779: IF p_pb_input_header_rec.pricing_perspective_code = 'PO' THEN
780: x_return_status := 'E';
781: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICING_PERSPECTIVE_CODE');
783: l_message_text := FND_MESSAGE.GET;
784: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
785: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICING_PERSPECTIVE_CODE');

778:
779: IF p_pb_input_header_rec.pricing_perspective_code = 'PO' THEN
780: x_return_status := 'E';
781: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICING_PERSPECTIVE_CODE');
783: l_message_text := FND_MESSAGE.GET;
784: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
785: l_price_book_messages_tbl(i).message_text := l_message_text;
786: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 783: l_message_text := FND_MESSAGE.GET;

779: IF p_pb_input_header_rec.pricing_perspective_code = 'PO' THEN
780: x_return_status := 'E';
781: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICING_PERSPECTIVE_CODE');
783: l_message_text := FND_MESSAGE.GET;
784: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
785: l_price_book_messages_tbl(i).message_text := l_message_text;
786: l_price_book_messages_tbl(i).pb_input_header_id :=
787: p_pb_input_header_rec.pb_input_header_id;

Line 797: FND_MESSAGE.SET_NAME('QP', 'QP_GET_CAT_NOT_FOR_INT_USER');

793:
794: --Get Catalog not supported for Internal User
795: IF p_pb_input_header_rec.request_origination_code = 'XML' THEN
796: x_return_status := 'E';
797: FND_MESSAGE.SET_NAME('QP', 'QP_GET_CAT_NOT_FOR_INT_USER');
798: l_message_text := FND_MESSAGE.GET;
799: l_price_book_messages_tbl(i).message_code := 'QP_GET_CAT_NOT_FOR_INT_USER';
800: l_price_book_messages_tbl(i).message_text := l_message_text;
801: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 798: l_message_text := FND_MESSAGE.GET;

794: --Get Catalog not supported for Internal User
795: IF p_pb_input_header_rec.request_origination_code = 'XML' THEN
796: x_return_status := 'E';
797: FND_MESSAGE.SET_NAME('QP', 'QP_GET_CAT_NOT_FOR_INT_USER');
798: l_message_text := FND_MESSAGE.GET;
799: l_price_book_messages_tbl(i).message_code := 'QP_GET_CAT_NOT_FOR_INT_USER';
800: l_price_book_messages_tbl(i).message_text := l_message_text;
801: l_price_book_messages_tbl(i).pb_input_header_id :=
802: p_pb_input_header_rec.pb_input_header_id;

Line 809: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

805: END IF;
806:
807: IF p_pb_input_header_rec.customer_attr_value IS NULL THEN
808: x_return_status := 'E';
809: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTR_VALUE');
811: l_message_text := FND_MESSAGE.GET;
812: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
813: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTR_VALUE');

806:
807: IF p_pb_input_header_rec.customer_attr_value IS NULL THEN
808: x_return_status := 'E';
809: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTR_VALUE');
811: l_message_text := FND_MESSAGE.GET;
812: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
813: l_price_book_messages_tbl(i).message_text := l_message_text;
814: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 811: l_message_text := FND_MESSAGE.GET;

807: IF p_pb_input_header_rec.customer_attr_value IS NULL THEN
808: x_return_status := 'E';
809: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
810: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CUSTOMER_ATTR_VALUE');
811: l_message_text := FND_MESSAGE.GET;
812: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
813: l_price_book_messages_tbl(i).message_text := l_message_text;
814: l_price_book_messages_tbl(i).pb_input_header_id :=
815: p_pb_input_header_rec.pb_input_header_id;

Line 825: FND_MESSAGE.SET_NAME('QP', 'QP_PO_CUSTOMER');

821: --If pricing perspective is PO then cust_attr_value must be -1
822: IF p_pb_input_header_rec.pricing_perspective_code = 'PO' THEN
823: IF p_pb_input_header_rec.customer_attr_value <> -1 THEN
824: x_return_status := 'E';
825: FND_MESSAGE.SET_NAME('QP', 'QP_PO_CUSTOMER');
826: l_message_text := FND_MESSAGE.GET;
827: l_price_book_messages_tbl(i).message_code := 'QP_PO_CUSTOMER';
828: l_price_book_messages_tbl(i).message_text := l_message_text;
829: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 826: l_message_text := FND_MESSAGE.GET;

822: IF p_pb_input_header_rec.pricing_perspective_code = 'PO' THEN
823: IF p_pb_input_header_rec.customer_attr_value <> -1 THEN
824: x_return_status := 'E';
825: FND_MESSAGE.SET_NAME('QP', 'QP_PO_CUSTOMER');
826: l_message_text := FND_MESSAGE.GET;
827: l_price_book_messages_tbl(i).message_code := 'QP_PO_CUSTOMER';
828: l_price_book_messages_tbl(i).message_text := l_message_text;
829: l_price_book_messages_tbl(i).pb_input_header_id :=
830: p_pb_input_header_rec.pb_input_header_id;

Line 851: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER');

847: END;
848:
849: IF l_count = 0 THEN -- invalid customer
850: x_return_status := 'E';
851: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER');
852: l_message_text := FND_MESSAGE.GET;
853: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_CUSTOMER';
854: l_price_book_messages_tbl(i).message_text := l_message_text;
855: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 852: l_message_text := FND_MESSAGE.GET;

848:
849: IF l_count = 0 THEN -- invalid customer
850: x_return_status := 'E';
851: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_CUSTOMER');
852: l_message_text := FND_MESSAGE.GET;
853: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_CUSTOMER';
854: l_price_book_messages_tbl(i).message_text := l_message_text;
855: l_price_book_messages_tbl(i).pb_input_header_id :=
856: p_pb_input_header_rec.pb_input_header_id;

Line 871: FND_MESSAGE.SET_NAME('QP', 'QP_PO_CUST_ACCT');

867: IF p_pb_input_header_rec.pricing_perspective_code = 'PO' THEN
868: --If pricing perspective is PO then cust_account_id must be null
869: IF p_pb_input_header_rec.cust_account_id IS NOT NULL THEN
870: x_return_status := 'E';
871: FND_MESSAGE.SET_NAME('QP', 'QP_PO_CUST_ACCT');
872: l_message_text := FND_MESSAGE.GET;
873: l_price_book_messages_tbl(i).message_code := 'QP_PO_CUST_ACCT';
874: l_price_book_messages_tbl(i).message_text := l_message_text;
875: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 872: l_message_text := FND_MESSAGE.GET;

868: --If pricing perspective is PO then cust_account_id must be null
869: IF p_pb_input_header_rec.cust_account_id IS NOT NULL THEN
870: x_return_status := 'E';
871: FND_MESSAGE.SET_NAME('QP', 'QP_PO_CUST_ACCT');
872: l_message_text := FND_MESSAGE.GET;
873: l_price_book_messages_tbl(i).message_code := 'QP_PO_CUST_ACCT';
874: l_price_book_messages_tbl(i).message_text := l_message_text;
875: l_price_book_messages_tbl(i).pb_input_header_id :=
876: p_pb_input_header_rec.pb_input_header_id;

Line 899: FND_MESSAGE.SET_NAME('QP', 'QP_CUST_AND_ACCT_COMBI_INVALID');

895: END;
896:
897: IF l_count = 0 THEN
898: x_return_status := 'E';
899: FND_MESSAGE.SET_NAME('QP', 'QP_CUST_AND_ACCT_COMBI_INVALID');
900: l_message_text := FND_MESSAGE.GET;
901: l_price_book_messages_tbl(i).message_code :=
902: 'QP_CUST_AND_ACCT_COMBI_INVALID';
903: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 900: l_message_text := FND_MESSAGE.GET;

896:
897: IF l_count = 0 THEN
898: x_return_status := 'E';
899: FND_MESSAGE.SET_NAME('QP', 'QP_CUST_AND_ACCT_COMBI_INVALID');
900: l_message_text := FND_MESSAGE.GET;
901: l_price_book_messages_tbl(i).message_code :=
902: 'QP_CUST_AND_ACCT_COMBI_INVALID';
903: l_price_book_messages_tbl(i).message_text := l_message_text;
904: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 919: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

915:
916: --Check if price_book_type_code is valid
917: IF p_pb_input_header_rec.price_book_type_code IS NULL THEN
918: x_return_status := 'E';
919: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
921: l_message_text := FND_MESSAGE.GET;
922: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
923: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');

916: --Check if price_book_type_code is valid
917: IF p_pb_input_header_rec.price_book_type_code IS NULL THEN
918: x_return_status := 'E';
919: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
921: l_message_text := FND_MESSAGE.GET;
922: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
923: l_price_book_messages_tbl(i).message_text := l_message_text;
924: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 921: l_message_text := FND_MESSAGE.GET;

917: IF p_pb_input_header_rec.price_book_type_code IS NULL THEN
918: x_return_status := 'E';
919: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
920: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
921: l_message_text := FND_MESSAGE.GET;
922: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
923: l_price_book_messages_tbl(i).message_text := l_message_text;
924: l_price_book_messages_tbl(i).pb_input_header_id :=
925: p_pb_input_header_rec.pb_input_header_id;

Line 934: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

930: IF NOT (p_pb_input_header_rec.price_book_type_code = 'F' OR
931: p_pb_input_header_rec.price_book_type_code = 'D')
932: THEN -- invalid price_book_type_code
933: x_return_status := 'E';
934: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
936: l_message_text := FND_MESSAGE.GET;
937: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
938: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');

931: p_pb_input_header_rec.price_book_type_code = 'D')
932: THEN -- invalid price_book_type_code
933: x_return_status := 'E';
934: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
936: l_message_text := FND_MESSAGE.GET;
937: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
938: l_price_book_messages_tbl(i).message_text := l_message_text;
939: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 936: l_message_text := FND_MESSAGE.GET;

932: THEN -- invalid price_book_type_code
933: x_return_status := 'E';
934: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
936: l_message_text := FND_MESSAGE.GET;
937: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
938: l_price_book_messages_tbl(i).message_text := l_message_text;
939: l_price_book_messages_tbl(i).pb_input_header_id :=
940: p_pb_input_header_rec.pb_input_header_id;

Line 946: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

942: x_return_text := x_return_text || substr(l_message_text, 1, 240);
943: END IF;
944: ELSIF l_pricing_status = 'S' THEN --Basic Pricing
945: IF nvl(p_pb_input_header_rec.price_book_type_code, 'F') <> 'F' THEN
946: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
948: l_message_text := FND_MESSAGE.GET;
949: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
950: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');

943: END IF;
944: ELSIF l_pricing_status = 'S' THEN --Basic Pricing
945: IF nvl(p_pb_input_header_rec.price_book_type_code, 'F') <> 'F' THEN
946: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
948: l_message_text := FND_MESSAGE.GET;
949: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
950: l_price_book_messages_tbl(i).message_text := l_message_text;
951: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 948: l_message_text := FND_MESSAGE.GET;

944: ELSIF l_pricing_status = 'S' THEN --Basic Pricing
945: IF nvl(p_pb_input_header_rec.price_book_type_code, 'F') <> 'F' THEN
946: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_TYPE_CODE');
948: l_message_text := FND_MESSAGE.GET;
949: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
950: l_price_book_messages_tbl(i).message_text := l_message_text;
951: l_price_book_messages_tbl(i).pb_input_header_id :=
952: p_pb_input_header_rec.pb_input_header_id;

Line 963: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

959:
960: --Check if price book name is not-null
961: IF p_pb_input_header_rec.price_book_name IS NULL THEN
962: x_return_status := 'E';
963: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_NAME');
965: l_message_text := FND_MESSAGE.GET;
966: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
967: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_NAME');

960: --Check if price book name is not-null
961: IF p_pb_input_header_rec.price_book_name IS NULL THEN
962: x_return_status := 'E';
963: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_NAME');
965: l_message_text := FND_MESSAGE.GET;
966: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
967: l_price_book_messages_tbl(i).message_text := l_message_text;
968: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 965: l_message_text := FND_MESSAGE.GET;

961: IF p_pb_input_header_rec.price_book_name IS NULL THEN
962: x_return_status := 'E';
963: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
964: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BOOK_NAME');
965: l_message_text := FND_MESSAGE.GET;
966: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
967: l_price_book_messages_tbl(i).message_text := l_message_text;
968: l_price_book_messages_tbl(i).pb_input_header_id :=
969: p_pb_input_header_rec.pb_input_header_id;

Line 994: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');

990: l_count := 0;
991: END;
992:
993: IF l_count = 0 THEN --corresponding full price book does not exist
994: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');
995: x_return_status := 'E';
996: l_message_text := FND_MESSAGE.GET;
997: l_price_book_messages_tbl(i).message_code := 'QP_FULL_PRICE_BOOK_MUST_EXIST';
998: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 996: l_message_text := FND_MESSAGE.GET;

992:
993: IF l_count = 0 THEN --corresponding full price book does not exist
994: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');
995: x_return_status := 'E';
996: l_message_text := FND_MESSAGE.GET;
997: l_price_book_messages_tbl(i).message_code := 'QP_FULL_PRICE_BOOK_MUST_EXIST';
998: l_price_book_messages_tbl(i).message_text := l_message_text;
999: l_price_book_messages_tbl(i).pb_input_header_id :=
1000: p_pb_input_header_rec.pb_input_header_id;

Line 1013: FND_MESSAGE.SET_NAME('QP', 'QP_XML_NOT_FOR_BASIC');

1009: IF p_pb_input_header_rec.request_origination_code = 'XML' OR
1010: p_pb_input_header_rec.dlv_xml_flag = 'Y'
1011: THEN
1012: x_return_status := 'E';
1013: FND_MESSAGE.SET_NAME('QP', 'QP_XML_NOT_FOR_BASIC');
1014: l_message_text := FND_MESSAGE.GET;
1015: l_price_book_messages_tbl(i).message_code := 'QP_XML_NOT_FOR_BASIC';
1016: l_price_book_messages_tbl(i).message_text := l_message_text;
1017: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1014: l_message_text := FND_MESSAGE.GET;

1010: p_pb_input_header_rec.dlv_xml_flag = 'Y'
1011: THEN
1012: x_return_status := 'E';
1013: FND_MESSAGE.SET_NAME('QP', 'QP_XML_NOT_FOR_BASIC');
1014: l_message_text := FND_MESSAGE.GET;
1015: l_price_book_messages_tbl(i).message_code := 'QP_XML_NOT_FOR_BASIC';
1016: l_price_book_messages_tbl(i).message_text := l_message_text;
1017: l_price_book_messages_tbl(i).pb_input_header_id :=
1018: p_pb_input_header_rec.pb_input_header_id;

Line 1030: FND_MESSAGE.SET_NAME('QP', 'QP_XML_NOT_FOR_PO');

1026: IF p_pb_input_header_rec.request_origination_code = 'XML' OR
1027: p_pb_input_header_rec.dlv_xml_flag = 'Y'
1028: THEN
1029: x_return_status := 'E';
1030: FND_MESSAGE.SET_NAME('QP', 'QP_XML_NOT_FOR_PO');
1031: l_message_text := FND_MESSAGE.GET;
1032: l_price_book_messages_tbl(i).message_code := 'QP_XML_NOT_FOR_PO';
1033: l_price_book_messages_tbl(i).message_text := l_message_text;
1034: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1031: l_message_text := FND_MESSAGE.GET;

1027: p_pb_input_header_rec.dlv_xml_flag = 'Y'
1028: THEN
1029: x_return_status := 'E';
1030: FND_MESSAGE.SET_NAME('QP', 'QP_XML_NOT_FOR_PO');
1031: l_message_text := FND_MESSAGE.GET;
1032: l_price_book_messages_tbl(i).message_code := 'QP_XML_NOT_FOR_PO';
1033: l_price_book_messages_tbl(i).message_text := l_message_text;
1034: l_price_book_messages_tbl(i).pb_input_header_id :=
1035: p_pb_input_header_rec.pb_input_header_id;

Line 1042: FND_MESSAGE.SET_NAME('QP', 'QP_PO_XML_SITE');

1038: END IF;
1039:
1040: IF p_pb_input_header_rec.dlv_xml_site_id IS NOT NULL THEN
1041: x_return_status := 'E';
1042: FND_MESSAGE.SET_NAME('QP', 'QP_PO_XML_SITE');
1043: l_message_text := FND_MESSAGE.GET;
1044: l_price_book_messages_tbl(i).message_code := 'QP_PO_XML_SITE';
1045: l_price_book_messages_tbl(i).message_text := l_message_text;
1046: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1043: l_message_text := FND_MESSAGE.GET;

1039:
1040: IF p_pb_input_header_rec.dlv_xml_site_id IS NOT NULL THEN
1041: x_return_status := 'E';
1042: FND_MESSAGE.SET_NAME('QP', 'QP_PO_XML_SITE');
1043: l_message_text := FND_MESSAGE.GET;
1044: l_price_book_messages_tbl(i).message_code := 'QP_PO_XML_SITE';
1045: l_price_book_messages_tbl(i).message_text := l_message_text;
1046: l_price_book_messages_tbl(i).pb_input_header_id :=
1047: p_pb_input_header_rec.pb_input_header_id;

Line 1059: FND_MESSAGE.SET_NAME('QP', 'QP_ONLY_XML_DELIVERY_ALLOWED');

1055: IF nvl(p_pb_input_header_rec.dlv_printer_flag, 'N') = 'Y' OR
1056: nvl(p_pb_input_header_rec.dlv_email_flag, 'N') = 'Y'
1057: THEN
1058: x_return_status := 'E';
1059: FND_MESSAGE.SET_NAME('QP', 'QP_ONLY_XML_DELIVERY_ALLOWED');
1060: l_message_text := FND_MESSAGE.GET;
1061: l_price_book_messages_tbl(i).message_code := 'QP_ONLY_XML_DELIVERY_ALLOWED';
1062: l_price_book_messages_tbl(i).message_text := l_message_text;
1063: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1060: l_message_text := FND_MESSAGE.GET;

1056: nvl(p_pb_input_header_rec.dlv_email_flag, 'N') = 'Y'
1057: THEN
1058: x_return_status := 'E';
1059: FND_MESSAGE.SET_NAME('QP', 'QP_ONLY_XML_DELIVERY_ALLOWED');
1060: l_message_text := FND_MESSAGE.GET;
1061: l_price_book_messages_tbl(i).message_code := 'QP_ONLY_XML_DELIVERY_ALLOWED';
1062: l_price_book_messages_tbl(i).message_text := l_message_text;
1063: l_price_book_messages_tbl(i).pb_input_header_id :=
1064: p_pb_input_header_rec.pb_input_header_id;

Line 1076: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1072: IF p_pb_input_header_rec.publish_existing_pb_flag IS NOT NULL AND
1073: p_pb_input_header_rec.publish_existing_pb_flag NOT IN ('Y', 'N')
1074: THEN
1075: x_return_status := 'E';
1076: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1077: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUBLISH_EXISTING_PB_FLAG');
1078: l_message_text := FND_MESSAGE.GET;
1079: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1080: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1077: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUBLISH_EXISTING_PB_FLAG');

1073: p_pb_input_header_rec.publish_existing_pb_flag NOT IN ('Y', 'N')
1074: THEN
1075: x_return_status := 'E';
1076: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1077: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUBLISH_EXISTING_PB_FLAG');
1078: l_message_text := FND_MESSAGE.GET;
1079: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1080: l_price_book_messages_tbl(i).message_text := l_message_text;
1081: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1078: l_message_text := FND_MESSAGE.GET;

1074: THEN
1075: x_return_status := 'E';
1076: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1077: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUBLISH_EXISTING_PB_FLAG');
1078: l_message_text := FND_MESSAGE.GET;
1079: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1080: l_price_book_messages_tbl(i).message_text := l_message_text;
1081: l_price_book_messages_tbl(i).pb_input_header_id :=
1082: p_pb_input_header_rec.pb_input_header_id;

Line 1091: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1087: IF p_pb_input_header_rec.overwrite_existing_pb_flag IS NOT NULL AND
1088: p_pb_input_header_rec.overwrite_existing_pb_flag NOT IN ('Y', 'N')
1089: THEN
1090: x_return_status := 'E';
1091: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1092: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'OVERWRITE_EXISTING_PB_FLAG');
1093: l_message_text := FND_MESSAGE.GET;
1094: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1095: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1092: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'OVERWRITE_EXISTING_PB_FLAG');

1088: p_pb_input_header_rec.overwrite_existing_pb_flag NOT IN ('Y', 'N')
1089: THEN
1090: x_return_status := 'E';
1091: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1092: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'OVERWRITE_EXISTING_PB_FLAG');
1093: l_message_text := FND_MESSAGE.GET;
1094: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1095: l_price_book_messages_tbl(i).message_text := l_message_text;
1096: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1093: l_message_text := FND_MESSAGE.GET;

1089: THEN
1090: x_return_status := 'E';
1091: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1092: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'OVERWRITE_EXISTING_PB_FLAG');
1093: l_message_text := FND_MESSAGE.GET;
1094: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1095: l_price_book_messages_tbl(i).message_text := l_message_text;
1096: l_price_book_messages_tbl(i).pb_input_header_id :=
1097: p_pb_input_header_rec.pb_input_header_id;

Line 1106: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1102: IF p_pb_input_header_rec.dlv_email_flag IS NOT NULL AND
1103: p_pb_input_header_rec.dlv_email_flag NOT IN ('Y', 'N')
1104: THEN
1105: x_return_status := 'E';
1106: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_EMAIL_FLAG');
1108: l_message_text := FND_MESSAGE.GET;
1109: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1110: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_EMAIL_FLAG');

1103: p_pb_input_header_rec.dlv_email_flag NOT IN ('Y', 'N')
1104: THEN
1105: x_return_status := 'E';
1106: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_EMAIL_FLAG');
1108: l_message_text := FND_MESSAGE.GET;
1109: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1110: l_price_book_messages_tbl(i).message_text := l_message_text;
1111: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1108: l_message_text := FND_MESSAGE.GET;

1104: THEN
1105: x_return_status := 'E';
1106: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_EMAIL_FLAG');
1108: l_message_text := FND_MESSAGE.GET;
1109: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1110: l_price_book_messages_tbl(i).message_text := l_message_text;
1111: l_price_book_messages_tbl(i).pb_input_header_id :=
1112: p_pb_input_header_rec.pb_input_header_id;

Line 1121: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1117: IF p_pb_input_header_rec.dlv_printer_flag IS NOT NULL AND
1118: p_pb_input_header_rec.dlv_printer_flag NOT IN ('Y', 'N')
1119: THEN
1120: x_return_status := 'E';
1121: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_PRINTER_FLAG');
1123: l_message_text := FND_MESSAGE.GET;
1124: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1125: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_PRINTER_FLAG');

1118: p_pb_input_header_rec.dlv_printer_flag NOT IN ('Y', 'N')
1119: THEN
1120: x_return_status := 'E';
1121: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_PRINTER_FLAG');
1123: l_message_text := FND_MESSAGE.GET;
1124: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1125: l_price_book_messages_tbl(i).message_text := l_message_text;
1126: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1123: l_message_text := FND_MESSAGE.GET;

1119: THEN
1120: x_return_status := 'E';
1121: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1122: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_PRINTER_FLAG');
1123: l_message_text := FND_MESSAGE.GET;
1124: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1125: l_price_book_messages_tbl(i).message_text := l_message_text;
1126: l_price_book_messages_tbl(i).pb_input_header_id :=
1127: p_pb_input_header_rec.pb_input_header_id;

Line 1136: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1132: IF p_pb_input_header_rec.dlv_xml_flag IS NOT NULL AND
1133: p_pb_input_header_rec.dlv_xml_flag NOT IN ('Y', 'N')
1134: THEN
1135: x_return_status := 'E';
1136: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_FLAG');
1138: l_message_text := FND_MESSAGE.GET;
1139: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1140: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_FLAG');

1133: p_pb_input_header_rec.dlv_xml_flag NOT IN ('Y', 'N')
1134: THEN
1135: x_return_status := 'E';
1136: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_FLAG');
1138: l_message_text := FND_MESSAGE.GET;
1139: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1140: l_price_book_messages_tbl(i).message_text := l_message_text;
1141: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1138: l_message_text := FND_MESSAGE.GET;

1134: THEN
1135: x_return_status := 'E';
1136: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_FLAG');
1138: l_message_text := FND_MESSAGE.GET;
1139: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1140: l_price_book_messages_tbl(i).message_text := l_message_text;
1141: l_price_book_messages_tbl(i).pb_input_header_id :=
1142: p_pb_input_header_rec.pb_input_header_id;

Line 1153: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1149: --If delivery option is email then email_addresses must be specified.
1150: IF p_pb_input_header_rec.dlv_email_flag = 'Y' THEN
1151: IF p_pb_input_header_rec.dlv_email_addresses IS NULL THEN
1152: x_return_status := 'E';
1153: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_EMAIL_ADDRESSES');
1155: l_message_text := FND_MESSAGE.GET;
1156: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1157: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_EMAIL_ADDRESSES');

1150: IF p_pb_input_header_rec.dlv_email_flag = 'Y' THEN
1151: IF p_pb_input_header_rec.dlv_email_addresses IS NULL THEN
1152: x_return_status := 'E';
1153: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_EMAIL_ADDRESSES');
1155: l_message_text := FND_MESSAGE.GET;
1156: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1157: l_price_book_messages_tbl(i).message_text := l_message_text;
1158: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1155: l_message_text := FND_MESSAGE.GET;

1151: IF p_pb_input_header_rec.dlv_email_addresses IS NULL THEN
1152: x_return_status := 'E';
1153: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_EMAIL_ADDRESSES');
1155: l_message_text := FND_MESSAGE.GET;
1156: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1157: l_price_book_messages_tbl(i).message_text := l_message_text;
1158: l_price_book_messages_tbl(i).pb_input_header_id :=
1159: p_pb_input_header_rec.pb_input_header_id;

Line 1168: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1164:
1165: IF p_pb_input_header_rec.generation_time_code NOT IN ('IMMEDIATE', 'SCHEDULE')
1166: THEN
1167: x_return_status := 'E';
1168: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1169: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'GENERATION_TIME_CODE');
1170: l_message_text := FND_MESSAGE.GET;
1171: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1172: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1169: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'GENERATION_TIME_CODE');

1165: IF p_pb_input_header_rec.generation_time_code NOT IN ('IMMEDIATE', 'SCHEDULE')
1166: THEN
1167: x_return_status := 'E';
1168: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1169: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'GENERATION_TIME_CODE');
1170: l_message_text := FND_MESSAGE.GET;
1171: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1172: l_price_book_messages_tbl(i).message_text := l_message_text;
1173: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1170: l_message_text := FND_MESSAGE.GET;

1166: THEN
1167: x_return_status := 'E';
1168: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1169: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'GENERATION_TIME_CODE');
1170: l_message_text := FND_MESSAGE.GET;
1171: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1172: l_price_book_messages_tbl(i).message_text := l_message_text;
1173: l_price_book_messages_tbl(i).pb_input_header_id :=
1174: p_pb_input_header_rec.pb_input_header_id;

Line 1182: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1178:
1179: IF p_pb_input_header_rec.generation_time_code = 'SCHEDULE' THEN
1180: IF p_pb_input_header_rec.gen_schedule_date IS NULL THEN
1181: x_return_status := 'E';
1182: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'GEN_SCHEDULE_DATE');
1184: l_message_text := FND_MESSAGE.GET;
1185: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1186: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'GEN_SCHEDULE_DATE');

1179: IF p_pb_input_header_rec.generation_time_code = 'SCHEDULE' THEN
1180: IF p_pb_input_header_rec.gen_schedule_date IS NULL THEN
1181: x_return_status := 'E';
1182: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'GEN_SCHEDULE_DATE');
1184: l_message_text := FND_MESSAGE.GET;
1185: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1186: l_price_book_messages_tbl(i).message_text := l_message_text;
1187: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1184: l_message_text := FND_MESSAGE.GET;

1180: IF p_pb_input_header_rec.gen_schedule_date IS NULL THEN
1181: x_return_status := 'E';
1182: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'GEN_SCHEDULE_DATE');
1184: l_message_text := FND_MESSAGE.GET;
1185: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1186: l_price_book_messages_tbl(i).message_text := l_message_text;
1187: l_price_book_messages_tbl(i).pb_input_header_id :=
1188: p_pb_input_header_rec.pb_input_header_id;

Line 1203: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1199:
1200: IF p_pb_input_header_rec.pub_template_code is NULL
1201: THEN
1202: x_return_status := 'E';
1203: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1204: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_template_code');
1205: l_message_text := FND_MESSAGE.GET;
1206: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1207: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1204: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_template_code');

1200: IF p_pb_input_header_rec.pub_template_code is NULL
1201: THEN
1202: x_return_status := 'E';
1203: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1204: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_template_code');
1205: l_message_text := FND_MESSAGE.GET;
1206: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1207: l_price_book_messages_tbl(i).message_text := l_message_text;
1208: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1205: l_message_text := FND_MESSAGE.GET;

1201: THEN
1202: x_return_status := 'E';
1203: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1204: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_template_code');
1205: l_message_text := FND_MESSAGE.GET;
1206: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1207: l_price_book_messages_tbl(i).message_text := l_message_text;
1208: l_price_book_messages_tbl(i).pb_input_header_id :=
1209: p_pb_input_header_rec.pb_input_header_id;

Line 1217: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1213:
1214: IF p_pb_input_header_rec.pub_language is NULL
1215: THEN
1216: x_return_status := 'E';
1217: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_language');
1219: l_message_text := FND_MESSAGE.GET;
1220: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1221: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_language');

1214: IF p_pb_input_header_rec.pub_language is NULL
1215: THEN
1216: x_return_status := 'E';
1217: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_language');
1219: l_message_text := FND_MESSAGE.GET;
1220: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1221: l_price_book_messages_tbl(i).message_text := l_message_text;
1222: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1219: l_message_text := FND_MESSAGE.GET;

1215: THEN
1216: x_return_status := 'E';
1217: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_language');
1219: l_message_text := FND_MESSAGE.GET;
1220: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1221: l_price_book_messages_tbl(i).message_text := l_message_text;
1222: l_price_book_messages_tbl(i).pb_input_header_id :=
1223: p_pb_input_header_rec.pb_input_header_id;

Line 1231: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1227:
1228: IF p_pb_input_header_rec.pub_territory is NULL
1229: THEN
1230: x_return_status := 'E';
1231: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_territory');
1233: l_message_text := FND_MESSAGE.GET;
1234: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1235: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_territory');

1228: IF p_pb_input_header_rec.pub_territory is NULL
1229: THEN
1230: x_return_status := 'E';
1231: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_territory');
1233: l_message_text := FND_MESSAGE.GET;
1234: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1235: l_price_book_messages_tbl(i).message_text := l_message_text;
1236: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1233: l_message_text := FND_MESSAGE.GET;

1229: THEN
1230: x_return_status := 'E';
1231: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1232: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'pub_territory');
1233: l_message_text := FND_MESSAGE.GET;
1234: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1235: l_price_book_messages_tbl(i).message_text := l_message_text;
1236: l_price_book_messages_tbl(i).pb_input_header_id :=
1237: p_pb_input_header_rec.pb_input_header_id;

Line 1256: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1252: END;
1253:
1254: IF l_count = 0 THEN
1255: x_return_status := 'E';
1256: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1257: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_TEMPLATE_CODE');
1258: l_message_text := FND_MESSAGE.GET;
1259: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1260: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1257: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_TEMPLATE_CODE');

1253:
1254: IF l_count = 0 THEN
1255: x_return_status := 'E';
1256: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1257: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_TEMPLATE_CODE');
1258: l_message_text := FND_MESSAGE.GET;
1259: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1260: l_price_book_messages_tbl(i).message_text := l_message_text;
1261: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1258: l_message_text := FND_MESSAGE.GET;

1254: IF l_count = 0 THEN
1255: x_return_status := 'E';
1256: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1257: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_TEMPLATE_CODE');
1258: l_message_text := FND_MESSAGE.GET;
1259: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1260: l_price_book_messages_tbl(i).message_text := l_message_text;
1261: l_price_book_messages_tbl(i).pb_input_header_id :=
1262: p_pb_input_header_rec.pb_input_header_id;

Line 1285: FND_MESSAGE.SET_NAME('QP', 'QP_TEMPLATE_COMBI_INVALID');

1281: END;
1282:
1283: IF l_count = 0 THEN
1284: x_return_status := 'E';
1285: FND_MESSAGE.SET_NAME('QP', 'QP_TEMPLATE_COMBI_INVALID');
1286: l_message_text := FND_MESSAGE.GET;
1287: l_price_book_messages_tbl(i).message_code := 'QP_TEMPLATE_COMBI_INVALID';
1288: l_price_book_messages_tbl(i).message_text := l_message_text;
1289: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1286: l_message_text := FND_MESSAGE.GET;

1282:
1283: IF l_count = 0 THEN
1284: x_return_status := 'E';
1285: FND_MESSAGE.SET_NAME('QP', 'QP_TEMPLATE_COMBI_INVALID');
1286: l_message_text := FND_MESSAGE.GET;
1287: l_price_book_messages_tbl(i).message_code := 'QP_TEMPLATE_COMBI_INVALID';
1288: l_price_book_messages_tbl(i).message_text := l_message_text;
1289: l_price_book_messages_tbl(i).pb_input_header_id :=
1290: p_pb_input_header_rec.pb_input_header_id;

Line 1304: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1300: nvl(p_pb_input_header_rec.dlv_email_flag, 'N') <> 'Y'
1301: THEN
1302: IF p_pb_input_header_rec.pub_output_document_type <> 'PDF' THEN
1303: x_return_status := 'E';
1304: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_OUTPUT_DOCUMENT_TYPE');
1306: l_message_text := FND_MESSAGE.GET;
1307: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1308: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_OUTPUT_DOCUMENT_TYPE');

1301: THEN
1302: IF p_pb_input_header_rec.pub_output_document_type <> 'PDF' THEN
1303: x_return_status := 'E';
1304: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_OUTPUT_DOCUMENT_TYPE');
1306: l_message_text := FND_MESSAGE.GET;
1307: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1308: l_price_book_messages_tbl(i).message_text := l_message_text;
1309: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1306: l_message_text := FND_MESSAGE.GET;

1302: IF p_pb_input_header_rec.pub_output_document_type <> 'PDF' THEN
1303: x_return_status := 'E';
1304: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_OUTPUT_DOCUMENT_TYPE');
1306: l_message_text := FND_MESSAGE.GET;
1307: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1308: l_price_book_messages_tbl(i).message_text := l_message_text;
1309: l_price_book_messages_tbl(i).pb_input_header_id :=
1310: p_pb_input_header_rec.pb_input_header_id;

Line 1325: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1321: IF p_pb_input_header_rec.pub_template_code IS NOT NULL AND
1322: p_pb_input_header_rec.pub_output_document_type IS NULL
1323: THEN
1324: x_return_status := 'E';
1325: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_OUTPUT_DOCUMENT_TYPE');
1327: l_message_text := FND_MESSAGE.GET;
1328: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1329: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_OUTPUT_DOCUMENT_TYPE');

1322: p_pb_input_header_rec.pub_output_document_type IS NULL
1323: THEN
1324: x_return_status := 'E';
1325: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_OUTPUT_DOCUMENT_TYPE');
1327: l_message_text := FND_MESSAGE.GET;
1328: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1329: l_price_book_messages_tbl(i).message_text := l_message_text;
1330: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1327: l_message_text := FND_MESSAGE.GET;

1323: THEN
1324: x_return_status := 'E';
1325: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PUB_OUTPUT_DOCUMENT_TYPE');
1327: l_message_text := FND_MESSAGE.GET;
1328: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1329: l_price_book_messages_tbl(i).message_text := l_message_text;
1330: l_price_book_messages_tbl(i).pb_input_header_id :=
1331: p_pb_input_header_rec.pb_input_header_id;

Line 1341: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1337: --If dlv_xml_flag is checked then dlv_xml_site_id is required
1338: IF p_pb_input_header_rec.dlv_xml_flag = 'Y' THEN
1339: IF p_pb_input_header_rec.dlv_xml_site_id IS NULL THEN
1340: x_return_status := 'E';
1341: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_SITE_ID');
1343: l_message_text := FND_MESSAGE.GET;
1344: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1345: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_SITE_ID');

1338: IF p_pb_input_header_rec.dlv_xml_flag = 'Y' THEN
1339: IF p_pb_input_header_rec.dlv_xml_site_id IS NULL THEN
1340: x_return_status := 'E';
1341: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_SITE_ID');
1343: l_message_text := FND_MESSAGE.GET;
1344: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1345: l_price_book_messages_tbl(i).message_text := l_message_text;
1346: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1343: l_message_text := FND_MESSAGE.GET;

1339: IF p_pb_input_header_rec.dlv_xml_site_id IS NULL THEN
1340: x_return_status := 'E';
1341: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1342: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_SITE_ID');
1343: l_message_text := FND_MESSAGE.GET;
1344: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1345: l_price_book_messages_tbl(i).message_text := l_message_text;
1346: l_price_book_messages_tbl(i).pb_input_header_id :=
1347: p_pb_input_header_rec.pb_input_header_id;

Line 1375: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1371: END;
1372:
1373: IF l_count = 0 THEN
1374: x_return_status := 'E';
1375: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_SITE_ID');
1377: l_message_text := FND_MESSAGE.GET;
1378: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1379: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_SITE_ID');

1372:
1373: IF l_count = 0 THEN
1374: x_return_status := 'E';
1375: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_SITE_ID');
1377: l_message_text := FND_MESSAGE.GET;
1378: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1379: l_price_book_messages_tbl(i).message_text := l_message_text;
1380: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1377: l_message_text := FND_MESSAGE.GET;

1373: IF l_count = 0 THEN
1374: x_return_status := 'E';
1375: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DLV_XML_SITE_ID');
1377: l_message_text := FND_MESSAGE.GET;
1378: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1379: l_price_book_messages_tbl(i).message_text := l_message_text;
1380: l_price_book_messages_tbl(i).pb_input_header_id :=
1381: p_pb_input_header_rec.pb_input_header_id;

Line 1408: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');

1404: END;
1405:
1406: IF l_count = 0 THEN
1407: x_return_status := 'E';
1408: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1409: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1410: p_pb_input_header_rec.price_book_name);
1411: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1412: p_pb_input_header_rec.price_book_type_code);

Line 1409: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

1405:
1406: IF l_count = 0 THEN
1407: x_return_status := 'E';
1408: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1409: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1410: p_pb_input_header_rec.price_book_name);
1411: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1412: p_pb_input_header_rec.price_book_type_code);
1413: l_message_text := FND_MESSAGE.GET;

Line 1411: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',

1407: x_return_status := 'E';
1408: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_DOES_NOT_EXIST');
1409: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1410: p_pb_input_header_rec.price_book_name);
1411: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1412: p_pb_input_header_rec.price_book_type_code);
1413: l_message_text := FND_MESSAGE.GET;
1414: l_price_book_messages_tbl(i).message_code := 'QP_PRICE_BOOK_DOES_NOT_EXIST';
1415: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1413: l_message_text := FND_MESSAGE.GET;

1409: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1410: p_pb_input_header_rec.price_book_name);
1411: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1412: p_pb_input_header_rec.price_book_type_code);
1413: l_message_text := FND_MESSAGE.GET;
1414: l_price_book_messages_tbl(i).message_code := 'QP_PRICE_BOOK_DOES_NOT_EXIST';
1415: l_price_book_messages_tbl(i).message_text := l_message_text;
1416: l_price_book_messages_tbl(i).pb_input_header_id :=
1417: p_pb_input_header_rec.pb_input_header_id;

Line 1442: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');

1438: IF l_count > 0 AND nvl(p_pb_input_header_rec.overwrite_existing_pb_flag, 'N') = 'N'
1439: THEN
1440: x_return_status := 'E';
1441: -- Price book to be generated already exists
1442: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
1443: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1444: p_pb_input_header_rec.price_book_name);
1445: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1446: p_pb_input_header_rec.price_book_type_code);

Line 1443: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

1439: THEN
1440: x_return_status := 'E';
1441: -- Price book to be generated already exists
1442: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
1443: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1444: p_pb_input_header_rec.price_book_name);
1445: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1446: p_pb_input_header_rec.price_book_type_code);
1447: l_message_text := FND_MESSAGE.GET;

Line 1445: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',

1441: -- Price book to be generated already exists
1442: FND_MESSAGE.SET_NAME('QP', 'QP_PRICE_BOOK_ALREADY_EXISTS');
1443: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1444: p_pb_input_header_rec.price_book_name);
1445: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1446: p_pb_input_header_rec.price_book_type_code);
1447: l_message_text := FND_MESSAGE.GET;
1448: l_price_book_messages_tbl(i).message_code := 'QP_PRICE_BOOK_ALREADY_EXISTS';
1449: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1447: l_message_text := FND_MESSAGE.GET;

1443: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1444: p_pb_input_header_rec.price_book_name);
1445: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_TYPE_CODE',
1446: p_pb_input_header_rec.price_book_type_code);
1447: l_message_text := FND_MESSAGE.GET;
1448: l_price_book_messages_tbl(i).message_code := 'QP_PRICE_BOOK_ALREADY_EXISTS';
1449: l_price_book_messages_tbl(i).message_text := l_message_text;
1450: l_price_book_messages_tbl(i).pb_input_header_id :=
1451: p_pb_input_header_rec.pb_input_header_id;

Line 1476: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');

1472:
1473: IF l_count = 0 AND l_count2 > 0 THEN
1474: x_return_status := 'E';
1475: -- Price book to be generated already exists
1476: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1477: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1478: p_pb_input_header_rec.price_book_name);
1479: l_message_text := FND_MESSAGE.GET;
1480: l_price_book_messages_tbl(i).message_code := 'QP_PB_EXISTS_IN_ANOTHER_ORG';

Line 1477: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',

1473: IF l_count = 0 AND l_count2 > 0 THEN
1474: x_return_status := 'E';
1475: -- Price book to be generated already exists
1476: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1477: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1478: p_pb_input_header_rec.price_book_name);
1479: l_message_text := FND_MESSAGE.GET;
1480: l_price_book_messages_tbl(i).message_code := 'QP_PB_EXISTS_IN_ANOTHER_ORG';
1481: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1479: l_message_text := FND_MESSAGE.GET;

1475: -- Price book to be generated already exists
1476: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1477: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1478: p_pb_input_header_rec.price_book_name);
1479: l_message_text := FND_MESSAGE.GET;
1480: l_price_book_messages_tbl(i).message_code := 'QP_PB_EXISTS_IN_ANOTHER_ORG';
1481: l_price_book_messages_tbl(i).message_text := l_message_text;
1482: l_price_book_messages_tbl(i).pb_input_header_id :=
1483: p_pb_input_header_rec.pb_input_header_id;

Line 1491: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1487:
1488: --Check if limit_products_by is valid
1489: IF p_pb_input_header_rec.limit_products_by IS NULL THEN
1490: x_return_status := 'E';
1491: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'LIMIT_PRODUCTS_BY');
1493: l_message_text := FND_MESSAGE.GET;
1494: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1495: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'LIMIT_PRODUCTS_BY');

1488: --Check if limit_products_by is valid
1489: IF p_pb_input_header_rec.limit_products_by IS NULL THEN
1490: x_return_status := 'E';
1491: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'LIMIT_PRODUCTS_BY');
1493: l_message_text := FND_MESSAGE.GET;
1494: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1495: l_price_book_messages_tbl(i).message_text := l_message_text;
1496: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1493: l_message_text := FND_MESSAGE.GET;

1489: IF p_pb_input_header_rec.limit_products_by IS NULL THEN
1490: x_return_status := 'E';
1491: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'LIMIT_PRODUCTS_BY');
1493: l_message_text := FND_MESSAGE.GET;
1494: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1495: l_price_book_messages_tbl(i).message_text := l_message_text;
1496: l_price_book_messages_tbl(i).pb_input_header_id :=
1497: p_pb_input_header_rec.pb_input_header_id;

Line 1504: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1500: ELSIF p_pb_input_header_rec.limit_products_by NOT IN
1501: ('ITEM', 'ITEM_CATEGORY', 'ALL_ITEMS', 'PRICE_LIST')
1502: THEN
1503: x_return_status := 'E';
1504: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1505: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'LIMIT_PRODUCTS_BY');
1506: l_message_text := FND_MESSAGE.GET;
1507: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1508: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1505: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'LIMIT_PRODUCTS_BY');

1501: ('ITEM', 'ITEM_CATEGORY', 'ALL_ITEMS', 'PRICE_LIST')
1502: THEN
1503: x_return_status := 'E';
1504: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1505: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'LIMIT_PRODUCTS_BY');
1506: l_message_text := FND_MESSAGE.GET;
1507: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1508: l_price_book_messages_tbl(i).message_text := l_message_text;
1509: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1506: l_message_text := FND_MESSAGE.GET;

1502: THEN
1503: x_return_status := 'E';
1504: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1505: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'LIMIT_PRODUCTS_BY');
1506: l_message_text := FND_MESSAGE.GET;
1507: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1508: l_price_book_messages_tbl(i).message_text := l_message_text;
1509: l_price_book_messages_tbl(i).pb_input_header_id :=
1510: p_pb_input_header_rec.pb_input_header_id;

Line 1517: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1513: ELSE --Validate product_context, product_attribute, product_attr_value
1514: IF p_pb_input_header_rec.limit_products_by = 'ITEM' THEN
1515: IF p_pb_input_header_rec.product_context IS NULL THEN
1516: x_return_status := 'E';
1517: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1518: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1519: l_message_text := FND_MESSAGE.GET;
1520: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1521: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1518: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');

1514: IF p_pb_input_header_rec.limit_products_by = 'ITEM' THEN
1515: IF p_pb_input_header_rec.product_context IS NULL THEN
1516: x_return_status := 'E';
1517: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1518: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1519: l_message_text := FND_MESSAGE.GET;
1520: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1521: l_price_book_messages_tbl(i).message_text := l_message_text;
1522: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1519: l_message_text := FND_MESSAGE.GET;

1515: IF p_pb_input_header_rec.product_context IS NULL THEN
1516: x_return_status := 'E';
1517: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1518: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1519: l_message_text := FND_MESSAGE.GET;
1520: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1521: l_price_book_messages_tbl(i).message_text := l_message_text;
1522: l_price_book_messages_tbl(i).pb_input_header_id :=
1523: p_pb_input_header_rec.pb_input_header_id;

Line 1528: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1524: i := i + 1;
1525: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1526: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1527: x_return_status := 'E';
1528: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1530: l_message_text := FND_MESSAGE.GET;
1531: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1532: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');

1525: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1526: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1527: x_return_status := 'E';
1528: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1530: l_message_text := FND_MESSAGE.GET;
1531: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1532: l_price_book_messages_tbl(i).message_text := l_message_text;
1533: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1530: l_message_text := FND_MESSAGE.GET;

1526: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1527: x_return_status := 'E';
1528: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1530: l_message_text := FND_MESSAGE.GET;
1531: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1532: l_price_book_messages_tbl(i).message_text := l_message_text;
1533: l_price_book_messages_tbl(i).pb_input_header_id :=
1534: p_pb_input_header_rec.pb_input_header_id;

Line 1539: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1535: i := i + 1;
1536: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1537: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1538: x_return_status := 'E';
1539: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1541: l_message_text := FND_MESSAGE.GET;
1542: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1543: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');

1536: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1537: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1538: x_return_status := 'E';
1539: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1541: l_message_text := FND_MESSAGE.GET;
1542: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1543: l_price_book_messages_tbl(i).message_text := l_message_text;
1544: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1541: l_message_text := FND_MESSAGE.GET;

1537: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1538: x_return_status := 'E';
1539: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1541: l_message_text := FND_MESSAGE.GET;
1542: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1543: l_price_book_messages_tbl(i).message_text := l_message_text;
1544: l_price_book_messages_tbl(i).pb_input_header_id :=
1545: p_pb_input_header_rec.pb_input_header_id;

Line 1551: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1547: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1548: ELSIF p_pb_input_header_rec.product_attribute <> 'PRICING_ATTRIBUTE1'
1549: THEN --Product Attribute must be 'Item Number'
1550: x_return_status := 'E';
1551: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1553: l_message_text := FND_MESSAGE.GET;
1554: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1555: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');

1548: ELSIF p_pb_input_header_rec.product_attribute <> 'PRICING_ATTRIBUTE1'
1549: THEN --Product Attribute must be 'Item Number'
1550: x_return_status := 'E';
1551: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1553: l_message_text := FND_MESSAGE.GET;
1554: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1555: l_price_book_messages_tbl(i).message_text := l_message_text;
1556: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1553: l_message_text := FND_MESSAGE.GET;

1549: THEN --Product Attribute must be 'Item Number'
1550: x_return_status := 'E';
1551: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1553: l_message_text := FND_MESSAGE.GET;
1554: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1555: l_price_book_messages_tbl(i).message_text := l_message_text;
1556: l_price_book_messages_tbl(i).pb_input_header_id :=
1557: p_pb_input_header_rec.pb_input_header_id;

Line 1562: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1558: i := i + 1;
1559: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1560: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1561: x_return_status := 'E';
1562: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1563: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1564: l_message_text := FND_MESSAGE.GET;
1565: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1566: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1563: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');

1559: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1560: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1561: x_return_status := 'E';
1562: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1563: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1564: l_message_text := FND_MESSAGE.GET;
1565: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1566: l_price_book_messages_tbl(i).message_text := l_message_text;
1567: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1564: l_message_text := FND_MESSAGE.GET;

1560: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1561: x_return_status := 'E';
1562: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1563: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1564: l_message_text := FND_MESSAGE.GET;
1565: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1566: l_price_book_messages_tbl(i).message_text := l_message_text;
1567: l_price_book_messages_tbl(i).pb_input_header_id :=
1568: p_pb_input_header_rec.pb_input_header_id;

Line 1590: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1586: END;
1587:
1588: IF l_count = 0 THEN
1589: x_return_status := 'E';
1590: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1592: l_message_text := FND_MESSAGE.GET;
1593: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1594: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');

1587:
1588: IF l_count = 0 THEN
1589: x_return_status := 'E';
1590: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1592: l_message_text := FND_MESSAGE.GET;
1593: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1594: l_price_book_messages_tbl(i).message_text := l_message_text;
1595: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1592: l_message_text := FND_MESSAGE.GET;

1588: IF l_count = 0 THEN
1589: x_return_status := 'E';
1590: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1592: l_message_text := FND_MESSAGE.GET;
1593: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1594: l_price_book_messages_tbl(i).message_text := l_message_text;
1595: l_price_book_messages_tbl(i).pb_input_header_id :=
1596: p_pb_input_header_rec.pb_input_header_id;

Line 1605: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1601:
1602: ELSIF p_pb_input_header_rec.limit_products_by = 'ITEM_CATEGORY' THEN
1603: IF p_pb_input_header_rec.product_context IS NULL THEN
1604: x_return_status := 'E';
1605: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1607: l_message_text := FND_MESSAGE.GET;
1608: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1609: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');

1602: ELSIF p_pb_input_header_rec.limit_products_by = 'ITEM_CATEGORY' THEN
1603: IF p_pb_input_header_rec.product_context IS NULL THEN
1604: x_return_status := 'E';
1605: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1607: l_message_text := FND_MESSAGE.GET;
1608: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1609: l_price_book_messages_tbl(i).message_text := l_message_text;
1610: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1607: l_message_text := FND_MESSAGE.GET;

1603: IF p_pb_input_header_rec.product_context IS NULL THEN
1604: x_return_status := 'E';
1605: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1607: l_message_text := FND_MESSAGE.GET;
1608: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1609: l_price_book_messages_tbl(i).message_text := l_message_text;
1610: l_price_book_messages_tbl(i).pb_input_header_id :=
1611: p_pb_input_header_rec.pb_input_header_id;

Line 1616: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1612: i := i + 1;
1613: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1614: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1615: x_return_status := 'E';
1616: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1618: l_message_text := FND_MESSAGE.GET;
1619: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1620: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');

1613: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1614: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1615: x_return_status := 'E';
1616: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1618: l_message_text := FND_MESSAGE.GET;
1619: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1620: l_price_book_messages_tbl(i).message_text := l_message_text;
1621: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1618: l_message_text := FND_MESSAGE.GET;

1614: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1615: x_return_status := 'E';
1616: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1618: l_message_text := FND_MESSAGE.GET;
1619: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1620: l_price_book_messages_tbl(i).message_text := l_message_text;
1621: l_price_book_messages_tbl(i).pb_input_header_id :=
1622: p_pb_input_header_rec.pb_input_header_id;

Line 1627: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1623: i := i + 1;
1624: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1625: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1626: x_return_status := 'E';
1627: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1629: l_message_text := FND_MESSAGE.GET;
1630: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1631: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');

1624: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1625: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1626: x_return_status := 'E';
1627: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1629: l_message_text := FND_MESSAGE.GET;
1630: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1631: l_price_book_messages_tbl(i).message_text := l_message_text;
1632: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1629: l_message_text := FND_MESSAGE.GET;

1625: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1626: x_return_status := 'E';
1627: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1629: l_message_text := FND_MESSAGE.GET;
1630: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1631: l_price_book_messages_tbl(i).message_text := l_message_text;
1632: l_price_book_messages_tbl(i).pb_input_header_id :=
1633: p_pb_input_header_rec.pb_input_header_id;

Line 1639: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1635: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1636: ELSIF p_pb_input_header_rec.product_attribute <> 'PRICING_ATTRIBUTE2'
1637: THEN --Product Attribute must be 'Item Category'
1638: x_return_status := 'E';
1639: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1641: l_message_text := FND_MESSAGE.GET;
1642: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1643: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');

1636: ELSIF p_pb_input_header_rec.product_attribute <> 'PRICING_ATTRIBUTE2'
1637: THEN --Product Attribute must be 'Item Category'
1638: x_return_status := 'E';
1639: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1641: l_message_text := FND_MESSAGE.GET;
1642: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1643: l_price_book_messages_tbl(i).message_text := l_message_text;
1644: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1641: l_message_text := FND_MESSAGE.GET;

1637: THEN --Product Attribute must be 'Item Category'
1638: x_return_status := 'E';
1639: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1641: l_message_text := FND_MESSAGE.GET;
1642: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1643: l_price_book_messages_tbl(i).message_text := l_message_text;
1644: l_price_book_messages_tbl(i).pb_input_header_id :=
1645: p_pb_input_header_rec.pb_input_header_id;

Line 1650: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1646: i := i + 1;
1647: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1648: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1649: x_return_status := 'E';
1650: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1652: l_message_text := FND_MESSAGE.GET;
1653: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1654: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');

1647: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1648: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1649: x_return_status := 'E';
1650: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1652: l_message_text := FND_MESSAGE.GET;
1653: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1654: l_price_book_messages_tbl(i).message_text := l_message_text;
1655: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1652: l_message_text := FND_MESSAGE.GET;

1648: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1649: x_return_status := 'E';
1650: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1652: l_message_text := FND_MESSAGE.GET;
1653: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1654: l_price_book_messages_tbl(i).message_text := l_message_text;
1655: l_price_book_messages_tbl(i).pb_input_header_id :=
1656: p_pb_input_header_rec.pb_input_header_id;

Line 1683: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1679: x_is_valid => l_category_valid);
1680:
1681: IF l_category_valid = FALSE THEN
1682: x_return_status := 'E';
1683: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1685: l_message_text := FND_MESSAGE.GET;
1686: l_price_book_messages_tbl(i).message_code :=
1687: 'QP_INVALID_ATTRIBUTE';

Line 1684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');

1680:
1681: IF l_category_valid = FALSE THEN
1682: x_return_status := 'E';
1683: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1685: l_message_text := FND_MESSAGE.GET;
1686: l_price_book_messages_tbl(i).message_code :=
1687: 'QP_INVALID_ATTRIBUTE';
1688: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1685: l_message_text := FND_MESSAGE.GET;

1681: IF l_category_valid = FALSE THEN
1682: x_return_status := 'E';
1683: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1685: l_message_text := FND_MESSAGE.GET;
1686: l_price_book_messages_tbl(i).message_code :=
1687: 'QP_INVALID_ATTRIBUTE';
1688: l_price_book_messages_tbl(i).message_text := l_message_text;
1689: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1699: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1695:
1696: ELSIF p_pb_input_header_rec.limit_products_by = 'ALL_ITEMS' THEN
1697: IF p_pb_input_header_rec.product_context IS NULL THEN
1698: x_return_status := 'E';
1699: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1701: l_message_text := FND_MESSAGE.GET;
1702: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1703: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');

1696: ELSIF p_pb_input_header_rec.limit_products_by = 'ALL_ITEMS' THEN
1697: IF p_pb_input_header_rec.product_context IS NULL THEN
1698: x_return_status := 'E';
1699: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1701: l_message_text := FND_MESSAGE.GET;
1702: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1703: l_price_book_messages_tbl(i).message_text := l_message_text;
1704: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1701: l_message_text := FND_MESSAGE.GET;

1697: IF p_pb_input_header_rec.product_context IS NULL THEN
1698: x_return_status := 'E';
1699: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1700: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1701: l_message_text := FND_MESSAGE.GET;
1702: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1703: l_price_book_messages_tbl(i).message_text := l_message_text;
1704: l_price_book_messages_tbl(i).pb_input_header_id :=
1705: p_pb_input_header_rec.pb_input_header_id;

Line 1710: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1706: i := i + 1;
1707: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1708: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1709: x_return_status := 'E';
1710: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1712: l_message_text := FND_MESSAGE.GET;
1713: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1714: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');

1707: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1708: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1709: x_return_status := 'E';
1710: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1712: l_message_text := FND_MESSAGE.GET;
1713: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1714: l_price_book_messages_tbl(i).message_text := l_message_text;
1715: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1712: l_message_text := FND_MESSAGE.GET;

1708: ELSIF p_pb_input_header_rec.product_attribute IS NULL THEN
1709: x_return_status := 'E';
1710: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1711: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1712: l_message_text := FND_MESSAGE.GET;
1713: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1714: l_price_book_messages_tbl(i).message_text := l_message_text;
1715: l_price_book_messages_tbl(i).pb_input_header_id :=
1716: p_pb_input_header_rec.pb_input_header_id;

Line 1721: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1717: i := i + 1;
1718: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1719: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1720: x_return_status := 'E';
1721: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1723: l_message_text := FND_MESSAGE.GET;
1724: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1725: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');

1718: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1719: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1720: x_return_status := 'E';
1721: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1723: l_message_text := FND_MESSAGE.GET;
1724: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1725: l_price_book_messages_tbl(i).message_text := l_message_text;
1726: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1723: l_message_text := FND_MESSAGE.GET;

1719: ELSIF p_pb_input_header_rec.product_context <> 'ITEM' THEN
1720: x_return_status := 'E';
1721: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_CONTEXT');
1723: l_message_text := FND_MESSAGE.GET;
1724: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1725: l_price_book_messages_tbl(i).message_text := l_message_text;
1726: l_price_book_messages_tbl(i).pb_input_header_id :=
1727: p_pb_input_header_rec.pb_input_header_id;

Line 1733: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1729: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1730: ELSIF p_pb_input_header_rec.product_attribute <> 'PRICING_ATTRIBUTE3'
1731: THEN --Product Attribute must be 'All Items'
1732: x_return_status := 'E';
1733: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1735: l_message_text := FND_MESSAGE.GET;
1736: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1737: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');

1730: ELSIF p_pb_input_header_rec.product_attribute <> 'PRICING_ATTRIBUTE3'
1731: THEN --Product Attribute must be 'All Items'
1732: x_return_status := 'E';
1733: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1735: l_message_text := FND_MESSAGE.GET;
1736: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1737: l_price_book_messages_tbl(i).message_text := l_message_text;
1738: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1735: l_message_text := FND_MESSAGE.GET;

1731: THEN --Product Attribute must be 'All Items'
1732: x_return_status := 'E';
1733: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTRIBUTE');
1735: l_message_text := FND_MESSAGE.GET;
1736: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1737: l_price_book_messages_tbl(i).message_text := l_message_text;
1738: l_price_book_messages_tbl(i).pb_input_header_id :=
1739: p_pb_input_header_rec.pb_input_header_id;

Line 1744: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1740: i := i + 1;
1741: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1742: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1743: x_return_status := 'E';
1744: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1746: l_message_text := FND_MESSAGE.GET;
1747: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1748: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');

1741: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1742: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1743: x_return_status := 'E';
1744: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1746: l_message_text := FND_MESSAGE.GET;
1747: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1748: l_price_book_messages_tbl(i).message_text := l_message_text;
1749: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1746: l_message_text := FND_MESSAGE.GET;

1742: ELSIF p_pb_input_header_rec.product_attr_value IS NULL THEN
1743: x_return_status := 'E';
1744: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1746: l_message_text := FND_MESSAGE.GET;
1747: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1748: l_price_book_messages_tbl(i).message_text := l_message_text;
1749: l_price_book_messages_tbl(i).pb_input_header_id :=
1750: p_pb_input_header_rec.pb_input_header_id;

Line 1755: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1751: i := i + 1;
1752: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1753: ELSIF p_pb_input_header_rec.product_attr_value <> 'ALL' THEN
1754: x_return_status := 'E';
1755: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1757: l_message_text := FND_MESSAGE.GET;
1758: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1759: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');

1752: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1753: ELSIF p_pb_input_header_rec.product_attr_value <> 'ALL' THEN
1754: x_return_status := 'E';
1755: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1757: l_message_text := FND_MESSAGE.GET;
1758: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1759: l_price_book_messages_tbl(i).message_text := l_message_text;
1760: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1757: l_message_text := FND_MESSAGE.GET;

1753: ELSIF p_pb_input_header_rec.product_attr_value <> 'ALL' THEN
1754: x_return_status := 'E';
1755: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRODUCT_ATTR_VALUE');
1757: l_message_text := FND_MESSAGE.GET;
1758: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1759: l_price_book_messages_tbl(i).message_text := l_message_text;
1760: l_price_book_messages_tbl(i).pb_input_header_id :=
1761: p_pb_input_header_rec.pb_input_header_id;

Line 1769: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1765:
1766: ELSIF p_pb_input_header_rec.limit_products_by = 'PRICE_LIST' THEN
1767: IF p_pb_input_header_rec.pl_agr_bsa_id IS NULL THEN
1768: x_return_status := 'E';
1769: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1770: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1771: l_message_text := FND_MESSAGE.GET;
1772: l_price_book_messages_tbl(i).message_code :=
1773: 'QP_ATTRIBUTE_REQUIRED';

Line 1770: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');

1766: ELSIF p_pb_input_header_rec.limit_products_by = 'PRICE_LIST' THEN
1767: IF p_pb_input_header_rec.pl_agr_bsa_id IS NULL THEN
1768: x_return_status := 'E';
1769: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1770: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1771: l_message_text := FND_MESSAGE.GET;
1772: l_price_book_messages_tbl(i).message_code :=
1773: 'QP_ATTRIBUTE_REQUIRED';
1774: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1771: l_message_text := FND_MESSAGE.GET;

1767: IF p_pb_input_header_rec.pl_agr_bsa_id IS NULL THEN
1768: x_return_status := 'E';
1769: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1770: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1771: l_message_text := FND_MESSAGE.GET;
1772: l_price_book_messages_tbl(i).message_code :=
1773: 'QP_ATTRIBUTE_REQUIRED';
1774: l_price_book_messages_tbl(i).message_text := l_message_text;
1775: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1781: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1777: i := i + 1;
1778: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1779: ELSIF nvl(p_pb_input_header_rec.price_based_on, 'X') <> 'PRICE_LIST' THEN
1780: x_return_status := 'E';
1781: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BASED_ON');
1783: l_message_text := FND_MESSAGE.GET;
1784: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1785: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BASED_ON');

1778: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1779: ELSIF nvl(p_pb_input_header_rec.price_based_on, 'X') <> 'PRICE_LIST' THEN
1780: x_return_status := 'E';
1781: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BASED_ON');
1783: l_message_text := FND_MESSAGE.GET;
1784: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1785: l_price_book_messages_tbl(i).message_text := l_message_text;
1786: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1783: l_message_text := FND_MESSAGE.GET;

1779: ELSIF nvl(p_pb_input_header_rec.price_based_on, 'X') <> 'PRICE_LIST' THEN
1780: x_return_status := 'E';
1781: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BASED_ON');
1783: l_message_text := FND_MESSAGE.GET;
1784: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1785: l_price_book_messages_tbl(i).message_text := l_message_text;
1786: l_price_book_messages_tbl(i).pb_input_header_id :=
1787: p_pb_input_header_rec.pb_input_header_id;

Line 1812: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1808: END;
1809:
1810: IF l_count = 0 THEN
1811: x_return_status := 'E';
1812: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1813: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1814: l_message_text := FND_MESSAGE.GET;
1815: l_price_book_messages_tbl(i).message_code :=
1816: 'QP_INVALID_ATTRIBUTE';

Line 1813: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');

1809:
1810: IF l_count = 0 THEN
1811: x_return_status := 'E';
1812: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1813: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1814: l_message_text := FND_MESSAGE.GET;
1815: l_price_book_messages_tbl(i).message_code :=
1816: 'QP_INVALID_ATTRIBUTE';
1817: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1814: l_message_text := FND_MESSAGE.GET;

1810: IF l_count = 0 THEN
1811: x_return_status := 'E';
1812: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1813: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1814: l_message_text := FND_MESSAGE.GET;
1815: l_price_book_messages_tbl(i).message_code :=
1816: 'QP_INVALID_ATTRIBUTE';
1817: l_price_book_messages_tbl(i).message_text := l_message_text;
1818: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1837: FND_MESSAGE.SET_NAME('QP', 'QP_PO_PRICE_BASED_ON');

1833: IF p_pb_input_header_rec.pricing_perspective_code = 'PO' AND
1834: p_pb_input_header_rec.price_based_on <> 'PRICE_LIST'
1835: THEN
1836: x_return_status := 'E';
1837: FND_MESSAGE.SET_NAME('QP', 'QP_PO_PRICE_BASED_ON');
1838: l_message_text := FND_MESSAGE.GET;
1839: l_price_book_messages_tbl(i).message_code := 'QP_PO_PRICE_BASED_ON';
1840: l_price_book_messages_tbl(i).message_text := l_message_text;
1841: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1838: l_message_text := FND_MESSAGE.GET;

1834: p_pb_input_header_rec.price_based_on <> 'PRICE_LIST'
1835: THEN
1836: x_return_status := 'E';
1837: FND_MESSAGE.SET_NAME('QP', 'QP_PO_PRICE_BASED_ON');
1838: l_message_text := FND_MESSAGE.GET;
1839: l_price_book_messages_tbl(i).message_code := 'QP_PO_PRICE_BASED_ON';
1840: l_price_book_messages_tbl(i).message_text := l_message_text;
1841: l_price_book_messages_tbl(i).pb_input_header_id :=
1842: p_pb_input_header_rec.pb_input_header_id;

Line 1849: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1845: ELSIF p_pb_input_header_rec.price_based_on NOT IN ('PRICE_LIST',
1846: 'AGREEMENT', 'BSA')
1847: THEN
1848: x_return_status := 'E';
1849: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BASED_ON');
1851: l_message_text := FND_MESSAGE.GET;
1852: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1853: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BASED_ON');

1846: 'AGREEMENT', 'BSA')
1847: THEN
1848: x_return_status := 'E';
1849: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BASED_ON');
1851: l_message_text := FND_MESSAGE.GET;
1852: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1853: l_price_book_messages_tbl(i).message_text := l_message_text;
1854: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1851: l_message_text := FND_MESSAGE.GET;

1847: THEN
1848: x_return_status := 'E';
1849: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1850: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PRICE_BASED_ON');
1851: l_message_text := FND_MESSAGE.GET;
1852: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
1853: l_price_book_messages_tbl(i).message_text := l_message_text;
1854: l_price_book_messages_tbl(i).pb_input_header_id :=
1855: p_pb_input_header_rec.pb_input_header_id;

Line 1861: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

1857: x_return_text := x_return_text || substr(l_message_text, 1, 240);
1858: ELSE --validate pl_agr_bsa_id
1859: IF p_pb_input_header_rec.pl_agr_bsa_id IS NULL THEN
1860: x_return_status := 'E';
1861: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1863: l_message_text := FND_MESSAGE.GET;
1864: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1865: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');

1858: ELSE --validate pl_agr_bsa_id
1859: IF p_pb_input_header_rec.pl_agr_bsa_id IS NULL THEN
1860: x_return_status := 'E';
1861: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1863: l_message_text := FND_MESSAGE.GET;
1864: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1865: l_price_book_messages_tbl(i).message_text := l_message_text;
1866: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1863: l_message_text := FND_MESSAGE.GET;

1859: IF p_pb_input_header_rec.pl_agr_bsa_id IS NULL THEN
1860: x_return_status := 'E';
1861: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
1862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1863: l_message_text := FND_MESSAGE.GET;
1864: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
1865: l_price_book_messages_tbl(i).message_text := l_message_text;
1866: l_price_book_messages_tbl(i).pb_input_header_id :=
1867: p_pb_input_header_rec.pb_input_header_id;

Line 1893: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1889: END;
1890:
1891: IF l_count = 0 THEN
1892: x_return_status := 'E';
1893: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1894: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1895: l_message_text := FND_MESSAGE.GET;
1896: l_price_book_messages_tbl(i).message_code :=
1897: 'QP_INVALID_ATTRIBUTE';

Line 1894: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');

1890:
1891: IF l_count = 0 THEN
1892: x_return_status := 'E';
1893: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1894: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1895: l_message_text := FND_MESSAGE.GET;
1896: l_price_book_messages_tbl(i).message_code :=
1897: 'QP_INVALID_ATTRIBUTE';
1898: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1895: l_message_text := FND_MESSAGE.GET;

1891: IF l_count = 0 THEN
1892: x_return_status := 'E';
1893: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1894: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1895: l_message_text := FND_MESSAGE.GET;
1896: l_price_book_messages_tbl(i).message_code :=
1897: 'QP_INVALID_ATTRIBUTE';
1898: l_price_book_messages_tbl(i).message_text := l_message_text;
1899: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1943: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1939: END;
1940:
1941: IF l_count = 0 THEN
1942: x_return_status := 'E';
1943: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1945: l_message_text := FND_MESSAGE.GET;
1946: l_price_book_messages_tbl(i).message_code :=
1947: 'QP_INVALID_ATTRIBUTE';

Line 1944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');

1940:
1941: IF l_count = 0 THEN
1942: x_return_status := 'E';
1943: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1945: l_message_text := FND_MESSAGE.GET;
1946: l_price_book_messages_tbl(i).message_code :=
1947: 'QP_INVALID_ATTRIBUTE';
1948: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1945: l_message_text := FND_MESSAGE.GET;

1941: IF l_count = 0 THEN
1942: x_return_status := 'E';
1943: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1944: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1945: l_message_text := FND_MESSAGE.GET;
1946: l_price_book_messages_tbl(i).message_code :=
1947: 'QP_INVALID_ATTRIBUTE';
1948: l_price_book_messages_tbl(i).message_text := l_message_text;
1949: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 1983: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

1979: END;
1980:
1981: IF l_count = 0 THEN
1982: x_return_status := 'E';
1983: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1984: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1985: l_message_text := FND_MESSAGE.GET;
1986: l_price_book_messages_tbl(i).message_code :=
1987: 'QP_INVALID_ATTRIBUTE';

Line 1984: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');

1980:
1981: IF l_count = 0 THEN
1982: x_return_status := 'E';
1983: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1984: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1985: l_message_text := FND_MESSAGE.GET;
1986: l_price_book_messages_tbl(i).message_code :=
1987: 'QP_INVALID_ATTRIBUTE';
1988: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 1985: l_message_text := FND_MESSAGE.GET;

1981: IF l_count = 0 THEN
1982: x_return_status := 'E';
1983: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
1984: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'PL_AGR_BSA_ID');
1985: l_message_text := FND_MESSAGE.GET;
1986: l_price_book_messages_tbl(i).message_code :=
1987: 'QP_INVALID_ATTRIBUTE';
1988: l_price_book_messages_tbl(i).message_text := l_message_text;
1989: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2004: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

2000:
2001: --Check if currency_code is not null
2002: IF p_pb_input_header_rec.currency_code IS NULL THEN
2003: x_return_status := 'E';
2004: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2005: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CURRENCY_CODE');
2006: l_message_text := FND_MESSAGE.GET;
2007: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2008: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2005: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CURRENCY_CODE');

2001: --Check if currency_code is not null
2002: IF p_pb_input_header_rec.currency_code IS NULL THEN
2003: x_return_status := 'E';
2004: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2005: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CURRENCY_CODE');
2006: l_message_text := FND_MESSAGE.GET;
2007: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2008: l_price_book_messages_tbl(i).message_text := l_message_text;
2009: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2006: l_message_text := FND_MESSAGE.GET;

2002: IF p_pb_input_header_rec.currency_code IS NULL THEN
2003: x_return_status := 'E';
2004: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2005: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CURRENCY_CODE');
2006: l_message_text := FND_MESSAGE.GET;
2007: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2008: l_price_book_messages_tbl(i).message_text := l_message_text;
2009: l_price_book_messages_tbl(i).pb_input_header_id :=
2010: p_pb_input_header_rec.pb_input_header_id;

Line 2027: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICELIST_N_CURR');

2023: l_validate_result => l_valid_currency);
2024:
2025: IF l_valid_currency = 'N' THEN
2026: x_return_status := 'E';
2027: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICELIST_N_CURR');
2028: l_message_text := FND_MESSAGE.GET;
2029: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_PRICELIST_N_CURR';
2030: l_price_book_messages_tbl(i).message_text := l_message_text;
2031: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2028: l_message_text := FND_MESSAGE.GET;

2024:
2025: IF l_valid_currency = 'N' THEN
2026: x_return_status := 'E';
2027: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_PRICELIST_N_CURR');
2028: l_message_text := FND_MESSAGE.GET;
2029: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_PRICELIST_N_CURR';
2030: l_price_book_messages_tbl(i).message_text := l_message_text;
2031: l_price_book_messages_tbl(i).pb_input_header_id :=
2032: p_pb_input_header_rec.pb_input_header_id;

Line 2057: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

2053: END;
2054:
2055: IF l_count = 0 THEN -- invalid currency_code
2056: x_return_status := 'E';
2057: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CURRENCY_CODE');
2059: l_message_text := FND_MESSAGE.GET;
2060: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2061: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CURRENCY_CODE');

2054:
2055: IF l_count = 0 THEN -- invalid currency_code
2056: x_return_status := 'E';
2057: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CURRENCY_CODE');
2059: l_message_text := FND_MESSAGE.GET;
2060: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2061: l_price_book_messages_tbl(i).message_text := l_message_text;
2062: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2059: l_message_text := FND_MESSAGE.GET;

2055: IF l_count = 0 THEN -- invalid currency_code
2056: x_return_status := 'E';
2057: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2058: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CURRENCY_CODE');
2059: l_message_text := FND_MESSAGE.GET;
2060: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2061: l_price_book_messages_tbl(i).message_text := l_message_text;
2062: l_price_book_messages_tbl(i).pb_input_header_id :=
2063: p_pb_input_header_rec.pb_input_header_id;

Line 2072: FND_MESSAGE.SET_NAME('QP', 'QP_ITEM_QTY_NEGATIVE_OR_ZERO');

2068:
2069: --Validate item_quantity
2070: IF p_pb_input_header_rec.item_quantity <= 0 THEN
2071: x_return_status := 'E';
2072: FND_MESSAGE.SET_NAME('QP', 'QP_ITEM_QTY_NEGATIVE_OR_ZERO');
2073: l_message_text := FND_MESSAGE.GET;
2074: l_price_book_messages_tbl(i).message_code := 'QP_ITEM_QTY_NEGATIVE_OR_ZERO';
2075: l_price_book_messages_tbl(i).message_text := l_message_text;
2076: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2073: l_message_text := FND_MESSAGE.GET;

2069: --Validate item_quantity
2070: IF p_pb_input_header_rec.item_quantity <= 0 THEN
2071: x_return_status := 'E';
2072: FND_MESSAGE.SET_NAME('QP', 'QP_ITEM_QTY_NEGATIVE_OR_ZERO');
2073: l_message_text := FND_MESSAGE.GET;
2074: l_price_book_messages_tbl(i).message_code := 'QP_ITEM_QTY_NEGATIVE_OR_ZERO';
2075: l_price_book_messages_tbl(i).message_text := l_message_text;
2076: l_price_book_messages_tbl(i).pb_input_header_id :=
2077: p_pb_input_header_rec.pb_input_header_id;

Line 2089: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

2085: LOOP
2086:
2087: IF p_pb_input_lines_tbl(j).context IS NULL THEN
2088: x_return_status := 'E';
2089: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CONTEXT');
2091: l_message_text := FND_MESSAGE.GET;
2092: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2093: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CONTEXT');

2086:
2087: IF p_pb_input_lines_tbl(j).context IS NULL THEN
2088: x_return_status := 'E';
2089: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CONTEXT');
2091: l_message_text := FND_MESSAGE.GET;
2092: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2093: l_price_book_messages_tbl(i).message_text := l_message_text;
2094: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2091: l_message_text := FND_MESSAGE.GET;

2087: IF p_pb_input_lines_tbl(j).context IS NULL THEN
2088: x_return_status := 'E';
2089: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'CONTEXT');
2091: l_message_text := FND_MESSAGE.GET;
2092: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2093: l_price_book_messages_tbl(i).message_text := l_message_text;
2094: l_price_book_messages_tbl(i).pb_input_header_id :=
2095: p_pb_input_header_rec.pb_input_header_id;

Line 2100: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

2096: i := i + 1;
2097: x_return_text := x_return_text || substr(l_message_text, 1, 240);
2098: ELSIF p_pb_input_lines_tbl(j).attribute IS NULL THEN
2099: x_return_status := 'E';
2100: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE');
2102: l_message_text := FND_MESSAGE.GET;
2103: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2104: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE');

2097: x_return_text := x_return_text || substr(l_message_text, 1, 240);
2098: ELSIF p_pb_input_lines_tbl(j).attribute IS NULL THEN
2099: x_return_status := 'E';
2100: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE');
2102: l_message_text := FND_MESSAGE.GET;
2103: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2104: l_price_book_messages_tbl(i).message_text := l_message_text;
2105: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2102: l_message_text := FND_MESSAGE.GET;

2098: ELSIF p_pb_input_lines_tbl(j).attribute IS NULL THEN
2099: x_return_status := 'E';
2100: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2101: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE');
2102: l_message_text := FND_MESSAGE.GET;
2103: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2104: l_price_book_messages_tbl(i).message_text := l_message_text;
2105: l_price_book_messages_tbl(i).pb_input_header_id :=
2106: p_pb_input_header_rec.pb_input_header_id;

Line 2111: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');

2107: i := i + 1;
2108: x_return_text := x_return_text || substr(l_message_text, 1, 240);
2109: ELSIF p_pb_input_lines_tbl(j).attribute_type IS NULL THEN
2110: x_return_status := 'E';
2111: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE_TYPE');
2113: l_message_text := FND_MESSAGE.GET;
2114: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2115: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE_TYPE');

2108: x_return_text := x_return_text || substr(l_message_text, 1, 240);
2109: ELSIF p_pb_input_lines_tbl(j).attribute_type IS NULL THEN
2110: x_return_status := 'E';
2111: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE_TYPE');
2113: l_message_text := FND_MESSAGE.GET;
2114: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2115: l_price_book_messages_tbl(i).message_text := l_message_text;
2116: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2113: l_message_text := FND_MESSAGE.GET;

2109: ELSIF p_pb_input_lines_tbl(j).attribute_type IS NULL THEN
2110: x_return_status := 'E';
2111: FND_MESSAGE.SET_NAME('QP', 'QP_ATTRIBUTE_REQUIRED');
2112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE_TYPE');
2113: l_message_text := FND_MESSAGE.GET;
2114: l_price_book_messages_tbl(i).message_code := 'QP_ATTRIBUTE_REQUIRED';
2115: l_price_book_messages_tbl(i).message_text := l_message_text;
2116: l_price_book_messages_tbl(i).pb_input_header_id :=
2117: p_pb_input_header_rec.pb_input_header_id;

Line 2123: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

2119: x_return_text := x_return_text || substr(l_message_text, 1, 240);
2120: ELSIF p_pb_input_lines_tbl(j).attribute_type NOT IN
2121: ('QUALIFIER', 'PRICING_ATTRIBUTE') THEN
2122: x_return_status := 'E';
2123: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE_TYPE');
2125: l_message_text := FND_MESSAGE.GET;
2126: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2127: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE_TYPE');

2120: ELSIF p_pb_input_lines_tbl(j).attribute_type NOT IN
2121: ('QUALIFIER', 'PRICING_ATTRIBUTE') THEN
2122: x_return_status := 'E';
2123: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE_TYPE');
2125: l_message_text := FND_MESSAGE.GET;
2126: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2127: l_price_book_messages_tbl(i).message_text := l_message_text;
2128: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2125: l_message_text := FND_MESSAGE.GET;

2121: ('QUALIFIER', 'PRICING_ATTRIBUTE') THEN
2122: x_return_status := 'E';
2123: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2124: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE_TYPE');
2125: l_message_text := FND_MESSAGE.GET;
2126: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2127: l_price_book_messages_tbl(i).message_text := l_message_text;
2128: l_price_book_messages_tbl(i).pb_input_header_id :=
2129: p_pb_input_header_rec.pb_input_header_id;

Line 2148: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

2144: END;
2145:
2146: IF l_count = 0 THEN
2147: x_return_status := 'E';
2148: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2150: 'CONTEXT'||'-'||substr(p_pb_input_lines_tbl(j).context, 1, 20));
2151: l_message_text := FND_MESSAGE.GET;
2152: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';

Line 2149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2145:
2146: IF l_count = 0 THEN
2147: x_return_status := 'E';
2148: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2150: 'CONTEXT'||'-'||substr(p_pb_input_lines_tbl(j).context, 1, 20));
2151: l_message_text := FND_MESSAGE.GET;
2152: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2153: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2151: l_message_text := FND_MESSAGE.GET;

2147: x_return_status := 'E';
2148: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2149: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2150: 'CONTEXT'||'-'||substr(p_pb_input_lines_tbl(j).context, 1, 20));
2151: l_message_text := FND_MESSAGE.GET;
2152: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2153: l_price_book_messages_tbl(i).message_text := l_message_text;
2154: l_price_book_messages_tbl(i).pb_input_header_id :=
2155: p_pb_input_header_rec.pb_input_header_id;

Line 2217: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

2213: END;
2214:
2215: IF l_count = 0 THEN
2216: x_return_status := 'E';
2217: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE'||'-'||substr(p_pb_input_lines_tbl(j).attribute, 1, 20));
2219: l_message_text := FND_MESSAGE.GET;
2220: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2221: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE'||'-'||substr(p_pb_input_lines_tbl(j).attribute, 1, 20));

2214:
2215: IF l_count = 0 THEN
2216: x_return_status := 'E';
2217: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE'||'-'||substr(p_pb_input_lines_tbl(j).attribute, 1, 20));
2219: l_message_text := FND_MESSAGE.GET;
2220: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2221: l_price_book_messages_tbl(i).message_text := l_message_text;
2222: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2219: l_message_text := FND_MESSAGE.GET;

2215: IF l_count = 0 THEN
2216: x_return_status := 'E';
2217: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2218: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'ATTRIBUTE'||'-'||substr(p_pb_input_lines_tbl(j).attribute, 1, 20));
2219: l_message_text := FND_MESSAGE.GET;
2220: l_price_book_messages_tbl(i).message_code := 'QP_INVALID_ATTRIBUTE';
2221: l_price_book_messages_tbl(i).message_text := l_message_text;
2222: l_price_book_messages_tbl(i).pb_input_header_id :=
2223: p_pb_input_header_rec.pb_input_header_id;

Line 2249: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

2245: QP_UTIL.validate_num_date(l_datatype,
2246: p_pb_input_lines_tbl(j).attribute_value) <> 0
2247: THEN
2248: x_return_status := 'E';
2249: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'VALUE'||'-'||substr(p_pb_input_lines_tbl(j).attribute_value, 1, 20));
2251: l_message_text := FND_MESSAGE.GET;
2252: l_price_book_messages_tbl(i).message_code :=
2253: 'QP_INVALID_ATTRIBUTE';

Line 2250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'VALUE'||'-'||substr(p_pb_input_lines_tbl(j).attribute_value, 1, 20));

2246: p_pb_input_lines_tbl(j).attribute_value) <> 0
2247: THEN
2248: x_return_status := 'E';
2249: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'VALUE'||'-'||substr(p_pb_input_lines_tbl(j).attribute_value, 1, 20));
2251: l_message_text := FND_MESSAGE.GET;
2252: l_price_book_messages_tbl(i).message_code :=
2253: 'QP_INVALID_ATTRIBUTE';
2254: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2251: l_message_text := FND_MESSAGE.GET;

2247: THEN
2248: x_return_status := 'E';
2249: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');
2250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'VALUE'||'-'||substr(p_pb_input_lines_tbl(j).attribute_value, 1, 20));
2251: l_message_text := FND_MESSAGE.GET;
2252: l_price_book_messages_tbl(i).message_code :=
2253: 'QP_INVALID_ATTRIBUTE';
2254: l_price_book_messages_tbl(i).message_text := l_message_text;
2255: l_price_book_messages_tbl(i).pb_input_header_id :=

Line 2311: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');

2307: WHERE pb_input_header_id = p_pb_input_header_id;
2308: EXCEPTION
2309: WHEN OTHERS THEN
2310: x_return_status := 'E';
2311: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');
2312: l_message_text := FND_MESSAGE.GET;
2313: l_price_book_messages_tbl(i).message_code :=
2314: 'QP_INPUT_REC_NOT_FOUND';
2315: l_price_book_messages_tbl(i).message_text := l_message_text;

Line 2312: l_message_text := FND_MESSAGE.GET;

2308: EXCEPTION
2309: WHEN OTHERS THEN
2310: x_return_status := 'E';
2311: FND_MESSAGE.SET_NAME('QP', 'QP_INPUT_REC_NOT_FOUND');
2312: l_message_text := FND_MESSAGE.GET;
2313: l_price_book_messages_tbl(i).message_code :=
2314: 'QP_INPUT_REC_NOT_FOUND';
2315: l_price_book_messages_tbl(i).message_text := l_message_text;
2316: l_price_book_messages_tbl(i).pb_input_header_id := p_pb_input_header_id;

Line 3098: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_NOT_FOUND');

3094: EXCEPTION
3095: WHEN NO_DATA_FOUND THEN
3096: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';
3097: x_return_status := FND_API.G_RET_STS_ERROR;
3098: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_NOT_FOUND');
3099: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_item_number);
3100: x_return_text := FND_MESSAGE.GET;
3101: WHEN TOO_MANY_ROWS THEN
3102: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';

Line 3099: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_item_number);

3095: WHEN NO_DATA_FOUND THEN
3096: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';
3097: x_return_status := FND_API.G_RET_STS_ERROR;
3098: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_NOT_FOUND');
3099: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_item_number);
3100: x_return_text := FND_MESSAGE.GET;
3101: WHEN TOO_MANY_ROWS THEN
3102: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';
3103: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3100: x_return_text := FND_MESSAGE.GET;

3096: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';
3097: x_return_status := FND_API.G_RET_STS_ERROR;
3098: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_NOT_FOUND');
3099: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_item_number);
3100: x_return_text := FND_MESSAGE.GET;
3101: WHEN TOO_MANY_ROWS THEN
3102: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_MULTI_FOUND');

Line 3104: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_MULTI_FOUND');

3100: x_return_text := FND_MESSAGE.GET;
3101: WHEN TOO_MANY_ROWS THEN
3102: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_MULTI_FOUND');
3105: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_item_number);
3106: x_return_text := FND_MESSAGE.GET;
3107: END;
3108: /*

Line 3105: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_item_number);

3101: WHEN TOO_MANY_ROWS THEN
3102: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_MULTI_FOUND');
3105: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_item_number);
3106: x_return_text := FND_MESSAGE.GET;
3107: END;
3108: /*
3109: ELSIF (p_item_number_cust is not null) THEN

Line 3106: x_return_text := FND_MESSAGE.GET;

3102: x_prod_attr_value := 'ITEM_LOOKUP_FAILED';
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ITEM_MULTI_FOUND');
3105: FND_MESSAGE.SET_TOKEN('ITEM_NUMBER', p_item_number);
3106: x_return_text := FND_MESSAGE.GET;
3107: END;
3108: /*
3109: ELSIF (p_item_number_cust is not null) THEN
3110: BEGIN

Line 3144: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_NOT_FOUND');

3140: EXCEPTION
3141: WHEN NO_DATA_FOUND THEN
3142: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_NOT_FOUND');
3145: FND_MESSAGE.SET_TOKEN('CATEGORY_NAME', p_item_category_name);
3146: x_return_text := FND_MESSAGE.GET;
3147: WHEN TOO_MANY_ROWS THEN
3148: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';

Line 3145: FND_MESSAGE.SET_TOKEN('CATEGORY_NAME', p_item_category_name);

3141: WHEN NO_DATA_FOUND THEN
3142: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_NOT_FOUND');
3145: FND_MESSAGE.SET_TOKEN('CATEGORY_NAME', p_item_category_name);
3146: x_return_text := FND_MESSAGE.GET;
3147: WHEN TOO_MANY_ROWS THEN
3148: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';
3149: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3146: x_return_text := FND_MESSAGE.GET;

3142: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';
3143: x_return_status := FND_API.G_RET_STS_ERROR;
3144: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_NOT_FOUND');
3145: FND_MESSAGE.SET_TOKEN('CATEGORY_NAME', p_item_category_name);
3146: x_return_text := FND_MESSAGE.GET;
3147: WHEN TOO_MANY_ROWS THEN
3148: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';
3149: x_return_status := FND_API.G_RET_STS_ERROR;
3150: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_MULTI_FOUND');

Line 3150: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_MULTI_FOUND');

3146: x_return_text := FND_MESSAGE.GET;
3147: WHEN TOO_MANY_ROWS THEN
3148: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';
3149: x_return_status := FND_API.G_RET_STS_ERROR;
3150: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_MULTI_FOUND');
3151: FND_MESSAGE.SET_TOKEN('CATEGORY_NAME', p_item_category_name);
3152: x_return_text := FND_MESSAGE.GET;
3153: END;
3154: END IF;

Line 3151: FND_MESSAGE.SET_TOKEN('CATEGORY_NAME', p_item_category_name);

3147: WHEN TOO_MANY_ROWS THEN
3148: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';
3149: x_return_status := FND_API.G_RET_STS_ERROR;
3150: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_MULTI_FOUND');
3151: FND_MESSAGE.SET_TOKEN('CATEGORY_NAME', p_item_category_name);
3152: x_return_text := FND_MESSAGE.GET;
3153: END;
3154: END IF;
3155: ELSIF (p_limit_products_by_code = 'ALL_ITEMS') THEN

Line 3152: x_return_text := FND_MESSAGE.GET;

3148: x_prod_attr_value := 'CATEGORY_LOOKUP_FAILED';
3149: x_return_status := FND_API.G_RET_STS_ERROR;
3150: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CATEGORY_MULTI_FOUND');
3151: FND_MESSAGE.SET_TOKEN('CATEGORY_NAME', p_item_category_name);
3152: x_return_text := FND_MESSAGE.GET;
3153: END;
3154: END IF;
3155: ELSIF (p_limit_products_by_code = 'ALL_ITEMS') THEN
3156: x_prod_attr_value := 'ALL';

Line 3167: FND_MESSAGE.SET_NAME('QP', 'QP_XML_PRICELIST_NOT_FOUND');

3163: ELSIF (p_price_list_name is not null) THEN
3164: x_pl_agr_bsa_id := GET_PRICE_LIST_ID(p_price_list_name);
3165: IF x_pl_agr_bsa_id is null THEN
3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: FND_MESSAGE.SET_NAME('QP', 'QP_XML_PRICELIST_NOT_FOUND');
3168: FND_MESSAGE.SET_TOKEN('PRICELIST_NAME', p_price_list_name);
3169: x_return_text := FND_MESSAGE.GET;
3170: END IF;
3171: x_pl_agr_bsa_name := p_price_list_name;

Line 3168: FND_MESSAGE.SET_TOKEN('PRICELIST_NAME', p_price_list_name);

3164: x_pl_agr_bsa_id := GET_PRICE_LIST_ID(p_price_list_name);
3165: IF x_pl_agr_bsa_id is null THEN
3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: FND_MESSAGE.SET_NAME('QP', 'QP_XML_PRICELIST_NOT_FOUND');
3168: FND_MESSAGE.SET_TOKEN('PRICELIST_NAME', p_price_list_name);
3169: x_return_text := FND_MESSAGE.GET;
3170: END IF;
3171: x_pl_agr_bsa_name := p_price_list_name;
3172: END IF;

Line 3169: x_return_text := FND_MESSAGE.GET;

3165: IF x_pl_agr_bsa_id is null THEN
3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: FND_MESSAGE.SET_NAME('QP', 'QP_XML_PRICELIST_NOT_FOUND');
3168: FND_MESSAGE.SET_TOKEN('PRICELIST_NAME', p_price_list_name);
3169: x_return_text := FND_MESSAGE.GET;
3170: END IF;
3171: x_pl_agr_bsa_name := p_price_list_name;
3172: END IF;
3173: ELSIF (p_price_based_on_code = 'AGREEMENT') THEN

Line 3180: FND_MESSAGE.SET_NAME('QP', 'QP_XML_AGREEMENT_NOT_FOUND');

3176: ELSIF (p_agreement_name is not null) THEN
3177: x_pl_agr_bsa_id := GET_AGREEMENT_ID(p_agreement_name, p_pricing_effective_date);
3178: IF x_pl_agr_bsa_id is null THEN
3179: x_return_status := FND_API.G_RET_STS_ERROR;
3180: FND_MESSAGE.SET_NAME('QP', 'QP_XML_AGREEMENT_NOT_FOUND');
3181: FND_MESSAGE.SET_TOKEN('AGREEMENT_NAME', p_agreement_name);
3182: FND_MESSAGE.SET_TOKEN('EFFECTIVE_DATE', p_pricing_effective_date);
3183: x_return_text := FND_MESSAGE.GET;
3184: END IF;

Line 3181: FND_MESSAGE.SET_TOKEN('AGREEMENT_NAME', p_agreement_name);

3177: x_pl_agr_bsa_id := GET_AGREEMENT_ID(p_agreement_name, p_pricing_effective_date);
3178: IF x_pl_agr_bsa_id is null THEN
3179: x_return_status := FND_API.G_RET_STS_ERROR;
3180: FND_MESSAGE.SET_NAME('QP', 'QP_XML_AGREEMENT_NOT_FOUND');
3181: FND_MESSAGE.SET_TOKEN('AGREEMENT_NAME', p_agreement_name);
3182: FND_MESSAGE.SET_TOKEN('EFFECTIVE_DATE', p_pricing_effective_date);
3183: x_return_text := FND_MESSAGE.GET;
3184: END IF;
3185: x_pl_agr_bsa_name := p_agreement_name;

Line 3182: FND_MESSAGE.SET_TOKEN('EFFECTIVE_DATE', p_pricing_effective_date);

3178: IF x_pl_agr_bsa_id is null THEN
3179: x_return_status := FND_API.G_RET_STS_ERROR;
3180: FND_MESSAGE.SET_NAME('QP', 'QP_XML_AGREEMENT_NOT_FOUND');
3181: FND_MESSAGE.SET_TOKEN('AGREEMENT_NAME', p_agreement_name);
3182: FND_MESSAGE.SET_TOKEN('EFFECTIVE_DATE', p_pricing_effective_date);
3183: x_return_text := FND_MESSAGE.GET;
3184: END IF;
3185: x_pl_agr_bsa_name := p_agreement_name;
3186: END IF;

Line 3183: x_return_text := FND_MESSAGE.GET;

3179: x_return_status := FND_API.G_RET_STS_ERROR;
3180: FND_MESSAGE.SET_NAME('QP', 'QP_XML_AGREEMENT_NOT_FOUND');
3181: FND_MESSAGE.SET_TOKEN('AGREEMENT_NAME', p_agreement_name);
3182: FND_MESSAGE.SET_TOKEN('EFFECTIVE_DATE', p_pricing_effective_date);
3183: x_return_text := FND_MESSAGE.GET;
3184: END IF;
3185: x_pl_agr_bsa_name := p_agreement_name;
3186: END IF;
3187: ELSIF (p_price_based_on_code = 'BSA') THEN

Line 3194: FND_MESSAGE.SET_NAME('QP', 'QP_XML_BSA_NOT_FOUND');

3190: ELSIF (p_bsa_name is not null) THEN
3191: x_pl_agr_bsa_id := GET_BSA_ID(p_bsa_name);
3192: IF x_pl_agr_bsa_id is null THEN
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: FND_MESSAGE.SET_NAME('QP', 'QP_XML_BSA_NOT_FOUND');
3195: FND_MESSAGE.SET_TOKEN('BSA_NAME', p_bsa_name);
3196: x_return_text := FND_MESSAGE.GET;
3197: END IF;
3198: x_pl_agr_bsa_name := p_bsa_name;

Line 3195: FND_MESSAGE.SET_TOKEN('BSA_NAME', p_bsa_name);

3191: x_pl_agr_bsa_id := GET_BSA_ID(p_bsa_name);
3192: IF x_pl_agr_bsa_id is null THEN
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: FND_MESSAGE.SET_NAME('QP', 'QP_XML_BSA_NOT_FOUND');
3195: FND_MESSAGE.SET_TOKEN('BSA_NAME', p_bsa_name);
3196: x_return_text := FND_MESSAGE.GET;
3197: END IF;
3198: x_pl_agr_bsa_name := p_bsa_name;
3199: END IF;

Line 3196: x_return_text := FND_MESSAGE.GET;

3192: IF x_pl_agr_bsa_id is null THEN
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: FND_MESSAGE.SET_NAME('QP', 'QP_XML_BSA_NOT_FOUND');
3195: FND_MESSAGE.SET_TOKEN('BSA_NAME', p_bsa_name);
3196: x_return_text := FND_MESSAGE.GET;
3197: END IF;
3198: x_pl_agr_bsa_name := p_bsa_name;
3199: END IF;
3200: END IF;

Line 3223: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_NOT_FOUND');

3219: EXCEPTION
3220: WHEN NO_DATA_FOUND THEN
3221: x_context_code := null;
3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_NOT_FOUND');
3224: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);
3225: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3226: x_return_text := FND_MESSAGE.GET;
3227: WHEN TOO_MANY_ROWS THEN

Line 3224: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);

3220: WHEN NO_DATA_FOUND THEN
3221: x_context_code := null;
3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_NOT_FOUND');
3224: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);
3225: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3226: x_return_text := FND_MESSAGE.GET;
3227: WHEN TOO_MANY_ROWS THEN
3228: x_context_code := null;

Line 3225: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);

3221: x_context_code := null;
3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_NOT_FOUND');
3224: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);
3225: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3226: x_return_text := FND_MESSAGE.GET;
3227: WHEN TOO_MANY_ROWS THEN
3228: x_context_code := null;
3229: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3226: x_return_text := FND_MESSAGE.GET;

3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_NOT_FOUND');
3224: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);
3225: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3226: x_return_text := FND_MESSAGE.GET;
3227: WHEN TOO_MANY_ROWS THEN
3228: x_context_code := null;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_MULTI_FOUND');

Line 3230: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_MULTI_FOUND');

3226: x_return_text := FND_MESSAGE.GET;
3227: WHEN TOO_MANY_ROWS THEN
3228: x_context_code := null;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_MULTI_FOUND');
3231: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);
3232: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3233: x_return_text := FND_MESSAGE.GET;
3234: END GET_CONTEXT_CODE;

Line 3231: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);

3227: WHEN TOO_MANY_ROWS THEN
3228: x_context_code := null;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_MULTI_FOUND');
3231: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);
3232: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3233: x_return_text := FND_MESSAGE.GET;
3234: END GET_CONTEXT_CODE;
3235:

Line 3232: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);

3228: x_context_code := null;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_MULTI_FOUND');
3231: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);
3232: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3233: x_return_text := FND_MESSAGE.GET;
3234: END GET_CONTEXT_CODE;
3235:
3236: PROCEDURE GET_ATTRIBUTE_CODE

Line 3233: x_return_text := FND_MESSAGE.GET;

3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230: FND_MESSAGE.SET_NAME('QP', 'QP_XML_CONTEXT_MULTI_FOUND');
3231: FND_MESSAGE.SET_TOKEN('CONTEXT_NAME', p_context_name);
3232: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3233: x_return_text := FND_MESSAGE.GET;
3234: END GET_CONTEXT_CODE;
3235:
3236: PROCEDURE GET_ATTRIBUTE_CODE
3237: (

Line 3260: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_NOT_FOUND');

3256: EXCEPTION
3257: WHEN NO_DATA_FOUND THEN
3258: x_attribute_code := null;
3259: x_return_status := FND_API.G_RET_STS_ERROR;
3260: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_NOT_FOUND');
3261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3262: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3263: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3264: x_return_text := FND_MESSAGE.GET;

Line 3261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);

3257: WHEN NO_DATA_FOUND THEN
3258: x_attribute_code := null;
3259: x_return_status := FND_API.G_RET_STS_ERROR;
3260: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_NOT_FOUND');
3261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3262: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3263: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3264: x_return_text := FND_MESSAGE.GET;
3265: WHEN TOO_MANY_ROWS THEN

Line 3262: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);

3258: x_attribute_code := null;
3259: x_return_status := FND_API.G_RET_STS_ERROR;
3260: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_NOT_FOUND');
3261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3262: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3263: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3264: x_return_text := FND_MESSAGE.GET;
3265: WHEN TOO_MANY_ROWS THEN
3266: x_attribute_code := null;

Line 3263: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);

3259: x_return_status := FND_API.G_RET_STS_ERROR;
3260: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_NOT_FOUND');
3261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3262: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3263: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3264: x_return_text := FND_MESSAGE.GET;
3265: WHEN TOO_MANY_ROWS THEN
3266: x_attribute_code := null;
3267: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3264: x_return_text := FND_MESSAGE.GET;

3260: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_NOT_FOUND');
3261: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3262: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3263: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3264: x_return_text := FND_MESSAGE.GET;
3265: WHEN TOO_MANY_ROWS THEN
3266: x_attribute_code := null;
3267: x_return_status := FND_API.G_RET_STS_ERROR;
3268: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_MULTI_FOUND');

Line 3268: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_MULTI_FOUND');

3264: x_return_text := FND_MESSAGE.GET;
3265: WHEN TOO_MANY_ROWS THEN
3266: x_attribute_code := null;
3267: x_return_status := FND_API.G_RET_STS_ERROR;
3268: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_MULTI_FOUND');
3269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3270: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3271: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3272: x_return_text := FND_MESSAGE.GET;

Line 3269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);

3265: WHEN TOO_MANY_ROWS THEN
3266: x_attribute_code := null;
3267: x_return_status := FND_API.G_RET_STS_ERROR;
3268: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_MULTI_FOUND');
3269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3270: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3271: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3272: x_return_text := FND_MESSAGE.GET;
3273: END GET_ATTRIBUTE_CODE;

Line 3270: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);

3266: x_attribute_code := null;
3267: x_return_status := FND_API.G_RET_STS_ERROR;
3268: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_MULTI_FOUND');
3269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3270: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3271: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3272: x_return_text := FND_MESSAGE.GET;
3273: END GET_ATTRIBUTE_CODE;
3274:

Line 3271: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);

3267: x_return_status := FND_API.G_RET_STS_ERROR;
3268: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_MULTI_FOUND');
3269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3270: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3271: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3272: x_return_text := FND_MESSAGE.GET;
3273: END GET_ATTRIBUTE_CODE;
3274:
3275: PROCEDURE GET_ATTRIBUTE_VALUE_CODE

Line 3272: x_return_text := FND_MESSAGE.GET;

3268: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTRIBUTE_MULTI_FOUND');
3269: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', p_attribute_name);
3270: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3271: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3272: x_return_text := FND_MESSAGE.GET;
3273: END GET_ATTRIBUTE_CODE;
3274:
3275: PROCEDURE GET_ATTRIBUTE_VALUE_CODE
3276: (

Line 3369: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_NOT_FOUND');

3365: EXCEPTION
3366: WHEN NO_DATA_FOUND THEN
3367: x_attribute_value_code := null;
3368: x_return_status := FND_API.G_RET_STS_ERROR;
3369: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_NOT_FOUND');
3370: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3372: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3373: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);

Line 3370: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);

3366: WHEN NO_DATA_FOUND THEN
3367: x_attribute_value_code := null;
3368: x_return_status := FND_API.G_RET_STS_ERROR;
3369: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_NOT_FOUND');
3370: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3372: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3373: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3374: x_return_text := FND_MESSAGE.GET;

Line 3371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);

3367: x_attribute_value_code := null;
3368: x_return_status := FND_API.G_RET_STS_ERROR;
3369: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_NOT_FOUND');
3370: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3372: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3373: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3374: x_return_text := FND_MESSAGE.GET;
3375: WHEN TOO_MANY_ROWS THEN

Line 3372: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);

3368: x_return_status := FND_API.G_RET_STS_ERROR;
3369: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_NOT_FOUND');
3370: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3372: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3373: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3374: x_return_text := FND_MESSAGE.GET;
3375: WHEN TOO_MANY_ROWS THEN
3376: x_attribute_value_code := null;

Line 3373: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);

3369: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_NOT_FOUND');
3370: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3372: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3373: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3374: x_return_text := FND_MESSAGE.GET;
3375: WHEN TOO_MANY_ROWS THEN
3376: x_attribute_value_code := null;
3377: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3374: x_return_text := FND_MESSAGE.GET;

3370: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3371: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3372: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3373: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3374: x_return_text := FND_MESSAGE.GET;
3375: WHEN TOO_MANY_ROWS THEN
3376: x_attribute_value_code := null;
3377: x_return_status := FND_API.G_RET_STS_ERROR;
3378: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_MULTI_FOUND');

Line 3378: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_MULTI_FOUND');

3374: x_return_text := FND_MESSAGE.GET;
3375: WHEN TOO_MANY_ROWS THEN
3376: x_attribute_value_code := null;
3377: x_return_status := FND_API.G_RET_STS_ERROR;
3378: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_MULTI_FOUND');
3379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3381: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3382: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);

Line 3379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);

3375: WHEN TOO_MANY_ROWS THEN
3376: x_attribute_value_code := null;
3377: x_return_status := FND_API.G_RET_STS_ERROR;
3378: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_MULTI_FOUND');
3379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3381: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3382: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3383: x_return_text := FND_MESSAGE.GET;

Line 3380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);

3376: x_attribute_value_code := null;
3377: x_return_status := FND_API.G_RET_STS_ERROR;
3378: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_MULTI_FOUND');
3379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3381: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3382: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3383: x_return_text := FND_MESSAGE.GET;
3384: END GET_ATTRIBUTE_VALUE_CODE;

Line 3381: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);

3377: x_return_status := FND_API.G_RET_STS_ERROR;
3378: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_MULTI_FOUND');
3379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3381: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3382: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3383: x_return_text := FND_MESSAGE.GET;
3384: END GET_ATTRIBUTE_VALUE_CODE;
3385:

Line 3382: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);

3378: FND_MESSAGE.SET_NAME('QP', 'QP_XML_ATTR_VALUE_MULTI_FOUND');
3379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3381: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3382: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3383: x_return_text := FND_MESSAGE.GET;
3384: END GET_ATTRIBUTE_VALUE_CODE;
3385:
3386: PROCEDURE PUBLISH_AND_DELIVER_CP

Line 3383: x_return_text := FND_MESSAGE.GET;

3379: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE_NAME', p_attribute_value_name);
3380: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_CODE', p_attribute_code);
3381: FND_MESSAGE.SET_TOKEN('CONTEXT_TYPE', p_attribute_type);
3382: FND_MESSAGE.SET_TOKEN('CONTEXT_CODE', p_context_code);
3383: x_return_text := FND_MESSAGE.GET;
3384: END GET_ATTRIBUTE_VALUE_CODE;
3385:
3386: PROCEDURE PUBLISH_AND_DELIVER_CP
3387: (

Line 4114: FND_MESSAGE.SET_NAME('QP', 'QP_XML_RESPONSIBILITY_REQUIRED');

4110:
4111: EXCEPTION
4112: WHEN NO_DATA_FOUND THEN
4113: x_return_status := FND_API.G_RET_STS_ERROR;
4114: FND_MESSAGE.SET_NAME('QP', 'QP_XML_RESPONSIBILITY_REQUIRED');
4115: x_return_text := FND_MESSAGE.GET;
4116: END;
4117:
4118: PROCEDURE CATGI_UPDATE_PUBLISH_OPTIONS

Line 4115: x_return_text := FND_MESSAGE.GET;

4111: EXCEPTION
4112: WHEN NO_DATA_FOUND THEN
4113: x_return_status := FND_API.G_RET_STS_ERROR;
4114: FND_MESSAGE.SET_NAME('QP', 'QP_XML_RESPONSIBILITY_REQUIRED');
4115: x_return_text := FND_MESSAGE.GET;
4116: END;
4117:
4118: PROCEDURE CATGI_UPDATE_PUBLISH_OPTIONS
4119: (

Line 4230: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');

4226: AND price_book_type_code = 'F';
4227: EXCEPTION
4228: WHEN OTHERS THEN
4229: x_return_status := FND_API.G_RET_STS_ERROR;
4230: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');
4231: x_return_text := FND_MESSAGE.GET;
4232: RETURN;
4233: END;
4234:

Line 4231: x_return_text := FND_MESSAGE.GET;

4227: EXCEPTION
4228: WHEN OTHERS THEN
4229: x_return_status := FND_API.G_RET_STS_ERROR;
4230: FND_MESSAGE.SET_NAME('QP', 'QP_FULL_PRICE_BOOK_MUST_EXIST');
4231: x_return_text := FND_MESSAGE.GET;
4232: RETURN;
4233: END;
4234:
4235: UPDATE qp_pb_input_headers_b

Line 4561: decode(LD.LIST_LINE_NO, null, fnd_message.get_string(''QP'',''QP_PRICE_BOOK_LISTPRICE''), fnd_message.get_string(''QP'',''QP_PRICE_BOOK_ADDITIONAL''))

4557: pbk.COMPARISON_OPERATOR_NAME "ComparisonOperatorName",
4558: pbk.ATTRIBUTE_NAME "AttributeName",
4559: pbk.PRICING_ATTR_VALUE_FROM "PricingAttrValueFrom",
4560: pbk.PRICING_ATTR_VALUE_TO "PricingAttrValueTo",
4561: decode(LD.LIST_LINE_NO, null, fnd_message.get_string(''QP'',''QP_PRICE_BOOK_LISTPRICE''), fnd_message.get_string(''QP'',''QP_PRICE_BOOK_ADDITIONAL''))
4562: ||'' ''
4563: ||pbk.ATTRIBUTE_NAME
4564: ||'' ''
4565: ||decode(pbk.PRICING_ATTR_VALUE_TO,

Line 4566: 999999999999999,fnd_message.get_string(''QP'',''QP_PRICE_BOOK_PBH_GREATER'')||'' ''||pbk.PRICING_ATTR_VALUE_FROM,

4562: ||'' ''
4563: ||pbk.ATTRIBUTE_NAME
4564: ||'' ''
4565: ||decode(pbk.PRICING_ATTR_VALUE_TO,
4566: 999999999999999,fnd_message.get_string(''QP'',''QP_PRICE_BOOK_PBH_GREATER'')||'' ''||pbk.PRICING_ATTR_VALUE_FROM,
4567: decode(pll.continuous_price_break_flag,
4568: ''Y'', fnd_message.get_string(''QP'',''QP_PRICE_BOOK_COMPARISON''),
4569: pbk.COMPARISON_OPERATOR_NAME)||'' ''|| pbk.PRICING_ATTR_VALUE_FROM||'' ''
4570: || decode(pll.continuous_price_break_flag, ''Y'',

Line 4568: ''Y'', fnd_message.get_string(''QP'',''QP_PRICE_BOOK_COMPARISON''),

4564: ||'' ''
4565: ||decode(pbk.PRICING_ATTR_VALUE_TO,
4566: 999999999999999,fnd_message.get_string(''QP'',''QP_PRICE_BOOK_PBH_GREATER'')||'' ''||pbk.PRICING_ATTR_VALUE_FROM,
4567: decode(pll.continuous_price_break_flag,
4568: ''Y'', fnd_message.get_string(''QP'',''QP_PRICE_BOOK_COMPARISON''),
4569: pbk.COMPARISON_OPERATOR_NAME)||'' ''|| pbk.PRICING_ATTR_VALUE_FROM||'' ''
4570: || decode(pll.continuous_price_break_flag, ''Y'',
4571: fnd_message.get_string(''QP'',''QP_PRICE_BOOK_MORE''),fnd_message.get_string(''QP'',''QP_PRICE_BOOK_AND''))||'' ''|| pbk.PRICING_ATTR_VALUE_TO
4572: ) "Description",

Line 4571: fnd_message.get_string(''QP'',''QP_PRICE_BOOK_MORE''),fnd_message.get_string(''QP'',''QP_PRICE_BOOK_AND''))||'' ''|| pbk.PRICING_ATTR_VALUE_TO

4567: decode(pll.continuous_price_break_flag,
4568: ''Y'', fnd_message.get_string(''QP'',''QP_PRICE_BOOK_COMPARISON''),
4569: pbk.COMPARISON_OPERATOR_NAME)||'' ''|| pbk.PRICING_ATTR_VALUE_FROM||'' ''
4570: || decode(pll.continuous_price_break_flag, ''Y'',
4571: fnd_message.get_string(''QP'',''QP_PRICE_BOOK_MORE''),fnd_message.get_string(''QP'',''QP_PRICE_BOOK_AND''))||'' ''|| pbk.PRICING_ATTR_VALUE_TO
4572: ) "Description",
4573: LD.LIST_LINE_NO "ModifierNumber",
4574: pbk.OPERAND "Operand",
4575: pbk.APPLICATION_METHOD_NAME "ApplicationMethodName",