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.PER_GRADE_SPINES_PKG dependencies on HR_UTILITY

Line 160: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

156: ceiling_step_id = X_Ceiling_Step_Id
157: WHERE rowid = chartorowid(X_rowid);
158:
159: if (SQL%NOTFOUND) then
160: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
161: hr_utility.set_message_token('PROCEDURE','update_row');
162: hr_utility.set_message_token('STEP','1');
163: hr_utility.raise_error;
164: end if;

Line 161: hr_utility.set_message_token('PROCEDURE','update_row');

157: WHERE rowid = chartorowid(X_rowid);
158:
159: if (SQL%NOTFOUND) then
160: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
161: hr_utility.set_message_token('PROCEDURE','update_row');
162: hr_utility.set_message_token('STEP','1');
163: hr_utility.raise_error;
164: end if;
165:

Line 162: hr_utility.set_message_token('STEP','1');

158:
159: if (SQL%NOTFOUND) then
160: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
161: hr_utility.set_message_token('PROCEDURE','update_row');
162: hr_utility.set_message_token('STEP','1');
163: hr_utility.raise_error;
164: end if;
165:
166: END Update_Row;

Line 163: hr_utility.raise_error;

159: if (SQL%NOTFOUND) then
160: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
161: hr_utility.set_message_token('PROCEDURE','update_row');
162: hr_utility.set_message_token('STEP','1');
163: hr_utility.raise_error;
164: end if;
165:
166: END Update_Row;
167:

Line 198: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

194: DELETE FROM per_grade_spines_f
195: WHERE rowid = chartorowid(X_Rowid);
196:
197: if (SQL%NOTFOUND) then
198: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
199: hr_utility.set_message_token('PROCEDURE','delete_row');
200: hr_utility.set_message_token('STEP','1');
201: hr_utility.raise_error;
202: end if;

Line 199: hr_utility.set_message_token('PROCEDURE','delete_row');

195: WHERE rowid = chartorowid(X_Rowid);
196:
197: if (SQL%NOTFOUND) then
198: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
199: hr_utility.set_message_token('PROCEDURE','delete_row');
200: hr_utility.set_message_token('STEP','1');
201: hr_utility.raise_error;
202: end if;
203: END Delete_Row;

Line 200: hr_utility.set_message_token('STEP','1');

196:
197: if (SQL%NOTFOUND) then
198: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
199: hr_utility.set_message_token('PROCEDURE','delete_row');
200: hr_utility.set_message_token('STEP','1');
201: hr_utility.raise_error;
202: end if;
203: END Delete_Row;
204:

Line 201: hr_utility.raise_error;

197: if (SQL%NOTFOUND) then
198: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
199: hr_utility.set_message_token('PROCEDURE','delete_row');
200: hr_utility.set_message_token('STEP','1');
201: hr_utility.raise_error;
202: end if;
203: END Delete_Row;
204:
205:

Line 239: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',1);

235: and a.special_ceiling_step_id is not null);
236: --
237: begin
238: --
239: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',1);
240: --
241: open c1;
242: --
243: fetch c1 into l_exists1;

Line 245: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');

241: open c1;
242: --
243: fetch c1 into l_exists1;
244: IF c1%found THEN
245: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');
246: close c1;
247: hr_utility.raise_error;
248: END IF;
249: --

Line 247: hr_utility.raise_error;

243: fetch c1 into l_exists1;
244: IF c1%found THEN
245: hr_utility.set_message(801, 'PER_7933_DEL_GRDSPN_PLACE');
246: close c1;
247: hr_utility.raise_error;
248: END IF;
249: --
250: close c1;
251: --

Line 252: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',2);

248: END IF;
249: --
250: close c1;
251: --
252: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',2);
253: --
254: open c2;
255: --
256: fetch c2 into l_exists2;

Line 258: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');

254: open c2;
255: --
256: fetch c2 into l_exists2;
257: IF c2%found THEN
258: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');
259: close c2;
260: hr_utility.raise_error;
261: END IF;
262: --

Line 260: hr_utility.raise_error;

256: fetch c2 into l_exists2;
257: IF c2%found THEN
258: hr_utility.set_message(801, 'PER_7934_DEL_GRDSPN_ASS');
259: close c2;
260: hr_utility.raise_error;
261: END IF;
262: --
263: close c2;
264: --

Line 281: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',1);

277: and p_sess between effective_start_date and effective_end_date;
278: --
279: begin
280: --
281: hr_utility.set_location('per_grade_spines_pkg.stb_del_validation',1);
282: --
283: open c3;
284: --
285: fetch c3 into l_exists;

Line 287: hr_utility.set_message(801, 'PER_7932_GRDSPN_GRD_EXISTS');

283: open c3;
284: --
285: fetch c3 into l_exists;
286: IF c3%found THEN
287: hr_utility.set_message(801, 'PER_7932_GRDSPN_GRD_EXISTS');
288: close c3;
289: hr_utility.raise_error;
290: END IF;
291: --

Line 289: hr_utility.raise_error;

285: fetch c3 into l_exists;
286: IF c3%found THEN
287: hr_utility.set_message(801, 'PER_7932_GRDSPN_GRD_EXISTS');
288: close c3;
289: hr_utility.raise_error;
290: END IF;
291: --
292: close c3;
293: --

Line 394: hr_utility.set_location('Entering:' ||l_proc, 10);

390:
391:
392: begin
393:
394: hr_utility.set_location('Entering:' ||l_proc, 10);
395:
396: insert into per_spinal_point_steps_f(
397: step_id,
398: grade_spine_id,

Line 427: hr_utility.set_location(l_proc, 20);

423: p_creation_date,
424: p_information_category,
425: p_object_version_number);
426:
427: hr_utility.set_location(l_proc, 20);
428:
429: --
430: -- Need to create option and option in plan for Benefit
431: --

Line 437: hr_utility.set_location(l_proc, 30);

