DBA Data[Home] [Help]

APPS.PAY_RUN_TYPE_USAGE_API dependencies on HR_UTILITY

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

35: l_effective_start_date pay_run_type_usages_f.effective_start_date%TYPE;
36: l_effective_end_date pay_run_type_usages_f.effective_end_date%TYPE;
37: --
38: begin
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: --
41: -- Issue a savepoint
42: --
43: savepoint create_run_type_usage;

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

44: --
45: -- Truncate the time portion from all IN date parameters
46: --
47: l_effective_date := trunc(p_effective_date);
48: hr_utility.set_location(l_proc, 20);
49: --
50: -- Call Before Process User Hook
51: --
52: begin

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

64: (p_module_name => 'create_run_type_usage'
65: ,p_hook_type => 'BP'
66: );
67: end;
68: hr_utility.set_location(l_proc, 30);
69: --
70: -- Validation in addition to Row Handlers
71: --
72: hr_utility.set_location(l_proc, 40);

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

68: hr_utility.set_location(l_proc, 30);
69: --
70: -- Validation in addition to Row Handlers
71: --
72: hr_utility.set_location(l_proc, 40);
73: --
74: -- Process Logic
75: --
76: -- Call the row handler

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

87: ,p_effective_start_date => l_effective_start_date
88: ,p_effective_end_date => l_effective_end_date
89: );
90: --
91: hr_utility.set_location(l_proc, 50);
92: --
93: -- Call After Process User Hook
94: --
95: begin

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

111: (p_module_name => 'create_run_type_usage'
112: ,p_hook_type => 'AP'
113: );
114: end;
115: hr_utility.set_location(l_proc, 60);
116: --
117: -- When in validation only mode raise the Validate_Enabled exception
118: --
119: if p_validate then

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

126: p_effective_start_date := l_effective_start_date;
127: p_effective_end_date := l_effective_end_date;
128: p_object_version_number := l_object_version_number;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: exception
132: when hr_api.validate_enabled then
133: --
134: -- As the Validate_Enabled exception has been raised

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

144: p_object_version_number := null;
145: p_effective_start_date := null;
146: p_effective_end_date := null;
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 80);
149: when others then
150: --
151: -- A validation or unexpected error has occured
152: --

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

158: p_object_version_number := null;
159: p_effective_start_date := null;
160: p_effective_end_date := null;
161: --
162: hr_utility.set_location(' Leaving:'||l_proc, 90);
163: raise;
164: end create_run_type_usage;
165: -- ----------------------------------------------------------------------------
166: -- |------------------------< update_run_type_usage >-------------------------|

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

193: --
194: l_object_version_number pay_run_type_usages_f.object_version_number%TYPE;
195: --
196: begin
197: hr_utility.set_location('Entering:'|| l_proc, 10);
198: --
199: -- Issue a savepoint
200: --
201: l_object_version_number := p_object_version_number;

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

203: --
204: -- Truncate the time portion from all IN date parameters
205: --
206: l_effective_date := trunc(p_effective_date);
207: hr_utility.set_location(l_proc, 20);
208: --
209: -- Call Before Process User Hook
210: --
211: begin

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

224: (p_module_name => 'update_run_type_usage'
225: ,p_hook_type => 'BP'
226: );
227: end;
228: hr_utility.set_location(l_proc, 30);
229: --
230: -- Validation in addition to Row Handlers
231: --
232: hr_utility.set_location(l_proc, 40);

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

228: hr_utility.set_location(l_proc, 30);
229: --
230: -- Validation in addition to Row Handlers
231: --
232: hr_utility.set_location(l_proc, 40);
233: --
234: -- call the row handler
235: --
236: pay_rtu_upd.upd

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

242: ,p_effective_start_date => l_effective_start_date
243: ,p_effective_end_date => l_effective_end_date
244: );
245: --
246: hr_utility.set_location(l_proc, 50);
247: --
248: -- Call After Process User Hook
249: --
250: begin

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

265: (p_module_name => 'update_run_type_usage'
266: ,p_hook_type => 'AP'
267: );
268: end;
269: hr_utility.set_location(l_proc, 60);
270: --
271: -- When in validation only mode raise the Validate_Enabled exception
272: --
273: if p_validate then

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

279: p_effective_start_date := l_effective_start_date;
280: p_effective_end_date := l_effective_end_date;
281: p_object_version_number := p_object_version_number;
282: --
283: hr_utility.set_location(' Leaving:'||l_proc, 70);
284: exception
285: when hr_api.validate_enabled then
286: --
287: -- As the Validate_Enabled exception has been raised

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

295: --
296: p_object_version_number := l_object_version_number;
297: p_effective_start_date := null;
298: p_effective_end_date := null;
299: hr_utility.set_location(' Leaving:'||l_proc, 80);
300: when others then
301: --
302: -- A validation or unexpected error has occured
303: --

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

308: p_object_version_number := l_object_version_number;
309: p_effective_start_date := null;
310: p_effective_end_date := null;
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 90);
313: raise;
314: end update_run_type_usage;
315: -- ----------------------------------------------------------------------------
316: -- |--------------------------< delete_run_type_usage >-----------------------|

Line 342: hr_utility.set_location('Entering:'|| l_proc, 5);

338: l_effective_start_date pay_run_type_usages_f.effective_start_date%type;
339: l_effective_end_date pay_run_type_usages_f.effective_end_date%type;
340: l_object_version_number pay_run_type_usages_f.object_version_number%type;
341: begin
342: hr_utility.set_location('Entering:'|| l_proc, 5);
343: --
344: -- Issue a savepoint
345: --
346: savepoint delete_run_type_usage;

Line 349: hr_utility.set_location(l_proc, 10);

345: --
346: savepoint delete_run_type_usage;
347: l_object_version_number := p_object_version_number;
348: --
349: hr_utility.set_location(l_proc, 10);
350: --
351: -- Truncate the time portion from all IN date parameters
352: --
353: l_effective_date := trunc(p_effective_date);

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

369: (p_module_name => 'delete_run_type_usage'
370: ,p_hook_type => 'BP'
371: );
372: end;
373: hr_utility.set_location(l_proc, 20);
374: --
375: -- Validation in addition to Row Handlers
376: --
377: hr_utility.set_location(l_proc, 30);

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

373: hr_utility.set_location(l_proc, 20);
374: --
375: -- Validation in addition to Row Handlers
376: --
377: hr_utility.set_location(l_proc, 30);
378: --
379: -- Process Logic
380: --
381: -- Call the row handler to delete the run_type

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

388: ,p_effective_start_date => l_effective_start_date
389: ,p_effective_end_date => l_effective_end_date
390: );
391: --
392: hr_utility.set_location(l_proc, 50);
393: --
394: -- Call After Process User Hook
395: --
396: begin

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

410: (p_module_name => 'delete_run_type_usage'
411: ,p_hook_type => 'AP'
412: );
413: end;
414: hr_utility.set_location(l_proc, 60);
415: --
416: -- When in validation only mode raise the Validate_Enabled exception
417: --
418: if p_validate then

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

424: p_object_version_number := p_object_version_number;
425: p_effective_start_date := l_effective_start_date;
426: p_effective_end_date := l_effective_end_date;
427: --
428: hr_utility.set_location(' Leaving:'||l_proc, 70);
429: exception
430: when hr_api.validate_enabled then
431: --
432: -- As the Validate_Enabled exception has been raised

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

441: p_object_version_number := l_object_version_number;
442: p_effective_start_date := null;
443: p_effective_end_date := null;
444: --
445: hr_utility.set_location(' Leaving:'||l_proc, 80);
446: when others then
447: --
448: -- A validation or unexpected error has occured
449: --

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

454: p_object_version_number := l_object_version_number;
455: p_effective_start_date := null;
456: p_effective_end_date := null;
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 90);
459: raise;
460: end delete_run_type_usage;
461: --
462: end pay_run_type_usage_api;