DBA Data[Home] [Help]

APPS.BEN_RZR_BUS dependencies on FND_MESSAGE

Line 122: fnd_message.set_name('BEN','BEN_91619_TO_VAL_NOT_GTR_FRM_V');

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

Line 123: fnd_message.raise_error;

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

Line 128: fnd_message.set_name('BEN','BEN_91620_TO_VAL_MST_BE_NULL');

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

Line 129: fnd_message.raise_error;

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

Line 134: -- fnd_message.set_name('BEN','BEN_91621_TO_VAL_MST_BE_NUM');

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: --

Line 135: -- fnd_message.raise_error;

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

Line 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: --

Line 140: 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: --
144: end;

Line 203: fnd_message.set_name('BEN','BEN_92501_ZIP_RNG_NOT_UNIQUE');

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: --

Line 204: fnd_message.raise_error;

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);

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

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: --

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

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

Line 290: fnd_message.raise_error;

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

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

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;

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

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: --

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

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: -- ----------------------------------------------------------------------------

Line 299: fnd_message.raise_error;

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 >--------------------------|

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

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

Line 433: -- fnd_message.set_token('TABLE_NAME', l_table_name); -- Bug 2332140

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;

Line 435: fnd_message.set_name('BEN', 'BEN_93061_ZIP_CHLD_RCD_EXISTS');

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:

Line 436: fnd_message.set_token('TABLE_NAME',l_child_rec,TRUE ); -- Bug 2488652

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

Line 437: fnd_message.raise_error;

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: --

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

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;

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

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: --

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

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: -- ----------------------------------------------------------------------------

Line 448: fnd_message.raise_error;

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 >----------------------------|

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

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: --

Line 617: fnd_message.raise_error;

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;