59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'GRADE_SPINE_ID')
67: );
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
839: (p_grade_spine_id => p_rec.grade_spine_id
840: ,p_effective_date => p_effective_date
841: ,p_object_version_number => p_rec.object_version_number
842: ) THEN
843: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
844: fnd_message.set_token('PROCEDURE ', l_proc);
845: fnd_message.set_token('STEP ', '5');
846: fnd_message.raise_error;
847: END IF;
840: ,p_effective_date => p_effective_date
841: ,p_object_version_number => p_rec.object_version_number
842: ) THEN
843: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
844: fnd_message.set_token('PROCEDURE ', l_proc);
845: fnd_message.set_token('STEP ', '5');
846: fnd_message.raise_error;
847: END IF;
848:
841: ,p_object_version_number => p_rec.object_version_number
842: ) THEN
843: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
844: fnd_message.set_token('PROCEDURE ', l_proc);
845: fnd_message.set_token('STEP ', '5');
846: fnd_message.raise_error;
847: END IF;
848:
849: --
842: ) THEN
843: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
844: fnd_message.set_token('PROCEDURE ', l_proc);
845: fnd_message.set_token('STEP ', '5');
846: fnd_message.raise_error;
847: END IF;
848:
849: --
850: -- Check business_group_id is not updated
954: --
955: -- An unhandled or unexpected error has occurred which
956: -- we must report
957: --
958: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
959: fnd_message.set_token('PROCEDURE', l_proc);
960: fnd_message.set_token('STEP','15');
961: fnd_message.raise_error;
962: End dt_update_validate;
955: -- An unhandled or unexpected error has occurred which
956: -- we must report
957: --
958: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
959: fnd_message.set_token('PROCEDURE', l_proc);
960: fnd_message.set_token('STEP','15');
961: fnd_message.raise_error;
962: End dt_update_validate;
963: --
956: -- we must report
957: --
958: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
959: fnd_message.set_token('PROCEDURE', l_proc);
960: fnd_message.set_token('STEP','15');
961: fnd_message.raise_error;
962: End dt_update_validate;
963: --
964: -- ----------------------------------------------------------------------------
957: --
958: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
959: fnd_message.set_token('PROCEDURE', l_proc);
960: fnd_message.set_token('STEP','15');
961: fnd_message.raise_error;
962: End dt_update_validate;
963: --
964: -- ----------------------------------------------------------------------------
965: -- |--------------------------< dt_delete_validate >--------------------------|
1052: ,p_base_key_value => p_grade_spine_id
1053: ,p_from_date => p_validation_start_date
1054: ,p_to_date => p_validation_end_date
1055: )) Then
1056: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1057: fnd_message.set_token('TABLE_NAME','spinal point steps');
1058: hr_multi_message.add;
1059: End If;
1060: If (dt_api.rows_exist
1053: ,p_from_date => p_validation_start_date
1054: ,p_to_date => p_validation_end_date
1055: )) Then
1056: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1057: fnd_message.set_token('TABLE_NAME','spinal point steps');
1058: hr_multi_message.add;
1059: End If;
1060: If (dt_api.rows_exist
1061: (p_base_table_name => 'per_cagr_entitlement_lines_f'
1063: ,p_base_key_value => p_grade_spine_id
1064: ,p_from_date => p_validation_start_date
1065: ,p_to_date => p_validation_end_date
1066: )) Then
1067: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1068: fnd_message.set_token('TABLE_NAME','cagr entitlement lines');
1069: hr_multi_message.add;
1070: End If;
1071: */
1064: ,p_from_date => p_validation_start_date
1065: ,p_to_date => p_validation_end_date
1066: )) Then
1067: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1068: fnd_message.set_token('TABLE_NAME','cagr entitlement lines');
1069: hr_multi_message.add;
1070: End If;
1071: */
1072: --
1077: --
1078: -- An unhandled or unexpected error has occurred which
1079: -- we must report
1080: --
1081: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1082: fnd_message.set_token('PROCEDURE', l_proc);
1083: fnd_message.set_token('STEP','15');
1084: fnd_message.raise_error;
1085: --
1078: -- An unhandled or unexpected error has occurred which
1079: -- we must report
1080: --
1081: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1082: fnd_message.set_token('PROCEDURE', l_proc);
1083: fnd_message.set_token('STEP','15');
1084: fnd_message.raise_error;
1085: --
1086: End dt_delete_validate;
1079: -- we must report
1080: --
1081: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1082: fnd_message.set_token('PROCEDURE', l_proc);
1083: fnd_message.set_token('STEP','15');
1084: fnd_message.raise_error;
1085: --
1086: End dt_delete_validate;
1087: --
1080: --
1081: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1082: fnd_message.set_token('PROCEDURE', l_proc);
1083: fnd_message.set_token('STEP','15');
1084: fnd_message.raise_error;
1085: --
1086: End dt_delete_validate;
1087: --
1088: -- ----------------------------------------------------------------------------