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.HR_DEI_BUS dependencies on HR_UTILITY

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

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

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

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

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

113: l_proc varchar2(72) := g_package||'return_legislation_code';
114: --
115: Begin
116: --
117: hr_utility.set_location('Entering:'|| l_proc, 10);
118: --
119: -- Ensure that all the mandatory parameter are not null
120: --
121: hr_api.mandatory_arg_error

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

131: -- call to this function. Just return the value in the global
132: -- variable.
133: --
134: l_legislation_code := hr_dei_bus.g_legislation_code;
135: hr_utility.set_location(l_proc, 20);
136: else
137: --
138: -- The ID is different to the last call to this function
139: -- or this is the first call to this function.

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

148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --
154: -- Set the global variables so the values are
155: -- available for the next call to this function.
156: --

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

157: close csr_leg_code;
158: hr_dei_bus.g_document_extra_info_id := p_document_extra_info_id;
159: hr_dei_bus.g_legislation_code := l_legislation_code;
160: end if;
161: hr_utility.set_location(' Leaving:'|| l_proc, 40);
162: return l_legislation_code;
163: end return_legislation_code;
164: --
165: --

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

183: l_proc varchar2(72) := g_package||'return_legislation_code';
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: --
189: -- Ensure that all the mandatory parameter are not null
190: --
191: hr_api.mandatory_arg_error

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

201: -- call to this function. Just return the value in the global
202: -- variable.
203: --
204: l_legislation_code := hr_dei_bus.g_legislation_code;
205: hr_utility.set_location(l_proc, 20);
206: else
207: --
208: -- The ID is different to the last call to this function
209: -- or this is the first call to this function.

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

218: close csr_leg_code;
219: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
220: fnd_message.raise_error;
221: end if;
222: hr_utility.set_location(l_proc,30);
223: --
224: -- Set the global variables so the values are
225: -- available for the next call to this function.
226: --

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

227: close csr_leg_code;
228: hr_dei_bus.g_person_id := p_person_id;
229: hr_dei_bus.g_legislation_code := l_legislation_code;
230: end if;
231: hr_utility.set_location(' Leaving:'|| l_proc, 40);
232: return l_legislation_code;
233: end return_leg_code_perid;
234: --
235:

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

267: --
268: l_proc varchar2(72) := g_package || 'chk_ddf';
269: --
270: begin
271: hr_utility.set_location('Entering:'||l_proc,10);
272: --
273: if ((p_rec.document_extra_info_id is not null) and (
274: nvl(hr_dei_shd.g_old_rec.dei_information_category, hr_api.g_varchar2) <>
275: nvl(p_rec.dei_information_category, hr_api.g_varchar2) or

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

407: );
408:
409: end if;
410: --
411: hr_utility.set_location(' Leaving:'||l_proc,20);
412: end chk_ddf;
413: --
414: -- ----------------------------------------------------------------------------
415: -- |------------------------------< chk_df >----------------------------------|

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

445: --
446: l_proc varchar2(72) := g_package || 'chk_df';
447: --
448: begin
449: hr_utility.set_location('Entering:'||l_proc,10);
450: --
451: if ((p_rec.document_extra_info_id is not null) and (
452: nvl(hr_dei_shd.g_old_rec.dei_attribute_category, hr_api.g_varchar2) <>
453: nvl(p_rec.dei_attribute_category, hr_api.g_varchar2) or

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

584: ,p_attribute30_value => p_rec.dei_attribute30
585: );
586: end if;
587: --
588: hr_utility.set_location(' Leaving:'||l_proc,20);
589: end chk_df;
590: --
591: -- ----------------------------------------------------------------------------
592: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 671: hr_utility.set_location(l_proc, 8);

667: --
668: --Check for Non- updation of document extra info id
669: --
670: --
671: hr_utility.set_location(l_proc, 8);
672: if nvl(p_rec.document_extra_info_id, hr_api.g_number) <>
673: hr_dei_shd.g_old_rec.document_extra_info_id then
674: hr_api.argument_changed_error
675: (p_api_name => l_proc

Line 724: hr_utility.set_location('Entering:'|| l_proc, 1);

720: l_proc varchar2(72) := g_package||'chk_date_from';
721: l_api_updating boolean;
722: --
723: begin
724: hr_utility.set_location('Entering:'|| l_proc, 1);
725: --
726: -- Check mandatory parameters have been set
727: --
728: hr_api.mandatory_arg_error

Line 741: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');

737: -- record
738: --
739: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
740:
741: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');
742: hr_utility.raise_error;
743: end if;
744: --
745:

Line 742: hr_utility.raise_error;

738: --
739: if p_date_from > nvl(p_date_to, hr_api.g_eot) then
740:
741: hr_utility.set_message(801, 'HR_7303_ADD_DATE_FROM_EARLIER');
742: hr_utility.raise_error;
743: end if;
744: --
745:
746: --

Line 747: hr_utility.set_location(' Leaving:'|| l_proc, 2);

743: end if;
744: --
745:
746: --
747: hr_utility.set_location(' Leaving:'|| l_proc, 2);
748: exception
749: when app_exception.application_exception then
750: if hr_multi_message.exception_add
751: (p_associated_column1 => 'HR_DOCUMENT_EXTRA_INFO.DATE_FROM'

Line 754: hr_utility.set_location(' Leaving:'||l_proc,3);

750: if hr_multi_message.exception_add
751: (p_associated_column1 => 'HR_DOCUMENT_EXTRA_INFO.DATE_FROM'
752: ,p_associated_column2 => 'HR_DOCUMENT_EXTRA_INFO.DATE_TO'
753: ) then
754: hr_utility.set_location(' Leaving:'||l_proc,3);
755: raise;
756: end if;
757: hr_utility.set_location(' Leaving:'||l_proc,4);
758: --

Line 757: hr_utility.set_location(' Leaving:'||l_proc,4);

753: ) then
754: hr_utility.set_location(' Leaving:'||l_proc,3);
755: raise;
756: end if;
757: hr_utility.set_location(' Leaving:'||l_proc,4);
758: --
759: end chk_date_from;
760: --
761: -- ---------------------------------------------------------------------------

Line 804: hr_utility.set_location('Entering:'|| l_proc, 1);

800: l_date_to date;
801: l_api_updating boolean;
802: --
803: begin
804: hr_utility.set_location('Entering:'|| l_proc, 1);
805: --
806: -- Check mandatory parameters have been set
807: --
808: hr_api.mandatory_arg_error

Line 826: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');

822: -- same record
823: --
824: if nvl(p_date_to, hr_api.g_eot) < p_date_from then
825:
826: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
827: hr_utility.raise_error;
828: end if;
829: --
830:

Line 827: hr_utility.raise_error;

823: --
824: if nvl(p_date_to, hr_api.g_eot) < p_date_from then
825:
826: hr_utility.set_message(801, 'HR_7301_ADD_DATE_TO_LATER');
827: hr_utility.raise_error;
828: end if;
829: --
830:
831: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 831: hr_utility.set_location(' Leaving:'|| l_proc, 3);

827: hr_utility.raise_error;
828: end if;
829: --
830:
831: hr_utility.set_location(' Leaving:'|| l_proc, 3);
832: exception
833: when app_exception.application_exception then
834: if hr_multi_message.exception_add
835: (p_same_associated_columns => 'Y'

Line 837: hr_utility.set_location(' Leaving:'||l_proc,4);

833: when app_exception.application_exception then
834: if hr_multi_message.exception_add
835: (p_same_associated_columns => 'Y'
836: ) then
837: hr_utility.set_location(' Leaving:'||l_proc,4);
838: raise;
839: end if;
840: hr_utility.set_location(' Leaving:'||l_proc,5);
841: --

Line 840: hr_utility.set_location(' Leaving:'||l_proc,5);

836: ) then
837: hr_utility.set_location(' Leaving:'||l_proc,4);
838: raise;
839: end if;
840: hr_utility.set_location(' Leaving:'||l_proc,5);
841: --
842: end chk_date_to;
843: --
844: -- ----------------------------------------------------------------------------

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

891: and hrl.lookup_type = 'DOCUMENT_CATEGORY'
892: and hdt.document_type_id = p_document_type_id;
893: --
894: begin
895: hr_utility.set_location('Entering:'||l_proc, 5);
896:
897: --
898: -- Check that the Document Type Id is linked to a
899: -- valid document type id on hr_document_types

Line 909: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');

905: if csr_valid_doc_id%notfound then
906:
907: --
908: close csr_valid_doc_id;
909: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
910: hr_utility.set_message_token('OBJECT', 'DOCUMENT_TYPE_ID');
911: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_TYPES');
912: hr_utility.raise_error;
913: --

Line 910: hr_utility.set_message_token('OBJECT', 'DOCUMENT_TYPE_ID');

906:
907: --
908: close csr_valid_doc_id;
909: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
910: hr_utility.set_message_token('OBJECT', 'DOCUMENT_TYPE_ID');
911: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_TYPES');
912: hr_utility.raise_error;
913: --
914: else

Line 911: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_TYPES');

907: --
908: close csr_valid_doc_id;
909: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
910: hr_utility.set_message_token('OBJECT', 'DOCUMENT_TYPE_ID');
911: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_TYPES');
912: hr_utility.raise_error;
913: --
914: else
915: close csr_valid_doc_id;

Line 912: hr_utility.raise_error;

908: close csr_valid_doc_id;
909: hr_utility.set_message(800, 'HR_449710_DOR_INVL_VAL');
910: hr_utility.set_message_token('OBJECT', 'DOCUMENT_TYPE_ID');
911: hr_utility.set_message_token('TABLE', 'HR_DOCUMENT_TYPES');
912: hr_utility.raise_error;
913: --
914: else
915: close csr_valid_doc_id;
916:

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

914: else
915: close csr_valid_doc_id;
916:
917: end if;
918: hr_utility.set_location(l_proc, 20);
919: --
920:
921: --
922:

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

921: --
922:
923:
924:
925: hr_utility.set_location('Leaving:'||l_proc, 30);
926:
927: exception
928: when app_exception.application_exception then
929: if hr_multi_message.exception_add

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

928: when app_exception.application_exception then
929: if hr_multi_message.exception_add
930: (p_associated_column1 => 'hr_document_types.document_type_id'
931: ) then
932: hr_utility.set_location('Leaving:'||l_proc, 50);
933: raise;
934: end if;
935: hr_utility.set_location('Leaving:'||l_proc,60);
936: end chk_document_type_id;

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

931: ) then
932: hr_utility.set_location('Leaving:'||l_proc, 50);
933: raise;
934: end if;
935: hr_utility.set_location('Leaving:'||l_proc,60);
936: end chk_document_type_id;
937: --
938: -- ---------------------------------------------------------------------------
939: -- |---------------------------< chk_person_id >----------------------------|

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

981: from per_people_f ppf
982: where ppf.person_id = p_person_id;
983: --
984: begin
985: hr_utility.set_location('Entering:'|| l_proc, 10);
986: --
987: -- Check mandatory parameters have been set
988: --
989: hr_api.mandatory_arg_error

Line 1005: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');

1001: if csr_valid_pers%notfound then
1002:
1003: --
1004: close csr_valid_pers;
1005: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');
1006: hr_utility.raise_error;
1007: --
1008: else
1009: close csr_valid_pers;

Line 1006: hr_utility.raise_error;

1002:
1003: --
1004: close csr_valid_pers;
1005: hr_utility.set_message(801, 'HR_7298_ADD_PERSON_INVALID');
1006: hr_utility.raise_error;
1007: --
1008: else
1009: close csr_valid_pers;
1010: hr_utility.set_location(l_proc, 20);

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

1006: hr_utility.raise_error;
1007: --
1008: else
1009: close csr_valid_pers;
1010: hr_utility.set_location(l_proc, 20);
1011: --
1012:
1013:
1014: end if;

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

1013:
1014: end if;
1015:
1016: --
1017: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1018:
1019: exception
1020: when app_exception.application_exception then
1021: if hr_multi_message.exception_add

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

1020: when app_exception.application_exception then
1021: if hr_multi_message.exception_add
1022: (p_associated_column1 => 'HR_DOCUMENT_EXTRA_INFO.PERSON_ID'
1023: ) then
1024: hr_utility.set_location(' Leaving:'||l_proc,60);
1025: raise;
1026: end if;
1027: hr_utility.set_location(' Leaving:'||l_proc,70);
1028: end chk_person_id;

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

1023: ) then
1024: hr_utility.set_location(' Leaving:'||l_proc,60);
1025: raise;
1026: end if;
1027: hr_utility.set_location(' Leaving:'||l_proc,70);
1028: end chk_person_id;
1029: --
1030:
1031: --

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

1039: --
1040: l_proc varchar2(72) := g_package||'insert_validate';
1041: --
1042: Begin
1043: hr_utility.set_location('Entering:'||l_proc, 5);
1044: --
1045: -- Call all supporting business operations
1046: --
1047: per_per_bus.set_security_group_id(p_person_id => p_rec.person_id);

Line 1079: hr_utility.set_location(l_proc, 10);

1075: ,p_person_id => p_rec.person_id
1076: );
1077:
1078:
1079: hr_utility.set_location(l_proc, 10);
1080: --
1081: -- hr_dei_bus.chk_ddf(p_rec);
1082: --
1083: -- hr_dei_bus.chk_df(p_rec);

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

1081: -- hr_dei_bus.chk_ddf(p_rec);
1082: --
1083: -- hr_dei_bus.chk_df(p_rec);
1084: --
1085: -- hr_utility.set_location(' Leaving:'||l_proc, 10);
1086: End insert_validate;
1087: --
1088:
1089:

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

1097: --
1098: l_proc varchar2(72) := g_package||'update_validate';
1099: --
1100: Begin
1101: hr_utility.set_location('Entering:'||l_proc, 5);
1102: --
1103: -- Call all supporting business operations
1104: --
1105: per_per_bus.set_security_group_id(p_person_id => p_rec.person_id);

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

1133: -- hr_dei_bus.chk_ddf(p_rec);
1134: --
1135: -- hr_dei_bus.chk_df(p_rec);
1136: --
1137: hr_utility.set_location(' Leaving:'||l_proc, 10);
1138: End update_validate;
1139: --
1140: -- ----------------------------------------------------------------------------
1141: -- |---------------------------< delete_validate >----------------------------|

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

1146: --
1147: l_proc varchar2(72) := g_package||'delete_validate';
1148: --
1149: Begin
1150: hr_utility.set_location('Entering:'||l_proc, 5);
1151: --
1152: -- Call all supporting business operations
1153: --
1154: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1150: hr_utility.set_location('Entering:'||l_proc, 5);
1151: --
1152: -- Call all supporting business operations
1153: --
1154: hr_utility.set_location(' Leaving:'||l_proc, 10);
1155: End delete_validate;
1156: --
1157: end hr_dei_bus;