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_FORMULA_LINES_UTIL dependencies on FND_API

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type
13: , p_old_FORMULA_LINES_rec IN QP_Price_Formula_PUB.Formula_Lines_Rec_Type :=
14: QP_Price_Formula_PUB.G_MISS_FORMULA_LINES_REC
15: , x_FORMULA_LINES_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Lines_Rec_Type

Line 31: IF p_attr_id = FND_API.G_MISS_NUM THEN

27:
28: -- If attr_id is missing compare old and new records and for
29: -- every changed attribute clear its dependent fields.
30:
31: IF p_attr_id = FND_API.G_MISS_NUM THEN
32:
33: IF NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.attribute1,p_old_FORMULA_LINES_rec.attribute1)
34: THEN
35: l_index := l_index + 1;

Line 530: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN

526: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
527: BEGIN
528:
529: oe_debug_pub.add('Entering proc Complete_Record in FormulaLines Util Pkg');
530: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
531: l_FORMULA_LINES_rec.attribute1 := p_old_FORMULA_LINES_rec.attribute1;
532: END IF;
533:
534: IF l_FORMULA_LINES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 534: IF l_FORMULA_LINES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

530: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
531: l_FORMULA_LINES_rec.attribute1 := p_old_FORMULA_LINES_rec.attribute1;
532: END IF;
533:
534: IF l_FORMULA_LINES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
535: l_FORMULA_LINES_rec.attribute10 := p_old_FORMULA_LINES_rec.attribute10;
536: END IF;
537:
538: IF l_FORMULA_LINES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 538: IF l_FORMULA_LINES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

534: IF l_FORMULA_LINES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
535: l_FORMULA_LINES_rec.attribute10 := p_old_FORMULA_LINES_rec.attribute10;
536: END IF;
537:
538: IF l_FORMULA_LINES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
539: l_FORMULA_LINES_rec.attribute11 := p_old_FORMULA_LINES_rec.attribute11;
540: END IF;
541:
542: IF l_FORMULA_LINES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 542: IF l_FORMULA_LINES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

538: IF l_FORMULA_LINES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
539: l_FORMULA_LINES_rec.attribute11 := p_old_FORMULA_LINES_rec.attribute11;
540: END IF;
541:
542: IF l_FORMULA_LINES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
543: l_FORMULA_LINES_rec.attribute12 := p_old_FORMULA_LINES_rec.attribute12;
544: END IF;
545:
546: IF l_FORMULA_LINES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 546: IF l_FORMULA_LINES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

542: IF l_FORMULA_LINES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
543: l_FORMULA_LINES_rec.attribute12 := p_old_FORMULA_LINES_rec.attribute12;
544: END IF;
545:
546: IF l_FORMULA_LINES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
547: l_FORMULA_LINES_rec.attribute13 := p_old_FORMULA_LINES_rec.attribute13;
548: END IF;
549:
550: IF l_FORMULA_LINES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 550: IF l_FORMULA_LINES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

546: IF l_FORMULA_LINES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
547: l_FORMULA_LINES_rec.attribute13 := p_old_FORMULA_LINES_rec.attribute13;
548: END IF;
549:
550: IF l_FORMULA_LINES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
551: l_FORMULA_LINES_rec.attribute14 := p_old_FORMULA_LINES_rec.attribute14;
552: END IF;
553:
554: IF l_FORMULA_LINES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 554: IF l_FORMULA_LINES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

550: IF l_FORMULA_LINES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
551: l_FORMULA_LINES_rec.attribute14 := p_old_FORMULA_LINES_rec.attribute14;
552: END IF;
553:
554: IF l_FORMULA_LINES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
555: l_FORMULA_LINES_rec.attribute15 := p_old_FORMULA_LINES_rec.attribute15;
556: END IF;
557:
558: IF l_FORMULA_LINES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 558: IF l_FORMULA_LINES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

554: IF l_FORMULA_LINES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
555: l_FORMULA_LINES_rec.attribute15 := p_old_FORMULA_LINES_rec.attribute15;
556: END IF;
557:
558: IF l_FORMULA_LINES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
559: l_FORMULA_LINES_rec.attribute2 := p_old_FORMULA_LINES_rec.attribute2;
560: END IF;
561:
562: IF l_FORMULA_LINES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 562: IF l_FORMULA_LINES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

558: IF l_FORMULA_LINES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
559: l_FORMULA_LINES_rec.attribute2 := p_old_FORMULA_LINES_rec.attribute2;
560: END IF;
561:
562: IF l_FORMULA_LINES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
563: l_FORMULA_LINES_rec.attribute3 := p_old_FORMULA_LINES_rec.attribute3;
564: END IF;
565:
566: IF l_FORMULA_LINES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 566: IF l_FORMULA_LINES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

562: IF l_FORMULA_LINES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
563: l_FORMULA_LINES_rec.attribute3 := p_old_FORMULA_LINES_rec.attribute3;
564: END IF;
565:
566: IF l_FORMULA_LINES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
567: l_FORMULA_LINES_rec.attribute4 := p_old_FORMULA_LINES_rec.attribute4;
568: END IF;
569:
570: IF l_FORMULA_LINES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 570: IF l_FORMULA_LINES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

566: IF l_FORMULA_LINES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
567: l_FORMULA_LINES_rec.attribute4 := p_old_FORMULA_LINES_rec.attribute4;
568: END IF;
569:
570: IF l_FORMULA_LINES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
571: l_FORMULA_LINES_rec.attribute5 := p_old_FORMULA_LINES_rec.attribute5;
572: END IF;
573:
574: IF l_FORMULA_LINES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 574: IF l_FORMULA_LINES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

570: IF l_FORMULA_LINES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
571: l_FORMULA_LINES_rec.attribute5 := p_old_FORMULA_LINES_rec.attribute5;
572: END IF;
573:
574: IF l_FORMULA_LINES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
575: l_FORMULA_LINES_rec.attribute6 := p_old_FORMULA_LINES_rec.attribute6;
576: END IF;
577:
578: IF l_FORMULA_LINES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 578: IF l_FORMULA_LINES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

