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

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error

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

72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --
76: hr_utility.set_location(' Leaving:'|| l_proc, 20);
77: --
78: end set_security_group_id;
79: --
80: -- ---------------------------------------------------------------------------

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 := per_rei_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 157: hr_utility.set_location(' Leaving:'|| l_proc, 40);

153: per_rei_bus.g_contact_extra_info_id := p_contact_extra_info_id;
154: per_rei_bus.g_legislation_code := l_legislation_code;
155: end if;
156: --
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;
159: end return_legislation_code;
160: --
161: -- ----------------------------------------------------------------------------

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

199: FROM per_contact_relationships con
200: WHERE con.contact_relationship_id = p_contact_relationship_id;
201: --
202: BEGIN
203: hr_utility.set_location('Entering:' || l_proc, 1);
204: --
205: -- Check mandatory parameters have been set
206: --
207: hr_api.mandatory_arg_error(

Line 212: hr_utility.set_location(l_proc, 2);

208: p_api_name => l_proc,
209: p_argument => 'contact_relationship_id',
210: p_argument_value => p_contact_relationship_id);
211: --
212: hr_utility.set_location(l_proc, 2);
213: --
214: -- Check that the contact_relationship_id is in the per_contact_relationships table.
215: --
216: OPEN c_valid_rel;

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

221: fnd_message.raise_error;
222: END IF;
223: CLOSE c_valid_rel;
224: --
225: hr_utility.set_location(' Leaving:' || l_proc, 3);
226: END chk_contact_relationship_id;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |-------------------------< chk_information_type >-------------------------|

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

273: where information_type = p_information_type;
274: l_rec csr_information_type%rowtype;
275: l_min_esd date;
276: begin
277: hr_utility.set_location('Entering:' || l_proc, 1);
278: --
279: -- Check mandatory parameters have been set
280: --
281: hr_api.mandatory_arg_error(

Line 325: hr_utility.trace('validation_start_date : ' || p_validation_start_date);

321: -- Check the information_type is unique on arbitrary date
322: -- when multiple_occurences_flag = 'N'.
323: --
324: if l_rec.multiple_occurences_flag = 'N' then
325: hr_utility.trace('validation_start_date : ' || p_validation_start_date);
326: hr_utility.trace('validation_end_date : ' || p_validation_end_date);
327: --
328: -- Lock parent contact_relationship_id to guarantee uniqueness.
329: -- This is to prevent other db sessions to modify the information_type

Line 326: hr_utility.trace('validation_end_date : ' || p_validation_end_date);

322: -- when multiple_occurences_flag = 'N'.
323: --
324: if l_rec.multiple_occurences_flag = 'N' then
325: hr_utility.trace('validation_start_date : ' || p_validation_start_date);
326: hr_utility.trace('validation_end_date : ' || p_validation_end_date);
327: --
328: -- Lock parent contact_relationship_id to guarantee uniqueness.
329: -- This is to prevent other db sessions to modify the information_type
330: -- with the same contact_relationship_id.

Line 351: hr_utility.trace('min_esd : ' || l_min_esd);

347: and contact_extra_info_id <> nvl(p_contact_extra_info_id, -1)
348: and effective_end_date >= p_validation_start_date
349: and effective_start_date <= p_validation_end_date;
350: --
351: hr_utility.trace('min_esd : ' || l_min_esd);
352: --
353: if l_min_esd is not null then
354: if l_min_esd <= p_validation_start_date then
355: fnd_message.set_name('PER', 'HR_MORE_THAN_1_EXTRA_INFO');

Line 361: hr_utility.trace('validation_end_date_new : ' || p_validation_end_date);

357: end if;
358: --
359: p_validation_end_date := l_min_esd - 1;
360: --
361: hr_utility.trace('validation_end_date_new : ' || p_validation_end_date);
362: end if;
363: end if;
364: end if;
365: --

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

362: end if;
363: end if;
364: end if;
365: --
366: hr_utility.set_location(' Leaving:' || l_proc, 4);
367: end chk_information_type;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |-----------------------------< chk_ddf >----------------------------------|

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

400: --
401: l_proc varchar2(72) := g_package || 'chk_ddf';
402: --
403: begin
404: hr_utility.set_location('Entering:'||l_proc,10);
405: --
406: -- Descriptive Flexfield reference field check
407: -- Reference field check is not done automatically, so must be done manually.
408: -- Note information_type is checked "not null" by chk_information_type

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

555: ,p_attribute30_value => p_rec.cei_information30
556: );
557: end if;
558: --
559: hr_utility.set_location(' Leaving:'||l_proc,20);
560: end chk_ddf;
561: --
562: -- ----------------------------------------------------------------------------
563: -- |------------------------------< chk_df >----------------------------------|

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

593: --
594: l_proc varchar2(72) := g_package || 'chk_df';
595: --
596: begin
597: hr_utility.set_location('Entering:'||l_proc,10);
598: --
599: if ((p_rec.contact_extra_info_id is not null) and (
600: nvl(per_rei_shd.g_old_rec.cei_attribute_category, hr_api.g_varchar2) <>
601: nvl(p_rec.cei_attribute_category, hr_api.g_varchar2) or

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

694: ,p_attribute20_value => p_rec.cei_attribute20
695: );
696: end if;
697: --
698: hr_utility.set_location(' Leaving:'||l_proc,20);
699: end chk_df;
700: --
701: -- ----------------------------------------------------------------------------
702: -- |-----------------------< chk_non_updateable_args >------------------------|

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

734: l_error EXCEPTION;
735: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
736: --
737: Begin
738: hr_utility.set_location('Entering:' || l_proc, 10);
739: --
740: -- Only proceed with the validation if a row exists for the current
741: -- record in the HR Schema.
742: --

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

753: --
754: -- Check if contact_relationship_id is updated.
755: -- Raise an error when contact_relationship_id is updated.
756: --
757: hr_utility.set_location(l_proc, 20);
758: IF NVL(p_rec.contact_relationship_id, hr_api.g_number) <>
759: NVL(per_rei_shd.g_old_rec.contact_relationship_id, hr_api.g_number) THEN
760: --
761: l_argument := 'contact_relationship_id';

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

764: --
765: -- Check if information_type is updated.
766: -- Raise an error when information_type is updated.
767: --
768: hr_utility.set_location(l_proc, 30);
769: IF NVL(p_rec.information_type, hr_api.g_varchar2) <>
770: NVL(per_rei_shd.g_old_rec.information_type, hr_api.g_varchar2) THEN
771: --
772: l_argument := 'information_type';

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

775: --
776: -- Check if cei_information_category is updated.
777: -- Raise an error when information_type is updated.
778: --
779: hr_utility.set_location(l_proc, 40);
780: IF NVL(p_rec.cei_information_category, hr_api.g_varchar2) <>
781: NVL(per_rei_shd.g_old_rec.cei_information_category, hr_api.g_varchar2) THEN
782: --
783: l_argument := 'cei_information_category';

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

783: l_argument := 'cei_information_category';
784: RAISE l_error;
785: END IF;
786: --
787: hr_utility.set_location(' Leaving:' || l_proc, 50);
788: EXCEPTION
789: WHEN l_error THEN
790: hr_utility.set_location(l_proc, 60);
791: --

Line 790: hr_utility.set_location(l_proc, 60);

786: --
787: hr_utility.set_location(' Leaving:' || l_proc, 50);
788: EXCEPTION
789: WHEN l_error THEN
790: hr_utility.set_location(l_proc, 60);
791: --
792: hr_api.argument_changed_error(
793: p_api_name => l_proc,
794: p_argument => l_argument);

Line 796: hr_utility.set_location(l_proc, 70);

792: hr_api.argument_changed_error(
793: p_api_name => l_proc,
794: p_argument => l_argument);
795: WHEN OTHERS THEN
796: hr_utility.set_location(l_proc, 70);
797: --
798: RAISE;
799: End chk_non_updateable_args;
800: --

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

986: --
987: l_proc varchar2(72) := g_package||'insert_validate';
988: --
989: Begin
990: hr_utility.set_location('Entering:'||l_proc, 5);
991: --
992: -- Call all supporting business operations
993: --
994: --

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

1015: --
1016: -- Skip descriptive flexfield validation when the API is called from form.
1017: --
1018: IF per_rei_shd.g_called_from_form = FALSE THEN
1019: hr_utility.set_location(l_proc, 10);
1020: --
1021: -- Bug.2770089
1022: -- Support dynamic profile option "PER_CONTACT_RELATIONSHIP_ID"
1023: -- which is available in df value set.

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

1035: --
1036: per_rei_bus.chk_df(p_rec);
1037: END IF;
1038: -- =
1039: hr_utility.set_location(' Leaving:'||l_proc, 10);
1040: End insert_validate;
1041: --
1042: -- ----------------------------------------------------------------------------
1043: -- |---------------------------< update_validate >----------------------------|

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

1052: --
1053: l_proc varchar2(72) := g_package||'update_validate';
1054: --
1055: Begin
1056: hr_utility.set_location('Entering:'||l_proc, 5);
1057: --
1058: -- Call all supporting business operations
1059: --
1060: --

Line 1084: hr_utility.set_location(l_proc, 7);

1080: --
1081: -- Skip descriptive flexfield validation when the API is called from form.
1082: --
1083: IF per_rei_shd.g_called_from_form = FALSE THEN
1084: hr_utility.set_location(l_proc, 7);
1085: --
1086: -- Bug.2770089
1087: -- Support dynamic profile option "PER_CONTACT_RELATIONSHIP_ID"
1088: -- which is available in df value set.

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

1100: --
1101: per_rei_bus.chk_df(p_rec);
1102: END IF;
1103: --
1104: hr_utility.set_location(' Leaving:'||l_proc, 10);
1105: End update_validate;
1106: --
1107: -- ----------------------------------------------------------------------------
1108: -- |---------------------------< delete_validate >----------------------------|

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

1117: --
1118: l_proc varchar2(72) := g_package||'delete_validate';
1119: --
1120: Begin
1121: hr_utility.set_location('Entering:'||l_proc, 5);
1122: --
1123: -- Call all supporting business operations
1124: --
1125: dt_delete_validate

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

1140: p_contact_extra_info_id => p_rec.contact_extra_info_id,
1141: p_validation_start_date => p_validation_start_date,
1142: p_validation_end_date => p_validation_end_date);
1143: --
1144: hr_utility.set_location(' Leaving:'||l_proc, 10);
1145: End delete_validate;
1146: --
1147: end per_rei_bus;