DBA Data[Home] [Help]

APPS.AME_GPI_BUS dependencies on HR_API

Line 211: hr_api.mandatory_arg_error(p_api_name => l_proc

207: nvl(end_date-ame_util.oneSecond,SYSDATE);
208:
209: Begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211: hr_api.mandatory_arg_error(p_api_name => l_proc
212: ,p_argument => 'APPROVAL_GROUP_ID'
213: ,p_argument_value => p_approval_group_id
214: );
215: -- Check if the group item has members of approver type other than 'PER'

Line 323: hr_api.mandatory_arg_error(p_api_name => l_proc

319: and p_effective_date between t.start_date
320: and (t.end_date - ame_util.oneSecond);
321: Begin
322: hr_utility.set_location('Entering:'||l_proc,10);
323: hr_api.mandatory_arg_error(p_api_name => l_proc
324: ,p_argument => 'APPROVAL_GROUP_ID'
325: ,p_argument_value => p_approval_group_id
326: );
327: -- Check if the approval_group exists

Line 389: hr_api.mandatory_arg_error(p_api_name => l_proc

385: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_NAME';
386:
387: Begin
388: hr_utility.set_location('Entering:'||l_proc,10);
389: hr_api.mandatory_arg_error(p_api_name => l_proc
390: ,p_argument => 'PARAMETER_NAME'
391: ,p_argument_value => p_parameter_name
392: );
393: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')

Line 471: hr_api.mandatory_arg_error(p_api_name => l_proc

467: and rownum < 2;
468:
469: Begin
470: hr_utility.set_location('Entering:'||l_proc,10);
471: hr_api.mandatory_arg_error(p_api_name => l_proc
472: ,p_argument => 'PARAMETER'
473: ,p_argument_value => p_parameter
474: );
475: -- Check if the parameter corresponds to a valid group in ame_approval_groups

Line 569: hr_api.mandatory_arg_error(p_api_name => l_proc

565: --
566: l_proc varchar2(72) := g_package || 'CHK_ORDER_NUMBER';
567: Begin
568: hr_utility.set_location('Entering:'||l_proc,10);
569: hr_api.mandatory_arg_error(p_api_name => l_proc
570: ,p_argument => 'ORDER_NUMBER'
571: ,p_argument_value => p_order_number
572: );
573: -- check if order_number is negative

Line 638: hr_api.mandatory_arg_error(p_api_name => l_proc

634: and t.parameter = p_parameter
635: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
636: Begin
637: hr_utility.set_location('Entering:'||l_proc,10);
638: hr_api.mandatory_arg_error(p_api_name => l_proc
639: ,p_argument => 'APPROVAL_GROUP_ID'
640: ,p_argument_value => p_approval_group_id
641: );
642: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 642: hr_api.mandatory_arg_error(p_api_name => l_proc

638: hr_api.mandatory_arg_error(p_api_name => l_proc
639: ,p_argument => 'APPROVAL_GROUP_ID'
640: ,p_argument_value => p_approval_group_id
641: );
642: hr_api.mandatory_arg_error(p_api_name => l_proc
643: ,p_argument => 'PARAMETER_NAME'
644: ,p_argument_value => p_parameter_name
645: );
646: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 646: hr_api.mandatory_arg_error(p_api_name => l_proc

642: hr_api.mandatory_arg_error(p_api_name => l_proc
643: ,p_argument => 'PARAMETER_NAME'
644: ,p_argument_value => p_parameter_name
645: );
646: hr_api.mandatory_arg_error(p_api_name => l_proc
647: ,p_argument => 'PARAMETER'
648: ,p_argument_value => p_parameter
649: );
650: -- check if the row represents a unique member for a group.

Line 741: nvl(p_rec.order_number, hr_api.g_number) <>

737: --
738: -- ORDER_NUMBER is non-updateable if the group is seeded
739:
740: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
741: nvl(p_rec.order_number, hr_api.g_number) <>
742: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
743: hr_api.argument_changed_error
744: (p_api_name => l_proc
745: ,p_argument => 'ORDER_NUMBER'

Line 742: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then

738: -- ORDER_NUMBER is non-updateable if the group is seeded
739:
740: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
741: nvl(p_rec.order_number, hr_api.g_number) <>
742: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
743: hr_api.argument_changed_error
744: (p_api_name => l_proc
745: ,p_argument => 'ORDER_NUMBER'
746: ,p_base_table => ame_gpi_shd.g_tab_nam

Line 743: hr_api.argument_changed_error

739:
740: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
741: nvl(p_rec.order_number, hr_api.g_number) <>
742: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
743: hr_api.argument_changed_error
744: (p_api_name => l_proc
745: ,p_argument => 'ORDER_NUMBER'
746: ,p_base_table => ame_gpi_shd.g_tab_nam
747: );

Line 751: if nvl(p_rec.approval_group_id, hr_api.g_number) <>

747: );
748: end if;
749: -- APPROVAL_GROUP_ID is non-updateable.
750:
751: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
752: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
753: hr_api.argument_changed_error
754: (p_api_name => l_proc
755: ,p_argument => 'APPROVAL_GROUP_ID'

Line 752: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then

748: end if;
749: -- APPROVAL_GROUP_ID is non-updateable.
750:
751: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
752: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
753: hr_api.argument_changed_error
754: (p_api_name => l_proc
755: ,p_argument => 'APPROVAL_GROUP_ID'
756: ,p_base_table => ame_gpi_shd.g_tab_nam

Line 753: hr_api.argument_changed_error

749: -- APPROVAL_GROUP_ID is non-updateable.
750:
751: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
752: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
753: hr_api.argument_changed_error
754: (p_api_name => l_proc
755: ,p_argument => 'APPROVAL_GROUP_ID'
756: ,p_base_table => ame_gpi_shd.g_tab_nam
757: );

Line 762: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>

758: end if;
759:
760: -- PARAMETER_NAME is non-updateable.
761:
762: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
763: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
764: hr_api.argument_changed_error
765: (p_api_name => l_proc
766: ,p_argument => 'PARAMETER_NAME'

Line 763: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then

759:
760: -- PARAMETER_NAME is non-updateable.
761:
762: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
763: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
764: hr_api.argument_changed_error
765: (p_api_name => l_proc
766: ,p_argument => 'PARAMETER_NAME'
767: ,p_base_table => ame_gpi_shd.g_tab_nam

Line 764: hr_api.argument_changed_error

760: -- PARAMETER_NAME is non-updateable.
761:
762: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
763: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
764: hr_api.argument_changed_error
765: (p_api_name => l_proc
766: ,p_argument => 'PARAMETER_NAME'
767: ,p_base_table => ame_gpi_shd.g_tab_nam
768: );

Line 773: if nvl(p_rec.parameter, hr_api.g_varchar2) <>

769: end if;
770:
771: -- PARAMETER is non-updateable.
772:
773: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
774: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
775: hr_api.argument_changed_error
776: (p_api_name => l_proc
777: ,p_argument => 'PARAMETER'

Line 774: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then

770:
771: -- PARAMETER is non-updateable.
772:
773: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
774: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
775: hr_api.argument_changed_error
776: (p_api_name => l_proc
777: ,p_argument => 'PARAMETER'
778: ,p_base_table => ame_gpi_shd.g_tab_nam

Line 775: hr_api.argument_changed_error

771: -- PARAMETER is non-updateable.
772:
773: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
774: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
775: hr_api.argument_changed_error
776: (p_api_name => l_proc
777: ,p_argument => 'PARAMETER'
778: ,p_base_table => ame_gpi_shd.g_tab_nam
779: );

Line 816: (p_approval_group_id in number default hr_api.g_number

812: --
813: -- {End Of Comments}
814: -- ----------------------------------------------------------------------------
815: Procedure dt_update_validate
816: (p_approval_group_id in number default hr_api.g_number
817: ,p_datetrack_mode in varchar2
818: ,p_validation_start_date in date
819: ,p_validation_end_date in date
820: ) Is

Line 828: hr_api.mandatory_arg_error

824: Begin
825: --
826: -- Ensure that the p_datetrack_mode argument is not null
827: --
828: hr_api.mandatory_arg_error
829: (p_api_name => l_proc
830: ,p_argument => 'datetrack_mode'
831: ,p_argument_value => p_datetrack_mode
832: );

Line 838: hr_api.mandatory_arg_error

834: -- Mode will be valid, as this is checked at the start of the upd.
835: --
836: -- Ensure the arguments are not null
837: --
838: hr_api.mandatory_arg_error
839: (p_api_name => l_proc
840: ,p_argument => 'validation_start_date'
841: ,p_argument_value => p_validation_start_date
842: );

Line 844: /*hr_api.mandatory_arg_error

840: ,p_argument => 'validation_start_date'
841: ,p_argument_value => p_validation_start_date
842: );
843: --
844: /*hr_api.mandatory_arg_error
845: (p_api_name => l_proc
846: ,p_argument => 'validation_end_date'
847: ,p_argument_value => p_validation_end_date
848: );*/

Line 910: hr_api.mandatory_arg_error

906: Begin
907: --
908: -- Ensure that the p_datetrack_mode argument is not null
909: --
910: hr_api.mandatory_arg_error
911: (p_api_name => l_proc
912: ,p_argument => 'datetrack_mode'
913: ,p_argument_value => p_datetrack_mode
914: );

Line 919: If (p_datetrack_mode = hr_api.g_delete or

915: --
916: -- Only perform the validation if the datetrack mode is either
917: -- DELETE or ZAP
918: --
919: If (p_datetrack_mode = hr_api.g_delete or
920: p_datetrack_mode = hr_api.g_zap) then
921: --
922: --
923: -- Ensure the arguments are not null

Line 920: p_datetrack_mode = hr_api.g_zap) then

916: -- Only perform the validation if the datetrack mode is either
917: -- DELETE or ZAP
918: --
919: If (p_datetrack_mode = hr_api.g_delete or
920: p_datetrack_mode = hr_api.g_zap) then
921: --
922: --
923: -- Ensure the arguments are not null
924: --

Line 925: hr_api.mandatory_arg_error

921: --
922: --
923: -- Ensure the arguments are not null
924: --
925: hr_api.mandatory_arg_error
926: (p_api_name => l_proc
927: ,p_argument => 'validation_start_date'
928: ,p_argument_value => p_validation_start_date
929: );

Line 931: /*hr_api.mandatory_arg_error

927: ,p_argument => 'validation_start_date'
928: ,p_argument_value => p_validation_start_date
929: );
930: --
931: /*hr_api.mandatory_arg_error
932: (p_api_name => l_proc
933: ,p_argument => 'validation_end_date'
934: ,p_argument_value => p_validation_end_date
935: );*/

Line 937: hr_api.mandatory_arg_error

933: ,p_argument => 'validation_end_date'
934: ,p_argument_value => p_validation_end_date
935: );*/
936: --
937: hr_api.mandatory_arg_error
938: (p_api_name => l_proc
939: ,p_argument => 'approval_group_item_id'
940: ,p_argument_value => p_approval_group_item_id
941: );