2: /* $Header: peconfii.pkb 120.1.12000000.2 2007/02/14 12:17:11 dbehera ship $ */
3: --
4: -- Package Variables
5: g_package varchar2(33) := 'hr_fi_contact_api';
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: --
9: -- ----------------------------------------------------------------------------
10: -- |----------------------------< create_fi_person >-----------------------------|
114: where bgp.business_group_id = c_business_group_id;
115: begin
116:
117: if g_debug then
118: hr_utility.set_location('Entering:'|| l_proc, 5);
119: end if;
120: --
121: -- Validation in addition to Row Handlers
122: --
124: open check_legislation(p_business_group_id);
125: fetch check_legislation into l_legislation_code;
126: close check_legislation;
127: if g_debug then
128: hr_utility.set_location(l_proc, 20);
129: end if;
130: --
131: -- Check that the legislation of the specified business group is 'FI'.
132: --
130: --
131: -- Check that the legislation of the specified business group is 'FI'.
132: --
133: if l_legislation_code <> 'FI' then
134: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
135: hr_utility.set_message_token('LEG_CODE','FI');
136: hr_utility.raise_error;
137: end if;
138:
131: -- Check that the legislation of the specified business group is 'FI'.
132: --
133: if l_legislation_code <> 'FI' then
134: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
135: hr_utility.set_message_token('LEG_CODE','FI');
136: hr_utility.raise_error;
137: end if;
138:
139: if p_membership_start_date is not null and p_membership_end_date is not null and
132: --
133: if l_legislation_code <> 'FI' then
134: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
135: hr_utility.set_message_token('LEG_CODE','FI');
136: hr_utility.raise_error;
137: end if;
138:
139: if p_membership_start_date is not null and p_membership_end_date is not null and
140: p_membership_start_date > p_membership_end_date then
137: end if;
138:
139: if p_membership_start_date is not null and p_membership_end_date is not null and
140: p_membership_start_date > p_membership_end_date then
141: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
142: hr_utility.set_message_token('LEG_CODE','FI');
143: hr_utility.raise_error;
144: end if;
145:
138:
139: if p_membership_start_date is not null and p_membership_end_date is not null and
140: p_membership_start_date > p_membership_end_date then
141: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
142: hr_utility.set_message_token('LEG_CODE','FI');
143: hr_utility.raise_error;
144: end if;
145:
146: if g_debug then
139: if p_membership_start_date is not null and p_membership_end_date is not null and
140: p_membership_start_date > p_membership_end_date then
141: hr_utility.set_message(801, 'HR_376639_FI_VALID_DATE');
142: hr_utility.set_message_token('LEG_CODE','FI');
143: hr_utility.raise_error;
144: end if;
145:
146: if g_debug then
147: hr_utility.set_location(l_proc, 30);
143: hr_utility.raise_error;
144: end if;
145:
146: if g_debug then
147: hr_utility.set_location(l_proc, 30);
148: end if;
149:
150: hr_contact_api.create_person
151: (p_validate => p_validate
239: ,p_orig_hire_warning => p_orig_hire_warning);
240:
241: --
242: if g_debug then
243: hr_utility.set_location(' Leaving:'||l_proc, 7);
244: end if;
245: --
246: end create_fi_person;
247: