35: hr_utility.set_location(l_proc, 15);
36: --
37: -- p_business_group_id
38: --
39: if nvl(p_rec.business_group_id, hr_api.g_number) <>
40: nvl(pay_etm_shd.g_old_rec.business_group_id, hr_api.g_number)
41: then
42: l_argument := 'p_business_group_id';
43: raise l_error;
36: --
37: -- p_business_group_id
38: --
39: if nvl(p_rec.business_group_id, hr_api.g_number) <>
40: nvl(pay_etm_shd.g_old_rec.business_group_id, hr_api.g_number)
41: then
42: l_argument := 'p_business_group_id';
43: raise l_error;
44: end if;
44: end if;
45: --
46: -- p_legislation_code
47: --
48: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
49: nvl(pay_etm_shd.g_old_rec.legislation_code, hr_api.g_varchar2)
50: then
51: l_argument := 'p_legislation_code';
52: raise l_error;
45: --
46: -- p_legislation_code
47: --
48: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
49: nvl(pay_etm_shd.g_old_rec.legislation_code, hr_api.g_varchar2)
50: then
51: l_argument := 'p_legislation_code';
52: raise l_error;
53: end if;
53: end if;
54: --
55: -- p_template_name
56: --
57: if nvl(p_rec.template_name, hr_api.g_varchar2) <>
58: nvl(pay_etm_shd.g_old_rec.template_name, hr_api.g_varchar2)
59: then
60: l_argument := 'p_template_name';
61: raise l_error;
54: --
55: -- p_template_name
56: --
57: if nvl(p_rec.template_name, hr_api.g_varchar2) <>
58: nvl(pay_etm_shd.g_old_rec.template_name, hr_api.g_varchar2)
59: then
60: l_argument := 'p_template_name';
61: raise l_error;
62: end if;
62: end if;
63: --
64: -- p_template_type
65: --
66: if nvl(p_rec.template_type, hr_api.g_varchar2) <>
67: nvl(pay_etm_shd.g_old_rec.template_type, hr_api.g_varchar2)
68: then
69: l_argument := 'p_template_type';
70: raise l_error;
63: --
64: -- p_template_type
65: --
66: if nvl(p_rec.template_type, hr_api.g_varchar2) <>
67: nvl(pay_etm_shd.g_old_rec.template_type, hr_api.g_varchar2)
68: then
69: l_argument := 'p_template_type';
70: raise l_error;
71: end if;
71: end if;
72: --
73: -- p_base_name
74: --
75: if nvl(p_rec.base_name, hr_api.g_varchar2) <>
76: nvl(pay_etm_shd.g_old_rec.base_name, hr_api.g_varchar2)
77: then
78: l_argument := 'p_base_name';
79: raise l_error;
72: --
73: -- p_base_name
74: --
75: if nvl(p_rec.base_name, hr_api.g_varchar2) <>
76: nvl(pay_etm_shd.g_old_rec.base_name, hr_api.g_varchar2)
77: then
78: l_argument := 'p_base_name';
79: raise l_error;
80: end if;
81: hr_utility.set_location('Leaving:'||l_proc, 20);
82: exception
83: when l_error then
84: hr_utility.set_location('Leaving:'||l_proc, 25);
85: hr_api.argument_changed_error
86: (p_api_name => l_proc
87: ,p_argument => l_argument);
88: when others then
89: hr_utility.set_location('Leaving:'||l_proc, 30);
122: --
123: -- Validate business_group_id.
124: --
125: if p_business_group_id is not null then
126: hr_api.validate_bus_grp_id( p_business_group_id );
127: end if;
128: --
129: -- Validate legislation_code - if set and not International.
130: --
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: -- Check that the name is not null.
185: --
186: hr_api.mandatory_arg_error
187: (p_api_name => l_proc
188: ,p_argument => 'p_template_name'
189: ,p_argument_value => p_template_name
190: );
197: -- Get the legislation_code for the new template.
198: --
199: if p_business_group_id is not null then
200: l_legislation_code :=
201: hr_api.return_legislation_code(p_business_group_id);
202: else
203: l_legislation_code := p_legislation_code;
204: end if;
205: --
257: ,p_object_version_number => p_object_version_number
258: );
259: --
260: if (l_api_updating and
261: nvl(pay_etm_shd.g_old_rec.base_processing_priority, hr_api.g_number) <>
262: nvl(p_base_processing_priority, hr_api.g_number)) or
263: not l_api_updating
264: then
265: --
258: );
259: --
260: if (l_api_updating and
261: nvl(pay_etm_shd.g_old_rec.base_processing_priority, hr_api.g_number) <>
262: nvl(p_base_processing_priority, hr_api.g_number)) or
263: not l_api_updating
264: then
265: --
266: -- Check that an update is not being done for a template type of 'U'.
272: end if;
273: --
274: -- Check that the priority is not null.
275: --
276: hr_api.mandatory_arg_error
277: (p_api_name => l_proc
278: ,p_argument => 'p_base_processing_priority'
279: ,p_argument_value => p_base_processing_priority
280: );
324: ,p_object_version_number => p_object_version_number
325: );
326: --
327: if (l_api_updating and
328: nvl(pay_etm_shd.g_old_rec.version_number, hr_api.g_number) <>
329: nvl(p_version_number, hr_api.g_number)) or
330: not l_api_updating
331: then
332: --
325: );
326: --
327: if (l_api_updating and
328: nvl(pay_etm_shd.g_old_rec.version_number, hr_api.g_number) <>
329: nvl(p_version_number, hr_api.g_number)) or
330: not l_api_updating
331: then
332: --
333: -- Check that the version number is not null.
331: then
332: --
333: -- Check that the version number is not null.
334: --
335: hr_api.mandatory_arg_error
336: (p_api_name => l_proc
337: ,p_argument => 'p_version_number'
338: ,p_argument_value => p_version_number
339: );
374: hr_utility.set_location('Entering:'||l_proc, 5);
375: --
376: -- Check that the template type is not null.
377: --
378: hr_api.mandatory_arg_error
379: (p_api_name => l_proc
380: ,p_argument => 'p_template_type'
381: ,p_argument_value => p_template_type
382: );
383: --
384: -- Validate against hr_lookups.
385: --
386: if p_template_type not in ('U','T') or
387: hr_api.not_exists_in_hr_lookups
388: (p_effective_date => p_effective_date
389: ,p_lookup_type => 'ELEMENT_TEMPLATE_TYPE'
390: ,p_lookup_code => p_template_type
391: )
430: ,p_object_version_number => p_object_version_number
431: );
432: --
433: if (l_api_updating and
434: nvl(pay_etm_shd.g_old_rec.max_base_name_length, hr_api.g_number) <>
435: nvl(p_max_base_name_length, hr_api.g_number)) or
436: not l_api_updating
437: then
438: --
431: );
432: --
433: if (l_api_updating and
434: nvl(pay_etm_shd.g_old_rec.max_base_name_length, hr_api.g_number) <>
435: nvl(p_max_base_name_length, hr_api.g_number)) or
436: not l_api_updating
437: then
438: --
439: -- Check that the base name length is not null.
437: then
438: --
439: -- Check that the base name length is not null.
440: --
441: hr_api.mandatory_arg_error
442: (p_api_name => l_proc
443: ,p_argument => 'p_max_base_name_length'
444: ,p_argument_value => p_max_base_name_length
445: );
523: end if;
524: --
525: -- Check that the base name is not null.
526: --
527: hr_api.mandatory_arg_error
528: (p_api_name => l_proc
529: ,p_argument => 'p_base_name'
530: ,p_argument_value => p_base_name
531: );