eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ENV_BUS dependencies on FND_MESSAGE

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

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'CAL_ENTRY_VALUE_ID')
67: );

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

138: --
139: -- The primary key is invalid therefore we must error
140: --
141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --

Line 143: fnd_message.raise_error;

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

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

197: IF NOT per_env_shd.api_updating
198: (p_cal_entry_value_id => p_rec.cal_entry_value_id
199: ,p_object_version_number => p_rec.object_version_number
200: ) THEN
201: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
202: fnd_message.set_token('PROCEDURE ', l_proc);
203: fnd_message.set_token('STEP ', '5');
204: fnd_message.raise_error;
205: END IF;

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

198: (p_cal_entry_value_id => p_rec.cal_entry_value_id
199: ,p_object_version_number => p_rec.object_version_number
200: ) THEN
201: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
202: fnd_message.set_token('PROCEDURE ', l_proc);
203: fnd_message.set_token('STEP ', '5');
204: fnd_message.raise_error;
205: END IF;
206: --

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

199: ,p_object_version_number => p_rec.object_version_number
200: ) THEN
201: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
202: fnd_message.set_token('PROCEDURE ', l_proc);
203: fnd_message.set_token('STEP ', '5');
204: fnd_message.raise_error;
205: END IF;
206: --
207: -- check parent Entry Id is not updated

Line 204: fnd_message.raise_error;

200: ) THEN
201: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
202: fnd_message.set_token('PROCEDURE ', l_proc);
203: fnd_message.set_token('STEP ', '5');
204: fnd_message.raise_error;
205: END IF;
206: --
207: -- check parent Entry Id is not updated
208: If nvl(p_rec.calendar_entry_id, hr_api.g_number) <>

Line 252: fnd_message.set_name('PER', 'PER_289976_CAL_ENT_NULL');

248: hr_utility.set_location('Entering:'||l_proc, 5);
249: --
250: If p_calendar_entry_id IS NULL then
251: -- raise as serious error, no point doing other checks
252: fnd_message.set_name('PER', 'PER_289976_CAL_ENT_NULL');
253: fnd_message.raise_error;
254: Else
255: --
256: open CSR_ENTRY;

Line 253: fnd_message.raise_error;

249: --
250: If p_calendar_entry_id IS NULL then
251: -- raise as serious error, no point doing other checks
252: fnd_message.set_name('PER', 'PER_289976_CAL_ENT_NULL');
253: fnd_message.raise_error;
254: Else
255: --
256: open CSR_ENTRY;
257: fetch CSR_ENTRY into l_dummy;

Line 261: fnd_message.set_name('PER', 'PER_289977_CAL_ENT_INV');

257: fetch CSR_ENTRY into l_dummy;
258: if CSR_ENTRY%notfound then
259: close CSR_ENTRY;
260: -- raise as serious error, no point doing other checks
261: fnd_message.set_name('PER', 'PER_289977_CAL_ENT_INV');
262: fnd_message.raise_error;
263: else
264: close CSR_ENTRY;
265: end if;

Line 262: fnd_message.raise_error;

258: if CSR_ENTRY%notfound then
259: close CSR_ENTRY;
260: -- raise as serious error, no point doing other checks
261: fnd_message.set_name('PER', 'PER_289977_CAL_ENT_INV');
262: fnd_message.raise_error;
263: else
264: close CSR_ENTRY;
265: end if;
266: End if;

Line 345: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');

341: open CSR_ENTRY;
342: fetch CSR_ENTRY into l_id;
343: if CSR_ENTRY%notfound then
344: close CSR_ENTRY;
345: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');
346: fnd_message.raise_error;
347: else
348: hr_utility.set_location(l_proc, 15);
349: close CSR_ENTRY;

Line 346: fnd_message.raise_error;

342: fetch CSR_ENTRY into l_id;
343: if CSR_ENTRY%notfound then
344: close CSR_ENTRY;
345: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');
346: fnd_message.raise_error;
347: else
348: hr_utility.set_location(l_proc, 15);
349: close CSR_ENTRY;
350: if l_id IS NULL then

