DBA Data[Home] [Help]

APPS.BEN_CHECK_ORGANIZATION dependencies on FND_MESSAGE

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

41: open chk_org_role_upd(p_organization_id, p_date_from, p_date_to);
42: fetch chk_org_role_upd into l_data_exists;
43: if chk_org_role_upd%found then
44: close chk_org_role_upd;
45: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');
46: fnd_message.raise_error;
47: end if;
48: close chk_org_role_upd;
49:

Line 46: fnd_message.raise_error;

42: fetch chk_org_role_upd into l_data_exists;
43: if chk_org_role_upd%found then
44: close chk_org_role_upd;
45: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');
46: fnd_message.raise_error;
47: end if;
48: close chk_org_role_upd;
49:
50: open chk_org_bnf_upd(p_organization_id, p_date_from, p_date_to);

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

50: open chk_org_bnf_upd(p_organization_id, p_date_from, p_date_to);
51: fetch chk_org_bnf_upd into l_data_exists;
52: if chk_org_bnf_upd%found then
53: close chk_org_bnf_upd;
54: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');
55: fnd_message.raise_error;
56: end if;
57: close chk_org_bnf_upd;
58: end if;

Line 55: fnd_message.raise_error;

51: fetch chk_org_bnf_upd into l_data_exists;
52: if chk_org_bnf_upd%found then
53: close chk_org_bnf_upd;
54: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');
55: fnd_message.raise_error;
56: end if;
57: close chk_org_bnf_upd;
58: end if;
59: end if;

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

73: open chk_org_role_del(p_organization_id);
74: fetch chk_org_role_del into l_data_exists;
75: if chk_org_role_del%found then
76: close chk_org_role_del;
77: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');
78: fnd_message.raise_error;
79: end if;
80: close chk_org_role_del;
81:

Line 78: fnd_message.raise_error;

74: fetch chk_org_role_del into l_data_exists;
75: if chk_org_role_del%found then
76: close chk_org_role_del;
77: fnd_message.set_name('BEN', 'BEN_93384_ORG_ROLE_EXISTS');
78: fnd_message.raise_error;
79: end if;
80: close chk_org_role_del;
81:
82: open chk_org_bnf_del(p_organization_id);

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

82: open chk_org_bnf_del(p_organization_id);
83: fetch chk_org_bnf_del into l_data_exists;
84: if chk_org_bnf_del%found then
85: close chk_org_bnf_del;
86: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');
87: fnd_message.raise_error;
88: end if;
89: close chk_org_bnf_del;
90: end if;

Line 87: fnd_message.raise_error;

83: fetch chk_org_bnf_del into l_data_exists;
84: if chk_org_bnf_del%found then
85: close chk_org_bnf_del;
86: fnd_message.set_name('BEN', 'BEN_93385_ORG_BNF_EXISTS');
87: fnd_message.raise_error;
88: end if;
89: close chk_org_bnf_del;
90: end if;
91: end if;