eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_VALIDATE_PRICE_LIST_LINE dependencies on QP_VALIDATE

Line 1: PACKAGE BODY QP_Validate_Price_List_Line AS

1: PACKAGE BODY QP_Validate_Price_List_Line AS
2: /* $Header: QPXLPLLB.pls 120.5.12010000.2 2009/11/30 04:02:48 jputta ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Price_List_Line';

2: /* $Header: QPXLPLLB.pls 120.5.12010000.2 2009/11/30 04:02:48 jputta ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Validate_Price_List_Line';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 172: IF NOT QP_Validate.Start_Date_Active(p_PRICE_LIST_LINE_rec.start_date_active, p_PRICE_LIST_LINE_rec.end_date_active) THEN

168: */
169: --
170: -- Validate attribute dependencies here.
171: --
172: IF NOT QP_Validate.Start_Date_Active(p_PRICE_LIST_LINE_rec.start_date_active, p_PRICE_LIST_LINE_rec.end_date_active) THEN
173:
174: l_return_status := FND_API.G_RET_STS_ERROR;
175:
176: /*

Line 276: IF NOT QP_Validate.Recurring_Value(p_PRICE_LIST_LINE_rec.recurring_value)

272: -- end of changes for ER # 6111123
273: END IF;
274:
275: -- block pricing
276: IF NOT QP_Validate.Recurring_Value(p_PRICE_LIST_LINE_rec.recurring_value)
277: THEN
278: l_return_status := FND_API.G_RET_STS_ERROR;
279:
280: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

Line 408: IF NOT QP_Validate.Accrual_Qty(p_PRICE_LIST_LINE_rec.accrual_qty) THEN

404: ( p_PRICE_LIST_LINE_rec.accrual_qty <>
405: p_old_PRICE_LIST_LINE_rec.accrual_qty OR
406: p_old_PRICE_LIST_LINE_rec.accrual_qty IS NULL )
407: THEN
408: IF NOT QP_Validate.Accrual_Qty(p_PRICE_LIST_LINE_rec.accrual_qty) THEN
409: x_return_status := FND_API.G_RET_STS_ERROR;
410: END IF;
411: END IF;
412:

Line 419: IF NOT QP_Validate.Accrual_Uom(p_PRICE_LIST_LINE_rec.accrual_uom_code) THEN

415: ( p_PRICE_LIST_LINE_rec.accrual_uom_code <>
416: p_old_PRICE_LIST_LINE_rec.accrual_uom_code OR
417: p_old_PRICE_LIST_LINE_rec.accrual_uom_code IS NULL )
418: THEN
419: IF NOT QP_Validate.Accrual_Uom(p_PRICE_LIST_LINE_rec.accrual_uom_code) THEN
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422: END IF;
423:

Line 441: IF NOT QP_Validate.Arithmetic_Operator(p_PRICE_LIST_LINE_rec.arithmetic_operator) THEN

437: ( p_PRICE_LIST_LINE_rec.arithmetic_operator <>
438: p_old_PRICE_LIST_LINE_rec.arithmetic_operator OR
439: p_old_PRICE_LIST_LINE_rec.arithmetic_operator IS NULL )
440: THEN
441: IF NOT QP_Validate.Arithmetic_Operator(p_PRICE_LIST_LINE_rec.arithmetic_operator) THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: END IF;
444:
445: END IF;

Line 452: IF NOT QP_Validate.Automatic(p_PRICE_LIST_LINE_rec.automatic_flag) THEN

448: ( p_PRICE_LIST_LINE_rec.automatic_flag <>
449: p_old_PRICE_LIST_LINE_rec.automatic_flag OR
450: p_old_PRICE_LIST_LINE_rec.automatic_flag IS NULL )
451: THEN
452: IF NOT QP_Validate.Automatic(p_PRICE_LIST_LINE_rec.automatic_flag) THEN
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: END IF;
455: END IF;
456:

Line 465: IF NOT QP_Validate.Base_Qty(p_PRICE_LIST_LINE_rec.base_qty) THEN

461: ( p_PRICE_LIST_LINE_rec.base_qty <>
462: p_old_PRICE_LIST_LINE_rec.base_qty OR
463: p_old_PRICE_LIST_LINE_rec.base_qty IS NULL )
464: THEN
465: IF NOT QP_Validate.Base_Qty(p_PRICE_LIST_LINE_rec.base_qty) THEN
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: END IF;
468: END IF;
469: */

Line 477: IF NOT QP_Validate.Base_Uom(p_PRICE_LIST_LINE_rec.base_uom_code) THEN

473: ( p_PRICE_LIST_LINE_rec.base_uom_code <>
474: p_old_PRICE_LIST_LINE_rec.base_uom_code OR
475: p_old_PRICE_LIST_LINE_rec.base_uom_code IS NULL )
476: THEN
477: IF NOT QP_Validate.Base_Uom(p_PRICE_LIST_LINE_rec.base_uom_code) THEN
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: END IF;
480: END IF;
481: */

Line 488: IF NOT QP_Validate.Comments(p_PRICE_LIST_LINE_rec.comments) THEN

484: ( p_PRICE_LIST_LINE_rec.comments <>
485: p_old_PRICE_LIST_LINE_rec.comments OR
486: p_old_PRICE_LIST_LINE_rec.comments IS NULL )
487: THEN
488: IF NOT QP_Validate.Comments(p_PRICE_LIST_LINE_rec.comments) THEN
489: x_return_status := FND_API.G_RET_STS_ERROR;
490: END IF;
491: END IF;
492:

Line 498: IF NOT QP_Validate.Created_By(p_PRICE_LIST_LINE_rec.created_by) THEN

494: ( p_PRICE_LIST_LINE_rec.created_by <>
495: p_old_PRICE_LIST_LINE_rec.created_by OR
496: p_old_PRICE_LIST_LINE_rec.created_by IS NULL )
497: THEN
498: IF NOT QP_Validate.Created_By(p_PRICE_LIST_LINE_rec.created_by) THEN
499: x_return_status := FND_API.G_RET_STS_ERROR;
500: END IF;
501: END IF;
502:

Line 508: IF NOT QP_Validate.Creation_Date(p_PRICE_LIST_LINE_rec.creation_date) THEN

504: ( p_PRICE_LIST_LINE_rec.creation_date <>
505: p_old_PRICE_LIST_LINE_rec.creation_date OR
506: p_old_PRICE_LIST_LINE_rec.creation_date IS NULL )
507: THEN
508: IF NOT QP_Validate.Creation_Date(p_PRICE_LIST_LINE_rec.creation_date) THEN
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: END IF;
511: END IF;
512:

Line 518: IF NOT QP_Validate.Effective_Period_Uom(p_PRICE_LIST_LINE_rec.effective_period_uom) THEN

514: ( p_PRICE_LIST_LINE_rec.effective_period_uom <>
515: p_old_PRICE_LIST_LINE_rec.effective_period_uom OR
516: p_old_PRICE_LIST_LINE_rec.effective_period_uom IS NULL )
517: THEN
518: IF NOT QP_Validate.Effective_Period_Uom(p_PRICE_LIST_LINE_rec.effective_period_uom) THEN
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: END IF;
521: END IF;
522:

Line 528: IF NOT QP_Validate.End_Date_Active(p_PRICE_LIST_LINE_rec.end_date_active, p_PRICE_LIST_LINE_rec.start_date_active) THEN

524: ( p_PRICE_LIST_LINE_rec.end_date_active <>
525: p_old_PRICE_LIST_LINE_rec.end_date_active OR
526: p_old_PRICE_LIST_LINE_rec.end_date_active IS NULL )
527: THEN
528: IF NOT QP_Validate.End_Date_Active(p_PRICE_LIST_LINE_rec.end_date_active, p_PRICE_LIST_LINE_rec.start_date_active) THEN
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: END IF;
531: END IF;
532:

Line 538: IF NOT QP_Validate.Estim_Accrual_Rate(p_PRICE_LIST_LINE_rec.estim_accrual_rate) THEN

534: ( p_PRICE_LIST_LINE_rec.estim_accrual_rate <>
535: p_old_PRICE_LIST_LINE_rec.estim_accrual_rate OR
536: p_old_PRICE_LIST_LINE_rec.estim_accrual_rate IS NULL )
537: THEN
538: IF NOT QP_Validate.Estim_Accrual_Rate(p_PRICE_LIST_LINE_rec.estim_accrual_rate) THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: END IF;
541: END IF;
542:

Line 548: IF NOT QP_Validate.Generate_Using_Formula(p_PRICE_LIST_LINE_rec.generate_using_formula_id) THEN

544: ( p_PRICE_LIST_LINE_rec.generate_using_formula_id <>
545: p_old_PRICE_LIST_LINE_rec.generate_using_formula_id OR
546: p_old_PRICE_LIST_LINE_rec.generate_using_formula_id IS NULL )
547: THEN
548: IF NOT QP_Validate.Generate_Using_Formula(p_PRICE_LIST_LINE_rec.generate_using_formula_id) THEN
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END IF;
551: END IF;
552:

Line 558: IF NOT QP_Validate.Inventory_Item(p_PRICE_LIST_LINE_rec.inventory_item_id) THEN

554: ( p_PRICE_LIST_LINE_rec.inventory_item_id <>
555: p_old_PRICE_LIST_LINE_rec.inventory_item_id OR
556: p_old_PRICE_LIST_LINE_rec.inventory_item_id IS NULL )
557: THEN
558: IF NOT QP_Validate.Inventory_Item(p_PRICE_LIST_LINE_rec.inventory_item_id) THEN
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: END IF;
561: END IF;
562:

Line 568: IF NOT QP_Validate.Last_Updated_By(p_PRICE_LIST_LINE_rec.last_updated_by) THEN

564: ( p_PRICE_LIST_LINE_rec.last_updated_by <>
565: p_old_PRICE_LIST_LINE_rec.last_updated_by OR
566: p_old_PRICE_LIST_LINE_rec.last_updated_by IS NULL )
567: THEN
568: IF NOT QP_Validate.Last_Updated_By(p_PRICE_LIST_LINE_rec.last_updated_by) THEN
569: x_return_status := FND_API.G_RET_STS_ERROR;
570: END IF;
571: END IF;
572:

Line 578: IF NOT QP_Validate.Last_Update_Date(p_PRICE_LIST_LINE_rec.last_update_date) THEN

574: ( p_PRICE_LIST_LINE_rec.last_update_date <>
575: p_old_PRICE_LIST_LINE_rec.last_update_date OR
576: p_old_PRICE_LIST_LINE_rec.last_update_date IS NULL )
577: THEN
578: IF NOT QP_Validate.Last_Update_Date(p_PRICE_LIST_LINE_rec.last_update_date) THEN
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: END IF;
581: END IF;
582:

Line 588: IF NOT QP_Validate.Last_Update_Login(p_PRICE_LIST_LINE_rec.last_update_login) THEN

584: ( p_PRICE_LIST_LINE_rec.last_update_login <>
585: p_old_PRICE_LIST_LINE_rec.last_update_login OR
586: p_old_PRICE_LIST_LINE_rec.last_update_login IS NULL )
587: THEN
588: IF NOT QP_Validate.Last_Update_Login(p_PRICE_LIST_LINE_rec.last_update_login) THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: END IF;
591: END IF;
592:

Line 598: IF NOT QP_Validate.List_Header(p_PRICE_LIST_LINE_rec.list_header_id) THEN

594: ( p_PRICE_LIST_LINE_rec.list_header_id <>
595: p_old_PRICE_LIST_LINE_rec.list_header_id OR
596: p_old_PRICE_LIST_LINE_rec.list_header_id IS NULL )
597: THEN
598: IF NOT QP_Validate.List_Header(p_PRICE_LIST_LINE_rec.list_header_id) THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: END IF;
601: END IF;
602:

Line 608: IF NOT QP_Validate.List_Line(p_PRICE_LIST_LINE_rec.list_line_id) THEN

604: ( p_PRICE_LIST_LINE_rec.list_line_id <>
605: p_old_PRICE_LIST_LINE_rec.list_line_id OR
606: p_old_PRICE_LIST_LINE_rec.list_line_id IS NULL )
607: THEN
608: IF NOT QP_Validate.List_Line(p_PRICE_LIST_LINE_rec.list_line_id) THEN
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: END IF;
611: END IF;
612:

Line 618: IF NOT QP_Validate.List_Line_Type(p_PRICE_LIST_LINE_rec.list_line_type_code) THEN

