DBA Data[Home] [Help]

APPS.PQH_ROUTING_HISTORY_API dependencies on HR_UTILITY

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

44: l_object_version_number pqh_routing_history.object_version_number%TYPE;
45: --
46: begin
47: --
48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: --
50: -- Issue a savepoint if operating in validation only mode
51: --
52: savepoint create_routing_history;

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

50: -- Issue a savepoint if operating in validation only mode
51: --
52: savepoint create_routing_history;
53: --
54: hr_utility.set_location(l_proc, 20);
55: --
56: -- Process Logic
57: --
58: begin

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

165: -- End of API User Hook for the after hook of create_routing_history
166: --
167: end;
168: --
169: hr_utility.set_location(l_proc, 60);
170: --
171: -- When in validation only mode raise the Validate_Enabled exception
172: --
173: if p_validate then

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

178: --
179: p_routing_history_id := l_routing_history_id;
180: p_object_version_number := l_object_version_number;
181: --
182: hr_utility.set_location(' Leaving:'||l_proc, 70);
183: --
184: exception
185: --
186: when hr_api.validate_enabled then

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

195: -- when validation only mode is being used.)
196: --
197: p_routing_history_id := null;
198: p_object_version_number := null;
199: hr_utility.set_location(' Leaving:'||l_proc, 80);
200: --
201: when others then
202: p_routing_history_id := null;
203: p_object_version_number := null;

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

246: l_object_version_number pqh_routing_history.object_version_number%TYPE;
247: --
248: begin
249: --
250: hr_utility.set_location('Entering:'|| l_proc, 10);
251: --
252: -- Issue a savepoint if operating in validation only mode
253: --
254: savepoint update_routing_history;

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

252: -- Issue a savepoint if operating in validation only mode
253: --
254: savepoint update_routing_history;
255: --
256: hr_utility.set_location(l_proc, 20);
257: --
258: -- Process Logic
259: --
260: l_object_version_number := p_object_version_number;

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

370: -- End of API User Hook for the after hook of update_routing_history
371: --
372: end;
373: --
374: hr_utility.set_location(l_proc, 60);
375: --
376: -- When in validation only mode raise the Validate_Enabled exception
377: --
378: if p_validate then

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

382: -- Set all output arguments
383: --
384: p_object_version_number := l_object_version_number;
385: --
386: hr_utility.set_location(' Leaving:'||l_proc, 70);
387: --
388: exception
389: --
390: when hr_api.validate_enabled then

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

397: -- Only set output warning arguments
398: -- (Any key or derived arguments must be set to null
399: -- when validation only mode is being used.)
400: --
401: hr_utility.set_location(' Leaving:'||l_proc, 80);
402: --
403: when others then
404: p_object_version_number := l_object_version_number;
405: --

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

426: l_object_version_number pqh_routing_history.object_version_number%TYPE;
427: --
428: begin
429: --
430: hr_utility.set_location('Entering:'|| l_proc, 10);
431: --
432: -- Issue a savepoint if operating in validation only mode
433: --
434: savepoint delete_routing_history;

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

432: -- Issue a savepoint if operating in validation only mode
433: --
434: savepoint delete_routing_history;
435: --
436: hr_utility.set_location(l_proc, 20);
437: --
438: -- Process Logic
439: --
440: l_object_version_number := p_object_version_number;

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

497: -- End of API User Hook for the after hook of delete_routing_history
498: --
499: end;
500: --
501: hr_utility.set_location(l_proc, 60);
502: --
503: -- When in validation only mode raise the Validate_Enabled exception
504: --
505: if p_validate then

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

505: if p_validate then
506: raise hr_api.validate_enabled;
507: end if;
508: --
509: hr_utility.set_location(' Leaving:'||l_proc, 70);
510: --
511: exception
512: --
513: when hr_api.validate_enabled then

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

547: l_proc varchar2(72) := g_package||'lck';
548: --
549: begin
550: --
551: hr_utility.set_location('Entering:'|| l_proc, 10);
552: --
553: pqh_rht_shd.lck
554: (
555: p_routing_history_id => p_routing_history_id

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

555: p_routing_history_id => p_routing_history_id
556: ,p_object_version_number => p_object_version_number
557: );
558: --
559: hr_utility.set_location(' Leaving:'||l_proc, 70);
560: --
561: end lck;
562: --
563: --

Line 655: hr_utility.set_location(' Inserting Into pqh_routing_hist_attribs: '||l_proc, 5);

651:
652: FOR i in NVL(p_rha_tab.FIRST,0)..NVL(p_rha_tab.LAST,-1)
653: LOOP
654:
655: hr_utility.set_location(' Inserting Into pqh_routing_hist_attribs: '||l_proc, 5);
656:
657:
658:
659: pqh_routing_hist_attrib_api.create_routing_hist_attrib

Line 679: hr_utility.set_location(' Done Inserting Into pqh_routing_hist_attribs: '||l_routing_hist_attrib_id, 7);

675: ,p_value_char => p_rha_tab(i).value_char
676: ,p_effective_date => p_effective_date
677: );
678:
679: hr_utility.set_location(' Done Inserting Into pqh_routing_hist_attribs: '||l_routing_hist_attrib_id, 7);
680:
681: END LOOP;
682:
683: