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

Line 48: hr_utility.set_message(801,'HR_6012_ROW_INSERTED');

44: fetch csr_p into l_dummy;
45: l_bool := csr_p%found;
46: close csr_p;
47: if l_bool then
48: hr_utility.set_message(801,'HR_6012_ROW_INSERTED');
49: hr_utility.raise_error;
50: end if;
51:
52: end Check_Unique_Row;

Line 49: hr_utility.raise_error;

45: l_bool := csr_p%found;
46: close csr_p;
47: if l_bool then
48: hr_utility.set_message(801,'HR_6012_ROW_INSERTED');
49: hr_utility.raise_error;
50: end if;
51:
52: end Check_Unique_Row;
53:

Line 72: hr_utility.set_message(801,'PER_7415_POS_EXISTS');

68: fetch csr_pd into l_dummy;
69: l_bool := csr_pd%found;
70: close csr_pd;
71: if l_bool then
72: hr_utility.set_message(801,'PER_7415_POS_EXISTS');
73: hr_utility.raise_error;
74: end if;
75:
76: end Check_Descriptor;

Line 73: hr_utility.raise_error;

69: l_bool := csr_pd%found;
70: close csr_pd;
71: if l_bool then
72: hr_utility.set_message(801,'PER_7415_POS_EXISTS');
73: hr_utility.raise_error;
74: end if;
75:
76: end Check_Descriptor;
77:

Line 104: hr_utility.set_message(801,'PER_7417_POS_ASSIGNMENT');

100: exception when no_data_found then
101: null;
102: end;
103: if l_exists = '1' then
104: hr_utility.set_message(801,'PER_7417_POS_ASSIGNMENT');
105: hr_utility.raise_error;
106: end if;
107:
108: l_exists := NULL;

Line 105: hr_utility.raise_error;

101: null;
102: end;
103: if l_exists = '1' then
104: hr_utility.set_message(801,'PER_7417_POS_ASSIGNMENT');
105: hr_utility.raise_error;
106: end if;
107:
108: l_exists := NULL;
109:

Line 123: hr_utility.set_message(801,'PER_7863_DEL_POS_LINK');

119: null;
120: end;
121:
122: if l_exists = '1' then
123: hr_utility.set_message(801,'PER_7863_DEL_POS_LINK');
124: hr_utility.set_message_token('FORM','PERWSDPO');
125: hr_utility.set_message_token('BLOCK','PST1');
126: hr_utility.set_message_token('TRIGGER','on-delete');
127: hr_utility.set_message_token('STEP','4');

Line 124: hr_utility.set_message_token('FORM','PERWSDPO');

120: end;
121:
122: if l_exists = '1' then
123: hr_utility.set_message(801,'PER_7863_DEL_POS_LINK');
124: hr_utility.set_message_token('FORM','PERWSDPO');
125: hr_utility.set_message_token('BLOCK','PST1');
126: hr_utility.set_message_token('TRIGGER','on-delete');
127: hr_utility.set_message_token('STEP','4');
128: hr_utility.raise_error;

Line 125: hr_utility.set_message_token('BLOCK','PST1');

121:
122: if l_exists = '1' then
123: hr_utility.set_message(801,'PER_7863_DEL_POS_LINK');
124: hr_utility.set_message_token('FORM','PERWSDPO');
125: hr_utility.set_message_token('BLOCK','PST1');
126: hr_utility.set_message_token('TRIGGER','on-delete');
127: hr_utility.set_message_token('STEP','4');
128: hr_utility.raise_error;
129: end if;

Line 126: hr_utility.set_message_token('TRIGGER','on-delete');

122: if l_exists = '1' then
123: hr_utility.set_message(801,'PER_7863_DEL_POS_LINK');
124: hr_utility.set_message_token('FORM','PERWSDPO');
125: hr_utility.set_message_token('BLOCK','PST1');
126: hr_utility.set_message_token('TRIGGER','on-delete');
127: hr_utility.set_message_token('STEP','4');
128: hr_utility.raise_error;
129: end if;
130:

Line 127: hr_utility.set_message_token('STEP','4');

123: hr_utility.set_message(801,'PER_7863_DEL_POS_LINK');
124: hr_utility.set_message_token('FORM','PERWSDPO');
125: hr_utility.set_message_token('BLOCK','PST1');
126: hr_utility.set_message_token('TRIGGER','on-delete');
127: hr_utility.set_message_token('STEP','4');
128: hr_utility.raise_error;
129: end if;
130:
131: l_exists := NULL;

