APPS.HR_AMD_BUS dependencies on HR_API_MODULES

Line 117: hr_amd_shd.constraint_error('HR_API_MODULES_CK1');

113: if hr_api.not_exists_in_hr_lookups
114: (p_effective_date => p_effective_date,
115: p_lookup_type => 'API_MODULE_TYPE',
116: p_lookup_code => p_api_module_type) then
117: hr_amd_shd.constraint_error('HR_API_MODULES_CK1');
118: end if;
119:
120: hr_utility.set_location('Leaving: '||l_proc,10);
121: end chk_api_module_type;

Line 168: select api_module_id from hr_api_modules ham

164: --
165: -- Declare a cursor that will check whether the passed
166: -- in module type and module name form a unique combination
167: cursor csr_valid_combo is
168: select api_module_id from hr_api_modules ham
169: where ham.module_name = p_module_name
170: and ham.api_module_type = p_api_module_type;
171:
172: begin

Line 209: hr_amd_shd.constraint_error('HR_API_MODULES_UK1');

205: fetch csr_valid_combo into l_module_id;
206:
207: if csr_valid_combo%found then
208: close csr_valid_combo;
209: hr_amd_shd.constraint_error('HR_API_MODULES_UK1');
210: end if;
211:
212: close csr_valid_combo;
213: end if;

Line 291: hr_amd_shd.constraint_error('HR_API_MODULES_CK2');

287: (p_effective_date => p_effective_date,
288: p_lookup_type => 'YES_NO',
289: p_lookup_code => p_data_within_business_group) then
290: -- Error, invalid value.
291: hr_amd_shd.constraint_error('HR_API_MODULES_CK2');
292: end if;
293: --
294: if ((p_api_module_id is not null)
295: and hr_amd_shd.g_old_rec.data_within_business_group ='Y'