DBA Data[Home] [Help]

APPS.OTA_TFL_API_BUS dependencies on HR_UTILITY

Line 28: hr_utility.set_location('Entering:'||l_proc, 5);

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

Line 100: hr_utility.trace('Date Raised '||to_char(p_rec.date_raised,'DD-MON-YYYY'));

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: --

Line 110: hr_utility.set_location(' Leaving:'||l_proc, 10);

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: -- ----------------------------------------------------------------------------

Line 186: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 187: hr_utility.trace(p_transaction_type);

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 !!

Line 346: hr_utility.set_location(' Leaving:'||l_proc, 10);

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: -- ----------------------------------------------------------------------------

Line 358: hr_utility.set_location('Entering:'||l_proc, 5);

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: --

Line 368: hr_utility.set_location(' Leaving:'||l_proc, 10);

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 >--------------------------|

Line 403: hr_utility.set_location('Entering:'|| l_proc, 10);

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

Line 443: hr_utility.set_location(' Leaving:'|| l_proc, 20);

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: -- ----------------------------------------------------------------------------

Line 500: hr_utility.set_location('Entering:'||l_proc, 5);

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,

Line 514: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

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;

Line 515: hr_utility.raise_error;

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;

Line 521: hr_utility.set_location(' Leaving:'||l_proc, 10);

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: