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.PAY_ETP_BUS_ND dependencies on FND_MESSAGE

Line 60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'ELEMENT_TYPE_ID')
64: );

Line 137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --

Line 138: fnd_message.raise_error;

134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are

Line 474: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

470: (p_element_type_id => p_rec.element_type_id
471: ,p_effective_date => p_effective_date
472: ,p_object_version_number => p_rec.object_version_number
473: ) THEN
474: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
475: fnd_message.set_token('PROCEDURE ', l_proc);
476: fnd_message.set_token('STEP ', '5');
477: fnd_message.raise_error;
478: END IF;

Line 475: fnd_message.set_token('PROCEDURE ', l_proc);

471: ,p_effective_date => p_effective_date
472: ,p_object_version_number => p_rec.object_version_number
473: ) THEN
474: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
475: fnd_message.set_token('PROCEDURE ', l_proc);
476: fnd_message.set_token('STEP ', '5');
477: fnd_message.raise_error;
478: END IF;
479: --

Line 476: fnd_message.set_token('STEP ', '5');

472: ,p_object_version_number => p_rec.object_version_number
473: ) THEN
474: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
475: fnd_message.set_token('PROCEDURE ', l_proc);
476: fnd_message.set_token('STEP ', '5');
477: fnd_message.raise_error;
478: END IF;
479: --
480: End chk_non_updateable_args;

Line 477: fnd_message.raise_error;

473: ) THEN
474: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
475: fnd_message.set_token('PROCEDURE ', l_proc);
476: fnd_message.set_token('STEP ', '5');
477: fnd_message.raise_error;
478: END IF;
479: --
480: End chk_non_updateable_args;
481: --

Line 553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

549: --
550: -- An unhandled or unexpected error has occurred which
551: -- we must report
552: --
553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
554: fnd_message.set_token('PROCEDURE', l_proc);
555: fnd_message.set_token('STEP','15');
556: fnd_message.raise_error;
557: End dt_update_validate;

Line 554: fnd_message.set_token('PROCEDURE', l_proc);

550: -- An unhandled or unexpected error has occurred which
551: -- we must report
552: --
553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
554: fnd_message.set_token('PROCEDURE', l_proc);
555: fnd_message.set_token('STEP','15');
556: fnd_message.raise_error;
557: End dt_update_validate;
558: --

Line 555: fnd_message.set_token('STEP','15');

551: -- we must report
552: --
553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
554: fnd_message.set_token('PROCEDURE', l_proc);
555: fnd_message.set_token('STEP','15');
556: fnd_message.raise_error;
557: End dt_update_validate;
558: --
559: -- ----------------------------------------------------------------------------

Line 556: fnd_message.raise_error;

552: --
553: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
554: fnd_message.set_token('PROCEDURE', l_proc);
555: fnd_message.set_token('STEP','15');
556: fnd_message.raise_error;
557: End dt_update_validate;
558: --
559: -- ----------------------------------------------------------------------------
560: -- |--------------------------< dt_delete_validate >--------------------------|

Line 647: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');

643: ,p_base_key_value => p_element_type_id
644: ,p_from_date => p_validation_start_date
645: ,p_to_date => p_validation_end_date
646: )) Then
647: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
648: fnd_message.set_token('TABLE_NAME','input values');
649: hr_multi_message.add;
650: End If;
651: If (dt_api.rows_exist

Line 648: fnd_message.set_token('TABLE_NAME','input values');

644: ,p_from_date => p_validation_start_date
645: ,p_to_date => p_validation_end_date
646: )) Then
647: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
648: fnd_message.set_token('TABLE_NAME','input values');
649: hr_multi_message.add;
650: End If;
651: If (dt_api.rows_exist
652: (p_base_table_name => 'ben_acty_base_rt_f'

Line 658: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');

654: ,p_base_key_value => p_element_type_id
655: ,p_from_date => p_validation_start_date
656: ,p_to_date => p_validation_end_date
657: )) Then
658: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
659: fnd_message.set_token('TABLE_NAME','acty base rt');
660: hr_multi_message.add;
661: End If;
662: If (dt_api.rows_exist

Line 659: fnd_message.set_token('TABLE_NAME','acty base rt');

655: ,p_from_date => p_validation_start_date
656: ,p_to_date => p_validation_end_date
657: )) Then
658: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
659: fnd_message.set_token('TABLE_NAME','acty base rt');
660: hr_multi_message.add;
661: End If;
662: If (dt_api.rows_exist
663: (p_base_table_name => 'pay_element_links_f'

Line 669: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');

665: ,p_base_key_value => p_element_type_id
666: ,p_from_date => p_validation_start_date
667: ,p_to_date => p_validation_end_date
668: )) Then
669: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
670: fnd_message.set_token('TABLE_NAME','element links');
671: hr_multi_message.add;
672: End If;
673: If (dt_api.rows_exist

Line 670: fnd_message.set_token('TABLE_NAME','element links');

666: ,p_from_date => p_validation_start_date
667: ,p_to_date => p_validation_end_date
668: )) Then
669: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
670: fnd_message.set_token('TABLE_NAME','element links');
671: hr_multi_message.add;
672: End If;
673: If (dt_api.rows_exist
674: (p_base_table_name => 'pay_element_type_usages_f'

Line 680: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');

676: ,p_base_key_value => p_element_type_id
677: ,p_from_date => p_validation_start_date
678: ,p_to_date => p_validation_end_date
679: )) Then
680: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
681: fnd_message.set_token('TABLE_NAME','element type usages');
682: hr_multi_message.add;
683: End If;
684: --

Line 681: fnd_message.set_token('TABLE_NAME','element type usages');

677: ,p_from_date => p_validation_start_date
678: ,p_to_date => p_validation_end_date
679: )) Then
680: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
681: fnd_message.set_token('TABLE_NAME','element type usages');
682: hr_multi_message.add;
683: End If;
684: --
685: End If;

Line 693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

689: --
690: -- An unhandled or unexpected error has occurred which
691: -- we must report
692: --
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE', l_proc);
695: fnd_message.set_token('STEP','15');
696: fnd_message.raise_error;
697: --

Line 694: fnd_message.set_token('PROCEDURE', l_proc);

690: -- An unhandled or unexpected error has occurred which
691: -- we must report
692: --
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE', l_proc);
695: fnd_message.set_token('STEP','15');
696: fnd_message.raise_error;
697: --
698: End dt_delete_validate;

Line 695: fnd_message.set_token('STEP','15');

691: -- we must report
692: --
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE', l_proc);
695: fnd_message.set_token('STEP','15');
696: fnd_message.raise_error;
697: --
698: End dt_delete_validate;
699: --

Line 696: fnd_message.raise_error;

692: --
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE', l_proc);
695: fnd_message.set_token('STEP','15');
696: fnd_message.raise_error;
697: --
698: End dt_delete_validate;
699: --
700: -- ----------------------------------------------------------------------------

Line 773: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

769: Fetch c_chk_bg_id into l_exists;
770: If c_chk_bg_id%notfound Then
771: --
772: Close c_chk_bg_id;
773: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
774: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');
775: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
776: fnd_message.raise_error;
777: --

Line 774: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');

770: If c_chk_bg_id%notfound Then
771: --
772: Close c_chk_bg_id;
773: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
774: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');
775: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
776: fnd_message.raise_error;
777: --
778: End If;

Line 775: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');

771: --
772: Close c_chk_bg_id;
773: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
774: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');
775: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
776: fnd_message.raise_error;
777: --
778: End If;
779: Close c_chk_bg_id;

Line 776: fnd_message.raise_error;

772: Close c_chk_bg_id;
773: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
774: fnd_message.set_token('COLUMN','BUSINESS_GROUP_ID');
775: fnd_message.set_token('TABLE','HR_ORGANIZATION_UNITS');
776: fnd_message.raise_error;
777: --
778: End If;
779: Close c_chk_bg_id;
780: --

Line 815: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

811: Fetch c_chk_leg_code into l_exists;
812: If c_chk_leg_code%notfound Then
813: --
814: Close c_chk_leg_code;
815: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
816: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
817: fnd_message.set_token('TABLE','FND_TERRITORIES');
818: fnd_message.raise_error;
819: --

Line 816: fnd_message.set_token('COLUMN','LEGISLATION_CODE');

812: If c_chk_leg_code%notfound Then
813: --
814: Close c_chk_leg_code;
815: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
816: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
817: fnd_message.set_token('TABLE','FND_TERRITORIES');
818: fnd_message.raise_error;
819: --
820: End If;

Line 817: fnd_message.set_token('TABLE','FND_TERRITORIES');

813: --
814: Close c_chk_leg_code;
815: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
816: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
817: fnd_message.set_token('TABLE','FND_TERRITORIES');
818: fnd_message.raise_error;
819: --
820: End If;
821: Close c_chk_leg_code;

Line 818: fnd_message.raise_error;

814: Close c_chk_leg_code;
815: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
816: fnd_message.set_token('COLUMN','LEGISLATION_CODE');
817: fnd_message.set_token('TABLE','FND_TERRITORIES');
818: fnd_message.raise_error;
819: --
820: End If;
821: Close c_chk_leg_code;
822:

Line 898: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

894: ,p_from_date => p_validation_start_date
895: ,p_to_date => p_validation_end_date
896: )) Then
897: --
898: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
899: fnd_message.set_token('COLUMN','FORMULA_ID');
900: fnd_message.set_token('TABLE','FF_FORMULAS_F');
901: fnd_message.raise_error;
902: --

Line 899: fnd_message.set_token('COLUMN','FORMULA_ID');

895: ,p_to_date => p_validation_end_date
896: )) Then
897: --
898: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
899: fnd_message.set_token('COLUMN','FORMULA_ID');
900: fnd_message.set_token('TABLE','FF_FORMULAS_F');
901: fnd_message.raise_error;
902: --
903: End If;

Line 900: fnd_message.set_token('TABLE','FF_FORMULAS_F');

896: )) Then
897: --
898: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
899: fnd_message.set_token('COLUMN','FORMULA_ID');
900: fnd_message.set_token('TABLE','FF_FORMULAS_F');
901: fnd_message.raise_error;
902: --
903: End If;
904: --

Line 901: fnd_message.raise_error;

897: --
898: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
899: fnd_message.set_token('COLUMN','FORMULA_ID');
900: fnd_message.set_token('TABLE','FF_FORMULAS_F');
901: fnd_message.raise_error;
902: --
903: End If;
904: --
905: If (p_process_in_run_flag = 'N' or

Line 909: fnd_message.set_name('PAY','HR_6951_PAY_ELE_NO_SKIP_RULE');

905: If (p_process_in_run_flag = 'N' or
906: p_indirect_only_flag = 'Y' or
907: p_adjustment_only_flag = 'Y') Then
908: --
909: fnd_message.set_name('PAY','HR_6951_PAY_ELE_NO_SKIP_RULE');
910: fnd_message.raise_error;
911: --
912: End If;
913: --

Line 910: fnd_message.raise_error;

906: p_indirect_only_flag = 'Y' or
907: p_adjustment_only_flag = 'Y') Then
908: --
909: fnd_message.set_name('PAY','HR_6951_PAY_ELE_NO_SKIP_RULE');
910: fnd_message.raise_error;
911: --
912: End If;
913: --
914: Open c_chk_formula_type;

Line 919: fnd_message.set_name('PAY','PAY_34130_ELE_FTYPE_INVALID');

915: Fetch c_chk_formula_type into l_exists;
916: If c_chk_formula_type%notfound Then
917: --
918: Close c_chk_formula_type;
919: fnd_message.set_name('PAY','PAY_34130_ELE_FTYPE_INVALID');
920: fnd_message.raise_error;
921: --
922: End If;
923: Close c_chk_formula_type;

Line 920: fnd_message.raise_error;

916: If c_chk_formula_type%notfound Then
917: --
918: Close c_chk_formula_type;
919: fnd_message.set_name('PAY','PAY_34130_ELE_FTYPE_INVALID');
920: fnd_message.raise_error;
921: --
922: End If;
923: Close c_chk_formula_type;
924: End If;

Line 1011: fnd_message.set_name('PAY','PAY_34131_ELE_CURR_REQD1');

1007: --
1008: If (l_non_payments_flag = 'N' and
1009: (p_input_currency_code is null or p_output_currency_code is null)) Then
1010: --
1011: fnd_message.set_name('PAY','PAY_34131_ELE_CURR_REQD1');
1012: fnd_message.raise_error;
1013: --
1014: End If;
1015: --

Line 1012: fnd_message.raise_error;

1008: If (l_non_payments_flag = 'N' and
1009: (p_input_currency_code is null or p_output_currency_code is null)) Then
1010: --
1011: fnd_message.set_name('PAY','PAY_34131_ELE_CURR_REQD1');
1012: fnd_message.raise_error;
1013: --
1014: End If;
1015: --
1016: If (p_input_currency_code is not null and p_output_currency_code is null

Line 1021: fnd_message.set_name('PAY','PAY_34150_ELE_CURR_REQD2');

1017: or
1018: p_input_currency_code is null and p_output_currency_code is not null
1019: ) Then
1020: --
1021: fnd_message.set_name('PAY','PAY_34150_ELE_CURR_REQD2');
1022: fnd_message.raise_error;
1023: --
1024: End If;
1025: --

Line 1022: fnd_message.raise_error;

1018: p_input_currency_code is null and p_output_currency_code is not null
1019: ) Then
1020: --
1021: fnd_message.set_name('PAY','PAY_34150_ELE_CURR_REQD2');
1022: fnd_message.raise_error;
1023: --
1024: End If;
1025: --
1026: If p_input_currency_code is not null Then

Line 1033: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');

1029: Fetch c_chk_currency into l_exists;
1030: If c_chk_currency%notfound Then
1031: --
1032: Close c_chk_currency;
1033: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
1034: fnd_message.raise_error;
1035: --
1036: End If;
1037: Close c_chk_currency;

Line 1034: fnd_message.raise_error;

1030: If c_chk_currency%notfound Then
1031: --
1032: Close c_chk_currency;
1033: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
1034: fnd_message.raise_error;
1035: --
1036: End If;
1037: Close c_chk_currency;
1038: --

Line 1048: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');

1044: Fetch c_chk_currency into l_exists;
1045: If c_chk_currency%notfound Then
1046: --
1047: Close c_chk_currency;
1048: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
1049: fnd_message.raise_error;
1050: --
1051: End If;
1052: Close c_chk_currency;

Line 1049: fnd_message.raise_error;

1045: If c_chk_currency%notfound Then
1046: --
1047: Close c_chk_currency;
1048: fnd_message.set_name('PAY','HR_51855_QUA_CCY_INV');
1049: fnd_message.raise_error;
1050: --
1051: End If;
1052: Close c_chk_currency;
1053: --

Line 1063: fnd_message.set_name('PAY','PAY_34152_ELE_INVALID_CURR');

1059: Fetch c_leg_rule_currency into l_rule_mode;
1060: If c_leg_rule_currency%found Then
1061: If p_output_currency_code <> l_rule_mode then
1062: Close c_leg_rule_currency;
1063: fnd_message.set_name('PAY','PAY_34152_ELE_INVALID_CURR');
1064: fnd_message.raise_error;
1065: End If;
1066: End if;
1067: Close c_leg_rule_currency;

Line 1064: fnd_message.raise_error;

1060: If c_leg_rule_currency%found Then
1061: If p_output_currency_code <> l_rule_mode then
1062: Close c_leg_rule_currency;
1063: fnd_message.set_name('PAY','PAY_34152_ELE_INVALID_CURR');
1064: fnd_message.raise_error;
1065: End If;
1066: End if;
1067: Close c_leg_rule_currency;
1068: --

Line 1137: fnd_message.set_name('PAY','PAY_34132_ELE_CLASS_VLDTN');

1133: p_processing_type <> 'N' or
1134: p_indirect_only_flag <> 'N') Then
1135: --
1136: Close c_get_class_bal_init;
1137: fnd_message.set_name('PAY','PAY_34132_ELE_CLASS_VLDTN');
1138: fnd_message.raise_error;
1139: --
1140: End If;
1141: End If;

Line 1138: fnd_message.raise_error;

1134: p_indirect_only_flag <> 'N') Then
1135: --
1136: Close c_get_class_bal_init;
1137: fnd_message.set_name('PAY','PAY_34132_ELE_CLASS_VLDTN');
1138: fnd_message.raise_error;
1139: --
1140: End If;
1141: End If;
1142: Close c_get_class_bal_init;

Line 1192: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1188: (p_effective_date
1189: ,'YES_NO'
1190: ,p_addl_entry_allowed_flag) Then
1191: --
1192: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1193: fnd_message.set_token('COLUMN','ADDITIONAL_ENTRY_ALLOWED_FLAG');
1194: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1195: fnd_message.raise_error;
1196: --

Line 1193: fnd_message.set_token('COLUMN','ADDITIONAL_ENTRY_ALLOWED_FLAG');

1189: ,'YES_NO'
1190: ,p_addl_entry_allowed_flag) Then
1191: --
1192: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1193: fnd_message.set_token('COLUMN','ADDITIONAL_ENTRY_ALLOWED_FLAG');
1194: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1195: fnd_message.raise_error;
1196: --
1197: End If;

Line 1194: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1190: ,p_addl_entry_allowed_flag) Then
1191: --
1192: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1193: fnd_message.set_token('COLUMN','ADDITIONAL_ENTRY_ALLOWED_FLAG');
1194: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1195: fnd_message.raise_error;
1196: --
1197: End If;
1198: --

Line 1195: fnd_message.raise_error;

1191: --
1192: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1193: fnd_message.set_token('COLUMN','ADDITIONAL_ENTRY_ALLOWED_FLAG');
1194: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1195: fnd_message.raise_error;
1196: --
1197: End If;
1198: --
1199: If (p_addl_entry_allowed_flag = 'Y' and p_processing_type = 'N') Then

Line 1201: fnd_message.set_name('PAY','PAY_6142_ELEMENT_NO_ADD_ENTRY');

1197: End If;
1198: --
1199: If (p_addl_entry_allowed_flag = 'Y' and p_processing_type = 'N') Then
1200: --
1201: fnd_message.set_name('PAY','PAY_6142_ELEMENT_NO_ADD_ENTRY');
1202: fnd_message.raise_error;
1203: --
1204: End If;
1205: --

Line 1202: fnd_message.raise_error;

1198: --
1199: If (p_addl_entry_allowed_flag = 'Y' and p_processing_type = 'N') Then
1200: --
1201: fnd_message.set_name('PAY','PAY_6142_ELEMENT_NO_ADD_ENTRY');
1202: fnd_message.raise_error;
1203: --
1204: End If;
1205: --
1206: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1259: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1255: (p_effective_date
1256: ,'YES_NO'
1257: ,p_adjustment_only_flag) Then
1258: --
1259: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1260: fnd_message.set_token('COLUMN','ADJUSTMENT_ONLY_FLAG');
1261: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1262: fnd_message.raise_error;
1263: --

Line 1260: fnd_message.set_token('COLUMN','ADJUSTMENT_ONLY_FLAG');

1256: ,'YES_NO'
1257: ,p_adjustment_only_flag) Then
1258: --
1259: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1260: fnd_message.set_token('COLUMN','ADJUSTMENT_ONLY_FLAG');
1261: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1262: fnd_message.raise_error;
1263: --
1264: End If;

Line 1261: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1257: ,p_adjustment_only_flag) Then
1258: --
1259: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1260: fnd_message.set_token('COLUMN','ADJUSTMENT_ONLY_FLAG');
1261: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1262: fnd_message.raise_error;
1263: --
1264: End If;
1265: --

Line 1262: fnd_message.raise_error;

1258: --
1259: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1260: fnd_message.set_token('COLUMN','ADJUSTMENT_ONLY_FLAG');
1261: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1262: fnd_message.raise_error;
1263: --
1264: End If;
1265: --
1266: If hr_api.not_exists_in_hr_lookups

Line 1271: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1267: (p_effective_date
1268: ,'YES_NO'
1269: ,p_closed_for_entry_flag) Then
1270: --
1271: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1272: fnd_message.set_token('COLUMN','CLOSED_FOR_ENTRY_FLAG');
1273: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1274: fnd_message.raise_error;
1275: --

Line 1272: fnd_message.set_token('COLUMN','CLOSED_FOR_ENTRY_FLAG');

1268: ,'YES_NO'
1269: ,p_closed_for_entry_flag) Then
1270: --
1271: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1272: fnd_message.set_token('COLUMN','CLOSED_FOR_ENTRY_FLAG');
1273: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1274: fnd_message.raise_error;
1275: --
1276: End If;

Line 1273: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1269: ,p_closed_for_entry_flag) Then
1270: --
1271: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1272: fnd_message.set_token('COLUMN','CLOSED_FOR_ENTRY_FLAG');
1273: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1274: fnd_message.raise_error;
1275: --
1276: End If;
1277: --

Line 1274: fnd_message.raise_error;

1270: --
1271: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1272: fnd_message.set_token('COLUMN','CLOSED_FOR_ENTRY_FLAG');
1273: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1274: fnd_message.raise_error;
1275: --
1276: End If;
1277: --
1278: If (p_adjustment_only_flag = 'Y' and p_processing_type = 'R') Then

Line 1280: fnd_message.set_name('PAY','PAY_6712_ELEMENT_NO_REC_ADJ');

1276: End If;
1277: --
1278: If (p_adjustment_only_flag = 'Y' and p_processing_type = 'R') Then
1279: --
1280: fnd_message.set_name('PAY','PAY_6712_ELEMENT_NO_REC_ADJ');
1281: fnd_message.raise_error;
1282: --
1283: End If;
1284: --

Line 1281: fnd_message.raise_error;

1277: --
1278: If (p_adjustment_only_flag = 'Y' and p_processing_type = 'R') Then
1279: --
1280: fnd_message.set_name('PAY','PAY_6712_ELEMENT_NO_REC_ADJ');
1281: fnd_message.raise_error;
1282: --
1283: End If;
1284: --
1285: If (p_adjustment_only_flag = 'Y' and p_indirect_only_flag = 'Y') Then

Line 1287: fnd_message.set_name('PAY','PAY_34133_ELE_ADJ_INDIRECT');

1283: End If;
1284: --
1285: If (p_adjustment_only_flag = 'Y' and p_indirect_only_flag = 'Y') Then
1286: --
1287: fnd_message.set_name('PAY','PAY_34133_ELE_ADJ_INDIRECT');
1288: fnd_message.raise_error;
1289: --
1290: End If;
1291: --

Line 1288: fnd_message.raise_error;

1284: --
1285: If (p_adjustment_only_flag = 'Y' and p_indirect_only_flag = 'Y') Then
1286: --
1287: fnd_message.set_name('PAY','PAY_34133_ELE_ADJ_INDIRECT');
1288: fnd_message.raise_error;
1289: --
1290: End If;
1291: --
1292: If (p_processing_type = 'R' and p_indirect_only_flag = 'Y') Then

Line 1294: fnd_message.set_name('PAY','PAY_6707_ELEMENT_NO_REC_IND');

1290: End If;
1291: --
1292: If (p_processing_type = 'R' and p_indirect_only_flag = 'Y') Then
1293: --
1294: fnd_message.set_name('PAY','PAY_6707_ELEMENT_NO_REC_IND');
1295: fnd_message.raise_error;
1296: --
1297: End If;
1298: --

Line 1295: fnd_message.raise_error;

1291: --
1292: If (p_processing_type = 'R' and p_indirect_only_flag = 'Y') Then
1293: --
1294: fnd_message.set_name('PAY','PAY_6707_ELEMENT_NO_REC_IND');
1295: fnd_message.raise_error;
1296: --
1297: End If;
1298: --
1299: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1357: fnd_message.set_name('PAY','PAY_6137_ELEMENT_DUP_NAME');

1353: ,p_legislation_code => p_legislation_code
1354: ,p_error_if_true => FALSE
1355: ) Then
1356: --
1357: fnd_message.set_name('PAY','PAY_6137_ELEMENT_DUP_NAME');
1358: fnd_message.raise_error;
1359: --
1360: End If;
1361: --

Line 1358: fnd_message.raise_error;

1354: ,p_error_if_true => FALSE
1355: ) Then
1356: --
1357: fnd_message.set_name('PAY','PAY_6137_ELEMENT_DUP_NAME');
1358: fnd_message.raise_error;
1359: --
1360: End If;
1361: --
1362: Begin

Line 1377: fnd_message.set_name('PAY','PAY_6365_ELEMENT_NO_DB_NAME');

1373: l_checkformat_error := True;
1374: End;
1375: If (l_checkformat_error) then
1376: --
1377: fnd_message.set_name('PAY','PAY_6365_ELEMENT_NO_DB_NAME');
1378: fnd_message.raise_error;
1379: --
1380: End If;
1381: --

Line 1378: fnd_message.raise_error;

1374: End;
1375: If (l_checkformat_error) then
1376: --
1377: fnd_message.set_name('PAY','PAY_6365_ELEMENT_NO_DB_NAME');
1378: fnd_message.raise_error;
1379: --
1380: End If;
1381: --
1382: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1450: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1446: (p_effective_date
1447: ,'YES_NO'
1448: ,p_multiple_entries_allowed_flg) Then
1449: --
1450: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1451: fnd_message.set_token('COLUMN','MULTIPLE_ENTRIES_ALLOWED_FLAG');
1452: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1453: fnd_message.raise_error;
1454: --

Line 1451: fnd_message.set_token('COLUMN','MULTIPLE_ENTRIES_ALLOWED_FLAG');

1447: ,'YES_NO'
1448: ,p_multiple_entries_allowed_flg) Then
1449: --
1450: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1451: fnd_message.set_token('COLUMN','MULTIPLE_ENTRIES_ALLOWED_FLAG');
1452: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1453: fnd_message.raise_error;
1454: --
1455: End If;

Line 1452: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1448: ,p_multiple_entries_allowed_flg) Then
1449: --
1450: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1451: fnd_message.set_token('COLUMN','MULTIPLE_ENTRIES_ALLOWED_FLAG');
1452: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1453: fnd_message.raise_error;
1454: --
1455: End If;
1456: --

Line 1453: fnd_message.raise_error;

1449: --
1450: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1451: fnd_message.set_token('COLUMN','MULTIPLE_ENTRIES_ALLOWED_FLAG');
1452: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1453: fnd_message.raise_error;
1454: --
1455: End If;
1456: --
1457: Open c_chk_ben_cobra_flag;

Line 1463: fnd_message.set_name('PAY','PAY_6964_ELEMENT_COBRA_MULTI');

1459: Close c_chk_ben_cobra_flag;
1460: If (p_multiple_entries_allowed_flg = 'Y' and p_processing_type = 'R'
1461: and l_exists is not null) Then
1462: --
1463: fnd_message.set_name('PAY','PAY_6964_ELEMENT_COBRA_MULTI');
1464: fnd_message.raise_error;
1465: --
1466: End If;
1467: If p_element_type_id is not null and

Line 1464: fnd_message.raise_error;

1460: If (p_multiple_entries_allowed_flg = 'Y' and p_processing_type = 'R'
1461: and l_exists is not null) Then
1462: --
1463: fnd_message.set_name('PAY','PAY_6964_ELEMENT_COBRA_MULTI');
1464: fnd_message.raise_error;
1465: --
1466: End If;
1467: If p_element_type_id is not null and
1468: (p_multiple_entries_allowed_flg <>

Line 1476: fnd_message.set_name('PAY','HR_6953_PAY_ELE_NO_STOP_ENTRY');

1472: (p_element_type_id
1473: ,p_validation_start_date
1474: ,p_validation_end_date) Then
1475: --
1476: fnd_message.set_name('PAY','HR_6953_PAY_ELE_NO_STOP_ENTRY');
1477: fnd_message.raise_error;
1478: --
1479: End If;
1480: If pay_element_types_pkg.update_recurring_rules_exist

Line 1477: fnd_message.raise_error;

1473: ,p_validation_start_date
1474: ,p_validation_end_date) Then
1475: --
1476: fnd_message.set_name('PAY','HR_6953_PAY_ELE_NO_STOP_ENTRY');
1477: fnd_message.raise_error;
1478: --
1479: End If;
1480: If pay_element_types_pkg.update_recurring_rules_exist
1481: (p_element_type_id

Line 1485: fnd_message.set_name('PAY','HR_6953_PAY_ELE_NO_STOP_ENTRY');

1481: (p_element_type_id
1482: ,p_validation_start_date
1483: ,p_validation_end_date) Then
1484: --
1485: fnd_message.set_name('PAY','HR_6953_PAY_ELE_NO_STOP_ENTRY');
1486: fnd_message.raise_error;
1487: --
1488: End If;
1489: End If;

Line 1486: fnd_message.raise_error;

1482: ,p_validation_start_date
1483: ,p_validation_end_date) Then
1484: --
1485: fnd_message.set_name('PAY','HR_6953_PAY_ELE_NO_STOP_ENTRY');
1486: fnd_message.raise_error;
1487: --
1488: End If;
1489: End If;
1490: --

Line 1547: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1543: (p_effective_date
1544: ,'YES_NO'
1545: ,p_process_in_run_flag) Then
1546: --
1547: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1548: fnd_message.set_token('COLUMN','PROCESS_IN_RUN_FLAG');
1549: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1550: fnd_message.raise_error;
1551: --

Line 1548: fnd_message.set_token('COLUMN','PROCESS_IN_RUN_FLAG');

1544: ,'YES_NO'
1545: ,p_process_in_run_flag) Then
1546: --
1547: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1548: fnd_message.set_token('COLUMN','PROCESS_IN_RUN_FLAG');
1549: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1550: fnd_message.raise_error;
1551: --
1552: End If;

Line 1549: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1545: ,p_process_in_run_flag) Then
1546: --
1547: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1548: fnd_message.set_token('COLUMN','PROCESS_IN_RUN_FLAG');
1549: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1550: fnd_message.raise_error;
1551: --
1552: End If;
1553: --

Line 1550: fnd_message.raise_error;

1546: --
1547: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1548: fnd_message.set_token('COLUMN','PROCESS_IN_RUN_FLAG');
1549: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1550: fnd_message.raise_error;
1551: --
1552: End If;
1553: --
1554: If hr_api.not_exists_in_hr_lookups

Line 1559: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1555: (p_effective_date
1556: ,'YES_NO'
1557: ,p_indirect_only_flag) Then
1558: --
1559: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1560: fnd_message.set_token('COLUMN','INDIRECT_ONLY_FLAG');
1561: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1562: fnd_message.raise_error;
1563: --

Line 1560: fnd_message.set_token('COLUMN','INDIRECT_ONLY_FLAG');

1556: ,'YES_NO'
1557: ,p_indirect_only_flag) Then
1558: --
1559: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1560: fnd_message.set_token('COLUMN','INDIRECT_ONLY_FLAG');
1561: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1562: fnd_message.raise_error;
1563: --
1564: End If;

Line 1561: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1557: ,p_indirect_only_flag) Then
1558: --
1559: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1560: fnd_message.set_token('COLUMN','INDIRECT_ONLY_FLAG');
1561: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1562: fnd_message.raise_error;
1563: --
1564: End If;
1565: --

Line 1562: fnd_message.raise_error;

1558: --
1559: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1560: fnd_message.set_token('COLUMN','INDIRECT_ONLY_FLAG');
1561: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1562: fnd_message.raise_error;
1563: --
1564: End If;
1565: --
1566: If hr_api.not_exists_in_hr_lookups

Line 1571: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1567: (p_effective_date
1568: ,'YES_NO'
1569: ,p_multiply_value_flag) Then
1570: --
1571: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1572: fnd_message.set_token('COLUMN','MULTIPLY_VALUE_FLAG');
1573: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1574: fnd_message.raise_error;
1575: --

Line 1572: fnd_message.set_token('COLUMN','MULTIPLY_VALUE_FLAG');

1568: ,'YES_NO'
1569: ,p_multiply_value_flag) Then
1570: --
1571: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1572: fnd_message.set_token('COLUMN','MULTIPLY_VALUE_FLAG');
1573: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1574: fnd_message.raise_error;
1575: --
1576: End If;

Line 1573: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1569: ,p_multiply_value_flag) Then
1570: --
1571: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1572: fnd_message.set_token('COLUMN','MULTIPLY_VALUE_FLAG');
1573: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1574: fnd_message.raise_error;
1575: --
1576: End If;
1577: --

Line 1574: fnd_message.raise_error;

1570: --
1571: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1572: fnd_message.set_token('COLUMN','MULTIPLY_VALUE_FLAG');
1573: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1574: fnd_message.raise_error;
1575: --
1576: End If;
1577: --
1578: If hr_api.not_exists_in_hr_lookups

Line 1583: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1579: (p_effective_date
1580: ,'TERMINATION_RULE'
1581: ,p_post_termination_rule) Then
1582: --
1583: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1584: fnd_message.set_token('COLUMN','POST_TERMINATION_RULE');
1585: fnd_message.set_token('LOOKUP_TYPE','TERMINATION_RULE');
1586: fnd_message.raise_error;
1587: --

Line 1584: fnd_message.set_token('COLUMN','POST_TERMINATION_RULE');

1580: ,'TERMINATION_RULE'
1581: ,p_post_termination_rule) Then
1582: --
1583: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1584: fnd_message.set_token('COLUMN','POST_TERMINATION_RULE');
1585: fnd_message.set_token('LOOKUP_TYPE','TERMINATION_RULE');
1586: fnd_message.raise_error;
1587: --
1588: End If;

Line 1585: fnd_message.set_token('LOOKUP_TYPE','TERMINATION_RULE');

1581: ,p_post_termination_rule) Then
1582: --
1583: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1584: fnd_message.set_token('COLUMN','POST_TERMINATION_RULE');
1585: fnd_message.set_token('LOOKUP_TYPE','TERMINATION_RULE');
1586: fnd_message.raise_error;
1587: --
1588: End If;
1589: --

Line 1586: fnd_message.raise_error;

1582: --
1583: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1584: fnd_message.set_token('COLUMN','POST_TERMINATION_RULE');
1585: fnd_message.set_token('LOOKUP_TYPE','TERMINATION_RULE');
1586: fnd_message.raise_error;
1587: --
1588: End If;
1589: --
1590: If hr_api.not_exists_in_hr_lookups

Line 1595: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1591: (p_effective_date
1592: ,'YES_NO'
1593: ,p_once_each_period_flag) Then
1594: --
1595: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1596: fnd_message.set_token('COLUMN','ONCE_EACH_PERIOD_FLAG');
1597: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1598: fnd_message.raise_error;
1599: --

Line 1596: fnd_message.set_token('COLUMN','ONCE_EACH_PERIOD_FLAG');

1592: ,'YES_NO'
1593: ,p_once_each_period_flag) Then
1594: --
1595: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1596: fnd_message.set_token('COLUMN','ONCE_EACH_PERIOD_FLAG');
1597: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1598: fnd_message.raise_error;
1599: --
1600: End If;

Line 1597: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1593: ,p_once_each_period_flag) Then
1594: --
1595: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1596: fnd_message.set_token('COLUMN','ONCE_EACH_PERIOD_FLAG');
1597: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1598: fnd_message.raise_error;
1599: --
1600: End If;
1601: If (p_process_in_run_flag = 'N' and

Line 1598: fnd_message.raise_error;

1594: --
1595: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1596: fnd_message.set_token('COLUMN','ONCE_EACH_PERIOD_FLAG');
1597: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1598: fnd_message.raise_error;
1599: --
1600: End If;
1601: If (p_process_in_run_flag = 'N' and
1602: (p_adjustment_only_flag = 'Y' or

Line 1607: fnd_message.set_name('PAY','PAY_34134_ELE_PROC_RUN_VLDTN');

1603: p_indirect_only_flag = 'Y' or
1604: p_multiply_value_flag = 'Y' or
1605: p_once_each_period_flag = 'Y')) Then
1606: --
1607: fnd_message.set_name('PAY','PAY_34134_ELE_PROC_RUN_VLDTN');
1608: fnd_message.raise_error;
1609: --
1610: End If;
1611: --

Line 1608: fnd_message.raise_error;

1604: p_multiply_value_flag = 'Y' or
1605: p_once_each_period_flag = 'Y')) Then
1606: --
1607: fnd_message.set_name('PAY','PAY_34134_ELE_PROC_RUN_VLDTN');
1608: fnd_message.raise_error;
1609: --
1610: End If;
1611: --
1612: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1688: fnd_message.set_name('PAY','PAY_6149_ELEMENT_PRIORITY_UPD');

1684: p_validation_start_date,
1685: p_validation_end_date,
1686: p_error_if_true => FALSE) Then
1687: --
1688: fnd_message.set_name('PAY','PAY_6149_ELEMENT_PRIORITY_UPD');
1689: fnd_message.raise_error;
1690: --
1691: End If;
1692: End If;

Line 1689: fnd_message.raise_error;

1685: p_validation_end_date,
1686: p_error_if_true => FALSE) Then
1687: --
1688: fnd_message.set_name('PAY','PAY_6149_ELEMENT_PRIORITY_UPD');
1689: fnd_message.raise_error;
1690: --
1691: End If;
1692: End If;
1693: --

Line 1742: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1738: (p_effective_date
1739: ,'PROCESSING_TYPE'
1740: ,p_processing_type) Then
1741: --
1742: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1743: fnd_message.set_token('COLUMN','PROCESSING_TYPE');
1744: fnd_message.set_token('LOOKUP_TYPE','PROCESSING_TYPE');
1745: fnd_message.raise_error;
1746: --

Line 1743: fnd_message.set_token('COLUMN','PROCESSING_TYPE');

1739: ,'PROCESSING_TYPE'
1740: ,p_processing_type) Then
1741: --
1742: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1743: fnd_message.set_token('COLUMN','PROCESSING_TYPE');
1744: fnd_message.set_token('LOOKUP_TYPE','PROCESSING_TYPE');
1745: fnd_message.raise_error;
1746: --
1747: End If;

Line 1744: fnd_message.set_token('LOOKUP_TYPE','PROCESSING_TYPE');

1740: ,p_processing_type) Then
1741: --
1742: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1743: fnd_message.set_token('COLUMN','PROCESSING_TYPE');
1744: fnd_message.set_token('LOOKUP_TYPE','PROCESSING_TYPE');
1745: fnd_message.raise_error;
1746: --
1747: End If;
1748: --

Line 1745: fnd_message.raise_error;

1741: --
1742: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1743: fnd_message.set_token('COLUMN','PROCESSING_TYPE');
1744: fnd_message.set_token('LOOKUP_TYPE','PROCESSING_TYPE');
1745: fnd_message.raise_error;
1746: --
1747: End If;
1748: --
1749: If (p_processing_type = 'N' and p_benefit_classification_id is not null) Then

Line 1751: fnd_message.set_name('PAY','PAY_34135_ELE_BEN_CLASS_VLDTN');

1747: End If;
1748: --
1749: If (p_processing_type = 'N' and p_benefit_classification_id is not null) Then
1750: --
1751: fnd_message.set_name('PAY','PAY_34135_ELE_BEN_CLASS_VLDTN');
1752: fnd_message.raise_error;
1753: --
1754: End If;
1755: --

Line 1752: fnd_message.raise_error;

1748: --
1749: If (p_processing_type = 'N' and p_benefit_classification_id is not null) Then
1750: --
1751: fnd_message.set_name('PAY','PAY_34135_ELE_BEN_CLASS_VLDTN');
1752: fnd_message.raise_error;
1753: --
1754: End If;
1755: --
1756: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1802: (p_effective_date
1803: ,'YES_NO'
1804: ,p_standard_link_flag) Then
1805: --
1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');
1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1809: fnd_message.raise_error;
1810: --

Line 1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');

1803: ,'YES_NO'
1804: ,p_standard_link_flag) Then
1805: --
1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');
1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1809: fnd_message.raise_error;
1810: --
1811: End If;

Line 1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1804: ,p_standard_link_flag) Then
1805: --
1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');
1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1809: fnd_message.raise_error;
1810: --
1811: End If;
1812: --

Line 1809: fnd_message.raise_error;

1805: --
1806: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1807: fnd_message.set_token('COLUMN','STANDARD_LINK_FLAG');
1808: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1809: fnd_message.raise_error;
1810: --
1811: End If;
1812: --
1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then

Line 1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');

1811: End If;
1812: --
1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then
1814: --
1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');
1816: fnd_message.raise_error;
1817: --
1818: End If;
1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then

Line 1816: fnd_message.raise_error;

1812: --
1813: If (p_standard_link_flag = 'Y' and p_processing_type = 'N') Then
1814: --
1815: fnd_message.set_name('PAY','PAY_6140_ELEMENT_NO_STANDARD');
1816: fnd_message.raise_error;
1817: --
1818: End If;
1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then
1820: --

Line 1821: fnd_message.set_name('PAY','HR_6952_PAY_ELE_NO_STD_MULTI');

1817: --
1818: End If;
1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then
1820: --
1821: fnd_message.set_name('PAY','HR_6952_PAY_ELE_NO_STD_MULTI');
1822: fnd_message.raise_error;
1823: --
1824: End If;
1825: --

Line 1822: fnd_message.raise_error;

1818: End If;
1819: If (p_standard_link_flag = 'Y' and p_multiple_entries_allowed_flg = 'Y') Then
1820: --
1821: fnd_message.set_name('PAY','HR_6952_PAY_ELE_NO_STD_MULTI');
1822: fnd_message.raise_error;
1823: --
1824: End If;
1825: --
1826: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 1879: fnd_message.set_name('PAY','PAY_33096_QUALI_AGE_CHECK');

1875: If nvl(p_qualifying_age,hr_api.g_number) <> hr_api.g_number Then
1876: If (sign(p_qualifying_age) = -1) or (p_qualifying_age not between 0 and 99)
1877: then
1878: --
1879: fnd_message.set_name('PAY','PAY_33096_QUALI_AGE_CHECK');
1880: fnd_message.raise_error;
1881: --
1882: End If;
1883: Elsif nvl(p_qualifying_length_of_service,hr_api.g_number) <> hr_api.g_number

Line 1880: fnd_message.raise_error;

1876: If (sign(p_qualifying_age) = -1) or (p_qualifying_age not between 0 and 99)
1877: then
1878: --
1879: fnd_message.set_name('PAY','PAY_33096_QUALI_AGE_CHECK');
1880: fnd_message.raise_error;
1881: --
1882: End If;
1883: Elsif nvl(p_qualifying_length_of_service,hr_api.g_number) <> hr_api.g_number
1884: then

Line 1887: fnd_message.set_name('PAY','PAY_34143_QUALI_LOS_VLDTN');

1883: Elsif nvl(p_qualifying_length_of_service,hr_api.g_number) <> hr_api.g_number
1884: then
1885: If (sign(p_qualifying_length_of_service) = -1) Then
1886: --
1887: fnd_message.set_name('PAY','PAY_34143_QUALI_LOS_VLDTN');
1888: fnd_message.raise_error;
1889: --
1890: End If;
1891: --

Line 1888: fnd_message.raise_error;

1884: then
1885: If (sign(p_qualifying_length_of_service) = -1) Then
1886: --
1887: fnd_message.set_name('PAY','PAY_34143_QUALI_LOS_VLDTN');
1888: fnd_message.raise_error;
1889: --
1890: End If;
1891: --
1892: If nvl(p_qualifying_units,hr_api.g_varchar2) = hr_api.g_varchar2 Then

Line 1894: fnd_message.set_name('PAY','PAY_34137_QUALI_FACTORS_VLDTN');

1890: End If;
1891: --
1892: If nvl(p_qualifying_units,hr_api.g_varchar2) = hr_api.g_varchar2 Then
1893: --
1894: fnd_message.set_name('PAY','PAY_34137_QUALI_FACTORS_VLDTN');
1895: fnd_message.raise_error;
1896: --
1897: Else
1898: --

Line 1895: fnd_message.raise_error;

1891: --
1892: If nvl(p_qualifying_units,hr_api.g_varchar2) = hr_api.g_varchar2 Then
1893: --
1894: fnd_message.set_name('PAY','PAY_34137_QUALI_FACTORS_VLDTN');
1895: fnd_message.raise_error;
1896: --
1897: Else
1898: --
1899: If hr_api.not_exists_in_hr_lookups

Line 1904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1900: (p_effective_date
1901: ,'QUALIFYING_UNITS'
1902: ,p_qualifying_units) Then
1903: --
1904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1905: fnd_message.set_token('COLUMN','QUALIFYING_UNITS');
1906: fnd_message.set_token('LOOKUP_TYPE','QUALIFYING_UNITS');
1907: fnd_message.raise_error;
1908: --

Line 1905: fnd_message.set_token('COLUMN','QUALIFYING_UNITS');

1901: ,'QUALIFYING_UNITS'
1902: ,p_qualifying_units) Then
1903: --
1904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1905: fnd_message.set_token('COLUMN','QUALIFYING_UNITS');
1906: fnd_message.set_token('LOOKUP_TYPE','QUALIFYING_UNITS');
1907: fnd_message.raise_error;
1908: --
1909: End If;

Line 1906: fnd_message.set_token('LOOKUP_TYPE','QUALIFYING_UNITS');

1902: ,p_qualifying_units) Then
1903: --
1904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1905: fnd_message.set_token('COLUMN','QUALIFYING_UNITS');
1906: fnd_message.set_token('LOOKUP_TYPE','QUALIFYING_UNITS');
1907: fnd_message.raise_error;
1908: --
1909: End If;
1910: --

Line 1907: fnd_message.raise_error;

1903: --
1904: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1905: fnd_message.set_token('COLUMN','QUALIFYING_UNITS');
1906: fnd_message.set_token('LOOKUP_TYPE','QUALIFYING_UNITS');
1907: fnd_message.raise_error;
1908: --
1909: End If;
1910: --
1911: End If;

Line 1966: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1962: (p_effective_date
1963: ,'YES_NO'
1964: ,nvl(p_third_party_pay_only_flag,'N')) Then
1965: --
1966: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1967: fnd_message.set_token('COLUMN','THIRD_PARTY_PAY_ONLY_FLAG');
1968: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1969: fnd_message.raise_error;
1970: --

Line 1967: fnd_message.set_token('COLUMN','THIRD_PARTY_PAY_ONLY_FLAG');

1963: ,'YES_NO'
1964: ,nvl(p_third_party_pay_only_flag,'N')) Then
1965: --
1966: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1967: fnd_message.set_token('COLUMN','THIRD_PARTY_PAY_ONLY_FLAG');
1968: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1969: fnd_message.raise_error;
1970: --
1971: End If;

Line 1968: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

1964: ,nvl(p_third_party_pay_only_flag,'N')) Then
1965: --
1966: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1967: fnd_message.set_token('COLUMN','THIRD_PARTY_PAY_ONLY_FLAG');
1968: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1969: fnd_message.raise_error;
1970: --
1971: End If;
1972: If p_element_type_id is not null and

Line 1969: fnd_message.raise_error;

