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 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 472: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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

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

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

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

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

Line 475: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 554: fnd_message.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 694: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 774: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 816: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 899: fnd_message.raise_error;

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

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

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

Line 908: fnd_message.raise_error;

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

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

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

Line 918: fnd_message.raise_error;

914: If c_chk_formula_type%notfound Then
915: --
916: Close c_chk_formula_type;
917: fnd_message.set_name('PAY','PAY_34130_ELE_FTYPE_INVALID');
918: fnd_message.raise_error;
919: --
920: End If;
921: Close c_chk_formula_type;
922: 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 2314: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

2310: ,'PAY_TIME_DEFINITION_TYPE'
2311: ,p_time_definition_type) Then
2312:
2313: hr_utility.set_location('The user has passed some value to time definition type ', 20);
2314: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2315: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2316: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2317: fnd_message.raise_error;
2318: ELSIF ( p_time_definition_type = 'S' ) THEN

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

2311: ,p_time_definition_type) Then
2312:
2313: hr_utility.set_location('The user has passed some value to time definition type ', 20);
2314: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2315: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2316: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2317: fnd_message.raise_error;
2318: ELSIF ( p_time_definition_type = 'S' ) THEN
2319: IF (p_time_definition_id IS NOT NULL) THEN

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

2312:
2313: hr_utility.set_location('The user has passed some value to time definition type ', 20);
2314: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2315: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2316: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2317: fnd_message.raise_error;
2318: ELSIF ( p_time_definition_type = 'S' ) THEN
2319: IF (p_time_definition_id IS NOT NULL) THEN
2320: open csr_time_definition;

Line 2317: fnd_message.raise_error;

2313: hr_utility.set_location('The user has passed some value to time definition type ', 20);
2314: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
2315: fnd_message.set_token('COLUMN','TIME_DEFINITION_TYPE');
2316: fnd_message.set_token('LOOKUP_TYPE','PAY_TIME_DEFINITION_TYPE');
2317: fnd_message.raise_error;
2318: ELSIF ( p_time_definition_type = 'S' ) THEN
2319: IF (p_time_definition_id IS NOT NULL) THEN
2320: open csr_time_definition;
2321: fetch csr_time_definition into l_flag;

Line 2324: fnd_message.set_name('PAY','PAY_34056_FLSA_INV_TIME_DEF_ID');

2320: open csr_time_definition;
2321: fetch csr_time_definition into l_flag;
2322: If (csr_time_definition%notfound) then
2323: close csr_time_definition;
2324: fnd_message.set_name('PAY','PAY_34056_FLSA_INV_TIME_DEF_ID');
2325: fnd_message.raise_error;
2326: end if;
2327: close csr_time_definition;
2328: ELSE

Line 2325: fnd_message.raise_error;

2321: fetch csr_time_definition into l_flag;
2322: If (csr_time_definition%notfound) then
2323: close csr_time_definition;
2324: fnd_message.set_name('PAY','PAY_34056_FLSA_INV_TIME_DEF_ID');
2325: fnd_message.raise_error;
2326: end if;
2327: close csr_time_definition;
2328: ELSE
2329: fnd_message.set_name('PAY','PAY_34080_FLSA_STATIC_TIME');

Line 2329: fnd_message.set_name('PAY','PAY_34080_FLSA_STATIC_TIME');

2325: fnd_message.raise_error;
2326: end if;
2327: close csr_time_definition;
2328: ELSE
2329: fnd_message.set_name('PAY','PAY_34080_FLSA_STATIC_TIME');
2330: fnd_message.raise_error;
2331: END IF;
2332: ELSIF (nvl(p_time_definition_type, '-1') <> 'S' AND p_time_definition_id IS NOT NULL) THEN
2333: fnd_message.set_name('PAY','PAY_34052_FLSA_ARG_NOT_NULL');

Line 2330: fnd_message.raise_error;

