290: p_effective_date => p_effective_date) then
291: --
292: -- raise error as does not exist as lookup
293: --
294: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
295: fnd_message.set_token('FIELD','p_prvs_stat_cd');
296: fnd_message.set_token('TYPE','BEN_PER_IN_LER_STAT_CD');
297: fnd_message.raise_error;
298: --
291: --
292: -- raise error as does not exist as lookup
293: --
294: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
295: fnd_message.set_token('FIELD','p_prvs_stat_cd');
296: fnd_message.set_token('TYPE','BEN_PER_IN_LER_STAT_CD');
297: fnd_message.raise_error;
298: --
299: end if;
292: -- raise error as does not exist as lookup
293: --
294: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
295: fnd_message.set_token('FIELD','p_prvs_stat_cd');
296: fnd_message.set_token('TYPE','BEN_PER_IN_LER_STAT_CD');
297: fnd_message.raise_error;
298: --
299: end if;
300: --
293: --
294: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
295: fnd_message.set_token('FIELD','p_prvs_stat_cd');
296: fnd_message.set_token('TYPE','BEN_PER_IN_LER_STAT_CD');
297: fnd_message.raise_error;
298: --
299: end if;
300: --
301: end if;
360: p_effective_date => p_effective_date) then
361: --
362: -- raise error as does not exist as lookup
363: --
364: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
365: fnd_message.set_token('FIELD','p_per_in_ler_stat_cd');
366: fnd_message.set_token('TYPE','BEN_PER_IN_LER_STAT_CD');
367: fnd_message.raise_error;
368: --
361: --
362: -- raise error as does not exist as lookup
363: --
364: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
365: fnd_message.set_token('FIELD','p_per_in_ler_stat_cd');
366: fnd_message.set_token('TYPE','BEN_PER_IN_LER_STAT_CD');
367: fnd_message.raise_error;
368: --
369: end if;
362: -- raise error as does not exist as lookup
363: --
364: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
365: fnd_message.set_token('FIELD','p_per_in_ler_stat_cd');
366: fnd_message.set_token('TYPE','BEN_PER_IN_LER_STAT_CD');
367: fnd_message.raise_error;
368: --
369: end if;
370: --
363: --
364: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
365: fnd_message.set_token('FIELD','p_per_in_ler_stat_cd');
366: fnd_message.set_token('TYPE','BEN_PER_IN_LER_STAT_CD');
367: fnd_message.raise_error;
368: --
369: end if;
370: --
371: end if;
502: open c1;
503: fetch c1 into l_person1,l_person2;
504: if c1%found then
505: close c1;
506: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');
507: fnd_message.set_token('PERSON1', l_person1);
508: fnd_message.set_token('PERSON2', l_person2);
509: fnd_message.raise_error;
510: end if;
503: fetch c1 into l_person1,l_person2;
504: if c1%found then
505: close c1;
506: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');
507: fnd_message.set_token('PERSON1', l_person1);
508: fnd_message.set_token('PERSON2', l_person2);
509: fnd_message.raise_error;
510: end if;
511: close c1;
504: if c1%found then
505: close c1;
506: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');
507: fnd_message.set_token('PERSON1', l_person1);
508: fnd_message.set_token('PERSON2', l_person2);
509: fnd_message.raise_error;
510: end if;
511: close c1;
512:
505: close c1;
506: fnd_message.set_name('BEN','BEN_93251_CWB_CANNOT_REASSIGN');
507: fnd_message.set_token('PERSON1', l_person1);
508: fnd_message.set_token('PERSON2', l_person2);
509: fnd_message.raise_error;
510: end if;
511: close c1;
512:
513: end if;