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_EGL_BUS dependencies on FND_MESSAGE

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

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

Line 124: fnd_message.raise_error;

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

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

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

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

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

Line 183: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 269: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 294: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 319: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 344: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 369: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 395: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

Line 421: fnd_message.raise_error;

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

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

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

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

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

Line 520: fnd_message.raise_error;

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

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

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

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

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

Line 539: fnd_message.raise_error;

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

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

628: */
629: --
630: -- raise error
631: --
632: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');
633: fnd_message.set_token('ID',p_access_calc_rule);
634: fnd_message.set_token('TYPE_ID',-552);
635: fnd_message.raise_error;
636: --

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

629: --
630: -- raise error
631: --
632: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');
633: fnd_message.set_token('ID',p_access_calc_rule);
634: fnd_message.set_token('TYPE_ID',-552);
635: fnd_message.raise_error;
636: --
637: end if;

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

630: -- raise error
631: --
632: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');
633: fnd_message.set_token('ID',p_access_calc_rule);
634: fnd_message.set_token('TYPE_ID',-552);
635: fnd_message.raise_error;
636: --
637: end if;
638: --

Line 635: fnd_message.raise_error;

631: --
632: fnd_message.set_name('BEN','BEN_91741_FORMULA_NOT_FOUND');
633: fnd_message.set_token('ID',p_access_calc_rule);
634: fnd_message.set_token('TYPE_ID',-552);
635: fnd_message.raise_error;
636: --
637: end if;
638: --
639: close c_formula;

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

703: open c1(p_col1_value_set_id);
704: fetch c1 into l_dummy;
705: if c1%notfound then
706: close c1;
707: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
708: fnd_message.set_token('VALUESET',p_col1_value_set_id);
709: fnd_message.raise_error;
710: end if;
711: close c1;

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

704: fetch c1 into l_dummy;
705: if c1%notfound then
706: close c1;
707: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
708: fnd_message.set_token('VALUESET',p_col1_value_set_id);
709: fnd_message.raise_error;
710: end if;
711: close c1;
712: --

Line 709: fnd_message.raise_error;

705: if c1%notfound then
706: close c1;
707: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
708: fnd_message.set_token('VALUESET',p_col1_value_set_id);
709: fnd_message.raise_error;
710: end if;
711: close c1;
712: --
713: end if;

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

722: open c1(p_col2_value_set_id);
723: fetch c1 into l_dummy;
724: if c1%notfound then
725: close c1;
726: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
727: fnd_message.set_token('VALUESET',p_col2_value_set_id);
728: fnd_message.raise_error;
729: end if;
730: close c1;

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

723: fetch c1 into l_dummy;
724: if c1%notfound then
725: close c1;
726: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
727: fnd_message.set_token('VALUESET',p_col2_value_set_id);
728: fnd_message.raise_error;
729: end if;
730: close c1;
731: --

Line 728: fnd_message.raise_error;

724: if c1%notfound then
725: close c1;
726: fnd_message.set_name('BEN','BEN_94132_INVALID_VALUE_SET_ID');
727: fnd_message.set_token('VALUESET',p_col2_value_set_id);
728: fnd_message.raise_error;
729: end if;
730: close c1;
731: --
732: end if;

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

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

Line 790: fnd_message.raise_error;

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

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

836: or p_access_column_name1 is not null ) )
837:
838: then
839: --
840: fnd_message.set_name('BEN','BEN_94134_ACCESS_RL_TAB_COL');
841: fnd_message.raise_error;
842: --
843: end if;
844:

Line 841: fnd_message.raise_error;

837:
838: then
839: --
840: fnd_message.set_name('BEN','BEN_94134_ACCESS_RL_TAB_COL');
841: fnd_message.raise_error;
842: --
843: end if;
844:
845: hr_utility.set_location('Leaving:'||l_proc, 10);

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

907: fetch c1 into l_table_id;
908: --
909: if c1%notfound then
910: close c1;
911: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
912: fnd_message.set_token('PROCNAME',l_proc);
913: fnd_message.raise_error;
914: --
915: else

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

908: --
909: if c1%notfound then
910: close c1;
911: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
912: fnd_message.set_token('PROCNAME',l_proc);
913: fnd_message.raise_error;
914: --
915: else
916: --

