DBA Data[Home] [Help]

APPS.PQH_ROUTING_LISTS_API dependencies on HR_UTILITY

Line 28: hr_utility.set_location('Entering:'|| l_proc, 10);

24: l_object_version_number pqh_routing_lists.object_version_number%TYPE;
25: --
26: begin
27: --
28: hr_utility.set_location('Entering:'|| l_proc, 10);
29: --
30: -- Issue a savepoint if operating in validation only mode
31: --
32: savepoint create_routing_list;

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

30: -- Issue a savepoint if operating in validation only mode
31: --
32: savepoint create_routing_list;
33: --
34: hr_utility.set_location(l_proc, 20);
35: --
36: -- Process Logic
37: --
38: begin

Line 89: hr_utility.set_location(l_proc, 60);

85: -- End of API User Hook for the after hook of create_routing_list
86: --
87: end;
88: --
89: hr_utility.set_location(l_proc, 60);
90: --
91: -- When in validation only mode raise the Validate_Enabled exception
92: --
93: if p_validate then

Line 102: hr_utility.set_location(' Leaving:'||l_proc, 70);

98: --
99: p_routing_list_id := l_routing_list_id;
100: p_object_version_number := l_object_version_number;
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 70);
103: --
104: exception
105: --
106: when hr_api.validate_enabled then

Line 119: hr_utility.set_location(' Leaving:'||l_proc, 80);

115: -- when validation only mode is being used.)
116: --
117: p_routing_list_id := null;
118: p_object_version_number := null;
119: hr_utility.set_location(' Leaving:'||l_proc, 80);
120: --
121: when others then
122: p_routing_list_id := null;
123: p_object_version_number := null;

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

146: l_object_version_number pqh_routing_lists.object_version_number%TYPE;
147: --
148: begin
149: --
150: hr_utility.set_location('Entering:'|| l_proc, 10);
151: --
152: -- Issue a savepoint if operating in validation only mode
153: --
154: savepoint update_routing_list;

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

152: -- Issue a savepoint if operating in validation only mode
153: --
154: savepoint update_routing_list;
155: --
156: hr_utility.set_location(l_proc, 20);
157: --
158: -- Process Logic
159: --
160: l_object_version_number := p_object_version_number;

Line 214: hr_utility.set_location(l_proc, 60);

210: -- End of API User Hook for the after hook of update_routing_list
211: --
212: end;
213: --
214: hr_utility.set_location(l_proc, 60);
215: --
216: -- When in validation only mode raise the Validate_Enabled exception
217: --
218: if p_validate then

Line 226: hr_utility.set_location(' Leaving:'||l_proc, 70);

222: -- Set all output arguments
223: --
224: p_object_version_number := l_object_version_number;
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 70);
227: --
228: exception
229: --
230: when hr_api.validate_enabled then

Line 241: hr_utility.set_location(' Leaving:'||l_proc, 80);

237: -- Only set output warning arguments
238: -- (Any key or derived arguments must be set to null
239: -- when validation only mode is being used.)
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 80);
242: --
243: when others then
244: p_object_version_number := l_object_version_number;
245: --

Line 274: hr_utility.set_location('Entering:'|| l_proc, 10);

270: where routing_list_id = p_routing_list_id;
271: --
272: begin
273: --
274: hr_utility.set_location('Entering:'|| l_proc, 10);
275: --
276: -- Issue a savepoint if operating in validation only mode
277: --
278: savepoint delete_routing_list;

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

276: -- Issue a savepoint if operating in validation only mode
277: --
278: savepoint delete_routing_list;
279: --
280: hr_utility.set_location(l_proc, 20);
281: --
282: -- Process Logic
283: --
284: l_object_version_number := p_object_version_number;

Line 343: hr_utility.set_location(l_proc, 60);

339: -- End of API User Hook for the after hook of delete_routing_list
340: --
341: end;
342: --
343: hr_utility.set_location(l_proc, 60);
344: --
345: -- When in validation only mode raise the Validate_Enabled exception
346: --
347: if p_validate then

Line 351: hr_utility.set_location(' Leaving:'||l_proc, 70);

347: if p_validate then
348: raise hr_api.validate_enabled;
349: end if;
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 70);
352: --
353: exception
354: --
355: when hr_api.validate_enabled then

Line 393: hr_utility.set_location('Entering:'|| l_proc, 10);

389: l_proc varchar2(72) := g_package||'lck';
390: --
391: begin
392: --
393: hr_utility.set_location('Entering:'|| l_proc, 10);
394: --
395: pqh_rlt_shd.lck
396: (
397: p_routing_list_id => p_routing_list_id

Line 401: hr_utility.set_location(' Leaving:'||l_proc, 70);

397: p_routing_list_id => p_routing_list_id
398: ,p_object_version_number => p_object_version_number
399: );
400: --
401: hr_utility.set_location(' Leaving:'||l_proc, 70);
402: --
403: end lck;
404: --
405: end PQH_ROUTING_LISTS_api;