614: ( p_PRICE_LIST_LINE_rec.list_line_type_code <>
615: p_old_PRICE_LIST_LINE_rec.list_line_type_code OR
616: p_old_PRICE_LIST_LINE_rec.list_line_type_code IS NULL )
617: THEN
618: IF NOT QP_Validate.List_Line_Type(p_PRICE_LIST_LINE_rec.list_line_type_code) THEN
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: END IF;
621: END IF;
622:

Line 628: IF NOT QP_Validate.List_Price(p_PRICE_LIST_LINE_rec.list_price) THEN

624: ( p_PRICE_LIST_LINE_rec.list_price <>
625: p_old_PRICE_LIST_LINE_rec.list_price OR
626: p_old_PRICE_LIST_LINE_rec.list_price IS NULL )
627: THEN
628: IF NOT QP_Validate.List_Price(p_PRICE_LIST_LINE_rec.list_price) THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: END IF;
631: END IF;
632:

Line 639: IF NOT QP_Validate.From_Rltd_Modifier_Id(p_PRICE_LIST_LINE_rec.from_rltd_modifier_id) THEN

635: p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id OR
636: p_old_PRICE_LIST_LINE_rec.from_rltd_modifier_id IS NULL )
637: THEN
638: /*
639: IF NOT QP_Validate.From_Rltd_Modifier_Id(p_PRICE_LIST_LINE_rec.from_rltd_modifier_id) THEN
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: END IF;
642: */
643: NULL;

Line 653: IF NOT QP_Validate.Rltd_Modifier_Group_No(p_PRICE_LIST_LINE_rec.rltd_modifier_group_no) THEN

649: p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no OR
650: p_old_PRICE_LIST_LINE_rec.rltd_modifier_group_no IS NULL )
651: THEN
652: /*
653: IF NOT QP_Validate.Rltd_Modifier_Group_No(p_PRICE_LIST_LINE_rec.rltd_modifier_group_no) THEN
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: END IF;
656: */
657:

Line 668: IF NOT QP_Validate.Product_Precedence(p_PRICE_LIST_LINE_rec.product_precedence) THEN

664: p_old_PRICE_LIST_LINE_rec.product_precedence OR
665: p_old_PRICE_LIST_LINE_rec.product_precedence IS NULL )
666: THEN
667: /*
668: IF NOT QP_Validate.Product_Precedence(p_PRICE_LIST_LINE_rec.product_precedence) THEN
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: END IF;
671: */
672: NULL;

Line 680: IF NOT QP_Validate.Modifier_Level(p_PRICE_LIST_LINE_rec.modifier_level_code) THEN

676: ( p_PRICE_LIST_LINE_rec.modifier_level_code <>
677: p_old_PRICE_LIST_LINE_rec.modifier_level_code OR
678: p_old_PRICE_LIST_LINE_rec.modifier_level_code IS NULL )
679: THEN
680: IF NOT QP_Validate.Modifier_Level(p_PRICE_LIST_LINE_rec.modifier_level_code) THEN
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: END IF;
683: END IF;
684:

Line 690: IF NOT QP_Validate.Number_Effective_Periods(p_PRICE_LIST_LINE_rec.number_effective_periods) THEN

686: ( p_PRICE_LIST_LINE_rec.number_effective_periods <>
687: p_old_PRICE_LIST_LINE_rec.number_effective_periods OR
688: p_old_PRICE_LIST_LINE_rec.number_effective_periods IS NULL )
689: THEN
690: IF NOT QP_Validate.Number_Effective_Periods(p_PRICE_LIST_LINE_rec.number_effective_periods) THEN
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: END IF;
693: END IF;
694:

Line 700: IF NOT QP_Validate.Operand(p_PRICE_LIST_LINE_rec.operand) THEN

696: ( p_PRICE_LIST_LINE_rec.operand <>
697: p_old_PRICE_LIST_LINE_rec.operand OR
698: p_old_PRICE_LIST_LINE_rec.operand IS NULL )
699: THEN
700: IF NOT QP_Validate.Operand(p_PRICE_LIST_LINE_rec.operand) THEN
701: x_return_status := FND_API.G_RET_STS_ERROR;
702: END IF;
703: END IF;
704:

Line 710: IF NOT QP_Validate.Organization(p_PRICE_LIST_LINE_rec.organization_id) THEN

706: ( p_PRICE_LIST_LINE_rec.organization_id <>
707: p_old_PRICE_LIST_LINE_rec.organization_id OR
708: p_old_PRICE_LIST_LINE_rec.organization_id IS NULL )
709: THEN
710: IF NOT QP_Validate.Organization(p_PRICE_LIST_LINE_rec.organization_id) THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: END IF;
713: END IF;
714:

Line 720: IF NOT QP_Validate.Override(p_PRICE_LIST_LINE_rec.override_flag) THEN

716: ( p_PRICE_LIST_LINE_rec.override_flag <>
717: p_old_PRICE_LIST_LINE_rec.override_flag OR
718: p_old_PRICE_LIST_LINE_rec.override_flag IS NULL )
719: THEN
720: IF NOT QP_Validate.Override(p_PRICE_LIST_LINE_rec.override_flag) THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: END IF;
723: END IF;
724:

Line 730: IF NOT QP_Validate.Percent_Price(p_PRICE_LIST_LINE_rec.percent_price) THEN

726: ( p_PRICE_LIST_LINE_rec.percent_price <>
727: p_old_PRICE_LIST_LINE_rec.percent_price OR
728: p_old_PRICE_LIST_LINE_rec.percent_price IS NULL )
729: THEN
730: IF NOT QP_Validate.Percent_Price(p_PRICE_LIST_LINE_rec.percent_price) THEN
731: x_return_status := FND_API.G_RET_STS_ERROR;
732: END IF;
733: END IF;
734:

Line 740: IF NOT QP_Validate.Price_Break_Type(p_PRICE_LIST_LINE_rec.price_break_type_code) THEN

736: ( p_PRICE_LIST_LINE_rec.price_break_type_code <>
737: p_old_PRICE_LIST_LINE_rec.price_break_type_code OR
738: p_old_PRICE_LIST_LINE_rec.price_break_type_code IS NULL )
739: THEN
740: IF NOT QP_Validate.Price_Break_Type(p_PRICE_LIST_LINE_rec.price_break_type_code) THEN
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: END IF;
743: END IF;
744:

Line 750: IF NOT QP_Validate.Price_By_Formula(p_PRICE_LIST_LINE_rec.price_by_formula_id) THEN

746: ( p_PRICE_LIST_LINE_rec.price_by_formula_id <>
747: p_old_PRICE_LIST_LINE_rec.price_by_formula_id OR
748: p_old_PRICE_LIST_LINE_rec.price_by_formula_id IS NULL )
749: THEN
750: IF NOT QP_Validate.Price_By_Formula(p_PRICE_LIST_LINE_rec.price_by_formula_id) THEN
751: x_return_status := FND_API.G_RET_STS_ERROR;
752: END IF;
753: END IF;
754:

Line 760: IF NOT QP_Validate.Primary_Uom(p_PRICE_LIST_LINE_rec.primary_uom_flag) THEN

756: ( p_PRICE_LIST_LINE_rec.primary_uom_flag <>
757: p_old_PRICE_LIST_LINE_rec.primary_uom_flag OR
758: p_old_PRICE_LIST_LINE_rec.primary_uom_flag IS NULL )
759: THEN
760: IF NOT QP_Validate.Primary_Uom(p_PRICE_LIST_LINE_rec.primary_uom_flag) THEN
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: END IF;
763: END IF;
764:

Line 770: IF NOT QP_Validate.Print_On_Invoice(p_PRICE_LIST_LINE_rec.print_on_invoice_flag) THEN

766: ( p_PRICE_LIST_LINE_rec.print_on_invoice_flag <>
767: p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag OR
768: p_old_PRICE_LIST_LINE_rec.print_on_invoice_flag IS NULL )
769: THEN
770: IF NOT QP_Validate.Print_On_Invoice(p_PRICE_LIST_LINE_rec.print_on_invoice_flag) THEN
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: END IF;
773: END IF;
774:

Line 780: IF NOT QP_Validate.Program_Application(p_PRICE_LIST_LINE_rec.program_application_id) THEN

