DBA Data[Home] [Help]

APPS.OTA_TSP_BUS dependencies on HR_UTILITY

Line 47: hr_utility.set_location('Entering:'||l_proc,10);

43: --
44: l_proc varchar2(72) := g_package || 'chk_ddf';
45: --
46: begin
47: hr_utility.set_location('Entering:'||l_proc,10);
48: --
49: if ((p_rec.skill_provision_id is not null) and (
50: nvl(ota_tsp_shd.g_old_rec.tsp_information_category, hr_api.g_varchar2) <>
51: nvl(p_rec.tsp_information_category, hr_api.g_varchar2) or

Line 146: hr_utility.set_location(' Leaving:'||l_proc,20);

142: ,p_attribute20_value => p_rec.tsp_information20
143: );
144: end if;
145: --
146: hr_utility.set_location(' Leaving:'||l_proc,20);
147: end chk_ddf;
148:
149: -- ----------------------------------------------------------------------------
150: -- |----------------------< check_analysis_criteria_id >----------------------|

Line 158: hr_utility.set_location('Entering '||l_proc, 10);

154: l_proc varchar2(30) := 'check_analysis_criteria_id';
155: --
156: Begin
157: --
158: hr_utility.set_location('Entering '||l_proc, 10);
159: --
160: if p_analysis_criteria_id is null then
161: --
162: fnd_message.set_name('OTA', 'OTA_13637_TSP_INFO_FIELD_NULL');

Line 167: hr_utility.set_location('Leaving '||l_proc, 10);

163: fnd_message.raise_error;
164: --
165: end if;
166: --
167: hr_utility.set_location('Leaving '||l_proc, 10);
168: --
169: end check_analysis_criteria_id;
170: --
171: -- ----------------------------------------------------------------------------

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

175: --
176: l_proc varchar2(72) := g_package||'insert_validate';
177: --
178: Begin
179: hr_utility.set_location('Entering:'||l_proc, 5);
180: --
181: -- Call all supporting business operations
182: --
183: check_analysis_criteria_id (p_rec.analysis_criteria_id);

Line 187: hr_utility.set_location(' Leaving:'||l_proc, 10);

183: check_analysis_criteria_id (p_rec.analysis_criteria_id);
184: --
185: --
186: ota_tsp_bus.chk_ddf(p_rec);
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End insert_validate;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |---------------------------< update_validate >----------------------------|

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

194: --
195: l_proc varchar2(72) := g_package||'update_validate';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: -- Call all supporting business operations
201: --
202: --

Line 207: hr_utility.set_location(' Leaving:'||l_proc, 10);

203: check_analysis_criteria_id (p_rec.analysis_criteria_id);
204: --
205: --
206: ota_tsp_bus.chk_ddf(p_rec);
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
208: End update_validate;
209: --
210: -- ----------------------------------------------------------------------------
211: -- |---------------------------< delete_validate >----------------------------|

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

214: --
215: l_proc varchar2(72) := g_package||'delete_validate';
216: --
217: Begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- Call all supporting business operations
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 222: hr_utility.set_location(' Leaving:'||l_proc, 10);

218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- Call all supporting business operations
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 10);
223: End delete_validate;
224: --
225:
226: --

Line 280: hr_utility.set_location('Entering:'|| l_proc, 10);

276: l_legislation_code varchar2(150);
277: --
278: begin
279: --
280: hr_utility.set_location('Entering:'|| l_proc, 10);
281: --
282: -- Ensure that all the mandatory parameter are not null
283: --
284: hr_api.mandatory_arg_error

Line 320: hr_utility.set_location(' Leaving:'|| l_proc, 20);

316: --
317: hr_api.set_legislation_context(l_legislation_code);
318: end if;
319: --
320: hr_utility.set_location(' Leaving:'|| l_proc, 20);
321: --
322: end set_security_group_id;
323:
324: --

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

372: l_proc varchar2(72) := g_package||'return_legislation_code';
373: l_legislation_code varchar2(150);
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: -- Ensure that all the mandatory parameters are not null
379: --
380: hr_api.mandatory_arg_error (p_api_name => l_proc,

Line 390: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

386: close csr_leg_code;
387: --
388: -- The primary key is invalid therefore we must error out
389: --
390: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
391: hr_utility.raise_error;
392: end if;
393: --
394: close csr_leg_code;

Line 391: hr_utility.raise_error;

387: --
388: -- The primary key is invalid therefore we must error out
389: --
390: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
391: hr_utility.raise_error;
392: end if;
393: --
394: close csr_leg_code;
395: return l_legislation_code;

Line 397: hr_utility.set_location(' Leaving:'||l_proc, 10);

393: --
394: close csr_leg_code;
395: return l_legislation_code;
396: --
397: hr_utility.set_location(' Leaving:'||l_proc, 10);
398: --
399: End return_legislation_code;
400: end ota_tsp_bus;