DBA Data[Home] [Help]

APPS.IRC_CMP_BUS dependencies on HR_UTILITY

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

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

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

85: --
86: hr_api.set_legislation_context(l_legislation_code);
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --
91: end set_security_group_id;
92: --
93: -- ---------------------------------------------------------------------------

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

120: l_proc varchar2(72) := g_package||'return_legislation_code';
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'|| l_proc, 10);
125: --
126: -- Ensure that all the mandatory parameter are not null
127: --
128: hr_api.mandatory_arg_error

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

138: -- call to this function. Just return the value in the global
139: -- variable.
140: --
141: l_legislation_code := irc_cmp_bus.g_legislation_code;
142: hr_utility.set_location(l_proc, 20);
143: else
144: --
145: -- The ID is different to the last call to this function
146: -- or this is the first call to this function.

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

155: close csr_leg_code;
156: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
157: fnd_message.raise_error;
158: end if;
159: hr_utility.set_location(l_proc,30);
160: --
161: -- Set the global variables so the values are
162: -- available for the next call to this function.
163: --

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

164: close csr_leg_code;
165: irc_cmp_bus.g_communication_property_id := p_communication_property_id;
166: irc_cmp_bus.g_legislation_code := l_legislation_code;
167: end if;
168: hr_utility.set_location(' Leaving:'|| l_proc, 40);
169: return l_legislation_code;
170: end return_legislation_code;
171: --
172: -- ----------------------------------------------------------------------------

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

