DBA Data[Home] [Help]

APPS.OTA_BJT_BUS dependencies on HR_UTILITY

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

40: l_legislation_code varchar2(150);
41: --
42: begin
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error

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

81: --
82: hr_api.set_legislation_context(l_legislation_code);
83: end if;
84: --
85: hr_utility.set_location(' Leaving:'|| l_proc, 20);
86: --
87: end set_security_group_id;
88: --
89: -- ---------------------------------------------------------------------------

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

111: l_proc varchar2(72) := g_package||'return_legislation_code';
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'|| l_proc, 10);
116: --
117: -- Ensure that all the mandatory parameter are not null
118: --
119: hr_api.mandatory_arg_error

Line 136: hr_utility.set_location(l_proc, 20);

132: -- call to this function. Just return the value in the global
133: -- variable.
134: --
135: l_legislation_code := ota_bjt_bus.g_legislation_code;
136: hr_utility.set_location(l_proc, 20);
137: else
138: --
139: -- The ID is different to the last call to this function
140: -- or this is the first call to this function.

Line 153: hr_utility.set_location(l_proc,30);

149: close csr_leg_code;
150: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
151: fnd_message.raise_error;
152: end if;
153: hr_utility.set_location(l_proc,30);
154: --
155: -- Set the global variables so the values are
156: -- available for the next call to this function.
157: --

Line 163: hr_utility.set_location(' Leaving:'|| l_proc, 40);

159: ota_bjt_bus.g_booking_justification_id := p_booking_justification_id;
160: ota_bjt_bus.g_language := p_language;
161: ota_bjt_bus.g_legislation_code := l_legislation_code;
162: end if;
163: hr_utility.set_location(' Leaving:'|| l_proc, 40);
164: return l_legislation_code;
165: end return_legislation_code;
166: --
167: -- ----------------------------------------------------------------------------

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

243: AND bjt.justification_text = p_justification_text
244: AND bjt.language = USERENV('LANG')
245: AND bjt.booking_justification_id <> p_booking_justification_id ;
246: begin
247: hr_utility.set_location(' Entering :'||l_proc, 10);
248: OPEN csr_get_bg;
249: FETCH csr_get_bg INTO l_business_group_id;
250: CLOSE csr_get_bg;
251:

Line 252: hr_utility.set_location(' Inside :'||l_proc, 20);

248: OPEN csr_get_bg;
249: FETCH csr_get_bg INTO l_business_group_id;
250: CLOSE csr_get_bg;
251:
252: hr_utility.set_location(' Inside :'||l_proc, 20);
253: IF l_business_group_id IS NOT NULL THEN
254: OPEN csr_get_name(l_business_group_id);
255: FETCH csr_get_name INTO l_exists;
256: IF csr_get_name%FOUND THEN

Line 258: hr_utility.set_location(' Inside :'||l_proc, 30);

254: OPEN csr_get_name(l_business_group_id);
255: FETCH csr_get_name INTO l_exists;
256: IF csr_get_name%FOUND THEN
257: CLOSE csr_get_name;
258: hr_utility.set_location(' Inside :'||l_proc, 30);
259: fnd_message.set_name('OTA', 'OTA_443106_BJS_UNIQUE_NAME');
260: fnd_message.raise_error;
261: ELSE
262: hr_utility.set_location(' Inside :'||l_proc, 40);

Line 262: hr_utility.set_location(' Inside :'||l_proc, 40);

258: hr_utility.set_location(' Inside :'||l_proc, 30);
259: fnd_message.set_name('OTA', 'OTA_443106_BJS_UNIQUE_NAME');
260: fnd_message.raise_error;
261: ELSE
262: hr_utility.set_location(' Inside :'||l_proc, 40);
263: CLOSE csr_get_name;
264: END IF;
265: END IF;
266: EXCEPTION

Line 272: hr_utility.set_location(' Leaving:'||l_proc, 92);

268:
269: IF hr_multi_message.exception_add
270: (p_associated_column1 => 'OTA_BOOKING_JUSTIFICATIONS_VL.JUSTIFICATION_TEXT') THEN
271:
272: hr_utility.set_location(' Leaving:'||l_proc, 92);
273: RAISE;
274:
275: END IF;
276:

Line 277: hr_utility.set_location(' Leaving:'||l_proc, 94);

273: RAISE;
274:
275: END IF;
276:
277: hr_utility.set_location(' Leaving:'||l_proc, 94);
278: end chk_name;
279: --
280: --
281: -- ----------------------------------------------------------------------------

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

288: --
289: l_proc varchar2(72) := g_package||'insert_validate';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- Call all supporting business operations
295: --
296: --

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

300: --
301: chk_name( p_justification_text => p_rec.justification_text
302: ,p_booking_justification_id =>p_booking_justification_id);
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: End insert_validate;
306: --
307: -- ----------------------------------------------------------------------------
308: -- |---------------------------< update_validate >----------------------------|

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

313: --
314: l_proc varchar2(72) := g_package||'update_validate';
315: --
316: Begin
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: -- Call all supporting business operations
320: --
321: --

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

332: ,p_booking_justification_id =>p_rec.booking_justification_id);
333: END IF;
334: --
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 10);
337: End update_validate;
338: --
339: -- ----------------------------------------------------------------------------
340: -- |---------------------------< delete_validate >----------------------------|

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

345: --
346: l_proc varchar2(72) := g_package||'delete_validate';
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Call all supporting business operations
352: --
353: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Call all supporting business operations
352: --
353: hr_utility.set_location(' Leaving:'||l_proc, 10);
354: End delete_validate;
355: --
356: end ota_bjt_bus;