1965: --
1966: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1967: fnd_message.set_token('COLUMN','THIRD_PARTY_PAY_ONLY_FLAG');
1968: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
1969: fnd_message.raise_error;
1970: --
1971: End If;
1972: If p_element_type_id is not null and
1973: (p_third_party_pay_only_flag <>

Line 1981: fnd_message.set_name('PAY','PAY_34139_ELE_3RD_NO_UPD');

1977: If pay_element_types_pkg.element_entries_exist
1978: (p_element_type_id
1979: ,FALSE) Then
1980: --
1981: fnd_message.set_name('PAY','PAY_34139_ELE_3RD_NO_UPD');
1982: fnd_message.raise_error;
1983: --
1984: End If;
1985: End If;

Line 1982: fnd_message.raise_error;

1978: (p_element_type_id
1979: ,FALSE) Then
1980: --
1981: fnd_message.set_name('PAY','PAY_34139_ELE_3RD_NO_UPD');
1982: fnd_message.raise_error;
1983: --
1984: End If;
1985: End If;
1986: --

Line 2059: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

2055: ,p_from_date => p_validation_start_date
2056: ,p_to_date => p_validation_end_date
2057: )) Then
2058: --
2059: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2060: fnd_message.set_token('COLUMN','FORMULA_ID');
2061: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2062: fnd_message.raise_error;
2063: --

Line 2060: fnd_message.set_token('COLUMN','FORMULA_ID');

2056: ,p_to_date => p_validation_end_date
2057: )) Then
2058: --
2059: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2060: fnd_message.set_token('COLUMN','FORMULA_ID');
2061: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2062: fnd_message.raise_error;
2063: --
2064: End If;

Line 2061: fnd_message.set_token('TABLE','FF_FORMULAS_F');

2057: )) Then
2058: --
2059: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2060: fnd_message.set_token('COLUMN','FORMULA_ID');
2061: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2062: fnd_message.raise_error;
2063: --
2064: End If;
2065: End If;

Line 2062: fnd_message.raise_error;

2058: --
2059: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2060: fnd_message.set_token('COLUMN','FORMULA_ID');
2061: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2062: fnd_message.raise_error;
2063: --
2064: End If;
2065: End If;
2066: --

Line 2072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

2068: (p_effective_date
2069: ,'YES_NO'
2070: ,nvl(p_iterative_flag,'N')) Then
2071: --
2072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2073: fnd_message.set_token('COLUMN','ITERATIVE_FLAG');
2074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
2075: fnd_message.raise_error;
2076: --

Line 2073: fnd_message.set_token('COLUMN','ITERATIVE_FLAG');

2069: ,'YES_NO'
2070: ,nvl(p_iterative_flag,'N')) Then
2071: --
2072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2073: fnd_message.set_token('COLUMN','ITERATIVE_FLAG');
2074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
2075: fnd_message.raise_error;
2076: --
2077: End If;

Line 2074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

2070: ,nvl(p_iterative_flag,'N')) Then
2071: --
2072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2073: fnd_message.set_token('COLUMN','ITERATIVE_FLAG');
2074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
2075: fnd_message.raise_error;
2076: --
2077: End If;
2078: --

Line 2075: fnd_message.raise_error;

2071: --
2072: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2073: fnd_message.set_token('COLUMN','ITERATIVE_FLAG');
2074: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
2075: fnd_message.raise_error;
2076: --
2077: End If;
2078: --
2079: If hr_api.not_exists_in_hr_lookups

Line 2084: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

2080: (p_effective_date
2081: ,'YES_NO'
2082: ,nvl(p_grossup_flag,'N')) Then
2083: --
2084: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2085: fnd_message.set_token('COLUMN','GROSSUP_FLAG');
2086: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
2087: fnd_message.raise_error;
2088: --

Line 2085: fnd_message.set_token('COLUMN','GROSSUP_FLAG');

2081: ,'YES_NO'
2082: ,nvl(p_grossup_flag,'N')) Then
2083: --
2084: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2085: fnd_message.set_token('COLUMN','GROSSUP_FLAG');
2086: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
2087: fnd_message.raise_error;
2088: --
2089: End If;

Line 2086: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

2082: ,nvl(p_grossup_flag,'N')) Then
2083: --
2084: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2085: fnd_message.set_token('COLUMN','GROSSUP_FLAG');
2086: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
2087: fnd_message.raise_error;
2088: --
2089: End If;
2090: --

Line 2087: fnd_message.raise_error;

2083: --
2084: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2085: fnd_message.set_token('COLUMN','GROSSUP_FLAG');
2086: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
2087: fnd_message.raise_error;
2088: --
2089: End If;
2090: --
2091: If p_iterative_flag = 'N' and

Line 2095: fnd_message.set_name('PAY','PAY_34144_ELE_ITR_NO_FORML_PRI');

2091: If p_iterative_flag = 'N' and
2092: (p_iterative_formula_id is not null or
2093: p_iterative_priority is not null) Then
2094: --
2095: fnd_message.set_name('PAY','PAY_34144_ELE_ITR_NO_FORML_PRI');
2096: fnd_message.raise_error;
2097: --
2098: End If;
2099: If p_iterative_flag = 'Y' and p_iterative_formula_id is null Then

Line 2096: fnd_message.raise_error;

2092: (p_iterative_formula_id is not null or
2093: p_iterative_priority is not null) Then
2094: --
2095: fnd_message.set_name('PAY','PAY_34144_ELE_ITR_NO_FORML_PRI');
2096: fnd_message.raise_error;
2097: --
2098: End If;
2099: If p_iterative_flag = 'Y' and p_iterative_formula_id is null Then
2100: --

Line 2101: fnd_message.set_name('PAY','PAY_34146_ELE_ITR_FORML_REQD');

2097: --
2098: End If;
2099: If p_iterative_flag = 'Y' and p_iterative_formula_id is null Then
2100: --
2101: fnd_message.set_name('PAY','PAY_34146_ELE_ITR_FORML_REQD');
2102: fnd_message.raise_error;
2103: --
2104: End If;
2105: If p_iterative_formula_id is not null Then

Line 2102: fnd_message.raise_error;

2098: End If;
2099: If p_iterative_flag = 'Y' and p_iterative_formula_id is null Then
2100: --
2101: fnd_message.set_name('PAY','PAY_34146_ELE_ITR_FORML_REQD');
2102: fnd_message.raise_error;
2103: --
2104: End If;
2105: If p_iterative_formula_id is not null Then
2106: --

Line 2113: fnd_message.set_name('PAY','PAY_34145_ELE_ITR_FTYPE');

2109: Close c_formula_type;
2110: --
2111: If upper(l_formula_type) <> 'NET TO GROSS' Then
2112: --
2113: fnd_message.set_name('PAY','PAY_34145_ELE_ITR_FTYPE');
2114: fnd_message.raise_error;
2115: --
2116: End If;
2117: --

Line 2114: fnd_message.raise_error;

2110: --
2111: If upper(l_formula_type) <> 'NET TO GROSS' Then
2112: --
2113: fnd_message.set_name('PAY','PAY_34145_ELE_ITR_FTYPE');
2114: fnd_message.raise_error;
2115: --
2116: End If;
2117: --
2118: End If;

Line 2121: fnd_message.set_name('PAY','PAY_34147_ELE_ITR_GROSSUP');

2117: --
2118: End If;
2119: If (p_grossup_flag = 'Y' and p_iterative_flag <> 'Y') Then
2120: --
2121: fnd_message.set_name('PAY','PAY_34147_ELE_ITR_GROSSUP');
2122: fnd_message.raise_error;
2123: --
2124: End If;
2125: If p_process_mode not in ('P','N','S') Then

Line 2122: fnd_message.raise_error;

2118: End If;
2119: If (p_grossup_flag = 'Y' and p_iterative_flag <> 'Y') Then
2120: --
2121: fnd_message.set_name('PAY','PAY_34147_ELE_ITR_GROSSUP');
2122: fnd_message.raise_error;
2123: --
2124: End If;
2125: If p_process_mode not in ('P','N','S') Then
2126: --

Line 2127: fnd_message.set_name('PAY','PAY_34148_ELE_PROC_MODE');

2123: --
2124: End If;
2125: If p_process_mode not in ('P','N','S') Then
2126: --
2127: fnd_message.set_name('PAY','PAY_34148_ELE_PROC_MODE');
2128: fnd_message.raise_error;
2129: --
2130: End If;
2131: --

Line 2128: fnd_message.raise_error;

2124: End If;
2125: If p_process_mode not in ('P','N','S') Then
2126: --
2127: fnd_message.set_name('PAY','PAY_34148_ELE_PROC_MODE');
2128: fnd_message.raise_error;
2129: --
2130: End If;
2131: --
2132: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 2180: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

2176: ,p_from_date => p_validation_start_date
2177: ,p_to_date => p_validation_end_date
2178: )) Then
2179: --
2180: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2181: fnd_message.set_token('COLUMN','RETRO_SUMM_ELE_ID');
2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
2183: fnd_message.raise_error;
2184: --

Line 2181: fnd_message.set_token('COLUMN','RETRO_SUMM_ELE_ID');

2177: ,p_to_date => p_validation_end_date
2178: )) Then
2179: --
2180: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2181: fnd_message.set_token('COLUMN','RETRO_SUMM_ELE_ID');
2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
2183: fnd_message.raise_error;
2184: --
2185: End If;

Line 2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');

2178: )) Then
2179: --
2180: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2181: fnd_message.set_token('COLUMN','RETRO_SUMM_ELE_ID');
2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
2183: fnd_message.raise_error;
2184: --
2185: End If;
2186: End If;

Line 2183: fnd_message.raise_error;

2179: --
2180: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2181: fnd_message.set_token('COLUMN','RETRO_SUMM_ELE_ID');
2182: fnd_message.set_token('TABLE','PAY_ELEMENT_TYPES_F');
2183: fnd_message.raise_error;
2184: --
2185: End If;
2186: End If;
2187: --

Line 2197: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

2193: ,p_from_date => p_validation_start_date
2194: ,p_to_date => p_validation_end_date
2195: )) Then
2196: --
2197: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2198: fnd_message.set_token('COLUMN','PRORATION_FORMULA_ID');
2199: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2200: fnd_message.raise_error;
2201: --

Line 2198: fnd_message.set_token('COLUMN','PRORATION_FORMULA_ID');

2194: ,p_to_date => p_validation_end_date
2195: )) Then
2196: --
2197: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2198: fnd_message.set_token('COLUMN','PRORATION_FORMULA_ID');
2199: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2200: fnd_message.raise_error;
2201: --
2202: End If;

Line 2199: fnd_message.set_token('TABLE','FF_FORMULAS_F');

2195: )) Then
2196: --
2197: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2198: fnd_message.set_token('COLUMN','PRORATION_FORMULA_ID');
2199: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2200: fnd_message.raise_error;
2201: --
2202: End If;
2203: End If;

Line 2200: fnd_message.raise_error;

2196: --
2197: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2198: fnd_message.set_token('COLUMN','PRORATION_FORMULA_ID');
2199: fnd_message.set_token('TABLE','FF_FORMULAS_F');
2200: fnd_message.raise_error;
2201: --
2202: End If;
2203: End If;
2204: --

Line 2212: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

2208: Fetch c_chk_event_group_id into l_exists, p_event_group_type;
2209: If c_chk_event_group_id%notfound Then
2210: --
2211: Close c_chk_event_group_id;
2212: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2213: fnd_message.set_token('COLUMN','PRORATION_GROUP_ID');
2214: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2215: fnd_message.raise_error;
2216: --

Line 2213: fnd_message.set_token('COLUMN','PRORATION_GROUP_ID');

2209: If c_chk_event_group_id%notfound Then
2210: --
2211: Close c_chk_event_group_id;
2212: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2213: fnd_message.set_token('COLUMN','PRORATION_GROUP_ID');
2214: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2215: fnd_message.raise_error;
2216: --
2217: Elsif p_event_group_type <> 'P' Then

Line 2214: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');

2210: --
2211: Close c_chk_event_group_id;
2212: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2213: fnd_message.set_token('COLUMN','PRORATION_GROUP_ID');
2214: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2215: fnd_message.raise_error;
2216: --
2217: Elsif p_event_group_type <> 'P' Then
2218: --

Line 2215: fnd_message.raise_error;

2211: Close c_chk_event_group_id;
2212: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2213: fnd_message.set_token('COLUMN','PRORATION_GROUP_ID');
2214: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2215: fnd_message.raise_error;
2216: --
2217: Elsif p_event_group_type <> 'P' Then
2218: --
2219: Close c_chk_event_group_id;

Line 2220: fnd_message.set_name('PAY','PAY_34141_ELE_PRORATION');

2216: --
2217: Elsif p_event_group_type <> 'P' Then
2218: --
2219: Close c_chk_event_group_id;
2220: fnd_message.set_name('PAY','PAY_34141_ELE_PRORATION');
2221: fnd_message.raise_error;
2222: --
2223: End If;
2224: Close c_chk_event_group_id;

Line 2221: fnd_message.raise_error;

2217: Elsif p_event_group_type <> 'P' Then
2218: --
2219: Close c_chk_event_group_id;
2220: fnd_message.set_name('PAY','PAY_34141_ELE_PRORATION');
2221: fnd_message.raise_error;
2222: --
2223: End If;
2224: Close c_chk_event_group_id;
2225: --

Line 2235: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

2231: Fetch c_chk_event_group_id into l_exists, p_event_group_type;
2232: If c_chk_event_group_id%notfound Then
2233: --
2234: Close c_chk_event_group_id;
2235: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2236: fnd_message.set_token('COLUMN','RECALC_EVENT_GROUP_ID');
2237: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2238: fnd_message.raise_error;
2239: --

Line 2236: fnd_message.set_token('COLUMN','RECALC_EVENT_GROUP_ID');

2232: If c_chk_event_group_id%notfound Then
2233: --
2234: Close c_chk_event_group_id;
2235: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2236: fnd_message.set_token('COLUMN','RECALC_EVENT_GROUP_ID');
2237: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2238: fnd_message.raise_error;
2239: --
2240: Elsif p_event_group_type <> 'R' Then

Line 2237: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');

2233: --
2234: Close c_chk_event_group_id;
2235: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2236: fnd_message.set_token('COLUMN','RECALC_EVENT_GROUP_ID');
2237: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2238: fnd_message.raise_error;
2239: --
2240: Elsif p_event_group_type <> 'R' Then
2241: --

Line 2238: fnd_message.raise_error;

2234: Close c_chk_event_group_id;
2235: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2236: fnd_message.set_token('COLUMN','RECALC_EVENT_GROUP_ID');
2237: fnd_message.set_token('TABLE','PAY_EVENT_GROUPS');
2238: fnd_message.raise_error;
2239: --
2240: Elsif p_event_group_type <> 'R' Then
2241: --
2242: Close c_chk_event_group_id;

Line 2243: fnd_message.set_name('PAY','PAY_34149_ELE_RECALC_EVENT');

2239: --
2240: Elsif p_event_group_type <> 'R' Then
2241: --
2242: Close c_chk_event_group_id;
2243: fnd_message.set_name('PAY','PAY_34149_ELE_RECALC_EVENT');
2244: fnd_message.raise_error;
2245: --
2246: End If;
2247: Close c_chk_event_group_id;

Line 2244: fnd_message.raise_error;

2240: Elsif p_event_group_type <> 'R' Then
2241: --
2242: Close c_chk_event_group_id;
2243: fnd_message.set_name('PAY','PAY_34149_ELE_RECALC_EVENT');
2244: fnd_message.raise_error;
2245: --
2246: End If;
2247: Close c_chk_event_group_id;
2248: --

Line 2290: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');

2286: open csr_time_definition;
2287: fetch csr_time_definition into l_flag;
2288: If (csr_time_definition%notfound) then
2289: close csr_time_definition;
2290: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2291: fnd_message.set_token('COLUMN','TIME_DEFINTION_ID');
2292: fnd_message.set_token('TABLE','PAY_TIME_DEFINITIONS');
2293: fnd_message.raise_error;
2294: end if;

Line 2291: fnd_message.set_token('COLUMN','TIME_DEFINTION_ID');

2287: fetch csr_time_definition into l_flag;
2288: If (csr_time_definition%notfound) then
2289: close csr_time_definition;
2290: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2291: fnd_message.set_token('COLUMN','TIME_DEFINTION_ID');
2292: fnd_message.set_token('TABLE','PAY_TIME_DEFINITIONS');
2293: fnd_message.raise_error;
2294: end if;
2295: close csr_time_definition;

Line 2292: fnd_message.set_token('TABLE','PAY_TIME_DEFINITIONS');

2288: If (csr_time_definition%notfound) then
2289: close csr_time_definition;
2290: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2291: fnd_message.set_token('COLUMN','TIME_DEFINTION_ID');
2292: fnd_message.set_token('TABLE','PAY_TIME_DEFINITIONS');
2293: fnd_message.raise_error;
2294: end if;
2295: close csr_time_definition;
2296: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 2293: fnd_message.raise_error;

2289: close csr_time_definition;
2290: fnd_message.set_name('PAY','PAY_33085_INVALID_FK');
2291: fnd_message.set_token('COLUMN','TIME_DEFINTION_ID');
2292: fnd_message.set_token('TABLE','PAY_TIME_DEFINITIONS');
2293: fnd_message.raise_error;
2294: end if;
2295: close csr_time_definition;
2296: hr_utility.set_location('Leaving:'||l_proc, 10);
2297: --

Line 2332: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

2328: (p_effective_date
2329: ,'PAY_TIME_DEFINITION_TYPE'
2330: ,p_time_definition_type) Then
2331: --
2332: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2333: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2334: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2335: fnd_message.raise_error;
2336: --

Line 2333: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');

2329: ,'PAY_TIME_DEFINITION_TYPE'
2330: ,p_time_definition_type) Then
2331: --
2332: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2333: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2334: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2335: fnd_message.raise_error;
2336: --
2337: End If; */

Line 2334: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');

2330: ,p_time_definition_type) Then
2331: --
2332: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2333: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2334: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2335: fnd_message.raise_error;
2336: --
2337: End If; */
2338: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 2335: fnd_message.raise_error;

2331: --
2332: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2333: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2334: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2335: fnd_message.raise_error;
2336: --
2337: End If; */
2338: hr_utility.set_location('Leaving:'||l_proc, 10);
2339: --

Line 2439: fnd_message.set_name('PAY','PAY_6147_ELEMENT_LINK_UPDATE');

2435: p_validation_end_date);
2436: --
2437: If l_element_links Then
2438: --
2439: fnd_message.set_name('PAY','PAY_6147_ELEMENT_LINK_UPDATE');
2440: fnd_message.raise_error;
2441: --
2442: End If;
2443: If (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag

Line 2440: fnd_message.raise_error;

2436: --
2437: If l_element_links Then
2438: --
2439: fnd_message.set_name('PAY','PAY_6147_ELEMENT_LINK_UPDATE');
2440: fnd_message.raise_error;
2441: --
2442: End If;
2443: If (p_adjustment_only_flag <> pay_etp_shd_nd.g_old_rec.adjustment_only_flag
2444: )Then

Line 2453: fnd_message.set_name('PAY','PAY_34138_ELE_NO_ADJ_FRR_UPD');

2449: p_validation_end_date);
2450: --
2451: If l_indirect_results Then
2452: --
2453: fnd_message.set_name('PAY','PAY_34138_ELE_NO_ADJ_FRR_UPD');
2454: fnd_message.raise_error;
2455: --
2456: End If;
2457: --

Line 2454: fnd_message.raise_error;

2450: --
2451: If l_indirect_results Then
2452: --
2453: fnd_message.set_name('PAY','PAY_34138_ELE_NO_ADJ_FRR_UPD');
2454: fnd_message.raise_error;
2455: --
2456: End If;
2457: --
2458: End If;

Line 2471: fnd_message.set_name('PAY','PAY_6909_ELEMENT_NO_UPD_RR');

2467: (p_element_type_id, p_validation_start_date, p_validation_end_date);
2468: --
2469: If l_run_results Then
2470: --
2471: fnd_message.set_name('PAY','PAY_6909_ELEMENT_NO_UPD_RR');
2472: fnd_message.raise_error;
2473: --
2474: End If;
2475: --

Line 2472: fnd_message.raise_error;

2468: --
2469: If l_run_results Then
2470: --
2471: fnd_message.set_name('PAY','PAY_6909_ELEMENT_NO_UPD_RR');
2472: fnd_message.raise_error;
2473: --
2474: End If;
2475: --
2476: End If;

Line 2621: fnd_message.set_name('PAY','PAY_6149_ELEMENT_PRIORITY_UPD');

2617: p_processing_priority,
2618: p_validation_start_date,
2619: p_validation_end_date) Then
2620: --
2621: fnd_message.set_name('PAY','PAY_6149_ELEMENT_PRIORITY_UPD');
2622: fnd_message.raise_error;
2623: --
2624: Elsif pay_element_types_pkg.cobra_benefits_exist
2625: (p_element_type_id,

Line 2622: fnd_message.raise_error;

2618: p_validation_start_date,
2619: p_validation_end_date) Then
2620: --
2621: fnd_message.set_name('PAY','PAY_6149_ELEMENT_PRIORITY_UPD');
2622: fnd_message.raise_error;
2623: --
2624: Elsif pay_element_types_pkg.cobra_benefits_exist
2625: (p_element_type_id,
2626: p_validation_start_date,

Line 2629: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');

2625: (p_element_type_id,
2626: p_validation_start_date,
2627: p_validation_end_date) Then
2628: --
2629: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');
2630: fnd_message.raise_error;
2631: --
2632: End If;
2633: End If;

Line 2630: fnd_message.raise_error;

2626: p_validation_start_date,
2627: p_validation_end_date) Then
2628: --
2629: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');
2630: fnd_message.raise_error;
2631: --
2632: End If;
2633: End If;
2634: --

Line 2642: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');

2638: (p_element_type_id,
2639: p_validation_start_date,
2640: p_validation_end_date) Then
2641: --
2642: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');
2643: fnd_message.raise_error;
2644: --
2645: Elsif pay_element_types_pkg.run_results_exist
2646: (p_element_type_id,

Line 2643: fnd_message.raise_error;

2639: p_validation_start_date,
2640: p_validation_end_date) Then
2641: --
2642: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');
2643: fnd_message.raise_error;
2644: --
2645: Elsif pay_element_types_pkg.run_results_exist
2646: (p_element_type_id,
2647: p_validation_start_date,

Line 2650: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');

2646: (p_element_type_id,
2647: p_validation_start_date,
2648: p_validation_end_date) Then
2649: --
2650: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');
2651: fnd_message.raise_error;
2652: --
2653: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2654: --

Line 2651: fnd_message.raise_error;

2647: p_validation_start_date,
2648: p_validation_end_date) Then
2649: --
2650: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');
2651: fnd_message.raise_error;
2652: --
2653: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2654: --
2655: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');

Line 2655: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');

2651: fnd_message.raise_error;
2652: --
2653: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2654: --
2655: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');
2656: fnd_message.raise_error;
2657: --
2658: End If;
2659: --

Line 2656: fnd_message.raise_error;

2652: --
2653: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2654: --
2655: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');
2656: fnd_message.raise_error;
2657: --
2658: End If;
2659: --
2660: End If;

Line 2667: fnd_message.set_name('PAY','PAY_6713_ELEMENT_NO_DEL_RULE');

2663: --
2664: If pay_element_types_pkg.element_is_in_an_element_set
2665: (p_element_type_id) Then
2666: --
2667: fnd_message.set_name('PAY','PAY_6713_ELEMENT_NO_DEL_RULE');
2668: fnd_message.raise_error;
2669: --
2670: Elsif pay_element_types_pkg.links_exist
2671: (p_element_type_id,

Line 2668: fnd_message.raise_error;

2664: If pay_element_types_pkg.element_is_in_an_element_set
2665: (p_element_type_id) Then
2666: --
2667: fnd_message.set_name('PAY','PAY_6713_ELEMENT_NO_DEL_RULE');
2668: fnd_message.raise_error;
2669: --
2670: Elsif pay_element_types_pkg.links_exist
2671: (p_element_type_id,
2672: p_validation_start_date,

Line 2675: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');

2671: (p_element_type_id,
2672: p_validation_start_date,
2673: p_validation_end_date) Then
2674: --
2675: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');
2676: fnd_message.raise_error;
2677: --
2678: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2679: --

Line 2676: fnd_message.raise_error;

2672: p_validation_start_date,
2673: p_validation_end_date) Then
2674: --
2675: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');
2676: fnd_message.raise_error;
2677: --
2678: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2679: --
2680: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');

Line 2680: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');

2676: fnd_message.raise_error;
2677: --
2678: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2679: --
2680: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');
2681: fnd_message.raise_error;
2682: --
2683: Elsif accrual_plan_exists(p_element_type_id) Then
2684: --

Line 2681: fnd_message.raise_error;

2677: --
2678: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2679: --
2680: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');
2681: fnd_message.raise_error;
2682: --
2683: Elsif accrual_plan_exists(p_element_type_id) Then
2684: --
2685: fnd_message.set_name('PAY','PAY_34142_ELE_NO_DEL_ACCRUAL');

Line 2685: fnd_message.set_name('PAY','PAY_34142_ELE_NO_DEL_ACCRUAL');

2681: fnd_message.raise_error;
2682: --
2683: Elsif accrual_plan_exists(p_element_type_id) Then
2684: --
2685: fnd_message.set_name('PAY','PAY_34142_ELE_NO_DEL_ACCRUAL');
2686: fnd_message.raise_error;
2687: --
2688: Elsif pay_element_types_pkg.run_results_exist
2689: (p_element_type_id,

Line 2686: fnd_message.raise_error;

2682: --
2683: Elsif accrual_plan_exists(p_element_type_id) Then
2684: --
2685: fnd_message.set_name('PAY','PAY_34142_ELE_NO_DEL_ACCRUAL');
2686: fnd_message.raise_error;
2687: --
2688: Elsif pay_element_types_pkg.run_results_exist
2689: (p_element_type_id,
2690: p_validation_start_date,

Line 2693: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');

2689: (p_element_type_id,
2690: p_validation_start_date,
2691: p_validation_end_date) Then
2692: --
2693: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');
2694: fnd_message.raise_error;
2695: --
2696: Elsif benefit_contributions_exist
2697: (p_element_type_id,

Line 2694: fnd_message.raise_error;

2690: p_validation_start_date,
2691: p_validation_end_date) Then
2692: --
2693: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');
2694: fnd_message.raise_error;
2695: --
2696: Elsif benefit_contributions_exist
2697: (p_element_type_id,
2698: p_validation_start_date,

Line 2701: fnd_message.set_name('PAY','PAY_34140_ELE_BEN_CONT_NO_DEL');

2697: (p_element_type_id,
2698: p_validation_start_date,
2699: p_validation_end_date) Then
2700: --
2701: fnd_message.set_name('PAY','PAY_34140_ELE_BEN_CONT_NO_DEL');
2702: fnd_message.raise_error;
2703: --
2704: Elsif pay_element_types_pkg.cobra_benefits_exist
2705: (p_element_type_id,

Line 2702: fnd_message.raise_error;

2698: p_validation_start_date,
2699: p_validation_end_date) Then
2700: --
2701: fnd_message.set_name('PAY','PAY_34140_ELE_BEN_CONT_NO_DEL');
2702: fnd_message.raise_error;
2703: --
2704: Elsif pay_element_types_pkg.cobra_benefits_exist
2705: (p_element_type_id,
2706: p_validation_start_date,

Line 2709: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');

2705: (p_element_type_id,
2706: p_validation_start_date,
2707: p_validation_end_date) Then
2708: --
2709: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');
2710: fnd_message.raise_error;
2711: --
2712: Elsif element_used_as_pay_basis(p_element_type_id) Then
2713: --

Line 2710: fnd_message.raise_error;

2706: p_validation_start_date,
2707: p_validation_end_date) Then
2708: --
2709: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');
2710: fnd_message.raise_error;
2711: --
2712: Elsif element_used_as_pay_basis(p_element_type_id) Then
2713: --
2714: fnd_message.set_name('PAY','PAY_6965_INPVAL_NO_DEL_SB');

Line 2714: fnd_message.set_name('PAY','PAY_6965_INPVAL_NO_DEL_SB');

2710: fnd_message.raise_error;
2711: --
2712: Elsif element_used_as_pay_basis(p_element_type_id) Then
2713: --
2714: fnd_message.set_name('PAY','PAY_6965_INPVAL_NO_DEL_SB');
2715: fnd_message.raise_error;
2716: --
2717: End If;
2718: End If;

Line 2715: fnd_message.raise_error;

2711: --
2712: Elsif element_used_as_pay_basis(p_element_type_id) Then
2713: --
2714: fnd_message.set_name('PAY','PAY_6965_INPVAL_NO_DEL_SB');
2715: fnd_message.raise_error;
2716: --
2717: End If;
2718: End If;
2719: --