DBA Data[Home] [Help]

APPS.HR_FR_PQH_EMPLOYEE_API dependencies on HR_UTILITY

Line 119: hr_utility.set_location('Entering:'|| l_proc, 5);

115: where pbg.business_group_id = p_business_group_id;
116: --
117: --
118: begin
119: hr_utility.set_location('Entering:'|| l_proc, 5);
120: --
121: -- Validation in addition to Row Handlers
122: --
123: -- Check that the specified business group is valid.

Line 130: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

126: fetch csr_bg
127: into l_legislation_code;
128: if csr_bg%notfound then
129: close csr_bg;
130: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
131: hr_utility.raise_error;
132: end if;
133: close csr_bg;
134: --

Line 131: hr_utility.raise_error;

127: into l_legislation_code;
128: if csr_bg%notfound then
129: close csr_bg;
130: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
131: hr_utility.raise_error;
132: end if;
133: close csr_bg;
134: --
135: -- Check that the legislation of the specified business group is 'FR'.

Line 138: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

134: --
135: -- Check that the legislation of the specified business group is 'FR'.
136: --
137: if l_legislation_code <> 'FR' then
138: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
139: hr_utility.set_message_token('LEG_CODE','FR');
140: hr_utility.raise_error;
141: end if;
142:

Line 139: hr_utility.set_message_token('LEG_CODE','FR');

135: -- Check that the legislation of the specified business group is 'FR'.
136: --
137: if l_legislation_code <> 'FR' then
138: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
139: hr_utility.set_message_token('LEG_CODE','FR');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 6);

Line 140: hr_utility.raise_error;

136: --
137: if l_legislation_code <> 'FR' then
138: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
139: hr_utility.set_message_token('LEG_CODE','FR');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 6);
144: /* Provisional/Definitive number not required

Line 143: hr_utility.set_location(l_proc, 6);

139: hr_utility.set_message_token('LEG_CODE','FR');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 6);
144: /* Provisional/Definitive number not required
145: --
146: -- Check that Provisonal Number is Unique or Not.
147: --

Line 152: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');

148: open provisonal_cur(p_provisional_no);
149: fetch provisonal_cur into l_var;
150: if provisonal_cur%found then
151: close provisonal_cur;
152: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
153: hr_utility.set_message_token('NAME','Provisional Number');
154: hr_utility.raise_error;
155: end if;
156: close provisonal_cur;

Line 153: hr_utility.set_message_token('NAME','Provisional Number');

149: fetch provisonal_cur into l_var;
150: if provisonal_cur%found then
151: close provisonal_cur;
152: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
153: hr_utility.set_message_token('NAME','Provisional Number');
154: hr_utility.raise_error;
155: end if;
156: close provisonal_cur;
157: --

Line 154: hr_utility.raise_error;

150: if provisonal_cur%found then
151: close provisonal_cur;
152: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
153: hr_utility.set_message_token('NAME','Provisional Number');
154: hr_utility.raise_error;
155: end if;
156: close provisonal_cur;
157: --
158: -- Check that Definitive Number is Unique or Not

Line 164: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');

160: open Definative_cur(p_definitive_no);
161: fetch Definative_cur into l_var;
162: if Definative_cur%found then
163: close Definative_cur;
164: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
165: hr_utility.set_message_token('NAME','Definitive Number');
166: hr_utility.raise_error;
167: end if;
168: close Definative_cur;

Line 165: hr_utility.set_message_token('NAME','Definitive Number');

161: fetch Definative_cur into l_var;
162: if Definative_cur%found then
163: close Definative_cur;
164: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
165: hr_utility.set_message_token('NAME','Definitive Number');
166: hr_utility.raise_error;
167: end if;
168: close Definative_cur;
169: */

Line 166: hr_utility.raise_error;

162: if Definative_cur%found then
163: close Definative_cur;
164: hr_utility.set_message(801, 'PQH_FR_UNIQUE_NO');
165: hr_utility.set_message_token('NAME','Definitive Number');
166: hr_utility.raise_error;
167: end if;
168: close Definative_cur;
169: */
170: --

Line 275: hr_utility.set_location(' Leaving:'||l_proc, 7);

271: ,p_name_combination_warning => p_name_combination_warning
272: ,p_assign_payroll_warning => p_assign_payroll_warning
273: );
274: --
275: hr_utility.set_location(' Leaving:'||l_proc, 7);
276: exception when others then
277: p_person_id := null;
278: p_assignment_id := null;
279: p_per_object_version_number := null;