DBA Data[Home] [Help]

APPS.AME_GPI_BUS dependencies on HR_API

Line 217: hr_api.mandatory_arg_error(p_api_name => l_proc

213: nvl(end_date-ame_util.oneSecond,SYSDATE);
214:
215: Begin
216: hr_utility.set_location('Entering:'||l_proc,10);
217: hr_api.mandatory_arg_error(p_api_name => l_proc
218: ,p_argument => 'APPROVAL_GROUP_ID'
219: ,p_argument_value => p_approval_group_id
220: );
221: -- Check if the group item has members of approver type other than 'PER'

Line 329: hr_api.mandatory_arg_error(p_api_name => l_proc

325: and p_effective_date between t.start_date
326: and (t.end_date - ame_util.oneSecond);
327: Begin
328: hr_utility.set_location('Entering:'||l_proc,10);
329: hr_api.mandatory_arg_error(p_api_name => l_proc
330: ,p_argument => 'APPROVAL_GROUP_ID'
331: ,p_argument_value => p_approval_group_id
332: );
333: -- Check if the approval_group exists

Line 395: hr_api.mandatory_arg_error(p_api_name => l_proc

391: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_NAME';
392:
393: Begin
394: hr_utility.set_location('Entering:'||l_proc,10);
395: hr_api.mandatory_arg_error(p_api_name => l_proc
396: ,p_argument => 'PARAMETER_NAME'
397: ,p_argument_value => p_parameter_name
398: );
399: -- Check if the parameter_name is in ('OAM_group_id','wf_roles_name')

Line 477: hr_api.mandatory_arg_error(p_api_name => l_proc

473: and rownum < 2;
474:
475: Begin
476: hr_utility.set_location('Entering:'||l_proc,10);
477: hr_api.mandatory_arg_error(p_api_name => l_proc
478: ,p_argument => 'PARAMETER'
479: ,p_argument_value => p_parameter
480: );
481: -- Check if the parameter corresponds to a valid group in ame_approval_groups

Line 575: hr_api.mandatory_arg_error(p_api_name => l_proc

571: --
572: l_proc varchar2(72) := g_package || 'CHK_ORDER_NUMBER';
573: Begin
574: hr_utility.set_location('Entering:'||l_proc,10);
575: hr_api.mandatory_arg_error(p_api_name => l_proc
576: ,p_argument => 'ORDER_NUMBER'
577: ,p_argument_value => p_order_number
578: );
579: -- check if order_number is negative

Line 644: hr_api.mandatory_arg_error(p_api_name => l_proc

640: and t.parameter = p_parameter
641: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
642: Begin
643: hr_utility.set_location('Entering:'||l_proc,10);
644: hr_api.mandatory_arg_error(p_api_name => l_proc
645: ,p_argument => 'APPROVAL_GROUP_ID'
646: ,p_argument_value => p_approval_group_id
647: );
648: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 648: hr_api.mandatory_arg_error(p_api_name => l_proc

644: hr_api.mandatory_arg_error(p_api_name => l_proc
645: ,p_argument => 'APPROVAL_GROUP_ID'
646: ,p_argument_value => p_approval_group_id
647: );
648: hr_api.mandatory_arg_error(p_api_name => l_proc
649: ,p_argument => 'PARAMETER_NAME'
650: ,p_argument_value => p_parameter_name
651: );
652: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 652: hr_api.mandatory_arg_error(p_api_name => l_proc

648: hr_api.mandatory_arg_error(p_api_name => l_proc
649: ,p_argument => 'PARAMETER_NAME'
650: ,p_argument_value => p_parameter_name
651: );
652: hr_api.mandatory_arg_error(p_api_name => l_proc
653: ,p_argument => 'PARAMETER'
654: ,p_argument_value => p_parameter
655: );
656: -- check if the row represents a unique member for a group.

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

743: --
744: -- ORDER_NUMBER is non-updateable if the group is seeded
745:
746: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
747: nvl(p_rec.order_number, hr_api.g_number) <>
748: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
749: hr_api.argument_changed_error
750: (p_api_name => l_proc
751: ,p_argument => 'ORDER_NUMBER'

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

744: -- ORDER_NUMBER is non-updateable if the group is seeded
745:
746: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
747: nvl(p_rec.order_number, hr_api.g_number) <>
748: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
749: hr_api.argument_changed_error
750: (p_api_name => l_proc
751: ,p_argument => 'ORDER_NUMBER'
752: ,p_base_table => ame_gpi_shd.g_tab_nam

Line 749: hr_api.argument_changed_error

745:
746: if ame_utility_pkg.is_seed_user(l_created_by) = ame_util.seededDataCreatedById and
747: nvl(p_rec.order_number, hr_api.g_number) <>
748: nvl(ame_gpi_shd.g_old_rec.order_number,hr_api.g_number)then
749: hr_api.argument_changed_error
750: (p_api_name => l_proc
751: ,p_argument => 'ORDER_NUMBER'
752: ,p_base_table => ame_gpi_shd.g_tab_nam
753: );

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

753: );
754: end if;
755: -- APPROVAL_GROUP_ID is non-updateable.
756:
757: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
758: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
759: hr_api.argument_changed_error
760: (p_api_name => l_proc
761: ,p_argument => 'APPROVAL_GROUP_ID'

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

754: end if;
755: -- APPROVAL_GROUP_ID is non-updateable.
756:
757: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
758: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
759: hr_api.argument_changed_error
760: (p_api_name => l_proc
761: ,p_argument => 'APPROVAL_GROUP_ID'
762: ,p_base_table => ame_gpi_shd.g_tab_nam

Line 759: hr_api.argument_changed_error

755: -- APPROVAL_GROUP_ID is non-updateable.
756:
757: if nvl(p_rec.approval_group_id, hr_api.g_number) <>
758: nvl(ame_gpi_shd.g_old_rec.approval_group_id,hr_api.g_number)then
759: hr_api.argument_changed_error
760: (p_api_name => l_proc
761: ,p_argument => 'APPROVAL_GROUP_ID'
762: ,p_base_table => ame_gpi_shd.g_tab_nam
763: );

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

764: end if;
765:
766: -- PARAMETER_NAME is non-updateable.
767:
768: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
769: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
770: hr_api.argument_changed_error
771: (p_api_name => l_proc
772: ,p_argument => 'PARAMETER_NAME'

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

765:
766: -- PARAMETER_NAME is non-updateable.
767:
768: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
769: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
770: hr_api.argument_changed_error
771: (p_api_name => l_proc
772: ,p_argument => 'PARAMETER_NAME'
773: ,p_base_table => ame_gpi_shd.g_tab_nam

Line 770: hr_api.argument_changed_error

766: -- PARAMETER_NAME is non-updateable.
767:
768: if nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
769: nvl(ame_gpi_shd.g_old_rec.parameter_name,hr_api.g_varchar2)then
770: hr_api.argument_changed_error
771: (p_api_name => l_proc
772: ,p_argument => 'PARAMETER_NAME'
773: ,p_base_table => ame_gpi_shd.g_tab_nam
774: );

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

775: end if;
776:
777: -- PARAMETER is non-updateable.
778:
779: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
780: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
781: hr_api.argument_changed_error
782: (p_api_name => l_proc
783: ,p_argument => 'PARAMETER'

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

776:
777: -- PARAMETER is non-updateable.
778:
779: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
780: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
781: hr_api.argument_changed_error
782: (p_api_name => l_proc
783: ,p_argument => 'PARAMETER'
784: ,p_base_table => ame_gpi_shd.g_tab_nam

Line 781: hr_api.argument_changed_error

777: -- PARAMETER is non-updateable.
778:
779: if nvl(p_rec.parameter, hr_api.g_varchar2) <>
780: nvl(ame_gpi_shd.g_old_rec.parameter,hr_api.g_varchar2)then
781: hr_api.argument_changed_error
782: (p_api_name => l_proc
783: ,p_argument => 'PARAMETER'
784: ,p_base_table => ame_gpi_shd.g_tab_nam
785: );

Line 822: (p_approval_group_id in number default hr_api.g_number

818: --
819: -- {End Of Comments}
820: -- ----------------------------------------------------------------------------
821: Procedure dt_update_validate
822: (p_approval_group_id in number default hr_api.g_number
823: ,p_datetrack_mode in varchar2
824: ,p_validation_start_date in date
825: ,p_validation_end_date in date
826: ) Is

Line 834: hr_api.mandatory_arg_error

830: Begin
831: --
832: -- Ensure that the p_datetrack_mode argument is not null
833: --
834: hr_api.mandatory_arg_error
835: (p_api_name => l_proc
836: ,p_argument => 'datetrack_mode'
837: ,p_argument_value => p_datetrack_mode
838: );

Line 844: hr_api.mandatory_arg_error

840: -- Mode will be valid, as this is checked at the start of the upd.
841: --
842: -- Ensure the arguments are not null
843: --
844: hr_api.mandatory_arg_error
845: (p_api_name => l_proc
846: ,p_argument => 'validation_start_date'
847: ,p_argument_value => p_validation_start_date
848: );

Line 850: /*hr_api.mandatory_arg_error

846: ,p_argument => 'validation_start_date'
847: ,p_argument_value => p_validation_start_date
848: );
849: --
850: /*hr_api.mandatory_arg_error
851: (p_api_name => l_proc
852: ,p_argument => 'validation_end_date'
853: ,p_argument_value => p_validation_end_date
854: );*/

Line 916: hr_api.mandatory_arg_error

912: Begin
913: --
914: -- Ensure that the p_datetrack_mode argument is not null
915: --
916: hr_api.mandatory_arg_error
917: (p_api_name => l_proc
918: ,p_argument => 'datetrack_mode'
919: ,p_argument_value => p_datetrack_mode
920: );

Line 925: If (p_datetrack_mode = hr_api.g_delete or

921: --
922: -- Only perform the validation if the datetrack mode is either
923: -- DELETE or ZAP
924: --
925: If (p_datetrack_mode = hr_api.g_delete or
926: p_datetrack_mode = hr_api.g_zap) then
927: --
928: --
929: -- Ensure the arguments are not null

Line 926: p_datetrack_mode = hr_api.g_zap) then

922: -- Only perform the validation if the datetrack mode is either
923: -- DELETE or ZAP
924: --
925: If (p_datetrack_mode = hr_api.g_delete or
926: p_datetrack_mode = hr_api.g_zap) then
927: --
928: --
929: -- Ensure the arguments are not null
930: --

Line 931: hr_api.mandatory_arg_error

927: --
928: --
929: -- Ensure the arguments are not null
930: --
931: hr_api.mandatory_arg_error
932: (p_api_name => l_proc
933: ,p_argument => 'validation_start_date'
934: ,p_argument_value => p_validation_start_date
935: );

Line 937: /*hr_api.mandatory_arg_error

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

Line 943: hr_api.mandatory_arg_error

939: ,p_argument => 'validation_end_date'
940: ,p_argument_value => p_validation_end_date
941: );*/
942: --
943: hr_api.mandatory_arg_error
944: (p_api_name => l_proc
945: ,p_argument => 'approval_group_item_id'
946: ,p_argument_value => p_approval_group_item_id
947: );