163: nvl(length(trim(p_uom_code)),-1)<>-1 Or
164: nvl(length(trim(p_measure_type_code)),-1)<>-1 Or
165: nvl(length(trim(p_measure_comments)),-1)<>-1 ))
166: then
167: fnd_message.set_name('PER', 'HR_51746_WPM_IMP_NO_MTYPE');
168: fnd_message.raise_error;
169: end if;
170:
171: if(l_measurement_style_code ='QUALIT_M') then
164: nvl(length(trim(p_measure_type_code)),-1)<>-1 Or
165: nvl(length(trim(p_measure_comments)),-1)<>-1 ))
166: then
167: fnd_message.set_name('PER', 'HR_51746_WPM_IMP_NO_MTYPE');
168: fnd_message.raise_error;
169: end if;
170:
171: if(l_measurement_style_code ='QUALIT_M') then
172:
170:
171: if(l_measurement_style_code ='QUALIT_M') then
172:
173: if nvl(length(trim(p_measure_name)),-1) = -1 then
174: fnd_message.set_name('PER', 'HR_51744_WPM_IMP_QUAL_TYPE');
175: fnd_message.raise_error;
176: end if;
177:
178: if( nvl(length(trim(p_target_value)),-1) <> -1 Or
171: if(l_measurement_style_code ='QUALIT_M') then
172:
173: if nvl(length(trim(p_measure_name)),-1) = -1 then
174: fnd_message.set_name('PER', 'HR_51744_WPM_IMP_QUAL_TYPE');
175: fnd_message.raise_error;
176: end if;
177:
178: if( nvl(length(trim(p_target_value)),-1) <> -1 Or
179: nvl(length(trim(p_uom_code)),-1) <> -1 Or
177:
178: if( nvl(length(trim(p_target_value)),-1) <> -1 Or
179: nvl(length(trim(p_uom_code)),-1) <> -1 Or
180: nvl(length(trim(p_measure_type_code)),-1) <> -1 ) then
181: fnd_message.set_name('PER', 'HR_51747_WPM_IMP_INVAL_QUAL');
182: fnd_message.raise_error;
183: end if;
184:
185: end if;
178: if( nvl(length(trim(p_target_value)),-1) <> -1 Or
179: nvl(length(trim(p_uom_code)),-1) <> -1 Or
180: nvl(length(trim(p_measure_type_code)),-1) <> -1 ) then
181: fnd_message.set_name('PER', 'HR_51747_WPM_IMP_INVAL_QUAL');
182: fnd_message.raise_error;
183: end if;
184:
185: end if;
186:
186:
187: if(l_measurement_style_code ='QUANT_M') then
188: if(nvl(length(trim(p_measure_name)),-1) = -1 Or nvl(length(trim(p_target_value)),-1) = -1 Or
189: nvl(length(trim(p_uom_code)),-1) = -1 Or nvl(length(trim(p_measure_type_code)),-1) = -1 ) then
190: fnd_message.set_name('PER', 'HR_51745_WPM_IMP_QUAN_TYPE');
191: fnd_message.raise_error;
192: end if;
193: end if;
194:
187: if(l_measurement_style_code ='QUANT_M') then
188: if(nvl(length(trim(p_measure_name)),-1) = -1 Or nvl(length(trim(p_target_value)),-1) = -1 Or
189: nvl(length(trim(p_uom_code)),-1) = -1 Or nvl(length(trim(p_measure_type_code)),-1) = -1 ) then
190: fnd_message.set_name('PER', 'HR_51745_WPM_IMP_QUAN_TYPE');
191: fnd_message.raise_error;
192: end if;
193: end if;
194:
195: if(l_eligibility_type_code='N_P' And nvl(length(trim(p_eligibility_profile_code)),-1)<>-1 ) then
192: end if;
193: end if;
194:
195: if(l_eligibility_type_code='N_P' And nvl(length(trim(p_eligibility_profile_code)),-1)<>-1 ) then
196: fnd_message.set_name('PER', 'HR_51743_WPM_IMP_SEL_ELIG_TYPE');
197: fnd_message.raise_error;
198: end if;
199:
200: if(l_eligibility_type_code='EXIST_P' And nvl(length(trim(p_eligibility_profile_code)),-1)=-1) then
193: end if;
194:
195: if(l_eligibility_type_code='N_P' And nvl(length(trim(p_eligibility_profile_code)),-1)<>-1 ) then
196: fnd_message.set_name('PER', 'HR_51743_WPM_IMP_SEL_ELIG_TYPE');
197: fnd_message.raise_error;
198: end if;
199:
200: if(l_eligibility_type_code='EXIST_P' And nvl(length(trim(p_eligibility_profile_code)),-1)=-1) then
201: fnd_message.set_name('PER', 'HR_51742_WPM_IMP_SEL_ELIG_NAME');
197: fnd_message.raise_error;
198: end if;
199:
200: if(l_eligibility_type_code='EXIST_P' And nvl(length(trim(p_eligibility_profile_code)),-1)=-1) then
201: fnd_message.set_name('PER', 'HR_51742_WPM_IMP_SEL_ELIG_NAME');
202: fnd_message.raise_error;
203: end if;
204:
205:
198: end if;
199:
200: if(l_eligibility_type_code='EXIST_P' And nvl(length(trim(p_eligibility_profile_code)),-1)=-1) then
201: fnd_message.set_name('PER', 'HR_51742_WPM_IMP_SEL_ELIG_NAME');
202: fnd_message.raise_error;
203: end if;
204:
205:
206:
268: -- messages and add them to Multiple Message List
269: --
270:
271: if l_weighting_over_100_warning then
272: -- fnd_message.set_name('PER', 'HR_50198_WPM_WEIGHT_WARN');
273: null;
274: end if;
275:
276: if l_weighting_appraisal_warning then
273: null;
274: end if;
275:
276: if l_weighting_appraisal_warning then
277: --fnd_message.set_name('PER', 'HR_50223_WPM_APPRAISE_WARN');
278: null;
279: end if;
280:
281: if(l_eligibility_type_code='EXIST_P') then
303: open csr_name(p_eligibility_profile_code,l_effective_date);
304: fetch csr_name into is_profile_exists,l_elig_prfl_bg_id;
305: if(csr_name%NOTFOUND)then
306: close csr_name;
307: fnd_message.set_name('PER', 'HR_51794_WPM_STALE_DATA');
308: fnd_message.raise_error;
309: end if;
310: close csr_name;
311: end if;
304: fetch csr_name into is_profile_exists,l_elig_prfl_bg_id;
305: if(csr_name%NOTFOUND)then
306: close csr_name;
307: fnd_message.set_name('PER', 'HR_51794_WPM_STALE_DATA');
308: fnd_message.raise_error;
309: end if;
310: close csr_name;
311: end if;
312:
357: -- Multiple Message List. Otherwise re-raise the
358: -- error.
359: --
360: rollback to import_library_objective_api;
361: fnd_message.raise_error;
362: hr_utility.set_location(' Leaving:' || l_proc,50);
363:
364: end import_library_objectives;
365: