DBA Data[Home] [Help]

APPS.HR_API_HOOK_CALL_API dependencies on HR_UTILITY

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

38: --
39: l_proc varchar2(72) := g_package||'create_api_hook_call';
40: --
41: begin
42: hr_utility.set_location('Entering:'|| l_proc, 5);
43: --
44: -- Set l_effective_date equal to truncated version of p_effective_date for
45: -- API work. Stops dates being passed to row handlers with time portion.
46: --

Line 55: hr_utility.set_location(l_proc, 10);

51: if p_validate then
52: savepoint create_api_hook_call;
53: end if;
54: --
55: hr_utility.set_location(l_proc, 10);
56: --
57: -- Validation in addition to Table Handlers
58: --
59: -- None required.

Line 83: hr_utility.set_location(l_proc, 20);

79: p_status => l_status,
80: p_object_version_number => l_object_version_number
81: );
82: --
83: hr_utility.set_location(l_proc, 20);
84: --
85: -- When in validation only mode raise the Validate_Enabled exception
86: --
87: if p_validate then

Line 96: hr_utility.set_location(' Leaving:'||l_proc, 100);

92: --
93: p_api_hook_call_id := l_api_hook_call_id;
94: p_object_version_number := l_object_version_number;
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 100);
97: exception
98: when hr_api.validate_enabled then
99: --
100: -- As the Validate_Enabled exception has been raised

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

138: from hr_api_hook_calls
139: where api_hook_call_id = p_api_hook_call_id;
140:
141: begin
142: hr_utility.set_location('Entering:'|| l_proc, 5);
143: --
144: -- Issue a savepoint if operating in validation only mode.
145: --
146: if p_validate then

Line 150: hr_utility.set_location(l_proc, 10);

146: if p_validate then
147: savepoint delete_api_hook_call;
148: end if;
149: --
150: hr_utility.set_location(l_proc, 10);
151: --
152: -- Validation in addition to Table Handlers
153: --
154: open csr_get_leg_code;

Line 158: hr_utility.set_message(800, 'PER_52149_AHC_CANNOT_DEL_ROW');

154: open csr_get_leg_code;
155: fetch csr_get_leg_code into l_leg_code;
156:
157: if (l_leg_code is not null) then
158: hr_utility.set_message(800, 'PER_52149_AHC_CANNOT_DEL_ROW');
159: hr_utility.raise_error;
160: end if;
161: --
162: -- Process Logic

Line 159: hr_utility.raise_error;

155: fetch csr_get_leg_code into l_leg_code;
156:
157: if (l_leg_code is not null) then
158: hr_utility.set_message(800, 'PER_52149_AHC_CANNOT_DEL_ROW');
159: hr_utility.raise_error;
160: end if;
161: --
162: -- Process Logic
163: --

Line 168: hr_utility.set_location(l_proc, 20);

164: hr_ahc_del.del
165: (p_api_hook_call_id => p_api_hook_call_id,
166: p_object_version_number => p_object_version_number);
167: --
168: hr_utility.set_location(l_proc, 20);
169: --
170: -- When in validation only mode raise the Validate_Enabled exception
171: --
172: if p_validate then

Line 176: hr_utility.set_location(' Leaving:'||l_proc, 100);

172: if p_validate then
173: raise hr_api.validate_enabled;
174: end if;
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 100);
177: exception
178: when hr_api.validate_enabled then
179: --
180: -- As the Validate_Enabled exception has been raised

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

215: from hr_api_hook_calls
216: where api_hook_call_id = p_api_hook_call_id;
217: --
218: begin
219: hr_utility.set_location('Entering:'|| l_proc, 5);
220: --
221: -- Set l_effective_date equal to truncated version of p_effective_date for
222: -- API work. Stops dates being passed to row handlers with time portion.
223: --

Line 236: hr_utility.set_location(l_proc, 10);

232: if p_validate then
233: savepoint update_api_hook_call;
234: end if;
235: --
236: hr_utility.set_location(l_proc, 10);
237: --
238: -- Validation in addition to Table Handlers
239: --
240: open csr_get_leg_code;

Line 245: hr_utility.set_message(800, 'PER_52149_AHC_CANNOT_DEL_ROW');

241: fetch csr_get_leg_code into l_leg_code;
242: if (l_leg_code is not null) then
243: --
244: close csr_get_leg_code;
245: hr_utility.set_message(800, 'PER_52149_AHC_CANNOT_DEL_ROW');
246: hr_utility.raise_error;
247: --
248: end if;
249: close csr_get_leg_code;

Line 246: hr_utility.raise_error;

242: if (l_leg_code is not null) then
243: --
244: close csr_get_leg_code;
245: hr_utility.set_message(800, 'PER_52149_AHC_CANNOT_DEL_ROW');
246: hr_utility.raise_error;
247: --
248: end if;
249: close csr_get_leg_code;
250: --

Line 263: hr_utility.set_location(l_proc, 20);

259: ,p_call_procedure => p_call_procedure
260: ,p_object_version_number => p_object_version_number
261: );
262: --
263: hr_utility.set_location(l_proc, 20);
264: --
265: -- When in validation only mode raise the Validate_Enabled exception
266: --
267: if p_validate then

Line 271: hr_utility.set_location(' Leaving:'||l_proc, 100);

267: if p_validate then
268: raise hr_api.validate_enabled;
269: end if;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 100);
272: exception
273: when hr_api.validate_enabled then
274: --
275: -- Only set output warning arguments