574: IF l_FORMULA_LINES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
575: l_FORMULA_LINES_rec.attribute6 := p_old_FORMULA_LINES_rec.attribute6;
576: END IF;
577:
578: IF l_FORMULA_LINES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
579: l_FORMULA_LINES_rec.attribute7 := p_old_FORMULA_LINES_rec.attribute7;
580: END IF;
581:
582: IF l_FORMULA_LINES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 582: IF l_FORMULA_LINES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

578: IF l_FORMULA_LINES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
579: l_FORMULA_LINES_rec.attribute7 := p_old_FORMULA_LINES_rec.attribute7;
580: END IF;
581:
582: IF l_FORMULA_LINES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
583: l_FORMULA_LINES_rec.attribute8 := p_old_FORMULA_LINES_rec.attribute8;
584: END IF;
585:
586: IF l_FORMULA_LINES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 586: IF l_FORMULA_LINES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

582: IF l_FORMULA_LINES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
583: l_FORMULA_LINES_rec.attribute8 := p_old_FORMULA_LINES_rec.attribute8;
584: END IF;
585:
586: IF l_FORMULA_LINES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
587: l_FORMULA_LINES_rec.attribute9 := p_old_FORMULA_LINES_rec.attribute9;
588: END IF;
589:
590: IF l_FORMULA_LINES_rec.context = FND_API.G_MISS_CHAR THEN

Line 590: IF l_FORMULA_LINES_rec.context = FND_API.G_MISS_CHAR THEN

586: IF l_FORMULA_LINES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
587: l_FORMULA_LINES_rec.attribute9 := p_old_FORMULA_LINES_rec.attribute9;
588: END IF;
589:
590: IF l_FORMULA_LINES_rec.context = FND_API.G_MISS_CHAR THEN
591: l_FORMULA_LINES_rec.context := p_old_FORMULA_LINES_rec.context;
592: END IF;
593:
594: IF l_FORMULA_LINES_rec.created_by = FND_API.G_MISS_NUM THEN

Line 594: IF l_FORMULA_LINES_rec.created_by = FND_API.G_MISS_NUM THEN

590: IF l_FORMULA_LINES_rec.context = FND_API.G_MISS_CHAR THEN
591: l_FORMULA_LINES_rec.context := p_old_FORMULA_LINES_rec.context;
592: END IF;
593:
594: IF l_FORMULA_LINES_rec.created_by = FND_API.G_MISS_NUM THEN
595: l_FORMULA_LINES_rec.created_by := p_old_FORMULA_LINES_rec.created_by;
596: END IF;
597:
598: IF l_FORMULA_LINES_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 598: IF l_FORMULA_LINES_rec.creation_date = FND_API.G_MISS_DATE THEN

594: IF l_FORMULA_LINES_rec.created_by = FND_API.G_MISS_NUM THEN
595: l_FORMULA_LINES_rec.created_by := p_old_FORMULA_LINES_rec.created_by;
596: END IF;
597:
598: IF l_FORMULA_LINES_rec.creation_date = FND_API.G_MISS_DATE THEN
599: l_FORMULA_LINES_rec.creation_date := p_old_FORMULA_LINES_rec.creation_date;
600: END IF;
601:
602: IF l_FORMULA_LINES_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 602: IF l_FORMULA_LINES_rec.end_date_active = FND_API.G_MISS_DATE THEN

598: IF l_FORMULA_LINES_rec.creation_date = FND_API.G_MISS_DATE THEN
599: l_FORMULA_LINES_rec.creation_date := p_old_FORMULA_LINES_rec.creation_date;
600: END IF;
601:
602: IF l_FORMULA_LINES_rec.end_date_active = FND_API.G_MISS_DATE THEN
603: l_FORMULA_LINES_rec.end_date_active := p_old_FORMULA_LINES_rec.end_date_active;
604: END IF;
605:
606: IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 606: IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

602: IF l_FORMULA_LINES_rec.end_date_active = FND_API.G_MISS_DATE THEN
603: l_FORMULA_LINES_rec.end_date_active := p_old_FORMULA_LINES_rec.end_date_active;
604: END IF;
605:
606: IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
607: l_FORMULA_LINES_rec.last_updated_by := p_old_FORMULA_LINES_rec.last_updated_by;
608: END IF;
609:
610: IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 610: IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN

606: IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
607: l_FORMULA_LINES_rec.last_updated_by := p_old_FORMULA_LINES_rec.last_updated_by;
608: END IF;
609:
610: IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN
611: l_FORMULA_LINES_rec.last_update_date := p_old_FORMULA_LINES_rec.last_update_date;
612: END IF;
613:
614: IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 614: IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN

610: IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN
611: l_FORMULA_LINES_rec.last_update_date := p_old_FORMULA_LINES_rec.last_update_date;
612: END IF;
613:
614: IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN
615: l_FORMULA_LINES_rec.last_update_login := p_old_FORMULA_LINES_rec.last_update_login;
616: END IF;
617:
618: IF l_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM THEN

Line 618: IF l_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM THEN

614: IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN
615: l_FORMULA_LINES_rec.last_update_login := p_old_FORMULA_LINES_rec.last_update_login;
616: END IF;
617:
618: IF l_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM THEN
619: l_FORMULA_LINES_rec.numeric_constant := p_old_FORMULA_LINES_rec.numeric_constant;
620: END IF;
621:
622: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN

Line 622: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN

618: IF l_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM THEN
619: l_FORMULA_LINES_rec.numeric_constant := p_old_FORMULA_LINES_rec.numeric_constant;
620: END IF;
621:
622: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN
623: l_FORMULA_LINES_rec.price_formula_id := p_old_FORMULA_LINES_rec.price_formula_id;
624: END IF;
625:
626: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN

Line 626: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN

622: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN
623: l_FORMULA_LINES_rec.price_formula_id := p_old_FORMULA_LINES_rec.price_formula_id;
624: END IF;
625:
626: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN
627: l_FORMULA_LINES_rec.price_formula_line_id := p_old_FORMULA_LINES_rec.price_formula_line_id;
628: END IF;
629:
630: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN

Line 630: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN

626: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN
627: l_FORMULA_LINES_rec.price_formula_line_id := p_old_FORMULA_LINES_rec.price_formula_line_id;
628: END IF;
629:
630: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN
631: l_FORMULA_LINES_rec.formula_line_type_code := p_old_FORMULA_LINES_rec.formula_line_type_code;
632: END IF;
633:
634: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN

Line 634: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN

630: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN
631: l_FORMULA_LINES_rec.formula_line_type_code := p_old_FORMULA_LINES_rec.formula_line_type_code;
632: END IF;
633:
634: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
635: l_FORMULA_LINES_rec.price_list_line_id := p_old_FORMULA_LINES_rec.price_list_line_id;
636: END IF;
637:
638: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN

Line 638: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN

634: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
635: l_FORMULA_LINES_rec.price_list_line_id := p_old_FORMULA_LINES_rec.price_list_line_id;
636: END IF;
637:
638: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN
639: l_FORMULA_LINES_rec.price_modifier_list_id := p_old_FORMULA_LINES_rec.price_modifier_list_id;
640: END IF;
641:
642: IF l_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

Line 642: IF l_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

638: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN
639: l_FORMULA_LINES_rec.price_modifier_list_id := p_old_FORMULA_LINES_rec.price_modifier_list_id;
640: END IF;
641:
642: IF l_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
643: l_FORMULA_LINES_rec.pricing_attribute := p_old_FORMULA_LINES_rec.pricing_attribute;
644: END IF;
645:
646: IF l_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

Line 646: IF l_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

642: IF l_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
643: l_FORMULA_LINES_rec.pricing_attribute := p_old_FORMULA_LINES_rec.pricing_attribute;
644: END IF;
645:
646: IF l_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
647: l_FORMULA_LINES_rec.pricing_attribute_context := p_old_FORMULA_LINES_rec.pricing_attribute_context;
648: END IF;
649:
650: IF l_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 650: IF l_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE THEN

646: IF l_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
647: l_FORMULA_LINES_rec.pricing_attribute_context := p_old_FORMULA_LINES_rec.pricing_attribute_context;
648: END IF;
649:
650: IF l_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE THEN
651: l_FORMULA_LINES_rec.start_date_active := p_old_FORMULA_LINES_rec.start_date_active;
652: END IF;
653:
654: IF l_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM THEN

Line 654: IF l_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM THEN

650: IF l_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE THEN
651: l_FORMULA_LINES_rec.start_date_active := p_old_FORMULA_LINES_rec.start_date_active;
652: END IF;
653:
654: IF l_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM THEN
655: l_FORMULA_LINES_rec.step_number := p_old_FORMULA_LINES_rec.step_number;
656: END IF;
657:
658: IF l_FORMULA_LINES_rec.reqd_flag = FND_API.G_MISS_CHAR THEN

Line 658: IF l_FORMULA_LINES_rec.reqd_flag = FND_API.G_MISS_CHAR THEN

654: IF l_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM THEN
655: l_FORMULA_LINES_rec.step_number := p_old_FORMULA_LINES_rec.step_number;
656: END IF;
657:
658: IF l_FORMULA_LINES_rec.reqd_flag = FND_API.G_MISS_CHAR THEN
659: l_FORMULA_LINES_rec.reqd_flag := p_old_FORMULA_LINES_rec.reqd_flag;
660: END IF;
661:
662: RETURN l_FORMULA_LINES_rec;

Line 677: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN

673: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type := p_FORMULA_LINES_rec;
674: BEGIN
675:
676: oe_debug_pub.add('Entering proc Convert_Miss_To_Null in FormulaLines Util Pkg');
677: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
678: l_FORMULA_LINES_rec.attribute1 := NULL;
679: END IF;
680:
681: IF l_FORMULA_LINES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 681: IF l_FORMULA_LINES_rec.attribute10 = FND_API.G_MISS_CHAR THEN

677: IF l_FORMULA_LINES_rec.attribute1 = FND_API.G_MISS_CHAR THEN
678: l_FORMULA_LINES_rec.attribute1 := NULL;
679: END IF;
680:
681: IF l_FORMULA_LINES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
682: l_FORMULA_LINES_rec.attribute10 := NULL;
683: END IF;
684:
685: IF l_FORMULA_LINES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 685: IF l_FORMULA_LINES_rec.attribute11 = FND_API.G_MISS_CHAR THEN

681: IF l_FORMULA_LINES_rec.attribute10 = FND_API.G_MISS_CHAR THEN
682: l_FORMULA_LINES_rec.attribute10 := NULL;
683: END IF;
684:
685: IF l_FORMULA_LINES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
686: l_FORMULA_LINES_rec.attribute11 := NULL;
687: END IF;
688:
689: IF l_FORMULA_LINES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 689: IF l_FORMULA_LINES_rec.attribute12 = FND_API.G_MISS_CHAR THEN

685: IF l_FORMULA_LINES_rec.attribute11 = FND_API.G_MISS_CHAR THEN
686: l_FORMULA_LINES_rec.attribute11 := NULL;
687: END IF;
688:
689: IF l_FORMULA_LINES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
690: l_FORMULA_LINES_rec.attribute12 := NULL;
691: END IF;
692:
693: IF l_FORMULA_LINES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 693: IF l_FORMULA_LINES_rec.attribute13 = FND_API.G_MISS_CHAR THEN

689: IF l_FORMULA_LINES_rec.attribute12 = FND_API.G_MISS_CHAR THEN
690: l_FORMULA_LINES_rec.attribute12 := NULL;
691: END IF;
692:
693: IF l_FORMULA_LINES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
694: l_FORMULA_LINES_rec.attribute13 := NULL;
695: END IF;
696:
697: IF l_FORMULA_LINES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 697: IF l_FORMULA_LINES_rec.attribute14 = FND_API.G_MISS_CHAR THEN

693: IF l_FORMULA_LINES_rec.attribute13 = FND_API.G_MISS_CHAR THEN
694: l_FORMULA_LINES_rec.attribute13 := NULL;
695: END IF;
696:
697: IF l_FORMULA_LINES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
698: l_FORMULA_LINES_rec.attribute14 := NULL;
699: END IF;
700:
701: IF l_FORMULA_LINES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 701: IF l_FORMULA_LINES_rec.attribute15 = FND_API.G_MISS_CHAR THEN

697: IF l_FORMULA_LINES_rec.attribute14 = FND_API.G_MISS_CHAR THEN
698: l_FORMULA_LINES_rec.attribute14 := NULL;
699: END IF;
700:
701: IF l_FORMULA_LINES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
702: l_FORMULA_LINES_rec.attribute15 := NULL;
703: END IF;
704:
705: IF l_FORMULA_LINES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 705: IF l_FORMULA_LINES_rec.attribute2 = FND_API.G_MISS_CHAR THEN

701: IF l_FORMULA_LINES_rec.attribute15 = FND_API.G_MISS_CHAR THEN
702: l_FORMULA_LINES_rec.attribute15 := NULL;
703: END IF;
704:
705: IF l_FORMULA_LINES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
706: l_FORMULA_LINES_rec.attribute2 := NULL;
707: END IF;
708:
709: IF l_FORMULA_LINES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 709: IF l_FORMULA_LINES_rec.attribute3 = FND_API.G_MISS_CHAR THEN

705: IF l_FORMULA_LINES_rec.attribute2 = FND_API.G_MISS_CHAR THEN
706: l_FORMULA_LINES_rec.attribute2 := NULL;
707: END IF;
708:
709: IF l_FORMULA_LINES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
710: l_FORMULA_LINES_rec.attribute3 := NULL;
711: END IF;
712:
713: IF l_FORMULA_LINES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 713: IF l_FORMULA_LINES_rec.attribute4 = FND_API.G_MISS_CHAR THEN

709: IF l_FORMULA_LINES_rec.attribute3 = FND_API.G_MISS_CHAR THEN
710: l_FORMULA_LINES_rec.attribute3 := NULL;
711: END IF;
712:
713: IF l_FORMULA_LINES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
714: l_FORMULA_LINES_rec.attribute4 := NULL;
715: END IF;
716:
717: IF l_FORMULA_LINES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 717: IF l_FORMULA_LINES_rec.attribute5 = FND_API.G_MISS_CHAR THEN

713: IF l_FORMULA_LINES_rec.attribute4 = FND_API.G_MISS_CHAR THEN
714: l_FORMULA_LINES_rec.attribute4 := NULL;
715: END IF;
716:
717: IF l_FORMULA_LINES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
718: l_FORMULA_LINES_rec.attribute5 := NULL;
719: END IF;
720:
721: IF l_FORMULA_LINES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 721: IF l_FORMULA_LINES_rec.attribute6 = FND_API.G_MISS_CHAR THEN

717: IF l_FORMULA_LINES_rec.attribute5 = FND_API.G_MISS_CHAR THEN
718: l_FORMULA_LINES_rec.attribute5 := NULL;
719: END IF;
720:
721: IF l_FORMULA_LINES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
722: l_FORMULA_LINES_rec.attribute6 := NULL;
723: END IF;
724:
725: IF l_FORMULA_LINES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 725: IF l_FORMULA_LINES_rec.attribute7 = FND_API.G_MISS_CHAR THEN

721: IF l_FORMULA_LINES_rec.attribute6 = FND_API.G_MISS_CHAR THEN
722: l_FORMULA_LINES_rec.attribute6 := NULL;
723: END IF;
724:
725: IF l_FORMULA_LINES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
726: l_FORMULA_LINES_rec.attribute7 := NULL;
727: END IF;
728:
729: IF l_FORMULA_LINES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 729: IF l_FORMULA_LINES_rec.attribute8 = FND_API.G_MISS_CHAR THEN

725: IF l_FORMULA_LINES_rec.attribute7 = FND_API.G_MISS_CHAR THEN
726: l_FORMULA_LINES_rec.attribute7 := NULL;
727: END IF;
728:
729: IF l_FORMULA_LINES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
730: l_FORMULA_LINES_rec.attribute8 := NULL;
731: END IF;
732:
733: IF l_FORMULA_LINES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 733: IF l_FORMULA_LINES_rec.attribute9 = FND_API.G_MISS_CHAR THEN

729: IF l_FORMULA_LINES_rec.attribute8 = FND_API.G_MISS_CHAR THEN
730: l_FORMULA_LINES_rec.attribute8 := NULL;
731: END IF;
732:
733: IF l_FORMULA_LINES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
734: l_FORMULA_LINES_rec.attribute9 := NULL;
735: END IF;
736:
737: IF l_FORMULA_LINES_rec.context = FND_API.G_MISS_CHAR THEN

Line 737: IF l_FORMULA_LINES_rec.context = FND_API.G_MISS_CHAR THEN

733: IF l_FORMULA_LINES_rec.attribute9 = FND_API.G_MISS_CHAR THEN
734: l_FORMULA_LINES_rec.attribute9 := NULL;
735: END IF;
736:
737: IF l_FORMULA_LINES_rec.context = FND_API.G_MISS_CHAR THEN
738: l_FORMULA_LINES_rec.context := NULL;
739: END IF;
740:
741: IF l_FORMULA_LINES_rec.created_by = FND_API.G_MISS_NUM THEN

Line 741: IF l_FORMULA_LINES_rec.created_by = FND_API.G_MISS_NUM THEN

737: IF l_FORMULA_LINES_rec.context = FND_API.G_MISS_CHAR THEN
738: l_FORMULA_LINES_rec.context := NULL;
739: END IF;
740:
741: IF l_FORMULA_LINES_rec.created_by = FND_API.G_MISS_NUM THEN
742: l_FORMULA_LINES_rec.created_by := NULL;
743: END IF;
744:
745: IF l_FORMULA_LINES_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 745: IF l_FORMULA_LINES_rec.creation_date = FND_API.G_MISS_DATE THEN

741: IF l_FORMULA_LINES_rec.created_by = FND_API.G_MISS_NUM THEN
742: l_FORMULA_LINES_rec.created_by := NULL;
743: END IF;
744:
745: IF l_FORMULA_LINES_rec.creation_date = FND_API.G_MISS_DATE THEN
746: l_FORMULA_LINES_rec.creation_date := NULL;
747: END IF;
748:
749: IF l_FORMULA_LINES_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 749: IF l_FORMULA_LINES_rec.end_date_active = FND_API.G_MISS_DATE THEN

745: IF l_FORMULA_LINES_rec.creation_date = FND_API.G_MISS_DATE THEN
746: l_FORMULA_LINES_rec.creation_date := NULL;
747: END IF;
748:
749: IF l_FORMULA_LINES_rec.end_date_active = FND_API.G_MISS_DATE THEN
750: l_FORMULA_LINES_rec.end_date_active := NULL;
751: END IF;
752:
753: IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 753: IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN

749: IF l_FORMULA_LINES_rec.end_date_active = FND_API.G_MISS_DATE THEN
750: l_FORMULA_LINES_rec.end_date_active := NULL;
751: END IF;
752:
753: IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
754: l_FORMULA_LINES_rec.last_updated_by := NULL;
755: END IF;
756:
757: IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 757: IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN

753: IF l_FORMULA_LINES_rec.last_updated_by = FND_API.G_MISS_NUM THEN
754: l_FORMULA_LINES_rec.last_updated_by := NULL;
755: END IF;
756:
757: IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN
758: l_FORMULA_LINES_rec.last_update_date := NULL;
759: END IF;
760:
761: IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 761: IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN

757: IF l_FORMULA_LINES_rec.last_update_date = FND_API.G_MISS_DATE THEN
758: l_FORMULA_LINES_rec.last_update_date := NULL;
759: END IF;
760:
761: IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN
762: l_FORMULA_LINES_rec.last_update_login := NULL;
763: END IF;
764:
765: IF l_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM THEN

Line 765: IF l_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM THEN

761: IF l_FORMULA_LINES_rec.last_update_login = FND_API.G_MISS_NUM THEN
762: l_FORMULA_LINES_rec.last_update_login := NULL;
763: END IF;
764:
765: IF l_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM THEN
766: l_FORMULA_LINES_rec.numeric_constant := NULL;
767: END IF;
768:
769: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN

Line 769: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN

765: IF l_FORMULA_LINES_rec.numeric_constant = FND_API.G_MISS_NUM THEN
766: l_FORMULA_LINES_rec.numeric_constant := NULL;
767: END IF;
768:
769: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN
770: l_FORMULA_LINES_rec.price_formula_id := NULL;
771: END IF;
772:
773: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN

Line 773: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN

769: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN
770: l_FORMULA_LINES_rec.price_formula_id := NULL;
771: END IF;
772:
773: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN
774: l_FORMULA_LINES_rec.price_formula_line_id := NULL;
775: END IF;
776:
777: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN

Line 777: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN

773: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN
774: l_FORMULA_LINES_rec.price_formula_line_id := NULL;
775: END IF;
776:
777: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN
778: l_FORMULA_LINES_rec.formula_line_type_code := NULL;
779: END IF;
780:
781: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN

Line 781: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN

777: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN
778: l_FORMULA_LINES_rec.formula_line_type_code := NULL;
779: END IF;
780:
781: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
782: l_FORMULA_LINES_rec.price_list_line_id := NULL;
783: END IF;
784:
785: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN

Line 785: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN

781: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
782: l_FORMULA_LINES_rec.price_list_line_id := NULL;
783: END IF;
784:
785: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN
786: l_FORMULA_LINES_rec.price_modifier_list_id := NULL;
787: END IF;
788:
789: IF l_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

Line 789: IF l_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

785: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN
786: l_FORMULA_LINES_rec.price_modifier_list_id := NULL;
787: END IF;
788:
789: IF l_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
790: l_FORMULA_LINES_rec.pricing_attribute := NULL;
791: END IF;
792:
793: IF l_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

Line 793: IF l_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

789: IF l_FORMULA_LINES_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
790: l_FORMULA_LINES_rec.pricing_attribute := NULL;
791: END IF;
792:
793: IF l_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
794: l_FORMULA_LINES_rec.pricing_attribute_context := NULL;
795: END IF;
796:
797: IF l_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 797: IF l_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE THEN

793: IF l_FORMULA_LINES_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
794: l_FORMULA_LINES_rec.pricing_attribute_context := NULL;
795: END IF;
796:
797: IF l_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE THEN
798: l_FORMULA_LINES_rec.start_date_active := NULL;
799: END IF;
800:
801: IF l_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM THEN

Line 801: IF l_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM THEN

797: IF l_FORMULA_LINES_rec.start_date_active = FND_API.G_MISS_DATE THEN
798: l_FORMULA_LINES_rec.start_date_active := NULL;
799: END IF;
800:
801: IF l_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM THEN
802: l_FORMULA_LINES_rec.step_number := NULL;
803: END IF;
804:
805: IF l_FORMULA_LINES_rec.reqd_flag = FND_API.G_MISS_CHAR THEN

Line 805: IF l_FORMULA_LINES_rec.reqd_flag = FND_API.G_MISS_CHAR THEN

