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.GHR_BEN_VALIDATION dependencies on HR_API

Line 225: 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','DR','KR','LR','MR','NR','PR') THEN

221:
222:
223: --Bug # 12973371
224: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
225: 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','DR','KR','LR','MR','NR','PR') THEN
226: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN
227: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
228: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
229: hr_utility.raise_error;

Line 226: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN

222:
223: --Bug # 12973371
224: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
225: 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','DR','KR','LR','MR','NR','PR') THEN
226: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN
227: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
228: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
229: hr_utility.raise_error;
230: END IF;

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

244: END IF;
245: END IF;
246:
247: END IF;
248: END IF; -- IF NVL(l_retirement_plan,hr_api.g_v
249:
250: IF p_which_eit = 'E' THEN
251: -- TSP Status should not be null
252: IF p_tsp_status IS NULL THEN

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

275: hr_utility.set_location('p_tsp_amount'||p_tsp_amount,10);
276: hr_utility.set_location('p_tsp_rate'||p_tsp_rate,10);
277: -- Status must be 'Y' or 'W' or 'A'
278: IF NVL(p_tsp_amount,'0') <> '0' OR NVL(p_tsp_rate,'0') <> '0' THEN
279: IF NVL(p_tsp_status,hr_api.g_varchar2) NOT IN ('Y','W','A') THEN
280: hr_utility.set_message(8301,'GHR_38678_INCORRECT_STATUS');
281: hr_utility.raise_error;
282: END IF;
283: END IF;

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

286: -- Bug # 13571004
287: --BUG # 13724018 modified to include the status Y, W or A
288: IF p_which_eit = 'R' AND (NVL(p_tsp_roth_401k_amt,'0') <> '0' OR NVL(p_tsp_roth_401k_rate,'0') <> '0') OR
289: NVL(p_tsp_amount,'0') <> '0' OR NVL(p_tsp_rate,'0') <> '0' THEN
290: IF NVL(p_tsp_status,hr_api.g_varchar2) NOT IN ('Y','W','A') THEN
291: hr_utility.set_message(8301,'GHR_38678_INCORRECT_STATUS');
292: hr_utility.raise_error;
293: END IF;
294: END IF;

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

452: hr_utility.raise_error;
453: END IF;
454: END IF;
455: -- If tenure code is not 0, then value should be null
456: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') AND NVL(p_tenure,hr_api.g_varchar2) <> '0' THEN
457: hr_utility.set_message(8301,'GHR_38954_TMP_ELIG_BLANK');
458: hr_utility.raise_error;
459: END IF;
460: -- This field is valid only for Temp. appointments. else throw error.

Line 541: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN

537:
538: --Bug# 11808857 modified to not to raise error when retirment plan is 4 and annuitant indicator is not in 2, 3, 9
539: IF p_tsp_scd IS NOT NULL AND p_retirement_plan IS NOT NULL THEN
540: IF p_retirement_plan NOT IN ('D','K','L','M','N','P') THEN
541: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN
542: -- Raise Error message
543: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');--Bug# 4769233
544: hr_utility.raise_error;
545: END IF;

Line 553: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN

549: --End Bug# 12557463
550: -- Bug # 11808857 modified to not to raise error when retirment plan is 4 and annuitant indicator is not in 2, 3, 9
551: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
552: IF p_retirement_plan NOT IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W','DR','KR','LR','MR','NR','PR') THEN
553: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN
554: -- Emp Contrib Elig date should be Null
555: IF p_emp_contrib_date IS NOT NULL THEN
556: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
557: hr_utility.raise_error;

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

556: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
557: hr_utility.raise_error;
558: END IF;
559: END IF;
560: END IF; -- IF NVL(l_retirement_plan,hr_api.g_v
561:
562: IF g_debug = TRUE THEN
563: hr_utility.set_location('If Retirement plan is not in FERS or CSRS ',1234);
564: END IF;

Line 620: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN

616: ELS*/
617: -- Bug # 11808857 modified to not to raise error when retirment plan is 4 and annuitant indicator is not in 2, 3, 9
618: --Bug# 15941036 added Retirement codes DR,KR,LR,MR,NR,PR
619: IF p_retirement_plan NOT IN ('D','K','L','M','N','P','DR','KR','LR','MR','NR','PR') AND p_agency_contrib_date IS NOT NULL THEN
620: IF NOT(NVL(p_retirement_plan,hr_api.g_varchar2) = '4' AND NVL(p_annuitant_indicator,hr_api.g_varchar2) NOT IN ('2','3','9')) THEN
621: hr_utility.set_message(8301,'GHR_38961_NOT_FERS_AGNCY_DATE');
622: hr_utility.raise_error;
623: END IF;
624: END IF;