2326: end if;
2327: close csr_time_definition;
2328: ELSE
2329: fnd_message.set_name('PAY','PAY_34080_FLSA_STATIC_TIME');
2330: fnd_message.raise_error;
2331: END IF;
2332: ELSIF (nvl(p_time_definition_type, '-1') <> 'S' AND p_time_definition_id IS NOT NULL) THEN
2333: fnd_message.set_name('PAY','PAY_34052_FLSA_ARG_NOT_NULL');
2334: fnd_message.set_token('ARGUMENT','TIME_DEFINITION_ID');

Line 2333: fnd_message.set_name('PAY','PAY_34052_FLSA_ARG_NOT_NULL');

2329: fnd_message.set_name('PAY','PAY_34080_FLSA_STATIC_TIME');
2330: fnd_message.raise_error;
2331: END IF;
2332: ELSIF (nvl(p_time_definition_type, '-1') <> 'S' AND p_time_definition_id IS NOT NULL) THEN
2333: fnd_message.set_name('PAY','PAY_34052_FLSA_ARG_NOT_NULL');
2334: fnd_message.set_token('ARGUMENT','TIME_DEFINITION_ID');
2335: fnd_message.raise_error;
2336: END IF;
2337: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 2334: fnd_message.set_token('ARGUMENT','TIME_DEFINITION_ID');

2330: fnd_message.raise_error;
2331: END IF;
2332: ELSIF (nvl(p_time_definition_type, '-1') <> 'S' AND p_time_definition_id IS NOT NULL) THEN
2333: fnd_message.set_name('PAY','PAY_34052_FLSA_ARG_NOT_NULL');
2334: fnd_message.set_token('ARGUMENT','TIME_DEFINITION_ID');
2335: fnd_message.raise_error;
2336: END IF;
2337: hr_utility.set_location('Leaving:'||l_proc, 10);
2338: --

Line 2335: fnd_message.raise_error;

2331: END IF;
2332: ELSIF (nvl(p_time_definition_type, '-1') <> 'S' AND p_time_definition_id IS NOT NULL) THEN
2333: fnd_message.set_name('PAY','PAY_34052_FLSA_ARG_NOT_NULL');
2334: fnd_message.set_token('ARGUMENT','TIME_DEFINITION_ID');
2335: fnd_message.raise_error;
2336: END IF;
2337: hr_utility.set_location('Leaving:'||l_proc, 10);
2338: --
2339: End chk_time_definition;

Line 2398: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');

2394: hr_utility.set_location('Entering:'||l_proc, 5);
2395: -- Parameter Vaidation
2396: -- check if the flag is not set but the id is passed
2397: If ( p_advance_payable = 'N' OR p_advance_payable is Null) and p_advance_element_type_id is not null then
2398: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');
2399: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Payable' );
2400: fnd_message.set_token('ADVANCE', 'Advance' );
2401: fnd_message.raise_error;
2402: end if;

Line 2399: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Payable' );

2395: -- Parameter Vaidation
2396: -- check if the flag is not set but the id is passed
2397: If ( p_advance_payable = 'N' OR p_advance_payable is Null) and p_advance_element_type_id is not null then
2398: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');
2399: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Payable' );
2400: fnd_message.set_token('ADVANCE', 'Advance' );
2401: fnd_message.raise_error;
2402: end if;
2403: --

Line 2400: fnd_message.set_token('ADVANCE', 'Advance' );

2396: -- check if the flag is not set but the id is passed
2397: If ( p_advance_payable = 'N' OR p_advance_payable is Null) and p_advance_element_type_id is not null then
2398: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');
2399: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Payable' );
2400: fnd_message.set_token('ADVANCE', 'Advance' );
2401: fnd_message.raise_error;
2402: end if;
2403: --
2404: If ( p_advance_deduction = 'N' OR p_advance_deduction is Null) and p_deduction_element_type_id is not null then

Line 2401: fnd_message.raise_error;

2397: If ( p_advance_payable = 'N' OR p_advance_payable is Null) and p_advance_element_type_id is not null then
2398: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');
2399: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Payable' );
2400: fnd_message.set_token('ADVANCE', 'Advance' );
2401: fnd_message.raise_error;
2402: end if;
2403: --
2404: If ( p_advance_deduction = 'N' OR p_advance_deduction is Null) and p_deduction_element_type_id is not null then
2405: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');

Line 2405: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');

2401: fnd_message.raise_error;
2402: end if;
2403: --
2404: If ( p_advance_deduction = 'N' OR p_advance_deduction is Null) and p_deduction_element_type_id is not null then
2405: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');
2406: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Deduction' );
2407: fnd_message.set_token('ADVANCE', 'Deduction' );
2408: fnd_message.raise_error;
2409: end if;

Line 2406: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Deduction' );

2402: end if;
2403: --
2404: If ( p_advance_deduction = 'N' OR p_advance_deduction is Null) and p_deduction_element_type_id is not null then
2405: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');
2406: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Deduction' );
2407: fnd_message.set_token('ADVANCE', 'Deduction' );
2408: fnd_message.raise_error;
2409: end if;
2410: --

Line 2407: fnd_message.set_token('ADVANCE', 'Deduction' );

2403: --
2404: If ( p_advance_deduction = 'N' OR p_advance_deduction is Null) and p_deduction_element_type_id is not null then
2405: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');
2406: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Deduction' );
2407: fnd_message.set_token('ADVANCE', 'Deduction' );
2408: fnd_message.raise_error;
2409: end if;
2410: --
2411: --

Line 2408: fnd_message.raise_error;

2404: If ( p_advance_deduction = 'N' OR p_advance_deduction is Null) and p_deduction_element_type_id is not null then
2405: fnd_message.set_name('PAY','PAY_33299_INVALID_ADVANCE_PAY');
2406: fnd_message.set_token('ADVANCE_PAYABLE', 'Advance Deduction' );
2407: fnd_message.set_token('ADVANCE', 'Deduction' );
2408: fnd_message.raise_error;
2409: end if;
2410: --
2411: --
2412: if p_datetrack_mode = 'INSERT' then

Line 2422: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');

2418: effective_end_date >= p_validation_end_date and
2419: p_effective_date between effective_start_date and effective_end_date;
2420:
2421: if l_count = 0 then
2422: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2423: fnd_message.set_token('ADVANCE', 'Advance' );
2424: fnd_message.raise_error;
2425: end if;
2426: end if;

Line 2423: fnd_message.set_token('ADVANCE', 'Advance' );

2419: p_effective_date between effective_start_date and effective_end_date;
2420:
2421: if l_count = 0 then
2422: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2423: fnd_message.set_token('ADVANCE', 'Advance' );
2424: fnd_message.raise_error;
2425: end if;
2426: end if;
2427: --

Line 2424: fnd_message.raise_error;

2420:
2421: if l_count = 0 then
2422: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2423: fnd_message.set_token('ADVANCE', 'Advance' );
2424: fnd_message.raise_error;
2425: end if;
2426: end if;
2427: --
2428: --Normal element with Deduction Element

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

2435: effective_end_date >= p_validation_end_date and
2436: p_effective_date between effective_start_date and effective_end_date;
2437:
2438: if l_count = 0 then
2439: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2440: fnd_message.set_token('ADVANCE', 'Deduction' );
2441: fnd_message.raise_error;
2442: end if;
2443: end if;

Line 2440: fnd_message.set_token('ADVANCE', 'Deduction' );

2436: p_effective_date between effective_start_date and effective_end_date;
2437:
2438: if l_count = 0 then
2439: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2440: fnd_message.set_token('ADVANCE', 'Deduction' );
2441: fnd_message.raise_error;
2442: end if;
2443: end if;
2444: -- No INSERT Validation For Advance Or Deduction Element

Line 2441: fnd_message.raise_error;

2437:
2438: if l_count = 0 then
2439: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2440: fnd_message.set_token('ADVANCE', 'Deduction' );
2441: fnd_message.raise_error;
2442: end if;
2443: end if;
2444: -- No INSERT Validation For Advance Or Deduction Element
2445: end if; -- end of Insert

Line 2459: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');

2455: effective_end_date >= p_validation_end_date and
2456: p_effective_date between effective_start_date and effective_end_date;
2457:
2458: if l_count = 0 then
2459: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2460: fnd_message.set_token('ADVANCE', 'Advance' );
2461: fnd_message.raise_error;
2462: end if;
2463: end if;

Line 2460: fnd_message.set_token('ADVANCE', 'Advance' );

2456: p_effective_date between effective_start_date and effective_end_date;
2457:
2458: if l_count = 0 then
2459: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2460: fnd_message.set_token('ADVANCE', 'Advance' );
2461: fnd_message.raise_error;
2462: end if;
2463: end if;
2464: --

Line 2461: fnd_message.raise_error;

2457:
2458: if l_count = 0 then
2459: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2460: fnd_message.set_token('ADVANCE', 'Advance' );
2461: fnd_message.raise_error;
2462: end if;
2463: end if;
2464: --
2465: -- UPDATE Validation For Normal Deduction Element

Line 2476: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');

2472: effective_end_date >= p_validation_end_date and
2473: p_effective_date between effective_start_date and effective_end_date;
2474:
2475: if l_count = 0 then
2476: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2477: fnd_message.set_token('ADVANCE', 'Deduction' );
2478: fnd_message.raise_error;
2479: end if;
2480: end if;

Line 2477: fnd_message.set_token('ADVANCE', 'Deduction' );

2473: p_effective_date between effective_start_date and effective_end_date;
2474:
2475: if l_count = 0 then
2476: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2477: fnd_message.set_token('ADVANCE', 'Deduction' );
2478: fnd_message.raise_error;
2479: end if;
2480: end if;
2481:

Line 2478: fnd_message.raise_error;

2474:
2475: if l_count = 0 then
2476: fnd_message.set_name('PAY','PAY_33739_INVALID_ADVANCE_ARG');
2477: fnd_message.set_token('ADVANCE', 'Deduction' );
2478: fnd_message.raise_error;
2479: end if;
2480: end if;
2481:
2482: -- No UPDATE Validation For Advance/Deduction Element

Line 2494: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');

2490: effective_start_date <= p_validation_start_date and
2491: effective_end_date >= p_validation_end_date;
2492:
2493: if l_count = 0 then
2494: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');
2495: fnd_message.set_token('ADVANCE', 'Advance' );
2496: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2497: fnd_message.raise_error;
2498: end if;

Line 2495: fnd_message.set_token('ADVANCE', 'Advance' );

2491: effective_end_date >= p_validation_end_date;
2492:
2493: if l_count = 0 then
2494: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');
2495: fnd_message.set_token('ADVANCE', 'Advance' );
2496: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2497: fnd_message.raise_error;
2498: end if;
2499: end if;

Line 2496: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);

2492:
2493: if l_count = 0 then
2494: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');
2495: fnd_message.set_token('ADVANCE', 'Advance' );
2496: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2497: fnd_message.raise_error;
2498: end if;
2499: end if;
2500: --

Line 2497: fnd_message.raise_error;

2493: if l_count = 0 then
2494: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');
2495: fnd_message.set_token('ADVANCE', 'Advance' );
2496: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2497: fnd_message.raise_error;
2498: end if;
2499: end if;
2500: --
2501: -- Delete Next Change Validation for Normal Deduction Element

Line 2510: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');

2506: effective_start_date <= p_validation_start_date and
2507: effective_end_date >= p_validation_end_date;
2508:
2509: if l_count = 0 then
2510: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');
2511: fnd_message.set_token('ADVANCE', 'Deduction' );
2512: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2513: fnd_message.raise_error;
2514: end if;

Line 2511: fnd_message.set_token('ADVANCE', 'Deduction' );

