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.

[Home] [Help]

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.11.12010000.2 2008/08/05 15:01:51 ubhat ship $ */
3: --
4: --g_debug BOOLEAN := hr_utility.debug_enabled;
5:
6: g_debug BOOLEAN := TRUE;
7:
8: PROCEDURE validate_benefits(

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

87: -- l_business_group_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
88: FND_PROFILE.get('PER_BUSINESS_GROUP_ID', l_business_group_id);
89:
90: IF g_debug = TRUE THEN
91: hr_utility.set_location('Entering check_element_exist',12);
92: hr_utility.set_location('l_business_group_id ' || l_business_group_id,12);
93: END IF;
94: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name(p_element_name,l_business_group_id,p_effective_date,null);
95:

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

88: FND_PROFILE.get('PER_BUSINESS_GROUP_ID', l_business_group_id);
89:
90: IF g_debug = TRUE THEN
91: hr_utility.set_location('Entering check_element_exist',12);
92: hr_utility.set_location('l_business_group_id ' || l_business_group_id,12);
93: END IF;
94: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name(p_element_name,l_business_group_id,p_effective_date,null);
95:
96: IF g_debug = TRUE THEN

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

93: END IF;
94: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name(p_element_name,l_business_group_id,p_effective_date,null);
95:
96: IF g_debug = TRUE THEN
97: hr_utility.set_location('l_new_element_name ' || l_new_element_name,12);
98: END IF;
99:
100: FOR l_cur_el_type IN c_element_type_id(l_new_element_name,l_business_group_id,p_effective_date) LOOP
101: l_element_type_id := l_cur_el_type.element_type_id;

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

101: l_element_type_id := l_cur_el_type.element_type_id;
102: END LOOP;
103:
104: IF g_debug = TRUE THEN
105: hr_utility.set_location('l_element_type_id ' || l_element_type_id,12);
106: hr_utility.set_location('p_assignment_id ' || p_assignment_id,12);
107: END IF;
108:
109: FOR l_cur_el_exists IN c_element_exist(p_assignment_id, p_effective_date, l_element_type_id) LOOP

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

102: END LOOP;
103:
104: IF g_debug = TRUE THEN
105: hr_utility.set_location('l_element_type_id ' || l_element_type_id,12);
106: hr_utility.set_location('p_assignment_id ' || p_assignment_id,12);
107: END IF;
108:
109: FOR l_cur_el_exists IN c_element_exist(p_assignment_id, p_effective_date, l_element_type_id) LOOP
110: l_exists := TRUE;

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

108:
109: FOR l_cur_el_exists IN c_element_exist(p_assignment_id, p_effective_date, l_element_type_id) LOOP
110: l_exists := TRUE;
111: IF g_debug = TRUE THEN
112: hr_utility.set_location(l_new_element_name || 'element exists',12);
113: END IF;
114: END LOOP;
115:
116: RETURN l_exists;

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

118: BEGIN
119: -- Validation for Health Plan
120: -- If called from element entry
121: l_validate := TRUE;
122: hr_utility.set_location('which eit' || p_which_eit,12);
123: IF (p_which_eit = 'E' AND p_passed_element = 'Health Benefits') OR p_which_eit = 'R'
124: THEN
125: IF g_debug = TRUE THEN
126:

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

123: IF (p_which_eit = 'E' AND p_passed_element = 'Health Benefits') OR p_which_eit = 'R'
124: THEN
125: IF g_debug = TRUE THEN
126:
127: hr_utility.set_location('p_health_plan' || p_health_plan,12);
128: hr_utility.set_location('p_noa_family_code' || p_noa_family_code,12);
129: END IF;
130:
131: IF p_which_eit = 'R' AND p_noa_family_code IN ('CONV_APP','EXT_NTE') THEN

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

124: THEN
125: IF g_debug = TRUE THEN
126:
127: hr_utility.set_location('p_health_plan' || p_health_plan,12);
128: hr_utility.set_location('p_noa_family_code' || p_noa_family_code,12);
129: END IF;
130:
131: IF p_which_eit = 'R' AND p_noa_family_code IN ('CONV_APP','EXT_NTE') THEN
132: IF p_health_plan IS NULL AND

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

141: END IF; -- IF p_which_eit = 'R' AND p_no
142:
143: IF l_validate = TRUE THEN
144: IF p_health_plan IS NULL THEN
145: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');
146: hr_utility.raise_error;
147: END IF;
148:
149: -- Enrollment Option

Line 146: hr_utility.raise_error;

142:
143: IF l_validate = TRUE THEN
144: IF p_health_plan IS NULL THEN
145: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');
146: hr_utility.raise_error;
147: END IF;
148:
149: -- Enrollment Option
150: IF p_enrollment_option IS NULL THEN

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

147: END IF;
148:
149: -- Enrollment Option
150: IF p_enrollment_option IS NULL THEN
151: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');
152: hr_utility.raise_error;
153: NULL;
154: ELSE
155: IF p_health_plan = 'ZZ' AND p_enrollment_option NOT IN('W','X','Y','Z') THEN

Line 152: hr_utility.raise_error;

148:
149: -- Enrollment Option
150: IF p_enrollment_option IS NULL THEN
151: hr_utility.set_message(8301,'GHR_38942_HB_NULL_PLAN_ENROLL');
152: hr_utility.raise_error;
153: NULL;
154: ELSE
155: IF p_health_plan = 'ZZ' AND p_enrollment_option NOT IN('W','X','Y','Z') THEN
156: hr_utility.set_message(8301,'GHR_38950_FEHB_INV_PLAN_OPTION');

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

152: hr_utility.raise_error;
153: NULL;
154: ELSE
155: IF p_health_plan = 'ZZ' AND p_enrollment_option NOT IN('W','X','Y','Z') THEN
156: hr_utility.set_message(8301,'GHR_38950_FEHB_INV_PLAN_OPTION');
157: hr_utility.raise_error;
158: END IF;
159:
160: IF p_health_plan <> 'ZZ' AND p_enrollment_option NOT IN('1','2','4','5') THEN

Line 157: hr_utility.raise_error;

153: NULL;
154: ELSE
155: IF p_health_plan = 'ZZ' AND p_enrollment_option NOT IN('W','X','Y','Z') THEN
156: hr_utility.set_message(8301,'GHR_38950_FEHB_INV_PLAN_OPTION');
157: hr_utility.raise_error;
158: END IF;
159:
160: IF p_health_plan <> 'ZZ' AND p_enrollment_option NOT IN('1','2','4','5') THEN
161: hr_utility.set_message(8301,'GHR_38960_FEHB_NOT_ZZ');

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

157: hr_utility.raise_error;
158: END IF;
159:
160: IF p_health_plan <> 'ZZ' AND p_enrollment_option NOT IN('1','2','4','5') THEN
161: hr_utility.set_message(8301,'GHR_38960_FEHB_NOT_ZZ');
162: hr_utility.raise_error;
163: END IF; -- IF NVL(l_health_plan,hr
164: END IF; -- IF l_enrollment_option IS NULL T
165:

Line 162: hr_utility.raise_error;

158: END IF;
159:
160: IF p_health_plan <> 'ZZ' AND p_enrollment_option NOT IN('1','2','4','5') THEN
161: hr_utility.set_message(8301,'GHR_38960_FEHB_NOT_ZZ');
162: hr_utility.raise_error;
163: END IF; -- IF NVL(l_health_plan,hr
164: END IF; -- IF l_enrollment_option IS NULL T
165:
166: -- Pretax waiver Validation

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

164: END IF; -- IF l_enrollment_option IS NULL T
165:
166: -- Pretax waiver Validation
167: IF p_health_plan = 'ZZ' AND p_pre_tax_waiver = 'Y' THEN
168: hr_utility.set_message(8301,'GHR_38956_PRE_TAX_ZZ_PLAN');
169: hr_utility.raise_error;
170: END IF;
171: END IF; -- IF l_validate = TRUE T
172: END IF; -- IF (p_which_eit = 'E' AND

Line 169: hr_utility.raise_error;

165:
166: -- Pretax waiver Validation
167: IF p_health_plan = 'ZZ' AND p_pre_tax_waiver = 'Y' THEN
168: hr_utility.set_message(8301,'GHR_38956_PRE_TAX_ZZ_PLAN');
169: hr_utility.raise_error;
170: END IF;
171: END IF; -- IF l_validate = TRUE T
172: END IF; -- IF (p_which_eit = 'E' AND
173:

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

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;
181:
182: -- TSP Status should be null

Line 179: hr_utility.raise_error;

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;
181:
182: -- TSP Status should be null
183: IF p_tsp_status IS NOT NULL THEN

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

180: END IF;
181:
182: -- TSP Status should be null
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:

Line 185: hr_utility.raise_error;

181:
182: -- TSP Status should be null
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

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

188:
189: IF p_which_eit = 'E' THEN
190: -- TSP Status should not be null
191: IF p_tsp_status IS NULL THEN
192: hr_utility.set_message(8301,'GHR_38976_TSP_STS_REQD');
193: hr_utility.raise_error;
194: END IF;
195: END IF;
196:

Line 193: hr_utility.raise_error;

189: IF p_which_eit = 'E' THEN
190: -- TSP Status should not be null
191: IF p_tsp_status IS NULL THEN
192: hr_utility.set_message(8301,'GHR_38976_TSP_STS_REQD');
193: hr_utility.raise_error;
194: END IF;
195: END IF;
196:
197: IF g_debug = TRUE THEN

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

194: END IF;
195: END IF;
196:
197: IF g_debug = TRUE THEN
198: hr_utility.set_location('If Retirement plan is not in FERS or CSRS ',1234);
199: END IF;
200:
201: -- Either only Amount should be entered or Rate...
202: IF p_tsp_amount IS NOT NULL AND p_tsp_rate IS NOT NULL THEN

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

199: END IF;
200:
201: -- Either only Amount should be entered or Rate...
202: IF p_tsp_amount IS NOT NULL AND p_tsp_rate IS NOT NULL THEN
203: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
204: hr_utility.raise_error;
205: END IF;
206:
207: -- Status must be 'Y' or 'W'

Line 204: hr_utility.raise_error;

200:
201: -- Either only Amount should be entered or Rate...
202: IF p_tsp_amount IS NOT NULL AND p_tsp_rate IS NOT NULL THEN
203: hr_utility.set_message(8301,'GHR_38685_RATE_AMOUNT_COMBO');
204: hr_utility.raise_error;
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

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

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

Line 211: hr_utility.raise_error;

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;
214:
215: IF g_debug = TRUE THEN

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

212: END IF;
213: END IF;
214:
215: IF g_debug = TRUE THEN
216: hr_utility.set_location('p_tsp_status' || p_tsp_status,1234);
217: END IF;
218:
219: IF p_tsp_status IN ('Y','W') THEN
220: -- Either Amount or Rate should be entered

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

218:
219: IF p_tsp_status IN ('Y','W') THEN
220: -- Either Amount or Rate should be entered
221: IF p_tsp_amount IS NULL AND p_tsp_rate IS NULL THEN
222: hr_utility.set_message(8301,'GHR_38677_INV_RATE_OR_STATUS');
223: hr_utility.raise_error;
224: END IF;
225: END IF;
226:

Line 223: hr_utility.raise_error;

219: IF p_tsp_status IN ('Y','W') THEN
220: -- Either Amount or Rate should be entered
221: IF p_tsp_amount IS NULL AND p_tsp_rate IS NULL THEN
222: hr_utility.set_message(8301,'GHR_38677_INV_RATE_OR_STATUS');
223: hr_utility.raise_error;
224: END IF;
225: END IF;
226:
227:

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

228: -- TSP Status date should be entered if Status is entered
229: -- Status Date should not be blank
230: IF p_tsp_status IS NOT NULL THEN
231: IF p_tsp_status_date IS NULL THEN
232: hr_utility.set_message(8301,'GHR_38675_INVALID_STATUS_DATE');
233: hr_utility.raise_error;
234: END IF;
235: ELSE
236: IF p_tsp_status_date IS NOT NULL THEN

Line 233: hr_utility.raise_error;

229: -- Status Date should not be blank
230: IF p_tsp_status IS NOT NULL THEN
231: IF p_tsp_status_date IS NULL THEN
232: hr_utility.set_message(8301,'GHR_38675_INVALID_STATUS_DATE');
233: hr_utility.raise_error;
234: END IF;
235: ELSE
236: IF p_tsp_status_date IS NOT NULL THEN
237: hr_utility.set_message(8301,'GHR_38676_INVALID_STATUS');

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

233: hr_utility.raise_error;
234: END IF;
235: ELSE
236: IF p_tsp_status_date IS NOT NULL THEN
237: hr_utility.set_message(8301,'GHR_38676_INVALID_STATUS');
238: hr_utility.raise_error;
239: END IF;
240: END IF;
241:

Line 238: hr_utility.raise_error;

234: END IF;
235: ELSE
236: IF p_tsp_status_date IS NOT NULL THEN
237: hr_utility.set_message(8301,'GHR_38676_INVALID_STATUS');
238: hr_utility.raise_error;
239: END IF;
240: END IF;
241:
242: IF g_debug = TRUE THEN

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

239: END IF;
240: END IF;
241:
242: IF g_debug = TRUE THEN
243: hr_utility.set_location('TSP Status date' ,1234);
244: END IF;
245:
246:
247: -- 2.2.2.1.6. If retirement Plan is 2, 4, or 5 and user has entered TSP information, provide error:

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

252: p_tsp_rate IS NOT NULL OR
253: p_tsp_status IS NOT NULL OR
254: p_tsp_status_date IS NOT NULL THEN
255: -- Raise Error message
256: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
257: hr_utility.raise_error;
258: END IF;
259: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
260: IF g_debug = TRUE THEN

Line 257: hr_utility.raise_error;

253: p_tsp_status IS NOT NULL OR
254: p_tsp_status_date IS NOT NULL THEN
255: -- Raise Error message
256: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
257: hr_utility.raise_error;
258: END IF;
259: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
260: IF g_debug = TRUE THEN
261: hr_utility.set_location('If retirement Plan is 2, 4, or 5',1234);

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

257: hr_utility.raise_error;
258: END IF;
259: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
260: IF g_debug = TRUE THEN
261: hr_utility.set_location('If retirement Plan is 2, 4, or 5',1234);
262: END IF;
263: END IF; -- IF (p_which_eit = 'E' AND p_passed_element = 'Health Benefits')
264:
265: IF p_which_eit = 'R' OR p_which_eit = 'P' THEN

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

264:
265: IF p_which_eit = 'R' OR p_which_eit = 'P' THEN
266: -- Validation for FEHB eligibility
267: IF g_debug = TRUE THEN
268: hr_utility.set_location('p_date_fehb_elig ' || to_char(p_date_fehb_elig,'dd/mm/yyyy') ,1234);
269: END IF;
270:
271: IF p_date_fehb_elig IS NOT NULL THEN
272: IF p_date_fehb_elig <= p_effective_date THEN

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

269: END IF;
270:
271: IF p_date_fehb_elig IS NOT NULL THEN
272: IF p_date_fehb_elig <= p_effective_date THEN
273: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
274: hr_utility.set_message_token('BEN_ELIG_DATE','FEHB Eligibility Expiration Date');
275: hr_utility.raise_error;
276: END IF;
277: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') THEN

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

270:
271: IF p_date_fehb_elig IS NOT NULL THEN
272: IF p_date_fehb_elig <= p_effective_date THEN
273: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
274: hr_utility.set_message_token('BEN_ELIG_DATE','FEHB Eligibility Expiration Date');
275: hr_utility.raise_error;
276: END IF;
277: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') THEN
278: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');

Line 275: hr_utility.raise_error;

271: IF p_date_fehb_elig IS NOT NULL THEN
272: IF p_date_fehb_elig <= p_effective_date THEN
273: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
274: hr_utility.set_message_token('BEN_ELIG_DATE','FEHB Eligibility Expiration Date');
275: hr_utility.raise_error;
276: END IF;
277: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') THEN
278: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
279: hr_utility.raise_error;

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

274: hr_utility.set_message_token('BEN_ELIG_DATE','FEHB Eligibility Expiration Date');
275: hr_utility.raise_error;
276: END IF;
277: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') THEN
278: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
279: hr_utility.raise_error;
280: END IF;
281: END IF;
282:

Line 279: hr_utility.raise_error;

275: hr_utility.raise_error;
276: END IF;
277: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') THEN
278: hr_utility.set_message(8301,'GHR_38952_FEHB_ELIG_FOR_TMP');
279: hr_utility.raise_error;
280: END IF;
281: END IF;
282:
283: IF g_debug = TRUE THEN

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

280: END IF;
281: END IF;
282:
283: IF g_debug = TRUE THEN
284: hr_utility.set_location('p_date_temp_elig ' || to_char(p_date_temp_elig,'dd/mm/yyyy') ,1234);
285: END IF;
286: -- Date Temp Eligibility Expires - Validation
287: IF p_date_temp_elig IS NOT NULL THEN
288: IF p_first_noa_code IS NOT NULL THEN

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

287: IF p_date_temp_elig IS NOT NULL THEN
288: IF p_first_noa_code IS NOT NULL THEN
289: IF p_first_noa_code IN ('115','122','149','171','515','522','549','571') AND p_tenure = '0' THEN
290: IF p_date_temp_elig <= p_effective_date THEN
291: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');
292: hr_utility.raise_error;
293: END IF;
294: END IF;
295: -- If tenure code is not 0, then value should be null

Line 292: hr_utility.raise_error;

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

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

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

Line 298: hr_utility.raise_error;

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

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

298: hr_utility.raise_error;
299: END IF;
300: -- This field is valid only for Temp. appointments. else throw error.
301: -- Bug 4668813
302: hr_utility.set_location('p_first_noa_code'|| p_first_noa_code,223);
303:
304: 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
305: hr_utility.set_message(8301,'GHR_38955_TMP_ELIG_FOR_TMP');
306: hr_utility.raise_error;

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

301: -- Bug 4668813
302: hr_utility.set_location('p_first_noa_code'|| p_first_noa_code,223);
303:
304: 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
305: hr_utility.set_message(8301,'GHR_38955_TMP_ELIG_FOR_TMP');
306: hr_utility.raise_error;
307: END IF;
308: ELSIF p_which_eit = 'P' THEN
309: IF p_date_temp_elig <= p_effective_date THEN

Line 306: hr_utility.raise_error;

302: hr_utility.set_location('p_first_noa_code'|| p_first_noa_code,223);
303:
304: 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
305: hr_utility.set_message(8301,'GHR_38955_TMP_ELIG_FOR_TMP');
306: hr_utility.raise_error;
307: END IF;
308: ELSIF p_which_eit = 'P' THEN
309: IF p_date_temp_elig <= p_effective_date THEN
310: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');

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

306: hr_utility.raise_error;
307: END IF;
308: ELSIF p_which_eit = 'P' THEN
309: IF p_date_temp_elig <= p_effective_date THEN
310: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');
311: hr_utility.raise_error;
312: END IF;
313: END IF; -- IF p_first_noa_code IS NOT NULL THEN
314: END IF; -- IF p_rei_information4 IS NOT

Line 311: hr_utility.raise_error;

307: END IF;
308: ELSIF p_which_eit = 'P' THEN
309: IF p_date_temp_elig <= p_effective_date THEN
310: hr_utility.set_message(8301,'GHR_38953_TMP_ELIG_FUT_DATE');
311: hr_utility.raise_error;
312: END IF;
313: END IF; -- IF p_first_noa_code IS NOT NULL THEN
314: END IF; -- IF p_rei_information4 IS NOT
315:

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

316: --
317: IF p_date_temp_elig IS NOT NULL AND p_date_temp_elig > NVL(p_effective_date,TRUNC(SYSDATE)) THEN
318: IF p_health_plan IS NOT NULL THEN
319: IF p_health_plan <> 'ZZ' AND p_enrollment_option <> 'Z' THEN
320: hr_utility.set_message(8301,'GHR_38964_FEHB_TMP_PLAN');
321: hr_utility.raise_error;
322: END IF;
323: END IF;
324: END IF; -- IF p_date_temp_elig IS NOT NULL

Line 321: hr_utility.raise_error;

317: IF p_date_temp_elig IS NOT NULL AND p_date_temp_elig > NVL(p_effective_date,TRUNC(SYSDATE)) THEN
318: IF p_health_plan IS NOT NULL THEN
319: IF p_health_plan <> 'ZZ' AND p_enrollment_option <> 'Z' THEN
320: hr_utility.set_message(8301,'GHR_38964_FEHB_TMP_PLAN');
321: hr_utility.raise_error;
322: END IF;
323: END IF;
324: END IF; -- IF p_date_temp_elig IS NOT NULL
325:

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

323: END IF;
324: END IF; -- IF p_date_temp_elig IS NOT NULL
325:
326: IF g_debug = TRUE THEN
327: hr_utility.set_location('p_fegli_elig_exp_date ' || to_char(p_fegli_elig_exp_date,'dd/mm/yyyy') ,1234);
328: END IF;
329:
330: -- FEGLI Eligibility Expiration Validation
331: IF p_fegli_elig_exp_date IS NOT NULL THEN

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

329:
330: -- FEGLI Eligibility Expiration Validation
331: IF p_fegli_elig_exp_date IS NOT NULL THEN
332: IF p_fegli_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
333: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
334: hr_utility.set_message_token('BEN_ELIG_DATE','FEGLI Eligibility Expiration Date');
335: hr_utility.raise_error;
336: END IF;
337: END IF; -- IF p_fegli_elig_exp_date IS NOT NULL THEN

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

330: -- FEGLI Eligibility Expiration Validation
331: IF p_fegli_elig_exp_date IS NOT NULL THEN
332: IF p_fegli_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
333: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
334: hr_utility.set_message_token('BEN_ELIG_DATE','FEGLI Eligibility Expiration Date');
335: hr_utility.raise_error;
336: END IF;
337: END IF; -- IF p_fegli_elig_exp_date IS NOT NULL THEN
338:

Line 335: hr_utility.raise_error;

331: IF p_fegli_elig_exp_date IS NOT NULL THEN
332: IF p_fegli_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
333: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
334: hr_utility.set_message_token('BEN_ELIG_DATE','FEGLI Eligibility Expiration Date');
335: hr_utility.raise_error;
336: END IF;
337: END IF; -- IF p_fegli_elig_exp_date IS NOT NULL THEN
338:
339: IF g_debug = TRUE THEN

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

336: END IF;
337: END IF; -- IF p_fegli_elig_exp_date IS NOT NULL THEN
338:
339: IF g_debug = TRUE THEN
340: hr_utility.set_location('-- FEGLI Eligibility Expiration Validatio',1234);
341: END IF;
342: -- FERS Eligibility Expiration Validation
343: IF p_fers_elig_exp_date IS NOT NULL THEN
344: IF p_fers_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN

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

341: END IF;
342: -- FERS Eligibility Expiration Validation
343: IF p_fers_elig_exp_date IS NOT NULL THEN
344: IF p_fers_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
345: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
346: hr_utility.set_message_token('BEN_ELIG_DATE','FERS Eligibility Expiration Date');
347: hr_utility.raise_error;
348: END IF;
349: END IF; -- IF p_fers_elig_exp_date IS NOT NULL THEN

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

342: -- FERS Eligibility Expiration Validation
343: IF p_fers_elig_exp_date IS NOT NULL THEN
344: IF p_fers_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
345: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
346: hr_utility.set_message_token('BEN_ELIG_DATE','FERS Eligibility Expiration Date');
347: hr_utility.raise_error;
348: END IF;
349: END IF; -- IF p_fers_elig_exp_date IS NOT NULL THEN
350: IF g_debug = TRUE THEN

Line 347: hr_utility.raise_error;

343: IF p_fers_elig_exp_date IS NOT NULL THEN
344: IF p_fers_elig_exp_date <= NVL(p_effective_date,TRUNC(SYSDATE)) THEN
345: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
346: hr_utility.set_message_token('BEN_ELIG_DATE','FERS Eligibility Expiration Date');
347: hr_utility.raise_error;
348: END IF;
349: END IF; -- IF p_fers_elig_exp_date IS NOT NULL THEN
350: IF g_debug = TRUE THEN
351: hr_utility.set_location('-- FERS Eligibility Expiration Validation',1234);

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

347: hr_utility.raise_error;
348: END IF;
349: END IF; -- IF p_fers_elig_exp_date IS NOT NULL THEN
350: IF g_debug = TRUE THEN
351: hr_utility.set_location('-- FERS Eligibility Expiration Validation',1234);
352: END IF;
353:
354: IF p_which_eit = 'R' AND p_noa_family_code IN ('CONV_APP','EXT_NTE') THEN
355: IF p_tsp_amount IS NULL AND

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

367: IF l_validate = TRUE THEN
368: IF p_retirement_plan IN ('D','K','L','M','N','P') THEN
369: IF LTRIM(p_tsp_scd) IS NULL THEN
370: -- Raise Error message
371: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');
372: hr_utility.raise_error;
373: END IF;
374: END IF; -- IF p_retirement_plan IN ('D','K','L'...
375: END IF;

Line 372: hr_utility.raise_error;

368: IF p_retirement_plan IN ('D','K','L','M','N','P') THEN
369: IF LTRIM(p_tsp_scd) IS NULL THEN
370: -- Raise Error message
371: hr_utility.set_message(8301,'GHR_38957_TSP_FERS');
372: hr_utility.raise_error;
373: END IF;
374: END IF; -- IF p_retirement_plan IN ('D','K','L'...
375: END IF;
376:

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

376:
377: IF p_tsp_scd IS NOT NULL AND p_retirement_plan IS NOT NULL THEN
378: IF p_retirement_plan NOT IN ('D','K','L','M','N','P') THEN
379: -- Raise Error message
380: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');--Bug# 4769233
381: hr_utility.raise_error;
382: END IF;
383: END IF;
384:

Line 381: hr_utility.raise_error;

377: IF p_tsp_scd IS NOT NULL AND p_retirement_plan IS NOT NULL THEN
378: IF p_retirement_plan NOT IN ('D','K','L','M','N','P') THEN
379: -- Raise Error message
380: hr_utility.set_message(8301,'GHR_38392_NON_TSP_FERS');--Bug# 4769233
381: hr_utility.raise_error;
382: END IF;
383: END IF;
384:
385: IF p_retirement_plan NOT IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W') THEN

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

384:
385: IF p_retirement_plan NOT IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W') THEN
386: -- Emp Contrib Elig date should be Null
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:

Line 389: hr_utility.raise_error;

385: IF p_retirement_plan NOT IN ('D','K','L','M','N','P','1','3','6','C','E','F','G','R','T','H','W') THEN
386: -- Emp Contrib Elig date should be Null
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

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

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

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

395: END IF;
396:
397: -- IF TSP status is I then the date must be future.
398: IF p_tsp_status = 'I' AND NVL(p_effective_date, TRUNC(SYSDATE)) > p_agency_contrib_date THEN
399: hr_utility.set_message(8301,'GHR_38680_INV_AGENCY_CONTRIB');
400: hr_utility.raise_error;
401: END IF;
402:
403: IF g_debug = TRUE THEN

Line 400: hr_utility.raise_error;

396:
397: -- IF TSP status is I then the date must be future.
398: IF p_tsp_status = 'I' AND NVL(p_effective_date, TRUNC(SYSDATE)) > p_agency_contrib_date THEN
399: hr_utility.set_message(8301,'GHR_38680_INV_AGENCY_CONTRIB');
400: hr_utility.raise_error;
401: END IF;
402:
403: IF g_debug = TRUE THEN
404: hr_utility.set_location(' IF TSP status is I',1234);

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

400: hr_utility.raise_error;
401: END IF;
402:
403: IF g_debug = TRUE THEN
404: hr_utility.set_location(' IF TSP status is I',1234);
405: END IF;
406:
407:
408:

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

416: OR p_retirement_plan IN ('J','X') THEN
417: IF p_agency_contrib_date IS NOT NULL OR
418: p_emp_contrib_date IS NOT NULL THEN
419: -- Raise Error message
420: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
421: hr_utility.raise_error;
422: END IF;
423: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
424: END IF;

Line 421: hr_utility.raise_error;

417: IF p_agency_contrib_date IS NOT NULL OR
418: p_emp_contrib_date IS NOT NULL THEN
419: -- Raise Error message
420: hr_utility.set_message(8301,'GHR_38965_TSP_OTH');
421: hr_utility.raise_error;
422: END IF;
423: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
424: END IF;
425:

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

423: END IF; -- IF p_retirement_plan IN ('2','4','5') THEN
424: END IF;
425:
426: IF g_debug = TRUE THEN
427: hr_utility.set_location('If retirement Plan is 2, 4, or 5',1234);
428: END IF;
429:
430: IF p_which_eit = 'R' THEN
431: -- If Agency or Emp contrib dates are entered, then status cannot be null

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

430: IF p_which_eit = 'R' THEN
431: -- If Agency or Emp contrib dates are entered, then status cannot be null
432: IF p_agency_contrib_date IS NOT NULL OR p_emp_contrib_date IS NOT NULL THEN
433: IF p_tsp_status IS NULL THEN
434: hr_utility.set_message(8301,'GHR_38679_BLANK_STATUS');
435: hr_utility.raise_error;
436: END IF;
437: END IF;
438:

Line 435: hr_utility.raise_error;

431: -- If Agency or Emp contrib dates are entered, then status cannot be null
432: IF p_agency_contrib_date IS NOT NULL OR p_emp_contrib_date IS NOT NULL THEN
433: IF p_tsp_status IS NULL THEN
434: hr_utility.set_message(8301,'GHR_38679_BLANK_STATUS');
435: hr_utility.raise_error;
436: END IF;
437: END IF;
438:
439: -- Bug 4691271 and 4687755

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

439: -- Bug 4691271 and 4687755
440: -- If FERS, the value should be not null. Else it should be null.
441: IF p_retirement_plan IN ('D','K','L','M','N','P') THEN
442: IF p_agency_contrib_date IS NULL THEN -- Bug 4693453
443: hr_utility.set_message(8301,'GHR_38977_TSP_AGNCY_DATE_REQD');
444: hr_utility.raise_error;
445: END IF;
446: ELSIF p_agency_contrib_date IS NOT NULL THEN
447: hr_utility.set_message(8301,'GHR_38961_NOT_FERS_AGNCY_DATE');

Line 444: hr_utility.raise_error;

440: -- If FERS, the value should be not null. Else it should be null.
441: IF p_retirement_plan IN ('D','K','L','M','N','P') THEN
442: IF p_agency_contrib_date IS NULL THEN -- Bug 4693453
443: hr_utility.set_message(8301,'GHR_38977_TSP_AGNCY_DATE_REQD');
444: hr_utility.raise_error;
445: END IF;
446: ELSIF p_agency_contrib_date IS NOT NULL THEN
447: hr_utility.set_message(8301,'GHR_38961_NOT_FERS_AGNCY_DATE');
448: hr_utility.raise_error;

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

443: hr_utility.set_message(8301,'GHR_38977_TSP_AGNCY_DATE_REQD');
444: hr_utility.raise_error;
445: END IF;
446: ELSIF p_agency_contrib_date IS NOT NULL THEN
447: hr_utility.set_message(8301,'GHR_38961_NOT_FERS_AGNCY_DATE');
448: hr_utility.raise_error;
449: END IF;
450: END IF;
451:

Line 448: hr_utility.raise_error;

444: hr_utility.raise_error;
445: END IF;
446: ELSIF p_agency_contrib_date IS NOT NULL THEN
447: hr_utility.set_message(8301,'GHR_38961_NOT_FERS_AGNCY_DATE');
448: hr_utility.raise_error;
449: END IF;
450: END IF;
451:
452: -- 2.2.1.1.3. AND 2.2.2.1.3 TSP Agncy Contrib Elig Date is required for all FERS covered employees.

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

500: IF p_which_eit = 'R' AND p_first_noa_code IN ('130','132','145','147','140','141','143') THEN
501: NULL;
502: ELSIF p_agency_contrib_date <> l_start_date THEN
503: -- Raise Error message
504: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
505: hr_utility.set_message_token('ST_MONTH',l_st_month);
506: hr_utility.set_message_token('END_MONTH',l_end_month);
507: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
508: hr_utility.raise_error;

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

501: NULL;
502: ELSIF p_agency_contrib_date <> l_start_date THEN
503: -- Raise Error message
504: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
505: hr_utility.set_message_token('ST_MONTH',l_st_month);
506: hr_utility.set_message_token('END_MONTH',l_end_month);
507: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
508: hr_utility.raise_error;
509: END IF;

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

502: ELSIF p_agency_contrib_date <> l_start_date THEN
503: -- Raise Error message
504: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
505: hr_utility.set_message_token('ST_MONTH',l_st_month);
506: hr_utility.set_message_token('END_MONTH',l_end_month);
507: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
508: hr_utility.raise_error;
509: END IF;
510:

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

503: -- Raise Error message
504: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
505: hr_utility.set_message_token('ST_MONTH',l_st_month);
506: hr_utility.set_message_token('END_MONTH',l_end_month);
507: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
508: hr_utility.raise_error;
509: END IF;
510:
511: IF g_debug = TRUE THEN

Line 508: hr_utility.raise_error;

504: hr_utility.set_message(8301,'GHR_38959_AGNCY_DATE_STRT_DATE');
505: hr_utility.set_message_token('ST_MONTH',l_st_month);
506: hr_utility.set_message_token('END_MONTH',l_end_month);
507: hr_utility.set_message_token('PAY_MONTH',l_pay_month);
508: hr_utility.raise_error;
509: END IF;
510:
511: IF g_debug = TRUE THEN
512: hr_utility.set_location('Get Payroll ID',1234);

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

508: hr_utility.raise_error;
509: END IF;
510:
511: IF g_debug = TRUE THEN
512: hr_utility.set_location('Get Payroll ID',1234);
513: END IF;
514:
515:
516: -- TSP Emp Contrib Elig date validation

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

516: -- TSP Emp Contrib Elig date validation
517: IF p_emp_contrib_date IS NOT NULL THEN
518: IF p_noa_family_code = 'APP' AND p_first_noa_code NOT IN ('130','132','145','147') THEN
519: -- Raise Error message
520: hr_utility.set_message(8301,'GHR_38962_APP_EMP_ELIG_DATE');
521: hr_utility.raise_error;
522: ELSE
523: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
524: -- Raise Error message

Line 521: hr_utility.raise_error;

517: IF p_emp_contrib_date IS NOT NULL THEN
518: IF p_noa_family_code = 'APP' AND p_first_noa_code NOT IN ('130','132','145','147') THEN
519: -- Raise Error message
520: hr_utility.set_message(8301,'GHR_38962_APP_EMP_ELIG_DATE');
521: hr_utility.raise_error;
522: ELSE
523: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
524: -- Raise Error message
525: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');

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

521: hr_utility.raise_error;
522: ELSE
523: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
524: -- Raise Error message
525: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
526: hr_utility.set_message_token('BEN_ELIG_DATE','TSP Emp Contrib Elig date');
527: hr_utility.raise_error;
528: END IF;
529: -- Amount or Rate should be null

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

522: ELSE
523: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
524: -- Raise Error message
525: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
526: hr_utility.set_message_token('BEN_ELIG_DATE','TSP Emp Contrib Elig date');
527: hr_utility.raise_error;
528: END IF;
529: -- Amount or Rate should be null
530: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN

Line 527: hr_utility.raise_error;

523: IF NVL(p_effective_date,TRUNC(SYSDATE)) <= p_emp_contrib_date THEN
524: -- Raise Error message
525: hr_utility.set_message(8301,'GHR_38951_BEN_ELIG_DATE');
526: hr_utility.set_message_token('BEN_ELIG_DATE','TSP Emp Contrib Elig date');
527: hr_utility.raise_error;
528: END IF;
529: -- Amount or Rate should be null
530: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
531: -- Raise Error message

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

528: END IF;
529: -- Amount or Rate should be null
530: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
531: -- Raise Error message
532: hr_utility.set_message(8301,'GHR_38963_TSP_EMP_ELIG_DATE');
533: hr_utility.raise_error;
534: END IF;
535: END IF; -- IF l_noa_family_code = 'APP' THEN
536: END IF;

Line 533: hr_utility.raise_error;

529: -- Amount or Rate should be null
530: IF p_tsp_amount IS NOT NULL OR p_tsp_rate IS NOT NULL THEN
531: -- Raise Error message
532: hr_utility.set_message(8301,'GHR_38963_TSP_EMP_ELIG_DATE');
533: hr_utility.raise_error;
534: END IF;
535: END IF; -- IF l_noa_family_code = 'APP' THEN
536: END IF;
537: IF g_debug = TRUE THEN

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

534: END IF;
535: END IF; -- IF l_noa_family_code = 'APP' THEN
536: END IF;
537: IF g_debug = TRUE THEN
538: hr_utility.set_location('IF p_rei_information18 IS NOT NULL',1234);
539: END IF;
540:
541:
542: END IF; -- IF p_which_eit = 'R' THEN

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

633: l_retirement_plan ghr_pa_requests.retirement_plan%type;
634: l_debug_mode BOOLEAN;
635: BEGIN
636: -- Initialization
637: IF ghr_utility.is_ghr = 'TRUE' THEN
638: IF g_debug = TRUE THEN
639: hr_utility.set_location('Entering validate_create_element',110);
640: END IF;
641:

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

635: BEGIN
636: -- Initialization
637: IF ghr_utility.is_ghr = 'TRUE' THEN
638: IF g_debug = TRUE THEN
639: hr_utility.set_location('Entering validate_create_element',110);
640: END IF;
641:
642: l_business_group_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
643: l_debug_mode := FALSE;

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

642: l_business_group_id := FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
643: l_debug_mode := FALSE;
644:
645: IF g_debug = TRUE THEN
646: hr_utility.set_location('l_business_group_id -- ' || l_business_group_id,110);
647: END IF;
648:
649: -- Check for the element Name
650: FOR l_cur_element_name IN c_element_name(p_element_link_id,p_effective_date,l_business_group_id) LOOP

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

651: l_new_element_name := l_cur_element_name.element_name;
652: END LOOP;
653:
654: IF g_debug = TRUE THEN
655: hr_utility.set_location('New Element name -- ' || l_new_element_name,110);
656: END IF;
657:
658: l_element_name := pqp_fedhr_uspay_int_utils.return_old_element_name(l_new_element_name,l_business_group_id,p_effective_date);
659:

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

657:
658: l_element_name := pqp_fedhr_uspay_int_utils.return_old_element_name(l_new_element_name,l_business_group_id,p_effective_date);
659:
660: IF g_debug = TRUE THEN
661: hr_utility.set_location('Element name -- ' || l_element_name,110);
662: END IF;
663:
664: l_ret_plan_name := pqp_fedhr_uspay_int_utils.return_new_element_name('Retirement Plan',l_business_group_id,p_effective_date,null);
665:

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

669: END IF;
670: END LOOP;
671:
672: IF g_debug = TRUE THEN
673: hr_utility.set_location('Retirement plan -- ' || l_retirement_plan,110);
674: END IF;
675:
676: IF l_element_name = 'TSP' THEN
677: FOR l_cur_element IN c_element(l_new_element_name,p_assignment_id, p_effective_date,l_business_group_id) LOOP

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

686: END IF;
687: END LOOP;
688:
689: IF g_debug = TRUE THEN
690: hr_utility.set_location('Entering validation tsp',110);
691: END IF;
692:
693: ghr_ben_validation.validate_benefits(
694: p_effective_date => p_effective_date

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

715: END IF;
716: END LOOP;
717:
718: IF g_debug = TRUE THEN
719: hr_utility.set_location('Entering validation fehb',110);
720: END IF;
721:
722: -- Validation part
723: validate_benefits(

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

730: , p_pre_tax_waiver => l_pre_tax_waiver
731: );
732:
733: END IF; -- IF l_element_name = 'TSP
734: END IF; -- IF ghr_utility.is_ghr = 'TRUE
735:
736: END validate_create_element;
737:
738: PROCEDURE validate_update_element(

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

747: ,P_ELEMENT_TYPE_ID_O in number default null
748: ) IS
749: BEGIN
750: IF g_debug = TRUE THEN
751: hr_utility.set_location('Entering validate_update_element',110);
752: END IF;
753: validate_create_element(
754: p_effective_date => p_effective_date
755: ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID_O

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

816: AND c_effective_date BETWEEN NVL(start_date_active,to_date('01/01/1951','dd/mm/yyyy'))
817: AND NVL(end_date_active,to_date('31/12/4712','dd/mm/yyyy'));
818:
819: BEGIN
820: IF ghr_utility.is_ghr = 'TRUE' AND p_information_type IN ('GHR_US_PER_BENEFIT_INFO','GHR_US_PER_SCD_INFORMATION') THEN
821: IF g_debug = TRUE THEN
822: hr_utility.set_location('Inside validate_create_personei',12);
823: END IF;
824: l_session_id := USERENV('sessionid');

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

818:
819: BEGIN
820: IF ghr_utility.is_ghr = 'TRUE' AND p_information_type IN ('GHR_US_PER_BENEFIT_INFO','GHR_US_PER_SCD_INFORMATION') THEN
821: IF g_debug = TRUE THEN
822: hr_utility.set_location('Inside validate_create_personei',12);
823: END IF;
824: l_session_id := USERENV('sessionid');
825: ghr_history_api.get_g_session_var(l_session);
826:

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

835: END LOOP;
836: END IF;
837:
838: IF g_debug = TRUE THEN
839: hr_utility.set_location('eff.date ' || l_effective_date,12);
840: END IF;
841:
842: -- Fire only for Appt, Conv to appt and extension actions
843: IF l_noa_family_code IN ('APPT','CONV_APPT','EXT_NTE')

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

848: l_assignment_id := l_asg_cur.assignment_id;
849: END LOOP;
850:
851: IF g_debug = TRUE THEN
852: hr_utility.set_location('Assignment_type ' || l_assignment_type,12);
853: hr_utility.set_location('Assignment_id ' || l_assignment_id,12);
854: hr_utility.set_location('p_information_type ' || p_information_type,12);
855: END IF;
856:

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

849: END LOOP;
850:
851: IF g_debug = TRUE THEN
852: hr_utility.set_location('Assignment_type ' || l_assignment_type,12);
853: hr_utility.set_location('Assignment_id ' || l_assignment_id,12);
854: hr_utility.set_location('p_information_type ' || p_information_type,12);
855: END IF;
856:
857: -- Validation only if person is employee

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

850:
851: IF g_debug = TRUE THEN
852: hr_utility.set_location('Assignment_type ' || l_assignment_type,12);
853: hr_utility.set_location('Assignment_id ' || l_assignment_id,12);
854: hr_utility.set_location('p_information_type ' || p_information_type,12);
855: END IF;
856:
857: -- Validation only if person is employee
858: IF l_assignment_type = 'E' THEN

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

876: p_asg_ei_data => l_asg_ei_data
877: );
878: l_annuitant_indicator := l_asg_ei_data.aei_information5;
879: IF g_debug = TRUE THEN
880: hr_utility.set_location('l_annuitant_indicator ' || l_annuitant_indicator,12);
881: hr_utility.set_location('l_tsp_scd ' || to_char(l_tsp_scd,'dd/mm/yyyy'),12);
882: END IF;
883: -- Call Validation package
884: validate_benefits(

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

877: );
878: l_annuitant_indicator := l_asg_ei_data.aei_information5;
879: IF g_debug = TRUE THEN
880: hr_utility.set_location('l_annuitant_indicator ' || l_annuitant_indicator,12);
881: hr_utility.set_location('l_tsp_scd ' || to_char(l_tsp_scd,'dd/mm/yyyy'),12);
882: END IF;
883: -- Call Validation package
884: validate_benefits(
885: p_effective_date => l_effective_date

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

893: , p_fers_elig_exp_date => l_fers_elig_exp_date
894: , p_annuitant_indicator => l_annuitant_indicator);
895: END IF; -- IF l_assignment_type = 'E' THEN
896: END IF; -- IF l_noa_family_code IN ('APPT','CONV_APPT','EXT_NTE')
897: END IF; -- IF ghr_utility.is_ghr
898:
899: END validate_create_personei;
900:
901: