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.PQH_PSU_BUS dependencies on FND_MESSAGE

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

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

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

143: --
144: -- The primary key is invalid therefore we must error
145: --
146: close csr_leg_code;
147: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
148: fnd_message.raise_error;
149: end if;
150: hr_utility.set_location(l_proc,30);
151: --

Line 148: fnd_message.raise_error;

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

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

379: IF NOT pqh_psu_shd.api_updating
380: (p_emp_stat_situation_id => p_rec.emp_stat_situation_id
381: ,p_object_version_number => p_rec.object_version_number
382: ) THEN
383: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE ', l_proc);
385: fnd_message.set_token('STEP ', '5');
386: fnd_message.raise_error;
387: END IF;

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

380: (p_emp_stat_situation_id => p_rec.emp_stat_situation_id
381: ,p_object_version_number => p_rec.object_version_number
382: ) THEN
383: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE ', l_proc);
385: fnd_message.set_token('STEP ', '5');
386: fnd_message.raise_error;
387: END IF;
388: --

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

381: ,p_object_version_number => p_rec.object_version_number
382: ) THEN
383: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE ', l_proc);
385: fnd_message.set_token('STEP ', '5');
386: fnd_message.raise_error;
387: END IF;
388: --
389: --

Line 386: fnd_message.raise_error;

382: ) THEN
383: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
384: fnd_message.set_token('PROCEDURE ', l_proc);
385: fnd_message.set_token('STEP ', '5');
386: fnd_message.raise_error;
387: END IF;
388: --
389: --
390: if nvl(p_rec.statutory_situation_id, hr_api.g_number) <>

Line 428: fnd_message.set_name('PQH','FR_PQH_STAT_SIT_INVALID_EMP');

424: BEGIN
425: OPEN csr_valid_emp(p_person_id);
426: FETCH csr_valid_emp INTO l_valid_emp;
427: IF csr_valid_emp%NOTFOUND THEN
428: fnd_message.set_name('PQH','FR_PQH_STAT_SIT_INVALID_EMP');
429: hr_multi_message.add
430: (p_associated_column1
431: => 'PERSON_ID'
432: );

Line 451: fnd_message.set_name('PQH','FR_PQH_STAT_SIT_INVALID_SIT');

447: BEGIN
448: OPEN csr_valid_stat_sit(p_statutory_situation_id);
449: FETCH csr_valid_stat_sit INTO l_valid_sit;
450: IF csr_valid_stat_sit%NOTFOUND THEN
451: fnd_message.set_name('PQH','FR_PQH_STAT_SIT_INVALID_SIT');
452: hr_multi_message.add
453: (p_associated_column1
454: =>'STATUTORY_SITUATION_ID'
455: );

Line 511: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_NOT_RENEWABLE');

507: FETCH csr_renew_dtls INTO l_freq, l_renewable, l_max_renewals, l_max_dur_per_renew, l_max_tot_cont_dur;
508: CLOSE csr_renew_dtls;
509: --
510: IF l_renewable = 'N' THEN
511: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_NOT_RENEWABLE');
512: HR_MULTI_MESSAGE.add;
513: END IF;
514: --
515: l_no_of_renewals := pqh_fr_stat_sit_util.get_num_renewals(p_rec.emp_stat_situation_id,p_rec.renew_stat_situation_id);

Line 518: FND_MESSAGE.set_name('PQH','FR_PQH_MAX_RENEWALS_REACHED');

514: --
515: l_no_of_renewals := pqh_fr_stat_sit_util.get_num_renewals(p_rec.emp_stat_situation_id,p_rec.renew_stat_situation_id);
516: --
517: IF l_no_of_renewals >= l_max_renewals THEN
518: FND_MESSAGE.set_name('PQH','FR_PQH_MAX_RENEWALS_REACHED');
519: HR_MULTI_MESSAGE.add;
520: END IF;
521: --
522: IF l_freq = 'BM' THEN

