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;
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,
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;
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,
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;
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,
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;
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;
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;
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: );
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
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: );
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
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: );
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: );
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: );*/
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: );
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
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: --
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: );
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: );*/
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: );