203: --
204: l_proc varchar2(72) := g_package || 'chk_ddf';
205: --
206: begin
207: hr_utility.set_location('Entering:'||l_proc,10);
208: --
209: if ((p_rec.communication_property_id is not null) and (
210: nvl(irc_cmp_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
211: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

262: ,p_attribute10_value => p_rec.information10
263: );
264: end if;
265: --
266: hr_utility.set_location(' Leaving:'||l_proc,20);
267: end chk_ddf;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |------------------------------< chk_df >----------------------------------|

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

300: --
301: l_proc varchar2(72) := g_package || 'chk_df';
302: --
303: begin
304: hr_utility.set_location('Entering:'||l_proc,10);
305: --
306: if ((p_rec.communication_property_id is not null) and (
307: nvl(irc_cmp_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
308: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

359: ,p_attribute10_value => p_rec.attribute10
360: );
361: end if;
362: --
363: hr_utility.set_location(' Leaving:'||l_proc,20);
364: end chk_df;
365: --
366: -- ----------------------------------------------------------------------------
367: -- |-----------------------< chk_non_updateable_args >------------------------|

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

472: l_proc varchar2(72) := g_package||'chk_default_comm_status';
473: l_api_updating boolean;
474: --
475: begin
476: hr_utility.set_location('Entering: '|| l_proc, 10);
477: l_api_updating := irc_cmp_shd.api_updating
478: (p_communication_property_id => p_communication_property_id,
479: p_object_version_number => p_object_version_number);
480: --

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

491: then
492: --
493: -- raise error as does not exist as lookup
494: --
495: hr_utility.set_location('Leaving: '|| l_proc, 20);
496: fnd_message.set_name('PER','IRC_412408_INVALID_COMM_STATUS');
497: fnd_message.raise_error;
498: end if;
499: end if;

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

496: fnd_message.set_name('PER','IRC_412408_INVALID_COMM_STATUS');
497: fnd_message.raise_error;
498: end if;
499: end if;
500: hr_utility.set_location('Leaving: '|| l_proc, 30);
501: end chk_default_comm_status;
502: --
503: -- ---------------------------------------------------------------------------
504: -- |----------------------------< chk_allow_attachment_flag >------------------|

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

536: l_proc varchar2(72) := g_package||'chk_allow_attachment_flag';
537: l_api_updating boolean;
538: --
539: begin
540: hr_utility.set_location('Entering: '|| l_proc, 10);
541: l_api_updating := irc_cmp_shd.api_updating
542: (p_communication_property_id => p_communication_property_id,
543: p_object_version_number => p_object_version_number);
544: --

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

555: then
556: --
557: -- raise error as does not exist as lookup
558: --
559: hr_utility.set_location('Leaving: '|| l_proc, 20);
560: fnd_message.set_name('PER','IRC_412409_INVALID_ATTACHMENT_FLAG');
561: fnd_message.raise_error;
562: end if;
563: end if;

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

560: fnd_message.set_name('PER','IRC_412409_INVALID_ATTACHMENT_FLAG');
561: fnd_message.raise_error;
562: end if;
563: end if;
564: hr_utility.set_location('Leaving: '|| l_proc, 30);
565: end chk_allow_attachment_flag;
566: --
567: -- ---------------------------------------------------------------------------
568: -- |----------------------------< chk_allow_add_recipients >-----------------|

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

600: l_proc varchar2(72) := g_package||'chk_allow_add_recipients';
601: l_api_updating boolean;
602: --
603: begin
604: hr_utility.set_location('Entering: '|| l_proc, 10);
605: l_api_updating := irc_cmp_shd.api_updating
606: (p_communication_property_id => p_communication_property_id,
607: p_object_version_number => p_object_version_number);
608: --

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

619: then
620: --
621: -- raise error as does not exist as lookup
622: --
623: hr_utility.set_location('Leaving: '|| l_proc, 20);
624: fnd_message.set_name('PER','IRC_412410_INVALID_ALLOW_ADD_RECIPIENT');
625: fnd_message.raise_error;
626: end if;
627: end if;

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

624: fnd_message.set_name('PER','IRC_412410_INVALID_ALLOW_ADD_RECIPIENT');
625: fnd_message.raise_error;
626: end if;
627: end if;
628: hr_utility.set_location('Leaving: '|| l_proc, 30);
629: end chk_allow_add_recipients;
630: --
631: -- ---------------------------------------------------------------------------
632: -- |----------------------------< chk_auto_notification_flag >--------------|

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

664: l_proc varchar2(72) := g_package||'chk_auto_notification_flag';
665: l_api_updating boolean;
666: --
667: begin
668: hr_utility.set_location('Entering: '|| l_proc, 10);
669: l_api_updating := irc_cmp_shd.api_updating
670: (p_communication_property_id => p_communication_property_id,
671: p_object_version_number => p_object_version_number);
672: --

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

683: then
684: --
685: -- raise error as does not exist as lookup
686: --
687: hr_utility.set_location('Leaving: '|| l_proc, 20);
688: fnd_message.set_name('PER','IRC_412411_INVALID_NOTIFICATION_FLAG');
689: fnd_message.raise_error;
690: end if;
691: end if;

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

688: fnd_message.set_name('PER','IRC_412411_INVALID_NOTIFICATION_FLAG');
689: fnd_message.raise_error;
690: end if;
691: end if;
692: hr_utility.set_location('Leaving: '|| l_proc, 30);
693: end chk_auto_notification_flag;
694: --
695: -- ---------------------------------------------------------------------------
696: -- |----------------------------< chk_default_moderator >-----------------|

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

728: l_proc varchar2(72) := g_package||'chk_default_moderator';
729: l_api_updating boolean;
730: --
731: begin
732: hr_utility.set_location('Entering: '|| l_proc, 10);
733: l_api_updating := irc_cmp_shd.api_updating
734: (p_communication_property_id => p_communication_property_id,
735: p_object_version_number => p_object_version_number);
736: --

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

747: then
748: --
749: -- raise error as does not exist as lookup
750: --
751: hr_utility.set_location('Leaving: '|| l_proc, 20);
752: fnd_message.set_name('PER','IRC_412412_INVALID_DEFAULT_MODERATOR');
753: fnd_message.raise_error;
754: end if;
755: end if;

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

752: fnd_message.set_name('PER','IRC_412412_INVALID_DEFAULT_MODERATOR');
753: fnd_message.raise_error;
754: end if;
755: end if;
756: hr_utility.set_location('Leaving: '|| l_proc, 30);
757: end chk_default_moderator;
758: --
759: -- ----------------------------------------------------------------------------
760: -- |-----------------------------< chk_object_id >-----------------------------|

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

802: where icp.object_id = p_object_id
803: and icp.object_type = p_object_type;
804: --
805: begin
806: hr_utility.set_location('Entering:'||l_proc,10);
807: -- Check that object_id is not null.
808: hr_api.mandatory_arg_error
809: (p_api_name => l_proc
810: ,p_argument => 'OBJECT_ID'

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

810: ,p_argument => 'OBJECT_ID'
811: ,p_argument_value => p_object_id
812: );
813: -- Check that object_id exists in per_all_vacancies
814: hr_utility.set_location(l_proc,20);
815: open csr_object_id;
816: fetch csr_object_id into l_object_id;
817: hr_utility.set_location(l_proc,30);
818: if csr_object_id%NOTFOUND then

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

813: -- Check that object_id exists in per_all_vacancies
814: hr_utility.set_location(l_proc,20);
815: open csr_object_id;
816: fetch csr_object_id into l_object_id;
817: hr_utility.set_location(l_proc,30);
818: if csr_object_id%NOTFOUND then
819: close csr_object_id;
820: fnd_message.set_name('PER','IRC_412413_BAD_OBJECT_ID');
821: fnd_message.raise_error;

Line 828: hr_utility.set_location(l_proc,40);

824:
825: -- Check that combination of (object_id,object_type) is unique.
826: open csr_object_type;
827: fetch csr_object_type into l_object_type;
828: hr_utility.set_location(l_proc,40);
829: if csr_object_type%FOUND then
830: close csr_object_type;
831: fnd_message.set_name('PER','IRC_412414_OBJID_OBJTYP_NOT_UNQ');
832: fnd_message.raise_error;

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

832: fnd_message.raise_error;
833: end if;
834: close csr_object_type;
835:
836: hr_utility.set_location(' Leaving:'||l_proc,50);
837: exception
838: when app_exception.application_exception then
839: if hr_multi_message.exception_add
840: (p_associated_column1 =>

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

839: if hr_multi_message.exception_add
840: (p_associated_column1 =>
841: 'IRC_COMM_PROPERTIES.OBJECT_ID'
842: ) then
843: hr_utility.set_location(' Leaving:'||l_proc,60);
844: raise;
845: end if;
846: hr_utility.set_location(' Leaving:'||l_proc,70);
847: end chk_object_id;

Line 846: hr_utility.set_location(' Leaving:'||l_proc,70);

842: ) then
843: hr_utility.set_location(' Leaving:'||l_proc,60);
844: raise;
845: end if;
846: hr_utility.set_location(' Leaving:'||l_proc,70);
847: end chk_object_id;
848: --
849: -- ----------------------------------------------------------------------------
850: -- |-----------------------------< chk_object_type >-----------------------------|

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

876: --
877: l_proc varchar2(72) := g_package || 'chk_object_type';
878: --
879: begin
880: hr_utility.set_location('Entering:'||l_proc,10);
881: -- Check that object_type is not null.
882: hr_api.mandatory_arg_error
883: (p_api_name => l_proc
884: ,p_argument => 'OBJECT_TYPE'

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

888: if p_object_type <> 'VACANCY' then
889: fnd_message.set_name('PER','IRC_412415_BAD_OBJECT_TYPE');
890: fnd_message.raise_error;
891: end if;
892: hr_utility.set_location(' Leaving:'||l_proc,20);
893: exception
894: when app_exception.application_exception then
895: if hr_multi_message.exception_add
896: (p_associated_column1 =>

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

895: if hr_multi_message.exception_add
896: (p_associated_column1 =>
897: 'IRC_COMM_PROPERTIES.OBJECT_TYPE'
898: ) then
899: hr_utility.set_location(' Leaving:'||l_proc,30);
900: raise;
901: end if;
902: hr_utility.set_location(' Leaving:'||l_proc,40);
903: end chk_object_type;

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

898: ) then
899: hr_utility.set_location(' Leaving:'||l_proc,30);
900: raise;
901: end if;
902: hr_utility.set_location(' Leaving:'||l_proc,40);
903: end chk_object_type;
904: --
905: -- ----------------------------------------------------------------------------
906: -- |---------------------------< insert_update_validate >----------------------|

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

965: --
966: l_proc varchar2(72) := g_package||'insert_validate';
967: --
968: Begin
969: hr_utility.set_location('Entering:'||l_proc, 5);
970: --
971: -- Call all supporting business operations
972: --
973: --

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

988: irc_cmp_bus.insert_update_validate(p_effective_date, p_rec);
989: irc_cmp_bus.chk_object_type(p_rec.object_type);
990: irc_cmp_bus.chk_object_id(p_rec.object_id,p_rec.object_type);
991: --
992: hr_utility.set_location(' Leaving:'||l_proc, 10);
993: End insert_validate;
994: --
995: -- ----------------------------------------------------------------------------
996: -- |---------------------------< update_validate >----------------------------|

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

1002: --
1003: l_proc varchar2(72) := g_package||'update_validate';
1004: --
1005: Begin
1006: hr_utility.set_location('Entering:'||l_proc, 5);
1007: --
1008: -- Call all supporting business operations
1009: --
1010: --

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

1028: -- irc_cmp_bus.chk_df(p_rec);
1029: --
1030: irc_cmp_bus.insert_update_validate(p_effective_date, p_rec);
1031:
1032: hr_utility.set_location(' Leaving:'||l_proc, 10);
1033: End update_validate;
1034: --
1035: -- ----------------------------------------------------------------------------
1036: -- |---------------------------< delete_validate >----------------------------|

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

1041: --
1042: l_proc varchar2(72) := g_package||'delete_validate';
1043: --
1044: Begin
1045: hr_utility.set_location('Entering:'||l_proc, 5);
1046: --
1047: -- Call all supporting business operations
1048: --
1049: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1045: hr_utility.set_location('Entering:'||l_proc, 5);
1046: --
1047: -- Call all supporting business operations
1048: --
1049: hr_utility.set_location(' Leaving:'||l_proc, 10);
1050: End delete_validate;
1051: --
1052: end irc_cmp_bus;