801: IF l_FORMULA_LINES_rec.step_number = FND_API.G_MISS_NUM THEN
802: l_FORMULA_LINES_rec.step_number := NULL;
803: END IF;
804:
805: IF l_FORMULA_LINES_rec.reqd_flag = FND_API.G_MISS_CHAR THEN
806: l_FORMULA_LINES_rec.reqd_flag := NULL;
807: END IF;
808:
809: oe_debug_pub.add('Leaving proc Convert_Miss_To_Null in FormulaLines Util Pkg');

Line 885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

881: , 'Update_Row'
882: );
883: END IF;
884:
885: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
886:
887: END Update_Row;
888:
889: -- Procedure Insert_Row

Line 995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

991: , 'Insert_Row'
992: );
993: END IF;
994:
995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
996:
997: END Insert_Row;
998:
999: -- Procedure Delete_Row

Line 1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1023: , 'Delete_Row'
1024: );
1025: END IF;
1026:
1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028:
1029: END Delete_Row;
1030:
1031: -- Function Query_Row

Line 1052: FND_API.G_MISS_NUM

1048: --
1049:
1050: FUNCTION Query_Rows
1051: ( p_price_formula_line_id IN NUMBER :=
1052: FND_API.G_MISS_NUM
1053: , p_price_formula_id IN NUMBER :=
1054: FND_API.G_MISS_NUM
1055: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type
1056: IS

Line 1054: FND_API.G_MISS_NUM

1050: FUNCTION Query_Rows
1051: ( p_price_formula_line_id IN NUMBER :=
1052: FND_API.G_MISS_NUM
1053: , p_price_formula_id IN NUMBER :=
1054: FND_API.G_MISS_NUM
1055: ) RETURN QP_Price_Formula_PUB.Formula_Lines_Tbl_Type
1056: IS
1057: l_FORMULA_LINES_rec QP_Price_Formula_PUB.Formula_Lines_Rec_Type;
1058: l_FORMULA_LINES_tbl QP_Price_Formula_PUB.Formula_Lines_Tbl_Type;

Line 1106: p_price_formula_line_id <> FND_API.G_MISS_NUM)

1102: oe_debug_pub.add('Entering proc Query_Rows in FormulaLines Util Pkg');
1103: IF
1104: (p_price_formula_line_id IS NOT NULL
1105: AND
1106: p_price_formula_line_id <> FND_API.G_MISS_NUM)
1107: AND
1108: (p_price_formula_id IS NOT NULL
1109: AND
1110: p_price_formula_id <> FND_API.G_MISS_NUM)

Line 1110: p_price_formula_id <> FND_API.G_MISS_NUM)

1106: p_price_formula_line_id <> FND_API.G_MISS_NUM)
1107: AND
1108: (p_price_formula_id IS NOT NULL
1109: AND
1110: p_price_formula_id <> FND_API.G_MISS_NUM)
1111: THEN
1112: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1113: THEN
1114: OE_MSG_PUB.Add_Exc_Msg

Line 1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1117: , 'Keys are mutually exclusive: price_formula_line_id = '|| p_price_formula_line_id || ', price_formula_id = '|| p_price_formula_id
1118: );
1119: END IF;
1120:
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122:
1123: END IF;
1124:
1125:

Line 1174: p_price_formula_line_id <> FND_API.G_MISS_NUM)

1170:
1171: IF
1172: (p_price_formula_line_id IS NOT NULL
1173: AND
1174: p_price_formula_line_id <> FND_API.G_MISS_NUM)
1175: AND
1176: (l_FORMULA_LINES_tbl.COUNT = 0)
1177: THEN
1178: RAISE NO_DATA_FOUND;

Line 1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1185: RETURN l_FORMULA_LINES_tbl;
1186:
1187: EXCEPTION
1188:
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190:
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192:
1193: WHEN OTHERS THEN

Line 1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1187: EXCEPTION
1188:
1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190:
1191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1192:
1193: WHEN OTHERS THEN
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1199: , 'Query_Rows'
1200: );
1201: END IF;
1202:
1203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1204:
1205: END Query_Rows;
1206:
1207: -- Procedure lock_Row

Line 1366: x_return_status := FND_API.G_RET_STS_SUCCESS;

1362: x_FORMULA_LINES_rec := l_FORMULA_LINES_rec;
1363:
1364: -- Set return status
1365:
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1368:
1369: ELSE
1370:

Line 1367: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1363:
1364: -- Set return status
1365:
1366: x_return_status := FND_API.G_RET_STS_SUCCESS;
1367: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1368:
1369: ELSE
1370:
1371: -- Row has changed by another user.

Line 1373: x_return_status := FND_API.G_RET_STS_ERROR;

1369: ELSE
1370:
1371: -- Row has changed by another user.
1372:
1373: x_return_status := FND_API.G_RET_STS_ERROR;
1374: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1375:
1376: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1377: THEN

Line 1374: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;

1370:
1371: -- Row has changed by another user.
1372:
1373: x_return_status := FND_API.G_RET_STS_ERROR;
1374: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1375:
1376: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1377: THEN
1378:

Line 1391: x_return_status := FND_API.G_RET_STS_ERROR;

1387: EXCEPTION
1388:
1389: WHEN NO_DATA_FOUND THEN
1390:
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1395: THEN

Line 1392: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;

1388:
1389: WHEN NO_DATA_FOUND THEN
1390:
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1395: THEN
1396:

Line 1403: x_return_status := FND_API.G_RET_STS_ERROR;

1399:
1400: END IF;
1401: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1402:
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1405:
1406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1407: THEN

Line 1404: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;

1400: END IF;
1401: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1402:
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1405:
1406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1407: THEN
1408:

Line 1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1411:
1412: END IF;
1413: WHEN OTHERS THEN
1414:
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417:
1418: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1419: THEN

Line 1416: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1412: END IF;
1413: WHEN OTHERS THEN
1414:
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: x_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417:
1418: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1419: THEN
1420: OE_MSG_PUB.Add_Exc_Msg

Line 1441: p_FORMULA_LINES_rec.price_formula_id <> FND_API.G_MISS_NUM AND

