DBA Data[Home] [Help]

APPS.PER_SP_SUCCESSEE_DETAIL_API dependencies on HR_UTILITY

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

34: l_proc varchar2(72) := g_package||'create_successee_detail';
35: l_successee_detail_id per_sp_successee_details.successee_detail_id%TYPE;
36: l_object_version_number per_sp_successee_details.object_version_number%TYPE;
37: begin
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: -- Issue a savepoint
41: --
42: savepoint create_successee_detail;

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: --
51: -- Call Before Process User Hook
52: --

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

78: -- Validation in addition to Row Handlers
79: --
80:
81:
82: hr_utility.set_location(l_proc, 30);
83:
84: --
85: -- Process Logic
86: --

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

84: --
85: -- Process Logic
86: --
87:
88: hr_utility.set_location(l_proc, 40);
89: per_ssd_ins.ins(
90: p_effective_date => l_effective_date
91: ,p_business_group_id => p_business_group_id
92: ,p_successee_type => p_successee_type

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

131: (p_module_name => 'create_successee_detail_b'
132: ,p_hook_type => 'AP'
133: );
134: end;
135: hr_utility.set_location(l_proc, 50);
136:
137: --
138: -- When in validation only mode raise the Validate_Enabled exception
139: --

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

145: --
146: p_successee_detail_id := l_successee_detail_id;
147: p_object_version_number := l_object_version_number;
148: --
149: hr_utility.set_location(' Leaving:'||l_proc, 70);
150: exception
151: when hr_api.validate_enabled then
152: --
153: -- As the Validate_Enabled exception has been raised

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

160: -- when validation only mode is being used.)
161: --
162: p_successee_detail_id := null;
163: p_object_version_number := null;
164: hr_utility.set_location(' Leaving:'||l_proc, 80);
165: when others then
166: --
167: -- A validation or unexpected error has occured
168: --

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

172: -- OUT parameters, including warnings, to null
173: --
174: p_successee_detail_id := null;
175: p_object_version_number := null;
176: hr_utility.set_location(' Leaving:'||l_proc, 90);
177: raise;
178: end create_successee_detail;
179: --
180: --

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

207: l_effective_date date;
208: l_proc varchar2(72) := g_package||'update_successee_detail';
209: l_object_version_number per_sp_successee_details.object_version_number%TYPE;
210: begin
211: hr_utility.set_location('Entering:'|| l_proc, 10);
212: --
213: -- Issue a savepoint
214: --
215: savepoint update_successee_detail;

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

219: --
220: -- Truncate the time portion from all IN date parameters
221: --
222: l_effective_date := trunc(p_effective_date);
223: hr_utility.set_location(l_proc, 20);
224:
225: --
226: -- Call Before Process User Hook
227: --

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

254: -- Validation in addition to Row Handlers
255: --
256:
257:
258: hr_utility.set_location(l_proc, 30);
259:
260: --
261: -- Process Logic
262: --

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

260: --
261: -- Process Logic
262: --
263:
264: hr_utility.set_location(l_proc, 40);
265: per_ssd_upd.upd(
266: p_effective_date => l_effective_date
267: ,p_business_group_id => p_business_group_id
268: ,p_successee_type => p_successee_type

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

308: (p_module_name => 'update_successee_detail_b'
309: ,p_hook_type => 'AP'
310: );
311: end;
312: hr_utility.set_location(l_proc, 50);
313:
314: --
315: -- When in validation only mode raise the Validate_Enabled exception
316: --

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

321: -- Set all IN OUT and OUT parameters with out values
322: --
323: p_object_version_number := l_object_version_number;
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised

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

335: -- (Any key or derived arguments must be set to null
336: -- when validation only mode is being used.)
337: --
338: p_object_version_number := l_object_version_number;
339: hr_utility.set_location(' Leaving:'||l_proc, 80);
340: when others then
341: --
342: -- A validation or unexpected error has occured
343: --

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

346: -- Reset IN OUT parameters and set all
347: -- OUT parameters, including warnings, to null
348: --
349: p_object_version_number := l_object_version_number;
350: hr_utility.set_location(' Leaving:'||l_proc, 90);
351: raise;
352: end update_successee_detail;
353: --
354: --

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

360: -- Declare cursors and local variables
361: --
362: l_proc varchar2(72) := g_package||'delete_successee_detail';
363: begin
364: hr_utility.set_location('Entering:'|| l_proc, 5);
365: --
366: -- Issue a savepoint.
367: --
368: savepoint delete_successee_detail;

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

365: --
366: -- Issue a savepoint.
367: --
368: savepoint delete_successee_detail;
369: hr_utility.set_location(l_proc, 10);
370: per_sp_successee_detail_bk3.delete_successee_detail_b(p_successee_detail_id => p_successee_detail_id);
371: hr_utility.set_location(l_proc, 20);
372: per_ssd_del.del(p_successee_detail_id => p_successee_detail_id
373: ,p_object_version_number => p_object_version_number);

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

367: --
368: savepoint delete_successee_detail;
369: hr_utility.set_location(l_proc, 10);
370: per_sp_successee_detail_bk3.delete_successee_detail_b(p_successee_detail_id => p_successee_detail_id);
371: hr_utility.set_location(l_proc, 20);
372: per_ssd_del.del(p_successee_detail_id => p_successee_detail_id
373: ,p_object_version_number => p_object_version_number);
374: hr_utility.set_location(l_proc, 30);
375: per_sp_successee_detail_bk3.delete_successee_detail_a(p_successee_detail_id => p_successee_detail_id);

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

370: per_sp_successee_detail_bk3.delete_successee_detail_b(p_successee_detail_id => p_successee_detail_id);
371: hr_utility.set_location(l_proc, 20);
372: per_ssd_del.del(p_successee_detail_id => p_successee_detail_id
373: ,p_object_version_number => p_object_version_number);
374: hr_utility.set_location(l_proc, 30);
375: per_sp_successee_detail_bk3.delete_successee_detail_a(p_successee_detail_id => p_successee_detail_id);
376: hr_utility.set_location(l_proc, 50);
377: --
378: -- When in validation only mode raise the Validate_Enabled exception

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

372: per_ssd_del.del(p_successee_detail_id => p_successee_detail_id
373: ,p_object_version_number => p_object_version_number);
374: hr_utility.set_location(l_proc, 30);
375: per_sp_successee_detail_bk3.delete_successee_detail_a(p_successee_detail_id => p_successee_detail_id);
376: hr_utility.set_location(l_proc, 50);
377: --
378: -- When in validation only mode raise the Validate_Enabled exception
379: --
380: if p_validate then

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

383: --
384: -- Set all IN OUT and OUT parameters with out values
385: --
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 70);
388: exception
389: when hr_api.validate_enabled then
390: --
391: -- As the Validate_Enabled exception has been raised

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

396: -- Reset IN OUT parameters and set OUT parameters
397: -- (Any key or derived arguments must be set to null
398: -- when validation only mode is being used.)
399: --
400: hr_utility.set_location(' Leaving:'||l_proc, 80);
401: when others then
402: --
403: -- A validation or unexpected error has occured
404: --

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

406: --
407: -- Reset IN OUT parameters and set all
408: -- OUT parameters, including warnings, to null
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 90);
411: raise;
412:
413: end delete_successee_detail;
414: --