DBA Data[Home] [Help]

APPS.WIP_PERSON dependencies on HR_UTILITY

Line 12: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 1);

8: BEGIN
9: /* Sets package variables to store location name and stage number which
10: * enables unexpected errors to be located more easily
11: */
12: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 1);
13:
14: begin
15: select 'Y'
16: into v_delete_permitted

Line 25: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');

21: where welr.employee_id = P_PERSON_ID);
22:
23: exception
24: when NO_DATA_FOUND then
25: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');
26: hr_utility.raise_error;
27: end;
28:
29: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 2);

Line 26: hr_utility.raise_error;

22:
23: exception
24: when NO_DATA_FOUND then
25: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');
26: hr_utility.raise_error;
27: end;
28:
29: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 2);
30:

Line 29: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 2);

25: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');
26: hr_utility.raise_error;
27: end;
28:
29: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 2);
30:
31: begin
32: select 'Y'
33: into v_delete_permitted

Line 42: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');

38: where wt.employee_id = P_PERSON_ID);
39:
40: exception
41: when NO_DATA_FOUND then
42: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');
43: hr_utility.raise_error;
44: end;
45:
46:

Line 43: hr_utility.raise_error;

39:
40: exception
41: when NO_DATA_FOUND then
42: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');
43: hr_utility.raise_error;
44: end;
45:
46:
47: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 3);

Line 47: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 3);

43: hr_utility.raise_error;
44: end;
45:
46:
47: hr_utility.set_location('WIP_PERSON.WIP_PREDEL_VALIDATION', 3);
48:
49: begin
50: select 'Y'
51: into v_delete_permitted

Line 63: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');

59: and be.person_id = P_PERSON_ID);
60:
61: exception
62: when NO_DATA_FOUND then
63: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');
64: hr_utility.raise_error;
65: end;
66:
67: END wip_predel_validation;

Line 64: hr_utility.raise_error;

60:
61: exception
62: when NO_DATA_FOUND then
63: hr_utility.set_message(706, 'WIP_EMPLOYEE_DELETE');
64: hr_utility.raise_error;
65: end;
66:
67: END wip_predel_validation;
68: