APPS.GHR_BEN_VALIDATION dependencies on HR_API

Line 176: IF NVL(p_retirement_plan,hr_api.g_varchar2) NOT IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W') THEN

172: END IF; -- IF (p_which_eit = 'E' AND
173:
174: IF (p_which_eit = 'E' AND p_passed_element = 'TSP') OR p_which_eit = 'R' THEN
175: l_validate := TRUE;
176: IF NVL(p_retirement_plan,hr_api.g_varchar2) NOT IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W') THEN
177: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
178: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
179: hr_utility.raise_error;
180: END IF;

Line 187: END IF; -- IF NVL(l_retirement_plan,hr_api.g_v

183: IF p_tsp_status IS NOT NULL THEN
184: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
185: hr_utility.raise_error;
186: END IF;
187: END IF; -- IF NVL(l_retirement_plan,hr_api.g_v
188:
189: IF p_which_eit = 'E' THEN
190: -- TSP Status should not be null
191: IF p_tsp_status IS NULL THEN

Line 209: IF NVL(p_tsp_status,hr_api.g_varchar2) NOT IN ('Y','W') THEN

205: END IF;
206:
207: -- Status must be 'Y' or 'W'
208: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
209: IF NVL(p_tsp_status,hr_api.g_varchar2) NOT IN ('Y','W') THEN
210: hr_utility.set_message(8301,'GHR_38678_INCORRECT_STATUS');
211: hr_utility.raise_error;
212: END IF;
213: END IF;

Line 296: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') AND NVL(p_tenure,hr_api.g_varchar2) <> '0' THEN

292: hr_utility.raise_error;
293: END IF;
294: END IF;
295: -- If tenure code is not 0, then value should be null
296: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') AND NVL(p_tenure,hr_api.g_varchar2) <> '0' THEN
297: hr_utility.set_message(8301,'GHR_38954_TMP_ELIG_BLANK');
298: hr_utility.raise_error;
299: END IF;
300: -- This field is valid only for Temp. appointments. else throw error.

Line 391: END IF; -- IF NVL(l_retirement_plan,hr_api.g_v

387: IF p_emp_contrib_date IS NOT NULL THEN
388: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
389: hr_utility.raise_error;
390: END IF;
391: END IF; -- IF NVL(l_retirement_plan,hr_api.g_v
392:
393: IF g_debug = TRUE THEN
394: hr_utility.set_location('If Retirement plan is not in FERS or CSRS ',1234);
395: END IF;