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: IF NOT pay_bth_shd.api_updating
191: (p_batch_id => p_rec.batch_id
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PAY', '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_batch_id => p_rec.batch_id
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PAY', '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('PAY', '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('PAY', '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: --
261: fetch csr_status into l_status;
262: close csr_status;
263:
264: if l_status = 'T' then
265: Fnd_Message.Set_Name('PER', 'HR_289754_BEE_REC_TRANSFERRED');
266: fnd_message.raise_error;
267: elsif l_status = 'P' then
268: Fnd_Message.Set_Name('PER', 'HR_51321_BATCH_AFTER_SUBMITION');
269: fnd_message.raise_error;
262: close csr_status;
263:
264: if l_status = 'T' then
265: Fnd_Message.Set_Name('PER', 'HR_289754_BEE_REC_TRANSFERRED');
266: fnd_message.raise_error;
267: elsif l_status = 'P' then
268: Fnd_Message.Set_Name('PER', 'HR_51321_BATCH_AFTER_SUBMITION');
269: fnd_message.raise_error;
270: end if;
264: if l_status = 'T' then
265: Fnd_Message.Set_Name('PER', 'HR_289754_BEE_REC_TRANSFERRED');
266: fnd_message.raise_error;
267: elsif l_status = 'P' then
268: Fnd_Message.Set_Name('PER', 'HR_51321_BATCH_AFTER_SUBMITION');
269: fnd_message.raise_error;
270: end if;
271: --
272: End chk_transferred_status;
265: Fnd_Message.Set_Name('PER', 'HR_289754_BEE_REC_TRANSFERRED');
266: fnd_message.raise_error;
267: elsif l_status = 'P' then
268: Fnd_Message.Set_Name('PER', 'HR_51321_BATCH_AFTER_SUBMITION');
269: fnd_message.raise_error;
270: end if;
271: --
272: End chk_transferred_status;
273: --
1050: If csr_batch_lines_exists%found Then
1051: --
1052: close csr_batch_lines_exists;
1053: --
1054: fnd_message.set_name('PAY','PAY_52681_BHT_CHILD_EXISTS');
1055: fnd_message.raise_error;
1056: --
1057: End If;
1058: --
1051: --
1052: close csr_batch_lines_exists;
1053: --
1054: fnd_message.set_name('PAY','PAY_52681_BHT_CHILD_EXISTS');
1055: fnd_message.raise_error;
1056: --
1057: End If;
1058: --
1059: close csr_batch_lines_exists;
1067: If csr_batch_ctl_totals_exists%found Then
1068: --
1069: close csr_batch_ctl_totals_exists;
1070: --
1071: fnd_message.set_name('PAY','PAY_52681_BHT_CHILD_EXISTS');
1072: fnd_message.raise_error;
1073: --
1074: End If;
1075: --
1068: --
1069: close csr_batch_ctl_totals_exists;
1070: --
1071: fnd_message.set_name('PAY','PAY_52681_BHT_CHILD_EXISTS');
1072: fnd_message.raise_error;
1073: --
1074: End If;
1075: --
1076: close csr_batch_ctl_totals_exists;
1084: If csr_message_lines%found Then
1085: --
1086: close csr_message_lines;
1087: --
1088: fnd_message.set_name('PAY','PAY_52681_BHT_CHILD_EXISTS');
1089: fnd_message.raise_error;
1090: --
1091: End If;
1092: --
1085: --
1086: close csr_message_lines;
1087: --
1088: fnd_message.set_name('PAY','PAY_52681_BHT_CHILD_EXISTS');
1089: fnd_message.raise_error;
1090: --
1091: End If;
1092: --
1093: close csr_message_lines;