[Home] [Help]
PACKAGE BODY: APPS.PSP_REPORT_TEMPLATE_API
Source
1 Package Body PSP_Report_Template_API as
2 /* $Header: PSPRTAIB.pls 120.5 2012/03/08 12:45:50 pnshukla ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' PSP_Report_Template_API.';
7 p_legislation_code varchar(50):=hr_api.userenv_lang;
8
9
10 --
11 -- ----------------------------------------------------------------------------
12 -- |--------------------------< Create_Report_Template >--------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 procedure Create_Report_Template
16 (P_VALIDATE in boolean default false
17 , P_TEMPLATE_ID in NUMBER
18 , P_TEMPLATE_NAME in VARCHAR2
19 , P_BUSINESS_GROUP_ID in NUMBER
20 , P_SET_OF_BOOKS_ID in NUMBER
21 , P_REPORT_TYPE in VARCHAR2
22 , P_PERIOD_FREQUENCY_ID in NUMBER
23 , P_REPORT_TEMPLATE_CODE in VARCHAR2
24 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG in VARCHAR2
25 , P_MANUAL_ENTRY_OVERRIDE_FLAG in VARCHAR2
26 , P_APPROVAL_TYPE in VARCHAR2
27 , P_SUP_LEVELS in NUMBER
28 , P_PREVIEW_EFFORT_REPORT_FLAG in VARCHAR2
29 , P_NOTIFICATION_REMINDER in NUMBER
30 , P_SPRCD_TOLERANCE_AMT in NUMBER
31 , P_SPRCD_TOLERANCE_PERCENT in NUMBER
32 , P_DESCRIPTION in VARCHAR2
33 , P_EGISLATION_CODE in VARCHAR2
34 , P_OBJECT_VERSION_NUMBER out nocopy NUMBER
35 , P_WARNING out nocopy boolean
36 , P_RETURN_STATUS out nocopy boolean
37 , P_CUSTOM_APPROVAL_CODE in VARCHAR2
38 , P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
39 , P_SELECTION_MATCH_LEVEL in VARCHAR2
40 ) is
41 --
42 -- Declare cursors and local variables
43 --
44 -- l_in_out_parameter number;
45 -- l_effective_date date;
46 l_proc varchar2(72) := g_package||'Create_Report_Template';
47
48 l_template_name Psp_Report_Templates.TEMPLATE_NAME%TYPE;
49
50 --
51 -- cursor to check Duplicate TEMPLATE NAME
52 --
53
54 cursor c_template_name
55 is
56 select distinct Template_Name
57 from Psp_Report_Templates
58 where Template_Name = P_TEMPLATE_NAME
59 and report_type = p_report_type ;
60
61 --
62 -- end of cursor
63 --
64
65
66
67
68 begin
69 hr_utility.set_location('Entering:'|| l_proc, 10);
70 --
71 -- Issue a savepoint
72 --
73 savepoint Create_Report_Template;
74 --
75 -- Remember IN OUT parameter IN values
76 --
77 -- l_in_out_parameter := p_in_out_parameter;
78
79 --
80 -- Truncate the time portion from all IN date parameters
81 --
82 -- l_effective_date := trunc(p_effective_date);
83
84
85 open c_template_name;
86 fetch c_template_name into l_template_name;
87 close c_template_name;
88
89 if (l_template_name is not NULL ) then
90 -- Show the appropriate Message
91
92 fnd_message.set_name('PSP', 'PSP_ER_DUP_TEMPLATE_NAME');
93 fnd_message.set_token('TEMPLATE_NAME', p_template_name);
94 fnd_message.raise_error;
95
96 end if;
97
98
99
100 --
101 -- Call Before Process User Hook
102 --
103 begin
104 PSP_Report_Template_BK1.Create_Report_Template_b
105 ( P_TEMPLATE_NAME => P_TEMPLATE_NAME
106 , P_TEMPLATE_ID => P_TEMPLATE_ID
107 , P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
108 , P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
109 , P_REPORT_TYPE => P_REPORT_TYPE
110 , P_PERIOD_FREQUENCY_ID => P_PERIOD_FREQUENCY_ID
111 , P_REPORT_TEMPLATE_CODE => P_REPORT_TEMPLATE_CODE
112 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG => P_DISPLAY_ALL_EMP_DISTRIB_FLAG
113 , P_MANUAL_ENTRY_OVERRIDE_FLAG => P_MANUAL_ENTRY_OVERRIDE_FLAG
114 , P_APPROVAL_TYPE => P_APPROVAL_TYPE
115 , P_SUP_LEVELS => P_SUP_LEVELS
116 , P_PREVIEW_EFFORT_REPORT_FLAG => P_PREVIEW_EFFORT_REPORT_FLAG
117 , P_NOTIFICATION_REMINDER => P_NOTIFICATION_REMINDER
118 , P_SPRCD_TOLERANCE_AMT => P_SPRCD_TOLERANCE_AMT
119 , P_SPRCD_TOLERANCE_PERCENT => P_SPRCD_TOLERANCE_PERCENT
120 , P_DESCRIPTION => P_DESCRIPTION
121 , P_EGISLATION_CODE => P_EGISLATION_CODE
122 ,P_CUSTOM_APPROVAL_CODE => P_CUSTOM_APPROVAL_CODE
123 ,P_HUNDRED_PCENT_EFF_AT_PER_ASG => P_HUNDRED_PCENT_EFF_AT_PER_ASG
124 ,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
125 );
126 exception
127 when hr_api.cannot_find_prog_unit then
128 hr_api.cannot_find_prog_unit_error
129 (p_module_name => 'Create_Report_Template'
130 ,p_hook_type => 'BP'
131 );
132 end;
133 --
134 -- Validation in addition to Row Handlers
135 --
136
137
138
139 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
140 -- Process Logic - Call the row-handler ins procedure
141 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
142
143 psp_prt_ins.ins (
144 p_template_name => p_template_name
145 ,p_business_group_id => p_business_group_id
146 ,p_set_of_books_id => p_set_of_books_id
147 ,p_report_type => p_report_type
148 ,p_period_frequency_id => p_period_frequency_id
149 ,p_report_template_code => p_report_template_code
150 ,p_preview_effort_report_flag => p_preview_effort_report_flag
151 ,p_display_all_emp_distrib_flag => p_display_all_emp_distrib_flag
152 ,p_manual_entry_override_flag => p_manual_entry_override_flag
153 ,p_approval_type => p_approval_type
154 ,p_sup_levels => p_sup_levels
155 ,p_notification_reminder_in_day => p_notification_reminder
156 ,p_sprcd_tolerance_amt => p_sprcd_tolerance_amt
157 ,p_sprcd_tolerance_percent => p_sprcd_tolerance_percent
158 ,p_description => p_description
159 ,p_legislation_code => p_legislation_code
160 ,P_TEMPLATE_ID => P_TEMPLATE_ID
161 ,p_object_version_number => p_object_version_number
162 ,P_CUSTOM_APPROVAL_CODE => P_CUSTOM_APPROVAL_CODE
163 ,P_HUNDRED_PCENT_EFF_AT_PER_ASG => P_HUNDRED_PCENT_EFF_AT_PER_ASG
164 ,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
165 );
166
167 --
168 -- Call After Process User Hook
169 --
170 begin
171 PSP_Report_Template_BK1.Create_Report_Template_a
172 ( P_TEMPLATE_ID => P_TEMPLATE_ID
173 , P_TEMPLATE_NAME => P_TEMPLATE_NAME
174 , P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
175 , P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
176 , P_REPORT_TYPE => P_REPORT_TYPE
177 , P_PERIOD_FREQUENCY_ID => P_PERIOD_FREQUENCY_ID
178 , P_REPORT_TEMPLATE_CODE => P_REPORT_TEMPLATE_CODE
179 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG => P_DISPLAY_ALL_EMP_DISTRIB_FLAG
180 , P_MANUAL_ENTRY_OVERRIDE_FLAG => P_MANUAL_ENTRY_OVERRIDE_FLAG
181 , P_APPROVAL_TYPE => P_APPROVAL_TYPE
182 , P_SUP_LEVELS => P_SUP_LEVELS
183 , P_PREVIEW_EFFORT_REPORT_FLAG => P_PREVIEW_EFFORT_REPORT_FLAG
184 , P_NOTIFICATION_REMINDER => P_NOTIFICATION_REMINDER
185 , P_SPRCD_TOLERANCE_AMT => P_SPRCD_TOLERANCE_AMT
186 , P_SPRCD_TOLERANCE_PERCENT => P_SPRCD_TOLERANCE_PERCENT
187 , P_DESCRIPTION => P_DESCRIPTION
188 , P_EGISLATION_CODE => P_EGISLATION_CODE
189 , P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
190 , P_WARNING => P_WARNING
191 , P_RETURN_STATUS => P_RETURN_STATUS
192 ,P_CUSTOM_APPROVAL_CODE => P_CUSTOM_APPROVAL_CODE
193 ,P_HUNDRED_PCENT_EFF_AT_PER_ASG => P_HUNDRED_PCENT_EFF_AT_PER_ASG
194 ,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
195 );
196 exception
197 when hr_api.cannot_find_prog_unit then
198 hr_api.cannot_find_prog_unit_error
199 (p_module_name => 'Create_Report_Template'
200 ,p_hook_type => 'AP'
201 );
202 end;
203 --
204 -- When in validation only mode raise the Validate_Enabled exception
205 --
206 if p_validate then
207 raise hr_api.validate_enabled;
208 end if;
209 --
210 -- Set all IN OUT and OUT parameters with out values
211 --
212 p_object_version_number := p_object_version_number;
213 --
214 hr_utility.set_location(' Leaving:'||l_proc, 70);
215 exception
216 when hr_api.validate_enabled then
217 --
218 -- As the Validate_Enabled exception has been raised
219 -- we must rollback to the savepoint
220 --
221 rollback to Create_Report_Template;
222 --
223 -- Reset IN OUT parameters and set OUT parameters
224 -- (Any key or derived arguments must be set to null
225 -- when validation only mode is being used.)
226 --
227 p_object_version_number := null;
228 hr_utility.set_location(' Leaving:'||l_proc, 80);
229 when others then
230 --
231 -- A validation or unexpected error has occured
232 --
233 rollback to Create_Report_Template;
234 --
235 -- Reset IN OUT parameters and set all
236 -- OUT parameters, including warnings, to null
237 --
238 p_object_version_number := null;
239 hr_utility.set_location(' Leaving:'||l_proc, 90);
240 raise;
241 end Create_Report_Template;
242
243
244
245
246
247
248
249
250
251
252
253
254 --
255 -- ----------------------------------------------------------------------------
256 -- |--------------------------< Update_Report_Template >--------------------------|
257 -- ----------------------------------------------------------------------------
258 --
259 procedure Update_Report_Template
260 (P_VALIDATE in boolean default false
261 , P_TEMPLATE_ID in NUMBER
262 , P_TEMPLATE_NAME in VARCHAR2
263 , P_BUSINESS_GROUP_ID in NUMBER
264 , P_SET_OF_BOOKS_ID in NUMBER
265 , P_REPORT_TYPE in VARCHAR2
266 , P_PERIOD_FREQUENCY_ID in NUMBER
267 , P_REPORT_TEMPLATE_CODE in VARCHAR2
268 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG in VARCHAR2
269 , P_MANUAL_ENTRY_OVERRIDE_FLAG in VARCHAR2
270 , P_APPROVAL_TYPE in VARCHAR2
271 , P_SUP_LEVELS in NUMBER
272 , P_PREVIEW_EFFORT_REPORT_FLAG in VARCHAR2
273 , P_NOTIFICATION_REMINDER in NUMBER
274 , P_SPRCD_TOLERANCE_AMT in NUMBER
275 , P_SPRCD_TOLERANCE_PERCENT in NUMBER
276 , P_DESCRIPTION in VARCHAR2
277 , P_EGISLATION_CODE in VARCHAR2
278 , P_OBJECT_VERSION_NUMBER in out nocopy NUMBER
279 , P_WARNING out nocopy boolean
280 , P_RETURN_STATUS out nocopy boolean
281 ,P_CUSTOM_APPROVAL_CODE in VARCHAR2
282 , P_HUNDRED_PCENT_EFF_AT_PER_ASG in VARCHAR2
283 , P_SELECTION_MATCH_LEVEL in VARCHAR2
284 ) is
285 --
286 -- Declare cursors and local variables
287 --
288 l_in_out_parameter number;
289 l_effective_date date;
290 l_proc varchar2(72) := g_package||'<BUS_PROCESS_NAME>';
291 begin
292 hr_utility.set_location('Entering:'|| l_proc, 10);
293 --
294 -- Issue a savepoint
295 --
296 savepoint Update_Report_Template;
297 --
298 -- Remember IN OUT parameter IN values
299 --
300 -- l_in_out_parameter := p_in_out_parameter;
301
302 --
303 -- Truncate the time portion from all IN date parameters
304 --
305 -- l_effective_date := trunc(p_effective_date);
306
307 --
308 -- Call Before Process User Hook
309 --
310 begin
311 PSP_Report_Template_BK2.Update_Report_Template_b
312
313 ( P_TEMPLATE_ID => P_TEMPLATE_ID
314 , P_TEMPLATE_NAME => P_TEMPLATE_NAME
315 , P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
316 , P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
317 , P_REPORT_TYPE => P_REPORT_TYPE
318 , P_PERIOD_FREQUENCY_ID => P_PERIOD_FREQUENCY_ID
319 , P_REPORT_TEMPLATE_CODE => P_REPORT_TEMPLATE_CODE
320 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG => P_DISPLAY_ALL_EMP_DISTRIB_FLAG
321 , P_MANUAL_ENTRY_OVERRIDE_FLAG => P_MANUAL_ENTRY_OVERRIDE_FLAG
322 , P_APPROVAL_TYPE => P_APPROVAL_TYPE
323 , P_SUP_LEVELS => P_SUP_LEVELS
324 , P_PREVIEW_EFFORT_REPORT_FLAG => P_PREVIEW_EFFORT_REPORT_FLAG
325 , P_NOTIFICATION_REMINDER => P_NOTIFICATION_REMINDER
326 , P_SPRCD_TOLERANCE_AMT => P_SPRCD_TOLERANCE_AMT
327 , P_SPRCD_TOLERANCE_PERCENT => P_SPRCD_TOLERANCE_PERCENT
328 , P_DESCRIPTION => P_DESCRIPTION
329 , P_EGISLATION_CODE => P_EGISLATION_CODE
330 ,P_CUSTOM_APPROVAL_CODE => P_CUSTOM_APPROVAL_CODE
331 ,P_HUNDRED_PCENT_EFF_AT_PER_ASG => P_HUNDRED_PCENT_EFF_AT_PER_ASG
332 ,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
333 );
334 exception
335 when hr_api.cannot_find_prog_unit then
336 hr_api.cannot_find_prog_unit_error
337 (p_module_name => 'Update_Report_Template'
338 ,p_hook_type => 'BP'
339 );
340 end;
341 --
342 -- Validation in addition to Row Handlers
343 --
344
345
346
347 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
348 -- Process Logic - Call the row-handler upd procedure
349 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
350 psp_prt_upd.upd(
351 p_template_id => p_template_id
352 ,p_object_version_number => p_object_version_number
353 ,p_template_name => p_template_name
354 ,p_business_group_id => p_business_group_id
355 ,p_set_of_books_id => p_set_of_books_id
356 ,p_report_type => p_report_type
357 ,p_period_frequency_id => p_period_frequency_id
358 ,p_report_template_code => p_report_template_code
359 ,p_preview_effort_report_flag => p_preview_effort_report_flag
360 ,p_display_all_emp_distrib_flag => p_display_all_emp_distrib_flag
361 ,p_manual_entry_override_flag => p_manual_entry_override_flag
362 ,p_approval_type => p_approval_type
363 ,p_sup_levels => p_sup_levels
364 ,p_notification_reminder_in_day => p_notification_reminder
365 ,p_sprcd_tolerance_amt => p_sprcd_tolerance_amt
366 ,p_sprcd_tolerance_percent => p_sprcd_tolerance_percent
367 ,p_description => p_description
368 ,p_legislation_code => p_legislation_code
369 ,P_CUSTOM_APPROVAL_CODE => P_CUSTOM_APPROVAL_CODE
370 ,P_HUNDRED_PCENT_EFF_AT_PER_ASG => P_HUNDRED_PCENT_EFF_AT_PER_ASG
371 ,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
372 );
373
374
375 --
376 -- Call After Process User Hook
377 --
378 begin
379 PSP_Report_Template_BK2.Update_Report_Template_a
380 ( P_TEMPLATE_ID => P_TEMPLATE_ID
381 , P_TEMPLATE_NAME => P_TEMPLATE_NAME
382 , P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
383 , P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
384 , P_REPORT_TYPE => P_REPORT_TYPE
385 , P_PERIOD_FREQUENCY_ID => P_PERIOD_FREQUENCY_ID
386 , P_REPORT_TEMPLATE_CODE => P_REPORT_TEMPLATE_CODE
387 , P_DISPLAY_ALL_EMP_DISTRIB_FLAG => P_DISPLAY_ALL_EMP_DISTRIB_FLAG
388 , P_MANUAL_ENTRY_OVERRIDE_FLAG => P_MANUAL_ENTRY_OVERRIDE_FLAG
389 , P_APPROVAL_TYPE => P_APPROVAL_TYPE
390 , P_SUP_LEVELS => P_SUP_LEVELS
391 , P_PREVIEW_EFFORT_REPORT_FLAG => P_PREVIEW_EFFORT_REPORT_FLAG
392 , P_NOTIFICATION_REMINDER => P_NOTIFICATION_REMINDER
393 , P_SPRCD_TOLERANCE_AMT => P_SPRCD_TOLERANCE_AMT
394 , P_SPRCD_TOLERANCE_PERCENT => P_SPRCD_TOLERANCE_PERCENT
395 , P_DESCRIPTION => P_DESCRIPTION
396 , P_EGISLATION_CODE => P_EGISLATION_CODE
397 , P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
398 , P_WARNING => P_WARNING
399 , P_RETURN_STATUS => P_RETURN_STATUS
400 ,P_CUSTOM_APPROVAL_CODE => P_CUSTOM_APPROVAL_CODE
401 ,P_HUNDRED_PCENT_EFF_AT_PER_ASG => P_HUNDRED_PCENT_EFF_AT_PER_ASG
402 ,P_SELECTION_MATCH_LEVEL => P_SELECTION_MATCH_LEVEL
403 );
404 exception
405 when hr_api.cannot_find_prog_unit then
406 hr_api.cannot_find_prog_unit_error
407 (p_module_name => 'Update_Report_Template'
408 ,p_hook_type => 'AP'
409 );
410 end;
411 --
412 -- When in validation only mode raise the Validate_Enabled exception
413 --
414 if p_validate then
415 raise hr_api.validate_enabled;
416 end if;
417 --
418 -- Set all IN OUT and OUT parameters with out values
419 --
420 -- p_id := p_id ;
421 -- p_in_out_parameter := p_in_out_parameter ;
422 p_object_version_number := p_object_version_number;
423 -- p_some_warning := p_some_warning ;
424 --
425 hr_utility.set_location(' Leaving:'||l_proc, 70);
426 exception
427 when hr_api.validate_enabled then
428 --
429 -- As the Validate_Enabled exception has been raised
430 -- we must rollback to the savepoint
431 --
432 rollback to Update_Report_Template;
433 --
434 -- Reset IN OUT parameters and set OUT parameters
435 -- (Any key or derived arguments must be set to null
436 -- when validation only mode is being used.)
437 --
438 -- p_in_out_parameter := l_in_out_parameter;
439 -- p_id := null;
440 p_object_version_number := null;
441 -- p_some_warning := p_some_warning ;
442 hr_utility.set_location(' Leaving:'||l_proc, 80);
443 when others then
444 --
445 -- A validation or unexpected error has occured
446 --
447 rollback to Update_Report_Template;
448 --
449 -- Reset IN OUT parameters and set all
450 -- OUT parameters, including warnings, to null
451 --
452 -- p_in_out_parameter := l_in_out_parameter;
453 -- p_id := null;
454 p_object_version_number := null;
455 -- p_some_warning := null;
456 hr_utility.set_location(' Leaving:'||l_proc, 90);
457 raise;
458 end Update_Report_Template;
459
460
461
462 --
463 -- ----------------------------------------------------------------------------
464 -- |--------------------------< Delete_Report_Template >--------------------------|
465 -- ----------------------------------------------------------------------------
466 --
467 procedure Delete_Report_Template
468 ( P_VALIDATE in BOOLEAN default false
469 ,P_TEMPLATE_ID in number
470 ,P_OBJECT_VERSION_NUMBER in out nocopy number
471 ,P_WARNING out nocopy varchar2
472 ) is
473 --
474 -- Declare cursors and local variables
475 --
476 l_in_out_parameter number;
477 l_effective_date date;
478 l_proc varchar2(72) := g_package||'<BUS_PROCESS_NAME>';
479 begin
480 hr_utility.set_location('Entering:'|| l_proc, 10);
481 --
482 -- Issue a savepoint
483 --
484 savepoint Delete_Report_template;
485 --
486 -- Remember IN OUT parameter IN values
487 --
488 -- l_in_out_parameter := p_in_out_parameter;
489
490 --
491 -- Truncate the time portion from all IN date parameters
492 --
493 -- l_effective_date := trunc(p_effective_date);
494
495 --
496 -- Call Before Process User Hook
497 --
498 begin
499 PSP_Report_Template_BK3.Delete_Report_template_b
500 ( P_TEMPLATE_ID => P_TEMPLATE_ID
501 );
502 exception
503 when hr_api.cannot_find_prog_unit then
504 hr_api.cannot_find_prog_unit_error
505 (p_module_name => 'Delete_Report_template'
506 ,p_hook_type => 'BP'
507 );
508 end;
509 --
510 -- Validation in addition to Row Handlers
511 --
512
513
514
515 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
516 -- Process Logic - Call the row-handler del procedure
517 -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
518
519
520 psp_prt_del.del(
521 p_template_id => p_template_id
522 ,p_object_version_number => p_object_version_number
523 );
524
525
526 --
527 -- Call After Process User Hook
528 --
529 begin
530 PSP_Report_Template_BK3.Delete_Report_template_a
531 ( P_TEMPLATE_ID => P_TEMPLATE_ID
532 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
533 ,P_WARNING => P_WARNING
534
535 );
536 exception
537 when hr_api.cannot_find_prog_unit then
538 hr_api.cannot_find_prog_unit_error
539 (p_module_name => 'Delete_Report_template'
540 ,p_hook_type => 'AP'
541 );
542 end;
543 --
544 -- When in validation only mode raise the Validate_Enabled exception
545 --
546 if p_validate then
547 raise hr_api.validate_enabled;
548 end if;
549 --
550 -- Set all IN OUT and OUT parameters with out values
551 --
552 -- p_id := p_id ;
553 -- p_in_out_parameter := p_in_out_parameter ;
554 p_object_version_number := p_object_version_number;
555 -- p_some_warning := p_some_warning ;
556 --
557 hr_utility.set_location(' Leaving:'||l_proc, 70);
558 exception
559 when hr_api.validate_enabled then
560 --
561 -- As the Validate_Enabled exception has been raised
562 -- we must rollback to the savepoint
563 --
564 rollback to Delete_Report_template;
565 --
566 -- Reset IN OUT parameters and set OUT parameters
567 -- (Any key or derived arguments must be set to null
568 -- when validation only mode is being used.)
569 --
570 -- p_in_out_parameter := l_in_out_parameter;
571 -- p_id := null;
572 p_object_version_number := null;
573 -- p_some_warning := p_some_warning ;
574 hr_utility.set_location(' Leaving:'||l_proc, 80);
575 when others then
576 --
577 -- A validation or unexpected error has occured
578 --
579 rollback to Delete_Report_template;
580 --
581 -- Reset IN OUT parameters and set all
582 -- OUT parameters, including warnings, to null
583 --
584 -- p_in_out_parameter := l_in_out_parameter;
585 -- p_id := null;
586 p_object_version_number := null;
587 -- p_some_warning := null;
588 hr_utility.set_location(' Leaving:'||l_proc, 90);
589 raise;
590 end Delete_Report_template;
591 --
592 end PSP_Report_Template_API;