DBA Data[Home] [Help]

APPS.PER_REQUISITIONS_PKG dependencies on HR_UTILITY

Line 59: hr_utility.raise_error;

55: IF name_exists%found THEN
56: CLOSE name_exists;
57: fnd_message.set_name('PER', 'HR_6123_ALL_UNIQUE_NAME');
58: fnd_message.set_token('INFORMATION_TYPE','requisition');
59: hr_utility.raise_error;
60: ELSE CLOSE name_exists;
61: END IF;
62: END Check_Unique_Name;
63: --

Line 94: hr_utility.raise_error;

90: FETCH C_chk_date_from into v_dummy;
91: IF C_chk_date_from%found THEN
92: CLOSE C_chk_date_from;
93: fnd_message.set_name('PER','HR_6834_VACS_REQ_IN_VAC_DATES');
94: hr_utility.raise_error;
95: ELSE CLOSE C_chk_date_from;
96: END IF;
97:
98:

Line 135: hr_utility.raise_error;

131: FETCH C_chk_raised_by into v_dummy;
132: IF C_chk_raised_by%NOTFOUND THEN
133: CLOSE C_chk_raised_by;
134: fnd_message.set_name('PER','HR_6643_VACS_RAISED_BY');
135: hr_utility.raise_error;
136: ELSE CLOSE C_chk_raised_by;
137: END IF;
138:
139: END Date_from_raised_by;

Line 173: hr_utility.raise_error;

169: FETCH C_date_to_val into v_dummy;
170: IF C_date_to_val%FOUND THEN
171: CLOSE C_date_to_val;
172: fnd_message.set_name('PER','HR_6835_VACS_REQ_DATE_TO');
173: hr_utility.raise_error;
174: ELSE CLOSE C_date_to_val;
175: END IF;
176:
177: END Date_to_in_vac_dates;

Line 208: hr_utility.raise_error;

204: FETCH C_Check_References into v_name;
205: IF C_Check_References%FOUND THEN
206: CLOSE C_Check_References;
207: fnd_message.set_name('PER','HR_6124_REQS_VACS_DEL_VACANCY');
208: hr_utility.raise_error;
209: ELSE CLOSE C_Check_References;
210: END IF;
211:
212: END Check_References;

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

321: OPEN C;
322: FETCH C INTO X_Rowid;
323: if (C%NOTFOUND) then
324: CLOSE C;
325: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
326: hr_utility.set_message_token('PROCEDURE',
327: 'per_requisitions_pkg.insert_row');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;

Line 326: hr_utility.set_message_token('PROCEDURE',

322: FETCH C INTO X_Rowid;
323: if (C%NOTFOUND) then
324: CLOSE C;
325: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
326: hr_utility.set_message_token('PROCEDURE',
327: 'per_requisitions_pkg.insert_row');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;
330: end if;

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

324: CLOSE C;
325: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
326: hr_utility.set_message_token('PROCEDURE',
327: 'per_requisitions_pkg.insert_row');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;
330: end if;
331: CLOSE C;
332: END Insert_Row;

Line 329: hr_utility.raise_error;

325: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
326: hr_utility.set_message_token('PROCEDURE',
327: 'per_requisitions_pkg.insert_row');
328: hr_utility.set_message_token('STEP','1');
329: hr_utility.raise_error;
330: end if;
331: CLOSE C;
332: END Insert_Row;
333: --

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

384: OPEN C;
385: FETCH C INTO Recinfo;
386: if (C%NOTFOUND) then
387: CLOSE C;
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE',
390: 'per_requistions_pkg.lock_row');
391: hr_utility.set_message_token('STEP','1');
392: hr_utility.raise_error;

Line 389: hr_utility.set_message_token('PROCEDURE',

385: FETCH C INTO Recinfo;
386: if (C%NOTFOUND) then
387: CLOSE C;
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE',
390: 'per_requistions_pkg.lock_row');
391: hr_utility.set_message_token('STEP','1');
392: hr_utility.raise_error;
393: end if;

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

387: CLOSE C;
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE',
390: 'per_requistions_pkg.lock_row');
391: hr_utility.set_message_token('STEP','1');
392: hr_utility.raise_error;
393: end if;
394: CLOSE C;
395: --

Line 392: hr_utility.raise_error;

388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE',
390: 'per_requistions_pkg.lock_row');
391: hr_utility.set_message_token('STEP','1');
392: hr_utility.raise_error;
393: end if;
394: CLOSE C;
395: --
396: Recinfo.name := rtrim(Recinfo.name);

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

592: attribute20 = X_Attribute20
593: WHERE rowid = X_rowid;
594:
595: if (SQL%NOTFOUND) then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE',
598: 'per_requisitions_pkg.update_row');
599: hr_utility.set_message_token('STEP','1');
600: hr_utility.raise_error;

Line 597: hr_utility.set_message_token('PROCEDURE',

593: WHERE rowid = X_rowid;
594:
595: if (SQL%NOTFOUND) then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE',
598: 'per_requisitions_pkg.update_row');
599: hr_utility.set_message_token('STEP','1');
600: hr_utility.raise_error;
601: end if;

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

595: if (SQL%NOTFOUND) then
596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE',
598: 'per_requisitions_pkg.update_row');
599: hr_utility.set_message_token('STEP','1');
600: hr_utility.raise_error;
601: end if;
602:
603: END Update_Row;

Line 600: hr_utility.raise_error;

596: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
597: hr_utility.set_message_token('PROCEDURE',
598: 'per_requisitions_pkg.update_row');
599: hr_utility.set_message_token('STEP','1');
600: hr_utility.raise_error;
601: end if;
602:
603: END Update_Row;
604: --

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

619: DELETE FROM PER_REQUISITIONS
620: WHERE rowid = X_Rowid;
621:
622: if (SQL%NOTFOUND) then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE',
625: 'per_requisitions_pkg.delete_row');
626: hr_utility.set_message_token('STEP','1');
627: hr_utility.raise_error;

Line 624: hr_utility.set_message_token('PROCEDURE',

620: WHERE rowid = X_Rowid;
621:
622: if (SQL%NOTFOUND) then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE',
625: 'per_requisitions_pkg.delete_row');
626: hr_utility.set_message_token('STEP','1');
627: hr_utility.raise_error;
628: end if;

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

622: if (SQL%NOTFOUND) then
623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE',
625: 'per_requisitions_pkg.delete_row');
626: hr_utility.set_message_token('STEP','1');
627: hr_utility.raise_error;
628: end if;
629: END Delete_Row;
630:

Line 627: hr_utility.raise_error;

623: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
624: hr_utility.set_message_token('PROCEDURE',
625: 'per_requisitions_pkg.delete_row');
626: hr_utility.set_message_token('STEP','1');
627: hr_utility.raise_error;
628: end if;
629: END Delete_Row;
630:
631: END PER_REQUISITIONS_PKG;