DBA Data[Home] [Help]

APPS.BEN_DPNT_EDC_BUS dependencies on FND_MESSAGE

Line 302: fnd_message.set_name('BEN', 'BEN_94139_DUP_ELIGY_CRIT_EXIST');

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

Line 303: fnd_message.raise_error;

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;

Line 376: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

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

Line 377: fnd_message.raise_error;

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;

Line 535: fnd_message.set_name('BEN', 'BEN_94140_LOOKUP_VALUE_NULL');

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

Line 536: fnd_message.raise_error;

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'

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

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;

Line 559: fnd_message.set_token('FIELD', 'Lookup Value');

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

Line 560: fnd_message.set_token('TYPE',l_col1_lookup_type);

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;

Line 561: fnd_message.set_token('VALUE',l_lookup_code);

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

Line 562: fnd_message.raise_error;

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;

Line 582: fnd_message.set_name('BEN', 'BEN_94141_VSET_VALUE_NULL');

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

Line 583: fnd_message.raise_error;

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

Line 602: fnd_message.set_name('BEN', 'BEN_94140_LOOKUP_VALUE_NULL');

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

Line 603: fnd_message.raise_error;

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'

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

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;

Line 626: fnd_message.set_token('FIELD', 'Lookup Value');

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

Line 627: fnd_message.set_token('TYPE',l_col2_lookup_type);

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;

Line 628: fnd_message.set_token('VALUE',l_lookup_code);

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

Line 629: fnd_message.raise_error;

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;

Line 649: fnd_message.set_name('BEN', 'BEN_94141_VSET_VALUE_NULL');

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

Line 650: fnd_message.raise_error;

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;