DBA Data[Home] [Help]

APPS.PAY_WCI_RATES_API dependencies on HR_UTILITY

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

31: where account_id = p_account_id;
32:
33: begin
34:
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Derive necessary parameters
38: --
39: open csr_business_group_id;

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

42: --
43: -- Issue a savepoint
44: --
45: savepoint create_wci_rate;
46: hr_utility.set_location(l_proc, 20);
47: --
48: -- Truncate the time portion from all IN date parameters
49: --
50: -- Call Before Process User Hook

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

65: (p_module_name => 'create_wci_rate'
66: ,p_hook_type => 'BP'
67: );
68: end;
69: hr_utility.set_location(l_proc, 30);
70: --
71: -- Validation in addition to Row Handlers
72: --
73: hr_utility.set_location(l_proc, 40);

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

69: hr_utility.set_location(l_proc, 30);
70: --
71: -- Validation in addition to Row Handlers
72: --
73: hr_utility.set_location(l_proc, 40);
74: --
75: -- Process Logic
76: --
77: -- Call the row handler

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

86: ,p_comments => p_comments
87: ,p_object_version_number => p_object_version_number
88: );
89:
90: hr_utility.set_location(l_proc, 50);
91: --
92: -- Call After Process User Hook
93: --
94: begin

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

108: (p_module_name => 'create_wci_rate'
109: ,p_hook_type => 'AP'
110: );
111: end;
112: hr_utility.set_location(l_proc, 60);
113: --
114: -- When in validation only mode raise the Validate_Enabled exception
115: --
116: if p_validate then

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

118: end if;
119: --
120: -- Set all output arguments
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 70);
123:
124: exception
125:
126: when hr_api.validate_enabled then

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

135: -- when validation only mode is being used.)
136: --
137: p_rate_id := null;
138: p_object_version_number := null;
139: hr_utility.set_location(' Leaving:'||l_proc, 80);
140: when others then
141: --
142: -- A validation or unexpected error has occured
143: --

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

148: --
149: p_rate_id := null;
150: p_object_version_number := null;
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 90);
153: raise;
154: end create_wci_rate;
155: --
156: -- ----------------------------------------------------------------------------

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

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

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

189: --
190: -- Issue a savepoint
191: --
192: savepoint update_wci_rate;
193: hr_utility.set_location(l_proc, 20);
194: --
195: -- Truncate the time portion from all IN date parameters
196: --
197: -- Derive necessary parameters

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

327: where rate_id = p_rate_id;
328:
329: begin
330:
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: --
333: -- Issue a savepoint
334: --
335: savepoint delete_wci_rate;

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

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

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

358: (p_module_name => 'delete_wci_rate'
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_rate_id => p_rate_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_rate'
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_rate;
425: hr_utility.set_location(' Leaving:'||l_proc, 90);
426: raise;
427:
428: end delete_wci_rate;
429: --