133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.raise_error;
139: --
140: end if;
141: --
142: end if;
224: close csr_organization_id;
225: --
226: -- raise error as this reg body already exists for this regulation
227: --
228: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
229: fnd_message.raise_error;
230: --
231: end if;
232: --
225: --
226: -- raise error as this reg body already exists for this regulation
227: --
228: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
229: fnd_message.raise_error;
230: --
231: end if;
232: --
233: end if;
321: --
322: -- A referential integrity check was violated therefore
323: -- we must error
324: --
325: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
326: fnd_message.set_token('TABLE_NAME', l_table_name);
327: fnd_message.raise_error;
328: When Others Then
329: --
322: -- A referential integrity check was violated therefore
323: -- we must error
324: --
325: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
326: fnd_message.set_token('TABLE_NAME', l_table_name);
327: fnd_message.raise_error;
328: When Others Then
329: --
330: -- An unhandled or unexpected error has occurred which
323: -- we must error
324: --
325: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
326: fnd_message.set_token('TABLE_NAME', l_table_name);
327: fnd_message.raise_error;
328: When Others Then
329: --
330: -- An unhandled or unexpected error has occurred which
331: -- we must report
329: --
330: -- An unhandled or unexpected error has occurred which
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
330: -- An unhandled or unexpected error has occurred which
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
339: -- ----------------------------------------------------------------------------
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
339: -- ----------------------------------------------------------------------------
340: -- |--------------------------< dt_delete_validate >--------------------------|
425: --
426: -- A referential integrity check was violated therefore
427: -- we must error
428: --
429: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
430: fnd_message.set_token('TABLE_NAME', l_table_name);
431: fnd_message.raise_error;
432: When Others Then
433: --
426: -- A referential integrity check was violated therefore
427: -- we must error
428: --
429: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
430: fnd_message.set_token('TABLE_NAME', l_table_name);
431: fnd_message.raise_error;
432: When Others Then
433: --
434: -- An unhandled or unexpected error has occurred which
427: -- we must error
428: --
429: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
430: fnd_message.set_token('TABLE_NAME', l_table_name);
431: fnd_message.raise_error;
432: When Others Then
433: --
434: -- An unhandled or unexpected error has occurred which
435: -- we must report
433: --
434: -- An unhandled or unexpected error has occurred which
435: -- we must report
436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_delete_validate;
434: -- An unhandled or unexpected error has occurred which
435: -- we must report
436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_delete_validate;
442: --
435: -- we must report
436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_delete_validate;
442: --
443: -- ----------------------------------------------------------------------------
436: --
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE', l_proc);
439: fnd_message.set_token('STEP','15');
440: fnd_message.raise_error;
441: End dt_delete_validate;
442: --
443: -- ----------------------------------------------------------------------------
444: -- |---------------------------< insert_validate >----------------------------|
604: close csr_leg_code;
605: --
606: -- The primary key is invalid therefore we must error
607: --
608: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
609: fnd_message.raise_error;
610: --
611: end if;
612: --
605: --
606: -- The primary key is invalid therefore we must error
607: --
608: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
609: fnd_message.raise_error;
610: --
611: end if;
612: --
613: close csr_leg_code;