eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_GRADE_SCALE_API dependencies on HR_API

Line 117: when hr_api.cannot_find_prog_unit then

113: ,p_program_id => p_program_id
114: ,p_program_update_date => p_program_update_date
115: );
116: exception
117: when hr_api.cannot_find_prog_unit then
118: hr_api.cannot_find_prog_unit_error
119: (p_module_name => 'CREATE_GRADE_SCALE'
120: ,p_hook_type => 'BP'
121: );

Line 118: hr_api.cannot_find_prog_unit_error

114: ,p_program_update_date => p_program_update_date
115: );
116: exception
117: when hr_api.cannot_find_prog_unit then
118: hr_api.cannot_find_prog_unit_error
119: (p_module_name => 'CREATE_GRADE_SCALE'
120: ,p_hook_type => 'BP'
121: );
122: --

Line 215: when hr_api.cannot_find_prog_unit then

211: ,p_effective_start_date => l_effective_start_date
212: ,p_effective_end_date => l_effective_end_date
213: );
214: exception
215: when hr_api.cannot_find_prog_unit then
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'CREATE_GRADE_SCALE'
218: ,p_hook_type => 'AP'
219: );

Line 216: hr_api.cannot_find_prog_unit_error

212: ,p_effective_end_date => l_effective_end_date
213: );
214: exception
215: when hr_api.cannot_find_prog_unit then
216: hr_api.cannot_find_prog_unit_error
217: (p_module_name => 'CREATE_GRADE_SCALE'
218: ,p_hook_type => 'AP'
219: );
220: --

Line 229: raise hr_api.validate_enabled;

225: -- When in validation only mode raise the Validate_Enabled exception
226: --
227: if p_validate
228: then
229: raise hr_api.validate_enabled;
230: end if;
231: --
232: hr_utility.set_location(l_proc, 80);
233: --

Line 246: when hr_api.validate_enabled then

242: hr_utility.set_location(' Leaving:' ||l_proc, 90);
243: --
244: exception
245: --
246: when hr_api.validate_enabled then
247: --
248: -- As the Validate_Enabled exception has been raised
249: -- we must rollback to the savepoint
250: --

Line 290: ,p_effective_date in date default hr_api.g_date

286: -- ----------------------------------------------------------------------------
287: --
288: procedure update_grade_scale
289: (p_validate in boolean default false
290: ,p_effective_date in date default hr_api.g_date
291: ,p_datetrack_mode in varchar2
292: ,p_grade_spine_id in number
293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number

Line 294: ,p_business_group_id in number default hr_api.g_number

290: ,p_effective_date in date default hr_api.g_date
291: ,p_datetrack_mode in varchar2
292: ,p_grade_spine_id in number
293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_parent_spine_id in number default hr_api.g_number
296: ,p_grade_id in number default hr_api.g_number
297: ,p_ceiling_step_id in number default hr_api.g_number
298: ,p_starting_step in number default hr_api.g_number

Line 295: ,p_parent_spine_id in number default hr_api.g_number

291: ,p_datetrack_mode in varchar2
292: ,p_grade_spine_id in number
293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_parent_spine_id in number default hr_api.g_number
296: ,p_grade_id in number default hr_api.g_number
297: ,p_ceiling_step_id in number default hr_api.g_number
298: ,p_starting_step in number default hr_api.g_number
299: ,p_request_id in number default hr_api.g_number

Line 296: ,p_grade_id in number default hr_api.g_number

292: ,p_grade_spine_id in number
293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_parent_spine_id in number default hr_api.g_number
296: ,p_grade_id in number default hr_api.g_number
297: ,p_ceiling_step_id in number default hr_api.g_number
298: ,p_starting_step in number default hr_api.g_number
299: ,p_request_id in number default hr_api.g_number
300: ,p_program_application_id in number default hr_api.g_number

Line 297: ,p_ceiling_step_id in number default hr_api.g_number

293: ,p_object_version_number in out nocopy number
294: ,p_business_group_id in number default hr_api.g_number
295: ,p_parent_spine_id in number default hr_api.g_number
296: ,p_grade_id in number default hr_api.g_number
297: ,p_ceiling_step_id in number default hr_api.g_number
298: ,p_starting_step in number default hr_api.g_number
299: ,p_request_id in number default hr_api.g_number
300: ,p_program_application_id in number default hr_api.g_number
301: ,p_program_id in number default hr_api.g_number

Line 298: ,p_starting_step in number default hr_api.g_number

294: ,p_business_group_id in number default hr_api.g_number
295: ,p_parent_spine_id in number default hr_api.g_number
296: ,p_grade_id in number default hr_api.g_number
297: ,p_ceiling_step_id in number default hr_api.g_number
298: ,p_starting_step in number default hr_api.g_number
299: ,p_request_id in number default hr_api.g_number
300: ,p_program_application_id in number default hr_api.g_number
301: ,p_program_id in number default hr_api.g_number
302: ,p_program_update_date in date default hr_api.g_date

Line 299: ,p_request_id in number default hr_api.g_number

295: ,p_parent_spine_id in number default hr_api.g_number
296: ,p_grade_id in number default hr_api.g_number
297: ,p_ceiling_step_id in number default hr_api.g_number
298: ,p_starting_step in number default hr_api.g_number
299: ,p_request_id in number default hr_api.g_number
300: ,p_program_application_id in number default hr_api.g_number
301: ,p_program_id in number default hr_api.g_number
302: ,p_program_update_date in date default hr_api.g_date
303: ,p_effective_start_date out nocopy date

Line 300: ,p_program_application_id in number default hr_api.g_number

296: ,p_grade_id in number default hr_api.g_number
297: ,p_ceiling_step_id in number default hr_api.g_number
298: ,p_starting_step in number default hr_api.g_number
299: ,p_request_id in number default hr_api.g_number
300: ,p_program_application_id in number default hr_api.g_number
301: ,p_program_id in number default hr_api.g_number
302: ,p_program_update_date in date default hr_api.g_date
303: ,p_effective_start_date out nocopy date
304: ,p_effective_end_date out nocopy date

Line 301: ,p_program_id in number default hr_api.g_number

297: ,p_ceiling_step_id in number default hr_api.g_number
298: ,p_starting_step in number default hr_api.g_number
299: ,p_request_id in number default hr_api.g_number
300: ,p_program_application_id in number default hr_api.g_number
301: ,p_program_id in number default hr_api.g_number
302: ,p_program_update_date in date default hr_api.g_date
303: ,p_effective_start_date out nocopy date
304: ,p_effective_end_date out nocopy date
305: ) is

Line 302: ,p_program_update_date in date default hr_api.g_date

298: ,p_starting_step in number default hr_api.g_number
299: ,p_request_id in number default hr_api.g_number
300: ,p_program_application_id in number default hr_api.g_number
301: ,p_program_id in number default hr_api.g_number
302: ,p_program_update_date in date default hr_api.g_date
303: ,p_effective_start_date out nocopy date
304: ,p_effective_end_date out nocopy date
305: ) is
306:

Line 364: when hr_api.cannot_find_prog_unit then

360: ,p_datetrack_mode => p_datetrack_mode
361: ,p_object_version_number => l_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'UPDATE_GRADE_SCALE'
367: ,p_hook_type => 'BP'
368: );

Line 365: hr_api.cannot_find_prog_unit_error

361: ,p_object_version_number => l_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'UPDATE_GRADE_SCALE'
367: ,p_hook_type => 'BP'
368: );
369: --

Line 433: when hr_api.cannot_find_prog_unit then

429: ,p_effective_start_date => l_effective_start_date
430: ,p_effective_end_date => l_effective_end_date
431: );
432: exception
433: when hr_api.cannot_find_prog_unit then
434: hr_api.cannot_find_prog_unit_error
435: (p_module_name => 'UPDATE_GRADE_SCALE'
436: ,p_hook_type => 'AP'
437: );

Line 434: hr_api.cannot_find_prog_unit_error

430: ,p_effective_end_date => l_effective_end_date
431: );
432: exception
433: when hr_api.cannot_find_prog_unit then
434: hr_api.cannot_find_prog_unit_error
435: (p_module_name => 'UPDATE_GRADE_SCALE'
436: ,p_hook_type => 'AP'
437: );
438: --

Line 447: raise hr_api.validate_enabled;

443: -- When in validation only mode raise the Validate_Enabled exception
444: --
445: if p_validate
446: then
447: raise hr_api.validate_enabled;
448: end if;
449: --
450: hr_utility.set_location(l_proc, 50);
451: --

Line 462: when hr_api.validate_enabled then

458: hr_utility.set_location(' Leaving:' ||l_proc, 60);
459: --
460: exception
461: --
462: when hr_api.validate_enabled then
463: --
464: -- As the Validate_Enabled exception has been raised
465: -- we must rollback to the savepoint
466: --

Line 583: if p_datetrack_mode = hr_api.g_delete then

579: -- Need to check the existence of child records based on the DT mode.
580: -- For DELETE mode, no child record should exists after the effective_date.
581: -- For ZAp mode, no child record should exists on any date.
582: --
583: if p_datetrack_mode = hr_api.g_delete then
584: l_date := p_effective_date;
585: end if;
586: --
587: hr_utility.set_location(l_proc, 20);

Line 633: p_datetrack_mode = hr_api.g_delete THEN

629: l_datetrack_mode := p_datetrack_mode;
630: --
631: hr_utility.set_location(l_proc, 60);
632: IF grade_step_rec.min_eff_start_date > p_effective_date AND
633: p_datetrack_mode = hr_api.g_delete THEN
634: --
635: -- ZAP the step using min effective_start_date as effective_date.
636: --
637: hr_utility.set_location(l_proc, 70);

Line 639: l_datetrack_mode := hr_api.g_zap;

635: -- ZAP the step using min effective_start_date as effective_date.
636: --
637: hr_utility.set_location(l_proc, 70);
638: l_effective_date := grade_step_rec.min_eff_start_date;
639: l_datetrack_mode := hr_api.g_zap;
640: --
641: ELSIF grade_step_rec.min_eff_start_date > p_effective_date AND
642: p_datetrack_mode = hr_api.g_zap THEN
643: --

Line 642: p_datetrack_mode = hr_api.g_zap THEN

638: l_effective_date := grade_step_rec.min_eff_start_date;
639: l_datetrack_mode := hr_api.g_zap;
640: --
641: ELSIF grade_step_rec.min_eff_start_date > p_effective_date AND
642: p_datetrack_mode = hr_api.g_zap THEN
643: --
644: -- To ZAP the step, use the min effective_start_date as effective_date.
645: --
646: hr_utility.set_location(l_proc, 80);

Line 650: p_datetrack_mode = hr_api.g_zap THEN

646: hr_utility.set_location(l_proc, 80);
647: l_effective_date := grade_step_rec.min_eff_start_date;
648: --
649: ELSIF grade_step_rec.max_eff_end_date <= p_effective_date AND
650: p_datetrack_mode = hr_api.g_zap THEN
651: --
652: -- To ZAp the step, use the min effective_start_date as effective_date.
653: --
654: hr_utility.set_location(l_proc, 90);

Line 663: p_datetrack_mode = hr_api.g_delete) THEN

659: hr_utility.set_location('l_effective_date: '||l_effective_date, 100);
660: hr_utility.set_location('l_datetrack_mode'||l_datetrack_mode, 100);
661: --
662: IF not (grade_step_rec.max_eff_end_date <= p_effective_date AND
663: p_datetrack_mode = hr_api.g_delete) THEN
664: --
665: -- Get the step details.
666: --
667: hr_utility.set_location(l_proc, 110);

Line 757: when hr_api.cannot_find_prog_unit then

753: ,p_grade_spine_id => p_grade_spine_id
754: ,p_object_version_number => l_object_version_number
755: );
756: exception
757: when hr_api.cannot_find_prog_unit then
758: hr_api.cannot_find_prog_unit_error
759: (p_module_name => 'DELETE_GRADE_SCALE'
760: ,p_hook_type => 'BP'
761: );

Line 758: hr_api.cannot_find_prog_unit_error

754: ,p_object_version_number => l_object_version_number
755: );
756: exception
757: when hr_api.cannot_find_prog_unit then
758: hr_api.cannot_find_prog_unit_error
759: (p_module_name => 'DELETE_GRADE_SCALE'
760: ,p_hook_type => 'BP'
761: );
762: end;

Line 772: IF p_datetrack_mode in (hr_api.g_delete, hr_api.g_zap) THEN

768: --
769: -- Fix for bug 3472194 starts here.
770: -- Delete the child grade steps before deleting the grade scale.
771: --
772: IF p_datetrack_mode in (hr_api.g_delete, hr_api.g_zap) THEN
773: hr_utility.set_location(l_proc, 25);
774: delete_child_grade_steps
775: (p_validate => p_validate
776: ,p_effective_date => l_effective_date

Line 808: when hr_api.cannot_find_prog_unit then

804: ,p_effective_start_date => l_effective_start_date
805: ,p_effective_end_date => l_effective_end_date
806: );
807: exception
808: when hr_api.cannot_find_prog_unit then
809: hr_api.cannot_find_prog_unit_error
810: (p_module_name => 'DELETE_GRADE_SCALE'
811: ,p_hook_type => 'AP'
812: );

Line 809: hr_api.cannot_find_prog_unit_error

805: ,p_effective_end_date => l_effective_end_date
806: );
807: exception
808: when hr_api.cannot_find_prog_unit then
809: hr_api.cannot_find_prog_unit_error
810: (p_module_name => 'DELETE_GRADE_SCALE'
811: ,p_hook_type => 'AP'
812: );
813: end;

Line 822: raise hr_api.validate_enabled;

818: --
819: -- When in validation only mode raise the Validate_Enabled exception
820: --
821: if p_validate then
822: raise hr_api.validate_enabled;
823: end if;
824:
825: --
826: -- Set all output arguments (returned by some dt modes only)

Line 832: when hr_api.validate_enabled then

828: p_object_version_number := l_object_version_number;
829:
830: hr_utility.set_location(' Leaving:'||l_proc, 100);
831: exception
832: when hr_api.validate_enabled then
833: hr_utility.set_location(' Leaving...:'||l_proc, 50);
834: --
835: -- As the Validate_Enabled exception has been raised
836: -- we must rollback to the savepoint