DBA Data[Home] [Help]

APPS.HXC_RETRIEVAL_RULE_COMPS_API dependencies on HR_UTILITY

Line 8: g_debug boolean := hr_utility.debug_enabled;

4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_retrieval_rule_comps_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< create_retrieval_rule_comps >------------------|
12: -- ----------------------------------------------------------------------------

Line 32: g_debug := hr_utility.debug_enabled;

28: l_object_version_number hxc_retrieval_rule_comps.object_version_number%TYPE;
29: l_retrieval_rule_comp_id hxc_retrieval_rule_comps.retrieval_rule_comp_id%TYPE;
30: --
31: Begin
32: g_debug := hr_utility.debug_enabled;
33: --
34: if g_debug then
35: l_proc := g_package||'create_retrieval_rule_comps ';
36: hr_utility.set_location('Entering:'|| l_proc, 10);

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

32: g_debug := hr_utility.debug_enabled;
33: --
34: if g_debug then
35: l_proc := g_package||'create_retrieval_rule_comps ';
36: hr_utility.set_location('Entering:'|| l_proc, 10);
37: end if;
38: --
39: -- Issue a savepoint
40: --

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

40: --
41: savepoint create_retrieval_rule_comps;
42: --
43: if g_debug then
44: hr_utility.set_location(l_proc, 20);
45: end if;
46: --
47: -- Truncate the time portion from all IN date parameters
48: --

Line 71: hr_utility.set_location(l_proc, 30);

67: );
68: end;
69: --
70: if g_debug then
71: hr_utility.set_location(l_proc, 30);
72: end if;
73: --
74:
75: --

Line 85: hr_utility.set_location(l_proc, 40);

81: --
82: -- Process Logic
83: --
84: if g_debug then
85: hr_utility.set_location(l_proc, 40);
86: end if;
87: --
88: -- call row handler
89: --

Line 100: hr_utility.set_location(l_proc, 50);

96: ,p_object_version_number => l_object_version_number
97: );
98: --
99: if g_debug then
100: hr_utility.set_location(l_proc, 50);
101: end if;
102: --
103: -- Call After Process User Hook
104: --

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

119: );
120: end;
121: --
122: if g_debug then
123: hr_utility.set_location(l_proc, 60);
124: end if;
125: --
126: --
127: -- When in validation only mode raise the Validate_Enabled exception

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

130: raise hr_api.validate_enabled;
131: end if;
132: --
133: --if g_debug then
134: --hr_utility.set_location(' Leaving:'||l_proc, 70);
135: --end if;
136: --
137: --
138: -- Set all output arguments

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

140: p_retrieval_rule_comp_id := l_retrieval_rule_comp_id;
141: p_object_version_number := l_object_version_number;
142: --
143: if g_debug then
144: hr_utility.set_location(' Leaving:'||l_proc, 70);
145: end if;
146: exception
147: when hr_api.validate_enabled then
148: --

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

157: --
158: p_retrieval_rule_comp_id := null;
159: p_object_version_number := null;
160: if g_debug then
161: hr_utility.set_location(' Leaving:'||l_proc, 80);
162: end if;
163: when others then
164: --
165: -- A validation or unexpected error has occured

Line 169: hr_utility.set_location(' Leaving:'||l_proc, 90);

165: -- A validation or unexpected error has occured
166: --
167: rollback to create_retrieval_rule_comps;
168: if g_debug then
169: hr_utility.set_location(' Leaving:'||l_proc, 90);
170: end if;
171: raise;
172: --
173: end create_retrieval_rule_comps;

Line 196: g_debug := hr_utility.debug_enabled;

192: l_proc varchar2(72);
193: l_object_version_number hxc_retrieval_rule_comps.object_version_number%TYPE := p_object_version_number;
194: --
195: Begin
196: g_debug := hr_utility.debug_enabled;
197: --
198: if g_debug then
199: l_proc := g_package||' update_retrieval_rule_comps';
200: hr_utility.set_location('Entering:'|| l_proc, 10);

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

196: g_debug := hr_utility.debug_enabled;
197: --
198: if g_debug then
199: l_proc := g_package||' update_retrieval_rule_comps';
200: hr_utility.set_location('Entering:'|| l_proc, 10);
201: end if;
202: --
203: -- Issue a savepoint if operating in validation only mode
204: --

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

204: --
205: savepoint update_retrieval_rule_comps;
206: --
207: if g_debug then
208: hr_utility.set_location(l_proc, 20);
209: end if;
210: --
211: -- Call Before Process User Hook
212: --

Line 231: --hr_utility.set_location(l_proc, 30);

227: );
228: end;
229: --
230: --if g_debug then
231: --hr_utility.set_location(l_proc, 30);
232: --end if;
233: --
234: -- Process Logic
235: --

Line 248: hr_utility.set_location(l_proc, 40);

244: ,p_time_recipient_id => p_time_recipient_id
245: );
246: --
247: if g_debug then
248: hr_utility.set_location(l_proc, 40);
249: end if;
250: --
251: -- Call After Process User Hook
252: --

Line 271: hr_utility.set_location(l_proc, 50);

267: );
268: end;
269: --
270: if g_debug then
271: hr_utility.set_location(l_proc, 50);
272: end if;
273: --
274: -- When in validation only mode raise the Validate_Enabled exception
275: --

Line 281: hr_utility.set_location(' Leaving:'||l_proc, 60);

277: raise hr_api.validate_enabled;
278: end if;
279: --
280: if g_debug then
281: hr_utility.set_location(' Leaving:'||l_proc, 60);
282: end if;
283: --
284: -- Set all output arguments
285: --

Line 305: hr_utility.set_location(' Leaving:'||l_proc, 60);

301: --
302: p_object_version_number := null;
303: --
304: if g_debug then
305: hr_utility.set_location(' Leaving:'||l_proc, 60);
306: end if;
307: --
308: when others then
309: --

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

310: -- A validation or unexpected error has occured
311: --
312: ROLLBACK TO update_retrieval_rule_comps;
313: if g_debug then
314: hr_utility.set_location(' Leaving:'||l_proc, 70);
315: end if;
316: raise;
317: --
318: END update_retrieval_rule_comps;

Line 335: g_debug := hr_utility.debug_enabled;

331: --
332: l_proc varchar2(72);
333: --
334: begin
335: g_debug := hr_utility.debug_enabled;
336: --
337: if g_debug then
338: l_proc := g_package||'delete_retrieval_rule_comps';
339: hr_utility.set_location('Entering:'|| l_proc, 10);

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

335: g_debug := hr_utility.debug_enabled;
336: --
337: if g_debug then
338: l_proc := g_package||'delete_retrieval_rule_comps';
339: hr_utility.set_location('Entering:'|| l_proc, 10);
340: end if;
341: --
342: -- Issue a savepoint if operating in validation only mode
343: --

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

343: --
344: savepoint delete_retrieval_rule_comps;
345: --
346: if g_debug then
347: hr_utility.set_location(l_proc, 20);
348: end if;
349: --
350: -- Call Before Process User Hook
351: --

Line 367: hr_utility.set_location(l_proc, 30);

363: );
364: end;
365: --
366: if g_debug then
367: hr_utility.set_location(l_proc, 30);
368: end if;
369: --
370: -- Process Logic
371: --

Line 379: hr_utility.set_location(l_proc, 40);

375: ,p_object_version_number => p_object_version_number
376: );
377: --
378: if g_debug then
379: hr_utility.set_location(l_proc, 40);
380: end if;
381: --
382: -- Call After Process User Hook
383: --

Line 405: hr_utility.set_location(' Leaving:'||l_proc, 50);

401: raise hr_api.validate_enabled;
402: end if;
403: --
404: if g_debug then
405: hr_utility.set_location(' Leaving:'||l_proc, 50);
406: end if;
407: --
408: exception
409: --

Line 499: g_debug := hr_utility.debug_enabled;

495: --
496: l_error varchar2(5) := NULL;
497: --
498: BEGIN
499: g_debug := hr_utility.debug_enabled;
500: if g_debug then
501: l_proc := g_package||'chk_retr_as_unique';
502: hr_utility.set_location('Entering:'||l_proc, 5);
503: end if;

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

498: BEGIN
499: g_debug := hr_utility.debug_enabled;
500: if g_debug then
501: l_proc := g_package||'chk_retr_as_unique';
502: hr_utility.set_location('Entering:'||l_proc, 5);
503: end if;
504: --
505: -- check that there is no other similat retrieval rule in the system
506: --

Line 514: hr_utility.set_message(809, 'HXC_RETR_AS_NOT_UNIQUE');

510: --
511: IF l_error IS NOT NULL
512: THEN
513: --
514: hr_utility.set_message(809, 'HXC_RETR_AS_NOT_UNIQUE');
515: hr_utility.raise_error;
516: --
517: END IF;
518: --

Line 515: hr_utility.raise_error;

511: IF l_error IS NOT NULL
512: THEN
513: --
514: hr_utility.set_message(809, 'HXC_RETR_AS_NOT_UNIQUE');
515: hr_utility.raise_error;
516: --
517: END IF;
518: --
519: if g_debug then

Line 520: hr_utility.set_location('Leaving:'||l_proc, 20);

516: --
517: END IF;
518: --
519: if g_debug then
520: hr_utility.set_location('Leaving:'||l_proc, 20);
521: end if;
522: --
523: END chk_retr_as_unique;
524: --