DBA Data[Home] [Help]

APPS.IRC_APL_PROFILE_ACCESS_API dependencies on HR_UTILITY

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

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

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

50: --
51: -- Truncate the time portion from all IN date parameters
52: --
53:
54: hr_utility.set_location(l_proc, 20);
55: --
56: -- Call Before Process User Hook
57: --
58: --Comment below To be removed

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

56: -- Call Before Process User Hook
57: --
58: --Comment below To be removed
59:
60: hr_utility.set_location(l_proc, 30);
61: --
62: -- Validation in addition to Row Handlers
63: --
64:

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

77: End If;
78:
79:
80:
81: hr_utility.set_location(' Leaving:'||l_proc, 50);
82: --
83: -- Call After Process User Hook
84: --
85: --Comment below To be removed

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

95: --
96: p_apl_profile_access_id := l_apl_profile_access_id;
97: p_object_version_number := l_object_version_number;
98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 70);
100: exception
101: when hr_api.validate_enabled then
102: --
103: -- As the Validate_Enabled exception has been raised

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

111: --
112: p_apl_profile_access_id := null;
113: p_object_version_number := null;
114: --
115: hr_utility.set_location(' Leaving:'||l_proc, 80);
116: when others then
117: --
118: -- A validation or unexpected error has occured
119: --

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

124: --
125: p_apl_profile_access_id := null;
126: p_object_version_number := null;
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 90);
129: raise;
130: end create_apl_profile_access;
131: --
132: -- ----------------------------------------------------------------------------

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

147: l_object_version_number irc_apl_profile_access.object_version_number%TYPE;
148: l_proc varchar2(72) := g_package||'update_apl_profile_access';
149:
150: begin
151: hr_utility.set_location('Entering:'|| l_proc, 10);
152: --
153: -- Issue a savepoint
154: --
155: savepoint update_apl_profile_access;

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

162: --
163: -- Truncate the time portion from all IN date parameters
164: --
165:
166: hr_utility.set_location(l_proc, 20);
167: --
168: -- Call Before Process User Hook
169: --
170: begin

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

179: (p_module_name => 'update_apl_profile_access'
180: ,p_hook_type => 'BP'
181: );
182: end;
183: hr_utility.set_location(l_proc, 30);
184: --
185: -- Validation in addition to Row Handlers
186: --
187:

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

192: (p_person_id => p_person_id
193: ,p_apl_profile_access_id => l_apl_profile_access_id
194: ,p_object_version_number => l_object_version_number
195: );
196: hr_utility.set_location(' Leaving:'||l_proc, 50);
197: --
198: -- Call After Process User Hook
199: --
200: begin

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

221: --
222: p_apl_profile_access_id := l_apl_profile_access_id;
223: p_object_version_number := l_object_version_number;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 70);
226: exception
227: when hr_api.validate_enabled then
228: --
229: -- As the Validate_Enabled exception has been raised

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

237: --
238: p_apl_profile_access_id := p_apl_profile_access_id;
239: p_object_version_number := p_object_version_number;
240: --
241: hr_utility.set_location(' Leaving:'||l_proc, 80);
242: when others then
243: --
244: -- A validation or unexpected error has occured
245: --

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

250: --
251: p_apl_profile_access_id := p_apl_profile_access_id;
252: p_object_version_number := p_object_version_number;
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 90);
255: raise;
256: end update_apl_profile_access;
257: --
258:

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

270: -- Declare cursors and local variables
271: --
272: l_proc varchar2(72) := g_package||'delete_apl_profile_access';
273: begin
274: hr_utility.set_location('Entering:'|| l_proc, 10);
275: --
276: -- Issue a savepoint
277: --
278: savepoint delete_apl_profile_access;

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

323: if p_validate then
324: raise hr_api.validate_enabled;
325: end if;
326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 70);
328: exception
329: when hr_api.validate_enabled then
330: --
331: -- As the Validate_Enabled exception has been raised

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

332: -- we must rollback to the savepoint
333: --
334: rollback to delete_apl_profile_access;
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 80);
337: when others then
338: --
339: -- A validation or unexpected error has occured
340: --

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

339: -- A validation or unexpected error has occured
340: --
341: rollback to delete_apl_profile_access;
342: --
343: hr_utility.set_location(' Leaving:'||l_proc, 90);
344: raise;
345: end delete_apl_profile_access;
346: --
347: end irc_apl_profile_access_api;