297: ELSE
298: p_status_flag := 'NO';
299: IF p_rule_type = 'REQUIRED' THEN
300: fnd_message.set_name('PQH','PQH_FR_REQD_SIT_RULE_FAIL');
301: HR_MULTI_MESSAGE.ADD;
302: RAISE HR_MULTI_MESSAGE.error_message_exist;
303: EXIT;
304: END IF;
305: END IF;
298: p_status_flag := 'NO';
299: IF p_rule_type = 'REQUIRED' THEN
300: fnd_message.set_name('PQH','PQH_FR_REQD_SIT_RULE_FAIL');
301: HR_MULTI_MESSAGE.ADD;
302: RAISE HR_MULTI_MESSAGE.error_message_exist;
303: EXIT;
304: END IF;
305: END IF;
306: end if;
344: l_return_status := 'Y';
345: ELSE
346: l_return_status := 'N';
347: fnd_message.set_name('PQH','PQH_FR_OPT_SIT_RULE_FAIL');
348: HR_MULTI_MESSAGE.ADD;
349: RAISE HR_MULTI_MESSAGE.error_message_exist;
350: END IF;
351: END IF;
352: RETURN l_return_status;
345: ELSE
346: l_return_status := 'N';
347: fnd_message.set_name('PQH','PQH_FR_OPT_SIT_RULE_FAIL');
348: HR_MULTI_MESSAGE.ADD;
349: RAISE HR_MULTI_MESSAGE.error_message_exist;
350: END IF;
351: END IF;
352: RETURN l_return_status;
353: hr_utility.set_location('leaving is_situation_valid ',10);