Line 913: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 921: fnd_message.raise_error;

917: if p_access_table_name1 not in ('PER_ALL_ASSIGNMENTS_F','PER_ALL_PEOPLE_F')then
918: fnd_message.set_name ('BEN','BEN_91039_INVALID_TABLE');
919: fnd_message.set_token('TABLENAME','p_access_table_name1');
920: fnd_message.set_token('PROCNAME',l_proc);
921: fnd_message.raise_error;
922: end if;
923: --
924: end if;
925: --

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

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

Line 933: fnd_message.raise_error;

929: --
930: --
931: if (p_access_table_name1 is not null and p_access_column_name1 is null) then
932: fnd_message.set_name('BEN','BEN_94433_COLUMN_REQUIRED');
933: fnd_message.raise_error;
934: end if;
935: --
936:
937: if p_access_column_name1 is not null then

Line 940: fnd_message.set_name('BEN','BEN_94432_TABLE_REQUIRED');

936:
937: if p_access_column_name1 is not null then
938: --
939: if p_access_table_name1 is null then
940: fnd_message.set_name('BEN','BEN_94432_TABLE_REQUIRED');
941: fnd_message.raise_error;
942: --
943: else
944: open c2(p_access_column_name1);

Line 941: fnd_message.raise_error;

937: if p_access_column_name1 is not null then
938: --
939: if p_access_table_name1 is null then
940: fnd_message.set_name('BEN','BEN_94432_TABLE_REQUIRED');
941: fnd_message.raise_error;
942: --
943: else
944: open c2(p_access_column_name1);
945: fetch c2 into l_dummy;

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

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

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

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

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

946: if c2%notfound then
947: close c2;
948: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
949: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
950: fnd_message.set_token('PROCNAME',l_proc);
951: fnd_message.raise_error;
952: end if;
953: --
954: close c2;

Line 951: fnd_message.raise_error;

947: close c2;
948: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
949: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
950: fnd_message.set_token('PROCNAME',l_proc);
951: fnd_message.raise_error;
952: end if;
953: --
954: close c2;
955: --

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

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

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

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

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

967: if c1%notfound then
968: close c1;
969: fnd_message.set_name('BEN','BEN_91039_INVALID_TABLE');
970: fnd_message.set_token('TABLENAME',p_access_table_name2);
971: fnd_message.set_token('PROCNAME',l_proc);
972: end if;
973: --
974: close c1;
975: --

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

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

Line 981: fnd_message.raise_error;

977: --
978: --
979: if (p_access_table_name2 is not null and p_access_column_name2 is null) then
980: fnd_message.set_name('BEN','BEN_94484_COLUMN_REQUIRED');
981: fnd_message.raise_error;
982: end if;
983: --
984:
985: if p_access_column_name2 is not null then

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

984:
985: if p_access_column_name2 is not null then
986: --
987: if p_access_table_name2 is null then
988: fnd_message.set_name('BEN','BEN_94485_TABLE_REQUIRED');
989: fnd_message.raise_error;
990: --
991: else
992: open c2(p_access_column_name2);

Line 989: fnd_message.raise_error;

985: if p_access_column_name2 is not null then
986: --
987: if p_access_table_name2 is null then
988: fnd_message.set_name('BEN','BEN_94485_TABLE_REQUIRED');
989: fnd_message.raise_error;
990: --
991: else
992: open c2(p_access_column_name2);
993: fetch c2 into l_dummy;

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

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

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

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

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

995: if c2%notfound then
996: close c2;
997: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
998: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
999: fnd_message.set_token('PROCNAME',l_proc);
1000: fnd_message.raise_error;
1001: end if;
1002: --
1003: close c2;

Line 1000: fnd_message.raise_error;

996: close c2;
997: fnd_message.set_name('BEN','BEN_91039_INVALID_COLUMN');
998: fnd_message.set_token('COLUMNNAME',p_access_column_name1);
999: fnd_message.set_token('PROCNAME',l_proc);
1000: fnd_message.raise_error;
1001: end if;
1002: --
1003: close c2;
1004: --

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

