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

Line 18: hr_utility.set_location('per_spinal_pt_plcmt_pkg.check_ass_end',1);

14: and a.grade_id <> p_grd_id;
15: --
16: begin
17: --
18: hr_utility.set_location('per_spinal_pt_plcmt_pkg.check_ass_end',1);
19: --
20: open c20;
21: --
22: fetch c20 into l_exists;

Line 24: hr_utility.set_message(801,'HR_51770_GRD_PLC_ASS_EXIST');

20: open c20;
21: --
22: fetch c20 into l_exists;
23: IF c20%found THEN
24: hr_utility.set_message(801,'HR_51770_GRD_PLC_ASS_EXIST');
25: close c20;
26: hr_utility.raise_error;
27: END IF;
28: --

Line 26: hr_utility.raise_error;

22: fetch c20 into l_exists;
23: IF c20%found THEN
24: hr_utility.set_message(801,'HR_51770_GRD_PLC_ASS_EXIST');
25: close c20;
26: hr_utility.raise_error;
27: END IF;
28: --
29: close c20;
30: --

Line 48: hr_utility.set_location('per_spinal_pt_plcmt_pkg.b_delete_valid',1);

44: and effective_start_date > p_eed;
45: --
46: begin
47: --
48: hr_utility.set_location('per_spinal_pt_plcmt_pkg.b_delete_valid',1);
49: --
50: open c1;
51: --
52: fetch c1 into l_exists;

Line 54: hr_utility.set_message(801, 'PER_7929_SP_PLACE_FUT_EXISTS');

50: open c1;
51: --
52: fetch c1 into l_exists;
53: IF c1%found THEN
54: hr_utility.set_message(801, 'PER_7929_SP_PLACE_FUT_EXISTS');
55: close c1;
56: hr_utility.raise_error;
57: END IF;
58: --

Line 56: hr_utility.raise_error;

52: fetch c1 into l_exists;
53: IF c1%found THEN
54: hr_utility.set_message(801, 'PER_7929_SP_PLACE_FUT_EXISTS');
55: close c1;
56: hr_utility.raise_error;
57: END IF;
58: --
59: close c1;
60: --

Line 99: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_flds',1);

95: --
96: l_count NUMBER;
97: begin
98: --
99: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_flds',1);
100: --
101: open c2;
102: --
103: fetch c2 into p_step_dsc,

Line 112: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_flds',2);

108:
109: --
110:
111: --
112: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_flds',2);
113: --
114: open c21;
115: --
116: fetch c21 into p_rsn_desc;

Line 136: hr_utility.set_location('per_spinal_pt_plcmt_pkg.chk_exist',1);

132: and effective_end_date >= p_sess;
133: --
134: begin
135: --
136: hr_utility.set_location('per_spinal_pt_plcmt_pkg.chk_exist',1);
137: --
138: open c3;
139: --
140: fetch c3 into l_exists;

Line 142: hr_utility.set_message(801, 'PER_7928_SP_PLACE_EXISTS');

138: open c3;
139: --
140: fetch c3 into l_exists;
141: IF c3%found THEN
142: hr_utility.set_message(801, 'PER_7928_SP_PLACE_EXISTS');
143: close c3;
144: hr_utility.raise_error;
145: END IF;
146: --

Line 144: hr_utility.raise_error;

140: fetch c3 into l_exists;
141: IF c3%found THEN
142: hr_utility.set_message(801, 'PER_7928_SP_PLACE_EXISTS');
143: close c3;
144: hr_utility.raise_error;
145: END IF;
146: --
147: close c3;
148: --

Line 578: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',1);

574: --
575: l_ceil_step NUMBER;
576: begin
577: --
578: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',1);
579: --
580: open c5;
581: --
582: fetch c5 into p_ass_eed,

Line 592: hr_utility.set_message(801, 'HR_7112_WFLOW_ASSGT_NO_PLAC');

588: p_ceil_seq,
589: p_grd_ldr_name;
590: --
591: IF c5%notfound AND upper(p_check) = 'Y' THEN
592: hr_utility.set_message(801, 'HR_7112_WFLOW_ASSGT_NO_PLAC');
593: close c5;
594: hr_utility.raise_error;
595: END IF;
596: --

Line 594: hr_utility.raise_error;

590: --
591: IF c5%notfound AND upper(p_check) = 'Y' THEN
592: hr_utility.set_message(801, 'HR_7112_WFLOW_ASSGT_NO_PLAC');
593: close c5;
594: hr_utility.raise_error;
595: END IF;
596: --
597: close c5;
598: --

Line 599: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',2);

595: END IF;
596: --
597: close c5;
598: --
599: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',2);
600: --
601: open c6;
602: --
603: fetch c6 into p_ceil_step;

Line 608: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',3);

604: --
605: close c6;
606:
607: --
608: hr_utility.set_location('per_spinal_pt_plcmt_pkg.pop_ctrl',3);
609: --
610: open c7;
611: --
612: fetch c7 into p_inc_def;

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

647: --
648: fetch c_derive_info into l_bgroup_id,
649: l_sess;
650: IF c_derive_info%notfound THEN
651: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
652: hr_utility.set_message_token('PROCEDURE',l_proc);
653: hr_utility.set_message_token('STEP','1');
654: hr_utility.raise_error;
655: close c_derive_info;

Line 652: hr_utility.set_message_token('PROCEDURE',l_proc);

648: fetch c_derive_info into l_bgroup_id,
649: l_sess;
650: IF c_derive_info%notfound THEN
651: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
652: hr_utility.set_message_token('PROCEDURE',l_proc);
653: hr_utility.set_message_token('STEP','1');
654: hr_utility.raise_error;
655: close c_derive_info;
656: END IF;

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

649: l_sess;
650: IF c_derive_info%notfound THEN
651: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
652: hr_utility.set_message_token('PROCEDURE',l_proc);
653: hr_utility.set_message_token('STEP','1');
654: hr_utility.raise_error;
655: close c_derive_info;
656: END IF;
657: --

Line 654: hr_utility.raise_error;

650: IF c_derive_info%notfound THEN
651: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
652: hr_utility.set_message_token('PROCEDURE',l_proc);
653: hr_utility.set_message_token('STEP','1');
654: hr_utility.raise_error;
655: close c_derive_info;
656: END IF;
657: --
658: close c_derive_info;