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_ECV_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 596: fnd_message.set_name('BEN', 'BEN_94142_ORG_HIERARCHY_NULL');

592: --
593: if (p_number_value1 is null or p_number_value2 is null)
594: then
595: --
596: fnd_message.set_name('BEN', 'BEN_94142_ORG_HIERARCHY_NULL');
597: fnd_message.raise_error;
598: --
599: else
600: --

Line 597: fnd_message.raise_error;

593: if (p_number_value1 is null or p_number_value2 is null)
594: then
595: --
596: fnd_message.set_name('BEN', 'BEN_94142_ORG_HIERARCHY_NULL');
597: fnd_message.raise_error;
598: --
599: else
600: --
601: -- Validate Organization Hierarchy / Structure

Line 612: fnd_message.set_name('BEN', 'BEN_94143_INVALID_ORG_STRU_VER');

608: then
609: --
610: -- Organization Structure Version ID non-existent or inactive
611: --
612: fnd_message.set_name('BEN', 'BEN_94143_INVALID_ORG_STRU_VER');
613: fnd_message.raise_error;
614: --
615: end if;
616: --

Line 613: fnd_message.raise_error;

609: --
610: -- Organization Structure Version ID non-existent or inactive
611: --
612: fnd_message.set_name('BEN', 'BEN_94143_INVALID_ORG_STRU_VER');
613: fnd_message.raise_error;
614: --
615: end if;
616: --
617: close c_org_stru_ver;

Line 630: fnd_message.set_name('BEN', 'BEN_94144_INVALID_START_ORG');

626: then
627: --
628: -- Start Organization does not fall under selected Organization Structure / Hierarchy
629: --
630: fnd_message.set_name('BEN', 'BEN_94144_INVALID_START_ORG');
631: fnd_message.raise_error;
632: --
633: end if;
634: --

Line 631: fnd_message.raise_error;

627: --
628: -- Start Organization does not fall under selected Organization Structure / Hierarchy
629: --
630: fnd_message.set_name('BEN', 'BEN_94144_INVALID_START_ORG');
631: fnd_message.raise_error;
632: --
633: end if;
634: --
635: close c_start_org;

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

645: --
646: if (p_number_value1 is null or p_number_value2 is null)
647: then
648: --
649: fnd_message.set_name('BEN', 'BEN_94145_POS_HIERARCHY_NULL');
650: fnd_message.raise_error;
651: --
652: else
653: --

Line 650: fnd_message.raise_error;

646: if (p_number_value1 is null or p_number_value2 is null)
647: then
648: --
649: fnd_message.set_name('BEN', 'BEN_94145_POS_HIERARCHY_NULL');
650: fnd_message.raise_error;
651: --
652: else
653: --
654: -- Validate Position Hierarchy / Structure

Line 665: fnd_message.set_name('BEN', 'BEN_94146_INVALID_POS_STRU_VER');

661: then
662: --
663: -- Position Structure Version ID non-existent or inactive
664: --
665: fnd_message.set_name('BEN', 'BEN_94146_INVALID_POS_STRU_VER');
666: fnd_message.raise_error;
667: --
668: end if;
669: --

Line 666: fnd_message.raise_error;

662: --
663: -- Position Structure Version ID non-existent or inactive
664: --
665: fnd_message.set_name('BEN', 'BEN_94146_INVALID_POS_STRU_VER');
666: fnd_message.raise_error;
667: --
668: end if;
669: --
670: close c_pos_stru_ver;

Line 683: fnd_message.set_name('BEN', 'BEN_94147_INVALID_START_POS');

679: then
680: --
681: -- Start Position does not fall under selected Position Structure / Hierarchy
682: --
683: fnd_message.set_name('BEN', 'BEN_94147_INVALID_START_POS');
684: fnd_message.raise_error;
685: --
686: end if;
687: --

Line 684: fnd_message.raise_error;

680: --
681: -- Start Position does not fall under selected Position Structure / Hierarchy
682: --
683: fnd_message.set_name('BEN', 'BEN_94147_INVALID_START_POS');
684: fnd_message.raise_error;
685: --
686: end if;
687: --
688: close c_start_pos;

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

702: ( l_crit_col2_datatype = 'C' and p_char_value3 is null ) OR
703: ( l_crit_col2_datatype = 'C' and l_allow_range_validation_flag2 = 'Y' and p_char_value4 is null )
704: then
705: --
706: fnd_message.set_name('BEN', 'BEN_94140_LOOKUP_VALUE_NULL');
707: fnd_message.raise_error;
708: --
709: else
710: --

Line 707: fnd_message.raise_error;

703: ( l_crit_col2_datatype = 'C' and l_allow_range_validation_flag2 = 'Y' and p_char_value4 is null )
704: then
705: --
706: fnd_message.set_name('BEN', 'BEN_94140_LOOKUP_VALUE_NULL');
707: fnd_message.raise_error;
708: --
709: else
710: --
711: if l_crit_col2_datatype = 'N'

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

725: p_effective_date => p_effective_date) then
726: --
727: -- raise error as code does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD', 'Lookup Value');
731: fnd_message.set_token('TYPE',l_col2_lookup_type);
732: fnd_message.set_token('VALUE',l_lookup_code);
733: fnd_message.raise_error;

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

726: --
727: -- raise error as code does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD', 'Lookup Value');
731: fnd_message.set_token('TYPE',l_col2_lookup_type);
732: fnd_message.set_token('VALUE',l_lookup_code);
733: fnd_message.raise_error;
734: --

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

727: -- raise error as code does not exist as lookup
728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD', 'Lookup Value');
731: fnd_message.set_token('TYPE',l_col2_lookup_type);
732: fnd_message.set_token('VALUE',l_lookup_code);
733: fnd_message.raise_error;
734: --
735: end if;

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

728: --
729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD', 'Lookup Value');
731: fnd_message.set_token('TYPE',l_col2_lookup_type);
732: fnd_message.set_token('VALUE',l_lookup_code);
733: fnd_message.raise_error;
734: --
735: end if;
736: --

Line 733: fnd_message.raise_error;

729: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
730: fnd_message.set_token('FIELD', 'Lookup Value');
731: fnd_message.set_token('TYPE',l_col2_lookup_type);
732: fnd_message.set_token('VALUE',l_lookup_code);
733: fnd_message.raise_error;
734: --
735: end if;
736: --
737: end if;

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

749: ( l_crit_col2_datatype = 'C' and p_char_value3 is null ) OR
750: ( l_crit_col2_datatype = 'C' and l_allow_range_validation_flag2 = 'Y' and p_char_value4 is null )
751: then
752: --
753: fnd_message.set_name('BEN', 'BEN_94141_VSET_VALUE_NULL');
754: fnd_message.raise_error;
755: --
756: end if;
757: --

Line 754: fnd_message.raise_error;

750: ( l_crit_col2_datatype = 'C' and l_allow_range_validation_flag2 = 'Y' and p_char_value4 is null )
751: then
752: --
753: fnd_message.set_name('BEN', 'BEN_94141_VSET_VALUE_NULL');
754: fnd_message.raise_error;
755: --
756: end if;
757: --
758: --

Line 767: fnd_message.set_name('BEN', 'BEN_94142_ORG_HIERARCHY_NULL');

763: --
764: if (p_number_value3 is null or p_number_value4 is null)
765: then
766: --
767: fnd_message.set_name('BEN', 'BEN_94142_ORG_HIERARCHY_NULL');
768: fnd_message.raise_error;
769: --
770: else
771: --

Line 768: fnd_message.raise_error;

764: if (p_number_value3 is null or p_number_value4 is null)
765: then
766: --
767: fnd_message.set_name('BEN', 'BEN_94142_ORG_HIERARCHY_NULL');
768: fnd_message.raise_error;
769: --
770: else
771: --
772: -- Validate Organization Hierarchy / Structure

Line 783: fnd_message.set_name('BEN', 'BEN_94143_INVALID_ORG_STRU_VER');

779: then
780: --
781: -- Organization Structure Version ID non-existent or inactive
782: --
783: fnd_message.set_name('BEN', 'BEN_94143_INVALID_ORG_STRU_VER');
784: fnd_message.raise_error;
785: --
786: end if;
787: --

Line 784: fnd_message.raise_error;

780: --
781: -- Organization Structure Version ID non-existent or inactive
782: --
783: fnd_message.set_name('BEN', 'BEN_94143_INVALID_ORG_STRU_VER');
784: fnd_message.raise_error;
785: --
786: end if;
787: --
788: close c_org_stru_ver2;

Line 801: fnd_message.set_name('BEN', 'BEN_94144_INVALID_START_ORG');

797: then
798: --
799: -- Start Organization does not fall under selected Organization Structure / Hierarchy
800: --
801: fnd_message.set_name('BEN', 'BEN_94144_INVALID_START_ORG');
802: fnd_message.raise_error;
803: --
804: end if;
805: --

Line 802: fnd_message.raise_error;

798: --
799: -- Start Organization does not fall under selected Organization Structure / Hierarchy
800: --
801: fnd_message.set_name('BEN', 'BEN_94144_INVALID_START_ORG');
802: fnd_message.raise_error;
803: --
804: end if;
805: --
806: close c_start_org2;

Line 820: fnd_message.set_name('BEN', 'BEN_94145_POS_HIERARCHY_NULL');

816: --
817: if (p_number_value3 is null or p_number_value4 is null)
818: then
819: --
820: fnd_message.set_name('BEN', 'BEN_94145_POS_HIERARCHY_NULL');
821: fnd_message.raise_error;
822: --
823: else
824: --

Line 821: fnd_message.raise_error;

817: if (p_number_value3 is null or p_number_value4 is null)
818: then
819: --
820: fnd_message.set_name('BEN', 'BEN_94145_POS_HIERARCHY_NULL');
821: fnd_message.raise_error;
822: --
823: else
824: --
825: -- Validate Position Hierarchy / Structure

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

832: then
833: --
834: -- Position Structure Version ID non-existent or inactive
835: --
836: fnd_message.set_name('BEN', 'BEN_94146_INVALID_POS_STRU_VER');
837: fnd_message.raise_error;
838: --
839: end if;
840: --

Line 837: fnd_message.raise_error;

833: --
834: -- Position Structure Version ID non-existent or inactive
835: --
836: fnd_message.set_name('BEN', 'BEN_94146_INVALID_POS_STRU_VER');
837: fnd_message.raise_error;
838: --
839: end if;
840: --
841: close c_pos_stru_ver2;

Line 854: fnd_message.set_name('BEN', 'BEN_94147_INVALID_START_POS');

850: then
851: --
852: -- Start Position does not fall under selected Position Structure / Hierarchy
853: --
854: fnd_message.set_name('BEN', 'BEN_94147_INVALID_START_POS');
855: fnd_message.raise_error;
856: --
857: end if;
858: --

Line 855: fnd_message.raise_error;

851: --
852: -- Start Position does not fall under selected Position Structure / Hierarchy
853: --
854: fnd_message.set_name('BEN', 'BEN_94147_INVALID_START_POS');
855: fnd_message.raise_error;
856: --
857: end if;
858: --
859: close c_start_pos2;