eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TCC_BUS dependencies on HR_UTILITY

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

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := ota_tcc_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: ota_tcc_bus.g_cross_charge_id := p_cross_charge_id;
142: ota_tcc_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

Line 252: hr_utility.set_location(' entering:'||l_proc, 10);

248: nvl(end_date_active,hr_api.g_date) <= nvl(p_end_date_active,hr_api.g_date) and
249: nvl(end_date_active,hr_api.g_date) >= p_start_date_active )) ; */
250:
251: Begin
252: hr_utility.set_location(' entering:'||l_proc, 10);
253:
254: if (((p_cross_charge_id is not null) and
255: (nvl(ota_tcc_shd.g_old_rec.start_date_active,hr_api.g_date) <>
256: nvl(p_start_date_active,hr_api.g_date) or

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

275: CLOSE TCC;
276:
277:
278: end if;
279: hr_utility.set_location(' Leaving:'||l_proc, 20);
280:
281: --
282: end chk_overlap_cc_def;
283:

Line 296: hr_utility.set_location(' entering:'||l_proc, 10);

292: l_proc varchar2(72) := g_package||'chk_end_date_ext';
293: l_exists varchar2(1);
294:
295: Begin
296: hr_utility.set_location(' entering:'||l_proc, 10);
297:
298: if (((p_cross_charge_id is not null) and
299: (nvl(ota_tcc_shd.g_old_rec.end_date_active,hr_api.g_date) <>
300: nvl(p_end_date_active,hr_api.g_date)))

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

310: end if;
311:
312:
313: end if;
314: hr_utility.set_location(' Leaving:'||l_proc, 20);
315:
316: --
317: end chk_end_date_ext;
318:

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

329: l_proc varchar2(72) := g_package||'chk_type';
330: l_api_updating boolean;
331:
332: begin
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334:
335:
336: if (((p_cross_charge_id is not null) and
337: nvl(ota_tcc_shd.g_old_rec.type,hr_api.g_varchar2) <>

Line 342: hr_utility.set_location(' entering:'||l_proc, 20);

338: nvl(p_type,hr_api.g_varchar2))
339: or
340: (p_cross_charge_id is null)) then
341:
342: hr_utility.set_location(' entering:'||l_proc, 20);
343: --
344: -- if type is not null then
345: -- check if the type value exists in hr_lookups
346: -- where lookup_type is 'OTA_CROSS_CHARGE_TYPE'

Line 356: hr_utility.set_location(' Leaving:'||l_proc, 30);

352: ,p_lookup_code => p_type) then
353: fnd_message.set_name('OTA','OTA_13334_TCC_TYPE_INVALID');
354: fnd_message.raise_error;
355: end if;
356: hr_utility.set_location(' Leaving:'||l_proc, 30);
357:
358: end if;
359:
360: end if;

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

357:
358: end if;
359:
360: end if;
361: hr_utility.set_location(' Leaving:'||l_proc, 40);
362:
363: end chk_type;
364:
365:

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

375: l_proc varchar2(72) := g_package||'chk_from_to';
376: l_api_updating boolean;
377:
378: begin
379: hr_utility.set_location(' Leaving:'||l_proc, 10);
380:
381:
382: if (((p_cross_charge_id is not null) and
383: nvl(ota_tcc_shd.g_old_rec.from_to,hr_api.g_varchar2) <>

Line 388: hr_utility.set_location(' entering:'||l_proc, 20);

384: nvl(p_from_to,hr_api.g_varchar2))
385: or
386: (p_cross_charge_id is null)) then
387:
388: hr_utility.set_location(' entering:'||l_proc, 20);
389: --
390: -- if From_to is not null then
391: -- check if the from_to value exists in hr_lookups
392: -- where lookup_type is 'OTA_CROSS_CHARGE_FROM_TO'

Line 402: hr_utility.set_location(' Leaving:'||l_proc, 30);

398: ,p_lookup_code => p_from_to) then
399: fnd_message.set_name('OTA','OTA_13341_TCC_FROM_TO_INVALID');
400: fnd_message.raise_error;
401: end if;
402: hr_utility.set_location(' Leaving:'||l_proc, 30);
403:
404: end if;
405:
406: end if;

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

403:
404: end if;
405:
406: end if;
407: hr_utility.set_location(' Leaving:'||l_proc, 40);
408:
409: end chk_from_to;
410:
411: --

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

419: --
420: l_proc varchar2(72) := g_package||'insert_validate';
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: -- Call all supporting business operations
426: --
427: chk_overlap_cc_def

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

446:
447: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
448: --
449: --
450: hr_utility.set_location(' Leaving:'||l_proc, 10);
451: End insert_validate;
452: --
453: -- ----------------------------------------------------------------------------
454: -- |---------------------------< update_validate >----------------------------|

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

460: --
461: l_proc varchar2(72) := g_package||'update_validate';
462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: -- Call all supporting business operations
467: --
468: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

496: ,p_effective_date => p_effective_date);
497:
498: --
499: --
500: hr_utility.set_location(' Leaving:'||l_proc, 10);
501: End update_validate;
502: --
503: -- ----------------------------------------------------------------------------
504: -- |---------------------------< delete_validate >----------------------------|

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

509: --
510: l_proc varchar2(72) := g_package||'delete_validate';
511: --
512: Begin
513: hr_utility.set_location('Entering:'||l_proc, 5);
514: --
515: -- Call all supporting business operations
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

513: hr_utility.set_location('Entering:'||l_proc, 5);
514: --
515: -- Call all supporting business operations
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 10);
518: End delete_validate;
519: --
520: end ota_tcc_bus;