[Home] [Help]
38: l_proc varchar2(72) := g_package||'set_security_group_id';
39: --
40: begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Ensure that all the mandatory parameter are not null
45: --
46: hr_api.mandatory_arg_error
69: hr_api.set_security_group_id
70: (p_security_group_id => l_security_group_id
71: );
72: --
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);
74: --
75: end set_security_group_id;
76: --
77: -- ---------------------------------------------------------------------------
100: l_proc varchar2(72) := g_package||'return_legislation_code';
101: --
102: Begin
103: --
104: hr_utility.set_location('Entering:'|| l_proc, 10);
105: --
106: -- Ensure that all the mandatory parameter are not null
107: --
108: hr_api.mandatory_arg_error
118: -- call to this function. Just return the value in the global
119: -- variable.
120: --
121: l_legislation_code := pqp_erg_bus.g_legislation_code;
122: hr_utility.set_location(l_proc, 20);
123: else
124: --
125: -- The ID is different to the last call to this function
126: -- or this is the first call to this function.
135: close csr_leg_code;
136: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
137: fnd_message.raise_error;
138: end if;
139: hr_utility.set_location(l_proc,30);
140: --
141: -- Set the global variables so the values are
142: -- available for the next call to this function.
143: --
144: close csr_leg_code;
145: pqp_erg_bus.g_exception_group_id := p_exception_group_id;
146: pqp_erg_bus.g_legislation_code := l_legislation_code;
147: end if;
148: hr_utility.set_location(' Leaving:'|| l_proc, 40);
149: return l_legislation_code;
150: end return_legislation_code;
151: --
152: -- ----------------------------------------------------------------------------
296: where a.exception_report_id = p_exception_report_id;
297: --
298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc,5);
301: --
302: l_api_updating := pqp_erg_shd.api_updating
303: (p_exception_group_id => p_exception_group_id,
304: p_object_version_number => p_object_version_number);
334: close c1;
335: --
336: end if;
337: --
338: hr_utility.set_location('Leaving:'||l_proc,10);
339: --
340: End chk_exception_report_id;
341: --
342: --
383: and a.business_group_id = p_business_group_id;
384: --
385: Begin
386: --
387: hr_utility.set_location('Entering:'||l_proc,5);
388: --
389: l_api_updating := pqp_erg_shd.api_updating
390: (p_exception_group_id => p_exception_group_id,
391: p_object_version_number => p_object_version_number);
415: close c1;
416: --
417: end if;
418: --
419: hr_utility.set_location('Leaving:'||l_proc,10);
420: --
421: End chk_consolidation_set_id;
422: --
423: --
464: and a.business_group_id = p_business_group_id;
465: --
466: Begin
467: --
468: hr_utility.set_location('Entering:'||l_proc,5);
469: --
470: l_api_updating := pqp_erg_shd.api_updating
471: (p_exception_group_id => p_exception_group_id,
472: p_object_version_number => p_object_version_number);
496: close c1;
497: --
498: end if;
499: --
500: hr_utility.set_location('Leaving:'||l_proc,10);
501: --
502: End chk_payroll_id;
503: --
504: --
548: SELECT pbg.legislation_code
549: FROM per_business_groups pbg where pbg.business_group_id=p_business_group_id;
550: --
551: Begin
552: hr_utility.set_location('Entering:'||l_proc, 5);
553: --
554: hr_api.mandatory_arg_error
555: (p_api_name => l_proc
556: ,p_argument => 'EXCEPTION_GROUP_NAME'
570:
571: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_NAMECHK');
572: end if;
573: --
574: hr_utility.set_location('Leaving:'||l_proc, 15);
575: End chk_group_name_unique;
576: --
577: -- ----------------------------------------------------------------------------
578: -- |------------------------< chk_comp_key_unique >---------------|
629:
630: --
631: Begin
632:
633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: open c2;
636: loop
637: fetch c2 into l_legislation_code;
645: close c1;
646: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_COMPKEY');
647: end if;
648: --
649: hr_utility.set_location('Leaving:'||l_proc, 15);
650: End chk_comp_key_unique;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< insert_validate >----------------------------|
658: --
659: l_proc varchar2(72) := g_package||'insert_validate';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);
663: --
664: -- Call all supporting business operations
665: --
666: --
702: );
703: --
704: -- set_security_group_id(p_rec.exception_group_id);
705: --
706: hr_utility.set_location(' Leaving:'||l_proc, 10);
707: End insert_validate;
708: --
709: -- ----------------------------------------------------------------------------
710: -- |---------------------------< update_validate >----------------------------|
715: --
716: l_proc varchar2(72) := g_package||'update_validate';
717: --
718: Begin
719: hr_utility.set_location('Entering:'||l_proc, 5);
720: --
721: -- Call all supporting business operations
722: --
723: chk_startup_action(false
763: ,p_legislation_code => p_rec.legislation_code
764: ,p_exception_report_id => p_rec.exception_report_id
765: );
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 10);
768: End update_validate;
769: --
770: -- ----------------------------------------------------------------------------
771: -- |---------------------------< delete_validate >----------------------------|
776: --
777: l_proc varchar2(72) := g_package||'delete_validate';
778: --
779: Begin
780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: chk_startup_action(false
783: ,pqp_erg_shd.g_old_rec.business_group_id
784: ,pqp_erg_shd.g_old_rec.legislation_code
788: END IF;
789: --
790: -- Call all supporting business operations
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 10);
793: End delete_validate;
794: --
795: end pqp_erg_bus;