1061: --
1062: if (p_col_lookup_type is null or p_col_value_set_id is not null)
1063: then
1064: --
1065: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1066: fnd_message.raise_error;
1067: --
1068: end if;
1069: --

Line 1066: fnd_message.raise_error;

1062: if (p_col_lookup_type is null or p_col_value_set_id is not null)
1063: then
1064: --
1065: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1066: fnd_message.raise_error;
1067: --
1068: end if;
1069: --
1070: else

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

1074: --
1075: if (p_col_lookup_type is not null or p_col_value_set_id is null)
1076: then
1077: --
1078: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1079: fnd_message.raise_error;
1080: --
1081: end if;
1082: --

Line 1079: fnd_message.raise_error;

1075: if (p_col_lookup_type is not null or p_col_value_set_id is null)
1076: then
1077: --
1078: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1079: fnd_message.raise_error;
1080: --
1081: end if;
1082: --
1083: else

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

1087: --
1088: if (p_col_lookup_type is not null or p_col_value_set_id is not null or p_access_calc_rule is not null)
1089: then
1090: --
1091: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1092: fnd_message.raise_error;
1093: --
1094: else
1095: --

Line 1092: fnd_message.raise_error;

1088: if (p_col_lookup_type is not null or p_col_value_set_id is not null or p_access_calc_rule is not null)
1089: then
1090: --
1091: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1092: fnd_message.raise_error;
1093: --
1094: else
1095: --
1096: if(p_allow_range_validation_flg = 'Y')

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

1095: --
1096: if(p_allow_range_validation_flg = 'Y')
1097: then
1098: --
1099: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1100: fnd_message.raise_error;
1101: --
1102: else
1103: --

Line 1100: fnd_message.raise_error;

1096: if(p_allow_range_validation_flg = 'Y')
1097: then
1098: --
1099: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1100: fnd_message.raise_error;
1101: --
1102: else
1103: --
1104: if p_crit_col_val_type_cd ='ORG_HIER'

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

1106: --
1107: if (p_access_table_name <> 'PER_ALL_ASSIGNMENTS_F' or p_access_column_name <> 'ORGANIZATION_ID')
1108: then
1109: --
1110: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1111: fnd_message.raise_error;
1112: --
1113: end if;
1114: --

Line 1111: fnd_message.raise_error;

1107: if (p_access_table_name <> 'PER_ALL_ASSIGNMENTS_F' or p_access_column_name <> 'ORGANIZATION_ID')
1108: then
1109: --
1110: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1111: fnd_message.raise_error;
1112: --
1113: end if;
1114: --
1115: else

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

1119: --
1120: if (p_access_table_name <> 'PER_ALL_ASSIGNMENTS_F' or p_access_column_name <> 'POSITION_ID')
1121: then
1122: --
1123: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1124: fnd_message.raise_error;
1125: --
1126: end if;
1127: --

Line 1124: fnd_message.raise_error;

1120: if (p_access_table_name <> 'PER_ALL_ASSIGNMENTS_F' or p_access_column_name <> 'POSITION_ID')
1121: then
1122: --
1123: fnd_message.set_name('BEN','BEN_94137_VALID_CRIT_BASIS');
1124: fnd_message.raise_error;
1125: --
1126: end if;
1127: --
1128: end if;

Line 1149: fnd_message.set_name('BEN','BEN_94152_VAL_TYP_CD_NULL');

1145: then
1146: --
1147: -- Bug 4729818 Display Appropriate error messages for two Sets
1148: if (p_set = 1) then --signifies set 1 is being checked
1149: fnd_message.set_name('BEN','BEN_94152_VAL_TYP_CD_NULL');
1150: fnd_message.raise_error;
1151: end if;
1152:
1153: if (p_set = 2) then -- signifies set 2 is being checked

Line 1150: fnd_message.raise_error;

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

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

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

Line 1156: fnd_message.raise_error;

1152:
1153: if (p_set = 2) then -- signifies set 2 is being checked
1154: --RKG Set 2 Error Message for Bug 4729818
1155: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');
1156: fnd_message.raise_error;
1157: end if;
1158: --
1159: end if;
1160: --

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

1222: then
1223: --
1224: --Bug 4729818 Display appropriate error messages
1225: if (p_set = 1) then --signifies set 1 is being checked
1226: fnd_message.set_name('BEN','BEN_94152_VAL_TYP_CD_NULL');
1227: fnd_message.raise_error;
1228: end if;
1229:
1230: if (p_set = 2) then -- signifies set 2 is being checked

Line 1227: fnd_message.raise_error;

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

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

1228: end if;
1229:
1230: if (p_set = 2) then -- signifies set 2 is being checked
1231: --RKG Set 2 Error Message for Bug 4729818
1232: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');
1233: fnd_message.raise_error;
1234: end if;
1235: --
1236:

Line 1233: fnd_message.raise_error;

1229:
1230: if (p_set = 2) then -- signifies set 2 is being checked
1231: --RKG Set 2 Error Message for Bug 4729818
1232: fnd_message.set_name('BEN','BEN_94483_VAL_TYP_CD_NULL');
1233: fnd_message.raise_error;
1234: end if;
1235: --
1236:
1237: else

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

1250: --
1251: if chk_eligy_criteria%found then
1252: close chk_eligy_criteria;
1253: --
1254: fnd_message.set_name('BEN','BEN_94133_EGL_CHLD_RCD_EXISTS');
1255: fnd_message.raise_error;
1256: --
1257: --
1258: else

Line 1255: fnd_message.raise_error;

1251: if chk_eligy_criteria%found then
1252: close chk_eligy_criteria;
1253: --
1254: fnd_message.set_name('BEN','BEN_94133_EGL_CHLD_RCD_EXISTS');
1255: fnd_message.raise_error;
1256: --
1257: --
1258: else
1259: chk_col_val_type_cd(p_crit_col_val_type_cd => p_crit_col_val_type_cd,

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

1317: and p_access_column_name1 is null ) )
1318:
1319: then
1320: --
1321: fnd_message.set_name('BEN','BEN_94149_TAB_COL_RL_NULL');
1322: fnd_message.raise_error;
1323: --
1324: end if;
1325: --

Line 1322: fnd_message.raise_error;

1318:
1319: then
1320: --
1321: fnd_message.set_name('BEN','BEN_94149_TAB_COL_RL_NULL');
1322: fnd_message.raise_error;
1323: --
1324: end if;
1325: --
1326: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1567: fnd_message.set_name('BEN','BEN_94271_EGL_HIER_NO_SET2');

1563: -- Check for Hierarchy Criteria type, There shd not be Sub-Criteria(Set2) defined
1564: if p_rec.crit_col1_val_type_cd like '%HIER' and
1565: l_set2_empty = 'N' then
1566: --
1567: fnd_message.set_name('BEN','BEN_94271_EGL_HIER_NO_SET2');
1568: fnd_message.raise_error;
1569: --
1570: end if;
1571: --

Line 1568: fnd_message.raise_error;

1564: if p_rec.crit_col1_val_type_cd like '%HIER' and
1565: l_set2_empty = 'N' then
1566: --
1567: fnd_message.set_name('BEN','BEN_94271_EGL_HIER_NO_SET2');
1568: fnd_message.raise_error;
1569: --
1570: end if;
1571: --
1572: if(l_set2_empty = 'N') then

Line 1740: fnd_message.set_name('BEN','BEN_94271_EGL_HIER_NO_SET2');

1736: -- Check for Hierarchy Criteria type, There shd not be any Sub-Criteria defined
1737: if p_rec.crit_col1_val_type_cd like '%HIER' and
1738: l_set2_empty = 'N' then
1739: --
1740: fnd_message.set_name('BEN','BEN_94271_EGL_HIER_NO_SET2');
1741: fnd_message.raise_error;
1742: --
1743: end if;
1744: --

Line 1741: fnd_message.raise_error;

1737: if p_rec.crit_col1_val_type_cd like '%HIER' and
1738: l_set2_empty = 'N' then
1739: --
1740: fnd_message.set_name('BEN','BEN_94271_EGL_HIER_NO_SET2');
1741: fnd_message.raise_error;
1742: --
1743: end if;
1744: --
1745: if(l_set2_empty = 'N') then