Line 351: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');

347: else
348: hr_utility.set_location(l_proc, 15);
349: close CSR_ENTRY;
350: if l_id IS NULL then
351: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');
352: fnd_message.raise_error;
353: else
354: hr_utility.set_location(l_proc, 25);
355: open CSR_GEN_HIER(l_id);

Line 352: fnd_message.raise_error;

348: hr_utility.set_location(l_proc, 15);
349: close CSR_ENTRY;
350: if l_id IS NULL then
351: fnd_message.set_name('PER', 'PER_289978_CAL_ENT_NODE_INV');
352: fnd_message.raise_error;
353: else
354: hr_utility.set_location(l_proc, 25);
355: open CSR_GEN_HIER(l_id);
356: fetch CSR_GEN_HIER into l_dummy;

Line 360: fnd_message.set_name('PER', 'PER_289979_CAL_ENT_NODE_INV');

356: fetch CSR_GEN_HIER into l_dummy;
357: if CSR_GEN_HIER%notfound then
358: close CSR_GEN_HIER;
359: -- node does not exist in the parent entry's gen heirarchy MM
360: fnd_message.set_name('PER', 'PER_289979_CAL_ENT_NODE_INV');
361: fnd_message.raise_error;
362: else
363: close CSR_GEN_HIER;
364: end if;

Line 361: fnd_message.raise_error;

357: if CSR_GEN_HIER%notfound then
358: close CSR_GEN_HIER;
359: -- node does not exist in the parent entry's gen heirarchy MM
360: fnd_message.set_name('PER', 'PER_289979_CAL_ENT_NODE_INV');
361: fnd_message.raise_error;
362: else
363: close CSR_GEN_HIER;
364: end if;
365:

Line 373: fnd_message.set_name('PER', 'PER_289980_CAL_ENT_NODE_UNQ');

369: if CSR_ENT_VAL%found then
370: close CSR_ENT_VAL;
371: -- node already used by an entry value for this
372: -- calendar entry
373: fnd_message.set_name('PER', 'PER_289980_CAL_ENT_NODE_UNQ');
374: fnd_message.raise_error;
375: else
376: close CSR_ENT_VAL;
377: end if;

Line 374: fnd_message.raise_error;

370: close CSR_ENT_VAL;
371: -- node already used by an entry value for this
372: -- calendar entry
373: fnd_message.set_name('PER', 'PER_289980_CAL_ENT_NODE_UNQ');
374: fnd_message.raise_error;
375: else
376: close CSR_ENT_VAL;
377: end if;
378: end if;

Line 437: fnd_message.set_name('PER', 'PER_289981_CAL_ENT_VS_INV');

433: fetch CSR_ENTRY into l_id;
434: if CSR_ENTRY%notfound then
435: close CSR_ENTRY;
436: -- parent entry is not using valueset -- MM
437: fnd_message.set_name('PER', 'PER_289981_CAL_ENT_VS_INV');
438: fnd_message.raise_error;
439: else
440: close CSR_ENTRY;
441: -- do valudation of the VS value ....

Line 438: fnd_message.raise_error;

434: if CSR_ENTRY%notfound then
435: close CSR_ENTRY;
436: -- parent entry is not using valueset -- MM
437: fnd_message.set_name('PER', 'PER_289981_CAL_ENT_VS_INV');
438: fnd_message.raise_error;
439: else
440: close CSR_ENTRY;
441: -- do valudation of the VS value ....
442:

Line 484: fnd_message.set_name('PER', 'PER_289982_CAL_ENV_FKS_NULL');

480: OR (p_hierarchy_node_id is not null and p_value is not null)
481: OR (p_org_structure_element_id is not null and p_value is not null)
482: OR (p_org_structure_element_id is not null and p_hierarchy_node_id is not null) then
483: -- unrecoverable error as only one must be set
484: fnd_message.set_name('PER', 'PER_289982_CAL_ENV_FKS_NULL');
485: fnd_message.raise_error;
486: END IF;
487: --
488: --

Line 485: fnd_message.raise_error;

481: OR (p_org_structure_element_id is not null and p_value is not null)
482: OR (p_org_structure_element_id is not null and p_hierarchy_node_id is not null) then
483: -- unrecoverable error as only one must be set
484: fnd_message.set_name('PER', 'PER_289982_CAL_ENV_FKS_NULL');
485: fnd_message.raise_error;
486: END IF;
487: --
488: --
489: hr_utility.set_location('Leaving:'||l_proc, 50);

Line 549: fnd_message.set_name('PER', 'HR_289992_CAL_OVER_NULL');

545: THEN
546:
547: IF p_usage_flag = 'O' and p_override_name is null and p_override_type is null then
548: -- override must have a name or value - convert to MM
549: fnd_message.set_name('PER', 'HR_289992_CAL_OVER_NULL');
550: fnd_message.raise_error;
551: End if;
552: --
553: IF p_usage_flag <> 'O' and p_override_name is not null then

Line 550: fnd_message.raise_error;

546:
547: IF p_usage_flag = 'O' and p_override_name is null and p_override_type is null then
548: -- override must have a name or value - convert to MM
549: fnd_message.set_name('PER', 'HR_289992_CAL_OVER_NULL');
550: fnd_message.raise_error;
551: End if;
552: --
553: IF p_usage_flag <> 'O' and p_override_name is not null then
554: -- non override's must not have an override name - convert to MM

Line 555: fnd_message.set_name('PER', 'HR_289993_CAL_OVERN_SET');

551: End if;
552: --
553: IF p_usage_flag <> 'O' and p_override_name is not null then
554: -- non override's must not have an override name - convert to MM
555: fnd_message.set_name('PER', 'HR_289993_CAL_OVERN_SET');
556: fnd_message.raise_error;
557: End if;
558: --
559: hr_utility.set_location(l_proc, 10);

Line 556: fnd_message.raise_error;

552: --
553: IF p_usage_flag <> 'O' and p_override_name is not null then
554: -- non override's must not have an override name - convert to MM
555: fnd_message.set_name('PER', 'HR_289993_CAL_OVERN_SET');
556: fnd_message.raise_error;
557: End if;
558: --
559: hr_utility.set_location(l_proc, 10);
560: IF p_override_type is not null then

Line 563: fnd_message.set_name('PER', 'HR_289994_CAL_OVERT_SET');

559: hr_utility.set_location(l_proc, 10);
560: IF p_override_type is not null then
561: IF p_usage_flag = 'Y' then
562: -- exceptions must not have an override type - convert to MM
563: fnd_message.set_name('PER', 'HR_289994_CAL_OVERT_SET');
564: fnd_message.raise_error;
565: ELSE
566: -- check the value exists in lookups...
567: if hr_api.NOT_EXISTS_IN_HR_LOOKUPS

Line 564: fnd_message.raise_error;

560: IF p_override_type is not null then
561: IF p_usage_flag = 'Y' then
562: -- exceptions must not have an override type - convert to MM
563: fnd_message.set_name('PER', 'HR_289994_CAL_OVERT_SET');
564: fnd_message.raise_error;
565: ELSE
566: -- check the value exists in lookups...
567: if hr_api.NOT_EXISTS_IN_HR_LOOKUPS
568: (p_effective_date => p_effective_date

Line 572: fnd_message.set_name('PER','HR_289995_CAL_OVERT_INV');

568: (p_effective_date => p_effective_date
569: ,p_lookup_type => 'CALENDAR_ENTRY_TYPE'
570: ,p_lookup_code => p_override_type)
571: then
572: fnd_message.set_name('PER','HR_289995_CAL_OVERT_INV');
573: fnd_message.raise_error;
574: --
575: end if;
576: END IF;

Line 573: fnd_message.raise_error;

569: ,p_lookup_type => 'CALENDAR_ENTRY_TYPE'
570: ,p_lookup_code => p_override_type)
571: then
572: fnd_message.set_name('PER','HR_289995_CAL_OVERT_INV');
573: fnd_message.raise_error;
574: --
575: end if;
576: END IF;
577: End if;

Line 587: fnd_message.set_name('PER', 'HR_289996_CAL_OVERN_DIF');

583: open CSR_OVR;
584: fetch CSR_OVR into l_name, l_type;
585: close CSR_OVR;
586: If upper(l_name) = upper(p_override_name) then
587: fnd_message.set_name('PER', 'HR_289996_CAL_OVERN_DIF');
588: fnd_message.raise_error;
589: End If;
590: If l_type = p_override_type then
591: fnd_message.set_name('PER', 'HR_289997_CAL_OVERT_DIF');

Line 588: fnd_message.raise_error;

584: fetch CSR_OVR into l_name, l_type;
585: close CSR_OVR;
586: If upper(l_name) = upper(p_override_name) then
587: fnd_message.set_name('PER', 'HR_289996_CAL_OVERN_DIF');
588: fnd_message.raise_error;
589: End If;
590: If l_type = p_override_type then
591: fnd_message.set_name('PER', 'HR_289997_CAL_OVERT_DIF');
592: fnd_message.raise_error;

Line 591: fnd_message.set_name('PER', 'HR_289997_CAL_OVERT_DIF');

587: fnd_message.set_name('PER', 'HR_289996_CAL_OVERN_DIF');
588: fnd_message.raise_error;
589: End If;
590: If l_type = p_override_type then
591: fnd_message.set_name('PER', 'HR_289997_CAL_OVERT_DIF');
592: fnd_message.raise_error;
593: End If;
594: End if;
595: --

Line 592: fnd_message.raise_error;

588: fnd_message.raise_error;
589: End If;
590: If l_type = p_override_type then
591: fnd_message.set_name('PER', 'HR_289997_CAL_OVERT_DIF');
592: fnd_message.raise_error;
593: End If;
594: End if;
595: --
596: END IF;

Line 658: fnd_message.set_name('PER', 'HR_289998_CAL_USAGE_INV');

654:
655:
656: If p_usage_flag is null or p_usage_flag not in ('Y','N','O') then
657: -- usage is invalid
658: fnd_message.set_name('PER', 'HR_289998_CAL_USAGE_INV');
659: fnd_message.raise_error;
660: End if;
661:
662: -- continue with combines validation

Line 659: fnd_message.raise_error;

655:
656: If p_usage_flag is null or p_usage_flag not in ('Y','N','O') then
657: -- usage is invalid
658: fnd_message.set_name('PER', 'HR_289998_CAL_USAGE_INV');
659: fnd_message.raise_error;
660: End if;
661:
662: -- continue with combines validation
663: If p_parent_entry_value_id is not null and p_usage_flag = 'N' THEN

Line 666: fnd_message.set_name('PER', 'PER_289983_CAL_VS_NO_PARENT');

662: -- continue with combines validation
663: If p_parent_entry_value_id is not null and p_usage_flag = 'N' THEN
664: -- current record is a gen hierarchy coverage parent or a valueset coverage
665: -- so parent_entry_value_id must be null.
666: fnd_message.set_name('PER', 'PER_289983_CAL_VS_NO_PARENT');
667: fnd_message.raise_error;
668: End if;
669:
670: If p_parent_entry_value_id is null and p_usage_flag <> 'N' THEN

Line 667: fnd_message.raise_error;

663: If p_parent_entry_value_id is not null and p_usage_flag = 'N' THEN
664: -- current record is a gen hierarchy coverage parent or a valueset coverage
665: -- so parent_entry_value_id must be null.
666: fnd_message.set_name('PER', 'PER_289983_CAL_VS_NO_PARENT');
667: fnd_message.raise_error;
668: End if;
669:
670: If p_parent_entry_value_id is null and p_usage_flag <> 'N' THEN
671: -- current record is not a gen hierarchy coverage parent or

Line 673: fnd_message.set_name('PER', 'HR_289999_CAL_PARENT_NULL');

669:
670: If p_parent_entry_value_id is null and p_usage_flag <> 'N' THEN
671: -- current record is not a gen hierarchy coverage parent or
672: -- a valueset coverage so parent_entry_value_id must NOT be null.
673: fnd_message.set_name('PER', 'HR_289999_CAL_PARENT_NULL');
674: fnd_message.raise_error;
675: End if;
676:
677: hr_utility.set_location(l_proc, 10);

Line 674: fnd_message.raise_error;

670: If p_parent_entry_value_id is null and p_usage_flag <> 'N' THEN
671: -- current record is not a gen hierarchy coverage parent or
672: -- a valueset coverage so parent_entry_value_id must NOT be null.
673: fnd_message.set_name('PER', 'HR_289999_CAL_PARENT_NULL');
674: fnd_message.raise_error;
675: End if;
676:
677: hr_utility.set_location(l_proc, 10);
678:

Line 687: fnd_message.set_name('PER', 'PER_289984_CAL_PARENT_INV1');

683: fetch CSR_EV into l_parent_entry_id, l_parent_entry_value_id;
684: If CSR_EV%notfound then
685: close CSR_EV;
686: -- parent EV was not found
687: fnd_message.set_name('PER', 'PER_289984_CAL_PARENT_INV1');
688: fnd_message.raise_error;
689: Else
690: close CSR_EV;
691:

Line 688: fnd_message.raise_error;

684: If CSR_EV%notfound then
685: close CSR_EV;
686: -- parent EV was not found
687: fnd_message.set_name('PER', 'PER_289984_CAL_PARENT_INV1');
688: fnd_message.raise_error;
689: Else
690: close CSR_EV;
691:
692: hr_utility.set_location(l_proc, 20);

Line 695: fnd_message.set_name('PER', 'PER_289985_CAL_PARENT_INV2');

691:
692: hr_utility.set_location(l_proc, 20);
693: If p_calendar_entry_id <> l_parent_entry_id then
694: -- parent EV exists for a different calendar entry
695: fnd_message.set_name('PER', 'PER_289985_CAL_PARENT_INV2');
696: fnd_message.raise_error;
697: End if;
698:
699: If l_parent_entry_value_id is not NULL then

Line 696: fnd_message.raise_error;

692: hr_utility.set_location(l_proc, 20);
693: If p_calendar_entry_id <> l_parent_entry_id then
694: -- parent EV exists for a different calendar entry
695: fnd_message.set_name('PER', 'PER_289985_CAL_PARENT_INV2');
696: fnd_message.raise_error;
697: End if;
698:
699: If l_parent_entry_value_id is not NULL then
700: -- parent EV is actually EVX or EVO so this grandchild is not allowed.

Line 701: fnd_message.set_name('PER', 'PER_289156_CAL_PARENT_INV3');

697: End if;
698:
699: If l_parent_entry_value_id is not NULL then
700: -- parent EV is actually EVX or EVO so this grandchild is not allowed.
701: fnd_message.set_name('PER', 'PER_289156_CAL_PARENT_INV3');
702: fnd_message.raise_error;
703: End if;
704: End if;
705: End if;

Line 702: fnd_message.raise_error;

698:
699: If l_parent_entry_value_id is not NULL then
700: -- parent EV is actually EVX or EVO so this grandchild is not allowed.
701: fnd_message.set_name('PER', 'PER_289156_CAL_PARENT_INV3');
702: fnd_message.raise_error;
703: End if;
704: End if;
705: End if;
706: --

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

745: fetch c_unique into l_value;
746: IF c_unique%found THEN
747: close c_unique;
748: -- Add to MM list as non-fatal
749: fnd_message.set_name('PER','PER_449074_CAL_IDK_EXISTS');
750: hr_multi_message.add
751: (p_associated_column1 => 'PER_CAL_ENTRY_VALUES.identifier_key');
752: ELSE
753: close c_unique;