776: ( p_PRICE_LIST_LINE_rec.program_application_id <>
777: p_old_PRICE_LIST_LINE_rec.program_application_id OR
778: p_old_PRICE_LIST_LINE_rec.program_application_id IS NULL )
779: THEN
780: IF NOT QP_Validate.Program_Application(p_PRICE_LIST_LINE_rec.program_application_id) THEN
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: END IF;
783: END IF;
784:

Line 790: IF NOT QP_Validate.Program(p_PRICE_LIST_LINE_rec.program_id) THEN

786: ( p_PRICE_LIST_LINE_rec.program_id <>
787: p_old_PRICE_LIST_LINE_rec.program_id OR
788: p_old_PRICE_LIST_LINE_rec.program_id IS NULL )
789: THEN
790: IF NOT QP_Validate.Program(p_PRICE_LIST_LINE_rec.program_id) THEN
791: x_return_status := FND_API.G_RET_STS_ERROR;
792: END IF;
793: END IF;
794:

Line 800: IF NOT QP_Validate.Program_Update_Date(p_PRICE_LIST_LINE_rec.program_update_date) THEN

796: ( p_PRICE_LIST_LINE_rec.program_update_date <>
797: p_old_PRICE_LIST_LINE_rec.program_update_date OR
798: p_old_PRICE_LIST_LINE_rec.program_update_date IS NULL )
799: THEN
800: IF NOT QP_Validate.Program_Update_Date(p_PRICE_LIST_LINE_rec.program_update_date) THEN
801: x_return_status := FND_API.G_RET_STS_ERROR;
802: END IF;
803: END IF;
804:

Line 810: IF NOT QP_Validate.Rebate_Transaction_Type(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code) THEN

806: ( p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <>
807: p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code OR
808: p_old_PRICE_LIST_LINE_rec.rebate_trxn_type_code IS NULL )
809: THEN
810: IF NOT QP_Validate.Rebate_Transaction_Type(p_PRICE_LIST_LINE_rec.rebate_trxn_type_code) THEN
811: x_return_status := FND_API.G_RET_STS_ERROR;
812: END IF;
813: END IF;
814:

Line 820: IF NOT QP_Validate.recurring_value(p_PRICE_LIST_LINE_rec.recurring_value) THEN

816: IF p_PRICE_LIST_LINE_rec.recurring_value IS NOT NULL AND
817: (p_PRICE_LIST_LINE_rec.recurring_value <> p_old_PRICE_LIST_LINE_rec.recurring_value OR
818: p_old_PRICE_LIST_LINE_rec.recurring_value IS NULL)
819: THEN
820: IF NOT QP_Validate.recurring_value(p_PRICE_LIST_LINE_rec.recurring_value) THEN
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: END IF;
823: END IF;
824:

Line 830: IF NOT QP_Validate.Related_Item(p_PRICE_LIST_LINE_rec.related_item_id) THEN

826: ( p_PRICE_LIST_LINE_rec.related_item_id <>
827: p_old_PRICE_LIST_LINE_rec.related_item_id OR
828: p_old_PRICE_LIST_LINE_rec.related_item_id IS NULL )
829: THEN
830: IF NOT QP_Validate.Related_Item(p_PRICE_LIST_LINE_rec.related_item_id) THEN
831: x_return_status := FND_API.G_RET_STS_ERROR;
832: END IF;
833: END IF;
834:

Line 840: IF NOT QP_Validate.Relationship_Type(p_PRICE_LIST_LINE_rec.relationship_type_id) THEN

836: ( p_PRICE_LIST_LINE_rec.relationship_type_id <>
837: p_old_PRICE_LIST_LINE_rec.relationship_type_id OR
838: p_old_PRICE_LIST_LINE_rec.relationship_type_id IS NULL )
839: THEN
840: IF NOT QP_Validate.Relationship_Type(p_PRICE_LIST_LINE_rec.relationship_type_id) THEN
841: x_return_status := FND_API.G_RET_STS_ERROR;
842: END IF;
843: END IF;
844:

Line 850: IF NOT QP_Validate.Reprice(p_PRICE_LIST_LINE_rec.reprice_flag) THEN

