DBA Data[Home] [Help]

APPS.HR_CAGR_GRADES_API dependencies on HR_API

Line 62: When HR_Api.Object_Locked then

58: --
59: hr_utility.set_location('Leaving:'|| l_proc, 30);
60: --
61: Exception
62: When HR_Api.Object_Locked then
63: rollback; -- Added for bug 3578845.
64: hr_utility.set_location('Leaving:'|| l_proc, 40);
65: end update_concat_segs_auto;
66: --

Line 286: when hr_api.cannot_find_prog_unit then

282: ,p_concat_segments => p_concat_segments
283: ,p_effective_date => trunc(p_effective_date)
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (
289: p_module_name => 'CREATE_CAGR_GRADES'
290: ,p_hook_type => 'BP'

Line 287: hr_api.cannot_find_prog_unit_error

283: ,p_effective_date => trunc(p_effective_date)
284: );
285: exception
286: when hr_api.cannot_find_prog_unit then
287: hr_api.cannot_find_prog_unit_error
288: (
289: p_module_name => 'CREATE_CAGR_GRADES'
290: ,p_hook_type => 'BP'
291: );

Line 408: when hr_api.cannot_find_prog_unit then

404: ,p_object_version_number => l_object_version_number
405: ,p_effective_date => trunc(p_effective_date));
406: --
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'CREATE_CAGR_GRADES'
411: ,p_hook_type => 'AP'
412: );

Line 409: hr_api.cannot_find_prog_unit_error

405: ,p_effective_date => trunc(p_effective_date));
406: --
407: exception
408: when hr_api.cannot_find_prog_unit then
409: hr_api.cannot_find_prog_unit_error
410: (p_module_name => 'CREATE_CAGR_GRADES'
411: ,p_hook_type => 'AP'
412: );
413: end;

Line 422: raise hr_api.validate_enabled;

418: --
419: -- When in validation only mode raise the Validate_Enabled exception
420: --
421: if p_validate then
422: raise hr_api.validate_enabled;
423: end if;
424: --
425: -- Set all output arguments
426: --

Line 436: when hr_api.validate_enabled then

432: hr_utility.set_location(' Leaving:'||l_proc, 70);
433: --
434: exception
435: --
436: when hr_api.validate_enabled then
437: --
438: -- As the Validate_Enabled exception has been raised
439: -- we must rollback to the savepoint
440: --

Line 479: ,p_sequence in number default hr_api.g_number

475: --
476: procedure update_cagr_grades
477: (p_validate in boolean default false
478: ,p_cagr_grade_id in number
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 480: ,p_segment1 in varchar2 default hr_api.g_varchar2

476: procedure update_cagr_grades
477: (p_validate in boolean default false
478: ,p_cagr_grade_id in number
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 481: ,p_segment2 in varchar2 default hr_api.g_varchar2

477: (p_validate in boolean default false
478: ,p_cagr_grade_id in number
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 482: ,p_segment3 in varchar2 default hr_api.g_varchar2

478: ,p_cagr_grade_id in number
479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 483: ,p_segment4 in varchar2 default hr_api.g_varchar2

479: ,p_sequence in number default hr_api.g_number
480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 484: ,p_segment5 in varchar2 default hr_api.g_varchar2

480: ,p_segment1 in varchar2 default hr_api.g_varchar2
481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 485: ,p_segment6 in varchar2 default hr_api.g_varchar2

481: ,p_segment2 in varchar2 default hr_api.g_varchar2
482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 486: ,p_segment7 in varchar2 default hr_api.g_varchar2

482: ,p_segment3 in varchar2 default hr_api.g_varchar2
483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 487: ,p_segment8 in varchar2 default hr_api.g_varchar2

483: ,p_segment4 in varchar2 default hr_api.g_varchar2
484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 488: ,p_segment9 in varchar2 default hr_api.g_varchar2

484: ,p_segment5 in varchar2 default hr_api.g_varchar2
485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 489: ,p_segment10 in varchar2 default hr_api.g_varchar2

485: ,p_segment6 in varchar2 default hr_api.g_varchar2
486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 490: ,p_segment11 in varchar2 default hr_api.g_varchar2

486: ,p_segment7 in varchar2 default hr_api.g_varchar2
487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 491: ,p_segment12 in varchar2 default hr_api.g_varchar2

487: ,p_segment8 in varchar2 default hr_api.g_varchar2
488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 492: ,p_segment13 in varchar2 default hr_api.g_varchar2

488: ,p_segment9 in varchar2 default hr_api.g_varchar2
489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 493: ,p_segment14 in varchar2 default hr_api.g_varchar2

489: ,p_segment10 in varchar2 default hr_api.g_varchar2
490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 494: ,p_segment15 in varchar2 default hr_api.g_varchar2

490: ,p_segment11 in varchar2 default hr_api.g_varchar2
491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 495: ,p_segment16 in varchar2 default hr_api.g_varchar2

491: ,p_segment12 in varchar2 default hr_api.g_varchar2
492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 496: ,p_segment17 in varchar2 default hr_api.g_varchar2

492: ,p_segment13 in varchar2 default hr_api.g_varchar2
493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2

Line 497: ,p_segment18 in varchar2 default hr_api.g_varchar2

493: ,p_segment14 in varchar2 default hr_api.g_varchar2
494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
501: ,p_object_version_number in out nocopy number

Line 498: ,p_segment19 in varchar2 default hr_api.g_varchar2

494: ,p_segment15 in varchar2 default hr_api.g_varchar2
495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
501: ,p_object_version_number in out nocopy number
502: ,p_effective_date in date

Line 499: ,p_segment20 in varchar2 default hr_api.g_varchar2

495: ,p_segment16 in varchar2 default hr_api.g_varchar2
496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
501: ,p_object_version_number in out nocopy number
502: ,p_effective_date in date
503: ,p_name out nocopy varchar2

Line 500: ,p_concat_segments in varchar2 default hr_api.g_varchar2

496: ,p_segment17 in varchar2 default hr_api.g_varchar2
497: ,p_segment18 in varchar2 default hr_api.g_varchar2
498: ,p_segment19 in varchar2 default hr_api.g_varchar2
499: ,p_segment20 in varchar2 default hr_api.g_varchar2
500: ,p_concat_segments in varchar2 default hr_api.g_varchar2
501: ,p_object_version_number in out nocopy number
502: ,p_effective_date in date
503: ,p_name out nocopy varchar2
504: ,p_cagr_grade_def_id in out nocopy number) is

Line 674: when hr_api.cannot_find_prog_unit then

670: ,p_effective_date => trunc(p_effective_date));
671: --
672: exception
673: --
674: when hr_api.cannot_find_prog_unit then
675: hr_api.cannot_find_prog_unit_error
676: (p_module_name => 'UPDATE_CAGR_GRADES'
677: ,p_hook_type => 'BP'
678: );

Line 675: hr_api.cannot_find_prog_unit_error

671: --
672: exception
673: --
674: when hr_api.cannot_find_prog_unit then
675: hr_api.cannot_find_prog_unit_error
676: (p_module_name => 'UPDATE_CAGR_GRADES'
677: ,p_hook_type => 'BP'
678: );
679: --

Line 799: when hr_api.cannot_find_prog_unit then

795: ,p_object_version_number => l_object_version_number);
796: --
797: exception
798: --
799: when hr_api.cannot_find_prog_unit then
800: --
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'UPDATE_CAGR_GRADES'
803: ,p_hook_type => 'AP');

Line 801: hr_api.cannot_find_prog_unit_error

797: exception
798: --
799: when hr_api.cannot_find_prog_unit then
800: --
801: hr_api.cannot_find_prog_unit_error
802: (p_module_name => 'UPDATE_CAGR_GRADES'
803: ,p_hook_type => 'AP');
804: --
805: -- End of API User Hook for the after hook of update_cagr_grades

Line 814: raise hr_api.validate_enabled;

810: --
811: -- When in validation only mode raise the Validate_Enabled exception
812: --
813: if p_validate then
814: raise hr_api.validate_enabled;
815: end if;
816: --
817: -- Set all output arguments
818: --

Line 827: when hr_api.validate_enabled then

823: hr_utility.set_location(' Leaving:'||l_proc, 997);
824: --
825: exception
826: --
827: when hr_api.validate_enabled then
828: --
829: hr_utility.set_location(' Leaving:'||l_proc, 998);
830: --
831: -- As the Validate_Enabled exception has been raised

Line 906: when hr_api.cannot_find_prog_unit then

902: ,p_object_version_number => p_object_version_number
903: ,p_effective_date => trunc(p_effective_date)
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'DELETE_CAGR_GRADES'
909: ,p_hook_type => 'BP'
910: );

Line 907: hr_api.cannot_find_prog_unit_error

903: ,p_effective_date => trunc(p_effective_date)
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'DELETE_CAGR_GRADES'
909: ,p_hook_type => 'BP'
910: );
911: --

Line 933: when hr_api.cannot_find_prog_unit then

929: ,p_object_version_number => l_object_version_number
930: ,p_effective_date => trunc(p_effective_date)
931: );
932: exception
933: when hr_api.cannot_find_prog_unit then
934: hr_api.cannot_find_prog_unit_error
935: (p_module_name => 'DELETE_CAGR_GRADES'
936: ,p_hook_type => 'AP'
937: );

Line 934: hr_api.cannot_find_prog_unit_error

930: ,p_effective_date => trunc(p_effective_date)
931: );
932: exception
933: when hr_api.cannot_find_prog_unit then
934: hr_api.cannot_find_prog_unit_error
935: (p_module_name => 'DELETE_CAGR_GRADES'
936: ,p_hook_type => 'AP'
937: );
938: --

Line 948: raise hr_api.validate_enabled;

944: --
945: -- When in validation only mode raise the Validate_Enabled exception
946: --
947: if p_validate then
948: raise hr_api.validate_enabled;
949: end if;
950: --
951: -- Set all output arguments
952: --

Line 959: when hr_api.validate_enabled then

955: hr_utility.set_location(' Leaving:'||l_proc, 70);
956: --
957: exception
958: --
959: when hr_api.validate_enabled then
960: --
961: -- As the Validate_Enabled exception has been raised
962: -- we must rollback to the savepoint
963: --