DBA Data[Home] [Help]

APPS.AME_ATY_BUS dependencies on HR_API

Line 81: hr_api.g_number) <>

77: IF createdBy = ame_util.seededDataCreatedById
78: and ame_utility_pkg.check_seeddb = 'N' then
79: IF
80: nvl(p_rec.name,
81: hr_api.g_number) <>
82: nvl(ame_aty_shd.g_old_rec.name,
83: hr_api.g_number) then
84: l_argument := 'name';
85: RAISE l_error;

Line 83: hr_api.g_number) then

79: IF
80: nvl(p_rec.name,
81: hr_api.g_number) <>
82: nvl(ame_aty_shd.g_old_rec.name,
83: hr_api.g_number) then
84: l_argument := 'name';
85: RAISE l_error;
86: ELSIF
87: nvl(p_rec.procedure_name,

Line 88: hr_api.g_number) <>

84: l_argument := 'name';
85: RAISE l_error;
86: ELSIF
87: nvl(p_rec.procedure_name,
88: hr_api.g_number) <>
89: nvl(ame_aty_shd.g_old_rec.procedure_name,
90: hr_api.g_number) then
91: l_argument := 'procedure_name';
92: RAISE l_error;

Line 90: hr_api.g_number) then

86: ELSIF
87: nvl(p_rec.procedure_name,
88: hr_api.g_number) <>
89: nvl(ame_aty_shd.g_old_rec.procedure_name,
90: hr_api.g_number) then
91: l_argument := 'procedure_name';
92: RAISE l_error;
93: ELSIF
94: nvl(p_rec.description,

Line 95: hr_api.g_number) <>

91: l_argument := 'procedure_name';
92: RAISE l_error;
93: ELSIF
94: nvl(p_rec.description,
95: hr_api.g_number) <>
96: nvl(ame_aty_shd.g_old_rec.description,
97: hr_api.g_number) then
98: l_argument := 'description';
99: RAISE l_error;

Line 97: hr_api.g_number) then

93: ELSIF
94: nvl(p_rec.description,
95: hr_api.g_number) <>
96: nvl(ame_aty_shd.g_old_rec.description,
97: hr_api.g_number) then
98: l_argument := 'description';
99: RAISE l_error;
100: ELSIF
101: nvl(p_rec.dynamic_description,

Line 102: hr_api.g_number) <>

98: l_argument := 'description';
99: RAISE l_error;
100: ELSIF
101: nvl(p_rec.dynamic_description,
102: hr_api.g_number) <>
103: nvl(ame_aty_shd.g_old_rec.dynamic_description,
104: hr_api.g_number) then
105: l_argument := 'dynamic_description';
106: RAISE l_error;

Line 104: hr_api.g_number) then

100: ELSIF
101: nvl(p_rec.dynamic_description,
102: hr_api.g_number) <>
103: nvl(ame_aty_shd.g_old_rec.dynamic_description,
104: hr_api.g_number) then
105: l_argument := 'dynamic_description';
106: RAISE l_error;
107: END IF;
108: END IF;

Line 111: hr_api.argument_changed_error

107: END IF;
108: END IF;
109: EXCEPTION
110: WHEN l_error THEN
111: hr_api.argument_changed_error
112: (p_api_name => l_proc
113: ,p_argument => l_argument);
114: WHEN OTHERS THEN
115: RAISE;

Line 162: hr_api.mandatory_arg_error

158: p_effective_date between start_date and
159: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
160: l_exists varchar2(1);
161: begin
162: hr_api.mandatory_arg_error
163: (p_api_name => l_proc
164: ,p_argument => 'name'
165: ,p_argument_value => p_name
166: );

Line 221: hr_api.mandatory_arg_error

217: (p_description in varchar2
218: ) is
219: l_proc varchar2(72) := g_package||'chk_description';
220: begin
221: hr_api.mandatory_arg_error
222: (p_api_name => l_proc,
223: p_argument => 'description',
224: p_argument_value => p_description);
225: exception

Line 279: hr_api.mandatory_arg_error

275: p_effective_date between start_date and
276: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
277: l_exists varchar2(1);
278: begin
279: hr_api.mandatory_arg_error
280: (p_api_name => l_proc
281: ,p_argument => 'procedure_name'
282: ,p_argument_value => p_procedure_name
283: );

Line 397: hr_api.mandatory_arg_error

393: l_proc varchar2(72) := g_package||'chk_description_query';
394: l_valid varchar2(1000);
395: begin
396: IF(p_dynamic_description = ame_util.booleanTrue) then
397: hr_api.mandatory_arg_error
398: (p_api_name => l_proc,
399: p_argument => 'description_query',
400: p_argument_value => p_description_query);
401: IF(instrb(p_description_query, ';', 1, 1) > 0) or

Line 649: hr_api.mandatory_arg_error

645: Begin
646: --
647: -- Ensure that the p_datetrack_mode argument is not null
648: --
649: hr_api.mandatory_arg_error
650: (p_api_name => l_proc
651: ,p_argument => 'datetrack_mode'
652: ,p_argument_value => p_datetrack_mode
653: );

Line 659: hr_api.mandatory_arg_error

655: -- Mode will be valid, as this is checked at the start of the upd.
656: --
657: -- Ensure the arguments are not null
658: --
659: hr_api.mandatory_arg_error
660: (p_api_name => l_proc
661: ,p_argument => 'validation_start_date'
662: ,p_argument_value => p_validation_start_date
663: );

Line 665: /*hr_api.mandatory_arg_error

661: ,p_argument => 'validation_start_date'
662: ,p_argument_value => p_validation_start_date
663: );
664: --
665: /*hr_api.mandatory_arg_error
666: (p_api_name => l_proc
667: ,p_argument => 'validation_end_date'
668: ,p_argument_value => p_validation_end_date
669: );*/

Line 731: hr_api.mandatory_arg_error

727: Begin
728: --
729: -- Ensure that the p_datetrack_mode argument is not null
730: --
731: hr_api.mandatory_arg_error
732: (p_api_name => l_proc
733: ,p_argument => 'datetrack_mode'
734: ,p_argument_value => p_datetrack_mode
735: );

Line 740: If (p_datetrack_mode = hr_api.g_delete or

736: --
737: -- Only perform the validation if the datetrack mode is either
738: -- DELETE or ZAP
739: --
740: If (p_datetrack_mode = hr_api.g_delete or
741: p_datetrack_mode = hr_api.g_zap) then
742: --
743: --
744: -- Ensure the arguments are not null

Line 741: p_datetrack_mode = hr_api.g_zap) then

737: -- Only perform the validation if the datetrack mode is either
738: -- DELETE or ZAP
739: --
740: If (p_datetrack_mode = hr_api.g_delete or
741: p_datetrack_mode = hr_api.g_zap) then
742: --
743: --
744: -- Ensure the arguments are not null
745: --

Line 746: hr_api.mandatory_arg_error

742: --
743: --
744: -- Ensure the arguments are not null
745: --
746: hr_api.mandatory_arg_error
747: (p_api_name => l_proc
748: ,p_argument => 'validation_start_date'
749: ,p_argument_value => p_validation_start_date
750: );

Line 752: /*hr_api.mandatory_arg_error

748: ,p_argument => 'validation_start_date'
749: ,p_argument_value => p_validation_start_date
750: );
751: --
752: /*hr_api.mandatory_arg_error
753: (p_api_name => l_proc
754: ,p_argument => 'validation_end_date'
755: ,p_argument_value => p_validation_end_date
756: );*/

Line 758: hr_api.mandatory_arg_error

754: ,p_argument => 'validation_end_date'
755: ,p_argument_value => p_validation_end_date
756: );*/
757: --
758: hr_api.mandatory_arg_error
759: (p_api_name => l_proc
760: ,p_argument => 'action_type_id'
761: ,p_argument_value => p_action_type_id
762: );