36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------
96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := pay_pta_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --
140: close csr_leg_code;
141: pay_pta_bus.g_dated_table_id := p_dated_table_id;
142: pay_pta_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------
262: --
263: l_proc varchar2(72) := g_package||'chk_dyn_trigger';
264: --
265: Begin
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: -- Validate against hr_lookups.
269: --
270: if p_rec.dyn_trigger_type is not null then
273: ,p_lookup_type => 'PAY_DYN_TRIGGER_TYPES'
274: ,p_lookup_code => p_rec.dyn_trigger_type
275: )
276: then
277: hr_utility.set_location(' Leaving:'||l_proc, 10);
278: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
279: fnd_message.set_token('LOOKUP_TYPE', 'PAY_DYN_TRIGGER_TYPES');
280: fnd_message.set_token('VALUE', p_rec.dyn_trigger_type);
281: fnd_message.raise_error;
280: fnd_message.set_token('VALUE', p_rec.dyn_trigger_type);
281: fnd_message.raise_error;
282: end if;
283: end if;
284: hr_utility.set_location(' Leaving:'||l_proc, 20);
285: End chk_dyn_trigger;
286:
287: --
288: -- ----------------------------------------------------------------------------
314: l_proc varchar2(72) := g_package||'chk_table_name';
315: --
316: Begin
317: --
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: hr_api.mandatory_arg_error
321: (p_api_name => l_proc
322: ,p_argument => 'table_name'
331:
332: fnd_message.raise_error;
333: End If;
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: end chk_table_name;
337:
338:
339: --
365: --
366: l_proc varchar2(72) := g_package||'chk_dyn_trig_pkg_generated';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: --
372: -- Validate dyn_trig_pkg_generated against hr_lookups.
373: --
377: ,p_lookup_type => 'YES_NO'
378: ,p_lookup_code => p_rec.dyn_trig_pkg_generated
379: )
380: then
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: fnd_message.set_name('PAY', 'INVALID_LOOKUP_CODE');
383: fnd_message.set_token('LOOKUP_TYPE', 'YES_NO');
384: fnd_message.set_token('VALUE', p_rec.dyn_trig_pkg_generated);
385: fnd_message.raise_error;
384: fnd_message.set_token('VALUE', p_rec.dyn_trig_pkg_generated);
385: fnd_message.raise_error;
386: end if;
387: end if;
388: hr_utility.set_location(' Leaving:'||l_proc, 20);
389: End chk_dyn_trig_pkg_generated;
390:
391:
392: --
424: l_proc varchar2(72) := g_package||'chk_columns';
425: --
426: Begin
427: --
428: hr_utility.set_location('Entering:'||l_proc, 5);
429: --
430: hr_api.mandatory_arg_error
431: (p_api_name => l_proc
432: ,p_argument => 'surrogate_key_name'
466: fnd_message.raise_error;
467: End If;
468: --
469: end if;
470: hr_utility.set_location(' Leaving:'||l_proc, 10);
471: end chk_columns;
472: --
473: -- ----------------------------------------------------------------------------
474: -- |---------------------------< insert_validate >----------------------------|
479: --
480: l_proc varchar2(72) := g_package||'insert_validate';
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: --
485: --hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
486: --
487: chk_table_name (p_rec => p_rec);
491: chk_dyn_trigger(p_rec => p_rec);
492: --
493: chk_dyn_trig_pkg_generated(p_rec => p_rec);
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 10);
496: End insert_validate;
497: --
498: -- ----------------------------------------------------------------------------
499: -- |---------------------------< update_validate >----------------------------|
504: --
505: l_proc varchar2(72) := g_package||'update_validate';
506: --
507: Begin
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: --hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
511: --
512: chk_non_updateable_args
520: chk_dyn_trigger(p_rec => p_rec);
521: --
522: chk_dyn_trig_pkg_generated(p_rec => p_rec);
523: --
524: hr_utility.set_location(' Leaving:'||l_proc, 10);
525: End update_validate;
526: --
527: -- ----------------------------------------------------------------------------
528: -- |---------------------------< delete_validate >----------------------------|
533: --
534: l_proc varchar2(72) := g_package||'delete_validate';
535: --
536: Begin
537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: -- Call all supporting business operations
540: --
541: hr_utility.set_location(' Leaving:'||l_proc, 10);
537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: -- Call all supporting business operations
540: --
541: hr_utility.set_location(' Leaving:'||l_proc, 10);
542: End delete_validate;
543: --
544: end pay_pta_bus;