DBA Data[Home] [Help]

APPS.BEN_SVA_BUS dependencies on FND_MESSAGE

Line 125: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

121: open c1;
122: fetch c1 into l_dummy;
123: if c1%found then
124: close c1;
125: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
126: fnd_message.raise_error;
127: end if;
128: --
129: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 126: fnd_message.raise_error;

122: fetch c1 into l_dummy;
123: if c1%found then
124: close c1;
125: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
126: fnd_message.raise_error;
127: end if;
128: --
129: hr_utility.set_location('Leaving:'||l_proc, 15);
130: End chk_name_unique;

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

186: p_effective_date => p_effective_date) then
187: --
188: -- raise error as does not exist as lookup
189: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;

Line 191: fnd_message.set_token('FIELD','p_org_unit_prdct');

187: --
188: -- raise error as does not exist as lookup
189: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
195: --

Line 192: fnd_message.set_token('VALUE',p_org_unit_prdct);

188: -- raise error as does not exist as lookup
189: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
195: --
196: end if;

Line 193: fnd_message.set_token('TYPE','BEN_PRDCT');

189: --
190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
195: --
196: end if;
197: --

Line 194: fnd_message.raise_error;

190: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
191: fnd_message.set_token('FIELD','p_org_unit_prdct');
192: fnd_message.set_token('VALUE',p_org_unit_prdct);
193: fnd_message.set_token('TYPE','BEN_PRDCT');
194: fnd_message.raise_error;
195: --
196: end if;
197: --
198: end if;

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

275: --
276: -- A referential integrity check was violated therefore
277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --

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

276: -- A referential integrity check was violated therefore
277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --
284: -- An unhandled or unexpected error has occurred which

Line 281: fnd_message.raise_error;

277: -- we must error
278: --
279: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
280: fnd_message.set_token('TABLE_NAME', l_table_name);
281: fnd_message.raise_error;
282: When Others Then
283: --
284: -- An unhandled or unexpected error has occurred which
285: -- we must report

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

283: --
284: -- An unhandled or unexpected error has occurred which
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;

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

284: -- An unhandled or unexpected error has occurred which
285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --

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

285: -- we must report
286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --
293: -- ----------------------------------------------------------------------------

Line 290: fnd_message.raise_error;

286: --
287: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
288: fnd_message.set_token('PROCEDURE', l_proc);
289: fnd_message.set_token('STEP','15');
290: fnd_message.raise_error;
291: End dt_update_validate;
292: --
293: -- ----------------------------------------------------------------------------
294: -- |--------------------------< dt_delete_validate >--------------------------|

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

412: --
413: -- An unhandled or unexpected error has occurred which
414: -- we must report
415: --
416: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
417: fnd_message.set_token('PROCEDURE', l_proc);
418: fnd_message.set_token('STEP','15');
419: fnd_message.raise_error;
420: End dt_delete_validate;

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

413: -- An unhandled or unexpected error has occurred which
414: -- we must report
415: --
416: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
417: fnd_message.set_token('PROCEDURE', l_proc);
418: fnd_message.set_token('STEP','15');
419: fnd_message.raise_error;
420: End dt_delete_validate;
421: --

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

414: -- we must report
415: --
416: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
417: fnd_message.set_token('PROCEDURE', l_proc);
418: fnd_message.set_token('STEP','15');
419: fnd_message.raise_error;
420: End dt_delete_validate;
421: --
422: -- ----------------------------------------------------------------------------

Line 419: fnd_message.raise_error;

415: --
416: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
417: fnd_message.set_token('PROCEDURE', l_proc);
418: fnd_message.set_token('STEP','15');
419: fnd_message.raise_error;
420: End dt_delete_validate;
421: --
422: -- ----------------------------------------------------------------------------
423: -- |---------------------------< insert_validate >----------------------------|

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

570: close csr_leg_code;
571: --
572: -- The primary key is invalid therefore we must error
573: --
574: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
575: fnd_message.raise_error;
576: --
577: end if;
578: --

Line 575: fnd_message.raise_error;

571: --
572: -- The primary key is invalid therefore we must error
573: --
574: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
575: fnd_message.raise_error;
576: --
577: end if;
578: --
579: close csr_leg_code;