50: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
59: --
247: open c1;
248: fetch c1 into l_dummy;
249: if c1%found then
250: close c1;
251: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
252: fnd_message.raise_error;
253: end if;
254: end if;
255: --
248: fetch c1 into l_dummy;
249: if c1%found then
250: close c1;
251: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
252: fnd_message.raise_error;
253: end if;
254: end if;
255: --
256: hr_utility.set_location('Leaving:'||l_proc, 15);
302: p_effective_date => p_effective_date) then
303: --
304: -- raise error message
305: --
306: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
307: fnd_message.set_token('FIELD', 'p_ext_global_flag');
308: fnd_message.set_token('TYPE', 'YES_NO');
309: fnd_message.raise_error;
310: --
303: --
304: -- raise error message
305: --
306: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
307: fnd_message.set_token('FIELD', 'p_ext_global_flag');
308: fnd_message.set_token('TYPE', 'YES_NO');
309: fnd_message.raise_error;
310: --
311: end if;
304: -- raise error message
305: --
306: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
307: fnd_message.set_token('FIELD', 'p_ext_global_flag');
308: fnd_message.set_token('TYPE', 'YES_NO');
309: fnd_message.raise_error;
310: --
311: end if;
312: else
305: --
306: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
307: fnd_message.set_token('FIELD', 'p_ext_global_flag');
308: fnd_message.set_token('TYPE', 'YES_NO');
309: fnd_message.raise_error;
310: --
311: end if;
312: else
313: /* BG is null, so alternative call is required */
317: p_effective_date => p_effective_date) then
318: --
319: -- raise error message
320: --
321: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
322: fnd_message.set_token('FIELD', 'p_ext_global_flag');
323: fnd_message.set_token('TYPE', 'YES_NO');
324: fnd_message.raise_error;
325: --
318: --
319: -- raise error message
320: --
321: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
322: fnd_message.set_token('FIELD', 'p_ext_global_flag');
323: fnd_message.set_token('TYPE', 'YES_NO');
324: fnd_message.raise_error;
325: --
326: end if;
319: -- raise error message
320: --
321: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
322: fnd_message.set_token('FIELD', 'p_ext_global_flag');
323: fnd_message.set_token('TYPE', 'YES_NO');
324: fnd_message.raise_error;
325: --
326: end if;
327: end if ;
320: --
321: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
322: fnd_message.set_token('FIELD', 'p_ext_global_flag');
323: fnd_message.set_token('TYPE', 'YES_NO');
324: fnd_message.raise_error;
325: --
326: end if;
327: end if ;
328:
332: open c ;
333: fetch c into l_dummy ;
334: if c%found then
335: --- create new error
336: fnd_message.set_name('BEN', 'BEN_92775_CHILD_REC_EXISTS');
337: fnd_message.raise_error;
338:
339: end if ;
340: close c ;
333: fetch c into l_dummy ;
334: if c%found then
335: --- create new error
336: fnd_message.set_name('BEN', 'BEN_92775_CHILD_REC_EXISTS');
337: fnd_message.raise_error;
338:
339: end if ;
340: close c ;
341: end if ;
499: close csr_leg_code;
500: --
501: -- The primary key is invalid therefore we must error
502: --
503: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
504: fnd_message.raise_error;
505: --
506: end if;
507: --
500: --
501: -- The primary key is invalid therefore we must error
502: --
503: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
504: fnd_message.raise_error;
505: --
506: end if;
507: --
508: close csr_leg_code;