DBA Data[Home] [Help]

APPS.BEN_CPR_BUS dependencies on FND_MESSAGE

Line 150: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

146: p_effective_date => p_effective_date) then
147: --
148: -- raise error as does not exist as lookup
149: --
150: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
151: fnd_message.set_token('FIELD','p_org_role_typ_cd');
152: fnd_message.set_token('VALUE', p_org_role_typ_cd);
153: fnd_message.set_token('TYPE','BEN_ORG_ROLE_TYP');
154: fnd_message.raise_error;

Line 151: fnd_message.set_token('FIELD','p_org_role_typ_cd');

147: --
148: -- raise error as does not exist as lookup
149: --
150: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
151: fnd_message.set_token('FIELD','p_org_role_typ_cd');
152: fnd_message.set_token('VALUE', p_org_role_typ_cd);
153: fnd_message.set_token('TYPE','BEN_ORG_ROLE_TYP');
154: fnd_message.raise_error;
155: end if;

Line 152: fnd_message.set_token('VALUE', p_org_role_typ_cd);

148: -- raise error as does not exist as lookup
149: --
150: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
151: fnd_message.set_token('FIELD','p_org_role_typ_cd');
152: fnd_message.set_token('VALUE', p_org_role_typ_cd);
153: fnd_message.set_token('TYPE','BEN_ORG_ROLE_TYP');
154: fnd_message.raise_error;
155: end if;
156:

Line 153: fnd_message.set_token('TYPE','BEN_ORG_ROLE_TYP');

149: --
150: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
151: fnd_message.set_token('FIELD','p_org_role_typ_cd');
152: fnd_message.set_token('VALUE', p_org_role_typ_cd);
153: fnd_message.set_token('TYPE','BEN_ORG_ROLE_TYP');
154: fnd_message.raise_error;
155: end if;
156:
157: -- This code is used to check that only program and plan-not-in-program

Line 154: fnd_message.raise_error;

150: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
151: fnd_message.set_token('FIELD','p_org_role_typ_cd');
152: fnd_message.set_token('VALUE', p_org_role_typ_cd);
153: fnd_message.set_token('TYPE','BEN_ORG_ROLE_TYP');
154: fnd_message.raise_error;
155: end if;
156:
157: -- This code is used to check that only program and plan-not-in-program
158: -- can be attached with a popl-org-role of POPLOWNR

Line 165: fnd_message.set_name('BEN','BEN_92611_POPLOWNR_NO_PLIPS');

161: fetch c1 into l_plnip;
162: if c1%found then
163: close c1;
164: -- raise error as Plan is in Program
165: fnd_message.set_name('BEN','BEN_92611_POPLOWNR_NO_PLIPS');
166: fnd_message.raise_error;
167: end if;
168: close c1;
169: end if;

Line 166: fnd_message.raise_error;

162: if c1%found then
163: close c1;
164: -- raise error as Plan is in Program
165: fnd_message.set_name('BEN','BEN_92611_POPLOWNR_NO_PLIPS');
166: fnd_message.raise_error;
167: end if;
168: close c1;
169: end if;
170:

Line 254: fnd_message.set_name('BEN','BEN_92610_PCP_LOCATOR');

250: -- cannot have a pcp locator role without the product code for the
251: -- pcp's external repository filled in the policy-or-group field.
252: -- it's what the search page uses to pass to the external repository
253: -- for the plan.
254: fnd_message.set_name('BEN','BEN_92610_PCP_LOCATOR');
255: fnd_message.raise_error;
256: end if;
257:
258: -- no need to check for program rows....we should not have pcp roles for

Line 255: fnd_message.raise_error;

251: -- pcp's external repository filled in the policy-or-group field.
252: -- it's what the search page uses to pass to the external repository
253: -- for the plan.
254: fnd_message.set_name('BEN','BEN_92610_PCP_LOCATOR');
255: fnd_message.raise_error;
256: end if;
257:
258: -- no need to check for program rows....we should not have pcp roles for
259: -- popl-orgs attached to programs.

Line 267: fnd_message.set_name('BEN','BEN_92578_POPL_ORG_ROLE');

263: close num_of_pcps;
264:
265: -- should not be any rows returned from cursor
266: if l_num_of_pcps > 0 then
267: fnd_message.set_name('BEN','BEN_92578_POPL_ORG_ROLE');
268: fnd_message.raise_error;
269: end if;
270: else
271: -- can only attach pcp locator rows to plans

Line 268: fnd_message.raise_error;

264:
265: -- should not be any rows returned from cursor
266: if l_num_of_pcps > 0 then
267: fnd_message.set_name('BEN','BEN_92578_POPL_ORG_ROLE');
268: fnd_message.raise_error;
269: end if;
270: else
271: -- can only attach pcp locator rows to plans
272: fnd_message.set_name('BEN','BEN_92609_PCP_ONLY_PLNS');

Line 272: fnd_message.set_name('BEN','BEN_92609_PCP_ONLY_PLNS');

268: fnd_message.raise_error;
269: end if;
270: else
271: -- can only attach pcp locator rows to plans
272: fnd_message.set_name('BEN','BEN_92609_PCP_ONLY_PLNS');
273: fnd_message.raise_error;
274: end if;
275: end if;
276:

Line 273: fnd_message.raise_error;

269: end if;
270: else
271: -- can only attach pcp locator rows to plans
272: fnd_message.set_name('BEN','BEN_92609_PCP_ONLY_PLNS');
273: fnd_message.raise_error;
274: end if;
275: end if;
276:
277: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 359: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

355: --
356: -- A referential integrity check was violated therefore
357: -- we must error
358: --
359: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
360: fnd_message.set_token('TABLE_NAME', l_table_name);
361: fnd_message.raise_error;
362: When Others Then
363: --

Line 360: fnd_message.set_token('TABLE_NAME', l_table_name);

356: -- A referential integrity check was violated therefore
357: -- we must error
358: --
359: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
360: fnd_message.set_token('TABLE_NAME', l_table_name);
361: fnd_message.raise_error;
362: When Others Then
363: --
364: -- An unhandled or unexpected error has occurred which

Line 361: fnd_message.raise_error;

357: -- we must error
358: --
359: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
360: fnd_message.set_token('TABLE_NAME', l_table_name);
361: fnd_message.raise_error;
362: When Others Then
363: --
364: -- An unhandled or unexpected error has occurred which
365: -- we must report

Line 367: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

363: --
364: -- An unhandled or unexpected error has occurred which
365: -- we must report
366: --
367: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
368: fnd_message.set_token('PROCEDURE', l_proc);
369: fnd_message.set_token('STEP','15');
370: fnd_message.raise_error;
371: End dt_update_validate;

Line 368: fnd_message.set_token('PROCEDURE', l_proc);

364: -- An unhandled or unexpected error has occurred which
365: -- we must report
366: --
367: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
368: fnd_message.set_token('PROCEDURE', l_proc);
369: fnd_message.set_token('STEP','15');
370: fnd_message.raise_error;
371: End dt_update_validate;
372: --

Line 369: fnd_message.set_token('STEP','15');

365: -- we must report
366: --
367: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
368: fnd_message.set_token('PROCEDURE', l_proc);
369: fnd_message.set_token('STEP','15');
370: fnd_message.raise_error;
371: End dt_update_validate;
372: --
373: -- ----------------------------------------------------------------------------

Line 370: fnd_message.raise_error;

366: --
367: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
368: fnd_message.set_token('PROCEDURE', l_proc);
369: fnd_message.set_token('STEP','15');
370: fnd_message.raise_error;
371: End dt_update_validate;
372: --
373: -- ----------------------------------------------------------------------------
374: -- |--------------------------< dt_delete_validate >--------------------------|

Line 461: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

457: --
458: -- A referential integrity check was violated therefore
459: -- we must error
460: --
461: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
462: fnd_message.set_token('TABLE_NAME', l_table_name);
463: fnd_message.raise_error;
464: When Others Then
465: --

Line 462: fnd_message.set_token('TABLE_NAME', l_table_name);

458: -- A referential integrity check was violated therefore
459: -- we must error
460: --
461: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
462: fnd_message.set_token('TABLE_NAME', l_table_name);
463: fnd_message.raise_error;
464: When Others Then
465: --
466: -- An unhandled or unexpected error has occurred which

Line 463: fnd_message.raise_error;

459: -- we must error
460: --
461: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
462: fnd_message.set_token('TABLE_NAME', l_table_name);
463: fnd_message.raise_error;
464: When Others Then
465: --
466: -- An unhandled or unexpected error has occurred which
467: -- we must report

Line 469: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

465: --
466: -- An unhandled or unexpected error has occurred which
467: -- we must report
468: --
469: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
470: fnd_message.set_token('PROCEDURE', l_proc);
471: fnd_message.set_token('STEP','15');
472: fnd_message.raise_error;
473: End dt_delete_validate;

Line 470: fnd_message.set_token('PROCEDURE', l_proc);

466: -- An unhandled or unexpected error has occurred which
467: -- we must report
468: --
469: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
470: fnd_message.set_token('PROCEDURE', l_proc);
471: fnd_message.set_token('STEP','15');
472: fnd_message.raise_error;
473: End dt_delete_validate;
474: --

Line 471: fnd_message.set_token('STEP','15');

467: -- we must report
468: --
469: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
470: fnd_message.set_token('PROCEDURE', l_proc);
471: fnd_message.set_token('STEP','15');
472: fnd_message.raise_error;
473: End dt_delete_validate;
474: --
475: -- ----------------------------------------------------------------------------

Line 472: fnd_message.raise_error;

468: --
469: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
470: fnd_message.set_token('PROCEDURE', l_proc);
471: fnd_message.set_token('STEP','15');
472: fnd_message.raise_error;
473: End dt_delete_validate;
474: --
475: -- ----------------------------------------------------------------------------
476: -- |---------------------------< insert_validate >----------------------------|

Line 634: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

630: close csr_leg_code;
631: --
632: -- The primary key is invalid therefore we must error
633: --
634: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
635: fnd_message.raise_error;
636: --
637: end if;
638: --

Line 635: fnd_message.raise_error;

631: --
632: -- The primary key is invalid therefore we must error
633: --
634: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
635: fnd_message.raise_error;
636: --
637: end if;
638: --
639: close csr_leg_code;