DBA Data[Home] [Help]

APPS.PER_BF_PROC_ASSIGNMENT_API dependencies on HR_UTILITY

Line 33: hr_utility.set_message(800,'PER_289340_BF_PROC_ASGN_EXISTS');

29: CLOSE csr_find_row;
30: --
31: -- Row already exists for assignment/payroll combination
32: -- Raise error
33: hr_utility.set_message(800,'PER_289340_BF_PROC_ASGN_EXISTS');
34: hr_utility.raise_error;
35: END IF;
36: CLOSE csr_find_row;
37: --

Line 34: hr_utility.raise_error;

30: --
31: -- Row already exists for assignment/payroll combination
32: -- Raise error
33: hr_utility.set_message(800,'PER_289340_BF_PROC_ASGN_EXISTS');
34: hr_utility.raise_error;
35: END IF;
36: CLOSE csr_find_row;
37: --
38: END chk_row_exists;

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

91: --
92: l_proc varchar2(72) := g_package||'create_processed_assignment';
93: --
94: begin
95: hr_utility.set_location('Entering:'|| l_proc, 10);
96: --
97: -- Issue a savepoint
98: --
99: savepoint create_processed_assignment;

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

96: --
97: -- Issue a savepoint
98: --
99: savepoint create_processed_assignment;
100: hr_utility.set_location(l_proc, 20);
101: --
102: -- Truncate the time portion from all IN date parameters
103: --
104: --

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

149: (p_module_name => 'CREATE_PROCESSED_ASSIGNMENT'
150: ,p_hook_type => 'BP'
151: );
152: end;
153: hr_utility.set_location(l_proc, 30);
154: --
155: -- Validation in addition to Row Handlers
156: --
157: chk_row_exists(p_assignment_id => p_assignment_id

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

199: ,p_object_version_number => l_processed_assignment_ovn
200: );
201: --
202: --
203: hr_utility.set_location(l_proc, 50);
204: --
205: -- Call After Process User Hook
206: --
207: begin

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

249: (p_module_name => 'CREATE_PROCESSED_ASSIGNMENT'
250: ,p_hook_type => 'AP'
251: );
252: end;
253: hr_utility.set_location(l_proc, 60);
254: --
255: -- When in validation only mode raise the Validate_Enabled exception
256: --
257: if p_validate then

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

262: --
263: p_processed_assignment_id := l_processed_assignment_id;
264: p_processed_assignment_ovn:= l_processed_assignment_ovn;
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 70);
267: exception
268: when hr_api.validate_enabled then
269: --
270: -- As the Validate_Enabled exception has been raised

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

278: --
279: p_processed_assignment_id := null;
280: p_processed_assignment_ovn:= null;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 80);
283: when others then
284: --
285: -- A validation or unexpected error has occured
286: --

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

287: rollback to create_processed_assignment;
288: --set out variables
289: p_processed_assignment_id := null;
290: p_processed_assignment_ovn:= null;
291: hr_utility.set_location(' Leaving:'||l_proc, 90);
292: raise;
293: end CREATE_PROCESSED_ASSIGNMENT;
294: --
295: -- ----------------------------------------------------------------------------

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

342: PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;
343: --
344: l_proc varchar2(72) := g_package||'update_processed_assignment';
345: begin
346: hr_utility.set_location('Entering:'|| l_proc, 10);
347: --
348: -- Issue a savepoint
349: --
350: savepoint update_processed_assignment;

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

347: --
348: -- Issue a savepoint
349: --
350: savepoint update_processed_assignment;
351: hr_utility.set_location(l_proc, 20);
352: --
353: -- Truncate the time portion from all IN date parameters
354: --
355: --

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

400: (p_module_name => 'UPDATE_PROCESSED_ASSIGNMENT'
401: ,p_hook_type => 'BP'
402: );
403: end;
404: hr_utility.set_location(l_proc, 30);
405: --
406: -- Process Logic
407: --
408: l_processed_assignment_ovn := p_processed_assignment_ovn;

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

444: ,p_object_version_number => l_processed_assignment_ovn
445: );
446: --
447: --
448: hr_utility.set_location(l_proc, 50);
449: --
450: -- Call After Process User Hook
451: --
452: begin

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

492: (p_module_name => 'UPDATE_PROCESSED_ASSIGNMENT'
493: ,p_hook_type => 'AP'
494: );
495: end;
496: hr_utility.set_location(l_proc, 60);
497: --
498: -- When in validation only mode raise the Validate_Enabled exception
499: --
500: if p_validate then

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

504: -- Set all output arguments
505: --
506: p_processed_assignment_ovn := l_processed_assignment_ovn;
507: --
508: hr_utility.set_location(' Leaving:'||l_proc, 70);
509: exception
510: when hr_api.validate_enabled then
511: --
512: -- As the Validate_Enabled exception has been raised

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

519: -- when validation only mode is being used.)
520: --
521: p_processed_assignment_ovn := null;
522: --
523: hr_utility.set_location(' Leaving:'||l_proc, 80);
524: when others then
525: --
526: -- A validation or unexpected error has occured
527: --

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

527: --
528: rollback to update_processed_assignment;
529: --set out variables
530: p_processed_assignment_ovn := null;
531: hr_utility.set_location(' Leaving:'||l_proc, 90);
532: raise;
533: end UPDATE_PROCESSED_ASSIGNMENT;
534: --
535: -- ----------------------------------------------------------------------------

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

546: --
547: l_proc varchar2(72) := g_package||'delete_processed_assignment';
548: --
549: begin
550: hr_utility.set_location('Entering:'|| l_proc, 10);
551: --
552: -- Issue a savepoint
553: --
554: savepoint delete_processed_assignment;

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

551: --
552: -- Issue a savepoint
553: --
554: savepoint delete_processed_assignment;
555: hr_utility.set_location(l_proc, 20);
556: --
557: -- Truncate the time portion from all IN date parameters
558: --
559: --

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

571: (p_module_name => 'DELETE_PROCESSED_ASSIGNMENT'
572: ,p_hook_type => 'BP'
573: );
574: end;
575: hr_utility.set_location(l_proc, 30);
576: --
577: -- Validation in addition to Row Handlers
578: --
579: --

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

576: --
577: -- Validation in addition to Row Handlers
578: --
579: --
580: hr_utility.set_location(l_proc, 40);
581: --
582: -- Process Logic
583: --
584: per_bpa_del.del

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

586: ,p_object_version_number => p_processed_assignment_ovn
587: );
588: --
589: --
590: hr_utility.set_location(l_proc, 50);
591: --
592: -- Call After Process User Hook
593: --
594: begin

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

603: (p_module_name => 'DELETE_PROCESSED_ASSIGNMENT'
604: ,p_hook_type => 'AP'
605: );
606: end;
607: hr_utility.set_location(l_proc, 60);
608: --
609: -- When in validation only mode raise the Validate_Enabled exception
610: --
611: if p_validate then

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

613: end if;
614: --
615: -- Set all output arguments
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 70);
618: exception
619: when hr_api.validate_enabled then
620: --
621: -- As the Validate_Enabled exception has been raised

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

626: -- Only set output warning arguments
627: -- (Any key or derived arguments must be set to null
628: -- when validation only mode is being used.)
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 80);
631: when others then
632: --
633: -- A validation or unexpected error has occured
634: --

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

632: --
633: -- A validation or unexpected error has occured
634: --
635: rollback to delete_processed_assignment;
636: hr_utility.set_location(' Leaving:'||l_proc, 90);
637: raise;
638: end DELETE_PROCESSED_ASSIGNMENT;
639: --
640: end PER_BF_PROC_ASSIGNMENT_API;