DBA Data[Home] [Help]

APPS.IRC_REFERRAL_INFO_API dependencies on HR_UTILITY

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

65: l_start_date date;
66: l_end_date date;
67: l_effective_date date;
68: begin
69: hr_utility.set_location('Entering:'|| l_proc, 10);
70: --
71: -- Issue a savepoint
72: --
73: savepoint create_referral_info;

Line 249: hr_utility.set_location(' Leaving:'||l_proc, 70);

245: p_object_version_number := l_object_version_number;
246: p_start_date := l_start_date;
247: p_end_date := l_end_date;
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 70);
250: exception
251: when hr_api.validate_enabled then
252: --
253: -- As the Validate_Enabled exception has been raised

Line 266: hr_utility.set_location(' Leaving:'||l_proc, 80);

262: p_referral_info_id := null;
263: p_object_version_number := null;
264: p_start_date := null;
265: p_end_date := null;
266: hr_utility.set_location(' Leaving:'||l_proc, 80);
267: when others then
268: --
269: -- A validation or unexpected error has occured
270: --

Line 280: hr_utility.set_location(' Leaving:'||l_proc, 90);

276: p_referral_info_id := null;
277: p_object_version_number := null;
278: p_start_date := null;
279: p_end_date := null;
280: hr_utility.set_location(' Leaving:'||l_proc, 90);
281: raise;
282: end create_referral_info;
283: --
284: --

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

338: l_end_date date;
339: l_effective_date date;
340: l_proc varchar2(72) := g_package||'update_referral_info';
341: begin
342: hr_utility.set_location('Entering:'|| l_proc, 10);
343: --
344: -- Issue a savepoint
345: --
346: savepoint update_referral_info;

Line 519: hr_utility.set_location(' Leaving:'||l_proc, 70);

515: p_object_version_number := l_object_version_number;
516: p_start_date := l_start_date;
517: p_end_date := l_end_date;
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 70);
520: exception
521: when hr_api.validate_enabled then
522: --
523: -- As the Validate_Enabled exception has been raised

Line 534: hr_utility.set_location(' Leaving:'||l_proc, 80);

530: -- when validation only mode is being used.)
531: --
532: p_start_date := null;
533: p_end_date := null;
534: hr_utility.set_location(' Leaving:'||l_proc, 80);
535: when others then
536: --
537: -- A validation or unexpected error has occured
538: --

Line 546: hr_utility.set_location(' Leaving:'||l_proc, 90);

542: -- OUT parameters, including warnings, to null
543: --
544: p_start_date := null;
545: p_end_date := null;
546: hr_utility.set_location(' Leaving:'||l_proc, 90);
547: raise;
548: end update_referral_info;
549: --
550: --

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

570: --
571: Cursor C_Sel1 is select irc_referral_info_s.nextval from sys.dual;
572: --
573: begin
574: hr_utility.set_location('Entering:'|| l_proc, 10);
575: --
576: -- Issue a savepoint
577: --
578: savepoint copy_referral_details;

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

683: --
684: END LOOP;
685: --
686: --
687: hr_utility.set_location(' Leaving:'||l_proc, 20);
688: exception
689: when hr_api.validate_enabled then
690: --
691: -- As the Validate_Enabled exception has been raised

Line 696: hr_utility.set_location(' Leaving:'||l_proc, 30);

692: -- we must rollback to the savepoint
693: --
694: rollback to copy_referral_details;
695: --
696: hr_utility.set_location(' Leaving:'||l_proc, 30);
697: when others then
698: --
699: -- A validation or unexpected error has occured
700: --

Line 703: hr_utility.set_location(' Leaving:'||l_proc, 40);

699: -- A validation or unexpected error has occured
700: --
701: rollback to copy_referral_details;
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 40);
704: raise;
705: end copy_referral_details;
706: --
707: end IRC_REFERRAL_INFO_API;