DBA Data[Home] [Help]

APPS.IRC_APL_PRFL_SNAPSHOTS_API dependencies on HR_UTILITY

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

26: l_effective_date date;
27: l_proc varchar2(72) := g_package||'create_applicant_snapshot';
28:
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: --
32: -- Issue a savepoint
33: --
34: savepoint create_applicant_snapshot;

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

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

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

56: (p_module_name => 'create_applicant_snapshot'
57: ,p_hook_type => 'BP'
58: );
59: end;
60: hr_utility.set_location(l_proc, 30);
61: --
62: -- Validation in addition to Row Handlers
63: --
64:

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

70: ,p_person_id => p_person_id
71: ,p_profile_snapshot_id => l_profile_snapshot_id
72: ,p_object_version_number => l_object_version_number
73: );
74: hr_utility.set_location(' Leaving:'||l_proc, 50);
75: --
76: -- Call After Process User Hook
77: --
78: begin

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

100: --
101: p_profile_snapshot_id := l_profile_snapshot_id;
102: p_object_version_number := l_object_version_number;
103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 70);
105: exception
106: when hr_api.validate_enabled then
107: --
108: -- As the Validate_Enabled exception has been raised

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

116: --
117: p_profile_snapshot_id := null;
118: p_object_version_number := null;
119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 80);
121: when others then
122: --
123: -- A validation or unexpected error has occured
124: --

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

129: --
130: p_profile_snapshot_id := null;
131: p_object_version_number := null;
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 90);
134: raise;
135: end create_applicant_snapshot;
136: --
137: -- ----------------------------------------------------------------------------

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

155: l_effective_date date;
156: l_proc varchar2(72) := g_package||'update_applicant_snapshot';
157:
158: begin
159: hr_utility.set_location('Entering:'|| l_proc, 10);
160: --
161: -- Issue a savepoint
162: --
163: savepoint update_applicant_snapshot;

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

171: -- Truncate the time portion from all IN date parameters
172: --
173: l_effective_date := trunc(p_effective_date);
174:
175: hr_utility.set_location(l_proc, 20);
176: --
177: -- Call Before Process User Hook
178: --
179: begin

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

189: (p_module_name => 'update_applicant_snapshot'
190: ,p_hook_type => 'BP'
191: );
192: end;
193: hr_utility.set_location(l_proc, 30);
194: --
195: -- Validation in addition to Row Handlers
196: --
197:

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

203: ,p_person_id => p_person_id
204: ,p_profile_snapshot_id => l_profile_snapshot_id
205: ,p_object_version_number => l_object_version_number
206: );
207: hr_utility.set_location(' Leaving:'||l_proc, 50);
208: --
209: -- Call After Process User Hook
210: --
211: begin

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

233: --
234: p_profile_snapshot_id := l_profile_snapshot_id;
235: p_object_version_number := l_object_version_number;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 70);
238: exception
239: when hr_api.validate_enabled then
240: --
241: -- As the Validate_Enabled exception has been raised

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

249: --
250: p_profile_snapshot_id := p_profile_snapshot_id;
251: p_object_version_number := p_object_version_number;
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 80);
254: when others then
255: --
256: -- A validation or unexpected error has occured
257: --

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

262: --
263: p_profile_snapshot_id := p_profile_snapshot_id;
264: p_object_version_number := p_object_version_number;
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 90);
267: raise;
268: end update_applicant_snapshot;
269: --
270: --

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

289: l_effective_date date;
290: l_proc varchar2(72) := g_package||'delete_applicant_snapshot';
291:
292: begin
293: hr_utility.set_location('Entering:'|| l_proc, 10);
294: --
295: -- Issue a savepoint
296: --
297: savepoint delete_applicant_snapshot;

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

306: -- Truncate the time portion from all IN date parameters
307: --
308: l_effective_date := trunc(p_effective_date);
309:
310: hr_utility.set_location(l_proc, 20);
311: --
312: -- Call Before Process User Hook
313: --
314: begin

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

324: (p_module_name => 'delete_applicant_snapshot'
325: ,p_hook_type => 'BP'
326: );
327: end;
328: hr_utility.set_location(l_proc, 30);
329: --
330: -- Validation in addition to Row Handlers
331: --
332:

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

336: irc_aps_del.del
337: (p_profile_snapshot_id => l_profile_snapshot_id
338: ,p_object_version_number => l_object_version_number
339: );
340: hr_utility.set_location(' Leaving:'||l_proc, 50);
341: --
342: --
343: -- Call After Process User Hook
344: --

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

362: if p_validate then
363: raise hr_api.validate_enabled;
364: end if;
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 70);
367: --
368: exception
369: when hr_api.validate_enabled then
370: --

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

372: -- we must rollback to the savepoint
373: --
374: rollback to delete_applicant_snapshot;
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 80);
377: when others then
378: --
379: -- A validation or unexpected error has occured
380: --

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

379: -- A validation or unexpected error has occured
380: --
381: rollback to delete_applicant_snapshot;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 90);
384: raise;
385: end delete_applicant_snapshot;
386: --
387: end irc_apl_prfl_snapshots_api;