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

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

31: l_proc varchar2(72) := g_package||'set_security_group_id';
32: --
33: begin
34: --
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Ensure that all the mandatory parameter are not null
38: --
39: hr_api.mandatory_arg_error

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

62: hr_api.set_security_group_id
63: (p_security_group_id => l_security_group_id
64: );
65: --
66: hr_utility.set_location(' Leaving:'|| l_proc, 20);
67: --
68: end set_security_group_id;
69:
70: --

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

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

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

110: -- call to this function. Just return the value in the global
111: -- variable.
112: --
113: l_legislation_code := ota_nhs_bus.g_legislation_code;
114: hr_utility.set_location(l_proc, 20);
115: else
116: --
117: -- The ID is different to the last call to this function
118: -- or this is the first call to this function.

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

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

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

136: close csr_leg_code;
137: ota_nhs_bus.g_nota_history_id := p_nota_history_id;
138: ota_nhs_bus.g_legislation_code := l_legislation_code;
139: end if;
140: hr_utility.set_location(' Leaving:'|| l_proc, 40);
141: return l_legislation_code;
142: end return_legislation_code;
143: --
144: -- ----------------------------------------------------------------------------

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

175: --
176: l_proc varchar2(72) := g_package || 'chk_df';
177: --
178: begin
179: hr_utility.set_location('Entering:'||l_proc,10);
180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or

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

276: ,p_attribute20_value => p_rec.nth_information20
277: );
278: end if;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc,20);
281: end chk_df;
282: --
283: -- ----------------------------------------------------------------------------
284: -- |-----------------------< chk_non_updateable_args >------------------------|

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

396: where organization_id = p_organization_id ;
397:
398:
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: ota_nhs_bus.get_profile_value(l_cross_business_group,
402: l_business_group_id );
403:
404: if (((p_nota_history_id is not null) and

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

405: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number) <>
406: nvl(p_organization_id,hr_api.g_number))
407: or (p_nota_history_id is null)) then
408: --
409: hr_utility.set_location('Entering:'||l_proc, 10);
410: if (p_organization_id is not null) then
411: hr_utility.set_location('Entering:'||l_proc, 15);
412: If l_business_group_id is not null then
413: open csr_organization_cross;

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

407: or (p_nota_history_id is null)) then
408: --
409: hr_utility.set_location('Entering:'||l_proc, 10);
410: if (p_organization_id is not null) then
411: hr_utility.set_location('Entering:'||l_proc, 15);
412: If l_business_group_id is not null then
413: open csr_organization_cross;
414: fetch csr_organization_cross into l_exists;
415: if csr_organization_cross%notfound then

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

417: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
418: fnd_message.raise_error;
419: end if;
420: close csr_organization_cross;
421: hr_utility.set_location('Entering:'||l_proc, 20);
422:
423: else
424: open csr_organization;
425: fetch csr_organization into l_exists;

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

428: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
429: fnd_message.raise_error;
430: end if;
431: close csr_organization;
432: hr_utility.set_location('Entering:'||l_proc, 25);
433: end if;
434: end if;
435: end if;
436: hr_utility.set_location('Entering:'||l_proc, 30);

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

432: hr_utility.set_location('Entering:'||l_proc, 25);
433: end if;
434: end if;
435: end if;
436: hr_utility.set_location('Entering:'||l_proc, 30);
437: end chk_organization_id;
438:
439:
440: -- ----------------------------------------------------------------------------

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

459: Where CUST_ACCT.party_id = PARTY.party_id
460: and CUST_ACCT.cust_account_id=p_customer_id;
461:
462: Begin
463: hr_utility.set_location('Entering:'||l_proc, 5);
464:
465: if (((p_nota_history_id is not null) and
466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>
467: nvl(p_customer_id,hr_api.g_number))

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

466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>
467: nvl(p_customer_id,hr_api.g_number))
468: or (p_nota_history_id is null)) then
469: --
470: hr_utility.set_location('Entering:'||l_proc, 10);
471: if (p_customer_id is not null) then
472: hr_utility.set_location('Entering:'||l_proc, 15);
473: open csr_customer;
474: fetch csr_customer into l_exists;

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

468: or (p_nota_history_id is null)) then
469: --
470: hr_utility.set_location('Entering:'||l_proc, 10);
471: if (p_customer_id is not null) then
472: hr_utility.set_location('Entering:'||l_proc, 15);
473: open csr_customer;
474: fetch csr_customer into l_exists;
475: if csr_customer%notfound then
476: close csr_customer;

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

477: fnd_message.set_name('OTA','OTA_13321_TFH_CUSTOMER_NAME');
478: fnd_message.raise_error;
479: end if;
480: close csr_customer;
481: hr_utility.set_location('Entering:'||l_proc, 20);
482: end if;
483: end if;
484: hr_utility.set_location('Entering:'||l_proc, 30);
485: end chk_customer_id;

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

480: close csr_customer;
481: hr_utility.set_location('Entering:'||l_proc, 20);
482: end if;
483: end if;
484: hr_utility.set_location('Entering:'||l_proc, 30);
485: end chk_customer_id;
486:
487: -- ----------------------------------------------------------------------------
488: -- |---------------------------< chk_person_id >----------------------------|

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

543: p_effective_date between per.effective_start_date and
544: per.effective_end_date ;
545: */
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548:
549: ota_nhs_bus.get_profile_value(l_cross_business_group,
550: l_business_group_id );
551:

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

554: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number) <>
555: nvl(p_person_id,hr_api.g_number))
556: or (p_nota_history_id is null)) then
557: --
558: hr_utility.set_location('Entering:'||l_proc, 10);
559: if p_person_id is not null then
560: if p_customer_id is null and p_organization_id is null then
561: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
562: fnd_message.raise_error;

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

563: end if;
564: end if;
565: if (p_customer_id is not null) then
566: if p_person_id is not null then
567: hr_utility.set_location('Entering:'||l_proc, 15);
568: open cus_contact;
569: fetch cus_contact into l_exists;
570: if cus_contact%notfound then
571: close cus_contact;

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

572: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
573: fnd_message.raise_error;
574: end if;
575: close cus_contact;
576: hr_utility.set_location('Entering:'||l_proc, 20);
577: end if;
578: elsif (p_organization_id is not null) then
579: if p_person_id is not null then
580: hr_utility.set_location('Entering:'||l_proc, 30);

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

576: hr_utility.set_location('Entering:'||l_proc, 20);
577: end if;
578: elsif (p_organization_id is not null) then
579: if p_person_id is not null then
580: hr_utility.set_location('Entering:'||l_proc, 30);
581: If l_business_group_id is not null then
582: open org_person_cross;
583: fetch org_person_cross into l_exists;
584: if org_person_cross%notfound then

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

597: fnd_message.raise_error;
598: end if;
599: close org_person;
600: end if;
601: hr_utility.set_location('Entering:'||l_proc, 40);
602: end if;
603: end if;
604: end if;
605: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 605: hr_utility.set_location(' Leaving:'||l_proc, 50);

601: hr_utility.set_location('Entering:'||l_proc, 40);
602: end if;
603: end if;
604: end if;
605: hr_utility.set_location(' Leaving:'||l_proc, 50);
606: End chk_person_id;
607:
608:
609: -- ----------------------------------------------------------------------------

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

647: p_effective_date between effective_start_date and
648: effective_end_date ;
649:
650: Begin
651: hr_utility.set_location('Entering:'||l_proc, 5);
652:
653: if (((p_nota_history_id is not null) and
654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>
655: nvl(p_contact_id,hr_api.g_number))

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

654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>
655: nvl(p_contact_id,hr_api.g_number))
656: or (p_nota_history_id is null)) then
657: --
658: hr_utility.set_location('Entering:'||l_proc, 10);
659:
660: if (p_customer_id is not null) then
661: if p_contact_id is not null then
662: hr_utility.set_location('Entering:'||l_proc, 15);

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

658: hr_utility.set_location('Entering:'||l_proc, 10);
659:
660: if (p_customer_id is not null) then
661: if p_contact_id is not null then
662: hr_utility.set_location('Entering:'||l_proc, 15);
663: open cus_contact;
664: fetch cus_contact into l_exists;
665: if cus_contact%notfound then
666: close cus_contact;

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

667: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');
668: fnd_message.raise_error;
669: end if;
670: close cus_contact;
671: hr_utility.set_location('Entering:'||l_proc, 20);
672: end if;
673: elsif (p_organization_id is not null) then
674: if p_contact_id is not null then
675: hr_utility.set_location('Entering:'||l_proc, 30);

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

671: hr_utility.set_location('Entering:'||l_proc, 20);
672: end if;
673: elsif (p_organization_id is not null) then
674: if p_contact_id is not null then
675: hr_utility.set_location('Entering:'||l_proc, 30);
676: open org_person;
677: fetch org_person into l_exists;
678: if org_person%notfound then
679: close org_person;

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

680: fnd_message.set_name('HR','HR_51889_APR_PERSON_NOT_EXIST');
681: fnd_message.raise_error;
682: end if;
683: close org_person;
684: hr_utility.set_location('Entering:'||l_proc, 40);
685: end if;
686: end if;
687: end if;
688: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 688: hr_utility.set_location(' Leaving:'||l_proc, 50);

684: hr_utility.set_location('Entering:'||l_proc, 40);
685: end if;
686: end if;
687: end if;
688: hr_utility.set_location(' Leaving:'||l_proc, 50);
689: End chk_contact_id;
690:
691:
692: -- ----------------------------------------------------------------------------

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

701: l_proc varchar2(72) := g_package||'chk_status';
702: l_api_updating boolean;
703:
704: begin
705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: --
707: -- check mandatory parameters has been set
708: --
709: hr_api.mandatory_arg_error

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

717: nvl(p_status,hr_api.g_varchar2))
718: or
719: (p_nota_history_id is null)) then
720:
721: hr_utility.set_location(' Leaving:'||l_proc, 20);
722: --
723: -- if status is not null then
724: -- check if the status value exists in hr_lookups
725: -- where lookup_type is 'OTA_TRAINING_STATUSES'

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

731: ,p_lookup_code => p_status) then
732: fnd_message.set_name('OTA','OTA_13880_NHS_STATUS_INVALID');
733: fnd_message.raise_error;
734: end if;
735: hr_utility.set_location(' Leaving:'||l_proc, 30);
736:
737: end if;
738:
739: end if;

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

736:
737: end if;
738:
739: end if;
740: hr_utility.set_location(' Leaving:'||l_proc, 40);
741:
742: end chk_status;
743: -- ----------------------------------------------------------------------------
744: -- |---------------------------< chk_type >----------------------------|

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

752: l_proc varchar2(72) := g_package||'chk_type';
753: l_api_updating boolean;
754:
755: begin
756: hr_utility.set_location(' Leaving:'||l_proc, 10);
757: --
758: -- check mandatory parameters has been set
759: --
760: hr_api.mandatory_arg_error

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

767: nvl(p_type,hr_api.g_varchar2))
768: or
769: (p_nota_history_id is null)) then
770:
771: hr_utility.set_location(' Leaving:'||l_proc, 20);
772: --
773: -- if status is not null then
774: -- check if the status value exists in hr_lookups
775: -- where lookup_type is 'OTA_TRAINING_TYPES'

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

781: ,p_lookup_code => p_type) then
782: fnd_message.set_name('OTA','OTA_13879_NHS_TYPE_INVALID');
783: fnd_message.raise_error;
784: end if;
785: hr_utility.set_location(' Leaving:'||l_proc, 30);
786:
787: end if;
788:
789: end if;

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

786:
787: end if;
788:
789: end if;
790: hr_utility.set_location(' Leaving:'||l_proc, 40);
791:
792: end chk_type;
793:
794:

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

804: l_proc varchar2(72) := g_package||'chk_duration_units';
805: l_api_updating boolean;
806:
807: begin
808: hr_utility.set_location(' Leaving:'||l_proc, 10);
809: --
810: -- check mandatory parameters has been set
811: --
812: hr_api.mandatory_arg_error

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

820: nvl(p_duration_units,hr_api.g_varchar2))
821: or
822: (p_nota_history_id is null)) then
823:
824: hr_utility.set_location(' Leaving:'||l_proc, 20);
825: --
826: -- if status is not null then
827: -- check if the status value exists in hr_lookups
828: -- where lookup_type is 'FREQUENCY'

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

834: ,p_lookup_code => p_duration_units) then
835: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');
836: fnd_message.raise_error;
837: end if;
838: hr_utility.set_location(' Leaving:'||l_proc, 30);
839:
840: end if;
841:
842: end if;

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

839:
840: end if;
841:
842: end if;
843: hr_utility.set_location(' Leaving:'||l_proc, 40);
844:
845: end chk_duration_unit;
846:
847: -- ----------------------------------------------------------------------------

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

857: l_proc varchar2(72) := g_package ||'chk_comb_duration';
858: l_api_updating boolean;
859:
860: begin
861: hr_utility.set_location(' Leaving:'||l_proc, 10);
862: if (p_duration is not null and
863: p_duration_units is null ) or
864: (p_duration is null and
865: p_duration_units is not null ) then

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

866: fnd_message.set_name('OTA','OTA_13881_NHS_COMB_INVALID');
867: fnd_message.raise_error;
868:
869: end if;
870: hr_utility.set_location(' Leaving:'||l_proc, 20);
871:
872: end chk_comb_duration;
873:
874: -- |---------------------------< get_profile_value >------------------------|

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

920: --
921: l_proc varchar2(72) := g_package||'insert_validate';
922: --
923: Begin
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: -- Call all supporting business operations
927: --
928: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

969:
970:
971: chk_df(p_rec);
972:
973: hr_utility.set_location(' Leaving:'||l_proc, 10);
974: End insert_validate;
975: --
976: -- ----------------------------------------------------------------------------
977: -- |---------------------------< update_validate >----------------------------|

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

981: --
982: l_proc varchar2(72) := g_package||'update_validate';
983: --
984: Begin
985: hr_utility.set_location('Entering:'||l_proc, 5);
986: --
987: -- Call all supporting business operations
988: --
989: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

1036:
1037: --
1038: chk_df(p_rec);
1039:
1040: hr_utility.set_location(' Leaving:'||l_proc, 10);
1041: End update_validate;
1042: --
1043: -- ----------------------------------------------------------------------------
1044: -- |---------------------------< delete_validate >----------------------------|

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

1047: --
1048: l_proc varchar2(72) := g_package||'delete_validate';
1049: --
1050: Begin
1051: hr_utility.set_location('Entering:'||l_proc, 5);
1052: --
1053: -- Call all supporting business operations
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1051: hr_utility.set_location('Entering:'||l_proc, 5);
1052: --
1053: -- Call all supporting business operations
1054: --
1055: hr_utility.set_location(' Leaving:'||l_proc, 10);
1056: End delete_validate;
1057: --
1058: end ota_nhs_bus;