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

Line 47: hr_utility.set_message(801,'HR_6120_RAC_VACACNY_EXISTS');

43: open c1 ;
44: fetch c1 into l_dummy ;
45: if c1%found then
46: close c1 ;
47: hr_utility.set_message(801,'HR_6120_RAC_VACACNY_EXISTS');
48: hr_utility.raise_error ;
49: end if;
50: close c1 ;
51: --

Line 48: hr_utility.raise_error ;

44: fetch c1 into l_dummy ;
45: if c1%found then
46: close c1 ;
47: hr_utility.set_message(801,'HR_6120_RAC_VACACNY_EXISTS');
48: hr_utility.raise_error ;
49: end if;
50: close c1 ;
51: --
52: end chk_vacancy_unique ;

Line 87: hr_utility.set_message(800,'HR_6110_RAC_RECRUIT_DEL_CHILD');

83: P_Business_group_id);
84: FETCH csr_rec_ac_for into v_dummy_id;
85: IF csr_rec_ac_for%found then
86: CLOSE csr_rec_ac_for;
87: hr_utility.set_message(800,'HR_6110_RAC_RECRUIT_DEL_CHILD');
88: hr_utility.raise_error;
89: ELSE
90: CLOSE csr_rec_ac_for;
91: END IF;

Line 88: hr_utility.raise_error;

84: FETCH csr_rec_ac_for into v_dummy_id;
85: IF csr_rec_ac_for%found then
86: CLOSE csr_rec_ac_for;
87: hr_utility.set_message(800,'HR_6110_RAC_RECRUIT_DEL_CHILD');
88: hr_utility.raise_error;
89: ELSE
90: CLOSE csr_rec_ac_for;
91: END IF;
92:

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

148: OPEN C;
149: FETCH C INTO X_Rowid;
150: if (C%NOTFOUND) then
151: CLOSE C;
152: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
153: hr_utility.set_message_token('PROCEDURE',
154: 'per_recruit_activity_for_pkg.insert_row');
155: hr_utility.set_message_token('STEP','1');
156: hr_utility.raise_error;

Line 153: hr_utility.set_message_token('PROCEDURE',

149: FETCH C INTO X_Rowid;
150: if (C%NOTFOUND) then
151: CLOSE C;
152: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
153: hr_utility.set_message_token('PROCEDURE',
154: 'per_recruit_activity_for_pkg.insert_row');
155: hr_utility.set_message_token('STEP','1');
156: hr_utility.raise_error;
157: end if;

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

151: CLOSE C;
152: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
153: hr_utility.set_message_token('PROCEDURE',
154: 'per_recruit_activity_for_pkg.insert_row');
155: hr_utility.set_message_token('STEP','1');
156: hr_utility.raise_error;
157: end if;
158: CLOSE C;
159: END Insert_Row;

Line 156: hr_utility.raise_error;

152: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
153: hr_utility.set_message_token('PROCEDURE',
154: 'per_recruit_activity_for_pkg.insert_row');
155: hr_utility.set_message_token('STEP','1');
156: hr_utility.raise_error;
157: end if;
158: CLOSE C;
159: END Insert_Row;
160: --

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

188: OPEN C;
189: FETCH C INTO Recinfo;
190: if (C%NOTFOUND) then
191: CLOSE C;
192: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('PROCEDURE',
194: 'per_recruit_activity_for_pkg.lock_row');
195: hr_utility.set_message_token('STEP','1');
196: hr_utility.raise_error;

Line 193: hr_utility.set_message_token('PROCEDURE',

189: FETCH C INTO Recinfo;
190: if (C%NOTFOUND) then
191: CLOSE C;
192: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('PROCEDURE',
194: 'per_recruit_activity_for_pkg.lock_row');
195: hr_utility.set_message_token('STEP','1');
196: hr_utility.raise_error;
197: end if;

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

191: CLOSE C;
192: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('PROCEDURE',
194: 'per_recruit_activity_for_pkg.lock_row');
195: hr_utility.set_message_token('STEP','1');
196: hr_utility.raise_error;
197: end if;
198: CLOSE C;
199: if (

Line 196: hr_utility.raise_error;

192: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
193: hr_utility.set_message_token('PROCEDURE',
194: 'per_recruit_activity_for_pkg.lock_row');
195: hr_utility.set_message_token('STEP','1');
196: hr_utility.raise_error;
197: end if;
198: CLOSE C;
199: if (
200: ( (Recinfo.recruitment_activity_for_id = X_Recruitment_Activity_For_Id)

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

253: recruitment_activity_id = X_Recruitment_Activity_Id
254: WHERE rowid = X_rowid;
255:
256: if (SQL%NOTFOUND) then
257: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE',
259: 'per_recruit_activity_for_pkg.update_row');
260: hr_utility.set_message_token('STEP','1');
261: hr_utility.raise_error;

Line 258: hr_utility.set_message_token('PROCEDURE',

254: WHERE rowid = X_rowid;
255:
256: if (SQL%NOTFOUND) then
257: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE',
259: 'per_recruit_activity_for_pkg.update_row');
260: hr_utility.set_message_token('STEP','1');
261: hr_utility.raise_error;
262: end if;

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

256: if (SQL%NOTFOUND) then
257: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE',
259: 'per_recruit_activity_for_pkg.update_row');
260: hr_utility.set_message_token('STEP','1');
261: hr_utility.raise_error;
262: end if;
263:
264: END Update_Row;

Line 261: hr_utility.raise_error;

257: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
258: hr_utility.set_message_token('PROCEDURE',
259: 'per_recruit_activity_for_pkg.update_row');
260: hr_utility.set_message_token('STEP','1');
261: hr_utility.raise_error;
262: end if;
263:
264: END Update_Row;
265: --

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

280: DELETE FROM PER_RECRUITMENT_ACTIVITY_FOR
281: WHERE rowid = X_Rowid;
282:
283: if (SQL%NOTFOUND) then
284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
285: hr_utility.set_message_token('PROCEDURE',
286: 'per_recruit_activity_for_pkg.delete_row');
287: hr_utility.set_message_token('STEP','1');
288: hr_utility.raise_error;

Line 285: hr_utility.set_message_token('PROCEDURE',

281: WHERE rowid = X_Rowid;
282:
283: if (SQL%NOTFOUND) then
284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
285: hr_utility.set_message_token('PROCEDURE',
286: 'per_recruit_activity_for_pkg.delete_row');
287: hr_utility.set_message_token('STEP','1');
288: hr_utility.raise_error;
289: end if;

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

283: if (SQL%NOTFOUND) then
284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
285: hr_utility.set_message_token('PROCEDURE',
286: 'per_recruit_activity_for_pkg.delete_row');
287: hr_utility.set_message_token('STEP','1');
288: hr_utility.raise_error;
289: end if;
290: END Delete_Row;
291:

Line 288: hr_utility.raise_error;

284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
285: hr_utility.set_message_token('PROCEDURE',
286: 'per_recruit_activity_for_pkg.delete_row');
287: hr_utility.set_message_token('STEP','1');
288: hr_utility.raise_error;
289: end if;
290: END Delete_Row;
291:
292: END PER_RECRUIT_ACTIVITY_FOR_PKG;