DBA Data[Home] [Help]

APPS.GHR_COMPLAINTS_CA_DETAILS_API dependencies on HR_UTILITY

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

36: l_proc varchar2(72) := g_package||'create_ca_detail';
37: l_compl_ca_detail_id number;
38: l_object_version_number number;
39: begin
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Issue a savepoint
43: --
44: savepoint create_ca_detail;

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

41: --
42: -- Issue a savepoint
43: --
44: savepoint create_ca_detail;
45: hr_utility.set_location(l_proc, 20);
46: --
47: -- Truncate the time portion from all IN date parameters
48: --
49: --

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

75: end;
76: --
77: -- Validation in addition to Row Handlers
78: --
79: hr_utility.set_location(l_proc, 40);
80: --
81: -- Process Logic
82: --
83: ghr_cdt_ins.ins

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

98: ,p_description => p_description
99: ,p_compl_ca_detail_id => l_compl_ca_detail_id
100: ,p_object_version_number => l_object_version_number
101: );
102: hr_utility.set_location(l_proc, 50);
103: --
104: -- Call After Process User Hook
105: --
106: begin

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

140: --
141: p_compl_ca_detail_id := l_compl_ca_detail_id;
142: p_object_version_number := l_object_version_number;
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 70);
145: exception
146: when hr_api.validate_enabled then
147: --
148: -- As the Validate_Enabled exception has been raised

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

155: -- when validation only mode is being used.)
156: --
157: p_compl_ca_detail_id := null;
158: p_object_version_number := null;
159: hr_utility.set_location(' Leaving:'||l_proc, 80);
160: when others then
161: --
162: -- A validation or unexpected error has occured
163: --

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

164: rollback to create_ca_detail;
165: --RESET In/Out Params and SET Out Params
166: p_compl_ca_detail_id := null;
167: p_object_version_number := null;
168: hr_utility.set_location(' Leaving:'||l_proc, 90);
169: raise;
170: end create_ca_detail;
171: --
172:

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

194: is
195: l_proc varchar2(72) := g_package||'update_ca_detail';
196: l_object_version_number number;
197: begin
198: hr_utility.set_location('Entering:'|| l_proc, 5);
199: --
200: savepoint update_ca_detail;
201: --
202: l_object_version_number := p_object_version_number;

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

236: -- Store the original ovn in case we rollback when p_validate is true
237: --
238: l_object_version_number := p_object_version_number;
239:
240: hr_utility.set_location(l_proc, 6);
241:
242: ghr_cdt_upd.upd
243: (p_effective_date => p_effective_date
244: ,p_compl_ca_detail_id => p_compl_ca_detail_id

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

296: -- Set all output arguments
297: --
298: p_object_version_number := l_object_version_number;
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 70);
301: exception
302: when hr_api.validate_enabled then
303: --
304: -- As the Validate_Enabled exception has been raised

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

310: -- (Any key or derived arguments must be set to null
311: -- when validation only mode is being used.)
312: --
313: p_object_version_number := l_object_version_number;
314: hr_utility.set_location(' Leaving:'||l_proc, 80);
315: when others then
316: --
317: -- A validation or unexpected error has occured
318: --

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

318: --
319: rollback to update_ca_detail;
320: -- RESET In/Out Params and SET Out Params
321: p_object_version_number := l_object_version_number;
322: hr_utility.set_location(' Leaving:'||l_proc, 90);
323: raise;
324:
325: end update_ca_detail;
326:

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

339: l_proc varchar2(72) := g_package||'delete_ca_detail';
340: l_exists boolean := false;
341:
342: begin
343: hr_utility.set_location('Entering:'|| l_proc, 5);
344: --
345: --
346: savepoint delete_ca_detail;
347: --

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

371: (p_compl_ca_detail_id => p_compl_ca_detail_id
372: ,p_object_version_number => p_object_version_number
373: );
374: --
375: hr_utility.set_location(l_proc, 8);
376: --
377: -- Call After Process User Hook
378: --
379: begin

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

394: if p_validate then
395: raise hr_api.validate_enabled;
396: end if;
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 11);
399: exception
400: when hr_api.validate_enabled then
401: -- we must rollback to the savepoint
402: --

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

405: When Others then
406: ROLLBACK TO delete_ca_detail;
407: raise;
408:
409: hr_utility.set_location(' Leaving:'||l_proc, 12);
410: end delete_ca_detail;
411: end ghr_complaints_ca_details_api;
412: