[Home] [Help]
37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------
101: l_proc varchar2(72) := g_package||'return_legislation_code';
102: --
103: Begin
104: --
105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
119: -- call to this function. Just return the value in the global
120: -- variable.
121: --
122: l_legislation_code := pay_put_bus.g_legislation_code;
123: hr_utility.set_location(l_proc, 20);
124: else
125: --
126: -- The ID is different to the last call to this function
127: -- or this is the first call to this function.
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are
143: -- available for the next call to this function.
144: --
145: close csr_leg_code;
146: pay_put_bus.g_user_table_id := p_user_table_id;
147: pay_put_bus.g_legislation_code := l_legislation_code;
148: end if;
149: hr_utility.set_location(' Leaving:'|| l_proc, 40);
150: return l_legislation_code;
151: end return_legislation_code;
152: --
153: -- ----------------------------------------------------------------------------
165: l_exists varchar2(1);
166: l_proc varchar2(100) := g_package || 'chk_legislation_code';
167: begin
168: --
169: hr_utility.set_location('Entering:'|| l_proc, 10);
170:
171: open csr_legislation_code;
172: fetch csr_legislation_code into l_exists ;
173:
177: fnd_message.raise_error;
178: end if;
179: close csr_legislation_code;
180:
181: hr_utility.set_location(' Leaving:'|| l_proc, 20);
182: --
183: exception
184: when app_exception.application_exception then
185: if hr_multi_message.exception_add
575: --
576: l_proc varchar2(72) := g_package||'insert_validate';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Call all supporting business operations
582: --
583: --
637: );
638: --
639: -- ROW_TITLE is not validated.
640: --
641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: End insert_validate;
643: --
644: -- ----------------------------------------------------------------------------
645: -- |---------------------------< update_validate >----------------------------|
651: --
652: l_proc varchar2(72) := g_package||'update_validate';
653: --
654: Begin
655: hr_utility.set_location('Entering:'||l_proc, 5);
656: --
657: -- Call all supporting business operations
658: --
659: --
694: );
695: --
696: -- ROW_TITLE is not validated.
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 10);
699: End update_validate;
700: --
701: -- ----------------------------------------------------------------------------
702: -- |---------------------------< delete_validate >----------------------------|
707: --
708: l_proc varchar2(72) := g_package||'delete_validate';
709: --
710: Begin
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: --
714: chk_startup_action(false
715: ,pay_put_shd.g_old_rec.business_group_id
730: --
731: -- Call all supporting business operations
732: --
733: chk_delete(p_user_table_id => p_rec.user_table_id);
734: hr_utility.set_location(' Leaving:'||l_proc, 10);
735: End delete_validate;
736: --
737: end pay_put_bus;