1437: BEGIN
1438:
1439: oe_debug_pub.add('Entering proc Get_Values in FormulaLines Util Pkg');
1440: IF p_FORMULA_LINES_rec.price_formula_id IS NOT NULL AND
1441: p_FORMULA_LINES_rec.price_formula_id <> FND_API.G_MISS_NUM AND
1442: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_id,
1443: p_old_FORMULA_LINES_rec.price_formula_id)
1444: THEN
1445: l_FORMULA_LINES_val_rec.price_formula := QP_Id_To_Value.Price_Formula

Line 1451: p_FORMULA_LINES_rec.price_formula_line_id <> FND_API.G_MISS_NUM AND

1447: );
1448: END IF;
1449:
1450: IF p_FORMULA_LINES_rec.price_formula_line_id IS NOT NULL AND
1451: p_FORMULA_LINES_rec.price_formula_line_id <> FND_API.G_MISS_NUM AND
1452: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_formula_line_id,
1453: p_old_FORMULA_LINES_rec.price_formula_line_id)
1454: THEN
1455: l_FORMULA_LINES_val_rec.price_formula_line := QP_Id_To_Value.Price_Formula_Line

Line 1461: p_FORMULA_LINES_rec.formula_line_type_code <> FND_API.G_MISS_CHAR AND

1457: );
1458: END IF;
1459:
1460: IF p_FORMULA_LINES_rec.formula_line_type_code IS NOT NULL AND
1461: p_FORMULA_LINES_rec.formula_line_type_code <> FND_API.G_MISS_CHAR AND
1462: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.formula_line_type_code,
1463: p_old_FORMULA_LINES_rec.formula_line_type_code)
1464: THEN
1465: l_FORMULA_LINES_val_rec.price_formula_line_type := QP_Id_To_Value.Price_Formula_Line_Type

Line 1471: p_FORMULA_LINES_rec.price_list_line_id <> FND_API.G_MISS_NUM AND

1467: );
1468: END IF;
1469:
1470: IF p_FORMULA_LINES_rec.price_list_line_id IS NOT NULL AND
1471: p_FORMULA_LINES_rec.price_list_line_id <> FND_API.G_MISS_NUM AND
1472: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_list_line_id,
1473: p_old_FORMULA_LINES_rec.price_list_line_id)
1474: THEN
1475: l_FORMULA_LINES_val_rec.price_list_line := QP_Id_To_Value.Price_List_Line

Line 1481: p_FORMULA_LINES_rec.price_modifier_list_id <> FND_API.G_MISS_NUM AND

1477: );
1478: END IF;
1479:
1480: IF p_FORMULA_LINES_rec.price_modifier_list_id IS NOT NULL AND
1481: p_FORMULA_LINES_rec.price_modifier_list_id <> FND_API.G_MISS_NUM AND
1482: NOT QP_GLOBALS.Equal(p_FORMULA_LINES_rec.price_modifier_list_id,
1483: p_old_FORMULA_LINES_rec.price_modifier_list_id)
1484: THEN
1485: l_FORMULA_LINES_val_rec.price_modifier_list := QP_Id_To_Value.Price_Modifier_List

Line 1508: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1504:
1505: oe_debug_pub.add('Entering proc Get_Ids in FormulaLines Util Pkg');
1506: -- initialize return_status.
1507:
1508: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1509:
1510: -- initialize l_FORMULA_LINES_rec.
1511:
1512: l_FORMULA_LINES_rec := p_FORMULA_LINES_rec;

Line 1514: IF p_FORMULA_LINES_val_rec.price_formula <> FND_API.G_MISS_CHAR

1510: -- initialize l_FORMULA_LINES_rec.
1511:
1512: l_FORMULA_LINES_rec := p_FORMULA_LINES_rec;
1513:
1514: IF p_FORMULA_LINES_val_rec.price_formula <> FND_API.G_MISS_CHAR
1515: THEN
1516:
1517: IF p_FORMULA_LINES_rec.price_formula_id <> FND_API.G_MISS_NUM THEN
1518:

Line 1517: IF p_FORMULA_LINES_rec.price_formula_id <> FND_API.G_MISS_NUM THEN

1513:
1514: IF p_FORMULA_LINES_val_rec.price_formula <> FND_API.G_MISS_CHAR
1515: THEN
1516:
1517: IF p_FORMULA_LINES_rec.price_formula_id <> FND_API.G_MISS_NUM THEN
1518:
1519: l_FORMULA_LINES_rec.price_formula_id := p_FORMULA_LINES_rec.price_formula_id;
1520:
1521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1536: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN

1532: l_FORMULA_LINES_rec.price_formula_id := QP_Value_To_Id.price_formula
1533: ( p_price_formula => p_FORMULA_LINES_val_rec.price_formula
1534: );
1535:
1536: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN
1537: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1538: END IF;
1539:
1540: END IF;

Line 1537: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;

1533: ( p_price_formula => p_FORMULA_LINES_val_rec.price_formula
1534: );
1535:
1536: IF l_FORMULA_LINES_rec.price_formula_id = FND_API.G_MISS_NUM THEN
1537: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1538: END IF;
1539:
1540: END IF;
1541:

Line 1544: IF p_FORMULA_LINES_val_rec.price_formula_line <> FND_API.G_MISS_CHAR

1540: END IF;
1541:
1542: END IF;
1543:
1544: IF p_FORMULA_LINES_val_rec.price_formula_line <> FND_API.G_MISS_CHAR
1545: THEN
1546:
1547: IF p_FORMULA_LINES_rec.price_formula_line_id <> FND_API.G_MISS_NUM THEN
1548:

Line 1547: IF p_FORMULA_LINES_rec.price_formula_line_id <> FND_API.G_MISS_NUM THEN

