662:
663: exception
664: when NO_DATA_FOUND then
665:
666: FND_MESSAGE.set_name('HXC','HXC_INVALID_INFO_CONTEXT');
667: FND_MESSAGE.set_token('CONTEXT',p_context_codes);
668:
669:
670: END build_context_string;
663: exception
664: when NO_DATA_FOUND then
665:
666: FND_MESSAGE.set_name('HXC','HXC_INVALID_INFO_CONTEXT');
667: FND_MESSAGE.set_token('CONTEXT',p_context_codes);
668:
669:
670: END build_context_string;
671:
738:
739: close c_person_info;
740: close closest_asg_record;
741:
742: FND_MESSAGE.set_name('HXC','HXC_NO_PERSON_INFO');
743: FND_MESSAGE.raise_error;
744:
745: end if;
746:
739: close c_person_info;
740: close closest_asg_record;
741:
742: FND_MESSAGE.set_name('HXC','HXC_NO_PERSON_INFO');
743: FND_MESSAGE.raise_error;
744:
745: end if;
746:
747: close closest_asg_record;
801:
802:
803: if (c_period_info%NOTFOUND) then
804:
805: FND_MESSAGE.set_name('HXC','HXC_MISSING_PERIOD_PREF');
806: FND_MESSAGE.raise_error;
807:
808: end if;
809:
802:
803: if (c_period_info%NOTFOUND) then
804:
805: FND_MESSAGE.set_name('HXC','HXC_MISSING_PERIOD_PREF');
806: FND_MESSAGE.raise_error;
807:
808: end if;
809:
810: close c_period_info;
851: fetch c_start_date into l_start_date;
852:
853: if c_start_date%NOTFOUND then
854: close c_start_date;
855: FND_MESSAGE.set_name('HXC','HXC_NO_ACTIVE_ASG');
856: FND_MESSAGE.raise_error;
857: end if;
858:
859: close c_start_date;
852:
853: if c_start_date%NOTFOUND then
854: close c_start_date;
855: FND_MESSAGE.set_name('HXC','HXC_NO_ACTIVE_ASG');
856: FND_MESSAGE.raise_error;
857: end if;
858:
859: close c_start_date;
860:
862: fetch c_end_date into l_end_date;
863:
864: if c_end_date%NOTFOUND then
865: close c_end_date;
866: FND_MESSAGE.set_name('HXC','HXC_NO_ACTIVE_ASG');
867: FND_MESSAGE.raise_error;
868: end if;
869:
870: close c_end_date;
863:
864: if c_end_date%NOTFOUND then
865: close c_end_date;
866: FND_MESSAGE.set_name('HXC','HXC_NO_ACTIVE_ASG');
867: FND_MESSAGE.raise_error;
868: end if;
869:
870: close c_end_date;
871: