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_FR_EMP_STAT_SIT_UTILITY dependencies on FND_MESSAGE

Line 154: FND_MESSAGE.set_name('PQH','FR_PQH_STS_NO_IAND_SIT'); --In Activity Normal Default sitution does not exist for the specified duration. A Situation can only be created when an In Activity Normal Default situation exists in the duration.

150: l_iand_act_start_dt,l_iand_prv_start_dt,
151: l_iand_act_end_dt,l_iand_prv_end_dt;
152: IF csr_get_inactivity%NOTFOUND THEN
153: CLOSE csr_get_inactivity;
154: FND_MESSAGE.set_name('PQH','FR_PQH_STS_NO_IAND_SIT'); --In Activity Normal Default sitution does not exist for the specified duration. A Situation can only be created when an In Activity Normal Default situation exists in the duration.
155: HR_MULTI_MESSAGE.ADD;
156: RAISE HR_MULTI_MESSAGE.error_message_exist;
157: END IF;
158: IF csr_get_inactivity%ISOPEN THEN

Line 169: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_OVERLAP_DATES'); --The Start and/or End Date for this situation overlaps with other situation. Please enter non overlapping dates.

165: p_person_id,p_emp_stat_situation_id,l_iand_stat_sit_id);
166: FETCH csr_overlaps INTO l_valid;
167: IF csr_overlaps%FOUND THEN
168: CLOSE csr_overlaps;
169: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_OVERLAP_DATES'); --The Start and/or End Date for this situation overlaps with other situation. Please enter non overlapping dates.
170: HR_MULTI_MESSAGE.ADD;
171: RAISE HR_MULTI_MESSAGE.error_message_exist;
172: END IF;
173: IF csr_overlaps%ISOPEN THEN

Line 470: FND_MESSAGE.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

466: OPEN csr_current_situation_dtls(p_emp_stat_situation_id);
467: FETCH csr_current_situation_dtls INTO l_person_id,l_sit_id,l_act_st_dt,l_prov_st_dt,l_act_end_dt,l_prov_end_dt;
468: IF csr_current_situation_dtls%NOTFOUND THEN
469: CLOSE csr_current_situation_dtls;
470: FND_MESSAGE.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
471: HR_MULTI_MESSAGE.ADD;
472: RAISE HR_MULTI_MESSAGE.error_message_exist;
473: END IF;
474: CLOSE csr_current_situation_dtls;

Line 483: FND_MESSAGE.set_name('PQH','FR_PQH_PRIOR_SIT_NOT_FND'); --Cannot Update/Delete because no situation exists prior to this situation.

479: l_prior_prov_st_date, l_prior_act_st_date,
480: l_prior_prov_end_date, l_prior_act_end_date;
481: IF csr_get_prior_sit_dtls%NOTFOUND THEN
482: CLOSE csr_get_prior_sit_dtls;
483: FND_MESSAGE.set_name('PQH','FR_PQH_PRIOR_SIT_NOT_FND'); --Cannot Update/Delete because no situation exists prior to this situation.
484: HR_MULTI_MESSAGE.ADD;
485: RAISE HR_MULTI_MESSAGE.error_message_exist;
486: END IF;
487: CLOSE csr_get_prior_sit_dtls;

Line 496: FND_MESSAGE.set_name('PQH','FR_PQH_NEXT_SIT_NOT_FND'); --Cannot Update/Delete because no situation exists after this situation.

492: l_next_act_st_date,l_next_prov_st_date,
493: l_next_prov_end_date, l_next_act_end_date;
494: IF csr_get_next_sit_dtls%NOTFOUND THEN
495: CLOSE csr_get_next_sit_dtls;
496: FND_MESSAGE.set_name('PQH','FR_PQH_NEXT_SIT_NOT_FND'); --Cannot Update/Delete because no situation exists after this situation.
497: HR_MULTI_MESSAGE.ADD;
498: RAISE HR_MULTI_MESSAGE.error_message_exist;
499: END IF;
500: CLOSE csr_get_next_sit_dtls;

Line 509: FND_MESSAGE.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT'); --In Activity Normal Default Situation does not exist.

505: ,p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
506: ,p_situation_type => 'IA'
507: ,p_sub_type => 'IA_N');
508: IF l_iand_sit_id = -1 THEN
509: FND_MESSAGE.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT'); --In Activity Normal Default Situation does not exist.
510: HR_MULTI_MESSAGE.ADD;
511: RAISE HR_MULTI_MESSAGE.error_message_exist;
512: END IF;
513: --

Line 520: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_OVERLAP_DATES'); --The Start and/or End Date for this situation overlaps with other situation. Please enter non overlapping dates.

516: p_person_id,p_emp_stat_situation_id,l_iand_sit_id);
517: FETCH csr_overlaps INTO l_valid;
518: IF csr_overlaps%FOUND THEN
519: CLOSE csr_overlaps;
520: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_OVERLAP_DATES'); --The Start and/or End Date for this situation overlaps with other situation. Please enter non overlapping dates.
521: HR_MULTI_MESSAGE.ADD;
522: RAISE HR_MULTI_MESSAGE.error_message_exist;
523: END IF;
524: IF csr_overlaps%ISOPEN THEN

Line 530: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_RENEW'); --Cannot update because this is a Renewal Situation.

526: END IF;
527: --
528: --If prior Sit is IAND and next Sit is IAND then
529: IF l_prior_sit_id <> l_iand_sit_id OR l_next_sit_id <> l_iand_sit_id THEN
530: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_RENEW'); --Cannot update because this is a Renewal Situation.
531: HR_MULTI_MESSAGE.ADD;
532: RAISE HR_MULTI_MESSAGE.error_message_exist;
533: END IF;
534: --

Line 741: FND_MESSAGE.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT'); --In Activity Normal Default Situation does not exist.

737: ,p_effective_date => p_reinstate_date
738: ,p_situation_type => 'IA'
739: ,p_sub_type => 'IA_N');
740: IF l_reinstate_sit_id = -1 THEN
741: FND_MESSAGE.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT'); --In Activity Normal Default Situation does not exist.
742: HR_MULTI_MESSAGE.ADD;
743: RAISE HR_MULTI_MESSAGE.error_message_exist;
744: END IF;
745: --

Line 751: FND_MESSAGE.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

747: OPEN csr_current_situation_dtls(p_emp_stat_situation_id);
748: FETCH csr_current_situation_dtls INTO lr_currec;
749: IF csr_current_situation_dtls%NOTFOUND THEN
750: CLOSE csr_current_situation_dtls;
751: FND_MESSAGE.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
752: HR_MULTI_MESSAGE.ADD;
753: RAISE HR_MULTI_MESSAGE.error_message_exist;
754: END IF;
755: CLOSE csr_current_situation_dtls;

Line 760: FND_MESSAGE.set_name('PQH','FR_PQH_INVLD_REINSTATE_DT'); --Invalid Reinstate Date entered. It must be between Start Date and End Date.

756: --
757: --Check Reinstate Date is valid.
758: IF(TRUNC(p_reinstate_date) <= TRUNC(NVL(lr_currec.actual_start_date,lr_currec.provisional_start_date)) OR
759: TRUNC(p_reinstate_date) > TRUNC(NVL(lr_currec.actual_end_date,lr_currec.provisional_end_date)+1)) THEN
760: FND_MESSAGE.set_name('PQH','FR_PQH_INVLD_REINSTATE_DT'); --Invalid Reinstate Date entered. It must be between Start Date and End Date.
761: HR_MULTI_MESSAGE.ADD;
762: RAISE HR_MULTI_MESSAGE.error_message_exist;
763: END IF;
764: --

Line 770: FND_MESSAGE.set_name('PQH','FR_PQH_IAND_NOT_FND'); --Cannot Renew/Reinstate because this Situation has already been Renewed or Reinstated.

766: OPEN csr_get_iand_dtls(l_reinstate_sit_id,NVL(lr_currec.actual_end_date,lr_currec.provisional_end_date));
767: FETCH csr_get_iand_dtls INTO l_iand_emp_stat_sit_id,l_iand_prov_end_date,l_iand_act_end_date,l_iand_ovn;
768: IF csr_get_iand_dtls%NOTFOUND THEN
769: CLOSE csr_get_iand_dtls;
770: FND_MESSAGE.set_name('PQH','FR_PQH_IAND_NOT_FND'); --Cannot Renew/Reinstate because this Situation has already been Renewed or Reinstated.
771: HR_MULTI_MESSAGE.ADD;
772: RAISE HR_MULTI_MESSAGE.error_message_exist;
773: END IF;
774: CLOSE csr_get_iand_dtls;

Line 950: FND_MESSAGE.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

946: l_rn_act_end_date,l_rn_prov_end_date,
947: l_rn_renewal_flag,l_rn_renew_stat_sit_id,l_rn_ovn;
948: IF csr_current_situation_dtls%NOTFOUND THEN
949: CLOSE csr_current_situation_dtls;
950: FND_MESSAGE.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
951: HR_MULTI_MESSAGE.ADD;
952: RAISE HR_MULTI_MESSAGE.error_message_exist;
953: END IF;
954: CLOSE csr_current_situation_dtls;

Line 964: FND_MESSAGE.set_name('PQH', 'FR_PQH_STS_RENEW_NOT_FND'); --Cannot find latest renewal for the Situation.

960: l_rn_approval_flag,l_rn_act_st_date,l_rn_prov_st_date,
961: l_rn_act_end_date,l_rn_prov_end_date,l_rn_ovn;
962: IF csr_renew_situation_dtls%NOTFOUND THEN
963: CLOSE csr_renew_situation_dtls;
964: FND_MESSAGE.set_name('PQH', 'FR_PQH_STS_RENEW_NOT_FND'); --Cannot find latest renewal for the Situation.
965: HR_MULTI_MESSAGE.ADD;
966: RAISE HR_MULTI_MESSAGE.error_message_exist;
967: END IF;
968: CLOSE csr_renew_situation_dtls;

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

978: l_renew_end_date := ADD_MONTHS(l_renew_start_date,p_renewal_duration);
979: ELSIF p_duration_units = 'Y' THEN
980: l_renew_end_date := ADD_MONTHS(l_renew_start_date,p_renewal_duration*12);
981: ELSE
982: FND_MESSAGE.set_name('PQH','FR_PQH_STS_INVALID_UNITS');
983: HR_MULTI_MESSAGE.add;
984: RAISE HR_MULTI_MESSAGE.error_message_exist;
985: END IF;
986: --

Line 993: FND_MESSAGE.set_name('PQH','FR_PQH_IAND_NOT_FND'); --Cannot Renew/Reinstate because this Situation has already been Renewed or Reinstated.

989: FETCH csr_get_iand_dtls INTO l_iand_emp_stat_sit_id,l_iand_stat_sit_id,l_iand_ovn,
990: l_iand_prov_end_date,l_iand_act_end_date;
991: IF csr_get_iand_dtls%NOTFOUND THEN
992: CLOSE csr_get_iand_dtls;
993: FND_MESSAGE.set_name('PQH','FR_PQH_IAND_NOT_FND'); --Cannot Renew/Reinstate because this Situation has already been Renewed or Reinstated.
994: HR_MULTI_MESSAGE.ADD;
995: RAISE HR_MULTI_MESSAGE.error_message_exist;
996: END IF;
997: CLOSE csr_get_iand_dtls;

Line 1001: FND_MESSAGE.set_name('PQH','FR_PQH_IAND_NOT_FND'); --Cannot Renew/Reinstate because this Situation has already been Renewed or Reinstated.

997: CLOSE csr_get_iand_dtls;
998: --
999: --Check whether IAND exists for entire duration of the Renewal.
1000: IF l_renew_end_date > NVL(l_iand_act_end_date,NVL(l_iand_prov_end_date,HR_GENERAL.end_of_time)) THEN
1001: FND_MESSAGE.set_name('PQH','FR_PQH_IAND_NOT_FND'); --Cannot Renew/Reinstate because this Situation has already been Renewed or Reinstated.
1002: HR_MULTI_MESSAGE.ADD;
1003: RAISE HR_MULTI_MESSAGE.error_message_exist;
1004: END IF;
1005: --

Line 1175: FND_MESSAGE.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

1171: FETCH csr_current_situation_dtls INTO l_person_id, l_act_st_dt, l_prov_st_dt,
1172: l_act_end_dt, l_prov_end_dt;
1173: IF csr_current_situation_dtls%NOTFOUND THEN
1174: CLOSE csr_current_situation_dtls;
1175: FND_MESSAGE.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
1176: HR_MULTI_MESSAGE.ADD;
1177: RAISE HR_MULTI_MESSAGE.error_message_exist;
1178: END IF;
1179: CLOSE csr_current_situation_dtls;

Line 1188: FND_MESSAGE.set_name('PQH','FR_PQH_PRIOR_SIT_NOT_FND'); --Cannot Update/Delete because no situation exists prior to this situation.

1184: l_prior_prov_st_date, l_prior_act_st_date,
1185: l_prior_prov_end_date, l_prior_act_end_date;
1186: IF csr_get_prior_sit_dtls%NOTFOUND THEN
1187: CLOSE csr_get_prior_sit_dtls;
1188: FND_MESSAGE.set_name('PQH','FR_PQH_PRIOR_SIT_NOT_FND'); --Cannot Update/Delete because no situation exists prior to this situation.
1189: HR_MULTI_MESSAGE.ADD;
1190: RAISE HR_MULTI_MESSAGE.error_message_exist;
1191: END IF;
1192: CLOSE csr_get_prior_sit_dtls;

Line 1200: FND_MESSAGE.set_name('PQH','FR_PQH_NEXT_SIT_NOT_FND'); --Cannot Update/Delete because no situation exists after this situation.

1196: FETCH csr_get_next_sit_dtls INTO l_next_emp_stat_sit_id, l_next_sit_id, l_next_ovn,
1197: l_next_prov_end_date, l_next_act_end_date;
1198: IF csr_get_next_sit_dtls%NOTFOUND THEN
1199: CLOSE csr_get_next_sit_dtls;
1200: FND_MESSAGE.set_name('PQH','FR_PQH_NEXT_SIT_NOT_FND'); --Cannot Update/Delete because no situation exists after this situation.
1201: HR_MULTI_MESSAGE.ADD;
1202: RAISE HR_MULTI_MESSAGE.error_message_exist;
1203: END IF;
1204: CLOSE csr_get_next_sit_dtls;

Line 1213: FND_MESSAGE.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT'); --In Activity Normal Default Situation does not exist.

1209: ,p_effective_date => TRUNC(NVL(l_act_st_dt,l_prov_st_dt))
1210: ,p_situation_type => 'IA'
1211: ,p_sub_type => 'IA_N');
1212: IF l_iand_sit_id = -1 THEN
1213: FND_MESSAGE.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT'); --In Activity Normal Default Situation does not exist.
1214: HR_MULTI_MESSAGE.ADD;
1215: RAISE HR_MULTI_MESSAGE.error_message_exist;
1216: END IF;
1217: --