Line 128: hr_utility.raise_error;

124: hr_utility.set_message_token('FORM','PERWSDPO');
125: hr_utility.set_message_token('BLOCK','PST1');
126: hr_utility.set_message_token('TRIGGER','on-delete');
127: hr_utility.set_message_token('STEP','4');
128: hr_utility.raise_error;
129: end if;
130:
131: l_exists := NULL;
132:

Line 144: hr_utility.set_message(801,'PER_7862_DEL_POS_BUD');

140: exception when no_data_found then
141: null;
142: end;
143: if l_exists = '1' then
144: hr_utility.set_message(801,'PER_7862_DEL_POS_BUD');
145: hr_utility.set_message_token('FORM','PERWSDPO');
146: hr_utility.set_message_token('BLOCK','PST1');
147: hr_utility.set_message_token('TRIGGER','on-delete');
148: hr_utility.set_message_token('STEP','6');

Line 145: hr_utility.set_message_token('FORM','PERWSDPO');

141: null;
142: end;
143: if l_exists = '1' then
144: hr_utility.set_message(801,'PER_7862_DEL_POS_BUD');
145: hr_utility.set_message_token('FORM','PERWSDPO');
146: hr_utility.set_message_token('BLOCK','PST1');
147: hr_utility.set_message_token('TRIGGER','on-delete');
148: hr_utility.set_message_token('STEP','6');
149: hr_utility.raise_error;

Line 146: hr_utility.set_message_token('BLOCK','PST1');

142: end;
143: if l_exists = '1' then
144: hr_utility.set_message(801,'PER_7862_DEL_POS_BUD');
145: hr_utility.set_message_token('FORM','PERWSDPO');
146: hr_utility.set_message_token('BLOCK','PST1');
147: hr_utility.set_message_token('TRIGGER','on-delete');
148: hr_utility.set_message_token('STEP','6');
149: hr_utility.raise_error;
150: end if;

Line 147: hr_utility.set_message_token('TRIGGER','on-delete');

143: if l_exists = '1' then
144: hr_utility.set_message(801,'PER_7862_DEL_POS_BUD');
145: hr_utility.set_message_token('FORM','PERWSDPO');
146: hr_utility.set_message_token('BLOCK','PST1');
147: hr_utility.set_message_token('TRIGGER','on-delete');
148: hr_utility.set_message_token('STEP','6');
149: hr_utility.raise_error;
150: end if;
151: l_exists := NULL;

Line 148: hr_utility.set_message_token('STEP','6');

144: hr_utility.set_message(801,'PER_7862_DEL_POS_BUD');
145: hr_utility.set_message_token('FORM','PERWSDPO');
146: hr_utility.set_message_token('BLOCK','PST1');
147: hr_utility.set_message_token('TRIGGER','on-delete');
148: hr_utility.set_message_token('STEP','6');
149: hr_utility.raise_error;
150: end if;
151: l_exists := NULL;
152: begin

Line 149: hr_utility.raise_error;

145: hr_utility.set_message_token('FORM','PERWSDPO');
146: hr_utility.set_message_token('BLOCK','PST1');
147: hr_utility.set_message_token('TRIGGER','on-delete');
148: hr_utility.set_message_token('STEP','6');
149: hr_utility.raise_error;
150: end if;
151: l_exists := NULL;
152: begin
153: select '1'

Line 163: hr_utility.set_message(801,'PER_7861_DEL_POS_REC_ACT');

159: exception when no_data_found then
160: null;
161: end;
162: if l_exists = '1' then
163: hr_utility.set_message(801,'PER_7861_DEL_POS_REC_ACT');
164: hr_utility.set_message_token('FORM','PERWSDPO');
165: hr_utility.set_message_token('BLOCK','PST1');
166: hr_utility.set_message_token('STEP','8');
167: hr_utility.raise_error;

Line 164: hr_utility.set_message_token('FORM','PERWSDPO');

160: null;
161: end;
162: if l_exists = '1' then
163: hr_utility.set_message(801,'PER_7861_DEL_POS_REC_ACT');
164: hr_utility.set_message_token('FORM','PERWSDPO');
165: hr_utility.set_message_token('BLOCK','PST1');
166: hr_utility.set_message_token('STEP','8');
167: hr_utility.raise_error;
168: end if;

Line 165: hr_utility.set_message_token('BLOCK','PST1');

161: end;
162: if l_exists = '1' then
163: hr_utility.set_message(801,'PER_7861_DEL_POS_REC_ACT');
164: hr_utility.set_message_token('FORM','PERWSDPO');
165: hr_utility.set_message_token('BLOCK','PST1');
166: hr_utility.set_message_token('STEP','8');
167: hr_utility.raise_error;
168: end if;
169:

Line 166: hr_utility.set_message_token('STEP','8');

162: if l_exists = '1' then
163: hr_utility.set_message(801,'PER_7861_DEL_POS_REC_ACT');
164: hr_utility.set_message_token('FORM','PERWSDPO');
165: hr_utility.set_message_token('BLOCK','PST1');
166: hr_utility.set_message_token('STEP','8');
167: hr_utility.raise_error;
168: end if;
169:
170: begin

Line 167: hr_utility.raise_error;

163: hr_utility.set_message(801,'PER_7861_DEL_POS_REC_ACT');
164: hr_utility.set_message_token('FORM','PERWSDPO');
165: hr_utility.set_message_token('BLOCK','PST1');
166: hr_utility.set_message_token('STEP','8');
167: hr_utility.raise_error;
168: end if;
169:
170: begin
171: select e.pos_structure_element_id

Line 203: hr_utility.set_message(801,'PER_7416_POS_IN_POS_HIER');

199: null;
200: end;
201:
202: if l_exists = '1' then
203: hr_utility.set_message(801,'PER_7416_POS_IN_POS_HIER');
204: hr_utility.raise_error;
205: end if;
206: end if;
207:

Line 204: hr_utility.raise_error;

200: end;
201:
202: if l_exists = '1' then
203: hr_utility.set_message(801,'PER_7416_POS_IN_POS_HIER');
204: hr_utility.raise_error;
205: end if;
206: end if;
207:
208: l_exists := NULL;

Line 223: hr_utility.set_message(801,'PER_7865_DEF_POS_DEL_GRADE');

219: null;
220: end;
221:
222: if l_exists = '1' then
223: hr_utility.set_message(801,'PER_7865_DEF_POS_DEL_GRADE');
224: hr_utility.raise_error;
225: end if;
226:
227: l_exists := NULL;

Line 224: hr_utility.raise_error;

220: end;
221:
222: if l_exists = '1' then
223: hr_utility.set_message(801,'PER_7865_DEF_POS_DEL_GRADE');
224: hr_utility.raise_error;
225: end if;
226:
227: l_exists := NULL;
228:

Line 241: hr_utility.set_message(801,'PER_7866_DEF_POS_DEL_REQ');

237: null;
238: end;
239:
240: if l_exists = '1' then
241: hr_utility.set_message(801,'PER_7866_DEF_POS_DEL_REQ');
242: hr_utility.raise_error;
243: end if;
244:
245:

Line 242: hr_utility.raise_error;

238: end;
239:
240: if l_exists = '1' then
241: hr_utility.set_message(801,'PER_7866_DEF_POS_DEL_REQ');
242: hr_utility.raise_error;
243: end if;
244:
245:
246: l_exists := NULL;

Line 260: hr_utility.set_message(801,'PER_7867_DEF_POS_DEL_EVAL');

256: null;
257: end;
258:
259: if l_exists = '1' then
260: hr_utility.set_message(801,'PER_7867_DEF_POS_DEL_EVAL');
261: hr_utility.raise_error;
262: end if;
263:
264: l_exists := NULL;

Line 261: hr_utility.raise_error;

257: end;
258:
259: if l_exists = '1' then
260: hr_utility.set_message(801,'PER_7867_DEF_POS_DEL_EVAL');
261: hr_utility.raise_error;
262: end if;
263:
264: l_exists := NULL;
265:

Line 278: hr_utility.set_message(801,'PER_7996_POS_SUCCESSOR_REF');

274: null;
275: end;
276:
277: if l_exists = '1' then
278: hr_utility.set_message(801,'PER_7996_POS_SUCCESSOR_REF');
279: hr_utility.raise_error;
280: end if;
281:
282: l_exists := NULL;

Line 279: hr_utility.raise_error;

275: end;
276:
277: if l_exists = '1' then
278: hr_utility.set_message(801,'PER_7996_POS_SUCCESSOR_REF');
279: hr_utility.raise_error;
280: end if;
281:
282: l_exists := NULL;
283:

Line 296: hr_utility.set_message(801,'PER_7997_POS_RELIEF_REF');

292: null;
293: end;
294:
295: if l_exists = '1' then
296: hr_utility.set_message(801,'PER_7997_POS_RELIEF_REF');
297: hr_utility.raise_error;
298: end if;
299:
300: l_exists := NULL;

Line 297: hr_utility.raise_error;

293: end;
294:
295: if l_exists = '1' then
296: hr_utility.set_message(801,'PER_7997_POS_RELIEF_REF');
297: hr_utility.raise_error;
298: end if;
299:
300: l_exists := NULL;
301:

Line 314: hr_utility.set_message(800,'HR_52776_NOT_DEL_MM_POSITIONS');

310: null;
311: end;
312:
313: if l_exists = '1' then
314: hr_utility.set_message(800,'HR_52776_NOT_DEL_MM_POSITIONS');
315: hr_utility.raise_error;
316: end if;
317:
318: end if;

Line 315: hr_utility.raise_error;

311: end;
312:
313: if l_exists = '1' then
314: hr_utility.set_message(800,'HR_52776_NOT_DEL_MM_POSITIONS');
315: hr_utility.raise_error;
316: end if;
317:
318: end if;
319:

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

527: OPEN C;
528: FETCH C INTO X_Rowid;
529: if (C%NOTFOUND) then
530: CLOSE C;
531: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
532: hr_utility.set_message_token('PROCEDURE','Insert_row');
533: hr_utility.set_message_token('STEP','1');
534: hr_utility.raise_error;
535: end if;

Line 532: hr_utility.set_message_token('PROCEDURE','Insert_row');

528: FETCH C INTO X_Rowid;
529: if (C%NOTFOUND) then
530: CLOSE C;
531: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
532: hr_utility.set_message_token('PROCEDURE','Insert_row');
533: hr_utility.set_message_token('STEP','1');
534: hr_utility.raise_error;
535: end if;
536: CLOSE C;

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

529: if (C%NOTFOUND) then
530: CLOSE C;
531: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
532: hr_utility.set_message_token('PROCEDURE','Insert_row');
533: hr_utility.set_message_token('STEP','1');
534: hr_utility.raise_error;
535: end if;
536: CLOSE C;
537:

Line 534: hr_utility.raise_error;

530: CLOSE C;
531: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
532: hr_utility.set_message_token('PROCEDURE','Insert_row');
533: hr_utility.set_message_token('STEP','1');
534: hr_utility.raise_error;
535: end if;
536: CLOSE C;
537:
538: if X_View_All_Psts <> 'Y' then

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

646: OPEN C;
647: FETCH C INTO Recinfo;
648: if (C%NOTFOUND) then
649: CLOSE C;
650: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
651: hr_utility.set_message_token('PROCEDURE','Lock_row');
652: hr_utility.set_message_token('STEP','1');
653: hr_utility.raise_error;
654: end if;

Line 651: hr_utility.set_message_token('PROCEDURE','Lock_row');

647: FETCH C INTO Recinfo;
648: if (C%NOTFOUND) then
649: CLOSE C;
650: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
651: hr_utility.set_message_token('PROCEDURE','Lock_row');
652: hr_utility.set_message_token('STEP','1');
653: hr_utility.raise_error;
654: end if;
655: CLOSE C;

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

648: if (C%NOTFOUND) then
649: CLOSE C;
650: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
651: hr_utility.set_message_token('PROCEDURE','Lock_row');
652: hr_utility.set_message_token('STEP','1');
653: hr_utility.raise_error;
654: end if;
655: CLOSE C;
656: --

Line 653: hr_utility.raise_error;

649: CLOSE C;
650: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
651: hr_utility.set_message_token('PROCEDURE','Lock_row');
652: hr_utility.set_message_token('STEP','1');
653: hr_utility.raise_error;
654: end if;
655: CLOSE C;
656: --
657: Recinfo.attribute15 := rtrim(Recinfo.attribute15);

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

912: attribute20 = X_Attribute20
913: WHERE rowid = X_rowid;
914:
915: if (SQL%NOTFOUND) then
916: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
917: hr_utility.set_message_token('PROCEDURE','Update_Row');
918: hr_utility.set_message_token('STEP','1');
919: hr_utility.raise_error;
920: end if;

Line 917: hr_utility.set_message_token('PROCEDURE','Update_Row');

913: WHERE rowid = X_rowid;
914:
915: if (SQL%NOTFOUND) then
916: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
917: hr_utility.set_message_token('PROCEDURE','Update_Row');
918: hr_utility.set_message_token('STEP','1');
919: hr_utility.raise_error;
920: end if;
921: */

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

914:
915: if (SQL%NOTFOUND) then
916: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
917: hr_utility.set_message_token('PROCEDURE','Update_Row');
918: hr_utility.set_message_token('STEP','1');
919: hr_utility.raise_error;
920: end if;
921: */
922: END Update_Row;

Line 919: hr_utility.raise_error;

915: if (SQL%NOTFOUND) then
916: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
917: hr_utility.set_message_token('PROCEDURE','Update_Row');
918: hr_utility.set_message_token('STEP','1');
919: hr_utility.raise_error;
920: end if;
921: */
922: END Update_Row;
923:

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

945: DELETE FROM PER_POSITIONS
946: WHERE rowid = X_Rowid;
947:
948: if (SQL%NOTFOUND) then
949: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
950: hr_utility.set_message_token('PROCEDURE','Delete_Row');
951: hr_utility.set_message_token('STEP','1');
952: hr_utility.raise_error;
953: end if;

Line 950: hr_utility.set_message_token('PROCEDURE','Delete_Row');

946: WHERE rowid = X_Rowid;
947:
948: if (SQL%NOTFOUND) then
949: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
950: hr_utility.set_message_token('PROCEDURE','Delete_Row');
951: hr_utility.set_message_token('STEP','1');
952: hr_utility.raise_error;
953: end if;
954: */

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

947:
948: if (SQL%NOTFOUND) then
949: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
950: hr_utility.set_message_token('PROCEDURE','Delete_Row');
951: hr_utility.set_message_token('STEP','1');
952: hr_utility.raise_error;
953: end if;
954: */
955: END Delete_Row;

Line 952: hr_utility.raise_error;

948: if (SQL%NOTFOUND) then
949: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
950: hr_utility.set_message_token('PROCEDURE','Delete_Row');
951: hr_utility.set_message_token('STEP','1');
952: hr_utility.raise_error;
953: end if;
954: */
955: END Delete_Row;
956: --

Line 1028: hr_utility.set_message(801,'PER_7995_POS_GRADE_BEFORE_POS');

1024: THEN
1025: --
1026: -- error and abort
1027: --
1028: hr_utility.set_message(801,'PER_7995_POS_GRADE_BEFORE_POS');
1029: hr_utility.raise_error;
1030: --
1031: END IF;
1032: --

Line 1029: hr_utility.raise_error;

1025: --
1026: -- error and abort
1027: --
1028: hr_utility.set_message(801,'PER_7995_POS_GRADE_BEFORE_POS');
1029: hr_utility.raise_error;
1030: --
1031: END IF;
1032: --
1033: END check_date_effective;

Line 1092: hr_utility.set_location('per_positions_pkg.check_valid_grades', 1);

1088: fetch csr_date_to into g_dummy_number;
1089: p_before_date_to := csr_date_to%FOUND;
1090: close csr_date_to;
1091: --
1092: hr_utility.set_location('per_positions_pkg.check_valid_grades', 1);
1093: --
1094: open csr_date_from;
1095: fetch csr_date_from into g_dummy_number;
1096: p_before_date_from := csr_date_from%FOUND;

Line 1099: hr_utility.set_location('per_positions_pkg.check_valid_grades', 2);

1095: fetch csr_date_from into g_dummy_number;
1096: p_before_date_from := csr_date_from%FOUND;
1097: close csr_date_from;
1098: --
1099: hr_utility.set_location('per_positions_pkg.check_valid_grades', 2);
1100: --
1101: open csr_end_date_blank;
1102: fetch csr_end_date_blank into g_dummy_number;
1103: p_end_date_blank := csr_end_date_blank%FOUND;

Line 1106: hr_utility.set_location('per_positions_pkg.check_valid_grades', 3);

1102: fetch csr_end_date_blank into g_dummy_number;
1103: p_end_date_blank := csr_end_date_blank%FOUND;
1104: close csr_end_date_blank;
1105: --
1106: hr_utility.set_location('per_positions_pkg.check_valid_grades', 3);
1107: --
1108: open csr_after_date_to;
1109: fetch csr_after_date_to into g_dummy_number;
1110: p_after_date_to := csr_after_date_to%FOUND;

Line 1113: hr_utility.set_location('per_positions_pkg.check_valid_grades', 4);

1109: fetch csr_after_date_to into g_dummy_number;
1110: p_after_date_to := csr_after_date_to%FOUND;
1111: close csr_after_date_to;
1112: --
1113: hr_utility.set_location('per_positions_pkg.check_valid_grades', 4);
1114: --
1115: end check_valid_grades;
1116: --
1117: PROCEDURE maintain_valid_grades(p_position_id NUMBER,

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

1140: vg.position_id = p_position_id
1141: and nvl(vg.date_to, p_end_of_time) > p_date_end;
1142: --
1143: if (SQL%NOTFOUND) then
1144: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1145: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1146: hr_utility.set_message_token('STEP','1');
1147: hr_utility.raise_error;
1148: end if;

Line 1145: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');

1141: and nvl(vg.date_to, p_end_of_time) > p_date_end;
1142: --
1143: if (SQL%NOTFOUND) then
1144: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1145: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1146: hr_utility.set_message_token('STEP','1');
1147: hr_utility.raise_error;
1148: end if;
1149: --

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

1142: --
1143: if (SQL%NOTFOUND) then
1144: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1145: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1146: hr_utility.set_message_token('STEP','1');
1147: hr_utility.raise_error;
1148: end if;
1149: --
1150: END IF;

Line 1147: hr_utility.raise_error;

1143: if (SQL%NOTFOUND) then
1144: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1145: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1146: hr_utility.set_message_token('STEP','1');
1147: hr_utility.raise_error;
1148: end if;
1149: --
1150: END IF;
1151: --

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

1160: where position_id = p_position_id
1161: and date_from > p_date_end;
1162: --
1163: if (SQL%NOTFOUND) then
1164: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1165: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1166: hr_utility.set_message_token('STEP','2');
1167: hr_utility.raise_error;
1168: end if;

Line 1165: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');

1161: and date_from > p_date_end;
1162: --
1163: if (SQL%NOTFOUND) then
1164: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1165: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1166: hr_utility.set_message_token('STEP','2');
1167: hr_utility.raise_error;
1168: end if;
1169: --

Line 1166: hr_utility.set_message_token('STEP','2');

1162: --
1163: if (SQL%NOTFOUND) then
1164: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1165: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1166: hr_utility.set_message_token('STEP','2');
1167: hr_utility.raise_error;
1168: end if;
1169: --
1170: END IF;

Line 1167: hr_utility.raise_error;

1163: if (SQL%NOTFOUND) then
1164: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1165: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1166: hr_utility.set_message_token('STEP','2');
1167: hr_utility.raise_error;
1168: end if;
1169: --
1170: END IF;
1171: --

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

1196: from per_positions p
1197: where p.position_id = p_position_id);
1198: --
1199: if (SQL%NOTFOUND) then
1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1201: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1202: hr_utility.set_message_token('STEP','3');
1203: hr_utility.raise_error;
1204: end if;

Line 1201: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');

1197: where p.position_id = p_position_id);
1198: --
1199: if (SQL%NOTFOUND) then
1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1201: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1202: hr_utility.set_message_token('STEP','3');
1203: hr_utility.raise_error;
1204: end if;
1205: END IF;

Line 1202: hr_utility.set_message_token('STEP','3');

1198: --
1199: if (SQL%NOTFOUND) then
1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1201: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1202: hr_utility.set_message_token('STEP','3');
1203: hr_utility.raise_error;
1204: end if;
1205: END IF;
1206: --

Line 1203: hr_utility.raise_error;

1199: if (SQL%NOTFOUND) then
1200: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1201: hr_utility.set_message_token('PROCEDURE','maintain_valid_grades');
1202: hr_utility.set_message_token('STEP','3');
1203: hr_utility.raise_error;
1204: end if;
1205: END IF;
1206: --
1207: end maintain_valid_grades;