DBA Data[Home] [Help]

APPS.RCV_PERSON dependencies on HR_UTILITY

Line 19: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 18);

15: v_delete_permitted varchar2(1);
16: --
17: BEGIN
18: --
19: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 18);
20: --
21: begin
22: select 'Y'
23: into v_delete_permitted

Line 31: hr_utility.set_message (801, 'HR_6575_ALL_PO24_PER_NO_DEL');

27: from rcv_shipment_headers rcv
28: where rcv.employee_id = P_PERSON_ID);
29: exception
30: when NO_DATA_FOUND then
31: hr_utility.set_message (801, 'HR_6575_ALL_PO24_PER_NO_DEL');
32: hr_utility.raise_error;
33: end;
34: --
35: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 19);

Line 32: hr_utility.raise_error;

28: where rcv.employee_id = P_PERSON_ID);
29: exception
30: when NO_DATA_FOUND then
31: hr_utility.set_message (801, 'HR_6575_ALL_PO24_PER_NO_DEL');
32: hr_utility.raise_error;
33: end;
34: --
35: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 19);
36: --

Line 35: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 19);

31: hr_utility.set_message (801, 'HR_6575_ALL_PO24_PER_NO_DEL');
32: hr_utility.raise_error;
33: end;
34: --
35: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 19);
36: --
37: begin
38: select 'Y'
39: into v_delete_permitted

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

44: where rcv.employee_id = P_PERSON_ID
45: or rcv.deliver_to_person_id = P_PERSON_ID);
46: exception
47: when NO_DATA_FOUND then
48: hr_utility.set_message (801, 'HR_6581_ALL_PO25_PER_NO_DEL');
49: hr_utility.raise_error;
50: end;
51: --
52: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 20);

Line 49: hr_utility.raise_error;

45: or rcv.deliver_to_person_id = P_PERSON_ID);
46: exception
47: when NO_DATA_FOUND then
48: hr_utility.set_message (801, 'HR_6581_ALL_PO25_PER_NO_DEL');
49: hr_utility.raise_error;
50: end;
51: --
52: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 20);
53: --

Line 52: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 20);

48: hr_utility.set_message (801, 'HR_6581_ALL_PO25_PER_NO_DEL');
49: hr_utility.raise_error;
50: end;
51: --
52: hr_utility.set_location('RCV_PERSON.RCV_PREDEL_VALIDATION', 20);
53: --
54: begin
55: select 'Y'
56: into v_delete_permitted

Line 70: hr_utility.set_message (801, 'HR_6582_ALL_PO26_PER_NO_DEL');

66: where rcv.employee_id = P_PERSON_ID
67: or rcv.deliver_to_person_id = P_PERSON_ID);
68: exception
69: when NO_DATA_FOUND then
70: hr_utility.set_message (801, 'HR_6582_ALL_PO26_PER_NO_DEL');
71: hr_utility.raise_error;
72: end;
73: --
74: END rcv_predel_validation;

Line 71: hr_utility.raise_error;

67: or rcv.deliver_to_person_id = P_PERSON_ID);
68: exception
69: when NO_DATA_FOUND then
70: hr_utility.set_message (801, 'HR_6582_ALL_PO26_PER_NO_DEL');
71: hr_utility.raise_error;
72: end;
73: --
74: END rcv_predel_validation;
75: --