49: close csr_sec_grp;
50: --
51: -- The primary key is invalid therefore we must error
52: --
53: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
54: fnd_message.raise_error;
55: --
56: end if;
57: close csr_sec_grp;
50: --
51: -- The primary key is invalid therefore we must error
52: --
53: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
54: fnd_message.raise_error;
55: --
56: end if;
57: close csr_sec_grp;
58: --
267: open c1;
268: fetch c1 into l_dummy;
269: if c1%found then
270: close c1;
271: fnd_message.set_name('BEN','BEN_91931_VAL_NOT_UNQ');
272: fnd_message.raise_error;
273: end if;
274: --
275: close c1;
268: fetch c1 into l_dummy;
269: if c1%found then
270: close c1;
271: fnd_message.set_name('BEN','BEN_91931_VAL_NOT_UNQ');
272: fnd_message.raise_error;
273: end if;
274: --
275: close c1;
276: hr_utility.set_location('Leaving:'||l_proc, 15);
309: Begin
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: if p_val is not null and p_dcd_val is null then
313: fnd_message.set_name('BEN','BEN_92119_IFVALUE_REPLACE_ERR');
314: fnd_message.raise_error;
315: end if;
316: --
317: hr_utility.set_location('Leaving:'||l_proc, 15);
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: if p_val is not null and p_dcd_val is null then
313: fnd_message.set_name('BEN','BEN_92119_IFVALUE_REPLACE_ERR');
314: fnd_message.raise_error;
315: end if;
316: --
317: hr_utility.set_location('Leaving:'||l_proc, 15);
318: End chk_ifvalue_replace_null;
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: if p_dcd_val is not null and p_val is null then
354: fnd_message.set_name('BEN','BEN_92120_IFVALUE_REPLACE_ERR');
355: fnd_message.raise_error;
356: end if;
357: --
358: hr_utility.set_location('Leaving:'||l_proc, 15);
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: if p_dcd_val is not null and p_val is null then
354: fnd_message.set_name('BEN','BEN_92120_IFVALUE_REPLACE_ERR');
355: fnd_message.raise_error;
356: end if;
357: --
358: hr_utility.set_location('Leaving:'||l_proc, 15);
359: End chk_replace_ifvalue_null;
560: close csr_leg_code;
561: --
562: -- The primary key is invalid therefore we must error
563: --
564: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
565: fnd_message.raise_error;
566: --
567: end if;
568: --
561: --
562: -- The primary key is invalid therefore we must error
563: --
564: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
565: fnd_message.raise_error;
566: --
567: end if;
568: --
569: close csr_leg_code;