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_OCL_BUS dependencies on HR_UTILITY

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

46: l_proc varchar2(72) := g_package||'set_security_group_id';
47: --
48: begin
49: --
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: --
52: -- Ensure that all the mandatory parameter are not null
53: --
54: hr_api.mandatory_arg_error

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

77: hr_api.set_security_group_id
78: (p_security_group_id => l_security_group_id
79: );
80: --
81: hr_utility.set_location(' Leaving:'|| l_proc, 20);
82: --
83: end set_security_group_id;
84: --
85: -- ---------------------------------------------------------------------------

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

106: l_proc varchar2(72) := g_package||'return_legislation_code';
107: --
108: Begin
109: --
110: hr_utility.set_location('Entering:'|| l_proc, 10);
111: --
112: -- Ensure that all the mandatory parameter are not null
113: --
114: hr_api.mandatory_arg_error

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

124: -- call to this function. Just return the value in the global
125: -- variable.
126: --
127: l_legislation_code := ota_ocl_bus.g_legislation_code;
128: hr_utility.set_location(l_proc, 20);
129: else
130: --
131: -- The ID is different to the last call to this function
132: -- or this is the first call to this function.

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

141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --
147: -- Set the global variables so the values are
148: -- available for the next call to this function.
149: --

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

150: close csr_leg_code;
151: ota_ocl_bus.g_competence_language_id:= p_competence_language_id;
152: ota_ocl_bus.g_legislation_code := l_legislation_code;
153: end if;
154: hr_utility.set_location(' Leaving:'|| l_proc, 40);
155: return l_legislation_code;
156: end return_legislation_code;
157: --
158: -- ----------------------------------------------------------------------------

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

189: --
190: l_proc varchar2(72) := g_package || 'chk_ddf';
191: --
192: begin
193: hr_utility.set_location('Entering:'||l_proc,10);
194: --
195: if ((p_rec.competence_language_id is not null) and (
196: nvl(ota_ocl_shd.g_old_rec.ocl_information_category, hr_api.g_varchar2) <>
197: nvl(p_rec.ocl_information_category, hr_api.g_varchar2) or

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

290: ,p_attribute20_value => p_rec.ocl_information20
291: );
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,20);
295: end chk_ddf;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |-----------------------< chk_non_updateable_args >------------------------|

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

389: (business_group_id = l_business_group_id OR
390: business_group_id is null);
391:
392: Begin
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: --
395: if l_business_group_id is null then
396: l_business_group_id := p_business_group_id;
397: end if;

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

403: nvl(ota_ocl_shd.g_old_rec.competence_id,hr_api.g_number) <>
404: nvl(p_competence_id,hr_api.g_number))
405: or (p_competence_language_id is null)) then
406: --
407: hr_utility.set_location('Entering:'||l_proc, 10);
408: if (p_competence_id is not null) then
409: hr_utility.set_location('Entering:'||l_proc, 15);
410: if ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and
411: l_hr_cross ='N') or

Line 409: hr_utility.set_location('Entering:'||l_proc, 15);

405: or (p_competence_language_id is null)) then
406: --
407: hr_utility.set_location('Entering:'||l_proc, 10);
408: if (p_competence_id is not null) then
409: hr_utility.set_location('Entering:'||l_proc, 15);
410: if ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and
411: l_hr_cross ='N') or
412: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and
413: l_hr_cross = 'N' )then

Line 422: hr_utility.set_location('Entering:'||l_proc, 20);

418: fnd_message.set_name('OTA','OTA_OCL_COMP_NOT_EXIST');
419: fnd_message.raise_error;
420: end if;
421: close csr_competence;
422: hr_utility.set_location('Entering:'||l_proc, 20);
423: elsif ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and
424: l_hr_cross ='Y') or
425: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and
426: l_hr_cross ='Y' )then

Line 427: hr_utility.set_location('Entering:'||l_proc, 25);

423: elsif ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and
424: l_hr_cross ='Y') or
425: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is null and
426: l_hr_cross ='Y' )then
427: hr_utility.set_location('Entering:'||l_proc, 25);
428: open csr_competence_cross;
429: fetch csr_competence_cross into l_exists;
430: if csr_competence_cross%notfound then
431: close csr_competence_cross;

Line 436: hr_utility.set_location('Entering:'||l_proc, 30);

432: fnd_message.set_name('OTA','OTA_OCL_COMP_NOT_EXIST');
433: fnd_message.raise_error;
434: end if;
435: close csr_competence_cross;
436: hr_utility.set_location('Entering:'||l_proc, 30);
437:
438: end if;
439: end if;
440: end if;

Line 446: hr_utility.set_location(' Leaving:'||l_proc, 35);

442: --
443: --
444: --
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 35);
447: End chk_competence;
448:
449: -- ----------------------------------------------------------------------------
450: -- |---------------------------< chk_proficiency>----------------------------|

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

479: AND prl.rating_level_id = p_min_proficiency_level_id;
480:
481:
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: --
485: -- Call all supporting business operations
486: if (((p_competence_language_id is not null) and
487: nvl(ota_ocl_shd.g_old_rec.min_proficiency_level_id,hr_api.g_number) <>

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

487: nvl(ota_ocl_shd.g_old_rec.min_proficiency_level_id,hr_api.g_number) <>
488: nvl(p_min_proficiency_level_id,hr_api.g_number))
489: or (p_competence_language_id is null)) then
490: --
491: hr_utility.set_location('Entering:'||l_proc, 10);
492: if (p_min_proficiency_level_id is not null) then
493: hr_utility.set_location('Entering:'||l_proc, 15);
494: open csr_proficiency ;
495: fetch csr_proficiency into l_exists;

Line 493: hr_utility.set_location('Entering:'||l_proc, 15);

489: or (p_competence_language_id is null)) then
490: --
491: hr_utility.set_location('Entering:'||l_proc, 10);
492: if (p_min_proficiency_level_id is not null) then
493: hr_utility.set_location('Entering:'||l_proc, 15);
494: open csr_proficiency ;
495: fetch csr_proficiency into l_exists;
496: if csr_proficiency %notfound then
497: close csr_proficiency ;

Line 502: hr_utility.set_location('Entering:'||l_proc, 20);

498: fnd_message.set_name('OTA','OTA_OCL_PROF_LEVEL_NOT_EXIST');
499: fnd_message.raise_error;
500: end if;
501: close csr_proficiency;
502: hr_utility.set_location('Entering:'||l_proc, 20);
503: end if;
504: end if;
505:
506: --

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

506: --
507: --
508: --
509: --
510: hr_utility.set_location(' Leaving:'||l_proc, 10);
511: End chk_proficiency;
512:
513:
514: -- ----------------------------------------------------------------------------

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

530: FROM OTA_NATURAL_LANGUAGES_V
531: WHERE LANGUAGE_code = p_language_code;
532:
533: Begin
534: hr_utility.set_location('Entering:'||l_proc, 5);
535: --
536: -- Call all supporting business operations
537: if (((p_competence_language_id is not null) and
538: nvl(ota_ocl_shd.g_old_rec.language_code,hr_api.g_number) <>

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

538: nvl(ota_ocl_shd.g_old_rec.language_code,hr_api.g_number) <>
539: nvl(p_language_code,hr_api.g_varchar2))
540: or (p_competence_language_id is null)) then
541: --
542: hr_utility.set_location('Entering:'||l_proc, 10);
543: if (p_language_code is not null) then
544: hr_utility.set_location('Entering:'||l_proc, 15);
545: open csr_language;
546: fetch csr_language into l_exists;

Line 544: hr_utility.set_location('Entering:'||l_proc, 15);

540: or (p_competence_language_id is null)) then
541: --
542: hr_utility.set_location('Entering:'||l_proc, 10);
543: if (p_language_code is not null) then
544: hr_utility.set_location('Entering:'||l_proc, 15);
545: open csr_language;
546: fetch csr_language into l_exists;
547: if csr_language%notfound then
548: close csr_language;

Line 553: hr_utility.set_location('Entering:'||l_proc, 20);

549: fnd_message.set_name('OTA','OTA_OCL_LANG_NOT_EXIST');
550: fnd_message.raise_error;
551: end if;
552: close csr_language;
553: hr_utility.set_location('Entering:'||l_proc, 20);
554: end if;
555: end if;
556:
557: --

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

557: --
558: --
559: --
560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 10);
562: End chk_language;
563:
564:
565: --

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

573: --
574: l_proc varchar2(72) := g_package||'insert_validate';
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -- Call all supporting business operations
580: --
581: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

603: ,p_effective_date => p_effective_date
604: ,p_language_code => p_rec.language_code
605: ) ;
606: --
607: hr_utility.set_location(' Leaving:'||l_proc, 10);
608: End insert_validate;
609: --
610: -- ----------------------------------------------------------------------------
611: -- |---------------------------< update_validate >----------------------------|

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

617: --
618: l_proc varchar2(72) := g_package||'update_validate';
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: -- Call all supporting business operations
624: --
625: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

653: ) ;
654:
655:
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: End update_validate;
659: --
660: -- ----------------------------------------------------------------------------
661: -- |---------------------------< delete_validate >----------------------------|

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

666: --
667: l_proc varchar2(72) := g_package||'delete_validate';
668: --
669: Begin
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: -- Call all supporting business operations
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: -- Call all supporting business operations
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 10);
675: End delete_validate;
676: --
677: end ota_ocl_bus;