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

Line 112: hr_utility.set_message (275, Error_Message);

108: exception
109: when Allow_deletion then
110: Return;
111: when Not_Allow_deletion then
112: hr_utility.set_message (275, Error_Message);
113: hr_utility.raise_error;
114: when OTHERS then
115: raise;
116: END pa_predel_validation;

Line 113: hr_utility.raise_error;

109: when Allow_deletion then
110: Return;
111: when Not_Allow_deletion then
112: hr_utility.set_message (275, Error_Message);
113: hr_utility.raise_error;
114: when OTHERS then
115: raise;
116: END pa_predel_validation;
117:

Line 146: hr_utility.set_message (275, 'PA_PER_PHS1_NO_DEL');

142: when OTHERS then
143: Raise;
144: /* ***
145: when NO_DATA_FOUND then
146: hr_utility.set_message (275, 'PA_PER_PHS1_NO_DEL');
147: hr_utility.raise_error;
148: ** */
149: END check_business_group;
150:

Line 147: hr_utility.raise_error;

143: Raise;
144: /* ***
145: when NO_DATA_FOUND then
146: hr_utility.set_message (275, 'PA_PER_PHS1_NO_DEL');
147: hr_utility.raise_error;
148: ** */
149: END check_business_group;
150:
151: PROCEDURE phase2 (p_person_id number)

Line 165: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 1);

161: AND fpi.status = 'I';
162: --
163: BEGIN
164: --
165: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 1);
166: --
167: begin
168: select 'Y'
169: into v_delete_permitted

Line 177: hr_utility.set_message (801, 'HR_6285_ALL_PA_PER_NO_DEL');

173: from pa_compensation_details pa
174: where pa.person_id = P_PERSON_ID);
175: exception
176: when NO_DATA_FOUND then
177: hr_utility.set_message (801, 'HR_6285_ALL_PA_PER_NO_DEL');
178: hr_utility.raise_error;
179: end;
180: --
181: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 2);

Line 178: hr_utility.raise_error;

174: where pa.person_id = P_PERSON_ID);
175: exception
176: when NO_DATA_FOUND then
177: hr_utility.set_message (801, 'HR_6285_ALL_PA_PER_NO_DEL');
178: hr_utility.raise_error;
179: end;
180: --
181: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 2);
182: --

Line 181: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 2);

177: hr_utility.set_message (801, 'HR_6285_ALL_PA_PER_NO_DEL');
178: hr_utility.raise_error;
179: end;
180: --
181: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 2);
182: --
183: begin
184: select 'Y'
185: into v_delete_permitted

Line 195: hr_utility.set_message (801, 'HR_6286_ALL_PA2_PER_NO_DEL');

191: and pa.task_id > -1
192: and pa.person_id = P_PERSON_ID);
193: exception
194: when NO_DATA_FOUND then
195: hr_utility.set_message (801, 'HR_6286_ALL_PA2_PER_NO_DEL');
196: hr_utility.raise_error;
197: end;
198: --
199: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 3);

Line 196: hr_utility.raise_error;

192: and pa.person_id = P_PERSON_ID);
193: exception
194: when NO_DATA_FOUND then
195: hr_utility.set_message (801, 'HR_6286_ALL_PA2_PER_NO_DEL');
196: hr_utility.raise_error;
197: end;
198: --
199: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 3);
200: --

Line 199: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 3);

195: hr_utility.set_message (801, 'HR_6286_ALL_PA2_PER_NO_DEL');
196: hr_utility.raise_error;
197: end;
198: --
199: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 3);
200: --
201: begin
202: select 'Y'
203: into v_delete_permitted

Line 215: hr_utility.set_message (801, 'HR_6287_ALL_PA3_PER_NO_DEL');

211: (pa.task_id > -1 AND
212: pa.person_id = P_PERSON_ID)));
213: exception
214: when NO_DATA_FOUND then
215: hr_utility.set_message (801, 'HR_6287_ALL_PA3_PER_NO_DEL');
216: hr_utility.raise_error;
217: end;
218: --
219: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 4);

Line 216: hr_utility.raise_error;

212: pa.person_id = P_PERSON_ID)));
213: exception
214: when NO_DATA_FOUND then
215: hr_utility.set_message (801, 'HR_6287_ALL_PA3_PER_NO_DEL');
216: hr_utility.raise_error;
217: end;
218: --
219: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 4);
220: --

Line 219: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 4);

215: hr_utility.set_message (801, 'HR_6287_ALL_PA3_PER_NO_DEL');
216: hr_utility.raise_error;
217: end;
218: --
219: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 4);
220: --
221: begin
222: select 'Y'
223: into v_delete_permitted

Line 234: hr_utility.set_message (801, 'HR_6288_ALL_PA4_PER_NO_DEL');

230: and pa.std_bill_rate_schedule <> 'DUMMY'
231: and pa.person_id = P_PERSON_ID);
232: exception
233: when NO_DATA_FOUND then
234: hr_utility.set_message (801, 'HR_6288_ALL_PA4_PER_NO_DEL');
235: hr_utility.raise_error;
236: end;
237: --
238: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 5);

Line 235: hr_utility.raise_error;

231: and pa.person_id = P_PERSON_ID);
232: exception
233: when NO_DATA_FOUND then
234: hr_utility.set_message (801, 'HR_6288_ALL_PA4_PER_NO_DEL');
235: hr_utility.raise_error;
236: end;
237: --
238: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 5);
239: --

Line 238: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 5);

234: hr_utility.set_message (801, 'HR_6288_ALL_PA4_PER_NO_DEL');
235: hr_utility.raise_error;
236: end;
237: --
238: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 5);
239: --
240: begin
241: select 'Y'
242: into v_delete_permitted

Line 250: hr_utility.set_message (801, 'HR_6289_ALL_PA5_PER_NO_DEL');

246: from pa_project_players pa
247: where pa.person_id = P_PERSON_ID);
248: exception
249: when NO_DATA_FOUND then
250: hr_utility.set_message (801, 'HR_6289_ALL_PA5_PER_NO_DEL');
251: hr_utility.raise_error;
252: end;
253: --
254: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 6);

Line 251: hr_utility.raise_error;

247: where pa.person_id = P_PERSON_ID);
248: exception
249: when NO_DATA_FOUND then
250: hr_utility.set_message (801, 'HR_6289_ALL_PA5_PER_NO_DEL');
251: hr_utility.raise_error;
252: end;
253: --
254: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 6);
255: --

Line 254: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 6);

250: hr_utility.set_message (801, 'HR_6289_ALL_PA5_PER_NO_DEL');
251: hr_utility.raise_error;
252: end;
253: --
254: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 6);
255: --
256: begin
257: select 'Y'
258: into v_delete_permitted

Line 266: hr_utility.set_message (801, 'HR_6290_ALL_PA6_PER_NO_DEL');

262: from pa_agreements pa
263: where pa.owned_by_person_id = P_PERSON_ID);
264: exception
265: when NO_DATA_FOUND then
266: hr_utility.set_message (801, 'HR_6290_ALL_PA6_PER_NO_DEL');
267: hr_utility.raise_error;
268: end;
269: --
270: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 7);

Line 267: hr_utility.raise_error;

263: where pa.owned_by_person_id = P_PERSON_ID);
264: exception
265: when NO_DATA_FOUND then
266: hr_utility.set_message (801, 'HR_6290_ALL_PA6_PER_NO_DEL');
267: hr_utility.raise_error;
268: end;
269: --
270: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 7);
271: --

Line 270: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 7);

266: hr_utility.set_message (801, 'HR_6290_ALL_PA6_PER_NO_DEL');
267: hr_utility.raise_error;
268: end;
269: --
270: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 7);
271: --
272: begin
273: select 'Y'
274: into v_delete_permitted

Line 282: hr_utility.set_message (801, 'HR_6295_ALL_PA7_PER_NO_DEL');

278: from pa_tasks pa
279: where pa.task_manager_person_id = P_PERSON_ID);
280: exception
281: when NO_DATA_FOUND then
282: hr_utility.set_message (801, 'HR_6295_ALL_PA7_PER_NO_DEL');
283: hr_utility.raise_error;
284: end;
285: --
286: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 8);

Line 283: hr_utility.raise_error;

279: where pa.task_manager_person_id = P_PERSON_ID);
280: exception
281: when NO_DATA_FOUND then
282: hr_utility.set_message (801, 'HR_6295_ALL_PA7_PER_NO_DEL');
283: hr_utility.raise_error;
284: end;
285: --
286: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 8);
287: --

Line 286: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 8);

282: hr_utility.set_message (801, 'HR_6295_ALL_PA7_PER_NO_DEL');
283: hr_utility.raise_error;
284: end;
285: --
286: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 8);
287: --
288: begin
289: select /*+ INDEX (pa PA_CREDIT_RECEIVERS_U1) */
290: 'Y'

Line 299: hr_utility.set_message (801, 'HR_6297_ALL_PA8_PER_NO_DEL');

295: from pa_credit_receivers pa
296: where pa.person_id = P_PERSON_ID);
297: exception
298: when NO_DATA_FOUND then
299: hr_utility.set_message (801, 'HR_6297_ALL_PA8_PER_NO_DEL');
300: hr_utility.raise_error;
301: end;
302: --
303: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 9);

Line 300: hr_utility.raise_error;

296: where pa.person_id = P_PERSON_ID);
297: exception
298: when NO_DATA_FOUND then
299: hr_utility.set_message (801, 'HR_6297_ALL_PA8_PER_NO_DEL');
300: hr_utility.raise_error;
301: end;
302: --
303: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 9);
304: --

Line 303: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 9);

299: hr_utility.set_message (801, 'HR_6297_ALL_PA8_PER_NO_DEL');
300: hr_utility.raise_error;
301: end;
302: --
303: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 9);
304: --
305: begin
306: select 'Y'
307: into v_delete_permitted

Line 323: hr_utility.set_message (801, 'HR_6300_ALL_PA9_PER_NO_DEL');

319: from pa_expenditures pa
320: where pa.entered_by_person_id = P_PERSON_ID);
321: exception
322: when NO_DATA_FOUND then
323: hr_utility.set_message (801, 'HR_6300_ALL_PA9_PER_NO_DEL');
324: hr_utility.raise_error;
325: end;
326: --
327: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 10);

Line 324: hr_utility.raise_error;

320: where pa.entered_by_person_id = P_PERSON_ID);
321: exception
322: when NO_DATA_FOUND then
323: hr_utility.set_message (801, 'HR_6300_ALL_PA9_PER_NO_DEL');
324: hr_utility.raise_error;
325: end;
326: --
327: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 10);
328: --

Line 327: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 10);

323: hr_utility.set_message (801, 'HR_6300_ALL_PA9_PER_NO_DEL');
324: hr_utility.raise_error;
325: end;
326: --
327: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 10);
328: --
329: begin
330: select 'Y'
331: into v_delete_permitted

Line 340: hr_utility.set_message (801, 'HR_6301_ALL_PA10_PER_NO_DEL');

336: where pa.approved_by_person_id = P_PERSON_ID
337: or pa.released_by_person_id = P_PERSON_ID);
338: exception
339: when NO_DATA_FOUND then
340: hr_utility.set_message (801, 'HR_6301_ALL_PA10_PER_NO_DEL');
341: hr_utility.raise_error;
342: end;
343: --
344:

Line 341: hr_utility.raise_error;

337: or pa.released_by_person_id = P_PERSON_ID);
338: exception
339: when NO_DATA_FOUND then
340: hr_utility.set_message (801, 'HR_6301_ALL_PA10_PER_NO_DEL');
341: hr_utility.raise_error;
342: end;
343: --
344:
345: /* -- sowong - these lines of code are removed since PA EMPLOYEE ACCUM

Line 348: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 11);

344:
345: /* -- sowong - these lines of code are removed since PA EMPLOYEE ACCUM
346: -- references are not needed (see bug 967781).
347:
348: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 11);
349: --
350: begin
351: select 'Y'
352: into v_delete_permitted

Line 360: hr_utility.set_message (801, 'HR_6302_ALL_PA11_PER_NO_DEL');

356: from pa_employee_accum pa
357: where pa.person_id = P_PERSON_ID);
358: exception
359: when NO_DATA_FOUND then
360: hr_utility.set_message (801, 'HR_6302_ALL_PA11_PER_NO_DEL');
361: hr_utility.raise_error;
362: end;
363: --
364: */

Line 361: hr_utility.raise_error;

357: where pa.person_id = P_PERSON_ID);
358: exception
359: when NO_DATA_FOUND then
360: hr_utility.set_message (801, 'HR_6302_ALL_PA11_PER_NO_DEL');
361: hr_utility.raise_error;
362: end;
363: --
364: */
365:

Line 366: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 12);

362: end;
363: --
364: */
365:
366: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 12);
367: --
368: begin
369: select 'Y'
370: into v_delete_permitted

Line 380: hr_utility.set_message (801, 'HR_7057_ALL_PA12_PER_NO_DEL');

376: OR
377: pa.routed_from_person_id = P_PERSON_ID));
378: exception
379: when NO_DATA_FOUND then
380: hr_utility.set_message (801, 'HR_7057_ALL_PA12_PER_NO_DEL');
381: hr_utility.raise_error;
382: end;
383: --
384: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 16);

Line 381: hr_utility.raise_error;

377: pa.routed_from_person_id = P_PERSON_ID));
378: exception
379: when NO_DATA_FOUND then
380: hr_utility.set_message (801, 'HR_7057_ALL_PA12_PER_NO_DEL');
381: hr_utility.raise_error;
382: end;
383: --
384: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 16);
385: --

Line 384: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 16);

380: hr_utility.set_message (801, 'HR_7057_ALL_PA12_PER_NO_DEL');
381: hr_utility.raise_error;
382: end;
383: --
384: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 16);
385: --
386: begin
387: select 'Y'
388: into v_delete_permitted

Line 397: hr_utility.set_message (801, 'HR_7061_ALL_PA16_PER_NO_DEL');

393: where pa.project_id > -1
394: and pa.person_id = P_PERSON_ID);
395: exception
396: when NO_DATA_FOUND then
397: hr_utility.set_message (801, 'HR_7061_ALL_PA16_PER_NO_DEL');
398: hr_utility.raise_error;
399: end;
400:
401: open pa_per_exists;

Line 398: hr_utility.raise_error;

394: and pa.person_id = P_PERSON_ID);
395: exception
396: when NO_DATA_FOUND then
397: hr_utility.set_message (801, 'HR_7061_ALL_PA16_PER_NO_DEL');
398: hr_utility.raise_error;
399: end;
400:
401: open pa_per_exists;
402: fetch pa_per_exists into dummy;

Line 404: hr_utility.set_message (275,'PA_PER_CANT_DELETE');

400:
401: open pa_per_exists;
402: fetch pa_per_exists into dummy;
403: if pa_per_exists%found then
404: hr_utility.set_message (275,'PA_PER_CANT_DELETE');
405: hr_utility.raise_error;
406: end if;
407: close pa_per_exists;
408: --

Line 405: hr_utility.raise_error;

401: open pa_per_exists;
402: fetch pa_per_exists into dummy;
403: if pa_per_exists%found then
404: hr_utility.set_message (275,'PA_PER_CANT_DELETE');
405: hr_utility.raise_error;
406: end if;
407: close pa_per_exists;
408: --
409: --