298: if c_eligy_prfl%found
299: then
300: --
301: close c_eligy_prfl;
302: fnd_message.set_name('BEN', 'BEN_94139_DUP_ELIGY_CRIT_EXIST');
303: fnd_message.raise_error;
304: --
305: end if;
306: --
299: then
300: --
301: close c_eligy_prfl;
302: fnd_message.set_name('BEN', 'BEN_94139_DUP_ELIGY_CRIT_EXIST');
303: fnd_message.raise_error;
304: --
305: end if;
306: --
307: close c_eligy_prfl;
372: if c1%found
373: then
374: --
375: close c1;
376: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
377: fnd_message.raise_error;
378: --
379: end if;
380: --
373: then
374: --
375: close c1;
376: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
377: fnd_message.raise_error;
378: --
379: end if;
380: --
381: close c1;
531: ( l_crit_col1_datatype = 'C' and p_char_value1 is null ) OR
532: ( l_crit_col1_datatype = 'C' and l_allow_range_validation_flag = 'Y' and p_char_value2 is null )
533: then
534: --
535: fnd_message.set_name('BEN', 'BEN_94140_LOOKUP_VALUE_NULL');
536: fnd_message.raise_error;
537: --
538: else
539: --
532: ( l_crit_col1_datatype = 'C' and l_allow_range_validation_flag = 'Y' and p_char_value2 is null )
533: then
534: --
535: fnd_message.set_name('BEN', 'BEN_94140_LOOKUP_VALUE_NULL');
536: fnd_message.raise_error;
537: --
538: else
539: --
540: if l_crit_col1_datatype = 'N'
554: p_effective_date => p_effective_date) then
555: --
556: -- raise error as code does not exist as lookup
557: --
558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
559: fnd_message.set_token('FIELD', 'Lookup Value');
560: fnd_message.set_token('TYPE',l_col1_lookup_type);
561: fnd_message.set_token('VALUE',l_lookup_code);
562: fnd_message.raise_error;
555: --
556: -- raise error as code does not exist as lookup
557: --
558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
559: fnd_message.set_token('FIELD', 'Lookup Value');
560: fnd_message.set_token('TYPE',l_col1_lookup_type);
561: fnd_message.set_token('VALUE',l_lookup_code);
562: fnd_message.raise_error;
563: --
556: -- raise error as code does not exist as lookup
557: --
558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
559: fnd_message.set_token('FIELD', 'Lookup Value');
560: fnd_message.set_token('TYPE',l_col1_lookup_type);
561: fnd_message.set_token('VALUE',l_lookup_code);
562: fnd_message.raise_error;
563: --
564: end if;
557: --
558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
559: fnd_message.set_token('FIELD', 'Lookup Value');
560: fnd_message.set_token('TYPE',l_col1_lookup_type);
561: fnd_message.set_token('VALUE',l_lookup_code);
562: fnd_message.raise_error;
563: --
564: end if;
565: --
558: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
559: fnd_message.set_token('FIELD', 'Lookup Value');
560: fnd_message.set_token('TYPE',l_col1_lookup_type);
561: fnd_message.set_token('VALUE',l_lookup_code);
562: fnd_message.raise_error;
563: --
564: end if;
565: --
566: end if;
578: ( l_crit_col1_datatype = 'C' and p_char_value1 is null ) OR
579: ( l_crit_col1_datatype = 'C' and l_allow_range_validation_flag = 'Y' and p_char_value2 is null )
580: then
581: --
582: fnd_message.set_name('BEN', 'BEN_94141_VSET_VALUE_NULL');
583: fnd_message.raise_error;
584: --
585: end if;
586: --
579: ( l_crit_col1_datatype = 'C' and l_allow_range_validation_flag = 'Y' and p_char_value2 is null )
580: then
581: --
582: fnd_message.set_name('BEN', 'BEN_94141_VSET_VALUE_NULL');
583: fnd_message.raise_error;
584: --
585: end if;
586: --
587: --
598: ( l_crit_col2_datatype = 'C' and p_char_value3 is null ) OR
599: ( l_crit_col2_datatype = 'C' and l_allow_range_validation_flag2 = 'Y' and p_char_value4 is null )
600: then
601: --
602: fnd_message.set_name('BEN', 'BEN_94140_LOOKUP_VALUE_NULL');
603: fnd_message.raise_error;
604: --
605: else
606: --
599: ( l_crit_col2_datatype = 'C' and l_allow_range_validation_flag2 = 'Y' and p_char_value4 is null )
600: then
601: --
602: fnd_message.set_name('BEN', 'BEN_94140_LOOKUP_VALUE_NULL');
603: fnd_message.raise_error;
604: --
605: else
606: --
607: if l_crit_col2_datatype = 'N'
621: p_effective_date => p_effective_date) then
622: --
623: -- raise error as code does not exist as lookup
624: --
625: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
626: fnd_message.set_token('FIELD', 'Lookup Value');
627: fnd_message.set_token('TYPE',l_col2_lookup_type);
628: fnd_message.set_token('VALUE',l_lookup_code);
629: fnd_message.raise_error;
622: --
623: -- raise error as code does not exist as lookup
624: --
625: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
626: fnd_message.set_token('FIELD', 'Lookup Value');
627: fnd_message.set_token('TYPE',l_col2_lookup_type);
628: fnd_message.set_token('VALUE',l_lookup_code);
629: fnd_message.raise_error;
630: --
623: -- raise error as code does not exist as lookup
624: --
625: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
626: fnd_message.set_token('FIELD', 'Lookup Value');
627: fnd_message.set_token('TYPE',l_col2_lookup_type);
628: fnd_message.set_token('VALUE',l_lookup_code);
629: fnd_message.raise_error;
630: --
631: end if;
624: --
625: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
626: fnd_message.set_token('FIELD', 'Lookup Value');
627: fnd_message.set_token('TYPE',l_col2_lookup_type);
628: fnd_message.set_token('VALUE',l_lookup_code);
629: fnd_message.raise_error;
630: --
631: end if;
632: --
625: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
626: fnd_message.set_token('FIELD', 'Lookup Value');
627: fnd_message.set_token('TYPE',l_col2_lookup_type);
628: fnd_message.set_token('VALUE',l_lookup_code);
629: fnd_message.raise_error;
630: --
631: end if;
632: --
633: end if;
645: ( l_crit_col2_datatype = 'C' and p_char_value3 is null ) OR
646: ( l_crit_col2_datatype = 'C' and l_allow_range_validation_flag2 = 'Y' and p_char_value4 is null )
647: then
648: --
649: fnd_message.set_name('BEN', 'BEN_94141_VSET_VALUE_NULL');
650: fnd_message.raise_error;
651: --
652: end if;
653: --
646: ( l_crit_col2_datatype = 'C' and l_allow_range_validation_flag2 = 'Y' and p_char_value4 is null )
647: then
648: --
649: fnd_message.set_name('BEN', 'BEN_94141_VSET_VALUE_NULL');
650: fnd_message.raise_error;
651: --
652: end if;
653: --
654: end if;