eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DPNT_EGD_BUS dependencies on FND_MESSAGE

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

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

Line 125: fnd_message.raise_error;

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

Line 182: fnd_message.set_name('BEN','BEN_94151_NOT_UNIQUE');

178: open c1;
179: fetch c1 into l_dummy;
180: if c1%found then
181: close c1;
182: fnd_message.set_name('BEN','BEN_94151_NOT_UNIQUE');
183: fnd_message.set_token('FIELD','Short Code');
184: fnd_message.raise_error;
185: end if;
186: --

Line 183: fnd_message.set_token('FIELD','Short Code');

179: fetch c1 into l_dummy;
180: if c1%found then
181: close c1;
182: fnd_message.set_name('BEN','BEN_94151_NOT_UNIQUE');
183: fnd_message.set_token('FIELD','Short Code');
184: fnd_message.raise_error;
185: end if;
186: --
187: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 184: fnd_message.raise_error;

180: if c1%found then
181: close c1;
182: fnd_message.set_name('BEN','BEN_94151_NOT_UNIQUE');
183: fnd_message.set_token('FIELD','Short Code');
184: fnd_message.raise_error;
185: end if;
186: --
187: hr_utility.set_location('Leaving:'||l_proc, 15);
188:

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

262: p_effective_date => p_effective_date) then
263: --
264: -- raise error as does not exist as lookup
265: --
266: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
267: fnd_message.set_token('FIELD', 'TYPE');
268: fnd_message.set_token('TYPE','BEN_CRITERIA_TYPE');
269: fnd_message.set_token('VALUE',p_criteria_type);
270: fnd_message.raise_error;

Line 267: fnd_message.set_token('FIELD', 'TYPE');

263: --
264: -- raise error as does not exist as lookup
265: --
266: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
267: fnd_message.set_token('FIELD', 'TYPE');
268: fnd_message.set_token('TYPE','BEN_CRITERIA_TYPE');
269: fnd_message.set_token('VALUE',p_criteria_type);
270: fnd_message.raise_error;
271: --

Line 268: fnd_message.set_token('TYPE','BEN_CRITERIA_TYPE');

264: -- raise error as does not exist as lookup
265: --
266: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
267: fnd_message.set_token('FIELD', 'TYPE');
268: fnd_message.set_token('TYPE','BEN_CRITERIA_TYPE');
269: fnd_message.set_token('VALUE',p_criteria_type);
270: fnd_message.raise_error;
271: --
272: end if;

Line 269: fnd_message.set_token('VALUE',p_criteria_type);

265: --
266: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
267: fnd_message.set_token('FIELD', 'TYPE');
268: fnd_message.set_token('TYPE','BEN_CRITERIA_TYPE');
269: fnd_message.set_token('VALUE',p_criteria_type);
270: fnd_message.raise_error;
271: --
272: end if;
273: --

Line 270: fnd_message.raise_error;

266: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
267: fnd_message.set_token('FIELD', 'TYPE');
268: fnd_message.set_token('TYPE','BEN_CRITERIA_TYPE');
269: fnd_message.set_token('VALUE',p_criteria_type);
270: fnd_message.raise_error;
271: --
272: end if;
273: --
274: end if;

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

287: p_effective_date => p_effective_date) then
288: --
289: -- raise error as does not exist as lookup
290: --
291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD', 'Crit Col1 Val Type Cd');
293: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
294: fnd_message.set_token('VALUE',p_crit_col1_val_type_cd);
295: fnd_message.raise_error;

Line 292: fnd_message.set_token('FIELD', 'Crit Col1 Val Type Cd');

288: --
289: -- raise error as does not exist as lookup
290: --
291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD', 'Crit Col1 Val Type Cd');
293: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
294: fnd_message.set_token('VALUE',p_crit_col1_val_type_cd);
295: fnd_message.raise_error;
296: --

Line 293: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');

289: -- raise error as does not exist as lookup
290: --
291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD', 'Crit Col1 Val Type Cd');
293: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
294: fnd_message.set_token('VALUE',p_crit_col1_val_type_cd);
295: fnd_message.raise_error;
296: --
297: end if;

Line 294: fnd_message.set_token('VALUE',p_crit_col1_val_type_cd);

290: --
291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD', 'Crit Col1 Val Type Cd');
293: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
294: fnd_message.set_token('VALUE',p_crit_col1_val_type_cd);
295: fnd_message.raise_error;
296: --
297: end if;
298: --

Line 295: fnd_message.raise_error;

291: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
292: fnd_message.set_token('FIELD', 'Crit Col1 Val Type Cd');
293: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
294: fnd_message.set_token('VALUE',p_crit_col1_val_type_cd);
295: fnd_message.raise_error;
296: --
297: end if;
298: --
299: end if;

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

312: p_effective_date => p_effective_date) then
313: --
314: -- raise error as does not exist as lookup
315: --
316: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
317: fnd_message.set_token('FIELD', 'Datatype');
318: fnd_message.set_token('TYPE', 'CRIT_COL1_DATATYPE');
319: fnd_message.set_token('VALUE', p_crit_col1_datatype);
320: fnd_message.raise_error;

Line 317: fnd_message.set_token('FIELD', 'Datatype');

313: --
314: -- raise error as does not exist as lookup
315: --
316: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
317: fnd_message.set_token('FIELD', 'Datatype');
318: fnd_message.set_token('TYPE', 'CRIT_COL1_DATATYPE');
319: fnd_message.set_token('VALUE', p_crit_col1_datatype);
320: fnd_message.raise_error;
321: --

Line 318: fnd_message.set_token('TYPE', 'CRIT_COL1_DATATYPE');

314: -- raise error as does not exist as lookup
315: --
316: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
317: fnd_message.set_token('FIELD', 'Datatype');
318: fnd_message.set_token('TYPE', 'CRIT_COL1_DATATYPE');
319: fnd_message.set_token('VALUE', p_crit_col1_datatype);
320: fnd_message.raise_error;
321: --
322: end if;

Line 319: fnd_message.set_token('VALUE', p_crit_col1_datatype);

315: --
316: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
317: fnd_message.set_token('FIELD', 'Datatype');
318: fnd_message.set_token('TYPE', 'CRIT_COL1_DATATYPE');
319: fnd_message.set_token('VALUE', p_crit_col1_datatype);
320: fnd_message.raise_error;
321: --
322: end if;
323: --

Line 320: fnd_message.raise_error;

316: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
317: fnd_message.set_token('FIELD', 'Datatype');
318: fnd_message.set_token('TYPE', 'CRIT_COL1_DATATYPE');
319: fnd_message.set_token('VALUE', p_crit_col1_datatype);
320: fnd_message.raise_error;
321: --
322: end if;
323: --
324: end if;

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

337: p_effective_date => p_effective_date) then
338: --
339: -- raise error as does not exist as lookup
340: --
341: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
342: fnd_message.set_token('FIELD', p_crit_col2_val_type_cd);
343: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
344: fnd_message.set_token('VALUE', p_crit_col2_val_type_cd);
345: fnd_message.raise_error;

Line 342: fnd_message.set_token('FIELD', p_crit_col2_val_type_cd);

338: --
339: -- raise error as does not exist as lookup
340: --
341: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
342: fnd_message.set_token('FIELD', p_crit_col2_val_type_cd);
343: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
344: fnd_message.set_token('VALUE', p_crit_col2_val_type_cd);
345: fnd_message.raise_error;
346: --

Line 343: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');

339: -- raise error as does not exist as lookup
340: --
341: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
342: fnd_message.set_token('FIELD', p_crit_col2_val_type_cd);
343: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
344: fnd_message.set_token('VALUE', p_crit_col2_val_type_cd);
345: fnd_message.raise_error;
346: --
347: end if;

Line 344: fnd_message.set_token('VALUE', p_crit_col2_val_type_cd);

340: --
341: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
342: fnd_message.set_token('FIELD', p_crit_col2_val_type_cd);
343: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
344: fnd_message.set_token('VALUE', p_crit_col2_val_type_cd);
345: fnd_message.raise_error;
346: --
347: end if;
348: --

Line 345: fnd_message.raise_error;

341: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
342: fnd_message.set_token('FIELD', p_crit_col2_val_type_cd);
343: fnd_message.set_token('TYPE', 'CRIT_COL1_VAL_TYPE_CD');
344: fnd_message.set_token('VALUE', p_crit_col2_val_type_cd);
345: fnd_message.raise_error;
346: --
347: end if;
348: --
349: end if;

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

362: p_effective_date => p_effective_date) then
363: --
364: -- raise error as does not exist as lookup
365: --
366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
367: fnd_message.set_token('FIELD', 'Allow Range Validation');
368: fnd_message.set_token('TYPE', 'YES_NO');
369: fnd_message.set_token('VALUE', p_allow_range_validation_flg);
370: fnd_message.raise_error;

Line 367: fnd_message.set_token('FIELD', 'Allow Range Validation');

363: --
364: -- raise error as does not exist as lookup
365: --
366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
367: fnd_message.set_token('FIELD', 'Allow Range Validation');
368: fnd_message.set_token('TYPE', 'YES_NO');
369: fnd_message.set_token('VALUE', p_allow_range_validation_flg);
370: fnd_message.raise_error;
371: --

Line 368: fnd_message.set_token('TYPE', 'YES_NO');

364: -- raise error as does not exist as lookup
365: --
366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
367: fnd_message.set_token('FIELD', 'Allow Range Validation');
368: fnd_message.set_token('TYPE', 'YES_NO');
369: fnd_message.set_token('VALUE', p_allow_range_validation_flg);
370: fnd_message.raise_error;
371: --
372: end if;

Line 369: fnd_message.set_token('VALUE', p_allow_range_validation_flg);

365: --
366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
367: fnd_message.set_token('FIELD', 'Allow Range Validation');
368: fnd_message.set_token('TYPE', 'YES_NO');
369: fnd_message.set_token('VALUE', p_allow_range_validation_flg);
370: fnd_message.raise_error;
371: --
372: end if;
373: --

Line 370: fnd_message.raise_error;

366: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
367: fnd_message.set_token('FIELD', 'Allow Range Validation');
368: fnd_message.set_token('TYPE', 'YES_NO');
369: fnd_message.set_token('VALUE', p_allow_range_validation_flg);
370: fnd_message.raise_error;
371: --
372: end if;
373: --
374: end if;

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

388: p_effective_date => p_effective_date) then
389: --
390: -- raise error as does not exist as lookup
391: --
392: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
393: fnd_message.set_token('FIELD', 'Allow Range Validation');
394: fnd_message.set_token('TYPE', 'YES_NO');
395: fnd_message.set_token('VALUE', p_allow_range_validation_flag2);
396: fnd_message.raise_error;

Line 393: fnd_message.set_token('FIELD', 'Allow Range Validation');

389: --
390: -- raise error as does not exist as lookup
391: --
392: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
393: fnd_message.set_token('FIELD', 'Allow Range Validation');
394: fnd_message.set_token('TYPE', 'YES_NO');
395: fnd_message.set_token('VALUE', p_allow_range_validation_flag2);
396: fnd_message.raise_error;
397: --

Line 394: fnd_message.set_token('TYPE', 'YES_NO');

390: -- raise error as does not exist as lookup
391: --
392: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
393: fnd_message.set_token('FIELD', 'Allow Range Validation');
394: fnd_message.set_token('TYPE', 'YES_NO');
395: fnd_message.set_token('VALUE', p_allow_range_validation_flag2);
396: fnd_message.raise_error;
397: --
398: end if;

Line 395: fnd_message.set_token('VALUE', p_allow_range_validation_flag2);

391: --
392: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
393: fnd_message.set_token('FIELD', 'Allow Range Validation');
394: fnd_message.set_token('TYPE', 'YES_NO');
395: fnd_message.set_token('VALUE', p_allow_range_validation_flag2);
396: fnd_message.raise_error;
397: --
398: end if;
399: --

Line 396: fnd_message.raise_error;

392: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
393: fnd_message.set_token('FIELD', 'Allow Range Validation');
394: fnd_message.set_token('TYPE', 'YES_NO');
395: fnd_message.set_token('VALUE', p_allow_range_validation_flag2);
396: fnd_message.raise_error;
397: --
398: end if;
399: --
400: end if;

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

414: p_effective_date => p_effective_date) then
415: --
416: -- raise error as does not exist as lookup
417: --
418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD', 'User Defined Flag');
420: fnd_message.set_token('TYPE', 'YES_NO');
421: fnd_message.set_token('VALUE', p_user_defined_flag);
422: fnd_message.raise_error;

Line 419: fnd_message.set_token('FIELD', 'User Defined Flag');

415: --
416: -- raise error as does not exist as lookup
417: --
418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD', 'User Defined Flag');
420: fnd_message.set_token('TYPE', 'YES_NO');
421: fnd_message.set_token('VALUE', p_user_defined_flag);
422: fnd_message.raise_error;
423: --

Line 420: fnd_message.set_token('TYPE', 'YES_NO');

416: -- raise error as does not exist as lookup
417: --
418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD', 'User Defined Flag');
420: fnd_message.set_token('TYPE', 'YES_NO');
421: fnd_message.set_token('VALUE', p_user_defined_flag);
422: fnd_message.raise_error;
423: --
424: end if;

Line 421: fnd_message.set_token('VALUE', p_user_defined_flag);

417: --
418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD', 'User Defined Flag');
420: fnd_message.set_token('TYPE', 'YES_NO');
421: fnd_message.set_token('VALUE', p_user_defined_flag);
422: fnd_message.raise_error;
423: --
424: end if;
425: --

Line 422: fnd_message.raise_error;

418: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
419: fnd_message.set_token('FIELD', 'User Defined Flag');
420: fnd_message.set_token('TYPE', 'YES_NO');
421: fnd_message.set_token('VALUE', p_user_defined_flag);
422: fnd_message.raise_error;
423: --
424: end if;
425: --
426: end if;

Line 519: fnd_message.set_name('PER','HR_6091_DEF_MISSING_LOOKUPS');

515: open c1(p_col1_lookup_type, p_business_group_id);
516: fetch c1 into l_dummy;
517: if c1%notfound then
518: close c1;
519: fnd_message.set_name('PER','HR_6091_DEF_MISSING_LOOKUPS');
520: fnd_message.set_token('LOOKUP_TYPE', p_col1_lookup_type);
521: fnd_message.raise_error;
522: end if;
523: close c1;

Line 520: fnd_message.set_token('LOOKUP_TYPE', p_col1_lookup_type);

516: fetch c1 into l_dummy;
517: if c1%notfound then
518: close c1;
519: fnd_message.set_name('PER','HR_6091_DEF_MISSING_LOOKUPS');
520: fnd_message.set_token('LOOKUP_TYPE', p_col1_lookup_type);
521: fnd_message.raise_error;
522: end if;
523: close c1;
524: --

Line 521: fnd_message.raise_error;

517: if c1%notfound then
518: close c1;
519: fnd_message.set_name('PER','HR_6091_DEF_MISSING_LOOKUPS');
520: fnd_message.set_token('LOOKUP_TYPE', p_col1_lookup_type);
521: fnd_message.raise_error;
522: end if;
523: close c1;
524: --
525: end if;

Line 538: fnd_message.set_name('PER','HR_6091_DEF_MISSING_LOOKUPS');

534: open c1(p_col2_lookup_type, p_business_group_id);
535: fetch c1 into l_dummy;
536: if c1%notfound then
537: close c1;
538: fnd_message.set_name('PER','HR_6091_DEF_MISSING_LOOKUPS');
539: fnd_message.set_token('LOOKUP_TYPE', p_col2_lookup_type);
540: fnd_message.raise_error;
541: end if;
542: close c1;

Line 539: fnd_message.set_token('LOOKUP_TYPE', p_col2_lookup_type);

535: fetch c1 into l_dummy;
536: if c1%notfound then
537: close c1;
538: fnd_message.set_name('PER','HR_6091_DEF_MISSING_LOOKUPS');
539: fnd_message.set_token('LOOKUP_TYPE', p_col2_lookup_type);
540: fnd_message.raise_error;
541: end if;
542: close c1;
543: --

Line 540: fnd_message.raise_error;

536: if c1%notfound then
537: close c1;
538: fnd_message.set_name('PER','HR_6091_DEF_MISSING_LOOKUPS');
539: fnd_message.set_token('LOOKUP_TYPE', p_col2_lookup_type);
540: fnd_message.raise_error;
541: end if;
542: close c1;
543: --
544: end if;

Line 627: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');

623: --
624: --
625: -- raise error
626: --
627: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');
628: fnd_message.set_token('ID',p_access_calc_rule);
629: fnd_message.set_token('TYPE_ID',-552);
630: fnd_message.raise_error;
631: --

Line 628: fnd_message.set_token('ID',p_access_calc_rule);

624: --
625: -- raise error
626: --
627: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');
628: fnd_message.set_token('ID',p_access_calc_rule);
629: fnd_message.set_token('TYPE_ID',-552);
630: fnd_message.raise_error;
631: --
632: end if;

Line 629: fnd_message.set_token('TYPE_ID',-552);

625: -- raise error
626: --
627: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');
628: fnd_message.set_token('ID',p_access_calc_rule);
629: fnd_message.set_token('TYPE_ID',-552);
630: fnd_message.raise_error;
631: --
632: end if;
633: --

Line 630: fnd_message.raise_error;

626: --
627: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');
628: fnd_message.set_token('ID',p_access_calc_rule);
629: fnd_message.set_token('TYPE_ID',-552);
630: fnd_message.raise_error;
631: --
632: end if;
633: --
634: close c_formula;

Line 703: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');

699: open c1(p_col1_value_set_id);
700: fetch c1 into l_dummy;
701: if c1%notfound then
702: close c1;
703: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
704: fnd_message.set_token('VALUESET',p_col1_value_set_id);
705: fnd_message.raise_error;
706: end if;
707: close c1;

Line 704: fnd_message.set_token('VALUESET',p_col1_value_set_id);

700: fetch c1 into l_dummy;
701: if c1%notfound then
702: close c1;
703: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
704: fnd_message.set_token('VALUESET',p_col1_value_set_id);
705: fnd_message.raise_error;
706: end if;
707: close c1;
708: --

Line 705: fnd_message.raise_error;

701: if c1%notfound then
702: close c1;
703: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
704: fnd_message.set_token('VALUESET',p_col1_value_set_id);
705: fnd_message.raise_error;
706: end if;
707: close c1;
708: --
709: end if;

Line 722: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');

718: open c1(p_col2_value_set_id);
719: fetch c1 into l_dummy;
720: if c1%notfound then
721: close c1;
722: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
723: fnd_message.set_token('VALUESET',p_col2_value_set_id);
724: fnd_message.raise_error;
725: end if;
726: close c1;

Line 723: fnd_message.set_token('VALUESET',p_col2_value_set_id);

719: fetch c1 into l_dummy;
720: if c1%notfound then
721: close c1;
722: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
723: fnd_message.set_token('VALUESET',p_col2_value_set_id);
724: fnd_message.raise_error;
725: end if;
726: close c1;
727: --

Line 724: fnd_message.raise_error;

720: if c1%notfound then
721: close c1;
722: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
723: fnd_message.set_token('VALUESET',p_col2_value_set_id);
724: fnd_message.raise_error;
725: end if;
726: close c1;
727: --
728: end if;

Line 786: fnd_message.set_name('BEN','BEN_94133_EGL_CHLD_RCD_EXISTS');

782: close chk_eligy_criteria;
783: --
784: -- raise error
785: --
786: fnd_message.set_name('BEN','BEN_94133_EGL_CHLD_RCD_EXISTS');
787: fnd_message.raise_error;
788: end if;
789: --
790: close chk_eligy_criteria;

Line 787: fnd_message.raise_error;

783: --
784: -- raise error
785: --
786: fnd_message.set_name('BEN','BEN_94133_EGL_CHLD_RCD_EXISTS');
787: fnd_message.raise_error;
788: end if;
789: --
790: close chk_eligy_criteria;
791: --

Line 836: fnd_message.set_name('BEN','BEN_94134_ACCESS_RL_TAB_COL');

832: or p_access_column_name1 is not null ) )
833:
834: then
835: --
836: fnd_message.set_name('BEN','BEN_94134_ACCESS_RL_TAB_COL');
837: fnd_message.raise_error;
838: --
839: end if;
840:

Line 837: fnd_message.raise_error;

833:
834: then
835: --
836: fnd_message.set_name('BEN','BEN_94134_ACCESS_RL_TAB_COL');
837: fnd_message.raise_error;
838: --
839: end if;
840:
841: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 907: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');

903: fetch c1 into l_table_id;
904: --
905: if c1%notfound then
906: close c1;
907: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
908: fnd_message.set_token('PROCNAME',l_proc);
909: fnd_message.raise_error;
910: --
911: else

Line 908: fnd_message.set_token('PROCNAME',l_proc);

904: --
905: if c1%notfound then
906: close c1;
907: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
908: fnd_message.set_token('PROCNAME',l_proc);
909: fnd_message.raise_error;
910: --
911: else
912: --

Line 909: fnd_message.raise_error;

905: if c1%notfound then
906: close c1;
907: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
908: fnd_message.set_token('PROCNAME',l_proc);
909: fnd_message.raise_error;
910: --
911: else
912: --
913: if p_access_table_name1 not in ('PER_ALL_ASSIGNMENTS_F','PER_ALL_PEOPLE_F')then

Line 914: fnd_message.set_name ('BEN','BEN_91039_INVALID_TABLE');

910: --
911: else
912: --
913: if p_access_table_name1 not in ('PER_ALL_ASSIGNMENTS_F','PER_ALL_PEOPLE_F')then
914: fnd_message.set_name ('BEN','BEN_91039_INVALID_TABLE');
915: fnd_message.set_token('TABLENAME','p_access_table_name1');
916: fnd_message.set_token('PROCNAME',l_proc);
917: fnd_message.raise_error;
918: end if;

Line 915: fnd_message.set_token('TABLENAME','p_access_table_name1');

911: else
912: --
913: if p_access_table_name1 not in ('PER_ALL_ASSIGNMENTS_F','PER_ALL_PEOPLE_F')then
914: fnd_message.set_name ('BEN','BEN_91039_INVALID_TABLE');
915: fnd_message.set_token('TABLENAME','p_access_table_name1');
916: fnd_message.set_token('PROCNAME',l_proc);
917: fnd_message.raise_error;
918: end if;
919: --

Line 916: fnd_message.set_token('PROCNAME',l_proc);

912: --
913: if p_access_table_name1 not in ('PER_ALL_ASSIGNMENTS_F','PER_ALL_PEOPLE_F')then
914: fnd_message.set_name ('BEN','BEN_91039_INVALID_TABLE');
915: fnd_message.set_token('TABLENAME','p_access_table_name1');
916: fnd_message.set_token('PROCNAME',l_proc);
917: fnd_message.raise_error;
918: end if;
919: --
920: end if;

Line 917: fnd_message.raise_error;

913: if p_access_table_name1 not in ('PER_ALL_ASSIGNMENTS_F','PER_ALL_PEOPLE_F')then
914: fnd_message.set_name ('BEN','BEN_91039_INVALID_TABLE');
915: fnd_message.set_token('TABLENAME','p_access_table_name1');
916: fnd_message.set_token('PROCNAME',l_proc);
917: fnd_message.raise_error;
918: end if;
919: --
920: end if;
921: --

Line 928: fnd_message.set_name('BEN','BEN_94433_COLUMN_REQUIRED');

924: end if;
925: --
926: --
927: if (p_access_table_name1 is not null and p_access_column_name1 is null) then
928: fnd_message.set_name('BEN','BEN_94433_COLUMN_REQUIRED');
929: fnd_message.raise_error;
930: end if;
931: --
932:

Line 929: fnd_message.raise_error;

925: --
926: --
927: if (p_access_table_name1 is not null and p_access_column_name1 is null) then
928: fnd_message.set_name('BEN','BEN_94433_COLUMN_REQUIRED');
929: fnd_message.raise_error;
930: end if;
931: --
932:
933: if p_access_column_name1 is not null then

Line 936: fnd_message.set_name('BEN','BEN_94730_TABLE_REQUIRED');

