55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --
128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
190: (p_run_type_usage_id => p_rec.run_type_usage_id
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: hr_utility.set_location(l_proc, 10);
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: hr_utility.set_location(l_proc, 10);
201: --
910: --
911: -- A referential integrity check was violated therefore
912: -- we must error
913: --
914: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
915: fnd_message.set_token('TABLE_NAME', l_table_name);
916: fnd_message.raise_error;
917: When Others Then
918: --
911: -- A referential integrity check was violated therefore
912: -- we must error
913: --
914: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
915: fnd_message.set_token('TABLE_NAME', l_table_name);
916: fnd_message.raise_error;
917: When Others Then
918: --
919: -- An unhandled or unexpected error has occurred which
912: -- we must error
913: --
914: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
915: fnd_message.set_token('TABLE_NAME', l_table_name);
916: fnd_message.raise_error;
917: When Others Then
918: --
919: -- An unhandled or unexpected error has occurred which
920: -- we must report
918: --
919: -- An unhandled or unexpected error has occurred which
920: -- we must report
921: --
922: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
923: fnd_message.set_token('PROCEDURE', l_proc);
924: fnd_message.set_token('STEP','15');
925: fnd_message.raise_error;
926: End dt_update_validate;
919: -- An unhandled or unexpected error has occurred which
920: -- we must report
921: --
922: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
923: fnd_message.set_token('PROCEDURE', l_proc);
924: fnd_message.set_token('STEP','15');
925: fnd_message.raise_error;
926: End dt_update_validate;
927: --
920: -- we must report
921: --
922: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
923: fnd_message.set_token('PROCEDURE', l_proc);
924: fnd_message.set_token('STEP','15');
925: fnd_message.raise_error;
926: End dt_update_validate;
927: --
928: -- ----------------------------------------------------------------------------
921: --
922: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
923: fnd_message.set_token('PROCEDURE', l_proc);
924: fnd_message.set_token('STEP','15');
925: fnd_message.raise_error;
926: End dt_update_validate;
927: --
928: -- ----------------------------------------------------------------------------
929: -- |--------------------------< dt_delete_validate >--------------------------|
1017: --
1018: -- A referential integrity check was violated therefore
1019: -- we must error
1020: --
1021: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1022: fnd_message.set_token('TABLE_NAME', l_table_name);
1023: fnd_message.raise_error;
1024: When Others Then
1025: --
1018: -- A referential integrity check was violated therefore
1019: -- we must error
1020: --
1021: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1022: fnd_message.set_token('TABLE_NAME', l_table_name);
1023: fnd_message.raise_error;
1024: When Others Then
1025: --
1026: -- An unhandled or unexpected error has occurred which
1019: -- we must error
1020: --
1021: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1022: fnd_message.set_token('TABLE_NAME', l_table_name);
1023: fnd_message.raise_error;
1024: When Others Then
1025: --
1026: -- An unhandled or unexpected error has occurred which
1027: -- we must report
1025: --
1026: -- An unhandled or unexpected error has occurred which
1027: -- we must report
1028: --
1029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1030: fnd_message.set_token('PROCEDURE', l_proc);
1031: fnd_message.set_token('STEP','15');
1032: fnd_message.raise_error;
1033: --
1026: -- An unhandled or unexpected error has occurred which
1027: -- we must report
1028: --
1029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1030: fnd_message.set_token('PROCEDURE', l_proc);
1031: fnd_message.set_token('STEP','15');
1032: fnd_message.raise_error;
1033: --
1034: End dt_delete_validate;
1027: -- we must report
1028: --
1029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1030: fnd_message.set_token('PROCEDURE', l_proc);
1031: fnd_message.set_token('STEP','15');
1032: fnd_message.raise_error;
1033: --
1034: End dt_delete_validate;
1035: --
1028: --
1029: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1030: fnd_message.set_token('PROCEDURE', l_proc);
1031: fnd_message.set_token('STEP','15');
1032: fnd_message.raise_error;
1033: --
1034: End dt_delete_validate;
1035: --
1036: -- ----------------------------------------------------------------------------