APPS.OTA_AP_DELETE dependencies on HR_UTILITY

Line 46: hr_utility.set_location('Entering:'||l_proc, 5);

42: where address_id = p_vendor_site_id
43: and vendor_id is not null;
44: --
45: begin
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: if p_vendor_id is not null then
49: --
50: hr_utility.set_location('Entering:'||l_proc, 15);

Line 50: hr_utility.set_location('Entering:'||l_proc, 15);

46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: if p_vendor_id is not null then
49: --
50: hr_utility.set_location('Entering:'||l_proc, 15);
51: open c_events;
52: fetch c_events into l_exists;
53: if c_events%found then
54: close c_events;

Line 62: hr_utility.set_location('Entering:'||l_proc, 20);

58: fnd_message.raise_error;
59: end if;
60: close c_events;
61: --
62: hr_utility.set_location('Entering:'||l_proc, 20);
63: open c_activity_versions;
64: fetch c_activity_versions into l_exists;
65: if c_activity_versions%found then
66: close c_activity_versions;

Line 74: hr_utility.set_location('Entering:'||l_proc, 25);

70: fnd_message.raise_error;
71: end if;
72: close c_activity_versions;
73: --
74: hr_utility.set_location('Entering:'||l_proc, 25);
75: open c_suppliable_resources;
76: fetch c_suppliable_resources into l_exists;
77: if c_suppliable_resources%found then
78: close c_suppliable_resources;

Line 86: hr_utility.set_location('Entering:'||l_proc, 35);

82: fnd_message.raise_error;
83: end if;
84: close c_suppliable_resources;
85: --
86: hr_utility.set_location('Entering:'||l_proc, 35);
87: open c_finance_headers1;
88: fetch c_finance_headers1 into l_exists;
89: if c_finance_headers1%found then
90: close c_finance_headers1;

Line 100: hr_utility.set_location('Entering:'||l_proc, 55);

96: close c_finance_headers1;
97: --
98: elsif p_contact_id is not null then
99: --
100: hr_utility.set_location('Entering:'||l_proc, 55);
101: open c_finance_headers2;
102: fetch c_finance_headers2 into l_exists;
103: if c_finance_headers2%found then
104: close c_finance_headers2;

Line 114: hr_utility.set_location('Entering:'||l_proc, 70);

110: close c_finance_headers2;
111: --
112: elsif p_vendor_site_id is not null then
113: --
114: hr_utility.set_location('Entering:'||l_proc, 70);
115: open c_finance_headers3;
116: fetch c_finance_headers3 into l_exists;
117: if c_finance_headers3%found then
118: close c_finance_headers3;

Line 128: hr_utility.set_location(' Leaving:'||l_proc, 75);

124: close c_finance_headers3;
125: --
126: end if;
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 75);
129: end;
130: --
131: end ota_ap_delete;