24: l_tfh_superseded_flag varchar2(30);
25: l_tfh_cancelled_flag varchar2(30);
26: Begin
27: --
28: hr_utility.set_location('Entering:'||l_proc, 5);
29: --
30: --
31: ota_tfl_api_business_rules.get_finance_header
32: (p_rec.finance_header_id
96: , p_booking_deal_id => p_rec.booking_deal_id
97: , p_finance_header_id => p_rec.finance_header_id
98: );
99: --
100: hr_utility.trace('Date Raised '||to_char(p_rec.date_raised,'DD-MON-YYYY'));
101: ota_tfl_api_business_rules.get_date_raised
102: ( p_rec.finance_header_id
103: , p_rec.date_raised );
104: --
106: ( p_rec.finance_header_id
107: , p_rec.sequence_number );
108: --
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: --
112: End insert_validate;
113: --
114: -- ----------------------------------------------------------------------------
182: l_tfh_transfer_status varchar2(30);
183: l_tfh_superseded_flag varchar2(30);
184: l_tfh_cancelled_flag varchar2(30);
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: hr_utility.trace(p_transaction_type);
188: --
189: -- Call all supporting business operations
190: --
183: l_tfh_superseded_flag varchar2(30);
184: l_tfh_cancelled_flag varchar2(30);
185: Begin
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: hr_utility.trace(p_transaction_type);
188: --
189: -- Call all supporting business operations
190: --
191: -- p_rec can only be IN parameter !!
342: , p_booking_deal_id => p_rec.booking_deal_id
343: , p_finance_header_id => p_rec.finance_header_id
344: );
345: --
346: hr_utility.set_location(' Leaving:'||l_proc, 10);
347: --
348: End update_validate;
349: --
350: -- ----------------------------------------------------------------------------
354: --
355: l_proc varchar2(72) := g_package||'delete_validate';
356: --
357: Begin
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: --
360: -- Call all supporting business operations
361: -- Do Not allow deletion if Finance Line Transfer_status = 'ST'
362: --
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;
370: --
371: -- ---------------------------------------------------------------------------
372: -- |----------------------< set_security_group_id >--------------------------|
399: l_legislation_code varchar2(150);
400: --
401: begin
402: --
403: hr_utility.set_location('Entering:'|| l_proc, 10);
404: --
405: -- Ensure that all the mandatory parameter are not null
406: --
407: hr_api.mandatory_arg_error
439: --
440: hr_api.set_legislation_context(l_legislation_code);
441: end if;
442: --
443: hr_utility.set_location(' Leaving:'|| l_proc, 20);
444: --
445: end set_security_group_id;
446:
447: -- ----------------------------------------------------------------------------
496: l_proc varchar2(72) := g_package||'return_legislation_code';
497: l_legislation_code varchar2(150);
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Ensure that all the mandatory parameters are not null
503: --
504: hr_api.mandatory_arg_error (p_api_name => l_proc,
510: close csr_leg_code;
511: --
512: -- The primary key is invalid therefore we must error out
513: --
514: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
515: hr_utility.raise_error;
516: end if;
517: --
518: close csr_leg_code;
511: --
512: -- The primary key is invalid therefore we must error out
513: --
514: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
515: hr_utility.raise_error;
516: end if;
517: --
518: close csr_leg_code;
519: return l_legislation_code;
517: --
518: close csr_leg_code;
519: return l_legislation_code;
520: --
521: hr_utility.set_location(' Leaving:'||l_proc, 10);
522: --
523: End return_legislation_code;
524:
525: