57: open csr;
58: fetch csr into l_rec;
59: if csr%notfound then
60: close csr;
61: fnd_message.set_name('PAY', 'PAY_34985_INVALID_PAY_ACTION');
62: fnd_message.raise_error;
63: end if;
64: close csr;
65: --
58: fetch csr into l_rec;
59: if csr%notfound then
60: close csr;
61: fnd_message.set_name('PAY', 'PAY_34985_INVALID_PAY_ACTION');
62: fnd_message.raise_error;
63: end if;
64: close csr;
65: --
66: g_payroll_action_id := p_payroll_action_id;
67: g_business_group_id := l_rec.business_group_id;
68:
69: g_legislation_code := hr_jp_id_pkg.legislation_code(g_business_group_id);
70: if (g_legislation_code is NULL) then
71: fnd_message.set_name(800,'HR_51255_PYP_INVALID_BUS_GROUP');
72: fnd_message.raise_error;
73: end if;
74:
75: g_start_date := l_rec.start_date;
68:
69: g_legislation_code := hr_jp_id_pkg.legislation_code(g_business_group_id);
70: if (g_legislation_code is NULL) then
71: fnd_message.set_name(800,'HR_51255_PYP_INVALID_BUS_GROUP');
72: fnd_message.raise_error;
73: end if;
74:
75: g_start_date := l_rec.start_date;
76: g_effective_date := l_rec.effective_date;
263: if nvl(l_retcode, '0') <> '0' then
264:
265: hr_utility.trace('Error: ' || l_errbuf);
266: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','JP Pre tax Archive Process completed with validation warning(s).');
267: fnd_message.set_encoded(l_errbuf);
268: fnd_message.raise_error;
269:
270: end if;
271:
264:
265: hr_utility.trace('Error: ' || l_errbuf);
266: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','JP Pre tax Archive Process completed with validation warning(s).');
267: fnd_message.set_encoded(l_errbuf);
268: fnd_message.raise_error;
269:
270: end if;
271:
272: end loop;