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_UPD_HR_VALIDATION dependencies on HR_UTILITY

Line 219: hr_utility.set_location('Entering:'||l_proc, 1);

215: first_set_form_item_name(p_block_name || '.' ||p_item_name);
216: END IF;
217: END check_null;
218: BEGIN
219: hr_utility.set_location('Entering:'||l_proc, 1);
220: --
221: ghr_upd_hr_validation.form_item_name := null;
222: -- I would like to have done this dynamically but I couldn't work out how and I was running
223: -- out of time!!!!

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

230: IF column_index <> -1 THEN
231: check_null(column_defs(column_index).value, cur_rpm_rec.prompt, cur_rpm_rec.form_block_name,
232: cur_rpm_rec.form_field_name, l_null_list, l_at_least_one_null);
233: ELSE
234: hr_utility.set_message(8301,'GHR_38235_INV_REC_STRUC_COL');
235: fnd_message.set_token('RECORD_STRUCTURE_NAME',cur_rpm_rec.record_structure_name);
236: fnd_message.set_token('RECORD_STRUCTURE_COL_NAME',cur_rpm_rec.record_structure_col_name);
237: hr_utility.raise_error;
238: END IF;

Line 237: hr_utility.raise_error;

233: ELSE
234: hr_utility.set_message(8301,'GHR_38235_INV_REC_STRUC_COL');
235: fnd_message.set_token('RECORD_STRUCTURE_NAME',cur_rpm_rec.record_structure_name);
236: fnd_message.set_token('RECORD_STRUCTURE_COL_NAME',cur_rpm_rec.record_structure_col_name);
237: hr_utility.raise_error;
238: END IF;
239: ELSE
240: hr_utility.set_message(8301,'GHR_38236_INV_REC_STRUC_NAME');
241: fnd_message.set_token('RECORD_STRUCTURE_NAME',cur_rpm_rec.record_structure_name);

Line 240: hr_utility.set_message(8301,'GHR_38236_INV_REC_STRUC_NAME');

236: fnd_message.set_token('RECORD_STRUCTURE_COL_NAME',cur_rpm_rec.record_structure_col_name);
237: hr_utility.raise_error;
238: END IF;
239: ELSE
240: hr_utility.set_message(8301,'GHR_38236_INV_REC_STRUC_NAME');
241: fnd_message.set_token('RECORD_STRUCTURE_NAME',cur_rpm_rec.record_structure_name);
242: hr_utility.raise_error;
243: END IF;
244: END LOOP;

Line 242: hr_utility.raise_error;

238: END IF;
239: ELSE
240: hr_utility.set_message(8301,'GHR_38236_INV_REC_STRUC_NAME');
241: fnd_message.set_token('RECORD_STRUCTURE_NAME',cur_rpm_rec.record_structure_name);
242: hr_utility.raise_error;
243: END IF;
244: END LOOP;
245:
246: hr_utility.set_location(l_proc, 90);

Line 246: hr_utility.set_location(l_proc, 90);

242: hr_utility.raise_error;
243: END IF;
244: END LOOP;
245:
246: hr_utility.set_location(l_proc, 90);
247:
248: IF l_at_least_one_null THEN
249: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
250: fnd_message.set_token('REQUIRED_LIST',l_null_list);

Line 249: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');

245:
246: hr_utility.set_location(l_proc, 90);
247:
248: IF l_at_least_one_null THEN
249: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
250: fnd_message.set_token('REQUIRED_LIST',l_null_list);
251: hr_utility.raise_error;
252: END IF;
253:

Line 251: hr_utility.raise_error;

247:
248: IF l_at_least_one_null THEN
249: hr_utility.set_message(8301,'GHR_38237_REQUIRED_ITEMS');
250: fnd_message.set_token('REQUIRED_LIST',l_null_list);
251: hr_utility.raise_error;
252: END IF;
253:
254: IF p_government_awards_type.date_exemp_award is not null then
255: l_exemp_award_date := fnd_date.canonical_to_date(p_government_awards_type.date_exemp_award);

Line 263: hr_utility.set_message(8301, 'GHR_38835_EFF_DT_EQUAL_SEP_DT');

259:
260: --Bug 2837169
261:
262: IF l_rpa_eff_date <> l_asg_end_date THEN
263: hr_utility.set_message(8301, 'GHR_38835_EFF_DT_EQUAL_SEP_DT');
264: hr_utility.raise_error;
265: END IF;
266: --End of Bug 2837169
267:

Line 264: hr_utility.raise_error;

260: --Bug 2837169
261:
262: IF l_rpa_eff_date <> l_asg_end_date THEN
263: hr_utility.set_message(8301, 'GHR_38835_EFF_DT_EQUAL_SEP_DT');
264: hr_utility.raise_error;
265: END IF;
266: --End of Bug 2837169
267:
268: IF l_award_date IS NOT NULL THEN

Line 270: hr_utility.set_message(8301, 'GHR_38806_EXEMP_AWD_AWD_EARNED');

266: --End of Bug 2837169
267:
268: IF l_award_date IS NOT NULL THEN
269: IF l_exemp_award_date < l_award_date THEN
270: hr_utility.set_message(8301, 'GHR_38806_EXEMP_AWD_AWD_EARNED');
271: hr_utility.raise_error;
272: END IF;
273: END IF;
274: -- Bug#2835007 Added NOAC 848

Line 271: hr_utility.raise_error;

267:
268: IF l_award_date IS NOT NULL THEN
269: IF l_exemp_award_date < l_award_date THEN
270: hr_utility.set_message(8301, 'GHR_38806_EXEMP_AWD_AWD_EARNED');
271: hr_utility.raise_error;
272: END IF;
273: END IF;
274: -- Bug#2835007 Added NOAC 848
275: IF nvl(p_pa_requests_type.first_noa_code,'@@') in ('846','847','848','872') then

Line 276: hr_utility.set_message(8301, 'GHR_38809_EXEMP_AWD_INV_NOA');

272: END IF;
273: END IF;
274: -- Bug#2835007 Added NOAC 848
275: IF nvl(p_pa_requests_type.first_noa_code,'@@') in ('846','847','848','872') then
276: hr_utility.set_message(8301, 'GHR_38809_EXEMP_AWD_INV_NOA');
277: hr_utility.raise_error;
278: END IF;
279: END IF;
280:

Line 277: hr_utility.raise_error;

273: END IF;
274: -- Bug#2835007 Added NOAC 848
275: IF nvl(p_pa_requests_type.first_noa_code,'@@') in ('846','847','848','872') then
276: hr_utility.set_message(8301, 'GHR_38809_EXEMP_AWD_INV_NOA');
277: hr_utility.raise_error;
278: END IF;
279: END IF;
280:
281: IF p_government_awards_type.date_exemp_award is not null THEN

Line 288: hr_utility.set_message(8301, 'GHR_38809_EXEMP_AWD_INV_NOA');

284: l_exists := TRUE;
285: exit;
286: end loop;
287: IF NOT l_exists THEN
288: hr_utility.set_message(8301, 'GHR_38809_EXEMP_AWD_INV_NOA');
289: hr_utility.raise_error;
290: ELSE
291: IF l_exemp_award_date < l_asg_end_date THEN
292: hr_utility.set_message(8301, 'GHR_38807_EXEMP_AWD_EQUAL_SEP');

Line 289: hr_utility.raise_error;

285: exit;
286: end loop;
287: IF NOT l_exists THEN
288: hr_utility.set_message(8301, 'GHR_38809_EXEMP_AWD_INV_NOA');
289: hr_utility.raise_error;
290: ELSE
291: IF l_exemp_award_date < l_asg_end_date THEN
292: hr_utility.set_message(8301, 'GHR_38807_EXEMP_AWD_EQUAL_SEP');
293: hr_utility.raise_error;

Line 292: hr_utility.set_message(8301, 'GHR_38807_EXEMP_AWD_EQUAL_SEP');

288: hr_utility.set_message(8301, 'GHR_38809_EXEMP_AWD_INV_NOA');
289: hr_utility.raise_error;
290: ELSE
291: IF l_exemp_award_date < l_asg_end_date THEN
292: hr_utility.set_message(8301, 'GHR_38807_EXEMP_AWD_EQUAL_SEP');
293: hr_utility.raise_error;
294: END IF;
295: END IF;
296: END IF;

Line 293: hr_utility.raise_error;

289: hr_utility.raise_error;
290: ELSE
291: IF l_exemp_award_date < l_asg_end_date THEN
292: hr_utility.set_message(8301, 'GHR_38807_EXEMP_AWD_EQUAL_SEP');
293: hr_utility.raise_error;
294: END IF;
295: END IF;
296: END IF;
297:

Line 311: hr_utility.set_location('Entering:'||l_proc, 1);

307: -- (underscores) left in the description then we are missing insertion values
308: -- It does not directly check what segments are defined for a given NOAC/LAC and then check
309: -- if those segments have been entered. Hence this solution is a bit crude but it is quick!
310: --
311: hr_utility.set_location('Entering:'||l_proc, 1);
312: --
313: IF p_pa_requests_type.first_noa_desc IS NOT NULL THEN
314: IF INSTR(p_pa_requests_type.first_noa_desc,'__') <> 0 THEN
315: hr_utility.set_message(8301,'GHR_38238_1ST_NOA_INSERT_REQD');

Line 315: hr_utility.set_message(8301,'GHR_38238_1ST_NOA_INSERT_REQD');

311: hr_utility.set_location('Entering:'||l_proc, 1);
312: --
313: IF p_pa_requests_type.first_noa_desc IS NOT NULL THEN
314: IF INSTR(p_pa_requests_type.first_noa_desc,'__') <> 0 THEN
315: hr_utility.set_message(8301,'GHR_38238_1ST_NOA_INSERT_REQD');
316: hr_utility.raise_error;
317: END IF;
318: END IF;
319: --

Line 316: hr_utility.raise_error;

312: --
313: IF p_pa_requests_type.first_noa_desc IS NOT NULL THEN
314: IF INSTR(p_pa_requests_type.first_noa_desc,'__') <> 0 THEN
315: hr_utility.set_message(8301,'GHR_38238_1ST_NOA_INSERT_REQD');
316: hr_utility.raise_error;
317: END IF;
318: END IF;
319: --
320: IF p_pa_requests_type.first_action_la_desc1 IS NOT NULL THEN

Line 322: hr_utility.set_message(8301,'GHR_38239_1ST_LA1_INSERT_REQD');

318: END IF;
319: --
320: IF p_pa_requests_type.first_action_la_desc1 IS NOT NULL THEN
321: IF INSTR(p_pa_requests_type.first_action_la_desc1,'__') <> 0 THEN
322: hr_utility.set_message(8301,'GHR_38239_1ST_LA1_INSERT_REQD');
323: hr_utility.raise_error;
324: END IF;
325: END IF;
326: --

Line 323: hr_utility.raise_error;

319: --
320: IF p_pa_requests_type.first_action_la_desc1 IS NOT NULL THEN
321: IF INSTR(p_pa_requests_type.first_action_la_desc1,'__') <> 0 THEN
322: hr_utility.set_message(8301,'GHR_38239_1ST_LA1_INSERT_REQD');
323: hr_utility.raise_error;
324: END IF;
325: END IF;
326: --
327: IF p_pa_requests_type.first_action_la_desc2 IS NOT NULL THEN

Line 329: hr_utility.set_message(8301,'GHR_38240_1ST_LA2_INSERT_REQD');

325: END IF;
326: --
327: IF p_pa_requests_type.first_action_la_desc2 IS NOT NULL THEN
328: IF INSTR(p_pa_requests_type.first_action_la_desc2,'__') <> 0 THEN
329: hr_utility.set_message(8301,'GHR_38240_1ST_LA2_INSERT_REQD');
330: hr_utility.raise_error;
331: END IF;
332: END IF;
333: --

Line 330: hr_utility.raise_error;

326: --
327: IF p_pa_requests_type.first_action_la_desc2 IS NOT NULL THEN
328: IF INSTR(p_pa_requests_type.first_action_la_desc2,'__') <> 0 THEN
329: hr_utility.set_message(8301,'GHR_38240_1ST_LA2_INSERT_REQD');
330: hr_utility.raise_error;
331: END IF;
332: END IF;
333: --
334: IF p_pa_requests_type.second_noa_desc IS NOT NULL THEN

Line 336: hr_utility.set_message(8301,'GHR_38241_2ND_NOA_INSERT_REQD');

332: END IF;
333: --
334: IF p_pa_requests_type.second_noa_desc IS NOT NULL THEN
335: IF INSTR(p_pa_requests_type.second_noa_desc,'__') <> 0 THEN
336: hr_utility.set_message(8301,'GHR_38241_2ND_NOA_INSERT_REQD');
337: hr_utility.raise_error;
338: END IF;
339: END IF;
340: --

Line 337: hr_utility.raise_error;

333: --
334: IF p_pa_requests_type.second_noa_desc IS NOT NULL THEN
335: IF INSTR(p_pa_requests_type.second_noa_desc,'__') <> 0 THEN
336: hr_utility.set_message(8301,'GHR_38241_2ND_NOA_INSERT_REQD');
337: hr_utility.raise_error;
338: END IF;
339: END IF;
340: --
341: IF p_pa_requests_type.second_action_la_desc1 IS NOT NULL THEN

Line 343: hr_utility.set_message(8301,'GHR_38242_2ND_LA1_INSERT_REQD');

339: END IF;
340: --
341: IF p_pa_requests_type.second_action_la_desc1 IS NOT NULL THEN
342: IF INSTR(p_pa_requests_type.second_action_la_desc1,'__') <> 0 THEN
343: hr_utility.set_message(8301,'GHR_38242_2ND_LA1_INSERT_REQD');
344: hr_utility.raise_error;
345: END IF;
346: END IF;
347: --

Line 344: hr_utility.raise_error;

340: --
341: IF p_pa_requests_type.second_action_la_desc1 IS NOT NULL THEN
342: IF INSTR(p_pa_requests_type.second_action_la_desc1,'__') <> 0 THEN
343: hr_utility.set_message(8301,'GHR_38242_2ND_LA1_INSERT_REQD');
344: hr_utility.raise_error;
345: END IF;
346: END IF;
347: --
348: IF p_pa_requests_type.second_action_la_desc2 IS NOT NULL THEN

Line 350: hr_utility.set_message(8301,'GHR_38243_2ND_LA2_INSERT_REQD');

346: END IF;
347: --
348: IF p_pa_requests_type.second_action_la_desc2 IS NOT NULL THEN
349: IF INSTR(p_pa_requests_type.second_action_la_desc2,'__') <> 0 THEN
350: hr_utility.set_message(8301,'GHR_38243_2ND_LA2_INSERT_REQD');
351: hr_utility.raise_error;
352: END IF;
353: END IF;
354: --

Line 351: hr_utility.raise_error;

347: --
348: IF p_pa_requests_type.second_action_la_desc2 IS NOT NULL THEN
349: IF INSTR(p_pa_requests_type.second_action_la_desc2,'__') <> 0 THEN
350: hr_utility.set_message(8301,'GHR_38243_2ND_LA2_INSERT_REQD');
351: hr_utility.raise_error;
352: END IF;
353: END IF;
354: --
355: hr_utility.set_location('Leaving:'||l_proc, 40);

Line 355: hr_utility.set_location('Leaving:'||l_proc, 40);

351: hr_utility.raise_error;
352: END IF;
353: END IF;
354: --
355: hr_utility.set_location('Leaving:'||l_proc, 40);
356: --
357: END check_insertion_values;
358: --
359: PROCEDURE main_validation(p_pa_requests_type IN ghr_pa_requests%ROWTYPE

Line 388: hr_utility.set_location('Entering:'||l_proc, 1);

384: ,p_per_scd_info_type IN ghr_api.per_scd_info_type
385: ) IS
386: l_proc varchar2(72) := g_package||'main_validation';
387: BEGIN
388: hr_utility.set_location('Entering:'||l_proc, 1);
389: --
390: set_structure('PA_REQUESTS_TYPE');
391: set_column('ACADEMIC_DISCIPLINE', p_pa_requests_type.academic_discipline);
392: set_column('ADITIONAL_INFO_PERSON_ID', p_pa_requests_type.additional_info_person_id);

Line 426: hr_utility.set_location('effe date ....'||to_char(p_pa_requests_type.effective_date,'DD/MM/YYYY'),9999);

422: set_column('FEGLI_DESC', p_pa_requests_type.fegli_desc);
423: -- Start Bug 1379280
424: -- Assigning hr_api.g_varchar2 to First Legal Authority fields
425:
426: hr_utility.set_location('effe date ....'||to_char(p_pa_requests_type.effective_date,'DD/MM/YYYY'),9999);
427:
428: -- to avoid getting required error message for NOACs 840-847,849
429: if (p_pa_requests_type.first_noa_code in ('840','841','842','843',
430: '844','845','846','847','848',

Line 553: hr_utility.set_location('Input Pay Rate Determinant ' || p_pa_requests_type.input_pay_rate_determinant, 99999);

549: set_structure('PER_RETAINED_GRADE_TYPE');
550:
551: IF NOT ( p_pa_requests_type.first_noa_code = '890' AND
552: p_pa_requests_type.input_pay_rate_determinant in ('A','B','E','F','U','V') ) THEN
553: hr_utility.set_location('Input Pay Rate Determinant ' || p_pa_requests_type.input_pay_rate_determinant, 99999);
554: hr_utility.set_location('First Noa Code ' || p_pa_requests_type.first_noa_code, 99999);
555: set_column('DATE_FROM', hr_api.g_date);
556: set_column('DATE_TO', hr_api.g_date);
557: set_column('RETAIN_GRADE', hr_api.g_varchar2);

Line 554: hr_utility.set_location('First Noa Code ' || p_pa_requests_type.first_noa_code, 99999);

550:
551: IF NOT ( p_pa_requests_type.first_noa_code = '890' AND
552: p_pa_requests_type.input_pay_rate_determinant in ('A','B','E','F','U','V') ) THEN
553: hr_utility.set_location('Input Pay Rate Determinant ' || p_pa_requests_type.input_pay_rate_determinant, 99999);
554: hr_utility.set_location('First Noa Code ' || p_pa_requests_type.first_noa_code, 99999);
555: set_column('DATE_FROM', hr_api.g_date);
556: set_column('DATE_TO', hr_api.g_date);
557: set_column('RETAIN_GRADE', hr_api.g_varchar2);
558: set_column('RETAIN_STEP_OR_RATE', hr_api.g_varchar2);

Line 704: hr_utility.set_location(l_proc, 10);

700: ,p_per_scd_info_type
701: );
702:
703: --
704: hr_utility.set_location(l_proc, 10);
705: --
706: check_insertion_values(p_pa_requests_type);
707: --
708: hr_utility.set_location('Leaving:'||l_proc, 40);

Line 708: hr_utility.set_location('Leaving:'||l_proc, 40);

704: hr_utility.set_location(l_proc, 10);
705: --
706: check_insertion_values(p_pa_requests_type);
707: --
708: hr_utility.set_location('Leaving:'||l_proc, 40);
709: --
710: END main_validation;
711:
712: --