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;
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;
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:
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
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
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;
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:
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
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.
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
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');
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:
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);
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: --
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
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
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >--------------------------|
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: --
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
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
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >----------------------------|
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: --
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;