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

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

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

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

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

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

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

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

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

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

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

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

152: close csr_leg_code;
153: ota_cmb_bus.g_certification_member_id := p_certification_member_id;
154: ota_cmb_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.certification_member_id is not null) and (
198: nvl(ota_cmb_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

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

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

379: l_cmb_start_date date;
380: l_cmb_end_date date;
381:
382: Begin
383: hr_utility.set_location(' Entering:' || l_proc,10);
384: --
385: IF hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
387: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

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

426: end if;
427:
428: END IF;
429: --
430: hr_utility.set_location(' Leaving:' || l_proc,10);
431:
432: Exception
433: when app_exception.application_exception then
434: IF hr_multi_message.exception_add

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

471: l_cmb_start_date date;
472: l_cmb_end_date date;
473:
474: Begin
475: hr_utility.set_location(' Entering:' || l_proc,10);
476: --
477: IF hr_multi_message.no_exclusive_error
478: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
479: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

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

518: end if;
519:
520: END IF;
521: --
522: hr_utility.set_location(' Leaving:' || l_proc,10);
523:
524: Exception
525: when app_exception.application_exception then
526: IF hr_multi_message.exception_add

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

569: l_dup_cmb_start_date date;
570: l_dup_cmb_end_date date;
571:
572: Begin
573: hr_utility.set_location(' Entering:' || l_proc,10);
574: --
575: IF hr_multi_message.no_exclusive_error
576: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
577: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'

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

595: end if;
596:
597: end loop;
598: END IF;
599: hr_utility.set_location(' Leaving:' || l_proc,10);
600:
601: Exception
602: when app_exception.application_exception then
603: IF hr_multi_message.exception_add

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

648: l_dup_cmb_start_date date;
649: l_dup_cmb_end_date date;
650:
651: Begin
652: hr_utility.set_location(' Entering:' || l_proc,10);
653: --
654:
655: p_return_status := 'S';
656:

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

676: end if;
677:
678: end loop;
679: END IF;
680: hr_utility.set_location(' Leaving:' || l_proc,10);
681:
682: --
683: End chk_dup_cmb_dates;
684: --

Line 705: hr_utility.set_location('Entering:'|| v_proc, 5);

701: and cmb.certification_id = p_certification_id;
702: --
703: Begin
704: --
705: hr_utility.set_location('Entering:'|| v_proc, 5);
706: --
707:
708: p_return_status := 'S';
709:

Line 725: hr_utility.set_location(' Step:'|| v_proc, 30);

721:
722: end if;
723: --
724:
725: hr_utility.set_location(' Step:'|| v_proc, 30);
726:
727: END chk_if_dup_cmb_exists;
728:
729: PROCEDURE chk_should_warn_delete

Line 755: hr_utility.set_location('Entering:'|| v_proc, 5);

751: cmb.end_date_active > sysdate);
752: --
753: Begin
754: --
755: hr_utility.set_location('Entering:'|| v_proc, 5);
756: --
757:
758: p_return_status := 'S';
759:

Line 764: hr_utility.set_location(' Step:'|| v_proc, 30);

760: for a_cmb in csr_cmb_info(p_cert_mbr_id) loop
761:
762: for another_cmb in csr_cmb_exists(p_cert_mbr_id, a_cmb.certification_id) loop
763: -- There is at least one more cert member, no need to warn, just return.
764: hr_utility.set_location(' Step:'|| v_proc, 30);
765: return;
766: end loop;
767:
768: -- No other current cert members exist, so we need to warn about

Line 774: hr_utility.set_location(' Step:'|| v_proc, 30);

770: p_return_status := 'E';
771:
772: end loop;
773:
774: hr_utility.set_location(' Step:'|| v_proc, 30);
775:
776: END chk_should_warn_delete;
777: -- ----------------------------------------------------------------------------
778: -- |---------------------------< insert_validate >----------------------------|

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

784: --
785: l_proc varchar2(72) := g_package||'insert_validate';
786: --
787: Begin
788: hr_utility.set_location('Entering:'||l_proc, 5);
789: --
790: -- Call all supporting business operations
791: --
792: hr_api.validate_bus_grp_id

Line 803: hr_utility.set_location(' Step:'|| l_proc,10);

799: -- if Multiple Message detection is enabled and at least
800: -- one error has been found then abort further validation.
801: --
802: hr_multi_message.end_validation_set;
803: hr_utility.set_location(' Step:'|| l_proc,10);
804: --
805: -- Validate Dependent Attributes
806: --
807: --

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

821: ,p_cert_member_id => p_rec.certification_member_id);
822:
823: ota_cmb_bus.chk_df(p_rec);
824: --
825: hr_utility.set_location(' Leaving:'||l_proc, 10);
826: End insert_validate;
827: --
828: -- ----------------------------------------------------------------------------
829: -- |---------------------------< update_validate >----------------------------|

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

835: --
836: l_proc varchar2(72) := g_package||'update_validate';
837: --
838: Begin
839: hr_utility.set_location('Entering:'||l_proc, 5);
840: --
841: -- Call all supporting business operations
842: --
843: hr_api.validate_bus_grp_id

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

869:
870:
871: ota_cmb_bus.chk_df(p_rec);
872: --
873: hr_utility.set_location(' Leaving:'||l_proc, 10);
874: End update_validate;
875: --
876: -- ----------------------------------------------------------------------------
877: -- |---------------------------< delete_validate >----------------------------|

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

882: --
883: l_proc varchar2(72) := g_package||'delete_validate';
884: --
885: Begin
886: hr_utility.set_location('Entering:'||l_proc, 5);
887: --
888: -- Call all supporting business operations
889: --
890: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

886: hr_utility.set_location('Entering:'||l_proc, 5);
887: --
888: -- Call all supporting business operations
889: --
890: hr_utility.set_location(' Leaving:'||l_proc, 10);
891: End delete_validate;
892: --
893: end ota_cmb_bus;