291:
292:
293: IF p_sprvsr_dtls_rec.replaced_person_number IS NOT NULL THEN
294:
295: l_replaced_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.replaced_person_number);
296:
297: OPEN c_repl_person_dtls(l_replaced_person_id);
298: FETCH c_repl_person_dtls INTO l_replaced_sequence_number;
299: CLOSE c_repl_person_dtls;
541: END IF;
542:
543: IF p_sprvsr_status = 'VALID' THEN
544: -- Check whether ca_person_number is valid or not.
545: l_ca_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.ca_person_number);
546:
547: IF l_ca_person_id IS NULL THEN
548: -- Add exception to stack
549: FND_MESSAGE.Set_Name('IGS','IGS_GE_INVALID_PERSON_NUMBER');
551: p_sprvsr_status := 'INVALID';
552: END IF;
553:
554: -- Check whether ca_person_number is valid or not.
555: l_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.person_number);
556:
557: IF l_person_id IS NULL THEN
558: FND_MESSAGE.Set_Name('IGS','IGS_GE_INVALID_PERSON_NUMBER');
559: FND_MSG_PUB.Add;
602:
603: IF p_sprvsr_status = 'VALID' THEN
604:
605: IF p_sprvsr_dtls_rec.replaced_person_number IS NOT NULL THEN
606: l_replaced_person_id := Igs_Ge_Gen_003.Get_Person_id (p_sprvsr_dtls_rec.replaced_person_number);
607: OPEN c_repl_person_dtls(l_replaced_person_id);
608: FETCH c_repl_person_dtls INTO l_replaced_sequence_number;
609: CLOSE c_repl_person_dtls;
610: END IF;