51: hr_utility.set_location('Entering:'|| l_proc, 10);
52: --
53: -- Ensure that all the mandatory parameter are not null
54: --
55: hr_api.mandatory_arg_error
56: (p_api_name => l_proc
57: ,p_argument => 'forum_id'
58: ,p_argument_value => p_forum_id
59: );
56: (p_api_name => l_proc
57: ,p_argument => 'forum_id'
58: ,p_argument_value => p_forum_id
59: );
60: hr_api.mandatory_arg_error
61: (p_api_name => l_proc
62: ,p_argument => 'person_id'
63: ,p_argument_value => p_person_id
64: );
61: (p_api_name => l_proc
62: ,p_argument => 'person_id'
63: ,p_argument_value => p_person_id
64: );
65: hr_api.mandatory_arg_error
66: (p_api_name => l_proc
67: ,p_argument => 'contact_id'
68: ,p_argument_value => p_contact_id
69: );
92: close csr_sec_grp;
93: --
94: -- Set the security_group_id in CLIENT_INFO
95: --
96: hr_api.set_security_group_id
97: (p_security_group_id => l_security_group_id
98: );
99: --
100: -- Set the sessions legislation context in HR_SESSION_DATA
98: );
99: --
100: -- Set the sessions legislation context in HR_SESSION_DATA
101: --
102: hr_api.set_legislation_context(l_legislation_code);
103: end if;
104: --
105: hr_utility.set_location(' Leaving:'|| l_proc, 20);
106: --
138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: -- Ensure that all the mandatory parameter are not null
141: --
142: hr_api.mandatory_arg_error
143: (p_api_name => l_proc
144: ,p_argument => 'forum_id'
145: ,p_argument_value => p_forum_id
146: );
143: (p_api_name => l_proc
144: ,p_argument => 'forum_id'
145: ,p_argument_value => p_forum_id
146: );
147: hr_api.mandatory_arg_error
148: (p_api_name => l_proc
149: ,p_argument => 'person_id'
150: ,p_argument_value => p_person_id
151: );
148: (p_api_name => l_proc
149: ,p_argument => 'person_id'
150: ,p_argument_value => p_person_id
151: );
152: hr_api.mandatory_arg_error
153: (p_api_name => l_proc
154: ,p_argument => 'contact_id'
155: ,p_argument_value => p_contact_id
156: );
154: ,p_argument => 'contact_id'
155: ,p_argument_value => p_contact_id
156: );
157: --
158: if (( nvl(ota_fns_bus.g_forum_id, hr_api.g_number)
159: = p_forum_id)
160: and ( nvl(ota_fns_bus.g_person_id, hr_api.g_number)
161: = p_person_id)
162: and ( nvl(ota_fns_bus.g_contact_id, hr_api.g_number)
156: );
157: --
158: if (( nvl(ota_fns_bus.g_forum_id, hr_api.g_number)
159: = p_forum_id)
160: and ( nvl(ota_fns_bus.g_person_id, hr_api.g_number)
161: = p_person_id)
162: and ( nvl(ota_fns_bus.g_contact_id, hr_api.g_number)
163: = p_contact_id)) then
164: --
158: if (( nvl(ota_fns_bus.g_forum_id, hr_api.g_number)
159: = p_forum_id)
160: and ( nvl(ota_fns_bus.g_person_id, hr_api.g_number)
161: = p_person_id)
162: and ( nvl(ota_fns_bus.g_contact_id, hr_api.g_number)
163: = p_contact_id)) then
164: --
165: -- The legislation code has already been found with a previous
166: -- call to this function. Just return the value in the global
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Call all supporting business operations
275: --
276: hr_api.validate_bus_grp_id
277: (p_business_group_id => p_rec.business_group_id
278: ,p_associated_column1 => ota_fns_shd.g_tab_nam
279: || '.BUSINESS_GROUP_ID');
280: --
304: hr_utility.set_location('Entering:'||l_proc, 5);
305: --
306: -- Call all supporting business operations
307: --
308: hr_api.validate_bus_grp_id
309: (p_business_group_id => p_rec.business_group_id
310: ,p_associated_column1 => ota_fns_shd.g_tab_nam
311: || '.BUSINESS_GROUP_ID');
312: --