DBA Data[Home] [Help]

APPS.HXC_APPROVAL_PERIOD_SETS_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_sets_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_approval_period_sets >-----------------|
11: -- ----------------------------------------------------------------------------

Line 30: g_debug:=hr_utility.debug_enabled;

26: l_approval_period_set_id hxc_approval_period_sets.approval_period_set_id%TYPE;
27: --
28: Begin
29: --
30: g_debug:=hr_utility.debug_enabled;
31: if g_debug then
32: l_proc := g_package||'create_approval_period_sets';
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: end if;--

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

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

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

36: --
37: savepoint create_approval_period_sets;
38: --
39: if g_debug then
40: hr_utility.set_location(l_proc, 20);
41: end if;
42: --
43: -- Truncate the time portion from all IN date parameters
44: --

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

61: );
62: end;
63: --
64: if g_debug then
65: hr_utility.set_location(l_proc, 30);
66: end if;
67: --
68:
69: --

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

75: --
76: -- Process Logic
77: --
78: if g_debug then
79: hr_utility.set_location(l_proc, 40);
80: end if;
81: --
82: -- call row handler
83: --

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

87: ,p_object_version_number => l_object_version_number
88: );
89: --
90: if g_debug then
91: hr_utility.set_location(l_proc, 50);
92: end if;
93: --
94: -- Call After Process User Hook
95: --

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

108: );
109: end;
110: --
111: if g_debug then
112: hr_utility.set_location(l_proc, 60);
113: end if;
114: --
115: --
116: -- When in validation only mode raise the Validate_Enabled exception

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

119: raise hr_api.validate_enabled;
120: end if;
121: --
122: --if g_debug then
123: --hr_utility.set_location(' Leaving:'||l_proc, 70);
124: --end if;
125: --
126: --
127: -- Set all output arguments

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

129: p_approval_period_set_id := l_approval_period_set_id;
130: p_object_version_number := l_object_version_number;
131: --
132: if g_debug then
133: hr_utility.set_location(' Leaving:'||l_proc, 70);
134: end if;
135: exception
136: when hr_api.validate_enabled then
137: --

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

146: --
147: p_approval_period_set_id := null;
148: p_object_version_number := null;
149: if g_debug then
150: hr_utility.set_location(' Leaving:'||l_proc, 80);
151: end if;
152: when others then
153: --
154: -- A validation or unexpected error has occured

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

154: -- A validation or unexpected error has occured
155: --
156: rollback to create_approval_period_sets;
157: if g_debug then
158: hr_utility.set_location(' Leaving:'||l_proc, 90);
159: end if;
160: raise;
161: --
162: end create_approval_period_sets;

Line 183: g_debug:=hr_utility.debug_enabled;

179: l_proc varchar2(72);
180: l_object_version_number hxc_approval_period_sets.object_version_number%TYPE := p_object_version_number;
181: --
182: Begin
183: g_debug:=hr_utility.debug_enabled;
184: --
185: if g_debug then
186: l_proc := g_package||' update_approval_period_sets';
187: hr_utility.set_location('Entering:'|| l_proc, 10);

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

183: g_debug:=hr_utility.debug_enabled;
184: --
185: if g_debug then
186: l_proc := g_package||' update_approval_period_sets';
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: end if;
189: --
190: -- Issue a savepoint if operating in validation only mode
191: --

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

191: --
192: savepoint update_approval_period_sets;
193: --
194: if g_debug then
195: hr_utility.set_location(l_proc, 20);
196: end if;
197: --
198: -- Call Before Process User Hook
199: --

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

212: );
213: end;
214: --
215: --if g_debug then
216: --hr_utility.set_location(l_proc, 30);
217: --end if;
218: --
219: -- Process Logic
220: --

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

227: );
228: --
229: --
230: if g_debug then
231: hr_utility.set_location(l_proc, 40);
232: end if;
233: --
234: -- Call After Process User Hook
235: --

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

248: );
249: end;
250: --
251: if g_debug then
252: hr_utility.set_location(l_proc, 50);
253: end if;
254: --
255: -- When in validation only mode raise the Validate_Enabled exception
256: --

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

258: raise hr_api.validate_enabled;
259: end if;
260: --
261: if g_debug then
262: hr_utility.set_location(' Leaving:'||l_proc, 60);
263: end if;
264: --
265: -- Set all output arguments
266: --

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

281: --
282: p_object_version_number := null;
283: --
284: if g_debug then
285: hr_utility.set_location(' Leaving:'||l_proc, 60);
286: end if;
287: --
288: when others then
289: --

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

290: -- A validation or unexpected error has occured
291: --
292: ROLLBACK TO update_approval_period_sets;
293: if g_debug then
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: end if;
296: raise;
297: --
298: END update_approval_period_sets;

Line 315: g_debug:=hr_utility.debug_enabled;

311: --
312: l_proc varchar2(72);
313: --
314: begin
315: g_debug:=hr_utility.debug_enabled;
316: --
317: if g_debug then
318: l_proc := g_package||'delete_approval_period_sets';
319: hr_utility.set_location('Entering:'|| l_proc, 10);

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

315: g_debug:=hr_utility.debug_enabled;
316: --
317: if g_debug then
318: l_proc := g_package||'delete_approval_period_sets';
319: hr_utility.set_location('Entering:'|| l_proc, 10);
320: end if;
321: --
322: -- Issue a savepoint if operating in validation only mode
323: --

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

323: --
324: savepoint delete_approval_period_sets;
325: --
326: if g_debug then
327: hr_utility.set_location(l_proc, 20);
328: end if;
329: --
330: -- Call Before Process User Hook
331: --

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

343: );
344: end;
345: --
346: if g_debug then
347: hr_utility.set_location(l_proc, 30);
348: end if;
349: --
350: -- Process Logic
351: --

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

355: ,p_object_version_number => p_object_version_number
356: );
357: --
358: if g_debug then
359: hr_utility.set_location(l_proc, 40);
360: end if;
361: --
362: -- Call After Process User Hook
363: --

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

381: raise hr_api.validate_enabled;
382: end if;
383: --
384: if g_debug then
385: hr_utility.set_location(' Leaving:'||l_proc, 50);
386: end if;
387: --
388: exception
389: --