2507: effective_end_date >= p_validation_end_date;
2508:
2509: if l_count = 0 then
2510: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');
2511: fnd_message.set_token('ADVANCE', 'Deduction' );
2512: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2513: fnd_message.raise_error;
2514: end if;
2515: end if;

Line 2512: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);

2508:
2509: if l_count = 0 then
2510: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');
2511: fnd_message.set_token('ADVANCE', 'Deduction' );
2512: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2513: fnd_message.raise_error;
2514: end if;
2515: end if;
2516: end if; -- end of delete_next_change

Line 2513: fnd_message.raise_error;

2509: if l_count = 0 then
2510: fnd_message.set_name('PAY','PAY_33425_ADV_ELM_NCD');
2511: fnd_message.set_token('ADVANCE', 'Deduction' );
2512: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2513: fnd_message.raise_error;
2514: end if;
2515: end if;
2516: end if; -- end of delete_next_change
2517:

Line 2522: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');

2518: -- PURGE Mode For Advance Element.
2519: if p_datetrack_mode = 'ZAP' then
2520: select count(*) into l_count from pay_element_types_f where advance_element_type_id = p_element_type_id ;
2521: if l_count > 0 then
2522: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2523: fnd_message.set_token('ADVANCE', 'Advance' );
2524: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2525: fnd_message.raise_error;
2526: end if;

Line 2523: fnd_message.set_token('ADVANCE', 'Advance' );

2519: if p_datetrack_mode = 'ZAP' then
2520: select count(*) into l_count from pay_element_types_f where advance_element_type_id = p_element_type_id ;
2521: if l_count > 0 then
2522: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2523: fnd_message.set_token('ADVANCE', 'Advance' );
2524: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2525: fnd_message.raise_error;
2526: end if;
2527: --

Line 2524: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);

2520: select count(*) into l_count from pay_element_types_f where advance_element_type_id = p_element_type_id ;
2521: if l_count > 0 then
2522: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2523: fnd_message.set_token('ADVANCE', 'Advance' );
2524: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2525: fnd_message.raise_error;
2526: end if;
2527: --
2528: select count(*) into l_count from pay_element_types_f where deduction_element_type_id = p_element_type_id ;

Line 2525: fnd_message.raise_error;

2521: if l_count > 0 then
2522: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2523: fnd_message.set_token('ADVANCE', 'Advance' );
2524: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2525: fnd_message.raise_error;
2526: end if;
2527: --
2528: select count(*) into l_count from pay_element_types_f where deduction_element_type_id = p_element_type_id ;
2529: if l_count > 0 then

Line 2530: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');

2526: end if;
2527: --
2528: select count(*) into l_count from pay_element_types_f where deduction_element_type_id = p_element_type_id ;
2529: if l_count > 0 then
2530: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2531: fnd_message.set_token('ADVANCE', 'Deduction' );
2532: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2533: fnd_message.raise_error;
2534: end if;

Line 2531: fnd_message.set_token('ADVANCE', 'Deduction' );

2527: --
2528: select count(*) into l_count from pay_element_types_f where deduction_element_type_id = p_element_type_id ;
2529: if l_count > 0 then
2530: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2531: fnd_message.set_token('ADVANCE', 'Deduction' );
2532: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2533: fnd_message.raise_error;
2534: end if;
2535: end if;

Line 2532: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);

2528: select count(*) into l_count from pay_element_types_f where deduction_element_type_id = p_element_type_id ;
2529: if l_count > 0 then
2530: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2531: fnd_message.set_token('ADVANCE', 'Deduction' );
2532: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2533: fnd_message.raise_error;
2534: end if;
2535: end if;
2536: -- end of ZAP

Line 2533: fnd_message.raise_error;

2529: if l_count > 0 then
2530: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2531: fnd_message.set_token('ADVANCE', 'Deduction' );
2532: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2533: fnd_message.raise_error;
2534: end if;
2535: end if;
2536: -- end of ZAP
2537:

Line 2559: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');

2555: and effective_end_date <= p_validation_end_date)
2556: and p_effective_date between effective_start_date and effective_end_date;
2557: --
2558: if l_a_count > 0 OR l_d_count > 0 then
2559: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2560: fnd_message.set_token('ADVANCE', 'Advance or Deduction' );
2561: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2562: fnd_message.raise_error;
2563: end if;

Line 2560: fnd_message.set_token('ADVANCE', 'Advance or Deduction' );

2556: and p_effective_date between effective_start_date and effective_end_date;
2557: --
2558: if l_a_count > 0 OR l_d_count > 0 then
2559: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2560: fnd_message.set_token('ADVANCE', 'Advance or Deduction' );
2561: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2562: fnd_message.raise_error;
2563: end if;
2564: end if;

Line 2561: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);

2557: --
2558: if l_a_count > 0 OR l_d_count > 0 then
2559: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2560: fnd_message.set_token('ADVANCE', 'Advance or Deduction' );
2561: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2562: fnd_message.raise_error;
2563: end if;
2564: end if;
2565: --

Line 2562: fnd_message.raise_error;

2558: if l_a_count > 0 OR l_d_count > 0 then
2559: fnd_message.set_name('PAY','PAY_33450_ADVANCE_ELE_DELETE');
2560: fnd_message.set_token('ADVANCE', 'Advance or Deduction' );
2561: fnd_message.set_token('DELETE_MODE', p_datetrack_mode);
2562: fnd_message.raise_error;
2563: end if;
2564: end if;
2565: --
2566: end if;

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

2665: p_validation_end_date);
2666: --
2667: If l_element_links Then
2668: --
2669: fnd_message.set_name('PAY','PAY_6147_ELEMENT_LINK_UPDATE');
2670: fnd_message.raise_error;
2671: --
2672: End If;
2673: If (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag

Line 2670: fnd_message.raise_error;

2666: --
2667: If l_element_links Then
2668: --
2669: fnd_message.set_name('PAY','PAY_6147_ELEMENT_LINK_UPDATE');
2670: fnd_message.raise_error;
2671: --
2672: End If;
2673: If (p_adjustment_only_flag <> pay_etp_shd.g_old_rec.adjustment_only_flag
2674: )Then

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

2679: p_validation_end_date);
2680: --
2681: If l_indirect_results Then
2682: --
2683: fnd_message.set_name('PAY','PAY_34138_ELE_NO_ADJ_FRR_UPD');
2684: fnd_message.raise_error;
2685: --
2686: End If;
2687: --

Line 2684: fnd_message.raise_error;

2680: --
2681: If l_indirect_results Then
2682: --
2683: fnd_message.set_name('PAY','PAY_34138_ELE_NO_ADJ_FRR_UPD');
2684: fnd_message.raise_error;
2685: --
2686: End If;
2687: --
2688: End If;

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

2697: (p_element_type_id, p_validation_start_date, p_validation_end_date);
2698: --
2699: If l_run_results Then
2700: --
2701: fnd_message.set_name('PAY','PAY_6909_ELEMENT_NO_UPD_RR');
2702: fnd_message.raise_error;
2703: --
2704: End If;
2705: --

Line 2702: fnd_message.raise_error;

2698: --
2699: If l_run_results Then
2700: --
2701: fnd_message.set_name('PAY','PAY_6909_ELEMENT_NO_UPD_RR');
2702: fnd_message.raise_error;
2703: --
2704: End If;
2705: --
2706: End If;

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

2847: p_processing_priority,
2848: p_validation_start_date,
2849: p_validation_end_date) Then
2850: --
2851: fnd_message.set_name('PAY','PAY_6149_ELEMENT_PRIORITY_UPD');
2852: fnd_message.raise_error;
2853: --
2854: Elsif pay_element_types_pkg.cobra_benefits_exist
2855: (p_element_type_id,

Line 2852: fnd_message.raise_error;

2848: p_validation_start_date,
2849: p_validation_end_date) Then
2850: --
2851: fnd_message.set_name('PAY','PAY_6149_ELEMENT_PRIORITY_UPD');
2852: fnd_message.raise_error;
2853: --
2854: Elsif pay_element_types_pkg.cobra_benefits_exist
2855: (p_element_type_id,
2856: p_validation_start_date,

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

2855: (p_element_type_id,
2856: p_validation_start_date,
2857: p_validation_end_date) Then
2858: --
2859: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');
2860: fnd_message.raise_error;
2861: --
2862: End If;
2863: End If;

Line 2860: fnd_message.raise_error;

2856: p_validation_start_date,
2857: p_validation_end_date) Then
2858: --
2859: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');
2860: fnd_message.raise_error;
2861: --
2862: End If;
2863: End If;
2864: --

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

2868: (p_element_type_id,
2869: p_validation_start_date,
2870: p_validation_end_date) Then
2871: --
2872: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');
2873: fnd_message.raise_error;
2874: --
2875: Elsif pay_element_types_pkg.run_results_exist
2876: (p_element_type_id,

Line 2873: fnd_message.raise_error;

2869: p_validation_start_date,
2870: p_validation_end_date) Then
2871: --
2872: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');
2873: fnd_message.raise_error;
2874: --
2875: Elsif pay_element_types_pkg.run_results_exist
2876: (p_element_type_id,
2877: p_validation_start_date,

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

2876: (p_element_type_id,
2877: p_validation_start_date,
2878: p_validation_end_date) Then
2879: --
2880: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');
2881: fnd_message.raise_error;
2882: --
2883: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2884: --

Line 2881: fnd_message.raise_error;

2877: p_validation_start_date,
2878: p_validation_end_date) Then
2879: --
2880: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');
2881: fnd_message.raise_error;
2882: --
2883: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2884: --
2885: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');

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

2881: fnd_message.raise_error;
2882: --
2883: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2884: --
2885: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');
2886: fnd_message.raise_error;
2887: --
2888: End If;
2889: --

Line 2886: fnd_message.raise_error;

2882: --
2883: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2884: --
2885: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');
2886: fnd_message.raise_error;
2887: --
2888: End If;
2889: --
2890: End If;

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

2893: --
2894: If pay_element_types_pkg.element_is_in_an_element_set
2895: (p_element_type_id) Then
2896: --
2897: fnd_message.set_name('PAY','PAY_6713_ELEMENT_NO_DEL_RULE');
2898: fnd_message.raise_error;
2899: --
2900: Elsif pay_element_types_pkg.links_exist
2901: (p_element_type_id,

Line 2898: fnd_message.raise_error;

2894: If pay_element_types_pkg.element_is_in_an_element_set
2895: (p_element_type_id) Then
2896: --
2897: fnd_message.set_name('PAY','PAY_6713_ELEMENT_NO_DEL_RULE');
2898: fnd_message.raise_error;
2899: --
2900: Elsif pay_element_types_pkg.links_exist
2901: (p_element_type_id,
2902: p_validation_start_date,

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

2901: (p_element_type_id,
2902: p_validation_start_date,
2903: p_validation_end_date) Then
2904: --
2905: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');
2906: fnd_message.raise_error;
2907: --
2908: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2909: --

Line 2906: fnd_message.raise_error;

2902: p_validation_start_date,
2903: p_validation_end_date) Then
2904: --
2905: fnd_message.set_name('PAY','PAY_6155_ELEMENT_NO_DEL_LINK');
2906: fnd_message.raise_error;
2907: --
2908: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2909: --
2910: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');

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

2906: fnd_message.raise_error;
2907: --
2908: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2909: --
2910: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');
2911: fnd_message.raise_error;
2912: --
2913: Elsif accrual_plan_exists(p_element_type_id) Then
2914: --

Line 2911: fnd_message.raise_error;

2907: --
2908: Elsif pay_element_types_pkg.stop_entry_rules_exist(p_element_type_id) Then
2909: --
2910: fnd_message.set_name('PAY','PAY_6157_ELEMENT_NO_DEL_FRR');
2911: fnd_message.raise_error;
2912: --
2913: Elsif accrual_plan_exists(p_element_type_id) Then
2914: --
2915: fnd_message.set_name('PAY','PAY_34142_ELE_NO_DEL_ACCRUAL');

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

2911: fnd_message.raise_error;
2912: --
2913: Elsif accrual_plan_exists(p_element_type_id) Then
2914: --
2915: fnd_message.set_name('PAY','PAY_34142_ELE_NO_DEL_ACCRUAL');
2916: fnd_message.raise_error;
2917: --
2918: Elsif pay_element_types_pkg.run_results_exist
2919: (p_element_type_id,

Line 2916: fnd_message.raise_error;

2912: --
2913: Elsif accrual_plan_exists(p_element_type_id) Then
2914: --
2915: fnd_message.set_name('PAY','PAY_34142_ELE_NO_DEL_ACCRUAL');
2916: fnd_message.raise_error;
2917: --
2918: Elsif pay_element_types_pkg.run_results_exist
2919: (p_element_type_id,
2920: p_validation_start_date,

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

2919: (p_element_type_id,
2920: p_validation_start_date,
2921: p_validation_end_date) Then
2922: --
2923: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');
2924: fnd_message.raise_error;
2925: --
2926: Elsif benefit_contributions_exist
2927: (p_element_type_id,

Line 2924: fnd_message.raise_error;

2920: p_validation_start_date,
2921: p_validation_end_date) Then
2922: --
2923: fnd_message.set_name('PAY','PAY_6242_ELEMENTS_NO_DEL_RR');
2924: fnd_message.raise_error;
2925: --
2926: Elsif benefit_contributions_exist
2927: (p_element_type_id,
2928: p_validation_start_date,

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

2927: (p_element_type_id,
2928: p_validation_start_date,
2929: p_validation_end_date) Then
2930: --
2931: fnd_message.set_name('PAY','PAY_34140_ELE_BEN_CONT_NO_DEL');
2932: fnd_message.raise_error;
2933: --
2934: Elsif pay_element_types_pkg.cobra_benefits_exist
2935: (p_element_type_id,

Line 2932: fnd_message.raise_error;

2928: p_validation_start_date,
2929: p_validation_end_date) Then
2930: --
2931: fnd_message.set_name('PAY','PAY_34140_ELE_BEN_CONT_NO_DEL');
2932: fnd_message.raise_error;
2933: --
2934: Elsif pay_element_types_pkg.cobra_benefits_exist
2935: (p_element_type_id,
2936: p_validation_start_date,

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

2935: (p_element_type_id,
2936: p_validation_start_date,
2937: p_validation_end_date) Then
2938: --
2939: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');
2940: fnd_message.raise_error;
2941: --
2942: Elsif element_used_as_pay_basis(p_element_type_id) Then
2943: --

Line 2940: fnd_message.raise_error;

2936: p_validation_start_date,
2937: p_validation_end_date) Then
2938: --
2939: fnd_message.set_name('PAY','PAY_COBRA_BENS_NO_DEL');
2940: fnd_message.raise_error;
2941: --
2942: Elsif element_used_as_pay_basis(p_element_type_id) Then
2943: --
2944: fnd_message.set_name('PAY','PAY_6965_INPVAL_NO_DEL_SB');

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

2940: fnd_message.raise_error;
2941: --
2942: Elsif element_used_as_pay_basis(p_element_type_id) Then
2943: --
2944: fnd_message.set_name('PAY','PAY_6965_INPVAL_NO_DEL_SB');
2945: fnd_message.raise_error;
2946: --
2947: End If;
2948: End If;

Line 2945: fnd_message.raise_error;

2941: --
2942: Elsif element_used_as_pay_basis(p_element_type_id) Then
2943: --
2944: fnd_message.set_name('PAY','PAY_6965_INPVAL_NO_DEL_SB');
2945: fnd_message.raise_error;
2946: --
2947: End If;
2948: End If;
2949: --