55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
57: -- Ensure that all the mandatory parameter are not null
58: --
59: hr_api.mandatory_arg_error
60: (p_api_name => l_proc
61: ,p_argument => 'forum_thread_id'
62: ,p_argument_value => p_forum_thread_id
63: );
60: (p_api_name => l_proc
61: ,p_argument => 'forum_thread_id'
62: ,p_argument_value => p_forum_thread_id
63: );
64: hr_api.mandatory_arg_error
65: (p_api_name => l_proc
66: ,p_argument => 'forum_id'
67: ,p_argument_value => p_forum_id
68: );
65: (p_api_name => l_proc
66: ,p_argument => 'forum_id'
67: ,p_argument_value => p_forum_id
68: );
69: hr_api.mandatory_arg_error
70: (p_api_name => l_proc
71: ,p_argument => 'person_id'
72: ,p_argument_value => p_person_id
73: );
70: (p_api_name => l_proc
71: ,p_argument => 'person_id'
72: ,p_argument_value => p_person_id
73: );
74: hr_api.mandatory_arg_error
75: (p_api_name => l_proc
76: ,p_argument => 'contact_id'
77: ,p_argument_value => p_contact_id
78: );
103: close csr_sec_grp;
104: --
105: -- Set the security_group_id in CLIENT_INFO
106: --
107: hr_api.set_security_group_id
108: (p_security_group_id => l_security_group_id
109: );
110: --
111: -- Set the sessions legislation context in HR_SESSION_DATA
109: );
110: --
111: -- Set the sessions legislation context in HR_SESSION_DATA
112: --
113: hr_api.set_legislation_context(l_legislation_code);
114: end if;
115: --
116: hr_utility.set_location(' Leaving:'|| l_proc, 20);
117: --
151: hr_utility.set_location('Entering:'|| l_proc, 10);
152: --
153: -- Ensure that all the mandatory parameter are not null
154: --
155: hr_api.mandatory_arg_error
156: (p_api_name => l_proc
157: ,p_argument => 'forum_thread_id'
158: ,p_argument_value => p_forum_thread_id
159: );
156: (p_api_name => l_proc
157: ,p_argument => 'forum_thread_id'
158: ,p_argument_value => p_forum_thread_id
159: );
160: hr_api.mandatory_arg_error
161: (p_api_name => l_proc
162: ,p_argument => 'forum_id'
163: ,p_argument_value => p_forum_id
164: );
161: (p_api_name => l_proc
162: ,p_argument => 'forum_id'
163: ,p_argument_value => p_forum_id
164: );
165: hr_api.mandatory_arg_error
166: (p_api_name => l_proc
167: ,p_argument => 'person_id'
168: ,p_argument_value => p_person_id
169: );
166: (p_api_name => l_proc
167: ,p_argument => 'person_id'
168: ,p_argument_value => p_person_id
169: );
170: hr_api.mandatory_arg_error
171: (p_api_name => l_proc
172: ,p_argument => 'contact_id'
173: ,p_argument_value => p_contact_id
174: );
172: ,p_argument => 'contact_id'
173: ,p_argument_value => p_contact_id
174: );
175: --
176: if (( nvl(ota_ftu_bus.g_forum_thread_id, hr_api.g_number)
177: = p_forum_thread_id)
178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)
179: = p_forum_id)
180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)
174: );
175: --
176: if (( nvl(ota_ftu_bus.g_forum_thread_id, hr_api.g_number)
177: = p_forum_thread_id)
178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)
179: = p_forum_id)
180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)
181: = p_person_id)
182: and ( nvl(ota_ftu_bus.g_contact_id, hr_api.g_number)
176: if (( nvl(ota_ftu_bus.g_forum_thread_id, hr_api.g_number)
177: = p_forum_thread_id)
178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)
179: = p_forum_id)
180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)
181: = p_person_id)
182: and ( nvl(ota_ftu_bus.g_contact_id, hr_api.g_number)
183: = p_contact_id)) then
184: --
178: and ( nvl(ota_ftu_bus.g_forum_id, hr_api.g_number)
179: = p_forum_id)
180: and ( nvl(ota_ftu_bus.g_person_id, hr_api.g_number)
181: = p_person_id)
182: and ( nvl(ota_ftu_bus.g_contact_id, hr_api.g_number)
183: = p_contact_id)) then
184: --
185: -- The legislation code has already been found with a previous
186: -- call to this function. Just return the value in the global
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Call all supporting business operations
298: --
299: hr_api.validate_bus_grp_id
300: (p_business_group_id => p_rec.business_group_id
301: ,p_associated_column1 => ota_ftu_shd.g_tab_nam
302: || '.BUSINESS_GROUP_ID');
303: --
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Call all supporting business operations
330: --
331: hr_api.validate_bus_grp_id
332: (p_business_group_id => p_rec.business_group_id
333: ,p_associated_column1 => ota_ftu_shd.g_tab_nam
334: || '.BUSINESS_GROUP_ID');
335: --