221: --
222: if p_transaction_type not in
223: ('CANCEL_LINE','REINSTATE_LINE','REINSTATE_HEADER_LINE') then
224: if l_cancelled_flag_changed then
225: fnd_message.set_name('OTA','OTA_13356_TFL_CANCELLED_FLAG');
226: fnd_message.raise_error;
227: end if;
228: end if;
229: /*
222: if p_transaction_type not in
223: ('CANCEL_LINE','REINSTATE_LINE','REINSTATE_HEADER_LINE') then
224: if l_cancelled_flag_changed then
225: fnd_message.set_name('OTA','OTA_13356_TFL_CANCELLED_FLAG');
226: fnd_message.raise_error;
227: end if;
228: end if;
229: /*
230: ota_tfl_api_business_rules.check_update_cancelled_flag
239: --
240: if p_transaction_type not in
241: ('REINSTATE_LINE','REINSTATE_HEADER_LINE') then
242: if p_rec.cancelled_flag = 'Y' then
243: fnd_message.set_name('OTA','OTA_13488_TFL_CANCELLED');
244: fnd_message.raise_error;
245: end if;
246: end if;
247: --
240: if p_transaction_type not in
241: ('REINSTATE_LINE','REINSTATE_HEADER_LINE') then
242: if p_rec.cancelled_flag = 'Y' then
243: fnd_message.set_name('OTA','OTA_13488_TFL_CANCELLED');
244: fnd_message.raise_error;
245: end if;
246: end if;
247: --
248: if l_line_type_changed then
245: end if;
246: end if;
247: --
248: if l_line_type_changed then
249: fnd_message.set_name('OTA','OTA_13354_TFL_NO_TYPE_UPDATE');
250: fnd_message.raise_error;
251: end if;
252: --
253: if (l_cancelled_flag_changed and
246: end if;
247: --
248: if l_line_type_changed then
249: fnd_message.set_name('OTA','OTA_13354_TFL_NO_TYPE_UPDATE');
250: fnd_message.raise_error;
251: end if;
252: --
253: if (l_cancelled_flag_changed and
254: p_rec.cancelled_flag = 'N')
360: -- Call all supporting business operations
361: -- Do Not allow deletion if Finance Line Transfer_status = 'ST'
362: --
363: if ota_tfl_api_shd.g_old_rec.transfer_status = 'ST' then
364: fnd_message.set_name('OTA','OTA_13610_TFL_DELETE_CHK');
365: fnd_message.raise_error;
366: end if;
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 10);
361: -- Do Not allow deletion if Finance Line Transfer_status = 'ST'
362: --
363: if ota_tfl_api_shd.g_old_rec.transfer_status = 'ST' then
364: fnd_message.set_name('OTA','OTA_13610_TFL_DELETE_CHK');
365: fnd_message.raise_error;
366: end if;
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 10);
369: End delete_validate;
419: close csr_sec_grp;
420: --
421: -- The primary key is invalid therefore we must error
422: --
423: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
424: hr_multi_message.add
425: (p_associated_column1
426: => nvl(p_associated_column1,'FINANCE_LINE_ID')
427: );