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_UTILITY

Line 4: --g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY GHR_BEN_VALIDATION AS
2: /* $Header: ghbenval.pkb 120.29.12020000.13 2013/02/06 11:08:33 vmididho ship $ */
3: --
4: --g_debug BOOLEAN := hr_utility.debug_enabled;
5:
6: g_debug BOOLEAN := TRUE;
7:
8: PROCEDURE validate_benefits(

Line 124: hr_utility.set_location('Entering check_element_exist',12);

120: -- l_business_group_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
121: FND_PROFILE.get('PER_BUSINESS_GROUP_ID', l_business_group_id);
122:
123: IF g_debug = TRUE THEN
124: hr_utility.set_location('Entering check_element_exist',12);
125: hr_utility.set_location('l_business_group_id ' || l_business_group_id,12);
126: END IF;
127: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name(p_element_name,l_business_group_id,p_effective_date,null);
128:

Line 125: hr_utility.set_location('l_business_group_id ' || l_business_group_id,12);

121: FND_PROFILE.get('PER_BUSINESS_GROUP_ID', l_business_group_id);
122:
123: IF g_debug = TRUE THEN
124: hr_utility.set_location('Entering check_element_exist',12);
125: hr_utility.set_location('l_business_group_id ' || l_business_group_id,12);
126: END IF;
127: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name(p_element_name,l_business_group_id,p_effective_date,null);
128:
129: IF g_debug = TRUE THEN

Line 130: hr_utility.set_location('l_new_element_name ' || l_new_element_name,12);

126: END IF;
127: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name(p_element_name,l_business_group_id,p_effective_date,null);
128:
129: IF g_debug = TRUE THEN
130: hr_utility.set_location('l_new_element_name ' || l_new_element_name,12);
131: END IF;
132:
133: FOR l_cur_el_type IN c_element_type_id(l_new_element_name,l_business_group_id,p_effective_date) LOOP
134: l_element_type_id := l_cur_el_type.element_type_id;

Line 138: hr_utility.set_location('l_element_type_id ' || l_element_type_id,12);

134: l_element_type_id := l_cur_el_type.element_type_id;
135: END LOOP;
136:
137: IF g_debug = TRUE THEN
138: hr_utility.set_location('l_element_type_id ' || l_element_type_id,12);
139: hr_utility.set_location('p_assignment_id ' || p_assignment_id,12);
140: END IF;
141:
142: FOR l_cur_el_exists IN c_element_exist(p_assignment_id, p_effective_date, l_element_type_id) LOOP

Line 139: hr_utility.set_location('p_assignment_id ' || p_assignment_id,12);

135: END LOOP;
136:
137: IF g_debug = TRUE THEN
138: hr_utility.set_location('l_element_type_id ' || l_element_type_id,12);
139: hr_utility.set_location('p_assignment_id ' || p_assignment_id,12);
140: END IF;
141:
142: FOR l_cur_el_exists IN c_element_exist(p_assignment_id, p_effective_date, l_element_type_id) LOOP
143: l_exists := TRUE;

Line 145: hr_utility.set_location(l_new_element_name || 'element exists',12);

141:
142: FOR l_cur_el_exists IN c_element_exist(p_assignment_id, p_effective_date, l_element_type_id) LOOP
143: l_exists := TRUE;
144: IF g_debug = TRUE THEN
145: hr_utility.set_location(l_new_element_name || 'element exists',12);
146: END IF;
147: END LOOP;
148:
149: RETURN l_exists;

Line 155: hr_utility.set_location('which eit' || p_which_eit,12);

151: BEGIN
152: -- Validation for Health Plan
153: -- If called from element entry
154: l_validate := TRUE;
155: hr_utility.set_location('which eit' || p_which_eit,12);
156: IF (p_which_eit = 'E' AND p_passed_element = 'Health Benefits') OR p_which_eit = 'R'
157: THEN
158: IF g_debug = TRUE THEN
159:

Line 160: hr_utility.set_location('p_health_plan' || p_health_plan,12);

156: IF (p_which_eit = 'E' AND p_passed_element = 'Health Benefits') OR p_which_eit = 'R'
157: THEN
158: IF g_debug = TRUE THEN
159:
160: hr_utility.set_location('p_health_plan' || p_health_plan,12);
161: hr_utility.set_location('p_noa_family_code' || p_noa_family_code,12);
162: END IF;
163:
164: IF p_which_eit = 'R' AND p_noa_family_code IN ('CONV_APP','EXT_NTE') THEN

Line 161: hr_utility.set_location('p_noa_family_code' || p_noa_family_code,12);

157: THEN
158: IF g_debug = TRUE THEN
159:
160: hr_utility.set_location('p_health_plan' || p_health_plan,12);
161: hr_utility.set_location('p_noa_family_code' || p_noa_family_code,12);
162: END IF;
163:
164: IF p_which_eit = 'R' AND p_noa_family_code IN ('CONV_APP','EXT_NTE') THEN
165: IF p_health_plan IS NULL AND

Line 178: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');

174: END IF; -- IF p_which_eit = 'R' AND p_no
175:
176: IF l_validate = TRUE THEN
177: IF p_health_plan IS NULL THEN
178: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');
179: hr_utility.raise_error;
180: END IF;
181:
182: -- Enrollment Option

Line 179: hr_utility.raise_error;

175:
176: IF l_validate = TRUE THEN
177: IF p_health_plan IS NULL THEN
178: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');
179: hr_utility.raise_error;
180: END IF;
181:
182: -- Enrollment Option
183: IF p_enrollment_option IS NULL THEN

Line 184: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');

180: END IF;
181:
182: -- Enrollment Option
183: IF p_enrollment_option IS NULL THEN
184: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');
185: hr_utility.raise_error;
186: NULL;
187: ELSE
188: IF p_health_plan = 'ZZ' AND p_enrollment_option NOT IN('W','X','Y','Z') THEN

Line 185: hr_utility.raise_error;

181:
182: -- Enrollment Option
183: IF p_enrollment_option IS NULL THEN
184: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');
185: hr_utility.raise_error;
186: NULL;
187: ELSE
188: IF p_health_plan = 'ZZ' AND p_enrollment_option NOT IN('W','X','Y','Z') THEN
189: hr_utility.set_message(8301,'GHR_38950_FEHB_INV_PLAN_OPTION');

Line 189: hr_utility.set_message(8301,'GHR_38950_FEHB_INV_PLAN_OPTION');

185: hr_utility.raise_error;
186: NULL;
187: ELSE
188: IF p_health_plan = 'ZZ' AND p_enrollment_option NOT IN('W','X','Y','Z') THEN
189: hr_utility.set_message(8301,'GHR_38950_FEHB_INV_PLAN_OPTION');
190: hr_utility.raise_error;
191: END IF;
192:
193: IF p_health_plan <> 'ZZ' AND p_enrollment_option NOT IN('1','2','4','5') THEN

Line 190: hr_utility.raise_error;

186: NULL;
187: ELSE
188: IF p_health_plan = 'ZZ' AND p_enrollment_option NOT IN('W','X','Y','Z') THEN
189: hr_utility.set_message(8301,'GHR_38950_FEHB_INV_PLAN_OPTION');
190: hr_utility.raise_error;
191: END IF;
192:
193: IF p_health_plan <> 'ZZ' AND p_enrollment_option NOT IN('1','2','4','5') THEN
194: hr_utility.set_message(8301,'GHR_38960_FEHB_NOT_ZZ');

Line 194: hr_utility.set_message(8301,'GHR_38960_FEHB_NOT_ZZ');

190: hr_utility.raise_error;
191: END IF;
192:
193: IF p_health_plan <> 'ZZ' AND p_enrollment_option NOT IN('1','2','4','5') THEN
194: hr_utility.set_message(8301,'GHR_38960_FEHB_NOT_ZZ');
195: hr_utility.raise_error;
196: END IF; -- IF NVL(l_health_plan,hr
197: END IF; -- IF l_enrollment_option IS NULL T
198:

Line 195: hr_utility.raise_error;

191: END IF;
192:
193: IF p_health_plan <> 'ZZ' AND p_enrollment_option NOT IN('1','2','4','5') THEN
194: hr_utility.set_message(8301,'GHR_38960_FEHB_NOT_ZZ');
195: hr_utility.raise_error;
196: END IF; -- IF NVL(l_health_plan,hr
197: END IF; -- IF l_enrollment_option IS NULL T
198:
199: -- Pretax waiver Validation

Line 201: hr_utility.set_message(8301,'GHR_38956_PRE_TAX_ZZ_PLAN');

197: END IF; -- IF l_enrollment_option IS NULL T
198:
199: -- Pretax waiver Validation
200: IF p_health_plan = 'ZZ' AND p_pre_tax_waiver = 'Y' THEN
201: hr_utility.set_message(8301,'GHR_38956_PRE_TAX_ZZ_PLAN');
202: hr_utility.raise_error;
203: END IF;
204: END IF; -- IF l_validate = TRUE T
205: END IF; -- IF (p_which_eit = 'E' AND

Line 202: hr_utility.raise_error;

198:
199: -- Pretax waiver Validation
200: IF p_health_plan = 'ZZ' AND p_pre_tax_waiver = 'Y' THEN
201: hr_utility.set_message(8301,'GHR_38956_PRE_TAX_ZZ_PLAN');
202: hr_utility.raise_error;
203: END IF;
204: END IF; -- IF l_validate = TRUE T
205: END IF; -- IF (p_which_eit = 'E' AND
206:

Line 217: hr_utility.set_message(8301,'GHR_38347_TSP_ROTH_NOT_EFF');

213: IF p_which_eit = 'R' THEN
214: IF ((p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_amt <> '0' ) OR
215: (p_tsp_roth_401k_rate IS NOT NULL AND p_tsp_roth_401k_rate <> '0' ))
216: AND (p_effective_date < to_date('01/01/2012','dd/mm/yyyy')) THEN
217: hr_utility.set_message(8301,'GHR_38347_TSP_ROTH_NOT_EFF');
218: hr_utility.raise_error;
219: END IF;
220: END IF;
221:

Line 218: hr_utility.raise_error;

214: IF ((p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_amt <> '0' ) OR
215: (p_tsp_roth_401k_rate IS NOT NULL AND p_tsp_roth_401k_rate <> '0' ))
216: AND (p_effective_date < to_date('01/01/2012','dd/mm/yyyy')) THEN
217: hr_utility.set_message(8301,'GHR_38347_TSP_ROTH_NOT_EFF');
218: hr_utility.raise_error;
219: END IF;
220: END IF;
221:
222:

Line 228: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');

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;
231:
232: -- TSP Status should be null

Line 229: hr_utility.raise_error;

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;
231:
232: -- TSP Status should be null
233: IF p_tsp_status IS NOT NULL THEN

Line 234: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');

230: END IF;
231:
232: -- TSP Status should be null
233: IF p_tsp_status IS NOT NULL THEN
234: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
235: hr_utility.raise_error;
236: END IF;
237:
238: --Bug # 12973371 Added Validation for TSP Roth amount and rate

Line 235: hr_utility.raise_error;

231:
232: -- TSP Status should be null
233: IF p_tsp_status IS NOT NULL THEN
234: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
235: hr_utility.raise_error;
236: END IF;
237:
238: --Bug # 12973371 Added Validation for TSP Roth amount and rate
239: -- Bug # 13571004

Line 242: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');

238: --Bug # 12973371 Added Validation for TSP Roth amount and rate
239: -- Bug # 13571004
240: IF p_which_eit = 'R' THEN
241: IF p_tsp_roth_401k_amt IS NOT NULL OR p_tsp_roth_401k_rate IS NOT NULL THEN
242: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
243: hr_utility.raise_error;
244: END IF;
245: END IF;
246:

Line 243: hr_utility.raise_error;

239: -- Bug # 13571004
240: IF p_which_eit = 'R' THEN
241: IF p_tsp_roth_401k_amt IS NOT NULL OR p_tsp_roth_401k_rate IS NOT NULL THEN
242: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');
243: hr_utility.raise_error;
244: END IF;
245: END IF;
246:
247: END IF;

Line 253: hr_utility.set_message(8301,'GHR_38976_TSP_STS_REQD');

249:
250: IF p_which_eit = 'E' THEN
251: -- TSP Status should not be null
252: IF p_tsp_status IS NULL THEN
253: hr_utility.set_message(8301,'GHR_38976_TSP_STS_REQD');
254: hr_utility.raise_error;
255: END IF;
256: END IF;
257:

Line 254: hr_utility.raise_error;

250: IF p_which_eit = 'E' THEN
251: -- TSP Status should not be null
252: IF p_tsp_status IS NULL THEN
253: hr_utility.set_message(8301,'GHR_38976_TSP_STS_REQD');
254: hr_utility.raise_error;
255: END IF;
256: END IF;
257:
258: IF g_debug = TRUE THEN

Line 259: hr_utility.set_location('If Retirement plan is not in FERS or CSRS ',1234);

255: END IF;
256: END IF;
257:
258: IF g_debug = TRUE THEN
259: hr_utility.set_location('If Retirement plan is not in FERS or CSRS ',1234);
260: END IF;
261:
262: -- Either only Amount should be entered or Rate...
263: IF p_tsp_amount IS NOT NULL AND p_tsp_rate IS NOT NULL THEN

Line 264: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');

260: END IF;
261:
262: -- Either only Amount should be entered or Rate...
263: IF p_tsp_amount IS NOT NULL AND p_tsp_rate IS NOT NULL THEN
264: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
265: hr_utility.raise_error;
266: END IF;
267:
268: --Bug # 12973371 Added Validation for TSP Roth amount and rate

Line 265: hr_utility.raise_error;

261:
262: -- Either only Amount should be entered or Rate...
263: IF p_tsp_amount IS NOT NULL AND p_tsp_rate IS NOT NULL THEN
264: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
265: hr_utility.raise_error;
266: END IF;
267:
268: --Bug # 12973371 Added Validation for TSP Roth amount and rate
269: -- Bug # 13571004

Line 271: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');

267:
268: --Bug # 12973371 Added Validation for TSP Roth amount and rate
269: -- Bug # 13571004
270: IF p_which_eit = 'R' AND p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_rate IS NOT NULL THEN
271: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
272: hr_utility.raise_error;
273: END IF;
274:
275: hr_utility.set_location('p_tsp_amount'||p_tsp_amount,10);

Line 272: hr_utility.raise_error;

268: --Bug # 12973371 Added Validation for TSP Roth amount and rate
269: -- Bug # 13571004
270: IF p_which_eit = 'R' AND p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_rate IS NOT NULL THEN
271: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
272: hr_utility.raise_error;
273: END IF;
274:
275: hr_utility.set_location('p_tsp_amount'||p_tsp_amount,10);
276: hr_utility.set_location('p_tsp_rate'||p_tsp_rate,10);

Line 275: hr_utility.set_location('p_tsp_amount'||p_tsp_amount,10);

271: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
272: hr_utility.raise_error;
273: END IF;
274:
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

Line 276: hr_utility.set_location('p_tsp_rate'||p_tsp_rate,10);

272: hr_utility.raise_error;
273: END IF;
274:
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');

Line 280: hr_utility.set_message(8301,'GHR_38678_INCORRECT_STATUS');

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

Line 281: hr_utility.raise_error;

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;
284:
285: --Bug # 12973371 Added Validation for TSP Roth amount and rate

Line 291: hr_utility.set_message(8301,'GHR_38678_INCORRECT_STATUS');

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

Line 292: hr_utility.raise_error;

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;
295:
296: IF g_debug = TRUE THEN

Line 297: hr_utility.set_location('p_tsp_status' || p_tsp_status,1234);

293: END IF;
294: END IF;
295:
296: IF g_debug = TRUE THEN
297: hr_utility.set_location('p_tsp_status' || p_tsp_status,1234);
298: END IF;
299:
300: --BUG # 13718289 removed this validation as while updating
301: -- TSP Status to Y from TSP Roth this will get fire when all the values are nulls.

Line 307: hr_utility.set_message(8301,'GHR_38677_INV_RATE_OR_STATUS');

303: /*IF p_tsp_status IN ('Y','W') THEN
304: -- Either Amount or Rate should be entered
305: IF NVL(p_tsp_amount,'0') = '0' AND NVL(p_tsp_rate,'0') = '0'
306: AND NVL(p_tsp_roth_401k_amt,'0') = '0' AND NVL(p_tsp_roth_401k_rate,'0') = '0' THEN
307: hr_utility.set_message(8301,'GHR_38677_INV_RATE_OR_STATUS');
308: hr_utility.raise_error;
309: END IF;
310: END IF;*/
311:

Line 308: hr_utility.raise_error;

304: -- Either Amount or Rate should be entered
305: IF NVL(p_tsp_amount,'0') = '0' AND NVL(p_tsp_rate,'0') = '0'
306: AND NVL(p_tsp_roth_401k_amt,'0') = '0' AND NVL(p_tsp_roth_401k_rate,'0') = '0' THEN
307: hr_utility.set_message(8301,'GHR_38677_INV_RATE_OR_STATUS');
308: hr_utility.raise_error;
309: END IF;
310: END IF;*/
311:
312: -- Bug # 13571004

Line 318: hr_utility.set_message(8301,'GHR_38677_INV_RATE_OR_STATUS');

314: IF p_which_eit = 'R' AND p_tsp_status IN ('Y','W') THEN
315: -- Either Amount or Rate should be entered
316: IF NVL(p_tsp_roth_401k_amt,'0') = '0' AND NVL(p_tsp_roth_401k_rate,'0') = '0'
317: AND NVL(p_tsp_amount,'0') = '0' AND NVL(p_tsp_rate,'0') = '0' THEN
318: hr_utility.set_message(8301,'GHR_38677_INV_RATE_OR_STATUS');
319: hr_utility.raise_error;
320: END IF;
321: END IF;
322:

Line 319: hr_utility.raise_error;

315: -- Either Amount or Rate should be entered
316: IF NVL(p_tsp_roth_401k_amt,'0') = '0' AND NVL(p_tsp_roth_401k_rate,'0') = '0'
317: AND NVL(p_tsp_amount,'0') = '0' AND NVL(p_tsp_rate,'0') = '0' THEN
318: hr_utility.set_message(8301,'GHR_38677_INV_RATE_OR_STATUS');
319: hr_utility.raise_error;
320: END IF;
321: END IF;
322:
323:

Line 328: hr_utility.set_message(8301,'GHR_38675_INVALID_STATUS_DATE');

324: -- TSP Status date should be entered if Status is entered
325: -- Status Date should not be blank
326: IF p_tsp_status IS NOT NULL THEN
327: IF p_tsp_status_date IS NULL THEN
328: hr_utility.set_message(8301,'GHR_38675_INVALID_STATUS_DATE');
329: hr_utility.raise_error;
330: END IF;
331: ELSE
332: IF p_tsp_status_date IS NOT NULL THEN

Line 329: hr_utility.raise_error;

325: -- Status Date should not be blank
326: IF p_tsp_status IS NOT NULL THEN
327: IF p_tsp_status_date IS NULL THEN
328: hr_utility.set_message(8301,'GHR_38675_INVALID_STATUS_DATE');
329: hr_utility.raise_error;
330: END IF;
331: ELSE
332: IF p_tsp_status_date IS NOT NULL THEN
333: hr_utility.set_message(8301,'GHR_38676_INVALID_STATUS');

Line 333: hr_utility.set_message(8301,'GHR_38676_INVALID_STATUS');

329: hr_utility.raise_error;
330: END IF;
331: ELSE
332: IF p_tsp_status_date IS NOT NULL THEN
333: hr_utility.set_message(8301,'GHR_38676_INVALID_STATUS');
334: hr_utility.raise_error;
335: END IF;
336: END IF;
337:

Line 334: hr_utility.raise_error;

330: END IF;
331: ELSE
332: IF p_tsp_status_date IS NOT NULL THEN
333: hr_utility.set_message(8301,'GHR_38676_INVALID_STATUS');
334: hr_utility.raise_error;
335: END IF;
336: END IF;
337:
338: IF g_debug = TRUE THEN

Line 339: hr_utility.set_location('TSP Status date' ,1234);

335: END IF;
336: END IF;
337:
338: IF g_debug = TRUE THEN
339: hr_utility.set_location('TSP Status date' ,1234);
340: END IF;
341:
342:
343: -- 2.2.2.1.6. If retirement Plan is 2, 4, or 5 and user has entered TSP information, provide error:

Line 355: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');

351: p_tsp_status IS NOT NULL OR
352: p_tsp_status_date IS NOT NULL
353: THEN
354: -- Raise Error message
355: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
356: hr_utility.raise_error;
357: END IF;
358: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
359:

Line 356: hr_utility.raise_error;

352: p_tsp_status_date IS NOT NULL
353: THEN
354: -- Raise Error message
355: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
356: hr_utility.raise_error;
357: END IF;
358: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
359:
360: -- Bug # 13571004

Line 369: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');

365: p_tsp_status_date IS NOT NULL OR
366: p_tsp_roth_401k_amt IS NOT NULL OR
367: p_tsp_roth_401k_rate IS NOT NULL THEN
368: -- Raise Error message
369: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
370: hr_utility.raise_error;
371: END IF;
372: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
373: IF g_debug = TRUE THEN

Line 370: hr_utility.raise_error;

366: p_tsp_roth_401k_amt IS NOT NULL OR
367: p_tsp_roth_401k_rate IS NOT NULL THEN
368: -- Raise Error message
369: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
370: hr_utility.raise_error;
371: END IF;
372: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
373: IF g_debug = TRUE THEN
374: hr_utility.set_location('If retirement Plan is 2, 4, or 5',1234);

Line 374: hr_utility.set_location('If retirement Plan is 2, 4, or 5',1234);

370: hr_utility.raise_error;
371: END IF;
372: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
373: IF g_debug = TRUE THEN
374: hr_utility.set_location('If retirement Plan is 2, 4, or 5',1234);
375: END IF;
376:
377: IF (p_tsp_rate IS NULL OR p_tsp_rate = '0' )
378: AND (p_tsp_amount IS NULL OR p_tsp_amount = '0')

Line 380: hr_utility.set_message(8301,'GHR_37454_TSP_STATUS');

376:
377: IF (p_tsp_rate IS NULL OR p_tsp_rate = '0' )
378: AND (p_tsp_amount IS NULL OR p_tsp_amount = '0')
379: AND (p_tsp_status = 'A' ) THEN
380: hr_utility.set_message(8301,'GHR_37454_TSP_STATUS');
381: hr_utility.raise_error;
382: END IF;
383:
384: IF ((p_tsp_rate IS NOT NULL AND p_tsp_rate <> '03' ) OR

Line 381: hr_utility.raise_error;

377: IF (p_tsp_rate IS NULL OR p_tsp_rate = '0' )
378: AND (p_tsp_amount IS NULL OR p_tsp_amount = '0')
379: AND (p_tsp_status = 'A' ) THEN
380: hr_utility.set_message(8301,'GHR_37454_TSP_STATUS');
381: hr_utility.raise_error;
382: END IF;
383:
384: IF ((p_tsp_rate IS NOT NULL AND p_tsp_rate <> '03' ) OR
385: (p_tsp_amount IS NOT NULL AND p_tsp_amount <> '0' ))

Line 387: hr_utility.set_message(8301,'GHR_37453_TSP_STATUS');

383:
384: IF ((p_tsp_rate IS NOT NULL AND p_tsp_rate <> '03' ) OR
385: (p_tsp_amount IS NOT NULL AND p_tsp_amount <> '0' ))
386: AND (p_tsp_status = 'A') THEN
387: hr_utility.set_message(8301,'GHR_37453_TSP_STATUS');
388: hr_utility.raise_error;
389: END IF;
390:
391: --Bug # 12973371

Line 388: hr_utility.raise_error;

384: IF ((p_tsp_rate IS NOT NULL AND p_tsp_rate <> '03' ) OR
385: (p_tsp_amount IS NOT NULL AND p_tsp_amount <> '0' ))
386: AND (p_tsp_status = 'A') THEN
387: hr_utility.set_message(8301,'GHR_37453_TSP_STATUS');
388: hr_utility.raise_error;
389: END IF;
390:
391: --Bug # 12973371
392: IF p_which_eit = 'R' AND ((p_tsp_rate IS NOT NULL AND p_tsp_rate <> '03' ) OR

Line 397: hr_utility.set_message(8301,'GHR_38219_INVALID_TSP_STATUS');

393: (p_tsp_amount IS NOT NULL AND p_tsp_amount <> '0' ) OR
394: (p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_amt <> '0' ) OR
395: (p_tsp_roth_401k_rate IS NOT NULL AND p_tsp_roth_401k_rate <> '0' ))
396: AND (p_tsp_status = 'A') THEN
397: hr_utility.set_message(8301,'GHR_38219_INVALID_TSP_STATUS');
398: hr_utility.raise_error;
399: END IF;
400: --Bug # 12973371
401:

Line 398: hr_utility.raise_error;

394: (p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_amt <> '0' ) OR
395: (p_tsp_roth_401k_rate IS NOT NULL AND p_tsp_roth_401k_rate <> '0' ))
396: AND (p_tsp_status = 'A') THEN
397: hr_utility.set_message(8301,'GHR_38219_INVALID_TSP_STATUS');
398: hr_utility.raise_error;
399: END IF;
400: --Bug # 12973371
401:
402: END IF; -- IF (p_which_eit = 'E' AND p_passed_element = 'TSP')

Line 407: hr_utility.set_location('p_date_fehb_elig ' || to_char(p_date_fehb_elig,'dd/mm/yyyy') ,1234);

403:
404: IF p_which_eit = 'R' OR p_which_eit = 'P' THEN
405: -- Validation for FEHB eligibility
406: IF g_debug = TRUE THEN
407: hr_utility.set_location('p_date_fehb_elig ' || to_char(p_date_fehb_elig,'dd/mm/yyyy') ,1234);
408: END IF;
409:
410: IF p_date_fehb_elig IS NOT NULL THEN
411: IF p_date_fehb_elig <= p_effective_date THEN

Line 412: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');

408: END IF;
409:
410: IF p_date_fehb_elig IS NOT NULL THEN
411: IF p_date_fehb_elig <= p_effective_date THEN
412: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
413: hr_utility.set_message_token('BEN_ELIG_DATE','FEHB Eligibility Expiration Date');
414: hr_utility.raise_error;
415: END IF;
416: --Bug# 10632221, removed noa codes 171, 571

Line 413: hr_utility.set_message_token('BEN_ELIG_DATE','FEHB Eligibility Expiration Date');

409:
410: IF p_date_fehb_elig IS NOT NULL THEN
411: IF p_date_fehb_elig <= p_effective_date THEN
412: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
413: hr_utility.set_message_token('BEN_ELIG_DATE','FEHB Eligibility Expiration Date');
414: hr_utility.raise_error;
415: END IF;
416: --Bug# 10632221, removed noa codes 171, 571
417: IF p_first_noa_code IN ('115','122','149','515','522','549') THEN

Line 414: hr_utility.raise_error;

410: IF p_date_fehb_elig IS NOT NULL THEN
411: IF p_date_fehb_elig <= p_effective_date THEN
412: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
413: hr_utility.set_message_token('BEN_ELIG_DATE','FEHB Eligibility Expiration Date');
414: hr_utility.raise_error;
415: END IF;
416: --Bug# 10632221, removed noa codes 171, 571
417: IF p_first_noa_code IN ('115','122','149','515','522','549') THEN
418: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');

Line 418: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');

414: hr_utility.raise_error;
415: END IF;
416: --Bug# 10632221, removed noa codes 171, 571
417: IF p_first_noa_code IN ('115','122','149','515','522','549') THEN
418: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
419: hr_utility.raise_error;
420: END IF;
421: --Begin Bug 12637350
422: IF p_noa_family_code IN ('APP','CONV_APP','EXT_NTE') THEN

Line 419: hr_utility.raise_error;

415: END IF;
416: --Bug# 10632221, removed noa codes 171, 571
417: IF p_first_noa_code IN ('115','122','149','515','522','549') THEN
418: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
419: hr_utility.raise_error;
420: END IF;
421: --Begin Bug 12637350
422: IF p_noa_family_code IN ('APP','CONV_APP','EXT_NTE') THEN
423: FOR l_first_nte_date IN c_first_nte_date LOOP

Line 436: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');

432: end loop;
433: END IF;
434: --Bug# 14686129 removed equal condition not to trigger error for 365 days
435: IF l_nte_date < l_asg_start_date THEN
436: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
437: hr_utility.raise_error;
438: END IF;
439: END IF;
440: --End Bug 12637350

Line 437: hr_utility.raise_error;

433: END IF;
434: --Bug# 14686129 removed equal condition not to trigger error for 365 days
435: IF l_nte_date < l_asg_start_date THEN
436: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
437: hr_utility.raise_error;
438: END IF;
439: END IF;
440: --End Bug 12637350
441: END IF;

Line 444: hr_utility.set_location('p_date_temp_elig ' || to_char(p_date_temp_elig,'dd/mm/yyyy') ,1234);

440: --End Bug 12637350
441: END IF;
442:
443: IF g_debug = TRUE THEN
444: hr_utility.set_location('p_date_temp_elig ' || to_char(p_date_temp_elig,'dd/mm/yyyy') ,1234);
445: END IF;
446: -- Date Temp Eligibility Expires - Validation
447: IF p_date_temp_elig IS NOT NULL THEN
448: IF p_first_noa_code IS NOT NULL THEN

Line 451: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');

447: IF p_date_temp_elig IS NOT NULL THEN
448: IF p_first_noa_code IS NOT NULL THEN
449: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') AND p_tenure = '0' THEN
450: IF p_date_temp_elig <= p_effective_date THEN
451: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');
452: hr_utility.raise_error;
453: END IF;
454: END IF;
455: -- If tenure code is not 0, then value should be null

Line 452: hr_utility.raise_error;

448: IF p_first_noa_code IS NOT NULL THEN
449: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') AND p_tenure = '0' THEN
450: IF p_date_temp_elig <= p_effective_date THEN
451: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');
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

Line 457: hr_utility.set_message(8301,'GHR_38954_TMP_ELIG_BLANK');

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.
461: -- Bug 4668813

Line 458: hr_utility.raise_error;

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.
461: -- Bug 4668813
462: hr_utility.set_location('p_first_noa_code'|| p_first_noa_code,223);

Line 462: hr_utility.set_location('p_first_noa_code'|| p_first_noa_code,223);

458: hr_utility.raise_error;
459: END IF;
460: -- This field is valid only for Temp. appointments. else throw error.
461: -- Bug 4668813
462: hr_utility.set_location('p_first_noa_code'|| p_first_noa_code,223);
463:
464: IF p_which_eit = 'R' AND (p_first_noa_code IS NOT NULL AND p_first_noa_code NOT IN ('115','122','149','171','515','522','549','571')) THEN
465: hr_utility.set_message(8301,'GHR_38955_TMP_ELIG_FOR_TMP');
466: hr_utility.raise_error;

Line 465: hr_utility.set_message(8301,'GHR_38955_TMP_ELIG_FOR_TMP');

461: -- Bug 4668813
462: hr_utility.set_location('p_first_noa_code'|| p_first_noa_code,223);
463:
464: IF p_which_eit = 'R' AND (p_first_noa_code IS NOT NULL AND p_first_noa_code NOT IN ('115','122','149','171','515','522','549','571')) THEN
465: hr_utility.set_message(8301,'GHR_38955_TMP_ELIG_FOR_TMP');
466: hr_utility.raise_error;
467: END IF;
468: ELSIF p_which_eit = 'P' THEN
469: IF p_date_temp_elig <= p_effective_date THEN

Line 466: hr_utility.raise_error;

462: hr_utility.set_location('p_first_noa_code'|| p_first_noa_code,223);
463:
464: IF p_which_eit = 'R' AND (p_first_noa_code IS NOT NULL AND p_first_noa_code NOT IN ('115','122','149','171','515','522','549','571')) THEN
465: hr_utility.set_message(8301,'GHR_38955_TMP_ELIG_FOR_TMP');
466: hr_utility.raise_error;
467: END IF;
468: ELSIF p_which_eit = 'P' THEN
469: IF p_date_temp_elig <= p_effective_date THEN
470: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');

Line 470: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');

466: hr_utility.raise_error;
467: END IF;
468: ELSIF p_which_eit = 'P' THEN
469: IF p_date_temp_elig <= p_effective_date THEN
470: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');
471: hr_utility.raise_error;
472: END IF;
473: END IF; -- IF p_first_noa_code IS NOT NULL THEN
474: END IF; -- IF p_rei_information4 IS NOT

Line 471: hr_utility.raise_error;

467: END IF;
468: ELSIF p_which_eit = 'P' THEN
469: IF p_date_temp_elig <= p_effective_date THEN
470: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');
471: hr_utility.raise_error;
472: END IF;
473: END IF; -- IF p_first_noa_code IS NOT NULL THEN
474: END IF; -- IF p_rei_information4 IS NOT
475:

Line 480: hr_utility.set_message(8301,'GHR_38964_FEHB_TMP_PLAN');

476: --
477: IF p_date_temp_elig IS NOT NULL AND p_date_temp_elig > NVL(p_effective_date,TRUNC(SYSDATE)) THEN
478: IF p_health_plan IS NOT NULL THEN
479: IF p_health_plan <> 'ZZ' AND p_enrollment_option <> 'Z' THEN
480: hr_utility.set_message(8301,'GHR_38964_FEHB_TMP_PLAN');
481: hr_utility.raise_error;
482: END IF;
483: END IF;
484: END IF; -- IF p_date_temp_elig IS NOT NULL

Line 481: hr_utility.raise_error;

477: IF p_date_temp_elig IS NOT NULL AND p_date_temp_elig > NVL(p_effective_date,TRUNC(SYSDATE)) THEN
478: IF p_health_plan IS NOT NULL THEN
479: IF p_health_plan <> 'ZZ' AND p_enrollment_option <> 'Z' THEN
480: hr_utility.set_message(8301,'GHR_38964_FEHB_TMP_PLAN');
481: hr_utility.raise_error;
482: END IF;
483: END IF;
484: END IF; -- IF p_date_temp_elig IS NOT NULL
485:

Line 487: hr_utility.set_location('p_fegli_elig_exp_date ' || to_char(p_fegli_elig_exp_date,'dd/mm/yyyy') ,1234);

483: END IF;
484: END IF; -- IF p_date_temp_elig IS NOT NULL
485:
486: IF g_debug = TRUE THEN
487: hr_utility.set_location('p_fegli_elig_exp_date ' || to_char(p_fegli_elig_exp_date,'dd/mm/yyyy') ,1234);
488: END IF;
489:
490: -- FEGLI Eligibility Expiration Validation
491: IF p_fegli_elig_exp_date IS NOT NULL THEN

Line 493: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');

489:
490: -- FEGLI Eligibility Expiration Validation
491: IF p_fegli_elig_exp_date IS NOT NULL THEN
492: IF p_fegli_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
493: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
494: hr_utility.set_message_token('BEN_ELIG_DATE','FEGLI Eligibility Expiration Date');
495: hr_utility.raise_error;
496: END IF;
497: END IF; -- IF p_fegli_elig_exp_date IS NOT NULL THEN

Line 494: hr_utility.set_message_token('BEN_ELIG_DATE','FEGLI Eligibility Expiration Date');

490: -- FEGLI Eligibility Expiration Validation
491: IF p_fegli_elig_exp_date IS NOT NULL THEN
492: IF p_fegli_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
493: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
494: hr_utility.set_message_token('BEN_ELIG_DATE','FEGLI Eligibility Expiration Date');
495: hr_utility.raise_error;
496: END IF;
497: END IF; -- IF p_fegli_elig_exp_date IS NOT NULL THEN
498:

Line 495: hr_utility.raise_error;

491: IF p_fegli_elig_exp_date IS NOT NULL THEN
492: IF p_fegli_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
493: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
494: hr_utility.set_message_token('BEN_ELIG_DATE','FEGLI Eligibility Expiration Date');
495: hr_utility.raise_error;
496: END IF;
497: END IF; -- IF p_fegli_elig_exp_date IS NOT NULL THEN
498:
499: IF g_debug = TRUE THEN

Line 500: hr_utility.set_location('-- FEGLI Eligibility Expiration Validatio',1234);

496: END IF;
497: END IF; -- IF p_fegli_elig_exp_date IS NOT NULL THEN
498:
499: IF g_debug = TRUE THEN
500: hr_utility.set_location('-- FEGLI Eligibility Expiration Validatio',1234);
501: END IF;
502: -- FERS Eligibility Expiration Validation
503: IF p_fers_elig_exp_date IS NOT NULL THEN
504: IF p_fers_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN

Line 505: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');

501: END IF;
502: -- FERS Eligibility Expiration Validation
503: IF p_fers_elig_exp_date IS NOT NULL THEN
504: IF p_fers_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
505: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
506: hr_utility.set_message_token('BEN_ELIG_DATE','FERS Eligibility Expiration Date');
507: hr_utility.raise_error;
508: END IF;
509: END IF; -- IF p_fers_elig_exp_date IS NOT NULL THEN

Line 506: hr_utility.set_message_token('BEN_ELIG_DATE','FERS Eligibility Expiration Date');

502: -- FERS Eligibility Expiration Validation
503: IF p_fers_elig_exp_date IS NOT NULL THEN
504: IF p_fers_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
505: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
506: hr_utility.set_message_token('BEN_ELIG_DATE','FERS Eligibility Expiration Date');
507: hr_utility.raise_error;
508: END IF;
509: END IF; -- IF p_fers_elig_exp_date IS NOT NULL THEN
510: IF g_debug = TRUE THEN

Line 507: hr_utility.raise_error;

503: IF p_fers_elig_exp_date IS NOT NULL THEN
504: IF p_fers_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
505: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
506: hr_utility.set_message_token('BEN_ELIG_DATE','FERS Eligibility Expiration Date');
507: hr_utility.raise_error;
508: END IF;
509: END IF; -- IF p_fers_elig_exp_date IS NOT NULL THEN
510: IF g_debug = TRUE THEN
511: hr_utility.set_location('-- FERS Eligibility Expiration Validation',1234);

Line 511: hr_utility.set_location('-- FERS Eligibility Expiration Validation',1234);

507: hr_utility.raise_error;
508: END IF;
509: END IF; -- IF p_fers_elig_exp_date IS NOT NULL THEN
510: IF g_debug = TRUE THEN
511: hr_utility.set_location('-- FERS Eligibility Expiration Validation',1234);
512: END IF;
513:
514: IF p_which_eit = 'R' AND p_noa_family_code IN ('CONV_APP','EXT_NTE') THEN
515: IF p_tsp_amount IS NULL AND

Line 532: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');

528: IF l_validate = TRUE THEN
529: IF p_retirement_plan IN ('D','K','L','M','N','P') THEN
530: IF LTRIM(p_tsp_scd) IS NULL THEN
531: -- Raise Error message
532: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');
533: hr_utility.raise_error;
534: END IF;
535: END IF; -- IF p_retirement_plan IN ('D','K','L'...
536: END IF;

Line 533: hr_utility.raise_error;

529: IF p_retirement_plan IN ('D','K','L','M','N','P') THEN
530: IF LTRIM(p_tsp_scd) IS NULL THEN
531: -- Raise Error message
532: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');
533: hr_utility.raise_error;
534: END IF;
535: END IF; -- IF p_retirement_plan IN ('D','K','L'...
536: END IF;
537:

Line 543: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');--Bug# 4769233

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;
546: END IF;
547: END IF;

Line 544: hr_utility.raise_error;

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;
546: END IF;
547: END IF;
548: */

Line 556: hr_utility.set_message(8301,'GHR_38958_TSP_AMT_NOT_FERS');

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;
558: END IF;
559: END IF;
560: END IF; -- IF NVL(l_retirement_plan,hr_api.g_v

Line 557: hr_utility.raise_error;

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;
558: END IF;
559: END IF;
560: END IF; -- IF NVL(l_retirement_plan,hr_api.g_v
561:

Line 563: hr_utility.set_location('If Retirement plan is not in FERS or CSRS ',1234);

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;
565:
566: -- IF TSP status is I then the date must be future.
567: IF p_tsp_status = 'I' AND NVL(p_effective_date, TRUNC(SYSDATE)) > p_agency_contrib_date THEN

Line 568: hr_utility.set_message(8301,'GHR_38680_INV_AGENCY_CONTRIB');

564: END IF;
565:
566: -- IF TSP status is I then the date must be future.
567: IF p_tsp_status = 'I' AND NVL(p_effective_date, TRUNC(SYSDATE)) > p_agency_contrib_date THEN
568: hr_utility.set_message(8301,'GHR_38680_INV_AGENCY_CONTRIB');
569: hr_utility.raise_error;
570: END IF;
571:
572: IF g_debug = TRUE THEN

Line 569: hr_utility.raise_error;

565:
566: -- IF TSP status is I then the date must be future.
567: IF p_tsp_status = 'I' AND NVL(p_effective_date, TRUNC(SYSDATE)) > p_agency_contrib_date THEN
568: hr_utility.set_message(8301,'GHR_38680_INV_AGENCY_CONTRIB');
569: hr_utility.raise_error;
570: END IF;
571:
572: IF g_debug = TRUE THEN
573: hr_utility.set_location(' IF TSP status is I',1234);

Line 573: hr_utility.set_location(' IF TSP status is I',1234);

569: hr_utility.raise_error;
570: END IF;
571:
572: IF g_debug = TRUE THEN
573: hr_utility.set_location(' IF TSP status is I',1234);
574: END IF;
575:
576:
577:

Line 589: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');

585: OR p_retirement_plan IN ('J','X') THEN
586: IF p_agency_contrib_date IS NOT NULL OR
587: p_emp_contrib_date IS NOT NULL THEN
588: -- Raise Error message
589: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
590: hr_utility.raise_error;
591: END IF;
592: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
593: END IF;

Line 590: hr_utility.raise_error;

586: IF p_agency_contrib_date IS NOT NULL OR
587: p_emp_contrib_date IS NOT NULL THEN
588: -- Raise Error message
589: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
590: hr_utility.raise_error;
591: END IF;
592: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
593: END IF;
594:

Line 596: hr_utility.set_location('If retirement Plan is 2, 4, or 5',1234);

592: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
593: END IF;
594:
595: IF g_debug = TRUE THEN
596: hr_utility.set_location('If retirement Plan is 2, 4, or 5',1234);
597: END IF;
598:
599: IF p_which_eit = 'R' THEN
600: -- If Agency or Emp contrib dates are entered, then status cannot be null

Line 603: hr_utility.set_message(8301,'GHR_38679_BLANK_STATUS');

599: IF p_which_eit = 'R' THEN
600: -- If Agency or Emp contrib dates are entered, then status cannot be null
601: IF p_agency_contrib_date IS NOT NULL OR p_emp_contrib_date IS NOT NULL THEN
602: IF p_tsp_status IS NULL THEN
603: hr_utility.set_message(8301,'GHR_38679_BLANK_STATUS');
604: hr_utility.raise_error;
605: END IF;
606: END IF;
607:

Line 604: hr_utility.raise_error;

600: -- If Agency or Emp contrib dates are entered, then status cannot be null
601: IF p_agency_contrib_date IS NOT NULL OR p_emp_contrib_date IS NOT NULL THEN
602: IF p_tsp_status IS NULL THEN
603: hr_utility.set_message(8301,'GHR_38679_BLANK_STATUS');
604: hr_utility.raise_error;
605: END IF;
606: END IF;
607:
608: -- Bug 4691271 and 4687755

Line 613: hr_utility.set_message(8301,'GHR_38977_TSP_AGNCY_DATE_REQD');

609: -- If FERS, the value should be not null. Else it should be null.
610: --Begin Bug# 8622486
611: /*IF p_retirement_plan IN ('D','K','L','M','N','P') THEN
612: IF p_agency_contrib_date IS NULL THEN -- Bug 4693453
613: hr_utility.set_message(8301,'GHR_38977_TSP_AGNCY_DATE_REQD');
614: hr_utility.raise_error;
615: END IF;
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

Line 614: hr_utility.raise_error;

610: --Begin Bug# 8622486
611: /*IF p_retirement_plan IN ('D','K','L','M','N','P') THEN
612: IF p_agency_contrib_date IS NULL THEN -- Bug 4693453
613: hr_utility.set_message(8301,'GHR_38977_TSP_AGNCY_DATE_REQD');
614: hr_utility.raise_error;
615: END IF;
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

Line 621: hr_utility.set_message(8301,'GHR_38961_NOT_FERS_AGNCY_DATE');

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;
625: --end Bug# 8622486

Line 622: hr_utility.raise_error;

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;
625: --end Bug# 8622486
626: END IF;

Line 683: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');

679: NULL;
680: --Begin Bug# 8622486
681: /*ELSIF p_agency_contrib_date <> l_start_date THEN
682: -- Raise Error message
683: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
684: hr_utility.set_message_token('ST_MONTH',l_st_month);
685: hr_utility.set_message_token('END_MONTH',l_end_month);
686: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
687: hr_utility.raise_error;*/

Line 684: hr_utility.set_message_token('ST_MONTH',l_st_month);

680: --Begin Bug# 8622486
681: /*ELSIF p_agency_contrib_date <> l_start_date THEN
682: -- Raise Error message
683: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
684: hr_utility.set_message_token('ST_MONTH',l_st_month);
685: hr_utility.set_message_token('END_MONTH',l_end_month);
686: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
687: hr_utility.raise_error;*/
688: --end Bug# 8622486

Line 685: hr_utility.set_message_token('END_MONTH',l_end_month);

681: /*ELSIF p_agency_contrib_date <> l_start_date THEN
682: -- Raise Error message
683: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
684: hr_utility.set_message_token('ST_MONTH',l_st_month);
685: hr_utility.set_message_token('END_MONTH',l_end_month);
686: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
687: hr_utility.raise_error;*/
688: --end Bug# 8622486
689: END IF;

Line 686: hr_utility.set_message_token('PAY_MONTH',l_pay_month);

682: -- Raise Error message
683: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
684: hr_utility.set_message_token('ST_MONTH',l_st_month);
685: hr_utility.set_message_token('END_MONTH',l_end_month);
686: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
687: hr_utility.raise_error;*/
688: --end Bug# 8622486
689: END IF;
690:

Line 687: hr_utility.raise_error;*/

683: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
684: hr_utility.set_message_token('ST_MONTH',l_st_month);
685: hr_utility.set_message_token('END_MONTH',l_end_month);
686: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
687: hr_utility.raise_error;*/
688: --end Bug# 8622486
689: END IF;
690:
691: IF g_debug = TRUE THEN

Line 692: hr_utility.set_location('Get Payroll ID',1234);

688: --end Bug# 8622486
689: END IF;
690:
691: IF g_debug = TRUE THEN
692: hr_utility.set_location('Get Payroll ID',1234);
693: END IF;
694:
695:
696: -- TSP Emp Contrib Elig date validation

Line 700: hr_utility.set_message(8301,'GHR_38962_APP_EMP_ELIG_DATE');

696: -- TSP Emp Contrib Elig date validation
697: IF p_emp_contrib_date IS NOT NULL THEN
698: IF p_noa_family_code = 'APP' AND p_first_noa_code NOT IN ('130','132','145','147') THEN
699: -- Raise Error message
700: hr_utility.set_message(8301,'GHR_38962_APP_EMP_ELIG_DATE');
701: hr_utility.raise_error;
702: ELSE
703: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
704: -- Raise Error message

Line 701: hr_utility.raise_error;

697: IF p_emp_contrib_date IS NOT NULL THEN
698: IF p_noa_family_code = 'APP' AND p_first_noa_code NOT IN ('130','132','145','147') THEN
699: -- Raise Error message
700: hr_utility.set_message(8301,'GHR_38962_APP_EMP_ELIG_DATE');
701: hr_utility.raise_error;
702: ELSE
703: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
704: -- Raise Error message
705: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');

Line 705: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');

701: hr_utility.raise_error;
702: ELSE
703: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
704: -- Raise Error message
705: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
706: hr_utility.set_message_token('BEN_ELIG_DATE','TSP Emp Contrib Elig date');
707: hr_utility.raise_error;
708: END IF;
709: -- Amount or Rate should be null

Line 706: hr_utility.set_message_token('BEN_ELIG_DATE','TSP Emp Contrib Elig date');

702: ELSE
703: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
704: -- Raise Error message
705: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
706: hr_utility.set_message_token('BEN_ELIG_DATE','TSP Emp Contrib Elig date');
707: hr_utility.raise_error;
708: END IF;
709: -- Amount or Rate should be null
710: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN

Line 707: hr_utility.raise_error;

703: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
704: -- Raise Error message
705: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
706: hr_utility.set_message_token('BEN_ELIG_DATE','TSP Emp Contrib Elig date');
707: hr_utility.raise_error;
708: END IF;
709: -- Amount or Rate should be null
710: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
711: -- Raise Error message

Line 712: hr_utility.set_message(8301,'GHR_38963_TSP_EMP_ELIG_DATE');

708: END IF;
709: -- Amount or Rate should be null
710: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
711: -- Raise Error message
712: hr_utility.set_message(8301,'GHR_38963_TSP_EMP_ELIG_DATE');
713: hr_utility.raise_error;
714: END IF;
715: END IF; -- IF l_noa_family_code = 'APP' THEN
716: END IF;

Line 713: hr_utility.raise_error;

709: -- Amount or Rate should be null
710: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
711: -- Raise Error message
712: hr_utility.set_message(8301,'GHR_38963_TSP_EMP_ELIG_DATE');
713: hr_utility.raise_error;
714: END IF;
715: END IF; -- IF l_noa_family_code = 'APP' THEN
716: END IF;
717: IF g_debug = TRUE THEN

Line 718: hr_utility.set_location('IF p_rei_information18 IS NOT NULL',1234);

714: END IF;
715: END IF; -- IF l_noa_family_code = 'APP' THEN
716: END IF;
717: IF g_debug = TRUE THEN
718: hr_utility.set_location('IF p_rei_information18 IS NOT NULL',1234);
719: END IF;
720:
721:
722: END IF; -- IF p_which_eit = 'R' THEN

Line 728: hr_utility.set_message(8301,'GHR_38347_TSP_ROTH_NOT_EFF');

724: IF (p_which_eit = 'E' AND p_passed_element = 'TSP Roth 401K') THEN
725: l_validate := TRUE;
726:
727: IF (p_effective_date < to_date('01/01/2012','dd/mm/yyyy')) THEN
728: hr_utility.set_message(8301,'GHR_38347_TSP_ROTH_NOT_EFF');
729: hr_utility.raise_error;
730: END IF;
731:
732: --- THis is commented as tsp status will be updated with Y after the validations of

Line 729: hr_utility.raise_error;

725: l_validate := TRUE;
726:
727: IF (p_effective_date < to_date('01/01/2012','dd/mm/yyyy')) THEN
728: hr_utility.set_message(8301,'GHR_38347_TSP_ROTH_NOT_EFF');
729: hr_utility.raise_error;
730: END IF;
731:
732: --- THis is commented as tsp status will be updated with Y after the validations of
733: --- TSP Roth

Line 736: hr_utility.set_message(8301, 'GHR_38678_INCORRECT_STATUS');

732: --- THis is commented as tsp status will be updated with Y after the validations of
733: --- TSP Roth
734: /*IF NVL(p_tsp_roth_401k_amt,0) > 0 OR NVL(p_tsp_roth_401k_rate,0) > 0 THEN
735: IF NVL(p_tsp_status,'X1') NOT IN ('Y') THEN
736: hr_utility.set_message(8301, 'GHR_38678_INCORRECT_STATUS');
737: hr_utility.raise_error;
738: END IF;
739: END IF;*/
740:

Line 737: hr_utility.raise_error;

733: --- TSP Roth
734: /*IF NVL(p_tsp_roth_401k_amt,0) > 0 OR NVL(p_tsp_roth_401k_rate,0) > 0 THEN
735: IF NVL(p_tsp_status,'X1') NOT IN ('Y') THEN
736: hr_utility.set_message(8301, 'GHR_38678_INCORRECT_STATUS');
737: hr_utility.raise_error;
738: END IF;
739: END IF;*/
740:
741: IF p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_rate IS NOT NULL THEN

Line 742: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');

738: END IF;
739: END IF;*/
740:
741: IF p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_rate IS NOT NULL THEN
742: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
743: hr_utility.raise_error;
744: END IF;
745: END IF;
746: -- Bug # 13571004

Line 743: hr_utility.raise_error;

739: END IF;*/
740:
741: IF p_tsp_roth_401k_amt IS NOT NULL AND p_tsp_roth_401k_rate IS NOT NULL THEN
742: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
743: hr_utility.raise_error;
744: END IF;
745: END IF;
746: -- Bug # 13571004
747:

Line 885: IF ghr_utility.is_ghr = 'TRUE' THEN

881:
882:
883: BEGIN
884: -- Initialization
885: IF ghr_utility.is_ghr = 'TRUE' THEN
886: IF g_debug = TRUE THEN
887: hr_utility.set_location('Entering validate_create_element',110);
888: END IF;
889:

Line 887: hr_utility.set_location('Entering validate_create_element',110);

883: BEGIN
884: -- Initialization
885: IF ghr_utility.is_ghr = 'TRUE' THEN
886: IF g_debug = TRUE THEN
887: hr_utility.set_location('Entering validate_create_element',110);
888: END IF;
889:
890: l_business_group_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
891: l_debug_mode := FALSE;

Line 894: hr_utility.set_location('l_business_group_id -- ' || l_business_group_id,110);

890: l_business_group_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
891: l_debug_mode := FALSE;
892:
893: IF g_debug = TRUE THEN
894: hr_utility.set_location('l_business_group_id -- ' || l_business_group_id,110);
895: END IF;
896:
897: -- Check for the element Name
898: FOR l_cur_element_name IN c_element_name(p_element_link_id,p_effective_date,l_business_group_id) LOOP

Line 903: hr_utility.set_location('New Element name -- ' || l_new_element_name,110);

899: l_new_element_name := l_cur_element_name.element_name;
900: END LOOP;
901:
902: IF g_debug = TRUE THEN
903: hr_utility.set_location('New Element name -- ' || l_new_element_name,110);
904: END IF;
905:
906: l_element_name := pqp_fedhr_uspay_int_utils.return_old_element_name(l_new_element_name,l_business_group_id,p_effective_date);
907:

Line 909: hr_utility.set_location('Element name -- ' || l_element_name,110);

905:
906: l_element_name := pqp_fedhr_uspay_int_utils.return_old_element_name(l_new_element_name,l_business_group_id,p_effective_date);
907:
908: IF g_debug = TRUE THEN
909: hr_utility.set_location('Element name -- ' || l_element_name,110);
910: END IF;
911:
912: l_ret_plan_name := pqp_fedhr_uspay_int_utils.return_new_element_name('Retirement Plan',l_business_group_id,p_effective_date,null);
913:

Line 921: hr_utility.set_location('Retirement plan -- ' || l_retirement_plan,110);

917: END IF;
918: END LOOP;
919:
920: IF g_debug = TRUE THEN
921: hr_utility.set_location('Retirement plan -- ' || l_retirement_plan,110);
922: END IF;
923:
924: IF l_element_name = 'TSP' THEN
925: FOR l_cur_element IN c_element(l_new_element_name,p_assignment_id, p_effective_date,l_business_group_id) LOOP

Line 938: hr_utility.set_location('Entering validation tsp',110);

934: END IF;
935: END LOOP;
936:
937: IF g_debug = TRUE THEN
938: hr_utility.set_location('Entering validation tsp',110);
939: END IF;
940:
941: ghr_ben_validation.validate_benefits(
942: p_effective_date => p_effective_date

Line 1004: hr_utility.set_location('Entering validation fehb',110);

1000: END IF;
1001: END LOOP;
1002:
1003: IF g_debug = TRUE THEN
1004: hr_utility.set_location('Entering validation fehb',110);
1005: END IF;
1006:
1007: -- Validation part
1008: validate_benefits(

Line 1029: hr_utility.set_location('Entering validation tsp roth',110);

1025: l_roth_eff_date := l_cur_element.effective_start_date;
1026: END LOOP;
1027:
1028: IF g_debug = TRUE THEN
1029: hr_utility.set_location('Entering validation tsp roth',110);
1030: END IF;
1031:
1032: ghr_per_sum.get_element_details('TSP','Status',p_assignment_id,
1033: p_effective_date,l_tsp_status,l_effective_start_date,l_business_group_id);

Line 1092: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);

1088: --BUG # 13844994
1089: -- BUG # 14618123 commented as it will be handled in PLD to raise an error message
1090: -- If Roth amount and rate is available and status is set to Y then need to raise an error
1091: /* ELSIF NVL(l_roth_amount,'0') = '0' AND NVL(l_roth_rate,'0') = '0' THEN
1092: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);
1093: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);
1094: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);
1095:
1096: ghr_per_sum.get_element_details('TSP','Status',p_assignment_id,

Line 1093: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);

1089: -- BUG # 14618123 commented as it will be handled in PLD to raise an error message
1090: -- If Roth amount and rate is available and status is set to Y then need to raise an error
1091: /* ELSIF NVL(l_roth_amount,'0') = '0' AND NVL(l_roth_rate,'0') = '0' THEN
1092: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);
1093: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);
1094: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);
1095:
1096: ghr_per_sum.get_element_details('TSP','Status',p_assignment_id,
1097: l_roth_eff_date,l_tsp_status,l_eff_start_date,l_business_group_id);

Line 1094: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);

1090: -- If Roth amount and rate is available and status is set to Y then need to raise an error
1091: /* ELSIF NVL(l_roth_amount,'0') = '0' AND NVL(l_roth_rate,'0') = '0' THEN
1092: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);
1093: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);
1094: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);
1095:
1096: ghr_per_sum.get_element_details('TSP','Status',p_assignment_id,
1097: l_roth_eff_date,l_tsp_status,l_eff_start_date,l_business_group_id);
1098:

Line 1104: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);

1100: l_roth_eff_date,l_tsp_amt,l_eff_start_date,l_business_group_id);
1101:
1102: ghr_per_sum.get_element_details('TSP','Rate', p_assignment_id,
1103: l_roth_eff_date,l_tsp_rate,l_eff_start_date,l_business_group_id);
1104: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);
1105: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);
1106: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);
1107: IF (l_tsp_amt is NULL and (NVL(l_tsp_rate,'0') = '0' or l_tsp_rate = '3')) and l_tsp_status = 'Y' THEN
1108: hr_utility.set_location('in loop1'||l_tsp_status,100);

Line 1105: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);

1101:
1102: ghr_per_sum.get_element_details('TSP','Rate', p_assignment_id,
1103: l_roth_eff_date,l_tsp_rate,l_eff_start_date,l_business_group_id);
1104: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);
1105: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);
1106: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);
1107: IF (l_tsp_amt is NULL and (NVL(l_tsp_rate,'0') = '0' or l_tsp_rate = '3')) and l_tsp_status = 'Y' THEN
1108: hr_utility.set_location('in loop1'||l_tsp_status,100);
1109: l_old_eff_start_date:= l_eff_start_date-1;

Line 1106: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);

1102: ghr_per_sum.get_element_details('TSP','Rate', p_assignment_id,
1103: l_roth_eff_date,l_tsp_rate,l_eff_start_date,l_business_group_id);
1104: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);
1105: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);
1106: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);
1107: IF (l_tsp_amt is NULL and (NVL(l_tsp_rate,'0') = '0' or l_tsp_rate = '3')) and l_tsp_status = 'Y' THEN
1108: hr_utility.set_location('in loop1'||l_tsp_status,100);
1109: l_old_eff_start_date:= l_eff_start_date-1;
1110:

Line 1108: hr_utility.set_location('in loop1'||l_tsp_status,100);

1104: hr_utility.set_location('l_tsp_status'||l_tsp_status,100);
1105: hr_utility.set_location('l_tsp_amt'||l_tsp_amt,100);
1106: hr_utility.set_location('l_tsp_rate'||l_tsp_rate,100);
1107: IF (l_tsp_amt is NULL and (NVL(l_tsp_rate,'0') = '0' or l_tsp_rate = '3')) and l_tsp_status = 'Y' THEN
1108: hr_utility.set_location('in loop1'||l_tsp_status,100);
1109: l_old_eff_start_date:= l_eff_start_date-1;
1110:
1111: ghr_per_sum.get_element_details('TSP','Status',p_assignment_id,
1112: l_old_eff_start_date,l_old_tsp_status,l_eff_start_date,l_business_group_id);

Line 1120: hr_utility.set_location('l_old_tsp_status'||l_old_tsp_status,100);

1116:
1117: ghr_per_sum.get_element_details('TSP','Rate', p_assignment_id,
1118: l_old_eff_start_date,l_old_tsp_rate,l_eff_start_date,l_business_group_id);
1119:
1120: hr_utility.set_location('l_old_tsp_status'||l_old_tsp_status,100);
1121: hr_utility.set_location('l_old_tsp_amt'||l_old_tsp_amt,100);
1122: hr_utility.set_location('l_old_tsp_rate'||l_old_tsp_rate,100);
1123:
1124: IF l_old_tsp_status is NOT NULL or l_old_tsp_amt is NOT NULL or l_old_tsp_rate is NOT NULL THEN

Line 1121: hr_utility.set_location('l_old_tsp_amt'||l_old_tsp_amt,100);

1117: ghr_per_sum.get_element_details('TSP','Rate', p_assignment_id,
1118: l_old_eff_start_date,l_old_tsp_rate,l_eff_start_date,l_business_group_id);
1119:
1120: hr_utility.set_location('l_old_tsp_status'||l_old_tsp_status,100);
1121: hr_utility.set_location('l_old_tsp_amt'||l_old_tsp_amt,100);
1122: hr_utility.set_location('l_old_tsp_rate'||l_old_tsp_rate,100);
1123:
1124: IF l_old_tsp_status is NOT NULL or l_old_tsp_amt is NOT NULL or l_old_tsp_rate is NOT NULL THEN
1125: hr_utility.set_location('in loop2'||l_tsp_status,100);

Line 1122: hr_utility.set_location('l_old_tsp_rate'||l_old_tsp_rate,100);

1118: l_old_eff_start_date,l_old_tsp_rate,l_eff_start_date,l_business_group_id);
1119:
1120: hr_utility.set_location('l_old_tsp_status'||l_old_tsp_status,100);
1121: hr_utility.set_location('l_old_tsp_amt'||l_old_tsp_amt,100);
1122: hr_utility.set_location('l_old_tsp_rate'||l_old_tsp_rate,100);
1123:
1124: IF l_old_tsp_status is NOT NULL or l_old_tsp_amt is NOT NULL or l_old_tsp_rate is NOT NULL THEN
1125: hr_utility.set_location('in loop2'||l_tsp_status,100);
1126: ghr_element_api.process_sf52_element(p_assignment_id => p_assignment_id

Line 1125: hr_utility.set_location('in loop2'||l_tsp_status,100);

1121: hr_utility.set_location('l_old_tsp_amt'||l_old_tsp_amt,100);
1122: hr_utility.set_location('l_old_tsp_rate'||l_old_tsp_rate,100);
1123:
1124: IF l_old_tsp_status is NOT NULL or l_old_tsp_amt is NOT NULL or l_old_tsp_rate is NOT NULL THEN
1125: hr_utility.set_location('in loop2'||l_tsp_status,100);
1126: ghr_element_api.process_sf52_element(p_assignment_id => p_assignment_id
1127: ,p_element_name => 'TSP'
1128: ,p_input_value_name1 => 'Amount'
1129: ,p_value1 => l_old_tsp_amt

Line 1140: hr_utility.set_location('in loop3'||l_tsp_status,100);

1136: ,p_effective_date => l_roth_eff_date
1137: ,p_process_warning => l_warning
1138: );
1139: ELSE
1140: hr_utility.set_location('in loop3'||l_tsp_status,100);
1141: ghr_element_api.process_sf52_element
1142: (p_assignment_id => p_assignment_id
1143: ,p_element_name => 'TSP'
1144: ,p_input_value_name1 => 'Amount'

Line 1161: END IF; -- IF ghr_utility.is_ghr = 'TRUE

1157: END IF;
1158: --BUG # 13844994
1159: --BUG # 13718289
1160: END IF; -- IF l_element_name = 'TSP
1161: END IF; -- IF ghr_utility.is_ghr = 'TRUE
1162:
1163: END validate_create_element;
1164:
1165: PROCEDURE validate_update_element(

Line 1178: hr_utility.set_location('Entering validate_update_element',110);

1174: ,P_ELEMENT_TYPE_ID_O in number default null
1175: ) IS
1176: BEGIN
1177: IF g_debug = TRUE THEN
1178: hr_utility.set_location('Entering validate_update_element',110);
1179: END IF;
1180: validate_create_element(
1181: p_effective_date => p_effective_date
1182: ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O

Line 1247: IF ghr_utility.is_ghr = 'TRUE' AND p_information_type IN ('GHR_US_PER_BENEFIT_INFO','GHR_US_PER_SCD_INFORMATION') THEN

1243: AND c_effective_date BETWEEN NVL(start_date_active,to_date('01/01/1951','dd/mm/yyyy'))
1244: AND NVL(end_date_active,to_date('31/12/4712','dd/mm/yyyy'));
1245:
1246: BEGIN
1247: IF ghr_utility.is_ghr = 'TRUE' AND p_information_type IN ('GHR_US_PER_BENEFIT_INFO','GHR_US_PER_SCD_INFORMATION') THEN
1248: IF g_debug = TRUE THEN
1249: hr_utility.set_location('Inside validate_create_personei',12);
1250: END IF;
1251: l_session_id := USERENV('sessionid');

Line 1249: hr_utility.set_location('Inside validate_create_personei',12);

1245:
1246: BEGIN
1247: IF ghr_utility.is_ghr = 'TRUE' AND p_information_type IN ('GHR_US_PER_BENEFIT_INFO','GHR_US_PER_SCD_INFORMATION') THEN
1248: IF g_debug = TRUE THEN
1249: hr_utility.set_location('Inside validate_create_personei',12);
1250: END IF;
1251: l_session_id := USERENV('sessionid');
1252: ghr_history_api.get_g_session_var(l_session);
1253:

Line 1266: hr_utility.set_location('eff.date ' || l_effective_date,12);

1262: END LOOP;
1263: END IF;
1264:
1265: IF g_debug = TRUE THEN
1266: hr_utility.set_location('eff.date ' || l_effective_date,12);
1267: END IF;
1268:
1269: -- Fire only for Appt, Conv to appt and extension actions
1270: IF l_noa_family_code IN ('APPT','CONV_APPT','EXT_NTE')

Line 1279: hr_utility.set_location('Assignment_type ' || l_assignment_type,12);

1275: l_assignment_id := l_asg_cur.assignment_id;
1276: END LOOP;
1277:
1278: IF g_debug = TRUE THEN
1279: hr_utility.set_location('Assignment_type ' || l_assignment_type,12);
1280: hr_utility.set_location('Assignment_id ' || l_assignment_id,12);
1281: hr_utility.set_location('p_information_type ' || p_information_type,12);
1282: END IF;
1283:

Line 1280: hr_utility.set_location('Assignment_id ' || l_assignment_id,12);

1276: END LOOP;
1277:
1278: IF g_debug = TRUE THEN
1279: hr_utility.set_location('Assignment_type ' || l_assignment_type,12);
1280: hr_utility.set_location('Assignment_id ' || l_assignment_id,12);
1281: hr_utility.set_location('p_information_type ' || p_information_type,12);
1282: END IF;
1283:
1284: -- Validation only if person is employee

Line 1281: hr_utility.set_location('p_information_type ' || p_information_type,12);

1277:
1278: IF g_debug = TRUE THEN
1279: hr_utility.set_location('Assignment_type ' || l_assignment_type,12);
1280: hr_utility.set_location('Assignment_id ' || l_assignment_id,12);
1281: hr_utility.set_location('p_information_type ' || p_information_type,12);
1282: END IF;
1283:
1284: -- Validation only if person is employee
1285: IF l_assignment_type = 'E' THEN

Line 1307: hr_utility.set_location('l_annuitant_indicator ' || l_annuitant_indicator,12);

1303: p_asg_ei_data => l_asg_ei_data
1304: );
1305: l_annuitant_indicator := l_asg_ei_data.aei_information5;
1306: IF g_debug = TRUE THEN
1307: hr_utility.set_location('l_annuitant_indicator ' || l_annuitant_indicator,12);
1308: hr_utility.set_location('l_tsp_scd ' || to_char(l_tsp_scd,'dd/mm/yyyy'),12);
1309: END IF;
1310: -- Call Validation package
1311: validate_benefits(

Line 1308: hr_utility.set_location('l_tsp_scd ' || to_char(l_tsp_scd,'dd/mm/yyyy'),12);

1304: );
1305: l_annuitant_indicator := l_asg_ei_data.aei_information5;
1306: IF g_debug = TRUE THEN
1307: hr_utility.set_location('l_annuitant_indicator ' || l_annuitant_indicator,12);
1308: hr_utility.set_location('l_tsp_scd ' || to_char(l_tsp_scd,'dd/mm/yyyy'),12);
1309: END IF;
1310: -- Call Validation package
1311: validate_benefits(
1312: p_effective_date => l_effective_date

Line 1324: END IF; -- IF ghr_utility.is_ghr

1320: , p_fers_elig_exp_date => l_fers_elig_exp_date
1321: , p_annuitant_indicator => l_annuitant_indicator);
1322: END IF; -- IF l_assignment_type = 'E' THEN
1323: END IF; -- IF l_noa_family_code IN ('APPT','CONV_APPT','EXT_NTE')
1324: END IF; -- IF ghr_utility.is_ghr
1325:
1326: END validate_create_personei;
1327:
1328: