118: v_to_value := to_number(p_to_value);
119: v_from_value := to_number(p_from_value);
120: begin
121: if v_from_value > v_to_value then
122: fnd_message.set_name('BEN','BEN_91619_TO_VAL_NOT_GTR_FRM_V');
123: fnd_message.raise_error;
124: end if;
125: exception
126: when value_error then
119: v_from_value := to_number(p_from_value);
120: begin
121: if v_from_value > v_to_value then
122: fnd_message.set_name('BEN','BEN_91619_TO_VAL_NOT_GTR_FRM_V');
123: fnd_message.raise_error;
124: end if;
125: exception
126: when value_error then
127: if p_to_value is not null then
124: end if;
125: exception
126: when value_error then
127: if p_to_value is not null then
128: fnd_message.set_name('BEN','BEN_91620_TO_VAL_MST_BE_NULL');
129: fnd_message.raise_error;
130: end if;
131: end;
132: exception
125: exception
126: when value_error then
127: if p_to_value is not null then
128: fnd_message.set_name('BEN','BEN_91620_TO_VAL_MST_BE_NULL');
129: fnd_message.raise_error;
130: end if;
131: end;
132: exception
133: when value_error then
130: end if;
131: end;
132: exception
133: when value_error then
134: -- fnd_message.set_name('BEN','BEN_91621_TO_VAL_MST_BE_NUM');
135: -- fnd_message.raise_error;
136: -- Bug 1612851 zip codes need not to be numberic .
137: if p_from_value > p_to_value then
138: --
131: end;
132: exception
133: when value_error then
134: -- fnd_message.set_name('BEN','BEN_91621_TO_VAL_MST_BE_NUM');
135: -- fnd_message.raise_error;
136: -- Bug 1612851 zip codes need not to be numberic .
137: if p_from_value > p_to_value then
138: --
139: fnd_message.set_name('BEN','BEN_91619_TO_VAL_NOT_GTR_FRM_V');
135: -- fnd_message.raise_error;
136: -- Bug 1612851 zip codes need not to be numberic .
137: if p_from_value > p_to_value then
138: --
139: fnd_message.set_name('BEN','BEN_91619_TO_VAL_NOT_GTR_FRM_V');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
136: -- Bug 1612851 zip codes need not to be numberic .
137: if p_from_value > p_to_value then
138: --
139: fnd_message.set_name('BEN','BEN_91619_TO_VAL_NOT_GTR_FRM_V');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end;
199: open c1;
200: fetch c1 into dummy;
201: if c1%found then
202: close c1;
203: fnd_message.set_name('BEN','BEN_92501_ZIP_RNG_NOT_UNIQUE');
204: fnd_message.raise_error;
205: end if;
206: close c1;
207: --
200: fetch c1 into dummy;
201: if c1%found then
202: close c1;
203: fnd_message.set_name('BEN','BEN_92501_ZIP_RNG_NOT_UNIQUE');
204: fnd_message.raise_error;
205: end if;
206: close c1;
207: --
208: hr_utility.set_location('Leaving:'||l_proc, 10);
284: --
285: -- A referential integrity check was violated therefore
286: -- we must error
287: --
288: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
289: fnd_message.set_token('TABLE_NAME', l_table_name);
290: fnd_message.raise_error;
291: When Others Then
292: --
285: -- A referential integrity check was violated therefore
286: -- we must error
287: --
288: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
289: fnd_message.set_token('TABLE_NAME', l_table_name);
290: fnd_message.raise_error;
291: When Others Then
292: --
293: -- An unhandled or unexpected error has occurred which
286: -- we must error
287: --
288: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
289: fnd_message.set_token('TABLE_NAME', l_table_name);
290: fnd_message.raise_error;
291: When Others Then
292: --
293: -- An unhandled or unexpected error has occurred which
294: -- we must report
292: --
293: -- An unhandled or unexpected error has occurred which
294: -- we must report
295: --
296: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
297: fnd_message.set_token('PROCEDURE', l_proc);
298: fnd_message.set_token('STEP','15');
299: fnd_message.raise_error;
300: End dt_update_validate;
293: -- An unhandled or unexpected error has occurred which
294: -- we must report
295: --
296: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
297: fnd_message.set_token('PROCEDURE', l_proc);
298: fnd_message.set_token('STEP','15');
299: fnd_message.raise_error;
300: End dt_update_validate;
301: --
294: -- we must report
295: --
296: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
297: fnd_message.set_token('PROCEDURE', l_proc);
298: fnd_message.set_token('STEP','15');
299: fnd_message.raise_error;
300: End dt_update_validate;
301: --
302: -- ----------------------------------------------------------------------------
295: --
296: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
297: fnd_message.set_token('PROCEDURE', l_proc);
298: fnd_message.set_token('STEP','15');
299: fnd_message.raise_error;
300: End dt_update_validate;
301: --
302: -- ----------------------------------------------------------------------------
303: -- |--------------------------< dt_delete_validate >--------------------------|
428: --
429: -- A referential integrity check was violated therefore
430: -- we must error
431: --
432: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
433: -- fnd_message.set_token('TABLE_NAME', l_table_name); -- Bug 2332140
434: --
435: fnd_message.set_name('BEN', 'BEN_93061_ZIP_CHLD_RCD_EXISTS');
436: fnd_message.set_token('TABLE_NAME',l_child_rec,TRUE ); -- Bug 2488652
429: -- A referential integrity check was violated therefore
430: -- we must error
431: --
432: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
433: -- fnd_message.set_token('TABLE_NAME', l_table_name); -- Bug 2332140
434: --
435: fnd_message.set_name('BEN', 'BEN_93061_ZIP_CHLD_RCD_EXISTS');
436: fnd_message.set_token('TABLE_NAME',l_child_rec,TRUE ); -- Bug 2488652
437: fnd_message.raise_error;
431: --
432: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
433: -- fnd_message.set_token('TABLE_NAME', l_table_name); -- Bug 2332140
434: --
435: fnd_message.set_name('BEN', 'BEN_93061_ZIP_CHLD_RCD_EXISTS');
436: fnd_message.set_token('TABLE_NAME',l_child_rec,TRUE ); -- Bug 2488652
437: fnd_message.raise_error;
438: --
439:
432: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
433: -- fnd_message.set_token('TABLE_NAME', l_table_name); -- Bug 2332140
434: --
435: fnd_message.set_name('BEN', 'BEN_93061_ZIP_CHLD_RCD_EXISTS');
436: fnd_message.set_token('TABLE_NAME',l_child_rec,TRUE ); -- Bug 2488652
437: fnd_message.raise_error;
438: --
439:
440: When Others Then
433: -- fnd_message.set_token('TABLE_NAME', l_table_name); -- Bug 2332140
434: --
435: fnd_message.set_name('BEN', 'BEN_93061_ZIP_CHLD_RCD_EXISTS');
436: fnd_message.set_token('TABLE_NAME',l_child_rec,TRUE ); -- Bug 2488652
437: fnd_message.raise_error;
438: --
439:
440: When Others Then
441: --
441: --
442: -- An unhandled or unexpected error has occurred which
443: -- we must report
444: --
445: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
446: fnd_message.set_token('PROCEDURE', l_proc);
447: fnd_message.set_token('STEP','15');
448: fnd_message.raise_error;
449: End dt_delete_validate;
442: -- An unhandled or unexpected error has occurred which
443: -- we must report
444: --
445: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
446: fnd_message.set_token('PROCEDURE', l_proc);
447: fnd_message.set_token('STEP','15');
448: fnd_message.raise_error;
449: End dt_delete_validate;
450: --
443: -- we must report
444: --
445: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
446: fnd_message.set_token('PROCEDURE', l_proc);
447: fnd_message.set_token('STEP','15');
448: fnd_message.raise_error;
449: End dt_delete_validate;
450: --
451: -- ----------------------------------------------------------------------------
444: --
445: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
446: fnd_message.set_token('PROCEDURE', l_proc);
447: fnd_message.set_token('STEP','15');
448: fnd_message.raise_error;
449: End dt_delete_validate;
450: --
451: -- ----------------------------------------------------------------------------
452: -- |---------------------------< insert_validate >----------------------------|
612: close csr_leg_code;
613: --
614: -- The primary key is invalid therefore we must error
615: --
616: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
617: fnd_message.raise_error;
618: --
619: end if;
620: --
613: --
614: -- The primary key is invalid therefore we must error
615: --
616: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
617: fnd_message.raise_error;
618: --
619: end if;
620: --
621: close csr_leg_code;