DBA Data[Home] [Help]

APPS.HXC_APPROVAL_PERIOD_COMPS_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_approval_period_comps_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_approval_period_comps >----------------|
11: -- ----------------------------------------------------------------------------

Line 32: g_debug:=hr_utility.debug_enabled;

28: l_approval_period_comp_id hxc_approval_period_comps.approval_period_comp_id%TYPE;
29: --
30: Begin
31: --
32: g_debug:=hr_utility.debug_enabled;
33: if g_debug then
34: l_proc := g_package||'create_approval_period_comps';
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_approval_period_comps';
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_approval_period_comps;
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_approval_period_comp_id := l_approval_period_comp_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_approval_period_comp_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_approval_period_comps;
167: if g_debug then
168: hr_utility.set_location(' Leaving:'||l_proc, 90);
169: end if;
170: raise;
171: --
172: end create_approval_period_comps;

Line 196: g_debug:=hr_utility.debug_enabled;

192: l_object_version_number hxc_approval_period_comps.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_approval_period_comps';
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_approval_period_comps';
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_approval_period_comps;
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_approval_period_comps;
331: if g_debug then
332: hr_utility.set_location(' Leaving:'||l_proc, 70);
333: end if;
334: raise;
335: --
336: END update_approval_period_comps;

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_approval_period_comps';
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_approval_period_comps';
357: hr_utility.set_location('Entering:'|| l_proc, 10);
358: end if;--
359: -- Issue a savepoint if operating in validation only mode
360: --
361: savepoint delete_approval_period_comps;

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

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

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

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

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

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

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

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