472: --
473: l_date date;
474: Begin
475:
476: hr_multi_message.enable_message_list;
477:
478: Open csr_suggest_eff_dt;
479: Fetch csr_suggest_eff_dt into l_date;
480: Close csr_suggest_eff_dt;
482:
483: fnd_message.set_name('PQH','PQH_FR_DATE_SUGGESTION');
484: fnd_message.set_token('DATE',l_date);
485:
486: hr_multi_message.add(p_message_type=>HR_MULTI_MESSAGE.G_INFORMATION_MSG);
487:
488: HR_MULTI_MESSAGE.end_validation_set;
489:
490:
484: fnd_message.set_token('DATE',l_date);
485:
486: hr_multi_message.add(p_message_type=>HR_MULTI_MESSAGE.G_INFORMATION_MSG);
487:
488: HR_MULTI_MESSAGE.end_validation_set;
489:
490:
491: End admin_effective_warning;
492: ---
519: -- There is no record as of effective date
520: --
521: fnd_message.set_name('PQH','PQH_FR_NO_PERSON_EXIST');
522: fnd_message.set_token('DATE',to_date(p_effective_date,'RRRR-MM-DD'));
523: hr_multi_message.add(p_message_type=>HR_MULTI_MESSAGE.G_ERROR_MSG);
524: --
525: End if;
526: Close csr_chk_person;
527:
533: -- No Career Exist as on DATE
534: --
535: fnd_message.set_name('PQH','PQH_FR_NO_CAREER');
536: fnd_message.set_token('DATE',to_date(p_effective_date,'RRRR-MM-DD'));
537: hr_multi_message.add(p_message_type=>HR_MULTI_MESSAGE.G_ERROR_MSG);
538: --
539: End if;
540: Close csr_chk_career;
541: --
569: -- There is no record as of effective date
570: --
571: fnd_message.set_name('PQH','PQH_FR_NO_PERSON_EXIST');
572: fnd_message.set_token('DATE',to_date(p_effective_date,'RRRR-MM-DD'));
573: hr_multi_message.add(p_message_type=>HR_MULTI_MESSAGE.G_ERROR_MSG);
574: --
575: End if;
576: Close csr_chk_person;
577:
600: Fetch csr_normal_hours into l_normal_hours;
601: If (l_normal_hours is null ) then
602: ---
603: fnd_message.set_name('PQH','PQH_FR_NO_NORMAL_HOURS');
604: hr_multi_message.add(p_message_type=>HR_MULTI_MESSAGE.G_ERROR_MSG);
605: --
606: End if;
607:
608: Close csr_normal_hours;
616: IS
617:
618: Begin
619:
620: hr_multi_message.enable_message_list;
621:
622: -- Administratvie Career Check
623: If (p_function_name = 'PQH_FR_HR_ADMIN_CAREER') Then
624: --
633: affectations_validations(p_person_id,p_effective_date);
634: --
635: End if;
636:
637: HR_MULTI_MESSAGE.end_validation_set;
638: EXCEPTION
639: when hr_multi_message.error_message_exist then
640: -- P_RETURN_STATUS := hr_multi_message.get_return_status;
641: null;
635: End if;
636:
637: HR_MULTI_MESSAGE.end_validation_set;
638: EXCEPTION
639: when hr_multi_message.error_message_exist then
640: -- P_RETURN_STATUS := hr_multi_message.get_return_status;
641: null;
642: End;
643:
636:
637: HR_MULTI_MESSAGE.end_validation_set;
638: EXCEPTION
639: when hr_multi_message.error_message_exist then
640: -- P_RETURN_STATUS := hr_multi_message.get_return_status;
641: null;
642: End;
643:
644:
882: --
883: If csr_situation_details%NOTFOUND then
884: --
885: fnd_message.set_name('PQH','PQH_FR_NO_DEFAULT_SITUATION');
886: hr_multi_message.add(p_message_type=>HR_MULTI_MESSAGE.G_ERROR_MSG);
887: --
888: End if;
889:
890: Close csr_situation_details;