eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_ROUTING_CATEGORIES_API dependencies on HR_UTILITY

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

33: l_object_version_number pqh_routing_categories.object_version_number%TYPE;
34: --
35: begin
36: --
37: hr_utility.set_location('Entering:'|| l_proc, 10);
38: --
39: -- Issue a savepoint if operating in validation only mode
40: --
41: savepoint create_ROUTING_CATEGORY;

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

39: -- Issue a savepoint if operating in validation only mode
40: --
41: savepoint create_ROUTING_CATEGORY;
42: --
43: hr_utility.set_location(l_proc, 20);
44: --
45: -- Process Logic
46: --
47: begin

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

121: -- End of API User Hook for the after hook of create_ROUTING_CATEGORY
122: --
123: end;
124: --
125: hr_utility.set_location(l_proc, 60);
126: --
127: -- When in validation only mode raise the Validate_Enabled exception
128: --
129: if p_validate then

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

134: --
135: p_routing_category_id := l_routing_category_id;
136: p_object_version_number := l_object_version_number;
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 70);
139: --
140: exception
141: --
142: when hr_api.validate_enabled then

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

151: -- when validation only mode is being used.)
152: --
153: p_routing_category_id := null;
154: p_object_version_number := null;
155: hr_utility.set_location(' Leaving:'||l_proc, 80);
156: --
157: when others then
158: p_routing_category_id := null;
159: p_object_version_number := null;

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

192: l_object_version_number pqh_routing_categories.object_version_number%TYPE;
193: --
194: begin
195: --
196: hr_utility.set_location('Entering:'|| l_proc, 10);
197: --
198: -- Issue a savepoint if operating in validation only mode
199: --
200: savepoint update_ROUTING_CATEGORY;

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

198: -- Issue a savepoint if operating in validation only mode
199: --
200: savepoint update_ROUTING_CATEGORY;
201: --
202: hr_utility.set_location(l_proc, 20);
203: --
204: -- Process Logic
205: --
206: l_object_version_number := p_object_version_number;

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

286: -- End of API User Hook for the after hook of update_ROUTING_CATEGORY
287: --
288: end;
289: --
290: hr_utility.set_location(l_proc, 60);
291: --
292: -- When in validation only mode raise the Validate_Enabled exception
293: --
294: if p_validate then

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

298: -- Set all output arguments
299: --
300: p_object_version_number := l_object_version_number;
301: --
302: hr_utility.set_location(' Leaving:'||l_proc, 70);
303: --
304: exception
305: --
306: when hr_api.validate_enabled then

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

313: -- Only set output warning arguments
314: -- (Any key or derived arguments must be set to null
315: -- when validation only mode is being used.)
316: --
317: hr_utility.set_location(' Leaving:'||l_proc, 80);
318: --
319: when others then
320: p_object_version_number := l_object_version_number;
321: --

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

343: l_object_version_number pqh_routing_categories.object_version_number%TYPE;
344: --
345: begin
346: --
347: hr_utility.set_location('Entering:'|| l_proc, 10);
348: --
349: -- Issue a savepoint if operating in validation only mode
350: --
351: savepoint delete_ROUTING_CATEGORY;

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

349: -- Issue a savepoint if operating in validation only mode
350: --
351: savepoint delete_ROUTING_CATEGORY;
352: --
353: hr_utility.set_location(l_proc, 20);
354: --
355: -- Process Logic
356: --
357: l_object_version_number := p_object_version_number;

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

408: -- End of API User Hook for the after hook of delete_ROUTING_CATEGORY
409: --
410: end;
411: --
412: hr_utility.set_location(l_proc, 60);
413: --
414: -- When in validation only mode raise the Validate_Enabled exception
415: --
416: if p_validate then

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

416: if p_validate then
417: raise hr_api.validate_enabled;
418: end if;
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --
422: exception
423: --
424: when hr_api.validate_enabled then

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

458: l_proc varchar2(72) := g_package||'lck';
459: --
460: begin
461: --
462: hr_utility.set_location('Entering:'|| l_proc, 10);
463: --
464: pqh_rct_shd.lck
465: (
466: p_routing_category_id => p_routing_category_id

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

466: p_routing_category_id => p_routing_category_id
467: ,p_object_version_number => p_object_version_number
468: );
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 70);
471: --
472: end lck;
473: --
474: ------------------------------------------------------------------------------

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

489: l_proc varchar2(72) := g_package||'disable_routing_categories';
490: --
491: Begin
492: --
493: hr_utility.set_location('Entering:'|| l_proc, 10);
494: --
495: sql_stmt := 'Select routing_category_id,object_version_number from pqh_routing_categories where transaction_category_id = :t';
496: --
497: -- Select only the routing categories that belong to the current routing

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

532: );
533: --
534: End loop;
535: --
536: hr_utility.set_location('Leaving:'|| l_proc, 70);
537: --
538: End;
539: --
540: --