433: open csr_get_names;
434: fetch csr_get_names into l_pay_scale_name,l_spinal_point_name,l_grade_id;
435: if csr_get_names%notfound then
436: close csr_get_names;
437: hr_utility.set_location(l_proc, 30);
438: else
439: /* Comment out for BUG3179239
440: l_return := pqh_gsp_sync_compensation_obj.create_option_for_point
441: (p_spinal_point_id => p_spinal_point_id

Line 446: hr_utility.trace('pqh_gsp_sync_compensation_obj.create_option_for_point : '

442: ,p_pay_scale_name => l_pay_scale_name
443: ,p_spinal_point_name => l_spinal_point_name
444: );
445: --
446: hr_utility.trace('pqh_gsp_sync_compensation_obj.create_option_for_point : '
447: || l_return);
448: --
449: if l_return <> 'SUCCESS' Then
450: l_message := fnd_message.get;

Line 451: hr_utility.trace('error message : ' || l_message);

447: || l_return);
448: --
449: if l_return <> 'SUCCESS' Then
450: l_message := fnd_message.get;
451: hr_utility.trace('error message : ' || l_message);
452: fnd_message.set_name('PER','HR_289527_CRE_OPTION_FOR_POINT');
453: if l_message is not null then
454: fnd_message.set_token('ERR_CODE',l_message);
455: else

Line 471: hr_utility.trace('pqh_gsp_sync_compensation_obj.oipl_for_step : '

467: ,p_effective_date => p_effective_date
468: ,p_datetrack_mode => 'INSERT'
469: );
470: --
471: hr_utility.trace('pqh_gsp_sync_compensation_obj.oipl_for_step : '
472: || l_return);
473: --
474: if l_return <> 'SUCCESS' Then
475: l_message := fnd_message.get;

Line 476: hr_utility.trace('error message : ' || l_message);

472: || l_return);
473: --
474: if l_return <> 'SUCCESS' Then
475: l_message := fnd_message.get;
476: hr_utility.trace('error message : ' || l_message);
477: fnd_message.set_name('PER','HR_289528_CRE_OPTION_IN_PLAN');
478: if l_message is not null then
479: fnd_message.set_token('ERR_CODE',l_message);
480: else

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

484: fnd_message.raise_error;
485: End if;
486:
487: end if;
488: hr_utility.set_location(' Leaving:' || l_proc, 40);
489: --
490: end first_step_api;
491:
492:

Line 521: hr_utility.set_location('per_grade_spines_pkg.chk_low_ceiling',1);

517: and s.sequence > p_new_ceil);
518: --
519: begin
520: --
521: hr_utility.set_location('per_grade_spines_pkg.chk_low_ceiling',1);
522: --
523: open c5;
524: --
525: fetch c5 into l_exists;

Line 527: hr_utility.set_message(801, 'PER_7935_CEIL_PLACE_HIGH_EXIST');

523: open c5;
524: --
525: fetch c5 into l_exists;
526: IF c5%found THEN
527: hr_utility.set_message(801, 'PER_7935_CEIL_PLACE_HIGH_EXIST');
528: close c5;
529: hr_utility.raise_error;
530: END IF;
531: --

Line 529: hr_utility.raise_error;

525: fetch c5 into l_exists;
526: IF c5%found THEN
527: hr_utility.set_message(801, 'PER_7935_CEIL_PLACE_HIGH_EXIST');
528: close c5;
529: hr_utility.raise_error;
530: END IF;
531: --
532: close c5;
533: --

Line 556: hr_utility.set_location('per_grade_spines_pkg.zap_placement',1);

552: -- the point in time where the grade spine is being ended.
553: --
554: begin
555: --
556: hr_utility.set_location('per_grade_spines_pkg.zap_placement',1);
557: --
558: delete from per_spinal_point_placements_f
559: where placement_id = p_placement_id
560: and step_id = p_step_id

Line 563: hr_utility.set_location('per_grade_spines_pkg.zap_placement',2);

559: where placement_id = p_placement_id
560: and step_id = p_step_id
561: and effective_start_date = p_eff_start_date;
562: --
563: hr_utility.set_location('per_grade_spines_pkg.zap_placement',2);
564: --
565: end zap_placement;
566:
567:

Line 578: hr_utility.set_location('per_grade_spines_pkg.update_placement',1);

574: -- EED to the date the grade spine is being ended/opened up until.
575: --
576: begin
577: --
578: hr_utility.set_location('per_grade_spines_pkg.update_placement',1);
579: --
580: update per_spinal_point_placements_f
581: set effective_end_date = p_newdate
582: where placement_id = p_placement_id

Line 586: hr_utility.set_location('per_grade_spines_pkg.update_placement',2);

582: where placement_id = p_placement_id
583: and step_id = p_step_id
584: and effective_start_date = p_eff_start_date;
585: --
586: hr_utility.set_location('per_grade_spines_pkg.update_placement',2);
587: --
588: end update_placement;
589:
590:

Line 600: hr_utility.set_location('per_grade_spines_pkg.zap_step',1);

596: -- point in time where the grade spine is being ended.
597: --
598: begin
599: --
600: hr_utility.set_location('per_grade_spines_pkg.zap_step',1);
601: --
602: delete from per_spinal_point_steps_f
603: where step_id = p_step_id
604: and grade_spine_id = p_grade_spine_id

Line 607: hr_utility.set_location('per_grade_spines_pkg.zap_step',2);

603: where step_id = p_step_id
604: and grade_spine_id = p_grade_spine_id
605: and effective_start_date = p_eff_start_date;
606: --
607: hr_utility.set_location('per_grade_spines_pkg.zap_step',2);
608: --
609: end zap_step;
610:
611:

Line 622: hr_utility.set_location('per_grade_spines_pkg.update_step',1);

618: -- to the date the grade spine is being ended/opened up until.
619: --
620: begin
621: --
622: hr_utility.set_location('per_grade_spines_pkg.update_step',1);
623: --
624: update per_spinal_point_steps_f
625: set effective_end_date = p_newdate
626: where step_id = p_step_id

Line 630: hr_utility.set_location('per_grade_spines_pkg.update_step',2);

626: where step_id = p_step_id
627: and grade_spine_id = p_grade_spine_id
628: and effective_start_date = p_eff_start_date;
629: --
630: hr_utility.set_location('per_grade_spines_pkg.update_step',2);
631: --
632: end update_step;
633:
634:

Line 656: hr_utility.set_location('per_grade_spines_pkg.get_gspine_end',1);

652: and grade_spine_id <> p_gspine_id;
653: --
654: begin
655: --
656: hr_utility.set_location('per_grade_spines_pkg.get_gspine_end',1);
657: --
658: open get_end;
659: --
660: fetch get_end into p_gspine_opento_date;

Line 668: hr_utility.set_location('per_grade_spines_pkg.get_gspine_end',2);

664: IF p_gspine_opento_date is null THEN
665: p_gspine_opento_date := l_end_of_time;
666: END IF;
667: --
668: hr_utility.set_location('per_grade_spines_pkg.get_gspine_end',2);
669: --
670: end get_gspine_end;
671:
672:

Line 721: hr_utility.set_location('per_grade_spines_pkg.close_gspine',1);

717: --
718: --
719: begin
720: --
721: hr_utility.set_location('per_grade_spines_pkg.close_gspine',1);
722: --
723: open check_ass;
724: --
725: fetch check_ass into l_exists;

Line 727: hr_utility.set_message(801,'PER_7939_DEL_STEP_ASS');

723: open check_ass;
724: --
725: fetch check_ass into l_exists;
726: IF check_ass%found THEN
727: hr_utility.set_message(801,'PER_7939_DEL_STEP_ASS');
728: close check_ass;
729: hr_utility.raise_error;
730: END IF;
731: --

Line 729: hr_utility.raise_error;

725: fetch check_ass into l_exists;
726: IF check_ass%found THEN
727: hr_utility.set_message(801,'PER_7939_DEL_STEP_ASS');
728: close check_ass;
729: hr_utility.raise_error;
730: END IF;
731: --
732: close check_ass;
733: --

Line 734: hr_utility.set_location('per_grade_spines_pkg.close_gspine',2);

730: END IF;
731: --
732: close check_ass;
733: --
734: hr_utility.set_location('per_grade_spines_pkg.close_gspine',2);
735: --
736: open get_steps;
737: --
738: LOOP

Line 749: hr_utility.set_location('per_grade_spines_pkg.close_gspine',3);

745: exit when get_steps%notfound;
746: IF p_sess < l_stp_eff_end THEN
747: --
748: --
749: hr_utility.set_location('per_grade_spines_pkg.close_gspine',3);
750: --
751: open get_plcmnts(l_step_id);
752: --
753: -- delete/update the placement records.

Line 870: hr_utility.set_location('per_grade_spines_pkg.open_gspine',1);

866: --
867: --
868: begin
869: --
870: hr_utility.set_location('per_grade_spines_pkg.open_gspine',1);
871: --
872: open check_notceilchng;
873: --
874: fetch check_notceilchng into l_exists;

Line 878: hr_utility.set_location('per_grade_spines_pkg.open_gspine',2);

874: fetch check_notceilchng into l_exists;
875: IF check_notceilchng%notfound THEN
876: close check_notceilchng;
877: --
878: hr_utility.set_location('per_grade_spines_pkg.open_gspine',2);
879: --
880: per_grade_spines_pkg.get_gspine_end(p_gspine_id,
881: p_grade_id,
882: p_eff_end_date,

Line 887: hr_utility.set_location('per_grade_spines_pkg.open_gspine',3);

883: l_gspine_opento_date);
884: --
885: l_stp_opento_date := nvl(l_gspine_opento_date,l_eot);
886: --
887: hr_utility.set_location('per_grade_spines_pkg.open_gspine',3);
888: --
889: FOR steps IN get_steps LOOP
890: --
891: -- re-open step records for grade spine

Line 896: hr_utility.set_location('per_grade_spines_pkg.open_gspine',4);

892: --
893: l_step_id := steps.step_id;
894: l_stp_eff_start := steps.effective_start_date;
895: --
896: hr_utility.set_location('per_grade_spines_pkg.open_gspine',4);
897: --
898: FOR placements IN get_placements(l_step_id) LOOP
899: --
900: -- re-open placement records for each step re-opened

Line 907: hr_utility.set_location('per_grade_spines_pkg.open_gspine',5);

903: l_plc_eff_start := placements.effective_start_date;
904: --
905: -- check if assignment has been ended
906: --
907: hr_utility.set_location('per_grade_spines_pkg.open_gspine',5);
908: --
909: open get_assend(l_plcmnt_id);
910: fetch get_assend into l_ass_maxend;
911: close get_assend;

Line 915: hr_utility.set_location('per_grade_spines_pkg.open_gspine',6);

911: close get_assend;
912: --
913: -- check if assignments grade has been changed
914: --
915: hr_utility.set_location('per_grade_spines_pkg.open_gspine',6);
916: --
917: open get_plcdate(l_plcmnt_id,
918: p_grade_id,
919: l_plc_eff_start);