1543:
1544: IF p_FORMULA_LINES_val_rec.price_formula_line <> FND_API.G_MISS_CHAR
1545: THEN
1546:
1547: IF p_FORMULA_LINES_rec.price_formula_line_id <> FND_API.G_MISS_NUM THEN
1548:
1549: l_FORMULA_LINES_rec.price_formula_line_id := p_FORMULA_LINES_rec.price_formula_line_id;
1550:
1551: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1566: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN

1562: l_FORMULA_LINES_rec.price_formula_line_id := QP_Value_To_Id.price_formula_line
1563: ( p_price_formula_line => p_FORMULA_LINES_val_rec.price_formula_line
1564: );
1565:
1566: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN
1567: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1568: END IF;
1569:
1570: END IF;

Line 1567: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;

1563: ( p_price_formula_line => p_FORMULA_LINES_val_rec.price_formula_line
1564: );
1565:
1566: IF l_FORMULA_LINES_rec.price_formula_line_id = FND_API.G_MISS_NUM THEN
1567: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1568: END IF;
1569:
1570: END IF;
1571:

Line 1574: IF p_FORMULA_LINES_val_rec.price_formula_line_type <> FND_API.G_MISS_CHAR

1570: END IF;
1571:
1572: END IF;
1573:
1574: IF p_FORMULA_LINES_val_rec.price_formula_line_type <> FND_API.G_MISS_CHAR
1575: THEN
1576:
1577: IF p_FORMULA_LINES_rec.formula_line_type_code <> FND_API.G_MISS_CHAR THEN
1578:

Line 1577: IF p_FORMULA_LINES_rec.formula_line_type_code <> FND_API.G_MISS_CHAR THEN

1573:
1574: IF p_FORMULA_LINES_val_rec.price_formula_line_type <> FND_API.G_MISS_CHAR
1575: THEN
1576:
1577: IF p_FORMULA_LINES_rec.formula_line_type_code <> FND_API.G_MISS_CHAR THEN
1578:
1579: l_FORMULA_LINES_rec.formula_line_type_code := p_FORMULA_LINES_rec.formula_line_type_code;
1580:
1581: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1596: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN

1592: l_FORMULA_LINES_rec.formula_line_type_code := QP_Value_To_Id.price_formula_line_type
1593: ( p_price_formula_line_type => p_FORMULA_LINES_val_rec.price_formula_line_type
1594: );
1595:
1596: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN
1597: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1598: END IF;
1599:
1600: END IF;

Line 1597: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;

1593: ( p_price_formula_line_type => p_FORMULA_LINES_val_rec.price_formula_line_type
1594: );
1595:
1596: IF l_FORMULA_LINES_rec.formula_line_type_code = FND_API.G_MISS_CHAR THEN
1597: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1598: END IF;
1599:
1600: END IF;
1601:

Line 1604: IF p_FORMULA_LINES_val_rec.price_list_line <> FND_API.G_MISS_CHAR

1600: END IF;
1601:
1602: END IF;
1603:
1604: IF p_FORMULA_LINES_val_rec.price_list_line <> FND_API.G_MISS_CHAR
1605: THEN
1606:
1607: IF p_FORMULA_LINES_rec.price_list_line_id <> FND_API.G_MISS_NUM THEN
1608:

Line 1607: IF p_FORMULA_LINES_rec.price_list_line_id <> FND_API.G_MISS_NUM THEN

1603:
1604: IF p_FORMULA_LINES_val_rec.price_list_line <> FND_API.G_MISS_CHAR
1605: THEN
1606:
1607: IF p_FORMULA_LINES_rec.price_list_line_id <> FND_API.G_MISS_NUM THEN
1608:
1609: l_FORMULA_LINES_rec.price_list_line_id := p_FORMULA_LINES_rec.price_list_line_id;
1610:
1611: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1626: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN

1622: l_FORMULA_LINES_rec.price_list_line_id := QP_Value_To_Id.price_list_line
1623: ( p_price_list_line => p_FORMULA_LINES_val_rec.price_list_line
1624: );
1625:
1626: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
1627: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1628: END IF;
1629:
1630: END IF;

Line 1627: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;

1623: ( p_price_list_line => p_FORMULA_LINES_val_rec.price_list_line
1624: );
1625:
1626: IF l_FORMULA_LINES_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
1627: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1628: END IF;
1629:
1630: END IF;
1631:

Line 1634: IF p_FORMULA_LINES_val_rec.price_modifier_list <> FND_API.G_MISS_CHAR

1630: END IF;
1631:
1632: END IF;
1633:
1634: IF p_FORMULA_LINES_val_rec.price_modifier_list <> FND_API.G_MISS_CHAR
1635: THEN
1636:
1637: IF p_FORMULA_LINES_rec.price_modifier_list_id <> FND_API.G_MISS_NUM THEN
1638:

Line 1637: IF p_FORMULA_LINES_rec.price_modifier_list_id <> FND_API.G_MISS_NUM THEN

1633:
1634: IF p_FORMULA_LINES_val_rec.price_modifier_list <> FND_API.G_MISS_CHAR
1635: THEN
1636:
1637: IF p_FORMULA_LINES_rec.price_modifier_list_id <> FND_API.G_MISS_NUM THEN
1638:
1639: l_FORMULA_LINES_rec.price_modifier_list_id := p_FORMULA_LINES_rec.price_modifier_list_id;
1640:
1641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1656: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN

1652: l_FORMULA_LINES_rec.price_modifier_list_id := QP_Value_To_Id.price_modifier_list
1653: ( p_price_modifier_list => p_FORMULA_LINES_val_rec.price_modifier_list
1654: );
1655:
1656: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN
1657: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1658: END IF;
1659:
1660: END IF;

Line 1657: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;

1653: ( p_price_modifier_list => p_FORMULA_LINES_val_rec.price_modifier_list
1654: );
1655:
1656: IF l_FORMULA_LINES_rec.price_modifier_list_id = FND_API.G_MISS_NUM THEN
1657: l_FORMULA_LINES_rec.return_status := FND_API.G_RET_STS_ERROR;
1658: END IF;
1659:
1660: END IF;
1661: