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_CURR_LISTS_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_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type
13: , p_old_CURR_LISTS_rec IN QP_Currency_PUB.Curr_Lists_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_LISTS_REC
15: , x_CURR_LISTS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Lists_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_CURR_LISTS_rec.attribute1,p_old_CURR_LISTS_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 458: IF p_old_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR

454: raise list_already_attached;
455:
456: Exception
457: WHEN NO_DATA_FOUND THEN
458: IF p_old_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR
459: THEN
460:
461: -- Update details record's to_currency_code with new base_currency_code
462: Update QP_CURRENCY_DETAILS

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480:
481: FND_MESSAGE.SET_NAME('QP','QP_MCURR_ATTCHD_TO_PRL'); -- CHANGE
482: OE_MSG_PUB.Add;
483:
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: WHEN list_already_attached THEN
486: -- oe_debug_pub.add('ERROR: This Multi-Currency is attached to a Price List, so Base Currency Code can not be modified');
487:
488: FND_MESSAGE.SET_NAME('QP','QP_MCURR_ATTCHD_TO_PRL'); -- CHANGE

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487:
488: FND_MESSAGE.SET_NAME('QP','QP_MCURR_ATTCHD_TO_PRL'); -- CHANGE
489: OE_MSG_PUB.Add;
490:
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492:
493: End;
494: END IF;
495:

Line 605: IF l_CURR_LISTS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

601: IS
602: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
603: BEGIN
604:
605: IF l_CURR_LISTS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
606: l_CURR_LISTS_rec.attribute1 := p_old_CURR_LISTS_rec.attribute1;
607: END IF;
608:
609: IF l_CURR_LISTS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 609: IF l_CURR_LISTS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

605: IF l_CURR_LISTS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
606: l_CURR_LISTS_rec.attribute1 := p_old_CURR_LISTS_rec.attribute1;
607: END IF;
608:
609: IF l_CURR_LISTS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
610: l_CURR_LISTS_rec.attribute10 := p_old_CURR_LISTS_rec.attribute10;
611: END IF;
612:
613: IF l_CURR_LISTS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 613: IF l_CURR_LISTS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

609: IF l_CURR_LISTS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
610: l_CURR_LISTS_rec.attribute10 := p_old_CURR_LISTS_rec.attribute10;
611: END IF;
612:
613: IF l_CURR_LISTS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
614: l_CURR_LISTS_rec.attribute11 := p_old_CURR_LISTS_rec.attribute11;
615: END IF;
616:
617: IF l_CURR_LISTS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 617: IF l_CURR_LISTS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

613: IF l_CURR_LISTS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
614: l_CURR_LISTS_rec.attribute11 := p_old_CURR_LISTS_rec.attribute11;
615: END IF;
616:
617: IF l_CURR_LISTS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
618: l_CURR_LISTS_rec.attribute12 := p_old_CURR_LISTS_rec.attribute12;
619: END IF;
620:
621: IF l_CURR_LISTS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 621: IF l_CURR_LISTS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

617: IF l_CURR_LISTS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
618: l_CURR_LISTS_rec.attribute12 := p_old_CURR_LISTS_rec.attribute12;
619: END IF;
620:
621: IF l_CURR_LISTS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
622: l_CURR_LISTS_rec.attribute13 := p_old_CURR_LISTS_rec.attribute13;
623: END IF;
624:
625: IF l_CURR_LISTS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 625: IF l_CURR_LISTS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

621: IF l_CURR_LISTS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
622: l_CURR_LISTS_rec.attribute13 := p_old_CURR_LISTS_rec.attribute13;
623: END IF;
624:
625: IF l_CURR_LISTS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
626: l_CURR_LISTS_rec.attribute14 := p_old_CURR_LISTS_rec.attribute14;
627: END IF;
628:
629: IF l_CURR_LISTS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 629: IF l_CURR_LISTS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

625: IF l_CURR_LISTS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
626: l_CURR_LISTS_rec.attribute14 := p_old_CURR_LISTS_rec.attribute14;
627: END IF;
628:
629: IF l_CURR_LISTS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
630: l_CURR_LISTS_rec.attribute15 := p_old_CURR_LISTS_rec.attribute15;
631: END IF;
632:
633: IF l_CURR_LISTS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 633: IF l_CURR_LISTS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

629: IF l_CURR_LISTS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
630: l_CURR_LISTS_rec.attribute15 := p_old_CURR_LISTS_rec.attribute15;
631: END IF;
632:
633: IF l_CURR_LISTS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
634: l_CURR_LISTS_rec.attribute2 := p_old_CURR_LISTS_rec.attribute2;
635: END IF;
636:
637: IF l_CURR_LISTS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 637: IF l_CURR_LISTS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

633: IF l_CURR_LISTS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
634: l_CURR_LISTS_rec.attribute2 := p_old_CURR_LISTS_rec.attribute2;
635: END IF;
636:
637: IF l_CURR_LISTS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
638: l_CURR_LISTS_rec.attribute3 := p_old_CURR_LISTS_rec.attribute3;
639: END IF;
640:
641: IF l_CURR_LISTS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 641: IF l_CURR_LISTS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

637: IF l_CURR_LISTS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
638: l_CURR_LISTS_rec.attribute3 := p_old_CURR_LISTS_rec.attribute3;
639: END IF;
640:
641: IF l_CURR_LISTS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
642: l_CURR_LISTS_rec.attribute4 := p_old_CURR_LISTS_rec.attribute4;
643: END IF;
644:
645: IF l_CURR_LISTS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 645: IF l_CURR_LISTS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

641: IF l_CURR_LISTS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
642: l_CURR_LISTS_rec.attribute4 := p_old_CURR_LISTS_rec.attribute4;
643: END IF;
644:
645: IF l_CURR_LISTS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
646: l_CURR_LISTS_rec.attribute5 := p_old_CURR_LISTS_rec.attribute5;
647: END IF;
648:
649: IF l_CURR_LISTS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 649: IF l_CURR_LISTS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

645: IF l_CURR_LISTS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
646: l_CURR_LISTS_rec.attribute5 := p_old_CURR_LISTS_rec.attribute5;
647: END IF;
648:
649: IF l_CURR_LISTS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
650: l_CURR_LISTS_rec.attribute6 := p_old_CURR_LISTS_rec.attribute6;
651: END IF;
652:
653: IF l_CURR_LISTS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 653: IF l_CURR_LISTS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

649: IF l_CURR_LISTS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
650: l_CURR_LISTS_rec.attribute6 := p_old_CURR_LISTS_rec.attribute6;
651: END IF;
652:
653: IF l_CURR_LISTS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
654: l_CURR_LISTS_rec.attribute7 := p_old_CURR_LISTS_rec.attribute7;
655: END IF;
656:
657: IF l_CURR_LISTS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 657: IF l_CURR_LISTS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

653: IF l_CURR_LISTS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
654: l_CURR_LISTS_rec.attribute7 := p_old_CURR_LISTS_rec.attribute7;
655: END IF;
656:
657: IF l_CURR_LISTS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
658: l_CURR_LISTS_rec.attribute8 := p_old_CURR_LISTS_rec.attribute8;
659: END IF;
660:
661: IF l_CURR_LISTS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 661: IF l_CURR_LISTS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

657: IF l_CURR_LISTS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
658: l_CURR_LISTS_rec.attribute8 := p_old_CURR_LISTS_rec.attribute8;
659: END IF;
660:
661: IF l_CURR_LISTS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
662: l_CURR_LISTS_rec.attribute9 := p_old_CURR_LISTS_rec.attribute9;
663: END IF;
664:
665: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN

Line 665: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN

661: IF l_CURR_LISTS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
662: l_CURR_LISTS_rec.attribute9 := p_old_CURR_LISTS_rec.attribute9;
663: END IF;
664:
665: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN
666: l_CURR_LISTS_rec.base_currency_code := p_old_CURR_LISTS_rec.base_currency_code;
667: END IF;
668:
669: IF l_CURR_LISTS_rec.context = FND_API.G_MISS_CHAR THEN

Line 669: IF l_CURR_LISTS_rec.context = FND_API.G_MISS_CHAR THEN

665: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN
666: l_CURR_LISTS_rec.base_currency_code := p_old_CURR_LISTS_rec.base_currency_code;
667: END IF;
668:
669: IF l_CURR_LISTS_rec.context = FND_API.G_MISS_CHAR THEN
670: l_CURR_LISTS_rec.context := p_old_CURR_LISTS_rec.context;
671: END IF;
672:
673: IF l_CURR_LISTS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 673: IF l_CURR_LISTS_rec.created_by = FND_API.G_MISS_NUM THEN

669: IF l_CURR_LISTS_rec.context = FND_API.G_MISS_CHAR THEN
670: l_CURR_LISTS_rec.context := p_old_CURR_LISTS_rec.context;
671: END IF;
672:
673: IF l_CURR_LISTS_rec.created_by = FND_API.G_MISS_NUM THEN
674: l_CURR_LISTS_rec.created_by := p_old_CURR_LISTS_rec.created_by;
675: END IF;
676:
677: IF l_CURR_LISTS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 677: IF l_CURR_LISTS_rec.creation_date = FND_API.G_MISS_DATE THEN

673: IF l_CURR_LISTS_rec.created_by = FND_API.G_MISS_NUM THEN
674: l_CURR_LISTS_rec.created_by := p_old_CURR_LISTS_rec.created_by;
675: END IF;
676:
677: IF l_CURR_LISTS_rec.creation_date = FND_API.G_MISS_DATE THEN
678: l_CURR_LISTS_rec.creation_date := p_old_CURR_LISTS_rec.creation_date;
679: END IF;
680:
681: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

Line 681: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

677: IF l_CURR_LISTS_rec.creation_date = FND_API.G_MISS_DATE THEN
678: l_CURR_LISTS_rec.creation_date := p_old_CURR_LISTS_rec.creation_date;
679: END IF;
680:
681: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
682: l_CURR_LISTS_rec.currency_header_id := p_old_CURR_LISTS_rec.currency_header_id;
683: END IF;
684:
685: IF l_CURR_LISTS_rec.description = FND_API.G_MISS_CHAR THEN

Line 685: IF l_CURR_LISTS_rec.description = FND_API.G_MISS_CHAR THEN

681: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
682: l_CURR_LISTS_rec.currency_header_id := p_old_CURR_LISTS_rec.currency_header_id;
683: END IF;
684:
685: IF l_CURR_LISTS_rec.description = FND_API.G_MISS_CHAR THEN
686: l_CURR_LISTS_rec.description := p_old_CURR_LISTS_rec.description;
687: END IF;
688:
689: -- Added by Sunil Pandey 10/01/01

Line 690: IF l_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM THEN

686: l_CURR_LISTS_rec.description := p_old_CURR_LISTS_rec.description;
687: END IF;
688:
689: -- Added by Sunil Pandey 10/01/01
690: IF l_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM THEN
691: l_CURR_LISTS_rec.base_rounding_factor := p_old_CURR_LISTS_rec.base_rounding_factor;
692: END IF;
693:
694: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN

Line 694: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN

690: IF l_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM THEN
691: l_CURR_LISTS_rec.base_rounding_factor := p_old_CURR_LISTS_rec.base_rounding_factor;
692: END IF;
693:
694: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN
695: l_CURR_LISTS_rec.base_markup_formula_id := p_old_CURR_LISTS_rec.base_markup_formula_id;
696: END IF;
697:
698: IF l_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR THEN

Line 698: IF l_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR THEN

694: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN
695: l_CURR_LISTS_rec.base_markup_formula_id := p_old_CURR_LISTS_rec.base_markup_formula_id;
696: END IF;
697:
698: IF l_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR THEN
699: l_CURR_LISTS_rec.base_markup_operator := p_old_CURR_LISTS_rec.base_markup_operator;
700: END IF;
701:
702: IF l_CURR_LISTS_rec.base_markup_value = FND_API.G_MISS_NUM THEN

Line 702: IF l_CURR_LISTS_rec.base_markup_value = FND_API.G_MISS_NUM THEN

698: IF l_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR THEN
699: l_CURR_LISTS_rec.base_markup_operator := p_old_CURR_LISTS_rec.base_markup_operator;
700: END IF;
701:
702: IF l_CURR_LISTS_rec.base_markup_value = FND_API.G_MISS_NUM THEN
703: l_CURR_LISTS_rec.base_markup_value := p_old_CURR_LISTS_rec.base_markup_value;
704: END IF;
705: -- Added by Sunil Pandey 10/01/01
706:

Line 707: IF l_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

703: l_CURR_LISTS_rec.base_markup_value := p_old_CURR_LISTS_rec.base_markup_value;
704: END IF;
705: -- Added by Sunil Pandey 10/01/01
706:
707: IF l_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
708: l_CURR_LISTS_rec.last_updated_by := p_old_CURR_LISTS_rec.last_updated_by;
709: END IF;
710:
711: IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 711: IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN

707: IF l_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
708: l_CURR_LISTS_rec.last_updated_by := p_old_CURR_LISTS_rec.last_updated_by;
709: END IF;
710:
711: IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN
712: l_CURR_LISTS_rec.last_update_date := p_old_CURR_LISTS_rec.last_update_date;
713: END IF;
714:
715: IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 715: IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN

711: IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN
712: l_CURR_LISTS_rec.last_update_date := p_old_CURR_LISTS_rec.last_update_date;
713: END IF;
714:
715: IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN
716: l_CURR_LISTS_rec.last_update_login := p_old_CURR_LISTS_rec.last_update_login;
717: END IF;
718:
719: IF l_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR THEN

Line 719: IF l_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR THEN

715: IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN
716: l_CURR_LISTS_rec.last_update_login := p_old_CURR_LISTS_rec.last_update_login;
717: END IF;
718:
719: IF l_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR THEN
720: l_CURR_LISTS_rec.name := p_old_CURR_LISTS_rec.name;
721: END IF;
722:
723: IF l_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 723: IF l_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM THEN

719: IF l_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR THEN
720: l_CURR_LISTS_rec.name := p_old_CURR_LISTS_rec.name;
721: END IF;
722:
723: IF l_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM THEN
724: l_CURR_LISTS_rec.program_application_id := p_old_CURR_LISTS_rec.program_application_id;
725: END IF;
726:
727: IF l_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 727: IF l_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM THEN

723: IF l_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM THEN
724: l_CURR_LISTS_rec.program_application_id := p_old_CURR_LISTS_rec.program_application_id;
725: END IF;
726:
727: IF l_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM THEN
728: l_CURR_LISTS_rec.program_id := p_old_CURR_LISTS_rec.program_id;
729: END IF;
730:
731: IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 731: IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN

727: IF l_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM THEN
728: l_CURR_LISTS_rec.program_id := p_old_CURR_LISTS_rec.program_id;
729: END IF;
730:
731: IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN
732: l_CURR_LISTS_rec.program_update_date := p_old_CURR_LISTS_rec.program_update_date;
733: END IF;
734:
735: IF l_CURR_LISTS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 735: IF l_CURR_LISTS_rec.request_id = FND_API.G_MISS_NUM THEN

731: IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN
732: l_CURR_LISTS_rec.program_update_date := p_old_CURR_LISTS_rec.program_update_date;
733: END IF;
734:
735: IF l_CURR_LISTS_rec.request_id = FND_API.G_MISS_NUM THEN
736: l_CURR_LISTS_rec.request_id := p_old_CURR_LISTS_rec.request_id;
737: END IF;
738:
739: /* Commented by Sunil

Line 740: IF l_CURR_LISTS_rec.row_id = FND_API.G_MISS_NUM THEN

736: l_CURR_LISTS_rec.request_id := p_old_CURR_LISTS_rec.request_id;
737: END IF;
738:
739: /* Commented by Sunil
740: IF l_CURR_LISTS_rec.row_id = FND_API.G_MISS_NUM THEN
741: l_CURR_LISTS_rec.row_id := p_old_CURR_LISTS_rec.row_id;
742: END IF;
743: Commented by Sunil */
744:

Line 758: IF l_CURR_LISTS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

754: IS
755: l_CURR_LISTS_rec QP_Currency_PUB.Curr_Lists_Rec_Type := p_CURR_LISTS_rec;
756: BEGIN
757:
758: IF l_CURR_LISTS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
759: l_CURR_LISTS_rec.attribute1 := NULL;
760: END IF;
761:
762: IF l_CURR_LISTS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 762: IF l_CURR_LISTS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

758: IF l_CURR_LISTS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
759: l_CURR_LISTS_rec.attribute1 := NULL;
760: END IF;
761:
762: IF l_CURR_LISTS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
763: l_CURR_LISTS_rec.attribute10 := NULL;
764: END IF;
765:
766: IF l_CURR_LISTS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 766: IF l_CURR_LISTS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

762: IF l_CURR_LISTS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
763: l_CURR_LISTS_rec.attribute10 := NULL;
764: END IF;
765:
766: IF l_CURR_LISTS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
767: l_CURR_LISTS_rec.attribute11 := NULL;
768: END IF;
769:
770: IF l_CURR_LISTS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 770: IF l_CURR_LISTS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

766: IF l_CURR_LISTS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
767: l_CURR_LISTS_rec.attribute11 := NULL;
768: END IF;
769:
770: IF l_CURR_LISTS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
771: l_CURR_LISTS_rec.attribute12 := NULL;
772: END IF;
773:
774: IF l_CURR_LISTS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 774: IF l_CURR_LISTS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

770: IF l_CURR_LISTS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
771: l_CURR_LISTS_rec.attribute12 := NULL;
772: END IF;
773:
774: IF l_CURR_LISTS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
775: l_CURR_LISTS_rec.attribute13 := NULL;
776: END IF;
777:
778: IF l_CURR_LISTS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 778: IF l_CURR_LISTS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

774: IF l_CURR_LISTS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
775: l_CURR_LISTS_rec.attribute13 := NULL;
776: END IF;
777:
778: IF l_CURR_LISTS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
779: l_CURR_LISTS_rec.attribute14 := NULL;
780: END IF;
781:
782: IF l_CURR_LISTS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 782: IF l_CURR_LISTS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

778: IF l_CURR_LISTS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
779: l_CURR_LISTS_rec.attribute14 := NULL;
780: END IF;
781:
782: IF l_CURR_LISTS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
783: l_CURR_LISTS_rec.attribute15 := NULL;
784: END IF;
785:
786: IF l_CURR_LISTS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 786: IF l_CURR_LISTS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

782: IF l_CURR_LISTS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
783: l_CURR_LISTS_rec.attribute15 := NULL;
784: END IF;
785:
786: IF l_CURR_LISTS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
787: l_CURR_LISTS_rec.attribute2 := NULL;
788: END IF;
789:
790: IF l_CURR_LISTS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 790: IF l_CURR_LISTS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

786: IF l_CURR_LISTS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
787: l_CURR_LISTS_rec.attribute2 := NULL;
788: END IF;
789:
790: IF l_CURR_LISTS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
791: l_CURR_LISTS_rec.attribute3 := NULL;
792: END IF;
793:
794: IF l_CURR_LISTS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 794: IF l_CURR_LISTS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

790: IF l_CURR_LISTS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
791: l_CURR_LISTS_rec.attribute3 := NULL;
792: END IF;
793:
794: IF l_CURR_LISTS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
795: l_CURR_LISTS_rec.attribute4 := NULL;
796: END IF;
797:
798: IF l_CURR_LISTS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 798: IF l_CURR_LISTS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

794: IF l_CURR_LISTS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
795: l_CURR_LISTS_rec.attribute4 := NULL;
796: END IF;
797:
798: IF l_CURR_LISTS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
799: l_CURR_LISTS_rec.attribute5 := NULL;
800: END IF;
801:
802: IF l_CURR_LISTS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 802: IF l_CURR_LISTS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

798: IF l_CURR_LISTS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
799: l_CURR_LISTS_rec.attribute5 := NULL;
800: END IF;
801:
802: IF l_CURR_LISTS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
803: l_CURR_LISTS_rec.attribute6 := NULL;
804: END IF;
805:
806: IF l_CURR_LISTS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 806: IF l_CURR_LISTS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

802: IF l_CURR_LISTS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
803: l_CURR_LISTS_rec.attribute6 := NULL;
804: END IF;
805:
806: IF l_CURR_LISTS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
807: l_CURR_LISTS_rec.attribute7 := NULL;
808: END IF;
809:
810: IF l_CURR_LISTS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 810: IF l_CURR_LISTS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

806: IF l_CURR_LISTS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
807: l_CURR_LISTS_rec.attribute7 := NULL;
808: END IF;
809:
810: IF l_CURR_LISTS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
811: l_CURR_LISTS_rec.attribute8 := NULL;
812: END IF;
813:
814: IF l_CURR_LISTS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 814: IF l_CURR_LISTS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

810: IF l_CURR_LISTS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
811: l_CURR_LISTS_rec.attribute8 := NULL;
812: END IF;
813:
814: IF l_CURR_LISTS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
815: l_CURR_LISTS_rec.attribute9 := NULL;
816: END IF;
817:
818: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN

Line 818: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN

814: IF l_CURR_LISTS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
815: l_CURR_LISTS_rec.attribute9 := NULL;
816: END IF;
817:
818: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN
819: l_CURR_LISTS_rec.base_currency_code := NULL;
820: END IF;
821:
822: IF l_CURR_LISTS_rec.context = FND_API.G_MISS_CHAR THEN

Line 822: IF l_CURR_LISTS_rec.context = FND_API.G_MISS_CHAR THEN

818: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN
819: l_CURR_LISTS_rec.base_currency_code := NULL;
820: END IF;
821:
822: IF l_CURR_LISTS_rec.context = FND_API.G_MISS_CHAR THEN
823: l_CURR_LISTS_rec.context := NULL;
824: END IF;
825:
826: IF l_CURR_LISTS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 826: IF l_CURR_LISTS_rec.created_by = FND_API.G_MISS_NUM THEN

822: IF l_CURR_LISTS_rec.context = FND_API.G_MISS_CHAR THEN
823: l_CURR_LISTS_rec.context := NULL;
824: END IF;
825:
826: IF l_CURR_LISTS_rec.created_by = FND_API.G_MISS_NUM THEN
827: l_CURR_LISTS_rec.created_by := NULL;
828: END IF;
829:
830: IF l_CURR_LISTS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 830: IF l_CURR_LISTS_rec.creation_date = FND_API.G_MISS_DATE THEN

826: IF l_CURR_LISTS_rec.created_by = FND_API.G_MISS_NUM THEN
827: l_CURR_LISTS_rec.created_by := NULL;
828: END IF;
829:
830: IF l_CURR_LISTS_rec.creation_date = FND_API.G_MISS_DATE THEN
831: l_CURR_LISTS_rec.creation_date := NULL;
832: END IF;
833:
834: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

Line 834: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

830: IF l_CURR_LISTS_rec.creation_date = FND_API.G_MISS_DATE THEN
831: l_CURR_LISTS_rec.creation_date := NULL;
832: END IF;
833:
834: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
835: l_CURR_LISTS_rec.currency_header_id := NULL;
836: END IF;
837:
838: IF l_CURR_LISTS_rec.description = FND_API.G_MISS_CHAR THEN

Line 838: IF l_CURR_LISTS_rec.description = FND_API.G_MISS_CHAR THEN

834: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
835: l_CURR_LISTS_rec.currency_header_id := NULL;
836: END IF;
837:
838: IF l_CURR_LISTS_rec.description = FND_API.G_MISS_CHAR THEN
839: l_CURR_LISTS_rec.description := NULL;
840: END IF;
841:
842: IF l_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 842: IF l_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

838: IF l_CURR_LISTS_rec.description = FND_API.G_MISS_CHAR THEN
839: l_CURR_LISTS_rec.description := NULL;
840: END IF;
841:
842: IF l_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
843: l_CURR_LISTS_rec.last_updated_by := NULL;
844: END IF;
845:
846: IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 846: IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN

842: IF l_CURR_LISTS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
843: l_CURR_LISTS_rec.last_updated_by := NULL;
844: END IF;
845:
846: IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN
847: l_CURR_LISTS_rec.last_update_date := NULL;
848: END IF;
849:
850: IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 850: IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN

846: IF l_CURR_LISTS_rec.last_update_date = FND_API.G_MISS_DATE THEN
847: l_CURR_LISTS_rec.last_update_date := NULL;
848: END IF;
849:
850: IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN
851: l_CURR_LISTS_rec.last_update_login := NULL;
852: END IF;
853:
854: IF l_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR THEN

Line 854: IF l_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR THEN

850: IF l_CURR_LISTS_rec.last_update_login = FND_API.G_MISS_NUM THEN
851: l_CURR_LISTS_rec.last_update_login := NULL;
852: END IF;
853:
854: IF l_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR THEN
855: l_CURR_LISTS_rec.name := NULL;
856: END IF;
857:
858: IF l_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 858: IF l_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM THEN

854: IF l_CURR_LISTS_rec.name = FND_API.G_MISS_CHAR THEN
855: l_CURR_LISTS_rec.name := NULL;
856: END IF;
857:
858: IF l_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM THEN
859: l_CURR_LISTS_rec.program_application_id := NULL;
860: END IF;
861:
862: IF l_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 862: IF l_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM THEN

858: IF l_CURR_LISTS_rec.program_application_id = FND_API.G_MISS_NUM THEN
859: l_CURR_LISTS_rec.program_application_id := NULL;
860: END IF;
861:
862: IF l_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM THEN
863: l_CURR_LISTS_rec.program_id := NULL;
864: END IF;
865:
866: IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 866: IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN

862: IF l_CURR_LISTS_rec.program_id = FND_API.G_MISS_NUM THEN
863: l_CURR_LISTS_rec.program_id := NULL;
864: END IF;
865:
866: IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN
867: l_CURR_LISTS_rec.program_update_date := NULL;
868: END IF;
869:
870: IF l_CURR_LISTS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 870: IF l_CURR_LISTS_rec.request_id = FND_API.G_MISS_NUM THEN

866: IF l_CURR_LISTS_rec.program_update_date = FND_API.G_MISS_DATE THEN
867: l_CURR_LISTS_rec.program_update_date := NULL;
868: END IF;
869:
870: IF l_CURR_LISTS_rec.request_id = FND_API.G_MISS_NUM THEN
871: l_CURR_LISTS_rec.request_id := NULL;
872: END IF;
873:
874: -- Added by Sunil Pandey 10/01/01

Line 875: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN

871: l_CURR_LISTS_rec.request_id := NULL;
872: END IF;
873:
874: -- Added by Sunil Pandey 10/01/01
875: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN
876: l_CURR_LISTS_rec.base_markup_formula_id := NULL;
877: END IF;
878:
879: IF l_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR THEN

Line 879: IF l_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR THEN

875: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN
876: l_CURR_LISTS_rec.base_markup_formula_id := NULL;
877: END IF;
878:
879: IF l_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR THEN
880: l_CURR_LISTS_rec.base_markup_operator := NULL;
881: END IF;
882:
883: IF l_CURR_LISTS_rec.base_markup_value = FND_API.G_MISS_NUM THEN

Line 883: IF l_CURR_LISTS_rec.base_markup_value = FND_API.G_MISS_NUM THEN

879: IF l_CURR_LISTS_rec.base_markup_operator = FND_API.G_MISS_CHAR THEN
880: l_CURR_LISTS_rec.base_markup_operator := NULL;
881: END IF;
882:
883: IF l_CURR_LISTS_rec.base_markup_value = FND_API.G_MISS_NUM THEN
884: l_CURR_LISTS_rec.base_markup_value := NULL;
885: END IF;
886:
887: IF l_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM THEN

Line 887: IF l_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM THEN

883: IF l_CURR_LISTS_rec.base_markup_value = FND_API.G_MISS_NUM THEN
884: l_CURR_LISTS_rec.base_markup_value := NULL;
885: END IF;
886:
887: IF l_CURR_LISTS_rec.base_rounding_factor = FND_API.G_MISS_NUM THEN
888: l_CURR_LISTS_rec.base_rounding_factor := NULL;
889: END IF;
890: -- Added by Sunil Pandey 10/01/01
891:

Line 893: IF l_CURR_LISTS_rec.row_id = FND_API.G_MISS_NUM THEN

889: END IF;
890: -- Added by Sunil Pandey 10/01/01
891:
892: /* Commented by Sunil
893: IF l_CURR_LISTS_rec.row_id = FND_API.G_MISS_NUM THEN
894: l_CURR_LISTS_rec.row_id := NULL;
895: END IF;
896: Commented by Sunil */
897:

Line 994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1120: , 'Insert_Row'
1121: );
1122: END IF;
1123:
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: End;
1126: -- Added by Sunil Pandey 10/01/01
1127:
1128: -- Added by Sunil

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: WHEN DUP_VAL_ON_INDEX THEN
1161:
1162: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MULTICURR');
1163: OE_MSG_PUB.Add;
1164: RAISE FND_API.G_EXC_ERROR;
1165:
1166: WHEN OTHERS THEN
1167:
1168: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: , 'Insert_Row'
1173: );
1174: END IF;
1175:
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177:
1178: End;
1179:
1180: INSERT INTO QP_CURRENCY_LISTS_B

Line 1240: WHEN FND_API.G_EXC_ERROR THEN

1236: , p_CURR_LISTS_rec.request_id
1237: );
1238:
1239: EXCEPTION
1240: WHEN FND_API.G_EXC_ERROR THEN
1241: raise;
1242:
1243: WHEN OTHERS THEN
1244:

Line 1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1249: , 'Insert_Row'
1250: );
1251: END IF;
1252:
1253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1254:
1255: END Insert_Row;
1256:
1257: -- Procedure Delete_Row

Line 1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1281: , 'Delete_Row'
1282: );
1283: END IF;
1284:
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286:
1287: END Delete_Row;
1288:
1289: -- Function Query_Row

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1402: , 'Query_Row'
1403: );
1404: END IF;
1405:
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407:
1408: END Query_Row;
1409:
1410: -- Procedure lock_Row

Line 1590: x_return_status := FND_API.G_RET_STS_SUCCESS;

1586: x_CURR_LISTS_rec := l_CURR_LISTS_rec;
1587:
1588: -- Set return status
1589:
1590: x_return_status := FND_API.G_RET_STS_SUCCESS;
1591: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1592:
1593: ELSE
1594:

Line 1591: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1587:
1588: -- Set return status
1589:
1590: x_return_status := FND_API.G_RET_STS_SUCCESS;
1591: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1592:
1593: ELSE
1594:
1595: -- Row has changed by another user.

Line 1597: x_return_status := FND_API.G_RET_STS_ERROR;

1593: ELSE
1594:
1595: -- Row has changed by another user.
1596:
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1599:
1600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1601: THEN

Line 1598: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;

1594:
1595: -- Row has changed by another user.
1596:
1597: x_return_status := FND_API.G_RET_STS_ERROR;
1598: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1599:
1600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1601: THEN
1602:

Line 1614: x_return_status := FND_API.G_RET_STS_ERROR;

1610: EXCEPTION
1611:
1612: WHEN NO_DATA_FOUND THEN
1613:
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1616:
1617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1618: THEN

Line 1615: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;

1611:
1612: WHEN NO_DATA_FOUND THEN
1613:
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1616:
1617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1618: THEN
1619:

Line 1626: x_return_status := FND_API.G_RET_STS_ERROR;

1622:
1623: END IF;
1624: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1625:
1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1628:
1629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1630: THEN

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

1623: END IF;
1624: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1625:
1626: x_return_status := FND_API.G_RET_STS_ERROR;
1627: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1628:
1629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1630: THEN
1631:

Line 1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1634:
1635: END IF;
1636: WHEN OTHERS THEN
1637:
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1640:
1641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1642: THEN

Line 1639: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1635: END IF;
1636: WHEN OTHERS THEN
1637:
1638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1639: x_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1640:
1641: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1642: THEN
1643: OE_MSG_PUB.Add_Exc_Msg

Line 1664: p_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR AND

1660: BEGIN
1661:
1662: -- oe_debug_pub.add('. ENTERED QP_Curr_Lists_Util.Get_Values');
1663: IF p_CURR_LISTS_rec.base_currency_code IS NOT NULL AND
1664: p_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR AND
1665: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_currency_code,
1666: p_old_CURR_LISTS_rec.base_currency_code)
1667: THEN
1668: l_CURR_LISTS_val_rec.base_currency := QP_Id_To_Value.Base_Currency

Line 1674: p_CURR_LISTS_rec.currency_header_id <> FND_API.G_MISS_NUM AND

1670: );
1671: END IF;
1672:
1673: IF p_CURR_LISTS_rec.currency_header_id IS NOT NULL AND
1674: p_CURR_LISTS_rec.currency_header_id <> FND_API.G_MISS_NUM AND
1675: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.currency_header_id,
1676: p_old_CURR_LISTS_rec.currency_header_id)
1677: THEN
1678: l_CURR_LISTS_val_rec.currency_header := QP_Id_To_Value.Currency_Header

Line 1686: p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_CHAR AND

1682:
1683: /*
1684: -- Added by Sunil Pandey 10/01/01
1685: IF p_CURR_LISTS_rec.base_markup_formula_id IS NOT NULL AND
1686: p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_CHAR AND
1687: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.base_markup_formula_id,
1688: p_old_CURR_LISTS_rec.base_markup_formula_id)
1689: THEN
1690: l_CURR_LISTS_val_rec.base_markup_formula := QP_Id_To_Value.Base_Markup_Formula

Line 1699: p_CURR_LISTS_rec.row_id <> FND_API.G_MISS_NUM AND

1695:
1696:
1697: /* Commented by Sunil
1698: IF p_CURR_LISTS_rec.row_id IS NOT NULL AND
1699: p_CURR_LISTS_rec.row_id <> FND_API.G_MISS_NUM AND
1700: NOT QP_GLOBALS.Equal(p_CURR_LISTS_rec.row_id,
1701: p_old_CURR_LISTS_rec.row_id)
1702: THEN
1703: l_CURR_LISTS_val_rec.row := QP_Id_To_Value.Row

Line 1726: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1722: BEGIN
1723:
1724: -- initialize return_status.
1725:
1726: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1727:
1728: -- initialize l_CURR_LISTS_rec.
1729:
1730: l_CURR_LISTS_rec := p_CURR_LISTS_rec;

Line 1732: IF p_CURR_LISTS_val_rec.base_currency <> FND_API.G_MISS_CHAR

1728: -- initialize l_CURR_LISTS_rec.
1729:
1730: l_CURR_LISTS_rec := p_CURR_LISTS_rec;
1731:
1732: IF p_CURR_LISTS_val_rec.base_currency <> FND_API.G_MISS_CHAR
1733: THEN
1734:
1735: IF p_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR THEN
1736:

Line 1735: IF p_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR THEN

1731:
1732: IF p_CURR_LISTS_val_rec.base_currency <> FND_API.G_MISS_CHAR
1733: THEN
1734:
1735: IF p_CURR_LISTS_rec.base_currency_code <> FND_API.G_MISS_CHAR THEN
1736:
1737: l_CURR_LISTS_rec.base_currency_code := p_CURR_LISTS_rec.base_currency_code;
1738:
1739: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1754: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN

1750: l_CURR_LISTS_rec.base_currency_code := QP_Value_To_Id.base_currency
1751: ( p_base_currency => p_CURR_LISTS_val_rec.base_currency
1752: );
1753:
1754: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN
1755: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1756: END IF;
1757:
1758: END IF;

Line 1755: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;

1751: ( p_base_currency => p_CURR_LISTS_val_rec.base_currency
1752: );
1753:
1754: IF l_CURR_LISTS_rec.base_currency_code = FND_API.G_MISS_CHAR THEN
1755: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1756: END IF;
1757:
1758: END IF;
1759:

Line 1762: IF p_CURR_LISTS_val_rec.currency_header <> FND_API.G_MISS_CHAR

1758: END IF;
1759:
1760: END IF;
1761:
1762: IF p_CURR_LISTS_val_rec.currency_header <> FND_API.G_MISS_CHAR
1763: THEN
1764:
1765: IF p_CURR_LISTS_rec.currency_header_id <> FND_API.G_MISS_NUM THEN
1766:

Line 1765: IF p_CURR_LISTS_rec.currency_header_id <> FND_API.G_MISS_NUM THEN

1761:
1762: IF p_CURR_LISTS_val_rec.currency_header <> FND_API.G_MISS_CHAR
1763: THEN
1764:
1765: IF p_CURR_LISTS_rec.currency_header_id <> FND_API.G_MISS_NUM THEN
1766:
1767: l_CURR_LISTS_rec.currency_header_id := p_CURR_LISTS_rec.currency_header_id;
1768:
1769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1784: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

1780: l_CURR_LISTS_rec.currency_header_id := QP_Value_To_Id.currency_header
1781: ( p_currency_header => p_CURR_LISTS_val_rec.currency_header
1782: );
1783:
1784: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
1785: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1786: END IF;
1787:
1788: END IF;

Line 1785: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;

1781: ( p_currency_header => p_CURR_LISTS_val_rec.currency_header
1782: );
1783:
1784: IF l_CURR_LISTS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
1785: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1786: END IF;
1787:
1788: END IF;
1789:

Line 1793: IF p_CURR_LISTS_val_rec.base_markup_formula <> FND_API.G_MISS_CHAR

1789:
1790: END IF;
1791:
1792: -- Added by Sunil Pandey 10/01/01
1793: IF p_CURR_LISTS_val_rec.base_markup_formula <> FND_API.G_MISS_CHAR
1794: THEN
1795:
1796: IF p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_NUM THEN
1797:

Line 1796: IF p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_NUM THEN

1792: -- Added by Sunil Pandey 10/01/01
1793: IF p_CURR_LISTS_val_rec.base_markup_formula <> FND_API.G_MISS_CHAR
1794: THEN
1795:
1796: IF p_CURR_LISTS_rec.base_markup_formula_id <> FND_API.G_MISS_NUM THEN
1797:
1798: l_CURR_LISTS_rec.base_markup_formula_id := p_CURR_LISTS_rec.base_markup_formula_id;
1799:
1800: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1815: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN

1811: l_CURR_LISTS_rec.base_markup_formula_id := QP_Value_To_Id.Base_Markup_Formula
1812: ( p_base_markup_formula => p_CURR_LISTS_val_rec.base_markup_formula
1813: );
1814:
1815: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN
1816: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1817: END IF;
1818:
1819: END IF;

Line 1816: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;

1812: ( p_base_markup_formula => p_CURR_LISTS_val_rec.base_markup_formula
1813: );
1814:
1815: IF l_CURR_LISTS_rec.base_markup_formula_id = FND_API.G_MISS_NUM THEN
1816: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1817: END IF;
1818:
1819: END IF;
1820:

Line 1824: IF p_CURR_LISTS_val_rec.row <> FND_API.G_MISS_CHAR

1820:
1821: END IF;
1822:
1823: /* Commented by Sunil
1824: IF p_CURR_LISTS_val_rec.row <> FND_API.G_MISS_CHAR
1825: THEN
1826:
1827: IF p_CURR_LISTS_rec.row_id <> FND_API.G_MISS_CHAR THEN
1828:

Line 1827: IF p_CURR_LISTS_rec.row_id <> FND_API.G_MISS_CHAR THEN

1823: /* Commented by Sunil
1824: IF p_CURR_LISTS_val_rec.row <> FND_API.G_MISS_CHAR
1825: THEN
1826:
1827: IF p_CURR_LISTS_rec.row_id <> FND_API.G_MISS_CHAR THEN
1828:
1829: l_CURR_LISTS_rec.row_id := p_CURR_LISTS_rec.row_id;
1830:
1831: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1846: IF l_CURR_LISTS_rec.row_id = FND_API.G_MISS_CHAR THEN

1842: l_CURR_LISTS_rec.row_id := QP_Value_To_Id.row
1843: ( p_row => p_CURR_LISTS_val_rec.row
1844: );
1845:
1846: IF l_CURR_LISTS_rec.row_id = FND_API.G_MISS_CHAR THEN
1847: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1848: END IF;
1849:
1850: END IF;

Line 1847: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;

1843: ( p_row => p_CURR_LISTS_val_rec.row
1844: );
1845:
1846: IF l_CURR_LISTS_rec.row_id = FND_API.G_MISS_CHAR THEN
1847: l_CURR_LISTS_rec.return_status := FND_API.G_RET_STS_ERROR;
1848: END IF;
1849:
1850: END IF;
1851: