APPS.PQH_PSU_BUS dependencies on PQH_FR_STAT_SIT_UTIL

Line 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);

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

Line 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);

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