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 HR_MULTI_MESSAGE

Line 65: hr_multi_message.add

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: );
69: --

Line 429: hr_multi_message.add

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: );
433: END IF;

Line 452: hr_multi_message.add

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: );
456: END IF;

Line 512: HR_MULTI_MESSAGE.add;

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);
516: --

Line 519: HR_MULTI_MESSAGE.add;

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
523: l_day_factor := 60;

Line 546: HR_MULTI_MESSAGE.add;

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;
550: WHILE l_date IS NOT NULL

Line 565: HR_MULTI_MESSAGE.add;

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

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 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 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 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 745: hr_multi_message.add();

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;
749: Fetch csr_person_info into l_original_hire_date;

Line 754: hr_multi_message.add();

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;
758: Fetch csr_situation_info into l_situ_end_date;

Line 763: hr_multi_message.add;

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

Line 842: HR_MULTI_MESSAGE.add(p_associated_column1 => 'PROVISIONAL_START_DATE'

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');
846: END IF;

Line 874: hr_multi_message.add

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
878: => 'CONTACT_RELATIONSHIP'

Line 983: HR_MULTI_MESSAGE.add;

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
987: FND_MESSAGE.set_name ('PQH', 'FR_PQH_PERIOD_OUT_OF_MAX_RANGE');

Line 988: 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.
992: IF l_duration_days < (lr_stat_sit_rec.min_duration_per_request*l_day_factor) THEN

Line 994: HR_MULTI_MESSAGE.add;

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
998: FND_MESSAGE.set_name ('PQH', 'FR_PQH_DURATION_LIMIT_EXCEEDS');

Line 999: 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);
1003: --

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