DBA Data[Home] [Help]

APPS.HXC_RETRIEVAL_RULES_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_rules_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< create_retrieval_rules >-----------------------|
12: -- ----------------------------------------------------------------------------

Line 31: g_debug := hr_utility.debug_enabled;

27: l_object_version_number hxc_retrieval_rules.object_version_number%TYPE;
28: l_retrieval_rule_id hxc_retrieval_rules.retrieval_rule_id%TYPE;
29: --
30: Begin
31: g_debug := hr_utility.debug_enabled;
32: --
33: if g_debug then
34: l_proc := g_package||'create_retrieval_rules ';
35: hr_utility.set_location('Entering:'|| l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

115: );
116: end;
117: --
118: if g_debug then
119: hr_utility.set_location(l_proc, 60);
120: end if;
121: --
122: --
123: -- When in validation only mode raise the Validate_Enabled exception

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

126: raise hr_api.validate_enabled;
127: end if;
128: --
129: --if g_debug then
130: --hr_utility.set_location(' Leaving:'||l_proc, 70);
131: --end if;
132: --
133: --
134: -- Set all output arguments

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

136: p_retrieval_rule_id := l_retrieval_rule_id;
137: p_object_version_number := l_object_version_number;
138: --
139: if g_debug then
140: hr_utility.set_location(' Leaving:'||l_proc, 70);
141: end if;
142: exception
143: when hr_api.validate_enabled then
144: --

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

153: --
154: p_retrieval_rule_id := null;
155: p_object_version_number := null;
156: if g_debug then
157: hr_utility.set_location(' Leaving:'||l_proc, 80);
158: end if;
159: when others then
160: --
161: -- A validation or unexpected error has occured

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

161: -- A validation or unexpected error has occured
162: --
163: rollback to create_retrieval_rules;
164: if g_debug then
165: hr_utility.set_location(' Leaving:'||l_proc, 90);
166: end if;
167: raise;
168: --
169: end create_retrieval_rules;

Line 191: g_debug := hr_utility.debug_enabled;

187: l_proc varchar2(72);
188: l_object_version_number hxc_retrieval_rules.object_version_number%TYPE := p_object_version_number;
189: --
190: Begin
191: g_debug := hr_utility.debug_enabled;
192: --
193: if g_debug then
194: l_proc := g_package||' update_retrieval_rules';
195: hr_utility.set_location('Entering:'|| l_proc, 10);

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

191: g_debug := hr_utility.debug_enabled;
192: --
193: if g_debug then
194: l_proc := g_package||' update_retrieval_rules';
195: hr_utility.set_location('Entering:'|| l_proc, 10);
196: end if;
197: --
198: -- Issue a savepoint if operating in validation only mode
199: --

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

199: --
200: savepoint update_retrieval_rules;
201: --
202: if g_debug then
203: hr_utility.set_location(l_proc, 20);
204: end if;
205: --
206: -- Call Before Process User Hook
207: --

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

221: );
222: end;
223: --
224: --if g_debug then
225: --hr_utility.set_location(l_proc, 30);
226: --end if;
227: --
228: -- Process Logic
229: --

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

237: ,p_name => p_name
238: );
239: --
240: if g_debug then
241: hr_utility.set_location(l_proc, 40);
242: end if;
243: --
244: -- Call After Process User Hook
245: --

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

259: );
260: end;
261: --
262: if g_debug then
263: hr_utility.set_location(l_proc, 50);
264: end if;
265: --
266: -- When in validation only mode raise the Validate_Enabled exception
267: --

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

269: raise hr_api.validate_enabled;
270: end if;
271: --
272: if g_debug then
273: hr_utility.set_location(' Leaving:'||l_proc, 60);
274: end if;
275: --
276: -- Set all output arguments
277: --

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

293: --
294: p_object_version_number := null;
295: --
296: if g_debug then
297: hr_utility.set_location(' Leaving:'||l_proc, 60);
298: end if;
299: --
300: when others then
301: --

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

302: -- A validation or unexpected error has occured
303: --
304: ROLLBACK TO update_retrieval_rules;
305: if g_debug then
306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: end if;
308: raise;
309: --
310: END update_retrieval_rules;

Line 327: g_debug := hr_utility.debug_enabled;

323: --
324: l_proc varchar2(72);
325: --
326: begin
327: g_debug := hr_utility.debug_enabled;
328: --
329: if g_debug then
330: l_proc := g_package||'delete_retrieval_rules';
331: hr_utility.set_location('Entering:'|| l_proc, 10);

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

327: g_debug := hr_utility.debug_enabled;
328: --
329: if g_debug then
330: l_proc := g_package||'delete_retrieval_rules';
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: end if;
333: --
334: -- Issue a savepoint if operating in validation only mode
335: --

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

335: --
336: savepoint delete_retrieval_rules;
337: --
338: if g_debug then
339: hr_utility.set_location(l_proc, 20);
340: end if;
341: --
342: -- Call Before Process User Hook
343: --

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

355: );
356: end;
357: --
358: if g_debug then
359: hr_utility.set_location(l_proc, 30);
360: end if;
361: --
362: -- Process Logic
363: --

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

367: ,p_object_version_number => p_object_version_number
368: );
369: --
370: if g_debug then
371: hr_utility.set_location(l_proc, 40);
372: end if;
373: --
374: -- Call After Process User Hook
375: --

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

393: raise hr_api.validate_enabled;
394: end if;
395: --
396: if g_debug then
397: hr_utility.set_location(' Leaving:'||l_proc, 50);
398: end if;
399: --
400: exception
401: --