Line 545: FND_MESSAGE.set_name ('PQH','FR_PQH_RENEW_OUT_OF_MAX_RANGE');

541: --
542: l_duration_days := p_rec.provisional_end_date - p_rec.provisional_start_date;
543: --
544: IF l_duration_days > (l_max_dur_per_renew*l_day_factor) THEN
545: FND_MESSAGE.set_name ('PQH','FR_PQH_RENEW_OUT_OF_MAX_RANGE');
546: HR_MULTI_MESSAGE.add;
547: END IF;
548: --
549: l_date := p_rec.provisional_start_date;

Line 564: FND_MESSAGE.set_name ('PQH', 'FR_PQH_RENEW_TOT_CONT_RANGE');

560: CLOSE csr_cont_renewals;
561: END LOOP;
562: --
563: IF (l_duration_days+NVL(l_cont_days,0)) > (l_max_tot_cont_dur*l_day_factor) THEN
564: FND_MESSAGE.set_name ('PQH', 'FR_PQH_RENEW_TOT_CONT_RANGE');
565: HR_MULTI_MESSAGE.add;
566: END IF;
567: --
568: END IF;

Line 625: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_NOT_RENEWABLE');

621: FETCH csr_renew_dtls INTO l_freq, l_renewable, l_max_renewals, l_max_dur_per_renew, l_max_tot_cont_dur;
622: CLOSE csr_renew_dtls;
623: --
624: IF l_renewable = 'N' THEN
625: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_NOT_RENEWABLE');
626: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
627: END IF;
628: --
629: l_no_of_renewals := pqh_fr_stat_sit_util.get_num_renewals(p_rec.emp_stat_situation_id,p_rec.renew_stat_situation_id);

Line 626: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;

622: CLOSE csr_renew_dtls;
623: --
624: IF l_renewable = 'N' THEN
625: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_NOT_RENEWABLE');
626: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
627: END IF;
628: --
629: l_no_of_renewals := pqh_fr_stat_sit_util.get_num_renewals(p_rec.emp_stat_situation_id,p_rec.renew_stat_situation_id);
630: --

Line 632: FND_MESSAGE.set_name('PQH','FR_PQH_MAX_RENEWALS_REACHED');

628: --
629: l_no_of_renewals := pqh_fr_stat_sit_util.get_num_renewals(p_rec.emp_stat_situation_id,p_rec.renew_stat_situation_id);
630: --
631: IF l_max_renewals IS NOT NULL AND NVL(l_no_of_renewals,0) >= l_max_renewals THEN
632: FND_MESSAGE.set_name('PQH','FR_PQH_MAX_RENEWALS_REACHED');
633: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
634: END IF;
635: --
636: l_start_date := TRUNC(NVL(p_rec.actual_start_date,p_rec.provisional_start_date));

Line 633: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;

629: l_no_of_renewals := pqh_fr_stat_sit_util.get_num_renewals(p_rec.emp_stat_situation_id,p_rec.renew_stat_situation_id);
630: --
631: IF l_max_renewals IS NOT NULL AND NVL(l_no_of_renewals,0) >= l_max_renewals THEN
632: FND_MESSAGE.set_name('PQH','FR_PQH_MAX_RENEWALS_REACHED');
633: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
634: END IF;
635: --
636: l_start_date := TRUNC(NVL(p_rec.actual_start_date,p_rec.provisional_start_date));
637: --

Line 689: FND_MESSAGE.set_name ('PQH','FR_PQH_RENEW_OUT_OF_MAX_RANGE');

685: l_mtcd := HR_GENERAL.end_of_time;
686: END IF;
687: --
688: IF l_max_dur_per_renew IS NOT NULL AND NVL(p_rec.actual_end_date,p_rec.provisional_end_date) >= l_mdpr THEN
689: FND_MESSAGE.set_name ('PQH','FR_PQH_RENEW_OUT_OF_MAX_RANGE');
690: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
691: END IF;
692: --
693: l_cont_days := 0;

Line 690: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;

686: END IF;
687: --
688: IF l_max_dur_per_renew IS NOT NULL AND NVL(p_rec.actual_end_date,p_rec.provisional_end_date) >= l_mdpr THEN
689: FND_MESSAGE.set_name ('PQH','FR_PQH_RENEW_OUT_OF_MAX_RANGE');
690: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
691: END IF;
692: --
693: l_cont_days := 0;
694: l_date := p_rec.provisional_start_date;

Line 711: FND_MESSAGE.set_name ('PQH', 'FR_PQH_RENEW_TOT_CONT_RANGE');

707: --
708: --Use (l_mtcd-1) because l_mtcd calculation adds one more day.
709: IF l_max_tot_cont_dur IS NOT NULL AND
710: (TRUNC(NVL(p_rec.actual_end_date,p_rec.provisional_end_date)+NVL(l_cont_days,0)) > (l_mtcd-1)) THEN
711: FND_MESSAGE.set_name ('PQH', 'FR_PQH_RENEW_TOT_CONT_RANGE');
712: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
713: END IF;
714: --
715: END IF;

Line 712: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;

708: --Use (l_mtcd-1) because l_mtcd calculation adds one more day.
709: IF l_max_tot_cont_dur IS NOT NULL AND
710: (TRUNC(NVL(p_rec.actual_end_date,p_rec.provisional_end_date)+NVL(l_cont_days,0)) > (l_mtcd-1)) THEN
711: FND_MESSAGE.set_name ('PQH', 'FR_PQH_RENEW_TOT_CONT_RANGE');
712: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
713: END IF;
714: --
715: END IF;
716: --

Line 744: fnd_message.set_name('PQH','PQH_FR_NO_GRT_STARTDT');

740: Begin
741: --
742: if (p_provisional_start_date > p_provisional_end_date ) then
743: --
744: fnd_message.set_name('PQH','PQH_FR_NO_GRT_STARTDT');
745: hr_multi_message.add();
746: --
747: End If;
748: Open csr_person_info;

Line 753: fnd_message.set_name('PQH','PQH_FR_NOSIT_BFOR_HIREDT');

749: Fetch csr_person_info into l_original_hire_date;
750: Close csr_person_info;
751: If (p_provisional_start_date< l_original_hire_date ) Then
752: --
753: fnd_message.set_name('PQH','PQH_FR_NOSIT_BFOR_HIREDT');
754: hr_multi_message.add();
755: --
756: End If;
757: Open csr_situation_info;

Line 762: fnd_message.set_name('PQH','PQH_FR_SITU_ENDDT_IS_LESS');

758: Fetch csr_situation_info into l_situ_end_date;
759: Close csr_situation_info;
760: If (p_provisional_end_date > l_situ_end_date ) Then
761: --
762: fnd_message.set_name('PQH','PQH_FR_SITU_ENDDT_IS_LESS');
763: hr_multi_message.add;
764: --
765: End If;
766: End;

Line 841: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_OVERLAP_DATES');

837: p_rec.person_id,p_rec.emp_stat_situation_id);
838: FETCH csr_overlap_dates INTO l_valid;
839: IF csr_overlap_dates%FOUND THEN
840: CLOSE csr_overlap_dates;
841: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_OVERLAP_DATES');
842: HR_MULTI_MESSAGE.add(p_associated_column1 => 'PROVISIONAL_START_DATE'
843: ,p_associated_column2 => 'PROVISIONAL_END_DATE'
844: ,p_associated_column3 => 'ACTUAL_START_DATE'
845: ,p_associated_column4 => 'ACTUAL_END_DATE');

Line 873: fnd_message.set_name('PQH','FR_PQH_STAT_SIT_INVALID_CNTCT');

869: OPEN Csr_contact_dtls(p_rec.contact_person_id, p_rec.person_id,p_rec.contact_relationship);
870: FETCH csr_contact_dtls INTO lr_contact.date_start, lr_contact.date_end;
871: IF csr_contact_dtls%NOTFOUND THEN
872: CLOSE csr_contact_dtls;
873: fnd_message.set_name('PQH','FR_PQH_STAT_SIT_INVALID_CNTCT');
874: hr_multi_message.add
875: (p_associated_column1
876: => 'CONTACT_PERSON_ID'
877: ,p_associated_column2

Line 982: FND_MESSAGE.set_name ('PQH','FR_PQH_EXCEEDS_FIRST_DURATION');

978: --
979: --If Situation does not exist.
980: IF lr_previous_exist.x IS NULL THEN
981: IF l_duration_days > (lr_stat_sit_rec.first_period_max_duration*l_day_factor) THEN
982: FND_MESSAGE.set_name ('PQH','FR_PQH_EXCEEDS_FIRST_DURATION');
983: HR_MULTI_MESSAGE.add;
984: END IF;
985: --If Situation exists.
986: ELSIF l_duration_days > (lr_stat_sit_rec.max_duration_per_request*l_day_factor) THEN

Line 987: FND_MESSAGE.set_name ('PQH', 'FR_PQH_PERIOD_OUT_OF_MAX_RANGE');

983: HR_MULTI_MESSAGE.add;
984: END IF;
985: --If Situation exists.
986: ELSIF l_duration_days > (lr_stat_sit_rec.max_duration_per_request*l_day_factor) THEN
987: FND_MESSAGE.set_name ('PQH', 'FR_PQH_PERIOD_OUT_OF_MAX_RANGE');
988: HR_MULTI_MESSAGE.add;
989: END IF;
990: --
991: --Modified by deenath. Moved below condition out of "If Situation Exists" condition.

Line 993: FND_MESSAGE.set_name ('PQH', 'FR_PQH_PERIOD_OUT_OF_MIN_RANGE');

989: END IF;
990: --
991: --Modified by deenath. Moved below condition out of "If Situation Exists" condition.
992: IF l_duration_days < (lr_stat_sit_rec.min_duration_per_request*l_day_factor) THEN
993: FND_MESSAGE.set_name ('PQH', 'FR_PQH_PERIOD_OUT_OF_MIN_RANGE');
994: HR_MULTI_MESSAGE.add;
995: END IF;
996: --
997: IF l_duration_days+NVL(l_total_duration_days,0) > (lr_stat_sit_rec.max_duration_whole_career*l_day_factor) THEN

Line 998: FND_MESSAGE.set_name ('PQH', 'FR_PQH_DURATION_LIMIT_EXCEEDS');

994: HR_MULTI_MESSAGE.add;
995: END IF;
996: --
997: IF l_duration_days+NVL(l_total_duration_days,0) > (lr_stat_sit_rec.max_duration_whole_career*l_day_factor) THEN
998: FND_MESSAGE.set_name ('PQH', 'FR_PQH_DURATION_LIMIT_EXCEEDS');
999: HR_MULTI_MESSAGE.add;
1000: END IF;
1001: --
1002: HR_UTILITY.set_location ('Leaving: '||l_proc,5);

Line 1187: FND_MESSAGE.set_name('PQH','FR_PQH_PERIOD_OUT_OF_MAX_RANGE');

1183: --
1184: IF NVL(l_previous_exist,'N') = 'Y' THEN --If Situation exists.
1185: --
1186: IF NVL(p_rec.actual_end_date,p_rec.provisional_end_date) >= l_max_dpr THEN
1187: FND_MESSAGE.set_name('PQH','FR_PQH_PERIOD_OUT_OF_MAX_RANGE');
1188: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1189: END IF;
1190: --
1191: ELSE --If Situation does not exist.

Line 1188: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;

1184: IF NVL(l_previous_exist,'N') = 'Y' THEN --If Situation exists.
1185: --
1186: IF NVL(p_rec.actual_end_date,p_rec.provisional_end_date) >= l_max_dpr THEN
1187: FND_MESSAGE.set_name('PQH','FR_PQH_PERIOD_OUT_OF_MAX_RANGE');
1188: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1189: END IF;
1190: --
1191: ELSE --If Situation does not exist.
1192: --

Line 1194: FND_MESSAGE.set_name ('PQH','FR_PQH_EXCEEDS_FIRST_DURATION');

1190: --
1191: ELSE --If Situation does not exist.
1192: --
1193: IF NVL(p_rec.actual_end_date,p_rec.provisional_end_date) >= l_fpmd THEN
1194: FND_MESSAGE.set_name ('PQH','FR_PQH_EXCEEDS_FIRST_DURATION');
1195: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1196: END IF;
1197: --
1198: END IF;

Line 1195: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;

1191: ELSE --If Situation does not exist.
1192: --
1193: IF NVL(p_rec.actual_end_date,p_rec.provisional_end_date) >= l_fpmd THEN
1194: FND_MESSAGE.set_name ('PQH','FR_PQH_EXCEEDS_FIRST_DURATION');
1195: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1196: END IF;
1197: --
1198: END IF;
1199: --

Line 1202: FND_MESSAGE.set_name ('PQH','FR_PQH_PERIOD_OUT_OF_MIN_RANGE');

1198: END IF;
1199: --
1200: --Use (l_min_dpr-1) because Calculated Date is one day more than valid Minimum Start Date.
1201: IF NVL(p_rec.actual_end_date,p_rec.provisional_end_date) < TRUNC(l_min_dpr-1) THEN
1202: FND_MESSAGE.set_name ('PQH','FR_PQH_PERIOD_OUT_OF_MIN_RANGE');
1203: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1204: END IF;
1205: --
1206: --Use (l_mdwc-1) because Calculated Date is one day more than valid Maximum Duration Whole Career.

Line 1203: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;

1199: --
1200: --Use (l_min_dpr-1) because Calculated Date is one day more than valid Minimum Start Date.
1201: IF NVL(p_rec.actual_end_date,p_rec.provisional_end_date) < TRUNC(l_min_dpr-1) THEN
1202: FND_MESSAGE.set_name ('PQH','FR_PQH_PERIOD_OUT_OF_MIN_RANGE');
1203: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1204: END IF;
1205: --
1206: --Use (l_mdwc-1) because Calculated Date is one day more than valid Maximum Duration Whole Career.
1207: IF TRUNC(NVL(p_rec.actual_end_date,p_rec.provisional_end_date)+NVL(l_total_duration_days,0)) > TRUNC(l_mdwc-1) THEN

Line 1208: FND_MESSAGE.set_name ('PQH','FR_PQH_DURATION_LIMIT_EXCEEDS');

1204: END IF;
1205: --
1206: --Use (l_mdwc-1) because Calculated Date is one day more than valid Maximum Duration Whole Career.
1207: IF TRUNC(NVL(p_rec.actual_end_date,p_rec.provisional_end_date)+NVL(l_total_duration_days,0)) > TRUNC(l_mdwc-1) THEN
1208: FND_MESSAGE.set_name ('PQH','FR_PQH_DURATION_LIMIT_EXCEEDS');
1209: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1210: END IF;
1211: --
1212: HR_UTILITY.set_location ('Leaving: '||l_proc,5);

Line 1209: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;

1205: --
1206: --Use (l_mdwc-1) because Calculated Date is one day more than valid Maximum Duration Whole Career.
1207: IF TRUNC(NVL(p_rec.actual_end_date,p_rec.provisional_end_date)+NVL(l_total_duration_days,0)) > TRUNC(l_mdwc-1) THEN
1208: FND_MESSAGE.set_name ('PQH','FR_PQH_DURATION_LIMIT_EXCEEDS');
1209: FND_MESSAGE.raise_error;--HR_MULTI_MESSAGE.add;
1210: END IF;
1211: --
1212: HR_UTILITY.set_location ('Leaving: '||l_proc,5);
1213: --