[Home] [Help]
217: --After validating the set of important attributes,
218: --if multiple message detection is enabled and atleast
219: --one error has been found then abort further validation.
220: --
221: hr_multi_message.end_validation_set;
222: --
223: -- Call all supporting business operations
224: --
225: -- Validate PERSON_ID, DATE_RECEIVED_COMBINATION
327: --After validating the set of important attributes,
328: --if multiple message detection is enabled and atleast
329: --one error has been found then abort further validation.
330: --
331: hr_multi_message.end_validation_set;
332: --
333: -- Call all supporting business operations
334: --
335: hr_utility.set_location(l_proc, 6);
484: into l_business_group_id, l_system_person_type;
485: if (csr_valid_person_per_people_f%notfound) then
486: close csr_valid_person_per_people_f;
487: hr_utility.set_message(801,'HR_51194_APL_INV_DT_PERSON');
488: hr_multi_message.add
489: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
490: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'
491: );
492: else
509: l_system_person_type <> 'EMP_APL' AND
510: l_system_person_type <> 'APL_EX_APL' AND
511: l_system_person_type <> 'EX_EMP_APL') then
512: hr_utility.set_message(801,'HR_51185_APL_INV_SYS_PER_TYPE');
513: hr_multi_message.add
514: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
515: );
516: end if;
517: --
520: -- Check the application is in the same business group as the person
521: --
522: if (p_business_group_id <> l_business_group_id) then
523: hr_utility.set_message(801,'HR_51187_APL_INV_BUS_GRP');
524: hr_multi_message.add
525: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
526: );
527: end if;
528: end if;
533: -- Validate date received with respect to DATE_END
534: --
535: if (p_date_received > nvl(p_date_end,hr_api.g_eot)) then
536: hr_utility.set_message(801,'HR_51188_APL_DTE_REC_DTE_END');
537: hr_multi_message.add
538: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
539: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'
540: );
541: end if;
545: -- Validate date received with respect to PROJECTED HIRE DATE
546: --
547: if (p_date_received > nvl(p_projected_hire_date,hr_api.g_eot)) then
548: hr_utility.set_message(801,'HR_51189_APL_DTE_REC_PROJ_HIRE');
549: hr_multi_message.add
550: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
551: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'
552: );
553: end if;
564: fetch csr_valid_person_per_apl into l_application_id;
565: if (csr_valid_person_per_apl%found) then
566: close csr_valid_person_per_apl;
567: hr_utility.set_message(801,'HR_51190_APL_DTE_REC_PERSON');
568: hr_multi_message.add
569: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
570: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'
571: );
572: else
598: hr_utility.set_location('Entering:'||l_proc,1);
599: --
600: -- Check if projected hire date is not null, only validate if it is not null
601: --
602: if hr_multi_message.no_all_inclusive_error
603: (p_check_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
604: ) then
605: if (p_projected_hire_date is not null) then
606: --
623: -- Validate projected hire date WRT date received.
624: --
625: if (p_date_received > p_projected_hire_date) then
626: hr_utility.set_message(801,'HR_51192_APL_PROJ_HIRE_DTE_REC');
627: hr_multi_message.add
628: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
629: ,p_associated_column2 => 'PER_APPLICATIONS.PROJECTED_HIRE_DATE'
630: );
631: end if;
700: hr_utility.set_location(l_proc,21);
701: --
702: hr_utility.set_message(801,'HR_7441_API_ARG_NOT_SET');
703: hr_utility.set_message_token('ARG_NAME','DATE_END');
704: hr_multi_message.add
705: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
706: );
707: --
708: elsif (l_api_updating and
718: if (per_apl_shd.g_old_rec.date_end is not null and
719: per_apl_shd.g_old_rec.date_end <> p_date_end) then
720: hr_utility.set_location('Inside:'||l_proc,35);
721: hr_utility.set_message(801,'HR_51234_APL_INVALID_UPDATE');
722: hr_multi_message.add
723: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
724: );
725: end if;
726: hr_utility.set_location(l_proc,41);
728: -- Raise error if date_end before date_received
729: --
730: if (p_date_end < p_date_received) then
731: hr_utility.set_message(801,'HR_51235_APL_DTE_END_DTE_REC');
732: hr_multi_message.add
733: (p_associated_column1 => 'PER_APPLICATIONS.DATE_RECEIVED'
734: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_END'
735: );
736: end if;
746: --
747: close csr_chk_asg_future_changes;
748: --
749: hr_utility.set_message(801,'HR_51236_APL_ASG_FUTURE_CHGS');
750: hr_multi_message.add
751: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
752: );
753: else
754: --
767: --
768: close csr_chk_apl_future_changes;
769: --
770: hr_utility.set_message(801,'HR_51237_APL_PER_FUTURE_CHGS');
771: hr_multi_message.add
772: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
773: );
774: else
775: --
832: hr_utility.set_location(' Leaving:' || l_proc, 31);
833: --
834: exception
835: when app_exception.application_exception then
836: if hr_multi_message.exception_add
837: (p_associated_column1 => 'PER_APPLICATIONS.SUCCESSFUL_FLAG'
838: ) then
839: hr_utility.set_location(' Leaving:' || l_proc,40);
840: raise;
905: --
906: hr_utility.set_location(' Leaving:'|| l_proc, 31);
907: exception
908: when app_exception.application_exception then
909: if hr_multi_message.exception_add
910: (p_associated_column1 => 'PER_APPLICATIONS.TERMINATION_REASON'
911: ) then
912: hr_utility.set_location(' Leaving:'||l_proc,40);
913: raise;