846: ( p_PRICE_LIST_LINE_rec.reprice_flag <>
847: p_old_PRICE_LIST_LINE_rec.reprice_flag OR
848: p_old_PRICE_LIST_LINE_rec.reprice_flag IS NULL )
849: THEN
850: IF NOT QP_Validate.Reprice(p_PRICE_LIST_LINE_rec.reprice_flag) THEN
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: END IF;
853: END IF;
854:

Line 860: IF NOT QP_Validate.Request(p_PRICE_LIST_LINE_rec.request_id) THEN

856: ( p_PRICE_LIST_LINE_rec.request_id <>
857: p_old_PRICE_LIST_LINE_rec.request_id OR
858: p_old_PRICE_LIST_LINE_rec.request_id IS NULL )
859: THEN
860: IF NOT QP_Validate.Request(p_PRICE_LIST_LINE_rec.request_id) THEN
861: x_return_status := FND_API.G_RET_STS_ERROR;
862: END IF;
863: END IF;
864:

Line 870: IF NOT QP_Validate.Revision(p_PRICE_LIST_LINE_rec.revision) THEN

866: ( p_PRICE_LIST_LINE_rec.revision <>
867: p_old_PRICE_LIST_LINE_rec.revision OR
868: p_old_PRICE_LIST_LINE_rec.revision IS NULL )
869: THEN
870: IF NOT QP_Validate.Revision(p_PRICE_LIST_LINE_rec.revision) THEN
871: x_return_status := FND_API.G_RET_STS_ERROR;
872: END IF;
873: END IF;
874:

Line 880: IF NOT QP_Validate.Revision_Date(p_PRICE_LIST_LINE_rec.revision_date) THEN

876: ( p_PRICE_LIST_LINE_rec.revision_date <>
877: p_old_PRICE_LIST_LINE_rec.revision_date OR
878: p_old_PRICE_LIST_LINE_rec.revision_date IS NULL )
879: THEN
880: IF NOT QP_Validate.Revision_Date(p_PRICE_LIST_LINE_rec.revision_date) THEN
881: x_return_status := FND_API.G_RET_STS_ERROR;
882: END IF;
883: END IF;
884:

Line 890: IF NOT QP_Validate.Revision_Reason(p_PRICE_LIST_LINE_rec.revision_reason_code) THEN

886: ( p_PRICE_LIST_LINE_rec.revision_reason_code <>
887: p_old_PRICE_LIST_LINE_rec.revision_reason_code OR
888: p_old_PRICE_LIST_LINE_rec.revision_reason_code IS NULL )
889: THEN
890: IF NOT QP_Validate.Revision_Reason(p_PRICE_LIST_LINE_rec.revision_reason_code) THEN
891: x_return_status := FND_API.G_RET_STS_ERROR;
892: END IF;
893: END IF;
894:

Line 900: IF NOT QP_Validate.Start_Date_Active(p_PRICE_LIST_LINE_rec.start_date_active, p_PRICE_LIST_LINE_rec.end_date_active) THEN

896: ( p_PRICE_LIST_LINE_rec.start_date_active <>
897: p_old_PRICE_LIST_LINE_rec.start_date_active OR
898: p_old_PRICE_LIST_LINE_rec.start_date_active IS NULL )
899: THEN
900: IF NOT QP_Validate.Start_Date_Active(p_PRICE_LIST_LINE_rec.start_date_active, p_PRICE_LIST_LINE_rec.end_date_active) THEN
901: x_return_status := FND_API.G_RET_STS_ERROR;
902: END IF;
903: END IF;
904:

Line 910: IF NOT QP_Validate.Substitution_Attribute(p_PRICE_LIST_LINE_rec.substitution_attribute) THEN

906: ( p_PRICE_LIST_LINE_rec.substitution_attribute <>
907: p_old_PRICE_LIST_LINE_rec.substitution_attribute OR
908: p_old_PRICE_LIST_LINE_rec.substitution_attribute IS NULL )
909: THEN
910: IF NOT QP_Validate.Substitution_Attribute(p_PRICE_LIST_LINE_rec.substitution_attribute) THEN
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: END IF;
913: END IF;
914:

Line 920: IF NOT QP_Validate.Substitution_Context(p_PRICE_LIST_LINE_rec.substitution_context) THEN

