DBA Data[Home] [Help]

APPS.PAY_EVENT_VALUE_CHANGES_API dependencies on HR_UTILITY

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

41: l_effective_start_date pay_event_value_changes_f.effective_start_date%TYPE;
42: l_effective_end_date pay_event_value_changes_f.effective_end_date%TYPE;
43:
44: begin
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Issue a savepoint
48: --
49: savepoint create_event_value_change;

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

50: --
51: -- Truncate the time portion from all IN date parameters
52: --
53: l_effective_date := trunc(p_effective_date);
54: hr_utility.set_location(l_proc, 20);
55:
56: --
57: -- Call Before Process User Hook
58: --

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

78: ,p_hook_type => 'BP'
79: );
80: end;
81:
82: hr_utility.set_location(l_proc, 30);
83: --
84: -- Validation in addition to Row Handlers
85: --
86:

Line 103: hr_utility.set_message(801, 'HR_449144_QUA_FWK_ID_EXISTS');

99: and p_datetracked_event_id = datetracked_event_id
100: and default_event = 'Y';
101:
102: if (l_counter <> 0) then --A qualifier type already exists
103: hr_utility.set_message(801, 'HR_449144_QUA_FWK_ID_EXISTS');
104: -- The vague message is: This Qualification Id already exists....
105: hr_utility.raise_error;
106: end if;
107: end if;

Line 105: hr_utility.raise_error;

101:
102: if (l_counter <> 0) then --A qualifier type already exists
103: hr_utility.set_message(801, 'HR_449144_QUA_FWK_ID_EXISTS');
104: -- The vague message is: This Qualification Id already exists....
105: hr_utility.raise_error;
106: end if;
107: end if;
108:
109: hr_utility.set_location(l_proc, 40);

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

105: hr_utility.raise_error;
106: end if;
107: end if;
108:
109: hr_utility.set_location(l_proc, 40);
110:
111:
112: --
113: -- Process Logic

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

132: ,p_effective_start_date => l_effective_start_date
133: ,p_effective_end_date => l_effective_end_date
134: );
135: --
136: hr_utility.set_location(l_proc, 50);
137:
138: --
139: -- Call After Process User Hook
140: --

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

163: ,p_hook_type => 'AP'
164: );
165: end;
166:
167: hr_utility.set_location(l_proc, 60);
168:
169: --
170: -- When in validation only mode raise the Validate_Enabled exception
171: --

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

179: p_effective_start_date := l_effective_start_date;
180: p_effective_end_date := l_effective_end_date;
181: p_object_version_number := l_object_version_number;
182: --
183: hr_utility.set_location(' Leaving:'||l_proc, 70);
184: exception
185: when hr_api.validate_enabled then
186: --
187: -- As the Validate_Enabled exception has been raised

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

196: p_event_value_change_id := null;
197: p_effective_start_date := null;
198: p_effective_end_date := null;
199: p_object_version_number := null;
200: hr_utility.set_location(' Leaving:'||l_proc, 80);
201: when others then
202: --
203: -- A validation or unexpected error has occured
204: --

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

206: p_event_value_change_id := null;
207: p_effective_start_date := null;
208: p_effective_end_date := null;
209: p_object_version_number := null;
210: hr_utility.set_location(' Leaving:'||l_proc, 90);
211: raise;
212: end create_event_value_change;
213: --
214:

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

252: --
253: l_object_version_number pay_event_value_changes_f.object_version_number%TYPE;
254: --
255: begin
256: hr_utility.set_location('Entering:'|| l_proc, 10);
257: --
258: -- Issue a savepoint and assign in-out parameters to local variable
259: --
260:

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

264: --
265: -- Truncate the time portion from all IN date parameters
266: --
267: l_effective_date := trunc(p_effective_date);
268: hr_utility.set_location(l_proc, 20);
269: --
270: -- Call Before Process User Hook
271: --
272: begin

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

293: (p_module_name => 'update_event_value_change'
294: ,p_hook_type => 'BP'
295: );
296: end;
297: hr_utility.set_location(l_proc, 30);
298: --
299: -- Validation in addition to Row Handlers
300: --
301: hr_utility.set_location(l_proc, 40);

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

