APPS.HR_CHANGE_START_DATE_API dependencies on HR_API

Line 160: AND NVL(final_process_date,hr_api.g_eot);

156: FROM per_periods_of_service
157: WHERE person_id = p_person_id
158: AND csr_overlap.p_start_date BETWEEN NVL(last_standard_process_date,
159: actual_termination_date)+1
160: AND NVL(final_process_date,hr_api.g_eot);
161: --
162: l_old_start_date_in_range BOOLEAN;
163: l_new_start_date_in_range BOOLEAN;
164: --

Line 179: and NVL(pdp.actual_termination_date,hr_api.g_eot));

175: (select 'x'
176: from per_periods_of_placement pdp
177: where pdp.person_id = p_person_id
178: and p_new_start_date between pdp.date_start
179: and NVL(pdp.actual_termination_date,hr_api.g_eot));
180: -- End of Fix for 10124468
181: --
182: -- 115.30 (END)
183: --

Line 2499: hr_api.mandatory_arg_error

2495: hr_utility.set_location('Entering:'|| l_proc, 10);
2496: --
2497: -- Check mandatory parameters have been set
2498: --
2499: hr_api.mandatory_arg_error
2500: (p_api_name => l_proc
2501: ,p_argument => 'person_id'
2502: ,p_argument_value => p_person_id);
2503: --

Line 2504: hr_api.mandatory_arg_error

2500: (p_api_name => l_proc
2501: ,p_argument => 'person_id'
2502: ,p_argument_value => p_person_id);
2503: --
2504: hr_api.mandatory_arg_error
2505: (p_api_name => l_proc
2506: ,p_argument => 'old_start_date'
2507: ,p_argument_value => p_old_start_date );
2508: --

Line 2509: hr_api.mandatory_arg_error

2505: (p_api_name => l_proc
2506: ,p_argument => 'old_start_date'
2507: ,p_argument_value => p_old_start_date );
2508: --
2509: hr_api.mandatory_arg_error
2510: (p_api_name => l_proc
2511: ,p_argument => 'new_start_date'
2512: ,p_argument_value => p_new_start_date);
2513: --

Line 2514: hr_api.mandatory_arg_error

2510: (p_api_name => l_proc
2511: ,p_argument => 'new_start_date'
2512: ,p_argument_value => p_new_start_date);
2513: --
2514: hr_api.mandatory_arg_error
2515: (p_api_name => l_proc
2516: ,p_argument => 'update_type'
2517: ,p_argument_value => p_update_type);
2518: --

Line 2559: when hr_api.cannot_find_prog_unit then

2555: ,p_update_type => p_update_type
2556: ,p_applicant_number => p_applicant_number
2557: );
2558: exception
2559: when hr_api.cannot_find_prog_unit then
2560: hr_api.cannot_find_prog_unit_error
2561: (p_module_name => 'update_start_date'
2562: ,p_hook_type => 'BP'
2563: );

Line 2560: hr_api.cannot_find_prog_unit_error

2556: ,p_applicant_number => p_applicant_number
2557: );
2558: exception
2559: when hr_api.cannot_find_prog_unit then
2560: hr_api.cannot_find_prog_unit_error
2561: (p_module_name => 'update_start_date'
2562: ,p_hook_type => 'BP'
2563: );
2564: end;

Line 3116: when hr_api.cannot_find_prog_unit then

3112: ,p_applicant_number => p_applicant_number
3113: ,p_warn_ee => l_warn_ee
3114: );
3115: exception
3116: when hr_api.cannot_find_prog_unit then
3117: hr_api.cannot_find_prog_unit_error
3118: (p_module_name => 'update_start_date'
3119: ,p_hook_type => 'AP'
3120: );

Line 3117: hr_api.cannot_find_prog_unit_error

3113: ,p_warn_ee => l_warn_ee
3114: );
3115: exception
3116: when hr_api.cannot_find_prog_unit then
3117: hr_api.cannot_find_prog_unit_error
3118: (p_module_name => 'update_start_date'
3119: ,p_hook_type => 'AP'
3120: );
3121: end;

Line 3127: raise hr_api.validate_enabled;

3123: --
3124: -- When in validation only mode raise the Validate_Enabled exception
3125: --
3126: if p_validate then
3127: raise hr_api.validate_enabled;
3128: end if;
3129: --
3130: -- Set all output arguments
3131: --

Line 3136: when hr_api.validate_enabled then

3132: p_warn_ee := l_warn_ee;
3133: --
3134: hr_utility.set_location(' Leaving:'||l_proc, 500);
3135: exception
3136: when hr_api.validate_enabled then
3137: --
3138: -- As the Validate_Enabled exception has been raised
3139: -- we must rollback to the savepoint
3140: --