916: ( p_PRICE_LIST_LINE_rec.substitution_context <>
917: p_old_PRICE_LIST_LINE_rec.substitution_context OR
918: p_old_PRICE_LIST_LINE_rec.substitution_context IS NULL )
919: THEN
920: IF NOT QP_Validate.Substitution_Context(p_PRICE_LIST_LINE_rec.substitution_context) THEN
921: x_return_status := FND_API.G_RET_STS_ERROR;
922: END IF;
923: END IF;
924:

Line 930: IF NOT QP_Validate.Substitution_Value(p_PRICE_LIST_LINE_rec.substitution_value) THEN

926: ( p_PRICE_LIST_LINE_rec.substitution_value <>
927: p_old_PRICE_LIST_LINE_rec.substitution_value OR
928: p_old_PRICE_LIST_LINE_rec.substitution_value IS NULL )
929: THEN
930: IF NOT QP_Validate.Substitution_Value(p_PRICE_LIST_LINE_rec.substitution_value) THEN
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: END IF;
933: END IF;
934:

Line 941: IF NOT QP_Validate.customer_item_id(p_PRICE_LIST_LINE_rec.CUSTOMER_ITEM_ID) THEN

937: ( p_PRICE_LIST_LINE_rec.CUSTOMER_ITEM_ID <>
938: p_old_PRICE_LIST_LINE_rec.CUSTOMER_ITEM_ID OR
939: p_old_PRICE_LIST_LINE_rec.CUSTOMER_ITEM_ID IS NULL)
940: THEN
941: IF NOT QP_Validate.customer_item_id(p_PRICE_LIST_LINE_rec.CUSTOMER_ITEM_ID) THEN
942: x_return_status := FND_API.G_RET_STS_ERROR;
943: END IF;
944: END IF;
945: -- OKS proration

Line 951: IF NOT QP_Validate.Break_UOM_Code(p_PRICE_LIST_LINE_rec.break_uom_code) THEN

947: ( p_PRICE_LIST_LINE_rec.break_uom_code <>
948: p_old_PRICE_LIST_LINE_rec.break_uom_code OR
949: p_old_PRICE_LIST_LINE_rec.break_uom_code IS NULL )
950: THEN
951: IF NOT QP_Validate.Break_UOM_Code(p_PRICE_LIST_LINE_rec.break_uom_code) THEN
952: x_return_status := FND_API.G_RET_STS_ERROR;
953: END IF;
954: END IF;
955:

Line 961: IF NOT QP_Validate.Break_UOM_Context(p_PRICE_LIST_LINE_rec.break_uom_context) THEN

957: ( p_PRICE_LIST_LINE_rec.break_uom_context <>
958: p_old_PRICE_LIST_LINE_rec.break_uom_context OR
959: p_old_PRICE_LIST_LINE_rec.break_uom_context IS NULL )
960: THEN
961: IF NOT QP_Validate.Break_UOM_Context(p_PRICE_LIST_LINE_rec.break_uom_context) THEN
962: x_return_status := FND_API.G_RET_STS_ERROR;
963: END IF;
964: END IF;
965:

Line 971: IF NOT QP_Validate.Break_UOM_Attribute(p_PRICE_LIST_LINE_rec.break_uom_attribute) THEN

967: ( p_PRICE_LIST_LINE_rec.break_uom_attribute <>
968: p_old_PRICE_LIST_LINE_rec.break_uom_attribute OR
969: p_old_PRICE_LIST_LINE_rec.break_uom_attribute IS NULL )
970: THEN
971: IF NOT QP_Validate.Break_UOM_Attribute(p_PRICE_LIST_LINE_rec.break_uom_attribute) THEN
972: x_return_status := FND_API.G_RET_STS_ERROR;
973: END IF;
974: END IF;
975:

Line 1113: IF NOT QP_Validate.Desc_Flex( 'PRICE_LIST_LINE' ) THEN

1109: */
1110:
1111: -- Validate descriptive flexfield.
1112:
1113: IF NOT QP_Validate.Desc_Flex( 'PRICE_LIST_LINE' ) THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: END IF;
1116:
1117: END IF;

Line 1187: END QP_Validate_Price_List_Line;

1183: END IF;
1184:
1185: END Entity_Delete;
1186:
1187: END QP_Validate_Price_List_Line;