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_CON_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_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
13: , p_old_CON_rec IN QP_Attributes_PUB.Con_Rec_Type :=
14: QP_Attributes_PUB.G_MISS_CON_REC
15: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Con_Rec_Type

Line 30: IF p_attr_id = FND_API.G_MISS_NUM THEN

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

Line 525: IF l_CON_rec.attribute1 = FND_API.G_MISS_CHAR THEN

521: IS
522: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
523: BEGIN
524:
525: IF l_CON_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: l_CON_rec.attribute1 := p_old_CON_rec.attribute1;
527: END IF;
528:
529: IF l_CON_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 529: IF l_CON_rec.attribute10 = FND_API.G_MISS_CHAR THEN

525: IF l_CON_rec.attribute1 = FND_API.G_MISS_CHAR THEN
526: l_CON_rec.attribute1 := p_old_CON_rec.attribute1;
527: END IF;
528:
529: IF l_CON_rec.attribute10 = FND_API.G_MISS_CHAR THEN
530: l_CON_rec.attribute10 := p_old_CON_rec.attribute10;
531: END IF;
532:
533: IF l_CON_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 533: IF l_CON_rec.attribute11 = FND_API.G_MISS_CHAR THEN

529: IF l_CON_rec.attribute10 = FND_API.G_MISS_CHAR THEN
530: l_CON_rec.attribute10 := p_old_CON_rec.attribute10;
531: END IF;
532:
533: IF l_CON_rec.attribute11 = FND_API.G_MISS_CHAR THEN
534: l_CON_rec.attribute11 := p_old_CON_rec.attribute11;
535: END IF;
536:
537: IF l_CON_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 537: IF l_CON_rec.attribute12 = FND_API.G_MISS_CHAR THEN

533: IF l_CON_rec.attribute11 = FND_API.G_MISS_CHAR THEN
534: l_CON_rec.attribute11 := p_old_CON_rec.attribute11;
535: END IF;
536:
537: IF l_CON_rec.attribute12 = FND_API.G_MISS_CHAR THEN
538: l_CON_rec.attribute12 := p_old_CON_rec.attribute12;
539: END IF;
540:
541: IF l_CON_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 541: IF l_CON_rec.attribute13 = FND_API.G_MISS_CHAR THEN

537: IF l_CON_rec.attribute12 = FND_API.G_MISS_CHAR THEN
538: l_CON_rec.attribute12 := p_old_CON_rec.attribute12;
539: END IF;
540:
541: IF l_CON_rec.attribute13 = FND_API.G_MISS_CHAR THEN
542: l_CON_rec.attribute13 := p_old_CON_rec.attribute13;
543: END IF;
544:
545: IF l_CON_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 545: IF l_CON_rec.attribute14 = FND_API.G_MISS_CHAR THEN

541: IF l_CON_rec.attribute13 = FND_API.G_MISS_CHAR THEN
542: l_CON_rec.attribute13 := p_old_CON_rec.attribute13;
543: END IF;
544:
545: IF l_CON_rec.attribute14 = FND_API.G_MISS_CHAR THEN
546: l_CON_rec.attribute14 := p_old_CON_rec.attribute14;
547: END IF;
548:
549: IF l_CON_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 549: IF l_CON_rec.attribute15 = FND_API.G_MISS_CHAR THEN

545: IF l_CON_rec.attribute14 = FND_API.G_MISS_CHAR THEN
546: l_CON_rec.attribute14 := p_old_CON_rec.attribute14;
547: END IF;
548:
549: IF l_CON_rec.attribute15 = FND_API.G_MISS_CHAR THEN
550: l_CON_rec.attribute15 := p_old_CON_rec.attribute15;
551: END IF;
552:
553: IF l_CON_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 553: IF l_CON_rec.attribute2 = FND_API.G_MISS_CHAR THEN

549: IF l_CON_rec.attribute15 = FND_API.G_MISS_CHAR THEN
550: l_CON_rec.attribute15 := p_old_CON_rec.attribute15;
551: END IF;
552:
553: IF l_CON_rec.attribute2 = FND_API.G_MISS_CHAR THEN
554: l_CON_rec.attribute2 := p_old_CON_rec.attribute2;
555: END IF;
556:
557: IF l_CON_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 557: IF l_CON_rec.attribute3 = FND_API.G_MISS_CHAR THEN

553: IF l_CON_rec.attribute2 = FND_API.G_MISS_CHAR THEN
554: l_CON_rec.attribute2 := p_old_CON_rec.attribute2;
555: END IF;
556:
557: IF l_CON_rec.attribute3 = FND_API.G_MISS_CHAR THEN
558: l_CON_rec.attribute3 := p_old_CON_rec.attribute3;
559: END IF;
560:
561: IF l_CON_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 561: IF l_CON_rec.attribute4 = FND_API.G_MISS_CHAR THEN

557: IF l_CON_rec.attribute3 = FND_API.G_MISS_CHAR THEN
558: l_CON_rec.attribute3 := p_old_CON_rec.attribute3;
559: END IF;
560:
561: IF l_CON_rec.attribute4 = FND_API.G_MISS_CHAR THEN
562: l_CON_rec.attribute4 := p_old_CON_rec.attribute4;
563: END IF;
564:
565: IF l_CON_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 565: IF l_CON_rec.attribute5 = FND_API.G_MISS_CHAR THEN

561: IF l_CON_rec.attribute4 = FND_API.G_MISS_CHAR THEN
562: l_CON_rec.attribute4 := p_old_CON_rec.attribute4;
563: END IF;
564:
565: IF l_CON_rec.attribute5 = FND_API.G_MISS_CHAR THEN
566: l_CON_rec.attribute5 := p_old_CON_rec.attribute5;
567: END IF;
568:
569: IF l_CON_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 569: IF l_CON_rec.attribute6 = FND_API.G_MISS_CHAR THEN

565: IF l_CON_rec.attribute5 = FND_API.G_MISS_CHAR THEN
566: l_CON_rec.attribute5 := p_old_CON_rec.attribute5;
567: END IF;
568:
569: IF l_CON_rec.attribute6 = FND_API.G_MISS_CHAR THEN
570: l_CON_rec.attribute6 := p_old_CON_rec.attribute6;
571: END IF;
572:
573: IF l_CON_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 573: IF l_CON_rec.attribute7 = FND_API.G_MISS_CHAR THEN

569: IF l_CON_rec.attribute6 = FND_API.G_MISS_CHAR THEN
570: l_CON_rec.attribute6 := p_old_CON_rec.attribute6;
571: END IF;
572:
573: IF l_CON_rec.attribute7 = FND_API.G_MISS_CHAR THEN
574: l_CON_rec.attribute7 := p_old_CON_rec.attribute7;
575: END IF;
576:
577: IF l_CON_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 577: IF l_CON_rec.attribute8 = FND_API.G_MISS_CHAR THEN

573: IF l_CON_rec.attribute7 = FND_API.G_MISS_CHAR THEN
574: l_CON_rec.attribute7 := p_old_CON_rec.attribute7;
575: END IF;
576:
577: IF l_CON_rec.attribute8 = FND_API.G_MISS_CHAR THEN
578: l_CON_rec.attribute8 := p_old_CON_rec.attribute8;
579: END IF;
580:
581: IF l_CON_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 581: IF l_CON_rec.attribute9 = FND_API.G_MISS_CHAR THEN

577: IF l_CON_rec.attribute8 = FND_API.G_MISS_CHAR THEN
578: l_CON_rec.attribute8 := p_old_CON_rec.attribute8;
579: END IF;
580:
581: IF l_CON_rec.attribute9 = FND_API.G_MISS_CHAR THEN
582: l_CON_rec.attribute9 := p_old_CON_rec.attribute9;
583: END IF;
584:
585: IF l_CON_rec.context = FND_API.G_MISS_CHAR THEN

Line 585: IF l_CON_rec.context = FND_API.G_MISS_CHAR THEN

581: IF l_CON_rec.attribute9 = FND_API.G_MISS_CHAR THEN
582: l_CON_rec.attribute9 := p_old_CON_rec.attribute9;
583: END IF;
584:
585: IF l_CON_rec.context = FND_API.G_MISS_CHAR THEN
586: l_CON_rec.context := p_old_CON_rec.context;
587: END IF;
588:
589: IF l_CON_rec.created_by = FND_API.G_MISS_NUM THEN

Line 589: IF l_CON_rec.created_by = FND_API.G_MISS_NUM THEN

585: IF l_CON_rec.context = FND_API.G_MISS_CHAR THEN
586: l_CON_rec.context := p_old_CON_rec.context;
587: END IF;
588:
589: IF l_CON_rec.created_by = FND_API.G_MISS_NUM THEN
590: l_CON_rec.created_by := p_old_CON_rec.created_by;
591: END IF;
592:
593: IF l_CON_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 593: IF l_CON_rec.creation_date = FND_API.G_MISS_DATE THEN

589: IF l_CON_rec.created_by = FND_API.G_MISS_NUM THEN
590: l_CON_rec.created_by := p_old_CON_rec.created_by;
591: END IF;
592:
593: IF l_CON_rec.creation_date = FND_API.G_MISS_DATE THEN
594: l_CON_rec.creation_date := p_old_CON_rec.creation_date;
595: END IF;
596:
597: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

Line 597: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

593: IF l_CON_rec.creation_date = FND_API.G_MISS_DATE THEN
594: l_CON_rec.creation_date := p_old_CON_rec.creation_date;
595: END IF;
596:
597: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
598: l_CON_rec.enabled_flag := p_old_CON_rec.enabled_flag;
599: END IF;
600:
601: IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 601: IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN

597: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
598: l_CON_rec.enabled_flag := p_old_CON_rec.enabled_flag;
599: END IF;
600:
601: IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN
602: l_CON_rec.last_updated_by := p_old_CON_rec.last_updated_by;
603: END IF;
604:
605: IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 605: IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN

601: IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN
602: l_CON_rec.last_updated_by := p_old_CON_rec.last_updated_by;
603: END IF;
604:
605: IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN
606: l_CON_rec.last_update_date := p_old_CON_rec.last_update_date;
607: END IF;
608:
609: IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 609: IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN

605: IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN
606: l_CON_rec.last_update_date := p_old_CON_rec.last_update_date;
607: END IF;
608:
609: IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN
610: l_CON_rec.last_update_login := p_old_CON_rec.last_update_login;
611: END IF;
612:
613: IF l_CON_rec.prc_context_code = FND_API.G_MISS_CHAR THEN

Line 613: IF l_CON_rec.prc_context_code = FND_API.G_MISS_CHAR THEN

609: IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN
610: l_CON_rec.last_update_login := p_old_CON_rec.last_update_login;
611: END IF;
612:
613: IF l_CON_rec.prc_context_code = FND_API.G_MISS_CHAR THEN
614: l_CON_rec.prc_context_code := p_old_CON_rec.prc_context_code;
615: END IF;
616:
617: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN

Line 617: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN

613: IF l_CON_rec.prc_context_code = FND_API.G_MISS_CHAR THEN
614: l_CON_rec.prc_context_code := p_old_CON_rec.prc_context_code;
615: END IF;
616:
617: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN
618: l_CON_rec.prc_context_id := p_old_CON_rec.prc_context_id;
619: END IF;
620:
621: IF l_CON_rec.prc_context_type = FND_API.G_MISS_CHAR THEN

Line 621: IF l_CON_rec.prc_context_type = FND_API.G_MISS_CHAR THEN

617: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN
618: l_CON_rec.prc_context_id := p_old_CON_rec.prc_context_id;
619: END IF;
620:
621: IF l_CON_rec.prc_context_type = FND_API.G_MISS_CHAR THEN
622: l_CON_rec.prc_context_type := p_old_CON_rec.prc_context_type;
623: END IF;
624:
625: IF l_CON_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 625: IF l_CON_rec.program_application_id = FND_API.G_MISS_NUM THEN

621: IF l_CON_rec.prc_context_type = FND_API.G_MISS_CHAR THEN
622: l_CON_rec.prc_context_type := p_old_CON_rec.prc_context_type;
623: END IF;
624:
625: IF l_CON_rec.program_application_id = FND_API.G_MISS_NUM THEN
626: l_CON_rec.program_application_id := p_old_CON_rec.program_application_id;
627: END IF;
628:
629: IF l_CON_rec.program_id = FND_API.G_MISS_NUM THEN

Line 629: IF l_CON_rec.program_id = FND_API.G_MISS_NUM THEN

625: IF l_CON_rec.program_application_id = FND_API.G_MISS_NUM THEN
626: l_CON_rec.program_application_id := p_old_CON_rec.program_application_id;
627: END IF;
628:
629: IF l_CON_rec.program_id = FND_API.G_MISS_NUM THEN
630: l_CON_rec.program_id := p_old_CON_rec.program_id;
631: END IF;
632:
633: IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 633: IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN

629: IF l_CON_rec.program_id = FND_API.G_MISS_NUM THEN
630: l_CON_rec.program_id := p_old_CON_rec.program_id;
631: END IF;
632:
633: IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN
634: l_CON_rec.program_update_date := p_old_CON_rec.program_update_date;
635: END IF;
636:
637: IF l_CON_rec.seeded_description = FND_API.G_MISS_CHAR THEN

Line 637: IF l_CON_rec.seeded_description = FND_API.G_MISS_CHAR THEN

633: IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN
634: l_CON_rec.program_update_date := p_old_CON_rec.program_update_date;
635: END IF;
636:
637: IF l_CON_rec.seeded_description = FND_API.G_MISS_CHAR THEN
638: l_CON_rec.seeded_description := p_old_CON_rec.seeded_description;
639: END IF;
640:
641: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

Line 641: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

637: IF l_CON_rec.seeded_description = FND_API.G_MISS_CHAR THEN
638: l_CON_rec.seeded_description := p_old_CON_rec.seeded_description;
639: END IF;
640:
641: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
642: l_CON_rec.seeded_flag := p_old_CON_rec.seeded_flag;
643: END IF;
644:
645: IF l_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR THEN

Line 645: IF l_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR THEN

641: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
642: l_CON_rec.seeded_flag := p_old_CON_rec.seeded_flag;
643: END IF;
644:
645: IF l_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR THEN
646: l_CON_rec.seeded_prc_context_name := p_old_CON_rec.seeded_prc_context_name;
647: END IF;
648:
649: IF l_CON_rec.user_description = FND_API.G_MISS_CHAR THEN

Line 649: IF l_CON_rec.user_description = FND_API.G_MISS_CHAR THEN

645: IF l_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR THEN
646: l_CON_rec.seeded_prc_context_name := p_old_CON_rec.seeded_prc_context_name;
647: END IF;
648:
649: IF l_CON_rec.user_description = FND_API.G_MISS_CHAR THEN
650: l_CON_rec.user_description := p_old_CON_rec.user_description;
651: END IF;
652:
653: IF l_CON_rec.user_prc_context_name = FND_API.G_MISS_CHAR THEN

Line 653: IF l_CON_rec.user_prc_context_name = FND_API.G_MISS_CHAR THEN

649: IF l_CON_rec.user_description = FND_API.G_MISS_CHAR THEN
650: l_CON_rec.user_description := p_old_CON_rec.user_description;
651: END IF;
652:
653: IF l_CON_rec.user_prc_context_name = FND_API.G_MISS_CHAR THEN
654: l_CON_rec.user_prc_context_name := p_old_CON_rec.user_prc_context_name;
655: END IF;
656:
657: RETURN l_CON_rec;

Line 670: IF l_CON_rec.attribute1 = FND_API.G_MISS_CHAR THEN

666: IS
667: l_CON_rec QP_Attributes_PUB.Con_Rec_Type := p_CON_rec;
668: BEGIN
669:
670: IF l_CON_rec.attribute1 = FND_API.G_MISS_CHAR THEN
671: l_CON_rec.attribute1 := NULL;
672: END IF;
673:
674: IF l_CON_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 674: IF l_CON_rec.attribute10 = FND_API.G_MISS_CHAR THEN

670: IF l_CON_rec.attribute1 = FND_API.G_MISS_CHAR THEN
671: l_CON_rec.attribute1 := NULL;
672: END IF;
673:
674: IF l_CON_rec.attribute10 = FND_API.G_MISS_CHAR THEN
675: l_CON_rec.attribute10 := NULL;
676: END IF;
677:
678: IF l_CON_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 678: IF l_CON_rec.attribute11 = FND_API.G_MISS_CHAR THEN

674: IF l_CON_rec.attribute10 = FND_API.G_MISS_CHAR THEN
675: l_CON_rec.attribute10 := NULL;
676: END IF;
677:
678: IF l_CON_rec.attribute11 = FND_API.G_MISS_CHAR THEN
679: l_CON_rec.attribute11 := NULL;
680: END IF;
681:
682: IF l_CON_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 682: IF l_CON_rec.attribute12 = FND_API.G_MISS_CHAR THEN

678: IF l_CON_rec.attribute11 = FND_API.G_MISS_CHAR THEN
679: l_CON_rec.attribute11 := NULL;
680: END IF;
681:
682: IF l_CON_rec.attribute12 = FND_API.G_MISS_CHAR THEN
683: l_CON_rec.attribute12 := NULL;
684: END IF;
685:
686: IF l_CON_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 686: IF l_CON_rec.attribute13 = FND_API.G_MISS_CHAR THEN

682: IF l_CON_rec.attribute12 = FND_API.G_MISS_CHAR THEN
683: l_CON_rec.attribute12 := NULL;
684: END IF;
685:
686: IF l_CON_rec.attribute13 = FND_API.G_MISS_CHAR THEN
687: l_CON_rec.attribute13 := NULL;
688: END IF;
689:
690: IF l_CON_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 690: IF l_CON_rec.attribute14 = FND_API.G_MISS_CHAR THEN

686: IF l_CON_rec.attribute13 = FND_API.G_MISS_CHAR THEN
687: l_CON_rec.attribute13 := NULL;
688: END IF;
689:
690: IF l_CON_rec.attribute14 = FND_API.G_MISS_CHAR THEN
691: l_CON_rec.attribute14 := NULL;
692: END IF;
693:
694: IF l_CON_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 694: IF l_CON_rec.attribute15 = FND_API.G_MISS_CHAR THEN

690: IF l_CON_rec.attribute14 = FND_API.G_MISS_CHAR THEN
691: l_CON_rec.attribute14 := NULL;
692: END IF;
693:
694: IF l_CON_rec.attribute15 = FND_API.G_MISS_CHAR THEN
695: l_CON_rec.attribute15 := NULL;
696: END IF;
697:
698: IF l_CON_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 698: IF l_CON_rec.attribute2 = FND_API.G_MISS_CHAR THEN

694: IF l_CON_rec.attribute15 = FND_API.G_MISS_CHAR THEN
695: l_CON_rec.attribute15 := NULL;
696: END IF;
697:
698: IF l_CON_rec.attribute2 = FND_API.G_MISS_CHAR THEN
699: l_CON_rec.attribute2 := NULL;
700: END IF;
701:
702: IF l_CON_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 702: IF l_CON_rec.attribute3 = FND_API.G_MISS_CHAR THEN

698: IF l_CON_rec.attribute2 = FND_API.G_MISS_CHAR THEN
699: l_CON_rec.attribute2 := NULL;
700: END IF;
701:
702: IF l_CON_rec.attribute3 = FND_API.G_MISS_CHAR THEN
703: l_CON_rec.attribute3 := NULL;
704: END IF;
705:
706: IF l_CON_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 706: IF l_CON_rec.attribute4 = FND_API.G_MISS_CHAR THEN

702: IF l_CON_rec.attribute3 = FND_API.G_MISS_CHAR THEN
703: l_CON_rec.attribute3 := NULL;
704: END IF;
705:
706: IF l_CON_rec.attribute4 = FND_API.G_MISS_CHAR THEN
707: l_CON_rec.attribute4 := NULL;
708: END IF;
709:
710: IF l_CON_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 710: IF l_CON_rec.attribute5 = FND_API.G_MISS_CHAR THEN

706: IF l_CON_rec.attribute4 = FND_API.G_MISS_CHAR THEN
707: l_CON_rec.attribute4 := NULL;
708: END IF;
709:
710: IF l_CON_rec.attribute5 = FND_API.G_MISS_CHAR THEN
711: l_CON_rec.attribute5 := NULL;
712: END IF;
713:
714: IF l_CON_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 714: IF l_CON_rec.attribute6 = FND_API.G_MISS_CHAR THEN

710: IF l_CON_rec.attribute5 = FND_API.G_MISS_CHAR THEN
711: l_CON_rec.attribute5 := NULL;
712: END IF;
713:
714: IF l_CON_rec.attribute6 = FND_API.G_MISS_CHAR THEN
715: l_CON_rec.attribute6 := NULL;
716: END IF;
717:
718: IF l_CON_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 718: IF l_CON_rec.attribute7 = FND_API.G_MISS_CHAR THEN

714: IF l_CON_rec.attribute6 = FND_API.G_MISS_CHAR THEN
715: l_CON_rec.attribute6 := NULL;
716: END IF;
717:
718: IF l_CON_rec.attribute7 = FND_API.G_MISS_CHAR THEN
719: l_CON_rec.attribute7 := NULL;
720: END IF;
721:
722: IF l_CON_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 722: IF l_CON_rec.attribute8 = FND_API.G_MISS_CHAR THEN

718: IF l_CON_rec.attribute7 = FND_API.G_MISS_CHAR THEN
719: l_CON_rec.attribute7 := NULL;
720: END IF;
721:
722: IF l_CON_rec.attribute8 = FND_API.G_MISS_CHAR THEN
723: l_CON_rec.attribute8 := NULL;
724: END IF;
725:
726: IF l_CON_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 726: IF l_CON_rec.attribute9 = FND_API.G_MISS_CHAR THEN

722: IF l_CON_rec.attribute8 = FND_API.G_MISS_CHAR THEN
723: l_CON_rec.attribute8 := NULL;
724: END IF;
725:
726: IF l_CON_rec.attribute9 = FND_API.G_MISS_CHAR THEN
727: l_CON_rec.attribute9 := NULL;
728: END IF;
729:
730: IF l_CON_rec.context = FND_API.G_MISS_CHAR THEN

Line 730: IF l_CON_rec.context = FND_API.G_MISS_CHAR THEN

726: IF l_CON_rec.attribute9 = FND_API.G_MISS_CHAR THEN
727: l_CON_rec.attribute9 := NULL;
728: END IF;
729:
730: IF l_CON_rec.context = FND_API.G_MISS_CHAR THEN
731: l_CON_rec.context := NULL;
732: END IF;
733:
734: IF l_CON_rec.created_by = FND_API.G_MISS_NUM THEN

Line 734: IF l_CON_rec.created_by = FND_API.G_MISS_NUM THEN

730: IF l_CON_rec.context = FND_API.G_MISS_CHAR THEN
731: l_CON_rec.context := NULL;
732: END IF;
733:
734: IF l_CON_rec.created_by = FND_API.G_MISS_NUM THEN
735: l_CON_rec.created_by := NULL;
736: END IF;
737:
738: IF l_CON_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 738: IF l_CON_rec.creation_date = FND_API.G_MISS_DATE THEN

734: IF l_CON_rec.created_by = FND_API.G_MISS_NUM THEN
735: l_CON_rec.created_by := NULL;
736: END IF;
737:
738: IF l_CON_rec.creation_date = FND_API.G_MISS_DATE THEN
739: l_CON_rec.creation_date := NULL;
740: END IF;
741:
742: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

Line 742: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

738: IF l_CON_rec.creation_date = FND_API.G_MISS_DATE THEN
739: l_CON_rec.creation_date := NULL;
740: END IF;
741:
742: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
743: l_CON_rec.enabled_flag := NULL;
744: END IF;
745:
746: IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 746: IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN

742: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
743: l_CON_rec.enabled_flag := NULL;
744: END IF;
745:
746: IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN
747: l_CON_rec.last_updated_by := NULL;
748: END IF;
749:
750: IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 750: IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN

746: IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN
747: l_CON_rec.last_updated_by := NULL;
748: END IF;
749:
750: IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN
751: l_CON_rec.last_update_date := NULL;
752: END IF;
753:
754: IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 754: IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN

750: IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN
751: l_CON_rec.last_update_date := NULL;
752: END IF;
753:
754: IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN
755: l_CON_rec.last_update_login := NULL;
756: END IF;
757:
758: IF l_CON_rec.prc_context_code = FND_API.G_MISS_CHAR THEN

Line 758: IF l_CON_rec.prc_context_code = FND_API.G_MISS_CHAR THEN

754: IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN
755: l_CON_rec.last_update_login := NULL;
756: END IF;
757:
758: IF l_CON_rec.prc_context_code = FND_API.G_MISS_CHAR THEN
759: l_CON_rec.prc_context_code := NULL;
760: END IF;
761:
762: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN

Line 762: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN

758: IF l_CON_rec.prc_context_code = FND_API.G_MISS_CHAR THEN
759: l_CON_rec.prc_context_code := NULL;
760: END IF;
761:
762: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN
763: l_CON_rec.prc_context_id := NULL;
764: END IF;
765:
766: IF l_CON_rec.prc_context_type = FND_API.G_MISS_CHAR THEN

Line 766: IF l_CON_rec.prc_context_type = FND_API.G_MISS_CHAR THEN

762: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN
763: l_CON_rec.prc_context_id := NULL;
764: END IF;
765:
766: IF l_CON_rec.prc_context_type = FND_API.G_MISS_CHAR THEN
767: l_CON_rec.prc_context_type := NULL;
768: END IF;
769:
770: IF l_CON_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 770: IF l_CON_rec.program_application_id = FND_API.G_MISS_NUM THEN

766: IF l_CON_rec.prc_context_type = FND_API.G_MISS_CHAR THEN
767: l_CON_rec.prc_context_type := NULL;
768: END IF;
769:
770: IF l_CON_rec.program_application_id = FND_API.G_MISS_NUM THEN
771: l_CON_rec.program_application_id := NULL;
772: END IF;
773:
774: IF l_CON_rec.program_id = FND_API.G_MISS_NUM THEN

Line 774: IF l_CON_rec.program_id = FND_API.G_MISS_NUM THEN

770: IF l_CON_rec.program_application_id = FND_API.G_MISS_NUM THEN
771: l_CON_rec.program_application_id := NULL;
772: END IF;
773:
774: IF l_CON_rec.program_id = FND_API.G_MISS_NUM THEN
775: l_CON_rec.program_id := NULL;
776: END IF;
777:
778: IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 778: IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN

774: IF l_CON_rec.program_id = FND_API.G_MISS_NUM THEN
775: l_CON_rec.program_id := NULL;
776: END IF;
777:
778: IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN
779: l_CON_rec.program_update_date := NULL;
780: END IF;
781:
782: IF l_CON_rec.seeded_description = FND_API.G_MISS_CHAR THEN

Line 782: IF l_CON_rec.seeded_description = FND_API.G_MISS_CHAR THEN

778: IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN
779: l_CON_rec.program_update_date := NULL;
780: END IF;
781:
782: IF l_CON_rec.seeded_description = FND_API.G_MISS_CHAR THEN
783: l_CON_rec.seeded_description := NULL;
784: END IF;
785:
786: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

Line 786: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

782: IF l_CON_rec.seeded_description = FND_API.G_MISS_CHAR THEN
783: l_CON_rec.seeded_description := NULL;
784: END IF;
785:
786: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
787: l_CON_rec.seeded_flag := NULL;
788: END IF;
789:
790: IF l_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR THEN

Line 790: IF l_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR THEN

786: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
787: l_CON_rec.seeded_flag := NULL;
788: END IF;
789:
790: IF l_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR THEN
791: l_CON_rec.seeded_prc_context_name := NULL;
792: END IF;
793:
794: IF l_CON_rec.user_description = FND_API.G_MISS_CHAR THEN

Line 794: IF l_CON_rec.user_description = FND_API.G_MISS_CHAR THEN

790: IF l_CON_rec.seeded_prc_context_name = FND_API.G_MISS_CHAR THEN
791: l_CON_rec.seeded_prc_context_name := NULL;
792: END IF;
793:
794: IF l_CON_rec.user_description = FND_API.G_MISS_CHAR THEN
795: l_CON_rec.user_description := NULL;
796: END IF;
797:
798: IF l_CON_rec.user_prc_context_name = FND_API.G_MISS_CHAR THEN

Line 798: IF l_CON_rec.user_prc_context_name = FND_API.G_MISS_CHAR THEN

794: IF l_CON_rec.user_description = FND_API.G_MISS_CHAR THEN
795: l_CON_rec.user_description := NULL;
796: END IF;
797:
798: IF l_CON_rec.user_prc_context_name = FND_API.G_MISS_CHAR THEN
799: l_CON_rec.user_prc_context_name := NULL;
800: END IF;
801:
802: RETURN l_CON_rec;

Line 888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

884: , 'Update_Row'
885: );
886: END IF;
887:
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889:
890: END Update_Row;
891:
892: -- Procedure Insert_Row

Line 1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1037: , 'Insert_Row'
1038: );
1039: END IF;
1040:
1041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1042:
1043: END Insert_Row;
1044:
1045: -- Procedure Delete_Row

Line 1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1087: , 'Delete_Row'
1088: );
1089: END IF;
1090:
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092:
1093: END Delete_Row;
1094:
1095: -- Function Query_Row

Line 1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1184: , 'Query_Row'
1185: );
1186: END IF;
1187:
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189:
1190: END Query_Row;
1191:
1192: -- Procedure lock_Row

Line 1350: x_return_status := FND_API.G_RET_STS_SUCCESS;

1346: x_CON_rec := l_CON_rec;
1347:
1348: -- Set return status
1349:
1350: x_return_status := FND_API.G_RET_STS_SUCCESS;
1351: x_CON_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1352:
1353: ELSE
1354:

Line 1351: x_CON_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1347:
1348: -- Set return status
1349:
1350: x_return_status := FND_API.G_RET_STS_SUCCESS;
1351: x_CON_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1352:
1353: ELSE
1354:
1355: -- Row has changed by another user.

Line 1357: x_return_status := FND_API.G_RET_STS_ERROR;

1353: ELSE
1354:
1355: -- Row has changed by another user.
1356:
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1359:
1360: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1361: THEN

Line 1358: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;

1354:
1355: -- Row has changed by another user.
1356:
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1359:
1360: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1361: THEN
1362:

Line 1374: x_return_status := FND_API.G_RET_STS_ERROR;

1370: EXCEPTION
1371:
1372: WHEN NO_DATA_FOUND THEN
1373:
1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1376:
1377: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1378: THEN

Line 1375: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;

1371:
1372: WHEN NO_DATA_FOUND THEN
1373:
1374: x_return_status := FND_API.G_RET_STS_ERROR;
1375: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1376:
1377: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1378: THEN
1379:

Line 1386: x_return_status := FND_API.G_RET_STS_ERROR;

1382:
1383: END IF;
1384: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1385:
1386: x_return_status := FND_API.G_RET_STS_ERROR;
1387: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1388:
1389: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1390: THEN

Line 1387: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;

1383: END IF;
1384: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1385:
1386: x_return_status := FND_API.G_RET_STS_ERROR;
1387: x_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1388:
1389: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1390: THEN
1391:

Line 1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1394:
1395: END IF;
1396: WHEN OTHERS THEN
1397:
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399: x_CON_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1400:
1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN

Line 1399: x_CON_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1395: END IF;
1396: WHEN OTHERS THEN
1397:
1398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1399: x_CON_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1400:
1401: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1402: THEN
1403: OE_MSG_PUB.Add_Exc_Msg

Line 1423: p_CON_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

1419: l_CON_val_rec QP_Attributes_PUB.Con_Val_Rec_Type;
1420: BEGIN
1421:
1422: IF p_CON_rec.enabled_flag IS NOT NULL AND
1423: p_CON_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1424: NOT QP_GLOBALS.Equal(p_CON_rec.enabled_flag,
1425: p_old_CON_rec.enabled_flag)
1426: THEN
1427: l_CON_val_rec.enabled := QP_Id_To_Value.Enabled

Line 1433: p_CON_rec.prc_context_id <> FND_API.G_MISS_NUM AND

1429: );
1430: END IF;
1431:
1432: IF p_CON_rec.prc_context_id IS NOT NULL AND
1433: p_CON_rec.prc_context_id <> FND_API.G_MISS_NUM AND
1434: NOT QP_GLOBALS.Equal(p_CON_rec.prc_context_id,
1435: p_old_CON_rec.prc_context_id)
1436: THEN
1437: l_CON_val_rec.prc_context := QP_Id_To_Value.Prc_Context

Line 1443: p_CON_rec.seeded_flag <> FND_API.G_MISS_CHAR AND

1439: );
1440: END IF;
1441:
1442: IF p_CON_rec.seeded_flag IS NOT NULL AND
1443: p_CON_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1444: NOT QP_GLOBALS.Equal(p_CON_rec.seeded_flag,
1445: p_old_CON_rec.seeded_flag)
1446: THEN
1447: l_CON_val_rec.seeded := QP_Id_To_Value.Seeded

Line 1468: l_CON_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1464: BEGIN
1465:
1466: -- initialize return_status.
1467:
1468: l_CON_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1469:
1470: -- initialize l_CON_rec.
1471:
1472: l_CON_rec := p_CON_rec;

Line 1474: IF p_CON_val_rec.enabled <> FND_API.G_MISS_CHAR

1470: -- initialize l_CON_rec.
1471:
1472: l_CON_rec := p_CON_rec;
1473:
1474: IF p_CON_val_rec.enabled <> FND_API.G_MISS_CHAR
1475: THEN
1476:
1477: IF p_CON_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1478:

Line 1477: IF p_CON_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN

1473:
1474: IF p_CON_val_rec.enabled <> FND_API.G_MISS_CHAR
1475: THEN
1476:
1477: IF p_CON_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1478:
1479: l_CON_rec.enabled_flag := p_CON_rec.enabled_flag;
1480:
1481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1496: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

1492: l_CON_rec.enabled_flag := QP_Value_To_Id.enabled
1493: ( p_enabled => p_CON_val_rec.enabled
1494: );
1495:
1496: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
1497: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1498: END IF;
1499:
1500: END IF;

Line 1497: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;

1493: ( p_enabled => p_CON_val_rec.enabled
1494: );
1495:
1496: IF l_CON_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
1497: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1498: END IF;
1499:
1500: END IF;
1501:

Line 1504: IF p_CON_val_rec.prc_context <> FND_API.G_MISS_CHAR

1500: END IF;
1501:
1502: END IF;
1503:
1504: IF p_CON_val_rec.prc_context <> FND_API.G_MISS_CHAR
1505: THEN
1506:
1507: IF p_CON_rec.prc_context_id <> FND_API.G_MISS_NUM THEN
1508:

Line 1507: IF p_CON_rec.prc_context_id <> FND_API.G_MISS_NUM THEN

1503:
1504: IF p_CON_val_rec.prc_context <> FND_API.G_MISS_CHAR
1505: THEN
1506:
1507: IF p_CON_rec.prc_context_id <> FND_API.G_MISS_NUM THEN
1508:
1509: l_CON_rec.prc_context_id := p_CON_rec.prc_context_id;
1510:
1511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1526: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN

1522: l_CON_rec.prc_context_id := QP_Value_To_Id.prc_context
1523: ( p_prc_context => p_CON_val_rec.prc_context
1524: );
1525:
1526: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN
1527: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1528: END IF;
1529:
1530: END IF;

Line 1527: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;

1523: ( p_prc_context => p_CON_val_rec.prc_context
1524: );
1525:
1526: IF l_CON_rec.prc_context_id = FND_API.G_MISS_NUM THEN
1527: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1528: END IF;
1529:
1530: END IF;
1531:

Line 1534: IF p_CON_val_rec.seeded <> FND_API.G_MISS_CHAR

1530: END IF;
1531:
1532: END IF;
1533:
1534: IF p_CON_val_rec.seeded <> FND_API.G_MISS_CHAR
1535: THEN
1536:
1537: IF p_CON_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
1538:

Line 1537: IF p_CON_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN

1533:
1534: IF p_CON_val_rec.seeded <> FND_API.G_MISS_CHAR
1535: THEN
1536:
1537: IF p_CON_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
1538:
1539: l_CON_rec.seeded_flag := p_CON_rec.seeded_flag;
1540:
1541: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1556: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

1552: l_CON_rec.seeded_flag := QP_Value_To_Id.seeded
1553: ( p_seeded => p_CON_val_rec.seeded
1554: );
1555:
1556: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
1557: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1558: END IF;
1559:
1560: END IF;

Line 1557: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;

1553: ( p_seeded => p_CON_val_rec.seeded
1554: );
1555:
1556: IF l_CON_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
1557: l_CON_rec.return_status := FND_API.G_RET_STS_ERROR;
1558: END IF;
1559:
1560: END IF;
1561: