DBA Data[Home] [Help]

APPS.BEN_CHECK_ORGANIZATION dependencies on FND_MESSAGE

Line 62: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');

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:

Line 63: fnd_message.raise_error;

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);

Line 71: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');

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;

Line 72: fnd_message.raise_error;

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;

Line 96: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');

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:

Line 97: fnd_message.raise_error;

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);

Line 105: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');

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;

Line 106: fnd_message.raise_error;

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;