932:
933: if p_access_column_name1 is not null then
934: --
935: if p_access_table_name1 is null then
936: fnd_message.set_name('BEN','BEN_94730_TABLE_REQUIRED');
937: fnd_message.raise_error;
938: --
939: else
940: open c2(p_access_column_name1);

Line 937: fnd_message.raise_error;

933: if p_access_column_name1 is not null then
934: --
935: if p_access_table_name1 is null then
936: fnd_message.set_name('BEN','BEN_94730_TABLE_REQUIRED');
937: fnd_message.raise_error;
938: --
939: else
940: open c2(p_access_column_name1);
941: fetch c2 into l_dummy;

Line 944: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');

940: open c2(p_access_column_name1);
941: fetch c2 into l_dummy;
942: if c2%notfound then
943: close c2;
944: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
945: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
946: fnd_message.set_token('PROCNAME',l_proc);
947: fnd_message.raise_error;
948: end if;

Line 945: fnd_message.set_token('COLUMNNAME',p_access_column_name1);

941: fetch c2 into l_dummy;
942: if c2%notfound then
943: close c2;
944: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
945: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
946: fnd_message.set_token('PROCNAME',l_proc);
947: fnd_message.raise_error;
948: end if;
949: --

Line 946: fnd_message.set_token('PROCNAME',l_proc);

942: if c2%notfound then
943: close c2;
944: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
945: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
946: fnd_message.set_token('PROCNAME',l_proc);
947: fnd_message.raise_error;
948: end if;
949: --
950: close c2;

Line 947: fnd_message.raise_error;

943: close c2;
944: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
945: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
946: fnd_message.set_token('PROCNAME',l_proc);
947: fnd_message.raise_error;
948: end if;
949: --
950: close c2;
951: --

Line 965: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');

961: fetch c1 into l_table_id;
962: --
963: if c1%notfound then
964: close c1;
965: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
966: fnd_message.set_token('TABLENAME',p_access_table_name2);
967: fnd_message.set_token('PROCNAME',l_proc);
968: end if;
969: --

Line 966: fnd_message.set_token('TABLENAME',p_access_table_name2);

962: --
963: if c1%notfound then
964: close c1;
965: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
966: fnd_message.set_token('TABLENAME',p_access_table_name2);
967: fnd_message.set_token('PROCNAME',l_proc);
968: end if;
969: --
970: close c1;

Line 967: fnd_message.set_token('PROCNAME',l_proc);

963: if c1%notfound then
964: close c1;
965: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
966: fnd_message.set_token('TABLENAME',p_access_table_name2);
967: fnd_message.set_token('PROCNAME',l_proc);
968: end if;
969: --
970: close c1;
971: --

Line 976: fnd_message.set_name('BEN','BEN_94484_COLUMN_REQUIRED');

972: end if;
973: --
974: --
975: if (p_access_table_name2 is not null and p_access_column_name2 is null) then
976: fnd_message.set_name('BEN','BEN_94484_COLUMN_REQUIRED');
977: fnd_message.raise_error;
978: end if;
979: --
980:

Line 977: fnd_message.raise_error;

973: --
974: --
975: if (p_access_table_name2 is not null and p_access_column_name2 is null) then
976: fnd_message.set_name('BEN','BEN_94484_COLUMN_REQUIRED');
977: fnd_message.raise_error;
978: end if;
979: --
980:
981: if p_access_column_name2 is not null then

Line 984: fnd_message.set_name('BEN','BEN_94485_TABLE_REQUIRED');

980:
981: if p_access_column_name2 is not null then
982: --
983: if p_access_table_name2 is null then
984: fnd_message.set_name('BEN','BEN_94485_TABLE_REQUIRED');
985: fnd_message.raise_error;
986: --
987: else
988: open c2(p_access_column_name2);

Line 985: fnd_message.raise_error;

981: if p_access_column_name2 is not null then
982: --
983: if p_access_table_name2 is null then
984: fnd_message.set_name('BEN','BEN_94485_TABLE_REQUIRED');
985: fnd_message.raise_error;
986: --
987: else
988: open c2(p_access_column_name2);
989: fetch c2 into l_dummy;

Line 993: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');

989: fetch c2 into l_dummy;
990: --
991: if c2%notfound then
992: close c2;
993: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
994: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
995: fnd_message.set_token('PROCNAME',l_proc);
996: fnd_message.raise_error;
997: end if;

Line 994: fnd_message.set_token('COLUMNNAME',p_access_column_name1);

990: --
991: if c2%notfound then
992: close c2;
993: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
994: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
995: fnd_message.set_token('PROCNAME',l_proc);
996: fnd_message.raise_error;
997: end if;
998: --

Line 995: fnd_message.set_token('PROCNAME',l_proc);

991: if c2%notfound then
992: close c2;
993: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
994: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
995: fnd_message.set_token('PROCNAME',l_proc);
996: fnd_message.raise_error;
997: end if;
998: --
999: close c2;

Line 996: fnd_message.raise_error;

992: close c2;
993: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
994: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
995: fnd_message.set_token('PROCNAME',l_proc);
996: fnd_message.raise_error;
997: end if;
998: --
999: close c2;
1000: --

Line 1060: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');

1056: --
1057: if (p_col_lookup_type is null or p_col_value_set_id is not null)
1058: then
1059: --
1060: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1061: fnd_message.raise_error;
1062: --
1063: end if;
1064: --

Line 1061: fnd_message.raise_error;

1057: if (p_col_lookup_type is null or p_col_value_set_id is not null)
1058: then
1059: --
1060: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1061: fnd_message.raise_error;
1062: --
1063: end if;
1064: --
1065: else

Line 1073: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');

1069: --
1070: if (p_col_lookup_type is not null or p_col_value_set_id is null)
1071: then
1072: --
1073: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1074: fnd_message.raise_error;
1075: --
1076: end if;
1077: --

Line 1074: fnd_message.raise_error;

1070: if (p_col_lookup_type is not null or p_col_value_set_id is null)
1071: then
1072: --
1073: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1074: fnd_message.raise_error;
1075: --
1076: end if;
1077: --
1078: else

Line 1086: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');

1082: --
1083: if (p_col_lookup_type is not null or p_col_value_set_id is not null )
1084: then
1085: --
1086: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1087: fnd_message.raise_error;
1088: --
1089: else
1090: --

Line 1087: fnd_message.raise_error;

1083: if (p_col_lookup_type is not null or p_col_value_set_id is not null )
1084: then
1085: --
1086: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1087: fnd_message.raise_error;
1088: --
1089: else
1090: --
1091: if(p_allow_range_validation_flg = 'Y')

Line 1094: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');

1090: --
1091: if(p_allow_range_validation_flg = 'Y')
1092: then
1093: --
1094: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1095: fnd_message.raise_error;
1096: --
1097: else
1098: --

Line 1095: fnd_message.raise_error;

1091: if(p_allow_range_validation_flg = 'Y')
1092: then
1093: --
1094: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1095: fnd_message.raise_error;
1096: --
1097: else
1098: --
1099: if p_crit_col_val_type_cd ='ORG_HIER'

Line 1105: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');

1101: --
1102: if (p_access_table_name <> 'PER_ALL_ASSIGNMENTS_F' or p_access_column_name <> 'ORGANIZATION_ID')
1103: then
1104: --
1105: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1106: fnd_message.raise_error;
1107: --
1108: end if;
1109: --

Line 1106: fnd_message.raise_error;

1102: if (p_access_table_name <> 'PER_ALL_ASSIGNMENTS_F' or p_access_column_name <> 'ORGANIZATION_ID')
1103: then
1104: --
1105: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1106: fnd_message.raise_error;
1107: --
1108: end if;
1109: --
1110: else

Line 1118: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');

1114: --
1115: if (p_access_table_name <> 'PER_ALL_ASSIGNMENTS_F' or p_access_column_name <> 'POSITION_ID')
1116: then
1117: --
1118: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1119: fnd_message.raise_error;
1120: --
1121: end if;
1122: --

Line 1119: fnd_message.raise_error;

1115: if (p_access_table_name <> 'PER_ALL_ASSIGNMENTS_F' or p_access_column_name <> 'POSITION_ID')
1116: then
1117: --
1118: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1119: fnd_message.raise_error;
1120: --
1121: end if;
1122: --
1123: end if;

Line 1144: fnd_message.set_name('BEN','BEN_94732_DEP_VAL_TYP_CD_NULL');

1140: then
1141: --
1142: -- Bug 4729818 Display Appropriate error messages for two Sets
1143: if (p_set = 1) then --signifies set 1 is being checked
1144: fnd_message.set_name('BEN','BEN_94732_DEP_VAL_TYP_CD_NULL');
1145: fnd_message.raise_error;
1146: end if;
1147:
1148: if (p_set = 2) then -- signifies set 2 is being checked

Line 1145: fnd_message.raise_error;

1141: --
1142: -- Bug 4729818 Display Appropriate error messages for two Sets
1143: if (p_set = 1) then --signifies set 1 is being checked
1144: fnd_message.set_name('BEN','BEN_94732_DEP_VAL_TYP_CD_NULL');
1145: fnd_message.raise_error;
1146: end if;
1147:
1148: if (p_set = 2) then -- signifies set 2 is being checked
1149: --RKG Set 2 Error Message for Bug 4729818

Line 1150: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');

1146: end if;
1147:
1148: if (p_set = 2) then -- signifies set 2 is being checked
1149: --RKG Set 2 Error Message for Bug 4729818
1150: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');
1151: fnd_message.raise_error;
1152: end if;
1153: --
1154: end if;

Line 1151: fnd_message.raise_error;

1147:
1148: if (p_set = 2) then -- signifies set 2 is being checked
1149: --RKG Set 2 Error Message for Bug 4729818
1150: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');
1151: fnd_message.raise_error;
1152: end if;
1153: --
1154: end if;
1155: --

Line 1220: fnd_message.set_name('BEN','BEN_94732_DEP_VAL_TYP_CD_NULL');

1216: then
1217: --
1218: --Bug 4729818 Display appropriate error messages
1219: if (p_set = 1) then --signifies set 1 is being checked
1220: fnd_message.set_name('BEN','BEN_94732_DEP_VAL_TYP_CD_NULL');
1221: fnd_message.raise_error;
1222: end if;
1223:
1224: if (p_set = 2) then -- signifies set 2 is being checked

Line 1221: fnd_message.raise_error;

1217: --
1218: --Bug 4729818 Display appropriate error messages
1219: if (p_set = 1) then --signifies set 1 is being checked
1220: fnd_message.set_name('BEN','BEN_94732_DEP_VAL_TYP_CD_NULL');
1221: fnd_message.raise_error;
1222: end if;
1223:
1224: if (p_set = 2) then -- signifies set 2 is being checked
1225: --RKG Set 2 Error Message for Bug 4729818

Line 1226: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');

1222: end if;
1223:
1224: if (p_set = 2) then -- signifies set 2 is being checked
1225: --RKG Set 2 Error Message for Bug 4729818
1226: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');
1227: fnd_message.raise_error;
1228: end if;
1229: --
1230:

Line 1227: fnd_message.raise_error;

1223:
1224: if (p_set = 2) then -- signifies set 2 is being checked
1225: --RKG Set 2 Error Message for Bug 4729818
1226: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');
1227: fnd_message.raise_error;
1228: end if;
1229: --
1230:
1231: else

Line 1248: fnd_message.set_name('BEN','BEN_94133_EGL_CHLD_RCD_EXISTS');

1244: --
1245: if chk_eligy_criteria%found then
1246: close chk_eligy_criteria;
1247: --
1248: fnd_message.set_name('BEN','BEN_94133_EGL_CHLD_RCD_EXISTS');
1249: fnd_message.raise_error;
1250: --
1251: --
1252: else

Line 1249: fnd_message.raise_error;

1245: if chk_eligy_criteria%found then
1246: close chk_eligy_criteria;
1247: --
1248: fnd_message.set_name('BEN','BEN_94133_EGL_CHLD_RCD_EXISTS');
1249: fnd_message.raise_error;
1250: --
1251: --
1252: else
1253: chk_col_val_type_cd(p_crit_col_val_type_cd => p_crit_col_val_type_cd,

Line 1313: fnd_message.set_name('BEN','BEN_94149_TAB_COL_RL_NULL');

1309: and p_access_column_name1 is null ) )
1310:
1311: then
1312: --
1313: fnd_message.set_name('BEN','BEN_94149_TAB_COL_RL_NULL');
1314: fnd_message.raise_error;
1315: --
1316: end if;
1317: --

Line 1314: fnd_message.raise_error;

1310:
1311: then
1312: --
1313: fnd_message.set_name('BEN','BEN_94149_TAB_COL_RL_NULL');
1314: fnd_message.raise_error;
1315: --
1316: end if;
1317: --
1318: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1553: fnd_message.set_name('BEN','BEN_94271_egd_HIER_NO_SET2');

1549: -- Check for Hierarchy Criteria type, There shd not be Sub-Criteria(Set2) defined
1550: if p_rec.crit_col1_val_type_cd like '%HIER' and
1551: l_set2_empty = 'N' then
1552: --
1553: fnd_message.set_name('BEN','BEN_94271_egd_HIER_NO_SET2');
1554: fnd_message.raise_error;
1555: --
1556: end if;
1557: --

Line 1554: fnd_message.raise_error;

1550: if p_rec.crit_col1_val_type_cd like '%HIER' and
1551: l_set2_empty = 'N' then
1552: --
1553: fnd_message.set_name('BEN','BEN_94271_egd_HIER_NO_SET2');
1554: fnd_message.raise_error;
1555: --
1556: end if;
1557: --
1558: if(l_set2_empty = 'N') then

Line 1719: fnd_message.set_name('BEN','BEN_94271_egd_HIER_NO_SET2');

1715: -- Check for Hierarchy Criteria type, There shd not be any Sub-Criteria defined
1716: if p_rec.crit_col1_val_type_cd like '%HIER' and
1717: l_set2_empty = 'N' then
1718: --
1719: fnd_message.set_name('BEN','BEN_94271_egd_HIER_NO_SET2');
1720: fnd_message.raise_error;
1721: --
1722: end if;
1723: --

Line 1720: fnd_message.raise_error;

1716: if p_rec.crit_col1_val_type_cd like '%HIER' and
1717: l_set2_empty = 'N' then
1718: --
1719: fnd_message.set_name('BEN','BEN_94271_egd_HIER_NO_SET2');
1720: fnd_message.raise_error;
1721: --
1722: end if;
1723: --
1724: if(l_set2_empty = 'N') then