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

Line 111: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_INVALID_SIT');

107: lr_sit_dtls.extend_probation_period_flag,
108: lr_sit_dtls.remunerate_assign_status_id;
109: IF csr_situation_details%NOTFOUND THEN
110: CLOSE csr_situation_details;
111: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_INVALID_SIT');
112: FND_MESSAGE.raise_error;
113: END IF;
114: CLOSE csr_situation_details;
115: --

Line 112: FND_MESSAGE.raise_error;

108: lr_sit_dtls.remunerate_assign_status_id;
109: IF csr_situation_details%NOTFOUND THEN
110: CLOSE csr_situation_details;
111: FND_MESSAGE.set_name('PQH','FR_PQH_STAT_SIT_INVALID_SIT');
112: FND_MESSAGE.raise_error;
113: END IF;
114: CLOSE csr_situation_details;
115: --
116: OPEN csr_career_dtls(p_person_id,p_start_date);

Line 239: FND_MESSAGE.set_name('PQH','FR_PQH_AFFECT_TERM_IN_FUTURE');

235: OPEN csr_invalid_term_assign(l_affect_asg_id,l_eff_dt);
236: FETCH csr_invalid_term_assign into l_term_exists;
237: IF csr_invalid_term_assign%FOUND THEN
238: CLOSE csr_invalid_term_assign;
239: FND_MESSAGE.set_name('PQH','FR_PQH_AFFECT_TERM_IN_FUTURE');
240: FND_MESSAGE.raise_error;
241: ELSE
242: CLOSE csr_invalid_term_assign;
243: END IF;

Line 240: FND_MESSAGE.raise_error;

236: FETCH csr_invalid_term_assign into l_term_exists;
237: IF csr_invalid_term_assign%FOUND THEN
238: CLOSE csr_invalid_term_assign;
239: FND_MESSAGE.set_name('PQH','FR_PQH_AFFECT_TERM_IN_FUTURE');
240: FND_MESSAGE.raise_error;
241: ELSE
242: CLOSE csr_invalid_term_assign;
243: END IF;
244: --

Line 297: FND_MESSAGE.set_name('PQH','FR_PQH_NO_REMU_ASG_STAT');

293: ,p_base_key_column => 'ASSIGNMENT_ID'
294: ,p_base_key_value => lr_career_rec.assignment_id);
295: --
296: IF lr_sit_dtls.remuneration_paid = 'Y' AND lr_sit_dtls.remunerate_assign_status_id = -1 THEN
297: FND_MESSAGE.set_name('PQH','FR_PQH_NO_REMU_ASG_STAT');
298: FND_MESSAGE.raise_error;
299: ELSIF lr_sit_dtls.remuneration_paid = 'Y' AND lr_sit_dtls.remunerate_assign_status_id <> -1 THEN
300: --
301: IF lr_career_rec.assignment_type = 'C' THEN

Line 298: FND_MESSAGE.raise_error;

294: ,p_base_key_value => lr_career_rec.assignment_id);
295: --
296: IF lr_sit_dtls.remuneration_paid = 'Y' AND lr_sit_dtls.remunerate_assign_status_id = -1 THEN
297: FND_MESSAGE.set_name('PQH','FR_PQH_NO_REMU_ASG_STAT');
298: FND_MESSAGE.raise_error;
299: ELSIF lr_sit_dtls.remuneration_paid = 'Y' AND lr_sit_dtls.remunerate_assign_status_id <> -1 THEN
300: --
301: IF lr_career_rec.assignment_type = 'C' THEN
302: --

Line 511: fnd_message.raise_error;

507: hr_utility.set_location(' Leaving:'||l_proc, 41);
508: When Others THEN
509: Rollback to create_emp_stat_situation;
510: hr_utility.set_location(' Leaving:'||l_proc, 42);
511: fnd_message.raise_error;
512: end CREATE_EMP_STAT_SITUATION;
513: procedure UPDATE_EMP_STAT_SITUATION
514: (p_validate IN boolean default false
515: ,p_effective_date IN date

Line 672: fnd_message.raise_error;

668: When Others THEN
669: Rollback to update_emp_stat_situation;
670: p_object_version_number := l_orig_object_version_number;
671: hr_utility.set_location(' Leaving:'||l_proc, 42 );
672: fnd_message.raise_error;
673: END UPDATE_EMP_STAT_SITUATION;
674: Procedure DELETE_EMP_STAT_SITUATION
675: ( P_VALIDATE IN BOOLEAN DEFAULT FALSE
676: ,P_EMP_STAT_SITUATION_ID IN NUMBER

Line 699: fnd_message.raise_error;

695: ROLLBACK TO delete_emp_stat_situation;
696: When Others THEN
697: Rollback to delete_emp_stat_situation;
698: hr_utility.set_location(' Leaving:'||l_proc, 42);
699: fnd_message.raise_error;
700: END DELETE_EMP_STAT_SITUATION;
701: --
702: --
703: procedure renew_emp_stat_situation

Line 737: fnd_message.set_name('PQH','FR_PQH_STS_INVALID_UNITS');

733: l_new_prov_end_date := add_months(lr_currec.provisional_end_date,p_renewal_duration);
734: ELSIF p_duration_units = 'Y' THEN
735: l_new_prov_end_date := add_months(lr_currec.provisional_end_date,p_renewal_duration*12);
736: ELSE
737: fnd_message.set_name('PQH','FR_PQH_STS_INVALID_UNITS');
738: hr_multi_message.add(p_associated_column1=> 'P_DURATION_UNITS');
739: END IF;
740: l_upd_sit_ovn := lr_currec.object_version_number;
741: --Extend the civil servant situation by the said duration and create a new renewal situation record

Line 772: fnd_message.raise_error;

768: ROLLBACK TO renew_emp_stat_situation;
769: When Others THEN
770: Rollback to renew_emp_stat_situation;
771: hr_utility.set_location(' Leaving:'||l_proc, 42);
772: fnd_message.raise_error;
773: end renew_emp_stat_situation;
774: procedure reinstate_emp_stat_situation
775: ( P_VALIDATE IN BOOLEAN DEFAULT FALSE
776: ,P_PERSON_ID IN NUMBER

Line 807: fnd_message.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT');

803: p_effective_date => p_reinstate_date,
804: p_situation_type => 'IA',
805: p_sub_type => 'IA_N');
806: IF l_reinstate_sit_id = -1 THEN
807: fnd_message.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT');
808: fnd_message.raise_error;
809: END IF;
810: OPEN csr_current_situation_dtls(p_emp_stat_situation_id);
811: FETCH csr_current_situation_dtls INTO lr_currec;

Line 808: fnd_message.raise_error;

804: p_situation_type => 'IA',
805: p_sub_type => 'IA_N');
806: IF l_reinstate_sit_id = -1 THEN
807: fnd_message.set_name('PQH','FR_PQH_STS_NO_DFLT_SIT');
808: fnd_message.raise_error;
809: END IF;
810: OPEN csr_current_situation_dtls(p_emp_stat_situation_id);
811: FETCH csr_current_situation_dtls INTO lr_currec;
812: IF csr_current_situation_dtls%NOTFOUND THEN

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

810: OPEN csr_current_situation_dtls(p_emp_stat_situation_id);
811: FETCH csr_current_situation_dtls INTO lr_currec;
812: IF csr_current_situation_dtls%NOTFOUND THEN
813: CLOSE csr_current_situation_dtls;
814: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
815: fnd_message.raise_error;
816: END IF;
817: CLOSE csr_current_situation_dtls;
818: l_upd_sit_ovn := lr_currec.object_version_number;

Line 815: fnd_message.raise_error;

811: FETCH csr_current_situation_dtls INTO lr_currec;
812: IF csr_current_situation_dtls%NOTFOUND THEN
813: CLOSE csr_current_situation_dtls;
814: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
815: fnd_message.raise_error;
816: END IF;
817: CLOSE csr_current_situation_dtls;
818: l_upd_sit_ovn := lr_currec.object_version_number;
819: --End Date the current situation and create a new situation with default situation for the employee.

Line 852: fnd_message.raise_error;

848: ROLLBACK TO reinstate_emp_stat_situation;
849: When Others THEN
850: Rollback to reinstate_emp_stat_situation;
851: hr_utility.set_location(' Leaving:'||l_proc, 42);
852: fnd_message.raise_error;
853: END REINSTATE_EMP_STAT_SITUATION;
854: --
855: end PQH_FR_EMP_STAT_SITUATION_API;