211: --
212: end if;
213: --
214: /*if p_ext_stat_cd not in ('A','R') then
215: fnd_message.set_name('BEN','BEN_91944_INVLD_STAT_CD');
216: fnd_message.raise_error;
217: end if;*/
218:
219: end if;
212: end if;
213: --
214: /*if p_ext_stat_cd not in ('A','R') then
215: fnd_message.set_name('BEN','BEN_91944_INVLD_STAT_CD');
216: fnd_message.raise_error;
217: end if;*/
218:
219: end if;
220: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: if instr(p_output_name,' ') > 0 or instr(p_drctry_name,' ') > 0 then
260: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');
261: fnd_message.raise_error;
262: end if;
263: --
264: hr_utility.set_location('Leaving:'||l_proc, 15);
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: if instr(p_output_name,' ') > 0 or instr(p_drctry_name,' ') > 0 then
260: fnd_message.set_name('BEN','BEN_91955_NAME_HAS_SPACE');
261: fnd_message.raise_error;
262: end if;
263: --
264: hr_utility.set_location('Leaving:'||l_proc, 15);
265: End chk_output_file;
285:
286: if ( (not nvl(p_output_type,'F') in ( 'F' , 'X' ) ) and p_xdo_template_id is null )
287: or ( p_xdo_template_id is not null and ( p_output_type in ('F' , 'X') ) )
288: then
289: fnd_message.set_name('BEN','BEN_94036_EXT_XDO_PDF_NULL');
290: fnd_message.raise_error;
291: end if;
292:
293: if p_xdo_template_id is not null then
286: if ( (not nvl(p_output_type,'F') in ( 'F' , 'X' ) ) and p_xdo_template_id is null )
287: or ( p_xdo_template_id is not null and ( p_output_type in ('F' , 'X') ) )
288: then
289: fnd_message.set_name('BEN','BEN_94036_EXT_XDO_PDF_NULL');
290: fnd_message.raise_error;
291: end if;
292:
293: if p_xdo_template_id is not null then
294: open c ;
294: open c ;
295: fetch c into l_dummy ;
296: if c%notfound then
297: close c ;
298: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
299: fnd_message.set_token('PROCEDURE', l_proc);
300: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
301: fnd_message.raise_error;
302: end if ;
295: fetch c into l_dummy ;
296: if c%notfound then
297: close c ;
298: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
299: fnd_message.set_token('PROCEDURE', l_proc);
300: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
301: fnd_message.raise_error;
302: end if ;
303: close c ;
296: if c%notfound then
297: close c ;
298: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
299: fnd_message.set_token('PROCEDURE', l_proc);
300: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
301: fnd_message.raise_error;
302: end if ;
303: close c ;
304:
297: close c ;
298: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
299: fnd_message.set_token('PROCEDURE', l_proc);
300: fnd_message.set_token('CONSTRAINT_NAME', 'XDO_TEMPLATE_ID');
301: fnd_message.raise_error;
302: end if ;
303: close c ;
304:
305: end if ;