DBA Data[Home] [Help]

APPS.PAY_PAY_SHD dependencies on HR_API

Line 554: hr_api.mandatory_arg_error(p_api_name => l_proc

550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: -- Ensure that all the mandatory arguments are not null
553: --
554: hr_api.mandatory_arg_error(p_api_name => l_proc
555: ,p_argument => 'effective_date'
556: ,p_argument_value => p_effective_date
557: );
558: --

Line 559: hr_api.mandatory_arg_error(p_api_name => l_proc

555: ,p_argument => 'effective_date'
556: ,p_argument_value => p_effective_date
557: );
558: --
559: hr_api.mandatory_arg_error(p_api_name => l_proc
560: ,p_argument => 'datetrack_mode'
561: ,p_argument_value => p_datetrack_mode
562: );
563: --

Line 564: hr_api.mandatory_arg_error(p_api_name => l_proc

560: ,p_argument => 'datetrack_mode'
561: ,p_argument_value => p_datetrack_mode
562: );
563: --
564: hr_api.mandatory_arg_error(p_api_name => l_proc
565: ,p_argument => 'payroll_id'
566: ,p_argument_value => p_payroll_id
567: );
568:

Line 569: if (p_datetrack_mode = hr_api.g_insert) then

565: ,p_argument => 'payroll_id'
566: ,p_argument_value => p_payroll_id
567: );
568:
569: if (p_datetrack_mode = hr_api.g_insert) then
570: hr_api.mandatory_arg_error(p_api_name => l_proc
571: ,p_argument => 'object_version_number'
572: ,p_argument_value => p_object_version_number
573: );

Line 570: hr_api.mandatory_arg_error(p_api_name => l_proc

566: ,p_argument_value => p_payroll_id
567: );
568:
569: if (p_datetrack_mode = hr_api.g_insert) then
570: hr_api.mandatory_arg_error(p_api_name => l_proc
571: ,p_argument => 'object_version_number'
572: ,p_argument_value => p_object_version_number
573: );
574: end if;

Line 579: If (p_datetrack_mode <> hr_api.g_insert) then

575:
576: --
577: -- Check to ensure the datetrack mode is not INSERT.
578: --
579: If (p_datetrack_mode <> hr_api.g_insert) then
580: --
581: -- We must select and lock the current row.
582: --
583: Open C_Sel1;

Line 598: hr_api.mandatory_arg_error(p_api_name => l_proc

594: End If;
595: Close C_Sel1;
596:
597: if (pay_pay_shd.g_old_rec.object_version_number is not null) then
598: hr_api.mandatory_arg_error(p_api_name => l_proc
599: ,p_argument => 'object_version_number'
600: ,p_argument_value => p_object_version_number
601: );
602: end if;

Line 616: (p_datetrack_mode = hr_api.g_update or

612: -- Providing we are doing an update and a comment_id exists then
613: -- we select the comment text.
614: --
615: If ((pay_pay_shd.g_old_rec.comment_id is not null) and
616: (p_datetrack_mode = hr_api.g_update or
617: p_datetrack_mode = hr_api.g_correction or
618: p_datetrack_mode = hr_api.g_update_override or
619: p_datetrack_mode = hr_api.g_update_change_insert)) then
620: --

Line 617: p_datetrack_mode = hr_api.g_correction or

613: -- we select the comment text.
614: --
615: If ((pay_pay_shd.g_old_rec.comment_id is not null) and
616: (p_datetrack_mode = hr_api.g_update or
617: p_datetrack_mode = hr_api.g_correction or
618: p_datetrack_mode = hr_api.g_update_override or
619: p_datetrack_mode = hr_api.g_update_change_insert)) then
620: --
621: Open C_Sel3;

Line 618: p_datetrack_mode = hr_api.g_update_override or

614: --
615: If ((pay_pay_shd.g_old_rec.comment_id is not null) and
616: (p_datetrack_mode = hr_api.g_update or
617: p_datetrack_mode = hr_api.g_correction or
618: p_datetrack_mode = hr_api.g_update_override or
619: p_datetrack_mode = hr_api.g_update_change_insert)) then
620: --
621: Open C_Sel3;
622: Fetch C_Sel3 Into pay_pay_shd.g_old_rec.comments;

Line 619: p_datetrack_mode = hr_api.g_update_change_insert)) then

615: If ((pay_pay_shd.g_old_rec.comment_id is not null) and
616: (p_datetrack_mode = hr_api.g_update or
617: p_datetrack_mode = hr_api.g_correction or
618: p_datetrack_mode = hr_api.g_update_override or
619: p_datetrack_mode = hr_api.g_update_change_insert)) then
620: --
621: Open C_Sel3;
622: Fetch C_Sel3 Into pay_pay_shd.g_old_rec.comments;
623: If C_Sel3%notfound then

Line 690: When HR_Api.Object_Locked then

686: --
687: -- We need to trap the ORA LOCK exception
688: --
689: Exception
690: When HR_Api.Object_Locked then
691: --
692: -- The object is locked therefore we need to supply a meaningful
693: -- error message.
694: --