297: hr_utility.set_location(l_proc, 30);
298: --
299: -- Validation in addition to Row Handlers
300: --
301: hr_utility.set_location(l_proc, 40);
302: --
303: -- Process Logic
304: --
305: -- Call the row handler

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

319: );
320: --
321:
322: --
323: hr_utility.set_location(l_proc, 50);
324: --
325: -- Call After Process User Hook
326: --
327: begin

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

349: (p_module_name => 'update_event_value_change_a'
350: ,p_hook_type => 'AP'
351: );
352: end;
353: hr_utility.set_location(l_proc, 60);
354: --
355: -- When in validation only mode raise the Validate_Enabled exception
356: --
357: if p_validate then

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

363: p_effective_start_date := l_effective_start_date;
364: p_effective_end_date := l_effective_end_date;
365: p_object_version_number := p_object_version_number;
366: --
367: hr_utility.set_location(' Leaving:'||l_proc, 70);
368: exception
369: when hr_api.validate_enabled then
370: --
371: -- As the Validate_Enabled exception has been raised

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

379: --
380: p_object_version_number := l_object_version_number;
381: p_effective_start_date := null;
382: p_effective_end_date := null;
383: hr_utility.set_location(' Leaving:'||l_proc, 80);
384: when others then
385: --
386: -- A validation or unexpected error has occured
387: --

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

386: -- A validation or unexpected error has occured
387: --
388: rollback to update_event_value_change;
389: raise;
390: hr_utility.set_location(' Leaving:'||l_proc, 90);
391: raise;
392: end update_event_value_change;
393:
394:

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

421: l_validation_end_date date;
422: l_object_version_number pay_event_value_changes_f.object_version_number%type;
423: --
424: begin
425: hr_utility.set_location('Entering:'|| l_proc, 5);
426: --
427: -- Issue a savepoint and assign in-out parameters to local variable
428: --
429: savepoint delete_event_value_change;

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

428: --
429: savepoint delete_event_value_change;
430: l_object_version_number := p_object_version_number;
431: --
432: hr_utility.set_location(l_proc, 10);
433: --
434: l_effective_date := trunc(p_effective_date);
435: --
436: -- Call Before Process User Hook

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

452: ,p_hook_type => 'BP'
453: );
454: end;
455: --
456: hr_utility.set_location(l_proc, 20);
457: --
458: -- Validation in addition to Row Handlers
459: --
460: hr_utility.set_location(l_proc, 30);

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

456: hr_utility.set_location(l_proc, 20);
457: --
458: -- Validation in addition to Row Handlers
459: --
460: hr_utility.set_location(l_proc, 30);
461: --
462: -- Lock the non-translated table row handler for ZAP datetrack delete mode
463: --
464: if p_datetrack_mode = hr_api.g_zap then

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

483: ,p_effective_start_date => l_effective_start_date
484: ,p_effective_end_date => l_effective_end_date
485: );
486: --
487: hr_utility.set_location(l_proc, 50);
488: --
489: -- Call After Process User Hook
490: --
491: begin

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

500: ,p_effective_end_date => l_effective_end_date
501: );
502: --
503: end;
504: hr_utility.set_location(l_proc, 60);
505: --
506: -- When in validation only mode raise the Validate_Enabled exception
507: --
508: if p_validate then

Line 518: hr_utility.set_location(l_proc, 70);

514: p_object_version_number := p_object_version_number;
515: p_effective_start_date := l_effective_start_date;
516: p_effective_end_date := l_effective_end_date;
517: --
518: hr_utility.set_location(l_proc, 70);
519: exception
520: when hr_api.validate_enabled then
521: --
522: -- As the Validate_Enabled exception has been raised

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

539: ROLLBACK TO delete_event_value_change;
540: p_object_version_number := l_object_version_number;
541: p_effective_start_date := null;
542: p_effective_end_date := null;
543: hr_utility.set_location(' Leaving:'||l_proc, 80);
544: raise;
545: --
546: end delete_event_value_change;
547: -- ----------------------------------------------------------------------------