DBA Data[Home] [Help]

APPS.PER_ENT_BUS dependencies on FND_MESSAGE

Line 60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

56: close csr_sec_grp;
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: );

Line 137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --

Line 138: fnd_message.raise_error;

134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are

Line 196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

192: IF NOT per_ent_shd.api_updating
193: (p_calendar_entry_id => p_rec.calendar_entry_id
194: ,p_object_version_number => p_rec.object_version_number
195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
197: fnd_message.set_token('PROCEDURE ', l_proc);
198: fnd_message.set_token('STEP ', '5');
199: fnd_message.raise_error;
200: END IF;

Line 197: fnd_message.set_token('PROCEDURE ', l_proc);

193: (p_calendar_entry_id => p_rec.calendar_entry_id
194: ,p_object_version_number => p_rec.object_version_number
195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
197: fnd_message.set_token('PROCEDURE ', l_proc);
198: fnd_message.set_token('STEP ', '5');
199: fnd_message.raise_error;
200: END IF;
201: --

Line 198: fnd_message.set_token('STEP ', '5');

194: ,p_object_version_number => p_rec.object_version_number
195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
197: fnd_message.set_token('PROCEDURE ', l_proc);
198: fnd_message.set_token('STEP ', '5');
199: fnd_message.raise_error;
200: END IF;
201: --
202:

Line 199: fnd_message.raise_error;

195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
197: fnd_message.set_token('PROCEDURE ', l_proc);
198: fnd_message.set_token('STEP ', '5');
199: fnd_message.raise_error;
200: END IF;
201: --
202:
203: -- check legislation code is not updated

Line 255: fnd_message.set_name('PER','PER_289958_CAL_NAME_NULL');

251: hr_utility.set_location('Entering:'||l_proc, 5);
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;

Line 298: fnd_message.set_name('PER','PER_289959_CAL_TYPE_NULL');

294: -- b) The value for type has changed
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

Line 313: fnd_message.set_name('PER','PER_289960_CAL_TYPE_INV');

309: ,p_lookup_code => p_type
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;

Line 388: fnd_message.set_name('PER','PER_289961_ENT_SDATE_NULL');

384: -- Check mandatory incident_date is set
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:

Line 395: fnd_message.set_name('PER','PER_289962_ENT_EDATE_NULL');

391: end if;
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:

Line 403: fnd_message.set_name('PER','PER_289963_ENT_SDATE_INV');

399:
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: --

Line 414: fnd_message.set_name('PER','PER_289187_CAL_ENT_TIME_INV');

410:
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'

Line 430: fnd_message.set_name('PER','PER_289188_CAL_ENT_TIME_INV2');

426: if ( nvl(to_number(p_start_hour),0) = nvl(to_number(p_end_hour),23)
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'

Line 454: fnd_message.set_name('PER','CAC_SR_HIER_ENTRY_DATE_ERROR');

450:
451: if l_hier_date_from is not null then
452: if l_hier_date_to is not null then
453: if p_end_date < l_hier_date_from or p_start_date > l_hier_date_to then
454: fnd_message.set_name('PER','CAC_SR_HIER_ENTRY_DATE_ERROR');
455: fnd_message.raise_error;
456: end if;
457: else
458: if p_end_date< l_hier_date_from then

Line 455: fnd_message.raise_error;

451: if l_hier_date_from is not null then
452: if l_hier_date_to is not null then
453: if p_end_date < l_hier_date_from or p_start_date > l_hier_date_to then
454: fnd_message.set_name('PER','CAC_SR_HIER_ENTRY_DATE_ERROR');
455: fnd_message.raise_error;
456: end if;
457: else
458: if p_end_date< l_hier_date_from then
459: fnd_message.set_name('PER','CAC_SR_HIER_ENTRY_DATE_ERROR');

Line 459: fnd_message.set_name('PER','CAC_SR_HIER_ENTRY_DATE_ERROR');

455: fnd_message.raise_error;
456: end if;
457: else
458: if p_end_date< l_hier_date_from then
459: fnd_message.set_name('PER','CAC_SR_HIER_ENTRY_DATE_ERROR');
460: fnd_message.raise_error;
461: end if;
462: end if;
463: end if;

Line 460: fnd_message.raise_error;

456: end if;
457: else
458: if p_end_date< l_hier_date_from then
459: fnd_message.set_name('PER','CAC_SR_HIER_ENTRY_DATE_ERROR');
460: fnd_message.raise_error;
461: end if;
462: end if;
463: end if;
464:

Line 517: fnd_message.set_name('PER', 'PER_289964_CAL_NO_DELETE');

513: open csr_ev;
514: fetch csr_ev into l_dummy;
515: if csr_ev%found then
516: close csr_ev;
517: fnd_message.set_name('PER', 'PER_289964_CAL_NO_DELETE');
518: fnd_message.raise_error;
519: else
520: close csr_ev;
521: end if;

Line 518: fnd_message.raise_error;

514: fetch csr_ev into l_dummy;
515: if csr_ev%found then
516: close csr_ev;
517: fnd_message.set_name('PER', 'PER_289964_CAL_NO_DELETE');
518: fnd_message.raise_error;
519: else
520: close csr_ev;
521: end if;
522: end if;

Line 613: fnd_message.set_name('PER','PER_289966_CAL_ENT_TWO_SET');

609: OR (p_value_set_id is not null and (p_organization_structure_id is not null or p_org_structure_version_id is not null))
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

Line 638: fnd_message.set_name('PER','PER_289967_CAL_ENT_VS_INV');

634: if csr_VS%notfound then
635: close csr_VS;
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

Line 639: fnd_message.set_token('VSET',p_value_set_id);

635: close csr_VS;
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;

Line 668: fnd_message.set_name('PER', 'PER_289968_CAL_ENT_HIER_INV');

664: fetch csr_HIER into l_dummy;
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;

Line 686: fnd_message.set_name('PER', 'HR_289971_CAL_OS_PARAMS');

682:
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');

Line 709: fnd_message.set_name('PER', 'PER_289968_CAL_ENT_HIER_INV');

705: fetch csr_ORG_HIER into l_dummy;
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;

Line 751: -- fnd_message.set_name('PER', 'HR_289969_CAL_HEVS1_EXIST');

747: END IF;
748:
749: -- Raise the relevant error
750: if l_dummy is not null then
751: -- fnd_message.set_name('PER', 'HR_289969_CAL_HEVS1_EXIST');
752: -- fnd_message.set_name('PER', 'HR_289972_CAL_VEVS1_EXIST');
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

Line 752: -- fnd_message.set_name('PER', 'HR_289972_CAL_VEVS1_EXIST');

748:
749: -- Raise the relevant error
750: if l_dummy is not null then
751: -- fnd_message.set_name('PER', 'HR_289969_CAL_HEVS1_EXIST');
752: -- fnd_message.set_name('PER', 'HR_289972_CAL_VEVS1_EXIST');
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

Line 753: fnd_message.set_name('PER', 'HR_289970_CAL_HEVS2_EXIST');

749: -- Raise the relevant error
750: if l_dummy is not null then
751: -- fnd_message.set_name('PER', 'HR_289969_CAL_HEVS1_EXIST');
752: -- fnd_message.set_name('PER', 'HR_289972_CAL_VEVS1_EXIST');
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

Line 754: -- fnd_message.set_token('PARAM1',l_param1 );

750: if l_dummy is not null then
751: -- fnd_message.set_name('PER', 'HR_289969_CAL_HEVS1_EXIST');
752: -- fnd_message.set_name('PER', 'HR_289972_CAL_VEVS1_EXIST');
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');

Line 812: fnd_message.set_name('PER','PER_449075_CAL_LEG_CODE');

808: l_value := hr_general.DECODE_TERRITORY(P_TERRITORY_CODE => p_legislation_code);
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: --

Line 859: fnd_message.set_name('PER','PER_449074_CAL_IDK_EXISTS');

855: fetch c_unique into l_value;
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;

Line 903: fnd_message.set_name('PER','PER_449076_CAL_LEG_ID_COMB');

899: IF (p_legislation_code IS NOT NULL AND p_identifier_key IS NULL)
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;

Line 960: fnd_message.set_name('PER', 'PER_289186_CAL_ENT_GLB_INV');

956: -- on insert only we check that the global entry is allowed
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;

Line 1049: fnd_message.set_name('PER', 'PER_289186_CAL_ENT_GLB_INV');

1045: ,p_org_structure_version_id => p_rec.org_structure_version_id);
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;