58: open chk_org_role_upd(p_organization_id, p_date_from, p_date_to);
59: fetch chk_org_role_upd into l_data_exists;
60: if chk_org_role_upd%found then
61: close chk_org_role_upd;
62: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');
63: fnd_message.raise_error;
64: end if;
65: close chk_org_role_upd;
66:
59: fetch chk_org_role_upd into l_data_exists;
60: if chk_org_role_upd%found then
61: close chk_org_role_upd;
62: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');
63: fnd_message.raise_error;
64: end if;
65: close chk_org_role_upd;
66:
67: open chk_org_bnf_upd(p_organization_id, p_date_from, p_date_to);
67: open chk_org_bnf_upd(p_organization_id, p_date_from, p_date_to);
68: fetch chk_org_bnf_upd into l_data_exists;
69: if chk_org_bnf_upd%found then
70: close chk_org_bnf_upd;
71: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');
72: fnd_message.raise_error;
73: end if;
74: close chk_org_bnf_upd;
75: end if;
68: fetch chk_org_bnf_upd into l_data_exists;
69: if chk_org_bnf_upd%found then
70: close chk_org_bnf_upd;
71: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');
72: fnd_message.raise_error;
73: end if;
74: close chk_org_bnf_upd;
75: end if;
76: end if;
92: open chk_org_role_del(p_organization_id);
93: fetch chk_org_role_del into l_data_exists;
94: if chk_org_role_del%found then
95: close chk_org_role_del;
96: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');
97: fnd_message.raise_error;
98: end if;
99: close chk_org_role_del;
100:
93: fetch chk_org_role_del into l_data_exists;
94: if chk_org_role_del%found then
95: close chk_org_role_del;
96: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');
97: fnd_message.raise_error;
98: end if;
99: close chk_org_role_del;
100:
101: open chk_org_bnf_del(p_organization_id);
101: open chk_org_bnf_del(p_organization_id);
102: fetch chk_org_bnf_del into l_data_exists;
103: if chk_org_bnf_del%found then
104: close chk_org_bnf_del;
105: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');
106: fnd_message.raise_error;
107: end if;
108: close chk_org_bnf_del;
109: end if;
102: fetch chk_org_bnf_del into l_data_exists;
103: if chk_org_bnf_del%found then
104: close chk_org_bnf_del;
105: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');
106: fnd_message.raise_error;
107: end if;
108: close chk_org_bnf_del;
109: end if;
110: end if;