DBA Data[Home] [Help]

APPS.HXC_APPROVAL_STYLES_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_styles_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_approval_styles >----------------------|
11: -- ----------------------------------------------------------------------------

Line 36: g_debug:=hr_utility.debug_enabled;

32: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
33: --
34: Begin
35: --
36: g_debug:=hr_utility.debug_enabled;
37: if g_debug then
38: l_proc := g_package||'create_approval_styles';
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: end if;

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

35: --
36: g_debug:=hr_utility.debug_enabled;
37: if g_debug then
38: l_proc := g_package||'create_approval_styles';
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: end if;
41: --
42: -- Issue a savepoint
43: --

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

43: --
44: savepoint create_approval_styles;
45: --
46: if g_debug then
47: hr_utility.set_location(l_proc, 20);
48: end if;
49: --
50: -- Truncate the time portion from all IN date parameters
51: --

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

74: );
75: end;
76: --
77: if g_debug then
78: hr_utility.set_location(l_proc, 30);
79: end if;
80: --
81:
82: --

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

88: --
89: -- Process Logic
90: --
91: if g_debug then
92: hr_utility.set_location(l_proc, 40);
93: end if;
94: --
95: -- call row handler
96: --

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

106: ,p_object_version_number => l_object_version_number
107: );
108: --
109: if g_debug then
110: hr_utility.set_location(l_proc, 50);
111: end if;
112: --
113: -- Call After Process User Hook
114: --

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

133: );
134: end;
135: --
136: if g_debug then
137: hr_utility.set_location(l_proc, 60);
138: end if;
139: --
140: --
141: -- When in validation only mode raise the Validate_Enabled exception

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

144: raise hr_api.validate_enabled;
145: end if;
146: --
147: --if g_debug then
148: --hr_utility.set_location(' Leaving:'||l_proc, 70);
149: --end if;
150: --
151: --
152: -- Set all output arguments

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

154: p_approval_style_id := l_approval_style_id;
155: p_object_version_number := l_object_version_number;
156: --
157: if g_debug then
158: hr_utility.set_location(' Leaving:'||l_proc, 70);
159: end if;
160: exception
161: when hr_api.validate_enabled then
162: --

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

171: --
172: p_approval_style_id := null;
173: p_object_version_number := null;
174: if g_debug then
175: hr_utility.set_location(' Leaving:'||l_proc, 80);
176: end if;
177: when others then
178: --
179: -- A validation or unexpected error has occured

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

179: -- A validation or unexpected error has occured
180: --
181: rollback to create_approval_styles;
182: if g_debug then
183: hr_utility.set_location(' Leaving:'||l_proc, 90);
184: end if;
185: raise;
186: --
187: end create_approval_styles;

Line 215: g_debug:=hr_utility.debug_enabled;

211: l_object_version_number hxc_approval_styles.object_version_number%TYPE := p_object_version_number;
212: --
213: Begin
214: --
215: g_debug:=hr_utility.debug_enabled;
216: if g_debug then
217: l_proc := g_package||' update_approval_styles';
218: hr_utility.set_location('Entering:'|| l_proc, 10);
219: end if;

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

214: --
215: g_debug:=hr_utility.debug_enabled;
216: if g_debug then
217: l_proc := g_package||' update_approval_styles';
218: hr_utility.set_location('Entering:'|| l_proc, 10);
219: end if;
220: --
221: -- Issue a savepoint if operating in validation only mode
222: --

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

222: --
223: savepoint update_approval_styles;
224: --
225: if g_debug then
226: hr_utility.set_location(l_proc, 20);
227: end if;
228: --
229: -- Call Before Process User Hook
230: --

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

249: );
250: end;
251: --
252: --if g_debug then
253: --hr_utility.set_location(l_proc, 30);
254: --end if;
255: --
256: -- Process Logic
257: --

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

270: );
271: --
272: --
273: if g_debug then
274: hr_utility.set_location(l_proc, 40);
275: end if;
276: --
277: -- Call After Process User Hook
278: --

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

297: );
298: end;
299: --
300: if g_debug then
301: hr_utility.set_location(l_proc, 50);
302: end if;
303: --
304: -- When in validation only mode raise the Validate_Enabled exception
305: --

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

307: raise hr_api.validate_enabled;
308: end if;
309: --
310: if g_debug then
311: hr_utility.set_location(' Leaving:'||l_proc, 60);
312: end if;
313: --
314: -- Set all output arguments
315: --

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

330: --
331: p_object_version_number := null;
332: --
333: if g_debug then
334: hr_utility.set_location(' Leaving:'||l_proc, 60);
335: end if;
336: --
337: when others then
338: --

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

339: -- A validation or unexpected error has occured
340: --
341: ROLLBACK TO update_approval_styles;
342: if g_debug then
343: hr_utility.set_location(' Leaving:'||l_proc, 70);
344: end if;
345: raise;
346: --
347: END update_approval_styles;

Line 365: g_debug:=hr_utility.debug_enabled;

361: l_proc varchar2(72);
362: --
363: begin
364: --
365: g_debug:=hr_utility.debug_enabled;
366: if g_debug then
367: l_proc := g_package||'delete_approval_styles';
368: hr_utility.set_location('Entering:'|| l_proc, 10);
369: end if;

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

364: --
365: g_debug:=hr_utility.debug_enabled;
366: if g_debug then
367: l_proc := g_package||'delete_approval_styles';
368: hr_utility.set_location('Entering:'|| l_proc, 10);
369: end if;
370: --
371: -- Issue a savepoint if operating in validation only mode
372: --

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

372: --
373: savepoint delete_approval_styles;
374: --
375: if g_debug then
376: hr_utility.set_location(l_proc, 20);
377: end if;
378: --
379: -- Call Before Process User Hook
380: --

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

392: );
393: end;
394: --
395: if g_debug then
396: hr_utility.set_location(l_proc, 30);
397: end if;
398: --
399: -- Process Logic
400: --

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

404: ,p_object_version_number => p_object_version_number
405: );
406: --
407: if g_debug then
408: hr_utility.set_location(l_proc, 40);
409: end if;
410: --
411: -- Call After Process User Hook
412: --

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

430: raise hr_api.validate_enabled;
431: end if;
432: --
433: if g_debug then
434: hr_utility.set_location(' Leaving:'||l_proc, 50);
435: end if;
436: --
437: exception
438: --