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