[Home] [Help]
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'CALENDAR_ENTRY_ID')
64: );
65: --
252: --
253: IF p_name IS NULL THEN
254: -- Add to MM list as non-fatal
255: fnd_message.set_name('PER','PER_289958_CAL_NAME_NULL');
256: hr_multi_message.add
257: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.NAME');
258: --
259: END IF;
260: --
295: --
296: IF p_type IS NULL THEN
297: -- Add to MM list
298: fnd_message.set_name('PER','PER_289959_CAL_TYPE_NULL');
299: hr_multi_message.add
300: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.TYPE');
301: --
302: ELSIF ((p_calendar_entry_id is null) or
303: ((p_calendar_entry_id is not null) and
310: )
311: then
312: -- Add to MM list
313: fnd_message.set_name('PER','PER_289960_CAL_TYPE_INV');
314: hr_multi_message.add
315: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.TYPE');
316: --
317: end if;
318: END IF;
385: --
386: if p_start_date is null then
387: -- Add to MM list
388: fnd_message.set_name('PER','PER_289961_ENT_SDATE_NULL');
389: hr_multi_message.add
390: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_DATE');
391: end if;
392:
393: if p_end_date is NULL then
392:
393: if p_end_date is NULL then
394: -- Add to MM list
395: fnd_message.set_name('PER','PER_289962_ENT_EDATE_NULL');
396: hr_multi_message.add
397: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.END_DATE');
398: end if;
399:
400: if ((p_end_date is NOT NULL and p_start_date is NOT NULL) and
400: if ((p_end_date is NOT NULL and p_start_date is NOT NULL) and
401: (p_start_date > p_end_date)) then
402: -- Add to MM list
403: fnd_message.set_name('PER','PER_289963_ENT_SDATE_INV');
404: hr_multi_message.add
405: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_DATE');
406: end if;
407: --
408:
411: if (p_start_min is NOT NULL and p_start_hour is NULL) or
412: (p_end_min is NOT NULL and p_end_hour is NULL) then
413: -- Add to MM list as invalid combination passed
414: fnd_message.set_name('PER','PER_289187_CAL_ENT_TIME_INV');
415: hr_multi_message.add
416: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
417: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
418: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
419: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
427: and nvl(to_number(p_start_min),0) > nvl(to_number(p_end_min),55) )
428: or ( nvl(to_number(p_start_hour),0) > nvl(to_number(p_end_hour),23) ) then
429:
430: fnd_message.set_name('PER','PER_289188_CAL_ENT_TIME_INV2');
431: hr_multi_message.add
432: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.START_HOUR'
433: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.START_MIN'
434: ,p_associated_column3 => 'PER_CALENDAR_ENTRIES.END_HOUR'
435: ,p_associated_column4 => 'PER_CALENDAR_ENTRIES.END_MIN');
610: OR (p_hierarchy_id is not null and (p_organization_structure_id is not null or p_org_structure_version_id is not null))
611: THEN
612: -- raise error as only one coverage source may be chosen
613: fnd_message.set_name('PER','PER_289966_CAL_ENT_TWO_SET');
614: hr_multi_message.add
615: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID'
616: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
617: ELSE
618: -- only validate a specific id if > 1 are not set
636: -- raise error on MM list as VS is invalid
637: -- i.e. id either was not found or is not F validation type
638: fnd_message.set_name('PER','PER_289967_CAL_ENT_VS_INV');
639: fnd_message.set_token('VSET',p_value_set_id);
640: hr_multi_message.add
641: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
642: else
643: close csr_VS;
644: end if;
665: if csr_HIER%notfound then
666: close csr_HIER;
667: -- raise error as gen hierarchy is invalid
668: fnd_message.set_name('PER', 'PER_289968_CAL_ENT_HIER_INV');
669: hr_multi_message.add
670: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID');
671: else
672: close csr_HIER;
673: end if;
683: -- validate BOTH org structure and version are supplied, if either are
684: IF (p_organization_structure_id is not null and p_org_structure_version_id is null)
685: OR (p_organization_structure_id is null and p_org_structure_version_id is not null) THEN
686: fnd_message.set_name('PER', 'HR_289971_CAL_OS_PARAMS');
687: hr_multi_message.add
688: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORGANIZATION_STRUCTURE_ID');
689: hr_multi_message.add
690: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
691:
685: OR (p_organization_structure_id is null and p_org_structure_version_id is not null) THEN
686: fnd_message.set_name('PER', 'HR_289971_CAL_OS_PARAMS');
687: hr_multi_message.add
688: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORGANIZATION_STRUCTURE_ID');
689: hr_multi_message.add
690: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
691:
692: ELSIF (p_organization_structure_id is not null and p_org_structure_version_id is not null) THEN
693: -- Validate Org Hier and Version
706: if csr_ORG_HIER%notfound then
707: close csr_ORG_HIER;
708: -- raise error as org Hierarchy is invalid
709: fnd_message.set_name('PER', 'PER_289968_CAL_ENT_HIER_INV');
710: hr_multi_message.add
711: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
712: else
713: close csr_ORG_HIER;
714: end if;
753: fnd_message.set_name('PER', 'HR_289970_CAL_HEVS2_EXIST');
754: -- fnd_message.set_token('PARAM1',l_param1 );
755: if l_dummy = 'H' then -- Gen Hier evs exist
756: -- updating to diff hierarchy
757: hr_multi_message.add
758: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID');
759: elsif l_dummy = 'V' then -- VS evs exist
760: -- updating from VS to hierarchy
761: hr_multi_message.add
757: hr_multi_message.add
758: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.HIERARCHY_ID');
759: elsif l_dummy = 'V' then -- VS evs exist
760: -- updating from VS to hierarchy
761: hr_multi_message.add
762: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
763: elsif l_dummy = 'O' then -- Org Hier evs exist
764: hr_multi_message.add
765: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
760: -- updating from VS to hierarchy
761: hr_multi_message.add
762: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.VALUE_SET_ID');
763: elsif l_dummy = 'O' then -- Org Hier evs exist
764: hr_multi_message.add
765: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.ORG_STRUCTURE_VERSION_ID');
766: end if;
767:
768: end if;
809:
810: IF l_value IS NULL then
811: -- Add to MM list as non-fatal
812: fnd_message.set_name('PER','PER_449075_CAL_LEG_CODE');
813: hr_multi_message.add
814: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.LEGISLATION_CODE');
815: END IF;
816: --
817: END IF;
856: IF c_unique%found THEN
857: close c_unique;
858: -- Add to MM list as non-fatal
859: fnd_message.set_name('PER','PER_449074_CAL_IDK_EXISTS');
860: hr_multi_message.add
861: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.identifier_key');
862: ELSE
863: close c_unique;
864: END IF;
900: OR (p_legislation_code IS NULL AND p_identifier_key IS NOT NULL) THEN
901:
902: -- Add to MM list as non-fatal
903: fnd_message.set_name('PER','PER_449076_CAL_LEG_ID_COMB');
904: hr_multi_message.add
905: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.LEGISLATION_CODE'
906: ,p_associated_column2 => 'PER_CALENDAR_ENTRIES.IDENTIFIER_KEY');
907: END IF;
908: --
957: -- by reading the HR_CROSS_BUSINESS_GROUP profile.
958: If p_rec.business_group_id is null then
959: If nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') <> 'Y' then
960: fnd_message.set_name('PER', 'PER_289186_CAL_ENT_GLB_INV');
961: hr_multi_message.add
962: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.BUSINESS_GROUP_ID');
963: End if;
964: End if;
965:
982: -- After validating the set of important attributes,
983: -- if Multiple Message detection is enabled and at least
984: -- one error has been found then abort further validation.
985: --
986: hr_multi_message.end_validation_set;
987: --
988: -- Validate Dependent Attributes
989: --
990: --
1016: -- After validating the set of important attributes,
1017: -- if Multiple Message detection is enabled and at least
1018: -- one error has been found then abort further validation.
1019: --
1020: hr_multi_message.end_validation_set;
1021: --
1022: -- Validate Dependent Attributes
1023: --
1024: chk_non_updateable_args
1046:
1047: If p_rec.business_group_id is null then
1048: If nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') <> 'Y' then
1049: fnd_message.set_name('PER', 'PER_289186_CAL_ENT_GLB_INV');
1050: hr_multi_message.add
1051: (p_associated_column1 => 'PER_CALENDAR_ENTRIES.BUSINESS_GROUP_ID');
1052: End if;
1053: End if;
1054: