DBA Data[Home] [Help]

APPS.PQH_FR_UTILITY dependencies on FND_MESSAGE

Line 94: fnd_message.set_name('PER', 'HR_FR_DUP_ORG_MASS_UPD');

90: fetch csr_chk_dup_rec into l_duplicate;
91: if l_duplicate > 0 then
92:
93: hr_utility.set_location('Has Duplicate Records', 25);
94: fnd_message.set_name('PER', 'HR_FR_DUP_ORG_MASS_UPD');
95: fnd_message.raise_error;
96: end if;
97: close csr_chk_dup_rec;
98: end if; -- no FR legislation

Line 95: fnd_message.raise_error;

91: if l_duplicate > 0 then
92:
93: hr_utility.set_location('Has Duplicate Records', 25);
94: fnd_message.set_name('PER', 'HR_FR_DUP_ORG_MASS_UPD');
95: fnd_message.raise_error;
96: end if;
97: close csr_chk_dup_rec;
98: end if; -- no FR legislation
99: end if; -- legislation doesn't exists

Line 483: fnd_message.set_name('PQH','PQH_FR_DATE_SUGGESTION');

479: Fetch csr_suggest_eff_dt into l_date;
480: Close csr_suggest_eff_dt;
481:
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:

Line 484: fnd_message.set_token('DATE',l_date);

480: Close csr_suggest_eff_dt;
481:
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;

Line 521: fnd_message.set_name('PQH','PQH_FR_NO_PERSON_EXIST');

517: If csr_chk_person%notfound then
518: --
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;

Line 522: fnd_message.set_token('DATE',to_date(p_effective_date,'RRRR-MM-DD'));

518: --
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;

Line 535: fnd_message.set_name('PQH','PQH_FR_NO_CAREER');

531: Fetch csr_chk_career into l_temp;
532: If (l_temp is null) then -- Career is Not definied
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;

Line 536: fnd_message.set_token('DATE',to_date(p_effective_date,'RRRR-MM-DD'));

532: If (l_temp is null) then -- Career is Not definied
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;

Line 571: fnd_message.set_name('PQH','PQH_FR_NO_PERSON_EXIST');

567: If csr_chk_person%notfound then
568: --
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;

Line 572: fnd_message.set_token('DATE',to_date(p_effective_date,'RRRR-MM-DD'));

568: --
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;

Line 603: fnd_message.set_name('PQH','PQH_FR_NO_NORMAL_HOURS');

599: Open csr_normal_hours;
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:

Line 885: fnd_message.set_name('PQH','PQH_FR_NO_DEFAULT_SITUATION');

881: Fetch csr_situation_details into l_statutory_situation_id;
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: