DBA Data[Home] [Help]

APPS.HXC_DATA_APP_RULE_USAGES_API dependencies on HR_UTILITY

Line 7: g_debug boolean :=hr_utility.debug_enabled;

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

Line 32: g_debug:=hr_utility.debug_enabled;

28: l_data_app_rule_usage_id hxc_data_app_rule_usages.data_app_rule_usage_id%TYPE;
29: --
30: Begin
31: --
32: g_debug:=hr_utility.debug_enabled;
33: if g_debug then
34: l_proc := g_package||'create_data_app_rule_usages';
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: end if;

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

31: --
32: g_debug:=hr_utility.debug_enabled;
33: if g_debug then
34: l_proc := g_package||'create_data_app_rule_usages';
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_data_app_rule_usages;
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 70: hr_utility.set_location(l_proc, 30);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 196: g_debug:=hr_utility.debug_enabled;

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

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

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

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

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

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

228: --
229: --insert into mtemp values('out of comp_b');
230: --commit;
231: --if g_debug then
232: --hr_utility.set_location(l_proc, 30);
233: --end if;
234: --
235: -- Process Logic
236: --

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

251: --insert into mtemp values('out of hax_hac_upd');
252: --commit;
253:
254: if g_debug then
255: hr_utility.set_location(l_proc, 40);
256: end if;
257: --
258: -- Call After Process User Hook
259: --

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

277: --insert into mtemp values('out of comp_a');
278: --commit;
279:
280: if g_debug then
281: hr_utility.set_location(l_proc, 50);
282: end if;
283: --
284: -- When in validation only mode raise the Validate_Enabled exception
285: --

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

287: raise hr_api.validate_enabled;
288: end if;
289: --
290: if g_debug then
291: hr_utility.set_location(' Leaving:'||l_proc, 60);
292: end if;
293: --
294: -- Set all output arguments
295: --

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

319: --insert into mtemp values('OVN set to null');
320: --commit;
321:
322: if g_debug then
323: hr_utility.set_location(' Leaving:'||l_proc, 60);
324: end if;
325: --
326: when others then
327: --

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

328: -- A validation or unexpected error has occured
329: --
330: ROLLBACK TO update_data_app_rule_usages;
331: if g_debug then
332: hr_utility.set_location(' Leaving:'||l_proc, 70);
333: end if;
334: raise;
335: --
336: END update_data_app_rule_usages;

Line 354: g_debug:=hr_utility.debug_enabled;

350: l_proc varchar2(72);
351: --
352: begin
353: --
354: g_debug:=hr_utility.debug_enabled;
355: if g_debug then
356: l_proc := g_package||'delete_data_app_rule_usages';
357: hr_utility.set_location('Entering:'|| l_proc, 10);
358: end if;

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

353: --
354: g_debug:=hr_utility.debug_enabled;
355: if g_debug then
356: l_proc := g_package||'delete_data_app_rule_usages';
357: hr_utility.set_location('Entering:'|| l_proc, 10);
358: end if;
359: --
360: -- Issue a savepoint if operating in validation only mode
361: --

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

361: --
362: savepoint delete_data_app_rule_usages;
363: --
364: if g_debug then
365: hr_utility.set_location(l_proc, 20);
366: end if;
367: --
368: -- Call Before Process User Hook
369: --

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

381: );
382: end;
383: --
384: if g_debug then
385: hr_utility.set_location(l_proc, 30);
386: end if;
387: --
388: -- Process Logic
389: --

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

393: ,p_object_version_number => p_object_version_number
394: );
395: --
396: if g_debug then
397: hr_utility.set_location(l_proc, 40);
398: end if;
399: --
400: -- Call After Process User Hook
401: --

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

419: raise hr_api.validate_enabled;
420: end if;
421: --
422: if g_debug then
423: hr_utility.set_location(' Leaving:'||l_proc, 50);
424: end if;
425: --
426: exception
427: --