DBA Data[Home] [Help]

APPS.PAY_WCI_ACCOUNTS_API dependencies on HR_UTILITY

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

29: l_effective_date date;
30:
31: begin
32:
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_wci_account;

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

34: --
35: -- Issue a savepoint
36: --
37: savepoint create_wci_account;
38: hr_utility.set_location(l_proc, 20);
39: --
40: -- Truncate the time portion from all IN date parameters
41: --
42: l_effective_date := trunc(p_effective_date);

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

60: (p_module_name => 'create_wci_account'
61: ,p_hook_type => 'BP'
62: );
63: end;
64: hr_utility.set_location(l_proc, 30);
65: --
66: -- Validation in addition to Row Handlers
67: --
68: hr_utility.set_location(l_proc, 40);

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

64: hr_utility.set_location(l_proc, 30);
65: --
66: -- Validation in addition to Row Handlers
67: --
68: hr_utility.set_location(l_proc, 40);
69: --
70: -- Process Logic
71: --
72: -- Call the row handler

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

81: ,p_comments => p_comments
82: ,p_account_id => p_account_id
83: );
84:
85: hr_utility.set_location(l_proc, 50);
86: --
87: -- Call After Process User Hook
88: --
89: begin

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

104: (p_module_name => 'create_wci_account'
105: ,p_hook_type => 'AP'
106: );
107: end;
108: hr_utility.set_location(l_proc, 60);
109: --
110: -- When in validation only mode raise the Validate_Enabled exception
111: --
112: if p_validate then

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

114: end if;
115: --
116: -- Set all output arguments
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119:
120: exception
121:
122: when hr_api.validate_enabled then

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

131: -- when validation only mode is being used.)
132: --
133: p_account_id := null;
134: p_object_version_number := null;
135: hr_utility.set_location(' Leaving:'||l_proc, 80);
136: when others then
137: --
138: -- A validation or unexpected error has occured
139: --

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

144: --
145: p_account_id := null;
146: p_object_version_number := null;
147: --
148: hr_utility.set_location(' Leaving:'||l_proc, 90);
149: raise;
150: end create_wci_account;
151: --
152: -- ----------------------------------------------------------------------------

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

179: where account_id = p_account_id;
180:
181: begin
182:
183: hr_utility.set_location('Entering:'|| l_proc, 10);
184: --
185: -- Store in out parameters
186: --
187: l_object_version_number := p_object_version_number;

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

188: --
189: -- Issue a savepoint
190: --
191: savepoint update_wci_account;
192: hr_utility.set_location(l_proc, 20);
193: --
194: -- Truncate the time portion from all IN date parameters
195: --
196: l_effective_date := trunc(p_effective_date);

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

221: (p_module_name => 'update_wci_account'
222: ,p_hook_type => 'BP'
223: );
224: end;
225: hr_utility.set_location(l_proc, 30);
226: --
227: -- Validation in addition to Row Handlers
228: --
229: hr_utility.set_location(l_proc, 40);

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

225: hr_utility.set_location(l_proc, 30);
226: --
227: -- Validation in addition to Row Handlers
228: --
229: hr_utility.set_location(l_proc, 40);
230: --
231: -- Process Logic
232: --
233: -- Call the row handler

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

240: ,p_location_id => p_location_id
241: ,p_comments => p_comments
242: );
243:
244: hr_utility.set_location(l_proc, 50);
245: --
246: -- Call After Process User Hook
247: --
248: begin

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

263: (p_module_name => 'update_wci_account'
264: ,p_hook_type => 'AP'
265: );
266: end;
267: hr_utility.set_location(l_proc, 60);
268: --
269: -- When in validation only mode raise the Validate_Enabled exception
270: --
271: if p_validate then

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

273: end if;
274: --
275: -- Set all output arguments
276: --
277: hr_utility.set_location(' Leaving:'||l_proc, 70);
278:
279: exception
280:
281: when hr_api.validate_enabled then

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

289: -- (Any key or derived arguments must be set to null
290: -- when validation only mode is being used.)
291: --
292: p_object_version_number := l_object_version_number;
293: hr_utility.set_location(' Leaving:'||l_proc, 80);
294: when others then
295: --
296: -- A validation or unexpected error has occured
297: --

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

301: -- Reset all IN OUT parameters
302: --
303: p_object_version_number := l_object_version_number;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 90);
306: raise;
307: end update_wci_account;
308: --
309: -- ----------------------------------------------------------------------------

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

328: where account_id = p_account_id;
329:
330: begin
331:
332: hr_utility.set_location('Entering:'|| l_proc, 10);
333: --
334: -- Issue a savepoint
335: --
336: savepoint delete_wci_account;

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

333: --
334: -- Issue a savepoint
335: --
336: savepoint delete_wci_account;
337: hr_utility.set_location(l_proc, 20);
338: --
339: -- Truncate the time portion from all IN date parameters
340: --
341: -- Derive necessary parameters

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

358: (p_module_name => 'delete_wci_account'
359: ,p_hook_type => 'BP'
360: );
361: end;
362: hr_utility.set_location(l_proc, 30);
363: --
364: -- Validation in addition to Row Handlers
365: --
366: hr_utility.set_location(l_proc, 40);

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

362: hr_utility.set_location(l_proc, 30);
363: --
364: -- Validation in addition to Row Handlers
365: --
366: hr_utility.set_location(l_proc, 40);
367: --
368: -- Process Logic
369: --
370: -- Call the row handler

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

373: (p_account_id => p_account_id
374: ,p_object_version_number => p_object_version_number
375: );
376:
377: hr_utility.set_location(l_proc, 50);
378: --
379: -- Call After Process User Hook
380: --
381: begin

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

390: (p_module_name => 'delete_wci_account'
391: ,p_hook_type => 'AP'
392: );
393: end;
394: hr_utility.set_location(l_proc, 60);
395: --
396: -- When in validation only mode raise the Validate_Enabled exception
397: --
398: if p_validate then

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

400: end if;
401: --
402: -- Set all output arguments
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 70);
405:
406: exception
407:
408: when hr_api.validate_enabled then

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

415: -- Only set output warning arguments
416: -- (Any key or derived arguments must be set to null
417: -- when validation only mode is being used.)
418: --
419: hr_utility.set_location(' Leaving:'||l_proc, 80);
420: when others then
421: --
422: -- A validation or unexpected error has occured
423: --

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

421: --
422: -- A validation or unexpected error has occured
423: --
424: rollback to delete_wci_account;
425: hr_utility.set_location(' Leaving:'||l_proc, 90);
426: raise;
427:
428: end delete_wci_account;
429: --