102: open csr_action;
103: fetch csr_action into l_csr_action;
104: if csr_action%notfound then
105: close csr_action;
106: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
107: fnd_message.raise_error;
108: end if;
109: close csr_action;
110: --
103: fetch csr_action into l_csr_action;
104: if csr_action%notfound then
105: close csr_action;
106: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
107: fnd_message.raise_error;
108: end if;
109: close csr_action;
110: --
111: g_payroll_action_id := p_payroll_action_id;
222: open csr_org;
223: fetch csr_org into l_csr_org;
224: --
225: if csr_org%notfound then
226: fnd_message.set_name('PAY','PAY_JP_INVALID_SWOT');
227: fnd_message.raise_error;
228: end if;
229: --
230: close csr_org;
223: fetch csr_org into l_csr_org;
224: --
225: if csr_org%notfound then
226: fnd_message.set_name('PAY','PAY_JP_INVALID_SWOT');
227: fnd_message.raise_error;
228: end if;
229: --
230: close csr_org;
231: --
2194: end if;
2195: --
2196: if l_tax_type not in ('M_KOU','D_KOU') then
2197: --
2198: fnd_message.set_name('PAY','PAY_JP_INVALID_TAX_TYPE');
2199: fnd_message.raise_error;
2200: --
2201: else
2202: --
2195: --
2196: if l_tax_type not in ('M_KOU','D_KOU') then
2197: --
2198: fnd_message.set_name('PAY','PAY_JP_INVALID_TAX_TYPE');
2199: fnd_message.raise_error;
2200: --
2201: else
2202: --
2203: if g_debug then