DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS_CA_HEADERS_API dependencies on HR_UTILITY

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

44: l_proc varchar2(72) := g_package||'create_ca_header';
45: l_compl_ca_header_id number;
46: l_object_version_number number;
47: begin
48: hr_utility.set_location('Entering:'|| l_proc, 10);
49: --
50: -- Issue a savepoint
51: --
52: savepoint create_ca_header;

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

49: --
50: -- Issue a savepoint
51: --
52: savepoint create_ca_header;
53: hr_utility.set_location(l_proc, 20);
54: --
55: -- Truncate the time portion from all IN date parameters
56: --
57:

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

93: --
94: -- Validation in addition to Row Handlers
95: --
96:
97: hr_utility.set_location(l_proc, 40);
98: --
99: -- Process Logic
100: --
101: ghr_cah_ins.ins

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

124: ,p_stage_complaint_reinstated => p_stage_complaint_reinstated
125: ,p_compl_ca_header_id => l_compl_ca_header_id
126: ,p_object_version_number => l_object_version_number
127: );
128: hr_utility.set_location(l_proc, 50);
129: --
130: -- Call After Process User Hook
131: --
132: begin

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

174: --
175: p_compl_ca_header_id := l_compl_ca_header_id;
176: p_object_version_number := l_object_version_number;
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 70);
179: exception
180: when hr_api.validate_enabled then
181: --
182: -- As the Validate_Enabled exception has been raised

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

189: -- when validation only mode is being used.)
190: --
191: p_compl_ca_header_id := null;
192: p_object_version_number := null;
193: hr_utility.set_location(' Leaving:'||l_proc, 80);
194: when others then
195: --
196: -- A validation or unexpected error has occured
197: --

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

198: rollback to create_ca_header;
199: -- RESET In/Out Params and Set Out Params
200: p_compl_ca_header_id := null;
201: p_object_version_number := null;
202: hr_utility.set_location(' Leaving:'||l_proc, 90);
203: raise;
204: end create_ca_header;
205: --
206: --

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

241: l_proc varchar2(72) := g_package||'update_ca_header';
242: l_compl_ca_header_id number;
243: l_object_version_number number;
244: begin
245: hr_utility.set_location('Entering:'|| l_proc, 5);
246: --
247: savepoint update_ca_header;
248: --
249: -- Initialise Local Variables

Line 298: hr_utility.set_location(l_proc, 6);

294: -- Store the original ovn in case we rollback when p_validate is true
295: --
296: l_object_version_number := p_object_version_number;
297:
298: hr_utility.set_location(l_proc, 6);
299:
300: ghr_cah_upd.upd
301: (p_effective_date => p_effective_date
302: ,p_complaint_id => p_complaint_id

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

370: -- Set all output arguments
371: --
372: p_object_version_number := l_object_version_number;
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 70);
375: exception
376: when hr_api.validate_enabled then
377: --
378: -- As the Validate_Enabled exception has been raised

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

384: -- (Any key or derived arguments must be set to null
385: -- when validation only mode is being used.)
386: --
387: p_object_version_number := l_object_version_number;
388: hr_utility.set_location(' Leaving:'||l_proc, 80);
389: when others then
390: --
391: -- A validation or unexpected error has occured
392: --

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

392: --
393: rollback to update_ca_header;
394: -- RESET In/Out Parameter
395: p_object_version_number := l_object_version_number;
396: hr_utility.set_location(' Leaving:'||l_proc, 90);
397: raise;
398:
399: end update_ca_header;
400: --

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

413: l_proc varchar2(72) := g_package||'delete_ca_header';
414: l_exists boolean := false;
415:
416: begin
417: hr_utility.set_location('Entering:'|| l_proc, 5);
418: --
419: --
420: savepoint delete_ca_header;
421: --

Line 448: hr_utility.set_location(l_proc, 8);

444: (p_compl_ca_header_id => p_compl_ca_header_id
445: ,p_object_version_number => p_object_version_number
446: );
447: --
448: hr_utility.set_location(l_proc, 8);
449: --
450: -- Call After Process User Hook
451: --
452: begin

Line 471: hr_utility.set_location(' Leaving:'||l_proc, 11);

467: if p_validate then
468: raise hr_api.validate_enabled;
469: end if;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 11);
472: exception
473: when hr_api.validate_enabled then
474: -- we must rollback to the savepoint
475: --

Line 482: hr_utility.set_location(' Leaving:'||l_proc, 12);

478: When Others then
479: ROLLBACK TO delete_ca_header;
480: raise;
481:
482: hr_utility.set_location(' Leaving:'||l_proc, 12);
483: end delete_ca_header;
484: end ghr_complaints_ca_headers_api;
485: